{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Lits NSA-LPH","Tableau de bord","Chambres","Menus (données)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":10},"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":"Lits NSA-LPH","index":0,"n_rows":5,"n_cols":37,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["Site","No chambre","Catégorie","Statut","Nom","Prénom","Numéro\ndossier","Date de\nnaissance","Âge","Groupe d'âge","Date dépôt demande","Motif de la\ndemande","Provenance","Date\nd'admission","Classif.\nà planifier","Durée prévue (en jours)","Profil à\nl'arrivée","ISO SMAF\narrivée","Usager actif au SAD","Justification admission","Date de fin\nSoins actifs","Soins actifs","Date \ncongé prévu","Date \ncongé","Orientation au congé","Profil au congé","ISO SMAF\ncongé","Référence au SAD","Temps attente (dépôt/adm.)","Durée séjour","Date dépôt MAH","Date orientation","Temps attente orientation vs sortie","Bloquants\nEnjeux","Commentaires","Année financière","Période"]
["René_Léosa",18,{"$f":"VLOOKUP(B3,Chambres!$A$2:$C$33,3,FALSE)","v":"Régulier"},{"$f":"IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]=\"\"),\"Occupée\",IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",\"Congé\",\"Libre\"))","v":"Congé"},null,null,"P082714","1944-11-18",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":76},{"$f":"IF(Tableau1[[#This Row],[Âge]]<=60,\"60 et -\",IF(Tableau1[[#This Row],[Âge]]<=65,\"61-65\",IF(Tableau1[[#This Row],[Âge]]<=70,\"66-70\",IF(Tableau1[[#This Row],[Âge]]<=75,\"71-75\",IF(Tableau1[[#This Row],[Âge]]<=80,\"76-80\",IF(Tableau1[[#This Row],[Âge]]<=85,\"81-85\",IF(Tableau1[[#This Row],[Âge]]<=110,\"86 et +\",\"\")))))))","v":"76-80"},"2021-03-10","Éval-ori","HSC","2021-03-15",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":"2021-04-29"},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-06-17"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-06-17",null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":5},{"$f":"IFERROR(IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]<>\"\"),DATEDIF(Tableau1[[#This Row],[Date\nd''admission]],Tableau1[[#This Row],[Date \ncongé]],\"D\"),\"\"),\"\")","v":94},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",18,{"$f":"VLOOKUP(B4,Chambres!$A$2:$C$33,3,FALSE)","v":"Régulier"},{"$f":"IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]=\"\"),\"Occupée\",IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",\"Congé\",\"Libre\"))","v":"Libre"},null,null,null,null,{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":""},{"$f":"IF(Tableau1[[#This Row],[Âge]]<=60,\"60 et -\",IF(Tableau1[[#This Row],[Âge]]<=65,\"61-65\",IF(Tableau1[[#This Row],[Âge]]<=70,\"66-70\",IF(Tableau1[[#This Row],[Âge]]<=75,\"71-75\",IF(Tableau1[[#This Row],[Âge]]<=80,\"76-80\",IF(Tableau1[[#This Row],[Âge]]<=85,\"81-85\",IF(Tableau1[[#This Row],[Âge]]<=110,\"86 et +\",\"\")))))))","v":""},null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":false},null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":""},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Oui"},null,null,null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":0},{"$f":"IFERROR(IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]<>\"\"),DATEDIF(Tableau1[[#This Row],[Date\nd''admission]],Tableau1[[#This Row],[Date \ncongé]],\"D\"),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",18,{"$f":"VLOOKUP(B5,Chambres!$A$2:$C$33,3,FALSE)","v":"Régulier"},{"$f":"IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]=\"\"),\"Occupée\",IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",\"Congé\",\"Libre\"))","v":"Occupée"},null,null,"P007626","1958-04-19",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":63},{"$f":"IF(Tableau1[[#This Row],[Âge]]<=60,\"60 et -\",IF(Tableau1[[#This Row],[Âge]]<=65,\"61-65\",IF(Tableau1[[#This Row],[Âge]]<=70,\"66-70\",IF(Tableau1[[#This Row],[Âge]]<=75,\"71-75\",IF(Tableau1[[#This Row],[Âge]]<=80,\"76-80\",IF(Tableau1[[#This Row],[Âge]]<=85,\"81-85\",IF(Tableau1[[#This Row],[Âge]]<=110,\"86 et +\",\"\")))))))","v":"61-65"},"2021-04-07","Conval","HSC","2021-04-08",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":"2021-05-23"},null,110,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":""},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Oui"},null,null,null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":1},{"$f":"IFERROR(IF(AND(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",Tableau1[[#This Row],[Date \ncongé]]<>\"\"),DATEDIF(Tableau1[[#This Row],[Date\nd''admission]],Tableau1[[#This Row],[Date \ncongé]],\"D\"),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]

{"sheet":"Tableau de bord","index":1,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[[32,1,32,2],[16,10,17,14],[1,1,1,14],[4,10,4,14],[4,4,4,5],[4,1,4,2],[14,1,14,2],[4,7,4,8],[14,4,14,5],[12,7,12,8]]}
[]
[null,"Tableau de bord"]
[]
[null,"Statut","Congé"]
[null,"Durée moyenne de séjour par site",null,null,"Durée moyenne d'attente du dépôt de la demande à l'admission par site",null,null,"Nombre d'usagers admis actifs au SAD",null,null,"Portrait des profils par usager à l'admission selon le site"]
[null,"Sites","DMS",null,"Site","Moyenne attente",null,"Actif au SAD","Nombre de Nom",null,null,"Sites"]
[null,"CFGH",52.863636363636367,null,"CFGH",6.8990825688073398,null,"Non",60,null,"Profil","CFGH","René_Léosa","_600_Bousquet_HT","_600_Bousquet_NSA","Total général"]
[null,"René_Léosa",34,null,"René_Léosa",4.4749999999999996,null,"Oui",138,null,110]
[null,"_600_Bousquet_NSA",34.478260869565219,null,"_600_Bousquet_HT",3,null,"(vide)",30,null,121]
[null,"Total général",42.863874345549739,null,"_600_Bousquet_NSA",3.625,null,"Total général",228,null,191]
[null,null,null,null,"Total général",5.321739130434783,null,null,null,null,192]
[null,null,null,null,null,null,null,null,null,null,210]
[null,null,null,null,null,null,null,"Nombre d'usagers ayant un profil ISO SMAF au congé",null,null,710]
[null,null,null,null,null,null,null,"ISO SMAF","Nombre de \ncongés",null,"(vide)"]
[null,"Orientation de l'usager au congé",null,null,"Provenance des demandes déposées",null,null,1,6,null,"Total général"]
[null,"Orientation","Nombre de congé",null,"Provenance","Nombre demandes",null,2,2]
[null,"CHSLD",24,null,"Autre",37,null,3,2,null,"Portrait des profils par usager au congé selon le site"]
[null,"Décès",6,null,"CH ext.",8,null,4,4]
[null,"Relocalisation RPA",41,null,"CHUS",11,null,5,2,null,"Nombre par profil","Sites"]
[null,"Retour à domicile",73,null,"HSC",166,null,6,8,null,"Profil","CFGH","René_Léosa","_600_Bousquet_HT","_600_Bousquet_NSA","Total général"]
[null,"TR NSA",3,null,"(vide)",4,null,7,8,null,110,null,5,null,1,6]
[null,"(vide)",18,null,"UCDG",1,null,8,13,null,192,null,null,null,2,2]
[null,"Relocalisation RI physique",4,null,"Total général",227,null,9,10,null,210,2,2,null,1,5]
[null,"Retour au CH",15,null,null,null,null,10,9,null,710,65,15,null,40,120]
[null,"RAD",1,null,null,null,null,11,13,null,"(vide)",24,9,null,24,57]
[null,"Maison S. Pall.",3,null,null,null,null,12,6,null,191,null,3,null,2,5]
[null,"Unité soins pall. CH",1,null,null,null,null,13,4,null,121,2,null,null,null,2]
[null,"Relocalisation RI cognitive",6,null,null,null,null,14,1,null,"Total général",93,34,null,70,197]
[null,"TR LPH Ext. À Int.",1,null,null,null,null,"(vide)",109]
[null,"Relocalisation RTF",1,null,null,null,null,"Total général",197]
[null,"Total général",197]
[]
[null,"Nombre d'admissions par groupe d'âge"]
[null,"Groupes d'âges","Nombre de Nom",null,"Nombre de chambre","Statut"]
[null,null,4,null,"Sites","Libre","Occupée","Total général"]
[null,"60 et -",8,null,"CFGH"]
[null,"61-65",12,null,1048,null,1,1]
[null,"66-70",19,null,1049,null,1,1]
[null,"71-75",19,null,1050,null,1,1]
[null,"76-80",30,null,1051,null,1,1]
[null,"81-85",45,null,1052,null,1,1]
[null,"86 et +",91,null,1053,null,1,1]
[null,"Total général",228,null,1054,null,1,1]
[null,null,null,null,1056,1,null,1]
[null,null,null,null,1058,null,1,1]
[null,null,null,null,1059,null,1,1]
[null,null,null,null,1062,null,1,1]
[null,null,null,null,1063,1,null,1]
[null,null,null,null,1064,null,1,1]
[null,null,null,null,"1079A",null,1,1]
[null,null,null,null,"1079B",null,1,1]
[null,null,null,null,"Total CFGH",2,13,15]
[null,null,null,null,"René_Léosa"]
[null,null,null,null,11,null,1,1]
[null,null,null,null,13,null,1,1]
[null,null,null,null,14,null,1,1]
[null,null,null,null,15,null,1,1]
[null,null,null,null,17,null,1,1]
[null,null,null,null,18,null,1,1]
[null,null,null,null,"Total René_Léosa",null,6,6]
[null,null,null,null,"_600_Bousquet_NSA"]
[null,null,null,null,218,null,1,1]
[null,null,null,null,276,1,null,1]
[null,null,null,null,277,null,1,1]
[null,null,null,null,279,null,1,1]
[null,null,null,null,280,null,1,1]
[null,null,null,null,281,null,1,1]
[null,null,null,null,282,null,1,1]
[null,null,null,null,370,1,null,1]
[null,null,null,null,386,1,null,1]
[null,null,null,null,387,null,1,1]
[null,null,null,null,"Total _600_Bousquet_NSA",3,7,10]
[null,null,null,null,"Total général",5,26,31]

{"sheet":"Chambres","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["No","Site","Catégorie",null,"Catégorie"]
[11,"René-Léosa","Régulier",null,"1NC"]
[13,"René-Léosa","Régulier",null,"1NP"]
[14,"René-Léosa","Régulier",null,"Prothétique"]
[15,"René-Léosa","Régulier",null,"Régulier"]
[17,"René-Léosa","Régulier"]
[18,"René-Léosa","Régulier"]
[218,"_600_Bousquet_NSA","Régulier"]
[276,"_600_Bousquet_NSA","Prothétique"]
[277,"_600_Bousquet_NSA","Prothétique"]
[279,"_600_Bousquet_NSA","Prothétique"]
[280,"_600_Bousquet_NSA","Prothétique"]
[281,"_600_Bousquet_NSA","Prothétique"]
[282,"_600_Bousquet_NSA","Prothétique"]
[370,"_600_Bousquet_NSA","Prothétique"]
[386,"_600_Bousquet_NSA","Prothétique"]
[387,"_600_Bousquet_NSA","Régulier"]
[1048,"CFGH","1NC"]
[1049,"CFGH","1NC"]
[1050,"CFGH","1NC"]
[1051,"CFGH","1NC"]
[1052,"CFGH","1NC"]
[1053,"CFGH","1NC"]
[1054,"CFGH","1NC"]
[1056,"CFGH","1NC"]
[1057,"CFGH","1NC"]
[1058,"CFGH","1NC"]
[1059,"CFGH","1NC"]
[1062,"CFGH","1NC"]
[1063,"CFGH","1NC"]
[1064,"CFGH","1NC"]
["1079A","CFGH","1NP"]
["1079B","CFGH","1NP"]
[163,"CHSLD Fortierville"]
[309,"CHSLD Shooner"]
[410,"CHSLD Shooner"]

{"sheet":"Menus (données)","index":3,"n_rows":17,"n_cols":25,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Motif",null,"Provenance",null,"Orientation",null,"Iso Smaff",null,"Profil",null,"Actif_SAD",null,"Référence",null,"Statut",null,"Période",null,"Site",null,"CFGH",null,"René_Léosa",null,"_600_Bousquet_NSA"]
["Conval",null,"CH ext.",null,"CHSLD",null,0,null,110,null,"Oui",null,"Ergothérapie",null,"Annulée",null,"P01",null,"_600_Bousquet_NSA",null,1048,null,11,null,218]
["Éval-ori",null,"CHUS",null,"Décès",null,1,null,121,null,"Non",null,"Inhalothérapie",null,"Réservée",null,"P02",null,"CFGH",null,1049,null,13,null,276]
["UTRF",null,"HSC",null,"Maison S. Pall.",null,2,null,131,null,null,null,"Nutrition",null,"Transférée",null,"P03",null,"René_Léosa",null,1050,null,14,null,277]
["Urgence sociale",null,"UCDG",null,"Relocalisation RI cognitive",null,3,null,191,null,null,null,"Physiothérapie",null,null,null,"P04",null,null,null,1051,null,15,null,279]
["Autre",null,"Autre",null,"Relocalisation RI multiproblématiques",null,4,null,192,null,null,null,"Service social",null,null,null,"P05",null,null,null,1052,null,17,null,280]
[null,null,null,null,"Relocalisation RI physique",null,5,null,210,null,null,null,"Soins infirmiers",null,null,null,"P06",null,null,null,1053,null,18,null,281]
[null,null,null,null,"Relocalisation RPA",null,6,null,311,null,null,null,null,null,null,null,"P07",null,null,null,1054,null,null,null,282]
[null,null,null,null,"Relocalisation RTF",null,7,null,312,null,null,null,null,null,null,null,"P08",null,null,null,1056,null,null,null,370]
[null,null,null,null,"Retour à domicile",null,8,null,410,null,null,null,null,null,null,null,"P09",null,null,null,1057,null,null,null,386]
[null,null,null,null,"Retour au CH",null,9,null,420,null,null,null,null,null,null,null,"P10",null,null,null,1058,null,null,null,387]
[null,null,null,null,"TR LPH Ext. À Int.",null,10,null,710,null,null,null,null,null,null,null,"P11",null,null,null,1059]
[null,null,null,null,"TR LPH Int. À Ext.",null,11,null,null,null,null,null,null,null,null,null,"P12",null,null,null,1062]
[null,null,null,null,"TR NSA",null,12,null,null,null,null,null,null,null,null,null,"P13",null,null,null,1063]
[null,null,null,null,"TR NSA vers LPH interne",null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,1064]
[null,null,null,null,"Unité soins pall. CH",null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,"1079A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1079B"]