{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Übersicht","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember"],"not_rendered":{"defined_names":48},"read":"whole","date_system":"1900"}

{"sheet":"Übersicht","index":0,"n_rows":17,"n_cols":17,"rows_kept":17,"merged":[[2,9,2,12]]}
["Mitarbeiter_in:",null,null,"Vorgaben für\nZuschläge","Samstag\n13:00-21:00","Sonntag\n8:00-22:00","Feiertage\n8:00-22:00","Heiligabend\nSilvester\nab 8:00","Nachtdienst\n21:00 -6:00 (nicht NB)","NB (Mo-Fr)\n22:00-5:30","NB (WE, Feiertag)  22:00-8:00"]
["Kalenderjahr:",2025,null,null,{"v":0.2,"d":"20%"},{"v":0.25,"d":"25%"},{"v":0.35,"d":"35%"},{"v":0.35,"d":"35%"},{"v":0.25,"d":"25%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[{"$nulls":9},"Flex"]
["€/Std",null,"WStd","Arb.Tage","Soll Std.","Ist Std.","Diff. Monat","Übertr.Vorm.","Übertr. Folgem.","Soll","Ist","Übertr.Vorm.","Übertr. Folgem.","Sonstige","Urlaub Vortrag","Urlaub Monat","Urlaub Rest"]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(B2,1,1)","v":"2025-01-01"},null,{"v":22,"d":"22.0"},{"$f":"C5/5*D5","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(TEXT(B5,\"MMMM\")&\"!IstAZ\")","v":{"v":0,"d":"0.00"}},{"$f":"+F5-E5","v":{"v":0,"d":"+0.00"}},null,{"$f":"+G5+H5","v":{"v":0,"d":"+0.00"}},null,{"$f":"INDIRECT(TEXT(B5,\"MMMM\")&\"!IstFlex\")","v":{"v":0,"d":"0.00"}},null,{"$f":"K5+L5-J5","v":{"v":0,"d":"+0.00"}},{"$f":"INDIRECT(TEXT(B5,\"MMMM\")&\"!IstSonst\")","v":{"v":0,"d":"0.00"}},null,{"$f":"INDIRECT(TEXT(B5,\"MMMM\")&\"!IstUrl\")","v":0},{"$f":"+O5-P5","v":0}]
[{"$f":"A5","v":{"v":0,"d":"0.00 €"}},{"$f":"DATE(YEAR(B5),MONTH(B5)+1,1)","v":"2025-02-01"},{"$f":"C5","v":{"v":0,"d":"0.00"}},{"v":21,"d":"21.0"},{"$f":"C6/5*D6","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"+F6-E6","v":{"v":0,"d":"+0.00"}},{"$f":"+I5","v":{"v":0,"d":"+0.00"}},{"$f":"+G6+H6","v":{"v":0,"d":"+0.00"}},{"$f":"J5","v":0},{"$f":"INDIRECT(TEXT(B6,\"MMMM\")&\"!IstFlex\")","v":{"v":0,"d":"0.00"}},{"$f":"M5","v":{"v":0,"d":"+0.00"}},{"$f":"K6+L6-J6","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"0.00"},{"$f":"+Q5","v":0},0,{"$f":"+O6-P6","v":0}]
[{"$f":"A6","v":{"v":0,"d":"0.00 €"}},{"$f":"DATE(YEAR(B6),MONTH(B6)+1,1)","v":"2025-03-01"},{"$f":"C6","v":{"v":0,"d":"0.00"}},{"v":20,"d":"20.0"},{"$f":"C7/5*D7","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"$f":"+I6","v":{"v":0,"d":"+0.00"}},{"$f":"+G7+H7","v":{"v":0,"d":"+0.00"}},{"$f":"J6","v":0},{"v":0,"d":"0.00"},{"$f":"M6","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},{"$f":"+Q6","v":0},0,0]
[{"$f":"A7","v":{"v":0,"d":"0.00 €"}},{"$f":"DATE(YEAR(B7),MONTH(B7)+1,1)","v":"2025-04-01"},{"$f":"C7","v":{"v":0,"d":"0.00"}},{"v":21,"d":"21.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"+F8-E8","v":{"v":0,"d":"+0.00"}},{"$f":"+I7","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},{"$f":"+Q7","v":0},0,0]
[{"$f":"A8","v":{"v":0,"d":"0.00 €"}},{"$f":"DATE(YEAR(B8),MONTH(B8)+1,1)","v":"2025-05-01"},{"$f":"C8","v":{"v":0,"d":"0.00"}},{"v":20,"d":"20.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},{"$f":"+Q8","v":0},{"$f":"INDIRECT(TEXT(B9,\"MMMM\")&\"!IstUrl\")","v":0},0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B9),MONTH(B9)+1,1)","v":"2025-06-01"},{"v":0,"d":"0.00"},{"v":20,"d":"20.0"},{"$f":"C10/5*D10","v":{"v":0,"d":"0.00"}},{"$f":"INDIRECT(TEXT(B10,\"MMMM\")&\"!IstAZ\")","v":{"v":0,"d":"0.00"}},{"$f":"+F10-E10","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},{"$f":"+Q9","v":0},0,0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B10),MONTH(B10)+1,1)","v":"2025-07-01"},{"v":0,"d":"0.00"},{"v":23,"d":"23.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"$f":"+I10","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B11),MONTH(B11)+1,1)","v":"2025-08-01"},{"v":0,"d":"0.00"},{"v":22,"d":"22.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"$f":"+I11","v":{"v":0,"d":"+0.00"}},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B12),MONTH(B12)+1,1)","v":"2025-09-01"},{"v":0,"d":"0.00"},{"v":21,"d":"21.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B13),MONTH(B13)+1,1)","v":"2025-10-01"},{"v":0,"d":"0.00"},{"v":21,"d":"21.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"v":0,"d":"0.00 €"},{"$f":"DATE(YEAR(B14),MONTH(B14)+1,1)","v":"2025-11-01"},{"v":0,"d":"0.00"},{"v":21,"d":"21.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"v":0,"d":"0.00 €"},"2025-12-01",{"v":0,"d":"0.00"},{"v":18,"d":"18.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},0,{"v":0,"d":"0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"+0.00"},{"v":0,"d":"0.00"},0,0,0]
[{"$nulls":3},{"$f":"SUM(D5:D16)","v":{"v":250,"d":"250.0"}},{"$f":"SUM(E5:E16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(F5:F16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(G5:G16)","v":{"v":0,"d":"+0.00"}},null,null,{"$f":"SUM(J5:J16)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K5:K16)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(N5:N16)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(P5:P16)","v":0}]

{"sheet":"Januar","index":1,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[1]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-01-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ","NB 3,75 WE: 5 ","Pause","Gesamt-\nStd.",{"$f":"Übersicht!E1","v":"Samstag\n13:00-21:00"},"Sonntag        0 - 24 h","Feiert.\n0 - 24 h","Heiligab.\nSilvester\nab 6.00 h","Nacht-\ndienst\n21 - 6 h","Ruf-Ber.",{"$f":"Übersicht!J3","v":"Flex"},{"$f":"Übersicht!N4","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Übersicht!E2","v":{"v":0.2,"d":"20%"}},{"$f":"Übersicht!F2","v":{"v":0.25,"d":"25%"}},{"$f":"Übersicht!G2","v":{"v":0.35,"d":"35%"}},{"$f":"Übersicht!H2","v":{"v":0.35,"d":"35%"}},{"$f":"Übersicht!I2","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-01-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-01-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-01-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-14",{"$nulls":4},{"$f":"IF(A20=\"\",\"\",IF(B20=\"U\",$B$41/5,(C20+IF(B20>C20,1,0)-B20)*24-E20)+D20)","v":{"v":0,"d":"0.00"}}]
["2025-01-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-01-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-01-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":22,"d":"22.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Februar","index":2,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[2]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-02-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Januar!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Januar!G5","v":"Samstag\n13:00-21:00"},{"$f":"Januar!H5","v":"Sonntag        0 - 24 h"},{"$f":"Januar!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Januar!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Januar!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Januar!L5","v":"Ruf-Ber."},{"$f":"Januar!M5","v":"Flex"},{"$f":"Januar!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Januar!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Januar!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Januar!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Januar!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Januar!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-02-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-02-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-02-03"},{"$nulls":4},{"$f":"IF(A9=\"\",\"\",IF(B9=\"U\",$B$41/5,(C9+IF(B9>C9,1,0)-B9)*24-E9)+D9)","v":{"v":0,"d":"0.00"}}]
["2025-02-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-02-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":""},{"$nulls":4},""]
["",{"$nulls":4},""]
["",{"$nulls":4},""]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":21,"d":"21.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"März","index":3,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[3]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-03-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Februar!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Februar!G5","v":"Samstag\n13:00-21:00"},{"$f":"Februar!H5","v":"Sonntag        0 - 24 h"},{"$f":"Februar!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Februar!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Februar!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Februar!L5","v":"Ruf-Ber."},{"$f":"Februar!M5","v":"Flex"},{"$f":"Februar!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Februar!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Februar!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Februar!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Februar!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Februar!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-03-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-03-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-03-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-05",{"$nulls":4},{"$f":"IF(A11=\"\",\"\",IF(B11=\"U\",$B$41/5,(C11+IF(B11>C11,1,0)-B11)*24-E11)+D11)","v":{"v":0,"d":"0.00"}}]
["2025-03-06",{"$nulls":4},{"$f":"IF(A12=\"\",\"\",IF(B12=\"U\",$B$41/5,(C12+IF(B12>C12,1,0)-B12)*24-E12)+D12)","v":{"v":0,"d":"0.00"}}]
["2025-03-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-03-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-03-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":20,"d":"20.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"April","index":4,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[4]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-04-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"März!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"März!G5","v":"Samstag\n13:00-21:00"},{"$f":"März!H5","v":"Sonntag        0 - 24 h"},{"$f":"März!I5","v":"Feiert.\n0 - 24 h"},{"$f":"März!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"März!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"März!L5","v":"Ruf-Ber."},{"$f":"März!M5","v":"Flex"},{"$f":"März!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"März!G6","v":{"v":0.2,"d":"20%"}},{"$f":"März!H6","v":{"v":0.25,"d":"25%"}},{"$f":"März!I6","v":{"v":0.35,"d":"35%"}},{"$f":"März!J6","v":{"v":0.35,"d":"35%"}},{"$f":"März!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-04-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-04-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-04-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-07",{"$nulls":4},{"$f":"IF(A13=\"\",\"\",IF(B13=\"U\",$B$41/5,(C13+IF(B13>C13,1,0)-B13)*24-E13)+D13)","v":{"v":0,"d":"0.00"}}]
["2025-04-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-22",{"$nulls":4},{"$f":"IF(A28=\"\",\"\",IF(B28=\"U\",$B$41/5,(C28+IF(B28>C28,1,0)-B28)*24-E28)+D28)","v":{"v":0,"d":"0.00"}}]
["2025-04-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-04-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-04-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["",{"$nulls":4},""]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":21,"d":"21.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Mai","index":5,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[5]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-05-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"April!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"April!G5","v":"Samstag\n13:00-21:00"},{"$f":"April!H5","v":"Sonntag        0 - 24 h"},{"$f":"April!I5","v":"Feiert.\n0 - 24 h"},{"$f":"April!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"April!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"April!L5","v":"Ruf-Ber."},{"$f":"April!M5","v":"Flex"},{"$f":"April!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"April!G6","v":{"v":0.2,"d":"20%"}},{"$f":"April!H6","v":{"v":0.25,"d":"25%"}},{"$f":"April!I6","v":{"v":0.35,"d":"35%"}},{"$f":"April!J6","v":{"v":0.35,"d":"35%"}},{"$f":"April!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-05-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-05-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-05-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-13",{"$nulls":4},{"$f":"IF(A19=\"\",\"\",IF(B19=\"U\",$B$41/5,(C19+IF(B19>C19,1,0)-B19)*24-E19)+D19)","v":{"v":0,"d":"0.00"}}]
["2025-05-14",{"$nulls":4},{"$f":"IF(A20=\"\",\"\",IF(B20=\"U\",$B$41/5,(C20+IF(B20>C20,1,0)-B20)*24-E20)+D20)","v":{"v":0,"d":"0.00"}}]
["2025-05-15",{"$nulls":4},{"$f":"IF(A21=\"\",\"\",IF(B21=\"U\",$B$41/5,(C21+IF(B21>C21,1,0)-B21)*24-E21)+D21)","v":{"v":0,"d":"0.00"}}]
["2025-05-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-22",{"$nulls":4},{"$f":"IF(A28=\"\",\"\",IF(B28=\"U\",$B$41/5,(C28+IF(B28>C28,1,0)-B28)*24-E28)+D28)","v":{"v":0,"d":"0.00"}}]
["2025-05-23",{"$nulls":4},{"$f":"IF(A29=\"\",\"\",IF(B29=\"U\",$B$41/5,(C29+IF(B29>C29,1,0)-B29)*24-E29)+D29)","v":{"v":0,"d":"0.00"}}]
["2025-05-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-05-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-05-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":20,"d":"20.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Juni","index":6,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[6]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-06-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Mai!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Mai!G5","v":"Samstag\n13:00-21:00"},{"$f":"Mai!H5","v":"Sonntag        0 - 24 h"},{"$f":"Mai!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Mai!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Mai!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Mai!L5","v":"Ruf-Ber."},{"$f":"Mai!M5","v":"Flex"},{"$f":"Mai!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Mai!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Mai!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Mai!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Mai!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Mai!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-06-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-06-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-06-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-19",{"$nulls":4},{"$f":"IF(A25=\"\",\"\",IF(B25=\"U\",$B$41/5,(C25+IF(B25>C25,1,0)-B25)*24-E25)+D25)","v":{"v":0,"d":"0.00"}}]
["2025-06-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-06-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-06-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["",{"$nulls":4},""]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":20,"d":"20.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Juli","index":7,"n_rows":45,"n_cols":18,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[7]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-07-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Juni!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Juni!G5","v":"Samstag\n13:00-21:00"},{"$f":"Juni!H5","v":"Sonntag        0 - 24 h"},{"$f":"Juni!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Juni!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Juni!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Juni!L5","v":"Ruf-Ber."},{"$f":"Juni!M5","v":"Flex"},{"$f":"Juni!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Juni!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Juni!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Juni!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Juni!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Juni!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-07-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-07-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-07-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-07-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-07-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":23,"d":"23.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}},{"$nulls":4}," "]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"August","index":8,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[8]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-08-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Juli!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Juli!G5","v":"Samstag\n13:00-21:00"},{"$f":"Juli!H5","v":"Sonntag        0 - 24 h"},{"$f":"Juli!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Juli!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Juli!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Juli!L5","v":"Ruf-Ber."},{"$f":"Juli!M5","v":"Flex"},{"$f":"Juli!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Juli!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Juli!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Juli!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Juli!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Juli!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-08-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-08-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-08-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-06",{"$nulls":4},{"$f":"IF(A12=\"\",\"\",IF(B12=\"U\",$B$41/5,(C12+IF(B12>C12,1,0)-B12)*24-E12)+D12)","v":{"v":0,"d":"0.00"}}]
["2025-08-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-08-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-08-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":22,"d":"22.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"September","index":9,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[9]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-09-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"August!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"August!G5","v":"Samstag\n13:00-21:00"},{"$f":"August!H5","v":"Sonntag        0 - 24 h"},{"$f":"August!I5","v":"Feiert.\n0 - 24 h"},{"$f":"August!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"August!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"August!L5","v":"Ruf-Ber."},{"$f":"August!M5","v":"Flex"},{"$f":"August!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"August!G6","v":{"v":0.2,"d":"20%"}},{"$f":"August!H6","v":{"v":0.25,"d":"25%"}},{"$f":"August!I6","v":{"v":0.35,"d":"35%"}},{"$f":"August!J6","v":{"v":0.35,"d":"35%"}},{"$f":"August!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-09-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-09-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-09-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-09-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-09-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["",{"$nulls":4},""]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":21,"d":"21.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Oktober","index":10,"n_rows":47,"n_cols":15,"rows_kept":47,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[10]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-10-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"September!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"September!G5","v":"Samstag\n13:00-21:00"},{"$f":"September!H5","v":"Sonntag        0 - 24 h"},{"$f":"September!I5","v":"Feiert.\n0 - 24 h"},{"$f":"September!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"September!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"September!L5","v":"Ruf-Ber."},{"$f":"September!M5","v":"Flex"},{"$f":"September!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"September!G6","v":{"v":0.2,"d":"20%"}},{"$f":"September!H6","v":{"v":0.25,"d":"25%"}},{"$f":"September!I6","v":{"v":0.35,"d":"35%"}},{"$f":"September!J6","v":{"v":0.35,"d":"35%"}},{"$f":"September!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-10-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-10-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-10-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-08",{"$nulls":4},{"$f":"IF(A14=\"\",\"\",IF(B14=\"U\",$B$41/5,(C14+IF(B14>C14,1,0)-B14)*24-E14)+D14)","v":{"v":0,"d":"0.00"}}]
["2025-10-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-10-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-10-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":21,"d":"21.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":14}," "]

{"sheet":"November","index":11,"n_rows":46,"n_cols":15,"rows_kept":46,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[11]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-11-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"Oktober!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"Oktober!G5","v":"Samstag\n13:00-21:00"},{"$f":"Oktober!H5","v":"Sonntag        0 - 24 h"},{"$f":"Oktober!I5","v":"Feiert.\n0 - 24 h"},{"$f":"Oktober!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"Oktober!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"Oktober!L5","v":"Ruf-Ber."},{"$f":"Oktober!M5","v":"Flex"},{"$f":"Oktober!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"Oktober!G6","v":{"v":0.2,"d":"20%"}},{"$f":"Oktober!H6","v":{"v":0.25,"d":"25%"}},{"$f":"Oktober!I6","v":{"v":0.35,"d":"35%"}},{"$f":"Oktober!J6","v":{"v":0.35,"d":"35%"}},{"$f":"Oktober!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-11-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-11-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-11-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-05",{"$nulls":4},{"$f":"IF(A11=\"\",\"\",IF(B11=\"U\",$B$41/5,(C11+IF(B11>C11,1,0)-B11)*24-E11)+D11)","v":{"v":0,"d":"0.00"}}]
["2025-11-06",{"$nulls":4},{"$f":"IF(A12=\"\",\"\",IF(B12=\"U\",$B$41/5,(C12+IF(B12>C12,1,0)-B12)*24-E12)+D12)","v":{"v":0,"d":"0.00"}}]
["2025-11-07",{"$nulls":4},{"$f":"IF(A13=\"\",\"\",IF(B13=\"U\",$B$41/5,(C13+IF(B13>C13,1,0)-B13)*24-E13)+D13)","v":{"v":0,"d":"0.00"}}]
["2025-11-08",{"$nulls":4},{"$f":"IF(A14=\"\",\"\",IF(B14=\"U\",$B$41/5,(C14+IF(B14>C14,1,0)-B14)*24-E14)+D14)","v":{"v":0,"d":"0.00"}}]
["2025-11-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-15",{"$nulls":4},{"$f":"IF(A21=\"\",\"\",IF(B21=\"U\",$B$41/5,(C21+IF(B21>C21,1,0)-B21)*24-E21)+D21)","v":{"v":0,"d":"0.00"}}]
["2025-11-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-11-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-11-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["",{"$nulls":4},""]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":21,"d":"21.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":13},{"$f":"COUNTIF(N9:N39,\"U\")","v":0}]

{"sheet":"Dezember","index":12,"n_rows":45,"n_cols":15,"rows_kept":45,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,6,3,11],[40,3,40,5],[40,8,40,10],[41,3,41,5],[41,8,41,10],[42,3,42,5],[42,8,42,10],[43,3,43,5],[43,8,43,10],[44,3,44,5],[44,10,44,11]]}
[12]
[{"$f":"Übersicht!B1","v":"00:00:00"}]
[{"$f":"DATE(Übersicht!B2,A1,1)","v":"2025-12-01"}]
[{"$nulls":6},"Zuschläge "]
[null,"Arbeitsz.\nvon","Arbeitsz. bis ",{"$f":"November!D5","v":"NB 3,75 WE: 5 "},"Pause","Gesamt-\nStd.",{"$f":"November!G5","v":"Samstag\n13:00-21:00"},{"$f":"November!H5","v":"Sonntag        0 - 24 h"},{"$f":"November!I5","v":"Feiert.\n0 - 24 h"},{"$f":"November!J5","v":"Heiligab.\nSilvester\nab 6.00 h"},{"$f":"November!K5","v":"Nacht-\ndienst\n21 - 6 h"},{"$f":"November!L5","v":"Ruf-Ber."},{"$f":"November!M5","v":"Flex"},{"$f":"November!N5","v":"Sonstige"},"Bemerkung"]
["Zuschlag €/Std.",{"$nulls":5},{"$f":"November!G6","v":{"v":0.2,"d":"20%"}},{"$f":"November!H6","v":{"v":0.25,"d":"25%"}},{"$f":"November!I6","v":{"v":0.35,"d":"35%"}},{"$f":"November!J6","v":{"v":0.35,"d":"35%"}},{"$f":"November!K6","v":{"v":0.25,"d":"25%"}}]
[{"$f":"DATE(YEAR(A3),MONTH(A3),1)","v":"2025-12-01"},{"$nulls":4},{"$f":"IF(A7=\"\",\"\",IF(B7=\"U\",$B$41/5,(C7+IF(B7>C7,1,0)-B7)*24-E7)+D7)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A7+1","v":"2025-12-02"},{"$nulls":4},{"$f":"IF(A8=\"\",\"\",IF(B8=\"U\",$B$41/5,(C8+IF(B8>C8,1,0)-B8)*24-E8)+D8)","v":{"v":0,"d":"0.00"}}]
[{"$f":"A8+1","v":"2025-12-03"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-04",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-05",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-06",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-07",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-08",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-09",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-10",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-11",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-12",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-13",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-14",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-15",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-16",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-17",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-18",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-19",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-20",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-21",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-22",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-23",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-24",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-25",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-26",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-27",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-28",{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$f":"IF(A34=\"\",\"\",IF(DAY(A34+1)<4,\"\",A34+1))","v":"2025-12-29"},{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-30",{"$nulls":4},{"v":0,"d":"0.00"}]
["2025-12-31",{"$nulls":4},{"v":0,"d":"0.00"}]
["Summe Stunden",{"$nulls":5},{"$f":"SUM(G7:G37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(H7:H37)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(I7:I37)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Summe Zuschlag"]
[]
["Wochen Std.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,2,FALSE)","v":{"v":0,"d":"0.00"}},null,"Soll Az",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,4,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Soll Monat",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$J$16,9,FALSE)","v":{"v":0,"d":"0.00"}}]
["Arbeitstage",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$E$16,3,FALSE)","v":{"v":18,"d":"18.0"}},null,"Ist Az",null,null,{"$f":"SUM(F7:F37)","v":{"v":0,"d":"0.00"}},null,"Flex Ist Monat",{"$nulls":3},{"$f":"IstFlex","v":{"v":0,"d":"0.00"}}]
["Url. Vorm.",{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,14,FALSE)","v":0},null,"Diff. akt. Monat",null,null,{"$f":"SUM(G42-G41)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Vormon.",{"$nulls":3},{"$f":"VLOOKUP(A3,Übersicht!$B$5:$L$16,11,FALSE)","v":{"v":0,"d":"0.00"}}]
["Url. Monat",{"$f":"COUNTIF(B7:B37,\"U\")","v":0},null,"Diff. Vormonat",null,null,{"$f":"VLOOKUP(A3,Übersicht!$B$5:$O$16,7,FALSE)","v":{"v":0,"d":"0.00"}},null,"Flex Konto Folgem.",{"$nulls":3},{"$f":"+M41+M43-M38","v":{"v":0,"d":"0.00"}}]
["Urlaub Rest",{"$f":"+B43-IstUrl","v":0},null,"Übertr. Folgem.",null,null,{"$f":"SUM(G44+G43)","v":{"v":0,"d":"0.00"}},null,"Zuschläge ",null,{"$f":"G39+H39+I39+J39+K39+L39","v":{"v":0,"d":"0.00 €"}}]