{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Synthèse","Revenus mensuels","Dépenses mensuelles","Épargne mensuelle","Données du graphique"],"not_rendered":{"charts":2,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"Synthèse","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,9,1],[2,3,10,7]]}
[null,"Budget personnel"]
[null,"Pourcentage du revenu dépensé","Synthèse"]
[null,{"$f":"Pourcentage_de_revenu_dépensé","v":{"v":0.6229333333333333,"d":"62%"}},"REVENU MENSUEL TOTAL","L’histogramme présentant le revenu mensuel total et les dépenses mensuelles totales se trouve dans cette cellule"]
[null,null,{"$f":"SUM(RevenuMensuel[[#All],[MONTANT]])","v":{"v":3750,"d":"3,750 $"}}]
[null,null,"DÉPENSES MENSUELLES TOTALES"]
[null,null,{"$f":"SUM(DépensesMensuelles[[#All],[MONTANT]])","v":{"v":2336,"d":"2,336 $"}}]
[null,null,"ÉPARGNE MENSUELLE TOTALE"]
[null,null,{"$f":"SUM(Épargne[[#All],[MONTANT]])","v":{"v":550,"d":"550 $"}}]
[null,null,"SOLDE"]
[null,null,{"$f":"RevenuMensuelTotal-DépensesMensuellesTotales-ÉpargneMensuelleTotale","v":{"v":864,"d":"864 $"}}]

{"sheet":"Revenus mensuels","index":1,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"TitreBudget","v":"Budget personnel"}]
[null,"Revenu mensuel"]
[null,"POSTE","MONTANT"]
[null,"Source de revenu 1",{"v":2500,"d":"2,500.00 $"}]
[null,"Source de revenu 2",{"v":1000,"d":"1,000.00 $"}]
[null,"Autres",{"v":250,"d":"250.00 $"}]

{"sheet":"Dépenses mensuelles","index":2,"n_rows":16,"n_cols":4,"rows_kept":16}
[null,{"$f":"TitreBudget","v":"Budget personnel"}]
[null,"Dépenses mensuelles"]
[null,"POSTE","ÉCHÉANCE","MONTANT"]
[null,"Location/prêt immobilier","Date",{"v":800,"d":"800.00 $"}]
[null,"Électricité","Date",{"v":120,"d":"120.00 $"}]
[null,"Gaz","Date",{"v":50,"d":"50.00 $"}]
[null,"Téléphone portable","Date",{"v":45,"d":"45.00 $"}]
[null,"Courses","Date",{"v":500,"d":"500.00 $"}]
[null,"Prêt automobile","Date",{"v":273,"d":"273.00 $"}]
[null,"Frais automobile","Date",{"v":120,"d":"120.00 $"}]
[null,"Prêts étudiant","Date",{"v":50,"d":"50.00 $"}]
[null,"Cartes de crédit","Date",{"v":100,"d":"100.00 $"}]
[null,"Assurance automobile","Date",{"v":78,"d":"78.00 $"}]
[null,"Soins personnels","Date",{"v":50,"d":"50.00 $"}]
[null,"Loisirs","Date",{"v":100,"d":"100.00 $"}]
[null,"Divers","Date",{"v":50,"d":"50.00 $"}]

{"sheet":"Épargne mensuelle","index":3,"n_rows":6,"n_cols":3,"rows_kept":6}
[null,{"$f":"TitreBudget","v":"Budget personnel"}]
[null,"Épargne mensuelle"]
[null,"DATE","MONTANT"]
[null,"Date",{"v":200,"d":"200.00 $"}]
[null,"Date",{"v":250,"d":"250.00 $"}]
[null,"Date",{"v":100,"d":"100.00 $"}]

{"sheet":"Données du graphique","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"hidden":true}
[]
[null,"DONNÉES DU GRAPHIQUE"]
[]
[null,{"$f":"MIN(1,1-B5)","v":{"v":0.37706666666666666,"d":"38%"}}]
[null,{"$f":"MIN(DépensesMensuellesTotales/RevenuMensuelTotal,1)","v":{"v":0.6229333333333333,"d":"62%"}}]
[null,{"$f":"(DépensesMensuellesTotales/RevenuMensuelTotal)>1","v":false}]