{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Planning en Output","1","2","Planning en Output (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":9,"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":"Planning en Output","index":0,"n_rows":395,"n_cols":7,"rows_kept":395,"cut":false,"hidden":false,"merged":[[20,7,20,15],[22,7,22,15],[24,7,24,15],[25,7,25,15],[26,7,26,15]]}
[5,null,"Invullen"]
["Week","Gepland","Output","Achterstand","Aantal blokken niet geclipt"]
[1,29500,{"$f":"SUMIF($C$58:$C$321,A3,$F$58:$F$321)","v":27300},{"$f":"B3-C3","v":2200},{"$f":"IFERROR(COUNTIF(INDIRECT(A3&\"!$G$5:$G$8\"),0)+COUNTIF(INDIRECT(A3&\"!$i$5:$i$8\"),0)+COUNTIF(INDIRECT(A3&\"!$k$5:$k$8\"),0)+COUNTIF(INDIRECT(A3&\"!$m$5:$m$8\"),0)+COUNTIF(INDIRECT(A3&\"!$o$5:$o$8\"),0),\"-\")","v":6}]
[2,31500,{"$f":"SUMIF($C$58:$C$321,A4,$F$58:$F$321)","v":29750},1750,{"$f":"IFERROR(COUNTIF(INDIRECT(A4&\"!$G$5:$G$8\"),0)+COUNTIF(INDIRECT(A4&\"!$i$5:$i$8\"),0)+COUNTIF(INDIRECT(A4&\"!$k$5:$k$8\"),0)+COUNTIF(INDIRECT(A4&\"!$m$5:$m$8\"),0)+COUNTIF(INDIRECT(A4&\"!$o$5:$o$8\"),0),\"-\")","v":4}]
[{"$f":"A4+1","v":3},null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[4,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[5,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[6,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[7,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[8,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[9,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[10,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[11,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[12,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[13,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[14,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[15,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[16,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[17,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[18,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[19,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[20,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[21,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[22,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[23,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[24,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[25,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[26,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[27,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[28,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[29,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[30,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[31,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[32,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[33,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[34,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[35,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[36,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[37,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[38,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[39,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[40,null,{"$error":"#REF!"},{"$f":"B42-C42","v":{"$error":"#REF!"}},"-"]
[{"$f":"A42+1","v":41},null,{"$error":"#REF!"},{"$f":"B43-C43","v":{"$error":"#REF!"}},"-"]
[{"$f":"A43+1","v":42},null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[43,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[44,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[45,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[46,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[47,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[48,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[49,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[50,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[51,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[52,null,{"$error":"#REF!"},{"$error":"#REF!"},"-"]
[]
[]
["Datum","Dag","Week","Gepland per week","Gepland","Output","Achterstand"]
["2019-12-30","Maandag",1,{"$f":"VLOOKUP(C58,$A$3:$B$54,2,FALSE)","v":29500},{"$f":"D58/$A$1","v":5900},{"$f":"SUM(INDIRECT(C58&\"!$G$5:$G$8\"))","v":4900},{"$f":"E58-F58","v":1000}]
[{"$f":"A58+1","v":"2019-12-31"},"Dinsdag",1,29500,5900,{"$f":"SUM(INDIRECT(C59&\"!$i$5:$i$8\"))","v":7175},-1275]
[{"$f":"A59+1","v":"2020-01-01"},"Woensdag",{"$f":"WEEKNUM(A60,2)","v":1},29500,5900,{"$f":"SUM(INDIRECT(C60&\"!$k$5:$k$8\"))","v":6125},-225]
["2020-01-02","Donderdag",1,29500,5900,{"$f":"SUM(INDIRECT(C61&\"!$m$5:$m$8\"))","v":6475},-575]
["2020-01-03","Vrijdag",1,29500,5900,{"$f":"SUM(INDIRECT(C62&\"!$o$5:$o$8\"))","v":2625},3275]
[{"$f":"A62+3","v":"2020-01-06"},{"$f":"B58","v":"Maandag"},2,31500,6300,{"$f":"SUM(INDIRECT(C63&\"!$G$5:$G$8\"))","v":6125},175]
[{"$f":"A63+1","v":"2020-01-07"},{"$f":"B59","v":"Dinsdag"},2,31500,6300,{"$f":"SUM(INDIRECT(C64&\"!$i$5:$i$8\"))","v":7000},{"$f":"E64-F64","v":-700}]
[{"$f":"A64+1","v":"2020-01-08"},{"$f":"B60","v":"Woensdag"},2,31500,6300,{"$f":"SUM(INDIRECT(C65&\"!$k$5:$k$8\"))","v":5600},{"$f":"IF(E65=0,0,IF(F65=0,G64,G64+E65-F65))","v":0}]
["2020-01-09",{"$f":"B61","v":"Donderdag"},2,31500,6300,{"$f":"SUM(INDIRECT(C66&\"!$m$5:$m$8\"))","v":5950},{"$f":"IF(E66=0,0,IF(F66=0,G65,G65+E66-F66))","v":350}]
["2020-01-10",{"$f":"B62","v":"Vrijdag"},2,31500,6300,{"$f":"SUM(INDIRECT(C67&\"!$o$5:$o$8\"))","v":5075},1575]
[{"$f":"A67+3","v":"2020-01-13"},{"$f":"B63","v":"Maandag"},3,0,0,{"$f":"SUM(INDIRECT(C68&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A68+1","v":"2020-01-14"},"Dinsdag",3,0,0,{"$f":"SUM(INDIRECT(C69&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-15","Woensdag",3,0,0,{"$f":"SUM(INDIRECT(C70&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-16","Donderdag",3,0,0,{"$f":"SUM(INDIRECT(C71&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-17","Vrijdag",3,0,0,{"$f":"SUM(INDIRECT(C72&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A72+3","v":"2020-01-20"},"Maandag",4,0,0,{"$f":"SUM(INDIRECT(C73&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A73+1","v":"2020-01-21"},"Dinsdag",4,0,0,{"$f":"SUM(INDIRECT(C74&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-22","Woensdag",4,0,0,{"$f":"SUM(INDIRECT(C75&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-23","Donderdag",4,0,0,{"$f":"SUM(INDIRECT(C76&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-24","Vrijdag",4,0,0,{"$f":"SUM(INDIRECT(C77&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A77+3","v":"2020-01-27"},"Maandag",5,0,0,{"$f":"SUM(INDIRECT(C78&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A78+1","v":"2020-01-28"},"Dinsdag",5,0,0,{"$f":"SUM(INDIRECT(C79&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-29","Woensdag",5,0,0,{"$f":"SUM(INDIRECT(C80&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-30","Donderdag",5,0,0,{"$f":"SUM(INDIRECT(C81&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-01-31","Vrijdag",5,0,0,{"$f":"SUM(INDIRECT(C82&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A82+3","v":"2020-02-03"},"Maandag",6,0,0,{"$f":"SUM(INDIRECT(C83&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A83+1","v":"2020-02-04"},"Dinsdag",6,0,0,{"$f":"SUM(INDIRECT(C84&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-05","Woensdag",6,0,0,{"$f":"SUM(INDIRECT(C85&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-06","Donderdag",6,0,0,{"$f":"SUM(INDIRECT(C86&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-07","Vrijdag",6,0,0,{"$f":"SUM(INDIRECT(C87&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A87+3","v":"2020-02-10"},"Maandag",7,0,0,{"$f":"SUM(INDIRECT(C88&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A88+1","v":"2020-02-11"},"Dinsdag",7,0,0,{"$f":"SUM(INDIRECT(C89&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-12","Woensdag",7,0,0,{"$f":"SUM(INDIRECT(C90&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-13","Donderdag",7,0,0,{"$f":"SUM(INDIRECT(C91&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-14","Vrijdag",7,0,0,{"$f":"SUM(INDIRECT(C92&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A92+3","v":"2020-02-17"},"Maandag",8,0,0,{"$f":"SUM(INDIRECT(C93&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A93+1","v":"2020-02-18"},"Dinsdag",8,0,0,{"$f":"SUM(INDIRECT(C94&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-19","Woensdag",8,0,0,{"$f":"SUM(INDIRECT(C95&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-20","Donderdag",8,0,0,{"$f":"SUM(INDIRECT(C96&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-21","Vrijdag",8,0,0,{"$f":"SUM(INDIRECT(C97&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A97+3","v":"2020-02-24"},"Maandag",9,0,0,{"$f":"SUM(INDIRECT(C98&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A98+1","v":"2020-02-25"},"Dinsdag",9,0,0,{"$f":"SUM(INDIRECT(C99&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-26","Woensdag",9,0,0,{"$f":"SUM(INDIRECT(C100&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-27","Donderdag",9,0,0,{"$f":"SUM(INDIRECT(C101&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-02-28","Vrijdag",9,0,0,{"$f":"SUM(INDIRECT(C102&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A102+3","v":"2020-03-02"},"Maandag",10,0,0,{"$f":"SUM(INDIRECT(C103&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A103+1","v":"2020-03-03"},"Dinsdag",10,0,0,{"$f":"SUM(INDIRECT(C104&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-04","Woensdag",10,0,0,{"$f":"SUM(INDIRECT(C105&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-05","Donderdag",10,0,0,{"$f":"SUM(INDIRECT(C106&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-06","Vrijdag",10,0,0,{"$f":"SUM(INDIRECT(C107&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A107+3","v":"2020-03-09"},"Maandag",11,0,0,{"$f":"SUM(INDIRECT(C108&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A108+1","v":"2020-03-10"},"Dinsdag",11,0,0,{"$f":"SUM(INDIRECT(C109&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-11","Woensdag",11,0,0,{"$f":"SUM(INDIRECT(C110&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-12","Donderdag",11,0,0,{"$f":"SUM(INDIRECT(C111&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-13","Vrijdag",11,0,0,{"$f":"SUM(INDIRECT(C112&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A112+3","v":"2020-03-16"},"Maandag",12,0,0,{"$f":"SUM(INDIRECT(C113&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A113+1","v":"2020-03-17"},"Dinsdag",12,0,0,{"$f":"SUM(INDIRECT(C114&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-18","Woensdag",12,0,0,{"$f":"SUM(INDIRECT(C115&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-19","Donderdag",12,0,0,{"$f":"SUM(INDIRECT(C116&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-20","Vrijdag",12,0,0,{"$f":"SUM(INDIRECT(C117&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A117+3","v":"2020-03-23"},"Maandag",13,0,0,{"$f":"SUM(INDIRECT(C118&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A118+1","v":"2020-03-24"},"Dinsdag",13,0,0,{"$f":"SUM(INDIRECT(C119&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-25","Woensdag",13,0,0,{"$f":"SUM(INDIRECT(C120&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-26","Donderdag",13,0,0,{"$f":"SUM(INDIRECT(C121&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-03-27","Vrijdag",13,{"$f":"VLOOKUP(C122,$A$3:$B$54,2,FALSE)","v":0},{"$f":"D122/$A$1","v":0},{"$f":"SUM(INDIRECT(C122&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A122+3","v":"2020-03-30"},"Maandag",14,0,0,{"$f":"SUM(INDIRECT(C123&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A123+1","v":"2020-03-31"},"Dinsdag",{"$f":"WEEKNUM(A124,2)","v":14},0,0,{"$f":"SUM(INDIRECT(C124&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-01","Woensdag",14,0,0,{"$f":"SUM(INDIRECT(C125&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-02","Donderdag",14,0,0,{"$f":"SUM(INDIRECT(C126&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-03","Vrijdag",14,0,0,{"$f":"SUM(INDIRECT(C127&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A127+3","v":"2020-04-06"},"Maandag",15,0,0,{"$f":"SUM(INDIRECT(C128&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A128+1","v":"2020-04-07"},"Dinsdag",15,0,0,{"$f":"SUM(INDIRECT(C129&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-08","Woensdag",15,0,0,{"$f":"SUM(INDIRECT(C130&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},{"$f":"IF(E130=0,0,IF(F130=0,G129,G129+E130-F130))","v":0}]
["2020-04-09","Donderdag",15,0,0,{"$f":"SUM(INDIRECT(C131&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-10",{"$f":"B127","v":"Vrijdag"},15,0,0,{"$f":"SUM(INDIRECT(C132&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A132+3","v":"2020-04-13"},"Maandag",16,0,0,{"$f":"SUM(INDIRECT(C133&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A133+1","v":"2020-04-14"},"Dinsdag",16,0,0,{"$f":"SUM(INDIRECT(C134&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-15","Woensdag",16,0,0,{"$f":"SUM(INDIRECT(C135&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-16","Donderdag",16,0,0,{"$f":"SUM(INDIRECT(C136&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-17","Vrijdag",16,0,0,{"$f":"SUM(INDIRECT(C137&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-20","Maandag",17,0,0,{"$f":"SUM(INDIRECT(C138&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-21","Dinsdag",17,0,0,{"$f":"SUM(INDIRECT(C139&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-22","Woensdag",17,0,0,{"$f":"SUM(INDIRECT(C140&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-23","Donderdag",17,0,0,{"$f":"SUM(INDIRECT(C141&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-24","Vrijdag",17,0,0,{"$f":"SUM(INDIRECT(C142&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-27","Maandag",18,0,0,{"$f":"SUM(INDIRECT(C143&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-28","Dinsdag",18,0,0,{"$f":"SUM(INDIRECT(C144&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-29","Woensdag",18,0,0,{"$f":"SUM(INDIRECT(C145&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-04-30","Donderdag",18,0,0,{"$f":"SUM(INDIRECT(C146&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-01","Vrijdag",18,0,0,{"$f":"SUM(INDIRECT(C147&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-04","Maandag",19,0,0,{"$f":"SUM(INDIRECT(C148&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-05","Dinsdag",19,0,0,{"$f":"SUM(INDIRECT(C149&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-06","Woensdag",19,0,0,{"$f":"SUM(INDIRECT(C150&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-07","Donderdag",19,0,0,{"$f":"SUM(INDIRECT(C151&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-08","Vrijdag",19,0,0,{"$f":"SUM(INDIRECT(C152&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-11","Maandag",20,0,0,{"$f":"SUM(INDIRECT(C153&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-12","Dinsdag",20,0,0,{"$f":"SUM(INDIRECT(C154&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-13","Woensdag",20,0,0,{"$f":"SUM(INDIRECT(C155&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-14","Donderdag",20,0,0,{"$f":"SUM(INDIRECT(C156&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-15","Vrijdag",20,0,0,{"$f":"SUM(INDIRECT(C157&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-18","Maandag",21,0,0,{"$f":"SUM(INDIRECT(C158&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-19","Dinsdag",21,0,0,{"$f":"SUM(INDIRECT(C159&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-20","Woensdag",21,0,0,{"$f":"SUM(INDIRECT(C160&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-21","Donderdag",21,0,0,{"$f":"SUM(INDIRECT(C161&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-22","Vrijdag",21,0,0,{"$f":"SUM(INDIRECT(C162&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-25","Maandag",22,0,0,{"$f":"SUM(INDIRECT(C163&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-26","Dinsdag",22,0,0,{"$f":"SUM(INDIRECT(C164&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-27","Woensdag",22,0,0,{"$f":"SUM(INDIRECT(C165&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-28","Donderdag",22,0,0,{"$f":"SUM(INDIRECT(C166&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-05-29","Vrijdag",22,0,0,{"$f":"SUM(INDIRECT(C167&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-01","Maandag",23,0,0,{"$f":"SUM(INDIRECT(C168&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-02","Dinsdag",23,0,0,{"$f":"SUM(INDIRECT(C169&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-03","Woensdag",23,0,0,{"$f":"SUM(INDIRECT(C170&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-04","Donderdag",23,0,0,{"$f":"SUM(INDIRECT(C171&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-05","Vrijdag",23,0,0,{"$f":"SUM(INDIRECT(C172&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-08","Maandag",24,0,0,{"$f":"SUM(INDIRECT(C173&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-09","Dinsdag",24,0,0,{"$f":"SUM(INDIRECT(C174&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-10","Woensdag",24,0,0,{"$f":"SUM(INDIRECT(C175&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-11","Donderdag",24,0,0,{"$f":"SUM(INDIRECT(C176&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-12","Vrijdag",24,0,0,{"$f":"SUM(INDIRECT(C177&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-15","Maandag",25,0,0,{"$f":"SUM(INDIRECT(C178&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-16","Dinsdag",25,0,0,{"$f":"SUM(INDIRECT(C179&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-17","Woensdag",25,0,0,{"$f":"SUM(INDIRECT(C180&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-18","Donderdag",25,0,0,{"$f":"SUM(INDIRECT(C181&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-19","Vrijdag",25,0,0,{"$f":"SUM(INDIRECT(C182&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-22","Maandag",26,0,0,{"$f":"SUM(INDIRECT(C183&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-23","Dinsdag",26,0,0,{"$f":"SUM(INDIRECT(C184&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-24","Woensdag",26,0,0,{"$f":"SUM(INDIRECT(C185&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-25","Donderdag",26,{"$f":"VLOOKUP(C186,$A$3:$B$54,2,FALSE)","v":0},{"$f":"D186/$A$1","v":0},{"$f":"SUM(INDIRECT(C186&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-26","Vrijdag",26,0,0,{"$f":"SUM(INDIRECT(C187&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-29","Maandag",{"$f":"WEEKNUM(A188,2)","v":27},0,0,{"$f":"SUM(INDIRECT(C188&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-06-30","Dinsdag",27,0,0,{"$f":"SUM(INDIRECT(C189&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-01","Woensdag",27,0,0,{"$f":"SUM(INDIRECT(C190&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-02","Donderdag",27,0,0,{"$f":"SUM(INDIRECT(C191&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-03","Vrijdag",27,0,0,{"$f":"SUM(INDIRECT(C192&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-06","Maandag",28,0,0,{"$f":"SUM(INDIRECT(C193&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-07","Dinsdag",28,0,0,{"$f":"SUM(INDIRECT(C194&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},{"$f":"IF(E194=0,0,IF(F194=0,G193,G193+E194-F194))","v":0}]
["2020-07-08","Woensdag",28,0,0,{"$f":"SUM(INDIRECT(C195&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-09",{"$f":"B191","v":"Donderdag"},28,0,0,{"$f":"SUM(INDIRECT(C196&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-10","Vrijdag",28,0,0,{"$f":"SUM(INDIRECT(C197&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A197+3","v":"2020-07-13"},"Maandag",29,0,0,{"$f":"SUM(INDIRECT(C198&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A198+1","v":"2020-07-14"},"Dinsdag",29,0,0,{"$f":"SUM(INDIRECT(C199&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-15","Woensdag",29,0,0,{"$f":"SUM(INDIRECT(C200&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-16","Donderdag",29,0,0,{"$f":"SUM(INDIRECT(C201&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-17","Vrijdag",29,0,0,{"$f":"SUM(INDIRECT(C202&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-20","Maandag",30,0,0,{"$f":"SUM(INDIRECT(C203&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-21","Dinsdag",30,0,0,{"$f":"SUM(INDIRECT(C204&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-22","Woensdag",30,0,0,{"$f":"SUM(INDIRECT(C205&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-23","Donderdag",30,0,0,{"$f":"SUM(INDIRECT(C206&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-24","Vrijdag",30,0,0,{"$f":"SUM(INDIRECT(C207&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-27","Maandag",31,0,0,{"$f":"SUM(INDIRECT(C208&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-28","Dinsdag",31,0,0,{"$f":"SUM(INDIRECT(C209&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-29","Woensdag",31,0,0,{"$f":"SUM(INDIRECT(C210&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-30","Donderdag",31,0,0,{"$f":"SUM(INDIRECT(C211&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-07-31","Vrijdag",31,0,0,{"$f":"SUM(INDIRECT(C212&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-03","Maandag",32,0,0,{"$f":"SUM(INDIRECT(C213&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-04","Dinsdag",32,0,0,{"$f":"SUM(INDIRECT(C214&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-05","Woensdag",32,0,0,{"$f":"SUM(INDIRECT(C215&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-06","Donderdag",32,0,0,{"$f":"SUM(INDIRECT(C216&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-07","Vrijdag",32,0,0,{"$f":"SUM(INDIRECT(C217&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-10","Maandag",33,0,0,{"$f":"SUM(INDIRECT(C218&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-11","Dinsdag",33,0,0,{"$f":"SUM(INDIRECT(C219&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-12","Woensdag",33,0,0,{"$f":"SUM(INDIRECT(C220&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-13","Donderdag",33,0,0,{"$f":"SUM(INDIRECT(C221&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-14","Vrijdag",33,0,0,{"$f":"SUM(INDIRECT(C222&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-17","Maandag",34,0,0,{"$f":"SUM(INDIRECT(C223&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-18","Dinsdag",34,0,0,{"$f":"SUM(INDIRECT(C224&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-19","Woensdag",34,0,0,{"$f":"SUM(INDIRECT(C225&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-20","Donderdag",34,0,0,{"$f":"SUM(INDIRECT(C226&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-21","Vrijdag",34,0,0,{"$f":"SUM(INDIRECT(C227&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-24","Maandag",35,0,0,{"$f":"SUM(INDIRECT(C228&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-25","Dinsdag",35,0,0,{"$f":"SUM(INDIRECT(C229&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-26","Woensdag",35,0,0,{"$f":"SUM(INDIRECT(C230&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-27","Donderdag",35,0,0,{"$f":"SUM(INDIRECT(C231&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-28","Vrijdag",35,0,0,{"$f":"SUM(INDIRECT(C232&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-08-31","Maandag",36,0,0,{"$f":"SUM(INDIRECT(C233&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-01","Dinsdag",36,0,0,{"$f":"SUM(INDIRECT(C234&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-02","Woensdag",36,0,0,{"$f":"SUM(INDIRECT(C235&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-03","Donderdag",36,0,0,{"$f":"SUM(INDIRECT(C236&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-04","Vrijdag",36,0,0,{"$f":"SUM(INDIRECT(C237&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-07","Maandag",37,0,0,{"$f":"SUM(INDIRECT(C238&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-08","Dinsdag",37,0,0,{"$f":"SUM(INDIRECT(C239&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-09","Woensdag",37,0,0,{"$f":"SUM(INDIRECT(C240&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-10","Donderdag",37,0,0,{"$f":"SUM(INDIRECT(C241&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-11","Vrijdag",37,0,0,{"$f":"SUM(INDIRECT(C242&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-14","Maandag",38,0,0,{"$f":"SUM(INDIRECT(C243&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-15","Dinsdag",38,0,0,{"$f":"SUM(INDIRECT(C244&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-16","Woensdag",38,0,0,{"$f":"SUM(INDIRECT(C245&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-17","Donderdag",38,0,0,{"$f":"SUM(INDIRECT(C246&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-18","Vrijdag",38,0,0,{"$f":"SUM(INDIRECT(C247&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-21","Maandag",39,0,0,{"$f":"SUM(INDIRECT(C248&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-22","Dinsdag",39,0,0,{"$f":"SUM(INDIRECT(C249&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-23","Woensdag",39,{"$f":"VLOOKUP(C250,$A$3:$B$54,2,FALSE)","v":0},{"$f":"D250/$A$1","v":0},{"$f":"SUM(INDIRECT(C250&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-24","Donderdag",39,0,0,{"$f":"SUM(INDIRECT(C251&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-25","Vrijdag",{"$f":"WEEKNUM(A252,2)","v":39},0,0,{"$f":"SUM(INDIRECT(C252&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-28","Maandag",40,0,0,{"$f":"SUM(INDIRECT(C253&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-29","Dinsdag",40,0,0,{"$f":"SUM(INDIRECT(C254&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-09-30","Woensdag",40,0,0,{"$f":"SUM(INDIRECT(C255&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-01","Donderdag",40,0,0,{"$f":"SUM(INDIRECT(C256&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-02","Vrijdag",40,0,0,{"$f":"SUM(INDIRECT(C257&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-05","Maandag",41,0,0,{"$f":"SUM(INDIRECT(C258&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},{"$f":"IF(E258=0,0,IF(F258=0,G257,G257+E258-F258))","v":0}]
["2020-10-06","Dinsdag",41,0,0,{"$f":"SUM(INDIRECT(C259&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-07",{"$f":"B255","v":"Woensdag"},41,0,0,{"$f":"SUM(INDIRECT(C260&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-08","Donderdag",41,0,0,{"$f":"SUM(INDIRECT(C261&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-09","Vrijdag",41,0,0,{"$f":"SUM(INDIRECT(C262&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A262+3","v":"2020-10-12"},"Maandag",42,0,0,{"$f":"SUM(INDIRECT(C263&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
[{"$f":"A263+1","v":"2020-10-13"},"Dinsdag",42,0,0,{"$f":"SUM(INDIRECT(C264&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-14","Woensdag",42,0,0,{"$f":"SUM(INDIRECT(C265&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-15","Donderdag",42,0,0,{"$f":"SUM(INDIRECT(C266&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-16","Vrijdag",42,0,0,{"$f":"SUM(INDIRECT(C267&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-19","Maandag",43,0,0,{"$f":"SUM(INDIRECT(C268&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-20","Dinsdag",43,0,0,{"$f":"SUM(INDIRECT(C269&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-21","Woensdag",43,0,0,{"$f":"SUM(INDIRECT(C270&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-22","Donderdag",43,0,0,{"$f":"SUM(INDIRECT(C271&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-23","Vrijdag",43,0,0,{"$f":"SUM(INDIRECT(C272&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-26","Maandag",44,0,0,{"$f":"SUM(INDIRECT(C273&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-27","Dinsdag",44,0,0,{"$f":"SUM(INDIRECT(C274&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-28","Woensdag",44,0,0,{"$f":"SUM(INDIRECT(C275&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-29","Donderdag",44,0,0,{"$f":"SUM(INDIRECT(C276&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-10-30","Vrijdag",44,0,0,{"$f":"SUM(INDIRECT(C277&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-02","Maandag",45,0,0,{"$f":"SUM(INDIRECT(C278&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-03","Dinsdag",45,0,0,{"$f":"SUM(INDIRECT(C279&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-04","Woensdag",45,0,0,{"$f":"SUM(INDIRECT(C280&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-05","Donderdag",45,0,0,{"$f":"SUM(INDIRECT(C281&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-06","Vrijdag",45,0,0,{"$f":"SUM(INDIRECT(C282&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-09","Maandag",46,0,0,{"$f":"SUM(INDIRECT(C283&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-10","Dinsdag",46,0,0,{"$f":"SUM(INDIRECT(C284&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-11","Woensdag",46,0,0,{"$f":"SUM(INDIRECT(C285&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-12","Donderdag",46,0,0,{"$f":"SUM(INDIRECT(C286&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-13","Vrijdag",46,0,0,{"$f":"SUM(INDIRECT(C287&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-16","Maandag",47,0,0,{"$f":"SUM(INDIRECT(C288&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-17","Dinsdag",47,0,0,{"$f":"SUM(INDIRECT(C289&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-18","Woensdag",47,0,0,{"$f":"SUM(INDIRECT(C290&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-19","Donderdag",47,0,0,{"$f":"SUM(INDIRECT(C291&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-20","Vrijdag",47,0,0,{"$f":"SUM(INDIRECT(C292&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-23","Maandag",48,0,0,{"$f":"SUM(INDIRECT(C293&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-24","Dinsdag",48,0,0,{"$f":"SUM(INDIRECT(C294&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-25","Woensdag",48,0,0,{"$f":"SUM(INDIRECT(C295&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-26","Donderdag",48,0,0,{"$f":"SUM(INDIRECT(C296&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-27","Vrijdag",48,0,0,{"$f":"SUM(INDIRECT(C297&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-11-30","Maandag",49,0,0,{"$f":"SUM(INDIRECT(C298&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-01","Dinsdag",49,0,0,{"$f":"SUM(INDIRECT(C299&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-02","Woensdag",49,0,0,{"$f":"SUM(INDIRECT(C300&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-03","Donderdag",49,0,0,{"$f":"SUM(INDIRECT(C301&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-04","Vrijdag",49,0,0,{"$f":"SUM(INDIRECT(C302&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-07","Maandag",50,0,0,{"$f":"SUM(INDIRECT(C303&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-08","Dinsdag",50,0,0,{"$f":"SUM(INDIRECT(C304&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-09","Woensdag",50,0,0,{"$f":"SUM(INDIRECT(C305&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-10","Donderdag",50,0,0,{"$f":"SUM(INDIRECT(C306&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-11","Vrijdag",50,0,0,{"$f":"SUM(INDIRECT(C307&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-14","Maandag",51,0,0,{"$f":"SUM(INDIRECT(C308&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-15","Dinsdag",51,0,0,{"$f":"SUM(INDIRECT(C309&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-16","Woensdag",51,0,0,{"$f":"SUM(INDIRECT(C310&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-17","Donderdag",51,0,0,{"$f":"SUM(INDIRECT(C311&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-18","Vrijdag",51,0,0,{"$f":"SUM(INDIRECT(C312&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-21","Maandag",52,0,0,{"$f":"SUM(INDIRECT(C313&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-22","Dinsdag",52,{"$f":"VLOOKUP(C314,$A$3:$B$54,2,FALSE)","v":0},{"$f":"D314/$A$1","v":0},{"$f":"SUM(INDIRECT(C314&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-23","Woensdag",52,0,0,{"$f":"SUM(INDIRECT(C315&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-24","Donderdag",{"$f":"WEEKNUM(A316,2)","v":52},0,0,{"$f":"SUM(INDIRECT(C316&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}},0]
["2020-12-25","Vrijdag",52,0,0,{"$f":"SUM(INDIRECT(C317&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C318&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C319&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C320&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C321&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C322&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C323&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C324&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C325&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C326&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C327&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C328&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C329&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C330&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C331&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C332&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C333&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C334&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C335&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C336&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C337&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C338&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C339&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C340&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C341&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C342&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C343&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C344&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C345&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C346&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C347&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C348&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C349&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C350&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C351&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C352&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C353&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C354&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C355&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C356&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C357&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C358&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C359&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C360&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C361&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C362&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C363&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C364&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C365&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C366&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C367&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C368&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C369&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C370&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C371&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C372&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C373&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C374&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C375&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C376&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C377&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C378&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C379&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C380&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C381&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C382&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C383&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C384&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C385&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C386&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C387&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C388&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C389&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C390&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C391&\"!$m$5:$m$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C392&\"!$o$5:$o$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C393&\"!$G$5:$G$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C394&\"!$i$5:$i$8\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"SUM(INDIRECT(C395&\"!$k$5:$k$8\"))","v":{"$error":"#REF!"}}]

{"sheet":"1","index":1,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,11,3,12],[3,13,3,14],[1,1,2,1],[1,2,2,2],[1,3,2,4],[1,5,1,8],[1,10,1,13],[2,5,2,8],[2,10,2,13],[8,5,8,6],[3,1,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[12,13,12,14],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[9,13,9,14],[12,1,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[16,13,18,14],[13,1,15,4],[13,5,15,6],[13,7,15,8],[13,9,15,10],[13,11,15,12],[13,13,15,14],[16,1,18,4],[16,5,18,6],[16,7,18,8],[16,9,18,10],[16,11,18,12],[22,13,24,14],[19,1,21,4],[19,5,21,6],[19,7,21,8],[19,9,21,10],[19,11,21,12],[19,13,21,14],[22,1,24,4],[22,5,24,6],[22,7,24,8],[22,9,24,10],[22,11,24,12]]}
[]
[null,"Year/week",2020,1,null,"Aantal Blocks",null,null,null,{"$f":"SUM(F11:O11)","v":14}]
[null,null,null,null,null,"Total week output",null,null,null,{"$f":"SUM(F9:O9)","v":27300},"Target output/day",null,null,null,10000]
[null,"Output",null,null,null,{"$f":"DATEVALUE(\"01-01-\"&$C$2)+D2*7-(10-1)","v":"2019-12-30"},null,{"$f":"WORKDAY.INTL(F4,1)","v":"2019-12-31"},null,{"$f":"WORKDAY.INTL(F4,2)","v":"2020-01-01"},null,{"$f":"WORKDAY.INTL(F4,3)","v":"2020-01-02"},null,{"$f":"WORKDAY.INTL(F4,4)","v":"2020-01-03"}]
[null,"Output block 1",null,null,null,null,{"$f":"F5*(35*5)","v":0},6,{"$f":"H5*(35*5)","v":1050},12,{"$f":"J5*(35*5)","v":2100},5,{"$f":"L5*(35*5)","v":875},null,{"$f":"N5*(35*5)","v":0}]
[null,"Output block 2",null,null,null,21,{"$f":"F6*(35*5)","v":3675},22,3850,null,{"$f":"J6*(35*5)","v":0},12,{"$f":"L6*(35*5)","v":2100},null,{"$f":"N6*(35*5)","v":0}]
[null,"Output block 3",null,null,null,7,1225,9,1575,8,1400,8,1400,15,2625]
[null,"Output block 4",null,null,null,null,0,4,700,15,2625,12,2100,null,0]
[null,"Daily Output",null,null,null,{"$f":"SUM(G5:G8)","v":4900},null,{"$f":"SUM(I5:I8)","v":7175},null,{"$f":"SUM(K5:K8)","v":6125},null,{"$f":"SUM(M5:M8)","v":6475},null,{"$f":"SUM(O5:O8)","v":2625}]
[null,"% Output / day","Average",{"$f":"AVERAGE(F10:O10)","v":0.54600000000000004},null,{"$f":"F9/O3","v":0.49},null,{"$f":"H9/O3","v":0.71750000000000003},null,{"$f":"J9/O3","v":0.61250000000000004},null,{"$f":"L9/O3","v":0.64749999999999996},null,{"$f":"N9/O3","v":0.26250000000000001}]
[null,"Aantal blocks",null,null,null,{"$f":"COUNTA(F5:F8)","v":2},null,{"$f":"COUNTA(H5:H8)","v":4},null,{"$f":"COUNTA(J5:J8)","v":3},null,{"$f":"COUNTA(L5:L8)","v":4},null,{"$f":"COUNTA(N5:N8)","v":1}]
[]
[null,"Remarks",null,null,null,{"$f":"F4","v":"2019-12-30"},null,{"$f":"H4","v":"2019-12-31"},null,{"$f":"J4","v":"2020-01-01"},null,{"$f":"L4","v":"2020-01-02"},null,{"$f":"N4","v":"2020-01-03"}]
[null,"Block 1"]
[]
[]
[null,"Block 2"]
[]
[]
[null,"Block 3"]
[]
[]
[null,"Block 4"]

{"sheet":"2","index":2,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,11,3,12],[3,13,3,14],[1,1,2,1],[1,2,2,2],[1,3,2,4],[1,5,1,8],[1,10,1,13],[2,5,2,8],[2,10,2,13],[8,5,8,6],[3,1,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[12,13,12,14],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[9,13,9,14],[12,1,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[16,13,18,14],[13,1,15,4],[13,5,15,6],[13,7,15,8],[13,9,15,10],[13,11,15,12],[13,13,15,14],[16,1,18,4],[16,5,18,6],[16,7,18,8],[16,9,18,10],[16,11,18,12],[22,13,24,14],[19,1,21,4],[19,5,21,6],[19,7,21,8],[19,9,21,10],[19,11,21,12],[19,13,21,14],[22,1,24,4],[22,5,24,6],[22,7,24,8],[22,9,24,10],[22,11,24,12]]}
[]
[null,"Year/week",2020,2,null,"Aantal Blocks",null,null,null,{"$f":"SUM(F11:O11)","v":16}]
[null,null,null,null,null,"Total week output",null,null,null,{"$f":"SUM(F9:O9)","v":29750},"Target output/day",null,null,null,10000]
[null,"Output",null,null,null,{"$f":"DATEVALUE(\"01-01-\"&$C$2)+D2*7-(10-1)","v":"2020-01-06"},null,{"$f":"WORKDAY.INTL(F4,1)","v":"2020-01-07"},null,{"$f":"WORKDAY.INTL(F4,2)","v":"2020-01-08"},null,{"$f":"WORKDAY.INTL(F4,3)","v":"2020-01-09"},null,{"$f":"WORKDAY.INTL(F4,4)","v":"2020-01-10"}]
[null,"Output block 1",null,null,null,10,{"$f":"F5*(35*5)","v":1750},7,{"$f":"H5*(35*5)","v":1225},null,{"$f":"J5*(35*5)","v":0},11,{"$f":"L5*(35*5)","v":1925},8,{"$f":"N5*(35*5)","v":1400}]
[null,"Output block 2",null,null,null,18,{"$f":"F6*(35*5)","v":3150},20,3500,11,{"$f":"J6*(35*5)","v":1925},9,{"$f":"L6*(35*5)","v":1575},21,{"$f":"N6*(35*5)","v":3675}]
[null,"Output block 3",null,null,null,7,1225,8,1400,9,1575,9,1575,null,0]
[null,"Output block 4",null,null,null,null,0,5,875,12,2100,5,875,null,0]
[null,"Daily Output",null,null,null,{"$f":"SUM(G5:G8)","v":6125},null,{"$f":"SUM(I5:I8)","v":7000},null,{"$f":"SUM(K5:K8)","v":5600},null,{"$f":"SUM(M5:M8)","v":5950},null,{"$f":"SUM(O5:O8)","v":5075}]
[null,"% Output / day","Average",{"$f":"AVERAGE(F10:O10)","v":0.59499999999999997},null,{"$f":"F9/O3","v":0.61250000000000004},null,{"$f":"H9/O3","v":0.7},null,{"$f":"J9/O3","v":0.56000000000000005},null,{"$f":"L9/O3","v":0.59499999999999997},null,{"$f":"N9/O3","v":0.50749999999999995}]
[null,"Aantal blocks",null,null,null,{"$f":"COUNTA(F5:F8)","v":3},null,{"$f":"COUNTA(H5:H8)","v":4},null,{"$f":"COUNTA(J5:J8)","v":3},null,{"$f":"COUNTA(L5:L8)","v":4},null,{"$f":"COUNTA(N5:N8)","v":2}]
[]
[null,"Remarks",null,null,null,{"$f":"F4","v":"2020-01-06"},null,{"$f":"H4","v":"2020-01-07"},null,{"$f":"J4","v":"2020-01-08"},null,{"$f":"L4","v":"2020-01-09"},null,{"$f":"N4","v":"2020-01-10"}]
[null,"Block 1"]
[]
[]
[null,"Block 2"]
[]
[]
[null,"Block 3"]
[]
[]
[null,"Block 4"]

{"sheet":"Planning en Output (2)","index":3,"n_rows":110,"n_cols":22,"rows_kept":110,"cut":false,"hidden":false,"merged":[[20,7,20,15],[22,7,22,15],[24,7,24,15],[25,7,25,15],[26,7,26,15]]}
[5,null,"Invullen","jaar",2020]
["Week","Gepland","Output","Achterstand","Aantal blokken niet geclipt",null," Door het jaartal in cel C3 past de volledige lijst zich aan met het nieuwe jaar"]
[1,29500,{"$f":"IFERROR(IF(B3<>\"\",SUM(INDIRECT(A3&\"!G$5:G$8\"))+SUM(INDIRECT(A3&\"!I$5:i$8\"))+SUM(INDIRECT(A3&\"!K$5:k$8\"))+SUM(INDIRECT(A3&\"!m$5:m$8\"))+SUM(INDIRECT(A3&\"!o$5:o$8\")),\"\"),\"\")","v":27300},{"$f":"IFERROR(IF(B3<>\"\",B3-C3,\"\"),\"\")","v":2200},{"$f":"IFERROR(COUNTIF(INDIRECT(A3&\"!$G$5:$G$8\"),0)+COUNTIF(INDIRECT(A3&\"!$i$5:$i$8\"),0)+COUNTIF(INDIRECT(A3&\"!$k$5:$k$8\"),0)+COUNTIF(INDIRECT(A3&\"!$m$5:$m$8\"),0)+COUNTIF(INDIRECT(A3&\"!$o$5:$o$8\"),0),\"-\")","v":6}]
[2,31500,{"$f":"IFERROR(IF(B4<>\"\",SUM(INDIRECT(A4&\"!G$5:G$8\"))+SUM(INDIRECT(A4&\"!I$5:i$8\"))+SUM(INDIRECT(A4&\"!K$5:k$8\"))+SUM(INDIRECT(A4&\"!m$5:m$8\"))+SUM(INDIRECT(A4&\"!o$5:o$8\")),\"\"),\"\")","v":29750},{"$f":"IFERROR(IF(B4<>\"\",B4-C4,\"\"),\"\")","v":1750},{"$f":"IFERROR(COUNTIF(INDIRECT(A4&\"!$G$5:$G$8\"),0)+COUNTIF(INDIRECT(A4&\"!$i$5:$i$8\"),0)+COUNTIF(INDIRECT(A4&\"!$k$5:$k$8\"),0)+COUNTIF(INDIRECT(A4&\"!$m$5:$m$8\"),0)+COUNTIF(INDIRECT(A4&\"!$o$5:$o$8\"),0),\"-\")","v":4},null,"Als B3 ingevuld is word automatisch B4 zichtbaar enz…"]
[{"$f":"A4+1","v":3},null,"","","-"]
[4,null,"","","-"]
[5,null,"","","-"]
[6,null,"","","-"]
[7,null,"","","-"]
[8,null,"","","-"]
[9,null,"","","-"]
[10,null,"","","-"]
[11,null,"","","-"]
[12,null,"","","-"]
[13,null,"","","-"]
[14,null,"","","-"]
[15,null,"","","-"]
[16,null,"","","-"]
[17,null,"","","-"]
[18,null,"","","-"]
[19,null,"","","-"]
[20,null,"","","-"]
[21,null,"","","-"]
[22,null,"","","-"]
[23,null,"","","-"]
[24,null,"","","-"]
[25,null,"","","-"]
[26,null,"","","-"]
[27,null,"","","-"]
[28,null,"","","-"]
[29,null,"","","-"]
[30,null,"","","-"]
[31,null,"","","-"]
[32,null,"","","-"]
[33,null,"","","-"]
[34,null,"","","-"]
[35,null,"","","-"]
[36,null,"","","-"]
[37,null,"","","-"]
[38,null,"","","-"]
[39,null,"","","-"]
[40,null,"","","-"]
[{"$f":"A42+1","v":41},null,"","","-"]
[{"$f":"A43+1","v":42},null,"","","-"]
[43,null,"","","-"]
[44,null,"","","-"]
[45,null,"","","-"]
[46,null,"","","-"]
[47,null,"","","-"]
[48,null,"","","-"]
[49,null,"","","-"]
[50,null,"","","-"]
[51,null,"","","-"]
[52,null,"","","-"]
[53,null,"",""]
[]
["Week","Gepland per week","datum","Gepland op maandag","Output","Achterstand","datum","Gepland op dinsdag","Output","Achterstand","datum","Gepland op woensdag","Output","Achterstand","datum","Gepland op donderdag","Output","Achterstand","datum","Gepland op vrijdag","Output","Achterstand"]
[1,{"$f":"VLOOKUP(A58,$A$3:$B$54,2,FALSE)","v":29500},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A58-1)+\"1\"","v":"2019-12-30"},{"$f":"$B58/$A$1","v":5900},{"$f":"IF($B58>0,SUM(INDIRECT($A58&\"!$G$5:$G$8\")),\"\")","v":4900},{"$f":"IF(E58<>\"\",D58-E58,\"\")","v":1000},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A58-1)+\"2\"","v":"2019-12-31"},{"$f":"$B58/$A$1","v":5900},{"$f":"IF($B58>0,SUM(INDIRECT($A58&\"!$i$5:$i$8\")),\"\")","v":7175},{"$f":"IF(I58<>\"\",H58-I58,\"\")","v":-1275},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A58-1)+\"3\"","v":"2020-01-01"},{"$f":"$B58/$A$1","v":5900},{"$f":"IF($B58>0,SUM(INDIRECT($A58&\"!$k$5:$k$8\")),\"\")","v":6125},{"$f":"IF(M58<>\"\",L58-M58,\"\")","v":-225},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A58-1)+\"4\"","v":"2020-01-02"},{"$f":"$B58/$A$1","v":5900},{"$f":"IF($B58>0,SUM(INDIRECT($A58&\"!$m$5:$m$8\")),\"\")","v":6475},{"$f":"IF(Q58<>\"\",P58-Q58,\"\")","v":-575},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A58-1)+\"5\"","v":"2020-01-03"},{"$f":"$B58/$A$1","v":5900},{"$f":"IF($B58>0,SUM(INDIRECT($A58&\"!$o$5:$o$8\")),\"\")","v":2625},{"$f":"IF(U58<>\"\",T58-U58,\"\")","v":3275}]
[2,{"$f":"VLOOKUP(A59,$A$3:$B$54,2,FALSE)","v":31500},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A59-1)+\"1\"","v":"2020-01-06"},{"$f":"$B59/$A$1","v":6300},6125,{"$f":"IF(E59<>\"\",D59-E59,\"\")","v":175},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A59-1)+\"2\"","v":"2020-01-07"},{"$f":"$B59/$A$1","v":6300},{"$f":"IF($B59>0,SUM(INDIRECT($A59&\"!$i$5:$i$8\")),\"\")","v":7000},{"$f":"IF(I59<>\"\",H59-I59,\"\")","v":-700},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A59-1)+\"3\"","v":"2020-01-08"},{"$f":"$B59/$A$1","v":6300},{"$f":"IF($B59>0,SUM(INDIRECT($A59&\"!$k$5:$k$8\")),\"\")","v":5600},{"$f":"IF(M59<>\"\",L59-M59,\"\")","v":700},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A59-1)+\"4\"","v":"2020-01-09"},{"$f":"$B59/$A$1","v":6300},{"$f":"IF($B59>0,SUM(INDIRECT($A59&\"!$m$5:$m$8\")),\"\")","v":5950},{"$f":"IF(Q59<>\"\",P59-Q59,\"\")","v":350},{"$f":"DATE($E$1,1,4)-WEEKDAY(DATE($E$1,1,4),2)+7*($A59-1)+\"5\"","v":"2020-01-10"},{"$f":"$B59/$A$1","v":6300},{"$f":"IF($B59>0,SUM(INDIRECT($A59&\"!$o$5:$o$8\")),\"\")","v":5075},{"$f":"IF(U59<>\"\",T59-U59,\"\")","v":1225}]
[3,0,"2020-01-13",0,"","","2020-01-14",0,"","","2020-01-15",0,"","","2020-01-16",0,"","","2020-01-17",0,"",""]
[4,0,"2020-01-20",0,"","","2020-01-21",0,"","","2020-01-22",0,"","","2020-01-23",0,"","","2020-01-24",0,"",""]
[5,0,"2020-01-27",0,"","","2020-01-28",0,"","","2020-01-29",0,"","","2020-01-30",0,"","","2020-01-31",0,"",""]
[6,0,"2020-02-03",0,"","","2020-02-04",0,"","","2020-02-05",0,"","","2020-02-06",0,"","","2020-02-07",0,"",""]
[7,0,"2020-02-10",0,"","","2020-02-11",0,"","","2020-02-12",0,"","","2020-02-13",0,"","","2020-02-14",0,"",""]
[8,0,"2020-02-17",0,"","","2020-02-18",0,"","","2020-02-19",0,"","","2020-02-20",0,"","","2020-02-21",0,"",""]
[9,0,"2020-02-24",0,"","","2020-02-25",0,"","","2020-02-26",0,"","","2020-02-27",0,"","","2020-02-28",0,"",""]
[10,0,"2020-03-02",0,"","","2020-03-03",0,"","","2020-03-04",0,"","","2020-03-05",0,"","","2020-03-06",0,"",""]
[11,0,"2020-03-09",0,"","","2020-03-10",0,"","","2020-03-11",0,"","","2020-03-12",0,"","","2020-03-13",0,"",""]
[12,0,"2020-03-16",0,"","","2020-03-17",0,"","","2020-03-18",0,"","","2020-03-19",0,"","","2020-03-20",0,"",""]
[13,0,"2020-03-23",0,"","","2020-03-24",0,"","","2020-03-25",0,"","","2020-03-26",0,"","","2020-03-27",0,"",""]
[14,0,"2020-03-30",0,"","","2020-03-31",0,"","","2020-04-01",0,"","","2020-04-02",0,"","","2020-04-03",0,"",""]
[15,0,"2020-04-06",0,"","","2020-04-07",0,"","","2020-04-08",0,"","","2020-04-09",0,"","","2020-04-10",0,"",""]
[16,0,"2020-04-13",0,"","","2020-04-14",0,"","","2020-04-15",0,"","","2020-04-16",0,"","","2020-04-17",0,"",""]
[17,0,"2020-04-20",0,"","","2020-04-21",0,"","","2020-04-22",0,"","","2020-04-23",0,"","","2020-04-24",0,"",""]
[18,0,"2020-04-27",0,"","","2020-04-28",0,"","","2020-04-29",0,"","","2020-04-30",0,"","","2020-05-01",0,"",""]
[19,0,"2020-05-04",0,"","","2020-05-05",0,"","","2020-05-06",0,"","","2020-05-07",0,"","","2020-05-08",0,"",""]
[20,0,"2020-05-11",0,"","","2020-05-12",0,"","","2020-05-13",0,"","","2020-05-14",0,"","","2020-05-15",0,"",""]
[21,0,"2020-05-18",0,"","","2020-05-19",0,"","","2020-05-20",0,"","","2020-05-21",0,"","","2020-05-22",0,"",""]
[22,0,"2020-05-25",0,"","","2020-05-26",0,"","","2020-05-27",0,"","","2020-05-28",0,"","","2020-05-29",0,"",""]
[23,0,"2020-06-01",0,"","","2020-06-02",0,"","","2020-06-03",0,"","","2020-06-04",0,"","","2020-06-05",0,"",""]
[24,0,"2020-06-08",0,"","","2020-06-09",0,"","","2020-06-10",0,"","","2020-06-11",0,"","","2020-06-12",0,"",""]
[25,0,"2020-06-15",0,"","","2020-06-16",0,"","","2020-06-17",0,"","","2020-06-18",0,"","","2020-06-19",0,"",""]
[26,0,"2020-06-22",0,"","","2020-06-23",0,"","","2020-06-24",0,"","","2020-06-25",0,"","","2020-06-26",0,"",""]
[27,0,"2020-06-29",0,"","","2020-06-30",0,"","","2020-07-01",0,"","","2020-07-02",0,"","","2020-07-03",0,"",""]
[28,0,"2020-07-06",0,"","","2020-07-07",0,"","","2020-07-08",0,"","","2020-07-09",0,"","","2020-07-10",0,"",""]
[29,0,"2020-07-13",0,"","","2020-07-14",0,"","","2020-07-15",0,"","","2020-07-16",0,"","","2020-07-17",0,"",""]
[30,0,"2020-07-20",0,"","","2020-07-21",0,"","","2020-07-22",0,"","","2020-07-23",0,"","","2020-07-24",0,"",""]
[31,0,"2020-07-27",0,"","","2020-07-28",0,"","","2020-07-29",0,"","","2020-07-30",0,"","","2020-07-31",0,"",""]
[32,0,"2020-08-03",0,"","","2020-08-04",0,"","","2020-08-05",0,"","","2020-08-06",0,"","","2020-08-07",0,"",""]
[33,0,"2020-08-10",0,"","","2020-08-11",0,"","","2020-08-12",0,"","","2020-08-13",0,"","","2020-08-14",0,"",""]
[34,0,"2020-08-17",0,"","","2020-08-18",0,"","","2020-08-19",0,"","","2020-08-20",0,"","","2020-08-21",0,"",""]
[35,0,"2020-08-24",0,"","","2020-08-25",0,"","","2020-08-26",0,"","","2020-08-27",0,"","","2020-08-28",0,"",""]
[36,0,"2020-08-31",0,"","","2020-09-01",0,"","","2020-09-02",0,"","","2020-09-03",0,"","","2020-09-04",0,"",""]
[37,0,"2020-09-07",0,"","","2020-09-08",0,"","","2020-09-09",0,"","","2020-09-10",0,"","","2020-09-11",0,"",""]
[38,0,"2020-09-14",0,"","","2020-09-15",0,"","","2020-09-16",0,"","","2020-09-17",0,"","","2020-09-18",0,"",""]
[39,0,"2020-09-21",0,"","","2020-09-22",0,"","","2020-09-23",0,"","","2020-09-24",0,"","","2020-09-25",0,"",""]
[40,0,"2020-09-28",0,"","","2020-09-29",0,"","","2020-09-30",0,"","","2020-10-01",0,"","","2020-10-02",0,"",""]
[41,0,"2020-10-05",0,"","","2020-10-06",0,"","","2020-10-07",0,"","","2020-10-08",0,"","","2020-10-09",0,"",""]
[42,0,"2020-10-12",0,"","","2020-10-13",0,"","","2020-10-14",0,"","","2020-10-15",0,"","","2020-10-16",0,"",""]
[43,0,"2020-10-19",0,"","","2020-10-20",0,"","","2020-10-21",0,"","","2020-10-22",0,"","","2020-10-23",0,"",""]
[44,0,"2020-10-26",0,"","","2020-10-27",0,"","","2020-10-28",0,"","","2020-10-29",0,"","","2020-10-30",0,"",""]
[45,0,"2020-11-02",0,"","","2020-11-03",0,"","","2020-11-04",0,"","","2020-11-05",0,"","","2020-11-06",0,"",""]
[46,0,"2020-11-09",0,"","","2020-11-10",0,"","","2020-11-11",0,"","","2020-11-12",0,"","","2020-11-13",0,"",""]
[47,0,"2020-11-16",0,"","","2020-11-17",0,"","","2020-11-18",0,"","","2020-11-19",0,"","","2020-11-20",0,"",""]
[48,0,"2020-11-23",0,"","","2020-11-24",0,"","","2020-11-25",0,"","","2020-11-26",0,"","","2020-11-27",0,"",""]
[49,0,"2020-11-30",0,"","","2020-12-01",0,"","","2020-12-02",0,"","","2020-12-03",0,"","","2020-12-04",0,"",""]
[50,0,"2020-12-07",0,"","","2020-12-08",0,"","","2020-12-09",0,"","","2020-12-10",0,"","","2020-12-11",0,"",""]
[51,0,"2020-12-14",0,"","","2020-12-15",0,"","","2020-12-16",0,"","","2020-12-17",0,"","","2020-12-18",0,"",""]
[52,0,"2020-12-21",0,"","","2020-12-22",0,"","","2020-12-23",0,"","","2020-12-24",0,"","","2020-12-25",0,"",""]
[53,{"$f":"VLOOKUP(A110,$A$3:$B$55,2,FALSE)","v":0},"2020-12-28",0,"","","2020-12-29",0,"","","2020-12-30",0,"","","2020-12-31",0,"","","2021-01-01",0,"",""]