{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["UI_Index","UI_beschäftigungsgrad","Background","AFÜbersicht","DB_teacher","DB_contract","print_all","print_base","print_add","print_sonderA","print_sonderB","print_sonderC","Tabelle1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":11,"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":"UI_Index","index":0,"n_rows":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"\"Vertragserfassung Tool \"&Background!$A$34","v":"Vertragserfassung Tool v1.7"}]
[]
[]
[]
[]
[null,null,null,"I.","Lehrpersonal erfassen",null,null,null,null,null,null,null,"II.","Verträge erfassen"]
[]
[]
[null,null,null,"III.","Verträge kontrollieren",null,null,null,null,null,null,null,"IV.","Verträge generieren"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Windows-Version"]

{"sheet":"UI_beschäftigungsgrad","index":1,"n_rows":89,"n_cols":21,"rows_kept":89,"cut":false,"hidden":false,"merged":[[13,12,16,20],[17,12,18,13],[2,2,3,21],[4,2,4,9],[6,2,8,2],[6,3,8,3],[6,5,6,6],[6,8,6,10],[6,18,6,19],[5,12,6,13],[8,12,9,13],[48,2,48,21],[6,27,6,28],[7,9,7,10],[8,9,8,10],[27,2,29,2],[27,3,29,3],[27,5,27,6],[27,8,27,10],[27,12,29,12],[27,13,29,13],[27,15,27,16],[27,18,27,20],[28,9,28,10],[28,19,28,20],[29,9,29,10],[29,19,29,20],[50,2,52,2],[50,3,52,3],[50,5,50,6],[50,8,50,10],[50,12,52,12],[50,15,50,16],[50,18,50,20],[51,9,51,10],[51,19,51,20],[52,9,52,10],[52,19,52,20],[50,13,52,13],[71,2,73,2],[71,3,73,3],[71,5,71,6],[71,8,71,10],[71,12,91,21],[72,9,72,10],[73,9,73,10]]}
[]
[]
[null,null,"TABELLE BESCHÄFTIGUNGSGRAD"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Lehrperson:"]
[null,null,"GESAMT :",{"$f":"I9","v":0.71428571258227602},null,null,null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,null,{"$f":"J9/Background!$D$2","v":0.71428571258227602},{"$f":"K14+K18+K22+K26+J13","v":1361.428568181818},null,null,{"$f":"Background!O2","v":"2016-08-01"}]
[]
[null,null,"UNTERRICHT",{"$f":"Background!F2+Background!F4+Background!F13+Background!F15 &\" Lektionen\"","v":"20 Lektionen"}]
[null,null,"88% - (75% - 92%)",null,null,null,null,null,null,{"$f":"K14+J18+J22+J26+J13","v":1198.0571399999999}]
[null,null,"Altersentlastung",null,null,null,null,null,{"$f":"J13/Background!D2","v":0},{"$f":"J34+T34+J57+J78","v":0}]
[null,null,"± Flexibilisierung",null,null,null,null,null,{"$f":"K14/Background!D2","v":0.62857142707240288},{"$f":"-(J18+J22+J26)","v":0},{"$f":"K35+U35+K58+U58","v":1198.0571399999999}]
[]
[null,null,"SCHÜLERINNEN / SCHÜLER"]
[null,null,"4% - (2% - 17%)",null,null,null,null,null,null,{"$f":"J38+T38","v":54.457142727272725}]
[null,null,"± Flexibilisierung :",null,null,null,null,null,{"$f":"K18/Background!D2","v":2.857142850329104E-2},{"$f":"J39+T39","v":0},{"$f":"J17+J18","v":54.457142727272725}]
[]
[null,null,"SCHULE"]
[null,null,"5% - (2% - 17%)",null,null,null,null,null,null,{"$f":"J42+T42+J86","v":68.071428409090899}]
[null,null,"± Flexibilisierung :",null,null,null,null,null,{"$f":"K22/Background!D2","v":3.5714285629113801E-2},{"$f":"J43+T43+J87","v":0},{"$f":"J21+J22","v":68.071428409090899}]
[]
[null,null,"LEHRPERSON"]
[null,null,"3% - (2% - 9%)",null,null,null,null,null,null,{"$f":"J46+T46+J69","v":40.842857045454537}]
[null,null,"± Flexibilisierung :",null,null,null,null,null,{"$f":"K26/Background!D2","v":2.1428571377468276E-2},{"$f":"J47+T47+J70","v":0},{"$f":"J25+J26","v":40.842857045454537}]
[]
[null,null,"BASISVERTRAG :",{"$f":"I30","v":0.35714285629113801},null,"NORMALISIERT",null,null,"EFFEKTIV",null,null,null,"ZUSATZVERTRÄGE :",{"$f":"S30","v":0.35714285629113801},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,null,"in %","in Std.",null,null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,null,{"$f":"J30/Background!D2","v":0.35714285629113801},{"$f":"K35+K39+K43+K47+J34","v":680.71428409090902},null,null,null,null,null,null,null,null,{"$f":"T30/Background!D2","v":0.35714285629113801},{"$f":"U35+U39+U43+U47+T34","v":680.71428409090902}]
[]
[null,null,"UNTERRICHT",{"$f":"Background!F2 & \" Lektionen\"","v":"10 Lektionen"},null,null,null,null,null,null,null,null,"UNTERRICHT",{"$f":"Background!F4 & \" Lektionen\"","v":"10 Lektionen"}]
[null,null,{"$f":"F33*100&\"% - (75% - 92%)\"","v":"88% - (75% - 92%)"},null,null,{"$f":"1-(F38+F42+F46)","v":0.88},null,null,null,{"$f":"K35+J39+J43+J47+J34","v":599.02856999999995},null,null,{"$f":"P33*100&\"% - (75% - 92%)\"","v":"88% - (75% - 92%)"},null,null,{"$f":"1-(P38+P42+P46)","v":0.88},null,null,null,{"$f":"U35+T34+T39+T43+T47","v":599.02856999999995}]
[null,null,"Altersentlastung",null,null,null,null,null,{"$f":"J34/Background!D2","v":0},{"$f":"IF(Background!C9<=0.3,,\nIF(Background!M2=0,,\nIF(Background!M2=1,\nIF(Background!P2=\"Mono\",\n(Background!F2*Background!E2+Background!J2+Background!L2)/27*2,\n(Background!F2*Background!E2+Background!H2+Background!J2+Background!L2)/26*2),\nIF(Background!P2=\"Mono\",\n(Background!F2*Background!E2+Background!J2+Background!L2)/26*3,\n(Background!F2*Background!E2+Background!H2+Background!J2+Background!L2)/25*3))))","v":0},null,null,"Altersentlastung",null,null,null,null,null,{"$f":"T34/Background!D2","v":0},{"$f":"IF(Background!C9<=0.3,,\nIF(Background!M2=0,,\nIF(Background!M2=1,\nIF(Background!P2=\"Mono\",\n(Background!F4*Background!E2+Background!H4+Background!J4+Background!L4)/27*2,\n(Background!F4*Background!E2+Background!H4+Background!J4+Background!L4)/26*2),\nIF(Background!P2=\"Mono\",\n(Background!F4*Background!E2+Background!H4+Background!J4+Background!L4)/26*3,\n(Background!F4*Background!E2+Background!H4+Background!J4+Background!L4)/25*3))))","v":0}]
[null,null,"± Flexibilisierung",null,null,{"$f":"IF(J$30>0,J35/J$30,0)","v":0},{"$f":"F33+F35","v":0.88},null,{"$f":"K35/Background!D2","v":0.31428571353620144},{"$f":"-(J39+J43+J47)","v":0},{"$f":"Background!F2*Background!E2","v":599.02856999999995},null,"± Flexibilisierung",null,null,{"$f":"IF(T$30>0,T35/T$30,0)","v":0},{"$f":"P33+P34+P35","v":0.88},null,{"$f":"U35/Background!D2","v":0.31428571353620144},{"$f":"-(T39+T43+T47)","v":0},{"$f":"Background!F4*Background!E2","v":599.02856999999995}]
[]
[null,null,"SCHÜLERINNEN / SCHÜLER",null,null,null,null,null,null,null,null,null,"SCHÜLERINNEN / SCHÜLER"]
[null,null,{"$f":"F38*100&\"% - (2% - 17%)\"","v":"4% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F11=1),4%,0%)","v":0.04},null,null,null,{"$f":"J33/F33*F38","v":27.228571363636362},null,null,{"$f":"P38*100&\"% - (2% - 17%)\"","v":"4% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F11=1),4%,0%)","v":0.04},null,null,null,{"$f":"T33/P33*P38","v":27.228571363636362}]
[null,null,"± Flexibilisierung :",{"$f":"IF(Background!G2=\"\",\"\",Background!G2)","v":""},null,{"$f":"IF(J$30>0,J39/J$30,0)","v":0},{"$f":"F38+F39","v":0.04},null,{"$f":"K39/Background!D2","v":1.428571425164552E-2},{"$f":"Background!H2","v":0},{"$f":"J38+J39","v":27.228571363636362},null,"± Flexibilisierung :",{"$f":"IF(Background!G4=\"\",\"\",Background!G4)","v":""},null,{"$f":"IF(T$30>0,T39/T$30,0)","v":0},{"$f":"P38+P39","v":0.04},null,{"$f":"U39/Background!D2","v":1.428571425164552E-2},{"$f":"Background!H4","v":0},{"$f":"T38+T39","v":27.228571363636362}]
[]
[null,null,"SCHULE",null,null,null,null,null,null,null,null,null,"SCHULE"]
[null,null,{"$f":"F42*100&\"% - (2% - 17%)\"","v":"5% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F11=2),5%,0%)","v":0.05},null,null,null,{"$f":"J33/F33*F42","v":34.035714204545449},null,null,{"$f":"P42*100&\"% - (2% - 17%)\"","v":"5% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F11=2),5%,0%)","v":0.05},null,null,null,{"$f":"T33/P33*P42","v":34.035714204545449}]
[null,null,"± Flexibilisierung :",{"$f":"IF(Background!I2=\"\",\"\",Background!I2)","v":""},null,{"$f":"IF(J$30>0,J43/J$30,0)","v":0},{"$f":"F42+F43","v":0.05},null,{"$f":"K43/Background!D2","v":1.7857142814556901E-2},{"$f":"Background!J2","v":0},{"$f":"J42+J43","v":34.035714204545449},null,"± Flexibilisierung :",{"$f":"IF(Background!I4=\"\",\"\",Background!I4)","v":""},null,{"$f":"IF(T$30>0,T43/T$30,0)","v":0},{"$f":"P42+P43","v":0.05},null,{"$f":"U43/Background!D2","v":1.7857142814556901E-2},{"$f":"Background!J4","v":0},{"$f":"T42+T43","v":34.035714204545449}]
[]
[null,null,"LEHRPERSON",null,null,null,null,null,null,null,null,null,"LEHRPERSON"]
[null,null,{"$f":"F46*100 &\"% - (2% - 9%)\"","v":"3% - (2% - 9%)"},null,null,0.03,null,null,null,{"$f":"J33/F33*F46","v":20.421428522727268},null,null,{"$f":"P46*100 &\"% - (2% - 9%)\"","v":"3% - (2% - 9%)"},null,null,0.03,null,null,null,{"$f":"T33/P33*P46","v":20.421428522727268}]
[null,null,"± Flexibilisierung :",{"$f":"IF(Background!K2=\"\",\"\",Background!K2)","v":""},null,{"$f":"IF(J$30>0,J47/J$30,0)","v":0},{"$f":"F46+F47","v":0.03},null,{"$f":"K47/Background!D2","v":1.0714285688734138E-2},{"$f":"Background!L2","v":0},{"$f":"J46+J47","v":20.421428522727268},null,"± Flexibilisierung :",{"$f":"IF(Background!K4=\"\",\"\",Background!K4)","v":""},null,{"$f":"IF(T$30>0,T47/T$30,0)","v":0},{"$f":"P46+P47","v":0.03},null,{"$f":"U47/Background!D2","v":1.0714285688734138E-2},{"$f":"Background!L4","v":0},{"$f":"T46+T47","v":20.421428522727268}]
[]
[null,null,"SONDERVERTRÄGE"]
[]
[null,null,"KURZE STELLVERTRETUNG BIS 4 WOCHEN :",{"$f":"I53","v":0},null,"NORMALISIERT",null,null,"EFFEKTIV",null,null,null,"ÜBERZEIT UNTERRICHT :",{"$f":"S53","v":0},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,null,"in %","in Std.",null,null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,null,{"$f":"J53/Background!$D$2","v":0},{"$f":"K58+K62+K66+K70+J57","v":0},null,null,null,null,null,null,null,null,{"$f":"T53/Background!$D$2","v":0},{"$f":"U58+U62+U66+U70+T57","v":0}]
[]
[null,null,"UNTERRICHT",{"$f":"Background!F13 & \" Lektionen\"","v":"0 Lektionen"},null,null,null,null,null,null,null,null,"UNTERRICHT",{"$f":"Background!F15 & \" Lektionen\"","v":"0 Lektionen"}]
[null,null,{"$f":"F56*100&\"%\"","v":"97%"},null,null,0.97,null,null,null,{"$f":"K58+J62+J66+J70+J57","v":0},null,null,{"$f":"P56*100&\"%\"","v":"100%"},null,null,1,null,null,null,{"$f":"U58+T62+T66+T70+T57","v":0}]
[null,null,"Altersentlastung",null,null,null,null,null,{"$f":"J57/Background!D2","v":0},{"$f":"IF(Background!C9<=0.3,,\nIF(Background!M2=0,,\nIF(Background!M2=1,\n(Background!F13*Background!E2+Background!L13)/(((Background!D2*F56)/Background!E2)-2)*2,\n(Background!F13*Background!E2+Background!L13)/(((Background!D2*F56)/Background!E2)-3)*3)))","v":0}]
[null,null,"± Flexibilisierung",null,null,{"$f":"IF(J$53>0,J58/J$53,0)","v":0},{"$f":"F56+F58","v":0.97},null,{"$f":"K58/Background!$D$2","v":0},{"$f":"-(J62+J66+J70)","v":0},{"$f":"Background!F13*Background!E2","v":0},null,"± Flexibilisierung",null,null,{"$f":"IF(T$53>0,T58/T$53,0)","v":0},{"$f":"P56+P58","v":1},null,{"$f":"U58/Background!$D$2","v":0},{"$f":"-(T62+T66+T70)","v":0},{"$f":"Background!E2*Background!F15","v":0}]
[]
[null,null,"SCHÜLERINNEN / SCHÜLER",null,null,null,null,null,null,null,null,null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,null,"SCHULE",null,null,null,null,null,null,null,null,null,"SCHULE"]
[]
[]
[]
[null,null,"LEHRPERSON",null,null,null,null,null,null,null,null,null,"LEHRPERSON"]
[null,null,{"$f":"F69*100 &\"%\"","v":"3%"},null,null,0.03,null,null,null,{"$f":"J56/F56*F69","v":0}]
[null,null,null,null,null,{"$f":"IF(J$53>0,J70/J$53,0)","v":0},{"$f":"F69+F70","v":0.03},null,{"$f":"K70/Background!$D$2","v":0},0,{"$f":"J69+J70","v":0}]
[]
[null,null,"AUSSCHLIESSLICH ARBEITSFELD SCHULE :",{"$f":"I74","v":0},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,null,{"$f":"J74/Background!$D$2","v":0},{"$f":"K87+J78","v":0}]
[]
[null,null,"UNTERRICHT"]
[]
[null,null,"Altersentlastung",null,null,null,{"$f":"IF(J$74>0,J78/J$74,0)","v":0},null,{"$f":"J78/Background!D2","v":0},{"$f":"IF(Background!C9<=0.3,,\nIF(Background!M2=0,,\nIF(Background!M2=1,Background!J17/93.714*6.286,\nBackground!J17/90.571*9.429)))","v":0}]
[]
[]
[null,null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,null,"SCHULE"]
[null,null,null,null,null,{"$f":"IF(J87=0,1,0)","v":1}]
[null,null,"± Flexibilisierung :",{"$f":"IF(Background!I17=\"\",\"\",Background!I17)","v":""},null,{"$f":"IF(J$74>0,J87/J$74,0)","v":0},{"$f":"F86+F87","v":1},null,{"$f":"K87/Background!$D$2","v":0},{"$f":"Background!$J17","v":0},{"$f":"J87","v":0}]
[]
[null,null,"LEHRPERSON"]

{"sheet":"Background","index":2,"n_rows":35,"n_cols":25,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["category","salary_long_name","salary_short_name","max_workhours","class_hours","workload_base","flexi1_base_T","flexi1_base_H","flexi2_base_T","flexi2_base_H","flexi3_base_T","flexi3_base_H","age_reduc","class_resp","chosen_date","teacher_type","teacher_name",null,null,null,"Lists:","Anrede","LPKategorie","Verträge","Lehrpersonen"]
["Wahl","Primarschule, Kindergarten, Legasthenie- und Dyskalkulie-Therapie","KG / PS / Lega-Dysk",1906,59.902856999999997,10,null,0,null,0,null,0,0,0,"2016-08-01","LP","asdf asdf",null,null,null,null,"Frau","Lehrperson","Basisvertrag","asdf, badfs"]
["Lehrauftrag unbefristet","Oberstufe, Kleinklasse, ISF / Logopädie / Rhythmik / Psychomotorik mit Lehrdiplom für Regelklasse","OS / SHP",null,null,"workload_add","flexi1_add_T","flexi1_add_H","flexi2_add_T","flexi2_add_H","flexi3_add_T","flexi3_add_H",null,null,{"$f":"DAY(O2)","v":1},null,null,null,null,null,null,"Mann","Klassenlehrperson","Zusatzvertrag","Doe, Jeanne"]
["Lehrauftrag befristet","ISF / Logopädie / Rhythmik / Psychomotorik ohne Lehrdiplom für Regelklasse","Förderungen ohne Lehrdiplom Regelklasse",null,null,10,null,0,null,0,null,0,null,null,{"$f":"MONTH(O2)","v":8},null,null,null,null,null,null,null,"Reine Fachlehrperson","Kurze Stellvertrungen bis 4 Wochen","fgbdsyfbxbycx, cbyxvvcxycvx"]
[null,null,null,null,null,"start_base","end_base","start_sA","end_sA","start_sC","end_sC",null,null,null,{"$f":"YEAR(O2)","v":2016},null,null,null,null,null,null,null,null,"Überzeit Unterricht","Schmutz, Helmut"]
["calendar",null,null,null,null,"2016-08-01","2017-07-31","9999-12-31","1900-12-31","9999-12-31","1900-12-31",null,null,null,null,null,null,null,null,null,null,null,null,"Projekt im Arbeitsfeld Schule","Seltzer, Louis"]
["DTReference",null,null,null,null,"start_add","end_add","start_sB","end_sB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test, Frau"]
[null,null,"get FTE no age Reduc",null,null,"2016-08-01","2017-07-31","9999-12-31","1900-12-31",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vd<yx, v<cxy"]
["Januar",null,0.71428571258227602]
["Februar",null,null,null,null,"under30"]
["März",null,null,null,null,0]
["April",null,null,null,null,"workload_sA","flexi1_sA_T","flexi1_sA_H","flexi2_sA_T","flexi2_sA_H","flexi3_sA_T","flexi3_sA_H"]
["Mai",null,null,null,null,0,null,0,null,0,null,0]
["Juni",null,null,null,null,"workload_sB","flexi1_sB_T","flexi1_sB_H","flexi2_sB_T","flexi2_sB_H","flexi3_sB_T","flexi3_sB_H"]
["Juli",null,null,null,null,0,null,0,null,0,null,0]
["August",null,null,null,null,"workload_sC","flexi1_sC_T","flexi1_sC_H","flexi2_sC_T","flexi2_sC_H","flexi3_sC_T","flexi3_sC_H"]
["September",null,{"$f":"E2/D2","v":3.1428571353620142E-2},null,null,0,null,0,null,0,null,0]
["Oktober"]
["November"]
["Dezember",null,null,null,null,null," "]
[]
["ChosenDay",null,null,null,null,"<SCHULE_NAME1>","<SCHULE_NAME2>","<SCHULE_STRASSE>","<SCHULE_ORT>","<SCHULE_TELNR>","<SCHULE_EMAIL>","<AG1_NAME>","<AG1_FUNKTION>","<AG2_NAME>","<AG2_FUNKTION>"]
[10,null,null,null,null,"Gemeinde Beispiel","Muster Schule","Beispielsstr. 152",{"$f":"I24&\" \"&I25","v":"9000 St.Gallen"},null,null,"Frau Präsidentin","Schulratspräsidentin","Herr Verwalter","Schulverwalter"]
["Fix Counters",null,null,null,null,null,null,null,9000]
[5,null,null,null,null,null,null,null,"St.Gallen"]
["Dir Word-Template"]
[]
[]
["Schoolyear"]
["2019 - 2020"]
[null,null,null,null,null,"workload_add","flexi1_add_T","flexi1_add_H","flexi2_add_T","flexi2_add_H","flexi3_add_T","flexi3_add_H","start_add","end_add"]
[1.7,null,null,null,null,"10",null,null,null,null,null,null,"2016-08-01","2017-07-31"]
["Tool Version","Next Version (check for update)"]
[{"$f":"\"v\" & A32","v":"v1.7"},{"$f":"\"v\"&A32+0.1","v":"v1.8"}]
["BLD"]

{"sheet":"AFÜbersicht","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,7],[2,3,2,7]]}
["ÜBERSICHT ARBEITSFELDER"]
["Stichtag: 01.01.2015"]
["LEHRPERSONEN",null,null,"ARBEITSFELDER (in Stunden)"]
["Name","Vorname",null,"Unterricht","SuS","Schule","Lehrperson","Total"]
[null,null,null,null,null,null,null,340.34999999999997]

{"sheet":"DB_teacher","index":4,"n_rows":1,"n_cols":33,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Lehrperson ID","Name","Vorname","Funktion","Geburtsdatum","Lehrperson Typ","Adresse","Jobsharing ID","PLZ","Ort","männlich","Altersentlastung","% - Anstellung"," KG / PS / Lega-Dysk"," OS / SHP"," Förderungen ohne Lehrdiplom Regelklasse"," Musiklehrer ohne Musikdiplom"," Kindergarten"," Primarschule"," Oberstufe"," Sonderpädagogik"," Deutsch für Kinder mit Migrationshintergrund","% - KG / PS / Lega-Dysk","% - OS / SHP","% - Förderungen ohne Lehrdiplom Regelklasse","% - Musiklehrer ohne Musikdiplom","% - Kindergarten","% - Primarschule","% - Oberstufe","% - Sonderpädagogik","% - Deutsch für Kinder mit Migrationshintergrund","BG < 30%","LEER_LASSEN_2"]

{"sheet":"DB_contract","index":5,"n_rows":1,"n_cols":25,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Lehrperson ID","Vertrag ID","Vertragsart","Vertragsbeginn","Vertragsende","Unterricht Lektionen","Klassenlehrperson","Flexi SuS Text","Flexi SuS Std.","Flexi Schule Text","Flexi Schule Std.","Flexi LP Text","Flexi LP Std.","Job Sharing","nicht ständig","Special_Form","KG / PS / Lega-Dysk","OS / SHP","Förderungen ohne Lehrdiplom Regelklasse","Musiklehrer ohne Musikdiplom","Kindergarten","Primarschule","Oberstufe","Sonderpädagogik","Deutsch für Kinder mit Migrationshintergrund"]

{"sheet":"print_all","index":6,"n_rows":272,"n_cols":10,"rows_kept":272,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9],[32,7,32,9],[37,1,39,1],[37,2,39,2],[37,4,37,5],[37,7,37,9],[38,8,38,9],[39,8,39,9],[63,7,63,9],[68,1,70,1],[68,2,70,2],[68,4,68,5],[68,7,68,9],[69,8,69,9],[70,8,70,9],[94,7,94,9],[99,1,101,1],[99,2,101,2],[99,4,99,5],[99,7,99,9],[100,8,100,9],[101,8,101,9],[125,7,125,9],[130,1,132,1],[130,2,132,2],[130,4,130,5],[130,7,130,9],[131,8,131,9],[132,8,132,9],[156,7,156,9],[161,1,163,1],[161,2,163,2],[161,4,161,5],[161,7,161,9],[162,8,162,9],[163,8,163,9],[187,7,187,9],[192,1,194,1],[192,2,194,2],[192,4,192,5],[192,7,192,9],[193,8,193,9],[194,8,194,9],[218,7,218,9],[223,1,225,1],[223,2,225,2],[223,4,223,5],[223,7,223,9],[224,8,224,9],[225,8,225,9],[249,7,249,9],[254,1,256,1],[254,2,256,2],[254,4,254,5],[254,7,254,9],[255,8,255,9],[256,8,256,9]]}
["ANHANG BASISVERTRAG"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:",{"$f":"Background!$F$6","v":"2016-08-01"}]
["Bis:",{"$f":"IF(Background!$G$6=\"N/A\",\"unbefristet\",Background!$G$6)","v":"2017-07-31"}]
[]
[null,"BASISVERTRAG :",{"$f":"H9","v":0.35714285629113801},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"UI_beschäftigungsgrad!$I$30","v":0.35714285629113801},{"$f":"UI_beschäftigungsgrad!$J$30","v":680.71428409090902}]
[]
[null,"UNTERRICHT",{"$f":"UI_beschäftigungsgrad!$D$32","v":"10 Lektionen"}]
[null,{"$f":"UI_beschäftigungsgrad!$C$33","v":"88% - (75% - 92%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$33","v":0.88},null,null,null,{"$f":"UI_beschäftigungsgrad!$J$33","v":599.02856999999995}]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"UI_beschäftigungsgrad!$I$34","v":0},{"$f":"UI_beschäftigungsgrad!$J$34","v":0}]
[null,"± Flexibilisierung",null,null,{"$f":"UI_beschäftigungsgrad!$F$35","v":0},{"$f":"E12+E14","v":0.88},null,{"$f":"UI_beschäftigungsgrad!$I$35","v":0.31428571353620144},{"$f":"UI_beschäftigungsgrad!$J$35","v":0},{"$f":"UI_beschäftigungsgrad!$K$35","v":599.02856999999995}]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[null,{"$f":"UI_beschäftigungsgrad!$C$38","v":"4% - (2% - 17%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$38","v":0.04},null,null,null,{"$f":"$I$12/$E$12*$E$17","v":27.228571363636362}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$39","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$39","v":0},{"$f":"E17+E18","v":0.04},null,{"$f":"UI_beschäftigungsgrad!$I$39","v":1.428571425164552E-2},{"$f":"UI_beschäftigungsgrad!$J$39","v":0},{"$f":"UI_beschäftigungsgrad!$K$39","v":27.228571363636362}]
[]
[null,"SCHULE"]
[null,{"$f":"UI_beschäftigungsgrad!$C$42","v":"5% - (2% - 17%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$42","v":0.05},null,null,null,{"$f":"$I$12/$E$12*$E$21","v":34.035714204545449}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$43","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$43","v":0},{"$f":"E21+E22","v":0.05},null,{"$f":"UI_beschäftigungsgrad!$I$43","v":1.7857142814556901E-2},{"$f":"UI_beschäftigungsgrad!$J$43","v":0},{"$f":"UI_beschäftigungsgrad!$K$43","v":34.035714204545449}]
[]
[null,"LEHRPERSON"]
[null,{"$f":"UI_beschäftigungsgrad!$C$46","v":"3% - (2% - 9%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$46","v":0.03},null,null,null,{"$f":"$I$12/$E$12*$E$25","v":20.421428522727268}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$47","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$47","v":0},{"$f":"E25+E26","v":0.03},null,{"$f":"UI_beschäftigungsgrad!$I$47","v":1.0714285688734138E-2},{"$f":"UI_beschäftigungsgrad!$J$47","v":0},{"$f":"UI_beschäftigungsgrad!$K$47","v":20.421428522727268}]
[]
[]
[]
[]
[]
["ANHANG ZUSATZVERTRAG"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2016-08-01"]
["Bis:","2017-07-31"]
[]
[null,"ZUSATZVERTRAG :",{"$f":"H40","v":0.357143708861967},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I40/Background!$D$2","v":0.357143708861967},{"$f":"I44+J45+J49+J53+J57","v":680.71590909090912}]
[]
[null,"UNTERRICHT","10 Lektionen"]
[null,{"$f":"E43*100&\"% - (75% - 92%)\"","v":"88% - (75% - 92%)"},null,null,{"$f":"1-(E48+E52+E56)","v":0.88},null,null,null,{"$f":"J45+I44+I49+I53+I57","v":599.03}]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I44/Background!$D$2","v":0},0]
[null,"± Flexibilisierung",null,null,{"$f":"IF(I40>0,I45/I40,0)","v":0},{"$f":"E43+E45","v":0.88},null,{"$f":"J45/Background!$D$2","v":0.31428646379853092},{"$f":"-(I49+I53+I57)","v":0},599.03]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[null,{"$f":"E48*100&\"% - (2% - 17%)\"","v":"4% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F$11=1),4%,0%)","v":0.04},null,null,null,{"$f":"I43/E43*E48","v":27.228636363636362}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I40>0,I49/I40,0)","v":0},{"$f":"E48+E49","v":0.04},null,{"$f":"J49/Background!$D$2","v":1.4285748354478678E-2},"0",{"$f":"I48+I49","v":27.228636363636362}]
[]
[null,"SCHULE"]
[null,{"$f":"E52*100&\"% - (2% - 17%)\"","v":"5% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F$11=2),5%,0%)","v":0.05},null,null,null,{"$f":"I43/E43*E52","v":34.03579545454545}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I40>0,I53/I40,0)","v":0},{"$f":"E53+E52","v":0.05},null,{"$f":"J53/Background!$D$2","v":1.7857185443098347E-2},"0",{"$f":"I52+I53","v":34.03579545454545}]
[]
[null,"LEHRPERSON"]
[null,{"$f":"E56*100 &\"% - (2% - 9%)\"","v":"3% - (2% - 9%)"},null,null,0.03,null,null,null,{"$f":"I43/E43*E56","v":20.42147727272727}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I40>0,I57/I40,0)","v":0},{"$f":"E56+E57","v":0.03},null,{"$f":"J57/Background!$D$2","v":1.0714311265859007E-2},"0",{"$f":"I56+I57","v":20.42147727272727}]
[]
[]
[]
[]
[]
["ANHANG ARBEITSFELD SCHULE"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","2016-07-31"]
[]
[null,"AUSSCHLIESSLICH ARBEITSFELD SCHULE :",{"$f":"H71","v":0},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I71/Background!$D$2","v":0},{"$f":"J84+I75","v":0}]
[]
[null,"UNTERRICHT"]
[]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I75/Background!$D$2","v":0},0]
[]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[null,null,null,null,{"$f":"IF(I84=0,1,0)","v":1}]
[null,{"$f":"UI_beschäftigungsgrad!$C$87","v":"± Flexibilisierung :"},{"$f":"IF(Background!$I$17=\"\",\"\",Background!$I$17)","v":""},null,{"$f":"IF(I71>0,I84/I71,0)","v":0},{"$f":"E83+E84","v":1},null,{"$f":"J84/Background!$D$2","v":0},{"$f":"Background!$J$17","v":0},{"$f":"I84","v":0}]
[]
[null,"LEHRPERSON"]
[]
[]
[]
[]
[]
[]
[]
["ANHANG STELLVERTRETUNG BIS 4 WOCHEN"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","2016-07-31"]
[]
[null,"KURZE STELLVERTRETUNG BIS 4 WOCHEN :",{"$f":"H102","v":0.10766797200376457},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I102/Background!$D$2","v":0.10766797200376457},{"$f":"I106+J107+J119","v":205.21515463917527}]
[]
[null,"UNTERRICHT","3 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$C$56","v":"97%"},null,null,0.97,null,null,null,{"$f":"I106+J107+I119","v":199.05870000000002}]
[null,{"$f":"UI_beschäftigungsgrad!$C$57","v":"Altersentlastung"},null,null,null,null,null,{"$f":"I106/Background!$D$2","v":1.0151469045120673E-2},19.348700000000001]
[null,{"$f":"UI_beschäftigungsgrad!$C$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I102>0,I107/I102,0)","v":0},{"$f":"E105+E107","v":0.97},null,{"$f":"J107/Background!$D$2","v":9.4286463798530964E-2},{"$f":"-I119","v":0},179.71]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]
[null,{"$f":"UI_beschäftigungsgrad!$C$69","v":"3%"},null,null,0.03,null,null,null,{"$f":"I105/E105*E118","v":6.1564546391752577}]
[null,null,null,null,{"$f":"IF(I102>0,I119/I102,0)","v":0},{"$f":"E118+E119","v":0.03},null,{"$f":"K163/Background!$D$2","v":0},"0",{"$f":"I118+I119","v":6.1564546391752577}]
[]
[null,null,null,null,null,null,null,null,null,"Dieser Vertrag muss im Wochenlohn entschädigt werden."]
[]
[]
[]
["ANHANG STELLVERTRETUNG BIS 4 WOCHEN"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","2016-07-31"]
[]
[null,"KURZE STELLVERTRETUNG BIS 4 WOCHEN :",{"$f":"H133","v":0.14355551108274467},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I133/Background!$D$2","v":0.14355551108274467},{"$f":"I137+J138+J150","v":273.61680412371135}]
[]
[null,"UNTERRICHT","4 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$C$56","v":"97%"},null,null,0.97,null,null,null,{"$f":"I137+J138+I150","v":265.4083}]
[null,{"$f":"UI_beschäftigungsgrad!$C$57","v":"Altersentlastung"},null,null,null,null,null,{"$f":"I137/Background!$D$2","v":1.3535309548793286E-2},25.798300000000001]
[null,{"$f":"UI_beschäftigungsgrad!$C$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I133>0,I138/I133,0)","v":0},{"$f":"E136+E138","v":0.97},null,{"$f":"J138/Background!$D$2","v":0.12571353620146905},{"$f":"-I150","v":0},239.61]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]
[null,{"$f":"UI_beschäftigungsgrad!$C$69","v":"3%"},null,null,0.03,null,null,null,{"$f":"I136/E136*E149","v":8.2085041237113394}]
[null,null,null,null,{"$f":"IF(I133>0,I150/I133,0)","v":0},{"$f":"E149+E150","v":0.03},null,{"$f":"K194/Background!$D$2","v":0},"0",{"$f":"I149+I150","v":8.2085041237113394}]
[]
[null,null,null,null,null,null,null,null,null,"Dieser Vertrag muss im Wochenlohn entschädigt werden."]
[]
[]
[]
["ANHANG ÜBERZEIT"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","2016-07-31"]
[]
[null,"ÜBERZEIT UNTERRICHT :",{"$f":"H164","v":3.1427072402938093E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I164/Background!$D$2","v":3.1427072402938093E-2},{"$f":"J169","v":59.9}]
[]
[null,"UNTERRICHT","1 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$M$56","v":"100%"},null,null,1,null,null,null,{"$f":"J169","v":59.9}]
[]
[null,{"$f":"UI_beschäftigungsgrad!$M$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I164>0,I169/I164,0)","v":0},{"$f":"E167+E169","v":1},null,{"$f":"J169/Background!$D$2","v":3.1427072402938093E-2},0,59.9]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]
[]
[]
[]
[]
[]
[]
[]
["ANHANG ÜBERZEIT"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","unbefristet"]
[]
[null,"ÜBERZEIT UNTERRICHT :",{"$f":"H195","v":6.2859391395592865E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I195/Background!$D$2","v":6.2859391395592865E-2},{"$f":"J200","v":119.81}]
[]
[null,"UNTERRICHT","2 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$M$56","v":"100%"},null,null,1,null,null,null,{"$f":"J200","v":119.81}]
[]
[null,{"$f":"UI_beschäftigungsgrad!$M$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I195>0,I200/I195,0)","v":0},{"$f":"E198+E200","v":1},null,{"$f":"J200/Background!$D$2","v":6.2859391395592865E-2},0,119.81]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]
[]
[]
[]
[]
[]
[]
[]
["ANHANG ARBEITSFELD SCHULE"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","unbefristet"]
[]
[null,"AUSSCHLIESSLICH ARBEITSFELD SCHULE :",{"$f":"H226","v":2.1417208814270727E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I226/Background!$D$2","v":2.1417208814270727E-2},{"$f":"J239+I230","v":40.821200000000005}]
[]
[null,"UNTERRICHT"]
[]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I230/Background!$D$2","v":1.0924029380902414E-2},20.821200000000001]
[]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[null,null,null,null,{"$f":"IF(I239=0,1,0)","v":0}]
[null,{"$f":"UI_beschäftigungsgrad!$C$87","v":"± Flexibilisierung :"},null,null,{"$f":"IF(I226>0,I239/I226,0)","v":0.48994150098478234},{"$f":"E238+E239","v":0.48994150098478234},null,{"$f":"J239/Background!$D$2","v":1.049317943336831E-2},20,{"$f":"I239","v":20}]
[]
[null,"LEHRPERSON"]
[]
[]
[]
[]
[]
[]
[]
["ANHANG ARBEITSFELD SCHULE"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","unbefristet"]
[]
[null,"AUSSCHLIESSLICH ARBEITSFELD SCHULE :",{"$f":"H257","v":1.1312486883525708E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I257/Background!$D$2","v":1.1312486883525708E-2},{"$f":"J270+I261","v":21.561599999999999}]
[]
[null,"UNTERRICHT"]
[]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I261/Background!$D$2","v":8.1930745015739771E-4},1.5616000000000001]
[]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[null,null,null,null,{"$f":"IF(I270=0,1,0)","v":0}]
[null,{"$f":"UI_beschäftigungsgrad!$C$87","v":"± Flexibilisierung :"},null,null,{"$f":"IF(I257>0,I270/I257,0)","v":0.92757494805580298},{"$f":"E269+E270","v":0.92757494805580298},null,{"$f":"J270/Background!$D$2","v":1.049317943336831E-2},20,{"$f":"I270","v":20}]
[]
[null,"LEHRPERSON"]

{"sheet":"print_base","index":7,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9]]}
["ANHANG BASISVERTRAG"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:",{"$f":"Background!$F$6","v":"2016-08-01"}]
["Bis:",{"$f":"IF(Background!$G$6=\"N/A\",\"unbefristet\",Background!$G$6)","v":"2017-07-31"}]
[]
[null,"BASISVERTRAG :",{"$f":"H9","v":0.35714285629113801},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"UI_beschäftigungsgrad!$I$30","v":0.35714285629113801},{"$f":"UI_beschäftigungsgrad!$J$30","v":680.71428409090902}]
[]
[null,"UNTERRICHT",{"$f":"UI_beschäftigungsgrad!$D$32","v":"10 Lektionen"}]
[null,{"$f":"UI_beschäftigungsgrad!$C$33","v":"88% - (75% - 92%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$33","v":0.88},null,null,null,{"$f":"UI_beschäftigungsgrad!$J$33","v":599.02856999999995}]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"UI_beschäftigungsgrad!$I$34","v":0},{"$f":"UI_beschäftigungsgrad!$J$34","v":0}]
[null,"± Flexibilisierung",null,null,{"$f":"UI_beschäftigungsgrad!$F$35","v":0},{"$f":"E12+E14","v":0.88},null,{"$f":"UI_beschäftigungsgrad!$I$35","v":0.31428571353620144},{"$f":"UI_beschäftigungsgrad!$J$35","v":0},{"$f":"UI_beschäftigungsgrad!$K$35","v":599.02856999999995}]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[null,{"$f":"UI_beschäftigungsgrad!$C$38","v":"4% - (2% - 17%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$38","v":0.04},null,null,null,{"$f":"$I$12/$E$12*$E$17","v":27.228571363636362}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$39","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$39","v":0},{"$f":"E17+E18","v":0.04},null,{"$f":"UI_beschäftigungsgrad!$I$39","v":1.428571425164552E-2},{"$f":"UI_beschäftigungsgrad!$J$39","v":0},{"$f":"UI_beschäftigungsgrad!$K$39","v":27.228571363636362}]
[]
[null,"SCHULE"]
[null,{"$f":"UI_beschäftigungsgrad!$C$42","v":"5% - (2% - 17%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$42","v":0.05},null,null,null,{"$f":"$I$12/$E$12*$E$21","v":34.035714204545449}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$43","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$43","v":0},{"$f":"E21+E22","v":0.05},null,{"$f":"UI_beschäftigungsgrad!$I$43","v":1.7857142814556901E-2},{"$f":"UI_beschäftigungsgrad!$J$43","v":0},{"$f":"UI_beschäftigungsgrad!$K$43","v":34.035714204545449}]
[]
[null,"LEHRPERSON"]
[null,{"$f":"UI_beschäftigungsgrad!$C$46","v":"3% - (2% - 9%)"},null,null,{"$f":"UI_beschäftigungsgrad!$F$46","v":0.03},null,null,null,{"$f":"$I$12/$E$12*$E$25","v":20.421428522727268}]
[null,"± Flexibilisierung :",{"$f":"UI_beschäftigungsgrad!$D$47","v":""},null,{"$f":"UI_beschäftigungsgrad!$F$47","v":0},{"$f":"E25+E26","v":0.03},null,{"$f":"UI_beschäftigungsgrad!$I$47","v":1.0714285688734138E-2},{"$f":"UI_beschäftigungsgrad!$J$47","v":0},{"$f":"UI_beschäftigungsgrad!$K$47","v":20.421428522727268}]

{"sheet":"print_add","index":8,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9]]}
["ANHANG ZUSATZVERTRAG"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2016-08-01"]
["Bis:","2017-07-31"]
[]
[null,"ZUSATZVERTRAG :",{"$f":"H9","v":0.357143708861967},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I9/Background!$D$2","v":0.357143708861967},{"$f":"I13+J14+J18+J22+J26","v":680.71590909090912}]
[]
[null,"UNTERRICHT","10 Lektionen"]
[null,{"$f":"E12*100&\"% - (75% - 92%)\"","v":"88% - (75% - 92%)"},null,null,{"$f":"1-(E17+E21+E25)","v":0.88},null,null,null,{"$f":"J14+I13+I18+I22+I26","v":599.03}]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I13/Background!$D$2","v":0},0]
[null,"± Flexibilisierung",null,null,{"$f":"IF(I9>0,I14/I9,0)","v":0},{"$f":"E12+E14","v":0.88},null,{"$f":"J14/Background!$D$2","v":0.31428646379853092},{"$f":"-(I18+I22+I26)","v":0},599.03]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[null,{"$f":"E17*100&\"% - (2% - 17%)\"","v":"4% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F$11=1),4%,0%)","v":0.04},null,null,null,{"$f":"I12/E12*E17","v":27.228636363636362}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I9>0,I18/I9,0)","v":0},{"$f":"E17+E18","v":0.04},null,{"$f":"J18/Background!$D$2","v":1.4285748354478678E-2},"0",{"$f":"I17+I18","v":27.228636363636362}]
[]
[null,"SCHULE"]
[null,{"$f":"E21*100&\"% - (2% - 17%)\"","v":"5% - (2% - 17%)"},null,null,{"$f":"IF(OR(Background!$F$11=0,Background!$F$11=2),5%,0%)","v":0.05},null,null,null,{"$f":"I12/E12*E21","v":34.03579545454545}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I9>0,I22/I9,0)","v":0},{"$f":"E22+E21","v":0.05},null,{"$f":"J22/Background!$D$2","v":1.7857185443098347E-2},"0",{"$f":"I21+I22","v":34.03579545454545}]
[]
[null,"LEHRPERSON"]
[null,{"$f":"E25*100 &\"% - (2% - 9%)\"","v":"3% - (2% - 9%)"},null,null,0.03,null,null,null,{"$f":"I12/E12*E25","v":20.42147727272727}]
[null,"± Flexibilisierung :","",null,{"$f":"IF(I9>0,I26/I9,0)","v":0},{"$f":"E25+E26","v":0.03},null,{"$f":"J26/Background!$D$2","v":1.0714311265859007E-2},"0",{"$f":"I25+I26","v":20.42147727272727}]
[]
[]
[]
[]
[]
[]
[]
[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,""]

{"sheet":"print_sonderA","index":9,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9]]}
["ANHANG STELLVERTRETUNG BIS 4 WOCHEN"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2011-08-01"]
["Bis:","2012-07-31"]
[]
[null,"KURZE STELLVERTRETUNG BIS 4 WOCHEN :",{"$f":"H9","v":6.4803496284116358E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I9/Background!$D$2","v":6.4803496284116358E-2},{"$f":"I13+J14+J26","v":123.51546391752578}]
[]
[null,"UNTERRICHT","2 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$C$56","v":"97%"},null,null,0.97,null,null,null,{"$f":"I13+J14+I26","v":119.81}]
[null,{"$f":"UI_beschäftigungsgrad!$C$57","v":"Altersentlastung"},null,null,null,null,null,{"$f":"I13/Background!$D$2","v":0},0]
[null,{"$f":"UI_beschäftigungsgrad!$C$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I9>0,I14/I9,0)","v":0},{"$f":"E12+E14","v":0.97},null,{"$f":"J14/Background!$D$2","v":6.2859391395592865E-2},{"$f":"-I26","v":0},119.81]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]
[null,{"$f":"UI_beschäftigungsgrad!$C$69","v":"3%"},null,null,0.03,null,null,null,{"$f":"I12/E12*E25","v":3.7054639175257731}]
[null,null,null,null,{"$f":"IF(I9>0,I26/I9,0)","v":0},{"$f":"E25+E26","v":0.03},null,{"$f":"J26/Background!$D$2","v":1.9441048885234906E-3},0,{"$f":"I25+I26","v":3.7054639175257731}]
[]
[null,null,null,null,null,null,null,null,null,"Dieser Vertrag muss im Wochenlohn entschädigt werden."]

{"sheet":"print_sonderB","index":10,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9]]}
["ANHANG ÜBERZEIT"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","unbefristet"]
[]
[null,"ÜBERZEIT UNTERRICHT :",{"$f":"H9","v":6.2859391395592865E-2},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I9/Background!$D$2","v":6.2859391395592865E-2},{"$f":"J14","v":119.81}]
[]
[null,"UNTERRICHT","2 Lektionen"]
[null,{"$f":"UI_beschäftigungsgrad!$M$56","v":"100%"},null,null,1,null,null,null,{"$f":"J14","v":119.81}]
[]
[null,{"$f":"UI_beschäftigungsgrad!$M$58","v":"± Flexibilisierung"},null,null,{"$f":"IF(I9>0,I14/I9,0)","v":0},{"$f":"E12+E14","v":1},null,{"$f":"J14/Background!$D$2","v":6.2859391395592865E-2},0,119.81]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[]
[]
[]
[null,"LEHRPERSON"]

{"sheet":"print_sonderC","index":11,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,7,1,9],[6,1,8,1],[6,2,8,2],[6,4,6,5],[6,7,6,9],[7,8,7,9],[8,8,8,9]]}
["ANHANG ARBEITSFELD SCHULE"]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-29"}]
[null,{"$f":"Background!$Q$2","v":"asdf asdf"}]
["Von:","2015-08-01"]
["Bis:","2016-07-31"]
[]
[null,"AUSSCHLIESSLICH ARBEITSFELD SCHULE :",{"$f":"H9","v":0},null,"NORMALISIERT",null,null,"EFFEKTIV"]
[null,null,null,null,null,null,null,"in %","in Std."]
[null,null,null,null,null,null,null,{"$f":"I9/Background!$D$2","v":0},{"$f":"J22+I13","v":0}]
[]
[null,"UNTERRICHT"]
[]
[null,"Altersentlastung",null,null,null,null,null,{"$f":"I13/Background!$D$2","v":0},0]
[]
[]
[null,"SCHÜLERINNEN / SCHÜLER"]
[]
[]
[]
[null,"SCHULE"]
[null,null,null,null,{"$f":"IF(I22=0,1,0)","v":1}]
[null,{"$f":"UI_beschäftigungsgrad!$C$87","v":"± Flexibilisierung :"},{"$f":"IF(Background!$I$17=\"\",\"\",Background!$I$17)","v":""},null,{"$f":"IF(I9>0,I22/I9,0)","v":0},{"$f":"E21+E22","v":1},null,{"$f":"J22/Background!$D$2","v":0},{"$f":"Background!$J$17","v":0},{"$f":"I22","v":0}]
[]
[null,"LEHRPERSON"]

{"sheet":"Tabelle1","index":12,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Damit das Tool funktionniert müssen Makros aktiviert werden."]
[null,"Bitte aktivieren Sie im Tab \"Datei\" die Inhalte für diese Arbeitsmappe."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null," "]