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

{"sheet":"Jahresarbeitszeittabelle","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,"Zeiterfassungskarte für Mitarbeiter"]
[]
[null,"Name des Mitarbeiters:",null,"E-Mail:",null,null,"Summen Jahr bis Datum:"]
[null,"Vorgesetzter:",null,"Telefon:",null,null,"Reguläre Std.:",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"Überstunden:",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"Summe:",{"$f":"SUM(H4:J4)","v":0}]
[]
[null,"Januar, Februar, März      Zeiterfassungskarte für Mitarbeiter: Täglich, wöchentlich, monatlich, jährlich"]
[null,"Januar","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Januar[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Januar[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Januar[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Januar[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Januar[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Januar[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Januar[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Januar[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Januar[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Januar[[   Überstunden    ]])","v":0}]
[null,"Summe Jan: Reguläre Arbeitsstunden",{"$f":"SUM(Januar[[#Totals],[Woche 1]],Januar[[#Totals],[Woche 2]],Januar[[#Totals],[Woche 3]],Januar[[#Totals],[Woche 4]],Januar[[#Totals],[Woche 5]])","v":0},"Summe Jan: Überstunden",null,{"$f":"SUM(Januar[[#Totals],[Überstunden]],Januar[[#Totals],[Überstunden ]],Januar[[#Totals],[Überstunden  ]],Januar[[#Totals],[  Überstunden   ]],Januar[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Februar","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Februar[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Februar[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Februar[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Februar[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Februar[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Februar[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Februar[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Februar[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Februar[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Februar[[   Überstunden    ]])","v":0}]
[null,"Summe Feb: Reguläre Arbeitsstunden",{"$f":"SUM(Februar[[#Totals],[Woche 1]],Februar[[#Totals],[Woche 2]],Februar[[#Totals],[Woche 3]],Februar[[#Totals],[Woche 4]],Februar[[#Totals],[Woche 5]])","v":0},"Summe Feb: Überstunden",null,{"$f":"SUM(Februar[[#Totals],[Überstunden]],Februar[[#Totals],[Überstunden ]],Februar[[#Totals],[Überstunden  ]],Februar[[#Totals],[  Überstunden   ]],Februar[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"März","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,März[Woche 1])","v":0},{"$f":"SUBTOTAL(109,März[Überstunden])","v":0},{"$f":"SUBTOTAL(109,März[Woche 2])","v":0},{"$f":"SUBTOTAL(109,März[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,März[Woche 3])","v":0},{"$f":"SUBTOTAL(109,März[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,März[Woche 4])","v":0},{"$f":"SUBTOTAL(109,März[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,März[Woche 5])","v":0},{"$f":"SUBTOTAL(109,März[[   Überstunden    ]])","v":0}]
[null,"Summe Mrz: Reguläre Arbeitsstunden",{"$f":"SUM(März[[#Totals],[Woche 1]],März[[#Totals],[Woche 2]],März[[#Totals],[Woche 3]],März[[#Totals],[Woche 4]],März[[#Totals],[Woche 5]])","v":0},"Summe Mrz: Überstunden",null,{"$f":"SUM(März[[#Totals],[Überstunden]],März[[#Totals],[Überstunden ]],März[[#Totals],[Überstunden  ]],März[[#Totals],[  Überstunden   ]],März[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"April, Mai, Juni      Zeiterfassungskarte für Mitarbeiter: Täglich, wöchentlich, monatlich, jährlich"]
[null,"April","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,April[Woche 1])","v":0},{"$f":"SUBTOTAL(109,April[Überstunden])","v":0},{"$f":"SUBTOTAL(109,April[Woche 2])","v":0},{"$f":"SUBTOTAL(109,April[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,April[Woche 3])","v":0},{"$f":"SUBTOTAL(109,April[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,April[Woche 4])","v":0},{"$f":"SUBTOTAL(109,April[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,April[Woche 5])","v":0},{"$f":"SUBTOTAL(109,April[[   Überstunden    ]])","v":0}]
[null,"Summe Apr: Reguläre Arbeitsstunden",{"$f":"SUM(April[[#Totals],[Woche 1]],April[[#Totals],[Woche 2]],April[[#Totals],[Woche 3]],April[[#Totals],[Woche 4]],April[[#Totals],[Woche 5]])","v":0},"Summe Apr: Überstunden",null,{"$f":"SUM(April[[#Totals],[Überstunden]],April[[#Totals],[Überstunden ]],April[[#Totals],[Überstunden  ]],April[[#Totals],[  Überstunden   ]],April[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Mai","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Mai[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Mai[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Mai[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Mai[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Mai[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Mai[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Mai[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Mai[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Mai[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Mai[[   Überstunden    ]])","v":0}]
[null,"Summe Mai: Reguläre Arbeitsstunden",{"$f":"SUM(Mai[[#Totals],[Woche 1]],Mai[[#Totals],[Woche 2]],Mai[[#Totals],[Woche 3]],Mai[[#Totals],[Woche 4]],Mai[[#Totals],[Woche 5]])","v":0},"Summe Mai: Überstunden",null,{"$f":"SUM(Mai[[#Totals],[Überstunden]],Mai[[#Totals],[Überstunden ]],Mai[[#Totals],[Überstunden  ]],Mai[[#Totals],[  Überstunden   ]],Mai[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Juni","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Juni[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Juni[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Juni[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Juni[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Juni[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Juni[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Juni[[   Überstunden    ]])","v":0}]
[null,"Summe Jun: Reguläre Arbeitsstunden",{"$f":"SUM(Juni[[#Totals],[Woche 1]],Juni[[#Totals],[Woche 2]],Juni[[#Totals],[Woche 3]],Juni[[#Totals],[Woche 4]],Juni[[#Totals],[Woche 5]])","v":0},"Summe Jun: Überstunden",null,{"$f":"SUM(Juni[[#Totals],[Überstunden]],Juni[[#Totals],[Überstunden ]],Juni[[#Totals],[Überstunden  ]],Juni[[#Totals],[  Überstunden   ]],Juni[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Juli, August, September      Zeiterfassungskarte für Mitarbeiter: Täglich, wöchentlich, monatlich, jährlich"]
[null,"Juli","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Juli[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Juli[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Juli[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Juli[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Juli[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Juli[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Juli[[   Überstunden    ]])","v":0}]
[null,"Summe Jul: Reguläre Arbeitsstunden",{"$f":"SUM(Juli[[#Totals],[Woche 1]],Juli[[#Totals],[Woche 2]],Juli[[#Totals],[Woche 3]],Juli[[#Totals],[Woche 4]],Juli[[#Totals],[Woche 5]])","v":0},"Summe Jul: Überstunden",null,{"$f":"SUM(Juli[[#Totals],[Überstunden]],Juli[[#Totals],[Überstunden ]],Juli[[#Totals],[Überstunden  ]],Juli[[#Totals],[  Überstunden   ]],Juli[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"August","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,August[Woche 1])","v":0},{"$f":"SUBTOTAL(109,August[Überstunden])","v":0},{"$f":"SUBTOTAL(109,August[Woche 2])","v":0},{"$f":"SUBTOTAL(109,August[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,August[Woche 3])","v":0},{"$f":"SUBTOTAL(109,August[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,August[Woche 4])","v":0},{"$f":"SUBTOTAL(109,August[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,August[Woche 5])","v":0},{"$f":"SUBTOTAL(109,August[[   Überstunden    ]])","v":0}]
[null,"Summe Aug: Reguläre Arbeitsstunden",{"$f":"SUM(August[[#Totals],[Woche 1]],August[[#Totals],[Woche 2]],August[[#Totals],[Woche 3]],August[[#Totals],[Woche 4]],August[[#Totals],[Woche 5]])","v":0},"Summe Aug: Überstunden",null,{"$f":"SUM(August[[#Totals],[Überstunden]],August[[#Totals],[Überstunden ]],August[[#Totals],[Überstunden  ]],August[[#Totals],[  Überstunden   ]],August[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"September","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,September[Woche 1])","v":0},{"$f":"SUBTOTAL(109,September[Überstunden])","v":0},{"$f":"SUBTOTAL(109,September[Woche 2])","v":0},{"$f":"SUBTOTAL(109,September[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,September[Woche 3])","v":0},{"$f":"SUBTOTAL(109,September[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,September[Woche 4])","v":0},{"$f":"SUBTOTAL(109,September[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,September[Woche 5])","v":0},{"$f":"SUBTOTAL(109,September[[   Überstunden    ]])","v":0}]
[null,"Summe Sep: Reguläre Arbeitsstunden",{"$f":"SUM(September[[#Totals],[Woche 1]],September[[#Totals],[Woche 2]],September[[#Totals],[Woche 3]],September[[#Totals],[Woche 4]],September[[#Totals],[Woche 5]])","v":0},"Summe Sep: Überstunden",null,{"$f":"SUM(September[[#Totals],[Überstunden]],September[[#Totals],[Überstunden ]],September[[#Totals],[Überstunden  ]],September[[#Totals],[  Überstunden   ]],September[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Oktober, November, Dezember      Zeiterfassungskarte für Mitarbeiter: Täglich, wöchentlich, monatlich, jährlich"]
[null,"Oktober","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Oktober[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Oktober[Überstunden])","v":0},{"$f":"SUBTOTAL(109,Oktober[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Oktober[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Oktober[[   Überstunden    ]])","v":0}]
[null,"Summe Okt: Reguläre Arbeitsstunden",{"$f":"SUM(Oktober[[#Totals],[Woche 1]],Oktober[[#Totals],[Woche 2]],Oktober[[#Totals],[Woche 3]],Oktober[[#Totals],[Woche 4]],Oktober[[#Totals],[Woche 5]])","v":0},"Summe Okt: Überstunden",null,{"$f":"SUM(Oktober[[#Totals],[Überstunden]],Oktober[[#Totals],[Überstunden ]],Oktober[[#Totals],[Überstunden  ]],Oktober[[#Totals],[  Überstunden   ]],Oktober[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"November","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,November[Woche 1])","v":0},{"$f":"SUBTOTAL(109,November[Überstunden])","v":0},{"$f":"SUBTOTAL(109,November[Woche 2])","v":0},{"$f":"SUBTOTAL(109,November[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,November[Woche 3])","v":0},{"$f":"SUBTOTAL(109,November[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,November[Woche 4])","v":0},{"$f":"SUBTOTAL(109,November[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,November[Woche 5])","v":0},{"$f":"SUBTOTAL(109,November[[   Überstunden    ]])","v":0}]
[null,"Summe Nov: Reguläre Arbeitsstunden",{"$f":"SUM(November[[#Totals],[Woche 1]],November[[#Totals],[Woche 2]],November[[#Totals],[Woche 3]],November[[#Totals],[Woche 4]],November[[#Totals],[Woche 5]])","v":0},"Summe Nov: Überstunden",null,{"$f":"SUM(November[[#Totals],[Überstunden]],November[[#Totals],[Überstunden ]],November[[#Totals],[Überstunden  ]],November[[#Totals],[  Überstunden   ]],November[[#Totals],[   Überstunden    ]])","v":0}]
[]
[null,"Dezember","Woche 1","Überstunden","Woche 2","Überstunden ","Woche 3","Überstunden  ","Woche 4","  Überstunden   ","Woche 5","   Überstunden    "]
[null,"Montag"]
[null,"Dienstag"]
[null,"Mittwoch"]
[null,"Donnerstag"]
[null,"Freitag"]
[null,"Samstag"]
[null,"Sonntag"]
[null,"Wöchentliche Stunden gesamt",{"$f":"SUBTOTAL(109,Dezember[Woche 1])","v":0},{"$f":"SUBTOTAL(109,Dezember[Überstunden])","v":0},{"$f":"SUBTOTAL(105,Dezember[Woche 2])","v":0},{"$f":"SUBTOTAL(109,Dezember[[Überstunden ]])","v":0},{"$f":"SUBTOTAL(109,Dezember[Woche 3])","v":0},{"$f":"SUBTOTAL(109,Dezember[[Überstunden  ]])","v":0},{"$f":"SUBTOTAL(109,Dezember[Woche 4])","v":0},{"$f":"SUBTOTAL(109,Dezember[[  Überstunden   ]])","v":0},{"$f":"SUBTOTAL(109,Dezember[Woche 5])","v":0},{"$f":"SUBTOTAL(109,Dezember[[   Überstunden    ]])","v":0}]
[null,"Summe Dez: Reguläre Arbeitsstunden",{"$f":"SUM(Dezember[[#Totals],[Woche 1]],Dezember[[#Totals],[Woche 2]],Dezember[[#Totals],[Woche 3]],Dezember[[#Totals],[Woche 4]],Dezember[[#Totals],[Woche 5]])","v":0},"Summe Dez: Überstunden",null,{"$f":"SUM(Dezember[[#Totals],[Überstunden]],Dezember[[#Totals],[Überstunden ]],Dezember[[#Totals],[Überstunden  ]],Dezember[[#Totals],[  Überstunden   ]],Dezember[[#Totals],[   Überstunden    ]])","v":0}]