{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Guide","Flux de trésorerie annuels","Flux de trésorerie mensuels","Récapitulatif quotidien","Revenus","Dépenses","Dépenses discrétionnaires","Épargne"],"not_rendered":{"charts":4,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[{"$nulls":6},"GUIDE","REVENUS"]
[null,"FLUX DE TRÉSORERIE PERSONNELS"]
[null,"Ce classeur contient une feuille de calcul qui permet de suivre les flux de trésorerie annuels, mensuels et quotidiens.  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 annuels",null,"Flux de trésorerie mensuels",null,"Flux de trésorerie quotidiens"]
[null,"Entrez le montant des flux de trésorerie annuels en lien avec différents aspects. Consultez les détails mensuels et le comparatif des différentes valeurs, et ce qu’il faut retenir de vos chiffres annuels et mensuels.",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,"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."]

{"sheet":"Flux de trésorerie annuels","index":1,"n_rows":6,"n_cols":15,"rows_kept":6,"merged":[[0,1,0,5],[0,7,0,8],[1,1,1,2],[1,3,1,5],[1,6,1,15],[2,1,2,3],[2,5,2,7],[2,9,2,11],[2,13,2,15],[3,2,3,3],[3,6,3,7],[3,10,3,11],[3,14,3,15],[4,1,4,3],[4,5,4,7],[4,9,4,11],[4,13,4,15],[5,2,5,3],[5,6,5,7],[5,10,5,11],[5,14,5,15]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":4},"GUIDE","FLUX DE TRÉSORERIE ANNUELS",null,"FLUX DE TRÉSORERIE \nMENSUELS"]
[null,"Total des flux de trésorerie à ce jour :",null,{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":39750,"d":"39,750.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 autres feuilles de calcul pour ajouter des postes quotidiens."]
[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 année :",{"$f":"Revenus!C10","v":{"v":125000,"d":"125,000.00 €"}},null,null,"Total année :",{"$f":"Dépenses[[#Totals],[Annuel  ]]","v":{"v":49000,"d":"49,000.00 €"}},null,null,"Total année :",{"$f":"Dépenses_discrétionnaires[[#Totals],[Annuel  ]]","v":{"v":13250,"d":"13,250.00 €"}},null,null,"Total année :",{"$f":"Épargne[[#Totals],[Annuel  ]]","v":{"v":23000,"d":"23,000.00 €"}}]
[null,"Un graphique en secteurs montrant les revenus de différentes sources figure dans cette cellule.",{"$nulls":3},"Un graphique en secteurs montrant les dépenses engagées figure dans cette cellule.",{"$nulls":3},"Un graphique en secteurs montrant les dépenses discrétionnaires figure dans cette cellule.",{"$nulls":3},"Un graphique en secteurs montrant l’épargne et les investissements figure dans cette cellule."]
[null,"Total mois :",{"$f":"Revenus!D10","v":{"v":10416.666666666668,"d":"10,416.67 €"}},null,null,"Total mois :",{"$f":"Dépenses[[#Totals],[Mensuel ]]","v":{"v":4083.333333333333,"d":"4,083.33 €"}},null,null,"Total mois :",{"$f":"Dépenses_discrétionnaires[[#Totals],[Mensuel ]]","v":{"v":1104.1666666666665,"d":"1,104.17 €"}},null,null,"Total mois :",{"$f":"Épargne!D9","v":{"v":1916.6666666666667,"d":"1,916.67 €"}}]

{"sheet":"Flux de trésorerie mensuels","index":2,"n_rows":47,"n_cols":16,"rows_kept":47,"merged":[[0,1,0,6],[1,1,1,2],[1,3,1,4],[1,5,1,15],[47,1,47,15]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":5},"GUIDE","FLUX DE TRÉSORERIE ANNUELS","FLUX DE TRÉSORERIE MENSUELS","RÉCAPITULATIF QUOTIDIEN"]
[null,"Total des flux de trésorerie mensuels :",null,{"$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é."]
[null,"Type","Description","Jan.","Fév.","Mar.","Avr.","Mai","Juin","Juil.","Août","Sept.","Oct.","Nov.","Déc.","Total"]
[null,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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","Prime assurance vie/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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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,"Dépenses discrétionnaires","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","Épargne retraite",{"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/placement",{"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],\"Revenus\",Mensuel[Jan.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Jan.])","v":{"v":3692.5,"d":"3,692.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Fév.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Fév.])","v":{"v":3247.5,"d":"3,247.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Mar.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Mar.])","v":{"v":2522.5,"d":"2,522.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Avr.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Avr.])","v":{"v":3427.5,"d":"3,427.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Mai])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Mai])","v":{"v":2887.5,"d":"2,887.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Juin])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Juin])","v":{"v":2602.5,"d":"2,602.50 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Juil.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Juil.])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Août])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Août])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Sept.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Sept.])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Oct.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Oct.])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Nov.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Nov.])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Déc.])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Déc.])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF(Mensuel[Type],\"Revenus\",Mensuel[Total])-SUMIF(Mensuel[Type],\"<>Revenus\",Mensuel[Total])","v":{"v":18380,"d":"18,380.00 €"}}]

{"sheet":"Récapitulatif quotidien","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,1,12]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":3},"GUIDE","FLUX DE TRÉSORERIE \nMENSUELS","RÉCAPITULATIF QUOTIDIEN","REVENUS"]
[null,"Total de la trésorerie disponible :",null,{"$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,"Revenus",{"$f":"SUMIF(Quotidien[Type],$B5,Quotidien[Quotidien])","v":{"v":342.47,"d":"342.47 €"}},{"$f":"SUMIF(Quotidien[Type],$B5,Quotidien[Mensuel])","v":{"v":10416.795833333334,"d":"10,416.80 €"}},{"$f":"SUMIF(Quotidien[Type],$B5,Quotidien[Annuel])","v":{"v":125001.55000000002,"d":"125,001.55 €"}}]
[null,"Dépenses",{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Quotidien])","v":{"v":136.05999999999997,"d":"136.06 €"}},{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Mensuel])","v":{"v":4138.491666666667,"d":"4,138.49 €"}},{"$f":"SUMIF(Quotidien[Type],$B6,Quotidien[Annuel])","v":{"v":49661.899999999994,"d":"49,661.90 €"}}]
[null,"Dépenses_discrétionnaires",{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Quotidien])","v":{"v":36.29,"d":"36.29 €"}},{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Mensuel])","v":{"v":1103.8208333333334,"d":"1,103.82 €"}},{"$f":"SUMIF(Quotidien[Type],$B7,Quotidien[Annuel])","v":{"v":13245.849999999999,"d":"13,245.85 €"}}]
[null,"Épargne",{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Quotidien])","v":{"v":63.019999999999996,"d":"63.02 €"}},{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Mensuel])","v":{"v":1916.8583333333333,"d":"1,916.86 €"}},{"$f":"SUMIF(Quotidien[Type],$B8,Quotidien[Annuel])","v":{"v":23002.300000000003,"d":"23,002.30 €"}}]
[null,"Type","Description","Quotidien","Mensuel","Annuel"]
[null,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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,"Revenus","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","Prime assurance vie/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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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,"Dépenses_discrétionnaires","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","Épargne retraite",{"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/placement",{"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],\"Revenus\",Quotidien[Quotidien])-SUMIF(Quotidien[Type],\"<>Revenus\",Quotidien[Quotidien])","v":{"v":107.10000000000014,"d":"107.10 €"}},{"$f":"SUMIF(Quotidien[Type],\"Revenus\",Quotidien[Mensuel])-SUMIF(Quotidien[Type],\"<>Revenus\",Quotidien[Mensuel])","v":{"v":3257.625,"d":"3,257.63 €"}},{"$f":"SUMIF(Quotidien[Type],\"Revenus\",Quotidien[Annuel])-SUMIF(Quotidien[Type],\"<>Revenus\",Quotidien[Annuel])","v":{"v":39091.500000000015,"d":"39,091.50 €"}}]

{"sheet":"Revenus","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":3},"GUIDE","RÉCAPITULATIF QUOTIDIEN","REVENUS","DÉPENSES"]
[null,"Total des flux de trésorerie à ce jour :",null,{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":39750,"d":"39,750.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":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":7500,"d":"7,500.00 €"}}]
[null,"Commissions/Primes",{"v":5000,"d":"5,000.00 €"},{"$f":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":416.6666666666667,"d":"416.67 €"}}]
[null,"Divers 1",{"v":30000,"d":"30,000.00 €"},{"$f":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":2500,"d":"2,500.00 €"}}]
[null,"Divers 2",null,{"$f":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Divers 3",null,{"$f":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Divers 4",null,{"$f":"Revenus[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Revenus[[Annuel  ]])","v":{"v":125000,"d":"125,000.00 €"}},{"$f":"SUBTOTAL(109,Revenus[[Mensuel ]])","v":{"v":10416.666666666668,"d":"10,416.67 €"}}]

{"sheet":"Dépenses","index":5,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":3},"GUIDE","REVENUS","DÉPENSES","DÉPENSES DISCRÉTIONNAIRES"]
[null,"Total des flux de trésorerie à ce jour :",null,{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":39750,"d":"39,750.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":15000,"d":"15,000.00 €"},{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":1250,"d":"1,250.00 €"}}]
[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,"Prime assurance vie/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",null,{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Divers 2",null,{"$f":"Dépenses[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses[[Annuel  ]])","v":{"v":49000,"d":"49,000.00 €"}},{"$f":"SUBTOTAL(109,Dépenses[[Mensuel ]])","v":{"v":4083.333333333333,"d":"4,083.33 €"}}]

{"sheet":"Dépenses discrétionnaires","index":6,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":3},"GUIDE","DÉPENSES","DÉPENSES DISCRÉTIONNAIRES","ÉPARGNE"]
[null,"Total des flux de trésorerie à ce jour :",null,{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":39750,"d":"39,750.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 discrétionnaires","Annuel  ","Mensuel "]
[null,"Restaurants",{"v":1200,"d":"1,200.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Cadeaux",{"v":600,"d":"600.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Déplacements",{"v":2250,"d":"2,250.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":187.5,"d":"187.50 €"}}]
[null,"Loisirs",{"v":1200,"d":"1,200.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":100,"d":"100.00 €"}}]
[null,"Soins personnels",{"v":300,"d":"300.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Achats",{"v":2000,"d":"2,000.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":166.66666666666666,"d":"166.67 €"}}]
[null,"Dons",{"v":600,"d":"600.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":50,"d":"50.00 €"}}]
[null,"Club/Abonnements",{"v":300,"d":"300.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":25,"d":"25.00 €"}}]
[null,"Rénovations",{"v":4800,"d":"4,800.00 €"},{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":400,"d":"400.00 €"}}]
[null,"Divers 1",null,{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Divers 2",null,{"$f":"Dépenses_discrétionnaires[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Dépenses_discrétionnaires[[Annuel  ]])","v":{"v":13250,"d":"13,250.00 €"}},{"$f":"SUBTOTAL(109,Dépenses_discrétionnaires[[Mensuel ]])","v":{"v":1104.1666666666665,"d":"1,104.17 €"}}]

{"sheet":"Épargne","index":7,"n_rows":9,"n_cols":8,"rows_kept":9,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[1,5,2,10]]}
[null,"FLUX DE TRÉSORERIE PERSONNELS",{"$nulls":3},"GUIDE","DÉPENSES DISCRÉTIONNAIRES","ÉPARGNE"]
[null,"Total des flux de trésorerie à ce jour :",null,{"$f":"FluxTrésorerieAnnuelsÀCeJour","v":{"v":39750,"d":"39,750.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,"Épargne retraite",{"v":12000,"d":"12,000.00 €"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":1000,"d":"1,000.00 €"}}]
[null,"Épargne/placement",{"v":6000,"d":"6,000.00 €"},{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":500,"d":"500.00 €"}}]
[null,"Divers 1",null,{"$f":"Épargne[[#This Row],[Annuel  ]]/12","v":{"v":0,"d":"0.00 €"}}]
[null,"Divers 2",null,{"$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 €"}}]