{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Formular","Org"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"1904"}

{"sheet":"Formular","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[16,0,17,0],[1,5,1,13],[3,5,4,6],[3,7,4,10],[5,5,6,5],[7,5,8,5],[5,7,6,10],[7,7,8,10],[9,7,10,10],[2,11,2,12],[11,5,11,6],[11,7,11,10],[12,7,14,10],[20,16,38,16],[0,5,0,13],[16,5,17,5],[16,10,17,10],[16,9,17,9]]}
[{"$f":"H8&\" \"&H10","v":" "}]
[null,null,null,null,null,"Berechnung Mehrarbeit "]
[null,null,null,null,null,null,null,null,null,null,null,"Wochenarbeitszeit [muss angekreuzt werden]"]
[null,null,null,null,null,"Name, Vorname",null,null,null,null,null,null,"39h"]
[null,null,null,null,null,null,null,null,null,null,null,null,"40h"]
[null,null,null,null,null,"Pers.-Nr.:",null,null,null,null,null,null,"41h"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Individuell"]
[null,null,null,null,null,"Monat"]
[]
[null,null,null,null,null,"Jahr:"]
[]
[null,null,null,null,null,"MA angeordnet am:\n"]
[]
[null,null,null,null,null,"angeordnet von:"]
[]
[]
["Tag",null,null,null,null,"Wochentag","Dienstbeginn","Dienstschluss","Dauer","Pausenzeiten gesamt","anrechenbar","tägl. SollarbZeit"]
[null,"Feiertag","Datum Text","Datum","Wochentag",null,"(Uhrzeit)","(Uhrzeit)",null,null,null,"Mo-Do 8:30 / 8:45 / 9:00\nFr 5:00","Individuelle Zeiten eintragen","Mehrarbeit"]
[1,{"$f":"IFERROR(VLOOKUP(D19,Org!$B$4:$B$17,1,0),\"\")","v":""},{"$f":"A19&\".\"&\" \"&$H$8&\" \"&$H$10","v":"1.  "},{"$f":"DATEVALUE(C19)","v":{"$error":"#VALUE!"}},{"$f":"WEEKDAY(C19,16)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(TEXT(E19,\"TTT\"),\"\")","v":""},null,null,{"$f":"IF(SUM(H19-G19)=0,\"\",SUM(H19-G19))","v":""},{"$f":"IFERROR(IF(I19=\"\",\"\",IF(I19<=Org!$J$12,\"\",IF(AND(I19>=Org!J$11,I19<=Org!J$10),I19-Org!J$12,IF(AND(I19>=Org!$J$9,I19<=Org!$J$5),Org!$J$14,IF(AND(I19>=Org!$J$5,I19<=Org!$J$3),(I19-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},{"$f":"IFERROR(IF(AND(E19=7,I19>0.25,I19<=0.27083333),0.25,IF(AND(I19>=0.364583333333333,I19<0.385416666666667),0.364583333333333+(I19-0.385416666666667),IF(J19=\"\",I19,IF(I19>=0.385416666666667,SUM(I19-J19),SUM(I19-J19))))),\"\")","v":""},{"$f":"IFERROR(IF(I19=\"\",\"\",IF(AND($L$4=\"\",$L$5=\"\",$L$6=\"\",$L$7=\"\"),\"\",IF($L$7=\"x\",M19,IF(I19=0,\"\",IF(OR(E19=1,E19=2),K19,IF(AND(E19<7,E19>=2,$L$4=\"x\"),0.354166666666667,IF(AND(E19<7,E19>=2,$L$5=\"x\"),0.364583333333333,IF(AND(E19<7,E19>=2,$L$6=\"x\"),0.375,IF(E19=7,0.208333333333333,\"\"))))))))),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(E19=1,E19=2),K19,IF(AND($L$7<>\"x\",E19>=3),K19-L19,IF($L$7=\"x\",K19-M19,IF(B19=D19,K19,IF(K19=L19,\"\",IF(AND(L19=\"\",M19=\"\"),\"\",K19-L19)))))),\"\")","v":""}]
[2,{"$f":"IFERROR(VLOOKUP(D20,Org!$B$4:$B$17,1,0),\"\")","v":""},"2.  ",{"$f":"DATEVALUE(C20)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IFERROR(TEXT(E20,\"TTT\"),\"\")","v":""},null,null,{"$f":"IF(SUM(H20-G20)=0,\"\",SUM(H20-G20))","v":""},{"$f":"IFERROR(IF(I20=\"\",\"\",IF(I20<=Org!$J$12,\"\",IF(AND(I20>=Org!J$11,I20<=Org!J$10),I20-Org!J$12,IF(AND(I20>=Org!$J$9,I20<=Org!$J$5),Org!$J$14,IF(AND(I20>=Org!$J$5,I20<=Org!$J$3),(I20-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},{"$f":"IFERROR(IF(AND(E20=7,I20>0.25,I20<=0.27083333),0.25,IF(AND(I20>=0.364583333333333,I20<0.385416666666667),0.364583333333333+(I20-0.385416666666667),IF(J20=\"\",I20,IF(I20>=0.385416666666667,SUM(I20-J20),SUM(I20-J20))))),\"\")","v":""},{"$f":"IFERROR(IF(I20=\"\",\"\",IF(AND($L$4=\"\",$L$5=\"\",$L$6=\"\",$L$7=\"\"),\"\",IF($L$7=\"x\",M20,IF(I20=0,\"\",IF(OR(E20=1,E20=2),K20,IF(AND(E20<7,E20>=2,$L$4=\"x\"),0.354166666666667,IF(AND(E20<7,E20>=2,$L$5=\"x\"),0.364583333333333,IF(AND(E20<7,E20>=2,$L$6=\"x\"),0.375,IF(E20=7,0.208333333333333,\"\"))))))))),\"\")","v":""},null,{"$f":"IFERROR(IF(OR(E20=1,E20=2),K20,IF(AND($L$7<>\"x\",E20>=3),K20-L20,IF($L$7=\"x\",K20-M20,IF(B20=D20,K20,IF(K20=L20,\"\",IF(AND(L20=\"\",M20=\"\"),\"\",K20-L20)))))),\"\")","v":""}]
[3,{"$f":"IFERROR(VLOOKUP(D21,Org!$B$4:$B$17,1,0),\"\")","v":""},"3.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,{"$f":"IF(SUM(H21-G21)=0,\"\",SUM(H21-G21))","v":""},{"$f":"IFERROR(IF(I21=\"\",\"\",IF(I21<=Org!$J$12,\"\",IF(AND(I21>=Org!J$11,I21<=Org!J$10),I21-Org!J$12,IF(AND(I21>=Org!$J$9,I21<=Org!$J$5),Org!$J$14,IF(AND(I21>=Org!$J$5,I21<=Org!$J$3),(I21-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"",{"$f":"IFERROR(IF(I21=\"\",\"\",IF(AND($L$4=\"\",$L$5=\"\",$L$6=\"\",$L$7=\"\"),\"\",IF($L$7=\"x\",M21,IF(I21=0,\"\",IF(OR(E21=1,E21=2),K21,IF(AND(E21<7,E21>=2,$L$4=\"x\"),0.354166666666667,IF(AND(E21<7,E21>=2,$L$5=\"x\"),0.364583333333333,IF(AND(E21<7,E21>=2,$L$6=\"x\"),0.375,IF(E21=7,0.208333333333333,\"\"))))))))),\"\")","v":""},null,""]
[4,{"$f":"IFERROR(VLOOKUP(D22,Org!$B$4:$B$17,1,0),\"\")","v":""},"4.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,{"$f":"IF(SUM(H22-G22)=0,\"\",SUM(H22-G22))","v":""},{"$f":"IFERROR(IF(I22=\"\",\"\",IF(I22<=Org!$J$12,\"\",IF(AND(I22>=Org!J$11,I22<=Org!J$10),I22-Org!J$12,IF(AND(I22>=Org!$J$9,I22<=Org!$J$5),Org!$J$14,IF(AND(I22>=Org!$J$5,I22<=Org!$J$3),(I22-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[5,{"$f":"IFERROR(VLOOKUP(D23,Org!$B$4:$B$17,1,0),\"\")","v":""},"5.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,{"$f":"IF(SUM(H23-G23)=0,\"\",SUM(H23-G23))","v":""},{"$f":"IFERROR(IF(I23=\"\",\"\",IF(I23<=Org!$J$12,\"\",IF(AND(I23>=Org!J$11,I23<=Org!J$10),I23-Org!J$12,IF(AND(I23>=Org!$J$9,I23<=Org!$J$5),Org!$J$14,IF(AND(I23>=Org!$J$5,I23<=Org!$J$3),(I23-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[6,{"$f":"IFERROR(VLOOKUP(D24,Org!$B$4:$B$17,1,0),\"\")","v":""},"6.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,{"$f":"IF(SUM(H24-G24)=0,\"\",SUM(H24-G24))","v":""},{"$f":"IFERROR(IF(I24=\"\",\"\",IF(I24<=Org!$J$12,\"\",IF(AND(I24>=Org!J$11,I24<=Org!J$10),I24-Org!J$12,IF(AND(I24>=Org!$J$9,I24<=Org!$J$5),Org!$J$14,IF(AND(I24>=Org!$J$5,I24<=Org!$J$3),(I24-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[7,{"$f":"IFERROR(VLOOKUP(D25,Org!$B$4:$B$17,1,0),\"\")","v":""},"7.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I25=\"\",\"\",IF(I25<=Org!$J$12,\"\",IF(AND(I25>=Org!J$11,I25<=Org!J$10),I25-Org!J$12,IF(AND(I25>=Org!$J$9,I25<=Org!$J$5),Org!$J$14,IF(AND(I25>=Org!$J$5,I25<=Org!$J$3),(I25-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[8,{"$f":"IFERROR(VLOOKUP(D26,Org!$B$4:$B$17,1,0),\"\")","v":""},"8.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I26=\"\",\"\",IF(I26<=Org!$J$12,\"\",IF(AND(I26>=Org!J$11,I26<=Org!J$10),I26-Org!J$12,IF(AND(I26>=Org!$J$9,I26<=Org!$J$5),Org!$J$14,IF(AND(I26>=Org!$J$5,I26<=Org!$J$3),(I26-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[9,{"$f":"IFERROR(VLOOKUP(D27,Org!$B$4:$B$17,1,0),\"\")","v":""},"9.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I27=\"\",\"\",IF(I27<=Org!$J$12,\"\",IF(AND(I27>=Org!J$11,I27<=Org!J$10),I27-Org!J$12,IF(AND(I27>=Org!$J$9,I27<=Org!$J$5),Org!$J$14,IF(AND(I27>=Org!$J$5,I27<=Org!$J$3),(I27-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[10,{"$f":"IFERROR(VLOOKUP(D28,Org!$B$4:$B$17,1,0),\"\")","v":""},"10.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I28=\"\",\"\",IF(I28<=Org!$J$12,\"\",IF(AND(I28>=Org!J$11,I28<=Org!J$10),I28-Org!J$12,IF(AND(I28>=Org!$J$9,I28<=Org!$J$5),Org!$J$14,IF(AND(I28>=Org!$J$5,I28<=Org!$J$3),(I28-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[11,{"$f":"IFERROR(VLOOKUP(D29,Org!$B$4:$B$17,1,0),\"\")","v":""},"11.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I29=\"\",\"\",IF(I29<=Org!$J$12,\"\",IF(AND(I29>=Org!J$11,I29<=Org!J$10),I29-Org!J$12,IF(AND(I29>=Org!$J$9,I29<=Org!$J$5),Org!$J$14,IF(AND(I29>=Org!$J$5,I29<=Org!$J$3),(I29-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[12,{"$f":"IFERROR(VLOOKUP(D30,Org!$B$4:$B$17,1,0),\"\")","v":""},"12.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I30=\"\",\"\",IF(I30<=Org!$J$12,\"\",IF(AND(I30>=Org!J$11,I30<=Org!J$10),I30-Org!J$12,IF(AND(I30>=Org!$J$9,I30<=Org!$J$5),Org!$J$14,IF(AND(I30>=Org!$J$5,I30<=Org!$J$3),(I30-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[13,{"$f":"IFERROR(VLOOKUP(D31,Org!$B$4:$B$17,1,0),\"\")","v":""},"13.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I31=\"\",\"\",IF(I31<=Org!$J$12,\"\",IF(AND(I31>=Org!J$11,I31<=Org!J$10),I31-Org!J$12,IF(AND(I31>=Org!$J$9,I31<=Org!$J$5),Org!$J$14,IF(AND(I31>=Org!$J$5,I31<=Org!$J$3),(I31-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[14,{"$f":"IFERROR(VLOOKUP(D32,Org!$B$4:$B$17,1,0),\"\")","v":""},"14.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I32=\"\",\"\",IF(I32<=Org!$J$12,\"\",IF(AND(I32>=Org!J$11,I32<=Org!J$10),I32-Org!J$12,IF(AND(I32>=Org!$J$9,I32<=Org!$J$5),Org!$J$14,IF(AND(I32>=Org!$J$5,I32<=Org!$J$3),(I32-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[15,{"$f":"IFERROR(VLOOKUP(D33,Org!$B$4:$B$17,1,0),\"\")","v":""},"15.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I33=\"\",\"\",IF(I33<=Org!$J$12,\"\",IF(AND(I33>=Org!J$11,I33<=Org!J$10),I33-Org!J$12,IF(AND(I33>=Org!$J$9,I33<=Org!$J$5),Org!$J$14,IF(AND(I33>=Org!$J$5,I33<=Org!$J$3),(I33-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[16,{"$f":"IFERROR(VLOOKUP(D34,Org!$B$4:$B$17,1,0),\"\")","v":""},"16.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I34=\"\",\"\",IF(I34<=Org!$J$12,\"\",IF(AND(I34>=Org!J$11,I34<=Org!J$10),I34-Org!J$12,IF(AND(I34>=Org!$J$9,I34<=Org!$J$5),Org!$J$14,IF(AND(I34>=Org!$J$5,I34<=Org!$J$3),(I34-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[17,{"$f":"IFERROR(VLOOKUP(D35,Org!$B$4:$B$17,1,0),\"\")","v":""},"17.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I35=\"\",\"\",IF(I35<=Org!$J$12,\"\",IF(AND(I35>=Org!J$11,I35<=Org!J$10),I35-Org!J$12,IF(AND(I35>=Org!$J$9,I35<=Org!$J$5),Org!$J$14,IF(AND(I35>=Org!$J$5,I35<=Org!$J$3),(I35-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[18,{"$f":"IFERROR(VLOOKUP(D36,Org!$B$4:$B$17,1,0),\"\")","v":""},"18.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I36=\"\",\"\",IF(I36<=Org!$J$12,\"\",IF(AND(I36>=Org!J$11,I36<=Org!J$10),I36-Org!J$12,IF(AND(I36>=Org!$J$9,I36<=Org!$J$5),Org!$J$14,IF(AND(I36>=Org!$J$5,I36<=Org!$J$3),(I36-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[19,{"$f":"IFERROR(VLOOKUP(D37,Org!$B$4:$B$17,1,0),\"\")","v":""},"19.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I37=\"\",\"\",IF(I37<=Org!$J$12,\"\",IF(AND(I37>=Org!J$11,I37<=Org!J$10),I37-Org!J$12,IF(AND(I37>=Org!$J$9,I37<=Org!$J$5),Org!$J$14,IF(AND(I37>=Org!$J$5,I37<=Org!$J$3),(I37-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[20,{"$f":"IFERROR(VLOOKUP(D38,Org!$B$4:$B$17,1,0),\"\")","v":""},"20.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I38=\"\",\"\",IF(I38<=Org!$J$12,\"\",IF(AND(I38>=Org!J$11,I38<=Org!J$10),I38-Org!J$12,IF(AND(I38>=Org!$J$9,I38<=Org!$J$5),Org!$J$14,IF(AND(I38>=Org!$J$5,I38<=Org!$J$3),(I38-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[21,{"$f":"IFERROR(VLOOKUP(D39,Org!$B$4:$B$17,1,0),\"\")","v":""},"21.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I39=\"\",\"\",IF(I39<=Org!$J$12,\"\",IF(AND(I39>=Org!J$11,I39<=Org!J$10),I39-Org!J$12,IF(AND(I39>=Org!$J$9,I39<=Org!$J$5),Org!$J$14,IF(AND(I39>=Org!$J$5,I39<=Org!$J$3),(I39-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[22,{"$f":"IFERROR(VLOOKUP(D40,Org!$B$4:$B$17,1,0),\"\")","v":""},"22.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I40=\"\",\"\",IF(I40<=Org!$J$12,\"\",IF(AND(I40>=Org!J$11,I40<=Org!J$10),I40-Org!J$12,IF(AND(I40>=Org!$J$9,I40<=Org!$J$5),Org!$J$14,IF(AND(I40>=Org!$J$5,I40<=Org!$J$3),(I40-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[23,{"$f":"IFERROR(VLOOKUP(D41,Org!$B$4:$B$17,1,0),\"\")","v":""},"23.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I41=\"\",\"\",IF(I41<=Org!$J$12,\"\",IF(AND(I41>=Org!J$11,I41<=Org!J$10),I41-Org!J$12,IF(AND(I41>=Org!$J$9,I41<=Org!$J$5),Org!$J$14,IF(AND(I41>=Org!$J$5,I41<=Org!$J$3),(I41-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[24,{"$f":"IFERROR(VLOOKUP(D42,Org!$B$4:$B$17,1,0),\"\")","v":""},"24.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I42=\"\",\"\",IF(I42<=Org!$J$12,\"\",IF(AND(I42>=Org!J$11,I42<=Org!J$10),I42-Org!J$12,IF(AND(I42>=Org!$J$9,I42<=Org!$J$5),Org!$J$14,IF(AND(I42>=Org!$J$5,I42<=Org!$J$3),(I42-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[25,{"$f":"IFERROR(VLOOKUP(D43,Org!$B$4:$B$17,1,0),\"\")","v":""},"25.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I43=\"\",\"\",IF(I43<=Org!$J$12,\"\",IF(AND(I43>=Org!J$11,I43<=Org!J$10),I43-Org!J$12,IF(AND(I43>=Org!$J$9,I43<=Org!$J$5),Org!$J$14,IF(AND(I43>=Org!$J$5,I43<=Org!$J$3),(I43-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[26,{"$f":"IFERROR(VLOOKUP(D44,Org!$B$4:$B$17,1,0),\"\")","v":""},"26.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I44=\"\",\"\",IF(I44<=Org!$J$12,\"\",IF(AND(I44>=Org!J$11,I44<=Org!J$10),I44-Org!J$12,IF(AND(I44>=Org!$J$9,I44<=Org!$J$5),Org!$J$14,IF(AND(I44>=Org!$J$5,I44<=Org!$J$3),(I44-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[27,{"$f":"IFERROR(VLOOKUP(D45,Org!$B$4:$B$17,1,0),\"\")","v":""},"27.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I45=\"\",\"\",IF(I45<=Org!$J$12,\"\",IF(AND(I45>=Org!J$11,I45<=Org!J$10),I45-Org!J$12,IF(AND(I45>=Org!$J$9,I45<=Org!$J$5),Org!$J$14,IF(AND(I45>=Org!$J$5,I45<=Org!$J$3),(I45-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[28,{"$f":"IFERROR(VLOOKUP(D46,Org!$B$4:$B$17,1,0),\"\")","v":""},"28.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I46=\"\",\"\",IF(I46<=Org!$J$12,\"\",IF(AND(I46>=Org!J$11,I46<=Org!J$10),I46-Org!J$12,IF(AND(I46>=Org!$J$9,I46<=Org!$J$5),Org!$J$14,IF(AND(I46>=Org!$J$5,I46<=Org!$J$3),(I46-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[29,{"$f":"IFERROR(VLOOKUP(D47,Org!$B$4:$B$17,1,0),\"\")","v":""},"29.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I47=\"\",\"\",IF(I47<=Org!$J$12,\"\",IF(AND(I47>=Org!J$11,I47<=Org!J$10),I47-Org!J$12,IF(AND(I47>=Org!$J$9,I47<=Org!$J$5),Org!$J$14,IF(AND(I47>=Org!$J$5,I47<=Org!$J$3),(I47-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[30,{"$f":"IFERROR(VLOOKUP(D48,Org!$B$4:$B$17,1,0),\"\")","v":""},"30.  ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,"",{"$f":"IFERROR(IF(I48=\"\",\"\",IF(I48<=Org!$J$12,\"\",IF(AND(I48>=Org!J$11,I48<=Org!J$10),I48-Org!J$12,IF(AND(I48>=Org!$J$9,I48<=Org!$J$5),Org!$J$14,IF(AND(I48>=Org!$J$5,I48<=Org!$J$3),(I48-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[31,{"$f":"IFERROR(VLOOKUP(D49,Org!$B$4:$B$17,1,0),\"\")","v":""},"31.  ",{"$f":"IFERROR(DATEVALUE(C49),\"\")","v":""},{"$f":"IFERROR(WEEKDAY(C49,16),\"\")","v":""},"",null,null,"",{"$f":"IFERROR(IF(I49=\"\",\"\",IF(I49<=Org!$J$12,\"\",IF(AND(I49>=Org!J$11,I49<=Org!J$10),I49-Org!J$12,IF(AND(I49>=Org!$J$9,I49<=Org!$J$5),Org!$J$14,IF(AND(I49>=Org!$J$5,I49<=Org!$J$3),(I49-Org!$J$5)+Org!$J$14,\"00:45\"))))),\"\")","v":""},"","",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00"]

{"sheet":"Org","index":1,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Dezimalzahlen","Zeiten"]
[null,null,null,"Jahr",null,{"$f":"IF(OR(MOD(D3,400)=0,AND(MOD(D3,4)=0,MOD(D3,100)<>0)),\"Schaltjahr\", \"kein Schaltjahr\")","v":"Schaltjahr"},{"$f":"IF(F2=\"Schaltjahr\",\"29.02.\"&D3,\"\")","v":"29.02.0"},null,null,0.40625,"09:45:00"]
[null,"Feiertage",null,{"$f":"Formular!H10","v":0},null,null,null,null,null,0.405555555555556,"09:44:00"]
["Neujahr",{"$f":"DATE($D$3,1,1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.39652777777777798,"09:31:00"]
["internationaler Frauentag",{"$f":"DATE($D$3,3,8)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.39583333333333331,"09:30:00"]
["Karfreitag",{"$f":"$B$7-2","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.375,"09:00:00"]
["Ostersonntag",{"$f":"DATE(D$3,3,28)+MOD(24-MOD(D$3,19)*10.63,29)-MOD(TRUNC(D$3*5/4)+MOD(24-MOD(D$3,19)*10.63,29)+1,7)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.36458333333333298,"08:45:00"]
["Ostermontag",{"$f":"$B$7+1","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.35416666666666702,"08:30:00"]
["Tag der Arbeit",{"$f":"DATE($D$3,5,1)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.27083333333333331,"06:30:00"]
["Christi Himmelfahrt",{"$f":"B7+39","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.27013888888888887,"06:29:00"]
["Pfingstsonntag",{"$f":"B7+49","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.25069444444444444,"06:01:00"]
["Pfingstmontag",{"$f":"B7+50","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.25,"06:00:00"]
["Tag der Deutschen Einheit",{"$f":"DATE($D$3,10,3)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,0.20833333333333301,"05:00:00"]
["Heiligabend",{"$f":"DATE($D$3,12,24)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,2.0833333333333332E-2,"00:30:00"]
["1. Weihnachtsfeiertag",{"$f":"DATE($D$3,12,25)","v":{"$error":"#NUM!"}}]
["2. Weihnachtsfeiertag",{"$f":"DATE($D$3,12,26)","v":{"$error":"#NUM!"}}]
["Silvester",{"$f":"DATE($D$3,12,31)","v":{"$error":"#NUM!"}}]