{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Flux de trésorerie","Revenus mensuels","Dépenses mensuelles","DONNÉES DU GRAPHIQUE"],"not_rendered":{"charts":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Flux de trésorerie","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,"Nom"]
[null,"Budget familial"]
[null,{"$f":"TEXT(TODAY(),\"mmmm\")","v":"novembre"}]
[null,{"$f":"YEAR(TODAY())","v":2017}]
[null,"Remarque : le tableau Flux de trésorerie est calculé automatiquement sur la base des entrées des feuilles de calcul Revenus mensuels et Dépenses mensuelles"]
[null,"Flux de trésorerie","Projeté","Réel","Variance"]
[null,"Revenus totaux",{"$f":"Revenu[[#Totals],[Projeté]]","v":{"v":5700,"d":"5,700"}},{"$f":"Revenu[[#Totals],[Réel]]","v":{"v":5500,"d":"5,500"}},{"$f":"Revenu[[#Totals],[Variance]]","v":-200}]
[null,"Dépenses totales",{"$f":"Dépenses[[#Totals],[Projeté]]","v":{"v":3603,"d":"3,603"}},{"$f":"Dépenses[[#Totals],[Réel]]","v":{"v":3655,"d":"3,655"}},{"$f":"Dépenses[[#Totals],[Variance]]","v":-52}]
[null,"Total trésorerie",{"$f":"C7-C8","v":{"v":2097,"d":"2,097"}},{"$f":"D7-D8","v":{"v":1845,"d":"1,845"}},{"$f":"SUBTOTAL(109,FluxDeTrésorerie[Variance])","v":-252}]

{"sheet":"Revenus mensuels","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[null,{"$f":"Nom","v":"Nom"}]
[null,{"$f":"TitreBudget","v":"Budget familial"}]
[null,{"$f":"Mois","v":"novembre"}]
[null,{"$f":"Année","v":2017}]
[null,"Revenus mensuels","Projeté","Réel","Variance"]
[null,"Revenu 1",{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$f":"Revenu[[#This Row],[Réel]]-Revenu[[#This Row],[Projeté]]","v":0}]
[null,"Revenu 2",{"v":1400,"d":"1,400"},{"v":1500,"d":"1,500"},{"$f":"Revenu[[#This Row],[Réel]]-Revenu[[#This Row],[Projeté]]","v":100}]
[null,"Autres revenus",300,0,{"$f":"Revenu[[#This Row],[Réel]]-Revenu[[#This Row],[Projeté]]","v":-300}]
[null,"Revenus totaux",{"$f":"SUBTOTAL(109,Revenu[Projeté])","v":{"v":5700,"d":"5,700"}},{"$f":"SUBTOTAL(109,Revenu[Réel])","v":{"v":5500,"d":"5,500"}},{"$f":"SUBTOTAL(109,Revenu[Variance])","v":-200}]

{"sheet":"Dépenses mensuelles","index":2,"n_rows":26,"n_cols":5,"rows_kept":26}
[null,{"$f":"Nom","v":"Nom"}]
[null,{"$f":"TitreBudget","v":"Budget familial"}]
[null,{"$f":"Mois","v":"novembre"}]
[null,{"$f":"Année","v":2017}]
[null,"Dépenses mensuelles","Projeté","Réel","Variance"]
[null,"Logement",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Courses",250,280,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":-30}]
[null,"Téléphone",38,38,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Électricité/Gaz",65,78,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":-13}]
[null,"Eau/Assainissement/Ordures",25,21,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":4}]
[null,"Câble",75,83,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":-8}]
[null,"Internet",60,60,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Entretien/Réparations",0,60,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":-60}]
[null,"Garderie",180,150,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":30}]
[null,"Frais d’inscription",250,250,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Animaux",75,80,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":-5}]
[null,"Transport",280,260,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":20}]
[null,"Soins personnels",75,65,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":10}]
[null,"Assurance",255,255,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Cartes de crédit",100,100,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Prêts",0,0,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Impôts",0,0,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Cadeaux/Dons",150,150,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Épargne",225,225,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Autre",0,0,{"$f":"Dépenses[[#This Row],[Projeté]]-Dépenses[[#This Row],[Réel]]","v":0}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses[Projeté])","v":{"v":3603,"d":"3,603"}},{"$f":"SUBTOTAL(109,Dépenses[Réel])","v":{"v":3655,"d":"3,655"}},{"$f":"SUBTOTAL(109,Dépenses[Variance])","v":-52}]

{"sheet":"DONNÉES DU GRAPHIQUE","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true}
[null,"DONNÉES DU GRAPHIQUE"]
[]
[null,null,"Projeté","Réel"]
[null,"Flux de trésorerie",{"$f":"FluxDeTrésorerie[[#Totals],[Projeté]]","v":2097},{"$f":"FluxDeTrésorerie[[#Totals],[Réel]]","v":1845}]
[null,"Revenus mensuels",{"$f":"Revenu[[#Totals],[Projeté]]","v":5700},{"$f":"Revenu[[#Totals],[Réel]]","v":5500}]
[null,"Dépenses mensuelles",{"$f":"Dépenses[[#Totals],[Projeté]]","v":3603},{"$f":"Dépenses[[#Totals],[Réel]]","v":3655}]