{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Vide","Menu"],"not_rendered":{"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Vide","index":0,"n_rows":141,"n_cols":4,"rows_kept":141,"merged":[[0,0,0,3],[5,0,6,0],[5,1,6,1],[5,2,6,2],[5,3,6,3],[7,0,9,0],[7,1,9,3],[10,2,10,3],[127,2,127,3],[129,0,129,3],[140,0,140,3]]}
["Annexe 3 -  Fonctions transversales"]
[null,"Annexe Directive dotation"]
[null,"Questionnaire d'évaluation des activités transversales"]
[]
[null,"Nom de l'EMS:"]
[null,"Années : "]
[]
[null,"Personne de référence et téléphone :"]
[]
[]
[null,"1. Gestion du personnel","Existence de fonctions transversales ?"]
[null,"Engagement","OUI","NON"]
[1,"Besoins"," "]
[2,"Sélection des dossiers/RDV"," "]
[3,"Entretien"," "]
[4,"Suivi des candidatures"," "]
[5,"Journée test"," "]
[6,"Fixation du salaire"," "]
[7,"Fiche de mutation"," "]
[8,"Engagement et formalités administratives"," "]
[9,"Organisation signature du contrat"," "]
[10,"Signature du contrat"," "]
[11,"Contrôle des documents et suivis"," "]
[12,"Introduction PEP"," "]
[null,"Accueil/intégration"]
[13,"Suivi accueil/intégration/statistiques",null," "]
[14,"Organisation fin temps essai",null," "]
[15,"Entretien fin temps essai",null," "]
[null,"Management des collaborateurs"]
[16,"Gestion des plannings"," "]
[17,"Gestions des absences"," "]
[18,"Rencontre du personnel absent à problème"," "]
[19,"Courrier des rencontres collaborateurs"," "]
[20,"Organisation du travail"," "]
[21,"Gestion des crises"," "]
[22,"Description de fonction"," "]
[23,"Evaluation et motivation"," "]
[24,"Suivi et synthèse des évaluations"," "]
[null,"Développement des compétences, formation"]
[25,"Analyse des besoins et compétences",null," "]
[26,"Contrat de formation",null," "]
[27,"Organisation des cours",null," "]
[28,"Suivi de la formation",null," "]
[29,"Efficacité de la formation",null," "]
[30,"Récapitulatif et suivi des diplômes",null," "]
[31,"Intégration des formations dans la planification",null," "]
[null,"Evolution professionnelle","OUI","NON"]
[32,"Recueil des demandes"," "]
[33,"Conseils, appui développement carrière"," "]
[null,"Communication interne"]
[34,"Suivi des colloques",null," "]
[35,"Suivi et évaluation du climat social",null," "]
[36,"Relation avec les partenaires sociaux- sanitaire direct (hôpital, BRIO, réseau)",null," "]
[37,"Gestion des dossiers administratifs",null," "]
[null,"Statut et réglementation (suivi et application)"]
[38,"lois et règlements en vigueur"," "]
[39,"CCT"," "]
[null,"Départ/Licenciement"]
[40,"Suivi des maladies lors d'un licenciement",null," "]
[41,"Rencontre de fin rapport de travail",null," "]
[null,"Gestion des stagiaires/apprentis"]
[42,"Relation avec les organismes externes"," "]
[43,"Contrôle des conditions légales"," "]
[44,"Suivi des stagiaires/apprentis"," "]
[45,"Objectifs et évaluations"," "]
[null,"Gestion des intérimaires"]
[46,"Demandes",null," "]
[47,"Confirmation de mandat",null," "]
[48,"Evaluation de l'intérim/ Liste récapiulative",null," "]
[49,"Contrôle factures",null," "]
[null,"2. Gestion de la clientèle"]
[null,"Recherche client"]
[50,"Contacts réguliers avec les Brios",null," "]
[51,"Transmission dossiers personnes concernées pour analyse",null," "]
[52,"Rencontre famille",null," "]
[53,"Visite de l'institution",null," "]
[54,"Travaux administratifs",null," "]
[null,"Processus d'accueil et d'intégration"]
[55,"Préparation de l'entrée"," "]
[56,"Accueil du résident"," "]
[57,"Recueil des données"," "]
[58,"Elaboration d'un projet"," "]
[null,"Vie du résident dans l'institution"]
[59,"Gestion des situations de crises",null," "]
[60,"Gestion des plaies",null," "]
[61,"Gestion de l'alimentation",null," "]
[62,"Gestion de la douleur",null," "]
[63,"Gestion des soins palliatifs",null," "]
[64,"Gestion de la mobilisation",null," "]
[65,"Gestion des activités",null," "]
[66,"Gestion de la contention",null," "]
[67,"Gestion de soins complexes",null," "]
[68,"Organisation de la vaccination des résidents",null," "]
[null,"Dossiers résidents","OUI","NON"]
[69,"Gestion du dossier informatisé"," "]
[70,"Tenue à jour des dossiers"," "]
[71,"Construction projet de vie"," "]
[72,"Suivi du projet de vie"," "]
[null,"Relation avec les proches"]
[73,"Rencontre avec familles/résidents conflictuels",null," "]
[74,"Rencontre avec familles/résidents habituel",null," "]
[null,"Organisation des manifestations festives"]
[75,"Noël; Pâques…."," "]
[null,"Relation avec les médecins"]
[76,"Coordination médicale",null," "]
[77,"Visite médicale",null," "]
[null,"Gestion des médicaments"]
[78,"Commande, contrôle, stock, distribution"," "]
[79,"Stupéfiants"," "]
[80,"Relation avec la pharmacie"," "]
[null,"Gestion du matériel"]
[81,"Contrôle des appareils (appareils de mesure,O2, frigo…)",null," "]
[82,"Gestion matériel, chaises roulantes, tintébins, barrières lits…)",null," "]
[83,"Gestion et facturation articles LIMA",null," "]
[null," Activités liées à la sécurité "]
[84,"MSST et ergonomie au travail"," "]
[85,"Sécurité incendie"," "]
[null," Activités liées à la qualité"]
[86,"Relevé et transmission des Indicateurs"," "]
[87,"Non-conformité"," "," "]
[88,"Enquête satisfaction"," "]
[89,"Tenue à jour documentation"," "]
[90,"Revue de direction et audits"," "]
[null," Activités liées aux finances"]
[91,"Evaluation Plaisir et suivi",null," "]
[92,"Evaluation des allocation d'impotence et suivi"," "," "]
[null,"Total : 92",{"$f":"COUNTIF(C13:C126,\"x\")","v":0},{"$f":"COUNTIF(D13:D126,\"x\")","v":0}]
[null,"Pourcentage",{"$f":"IF(+C127+D127>0,IF(+C127+D127=A126,+C127/A126,\"Réponses NOK\"),0)","v":{"v":0,"d":"0.00%"}}]
[]
["Si le pourcentage est égal ou supérieur à 20% :"]
[]
[null,"Nom :"]
[]
[null,"Prénom :"]
[]
[null,"Fonction :"]
[]
[null,"Taux d’occup. des personnes concernées :"]
[]
[]
["Document protégé pour votre confort, mot de passe en cas de nécessité : Annexe 3"]

{"sheet":"Menu","index":1,"n_rows":2,"n_cols":1,"rows_kept":2}
["X"]
[" "]