{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Erfassung","Feiertage","Arbeitszeiten"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":48,"comments":2,"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":"Erfassung","index":0,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,11,2],[9,4,11,15],[13,1,15,1]]}
["Jahr","Wochenarbeitszeit","Prozent alle Mt","Ferientage im Jahr","Jan","Feb","März","Apr","Mai","Juni","Juli","Aug","Sept","Okt","Nov","Dez"]
[2024,42,1,30,{"$f":"$C$2","v":1},{"$f":"$C$2","v":1},1,1,1,1,1,1,1,1,1,1]
[]
[]
[null,null,null,null,null,null,null,null,null,"zu den Feiertagen/Ferien"]
[]
[null,null,null,null,null,null,null,null,null,"zu den Arbeitszeiten"]
[]
[]
[null,"im sk-app unter Administration, Arbeitszeiten eintragen:",null,null,"im sk-app unter Administration+2021, die Stunden eintragen:"]
[]
[]
[null,"Saldovortrag","Ferien",null,"Jan","Feb","März","Apr","Mai","Juni","Juli","Aug","Sept","Okt","Nov","Dez"]
[null,"siehe Excel Zeiterfassung Mappe \"Monat 2023\"",{"$f":"Arbeitszeiten!AK31","v":252},null,{"$f":"Arbeitszeiten!AJ4","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ6","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ8","v":168.00000000000006},{"$f":"Arbeitszeiten!AJ10","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ12","v":172.20000000000005},{"$f":"Arbeitszeiten!AJ14","v":168.00000000000006},{"$f":"Arbeitszeiten!AJ16","v":193.20000000000007},{"$f":"Arbeitszeiten!AJ18","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ20","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ22","v":193.20000000000007},{"$f":"Arbeitszeiten!AJ24","v":176.40000000000006},{"$f":"Arbeitszeiten!AJ26","v":168.00000000000006}]

{"sheet":"Feiertage","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,4,2,7]]}
["Datum","Feiertag"]
["2024-01-01","Neujahrstag",null,null,"zu den Resultaten"]
["2024-01-02","Berchtoldstag (statt 1. Mai = gleiches Resultat)"]
["2024-03-29","Karfreitag"]
["2024-04-01","Ostermontag"]
["2024-05-09","Auffahrt"]
["2024-05-20","Pfingstmontag"]
["2024-08-01","Nationalfeiertag Schweiz"]
["2024-12-25","Weihnachten"]
["2024-12-26","Stephanstag"]

{"sheet":"Arbeitszeiten","index":2,"n_rows":32,"n_cols":37,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,35,1,36]]}
["Arbeitszeiten"]
[2024,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,"F Tage","Ferien h","A-Tage","Monatssaldo"]
[null,"2024-01-01",{"$f":"B3+1","v":"2024-01-02"},{"$f":"C3+1","v":"2024-01-03"},"2024-01-04","2024-01-05","2024-01-06","2024-01-07","2024-01-08","2024-01-09","2024-01-10","2024-01-11","2024-01-12","2024-01-13","2024-01-14","2024-01-15","2024-01-16","2024-01-17","2024-01-18","2024-01-19","2024-01-20","2024-01-21","2024-01-22","2024-01-23","2024-01-24","2024-01-25","2024-01-26","2024-01-27","2024-01-28","2024-01-29","2024-01-30","2024-01-31"]
["Januar",{"$f":"IF(ISNA(VLOOKUP(B3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B3)=1,WEEKDAY(B3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(C3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C3)=1,WEEKDAY(C3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(D3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D3)=1,WEEKDAY(D3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E3)=1,WEEKDAY(E3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F3)=1,WEEKDAY(F3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G3)=1,WEEKDAY(G3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(H3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H3)=1,WEEKDAY(H3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(I3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I3)=1,WEEKDAY(I3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J3)=1,WEEKDAY(J3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K3)=1,WEEKDAY(K3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L3)=1,WEEKDAY(L3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M3)=1,WEEKDAY(M3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N3)=1,WEEKDAY(N3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(O3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O3)=1,WEEKDAY(O3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(P3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P3)=1,WEEKDAY(P3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q3)=1,WEEKDAY(Q3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R3)=1,WEEKDAY(R3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S3)=1,WEEKDAY(S3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T3)=1,WEEKDAY(T3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U3)=1,WEEKDAY(U3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(V3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V3)=1,WEEKDAY(V3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(W3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W3)=1,WEEKDAY(W3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X3)=1,WEEKDAY(X3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y3)=1,WEEKDAY(Y3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z3)=1,WEEKDAY(Z3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA3)=1,WEEKDAY(AA3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB3)=1,WEEKDAY(AB3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AC3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC3)=1,WEEKDAY(AC3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AD3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD3)=1,WEEKDAY(AD3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE3)=1,WEEKDAY(AE3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF3,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF3)=1,WEEKDAY(AF3)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$E$2:$E$2)/5),\"F\")","v":8.4},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG4=\"\",\"\",AG4*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21},{"$f":"COUNT(B4:AF4,\"<0.1\")","v":21},{"$f":"SUM(B4:AF4)","v":176.40000000000006},"Januar"]
[null,{"$f":"AF3+1","v":"2024-02-01"},{"$f":"B5+1","v":"2024-02-02"},"2024-02-03","2024-02-04","2024-02-05","2024-02-06","2024-02-07","2024-02-08","2024-02-09","2024-02-10","2024-02-11","2024-02-12","2024-02-13","2024-02-14","2024-02-15","2024-02-16","2024-02-17","2024-02-18","2024-02-19","2024-02-20","2024-02-21","2024-02-22","2024-02-23","2024-02-24","2024-02-25","2024-02-26","2024-02-27","2024-02-28","2024-02-29",null,null,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG5=\"\",\"\",AG5*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["Februar",{"$f":"IF(ISNA(VLOOKUP(B5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B5)=1,WEEKDAY(B5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C5)=1,WEEKDAY(C5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D5)=1,WEEKDAY(D5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E5)=1,WEEKDAY(E5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(F5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F5)=1,WEEKDAY(F5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G5)=1,WEEKDAY(G5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H5)=1,WEEKDAY(H5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I5)=1,WEEKDAY(I5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J5)=1,WEEKDAY(J5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K5)=1,WEEKDAY(K5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(L5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L5)=1,WEEKDAY(L5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(M5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M5)=1,WEEKDAY(M5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N5)=1,WEEKDAY(N5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O5)=1,WEEKDAY(O5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P5)=1,WEEKDAY(P5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q5)=1,WEEKDAY(Q5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R5)=1,WEEKDAY(R5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(S5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S5)=1,WEEKDAY(S5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(T5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T5)=1,WEEKDAY(T5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U5)=1,WEEKDAY(U5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V5)=1,WEEKDAY(V5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W5)=1,WEEKDAY(W5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X5)=1,WEEKDAY(X5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y5)=1,WEEKDAY(Y5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Z5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z5)=1,WEEKDAY(Z5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AA5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA5)=1,WEEKDAY(AA5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB5)=1,WEEKDAY(AB5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC5)=1,WEEKDAY(AC5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD5)=1,WEEKDAY(AD5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE5)=1,WEEKDAY(AE5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AF5,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF5)=1,WEEKDAY(AF5)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$F2:$F2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG6=\"\",\"\",AG6*(Erfassung!$B$2/5)*SUM(Erfassung!F$2))","v":21},{"$f":"COUNT(B6:AF6,\"<0.1\")","v":21},{"$f":"SUM(B6:AF6)","v":176.40000000000006},"Februar"]
[null,{"$f":"AD5+1","v":"2024-03-01"},{"$f":"B7+1","v":45353},45354,45355,45356,45357,45358,45359,45360,45361,45362,45363,45364,45365,45366,45367,45368,45369,45370,45371,45372,45373,45374,45375,45376,45377,45378,45379,45380,45381,45382,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG7=\"\",\"\",AG7*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["März",{"$f":"IF(ISNA(VLOOKUP(B7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B7)=1,WEEKDAY(B7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C7)=1,WEEKDAY(C7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(D7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D7)=1,WEEKDAY(D7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E7)=1,WEEKDAY(E7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F7)=1,WEEKDAY(F7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G7)=1,WEEKDAY(G7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H7)=1,WEEKDAY(H7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I7)=1,WEEKDAY(I7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J7)=1,WEEKDAY(J7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(K7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K7)=1,WEEKDAY(K7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(L7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L7)=1,WEEKDAY(L7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M7)=1,WEEKDAY(M7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N7)=1,WEEKDAY(N7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O7)=1,WEEKDAY(O7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P7)=1,WEEKDAY(P7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q7)=1,WEEKDAY(Q7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(R7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R7)=1,WEEKDAY(R7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(S7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S7)=1,WEEKDAY(S7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T7)=1,WEEKDAY(T7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U7)=1,WEEKDAY(U7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V7)=1,WEEKDAY(V7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W7)=1,WEEKDAY(W7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X7)=1,WEEKDAY(X7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Y7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y7)=1,WEEKDAY(Y7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Z7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z7)=1,WEEKDAY(Z7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA7)=1,WEEKDAY(AA7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB7)=1,WEEKDAY(AB7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC7)=1,WEEKDAY(AC7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD7)=1,WEEKDAY(AD7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(AE7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE7)=1,WEEKDAY(AE7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AF7,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF7)=1,WEEKDAY(AF7)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$G2:$G2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG8=\"\",\"\",AG8*(Erfassung!$B$2/5)*SUM(Erfassung!G$2))","v":21},{"$f":"COUNT(B8:AF8,\"<0.1\")","v":20},{"$f":"SUM(B8:AF8)","v":168.00000000000006},"März"]
[null,{"$f":"AF7+1","v":"2024-04-01"},{"$f":"B9+1","v":45384},45385,45386,45387,45388,45389,45390,45391,45392,45393,45394,45395,45396,45397,45398,45399,45400,45401,45402,45403,45404,45405,45406,45407,45408,45409,45410,45411,45412,null,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG9=\"\",\"\",AG9*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["April",{"$f":"IF(ISNA(VLOOKUP(B9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B9)=1,WEEKDAY(B9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(C9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C9)=1,WEEKDAY(C9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D9)=1,WEEKDAY(D9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E9)=1,WEEKDAY(E9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F9)=1,WEEKDAY(F9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G9)=1,WEEKDAY(G9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(H9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H9)=1,WEEKDAY(H9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(I9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I9)=1,WEEKDAY(I9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J9)=1,WEEKDAY(J9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K9)=1,WEEKDAY(K9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L9)=1,WEEKDAY(L9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M9)=1,WEEKDAY(M9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N9)=1,WEEKDAY(N9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(O9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O9)=1,WEEKDAY(O9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(P9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P9)=1,WEEKDAY(P9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q9)=1,WEEKDAY(Q9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R9)=1,WEEKDAY(R9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S9)=1,WEEKDAY(S9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T9)=1,WEEKDAY(T9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U9)=1,WEEKDAY(U9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(V9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V9)=1,WEEKDAY(V9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(W9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W9)=1,WEEKDAY(W9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X9)=1,WEEKDAY(X9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y9)=1,WEEKDAY(Y9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z9)=1,WEEKDAY(Z9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA9)=1,WEEKDAY(AA9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB9)=1,WEEKDAY(AB9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AC9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC9)=1,WEEKDAY(AC9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AD9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD9)=1,WEEKDAY(AD9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE9)=1,WEEKDAY(AE9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF9,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF9)=1,WEEKDAY(AF9)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$H2:$H2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG10=\"\",\"\",AG10*(Erfassung!$B$2/5)*SUM(Erfassung!H$2))","v":21},{"$f":"COUNT(B10:AF10,\"<0.1\")","v":21},{"$f":"SUM(B10:AF10)","v":176.40000000000006},"April"]
[null,{"$f":"AE9+1","v":45413},{"$f":"B11+1","v":45414},45415,45416,45417,45418,45419,45420,45421,45422,45423,45424,45425,45426,45427,45428,45429,45430,45431,45432,45433,45434,45435,45436,45437,45438,45439,45440,45441,45442,45443,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG11=\"\",\"\",AG11*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["Mai",{"$f":"IF(ISNA(VLOOKUP(B11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B11)=1,WEEKDAY(B11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C11)=1,WEEKDAY(C11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D11)=1,WEEKDAY(D11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")*50%","v":4.2},{"$f":"IF(ISNA(VLOOKUP(E11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E11)=1,WEEKDAY(E11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(F11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F11)=1,WEEKDAY(F11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(G11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G11)=1,WEEKDAY(G11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H11)=1,WEEKDAY(H11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I11)=1,WEEKDAY(I11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J11)=1,WEEKDAY(J11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(K11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K11)=1,WEEKDAY(K11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L11)=1,WEEKDAY(L11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(M11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M11)=1,WEEKDAY(M11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(N11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N11)=1,WEEKDAY(N11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O11)=1,WEEKDAY(O11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P11)=1,WEEKDAY(P11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q11)=1,WEEKDAY(Q11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R11)=1,WEEKDAY(R11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S11)=1,WEEKDAY(S11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(T11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T11)=1,WEEKDAY(T11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(U11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U11)=1,WEEKDAY(U11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(V11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V11)=1,WEEKDAY(V11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W11)=1,WEEKDAY(W11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X11)=1,WEEKDAY(X11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y11)=1,WEEKDAY(Y11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z11)=1,WEEKDAY(Z11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AA11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA11)=1,WEEKDAY(AA11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AB11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB11)=1,WEEKDAY(AB11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC11)=1,WEEKDAY(AC11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD11)=1,WEEKDAY(AD11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE11)=1,WEEKDAY(AE11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF11,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF11)=1,WEEKDAY(AF11)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$I2:$I2)/5),\"F\")","v":8.4},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG12=\"\",\"\",AG12*(Erfassung!$B$2/5)*SUM(Erfassung!I$2))","v":21},{"$f":"COUNT(B12:AF12,\"<0.1\")","v":21},{"$f":"SUM(B12:AF12)","v":172.20000000000005},"Mai"]
[null,{"$f":"AF11+1","v":"2024-06-01"},{"$f":"B13+1","v":"2024-06-02"},"2024-06-03","2024-06-04","2024-06-05","2024-06-06","2024-06-07","2024-06-08","2024-06-09","2024-06-10","2024-06-11","2024-06-12","2024-06-13","2024-06-14","2024-06-15","2024-06-16","2024-06-17","2024-06-18","2024-06-19","2024-06-20","2024-06-21","2024-06-22","2024-06-23","2024-06-24","2024-06-25","2024-06-26","2024-06-27","2024-06-28","2024-06-29","2024-06-30",null,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG13=\"\",\"\",AG13*(Erfassung!$B$2/5)*SUM(Erfassung!I$2))","v":21}]
["Juni",{"$f":"IF(ISNA(VLOOKUP(B13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B13)=1,WEEKDAY(B13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(C13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C13)=1,WEEKDAY(C13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(D13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D13)=1,WEEKDAY(D13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E13)=1,WEEKDAY(E13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F13)=1,WEEKDAY(F13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G13)=1,WEEKDAY(G13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H13)=1,WEEKDAY(H13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I13)=1,WEEKDAY(I13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(J13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J13)=1,WEEKDAY(J13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(K13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K13)=1,WEEKDAY(K13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L13)=1,WEEKDAY(L13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M13)=1,WEEKDAY(M13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N13)=1,WEEKDAY(N13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O13)=1,WEEKDAY(O13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P13)=1,WEEKDAY(P13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Q13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q13)=1,WEEKDAY(Q13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(R13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R13)=1,WEEKDAY(R13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S13)=1,WEEKDAY(S13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T13)=1,WEEKDAY(T13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U13)=1,WEEKDAY(U13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V13)=1,WEEKDAY(V13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W13)=1,WEEKDAY(W13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(X13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X13)=1,WEEKDAY(X13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Y13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y13)=1,WEEKDAY(Y13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z13)=1,WEEKDAY(Z13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA13)=1,WEEKDAY(AA13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB13)=1,WEEKDAY(AB13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC13)=1,WEEKDAY(AC13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD13)=1,WEEKDAY(AD13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AE13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE13)=1,WEEKDAY(AE13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AF13,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF13)=1,WEEKDAY(AF13)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$J2:$J2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG14=\"\",\"\",AG14*(Erfassung!$B$2/5)*SUM(Erfassung!I$2))","v":21},{"$f":"COUNT(B14:AF14,\"<0.1\")","v":20},{"$f":"SUM(B14:AF14)","v":168.00000000000006},"Juni"]
[null,{"$f":"AE13+1","v":"2024-07-01"},{"$f":"B15+1","v":45475},45476,45477,45478,45479,45480,45481,45482,45483,45484,45485,45486,45487,45488,45489,45490,45491,45492,45493,45494,45495,45496,45497,45498,45499,45500,45501,45502,45503,45504,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG15=\"\",\"\",AG15*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["Juli",{"$f":"IF(ISNA(VLOOKUP(B15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B15)=1,WEEKDAY(B15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C15)=1,WEEKDAY(C15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D15)=1,WEEKDAY(D15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E15)=1,WEEKDAY(E15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F15)=1,WEEKDAY(F15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G15)=1,WEEKDAY(G15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(H15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H15)=1,WEEKDAY(H15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(I15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I15)=1,WEEKDAY(I15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J15)=1,WEEKDAY(J15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K15)=1,WEEKDAY(K15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L15)=1,WEEKDAY(L15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M15)=1,WEEKDAY(M15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N15)=1,WEEKDAY(N15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(O15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O15)=1,WEEKDAY(O15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(P15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P15)=1,WEEKDAY(P15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q15)=1,WEEKDAY(Q15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R15)=1,WEEKDAY(R15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S15)=1,WEEKDAY(S15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T15)=1,WEEKDAY(T15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U15)=1,WEEKDAY(U15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(V15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V15)=1,WEEKDAY(V15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(W15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W15)=1,WEEKDAY(W15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X15)=1,WEEKDAY(X15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y15)=1,WEEKDAY(Y15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z15)=1,WEEKDAY(Z15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA15)=1,WEEKDAY(AA15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB15)=1,WEEKDAY(AB15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AC15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC15)=1,WEEKDAY(AC15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AD15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD15)=1,WEEKDAY(AD15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE15)=1,WEEKDAY(AE15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF15,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF15)=1,WEEKDAY(AF15)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$K2:$K2)/5),\"F\")","v":8.4},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG16=\"\",\"\",AG16*(Erfassung!$B$2/5)*SUM(Erfassung!K$2))","v":21},{"$f":"COUNT(B16:AF16,\"<0.1\")","v":23},{"$f":"SUM(B16:AF16)","v":193.20000000000007},"Juli"]
[null,{"$f":"AF15+1","v":"2024-08-01"},{"$f":"B17+1","v":45506},45507,45508,45509,45510,45511,45512,45513,45514,45515,45516,45517,45518,45519,45520,45521,45522,45523,45524,45525,45526,45527,45528,45529,45530,45531,45532,45533,45534,45535,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG17=\"\",\"\",AG17*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["August",{"$f":"IF(ISNA(VLOOKUP(B17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B17)=1,WEEKDAY(B17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(C17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C17)=1,WEEKDAY(C17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D17)=1,WEEKDAY(D17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E17)=1,WEEKDAY(E17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(F17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F17)=1,WEEKDAY(F17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G17)=1,WEEKDAY(G17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H17)=1,WEEKDAY(H17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I17)=1,WEEKDAY(I17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J17)=1,WEEKDAY(J17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K17)=1,WEEKDAY(K17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(L17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L17)=1,WEEKDAY(L17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(M17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M17)=1,WEEKDAY(M17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N17)=1,WEEKDAY(N17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O17)=1,WEEKDAY(O17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P17)=1,WEEKDAY(P17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q17)=1,WEEKDAY(Q17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R17)=1,WEEKDAY(R17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(S17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S17)=1,WEEKDAY(S17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(T17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T17)=1,WEEKDAY(T17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U17)=1,WEEKDAY(U17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V17)=1,WEEKDAY(V17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W17)=1,WEEKDAY(W17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X17)=1,WEEKDAY(X17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y17)=1,WEEKDAY(Y17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Z17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z17)=1,WEEKDAY(Z17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AA17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA17)=1,WEEKDAY(AA17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB17)=1,WEEKDAY(AB17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC17)=1,WEEKDAY(AC17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD17)=1,WEEKDAY(AD17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE17)=1,WEEKDAY(AE17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF17,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF17)=1,WEEKDAY(AF17)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$L2:$L2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG18=\"\",\"\",AG18*(Erfassung!$B$2/5)*SUM(Erfassung!L$2))","v":21},{"$f":"COUNT(B18:AF18,\"<0.1\")","v":21},{"$f":"SUM(B18:AF18)","v":176.40000000000006},"August"]
[null,{"$f":"AF17+1","v":45536},{"$f":"B19+1","v":45537},45538,45539,45540,45541,45542,45543,45544,45545,45546,45547,45548,45549,45550,45551,45552,45553,45554,45555,45556,45557,45558,45559,45560,45561,45562,45563,45564,45565,null,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG19=\"\",\"\",AG19*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["September",{"$f":"IF(ISNA(VLOOKUP(B19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B19)=1,WEEKDAY(B19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(C19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C19)=1,WEEKDAY(C19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D19)=1,WEEKDAY(D19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E19)=1,WEEKDAY(E19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F19)=1,WEEKDAY(F19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G19)=1,WEEKDAY(G19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H19)=1,WEEKDAY(H19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(I19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I19)=1,WEEKDAY(I19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(J19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J19)=1,WEEKDAY(J19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K19)=1,WEEKDAY(K19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L19)=1,WEEKDAY(L19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M19)=1,WEEKDAY(M19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N19)=1,WEEKDAY(N19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O19)=1,WEEKDAY(O19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(P19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P19)=1,WEEKDAY(P19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Q19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q19)=1,WEEKDAY(Q19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R19)=1,WEEKDAY(R19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S19)=1,WEEKDAY(S19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T19)=1,WEEKDAY(T19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U19)=1,WEEKDAY(U19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V19)=1,WEEKDAY(V19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(W19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W19)=1,WEEKDAY(W19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(X19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X19)=1,WEEKDAY(X19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y19)=1,WEEKDAY(Y19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z19)=1,WEEKDAY(Z19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA19)=1,WEEKDAY(AA19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB19)=1,WEEKDAY(AB19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC19)=1,WEEKDAY(AC19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AD19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD19)=1,WEEKDAY(AD19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AE19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE19)=1,WEEKDAY(AE19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF19,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF19)=1,WEEKDAY(AF19)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$M2:$M2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG20=\"\",\"\",AG20*(Erfassung!$B$2/5)*SUM(Erfassung!M$2))","v":21},{"$f":"COUNT(B20:AF20,\"<0.1\")","v":21},{"$f":"SUM(B20:AF20)","v":176.40000000000006},"September"]
[null,{"$f":"AE19+1","v":"2024-10-01"},{"$f":"B21+1","v":"2024-10-02"},"2024-10-03","2024-10-04","2024-10-05","2024-10-06","2024-10-07","2024-10-08","2024-10-09","2024-10-10","2024-10-11","2024-10-12","2024-10-13","2024-10-14","2024-10-15","2024-10-16","2024-10-17","2024-10-18","2024-10-19","2024-10-20","2024-10-21","2024-10-22","2024-10-23","2024-10-24","2024-10-25","2024-10-26","2024-10-27","2024-10-28","2024-10-29","2024-10-30","2024-10-31",{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG21=\"\",\"\",AG21*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["Oktober",{"$f":"IF(ISNA(VLOOKUP(B21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B21)=1,WEEKDAY(B21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C21)=1,WEEKDAY(C21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D21)=1,WEEKDAY(D21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E21)=1,WEEKDAY(E21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F21)=1,WEEKDAY(F21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(G21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G21)=1,WEEKDAY(G21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(H21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H21)=1,WEEKDAY(H21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I21)=1,WEEKDAY(I21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J21)=1,WEEKDAY(J21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K21)=1,WEEKDAY(K21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L21)=1,WEEKDAY(L21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M21)=1,WEEKDAY(M21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(N21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N21)=1,WEEKDAY(N21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(O21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O21)=1,WEEKDAY(O21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P21)=1,WEEKDAY(P21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q21)=1,WEEKDAY(Q21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R21)=1,WEEKDAY(R21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S21)=1,WEEKDAY(S21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T21)=1,WEEKDAY(T21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(U21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U21)=1,WEEKDAY(U21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(V21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V21)=1,WEEKDAY(V21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W21)=1,WEEKDAY(W21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X21)=1,WEEKDAY(X21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y21)=1,WEEKDAY(Y21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z21)=1,WEEKDAY(Z21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA21)=1,WEEKDAY(AA21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AB21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB21)=1,WEEKDAY(AB21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AC21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC21)=1,WEEKDAY(AC21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD21)=1,WEEKDAY(AD21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE21)=1,WEEKDAY(AE21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF21,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF21)=1,WEEKDAY(AF21)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$N2:$N2)/5),\"F\")","v":8.4},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG22=\"\",\"\",AG22*(Erfassung!$B$2/5)*SUM(Erfassung!N$2))","v":21},{"$f":"COUNT(B22:AF22,\"<0.1\")","v":23},{"$f":"SUM(B22:AF22)","v":193.20000000000007},"Oktober"]
[null,{"$f":"AF21+1","v":"2024-11-01"},{"$f":"B23+1","v":45598},45599,45600,45601,45602,45603,45604,45605,45606,45607,45608,45609,45610,45611,45612,45613,45614,45615,45616,45617,45618,45619,45620,45621,45622,45623,45624,45625,45626,null,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG23=\"\",\"\",AG23*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["November",{"$f":"IF(ISNA(VLOOKUP(B23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B23)=1,WEEKDAY(B23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(C23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C23)=1,WEEKDAY(C23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(D23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D23)=1,WEEKDAY(D23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(E23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E23)=1,WEEKDAY(E23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F23)=1,WEEKDAY(F23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G23)=1,WEEKDAY(G23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H23)=1,WEEKDAY(H23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(I23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I23)=1,WEEKDAY(I23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(J23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J23)=1,WEEKDAY(J23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(K23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K23)=1,WEEKDAY(K23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(L23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L23)=1,WEEKDAY(L23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M23)=1,WEEKDAY(M23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N23)=1,WEEKDAY(N23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O23)=1,WEEKDAY(O23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(P23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P23)=1,WEEKDAY(P23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Q23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q23)=1,WEEKDAY(Q23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(R23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R23)=1,WEEKDAY(R23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(S23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S23)=1,WEEKDAY(S23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T23)=1,WEEKDAY(T23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U23)=1,WEEKDAY(U23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V23)=1,WEEKDAY(V23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(W23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W23)=1,WEEKDAY(W23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(X23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X23)=1,WEEKDAY(X23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Y23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y23)=1,WEEKDAY(Y23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Z23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z23)=1,WEEKDAY(Z23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AA23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA23)=1,WEEKDAY(AA23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AB23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB23)=1,WEEKDAY(AB23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC23)=1,WEEKDAY(AC23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AD23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD23)=1,WEEKDAY(AD23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AE23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE23)=1,WEEKDAY(AE23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AF23,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF23)=1,WEEKDAY(AF23)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$O2:$O2)/5),\"F\")","v":""},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG24=\"\",\"\",AG24*(Erfassung!$B$2/5)*SUM(Erfassung!O$2))","v":21},{"$f":"COUNT(B24:AF24,\"<0.1\")","v":21},{"$f":"SUM(B24:AF24)","v":176.40000000000006},"November"]
[null,{"$f":"AE23+1","v":"2024-12-01"},{"$f":"B25+1","v":45628},45629,45630,45631,45632,45633,45634,45635,45636,45637,45638,45639,45640,45641,45642,45643,45644,45645,45646,45647,45648,45649,45650,45651,45652,45653,45654,45655,45656,45657,{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG25=\"\",\"\",AG25*(Erfassung!$B$2/5)*SUM(Erfassung!E$2))","v":21}]
["Dezbember",{"$f":"IF(ISNA(VLOOKUP(B25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(B25)=1,WEEKDAY(B25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(C25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(C25)=1,WEEKDAY(C25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(D25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(D25)=1,WEEKDAY(D25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(E25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(E25)=1,WEEKDAY(E25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(F25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(F25)=1,WEEKDAY(F25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(G25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(G25)=1,WEEKDAY(G25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(H25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(H25)=1,WEEKDAY(H25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(I25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(I25)=1,WEEKDAY(I25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(J25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(J25)=1,WEEKDAY(J25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(K25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(K25)=1,WEEKDAY(K25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(L25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(L25)=1,WEEKDAY(L25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(M25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(M25)=1,WEEKDAY(M25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(N25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(N25)=1,WEEKDAY(N25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(O25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(O25)=1,WEEKDAY(O25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(P25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(P25)=1,WEEKDAY(P25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(Q25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Q25)=1,WEEKDAY(Q25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(R25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(R25)=1,WEEKDAY(R25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(S25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(S25)=1,WEEKDAY(S25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(T25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(T25)=1,WEEKDAY(T25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(U25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(U25)=1,WEEKDAY(U25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(V25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(V25)=1,WEEKDAY(V25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(W25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(W25)=1,WEEKDAY(W25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(X25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(X25)=1,WEEKDAY(X25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Y25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Y25)=1,WEEKDAY(Y25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(Z25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(Z25)=1,WEEKDAY(Z25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(AA25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AA25)=1,WEEKDAY(AA25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":"F"},{"$f":"IF(ISNA(VLOOKUP(AB25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AB25)=1,WEEKDAY(AB25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AC25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AC25)=1,WEEKDAY(AC25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AD25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AD25)=1,WEEKDAY(AD25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":""},{"$f":"IF(ISNA(VLOOKUP(AE25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AE25)=1,WEEKDAY(AE25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"IF(ISNA(VLOOKUP(AF25,Feiertage!$A:$C,3,FALSE)),IF(OR(WEEKDAY(AF25)=1,WEEKDAY(AF25)=7),\"\",Erfassung!$B$2*SUM(Erfassung!$P2:$P2)/5),\"F\")","v":8.4},{"$f":"Erfassung!$D$2/12","v":2.5},{"$f":"IF(AG26=\"\",\"\",AG26*(Erfassung!$B$2/5)*SUM(Erfassung!P$2))","v":21},{"$f":"COUNT(B26:AF26,\"<0.1\")","v":20},{"$f":"SUM(B26:AF26)","v":168.00000000000006},"Dezember"]
[]
["Legende:",null,"Ferien",null,null,null,"Arbeitstage",null,null,null,"Wochenende",null,null,"F","Feiertage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Arbeitstage Jahr:",{"$f":"SUM(AI4,AI6,AI8,AI10,AI12,AI14,AI16,AI18,AI20,AI22,AI24,AI26)","v":253}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferien",{"$f":"SUM(AH4,AH6,AH8,AH10,AH12,AH14,AH16,AH18,AH20,AH22,AH24,AH26)","v":252}]
[null,null,null,null,null,null,null,null,null,null,null,"Die roten Resultate unter ","http://sk-app.ch/WorkingHours?page=1",null,null,null,null,null,null,"im sk-app erfassen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahresarbeitszeit:",{"$f":"SUM(AJ4,AJ6,AJ8,AJ10,AJ12,AJ14,AJ16,AJ18,AJ20,AJ22,AJ24,AJ26)","v":2121.0000000000009}]