{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Ishikawa_Input","Pareto","Fishbone_View","Guide"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Ishikawa_Input","index":0,"n_rows":200,"n_cols":12,"rows_kept":200,"merged":[[0,0,0,8]]}
["Modèle automatisé - Diagramme d’Ishikawa (6M)"]
[{"$nulls":10},"KPI"]
["Catégorie (6M)","Cause","Fréquence","Impact (1-5)","Score Risque","Responsable","Échéance","Statut","Commentaires",null,"% Ouvertes",{"$f":"IFERROR(COUNTIF(H4:H200,\"Ouverte\")/COUNTA(H4:H200),0)","v":null}]
["Machines","Four mal calibré",12,5,null,"Durand",null,"En cours","Calibration hebdomadaire à revoir",null,"% En cours",{"$f":"IFERROR(COUNTIF(H4:H200,\"En cours\")/COUNTA(H4:H200),0)","v":null}]
["Mesures","Sonde de température instable",4,4,null,"Martin",null,"Ouverte","Remplacer la sonde",null,"% Fermées",{"$f":"IFERROR(COUNTIF(H4:H200,\"Fermée\")/COUNTA(H4:H200),0)","v":null}]
["Méthodes","Procédure de prélèvement floue",3,3,null,"Leclerc",null,"Ouverte","Mettre à jour l'instruction",null,"Score moyen",{"$f":"IFERROR(AVERAGEIF(E4:E200,\">0\",E4:E200),0)","v":null}]
["Main d'œuvre","Formation incomplète",5,4,null,"Dupont",null,"En cours","Plan de formation Q3"]
["Matières","Variabilité fournisseur",2,3,null,"Benali",null,"Fermée","Qualification fournisseur terminée"]
["Milieu","Humidité atelier élevée",1,2,null,"Saidi",null,"Ouverte","Installation déshumidificateur"]
[{"$nulls":4},{"$f":"IFERROR(C10*D10,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C11*D11,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C12*D12,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C13*D13,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C14*D14,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C15*D15,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C16*D16,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C17*D17,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C18*D18,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C19*D19,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C20*D20,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C21*D21,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C22*D22,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C23*D23,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C24*D24,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C25*D25,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C26*D26,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C27*D27,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C28*D28,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C29*D29,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C30*D30,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C31*D31,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C32*D32,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C33*D33,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C34*D34,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C35*D35,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C36*D36,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C37*D37,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C38*D38,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C39*D39,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C40*D40,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C41*D41,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C42*D42,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C43*D43,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C44*D44,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C45*D45,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C46*D46,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C47*D47,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C48*D48,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C49*D49,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C50*D50,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C51*D51,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C52*D52,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C53*D53,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C54*D54,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C55*D55,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C56*D56,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C57*D57,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C58*D58,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C59*D59,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C60*D60,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C61*D61,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C62*D62,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C63*D63,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C64*D64,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C65*D65,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C66*D66,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C67*D67,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C68*D68,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C69*D69,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C70*D70,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C71*D71,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C72*D72,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C73*D73,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C74*D74,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C75*D75,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C76*D76,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C77*D77,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C78*D78,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C79*D79,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C80*D80,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C81*D81,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C82*D82,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C83*D83,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C84*D84,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C85*D85,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C86*D86,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C87*D87,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C88*D88,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C89*D89,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C90*D90,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C91*D91,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C92*D92,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C93*D93,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C94*D94,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C95*D95,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C96*D96,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C97*D97,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C98*D98,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C99*D99,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C100*D100,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C101*D101,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C102*D102,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C103*D103,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C104*D104,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C105*D105,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C106*D106,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C107*D107,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C108*D108,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C109*D109,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C110*D110,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C111*D111,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C112*D112,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C113*D113,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C114*D114,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C115*D115,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C116*D116,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C117*D117,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C118*D118,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C119*D119,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C120*D120,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C121*D121,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C122*D122,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C123*D123,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C124*D124,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C125*D125,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C126*D126,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C127*D127,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C128*D128,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C129*D129,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C130*D130,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C131*D131,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C132*D132,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C133*D133,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C134*D134,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C135*D135,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C136*D136,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C137*D137,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C138*D138,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C139*D139,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C140*D140,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C141*D141,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C142*D142,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C143*D143,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C144*D144,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C145*D145,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C146*D146,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C147*D147,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C148*D148,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C149*D149,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C150*D150,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C151*D151,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C152*D152,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C153*D153,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C154*D154,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C155*D155,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C156*D156,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C157*D157,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C158*D158,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C159*D159,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C160*D160,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C161*D161,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C162*D162,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C163*D163,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C164*D164,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C165*D165,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C166*D166,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C167*D167,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C168*D168,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C169*D169,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C170*D170,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C171*D171,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C172*D172,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C173*D173,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C174*D174,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C175*D175,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C176*D176,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C177*D177,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C178*D178,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C179*D179,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C180*D180,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C181*D181,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C182*D182,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C183*D183,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C184*D184,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C185*D185,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C186*D186,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C187*D187,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C188*D188,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C189*D189,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C190*D190,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C191*D191,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C192*D192,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C193*D193,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C194*D194,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C195*D195,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C196*D196,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C197*D197,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C198*D198,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C199*D199,0)","v":null}]
[{"$nulls":4},{"$f":"IFERROR(C200*D200,0)","v":null}]

{"sheet":"Pareto","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[0,0,0,7]]}
["Pareto des catégories (basé sur Fréquences de Ishikawa_Input)"]
[]
["Catégorie","Occurrences","Cumul","Cumul %"]
["Main d'œuvre",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Main d'œuvre\",Ishikawa_Input!C:C)","v":null},{"$f":"B4","v":null},{"$f":"IFERROR(C4/$B$10,0)","v":null}]
["Méthodes",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Méthodes\",Ishikawa_Input!C:C)","v":null},{"$f":"C4+B5","v":null},{"$f":"IFERROR(C5/$B$10,0)","v":null}]
["Machines",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Machines\",Ishikawa_Input!C:C)","v":null},{"$f":"C5+B6","v":null},{"$f":"IFERROR(C6/$B$10,0)","v":null}]
["Matières",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Matières\",Ishikawa_Input!C:C)","v":null},{"$f":"C6+B7","v":null},{"$f":"IFERROR(C7/$B$10,0)","v":null}]
["Milieu",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Milieu\",Ishikawa_Input!C:C)","v":null},{"$f":"C7+B8","v":null},{"$f":"IFERROR(C8/$B$10,0)","v":null}]
["Mesures",{"$f":"SUMIF(Ishikawa_Input!A:A,\"Mesures\",Ishikawa_Input!C:C)","v":null},{"$f":"C8+B9","v":null},{"$f":"IFERROR(C9/$B$10,0)","v":null}]
["Total",{"$f":"SUM(B4:B9)","v":null}]

{"sheet":"Fishbone_View","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"merged":[[1,1,1,8],[3,4,3,6]]}
[]
[null,"Diagramme d’Ishikawa (vue visuelle)"]
[]
[null,"Conseil: Renseignez vos causes dans Ishikawa_Input. Copiez les causes clés sous chaque branche ci-dessous.",null,null,"Effet / Problème"]
[]
[null,"Main d'œuvre"]
[]
[]
[]
[null,"Méthodes"]
[]
[]
[]
[null,"Machines"]
[]
[]
[]
[null,"Matières"]
[]
[]
[]
[null,"Milieu"]
[]
[]
[]
[null,"Mesures"]

{"sheet":"Guide","index":3,"n_rows":9,"n_cols":2,"rows_kept":9}
["Mode d’emploi - Modèle Ishikawa automatisé"]
[]
["1) Saisir les causes","Dans la feuille Ishikawa_Input, sélectionnez la Catégorie (6M), tapez la Cause, et renseignez Fréquence & Impact (1-5)."]
[]
["2) Suivre les KPI","Les indicateurs % par statut et le score moyen se calculent automatiquement (zone KPI à droite)."]
[]
["3) Prioriser avec Pareto","La feuille Pareto agrège automatiquement les Fréquences par catégorie et met à jour le graphique."]
[]
["4) Construire la vue visuelle","Utilisez la feuille Fishbone_View pour disposer vos causes clés sous chaque branche (couper/coller depuis Ishikawa_Input)."]