{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Config","Zeitbogen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"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":"Config","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Monat (1-12)",11]
["Jahr",2025]
["Working Type","Full-time"]
[]
[]
[]
[]
[]
[]
["Art_Lista",null,"Monatsnamen_DE",null,"Feiertage:"]
["Office",null,"Januar",null,"Datum","Bezeichnung"]
["Home Office",null,"Februar",null,"2025-01-01","Neujahr"]
["Dienstreise",null,"März",null,"2025-04-18","Karfreitag"]
["Urlaub",null,"April",null,"2025-04-21","Ostermontag"]
["Krank",null,"Mai",null,"2025-05-01","Tag der Arbeit"]
["Overtime",null,"Juni",null,"2025-05-29","Christi Himmelfahrt"]
[null,null,"Juli",null,"2025-06-09","Pfingstmontag"]
[null,null,"August",null,"2025-10-03","Tag der Deutschen Einheit"]
[null,null,"September",null,"2025-12-25","1. Weihnachtstag"]
[null,null,"Oktober",null,"2025-12-26","2. Weihnachtstag"]
[null,null,"November"]
[null,null,"Dezember"]

{"sheet":"Zeitbogen","index":1,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,5,2,7],[0,0,1,7],[3,2,4,2],[5,2,7,2],[5,3,7,3],[3,3,4,3],[5,4,7,4],[3,4,4,4]]}
["Zeiterfassungsbogen für die flexible Arbeitszeit"]
[]
["Monat:",{"$f":"INDEX(Config!$C$11:$C$22,MONTH(DATE(Config!B2,Config!B1,1)))&\" \"&YEAR(DATE(Config!B2,Config!B1,1))","v":"November 2025"},null,null,null,"Pausenregelung bei zusammenhängender Arbeitszeit"]
["Arbeitstage pro Woche:",5,"Supervisor (Name, Unterschrift)","Overtime:",null,"Beschreibung","Parameter","Pause in Min"]
["wöchentl. Arbeitszeit:",39.4,null,null,null,"max. AZ ohne Pause","06:00","00:00"]
["Name:","Tom Yorke",null,"Summe:",{"$f":"(G48-G50)*24+E4","v":0},"Pause bei 6h bis 9h","09:30","00:30"]
["Dienststelle:","Radiohead",null,null,null,"Pause bei 9h bis 24h","23:59","00:45"]
["M.Number",1234567]
[]
["Datum","Wochentag","Art (Office/Home/Dienstreise/Urlaub/Krank)","Start","Ende","Pause","Arbeitszeit [h]","Kommentar",null,"Arbeitstag?"]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-01"},{"$f":"IF(A11=\"\",\"\",CHOOSE(WEEKDAY(A11,2),\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\",\"So\"))","v":"Sa"},null,null,null,null,{"$f":"IF(A11=\"\",\"\",IF(OR(C11=\"Office\",C11=\"Home Office\",C11=\"Dienstreise\"),MAX(0,(E11-D11)-F11),0))","v":0},null,null,{"$f":"IF(A11=\"\", \"\", IF(AND(WEEKDAY(A11,2)<=5, OR(C11=\"Office\",C11=\"Home Office\",C11=\"Dienstreise\",C11=\"Overtime\")), 1, 0))","v":0}]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-02"},"So",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-03"},"Mo",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-04"},"Di",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-05"},"Mi",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-06"},"Do",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-07"},"Fr",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-08"},"Sa",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-09"},"So",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-10"},"Mo",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-11"},"Di",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-12"},"Mi",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-13"},"Do",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-14"},"Fr",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-15"},"Sa",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-16"},"So",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-17"},"Mo",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-18"},"Di",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-19"},"Mi",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-20"},"Do",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-21"},"Fr",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-22"},"Sa",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-23"},"So",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-24"},"Mo",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-25"},"Di",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-26"},"Mi",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-27"},"Do",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-28"},"Fr",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-29"},"Sa",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":"2025-11-30"},"So",null,null,null,null,0,null,null,0]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":""},"",null,null,null,null,"",null,null,""]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":""},"",null,null,null,null,"",null,null,""]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":""},"",null,null,null,null,"",null,null,""]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":""},"",null,null,null,null,"",null,null,""]
[{"$f":"IF(MONTH(DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11))=Config!B1, DATE(Config!B2,Config!B1,1)+ROW()-ROW($A$11), \"\")","v":""},"",null,null,null,null,"",null,null,""]
[]
[]
[null,null,null,null,null,"Monats-Summe:",{"$f":"SUM(G11:G45)","v":0}]
[null,null,null,null,null,"Arbeitstage:",{"$f":"SUM(J11:J45)","v":0}]
[null,null,null,null,null,"Sollstunden (8h/AT):",{"$f":"IF(Config!B3=\"Part-time\", 40/24, (G49*(B5/B4))/24)","v":0}]
[null,null,null,null,null,"Diff (Ist - Soll) [h]:",{"$f":"(G48-G50)*24","v":0}]