{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Flux de trésorerie quotidien","Flux de trésorerie mensuel","Flux de trésorerie annuel","Revenu","Dépenses","Dépenses discrétionnaires","Épargne"],"not_rendered":{"charts":4,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"FLUX DE TRÉSORERIE PERSONNEL"]
[null,"  Ce classeur comporte des feuilles de calcul pour le flux de trésorerie annuels, mensuels et quotidiens. \n  Choisissez le type de flux de trésorerie qui vous convient ou utilisez-les tous pour mieux suivre vos flux de trésorerie personnels."]
[]
[null,"Flux de trésorerie quotidien",null,null,"Flux de trésorerie mensuel",null,null,"Flux de trésorerie annuel"]
[]
[null,"Entrez le montant estimé de vos flux de trésorerie quotidiens et examinez l’estimation des totaux mensuels et annuels.  Cette feuille de calcul vous permet d’identifier vos habitudes quotidiennes en matière de dépenses au cours d’un mois ou d’une année.",null,null,"Entrez vos flux de trésorerie mensuels ou estimez les mois restants pour afficher les flux de trésorerie prévisionnels pour l’année et pour chaque mois.",null,null,"Entrez un montant de flux de trésorerie annuel dans quatre feuilles de calcul : Revenus, dépenses, discrétionnaires et épargnes. \nConsultez les détails mensuels et le comparatif des différentes valeurs, et ce qu’il faut retenir de vos chiffres annuels et mensuels."]

{"sheet":"Flux de trésorerie quotidien","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL"]
[null,null,"Total de la trésorerie disponible :",{"$f":"FluxTrésorerieQuotidiens","v":{"v":577.8399999999999,"d":"577.84 $"}},null,"REMARQUE : Si vous souhaitez ajouter des postes quotidiens à la table, estimez le montant ou la valeur mensuel, et placez cette valeur dans la colonne du mois approprié."]
[]
[null,"RÉCAPITULATIF QUOTIDIEN"]
[null,"Totaux","Quotidien","Mensuel","Annuel "]
[null,"Revenu",{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Quotidien])","v":{"v":342.47,"d":"342.47 $"}},{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Mensuel])","v":{"v":10416.795833333334,"d":"10,416.80 $"}},{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Annuel])","v":{"v":125001.55000000002,"d":"125,001.55 $"}}]
[null,"Dépenses",{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Quotidien])","v":{"v":136.05999999999997,"d":"136.06 $"}},{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Mensuel])","v":{"v":4138.491666666667,"d":"4,138.49 $"}},{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Annuel])","v":{"v":49661.899999999994,"d":"49,661.90 $"}}]
[null,"Discrétionnaire",{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Quotidien])","v":{"v":36.29,"d":"36.29 $"}},{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Mensuel])","v":{"v":1103.8208333333334,"d":"1,103.82 $"}},{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Annuel])","v":{"v":13245.849999999999,"d":"13,245.85 $"}}]
[null,"Épargne",{"$f":"SUMIF(Quotidien[Type],$B9,Quotidien[Quotidien])","v":{"v":63.019999999999996,"d":"63.02 $"}},{"$f":"SUMIF(Quotidien[Type],$B9,Quotidien[Mensuel])","v":{"v":1916.8583333333333,"d":"1,916.86 $"}},{"$f":"SUMIF(Quotidien[Type],$B9,Quotidien[Annuel])","v":{"v":23002.300000000003,"d":"23,002.30 $"}}]
[]
[null,"Type","Description","Quotidien","Mensuel","Annuel"]
[null,"Revenu","Salaire",{"v":246.58,"d":"246.58 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":7500.141666666667,"d":"7,500.14 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":90001.70000000001,"d":"90,001.70 $"}}]
[null,"Revenu","Commissions/Primes",{"v":13.7,"d":"13.70 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":416.7083333333333,"d":"416.71 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":5000.5,"d":"5,000.50 $"}}]
[null,"Revenu","Divers 1",{"v":82.19,"d":"82.19 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":2499.945833333333,"d":"2,499.95 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":29999.35,"d":"29,999.35 $"}}]
[null,"Revenu","Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Revenu","Divers 3",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Revenu","Divers 4",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Assurance maladie",{"v":41.1,"d":"41.10 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":1250.125,"d":"1,250.13 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":15001.5,"d":"15,001.50 $"}}]
[null,"Dépenses","Impôts sur les revenus",{"v":6.85,"d":"6.85 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":208.35416666666666,"d":"208.35 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":2500.25,"d":"2,500.25 $"}}]
[null,"Dépenses","Taxe automobile/Frais",{"v":0.55,"d":"0.55 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":16.729166666666668,"d":"16.73 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":200.75000000000003,"d":"200.75 $"}}]
[null,"Dépenses","Prêt automobile",{"v":10.96,"d":"10.96 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":333.3666666666667,"d":"333.37 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":4000.4,"d":"4,000.40 $"}}]
[null,"Dépenses","Prêt immobilier/Loyer",{"v":41.1,"d":"41.10 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":1250.125,"d":"1,250.13 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":15001.5,"d":"15,001.50 $"}}]
[null,"Dépenses","Assurance",{"v":0.68,"d":"0.68 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":20.683333333333334,"d":"20.68 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":248.20000000000002,"d":"248.20 $"}}]
[null,"Dépenses","Électricité",{"v":3.29,"d":"3.29 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":100.07083333333333,"d":"100.07 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":1200.85,"d":"1,200.85 $"}}]
[null,"Dépenses","Gaz",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Dépenses","Eau",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Dépenses","Assainissement",{"v":0.82,"d":"0.82 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":24.941666666666663,"d":"24.94 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":299.29999999999995,"d":"299.30 $"}}]
[null,"Dépenses","Ordures ménagères",{"v":0.41,"d":"0.41 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":12.470833333333331,"d":"12.47 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":149.64999999999998,"d":"149.65 $"}}]
[null,"Dépenses","Téléphone",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Dépenses","Internet",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Dépenses","Primes d’invalidité",{"v":4.11,"d":"4.11 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":125.0125,"d":"125.01 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":1500.15,"d":"1,500.15 $"}}]
[null,"Dépenses","Nourriture",{"v":13.7,"d":"13.70 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":416.7083333333333,"d":"416.71 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":5000.5,"d":"5,000.50 $"}}]
[null,"Dépenses","Habillement",{"v":3.29,"d":"3.29 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":100.07083333333333,"d":"100.07 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":1200.85,"d":"1,200.85 $"}}]
[null,"Dépenses","Soins médicaux/dentaires/Pharmacie",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Dépenses","Bus",{"v":1,"d":"1.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":30.416666666666668,"d":"30.42 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":365,"d":"365.00 $"}}]
[null,"Dépenses","Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Divers 3",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Divers 4",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Discrétionnaire","Restaurants",{"v":3.29,"d":"3.29 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":100.07083333333333,"d":"100.07 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":1200.85,"d":"1,200.85 $"}}]
[null,"Discrétionnaire","Cadeaux",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Discrétionnaire","Déplacements",{"v":6.16,"d":"6.16 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":187.36666666666667,"d":"187.37 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":2248.4,"d":"2,248.40 $"}}]
[null,"Discrétionnaire","Loisirs",{"v":3.29,"d":"3.29 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":100.07083333333333,"d":"100.07 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":1200.85,"d":"1,200.85 $"}}]
[null,"Discrétionnaire","Soins personnels",{"v":0.82,"d":"0.82 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":24.941666666666663,"d":"24.94 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":299.29999999999995,"d":"299.30 $"}}]
[null,"Discrétionnaire","Achats",{"v":5.48,"d":"5.48 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":166.68333333333334,"d":"166.68 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":2000.2,"d":"2,000.20 $"}}]
[null,"Discrétionnaire","Dons",{"v":1.64,"d":"1.64 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":49.883333333333326,"d":"49.88 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":598.5999999999999,"d":"598.60 $"}}]
[null,"Discrétionnaire","Club/Abonnements",{"v":0.82,"d":"0.82 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":24.941666666666663,"d":"24.94 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":299.29999999999995,"d":"299.30 $"}}]
[null,"Discrétionnaire","Rénovations",{"v":13.15,"d":"13.15 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":399.9791666666667,"d":"399.98 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":4799.75,"d":"4,799.75 $"}}]
[null,"Discrétionnaire","Divers 1",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Discrétionnaire","Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Épargne","Réserves de trésorerie",{"v":13.7,"d":"13.70 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":416.7083333333333,"d":"416.71 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":5000.5,"d":"5,000.50 $"}}]
[null,"Épargne","401(k)/Etc",{"v":32.88,"d":"32.88 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":1000.1,"d":"1,000.10 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":12001.2,"d":"12,001.20 $"}}]
[null,"Épargne","Compte d’épargne",{"v":16.44,"d":"16.44 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":500.05,"d":"500.05 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":6000.6,"d":"6,000.60 $"}}]
[null,"Épargne","Divers 1",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Épargne","Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Quotidien[[#This Row],[Annuel]]/12","v":{"v":0,"d":"0.00 $"}},{"$f":"Quotidien[[#This Row],[Quotidien]]*365","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",null,{"$f":"SUMIF(Quotidien[Type],\"Revenu\",Quotidien[Quotidien])-SUMIF(Quotidien[Type],\"<>Revenu\",Quotidien[Quotidien])","v":{"v":107.10000000000014,"d":"107.10 $"}},{"$f":"SUMIF(Quotidien[Type],\"Revenu\",Quotidien[Mensuel])-SUMIF(Quotidien[Type],\"<>Revenu\",Quotidien[Mensuel])","v":{"v":3257.625,"d":"3,257.63 $"}},{"$f":"SUMIF(Quotidien[Type],\"Revenu\",Quotidien[Annuel])-SUMIF(Quotidien[Type],\"<>Revenu\",Quotidien[Annuel])","v":{"v":39091.500000000015,"d":"39,091.50 $"}}]

{"sheet":"Flux de trésorerie mensuel","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL",{"$nulls":15}," "]
[null,null,"Total des flux de trésorerie mensuels :",{"$f":"FluxTrésorerieMensuelsÀCeJour","v":{"v":18380,"d":"18,380.00 $"}},null,"REMARQUE : Pour les postes quotidiens, estimez le montant ou la valeur mensuel, et placez cette valeur dans la colonne du mois approprié.\n"]
[]
[null,"Type","Description","Jan.","Fév.","Mar.","Avr.","Mai","Juin","Juil.","Août","Sept.","Oct.","Nov.","Déc.","Total"]
[null,"Revenu","Salaire",{"v":7500,"d":"7,500.00 $"},{"v":7500,"d":"7,500.00 $"},{"v":7500,"d":"7,500.00 $"},{"v":7500,"d":"7,500.00 $"},{"v":7500,"d":"7,500.00 $"},{"v":7500,"d":"7,500.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":45000,"d":"45,000.00 $"}}]
[null,"Revenu","Commissions/Primes",{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"v":500,"d":"500.00 $"},{"v":200,"d":"200.00 $"},{"v":0,"d":"0.00 $"},{"v":600,"d":"600.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":2100,"d":"2,100.00 $"}}]
[null,"Revenu","Divers 1",{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"},{"v":2500,"d":"2,500.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":15000,"d":"15,000.00 $"}}]
[null,"Revenu","Divers 2",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Revenu","Divers 3",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Revenu","Divers 4",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Assurance maladie",{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":7500,"d":"7,500.00 $"}}]
[null,"Dépenses","Impôts sur les revenus",{"v":208.33333333333334,"d":"208.33 $"},{"v":208.33333333333334,"d":"208.33 $"},{"v":208.33333333333334,"d":"208.33 $"},{"v":208.33333333333334,"d":"208.33 $"},{"v":208.33333333333334,"d":"208.33 $"},{"v":208.33333333333334,"d":"208.33 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":1250,"d":"1,250.00 $"}}]
[null,"Dépenses","Taxe automobile/Frais",{"v":16.666666666666668,"d":"16.67 $"},{"v":16.666666666666668,"d":"16.67 $"},{"v":16.666666666666668,"d":"16.67 $"},{"v":16.666666666666668,"d":"16.67 $"},{"v":16.666666666666668,"d":"16.67 $"},{"v":16.666666666666668,"d":"16.67 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":100.00000000000001,"d":"100.00 $"}}]
[null,"Dépenses","Prêt automobile",{"v":333.3333333333333,"d":"333.33 $"},{"v":333.3333333333333,"d":"333.33 $"},{"v":333.3333333333333,"d":"333.33 $"},{"v":333.3333333333333,"d":"333.33 $"},{"v":333.3333333333333,"d":"333.33 $"},{"v":333.3333333333333,"d":"333.33 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":1999.9999999999998,"d":"2,000.00 $"}}]
[null,"Dépenses","Prêt immobilier/Loyer",{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"v":1250,"d":"1,250.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":7500,"d":"7,500.00 $"}}]
[null,"Dépenses","Assurance",{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":150,"d":"150.00 $"}}]
[null,"Dépenses","Électricité",{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"v":100,"d":"100.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":600,"d":"600.00 $"}}]
[null,"Dépenses","Gaz",{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Dépenses","Eau",{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Dépenses","Assainissement",{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":150,"d":"150.00 $"}}]
[null,"Dépenses","Ordures ménagères",{"v":12.5,"d":"12.50 $"},{"v":12.5,"d":"12.50 $"},{"v":12.5,"d":"12.50 $"},{"v":12.5,"d":"12.50 $"},{"v":12.5,"d":"12.50 $"},{"v":12.5,"d":"12.50 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":75,"d":"75.00 $"}}]
[null,"Dépenses","Téléphone",{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Dépenses","Internet",{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Dépenses","Primes d’invalidité",{"v":125,"d":"125.00 $"},{"v":125,"d":"125.00 $"},{"v":125,"d":"125.00 $"},{"v":125,"d":"125.00 $"},{"v":125,"d":"125.00 $"},{"v":125,"d":"125.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":750,"d":"750.00 $"}}]
[null,"Dépenses","Nourriture",{"v":400,"d":"400.00 $"},{"v":500,"d":"500.00 $"},{"v":450,"d":"450.00 $"},{"v":400,"d":"400.00 $"},{"v":450,"d":"450.00 $"},{"v":425,"d":"425.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":2625,"d":"2,625.00 $"}}]
[null,"Dépenses","Habillement",{"v":50,"d":"50.00 $"},{"v":75,"d":"75.00 $"},{"v":100,"d":"100.00 $"},{"v":75,"d":"75.00 $"},{"v":125,"d":"125.00 $"},{"v":75,"d":"75.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":500,"d":"500.00 $"}}]
[null,"Dépenses","Soins médicaux/dentaires/Pharmacie",{"v":50,"d":"50.00 $"},{"v":10,"d":"10.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":20,"d":"20.00 $"},{"v":70,"d":"70.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":200,"d":"200.00 $"}}]
[null,"Dépenses","Bus",{"v":30,"d":"30.00 $"},{"v":30,"d":"30.00 $"},{"v":30,"d":"30.00 $"},{"v":20,"d":"20.00 $"},{"v":30,"d":"30.00 $"},{"v":30,"d":"30.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":170,"d":"170.00 $"}}]
[null,"Dépenses","Divers 2",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Divers 3",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Dépenses","Divers 4",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Discrétionnaire","Restaurants",{"v":50,"d":"50.00 $"},{"v":150,"d":"150.00 $"},{"v":100,"d":"100.00 $"},{"v":50,"d":"50.00 $"},{"v":150,"d":"150.00 $"},{"v":100,"d":"100.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":600,"d":"600.00 $"}}]
[null,"Discrétionnaire","Cadeaux",{"v":25,"d":"25.00 $"},{"v":75,"d":"75.00 $"},{"v":50,"d":"50.00 $"},{"v":25,"d":"25.00 $"},{"v":75,"d":"75.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Discrétionnaire","Déplacements",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":1000,"d":"1,000.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":1000,"d":"1,000.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":2000,"d":"2,000.00 $"}}]
[null,"Discrétionnaire","Loisirs",{"v":50,"d":"50.00 $"},{"v":150,"d":"150.00 $"},{"v":100,"d":"100.00 $"},{"v":50,"d":"50.00 $"},{"v":150,"d":"150.00 $"},{"v":100,"d":"100.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":600,"d":"600.00 $"}}]
[null,"Discrétionnaire","Soins personnels",{"v":15,"d":"15.00 $"},{"v":25,"d":"25.00 $"},{"v":35,"d":"35.00 $"},{"v":15,"d":"15.00 $"},{"v":25,"d":"25.00 $"},{"v":35,"d":"35.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":150,"d":"150.00 $"}}]
[null,"Discrétionnaire","Achats",{"v":100,"d":"100.00 $"},{"v":200,"d":"200.00 $"},{"v":150,"d":"150.00 $"},{"v":175,"d":"175.00 $"},{"v":150,"d":"150.00 $"},{"v":175,"d":"175.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":950,"d":"950.00 $"}}]
[null,"Discrétionnaire","Dons",{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"v":50,"d":"50.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":300,"d":"300.00 $"}}]
[null,"Discrétionnaire","Club/Abonnements",{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"v":25,"d":"25.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":150,"d":"150.00 $"}}]
[null,"Discrétionnaire","Rénovations",{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"v":400,"d":"400.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":2400,"d":"2,400.00 $"}}]
[null,"Discrétionnaire","Divers 1",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Discrétionnaire","Divers 2",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Épargne","Réserves de trésorerie",{"v":416.6666666666667,"d":"416.67 $"},{"v":416.6666666666667,"d":"416.67 $"},{"v":416.6666666666667,"d":"416.67 $"},{"v":416.6666666666667,"d":"416.67 $"},{"v":416.6666666666667,"d":"416.67 $"},{"v":416.6666666666667,"d":"416.67 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":2500,"d":"2,500.00 $"}}]
[null,"Épargne","401(k)/Etc",{"v":1000,"d":"1,000.00 $"},{"v":1000,"d":"1,000.00 $"},{"v":1000,"d":"1,000.00 $"},{"v":1000,"d":"1,000.00 $"},{"v":1000,"d":"1,000.00 $"},{"v":1000,"d":"1,000.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":6000,"d":"6,000.00 $"}}]
[null,"Épargne","Compte d’épargne",{"v":500,"d":"500.00 $"},{"v":500,"d":"500.00 $"},{"v":500,"d":"500.00 $"},{"v":500,"d":"500.00 $"},{"v":500,"d":"500.00 $"},{"v":500,"d":"500.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":3000,"d":"3,000.00 $"}}]
[null,"Épargne","Divers 1",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Épargne","Divers 2",{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"v":0,"d":"0.00 $"},{"$nulls":6},{"$f":"SUM(Mensuel[[#This Row],[Jan.]:[Déc.]])","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",null,{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Jan.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Jan.])","v":{"v":3692.5,"d":"3,692.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Fév.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Fév.])","v":{"v":3247.5,"d":"3,247.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Mar.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Mar.])","v":{"v":2522.5,"d":"2,522.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Avr.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Avr.])","v":{"v":3427.5,"d":"3,427.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Mai])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Mai])","v":{"v":2887.5,"d":"2,887.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Juin])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Juin])","v":{"v":2602.5,"d":"2,602.50 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Juil.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Juil.])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Août])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Août])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Sept.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Sept.])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Oct.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Oct.])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Nov.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Nov.])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Déc.])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Déc.])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUMIF(Mensuel[Type],\"Revenu\",Mensuel[Total])-SUMIF(Mensuel[Type],\"<>Revenu\",Mensuel[Total])","v":{"v":18380,"d":"18,380.00 $"}}]

{"sheet":"Flux de trésorerie annuel","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"merged":[[1,3,1,4],[1,6,1,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[7,2,7,3],[7,6,7,7],[7,10,7,11],[7,14,7,15]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL",{"$nulls":14}," "]
[null,null,"Total des flux de trésorerie à ce jour :",{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":42250,"d":"42,250.00 $"}},null,null,"Il s’agit d’une estimation annuelle. Cette feuille de calcul vous permet de consulter les montants annuels avec des valeurs mensuelles estimées. Utilisez les feuilles de calcul Revenus, Dépenses, Discrétionnaires et Épargne pour entrer des postes."]
[]
[null,"RÉCAPITULATIF DES REVENUS",{"$nulls":3},"RÉCAPITULATIF DES DÉPENSES",{"$nulls":3},"RÉCAPITULATIF DES DÉPENSES DISCRÉTIONNAIRES",{"$nulls":3},"RÉCAPITULATIF DE L’ÉPARGNE"]
[null,"Total annuel :",{"$f":"'Revenu'!C11","v":{"v":125000,"d":"125,000.00 $"}},null,null,"Total annuel :",{"$f":"Dépenses[[#Totals],[Annuel  ]]","v":{"v":46500,"d":"46,500.00 $"}},null,null,"Total annuel :",{"$f":"Discrétionnaire[[#Totals],[Annuel  ]]","v":{"v":13250,"d":"13,250.00 $"}},null,null,"Total annuel :",{"$f":"Épargne[[#Totals],[Annuel  ]]","v":{"v":23000,"d":"23,000.00 $"}}]
[]
[]
[null,"Total mensuel :",{"$f":"'Revenu'!D11","v":{"v":10416.666666666668,"d":"10,416.67 $"}},null,null,"Total mensuel :",{"$f":"Dépenses[[#Totals],[Mensuel ]]","v":{"v":3875,"d":"3,875.00 $"}},null,null,"Total mensuel :",{"$f":"Discrétionnaire[[#Totals],[Mensuel ]]","v":{"v":1104.1666666666665,"d":"1,104.17 $"}},null,null,"Total mensuel :",{"$f":"Épargne!D10","v":{"v":1916.6666666666667,"d":"1,916.67 $"}}]
[]
[{"$nulls":17},"Intitulés des lignes","Somme annuelle",null,"Intitulés des lignes","Somme annuelle",null,"Intitulés des lignes","Somme annuelle",null,"Intitulés des lignes","Somme annuelle"]
[{"$nulls":17},"Divers 2",{"v":0,"d":"$0"},null,"Divers 2",{"v":0,"d":"$0"},null,"Divers 2",{"v":0,"d":"$0"},null,"Divers 2",{"v":0,"d":"$0"}]
[{"$nulls":17},"Divers 3",{"v":0,"d":"$0"},null,"Divers 1",{"v":0,"d":"$0"},null,"Divers 1",{"v":0,"d":"$0"},null,"Divers 1",{"v":0,"d":"$0"}]
[{"$nulls":17},"Divers 4",{"v":0,"d":"$0"},null,"Ordures ménagères",{"v":150,"d":"$150"},null,"Club/Abonnements",{"v":300,"d":"$300"},null,"Réserves de trésorerie",{"v":5000,"d":"$5,000"}]
[{"$nulls":17},"Commissions/Primes",{"v":5000,"d":"$5,000"},null,"Taxe automobile/Frais",{"v":200,"d":"$200"},null,"Soins personnels",{"v":300,"d":"$300"},null,"Épargne/investissement",{"v":6000,"d":"$6,000"}]
[{"$nulls":17},"Divers 1",{"v":30000,"d":"$30,000"},null,"Assurance",{"v":250,"d":"$250"},null,"Cadeaux",{"v":600,"d":"$600"},null,"401(k)/Etc",{"v":12000,"d":"$12,000"}]
[{"$nulls":17},"Salaire",{"v":90000,"d":"$90,000"},null,"Gaz",{"v":600,"d":"$600"},null,"Dons",{"v":600,"d":"$600"},null,"Total général",{"v":23000,"d":"$23,000"}]
[{"$nulls":17},"Total général",{"v":125000,"d":"$125,000"},null,"Internet",{"v":600,"d":"$600"},null,"Loisirs",{"v":1200,"d":"$1,200"}]
[{"$nulls":20},"Téléphone",{"v":600,"d":"$600"},null,"Restaurants",{"v":1200,"d":"$1,200"}]
[{"$nulls":20},"Eau/assainissement",{"v":600,"d":"$600"},null,"Achats",{"v":2000,"d":"$2,000"}]
[{"$nulls":20},"Soins médicaux/dentaires/Pharmacie",{"v":600,"d":"$600"},null,"Déplacements",{"v":2250,"d":"$2,250"}]
[{"$nulls":20},"Habillement",{"v":1200,"d":"$1,200"},null,"Rénovations",{"v":4800,"d":"$4,800"}]
[{"$nulls":20},"Électricité",{"v":1200,"d":"$1,200"},null,"Total général",{"v":13250,"d":"$13,250"}]
[{"$nulls":20},"Primes d’invalidité",{"v":1500,"d":"$1,500"}]
[{"$nulls":20},"Impôts sur les revenus",{"v":2500,"d":"$2,500"}]
[{"$nulls":20},"Prêt automobile",{"v":4000,"d":"$4,000"}]
[{"$nulls":20},"Nourriture",{"v":5000,"d":"$5,000"}]
[{"$nulls":20},"Assurance maladie",{"v":12500,"d":"$12,500"}]
[{"$nulls":20},"Prêt immobilier/Loyer",{"v":15000,"d":"$15,000"}]
[{"$nulls":20},"Total général",{"v":46500,"d":"$46,500"}]

{"sheet":"Revenu","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL"]
[null,null,"Total des flux de trésorerie à ce jour :",{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":42250,"d":"42,250.00 $"}},null,"Il s’agit d’une estimation annuelle. Cette feuille de calcul vous permet de consulter les montants annuels avec des valeurs mensuelles estimées.\nSi vous souhaitez ajouter des postes quotidiens à la table, estimez le montant ou la valeur annuel, et placez cette valeur dans la colonne Annuel appropriée."]
[]
[null,"Revenus","Annuel  ","Mensuel "]
[null,"Salaire",{"v":90000,"d":"90,000.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":7500,"d":"7,500.00 $"}}]
[null,"Commissions/Primes",{"v":5000,"d":"5,000.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":416.6666666666667,"d":"416.67 $"}}]
[null,"Divers 1",{"v":30000,"d":"30,000.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":2500,"d":"2,500.00 $"}}]
[null,"Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Divers 3",{"v":0,"d":"0.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Divers 4",{"v":0,"d":"0.00 $"},{"$f":"Revenu[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Revenu[[Annuel  ]])","v":{"v":125000,"d":"125,000.00 $"}},{"$f":"SUBTOTAL(109,Revenu[[Mensuel ]])","v":{"v":10416.666666666668,"d":"10,416.67 $"}}]

{"sheet":"Dépenses","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL"]
[null,null,"Total des flux de trésorerie à ce jour :",{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":42250,"d":"42,250.00 $"}},null,"Il s’agit d’une estimation annuelle. Cette feuille de calcul vous permet de consulter les montants annuels avec des valeurs mensuelles estimées\nSi vous souhaitez ajouter des postes quotidiens à la table, estimez le montant ou la valeur annuel, et placez cette valeur dans la colonne Annuel appropriée."]
[]
[null,"Dépenses","Annuel  ","Mensuel "]
[null,"Assurance maladie",{"v":12500,"d":"12,500.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":1041.6666666666667,"d":"1,041.67 $"}}]
[null,"Impôts sur les revenus",{"v":2500,"d":"2,500.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":208.33333333333334,"d":"208.33 $"}}]
[null,"Taxe automobile/Frais",{"v":200,"d":"200.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":16.666666666666668,"d":"16.67 $"}}]
[null,"Prêt automobile",{"v":4000,"d":"4,000.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":333.3333333333333,"d":"333.33 $"}}]
[null,"Prêt immobilier/Loyer",{"v":15000,"d":"15,000.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":1250,"d":"1,250.00 $"}}]
[null,"Assurance",{"v":250,"d":"250.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":20.833333333333332,"d":"20.83 $"}}]
[null,"Électricité",{"v":1200,"d":"1,200.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 $"}}]
[null,"Gaz",{"v":600,"d":"600.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Eau/assainissement",{"v":600,"d":"600.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Ordures ménagères",{"v":150,"d":"150.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":12.5,"d":"12.50 $"}}]
[null,"Téléphone",{"v":600,"d":"600.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Internet",{"v":600,"d":"600.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Primes d’invalidité",{"v":1500,"d":"1,500.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":125,"d":"125.00 $"}}]
[null,"Nourriture",{"v":5000,"d":"5,000.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":416.6666666666667,"d":"416.67 $"}}]
[null,"Habillement",{"v":1200,"d":"1,200.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 $"}}]
[null,"Soins médicaux/dentaires/Pharmacie",{"v":600,"d":"600.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Divers 1",{"v":0,"d":"0.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses[[Annuel  ]])","v":{"v":46500,"d":"46,500.00 $"}},{"$f":"SUBTOTAL(109,Dépenses[[Mensuel ]])","v":{"v":3875,"d":"3,875.00 $"}}]

{"sheet":"Dépenses discrétionnaires","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL"]
[null,null,"Total des flux de trésorerie à ce jour :",{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":42250,"d":"42,250.00 $"}},null,"Il s’agit d’une estimation annuelle. Cette feuille de calcul vous permet de consulter les montants annuels avec des valeurs mensuelles estimées\nSi vous souhaitez ajouter des postes quotidiens à la table, estimez le montant ou la valeur annuel, et placez cette valeur dans la colonne Annuel appropriée."]
[]
[null,"Dépenses","Annuel  ","Mensuel "]
[null,"Restaurants",{"v":1200,"d":"1,200.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 $"}}]
[null,"Cadeaux",{"v":600,"d":"600.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Déplacements",{"v":2250,"d":"2,250.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":187.5,"d":"187.50 $"}}]
[null,"Loisirs",{"v":1200,"d":"1,200.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 $"}}]
[null,"Soins personnels",{"v":300,"d":"300.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":25,"d":"25.00 $"}}]
[null,"Achats",{"v":2000,"d":"2,000.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":166.66666666666666,"d":"166.67 $"}}]
[null,"Dons",{"v":600,"d":"600.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 $"}}]
[null,"Club/Abonnements",{"v":300,"d":"300.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":25,"d":"25.00 $"}}]
[null,"Rénovations",{"v":4800,"d":"4,800.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":400,"d":"400.00 $"}}]
[null,"Divers 1",{"v":0,"d":"0.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Discrétionnaire[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Discrétionnaire[[Annuel  ]])","v":{"v":13250,"d":"13,250.00 $"}},{"$f":"SUBTOTAL(109,Discrétionnaire[[Mensuel ]])","v":{"v":1104.1666666666665,"d":"1,104.17 $"}}]

{"sheet":"Épargne","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"FLUX DE TRÉSORERIE PERSONNEL",{"$nulls":7}," "]
[null,null,"Total des flux de trésorerie à ce jour :",{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":42250,"d":"42,250.00 $"}},null,"Il s’agit d’une estimation annuelle. Cette feuille de calcul vous permet de consulter les montants annuels avec des valeurs mensuelles estimées\nSi vous souhaitez ajouter des postes quotidiens à la table, estimez le montant ou la valeur annuel, et placez cette valeur dans la colonne Annuel appropriée."]
[]
[null,"Épargne","Annuel  ","Mensuel "]
[null,"Réserves de trésorerie",{"v":5000,"d":"5,000.00 $"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":416.6666666666667,"d":"416.67 $"}}]
[null,"401(k)/Etc",{"v":12000,"d":"12,000.00 $"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":1000,"d":"1,000.00 $"}}]
[null,"Épargne/investissement",{"v":6000,"d":"6,000.00 $"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":500,"d":"500.00 $"}}]
[null,"Divers 1",{"v":0,"d":"0.00 $"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Divers 2",{"v":0,"d":"0.00 $"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Épargne[[Annuel  ]])","v":{"v":23000,"d":"23,000.00 $"}},{"$f":"SUBTOTAL(109,Épargne[[Mensuel ]])","v":{"v":1916.6666666666667,"d":"1,916.67 $"}}]