{"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,"images":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Flux de trésorerie","index":0,"n_rows":14,"n_cols":6,"rows_kept":14}
[{"$nulls":5}," "]
[]
[null," Nom de famille"]
[null,"Budget familial"]
[null,{"$f":"\" Pour le mois de \" & TEXT(TODAY(),\"mmmm aaaa\")","v":" Pour le mois de septembre 2021"}]
[]
[]
[null,"Analyse des flux de trésorerie"]
[]
[]
[null," ","Projection","Actuel","Variance"]
[{"$f":"Bénéfices[[#Totals],[Variance]]","v":300},"Revenu total",{"$f":"Bénéfices[[#Totals],[Projection]]","v":{"v":5700,"d":"5,700 $"}},{"$f":"Bénéfices[[#Totals],[Actuel]]","v":{"v":6000,"d":"6,000 $"}},{"$f":"A12","v":{"v":300,"d":"300 $"}}]
[{"$f":"Dépenses[[#Totals],[Variance]]","v":-52},"Dépense totale",{"$f":"Dépenses[[#Totals],[Projection]]","v":{"v":3603,"d":"3,603 $"}},{"$f":"Dépenses[[#Totals],[Actuel]]","v":{"v":3655,"d":"3,655 $"}},{"$f":"A13","v":{"v":-52,"d":"-52 $ "}}]
[null,"Total des espèces",{"$f":"C12-C13","v":{"v":2097,"d":"2,097 $"}},{"$f":"D12-D13","v":{"v":2345,"d":"2,345 $"}},{"$f":"SUBTOTAL(109,FluxDeTrésorerie[Variance])","v":{"v":248,"d":"248 $"}}]

{"sheet":"Revenus mensuels","index":1,"n_rows":9,"n_cols":6,"rows_kept":9}
[{"$nulls":5}," "]
[null,"Revenus mensuels"]
[]
[]
[null," ","Projection","Actuel","Variance"]
[null,"Revenu 1",{"v":4000,"d":"4,000.00 $"},{"v":4000,"d":"4,000.00 $"},{"$f":"Bénéfices[[#This Row],[Actuel]]-Bénéfices[[#This Row],[Projection]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Revenu 2",{"v":1400,"d":"1,400.00 $"},{"v":1500,"d":"1,500.00 $"},{"$f":"Bénéfices[[#This Row],[Actuel]]-Bénéfices[[#This Row],[Projection]]","v":{"v":100,"d":"100.00 $"}}]
[null,"Autre revenu",{"v":300,"d":"300.00 $"},{"v":500,"d":"500.00 $"},{"$f":"Bénéfices[[#This Row],[Actuel]]-Bénéfices[[#This Row],[Projection]]","v":{"v":200,"d":"200.00 $"}}]
[null,"Revenu total",{"$f":"SUBTOTAL(109,Bénéfices[Projection])","v":{"v":5700,"d":"5,700.00 $"}},{"$f":"SUBTOTAL(109,Bénéfices[Actuel])","v":{"v":6000,"d":"6,000.00 $"}},{"$f":"SUBTOTAL(109,Bénéfices[Variance])","v":{"v":300,"d":"300.00 $"}}]

{"sheet":"Dépenses mensuelles","index":2,"n_rows":26,"n_cols":6,"rows_kept":26}
[{"$nulls":5}," "]
[null,"Dépenses mensuelles"]
[]
[]
[null," ","Projection","Actuel","Variance"]
[null,"Logement",{"v":1500,"d":"1,500.00 $"},{"v":1500,"d":"1,500.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Épicerie",{"v":250,"d":"250.00 $"},{"v":280,"d":"280.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":-30,"d":"-30.00 $ "}}]
[null,"Téléphone",{"v":38,"d":"38.00 $"},{"v":38,"d":"38.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Électricité/Gaz",{"v":65,"d":"65.00 $"},{"v":78,"d":"78.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":-13,"d":"-13.00 $ "}}]
[null,"Eau/Assainissement/Ordures",{"v":25,"d":"25.00 $"},{"v":21,"d":"21.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":4,"d":"4.00 $"}}]
[null,"Câble TV",{"v":75,"d":"75.00 $"},{"v":83,"d":"83.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":-8,"d":"-8.00 $ "}}]
[null,"Internet",{"v":60,"d":"60.00 $"},{"v":60,"d":"60.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Entretien/Réparations",{"v":0,"d":"0.00 $"},{"v":60,"d":"60.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":-60,"d":"-60.00 $ "}}]
[null,"Crèche",{"v":180,"d":"180.00 $"},{"v":150,"d":"150.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":30,"d":"30.00 $"}}]
[null,"Frais d’inscription",{"v":250,"d":"250.00 $"},{"v":250,"d":"250.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Animaux",{"v":75,"d":"75.00 $"},{"v":80,"d":"80.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":-5,"d":"-5.00 $ "}}]
[null,"Transport",{"v":280,"d":"280.00 $"},{"v":260,"d":"260.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":20,"d":"20.00 $"}}]
[null,"Soins personnels",{"v":75,"d":"75.00 $"},{"v":65,"d":"65.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":10,"d":"10.00 $"}}]
[null,"Assurance",{"v":255,"d":"255.00 $"},{"v":255,"d":"255.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Cartes de crédit",{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Prêts",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Impôts",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Cadeaux/Dons",{"v":150,"d":"150.00 $"},{"v":150,"d":"150.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Épargne",{"v":225,"d":"225.00 $"},{"v":225,"d":"225.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Autre",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$f":"Dépenses[[#This Row],[Projection]]-Dépenses[[#This Row],[Actuel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses[Projection])","v":{"v":3603,"d":"3,603.00 $"}},{"$f":"SUBTOTAL(109,Dépenses[Actuel])","v":{"v":3655,"d":"3,655.00 $"}},{"$f":"SUBTOTAL(109,Dépenses[Variance])","v":{"v":-52,"d":"-52.00 $ "}}]

{"sheet":"Données du graphique","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Données du diagramme"]
[]
[null,null,"Projection","Actuel"]
[null,"Revenu mensuel",{"$f":"Bénéfices[[#Totals],[Projection]]","v":5700},{"$f":"Bénéfices[[#Totals],[Actuel]]","v":6000}]
[null,"Dépenses mensuelles",{"$f":"Dépenses[[#Totals],[Projection]]","v":3603},{"$f":"Dépenses[[#Totals],[Actuel]]","v":3655}]
[null,"Flux de trésorerie",{"$f":"FluxDeTrésorerie[[#Totals],[Projection]]","v":2097},{"$f":"FluxDeTrésorerie[[#Totals],[Actuel]]","v":2345}]