Excel accomodation file modification for next year -- 2
- Status: Closed
- Prize: €40
- Entries Received: 8
- Winner: xSharaf
Contest Brief
- The file "zasedenost-old.xlsx" is a file used for accomodation reservations.
It needs to be prepared for 2018...now it was for 2017.
- In the mentioned file they are 2 tabs for statistics of room occupancy.
The 1st tab sheet "room occupancy DB" is the database.
The 2nd tab sheet "occupancy rate" is the statistics of the rooms occupancy per month and on an annual basis. It should be done the same for year 2018.
- The end file is used in google sheets as a gsheet file later on and shared amon users so its very important that all function that work in excel will work later on in google sheets.
- Don't change other formulas and cells because almost everything has some formula
I am also attaching some screenshot to see how it works in practice.
The end file has to be in excel (.xlsx) and I will also grant the winner access to google sheets so that the file can be implemented to google sheets and can work as .gsheet file. I can then check if all works fluently and without any problem.
Recommended Skills
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!