{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["À propos","Roue budgétaire","Data"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"À propos","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"À propos du modèle"]
[null,"Ce modèle permet d’effectuer le suivi de vos dépenses et votre épargne mensuelles."]
[null,"Entrez le détail des dépenses dans le tableau ainsi que votre revenu mensuel pour calculer votre épargne."]
[null,"Le graphique en anneau illustre les dépenses et l'épargne, et se met à jour automatiquement."]
[null,"Remarque :"]
[null,"Des instructions supplémentaires sont fournies dans la colonne A de la feuille de calcul ROUE BUDGÉTAIRE. Ce texte a été intentionnellement masqué. Pour supprimer ce texte, sélectionnez la colonne A, puis sélectionnez SUPPRIMER. Pour afficher le texte, sélectionnez la colonne A, puis modifiez la couleur de la police."]
[null,"Pour en apprendre davantage sur le tableau, appuyez sur MAJ puis sur F10 dans le tableau, sélectionnez l'option TABLE, puis sélectionnez TEXTE DE REMPLACEMENT."]

{"sheet":"Roue budgétaire","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"merged":[[0,1,0,2],[0,3,0,6],[1,2,4,4]]}
["Cette feuille de calcul permet de créer une roue budgétaire. La cellule B1 contient son titre. La cellule C1 contient quelques informations sur son utilisation. Vous en trouverez d’autres dans cette colonne (A). Pour les consulter, appuyez sur la touche fléchée vers le bas de votre clavier.","Roue budgétaire",null,"Remplissez le tableau dans ce modèle. Le graphique affichera vos dépenses mensuelles en relation avec votre revenu mensuel. Il calculera également les pourcentages pour vous montrer dans quelle mesure vous avez épargné."]
["La cellule B1, à droite de celle-ci, contient l’étiquette Revenu mensuel. La cellule C2 contient le graphique en anneau représentant vos dépenses et votre épargne. Enfin, la cellule G2 contient l’étiquette Montant de l'épargne.","Revenu\nmensuel","Cette cellule contient le graphique en anneau représentant vos dépenses et votre épargne.",{"$nulls":3},"Montant de l’épargne\nde l'épargne"]
["Entrez votre revenu mensuel dans la cellule B3. Le montant de votre épargne est calculé automatiquement et affiché dans la cellule G3. L’instruction suivante est dans la cellule A6.",{"v":5738,"d":"5,738 €"},{"$nulls":4},{"$f":"Savings","v":{"v":2777,"d":"2,777 €"}}]
[{"$nulls":6},"Valeur calculée \nautomatiquement"]
[]
["Entrez le détail de vos dépenses dans le tableau ci-contre.","Dépenses","Catégorie","Montant","Fréquence","Montant mensuel","% du Total"]
[null,"Assurance","Transport",{"v":300,"d":"300 €"},"Tous les 6 mois",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":50,"d":"50 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.00871383757406762,"d":"1%"}}]
[null,"Essence","Transport",{"v":25,"d":"25 €"},"Hebdomadaire",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Remboursement voiture","Transport",{"v":200,"d":"200 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":200,"d":"200 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.03485535029627048,"d":"3%"}}]
[null,"Prêt immobilier","Logement",{"v":1600,"d":"1,600 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":1600,"d":"1,600 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.27884280237016384,"d":"28%"}}]
[null,"Câble","Logement",{"v":60,"d":"60 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Soirée cinéma","Divertissement",{"v":70,"d":"70 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"70 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Baskets","Divers",{"v":300,"d":"300 €"},"Annuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":25,"d":"25 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.00435691878703381,"d":"0%"}}]
[null,"Nourriture chien","Divers",{"v":60,"d":"60 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Assurance des animaux","Divers",{"v":70,"d":"70 €"},"Annuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":6,"d":"6 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":1.0456605088881143E-3,"d":"0%"}}]
[null,"Provisions","Aliments",{"v":100,"d":"100 €"},"Hebdomadaire",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":400,"d":"400 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.06971070059254096,"d":"7%"}}]
[null,"Café","Aliments",{"v":25,"d":"25 €"},"Hebdomadaire",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Matériel d'escalade","Divertissement",{"v":170,"d":"170 €"},"Annuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":14,"d":"14 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":2.4398745207389336E-3,"d":"0%"}}]
[null,"Abonnement club de sport","Divers",{"v":60,"d":"60 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":60,"d":"60 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.010456605088881143,"d":"1%"}}]
[null,"Écouteurs","Divertissement",{"v":50,"d":"50 €"},"Annuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":4,"d":"4 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":6.9710700592540956E-4,"d":"0%"}}]
[null,"Coupe de cheveux","Divers",{"v":70,"d":"70 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":70,"d":"70 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.012199372603694667,"d":"1%"}}]
[null,"Jeux vidéo","Divertissement",{"v":100,"d":"100 €"},"Mensuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":100,"d":"100 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":0.01742767514813524,"d":"2%"}}]
[null,"Vêtements","Divers",{"v":500,"d":"500 €"},"Annuelle",{"$f":"IF(Expenses[[#This Row],[Montant]]>0,IF(Expenses[[#This Row],[Fréquence]]<>\"\",ROUND(IF(Expenses[[#This Row],[Fréquence]]=\"Mensuelle\",Expenses[Montant],IF(Expenses[[#This Row],[Fréquence]]=\"Hebdomadaire\",Expenses[[#This Row],[Montant]]*4,IF(Expenses[[#This Row],[Fréquence]]=\"Trimestrielle\",Expenses[[#This Row],[Montant]]/3,IF(Expenses[[#This Row],[Fréquence]]=\"Tous les 6 mois\",Expenses[[#This Row],[Montant]]/6,IF(Expenses[[#This Row],[Fréquence]]=\"Annuelle\",Expenses[[#This Row],[Montant]]/12,IF(Expenses[[#This Row],[Fréquence]]=\"Toutes les deux semaines\",Expenses[[#This Row],[Montant]]*2,IF(Expenses[[#This Row],[Fréquence]]=\"Aux deux mois\",Expenses[[#This Row],[Montant]]/2,\"\"))))))),0),\"\"),\"\")","v":{"v":42,"d":"42 €"}},{"$f":"IF(Expenses[[#This Row],[Montant mensuel]]<>\"\",Expenses[[#This Row],[Montant mensuel]]/Income,\"\")","v":{"v":7.3196235622168E-3,"d":"1%"}}]

{"sheet":"Data","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"hidden":true}
["Cette feuille devrait rester cachée"]
["Catégories","Montant par catégorie","Pourcentage du total","Fréquence","Économies"]
["Logement",{"$f":"IF(SUMIF(Expenses[Catégorie],\"Logement\",Expenses[Montant mensuel])>0,SUMIF(Expenses[Catégorie],\"Logement\",Expenses[Montant mensuel]),NA())","v":{"v":1660,"d":"1,660 €"}},{"$f":"IF(B3>0,B3/Income,\"\")","v":{"v":0.289299407459045,"d":"29%"}},"Hebdomadaire",{"$f":"Income-SUM(Expenses[Montant mensuel])","v":{"v":2777,"d":"2,777 €"}}]
["Divertissement",{"$f":"IF(SUMIF(Expenses[Catégorie],\"Divertissement\",Expenses[Montant mensuel])>0,SUMIF(Expenses[Catégorie],\"Divertissement\",Expenses[Montant mensuel]),NA())","v":{"v":188,"d":"188 €"}},{"v":0.03276402927849425,"d":"3%"},"Mensuelle"]
["Transport",{"$f":"IF(SUMIF(Expenses[Catégorie],\"Transport\",Expenses[Montant mensuel])>0,SUMIF(Expenses[Catégorie],\"Transport\",Expenses[Montant mensuel]),NA())","v":{"v":350,"d":"350 €"}},{"v":0.06099686301847333,"d":"6%"},"Trimestrielle"]
["Aliments",{"$f":"IF(SUMIF(Expenses[Catégorie],\"Aliments\",Expenses[Montant mensuel])>0,SUMIF(Expenses[Catégorie],\"Aliments\",Expenses[Montant mensuel]),NA())","v":{"v":500,"d":"500 €"}},{"v":0.08713837574067619,"d":"9%"},"Tous les 6 mois"]
["Divers",{"$f":"IF(SUMIF(Expenses[Catégorie],\"Divers\",Expenses[Montant mensuel])>0,SUMIF(Expenses[Catégorie],\"Divers\",Expenses[Montant mensuel]),NA())","v":{"v":263,"d":"263 €"}},{"v":0.04583478563959568,"d":"5%"},"Annuelle"]
["Économies",{"$f":"IF(E3>0,E3,NA())","v":{"v":2777,"d":"2,777 €"}},{"v":0.4839665388637156,"d":"48%"},"Toutes les 2 semaines"]
[{"$nulls":3},"Tous les 2 mois"]
[null,"TOTAL:",{"$f":"SUM(C3:C8)","v":{"v":1,"d":"100%"}}]