{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anleitung","Arbeitszeit Vorlage MA1"],"not_rendered":{"images":6},"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"merged":[[2,1,2,2],[4,1,4,2],[6,1,6,5],[9,1,9,2],[9,4,9,8],[11,1,11,2],[11,4,11,8],[13,5,13,8],[15,5,15,8],[20,4,20,8],[22,5,22,8]]}
[{"$nulls":5},"Arbeitszeit Vorlage"]
[]
[null,"Anleitung zur Staffomatic Arbeitszeit Vorlage"]
[]
[null,"Anleitung für unsere Excel Arbeitszeit-Vorlage:"]
[]
[null,"1) Bitte trage den Monat, das Jahr, den Stundenlohn und deinen Namen ein.\n\n2) Die Vorlage aktualisiert sich automatisch auf das entsprechende Jahr und den Monat und enthält tägliche Datumsangaben. Wochenenden werden automatisch in Pink markiert.\n\n3) Du kannst dann täglich die Arbeitsbeginn- und Endzeiten sowie die Gesamtpausenzeit eintragen.\n\n4) Sowohl die Brutto- als auch die Nettoarbeitszeit werden automatisch berechnet.\n\n5) Am Tabellenende findest du eine Zusammenfassung für den gesamten Monat mit der Gesamtbrutto- und Nettostundenanzahl sowie dem entsprechenden Monatslohn, der automatisch berechnet wird."]
[]
[]
[null,"Tipps zu Deiner Dienstplanung",null,null,"Nicht die richtige Vorlage für Dich? "]
[]
[null,"Beachte die folgenden Dinge bei Deiner Dienstplanung:",null,null,"Dann ist vielleicht eine unserer anderen Vorlagen passend."]
[]
[null,null,"Achte darauf, dass du gesetzliche Pausenzeiten einhälst.",null,"-","Dienstplan Vorlage"]
[]
[null,null,"FAQ zu Pausenzeiten",null,"-","Urlaubsplaner Vorlage"]
[]
[null,null,"Achte darauf, dass du die gesetzlichen Ruhezeiten einhälst"]
[]
[null,null,"FAQ zu Ruhezeiten"]
[{"$nulls":4},"Branchenspezifische Vorlagen"]
[null,null,"Bei Überstunden: Achte darauf, dass der gesetzliche Mindestlohn nicht unterschritten wird."]
[{"$nulls":4},"-","Dienstplan Vorlage für die Pflege"]
[null,null,"FAQ zu Mindestlohn"]
[]
[null,null,"Achte darauf, dass auf mögliche Zuschläge bei Wochenenden, Feiertagen usw."]
[]
[null,null,"FAQ zu Sonntagszuschlägen"]
[]
[null,null,"FAQ zu Feiertagszuschlägen"]
[]
[null,null,"Denke dran, dass du die geleisteten IST-Arbeitszeiten erfasst. Dies ist seit 2023 Pflicht."]
[]
[null,null,"FAQ zur Zeiterfassungspflicht"]
[]
[null,null,"Vorsicht beim Thema Datenschutz! Nicht alle Informationen über Deine Mitarbeitenden dürfen öffentlich ausgehangen werden."]
[]
[null,null,"FAQ: Was darf im Dienstplan stehen darf und was nicht?"]
[]
[null,null,"Beziehe die Wünsche Deiner Mitarbeitenden ein."]

{"sheet":"Arbeitszeit Vorlage MA1","index":1,"n_rows":46,"n_cols":13,"rows_kept":46,"merged":[[1,1,2,6],[1,13,1,14],[2,13,2,14],[5,2,5,3],[6,2,6,3],[6,10,6,11],[7,2,7,3],[7,10,7,11],[8,2,8,3],[8,10,8,11],[9,10,9,11],[12,9,14,10]]}
[{"$nulls":10},"Arbeitszeit Vorlage"]
[{"$nulls":12},"Woche"]
[{"$nulls":12},"Abteilung"]
[]
[]
[]
[{"$nulls":9},"Name"]
[{"$nulls":9},"Monat","Januar"]
[{"$nulls":9},"Jahr",2024]
[{"$nulls":9},"Stundenlohn",{"v":14,"d":"14.00 €"}]
[]
[]
[]
[null,null,"DATUM","START","ENDE","GESAMT BRUTTO","PAUSE (h)","ARBEITSZEIT NETTO"]
[]
[null,null,{"$f":"IFERROR(DATEVALUE(CONCATENATE(1,K8,K9)),\"\")","v":"2024-01-01"},"08:00:00","16:30:00",{"$f":"(E16-D16)","v":"08:30:00"},"01:00:00",{"$f":"F16-G16","v":"07:30:00"},null,"Monat:",{"$f":"K8","v":"Januar"}]
[null,null,{"$f":"IFERROR(C16+1,\"\")","v":"2024-01-02"},"07:45:00","16:30:00",{"$f":"(E17-D17)","v":"08:45:00"},"01:00:00",{"$f":"F17-G17","v":"07:45:00"},null,"Gesamt Brutto:",{"$f":"SUM(F16:F46)","v":8.250000000000002}]
[null,null,{"$f":"IFERROR(C17+1,\"\")","v":"2024-01-03"},"08:00:00","18:00:00","10:00:00","01:00:00","09:00:00",null,"Bruttolohn:",{"$f":"(K17*24)*K10","v":{"v":2772.000000000001,"d":"2,772.00 €"}}]
[null,null,{"$f":"IFERROR(C18+1,\"\")","v":"2024-01-04"},"07:45:00","16:30:00","08:45:00","01:00:00","07:45:00"]
[null,null,"2024-01-05","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-06",{"$nulls":6},"Gesamt Netto:",{"$f":"SUM(H16:H46)","v":7.291666666666666}]
[null,null,"2024-01-07",{"$nulls":6},"Nettolohn:",{"$f":"(K21*24)*K10","v":{"v":2450,"d":"2,450.00 €"}}]
[null,null,"2024-01-08","07:45:00","16:30:00","08:45:00","01:00:00","07:45:00"]
[null,null,"2024-01-09","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-10","07:45:00","16:30:00","08:45:00","01:00:00","07:45:00"]
[null,null,"2024-01-11","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-12","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-13","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-14","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-15","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-16","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-17"]
[null,null,"2024-01-18"]
[null,null,"2024-01-19","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-20","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-21","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-22","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-23","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-24"]
[null,null,"2024-01-25"]
[null,null,"2024-01-26","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-27","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-28","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-29","08:00:00","16:30:00","08:30:00","01:00:00","07:30:00"]
[null,null,"2024-01-30"]
[null,null,"2024-01-31"]