{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Front Page","Attendees","Rehearsal Dinner","Wedding Party","Budget","states","RSVP","Invite","Thank You","View RSVPs","View Invites","View Thank Yous","Edit","default"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Front Page","index":0,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[20,0,20,11],[1,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[18,0,18,11],[19,0,19,11]]}
[]
["Wedding Planner 1.0"]
[]
[]
["By Chris DuBois"]
["ckdubois@gmail.com"]
["MBA 614 - Winter 11"]
[]
[null,null,null,null,"Wedding Date:",null,"2011-05-08"]
[null,null,null,null,"Days until Wedding",null,{"$f":"G9-TODAY()","v":27}]
[]
[null,null,null,null,"Current RSVPs:",null,{"$f":"COUNTIF(Attendees!J:J,\"YES\")","v":0}]
[null,null,null,null,"Current Guest Total:",null,{"$f":"SUMIFS(Attendees!G:G,Attendees!J:J,\"YES\")","v":0}]

{"sheet":"Attendees","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests","Relation","Invite Sent","RSVP","Gift","Thank You Sent"]
["John Quincy","Adams","1614 Kenton","Ferndale","MI",48220,{"$f":"F2+1","v":48221},"Bride's Family","NO","PENDING",null,"NO"]
["Andrew","Johnson","3000 Blackburn St #507","Dallas","TX",75204,{"$f":"F3+1","v":75205},"Bride's Family","NO","PENDING",null,"NO"]
["James K","Polk","637 24th Street South","Arlington","VA",22202,{"$f":"F4+1","v":22203},"Bride's Family","NO","PENDING",null,"NO"]
["George","Washington","5525 18th Rd N","Arlington","VA",22205,{"$f":"F5+1","v":22206},"Bride's Family","NO","PENDING",null,"NO"]
["Millard","Fillmore","20710 Strathern St","Canoga Park","CA",91306,{"$f":"F6+1","v":91307},"Bride's Friend","NO","PENDING",null,"NO"]
["Rutherford B.","Hayes","1760 Frankstown Road","Hollidaysburg","PA",16648,{"$f":"F7+1","v":16649},"Bride's Friend","NO","PENDING",null,"NO"]
["Thomas","Jefferson","1651 Brentwood Dr","Troy","MI",48098,{"$f":"F8+1","v":48099},"Bride's Friend","NO","PENDING",null,"NO"]
["Martin","Van Buren","1812 Martin St.","Conway","AR",72034,{"$f":"F9+1","v":72035},"Bride's Friend","NO","PENDING",null,"NO"]
["John","Adams","569 Ashmoor Lane","Lexington","NC",27295,{"$f":"F10+1","v":27296},"Groom's Family","NO","PENDING",null,"NO"]
["Ulysses S.","Grant","783 Spring Lane","Lansdale","PA",19446,{"$f":"F11+1","v":19447},"Groom's Family","NO","PENDING",null,"NO"]
["Andrew","Jackson","118 22nd Ave E","Seattle","WA",98112,{"$f":"F12+1","v":98113},"Groom's Family","NO","PENDING",null,"NO"]
["Zachary","Taylor","4 Garrison Way","Bangor","ME","04401",{"$f":"F13+1","v":4402},"Groom's Family","NO","PENDING",null,"NO"]
["James","Buchanan","21 Cortland Dr.","Stow","MA","01775",{"$f":"F14+1","v":1776},"Groom's Friend","NO","PENDING",null,"NO"]
["James","Garfield","340 Wilkinson Way","The Villages","FL  ",32162,{"$f":"F15+1","v":32163},"Groom's Friend","NO","PENDING",null,"NO"]
["William Henry","Harrison","522 Greenwood St. Apt 1W","Evanston","IL",60201,{"$f":"F16+1","v":60202},"Groom's Friend","NO","PENDING",null,"NO"]
["James","Madison","2930 N Connecticut Avenue","Royal Oaks","MI",48073,48074,"Groom's Friend","NO","PENDING",null,"NO"]
["Chester A.","Arthur","1105 Halcyon Ave.","Nashville","TN",37204,{"$f":"F18+1","v":37205},"Mutual Friend","NO","PENDING",null,"NO"]
["Abraham","Lincoln","49R Nursery Street","Whitmans","MA",2382,2383,"Mutual Friend","NO","PENDING",null,"NO"]
["James","Monroe","425 Hillside","Glen Ellyn","IL",60137,{"$f":"F20+1","v":60138},"Mutual Friend","NO","PENDING",null,"NO"]
["John","Tyler","2561 Westview Ct","Prosper","TX",75078,{"$f":"F21+1","v":75079},"Mutual Friend","NO","PENDING",null,"NO"]

{"sheet":"Rehearsal Dinner","index":2,"n_rows":1,"n_cols":7,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests"]

{"sheet":"Wedding Party","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Role"]

{"sheet":"Budget","index":4,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Default Venue","SPENT","BUDGETED","Tax Rate"]
["Facility (include gratuity)"]
["Alcohol (Beer, wine, champagne)"]
["Wedding Party Gifts "]
["Additional Decorations"]
["Music (DJ)"]
["Valet Parking"]
["Tuxedos (Groom, Groomsmen)"]
["Dresses (Bride & bridesmaids)"]
["Marriage License "]
["Guest Favours"]
["Photographer "]
["Marriage Certificate "]
["Limousine "]
["Announcements for those not invited "]
["Save the Date"]
["Save the Date Postage"]
["Invitations"]
["Invitation Postage"]
["Manicure/Pedicure"]
["Bride's Hair"]
["Honeymoon Suite"]
["Pre-tax Total",{"$f":"SUM(B2:B22)","v":0},{"$f":"SUM(C2:C22)","v":0}]
["Tax",{"$f":"B23*(E1/100)","v":0},{"$f":"C23*(E1/100)","v":0}]
["Grand Total",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C23:C24)","v":0}]

{"sheet":"states","index":5,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["States","Relations","Party","Invite","RSVP"]
["AL","Bride's Family","Maid of Honor","YES","YES"]
["AK","Bride's Friend(s)","Bridesmaid","NO","NO"]
["AZ","Groom's Family","Best Man",null,"PENDING"]
["AR","Groom's Friend(s)","Groomsman"]
["CA","Mutual Friend(s)","Usher"]
["CO",null,"Father of the Bride"]
["CT",null,"Mother of the Bride"]
["DC",null,"Father of the Groom"]
["DE",null,"Mother of the Groom"]
["FL",null,"Officiant"]
["GA",null,"Flower Girl"]
["HI",null,"Ring Bearer"]
["ID"]
["IL"]
["IN"]
["IA"]
["KS"]
["KY"]
["LA"]
["ME"]
["MD"]
["MA"]
["MI"]
["MN"]
["MS"]
["MO"]
["MT"]
["NE"]
["NV"]
["NH"]
["NJ"]
["NM"]
["NY"]
["NC"]
["ND"]
["OH"]
["OK"]
["OR"]
["PA"]
["RI"]
["SC"]
["SD"]
["TN"]
["TX"]
["UT"]
["VT"]
["VA"]
["WA"]
["WV"]
["WI"]
["WY"]

{"sheet":"RSVP","index":6,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,"RSVP"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]
[null,null,"PENDING"]

{"sheet":"Invite","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,"Invite Sent"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]

{"sheet":"Thank You","index":8,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,"Thank You Sent"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]
[null,null,"NO"]

{"sheet":"View RSVPs","index":9,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests","Relation","Invite Sent","RSVP","Gift","Thank You Sent"]

{"sheet":"View Invites","index":10,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests","Relation","Invite Sent","RSVP","Gift","Thank You Sent"]

{"sheet":"View Thank Yous","index":11,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests","Relation","Invite Sent","RSVP","Gift","Thank You Sent"]

{"sheet":"Edit","index":12,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["First Name","Last Name","Address","City","State","Zip","Total Guests","Relation","Invite Sent","RSVP","Gift","Thank You Sent"]

{"sheet":"default","index":13,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Default Venue","SPENT","BUDGETED","Tax Rate"]
["Facility (include gratuity)"]
["Alcohol (Beer, wine, champagne)"]
["Wedding Party Gifts "]
["Additional Decorations"]
["Music (DJ)"]
["Valet Parking"]
["Tuxedos (Groom, Groomsmen)"]
["Dresses (Bride & bridesmaids)"]
["Marriage License "]
["Guest Favours"]
["Photographer "]
["Marriage Certificate "]
["Limousine "]
["Announcements for those not invited "]
["Save the Date"]
["Save the Date Postage"]
["Invitations"]
["Invitation Postage"]
["Manicure/Pedicure"]
["Bride's Hair"]
["Honeymoon Suite"]
["Pre-tax Total",{"$f":"SUM(B2:B22)","v":0},{"$f":"SUM(C2:C22)","v":0}]
["Tax",{"$f":"B23*(E1/100)","v":0},{"$f":"C23*(E1/100)","v":0}]
["Grand Total",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C23:C24)","v":0}]