{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Marchandises","Entrées","Sorties","Inventaire ","Analyse","Tableau De Bord"],"not_rendered":{"charts":19,"images":12,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":15},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Marchandises","index":0,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,2,2,4],[4,2,4,4],[3,2,3,4]]}
[]
[]
[null,null,"Nouvelle marchandise "]
[null,null,"Veuillez saisir les informations de chaque marchandise"]
[null,null,"Liste des marchandises :"]
[]
[null,null,"Référence","Désignation","Catégorie","Unité","Seuil d'alerte","Stock initial","Prix unitaire","Total"]
[null,null,"S2","IPHONE 13 PRO","SmartPhone","1 unité",10,3,1400,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":4200}]
[null,null,"C2","NINTENDO SWITCH","Consoles","1 unité",10,6,400,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":2400}]
[null,null,"C1","PLAYSTATION PS5 ","Consoles","1 unité",10,3,750,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":2250}]
[null,null,"E4","Cuisinière CANDY","Electro","1 unité",10,0,0,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":0}]
[null,null,"E3","Cuisinière SIERA","Electro","1 unité",10,6,150,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":900}]
[null,null,"E2","Réfrigérateur SIERA","Electro","1 unité",10,3,300,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":900}]
[null,null,"E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",10,5,700,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":3500}]
[null,null,"S1","GOOGLE PIXEL 5","SmartPhone","1 unité",10,20,600,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":12000}]
[null,null,"B1","Oreo","Biscuits ","1 unité ",10,10,0.2,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":2}]
[null,null,"B2","Oreo","Biscuits ","Pack de 10 unités",50,15,2,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":30}]
[null,null,"B3","Oreo","Biscuits ","Pack de 20 unités",20,5,4,{"$f":"listeProduits[[#This Row],[Stock initial]]*listeProduits[[#This Row],[Prix unitaire]]","v":20}]

{"sheet":"Entrées","index":1,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,2,2,10],[3,2,3,9]]}
[]
[]
[null,null,"Liste des entrées :"]
[null,null,"Détails de toutes les transactions d'entrée"]
[]
[null,null,"Veuillez saisir les informations d'achats"]
[]
[null,null,"Numéro","Date","Référence","Désignation","Catégorie","Unité","Coût d'achat","Quantité","Total"]
[null,null,{"$f":"C10+1","v":54},"2022-05-17","B2","Oreo","Biscuits ","Pack de 10 unités",2,25,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":50}]
[null,null,{"$f":"C11+1","v":53},"2022-05-17","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3500}]
[null,null,{"$f":"C12+1","v":52},"2022-05-05","E4","Cuisinière CANDY","Electro","1 unité",500,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":5000}]
[null,null,51,"2022-04-05","E4","Cuisinière CANDY","Electro","1 unité",500,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":5000}]
[null,null,50,"2022-03-03","E4","Cuisinière CANDY","Electro","1 unité",500,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":5000}]
[null,null,49,"2022-02-03","E4","Cuisinière CANDY","Electro","1 unité",500,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":5000}]
[null,null,48,"2022-01-20","E4","Cuisinière CANDY","Electro","1 unité",500,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":10000}]
[null,null,47,"2022-05-04","E3","Cuisinière SIERA","Electro","1 unité",150,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":750}]
[null,null,46,"2022-04-04","E3","Cuisinière SIERA","Electro","1 unité",150,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1500}]
[null,null,45,"2022-03-03","E3","Cuisinière SIERA","Electro","1 unité",150,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3000}]
[null,null,44,"2022-02-02","E3","Cuisinière SIERA","Electro","1 unité",150,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1500}]
[null,null,43,"2022-01-01","E3","Cuisinière SIERA","Electro","1 unité",150,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3000}]
[null,null,42,"2022-05-09","E2","Réfrigérateur SIERA","Electro","1 unité",300,4,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1200}]
[null,null,41,"2022-04-04","E2","Réfrigérateur SIERA","Electro","1 unité",300,4,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1200}]
[null,null,40,"2022-03-06","E2","Réfrigérateur SIERA","Electro","1 unité",300,2,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":600}]
[null,null,39,"2022-02-15","E2","Réfrigérateur SIERA","Electro","1 unité",300,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3000}]
[null,null,38,"2022-01-16","E2","Réfrigérateur SIERA","Electro","1 unité",300,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":6000}]
[null,null,37,"2022-05-06","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,6,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":4200}]
[null,null,36,"2022-04-06","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,2,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1400}]
[null,null,35,"2022-03-03","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,4,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2800}]
[null,null,34,"2022-02-03","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,3,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2100}]
[null,null,33,"2022-01-22","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",700,4,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2800}]
[null,null,32,"2022-05-22","C2","NINTENDO SWITCH","Consoles","1 unité",405,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2025}]
[null,null,31,"2022-04-05","C2","NINTENDO SWITCH","Consoles","1 unité",410,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":4100}]
[null,null,30,"2022-03-05","C2","NINTENDO SWITCH","Consoles","1 unité",420,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":4200}]
[null,null,29,"2022-02-10","C2","NINTENDO SWITCH","Consoles","1 unité",400,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":4000}]
[null,null,28,"2022-01-02","C2","NINTENDO SWITCH","Consoles","1 unité",400,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2000}]
[null,null,27,"2022-05-08","C1","PLAYSTATION PS5 ","Consoles","1 unité",760,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":15200}]
[null,null,26,"2022-04-05","C1","PLAYSTATION PS5 ","Consoles","1 unité",750,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3750}]
[null,null,25,"2022-03-03","C1","PLAYSTATION PS5 ","Consoles","1 unité",745,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":7450}]
[null,null,24,"2022-02-26","C1","PLAYSTATION PS5 ","Consoles","1 unité",750,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":7500}]
[null,null,23,"2022-01-02","C1","PLAYSTATION PS5 ","Consoles","1 unité",740,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3700}]
[null,null,22,"2022-05-02","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,30,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":42000}]
[null,null,21,"2022-04-25","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":28000}]
[null,null,{"$f":"C44+1","v":20},"2022-03-26","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":14000}]
[null,null,19,"2022-02-02","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,6,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":8400}]
[null,null,18,"2022-02-01","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,30,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":42000}]
[null,null,17,"2022-05-08","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",620,3,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1860}]
[null,null,16,"2022-04-05","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",600,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3000}]
[null,null,15,"2022-03-03","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",550,2,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1100}]
[null,null,14,"2022-02-05","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",600,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":3000}]
[null,null,13,"2022-01-20","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",600,40,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":24000}]
[null,null,12,"2022-05-08","B3","Oreo","Biscuits ","Pack de 20 unités",4,250,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1000}]
[null,null,11,"2022-04-25","B3","Oreo","Biscuits ","Pack de 20 unités",4,30,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":120}]
[null,null,10,"2022-03-20","B3","Oreo","Biscuits ","Pack de 20 unités",4,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":80}]
[null,null,9,"2022-02-05","B3","Oreo","Biscuits ","Pack de 20 unités",4,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":40}]
[null,null,8,"2022-05-05","B2","Oreo","Biscuits ","Pack de 10 unités",2,50,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":100}]
[null,null,7,"2022-04-05","B2","Oreo","Biscuits ","Pack de 10 unités",2,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":10}]
[null,null,6,"2022-03-02","B2","Oreo","Biscuits ","Pack de 10 unités",2,4,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":8}]
[null,null,5,"2022-02-25","B2","Oreo","Biscuits ","Pack de 10 unités",2,60,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":120}]
[null,null,4,"2022-05-05","B1","Oreo","Biscuits ","1 unité ",0.24,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2.4}]
[null,null,3,"2022-04-03","B1","Oreo","Biscuits ","1 unité ",0.23,5,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":1.1500000000000001}]
[null,null,2,"2022-03-20","B1","Oreo","Biscuits ","1 unité ",0.2,50,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":10}]
[null,null,1,"2022-02-02","B1","Oreo","Biscuits ","1 unité ",0.22,20,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":4.4000000000000004}]

{"sheet":"Sorties","index":2,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,2,2,10],[3,2,3,9]]}
[]
[]
[null,null,"Liste des sorties :"]
[null,null,"Détails de toutes les transactions de sortie"]
[]
[null,null,"Veuillez saisir les informations de vente"]
[]
[null,null,"Numéro","Date","Référence","Désignation","Catégorie","Unité","Prix de vente","Quantité","Total"]
[null,null,{"$f":"C10+1","v":60},"2022-05-17","B2","Oreo","Biscuits ","Pack de 10 unités",2.5,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":25}]
[null,null,{"$f":"C11+1","v":59},"2022-05-17","E1","Réfrigérateur WHIRLPOOL","Electro","1 unité",800,3,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2400}]
[null,null,{"$f":"C12+1","v":58},"2022-04-19","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",650,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1300}]
[null,null,{"$f":"C13+1","v":57},"2022-04-11","B1","Oreo","Biscuits ","1 unité ",0.2,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4}]
[null,null,56,"2022-05-06","E4","Cuisinière CANDY","Electro","1 unité",600,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":6000}]
[null,null,55,"2022-04-04","E4","Cuisinière CANDY","Electro","1 unité",590,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":11800}]
[null,null,54,"2022-03-03","E4","Cuisinière CANDY","Electro","1 unité",580,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":11600}]
[null,null,53,"2022-02-06","E4","Cuisinière CANDY","Electro","1 unité",600,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":3000}]
[null,null,52,"2022-01-01","E4","Cuisinière CANDY","Electro","1 unité",600,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":3000}]
[null,null,51,"2022-05-05","E3","Cuisinière SIERA","Electro","1 unité",220,3,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":660}]
[null,null,50,"2022-04-04","E3","Cuisinière SIERA","Electro","1 unité",200,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1000}]
[null,null,49,"2022-03-05","E3","Cuisinière SIERA","Electro","1 unité",250,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2500}]
[null,null,48,"2022-02-05","E3","Cuisinière SIERA","Electro","1 unité",200,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1000}]
[null,null,47,"2022-01-01","E3","Cuisinière SIERA","Electro","1 unité",200,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1000}]
[null,null,46,"2022-05-04","E2","Réfrigérateur SIERA","Electro","1 unité",400,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":800}]
[null,null,45,"2022-04-04","E2","Réfrigérateur SIERA","Electro","1 unité",400,7,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2800}]
[null,null,44,"2022-03-04","E2","Réfrigérateur SIERA","Electro","1 unité",400,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2000}]
[null,null,43,"2022-02-20","E2","Réfrigérateur SIERA","Electro","1 unité",400,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2000}]
[null,null,42,"2022-01-02","E2","Réfrigérateur SIERA","Electro","1 unité",400,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":2000}]
[null,null,41,"2022-05-15","E1","Réfrigérateur WHIRLPOOL ","Electro","1 unité",800,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1600}]
[null,null,40,"2022-04-04","E1","Réfrigérateur WHIRLPOOL ","Electro","1 unité",800,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1600}]
[null,null,39,"2022-03-26","E1","Réfrigérateur WHIRLPOOL ","Electro","1 unité",800,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4800}]
[null,null,38,"2022-02-06","E1","Réfrigérateur WHIRLPOOL ","Electro","1 unité",800,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4800}]
[null,null,37,"2022-01-02","E1","Réfrigérateur WHIRLPOOL ","Electro","1 unité",800,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1600}]
[null,null,36,"2022-05-05","C2","NINTENDO SWITCH","Consoles","1 unité",550,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1100}]
[null,null,35,"2022-04-04","C2","NINTENDO SWITCH","Consoles","1 unité",550,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":5500}]
[null,null,34,"2022-03-05","C2","NINTENDO SWITCH","Consoles","1 unité",520,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":3120}]
[null,null,33,"2022-02-09","C2","NINTENDO SWITCH","Consoles","1 unité",600,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":12000}]
[null,null,32,"2022-01-06","C2","NINTENDO SWITCH","Consoles","1 unité",550,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":3300}]
[null,null,31,"2022-05-03","C1","PLAYSTATION PS5 ","Consoles","1 unité",800,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":8000}]
[null,null,30,"2022-04-21","C1","PLAYSTATION PS5 ","Consoles","1 unité",800,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4000}]
[null,null,29,"2022-03-06","C1","PLAYSTATION PS5 ","Consoles","1 unité",820,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":8200}]
[null,null,28,"2022-02-05","C1","PLAYSTATION PS5 ","Consoles","1 unité",820,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4100}]
[null,null,27,"2022-01-02","C1","PLAYSTATION PS5 ","Consoles","1 unité",800,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":8000}]
[null,null,26,"2022-05-06","S2","IPHONE 13 PRO","SmartPhone","1 unité",1500,12,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":18000}]
[null,null,{"$f":"C45+1","v":25},"2022-04-04","S2","IPHONE 13 PRO","SmartPhone","1 unité",1500,30,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":45000}]
[null,null,24,"2022-03-06","S2","IPHONE 13 PRO","SmartPhone","1 unité",1500,15,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":22500}]
[null,null,23,"2022-02-02","S2","IPHONE 13 PRO","SmartPhone","1 unité",1500,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":30000}]
[null,null,22,"2022-01-02","S2","IPHONE 13 PRO","SmartPhone","1 unité",1400,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":14000}]
[null,null,21,"2022-05-06","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",720,23,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":16560}]
[null,null,20,"2022-04-09","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",680,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1360}]
[null,null,19,"2022-03-06","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",700,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":14000}]
[null,null,18,"2022-02-22","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",670,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":3350}]
[null,null,17,"2022-01-26","S1","GOOGLE PIXEL 5","SmartPhone","1 unité",680,8,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":5440}]
[null,null,16,"2022-04-22","B3","Oreo","Biscuits ","Pack de 20 unités",4.5999999999999996,60,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":276}]
[null,null,15,"2022-04-01","B3","Oreo","Biscuits ","Pack de 20 unités",5,60,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":300}]
[null,null,14,"2022-03-09","B3","Oreo","Biscuits ","Pack de 20 unités",5,60,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":300}]
[null,null,13,"2022-02-06","B3","Oreo","Biscuits ","Pack de 20 unités",5,12,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":60}]
[null,null,12,"2022-05-08","B2","Oreo","Biscuits ","Pack de 10 unités",3,10,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":30}]
[null,null,11,"2022-04-05","B2","Oreo","Biscuits ","Pack de 10 unités",2.7,15,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":40.5}]
[null,null,10,"2022-03-03","B2","Oreo","Biscuits ","Pack de 10 unités",2.6,15,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":39}]
[null,null,9,"2022-02-03","B2","Oreo","Biscuits ","Pack de 10 unités",2.5,2,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":5}]
[null,null,8,"2022-05-22","B1","Oreo","Biscuits ","1 unité ",0.3,4,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1.2}]
[null,null,7,"2022-04-04","B1","Oreo","Biscuits ","1 unité ",0.3,15,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4.5}]
[null,null,6,"2022-03-06","B1","Oreo","Biscuits ","1 unité ",0.3,20,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":6}]
[null,null,5,"2022-02-05","B1","Oreo","Biscuits ","1 unité ",0.3,15,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":4.5}]
[null,null,4,"2022-01-23","B2","Oreo","Biscuits ","Pack de 10 unités",3,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":18}]

{"sheet":"Inventaire ","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,7,2,8],[3,7,3,9],[2,2,3,3]]}
[]
[]
[null,null,"Détails d'inventaire"]
[]
[null,null,"Référence","Désignation","Catégorie","Unité","Seuil d'alerte","Stock initial","Entrées","Sorties","Stock final","CUMP","Valeur","Statue"]
[null,null,"S1",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"GOOGLE PIXEL 5"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"SmartPhone"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":20},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":55},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":60},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":15},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":599.4666666666667},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":8992},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"S2",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"IPHONE 13 PRO"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"SmartPhone"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":3},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":96},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":87},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":12},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":1400},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":16800},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"B1",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Oreo"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Biscuits "},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité "},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":10},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":85},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":74},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":21},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":0.21000000000000002},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":4.41},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"B2",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Oreo"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Biscuits "},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"Pack de 10 unités"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":50},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":15},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":144},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":58},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":101},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":2},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":202},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"B3",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Oreo"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Biscuits "},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"Pack de 20 unités"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":5},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":310},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":192},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":123},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":4},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":492},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"E1",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Réfrigérateur WHIRLPOOL"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Electro"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":5},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":24},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":21},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":8},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":700},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":5600},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock faible"}]
[null,null,"E2",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Réfrigérateur SIERA"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Electro"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":3},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":40},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":24},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":19},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":300},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":5700},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"E3",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Cuisinière SIERA"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Electro"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":6},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":65},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":28},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":43},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":150},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":6450},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"E4",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"Cuisinière CANDY"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Electro"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":0},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":60},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":60},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":0},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":500},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":0},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Non disponible"}]
[null,null,"C1",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"PLAYSTATION PS5 "},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Consoles"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":3},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":50},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":40},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":13},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":751.88679245283015},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":9774.5283018867922},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock normal"}]
[null,null,"C2",{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],2,FALSE),\"\")","v":"NINTENDO SWITCH"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],3,FALSE),\"\")","v":"Consoles"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],4,FALSE),\"\")","v":"1 unité"},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],5,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE),\"\")","v":6},{"$f":"SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])","v":40},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":44},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":2},{"$f":"IFERROR((VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],8,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Total]))/(VLOOKUP(listeInventaire[[#This Row],[Référence]],listeProduits[],6,FALSE)+SUMIF(listeAchats[Référence],listeInventaire[[#This Row],[Référence]],listeAchats[Quantité])),\"\")","v":407.06521739130437},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":814.13043478260875},{"$f":"IF(listeInventaire[[#This Row],[Stock final]]>listeInventaire[[#This Row],[Seuil d''alerte]],\"Stock normal\",IF(listeInventaire[[#This Row],[Stock final]]=0,\"Non disponible\",\"Stock faible\"))","v":"Stock faible"}]

{"sheet":"Analyse","index":4,"n_rows":139,"n_cols":102,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Qté Stock final","Valeur Stock final"]
[null,357,54829.068736669404]
[]
[]
[null,"Somme de Quantité","Somme de Total"]
[null,969,291380]
[]
[]
[]
[null,"Qté sortie","Valeur Qté Sortie"]
[null,688,297903.7]
[]
[]
[null,"Catégorie","Qté finale par Catégorie"]
[null,"Biscuits",245]
[null,"Consoles",15]
[null,"Electro",70]
[null,"SmartPhone",27]
[]
[]
[]
[]
[null,"Catégorie","Valeur finale par Catégorie"]
[null,"Biscuits",698.41]
[null,"Consoles",10588.6587366694]
[null,"Electro",17750]
[null,"SmartPhone",25792]
[]
[]
[]
[]
[]
[null,"Catégorie","Somme de Quantité"]
[null,"Biscuits",539]
[null,"Consoles",90,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LesMois",null,"Catégorie",null,"Référence"]
[null,"Electro",189,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"janv",null,"SmartPhone",null,"S2"]
[null,"SmartPhone",151,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"févr",null,"Consoles",null,"C2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mars",null,"Electro",null,"C1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avr",null,"Biscuits ",null,"E4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mai",null,null,null,"E3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E1"]
[null,"Catégorie","Somme de Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S1"]
[null,"Biscuits",1545,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B1"]
[null,"Consoles",53925,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B2"]
[null,"Electro",68550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B3"]
[null,"SmartPhone",167360]
[]
[]
[]
[]
[null,"Catégorie","Qté sortie par Catégorie"]
[null,"Biscuits",324]
[null,"Consoles",84]
[null,"Electro",133]
[null,"SmartPhone",147]
[]
[]
[]
[]
[]
[]
[null,"Catégorie","Valeur Qté Sortie par Catégorie"]
[null,"Biscuits",1113.7]
[null,"Consoles",57320]
[null,"Electro",67960]
[null,"SmartPhone",171510]
[]
[]
[]
[]
[]
[null,"Mois","Somme de Quantité"]
[null,"janv",114,null,{"$f":"B75","v":"janv"},{"$f":"_xlfn.XLOOKUP(E75,B75:B79,C75:C79,\"0\",0)","v":114},{"$f":"IF(F75=MAX($F$75:$F$79),F75,\"\")","v":""}]
[null,"févr",184,null,{"$f":"B76","v":"févr"},{"$f":"_xlfn.XLOOKUP(E76,B76:B80,C76:C80,\"0\",0)","v":184},{"$f":"IF(F76=MAX($F$75:$F$79),F76,\"\")","v":""}]
[null,"mars",142,null,"mars",142,""]
[null,"avr",106,null,"avr",106,""]
[null,"mai",423,null,"mai",423,423]
[]
[]
[]
[]
[]
[]
[null,"Mois","Somme de Quantité"]
[null,"janv",57,null,{"$f":"B87","v":"janv"},{"$f":"_xlfn.XLOOKUP(E87,B87:B91,C87:C91,\"\",0)","v":57},{"$f":"IF(F87=MAX($F$87:$F$91),F87,\"\")","v":""}]
[null,"févr",100,null,{"$f":"B88","v":"févr"},{"$f":"_xlfn.XLOOKUP(E88,B88:B92,C88:C92,\"\",0)","v":100},{"$f":"IF(F88=MAX($F$87:$F$91),F88,\"\")","v":""}]
[null,"mars",187,null,"mars",187,""]
[null,"avr",253,null,"avr",253,253]
[null,"mai",91,null,"mai",91,""]
[]
[]
[]
[]
[]
[]
[]
[null,"Mois","Somme de Total2","Somme de Total"]
[null,"janv",51500,51500,null,{"$f":"B100","v":"janv"},{"$f":"_xlfn.XLOOKUP(F100,$B$100:$B$104,$C$100:$C$104,\"\",0)","v":51500},{"$f":"_xlfn.XLOOKUP(F100,$B$100:$B$104,$D$100:$D$104,\"\",0)","v":51500}]
[null,"févr",76664,76664,null,{"$f":"B101","v":"févr"},{"$f":"_xlfn.XLOOKUP(F101,$B$100:$B$104,$C$100:$C$104,\"\",0)","v":76664},{"$f":"_xlfn.XLOOKUP(F101,$B$100:$B$104,$D$100:$D$104,\"\",0)","v":76664}]
[null,"mars",38248,38248,null,"mars",{"$f":"_xlfn.XLOOKUP(F102,$B$100:$B$104,$C$100:$C$104,\"\",0)","v":38248},38248]
[null,"avr",48081,48081,null,"avr",48081,48081]
[null,"mai",76887,76887,null,"mai",76887,76887]
[]
[]
[]
[]
[]
[null,"Mois","Somme de Total","Somme de Total2"]
[null,"janv",38358,38358,null,{"$f":"B111","v":"janv"},{"$f":"_xlfn.XLOOKUP(F111,$B$111:$B$115,$C$111:$C$115,\"\",0)","v":38358},{"$f":"_xlfn.XLOOKUP(F111,$B$111:$B$115,$D$111:$D$115,\"\",0)","v":38358}]
[null,"févr",60319.5,60319.5,null,{"$f":"B112","v":"févr"},{"$f":"_xlfn.XLOOKUP(F112,$B$111:$B$115,$C$111:$C$115,\"\",0)","v":60319.5},{"$f":"_xlfn.XLOOKUP(F112,$B$111:$B$115,$D$111:$D$115,\"\",0)","v":60319.5}]
[null,"mars",69065,69065,null,"mars",69065,69065]
[null,"avr",74985,74985,null,"avr",74985,74985]
[null,"mai",55176.2,55176.2,null,"mai",55176.2,55176.2]
[]
[]
[]
[]
[]
[]
[null,"Désignations","Somme de Total"]
[null,"IPHONE 13 PRO",129500]
[null,"GOOGLE PIXEL 5",42010]
[null,"Cuisinière CANDY",35400]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Statue","(Plusieurs éléments)"]
[]
[null,"Désignations","Somme de Stock final"]
[null,"Cuisinière CANDY",0,null,{"$f":"IF(B137<>0,B137,\"Pas de marchandise\")","v":"Cuisinière CANDY"},{"$f":"_xlfn.XLOOKUP(E137,$B$137:$B$139,$C$137:$C$139,\"\",0)","v":0},{"$f":"IF(F137>0,\"Stock faible\",\"Non disponible\")","v":"Non disponible"}]
[null,"NINTENDO SWITCH",2,null,{"$f":"IF(B138<>0,B138,\"Pas de marchandise\")","v":"NINTENDO SWITCH"},{"$f":"_xlfn.XLOOKUP(E138,$B$137:$B$139,$C$137:$C$139,\"\",0)","v":2},{"$f":"IF(F138>0,\"Stock faible\",\"Non disponible\")","v":"Stock faible"}]
[null,"Réfrigérateur WHIRLPOOL",8,null,{"$f":"IF(B139<>0,B139,\"Pas de marchandise\")","v":"Réfrigérateur WHIRLPOOL"},{"$f":"_xlfn.XLOOKUP(E139,$B$137:$B$139,$C$137:$C$139,\"\",0)","v":8},"Stock faible"]

{"sheet":"Tableau De Bord","index":5,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dernière mise à Jour",null,"2026-08-01T17:17:00"]