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

{"sheet":"Planificateur de budget fêtes","index":0,"n_rows":37,"n_cols":12,"rows_kept":37,"merged":[[1,1,7,4],[9,1,9,4],[9,8,9,11],[19,1,19,4],[19,8,19,11],[30,1,30,4],[30,8,30,11]]}
[]
[null,"Planificateur de budget fêtes"]
[]
[{"$nulls":8},"BUDGET FÊTES",null,{"$f":"SUM(Cadeaux[Budget],Emballage[Budget],(Déplacements[Budget],(Repas[Budget],(Loisirs[Budget],Divers[Budget]))))","v":{"v":750,"d":"750.00 $"}}]
[{"$nulls":8},"DÉPENSES RÉELLES",null,{"$f":"SUM((Cadeaux[Réel],(Emballage[Réel],(Déplacements[Réel],(Repas[Réel],(Loisirs[Réel],(Divers[Réel])))))))","v":{"v":820,"d":"820.00 $"}}]
[]
[{"$nulls":8},"ÉCART (positif/négatif par rapport au budget)",null,{"$f":"SUM(K4-K5)","v":{"v":-70,"d":"-70.00 $"}}]
[]
[]
[null,"Cadeaux",{"$nulls":6},"Repas"]
[null,"Poste","Budget","Réel","Écart",{"$nulls":3},"Poste","Budget","Réel","Écart"]
[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":3},"Provisions",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[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":3},"Boissons alcoolisées",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Collègues",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Décorations",null,null,{"$f":"Repas[[#This Row],[Budget]]-Repas[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Enseignants, nounou, gardienne d'enfant, etc.",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"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,"Dons de bienfaisance",null,null,{"$f":"Cadeaux[[#This Row],[Budget]]-Cadeaux[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"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,"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,"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 $"}}]
[]
[null,"Emballage",{"$nulls":6},"Loisirs"]
[null,"Poste","Budget","Réel","Écart",{"$nulls":3},"Poste","Budget","Réel","Écart"]
[null,"Papier cadeau",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"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,"Étiquettes",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Décorations",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[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":3},"Nourriture et boissons",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Boîtes",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Habillement",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Affranchissement",null,null,{"$f":"Emballage[[#This Row],[Budget]]-Emballage[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Billets",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[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":3},"Repas à l’extérieur",null,null,{"$f":"Loisirs[[#This Row],[Budget]]-Loisirs[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[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":3},"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 $"}}]
[{"$nulls":8},"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,"Déplacements",{"$nulls":6},"Divers"]
[null,"Poste","Budget","Réel","Écart",{"$nulls":3},"Poste","Budget","Réel","Écart"]
[null,"Avion",null,null,{"$f":"Déplacements[[#This Row],[Budget]]-Déplacements[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Photos",null,null,{"$f":"Divers[[#This Row],[Budget]]-Divers[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Hébergement",null,null,{"$f":"Déplacements[[#This Row],[Budget]]-Déplacements[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"Essence ",null,null,{"$f":"Divers[[#This Row],[Budget]]-Divers[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}}]
[null,"Transports",null,null,{"$f":"Déplacements[[#This Row],[Budget]]-Déplacements[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"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,"Autres (tabulez dans la dernière colonne de cette ligne pour ajouter une ligne)",null,null,{"$f":"Déplacements[[#This Row],[Budget]]-Déplacements[[#This Row],[Réel]]","v":{"v":0,"d":"0.00 $"}},{"$nulls":3},"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 $"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Déplacements[Budget])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUBTOTAL(109,Déplacements[Réel])","v":{"v":0,"d":"0.00 $"}},{"$f":"SUBTOTAL(109,Déplacements[Écart])","v":{"v":0,"d":"0.00 $"}}]