{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Budget de mariage","Dépenses","Calculs"],"not_rendered":{"charts":1,"images":1,"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"Budget de mariage","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[3,1,3,5],[4,1,4,5],[5,1,5,4],[18,1,34,5]]}
[{"$nulls":6}," "]
[]
[]
[null,"Date du mariage :"]
[null,{"$f":"TODAY()+365","v":"2020-08-05"}]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget","Terminé"]
[null,"Vêtements et accessoires",{"$f":"Vêtements_et_accessoires_Total_Est","v":{"v":9490,"d":"9,490.00"}},{"$f":"Vêtements_et_accessoires_Total_Réel","v":{"v":9770,"d":"9,770.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":-280,"d":"-280.00"}},{"$f":"Vêtements_et_accessoires_Fait","v":"Non"}]
[null,"Réception",{"$f":"Réception_Total_Est","v":{"v":1050,"d":"1,050.00"}},{"$f":"Réception_Total_Réel","v":{"v":928,"d":"928.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":122,"d":"122.00"}},{"$f":"Réception_Fait","v":"Oui"}]
[null,"Musique",{"$f":"Musique_Animations_Total_Est","v":{"v":600,"d":"600.00"}},{"$f":"Musique_Animations_Total_Réel","v":{"v":500,"d":"500.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":100,"d":"100.00"}},{"$f":"Musique_Fait","v":"Oui"}]
[null,"Impression",{"$f":"Impression_Papeterie_Total_Est","v":{"v":935,"d":"935.00"}},{"$f":"Impression_Papeterie_Total_Réel","v":{"v":870,"d":"870.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":65,"d":"65.00"}},{"$f":"Impression_Fait","v":"Non"}]
[null,"Photographie",{"$f":"Photographie_Total_Est","v":{"v":1625,"d":"1,625.00"}},{"$f":"Photographie_Total_Réel","v":{"v":1575,"d":"1,575.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":50,"d":"50.00"}},{"$f":"Photographie_Fait","v":"Non"}]
[null,"Décoration",{"$f":"Décoration_Total_Est","v":{"v":700,"d":"700.00"}},{"$f":"Décoration_Total_Réel","v":{"v":720,"d":"720.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":-20,"d":"-20.00"}},{"$f":"Décoration_Fait","v":"Oui"}]
[null,"Fleurs",{"$f":"Fleurs_Total_Est","v":{"v":900,"d":"900.00"}},{"$f":"Fleurs_Total_Réel","v":{"v":850,"d":"850.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":50,"d":"50.00"}},{"$f":"Fleurs_Fait","v":"Non"}]
[null,"Cadeaux",{"$f":"Cadeaux_Total_Est","v":{"v":1345,"d":"1,345.00"}},{"$f":"Cadeaux_Total_Réel","v":{"v":1075,"d":"1,075.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":270,"d":"270.00"}},{"$f":"Cadeaux_Fait","v":"Non"}]
[null,"Transport",{"$f":"Transport_Total_Est","v":{"v":100,"d":"100.00"}},{"$f":"Transport_Total_Réel","v":{"v":165,"d":"165.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":-65,"d":"-65.00"}},{"$f":"Transport_Fait","v":"Oui"}]
[null,"Autres",{"$f":"Autres_frais_Total_Est","v":{"v":885,"d":"885.00"}},{"$f":"Autres_frais_Total_Réel","v":{"v":1021,"d":"1,021.00"}},{"$f":"RécapitulatifBudget[[#This Row],[Estimé]]-RécapitulatifBudget[[#This Row],[Réel]]","v":{"v":-136,"d":"-136.00"}},{"$f":"Autres_Fait","v":"Non"}]
[null,"Total des dépenses",{"$f":"SUBTOTAL(109,RécapitulatifBudget[Estimé])","v":{"v":17630,"d":"17,630.00"}},{"$f":"SUBTOTAL(109,RécapitulatifBudget[Réel])","v":{"v":17474,"d":"17,474.00"}},{"$f":"SUBTOTAL(109,RécapitulatifBudget[Dans le budget/hors budget])","v":{"v":156,"d":"156.00"}}]
[null,"Le graphique présentant le pourcentage de dépenses par catégorie figure dans cette cellule."]

{"sheet":"Dépenses","index":1,"n_rows":136,"n_cols":6,"rows_kept":136,"merged":[[1,1,1,4],[21,1,21,4],[37,1,37,4],[46,1,46,4],[62,1,62,4],[73,1,73,4],[86,1,86,4],[98,1,98,4],[110,1,110,4],[120,1,120,4]]}
[{"$nulls":5}," "]
[null,"Vêtements et accessoires",{"$nulls":3}," "]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"," "]
[null,"Alliance(s)",{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"},{"$f":"Dépenses!$C5-Dépenses!$D5","v":{"v":0,"d":"0.00"}}]
[null,"Alliance conjoint 1",{"v":2000,"d":"2,000.00"},{"v":2300,"d":"2,300.00"},{"$f":"Dépenses!$C6-Dépenses!$D6","v":{"v":-300,"d":"-300.00"}}]
[null,"Robe/Costume conjoint 1",{"v":3000,"d":"3,000.00"},{"v":2750,"d":"2,750.00"},{"$f":"Dépenses!$C7-Dépenses!$D7","v":{"v":250,"d":"250.00"}}]
[null,"Voile/Tiare conjoint 1",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Dépenses!$C8-Dépenses!$D8","v":{"v":0,"d":"0.00"}}]
[null,"Chaussures conjoint 1",{"v":350,"d":"350.00"},{"v":300,"d":"300.00"},{"$f":"Dépenses!$C9-Dépenses!$D9","v":{"v":50,"d":"50.00"}}]
[null,"Bijoux conjoint 1",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Dépenses!$C10-Dépenses!$D10","v":{"v":-150,"d":"-150.00"}}]
[null,"Bas conjoint 1",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"$f":"Dépenses!$C11-Dépenses!$D11","v":{"v":0,"d":"0.00"}}]
[null,"Alliance conjoint 2",{"v":300,"d":"300.00"},{"v":250,"d":"250.00"},{"$f":"Dépenses!$C12-Dépenses!$D12","v":{"v":50,"d":"50.00"}}]
[null,"Robe/Costume conjoint 2",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"$f":"Dépenses!$C13-Dépenses!$D13","v":{"v":-50,"d":"-50.00"}}]
[null,"Voile/Tiare conjoint 2",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Dépenses!$C14-Dépenses!$D14","v":{"v":0,"d":"0.00"}}]
[null,"Chaussures conjoint 2",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Dépenses!$C15-Dépenses!$D15","v":{"v":25,"d":"25.00"}}]
[null,"Bijoux conjoint 2",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Dépenses!$C16-Dépenses!$D16","v":{"v":-150,"d":"-150.00"}}]
[null,"Bas conjoint 2",{"v":20,"d":"20.00"},{"v":25,"d":"25.00"},{"$f":"Dépenses!$C17-Dépenses!$D17","v":{"v":-5,"d":"-5.00"}}]
[null,"Total vêtements et accessoires",{"$f":"SUBTOTAL(109,Vêtements_et_accessoires[Estimé])","v":{"v":9490,"d":"9,490.00"}},{"$f":"SUBTOTAL(109,Vêtements_et_accessoires[Réel])","v":{"v":9770,"d":"9,770.00"}},{"$f":"SUBTOTAL(109,Vêtements_et_accessoires[Dans le budget/hors budget])","v":{"v":-280,"d":"-280.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B2&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Vêtements et accessoires sont-elles terminées ?"},"Non"]
[]
[null,"Réception*"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Location de salle",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Dépenses!$C25-Dépenses!$D25","v":{"v":50,"d":"50.00"}}]
[null,"Tables et chaises",{"v":100,"d":"100.00"},{"v":50,"d":"50.00"},{"$f":"Dépenses!$C26-Dépenses!$D26","v":{"v":50,"d":"50.00"}}]
[null,"Nourriture",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C27-Dépenses!$D27","v":{"v":0,"d":"0.00"}}]
[null,"Boissons",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C28-Dépenses!$D28","v":{"v":0,"d":"0.00"}}]
[null,"Linge de table",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C29-Dépenses!$D29","v":{"v":0,"d":"0.00"}}]
[null,"Gâteau",{"v":700,"d":"700.00"},{"v":700,"d":"700.00"},{"$f":"Dépenses!$C30-Dépenses!$D30","v":{"v":0,"d":"0.00"}}]
[null,"Cadeaux pour les invités",{"v":50,"d":"50.00"},{"v":28,"d":"28.00"},{"$f":"Dépenses!$C31-Dépenses!$D31","v":{"v":22,"d":"22.00"}}]
[null,"Personnel et pourboires",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C32-Dépenses!$D32","v":{"v":0,"d":"0.00"}}]
[null,"Total réception",{"$f":"SUBTOTAL(109,Réception[Estimé])","v":{"v":1050,"d":"1,050.00"}},{"$f":"SUBTOTAL(109,Réception[Réel])","v":{"v":928,"d":"928.00"}},{"$f":"SUBTOTAL(109,Réception[Dans le budget/hors budget])","v":{"v":122,"d":"122.00"}}]
[null,"* Hors animation et décoration"]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B22&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Réception* sont-elles terminées ?"},"Oui"]
[]
[null,"Musique/Animation"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Musiciens pour la cérémonie",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Dépenses!$C41-Dépenses!$D41","v":{"v":0,"d":"0.00"}}]
[null,"Orchestre/DJ pour la réception",{"v":200,"d":"200.00"},{"v":100,"d":"100.00"},{"$f":"Dépenses!$C42-Dépenses!$D42","v":{"v":100,"d":"100.00"}}]
[null,"Total musique/animation",{"$f":"SUBTOTAL(109,Musique[Estimé])","v":{"v":600,"d":"600.00"}},{"$f":"SUBTOTAL(109,Musique[Réel])","v":{"v":500,"d":"500.00"}},{"$f":"SUBTOTAL(109,Musique[Dans le budget/hors budget])","v":{"v":100,"d":"100.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B38&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Musique/Animation sont-elles terminées ?"},"Oui"]
[]
[null,"Impression/Papeterie"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Invitations",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Dépenses!$C50-Dépenses!$D50","v":{"v":50,"d":"50.00"}}]
[null,"Annonces",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Dépenses!$C51-Dépenses!$D51","v":{"v":25,"d":"25.00"}}]
[null,"Cartes de remerciement",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Dépenses!$C52-Dépenses!$D52","v":{"v":0,"d":"0.00"}}]
[null,"Papeterie à en-tête",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C53-Dépenses!$D53","v":{"v":0,"d":"0.00"}}]
[null,"Livre d’or",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Dépenses!$C54-Dépenses!$D54","v":{"v":0,"d":"0.00"}}]
[null,"Programmes",{"v":75,"d":"75.00"},{"v":80,"d":"80.00"},{"$f":"Dépenses!$C55-Dépenses!$D55","v":{"v":-5,"d":"-5.00"}}]
[null,"Serviettes pour la réception",{"v":35,"d":"35.00"},{"v":40,"d":"40.00"},{"$f":"Dépenses!$C56-Dépenses!$D56","v":{"v":-5,"d":"-5.00"}}]
[null,"Pochettes d’allumettes",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C57-Dépenses!$D57","v":{"v":0,"d":"0.00"}}]
[null,"Calligraphie",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C58-Dépenses!$D58","v":{"v":0,"d":"0.00"}}]
[null,"Total impression/papeterie",{"$f":"SUBTOTAL(109,Impression[Estimé])","v":{"v":935,"d":"935.00"}},{"$f":"SUBTOTAL(109,Impression[Réel])","v":{"v":870,"d":"870.00"}},{"$f":"SUBTOTAL(109,Impression[Dans le budget/hors budget])","v":{"v":65,"d":"65.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B47&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Impression/Papeterie sont-elles terminées ?"},"Non"]
[]
[null,"Photographie"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Robes",{"v":1300,"d":"1,300.00"},{"v":1300,"d":"1,300.00"},{"$f":"Dépenses!$C66-Dépenses!$D66","v":{"v":0,"d":"0.00"}}]
[null,"Tirages supplémentaires",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Dépenses!$C67-Dépenses!$D67","v":{"v":0,"d":"0.00"}}]
[null,"Albums photo",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Dépenses!$C68-Dépenses!$D68","v":{"v":0,"d":"0.00"}}]
[null,"Vidéo",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Dépenses!$C69-Dépenses!$D69","v":{"v":50,"d":"50.00"}}]
[null,"Total photographie",{"$f":"SUBTOTAL(109,Photographie[Estimé])","v":{"v":1625,"d":"1,625.00"}},{"$f":"SUBTOTAL(109,Photographie[Réel])","v":{"v":1575,"d":"1,575.00"}},{"$f":"SUBTOTAL(109,Photographie[Dans le budget/hors budget])","v":{"v":50,"d":"50.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B63&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Photographie sont-elles terminées ?"},"Non"]
[]
[null,"Décoration*"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Nœuds de chaise",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C77-Dépenses!$D77","v":{"v":0,"d":"0.00"}}]
[null,"Ornements de table",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},{"$f":"Dépenses!$C78-Dépenses!$D78","v":{"v":-20,"d":"-20.00"}}]
[null,"Bougies",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Dépenses!$C79-Dépenses!$D79","v":{"v":25,"d":"25.00"}}]
[null,"Éclairage",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Dépenses!$C80-Dépenses!$D80","v":{"v":25,"d":"25.00"}}]
[null,"Ballons",{"v":200,"d":"200.00"},{"v":250,"d":"250.00"},{"$f":"Dépenses!$C81-Dépenses!$D81","v":{"v":-50,"d":"-50.00"}}]
[null,"Total décoration",{"$f":"SUBTOTAL(109,Décoration[Estimé])","v":{"v":700,"d":"700.00"}},{"$f":"SUBTOTAL(109,Décoration[Réel])","v":{"v":720,"d":"720.00"}},{"$f":"SUBTOTAL(109,Décoration[Dans le budget/hors budget])","v":{"v":-20,"d":"-20.00"}}]
[null,"*Hors fleurs"]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B74&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Décoration* sont-elles terminées ?"},"Oui"]
[]
[null,"Fleurs"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Bouquets",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Dépenses!$C90-Dépenses!$D90","v":{"v":50,"d":"50.00"}}]
[null,"Boutonnières",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C91-Dépenses!$D91","v":{"v":0,"d":"0.00"}}]
[null,"Petits bouquets à épingler au corsage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C92-Dépenses!$D92","v":{"v":0,"d":"0.00"}}]
[null,"Cérémonie",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Dépenses!$C93-Dépenses!$D93","v":{"v":0,"d":"0.00"}}]
[null,"Réception",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C94-Dépenses!$D94","v":{"v":0,"d":"0.00"}}]
[null,"Total fleurs",{"$f":"SUBTOTAL(109,Fleurs[Estimé])","v":{"v":900,"d":"900.00"}},{"$f":"SUBTOTAL(109,Fleurs[Réel])","v":{"v":850,"d":"850.00"}},{"$f":"SUBTOTAL(109,Fleurs[Dans le budget/hors budget])","v":{"v":50,"d":"50.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B87&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Fleurs sont-elles terminées ?"},"Non"]
[]
[null,"Cadeaux"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Garçons et demoiselles d’honneur",{"v":1000,"d":"1,000.00"},{"v":400,"d":"400.00"},{"$f":"Dépenses!$C102-Dépenses!$D102","v":{"v":600,"d":"600.00"}}]
[null,"Conjoint 1",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Dépenses!$C103-Dépenses!$D103","v":{"v":-50,"d":"-50.00"}}]
[null,"Conjoint 2",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Dépenses!$C104-Dépenses!$D104","v":{"v":-50,"d":"-50.00"}}]
[null,"Parents",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Dépenses!$C105-Dépenses!$D105","v":{"v":0,"d":"0.00"}}]
[null,"Lecteurs/autres participants",{"v":20,"d":"20.00"},{"v":250,"d":"250.00"},{"$f":"Dépenses!$C106-Dépenses!$D106","v":{"v":-230,"d":"-230.00"}}]
[null,"Total cadeaux",{"$f":"SUBTOTAL(109,Cadeaux[Estimé])","v":{"v":1345,"d":"1,345.00"}},{"$f":"SUBTOTAL(109,Cadeaux[Réel])","v":{"v":1075,"d":"1,075.00"}},{"$f":"SUBTOTAL(109,Cadeaux[Dans le budget/hors budget])","v":{"v":270,"d":"270.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B99&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Cadeaux sont-elles terminées ?"},"Non"]
[]
[null,"Transport"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Limousines/Bus",{"v":100,"d":"100.00"},{"v":125,"d":"125.00"},{"$f":"Dépenses!$C114-Dépenses!$D114","v":{"v":-25,"d":"-25.00"}}]
[null,"Parking",{"v":0,"d":"0.00"},{"v":40,"d":"40.00"},{"$f":"Dépenses!$C115-Dépenses!$D115","v":{"v":-40,"d":"-40.00"}}]
[null,"Taxis",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C116-Dépenses!$D116","v":{"v":0,"d":"0.00"}}]
[null,"Total transport",{"$f":"SUBTOTAL(109,Transport[Estimé])","v":{"v":100,"d":"100.00"}},{"$f":"SUBTOTAL(109,Transport[Réel])","v":{"v":165,"d":"165.00"}},{"$f":"SUBTOTAL(109,Transport[Dans le budget/hors budget])","v":{"v":-65,"d":"-65.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B111&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Transport sont-elles terminées ?"},"Oui"]
[]
[null,"Autres frais"]
[]
[null,"Catégorie","Estimé","Réel","Dans le budget/hors budget"]
[null,"Célébrant",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C124-Dépenses!$D124","v":{"v":0,"d":"0.00"}}]
[null,"Frais église/lieu de la cérémonie",{"v":40,"d":"40.00"},{"v":55,"d":"55.00"},{"$f":"Dépenses!$C125-Dépenses!$D125","v":{"v":-15,"d":"-15.00"}}]
[null,"Coordinateur du mariage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C126-Dépenses!$D126","v":{"v":0,"d":"0.00"}}]
[null,"Dîner de répétition",{"v":450,"d":"450.00"},{"v":450,"d":"450.00"},{"$f":"Dépenses!$C127-Dépenses!$D127","v":{"v":0,"d":"0.00"}}]
[null,"Fête de fiançailles",{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},{"$f":"Dépenses!$C128-Dépenses!$D128","v":{"v":-30,"d":"-30.00"}}]
[null,"Fêtes",{"v":30,"d":"30.00"},{"v":20,"d":"20.00"},{"$f":"Dépenses!$C129-Dépenses!$D129","v":{"v":10,"d":"10.00"}}]
[null,"Soins de mise en beauté",{"v":45,"d":"45.00"},{"v":46,"d":"46.00"},{"$f":"Dépenses!$C130-Dépenses!$D130","v":{"v":-1,"d":"-1.00"}}]
[null,"Enterrements de vie de garçon/jeune fille",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C131-Dépenses!$D131","v":{"v":0,"d":"0.00"}}]
[null,"Brunch",{"v":300,"d":"300.00"},{"v":400,"d":"400.00"},{"$f":"Dépenses!$C132-Dépenses!$D132","v":{"v":-100,"d":"-100.00"}}]
[null,"Chambres d’hôtel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Dépenses!$C133-Dépenses!$D133","v":{"v":0,"d":"0.00"}}]
[null,"Total autres frais",{"$f":"SUBTOTAL(109,Autres_frais[Estimé])","v":{"v":885,"d":"885.00"}},{"$f":"SUBTOTAL(109,Autres_frais[Réel])","v":{"v":1021,"d":"1,021.00"}},{"$f":"SUBTOTAL(109,Autres_frais[Dans le budget/hors budget])","v":{"v":-136,"d":"-136.00"}}]
[]
[{"$nulls":3},{"$f":"\"Toutes les dépenses de la catégorie \"&B121&\" sont-elles terminées ?\"","v":"Toutes les dépenses de la catégorie Autres frais sont-elles terminées ?"},"Non"]

{"sheet":"Calculs","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true}
[]
[null,"CATÉGORIE","ESTIMÉ","Réel",null,"Estimé",null,"DANS LE BUDGET/HORS BUDGET"]
[null,"Vêtements et accessoires",{"$f":"Vêtements_et_accessoires_Total_Est","v":{"v":9490,"d":"9,490.00"}},{"$f":"Vêtements_et_accessoires_Total_Réel","v":{"v":9770,"d":"9,770.00"}},{"$f":"C3-F3","v":{"v":9480,"d":"9,480.00"}},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E3","v":290},{"$f":"D3-C3","v":{"v":280,"d":"280.00"}}]
[null,"Réception",{"$f":"Réception_Total_Est","v":{"v":1050,"d":"1,050.00"}},{"$f":"Réception_Total_Réel","v":{"v":928,"d":"928.00"}},{"$f":"C4-F4","v":{"v":1040,"d":"1,040.00"}},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E4","v":8730},{"$f":"D4-C4","v":{"v":-122,"d":"-122.00"}}]
[null,"Musique",{"$f":"Musique_Animations_Total_Est","v":{"v":600,"d":"600.00"}},{"$f":"Musique_Animations_Total_Réel","v":{"v":500,"d":"500.00"}},{"v":590,"d":"590.00"},{"v":10,"d":"10.00"},9180,{"v":-100,"d":"-100.00"}]
[null,"Impression",{"$f":"Impression_Papeterie_Total_Est","v":{"v":935,"d":"935.00"}},{"$f":"Impression_Papeterie_Total_Réel","v":{"v":870,"d":"870.00"}},{"v":925,"d":"925.00"},{"v":10,"d":"10.00"},8845,{"v":-65,"d":"-65.00"}]
[null,"Photographie",{"$f":"Photographie_Total_Est","v":{"v":1625,"d":"1,625.00"}},{"$f":"Photographie_Total_Réel","v":{"v":1575,"d":"1,575.00"}},{"v":1615,"d":"1,615.00"},{"v":10,"d":"10.00"},8155,{"v":-50,"d":"-50.00"}]
[null,"Décoration",{"$f":"Décoration_Total_Est","v":{"v":700,"d":"700.00"}},{"$f":"Décoration_Total_Réel","v":{"v":720,"d":"720.00"}},{"v":690,"d":"690.00"},{"v":10,"d":"10.00"},9080,{"v":20,"d":"20.00"}]
[null,"Fleurs",{"$f":"Fleurs_Total_Est","v":{"v":900,"d":"900.00"}},{"$f":"Fleurs_Total_Réel","v":{"v":850,"d":"850.00"}},{"v":890,"d":"890.00"},{"v":10,"d":"10.00"},8880,{"v":-50,"d":"-50.00"}]
[null,"Cadeaux",{"$f":"Cadeaux_Total_Est","v":{"v":1345,"d":"1,345.00"}},{"$f":"Cadeaux_Total_Réel","v":{"v":1075,"d":"1,075.00"}},{"v":1335,"d":"1,335.00"},{"v":10,"d":"10.00"},8435,{"v":-270,"d":"-270.00"}]
[null,"Transport",{"$f":"Transport_Total_Est","v":{"v":100,"d":"100.00"}},{"$f":"Transport_Total_Réel","v":{"v":165,"d":"165.00"}},{"v":90,"d":"90.00"},{"v":10,"d":"10.00"},9680,{"v":65,"d":"65.00"}]
[null,"Autres",{"$f":"Autres_frais_Total_Est","v":{"v":885,"d":"885.00"}},{"$f":"Autres_frais_Total_Réel","v":{"v":1021,"d":"1,021.00"}},{"v":875,"d":"875.00"},{"v":10,"d":"10.00"},8895,{"v":136,"d":"136.00"}]
[null,"Max",{"$f":"MAX(C3:D12)","v":9770},{"$f":"MAX(C3:D12)","v":9770},null,{"v":10,"d":"10.00"}]