{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Full timeline","Marketing General","Marketing Defined"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Full timeline","index":0,"n_rows":158,"n_cols":5,"rows_kept":158,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Timeline","Committee","Job","Task Assignment","Progress"]
["July"]
["July","Beth/Deb","Host 2012 strategy/brainstorming meeting"]
["July","Beth","Code gala attendees, volunteers, dancers and committee in database"]
[]
["August"]
["August","Beth/Kym","Reevaluate Kym participation and develop 2012 contract"]
["August","Chair","Meet with SSO and develop 2012 contract"]
["August","Gala Chair","Finalize commmittee structure, committee members, and meeting dates"]
["August","Gala Chair","Begin soliciting dancers for 2013"]
["August","Beth/Deb/Kym","Clarify all roles and expected communication for 2012"]
[]
["September"]
["September","Full","Begin full committee meetings, clarify structure and communication"]
["September","Full","Evaluate pricing structure: tickets, sponsorships"]
["September","Full","Discuss emcee options"]
["September","Kym","Begin talks with Canopies on changes to make for 2012"]
["September","Kym","Review 2011 wrap-up info and document changes for 2012"]
["September","Kym","Develop preliminary sponsorship materials"]
["September","Beth/Deb/Kym","Develop budget and goals"]
["September","Marketing/Kym","Secure design and photo donation/fee (Blaine Huber, Blue Moon)"]
["September","Beth/Deb/Kym","Coordinate fall dancer meeting (review marketing tools, meet)"]
[]
["October"]
["October","Food & Beverage","Initial Food & Beverage Sub-Committee Meeting"]
["October","Beth/Deb/Kym","Present budget to Full Committee for review/approval"]
["October","Auction","Review auction items and strategy to secure items"]
["October","Beth/Deb/Kym","Create sponsorship prospect list"]
["October","Entertainment","Review selection of band, bring proposal to full committee"]
["October","Marketing","Secure in-kind printing donations or discounts"]
["October","Kym/Beth","Coordinate meeting with Robin: review reservations/sponsorships"]
["October","Kym","Review process of reservations and invoicing, test online"]
["October","Kym","Begin accepting and tracking reservations"]
["October","Kym","Schedule photoshoots with celebrities"]
["October","Beth/Deb/Kym","Secure major sponsors, solicit additional sponsors"]
[]
["November"]
["November","Logistics","Secure contract with Canopies, copy to Lakeland Attorney"]
["November","Dancers","Contact Entourage Salon for photoshoot and night-of needs"]
["November","Food & Beverage","Second Food & Beverage Sub-Committee Meeting"]
["January","Photography","Photoshoots take place in January"]
["November","Kym/Marketing","Update Gala website and Facebook Page"]
["November","Kym/Volunteer","Evaluate and write job descriptions for volunteers"]
["November","Kym/Charity","Secure charities and gather W9 forms"]
["November","Kym/Charity","Communicate expectations and goals with dancer charities"]
[]
["December"]
["December","Auction","Finalize auction items"]
["December","Food & Beverage","Present menu to Full Gala Committee"]
[]
["January"]
["January 1st week","Marketing","Review and refine save-the-date mailing list"]
["January 1st week","Marketing","Design save the date card"]
["January 2nd week","Marketing","Proof and edit save the date"]
["January 3rd week","Marketing","Save-the-dates to the printer"]
["January 4th week","Marketing","Mail save-the dates"]
["January","Sponsorships","Begin work with major sponsors for graphic design and ad copy"]
["January","Sponsorships","Secure printing donation from GT Graphics"]
["January","Food & Beverage","Secure wine and beverage sponsorships"]
["January","Food & Beverage","Secure food donations/discounts and sponsorships"]
["January","Marketing","Secure video sponsor"]
["January","Beth/Deb/Kym","Secure Emcee(s)"]
["January","Judges","Secure judges"]
["January","Beth/Deb","Mail letters to Trustees/Alumni Board for donations"]
["January","Dorothy","Talk to Symphony Board about donations/table sponsors"]
["January","Reservations","Get table needs from celebrity dancers"]
["January","Reservations","Mail corporate table prospects info for 2011 gala"]
["January","Dancers","Communicate with dancers and charities regarding online votes"]
[]
["February"]
["February","Sponsorships","Finalize sponsorships"]
["1st week February","Marketing","Prepare Lakeland College magazine ad"]
["February","Logistics","Revised set up of event presented to full committee"]
[]
["March"]
["1st week of March","Marketing","Finalize invitation design and copy"]
["2nd week of March","Marketing","Proof invitation"]
["2nd week of March","Marketing","Finalize mailing list for invitations"]
["1st week of March","Marketing","SSO Playbill ad finalized - photos of dancers"]
["2nd week of March","Marketing","SSO Full page Playbill ad"]
["2nd week of March","Marketing","Send invitations to printers"]
["2nd week of March","Marketing","Press packet contents completed (release announcing event, dancers profiles, photos, release announcing charitable organizations and how to vote, SSO profile release and photo, Lakeland profile release and photo)"]
["3rd week of March","Marketing","Web update (dancer profiles, photos, ticket purchase info, voting info and charitable organizations, sponsors [continually updated])"]
["3rd week of March","Marketing","Press packet released to the media"]
["2010-03-31","Marketing","Mail invitations"]
["March","Logistics","Set up of event location finalized and contract signed"]
["March","Auction","Begin verbiage for program/auction book"]
["March","Marketing","Finalize program/auction book cover"]
["March","Beth","Plan dancer thank you party"]
["March","Kym","Provide detailed information for dancers and charities"]
["March","Auction","Order bidder paddles if necessary"]
[]
["April"]
["April","Auction","Develop checkout database and procedures"]
["April","Auction","Work with Larry Marcus to update and print ballots"]
["1st week of April","Marketing","Send out invitations"]
["1st week of April","Lakeland logistics","Meet with all internal staff who need to be part of Gala logistics"]
["2nd week of April","Pre-program book","Send auction copy to book designer"]
["2nd week of April","Pre-program book","Edit and proof pre-program book"]
["3rd week of April","Pre-program book","Get pre-program book printed"]
["2nd week of April","Marketing","If not sold out: radio PSA released"]
["2nd week of April","Marketing","If not sold out: video releases to local cable station"]
["2nd week of April","Marketing","Save the Date to Media Guests"]
["April","Volunteers","Finalize volunteers and identify additional needs"]
["April","Volunteers","Schedule volunteer trainings and book space"]
["April","Kym","Follow-up calls to corporate table prospects"]
["April","Kym ","Ensure invitations are sent to dancer guests (if not included in invite list)"]
["April","Auction","Determine order of voice auction items for bidding purposes"]
["April","Auction","Determine set up requirements, payment and pickup requirements"]
["April","Auction","Order bidder paddles if necessary"]
["April 4th week ","Auction","Proof pre-program book information"]
["April","Marketing","Work on Reverse Auction video"]
["2010-04-25","Marketing","Preview and Event Night Program book covers in house"]
["April","Kym/Beth/Deb","Develop surveys for guests, volunteers, dancers"]
[]
["May "]
["1st week of May","Marketing","Web update (auction items, menu, judges and bios, professional dancers and bios)"]
["1st week of May","Marketing","Consider email blast to plug online votes?"]
["1st week of May","Marketing","Press packet to media guests (RSVP by May 15)"]
["1st week of May","Judges","Have judges meeting"]
["2nd week of May","Kym","Work with Eric for implementation of online survey, supply emails"]
["2nd week of May","Marketing","SSO full page Playbill ad (rerun March ad)"]
["2nd week of May","Marketing","RSVP date for media guests"]
["3rd week of May","Marketing","Media passes mailed"]
["2010-05-01","Reservations","RSVP due"]
["2010-05-04","Marketing","Preview and Event Night Program books complete"]
["2010-05-11","Marketing","Mail pre-program books to confirmed guests"]
["1st week of May","Sponsorships","Create video/powerpoint sponsorship acknowledgement"]
["1st week of May","Signage","Evaluate signage needs"]
["1st week of May","Kym","Finalize event \"week\" schedule for set-up and facilities, schedule coverage"]
["2nd week of May","Kym/Beth/Deb","Begin seating chart of guests"]
["1st week of May","Marketing","Make corrections to pre-program book for final book"]
["2nd week of May","Program book","Get program books printed"]
["2nd week of May","Auction","Assign bidder numbers to guests; print labels for program books"]
["2nd week of May","Auction","Print extra labels with guests names, table and bid #s for winnings"]
["2nd week of May","Marketing","Coordinate closing of online vote sales and communication"]
["2012-05-18","Full","Event rehearsal and final set-up"]
["2012-05-19","Full","Movers & Shakers Gala"]
["4th week of May","Kym","Communicate with College on all unfinished tasks"]
["4th week of May","Kym","Make sure all documents are on college network before end of contract"]
["4th week of May","Auction","Contact auction award winners and donors"]
["4th week of May","Marketing/Kym","Send out all surveys electronically"]
["4th week of May","Kym/Beth","Tally Survey Results or get reports from Eric"]
["June","Marketing","Update Website and Facebook with post-event information"]
[]
["June"]
["June 1st week","Sponsorships","Thank you letter sent from symphony and college"]
["June","Auction","Thank you notes sent to all in-kind donors"]
["June","Auction","Thank you notes sent to winning bidders re: tax deductive amounts"]
["June","Marketing","Luxury Living article/photos"]
["June","Beth","Committee thank you notes"]
["June","Volunteer","Volunteer thank you notes"]
[null,"Beth","Dancer thank you notes"]
["June","Beth","Dancer and major sponsor thank you notes - President's Office"]
["June","Beth","Follow up invoices for payments not received"]
["June","Beth","Letters to charities with checks, copy dancers"]
["June","Beth/Deb","Schedule dancer wrap-up meeting in coordination with thank you party"]
["June","Marketing/Beth","Work on Gala DVD production"]

{"sheet":"Marketing General","index":1,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Month ","Task Detail"]
["Ongong","Dancer video production"]
[]
["2019-12-01","Design save-the-date"]
[null,"Deadline for Ad in SSO playbill"]
[]
["2019-01-01","Update Gala website phase 1 with online reservations"]
[null,"Online reservations and voting open"]
[null,"Press release with dancer photos with emphasis on charities"]
["Early Jan","Marketing sub-committee meeting"]
["2nd week Jan.","Save-the-dates mailed AND e-mail blast"]
[]
["2019-02-01","Deadline for Ad in SSO playbill"]
[" ","Copy to Marketing for invitation"]
[]
["2019-03-07","Deadline for Ad in SSO playbill"]
[null,"Get volunteers to put invites into envelopes"]
["Mid-March","Program book to Bill"]
["2019-03-29","Invitations mailed"]
[]
["Early April","Preview book content to Eric for website"]
["Late April","Preview and Event Night Program Book covers printed"]
["Late April","Power Point slides content to Marketing to format"]
["Mid April","Program book due to Bill"]
[null,"Create post event online survey"]
[]
["2019-05-03","Deadline for Ad in SSO playbill"]
["5/1/","Event Night opening video & reverse auction videos complete"]
[" ","Mail or e-mail Preview Book"]
[" ","All event night Power Point, music, etc. due to Studio Gear"]

{"sheet":"Marketing Defined","index":2,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Task Category","Task Detail","Contractor","Lakeland","Deb","Marketing Committee","Goal Date"]
[]
["Gala Committee Meetings","Attend gala committee meetings","x","x","x","x","on going"]
[null,"Document meeting minutes","x"," ",null,null,"on going"]
[null,"Coordinate and monitor all meeting tasks follow-up","x",null,null,null,"on going"]
[]
["Gala Budget","Create gala budget and goals","x","x","x","x","on going"]
[null,"Maintain accurate spreadsheets of income and expenses","x",null,null,null,"on going"]
[null,"Obtain Marketing Committee/LC approval for budget expenses","x",null,null,null,"on going"]
[]
["Guests & Corporate Contributions","Copy and process all sponsorship and reservation payments","x","x",null,null,"on going"]
[null,"Record all attending guests","x",null,null,null,"on going"]
[null,"Record all Corporate tables/sponsors","x","x",null," ","on going"]
[" ","Develop corporate sponsor prospects","x","x","x",null,"January"]
[null,"Solicit past and prospective corporations through letters and personal contacts","x","x","x",null,"January/February"]
[null,"Obtain ads of sponsors for program book","x",null,null,null,"March"]
[null,"Create seating assignments","x","x","x","x","May"]
[]
["Marketing & Publicity","Work with designer to create Save the Date card and Gala invitation","x","x","x","x","December/January"]
[null,"Design and type set pre-event and event night program books",null,"x",null," ","April"]
[null,"Develop ads for Lakeland Magazine and Symphony playbills",null,"x",null,null,"based on respective dates"]
[null,"Lakeland College Save the Date ad",null,"x",null,null,"early Feb"]
[null,"SSO Playbill ad finalized -  photos of dancers",null,"x",null,"x","late Feb."]
[null,"SSO Full page Playbill ad",null,"x",null,null,"mid March"]
[null,"SSO full page Playbill ad (rerun March ad)",null,"x",null,null,"early March"]
[null,"Web promotion on Lakeland and Symphony Web sites",null,"x",null,null,"early Jan"]
[null,"Web Update (dancer profiles, photos, ticket purchase info, voting info and charitable organizations, sponsors… continually update)","x","x",null,null,"Early October and again Mid December"]
[null,"Web Update (auction items, menu, judges and bios, professional dancers and bios)",null,"x",null,null,"As soon as available"]
[null,"Write and distribute all for pre-event, day of, and post-event publicity","provide info","x",null,"x","discuss at first mktg meeting"]
[null,"Press packet contents completed (release announcing event, dancers profiles, photos, release announcing charitable organizations and how to vote, SSO profile release and photo, Lakeland profile release and photo)",null,"x",null,"x","early March"]
[null,"Press Packet released to media ",null,"x",null,null,"mid March"]
[null,"Save the Date to Media Guests",null,"x",null,"x","Feb. 1"]
[null,"Power Point content provided & slides created","provide info","x",null,null,"late April"]
[]
["Gala Collateral & Materials","Ensure the design, approval and printing of all Gala collateral is timely","x","x","x","x","on going"]
[null,"Approve all Gala collateral and materials",null,"x","x","x","on going"]
[null,"Finalize invitation design and copy","x","x",null,"x","early March"]
[null,"Invitations to printers",null,"x",null,null,"early March"]
[null,"Obtain dancer questionairres for bios","x",null,null,null,"February"]
[null,"Copy for program books to LC Marketing dept.","x","x",null,null,"Late April/Early May"]
[null,"Write bios for invitations and event programs",null,"x",null,null,"Upon availability"]
[null,"Organize and supervise photo shoots of dancers","x"," ",null,null,"February"]
[null,"Invitations mailed to guests","x","x",null,null,"mid March"]
[null,"Provide a list of all signs and information needed to recognize sponsors at Gala to Lakeland","x",null,null,null,"May"]
[null,"Manufacture and print all Gala signs and recognition boards","x"," ",null,null,"May"]
[]
["Invitation List","Create invite list","x","x","x","x","January, on going"]
[null,"Provide new names to invite list",null,"x","x",null,"on going"]
[null,"Input new names for invitations","x","x",null,null,"on going"]
[]
["Post-Event Follow-up","Write appropriate thank you's and reports","x","x",null,null,"on going through June"]
[null,"Write thank you's to particular guests or sponsors","x","x",null,null,"on going through June"]
[null,"Attend post-event evaluation meeting","x","x","x","x","June"]
[null,"Produce all tax letters",null,"x",null," ","on going through June"]
[null,"Launch survey","provide info","x",null,null,"mid May"]