{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Anleitung","Dienstplan"],"not_rendered":{"images":7},"read":"whole","date_system":"1900"}

{"sheet":"Anleitung","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[0,6,0,8],[2,1,2,2],[4,1,4,5],[8,1,8,2],[8,4,8,8],[10,1,10,2],[10,4,10,8],[12,5,12,8],[14,5,14,8],[19,4,19,8],[21,5,21,8]]}
[{"$nulls":6},"Schichtplan"]
[]
[null,"Anleitung zur 3 Schichtssystem Vorlage"]
[]
[null,"1.) Du kannst jeden Tag einzeln planen\n\n2.) Trage für jede:n Mitarbeitende:n ein, zu welcher Uhrzeit diese/r Dienst hat und in welchem Arbeitsbereich der Einsatz ist. Die drei Schichtsysteme (Frühschicht, Spätschicht und Nachtschicht) findest du als Legende in der Vorlage."]
[]
[]
[]
[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 Excel Vorlage"]
[]
[null,null,"FAQ zu Pausenzeiten",null,"-","Urlaubsplaner 2024"]
[]
[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":"Dienstplan","index":1,"n_rows":66,"n_cols":16,"rows_kept":66,"merged":[[1,1,2,5],[1,12,1,13],[2,12,2,13],[4,1,5,1],[13,1,14,1],[22,1,23,1],[31,1,32,1],[40,1,41,1],[49,1,50,1],[58,1,59,1]]}
[{"$nulls":11},"Schichtplan"]
[]
[{"$nulls":11},"Abteilung"]
[]
[null,"Montag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1","Arbeitsbereich 1",{"$nulls":12},{"$f":"COUNTIF(Dienstplan!$C7:$L7,\"*\")","v":1}]
[null,"Mitarbeiter 2","Arbeitsbereich 2",{"$nulls":12},{"$f":"COUNTIF(Dienstplan!$C8:$L8,\"*\")","v":1}]
[null,"Mitarbeiter 3","Arbeitsbereich 3",{"$nulls":12},{"$f":"COUNTIF(Dienstplan!$C9:$L9,\"*\")","v":1}]
[null,"Mitarbeiter 4",{"$nulls":12},"abwesend",{"$f":"COUNTIF(Dienstplan!$C10:$L10,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C11:$L11,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C12:$L12,\"*\")","v":0}]
[]
[null,"Dienstag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C16:$L16,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C17:$L17,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C18:$L18,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C19:$L19,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C20:$L20,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C21:$L21,\"*\")","v":0}]
[]
[null,"Mittwoch"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C25:$L25,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C26:$L26,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C27:$L27,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C28:$L28,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C29:$L29,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C30:$L30,\"*\")","v":0}]
[]
[null,"Donnerstag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C34:$L34,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C35:$L35,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C36:$L36,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C37:$L37,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C38:$L38,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C39:$L39,\"*\")","v":0}]
[]
[null,"Freitag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C43:$L43,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C44:$L44,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C45:$L45,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C46:$L46,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C47:$L47,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C48:$L48,\"*\")","v":0}]
[]
[null,"Samstag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C52:$L52,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C53:$L53,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C54:$L54,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C55:$L55,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C56:$L56,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C57:$L57,\"*\")","v":0}]
[]
[null,"Sonntag"]
[null,null,"08:00 - 09:00","09:00 - 10:00","10:00 - 11:00","11:00 - 12:00","12:00 - 13:00","13:00 - 14:00","14:00 - 15:00","15:00 - 16:00","16:00 - 17:00","17:00 - 18:00","18:00 - 19:00","19:00 - 20:00","abwesend","Stunden"]
[null,"Mitarbeiter 1",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C61:$L61,\"*\")","v":0}]
[null,"Mitarbeiter 2",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C62:$L62,\"*\")","v":0}]
[null,"Mitarbeiter 3",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C63:$L63,\"*\")","v":0}]
[null,"Mitarbeiter 4",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C64:$L64,\"*\")","v":0}]
[null,"Mitarbeiter 5",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C65:$L65,\"*\")","v":0}]
[null,"Mitarbeiter 6",{"$nulls":13},{"$f":"COUNTIF(Dienstplan!$C66:$L66,\"*\")","v":0}]