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

{"sheet":"Jaarlijkse urenstaat","index":0,"n_rows":140,"n_cols":12,"rows_kept":140,"merged":[[0,1,1,11],[2,6,2,7],[2,8,2,9],[5,1,5,11],[39,1,39,11],[73,1,73,11],[107,1,107,11]]}
[null,"Urenstaat werknemer"]
[]
[null,"Naam werknemer:",null,"E-mail:",null,null,"Totalen jaar tot heden:"]
[null,"Manager:",null,"Telefoon:",null,null,"Normale uren:",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"Overuren:",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"Totaal:",{"$f":"SUM(H4:J4)","v":0}]
[]
[null,"Januari, februari, maart      Urenstaat voor werknemer per dag, week, maand en jaar"]
[null,"Januari","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Januari[Week 1])","v":0},{"$f":"SUBTOTAL(109,Januari[Overuren])","v":0},{"$f":"SUBTOTAL(109,Januari[Week 2])","v":0},{"$f":"SUBTOTAL(109,Januari[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Week 3])","v":0},{"$f":"SUBTOTAL(109,Januari[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Week 4])","v":0},{"$f":"SUBTOTAL(109,Januari[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Week 5])","v":0},{"$f":"SUBTOTAL(109,Januari[[Overuren    ]])","v":0}]
[null,"Totaal jan.: Normale uren",{"$f":"SUM(Januari[[#Totals],[Week 1]],Januari[[#Totals],[Week 2]],Januari[[#Totals],[Week 3]],Januari[[#Totals],[Week 4]],Januari[[#Totals],[Week 5]])","v":0},"Totaal jan.: Overuren",null,{"$f":"SUM(Januari[[#Totals],[Overuren]],Januari[[#Totals],[Overuren ]],Januari[[#Totals],[Overuren  ]],Januari[[#Totals],[Overuren   ]],Januari[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Februari","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Februari[Week 1])","v":0},{"$f":"SUBTOTAL(109,Februari[Overuren])","v":0},{"$f":"SUBTOTAL(109,Februari[Week 2])","v":0},{"$f":"SUBTOTAL(109,Februari[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Week 3])","v":0},{"$f":"SUBTOTAL(109,Februari[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Week 4])","v":0},{"$f":"SUBTOTAL(109,Februari[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Week 5])","v":0},{"$f":"SUBTOTAL(109,Februari[[Overuren    ]])","v":0}]
[null,"Totaal feb.: Normale uren",{"$f":"SUM(Februari[[#Totals],[Week 1]],Februari[[#Totals],[Week 2]],Februari[[#Totals],[Week 3]],Februari[[#Totals],[Week 4]],Februari[[#Totals],[Week 5]])","v":0},"Totaal feb.: Overuren",null,{"$f":"SUM(Februari[[#Totals],[Overuren]],Februari[[#Totals],[Overuren ]],Februari[[#Totals],[Overuren  ]],Februari[[#Totals],[Overuren   ]],Februari[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Maart","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Maart[Week 1])","v":0},{"$f":"SUBTOTAL(109,Maart[Overuren])","v":0},{"$f":"SUBTOTAL(109,Maart[Week 2])","v":0},{"$f":"SUBTOTAL(109,Maart[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Maart[Week 3])","v":0},{"$f":"SUBTOTAL(109,Maart[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Maart[Week 4])","v":0},{"$f":"SUBTOTAL(109,Maart[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Maart[Week 5])","v":0},{"$f":"SUBTOTAL(109,Maart[[Overuren    ]])","v":0}]
[null,"Totaal mrt.: Normale uren",{"$f":"SUM(Maart[[#Totals],[Week 1]],Maart[[#Totals],[Week 2]],Maart[[#Totals],[Week 3]],Maart[[#Totals],[Week 4]],Maart[[#Totals],[Week 5]])","v":0},"Totaal mrt.: Overuren",null,{"$f":"SUM(Maart[[#Totals],[Overuren]],Maart[[#Totals],[Overuren ]],Maart[[#Totals],[Overuren  ]],Maart[[#Totals],[Overuren   ]],Maart[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"April, mei, juni      Urenstaat voor werknemer per dag, week, maand en jaar"]
[null,"April","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,April[Week 1])","v":0},{"$f":"SUBTOTAL(109,April[Overuren])","v":0},{"$f":"SUBTOTAL(109,April[Week 2])","v":0},{"$f":"SUBTOTAL(109,April[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 3])","v":0},{"$f":"SUBTOTAL(109,April[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 4])","v":0},{"$f":"SUBTOTAL(109,April[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,April[Week 5])","v":0},{"$f":"SUBTOTAL(109,April[[Overuren    ]])","v":0}]
[null,"Totaal apr.: Normale uren",{"$f":"SUM(April[[#Totals],[Week 1]],April[[#Totals],[Week 2]],April[[#Totals],[Week 3]],April[[#Totals],[Week 4]],April[[#Totals],[Week 5]])","v":0},"Totaal apr.: Overuren",null,{"$f":"SUM(April[[#Totals],[Overuren]],April[[#Totals],[Overuren ]],April[[#Totals],[Overuren  ]],April[[#Totals],[Overuren   ]],April[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Mei","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Mei[Week 1])","v":0},{"$f":"SUBTOTAL(109,Mei[Overuren])","v":0},{"$f":"SUBTOTAL(109,Mei[Week 2])","v":0},{"$f":"SUBTOTAL(109,Mei[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Week 3])","v":0},{"$f":"SUBTOTAL(109,Mei[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Week 4])","v":0},{"$f":"SUBTOTAL(109,Mei[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Week 5])","v":0},{"$f":"SUBTOTAL(109,Mei[[Overuren    ]])","v":0}]
[null,"Totaal mei: Normale uren",{"$f":"SUM(Mei[[#Totals],[Week 1]],Mei[[#Totals],[Week 2]],Mei[[#Totals],[Week 3]],Mei[[#Totals],[Week 4]],Mei[[#Totals],[Week 5]])","v":0},"Totaal mei: Overuren",null,{"$f":"SUM(Mei[[#Totals],[Overuren]],Mei[[#Totals],[Overuren ]],Mei[[#Totals],[Overuren  ]],Mei[[#Totals],[Overuren   ]],Mei[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Juni","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Juni[Week 1])","v":0},{"$f":"SUBTOTAL(109,Juni[Overuren])","v":0},{"$f":"SUBTOTAL(109,Juni[Week 2])","v":0},{"$f":"SUBTOTAL(109,Juni[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Week 3])","v":0},{"$f":"SUBTOTAL(109,Juni[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Week 4])","v":0},{"$f":"SUBTOTAL(109,Juni[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Week 5])","v":0},{"$f":"SUBTOTAL(109,Juni[[Overuren    ]])","v":0}]
[null,"Totaal juni: Normale uren",{"$f":"SUM(Juni[[#Totals],[Week 1]],Juni[[#Totals],[Week 2]],Juni[[#Totals],[Week 3]],Juni[[#Totals],[Week 4]],Juni[[#Totals],[Week 5]])","v":0},"Totaal juni: Overuren",null,{"$f":"SUM(Juni[[#Totals],[Overuren]],Juni[[#Totals],[Overuren ]],Juni[[#Totals],[Overuren  ]],Juni[[#Totals],[Overuren   ]],Juni[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Juli, augustus, september      Urenstaat voor werknemer per dag, week, maand en jaar"]
[null,"Juli","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Juli[Week 1])","v":0},{"$f":"SUBTOTAL(109,Juli[Overuren])","v":0},{"$f":"SUBTOTAL(109,Juli[Week 2])","v":0},{"$f":"SUBTOTAL(109,Juli[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Week 3])","v":0},{"$f":"SUBTOTAL(109,Juli[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Week 4])","v":0},{"$f":"SUBTOTAL(109,Juli[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Week 5])","v":0},{"$f":"SUBTOTAL(109,Juli[[Overuren    ]])","v":0}]
[null,"Totaal juli: Normale uren",{"$f":"SUM(Juli[[#Totals],[Week 1]],Juli[[#Totals],[Week 2]],Juli[[#Totals],[Week 3]],Juli[[#Totals],[Week 4]],Juli[[#Totals],[Week 5]])","v":0},"Totaal juli: Overuren",null,{"$f":"SUM(Juli[[#Totals],[Overuren]],Juli[[#Totals],[Overuren ]],Juli[[#Totals],[Overuren  ]],Juli[[#Totals],[Overuren   ]],Juli[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Augustus","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Augustus[Week 1])","v":0},{"$f":"SUBTOTAL(109,Augustus[Overuren])","v":0},{"$f":"SUBTOTAL(109,Augustus[Week 2])","v":0},{"$f":"SUBTOTAL(109,Augustus[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Augustus[Week 3])","v":0},{"$f":"SUBTOTAL(109,Augustus[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Augustus[Week 4])","v":0},{"$f":"SUBTOTAL(109,Augustus[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Augustus[Week 5])","v":0},{"$f":"SUBTOTAL(109,Augustus[[Overuren    ]])","v":0}]
[null,"Totaal aug.: Normale uren",{"$f":"SUM(Augustus[[#Totals],[Week 1]],Augustus[[#Totals],[Week 2]],Augustus[[#Totals],[Week 3]],Augustus[[#Totals],[Week 4]],Augustus[[#Totals],[Week 5]])","v":0},"Totaal aug.: Overuren",null,{"$f":"SUM(Augustus[[#Totals],[Overuren]],Augustus[[#Totals],[Overuren ]],Augustus[[#Totals],[Overuren  ]],Augustus[[#Totals],[Overuren   ]],Augustus[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"September","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,September[Week 1])","v":0},{"$f":"SUBTOTAL(109,September[Overuren])","v":0},{"$f":"SUBTOTAL(109,September[Week 2])","v":0},{"$f":"SUBTOTAL(109,September[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 3])","v":0},{"$f":"SUBTOTAL(109,September[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 4])","v":0},{"$f":"SUBTOTAL(109,September[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,September[Week 5])","v":0},{"$f":"SUBTOTAL(109,September[[Overuren    ]])","v":0}]
[null,"Totaal sept.: Normale uren",{"$f":"SUM(September[[#Totals],[Week 1]],September[[#Totals],[Week 2]],September[[#Totals],[Week 3]],September[[#Totals],[Week 4]],September[[#Totals],[Week 5]])","v":0},"Totaal sept.: Overuren",null,{"$f":"SUM(September[[#Totals],[Overuren]],September[[#Totals],[Overuren ]],September[[#Totals],[Overuren  ]],September[[#Totals],[Overuren   ]],September[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"Oktober, november, december      Urenstaat voor werknemers per dag, week, maand en jaar"]
[null,"Oktober","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,Oktober[Week 1])","v":0},{"$f":"SUBTOTAL(109,Oktober[Overuren])","v":0},{"$f":"SUBTOTAL(109,Oktober[Week 2])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Week 3])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Week 4])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Week 5])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Overuren    ]])","v":0}]
[null,"Totaal okt.: Normale uren",{"$f":"SUM(Oktober[[#Totals],[Week 1]],Oktober[[#Totals],[Week 2]],Oktober[[#Totals],[Week 3]],Oktober[[#Totals],[Week 4]],Oktober[[#Totals],[Week 5]])","v":0},"Totaal okt.: Overuren",null,{"$f":"SUM(Oktober[[#Totals],[Overuren]],Oktober[[#Totals],[Overuren ]],Oktober[[#Totals],[Overuren  ]],Oktober[[#Totals],[Overuren   ]],Oktober[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"November","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,November[Week 1])","v":0},{"$f":"SUBTOTAL(109,November[Overuren])","v":0},{"$f":"SUBTOTAL(109,November[Week 2])","v":0},{"$f":"SUBTOTAL(109,November[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 3])","v":0},{"$f":"SUBTOTAL(109,November[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 4])","v":0},{"$f":"SUBTOTAL(109,November[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,November[Week 5])","v":0},{"$f":"SUBTOTAL(109,November[[Overuren    ]])","v":0}]
[null,"Totaal nov.: Normale uren",{"$f":"SUM(November[[#Totals],[Week 1]],November[[#Totals],[Week 2]],November[[#Totals],[Week 3]],November[[#Totals],[Week 4]],November[[#Totals],[Week 5]])","v":0},"Totaal nov.: Overuren",null,{"$f":"SUM(November[[#Totals],[Overuren]],November[[#Totals],[Overuren ]],November[[#Totals],[Overuren  ]],November[[#Totals],[Overuren   ]],November[[#Totals],[Overuren    ]])","v":0}]
[]
[null,"December","Week 1","Overuren","Week 2","Overuren ","Week 3","Overuren  ","Week 4","Overuren   ","Week 5","Overuren    "]
[null,"Maandag"]
[null,"Dinsdag"]
[null,"Woensdag"]
[null,"Donderdag"]
[null,"Vrijdag"]
[null,"Zaterdag"]
[null,"Zondag"]
[null,"Weektotaal uren",{"$f":"SUBTOTAL(109,December[Week 1])","v":0},{"$f":"SUBTOTAL(109,December[Overuren])","v":0},{"$f":"SUBTOTAL(105,December[Week 2])","v":0},{"$f":"SUBTOTAL(109,December[[Overuren ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 3])","v":0},{"$f":"SUBTOTAL(109,December[[Overuren  ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 4])","v":0},{"$f":"SUBTOTAL(109,December[[Overuren   ]])","v":0},{"$f":"SUBTOTAL(109,December[Week 5])","v":0},{"$f":"SUBTOTAL(109,December[[Overuren    ]])","v":0}]
[null,"Totaal dec.: Normale uren",{"$f":"SUM(December[[#Totals],[Week 1]],December[[#Totals],[Week 2]],December[[#Totals],[Week 3]],December[[#Totals],[Week 4]],December[[#Totals],[Week 5]])","v":0},"Totaal dec.: Overuren",null,{"$f":"SUM(December[[#Totals],[Overuren]],December[[#Totals],[Overuren ]],December[[#Totals],[Overuren  ]],December[[#Totals],[Overuren   ]],December[[#Totals],[Overuren    ]])","v":0}]