{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Par fournisseur"],"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":"Feuil1","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["Date","N° commande","titre!","Fournisseur","Montant H.T","TVA","Montant TTC","Date paiement","Type paiment"]
["2020-10-15","750700-1",null,"Google Store",65.83,13.17,{"$f":"E2+F2","v":79},"2020-11-30","CB"]
["2020-10-15","750700-2",null,"Google Store",58.33,11.66,69.989999999999995,"2020-11-30","CB"]
["2020-10-15","750700-3",null,"Google Store",37.5,7.5,45,null,"CB"]
["2020-10-19","FRAISJBO1020",null,"JBO",449.23,60.24,509.47,"2020-10-30","CB"]
["2020-10-20","N° 2020-10",null,"MGRP",5000,1000,6000,"2020-10-26","Virement"]
["2020-10-20","N°103643453",null,"Amazon",132.5,26.5,159,"2020-11-30","CB"]
["2020-10-21","N°909282",null,"Amazon",132.5,null,132.5,"2020-11-30","CB"]
["2020-10-22","N°4402",null,"Amazon",30.82,null,30.82]
[]
["Fournisseur","Date","N° commande","Débit","Crédit","Type paiement"]
["Amazon","2020-10-20","N°103643453",null,159]
["Amazon","2020-10-21","N°909282",null,132.5]
["Amazon","2020-10-22","N°4402",null,30.82]
["Amazon","2020-11-30","CB",159,null,"CB"]
["Amazon","2020-11-30","CB",132.5,null,"CB"]
[]
[]
["Total Amazon",null,null,{"$f":"SUM(D12:D18)","v":291.5},{"$f":"SUM(E12:E18)","v":322.32}]
[{"$f":"IF(E19>D19,\"Compte Créditeur\",IF(E19=D19,\"Compte Soldé\",\"Compte Débiteur\"))","v":"Compte Créditeur"},null,null,{"$f":"IF(D19>E19,D19-E19,\"\")","v":""},{"$f":"IF(E19>D19,E19-D19,\"\")","v":30.819999999999993}]
[]
["JBO","2020-10-19","FRAISJBO1020",null,509.47]
["JBO","2020-10-30","Virement",509.47,null,"Virement"]
[]
[]
["Total JBO",null,null,{"$f":"SUM(D22:D25)","v":509.47},{"$f":"SUM(E22:E25)","v":509.47}]
[{"$f":"IF(E26>D26,\"Compte Créditeur\",IF(E26=D26,\"Compte Soldé\",\"Compte Débiteur\"))","v":"Compte Soldé"},null,null,{"$f":"IF(D26>E26,D26-E26,\"\")","v":""},{"$f":"IF(E26>D26,E26-D26,\"\")","v":""}]
[]
["Google store","2020-10-15","750700-1",null,79]
["Google store","2020-10-15","750700-2",null,69.989999999999995]
["Google store","2020-10-15","750700-3",null,45]
["Google store","2020-11-30","CB",79]
["Google store","2020-11-30","CB",69.989999999999995]
[]
["Total Google Store",null,null,{"$f":"SUM(D29:D34)","v":148.99},{"$f":"SUM(E29:E34)","v":193.99}]
[{"$f":"IF(E35>D35,\"Compte Créditeur\",IF(E35=D35,\"Compte Soldé\",\"Compte Débiteur\"))","v":"Compte Créditeur"},null,null,{"$f":"IF(D35>E35,D35-E35,\"\")","v":""},{"$f":"IF(E35>D35,E35-D35,\"\")","v":45}]
[]
["MGRP","2020-10-20","N° 2020-10",null,5000]
["MGRP","2020-10-26","Virement",5000]
[]
["Total MGRP",null,null,{"$f":"SUM(D37:D40)","v":5000},{"$f":"SUM(E37:E40)","v":5000}]
[{"$f":"IF(E41>D41,\"Compte Créditeur\",IF(E41=D41,\"Compte Soldé\",\"Compte Débiteur\"))","v":"Compte Soldé"},null,null,{"$f":"IF(D41>E41,D41-E41,\"\")","v":""},{"$f":"IF(E41>D41,E41-D41,\"\")","v":""}]

{"sheet":"Par fournisseur","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}