{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Causes_Board","Summary_6M","Top10_Priorites","Fishbone_Canvas","Guide"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Causes_Board","index":0,"n_rows":300,"n_cols":15,"rows_kept":300,"merged":[[0,0,0,11]]}
["Ishikawa – Modèle Alternatif (Board 6M + RPN)"]
[{"$nulls":13},"KPI"]
["Catégorie (6M)","Cause","Fréquence","Gravité (1-5)","Détectabilité (1-5)","RPN","Responsable","Échéance","Statut","Coût estimé","Commentaires","Lien Preuve",null,"% Ouvertes",{"$f":"IFERROR(COUNTIF(I4:I300,\"Ouverte\")/COUNTA(I4:I300),0)","v":null}]
["Machines","Four mal calibré",12,5,4,null,"Durand",null,"En cours",{"v":5000,"d":"5,000"},"Recalibrage + capteurs","Lien CMMS",null,"% En cours",{"$f":"IFERROR(COUNTIF(I4:I300,\"En cours\")/COUNTA(I4:I300),0)","v":null}]
["Mesures","Sonde instable",4,4,3,null,"Martin",null,"Ouverte",{"v":1200,"d":"1,200"},"Remplacement planifié","Bon de commande #1234",null,"% Fermées",{"$f":"IFERROR(COUNTIF(I4:I300,\"Fermée\")/COUNTA(I4:I300),0)","v":null}]
["Méthodes","Procédure floue",3,3,3,null,"Leclerc",null,"Ouverte",0,"MAJ instruction de travail","Doc-PR-007",null,"RPN moyen",{"$f":"IFERROR(AVERAGEIF(F4:F300,\">0\",F4:F300),0)","v":null}]
["Main d'œuvre","Formation incomplète",5,4,2,null,"Dupont",null,"En cours",800,"Session Q3","HR-LMS"]
[{"$nulls":5},{"$f":"IFERROR(C8*D8*E8,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C9*D9*E9,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C10*D10*E10,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C11*D11*E11,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C12*D12*E12,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C13*D13*E13,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C14*D14*E14,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C15*D15*E15,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C16*D16*E16,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C17*D17*E17,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C18*D18*E18,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C19*D19*E19,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C20*D20*E20,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C21*D21*E21,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C22*D22*E22,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C23*D23*E23,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C24*D24*E24,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C25*D25*E25,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C26*D26*E26,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C27*D27*E27,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C28*D28*E28,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C29*D29*E29,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C30*D30*E30,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C31*D31*E31,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C32*D32*E32,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C33*D33*E33,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C34*D34*E34,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C35*D35*E35,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C36*D36*E36,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C37*D37*E37,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C38*D38*E38,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C39*D39*E39,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C40*D40*E40,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C41*D41*E41,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C42*D42*E42,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C43*D43*E43,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C44*D44*E44,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C45*D45*E45,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C46*D46*E46,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C47*D47*E47,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C48*D48*E48,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C49*D49*E49,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C50*D50*E50,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C51*D51*E51,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C52*D52*E52,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C53*D53*E53,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C54*D54*E54,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C55*D55*E55,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C56*D56*E56,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C57*D57*E57,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C58*D58*E58,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C59*D59*E59,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C60*D60*E60,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C61*D61*E61,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C62*D62*E62,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C63*D63*E63,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C64*D64*E64,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C65*D65*E65,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C66*D66*E66,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C67*D67*E67,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C68*D68*E68,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C69*D69*E69,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C70*D70*E70,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C71*D71*E71,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C72*D72*E72,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C73*D73*E73,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C74*D74*E74,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C75*D75*E75,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C76*D76*E76,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C77*D77*E77,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C78*D78*E78,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C79*D79*E79,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C80*D80*E80,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C81*D81*E81,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C82*D82*E82,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C83*D83*E83,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C84*D84*E84,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C85*D85*E85,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C86*D86*E86,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C87*D87*E87,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C88*D88*E88,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C89*D89*E89,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C90*D90*E90,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C91*D91*E91,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C92*D92*E92,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C93*D93*E93,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C94*D94*E94,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C95*D95*E95,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C96*D96*E96,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C97*D97*E97,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C98*D98*E98,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C99*D99*E99,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C100*D100*E100,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C101*D101*E101,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C102*D102*E102,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C103*D103*E103,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C104*D104*E104,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C105*D105*E105,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C106*D106*E106,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C107*D107*E107,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C108*D108*E108,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C109*D109*E109,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C110*D110*E110,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C111*D111*E111,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C112*D112*E112,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C113*D113*E113,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C114*D114*E114,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C115*D115*E115,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C116*D116*E116,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C117*D117*E117,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C118*D118*E118,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C119*D119*E119,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C120*D120*E120,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C121*D121*E121,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C122*D122*E122,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C123*D123*E123,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C124*D124*E124,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C125*D125*E125,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C126*D126*E126,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C127*D127*E127,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C128*D128*E128,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C129*D129*E129,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C130*D130*E130,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C131*D131*E131,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C132*D132*E132,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C133*D133*E133,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C134*D134*E134,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C135*D135*E135,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C136*D136*E136,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C137*D137*E137,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C138*D138*E138,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C139*D139*E139,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C140*D140*E140,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C141*D141*E141,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C142*D142*E142,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C143*D143*E143,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C144*D144*E144,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C145*D145*E145,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C146*D146*E146,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C147*D147*E147,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C148*D148*E148,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C149*D149*E149,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C150*D150*E150,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C151*D151*E151,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C152*D152*E152,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C153*D153*E153,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C154*D154*E154,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C155*D155*E155,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C156*D156*E156,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C157*D157*E157,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C158*D158*E158,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C159*D159*E159,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C160*D160*E160,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C161*D161*E161,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C162*D162*E162,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C163*D163*E163,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C164*D164*E164,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C165*D165*E165,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C166*D166*E166,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C167*D167*E167,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C168*D168*E168,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C169*D169*E169,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C170*D170*E170,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C171*D171*E171,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C172*D172*E172,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C173*D173*E173,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C174*D174*E174,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C175*D175*E175,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C176*D176*E176,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C177*D177*E177,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C178*D178*E178,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C179*D179*E179,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C180*D180*E180,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C181*D181*E181,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C182*D182*E182,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C183*D183*E183,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C184*D184*E184,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C185*D185*E185,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C186*D186*E186,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C187*D187*E187,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C188*D188*E188,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C189*D189*E189,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C190*D190*E190,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C191*D191*E191,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C192*D192*E192,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C193*D193*E193,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C194*D194*E194,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C195*D195*E195,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C196*D196*E196,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C197*D197*E197,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C198*D198*E198,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C199*D199*E199,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C200*D200*E200,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C201*D201*E201,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C202*D202*E202,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C203*D203*E203,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C204*D204*E204,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C205*D205*E205,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C206*D206*E206,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C207*D207*E207,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C208*D208*E208,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C209*D209*E209,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C210*D210*E210,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C211*D211*E211,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C212*D212*E212,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C213*D213*E213,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C214*D214*E214,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C215*D215*E215,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C216*D216*E216,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C217*D217*E217,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C218*D218*E218,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C219*D219*E219,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C220*D220*E220,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C221*D221*E221,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C222*D222*E222,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C223*D223*E223,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C224*D224*E224,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C225*D225*E225,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C226*D226*E226,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C227*D227*E227,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C228*D228*E228,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C229*D229*E229,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C230*D230*E230,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C231*D231*E231,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C232*D232*E232,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C233*D233*E233,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C234*D234*E234,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C235*D235*E235,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C236*D236*E236,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C237*D237*E237,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C238*D238*E238,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C239*D239*E239,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C240*D240*E240,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C241*D241*E241,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C242*D242*E242,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C243*D243*E243,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C244*D244*E244,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C245*D245*E245,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C246*D246*E246,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C247*D247*E247,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C248*D248*E248,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C249*D249*E249,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C250*D250*E250,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C251*D251*E251,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C252*D252*E252,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C253*D253*E253,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C254*D254*E254,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C255*D255*E255,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C256*D256*E256,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C257*D257*E257,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C258*D258*E258,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C259*D259*E259,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C260*D260*E260,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C261*D261*E261,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C262*D262*E262,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C263*D263*E263,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C264*D264*E264,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C265*D265*E265,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C266*D266*E266,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C267*D267*E267,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C268*D268*E268,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C269*D269*E269,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C270*D270*E270,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C271*D271*E271,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C272*D272*E272,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C273*D273*E273,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C274*D274*E274,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C275*D275*E275,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C276*D276*E276,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C277*D277*E277,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C278*D278*E278,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C279*D279*E279,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C280*D280*E280,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C281*D281*E281,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C282*D282*E282,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C283*D283*E283,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C284*D284*E284,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C285*D285*E285,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C286*D286*E286,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C287*D287*E287,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C288*D288*E288,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C289*D289*E289,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C290*D290*E290,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C291*D291*E291,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C292*D292*E292,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C293*D293*E293,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C294*D294*E294,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C295*D295*E295,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C296*D296*E296,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C297*D297*E297,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C298*D298*E298,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C299*D299*E299,0)","v":null}]
[{"$nulls":5},{"$f":"IFERROR(C300*D300*E300,0)","v":null}]

{"sheet":"Summary_6M","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,7]]}
["Synthèse 6M – Radar du Risque (Somme des RPN)"]
[]
["Catégorie","RPN total","Fréquence totale","Gravité moyenne","Détectabilité moyenne"]
["Main d'œuvre",{"$f":"SUMIF(Causes_Board!A:A,\"Main d'œuvre\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Main d'œuvre\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Main d'œuvre\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Main d'œuvre\"\",Causes_Board!E:E),0)","v":null}]
["Méthodes",{"$f":"SUMIF(Causes_Board!A:A,\"Méthodes\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Méthodes\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Méthodes\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Méthodes\"\",Causes_Board!E:E),0)","v":null}]
["Machines",{"$f":"SUMIF(Causes_Board!A:A,\"Machines\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Machines\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Machines\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Machines\"\",Causes_Board!E:E),0)","v":null}]
["Matières",{"$f":"SUMIF(Causes_Board!A:A,\"Matières\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Matières\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Matières\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Matières\"\",Causes_Board!E:E),0)","v":null}]
["Milieu",{"$f":"SUMIF(Causes_Board!A:A,\"Milieu\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Milieu\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Milieu\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Milieu\"\",Causes_Board!E:E),0)","v":null}]
["Mesures",{"$f":"SUMIF(Causes_Board!A:A,\"Mesures\",Causes_Board!F:F)","v":null},{"$f":"SUMIF(Causes_Board!A:A,\"Mesures\",Causes_Board!C:C)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Mesures\"\",Causes_Board!D:D),0)","v":null},{"$f":"IFERROR(AVERAGEIF(Causes_Board!A:A,\"\"Mesures\"\",Causes_Board!E:E),0)","v":null}]

{"sheet":"Top10_Priorites","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[0,0,0,5]]}
["Top 10 Priorités – Causes à traiter (RPN décroissant)"]
[]
["Rang","Cause","Catégorie","RPN","Responsable","Statut"]
[1,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D4,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D4,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,1),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D4,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D4,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[2,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D5,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D5,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,2),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D5,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D5,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[3,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D6,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D6,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,3),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D6,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D6,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[4,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D7,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D7,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,4),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D7,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D7,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[5,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D8,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D8,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,5),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D8,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D8,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[6,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D9,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D9,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,6),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D9,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D9,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[7,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D10,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D10,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,7),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D10,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D10,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[8,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D11,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D11,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,8),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D11,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D11,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[9,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D12,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D12,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,9),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D12,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D12,Causes_Board!F$4:F$300,0)),\"\")","v":null}]
[10,{"$f":"IFERROR(INDEX(Causes_Board!B$4:B$300,MATCH(D13,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!A$4:A$300,MATCH(D13,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(LARGE(Causes_Board!F$4:F$300,10),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!G$4:G$300,MATCH(D13,Causes_Board!F$4:F$300,0)),\"\")","v":null},{"$f":"IFERROR(INDEX(Causes_Board!I$4:I$300,MATCH(D13,Causes_Board!F$4:F$300,0)),\"\")","v":null}]

{"sheet":"Fishbone_Canvas","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,1,1,9],[5,7,7,9]]}
[]
[null,"Canvas Ishikawa – Conception Horizontale"]
[]
[null,"Indiquez le problème à droite. Listez 2–3 causes majeures par branche (copier depuis Top10_Priorites)."]
[]
[null,null,"Main d'œuvre","⇒",{"$nulls":3},"Problème / Effet"]
[]
[null,null,"Méthodes","⇒"]
[]
[null,null,"Machines","⇒"]
[]
[null,null,"Matières","⇒"]
[]
[null,null,"Milieu","⇒"]
[]
[null,null,"Mesures","⇒"]

{"sheet":"Guide","index":4,"n_rows":9,"n_cols":2,"rows_kept":9}
["Mode d’emploi – Conception alternative Ishikawa"]
[]
["1) Alimenter Causes_Board","Choisissez la catégorie 6M, renseignez Fréquence, Gravité, Détectabilité : le RPN est calculé."]
[]
["2) Analyser","Consultez Summary_6M (radar) et Top10_Priorites pour cibler les actions."]
[]
["3) Formaliser","Utilisez Fishbone_Canvas pour vos ateliers et revues."]
[]
["Conseil","Ajoutez des preuves/liens (CMMS, tickets, docs) pour tracer vos décisions."]