{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Startseite","Hilfe","Basisdaten","Feiertage","Mitarbeiter","Dienstplan KW Vorlage","Jahresdienstplan Vorlage","<Abteilung 1>KW1","<Abteilung 2>KW1","Tabvorlage","VERLAUF","Tabelle1","ICONS"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":51,"comments":2,"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":"Startseite","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,2,25,4],[26,2,26,4],[24,6,24,8],[25,6,25,8],[26,6,26,8],[22,6,22,8],[23,6,23,8],[12,2,12,4],[12,6,12,8],[24,2,24,4],[13,2,13,4],[13,6,13,8],[14,2,14,4],[14,6,14,8],[17,2,17,4],[17,6,17,8],[15,2,15,4],[15,6,15,8],[16,2,16,4],[16,6,16,8],[9,2,9,9],[28,7,28,10],[0,1,3,10],[20,2,20,4],[21,2,21,4],[22,2,22,4],[11,2,11,4],[18,2,18,4],[19,2,19,4],[10,6,10,8],[11,6,11,8],[18,6,18,8],[19,6,19,8],[23,2,23,4],[20,6,20,8],[21,6,21,8]]}
[null,"Dienstplan 2022"]
[]
[]
[]
[]
[]
[null,null,{"$f":"B1","v":"Dienstplan 2022"}]
[null,null,"Ignatz Schels, Wolnzach"]
[]
[null,null,"Ob im Call-Center oder Pflegedienst, im Schulbereich oder auf Wache - Dienstpläne werden für zahlreiche Zwecke gebraucht. Dieses Tool erstellt Wochen- und Jahrespläne und bietet die Möglichkeit, Mitarbeiter schnell in den Plan einzutragen. Die Wochenpläne werden nach Kalenderwochen organisiert, das Tool benutzt für die Berechnung von KW, Feiertagen und Datumswerten eine Mischung aus Excel-Funktionen und Makros."]
[null,null,"» Hilfe",null,null,null,"» Dienstplan KW Vorlage"]
[null,null,"» Basisdaten",null,null,null,"» Jahresdienstplan Vorlage"]
[null,null,"» Feiertage",null,null,null,"» <Abteilung 1>KW1"]
[null,null,"» Mitarbeiter",null,null,null,"» <Abteilung 2>KW1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Tabelle einfügen / Startseite konfigurieren"]

{"sheet":"Hilfe","index":1,"n_rows":195,"n_cols":14,"rows_kept":195,"cut":false,"hidden":false,"merged":[[194,3,194,13],[179,3,179,13],[182,3,182,13],[133,3,133,13],[149,3,149,13],[150,3,150,13],[165,3,165,13],[186,3,186,13],[190,3,190,13],[173,3,173,13],[177,3,177,13],[138,3,138,13],[140,4,140,13],[144,3,144,13],[169,3,169,13],[0,2,2,11],[168,11,168,14],[135,3,135,13],[127,3,127,13],[5,3,5,4],[124,3,124,13],[148,3,148,13],[131,3,131,13],[6,3,6,4],[123,3,123,13]]}
[null,null,"Anwenderhilfe für Excel"]
[]
[]
[]
[]
[null,null,null,"» Inhaltliche Hilfe",null,null,null,null,null,null,null,null,null,"» Startseite"]
[null,null,null,"» Technische Hilfe"]
[]
[]
[null,null,null,"Inhaltliche Hilfe"]
[]
[null,null,null,"Basisdaten","Tragen Sie hier die Rahmenbedingungen für den Dienstplan ein. "]
[null,null,null,null,"D10: Firmenname, D12: laufendes Jahr"]
[null,null,null,null,"Kreuzen Sie in D15:D21 die Arbeitstage an, die im Dienstplan berücksichtigt werden sollen."]
[null,null,null,null,"Arbeitsfreie Tage werden im Wochen- und Jahresplan automatisch farbig gekennzeichnet"]
[null,null,null,null,"Stunden pro Tag: Hier bestimmen Sie die Zeilenbeschriftungen für den Wochenplan"]
[null,null,null,null,"Die Angabe der Art (Dienst oder Pause) ist wichtig, Pausen werden in der Auswertung ausgefiltert"]
[]
[null,null,null,null,"Farben im Wochenplan: Diese Farben werden für neue Wochenpläne benutzt"]
[null,null,null,null,"Stationen: Bestimmen Sie im Bereich O11:O25 die Bezeichnungen der Bereiche, "]
[null,null,null,null,"für die Sie Wochenpläne erstellen."]
[null,null,null,null,"Kalenderwochen: Hier werden die Kalenderwochen für das laufende Jahr (D12) berechnet"]
[null,null,null,null,"In Spalte R sehen Sie das Datum des ersten Tages jeder Kalenderwoche (immer ein Montag)"]
[]
[null,null,null,"Feiertage","In dieser Tabelle werden die Feiertage des Auswertungsjahres berechnet, und zwar ohne VBA-Makros"]
[null,null,null,null,"Diese Feiertage werden im Wochen- und Jahresplan markiert, im Wochenplan mit Namenseintrag"]
[null,null,null,null,"Markieren Sie in Spalte A das Bundesland, in dem Sie sich befinden. Die Feiertagsliste enthält alle"]
[null,null,null,null,"Feiertage, die möglich sind. Mit der Auswahl des Bundeslandes werden die nicht zutreffenden Feiertage"]
[null,null,null,null,"automatisch ausgeblendet."]
[null,null,null,null,"Wenn Sie weitere Feiertage oder freie Tage für die Wochen- und Jahresplanung vorsehen wollen"]
[null,null,null,null,"(z. B. Rosenmontag) tragen Sie bitte das Datum in G25 (bis G28) und die Bezeichnung in H25 bis H28 ein."]
[]
[null,null,null,"Mitarbeiter","Tragen Sie hier die Mitarbeiterdaten ein, die Sie in den Wochenplan übertragen wollen."]
[null,null,null,null,"Die Überschriften können Sie jederzeit wechseln, statt Abteilung können Sie z.B. auch Schicht schreiben."]
[null,null,null,null,"Die Makrolösung übernimmt die Überschriften der Spalten E bis H. Achten Sie auch darauf, dass keine Leerzeilen"]
[null,null,null,null,"zwischen den Mitarbeiternamen stehen."]
[]
[null,null,null,"Dienstplan KW","Das ist die Vorlage für die Wochendienstpläne. Die Makrolösung wird diese Vorlage mit den Angaben in der Tabelle"]
[null,null,null,"Vorlage","Basisdaten füllen und die Datumswerte für die Kalenderwoche berechnen."]
[null,null,null,null,"Sie können diese Vorlage nach Belieben formatieren und gestalten, ändern Sie aber nicht den Aufbau des"]
[null,null,null,null,"Kopfbereiches und fügen Sie keine Spalten ein."]
[]
[null,null,null,"Jahresdienstplan","Das ist die Vorlage für den Jahresdienstplan mit Berechnung der Kalenderwochen. Die Makrolösung wird"]
[null,null,null,"Vorlage","automatisch die Stunden (ohne Pausen) eintragen und die Einträge aus allen Wochendienstplänen übertragen"]
[null,null,null,null,"Bitte ändern Sie diese Vorlage nicht, da das Makro genau auf den Aufbau der Zeilen und Spalten abgestimmt ist."]
[]
[null,null,null,null,"Die Makrolösung"]
[null,null,null,null,"Mit dem Start dieser Mappe erhalten Sie eine neue Symbolleiste \"Dienstplan\"."]
[null,null,null,null,"Diese Symbolleiste wird mit dem Schliessen der Mappe automatisch wieder entfernt."]
[null,null,null,null,"Wählen Sie die einzelnen Optionen, um neue Dienstpläne anzulegen,"]
[null,null,null,null,"Dienstpläne auszuwählen oder zu löschen, Jahrespläne zu erstellen,"]
[null,null,null,null,"oder Mitarbeiterdaten in die Wochenpläne zu übertragen."]
[]
[]
[]
[null,null,null,null,"Dienstplan neu"]
[null,null,null,null,"Erstellen Sie mit dieser Option einen neuen Wochendienstplan."]
[null,null,null,null,"Wählen Sie die Kalenderwoche. Anfangs- und Enddatum"]
[null,null,null,null,"werden automatisch berechnet."]
[null,null,null,null,"Wählen Sie eine Station aus. Die Liste zeigt die Einträge in der"]
[null,null,null,null,"Tabelle Basisdaten (O11:O25)."]
[null,null,null,null,"Klicken Sie auf \"Dienstplan erstellen\", um eine Kopie der KW Vorlage"]
[null,null,null,null,"anzulegen, in der die neue KW, die Stundeneinteilung"]
[null,null,null,null,"aus den Basisdaten und die Bezeichnung der Station eingetragen ist"]
[null,null,null,null,"Der Name der neuen Tabelle wird die Bezeichnung der Station in "]
[null,null,null,null,"spitzen Klammern und die KW-Nummer enthalten:"]
[null,null,null,null,"<Station 1>KW1"]
[null,null,null,null,"Ändern Sie diese Bezeichnung nicht, da sie für die Jahresplanauswertung"]
[null,null,null,null,"genau in dieser Form benötig wird."]
[]
[null,null,null,null,"Dienstpläne verwalten"]
[null,null,null,null,"Wählen Sie diese Option, um alle Dienstpläne einer Station aufzulisten"]
[null,null,null,null,"Suchen Sie zuerst die Station in der ersten Liste. Die Dienstpläne"]
[null,null,null,null,"dieser Station werden in der zweiten Liste angezeigt."]
[null,null,null,null,"Sie können einen markierten Dienstplan aktivieren oder löschen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Jahresplan erstellen"]
[null,null,null,null,"Mit dieser Option erstellen Sie einen Jahresplan aus allen Dienstplänen"]
[null,null,null,null,"einer Station. Im ersten Feld wird das laufende Jahr angezeigt."]
[null,null,null,null,"Wählen Sie zuerst eine Station."]
[null,null,null,null,"Klicken Sie dann auf einzelne Dienstpläne oder auf \"Alle auswählen\","]
[null,null,null,null,"um alle Dienstpläne zu markieren."]
[null,null,null,null,"Mit \"Erstellen\" wird eine Kopie der Jahresplanvorlage angelegt"]
[null,null,null,null,"und die Daten aus den Dienstplänen werden eingetragen."]
[null,null,null,null,"Achten Sie darauf, dass die Stundeneinteilung aller Dienstpläne "]
[null,null,null,null,"identisch sein muss."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Mitarbeiter eintragen"]
[null,null,null,null,"Diese Option öffnet eine Liste mit allen Daten-"]
[null,null,null,null,"sätzen aus der Mitarbeitertabelle."]
[null,null,null,null,"Aktivieren Sie einen Dienstplan und markieren"]
[null,null,null,null,"im Bereich ab Zelle E12 die Zelle(n), die Sie "]
[null,null,null,null,"Sie beschriften wollen. Wählen Sie die Information,"]
[null,null,null,null,"die Sie eintragen wollen,über die Optionen rechts."]
[null,null,null,null,"Klicken Sie auf einen Mitarbeiter, und klicken"]
[null,null,null,null,"Sie auf \"Eintragen\", um die Information in die"]
[null,null,null,null,"markierten Zellen einzutragen."]
[null,null,null,null,"Diese Dialogbox bleibt im Hintergrund offen, Sie"]
[null,null,null,null,"können in der Tabelle oder Mappe weiterarbeiten"]
[null,null,null,null,"und die Mitarbeiterliste einfach wieder anklicken, "]
[null,null,null,null,"wenn Sie einen neuen Eintrag brauchen."]
[]
[]
[]
[null,null,null,"Technische Hilfe",null,null,null,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Zum komfortablen Umgang mit diesem und anderen Excel-Tools erläutern wir hier einige Funktionen, die Sie beim Arbeiten mit Excel häufig benötigen, wie etwa die Anpassung der Startseite an Ihre persönlichen Bedürfnisse oder die Möglichkeiten der Haufe Toolbar. "]
[]
[]
[null,null,null,"Startseite konfigurieren"]
[null,null,null,"Über den Link Startseite konfigurieren gelangen Sie in ein Dialogfeld, in dem Sie alle nötigen Anpassungen der Startseite vornehmen können. \nHier können Sie weitere Tabellen einfügen, diese umbenennen oder löschen. Haben Sie eine Tabelle in der Liste markiert, können Sie mithilfe der Pfeiltasten die Reihenfolge der Tabellen ändern. Diese Änderung wirkt sich sowohl auf die Darstellung auf der Startseite aus, als auch auf die Position der Tabelle im Blattregister und im Listenfeld in der Toolbar."]
[]
[]
[]
[null,null,null,"Klicken Sie auf Speichern, werden die vorgenommenen Änderungen wirksam und Sie springen zurück zur Startseite."]
[]
[null,null,null,"Wenn Sie eine Tabelle im Listenfeld ausgewählt haben, gelangen Sie über den Button Gehe zu direkt zur gewünschten Tabelle."]
[]
[null,null,null,"Möchten Sie eine Tabelle umbenennen, markieren Sie diese und vergeben Sie im nebenstehenden Feld einen neuen Namen. \nMithilfe des Buttons Tabelle umbenennen werden die Änderungen gespeichert."]
[]
[null,null,null,"Logo auswählen"]
[null,null,null,"Über das Feld Logo auswählen können Sie Ihr eigenes Firmenlogo auf jeder Tabellenseite einbinden. Klicken Sie auf Durchsuchen, wählen Sie die gewünschte Datei aus und importieren Sie diese mithilfe des Buttons Hochladen.\nBitte beachten Sie dabei unbedingt die maximale Größe des neuen Logos. Die Datei sollte die Maße 35 px (Breite) und 84px (Höhe) nicht überschreiten. Bitte achten Sie auch darauf, dass die Datei 50 KB nicht überschreitet."]
[]
[null,null,null,"Hinweis:","Bitte ändern Sie die Namen der Blattregister nur über das Dialogfeld Tabelle einfügen/Startseite konfigurieren auf der Startseite. \nWenn Sie die Blattregister per Doppelklick umbenennen, funktionieren die Navigationslinks der Startseite bis zu einer Aktualisierung nicht mehr)."]
[]
[]
[null,null,null,"Haufe Toolbar"]
[null,null,null,"Die Haufe Toolbar ist das zentrale Navigationselement und erleichtert Ihnen die Navigation innerhalb des Tools. Hier werden ebenfalls die wichtigsten Funktionen für die Handhabung des Tools angeboten."]
[]
[]
[]
[null,null,null,"Mithilfe der Vor- und Zurück-Schaltflächen können Sie innerhalb der zuletzt aufgerufenen Seiten navigieren."]
[null,null,null,"Über das Listenfeld rufen Sie direkt die gewünschten Tabellen auf."]
[null,null,null,"Die wichtigsten Funktionen Speichern, Drucken, Kopieren und Einfügen werden ebenfalls zentral in der Toolbar angeboten"]
[]
[]
[null,null,null,"Optionen"]
[]
[null,null,null,null,null,null,null,"» Gitternetz ein/aus"]
[null,null,null,null,null,null,null,"» Zeilen- und Spaltenbeschriftung ein/aus"]
[null,null,null,null,null,null,null,"» Blattregister ein/aus"]
[null,null,null,null,null,null,null,"» Kopf- und Fußzeile anpassen"]
[null,null,null,null,null,null,null,"» Zoom einstellen"]
[]
[]
[]
[]
[null,null,null,"Gitternetz ein/aus"]
[null,null,null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige des Gitternetzes ein- und ausschalten."]
[]
[]
[null,null,null,"Zeilen- und Spaltenbeschriftung ein/aus"]
[null,null,null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige der Zeilen- und Spaltenköpfe ein- und ausschalten. "]
[]
[]
[null,null,null,"Blattregister ein/aus"]
[null,null,null,"Mit Hilfe dieses Menübefehls können Sie die Anzeige der Blattregister ein- und ausschalten."]
[]
[]
[null,null,null,"Kopf- und Fußzeile bearbeiten"]
[null,null,null,"Über diesen Menübefehl rufen Sie einen Dialog auf, in dem Sie Ihre Kopf- und Fußzeilen einstellen können. Auf dem Reiter Eingabe Daten können Sie Angaben zur Firma, zur Abteilung und zum Autor eintragen."]
[]
[null,null,null,"Auf dem Reiter Kopf- und Fußzeile anpassen können Sie auswählen, wo die gewünschten Angaben platziert werden sollen. \nWählen Sie dazu den Bereich (Kopf- oder Fußzeile) aus, sowie die Platzierung (Links, Mitte oder Rechts)."]
[]
[]
[null,null,null,"Damit Sie Ihre Einstellungen in der Vorschau überprüfen können, müssen Sie die Einstellungen übernehmen mithilfe des gleichnamigen Buttons. Die Schaltfläche Alle Kopf- und Fußzeilen entfernen löscht alle Eintragungen in der Kopf- und Fußzeile. \nBitte beachten Sie, dass diese beiden Vorgänge etwas Zeit in Anspruch nehmen können."]
[]
[]
[null,null,null,"Zoom einstellen"]
[null,null,null,"Mit Hilfe dieses Menübefehls können Sie den Zoom für die einzelnen Arbeitsblätter einstellen. Standardmäßig ist ein 85%-iger Zoom eingestellt, den Sie jedoch jederzeit ändern können."]
[]
[]
[null,null,null,"Hilfe"]
[null,null,null,"Über den Hilfe-Button der Haufe Toolbar gelangen Sie auf die Hilfe-Seite, die Ihnen inhaltliche Hilfestellung bietet, sowie Hinweise zur technischen Handhabung des Tools."]
[]
[]
[null,null,null,"Hinweis"]
[null,null,null,"Beim mehrmaligen Öffnen mit dem IE 7 aus einer Online-Version heraus, erscheint die Meldung, dass dieses Tool bereits verwendet wird. Öffnen Sie es schreibgeschützt und speichern Sie es lokal auf Ihrem Rechner ab. Wenn Sie die Meldung unterbinden möchten, aktivieren Sie über Extras > Internetoptionen > Erweitert > Bei Einstellungen/Sicherheit die Option \"Leeren des Ordners für temporäre Internetdateien beim Schließen des Browsers\"."]

{"sheet":"Basisdaten","index":2,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,2,2,20],[11,3,11,4],[7,6,7,9],[7,3,7,4],[10,3,10,4],[9,3,9,4]]}
[null,null,"Basisdaten"]
[]
[]
[]
[]
[null,null,null,"Basisdaten",null,null,null,null,null,null,null,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Firma",null,null,"Stunden pro Tag",null,null,null,null,"Farben im Wochenplan",null,null,"Stationen",null,"Kalenderwochen",null,null,"» Startseite"]
[]
[null,null,null,"ABC Call Center",null,null,"von","bis","Art","Zeilenhöhe",null,"Dienst",null,null,"Abteilung 1",null,1,{"$f":"DATE(JAHR,1,7*Q10-3-WEEKDAY(DATE(JAHR,,),3))","v":"2022-01-03"},null,1]
[null,null,null,"Jahr",null,null,"08:00:00","08:30:00","Dienst",20,null,"Arbeitsfrei",null,null,"Abteilung 2",null,2,"2022-01-10"]
[null,null,null,2022,null,null,"08:45:00","09:30:00","Dienst",20,null,"Feiertag",null,null,"Abteilung 3",null,3,"2022-01-17"]
[null,null,null,null,null,null,"09:30:00","09:45:00","Pause",15,null,null,null,null,"Abteilung 4",null,4,"2022-01-24"]
[null,null,null,{"$f":"IF(D15,1,0)&IF(D16,2,0)&IF(D17,3,0)&IF(D18,4,0)&IF(D19,5,0)&IF(D20,6,0)&IF(D21,7,0)","v":"1234500"},"Arbeitstage pro Woche",null,"10:15:00","11:00:00","Dienst",20,null,null,null,null,null,null,5,"2022-01-31"]
[null,null,null,true,"Montag",null,"11:00:00","11:45:00","Dienst",20,null,null,null,null,null,null,6,"2022-02-07"]
[null,null,null,true,"Dienstag",null,"11:45:00","12:30:00","Dienst",20,null,null,null,null,null,null,7,"2022-02-14"]
[null,null,null,true,"Mittwoch",null,"12:30:00","12:45:00","Pause",15,null,null,null,null,null,null,8,"2022-02-21"]
[null,null,null,true,"Donnerstag",null,"12:45:00","13:30:00","Dienst",20,null,null,null,null,null,null,9,"2022-02-28"]
[null,null,null,true,"Freitag",null,"13:30:00","14:15:00","Dienst",20,null,null,null,null,null,null,10,"2022-03-07"]
[null,null,null,false,"Samstag",null,"14:15:00","15:00:00","Dienst",20,null,null,null,null,null,null,11,"2022-03-14"]
[null,null,null,false,"Sonntag",null,"15:00:00","15:15:00","Pause",15,null,null,null,null,null,null,12,"2022-03-21"]
[null,null,null,null,null,null,"15:15:00","16:00:00","Dienst",20,null,null,null,null,null,null,13,"2022-03-28"]
[null,null,null,null,null,null,"16:00:00","16:45:00","Dienst",20,null,null,null,null,null,null,14,"2022-04-04"]
[null,null,null,null,null,null,"16:45:00","17:30:00","Dienst",20,null,null,null,null,null,null,15,"2022-04-11"]
[null,null,null,null,null,null,"17:30:00","18:15:00","Dienst",20,null,null,null,null,null,null,16,"2022-04-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"2022-04-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"2022-05-02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"2022-05-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"2022-05-16"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"2022-05-23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"2022-05-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"2022-06-06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"2022-06-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"2022-06-20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"2022-06-27"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"2022-07-04"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"2022-07-11"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"2022-07-18"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"2022-07-25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"2022-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"2022-08-08"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,{"$f":"DATE(JAHR,1,7*Q42-3-WEEKDAY(DATE(JAHR,,),3))","v":"2022-08-15"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"2022-08-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"2022-08-29"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"2022-09-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"2022-09-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"2022-09-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"2022-09-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"2022-10-03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"2022-10-10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"2022-10-17"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"2022-10-24"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"2022-10-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"2022-11-07"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"2022-11-14"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"2022-11-21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"2022-11-28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"2022-12-05"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"2022-12-12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,"2022-12-19"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,"2022-12-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,"2023-01-02"]

{"sheet":"Feiertage","index":3,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,2,2,8]]}
[null,null,"Feiertage"]
[]
[]
[]
[]
[null,null,null,"Feiertage",null,null,null,"» Startseite"]
[]
[null,null,null,12,"Bundesland",{"$f":"OFFSET($F$9,D8-1,0)","v":"F1011111100100011"},{"$f":"\"Feiertage \"& JAHR","v":"Feiertage 2022"}]
[null,null,null,null,"Baden-Württemberg","F1111111100101011",{"$f":"DATE(JAHR,1,1)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"2022-01-01"},"Neujahrstag"]
[null,null,null,null,"Bayern – überwiegend kath. Bevölkerung","F1111111101101011",{"$f":"DATE(JAHR,1,6)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G10,\"Hl. Drei Könige\",\"\")","v":""}]
[null,null,null,null,"Bayern","F1111111100101011",{"$f":"G12-3","v":"2022-04-15"},"Karfreitag"]
[null,null,null,null,"Bayern Stadtkreis Augsburg","F1111111111101011",{"$f":"DATE(JAHR,3,28)+MOD(24-MOD(JAHR,19)*10.63,29)-MOD(TRUNC(JAHR*5/4)+MOD(24-MOD(JAHR,19)*10.63,29)+1,7)+1","v":"2022-04-18"},"Ostermontag"]
[null,null,null,null,"Berlin","F1011111000100011",{"$f":"DATE(JAHR,5,1)","v":"2022-05-01"},"Tag der Arbeit"]
[null,null,null,null,"Brandenburg","F1011111000110011",{"$f":"(G12+38)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"2022-05-26"},{"$f":"IF(G14,\"Christi Himmelfahrt\",\"\")","v":"Christi Himmelfahrt"}]
[null,null,null,null,"Mecklenburg-Vorpommern","F1011111000110011",{"$f":"(G12+49)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"2022-06-06"},"Pfingstmontag"]
[null,null,null,null,"Bremen","F1011111000100011",{"$f":"(G12+59)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"2022-06-16"},{"$f":"IF(G16,\"Fronleichnam\",\"\")","v":"Fronleichnam"}]
[null,null,null,null,"Hamburg","F1011111000100011",{"$f":"DATE(JAHR,8,8)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G17,\"Augsburger Friedensfest\",\"\")","v":""}]
[null,null,null,null,"Schleswig-Holstein","F1011111000100011",{"$f":"DATE(JAHR,8,15)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G18,\"Mariä Himmelfahrt\",\"\")","v":""}]
[null,null,null,null,"Niedersachsen","F1011111000100011",{"$f":"DATE(JAHR,10,3)","v":"2022-10-03"},"Tag der d. Einheit"]
[null,null,null,null,"Hessen","F1011111100100011",{"$f":"DATE(JAHR,10,31)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G20,\"Reformationstag\",\"\")","v":""}]
[null,null,null,null,"Nordrhein-Westfalen","F1011111100101011",{"$f":"DATE(JAHR,11,1)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G21,\"Allerheiligen\",\"\")","v":""}]
[null,null,null,null,"Rheinland-Pfalz","F1011111100101011",{"$f":"(DATE(JAHR,12,25)-WEEKDAY(\"24.12.\" & JAHR)-32)*VALUE(MID(FTINDEX,ROW()-7,1))","v":"00:00:00"},{"$f":"IF(G22,\"Buß- und Bettag\",\"\")","v":""}]
[null,null,null,null,"Saarland","F1011111101101011",{"$f":"DATE(JAHR,12,25)","v":"2022-12-25"},"1. Weihnachtsfeiertag"]
[null,null,null,null,"Sachsen – überwiegend kath. Bevölkerung","F1011111100110111",{"$f":"DATE(JAHR,12,26)","v":"2022-12-26"},"2. Weihnachtsfeiertag"]
[null,null,null,null,"Sachsen","F1011111000110111"]
[null,null,null,null,"Sachsen-Anhalt","F1111111000110011"]
[null,null,null,null,"Thüringen – überwiegend kath. Bevölkerung","F1011111100110011"]
[null,null,null,null,"Thüringen","F1011111000110011"]

{"sheet":"Mitarbeiter","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,2,8]]}
[null,null,"Mitarbeiter"]
[]
[]
[]
[]
[null,null,null,"Mitarbeiter",null,null,null,"» Startseite"]
[]
[null,null,null,"Nr","Vorname","Name","Abteilung","Kürzel"]
[]
[null,null,null,1,"Angela","Dammel","Ausbildung",{"$f":"LEFT(E10,1)&LEFT(F10,1)","v":"AD"}]
[null,null,null,2,"Petra","Lüders","Ausbildung","PL"]
[null,null,null,3,"Brigitte","Gärtner ","Support","BG"]
[null,null,null,4,"Carsten","Glück","Support","CG"]
[null,null,null,5,"Olcay","Langer","Support","OL"]
[null,null,null,6,"Stefan","Reisner","Support","SR"]
[null,null,null,7,"Udo","Ücel","Support","UÜ"]
[null,null,null,8,"Wolfgang","Wüllf","Support","WW"]
[null,null,null,9,"Regina","Müller","Technik","RM"]
[null,null,null,10,"Hans","Hebbel","Technik","HH"]
[null,null,null,11,"Melita","Härtel","Technik","MH"]
[null,null,null,12,"Stefan","Pfaller","Technik","SP"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,11]

{"sheet":"Dienstplan KW Vorlage","index":5,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,3,5,7],[0,2,2,11]]}
[null,null,"Dienstplan KW Vorlage"]
[]
[]
[]
[]
[null,null,null,1,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Station",null,null,null,null,null,null,{"$f":"\"ab \"&TEXT(E10,\"t. MMMM JJJJ\")","v":"ab 3. Januar 2022"}]
[null,null,null,"Monat",{"$f":"E10","v":"2022-01-03"},{"$f":"E9+1","v":"2022-01-04"},"2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Datum",{"$f":"DATE(JAHR,1,7*$D$6-3-WEEKDAY(DATE(JAHR,,),3))","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Wochentag",{"$f":"E10","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]

{"sheet":"Jahresdienstplan Vorlage","index":6,"n_rows":43,"n_cols":35,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,3,7,10],[5,3,5,10],[5,33,5,34],[0,2,2,35],[5,17,5,18]]}
[null,null,"Jahresdienstplan Vorlage"]
[]
[]
[]
[]
[null,null,null,{"$f":"JAHR","v":2022},null,null,null,null,null,null,null,null,null,null,null,null,null,"» Startseite",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Station"]
[null,null,null,null,{"$f":"\"KW \"&TRUNC((E10-WEEKDAY(E10,2)-DATE(YEAR(E10+4-WEEKDAY(E10,2)),1,-10))/7)","v":"KW 52"},{"$f":"IF(WEEKDAY(F10)=2,\"KW \"&TRUNC((F10-WEEKDAY(F10,2)-DATE(YEAR(F10+4-WEEKDAY(F10,2)),1,-10))/7),\"\")","v":""},"KW 1","","","","","","","KW 2","","","","","","","KW 3","","","","","","","KW 4","","","","","","","KW 5"]
[null,null,null,{"$f":"DATE(JAHR,1,1)","v":"2022-01-01"},{"$f":"DATE($D$6,1,COLUMN()-4)","v":"2022-01-01"},{"$f":"DATE($D$6,1,COLUMN()-4)","v":"2022-01-02"},"2022-01-03","2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09","2022-01-10","2022-01-11","2022-01-12","2022-01-13","2022-01-14","2022-01-15","2022-01-16","2022-01-17","2022-01-18","2022-01-19","2022-01-20","2022-01-21","2022-01-22","2022-01-23","2022-01-24","2022-01-25","2022-01-26","2022-01-27","2022-01-28","2022-01-29","2022-01-30","2022-01-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E13)=2,\"KW \"&TRUNC((E13-WEEKDAY(E13,2)-DATE(YEAR(E13+4-WEEKDAY(E13,2)),1,-10))/7),\"\")","v":""},"","","","","","KW 6","","","","","","","KW 7","","","","","","","KW 8","","","","","","","KW 9",{"$f":"IF(AG13=\"\",\"\",IF(WEEKDAY(AG13)=2,\"KW \"&TRUNC((AG13-WEEKDAY(AG13,2)-DATE(YEAR(AG13+4-WEEKDAY(AG13,2)),1,-10))/7),\"\"))","v":""}]
[null,null,null,{"$f":"DATE(JAHR,2,1)","v":"2022-02-01"},{"$f":"DATE($D$6,2,COLUMN()-4)","v":"2022-02-01"},{"$f":"DATE($D$6,2,COLUMN()-4)","v":"2022-02-02"},"2022-02-03","2022-02-04","2022-02-05","2022-02-06","2022-02-07","2022-02-08","2022-02-09","2022-02-10","2022-02-11","2022-02-12","2022-02-13","2022-02-14","2022-02-15","2022-02-16","2022-02-17","2022-02-18","2022-02-19","2022-02-20","2022-02-21","2022-02-22","2022-02-23","2022-02-24","2022-02-25","2022-02-26","2022-02-27","2022-02-28",{"$f":"IF(DAY(DATE($D$6,2,COLUMN()-4))=1,\"\",DATE($D$6,2,COLUMN()-4))","v":""}]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E16)=2,\"KW \"&TRUNC((E16-WEEKDAY(E16,2)-DATE(YEAR(E16+4-WEEKDAY(E16,2)),1,-10))/7),\"\")","v":""},"","","","","","KW 10","","","","","","","KW 11","","","","","","","KW 12","","","","","","","KW 13","","",""]
[null,null,null,{"$f":"DATE(JAHR,3,1)","v":"2022-03-01"},{"$f":"DATE($D$6,3,COLUMN()-4)","v":"2022-03-01"},{"$f":"DATE($D$6,3,COLUMN()-4)","v":"2022-03-02"},"2022-03-03","2022-03-04","2022-03-05","2022-03-06","2022-03-07","2022-03-08","2022-03-09","2022-03-10","2022-03-11","2022-03-12","2022-03-13","2022-03-14","2022-03-15","2022-03-16","2022-03-17","2022-03-18","2022-03-19","2022-03-20","2022-03-21","2022-03-22","2022-03-23","2022-03-24","2022-03-25","2022-03-26","2022-03-27","2022-03-28","2022-03-29","2022-03-30","2022-03-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E19)=2,\"KW \"&TRUNC((E19-WEEKDAY(E19,2)-DATE(YEAR(E19+4-WEEKDAY(E19,2)),1,-10))/7),\"\")","v":""},"","","KW 14","","","","","","","KW 15","","","","","","","KW 16","","","","","","","KW 17","","","","","",""]
[null,null,null,{"$f":"DATE(JAHR,4,1)","v":"2022-04-01"},{"$f":"DATE($D$6,4,COLUMN()-4)","v":"2022-04-01"},{"$f":"DATE($D$6,4,COLUMN()-4)","v":"2022-04-02"},"2022-04-03","2022-04-04","2022-04-05","2022-04-06","2022-04-07","2022-04-08","2022-04-09","2022-04-10","2022-04-11","2022-04-12","2022-04-13","2022-04-14","2022-04-15","2022-04-16","2022-04-17","2022-04-18","2022-04-19","2022-04-20","2022-04-21","2022-04-22","2022-04-23","2022-04-24","2022-04-25","2022-04-26","2022-04-27","2022-04-28","2022-04-29","2022-04-30"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E22)=2,\"KW \"&TRUNC((E22-WEEKDAY(E22,2)-DATE(YEAR(E22+4-WEEKDAY(E22,2)),1,-10))/7),\"\")","v":""},"KW 18","","","","","","","KW 19","","","","","","","KW 20","","","","","","","KW 21","","","","","","","KW 22",""]
[null,null,null,{"$f":"DATE(JAHR,5,1)","v":"2022-05-01"},{"$f":"DATE($D$6,5,COLUMN()-4)","v":"2022-05-01"},{"$f":"DATE($D$6,5,COLUMN()-4)","v":"2022-05-02"},"2022-05-03","2022-05-04","2022-05-05","2022-05-06","2022-05-07","2022-05-08","2022-05-09","2022-05-10","2022-05-11","2022-05-12","2022-05-13","2022-05-14","2022-05-15","2022-05-16","2022-05-17","2022-05-18","2022-05-19","2022-05-20","2022-05-21","2022-05-22","2022-05-23","2022-05-24","2022-05-25","2022-05-26","2022-05-27","2022-05-28","2022-05-29","2022-05-30","2022-05-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E25)=2,\"KW \"&TRUNC((E25-WEEKDAY(E25,2)-DATE(YEAR(E25+4-WEEKDAY(E25,2)),1,-10))/7),\"\")","v":""},"","","","","KW 23","","","","","","","KW 24","","","","","","","KW 25","","","","","","","KW 26","","","",""]
[null,null,null,{"$f":"DATE(JAHR,6,1)","v":"2022-06-01"},{"$f":"DATE($D$6,6,COLUMN()-4)","v":"2022-06-01"},{"$f":"DATE($D$6,6,COLUMN()-4)","v":"2022-06-02"},"2022-06-03","2022-06-04","2022-06-05","2022-06-06","2022-06-07","2022-06-08","2022-06-09","2022-06-10","2022-06-11","2022-06-12","2022-06-13","2022-06-14","2022-06-15","2022-06-16","2022-06-17","2022-06-18","2022-06-19","2022-06-20","2022-06-21","2022-06-22","2022-06-23","2022-06-24","2022-06-25","2022-06-26","2022-06-27","2022-06-28","2022-06-29","2022-06-30"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E28)=2,\"KW \"&TRUNC((E28-WEEKDAY(E28,2)-DATE(YEAR(E28+4-WEEKDAY(E28,2)),1,-10))/7),\"\")","v":""},"","","KW 27","","","","","","","KW 28","","","","","","","KW 29","","","","","","","KW 30","","","","","",""]
[null,null,null,{"$f":"DATE(JAHR,7,1)","v":"2022-07-01"},{"$f":"DATE($D$6,7,COLUMN()-4)","v":"2022-07-01"},{"$f":"DATE($D$6,7,COLUMN()-4)","v":"2022-07-02"},"2022-07-03","2022-07-04","2022-07-05","2022-07-06","2022-07-07","2022-07-08","2022-07-09","2022-07-10","2022-07-11","2022-07-12","2022-07-13","2022-07-14","2022-07-15","2022-07-16","2022-07-17","2022-07-18","2022-07-19","2022-07-20","2022-07-21","2022-07-22","2022-07-23","2022-07-24","2022-07-25","2022-07-26","2022-07-27","2022-07-28","2022-07-29","2022-07-30","2022-07-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E31)=2,\"KW \"&TRUNC((E31-WEEKDAY(E31,2)-DATE(YEAR(E31+4-WEEKDAY(E31,2)),1,-10))/7),\"\")","v":"KW 31"},"","","","","","","KW 32","","","","","","","KW 33","","","","","","","KW 34","","","","","","","KW 35","",""]
[null,null,null,{"$f":"DATE(JAHR,8,1)","v":"2022-08-01"},{"$f":"DATE($D$6,8,COLUMN()-4)","v":"2022-08-01"},{"$f":"DATE($D$6,8,COLUMN()-4)","v":"2022-08-02"},"2022-08-03","2022-08-04","2022-08-05","2022-08-06","2022-08-07","2022-08-08","2022-08-09","2022-08-10","2022-08-11","2022-08-12","2022-08-13","2022-08-14","2022-08-15","2022-08-16","2022-08-17","2022-08-18","2022-08-19","2022-08-20","2022-08-21","2022-08-22","2022-08-23","2022-08-24","2022-08-25","2022-08-26","2022-08-27","2022-08-28","2022-08-29","2022-08-30","2022-08-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E34)=2,\"KW \"&TRUNC((E34-WEEKDAY(E34,2)-DATE(YEAR(E34+4-WEEKDAY(E34,2)),1,-10))/7),\"\")","v":""},"","","","KW 36","","","","","","","KW 37","","","","","","","KW 38","","","","","","","KW 39","","","","",""]
[null,null,null,{"$f":"DATE(JAHR,9,1)","v":"2022-09-01"},{"$f":"DATE($D$6,9,COLUMN()-4)","v":"2022-09-01"},{"$f":"DATE($D$6,9,COLUMN()-4)","v":"2022-09-02"},"2022-09-03","2022-09-04","2022-09-05","2022-09-06","2022-09-07","2022-09-08","2022-09-09","2022-09-10","2022-09-11","2022-09-12","2022-09-13","2022-09-14","2022-09-15","2022-09-16","2022-09-17","2022-09-18","2022-09-19","2022-09-20","2022-09-21","2022-09-22","2022-09-23","2022-09-24","2022-09-25","2022-09-26","2022-09-27","2022-09-28","2022-09-29","2022-09-30"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E37)=2,\"KW \"&TRUNC((E37-WEEKDAY(E37,2)-DATE(YEAR(E37+4-WEEKDAY(E37,2)),1,-10))/7),\"\")","v":""},"","KW 40","","","","","","","KW 41","","","","","","","KW 42","","","","","","","KW 43","","","","","","","KW 44"]
[null,null,null,{"$f":"DATE(JAHR,10,1)","v":"2022-10-01"},{"$f":"DATE($D$6,10,COLUMN()-4)","v":"2022-10-01"},{"$f":"DATE($D$6,10,COLUMN()-4)","v":"2022-10-02"},"2022-10-03","2022-10-04","2022-10-05","2022-10-06","2022-10-07","2022-10-08","2022-10-09","2022-10-10","2022-10-11","2022-10-12","2022-10-13","2022-10-14","2022-10-15","2022-10-16","2022-10-17","2022-10-18","2022-10-19","2022-10-20","2022-10-21","2022-10-22","2022-10-23","2022-10-24","2022-10-25","2022-10-26","2022-10-27","2022-10-28","2022-10-29","2022-10-30","2022-10-31"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E40)=2,\"KW \"&TRUNC((E40-WEEKDAY(E40,2)-DATE(YEAR(E40+4-WEEKDAY(E40,2)),1,-10))/7),\"\")","v":""},"","","","","","KW 45","","","","","","","KW 46","","","","","","","KW 47","","","","","","","KW 48","","",{"$f":"IF(WEEKDAY(AI40)=2,\"KW\"&TRUNC((AI40-WEEKDAY(AI40,2)-DATE(YEAR(AI40+4-WEEKDAY(AI40,2)),1,-10))/7),\"\")","v":""}]
[null,null,null,{"$f":"DATE(JAHR,11,1)","v":"2022-11-01"},{"$f":"DATE($D$6,11,COLUMN()-4)","v":"2022-11-01"},{"$f":"DATE($D$6,11,COLUMN()-4)","v":"2022-11-02"},"2022-11-03","2022-11-04","2022-11-05","2022-11-06","2022-11-07","2022-11-08","2022-11-09","2022-11-10","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","2022-11-16","2022-11-17","2022-11-18","2022-11-19","2022-11-20","2022-11-21","2022-11-22","2022-11-23","2022-11-24","2022-11-25","2022-11-26","2022-11-27","2022-11-28","2022-11-29","2022-11-30"]
[]
[null,null,null,null,{"$f":"IF(WEEKDAY(E43)=2,\"KW \"&TRUNC((E43-WEEKDAY(E43,2)-DATE(YEAR(E43+4-WEEKDAY(E43,2)),1,-10))/7),\"\")","v":""},"","","","KW 49","","","","","","","KW 50","","","","","","","KW 51","","","","","","","KW 52","","","","",""]
[null,null,null,{"$f":"DATE(JAHR,12,1)","v":"2022-12-01"},{"$f":"DATE($D$6,12,COLUMN()-4)","v":"2022-12-01"},{"$f":"DATE($D$6,12,COLUMN()-4)","v":"2022-12-02"},"2022-12-03","2022-12-04","2022-12-05","2022-12-06","2022-12-07","2022-12-08","2022-12-09","2022-12-10","2022-12-11","2022-12-12","2022-12-13","2022-12-14","2022-12-15","2022-12-16","2022-12-17","2022-12-18","2022-12-19","2022-12-20","2022-12-21","2022-12-22","2022-12-23","2022-12-24","2022-12-25","2022-12-26","2022-12-27","2022-12-28","2022-12-29","2022-12-30","2022-12-31"]

{"sheet":"<Abteilung 1>KW1","index":7,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,2,11],[5,3,5,7],[13,4,13,10],[17,4,17,10],[21,4,21,10]]}
[null,null,"Dienstplan KW Vorlage"]
[]
[]
[]
[]
[null,null,null,1,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Abteilung 1",null,null,null,null,null,null,{"$f":"\"ab \"&TEXT(E10,\"t. MMMM JJJJ\")","v":"ab 3. Januar 2022"}]
[null,null,null,"Monat",{"$f":"E10","v":"2022-01-03"},{"$f":"E9+1","v":"2022-01-04"},"2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Datum",{"$f":"DATE(JAHR,1,7*$D$6-3-WEEKDAY(DATE(JAHR,,),3))","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Wochentag",{"$f":"E10","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"08:00-08:30","Gärtner ",null,"Hl. Drei Könige"]
[null,null,null,"08:45-09:30","Ücel"]
[null,null,null,"09:30-09:45","Pause"]
[null,null,null,"10:15-11:00","Lüders"]
[null,null,null,"11:00-11:45","Lüders"]
[null,null,null,"11:45-12:30","Lüders"]
[null,null,null,"12:30-12:45","Pause"]
[null,null,null,"12:45-13:30","Lüders"]
[null,null,null,"13:30-14:15","Lüders"]
[null,null,null,"14:15-15:00","Lüders"]
[null,null,null,"15:00-15:15","Pause"]
[null,null,null,"15:15-16:00"]
[null,null,null,"16:00-16:45"]
[null,null,null,"16:45-17:30"]
[null,null,null,"17:30-18:15"]

{"sheet":"<Abteilung 2>KW1","index":8,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,2,11],[5,3,5,7],[13,4,13,10],[17,4,17,10],[21,4,21,10]]}
[null,null,"Dienstplan KW Vorlage"]
[]
[]
[]
[]
[null,null,null,1,null,null,null,null,null,null,"» Startseite"]
[]
[null,null,null,"Abteilung 2",null,null,null,null,null,null,{"$f":"\"ab \"&TEXT(E10,\"t. MMMM JJJJ\")","v":"ab 3. Januar 2022"}]
[null,null,null,"Monat",{"$f":"E10","v":"2022-01-03"},{"$f":"E9+1","v":"2022-01-04"},"2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Datum",{"$f":"DATE(JAHR,1,7*$D$6-3-WEEKDAY(DATE(JAHR,,),3))","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"Wochentag",{"$f":"E10","v":"2022-01-03"},"2022-01-04","2022-01-05","2022-01-06","2022-01-07","2022-01-08","2022-01-09"]
[null,null,null,"08:00-08:30","Müller",null,"Hl. Drei Könige"]
[null,null,null,"08:45-09:30"]
[null,null,null,"09:30-09:45","Pause"]
[null,null,null,"10:15-11:00","Hebbel"]
[null,null,null,"11:00-11:45","Hebbel"]
[null,null,null,"11:45-12:30"]
[null,null,null,"12:30-12:45","Pause"]
[null,null,null,"12:45-13:30","Glück"]
[null,null,null,"13:30-14:15"]
[null,null,null,"14:15-15:00"]
[null,null,null,"15:00-15:15","Pause"]
[null,null,null,"15:15-16:00"]
[null,null,null,"16:00-16:45"]
[null,null,null,"16:45-17:30"]
[null,null,null,"17:30-18:15"]

{"sheet":"Tabvorlage","index":9,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":true,"merged":[[0,2,2,10]]}
[null,null,{"$f":"Startseite!B1","v":"Dienstplan 2022"}]
[]
[]
[]
[]
[null,null,null,"Untertitel",null,null,null,null,null,"» Startseite"]

{"sheet":"VERLAUF","index":10,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Startseite"]
["Hilfe"]
["Basisdaten"]
["Feiertage"]
["Mitarbeiter"]
["Dienstplan KW Vorlage"]
["Jahresdienstplan Vorlage"]
["<Abteilung 1>KW1"]
["<Abteilung 2>KW1"]

{"sheet":"Tabelle1","index":11,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[false,"Kopfzeile",false,false,false]
[false,"Bitte wählen",false,false,false]
[false,"Bitte wählen",false,false,false]
[false,"Bitte wählen",false,false,false]
[false,"Bitte wählen",false,false,false]
[false,"Bitte wählen",false,false,false]

{"sheet":"ICONS","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}