{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Données","Synthèse","Liste"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"Données","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Clef unique","Catégories","Nom du client ou fournisseur","No Facture","Libellé","Institutions financières","Date d’opération","Etat","Montant"]
[1,null,null,null,"Solde","RBC Checking","2017-02-16","Payé",0]
[2,null,null,null,"Solde","RBC Visa","2017-02-16","Payé",-300]
[3,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-02-28","Connu",-1100]
[4,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-03-31","Connu",-1100]
[5,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-04-30","Connu",-1100]
[6,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-05-31","Connu",-1100]
[7,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-06-30","Connu",-1100]
[8,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-07-31","Connu",-1100]
[9,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-08-31","Connu",-1100]
[10,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-09-30","Connu",-1100]
[11,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-10-31","Connu",-1100]
[12,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-11-30","Connu",-1100]
[13,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2017-12-31","Connu",-1100]
[14,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2018-01-31","Connu",-1100]
[15,"D12-LOYER ET LOCATION DE SALLE","Anne",null,"Loyer","RBC Checking","2018-02-28","Connu",-1100]
[16,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-02-20","Connu",-150]
[17,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-03-20","Connu",-150]
[18,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-04-20","Connu",-150]
[19,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-05-20","Connu",-150]
[20,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-06-20","Connu",-150]
[21,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-07-20","Connu",-150]
[22,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-08-20","Connu",-150]
[23,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-09-20","Connu",-150]
[24,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-10-20","Connu",-150]
[25,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-11-20","Connu",-150]
[26,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2017-12-20","Connu",-150]
[27,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2018-01-20","Connu",-150]
[28,"D10-INTÉRÊT ET FRAIS BANCAIRES","RBC",null,"Prêt étudiant","RBC Checking","2018-02-20","Connu",-150]
[29,"E01-Encaissements Chèques","SDE",null,"Organisation d'un cocktail","RBC Checking","2017-02-25","Estimé",512]

{"sheet":"Synthèse","index":1,"n_rows":19,"n_cols":30,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Attention, ne pas oublier d'actualiser le tableau. Clic droit sur une cellule du tableau, et choisir Actualiser (Refresh)"]
[]
[]
["Institutions financières","RBC Checking"]
[]
[null,"Étiquettes de colonnes"]
["Étiquettes de lignes","2017-02-16","2017-02-20","2017-02-25","2017-02-28","2017-03-20","2017-03-31","2017-04-20","2017-04-30","2017-05-20","2017-05-31","2017-06-20","2017-06-30","2017-07-20","2017-07-31","2017-08-20","2017-08-31","2017-09-20","2017-09-30","2017-10-20","2017-10-31","2017-11-20","2017-11-30","2017-12-20","2017-12-31","2018-01-20","2018-01-31","2018-02-20","2018-02-28","Total général"]
["Somme de Montant"]
["D10-INTÉRÊT ET FRAIS BANCAIRES",null,-150,null,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-150,null,-1950]
["D12-LOYER ET LOCATION DE SALLE",null,null,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,null,-1100,-14300]
["E01-Encaissements Chèques",null,null,512,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,512]
["(vide)",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Somme de Montant2"]
["D10-INTÉRÊT ET FRAIS BANCAIRES",0,-150,-150,-150,-300,-300,-450,-450,-600,-600,-750,-750,-900,-900,-1050,-1050,-1200,-1200,-1350,-1350,-1500,-1500,-1650,-1650,-1800,-1800,-1950,-1950]
["D12-LOYER ET LOCATION DE SALLE",0,0,0,-1100,-1100,-2200,-2200,-3300,-3300,-4400,-4400,-5500,-5500,-6600,-6600,-7700,-7700,-8800,-8800,-9900,-9900,-11000,-11000,-12100,-12100,-13200,-13200,-14300]
["E01-Encaissements Chèques",0,0,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512,512]
["(vide)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total Somme de Montant",0,-150,512,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-150,-1100,-15738]
["Total Somme de Montant2",0,-150,362,-738,-888,-1988,-2138,-3238,-3388,-4488,-4638,-5738,-5888,-6988,-7138,-8238,-8388,-9488,-9638,-10738,-10888,-11988,-12138,-13238,-13388,-14488,-14638,-15738]

{"sheet":"Liste","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Catégories",null,"Banques",null,"Etat"]
["D01-AUTRES",null,"RBC Checking",null,"Estimé"]
["D02-CONTRATS DE SERVICES OU HONORAIRES",null,"RBC Visa",null,"Connu"]
["D03-DÉPLACEMENTS AUTO",null,null,null,"Payé"]
["D04-FOURNITURES ET PAPETERIE"]
["D05-FOURNITURES POUR REVENTE"]
["D06-FRAIS CRÉATION MARKETING"]
["D07-FRAIS DE CONGRÈS ET DE FORMATION"]
["D08-FRAIS DE REPRÉSENTATION (50%)"]
["D09-FRAIS PROMOTIONNELS"]
["D10-INTÉRÊT ET FRAIS BANCAIRES"]
["D11-LIVRES ET ABONNEMENT"]
["D12-LOYER ET LOCATION DE SALLE"]
["D13-POSTES +PORT+LIVRAISON"]
["D14-PUBLICITÉ (MARKETING)"]
["D15-RETRAITES"]
["D16-TAXES"]
["D17-TÉLÉPHONIE LOC EQUIP.& APPELS + INTERNET"]
["D18-VOYAGES"]
["E01-Encaissements Chèques"]
["E01-Encaissements Virements"]