{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Wedding budget spreadsheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Wedding budget spreadsheet","index":0,"n_rows":68,"n_cols":7,"rows_kept":68,"cut":false,"hidden":false,"merged":[[52,2,54,2],[56,2,60,2],[52,3,54,3],[56,3,60,3],[67,3,67,6],[3,1,3,6],[5,4,5,6],[5,1,5,3],[4,1,4,6],[50,1,50,6],[7,1,7,6],[9,3,14,3],[16,3,21,3],[23,3,25,3],[27,3,32,3],[38,3,42,3],[44,3,47,3],[34,3,36,3]]}
[]
[]
[null,"Wedding budget spreadsheet"]
[null,"The Fonds de solidarité FTQ helps you manage your wedding budget and track your spending. Fill out the yellow fields and adapt the budget spreadsheet according to your needs."]
[null,"My wedding"]
[null,"Total projected budget"]
[null,"Expenses (recommended %)","Projected budget in % (adjust depending on your preferences)","Projected budget in $","Actual budget in $","Actual expenses in $","Difference between the actual budget and actual spending in $"]
[null,"Expenses to consider"]
[null,"Ceremony (5%)",0.05,{"$f":"$E$6*$C9","v":0},{"$f":"SUM(E10:E15)","v":0},{"$f":"SUM(F10:F15)","v":0},{"$f":"F9-E9","v":0}]
[null,"Ceremony venue",null,{"$f":"\"The total for this category should correspond to about \"&TEXT(IF(C9<>0,C9,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D9,\"# ##0 $\")&\".\",\".\")","v":"The total for this category should correspond to about 5 % of your wedding budget."},null,null,{"$f":"F10-E10","v":0}]
[null,"Officiant",null,null,null,null,{"$f":"F11-E11","v":0}]
[null,"Marriage licence",null,null,null,null,{"$f":"F12-E12","v":0}]
[null,"Rings",null,null,null,null,0]
[null,"Rehearsal dinner",null,null,null,null,0]
[null,"Other fees",null,null,null,null,0]
[null,"Reception (50 %)",0.5,{"$f":"$E$6*$C16","v":0},{"$f":"SUM(E17:E22)","v":0},{"$f":"SUM(F17:F22)","v":0},{"$f":"F16-E16","v":0}]
[null,"Reception venue rental",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C16<>0,C16,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D16,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 50 % of your wedding budget."},null,null,{"$f":"F17-E17","v":0}]
[null,"Reception venue set up",null,null,null,null,{"$f":"F18-E18","v":0}]
[null,"Caterer",null,null,null,null,0]
[null,"Wedding cake",null,null,null,null,0]
[null,"Bar service and servers",null,null,null,null,0]
[null,"Other fees",null,null,null,null,0]
[null,"Photos and videos (10%)",0.1,{"$f":"$E$6*$C23","v":0},{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0},{"$f":"F23-E23","v":0}]
[null,"Photographer",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C23<>0,C23,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D23,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 10 % of your wedding budget."},null,null,{"$f":"F24-E24","v":0}]
[null,"Videographer",null,null,null,null,{"$f":"F25-E25","v":0}]
[null,"Other fees",null,null,null,null,0]
[null,"Flowers and decor (10%)",0.1,{"$f":"$E$6*$C27","v":0},{"$f":"SUM(E28:E33)","v":0},{"$f":"SUM(F28:F33)","v":0},{"$f":"F27-E27","v":0}]
[null,"Bouquet(s) ",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C27<>0,C27,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D27,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 10 % of your wedding budget."},null,null,{"$f":"F28-E28","v":0}]
[null,"Boutonnieres",null,null,null,null,0]
[null,"Centrepieces",null,null,null,null,0]
[null,"Tables and chairs",null,null,null,null,0]
[null,"Tablecloths",null,null,null,null,0]
[null,"Other fees",null,null,null,null,0]
[null,"Music (7%)",7.0000000000000007E-2,{"$f":"$E$6*$C34","v":0},{"$f":"SUM(E35:E36)","v":0},{"$f":"SUM(F35:F36)","v":0},{"$f":"F34-E34","v":0}]
[null,"Music for the ceremony",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C34<>0,C34,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D34,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 7 % of your wedding budget."},null,null,0]
[null,"Music for the reception",null,null,null,null,0]
[null,"Other fees",null,null,null,null,0]
[null,"Wedding attire (10%)",0.1,{"$f":"$E$6*$C38","v":0},{"$f":"SUM(E39:E43)","v":0},{"$f":"SUM(F39:F43)","v":0},0]
[null,"Wedding outfits",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C38<>0,C38,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D38,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 10 % of your wedding budget."},null,null,0]
[null,"Shoes",null,null,null,null,{"$f":"F40-E40","v":0}]
[null,"Jewellery",null,null,null,null,0]
[null,"Hair and makeup",null,null,null,null,0]
[null,"Other fees",null,null,null,null,0]
[null,"Stationery (3%)",0.03,{"$f":"$E$6*$C44","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(F45:F48)","v":0},{"$f":"F44-E44","v":0}]
[null,"Invitations and announcement",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C44<>0,C44,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D44,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 3 % of your wedding budget."},null,null,0]
[null,"Place cards",null,null,null,null,{"$f":"F46-E46","v":0}]
[null,"Thank-you cards",null,null,null,null,{"$f":"F47-E47","v":0}]
[null,"Other fees",null,null,null,null,0]
[null,"Financial safety cushion (5%)",0.05,{"$f":"$E$6*$C49","v":0},{"$f":"SUM(E50)","v":0},{"$f":"SUM(F51:F53)","v":0},{"$f":"F49-E49","v":0}]
[null,"Unexpected expenses",null,{"$f":"\"The total of this category should correspond to about \"&TEXT(IF(C49<>0,C49,0),\"##0 %\")&\" of your wedding budget\"&IF($E$6>0,\", or \"&TEXT(D49,\"# ##0 $\")&\".\",\".\")","v":"The total of this category should correspond to about 5 % of your wedding budget."},null,null,{"$f":"F50-E50","v":0}]
[null,"Additional expenses depending on your preferences"]
[null,"Other (variable %)",0,{"$f":"$E$6*$C52","v":0},{"$f":"SUM(E53:E55)","v":0},{"$f":"SUM(F53:F55)","v":0},{"$f":"F52-E52","v":0}]
[null,"Wedding planner","\nIt's up to you to decide what percentage of your total budget you'd like to allocate to this category.",{"$f":"IF(C52>0,\"Le total de cette catégorie doit être égal à environ \"&TEXT(IF(C52<>0,C52,0),\"##0 %\")&\" de votre budget de mariage\"&IF($E$6>0,\", soit \"&TEXT(D52,\"# ##0 $\")&\".\",\".\"),\"\")","v":""},null,null,{"$f":"F53-E53","v":0}]
[null,"Transportation (parking, shuttle buses, etc.)",null,null,null,null,{"$f":"F54-E54","v":0}]
[null,"Other fees",null,null,null,null,0]
[null,"Honeymoon (variable %)",0,{"$f":"$E$6*$C56","v":0},{"$f":"SUM(E57:E61)","v":0},{"$f":"SUM(F57:F61)","v":0},{"$f":"F56-E56","v":0}]
[null,"Plane tickets","It's up to you to decide what percentage of your total budget you'd like to allocate to this category.",{"$f":"IF(C56>0,\"Le total de cette catégorie doit être égal à environ \"&TEXT(IF(C56<>0,C56,0),\"##0 %\")&\" de votre budget de mariage\"&IF($E$6>0,\", soit \"&TEXT(D56,\"# ##0 $\")&\".\",\".\"),\"\")","v":""},null,null,{"$f":"F57-E57","v":0}]
[null,"Accommodations",null,null,null,null,{"$f":"F58-E58","v":0}]
[null,"Activities",null,null,null,null,{"$f":"F59-E59","v":0}]
[null,"Meals",null,null,null,null,{"$f":"F60-E60","v":0}]
[null,"Other fees",null,null,null,null,{"$f":"F61-E61","v":0}]
[null,"Summary","Projected budget in %","Projected budget in $","Actual budget in $","Actual expenses in $","Difference between the actual budget and actual spending in $"]
[null,{"$f":"B6","v":"Total projected budget"},{"$f":"SUM(C9,C16,C23,C27,C34,C38,C44,C49)","v":1},{"$f":"SUM(D9,D16,D23,D27,D34,D38,D44,D49)","v":0},{"$f":"SUM(E9,E16,E23,E27,E34,E38,E44,E49)","v":0},{"$f":"SUM(F9,F16,F23,F27,F34,F38,F44, F49)","v":0},{"$f":"IF(F63<>0,F63-E63,\"\")","v":""}]
[null,{"$f":"B51","v":"Additional expenses depending on your preferences"},{"$f":"SUM(C52,C56)","v":0},{"$f":"SUM(D52,D56)","v":0},{"$f":"SUM(E52,E56)","v":0},{"$f":"SUM(F52,F56)","v":0},{"$f":"IF(F64<>0,F64-E64,\"\")","v":""}]
[null,"TOTAL",{"$f":"SUM(C63:C64)","v":1},{"$f":"SUM(D63:D64)","v":0},{"$f":"SUM(E63:E64)","v":0},0,{"$f":"IF(F65<>0,F65-E65,\"\")","v":""}]
[]
[null,null,null,{"$f":"IF(C65>1,\"Oops! Your budget % exceed 100 %.\",IF(C65<1,\"Oops! Your budget % don't amount to 100 %.\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(AND($E$65>0,$F$65>0),IF($E$65>=$F$65,\"Congratulations, you stayed within your wedding budget!\",\"Uh-oh, you spent \"&TEXT($G$65,\"_ * # ##0 $\")&\" more than you planned!\"),\"\")","v":""}]