{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Plantons","Lijnmannen","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Plantons","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Rangschikking"]
[]
["Pers. Nr.",null,"Dienst"]
[5638,null,{"$f":"IF(ISNUMBER(VLOOKUP(A4,gegevens,5,)),VLOOKUP(A4,gegevens,5,),IF(LEN(VLOOKUP(A4,gegevens,7,))>0,VLOOKUP(A4,gegevens,7,),\"TC\"))","v":"WV"}]
[5857,null,{"$f":"IF(ISNUMBER(VLOOKUP(A5,gegevens,5,)),VLOOKUP(A5,gegevens,5,),IF(LEN(VLOOKUP(A5,gegevens,7,))>0,VLOOKUP(A5,gegevens,7,),\"TC\"))","v":"T"}]
[7355,null,{"$f":"IF(ISNUMBER(VLOOKUP(A6,gegevens,5,)),VLOOKUP(A6,gegevens,5,),IF(LEN(VLOOKUP(A6,gegevens,7,))>0,VLOOKUP(A6,gegevens,7,),\"TC\"))","v":"X"}]
[7384,null,{"$f":"IF(ISNUMBER(VLOOKUP(A7,gegevens,5,)),VLOOKUP(A7,gegevens,5,),IF(LEN(VLOOKUP(A7,gegevens,7,))>0,VLOOKUP(A7,gegevens,7,),\"TC\"))","v":"WV"}]
[7426,null,{"$f":"IF(ISNUMBER(VLOOKUP(A8,gegevens,5,)),VLOOKUP(A8,gegevens,5,),IF(LEN(VLOOKUP(A8,gegevens,7,))>0,VLOOKUP(A8,gegevens,7,),\"TC\"))","v":190}]

{"sheet":"Lijnmannen","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Rangschikking"]
[]
["Pers. Nr."]
[2278,null,{"$f":"IF(VLOOKUP(A4,Data!#REF!,9,)=0,IF(VLOOKUP(A4,Data!#REF!,10,)=0,\"TC\",VLOOKUP(A4,Data!#REF!,10,)),VLOOKUP(A4,Data!#REF!,9,))","v":{"$error":"#REF!"}}]
[4709,null,{"$f":"IF(VLOOKUP(A5,Data!#REF!,9,)=0,IF(VLOOKUP(A5,Data!#REF!,10,)=0,\"TC\",VLOOKUP(A5,Data!#REF!,10,)),VLOOKUP(A5,Data!#REF!,9,))","v":{"$error":"#REF!"}}]
[9748,null,{"$f":"IF(VLOOKUP(A6,Data!#REF!,9,)=0,IF(VLOOKUP(A6,Data!#REF!,10,)=0,\"TC\",VLOOKUP(A6,Data!#REF!,10,)),VLOOKUP(A6,Data!#REF!,9,))","v":{"$error":"#REF!"}}]
[7384,null,{"$f":"IF(VLOOKUP(A7,Data!#REF!,9,)=0,IF(VLOOKUP(A7,Data!#REF!,10,)=0,\"TC\",VLOOKUP(A7,Data!#REF!,10,)),VLOOKUP(A7,Data!#REF!,9,))","v":{"$error":"#REF!"}}]
[5601,null,{"$f":"IF(VLOOKUP(A8,Data!#REF!,9,)=0,IF(VLOOKUP(A8,Data!#REF!,10,)=0,\"TC\",VLOOKUP(A8,Data!#REF!,10,)),VLOOKUP(A8,Data!#REF!,9,))","v":{"$error":"#REF!"}}]

{"sheet":"Data","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["         ","                   User: XXXXX","             ","      ","    ","   ","    ","XX:XX  1","2014-08-05",")  Blz. "]
["*--------","----------------*  *----------","--*"]
["Lijst XXX","XXX   Regio: X   Stelplaats: 1","   Datum:  6-",-2014]
["*--------","--*   *------*   *------------","   *---------","----*"]
["Personeel","Naam                          ","Kwalificaties","Dienst","Volg","Var","Rust","Aanvangs","Begin","Aankomst"]
["nummer   ","                              ","             ","      ","Nr. ","   ","afwz","Plaats  ","uur  ","Plaats"]
["*--------","*----------------------------*","*-----------*","*----*","*--*","*-*","*--*","*------*","*---*","*------*"]
[2278,"XXXXXXXXXXXXXXX               ","L H G C B A  "," XX00 ",96,"   ","    ","XXX111  "," 7:00","XXX111"]
[2314,"XXXXXXXXXXXXX                 ","G C A        "," XX00 ",56,"   ","    ","XXX111  ","12:56:00","XXX111"]
[2460,"XXXXXXXXXXXXXX                ","L H G C B A  ","      ","    ","   ","X"]
[5601,"XXXXXXXXXXXXX                 ","L H G C A    ","      ","    ","   ","OG"]
[5638,"XXXXXXXXXXXXX                 ","P G C A      ","      ","    ","   ","WV"]
[5857,"XXXXXXXXXXXXX                 ","P G C A      ","      ","    ","   ","T"]
[7355,"XXXXXXXXXXXXX                 ","P H G C A    ","      ","    ","   ","X"]
[7384,"XXXXXXXXXXXXX                 ","P L H G C A  ","      ","    ","   ","WV"]
[7426,"XXXXXXXXXXXXX                 ","P H G C A    "," XX00 ",190,"   ","    ","XXX111  ","23:00:00","XXX111"]