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

{"sheet":"Tweewekelijkse urenstaat","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"merged":[[1,1,1,5],[1,6,1,7],[2,1,2,2],[2,3,2,4],[2,6,2,7],[3,1,3,2],[3,3,3,4],[3,5,3,6],[4,1,4,2],[4,3,4,4],[4,5,4,6],[24,1,24,4],[24,6,24,7],[25,1,25,4],[26,1,26,4],[26,6,26,7],[27,1,27,4]]}
[null,"Bedrijfsnaam"]
[null,"Adres, adres 2, postcode en plaats",{"$nulls":4},"Wekelijkse urenstaat met pauzes"]
[null,"Werknemer:",{"$nulls":3},"Telefoon werknemer:"]
[null,"E-mailadres werknemer:",{"$nulls":3},"Begindatum salarisperiode:",null,{"$f":"TODAY()","v":"2018-12-13"}]
[null,"Manager:",{"$nulls":3},"Einddatum salarisperiode:",null,{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2018-12-26"}]
[]
[null,"Dag","Datum","Normale uren","Overuren","Ziek","Vakantie","Totaal"]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"H4","v":"2018-12-13"},{"v":8,"d":"8.00"},{"$nulls":3},{"$f":"IFERROR(SUM(D8:G8), \"\")","v":{"v":8,"d":"8.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"IF($H$4=\"\",\"\",$H$4+1)","v":"2018-12-14"},{"v":8,"d":"8.00"},{"v":2,"d":"2.00"},null,null,{"$f":"IFERROR(SUM(D9:G9), \"\")","v":{"v":10,"d":"10.00"}}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IF($H$4=\"\",\"\",$H$4+2)","v":"2018-12-15"},null,null,{"v":8,"d":"8.00"},null,{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IF($H$4=\"\",\"\",$H$4+3)","v":"2018-12-16"},{"$nulls":3},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IF($H$4=\"\",\"\",$H$4+4)","v":"2018-12-17"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IF($H$4=\"\",\"\",$H$4+5)","v":"2018-12-18"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IF($H$4=\"\",\"\",$H$4+6)","v":"2018-12-19"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Thursday"},{"$f":"IF($H$4=\"\",\"\",$H$4+7)","v":"2018-12-20"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Friday"},{"$f":"IF($H$4=\"\",\"\",$H$4+8)","v":"2018-12-21"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Saturday"},{"$f":"IF($H$4=\"\",\"\",$H$4+9)","v":"2018-12-22"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Sunday"},{"$f":"IF($H$4=\"\",\"\",$H$4+10)","v":"2018-12-23"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Monday"},{"$f":"IF($H$4=\"\",\"\",$H$4+11)","v":"2018-12-24"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Tuesday"},{"$f":"IF($H$4=\"\",\"\",$H$4+12)","v":"2018-12-25"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(Urenstaat[[#This Row],[Datum]],\"aaaa\"), \"\")","v":"Wednesday"},{"$f":"IF($H$4=\"\",\"\",$H$4+13)","v":"2018-12-26"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"Totaal",{"$f":"SUBTOTAL(109,Urenstaat[Normale uren])","v":{"v":16,"d":"16.00"}},{"$f":"SUBTOTAL(109,Urenstaat[Overuren])","v":{"v":2,"d":"2.00"}},{"$f":"SUBTOTAL(109,Urenstaat[Ziek])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,Urenstaat[Vakantie])","v":{"v":8,"d":"8.00"}},{"$f":"SUBTOTAL(109,Urenstaat[Totaal])","v":{"v":34,"d":"34.00"}}]
[null,null,"Tarief per uur",{"v":10,"d":"€ 10.00"},{"v":15,"d":"€ 15.00"},{"v":10,"d":"€ 10.00"},{"v":10,"d":"€ 10.00"}]
[null,null,"Totaal salaris",{"$f":"IFERROR(SUM(D23*Urenstaat[[#Totals],[Normale uren]]), \"\")","v":{"v":160,"d":"€ 160.00"}},{"$f":"IFERROR(SUM(E23*Urenstaat[[#Totals],[Overuren]]), \"\")","v":{"v":30,"d":"€ 30.00"}},{"$f":"IFERROR(SUM(F23*Urenstaat[[#Totals],[Ziek]]), \"\")","v":{"v":80,"d":"€ 80.00"}},{"$f":"IFERROR(SUM(G23*Urenstaat[[#Totals],[Vakantie]]), \"\")","v":{"v":80,"d":"€ 80.00"}},{"$f":"IFERROR(SUM(D24:G24), \"\")","v":{"v":350,"d":"€ 350.00"}}]
[]
[null,"Handtekening werknemer",{"$nulls":4},"Datum"]
[]
[null,"Handtekening manager",{"$nulls":4},"Datum"]