{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Voorblad","Invoer","MndOvz"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  Urenregistratie"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2015, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Invoer","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Urenverantwoording"]
[]
["Datum","Dag","Begin1","Eind1","Begin2","Eind2","UrenMin","Uren","Bijzonderheden"]
["2015-04-01",{"$f":"A4","v":"2015-04-01"},"08:10:00","17:15:00",null,null,{"$f":"IF(D4=\"\",0,D4-C4)+IF(F4=\"\",0,F4-E4)","v":"09:05:00"},{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.0833333333333339}]
[{"$f":"+A4+1","v":"2015-04-02"},"2015-04-02","08:05:00","12:30:00","13:00:00","17:20:00","08:45:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.75}]
[{"$f":"+A5+1","v":"2015-04-03"},"2015-04-03","08:10:00","12:30:00","13:05:00","17:35:00","08:50:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.8333333333333321}]
["2015-04-04","2015-04-04",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-05","2015-04-05",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-06","2015-04-06","08:15:00","12:40:00","13:20:00","17:35:00","08:40:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.6666666666666643},"Project2"]
["2015-04-07","2015-04-07","08:05:00","17:05:00",null,null,"09:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.9999999999999964},"Project2"]
["2015-04-08","2015-04-08","08:10:00","12:35:00","13:20:00","17:10:00","08:15:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.2500000000000018},"Project2"]
["2015-04-09","2015-04-09","08:10:00","12:30:00","13:15:00","17:00:00","08:05:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.0833333333333357}]
["2015-04-10","2015-04-10","08:10:00","12:30:00","13:10:00","17:50:00","09:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.0000000000000018},"1 uur Project2"]
["2015-04-11","2015-04-11",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-12","2015-04-12",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-13","2015-04-13","08:05:00","17:45:00",null,null,"09:40:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.6666666666666679}]
["2015-04-14","2015-04-14","08:05:00","16:50:00",null,null,"08:45:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.7499999999999982}]
["2015-04-15","2015-04-15","08:00:00","12:35:00","13:15:00","17:20:00","08:40:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.6666666666666661}]
["2015-04-16","2015-04-16","08:10:00","12:45:00","13:30:00","17:30:00","08:35:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.5833333333333339}]
["2015-04-17","2015-04-17","08:05:00","17:05:00",null,null,"09:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.9999999999999964}]
["2015-04-18","2015-04-18",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-19","2015-04-19",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-20","2015-04-20","08:15:00","12:15:00","13:00:00","17:15:00","08:15:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.25}]
["2015-04-21","2015-04-21","08:05:00","12:30:00","13:00:00","17:20:00","08:45:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.75}]
["2015-04-22","2015-04-22","08:00:00","17:35:00",null,null,"09:35:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.5833333333333321}]
["2015-04-23","2015-04-23","08:10:00","12:40:00","13:10:00","17:50:00","09:10:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.1666666666666679}]
["2015-04-24","2015-04-24",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-25","2015-04-25",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-26","2015-04-26",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-04-27","2015-04-27",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0},"Koningsdag"]
["2015-04-28","2015-04-28","08:05:00","12:30:00","13:00:00","17:20:00","08:45:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.75}]
["2015-04-29","2015-04-29","08:15:00","12:15:00","13:00:00","17:15:00","08:15:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.25}]
["2015-04-30","2015-04-30","08:10:00","12:45:00","13:15:00","17:45:00","09:05:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.0833333333333339}]
["2015-05-01","2015-05-01",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0},"lang weekend"]
["2015-05-02","2015-05-02",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-03","2015-05-03",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-04","2015-05-04",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0},"lang weekend"]
["2015-05-05","2015-05-05",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0},"bevrijdingsdag"]
["2015-05-06","2015-05-06","08:10:00","12:40:00","13:00:00","17:35:00","09:05:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.0833333333333339}]
["2015-05-07","2015-05-07","08:05:00","12:30:00","13:00:00","17:20:00","08:45:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":8.75}]
["2015-05-08","2015-05-08","08:00:00","17:35:00",null,null,"09:35:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":9.5833333333333321}]
["2015-05-09","2015-05-09",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-10","2015-05-10",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-11","2015-05-11",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-12","2015-05-12",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-13","2015-05-13",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]
["2015-05-14","2015-05-14",null,null,null,null,"00:00:00",{"$f":"Uren[[#This Row],[UrenMin]]*24","v":0}]

{"sheet":"MndOvz","index":2,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[41,1,41,6],[1,1,1,9],[2,1,2,9],[3,3,3,9],[4,3,4,9],[5,3,5,9],[8,7,8,8]]}
[]
[null,"Maandelijkse urenrapportage"]
[]
[null,"Naam:",null,"Gijs Verbruggen"]
[null,"Maand:",null,"2015-04-01"]
[null,"Klant:",null,"G-Info"]
[]
[]
[null,"Dag",null,"Van1","Tot1","Van2","Tot2","Gewerkte uren",null,"Bijzonderheden"]
[null,null,null,3,4,5,6,7,8,9]
[null,1,{"$f":"$D$5+B11-1","v":"2015-04-01"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),E$10),\"\")","v":"17:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),H$10),\"\")","v":"09:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),I$10),\"\")","v":9.0833333333333339},{"$f":"IFERROR(INDEX(Uren[],MATCH($C11,Uren[Datum],0),J$10),\"\")","v":0}]
[null,2,{"$f":"IF(MONTH($D$5+B12-1)=MONTH($D$5),$D$5+B12-1,\"\")","v":"2015-04-02"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),F$10),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),G$10),\"\")","v":"17:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),H$10),\"\")","v":"08:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),I$10),\"\")","v":8.75},{"$f":"IFERROR(INDEX(Uren[],MATCH($C12,Uren[Datum],0),J$10),\"\")","v":0}]
[null,3,"2015-04-03",{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),F$10),\"\")","v":"13:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),G$10),\"\")","v":"17:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),H$10),\"\")","v":"08:50:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),I$10),\"\")","v":8.8333333333333321},{"$f":"IFERROR(INDEX(Uren[],MATCH($C13,Uren[Datum],0),J$10),\"\")","v":0}]
[null,4,"2015-04-04",{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C14,Uren[Datum],0),J$10),\"\")","v":0}]
[null,5,"2015-04-05",{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C15,Uren[Datum],0),J$10),\"\")","v":0}]
[null,6,"2015-04-06",{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),D$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),E$10),\"\")","v":"12:40:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),F$10),\"\")","v":"13:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),G$10),\"\")","v":"17:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),H$10),\"\")","v":"08:40:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),I$10),\"\")","v":8.6666666666666643},{"$f":"IFERROR(INDEX(Uren[],MATCH($C16,Uren[Datum],0),J$10),\"\")","v":"Project2"}]
[null,7,"2015-04-07",{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),E$10),\"\")","v":"17:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),H$10),\"\")","v":"09:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),I$10),\"\")","v":8.9999999999999964},{"$f":"IFERROR(INDEX(Uren[],MATCH($C17,Uren[Datum],0),J$10),\"\")","v":"Project2"}]
[null,8,"2015-04-08",{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),E$10),\"\")","v":"12:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),F$10),\"\")","v":"13:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),G$10),\"\")","v":"17:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),H$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),I$10),\"\")","v":8.2500000000000018},{"$f":"IFERROR(INDEX(Uren[],MATCH($C18,Uren[Datum],0),J$10),\"\")","v":"Project2"}]
[null,9,"2015-04-09",{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),F$10),\"\")","v":"13:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),G$10),\"\")","v":"17:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),H$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),I$10),\"\")","v":8.0833333333333357},{"$f":"IFERROR(INDEX(Uren[],MATCH($C19,Uren[Datum],0),J$10),\"\")","v":0}]
[null,10,"2015-04-10",{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),F$10),\"\")","v":"13:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),G$10),\"\")","v":"17:50:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),H$10),\"\")","v":"09:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),I$10),\"\")","v":9.0000000000000018},{"$f":"IFERROR(INDEX(Uren[],MATCH($C20,Uren[Datum],0),J$10),\"\")","v":"1 uur Project2"}]
[null,11,"2015-04-11",{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C21,Uren[Datum],0),J$10),\"\")","v":0}]
[null,12,"2015-04-12",{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C22,Uren[Datum],0),J$10),\"\")","v":0}]
[null,13,"2015-04-13",{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),E$10),\"\")","v":"17:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),H$10),\"\")","v":"09:40:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),I$10),\"\")","v":9.6666666666666679},{"$f":"IFERROR(INDEX(Uren[],MATCH($C23,Uren[Datum],0),J$10),\"\")","v":0}]
[null,14,"2015-04-14",{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),E$10),\"\")","v":"16:50:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),H$10),\"\")","v":"08:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),I$10),\"\")","v":8.7499999999999982},{"$f":"IFERROR(INDEX(Uren[],MATCH($C24,Uren[Datum],0),J$10),\"\")","v":0}]
[null,15,"2015-04-15",{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),D$10),\"\")","v":"08:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),E$10),\"\")","v":"12:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),F$10),\"\")","v":"13:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),G$10),\"\")","v":"17:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),H$10),\"\")","v":"08:40:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),I$10),\"\")","v":8.6666666666666661},{"$f":"IFERROR(INDEX(Uren[],MATCH($C25,Uren[Datum],0),J$10),\"\")","v":0}]
[null,16,"2015-04-16",{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),E$10),\"\")","v":"12:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),F$10),\"\")","v":"13:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),G$10),\"\")","v":"17:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),H$10),\"\")","v":"08:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),I$10),\"\")","v":8.5833333333333339},{"$f":"IFERROR(INDEX(Uren[],MATCH($C26,Uren[Datum],0),J$10),\"\")","v":0}]
[null,17,"2015-04-17",{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),E$10),\"\")","v":"17:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),H$10),\"\")","v":"09:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),I$10),\"\")","v":8.9999999999999964},{"$f":"IFERROR(INDEX(Uren[],MATCH($C27,Uren[Datum],0),J$10),\"\")","v":0}]
[null,18,"2015-04-18",{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C28,Uren[Datum],0),J$10),\"\")","v":0}]
[null,19,"2015-04-19",{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C29,Uren[Datum],0),J$10),\"\")","v":0}]
[null,20,"2015-04-20",{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),D$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),E$10),\"\")","v":"12:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),F$10),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),G$10),\"\")","v":"17:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),H$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),I$10),\"\")","v":8.25},{"$f":"IFERROR(INDEX(Uren[],MATCH($C30,Uren[Datum],0),J$10),\"\")","v":0}]
[null,21,"2015-04-21",{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),F$10),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),G$10),\"\")","v":"17:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),H$10),\"\")","v":"08:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),I$10),\"\")","v":8.75},{"$f":"IFERROR(INDEX(Uren[],MATCH($C31,Uren[Datum],0),J$10),\"\")","v":0}]
[null,22,"2015-04-22",{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),D$10),\"\")","v":"08:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),E$10),\"\")","v":"17:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),H$10),\"\")","v":"09:35:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),I$10),\"\")","v":9.5833333333333321},{"$f":"IFERROR(INDEX(Uren[],MATCH($C32,Uren[Datum],0),J$10),\"\")","v":0}]
[null,23,"2015-04-23",{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),E$10),\"\")","v":"12:40:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),F$10),\"\")","v":"13:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),G$10),\"\")","v":"17:50:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),H$10),\"\")","v":"09:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),I$10),\"\")","v":9.1666666666666679},{"$f":"IFERROR(INDEX(Uren[],MATCH($C33,Uren[Datum],0),J$10),\"\")","v":0}]
[null,24,"2015-04-24",{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C34,Uren[Datum],0),J$10),\"\")","v":0}]
[null,25,"2015-04-25",{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C35,Uren[Datum],0),J$10),\"\")","v":0}]
[null,26,"2015-04-26",{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C36,Uren[Datum],0),J$10),\"\")","v":0}]
[null,27,"2015-04-27",{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),D$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),E$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),F$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),G$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),H$10),\"\")","v":"00:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),I$10),\"\")","v":0},{"$f":"IFERROR(INDEX(Uren[],MATCH($C37,Uren[Datum],0),J$10),\"\")","v":"Koningsdag"}]
[null,28,{"$f":"IF(MONTH($D$5+B38-1)=MONTH($D$5),$D$5+B38-1,\"\")","v":"2015-04-28"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),D$10),\"\")","v":"08:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),E$10),\"\")","v":"12:30:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),F$10),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),G$10),\"\")","v":"17:20:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),H$10),\"\")","v":"08:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),I$10),\"\")","v":8.75},{"$f":"IFERROR(INDEX(Uren[],MATCH($C38,Uren[Datum],0),J$10),\"\")","v":0}]
[null,29,{"$f":"IF(MONTH($D$5+B39-1)=MONTH($D$5),$D$5+B39-1,\"\")","v":"2015-04-29"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),D$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),E$10),\"\")","v":"12:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),F$10),\"\")","v":"13:00:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),G$10),\"\")","v":"17:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),H$10),\"\")","v":"08:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),I$10),\"\")","v":8.25},{"$f":"IFERROR(INDEX(Uren[],MATCH($C39,Uren[Datum],0),J$10),\"\")","v":0}]
[null,30,{"$f":"IF(MONTH($D$5+B40-1)=MONTH($D$5),$D$5+B40-1,\"\")","v":"2015-04-30"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),D$10),\"\")","v":"08:10:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),E$10),\"\")","v":"12:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),F$10),\"\")","v":"13:15:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),G$10),\"\")","v":"17:45:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),H$10),\"\")","v":"09:05:00"},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),I$10),\"\")","v":9.0833333333333339},{"$f":"IFERROR(INDEX(Uren[],MATCH($C40,Uren[Datum],0),J$10),\"\")","v":0}]
[null,31,{"$f":"IF(MONTH($D$5+B41-1)=MONTH($D$5),$D$5+B41-1,\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),D$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),E$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),F$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),G$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),H$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),I$10),\"\")","v":""},{"$f":"IFERROR(INDEX(Uren[],MATCH($C41,Uren[Datum],0),J$10),\"\")","v":""}]
[null,"Totaal:  ",null,null,null,null,null,{"$f":"SUM(H11:H41)","v":7.3402777777777777},{"$f":"SUM(I11:I41)","v":176.16666666666669}]
[]
[]
[null,"Handtekening medewerker",null,null,null,"Handtekening opdrachtgever"]
[null,null,null,null,null,"Naam in blokletters"]