{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BEGIN","JAARLIJKSE URENSTAAT"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"BEGIN","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"OVER DEZE SJABLOON"]
[null,"Houd uw uren dagelijks, wekelijks, maandelijks en jaarlijks bij met deze urenstaat voor werknemers."]
[null,"Vul basisinformatie zoals naam van werknemer, naam van manager, e-mailadres en telefoonnummer in. "]
[null,"Voeg uw uren aan elke maandtabel toe. Leg normale uren en overuren in aparte kolommen vast voor elke weekdag van elke week. "]
[null,"Totaalaantal werkuren, normale uren en overuren worden automatisch berekend. "]
[null,"Opmerkingen:"]
[null,"Kolom A van het werkblad JAARLIJKSE URENSTAAT bevat aanvullende instructies. Deze tekst is opzettelijk verborgen. Als u tekst wilt verwijderen, selecteert u kolom A en drukt u op DELETE. Als u de tekst zichtbaar wilt maken, selecteert u kolom A en wijzigt u de tekenkleur. "]
[null,"Als u meer wilt weten over tabellen, drukt u in een tabel op Shift en F10 en selecteert u de optie TABEL en vervolgens ALTERNATIEVE TEKST."]

{"sheet":"JAARLIJKSE URENSTAAT","index":1,"n_rows":132,"n_cols":15,"rows_kept":132,"merged":[[0,1,0,2],[0,4,0,14],[10,6,10,7],[21,6,21,7],[32,6,32,7],[33,4,33,14],[43,6,43,7],[54,6,54,7],[65,6,65,7],[66,4,66,14],[76,6,76,7],[87,6,87,7],[98,6,98,7],[99,4,99,14],[109,6,109,7],[120,6,120,7],[131,6,131,7]]}
["Maak in dit werkblad een dagelijkse, wekelijkse, maandelijkse of jaarlijkse urenstaat voor werknemers. \nCellen in deze kolom bevatten handige instructies voor het gebruik van deze werkmap. Druk op de pijl-omlaag om aan de slag te gaan.\nDe titel van dit werkblad staat in de cel rechts en de kwartaalkop voor januari, februari en maart staat in cel E1.","URENSTAAT VOOR \nWERKNEMERS",null,null,"Januari, Februari, Maart      Urenstaat voor werknemers: Dagelijks, Wekelijks, Maandelijks, Jaarlijks"]
["Voer in cel C2 de naam van werknemer in en in de tabel Januari normale uren en overuren, beginnend in cel E2.","Naam van werknemer:",null,null,"Januari","Week 1","Overuren","Week 2","Overuren  ","Week 3","Overuren   ","Week 4","Overuren    ","Week 5","Overuren     "]
["Voer in cel C3 de naam van de manager in.","Manager:",null,null,"Maandag",{"v":8,"d":"8.0"}]
["Voer in cel C4 het e-mailadres in.","E-mail:",null,null,"Dinsdag",{"v":8,"d":"8.0"},{"v":2,"d":"2.0"}]
["Voer in cel C5 het telefoonnummer in. De volgende aanwijzing staat in cel A9.","Telefoon:",null,null,"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
["Jaarlijks totaalaantal normale uren wordt automatisch berekend in cel C9.","Normale uren:",{"$f":"RegularHrs","v":31},null,"Zondag"]
["Jaarlijks totaalaantal overuren wordt automatisch berekend in cel C10.","Overuren:",{"$f":"Overtime_hrs","v":4},null,"Totaalaantal wekelijkse uren",{"$f":"SUM(F3:F9)","v":{"v":16,"d":"16.0"}},{"v":2,"d":"2.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Jaarlijks algemeen totaalaantal uren wordt automatisch berekend in cel C11. Totaalaantal normale uren voor januari in cel F11 en totaalaantal overuren voor januari in cel I11 worden automatisch berekend. De volgende aanwijzing staat in cel A13.","Totaal",{"$f":"RegularHrs+Overtime_hrs","v":35},null,{"$f":"TEXT(DATEVALUE(Januari[[#Headers],[Januari]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"jan. totaal: Normale uren"},{"$f":"SUM(Januari[Week 1],Januari[Week 2],Januari[Week 3],Januari[Week 4],Januari[Week 5])","v":{"v":16,"d":"16.0"}},{"$f":"TEXT(DATEVALUE(Januari[[#Headers],[Januari]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"jan. totaal: Overuren"},null,{"$f":"SUM(Januari[Overuren],Januari[[Overuren  ]],Januari[[Overuren   ]],Januari[[Overuren    ]],Januari[[Overuren     ]])","v":{"v":2,"d":"2.0"}}]
[]
["Voer in de tabel Februari normale uren en overuren in, beginnend in cel E13. De volgende aanwijzing staat in cel A22.",{"$nulls":3},"Februari","Week 1","Overuren","Week 2","Overuren  ","Week 3","Overuren   ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag",{"v":8,"d":"8.0"}]
[{"$nulls":4},"Dinsdag",{"v":7,"d":"7.0"},{"v":2,"d":"2.0"}]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F14:F20)","v":{"v":15,"d":"15.0"}},{"v":2,"d":"2.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor februari in cel F22 en totaalaantal overuren voor februari in cel I22 worden automatisch berekend. De volgende aanwijzing staat in cel A24.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Februari[[#Headers],[Februari]]&\"  \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"feb. totaal: Normale uren"},{"$f":"SUM(Februari[Week 1],Februari[Week 2],Februari[Week 3],Februari[Week 4],Februari[Week 5])","v":{"v":15,"d":"15.0"}},{"$f":"TEXT(DATEVALUE(Februari[[#Headers],[Februari]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"feb. totaal: Overuren"},null,{"$f":"SUM(Februari[Overuren],Februari[[Overuren  ]],Februari[[Overuren   ]],Februari[[Overuren    ]],Februari[[Overuren     ]])","v":{"v":2,"d":"2.0"}}]
[]
["Voer in de tabel Maart normale uren en overuren in, beginnend in cel E24. De volgende aanwijzing staat in cel A33.",{"$nulls":3},"Maart","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F25:F31)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor maart in cel F33 en totaalaantal overuren voor maart in cel I33 worden automatisch berekend.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Maart[[#Headers],[Maart]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"mrt. totaal: Normale uren"},{"$f":"SUM(Maart[Week 1],Maart[Week 2],Maart[Week 3],Maart[Week 4],Maart[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Maart[[#Headers],[Maart]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"mrt. totaal: Overuren"},null,{"$f":"SUM(Maart[Overuren],Maart[[Overuren ]],Maart[[Overuren  ]],Maart[[Overuren    ]],Maart[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
["De tweede-kwartaalkop voor april, mei en juni staat in cel E34. ",{"$nulls":3},"April, Mei, Juni      Urenstaat voor werknemers: Dagelijks, Wekelijks, Maandelijks, Jaarlijks"]
["Voer in de tabel April normale uren en overuren in, beginnend in cel E35. De volgende aanwijzing staat in cel A44.",{"$nulls":3},"April","Week 1","Overuren","Week 2","Overuren  ","Week 3","Overuren   ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F36:F42)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor april in cel F44 en totaalaantal overuren voor april in cel I44 worden automatisch berekend. De volgende aanwijzing staat in cel A46.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(April[[#Headers],[April]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"apr. totaal: Normale uren"},{"$f":"SUM(April[Week 1],April[Week 2],April[Week 3],April[Week 4],April[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(April[[#Headers],[April]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"apr. totaal: Overuren"},null,{"$f":"SUM(April[Overuren],April[[Overuren  ]],April[[Overuren   ]],April[[Overuren    ]],April[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel Mei normale uren en overuren in, beginnend in cel E46. De volgende aanwijzing staat in cel A55.",{"$nulls":3},"Mei","Week 1","Overuren","Week 2","Overuren  ","Week 3","Overuren   ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F47:F53)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor mei in cel F55 en totaalaantal overuren voor mei in cel I55 worden automatisch berekend. De volgende aanwijzing staat in cel A57.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Mei[[#Headers],[Mei]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"mei. totaal: Normale uren"},{"$f":"SUM(Mei[Week 1],Mei[Week 2],Mei[Week 3],Mei[Week 4],Mei[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Mei[[#Headers],[Mei]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"mei. totaal: Overuren"},null,{"$f":"SUM(Mei[Overuren],Mei[[Overuren  ]],Mei[[Overuren   ]],Mei[[Overuren    ]],Mei[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel Juni normale uren en overuren in, beginnend in cel E57. De volgende aanwijzing staat in cel A66.",{"$nulls":3},"Juni","Week 1","Overuren","Week 2","Overuren  ","Week 3","Overuren   ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F58:F64)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor juni in cel F66 en totaalaantal overuren voor juni in cel I66 worden automatisch berekend.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Juni[[#Headers],[Juni]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"jun. totaal: Normale uren"},{"$f":"SUM(Juni[Week 1],Juni[Week 2],Juni[Week 3],Juni[Week 4],Juni[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Juni[[#Headers],[Juni]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"jun. totaal: Overuren"},null,{"$f":"SUM(Juni[Overuren],Juni[[Overuren  ]],Juni[[Overuren   ]],Juni[[Overuren    ]],Juni[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
["De derde-kwartaalkop voor juli, augustus en september staat in cel E67. ",{"$nulls":3},"Juli, Augustus, September      Urenstaat voor werknemers: Dagelijks, Wekelijks, Maandelijks, Jaarlijks"]
["Voer in de tabel Juli normale uren en overuren in, beginnend in cel E68. De volgende aanwijzing staat in cel A77.",{"$nulls":3},"Juli","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUM(F69:F75)","v":{"v":0,"d":"0.0"}},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Totaalaantal normale uren voor juli in cel F77 en totaalaantal overuren voor juli in cel I77 worden automatisch berekend. De volgende aanwijzing staat in cel A79.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Juli[[#Headers],[Juli]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"jul. totaal: Normale uren"},{"$f":"SUM(Juli[Week 1],Juli[Week 2],Juli[Week 3],Juli[Week 4],Juli[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Juli[[#Headers],[Juli]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"jul. totaal: Overuren"},null,{"$f":"SUM(Juli[Overuren],Juli[[Overuren ]],Juli[[Overuren  ]],Juli[[Overuren   ]],Juli[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel Augustus normale uren en overuren in, beginnend in cel E79. De volgende aanwijzing staat in cel A88.",{"$nulls":3},"Augustus","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren   ","Week 4","Overuren  ","Week 5","Overuren    "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUBTOTAL(109,Augustus[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[Overuren])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[[Overuren ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[[Overuren   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[[Overuren  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Augustus[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
["Totaalaantal normale uren voor augustus in cel F88 en totaalaantal overuren voor augustus in cel I88 worden automatisch berekend. De volgende aanwijzing staat in cel A90.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Augustus[[#Headers],[Augustus]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"aug. totaal: Normale uren"},{"$f":"SUM(Augustus[Week 1],Augustus[Week 2],Augustus[Week 3],Augustus[Week 4],Augustus[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Augustus[[#Headers],[Augustus]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"aug. totaal: Overuren"},null,{"$f":"SUM(Augustus[Overuren],Augustus[[Overuren ]],Augustus[[Overuren   ]],Augustus[[Overuren  ]],Augustus[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel September normale uren en overuren in, beginnend in cel E90. De volgende aanwijzing staat in cel A99.",{"$nulls":3},"September","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUBTOTAL(109,September[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Overuren])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overuren ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overuren  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overuren   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,September[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
["Totaalaantal normale uren voor september in cel F99 en totaalaantal overuren voor september in cel I99 worden automatisch berekend.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(September[[#Headers],[September]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"sep. totaal: Normale uren"},{"$f":"SUM(September[Week 1],September[Week 2],September[Week 3],September[Week 4],September[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(September[[#Headers],[September]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"sep. totaal: Overuren"},null,{"$f":"SUM(September[Overuren],September[[Overuren ]],September[[Overuren  ]],September[[Overuren   ]],September[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
["De vierde-kwartaalkop voor oktober, november en december staat in cel E100. ",{"$nulls":3},"Oktober, November, December      Urenstaat voor werknemers: Dagelijks, Wekelijks, Maandelijks, Jaarlijks"]
["Voer in de tabel Oktober normale uren en overuren in, beginnend in cel E101. De volgende aanwijzing staat in cel A110.",{"$nulls":3},"Oktober","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUBTOTAL(109,Oktober[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[Overuren])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[[Overuren ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[[Overuren  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[[Overuren   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,Oktober[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
["Totaalaantal normale uren voor oktober in cel F110 en totaalaantal overuren voor oktober in cel I110 worden automatisch berekend. De volgende aanwijzing staat in cel A112.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(Oktober[[#Headers],[Oktober]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"okt. totaal: Normale uren"},{"$f":"SUM(Oktober[Week 1],Oktober[Week 2],Oktober[Week 3],Oktober[Week 4],Oktober[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(Oktober[[#Headers],[Oktober]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"okt. totaal: Overuren"},null,{"$f":"SUM(Oktober[Overuren],Oktober[[Overuren ]],Oktober[[Overuren  ]],Oktober[[Overuren   ]],Oktober[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel November normale uren en overuren in, beginnend in cel E112. De volgende aanwijzing staat in cel A121.",{"$nulls":3},"November","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren    ","Week 5","Overuren     "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUBTOTAL(109,November[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Overuren])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overuren ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overuren  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overuren    ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,November[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
["Totaalaantal normale uren voor november in cel F121 en totaalaantal overuren voor november in cel I121 worden automatisch berekend. De volgende aanwijzing staat in cel A123.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(November[[#Headers],[November]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"nov. totaal: Normale uren"},{"$f":"SUM(November[Week 1],November[Week 2],November[Week 3],November[Week 4],November[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(November[[#Headers],[November]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"nov. totaal: Overuren"},null,{"$f":"SUM(November[Overuren],November[[Overuren ]],November[[Overuren  ]],November[[Overuren    ]],November[[Overuren     ]])","v":{"v":0,"d":"0.0"}}]
[]
["Voer in de tabel December normale uren en overuren in, beginnend in cel E123. De volgende aanwijzing staat in cel A132.",{"$nulls":3},"December","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[{"$nulls":4},"Maandag"]
[{"$nulls":4},"Dinsdag"]
[{"$nulls":4},"Woensdag"]
[{"$nulls":4},"Donderdag"]
[{"$nulls":4},"Vrijdag"]
[{"$nulls":4},"Zaterdag"]
[{"$nulls":4},"Zondag"]
[{"$nulls":4},"Totaalaantal wekelijkse uren",{"$f":"SUBTOTAL(109,December[Week 1])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Overuren])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 2])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overuren ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 3])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overuren  ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 4])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overuren   ]])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"SUBTOTAL(109,December[[Overuren    ]])","v":{"v":0,"d":"0.0"}}]
["Totaalaantal normale uren voor december in cel F132 en totaalaantal overuren voor december in cel I132 worden automatisch berekend.",{"$nulls":3},{"$f":"TEXT(DATEVALUE(December[[#Headers],[December]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Normale uren\"","v":"dec. totaal: Normale uren"},{"$f":"SUM(December[Week 1],December[Week 2],December[Week 3],December[Week 4],December[Week 5])","v":{"v":0,"d":"0.0"}},{"$f":"TEXT(DATEVALUE(December[[#Headers],[December]]&\" \"&YEAR(TODAY())),\"mmm.\")&\" totaal: Overuren\"","v":"dec. totaal: Overuren"},null,{"$f":"SUM(G124:G130,I124:I130,K124:K130,M124:M130,O124:O130)","v":{"v":0,"d":"0.0"}}]