{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Januar(1)","Februar(2)","März(3)","April(4)","MW Stunden"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Januar(1)","index":0,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,0,0,4],[0,6,0,9],[1,0,1,1],[1,2,1,3],[1,7,1,9],[42,3,42,4],[42,7,42,8],[43,0,43,1],[43,7,43,8],[3,3,3,4],[5,0,5,1],[6,0,6,1],[7,2,7,3],[40,2,40,3],[41,2,41,3]]}
["Stundenerfassung"]
["Mitarbeiter:",null,null,null,null,null,null,"Jahr:",null,null,2026]
["Vorname:",null,null,null,null,null,null,"Monat:",null,null,"Januar"]
[null,null,null,"Urlaubstage  ",null,{"$f":"SUM(K2)","v":2026},null,"Tage"]
[null,null,null,null,"Vorjahr",null,0,"Tage"]
["Arbeitszeit/Monat:",null,{"$f":"SUMPRODUCT((IF(B10:B40=\"Montag\",1,0)+(IF(B10:B40=\"Dienstag\",1,0)+(IF(B10:B40=\"Mittwoch\",1,0)+(IF(B10:B40=\"Donnerstag\",1,0)+(IF(B10:B40=\"Freitag\",1,0)))))))*G6","v":176},"h",null,"U,K,F",8,"h"]
["Üzeit  Vormonat:",null,0.5,"h",null,"Pause",0.5,"h"]
[null,null,"Arbeitszeit"]
[null,null,"kommt","geht","Stunden","keine Pause"," UKF","U","K","F","Bemerkungen:"]
["2017-01-01","Donnerstag",null,null,{"$f":"SUM(G10)","v":8},null,{"$f":"IF(O10=1,$G$6,\"\")","v":8},null,null,1,null,null,null,null,{"$f":"IF(SUM(H10:J10)>=1,1,\"\")","v":1}]
["2017-01-02","Freitag",null,null,{"$f":"SUM(G11)","v":8},null,{"$f":"IF(O11=1,$G$6,\"\")","v":8},1,null,null,null,null,null,null,1]
["2010-01-03","Samstag",null,null,{"$f":"SUBTOTAL(9,E7:E11)","v":16},{"$f":"AVERAGEIF(E7:E11,\">0\")","v":8},"",null,null,null,null,null,null,null,""]
["2010-01-04","Sonntag",null,null,{"$f":"IF(D13=0,0,((TRUNC(D13))*60+100*(D13-TRUNC(D13))-((TRUNC(C13))*60+100*(C13-TRUNC(C13))))/60-$G$7)+F13","v":0},null,"",null,null,null,null,null,null,null,""]
["2010-01-05","Montag",11.15,17.45,6,null,"",null,null,null,null,null,null,null,""]
["2010-01-06","Dienstag",10,18,7.5,null,"",null,null,null,null,null,null,null,""]
["2010-01-07","Mittwoch",8.4499999999999993,18.3,9.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-08","Donnerstag",8.4499999999999993,17.3,8.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-09","Freitag",9,19,9,-0.5,"",null,null,null,null,null,null,null,""]
["2010-01-10","Samstag",null,null,{"$f":"SUBTOTAL(9,E14:E18)","v":40},{"$f":"AVERAGEIF(E14:E18,\">0\")","v":8},"",null,null,null,null,null,null,null,""]
["2010-01-11","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-01-12","Montag",9,17.3,8,null,"",null,null,null,null,null,null,null,""]
["2010-01-13","Dienstag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-01-14","Mittwoch",8.4499999999999993,17.45,8.5000000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-15","Donnerstag",8.4499999999999993,17.45,8.5000000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-16","Freitag",8.4499999999999993,17.149999999999999,7.9999999999999982,null,"",null,null,null,null,null,null,null,""]
["2010-01-17","Samstag",null,null,{"$f":"SUBTOTAL(9,E21:E25)","v":41.5},{"$f":"AVERAGEIF(E21:E25,\">0\")","v":8.3000000000000007},"",null,null,null,null,null,null,null,""]
["2010-01-18","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-01-19","Montag",8.3000000000000007,18,8.5,-0.5,"",null,null,null,null,null,null,null,""]
["2010-01-20","Dienstag",8.4499999999999993,18,8.7500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-21","Mittwoch",9.3000000000000007,18,7.9999999999999982,null,"",null,null,null,null,null,null,null,""]
["2010-01-22","Donnerstag",8.4499999999999993,18,8.7500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-23","Freitag",8.4499999999999993,17,7.7500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-24","Samstag",null,null,{"$f":"SUBTOTAL(9,E28:E32)","v":41.75},{"$f":"AVERAGEIF(E28:E32,\">0\")","v":8.35},"",null,null,null,null,null,null,null,""]
["2010-01-25","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-01-26","Montag",8.4499999999999993,17.3,8.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-27","Dienstag",8.4499999999999993,17.45,8.5000000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-28","Mittwoch",9.3000000000000007,18.3,8.4999999999999982,null,"",null,null,null,null,null,null,null,""]
["2010-01-29","Donnerstag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-01-30","Freitag",8.4499999999999993,17.3,8.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-01-31","Samstag",null,null,{"$f":"SUBTOTAL(9,E35:E39)","v":42},{"$f":"AVERAGEIF(E35:E39,\">0\")","v":8.4},"",null,null,null,null,null,null,null,""]
[null,null,"Gearbeitete Std:",null,{"$f":"SUBTOTAL(9,E10:E40)","v":181.25},{"$f":"SUM(F10:F40)","v":40.049999999999997},null,null,null,null,null,null,null,"Urlaub",{"$f":"SUM(H10:H40)","v":1}]
[null,null,"Gesamt Std:",null,{"$f":"SUM(E41+G41)","v":181.25},null,null,null,null,null,null,null,null,"Krank",{"$f":"SUM(I10:I40)","v":0}]
[null,null,null,"Überzeit Std:",null,{"$f":"IF(E42,E42-C6,0)","v":5.25},null,null,null,"Std.","Ü. Auszahlung"]
["Resturlaubstage Tage:",null,null,null,"Überzeitgesamt Std:",{"$f":"IF(C7+F43-H43,C7+F43-H43-H44,0)","v":5.75},null,null,null,"Std.","Ü. Abzug"]

{"sheet":"Februar(2)","index":1,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,0,0,4],[0,6,0,9],[1,0,1,1],[1,2,1,3],[1,7,1,9],[42,3,42,4],[42,7,42,8],[43,0,43,1],[43,7,43,8],[3,3,3,4],[5,0,5,1],[6,0,6,1],[7,2,7,3],[40,2,40,3],[41,2,41,3]]}
["Stundenerfassung"]
["Mitarbeiter:",null,null,null,null,null,null,"Jahr:",null,null,{"$f":"SUM('Januar(1)'!K2)","v":2026}]
["Vorname:",null,null,null,null,null,null,"Monat:",null,null,"Februar"]
[null,null,null,"Urlaubstage  ",null,{"$f":"SUM(K2)","v":2026},{"$f":"SUM('Januar(1)'!C44)","v":0},"Tage"]
[]
["Arbeitszeit/Monat:",null,{"$f":"SUMPRODUCT((IF(B10:B40=\"Montag\",1,0)+(IF(B10:B40=\"Dienstag\",1,0)+(IF(B10:B40=\"Mittwoch\",1,0)+(IF(B10:B40=\"Donnerstag\",1,0)+(IF(B10:B40=\"Freitag\",1,0)))))))*G6","v":160},"h",null,"U,K,F",8,"h"]
["Üzeit  Vormonat:",null,{"$f":"SUM('Januar(1)'!F44)","v":5.75},"h",null,"Pause",0.5,"h"]
[null,null,"Arbeitszeit"]
[null,null,"kommt","geht","Stunden","keine Pause"," UKF","U","K","F","Bemerkungen:"]
["2010-02-01","Sonntag",null,null,{"$f":"IF(D10=0,0,((TRUNC(D10))*60+100*(D10-TRUNC(D10))-((TRUNC(C10))*60+100*(C10-TRUNC(C10))))/60-$G$7)-F10","v":0},null,{"$f":"IF(O10=1,$G$6,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(SUM(H10:J10)>=1,1,\"\")","v":""}]
["2010-02-02","Montag",8.3000000000000007,17.45,{"$f":"IF(D11=0,0,((TRUNC(D11))*60+100*(D11-TRUNC(D11))-((TRUNC(C11))*60+100*(C11-TRUNC(C11))))/60-$G$7)-F11","v":8.75},null,{"$f":"IF(O11=1,$G$6,\"\")","v":""},null,null,null,null,null,null,null,""]
["2010-02-03","Dienstag",8.3000000000000007,17.149999999999999,8.2499999999999964,null,"",null,null,null,null,null,null,null,""]
["2010-02-04","Mittwoch",8.4499999999999993,17.3,8.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-02-05","Donnerstag",8.4499999999999993,18.45,10.000000000000002,-0.5,"",null,null,null,null,null,null,null,""]
["2010-02-06","Freitag",9.4499999999999993,18,7.7500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-02-07","Samstag",null,null,{"$f":"SUBTOTAL(9,E11:E15)","v":43},{"$f":"AVERAGEIF(E11:E15,\">0\")","v":8.6},"",null,null,null,null,null,null,null,""]
["2010-02-08","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-02-09","Montag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-10","Dienstag",9,17.3,8,null,"",null,null,null,null,null,null,null,""]
["2010-02-11","Mittwoch",8.4499999999999993,17.149999999999999,7.9999999999999982,null,"",null,null,null,null,null,null,null,""]
["2010-02-12","Donnerstag",13,18,4.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-13","Freitag",8.4499999999999993,18,8.7500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-02-14","Samstag",null,null,{"$f":"SUBTOTAL(9,E18:E22)","v":37.75},{"$f":"AVERAGEIF(E18:E22,\">0\")","v":7.55},"",null,null,null,null,null,null,null,""]
["2010-02-15","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-02-16","Montag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-17","Dienstag",8.4499999999999993,17.45,8.5000000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-02-18","Mittwoch",8.4499999999999993,17.3,8.2500000000000018,null,"",null,null,null,null,null,null,null,""]
["2010-02-19","Donnerstag",9,17.3,8,null,"",null,null,null,null,null,null,null,""]
["2010-02-20","Freitag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-21","Samstag",null,null,{"$f":"SUBTOTAL(9,E25:E29)","v":41.75},{"$f":"AVERAGEIF(E25:E29,\">0\")","v":8.35},"",null,null,null,null,null,null,null,""]
["2010-02-22","Sonntag",null,null,0,null,"",null,null,null,null,null,null,null,""]
["2010-02-23","Montag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-24","Dienstag",8.4499999999999993,18.3,9.7500000000000018,-0.5,"",null,null,null,null,null,null,null,""]
["2010-02-25","Mittwoch",10,17.45,7.25,null,"",null,null,null,null,null,null,null,""]
["2010-02-26","Donnerstag",9,18.3,9,null,"",null,null,null,null,null,null,null,""]
["2010-02-27","Freitag",9,18,8.5,null,"",null,null,null,null,null,null,null,""]
["2010-02-28","Samstag",null,null,{"$f":"SUBTOTAL(9,E32:E36)","v":43},{"$f":"AVERAGEIF(E32:E36,\">0\")","v":8.6},"",null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(O39=1,G6,\"\")","v":""},null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(O40=1,G6,\"\")","v":""},null,null,null,null,null,null,null,""]
[null,null,"Gearbeitete Std:",null,{"$f":"SUBTOTAL(9,E10:E40)","v":165.5},{"$f":"SUM(F10:F40)","v":32.1},null,null,null,null,null,null,null,"Urlaub",{"$f":"SUM(H10:H40)","v":0}]
[null,null,"Gesamt Std:",null,{"$f":"SUM(E41+G41)","v":165.5},null,null,null,null,null,null,null,null,"Krank",{"$f":"SUM(I10:I40)","v":0}]
[null,null,null,"Überzeit Std:",null,{"$f":"IF(E42,E42-C6,0)","v":5.5},null,null,null,"Std.","Ü. Auszahlung",null,null,"Krank ges.",{"$f":"SUM(O42+'Januar(1)'!O43)","v":0}]
["Resturlaubstage Tage:",null,{"$f":"SUM(G4+G5-O41)","v":0},null,"Überzeitgesamt Std:",{"$f":"IF(C7+F43-H43,C7+F43-H43-H44,0)","v":11.25},null,null,null,"Std.","Ü. Abzug"]

{"sheet":"März(3)","index":2,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,2,2,3],[2,7,2,9],[0,0,0,4],[0,6,0,9],[1,0,1,1],[1,2,1,3],[1,7,1,9],[46,0,46,2],[46,4,46,10],[43,5,43,10],[43,0,43,1],[3,3,3,4],[5,0,5,1],[6,0,6,1],[7,2,7,3],[40,2,40,3],[41,2,41,3]]}
["Stundenerfassung"]
["Mitarbeiter:",null,null,null,null,null,null,"Jahr:",null,null,{"$f":"SUM('Februar(2)'!K2)","v":2026}]
["Vorname:",null,null,null,null,null,null,"Monat:",null,null,"März"]
[null,null,null,"Urlaubstage  ",null,{"$f":"SUM(K2)","v":2026},null,"Tage"]
[]
[]
["Üzeit  Vormonat:",null,null,"h",null,"Pause",0.5,"h"]
[null,null,"Arbeitszeit"]
[null,null,"kommt","geht","Stunden","keine Pause"," UKF","U","K","F","Bemerkungen:"]
["2010-03-01","Sonntag",null,null,{"$f":"IF(D10=0,0,((TRUNC(D10))*60+100*(D10-TRUNC(D10))-((TRUNC(C10))*60+100*(C10-TRUNC(C10))))/60-$G$7)+F10","v":0},null,{"$f":"IF(N10=1,$G$6,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(H10:J10)>=1,1,\"\")","v":""}]
["2010-03-02","Montag",9.15,17.3,{"$f":"IF(D11=0,0,((TRUNC(D11))*60+100*(D11-TRUNC(D11))-((TRUNC(C11))*60+100*(C11-TRUNC(C11))))/60-$G$7)+F11","v":7.75},null,{"$f":"IF(N11=1,$G$6,\"\")","v":""},null,null,null,null,null,null,""]
["2010-03-03","Dienstag",9,18.3,8.5,-0.5,"",null,null,null,null,null,null,""]
["2010-03-04","Mittwoch",9.15,18,8.25,null,"",null,null,null,null,null,null,""]
["2010-03-05","Donnerstag",9.15,18.149999999999999,8.4999999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-06","Freitag",9,18.149999999999999,8.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-07","Samstag",null,null,{"$f":"SUBTOTAL(9,E11:E15)","v":41.75},{"$f":"AVERAGEIF(E11:E15,\">0\")","v":8.35},"",null,null,null,null,null,null,""]
["2010-03-08","Sonntag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-09","Montag",9,18.3,8.5,-0.5,"",null,null,null,null,null,null,""]
["2010-03-10","Dienstag",9,18,8.5,null,"",null,null,null,null,null,null,""]
["2010-03-11","Mittwoch",9,17.3,8,null,"",null,null,null,null,null,null,""]
["2010-03-12","Donnerstag",9,18.149999999999999,8.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-13","Freitag",9,18.149999999999999,8.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-14","Samstag",null,null,{"$f":"SUBTOTAL(9,E18:E22)","v":42.5},{"$f":"AVERAGEIF(E18:E22,\">0\")","v":8.5},"",null,null,null,null,null,null,""]
["2010-03-15","Sonntag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-16","Montag",8.4499999999999993,18.3,9.2500000000000018,null,"",null,null,null,null,null,null,""]
["2010-03-17","Dienstag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-18","Mittwoch",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-19","Donnerstag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-20","Freitag",11,18.149999999999999,6.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-21","Samstag",null,null,{"$f":"SUBTOTAL(9,E25:E29)","v":15.999999999999998},{"$f":"AVERAGEIF(E25:E29,\">0\")","v":7.9999999999999991},"",null,null,null,null,null,null,""]
["2010-03-22","Sonntag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-23","Montag",9,15.3,6.0000000000000018,null,"",null,null,null,null,null,null,""]
["2010-03-24","Dienstag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-25","Mittwoch",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-26","Donnerstag",12,18.149999999999999,5.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-27","Freitag",14,18.149999999999999,3.7499999999999964,null,"",null,null,null,null,null,null,""]
["2010-03-28","Samstag",null,null,{"$f":"SUBTOTAL(9,E32:E36)","v":15.499999999999995},{"$f":"AVERAGEIF(E32:E36,\">0\")","v":5.1666666666666652},"",null,null,null,null,null,null,""]
["2010-03-29","Sonntag",null,null,0,null,"",null,null,null,null,null,null,""]
["2010-03-30","Montag",9.3000000000000007,18.45,8.7499999999999982,null,"",null,null,null,null,null,null,""]
["2010-03-31","Dienstag",null,null,0,null,""]
[null,null,"Gearbeitete Std:",null,{"$f":"SUBTOTAL(9,E10:E40)","v":124.5},{"$f":"SUBTOTAL(9,F11:F15,F18:F22,F25:F29,F32:F36,F39:F40)","v":-1},{"$f":"SUM(G10:G40)","v":0}]
[null,null,"Gesamt Std:",null,{"$f":"SUM(E41+G41)","v":124.5}]
[]
["Resturlaubstage Tage:",null,null,null,{"$f":"AVERAGE(E16,E23,E30,E37)","v":28.9375},"Mittelwert der wöchentlichen Arbeits-Std."]

{"sheet":"April(4)","index":3,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,5,43,10],[2,0,2,1],[2,2,2,3],[2,7,2,9],[3,3,3,4],[5,0,5,1],[43,0,43,1],[6,0,6,1],[7,2,7,3],[40,2,40,3],[41,2,41,3],[0,0,0,4],[0,6,0,9],[1,0,1,1],[1,2,1,3],[1,7,1,9]]}
["Stundenerfassung"]
["Mitarbeiter:",null,{"$f":"HYPERLINK('März(3)'!C2:D2)","v":""},null,null,null,null,"Jahr:",null,null,{"$f":"SUM('März(3)'!K2)","v":2026}]
["Vorname:",null,{"$f":"HYPERLINK('März(3)'!C3:D3)","v":""},null,null,null,null,"Monat:",null,null,"April"]
[null,null,null,"Urlaubstage  ",null,{"$f":"SUM(K2)","v":2026},{"$f":"SUM('März(3)'!C44)","v":0},"Tage"]
[]
[]
["Üzeit  Vormonat:",null,{"$f":"SUM('März(3)'!F44)","v":0},"h",null,"Pause",0.5,"h"]
[null,null,"Arbeitszeit"]
[null,null,"kommt","geht","Stunden","keine Pause"," UKF","U","K","F","Bemerkungen:"]
["2010-04-01","Mittwoch",null,null,{"$f":"IF(D10=0,0,((TRUNC(D10))*60+100*(D10-TRUNC(D10))-((TRUNC(C10))*60+100*(C10-TRUNC(C10))))/60-$G$7)+F10","v":0},null,{"$f":"IF(N10=1,$G$6,\"\")","v":""}]
["2010-04-02","Donnerstag",null,null,{"$f":"IF(D11=0,0,((TRUNC(D11))*60+100*(D11-TRUNC(D11))-((TRUNC(C11))*60+100*(C11-TRUNC(C11))))/60-$G$7)+F11","v":0},null,{"$f":"IF(N11=1,$G$6,\"\")","v":""}]
["2010-04-03","Freitag",null,null,{"$f":"SUM(G12)","v":8},null,{"$f":"SUM('MW Stunden'!C16)","v":8},null,null,1]
["2010-04-04","Samstag",null,null,{"$f":"SUBTOTAL(9,E10:E12,'März(3)'!E39)","v":16.75},null,""]
["2010-04-05","Sonntag",null,null,0,null,""]
["2010-04-06","Montag",null,null,{"$f":"SUM(G15)","v":7.7638888888888893},null,{"$f":"SUM('MW Stunden'!C17)","v":7.7638888888888893},null,null,1]
["2010-04-07","Dienstag",null,null,0,null,""]
["2010-04-08","Mittwoch",null,null,0,null,""]
["2010-04-09","Donnerstag",null,null,0,null,""]
["2010-04-10","Freitag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H19:J19)>=1,1,\"\")","v":""}]
["2010-04-11","Samstag",null,null,{"$f":"SUBTOTAL(9,E15:E19)","v":7.7638888888888893},{"$f":"AVERAGEIF(E15:E19,\">0\")","v":7.7638888888888893},"",null,null,null,null,null,null,{"$f":"IF(SUM(H20:J20)>=1,1,\"\")","v":""}]
["2010-04-12","Sonntag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H21:J21)>=1,1,\"\")","v":""}]
["2010-04-13","Montag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H22:J22)>=1,1,\"\")","v":""}]
["2010-04-14","Dienstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H23:J23)>=1,1,\"\")","v":""}]
["2010-04-15","Mittwoch",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H24:J24)>=1,1,\"\")","v":""}]
["2010-04-16","Donnerstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H25:J25)>=1,1,\"\")","v":""}]
["2010-04-17","Freitag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H26:J26)>=1,1,\"\")","v":""}]
["2010-04-18","Samstag",null,null,{"$f":"SUBTOTAL(9,E22:E26)","v":0},{"$f":"AVERAGEIF(E22:E26,\">0\")","v":{"$error":"#DIV/0!"}},"",null,null,null,null,null,null,{"$f":"IF(SUM(H27:J27)>=1,1,\"\")","v":""}]
["2010-04-19","Sonntag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H28:J28)>=1,1,\"\")","v":""}]
["2010-04-20","Montag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H29:J29)>=1,1,\"\")","v":""}]
["2010-04-21","Dienstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H30:J30)>=1,1,\"\")","v":""}]
["2010-04-22","Mittwoch",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H31:J31)>=1,1,\"\")","v":""}]
["2010-04-23","Donnerstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H32:J32)>=1,1,\"\")","v":""}]
["2010-04-24","Freitag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H33:J33)>=1,1,\"\")","v":""}]
["2010-04-25","Samstag",null,null,{"$f":"SUBTOTAL(9,E29:E33)","v":0},{"$f":"AVERAGEIF(E29:E33,\">0\")","v":{"$error":"#DIV/0!"}},"",null,null,null,null,null,null,{"$f":"IF(SUM(H34:J34)>=1,1,\"\")","v":""}]
["2010-04-26","Sonntag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H35:J35)>=1,1,\"\")","v":""}]
["2010-04-27","Montag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H36:J36)>=1,1,\"\")","v":""}]
["2010-04-28","Dienstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H37:J37)>=1,1,\"\")","v":""}]
["2010-04-29","Mittwoch",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H38:J38)>=1,1,\"\")","v":""}]
["2010-04-30","Donnerstag",null,null,0,null,"",null,null,null,null,null,null,{"$f":"IF(SUM(H39:J39)>=1,1,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(N40=1,G6,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(H40:J40)>=1,1,\"\")","v":""}]
[null,null,"Gearbeitete Std:",null,{"$f":"SUBTOTAL(9,E10:E40)","v":15.763888888888889},{"$f":"SUBTOTAL(9,F10:F12,F15:F19,F22:F26,F29:F33,F36:F39)","v":0},null,null,null,null,null,null,"Urlaub",{"$f":"SUM(H10:H40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Krank",{"$f":"SUM(I10:I40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Krank ges.",{"$f":"SUM(N42+'März(3)'!N43)","v":0}]
["Resturlaubstage Tage:",null,{"$f":"SUM(G4+G5-N41)","v":0},null,{"$f":"AVERAGE(E16,E23,E30,E37)","v":0},"Mittelwert der wöchentlichen Arbeits-Std."]

{"sheet":"MW Stunden","index":4,"n_rows":56,"n_cols":3,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Ermittlung Mittelwert der Stunden "]
[]
[null,"Mittelwert","Mittelwert 12 Wochen"]
["KW 1",8]
["KW 2",8]
["KW 3",8]
["KW 4",8]
["KW 5",8]
["KW 6",8]
["KW 7",8]
["KW 8",8]
["KW 9",8]
["KW 10",8]
["KW 11",8]
["KW 12",{"$f":"SUM('März(3)'!F30)","v":7.9999999999999991}]
["KW 13",{"$f":"SUM('März(3)'!F37)","v":5.1666666666666652},{"$f":"AVERAGE(B4:B15)","v":8}]
["KW 14",{"$f":"SUM('April(4)'!F13)","v":0},{"$f":"AVERAGE(B5:B16)","v":7.7638888888888893}]
["KW 15",{"$f":"SUM('April(4)'!F20)","v":7.7638888888888893},{"$f":"AVERAGE(B6:B17)","v":7.0972222222222223}]
["KW 16",{"$f":"SUM('April(4)'!F27)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(B7:B18)","v":7.0775462962962967}]
["KW 17",{"$f":"SUM('April(4)'!F34)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
["KW 18",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 19",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 20",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 21",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 22",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 23",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 24",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 25",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 26",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 27",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 28",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 29",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#DIV/0!"}]
["KW 30",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 31",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 32",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 33",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 34",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 35",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 36",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 37",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 38",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 39",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 40",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 41",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 42",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 43",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 44",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 45",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 46",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 47",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 48",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 49",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 50",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 51",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 52",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KW 53",null,{"$error":"#REF!"}]