Further editing of Excel Doc
- or -
Post a project like this2382
$$
- Posted:
- Proposals: 3
- Remote
- #1718265
- Awarded
Description
Experience Level: Intermediate
Description of excel work: The attached document works like a pickup tool and was actually created for me by someone on PPH.
The process works currently as follows:
Step 1 - User selects the Paste to LW button to ensure all data is copied over to the relevant fields in the page.
Step 2 - User updates the data for market segmentation accordingly.
Step 3 - Prices are updated in the BAR column
Step 4 - Information is analysed as required.
This is what is happening currently, what i need from you for the future....
1. I need this document to work properly on my mac excel, it was working fine but before the additional changes were made to the document since the new changes (incomplete) were made i cannot use the document on my mac excel.
2. I need the document to be more stable, i need to ensure everything works as it should. The buttons should do exactly what i need them to. I add more months and add/remove more segments this should work without any technical problems.
3. The calendar - You will be able to see a calendar on the spreadsheet, I actually do not need this calendar. What I would like to happen is based on some instructions i would like a little table or something presentable added to the document which simply would show me dates that are busy. e.g. when occupancy is over a certain percentage given a specific date to arrival then this would be classed as a busy day. The pickup tool is generally completed for a period up to 6 months at a time. On each page I would like to have to display in this section all dates that are busy from all months so that I don't have to go and look at every month to find out which dates are busy and which are not, this would need to be consistent on every monthly page created from the currently selected month (the tab) onwards.
4. Pickup Trendline - The current pickup trend line does not serve its purpose, I need a trend line to display the pickup for each day of the week by segment, in addition to this I would need some kind of forecast of pickup which could again be a trend line to simply show based on only the historical data what could be the potential pickup per segment for occupancy by day of week.
5. You will notice that based on the fact that by saving the data prior to overriding it this allows me to see the history in the relevant section of the workbook. At the moment you will see it is only limited to 5 weeks. I would like this to be changed and I don't have a problem with what the change leads it to be. I just want to be able to select a period of history and then see the trends for the "BAR, AP and Rooms Occupied" and make a comparison with any other period required.
I have tried to explain everything in greater detail so that you fully understand what is required before you submit your proposals. Please only submit offers if you fully understand my requirements, have good competitive offers and more importantly know how to do the job.
I have used PPH for quite some time for excel docs and are fully aware of the level of offers I get, please ensure you send your very best offers in terms of price because this is something I will have a primary focus on.
Thanks
The process works currently as follows:
Step 1 - User selects the Paste to LW button to ensure all data is copied over to the relevant fields in the page.
Step 2 - User updates the data for market segmentation accordingly.
Step 3 - Prices are updated in the BAR column
Step 4 - Information is analysed as required.
This is what is happening currently, what i need from you for the future....
1. I need this document to work properly on my mac excel, it was working fine but before the additional changes were made to the document since the new changes (incomplete) were made i cannot use the document on my mac excel.
2. I need the document to be more stable, i need to ensure everything works as it should. The buttons should do exactly what i need them to. I add more months and add/remove more segments this should work without any technical problems.
3. The calendar - You will be able to see a calendar on the spreadsheet, I actually do not need this calendar. What I would like to happen is based on some instructions i would like a little table or something presentable added to the document which simply would show me dates that are busy. e.g. when occupancy is over a certain percentage given a specific date to arrival then this would be classed as a busy day. The pickup tool is generally completed for a period up to 6 months at a time. On each page I would like to have to display in this section all dates that are busy from all months so that I don't have to go and look at every month to find out which dates are busy and which are not, this would need to be consistent on every monthly page created from the currently selected month (the tab) onwards.
4. Pickup Trendline - The current pickup trend line does not serve its purpose, I need a trend line to display the pickup for each day of the week by segment, in addition to this I would need some kind of forecast of pickup which could again be a trend line to simply show based on only the historical data what could be the potential pickup per segment for occupancy by day of week.
5. You will notice that based on the fact that by saving the data prior to overriding it this allows me to see the history in the relevant section of the workbook. At the moment you will see it is only limited to 5 weeks. I would like this to be changed and I don't have a problem with what the change leads it to be. I just want to be able to select a period of history and then see the trends for the "BAR, AP and Rooms Occupied" and make a comparison with any other period required.
I have tried to explain everything in greater detail so that you fully understand what is required before you submit your proposals. Please only submit offers if you fully understand my requirements, have good competitive offers and more importantly know how to do the job.
I have used PPH for quite some time for excel docs and are fully aware of the level of offers I get, please ensure you send your very best offers in terms of price because this is something I will have a primary focus on.
Thanks
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