{"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":12,"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":84,"n_cols":37,"rows_kept":84,"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",11,{"$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,"P081174","1961-12-12",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":59},{"$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":"60 et -"},"2021-01-05","Éval-ori","HSC","2021-01-11",{"$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-02-25"},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-01-21"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-01-21","Retour à domicile",710,null,"Soins infirmiers",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":6},{"$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":10},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",11,{"$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",13,{"$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":"Congé"},null,null,"P092211","1948-05-14",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":73},{"$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":"71-75"},"2021-03-15","Éval-ori","HSC","2021-03-16",{"$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-30"},null,710,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-04-01"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-04-01","Retour à domicile",710,null,"Soins infirmiers",{"$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":16},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",13,{"$f":"VLOOKUP(B6,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,"P065245","1952-02-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":69},{"$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":"66-70"},"2021-04-21","Éval-ori","HSC","2021-04-23",{"$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-06-07"},null,710,null,"Oui",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,"Relocalisation RI physique",null,4,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":""},"2021-05-03","2021-05-03",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",14,{"$f":"VLOOKUP(B7,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,"P082785","1941-11-07",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":79},{"$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"},"2020-09-02","Éval-ori","HSC","2020-09-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":"2020-10-23"},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-10-02"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-10-02","Retour à domicile",710,null,"Ergothérapie",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":6},{"$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":24},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",14,{"$f":"VLOOKUP(B8,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,"P009088","1949-07-07",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":71},{"$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":"71-75"},"2021-04-02","Autre","HSC","2021-04-06",{"$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-21"},null,191,null,"Oui",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":4},{"$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",15,{"$f":"VLOOKUP(B9,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,"P051448",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":""},"2021-02-12","UTRF","HSC","2021-02-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-01"},null,191,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-03-19"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-03-19","Retour à domicile",null,null,"Physiothérapie",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":3},{"$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":32},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",15,{"$f":"VLOOKUP(B10,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",17,{"$f":"VLOOKUP(B11,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,"P064433","1927-06-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":93},{"$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":"86 et +"},"2020-08-04","UTRF","HSC","2020-08-07",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":"2020-09-21"},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-09-30"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-09-30",null,710,null,"Service social",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":3},{"$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":54},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["René_Léosa",17,{"$f":"VLOOKUP(B12,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,"P127231","1931-05-29",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2021-01-13","Éval-ori","CH ext.","2021-01-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-03-01"},null,710,null,"Oui",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,"CHSLD",710,9,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":""},"2021-03-19","2021-03-24",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":5}]
["René_Léosa",18,{"$f":"VLOOKUP(B13,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-03-30"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-03-30",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":15},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(B14,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}]
["René_Léosa",28,"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,"P164919","1958-08-24",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":62},{"$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"},"2020-04-30","UTRF","HSC","2020-05-01",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":"2020-06-15"},null,191,null,"Non","r-oh, consomm. Avec site IV",{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-05-26"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-05-26","Retour à domicile",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":25},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["_600_Bousquet_NSA",218,{"$f":"VLOOKUP(B16,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,"P134934","1949-12-14",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":71},{"$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":"71-75"},"2021-04-26","Conval","HSC","2021-04-28",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-05-11"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-05-11","Retour à domicile",110,2,"Physiothérapie",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":13},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",218,{"$f":"VLOOKUP(B17,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,"P015901","1932-06-26",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":88},{"$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":"86 et +"},"2021-04-28","Éval-ori","HSC","2021-05-12",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":14},{"$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}]
["_600_Bousquet_HT",276,{"$f":"VLOOKUP(B18,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},"Annulée",null,null,"P156433","1929-05-19",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":92},{"$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":"86 et +"},"2020-07-27","Autre","Autre","2020-07-30",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":3},{"$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}]
["_600_Bousquet_NSA",276,{"$f":"VLOOKUP(B19,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P007073","1942-02-16",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":79},{"$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"},"2020-05-25","UTRF","Autre","2020-05-27",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-06"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-06","CHSLD",710,10,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":40},"2020-07-01","2020-07-02",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":1},null,null,"2020-2021"]
["_600_Bousquet_NSA",276,{"$f":"VLOOKUP(B20,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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}]
["_600_Bousquet_NSA",276,{"$f":"VLOOKUP(B21,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P117820","1929-10-04",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":91},{"$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":"86 et +"},"2021-05-18","UTRF","HSC","2021-05-19",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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}]
["_600_Bousquet_NSA",277,{"$f":"VLOOKUP(B22,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P053174","1951-08-16",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":69},{"$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":"66-70"},"2020-07-20","UTRF","Autre","2020-07-21",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-31"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-31","Retour à domicile",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":10},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",277,{"$f":"VLOOKUP(B23,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P064213","1935-11-30",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":85},{"$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":"81-85"},"2021-04-30","Éval-ori","HSC","2021-05-03",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":3},{"$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}]
["_600_Bousquet_NSA",279,{"$f":"VLOOKUP(B24,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P087278","1927-03-20",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":94},{"$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":"86 et +"},"2021-01-01","Conval","HSC","2021-02-04",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-03-10"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-03-10","Relocalisation RPA",191,8,"Service social",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":34},{"$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":34},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",279,{"$f":"VLOOKUP(B25,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P081888","1934-02-25",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":87},{"$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":"86 et +"},"2021-01-08","Éval-ori","Autre","2021-01-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":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-02-02"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-02-02","Relocalisation RPA",710,null,"Soins infirmiers",{"$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":25},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",279,{"$f":"VLOOKUP(B26,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P001671","1969-03-20",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":52},{"$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":"60 et -"},"2021-01-14","Conval","HSC","2021-01-22",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,191,null,"Oui",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":8},{"$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},null,null,"2020-2021"]
["_600_Bousquet_NSA",280,{"$f":"VLOOKUP(B27,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P083142","1941-01-05",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":80},{"$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"},"2020-09-16","Conval","Autre","2020-09-17",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-10-28"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-10-28","Retour à domicile",710,null,"Ergothérapie",{"$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":41},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",280,{"$f":"VLOOKUP(B28,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P110010","1930-02-27",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":91},{"$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":"86 et +"},"2021-04-16","Éval-ori","HSC","2021-04-30",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":14},{"$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}]
["_600_Bousquet_NSA",281,{"$f":"VLOOKUP(B29,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P134734","1936-10-05",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":84},{"$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":"81-85"},"2020-10-15","Urgence sociale","Autre","2020-10-17",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-01-22"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-01-22","Relocalisation RPA",710,null,"Soins infirmiers",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":97},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",281,{"$f":"VLOOKUP(B30,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P102731","1931-04-18",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2021-04-28","Éval-ori","HSC","2021-04-29",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},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":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}]
["_600_Bousquet_NSA",282,{"$f":"VLOOKUP(B31,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},"Annulée",null,null,"P168013","1927-04-29",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":94},{"$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":"86 et +"},"2020-09-18","Conval","CH ext.","2020-09-21",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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":3},{"$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}]
["_600_Bousquet_NSA",282,{"$f":"VLOOKUP(B32,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P121758","1935-01-31",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2020-06-19","Conval","HSC","2020-06-19",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,110,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-08-25"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-08-25","Retour à domicile",null,null,"Service social",{"$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":67},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA",282,{"$f":"VLOOKUP(B33,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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}]
["_600_Bousquet_NSA",370,{"$f":"VLOOKUP(B34,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P009112","1937-01-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":84},{"$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":"81-85"},"2020-12-23","Urgence sociale","Autre","2020-12-25",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,7,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-02-18"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-02-18","CHSLD",710,10,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":55},"2020-12-28","2021-01-12",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":15}]
["_600_Bousquet_NSA",370,{"$f":"VLOOKUP(B35,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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},null,null,"2020-2021"]
["_600_Bousquet_NSA",370,{"$f":"VLOOKUP(B36,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P081699","1942-03-04",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":79},{"$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-05-12","Éval-ori","HSC","2021-05-18",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,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":6},{"$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}]
["_600_Bousquet_NSA",386,{"$f":"VLOOKUP(B37,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P141615","1938-07-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":82},{"$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":"81-85"},"2020-06-16","Éval-ori","HSC","2020-06-17",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-09"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},"2020-07-09","2020-07-09","Retour à domicile",710,null,"Service social",{"$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":22},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["_600_Bousquet_NSA",386,{"$f":"VLOOKUP(B38,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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,"P161182","1933-01-02",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":88},{"$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":"86 et +"},"2020-05-20","Conval","HSC","2020-05-20",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,7,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-06-05"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-06-05","Relocalisation RPA",710,null,"TS\nNutri",{"$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":16},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["_600_Bousquet_NSA",386,{"$f":"VLOOKUP(B39,Chambres!$A$2:$C$33,3,FALSE)","v":"Prothétique"},{"$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}]
["_600_Bousquet_NSA",387,{"$f":"VLOOKUP(B40,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,"P077232","1934-12-30",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2020-04-15","Éval-ori","HSC","2020-04-30",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-01"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-01","Relocalisation RPA",710,12,"Soins infirmiers",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":15},{"$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":62},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["_600_Bousquet_NSA",387,{"$f":"VLOOKUP(B41,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,"P078928","1951-10-25",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":69},{"$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":"66-70"},"2020-07-28","Éval-ori","HSC","2020-07-30",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-09-09"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},"2020-09-08","2020-09-09","Relocalisation RI cognitive",710,7,"Service social",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":41},"2020-08-17","2020-08-20",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":3}]
["_600_Bousquet_NSA",387,{"$f":"VLOOKUP(B42,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,"P101686","1939-09-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":81},{"$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":"81-85"},"2021-04-28","Éval-ori","HSC","2021-05-03",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},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":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":""},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1048,{"$f":"VLOOKUP(B43,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},"Annulée",null,null,"P068046","1930-08-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2020-05-26","Éval-ori","Autre","2020-05-28",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,121,null,"Oui","Mme n'a pas entrée. Chang. Dans son état",{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-05-28"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-05-28",null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":0},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["CFGH",1048,{"$f":"VLOOKUP(B44,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P170197","1945-10-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":75},{"$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":"71-75"},"2021-05-06","Éval-ori","HSC","2021-05-07",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-05-21"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-05-21","Retour à domicile",710,null,"Ergothérapie",{"$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":14},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1048,{"$f":"VLOOKUP(B45,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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}]
["CFGH",1048,{"$f":"VLOOKUP(B46,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P055667","1954-04-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":67},{"$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":"66-70"},"2021-05-10","Autre","HSC","2021-05-21",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,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":11},{"$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}]
["CFGH",1049,{"$f":"VLOOKUP(B47,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},"Annulée",null,null,"P144748","1931-08-26",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":89},{"$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":"86 et +"},"2020-06-12","Éval-ori","HSC","2020-06-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":""},null,710,null,null,"Pas admise - reloc chsld du ch",{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-06-15"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-06-15",null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":3},{"$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":0},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["CFGH",1049,{"$f":"VLOOKUP(B48,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P127795","1941-03-29",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":80},{"$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"},"2020-09-23","Éval-ori","HSC","2020-09-25",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-11-23"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-11-23","CHSLD",710,10,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":59},"2020-10-15","2020-10-20",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":5}]
["CFGH",1049,{"$f":"VLOOKUP(B49,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P039444","1944-10-14",{"$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-15","Éval-ori","HSC","2021-03-16",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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}]
["CFGH",1050,{"$f":"VLOOKUP(B50,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P077029","1939-01-15",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":82},{"$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":"81-85"},"2020-07-01","Éval-ori","HSC","2020-07-09",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-09-30"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-09-30","Retour au CH",710,12,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":8},{"$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":83},"2020-09-22","2020-09-24",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":2}]
["CFGH",1050,{"$f":"VLOOKUP(B51,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P159158","1950-09-27",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":70},{"$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":"66-70"},"2021-04-16","Éval-ori","HSC","2021-04-20",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,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":4},{"$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}]
["CFGH",1051,{"$f":"VLOOKUP(B52,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P066377","1939-10-08",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":81},{"$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":"81-85"},"2020-07-12",null,null,"2020-07-13",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-30"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-30","Retour à domicile",710,8,"Ergothérapie",{"$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":17},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1051,{"$f":"VLOOKUP(B53,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P090324","1930-12-09",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2021-04-16","Éval-ori","HSC","2021-04-28",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":12},{"$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}]
["CFGH",1052,{"$f":"VLOOKUP(B54,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P034081","1929-11-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":91},{"$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":"86 et +"},"2020-08-14","Éval-ori","HSC","2020-08-27",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,9,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-03"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-03","CHSLD",710,11,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":13},{"$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":98},"2020-10-09","2020-10-14",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":5}]
["CFGH",1052,{"$f":"VLOOKUP(B55,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P013091","1940-11-22",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":80},{"$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-05-14","Éval-ori","HSC","2021-05-14",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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}]
["CFGH",1053,{"$f":"VLOOKUP(B56,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P150190","1933-03-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":88},{"$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":"86 et +"},"2020-06-11","Éval-ori","HSC","2020-06-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":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-02"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-02","Retour au CH",null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":4},{"$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":17},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["CFGH",1053,{"$f":"VLOOKUP(B57,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P139437","1945-02-12",{"$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-04-23","Éval-ori","HSC","2021-05-10",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":17},{"$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}]
["CFGH",1054,{"$f":"VLOOKUP(B58,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P109296","1926-07-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":94},{"$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":"86 et +"},"2020-08-31","Éval-ori","HSC","2020-09-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":""},null,710,11,"oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-16"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-16","CHSLD",710,11,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":8},{"$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":99},"2020-11-27","2020-12-02",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":5}]
["CFGH",1054,{"$f":"VLOOKUP(B59,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P027161","1943-10-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":77},{"$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-04-14","Autre","HSC","2021-04-22",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":8},{"$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}]
["CFGH",1056,{"$f":"VLOOKUP(B60,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P037213","1951-02-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":70},{"$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":"66-70"},"2020-12-18","Éval-ori","HSC","2020-12-23",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,110,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2021-02-26"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2021-02-26","Retour à domicile",710,null,"Service social",{"$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":65},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1056,{"$f":"VLOOKUP(B61,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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}]
["CFGH",1056,{"$f":"VLOOKUP(B62,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P000286","1961-11-04",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":59},{"$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":"60 et -"},"2021-04-30","Autre","HSC","2021-05-19",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,191,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":19},{"$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}]
["CFGH",1057,{"$f":"VLOOKUP(B63,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P074162","1932-03-09",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":89},{"$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":"86 et +"},"2020-06-22","Conval","HSC","2020-06-23",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-09-21"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-09-21","Retour à domicile",710,8,"Service social",{"$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":90},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1058,{"$f":"VLOOKUP(B64,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P162529","1936-07-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":84},{"$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":"81-85"},"2020-07-17","Éval-ori","HSC","2020-07-23",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-10-05"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-10-05","CHSLD",710,4,"Service social",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":6},{"$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":74},"2020-09-08","2020-09-28",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":20}]
["CFGH",1058,{"$f":"VLOOKUP(B65,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P051313","1939-01-05",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":82},{"$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":"81-85"},"2021-04-23","Éval-ori","HSC","2021-04-29",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":6},{"$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}]
["CFGH",1059,{"$f":"VLOOKUP(B66,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},"Annulée",null,null,"P115408","1951-08-02",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":69},{"$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":"66-70"},"2020-09-28","Éval-ori","HSC","2020-09-30",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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":2},{"$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}]
["CFGH",1059,{"$f":"VLOOKUP(B67,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},"Annulée",null,null,"P051598","1934-05-13",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":87},{"$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":"86 et +"},"2020-09-23","Éval-ori","HSC","2020-09-28",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,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":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":""},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1059,{"$f":"VLOOKUP(B68,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P072188","1935-03-25",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2020-11-16","Éval-ori","HSC","2020-11-25",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-22"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-22","Retour à domicile",710,4,"Soins infirmiers",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":9},{"$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":27},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1059,{"$f":"VLOOKUP(B69,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P096192","1959-02-20",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":62},{"$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-28","UTRF","HSC","2021-04-29",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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}]
["CFGH",1062,{"$f":"VLOOKUP(B70,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P090671","1939-03-27",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":82},{"$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":"81-85"},"2020-07-17","UTRF","HSC","2020-07-19",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-09-07"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},"2020-09-07","2020-09-07","Relocalisation RPA",710,6,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":50},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1062,{"$f":"VLOOKUP(B71,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P038276","1940-09-16",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":80},{"$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-04-23","Éval-ori","HSC","2021-05-11",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Oui",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":18},{"$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}]
["CFGH",1063,{"$f":"VLOOKUP(B72,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P118942","1947-01-04",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":74},{"$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":"71-75"},"2020-03-04","Éval-ori","HSC","2020-03-05",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,null,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-07-08"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-07-08","Relocalisation RPA",710,8,"Service social",{"$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":125},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2019-2020"]
["CFGH",1063,{"$f":"VLOOKUP(B73,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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}]
["CFGH",1064,{"$f":"VLOOKUP(B74,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},"Annulée",null,null,"P068046","1930-08-11",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2020-05-26","Éval-ori","Autre","2020-06-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":""},null,121,null,"Oui","Jamais admise - DCD",{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-06-08"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-06-08","Décès",null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":13},{"$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":0},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["CFGH",1064,{"$f":"VLOOKUP(B75,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P073939","1935-07-17",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":85},{"$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":"81-85"},"2020-07-07","Éval-ori","HSC","2020-07-21",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Non",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-08-14"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-08-14","Retour à domicile",710,11,"Service social",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":14},{"$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":24},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH",1064,{"$f":"VLOOKUP(B76,Chambres!$A$2:$C$33,3,FALSE)","v":"1NC"},{"$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,"P034513","1939-09-23",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":81},{"$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":"81-85"},"2021-04-02","Éval-ori","HSC","2021-04-06",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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":4},{"$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}]
["CFGH","1079A",{"$f":"VLOOKUP(B77,Chambres!$A$2:$C$33,3,FALSE)","v":"1NP"},"Annulée",null,null,"P131747","1935-10-30",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":85},{"$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":"81-85"},"2021-02-19","Éval-ori","HSC","2021-03-01",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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":10},{"$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}]
["CFGH","1079A",{"$f":"VLOOKUP(B78,Chambres!$A$2:$C$33,3,FALSE)","v":"1NP"},{"$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,"P075315","1935-07-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":85},{"$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":"81-85"},"2020-08-07","Éval-ori","HSC","2020-08-12",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-03"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-03","Relocalisation RPA",710,11,"Soins infirmiers",{"$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":113},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH","1079A",{"$f":"VLOOKUP(B79,Chambres!$A$2:$C$33,3,FALSE)","v":"1NP"},{"$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,"P136412","1930-07-27",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":90},{"$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":"86 et +"},"2021-03-23","Éval-ori","HSC","2021-03-25",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",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":2},{"$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}]
["CFGH","1079B",{"$f":"VLOOKUP(B80,Chambres!$A$2:$C$33,3,FALSE)","v":"1NP"},{"$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,"P104724","1935-03-13",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2020-08-10","Éval-ori","HSC","2020-08-12",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-03"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-03","Relocalisation RPA",710,7,"Soins infirmiers",{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":113},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["CFGH","1079B",{"$f":"VLOOKUP(B81,Chambres!$A$2:$C$33,3,FALSE)","v":"1NP"},{"$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,"P021646","1934-10-27",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2021-03-15","Conval","HSC","2021-03-18",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,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":3},{"$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}]
["_600_Bousquet_NSA","219-220","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,"P075315","1935-07-06",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":85},{"$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":"81-85"},"2020-06-26","Éval-ori","HSC","2020-06-29",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-08-11"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-08-11",null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":3},{"$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":43},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0},null,null,"2020-2021"]
["_600_Bousquet_NSA","219-220","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,"P104724","1935-03-13",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":86},{"$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":"86 et +"},"2020-06-26","Éval-ori","HSC","2020-06-29",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-08-11"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-08-11",null,null,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":3},{"$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":43},null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt MAH]],Tableau1[[#This Row],[Date orientation]],\"D\"),\"\")","v":0}]
["_600_Bousquet_NSA","226-227","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,"P087622","1937-06-20",{"$f":"(IF(Tableau1[[#This Row],[Date de\nnaissance]]<>\"\",DATEDIF(Tableau1[[#This Row],[Date de\nnaissance]],TODAY(),\"Y\"),\"\"))","v":83},{"$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":"81-85"},"2020-11-30","Autre","HSC","2020-12-02",{"$f":"IF(Tableau1[[#This Row],[Date\nd''admission]]<>\"\",IF(Tableau1[[#This Row],[Site]]=\"René_Léosa\",Tableau1[[#This Row],[Date\nd''admission]]+45,\"\"))","v":""},null,710,null,"Oui",null,{"$f":"IF(Tableau1[[#This Row],[Date \ncongé]]<>\"\",Tableau1[[#This Row],[Date \ncongé]],\"\")","v":"2020-12-08"},{"$f":"IF(Tableau1[[#This Row],[Date de fin\nSoins actifs]]<>\"\",\"Non\",\"Oui\")","v":"Non"},null,"2020-12-08","Relocalisation RPA",710,null,null,{"$f":"IFERROR(DATEDIF(Tableau1[[#This Row],[Date dépôt demande]],Tableau1[[#This Row],[Date\nd''admission]],\"D\"),\"\")","v":2},{"$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":6},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"]