{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Dez. 2024","Hilfstabelle"],"not_rendered":{"charts":0,"images":3,"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":38,"n_cols":500,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,0,5,2],[5,4,5,8],[1,1,1,3],[2,1,2,3],[3,20,3,22],[6,22,6,23],[1,20,1,34],[6,20,6,21],[1,5,1,8],[2,5,2,8],[1,10,1,13],[4,0,4,2],[4,4,4,7],[4,15,4,18]]}
[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,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]
[null,null,null,null,null,"Stundennachweis",null,null,null,null,"Dir ZS Pers A 12 PuZMan",null,null,null,null,null,null,null,null,null,"Schaltflächen + Hilfsspalten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,"für Tarifbeschäftigte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TT Gef"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hilfsberechnung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NT Gef"]
["Monat / Jahr",null,null,null,"Dienstkraft",null,null,null,null,null,null,"Dienststelle",null,null,null,null,null,null,null,null,"DE soll","DE ist","Std. + / -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr"]
["12 / 2024",null,null,null,"Herrmann, Frank, 24115913",null,null,null,null,null,null,"Dir ZeSo Gef 41/B",null,null,null,null,null,null,null,null,"06:00:00","06:20:00",{"$f":"V6-U6","v":"00:20:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U"]
["Datum","FT","Dienst","Von","Bis","Soll","AZ","Gesamt","ZK","ang.Std.","Üstd.","FtGs","FAK","B",null,null,null,null,null,null,"Stunden - ZK",null,"Stunden - FAK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DA"]
["2020-11-30",{"$f":"IF(ISERROR(VLOOKUP(A8,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A8,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A8,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SU2"]
[{"$f":"A8+1","v":"2020-12-01"},{"$f":"IF(ISERROR(VLOOKUP(A9,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A9,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A9,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H9<>\"\",J8+H9,J8)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BA"]
[{"$f":"A9+1","v":"2020-12-02"},{"$f":"IF(ISERROR(VLOOKUP(A10,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A10,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A10,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$f":"IF(H10<>\"\",J9+H10,J9)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lg"]
["2020-12-03",{"$f":"IF(ISERROR(VLOOKUP(A11,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A11,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A11,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fb"]
["2020-12-04",{"$f":"IF(ISERROR(VLOOKUP(A12,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A12,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A12,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 01"]
["2020-12-05",{"$f":"IF(ISERROR(VLOOKUP(A13,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A13,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A13,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 02"]
["2020-12-06",{"$f":"IF(ISERROR(VLOOKUP(A14,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A14,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A14,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 03"]
["2020-12-07",{"$f":"IF(ISERROR(VLOOKUP(A15,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A15,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A15,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 04"]
["2020-12-08",{"$f":"IF(ISERROR(VLOOKUP(A16,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A16,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A16,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 05"]
["2020-12-09",{"$f":"IF(ISERROR(VLOOKUP(A17,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A17,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A17,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 06"]
["2020-12-10",{"$f":"IF(ISERROR(VLOOKUP(A18,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A18,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A18,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 07"]
["2020-12-11",{"$f":"IF(ISERROR(VLOOKUP(A19,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A19,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A19,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 08"]
["2020-12-12",{"$f":"IF(ISERROR(VLOOKUP(A20,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A20,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A20,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 09"]
["2020-12-13",{"$f":"IF(ISERROR(VLOOKUP(A21,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A21,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A21,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 10"]
["2020-12-14",{"$f":"IF(ISERROR(VLOOKUP(A22,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A22,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A22,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 11"]
["2020-12-15",{"$f":"IF(ISERROR(VLOOKUP(A23,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A23,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A23,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 12"]
["2020-12-16",{"$f":"IF(ISERROR(VLOOKUP(A24,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A24,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A24,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 13"]
["2020-12-17",{"$f":"IF(ISERROR(VLOOKUP(A25,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A25,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A25,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 14"]
["2020-12-18",{"$f":"IF(ISERROR(VLOOKUP(A26,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A26,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A26,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 15"]
["2020-12-19",{"$f":"IF(ISERROR(VLOOKUP(A27,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A27,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A27,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 16"]
["2020-12-20",{"$f":"IF(ISERROR(VLOOKUP(A28,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A28,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A28,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 17"]
["2020-12-21",{"$f":"IF(ISERROR(VLOOKUP(A29,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A29,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A29,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 18"]
["2020-12-22",{"$f":"IF(ISERROR(VLOOKUP(A30,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A30,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A30,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F / 19"]
["2020-12-23",{"$f":"IF(ISERROR(VLOOKUP(A31,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A31,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A31,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":"HA"},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"}]
["2020-12-24",{"$f":"IF(ISERROR(VLOOKUP(A32,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A32,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A32,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":"1. Wf."},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"}]
["2020-12-25",{"$f":"IF(ISERROR(VLOOKUP(A33,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A33,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A33,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":"2. Wf."},null,null,null,null,null,null,null,{"$error":"#REF!"}]
["2020-12-26",{"$f":"IF(ISERROR(VLOOKUP(A34,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A34,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A34,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"}]
["2020-12-27",{"$f":"IF(ISERROR(VLOOKUP(A35,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A35,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A35,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"TT Gef","05:45:00","18:00:00","12:15:00",null,null,null,{"$error":"#REF!"}]
["2020-12-28",{"$f":"IF(ISERROR(VLOOKUP(A36,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A36,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A36,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},"NT Gef","17:45:00","06:00:00","12:15:00",null,null,null,{"$error":"#REF!"}]
["2020-12-29",{"$f":"IF(ISERROR(VLOOKUP(A37,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A37,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A37,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":""},null,null,null,null,null,null,null,{"$error":"#REF!"}]
["2020-12-30",{"$f":"IF(ISERROR(VLOOKUP(A38,Hilfstabelle!$A$2:$C$85,3,FALSE)),\"\",IF(VLOOKUP(A38,Hilfstabelle!$A$2:$C$85,3,FALSE)=0,\"\",VLOOKUP(A38,Hilfstabelle!$A$2:$C$85,3,FALSE)))","v":"Silv."},null,null,null,null,null,null,null,{"$error":"#REF!"}]

{"sheet":"Hilfstabelle","index":1,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[2024,2025,null,2026,"Datum erster Dienst im Monat",null,null,2025,"bitte auswählen"]
[{"$f":"DATE($A$1,1,1)","v":"2019-12-31"},"Neujahr","Nj.",2027,"2020-11-30","N","TT Gef",2026,"Januar"]
[{"$f":"DATE($A$1,3,8)","v":"2020-03-07"},"Frauentag","Ft.",2028,"2020-12-31","T","NT Gef",2027,"Februar"]
[{"$f":"A5-2","v":"2020-03-28"},"Karfreitag","Kf.",2029,"2021-02-01","T","SU2",2028,"März"]
[{"$f":"DATE(A1,3,28)+MOD(24-MOD(A1,19)*10.63,29)-MOD(TRUNC(A1*5/4)+MOD(24-MOD(A1,19)*10.63,29)+1,7)","v":"2020-03-30"},"Ostersonntag","Os."," ","2021-03-01","T","DA",2029,"April"]
[{"$f":"A5+1","v":"2020-03-31"},"Ostermontag","Om.",null,"2021-04-02","T","F / 01",null,"Mai"]
[{"$f":"DATE($A$1,5,1)","v":"2020-04-30"},"Tag d. Arbeit","Mf.",null,"2021-04-30","T","F / 02",null,"Juni"]
[{"$f":"A5+39","v":"2020-05-08"},"Himmelfahrt","Hf.",null,"2021-06-01","T","F / 03",null,"Juli"]
[{"$f":"A5+49","v":"2020-05-18"},"Pfingstsonntag","Pfs.",null,"2021-06-30","N","F / 04",null,"August"]
[{"$f":"A5+50","v":"2020-05-19"},"Pfingstmontag","Pfm.",null,"2021-07-31","T","F / 05",null,"September"]
[{"$f":"DATE($A$1,10,3)","v":"2020-10-02"},"Tag d. dtsch. Einheit","T.d.E.",null,"2021-09-01","T","F / 06",null,"Oktober"]
[{"$f":"DATE($A$1,12,24)","v":"2020-12-23"},"Heilig Abend","HA",null,"2021-09-30","N","F / 07",null,"November"]
[{"$f":"DATE($A$1,12,25)","v":"2020-12-24"},"1. Weihnachtsfeiertag","1. Wf.",null,"2021-10-31","T","F / 08",null,"Dezember"]
[{"$f":"DATE($A$1,12,26)","v":"2020-12-25"},"2. Weihnachtsfeiertag","2. Wf.",null,"2021-12-02","T","F / 09"]
[{"$f":"DATE($A$1,12,31)","v":"2020-12-30"},"Silvester","Silv.",null,"2021-12-31","N","F / 10"]
[{"$f":"DATE($B$1,1,1)","v":"2020-12-31"},"Neujahr","Nj.",null,"2022-01-31","T","F / 11"]
[{"$f":"DATE($B$1,3,8)","v":"2021-03-07"},"Frauentag","Ft.",null,"2022-02-28","T","F / 12"]
[{"$f":"A19-2","v":"2021-04-17"},"Karfreitag","Kf.",null,"2022-04-01","T","F / 13"]
[{"$f":"DATE(B1,3,28)+MOD(24-MOD(B1,19)*10.63,29)-MOD(TRUNC(B1*5/4)+MOD(24-MOD(B1,19)*10.63,29)+1,7)","v":"2021-04-19"},"Ostersonntag","Os.",null,"2022-04-30","N","F / 14"]
[{"$f":"A19+1","v":"2021-04-20"},"Ostermontag","Om.",null,"2022-05-31","T","F / 15"]
[{"$f":"DATE($B$1,5,1)","v":"2021-04-30"},"Tag d. Arbeit","Mf.",null,"2022-07-02","T","F / 16"]
[{"$f":"A19+39","v":"2021-05-28"},"Himmelfahrt","Hf.",null,"2022-07-31","N","F / 17"]
[{"$f":"A19+49","v":"2021-06-07"},"Pfingstsonntag","Pfs.",null,"2022-08-31","T","F / 18"]
[{"$f":"A19+50","v":"2021-06-08"},"Pfingstmontag","Pfm.",null,"2022-10-02","T","F / 19"]
[{"$f":"DATE($B$1,10,3)","v":"2021-10-02"},"Tag d. dtsch. Einheit","T.d.E.",null,"2022-10-31","N","U"]
[{"$f":"DATE($B$1,12,24)","v":"2021-12-23"},"Heilig Abend","HA",null,"2022-12-01","T","WoF"]
[{"$f":"DATE($B$1,12,25)","v":"2021-12-24"},"1. Weihnachtsfeiertag","1. Wf.",null,"2023-01-02","T","kr"]
[{"$f":"DATE($B$1,12,26)","v":"2021-12-25"},"2. Weihnachtsfeiertag","2. Wf.",null,"2023-01-31","N"]
[{"$f":"DATE($B$1,12,31)","v":"2021-12-30"},"Silvester","Silv.",null,"2023-02-28","N"]
[{"$f":"DATE($D$1,1,1)","v":"2021-12-31"},"Neujahr","Nj.",null,"2023-03-31","T"]
[{"$f":"DATE($D$1,3,8)","v":"2022-03-07"},"Frauentag","Ft.",null,"2023-05-02","T"]
[{"$f":"A33-2","v":"2022-04-02"},"Karfreitag","Kf.",null,"2023-05-31","N"]
[{"$f":"DATE(D1,3,28)+MOD(24-MOD(D1,19)*10.63,29)-MOD(TRUNC(D1*5/4)+MOD(24-MOD(D1,19)*10.63,29)+1,7)","v":"2022-04-04"},"Ostersonntag","Os.",null,"2023-07-01","T"]
[{"$f":"A33+1","v":"2022-04-05"},"Ostermontag","Om.",null,"2023-08-02","T"]
[{"$f":"DATE($D$1,5,1)","v":"2022-04-30"},"Tag d. Arbeit","Mf.",null,"2023-08-31","N"]
[{"$f":"A33+39","v":"2022-05-13"},"Himmelfahrt","Hf.",null,"2023-10-01","T"]
[{"$f":"A33+49","v":"2022-05-23"},"Pfingstsonntag","Pfs.",null,"2023-11-02","T"]
[{"$f":"A33+50","v":"2022-05-24"},"Pfingstmontag","Pfm.",null,"2023-11-30","T"]
[{"$f":"DATE($D$1,10,3)","v":"2022-10-02"},"Tag d. dtsch. Einheit","T.d.E.",null,"2024-01-01","T"]
[{"$f":"DATE($D$1,12,24)","v":"2022-12-23"},"Heilig Abend","HA",null,"2024-02-02","T"]
[{"$f":"DATE($D$1,12,25)","v":"2022-12-24"},"1. Weihnachtsfeiertag","1. Wf.",null,"2024-03-01","T"]
[{"$f":"DATE($D$1,12,26)","v":"2022-12-25"},"2. Weihnachtsfeiertag","2. Wf.",null,"2024-04-02","T"]
[{"$f":"DATE($D$1,12,31)","v":"2022-12-30"},"Silvester","Silv.",null,"2024-04-30","T"]
[{"$f":"DATE($D$2,1,1)","v":"2022-12-31"},"Neujahr","Nj.",null,"2024-06-01","T"]
[{"$f":"DATE($D$2,3,8)","v":"2023-03-07"},"Frauentag","Ft.",null,"2024-06-30","N"]
[{"$f":"A47-2","v":"2023-03-25"},"Karfreitag","Kf.",null,"2024-07-31","T"]
[{"$f":"DATE(D2,3,28)+MOD(24-MOD(D2,19)*10.63,29)-MOD(TRUNC(D2*5/4)+MOD(24-MOD(D2,19)*10.63,29)+1,7)","v":"2023-03-27"},"Ostersonntag","Os.",null,"2024-09-01","T"]
[{"$f":"A47+1","v":"2023-03-28"},"Ostermontag","Om.",null,"2024-09-30","N"]
[{"$f":"DATE($D$2,5,1)","v":"2023-04-30"},"Tag d. Arbeit","Mf.",null,"2024-10-31","T"]
[{"$f":"A47+39","v":"2023-05-05"},"Himmelfahrt","Hf.",null,"2024-12-02","T"]
[{"$f":"A47+49","v":"2023-05-15"},"Pfingstsonntag","Pfs.",null,"2024-12-31","N"]
[{"$f":"A47+50","v":"2023-05-16"},"Pfingstmontag","Pfm.",null,"2025-01-31","T"]
[{"$f":"DATE($D$2,10,3)","v":"2023-10-02"},"Tag d. dtsch. Einheit","T.d.E."]
[{"$f":"DATE($D$2,12,24)","v":"2023-12-23"},"Heilig Abend","HA"]
[{"$f":"DATE($D$2,12,25)","v":"2023-12-24"},"1. Weihnachtsfeiertag","1. Wf."]
[{"$f":"DATE($D$2,12,26)","v":"2023-12-25"},"2. Weihnachtsfeiertag","2. Wf."]
[{"$f":"DATE($D$2,12,31)","v":"2023-12-30"},"Silvester","Silv."]
[{"$f":"DATE($D$3,1,1)","v":"2023-12-31"},"Neujahr","Nj."]
[{"$f":"DATE($D$3,3,8)","v":"2024-03-07"},"Frauentag","Ft."]
[{"$f":"A61-2","v":"2024-04-13"},"Karfreitag","Kf."]
[{"$f":"DATE(D3,3,28)+MOD(24-MOD(D3,19)*10.63,29)-MOD(TRUNC(D3*5/4)+MOD(24-MOD(D3,19)*10.63,29)+1,7)","v":"2024-04-15"},"Ostersonntag","Os."]
[{"$f":"A61+1","v":"2024-04-16"},"Ostermontag","Om."]
[{"$f":"DATE($D$3,5,1)","v":"2024-04-30"},"Tag d. Arbeit","Mf."]
[{"$f":"A61+39","v":"2024-05-24"},"Himmelfahrt","Hf."]
[{"$f":"A61+49","v":"2024-06-03"},"Pfingstsonntag","Pfs."]
[{"$f":"A61+50","v":"2024-06-04"},"Pfingstmontag","Pfm."]
[{"$f":"DATE($D$3,10,3)","v":"2024-10-02"},"Tag d. dtsch. Einheit","T.d.E."]
[{"$f":"DATE($D$3,12,24)","v":"2024-12-23"},"Heilig Abend","HA"]
[{"$f":"DATE($D$3,12,25)","v":"2024-12-24"},"1. Weihnachtsfeiertag","1. Wf."]
[{"$f":"DATE($D$3,12,26)","v":"2024-12-25"},"2. Weihnachtsfeiertag","2. Wf."]
[{"$f":"DATE($D$3,12,31)","v":"2024-12-30"},"Silvester","Silv."]
[{"$f":"DATE($D$4,1,1)","v":"2024-12-31"},"Neujahr","Nj."]
[{"$f":"DATE($D$4,3,8)","v":"2025-03-07"},"Frauentag","Ft."]
[{"$f":"A75-2","v":"2025-03-29"},"Karfreitag","Kf."]
[{"$f":"DATE(D4,3,28)+MOD(24-MOD(D4,19)*10.63,29)-MOD(TRUNC(D4*5/4)+MOD(24-MOD(D4,19)*10.63,29)+1,7)","v":"2025-03-31"},"Ostersonntag","Os."]
[{"$f":"A75+1","v":"2025-04-01"},"Ostermontag","Om."]
[{"$f":"DATE($D$4,5,1)","v":"2025-04-30"},"Tag d. Arbeit","Mf."]
[{"$f":"A75+39","v":"2025-05-09"},"Himmelfahrt","Hf."]
[{"$f":"A75+49","v":"2025-05-19"},"Pfingstsonntag","Pfs."]
[{"$f":"A75+50","v":"2025-05-20"},"Pfingstmontag","Pfm."]
[{"$f":"DATE($D$4,10,3)","v":"2025-10-02"},"Tag d. dtsch. Einheit","T.d.E."]
[{"$f":"DATE($D$4,12,24)","v":"2025-12-23"},"Heilig Abend","HA"]
[{"$f":"DATE($D$4,12,25)","v":"2025-12-24"},"1. Weihnachtsfeiertag","1. Wf."]
[{"$f":"DATE($D$4,12,26)","v":"2025-12-25"},"2. Weihnachtsfeiertag","2. Wf."]
[{"$f":"DATE($D$4,12,31)","v":"2025-12-30"},"Silvester","Silv."]