{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dashboard","Opérations","Marchandises","Entrées","Sorties","Inventaire ","TCD"],"not_rendered":{"charts":11,"images":11,"macros":1,"external_links":0,"defined_names":8,"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":"Dashboard","index":0,"n_rows":1,"n_cols":23,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,20,0,21]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dernière mise à jour",null,"2025-02-25T14:48:21"]

{"sheet":"Opérations","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,6,3,8]]}
[]
[]
[null,null,null,null,null,null,"Nouvelle opération"]
[null,null,null,null,null,null,"Veuillez saisir les détaille de l'opération de vente ou d'achat"]
[]
[null,null,null,null,null,null,"Référence  ",null,"Date"]
[]
[]
[null,null,null,null,null,null,"Désignation ",null,"Prix unitaire"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G7,listeProduits[],2,FALSE),\"\")","v":""},null,0]
[]
[null,null,null,null,null,null,"Catégorie ",null,"Quantité "]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G7,listeProduits[],3,FALSE),\"\")","v":""}]
[]
[null,null,null,null,null,null,"Unité",null,"Total"]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(G7,listeProduits[],4,FALSE),\"\")","v":""},null,{"$f":"I10*I13","v":0}]

{"sheet":"Marchandises","index":2,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,2,2,4],[3,2,3,3],[11,2,11,4]]}
[]
[]
[null,null,"Nouvelle marchandise "]
[null,null,"Veuillez saisir les informations de chaque marchandise"]
[]
[null,null,"Référence",null," Seuil d'alerte",0]
[null,null,"Désignation",null," Stock initial",0]
[null,null,"Catégorie",null," Prix unitaire",0]
[null,null,"Unité ",null," Total",{"$f":"F7*F8","v":0}]
[]
[]
[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":3,"n_rows":63,"n_cols":11,"rows_kept":63,"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,"Numéro","Date","Référence","Désignation","Catégorie","Unité","Coût d'achat","Quantité","Total"]
[null,null,{"$f":"C8+1","v":57},"2022-05-17","B2","Oreo","Biscuits ","Pack de 10 unités",2500,25,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":62500}]
[null,null,{"$f":"C9+1","v":56},"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":"C10+1","v":55},"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,54,"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,53,"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,52,"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,51,"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,50,"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,49,"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,48,"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,47,"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,46,"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,45,"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,44,"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,43,"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,42,"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,41,"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,40,"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,39,"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,38,"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,37,"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,36,"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,35,"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,34,"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,33,"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,32,"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,31,"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,30,"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,29,"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,28,"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,27,"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,26,"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,25,"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,24,"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":"C42+1","v":23},"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,22,"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,21,"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,20,"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,19,"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,18,"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,17,"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,16,"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,15,"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,14,"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,13,"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,12,"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,11,"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,10,"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,9,"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,8,"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,7,"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,6,"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,5,"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,4,"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}]
[null,null,3,"2022-01-25","B1","Oreo","Biscuits ","1 unité ",0.2,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":2}]
[null,null,2,"2022-01-05","B2","Oreo","Biscuits ","Pack de 10 unités",2,3,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":6}]
[null,null,1,"2022-01-02","B3","Oreo","Biscuits ","Pack de 20 unités",4,10,{"$f":"listeAchats[[#This Row],[Coût d''achat]]*listeAchats[[#This Row],[Quantité]]","v":40}]

{"sheet":"Sorties","index":4,"n_rows":66,"n_cols":11,"rows_kept":66,"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,"Numéro","Date","Référence","Désignation","Catégorie","Unité","Prix de vente","Quantité","Total"]
[null,null,{"$f":"C8+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":"C9+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":"C10+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":"C11+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":"C43+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}]
[null,null,3,"2022-01-21","B1","Oreo","Biscuits ","1 unité ",0.3,5,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":1.5}]
[null,null,2,"2022-01-17","B2","Oreo","Biscuits ","Pack de 10 unités",2.2000000000000002,6,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":13.200000000000001}]
[null,null,1,"2022-01-10","B3","Oreo","Biscuits ","Pack de 20 unités",4.2,3,{"$f":"listeVentes[[#This Row],[Prix de vente]]*listeVentes[[#This Row],[Quantité]]","v":12.600000000000001}]

{"sheet":"Inventaire ","index":5,"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":95},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":79},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":26},{"$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.20904761904761907},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":5.4352380952380956},{"$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":147},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":64},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":98},{"$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":387.49382716049382},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock final]]*listeInventaire[[#This Row],[CUMP]],\"\")","v":37974.395061728392},{"$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":320},{"$f":"SUMIF(listeVentes[Référence],listeInventaire[[#This Row],[Référence]],listeVentes[Quantité])","v":195},{"$f":"IFERROR(listeInventaire[[#This Row],[Stock initial]]+listeInventaire[[#This Row],[Entrées]]-listeInventaire[[#This Row],[Sorties]],\"\")","v":130},{"$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":520},{"$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":"TCD","index":6,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Somme de Stock final","Somme de Valeur",null,null,null,null,"Catégorie",null,"Références",null,"Mois"]
[366,92630.489036493032,null,null,null,null,"Biscuits ",null,"B2",null,"Janvier"]
[null,null,null,null,null,null,"Electro",null,"E1",null,"Février"]
[null,null,null,null,null,null,"Consoles",null,"E4",null,"Mars"]
[null,null,null,null,null,null,"SmartPhone",null,"E3",null,"Avril"]
[null,null,null,null,null,null,null,null,"E2",null,"Mai"]
["Somme de Quantité","Somme de Total",null,null,null,null,null,null,"C2",null,"Juin"]
[992,353878.95000000007,null,null,null,null,null,null,"C1"]
[null,null,null,null,null,null,null,null,"S2"]
[null,null,null,null,null,null,null,null,"S1"]
[null,null,null,null,null,null,null,null,"B3"]
[null,null,null,null,null,null,null,null,"B1"]
["Somme de Quantité","Somme de Total"]
[702,297931]
[]
[]
["Étiquettes de lignes","Somme de Quantité"]
["Biscuits",562]
["Consoles",90]
["Electro",189]
["SmartPhone",151]
["Total général",992]
[]
["Étiquettes de lignes","Somme de Total"]
["Biscuits",64043.950000000004]
["Consoles",53925]
["Electro",68550]
["SmartPhone",167360]
["Total général",353878.95000000007]
[]
[]
[]
["Étiquettes de lignes","Somme de Total"]
["Biscuits",1141]
["Consoles",57320]
["Electro",67960]
["SmartPhone",171510]
["Total général",297931]
[]
["Étiquettes de lignes","Somme de Valeur"]
["Biscuits ",38499.830299823632]
["Consoles",10588.6587366694]
["Electro",17750]
["SmartPhone",25792]
["Total général",92630.489036493032]
[]
[]
["Étiquettes de lignes","Somme de Stock final"]
["Biscuits ",254]
["Consoles",15]
["Electro",70]
["SmartPhone",27]
["Total général",366]
[]
[]
["Étiquettes de lignes","Somme de Quantité"]
["Biscuits",338]
["Consoles",84]
["Electro",133]
["SmartPhone",147]
["Total général",702]
[]
[]
[]
["Étiquettes de lignes","Somme de Quantité",null,null,null,null,"Max"]
["janv",137,null,null,{"$f":"A66","v":"janv"},{"$f":"VLOOKUP(E66,$A$66:$C$70,2,FALSE)","v":137},{"$f":"IF(F66=MAX($F$66:$F$70),F66,\"\")","v":""}]
["févr",184,null,null,{"$f":"A67","v":"févr"},{"$f":"VLOOKUP(E67,$A$66:$C$70,2,FALSE)","v":184},{"$f":"IF(F67=MAX($F$66:$F$70),F67,\"\")","v":""}]
["mars",142,null,null,"mars",142,""]
["avr",106,null,null,"avr",106,""]
["mai",423,null,null,"mai",423,423]
["Total général",992]
[]
["Étiquettes de lignes","Somme de Quantité",null,null,null,null,"Max"]
["janv",71,null,null,{"$f":"A74","v":"janv"},{"$f":"VLOOKUP(E74,$A$74:$B$78,2,FALSE)","v":71},{"$f":"IF(F74=MAX($F$74:$F$78),F74,\"\")","v":""}]
["févr",100,null,null,{"$f":"A75","v":"févr"},{"$f":"VLOOKUP(E75,$A$74:$B$78,2,FALSE)","v":100},{"$f":"IF(F75=MAX($F$74:$F$78),F75,\"\")","v":""}]
["mars",187,null,null,"mars",187,""]
["avr",253,null,null,"avr",253,253]
["mai",91,null,null,"mai",91,""]
["Total général",702]
[]
["Étiquettes de lignes","Somme de Total","Somme de Total2"]
["janv",51548,51548]
["févr",76664.399999999994,76664.399999999994]
["mars",38248,38248]
["avr",48081.15,48081.15]
["mai",139337.4,139337.4]
["Total général",353878.95000000007,353878.95000000007]
[]
[]
["Étiquettes de lignes","Somme de Total","Somme de Total2"]
["janv",38385.299999999996,38385.299999999996]
["févr",60319.5,60319.5]
["mars",69065,69065]
["avr",74985,74985]
["mai",55176.2,55176.2]
["Total général",297931,297931]
[]
[]
["Étiquettes de lignes","Somme de Total"]
["Cuisinière CANDY",35400]
["GOOGLE PIXEL 5",42010]
["IPHONE 13 PRO",129500]
["Total général",206910]
[]
[]
["Statue","(Plusieurs éléments)"]
[]
["Étiquettes de lignes","Somme de Stock final"]
["Cuisinière CANDY",0,null,{"$f":"A109","v":"Cuisinière CANDY"},{"$f":"VLOOKUP(D109,$A$109:$B$111,2,FALSE)","v":0},{"$f":"IF(E109=0,\"Non disponible\",\"Stock faible\")","v":"Non disponible"}]
["NINTENDO SWITCH",2,null,{"$f":"A110","v":"NINTENDO SWITCH"},{"$f":"VLOOKUP(D110,$A$109:$B$111,2,FALSE)","v":2},{"$f":"IF(E110=0,\"Non disponible\",\"Stock faible\")","v":"Stock faible"}]
["Réfrigérateur WHIRLPOOL",8,null,"Réfrigérateur WHIRLPOOL",8,"Stock faible"]
["Total général",10]