What is the easiest way to enter Team Up calendar data into excel spreadsheets.
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Creating an auto-populating visual calendar for multiple departments to view?I coordinate student schedules across multiple hospital units. I log the shifts in an hours log spreadsheet (date, start time, end time, unit, student name, etc.). Every month, I need to send each unit a schedule showing who is coming in and when so they can review and plan coverage. Right now, this part is very manual, and does not lend to tracking any data like how many students on each units, hours, etc., which we need as a department. We have over 100 students each month, so as much automizing as possible would be helpful as its a big process. Ideally, I’d like something that: Pulls directly from the hours log (no retyping or copy/paste) Is easy to read at a glance for unit managers Can handle many units, many months, and many students Lets me filter by unit + month I'm not really an excel genius, and I've been using copilot to help me with some of this and formulations, but It's not providing me with accurate formulas for the actual calendar conversion. If there are any resources on what formulas to use, what platforms that I could maybe look into for how to do this, or just honestly any advice at all. We've gotten the data tracking mostly drafted up and it's able to pull from pivot tables and show the analytics, but the calendar is my biggest hurdle at the moment. submitted by /u/JuggernautFlashy6489 [link] [comments]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]
- What would you do with this task, and how long would it take you to do it?I'm going to describe a situation as specifically as I can. I am curious what people would do in this situation, I worry that I complicate things for myself. I'm describing the whole task as it was described to me and then as I discovered it. Ultimately, I'm here to ask you, what do you do, and how long does it take you to do it? I started a new role this month, I am new to advertising modeling methods like mmm, so I am reading a lot about how to apply the methods specific to mmm in R and python, I use VScode, I don't have a github copilot license, I get to use copilot through windows office license. Although this task did not involve modeling, I do want to ask about that kind of task another day if this goes over well. The task 5, excel sheets are to be provided. You are told that this is a clients data that was given to another party for some other analysis and augmentation. This is a quality assurance task. The previous process was as follows; the data the data structure: 1 workbook per industry for 5 industries 4 workbooks had 1 tab, 1 workbook had 3 tabs each tab had a table that had a date column in days, 2 categorical columns advertising_partner, line_of_business and at least 2 numeric columns per work book. some times data is updated from our side and the partner has to redownload the data and reprocess and share again the process this is done once per client, per quarter (but it's just this client for now) open each workbook navigate to each tab the data is in a "controllable" table bing bing home home impressions spend partner dropdown line of business dropdown where bing and home are controlled with drop down toggles, with a combination of 3-4 categories each. compare with data that is to be downloaded from a tableau dashboard end state: the comparison of the metrics in tableau to the excel tables to ensure that "the numbers are the same" the categories presented map 1 to 1 with the data you have downloaded from tableau aggregate the data in a pivot table, select the matching categories, make sure the values match additional info about the file the summary table is a complicated sumproduct look up table against an extremely wide table hidden to the left. the summary table can start as early as AK and as late as FE. there are 2 broadly different formats of underlying data in the 5 notebooks, with small structure differences between the group of 3. in the group of 3 the structure of this wide table is similar to the summary table with categories in the column headers describing the metric below it. but with additional categories like region, which is the same value for every column header. 1 of these tables has 1 more header category than the other 2 the left most columns have 1 category each, there are 3 date columns for day, quarter. REGION USA USA USA PARTNER bing bing google LOB home home auto impressions spend ...etc date quarter impressions spend ...etc 2023-01-01 q1 1 2 ...etc 2023-01-02 q1 3 4 ...etc in the group of 2 the left most categories are actually the categorical headers in the group of 3, and the metrics, the values in each category mach the dates are now the headers of this very wide table the header labels are separated from the start of the values by 1 column there is an empty row immediately below the final row for column headers. date Label 2023-01-01 2023-01-02 year 2023 2023 quarter q1 q1 blank row REGION PARTNER LOB measure blank row US bing home impressions 1 3 US bing home spend 2 4 US google auto ...etc ...etc ... etc The question is, what do you do, and how long does it take you to do it? I am being honest here, I wrote out this explaination basically in the order in which I was introduced to the information and how I discovered it. (Oh it's easy if it's all the same format even if it's weird, oh there are 2-ish different formatted files) the meeting of this task ended at 11:00AM. I saw this copy paste manual etl project and I simply didn't want to do it. So I outlined my task by identifying the elements of the table, column name ranges, value ranges, stacked / pivoted column ranges, etc... for an R script to extract that data. by passing the ranges of that content to an argument make_clean_table(left_columns="B4:E4", header_dims=c(..etc)) and functions that extract that convert that excel range into the correct position in the table to extract that element. Then the data was transformed to create a tidy long table. the function gets passed once per notebook extracting the data from each worksheet, building a single table with the columns for the workbook industry, the category in the tab, partner, line of business, spend, impressions, etc... IMO; ideally (if I have to check their data in excel that is), I'd like the partner to redo their report so that I received a workbook with the underlying data in a traditionally tabular form and their reporting page to use power query and table references and not cell ranges and formula. submitted by /u/TheTresStateArea [link] [comments]
- Calendar formatting. Creating a multiple year with automatic fill in based off inputed informationI want to create a calendar for my office, where I can make it once and everyone else can use it. And they understand how to work it I need a calendar where people can request leave time off and by inputting it in one tab it will automatically populate to the correct spot on calendar. I also need to create a weekly calendar that pulls the info from the monthly calendar. If you have any clue how to assist thanks ahead of time submitted by /u/Tx75110 [link] [comments]