{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Début","Planificateur de budget fêtes"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Début","index":0,"n_rows":4,"n_cols":2,"rows_kept":4}
[null,"Comment utiliser ce modèle"]
[null,"Suivez vos dépenses avec ce planificateur de budget fêtes."]
[null,"Pour commencer, entrez votre budget et dépenses réelles sur chaque table de catégories."]
[null,"Le programme calcule automatiquement le budget fêtes, le total réellement dépenséet la Écart à votre place."]

{"sheet":"Planificateur de budget fêtes","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"merged":[[0,2,5,7],[2,10,2,11],[8,2,8,5],[8,10,8,13],[18,2,18,5],[18,10,18,13],[29,2,29,5],[29,10,29,13]]}
[null,null,"Planificateur de budget \nfêtes"]
[]
[{"$nulls":10},"BUDGET FÊTES",null,null,{"$f":"SUM(Cadeaux[Budget],Emballage[Budget],(Voyage[Budget],(Repas[Budget],(Loisirs[Budget],Divers[Budget]))))","v":{"v":750,"d":"750.00 €"}}]
[{"$nulls":10},"DÉPENSES RÉELLES",null,null,{"$f":"SUM((Cadeaux[Réel],(Emballage[Réel],(Voyage[Réel],(Repas[Réel],(Loisirs[Réel],(Divers[Réel])))))))","v":{"v":820,"d":"820.00 €"}}]
[]
[{"$nulls":10},"ÉCART (positive/négative par rapport au budget)",null,null,{"$f":"SUM(N3-N4)","v":{"v":-70,"d":"-70.00 €"}}]
[]
[]
[null,null,"CADEAUX",{"$nulls":7},"REPAS DE VACANCES"]
[null,null,"Élément","Budget","Réel","Écart",{"$nulls":4},"Élément","Budget","Réel","Écart"]
[null,null,"Famille",{"v":500,"d":"500.00 €"},{"v":495,"d":"495.00 €"},{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":5,"d":"5.00 €"}},{"$nulls":4},"Provisions",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Amis",{"v":250,"d":"250.00 €"},{"v":325,"d":"325.00 €"},{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":-75,"d":"-75.00 €"}},{"$nulls":4},"Boissons alcoolisées",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Collègues",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Décorations",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Enseignants, nounou, baby-sitter, etc.",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Dons de bienfaisance",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":7},{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Cadeaux[Budget])","v":{"v":750,"d":"750.00 €"}},{"$f":"SUBTOTAL(109,Cadeaux[Réel])","v":{"v":820,"d":"820.00 €"}},{"$f":"SUBTOTAL(109,Cadeaux[Écart])","v":{"v":-70,"d":"-70.00 €"}},{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Repas[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Repas[Réel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Repas[Écart])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"EMBALLAGE",{"$nulls":7},"LOISIRS"]
[null,null,"Élément","Budget","Réel","Écart",{"$nulls":4},"Élément","Budget","Réel","Écart"]
[null,null,"Papier cadeau",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Aide au service (barman, traiteur, etc.)",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Étiquettes",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Décorations",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Fournitures (ruban, papier collant, etc.)",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Nourriture et boissons",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Boîtes",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Habillement",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Affranchissement",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Billets",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Repas à l’extérieur",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":10},"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Emballage[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Emballage[Réel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Emballage[Écart])","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Loisirs[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Loisirs[Réel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Loisirs[Écart])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,null,"VOYAGE",{"$nulls":7},"DIVERS"]
[null,null,"Élément","Budget","Réel","Écart",{"$nulls":4},"Élément","Budget","Réel","Écart"]
[null,null,"Avion",null,null,{"$f":"Voyage[[#This Row],[Budget]]-Voyage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Photos",null,null,{"$f":"Divers[[#This Row],[Budget]]-Divers[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Hébergement",null,null,{"$f":"Voyage[[#This Row],[Budget]]-Voyage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Essence ",null,null,{"$f":"Divers[[#This Row],[Budget]]-Divers[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Transports",null,null,{"$f":"Voyage[[#This Row],[Budget]]-Voyage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Divers[[#This Row],[Budget]]-Divers[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Voyage[[#This Row],[Budget]]-Voyage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Voyage[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Voyage[Réel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Voyage[Écart])","v":{"v":0,"d":"0.00 €"}},{"$nulls":4},"Total",{"$f":"SUBTOTAL(109,Divers[Budget])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Divers[Réel])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Divers[Écart])","v":{"v":0,"d":"0.00 €"}}]