{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["READ ME","EPSM","A.Liste déroulante","B.Hors périmètre","1. T21_v04_données gén","2. T21v04_981_982","3. T21vo4_déc partic","4. Données PLAISIR","5. Qualif _Cibles transitoires","6. R19v01 DOT VAL","7.Doc DOT","202010_202005 EPSM_base"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":16,"comments":2,"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":"READ ME","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["No","Onglet","Description","Remarque"]
[null,"EPSM","Feuille de calcul dotation","Calcul"]
["A","Liste déroulante - établissements concernés","Mettre à jour avec onglet 2 et liste adresses mails","Tenir compte établissements hors périmètre"]
["B","Etablissements hors périmètre","Vérifier et mettre à jour"]
[1,"T21 SOHO vo finale","Etabl, lits, missions, EPTHote (coefficient EPT)","Données SOHO"]
[2,"T21 SOHO 981-982","EPSM : prestations d'accompagnement socio-éducatif","Données SOHO"]
[3,"T21 SOHO décisions particulières","Compléments de dotation exceptionnels","Données SOHO"]
[4,"Données Plaisir","Minutes moyennes de soins, deux derniers extrants","Données COGNOS, 4 janvier 2021"]
[5,"EPSM - Cibles transitoires qualification","Selon directive transitoire et annexe 1 2020/2021","Annexe à directive transitoire"]
[6,"R19_vo1_dotations - récapitulation","Données au 24.11.2020. OK vérifié le 4 janvier 2021","Données dossier Reporting"]
[7,"DOC DOT","Documentation dotation Fonctions NREF et FP"]

{"sheet":"EPSM","index":1,"n_rows":181,"n_cols":8,"rows_kept":181,"cut":false,"hidden":false,"merged":[[2,8,2,9],[113,1,113,2],[98,3,98,5],[105,1,105,2],[15,6,17,7],[3,2,3,3],[31,3,31,4],[3,4,3,5],[27,3,27,4],[27,1,27,2],[29,3,29,4],[29,1,29,2],[17,3,17,4],[15,3,15,4],[103,1,103,2],[36,7,36,9],[101,1,101,2],[76,5,77,7],[27,6,27,7],[31,6,31,7],[29,6,29,7],[31,1,31,2],[22,3,22,6],[24,6,24,7],[24,3,24,4],[128,6,128,7],[126,3,126,7],[117,1,117,2],[107,1,107,2],[128,2,128,3],[128,1,129,1],[128,4,128,5],[115,1,115,2],[20,5,20,6],[138,5,138,6],[136,5,136,6],[137,5,137,6],[0,1,0,7],[13,1,13,2],[9,3,9,7],[2,2,2,3],[13,3,13,4],[9,1,9,2],[11,3,11,7],[2,4,2,5],[4,1,4,7],[5,1,5,7],[11,1,11,2],[1,1,1,6]]}
[null,"Etablissements psycho-sociaux médicalisés (EPSM)"]
[null,"FEUILLE DE CALCUL DE DOTATION 2021 -  Annexe 2"]
[null,null,"Mise à jour :",null,"2021-01-05"]
[null,null,"Applicable : ",null,"Année 2021"]
[null,"Cette feuille de calcul présente la synthèse de vos dotations financées et exigées par la directive transitoire du DSAS du 17 décembre 2019 concernant les exigences de dotation minimale en personnel de soins et d'accompagnement socio-éducatif dans les établissements psycho-sociaux médicalisés (EPSM).  Les numéros indiqués font référence à cette directive et à son annexe 1 (avenant 2021)."]
[null,"Les dotations pour les cas de rigueur LAPRAMS ou octroyées par le SPEN ne sont pas prises en compte dans la présente feuille de calcul."]
[]
[null,"Etablissement"]
[]
[null,"No & Nom établissement (choisir dans la liste déroulante)",null,"217 ALEXANDRA EPSM"]
[]
[null,"Mission",null,{"$f":"VLOOKUP($D$14,$A$146:$I$181,4,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($D$14,$B$146:$H$178,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($D$14,$B$146:$H$178,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($D$14,$B$146:$H$178,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($D$14,$B$146:$H$178,7,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"Numéro UT (SOHO)",null,{"$f":"VLOOKUP($D$10,'A.Liste déroulante'!$A$2:$C$37,2,FALSE)","v":217}]
[]
[null,"Lits C dédiés au long séjour financés (*)",null,{"$f":"$C$49","v":17},null,null,"(*) Nombre de lits reconnus pour l'année 2021."]
[]
[null,"Lits C dédiés au court séjour conventionné financés (*):",null,{"$f":"$G$49","v":0}]
[]
[]
[null,"Long séjour : Minutes-soins nettes requises en moyenne par jour *",null,null,null,"Données extrants PLAISIR à saisir"]
[]
[null,null,null,"Données PLAISIR des  EXTRANTS d'octobre 2018 et de mai 2019"]
[]
[null,null,null,"Avant-dernier extrant PLAISIR",null,null,"Dernier extrant PLAISIR"]
[]
[]
[null,"LR3, colonne MSN OPAS, TOTAL"]
[]
[null,"Colonne Jour MSN OPAS (calculée)",null,{"$f":"D28-D32","v":0},null,null,{"$f":"G28-G32","v":0}]
[]
[null,"LR3, colonne Nuit MSN"]
[null,"* La dotation correspondant au financement résiduel complémentaire \"Plaisir 13+\" n'est pas incluse."]
[]
[null,"Paramètres de calcul",null,"Soins"]
[]
[null,"Heures par EPT et par année (jour)",null,{"$f":"$D$70","v":1711}]
[]
[null,"Taux de financement",null,{"$f":"$D$74","v":0.90600000000000003}]
[]
[]
[]
[]
[null,null,null,"Avant dernier extrant",null,null,"Dernier extrant"]
[null,"Jour (calculé)",null,{"$f":"+D30","v":0},null,null,{"$f":"+G30","v":0}]
[]
[null,"Nuit",null,{"$f":"D32","v":0},null,null,{"$f":"G32","v":0}]
[]
[null,"Lits C de LS (présaisie)",{"$f":"VLOOKUP($D$14,$A$146:$G$181,6,FALSE)","v":17},null,null,"Lits C de CS (présaisie)",{"$f":"VLOOKUP($D$14,$A$146:$G$181,7,FALSE)","v":0}]
[]
[null,"Soins"]
[]
["Heures annuelles de soins nettes par EPT"]
["Jours travaillés par année"]
["Jours",null,null,365]
["Week end",null,null,-104]
["Vacances",null,null,-25]
["Vacances : 6ème semaine 50+ (33% de l'effectif)",null,null,-1.65,null,"Mise à jour base données 2018 - dossier fin soins"]
["Jours fériés",null,null,-10]
["Absence maladie",null,null,-2]
["Absence formation",null,null,-3]
["Total",null,null,{"$f":"SUM(D55:D61)","v":219.35}]
[]
["Heures de soins nettes par jour"]
["Horaire de base 42h30 / semaine",null,null,8.5]
["pause 30 min",null,null,-0.5]
["Heure en moins dès 2009",null,null,-0.2]
["Total",null,null,{"$f":"SUM(D65:D67)","v":7.8}]
[null,null,null,{"$f":"D62*D68","v":1710.9299999999998}]
["Total heures de soins nettes par EPT",null,null,1711,null,"Arrondi - voir dossier 2018 financement soins"]
[]
[]
[]
["Taux de financement",null,null,0.90600000000000003,null,"Stable- révision prévue sur base reporting 2020"]
[]
["Minutes de soins requises par année"]
[null,"Jour",null,{"$f":"IF(ISERROR(((D45+G45)/2 + 21.23 * 88%) * D16 * 365 * 98%),0,((D45+G45)/2 + 21.23 * 88%) * D16 * 365 * 98%)","v":113605.80616000001},null,"88% jour, 12% nuit : mise à jour base données 2018 (dossier fin soins), harmonisé avec calcul coût de l'heure productive 2020-2021"]
[null,"Nuit",null,{"$f":"((D47+G47)/2 + 21.23 * 12%) * D16 * 365 * 98%","v":15491.700840000001}]
[]
[]
[]
[]
[]
["Traitements spécifiques au chapitre 3.2.1: Renforcement des veilles. Le barème en lits s'applique au total des lits de LS+CS autorisés."]
[]
[null,"\"Maintien des acquis et réhabilitation\" et \"Insertion socio-professionnelle\""]
[null,"Nb de lits min.","Nb de lits max.","Veille","Renforc. Soir","Total exigé"]
[null,1,30,2.2999999999999998,0,{"$f":"D88+E88","v":2.2999999999999998}]
[null,31,39,2.2999999999999998,0.9,{"$f":"D89+E89","v":3.1999999999999997}]
[null,40,79,4.5999999999999996,0,4.5999999999999996]
[]
[null,"Réduction des risques et engagement dans le suivi"]
[null,"Nb de lits min.","Nb de lits max.","Veille","Renforc. Soir","Total exigé"]
[null,1,30,2.2999999999999998,0,{"$f":"D94+E94","v":2.2999999999999998}]
[null,31,39,4.5999999999999996,0,{"$f":"D95+E95","v":4.5999999999999996}]
[null,40,79,4.5999999999999996,0,4.5999999999999996]
[]
[]
[null,"Nombre d'EPT financés",null,"Dotation soins",null,null,"Dotation socio-éducative - Long et court séjour ","Dotation totale soins et socio-éducative"]
[null,null,null,"Jour","Nuit /Soir","Total","Total","Total"]
[]
[null,"Nombre d'EPT requis selon évaluation PLAISIR",null,{"$f":"IF(OR(D28=0,G28=0),0,D77/($D$70*60))","v":0},{"$f":"IF(OR(D28=0,G28=0),0,D78/($D$70*60))","v":0},{"$f":"+E102+D102","v":0}]
[]
[null,"Nombre d'EPT selon taux de financement",null,{"$f":"D102*$D$39","v":0},{"$f":"E102*$D$39","v":0},{"$f":"+E104+D104","v":0},{"$f":"VLOOKUP($D$10,Tableau5[[Name + Long name]:[EPT SOHO ASE T2021]],6,FALSE)","v":1.7},{"$f":"F104+G104","v":1.7}]
[]
[null,"EPT minimum de veille",null,null,{"$f":"MAX((VLOOKUP(($D$16+$D$18),$B$88:$F$90,3,TRUE)),0)","v":2.2999999999999998},{"$f":"D106+E106","v":2.2999999999999998}]
[]
[null,"Nombre d'EPT après compensation jour/nuit (si nécessaire)",null,{"$f":"MAX(F104-E108,0)","v":0},{"$f":"MAX(E106,E104)","v":2.2999999999999998},{"$f":"+E108+D108","v":2.2999999999999998}]
[]
[null,"5.3.1 Renforts horaire du soir (19h-23h) en EPT **",null,null,{"$f":"IF($D$12=\"Réduction des risques et engagement dans le suivi\",0,IF(VLOOKUP(($D$16+$D$18),$B$88:$F$90,4,TRUE)>0,MAX(3.2-E108,0),0))","v":0},{"$f":"D110+E110","v":0},null,{"$f":"F110+G110","v":0}]
[]
[null,"5.3.2 Mission \"Réd.risques et engag.\" >=31 lits : renfort veilles ***",null,null,{"$f":"IF($D$12=\"Réduction des risques et engagement dans le suivi\",MAX((VLOOKUP(($D$16+$D$18),$B$94:$F$95,5,TRUE)-$E$108-$E$110),0),0)","v":0},{"$f":"D112+E112","v":0},null,{"$f":"F112+G112","v":0}]
[]
[null,"3 a) Court séjour conventionné : + 0.5 EPT auxiliaire par lit dédié",null,{"$f":"D18*0.5","v":0},null,{"$f":"+E114+D114","v":0},null,{"$f":"F114+G114","v":0}]
[]
[null,"Nombre d'EPT financés",null,{"$f":"SUM(D108:D114)","v":0},{"$f":"SUM(E108:E114)","v":2.2999999999999998},{"$f":"D116+E116","v":2.2999999999999998},{"$f":"G104","v":1.7},{"$f":"F116+G116","v":4}]
[]
[null,"Nombre d'EPT minimum exigés (soins : 10% de tolérance)",null,{"$f":"D116*0.9","v":0},{"$f":"E116","v":2.2999999999999998},{"$f":"D118+E118","v":2.2999999999999998},{"$f":"G116","v":1.7},{"$f":"F118+G118","v":4}]
[]
[null,"5.1 Minimas absolus niveau expertise (HES/ES)",null,null,null,1.26,null,3.03]
[]
[null,"5.5 Financement supplémentaire",null,{"$f":"IF(VLOOKUP($D$14,'3. T21vo4_déc partic'!$A$2:$M$39,10,FALSE)=0,\" \",VLOOKUP($D$14,'3. T21vo4_déc partic'!$A$2:$M$39,10,FALSE))","v":" "},null,null,{"$f":"VLOOKUP($D$14,'3. T21vo4_déc partic'!$A$2:$M$39,13,FALSE)","v":0},{"$f":"G122","v":0}]
[null,"** Les renforts pour l'horaire du soir font l'objet d'un financement spécifique."]
[null,"*** Pour cette mission, les renforts veilles font l'objet de financements spécifiques."]
[]
[]
[null,"5.2 Qualification - Cibles transitoires indicatives",null,{"$f":"D12","v":"Maintien des acquis et réhabilitation"}]
[]
[null,"Cibles transitoires indicatives - Degrés de qualification - Long séjour et court séjour conventionné","31 - Personnel de soins (hors veilles hors autres*)",null,"32 - Personnel socio-éducatif (hors autres*)",null,"31 et 32 - Personnel soins et socio-éducatif (hors veilles hors autres)"]
[null,null,"Cible en %","Cible en EPT","Cible en %","Cible en EPT","Cible en EPT","Reporting 2019"]
[null,"Niveau d'expertise (HES/ES)",{"$f":"IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$E$7,'5. Qualif _Cibles transitoires'!$C$7)","v":" Min 40%"},{"$f":"$D$116*0.4","v":0},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$N$7,IF($D$12=\"Maintien des acquis et réhabilitation\",'5. Qualif _Cibles transitoires'!$D$7,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$F$7)))","v":" Min 50%"},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$J$7,IF($D$12=\"Maintien des acquis et réhabilitation\",$G$116*0.5,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),$G$116*1)))","v":0.85},{"$f":"\"Min  \" & ROUND((D131+F131),2)","v":"Min  0.85"},{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$F$37,4,FALSE)","v":3.0300000000000002}]
[null,"Niveau assistance (CFC)",{"$f":"IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$E$8,'5. Qualif _Cibles transitoires'!$C$8)","v":" Max 40%"},{"$f":"$D$116*0.4","v":0},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$N$8,IF($D$12=\"Maintien des acquis et réhabilitation\",'5. Qualif _Cibles transitoires'!$D$8,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$F$8)))","v":" Max 50%"},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$J$8,IF($D$12=\"Maintien des acquis et réhabilitation\",$G$116*0.5,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),$G$116*0)))","v":0.85},{"$f":"\"Max  \" & ROUND((D132+F132),2)","v":"Max  0.85"},{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$F$37,5,FALSE)","v":1.39}]
[null,"Niveau soutien (auxiliaire)",{"$f":"IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$E$9,'5. Qualif _Cibles transitoires'!$C$9)","v":" Max 20%"},{"$f":"$D$116*0.2","v":0},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$N$9,IF($D$12=\"Maintien des acquis et réhabilitation\",'5. Qualif _Cibles transitoires'!$D$9,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),'5. Qualif _Cibles transitoires'!$F$9)))","v":0},{"$f":"IF($D$14=562,'5. Qualif _Cibles transitoires'!$J$9,IF($D$12=\"Maintien des acquis et réhabilitation\",$G$116*0,IF(OR($D$12=\"Réduction des risques et engagement dans le suivi\",$D$12=\"Insertion socio-professionnelle\"),$G$116*0)))","v":0},{"$f":"\"Max  \" & ROUND((D133+F133),2)","v":"Max  0"},{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$F$37,6,FALSE)","v":1.57}]
[null,"Total hors veilles hors autres",1,{"$f":"SUM(D131:D133)","v":0},1,{"$f":"SUM(F131:F133)","v":1.7},{"$f":"D134+F134","v":1.7},{"$f":"IF(OR(H131=\"n.a\",H132=\"n.a\",H133=\"n.a\"),\"n.a\",H131+H132+H133)","v":5.99}]
[null,"* Personnel de soins (31) sans veilleurs (31550) et sans autres (stagiaires, élèves, apprentis) (319XX)."]
[null,"** Personnel socio-éducatif (32) sans autres (stagiaires, élèves, apprentis) (329XX)."]
[null,null,null,null,null,"Pour info : Reporting 2019 Veilleurs (31550)",null,{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$Q$37,16,FALSE)","v":2.0299999999999998}]
[null,null,null,null,null,"Pour info : Reporting 2019 Fonctions NREF (31000 et 32000) :",null,{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$Q$37,7,FALSE)","v":0}]
[null,null,null,null,null,"Pour info : Reporting 2019 Fonctions FP FP (319xx et 329xx)",null,{"$f":"VLOOKUP($D$14,'6. R19v01 DOT VAL'!$A$2:$P$37,8,FALSE)","v":1.3599999999999999}]
[]
[null,null,null,null,null,null,"Date d'impression :",{"$f":"TODAY()","v":"2021-01-05"}]
[]
[]
[]
["Name","LongName","Name + Long name","ColMissionPa","CalLits T2021","Lits LS calculé","Lits CS Entré manuellement","EPT SOHO ASE T2021"]
[217,{"$f":"VLOOKUP($A146,Tableau15[],2,FALSE)","v":"ALEXANDRA EPSM"},{"$f":"A146&\" \"&B146","v":"217 ALEXANDRA EPSM"},{"$f":"VLOOKUP($A146,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A146,Tableau15[],7,FALSE)","v":17},{"$f":"E146-G146","v":17},0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.7}]
[254,{"$f":"VLOOKUP($A147,Tableau15[],2,FALSE)","v":"BOIS-GENTIL RUCHONNET EPSM"},"254 BOIS-GENTIL RUCHONNET EPSM",{"$f":"VLOOKUP($A147,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A147,Tableau15[],7,FALSE)","v":22},22,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.2000000000000002}]
[255,{"$f":"VLOOKUP($A148,Tableau15[],2,FALSE)","v":"BOIS-GENTIL VALLON EPSM"},"255 BOIS-GENTIL VALLON EPSM",{"$f":"VLOOKUP($A148,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A148,Tableau15[],7,FALSE)","v":32},32,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":4.8}]
[260,{"$f":"VLOOKUP($A149,Tableau15[],2,FALSE)","v":"BORDE EPSM"},"260 BORDE EPSM",{"$f":"VLOOKUP($A149,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A149,Tableau15[],7,FALSE)","v":25},25,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.5}]
[302,{"$f":"VLOOKUP($A150,Tableau15[],2,FALSE)","v":"TILLEULS EPSM"},"302 TILLEULS EPSM",{"$f":"VLOOKUP($A150,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A150,Tableau15[],7,FALSE)","v":27},27,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.7}]
[303,{"$f":"VLOOKUP($A151,Tableau15[],2,FALSE)","v":"CLOS BERCHER EPSM"},"303 CLOS BERCHER EPSM",{"$f":"VLOOKUP($A151,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A151,Tableau15[],7,FALSE)","v":27},27,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.7}]
[313,{"$f":"VLOOKUP($A152,Tableau15[],2,FALSE)","v":"BRU EPSM"},"313 BRU EPSM",{"$f":"VLOOKUP($A152,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A152,Tableau15[],7,FALSE)","v":61},61,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":6.1}]
[321,{"$f":"VLOOKUP($A153,Tableau15[],2,FALSE)","v":"COLOMBIERE EPSM"},"321 COLOMBIERE EPSM",{"$f":"VLOOKUP($A153,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A153,Tableau15[],7,FALSE)","v":18},18,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[324,{"$f":"VLOOKUP($A154,Tableau15[],2,FALSE)","v":"PRE CARRE EPSM"},"324 PRE CARRE EPSM",{"$f":"VLOOKUP($A154,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A154,Tableau15[],7,FALSE)","v":18},18,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[343,{"$f":"VLOOKUP($A155,Tableau15[],2,FALSE)","v":"CHAMP FLEURI EPSM"},"343 CHAMP FLEURI EPSM",{"$f":"VLOOKUP($A155,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A155,Tableau15[],7,FALSE)","v":38},38,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":5.7}]
[348,{"$f":"VLOOKUP($A156,Tableau15[],2,FALSE)","v":"COLLONGES EPSM"},"348 COLLONGES EPSM",{"$f":"VLOOKUP($A156,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A156,Tableau15[],7,FALSE)","v":15},15,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.5}]
[357,{"$f":"VLOOKUP($A157,Tableau15[],2,FALSE)","v":"ORPHEE EPSM"},"357 ORPHEE EPSM",{"$f":"VLOOKUP($A157,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A157,Tableau15[],7,FALSE)","v":25},25,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.5}]
[362,{"$f":"VLOOKUP($A158,Tableau15[],2,FALSE)","v":"SANS SOUCI EPSM"},"362 SANS SOUCI EPSM",{"$f":"VLOOKUP($A158,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A158,Tableau15[],7,FALSE)","v":36},36,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3.6}]
[365,{"$f":"VLOOKUP($A159,Tableau15[],2,FALSE)","v":"MYOSOTIS EPSM"},"365 MYOSOTIS EPSM",{"$f":"VLOOKUP($A159,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A159,Tableau15[],7,FALSE)","v":32},32,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3.2}]
[376,{"$f":"VLOOKUP($A160,Tableau15[],2,FALSE)","v":"SYLVABELLE EPSM"},"376 SYLVABELLE EPSM",{"$f":"VLOOKUP($A160,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A160,Tableau15[],7,FALSE)","v":28},28,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":4.2}]
[388,{"$f":"VLOOKUP($A161,Tableau15[],2,FALSE)","v":"DUC EPSM"},"388 DUC EPSM",{"$f":"VLOOKUP($A161,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A161,Tableau15[],7,FALSE)","v":15},15,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.5}]
[441,{"$f":"VLOOKUP($A162,Tableau15[],2,FALSE)","v":"AUBEPINES EPSM"},"441 AUBEPINES EPSM",{"$f":"VLOOKUP($A162,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A162,Tableau15[],7,FALSE)","v":18},18,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[476,{"$f":"VLOOKUP($A163,Tableau15[],2,FALSE)","v":"MIDI EPSM"},"476 MIDI EPSM",{"$f":"VLOOKUP($A163,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A163,Tableau15[],7,FALSE)","v":12},12,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.2}]
[478,{"$f":"VLOOKUP($A164,Tableau15[],2,FALSE)","v":"PRAZ-SECHAUD II EPSM"},"478 PRAZ-SECHAUD II EPSM",{"$f":"VLOOKUP($A164,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A164,Tableau15[],7,FALSE)","v":18},18,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[514,{"$f":"VLOOKUP($A165,Tableau15[],2,FALSE)","v":"TERRASSE EPSM"},"514 TERRASSE EPSM",{"$f":"VLOOKUP($A165,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A165,Tableau15[],7,FALSE)","v":24},24,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.4}]
[517,{"$f":"VLOOKUP($A166,Tableau15[],2,FALSE)","v":"SOLEIL EPSM"},"517 SOLEIL EPSM",{"$f":"VLOOKUP($A166,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A166,Tableau15[],7,FALSE)","v":40},40,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":4}]
[521,{"$f":"VLOOKUP($A167,Tableau15[],2,FALSE)","v":"CHANELLA EPSM"},"521 CHANELLA EPSM",{"$f":"VLOOKUP($A167,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A167,Tableau15[],7,FALSE)","v":21},21,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.1}]
[522,{"$f":"VLOOKUP($A168,Tableau15[],2,FALSE)","v":"POMMERAIE EPSM"},"522 POMMERAIE EPSM",{"$f":"VLOOKUP($A168,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A168,Tableau15[],7,FALSE)","v":13},13,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.3}]
[527,{"$f":"VLOOKUP($A169,Tableau15[],2,FALSE)","v":"BETHEL EPSM"},"527 BETHEL EPSM",{"$f":"VLOOKUP($A169,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A169,Tableau15[],7,FALSE)","v":22},5,17,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3.3}]
[534,{"$f":"VLOOKUP($A170,Tableau15[],2,FALSE)","v":"SOLEIL LEVANT EPSM"},"534 SOLEIL LEVANT EPSM",{"$f":"VLOOKUP($A170,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A170,Tableau15[],7,FALSE)","v":12},12,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[542,{"$f":"VLOOKUP($A171,Tableau15[],2,FALSE)","v":"POINT JOUR EPSM"},"542 POINT JOUR EPSM",{"$f":"VLOOKUP($A171,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A171,Tableau15[],7,FALSE)","v":11},11,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.1000000000000001}]
[544,{"$f":"VLOOKUP($A172,Tableau15[],2,FALSE)","v":"THIELE EPSM"},"544 THIELE EPSM",{"$f":"VLOOKUP($A172,Tableau15[],5,FALSE)","v":"Insertion socio-professionnelle"},{"$f":"VLOOKUP($A172,Tableau15[],7,FALSE)","v":18},18,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3.6}]
[545,{"$f":"VLOOKUP($A173,Tableau15[],2,FALSE)","v":"LYS EPSM"},"545 LYS EPSM",{"$f":"VLOOKUP($A173,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A173,Tableau15[],7,FALSE)","v":20},20,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3}]
[546,{"$f":"VLOOKUP($A174,Tableau15[],2,FALSE)","v":"ENVOL MORGES EPSM"},"546 ENVOL MORGES EPSM",{"$f":"VLOOKUP($A174,Tableau15[],5,FALSE)","v":"Insertion socio-professionnelle"},{"$f":"VLOOKUP($A174,Tableau15[],7,FALSE)","v":9},9,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[547,{"$f":"VLOOKUP($A175,Tableau15[],2,FALSE)","v":"ENVOL YVERDON EPSM"},"547 ENVOL YVERDON EPSM",{"$f":"VLOOKUP($A175,Tableau15[],5,FALSE)","v":"Insertion socio-professionnelle"},{"$f":"VLOOKUP($A175,Tableau15[],7,FALSE)","v":9},9,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.8}]
[549,{"$f":"VLOOKUP($A176,Tableau15[],2,FALSE)","v":"CROISEE DE JOUX EPSM"},"549 CROISEE DE JOUX EPSM",{"$f":"VLOOKUP($A176,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A176,Tableau15[],7,FALSE)","v":19},19,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.9}]
[551,{"$f":"VLOOKUP($A177,Tableau15[],2,FALSE)","v":"ROUVRAIE EPSM"},"551 ROUVRAIE EPSM",{"$f":"VLOOKUP($A177,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A177,Tableau15[],7,FALSE)","v":15},15,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.5}]
[553,{"$f":"VLOOKUP($A178,Tableau15[],2,FALSE)","v":"ROTILLON EPSM"},"553 ROTILLON EPSM",{"$f":"VLOOKUP($A178,Tableau15[],5,FALSE)","v":"Réduction des risques et engagement dans le suivi"},{"$f":"VLOOKUP($A178,Tableau15[],7,FALSE)","v":21},21,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":3.15}]
[558,{"$f":"VLOOKUP($A179,Tableau15[],2,FALSE)","v":"OISEAUX EPSM"},"558 OISEAUX EPSM",{"$f":"VLOOKUP($A179,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A179,Tableau15[],7,FALSE)","v":12},{"$f":"E179-G179","v":12},0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":1.2}]
[562,{"$f":"VLOOKUP($A180,Tableau15[],2,FALSE)","v":"ODMER EPSM"},"562 ODMER EPSM",{"$f":"VLOOKUP($A180,Tableau15[],5,FALSE)","v":"Mission spécifique"},{"$f":"VLOOKUP($A180,Tableau15[],7,FALSE)","v":40},40,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":5.1999999999999993}]
[566,{"$f":"VLOOKUP($A181,Tableau15[],2,FALSE)","v":"ROCHELLE EPSM"},"566 ROCHELLE EPSM",{"$f":"VLOOKUP($A181,Tableau15[],5,FALSE)","v":"Maintien des acquis et réhabilitation"},{"$f":"VLOOKUP($A181,Tableau15[],7,FALSE)","v":22},22,0,{"$f":"VLOOKUP(Tableau5[[#This Row],[Name]],'2. T21v04_981_982'!$A$1:$M$42,12,FALSE)","v":2.2000000000000002}]

{"sheet":"A.Liste déroulante","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["No et nom","Name","LongName","Direction adresse 1","Direction adresse 2","Direction adresse 3"]
[{"$f":"B2&\" \"&C2","v":"217 ALEXANDRA EPSM"},217,"ALEXANDRA EPSM","direction@cpsealexandra.ch"]
["254 BOIS-GENTIL RUCHONNET EPSM",254,"BOIS-GENTIL RUCHONNET EPSM","py.remy@fbg.ch","c.gillioz@fbg.ch"]
["255 BOIS-GENTIL VALLON EPSM",255,"BOIS-GENTIL VALLON EPSM","py.remy@fbg.ch","c.gillioz@fbg.ch"]
["260 BORDE EPSM",260,"BORDE EPSM","caffaro.direction@sispsa.ch"]
["302 TILLEULS EPSM",302,"TILLEULS EPSM","claude.paponnet@altage.ch","laurent.wymann@altage.ch","nathalie.correvon@altage.ch"]
["303 CLOS BERCHER EPSM",303,"CLOS BERCHER EPSM","dimitri.mocellin@fondation-espace.com","amela.ahmetovic@fondation-espace.com"]
["313 BRU EPSM",313,"BRU EPSM","alan.tharin@emsbru.ch"]
["321 COLOMBIERE EPSM",321,"COLOMBIERE EPSM","luis.villa@fondation-saphir.ch"]
["324 PRE CARRE EPSM",324,"PRE CARRE EPSM","luis.villa@fondation-saphir.ch"]
["343 CHAMP FLEURI EPSM",343,"CHAMP FLEURI EPSM","florian.rubio@champ-fleuri.ch"]
["348 COLLONGES EPSM",348,"COLLONGES EPSM","direction@maison-collonges.ch"]
["357 ORPHEE EPSM",357,"ORPHEE EPSM","direction@maison-collonges.ch"]
["362 SANS SOUCI EPSM",362,"SANS SOUCI EPSM","claude.paponnet@altage.ch","laurent.wymann@altage.ch","nathalie.correvon@altage.ch"]
["365 MYOSOTIS EPSM",365,"MYOSOTIS EPSM","myosotis@sefanet.ch","myosotis.qualite@sefanet.ch"]
["376 SYLVABELLE EPSM",376,"SYLVABELLE EPSM","kiny.mottier@altage.ch","nathalie.correvon@altage.ch","laurent.wymann@altage.ch"]
["388 DUC EPSM",388,"DUC EPSM","christine.semadeni@epsmduc.ch"]
["441 AUBEPINES EPSM",441,"AUBEPINES EPSM","caffaro.direction@sispsa.ch"]
["476 MIDI EPSM",476,"MIDI EPSM","caffaro.direction@sispsa.ch"]
["478 PRAZ-SECHAUD II EPSM",478,"PRAZ-SECHAUD II EPSM","claude.paponnet@altage.ch","laurent.wymann@altage.ch","nathalie.correvon@altage.ch"]
["514 TERRASSE EPSM",514,"TERRASSE EPSM","direction@fondationlaprimerose.ch"]
["517 SOLEIL EPSM",517,"SOLEIL EPSM","r.hartmann@fcm63.ch"]
["521 CHANELLA EPSM",521,"CHANELLA EPSM","serge.getaz@cogestems.ch","vincent.chappuis@cogestems.ch","claude.schnegg@cogestems.ch"]
["522 POMMERAIE EPSM",522,"POMMERAIE EPSM","serge.getaz@cogestems.ch","vincent.chappuis@cogestems.ch","claude.schnegg@cogestems.ch"]
["527 BETHEL EPSM",527,"BETHEL EPSM","kdelabaume@maison-bethel.ch"]
["534 SOLEIL LEVANT EPSM",534,"SOLEIL LEVANT EPSM","pascal.dubrit@levant.ch","georges.gottignies@levant.ch"]
["542 POINT JOUR EPSM",542,"POINT JOUR EPSM","direction.pdj@bluewin.ch"]
["544 THIELE EPSM",544,"THIELE EPSM","p.morales@fondation-simonin.ch","direction@foyerthiele.ch"]
["545 LYS EPSM",545,"LYS EPSM","pascal.dubrit@levant.ch","georges.gottignies@levant.ch"]
["546 ENVOL MORGES EPSM",546,"ENVOL MORGES EPSM","laurence.juriens@apsip.ch","envolmorges@apsip.ch"]
["547 ENVOL YVERDON EPSM",547,"ENVOL YVERDON EPSM","laurence.juriens@apsip.ch","envolmorges@apsip.ch"]
["549 CROISEE DE JOUX EPSM",549,"CROISEE DE JOUX EPSM","direction@croiseedejoux.ch"]
["551 ROUVRAIE EPSM",551,"ROUVRAIE EPSM","rouvraie@bluewin.ch"]
["553 ROTILLON EPSM",553,"ROTILLON EPSM","ebovitutti@lerotillon.ch"]
["558 OISEAUX EPSM",558,"OISEAUX EPSM","caffaro.direction@sispsa.ch"]
["562 ODMER EPSM",562,"ODMER EPSM","r.hartmann@fcm63.ch"]
["566 ROCHELLE EPSM",566,"ROCHELLE EPSM","kiny.mottier@altage.ch","laurent.wymann@altage.ch","nathalie.correvon@altage.ch"]

{"sheet":"B.Hors périmètre","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["No et nom","Name","LongName","Direction adresse 1","Direction adresse 2","Direction adresse 3"]
[{"$f":"B2&\" \"&C2","v":"496 VERNIE"},496,"VERNIE","direction@fondationlaprimerose.ch"]
[{"$f":"B3&\" \"&C3","v":"552 MANCINI PPS"},552,"MANCINI PPS","mancini&co@bluewin.ch "]
["554 PAROLE EPSM",554,"PAROLE EPSM","portner@chiffredelaparole.ch"]
["555 MAIEUTIQUE EPSM",555,"MAIEUTIQUE EPSM","muriel.reboh-serero@maieutique.ch"]
["560 TRAVERSE PPS",560,"TRAVERSE PPS","claude.paponnet@altage.ch","laurent.wymann@altage.ch","nathalie.correvon@altage.ch"]
[]
[]
[]
[]
[]
[null,"F calcul dotation 2021"]
[]
["Hors périmètre f calcul dotation"]
[496,"VERNIE EMS",null,"Unité Aventurine (15 lits PA)",null,"Données PLAISIR globales pour l'établissement (pas spécifiques à l'unité Aventurine PA)"]
[]
[552,"MANCINI PPS",null,"PPS - pas de financement soins . Hors périmètre directive transitoire"]
[560,"TRAVERSE PPS",null,"PPS - pas de financement soins . Hors périmètre directive transitoire"]
[555,"MAIEUTIQUE EPSM",null,"PPS - pas de financement soins . Hors périmètre directive transitoire",null,"Facturation forfait journalier LAMal pour l'hôpital de jour."]
[]
[554,"PAROLE EPSM",null,"Pas de financement soins - exception - pas de feuille de calcul dotation mais reçoivent l'information sur la directive transitoire."]
[]
[131,"ROSE VENTS EPSM",null,"ouverture février 2021 - pas de données PLAISIR"]

{"sheet":"1. T21_v04_données gén","index":4,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Name","LongName","Variante","ColMission","ColMissionPa","MissionPa","CalLits"]
[131,"ROSE VENTS EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",15]
[217,"ALEXANDRA EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",17]
[254,"BOIS-GENTIL RUCHONNET EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",22]
[255,"BOIS-GENTIL VALLON EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",32]
[260,"BORDE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",25]
[302,"TILLEULS EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",27]
[303,"CLOS BERCHER EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",27]
[313,"BRU EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",61]
[321,"COLOMBIERE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18]
[324,"PRE CARRE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18]
[343,"CHAMP FLEURI EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",38]
[348,"COLLONGES EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15]
[357,"ORPHEE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",25]
[362,"SANS SOUCI EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",36]
[365,"MYOSOTIS EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",32]
[376,"SYLVABELLE EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",28]
[388,"DUC EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15]
[441,"AUBEPINES EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18]
[476,"MIDI EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",12]
[478,"PRAZ-SECHAUD II EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18]
[514,"TERRASSE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",24]
[517,"SOLEIL EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",40]
[521,"CHANELLA EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",21]
[522,"POMMERAIE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",13]
[527,"BETHEL EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",22]
[534,"SOLEIL LEVANT EPSM","Standard-PA","Spécifique","Réduction des risques et engagement dans le suivi","REDUCTION",12]
[542,"POINT JOUR EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",11]
[544,"THIELE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",18]
[545,"LYS EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",20]
[546,"ENVOL MORGES EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",9]
[547,"ENVOL YVERDON EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",9]
[549,"CROISEE DE JOUX EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",19]
[551,"ROUVRAIE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15]
[552,"MANCINI PPS","Standard-PA","Psychiatrie adulte","Soutien dans les besoins de base","BASE",38]
[553,"ROTILLON EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",21]
[554,"PAROLE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",7]
[555,"MAIEUTIQUE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",26]
[558,"OISEAUX EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",12]
[560,"TRAVERSE PPS","Standard-PA","Psychiatrie adulte","Soutien dans les besoins de base","MAINTIEN",12]
[562,"ODMER EPSM","Standard-PA","Psychiatrie adulte","Mission spécifique","SPECIFIQUE",40]
[566,"ROCHELLE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",22]

{"sheet":"2. T21v04_981_982","index":5,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["Name","LongName","Variante","ColMission","ColMissionPa","MissionPa","CalLits","Code","PresSim2Dota","Code","PresSim2Dota","EPT TOT 981-982","DOT TOT"]
[131,"ROSE VENTS EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",15,981,3,982,0,{"$f":"I2+K2","v":3},{"$f":"L2/G2","v":0.2}]
[217,"ALEXANDRA EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",17,981,0.85,982,0.85,{"$f":"I3+K3","v":1.7},{"$f":"L3/G3","v":9.9999999999999992E-2}]
[254,"BOIS-GENTIL RUCHONNET EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",22,981,1.1000000000000001,982,1.1000000000000001,2.2000000000000002,0.1]
[255,"BOIS-GENTIL VALLON EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",32,981,4.8,982,0,4.8,0.15]
[260,"BORDE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",25,981,1.25,982,1.25,2.5,0.1]
[302,"TILLEULS EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",27,981,1.35,982,1.35,2.7,0.1]
[303,"CLOS BERCHER EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",27,981,1.35,982,1.35,2.7,0.1]
[313,"BRU EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",61,981,3.05,982,3.05,6.1,9.9999999999999992E-2]
[321,"COLOMBIERE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18,981,0.9,982,0.9,1.8,0.1]
[324,"PRE CARRE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18,981,0.9,982,0.9,1.8,0.1]
[343,"CHAMP FLEURI EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",38,981,5.7,982,0,5.7,0.15]
[348,"COLLONGES EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15,981,0.75,982,0.75,1.5,0.1]
[357,"ORPHEE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",25,981,1.25,982,1.25,2.5,0.1]
[362,"SANS SOUCI EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",36,981,1.8,982,1.8,3.6,0.1]
[365,"MYOSOTIS EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",32,981,1.6,982,1.6,3.2,0.1]
[376,"SYLVABELLE EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",28,981,4.2,982,0,4.2,0.15]
[388,"DUC EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15,981,0.75,982,0.75,1.5,0.1]
[441,"AUBEPINES EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18,981,0.9,982,0.9,1.8,0.1]
[476,"MIDI EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",12,981,0.6,982,0.6,1.2,9.9999999999999992E-2]
[478,"PRAZ-SECHAUD II EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",18,981,0.9,982,0.9,1.8,0.1]
[514,"TERRASSE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",24,981,1.2,982,1.2,2.4,9.9999999999999992E-2]
[517,"SOLEIL EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",40,981,2,982,2,4,0.1]
[521,"CHANELLA EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",21,981,1.05,982,1.05,2.1,0.1]
[522,"POMMERAIE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",13,981,0.65,982,0.65,1.3,0.1]
[527,"BETHEL EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",22,981,3.3,982,0,3.3,0.15]
[534,"SOLEIL LEVANT EPSM","Standard-PA","Spécifique","Réduction des risques et engagement dans le suivi","REDUCTION",12,981,1.8,982,0,1.8,0.15]
[542,"POINT JOUR EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",11,981,0.55000000000000004,982,0.55000000000000004,1.1000000000000001,0.1]
[544,"THIELE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",18,981,3.6,982,0,3.6,0.2]
[545,"LYS EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",20,981,3,982,0,3,0.15]
[546,"ENVOL MORGES EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",9,981,1.8,982,0,1.8,0.2]
[547,"ENVOL YVERDON EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",9,981,1.8,982,0,1.8,0.2]
[549,"CROISEE DE JOUX EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",19,981,0.95,982,0.95,1.9,9.9999999999999992E-2]
[551,"ROUVRAIE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",15,981,0.75,982,0.75,1.5,0.1]
[552,"MANCINI PPS","Standard-PA","Psychiatrie adulte","Soutien dans les besoins de base","BASE",38,981,0,982,0,0,0]
[553,"ROTILLON EPSM","Standard-PA","Psychiatrie adulte","Réduction des risques et engagement dans le suivi","REDUCTION",21,981,3.15,982,0,3.15,0.15]
[554,"PAROLE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",7,981,1.4,982,0,1.4,0.19999999999999998]
[555,"MAIEUTIQUE EPSM","Standard-PA","Psychiatrie adulte","Insertion socio-professionnelle","INSERTION",26,981,5.2,982,0,5.2,0.2]
[558,"OISEAUX EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",12,981,0.6,982,0.6,1.2,9.9999999999999992E-2]
[560,"TRAVERSE PPS","Standard-PA","Psychiatrie adulte","Soutien dans les besoins de base","MAINTIEN",12,981,0.6,982,0.6,1.2,9.9999999999999992E-2]
[562,"ODMER EPSM","Standard-PA","Psychiatrie adulte","Mission spécifique","SPECIFIQUE",40,981,3.8,982,1.4,5.1999999999999993,0.12999999999999998]
[566,"ROCHELLE EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",22,981,1.1000000000000001,982,1.1000000000000001,2.2000000000000002,0.1]

{"sheet":"3. T21vo4_déc partic","index":6,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Name","LongName","Variante","ColMission","ColMissionPa","MissionPa","CalLits","Code","Type","Precision","MontantJour","MontantAn","NbEpt"]
[131]
[217]
[254]
[255]
[260]
[302]
[303]
[313]
[321]
[324]
[343]
[348]
[357]
[362]
[365,"MYOSOTIS EPSM","Standard-PA","Psychiatrie adulte","Maintien des acquis et réhabilitation","MAINTIEN",32,1,"COMP_DECISION_PARTICULIERE","0.4 EPT pairs praticiens",2.75,31426.21,0.4]
[376]
[388]
[441]
[476]
[478]
[514]
[517]
[521]
[522]
[527]
[534]
[542]
[544]
[545]
[546]
[547]
[549]
[551]
[553]
[558]
[560,"TRAVERSE PPS","Standard-PA","Psychiatrie adulte","Soutien besoins de base","BASE",12,1,"COMP_DECISION_PARTICULIERE","0.5 EPT ASA",8.85,37918,0.5]
[562]
[566]

{"sheet":"4. Données PLAISIR","index":7,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["UA Jointure","Nom Jointure","Mandat","Lits T2021","202010 minutes jour+nuit OPAS","202010 minutes jour","202010 minutes nuit","202005 minutes jour+nuit OPAS","202005 minutes jour","202005 minutes nuit","202010 Nbre Résidents Evalués","202005 Nbre Résidents Evalués"]
[217,"ALEXANDRA EPSM","PA",17,115.69,103.25,12.46,102.34,92.82,10.029999999999999,12,12]
[254,"BOIS-GENTIL RUCHONNET EPSM","PA",22,118.1,109.04,9.07,108.22,99.88,8.9600000000000009,21,22]
[255,"BOIS-GENTIL VALLON EPSM","PA",32,120.69,111.09,9.7200000000000006,110.9,102.58,8.64,31,31]
[260,"BORDE EPSM","PA",25,188.07,177.97,11.32,150.75,142.16999999999999,9.6,25,25]
[302,"TILLEULS EPSM","PA",27,202.38,180,26.02,217.93,194.73,27.79,25,25]
[303,"CLOS BERCHER EPSM","PA",27,118.7,106.7,12.62,114.8,104.12,12.05,22,22]
[313,"BRU EPSM","PA",61,146.41,136.15,11.47,130.06,120.63,11.15,58,58]
[321,"COLOMBIERE EPSM","PA",18,113.96,106.49,9.7799999999999994,106.8,100.02,8.6999999999999993,18,18]
[324,"PRE CARRE EPSM","PA",18,112.9,105.25,12.27,104.69,97.42,11.09,19,18]
[343,"CHAMP FLEURI EPSM","PA",38,154.77000000000001,143.58000000000001,12.23,143.72999999999999,132.6,12.21,37,38]
[348,"COLLONGES EPSM","PA",15,97.24,92.21,6.4,93.31,88.04,6.55,14,14]
[357,"ORPHEE EPSM","PA",25,92.53,87.68,6.03,97.87,92.35,6.76,23,25]
[362,"SANS SOUCI EPSM","PA",36,137.96,122.79,15.26,134.76,119.8,15.86,32,32]
[365,"MYOSOTIS EPSM","PA",32,123.08,110.9,12.26,119.04,107.99,11.38,28,30]
[376,"SYLVABELLE EPSM","PA",28,132.85,123.36,9.6199999999999992,126.92,117.09,9.94,16,18]
[388,"DUC EPSM","PA",15,134.16999999999999,122.2,13.08,126.88,116.12,13.53,16,19]
[441,"AUBEPINES EPSM","PA",18,161.79,152.25,10.79,153.03,145.03,9.34,18,18]
[476,"MIDI EPSM","PA",12,153.87,148.85,7.75,155.72,150.41999999999999,8.32,12,12]
[478,"PRAZ SECHAUD II EPSM","PA",18,198.34,175.04,25.55,193.34,173.17,21.78,18,17]
[514,"TERRASSE EPSM","PA",24,135,122.59,13.5,131.66999999999999,119.72,13.23,23,25]
[517,"SOLEIL EPSM","PA",40,114.25,100.61,14.68,112.22,99.65,13.85,42,39]
[521,"CHANELLA EPSM","PA",21,119.32,108.49,11.27,110.42,101.91,9.23,22,19]
[522,"POMMERAIE EPSM","PA",13,123.74,112.94,10.91,107.33,98.32,9.5399999999999991,13,16]
[527,"BETHEL EPSM","PA",22,93.74,85.08,8.66,90.07,83.51,7.07,5,3]
[534,"SOLEIL LEVANT EPSM","PA",12,171.94,153.81,20.190000000000001,164.76,148.13,18.579999999999998,12,11]
[542,"POINT DU JOUR EPSM","PA",11,114.92,101.35,13.57,108.46,96.29,12.42,11,11]
[544,"THIELE EPSM","PA",18,103,98.11,4.88,96.9,91.24,5.66,18,19]
[545,"LYS EPSM","PA",20,112.29,104.09,8.2100000000000009,112.62,104.39,8.23,20,16]
[546,"ENVOL MORGES EPSM","PA",9,140.79,130.87,9.92,133.94,124.77,9.17,9,9]
[547,"ENVOL YVERDON EPSM","PA",9,140.57,134.01,6.56,114.88,107.48,7.41,9,8]
[549,"CROISEE DE JOUX EPSM","PA",19,93.69,91.97,1.72,83.68,82.4,1.59,17,14]
[551,"ROUVRAIE EPSM","PA",15,90.65,84.39,6.35,90.13,83.69,6.44,16,15]
[553,"ROTILLON EPSM","PA",21,139.9,131.11000000000001,10.92,123.44,114.03,9.41,21,21]
[558,"OISEAUX EPSM","PA",12,154.21,145.75,9.83,138.16999999999999,130.74,8.93,12,12]
[562,"ODMER EPSM","PA",40,90.037000000000006,82.474000000000004,10.821000000000002,87.635999999999996,80.572000000000003,9.5030000000000001,38,36]
[566,"ROCHELLE EPSM","PA",22,127.88,116.04,11.88,120.49,108.56,13.97,20,22]
[]
["ODMER : données pondérées, voir base Plaisir"]

{"sheet":"5. Qualif _Cibles transitoires","index":8,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":true,"merged":[[4,2,4,3],[4,4,4,5]]}
[]
[]
[null,"5.2 EPSM - Cibles transitoires : degrés de qualification par mission et par catégories de personnel 31 - 32 "]
[]
[null,"Missions","A. Maintien des acquis et réhabilitation",null,"B. Réduction des risques et engagement dans le suivi & C. Insertion socio-professionnelle",null,null,"562 ODMER Socio-éducatif",{"$f":"(28*0.1)+(12*0.2)","v":5.2000000000000011}]
[null,"Cibles transitoires - Degrés de qualification - Long séjour et court séjour conventionné","31 - Personnel de soins (hors veilles hors autres*)","32 - Personnel socio-éducatif (hors autres**)","31 - Personnel de soins (hors veilles hors autres*)","32 - Personnel socio-éducatif (hors autres**)",null,"28 lits Maintien","12 lits Insertion","Total","% mixte"]
[null,"Niveau d'expertise (HES/ES)"," Min 40%"," Min 50%"," Min 40%",1,null,{"$f":"28/40*$I$5*0.5","v":1.8200000000000003},{"$f":"12/40*$I$5*1","v":1.5600000000000003},{"$f":"H7+I7","v":3.3800000000000008},{"$f":"J7/$J$10","v":0.65},"Min",null,{"$f":"M7&\" \"&L7&\" \"&K7*100&\"%\"","v":" Min 65%"}]
[null,"Niveau assistance (CFC)"," Max 40%"," Max 50%"," Max 40%",0,null,{"$f":"28/40*$I$5*0.5","v":1.8200000000000003},{"$f":"12/40*$I$5*0","v":0},{"$f":"H8+I8","v":1.8200000000000003},{"$f":"J8/$J$10","v":0.35},"Max",null,{"$f":"M8&\" \"&L8&\" \"&K8*100&\"%\"","v":" Max 35%"}]
[null,"Niveau soutien (auxiliaire)"," Max 20%",0," Max 20%",0,null,0,0,0,{"$f":"J9/$J$10","v":0},null,null,{"$f":"M9&\" \"&L9&\" \"&K9*100&\"%\"","v":"  0%"}]
[null,"Total hors veilles hors autres",1,1,1,1,null,{"$f":"SUM(H7:H9)","v":3.6400000000000006},{"$f":"SUM(I7:I9)","v":1.5600000000000003},5.2000000000000011,1]
[null,"* Personnel de soins (31) sans veilleurs (31550) et sans autres (stagiaires, élèves, apprentis) (319XX)."]
[null,"** Personnel socio-éducatif (32) sans autres (stagiaires, élèves, apprentis) (329XX)."]

{"sheet":"6. R19v01 DOT VAL","index":9,"n_rows":45,"n_cols":36,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["Name","LongName","Variante","31-32 EXPERT","31-32 ASSIST","31-32 SOUTIEN hors veilleurs","31-32 NREF (31000- 32000)","31-32 FP","Code","Ept","Code","Ept","Code","Ept","Code veilleurs 31550","Ept","Code","Ept","Code (319xx)","Ept","Code","Ept","Code","Ept","Code","Ept","Code","Ept","Code (329xx)","Ept","Code","Ept","Contrôle 31","Code","Ept","Contrôle 32"]
[217,"ALEXANDRA EPSM","MonoSites",{"$f":"J2+V2","v":3.0300000000000002},{"$f":"L2+X2","v":1.39},{"$f":"N2-P2+Z2","v":1.57},{"$f":"R2+AB2","v":0},{"$f":"T2+AD2","v":1.3599999999999999},"31EXPERT",2.4500000000000002,"31ASSIST",0,"31SOUTIEN",2.0299999999999998,"31550",2.0299999999999998,"31NREF",0,"31FP",0.36,"32EXPERT",0.57999999999999996,"32ASSIST",1.39,"32SOUTIEN",1.57,"32NREF",0,"32FP",1,"31",4.8499999999999996,{"$f":"AF2-J2-L2-N2-R2-T2","v":9.9999999999996758E-3},"32",4.54,{"$f":"AI2-V2-X2-Z2-AB2-AD2","v":0}]
[254,"BOIS-GENTIL RUCHONNET EPSM","MonoSites",4.92,0.38,3.42,0,0.41,"31EXPERT",2.72,"31ASSIST",0,"31SOUTIEN",2.4300000000000002,"31550",2.4300000000000002,"31NREF",0,"31FP",0.41,"32EXPERT",2.2000000000000002,"32ASSIST",0.38,"32SOUTIEN",3.42,"32NREF",0,"32FP",0,"31",5.58,1.999999999999974E-2,"32",6.01,9.9999999999997868E-3]
[255,"BOIS-GENTIL VALLON EPSM","MonoSites",4.63,4.5999999999999996,0.83,0,0,"31EXPERT",3.44,"31ASSIST",0,"31SOUTIEN",5.32,"31550",5.32,"31NREF",0,"31FP",0,"32EXPERT",1.19,"32ASSIST",4.5999999999999996,"32SOUTIEN",0.83,"32NREF",0,"32FP",0,"31",8.77,9.9999999999997868E-3,"32",6.63,9.9999999999998979E-3]
[260,"BORDE EPSM","SitesMulti",8.8699999999999992,3.29,0,0,2.63,"31EXPERT",7.06,"31ASSIST",1.41,"31SOUTIEN",1.1200000000000001,"31550",1.1200000000000001,"31NREF",0,"31FP",1.41,"32EXPERT",1.81,"32ASSIST",1.88,"32SOUTIEN",0,"32NREF",0,"32FP",1.22,"31",11.01,1.0000000000000009E-2,"32",4.93,1.9999999999999796E-2]
[302,"TILLEULS EPSM","SitesMulti",6.27,3.35,8.9,0,0.57999999999999996,"31EXPERT",5.27,"31ASSIST",2.83,"31SOUTIEN",11.81,"31550",4.22,"31NREF",0,"31FP",0,"32EXPERT",1,"32ASSIST",0.52,"32SOUTIEN",1.31,"32NREF",0,"32FP",0.57999999999999996,"31",19.920000000000002,1.0000000000001563E-2,"32",3.42,9.9999999999998979E-3]
[303,"CLOS BERCHER EPSM","MonoSites",4.2299999999999995,1.95,1.4000000000000001,0,0,"31EXPERT",2.59,"31ASSIST",0.5,"31SOUTIEN",2.14,"31550",0.74,"31NREF",0,"31FP",0,"32EXPERT",1.64,"32ASSIST",1.45,"32SOUTIEN",0,"32NREF",0,"32FP",0,"31",5.23,4.4408920985006262E-16,"32",3.09,0]
[313,"BRU EPSM","SitesMulti",13.99,9.32,7.7600000000000007,0,2.13,"31EXPERT",10.64,"31ASSIST",5.0199999999999996,"31SOUTIEN",11.46,"31550",4.21,"31NREF",0,"31FP",0.28999999999999998,"32EXPERT",3.35,"32ASSIST",4.3,"32SOUTIEN",0.51,"32NREF",0,"32FP",1.84,"31",27.42,1.0000000000000731E-2,"32",10.01,1.0000000000000231E-2]
[321,"COLOMBIERE EPSM","SitesMulti",3.73,1.1499999999999999,4.91,0.06,0.41,"31EXPERT",1.91,"31ASSIST",1.1299999999999999,"31SOUTIEN",4.29,"31550",0,"31NREF",0.06,"31FP",0,"32EXPERT",1.82,"32ASSIST",0.02,"32SOUTIEN",0.62,"32NREF",0,"32FP",0.41,"31",7.4,1.0000000000000286E-2,"32",2.89,2.0000000000000073E-2]
[324,"PRE CARRE EPSM","SitesMulti",4.3499999999999996,0.82,3.98,0.06,1.0699999999999998,"31EXPERT",3.5,"31ASSIST",0.73,"31SOUTIEN",3.92,"31550",0,"31NREF",0.06,"31FP",0.56999999999999995,"32EXPERT",0.85,"32ASSIST",0.09,"32SOUTIEN",0.06,"32NREF",0,"32FP",0.5,"31",8.8000000000000007,2.0000000000000351E-2,"32",1.51,1.0000000000000009E-2]
[343,"CHAMP FLEURI EPSM","MonoSites",13.69,4.96,2.23,0.5,0.48,"31EXPERT",8.09,"31ASSIST",2.21,"31SOUTIEN",3.94,"31550",2.13,"31NREF",0.5,"31FP",0,"32EXPERT",5.6,"32ASSIST",2.75,"32SOUTIEN",0.42,"32NREF",0,"32FP",0.48,"31",14.76,2.0000000000000018E-2,"32",9.27,1.9999999999999962E-2]
[348,"COLLONGES EPSM","SitesMulti",5.2,0,0.75,0,1.08,"31EXPERT",3.2,"31ASSIST",0,"31SOUTIEN",2.71,"31550",1.96,"31NREF",0,"31FP",0,"32EXPERT",2,"32ASSIST",0,"32SOUTIEN",0,"32NREF",0,"32FP",1.08,"31",5.91,0,"32",3.08,0]
[357,"ORPHEE EPSM","SitesMulti",5.01,3.26,1.5,0,1.33,"31EXPERT",3.99,"31ASSIST",2,"31SOUTIEN",2.61,"31550",2.11,"31NREF",0,"31FP",0,"32EXPERT",1.02,"32ASSIST",1.26,"32SOUTIEN",1,"32NREF",0,"32FP",1.33,"31",8.6,-4.4408920985006262E-16,"32",4.62,9.9999999999997868E-3]
[362,"SANS SOUCI EPSM","SitesMulti",6.58,5.0500000000000007,5.9599999999999991,0,1.58,"31EXPERT",5.58,"31ASSIST",2.1,"31SOUTIEN",8.02,"31550",2.06,"31NREF",0,"31FP",0.57999999999999996,"32EXPERT",1,"32ASSIST",2.95,"32SOUTIEN",0,"32NREF",0,"32FP",1,"31",16.3,2.0000000000001461E-2,"32",4.95,0]
[365,"MYOSOTIS EPSM","MonoSites",7.6000000000000005,2.44,5.3,0,0.53,"31EXPERT",6.65,"31ASSIST",0,"31SOUTIEN",7.46,"31550",2.4700000000000002,"31NREF",0,"31FP",0,"32EXPERT",0.95,"32ASSIST",2.44,"32SOUTIEN",0.31,"32NREF",0,"32FP",0.53,"31",14.11,-8.8817841970012523E-16,"32",4.24,1.0000000000000009E-2]
[376,"SYLVABELLE EPSM","SitesMulti",6.93,3.15,3.8600000000000003,0,0,"31EXPERT",5.21,"31ASSIST",0,"31SOUTIEN",8.2200000000000006,"31550",4.3600000000000003,"31NREF",0,"31FP",0,"32EXPERT",1.72,"32ASSIST",3.15,"32SOUTIEN",0,"32NREF",0,"32FP",0,"31",13.44,9.9999999999997868E-3,"32",4.87,4.4408920985006262E-16]
[388,"DUC EPSM","MonoSites",3.4699999999999998,3.41,0,0,1.27,"31EXPERT",2.5099999999999998,"31ASSIST",0.97,"31SOUTIEN",2.4,"31550",2.4,"31NREF",0,"31FP",1.2,"32EXPERT",0.96,"32ASSIST",2.44,"32SOUTIEN",0,"32NREF",0,"32FP",7.0000000000000007E-2,"31",7.08,0,"32",3.48,1.0000000000000064E-2]
[441,"AUBEPINES EPSM","SitesMulti",5.48,1.8199999999999998,0.4,0,2.23,"31EXPERT",4.66,"31ASSIST",0.15,"31SOUTIEN",2.16,"31550",2.16,"31NREF",0,"31FP",1.65,"32EXPERT",0.82,"32ASSIST",1.67,"32SOUTIEN",0.4,"32NREF",0,"32FP",0.57999999999999996,"31",8.6300000000000008,1.0000000000000675E-2,"32",3.48,1.0000000000000231E-2]
[476,"MIDI EPSM","SitesMulti",5.17,1.44,0.35,0,2.31,"31EXPERT",3.77,"31ASSIST",0,"31SOUTIEN",1.1200000000000001,"31550",1.1200000000000001,"31NREF",0,"31FP",0.95,"32EXPERT",1.4,"32ASSIST",1.44,"32SOUTIEN",0.35,"32NREF",0,"32FP",1.36,"31",5.85,9.9999999999995648E-3,"32",4.5599999999999996,9.9999999999995648E-3]
[478,"PRAZ SECHAUD EPSM","SitesMulti",5.71,1,5.4799999999999995,0,0.66,"31EXPERT",5.21,"31ASSIST",0,"31SOUTIEN",11.09,"31550",5.61,"31NREF",0,"31FP",0.66,"32EXPERT",0.5,"32ASSIST",1,"32SOUTIEN",0,"32NREF",0,"32FP",0,"31",16.98,1.9999999999999685E-2,"32",1.5,0]
[514,"TERRASSE EPSM","SitesMulti",6.9,3.67,3.7199999999999998,0.4,0.25,"31EXPERT",6.23,"31ASSIST",1.91,"31SOUTIEN",6.3,"31550",2.58,"31NREF",0,"31FP",0,"32EXPERT",0.67,"32ASSIST",1.76,"32SOUTIEN",0,"32NREF",0.4,"32FP",0.25,"31",14.44,-8.8817841970012523E-16,"32",3.09,9.9999999999998979E-3]
[517,"SOLEIL EPSM","SitesMulti",10.71,4.1900000000000004,6.05,0,1,"31EXPERT",7.86,"31ASSIST",1.3,"31SOUTIEN",5.29,"31550",0,"31NREF",0,"31FP",0,"32EXPERT",2.85,"32ASSIST",2.89,"32SOUTIEN",0.76,"32NREF",0,"32FP",1,"31",14.46,1.0000000000000675E-2,"32",7.51,1.0000000000000009E-2]
[521,"CHANELLA EPSM","SitesMulti",5.17,2.31,0.77,0,0.41,"31EXPERT",3.62,"31ASSIST",0,"31SOUTIEN",3.37,"31550",2.6,"31NREF",0,"31FP",0,"32EXPERT",1.55,"32ASSIST",2.31,"32SOUTIEN",0,"32NREF",0,"32FP",0.41,"31",7,9.9999999999997868E-3,"32",4.28,1.0000000000000397E-2]
[522,"POMMERAIE EPSM","SitesMulti",2.9299999999999997,1.3,1,0,1.05,"31EXPERT",1.77,"31ASSIST",1.3,"31SOUTIEN",2.71,"31550",2.71,"31NREF",0,"31FP",0,"32EXPERT",1.1599999999999999,"32ASSIST",0,"32SOUTIEN",1,"32NREF",0,"32FP",1.05,"31",5.78,0,"32",3.22,1.0000000000000453E-2]
[527,"BETHEL EPSM","MonoSites",9.35,3.21,1.63,0.21,2.2000000000000002,"31EXPERT",8.25,"31ASSIST",2.21,"31SOUTIEN",2.46,"31550",0.83,"31NREF",0,"31FP",0,"32EXPERT",1.1000000000000001,"32ASSIST",1,"32SOUTIEN",0,"32NREF",0.21,"32FP",2.2000000000000002,"31",12.92,0,"32",4.5199999999999996,9.9999999999993427E-3]
[534,"SOLEIL LEVANT EPSM","MonoSites",8.2099999999999991,2.44,0,0.34,0.4,"31EXPERT",8.01,"31ASSIST",1.64,"31SOUTIEN",0.8,"31550",0.8,"31NREF",0.08,"31FP",0.4,"32EXPERT",0.2,"32ASSIST",0.8,"32SOUTIEN",0,"32NREF",0.26,"32FP",0,"31",10.94,9.9999999999997313E-3,"32",1.26,0]
[542,"POINT JOUR EPSM","MonoSites",4.5999999999999996,0.86,0,0,0,"31EXPERT",3.02,"31ASSIST",0,"31SOUTIEN",0.99,"31550",0.99,"31NREF",0,"31FP",0,"32EXPERT",1.58,"32ASSIST",0.86,"32SOUTIEN",0,"32NREF",0,"32FP",0,"31",4.01,-2.2204460492503131E-16,"32",2.44,-1.1102230246251565E-16]
[544,"THIELE EPSM","MonoSites",4.4499999999999993,0,1.2,2.36,0,"31EXPERT",1.4,"31ASSIST",0,"31SOUTIEN",0,"31550",0,"31NREF",2.36,"31FP",0,"32EXPERT",3.05,"32ASSIST",0,"32SOUTIEN",1.2,"32NREF",0,"32FP",0,"31",3.76,0,"32",4.25,2.2204460492503131E-16]
[545,"LYS EPSM","MonoSites",8.9600000000000009,0.71,0,0,1,"31EXPERT",4.55,"31ASSIST",0,"31SOUTIEN",2.5099999999999998,"31550",2.5099999999999998,"31NREF",0,"31FP",0,"32EXPERT",4.41,"32ASSIST",0.71,"32SOUTIEN",0,"32NREF",0,"32FP",1,"31",7.06,0,"32",6.12,0]
[546,"ENVOL EPSM","SitesMulti",4.34,0,0.2,0.3,0.5,"31EXPERT",1.1499999999999999,"31ASSIST",0,"31SOUTIEN",1.62,"31550",1.62,"31NREF",0,"31FP",0,"32EXPERT",3.19,"32ASSIST",0,"32SOUTIEN",0.2,"32NREF",0.3,"32FP",0.5,"31",2.77,0,"32",4.1900000000000004,0]
[547,"MUJON EPSM","SitesMulti",4.9800000000000004,1.1299999999999999,0,0.3,0.41,"31EXPERT",1.36,"31ASSIST",0,"31SOUTIEN",1.24,"31550",1.24,"31NREF",0,"31FP",0,"32EXPERT",3.62,"32ASSIST",1.1299999999999999,"32SOUTIEN",0,"32NREF",0.3,"32FP",0.41,"31",2.61,9.9999999999997868E-3,"32",5.47,9.9999999999997868E-3]
[549,"CROISEE DE JOUX EPSM","MonoSites",6.18,0.25,0.48,0,1.69,"31EXPERT",1.41,"31ASSIST",0,"31SOUTIEN",1.91,"31550",1.91,"31NREF",0,"31FP",0,"32EXPERT",4.7699999999999996,"32ASSIST",0.25,"32SOUTIEN",0.48,"32NREF",0,"32FP",1.69,"31",3.33,1.0000000000000231E-2,"32",7.19,0]
[551,"ROUVRAIE EPSM","MonoSites",4.67,2.38,0.6,0,0,"31EXPERT",1.97,"31ASSIST",0.13,"31SOUTIEN",2.91,"31550",2.91,"31NREF",0,"31FP",0,"32EXPERT",2.7,"32ASSIST",2.25,"32SOUTIEN",0.6,"32NREF",0,"32FP",0,"31",5.0199999999999996,9.9999999999997868E-3,"32",5.56,9.9999999999994538E-3]
[553,"ROTILLON EPSM","SitesMulti",7.5500000000000007,0,1.9,0,0,"31EXPERT",4.16,"31ASSIST",0,"31SOUTIEN",1.56,"31550",1.56,"31NREF",0,"31FP",0,"32EXPERT",3.39,"32ASSIST",0,"32SOUTIEN",1.9,"32NREF",0,"32FP",0,"31",5.72,-4.4408920985006262E-16,"32",5.3,9.9999999999997868E-3]
[558,"OISEAUX EPSM","MonoSites",2.3199999999999998,1,1,0,2,"31EXPERT",2.3199999999999998,"31ASSIST",0,"31SOUTIEN",2.12,"31550",1.1200000000000001,"31NREF",0,"31FP",1,"32EXPERT",0,"32ASSIST",1,"32SOUTIEN",0,"32NREF",0,"32FP",1,"31",5.45,1.0000000000000231E-2,"32",2,0]
[562,"ODMER EPSM","SitesMulti",8.2100000000000009,2.63,6.4200000000000008,0,0.16,"31EXPERT",4.4400000000000004,"31ASSIST",1,"31SOUTIEN",4.82,"31550",0.1,"31NREF",0,"31FP",0,"32EXPERT",3.77,"32ASSIST",1.63,"32SOUTIEN",1.7,"32NREF",0,"32FP",0.16,"31",10.26,-8.8817841970012523E-16,"32",7.27,9.9999999999997036E-3]
[566,"ROCHELLE EPSM","SitesMulti","n.a","n.a","n.a","n.a","n.a",null,null,null,null,null,null,"31550","n.a"]
[]
[null,"Totaux",null,{"$f":"SUM(D2:D37)","v":218.39},{"$f":"SUM(E2:E37)","v":78.859999999999971},{"$f":"SUM(F2:F37)","v":83.57},{"$f":"SUM(G2:G37)","v":4.5299999999999994},{"$f":"SUM(H2:H37)","v":31.13},null,{"$f":"SUM(J2:J37)","v":149.97},null,{"$f":"SUM(L2:L37)","v":28.540000000000003},null,{"$f":"SUM(N2:N37)","v":134.85999999999999},null,{"$f":"SUM(P2:P37)","v":69.929999999999993},null,{"$f":"SUM(R2:R37)","v":3.0599999999999996},null,{"$f":"SUM(T2:T37)","v":9.4799999999999986},null,{"$f":"SUM(V2:V37)","v":68.419999999999987},null,{"$f":"SUM(X2:X37)","v":50.32},null,{"$f":"SUM(Z2:Z37)","v":18.639999999999997},null,{"$f":"SUM(AB2:AB37)","v":1.47},null,{"$f":"SUM(AD2:AD37)","v":21.650000000000002},null,{"$f":"SUM(AF2:AF37)","v":326.16999999999996},{"$f":"SUM(AG2:AG37)","v":0.26000000000000023},null,{"$f":"SUM(AI2:AI37)","v":160.75000000000003},{"$f":"SUM(AJ2:AJ37)","v":0.2499999999999987}]
[]
[null,null,null,null,null,null,null,{"$f":"D39+E39+F39+G39+H39+P39","v":486.40999999999991},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,{"$f":"AF39+AI39","v":486.91999999999996},{"$f":"AI41-$H$41","v":0.51000000000004775}]
[]
[]
[]
[566,"ROCHELLE EPSM","SitesMulti",{"$f":"J45+V45","v":0.87},{"$f":"L45+X45","v":0.86},{"$f":"N45-P45+Z45","v":0},{"$f":"R45+AB45","v":0},{"$f":"T45+AD45","v":0.33},"31EXPERT",0.87,"31ASSIST",0.26,"31SOUTIEN",0.56000000000000005,"31550",0.56000000000000005,"31NREF",0,"31FP",0,"32EXPERT",0,"32ASSIST",0.6,"32SOUTIEN",0,"32NREF",0,"32FP",0.33,"31",1.7,{"$f":"AF45-J45-L45-N45-R45-T45","v":9.9999999999998979E-3},"32",0.93,{"$f":"AI45-V45-X45-Z45-AB45-AD45","v":0}]

{"sheet":"7.Doc DOT","index":10,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["31000 - Autre personnel soignant ou fonctions non référencées - NREF",null,"Intégré au total du groupe 31"]
["32000 - Autre personnel paramédical ou fonctions non référencées - NREF",null,"Intégré au total du groupe 32"]
[]
[]
["FonctionNr","FonctionLibelle"]
[31900,"31900 - Etudiant infirmier en stage - FP","Intégré au total du groupe 31"]
[31903,"31903 - Jeune auxiliaire de remplacement vacances (pas de formation) - FP","Intégré au total du groupe 31"]
[31904,"31904 - Pré-apprenti ou apprenti - FP","Intégré au total du groupe 31"]
[31905,"31905 - Pré-stagiaire en vue d'une formation professionnelle - FP","Intégré au total du groupe 31"]
[31999,"31999 - Personnel de soins \"à conditions particulières\" - FP","Intégré au total du groupe 31"]
[32901,"32901 - Stagiaire en animation ou en éducation - FP","Intégré au total du groupe 32"]
[32904,"32904 - Pré-apprenti ou apprenti - FP","Intégré au total du groupe 32"]
[32905,"32905 - Pré-stagiaire en vue d'une formation professionnelle - FP","Intégré au total du groupe 32"]
[32999,"32999 - Personnel paramédical \"à conditions particulières\" - FP","Intégré au total du groupe 32"]

{"sheet":"202010_202005 EPSM_base","index":11,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":true,"merged":[[0,0,0,13]]}
["Minutes Plaisir"]
["No Plaisir","UA Jointure","Nom Jointure","Mandat","Lits T2021","Nom EMS","202010 minutes jour+nuit OPAS","202010 minutes jour","202010 minutes nuit","202005 minutes jour+nuit OPAS","202005 minutes jour","202005 minutes nuit","202010 Nbre Résidents Evalués","202005 Nbre Résidents Evalués"]
["01217",217,"ALEXANDRA EPSM","PA",17,"CENTRE HEBERGEMENT PSY EMS",115.69,103.25,12.46,102.34,92.82,10.029999999999999,12,12]
["01417",254,"BOIS-GENTIL RUCHONNET EPSM","PA",22,"FOYER FEMININ ARMEE SALUT EPSM",118.1,109.04,9.07,108.22,99.88,8.9600000000000009,21,22]
["01416",255,"BOIS-GENTIL VALLON EPSM","PA",32,"RESIDENCE ARMEE SALUT EPSM",120.69,111.09,9.7200000000000006,110.9,102.58,8.64,31,31]
["01260",260,"BORDE EPSM","PA",25,"BORDE SISP EMS",188.07,177.97,11.32,150.75,142.16999999999999,9.6,25,25]
["01302",302,"TILLEULS EPSM","PA",27,"TILLEULS HOME-AGE EMS",202.38,180,26.02,217.93,194.73,27.79,25,25]
["01303",303,"CLOS BERCHER EPSM","PA",27,"CLOS BERCHER BOAS EMS",118.7,106.7,12.62,114.8,104.12,12.05,22,22]
["01313",313,"BRU EPSM","PA",61,"BRU EPSM",146.41,136.15,11.47,130.06,120.63,11.15,58,58]
["01321",321,"COLOMBIERE EPSM","PA",18,"COLOMBIERE MONT-RIANT EMS",113.96,106.49,9.7799999999999994,106.8,100.02,8.6999999999999993,18,18]
["01324",324,"PRE CARRE EPSM","PA",18,"PRE CARRE MONT-RIANT EMS",112.9,105.25,12.27,104.69,97.42,11.09,19,18]
["01343",343,"CHAMP FLEURI EPSM","PA",38,"CHAMP FLEURI EMS",154.77000000000001,143.58000000000001,12.23,143.72999999999999,132.6,12.21,37,38]
["01349",348,"COLLONGES EPSM","PA",15,"COLLONGES EMS",97.24,92.21,6.4,93.31,88.04,6.55,14,14]
["01347",357,"ORPHEE EPSM","PA",25,"MAISON ORPHEE EMS",92.53,87.68,6.03,97.87,92.35,6.76,23,25]
["01362",362,"SANS SOUCI EPSM","PA",36,"SANS SOUCI HOME-AGE EMS",137.96,122.79,15.26,134.76,119.8,15.86,32,32]
["01365",365,"MYOSOTIS EPSM","PA",32,"MYOSOTIS MONTHEROD EMS",123.08,110.9,12.26,119.04,107.99,11.38,28,30]
["01376",376,"SYLVABELLE EPSM","PA",28,"SYLVABELLE EMS",132.85,123.36,9.6199999999999992,126.92,117.09,9.94,16,18]
["01415",388,"DUC EPSM","PA",15,"DUC EPSM",134.16999999999999,122.2,13.08,126.88,116.12,13.53,16,19]
["01441",441,"AUBEPINES EPSM","PA",18,"AUBEPINES SISP EMS",161.79,152.25,10.79,153.03,145.03,9.34,18,18]
["01476",476,"MIDI EPSM","PA",12,"MIDI FOYER SISP EMS",153.87,148.85,7.75,155.72,150.41999999999999,8.32,12,12]
["01478",478,"PRAZ SECHAUD II EPSM","PA",18,"PRAZ-SECHAUD II HOME-AGE EMS",198.34,175.04,25.55,193.34,173.17,21.78,18,17]
["01514",514,"TERRASSE EPSM","PA",24,"TERRASSE PRIMEROSE EMS",135,122.59,13.5,131.66999999999999,119.72,13.23,23,25]
["01463",517,"SOLEIL EPSM","PA",40,"RESIDENCE SOLEIL MAGNIN EMS",114.25,100.61,14.68,112.22,99.65,13.85,42,39]
["01460-01",521,"CHANELLA EPSM","PA",21,"CHANELLA GETAZ EMS",119.32,108.49,11.27,110.42,101.91,9.23,22,19]
["01460-02",522,"POMMERAIE EPSM","PA",13,"POMMERAIE GETAZ EMS",123.74,112.94,10.91,107.33,98.32,9.5399999999999991,13,16]
["01518",527,"BETHEL EPSM","PA",22,"BETHEL PRAZ-SOLEIL EMS",93.74,85.08,8.66,90.07,83.51,7.07,5,3]
["01270",534,"SOLEIL LEVANT EPSM","PA",12,"FONDATION DU LEVANT",171.94,153.81,20.190000000000001,164.76,148.13,18.579999999999998,12,11]
["01494",542,"POINT DU JOUR EPSM","PA",11,"POINT JOUR EMS",114.92,101.35,13.57,108.46,96.29,12.42,11,11]
["01414",544,"THIELE EPSM","PA",18,"THIELE (SIMONIN) EPSM",103,98.11,4.88,96.9,91.24,5.66,18,19]
["01419",545,"LYS EPSM","PA",20,"LYS EPSM",112.29,104.09,8.2100000000000009,112.62,104.39,8.23,20,16]
["01418",546,"ENVOL MORGES EPSM","PA",9,"ENVOL (APSIP) EPSM",140.79,130.87,9.92,133.94,124.77,9.17,9,9]
["01420",547,"ENVOL YVERDON EPSM","PA",9,"MUJON (APSIP) EPSM",140.57,134.01,6.56,114.88,107.48,7.41,9,8]
["01411",549,"CROISEE DE JOUX EPSM","PA",19,"CROISEE DE JOUX ABBAYE EPSM",93.69,91.97,1.72,83.68,82.4,1.59,17,14]
["01413",551,"ROUVRAIE EPSM","PA",15,"ROUVRAIE (DEO GRATIAS) EPSM",90.65,84.39,6.35,90.13,83.69,6.44,16,15]
["01412",553,"ROTILLON EPSM","PA",21,"ROTILLON (ORME) EPSM",139.9,131.11000000000001,10.92,123.44,114.03,9.41,21,21]
["01346",558,"OISEAUX EPSM","PA",12,"LES OISEAUX ACHILLE ALEX EPSM",154.21,145.75,9.83,138.16999999999999,130.74,8.93,12,12]
["01410",562,"ODMER EPSM MAINT","PA",28,"ENTRAIDE (MAGNIN) EPSM",89.5,82.09,11.4,85.02,77.89,9.17,27,26]
["01430",562,"ODMER EPSM INSERT","PA",12,"ODMER JEUNES",91.29,83.37,9.4700000000000006,93.74,86.83,10.28,11,10]
["01430",562,"ODMER EPSM","PA",40,"ODMER total",90.037000000000006,82.474000000000004,10.821000000000002,87.635999999999996,80.572000000000003,9.5030000000000001,38,36]
["01566",566,"ROCHELLE EPSM","PA",22,"EPSM LA ROCHELLE",127.88,116.04,11.88,120.49,108.56,13.97,20,22]