{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["StundenZettel","Daten","Translate"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"1900"}

{"sheet":"StundenZettel","index":0,"n_rows":375,"n_cols":13,"rows_kept":375,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
[null,{"$f":"HYPERLINK(\"#\"&\"StundenZettel!D\"&MATCH(Daten!E3,INDEX(C:C,0),0),Translate!A16)","v":"Heute"}]
[{"$f":"HYPERLINK(\"#\"&\"StundenZettel!D\"&MATCH(C2,INDEX(C5:C379,0),0)+4,Translate!A14)","v":"Erster Montag im Monat"},null,"2023-01-02"]
[{"$f":"Daten!E4","v":2023},null,null,{"$f":"Translate!A3","v":"gearbeitet von"},{"$f":"Translate!A4","v":"gearbeitet bis"},{"$f":"Translate!A5","v":"Pause"},{"$f":"Translate!A6","v":"gearbeitete Stunden"},{"$f":"Translate!A7","v":"gearbeitete Stunden als Dezimalzahl"},{"$f":"Translate!A8","v":"Ferientag"},{"$f":"Translate!$A$17","v":"Wochentotal"},{"$f":"Translate!A9","v":"Überstunden"},{"$f":"Translate!A20","v":"Minusstunden"},{"$f":"Translate!A9&\"-\"&Translate!A20","v":"Überstunden-Minusstunden"}]
[{"$f":"Translate!A11","v":"KW"},{"$f":"Translate!A12","v":"Tag"},{"$f":"Translate!A13","v":"Datum"},null,null,null,{"$f":"SUM(G5:G486)","v":0},{"$f":"SUM(H5:H375)","v":0},{"$f":"COUNTIF(I5:I375,Translate!A24)","v":0},null,{"$f":"SUM(K5:K375)","v":0},{"$f":"SUM(L5:L375)","v":0},{"$f":"K4+L4","v":0}]
[{"$f":"_xlfn.ISOWEEKNUM(C5)","v":52},{"$f":"TEXT(C5,\"TTTT\")","v":"Montag"},{"$f":"Daten!B2","v":"2022-12-26"},null,null,null,{"$f":"E5-D5-F5","v":"00:00:00"},{"$f":"IF(E5=\"\",\"\",G5*24)","v":""}]
[{"$f":"_xlfn.ISOWEEKNUM(C6)","v":52},{"$f":"TEXT(C6,\"TTTT\")","v":"Dienstag"},{"$f":"C5+1","v":"2022-12-27"},null,null,null,{"$f":"E6-D6-F6","v":"00:00:00"},""]
[52,{"$f":"TEXT(C7,\"TTTT\")","v":"Mittwoch"},{"$f":"C6+1","v":"2022-12-28"},null,null,null,{"$f":"E7-D7-F7","v":"00:00:00"},""]
[52,"Donnerstag","2022-12-29",null,null,null,"00:00:00",""]
[52,"Freitag","2022-12-30",null,null,null,"00:00:00",""]
[52,"Samstag","2022-12-31",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[52,"Sonntag","2023-01-01",null,null,null,"00:00:00","",null,{"$f":"SUM(H5:H11)","v":0},{"$f":"IF(J11-Daten!E$1<0,,J11-Daten!E$1)","v":0},{"$f":"IF(J11-Daten!E$1>0,,IF(J11-Daten!E$1=Daten!F$1,0,J11-Daten!E$1))","v":0}]
[1,"Montag","2023-01-02",null,null,null,"00:00:00",""]
[1,"Dienstag","2023-01-03",null,null,null,{"$f":"E13-D13-F13","v":"00:00:00"},""]
[1,"Mittwoch","2023-01-04",null,null,null,"00:00:00",""]
[1,"Donnerstag","2023-01-05",null,null,null,{"$f":"E15-D15-F15","v":"00:00:00"},""]
[1,"Freitag","2023-01-06",null,null,null,"00:00:00",""]
[1,"Samstag","2023-01-07",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[1,"Sonntag","2023-01-08",null,null,null,"00:00:00","",null,{"$f":"SUM(H12:H18)","v":0},{"$f":"IF(J18-Daten!E$1<0,,J18-Daten!E$1)","v":0},{"$f":"IF(J18-Daten!E$1>0,,IF(J18-Daten!E$1=Daten!F$1,0,J18-Daten!E$1))","v":0}]
[2,"Montag","2023-01-09",null,null,null,"00:00:00",""]
[2,"Dienstag","2023-01-10",null,null,null,"00:00:00",""]
[2,"Mittwoch","2023-01-11",null,null,null,"00:00:00",""]
[2,"Donnerstag","2023-01-12",null,null,null,"00:00:00",""]
[2,"Freitag","2023-01-13",null,null,null,"00:00:00",""]
[2,"Samstag","2023-01-14",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[2,"Sonntag","2023-01-15",null,null,null,"00:00:00","",null,{"$f":"SUM(H19:H25)","v":0},{"$f":"IF(J25-Daten!E$1<0,,J25-Daten!E$1)","v":0},{"$f":"IF(J25-Daten!E$1>0,,IF(J25-Daten!E$1=Daten!F$1,0,J25-Daten!E$1))","v":0}]
[3,"Montag","2023-01-16",null,null,null,"00:00:00",""]
[3,"Dienstag","2023-01-17",null,null,null,"00:00:00",""]
[3,"Mittwoch","2023-01-18",null,null,null,"00:00:00",""]
[3,"Donnerstag","2023-01-19",null,null,null,"00:00:00",""]
[3,"Freitag","2023-01-20",null,null,null,"00:00:00",""]
[3,"Samstag","2023-01-21",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[3,"Sonntag","2023-01-22",null,null,null,"00:00:00","",null,{"$f":"SUM(H26:H32)","v":0},{"$f":"IF(J32-Daten!E$1<0,,J32-Daten!E$1)","v":0},{"$f":"IF(J32-Daten!E$1>0,,IF(J32-Daten!E$1=Daten!F$1,0,J32-Daten!E$1))","v":0}]
[4,"Montag","2023-01-23",null,null,null,"00:00:00",""]
[4,"Dienstag","2023-01-24",null,null,null,"00:00:00",""]
[4,"Mittwoch","2023-01-25",null,null,null,"00:00:00",""]
[4,"Donnerstag","2023-01-26",null,null,null,"00:00:00",""]
[4,"Freitag","2023-01-27",null,null,null,"00:00:00",""]
[4,"Samstag","2023-01-28",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[4,"Sonntag","2023-01-29",null,null,null,"00:00:00","",null,{"$f":"SUM(H33:H39)","v":0},{"$f":"IF(J39-Daten!E$1<0,,J39-Daten!E$1)","v":0},{"$f":"IF(J39-Daten!E$1>0,,IF(J39-Daten!E$1=Daten!F$1,0,J39-Daten!E$1))","v":0}]
[5,"Montag","2023-01-30",null,null,null,"00:00:00",""]
[5,"Dienstag","2023-01-31",null,null,null,"00:00:00",""]
[5,"Mittwoch","2023-02-01",null,null,null,"00:00:00",""]
[5,"Donnerstag","2023-02-02",null,null,null,"00:00:00",""]
[5,"Freitag","2023-02-03",null,null,null,"00:00:00",""]
[5,"Samstag","2023-02-04",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[5,"Sonntag","2023-02-05",null,null,null,"00:00:00","",null,{"$f":"SUM(H40:H46)","v":0},{"$f":"IF(J46-Daten!E$1<0,,J46-Daten!E$1)","v":0},{"$f":"IF(J46-Daten!E$1>0,,IF(J46-Daten!E$1=Daten!F$1,0,J46-Daten!E$1))","v":0}]
[6,"Montag","2023-02-06",null,null,null,"00:00:00",""]
[6,"Dienstag","2023-02-07",null,null,null,"00:00:00",""]
[6,"Mittwoch","2023-02-08",null,null,null,"00:00:00",""]
[{"$f":"_xlfn.ISOWEEKNUM(C50)","v":6},"Donnerstag","2023-02-09",null,null,null,"00:00:00",""]
[6,"Freitag","2023-02-10",null,null,null,"00:00:00",""]
[6,"Samstag","2023-02-11",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[6,"Sonntag","2023-02-12",null,null,null,"00:00:00","",null,{"$f":"SUM(H47:H53)","v":0},{"$f":"IF(J53-Daten!E$1<0,,J53-Daten!E$1)","v":0},{"$f":"IF(J53-Daten!E$1>0,,IF(J53-Daten!E$1=Daten!F$1,0,J53-Daten!E$1))","v":0}]
[7,"Montag","2023-02-13",null,null,null,"00:00:00",""]
[7,"Dienstag","2023-02-14",null,null,null,"00:00:00",""]
[7,"Mittwoch","2023-02-15",null,null,null,"00:00:00",""]
[7,"Donnerstag","2023-02-16",null,null,null,"00:00:00",""]
[7,"Freitag","2023-02-17",null,null,null,"00:00:00",""]
[7,"Samstag","2023-02-18",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[7,"Sonntag","2023-02-19",null,null,null,"00:00:00","",null,{"$f":"SUM(H54:H60)","v":0},{"$f":"IF(J60-Daten!E$1<0,,J60-Daten!E$1)","v":0},{"$f":"IF(J60-Daten!E$1>0,,IF(J60-Daten!E$1=Daten!F$1,0,J60-Daten!E$1))","v":0}]
[8,"Montag","2023-02-20",null,null,null,"00:00:00",""]
[8,"Dienstag","2023-02-21",null,null,null,"00:00:00",""]
[8,"Mittwoch","2023-02-22",null,null,null,"00:00:00",""]
[8,"Donnerstag","2023-02-23",null,null,null,"00:00:00",""]
[8,"Freitag","2023-02-24",null,null,null,"00:00:00",""]
[8,"Samstag","2023-02-25",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[8,"Sonntag","2023-02-26",null,null,null,"00:00:00","",null,{"$f":"SUM(H61:H67)","v":0},{"$f":"IF(J67-Daten!E$1<0,,J67-Daten!E$1)","v":0},{"$f":"IF(J67-Daten!E$1>0,,IF(J67-Daten!E$1=Daten!F$1,0,J67-Daten!E$1))","v":0}]
[9,"Montag","2023-02-27",null,null,null,"00:00:00",""]
[9,"Dienstag","2023-02-28",null,null,null,"00:00:00",""]
[{"$f":"_xlfn.ISOWEEKNUM(C70)","v":9},"Mittwoch","2023-03-01",null,null,null,"00:00:00",{"$f":"IF(E70=\"\",\"\",G70*24)","v":""}]
[9,{"$f":"TEXT(C71,\"TTTT\")","v":"Donnerstag"},{"$f":"C70+1","v":"2023-03-02"},null,null,null,{"$f":"E71-D71-F71","v":"00:00:00"},""]
[9,"Freitag","2023-03-03",null,null,null,"00:00:00",""]
[9,"Samstag","2023-03-04",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[9,"Sonntag","2023-03-05",null,null,null,"00:00:00","",null,{"$f":"SUM(H68:H74)","v":0},{"$f":"IF(J74-Daten!E$1<0,,J74-Daten!E$1)","v":0},{"$f":"IF(J74-Daten!E$1>0,,IF(J74-Daten!E$1=Daten!F$1,0,J74-Daten!E$1))","v":0}]
[10,"Montag","2023-03-06",null,null,null,"00:00:00",""]
[10,"Dienstag","2023-03-07",null,null,null,"00:00:00",""]
[10,"Mittwoch","2023-03-08",null,null,null,"00:00:00",""]
[10,"Donnerstag","2023-03-09",null,null,null,"00:00:00",""]
[10,"Freitag","2023-03-10",null,null,null,"00:00:00",""]
[10,"Samstag","2023-03-11",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[10,"Sonntag","2023-03-12",null,null,null,"00:00:00","",null,{"$f":"SUM(H75:H81)","v":0},{"$f":"IF(J81-Daten!E$1<0,,J81-Daten!E$1)","v":0},{"$f":"IF(J81-Daten!E$1>0,,IF(J81-Daten!E$1=Daten!F$1,0,J81-Daten!E$1))","v":0}]
[11,"Montag","2023-03-13",null,null,null,"00:00:00",""]
[11,"Dienstag","2023-03-14",null,null,null,"00:00:00",""]
[11,"Mittwoch","2023-03-15",null,null,null,"00:00:00",""]
[11,"Donnerstag","2023-03-16",null,null,null,"00:00:00",""]
[11,"Freitag","2023-03-17",null,null,null,"00:00:00",""]
[11,"Samstag","2023-03-18",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[11,"Sonntag","2023-03-19",null,null,null,"00:00:00","",null,{"$f":"SUM(H82:H88)","v":0},{"$f":"IF(J88-Daten!E$1<0,,J88-Daten!E$1)","v":0},{"$f":"IF(J88-Daten!E$1>0,,IF(J88-Daten!E$1=Daten!F$1,0,J88-Daten!E$1))","v":0}]
[12,"Montag","2023-03-20",null,null,null,"00:00:00",""]
[12,"Dienstag","2023-03-21",null,null,null,"00:00:00",""]
[12,"Mittwoch","2023-03-22",null,null,null,"00:00:00",""]
[12,"Donnerstag","2023-03-23",null,null,null,"00:00:00",""]
[12,"Freitag","2023-03-24",null,null,null,"00:00:00",""]
[12,"Samstag","2023-03-25",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[12,"Sonntag","2023-03-26",null,null,null,"00:00:00","",null,{"$f":"SUM(H89:H95)","v":0},{"$f":"IF(J95-Daten!E$1<0,,J95-Daten!E$1)","v":0},{"$f":"IF(J95-Daten!E$1>0,,IF(J95-Daten!E$1=Daten!F$1,0,J95-Daten!E$1))","v":0}]
[13,"Montag","2023-03-27",null,null,null,"00:00:00",""]
[13,"Dienstag","2023-03-28",null,null,null,"00:00:00",""]
[13,"Mittwoch","2023-03-29",null,null,null,"00:00:00",""]
[13,"Donnerstag","2023-03-30",null,null,null,"00:00:00",""]
[13,"Freitag","2023-03-31",null,null,null,"00:00:00",""]
[13,"Samstag","2023-04-01",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[13,"Sonntag","2023-04-02",null,null,null,"00:00:00","",null,{"$f":"SUM(H96:H102)","v":0},{"$f":"IF(J102-Daten!E$1<0,,J102-Daten!E$1)","v":0},{"$f":"IF(J102-Daten!E$1>0,,IF(J102-Daten!E$1=Daten!F$1,0,J102-Daten!E$1))","v":0}]
[14,"Montag","2023-04-03",null,null,null,"00:00:00",""]
[14,"Dienstag","2023-04-04",null,null,null,"00:00:00",""]
[14,"Mittwoch","2023-04-05",null,null,null,"00:00:00",""]
[14,"Donnerstag","2023-04-06",null,null,null,"00:00:00",""]
[14,"Freitag","2023-04-07",null,null,null,"00:00:00",""]
[14,"Samstag","2023-04-08",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[14,"Sonntag","2023-04-09",null,null,null,"00:00:00","",null,{"$f":"SUM(H103:H109)","v":0},{"$f":"IF(J109-Daten!E$1<0,,J109-Daten!E$1)","v":0},{"$f":"IF(J109-Daten!E$1>0,,IF(J109-Daten!E$1=Daten!F$1,0,J109-Daten!E$1))","v":0}]
[15,"Montag","2023-04-10",null,null,null,"00:00:00",""]
[15,"Dienstag","2023-04-11",null,null,null,"00:00:00",""]
[15,"Mittwoch","2023-04-12",null,null,null,"00:00:00",""]
[15,"Donnerstag","2023-04-13",null,null,null,"00:00:00",""]
[15,"Freitag","2023-04-14",null,null,null,"00:00:00",""]
[15,"Samstag","2023-04-15",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[15,"Sonntag","2023-04-16",null,null,null,"00:00:00","",null,{"$f":"SUM(H110:H116)","v":0},{"$f":"IF(J116-Daten!E$1<0,,J116-Daten!E$1)","v":0},{"$f":"IF(J116-Daten!E$1>0,,IF(J116-Daten!E$1=Daten!F$1,0,J116-Daten!E$1))","v":0}]
[16,"Montag","2023-04-17",null,null,null,"00:00:00",""]
[16,"Dienstag","2023-04-18",null,null,null,"00:00:00",""]
[16,"Mittwoch","2023-04-19",null,null,null,"00:00:00",""]
[16,"Donnerstag","2023-04-20",null,null,null,"00:00:00",""]
[16,"Freitag","2023-04-21",null,null,null,"00:00:00",""]
[16,"Samstag","2023-04-22",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[16,"Sonntag","2023-04-23",null,null,null,"00:00:00","",null,{"$f":"SUM(H117:H123)","v":0},{"$f":"IF(J123-Daten!E$1<0,,J123-Daten!E$1)","v":0},{"$f":"IF(J123-Daten!E$1>0,,IF(J123-Daten!E$1=Daten!F$1,0,J123-Daten!E$1))","v":0}]
[17,"Montag","2023-04-24",null,null,null,"00:00:00",""]
[17,"Dienstag","2023-04-25",null,null,null,"00:00:00",""]
[17,"Mittwoch","2023-04-26",null,null,null,"00:00:00",""]
[17,"Donnerstag","2023-04-27",null,null,null,"00:00:00",""]
[17,"Freitag","2023-04-28",null,null,null,"00:00:00",""]
[17,"Samstag","2023-04-29",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[17,"Sonntag","2023-04-30",null,null,null,"00:00:00","",null,{"$f":"SUM(H124:H130)","v":0},{"$f":"IF(J130-Daten!E$1<0,,J130-Daten!E$1)","v":0},{"$f":"IF(J130-Daten!E$1>0,,IF(J130-Daten!E$1=Daten!F$1,0,J130-Daten!E$1))","v":0}]
[18,"Montag","2023-05-01",null,null,null,"00:00:00",""]
[18,"Dienstag","2023-05-02",null,null,null,"00:00:00",""]
[18,"Mittwoch","2023-05-03",null,null,null,"00:00:00",""]
[{"$f":"_xlfn.ISOWEEKNUM(C134)","v":18},"Donnerstag","2023-05-04",null,null,null,"00:00:00",{"$f":"IF(E134=\"\",\"\",G134*24)","v":""}]
[18,{"$f":"TEXT(C135,\"TTTT\")","v":"Freitag"},{"$f":"C134+1","v":"2023-05-05"},null,null,null,{"$f":"E135-D135-F135","v":"00:00:00"},""]
[18,"Samstag","2023-05-06",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[18,"Sonntag","2023-05-07",null,null,null,"00:00:00","",null,{"$f":"SUM(H131:H137)","v":0},{"$f":"IF(J137-Daten!E$1<0,,J137-Daten!E$1)","v":0},{"$f":"IF(J137-Daten!E$1>0,,IF(J137-Daten!E$1=Daten!F$1,0,J137-Daten!E$1))","v":0}]
[19,"Montag","2023-05-08",null,null,null,"00:00:00",""]
[19,"Dienstag","2023-05-09",null,null,null,"00:00:00",""]
[19,"Mittwoch","2023-05-10",null,null,null,"00:00:00",""]
[19,"Donnerstag","2023-05-11",null,null,null,"00:00:00",""]
[19,"Freitag","2023-05-12",null,null,null,"00:00:00",""]
[19,"Samstag","2023-05-13",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[19,"Sonntag","2023-05-14",null,null,null,"00:00:00","",null,{"$f":"SUM(H138:H144)","v":0},{"$f":"IF(J144-Daten!E$1<0,,J144-Daten!E$1)","v":0},{"$f":"IF(J144-Daten!E$1>0,,IF(J144-Daten!E$1=Daten!F$1,0,J144-Daten!E$1))","v":0}]
[20,"Montag","2023-05-15",null,null,null,"00:00:00",""]
[20,"Dienstag","2023-05-16",null,null,null,"00:00:00",""]
[20,"Mittwoch","2023-05-17",null,null,null,"00:00:00",""]
[20,"Donnerstag","2023-05-18",null,null,null,"00:00:00",""]
[20,"Freitag","2023-05-19",null,null,null,"00:00:00",""]
[20,"Samstag","2023-05-20",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[20,"Sonntag","2023-05-21",null,null,null,"00:00:00","",null,{"$f":"SUM(H145:H151)","v":0},{"$f":"IF(J151-Daten!E$1<0,,J151-Daten!E$1)","v":0},{"$f":"IF(J151-Daten!E$1>0,,IF(J151-Daten!E$1=Daten!F$1,0,J151-Daten!E$1))","v":0}]
[21,"Montag","2023-05-22",null,null,null,"00:00:00",""]
[21,"Dienstag","2023-05-23",null,null,null,"00:00:00",""]
[21,"Mittwoch","2023-05-24",null,null,null,"00:00:00",""]
[21,"Donnerstag","2023-05-25",null,null,null,"00:00:00",""]
[21,"Freitag","2023-05-26",null,null,null,"00:00:00",""]
[21,"Samstag","2023-05-27",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[21,"Sonntag","2023-05-28",null,null,null,"00:00:00","",null,{"$f":"SUM(H152:H158)","v":0},{"$f":"IF(J158-Daten!E$1<0,,J158-Daten!E$1)","v":0},{"$f":"IF(J158-Daten!E$1>0,,IF(J158-Daten!E$1=Daten!F$1,0,J158-Daten!E$1))","v":0}]
[22,"Montag","2023-05-29",null,null,null,"00:00:00",""]
[22,"Dienstag","2023-05-30",null,null,null,"00:00:00",""]
[22,"Mittwoch","2023-05-31",null,null,null,"00:00:00",""]
[22,"Donnerstag","2023-06-01",null,null,null,"00:00:00",""]
[22,"Freitag","2023-06-02",null,null,null,"00:00:00",""]
[22,"Samstag","2023-06-03",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[22,"Sonntag","2023-06-04",null,null,null,"00:00:00","",null,{"$f":"SUM(H159:H165)","v":0},{"$f":"IF(J165-Daten!E$1<0,,J165-Daten!E$1)","v":0},{"$f":"IF(J165-Daten!E$1>0,,IF(J165-Daten!E$1=Daten!F$1,0,J165-Daten!E$1))","v":0}]
[23,"Montag","2023-06-05",null,null,null,"00:00:00",""]
[23,"Dienstag","2023-06-06",null,null,null,"00:00:00",""]
[23,"Mittwoch","2023-06-07",null,null,null,"00:00:00",""]
[23,"Donnerstag","2023-06-08",null,null,null,"00:00:00",""]
[23,"Freitag","2023-06-09",null,null,null,"00:00:00",""]
[23,"Samstag","2023-06-10",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[23,"Sonntag","2023-06-11",null,null,null,"00:00:00","",null,{"$f":"SUM(H166:H172)","v":0},{"$f":"IF(J172-Daten!E$1<0,,J172-Daten!E$1)","v":0},{"$f":"IF(J172-Daten!E$1>0,,IF(J172-Daten!E$1=Daten!F$1,0,J172-Daten!E$1))","v":0}]
[24,"Montag","2023-06-12",null,null,null,"00:00:00",""]
[24,"Dienstag","2023-06-13",null,null,null,"00:00:00",""]
[24,"Mittwoch","2023-06-14",null,null,null,"00:00:00",""]
[24,"Donnerstag","2023-06-15",null,null,null,"00:00:00",""]
[24,"Freitag","2023-06-16",null,null,null,"00:00:00",""]
[24,"Samstag","2023-06-17",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[24,"Sonntag","2023-06-18",null,null,null,"00:00:00","",null,{"$f":"SUM(H173:H179)","v":0},{"$f":"IF(J179-Daten!E$1<0,,J179-Daten!E$1)","v":0},{"$f":"IF(J179-Daten!E$1>0,,IF(J179-Daten!E$1=Daten!F$1,0,J179-Daten!E$1))","v":0}]
[25,"Montag","2023-06-19",null,null,null,"00:00:00",""]
[25,"Dienstag","2023-06-20",null,null,null,"00:00:00",""]
[25,"Mittwoch","2023-06-21",null,null,null,"00:00:00",""]
[25,"Donnerstag","2023-06-22",null,null,null,"00:00:00",""]
[25,"Freitag","2023-06-23",null,null,null,"00:00:00",""]
[25,"Samstag","2023-06-24",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[25,"Sonntag","2023-06-25",null,null,null,"00:00:00","",null,{"$f":"SUM(H180:H186)","v":0},{"$f":"IF(J186-Daten!E$1<0,,J186-Daten!E$1)","v":0},{"$f":"IF(J186-Daten!E$1>0,,IF(J186-Daten!E$1=Daten!F$1,0,J186-Daten!E$1))","v":0}]
[26,"Montag","2023-06-26",null,null,null,"00:00:00",""]
[26,"Dienstag","2023-06-27",null,null,null,"00:00:00",""]
[26,"Mittwoch","2023-06-28",null,null,null,"00:00:00",""]
[26,"Donnerstag","2023-06-29",null,null,null,"00:00:00",""]
[26,"Freitag","2023-06-30",null,null,null,"00:00:00",""]
[26,"Samstag","2023-07-01",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[26,"Sonntag","2023-07-02",null,null,null,"00:00:00","",null,{"$f":"SUM(H187:H193)","v":0},{"$f":"IF(J193-Daten!E$1<0,,J193-Daten!E$1)","v":0},{"$f":"IF(J193-Daten!E$1>0,,IF(J193-Daten!E$1=Daten!F$1,0,J193-Daten!E$1))","v":0}]
[27,"Montag","2023-07-03",null,null,null,"00:00:00",""]
[27,"Dienstag","2023-07-04",null,null,null,"00:00:00",""]
[27,"Mittwoch","2023-07-05",null,null,null,"00:00:00",""]
[27,"Donnerstag","2023-07-06",null,null,null,"00:00:00",""]
[{"$f":"_xlfn.ISOWEEKNUM(C198)","v":27},"Freitag","2023-07-07",null,null,null,"00:00:00",{"$f":"IF(E198=\"\",\"\",G198*24)","v":""}]
[27,{"$f":"TEXT(C199,\"TTTT\")","v":"Samstag"},{"$f":"C198+1","v":"2023-07-08"},null,null,null,{"$f":"E199-D199-F199","v":"00:00:00"},"",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[27,"Sonntag","2023-07-09",null,null,null,"00:00:00","",null,{"$f":"SUM(H194:H200)","v":0},{"$f":"IF(J200-Daten!E$1<0,,J200-Daten!E$1)","v":0},{"$f":"IF(J200-Daten!E$1>0,,IF(J200-Daten!E$1=Daten!F$1,0,J200-Daten!E$1))","v":0}]
[28,"Montag","2023-07-10",null,null,null,"00:00:00",""]
[28,"Dienstag","2023-07-11",null,null,null,"00:00:00",""]
[28,"Mittwoch","2023-07-12",null,null,null,"00:00:00",""]
[28,"Donnerstag","2023-07-13",null,null,null,"00:00:00",""]
[28,"Freitag","2023-07-14",null,null,null,"00:00:00",""]
[28,"Samstag","2023-07-15",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[28,"Sonntag","2023-07-16",null,null,null,"00:00:00","",null,{"$f":"SUM(H201:H207)","v":0},{"$f":"IF(J207-Daten!E$1<0,,J207-Daten!E$1)","v":0},{"$f":"IF(J207-Daten!E$1>0,,IF(J207-Daten!E$1=Daten!F$1,0,J207-Daten!E$1))","v":0}]
[29,"Montag","2023-07-17",null,null,null,"00:00:00",""]
[29,"Dienstag","2023-07-18",null,null,null,"00:00:00",""]
[29,"Mittwoch","2023-07-19",null,null,null,"00:00:00",""]
[29,"Donnerstag","2023-07-20",null,null,null,"00:00:00",""]
[29,"Freitag","2023-07-21",null,null,null,"00:00:00",""]
[29,"Samstag","2023-07-22",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[29,"Sonntag","2023-07-23",null,null,null,"00:00:00","",null,{"$f":"SUM(H208:H214)","v":0},{"$f":"IF(J214-Daten!E$1<0,,J214-Daten!E$1)","v":0},{"$f":"IF(J214-Daten!E$1>0,,IF(J214-Daten!E$1=Daten!F$1,0,J214-Daten!E$1))","v":0}]
[30,"Montag","2023-07-24",null,null,null,"00:00:00",""]
[30,"Dienstag","2023-07-25",null,null,null,"00:00:00",""]
[30,"Mittwoch","2023-07-26",null,null,null,"00:00:00",""]
[30,"Donnerstag","2023-07-27",null,null,null,"00:00:00",""]
[30,"Freitag","2023-07-28",null,null,null,"00:00:00",""]
[30,"Samstag","2023-07-29",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[30,"Sonntag","2023-07-30",null,null,null,"00:00:00","",null,{"$f":"SUM(H215:H221)","v":0},{"$f":"IF(J221-Daten!E$1<0,,J221-Daten!E$1)","v":0},{"$f":"IF(J221-Daten!E$1>0,,IF(J221-Daten!E$1=Daten!F$1,0,J221-Daten!E$1))","v":0}]
[31,"Montag","2023-07-31",null,null,null,"00:00:00",""]
[31,"Dienstag","2023-08-01",null,null,null,"00:00:00",""]
[31,"Mittwoch","2023-08-02",null,null,null,"00:00:00",""]
[31,"Donnerstag","2023-08-03",null,null,null,"00:00:00",""]
[31,"Freitag","2023-08-04",null,null,null,"00:00:00",""]
[31,"Samstag","2023-08-05",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[31,"Sonntag","2023-08-06",null,null,null,"00:00:00","",null,{"$f":"SUM(H222:H228)","v":0},{"$f":"IF(J228-Daten!E$1<0,,J228-Daten!E$1)","v":0},{"$f":"IF(J228-Daten!E$1>0,,IF(J228-Daten!E$1=Daten!F$1,0,J228-Daten!E$1))","v":0}]
[32,"Montag","2023-08-07",null,null,null,"00:00:00",""]
[32,"Dienstag","2023-08-08",null,null,null,"00:00:00",""]
[32,"Mittwoch","2023-08-09",null,null,null,"00:00:00",""]
[32,"Donnerstag","2023-08-10",null,null,null,"00:00:00",""]
[32,"Freitag","2023-08-11",null,null,null,"00:00:00",""]
[32,"Samstag","2023-08-12",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[32,"Sonntag","2023-08-13",null,null,null,"00:00:00","",null,{"$f":"SUM(H229:H235)","v":0},{"$f":"IF(J235-Daten!E$1<0,,J235-Daten!E$1)","v":0},{"$f":"IF(J235-Daten!E$1>0,,IF(J235-Daten!E$1=Daten!F$1,0,J235-Daten!E$1))","v":0}]
[33,"Montag","2023-08-14",null,null,null,"00:00:00",""]
[33,"Dienstag","2023-08-15",null,null,null,"00:00:00",""]
[33,"Mittwoch","2023-08-16",null,null,null,"00:00:00",""]
[33,"Donnerstag","2023-08-17",null,null,null,"00:00:00",""]
[33,"Freitag","2023-08-18",null,null,null,"00:00:00",""]
[33,"Samstag","2023-08-19",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[33,"Sonntag","2023-08-20",null,null,null,"00:00:00","",null,{"$f":"SUM(H236:H242)","v":0},{"$f":"IF(J242-Daten!E$1<0,,J242-Daten!E$1)","v":0},{"$f":"IF(J242-Daten!E$1>0,,IF(J242-Daten!E$1=Daten!F$1,0,J242-Daten!E$1))","v":0}]
[34,"Montag","2023-08-21",null,null,null,"00:00:00",""]
[34,"Dienstag","2023-08-22",null,null,null,"00:00:00",""]
[34,"Mittwoch","2023-08-23",null,null,null,"00:00:00",""]
[34,"Donnerstag","2023-08-24",null,null,null,"00:00:00",""]
[34,"Freitag","2023-08-25",null,null,null,"00:00:00",""]
[34,"Samstag","2023-08-26",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[34,"Sonntag","2023-08-27",null,null,null,"00:00:00","",null,{"$f":"SUM(H243:H249)","v":0},{"$f":"IF(J249-Daten!E$1<0,,J249-Daten!E$1)","v":0},{"$f":"IF(J249-Daten!E$1>0,,IF(J249-Daten!E$1=Daten!F$1,0,J249-Daten!E$1))","v":0}]
[35,"Montag","2023-08-28",null,null,null,"00:00:00",""]
[35,"Dienstag","2023-08-29",null,null,null,"00:00:00",""]
[35,"Mittwoch","2023-08-30",null,null,null,"00:00:00",""]
[35,"Donnerstag","2023-08-31",null,null,null,"00:00:00",""]
[35,"Freitag","2023-09-01",null,null,null,"00:00:00",""]
[35,"Samstag","2023-09-02",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[35,"Sonntag","2023-09-03",null,null,null,"00:00:00","",null,{"$f":"SUM(H250:H256)","v":0},{"$f":"IF(J256-Daten!E$1<0,,J256-Daten!E$1)","v":0},{"$f":"IF(J256-Daten!E$1>0,,IF(J256-Daten!E$1=Daten!F$1,0,J256-Daten!E$1))","v":0}]
[36,"Montag","2023-09-04",null,null,null,"00:00:00",""]
[36,"Dienstag","2023-09-05",null,null,null,"00:00:00",""]
[36,"Mittwoch","2023-09-06",null,null,null,"00:00:00",""]
[36,"Donnerstag","2023-09-07",null,null,null,"00:00:00",""]
[36,"Freitag","2023-09-08",null,null,null,"00:00:00",""]
[{"$f":"_xlfn.ISOWEEKNUM(C262)","v":36},"Samstag","2023-09-09",null,null,null,"00:00:00",{"$f":"IF(E262=\"\",\"\",G262*24)","v":""},null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[36,{"$f":"TEXT(C263,\"TTTT\")","v":"Sonntag"},{"$f":"C262+1","v":"2023-09-10"},null,null,null,{"$f":"E263-D263-F263","v":"00:00:00"},"",null,{"$f":"SUM(H257:H263)","v":0},{"$f":"IF(J263-Daten!E$1<0,,J263-Daten!E$1)","v":0},{"$f":"IF(J263-Daten!E$1>0,,IF(J263-Daten!E$1=Daten!F$1,0,J263-Daten!E$1))","v":0}]
[37,"Montag","2023-09-11",null,null,null,"00:00:00",""]
[37,"Dienstag","2023-09-12",null,null,null,"00:00:00",""]
[37,"Mittwoch","2023-09-13",null,null,null,"00:00:00",""]
[37,"Donnerstag","2023-09-14",null,null,null,"00:00:00",""]
[37,"Freitag","2023-09-15",null,null,null,"00:00:00",""]
[37,"Samstag","2023-09-16",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[37,"Sonntag","2023-09-17",null,null,null,"00:00:00","",null,{"$f":"SUM(H264:H270)","v":0},{"$f":"IF(J270-Daten!E$1<0,,J270-Daten!E$1)","v":0},{"$f":"IF(J270-Daten!E$1>0,,IF(J270-Daten!E$1=Daten!F$1,0,J270-Daten!E$1))","v":0}]
[38,"Montag","2023-09-18",null,null,null,"00:00:00",""]
[38,"Dienstag","2023-09-19",null,null,null,"00:00:00",""]
[38,"Mittwoch","2023-09-20",null,null,null,"00:00:00",""]
[38,"Donnerstag","2023-09-21",null,null,null,"00:00:00",""]
[38,"Freitag","2023-09-22",null,null,null,"00:00:00",""]
[38,"Samstag","2023-09-23",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[38,"Sonntag","2023-09-24",null,null,null,"00:00:00","",null,{"$f":"SUM(H271:H277)","v":0},{"$f":"IF(J277-Daten!E$1<0,,J277-Daten!E$1)","v":0},{"$f":"IF(J277-Daten!E$1>0,,IF(J277-Daten!E$1=Daten!F$1,0,J277-Daten!E$1))","v":0}]
[39,"Montag","2023-09-25",null,null,null,"00:00:00",""]
[39,"Dienstag","2023-09-26",null,null,null,"00:00:00",""]
[39,"Mittwoch","2023-09-27",null,null,null,"00:00:00",""]
[39,"Donnerstag","2023-09-28",null,null,null,"00:00:00",""]
[39,"Freitag","2023-09-29",null,null,null,"00:00:00",""]
[39,"Samstag","2023-09-30",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[39,"Sonntag","2023-10-01",null,null,null,"00:00:00","",null,{"$f":"SUM(H278:H284)","v":0},{"$f":"IF(J284-Daten!E$1<0,,J284-Daten!E$1)","v":0},{"$f":"IF(J284-Daten!E$1>0,,IF(J284-Daten!E$1=Daten!F$1,0,J284-Daten!E$1))","v":0}]
[40,"Montag","2023-10-02",null,null,null,"00:00:00",""]
[40,"Dienstag","2023-10-03",null,null,null,"00:00:00",""]
[40,"Mittwoch","2023-10-04",null,null,null,"00:00:00",""]
[40,"Donnerstag","2023-10-05",null,null,null,"00:00:00",""]
[40,"Freitag","2023-10-06",null,null,null,"00:00:00",""]
[40,"Samstag","2023-10-07",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[40,"Sonntag","2023-10-08",null,null,null,"00:00:00","",null,{"$f":"SUM(H285:H291)","v":0},{"$f":"IF(J291-Daten!E$1<0,,J291-Daten!E$1)","v":0},{"$f":"IF(J291-Daten!E$1>0,,IF(J291-Daten!E$1=Daten!F$1,0,J291-Daten!E$1))","v":0}]
[41,"Montag","2023-10-09",null,null,null,"00:00:00",""]
[41,"Dienstag","2023-10-10",null,null,null,"00:00:00",""]
[41,"Mittwoch","2023-10-11",null,null,null,"00:00:00",""]
[41,"Donnerstag","2023-10-12",null,null,null,"00:00:00",""]
[41,"Freitag","2023-10-13",null,null,null,"00:00:00",""]
[41,"Samstag","2023-10-14",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[41,"Sonntag","2023-10-15",null,null,null,"00:00:00","",null,{"$f":"SUM(H292:H298)","v":0},{"$f":"IF(J298-Daten!E$1<0,,J298-Daten!E$1)","v":0},{"$f":"IF(J298-Daten!E$1>0,,IF(J298-Daten!E$1=Daten!F$1,0,J298-Daten!E$1))","v":0}]
[42,"Montag","2023-10-16",null,null,null,"00:00:00",""]
[42,"Dienstag","2023-10-17",null,null,null,"00:00:00",""]
[42,"Mittwoch","2023-10-18",null,null,null,"00:00:00",""]
[42,"Donnerstag","2023-10-19",null,null,null,"00:00:00",""]
[42,"Freitag","2023-10-20",null,null,null,"00:00:00",""]
[42,"Samstag","2023-10-21",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[42,"Sonntag","2023-10-22",null,null,null,"00:00:00","",null,{"$f":"SUM(H299:H305)","v":0},{"$f":"IF(J305-Daten!E$1<0,,J305-Daten!E$1)","v":0},{"$f":"IF(J305-Daten!E$1>0,,IF(J305-Daten!E$1=Daten!F$1,0,J305-Daten!E$1))","v":0}]
[43,"Montag","2023-10-23",null,null,null,"00:00:00",""]
[43,"Dienstag","2023-10-24",null,null,null,"00:00:00",""]
[43,"Mittwoch","2023-10-25",null,null,null,"00:00:00",""]
[43,"Donnerstag","2023-10-26",null,null,null,"00:00:00",""]
[43,"Freitag","2023-10-27",null,null,null,"00:00:00",""]
[43,"Samstag","2023-10-28",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[43,"Sonntag","2023-10-29",null,null,null,"00:00:00","",null,{"$f":"SUM(H306:H312)","v":0},{"$f":"IF(J312-Daten!E$1<0,,J312-Daten!E$1)","v":0},{"$f":"IF(J312-Daten!E$1>0,,IF(J312-Daten!E$1=Daten!F$1,0,J312-Daten!E$1))","v":0}]
[44,"Montag","2023-10-30",null,null,null,"00:00:00",""]
[44,"Dienstag","2023-10-31",null,null,null,"00:00:00",""]
[44,"Mittwoch","2023-11-01",null,null,null,"00:00:00",""]
[44,"Donnerstag","2023-11-02",null,null,null,"00:00:00",""]
[44,"Freitag","2023-11-03",null,null,null,"00:00:00",""]
[44,"Samstag","2023-11-04",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[44,"Sonntag","2023-11-05",null,null,null,"00:00:00","",null,{"$f":"SUM(H313:H319)","v":0},{"$f":"IF(J319-Daten!E$1<0,,J319-Daten!E$1)","v":0},{"$f":"IF(J319-Daten!E$1>0,,IF(J319-Daten!E$1=Daten!F$1,0,J319-Daten!E$1))","v":0}]
[45,"Montag","2023-11-06",null,null,null,"00:00:00",""]
[45,"Dienstag","2023-11-07",null,null,null,"00:00:00",""]
[45,"Mittwoch","2023-11-08",null,null,null,"00:00:00",""]
[45,"Donnerstag","2023-11-09",null,null,null,"00:00:00",""]
[45,"Freitag","2023-11-10",null,null,null,"00:00:00",""]
[45,"Samstag","2023-11-11",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[{"$f":"_xlfn.ISOWEEKNUM(C326)","v":45},"Sonntag","2023-11-12",null,null,null,"00:00:00",{"$f":"IF(E326=\"\",\"\",G326*24)","v":""},null,{"$f":"SUM(H320:H326)","v":0},{"$f":"IF(J326-Daten!E$1<0,,J326-Daten!E$1)","v":0},{"$f":"IF(J326-Daten!E$1>0,,IF(J326-Daten!E$1=Daten!F$1,0,J326-Daten!E$1))","v":0}]
[46,{"$f":"TEXT(C327,\"TTTT\")","v":"Montag"},{"$f":"C326+1","v":"2023-11-13"},null,null,null,{"$f":"E327-D327-F327","v":"00:00:00"},""]
[46,"Dienstag","2023-11-14",null,null,null,"00:00:00",""]
[46,"Mittwoch","2023-11-15",null,null,null,"00:00:00",""]
[46,"Donnerstag","2023-11-16",null,null,null,"00:00:00",""]
[46,"Freitag","2023-11-17",null,null,null,"00:00:00",""]
[46,"Samstag","2023-11-18",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[46,"Sonntag","2023-11-19",null,null,null,"00:00:00","",null,{"$f":"SUM(H327:H333)","v":0},{"$f":"IF(J333-Daten!E$1<0,,J333-Daten!E$1)","v":0},{"$f":"IF(J333-Daten!E$1>0,,IF(J333-Daten!E$1=Daten!F$1,0,J333-Daten!E$1))","v":0}]
[47,"Montag","2023-11-20",null,null,null,"00:00:00",""]
[47,"Dienstag","2023-11-21",null,null,null,"00:00:00",""]
[47,"Mittwoch","2023-11-22",null,null,null,"00:00:00",""]
[47,"Donnerstag","2023-11-23",null,null,null,"00:00:00",""]
[47,"Freitag","2023-11-24",null,null,null,"00:00:00",""]
[47,"Samstag","2023-11-25",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[47,"Sonntag","2023-11-26",null,null,null,"00:00:00","",null,{"$f":"SUM(H334:H340)","v":0},{"$f":"IF(J340-Daten!E$1<0,,J340-Daten!E$1)","v":0},{"$f":"IF(J340-Daten!E$1>0,,IF(J340-Daten!E$1=Daten!F$1,0,J340-Daten!E$1))","v":0}]
[48,"Montag","2023-11-27",null,null,null,"00:00:00",""]
[48,"Dienstag",{"$f":"C341+1","v":"2023-11-28"},null,null,null,"00:00:00",""]
[48,"Mittwoch",{"$f":"C342+1","v":"2023-11-29"},null,null,null,"00:00:00",""]
[48,"Donnerstag","2023-11-30",null,null,null,"00:00:00",""]
[48,"Freitag","2023-12-01",null,null,null,"00:00:00",""]
[48,"Samstag","2023-12-02",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[48,"Sonntag","2023-12-03",null,null,null,"00:00:00","",null,{"$f":"SUM(H341:H347)","v":0},{"$f":"IF(J347-Daten!E$1<0,,J347-Daten!E$1)","v":0},{"$f":"IF(J347-Daten!E$1>0,,IF(J347-Daten!E$1=Daten!F$1,0,J347-Daten!E$1))","v":0}]
[49,"Montag","2023-12-04",null,null,null,"00:00:00",""]
[49,"Dienstag","2023-12-05",null,null,null,"00:00:00",""]
[49,"Mittwoch","2023-12-06",null,null,null,"00:00:00",""]
[49,"Donnerstag","2023-12-07",null,null,null,"00:00:00",""]
[49,"Freitag","2023-12-08",null,null,null,"00:00:00",""]
[49,"Samstag","2023-12-09",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[49,"Sonntag","2023-12-10",null,null,null,"00:00:00","",null,{"$f":"SUM(H348:H354)","v":0},{"$f":"IF(J354-Daten!E$1<0,,J354-Daten!E$1)","v":0},{"$f":"IF(J354-Daten!E$1>0,,IF(J354-Daten!E$1=Daten!F$1,0,J354-Daten!E$1))","v":0}]
[50,"Montag","2023-12-11",null,null,null,"00:00:00",""]
[50,"Dienstag","2023-12-12",null,null,null,"00:00:00",""]
[50,"Mittwoch","2023-12-13",null,null,null,"00:00:00",""]
[50,"Donnerstag","2023-12-14",null,null,null,"00:00:00",""]
[50,"Freitag","2023-12-15",null,null,null,"00:00:00",""]
[50,"Samstag","2023-12-16",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[50,"Sonntag","2023-12-17",null,null,null,"00:00:00","",null,{"$f":"SUM(H355:H361)","v":0},{"$f":"IF(J361-Daten!E$1<0,,J361-Daten!E$1)","v":0},{"$f":"IF(J361-Daten!E$1>0,,IF(J361-Daten!E$1=Daten!F$1,0,J361-Daten!E$1))","v":0}]
[51,"Montag","2023-12-18",null,null,null,"00:00:00",""]
[51,"Dienstag","2023-12-19",null,null,null,"00:00:00",""]
[51,"Mittwoch","2023-12-20",null,null,null,"00:00:00",""]
[51,"Donnerstag","2023-12-21",null,null,null,"00:00:00",""]
[51,"Freitag","2023-12-22",null,null,null,"00:00:00",""]
[51,"Samstag","2023-12-23",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[51,"Sonntag","2023-12-24",null,null,null,"00:00:00","",null,{"$f":"SUM(H362:H368)","v":0},{"$f":"IF(J368-Daten!E$1<0,,J368-Daten!E$1)","v":0},{"$f":"IF(J368-Daten!E$1>0,,IF(J368-Daten!E$1=Daten!F$1,0,J368-Daten!E$1))","v":0}]
[52,"Montag","2023-12-25",null,null,null,"00:00:00",""]
[52,"Dienstag","2023-12-26",null,null,null,"00:00:00",""]
[52,"Mittwoch","2023-12-27",null,null,null,"00:00:00",""]
[52,"Donnerstag","2023-12-28",null,null,null,"00:00:00",""]
[52,"Freitag","2023-12-29",null,null,null,"00:00:00",""]
[52,"Samstag","2023-12-30",null,null,null,"00:00:00","",null,{"$f":"Translate!$A$17","v":"Wochentotal"}]
[52,"Sonntag","2023-12-31",null,null,null,"00:00:00","",null,{"$f":"SUM(H369:H375)","v":0},{"$f":"IF(J375-Daten!E$1<0,,J375-Daten!E$1)","v":0},{"$f":"IF(J375-Daten!E$1>0,,IF(J375-Daten!E$1=Daten!F$1,0,J375-Daten!E$1))","v":0}]

{"sheet":"Daten","index":1,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,3,5,3],[3,4,5,4],[3,5,5,6]]}
["Kalender Woche","Datum",null,"Stunden/Woche",43,{"$f":"-E1","v":-43},null,null,"Erster Montag"]
[{"$f":"_xlfn.ISOWEEKNUM(C2)","v":52},{"$f":"DATE(Daten!E4,1,0*WEEKNUM(DATE(Daten!E4,1,))-1-IF(WEEKDAY(DATE(Daten!E4,,),1) >=5,WEEKDAY(DATE(Daten!E4,,),1) -7,WEEKDAY(DATE(Daten!E4,,),1)))","v":"2022-12-26"},{"$f":"B2+6","v":"2023-01-01"},"Stunden/Monat",{"$f":"E1*4","v":172},null,null,{"$f":"\"01.01.\"&E$4","v":"01.01.2023"},{"$f":"H2-1-WEEKDAY(H2-1,3)+7*1","v":"2023-01-02"}]
[{"$f":"_xlfn.ISOWEEKNUM(C3)","v":1},{"$f":"C2+1","v":"2023-01-02"},"2023-01-08","Heute",{"$f":"TODAY()","v":"2023-08-08"},null,null,{"$f":"\"01.02.\"&E$4","v":"01.02.2023"},{"$f":"H3-1-WEEKDAY(H3-1,3)+7*1","v":"2023-02-06"}]
[2,"2023-01-09","2023-01-15","Jahr",2023,"<--- Please change this value",null,{"$f":"\"01.03.\"&E$4","v":"01.03.2023"},{"$f":"H4-1-WEEKDAY(H4-1,3)+7*1","v":"2023-03-06"}]
[3,"2023-01-16","2023-01-22",null,null,null,null,{"$f":"\"01.04.\"&E$4","v":"01.04.2023"},{"$f":"H5-1-WEEKDAY(H5-1,3)+7*1","v":"2023-04-03"}]
[4,"2023-01-23","2023-01-29",null,null,null,null,{"$f":"\"01.05.\"&E$4","v":"01.05.2023"},{"$f":"H6-1-WEEKDAY(H6-1,3)+7*1","v":"2023-05-01"}]
[5,"2023-01-30","2023-02-05","PLEASE CHECK FIRST DATE",null,null,null,{"$f":"\"01.06.\"&E$4","v":"01.06.2023"},{"$f":"H7-1-WEEKDAY(H7-1,3)+7*1","v":"2023-06-05"}]
[6,"2023-02-06","2023-02-12",null,null,null,null,{"$f":"\"01.07.\"&E$4","v":"01.07.2023"},{"$f":"H8-1-WEEKDAY(H8-1,3)+7*1","v":"2023-07-03"}]
[7,"2023-02-13","2023-02-19",null,null,null,null,{"$f":"\"01.08.\"&E$4","v":"01.08.2023"},{"$f":"H9-1-WEEKDAY(H9-1,3)+7*1","v":"2023-08-07"}]
[8,"2023-02-20","2023-02-26",null,null,null,null,{"$f":"\"01.09.\"&E$4","v":"01.09.2023"},{"$f":"H10-1-WEEKDAY(H10-1,3)+7*1","v":"2023-09-04"}]
[9,"2023-02-27","2023-03-05",null,null,null,null,{"$f":"\"01.10.\"&E$4","v":"01.10.2023"},{"$f":"H11-1-WEEKDAY(H11-1,3)+7*1","v":"2023-10-02"}]
[10,"2023-03-06","2023-03-12",null,null,null,null,{"$f":"\"01.11.\"&E$4","v":"01.11.2023"},{"$f":"H12-1-WEEKDAY(H12-1,3)+7*1","v":"2023-11-06"}]
[11,"2023-03-13","2023-03-19",null,null,null,null,{"$f":"\"01.12.\"&E$4","v":"01.12.2023"},{"$f":"H13-1-WEEKDAY(H13-1,3)+7*1","v":"2023-12-04"}]
[12,"2023-03-20","2023-03-26"]
[13,"2023-03-27","2023-04-02"]
[14,"2023-04-03","2023-04-09"]
[15,"2023-04-10","2023-04-16"]
[16,"2023-04-17","2023-04-23"]
[17,"2023-04-24","2023-04-30"]
[18,"2023-05-01","2023-05-07"]
[19,"2023-05-08","2023-05-14"]
[20,"2023-05-15","2023-05-21"]
[21,"2023-05-22","2023-05-28"]
[22,"2023-05-29","2023-06-04"]
[23,"2023-06-05","2023-06-11"]
[24,"2023-06-12","2023-06-18"]
[25,"2023-06-19","2023-06-25"]
[26,"2023-06-26","2023-07-02"]
[27,"2023-07-03","2023-07-09"]
[28,"2023-07-10","2023-07-16"]
[29,"2023-07-17","2023-07-23"]
[30,"2023-07-24","2023-07-30"]
[31,"2023-07-31","2023-08-06"]
[32,"2023-08-07",{"$f":"B34+6","v":"2023-08-13"}]
[33,{"$f":"C34+1","v":"2023-08-14"},"2023-08-20"]
[34,"2023-08-21","2023-08-27"]
[35,"2023-08-28","2023-09-03"]
[36,"2023-09-04","2023-09-10"]
[37,"2023-09-11","2023-09-17"]
[38,"2023-09-18","2023-09-24"]
[39,"2023-09-25","2023-10-01"]
[40,"2023-10-02","2023-10-08"]
[41,"2023-10-09","2023-10-15"]
[42,"2023-10-16","2023-10-22"]
[43,"2023-10-23","2023-10-29"]
[44,"2023-10-30","2023-11-05"]
[45,"2023-11-06","2023-11-12"]
[46,"2023-11-13","2023-11-19"]
[47,"2023-11-20","2023-11-26"]
[48,"2023-11-27","2023-12-03"]
[49,"2023-12-04","2023-12-10"]
[50,"2023-12-11","2023-12-17"]
[51,"2023-12-18","2023-12-24"]
[52,"2023-12-25","2023-12-31"]
[1,"2024-01-01","2024-01-07"]

{"sheet":"Translate","index":2,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Translate"]
[]
["gearbeitet von"]
["gearbeitet bis"]
["Pause"]
["gearbeitete Stunden"]
["gearbeitete Stunden als Dezimalzahl"]
["Ferientag"]
["Überstunden"]
[]
["KW"]
["Tag"]
["Datum"]
["Erster Montag im Monat"]
[]
["Heute"]
["Wochentotal"]
["Tage"]
["Stunden"]
["Minusstunden"]
["Total Stunden"]
[]
[]
["Ja"]
[]
["Monatslohn"]
["Ferientage"]
["Feiertage"]
["Arbeitsstunden/Woche"]
["Fix Spesen"]
["Bonus"]
["Monatslöhne"]
["Lohn"]
[]
[]
["CHF"]