{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Reception_Marchandises","Suivi_Stock","Non_Conformites","KPI_Logistique","Dashboard_Logistique","Références","Formulaire_Validation"],"not_rendered":{"charts":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Reception_Marchandises","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[0,0,0,6]]}
["📦 Suivi des Réceptions de Marchandises"]
["Date","Fournisseur","Produit"]
[{"$nulls":3},100,90,{"$f":"E3-D3","v":null},{"$f":"IF(ABS(F3)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,95,{"$f":"E4-D4","v":null},{"$f":"IF(ABS(F4)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,100,{"$f":"E5-D5","v":null},{"$f":"IF(ABS(F5)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,90,{"$f":"E6-D6","v":null},{"$f":"IF(ABS(F6)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,95,{"$f":"E7-D7","v":null},{"$f":"IF(ABS(F7)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,100,{"$f":"E8-D8","v":null},{"$f":"IF(ABS(F8)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,90,{"$f":"E9-D9","v":null},{"$f":"IF(ABS(F9)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,95,{"$f":"E10-D10","v":null},{"$f":"IF(ABS(F10)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,100,{"$f":"E11-D11","v":null},{"$f":"IF(ABS(F11)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
[{"$nulls":3},100,90,{"$f":"E12-D12","v":null},{"$f":"IF(ABS(F12)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]
{"$rows_empty":7}
[{"$nulls":3},100,95,{"$f":"E19-D19","v":null},{"$f":"IF(ABS(F19)<=5,\"✅ Conforme\",\"❌ Écart\")","v":null}]

{"sheet":"Suivi_Stock","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[0,0,0,5]]}
["📊 Suivi des Stocks Produits"]
["Produit","Stock Initial","Entrées"]
[null,50,null,23,13,{"$f":"B3+D3-E3","v":null},25]
[null,50,null,24,14,{"$f":"B4+D4-E4","v":null},25]
[null,50,null,25,10,{"$f":"B5+D5-E5","v":null},25]
[null,50,null,26,11,{"$f":"B6+D6-E6","v":null},25]
[null,50,null,27,12,{"$f":"B7+D7-E7","v":null},25]
[null,50,null,28,13,{"$f":"B8+D8-E8","v":null},25]
[null,50,null,29,14,{"$f":"B9+D9-E9","v":null},25]
[null,50,null,30,10,{"$f":"B10+D10-E10","v":null},25]
[null,50,null,31,11,{"$f":"B11+D11-E11","v":null},25]
[null,50,null,32,12,{"$f":"B12+D12-E12","v":null},25]

{"sheet":"Non_Conformites","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,0,0,5]]}
["🚨 Enregistrement des Non-Conformités"]
["Date","Produit","Type de Défaut","Gravité","Fournisseur","Action Corrective"]
["01/06/2025","Produit A","Casse","Élevée","Fournisseur X","Remplacement immédiat"]
["03/06/2025","Produit B","Erreur de quantité","Modérée","Fournisseur Y","Réclamation envoyée"]
["05/06/2025","Produit C","Mauvais étiquetage","Faible","Fournisseur Z","Stock isolé"]

{"sheet":"KPI_Logistique","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[0,0,0,3]]}
["📈 Indicateurs de Performance Logistique"]
["Indicateur","Valeur","Objectif","État"]
["Taux de conformité",{"$f":"COUNTIF(Reception_Marchandises!G2:G100,\"✅ Conforme\")/COUNTA(Reception_Marchandises!G2:G100)","v":null},"0.95",{"$f":"IF(B2>=C2,\"✅\",\"❌\")","v":null}]
["Nb non-conformités",{"$f":"COUNTA(Non_Conformites!A2:A100)","v":null},"10",{"$f":"IF(B3>=C3,\"✅\",\"❌\")","v":null}]
["Taux de livraison conforme (>95%)",{"$f":"COUNTIF(Reception_Marchandises!G3:G100,\"✅ Conforme\")/COUNTA(Reception_Marchandises!G3:G100)","v":null},"0.95",{"$f":"IF(B5>=C5,\"✅\",\"❌\")","v":null}]
["Taux de produits non conformes",{"$f":"COUNTIF(Reception_Marchandises!G3:G100,\"❌ Écart\")/COUNTA(Reception_Marchandises!G3:G100)","v":null},"<0.05",{"$f":"IF(B6<=C6,\"✅\",\"❌\")","v":null}]

{"sheet":"Dashboard_Logistique","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"merged":[[0,0,0,1]]}
["🧠 Tableau de Bord Logistique"]
["Indicateur","Valeur"]
["Taux de conformité",{"$f":"KPI_Logistique!B2","v":null}]
["Nb non-conformités",{"$f":"KPI_Logistique!B3","v":null}]
[]
["🔔 Alerte de conformité",{"$f":"IF(KPI_Logistique!D2=\"❌\",\"⚠️ Livraison non conforme\",\"✅ OK\")","v":null}]
["🔔 Alerte non-conformités",{"$f":"IF(KPI_Logistique!D3=\"❌\",\"🚨 Trop de non-conformités\",\"✅ OK\")","v":null}]

{"sheet":"Références","index":5,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[0,0,0,2]]}
["📁 Références Produits et Fournisseurs"]
["Produits","Fournisseurs","Types Défauts"]
["Produit A","Fournisseur X","Casse"]
["Produit B","Fournisseur Y","Erreur de quantité"]
["Produit C","Fournisseur Z","Mauvais étiquetage"]

{"sheet":"Formulaire_Validation","index":6,"n_rows":12,"n_cols":1,"rows_kept":12,"merged":[[0,0,0,1]]}
["📋 FORMULAIRE DE VALIDATION LOGISTIQUE"]
[]
["Date de validation"]
["Nom du responsable"]
["Service concerné"]
["Fournisseur validé"]
["Produit vérifié"]
["Quantité réceptionnée"]
["État visuel conforme"]
["Écart quantité acceptable"]
["Observations"]
["Signature responsable"]