Event Spreadsheet

The club has 'repurposed' or adapted the Marco Men's Club Excel spreadsheet (Workbook) that has been used for many years to manage MMC events. This spreadsheet only requires basic Excel skills. It's a useful tool for keeping track of guest registrations and meal choices and has many other features. See below.

After you read the "What does this workbook offer?", DOWNLOAD A COPY HERE
.XLSX VERSION FOR CURRENT VERSIONS OF EXCEL	.XLS VERSION FOR OLDER VERSIONS 1985 TO 2003
These Excel workbooks are compatible with the Apple Numbers spreadsheet program, but you will need to export the Apple Numbers spreadsheet back to Excel before sending it to the Webmaster. The Webmaster will post your Who is Coming List to the club website. ATTENTION APPLE USERS: Please read this tutorial on how to download Excel spreadsheets into Apple Numbers & then convert Numbers files to export them as Excel files. You can also purchase the Excel version that Microsoft sells for Apple devices but this is expensive unless you do this lot.
TIP: This Workbook has 15+ Worksheets (Tabs). Depending on your screen size you may need to use the Excel controls in the lower LEFT hand corner to navigate the Workbook horizontally to see all the Tabs. There's also a QUICK START GUIDE for these Excel spreadsheets. IT COVERS ALL OF THE FEATURES AVAILABLE IN THE MSC VERSION AND IS A GREAT RESOURCE. PLEASE READ THROUGH THIS BEFORE USING THE SPREADSHEET. Confused about the Excel terms Worksheet, Workbook, Tab & Spreadsheet? Here's a short turorial.

WHAT DOES THIS WORKBOOK OFFER? Reading this will enhance your experience!
WORKBOOK TAB	WHAT THE TAB CONTAINS or DOES, & How to Use it.
(1) Enter All Data Here	This tab is where the Host enters the description of the event & all the information from the guest reservations. Just about everything the Host does in this spreadsheet is on this tab Do NOT use CUT & PASTE here. See tab 1B below Do NOT Drag & Drop. (it's another form of Cut & Paste) Never sort this tab.
(1A) Who's Coming?	This a is hidden tab. This automatically generated list of attendees is typically posted on the website coming events page. This tab is not visible to the Host. The only customer for this is the Webmaster, and he doesn't appreciate folks screwing around with it, so it's hidden, protected and cloaked. The Host can update the list on the website as often as needed by attaching the entire spreadsheet to an email and sending it to the webmaster. The Host retains the original. The email client only sends a copy. Click Here for an example of a 'Who's Coming' list. The default List for the website is just the event details and names of the attendees. The Host can chose to include the Table/Group number and/or the Meal Selections. He can ask the webmaster to do that at any time. The sample above shows the full List.
(1B) Check-in sheet	This tab was created specifically for Dave Walsh and the 6+ picnics that he hosts each year during season. It provides a means to capture payment and attendance details on the day of the event as people arrive. After the event this information is added to Tab1 so the the accounting records for the event will be accurate. It is formatted and set up to print and can be submitted to the Treasurer with the checks and cash. Everyone is invited to use it.
(1C) Cut-Paste Demo	This a is hidden tab. To see it, right click any tab, select unhide, and select "Cut-Paste Demo" All worksheets (spreadsheets) are seriously damaged by using the Excel CUT/PASTE commands. This tab is an interactive tutorial that leads you through a demonstration of the damage that can occur. It is very educational! It is optional and does not have any effect on the rest the workbook. CLICK HERE to download a separate copy of the tutorial. It demonstrates why to NEVER use "cut and paste" on any spreadsheet. An (.xls) version is also available.
(2A+B+C+D) Print the Data from TAB 1	These are automatic copies of the information from the data entry tab(1A) above. The first 3 tabs (A,B,C) are automatically sorted by Last Name, Table Number & Check Number respectively. Auto-sorting is accomplished by using the "=Sort()" function first available in Excel 365. Tab(D) is the source for the first three tabs. Tab(D) is the raw, unsorted data from TAB(1A). If you are using an older version of Excel you can sort Tab(D) manually. Tab D is also useful for repairing a spreadsheet that has been damaged by the "Cut & Paste" commands. See the Quick Start Guide for more info on this. The data on tab(A) (auto-sorted by Last Name) drives many of the other functions such as nametags and envelope labels below.
(4) Host expenses	This a printable form for the Host to list any expenses that they have while running the event. Submit this to the treasurer and the Club will reimburse the Host.
(5A) Meal tickets	These fully automatic meal tickets are primarily for the serving staff at the event. Staff can easily deliver the meals to the right people. These tickets only need to be printed, cut up and distributed to the attendees.
(5B) Drink tickets	These tickets for complementary drinks can be configured for any event and distributed to the attendees who hand them to the server in exchange for a drink. It's also a good way for the venue to keep track of how many drinks they have served.
(6A+B) Envelope Labels with or without Table Numbers	These automatically generated labels are handy if you have envelopes to stuff with things like Name Tags, Meal, Drink and Drawing tickets, etc. They labels are numbered and in alphabetical order, making it easy and quick to lay then out at the event. Unclaimed envelopes are a clear record of no shows & eliminates the need to 'Check-in' guests at the event.
(7A) Event Expense Report	The is a financial report that the Host can turn into the Treasurer after the event. Some fields are automatically populated. Other fields may need manual intervention. The result is formatted to print to paper or PDF.
(7B) Event Review Report	This is a report that the Host can fill out to rate the Event. It can be printed and submitted with the other information and checks after the Event.
(8A+B) Door prize tickets	These fully automated tickets are useful if there is to be a raffle or door prize. There's two lists. One for each individual at the event and the other for couples. All the Host has to do is to print them, cut them up and put them in the 'Fish Bowl" for the drawing. Using these instead of numbered tickets will make the drawings move more quickly and accurately. No more fumbling around for your reading glasses so you can read those tiny numbers on a ticket. Most people will recognize their own name when it's called, even after a few adult beverages! Click to see an example of the Individual Door Prize Tickets.
(9) Cover sheet	The host will receive a copy of this cover sheet with the print job if he asks the webmaster to print the job.