{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Bilan","Bilan Entrées","Evolution de la valeur","Taux stock et appro","Journal","Liste Sorties","Liste Entrées"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Bilan","index":0,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,5],[3,0,3,5]]}
[null,null,"2 - Entrer les dates du bilan\n(jj/mm/aaaa)",null,null,null,null,null,null,"PS01-FO0020\nV1"]
[null,null,"Date début","2019-06-04","Date fin","2019-06-30"]
[]
["Total des Sortie"]
[]
["Référence","Famille","Désignation","Quantité Consommés","Prix unitaire","Coût Total",null,"Total",{"$f":"SUM(F7:F100000)","v":0}]

{"sheet":"Bilan Entrées","index":1,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Total des entrées"]
[]
["Référence","Famille","Désignation","Quantité Achetés","Prix unitaire","Coût Total",null,"Total",{"$f":"SUM(F4:F100000)","v":0}]

{"sheet":"Evolution de la valeur","index":2,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
["Date","Reference","Famille","Designation","Qté","Prix unitaire","Prix total","Valeur du stock"]
[null,"Valeur de départ du stock (optionnel)"]

{"sheet":"Taux stock et appro","index":3,"n_rows":3,"n_cols":335,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,15,0,17],[0,0,0,2],[0,3,0,5],[0,6,0,8],[0,9,0,11],[0,12,0,14]]}
["Produits",null,null,null,null,null,null,null,null,null,null,null,"Analyse du surstockage",null,null,"Analyse des achats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7622024]
["Reference","Famille","Designation","Qté inventaire","PUA","PTA","Qté consommée","PUA","PTA","Qté entrée","PUA","PTA","Conso/stock","Interprétation","Coût du surstockage","Conso/achats","Interprétation"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D3=0,G3=0),\"Ref non utilisée\",\nIF(D3=0,\"Rupture au moment de l'inventaire\",G3/D3))","v":"Ref non utilisée"},{"$f":"IF(ISTEXT(M3),M3,\nIF(M3=0,\"Stocké pas utilisé\",\nIF(M3<75%,\"Possible Surstock\",\nIF(M3<125%,\"Equilibré\",\"Bonne Conso\"))))","v":"Ref non utilisée"},{"$f":"IF(OR(N3=\"Possible Surstock\",N3=\"Stocké pas utilisé\"),F3-I3,\"-\")","v":"-"},{"$f":"IF(AND(G3=0,J3=0,D3=0),\"Ref non utilisée\",\nIF(AND(J3=0,G3=0),\"Stocké, pas de mouvement\",\nIF(J3=0,\"Consommé, pas renouvelé\",\nG3/J3)))","v":"Ref non utilisée"},{"$f":"IF(ISTEXT(P3),P3,\nIF(P3=0,\"Acheté, pas consommé\",\nIF(P3<75%,\"Possible Surachat\",\nIF(P3<125%,\"Equilibré\",\"Possible sous achat\"))))","v":"Ref non utilisée"},{"$f":"L3-I3","v":0}]

{"sheet":"Journal","index":4,"n_rows":1,"n_cols":18,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ID","Dates","Type","Commentaire","Famille","ID_prod","Reference","Designation","Fournisseur","Quantite","Mouvement","Mini","Emplacement","PUA","PTA","PUV","PTV","Utilisateur"]

{"sheet":"Liste Sorties","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Liste Entrées","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}