Tradeshow Checklist & Dashboard User's Guide

Information about Tradeshow Checklist & Dashboard User's Guide

Published on July 16, 2014




PowerPoint Presentation: TRADESHOW CHECKLIST & DASHBOARD USERS GUIDE PowerPoint Presentation: Thank You! Thank you for purchasing this template. This document is a guide to help you get started with your template and get the most out of it while planning your next trade show. If you have any questions that are beyond the scope of this document, please feel free to email via our website contact form ( http:// /contact-us/ ) or send us a Tweet ( https:// /PLEXKITS )! Table of Contents: Table of Contents DETAILS TAB OVERVIEW – p4 First Things First – p5 Main Details – p6 Other Details – p7 Checklist Tab Overview – p8 Overview – p9 Columns Explained – p10 Reminders** - p19 Dashboard Overview – p20 Overview – p21 Budget Tracking – p22 Step-by-Step – p23 PLEXKITS Social Links – p27 Details Tab Overview: Details Tab Overview Part 1 PowerPoint Presentation: Make sure you follow Steps 1-3 before changing anything on the Checklist Tab! * Go to the Details tab 1. First Things First! Fill in the Show Name & the Show Start Date. 2. PowerPoint Presentation: While still on the Details Tab - Fill out the Name & Email Address Columns, but leave the Task Count Column the way it is. These cells will update automatically as you assign tasks on the checklist tab 3. ✓ ✓ ✖ When Adding new Employees to the list, it should automatically expand the table, but if it doesn’t, simply drag the bottom corner to include or remove entries. * PowerPoint Presentation: The rest of the Details Tab is optional and can be filled out at any time. Some are linked to other items, but leaving them blank won’t cause any problems. SHOW DETAILS Event Budget - Enter your predetermined Budget for the event here. This number is needed for the budget chart on the Dashboard tab Actual Cost – This number is automatically calculated from the costs entered in the checklist VENUE DETAILS Venue Name - Enter the name of the venue where the show is taking place Venue Address - This will be used to generate the map link Map to Venue – A link to Google Maps will be auto generated here EQUIPMENT SHIPPING DETAILS (Optional) Name - Enter the name of the location where equipment is being shipped Shipping Address - This will be used to generate the map link Map to Venue – A link to a Google Map will be auto generated here Shipment Deadline – This value will be inserted on the checklist HOTEL DETAILS (Optional) Hotel Name - Enter the name of the hotel where your staff is styaing Hotel Address - Enter the address hotel to generate a map Map to Hotel – Another auto-generated Google Maps link to the hotel # of Rooms Reserved - Enter the number of rooms you have booked Length of Stay - Enter the number of days you have each room for Cost per Room - Enter the cost per room per night Total Cost of Hotels – This cell calculates the total costs of the hotel accommodations and enters it into the appropriate checklist cell. *If you don’t have all the details and just the total cost, you can overwrite this cell with the total value 4. 1 2 3 4 6 5 7 8 9 10 11 13 12 14 15 16 # These Cells Auto-Update **Venue Details, Equipment Shipping and Hotel Details were added in Version 2.7 Checklist tab Overview: Checklist tab Overview Part 2 PowerPoint Presentation: A B C D E F G H I J K L Go to the Checklist tab. Now that you have entered the beginning details, your checklist should look like the image below. If it doesn’t you should check to make sure you entered all the details correctly from steps 1-4. Event Title – Title of the event from the details tab Progress Bar –The percentage of tasks already completed ID # - This is a task ID number Task – This is the name of a specific task Stage – Which Stage of the process does this task belong to Category – What type of task is this Effort – Amount of effort required to complete this task Owner – Person responsible for completion of specific task Due Date – Specific Tasks Due Date Cost – Actual Cost of specific Item Status – Current completion status of task Notes – A space for personal notes or comments about task PowerPoint Presentation: The ID column contains a simple ascending count of the tasks when you begin. This column does not use any formulas and the numbers are static. This is for sorting purposes so that if you decide to sort by any of the other columns, you can still bring it back to this original order. The ID column must contain a UNIQUE number in order for the “NEXT TASKS” items on the dashboard to properly register. C. Columns Explained – ID If you add in a new column, you’ll notice that it does not automatically receive and ID number. If you don’t want to have to renumber all the other cells in order to insert it at a specific spot, you can get a unique number that fits the order by using decimals. For instance if you insert a line between 10 and 11, instead of renumbering all the tasks from 11 to the end, you could just give the new item a number of 10.1 * PowerPoint Presentation: The TASK column simple contains the name or brief description of a specific task. The list begins with a huge task list to get you started, but this column is completely editable and completely up to you. You should remove any rows that contain tasks aren’t applicable to your show. Every show is different so make sure you add any additional tasks that may be missing from the original list. D. Columns Explained – Task PowerPoint Presentation: The Stage & Category columns are completely customizable columns used for the purpose of sorting. You can come up with as many stages or categories as you would like to help organize your tasks. E&F. Columns Explained – Stage / Category Use column filtering and sorting to help keep track of tasks and create the perfect view of the progress. * PowerPoint Presentation: The Effort column is the amount of work involved in completing that specific task. This task uses a dropdown box to select your choice from the predetermined list. Select LOW if it involves only a small amount of work. MED is for tasks with an average amount of work and HIGH are tasks with the most work. There is also and N/A category for tasks which effort level does not apply. G. Columns Explained – Effort Each tasks value is weighted based on effort level so that you can accurately gauge your progress so far for the event. For example completing a High effort task would increase your overall percent completion than completing low effort tasks. * PowerPoint Presentation: The Owner column is where you select the member of your team that is responsible for that specific task. The value must be chosen from a dropdown box that consists of all the names listed on the Details tab. If you remove someone from the Details tab after they have been assigned a task, the owner column will become greyed out to let you know it needs to be assigned to a new person. A blank cell is remains greyed out until it has a proper name selected. H. Columns Explained – Owner The name Ron is no longer on the Details Tab so it becomes greyed out PowerPoint Presentation: The Due Date column is the date on which that specific task is due. The date column works together with the Status column. If a task due date has past AND the task has not been marked as “Complete” the date will highlight in Red. If a task has been completed, it will not turn red even after the date has past. The Due Dates that you begin with are are estimation based on the date you entered on the Details tab. I. Columns Explained – Due Date Most of the start dates are created with formulas that look like this = StartDate- 60 to adjust a formula for your show you can either adjust the number in the formula or enter an exact date. To adjust the formula just change the number to how many days before the Show Start Date you would like the task to be completed. If the due date should be a week before the show just change the formula to =StartDate - 7 * PowerPoint Presentation: The Cost column is where you can keep track of all the actual costs of specific items throughout the entire process. Do not enter your budgeted costs in this column, as the sum of this column will be compared to your original budget value you entered on the details tab. The comparison of Actual to Budgeted spend is displayed on the Dashboard tab. J. Columns Explained – Cost A few of the cost cells will be automatically populated with data you entered on the details tab (if applicable) * PowerPoint Presentation: The Status column is where you indicate the current status of a task. You can select either Not Started , In Progress or Completed for the various stages of completion. If you do have a task that you need to mark as blank, selecting N/A in the Effort Column will remove the Status of that specific task . Marking a task as complete or in progress will further your progression towards 100% completion. K . Columns Explained – Status PowerPoint Presentation: The Notes column is just that, a place to enter any notes or comments that you would like to remember for later. There isn’t much to this column, it’s only for convenience and is not connected to any formulas or other cells. L . Columns Explained – Notes PowerPoint Presentation: The Reminder Email feature was removed from our feature list as it is no longer supported by most email clients, though we left it in just in case. If you are using most Outlook on a Windows machine most versions will still work correctly. Essentially if a task is past due and not yet marked as complete a link will appear that when you click it will generate an email to the task owner than mentions which task is still past due, all you have to do is hit send. If you are using a Mail Client that doesn’t support this feature, feel free to delete or clear the cells to remove the feature completely. ** Columns Explained – Reminders** Dashboard Overview: Dashboard Overview Part 3 PowerPoint Presentation: A B C D E F G H I J Go to the Dashboard tab. No cells on this tab need to be edited, they will automatically update as you progress through the planning process. Event Title – Title of the event from the details tab Percent Complete –The percentage of tasks already completed Budget Graph – A comparison of actual spend & budget Tasks By Owner – A breakdown of number of tasks per person Days Until Event – Days left until the event begins Tasks to Complete – Number of tasks left to complete Tasks Past Due – Number of tasks that are past their due date Percent of Budget – Actual Spend as a percentage of Budget Next Task List – A list of the next tasks to complete based on date Tasks by Status – A breakdown of Tasks by completion status Budget Tracking: Budget Tracking Part 4 PowerPoint Presentation: Go to the Details tab 1. Make sure you have entered your budget in the Event Budget Cell 2. PowerPoint Presentation: Go to the Checklist tab 3. Enter any costs from the event in the Cost Column of the applicable task. Ex. The $2500 listed here, is related to the submit full payment item. Even if the item is not marked as complete, you are still able to enter any known costs. 4. PowerPoint Presentation: If you take a look at the Details tab now, you will see the Actual Cost cell has been updated with the costs entered so far. * Go to the Dashboard tab 5. The graph here will show your current costs compared to the budget you set for the event initially. The number to the right will give you a quick percentage showing you if you are on track with your budget. The Green dot means you are still under budget. PowerPoint Presentation: If your Actual Cost is higher than your E vent B udget , you will see this reflected in both the graph and on the Details Tab. The Dot on the Dashboard tab will turn from green to red once you are no longer within your budget. * PowerPoint Presentation: Thank You! Have any questions? Stay in touch!

Related presentations

Other presentations created by PLEXKITS