{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Protocole","Mode emploi ","Logigramme","Audit Processus","Résultats processus","Audit Résultat","Résultats Audit résultat "],"not_rendered":{"charts":2,"images":8,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Protocole","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[38,0,38,4],[37,0,37,4],[7,0,7,8],[8,6,8,7],[9,6,9,7],[8,2,10,2],[8,1,10,1],[8,3,10,3],[8,4,10,4],[2,4,2,6],[4,4,4,6],[8,0,10,0],[1,6,1,8],[6,0,6,8]]}

{"sheet":"Mode emploi ","index":1,"n_rows":54,"n_cols":1,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Personnaliser les menus déroulant du fichier Excel"]
["Type d'intervention et type d'intervenant de l'audit de processus"]
[]
["Si désiré, vous pouvez personnaliser les menus déroulants du fichier. "]
["Même si des listes déroulantes sont présentes, vous avez la possibilité d'entrer des informations en tapant votre réponse. "]
[]
[]
["1- Inscrire, supprimer, ajouter ou modifier les choix de réponse à afficher dans le menu déroulant "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2- Sélectionner une des cellules où les menus doivent apparaître."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3-"]
[]
[]
[]
[]
[]
["4-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5- "]

{"sheet":"Logigramme","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Audit Processus","index":3,"n_rows":63,"n_cols":16,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,1,1,9],[51,1,51,6],[50,1,50,5],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[2,1,2,3],[8,6,9,6],[8,8,9,8],[50,6,50,9],[6,7,6,8],[5,7,5,8],[2,4,2,6],[2,8,2,9],[3,1,3,3],[3,4,3,6],[3,8,3,9],[4,1,4,9],[5,1,9,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[8,7,9,7],[8,9,9,9]]}
[null,"Évaluation de la qualité et de la sécurité des services et des interventions \nIdentification de l'usager "]
[]
[null,"Unité / Service  ",null,null,null,null,null,"Auditeur"]
[null,"Installation ",null,null,null,null,null,"Notes "]
[null," GRILLE D’AUDIT\nIdentification de l’usager – Audit du processus"]
[null,"Observation","A","B","C","D","E","F",null,"G"]
[null,null,null,null,null,null,"Identification active","Identification passive",null,"Validation"]
[null,null,null,null,null,null,1,2,3,4]
[null,null,"Date","Quart de travail (J-S-N)","Types d'intervenant","Types d'intervention","L'intervenant demande à l'usager ou à une tierce personne les nom ET prénom et la date de naissance de l'usager?","L'intervenant identifie 2 des 4  informations suivantes (nom et prénom, date de naissance, # de RAMQ , # de dossier)","L'intervenant vérifie l'information inscrite sur : (carte d'identité, le bracelet, fiche signalétique, piéce d'identité avec photo)?","L'intervenant valide la concordance entre l'identité de l'usager(deux identificateurs uniques à la personne) ET l'information inscrite sur le document relié au service ou à l'intervention?"]
[]
[null,1,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(G11=\"SO\",J11=\"SO\"),0,IF(G11+J11=2,1,0))","v":0},{"$f":"IF(OR(H11=\"SO\",J11=\"SO\",I11=\"SO\"),0,IF(H11+I11+J11=3,1,0))","v":0},{"$f":"MAX(L11:M11)","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,0,0,{"$f":"MAX(L12:M12)","v":0}]
[null,3,null,null,null,null,null,null,null,null,null,0,0,0]
[null,4,null,null,null,null,null,null,null,null,null,0,0,0]
[null,5,null,null,null,null,null,null,null,null,null,0,0,0]
[null,6,null,null,null,null,null,null,null,null,null,0,0,0]
[null,7,null,null,null,null,null,null,null,null,null,0,0,0]
[null,8,null,null,null,null,null,null,null,null,null,0,0,0]
[null,9,null,null,null,null,null,null,null,null,null,0,0,0]
[null,10,null,null,null,null,null,null,null,null,null,0,0,0]
[null,11,null,null,null,null,null,null,null,null,null,0,0,0]
[null,12,null,null,null,null,null,null,null,null,null,0,0,0]
[null,13,null,null,null,null,null,null,null,null,null,0,0,0]
[null,14,null,null,null,null,null,null,null,null,null,0,0,0]
[null,15,null,null,null,null,null,null,null,null,null,0,0,0]
[null,16,null,null,null,null,null,null,null,null,null,0,0,0]
[null,17,null,null,null,null,null,null,null,null,null,0,0,0]
[null,18,null,null,null,null,null,null,null,null,null,0,0,0]
[null,19,null,null,null,null,null,null,null,null,null,0,0,0]
[null,20,null,null,null,null,null,null,null,null,null,0,0,0]
[null,21,null,null,null,null,null,null,null,null,null,0,0,0]
[null,22,null,null,null,null,null,null,null,null,null,0,0,0]
[null,23,null,null,null,null,null,null,null,null,null,0,0,0]
[null,24,null,null,null,null,null,null,null,null,null,0,0,0]
[null,25,null,null,null,null,null,null,null,null,null,0,0,0]
[null,26,null,null,null,null,null,null,null,null,null,0,0,0]
[null,27,null,null,null,null,null,null,null,null,null,0,0,0]
[null,28,null,null,null,null,null,null,null,null,null,0,0,0]
[null,29,null,null,null,null,null,null,null,null,null,0,0,0]
[null,30,null,null,null,null,null,null,null,null,null,0,0,0]
[null,31,null,null,null,null,null,null,null,null,null,0,0,0]
[null,32,null,null,null,null,null,null,null,null,null,0,0,0]
[null,33,null,null,null,null,null,null,null,null,null,0,0,0]
[null,34,null,null,null,null,null,null,null,null,null,0,0,0]
[null,35,null,null,null,null,null,null,null,null,null,0,0,0]
[null,36,null,null,null,null,null,null,null,null,null,0,0,0]
[null,37,null,null,null,null,null,null,null,null,null,0,0,0]
[null,38,null,null,null,null,null,null,null,null,null,0,0,0]
[null,39,null,null,null,null,null,null,null,null,null,0,0,0,null,{"$f":"COUNTA(G11:G50)","v":0}]
[null,40,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Taux conformité global",null,null,null,null,{"$f":"IF(P49=0,0,N51/P49)","v":0},null,null,null,null,null,null,{"$f":"SUM(N11:N50)","v":0}]
[null,"OUI = 1;  NON = 0 ; SANS OBJET = « SO »"]
[null,"Type d'intervenant ",null,null,null,"Type d'intervention "]
[null,1,"Infirmière ",null,1,"Acceuil"]
[null,2,"Médecin",null,2,"Examen "]
[null,3,"PAB",null,3,"Transport "]
[null,4,"Agent administratif",null,4,"Traitement"]
[null,5,"Infirmière auxiliaire ",null,5,"Rendez-vous"]
[null,6,"Brancardier ",null,6]
[null,7,null,null,7]
[null,8,null,null,8]
[null,9,null,null,9]
[null,10,null,null,10]

{"sheet":"Résultats processus","index":4,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Fréquence"]
[null,null,"Conforme",{"$f":"'Audit Processus'!G51","v":0}]
[null,null,"Non conforme",{"$f":"1-D28","v":1}]

{"sheet":"Audit Résultat","index":5,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":false,"merged":[[0,1,1,9],[2,1,2,3],[2,4,2,6],[2,8,2,9],[3,1,3,3],[3,4,3,6],[3,8,3,9],[4,1,4,5],[5,1,9,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[8,2,9,2],[8,3,9,3],[52,1,52,3],[52,4,52,5],[53,1,53,6],[50,1,51,3],[50,4,51,5]]}
[null,"Évaluation de la qualité et de la sécurité des services et des interventions \nIdentification de l'usager "]
[]
[null,"Unité / Service  ",null,null,null,null,null,"Auditeur"]
[null,"Installation ",null,null,null,null,null,"Notes "]
[null," GRILLE D’AUDIT\nIdentification de l’usager – Audit du résultat"]
[null,"Observation","A","B","Étape 1","Étape 2"]
[]
[]
[null,null,"Date","Quart de travail (J-S-N)"," Étape 1"," Étape 2"]
[null,null,null,null,"L’information concernant l’identification de l’usager est inscrite dans le dossier de l’usager","L'usager témoigne si l’intervenant a procédé à son identification en répondant à la question posée par l’auditeur*\n"]
[null,1,null,null,null,null,null,{"$f":"SUM(E11:G11)","v":0}]
[null,2,null,null,null,null,null,{"$f":"SUM(E12:G12)","v":0}]
[null,3,null,null,null,null,null,0]
[null,4,null,null,null,null,null,0]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,null,null,null,null,null,0]
[null,17,null,null,null,null,null,0]
[null,18,null,null,null,null,null,0]
[null,19,null,null,null,null,null,0]
[null,20,null,null,null,null,null,0]
[null,21,null,null,null,null,null,0]
[null,22,null,null,null,null,null,0]
[null,23,null,null,null,null,null,0]
[null,24,null,null,null,null,null,0]
[null,25,null,null,null,null,null,0]
[null,26,null,null,null,null,null,0]
[null,27,null,null,null,null,null,0]
[null,28,null,null,null,null,null,0]
[null,29,null,null,null,null,null,0]
[null,30,null,null,null,null,null,0]
[null,31,null,null,null,null,null,0]
[null,32,null,null,null,null,null,0]
[null,33,null,null,null,null,null,0]
[null,34,null,null,null,null,null,0]
[null,35,null,null,null,null,null,0]
[null,36,null,null,null,null,null,0]
[null,37,null,null,null,null,null,0]
[null,38,null,null,null,null,null,0]
[null,39,null,null,null,null,null,0,null,null,null,{"$f":"COUNTA(#REF!)","v":1}]
[null,40,null,null,null,null,null,0]
[null,"Total conformes ",null,null,{"$f":"COUNTIF(H11:H50,2)","v":0}]
[null,null,null,null,null,null,null,{"$f":"COUNTA(E11:E50)","v":0}]
[null,"Taux conformité global",null,null,{"$f":"E51/H52","v":{"$error":"#DIV/0!"}}]
[null,"OUI = 1;  NON = 0 ; SANS OBJET = « SO »"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Oui"]
[null,null,"Non"]
[null,null,"SO"]

{"sheet":"Résultats Audit résultat ","index":6,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Fréquence"]
[null,null,"Conforme",{"$f":"'Audit Résultat'!E53","v":{"$error":"#DIV/0!"}}]
[null,null,"Non conforme",{"$f":"1-D28","v":{"$error":"#DIV/0!"}}]