{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Présentation","EvaluationConformité","EvaluationPerformance-1","EvaluationPerformance-2","EvaluationPerformance-3","EvaluationPerformance-4","EvaluationPerformance-5","Résultats","CalculsPerformance"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Présentation","index":0,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,1,3,6],[4,1,5,6],[6,1,6,6],[7,1,9,6],[0,1,0,18],[1,1,1,18],[3,8,3,12],[3,14,3,18],[4,14,4,18],[7,14,7,18],[5,14,6,18],[11,1,31,6],[8,14,11,18],[12,14,12,18],[13,14,21,18],[15,8,15,12],[22,8,22,12],[23,8,24,12],[16,8,16,12],[10,1,10,6],[26,8,27,12],[29,8,30,12],[19,8,19,12],[20,8,21,12],[25,8,25,12],[28,8,28,12],[17,8,18,12]]}
[null,"Qualgédo"]
[null,"Évaluation du système documentaire qualité - Conformité et Performance"]
[]
[null,"Pour qui?",null,null,null,null,null,null,"Navigation - Accès rapides",null,null,null,null,null,"Quelques petites informations sur Qualgédo"]
[null,"Pour toutes les entreprises possédant un système documentaire qualité",null,null,null,null,null,null,null,null,null,null,null,null,"Son nom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qualgédo est l'abréviation de QUALité et GEstion DOcumentaire"]
[null,"Pourquoi?"]
[null,"Pour toutes les entreprises qui désirent voir facilement si leur système de gestion documentaire qualité est conforme à la norme ISO 9001:2008 et s'il est performant.",null,null,null,null,null,null,null,null,null,null,null,null,"Sa conception"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cet outil est le fruit d'un travail étudiant. Il a été conçu pendant le stage de fin d'année du master QPO (Qualité et Performance dans les Organisations)."]
[]
[null,"Comment?"]
[null,"0 - N'oubliez pas d'activer les macro pour la navigation rapide\n1- Rendez-vous sur la feuille d'évaluation qui vous intéresse (conformité ou performance)\n2- Indiquez les noms et prénoms de l'évaluateur pour plus de traçabilité\n3- Indiquez la date de l'évaluation\n4-Commencer l'évaluation\n5- Une fois l'évaluation désirée terminée, vous pouvez vous rendre sur la feuille des résultats afin d'observer le niveau de conformité et de performance de votre système.\n\nNota Bene : \n- L'évaluation de la conformité se fait par un unique évaluateur. Elle comporte seulement deux choix : conforme ou non conforme.\n- L'évaluation de la performance se fait entre 1 et 5 évaluateurs. Pour plus de reculs sur les évaluations, il est conseillé d'avoir trois évaluateurs différents. Cette évaluation est composée d'affirmations auxquelles il faut répondre par l'un des quatre choix : oui, plutôt oui, plutôt non, non. Il est possible d'ajouter des critères de notation sur les plages grisées.\n- Les éléments de calculs sont masqués dans les différentes évaluations ainsi que dans une feuille à part. Vous pouvez si vous le souhaitez les faire apparaître."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour plus d'information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pour plus d'informations sur la méthodologie de conception de ce logiciel, vous pouvez lire le mémoire en ligne en suivant la référence ci-après :\nGENOUD Florie, Université de Technologie de Compiègne, Master Qualité et Performance dans les Organisations (QPO), Mémoire d'Intelligence Méthodologique du stage professionnel de fin d'études, juin 2014, www.utc.fr/master-qualite, puis \"Travaux\" \"Qualité-Management\", réf n°287"]
[]
[null,null,null,null,null,null,null,null,"Quelques définitions"]
[null,null,null,null,null,null,null,null,"Conformité"]
[null,null,null,null,null,null,null,null,"Etat de ce qui est parfaitement similaire à un modèle donné"]
[]
[null,null,null,null,null,null,null,null,"Performance"]
[null,null,null,null,null,null,null,null,"Résultat optimal que peut obtenir un système (point de jonction entre l'efficacité, l'efficience et la qualité perçue)"]
[]
[null,null,null,null,null,null,null,null,"Efficacité"]
[null,null,null,null,null,null,null,null,"Capacité d'un système à parvenir à ses fins, à ses objectifs"]
[]
[null,null,null,null,null,null,null,null,"Efficience"]
[null,null,null,null,null,null,null,null,"Rapport entre les résultats obtenus et les ressources utilisées pour les obtenir"]
[]
[null,null,null,null,null,null,null,null,"Qualité perçue"]
[null,null,null,null,null,null,null,null,"Niveau de qualité d'un système tel qu'il est perçu par l'utilisateur"]

{"sheet":"EvaluationConformité","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,0,4,1],[0,1,0,4],[7,8,7,9],[13,8,13,9],[34,8,34,9],[25,8,25,9],[0,8,0,10],[2,0,2,2],[3,0,3,1]]}
[null,"Grille d'évaluation du système documentaire qualité - Conformité",null,null,null,null,null,null,"Zone de calculs"]
[]
["Evaluateur"]
["Nom :",null,null,null,null,null,null,null,null,"Conforme"]
["Prénom :",null,null,null,null,null,null,null,null,"Non conforme"]
[]
[null,"Ligne","Sujet","Conformité?","Remarques",null,null,null,"Valeur conforme","Valeur non Conforme","Moyenne"]
[null,1,"Manuel Qualité",null,null,null,null,null,"Manuel Qualité",null,{"$f":"AVERAGE(K9,K15,K27,K36)","v":0}]
[null,"1.1","Les domaines d'application du système de management de la qualité sont explicités (et les exclusions justifiées)",null,null,null,null,null,{"$f":"IF(D9=$J$4,100,0)","v":0},{"$f":"IF(D9=$J$5,0,\"\")","v":""},{"$f":"AVERAGE(I9:I13)","v":0}]
[null,"1.2","Les procédures documentées sont présentes dans le manuel (ou les références à ces procédures sont présentes)",null,null,null,null,null,{"$f":"IF(D10=$J$4,100,0)","v":0},{"$f":"IF(D10=$J$5,0,\"\")","v":""},"Nombre valeur"]
[null,"1.3","Les interactions entre les processus et le système de management de la qualité sont décrites",null,null,null,null,null,{"$f":"IF(D11=$J$4,100,0)","v":0},{"$f":"IF(D11=$J$5,0,\"\")","v":""},{"$f":"COUNTA(D9:D13)","v":0}]
[null,"1.4","Le manuel qualité est rédigé",null,null,null,null,null,{"$f":"IF(D12=$J$4,100,0)","v":0},{"$f":"IF(D12=$J$5,0,\"\")","v":""}]
[null,"1.5","Le manuel qualité est remis à jour régulièrement",null,null,null,null,null,{"$f":"IF(D13=$J$4,100,0)","v":0},{"$f":"IF(D13=$J$5,0,\"\")","v":""}]
[null,2,"Maîtrise des documents",null,null,null,null,null,"Maîtrise des documents"]
[null,"2.1","La procédure de maîtrise des documents est rédigée",null,null,null,null,null,{"$f":"IF(D15=$J$4,100,0)","v":0},{"$f":"IF(D15=$J$5,0,\"\")","v":""},{"$f":"AVERAGE(I15:I25)","v":0}]
[null,"2.2","Le mode d'approbation des documents est défini",null,null,null,null,null,0,""]
[null,"2.3","Le mode de révision et de mise à jour des documents est défini",null,null,null,null,null,0,""]
[null,"2.4","Le mode de modification est défini",null,null,null,null,null,0,"","Nombre valeur"]
[null,"2.5","Le mode d'identification des versions en vigueur est défini",null,null,null,null,null,0,"",{"$f":"COUNTA(D15:D25)","v":0}]
[null,"2.6","Le mode de mise à disposition des versions pertinentes des documents applicables sur les lieux d'utilisation est défini",null,null,null,null,null,0,""]
[null,"2.7","Le mode d'identification des documents est défini",null,null,null,null,null,0,""]
[null,"2.8","Le mode d'identification des documents d'origine externe est défini",null,null,null,null,null,0,""]
[null,"2.9","Le mode de diffusion maîtrisé des documents d'origine externe est défini",null,null,null,null,null,0,""]
[null,"2.10","Le mode de gestion des documents périmés est défini",null,null,null,null,null,0,""]
[null,"2.11","Le mode d'identification des documents périmés conservés est défini",null,null,null,null,null,0,""]
[null,3,"Maîtrise des enregistrements",null,null,null,null,null,"Maîtrise des enregistrements"]
[null,"3.1","La procédure de maîtrise des enregistrements est rédigée",null,null,null,null,null,{"$f":"IF(D27=$J$4,100,0)","v":0},{"$f":"IF(D27=$J$5,0,\"\")","v":""},{"$f":"AVERAGE(I27:I34)","v":0}]
[null,"3.2","Le mode d'identification des enregistrements est défini",null,null,null,null,null,0,"",{"$f":"COUNTA(D27:D34)","v":0}]
[null,"3.3","Le mode de stockage des enregistrements est défini",null,null,null,null,null,0,""]
[null,"3.4","Le mode de protection des enregistrements est défini",null,null,null,null,null,0,""]
[null,"3.5","Le mode d'accessibilité des enregistrements est défini",null,null,null,null,null,0,""]
[null,"3.6","Le mode de conservation des enregistrements est défini",null,null,null,null,null,0,""]
[null,"3.7","Le mode d'élimination des documents est défini",null,null,null,null,null,0,""]
[null,"3.8","Les enregistrements apportant la conformité aux exigences et au fonctionnement du système de management de la qualité sont maîtrisés",null,null,null,null,null,0,""]
[null,4,"Documents exigés",null,null,null,null,null,"Documents exigés"]
[null,"4.1","Les objectifs qualité sont rédigés",null,null,null,null,null,{"$f":"IF(D36=$J$4,100,0)","v":0},{"$f":"IF(D36=$J$5,0,\"\")","v":""},{"$f":"AVERAGE(I36:I43,I27,I15,I12)","v":0}]
[null,"4.2","La politique qualité est rédigée",null,null,null,null,null,0,"",{"$f":"COUNTA(D36:D43)","v":0}]
[null,"4.4","Les enregistrements nécessaires sont créés",null,null,null,null,null,0,""]
[null,"4.7","La procédure décrivant les audits internes est rédigée",null,null,null,null,null,0,""]
[null,"4.8","La procédure de maîtrise des non-conformités est rédigée",null,null,null,null,null,0,""]
[null,"4.9","La procédure de gestion des actions correctives est rédigée",null,null,null,null,null,0,""]
[null,"4.10","La procédure de gestion des actions préventives est rédigée",null,null,null,null,null,0,""]
[null,"4.11","Les documents nécessaires à la planification, au fonctionnement et à la maîtrise des processus sont créés",null,null,null,null,null,0,""]

{"sheet":"EvaluationPerformance-1","index":2,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,4],[4,0,4,1],[3,0,3,1],[2,0,2,2]]}
[null,"Grille d'évaluation du système documentaire qualité - Performance"]
[]
["Évaluateur 1",null,null,"Date :",null,null,null,null,null,"Oui"]
["Nom :",null,null,null,null,null,null,null,null,"Plutôt oui"]
["Prénom : ",null,null,null,null,null,null,null,null,"Plutôt non"]
[null,null,null,null,null,null,null,null,null,"Non"]
[null,"Ligne","Sujet","Évaluation","Remarques"]
[null,1,"Efficacité",null,null,null,null,null,null,"Oui","Plutôt oui","Plutôt non","Non","Somme"]
[null,"1.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,{"$f":"IF(D9=$J$3,100,\"\")","v":""},{"$f":"IF(D9=$J$4,75,\"\")","v":""},{"$f":"IF(D9=$J$5,25,\"\")","v":""},{"$f":"IF(D9=$J$6,0,\"\")","v":""},{"$f":"SUM(J9:M18)","v":0}]
[null,"1.2","Le temps consacré à rechercher un document est correct",null,null,null,null,null,null,{"$f":"IF(D10=$J$3,100,\"\")","v":""},{"$f":"IF(D10=$J$4,75,\"\")","v":""},{"$f":"IF(D10=$J$5,25,\"\")","v":""},{"$f":"IF(D10=$J$6,0,\"\")","v":""},"Nombre de valeurs"]
[null,"1.3","Le taux de consultation des documents est bon.",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J9:M18)","v":0}]
[null,"1.4","Le nombre de documents présents dans le système documentaire qualité est satisfaisant.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"1.5","Tous les documents du système sont utilisés",null,null,null,null,null,null,"","","","",{"$f":"N9/N11","v":{"$error":"#DIV/0!"}}]
[null,"1.6",null,null,null,null,null,null,null,"","","",""]
[null,"1.7",null,null,null,null,null,null,null,"","","",""]
[null,"1.8",null,null,null,null,null,null,null,"","","",""]
[null,"1.9",null,null,null,null,null,null,null,"","","",""]
[null,"1.10",null,null,null,null,null,null,null,"","","",""]
[null,2,"Efficience",null,null,null,null,null,null,"","","","","Somme"]
[null,"2.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,"","","","",{"$f":"SUM(J20:M29)","v":0}]
[null,"2.2","Les outils utilisés pour gérer le système documentaire sont optimisés",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"2.3","Le taux d'usage des ressources documentaires qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J20:M29)","v":0}]
[null,"2.4","Le taux de documents à jour est maximal.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"2.5","Les ressources mises à disposition sont en adéquation avec les besoins des collaborateurs",null,null,null,null,null,null,"","","","",{"$f":"N20/N22","v":{"$error":"#DIV/0!"}}]
[null,"2.6",null,null,null,null,null,null,null,"","","",""]
[null,"2.7",null,null,null,null,null,null,null,"","","",""]
[null,"2.8",null,null,null,null,null,null,null,"","","",""]
[null,"2.9",null,null,null,null,null,null,null,"","","",""]
[null,"2.10",null,null,null,null,null,null,null,"","","",""]
[null,3,"Qualité Perçue",null,null,null,null,null,null,"","","","","Somme"]
[null,"3.1","Vous pensez que le système documentaire qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"SUM(J31:M40)","v":0}]
[null,"3.2","Vous avez confiance dans le système documentaire qualité",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"3.3","Vous avez confiance dans les documents que vous trouvez dans le système documentaire qualité",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J31:M40)","v":0}]
[null,"3.4","Vous pensez que les documents présents dans le système documentaire qualité sont utilisés",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"3.5","Vous pensez que les documents présents dans le système documentaire qualité sont utilisables",null,null,null,null,null,null,"","","","",{"$f":"N31/N33","v":{"$error":"#DIV/0!"}}]
[null,"3.6",null,null,null,null,null,null,null,"","","",""]
[null,"3.7",null,null,null,null,null,null,null,"","","",""]
[null,"3.8",null,null,null,null,null,null,null,"","","",""]
[null,"3.9",null,null,null,null,null,null,null,"","","",""]
[null,"3.10",null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=$J$5,5,\"\")","v":""}]

{"sheet":"EvaluationPerformance-2","index":3,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,1,0,4],[2,0,2,2],[3,0,3,1],[4,0,4,1]]}
[null,"Grille d'évaluation du système documentaire qualité - Performance"]
[]
["Évaluateur 2",null,null,"Date :",null,null,null,null,null,"Oui"]
["Nom :",null,null,null,null,null,null,null,null,"Plutôt oui"]
["Prénom : ",null,null,null,null,null,null,null,null,"Plutôt non"]
[null,null,null,null,null,null,null,null,null,"Non"]
[null,"Ligne","Sujet","Évaluation","Remarques"]
[null,1,"Efficacité",null,null,null,null,null,null,"Oui","Plutôt oui","Plutôt non","Non","Somme"]
[null,"1.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,{"$f":"IF(D9=$J$3,100,\"\")","v":""},{"$f":"IF(D9=$J$4,75,\"\")","v":""},{"$f":"IF(D9=$J$5,25,\"\")","v":""},{"$f":"IF(D9=$J$6,0,\"\")","v":""},{"$f":"SUM(J9:M18)","v":0}]
[null,"1.2","Le temps consacré à rechercher un document est correct",null,null,null,null,null,null,{"$f":"IF(D10=$J$3,100,\"\")","v":""},{"$f":"IF(D10=$J$4,75,\"\")","v":""},{"$f":"IF(D10=$J$5,25,\"\")","v":""},{"$f":"IF(D10=$J$6,0,\"\")","v":""},"Nombre de valeurs"]
[null,"1.3","Le taux de consultation des documents est bon.",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J9:M18)","v":0}]
[null,"1.4","Le nombre de documents présents dans le système documentaire qualité est satisfaisant.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"1.5","Tous les documents du système sont utilisés",null,null,null,null,null,null,"","","","",{"$f":"N9/N11","v":{"$error":"#DIV/0!"}}]
[null,"1.6",{"$f":"IF('EvaluationPerformance-1'!C14<>0,'EvaluationPerformance-1'!C14,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.7",{"$f":"IF('EvaluationPerformance-1'!C15<>0,'EvaluationPerformance-1'!C15,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.8",{"$f":"IF('EvaluationPerformance-1'!C16<>0,'EvaluationPerformance-1'!C16,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.9",{"$f":"IF('EvaluationPerformance-1'!C17<>0,'EvaluationPerformance-1'!C17,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.10",{"$f":"IF('EvaluationPerformance-1'!C18<>0,'EvaluationPerformance-1'!C18,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,2,"Efficience",null,null,null,null,null,null,"","","","","Somme"]
[null,"2.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,"","","","",{"$f":"SUM(J20:M29)","v":0}]
[null,"2.2","Les outils utilisés pour gérer le système documentaire sont optimisés",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"2.3","Le taux d'usage des ressources documentaires qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J20:M29)","v":0}]
[null,"2.4","Le taux de documents à jour est maximal.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"2.5","Les ressources mises à disposition sont en adéquation avec les besoins des collaborateurs",null,null,null,null,null,null,"","","","",{"$f":"N20/N22","v":{"$error":"#DIV/0!"}}]
[null,"2.6",{"$f":"IF('EvaluationPerformance-1'!C25<>0,'EvaluationPerformance-1'!C25,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.7",{"$f":"IF('EvaluationPerformance-1'!C26<>0,'EvaluationPerformance-1'!C26,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.8",{"$f":"IF('EvaluationPerformance-1'!C27<>0,'EvaluationPerformance-1'!C27,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.9",{"$f":"IF('EvaluationPerformance-1'!C28<>0,'EvaluationPerformance-1'!C28,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.10",{"$f":"IF('EvaluationPerformance-1'!C29<>0,'EvaluationPerformance-1'!C29,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,3,"Qualité Perçue",null,null,null,null,null,null,"","","","","Somme"]
[null,"3.1","Vous pensez que le système documentaire qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"SUM(J31:M40)","v":0}]
[null,"3.2","Vous avez confiance dans le système documentaire qualité",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"3.3","Vous avez confiance dans les documents que vous trouvez dans le système documentaire qualité",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J31:M40)","v":0}]
[null,"3.4","Vous pensez que les documents présents dans le système documentaire qualité sont utilisés",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"3.5","Vous pensez que les documents présents dans le système documentaire qualité sont utilisables",null,null,null,null,null,null,"","","","",{"$f":"N31/N33","v":{"$error":"#DIV/0!"}}]
[null,"3.6",{"$f":"IF('EvaluationPerformance-1'!C36<>0,'EvaluationPerformance-1'!C36,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.7",{"$f":"IF('EvaluationPerformance-1'!C37<>0,'EvaluationPerformance-1'!C37,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.8",{"$f":"IF('EvaluationPerformance-1'!C38<>0,'EvaluationPerformance-1'!C38,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.9",{"$f":"IF('EvaluationPerformance-1'!C39<>0,'EvaluationPerformance-1'!C39,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.10",{"$f":"IF('EvaluationPerformance-1'!C40<>0,'EvaluationPerformance-1'!C40,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=$J$5,5,\"\")","v":""}]

{"sheet":"EvaluationPerformance-3","index":4,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,1,0,4],[2,0,2,2],[3,0,3,1],[4,0,4,1]]}
[null,"Grille d'évaluation du système documentaire qualité - Performance"]
[]
["Évaluateur 3",null,null,"Date : ",null,null,null,null,null,"Oui"]
["Nom :",null,null,null,null,null,null,null,null,"Plutôt oui"]
["Prénom : ",null,null,null,null,null,null,null,null,"Plutôt non"]
[null,null,null,null,null,null,null,null,null,"Non"]
[null,"Ligne","Sujet","Évaluation","Remarques"]
[null,1,"Efficacité",null,null,null,null,null,null,"Oui","Plutôt oui","Plutôt non","Non","Somme"]
[null,"1.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,{"$f":"IF(D9=$J$3,100,\"\")","v":""},{"$f":"IF(D9=$J$4,75,\"\")","v":""},{"$f":"IF(D9=$J$5,25,\"\")","v":""},{"$f":"IF(D9=$J$6,0,\"\")","v":""},{"$f":"SUM(J9:M18)","v":0}]
[null,"1.2","Le temps consacré à rechercher un document est correct",null,null,null,null,null,null,{"$f":"IF(D10=$J$3,100,\"\")","v":""},{"$f":"IF(D10=$J$4,75,\"\")","v":""},{"$f":"IF(D10=$J$5,25,\"\")","v":""},{"$f":"IF(D10=$J$6,0,\"\")","v":""},"Nombre de valeurs"]
[null,"1.3","Le taux de consultation des documents est bon.",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J9:M18)","v":0}]
[null,"1.4","Le nombre de documents présents dans le système documentaire qualité est satisfaisant.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"1.5","Tous les documents du système sont utilisés",null,null,null,null,null,null,"","","","",{"$f":"N9/N11","v":{"$error":"#DIV/0!"}}]
[null,"1.6",{"$f":"IF('EvaluationPerformance-1'!C14<>0,'EvaluationPerformance-1'!C14,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.7",{"$f":"IF('EvaluationPerformance-1'!C15<>0,'EvaluationPerformance-1'!C15,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.8",{"$f":"IF('EvaluationPerformance-1'!C16<>0,'EvaluationPerformance-1'!C16,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.9",{"$f":"IF('EvaluationPerformance-1'!C17<>0,'EvaluationPerformance-1'!C17,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.10",{"$f":"IF('EvaluationPerformance-1'!C18<>0,'EvaluationPerformance-1'!C18,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,2,"Efficience",null,null,null,null,null,null,"","","","","Somme"]
[null,"2.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,"","","","",{"$f":"SUM(J20:M29)","v":0}]
[null,"2.2","Les outils utilisés pour gérer le système documentaire sont optimisés",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"2.3","Le taux d'usage des ressources documentaires qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J20:M29)","v":0}]
[null,"2.4","Le taux de documents à jour est maximal.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"2.5","Les ressources mises à disposition sont en adéquation avec les besoins des collaborateurs",null,null,null,null,null,null,"","","","",{"$f":"N20/N22","v":{"$error":"#DIV/0!"}}]
[null,"2.6",{"$f":"IF('EvaluationPerformance-1'!C25<>0,'EvaluationPerformance-1'!C25,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.7",{"$f":"IF('EvaluationPerformance-1'!C26<>0,'EvaluationPerformance-1'!C26,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.8",{"$f":"IF('EvaluationPerformance-1'!C27<>0,'EvaluationPerformance-1'!C27,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.9",{"$f":"IF('EvaluationPerformance-1'!C28<>0,'EvaluationPerformance-1'!C28,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.10",{"$f":"IF('EvaluationPerformance-1'!C29<>0,'EvaluationPerformance-1'!C29,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,3,"Qualité Perçue",null,null,null,null,null,null,"","","","","Somme"]
[null,"3.1","Vous pensez que le système documentaire qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"SUM(J31:M40)","v":0}]
[null,"3.2","Vous avez confiance dans le système documentaire qualité",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"3.3","Vous avez confiance dans les documents que vous trouvez dans le système documentaire qualité",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J31:M40)","v":0}]
[null,"3.4","Vous pensez que les documents présents dans le système documentaire qualité sont utilisés",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"3.5","Vous pensez que les documents présents dans le système documentaire qualité sont utilisables",null,null,null,null,null,null,"","","","",{"$f":"N31/N33","v":{"$error":"#DIV/0!"}}]
[null,"3.6",{"$f":"IF('EvaluationPerformance-1'!C36<>0,'EvaluationPerformance-1'!C36,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.7",{"$f":"IF('EvaluationPerformance-1'!C37<>0,'EvaluationPerformance-1'!C37,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.8",{"$f":"IF('EvaluationPerformance-1'!C38<>0,'EvaluationPerformance-1'!C38,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.9",{"$f":"IF('EvaluationPerformance-1'!C39<>0,'EvaluationPerformance-1'!C39,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.10",{"$f":"IF('EvaluationPerformance-1'!C40<>0,'EvaluationPerformance-1'!C40,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=$J$5,5,\"\")","v":""}]

{"sheet":"EvaluationPerformance-4","index":5,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,1,0,4],[2,0,2,2],[3,0,3,1],[4,0,4,1]]}
[null,"Grille d'évaluation du système documentaire qualité - Performance"]
[]
["Évaluateur 4",null,null,"Date : ",null,null,null,null,null,"Oui"]
["Nom :",null,null,null,null,null,null,null,null,"Plutôt oui"]
["Prénom : ",null,null,null,null,null,null,null,null,"Plutôt non"]
[null,null,null,null,null,null,null,null,null,"Non"]
[null,"Ligne","Sujet","Évaluation","Remarques"]
[null,1,"Efficacité",null,null,null,null,null,null,"Oui","Plutôt oui","Plutôt non","Non","Somme"]
[null,"1.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,{"$f":"IF(D9=$J$3,100,\"\")","v":""},{"$f":"IF(D9=$J$4,75,\"\")","v":""},{"$f":"IF(D9=$J$5,25,\"\")","v":""},{"$f":"IF(D9=$J$6,0,\"\")","v":""},{"$f":"SUM(J9:M18)","v":0}]
[null,"1.2","Le temps consacré à rechercher un document est correct",null,null,null,null,null,null,{"$f":"IF(D10=$J$3,100,\"\")","v":""},{"$f":"IF(D10=$J$4,75,\"\")","v":""},{"$f":"IF(D10=$J$5,25,\"\")","v":""},{"$f":"IF(D10=$J$6,0,\"\")","v":""},"Nombre de valeurs"]
[null,"1.3","Le taux de consultation des documents est bon.",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J9:M18)","v":0}]
[null,"1.4","Le nombre de documents présents dans le système documentaire qualité est satisfaisant.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"1.5","Tous les documents du système sont utilisés",null,null,null,null,null,null,"","","","",{"$f":"N9/N11","v":{"$error":"#DIV/0!"}}]
[null,"1.6",{"$f":"IF('EvaluationPerformance-1'!C14<>0,'EvaluationPerformance-1'!C14,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.7",{"$f":"IF('EvaluationPerformance-1'!C15<>0,'EvaluationPerformance-1'!C15,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.8",{"$f":"IF('EvaluationPerformance-1'!C16<>0,'EvaluationPerformance-1'!C16,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.9",{"$f":"IF('EvaluationPerformance-1'!C17<>0,'EvaluationPerformance-1'!C17,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.10",{"$f":"IF('EvaluationPerformance-1'!C18<>0,'EvaluationPerformance-1'!C18,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,2,"Efficience",null,null,null,null,null,null,"","","","","Somme"]
[null,"2.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,"","","","",{"$f":"SUM(J20:M29)","v":0}]
[null,"2.2","Les outils utilisés pour gérer le système documentaire sont optimisés",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"2.3","Le taux d'usage des ressources documentaires qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J20:M29)","v":0}]
[null,"2.4","Le taux de documents à jour est maximal.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"2.5","Les ressources mises à disposition sont en adéquation avec les besoins des collaborateurs",null,null,null,null,null,null,"","","","",{"$f":"N20/N22","v":{"$error":"#DIV/0!"}}]
[null,"2.6",{"$f":"IF('EvaluationPerformance-1'!C25<>0,'EvaluationPerformance-1'!C25,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.7",{"$f":"IF('EvaluationPerformance-1'!C26<>0,'EvaluationPerformance-1'!C26,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.8",{"$f":"IF('EvaluationPerformance-1'!C27<>0,'EvaluationPerformance-1'!C27,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.9",{"$f":"IF('EvaluationPerformance-1'!C28<>0,'EvaluationPerformance-1'!C28,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.10",{"$f":"IF('EvaluationPerformance-1'!C29<>0,'EvaluationPerformance-1'!C29,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,3,"Qualité Perçue",null,null,null,null,null,null,"","","","","Somme"]
[null,"3.1","Vous pensez que le système documentaire qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"SUM(J31:M40)","v":0}]
[null,"3.2","Vous avez confiance dans le système documentaire qualité",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"3.3","Vous avez confiance dans les documents que vous trouvez dans le système documentaire qualité",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J31:M40)","v":0}]
[null,"3.4","Vous pensez que les documents présents dans le système documentaire qualité sont utilisés",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"3.5","Vous pensez que les documents présents dans le système documentaire qualité sont utilisables",null,null,null,null,null,null,"","","","",{"$f":"N31/N33","v":{"$error":"#DIV/0!"}}]
[null,"3.6",{"$f":"IF('EvaluationPerformance-1'!C36<>0,'EvaluationPerformance-1'!C36,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.7",{"$f":"IF('EvaluationPerformance-1'!C37<>0,'EvaluationPerformance-1'!C37,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.8",{"$f":"IF('EvaluationPerformance-1'!C38<>0,'EvaluationPerformance-1'!C38,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.9",{"$f":"IF('EvaluationPerformance-1'!C39<>0,'EvaluationPerformance-1'!C39,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.10",{"$f":"IF('EvaluationPerformance-1'!C40<>0,'EvaluationPerformance-1'!C40,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=$J$5,5,\"\")","v":""}]

{"sheet":"EvaluationPerformance-5","index":6,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,1,0,4],[2,0,2,2],[3,0,3,1],[4,0,4,1]]}
[null,"Grille d'évaluation du système documentaire qualité - Performance"]
[]
["Évaluateur 5",null,null,"Date : ",null,null,null,null,null,"Oui"]
["Nom :",null,null,null,null,null,null,null,null,"Plutôt oui"]
["Prénom : ",null,null,null,null,null,null,null,null,"Plutôt non"]
[null,null,null,null,null,null,null,null,null,"Non"]
[null,"Ligne","Sujet","Évaluation","Remarques"]
[null,1,"Efficacité",null,null,null,null,null,null,"Oui","Plutôt oui","Plutôt non","Non","Somme"]
[null,"1.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,{"$f":"IF(D9=$J$3,100,\"\")","v":""},{"$f":"IF(D9=$J$4,75,\"\")","v":""},{"$f":"IF(D9=$J$5,25,\"\")","v":""},{"$f":"IF(D9=$J$6,0,\"\")","v":""},{"$f":"SUM(J9:M18)","v":0}]
[null,"1.2","Le temps consacré à rechercher un document est correct",null,null,null,null,null,null,{"$f":"IF(D10=$J$3,100,\"\")","v":""},{"$f":"IF(D10=$J$4,75,\"\")","v":""},{"$f":"IF(D10=$J$5,25,\"\")","v":""},{"$f":"IF(D10=$J$6,0,\"\")","v":""},"Nombre de valeurs"]
[null,"1.3","Le taux de consultation des documents est bon.",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J9:M18)","v":0}]
[null,"1.4","Le nombre de documents présents dans le système documentaire qualité est satisfaisant.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"1.5","Tous les documents du système sont utilisés",null,null,null,null,null,null,"","","","",{"$f":"N9/N11","v":{"$error":"#DIV/0!"}}]
[null,"1.6",{"$f":"IF('EvaluationPerformance-1'!C14<>0,'EvaluationPerformance-1'!C14,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.7",{"$f":"IF('EvaluationPerformance-1'!C15<>0,'EvaluationPerformance-1'!C15,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.8",{"$f":"IF('EvaluationPerformance-1'!C16<>0,'EvaluationPerformance-1'!C16,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.9",{"$f":"IF('EvaluationPerformance-1'!C17<>0,'EvaluationPerformance-1'!C17,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"1.10",{"$f":"IF('EvaluationPerformance-1'!C18<>0,'EvaluationPerformance-1'!C18,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,2,"Efficience",null,null,null,null,null,null,"","","","","Somme"]
[null,"2.1","Tous les collaborateurs ont accès aux informations lorsqu'ils en ont besoin",null,null,null,null,null,null,"","","","",{"$f":"SUM(J20:M29)","v":0}]
[null,"2.2","Les outils utilisés pour gérer le système documentaire sont optimisés",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"2.3","Le taux d'usage des ressources documentaires qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J20:M29)","v":0}]
[null,"2.4","Le taux de documents à jour est maximal.",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"2.5","Les ressources mises à disposition sont en adéquation avec les besoins des collaborateurs",null,null,null,null,null,null,"","","","",{"$f":"N20/N22","v":{"$error":"#DIV/0!"}}]
[null,"2.6",{"$f":"IF('EvaluationPerformance-1'!C25<>0,'EvaluationPerformance-1'!C25,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.7",{"$f":"IF('EvaluationPerformance-1'!C26<>0,'EvaluationPerformance-1'!C26,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.8",{"$f":"IF('EvaluationPerformance-1'!C27<>0,'EvaluationPerformance-1'!C27,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.9",{"$f":"IF('EvaluationPerformance-1'!C28<>0,'EvaluationPerformance-1'!C28,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"2.10",{"$f":"IF('EvaluationPerformance-1'!C29<>0,'EvaluationPerformance-1'!C29,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,3,"Qualité Perçue",null,null,null,null,null,null,"","","","","Somme"]
[null,"3.1","Vous pensez que le système documentaire qualité est bon",null,null,null,null,null,null,"","","","",{"$f":"SUM(J31:M40)","v":0}]
[null,"3.2","Vous avez confiance dans le système documentaire qualité",null,null,null,null,null,null,"","","","","Nombre de valeurs"]
[null,"3.3","Vous avez confiance dans les documents que vous trouvez dans le système documentaire qualité",null,null,null,null,null,null,"","","","",{"$f":"COUNT(J31:M40)","v":0}]
[null,"3.4","Vous pensez que les documents présents dans le système documentaire qualité sont utilisés",null,null,null,null,null,null,"","","","","Moyenne"]
[null,"3.5","Vous pensez que les documents présents dans le système documentaire qualité sont utilisables",null,null,null,null,null,null,"","","","",{"$f":"N31/N33","v":{"$error":"#DIV/0!"}}]
[null,"3.6",{"$f":"IF('EvaluationPerformance-1'!C36<>0,'EvaluationPerformance-1'!C36,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.7",{"$f":"IF('EvaluationPerformance-1'!C37<>0,'EvaluationPerformance-1'!C37,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.8",{"$f":"IF('EvaluationPerformance-1'!C38<>0,'EvaluationPerformance-1'!C38,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.9",{"$f":"IF('EvaluationPerformance-1'!C39<>0,'EvaluationPerformance-1'!C39,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,"3.10",{"$f":"IF('EvaluationPerformance-1'!C40<>0,'EvaluationPerformance-1'!C40,\"\")","v":""},null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D41=$J$5,5,\"\")","v":""}]

{"sheet":"Résultats","index":7,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,1,2,9],[4,1,5,2],[4,3,5,9],[7,5,9,9],[4,13,4,14],[5,13,5,14],[6,13,6,14],[7,13,7,14],[29,3,30,9],[10,1,10,4],[7,1,7,4],[16,1,16,4],[13,1,13,4],[10,5,12,9],[13,5,15,9],[16,5,18,9],[32,1,32,9],[20,1,20,9],[25,1,25,2],[27,1,27,2],[25,3,26,9],[27,3,28,9],[22,1,22,2],[22,3,23,9]]}
[null,"Évaluation du système documentaire qualité"]
[]
[null,"Conformité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"En pourcentage"]
[null,"Conformité globale :",null,{"$f":"IF(EvaluationConformité!K8=0,\"\",IF(EvaluationConformité!K8=100,\"Félicitation votre système documentaire est conforme à la norme ISO 9001:2008.\",\"Malheureusement, votre système documentaire n'est pas conforme à la norme ISO 9001:2008. Il vous reste encore quelques efforts à fournir pour y arriver.\"))","v":""},null,null,null,null,null,null,null,null,null,"Manuel Qualité",null,{"$f":"EvaluationConformité!K9","v":0},{"$f":"P5/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Maîtrise des documents",null,{"$f":"EvaluationConformité!K15","v":0},{"$f":"P6/100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Maîtrise des enregistrements",null,{"$f":"EvaluationConformité!K27","v":0},0]
[null,"Conformité au manuel qualité : ",null,null,null,{"$f":"IF(EvaluationConformité!K11=0,\"\",IF(EvaluationConformité!K9=100,\"Félicitation, votre manuel qualité est conforme aux exigences.\",\"Malheureusement, votre manuel qualité n'est pas encore conforme à la norme ISO. Il vous reste quelques points à retravailler.\"))","v":""},null,null,null,null,null,null,null,"Documents exigés",null,{"$f":"EvaluationConformité!K36","v":0},0]
[]
[]
[null,"Conformité à la maîtrise des documents : ",null,null,null,{"$f":"IF(EvaluationConformité!K19=0,\"\",IF(EvaluationConformité!K15=100,\"Félicitation, les documents de votre système sont conformes à la norme ISO 9001:2008.\",\"Malheureusement, vos documents ne sont pas encore assez maîtrisés pour être conforme à la norme. Encore quelques efforts.\"))","v":""}]
[]
[]
[null,"Conformité à la maîtrise des enregistrements : ",null,null,null,{"$f":"IF(EvaluationConformité!K28=0,\"\",IF(EvaluationConformité!K27=100,\"Félicitation, les enregistrements de votre système qualité sont maîtrisés selon les exigences de la norme.\",\"Malheureusement, vos enregistrements qualités ne satisfont pas encore toutes les exigences de la norme. Un petit travail est encore à fournir pour y parvenir.\"))","v":""}]
[]
[]
[null,"Conformité aux documents exigés : ",null,null,null,{"$f":"IF(EvaluationConformité!K37=0,\"\",IF(AND(EvaluationConformité!K36=100,EvaluationConformité!I27=100,EvaluationConformité!I15=100,EvaluationConformité!I12=100),\"Félicitation, vous disposez de tous les documents exigés par la norme ISO 9001-2008.\",\"Malheureusement, vous ne disposez pas de tous les documents satisfaisants aux exigences de la norme.\"))","v":""}]
[]
[]
[]
[null,"Performance"]
[]
[null,"Performance",null,{"$f":"IF(CalculsPerformance!G7=\"\",\"\",IF(CalculsPerformance!G7>66,CalculsPerformance!C10,IF(CalculsPerformance!G7<33,CalculsPerformance!C12,CalculsPerformance!C11)))","v":""}]
[]
[]
[null,"Efficacité :",null,{"$f":"IF(CalculsPerformance!G4=\"\",\"\",IF(CalculsPerformance!G4>66,CalculsPerformance!C13,IF(CalculsPerformance!G4<33,CalculsPerformance!C15,CalculsPerformance!C14)))","v":""}]
[]
[null,"Efficience :",null,{"$f":"IF(CalculsPerformance!G5=\"\",\"\",IF(CalculsPerformance!G5>66,CalculsPerformance!C16,IF(CalculsPerformance!G5<33,CalculsPerformance!C18,CalculsPerformance!C17)))","v":""}]
[]
[null,"Qualité Perçue :",null,{"$f":"IF(CalculsPerformance!G6=\"\",\"\",IF(CalculsPerformance!G6>66,CalculsPerformance!C19,IF(CalculsPerformance!G6<33,CalculsPerformance!C21,CalculsPerformance!C20)))","v":""}]
[]
[]
[null,"Navigation - Accès rapides"]

{"sheet":"CalculsPerformance","index":8,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[[15,2,15,6],[14,2,14,6],[13,2,13,6],[20,2,20,6],[19,2,19,6],[18,2,18,6],[17,2,17,6],[16,2,16,6],[12,2,12,6],[11,2,11,6],[10,2,10,6],[9,2,9,6],[0,1,0,5]]}
[null,"Calcul de la performance du système documentaire qualité"]
[]
[null,"Évaluateur 1","Évaluateur 2","Évaluateur 3","Évaluateur 4","Évaluateur 5","Moyenne"]
["Efficacité",{"$f":"IF('EvaluationPerformance-1'!N11<>0,'EvaluationPerformance-1'!N13,\"\")","v":""},{"$f":"IF('EvaluationPerformance-2'!N11<>0,'EvaluationPerformance-2'!N13,\"\")","v":""},{"$f":"IF('EvaluationPerformance-3'!N11<>0,'EvaluationPerformance-3'!N13,\"\")","v":""},{"$f":"IF('EvaluationPerformance-4'!N11<>0,'EvaluationPerformance-4'!N13,\"\")","v":""},{"$f":"IF('EvaluationPerformance-5'!N11<>0,'EvaluationPerformance-5'!N13,\"\")","v":""},{"$f":"IF(B4<>\"\",AVERAGE(B4:F4),\"\")","v":""}]
["Efficience",{"$f":"IF('EvaluationPerformance-1'!N22<>0,'EvaluationPerformance-1'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-2'!N22<>0,'EvaluationPerformance-2'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-3'!N22<>0,'EvaluationPerformance-3'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-4'!N22<>0,'EvaluationPerformance-4'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-5'!N22<>0,'EvaluationPerformance-5'!N24,\"\")","v":""},{"$f":"IF(B5<>\"\",AVERAGE(B5:F5),\"\")","v":""}]
["Qualité Perçue",{"$f":"IF('EvaluationPerformance-1'!N22<>0,'EvaluationPerformance-1'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-2'!N22<>0,'EvaluationPerformance-2'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-3'!N22<>0,'EvaluationPerformance-3'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-4'!N22<>0,'EvaluationPerformance-4'!N24,\"\")","v":""},{"$f":"IF('EvaluationPerformance-5'!N22<>0,'EvaluationPerformance-5'!N24,\"\")","v":""},{"$f":"IF(B6<>\"\",AVERAGE(B6:F6),\"\")","v":""}]
["Performance",{"$f":"IF(B4<>\"\",AVERAGE(B4:B6),\"\")","v":""},{"$f":"IF(C4<>\"\",AVERAGE(C4:C6),\"\")","v":""},{"$f":"IF(D4<>\"\",AVERAGE(D4:D6),\"\")","v":""},"","","",{"$f":"G7","v":""},{"$f":"G7","v":""}]
[]
[]
["Performance","Bonne","La performance de votre système est bonne. Continuez vos efforts pour arriver à l'excellence."]
[null,"Moyenne","Votre système est assez performant. Cependant, n'hésitez pas à lancer des actions d'amélioration afin de le rendre encore plus performant."]
[null,"Faible","Votre système n'est pas très performant. Pensez à lancer des actions dans les critères ci-dessous afin d'essayer d'y remédier."]
["Efficacité","Bonne","Votre système est efficace : il a atteint ses objectifs."]
[null,"Moyenne","Tous les objectifs de votre système qualité ne sont pas atteints. Travailler afin d'essayer d'améliorer ce point."]
[null,"Faible","Trop d'objectifs ne sont pas atteints dans votre système. Essayer de mettre en place des actions afin d'y remédier."]
["Efficience","Bonne","Votre système utilise des ressources optimisées afin d'obtenir les meilleurs résultats possible"]
[null,"Moyenne","Votre système pourrait mieux utiliser les ressources dont il dispose afin d'être performant"]
[null,"Faible","Votre système n'est pas efficient. Essayez de mettre en place un certain nombre d'actions afin de régler ce problème."]
["Qualité perçue","Bonne","Vos collaborateurs ont une excellente opinion de votre système documentaire qualité."]
[null,"Moyenne ","Vos collaborateurs ont une opinion assez moyenne sur votre système. N'hésitez pas à mieux prendre leurs besoins en compte."]
[null,"Faible","Vos collaborateurs n'ont pas une bonne opinion de votre système documentaire qualité. Pensez à y remédier en prenant mieux en compte leurs attentes et leurs besoins"]
[]
[null,"Pourcentage"]
[null,"Évaluateur 1","Évaluateur 2","Évaluateur 3","Évaluateur 4","Évaluateur 5","Moyenne"]
["Efficacité",{"$f":"IF(B4<>\"\",B4/100,\"\")","v":""},{"$f":"IF(C4<>\"\",C4/100,\"\")","v":""},"","","",{"$f":"IF(G4<>\"\",G4/100,\"\")","v":""}]
["Efficience",{"$f":"IF(B5<>\"\",B5/100,\"\")","v":""},"","","","",{"$f":"IF(G5<>\"\",G5/100,\"\")","v":""}]
["Qualité Perçue",{"$f":"IF(B6<>\"\",B6/100,\"\")","v":""},"","","","",""]
["Performance",{"$f":"IF(B7<>\"\",B7/100,\"\")","v":""},"","","","","","",""]