{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Arbeitsplan Woche {wochenr}","Kontaktdaten Mitarbeiter","Parameter"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Arbeitsplan Woche {wochenr}","index":0,"n_rows":32,"n_cols":88,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,86],[1,0,1,86],[3,1,3,17],[3,18,3,34],[7,11,7,17],[3,69,3,85],[3,35,3,51],[3,52,3,68],[7,28,7,34],[7,45,7,51],[7,62,7,68],[7,79,7,85]]}
["Arbeitsplan {kitaName}"]
["{kalenderwoche}"]
[]
["Mitarbeiter","Montag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dienstag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mittwoch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Donnerstag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freitag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"{repeatGroup:22}"]
[]
["{gruppenname}"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Belegung: \" &B9&\"/\"&C9&\"/\"&D9","v":"Belegung: {belegungMontag}/{belegungMontag}/{belegungMontag}"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Belegung: \" &S9&\"/\"&T9&\"/\"&U9","v":"Belegung: {belegungDienstag}/{belegungDienstag}/{belegungDienstag}"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Belegung: \" &AJ9&\"/\"&AK9&\"/\"&AL9","v":"Belegung: {belegungMittwoch}/{belegungMittwoch}/{belegungMittwoch}"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Belegung: \" &BA9&\"/\"&BB9&\"/\"&BC9","v":"Belegung: {belegungDonnerstag}/{belegungDonnerstag}/{belegungDonnerstag}"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Belegung: \" &BR9&\"/\"&BS9&\"/\"&BT9","v":"Belegung: {belegungFreitag}/{belegungFreitag}/{belegungFreitag}"}]
["Schicht","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","{belegungMontag}","FD 1","FD 2","VM","M","NM","SD 1","SD 2","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","{belegungDienstag}","FD 1","FD 2","VM","M","NM","SD 1","SD 2","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","{belegungMittwoch}","FD 1","FD 2","VM","M","NM","SD 1","SD 2","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","{belegungDonnerstag}","FD 1","FD 2","VM","M","NM","SD 1","SD 2","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","{belegungFreitag}","FD 1","FD 2","VM","M","NM","SD 1","SD 2"]
["von",null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337]
["bis",null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663,null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663,null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663,null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663,null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663]
["Zeit",null,null,null,null,null,null,null,null,null,null,{"$f":"L11-L10","v":"00:45:00"},{"$f":"M11-M10","v":"00:30:00"},{"$f":"N11-N10","v":"03:30:00"},{"$f":"O11-O10","v":"02:30:00"},{"$f":"P11-P10","v":"02:30:00"},{"$f":"Q11-Q10","v":"01:15:00"},{"$f":"R11-R10","v":"00:30:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"AC11-AC10","v":"00:45:00"},{"$f":"AD11-AD10","v":"00:30:00"},{"$f":"AE11-AE10","v":"03:30:00"},{"$f":"AF11-AF10","v":"02:30:00"},{"$f":"AG11-AG10","v":"02:30:00"},{"$f":"AH11-AH10","v":"01:15:00"},{"$f":"AI11-AI10","v":"00:30:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"AT11-AT10","v":"00:45:00"},{"$f":"AU11-AU10","v":"00:30:00"},{"$f":"AV11-AV10","v":"03:30:00"},{"$f":"AW11-AW10","v":"02:30:00"},{"$f":"AX11-AX10","v":"02:30:00"},{"$f":"AY11-AY10","v":"01:15:00"},{"$f":"AZ11-AZ10","v":"00:30:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"BK11-BK10","v":"00:45:00"},{"$f":"BL11-BL10","v":"00:30:00"},{"$f":"BM11-BM10","v":"03:30:00"},{"$f":"BN11-BN10","v":"02:30:00"},{"$f":"BO11-BO10","v":"02:30:00"},{"$f":"BP11-BP10","v":"01:15:00"},{"$f":"BQ11-BQ10","v":"00:30:00"},null,null,null,null,null,null,null,null,null,null,{"$f":"CB11-CB10","v":"00:45:00"},{"$f":"CC11-CC10","v":"00:30:00"},{"$f":"CD11-CD10","v":"03:30:00"},{"$f":"CE11-CE10","v":"02:30:00"},{"$f":"CF11-CF10","v":"02:30:00"},{"$f":"CG11-CG10","v":"01:15:00"},{"$f":"CH11-CH10","v":"00:30:00"}]
["Ausgebildet",{"$f":"IF(B9=0,0,IF(B9<=12,1,IF(B9<=18,2,IF(B9<=24,2,IF(B9<=30,3,IF(B9<=36,3,4))))))","v":4},{"$f":"IF(C9=0,0,IF(C9<=12,1,IF(C9<=18,2,IF(C9<=24,2,IF(C9<=30,3,IF(C9<=36,3,4))))))","v":4},4,4,4,4,4,4,4,4,{"$f":"ROUND(IF(B13=0,0,MAX(B13/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(B13=0,0,MAX(B13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(B13,0)","v":4},{"$f":"ROUND(C13,0)","v":4},{"$f":"ROUND(D13,0)","v":4},{"$f":"ROUND(IF(D13=0,0,MAX(D13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(IF(D13=0,0,MAX(D13/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(S9=0,0,IF(S9<=12,1,IF(S9<=18,2,IF(S9<=24,2,IF(S9<=30,3,IF(S9<=36,3,4))))))","v":4},{"$f":"IF(T9=0,0,IF(T9<=12,1,IF(T9<=18,2,IF(T9<=24,2,IF(T9<=30,3,IF(T9<=36,3,4))))))","v":4},4,4,4,4,4,4,4,4,{"$f":"ROUND(IF(S13=0,0,MAX(S13/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(S13=0,0,MAX(S13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(S13,0)","v":4},{"$f":"ROUND(T13,0)","v":4},{"$f":"ROUND(U13,0)","v":4},{"$f":"ROUND(IF(U13=0,0,MAX(U13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(IF(U13=0,0,MAX(U13/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(AJ9=0,0,IF(AJ9<=12,1,IF(AJ9<=18,2,IF(AJ9<=24,2,IF(AJ9<=30,3,IF(AJ9<=36,3,4))))))","v":4},{"$f":"IF(AK9=0,0,IF(AK9<=12,1,IF(AK9<=18,2,IF(AK9<=24,2,IF(AK9<=30,3,IF(AK9<=36,3,4))))))","v":4},4,4,4,4,4,4,4,4,{"$f":"ROUND(IF(AJ13=0,0,MAX(AJ13/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(AJ13=0,0,MAX(AJ13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(AJ13,0)","v":4},{"$f":"ROUND(AK13,0)","v":4},{"$f":"ROUND(AL13,0)","v":4},{"$f":"ROUND(IF(AL13=0,0,MAX(AL13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(IF(AL13=0,0,MAX(AL13/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(BA9=0,0,IF(BA9<=12,1,IF(BA9<=18,2,IF(BA9<=24,2,IF(BA9<=30,3,IF(BA9<=36,3,4))))))","v":4},{"$f":"IF(BB9=0,0,IF(BB9<=12,1,IF(BB9<=18,2,IF(BB9<=24,2,IF(BB9<=30,3,IF(BB9<=36,3,4))))))","v":4},4,4,4,4,4,4,4,4,{"$f":"ROUND(IF(BA13=0,0,MAX(BA13/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(BA13=0,0,MAX(BA13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(BA13,0)","v":4},{"$f":"ROUND(BB13,0)","v":4},{"$f":"ROUND(BC13,0)","v":4},{"$f":"ROUND(IF(BC13=0,0,MAX(BC13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(IF(BC13=0,0,MAX(BC13/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(BR9=0,0,IF(BR9<=12,1,IF(BR9<=18,2,IF(BR9<=24,2,IF(BR9<=30,3,IF(BR9<=36,3,4))))))","v":4},{"$f":"IF(BS9=0,0,IF(BS9<=12,1,IF(BS9<=18,2,IF(BS9<=24,2,IF(BS9<=30,3,IF(BS9<=36,3,4))))))","v":4},4,4,4,4,4,4,4,4,{"$f":"ROUND(IF(BR13=0,0,MAX(BR13/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(BR13=0,0,MAX(BR13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(BR13,0)","v":4},{"$f":"ROUND(BS13,0)","v":4},{"$f":"ROUND(BT13,0)","v":4},{"$f":"ROUND(IF(BT13=0,0,MAX(BT13/Parameter!$B$3*2,1)),0)","v":3},{"$f":"ROUND(IF(BT13=0,0,MAX(BT13/Parameter!$B$4,1)),0)","v":1},"Total h"]
["Ist",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(L15:L18,\"X\")","v":0},2,3,3,3,3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AC15:AC18,\"X\")","v":0},2,3,3,3,3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AT15:AT18,\"X\")","v":0},2,3,3,3,3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(BK15:BK18,\"X\")","v":0},2,3,3,3,3,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(CB15:CB18,\"X\")","v":0},2,3,3,3,3,1]
["Andrea",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",{"$f":"SUM(COUNTIF(L15,\"x\")*L$12,COUNTIF(M15,\"x\")*M$12,COUNTIF(N15,\"x\")*N$12,COUNTIF(O15,\"x\")*O$12,COUNTIF(P15,\"x\")*P$12,COUNTIF(Q15,\"x\")*Q$12,COUNTIF(R15,\"x\")*R$12,COUNTIF(AC15,\"x\")*AC$12,COUNTIF(AD15,\"x\")*AD$12,COUNTIF(AE15,\"x\")*AE$12,COUNTIF(AF15,\"x\")*AF$12,COUNTIF(AG15,\"x\")*AG$12,COUNTIF(AH15,\"x\")*AH$12,COUNTIF(AI15,\"x\")*AI$12,COUNTIF(AT15,\"x\")*AT$12,COUNTIF(AU15,\"x\")*AU$12,COUNTIF(AV15,\"x\")*AV$12,COUNTIF(AW15,\"x\")*AW$12,COUNTIF(AX15,\"x\")*AX$12,COUNTIF(AY15,\"x\")*AY$12,COUNTIF(AZ15,\"x\")*AZ$12,COUNTIF(BK15,\"x\")*BK$12,COUNTIF(BL15,\"x\")*BL$12,COUNTIF(BM15,\"x\")*BM$12,COUNTIF(BN15,\"x\")*BN$12,COUNTIF(BO15,\"x\")*BO$12,COUNTIF(BP15,\"x\")*BP$12,COUNTIF(BQ15,\"x\")*BQ$12,COUNTIF(CB15,\"x\")*CB$12,COUNTIF(CC15,\"x\")*CC$12,COUNTIF(CD15,\"x\")*CD$12,COUNTIF(CE15,\"x\")*CE$12,COUNTIF(CF15,\"x\")*CF$12,COUNTIF(CG15,\"x\")*CG$12,COUNTIF(CH15,\"x\")*CH$12)","v":2.135416666666667}]
["Bea",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,{"$f":"SUM(COUNTIF(L16,\"x\")*L$12,COUNTIF(M16,\"x\")*M$12,COUNTIF(N16,\"x\")*N$12,COUNTIF(O16,\"x\")*O$12,COUNTIF(P16,\"x\")*P$12,COUNTIF(Q16,\"x\")*Q$12,COUNTIF(R16,\"x\")*R$12,COUNTIF(AC16,\"x\")*AC$12,COUNTIF(AD16,\"x\")*AD$12,COUNTIF(AE16,\"x\")*AE$12,COUNTIF(AF16,\"x\")*AF$12,COUNTIF(AG16,\"x\")*AG$12,COUNTIF(AH16,\"x\")*AH$12,COUNTIF(AI16,\"x\")*AI$12,COUNTIF(AT16,\"x\")*AT$12,COUNTIF(AU16,\"x\")*AU$12,COUNTIF(AV16,\"x\")*AV$12,COUNTIF(AW16,\"x\")*AW$12,COUNTIF(AX16,\"x\")*AX$12,COUNTIF(AY16,\"x\")*AY$12,COUNTIF(AZ16,\"x\")*AZ$12,COUNTIF(BK16,\"x\")*BK$12,COUNTIF(BL16,\"x\")*BL$12,COUNTIF(BM16,\"x\")*BM$12,COUNTIF(BN16,\"x\")*BN$12,COUNTIF(BO16,\"x\")*BO$12,COUNTIF(BP16,\"x\")*BP$12,COUNTIF(BQ16,\"x\")*BQ$12,COUNTIF(CB16,\"x\")*CB$12,COUNTIF(CC16,\"x\")*CC$12,COUNTIF(CD16,\"x\")*CD$12,COUNTIF(CE16,\"x\")*CE$12,COUNTIF(CF16,\"x\")*CF$12,COUNTIF(CG16,\"x\")*CG$12,COUNTIF(CH16,\"x\")*CH$12)","v":2.1354166666666674}]
["Christine",null,null,null,null,null,null,null,null,null,null,"K","K","K","K","K","K","K",null,null,null,null,null,null,null,null,null,null,"K","K","K","K","K","K","K",null,null,null,null,null,null,null,null,null,null,"K","K","K","K","K","K","K",null,null,null,null,null,null,null,null,null,null,"K","K","K","K","K","K","K",null,null,null,null,null,null,null,null,null,null,"K","K","K","K","K","K","K",{"$f":"SUM(COUNTIF(L17,\"x\")*L$12,COUNTIF(M17,\"x\")*M$12,COUNTIF(N17,\"x\")*N$12,COUNTIF(O17,\"x\")*O$12,COUNTIF(P17,\"x\")*P$12,COUNTIF(Q17,\"x\")*Q$12,COUNTIF(R17,\"x\")*R$12,COUNTIF(AC17,\"x\")*AC$12,COUNTIF(AD17,\"x\")*AD$12,COUNTIF(AE17,\"x\")*AE$12,COUNTIF(AF17,\"x\")*AF$12,COUNTIF(AG17,\"x\")*AG$12,COUNTIF(AH17,\"x\")*AH$12,COUNTIF(AI17,\"x\")*AI$12,COUNTIF(AT17,\"x\")*AT$12,COUNTIF(AU17,\"x\")*AU$12,COUNTIF(AV17,\"x\")*AV$12,COUNTIF(AW17,\"x\")*AW$12,COUNTIF(AX17,\"x\")*AX$12,COUNTIF(AY17,\"x\")*AY$12,COUNTIF(AZ17,\"x\")*AZ$12,COUNTIF(BK17,\"x\")*BK$12,COUNTIF(BL17,\"x\")*BL$12,COUNTIF(BM17,\"x\")*BM$12,COUNTIF(BN17,\"x\")*BN$12,COUNTIF(BO17,\"x\")*BO$12,COUNTIF(BP17,\"x\")*BP$12,COUNTIF(BQ17,\"x\")*BQ$12,COUNTIF(CB17,\"x\")*CB$12,COUNTIF(CC17,\"x\")*CC$12,COUNTIF(CD17,\"x\")*CD$12,COUNTIF(CE17,\"x\")*CE$12,COUNTIF(CF17,\"x\")*CF$12,COUNTIF(CG17,\"x\")*CG$12,COUNTIF(CH17,\"x\")*CH$12)","v":0}]
["Daniela",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,{"$f":"SUM(COUNTIF(L18,\"x\")*L$12,COUNTIF(M18,\"x\")*M$12,COUNTIF(N18,\"x\")*N$12,COUNTIF(O18,\"x\")*O$12,COUNTIF(P18,\"x\")*P$12,COUNTIF(Q18,\"x\")*Q$12,COUNTIF(R18,\"x\")*R$12,COUNTIF(AC18,\"x\")*AC$12,COUNTIF(AD18,\"x\")*AD$12,COUNTIF(AE18,\"x\")*AE$12,COUNTIF(AF18,\"x\")*AF$12,COUNTIF(AG18,\"x\")*AG$12,COUNTIF(AH18,\"x\")*AH$12,COUNTIF(AI18,\"x\")*AI$12,COUNTIF(AT18,\"x\")*AT$12,COUNTIF(AU18,\"x\")*AU$12,COUNTIF(AV18,\"x\")*AV$12,COUNTIF(AW18,\"x\")*AW$12,COUNTIF(AX18,\"x\")*AX$12,COUNTIF(AY18,\"x\")*AY$12,COUNTIF(AZ18,\"x\")*AZ$12,COUNTIF(BK18,\"x\")*BK$12,COUNTIF(BL18,\"x\")*BL$12,COUNTIF(BM18,\"x\")*BM$12,COUNTIF(BN18,\"x\")*BN$12,COUNTIF(BO18,\"x\")*BO$12,COUNTIF(BP18,\"x\")*BP$12,COUNTIF(BQ18,\"x\")*BQ$12,COUNTIF(CB18,\"x\")*CB$12,COUNTIF(CC18,\"x\")*CC$12,COUNTIF(CD18,\"x\")*CD$12,COUNTIF(CE18,\"x\")*CE$12,COUNTIF(CF18,\"x\")*CF$12,COUNTIF(CG18,\"x\")*CG$12,COUNTIF(CH18,\"x\")*CH$12)","v":2.1354166666666674}]
["…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(COUNTIF(L19,\"x\")*L$12,COUNTIF(M19,\"x\")*M$12,COUNTIF(N19,\"x\")*N$12,COUNTIF(O19,\"x\")*O$12,COUNTIF(P19,\"x\")*P$12,COUNTIF(Q19,\"x\")*Q$12,COUNTIF(R19,\"x\")*R$12,COUNTIF(AC19,\"x\")*AC$12,COUNTIF(AD19,\"x\")*AD$12,COUNTIF(AE19,\"x\")*AE$12,COUNTIF(AF19,\"x\")*AF$12,COUNTIF(AG19,\"x\")*AG$12,COUNTIF(AH19,\"x\")*AH$12,COUNTIF(AI19,\"x\")*AI$12,COUNTIF(AT19,\"x\")*AT$12,COUNTIF(AU19,\"x\")*AU$12,COUNTIF(AV19,\"x\")*AV$12,COUNTIF(AW19,\"x\")*AW$12,COUNTIF(AX19,\"x\")*AX$12,COUNTIF(AY19,\"x\")*AY$12,COUNTIF(AZ19,\"x\")*AZ$12,COUNTIF(BK19,\"x\")*BK$12,COUNTIF(BL19,\"x\")*BL$12,COUNTIF(BM19,\"x\")*BM$12,COUNTIF(BN19,\"x\")*BN$12,COUNTIF(BO19,\"x\")*BO$12,COUNTIF(BP19,\"x\")*BP$12,COUNTIF(BQ19,\"x\")*BQ$12,COUNTIF(CB19,\"x\")*CB$12,COUNTIF(CC19,\"x\")*CC$12,COUNTIF(CD19,\"x\")*CD$12,COUNTIF(CE19,\"x\")*CE$12,COUNTIF(CF19,\"x\")*CF$12,COUNTIF(CG19,\"x\")*CG$12,COUNTIF(CH19,\"x\")*CH$12)","v":0}]
["nicht Ausgebildet",{"$f":"IF(B9=0,0,IF(B9<=12,1,IF(B9<=18,1,IF(B9<=24,2,IF(B9<=30,2,IF(B9<=36,3,3))))))","v":3},{"$f":"IF(C9=0,0,IF(C9<=12,1,IF(C9<=18,1,IF(C9<=24,2,IF(C9<=30,2,IF(C9<=36,3,3))))))","v":3},3,3,3,3,3,3,3,3,{"$f":"ROUND(IF(B20=0,0,MAX(B20/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(B20=0,0,MAX(B20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(B20,0)","v":3},{"$f":"ROUND(C20,0)","v":3},{"$f":"ROUND(D20,0)","v":3},{"$f":"ROUND(IF(D20=0,0,MAX(D20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(IF(D20=0,0,MAX(D20/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(S9=0,0,IF(S9<=12,1,IF(S9<=18,1,IF(S9<=24,2,IF(S9<=30,2,IF(S9<=36,3,3))))))","v":3},{"$f":"IF(T9=0,0,IF(T9<=12,1,IF(T9<=18,1,IF(T9<=24,2,IF(T9<=30,2,IF(T9<=36,3,3))))))","v":3},3,3,3,3,3,3,3,3,{"$f":"ROUND(IF(S20=0,0,MAX(S20/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(S20=0,0,MAX(S20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(S20,0)","v":3},{"$f":"ROUND(T20,0)","v":3},{"$f":"ROUND(U20,0)","v":3},{"$f":"ROUND(IF(U20=0,0,MAX(U20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(IF(U20=0,0,MAX(U20/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(AJ9=0,0,IF(AJ9<=12,1,IF(AJ9<=18,1,IF(AJ9<=24,2,IF(AJ9<=30,2,IF(AJ9<=36,3,3))))))","v":3},{"$f":"IF(AK9=0,0,IF(AK9<=12,1,IF(AK9<=18,1,IF(AK9<=24,2,IF(AK9<=30,2,IF(AK9<=36,3,3))))))","v":3},3,3,3,3,3,3,3,3,{"$f":"ROUND(IF(AJ20=0,0,MAX(AJ20/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(AJ20=0,0,MAX(AJ20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(AJ20,0)","v":3},{"$f":"ROUND(AK20,0)","v":3},{"$f":"ROUND(AL20,0)","v":3},{"$f":"ROUND(IF(AL20=0,0,MAX(AL20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(IF(AL20=0,0,MAX(AL20/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(BA9=0,0,IF(BA9<=12,1,IF(BA9<=18,1,IF(BA9<=24,2,IF(BA9<=30,2,IF(BA9<=36,3,3))))))","v":3},{"$f":"IF(BB9=0,0,IF(BB9<=12,1,IF(BB9<=18,1,IF(BB9<=24,2,IF(BB9<=30,2,IF(BB9<=36,3,3))))))","v":3},3,3,3,3,3,3,3,3,{"$f":"ROUND(IF(BA20=0,0,MAX(BA20/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(BA20=0,0,MAX(BA20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(BA20,0)","v":3},{"$f":"ROUND(BB20,0)","v":3},{"$f":"ROUND(BC20,0)","v":3},{"$f":"ROUND(IF(BC20=0,0,MAX(BC20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(IF(BC20=0,0,MAX(BC20/Parameter!$B$4,1)),0)","v":1},{"$f":"IF(BR9=0,0,IF(BR9<=12,1,IF(BR9<=18,1,IF(BR9<=24,2,IF(BR9<=30,2,IF(BR9<=36,3,3))))))","v":3},{"$f":"IF(BS9=0,0,IF(BS9<=12,1,IF(BS9<=18,1,IF(BS9<=24,2,IF(BS9<=30,2,IF(BS9<=36,3,3))))))","v":3},3,3,3,3,3,3,3,3,{"$f":"ROUND(IF(BR20=0,0,MAX(BR20/Parameter!$B$3,1)),0)","v":1},{"$f":"ROUND(IF(BR20=0,0,MAX(BR20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(BR20,0)","v":3},{"$f":"ROUND(BS20,0)","v":3},{"$f":"ROUND(BT20,0)","v":3},{"$f":"ROUND(IF(BT20=0,0,MAX(BT20/Parameter!$B$3*2,1)),0)","v":2},{"$f":"ROUND(IF(BT20=0,0,MAX(BT20/Parameter!$B$4,1)),0)","v":1},"Total h"]
["Ist",null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(L22:L25,\"X\")","v":1},2,3,2,2,1,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AC22:AC25,\"X\")","v":1},2,3,3,3,2,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AT22:AT25,\"X\")","v":1},2,3,3,3,2,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(BK22:BK25,\"X\")","v":1},2,3,3,3,2,1,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(CB22:CB25,\"X\")","v":1},2,3,3,3,2,1]
["Elisabeth",null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"S","S","S","S","S","S","S",null,null,null,null,null,null,null,null,null,null,"S","S","S","S","S","S","S",{"$f":"SUM(COUNTIF(L22,\"x\")*L$12,COUNTIF(M22,\"x\")*M$12,COUNTIF(N22,\"x\")*N$12,COUNTIF(O22,\"x\")*O$12,COUNTIF(P22,\"x\")*P$12,COUNTIF(Q22,\"x\")*Q$12,COUNTIF(R22,\"x\")*R$12,COUNTIF(AC22,\"x\")*AC$12,COUNTIF(AD22,\"x\")*AD$12,COUNTIF(AE22,\"x\")*AE$12,COUNTIF(AF22,\"x\")*AF$12,COUNTIF(AG22,\"x\")*AG$12,COUNTIF(AH22,\"x\")*AH$12,COUNTIF(AI22,\"x\")*AI$12,COUNTIF(AT22,\"x\")*AT$12,COUNTIF(AU22,\"x\")*AU$12,COUNTIF(AV22,\"x\")*AV$12,COUNTIF(AW22,\"x\")*AW$12,COUNTIF(AX22,\"x\")*AX$12,COUNTIF(AY22,\"x\")*AY$12,COUNTIF(AZ22,\"x\")*AZ$12,COUNTIF(BK22,\"x\")*BK$12,COUNTIF(BL22,\"x\")*BL$12,COUNTIF(BM22,\"x\")*BM$12,COUNTIF(BN22,\"x\")*BN$12,COUNTIF(BO22,\"x\")*BO$12,COUNTIF(BP22,\"x\")*BP$12,COUNTIF(BQ22,\"x\")*BQ$12,COUNTIF(CB22,\"x\")*CB$12,COUNTIF(CC22,\"x\")*CC$12,COUNTIF(CD22,\"x\")*CD$12,COUNTIF(CE22,\"x\")*CE$12,COUNTIF(CF22,\"x\")*CF$12,COUNTIF(CG22,\"x\")*CG$12,COUNTIF(CH22,\"x\")*CH$12)","v":1.2187500000000004}]
["Frida",null,null,null,null,null,null,null,null,null,null,null,"x","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,{"$f":"SUM(COUNTIF(L23,\"x\")*L$12,COUNTIF(M23,\"x\")*M$12,COUNTIF(N23,\"x\")*N$12,COUNTIF(O23,\"x\")*O$12,COUNTIF(P23,\"x\")*P$12,COUNTIF(Q23,\"x\")*Q$12,COUNTIF(R23,\"x\")*R$12,COUNTIF(AC23,\"x\")*AC$12,COUNTIF(AD23,\"x\")*AD$12,COUNTIF(AE23,\"x\")*AE$12,COUNTIF(AF23,\"x\")*AF$12,COUNTIF(AG23,\"x\")*AG$12,COUNTIF(AH23,\"x\")*AH$12,COUNTIF(AI23,\"x\")*AI$12,COUNTIF(AT23,\"x\")*AT$12,COUNTIF(AU23,\"x\")*AU$12,COUNTIF(AV23,\"x\")*AV$12,COUNTIF(AW23,\"x\")*AW$12,COUNTIF(AX23,\"x\")*AX$12,COUNTIF(AY23,\"x\")*AY$12,COUNTIF(AZ23,\"x\")*AZ$12,COUNTIF(BK23,\"x\")*BK$12,COUNTIF(BL23,\"x\")*BL$12,COUNTIF(BM23,\"x\")*BM$12,COUNTIF(BN23,\"x\")*BN$12,COUNTIF(BO23,\"x\")*BO$12,COUNTIF(BP23,\"x\")*BP$12,COUNTIF(BQ23,\"x\")*BQ$12,COUNTIF(CB23,\"x\")*CB$12,COUNTIF(CC23,\"x\")*CC$12,COUNTIF(CD23,\"x\")*CD$12,COUNTIF(CE23,\"x\")*CE$12,COUNTIF(CF23,\"x\")*CF$12,COUNTIF(CG23,\"x\")*CG$12,COUNTIF(CH23,\"x\")*CH$12)","v":1.8333333333333335}]
["Gertrud",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,"ÜK","ÜK","ÜK","ÜK","ÜK","ÜK","ÜK",null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,{"$f":"SUM(COUNTIF(L24,\"x\")*L$12,COUNTIF(M24,\"x\")*M$12,COUNTIF(N24,\"x\")*N$12,COUNTIF(O24,\"x\")*O$12,COUNTIF(P24,\"x\")*P$12,COUNTIF(Q24,\"x\")*Q$12,COUNTIF(R24,\"x\")*R$12,COUNTIF(AC24,\"x\")*AC$12,COUNTIF(AD24,\"x\")*AD$12,COUNTIF(AE24,\"x\")*AE$12,COUNTIF(AF24,\"x\")*AF$12,COUNTIF(AG24,\"x\")*AG$12,COUNTIF(AH24,\"x\")*AH$12,COUNTIF(AI24,\"x\")*AI$12,COUNTIF(AT24,\"x\")*AT$12,COUNTIF(AU24,\"x\")*AU$12,COUNTIF(AV24,\"x\")*AV$12,COUNTIF(AW24,\"x\")*AW$12,COUNTIF(AX24,\"x\")*AX$12,COUNTIF(AY24,\"x\")*AY$12,COUNTIF(AZ24,\"x\")*AZ$12,COUNTIF(BK24,\"x\")*BK$12,COUNTIF(BL24,\"x\")*BL$12,COUNTIF(BM24,\"x\")*BM$12,COUNTIF(BN24,\"x\")*BN$12,COUNTIF(BO24,\"x\")*BO$12,COUNTIF(BP24,\"x\")*BP$12,COUNTIF(BQ24,\"x\")*BQ$12,COUNTIF(CB24,\"x\")*CB$12,COUNTIF(CC24,\"x\")*CC$12,COUNTIF(CD24,\"x\")*CD$12,COUNTIF(CE24,\"x\")*CE$12,COUNTIF(CF24,\"x\")*CF$12,COUNTIF(CG24,\"x\")*CG$12,COUNTIF(CH24,\"x\")*CH$12)","v":1.7083333333333339}]
["Hannah",null,null,null,null,null,null,null,null,null,null,"F","F","F","F","F","F","F",null,null,null,null,null,null,null,null,null,null,"F","F","F","F","F","F","F",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",null,null,null,null,null,null,null,null,null,null,null,null,"x","x","x","x","x",{"$f":"SUM(COUNTIF(L25,\"x\")*L$12,COUNTIF(M25,\"x\")*M$12,COUNTIF(N25,\"x\")*N$12,COUNTIF(O25,\"x\")*O$12,COUNTIF(P25,\"x\")*P$12,COUNTIF(Q25,\"x\")*Q$12,COUNTIF(R25,\"x\")*R$12,COUNTIF(AC25,\"x\")*AC$12,COUNTIF(AD25,\"x\")*AD$12,COUNTIF(AE25,\"x\")*AE$12,COUNTIF(AF25,\"x\")*AF$12,COUNTIF(AG25,\"x\")*AG$12,COUNTIF(AH25,\"x\")*AH$12,COUNTIF(AI25,\"x\")*AI$12,COUNTIF(AT25,\"x\")*AT$12,COUNTIF(AU25,\"x\")*AU$12,COUNTIF(AV25,\"x\")*AV$12,COUNTIF(AW25,\"x\")*AW$12,COUNTIF(AX25,\"x\")*AX$12,COUNTIF(AY25,\"x\")*AY$12,COUNTIF(AZ25,\"x\")*AZ$12,COUNTIF(BK25,\"x\")*BK$12,COUNTIF(BL25,\"x\")*BL$12,COUNTIF(BM25,\"x\")*BM$12,COUNTIF(BN25,\"x\")*BN$12,COUNTIF(BO25,\"x\")*BO$12,COUNTIF(BP25,\"x\")*BP$12,COUNTIF(BQ25,\"x\")*BQ$12,COUNTIF(CB25,\"x\")*CB$12,COUNTIF(CC25,\"x\")*CC$12,COUNTIF(CD25,\"x\")*CD$12,COUNTIF(CE25,\"x\")*CE$12,COUNTIF(CF25,\"x\")*CF$12,COUNTIF(CG25,\"x\")*CG$12,COUNTIF(CH25,\"x\")*CH$12)","v":1.2812500000000002}]
["...",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(COUNTIF(L26,\"x\")*L$12,COUNTIF(M26,\"x\")*M$12,COUNTIF(N26,\"x\")*N$12,COUNTIF(O26,\"x\")*O$12,COUNTIF(P26,\"x\")*P$12,COUNTIF(Q26,\"x\")*Q$12,COUNTIF(R26,\"x\")*R$12,COUNTIF(AC26,\"x\")*AC$12,COUNTIF(AD26,\"x\")*AD$12,COUNTIF(AE26,\"x\")*AE$12,COUNTIF(AF26,\"x\")*AF$12,COUNTIF(AG26,\"x\")*AG$12,COUNTIF(AH26,\"x\")*AH$12,COUNTIF(AI26,\"x\")*AI$12,COUNTIF(AT26,\"x\")*AT$12,COUNTIF(AU26,\"x\")*AU$12,COUNTIF(AV26,\"x\")*AV$12,COUNTIF(AW26,\"x\")*AW$12,COUNTIF(AX26,\"x\")*AX$12,COUNTIF(AY26,\"x\")*AY$12,COUNTIF(AZ26,\"x\")*AZ$12,COUNTIF(BK26,\"x\")*BK$12,COUNTIF(BL26,\"x\")*BL$12,COUNTIF(BM26,\"x\")*BM$12,COUNTIF(BN26,\"x\")*BN$12,COUNTIF(BO26,\"x\")*BO$12,COUNTIF(BP26,\"x\")*BP$12,COUNTIF(BQ26,\"x\")*BQ$12,COUNTIF(CB26,\"x\")*CB$12,COUNTIF(CC26,\"x\")*CC$12,COUNTIF(CD26,\"x\")*CD$12,COUNTIF(CE26,\"x\")*CE$12,COUNTIF(CF26,\"x\")*CF$12,COUNTIF(CG26,\"x\")*CG$12,COUNTIF(CH26,\"x\")*CH$12)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Modulbezeichnungen (von/bis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legende"]
[null,null,null,null,null,null,null,null,null,null,null,"FD 1","FD 2","VM","M","NM","SD 1","SD 2",null,null,null,null,null,null,null,null,null,null,null,null,"x","Anwesend",null,null,null,null,null,null,null,null,null,null,null,null,null,"S","Schule"]
[null,null,null,null,null,null,null,null,null,null,null,0.28125,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,null,null,null,null,null,null,null,null,null,null,null,null,"K","Krankheit/Unfall",null,null,null,null,null,null,null,null,null,null,null,null,null,"F","Frei/Ferien"]
[null,null,null,null,null,null,null,null,null,null,null,0.3125,0.33333333333333331,0.47916666666666669,0.58333333333333337,0.6875,0.73958333333333337,0.76041666666666663,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ÜK","Überbetrieblicher Kurs"]

{"sheet":"Kontaktdaten Mitarbeiter","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,86]]}
["Kontaktdaten"]
[]
[null,"Telefonnummer","E-Mail","Adresse"]
["Ausgebildet"]
["Andrea","079 123 45 56","andrea@kitadmin.ch","Nussbaumstrasse 1, 3006 Bern"]
["Bea","079 456 78 12","bea@kitadmin.ch","Nussbaumstrasse 2, 3006 Bern"]
["Christine","079 789 12 45","christine@kitadmin.ch","Nussbaumstrasse 3, 3006 Bern"]
["Daniela","079 369 25 14","daniela@kitadmin.ch","Nussbaumstrasse 4, 3006 Bern"]
[]
["nicht Ausgebildet"]
["Elisabeth","079 258 14 36","elisabeth@kitadmin.ch","Nussbaumstrasse 5, 3006 Bern"]
["Frida","079 147 36 25","frida@kitadmin.ch","Nussbaumstrasse 6, 3006 Bern"]
["Gertrud","079 159 26 48","gertrud@kitadmin.ch","Nussbaumstrasse 7, 3006 Bern"]
["Hannah","079 357 68 24","hannah@kitadmin.ch","Nussbaumstrasse 8, 3006 Bern"]

{"sheet":"Parameter","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,86]]}
["Parameter"]
[]
["Frühschichtfaktor",3]
["Spätschichtfaktor",3]