{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Wedding budget","Expenses","Calculations"],"not_rendered":{"charts":1,"images":1,"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"Wedding budget","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,"Wedding date:"]
[null,{"$f":"TODAY()+365","v":"2020-06-28"}]
[]
[null,"Category","Estimated","Actual","Over/Under","Done"]
[null,"Outfits",{"$f":"Apparel_Total_est","v":{"v":9490,"d":"9,490.00"}},{"$f":"Apparel_Total_act","v":{"v":9770,"d":"9,770.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":-280,"d":"-280.00"}},{"$f":"Apparel_done","v":"No"}]
[null,"Reception",{"$f":"Reception_Total_est","v":{"v":1050,"d":"1,050.00"}},{"$f":"Reception_Total_act","v":{"v":928,"d":"928.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":122,"d":"122.00"}},{"$f":"Reception_Done","v":"Yes"}]
[null,"Music",{"$f":"Music_Entertainment_Total_est","v":{"v":600,"d":"600.00"}},{"$f":"Music_Entertainment_Total_act","v":{"v":500,"d":"500.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":100,"d":"100.00"}},{"$f":"Music_Done","v":"Yes"}]
[null,"Printing",{"$f":"Printing__Stationery_Total_est","v":{"v":935,"d":"935.00"}},{"$f":"Printing__Stationery_Total_act","v":{"v":870,"d":"870.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":65,"d":"65.00"}},{"$f":"Printing_Done","v":"No"}]
[null,"Photography",{"$f":"Photography_Total_est","v":{"v":1625,"d":"1,625.00"}},{"$f":"Photography_Total_act","v":{"v":1575,"d":"1,575.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":50,"d":"50.00"}},{"$f":"Photography_Done","v":"No"}]
[null,"Decorations",{"$f":"Decorations_Total_est","v":{"v":700,"d":"700.00"}},{"$f":"Decorations_Total_act","v":{"v":720,"d":"720.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":-20,"d":"-20.00"}},{"$f":"Deco_Done","v":"Yes"}]
[null,"Flowers",{"$f":"Flowers_Total_est","v":{"v":900,"d":"900.00"}},{"$f":"Flowers_Total_act","v":{"v":850,"d":"850.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":50,"d":"50.00"}},{"$f":"Flowers_Done","v":"No"}]
[null,"Presents",{"$f":"Gifts_Total_est","v":{"v":1345,"d":"1,345.00"}},{"$f":"Gifts_Total_act","v":{"v":1075,"d":"1,075.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":270,"d":"270.00"}},{"$f":"Gifts_Done","v":"No"}]
[null,"Travel",{"$f":"Travel_Transportation_Total_est","v":{"v":100,"d":"100.00"}},{"$f":"Travel_Transportation_Total_act","v":{"v":165,"d":"165.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":-65,"d":"-65.00"}},{"$f":"Travel_Done","v":"Yes"}]
[null,"Other",{"$f":"Other_Expenses_Total_est","v":{"v":885,"d":"885.00"}},{"$f":"Other_Expenses_Total_act","v":{"v":1021,"d":"1,021.00"}},{"$f":"BudgetSummary[[#This Row],[Estimated]]-BudgetSummary[[#This Row],[Actual]]","v":{"v":-136,"d":"-136.00"}},{"$f":"Other_Done","v":"No"}]
[null,"Total expenses",{"$f":"SUBTOTAL(109,BudgetSummary[Estimated])","v":{"v":17630,"d":"17,630.00"}},{"$f":"SUBTOTAL(109,BudgetSummary[Actual])","v":{"v":17474,"d":"17,474.00"}},{"$f":"SUBTOTAL(109,BudgetSummary[Over/Under])","v":{"v":156,"d":"156.00"}}]
[null,"Chart showing each category expense percentage is in this cell."]

{"sheet":"Expenses","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,"Outfits",{"$nulls":3}," "]
[]
[null,"Category","Estimated","Actual","Over/Under"," "]
[null,"Engagement ring(s)",{"v":1500,"d":"1,500.00"},{"v":1500,"d":"1,500.00"},{"$f":"Expenses!$C5-Expenses!$D5","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 1 ring",{"v":2000,"d":"2,000.00"},{"v":2300,"d":"2,300.00"},{"$f":"Expenses!$C6-Expenses!$D6","v":{"v":-300,"d":"-300.00"}}]
[null,"Spouse-to-be 1 gown/tuxedo",{"v":3000,"d":"3,000.00"},{"v":2750,"d":"2,750.00"},{"$f":"Expenses!$C7-Expenses!$D7","v":{"v":250,"d":"250.00"}}]
[null,"Spouse-to-be 1 veil/headpiece",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Expenses!$C8-Expenses!$D8","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 1 shoes",{"v":350,"d":"350.00"},{"v":300,"d":"300.00"},{"$f":"Expenses!$C9-Expenses!$D9","v":{"v":50,"d":"50.00"}}]
[null,"Spouse-to-be 1 jewellery",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Expenses!$C10-Expenses!$D10","v":{"v":-150,"d":"-150.00"}}]
[null,"Spouse-to-be 1 hosiery",{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"$f":"Expenses!$C11-Expenses!$D11","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 2 ring",{"v":300,"d":"300.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C12-Expenses!$D12","v":{"v":50,"d":"50.00"}}]
[null,"Spouse-to-be 2 gown/tuxedo",{"v":300,"d":"300.00"},{"v":350,"d":"350.00"},{"$f":"Expenses!$C13-Expenses!$D13","v":{"v":-50,"d":"-50.00"}}]
[null,"Spouse-to-be 2 veil/headpiece",{"v":500,"d":"500.00"},{"v":500,"d":"500.00"},{"$f":"Expenses!$C14-Expenses!$D14","v":{"v":0,"d":"0.00"}}]
[null,"Spouse-to-be 2 shoes",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Expenses!$C15-Expenses!$D15","v":{"v":25,"d":"25.00"}}]
[null,"Spouse-to-be 2 jewellery",{"v":400,"d":"400.00"},{"v":550,"d":"550.00"},{"$f":"Expenses!$C16-Expenses!$D16","v":{"v":-150,"d":"-150.00"}}]
[null,"Spouse-to-be 2 hosiery",{"v":20,"d":"20.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C17-Expenses!$D17","v":{"v":-5,"d":"-5.00"}}]
[null,"Clothing Total",{"$f":"SUBTOTAL(109,Outfits[Estimated])","v":{"v":9490,"d":"9,490.00"}},{"$f":"SUBTOTAL(109,Outfits[Actual])","v":{"v":9770,"d":"9,770.00"}},{"$f":"SUBTOTAL(109,Outfits[Over/Under])","v":{"v":-280,"d":"-280.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B2&\" category complete?\"","v":"Are all expenses in Outfits category complete?"},"No"]
[]
[null,"Reception*"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Room/hall fees",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Expenses!$C25-Expenses!$D25","v":{"v":50,"d":"50.00"}}]
[null,"Tables and chairs",{"v":100,"d":"100.00"},{"v":50,"d":"50.00"},{"$f":"Expenses!$C26-Expenses!$D26","v":{"v":50,"d":"50.00"}}]
[null,"Food",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C27-Expenses!$D27","v":{"v":0,"d":"0.00"}}]
[null,"Drinks",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C28-Expenses!$D28","v":{"v":0,"d":"0.00"}}]
[null,"Linen",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C29-Expenses!$D29","v":{"v":0,"d":"0.00"}}]
[null,"Cake",{"v":700,"d":"700.00"},{"v":700,"d":"700.00"},{"$f":"Expenses!$C30-Expenses!$D30","v":{"v":0,"d":"0.00"}}]
[null,"Favours",{"v":50,"d":"50.00"},{"v":28,"d":"28.00"},{"$f":"Expenses!$C31-Expenses!$D31","v":{"v":22,"d":"22.00"}}]
[null,"Staff and gratuities",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C32-Expenses!$D32","v":{"v":0,"d":"0.00"}}]
[null,"Reception Total",{"$f":"SUBTOTAL(109,Reception[Estimated])","v":{"v":1050,"d":"1,050.00"}},{"$f":"SUBTOTAL(109,Reception[Actual])","v":{"v":928,"d":"928.00"}},{"$f":"SUBTOTAL(109,Reception[Over/Under])","v":{"v":122,"d":"122.00"}}]
[null,"* Excludes entertainment and decorations"]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B22&\" category complete?\"","v":"Are all expenses in Reception* category complete?"},"Yes"]
[]
[null,"Music/Entertainment"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Musicians for ceremony",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C41-Expenses!$D41","v":{"v":0,"d":"0.00"}}]
[null,"Band/DJ for reception",{"v":200,"d":"200.00"},{"v":100,"d":"100.00"},{"$f":"Expenses!$C42-Expenses!$D42","v":{"v":100,"d":"100.00"}}]
[null,"Music/Entertainment Total",{"$f":"SUBTOTAL(109,Music[Estimated])","v":{"v":600,"d":"600.00"}},{"$f":"SUBTOTAL(109,Music[Actual])","v":{"v":500,"d":"500.00"}},{"$f":"SUBTOTAL(109,Music[Over/Under])","v":{"v":100,"d":"100.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B38&\" category complete?\"","v":"Are all expenses in Music/Entertainment category complete?"},"Yes"]
[]
[null,"Printing/Stationery"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Invitations",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C50-Expenses!$D50","v":{"v":50,"d":"50.00"}}]
[null,"Announcements",{"v":200,"d":"200.00"},{"v":175,"d":"175.00"},{"$f":"Expenses!$C51-Expenses!$D51","v":{"v":25,"d":"25.00"}}]
[null,"Thank-you cards",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Expenses!$C52-Expenses!$D52","v":{"v":0,"d":"0.00"}}]
[null,"Personal stationery",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C53-Expenses!$D53","v":{"v":0,"d":"0.00"}}]
[null,"Guest book",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C54-Expenses!$D54","v":{"v":0,"d":"0.00"}}]
[null,"Programmes",{"v":75,"d":"75.00"},{"v":80,"d":"80.00"},{"$f":"Expenses!$C55-Expenses!$D55","v":{"v":-5,"d":"-5.00"}}]
[null,"Reception napkins",{"v":35,"d":"35.00"},{"v":40,"d":"40.00"},{"$f":"Expenses!$C56-Expenses!$D56","v":{"v":-5,"d":"-5.00"}}]
[null,"Matchbooks",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C57-Expenses!$D57","v":{"v":0,"d":"0.00"}}]
[null,"Calligraphy",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C58-Expenses!$D58","v":{"v":0,"d":"0.00"}}]
[null,"Printing /Stationery Total",{"$f":"SUBTOTAL(109,Printing[Estimated])","v":{"v":935,"d":"935.00"}},{"$f":"SUBTOTAL(109,Printing[Actual])","v":{"v":870,"d":"870.00"}},{"$f":"SUBTOTAL(109,Printing[Over/Under])","v":{"v":65,"d":"65.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B47&\" category complete?\"","v":"Are all expenses in Printing/Stationery category complete?"},"No"]
[]
[null,"Photography"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Formals",{"v":1300,"d":"1,300.00"},{"v":1300,"d":"1,300.00"},{"$f":"Expenses!$C66-Expenses!$D66","v":{"v":0,"d":"0.00"}}]
[null,"Extra prints",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C67-Expenses!$D67","v":{"v":0,"d":"0.00"}}]
[null,"Photo albums",{"v":100,"d":"100.00"},{"v":100,"d":"100.00"},{"$f":"Expenses!$C68-Expenses!$D68","v":{"v":0,"d":"0.00"}}]
[null,"Videography",{"v":200,"d":"200.00"},{"v":150,"d":"150.00"},{"$f":"Expenses!$C69-Expenses!$D69","v":{"v":50,"d":"50.00"}}]
[null,"Photography total",{"$f":"SUBTOTAL(109,Photography[Estimated])","v":{"v":1625,"d":"1,625.00"}},{"$f":"SUBTOTAL(109,Photography[Actual])","v":{"v":1575,"d":"1,575.00"}},{"$f":"SUBTOTAL(109,Photography[Over/Under])","v":{"v":50,"d":"50.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B63&\" category complete?\"","v":"Are all expenses in Photography category complete?"},"No"]
[]
[null,"Decorations*"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Bows for seating",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C77-Expenses!$D77","v":{"v":0,"d":"0.00"}}]
[null,"Centrepieces",{"v":300,"d":"300.00"},{"v":320,"d":"320.00"},{"$f":"Expenses!$C78-Expenses!$D78","v":{"v":-20,"d":"-20.00"}}]
[null,"Candles",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Expenses!$C79-Expenses!$D79","v":{"v":25,"d":"25.00"}}]
[null,"Lighting",{"v":100,"d":"100.00"},{"v":75,"d":"75.00"},{"$f":"Expenses!$C80-Expenses!$D80","v":{"v":25,"d":"25.00"}}]
[null,"Balloons",{"v":200,"d":"200.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C81-Expenses!$D81","v":{"v":-50,"d":"-50.00"}}]
[null,"Decorations Total",{"$f":"SUBTOTAL(109,Decorations[Estimated])","v":{"v":700,"d":"700.00"}},{"$f":"SUBTOTAL(109,Decorations[Actual])","v":{"v":720,"d":"720.00"}},{"$f":"SUBTOTAL(109,Decorations[Over/Under])","v":{"v":-20,"d":"-20.00"}}]
[null,"*Excludes flowers"]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B74&\" category complete?\"","v":"Are all expenses in Decorations* category complete?"},"Yes"]
[]
[null,"Flowers"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Bouquets",{"v":500,"d":"500.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C90-Expenses!$D90","v":{"v":50,"d":"50.00"}}]
[null,"Buttonholes",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C91-Expenses!$D91","v":{"v":0,"d":"0.00"}}]
[null,"Corsages",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C92-Expenses!$D92","v":{"v":0,"d":"0.00"}}]
[null,"Ceremony",{"v":400,"d":"400.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C93-Expenses!$D93","v":{"v":0,"d":"0.00"}}]
[null,"Reception",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C94-Expenses!$D94","v":{"v":0,"d":"0.00"}}]
[null,"Flowers Total",{"$f":"SUBTOTAL(109,Flowers[Estimated])","v":{"v":900,"d":"900.00"}},{"$f":"SUBTOTAL(109,Flowers[Actual])","v":{"v":850,"d":"850.00"}},{"$f":"SUBTOTAL(109,Flowers[Over/Under])","v":{"v":50,"d":"50.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B87&\" category complete?\"","v":"Are all expenses in Flowers category complete?"},"No"]
[]
[null,"Gifts"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Attendants",{"v":1000,"d":"1,000.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C102-Expenses!$D102","v":{"v":600,"d":"600.00"}}]
[null,"Spouse-to-be 1",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Expenses!$C103-Expenses!$D103","v":{"v":-50,"d":"-50.00"}}]
[null,"Spouse-to-be 2",{"v":150,"d":"150.00"},{"v":200,"d":"200.00"},{"$f":"Expenses!$C104-Expenses!$D104","v":{"v":-50,"d":"-50.00"}}]
[null,"Parents",{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"$f":"Expenses!$C105-Expenses!$D105","v":{"v":0,"d":"0.00"}}]
[null,"Readers/other participants",{"v":20,"d":"20.00"},{"v":250,"d":"250.00"},{"$f":"Expenses!$C106-Expenses!$D106","v":{"v":-230,"d":"-230.00"}}]
[null,"Gifts Total",{"$f":"SUBTOTAL(109,Presents[Estimated])","v":{"v":1345,"d":"1,345.00"}},{"$f":"SUBTOTAL(109,Presents[Actual])","v":{"v":1075,"d":"1,075.00"}},{"$f":"SUBTOTAL(109,Presents[Over/Under])","v":{"v":270,"d":"270.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B99&\" category complete?\"","v":"Are all expenses in Gifts category complete?"},"No"]
[]
[null,"Travel/Transport"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Limousines/cars",{"v":100,"d":"100.00"},{"v":125,"d":"125.00"},{"$f":"Expenses!$C114-Expenses!$D114","v":{"v":-25,"d":"-25.00"}}]
[null,"Parking",{"v":0,"d":"0.00"},{"v":40,"d":"40.00"},{"$f":"Expenses!$C115-Expenses!$D115","v":{"v":-40,"d":"-40.00"}}]
[null,"Taxis",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C116-Expenses!$D116","v":{"v":0,"d":"0.00"}}]
[null,"Travel/Transport Total",{"$f":"SUBTOTAL(109,Travel[Estimated])","v":{"v":100,"d":"100.00"}},{"$f":"SUBTOTAL(109,Travel[Actual])","v":{"v":165,"d":"165.00"}},{"$f":"SUBTOTAL(109,Travel[Over/Under])","v":{"v":-65,"d":"-65.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B111&\" category complete?\"","v":"Are all expenses in Travel/Transport category complete?"},"Yes"]
[]
[null,"Other expenses"]
[]
[null,"Category","Estimated","Actual","Over/Under"]
[null,"Officiant",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C124-Expenses!$D124","v":{"v":0,"d":"0.00"}}]
[null,"Church/ceremony site fee",{"v":40,"d":"40.00"},{"v":55,"d":"55.00"},{"$f":"Expenses!$C125-Expenses!$D125","v":{"v":-15,"d":"-15.00"}}]
[null,"Wedding coordinator",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C126-Expenses!$D126","v":{"v":0,"d":"0.00"}}]
[null,"Rehearsal dinner",{"v":450,"d":"450.00"},{"v":450,"d":"450.00"},{"$f":"Expenses!$C127-Expenses!$D127","v":{"v":0,"d":"0.00"}}]
[null,"Engagement party",{"v":20,"d":"20.00"},{"v":50,"d":"50.00"},{"$f":"Expenses!$C128-Expenses!$D128","v":{"v":-30,"d":"-30.00"}}]
[null,"Showers",{"v":30,"d":"30.00"},{"v":20,"d":"20.00"},{"$f":"Expenses!$C129-Expenses!$D129","v":{"v":10,"d":"10.00"}}]
[null,"Salon appointments",{"v":45,"d":"45.00"},{"v":46,"d":"46.00"},{"$f":"Expenses!$C130-Expenses!$D130","v":{"v":-1,"d":"-1.00"}}]
[null,"Bachelor/ette parties",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C131-Expenses!$D131","v":{"v":0,"d":"0.00"}}]
[null,"Brunch",{"v":300,"d":"300.00"},{"v":400,"d":"400.00"},{"$f":"Expenses!$C132-Expenses!$D132","v":{"v":-100,"d":"-100.00"}}]
[null,"Hotel rooms",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"Expenses!$C133-Expenses!$D133","v":{"v":0,"d":"0.00"}}]
[null,"Other expenses total",{"$f":"SUBTOTAL(109,OtherExpenses[Estimated])","v":{"v":885,"d":"885.00"}},{"$f":"SUBTOTAL(109,OtherExpenses[Actual])","v":{"v":1021,"d":"1,021.00"}},{"$f":"SUBTOTAL(109,OtherExpenses[Over/Under])","v":{"v":-136,"d":"-136.00"}}]
[]
[{"$nulls":3},{"$f":"\"Are all expenses in \"&B121&\" category complete?\"","v":"Are all expenses in Other expenses category complete?"},"No"]

{"sheet":"Calculations","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"hidden":true}
[]
[null,"CATEGORY","ESTIMATED","Actual",null,"Estimated",null,"OVER/UNDER"]
[null,"Outfits",{"$f":"Apparel_Total_est","v":{"v":9490,"d":"9,490.00"}},{"$f":"Apparel_Total_act","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,"Reception",{"$f":"Reception_Total_est","v":{"v":1050,"d":"1,050.00"}},{"$f":"Reception_Total_act","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,"Music",{"$f":"Music_Entertainment_Total_est","v":{"v":600,"d":"600.00"}},{"$f":"Music_Entertainment_Total_act","v":{"v":500,"d":"500.00"}},{"v":590,"d":"590.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E5","v":9180},{"v":-100,"d":"-100.00"}]
[null,"Printing",{"$f":"Printing__Stationery_Total_est","v":{"v":935,"d":"935.00"}},{"$f":"Printing__Stationery_Total_act","v":{"v":870,"d":"870.00"}},{"v":925,"d":"925.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E6","v":8845},{"v":-65,"d":"-65.00"}]
[null,"Photography",{"$f":"Photography_Total_est","v":{"v":1625,"d":"1,625.00"}},{"$f":"Photography_Total_act","v":{"v":1575,"d":"1,575.00"}},{"v":1615,"d":"1,615.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E7","v":8155},{"v":-50,"d":"-50.00"}]
[null,"Decorations",{"$f":"Decorations_Total_est","v":{"v":700,"d":"700.00"}},{"$f":"Decorations_Total_act","v":{"v":720,"d":"720.00"}},{"v":690,"d":"690.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E8","v":9080},{"v":20,"d":"20.00"}]
[null,"Flowers",{"$f":"Flowers_Total_est","v":{"v":900,"d":"900.00"}},{"$f":"Flowers_Total_act","v":{"v":850,"d":"850.00"}},{"v":890,"d":"890.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E9","v":8880},{"v":-50,"d":"-50.00"}]
[null,"Presents",{"$f":"Gifts_Total_est","v":{"v":1345,"d":"1,345.00"}},{"$f":"Gifts_Total_act","v":{"v":1075,"d":"1,075.00"}},{"v":1335,"d":"1,335.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E10","v":8435},{"v":-270,"d":"-270.00"}]
[null,"Travel",{"$f":"Travel_Transportation_Total_est","v":{"v":100,"d":"100.00"}},{"$f":"Travel_Transportation_Total_act","v":{"v":165,"d":"165.00"}},{"v":90,"d":"90.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E11","v":9680},{"v":65,"d":"65.00"}]
[null,"Other",{"$f":"Other_Expenses_Total_est","v":{"v":885,"d":"885.00"}},{"$f":"Other_Expenses_Total_act","v":{"v":1021,"d":"1,021.00"}},{"v":875,"d":"875.00"},{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}},{"$f":"$D$13-E12","v":8895},{"v":136,"d":"136.00"}]
[null,"Max",{"$f":"MAX(C3:D12)","v":9770},{"$f":"MAX(C3:D12)","v":9770},null,{"$f":"ROUNDUP($C$13/1000,0)","v":{"v":10,"d":"10.00"}}]