{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Berechnung exkl. 13.","Berechnung inkl. 13.","Lohntabelle"],"not_rendered":{"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Berechnung exkl. 13.","index":0,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[2,2,3,4]]}
["Berechnung unbezahlter Urlaub für:"]
["Urlaub von / bis:"]
[]
["Grundlagen:"]
[]
["Lohn-Kategorie und Lohnklasse",{"$nulls":3},"Lohn wählen"]
["Beschäftigungsgrad",{"$nulls":3},{"v":0,"d":"0.00%"}]
["Jahreslohn exkl. 13. ML",{"$nulls":3},{"$f":"ROUND((VLOOKUP(E6,Lohntabelle!A:C,3,FALSE)*E7),1)","v":{"v":0,"d":"0.00"}}]
["Monatslohn exkl. 13. ML",{"$nulls":3},{"$f":"ROUND(E8/12,1)","v":{"v":0,"d":"0.00"}}]
["Anzahl Wochen Urlaub (Anzahl Schulwochen)",{"$nulls":3},{"v":0,"d":"0.00"}]
["Gesamter Lohnabzug1 exkl. 13. ML",{"$nulls":3},{"$f":"ROUND(E8/39*E10,1)","v":{"v":0,"d":"0.00"}}]
["Kinderzulage pro Monat2"]
["Klassenlehrerzulage pro Monat3  (Ansatz 100%: Kiga+PL: Fr. 162.10 / OS Fr. 203.90)"]
[]
["Berechnung (es werden nur die Monate mit Lohnabzug aufgeführt)"]
[]
["Monat","ordentlicher Monatslohn","Lohnabzug","Lohn","Klassen-lehrerzulage","Kinderzulage","Bruttolohn","sgpk-Beitrag für\nRisikoversicherung4"]
["Januar",null,{"$f":"IF(B18=\"\",\"\",(IF(SUM(B18:B18)>$E$11,($B$30-E9)-$E$11,-B18)))","v":""},{"$f":"IF(B18>0,B18+C18,\"\")","v":""},{"$f":"IF(B18>0,$E$13,\"\")","v":""},{"$f":"IF(B18>0,$E$12,\"\")","v":""},{"$f":"IF(B18=\"\",\"\",SUM(D18:F18))","v":""}]
["Februar",null,{"$f":"IF(B19=\"\",\"\",(IF(SUM(B18:B19)>$E$11,($B$30-E9)-$E$11,-B19)))","v":""},{"$f":"IF(B19>0,B19+C19,\"\")","v":""},"","",{"$f":"IF(B19=\"\",\"\",SUM(D19:F19))","v":""}]
["März",null,{"$f":"IF(B20=\"\",\"\",(IF(SUM(B18:B20)>$E$11,($B$30-E9)-$E$11,-B20)))","v":""},"","","",""]
["April",null,{"$f":"IF(B21=\"\",\"\",(IF(SUM(B18:B21)>$E$11,($B$30-E9)-$E$11,-B21)))","v":""},"","","",""]
["Mai",null,{"$f":"IF(B22=\"\",\"\",(IF(SUM(B18:B22)>$E$11,($B$30-E9)-$E$11,-B22)))","v":""},"","","",""]
["Juni",null,{"$f":"IF(B23=\"\",\"\",(IF(SUM(B18:B23)>$E$11,($B$30-E9)-$E$11,-B23)))","v":""},"","","",""]
["Juli",null,{"$f":"IF(B24=\"\",\"\",(IF(SUM(B18:B24)>$E$11,($B$30-E9)-$E$11,-B24)))","v":""},"","","",""]
["August",null,{"$f":"IF(B25=\"\",\"\",(IF(SUM(B18:B25)>$E$11,($B$30-E9)-$E$11,-B25)))","v":""},"","","",""]
["September",null,{"$f":"IF(B26=\"\",\"\",(IF(SUM(B18:B26)>$E$11,($B$30-E9)-$E$11,-B26)))","v":""},"","","",""]
["Oktober",null,{"$f":"IF(B27=\"\",\"\",(IF(SUM(B18:B27)>$E$11,($B$30-E9)-$E$11,-B27)))","v":""},"","","",""]
["November",null,{"$f":"IF(B28=\"\",\"\",(IF(SUM(B18:B28)>$E$11,($B$30-E9)-$E$11,-B28)))","v":""},"","","",""]
["Dezember",null,{"$f":"IF(B29=\"\",\"\",(IF(SUM(B18:B29)>$E$11,($B$30-E9)-$E$11,-B29)))","v":""},"","","",""]
["Kontrollsumme",{"$f":"SUM(B18:B29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C18:C29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D18:D29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["Legende:"]
["1 Für jede nicht gleistete Unterrichtswoche wird 1/39 des Jahreslohn inkl. 13. Monatslohn abgezogen (gem. SGV Handbuch VS, 3.2.3)."]
["2 Eine allfällige Kinderzulage wird bei weniger als 4 Monaten Urlaub weiter vergütet."]
["3 Eine allfällige Klassenlehrerzulage wird gemäss individueller Regelung des Schulträgers weitervergütet."]
["4 Empfehlung: bei einem unbezahlten Urlaub von mehr als 7 Tagen trägt die Lehrperson sowohl die AN- als auch die AG-Beiträge für die Weiterführung der Risikoversicherung. "]
["  Für die Beitragsberechnung steht ein separates Excel-Tool zur Verfügung"]
[]
["Unfallversicherung: Ab dem 31. Tag des Urlaubes besteht kein Unfallversicherungsschutz mehr gemäss UVG. Der Arbeitnehmer kann ab dem 31. Tag eine Abredeversicherung abschliessen."]
["Krankheit: Während eines unbezahlten Urlaubes ruht das Dienstverhältnis. Der Arbeitnehmer hat auch bei Krankheit während des Urlaubes keinen Lohnanspruch."]

{"sheet":"Berechnung inkl. 13.","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[0,2,0,4],[1,2,1,4],[2,3,3,4]]}
["Berechnung unbezahlter Urlaub für:"]
["Urlaub von / bis:"]
[{"$nulls":3},"gelbe Felder ausfüllen"]
["Grundlagen:"]
[]
["Lohn-Kategorie und Lohnklasse",{"$nulls":3},"Lohn wählen"]
["Beschäftigungsgrad",{"$nulls":3},{"v":0,"d":"0.00%"}]
["Jahreslohn inkl. 13. ML",{"$nulls":3},{"$f":"ROUND(IF(D6=\"KIG\",VLOOKUP(E6,Lohntabelle!A:B,2,FALSE)/24*E7,VLOOKUP(E6,Lohntabelle!A:B,2,FALSE)*E7),1)","v":{"v":0,"d":"0.00"}}]
["Monatslohn exkl. 13. ML",{"$nulls":3},{"$f":"ROUND(E8/13,1)","v":{"v":0,"d":"0.00"}}]
["Anzahl Wochen Urlaub (Anzahl Schulwochen)"]
["Gesamter Lohnabzug1 inkl. 13. ML",{"$nulls":3},{"$f":"ROUND(E8/39*E10,1)","v":{"v":0,"d":"0.00"}}]
["Kinderzulage pro Monat2"]
["Klassenlehrerzulage pro Monat3  (Ansatz 100%: Kiga+PL: Fr. 162.10 / OS Fr. 203.90)"]
[]
["Berechnung (es sind nur die Monate mit Lohnabzug aufgeführt)"]
[]
["Monat","ordentliches Monatsgehalt","Lohnabzug","Gehalt","Klassen-lehrerzulage","Kinderzulage","Bruttolohn","sgpk-Beitrag für\nRisikoversicherung4"]
["Januar",null,{"$f":"IF(B18=\"\",\"\",(IF(SUM(B18:B18)>$E$11,($B$30-E9)-$E$11,-B18)))","v":""},{"$f":"IF(B18>0,B18+C18,\"\")","v":""},{"$f":"IF(B18>0,$E$13,\"\")","v":""},{"$f":"IF(B18>0,$E$12,\"\")","v":""},{"$f":"IF(B18=\"\",\"\",SUM(D18:F18))","v":""}]
["Februar",null,{"$f":"IF(B19=\"\",\"\",(IF(SUM(B18:B19)>$E$11,($B$30-E9)-$E$11,-B19)))","v":""},{"$f":"IF(B19>0,B19+C19,\"\")","v":""},"","",{"$f":"IF(B19=\"\",\"\",SUM(D19:F19))","v":""}]
["März",null,{"$f":"IF(B20=\"\",\"\",(IF(SUM(B18:B20)>$E$11,($B$30-E9)-$E$11,-B20)))","v":""},"","","",""]
["April",null,{"$f":"IF(B21=\"\",\"\",(IF(SUM(B18:B21)>$E$11,($B$30-E9)-$E$11,-B21)))","v":""},"","","",""]
["Mai",null,{"$f":"IF(B22=\"\",\"\",(IF(SUM(B18:B22)>$E$11,($B$30-E9)-$E$11,-B22)))","v":""},"","","",""]
["Juni",null,{"$f":"IF(B23=\"\",\"\",(IF(SUM(B18:B23)>$E$11,($B$30-E9)-$E$11,-B23)))","v":""},"","","",""]
["Juli",null,{"$f":"IF(B24=\"\",\"\",(IF(SUM(B18:B24)>$E$11,($B$30-E9)-$E$11,-B24)))","v":""},"","","",""]
["August",null,{"$f":"IF(B25=\"\",\"\",(IF(SUM(B18:B25)>$E$11,($B$30-E9)-$E$11,-B25)))","v":""},"","","",""]
["September",null,{"$f":"IF(B26=\"\",\"\",(IF(SUM(B18:B26)>$E$11,($B$30-E9)-$E$11,-B26)))","v":""},"","","",""]
["Oktober",null,{"$f":"IF(B27=\"\",\"\",(IF(SUM(B18:B27)>$E$11,($B$30-E9)-$E$11,-B27)))","v":""},"","","",""]
["November",null,{"$f":"IF(B28=\"\",\"\",(IF(SUM(B18:B28)>$E$11,($B$30-E9)-$E$11,-B28)))","v":""},"","","",""]
["Dezember",null,{"$f":"IF(B29=\"\",\"\",(IF(SUM(B18:B29)>$E$11,($B$30-E9)-$E$11,-B29)))","v":""},"","","",""]
["Kontrollsumme",{"$f":"SUM(B18:B29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C18:C29)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D18:D29)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["Legende:"]
["1 Für jede nicht gleistete Unterrichtswoche wird 1/39 des Jahreslohn inkl. 13. Monatslohn abgezogen (gem. SGV Handbuch VS, 3.2.3)."]
["2 Eine allfällige Kinderzulage wird bei weniger als 4 Monaten Urlaub weiter vergütet."]
["3 Eine allfällige Klassenlehrerzulage wird gemäss individueller Regelung des Schulträgers weitervergütet."]
["4 Empfehlung: bei einem unbezahlten Urlaub von mehr als 7 Tagen trägt die Lehrperson sowohl die AN- als auch die AG-Beiträge für die Weiterführung der Risikoversicherung. "]
["  Für die Beitragsberechnung steht ein separates Excel-Tool zur Verfügung"]
[]
["Unfallversicherung: Ab dem 31. Tag des Urlaubes besteht kein Unfallversicherungsschutz mehr gemäss UVG. Der Arbeitnehmer kann ab dem 31. Tag eine Abredeversicherung abschliessen."]
["Krankheit: Während eines unbezahlten Urlaubes ruht das Dienstverhältnis. Der Arbeitnehmer hat auch bei Krankheit während des Urlaubes keinen Lohnanspruch."]

{"sheet":"Lohntabelle","index":2,"n_rows":108,"n_cols":3,"rows_kept":108}
["Lohn wählen",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["PS1",{"v":78884.9,"d":"78,884.90"},{"v":72816.85,"d":"72,816.85"}]
["PS2",{"v":78884.9,"d":"78,884.90"},{"v":72816.85,"d":"72,816.85"}]
["PS3",{"v":78884.9,"d":"78,884.90"},{"v":72816.85,"d":"72,816.85"}]
["PS4",{"v":78884.9,"d":"78,884.90"},{"v":72816.85,"d":"72,816.85"}]
["PS5",{"v":82131.9,"d":"82,131.90"},{"v":75814.05,"d":"75,814.05"}]
["PS6",{"v":85380.2,"d":"85,380.20"},{"v":78812.5,"d":"78,812.50"}]
["PS7",{"v":88628.7,"d":"88,628.70"},{"v":81811.1,"d":"81,811.10"}]
["PS8",{"v":91877.1,"d":"91,877.10"},{"v":84809.65,"d":"84,809.65"}]
["PS9",{"v":95125.45,"d":"95,125.45"},{"v":87808.1,"d":"87,808.10"}]
["PS10",{"v":95125.45,"d":"95,125.45"},{"v":87808.1,"d":"87,808.10"}]
["PS11",{"v":95125.45,"d":"95,125.45"},{"v":87808.1,"d":"87,808.10"}]
["PS12",{"v":95125.45,"d":"95,125.45"},{"v":87808.1,"d":"87,808.10"}]
["PS13",{"v":98141.55,"d":"98,141.55"},{"v":90592.2,"d":"90,592.20"}]
["PS14",{"v":101157.8,"d":"101,157.80"},{"v":93376.45,"d":"93,376.45"}]
["PS15",{"v":104174.05,"d":"104,174.05"},{"v":96160.65,"d":"96,160.65"}]
["PS16",{"v":107190.2,"d":"107,190.20"},{"v":98944.8,"d":"98,944.80"}]
["PS17",{"v":110206.3,"d":"110,206.30"},{"v":101728.9,"d":"101,728.90"}]
["PS18",{"v":110206.3,"d":"110,206.30"},{"v":101728.9,"d":"101,728.90"}]
["PS19",{"v":110206.3,"d":"110,206.30"},{"v":101728.9,"d":"101,728.90"}]
["PS20",{"v":110206.3,"d":"110,206.30"},{"v":101728.9,"d":"101,728.90"}]
["PS21",{"v":110206.3,"d":"110,206.30"},{"v":101728.9,"d":"101,728.90"}]
["PS22",{"v":111366.05,"d":"111,366.05"},{"v":102799.45,"d":"102,799.45"}]
["PS23",{"v":112641.9,"d":"112,641.90"},{"v":103977.15,"d":"103,977.15"}]
["PS24",{"v":113801.6,"d":"113,801.60"},{"v":105047.65,"d":"105,047.65"}]
["PS25",{"v":114962.75,"d":"114,962.75"},{"v":106119.45,"d":"106,119.45"}]
["PS26",{"v":116238.65,"d":"116,238.65"},{"v":107297.2,"d":"107,297.20"}]
["PS27",{"v":117398.4,"d":"117,398.40"},{"v":108367.75,"d":"108,367.75"}]
[]
["OS1",{"v":91297.95,"d":"91,297.95"},{"v":84275.05,"d":"84,275.05"}]
["OS2",{"v":95241.65,"d":"95,241.65"},{"v":87915.35,"d":"87,915.35"}]
["OS3",{"v":99185.35,"d":"99,185.35"},{"v":91555.7,"d":"91,555.70"}]
["OS4",{"v":99185.35,"d":"99,185.35"},{"v":91555.7,"d":"91,555.70"}]
["OS5",{"v":103245.05,"d":"103,245.05"},{"v":95303.1,"d":"95,303.10"}]
["OS6",{"v":107306.3,"d":"107,306.30"},{"v":99051.95,"d":"99,051.95"}]
["OS7",{"v":111366.05,"d":"111,366.05"},{"v":102799.45,"d":"102,799.45"}]
["OS8",{"v":115427.45,"d":"115,427.45"},{"v":106548.4,"d":"106,548.40"}]
["OS9",{"v":115427.45,"d":"115,427.45"},{"v":106548.4,"d":"106,548.40"}]
["OS10",{"v":115427.45,"d":"115,427.45"},{"v":106548.4,"d":"106,548.40"}]
["OS11",{"v":115427.45,"d":"115,427.45"},{"v":106548.4,"d":"106,548.40"}]
["OS12",{"v":119254.8,"d":"119,254.80"},{"v":110081.35,"d":"110,081.35"}]
["OS13",{"v":123082.3,"d":"123,082.30"},{"v":113614.45,"d":"113,614.45"}]
["OS14",{"v":126911.4,"d":"126,911.40"},{"v":117149,"d":"117,149.00"}]
["OS15",{"v":130738.95,"d":"130,738.95"},{"v":120682.1,"d":"120,682.10"}]
["OS16",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS17",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS18",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS19",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS20",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS21",{"v":134567.9,"d":"134,567.90"},{"v":124216.5,"d":"124,216.50"}]
["OS22",{"v":135147.1,"d":"135,147.10"},{"v":124751.15,"d":"124,751.15"}]
["OS23",{"v":135727.7,"d":"135,727.70"},{"v":125287.1,"d":"125,287.10"}]
["OS24",{"v":136308.3,"d":"136,308.30"},{"v":125823.05,"d":"125,823.05"}]
["OS25",{"v":136887.45,"d":"136,887.45"},{"v":126357.65,"d":"126,357.65"}]
[]
["HP1",{"v":80044.65,"d":"80,044.65"},{"v":73887.35,"d":"73,887.35"}]
["HP2",{"v":82944.75,"d":"82,944.75"},{"v":76564.4,"d":"76,564.40"}]
["HP3",{"v":85844.85,"d":"85,844.85"},{"v":79241.4,"d":"79,241.40"}]
["HP4",{"v":85844.85,"d":"85,844.85"},{"v":79241.4,"d":"79,241.40"}]
["HP5",{"v":90485.15,"d":"90,485.15"},{"v":83524.75,"d":"83,524.75"}]
["HP6",{"v":95125.45,"d":"95,125.45"},{"v":87808.1,"d":"87,808.10"}]
["HP7",{"v":99765.9,"d":"99,765.90"},{"v":92091.6,"d":"92,091.60"}]
["HP8",{"v":104406.3,"d":"104,406.30"},{"v":96375.05,"d":"96,375.05"}]
["HP9",{"v":109046.65,"d":"109,046.65"},{"v":100658.45,"d":"100,658.45"}]
["HP10",{"v":109046.65,"d":"109,046.65"},{"v":100658.45,"d":"100,658.45"}]
["HP11",{"v":109046.65,"d":"109,046.65"},{"v":100658.45,"d":"100,658.45"}]
["HP12",{"v":109046.65,"d":"109,046.65"},{"v":100658.45,"d":"100,658.45"}]
["HP13",{"v":111946.7,"d":"111,946.70"},{"v":103335.4,"d":"103,335.40"}]
["HP14",{"v":114846.7,"d":"114,846.70"},{"v":106012.35,"d":"106,012.35"}]
["HP15",{"v":117746.75,"d":"117,746.75"},{"v":108689.3,"d":"108,689.30"}]
["HP16",{"v":120646.9,"d":"120,646.90"},{"v":111366.35,"d":"111,366.35"}]
["HP17",{"v":123546.95,"d":"123,546.95"},{"v":114043.35,"d":"114,043.35"}]
["HP18",{"v":123546.95,"d":"123,546.95"},{"v":114043.35,"d":"114,043.35"}]
["HP19",{"v":123546.95,"d":"123,546.95"},{"v":114043.35,"d":"114,043.35"}]
["HP20",{"v":123546.95,"d":"123,546.95"},{"v":114043.35,"d":"114,043.35"}]
["HP21",{"v":123546.95,"d":"123,546.95"},{"v":114043.35,"d":"114,043.35"}]
["HP22",{"v":124706.6,"d":"124,706.60"},{"v":115113.8,"d":"115,113.80"}]
["HP23",{"v":125866.35,"d":"125,866.35"},{"v":116184.3,"d":"116,184.30"}]
["HP24",{"v":127027.55,"d":"127,027.55"},{"v":117256.2,"d":"117,256.20"}]
["HP25",{"v":128187.25,"d":"128,187.25"},{"v":118326.7,"d":"118,326.70"}]
[]
["MSo1",{"v":64731.25,"d":"64,731.25"},{"v":59751.9,"d":"59,751.90"}]
["MSo2",{"v":67863.9,"d":"67,863.90"},{"v":62643.6,"d":"62,643.60"}]
["MSo3",{"v":70996.4,"d":"70,996.40"},{"v":65535.15,"d":"65,535.15"}]
["MSo4",{"v":70996.4,"d":"70,996.40"},{"v":65535.15,"d":"65,535.15"}]
["MSo5",{"v":73918.7,"d":"73,918.70"},{"v":68232.65,"d":"68,232.65"}]
["MSo6",{"v":76842.2,"d":"76,842.20"},{"v":70931.25,"d":"70,931.25"}]
["MSo7",{"v":79765.85,"d":"79,765.85"},{"v":73630,"d":"73,630.00"}]
["MSo8",{"v":82689.45,"d":"82,689.45"},{"v":76328.7,"d":"76,328.70"}]
["MSo9",{"v":85612.9,"d":"85,612.90"},{"v":79027.3,"d":"79,027.30"}]
["MSo10",{"v":85612.9,"d":"85,612.90"},{"v":79027.3,"d":"79,027.30"}]
["MSo11",{"v":85612.9,"d":"85,612.90"},{"v":79027.3,"d":"79,027.30"}]
["MSo12",{"v":85612.9,"d":"85,612.90"},{"v":79027.3,"d":"79,027.30"}]
["MSo13",{"v":88327.4,"d":"88,327.40"},{"v":81533,"d":"81,533.00"}]
["MSo14",{"v":91042.05,"d":"91,042.05"},{"v":84038.8,"d":"84,038.80"}]
["MSo15",{"v":93756.65,"d":"93,756.65"},{"v":86544.6,"d":"86,544.60"}]
["MSo16",{"v":96471.15,"d":"96,471.15"},{"v":89050.3,"d":"89,050.30"}]
["MSo17",{"v":99185.65,"d":"99,185.65"},{"v":91556,"d":"91,556.00"}]
["MSo18",{"v":99185.65,"d":"99,185.65"},{"v":91556,"d":"91,556.00"}]
["MSo19",{"v":99185.65,"d":"99,185.65"},{"v":91556,"d":"91,556.00"}]
["MSo20",{"v":99185.65,"d":"99,185.65"},{"v":91556,"d":"91,556.00"}]
["MSo21",{"v":99185.65,"d":"99,185.65"},{"v":91556,"d":"91,556.00"}]
["MSo22",{"v":100229.45,"d":"100,229.45"},{"v":92519.5,"d":"92,519.50"}]
["MSo23",{"v":101377.75,"d":"101,377.75"},{"v":93579.45,"d":"93,579.45"}]
["MSo24",{"v":102421.5,"d":"102,421.50"},{"v":94542.9,"d":"94,542.90"}]
["MSo25",{"v":103466.45,"d":"103,466.45"},{"v":95507.5,"d":"95,507.50"}]
["MSo26",{"v":104614.8,"d":"104,614.80"},{"v":96567.5,"d":"96,567.50"}]
["MSo27",{"v":105658.6,"d":"105,658.60"},{"v":97531,"d":"97,531.00"}]