{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Wekelijkse urenstaat"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Wekelijkse urenstaat","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,1,2,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,3,5,4],[5,7,5,8],[6,3,6,4],[6,7,6,8],[7,3,7,4],[7,7,7,8],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8]]}
[]
[]
[null,"WEKELIJKSE URENSTAAT"]
[null,"MODERN DESIGN CO"]
[]
[null,"WERKNEMER:",null,"Miguel Reyes",null,null,"TELEFOONNUMMER WERKNEMER:","(805) 555-0123"]
[null,"MANAGER:",null,"Jyeshta Davgar",null,null,"E-MAIL VAN WERKNEMER:","miguel@example.com"]
[{"$nulls":6},"WEEK EINDIGEND OP:",{"$f":"TODAY()","v":"2023-03-23"}]
[]
[null,"DAG"," ","DATUM","NORMALE UREN","OVERUREN","ZIEK","VAKANTIE","TOTAAL"]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"vrijdag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-6), \"\")","v":"2023-03-17"},{"$nulls":4},{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"zaterdag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-5), \"\")","v":"2023-03-18"},{"$nulls":4},{"$f":"IFERROR(SUM(E12:H12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"zondag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-4), \"\")","v":"2023-03-19"},{"$nulls":4},{"$f":"IFERROR(SUM(E13:H13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"maandag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-3), \"\")","v":"2023-03-20"},{"$nulls":4},{"$f":"IFERROR(SUM(E14:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"dinsdag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-2), \"\")","v":"2023-03-21"},{"$nulls":4},{"$f":"IFERROR(SUM(E15:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"woensdag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-1), \"\")","v":"2023-03-22"},{"$nulls":4},{"$f":"IFERROR(SUM(E16:H16), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[DATUM]],\"dddd\"), \"\")","v":"donderdag"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8), \"\")","v":"2023-03-23"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TOTAAL AANTAL UREN",{"$f":"IFERROR(SUM(Urenstaat[NORMALE UREN]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(Urenstaat[OVERUREN]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(Urenstaat[ZIEK]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(Urenstaat[VAKANTIE]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(Urenstaat[TOTAAL]), \"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TARIEF PER UUR"]
[{"$nulls":3},"TOTAAL LOON",{"$f":"IFERROR(E18*E19, \"\")","v":{"v":0,"d":"€ 0"}},{"$f":"IFERROR(F18*F19, \"\")","v":{"v":0,"d":"€ 0"}},{"v":0,"d":"€ 0"},{"v":0,"d":"€ 0"},{"v":0,"d":"€ 0"}]
[]
[]
[null,"HANDTEKENING VAN WERKNEMER",{"$nulls":5},"DATUM"]
[]
[null,"HANDTEKENING VAN MANAGER",{"$nulls":5},"DATUM"]