{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Listes","Paramètres","Lisez-moi","Exigences","RACI","Plan de contrôle","Risques & Actions","Checklists","CAPA","Incidents & NC","Livrables & Jalons","Audits & Revues","Dashboard"],"not_rendered":{"charts":4,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Listes","index":0,"n_rows":5,"n_cols":4,"rows_kept":5}
["Statuts","Criticités","Oui/Non","Checkbox"]
["Non démarré","Faible","Oui","☐"]
["En cours","Moyen","Non","☑"]
["Terminé","Élevé"]
["Bloqué","Critique"]

{"sheet":"Paramètres","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"merged":[[0,0,0,5],[1,0,1,5]]}
["Paramètres du modèle"]
["Seuils & options"]
[]
["Paramètre","Valeur par défaut","Description"]
["Seuil KPI OK (%)",0.8,"Seuil vert pour KPI de % (ex: >80%)"]
["Seuil KPI Alerte (%)",0.5,"Seuil orange (ex: >50%)"]

{"sheet":"Lisez-moi","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"merged":[[0,0,0,7],[1,0,1,7]]}
["PQP — Modèle standard PLUS (checkboxes)"]
["Mode d'emploi"]
[]
["• Jusqu'à 500 lignes par onglet (validations actives)."]
["• '☐/☑' = cases à cocher via liste ; couleurs auto."]
["• KPI & Dashboard sans macros. Ajustez les seuils dans Paramètres."]

{"sheet":"Exigences","index":3,"n_rows":9,"n_cols":12,"rows_kept":9,"merged":[[0,0,0,7],[1,0,1,7]]}
["Plan Qualité Projet — Exigences"]
["Standard"]
[]
["ID","Exigence","Source","Responsable","Échéance","Statut","Preuve","Commentaire","Approuvée (☐/☑)","Validée (☐/☑)",null,"% Exigences terminées"]
["REQ-001","Exigences critiques client formalisées","Client","Chef Qualité","2025-09-21","En cours",null,null,"☑","☐",null,{"$f":"IFERROR(COUNTIF(F5:F500,\"Terminé\")/COUNTA(F5:F500),0)","v":{"v":0,"d":"0.0%"}}]
["REQ-002","Normes applicables identifiées et intégrées","Norme","Resp. Qualité Projet","2025-10-06","Non démarré",null,null,"☐","☐",null,"% Exigences approuvées"]
[{"$nulls":11},{"$f":"IFERROR(COUNTIF(I5:I500,\"☑\")/COUNTA(I5:I500),0)","v":{"v":0,"d":"0.0%"}}]
[{"$nulls":11},"% Exigences validées"]
[{"$nulls":11},{"$f":"IFERROR(COUNTIF(J5:J500,\"☑\")/COUNTA(J5:J500),0)","v":{"v":0,"d":"0.0%"}}]

{"sheet":"RACI","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"merged":[[0,0,0,7],[1,0,1,7]]}
["Matrice RACI"]
["Standard"]
[]
["Activité","R (Responsable)","A (Autorité)","C (Consulté)","I (Informé)","Statut","Sign-off (☐/☑)",null,"% Activités signées"]
["Planification qualité initiale","Resp. Qualité","Chef de Projet","Ing. Proc.","Direction","En cours","☐",null,{"$f":"IFERROR(COUNTIF(G5:G500,\"☑\")/COUNTA(G5:G500),0)","v":{"v":0,"d":"0.0%"}}]
["Revue de conception","Ing. Conception","Chef de Projet","Qualité","Client","Non démarré","☐"]

{"sheet":"Plan de contrôle","index":5,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7]]}
["Plan de Contrôle / PAQ"]
["Standard"]
[]
["Phase/Processus","Contrôle","Méthode","Fréquence","Échantillon","Critère d'acceptation","Responsable","Preuve","Statut","Fiche à jour (☐/☑)",null,"% Contrôles actifs"]
["Réception","Contrôle matière","Vérif. COA","Chaque lot","100%","COA conforme","QC",null,"En cours","☑",null,{"$f":"IFERROR((COUNTIF(I5:I500,\"En cours\")+COUNTIF(I5:I500,\"Terminé\"))/MAX(COUNTA(I5:I500),1),0)","v":{"v":0,"d":"0.0%"}}]
["Production","Inspection visuelle","Check-list","Horaire","AQL 1.0","0 défaut critique","Qualité Ligne",null,"Non démarré","☐",null,"% Fiches à jour"]
[{"$nulls":11},{"$f":"IFERROR(COUNTIF(J5:J500,\"☑\")/COUNTA(J5:J500),0)","v":{"v":0,"d":"0.0%"}}]

{"sheet":"Risques & Actions","index":6,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7]]}
["Risques & Actions Qualité"]
["Standard"]
[]
["Risque","Cause","Effet","Criticité","Mesure/Action","Propriétaire","Échéance","Statut","Mitigé ? (☐/☑)",null,"% Actions clôturées"]
["NC récurrentes","Procédure inadaptée","Retards & rebut","Élevé","Réviser procédure","Qualité","2025-09-06","En cours","☐",null,{"$f":"IFERROR(COUNTIF(H5:H500,\"Terminé\")/COUNTA(H5:H500),0)","v":{"v":0,"d":"0.0%"}}]
["Fournisseur instable","Variabilité lot","Échec tests","Critique","Audit fournisseur","Achat","2025-09-16","Non démarré","☐",null,"% Risques mitigés"]
[{"$nulls":10},{"$f":"IFERROR(COUNTIF(I5:I500,\"☑\")/COUNTA(I5:I500),0)","v":{"v":0,"d":"0.0%"}}]

{"sheet":"Checklists","index":7,"n_rows":6,"n_cols":10,"rows_kept":6,"merged":[[0,0,0,7],[1,0,1,7]]}
["Checklists de Qualité"]
["Standard"]
[]
["Point de contrôle","Fréquence","Responsable","Preuve","Conforme (Oui/Non)","Observation","Statut","Vérifié (☐/☑)",null,"% Points vérifiés"]
["Check 5S zone critique","Quotidien","Superviseur","Photo","Oui",null,"Terminé","☑",null,{"$f":"IFERROR(COUNTIF(H5:H500,\"☑\")/COUNTA(H5:H500),0)","v":{"v":0,"d":"0.0%"}}]
["Vérif. calibration instruments","Mensuel","Métrologie","Certificat","Non","Étalon en retard","En cours","☐"]

{"sheet":"CAPA","index":8,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7]]}
["CAPA — Correctives & Préventives"]
["Standard"]
[]
["Type (NC/Obs/Amélio)","Référence","Description","Cause racine","Action","Responsable","Échéance","Statut","Vérifié (☐/☑)","Efficace (Oui/Non)",null,"% CAPA clôturées"]
["NC","CAPA-001","Défaut critique récurrent","Ishikawa: Méthode","Standardiser procédure","Qualité","2025-09-11","En cours","☐","Oui",null,{"$f":"IFERROR(COUNTIF(H5:H500,\"Terminé\")/COUNTA(H5:H500),0)","v":{"v":0,"d":"0.0%"}}]
["Obs","CAPA-002","Dérive ponctuelle","5-Why: Matière","Audit fournisseur","Achat","2025-09-21","Non démarré","☐","Non",null,"% CAPA vérifiées"]
[{"$nulls":11},{"$f":"IFERROR(COUNTIF(I5:I500,\"☑\")/COUNTA(I5:I500),0)","v":{"v":0,"d":"0.0%"}}]

{"sheet":"Incidents & NC","index":9,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,0,0,7],[1,0,1,7]]}
["Registre Incidents & Non-Conformités"]
["Standard"]
[]
["ID","Date","Processus/Zone","Gravité","Description","Action immédiate","Responsable","Statut","Clôturé (☐/☑)",null,"% NC/Incidents clôturés"]
["NC-001","2025-08-17","Ligne A","Élevé","Pièce hors tolérance","Isolement lot","Qualité","En cours","☐",null,{"$f":"IFERROR(COUNTIF(I5:I500,\"☑\")/COUNTA(I5:I500),0)","v":{"v":0,"d":"0.0%"}}]
["INC-002","2025-08-20","IT-CRM","Moyen","Erreur d’accès","Révocation droits","SecOps","Terminé","☑"]

{"sheet":"Livrables & Jalons","index":10,"n_rows":7,"n_cols":10,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7]]}
["Livrables & Jalons"]
["Standard (mini-Gantt)"]
[]
["Livrable/Jalon","Responsable","Début","Fin","Statut","Approuvé (☐/☑)","Terminé (☐/☑)","Durée (jours)","Début_num","Durée_num"]
["Spécifications validées","Chef de Projet","2025-08-20","2025-08-27","En cours","☑","☐",{"$f":"IFERROR(D5-C5,0)","v":0},{"$f":"C5","v":"00:00:00"},{"$f":"MAX(D5-C5,0)","v":0}]
["Plan de test UAT","QA","2025-08-23","2025-09-01","Non démarré","☐","☐",{"$f":"IFERROR(D6-C6,0)","v":0},{"$f":"C6","v":"00:00:00"},{"$f":"MAX(D6-C6,0)","v":0}]
["Lot pilote","Production","2025-08-25","2025-09-06","Non démarré","☐","☐",{"$f":"IFERROR(D7-C7,0)","v":0},{"$f":"C7","v":"00:00:00"},{"$f":"MAX(D7-C7,0)","v":0}]

{"sheet":"Audits & Revues","index":11,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,0,0,7],[1,0,1,7]]}
["Audits & Revues"]
["Standard"]
[]
["Type","Date","Auditeur","Périmètre/Zone","NC détectées","Actions ouvertes","Délai moyen clôture (j)","Statut","Rapport envoyé (☐/☑)",null,"NC / Audit (moy.)"]
["Audit interne","2025-08-08","Auditeur A","Production",5,2,10,"En cours","☐",null,{"$f":"IFERROR(AVERAGE(E5:E500),0)","v":0}]
["Revue de processus","2025-08-15","Chef Qualité","Processus X",0,0,0,"Terminé","☑"]

{"sheet":"Dashboard","index":12,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[0,0,0,16],[1,0,1,16]]}
["Tableau de Bord Qualité"]
["Standard PLUS"]
[]
["KPI","Valeur",null,"Statut","Nb (Exigences)"]
["% Exigences terminées",{"$f":"'Exigences'!L5","v":0},{"$f":"1-B5","v":0},"Non démarré",{"$f":"COUNTIF('Exigences'!F5:F500,\"Non démarré\")","v":0}]
["% Exigences approuvées",{"$f":"'Exigences'!L7","v":0},null,"En cours",{"$f":"COUNTIF('Exigences'!F5:F500,\"En cours\")","v":0}]
["% Exigences validées",{"$f":"'Exigences'!L9","v":0},null,"Terminé",{"$f":"COUNTIF('Exigences'!F5:F500,\"Terminé\")","v":0}]
["% Actions risques clôturées",{"$f":"'Risques & Actions'!K5","v":0},null,"Bloqué",{"$f":"COUNTIF('Exigences'!F5:F500,\"Bloqué\")","v":0}]
["% CAPA clôturées",{"$f":"'CAPA'!L5","v":0},{"$f":"1-B9","v":0}]
["% Checklists vérifiées",{"$f":"'Checklists'!J5","v":0}]