{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Suivi d'Inventaire"],"read":"whole","date_system":"1900"}

{"sheet":"Suivi d'Inventaire","index":0,"n_rows":16,"n_cols":10,"rows_kept":16,"merged":[[0,0,0,9],[1,0,1,9],[11,0,11,9]]}
["SYSTÈME DE GESTION D'INVENTAIRE"]
["Suivi en temps réel des niveaux de stock et de la valeur"]
[]
["Code Produit","Nom du Produit","Catégorie","Prix Unitaire (€)","Quantité Initiale","Seuil de Réapprovisionnement","Quantité Reçue","Quantité Vendue","Quantité Finale","Valeur Totale (€)"]
["P001","Imprimante Laser","Technologie",250,8,5,6,4,{"$f":"E5+G5-H5","v":null},{"$f":"I5*D5","v":null}]
["P002","Armoire Classement","Mobilier",180,10,3,5,7,{"$f":"E6+G6-H6","v":null},{"$f":"I6*D6","v":null}]
["P003","Chaise de Bureau","Mobilier",95,15,5,8,5,{"$f":"E7+G7-H7","v":null},{"$f":"I7*D7","v":null}]
["P004","Routeur","Réseau",120,12,6,4,9,{"$f":"E8+G8-H8","v":null},{"$f":"I8*D8","v":null}]
["P005","Destructeur","Outils de Bureau",60,6,4,3,2,{"$f":"E9+G9-H9","v":null},{"$f":"I9*D9","v":null}]
[]
[]
["Indicateurs de Performance (KPIs)"]
["Valeur Totale de l'Inventaire",{"$f":"SUM(J5:J9)","v":null}]
["Prix Unitaire Moyen",{"$f":"AVERAGE(D5:D9)","v":null}]
["Articles Vendus au Total",{"$f":"SUM(H5:H9)","v":null}]
["Articles sous Seuil",{"$f":"COUNTIF(I5:I9,\"<\"&F5)","v":null}]