{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Deutsch","Français","Mehrsprachig Deutsch","Mehrsprachig Franz","Tabelle1","Anleitung"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":7,"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":"Deutsch","index":0,"n_rows":85,"n_cols":19,"rows_kept":85,"cut":false,"hidden":false,"merged":[[6,7,9,7],[6,8,9,8],[27,5,27,6],[4,3,4,6],[4,1,4,2],[2,1,2,2],[3,1,3,2],[3,3,3,6],[2,4,2,6],[2,7,5,8]]}
[null,null,null,null,null,null,null,null,"2019.ERZ.96 / 681538"]
[]
[null,"SOE-Key: ",null,null,null,null,null,"Referenzwerte ePM"]
[null,"Schule:",null,{"$f":"IF(D3=\"\",\"\",IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)),\"SOE-Key ungültig\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)))","v":""}]
["\n","Trägergemeinde:",null,{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,"gültig per 1.8.2021\nSJ 2021/22","gültig ab 1.8.2022\nSJ 2022/23"]
["Berechnung der Pools für die Volksschule, LAV, Anhang 4"]
["Wird mit der Freigabe der ePM 1. Semester unterschrieben an das Regionale Schulinspektorat eingereicht."]
[]
[]
["Schulleitungspool"]
["LAV, Anhang 4 Kap. 1:   a * 0.062 + b * 0.106 + c * 0.194 = SL-Pool-%"]
[]
["Korrekturfaktor für Lektionen in Abhängigkeit der Schulwochen (=SW): ",null,null,null,"b * SW / 39"]
[]
["Anzahl Auszubildende (a)"]
[]
["Anzahl Lektionen (b) gem. Pensenmeldung pro Schule mit 1)",null,null,38,"SW pro Jahr"]
[null,null,null,39,"SW pro Jahr"]
[]
["Anzahl Lektionen (b); SW-Korrekturfaktor berücksichtigt",null,null,null,null,null,{"$f":"G19*D19/39 + G20*D20/39","v":0}]
[]
["Anzahl Lehrkräfte (c) gem. Pensenmeldung pro Schule "]
["(exkl. Lehrkräfte für Spezialunterricht* und exkl. 1 Person mit Schulleitungsfunktion) "]
[]
["Bei zweisprachigen Schulen (+  a *  0.03 ) mit x markieren ",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[null,null,null,null,null,{"$f":"ROUND(0.062 *G17 + 0.106 * G22 + 0.194 * G24,3)","v":0}]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IF(SUM(G17,G19:G20,G22:G24)=0,\"\",IF((G27<>\"x\"),F28,F28 + G17 * 0.03))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE))","v":""},{"$f":"IF(L29<>\"\",L29,IF(M29<>\"\",M29,IF(N29<>\"\",N29,IF(O29<>\"\",O29,IF(P29<>\"\",P29,IF(Q29<>\"\",Q29,IF(R29<>\"\",R29,IF(S29<>\"\",S29,\"\"))))))))","v":""},null,{"$f":"IF(G29=\"\",0,ABS(H29-G29))","v":0},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29>3),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29>6),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29<=6),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$K$29>3),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29>=2.5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29<2.5),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=2.5),ROUND($G$29/500,2)*500,\"\"))","v":""}]
[]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G29<2.5,G29,ROUND(G29/500,2)*500),\"\")","v":""}]
[]
[]
["Pool für Spezialaufgaben (60% vom gerundeten Schulleitungspool, LAV, Anhang 4, Ziff. 3.3)"]
[]
["LAV, Anhang 4, Ziff. 3.2: Vergrösserung (Andere Unterrichtsspr. oder Klassenaustausch)"]
["bis 9 beteiligte Klassen (+3.5%), mit x markieren"]
["ab 10 beteiligte Klassen (+7%), mit x markieren",null,{"$f":"IF(AND(G37=\"x\",G38=\"x\"),\"Nur 1 Feld markieren!\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISTEXT(I29),\"\",I29*0.6)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G37=\"x\",(G39+3.5),IF(G38=\"x\",(G39+7),G39))","v":""}]
["Beschäftigungsgradprozente Schulpool/Spezialaufgaben",null,null,null,null,null,{"$f":"IFERROR(G40,\"\")","v":""},null,{"$f":"$G$41","v":""}]
[]
["Leitungspool Spezialunterricht (IF, eU, Art. 16b LADV, Logo und Psychomotorik)"]
[]
["LAV, Anhang 4 Kap. 2:   d * 0.106 + e * 0.194 = SL-Pool-%"]
["Korrekturfaktor für Lektionen in Abhängigkeit der Schulwochen (=SW): ",null,null,null,"d * SW / 39"]
[]
["Anzahl Lektionen (d) für Spezialunterricht gem. Pensen-",null,null,38,"SW pro Jahr"]
["meldung pro Schule mit 2) exkl. Lekt. besonderes VS-Angebot",null,null,39,"SW pro Jahr"]
[]
["Anzahl Lektionen (d);  SW-Korrekturfaktor berücksichtigt",null,null,null,null,null,{"$f":"G48*D48/39 + G49*D49/39","v":0}]
[]
["Anzahl Lehrkräfte (e) für Spezialunterricht gem. Pensenmeldung pro Schule 3)",null,null,null,null,{"$f":"ROUND(G51*0.106+G53*0.194,3)","v":0}]
["(exkl. 1 Person mit Schulleitungsfunktion Spezialunterricht) ",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IF(F53<>0,F53,\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE))","v":""},{"$f":"IF(L56<>\"\",L56,IF(M56<>\"\",M56,IF(N56<>\"\",N56,IF(O56<>\"\",O56,IF(P56<>\"\",P56,IF(Q56<>\"\",Q56,IF(R56<>\"\",R56,IF(S56<>\"\",S56,\"\"))))))))","v":""},null,{"$f":"IF(G56=\"\",0,ABS(H56-G56))","v":0},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56>3),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56<=3),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56>6),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56<=6),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$K$56>3),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56>=2.5,$K$56<=3),$H$56,\"\")))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56<2.5),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=2.5),ROUND($G$56/500,2)*500,\"\"))","v":""}]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G56<2.5,G56,ROUND(G56/500,2)*500),\"\")","v":""}]
[]
[]
["Sonderpool \"Integrative Schulung von SuS mit verstärkten sonderpädagogischen Massnahmen\""]
["Massnahme im Zusammenhang mit REVOS 2020"]
["Anzahl Schülerinnen und Schüler",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G63),0,G63)","v":0}]
["Beschäftigungsgradprozente Sonderpool \"Integrative Schulung\"",null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",(G63*1))","v":""},null,{"$f":"G64","v":""}]
[]
["Sonderpool \"Mentoring\" vom 24. Oktober 2018 gemäss LAV, Art. 94"]
["Massnahme im Zusammenhang mit dem Mangel an Lehrpersonen"]
["Anzahl Mentorate gemäss Allgemeinverfügung vom 24. Oktober 2018",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G68),0,G68)","v":0}]
["Anzahl Berufseinsteigende gemäss Allgemeinverfügung vom 24. Oktober 2018 4)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G69),0,G69)","v":0}]
[null,null,null,{"$f":"IF(AND(J69>=1,J68=0),\"Anz. Mentorate erfassen\",\"\")","v":""}]
["Beschäftigungsgradprozente Sonderpool \"Mentoring\"",null,null,null,null,null,{"$f":"IF(G68=\"\",\"\",(G68+G69)*3)","v":""},null,{"$f":"G71","v":""}]
[]
[]
["1) Alle Lektionen exkl. Klassenlehrerlektionen und exkl. Lektionen gemäss 2)"]
["2) Lektionen für IF, eU, Art. 16b LADV, Logo und Psychomotorik (exkl. Lekt. besonderes VS-Angebot)"]
["3) Bei Doppelfunktion (z.B. Logo+DaZ) Lehrkraft nur 1x zählen. Massgebend ist das grössere Pensum."]
["4) Sofern der Beschäftigungsgrad 40% oder mehr beträgt und mindestens ein Semester dauert."]
[]
["Die Richtigkeit bestätigen:"]
[]
["Datum:","Schulleitung:"]
[]
["Datum:","Zuständige Gemeindebehörde:"]
[]
["Datum:","Schulinspektorat:"]

{"sheet":"Français","index":1,"n_rows":85,"n_cols":19,"rows_kept":85,"cut":false,"hidden":false,"merged":[[6,7,9,7],[6,8,9,8],[27,5,27,6],[2,1,2,2],[2,4,2,6],[2,7,5,8],[3,1,3,2],[3,3,3,6],[4,1,4,2],[4,3,4,6]]}
[null,null,null,null,null,null,null,null,"2019.ERZ.96 / 681538"]
[]
[null,"US-Key:",null,null,null,null,null,"Valeurs de référence CdPe"]
[null,"Etablissement:",null,{"$f":"IF(D3=\"\",\"\",IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)),\"US-Key invalide\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)))","v":""}]
["\n","Commune:",null,{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,"valable à partir du 1.8.2021\nAs 2021/22","valable à partir du 1.8.2022\nAs 2022/23"]
["Calcul des pools de l'école obligatoire, OSE, annexe 4"]
["Ce formulaire doit être signé et remis à l'Inspection scolaire régional avec la validation de la CdPe du 1er semestre."]
[]
[]
["Pool de direction "]
["OSE, annexe 4 chap. 1:  a * 0.062 + b * 0.106 + c * 0.194 = Pool de direction %"]
[]
["Facteur de correction pour les leçons en fonction des semaines d'école (=SE): ",null,null,null,null,"b * SE / 39"]
[]
["Nombre d'élèves (a)"]
[]
["Nombre de leçons (b) selon la comm. des progr. par établissement 1)",null,null,null,38,"SE par an"]
[null,null,null,null,39,"SE par an"]
[]
["Nombre de leçons (b) avec le facteur de correction SE",null,null,null,null,null,{"$f":"G19*E19/39 + G20*E20/39","v":0}]
[]
["Nombre d'enseignants (c) selon comm. des progr. par établissement (ens. de l'enseign."]
["spécialisé et une personne exerçant une fonction de direction d'école exclus) "]
[]
["Ecoles bilingues, (+  a *  0.03 ) marquer avec x",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[null,null,null,null,null,{"$f":"ROUND(0.062 *G17 + 0.106 * G22 + 0.194 * G24,3)","v":0}]
["Degré d'occupation total pour le pool de direction (dès 2.5% arrondi)",null,null,null,null,null,{"$f":"IF(SUM(G17,G19:G20,G22:G24)=0,\"\",IF((G27<>\"x\"),F28,F28 + G17 * 0.03))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE))","v":""},{"$f":"IF(L29<>\"\",L29,IF(M29<>\"\",M29,IF(N29<>\"\",N29,IF(O29<>\"\",O29,IF(P29<>\"\",P29,IF(Q29<>\"\",Q29,IF(R29<>\"\",R29,IF(S29<>\"\",S29,\"\"))))))))","v":""},null,{"$f":"IF(G29=\"\",0,ABS(H29-G29))","v":0},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29>3),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29>6),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29<=6),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$K$29>3),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29>=2.5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29<2.5),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=2.5),ROUND($G$29/500,2)*500,\"\"))","v":""}]
[]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G29<2.5,G29,ROUND(G29/500,2)*500),\"\")","v":""}]
[]
[]
["Pool destiné aux tâches spéciales (60% du pool de dir. arrondi, OSE, annexe 4, chiffre 3.3)"]
[]
["OSE, annexe 4, chiffre 3.2: Augmentation (autre langue d'enseign. ou échange de classes)"]
["Jusqu'à 9 classes impliquées (+3.5%), marquer avec x"]
["Dès 10 classes impliquées (+7%), marquer avec x",null,{"$f":"IF(AND(G37=\"x\",G38=\"x\"),\"Seulement marquer une croix!\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISTEXT(I29),\"\",I29*0.6)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G37=\"x\",(G39+3.5),IF(G38=\"x\",(G39+7),G39))","v":""}]
["Degré d'occupation pool général/tâches spéciales",null,null,null,null,null,{"$f":"IFERROR(G40,\"\")","v":""},null,{"$f":"$G$41","v":""}]
[]
["Le pool de direction de l'enseignement spécialisé",null,null,null,null,null," (SPA,SE,Art. 16b ODSE,logo. et psych.)"]
[]
["OSE, annexe 4 chap. 2:  d * 0.106 + e * 0.194 = Pool de direction %"]
["Facteur de correction pour les leçons en fonction des sem. d'école (=SE): ",null,null,null,"d * SE / 39"]
[]
["Nombre de leçons (d) de l'enseignement spécialisé selon comm.",null,null,null,38,"SE par an"]
["des progr. par établissement 2) excl.leçons offres spéc.de l'école oblig.",null,null,null,39,"SE par an"]
[]
["Nombre de leçons (d) avec le facteur de correction SE",null,null,null,null,null,{"$f":"G48*E48/39 + G49*E49/39","v":0}]
[]
["Nombre d'enseignants (e) de l'enseignement spécialisé selon comm. des progr. par",null,null,null,null,{"$f":"ROUND(G51*0.106+G53*0.194,3)","v":0}]
["établissement (une personne exerçant une fonction de direction de l'enseign. spécialisé exclue) 3)",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[]
["Degré d'occupation direction de l'enseign. Spécialisé (dès 2.5% arrondi)",null,null,null,null,null,{"$f":"IF(F53<>0,F53,\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE))","v":""},{"$f":"IF(L56<>\"\",L56,IF(M56<>\"\",M56,IF(N56<>\"\",N56,IF(O56<>\"\",O56,IF(P56<>\"\",P56,IF(Q56<>\"\",Q56,IF(R56<>\"\",R56,IF(S56<>\"\",S56,\"\"))))))))","v":""},null,{"$f":"IF(G56=\"\",0,ABS(H56-G56))","v":0},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56>3),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56<=3),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56>6),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56<=6),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$K$56>3),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56>=2.5,$K$56<=3),$H$56,\"\")))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56<2.5),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=2.5),ROUND($G$56/500,2)*500,\"\"))","v":""}]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G56<2.5,G56,ROUND(G56/500,2)*500),\"\")","v":""}]
[]
[]
["Pool spécial \"Scolarisation intégrée des élèves au bénéfice de mesures de pédagogie spécialisée renforcées\""]
["Mesure dans le cadre de REVOS 2020"]
["Nombre d'élèves",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G63),0,G63)","v":0}]
["Degré d'occupation pool spécial \"Scolarisation intégrée\"",null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",(G63*1))","v":""},null,{"$f":"G64","v":""}]
[]
[]
["Pool spécial \"Mentoring\" du 24 octobre 2018 selon OSE, Art 94"]
["Mesure liée à la pénurie d'enseignants"]
["Nombre de mentorat selon décision générale du 24 octobre 2018",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G69),0,G69)","v":0}]
["Nombre de béneficiaire selon décision générale du 24 octobre 2018 4)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G70),0,G70)","v":0}]
[null,null,null,{"$f":"IF(AND(J70>=1,J69=0),\"Anz. Mentorate erfassen\",\"\")","v":""}]
["Degré d'occupation pool spécial \"Mentoring\"",null,null,null,null,null,{"$f":"IF(G69=\"\",\"\",(G69+G70)*3)","v":""},null,{"$f":"G72","v":""}]
[]
["1) Toutes les leçons sauf les leçons de maître de classe et les leçons selon 2)"]
["2) Leçons pour soutien pédagogique ambulatoire, SE, Art. 16b ODSE, logopédie et psychomotricité (excl.leçons offres spéc.de l'école oblig.)"]
["3) En cas de double fonction (p. ex. logo. + FLS), ne compter l’enseignant-e qu’1x (programme le plus important)"]
["4) A condition que le taux d'occupation compte 40% ou plus et dure au moins un semestre"]
[]
["Certifié exact par"]
[]
["Date :","La direction d'école :"]
[]
["Date :","Autorité communale compétente  :"]
[]
["Date :","L'inspection scolaire :"]

{"sheet":"Mehrsprachig Deutsch","index":2,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":true,"merged":[[6,7,9,7],[6,8,9,8],[27,5,27,6],[2,1,2,2],[2,4,2,6],[2,7,5,8],[3,1,3,2],[3,3,3,6],[4,1,4,2],[4,3,4,6]]}
[null,null,null,null,null,null,null,null,"2019.ERZ.96 / 681538"]
[]
[null,"SOE-Key: ",null,null,null,null,null,"Referenzwerte ePM"]
[null,"Schule:",null,{"$f":"IF(D3=\"\",\"\",IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)),\"SOE-Key ungültig\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)))","v":""}]
["\n","Trägergemeinde:",null,{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,"gültig per 1.8.2021\nSJ 2021/22","gültig ab 1.8.2022\nSJ 2022/23"]
["Berechnung der Pools für die Volksschule, LAV, Anhang 4"]
["Wird mit der Freigabe der ePM 1. Semester unterschrieben an das Regionale Schulinspektorat eingereicht."]
[]
[]
["Schulleitungspool"]
["LAV, Anhang 4 Kap. 1:   a * 0.062 + b * 0.106 + c * 0.194 = SL-Pool-%"]
[]
["Korrekturfaktor für Lektionen in Abhängigkeit der Schulwochen (=SW): ",null,null,null,"b * SW / 39"]
[]
["Anzahl Auszubildende (a)"]
[]
["Anzahl Lektionen (b) gem. Pensenmeldung pro Schule mit 1)",null,null,38,"SW pro Jahr"]
[null,null,null,39,"SW pro Jahr"]
[]
["Anzahl Lektionen (b); SW-Korrekturfaktor berücksichtigt",null,null,null,null,null,{"$f":"G19*D19/39 + G20*D20/39","v":0}]
[]
["Anzahl Lehrkräfte (c) gem. Pensenmeldung pro Schule "]
["(exkl. Lehrkräfte für Spezialunterricht* und exkl. 1 Person mit Schulleitungsfunktion) "]
[]
["Bei zweisprachigen Schulen (+  a *  0.03 ) mit x markieren ",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[null,null,null,null,null,{"$f":"ROUND(0.062 *G17 + 0.106 * G22 + 0.194 * G24,3)","v":0}]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IF(SUM(G17,G19:G20,G22:G24)=0,\"\",IF((G27<>\"x\"),F28,F28 + G17 * 0.03))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE))","v":""},{"$f":"IF(L29<>\"\",L29,IF(M29<>\"\",M29,IF(N29<>\"\",N29,IF(O29<>\"\",O29,IF(P29<>\"\",P29,IF(Q29<>\"\",Q29,IF(R29<>\"\",R29,IF(S29<>\"\",S29,\"\"))))))))","v":""},null,{"$f":"IF(G29=\"\",0,ABS(H29-G29))","v":0},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29>3),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29>6),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29<=6),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$K$29>3),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29>=2.5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29<2.5),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=2.5),ROUND($G$29/500,2)*500,\"\"))","v":""}]
[]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G29<2.5,G29,ROUND(G29/500,2)*500),\"\")","v":""}]
[]
[]
["Pool für Spezialaufgaben (60% vom gerundeten Schulleitungspool, LAV, Anhang 4, Ziff. 3.3)"]
[]
["LAV, Anhang 4, Ziff. 3.2: Vergrösserung (Andere Unterrichtsspr. oder Klassenaustausch)"]
["bis 9 beteiligte Klassen (+3.5%), mit x markieren"]
["ab 10 beteiligte Klassen (+7%), mit x markieren",null,{"$f":"IF(AND(G37=\"x\",G38=\"x\"),\"Nur 1 Feld markieren!\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISTEXT(I29),\"\",I29*0.6)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G37=\"x\",(G39+3.5),IF(G38=\"x\",(G39+7),G39))","v":""}]
["Beschäftigungsgradprozente Schulpool/Spezialaufgaben",null,null,null,null,null,{"$f":"IFERROR(G40,\"\")","v":""},null,{"$f":"$G$41","v":""}]
[]
["Leitungspool Spezialunterricht (IF, eU, Art. 16b LADV, Logo und Psychomotorik)"]
[]
["LAV, Anhang 4 Kap. 2:   d * 0.106 + e * 0.194 = SL-Pool-%"]
["Korrekturfaktor für Lektionen in Abhängigkeit der Schulwochen (=SW): ",null,null,null,"d * SW / 39"]
[]
["Anzahl Lektionen (d) für Spezialunterricht gem. Pensen-",null,null,38,"SW pro Jahr"]
["meldung pro Schule mit 2) ",null,null,39,"SW pro Jahr"]
[]
["Anzahl Lektionen (d);  SW-Korrekturfaktor berücksichtigt",null,null,null,null,null,{"$f":"G48*D48/39 + G49*D49/39","v":0}]
[]
["Anzahl Lehrkräfte (e) für Spezialunterricht gem. Pensenmeldung pro Schule 3)",null,null,null,null,{"$f":"ROUND(G51*0.106+G53*0.194,3)","v":0}]
["(exkl. 1 Person mit Schulleitungsfunktion Spezialunterricht) ",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IF(F53<>0,F53,\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE))","v":""},{"$f":"IF(L56<>\"\",L56,IF(M56<>\"\",M56,IF(N56<>\"\",N56,IF(O56<>\"\",O56,IF(P56<>\"\",P56,IF(Q56<>\"\",Q56,IF(R56<>\"\",R56,IF(S56<>\"\",S56,\"\"))))))))","v":""},null,{"$f":"IF(G56=\"\",0,ABS(H56-G56))","v":0},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56>3),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56<=3),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56>6),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56<=6),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$K$56>3),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56>=2.5,$K$56<=3),$H$56,\"\")))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56<2.5),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=2.5),ROUND($G$56/500,2)*500,\"\"))","v":""}]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G56<2.5,G56,ROUND(G56/500,2)*500),\"\")","v":""}]
[]
[]
["Sonderpool \"Integrative Schulung von SuS mit verstärkten sonderpäadagogischen Massnahmen\""]
["Massnahme im Zusammenhang mit REVOS 2020"]
["Anzahl Schülerinnen und Schüler",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G63),0,G63)","v":0}]
["Beschäftigungsgradprozente Sonderpool \"Integrative Schulung\"",null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",(G63*1))","v":""},null,{"$f":"G64","v":""}]
[]
["Sonderpool \"Mentoring\" vom 24. Oktober 2018 gemäss LAV, Art. 94"]
["Massnahme im Zusammenhang mit dem Mangel an Lehrpersonen"]
["Anzahl Mentorate gemäss Allgemeinverfügung vom 24. Oktober 2018",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G68),0,G68)","v":0}]
["Anzahl Berufseinsteigende gemäss Allgemeinverfügung vom 24. Oktober 2018 4)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G69),0,G69)","v":0}]
[null,null,null,{"$f":"IF(AND(J69>=1,J68=0),\"Anz. Mentorate erfassen\",\"\")","v":""}]
["Beschäftigungsgradprozente Sonderpool \"Mentoring\"",null,null,null,null,null,{"$f":"IF(G68=\"\",\"\",(G68+G69)*3)","v":""},null,{"$f":"G71","v":""}]
[]
["1) Alle Lektionen exkl. Klassenlehrerlektionen und exkl. Lektionen gemäss 2)"]
["2) Lektionen für IF, eU, Art. 16b LADV, Logo und Psychomotorik (exkl. Lekt. besonderes VS-Angebot)"]
["3) Bei Doppelfunktion (z.B. Logo+DaZ) Lehrkraft nur 1x zählen. Massgebend ist das grössere Pensum."]
["4) Sofern der Beschäftigungsgrad 40% oder mehr beträgt und mindestens ein Semester dauert."]
[]
["Die Richtigkeit bestätigen:"]
[]
["Datum:","Schulleitung:"]
[]
["Datum:","Zuständige Gemeindebehörde:"]
[]
["Datum:","Schulinspektorat:"]

{"sheet":"Mehrsprachig Franz","index":3,"n_rows":85,"n_cols":19,"rows_kept":85,"cut":false,"hidden":true,"merged":[[6,7,9,7],[6,8,9,8],[27,5,27,6],[2,1,2,2],[2,4,2,6],[2,7,5,8],[3,1,3,2],[3,3,3,6],[4,1,4,2],[4,3,4,6]]}
[null,null,null,null,null,null,null,null,"2019.ERZ.96 / 681538"]
[]
[null,"US-Key:",null,null,null,null,null,"Valeurs de référence CdPe"]
[null,"Etablissement:",null,{"$f":"IF(D3=\"\",\"\",IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)),\"US-Key invalide\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,2,FALSE)))","v":""}]
["\n","Commune:",null,{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,3,FALSE))","v":""}]
[]
[null,null,null,null,null,null,null,"valable à partir du 1.8.2021\nAs 2021/22","valable à partir du 1.8.2022\nAs 2022/23"]
["Calcul des pools de l'école obligatoire, OSE, annexe 4"]
["Ce formulaire doit être signé et remis à l'Inspection scolaire régional avec la validation de la CdPe du 1er semestre."]
[]
[]
["Pool de direction "]
["OSE, annexe 4 chap. 1:  a * 0.062 + b * 0.106 + c * 0.194 = Pool de direction %"]
[]
["Facteur de correction pour les leçons en fonction des semaines d'école (=SE): ",null,null,null,null,"b * SE / 39"]
[]
["Nombre d'élèves (a)"]
[]
["Nombre de leçons (b) selon la comm. des progr. par établissement 1)",null,null,null,38,"SE par an"]
[null,null,null,null,39,"SE par an"]
[]
["Nombre de leçons (b) avec le facteur de correction SE",null,null,null,null,null,{"$f":"G19*E19/39 + G20*E20/39","v":0}]
[]
["Nombre d'enseignants (c) selon comm. des progr. par établissement (ens. de l'enseign."]
["spécialisé et une personne exerçant une fonction de direction d'école exclus) "]
[]
["Ecoles bilingues, (+  a *  0.03 ) marquer avec x",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[null,null,null,null,null,{"$f":"ROUND(0.062 *G17 + 0.106 * G22 + 0.194 * G24,3)","v":0}]
["Degré d'occupation total pour le pool de direction (dès 2.5% arrondi)",null,null,null,null,null,{"$f":"IF(SUM(G17,G19:G20,G22:G24)=0,\"\",IF((G27<>\"x\"),F28,F28 + G17 * 0.03))","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,4,FALSE))","v":""},{"$f":"IF(L29<>\"\",L29,IF(M29<>\"\",M29,IF(N29<>\"\",N29,IF(O29<>\"\",O29,IF(P29<>\"\",P29,IF(Q29<>\"\",Q29,IF(R29<>\"\",R29,IF(S29<>\"\",S29,\"\"))))))))","v":""},null,{"$f":"IF(G29=\"\",0,ABS(H29-G29))","v":0},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29>3),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=60,$H$29>=5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29>6),ROUND($G$29/500,2)*500,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29>60,$K$29<=6),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$K$29>3),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29>=2.5,$K$29<=3),$H$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29<2.5,$H$29<2.5),$G$29,\"\"))","v":""},{"$f":"IF($G$29=\"\",\"\",IF(AND($G$29>=2.5,$H$29<=2.5),ROUND($G$29/500,2)*500,\"\"))","v":""}]
[]
["Gesamttotal Beschäftigungsgrad Schulleitungspool (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G29<2.5,G29,ROUND(G29/500,2)*500),\"\")","v":""}]
[]
[]
["Pool destiné aux tâches spéciales (60% du pool de dir. arrondi, OSE, annexe 4, chiffre 3.3)"]
[]
["OSE, annexe 4, chiffre 3.2: Augmentation (autre langue d'enseign. ou échange de classes)"]
["Jusqu'à 9 classes impliquées (+3.5%), marquer avec x"]
["Dès 10 classes impliquées (+7%), marquer avec x",null,{"$f":"IF(AND(G37=\"x\",G38=\"x\"),\"Seulement marquer une croix!\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISTEXT(I29),\"\",I29*0.6)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(G37=\"x\",(G39+3.5),IF(G38=\"x\",(G39+7),G39))","v":""}]
["Degré d'occupation pool général/tâches spéciales",null,null,null,null,null,{"$f":"IFERROR(G40,\"\")","v":""},null,{"$f":"$G$41","v":""}]
[]
["Le pool de direction de l'enseignement spécialisé",null,null,null,null,null," (SPA,SE,Art. 16b ODSE,logo. et psych.)"]
[]
["OSE, annexe 4 chap. 2:  d * 0.106 + e * 0.194 = Pool de direction %"]
["Facteur de correction pour les leçons en fonction des sem. d'école (=SE): ",null,null,null,"d * SE / 39"]
[]
["Nombre de leçons (d) de l'enseignement spécialisé selon comm.",null,null,null,38,"SE par an"]
["des progr. par établissement 2) excl.leçons offres spéc.de l'école oblig.",null,null,null,39,"SE par an"]
[]
["Nombre de leçons (d) avec le facteur de correction SE",null,null,null,null,null,{"$f":"G48*E48/39 + G49*E49/39","v":0}]
[]
["Nombre d'enseignants (e) de l'enseignement spécialisé selon comm. des progr. par",null,null,null,null,{"$f":"ROUND(G51*0.106+G53*0.194,3)","v":0}]
["établissement (une personne exerçant une fonction de direction de l'enseign. spécialisé exclue) 3)",null,null,null,null,null,null,null,null,null,"Diff.f.B-br.","Fall1","Fall2","Fall3","Fall4","Fall5","Fall6","Fall7","Fall8"]
[]
["Degré d'occupation direction de l'enseign. Spécialisé (dès 2.5% arrondi)",null,null,null,null,null,{"$f":"IF(F53<>0,F53,\"\")","v":""},{"$f":"IF(ISERROR(VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE)),\"\",VLOOKUP(D3,Tabelle1!$B$10:$F$461,5,FALSE))","v":""},{"$f":"IF(L56<>\"\",L56,IF(M56<>\"\",M56,IF(N56<>\"\",N56,IF(O56<>\"\",O56,IF(P56<>\"\",P56,IF(Q56<>\"\",Q56,IF(R56<>\"\",R56,IF(S56<>\"\",S56,\"\"))))))))","v":""},null,{"$f":"IF(G56=\"\",0,ABS(H56-G56))","v":0},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56>3),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=60,$H$56>=5,$K$56<=3),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56>6),ROUND($G$56/500,2)*500,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56>60,$K$56<=6),$H$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$K$56>3),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56>=2.5,$K$56<=3),$H$56,\"\")))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56<2.5,$H$56<2.5),$G$56,\"\"))","v":""},{"$f":"IF($G$56=\"\",\"\",IF(AND($G$56>=2.5,$H$56<=2.5),ROUND($G$56/500,2)*500,\"\"))","v":""}]
[]
["Beschäftigungsgradprozente Leitungspool Spezialunterricht (ab 2.5% gerundet)",null,null,null,null,null,{"$f":"IFERROR(IF(G56<2.5,G56,ROUND(G56/500,2)*500),\"\")","v":""}]
[]
[]
["Pool spécial \"Scolarisation intégrée des élèves au bénéfice de mesures de pédagogie spécialisée renforcées\""]
["Mesure dans le cadre de REVOS 2020"]
["Nombre d'élèves",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G63),0,G63)","v":0}]
["Degré d'occupation pool spécial \"Scolarisation intégrée\"",null,null,null,null,null,{"$f":"IF(G63=\"\",\"\",(G63*1))","v":""},null,{"$f":"G64","v":""}]
[]
[]
["Pool spécial \"Mentoring\" du 24 octobre 2018 selon OSE, Art 94"]
["Mesure liée à la pénurie d'enseignants"]
["Nombre de mentorat selon décision générale du 24 octobre 2018",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G69),0,G69)","v":0}]
["Nombre de béneficiaire selon décision générale du 24 octobre 2018 4)",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G70),0,G70)","v":0}]
[null,null,null,{"$f":"IF(AND(J70>=1,J69=0),\"Anz. Mentorate erfassen\",\"\")","v":""}]
["Degré d'occupation pool spécial \"Mentoring\"",null,null,null,null,null,{"$f":"IF(G69=\"\",\"\",(G69+G70)*3)","v":""},null,{"$f":"G72","v":""}]
[]
["1) Toutes les leçons sauf les leçons de maître de classe et les leçons selon 2)"]
["2) Leçons pour soutien pédagogique ambulatoire, SE, Art. 16b ODSE, logopédie et psychomotricité (excl.leçons offres spéc.de l'école oblig.)"]
["3) En cas de double fonction (p. ex. logo. + FLS), ne compter l’enseignant-e qu’1x (programme le plus important)"]
["4) A condition que le taux d'occupation compte 40% ou plus et dure au moins un semestre"]
[]
["Certifié exact par"]
[]
["Date :","La direction d'école :"]
[]
["Date :","Autorité communale compétente  :"]
[]
["Date :","L'inspection scolaire :"]

{"sheet":"Tabelle1","index":4,"n_rows":461,"n_cols":6,"rows_kept":461,"cut":false,"hidden":true,"merged":[[6,4,6,5],[7,4,7,5]]}
["Beschäftigungsgrad des Schulleitungspools sowie des Leitungspools Spezialunterricht"]
["(Referenzdatum 1.08.2019)"]
["2019.ERZ.96 / 681538",null,null,null,null,"Eingabefrist : 1.9.2022"]
[]
[]
[null,"Schuljahr","2022/23",null,{"$f":"SUBTOTAL(9,E11:E461)","v":31052.476000000002},{"$f":"SUBTOTAL(9,F11:F461)","v":3060.3229999999976}]
[null,null,null,null,"Beschäftigungsgrad-% gerundet"]
[null,null,null,null,"Eingefrorene Werte "]
[null,{"$f":"SUBTOTAL(3,B11:B461)","v":451},null,null,"2021-08-01","2021-08-01"]
["Kr","SOE-Key","SOE-Name","Trägername","SL-Pool in %","Leitungspool Spezialunterricht in %"]
[1,20,"Schule Habkern","Einwohnergemeinde Habkern",20,1.1240000000000001]
[1,24,"Schule Gündlischwand/Lütschental","Einwohnergemeinde Gündlischwand",20,1.766]
[1,99,"Schule Matten","Einwohnergemeinde Matten bei Interlaken",100,10]
[1,107,"Schule Brienz","Einwohnergemeinde Brienz",105,15]
[1,110,"Schule Grindelwald","Einwohnergemeinde Grindelwald",85,5]
[1,135,"Schule Bönigen","Einwohnergemeinde Bönigen",60,5]
[1,137,"Schule Gsteigwiler","Einwohnergemeinde Gsteigwiler",10,0.40600000000000003]
[1,197,"Schule Interlaken","Einwohnergemeinde Interlaken",165,15]
[1,199,"Spezialunterricht Jungfrauregion","Einwohnergemeinde Interlaken",5,25]
[4,288,"Oberstufenschule Progymatte","Stadt Thun",100,5]
[4,289,"Oberstufenschule Buchholz","Stadt Thun",60,5]
[4,290,"Oberstufenschule Länggasse","Stadt Thun",75,5]
[4,291,"Oberstufenschule Strättligen","Stadt Thun",90,5]
[4,292,"Primarschulen Allmendingen Dürrenast Neufeld","Stadt Thun",200,20]
[4,293,"Primarschulen Lerchenfeld Goldiwil","Stadt Thun",90,10]
[4,294,"Primarschulen Pestalozzi Göttibach Seefeld","Stadt Thun",145,15]
[4,295,"Primarschulen Schönau Hohmad","Stadt Thun",150,15]
[4,296,"Primarschulen Gotthelf Obermatt Schoren","Stadt Thun",155,20]
[1,299,"Schule Leissigen","Einwohnergemeinde Leissigen",30,0.51200000000000001]
[1,320,"Schule Unterseen","Einwohnergemeinde Unterseen",150,10]
[1,324,"Schule bhs","Einwohnergemeinde Hofstetten bei Brienz",30,5]
[1,327,"Schule Ringgenberg","Einwohnergemeinde Ringgenberg (BE)",70,5]
[1,406,"Schule Wilderswil","Einwohnergemeinde Wilderswil",80,5]
[1,463,"Schule Därligen","Einwohnergemeinde Därligen",10,0.72299999999999998]
[1,488,"Schule Lauterbrunnental","Einwohnergemeinde Lauterbrunnen",50,5]
[1,528,"Schule Beatenberg","Einwohnergemeinde Beatenberg",30,1.996]
[2,8,"Schule Krattigen","Einwohnergemeinde Krattigen",20,0]
[2,11,"Schulen Oberwil","Einwohnergemeinde Oberwil im Simmental",25,0]
[2,64,"Kindergarten und Volksschule Lauenen","Einwohnergemeinde Lauenen",25,0]
[2,78,"Schule Reutigen-Zwieselberg","Einwohnergemeinde Reutigen",30,0]
[2,82,"Oberstufenschule Frutigen","Einwohnergemeinde Frutigen",70,0]
[2,83,"Schule Widi","Einwohnergemeinde Frutigen",105,0]
[2,87,"IBEM Kander- und Engstligental","Einwohnergemeinde Frutigen",15,40]
[2,103,"Schule Därstetten","Einwohnergemeinde Därstetten",25,0]
[2,123,"Kindergarten, Primar- und Realschule Erlenbach","Einwohnergemeinde Erlenbach im Simmental",40,0]
[2,167,"Schule Kandergrund-Kandersteg","Einwohnergemeinde Kandersteg",40,0]
[2,181,"IBEM Saanenland","Einwohnergemeinde Saanen",10,20]
[2,182,"Ebnit OSZ","Einwohnergemeinde Saanen",50,0]
[2,183,"Kindergarten und Primarschule S-G-S","Einwohnergemeinde Saanen",30,0]
[2,185,"Schule Turbach-Bissen","Einwohnergemeinde Saanen",15,0]
[2,188,"Sekundarschule Erlenbach","Sekundarschulverband Erlenbach",20,0]
[2,191,"Primarschule Rütti","Einwohnergemeinde Saanen",40,0]
[2,216,"Schule Adelboden","Einwohnergemeinde Adelboden",105,0]
[2,222,"Kindergarten und Primarschule Zweisimmen","Einwohnergemeinde Zweisimmen",55,2.1720000000000002]
[2,265,"Schule Wimmis","Einwohnergemeinde Wimmis",100,0]
[2,266,"IBEM Niedersimmental","Einwohnergemeinde Wimmis",10,25]
[2,323,"Volksschule Reichenbach","Einwohnergemeinde Reichenbach im Kandertal",115,0]
[2,348,"Schule Gsteig-Feutersoey","Einwohnergemeinde Gsteig b. Gstaad",25,0]
[2,366,"Kindergarten und Primarschule Aeschi bei Spiez","Gemischte Gemeinde Aeschi b. Spiez",50,1.524]
[2,367,"Oberstufenschule Aeschi bei Spiez","Gemischte Gemeinde Aeschi b. Spiez",30,0.91700000000000004]
[2,392,"Schule Boltigen","Einwohnergemeinde Boltigen",35,0]
[2,400,"Volksschule Lenk","Einwohnergemeinde Lenk",70,1.66]
[2,409,"Volksschule St. Stephan","Einwohnergemeinde St. Stephan",30,0.61799999999999999]
[2,507,"Schule Diemtigtal","Einwohnergemeinde Diemtigen",55,0]
[2,530,"Primarschule Saanen","Einwohnergemeinde Saanen",40,0]
[2,531,"Oberstufe Zweisimmen","Einwohnergemeinde Zweisimmen",30,0.61799999999999999]
[2,532,"IBEM Obersimmental","Einwohnergemeinde Zweisimmen",5,20]
[2,533,"Schulzentrum Längenstein","Einwohnergemeinde Spiez",90,1.3420000000000001]
[2,534,"Kindergarten und Primarschule Einigen","Einwohnergemeinde Spiez",30,1.466]
[2,535,"Kindergarten und Primarschule Hofachern/Hondrich","Einwohnergemeinde Spiez",65,1.5720000000000001]
[2,536,"Kindergarten und Primarschule Räumli/Spiezwiler","Einwohnergemeinde Spiez",75,0]
[2,537,"Kindergarten und Primarschule Spiezmoos/Faulensee","Einwohnergemeinde Spiez",65,0]
[2,538,"IBEM Spiez-Aeschi-Krattigen","Einwohnergemeinde Spiez",20,30]
[2,600,"Bäuertschulen","Einwohnergemeinde Frutigen",80,0]
[1,6,"Kindergarten und Primarschule Hasliberg","Einwohnergemeinde Hasliberg",30,0.60699999999999998]
[3,25,"Schule Buchholterberg","Einwohnergemeinde Buchholterberg",45,1.254]
[1,35,"Primar- und Realschule Innertkirchen","Einwohnergemeinde Innertkirchen",30,0]
[3,59,"Volksschule Unterlangenegg","Einwohnergemeinde Unterlangenegg",30,0.51200000000000001]
[3,60,"IBEM-Region Zulg","Einwohnergemeinde Unterlangenegg",0.91800000000000004,15]
[3,66,"Kindergarten und Primarschule Uetendorf","Einwohnergemeinde Uetendorf",120,15]
[3,67,"Sekundarschule Uetendorf","Einwohnergemeinde Uetendorf",70,5]
[3,81,"Schulen Burgistein","Einwohnergemeinde Burgistein",25,0]
[3,96,"Kindergarten und Primarschule Wattenwil","Einwohnergemeinde Wattenwil",65,5]
[3,97,"OSZ Wattenwil","Einwohnergemeinde Wattenwil",70,0.74199999999999999]
[3,129,"Schule Linke Zulg","Einwohnergemeinde Homberg",40,1.236]
[3,218,"Schule Forst-Längenbühl","Einwohnergemeinde Forst-Längenbühl",20,1.421]
[4,233,"Primarstufe Hilterfingen","Schulverband Hilterfingen",60,0]
[4,234,"Primarstufe Oberhofen","Schulverband Hilterfingen",30,0]
[4,235,"Mittelstufenschule Friedbühl","Schulverband Hilterfingen",35,0]
[4,236,"Oberstufenschule Hünibach","Schulverband Hilterfingen",60,0]
[3,316,"Kindergarten und Schule Blumenstein","Einwohnergemeinde Blumenstein",35,0.42399999999999999]
[3,345,"Kindergarten + Primarschule Heimberg","Einwohnergemeinde Heimberg",150,20]
[3,346,"Oberstufenschule Heimberg","Einwohnergemeinde Heimberg",55,5]
[1,359,"Schule Meiringen","Einwohnergemeinde Meiringen",105,5]
[4,360,"Kindergärten und Primarschulen Steffisburg","Einwohnergemeinde Steffisburg",285,0]
[4,361,"Oberstufe Steffisburg","Einwohnergemeinde Steffisburg",115,0]
[4,362,"Besondere Massnahmen Steffisburg","Einwohnergemeinde Steffisburg",20,40]
[3,369,"Basisstufe und Primarschule Bieten","Einwohnergemeinde Eriz",10,0]
[3,376,"Schulen Oberlangenegg","Einwohnergemeinde Oberlangenegg",15,0.51200000000000001]
[3,384,"Kindergarten und Primarschule Uebeschi","Einwohnergemeinde Uebeschi",20,1.2270000000000001]
[3,393,"Primarschule Thierachern/Amsoldingen","Einwohnergemeinde Thierachern",75,5]
[3,394,"Oberstufenschule Thierachern","Einwohnergemeinde Thierachern",45,5]
[3,395,"Besondere Massnahmen Thuner Westamt","Einwohnergemeinde Thierachern",1.5349999999999999,20]
[3,408,"Schule Gurzelen","Einwohnergemeinde Gurzelen",25,0.40100000000000002]
[3,415,"Schule Fahrni","Einwohnergemeinde Fahrni",20,1.042]
[4,443,"Schulen Sigriswil\nWerte per 1.8.2020: 506 Zentrale Oberstufe Sigriswil 25+0.512","Einwohnergemeinde Sigriswil",85,10]
[3,458,"Schule Seftigen","Einwohnergemeinde Seftigen",65,5]
[4,468,"Schule Heiligenschwendi","Einwohnergemeinde Heiligenschwendi",15,0]
[3,484,"Schule Uttigen","Einwohnergemeinde Uttigen",50,5]
[1,540,"Besondere Massnahmen Oberhasli","Einwohnergemeinde Meiringen",5,20]
[3,541,"Oberstufenzentrum Unterlangenegg","Gemeindeverband Oberstufenzentrum Unterlangenegg",45,0]
[3,542,"Zuweisungsregion Wattenwil","Einwohnergemeinde Wattenwil",5,20]
[4,592,"IBEM Schulverband Hilterfingen","Schulverband Hilterfingen",5,25]
[1,593,"OZO Meiringen","Einwohnergemeinde Meiringen",55,1.748]
[3,594,"Schule Stocken-Höfen","Einwohnergemeinde Stocken-Höfen",25,0.91700000000000004]
[3,597,"IBEM Linke Zulg","Einwohnergemeinde Homberg",0.40600000000000003,5]
[6,22,"Schulen Guggisberg","Einwohnergemeinde Guggisberg",35,0]
[6,47,"Oberstufe Kehrsatz","Einwohnergemeinde Kehrsatz",50,0]
[6,53,"Oberstufenzentrum Schwarzenburg","Einwohnergemeinde Schwarzenburg",70,0.83]
[6,54,"Kindergärten und Primarschulen Schwarzenburg","Einwohnergemeinde Schwarzenburg",120,5]
[9,111,"Kindergarten und Primarschule Kaufdorf","Einwohnergemeinde Kaufdorf",30,0]
[6,115,"Kindergarten und Primarschule Kehrsatz","Einwohnergemeinde Kehrsatz",105,0]
[9,124,"Primarstufe Wichtrach","Einwohnergemeinde Wichtrach",95,0.81399999999999995]
[9,125,"Sekstufe 1 Wichtrach","Gemeindeverband Sekstufe1 Wichtrach",70,1.766]
[9,126,"IBEM Region Aaretal Süd","Einwohnergemeinde Wichtrach",5,20]
[9,154,"Schulzentrum Rebacker Münsingen","Einwohnergemeinde Münsingen",205,10]
[9,155,"Schulzentrum Schlossmatt Münsingen","Einwohnergemeinde Münsingen",200,5]
[9,156,"Schule Riggisberg","Einwohnergemeinde Riggisberg",115,2.2959999999999998]
[9,158,"IBEM Region Gürbetal-Längenberg","Einwohnergemeinde Riggisberg",5,25]
[6,165,"Kindergarten und Primarschule Oberbalm","Einwohnergemeinde Oberbalm",20,0.61799999999999999]
[9,166,"Schule Rüeggisberg","Einwohnergemeinde Rüeggisberg",30,0.21199999999999999]
[9,169,"Kindergarten, Primar- und Realschule Toffen","Einwohnergemeinde Toffen",65,1.042]
[9,206,"Schule Region Gerzensee","Einwohnergemeinde Gerzensee",75,10]
[9,219,"Kindergarten und Primarschule Rubigen","Einwohnergemeinde Rubigen",55,1.4330000000000001]
[6,239,"Kindergarten, Primar-und Realschule Rüschegg","Einwohnergemeinde Rüschegg",45,2.3140000000000001]
[6,269,"Schule Wald","Einwohnergemeinde Wald BE",25,0]
[7,279,"Primarschule Allmendingen","Einwohnergemeinde Allmendingen",15,1.615]
[9,325,"Kindergarten und Primarschule Kiesen","Einwohnergemeinde Kiesen",35,0]
[9,354,"Primarschule Oppligen","Einwohnergemeinde Oppligen",15,0.81399999999999995]
[6,391,"Schule Niedermuhlern und Realschule NOW","Einwohnergemeinde Niedermuhlern",20,0]
[9,438,"Volksschule Belp Dorf","Einwohnergemeinde Belp",65,0.51200000000000001]
[9,439,"Volksschule Belp Mühlematt","Einwohnergemeinde Belp",80,2.472]
[9,440,"Volksschule Belp Oberstufe","Einwohnergemeinde Belp",100,0.83]
[9,441,"Volksschule Belp Neumatt","Einwohnergemeinde Belp",80,0.42399999999999999]
[9,464,"Schule Thurnen","Einwohnergemeinde Thurnen",40,0]
[6,545,"IBEM Schwarzenburg","Einwohnergemeinde Schwarzenburg",5,25]
[6,572,"IBEM Region Längenberg-Kehrsatz","Einwohnergemeinde Kehrsatz",0,20]
[9,573,"IBEM Region Aaretal Nord","Einwohnergemeinde Münsingen",25,25]
[9,574,"IBEM Belp","Einwohnergemeinde Belp",5,25]
[9,599,"Zyklusschule Belpberg","Einwohnergemeinde Belp",10,0]
[5,300,"Bern Altstadt/Schosshalde","Einwohnergemeinde Bern",150,15]
[5,301,"Bern Kirchenfeld","Einwohnergemeinde Bern",80,10]
[5,302,"Bern Laubegg","Einwohnergemeinde Bern",235,20]
[5,304,"Bern Manuel","Einwohnergemeinde Bern",220,25]
[5,305,"Bern Brunnmatt","Einwohnergemeinde Bern",180,15]
[5,306,"Bern Munzinger","Einwohnergemeinde Bern",100,10]
[5,307,"Bern Pestalozzi","Einwohnergemeinde Bern",170,15]
[5,313,"Bern Marzili/Sulgenbach","Einwohnergemeinde Bern",145,20]
[5,314,"Bern Breitfeld/Wankdorf","Einwohnergemeinde Bern",185,20]
[5,315,"Bern Lorraine/Wylergut","Einwohnergemeinde Bern",100,10]
[5,328,"Bern Spitalacker/Breitenrain","Einwohnergemeinde Bern",260,25]
[5,329,"Bern Hochfeld II","Einwohnergemeinde Bern",130,15]
[5,332,"Bern Bümpliz/Höhe","Einwohnergemeinde Bern",215,25]
[5,333,"Bern Kleefeld","Einwohnergemeinde Bern",95,10]
[5,334,"Bern Oberbottigen","Einwohnergemeinde Bern",30,5]
[5,338,"Bern Stapfenacker","Einwohnergemeinde Bern",135,20]
[5,351,"Bern Bethlehemacker","Einwohnergemeinde Bern",235,35]
[5,352,"Bern Schwabgut","Einwohnergemeinde Bern",175,25]
[5,353,"Bern Tscharnergut","Einwohnergemeinde Bern",95,25]
[5,581,"Bern Zentrale Angebote","Einwohnergemeinde Bern",20,1.5720000000000001]
[5,586,"Bern Hochfeld I","Einwohnergemeinde Bern",105,10]
[5,587,"Bern Rossfeld","Einwohnergemeinde Bern",90,15]
[5,588,"Bern Grosses Länggassschulhaus","Einwohnergemeinde Bern",95,15]
[5,598,"Bern Intensivkurse","Einwohnergemeinde Bern",30,0]
[7,13,"Schule Biglen","Einwohnergemeinde Biglen",65,15]
[7,28,"Schule Region Zäziwil","Einwohnergemeinde Zäziwil",55,5]
[9,75,"Schule Konolfingen","Einwohnergemeinde Konolfingen",165,20]
[9,89,"Schule Niederhünigen","Einwohnergemeinde Niederhünigen",15,0]
[9,119,"Primarschule Brenzikofen","Einwohnergemeinde Brenzikofen",10,0]
[7,200,"KG, Primar-, Realschule Mirchel","Einwohnergemeinde Mirchel",25,2.0529999999999999]
[7,221,"Schule Arni-Landiswil","Einwohnergemeinde Arni BE",50,0.90400000000000003]
[9,238,"Primarschule Herbligen","Einwohnergemeinde Herbligen",15,0]
[7,275,"Primarstufenkreis Worb","Einwohnergemeinde Worb",140,20]
[7,276,"Primarstufenkreis Rüfenacht","Einwohnergemeinde Worb",100,15]
[7,277,"Sekundarstufenkreis Worb","Einwohnergemeinde Worb",95,5]
[7,278,"Schule Oberthal","Einwohnergemeinde Oberthal",25,2.0529999999999999]
[9,321,"Primarschule Häutligen","Einwohnergemeinde Häutligen",5,0]
[7,365,"Schulen Walkringen","Einwohnergemeinde Walkringen",55,0]
[9,378,"Kindergarten, Primarstufe und Sekundarstufe I Oberdiessbach","Einwohnergemeinde Oberdiessbach",125,0]
[9,380,"IBEM Region Oberdiessbach","Einwohnergemeinde Oberdiessbach",5,20]
[9,412,"Primarschule Freimettigen","Einwohnergemeinde Freimettigen",20,0.19400000000000001]
[6,460,"Oberstufenzentrum Köniz (OZK)","Einwohnergemeinde Köniz",70,1.024]
[6,461,"Schule Köniz Buchsee","Einwohnergemeinde Köniz",145,5]
[6,462,"Schule Schliern Blindenmoos","Einwohnergemeinde Köniz",135,1.448]
[6,467,"Schule Liebefeld Steinhölzli","Einwohnergemeinde Köniz",70,1.042]
[6,470,"Schule Liebefeld Hessgut","Einwohnergemeinde Köniz",140,5]
[6,471,"Schule Spiegel","Einwohnergemeinde Köniz",140,5]
[9,473,"Schule Linden","Einwohnergemeinde Linden",35,0]
[6,476,"Schule Wabern","Einwohnergemeinde Köniz",210,5]
[6,477,"Schule Sternenberg","Einwohnergemeinde Köniz",150,1.8540000000000001]
[6,480,"Schulen Wangental","Einwohnergemeinde Köniz",155,5]
[7,543,"Schule Grosshöchstetten","Einwohnergemeinde Grosshöchstetten",105,1.1299999999999999]
[6,582,"Koordinationsstelle für besondere Förderung Köniz","Einwohnergemeinde Köniz",25,100]
[6,604,"Spezielle Sekundarschulklassen am Gymnasium Lerbermatt","Einwohnergemeinde Köniz",0,0]
[10,50,"Schulen Meikirch","Einwohnergemeinde Meikirch",75,5]
[8,100,"Kindergarten Bremgarten","Einwohnergemeinde Bremgarten bei Bern",25,1.627]
[8,101,"Unterstufe Bremgarten (1.-4. Klassen)","Einwohnergemeinde Bremgarten bei Bern",50,10]
[8,102,"Oberstufe Bremgarten (5.-9. Klassen)","Einwohnergemeinde Bremgarten bei Bern",65,5]
[10,140,"Kindergarten und Primarschule Kirchlindach","Einwohnergemeinde Kirchlindach",70,5]
[5,159,"Schule Bernstrasse Ostermundigen","Einwohnergemeinde Ostermundigen",90,15]
[5,160,"Schule Dennigkofen Ostermundigen","Einwohnergemeinde Ostermundigen",145,10]
[5,161,"Schule Mösli Ostermundigen","Einwohnergemeinde Ostermundigen",135,10]
[5,162,"Schule Rüti Ostermundigen","Einwohnergemeinde Ostermundigen",130,10]
[8,193,"Primarschule Ittigen/Worblaufen","Einwohnergemeinde Ittigen",225,20]
[8,194,"Oberstufenzentrum Ittigen","Einwohnergemeinde Ittigen",80,5]
[8,223,"Sekundarstufe I Zollikofen","Einwohnergemeinde Zollikofen",85,5]
[8,224,"Primarstufe Zollikofen","Einwohnergemeinde Zollikofen",220,20]
[7,226,"Primarschule Bolligen","Einwohnergemeinde Bolligen",135,5]
[7,227,"Oberstufenzentrum Eisengasse Bolligen","Einwohnergemeinde Bolligen",60,0.61799999999999999]
[10,272,"Kindergarten und Primarschule Hinterkappelen","Einwohnergemeinde Wohlen bei Bern",85,10]
[10,273,"Primarschule Matzwil","Schulgemeindeverband Matzwil",10,0.42399999999999999]
[10,274,"Oberstufenschule Uettligen","Einwohnergemeinde Wohlen bei Bern",45,5]
[7,283,"Primarschule Vechigen","Einwohnergemeinde Vechigen",105,5]
[7,284,"Oberstufenschule Vechigen","Einwohnergemeinde Vechigen",35,1.236]
[7,287,"Gesamtschule Lindental","Einwohnergemeinde Vechigen",5,0]
[7,308,"Schule Bernstrasse Stettlen","Einwohnergemeinde Stettlen",65,5]
[7,309,"Schule Bleiche","Einwohnergemeinde Stettlen",20,0]
[7,401,"Schule Aebnit-Horbern-Melchenbühl Muri bei Bern","Einwohnergemeinde Muri bei Bern",80,15]
[7,402,"Schule Moos-Dorf Muri bei Bern","Einwohnergemeinde Muri bei Bern",105,10]
[7,403,"Schule Seidenberg Muri bei Bern","Einwohnergemeinde Muri bei Bern",90,10]
[7,404,"Kindergärten Muri bei Bern","Einwohnergemeinde Muri bei Bern",55,5]
[10,518,"Oberstufenschule Hinterkappelen","Einwohnergemeinde Wohlen bei Bern",50,5]
[10,519,"Kindergarten und Primarschule Wohlen/Murzelen/Innerberg","Einwohnergemeinde Wohlen bei Bern",60,5]
[10,520,"Kindergarten und Primarschule Uettligen/Säriswil/Möriswil","Einwohnergemeinde Wohlen bei Bern",40,5]
[10,23,"Primarschule Münchenwiler","Einwohnergemeinde Münchenwiler",10,0]
[10,38,"Kindergarten und Primarschule Wileroltigen, Gurbrü","Einwohnergemeinde Wileroltigen",10,0.51600000000000001]
[10,77,"Schule Mühleberg","Einwohnergemeinde Mühleberg",90,10]
[8,79,"Schulen Fraubrunnen","Einwohnergemeinde Fraubrunnen",180,15]
[10,113,"Kindergarten und Primarschule Frauenkappelen","Einwohnergemeinde Frauenkappelen",25,0]
[8,152,"Spezialunterricht Jegenstorf und Umgebung","Einwohnergemeinde Jegenstorf",180,25]
[8,153,"Schule Jegenstorf","Einwohnergemeinde Jegenstorf",180,25]
[10,217,"Primarschule Kriechenwil","Einwohnergemeinde Kriechenwil",10,0]
[10,237,"Schule Ferenbalm","Einwohnergemeinde Ferenbalm",15,0.42399999999999999]
[10,249,"Kindergarten und Primarstufe Neuenegg","Einwohnergemeinde Neuenegg",100,10]
[10,250,"Kindergarten und Primarstufe Thörishaus","Einwohnergemeinde Neuenegg",40,1.847]
[10,251,"Sekundarstufe I Neuenegg","Einwohnergemeinde Neuenegg",60,5]
[8,319,"Primarschule Diemerswil","Einwohnergemeinde Diemerswil",5,0.41299999999999998]
[8,349,"Schulen Grauholz","Einwohnergemeinde Urtenen-Schönbühl",260,25]
[10,383,"Schule Laupen","Einwohnergemeinde Laupen",105,15]
[8,385,"Schule Münchenbuchsee","Einwohnergemeinde Münchenbuchsee",330,25]
[8,410,"Schule Moosseedorf","Einwohnergemeinde Moosseedorf",110,5]
[8,494,"Schule Zuzwil","Einwohnergemeinde Zuzwil (BE)",20,1.254]
[8,497,"Primarschule Iffwil","Einwohnergemeinde Iffwil",10,6]
[11,1,"Schule Affoltern i.E.","Einwohnergemeinde Affoltern im Emmental",25,0.60699999999999998]
[11,2,"Schule Röthenbach i.E.","Einwohnergemeinde Röthenbach im Emmental",30,0.51200000000000001]
[11,9,"Schule Trub*schachen\nWerte 1.8.2020: Schule Trubschachen 40+10, Schule Trub 40+0","Schulverband Trub-Trubschachen",85,10]
[11,15,"Volksschule Lauperswil","Einwohnergemeinde Lauperswil",70,10]
[11,16,"Gemeindeverband Sekundarschule Zollbrück","Gemeindeverband Sekundarschule Zollbrück",25,0]
[11,27,"Schulen Sumiswald-Wasen","Einwohnergemeinde Sumiswald",165,15]
[11,61,"Schulen Signau","Einwohnergemeinde Signau",65,15]
[11,63,"Sekundarschule Signau","Sekundarschulverband Signau",35,1.3240000000000001]
[11,76,"Schulen Schangnau","Einwohnergemeinde Schangnau",35,0.93600000000000005]
[11,88,"Schulen Rüderswil","Einwohnergemeinde Rüderswil",65,0.42399999999999999]
[11,94,"Schule Langnau","Einwohnergemeinde Langnau im Emmental",285,25]
[11,117,"Kindergarten und Primarschule Dürrenroth","Einwohnergemeinde Dürrenroth",25,0]
[11,120,"Primarschule Gassen","Schulgemeinde Klein-Emmental",10,0]
[11,134,"Volksschule Trachselwald","Einwohnergemeinde Trachselwald",25,5]
[11,141,"Schule Lützelflüh","Einwohnergemeinde Lützelflüh",120,5]
[11,268,"Schule Bowil","Einwohnergemeinde Bowil",40,5]
[11,311,"Schulen Rüegsau","Einwohnergemeinde Rüegsau",155,20]
[11,486,"Kindergarten, Primar- und Realschule Eggiwil","Einwohnergemeinde Eggiwil",90,5]
[12,3,"Schule Gondiswil-Reisiswil","Einwohnergemeinde Gondiswil",30,0]
[12,34,"Volksschule Ursenbach","Einwohnergemeinde Ursenbach",25,1.2250000000000001]
[11,42,"Schule Wyssachen","Einwohnergemeinde Wyssachen",0,0]
[12,48,"Schule Niederbipp","Einwohnergemeinde Niederbipp",150,0]
[12,49,"IBEM ZUK Bipperamt","Einwohnergemeinde Niederbipp",25,35]
[12,55,"Schule Bannwil-Schwarzhäusern","Einwohnergemeinde Bannwil",35,0]
[12,114,"Volksschule Oberbipp","Einwohnergemeinde Oberbipp",45,0]
[12,118,"Schule Attiswil","Einwohnergemeinde Attiswil",35,0]
[12,131,"Volksschule Rohrbachgraben","Einwohnergemeinde Rohrbachgraben",15,2.0409999999999999]
[12,132,"Kindergarten und Primarschule Obersteckholz","Einwohnergemeinde Langenthal",15,0]
[12,190,"Basisstufe Auswil","Einwohnergemeinde Auswil",5,0]
[12,196,"Volksschule Rohrbach","Einwohnergemeinde Rohrbach",40,0.51600000000000001]
[12,202,"Volksschule Lotzwil","Einwohnergemeinde Lotzwil",130,2.0840000000000001]
[12,203,"Schule und Kindergarten Melchnau","Einwohnergemeinde Melchnau",55,0]
[12,214,"Gemeindeverband Schule Aare-Oenz","Gemeindeverband Schule Aare-Oenz",55,0]
[12,225,"Schulverband Farnern Rumisberg Wolfisberg","Schulverband Farnern Rumisberg Wolfisberg",20,0]
[12,241,"Volksschule Thunstetten-Bützberg","Einwohnergemeinde Thunstetten",95,0]
[12,247,"Oberstufe Sek I Herzogenbuchsee","Oberstufenverband Herzogenbuchsee",95,0]
[11,256,"Schule Huttwil","Einwohnergemeinde Huttwil",185,0]
[11,257,"IBEM-Region Huttwil","Einwohnergemeinde Huttwil",5,35]
[12,260,"Volksschule Langenthal Kreuzfeld","Einwohnergemeinde Langenthal",95,0]
[12,261,"Volksschule Langenthal Hard","Einwohnergemeinde Langenthal",65,0]
[12,262,"Volksschule Langenthal Elzmatte","Einwohnergemeinde Langenthal",65,0]
[12,263,"Volksschule Langenthal Oberstufenzentrum","Einwohnergemeinde Langenthal",145,0]
[12,264,"Kindergärten Langenthal","Einwohnergemeinde Langenthal",65,0]
[12,270,"Volksschule Madiswil","Einwohnergemeinde Madiswil",75,5]
[12,271,"Oberstufenzentrum Kleindietwil (OSZK)","Gemeindeverband Oberstufenzentrum Kleindietwil",60,1.254]
[12,303,"Schule Herzogenbuchsee","Einwohnergemeinde Herzogenbuchsee",200,55]
[11,347,"Kindergarten, Primar- und Realschule Eriswil","Einwohnergemeinde Eriswil",35,0]
[12,368,"Volksschule Aarwangen","Einwohnergemeinde Aarwangen",145,0]
[12,382,"Schule Wangen","Einwohnergemeinde Wangen an der Aare",105,0]
[12,450,"Schule Walterswil","Einwohnergemeinde Walterswil (BE)",20,0]
[12,487,"Schule Roggwil","Einwohnergemeinde Roggwil (BE)",130,0]
[12,490,"Schule Wiedlisbach","Einwohnergemeinde Wiedlisbach",55,0]
[12,491,"Oberstufenzentrum Wiedlisbach","Oberstufenverband Wiedlisbach",45,0]
[12,504,"Schule Wynau","Einwohnergemeinde Wynau",60,0]
[12,512,"IBEM-Region Langenthal","Einwohnergemeinde Langenthal",55,25]
[12,513,"IBEM-Region ZBMO 1","Einwohnergemeinde Aarwangen",5,20]
[12,514,"IBEM-Region ZBMO 2","Einwohnergemeinde Roggwil (BE)",5,15]
[12,515,"IBEM-Region ZBMO 3","Einwohnergemeinde Melchnau",0.97099999999999997,10]
[12,516,"IBEM-Region oberes Langetental","Einwohnergemeinde Rohrbach",10,25]
[12,580,"Schule Bettenhausen-Ochlenberg-Thörigen","Schulverband Bettenhausen-Ochlenberg-Thörigen",75,0]
[12,602,"IBEM-Region ZBMO 4","Einwohnergemeinde Wynau",1.819,5]
[13,7,"Schule Oberburg","Einwohnergemeinde Oberburg",100,15]
[13,43,"Schule Hindelbank","Einwohnergemeinde Hindelbank",100,2.1739999999999999]
[11,71,"Kindergarten und Primarschule Hasle bei Burgdorf","Einwohnergemeinde Hasle bei Burgdorf",80,5]
[13,98,"Schule Lyssach","Einwohnergemeinde Lyssach",35,0]
[13,104,"Schule Kirchberg","Einwohnergemeinde Kirchberg (BE)",100,0]
[13,105,"Oberstufe Gemeindeverband Kirchberg BE","Gemeindeverband Kirchberg BE",90,0]
[13,106,"IBEM Kirchberg","Gemeindeverband Kirchberg BE",25,30]
[13,164,"Schule Wynigen-Seeberg","Einwohnergemeinde Wynigen",130,0]
[13,170,"Kindergarten und Primarschule Aefligen","Einwohnergemeinde Aefligen",25,0]
[13,172,"Primarschule Rüdtligen-Alchenflüh","Einwohnergemeinde Rüdtligen-Alchenflüh",50,0]
[13,281,"Schule Heimiswil/Kaltacker","Einwohnergemeinde Heimiswil",50,5]
[13,298,"Kindergarten und Primarschule Kernenried-Zauggenried","Einwohnergemeinde Kernenried",20,0]
[13,318,"Schule Regio Koppigen","Gemeindeverband Koppigen",95,25]
[13,389,"Schule Ersigen-Oesch","Einwohnergemeinde Ersigen",55,0]
[13,396,"Schule untere Emme","Schulverband untere Emme",275,15]
[13,416,"Primarschulen Krauchthal","Einwohnergemeinde Krauchthal",50,1.236]
[13,429,"Integration und besondere Angebote IBEM","Einwohnergemeinde Burgdorf",15,10]
[13,430,"Primarschule Gsteighof Burgdorf","Einwohnergemeinde Burgdorf",90,10]
[13,431,"Primarschule Lindenfeld Burgdorf","Einwohnergemeinde Burgdorf",55,5]
[13,432,"Primarschule Neumatt Burgdorf","Einwohnergemeinde Burgdorf",40,5]
[13,433,"Primarschule Schlossmatt Burgdorf","Einwohnergemeinde Burgdorf",75,5]
[13,434,"Schulzentrum Pestalozzi-Gotthelf","Einwohnergemeinde Burgdorf",155,15]
[13,435,"Oberstufe Gsteighof Burgdorf","Einwohnergemeinde Burgdorf",75,5]
[13,591,"IBEM-Region Hindelbank","Einwohnergemeinde Hindelbank",1.827,15]
[14,90,"Schule Brügg","Einwohnergemeinde Brügg",135,10]
[16,128,"Schule Lengnau","Einwohnergemeinde Lengnau (BE)",175,20]
[14,186,"Primarschule BTM","Einwohnergemeinde Treiten",60,1.466]
[14,207,"Primarschule Ins","Einwohnergemeinde Ins",85,5]
[14,208,"Oberstufenzentrum Ins","Gemeindeverband Oberstufenzentrum Ins",70,5]
[14,210,"Besondere Massnahmen Ins","Einwohnergemeinde Ins",15,25]
[14,240,"Schule Studen Aegerten","Einwohnergemeinde Studen (BE)",210,20]
[14,252,"Kindergarten und Primarschule Leubringen","Commune municipale/Einwohnergemeinde  Evilard/Leubringen",45,5]
[14,322,"Schule Finsterhennen-Siselen","Einwohnergemeinde Finsterhennen",25,0.61799999999999999]
[14,424,"Kindergarten und Primarschule Erlach","Einwohnergemeinde Erlach",30,0.42399999999999999]
[14,425,"Oberstufenschule Erlach","Oberstufenschulverband Erlach",30,0.21199999999999999]
[16,495,"Schule Twann-Tüscherz-Ligerz","Einwohnergemeinde Twann-Tüscherz",50,5]
[14,546,"Biel Rittermatte (OSZ)","Einwohnergemeinde/Commune municipale  Biel/Bienne",100,5]
[14,547,"Biel Madretsch (OSZ)","Einwohnergemeinde/Commune municipale  Biel/Bienne",80,1.042]
[14,548,"Biel Mett-Bözingen (OSZ)","Einwohnergemeinde/Commune municipale  Biel/Bienne",95,5]
[14,550,"Biel Zentrum","Einwohnergemeinde/Commune municipale  Biel/Bienne",195,10]
[14,551,"Biel Bözingen / Champagne","Einwohnergemeinde/Commune municipale  Biel/Bienne",155,10]
[14,552,"Biel Mühlefeld","Einwohnergemeinde/Commune municipale  Biel/Bienne",110,10]
[14,553,"Biel Linde/Madretsch","Einwohnergemeinde/Commune municipale  Biel/Bienne",150,10]
[14,555,"Biel Mett","Einwohnergemeinde/Commune municipale  Biel/Bienne",165,15]
[14,584,"Biel Zentrum für Pädagogik","Einwohnergemeinde/Commune municipale  Biel/Bienne",5,20]
[14,595,"Schulimont","Gemeindeverband Schulimont",70,1.66]
[15,10,"Schulen Seedorf","Einwohnergemeinde Seedorf (BE)",75,5]
[15,18,"Schule Kappelen","Einwohnergemeinde Kappelen",35,1.784]
[15,40,"Primarschule Aarberg","Einwohnergemeinde Aarberg",90,2.38]
[15,45,"Schule Ipsach","Einwohnergemeinde Ipsach",80,4.1289999999999996]
[15,57,"Kindergarten + Primarschule Bellmund","Einwohnergemeinde Bellmund",45,1.956]
[15,58,"Schulverband Hermrigen-Merzligen","Schulverband Hermrigen-Merzligen",15,0.42799999999999999]
[15,70,"Kindergarten, Primar- und Realschule Bargen","Einwohnergemeinde Bargen (BE)",30,1.7310000000000001]
[15,130,"Real-/Sekundarschule Aarberg","Schulverband Aarberg",85,1.1299999999999999]
[15,173,"Kindergarten, Primarschule Worben","Einwohnergemeinde Worben",50,5]
[15,282,"Primarschule Port","Einwohnergemeinde Port",80,2.4409999999999998]
[15,331,"Primarschule Sutz-Lattrigen-Mörigen","Einwohnergemeinde Sutz-Lattrigen",45,0]
[15,335,"Schule Burgerbeunden (Primarstufe)","Einwohnergemeinde Nidau",30,2.3460000000000001]
[15,336,"Kindergarten und Primarschule Balainen","Einwohnergemeinde Nidau",25,1]
[15,337,"Schule Weidteile","Einwohnergemeinde Nidau",70,6.44]
[15,339,"Schule Burgerbeunden (Sekundarstufe I)","Schulverband Nidau",100,8.843]
[15,340,"Sekundarstufe I Balainen","Schulverband Nidau",40,5.4409999999999998]
[15,343,"IBEM-Region Nidau","Schulverband Nidau",5,9.7390000000000008]
[15,350,"Schule Walperswil-Bühl","Einwohnergemeinde Walperswil",40,2.19]
[15,363,"Kindergarten und Primarschule Täuffelen","Einwohnergemeinde Täuffelen",70,1.3180000000000001]
[15,364,"Oberstufenzentrum Täuffelen","Schulverband Oberstufenzentrum Täuffelen",45,0.83]
[15,388,"Kindergarten und Primarschule Radelfingen","Einwohnergemeinde Radelfingen",25,1.24]
[15,445,"Schule Grentschel Lyss","Einwohnergemeinde Lyss",125,5]
[15,447,"Schule Lyssbach Lyss","Einwohnergemeinde Lyss",160,10]
[15,448,"Schule Stegmatt Lyss","Einwohnergemeinde Lyss",130,15]
[15,449,"Schule Busswil Lyss","Einwohnergemeinde Lyss",45,5]
[15,500,"KG, Real- und Primarschule Kallnach","Einwohnergemeinde Kallnach",50,5]
[15,521,"Primarschule Jens","Einwohnergemeinde Jens",15,1.0669999999999999]
[15,575,"IBEM-Region Aarberg","Schulverband Aarberg",25,15]
[15,577,"IBEM-Region Täuffelen","Schulverband Oberstufenzentrum Täuffelen",5,15]
[16,37,"Kindergarten- und Primarschule Grossaffoltern","Einwohnergemeinde Grossaffoltern",65,0.91800000000000004]
[16,65,"Kindergarten und Primarschule Diessbach","Einwohnergemeinde Diessbach bei Büren",30,2.19]
[16,68,"Primarschule Orpund","Einwohnergemeinde Orpund",65,1.615]
[16,69,"Oberstufenzentrum Orpund","Gemeindeverband Bildung Gottstatt",60,1.024]
[16,108,"Schule Büren an der Aare","Einwohnergemeinde Büren an der Aare",120,0.61799999999999999]
[16,109,"Integration und schulische Fördermassnahmen (IFB) Schulkreis Büren","Einwohnergemeinde Büren an der Aare",25,25]
[16,112,"Kindergarten und Primarschule Meinisberg","Einwohnergemeinde Meinisberg",35,0]
[16,146,"Kindergarten und Primarschule Oberwil bei Büren","Einwohnergemeinde Oberwil bei Büren",25,1.1479999999999999]
[16,147,"Kindergarten und Primarschule Rapperswil","Einwohnergemeinde Rapperswil (BE)",55,0.40600000000000003]
[16,148,"Oberstufenzentrum Rapperswil","Oberstufenverband Rapperswil",50,0]
[16,184,"Schule Schüpfen","Einwohnergemeinde Schüpfen",125,5]
[16,189,"IBEM-Region Seeland Südost","Einwohnergemeinde Schüpfen",5,25]
[16,204,"Schule Büetigen","Einwohnergemeinde Büetigen",20,0.42399999999999999]
[16,205,"Kindergarten und Primarschule Arch","Einwohnergemeinde Arch",35,0.61799999999999999]
[16,230,"Kindergarten und Primarschule Leuzigen","Einwohnergemeinde Leuzigen",35,0.61799999999999999]
[16,259,"Primarschule Wengi","Einwohnergemeinde Wengi",10,1.042]
[16,280,"Primarschule Rüti","Einwohnergemeinde Rüti bei Büren",20,0.95399999999999996]
[16,317,"Schule 2556, Kindergarten und Primarschule Scheuren/Schwadernau","Einwohnergemeinde Schwadernau",25,0.20699999999999999]
[16,373,"Schule Pieterlen","Einwohnergemeinde Pieterlen",180,15]
[16,452,"Schule Räbli Safnern","Einwohnergemeinde Safnern",45,0]
[16,453,"Primarschule Dotzigen","Einwohnergemeinde Dotzigen",35,1.254]
[16,454,"OS Dotzigen","Oberstufenverband Büetigen-Diessbach-Dotzigen",30,1.042]
[16,565,"Oberstufenzentrum Arch","Gemeindeverband Oberstufenzentrum Arch",30,1.024]
[16,576,"IBEM-Region Gottstatt","Gemeindeverband Bildung Gottstatt",5,20]
[17,31,"Ecole primaire Cortébert","Commune municipale de Cortébert",15,0]
[18,32,"Ecole des Prés-de-Cortébert","Syndicat de communes de l'école des Prés-de-Cortébert",10,0]
[17,143,"Ecole enfantine et primaire Corgémont","Commune municipale de Corgémont",45,0]
[17,144,"Ecole secondaire du Bas-Vallon","Syndicat scolaire secondaire du Bas-Vallon",65,0]
[17,171,"Ecole primaire et enfantine de La Neuveville","Commune municipale de La Neuveville",80,5]
[17,212,"Ecole primaire et enfantine Orvin","Commune municipale Orvin",35,5]
[17,228,"Communauté scolaire du Plateau de Diesse","Communauté scolaire du Plateau de Diesse",65,5]
[17,231,"Ecole enfantine et primaire Péry-La Heutte","Commune municipale de Péry-La Heutte",40,0]
[17,457,"Ecole Primaire Sonceboz-Sombeval","Commune municipale de Sonceboz-Sombeval",65,15]
[17,482,"Communauté scolaire de La Baroche","Communauté scolaire de La Baroche",15,1.1240000000000001]
[17,556,"Bienne La Suze (Collège)","Einwohnergemeinde/Commune municipale  Biel/Bienne",80,10]
[17,557,"Bienne Platanes (Collège)","Einwohnergemeinde/Commune municipale  Biel/Bienne",80,10]
[17,558,"Bienne Châtelet (Collège)","Einwohnergemeinde/Commune municipale  Biel/Bienne",95,10]
[17,560,"Bienne Entité scolaire Centre","Einwohnergemeinde/Commune municipale  Biel/Bienne",130,15]
[17,561,"Bienne Entité scolaire Madretsch","Einwohnergemeinde/Commune municipale  Biel/Bienne",190,20]
[17,562,"Bienne Entité scolaire Boujean-Champagne","Einwohnergemeinde/Commune municipale  Biel/Bienne",80,10]
[17,563,"Bienne Entité scolaire Mâche","Einwohnergemeinde/Commune municipale  Biel/Bienne",155,10]
[17,567,"Ecole enfantine et primaire d'Evilard","Commune municipale/Einwohnergemeinde  Evilard/Leubringen",35,5]
[17,570,"Communauté scolaire du district de La Neuveville","Communauté scolaire du district de La Neuveville",65,5]
[17,579,"Ecole primaire de Jean-Gui","Communauté scolaire de Jean-Gui",5,0]
[17,585,"Bienne Service de ressources pédagogiques (SEREP)","Einwohnergemeinde/Commune municipale  Biel/Bienne",5,30]
[17,590,"Biel-Bienne FiBi ","Einwohnergemeinde/Commune municipale  Biel/Bienne",100,5]
[17,601,"Biel-Bienne FiBiS","Einwohnergemeinde/Commune municipale  Biel/Bienne",45,5]
[18,19,"Ecole primaire Perrefitte","Commune municipale de Perrefitte",10,1.4990000000000001]
[18,174,"Ecole du Syndicat Scolaire du Grand-Val","Syndicat Scolaire du Grand-Val",45,5]
[18,187,"Ecole de La Ferrière","Commune municipale de La Ferrière",10,0]
[18,229,"Ecole primaire Renan","Commune municipale de Renan",20,0]
[18,253,"Ecole primaire Saint-Imier","Commune municipale de Saint-Imier",120,25]
[18,254,"Ecole secondaire Saint-Imier","Commune municipale de Saint-Imier",75,0]
[18,356,"Ecoles primaires et enfantines de Moutier","Commune municipale de Moutier",150,20]
[18,357,"Ecole secondaire Moutier","Commune municipale de Moutier",85,5]
[18,370,"Ecoles enfantine et primaire de Court","Commune municipale de Court",35,5]
[18,377,"Ecole primaire Sorvilier","Commune municipale de Sorvilier",5,0.91700000000000004]
[18,381,"Ecole du Syndicat scolaire Courtelary-Cormoret-Villeret","Syndicat scolaire Courtelary-Cormoret-Villeret",95,0]
[18,459,"Ecole primaire Loveresse","Commune mixte de Loveresse",10,0.61799999999999999]
[18,466,"Ecoles de Reconvilier","Commune municipale de Reconvilier",90,10]
[18,469,"Ecole primaire Champoz","Commune municipale de Champoz",5,0.59499999999999997]
[18,501,"Ecole secondaire Tavannes","Commune municipale de Tavannes",45,5]
[18,502,"Ecole primaire Tavannes","Commune municipale de Tavannes",85,25]
[18,524,"Ecole primaire de la Printanière","Commune municipale de Tramelan",120,10]
[18,525,"Ecole secondaire Tramelan","Commune municipale de Tramelan",60,5]
[18,526,"Ecole primaire de Valbirse","Commune mixte de Valbirse",90,10]
[18,527,"Ecole secondaire du bas de la vallée","Syndicat Scolaire de l'école secondaire du bas de la vallée",65,5]
[18,568,"Ecole secondaire de la Courtine","Communauté de l'école secondaire de la Courtine",30,1.66]
[18,569,"Ecole primaire de Sonvilier","Commune municipale de Sonvilier",30,0]
[18,603,"Syndicat scolaire Saicourt-Petit-Val","Syndicat scolaire Saicourt-Petit-Val",30,5]
[18,834,"Ecole cantonale de langue française de Berne (ECLF) degré primaire","Office de l’enseignement obligatoire et du conseil (OECO)",65,10]
[18,836,"Ecole cantonale de langue française de Berne (ECLF) degré secondaire","Office de l’enseignement obligatoire et du conseil (OECO)",35,1.536]

{"sheet":"Anleitung","index":5,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Anleitung"]
["Alle SOE-Aenderungen müssen in der Tabelle 1 erfasst werden."]
["Bei neuen SOE's sind die Pool-Wert = 0."]
[]
[]
["Regeln"]