{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ACCUEIL","Product_Master","Sale_Purchase","Sale_Purchase_Display","Inventory","Inventory_Display","Report"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"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":"ACCUEIL","index":0,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]

{"sheet":"Product_Master","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ID","Produit","Prix  Vente","Prix Achat"]
[{"$f":"ROW()-1","v":1},"jus",3000,2000]
[{"$f":"ROW()-1","v":2},"Sel",1500,1000]

{"sheet":"Sale_Purchase","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["S.No","Produit","Type","Quantité","Prix","Montant","Date","Bénéfice","Statut"]
[{"$f":"ROW()-1","v":1},"Sel","Achat",1000,1000,1000000,"02-janvier-2021","NA","Gérante"]
[{"$f":"ROW()-1","v":2},"jus","Achat",1000,2000,2000000,"02-janvier-2021","NA","Gérante"]
[{"$f":"ROW()-1","v":3},"jus","Vente",100,3000,300000,"02-janvier-2021",100000,"Gérante"]
[{"$f":"ROW()-1","v":4},"Sel","Vente",21,1500,31500,"02-janvier-2021",10500,"Gérante"]

{"sheet":"Sale_Purchase_Display","index":3,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["S.No","Produit","Type","Quantité","Prix","Montant","Date","Bénéfice","Statut"]

{"sheet":"Inventory","index":4,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Produit","Achat","Vente","Stock Disponible","Valeur Stock"]
["jus",1000,100,900,2700000]
["Sel",1000,21,979,1468500]

{"sheet":"Inventory_Display","index":5,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Produit","Achat","Vente","Stock Disponible","Valeur Stock"]
["jus",1000,100,900,2700000]
["Sel",1000,21,979,1468500]

{"sheet":"Report","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Début","19-mars-2021",null,"Gérante"]
[null,"Fin","19-mars-2021",null,"Vendeur"]
[]
[null,"Type","Montant"]
[null,"Achat",{"$f":"SUMIFS(Sale_Purchase!$F:$F,Sale_Purchase!$C:C,\"Report!B5\",Sale_Purchase!G:G,\">=\"&$C$1,Sale_Purchase!G:G,\"<=\"&$C$2)","v":0}]
[null,"Vente",{"$f":"SUMIFS(Sale_Purchase!$F:$F,Sale_Purchase!C:C,Report!$B$6,Sale_Purchase!$G:$G,\">=\"&$C$1,Sale_Purchase!$G:$G,\"<=\"&$C$2)","v":0}]
[null,"Bénéfices",{"$f":"SUMIFS(Sale_Purchase!H:H,Sale_Purchase!G:G,\">=\"&$C$1,Sale_Purchase!G:G,\"<=\"&$C$2)","v":0}]
[null,"Quantité",{"$f":"SUM(Inventory!D:D)","v":1879}]
[null,"Valeur Stock",{"$f":"SUM(Inventory!E:E)","v":4168500}]