{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Team 1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Team 1","index":0,"n_rows":58,"n_cols":40,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,21,3,39],[4,1,5,2],[2,9,2,20],[1,1,1,3],[1,7,1,8],[2,7,2,8],[3,6,3,8],[4,6,5,6],[4,7,5,7],[4,8,5,8],[3,9,3,20],[57,1,57,2],[4,3,5,3],[4,4,5,4],[2,1,2,5],[3,3,3,5],[3,1,3,2],[4,5,5,5]]}
[]
[]
[null,{"$f":"MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,255)","v":"Team 1"},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,2025]
[null,2025,null,"Urlaub",null,null,"Extras",null,null,{"$f":"DATE(B4,1,1)","v":"2025-01-01"},{"$f":"DATE(C1,1,1)","v":"1900-01-01"},"1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01","1900-01-01",{"$f":"DATE(J1,1,1)","v":"1900-01-01"},"1900-01-01","1900-01-01","1900-01-01"]
[null,"Mitarbeiter",null,"Urlaub","Rest Urlaub"," Einge-tragen",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J3","v":"1905-07-17"},{"$f":"K6","v":"2025-01-02"},{"$f":"L6","v":"2025-01-03"},"2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30","2025-01-31"]
[null,null,null,null,null,null,null,null,null,{"$f":"J4","v":"2025-01-01"},{"$f":"J6+1","v":"2025-01-02"},{"$f":"K6+1","v":"2025-01-03"},"2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19",{"$f":"AB6+1","v":"2025-01-20"},"2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26",{"$f":"IF(AI7=AI6,\"\",IF(AI6=\"\",\"\",AI6+1))","v":"2025-01-27"},{"$f":"IF(AJ7=AJ6,\"\",IF(AJ6=\"\",\"\",AJ6+1))","v":"2025-01-28"},"2025-01-29","2025-01-30","2025-01-31"]
[]
[null,1,"Max Mustermann",30,{"$f":"IF(D8=\"\",\"\",D8-F8)","v":8},{"$f":"IF(D8=\"\",\"\",COUNTIF(K8:AO8,\"1\"))","v":22},{"$f":"IF(C8=\"\",\"\",COUNTIF(J8:AN8,\"2\"))","v":0},{"$f":"IF(C8=\"\",\"\",COUNTIF(J8:AN8,\"3\"))","v":0},{"$f":"IF(C8=\"\",\"\",COUNTIF(J8:AN8,\"4\"))","v":0},null,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1,null,null,1,1,1,1,1]
[null,2,null,null,{"$f":"IF(D9=\"\",\"\",D9-F9)","v":""},"","","",""]
[null,3,null,null,"","","","",""]
[null,4,null,null,"","","","",""]
[null,5,null,null,"","","","",""]
[null,6,null,null,"","","","","",null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,7,null,null,"","","","",""]
[null,8,null,null,"","","","",""]
[null,9,null,null,"","","","","",null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,10,null,null,"","","","",""]
[null,11,null,null,"","","","",""]
[null,12,null,null,"","","","",""]
[null,13,null,null,"","","","","",null,null,null,null,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,14,null,null,"","","","",""]
[null,15,null,null,"","","","",""]
[null,16,null,null,"","","","",""]
[null,17,null,null,"","","","",""]
[null,18,null,null,"","","","",""]
[null,19,null,null,"","","","",""]
[null,20,null,null,"","","","",""]
[null,21,null,null,"","","","",""]
[null,22,null,null,"","","","",""]
[null,23,null,null,"","","","",""]
[null,24,null,null,"","","","",""]
[null,25,null,null,"","","","",""]
[null,26,null,null,"","","","",""]
[null,27,null,null,"","","","",""]
[null,28,null,null,"","","","",""]
[null,29,null,null,"","","","",""]
[null,30,null,null,"","","","",""]
[null,31,null,null,"","","","",""]
[null,32,null,null,"","","","",""]
[null,33,null,null,"",{"$f":"IF(D40=\"\",\"\",COUNTIF(K40:AO40,\"1\"))","v":""},{"$f":"IF(C40=\"\",\"\",COUNTIF(J40:AN40,\"2\"))","v":""},{"$f":"IF(C40=\"\",\"\",COUNTIF(J40:AN40,\"3\"))","v":""},{"$f":"IF(C40=\"\",\"\",COUNTIF(J40:AN40,\"4\"))","v":""}]
[null,34,null,null,"","","","",""]
[null,35,null,null,"","","","",""]
[null,36,null,null,"","","","",""]
[null,37,null,null,"","","","",""]
[null,38,null,null,"","","","",""]
[null,39,null,null,"","","","",""]
[null,40,null,null,"","","","",""]
[null,41,null,null,"","","","",""]
[null,42,null,null,"","","","",""]
[null,43,null,null,"","","","",""]
[null,44,null,null,"","","","",""]
[null,45,null,null,"","","","",""]
[null,46,null,null,"","","","",""]
[null,47,null,null,"","","","",""]
[null,48,null,null,"","","","",""]
[null,49,null,null,"","","","",""]
[null,50,null,null,"","","","",""]
[null,"Eingabe \"4\" Zelle wird antrazit"]