{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["filtre","LISTE","FACTURE","1271"],"not_rendered":{"charts":0,"images":1,"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":"filtre","index":0,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CLIENT","FACTURE ","DATE","MONTANT ","PAYÉ","SOLDE"]
[null,null,null,null,null,null,{"$f":"\">0.01\"","v":">0.01"}]

{"sheet":"LISTE","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["LISTE DES COMPTES À RECEVOIR",null,null,null,"TOTAL:",{"$f":"SUM(F5:F9994)","v":374.875}]
[]
[]
["CLIENT","FACTURE ","DATE","MONTANT ","PAYÉ","SOLDE"]
["aaa",1271,"2017-01-01",{"$f":"INDIRECT(\"'\" & B5 & \"'!C49\")","v":574.875},{"$f":"INDIRECT(\"'\" & B5 & \"'!C50\")","v":200},{"$f":"IF(D5>0,D5-E5,\"\")","v":374.875}]
[null,null,null,null,null,{"$f":"IF(D6>0,D6-E6,\"\")","v":""}]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(D13>0,D13-E13,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D14>0,D14-E14,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D15>0,D15-E15,\"\")","v":""}]

{"sheet":"FACTURE","index":2,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[38,0,38,1],[39,0,39,1],[33,0,33,1],[32,0,32,1],[36,0,36,1],[34,0,34,1],[35,0,35,1],[37,0,37,1],[44,0,44,1],[43,0,43,1],[42,0,42,1],[40,0,40,1],[41,0,41,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[31,0,31,1],[45,4,45,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[23,0,23,1],[24,0,24,1],[18,1,18,2],[30,0,30,1],[17,1,17,2],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[25,0,25,1]]}
[]
[null,null,"FACTURE"]
[]
[]
["RBQ: "]
[]
[null,"Numéro :",1272]
[]
[null,"Date :","2017-01-01"]
[]
[]
[]
["CLIENT","POUR :"]
[]
["bbb"]
[]
[]
[]
[]
["DESCRIPTION",null,"MONTANT"]
[]
[null,null,800]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," SOUS-TOTAL  ",{"$f":"SUM(C21:C45)","v":800},null,"PAIEMENTS REÇUS"]
[null,"TPS  ",{"$f":"+C46*0.05","v":40},null,"DATE","MONTANTS"]
[null,"TVQ  ",{"$f":"+C46*0.09975","v":79.800000000000011}]
[null,"TOTAL  ",{"$f":"SUM(C46:C48)","v":919.8}]
[null,"DÉPÔT  ",{"$f":"+F57","v":0}]
[null,"BALANCE  ",{"$f":"+C49-C50","v":919.8}]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F48:F56)","v":0}]

{"sheet":"1271","index":3,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[[23,0,23,1],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[35,0,35,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,4,45,5],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1]]}
[]
[null,null,"FACTURE"]
[]
[]
["RBQ: "]
[]
[null,"Numéro :",1271]
[]
[null,"Date :","2017-01-01"]
[]
[]
[]
["CLIENT","POUR :"]
[]
["aaa"]
[]
[]
[]
[]
["DESCRIPTION",null,"MONTANT"]
[]
[null,null,500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," SOUS-TOTAL  ",{"$f":"SUM(C21:C45)","v":500},null,"PAIEMENTS REÇUS"]
[null,"TPS  ",{"$f":"+C46*0.05","v":25},null,"DATE","MONTANTS"]
[null,"TVQ  ",{"$f":"+C46*0.09975","v":49.875},null,null,200]
[null,"TOTAL  ",{"$f":"SUM(C46:C48)","v":574.875}]
[null,"DÉPÔT  ",{"$f":"+F57","v":200}]
[null,"BALANCE  ",{"$f":"+C49-C50","v":374.875}]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",{"$f":"SUM(F48:F56)","v":200}]