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

{"sheet":"Einstufung","index":0,"n_rows":39,"n_cols":18,"rows_kept":39,"merged":[[0,1,0,7],[1,8,1,10],[4,0,4,7],[5,0,5,7],[25,5,26,5],[28,5,29,5],[31,3,32,5],[34,3,35,5],[37,1,38,4]]}
["Name, Vorname",{"$nulls":9},2024]
["Geburtsjahr",{"$nulls":7},"Einstufungs-Tabelle",null,null,"KGst","IF"]
["Grundausbildung","FL",{"$nulls":6},"Anrechen-bare Jahre","Lohnstufe",null,"Gst","EK"]
["Stufenwechsel",null,{"$f":"CONCATENATE(B3,B4)","v":"FL"},{"$nulls":6},"Primarstufe","Sekundarstufe","Sst","AK"]
["Berechnung Jahre Unterrrichts- und Berufstätigkeiten",{"$nulls":7},46,21,20,null,"Pst"]
["Einreihung in die Lohnstufe",{"$nulls":7},"41-45",19,18,null,"Sst"]
[{"$nulls":8},40,17,16]
["Alter",{"$f":"K1-B2","v":2024},{"$nulls":6},39,15,14]
[{"$nulls":8},"33-38",15,14]
["Ausbildungsjahre",{"$f":"IF(B4=\"Pst\",23,IF(B4=\"Sst\",24,FALSE))","v":false},null,"Fach-LP Primar 23; Sekundar 24",{"$nulls":4},"26-32",14,13,{"$nulls":3},"B",null,null,"F"]
[{"$nulls":8},25,12,11]
["max. zu berechnen",{"$f":"IF(B8-B10<0,0,B8-B10)","v":2024},{"$nulls":6},24,12,11,{"$nulls":3},{"$f":"B12*12","v":24288}]
[{"$nulls":8},23,12,11]
["davon:",{"$nulls":7},22,12,11]
["Unterrichtstätigkeit zu 100 %",null,"/",null,null,{"$f":"INT(R15/12)","v":0},"/",{"$f":"R15-F15*12","v":0},21,12,11,{"$nulls":3},{"$f":"B15*12+D15","v":0},null,null,{"$f":"IF(O15>O12,O12,O15)","v":0}]
["gemäss LPVO § 16 Abs. 2 lit a.",{"$nulls":7},20,12,11]
[{"$nulls":8},19,12,11]
["Unterrichtstätigkeit zu 75 %",null,"/",null,null,{"$f":"INT(R18/12)","v":0},"/",{"$f":"R18-F18*12","v":0},18,12,11,{"$nulls":3},{"$f":"IF(O12>O15,O12-O15,IF(OR(O15>O12,O12=O15),0))","v":24288},{"$f":"B18*12+D18","v":0},null,{"$f":"IF(P18<O18,INT(P18/4*3),INT(O18/4*3))","v":0}]
["gemäss LPVO § 16 Abs. 2 lit b.",{"$nulls":7},17,10,9]
[{"$nulls":8},16,9,8]
["andere Tätigkeiten zu 50 %",{"$f":"INT(O21/12)","v":2024},"/",{"$f":"O21-B21*12","v":0},null,{"$f":"INT(R21/12)","v":1012},"/",{"$f":"R21-F21*12","v":0},15,8,7,{"$nulls":3},{"$f":"IF(O15>O12, 0,IF(P18>O18,O12-O15-O18,O12-O15-P18))","v":24288},null,null,{"$f":"INT(O21/2)","v":12144}]
["gemäss LPVO § 16 Abs. 2 lit c.",{"$nulls":7},14,8,7]
[{"$nulls":8},13,8,7]
["Total angerechnet",{"$nulls":4},{"$f":"INT(R24/12)","v":1012},"/",{"$f":"R24-F24*12","v":0},12,8,7,{"$nulls":6},{"$f":"R15+R18+R21","v":12144}]
[{"$nulls":8},11,8,7]
["Anrechenbare Jahre",{"$nulls":4},{"$f":"IF(F24>0,IF(F24>B12,B12,F24),0)","v":1012},null,null,10,7,6]
["Unterrichs- und Berufstätigkeit",{"$nulls":7},9,7,6]
[{"$nulls":8},8,5,4]
["Lohnstufe",{"$nulls":4},{"$f":"IF(OR(B4=\"Pst\"),VLOOKUP(F26,Tabelle!A:B,2),VLOOKUP(F26,Tab!A:B,2))","v":20},null,null,7,5,4]
["gemäss Einstufungs-Tabelle",{"$nulls":7},6,5,4]
[{"$nulls":8},5,3,2]
[{"$nulls":3},{"$f":"CONCATENATE(VLOOKUP(C4,Einreihung!A:B,2,FALSE),\"\",IF(F29=\"\",\"\",F29))","v":{"$error":"#N/A"}},{"$nulls":4},4,3,2]
["Lohneinreihung",{"$nulls":7},3,3,2]
[{"$nulls":8},2,2,1]
["Jahresgrundlohn in Franken",null,null,{"$f":"IF(OR(D32=\"\",D32=\"falsch\"),\"\",VLOOKUP(F29,Lohntabelle!A:C,VLOOKUP(C4,Einreihung!A:C,3,FALSE),FALSE))","v":{"$error":"#N/A"}},{"$nulls":4},1,1,1]
["bei 100 % Beschäftigungsgrad inkl. 13. Monatslohn",{"$nulls":7},0,1,1]
[]
[]
["Datum / Kürzel:"]

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

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

{"sheet":"Einreihung","index":3,"n_rows":2,"n_cols":3,"rows_kept":2}
["FLPst","10.01.",2]
["FLSst","12.01.",3]

{"sheet":"Lohntabelle","index":4,"n_rows":28,"n_cols":3,"rows_kept":28}
["Stufe","LR 10.01","LR 12.01"]
[1,{"v":97839,"d":"97,839"},{"v":103676,"d":"103,676"}]
[2,{"v":101458,"d":"101,458"},{"v":107547,"d":"107,547"}]
[3,{"v":104219,"d":"104,219"},{"v":111419,"d":"111,419"}]
[4,{"v":107837,"d":"107,837"},{"v":115286,"d":"115,286"}]
[5,{"v":111453,"d":"111,453"},{"v":119156,"d":"119,156"}]
[6,{"v":115072,"d":"115,072"},{"v":122169,"d":"122,169"}]
[7,{"v":118689,"d":"118,689"},{"v":126039,"d":"126,039"}]
[8,{"v":121449,"d":"121,449"},{"v":129907,"d":"129,907"}]
[9,{"v":125068,"d":"125,068"},{"v":133777,"d":"133,777"}]
[10,{"v":128686,"d":"128,686"},{"v":137648,"d":"137,648"}]
[11,{"v":132305,"d":"132,305"},{"v":141517,"d":"141,517"}]
[12,{"v":133855,"d":"133,855"},{"v":143176,"d":"143,176"}]
[13,{"v":135405,"d":"135,405"},{"v":144835,"d":"144,835"}]
[14,{"v":136957,"d":"136,957"},{"v":146492,"d":"146,492"}]
[15,{"v":138503,"d":"138,503"},{"v":148150,"d":"148,150"}]
[16,{"v":140057,"d":"140,057"},{"v":149809,"d":"149,809"}]
[17,{"v":141605,"d":"141,605"},{"v":151466,"d":"151,466"}]
[18,{"v":143158,"d":"143,158"},{"v":153124,"d":"153,124"}]
[19,{"v":144706,"d":"144,706"},{"v":154783,"d":"154,783"}]
[20,{"v":146258,"d":"146,258"},{"v":156443,"d":"156,443"}]
[21,{"v":147811,"d":"147,811"},{"v":158101,"d":"158,101"}]
[22,{"v":149358,"d":"149,358"},{"v":159758,"d":"159,758"}]
[23,{"v":150909,"d":"150,909"},{"v":161420,"d":"161,420"}]
[24,{"v":152460,"d":"152,460"},{"v":163077,"d":"163,077"}]
[25,{"v":154010,"d":"154,010"},{"v":164735,"d":"164,735"}]
[26,{"v":155561,"d":"155,561"},{"v":166392,"d":"166,392"}]
[27,{"v":157113,"d":"157,113"},{"v":168049,"d":"168,049"}]