{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Synthèse des finances","Dépenses en espèces","Synthèse mensuelle","Données du graphique"],"not_rendered":{"charts":2,"defined_names":9,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Synthèse des finances","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[0,1,1,5],[2,1,2,2],[2,3,2,4],[3,1,18,1],[19,1,20,1],[21,1,22,1]]}
[null,"Outil de suivi des finances personnelles"]
[{"$nulls":6},"Dépenses en espèces >"]
[{"$nulls":3},"Synthèse des finances"]
[null,"Cette cellule contient l’histogramme représentant le pourcentage de trésorerie disponible.",null,"Compte","Départ de l’argent comptant","Total des dépenses","Liquidités restantes"]
[{"$nulls":3},"Compte courant",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(ArgentDépensé[Compte],\"=\" &TableauSynthèseFinances[[#This Row],[Compte]],ArgentDépensé[Montant])","v":{"v":496,"d":"496.00"}},{"$f":"TableauSynthèseFinances[[#This Row],[Départ de l’argent comptant]]-TableauSynthèseFinances[[#This Row],[Total des dépenses]]","v":{"v":2504,"d":"2504.00"}}]
[{"$nulls":3},"Épargne",{"v":500,"d":"500.00"},{"$f":"SUMIF(ArgentDépensé[Compte],\"=\" &TableauSynthèseFinances[[#This Row],[Compte]],ArgentDépensé[Montant])","v":{"v":450,"d":"450.00"}},{"$f":"TableauSynthèseFinances[[#This Row],[Départ de l’argent comptant]]-TableauSynthèseFinances[[#This Row],[Total des dépenses]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Autre",{"v":200,"d":"200.00"},{"$f":"SUMIF(ArgentDépensé[Compte],\"=\" &TableauSynthèseFinances[[#This Row],[Compte]],ArgentDépensé[Montant])","v":{"v":30,"d":"30.00"}},{"$f":"TableauSynthèseFinances[[#This Row],[Départ de l’argent comptant]]-TableauSynthèseFinances[[#This Row],[Total des dépenses]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,TableauSynthèseFinances[Départ de l’argent comptant])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,TableauSynthèseFinances[Total des dépenses])","v":{"v":976,"d":"976.00"}},{"$f":"SUBTOTAL(109,TableauSynthèseFinances[Liquidités restantes])","v":{"v":2724,"d":"2724.00"}}]
{"$rows_empty":11}
[null,"Liquidités\nRestant :"]
[]
[null,{"$f":"TableauSynthèseFinances[[#Totals],[Liquidités restantes]]/TableauSynthèseFinances[[#Totals],[Départ de l’argent comptant]]","v":{"v":0.7362162162162162,"d":"74%"}}]

{"sheet":"Dépenses en espèces","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,1,1,3],[2,1,2,2],[3,5,6,6],[7,5,14,6]]}
[null,"Outil de suivi des finances personnelles"]
[{"$nulls":4},"< Synthèse des finances","Synthèse mensuelle >"]
[null,"Dépenses en espèces"]
[null,"Date","Description","Montant","Compte","Cette cellule contient un segment pour filtrer les données de la table par Type de compte."]
[null,{"$f":"TODAY()+105","v":"2023-03-21"},"Retrait DAB",{"v":40,"d":"40.00 $"},"Compte courant"]
[null,{"$f":"TODAY()+106","v":"2023-03-22"},"Déjeuner",{"v":5,"d":"5.00 $"},"Compte courant"]
[null,{"$f":"TODAY()+107","v":"2023-03-23"},"Prêt automobile",{"v":230,"d":"230.00 $"},"Épargne"]
[null,{"$f":"TODAY()+135","v":"2023-04-20"},"Paiement - Électricité",{"v":70,"d":"70.00 $"},"Compte courant","Cette cellule contient un segment pour filtrer les données de la table par Description."]
[null,{"$f":"TODAY()+139","v":"2023-04-24"},"Dîner",{"v":53,"d":"53.00 $"},"Compte courant"]
[null,{"$f":"TODAY()+162","v":"2023-05-17"},"Retrait d’espèces",{"v":100,"d":"100.00 $"},"Épargne"]
[null,{"$f":"TODAY()+167","v":"2023-05-22"},"Prêt automobile",{"v":230,"d":"230.00 $"},"Compte courant"]
[null,{"$f":"TODAY()+198","v":"2023-06-22"},"Paiement - Électricité",{"v":70,"d":"70.00 $"},"Épargne"]
[null,{"$f":"TODAY()+212","v":"2023-07-06"},"Retrait DAB",{"v":30,"d":"30.00 $"},"Compte courant"]
[null,{"$f":"TODAY()+225","v":"2023-07-19"},"Retrait DAB",{"v":50,"d":"50.00 $"},"Épargne"]
[null,{"$f":"TODAY()+232","v":"2023-07-26"},"Retrait DAB",{"v":30,"d":"30.00 $"},"Autre"]
[null,{"$f":"TODAY()+283","v":"2023-09-15"},"Paiement - Électricité",{"v":68,"d":"68.00 $"},"Compte courant"]

{"sheet":"Synthèse mensuelle","index":2,"n_rows":37,"n_cols":6,"rows_kept":37,"merged":[[0,1,1,4],[2,1,2,5],[3,1,3,6],[4,1,16,4],[4,5,8,6],[9,5,16,6],[17,1,17,5]]}
[null,"Synthèse mensuelle"]
[{"$nulls":5},"< Dépenses en espèces"]
[null,"Pour mettre à niveau ces données, commencez par sélectionner le graphique croisé dynamique.  Faites un clic droit pour accéder au menu contextuel.  Sélectionnez Actualiser ou Actualiser tout pour mettre à niveau le graphique."]
[null,"Synthèse des comptes"]
[null,"Cette cellule contient l’histogramme Synthèse des comptes comparant le solde des comptes Courant, Épargne et Autres pour chaque mois.",{"$nulls":3},"Cette cellule contient un segment pour filtrer le graphique par Type de compte."]
[]
[]
[]
[]
[{"$nulls":5},"Cette cellule contient un segment de filtrage du graphique par Description."]
{"$rows_empty":7}
[null,"Synthèse des dépenses"]
[null,"Détails "]
[null,null,"Compte courant","Épargne","Autre","Total général"]
[null,"avr",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"Dîner",{"v":53,"d":"53.00"},null,null,{"v":53,"d":"53.00"}]
[null,"Paiement - Électricité",{"v":70,"d":"70.00"},null,null,{"v":70,"d":"70.00"}]
[null,"juil",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"Retrait DAB",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"juin",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"Paiement - Électricité",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"mai",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"Prêt automobile",{"v":230,"d":"230.00"},null,null,{"v":230,"d":"230.00"}]
[null,"Retrait d’espèces",null,{"v":100,"d":"100.00"},null,{"v":100,"d":"100.00"}]
[null,"mars",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"Retrait DAB",{"v":40,"d":"40.00"},null,null,{"v":40,"d":"40.00"}]
[null,"Prêt automobile",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"Déjeuner",{"v":5,"d":"5.00"},null,null,{"v":5,"d":"5.00"}]
[null,"sept",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Paiement - Électricité",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Total général",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]

{"sheet":"Données du graphique","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,1,0,2]]}
[null,"Données du graphique croisé dynamique"]
[null,"Ce tableau croisé dynamique constitue la source de données du graphique croisé dynamique Synthèse des comptes figurant dans la feuille Synthèse mensuelle"]
[null,"Somme de Montant","Étiquettes de colonnes"]
[null,"Étiquettes de lignes","Compte courant","Épargne","Autre","Total général"]
[null,"mars",{"v":45,"d":"45.00"},{"v":230,"d":"230.00"},null,{"v":275,"d":"275.00"}]
[null,"avr",{"v":123,"d":"123.00"},null,null,{"v":123,"d":"123.00"}]
[null,"mai",{"v":230,"d":"230.00"},{"v":100,"d":"100.00"},null,{"v":330,"d":"330.00"}]
[null,"juin",null,{"v":70,"d":"70.00"},null,{"v":70,"d":"70.00"}]
[null,"juil",{"v":30,"d":"30.00"},{"v":50,"d":"50.00"},{"v":30,"d":"30.00"},{"v":110,"d":"110.00"}]
[null,"sept",{"v":68,"d":"68.00"},null,null,{"v":68,"d":"68.00"}]
[null,"Total général",{"v":496,"d":"496.00"},{"v":450,"d":"450.00"},{"v":30,"d":"30.00"},{"v":976,"d":"976.00"}]