{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Uren","Jaar overzicht"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":0,"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":"Uren","index":0,"n_rows":13,"n_cols":28,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,23,3,26],[2,3,2,6],[2,7,2,10],[2,11,2,14],[2,15,2,18],[2,19,2,22],[2,23,2,26],[3,3,3,6],[3,7,3,10],[3,11,3,14],[3,15,3,18],[3,19,3,22]]}
[]
["week","Jaar","Gewerkte uren"]
[17,2023,null,"Ma",null,null,null,"Di",null,null,null,"Wo",null,null,null,"Do",null,null,null,"Vr",null,null,null,"Za",null,null,null,"Totaal Week"]
["Naam",null,null,{"$f":"DATE(B3,1,1)+(A3-IF(WEEKDAY(DATE(B3,1,1),2)<5,1,0))*7-WEEKDAY(DATE(B3,1,1),2)+1","v":"2023-04-24"},null,null,null,{"$f":"D4+1","v":"2023-04-25"},null,null,null,{"$f":"H4+1","v":"2023-04-26"},null,null,null,{"$f":"L4+1","v":"2023-04-27"},null,null,null,{"$f":"P4+1","v":"2023-04-28"},null,null,null,{"$f":"T4+1","v":"2023-04-29"}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A3","v":17}]
[" ",null,null,"van","tot","pauze","totaal","van","tot","pauze","totaal","van","tot","pauze","totaal","van","tot","pauze","totaal","van","tot","pauze","totaal","van","tot","pauze","totaal"]
["klaasens","Piet","-",6,12,0.5,{"$f":"IF(E7=\"\",\"0\",E7-D7-F7)","v":5.5},6,null,null,{"$f":"IF(I7=\"\",\"0\",I7-H7-J7)","v":"0"},null,null,null,{"$f":"IF(M7=\"\",\"0\",M7-L7-N7)","v":"0"},null,null,null,{"$f":"IF(Q7=\"\",\"0\",Q7-P7-R7)","v":"0"},null,null,null,{"$f":"IF(U7=\"\",\"0\",U7-T7-V7)","v":"0"},null,null,null,{"$f":"IF(Y7=\"\",\"0\",Y7-X7-Z7)","v":"0"},{"$f":"IF(E7=\"\",\"\",G7+K7+O7+S7+W7+AA7)","v":5.5}]
["Groot",{"$f":"IF(A8=0,\" \",VLOOKUP(A8,[1]Personeel!$B$4:$D$51,3,0))","v":"Inge"},{"$f":"IF(A8=0,\" \",VLOOKUP(A8,[1]Personeel!$B$4:$D$51,2,0))","v":"de"},null,null,null,{"$f":"IF(E8=\"\",\"0\",E8-D8-F8)","v":"0"},null,null,null,{"$f":"IF(I8=\"\",\"0\",I8-H8-J8)","v":"0"},null,null,null,{"$f":"IF(M8=\"\",\"0\",M8-L8-N8)","v":"0"},null,null,null,{"$f":"IF(Q8=\"\",\"0\",Q8-P8-R8)","v":"0"},null,null,null,{"$f":"IF(U8=\"\",\"0\",U8-T8-V8)","v":"0"},null,null,null,{"$f":"IF(Y8=\"\",\"0\",Y8-X8-Z8)","v":"0"},{"$f":"IF(E8=\"\",\"\",G8+K8+O8+S8+W8+AA8)","v":""}]
["Vaak",{"$f":"IF(A9=0,\" \",VLOOKUP(A9,[1]Personeel!$B$4:$D$51,3,0))","v":"Klaas"},{"$f":"IF(A9=0,\" \",VLOOKUP(A9,[1]Personeel!$B$4:$D$51,2,0))","v":"-"},null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",""]
["Goede","Anna","de",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",""]
[null,{"$f":"IF(A11=0,\" \",VLOOKUP(A11,[1]Personeel!$B$4:$D$51,3,0))","v":" "},{"$f":"IF(A11=0,\" \",VLOOKUP(A11,[1]Personeel!$B$4:$D$51,2,0))","v":" "},null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",""]
[null,{"$f":"IF(A12=0,\" \",VLOOKUP(A12,[1]Personeel!$B$4:$D$51,3,0))","v":" "},{"$f":"IF(A12=0,\" \",VLOOKUP(A12,[1]Personeel!$B$4:$D$51,2,0))","v":" "},null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",""]
[null,{"$f":"IF(A13=0,\" \",VLOOKUP(A13,[1]Personeel!$B$4:$D$51,3,0))","v":" "},{"$f":"IF(A13=0,\" \",VLOOKUP(A13,[1]Personeel!$B$4:$D$51,2,0))","v":" "},null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",null,null,null,"0",""]

{"sheet":"Jaar overzicht","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}