Excel accomodation file modification for next year -- 2
- 状态: Closed
- 奖金: €40
- 参赛作品已收到: 8
- 获胜者: xSharaf
竞赛简介
- 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.