What is the easiest way to enter Team Up calendar data into excel spreadsheets.
I work in a hotel where a small, very time consuming part of our job is creating operational set up sheets for meetings and events that happen in the hotel. These sheets are again a very time consuming and tiny sliver of a lot of the FOH staffs daily to do list, so most of the work falls on me (basically OP will do it, so why should we :)
Our operations sheets are created using a bog standard excel spreadsheet, where all details can be entered as per the needed set up / catering / staff support i.e. Technological Requirements, Lunch or Dinner options, Catering Requirements etc. These are usually manually transferred from Team Up, which along with other calendars serves as the back end, meeting and event management system as it allows for all important details to be entered and clearly displayed so that every area in the hotel, be it the kitchen, catering staff, maintenance staff, porter staff or reception and FOH are able to see where something is booked, for how long and what is needed, along with essential contact and billing details.
Our sheets are extremely simple, basically currently just serving as an easier to use word document.
The op sheets serve the importance that, on a basic level, we need to have a simple, quick to read, easy to understand sheet for all requirements listed for any meeting, conference, event, function or meal, so that nobody in the hotel is ever missing and info. These sheets are a clean, simplified version of the Calendar, and hold all essential data.
The sheets are usually also sent to corporate clients who wish to present this summary to all presenters and hosts for the event or meeting / training etc.
What I want to know is, bar culling data manually from what has been entered into the calendar, then manually entering all the data, is there anyway that a CSV file can be read, filtered and the filtered items can be entered into the different sections of these sheets?
EXAMPLE:
Company X Regional Compliance AGM
Team up: Meeting set up for 20 attendees, 2 presenters and 1 monitor.
Excel: MTG x 20, TT x 2 + 1
EXAMPLE 2:
Team up: Tea / Coffee and an array of sandwiches and finger food to be served
Excel: T/C/Sands + FF
More or less, is there a way to set up a pattern recognition for all relevant data, to make it that a CSV file can be imported into the sheet, information is filled out without manual culling and it allows for all info to flow effortlessly between both places?
I have googled, begged AI to help and also tried finding something similar on this sub but its genuinely very hard to properly explain without writing out a post. Thank you in advance :D
[link] [comments]
Want to read more?
Check out the full article on the original site