{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Einstufung","Tabelle","Lohnstufenkorrektur","Lohntabelle","Einreihung"],"not_rendered":{"images":2,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Einstufung","index":0,"n_rows":40,"n_cols":20,"rows_kept":40,"merged":[[0,1,0,7],[5,0,5,7],[5,10,5,12],[6,0,6,7],[6,8,7,8],[6,9,7,9],[6,11,6,12],[26,5,27,5],[29,5,30,5],[32,5,33,5],[35,3,36,5],[38,3,39,5]]}
["Name, Vorname",{"$nulls":11},2024,null,null,"FLKG"]
["Geburtsjahr",{"$nulls":14},"KG","ZSL","ja"]
["Grundausbildung",{"$nulls":14},"PL","kZSL","nein"]
["Zertifikat Schulleitung",{"$nulls":14},"SL"]
["Ausserschul. Führungserfahrung",null,{"$f":"IF(CONCATENATE(B3,B4)=\"\",1,CONCATENATE(B3,B4))","v":1},{"$nulls":12},"S2"]
["Berechnung Jahre Unterrrichts- und Berufstätigkeiten",{"$nulls":7},"Einstufungs-Tabelle",null,"Lohnstufenkorrektur",{"$nulls":4},"FLPst"]
["Einreihung in die Lohnstufe",{"$nulls":7},"Anrechen-bare Jahre","Lohnstufe","Lohnstufe","Überführung",{"$nulls":3},"FLSst"]
[{"$nulls":10},"bisher","KG / PL","SL",null,null,"kLD"]
["Alter",{"$f":"M1-B2","v":2024},{"$nulls":6},46,22,{"$nulls":5},"SHP"]
[{"$nulls":8},"41-45",20]
["Ausbildungsjahre",{"$f":"IF(B3=\"\",23,IF(B3=\"kLD\",23,IF(B3=\"FLKG\",23,IF(B3=\"KG\",23,IF(B3=\"PL\",23,IF(B3=\"FLPst\",23,IF(B3=\"SL\",24,IF(B3=\"FLSst\",24,IF(B3=\"SHP\",24,IF(B3=\"S2\",24,FALSE))))))))))","v":23},null,"Kiga 23; Primar 23; Sekundar 24",{"$nulls":4},40,18,{"$nulls":6},"B",null,null,"F"]
[{"$nulls":8},39,16]
["max. zu berechnen",{"$f":"IF(B9-B11<0,0,B9-B11)","v":2001},{"$nulls":6},"33-38",16,{"$nulls":6},{"$f":"B13*12","v":24012}]
[{"$nulls":8},"26-32",15]
["davon:",{"$nulls":7},25,13]
["Unterrichtstätigkeit zu 100 %",null,"/",null,null,{"$f":"INT(T16/12)","v":0},"/",{"$f":"T16-F16*12","v":0},24,13,21,22,23,{"$nulls":3},{"$f":"B16*12+D16","v":0},null,null,{"$f":"IF(Q16>Q13,Q13,Q16)","v":0}]
["gemäss LPVO § 16 Abs. 2 lit a.",{"$nulls":7},23,13,20,21,22]
[{"$nulls":8},22,13,19,20,21]
["Unterrichtstätigkeit zu 75 %",null,"/",null,null,{"$f":"INT(T19/12)","v":0},"/",{"$f":"T19-F19*12","v":0},21,13,18,19,20,{"$nulls":3},{"$f":"IF(Q13>Q16,Q13-Q16,IF(OR(Q16>Q13,Q13=Q16),0))","v":24012},{"$f":"B19*12+D19","v":0},null,{"$f":"IF(R19<Q19,INT(R19/4*3),INT(Q19/4*3))","v":0}]
["gemäss LPVO § 16 Abs. 2 lit b.",{"$nulls":7},20,13,17,18,19]
[{"$nulls":8},19,13,16,17,18]
["andere Tätigkeiten zu 50 %",{"$f":"INT(Q22/12)","v":2001},"/",{"$f":"Q22-B22*12","v":0},null,{"$f":"INT(T22/12)","v":1000},"/",{"$f":"T22-F22*12","v":6},18,13,{"$nulls":6},{"$f":"IF(Q16>Q13, 0,IF(R19>Q19,Q13-Q16-Q19,Q13-Q16-R19))","v":24012},null,null,{"$f":"INT(Q22/2)","v":12006}]
["gemäss LPVO § 16 Abs. 2 lit c.",{"$nulls":7},17,11,15,16,17]
[{"$nulls":8},16,10,14,15,16]
["Total angerechnet",{"$nulls":4},{"$f":"INT(T25/12)","v":1000},"/",{"$f":"T25-F25*12","v":6},15,9,13,14,15,{"$nulls":6},{"$f":"T16+T19+T22","v":12006}]
[{"$nulls":8},14,9,12,13,14]
["Anrechenbare Jahre",{"$nulls":4},{"$f":"IF(F25>0,IF(F25>B13,B13,F25),0)","v":1000},null,null,13,9,11,12,13]
["Unterrichs- und Berufstätigkeit",{"$nulls":7},12,9]
[{"$nulls":8},11,9,10,11,12]
["Lohnstufe",{"$nulls":4},{"$f":"IF(AND(OR(B2=\"SL\",B2=\"S2\"),VLOOKUP(F27,Tabelle!A:B,2)=-1),1,VLOOKUP(F27,Tabelle!A:B,2))","v":22},null,null,10,8,9,10,11]
["gemäss Einstufungs-Tabelle",{"$nulls":7},9,8,8,9,10]
[{"$nulls":8},8,6,7,8,9]
["Lohnstufenkorrektur",{"$nulls":4},{"$f":"IF(VLOOKUP(B3,Einreihung!A:D,4,FALSE)=0,\"\",VLOOKUP(F30,Lohnstufenkorrektur!A:D,VLOOKUP(B3,Einreihung!A:D,4,FALSE),FALSE))","v":{"$error":"#N/A"}},null,null,7,6,6,7,8]
["Lohnstufe",{"$nulls":7},6,6]
["gemäss Tabelle",{"$nulls":7},5,4,5,6,7]
[{"$nulls":3},{"$f":"IF(VLOOKUP(C5,Einreihung!A:C,2,FALSE)=15,\"falsch\",IF(VLOOKUP(C5,Einreihung!A:C,2,FALSE)=16,\"\",CONCATENATE(VLOOKUP(C5,Einreihung!A:C,3,FALSE),IF(F27=\"\",\"\",\".\"),IF(F33=\"\",F30,F33))))","v":{"$error":"#N/A"}},{"$nulls":4},4,4,4,5,6]
["Lohneinreihung",{"$nulls":7},3,4,3,4,5]
[{"$nulls":8},2,3,2,3,4]
["Jahresgrundlohn in Franken",null,null,{"$f":"IF(OR(D36=\"\",D36=\"falsch\"),\"\",VLOOKUP(IF(F33=\"\",F30,F33),Lohntabelle!A:C,VLOOKUP(C5,Einreihung!A:C,2,FALSE),FALSE))","v":{"$error":"#N/A"}},{"$nulls":4},1,2,1,2,3]
["bei 100 % Beschäftigungsgrad inkl. 13. Monatslohn",{"$nulls":7},0,1]

{"sheet":"Tabelle","index":1,"n_rows":47,"n_cols":2,"rows_kept":47}
[0,1]
[1,2]
[2,3]
[3,4]
[4,4]
[5,4]
[6,6]
[7,6]
[8,6]
[9,8]
[10,8]
[11,9]
[12,9]
[13,9]
[14,9]
[15,9]
[16,10]
[17,11]
[18,13]
[19,13]
[20,13]
[21,13]
[22,13]
[23,13]
[24,13]
[25,13]
[26,15]
[27,15]
[28,15]
[29,15]
[30,15]
[31,15]
[32,15]
[33,16]
[34,16]
[35,16]
[36,16]
[37,16]
[38,16]
[39,16]
[40,18]
[41,20]
[42,20]
[43,20]
[44,20]
[45,20]
[46,22]

{"sheet":"Lohnstufenkorrektur","index":2,"n_rows":44,"n_cols":4,"rows_kept":44}
["Ausgangsstufe","KG / PL","SL"]
[]
[1,2,3,"falsch"]
[2,3,4,"falsch"]
[3,4,5,"falsch"]
[4,5,6,"falsch"]
[5,6,7,"falsch"]
[6,7,8,"falsch"]
[7,8,9,"falsch"]
[8,9,10,"falsch"]
[9,10,11,"falsch"]
[10,11,12,"falsch"]
[11,12,13,"falsch"]
[12,13,14,"falsch"]
[13,14,15,"falsch"]
[14,15,16,"falsch"]
[15,16,17,"falsch"]
[16,17,18,"falsch"]
[17,18,19,"falsch"]
[18,19,20,"falsch"]
[19,20,21,"falsch"]
[20,21,22,"falsch"]
[21,22,23,"falsch"]
[22,23,23,"falsch"]
[23,23,23,"falsch"]
[24,24,24,"falsch"]
[25,25,25,"falsch"]
[26,26,26,"falsch"]
[27,27,27,"falsch"]
[]
[null,2,3,15]
[]
[]
[]
[null,null,2]
[null,null,3]
[null,null,6]
[null,null,7]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,17]
[null,null,18]
[null,null,23]

{"sheet":"Lohntabelle","index":3,"n_rows":28,"n_cols":3,"rows_kept":28}
["Stufe","LR 12.01","LR 12.02"]
[1,{"v":103676,"d":"103,676"},{"v":110938,"d":"110,938"}]
[2,{"v":107547,"d":"107,547"},{"v":115082,"d":"115,082"}]
[3,{"v":111419,"d":"111,419"},{"v":119223,"d":"119,223"}]
[4,{"v":115286,"d":"115,286"},{"v":122512,"d":"122,512"}]
[5,{"v":119156,"d":"119,156"},{"v":126654,"d":"126,654"}]
[6,{"v":122169,"d":"122,169"},{"v":130796,"d":"130,796"}]
[7,{"v":126039,"d":"126,039"},{"v":134941,"d":"134,941"}]
[8,{"v":129907,"d":"129,907"},{"v":139083,"d":"139,083"}]
[9,{"v":133777,"d":"133,777"},{"v":143223,"d":"143,223"}]
[10,{"v":137648,"d":"137,648"},{"v":147369,"d":"147,369"}]
[11,{"v":141517,"d":"141,517"},{"v":151510,"d":"151,510"}]
[12,{"v":143176,"d":"143,176"},{"v":153286,"d":"153,286"}]
[13,{"v":144835,"d":"144,835"},{"v":155063,"d":"155,063"}]
[14,{"v":146492,"d":"146,492"},{"v":156839,"d":"156,839"}]
[15,{"v":148150,"d":"148,150"},{"v":158613,"d":"158,613"}]
[16,{"v":149809,"d":"149,809"},{"v":160388,"d":"160,388"}]
[17,{"v":151466,"d":"151,466"},{"v":162165,"d":"162,165"}]
[18,{"v":153124,"d":"153,124"},{"v":163940,"d":"163,940"}]
[19,{"v":154783,"d":"154,783"},{"v":165716,"d":"165,716"}]
[20,{"v":156443,"d":"156,443"},{"v":167492,"d":"167,492"}]
[21,{"v":158101,"d":"158,101"},{"v":169268,"d":"169,268"}]
[22,{"v":159758,"d":"159,758"},{"v":171044,"d":"171,044"}]
[23,{"v":161420,"d":"161,420"},{"v":172818,"d":"172,818"}]
[24,{"v":163077,"d":"163,077"},{"v":174592,"d":"174,592"}]
[25,{"v":164735,"d":"164,735"},{"v":176367,"d":"176,367"}]
[26,{"v":166392,"d":"166,392"},{"v":178144,"d":"178,144"}]
[27,{"v":168049,"d":"168,049"},{"v":179919,"d":"179,919"}]

{"sheet":"Einreihung","index":4,"n_rows":158,"n_cols":5,"rows_kept":158}
["KG",15,"nicht möglich",2]
["KGkZSL",2,12.01,0]
["KGZSL",3,12.02,0]
["PL",15,"nicht möglich",2,12]
["PLkZSL",2,12.01,0]
["PLZSL",3,12.02,0]
["SL",15,"nicht möglich",3,12]
["SLkZSL",2,12.01,0]
["SLZSL",3,12.02,0]
["S2",15,"nicht möglich",3]
["S2kZSL",2,12.01,0]
["S2ZSL",3,12.02,0]
["SHP",15,"nicht möglich",3,12]
["SHPkZSL",2,12.01,0]
["SHPZSL",3,12.02,0]
["FLKG",15,"nicht möglich",0]
["FLKGkZSL",2,12.01,0]
["FLKGZSL",3,12.02,0]
["FLPst",15,"nicht möglich",2]
["FLPstkZSL",2,12.01,0]
["FLPstZSL",3,12.02,0]
["FLSst",15,"nicht möglich",3]
["FLSstkZSL",2,12.01,0]
["FLSstZSL",3,12.02,0]
["kLD",15,"nicht möglich",0]
["kLDkZSL",2,12.01,0]
["kLDZSL",3,12.02,0]
{"$rows_empty":8}
[{"$nulls":4},14]
[{"$nulls":4},14]
[{"$nulls":4},14]
[]
[{"$nulls":4},16]
[]
[{"$nulls":4},16]
[]
[]
[]
[]
[]
[{"$nulls":4},14]
{"$rows_empty":7}
[{"$nulls":4},14]
[{"$nulls":4},14]
[{"$nulls":4},14]
{"$rows_empty":12}
[{"$nulls":4},14]
[{"$nulls":4},12]
{"$rows_empty":7}
[{"$nulls":4},15]
[]
[{"$nulls":4},15]
[]
[]
[]
[]
[{"$nulls":4},17]
[]
[]
[{"$nulls":4},17]
[]
[]
[]
[]
[]
[{"$nulls":4},16]
[]
[{"$nulls":4},16]
{"$rows_empty":8}
[{"$nulls":4},17]
[]
[]
[]
[]
[{"$nulls":4},12]
[]
[]
[]
[{"$nulls":4},14]
[{"$nulls":4},14]
[{"$nulls":4},14]
{"$rows_empty":8}
[{"$nulls":4},17]
[]
[]
[{"$nulls":4},17]
[]
[]
[]
[]
[]
[{"$nulls":4},16]
[]
[{"$nulls":4},16]
{"$rows_empty":8}
[{"$nulls":4},17]
[]
[]
[]
[]
[{"$nulls":4},12]
[]
[]
[]
[{"$nulls":4},14]
[{"$nulls":4},14]
[{"$nulls":4},14]