{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Muster","zum Ausfüllen","Summen"],"not_rendered":{"images":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Muster","index":0,"n_rows":17,"n_cols":12,"rows_kept":17,"merged":[[0,1,0,5],[0,7,0,11],[16,1,16,11]]}
["Schule:","VS Musterau",{"$nulls":4},"Name:","MUSTERMANN Max"]
[]
["Bitte beachten: "]
["- Start- und Endezeit der Schulstunde eintragen (zB Start 07:50, Ende 08:40); siehe Tabellenblatt \"Muster\""]
["- bei jeder Stunde auswählen: Schulassistenzstunde (SA) oder Freizeitbetreuungsstunde (FZ) "]
["- Option: Ergänzende Aufgaben (EA) können hinterlegt werden, sofern diese wöchentlich zur selben Zeit stattfinden (zb. EA von 07:15 - 07:30 Uhr)"]
[]
["Start Schulstunde:","07:30:00","07:50:00","08:45:00","10:00:00","10:55:00","11:50:00","12:40:00","14:00:00","14:55:00","15:45:00"]
["Ende Schulstunde:","07:50:00","08:40:00","09:35:00","10:50:00","11:45:00","12:40:00","14:00:00","14:50:00","15:45:00","16:00:00"]
[null,{"$f":"(B9-B8)*24","v":{"v":0.3333333333333335,"d":"0.33"}},{"v":0.833333333333333,"d":"0.83"},{"v":0.8333333333333344,"d":"0.83"},{"v":0.833333333333333,"d":"0.83"},{"v":0.833333333333333,"d":"0.83"},{"v":0.833333333333333,"d":"0.83"},{"v":1.333333333333334,"d":"1.33"},{"v":0.833333333333333,"d":"0.83"},{"v":0.833333333333333,"d":"0.83"},{"v":0.2499999999999991,"d":"0.25"},{"v":0,"d":"0.00"}]
["MONTAG","EA","SA","SA","SA","SA"]
["DIENSTAG",{"$nulls":6},"FZ","SA","SA","FZ"]
["MITTWOCH","EA","SA","SA","SA"]
["DONNERSTAG",{"$nulls":3},"SA","SA","SA","FZ"]
["FREITAG"]
[]
["Anmerkung:","zusätzliche EA am Donnerstag von 09:35 bis 10:00"]

{"sheet":"zum Ausfüllen","index":1,"n_rows":64,"n_cols":12,"rows_kept":64,"merged":[[0,1,0,5],[0,7,0,11],[16,1,16,11]]}
["Schule:",{"$nulls":5},"Name:"]
[]
["Bitte beachten: "]
["- Start- und Endezeit der Schulstunde eintragen (zB Start 07:50, Ende 08:40); siehe Tabellenblatt \"Muster\""]
["- bei jeder Stunde auswählen: Schulassistenzstunde (SA) oder Freizeitbetreuungsstunde (FZ) "]
["- Option: Ergänzende Aufgaben (EA) können hinterlegt werden, sofern diese wöchentlich zur selben Zeit stattfinden (zb. EA von 07:15 - 07:30 Uhr)"]
[]
["Start Schulstunde:"]
["Ende Schulstunde:"]
[null,{"$f":"(B9-B8)*24","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["MONTAG"]
["DIENSTAG"]
["MITTWOCH"]
["DONNERSTAG"]
["FREITAG"]
[]
["Anmerkung:"]
[]
["Mo FZ",{"$f":"IF(B$11=\"FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$11=\"FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mo VB FZ",{"$f":"IF(B$11=\"VB FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$11=\"VB FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mo EA",{"$f":"IF(B$11=\"EA\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$11=\"EA\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mo SA",{"$f":"IF(B$11=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$11=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Di FZ",{"$f":"IF(B$12=\"FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$12=\"FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Di VB FZ",{"$f":"IF(B$12=\"VB FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$12=\"VB FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Di EA",{"$f":"IF(B$12=\"EA\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$12=\"EA\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Di SA",{"$f":"IF(B$12=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$12=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mi FZ",{"$f":"IF(B$13=\"FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$13=\"FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mi VB FZ",{"$f":"IF(B$13=\"VB FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$13=\"VB FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mi EA",{"$f":"IF(B$13=\"EA\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$13=\"EA\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Mi SA",{"$f":"IF(B$13=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$13=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Do FZ",{"$f":"IF(B$14=\"FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$14=\"FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Do VB FZ",{"$f":"IF(B$14=\"VB FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$14=\"VB FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Do EA",{"$f":"IF(B$14=\"EA\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$14=\"EA\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Do SA",{"$f":"IF(B$14=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$14=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Fr FZ",{"$f":"IF(B$15=\"FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$15=\"FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Fr VB FZ",{"$f":"IF(B$15=\"VB FZ\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$15=\"VB FZ\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Fr EA",{"$f":"IF(B$15=\"EA\",B$10,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$15=\"EA\",C$10,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Fr SA",{"$f":"IF(B$15=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"$f":"IF(C$15=\"SA\",1,)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Summe Mo FZ",{"$f":"SUM(B19:L19)","v":{"v":0,"d":"0.00"}}]
["Summe Mo VB FZ",{"$f":"SUM(B20:L20)","v":{"v":0,"d":"0.00"}}]
["Summe Mo EA",{"$f":"SUM(B21:L21)","v":{"v":0,"d":"0.00"}}]
["Summe Mo SA",{"$f":"SUM(B22:L22)","v":{"v":0,"d":"0.00"}}]
["Summe Di FZ",{"$f":"SUM(B23:L23)","v":{"v":0,"d":"0.00"}}]
["Summe Di VB FZ",{"v":0,"d":"0.00"}]
["Summe Di EA",{"v":0,"d":"0.00"}]
["Summe Di SA",{"v":0,"d":"0.00"}]
["Summe Mi FZ",{"v":0,"d":"0.00"}]
["Summe Mi VB FZ",{"v":0,"d":"0.00"}]
["Summe Mi EA",{"v":0,"d":"0.00"}]
["Summe Mi SA",{"v":0,"d":"0.00"}]
["Summe Do FZ",{"v":0,"d":"0.00"}]
["Summe Do VB FZ",{"v":0,"d":"0.00"}]
["Summe Do EA",{"v":0,"d":"0.00"}]
["Summe Do SA",{"v":0,"d":"0.00"}]
["Summe Fr FZ",{"v":0,"d":"0.00"}]
["Summe Fr VB FZ",{"v":0,"d":"0.00"}]
["Summe Fr EA",{"v":0,"d":"0.00"}]
["Summe Fr SA",{"v":0,"d":"0.00"}]
[]
["Wochesumme FZ",{"$f":"B40+B44+B48+B52+B56","v":{"v":0,"d":"0.00"}}]
["Wochesumme VB FZ",{"$f":"B41+B45+B49+B53+B57","v":{"v":0,"d":"0.00"}}]
["Wochesumme EA",{"v":0,"d":"0.00"}]
["Wochesumme SA",{"v":0,"d":"0.00"}]

{"sheet":"Summen","index":2,"n_rows":6,"n_cols":10,"rows_kept":6}
[]
[null,"Mo","Di","Mi","Do","Fr","Gesamt","Gesamt","EA max","EA Differenz"]
["SA",{"$f":"'zum Ausfüllen'!B43","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B47","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B51","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B55","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B59","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B3:F3)","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B64","v":{"v":0,"d":"0.00"}}]
["EA",{"$f":"'zum Ausfüllen'!B42","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B46","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B50","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B54","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B58","v":{"v":0,"d":"0.00"}},{"$f":"SUM(B4:F4)","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B63","v":{"v":0,"d":"0.00"}},{"$f":"H3*1.2","v":0},{"$f":"H4-I4","v":{"v":0,"d":"0.00"}}]
["FZ",{"$f":"'zum Ausfüllen'!B40","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B44","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B48","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B52","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B56","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"'zum Ausfüllen'!B61","v":{"v":0,"d":"0.00"}}]
["VB FZ",{"$f":"'zum Ausfüllen'!B41","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B45","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B49","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B53","v":{"v":0,"d":"0.00"}},{"$f":"'zum Ausfüllen'!B57","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"'zum Ausfüllen'!B62","v":{"v":0,"d":"0.00"}}]