{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Suivi de dépenses personnelles","Résumé mensuel","Données graphiques"],"not_rendered":{"charts":2,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Suivi de dépenses personnelles","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[19,1,20,1],[21,1,23,1]]}
[null,"Suivi de dépenses personnelles"]
[]
[{"$nulls":3},"Synthèse"]
[{"$nulls":3},"Comptes","Montant de départ","Dépenses totales","Solde"]
[{"$nulls":3},"Compte courant",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(CashSpent[Comptes],\"=\" &CashSummaryTable[[#This Row],[Comptes]],CashSpent[Montant])","v":{"v":428,"d":"428.00"}},{"$f":"CashSummaryTable[[#This Row],[Montant de départ]]-CashSummaryTable[[#This Row],[Dépenses totales]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Épargne",{"v":500,"d":"500.00"},{"$f":"SUMIF(CashSpent[Comptes],\"=\" &CashSummaryTable[[#This Row],[Comptes]],CashSpent[Montant])","v":{"v":450,"d":"450.00"}},{"$f":"CashSummaryTable[[#This Row],[Montant de départ]]-CashSummaryTable[[#This Row],[Dépenses totales]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Autre",{"v":200,"d":"200.00"},{"$f":"SUMIF(CashSpent[Comptes],\"=\" &CashSummaryTable[[#This Row],[Comptes]],CashSpent[Montant])","v":{"v":30,"d":"30.00"}},{"$f":"CashSummaryTable[[#This Row],[Montant de départ]]-CashSummaryTable[[#This Row],[Dépenses totales]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,CashSummaryTable[Montant de départ])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Dépenses totales])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,CashSummaryTable[Solde])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Mes dépenses"]
[{"$nulls":3},"Date","Description","Montant","Comptes"]
[{"$nulls":3},"2012-01-04","Retrait distributeur",{"v":40,"d":"40.00"},"Compte courant"]
[{"$nulls":3},"2012-01-05","Déjeuner",{"v":5,"d":"5.00"},"Compte courant"]
[{"$nulls":3},"2012-01-06","Traites voiture",{"v":230,"d":"230.00"},"Épargne"]
[{"$nulls":3},"2012-02-03","Factures d’électricité",{"v":70,"d":"70.00"},"Compte courant"]
[{"$nulls":3},"2012-02-07","Dîner",{"v":53,"d":"53.00"},"Compte courant"]
[{"$nulls":3},"2012-03-01","Retrait espèces",{"v":100,"d":"100.00"},"Épargne"]
[{"$nulls":3},"2012-03-06","Traites voiture",{"v":230,"d":"230.00"},"Compte courant"]
[{"$nulls":3},"2012-04-06","Factures d’électricité",{"v":70,"d":"70.00"},"Épargne"]
[null,"Solde :",null,"2012-04-20","Retrait distributeur",{"v":30,"d":"30.00"},"Compte courant"]
[{"$nulls":3},"2012-05-03","Retrait distributeur",{"v":50,"d":"50.00"},"Épargne"]
[null,{"$f":"CashSummaryTable[[#Totals],[Solde]]/CashSummaryTable[[#Totals],[Montant de départ]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","Retrait distributeur",{"v":30,"d":"30.00"},"Autre"]

{"sheet":"Résumé mensuel","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Résumé mensuel"]
[null,"Synthèse des comptes"]
{"$rows_empty":13}
[null,"Résumé des dépenses"]
[null,"Détails"]
[null,null,"Autre","Compte courant","Épargne","Total général"]
[null,"mars",null,230,100,330]
[null,"Retrait espèces",null,null,100,100]
[null,"Traites voiture",null,230,null,230]
[null,"mai",30,null,50,80]
[null,"avr",null,30,70,100]
[null,"févr",null,123,null,123]
[null,"janv",null,45,230,275]
[null,"Total général",30,428,450,908]

{"sheet":"Données graphiques","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Données de tableau croisé dynamique"]
[null,"Ce tableau croisé dynamique représente la source de données pour le tableau croisé dynamique de synthèse des comptes sur la feuille de résumé mensuel"]
[null,"Somme de Montant","Étiquettes de colonnes"]
[null,"Étiquettes de lignes","Autre","Compte courant","Épargne","Total général"]
[null,"janv",null,{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},{"v":275,"d":"275.00"}]
[null,"févr",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"mars",null,{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},{"v":330,"d":"330.00"}]
[null,"avr",null,{"v":30,"d":"30.00"},{"v":70,"d":"70.00"},{"v":100,"d":"100.00"}]
[null,"mai",{"v":30,"d":"30.00"},null,{"v":50,"d":"50.00"},{"v":80,"d":"80.00"}]
[null,"Total général",{"v":30,"d":"30.00"},{"v":428,"d":"428.00"},{"v":450,"d":"450.00"},{"v":908,"d":"908.00"}]