{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Operations","Expenses and revenues","Analysis by Category","expenses evolution by month and cat"],"not_rendered":{"charts":5,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Operations","index":0,"n_rows":47267,"n_cols":42,"rows_kept":47267,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Opérations","Ventilation","Date","Date de valeur","Chèques","P/R","Tiers","Crédit","Débit","Montant","Solde","Catégorie","Sous-catégories","Imputations budgétaires","Sous-imputations budgétaires","Remarques","Pièce comptable","N° de rapprochement","Infos banque/guichet","MONTH","ANNEE","ANNEE-MOIS"]
[16,null,"2007-10-04",null,2,null,"XXX",0,823.8,0,18537.54,"Santé","Dentiste",{"$nulls":6},10,2007,"2007-10"]
[17,null,"2007-10-04",null,3,null,"XXX",0,675,0,17862.54,"Enfants","Crèche / Nourrice",{"$nulls":6},10,2007,"2007-10"]
[18,null,"2007-10-04",null,null,null,"XXX",0,50,0,17812.54,"Logement","Electricité",{"$nulls":6},10,2007,"2007-10"]
[19,null,"2007-10-04",null,null,null,"XXX",0,16.09,0,17796.45,"Santé","Pharmacie",{"$nulls":6},10,2007,"2007-10"]
[20,null,"2007-10-04",null,null,null,"XXX",0,28.35,0,17768.1,"Santé","Laboratoire",{"$nulls":6},10,2007,"2007-10"]
[21,null,"2007-10-04",null,null,null,"XXX",0,3.95,0,17764.15,"Frais financiers","Frais bancaires",{"$nulls":6},10,2007,"2007-10"]
[22,null,"2007-10-04",null,null,null,"XXX",0,0.77,0,17763.38,"Frais financiers","Frais bancaires",{"$nulls":6},10,2007,"2007-10"]
[23,null,"2007-10-05",null,null,null,"XXX",0,16,0,17747.38,"Frais divers","Cadeaux",{"$nulls":6},10,2007,"2007-10"]
[24,null,"2007-10-05",null,null,null,"XXX",0,360.5,0,17386.88,"Vacances","Logement",{"$nulls":6},10,2007,"2007-10"]
[25,null,"2007-10-05",null,null,null,"XXX",4000,0,0,21386.88,"Revenus divers","Remboursement",{"$nulls":6},10,2007,"2007-10"]
[26,null,"2007-10-05",null,null,null,"XXX",0,242.83,0,21144.05,"Assurance","Automobile",{"$nulls":6},10,2007,"2007-10"]
[27,null,"2007-10-05",null,null,null,"XXX",0,15,0,21129.05,"Frais financiers","Frais bancaires",{"$nulls":6},10,2007,"2007-10"]
[28,null,"2007-10-05",null,null,null,"XXX",0,141,0,20988.05,"Logement","Gaz",{"$nulls":6},10,2007,"2007-10"]
[29,null,"2007-10-05",null,null,null,"XXX",0,1817.26,0,19170.79,"Frais financiers","Charges d'emprunts",{"$nulls":6},10,2007,"2007-10"]
[30,null,"2007-10-08",null,null,null,"XXX",0,62.4,0,19108.39,"Automobile","Carburant",{"$nulls":6},10,2007,"2007-10"]
[31,null,"2007-10-08",null,null,null,"XXX",0,132.52,0,18975.87,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[32,null,"2007-10-08",null,null,null,"XXX",0,304.73,0,18671.14,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[33,null,"2007-10-09",null,null,null,"XXX",4000,0,0,22671.14,"Revenus divers","Remboursement",{"$nulls":6},10,2007,"2007-10"]
[34,null,"2007-10-09",null,null,null,"XXX",30.68,0,0,22701.82,"Autres revenus","Mutuelle santé",{"$nulls":6},10,2007,"2007-10"]
[35,null,"2007-10-10",null,null,null,"XXX",0,100,0,22601.82,"Vacances","Voyages",{"$nulls":6},10,2007,"2007-10"]
[36,null,"2007-10-10",null,null,null,"XXX",1500,0,0,24101.82,"Revenus divers","Remboursement",{"$nulls":6},10,2007,"2007-10"]
[37,null,"2007-10-11",null,null,null,"XXX",0,33.6,0,24068.22,"Logement","ADSL",{"$nulls":6},10,2007,"2007-10"]
[38,null,"2007-10-11",null,null,null,"XXX",0,400,0,23668.22,"Automobile","Entretien",{"$nulls":6},10,2007,"2007-10"]
[39,null,"2007-10-12",null,null,null,"XXX",0,50,0,23618.22,"Alimentation","Cantine",{"$nulls":6},10,2007,"2007-10"]
[40,null,"2007-10-15","2007-10-15",null,null,"XXX",0,4.5,0,23613.72,{"$nulls":8},10,2007,"2007-10"]
[41,null,"2007-10-15",null,null,null,"XXX",0,15,0,23598.72,"Enfants","Frais divers",{"$nulls":6},10,2007,"2007-10"]
[42,null,"2007-10-15",null,null,null,"XXX",0,49,0,23549.72,"Alimentation","Restaurant",{"$nulls":6},10,2007,"2007-10"]
[43,null,"2007-10-15",null,null,null,"XXX",0,106.52,0,23443.2,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[44,null,"2007-10-15",null,null,null,"XXX",2500,0,0,25943.2,"Revenus divers","Remboursement",{"$nulls":6},10,2007,"2007-10"]
[45,null,"2007-10-16",null,null,null,"XXX",0,16.67,0,25926.53,"Santé","Pharmacie",{"$nulls":6},10,2007,"2007-10"]
[46,null,"2007-10-16","2007-10-16",null,null,"XXX",0,112.4,0,25814.13,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[47,null,"2007-10-18",null,null,null,"XXX",0,69.59,0,25744.54,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[48,null,"2007-10-19",null,4,null,"XXX",0,36,0,25708.54,"Santé","Médecin",{"$nulls":6},10,2007,"2007-10"]
[49,null,"2007-10-19",null,null,null,"XXX",0,55.32,0,25653.22,"Automobile","Carburant",{"$nulls":6},10,2007,"2007-10"]
[50,null,"2007-10-19",null,null,null,"XXX",0,580,0,25073.22,"Impôts","Impôts locaux",{"$nulls":6},10,2007,"2007-10"]
[51,null,"2007-10-22",null,11,null,"XXX",0,185.47,0,24887.75,"Logement",{"$nulls":7},10,2007,"2007-10"]
[52,null,"2007-10-22",null,null,null,"XXX",2000,0,0,26887.75,"Revenus divers","Remboursement",{"$nulls":6},10,2007,"2007-10"]
[53,null,"2007-10-22",null,null,null,"XXX",0,113,0,26774.75,"Soins","Coiffeur",{"$nulls":6},10,2007,"2007-10"]
[54,null,"2007-10-26",null,5,null,"XXX",0,45,0,26729.75,"Automobile","Amendes",{"$nulls":6},10,2007,"2007-10"]
[55,null,"2007-10-29",null,12,null,"XXX",0,675,0,26054.75,"Enfants","Crèche / Nourrice",{"$nulls":6},10,2007,"2007-10"]
[56,null,"2007-10-29",null,null,null,"XXX",3000,0,0,30311.3,"Salaire","Salaire net",{"$nulls":6},10,2007,"2007-10"]
[57,null,"2007-10-29",null,null,null,"XXX",3000,0,0,32765.65,"Salaire","Salaire net",{"$nulls":6},10,2007,"2007-10"]
[58,null,"2007-10-29",null,null,null,"XXX",0,30,0,32735.65,"Divers",{"$nulls":7},10,2007,"2007-10"]
[59,null,"2007-10-29",null,null,null,"XXX",0,48.8,0,32686.85,"Alimentation","Restaurant",{"$nulls":6},10,2007,"2007-10"]
[60,null,"2007-10-29",null,null,null,"XXX",0,72.36,0,32614.49,"Alimentation","Supermarché",{"$nulls":6},10,2007,"2007-10"]
[61,null,"2007-10-29",null,null,null,"XXX",0,126.09,0,32488.4,"Santé","Pharmacie",{"$nulls":6},10,2007,"2007-10"]
[62,null,"2007-10-30",null,6,null,"XXX",0,216.14,0,32272.26,"Enfants","cantine/garderie",{"$nulls":6},10,2007,"2007-10"]
[63,null,"2007-10-30",null,null,null,"XXX",33.83,0,0,32306.09,"Autres revenus","Mutuelle santé",{"$nulls":6},10,2007,"2007-10"]
[65,null,"2007-10-31",null,7,null,"XXX",0,530,0,7776.09,"Impôts","Impôts locaux",{"$nulls":6},10,2007,"2007-10"]
[66,null,"2007-10-31",null,8,null,"XXX",0,11,0,7765.09,"Automobile","Réparation",{"$nulls":6},10,2007,"2007-10"]
[67,null,"2007-10-31",null,null,null,"XXX",0,61.2,0,7703.89,"Frais professionnels",{"$nulls":7},10,2007,"2007-10"]
[68,null,"2007-11-02",null,null,null,"XXX",0,6.48,0,7697.41,"Divers",{"$nulls":7},11,2007,"2007-11"]
[69,null,"2007-11-02",null,null,null,"XXX",0,13.45,0,7683.96,"Santé","Pharmacie",{"$nulls":6},11,2007,"2007-11"]
[70,null,"2007-11-02",null,null,null,"XXX",0,29.25,0,7654.71,"Frais divers","Cadeaux",{"$nulls":6},11,2007,"2007-11"]
[71,null,"2007-11-02",null,null,null,"XXX",0,13.29,0,7641.42,"Alimentation","Supermarché",{"$nulls":6},11,2007,"2007-11",{"$nulls":18},11,2007]
[72,null,"2007-11-05",null,null,null,"XXX",0,15,0,7626.42,"Frais financiers","Frais bancaires",{"$nulls":6},11,2007,"2007-11"]
[73,null,"2007-11-05",null,null,null,"XXX",0,50,0,7576.42,"Logement","Electricité",{"$nulls":6},11,2007,"2007-11"]
[74,null,"2007-11-05",null,null,null,"XXX",0,242.83,0,7333.59,"Assurance","Automobile",{"$nulls":6},11,2007,"2007-11"]
[75,null,"2007-11-05",null,null,null,"XXX",0,141,0,7192.59,"Logement","Gaz",{"$nulls":6},11,2007,"2007-11",{"$nulls":18},11,2007]
[76,null,"2007-11-05",null,null,null,"XXX",0,1720.32,0,5472.27,"Frais financiers","Charges d'emprunts",{"$nulls":6},11,2007,"2007-11"]
[77,null,"2007-11-06",null,null,null,"XXX",0,15,0,5457.27,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[78,null,"2007-11-06",null,null,null,"XXX",0,18.11,0,5439.16,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[79,null,"2007-11-06",null,null,null,"XXX",0,27.9,0,5411.26,"Alimentation","Restaurant",{"$nulls":6},11,2007,"2007-11"]
[80,null,"2007-11-06",null,null,null,"XXX",0,48.27,0,5362.99,"Automobile","Carburant",{"$nulls":6},11,2007,"2007-11"]
[81,null,"2007-11-06",null,null,null,"XXX",0,49.05,0,5313.94,"Automobile","Carburant",{"$nulls":6},11,2007,"2007-11"]
[82,null,"2007-11-07",null,10,null,"XXX",0,12,0,5301.94,"Frais divers","Cadeaux",{"$nulls":6},11,2007,"2007-11"]
[83,null,"2007-11-07",null,null,null,"XXX",0,3.7,0,5298.24,"Automobile","Stationnement",{"$nulls":6},11,2007,"2007-11"]
[84,null,"2007-11-07",null,null,null,"XXX",0,4.7,0,5293.54,"Automobile","Stationnement",{"$nulls":6},11,2007,"2007-11"]
[85,null,"2007-11-08",null,null,null,"XXX",0,21,0,5272.54,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[86,null,"2007-11-08",null,null,null,"XXX",0,29.6,0,5242.94,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[87,null,"2007-11-09",null,9,null,"XXX",0,46.8,0,5196.14,"Alimentation","Restaurant",{"$nulls":6},11,2007,"2007-11"]
[88,null,"2007-11-09",null,null,null,"XXX",0,4,0,5192.14,"Automobile","Stationnement",{"$nulls":6},11,2007,"2007-11"]
[89,null,"2007-11-09",null,null,null,"XXX",0,17.6,0,5174.54,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[90,null,"2007-11-09",null,null,null,"XXX",0,36,0,5138.54,"Frais divers","Cadeaux",{"$nulls":6},11,2007,"2007-11"]
[91,null,"2007-11-09",null,null,null,"XXX",0,39.6,0,5098.94,"Alimentation","Restaurant",{"$nulls":6},11,2007,"2007-11"]
[92,null,"2007-11-09",null,null,null,"XXX",0,70,0,5028.94,"Alimentation","Restaurant",{"$nulls":6},11,2007,"2007-11"]
[93,null,"2007-11-12",null,null,null,"XXX",0,4.9,0,5024.04,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[94,null,"2007-11-12",null,null,null,"XXX",0,74.31,0,4949.73,"Automobile","Carburant",{"$nulls":6},11,2007,"2007-11"]
[95,null,"2007-11-12",null,null,null,"XXX",0,114.2,0,4835.53,"Vacances","Logement",{"$nulls":6},11,2007,"2007-11"]
[96,null,"2007-11-13",null,null,null,"XXX",0,72,0,4763.53,"Enfants","cantine/garderie",{"$nulls":6},11,2007,"2007-11"]
[97,null,"2007-11-13",null,null,null,"XXX",0,118.72,0,4644.81,"Enfants","cantine/garderie",{"$nulls":6},11,2007,"2007-11"]
[98,null,"2007-11-13",null,null,null,"XXX",44.79,0,0,4689.6,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[99,null,"2007-11-14",null,null,null,"XXX",0,5.1,0,4684.5,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[100,null,"2007-11-14",null,null,null,"XXX",0,5.4,0,4679.1,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
[101,null,"2007-11-14",null,null,null,"XXX",0,21.4,0,4657.7,"Transport","Péage",{"$nulls":6},11,2007,"2007-11"]
{"$rows_empty":218}
[{"$nulls":40},12,1899]
{"$rows_empty":683}
[168,{"$nulls":5},"03/12/07 STATION OIL CARTE 49799",0,64.52,0,4139.64,"Automobile","Carburant"]
[169,{"$nulls":5},"30/11/07 PHOTOWAYS CARTE 4979921",0,90,0,4049.64,"Frais divers","Cadeaux"]
[170,{"$nulls":5},"VIR RECU  -- TEA012691978 REF 34",1508.78,0,0,5558.42,"Revenus divers","Remboursement"]
[171,{"$nulls":5},"05/12/07 TOYS'R'US CARTE 4979921",0,50.59,0,5507.83,"Frais divers","Cadeaux"]
{"$rows_empty":7}
[172,{"$nulls":5},"PRELEVEMENT SAINT-NOM-LA-BRETEC",0,54,0,5453.83,"Enfants","cantine/garderie"]
{"$rows_empty":21}
[173,{"$nulls":5},"06/12/07 CAMAIEU F536 CARTE 4979",0,17.9,0,5435.93,"Frais divers","Cadeaux"]
{"$rows_empty":34481}
[{"$nulls":19},12,1899]
{"$rows_empty":1539}
[{"$nulls":19},12,1899]
{"$rows_empty":959}
[{"$nulls":19},12,1899]
{"$rows_empty":379}
[{"$nulls":19},12,1899]
{"$rows_empty":1268}
[{"$nulls":19},12,1899]
{"$rows_empty":1348}
[{"$nulls":19},12,1899]
{"$rows_empty":892}
[{"$nulls":19},12,1899]
{"$rows_empty":2926}
[{"$nulls":19},12,1899]
{"$rows_empty":392}
[{"$nulls":19},12,1899]
{"$rows_empty":371}
[{"$nulls":19},12,1899]
{"$rows_empty":1679}
[{"$nulls":19},12,1899]

{"sheet":"Expenses and revenues","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Filtre"]
[]
[null,"ANNEE-MOIS"]
["Données","(vide)","2007-10","2007-11","Total Résultat"]
["Somme - Crédit",null,20064.51,44.79,20109.3]
["Somme - Débit",null,8432.86,3090.98,11523.84]
["Total Somme - Crédit",null,20064.51,44.79,20109.3]
["Total Somme - Débit",null,8432.86,3090.98,11523.84]

{"sheet":"Analysis by Category","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Filtre"]
[]
["Somme - Débit","ANNEE-MOIS"]
["Catégorie","2007-10","2007-11","Total Résultat"]
["Alimentation",945.92,197.59,1143.51]
["Assurance",242.83,242.83,485.66]
["Automobile",573.72,184.03,757.75]
["Divers",30,6.48,36.48]
["Enfants",1581.14,190.72,1771.86]
["Frais divers",16,77.25,93.25]
["Frais financiers",1836.98,1735.32,3572.3]
["Frais professionnels",61.2,null,61.2]
["Impôts",1110,null,1110]
["Logement",410.07,191,601.07]
["Santé",1047,13.45,1060.45]
["Soins",113,null,113]
["Transport",null,138.11,138.11]
["Vacances",460.5,114.2,574.7]
["Total Résultat",8428.36,3090.98,11519.34]

{"sheet":"expenses evolution by month and cat","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}