{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["devis","pr calcul stock","stock","1","2","3","4","5","6","Feuil2","produits"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"devis","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"pr calcul stock","index":1,"n_rows":22,"n_cols":41,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"Produits"]
[null,{"$f":"OFFSET(produits!$B$5,,ROW()-5)","v":{"$error":"#REF!"}},{"$f":"OFFSET(produits!$B$5,,ROW()-5)","v":{"$error":"#REF!"}},{"$f":"produits!D5","v":0},{"$f":"produits!D6","v":0},{"$f":"produits!F5","v":0},{"$f":"produits!G5","v":0},{"$f":"produits!H5","v":0},{"$f":"produits!I5","v":0},{"$f":"produits!J5","v":0},{"$f":"produits!K5","v":0},{"$f":"produits!L5","v":0},{"$f":"produits!M5","v":0},{"$f":"produits!N5","v":0},{"$f":"produits!O5","v":0},{"$f":"produits!P5","v":0},{"$f":"produits!Q5","v":0},{"$f":"produits!R5","v":0},{"$f":"produits!S5","v":0},{"$f":"produits!T5","v":0},{"$f":"produits!U5","v":0},{"$f":"produits!V5","v":0},{"$f":"produits!W5","v":0},{"$f":"produits!X5","v":0},{"$f":"produits!Y5","v":0},{"$f":"produits!Z5","v":0},{"$f":"produits!AA5","v":0},{"$f":"produits!AB5","v":0},{"$f":"produits!AC5","v":0},{"$f":"produits!AD5","v":0},{"$f":"produits!AE5","v":0},{"$f":"produits!AF5","v":0},{"$f":"produits!AG5","v":0},{"$f":"produits!AH5","v":0},{"$f":"produits!AI5","v":0},{"$f":"produits!AJ5","v":0},{"$f":"produits!AK5","v":0},{"$f":"produits!AL5","v":0},{"$f":"produits!AM5","v":0},{"$f":"produits!AN5","v":0},{"$f":"produits!AO5","v":0}]
["stock initial",15,10,10,5,5,8,5]
[{"$f":"'[1]1'!B6","v":1},{"$f":"-'[1]1'!C15","v":-3},{"$f":"-'[1]1'!C16","v":-5}]
[{"$f":"'[1]2'!B6","v":2},{"$f":"-'[1]2'!C15","v":-10},{"$f":"-'[1]2'!C17","v":1},{"$f":"-'[1]2'!C16","v":-3}]
["achat du  5/1/16",5]
[3,-2,-3,-4]
[4,-2,-3,-4]
["dqfq",10,5]
[5,-2,-3]
[]
[]
[]
[]
[null,{"$f":"SUM(B3:B14)","v":11},{"$f":"SUM(C3:C14)","v":2},-1,5,5,8,5]
[]
[]
[]
[]
[]
[]
[null,null,null,"²"]

{"sheet":"stock","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"a","b","c","d","e","f","g"]
["stock"]

{"sheet":"1","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",1]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
[]
["A","Produit A",3]
["B","Produit B",5]

{"sheet":"2","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",{"$f":"'1'!B6+1","v":2}]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
[]
["A","Produit A",10]
["C","Prroduit C",3]
["B","Produit B",-1]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"²"]

{"sheet":"3","index":5,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",3]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
["A","Produit A",2]
["B","Prroduit C",3]
["C","Produit B",4]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"²"]

{"sheet":"4","index":6,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",4]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
["A","Produit A",2]
["B","Prroduit C",3]
["C","Produit B",4]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"²"]

{"sheet":"5","index":7,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",5]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
["A","Produit A",2]
["B","Prroduit C",3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"²"]

{"sheet":"6","index":8,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["facture",6]
[]
[]
[]
[]
[]
[]
["REF","DESIGNATION","QUANTITE","PRIX UNITAIRE","MONTANT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"²"]

{"sheet":"Feuil2","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Valider"]

{"sheet":"produits","index":10,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Référence","Désignation"]
[null,"a"]
[null,"b"]
[null,"c"]
[null,"d"]
[null,"e"]
[null,"f"]
[null,"g"]
[null,"h"]
[null,"i"]
[null,"j"]
[null,"k"]
[null,"l"]
[null,"m"]
[null,"n"]
[null,"o"]
[null,"p"]
[null,"q"]
[null,"r"]
[null,"s"]
[null,"t"]
[null,"u"]
[null,"v"]