{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Tableau de bord","Journal des dépenses","Données dépenses personnelles"],"not_rendered":{"charts":1,"images":1,"defined_names":5,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Tableau de bord","index":0,"n_rows":3,"n_cols":6,"rows_kept":3,"merged":[[0,2,0,4],[1,1,1,5],[2,1,2,2],[2,3,2,4]]}
[null,null,"Tableau de bord des dépenses personnelles",null,null,"vers le journal des dépenses >"]
[null,"Cette cellule contient un graphique croisé dynamique (PivotChart) qui présente les dépenses par catégorie et par mois. Des segments pour filtrer les dépenses par date, catégories et sous-catégories figurent dans les cellules B3, D3 et F3 ci-dessous."]
[null,"Cette cellule contient un segment qui permet de filtrer les données du tableau par date.",null,"Cette cellule contient un segment qui permet de filtrer les données du tableau par catégorie.",null,"Cette cellule contient un segment qui permet de filtrer les données du tableau par sous-catégorie."]

{"sheet":"Journal des dépenses","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[0,1,0,4]]}
[null,"Journal des dépenses",{"$nulls":3},"< vers le tableau de bord"]
[null,"Date","Catégorie","Sous-catégorie","Montant","Note"]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Logement","Internet",{"v":29,"d":"29.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,2)","v":"2019-03-02"},"Logement","Téléphone filaire",{"v":39,"d":"39.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Logement","Électricité",{"v":62,"d":"62.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,4)","v":"2019-03-04"},"Loisirs","Salle de sport",{"v":29,"d":"29.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Quotidien","Habillement",{"v":42,"d":"42.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),3,6)","v":"2019-03-06"},"Transport","Carte de métro",{"v":21,"d":"21.00 $"},"Carte du mois de mars"]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Transport","Carburant",{"v":54,"d":"54.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,2)","v":"2019-04-02"},"Quotidien","Coiffeur",{"v":12,"d":"12.00 $"}]
[null,"2019-04-02","Quotidien","Thé/Café",{"v":12,"d":"12.00 $"}]
[null,"2019-04-02","Quotidien","Friandises",{"v":2.75,"d":"2.75 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Logement","Internet",{"v":29,"d":"29.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Logement","Téléphone filaire",{"v":39,"d":"39.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Logement","Électricité",{"v":62,"d":"62.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,4)","v":"2019-04-04"},"Quotidien","Lentilles de contact",{"v":29,"d":"29.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Quotidien","Habillement",{"v":42,"d":"42.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),4,6)","v":"2019-04-06"},"Transport","Carte de métro",{"v":21,"d":"21.00 $"},"Carte du mois de avril"]
[null,{"$f":"DATE(YEAR(TODAY()),5,1)","v":"2019-05-01"},"Transport","Carburant",{"v":54,"d":"54.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2019-06-01"},"Quotidien","Coiffeur",{"v":12,"d":"12.00 $"}]
[null,{"$f":"DATE(YEAR(TODAY()),7,1)","v":"2019-07-01"},"Loisirs","Cinéma",{"v":21,"d":"21.00 $"},"Soirée de films classiques"]
[null,{"$f":"DATE(YEAR(TODAY()),8,1)","v":"2019-08-01"},"Quotidien","Friandises",{"v":2.75,"d":"2.75 $"}]

{"sheet":"Données dépenses personnelles","index":2,"n_rows":21,"n_cols":3,"rows_kept":21,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3]]}
[null,"données dépenses personnelles"]
[null,"Le tableau croisé dynamique ci-dessous constitue la source de données du graphique croisé dynamique Dépenses personnelles figurant dans le tableau de bord. Toutes les modifications apportées peuvent entraîner des modifications visibles dans le graphique croisé dynamique ou des erreurs."]
[null,"Étiquettes de lignes","Somme des montants"]
[null,"mars",{"v":222,"d":"222.00 $"}]
[null,"Loisirs",{"v":29,"d":"29.00 $"}]
[null,"Transport",{"v":21,"d":"21.00 $"}]
[null,"Quotidien",{"v":42,"d":"42.00 $"}]
[null,"Logement",{"v":130,"d":"130.00 $"}]
[null,"avr",{"v":302.75,"d":"302.75 $"}]
[null,"Transport",{"v":75,"d":"75.00 $"}]
[null,"Quotidien",{"v":97.75,"d":"97.75 $"}]
[null,"Logement",{"v":130,"d":"130.00 $"}]
[null,"mai",{"v":54,"d":"54.00 $"}]
[null,"Transport",{"v":54,"d":"54.00 $"}]
[null,"juin",{"v":12,"d":"12.00 $"}]
[null,"Quotidien",{"v":12,"d":"12.00 $"}]
[null,"juil",{"v":21,"d":"21.00 $"}]
[null,"Loisirs",{"v":21,"d":"21.00 $"}]
[null,"août",{"v":2.75,"d":"2.75 $"}]
[null,"Quotidien",{"v":2.75,"d":"2.75 $"}]
[null,"Total général",{"v":614.5,"d":"614.50 $"}]