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

{"sheet":"Monat","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[0,1,0,8],[1,4,1,5],[6,12,6,15],[11,12,11,15],[13,12,13,15],[15,12,15,15],[33,12,33,13],[33,14,33,15],[35,1,35,6],[35,11,35,12],[35,13,35,14],[35,15,35,16],[36,11,36,14],[36,15,36,16],[37,11,38,14],[37,15,38,16],[39,11,41,14],[39,15,41,16]]}
[null,"2024-07-01"]
[{"$nulls":4},"Arbeitszeit"]
[{"$nulls":4},"von","bis","Pause","Stunden","Tätigkeit"]
[null,{"$f":"B1","v":"2024-07-01"},{"$f":"B4","v":"2024-07-01"},{"$nulls":4},{"$f":"IF(F4,IF(E4,IF(E4>F4,F4+\"24:00\"-E4,F4-E4)-G4,\"\"),\"\")","v":""},null,null,"Abteilung I"]
[null,{"$f":"B4+1","v":"2024-07-02"},{"$f":"B5","v":"2024-07-02"},{"$nulls":4},"",null,null,"Personal"]
[null,{"$f":"B5+1","v":"2024-07-03"},{"$f":"B6","v":"2024-07-03"},{"$nulls":4},""]
[null,"2024-07-04","2024-07-04",null,"08:00:00","16:00:00","00:30:00","07:30:00","Beispiel",null,null,"Fachbereich:","M+W"]
[null,"2024-07-05","2024-07-05",{"$nulls":4},""]
[null,"2024-07-06","2024-07-06",{"$nulls":4},"",{"$nulls":3},"Abrechnung/ Nachweis für studentische/wissenschaftliche Hilfskräfte an der TH Lübeck"]
[null,"2024-07-07","2024-07-07",{"$nulls":4},""]
[null,"2024-07-08","2024-07-08",{"$nulls":4},""]
[null,"2024-07-09","2024-07-09",null,"08:00:00","16:00:00","00:30:00","07:30:00","Beispiel",null,null,"Name, Vorname:","Mustermann, Max"]
[null,"2024-07-10","2024-07-10",{"$nulls":4},""]
[null,"2024-07-11","2024-07-11",{"$nulls":4},"",{"$nulls":3},"Straße:","Musterstr. 0815"]
[null,"2024-07-12","2024-07-12",{"$nulls":4},{"$f":"IF(F15,IF(E15,IF(E15>F15,F15+\"24:00\"-E15,F15-E15)-G15,\"\"),\"\")","v":""}]
[null,"2024-07-13","2024-07-13",{"$nulls":4},"",{"$nulls":3},"PLZ, Wohnort:","08151 Musterhausen"]
[null,"2024-07-14","2024-07-14",{"$nulls":4},""]
[null,"2024-07-15","2024-07-15",{"$nulls":4},"",{"$nulls":3},"Immatrikuliert:"]
[null,"2024-07-16","2024-07-16",{"$nulls":4},""]
[null,"2024-07-17","2024-07-17",{"$nulls":4},"",null,null,"   Änderung der persönlichen Daten (z.B. Adresse, Kontoverbindungen etc.) sind der Abteilung I unverzüglich schriftlich"]
[null,"2024-07-18","2024-07-18",{"$nulls":4},"",null,null,"    mitzuteilen."]
[null,"2024-07-19","2024-07-19",{"$nulls":4},""]
[null,"2024-07-20","2024-07-20",{"$nulls":4},"",null,null,"   Für jeden Kalendermonat ist ein separater Nachweis zu verwenden, der handschriftlich zu unterzeichnen ist. "]
[null,"2024-07-21","2024-07-21",{"$nulls":4},"",null,null,"   Der Stundennachweis ist vollständig unterzeichnet 6 Monate nach Vertragsende in Kopie auzubewahren und bei Verlangen"]
[null,"2024-07-22","2024-07-22",{"$nulls":4},"",null,null,"   vorzulegen."]
[null,"2024-07-23","2024-07-23",{"$nulls":4},""]
[null,"2024-07-24","2024-07-24",{"$nulls":4},"",null,null,"   Hiermit bestätige ich, dass die Anzahl der Zeitstunden aufgrund gesetzlich vorgeschriebener Pausen von der tatsächlichen"]
[null,"2024-07-25","2024-07-25",{"$nulls":4},"",null,null,"   Arbeitszeit abweichen kann. Ich erkläre, dass ich an den niedergeschriebenen  Tagen weisungsgemäß Hilfstätigkeiten"]
[null,"2024-07-26","2024-07-26",{"$nulls":4},"",null,null,"   geleistet habe."]
[null,"2024-07-27","2024-07-27",{"$nulls":4},""]
[null,"2024-07-28","2024-07-28",{"$nulls":4},""]
[null,"2024-07-29","2024-07-29",{"$nulls":4},"",null,null,"¨ Grundhaushalt",null,null,"¨ Drittmittel",null," ¨ ZSL"]
[null,"2024-07-30","2024-07-30",{"$nulls":4},""]
[null,"2024-07-31","2024-07-31",{"$nulls":4},"",{"$nulls":4},"Kostenstelle:"]
[]
[null,"Stunden Gesamt",{"$nulls":5},{"$f":"SUM(H4:H34)","v":0.625},"       Abt. I - In Liste übertragen:",null,"Lübeck, "]
[{"$nulls":10},{"$f":"TODAY()","v":"2024-06-18"},"Unterschrift",{"$nulls":3},"Unterschrift"]
[{"$nulls":11},"Name leserlich",{"$nulls":3},{"$f":"M12","v":"Mustermann, Max"}]
[]
[{"$nulls":11},"Unterschriftsberechtigte_r \n Sachlich und Rechnerich richtig",{"$nulls":3},"Studentische-/ \nWissenschaftliche\nHilfskraft"]
[{"$nulls":8},"Abt.I - Version 2.0 ,08.04.2019"]

{"sheet":"Feiertage","index":1,"n_rows":49,"n_cols":4,"rows_kept":49}
["Datum",{"$f":"YEAR(Monat!B1)","v":2024},"Feiertag?"]
[{"$f":"DATEVALUE(\"01.01.\"&$B$1)","v":"2024-01-01"},{"$f":"IF(C2=\"x\",A2,0)","v":"2024-01-01"},"x","Neujahr"]
[{"$f":"DATEVALUE(\"02.01.\"&$B$1)","v":"2024-01-02"},{"$f":"IF(C3=\"x\",A3,0)","v":"00:00:00"},null,"Berchtoldstag"]
[{"$f":"DATEVALUE(\"06.01.\"&$B$1)","v":"2024-01-06"},{"$f":"IF(C4=\"x\",A4,0)","v":"00:00:00"},null,"3 Könige"]
[{"$f":"A8-48","v":"2024-02-12"},"00:00:00",null,"Rosenmontag"]
[{"$f":"A8-2","v":"2024-03-29"},"2024-03-29","x","Karfreitag"]
[{"$f":"A8-1","v":"2024-03-30"},"00:00:00",null,"Ostersamstag"]
[{"$f":"DOLLAR((DAY(MINUTE($B$1/38)/2+55) & \".4.\" & $B$1)/7,)*7-IF(YEAR(1)=1904,5,6)","v":"2024-03-31"},"2024-03-31","x","Ostersonntag"]
[{"$f":"A8+1","v":"2024-04-01"},"2024-04-01","x","Ostermontag"]
[{"$f":"DATEVALUE(\"01.05.\"&$B$1)","v":"2024-05-01"},"2024-05-01","x","1. Mai"]
[{"$f":"A8+39","v":"2024-05-09"},"2024-05-09","x","Christi Himmelfahrt"]
[{"$f":"DATE($B$1,5,1)+15-WEEKDAY(DATE($B$1,5,1))","v":"2024-05-12"},"00:00:00",null,"Muttertag"]
[{"$f":"A8+48","v":"2024-05-18"},"00:00:00",null,"Pfingstsamstag"]
[{"$f":"A8+49","v":"2024-05-19"},"2024-05-19","x","Pfingstsonntag"]
[{"$f":"A8+50","v":"2024-05-20"},"2024-05-20","x","Pfingstmontag"]
[{"$f":"A8+60","v":"2024-05-30"},"00:00:00",null,"Fronleichnam"]
[{"$f":"DATEVALUE(\"01.08.\"&$B$1)","v":"2024-08-01"},"00:00:00",null,"Nationalfeiertag (CH)"]
[{"$f":"DATEVALUE(\"03.10.\"&$B$1)","v":"2024-10-03"},"2024-10-03","x","Tag der deutschen Einheit (D)"]
[{"$f":"DATE($B$1,10,1)+7-WEEKDAY(DATE($B$1,10,1),2)","v":"2024-10-06"},"00:00:00",null,"Erntedankfest"]
["2018-10-26","00:00:00",null,"Nationalfeiertag (AT)"]
[{"$f":"DATEVALUE(\"31.10.\"&$B$1)","v":"2024-10-31"},"2024-10-31","x","Reformationstag"]
[{"$f":"DATEVALUE(\"01.11.\"&$B$1)","v":"2024-11-01"},"00:00:00",null,"Allerheiligen"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-35","v":"2024-11-17"},"00:00:00",null,"Volkstrauertag"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-32","v":"2024-11-20"},"00:00:00",null,"Buss- und Bettag"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-28","v":"2024-11-24"},"00:00:00",null,"Totensonntag/Ewigkeitssontag"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-21","v":"2024-12-01"},"00:00:00",null,"1. Advent"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-14","v":"2024-12-08"},"00:00:00",null,"2. Advent"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)-7","v":"2024-12-15"},"00:00:00",null,"3. Advent"]
[{"$f":"DATE($B$1,12,25)-WEEKDAY(DATE($B$1,12,25),2)","v":"2024-12-22"},"00:00:00",null,"4. Advent"]
[{"$f":"DATEVALUE(\"24.12.\"&$B$1)","v":"2024-12-24"},"00:00:00",null,"Heilig Abend"]
[{"$f":"DATEVALUE(\"25.12.\"&$B$1)","v":"2024-12-25"},"2024-12-25","x","1. Weihnachtstag"]
[{"$f":"DATEVALUE(\"26.12.\"&$B$1)","v":"2024-12-26"},"2024-12-26","x","2. Weihnachtstag"]
[{"$f":"DATEVALUE(\"31.12.\"&$B$1)","v":"2024-12-31"},"00:00:00",null,"Silvester"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]
[null,"00:00:00"]