{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Budget Noël","Entrées liste","Informations liste"],"not_rendered":{"charts":1,"images":3,"defined_names":13,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget Noël","index":0,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,1,1,3],[0,4,1,4],[2,1,2,2],[2,3,5,5],[6,4,12,4],[6,5,12,5],[7,3,22,3],[13,4,19,4],[13,5,20,5]]}
[null,"Budget d’achat Noël",null,null,"Cette cellule contient une guirlande lumineuse.","VERS ENTRÉES LISTE >"]
[{"$nulls":5},"VERS INFORMATIONS LISTE >"]
[null,"TOTAUX",null,"Cette cellule contient un graphique à barres groupées montrant la répartition des coûts et le montant dépensé à ce jour."]
[null,"RÉPARTITION DES COÛTS",{"$f":"SUM(DonnéesCadeaux[COÛT])","v":{"v":377,"d":"377.00 €"}}]
[null,"MONTANT DÉPENSÉ À CE JOUR",{"$f":"SUMIF(DonnéesCadeaux[ACHETÉ],\"Acheté\",DonnéesCadeaux[COÛT])","v":{"v":233,"d":"233.00 €"}}]
[null,"DIFFÉRENCE",{"$f":"C4-C5","v":{"v":144,"d":"144.00 €"}}]
[null,"Pour mettre à jour le rapport ci-dessous, Actualiser-le.",null,null,"Cette cellule contient un segment pour filtrer les données de la table sur État d’emballage.","Cette cellule contient un segment pour filtrer les données de la table sur Acheté."]
[null,"RÉPARTITION",null,"Cette cellule contient un segment pour filtrer les données de la table sur Pour."]
[null,null,"Coût du cadeau"]
[null,"Nom 3",{"v":71,"d":"71.00 €"}]
[null,"Acheté"]
[null,"Petit train",{"v":26,"d":"26.00 €"}]
[null,"Puzzle",{"v":16,"d":"16.00 €"}]
[null,"Pas acheté",null,null,"Cette cellule contient un segment pour filtrer les données de la table sur État de livraison.","Cette cellule contient un segment pour filtrer les données de la table sur Catégorie du cadeau."]
[null,"Vélo",{"v":29,"d":"29.00 €"}]
[]
[null,"Nom 2",{"v":59,"d":"59.00 €"}]
[null,"Acheté"]
[null,"Chaussettes",{"v":23,"d":"23.00 €"}]
[null,"Maison de poupée",{"v":36,"d":"36.00 €"}]
[]
[null,"Nom 4",{"v":44,"d":"44.00 €"}]
[null,"Acheté"]
[null,"Matériel de scrapbooking",{"v":14,"d":"14.00 €"}]
[null,"Album photo",{"v":30,"d":"30.00 €"}]
[]
[null,"Nom 5",{"v":118,"d":"118.00 €"}]
[null,"Acheté"]
[null,"Jeu Xbox",{"v":49,"d":"49.00 €"}]
[null,"Pas acheté"]
[null,"Chemise",{"v":37,"d":"37.00 €"}]
[null,"Carte cadeau",{"v":32,"d":"32.00 €"}]
[]
[null,"Nom 1",{"v":39,"d":"39.00 €"}]
[null,"Acheté"]
[null,"Chandail",{"v":39,"d":"39.00 €"}]
[]
[null,"Nom 6",{"v":46,"d":"46.00 €"}]
[null,"Pas acheté"]
[null,"Chaussettes",{"v":46,"d":"46.00 €"}]
[]
[null,"Total général",{"v":377,"d":"377.00 €"}]

{"sheet":"Entrées liste","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,1,1,2],[0,3,1,6]]}
[null,"Liste d’achats",null,"Cette cellule contient une guirlande lumineuse.",{"$nulls":3},"VERS INFORMATIONS LISTE >"]
[{"$nulls":7},"< VERS BUDGET NOËL"]
[null,"POUR","CATÉGORIE DU CADEAU","CADEAU","COÛT","ACHETÉ","ÉTAT DE LIVRAISON","ÉTAT D’EMBALLAGE"]
[null,"Nom 3","Cadeau de la famille","Petit train",{"v":26,"d":"26.00 €"},"Acheté","Arrivé","Emballé"]
[null,"Nom 2","Cadeau général","Chaussettes",{"v":23,"d":"23.00 €"},"Acheté","Arrivé","Emballé"]
[null,"Nom 3","Cadeau général","Puzzle",{"v":16,"d":"16.00 €"},"Acheté","Arrivé","Pas emballé"]
[null,"Nom 4","Cadeau général","Matériel de scrapbooking",{"v":14,"d":"14.00 €"},"Acheté","En transit","Pas emballé"]
[null,"Nom 5","Cadeau général","Jeu Xbox",{"v":49,"d":"49.00 €"},"Acheté","En transit","Pas emballé"]
[null,"Nom 5","Cadeau général","Chemise",{"v":37,"d":"37.00 €"},"Pas acheté","En transit","Pas emballé"]
[null,"Nom 1","Cadeau général","Chandail",{"v":39,"d":"39.00 €"},"Acheté","En transit","Pas emballé"]
[null,"Nom 2","Cadeau général","Maison de poupée",{"v":36,"d":"36.00 €"},"Acheté","Arrivé","Pas emballé"]
[null,"Nom 3","Cadeau général","Vélo",{"v":29,"d":"29.00 €"},"Pas acheté"]
[null,"Nom 4","Cadeau général","Album photo",{"v":30,"d":"30.00 €"},"Acheté","Arrivé"]
[null,"Nom 5","Cadeau général","Carte cadeau",{"v":32,"d":"32.00 €"},"Pas acheté"]
[null,"Nom 6","Cadeau général","Chaussettes",{"v":46,"d":"46.00 €"},"Pas acheté"]

{"sheet":"Informations liste","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,1,1,1],[0,2,1,3]]}
[null,"Informations liste","Cette cellule contient une guirlande lumineuse.",null,"< VERS ENTRÉES LISTE"]
[{"$nulls":4},"< VERS BUDGET NOËL"]
[null,"PERSONNES",null,"CATÉGORIES DE CADEAUX"]
[null,"Nom 1",null,"Bas de Noël"]
[null,"Nom 2",null,"Cadeau général"]
[null,"Nom 3",null,"Cadeau du conjoint"]
[null,"Nom 4",null,"Cadeau de la famille"]
[null,"Nom 5",null,"Cadeau spécial"]
[null,"Nom 6"]