{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dez. 2024","Jan. 2025","Hilfstabelle"],"not_rendered":{"charts":0,"images":2,"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":"Dez. 2024","index":0,"n_rows":59,"n_cols":501,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,0,2,3],[4,0,4,2],[5,0,5,2],[1,0,1,6],[40,0,40,6],[4,4,4,7],[4,15,4,18],[6,8,6,9],[6,11,6,13],[6,16,6,18],[8,0,8,7],[5,4,5,8],[4,12,4,14],[5,12,5,14],[7,4,7,6],[42,0,42,6],[43,0,43,6],[42,8,42,9],[44,0,44,2],[45,0,45,2],[46,0,46,2],[44,17,44,18],[48,0,48,3],[49,0,49,3],[48,7,48,10],[49,7,49,10],[50,0,50,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[50,7,50,10],[51,7,51,10],[52,7,52,10],[53,7,53,10],[48,14,48,18]]}
[1,null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500]
["Stundennachweis"]
["für besoldete Dienstkräfte"]
[]
["Monat / Jahr",null,null,null,"Dienstkraft",null,null,null,null,null,null,null,"Dienststelle",null,null,"Beschäftigungsart"]
["12 / 2024",null,null,null,"Herrmann, Frank, 24115913",null,null,null,null,null,null,null,"Dir ZeSo Gef 41/B",null,null,"TB"]
[null,null,null,null,null,null,null,null,"Kontostände:",null,null,"Bestandskonten",null,null,null,null,"Aufbaukonten"]
["Datum","FT","Soll","Dienst","Dienstzeit",null,null,"+/-","Ges.","ZK","FAK","MA","BmB","RufB","RB gel.","ML","BVv","BmB","ML.nM"]
["Übertrag aus Vormonat:",null,null,null,null,null,null,null,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,"00:00:00","00:00:00","00:00:00","00:00:00"]
["2024-12-01",{"$f":"IF(ISERROR(VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","F / 18","17:45:00","-","06:00:00",null,"00:00:00"]
[{"$f":"A10+1","v":"2024-12-02"},{"$f":"IF(ISERROR(VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
[{"$f":"A11+1","v":"2024-12-03"},{"$f":"IF(ISERROR(VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-04",{"$f":"IF(ISERROR(VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","TT Gef","05:45:00","-","18:00:00",null,"00:00:00"]
["2024-12-05",{"$f":"IF(ISERROR(VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"00:00:00"]
["2024-12-06",{"$f":"IF(ISERROR(VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2024-12-07",{"$f":"IF(ISERROR(VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-08",{"$f":"IF(ISERROR(VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","TT Gef","05:45:00","-","18:00:00",null,"00:00:00"]
["2024-12-09",{"$f":"IF(ISERROR(VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"00:00:00"]
["2024-12-10",{"$f":"IF(ISERROR(VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-11",{"$f":"IF(ISERROR(VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-12",{"$f":"IF(ISERROR(VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","TT Gef","05:45:00","-","19:11:00",null,"00:00:00"]
["2024-12-13",{"$f":"IF(ISERROR(VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"00:00:00"]
["2024-12-14",{"$f":"IF(ISERROR(VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-15",{"$f":"IF(ISERROR(VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"00:00:00"]
["2024-12-16",{"$f":"IF(ISERROR(VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","F / 12","05:45:00","-","18:00:00","+10:45","10:45:00","00:00:00","10:45:00"]
["2024-12-17",{"$f":"IF(ISERROR(VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","F / 19","17:45:00","-","06:00:00","-4:15","06:30:00",null,"06:30:00"]
["2024-12-18",{"$f":"IF(ISERROR(VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-19",{"$f":"IF(ISERROR(VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-20",{"$f":"IF(ISERROR(VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","SZU",null,null,null,null,"06:30:00"]
["2024-12-21",{"$f":"IF(ISERROR(VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"06:30:00"]
["2024-12-22",{"$f":"IF(ISERROR(VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-23",{"$f":"IF(ISERROR(VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-24",{"$f":"IF(ISERROR(VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":"HA"},"12:15:00","TT Gef","05:45:00","-","18:00:00",null,"06:30:00"]
["2024-12-25",{"$f":"IF(ISERROR(VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":"1. Wf."},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"06:30:00"]
["2024-12-26",{"$f":"IF(ISERROR(VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":"2. Wf."},null,"-",null,null,null,null,"06:30:00"]
["2024-12-27",{"$f":"IF(ISERROR(VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-28",{"$f":"IF(ISERROR(VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","TT Gef","05:45:00","-","18:00:00",null,"06:30:00"]
["2024-12-29",{"$f":"IF(ISERROR(VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00","NT Gef","17:45:00","-","06:00:00",null,"06:30:00"]
["2024-12-30",{"$f":"IF(ISERROR(VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,"-",null,null,null,null,"06:30:00"]
["2024-12-31",{"$f":"IF(ISERROR(VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":"Silv."},null,"-",null,null,null,"+7:42","14:12:00","07:42:00","06:30:00","00:00:00","00:00:00","00:00:00"]
["Veränderung zum Vormonat:",null,null,null,null,null,null,null,"14:12:00","07:42:00","06:30:00","00:00:00","00:00:00","00:00:00",null," ∑"]
[]
["Übersicht Kontostände zum:",null,null,null,null,null,null,null,{"$f":"A40","v":"2024-12-31"}]
["Alterungskonten:"]
["Monat:",null,null,null,1,null,2,3,4,5,6,7,8,9,10,11,12,"13 bez."]
["Mehrarbeit:"]
["Bereit. (m.B.):"]
[]
["Urlaub:",null,null,null,0,null,null,"AZV-Tag:",null,null,null,null,0,null,"genutzte Zeiterfassungsgeräte:"]
["Resturlaub:",null,null,null,0,null,null,"Urlaub-Anspar Tage:",null,null,null,null,0,null,"WK01:","20x","WK03:","2x"]
["Zusatzurlaub:",null,null,null,0,null,null,"ZU Stunden SchwerB.:",null,null,null,null,"00:00:00"]
["Rest-Zusatzurlaub:",null,null,null,0,null,null,"Schichten:",null,null,null,null,0]
["SZU Anspruch (lfd. Jahr):",null,null,null,2,null,null,"Nachtdienststunden:",null,null,null,null,"00:00:00"]
["SZU genommen (lfd. Jahr):",null,null,null,1,null,null,"Auszahlung:",null,null,null,null,0]
["SZU aus Vorjahr:",null,null,null,0]
[]
["Legende:",null,null,"MA:Mehrarbeit",null,null,null,null,"ML: Mehrleistung",null,null,null,null,null,"MLnm: Mehrleistung nicht messbar"]
["ZK: Zeitkonto",null,null,"BmB: Bereitschaftszeit mit Befehl",null,null,null,null,"BVv: Bereitschaftszeit gem. Verwaltungsvereinbarung",null,null,null,null,null,"II: besonderer Buchungsgrund"]
["FAK: Freizeitrausgleichskonto",null,null,"RufB: Rufbereitschaft",null,null,null,null,"BmBlfd: Bereitschaftszeit mit Befehl laufender Monat",null,null,null,null,null,"T: Diensttausch"]

{"sheet":"Jan. 2025","index":1,"n_rows":59,"n_cols":501,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,20,1,28],[6,16,6,18],[1,0,1,6],[2,0,2,3],[4,0,4,2],[4,4,4,7],[4,12,4,14],[4,15,4,18],[43,0,43,6],[5,0,5,2],[5,4,5,8],[5,12,5,14],[6,8,6,9],[6,11,6,13],[7,4,7,6],[8,0,8,7],[40,0,40,6],[42,0,42,6],[42,8,42,9],[44,0,44,2],[44,17,44,18],[45,0,45,2],[46,0,46,2],[48,0,48,3],[48,7,48,10],[48,14,48,18],[49,0,49,3],[49,7,49,10],[50,0,50,3],[50,7,50,10],[51,0,51,3],[51,7,51,10],[52,0,52,3],[52,7,52,10],[53,0,53,3],[53,7,53,10],[54,0,54,3]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500]
["Stundennachweis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schaltflächen + Hilfsspalten"]
["für besoldete Dienstkräfte"]
[]
["Monat / Jahr"]
["01 / 2025"]
[null,null,null,null,null,null,null,null,"Kontostände:",null,null,"Bestandskonten",null,null,null,null,"Aufbaukonten"]
["Datum","FT","Soll","Dienst","Dienstzeit",null,null,"+/-","Ges.","ZK","FAK","MA","BmB","RufB","RB gel.","ML","BVv","BmB","ML.nM"]
["Übertrag aus Vormonat:",null,null,null,null,null,null,null,{"$f":"'Dez. 2024'!I40","v":"14:12:00"},{"$f":"'Dez. 2024'!J40","v":"07:42:00"},{"$f":"'Dez. 2024'!K40","v":"06:30:00"},{"$f":"'Dez. 2024'!L40","v":"00:00:00"},{"$f":"'Dez. 2024'!M40","v":"00:00:00"},{"$f":"'Dez. 2024'!N40","v":"00:00:00"},{"$f":"'Dez. 2024'!O40","v":"00:00:00"},{"$f":"'Dez. 2024'!P40","v":"00:00:00"},{"$f":"'Dez. 2024'!Q40","v":"00:00:00"},{"$f":"'Dez. 2024'!R40","v":"00:00:00"},{"$f":"'Dez. 2024'!S40","v":"00:00:00"}]
["2025-01-01",{"$f":"IF(ISERROR(VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A10,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":"Nj."},"12:15:00",null,null,null,null,null,"00:00:00"]
[{"$f":"A10+1","v":"2025-01-02"},{"$f":"IF(ISERROR(VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A11,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00",null,null,null,null,null,"00:00:00"]
[{"$f":"A11+1","v":"2025-01-03"},{"$f":"IF(ISERROR(VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A12,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-04",{"$f":"IF(ISERROR(VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A13,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-01"]
["2025-01-05",{"$f":"IF(ISERROR(VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A14,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00",null,null,null,null,null,"00:00:00"]
["2025-01-06",{"$f":"IF(ISERROR(VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A15,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},"12:15:00",null,null,null,null,null,"00:00:00"]
["2025-01-07",{"$f":"IF(ISERROR(VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A16,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-08",{"$f":"IF(ISERROR(VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A17,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-09",{"$f":"IF(ISERROR(VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A18,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-10",{"$f":"IF(ISERROR(VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A19,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-11",{"$f":"IF(ISERROR(VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A20,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-12",{"$f":"IF(ISERROR(VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A21,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-13",{"$f":"IF(ISERROR(VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A22,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-14",{"$f":"IF(ISERROR(VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A23,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-15",{"$f":"IF(ISERROR(VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A24,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"00:00:00"]
["2025-01-16",{"$f":"IF(ISERROR(VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A25,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"10:45:00"]
["2025-01-17",{"$f":"IF(ISERROR(VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A26,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-18",{"$f":"IF(ISERROR(VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A27,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-19",{"$f":"IF(ISERROR(VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A28,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-20",{"$f":"IF(ISERROR(VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A29,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-21",{"$f":"IF(ISERROR(VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A30,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-22",{"$f":"IF(ISERROR(VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A31,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-23",{"$f":"IF(ISERROR(VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A32,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-24",{"$f":"IF(ISERROR(VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A33,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-25",{"$f":"IF(ISERROR(VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A34,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-26",{"$f":"IF(ISERROR(VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A35,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-27",{"$f":"IF(ISERROR(VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A36,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-28",{"$f":"IF(ISERROR(VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A37,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-29",{"$f":"IF(ISERROR(VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A38,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-30",{"$f":"IF(ISERROR(VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A39,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,null,"06:30:00"]
["2025-01-31",{"$f":"IF(ISERROR(VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)),\"\",IF(VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)=0,\"\",VLOOKUP(A40,Hilfstabelle!$A$7:$C$27,3,FALSE)))","v":""},null,null,null,null,null,"+7:42","14:12:00","07:42:00","06:30:00","00:00:00","00:00:00","00:00:00"]
["Veränderung zum Vormonat:",null,null,null,null,null,null,null,"14:12:00","07:42:00","06:30:00","00:00:00","00:00:00","00:00:00",null," ∑"]
[]
["Übersicht Kontostände zum:",null,null,null,null,null,null,null,{"$f":"A40","v":"2025-01-31"}]
["Alterungskonten:"]
["Monat:",null,null,null,1,null,2,3,4,5,6,7,8,9,10,11,12,"13 bez."]
["Mehrarbeit:"]
["Bereit. (m.B.):"]
[]
["Urlaub:",null,null,null,0,null,null,"AZV-Tag:",null,null,null,null,0,null,"genutzte Zeiterfassungsgeräte:"]
["Resturlaub:",null,null,null,0,null,null,"Urlaub-Anspar Tage:",null,null,null,null,0,null,"WK01:","20x","WK03:","2x"]
["Zusatzurlaub:",null,null,null,0,null,null,"ZU Stunden SchwerB.:",null,null,null,null,"00:00:00"]
["Rest-Zusatzurlaub:",null,null,null,0,null,null,"Schichten:",null,null,null,null,0]
["SZU Anspruch (lfd. Jahr):",null,null,null,2,null,null,"Nachtdienststunden:",null,null,null,null,"00:00:00"]
["SZU genommen (lfd. Jahr):",null,null,null,1,null,null,"Auszahlung:",null,null,null,null,0]
["SZU aus Vorjahr:",null,null,null,0]
[]
["Legende:",null,null,"MA:Mehrarbeit",null,null,null,null,"ML: Mehrleistung",null,null,null,null,null,"MLnm: Mehrleistung nicht messbar"]
["ZK: Zeitkonto",null,null,"BmB: Bereitschaftszeit mit Befehl",null,null,null,null,"BVv: Bereitschaftszeit gem. Verwaltungsvereinbarung",null,null,null,null,null,"II: besonderer Buchungsgrund"]
["FAK: Freizeitrausgleichskonto",null,null,"RufB: Rufbereitschaft",null,null,null,null,"BmBlfd: Bereitschaftszeit mit Befehl laufender Monat",null,null,null,null,null,"T: Diensttausch"]

{"sheet":"Hilfstabelle","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[2024,2025]
[{"$f":"DATE($A$1,1,1)","v":"2024-01-01"},"Neujahr","Nj."]
[{"$f":"DATE($A$1,3,8)","v":"2024-03-08"},"Frauentag","Ft."]
[{"$f":"bewFeiert($A$1)-2","v":"2024-03-29"},"Karfreitag","Kf."]
[{"$f":"bewFeiert($A$1)","v":"2024-03-31"},"Ostersonntag","Os."]
[{"$f":"bewFeiert($A$1)+1","v":"2024-04-01"},"Ostermontag","Om."]
[{"$f":"DATE($A$1,5,1)","v":"2024-05-01"},"Tag d. Arbeit","Mf."]
[{"$f":"bewFeiert($A$1)+39","v":"2024-05-09"},"Himmelfahrt","Hf."]
[{"$f":"bewFeiert($A$1)+49","v":"2024-05-19"},"Pfingstsonntag","Pfs."]
[{"$f":"bewFeiert($A$1)+50","v":"2024-05-20"},"Pfingstmontag","Pfm."]
[{"$f":"DATE($A$1,10,3)","v":"2024-10-03"},"Tag d. dtsch. Einheit","T.d.E."]
[{"$f":"DATE($A$1,12,24)","v":"2024-12-24"},"Heilig Abend","HA"]
[{"$f":"DATE($A$1,12,25)","v":"2024-12-25"},"1. Weihnachtsfeiertag","1. Wf."]
[{"$f":"DATE($A$1,12,26)","v":"2024-12-26"},"2. Weihnachtsfeiertag","2. Wf."]
[{"$f":"DATE($A$1,12,31)","v":"2024-12-31"},"Silvester","Silv."]
[{"$f":"DATE($B$1,1,1)","v":"2025-01-01"},"Neujahr","Nj."]
[{"$f":"DATE($B$1,3,8)","v":"2025-03-08"},"Frauentag","Ft."]
[{"$f":"bewFeiert($B$1)-2","v":"2025-04-18"},"Karfreitag","Kf."]
[{"$f":"bewFeiert($B$1)","v":"2025-04-20"},"Ostersonntag","Os."]
[{"$f":"bewFeiert($B$1)+1","v":"2025-04-21"},"Ostermontag","Om."]
[{"$f":"DATE($B$1,5,1)","v":"2025-05-01"},"Tag d. Arbeit","Mf."]
[{"$f":"bewFeiert($B$1)+39","v":"2025-05-29"},"Himmelfahrt","Hf."]
[{"$f":"bewFeiert($B$1)+49","v":"2025-06-08"},"Pfingstsonntag","Pfs."]
[{"$f":"bewFeiert($B$1)+50","v":"2025-06-09"},"Pfingstmontag","Pfm."]
[{"$f":"DATE($B$1,10,3)","v":"2025-10-03"},"Tag d. dtsch. Einheit","T. d. E."]
[{"$f":"DATE($B$1,12,25)","v":"2025-12-25"},"1. Weihnachtsfeiertag","1. Wf."]
[{"$f":"DATE($B$1,12,26)","v":"2025-12-26"},"2. Weihnachtsfeiertag","2. Wf."]