{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["facture","mouvements_stock","stock"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"facture","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,0,6,3],[7,0,7,3],[1,4,1,7],[5,5,5,7],[6,5,6,7],[4,5,4,7],[7,5,7,7],[11,0,11,3],[9,0,9,4],[8,5,8,7],[8,0,8,3],[10,0,10,4],[12,0,12,4],[13,0,13,4]]}
[]
[]
[]
[]
[null,null,null,null,null,"DESTINATAIRE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DATE ","2020-01-20","N°FACTURE",null,"N°PLAQUE  "]
[]
["Code","QUANTITÉ","DESIGNATION",null,null,null,null,"PRIX H.T.V.A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Toute facture non réglée à 8 jours de sa date donne lieu de plein "]
[null,null,"droit à un intérêt de 18%.En cas de non paiement dans les huits jours"]
[null,null,"de l'envoi recommandé d'une sommation, elle sera majorée de 20%"]
[null,null,"à titre de dommages et intérêts (art.1137 et 1149 du code civil)"]
["     OUVERT DU LUNDI AU VENDREDI",null,null,null,null,"PRIX H.T.V.A",null,{"$f":"SUM(H20:H39)","v":0}]
["      DE 8 H00 A 12H00 ET DE 13H00 A 17H30",null,null,null,null,"REMISE"]
[null,null,null,null,null,"T.V.A.",null,{"$f":"H44*0.21","v":0}]
[null,null,null,null,null,"A PAYER",null,{"$f":"H44+H46","v":0}]

{"sheet":"mouvements_stock","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DATE","REF","ENTRÉES","SORTIES"]
["2020-01-02","1234JUD",4]
["2020-01-02","THER65",1]
["2020-01-02","AIR903",10]
["2020-01-02","JBOU",50]
["2020-01-02",3490145,1]
["2020-01-02","TEST",3]
["2020-01-02","PLAQ48",18]
["2020-02-04","JBOU",null,1]
["2020-01-20","PLAQ48",null,4]
["2020-01-20","AIR903",null,1]

{"sheet":"stock","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["références","description","quantité"]
["1234JUD","FILTRE A HUILE",{"$f":"SUMIF(mouvements_stock!B:B,stock!A2,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A2,mouvements_stock!D:D)","v":4}]
["THER65","SONDE LAMBDA",{"$f":"SUMIF(mouvements_stock!B:B,stock!A3,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A3,mouvements_stock!D:D)","v":1}]
["AIR903","FILTRE A AIR",{"$f":"SUMIF(mouvements_stock!B:B,stock!A4,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A4,mouvements_stock!D:D)","v":9}]
["JBOU","JOINT DE BOUCHON DE VIDANGE",{"$f":"SUMIF(mouvements_stock!B:B,stock!A5,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A5,mouvements_stock!D:D)","v":49}]
[3490145,"RETRO",{"$f":"SUMIF(mouvements_stock!B:B,stock!A6,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A6,mouvements_stock!D:D)","v":1}]
["TEST","TEST",{"$f":"SUMIF(mouvements_stock!B:B,stock!A7,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A7,mouvements_stock!D:D)","v":3}]
["PLAQ48","PLAQUETTES",{"$f":"SUMIF(mouvements_stock!B:B,stock!A8,mouvements_stock!C:C)-SUMIF(mouvements_stock!B:B,stock!A8,mouvements_stock!D:D)","v":14}]