Create a booking pace and pickup tool in excel
2916
$$
- Posted:
- Proposals: 2
- Remote
- #1125968
- Archived
Description
Experience Level: Intermediate
General information for the business: Create a booking pace and pickup tool in excel
Description of excel work: I need a booking pace and pickup tool creating in excel, This tool should have an input field of specific data for bookings made into the future. I would need a table area created where information can be inputted manually by the user for the year. The table needs to be broken down by individual segment, by day for each month. I think it would be better if a new page could be used for each month on the excel file. Not all of the hotels i manage have the same number of market segmentation so i would need to have an option to add up to 20 segments data per month but bearing in mind this may not always be used. On each table i would need to have headings, so data input field of Date, Day of week, Market Segmentation, Available Rooms, Total number of rooms sold at each segment level, so segment 1, 2, 3, 4 etc...., room pickup from previous update (so for example this column would need to calculate the new rooms sold from the previous rooms sold for the same date, room type sold, rate room is booked on, room revenue, ADR (Average Daily Rate), RevPAR (Revenue Per Available Room), MPI (Market Penetration Index), ARI (Average Rate Index), RGI (Revenue Generation Index, The idea of the tool is that i as a user can observe pickup of rooms based on different options over a set period. Usually this period would be up to 90 days in advance, if an option could be added to extended the pickup period then this would be great. This tool helps people like me in understanding the business better and allow us to forecast the business better based on pickup. on one page (1st page) i would need the different output options to be shown. I suppose it will work a bit like a pivot table (or something better that you can do) but i don't want to have to select information like a pivot table, i would just like to have the information displayed in a fancy format also with the correct format graphs and output data table for each of the data input field's i have mentioned above. I would like to be able to control the period that i am observing for, i think a date option on the main page 1 option to show the pickup period from x date to y date which i can select the date to be analysed and 1 option again date period for which reservation was made from x date to y date (i am open to something better if you can think of something.
I have tried to add all the "data input fields" that i will need to be setup but please note if you accept this job and prior to me accepting the completed job i may think of something that i require which i have not mentioned now (an additional input field) this would need to be added. I like working with people who are flexible and if this is you and you understand my requirements and the concept fully then please submit your proposals. Thanks! I have added a link here http://www.hotelbenchmarking.eu/upload/homepage-files/pacereport.pdf you can copy and paste this link which will give you a basic understanding of the concept. Please ensure you have understood the concept prior to submitting proposals. Thanks again and i look forward to having you on board. Zak
Extra notes:
Description of excel work: I need a booking pace and pickup tool creating in excel, This tool should have an input field of specific data for bookings made into the future. I would need a table area created where information can be inputted manually by the user for the year. The table needs to be broken down by individual segment, by day for each month. I think it would be better if a new page could be used for each month on the excel file. Not all of the hotels i manage have the same number of market segmentation so i would need to have an option to add up to 20 segments data per month but bearing in mind this may not always be used. On each table i would need to have headings, so data input field of Date, Day of week, Market Segmentation, Available Rooms, Total number of rooms sold at each segment level, so segment 1, 2, 3, 4 etc...., room pickup from previous update (so for example this column would need to calculate the new rooms sold from the previous rooms sold for the same date, room type sold, rate room is booked on, room revenue, ADR (Average Daily Rate), RevPAR (Revenue Per Available Room), MPI (Market Penetration Index), ARI (Average Rate Index), RGI (Revenue Generation Index, The idea of the tool is that i as a user can observe pickup of rooms based on different options over a set period. Usually this period would be up to 90 days in advance, if an option could be added to extended the pickup period then this would be great. This tool helps people like me in understanding the business better and allow us to forecast the business better based on pickup. on one page (1st page) i would need the different output options to be shown. I suppose it will work a bit like a pivot table (or something better that you can do) but i don't want to have to select information like a pivot table, i would just like to have the information displayed in a fancy format also with the correct format graphs and output data table for each of the data input field's i have mentioned above. I would like to be able to control the period that i am observing for, i think a date option on the main page 1 option to show the pickup period from x date to y date which i can select the date to be analysed and 1 option again date period for which reservation was made from x date to y date (i am open to something better if you can think of something.
I have tried to add all the "data input fields" that i will need to be setup but please note if you accept this job and prior to me accepting the completed job i may think of something that i require which i have not mentioned now (an additional input field) this would need to be added. I like working with people who are flexible and if this is you and you understand my requirements and the concept fully then please submit your proposals. Thanks! I have added a link here http://www.hotelbenchmarking.eu/upload/homepage-files/pacereport.pdf you can copy and paste this link which will give you a basic understanding of the concept. Please ensure you have understood the concept prior to submitting proposals. Thanks again and i look forward to having you on board. Zak
Extra notes:
Saqib A.
100% (62)Projects Completed
48
Freelancers worked with
46
Projects awarded
50%
Last project
16 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies