Excel accomodation file modification for next year -- 2
- Állapot: Closed
- Díj: €40
- Beérkezett pályamű: 8
- Nyertes: xSharaf
A verseny összegzése
- 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.
Ajánlott készségek
Nyilvános pontosítófelület
Így vágjon bele a versenyekbe
-
Indítson egy versenyt! Gyors és könnyű
-
Kapjon akár több száz pályaművet A világ minden szegletéből
-
Díjazza a legjobb pályázatot Töltse le a fájlokat - csak egy kattintás!