Modification on google sheets excel file - accomodation

Estado: Closed
Premio: €114
Propuestas recibidas: 14
Ganador: IgeS

Winner

Resumen del concurso

- files is "copy of zasedenost2018.ghsheet"
- link https://docs.google.com/spreadsheets/d/1wEJwdpHpl5UUoDCwnlpxiSdY2tjCN71slVuM_WveUSU/edit?usp=sharing
- in sheet Occupancy Rate occupancy for 2016, 2017 is already calculated but i need the data for 2018 and 2019 is missing
- make the sheet for 2020 and it also needs to be connected to the "Occupany Rate" for 2020
- you need to do it simple
- in need training how to do it on my own for the future years for the stats. it can be also some other way if you find a better solution.
(you tube video would be prefered).

Statistic that I need in the occupancy rate:
- room occupation for a specific room per month
- room occupation on an annual basis
- the Occupancy Rate sheet already covers it most
- you can delete rows U and V because I dont need them anymore
- the files has to be as small as possible for fast working when sharing
- formuals have to be simple and clean
- dont make any changes on the sheet "Zasedenost 2018" and "Zasedenost 2019"

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“great guy to work with”

alexlexa, Slovenia.

Principales propuestas de este concurso

IgeS Philippines

0
ariesdela Philippines

0
tushartufan Bangladesh

0
rrubai Bangladesh

0
Milon4646 Bangladesh

0
Milon4646 Bangladesh

0
ammar7may Pakistan

0
ammar7may Pakistan

0
Daniel101188 Venezuela

0

Ver más participaciones

Tablero de aclaración pública

jaflores77
- 5 años atrás
To the owner of the constest, could you give me the raw data, or place it on a new page inside the document? So I can give you another point of view of how to work with the data.
- 5 años atrás
sunnyland63
- 5 años atrás
I have a question re the Zasedenost 2018 or Zasedenost 2019 sheets. When you have a 0 in one column does it count as 0 or 1 in the OccupancyDB sheet? For example 1/01/2018 room 4* as a 0 in it on the Zasedenost 2018 but shows as 1 in OccupancyDB? Thank you for your answer.
- 5 años atrás
Milon4646
- 5 años atrás
Why you should choose me :
Quick Responsible
Unlimited Revisions till 100% Buyer satisfaction.
I can work 24 hours for you.
I want to work $ 2.0 per hours.
Please give me one chance
- 5 años atrás
Organizador del concurso
- 5 años atrás
you have the link to the file now in description
- 5 años atrás
ammar7may
- 5 años atrás
Please see my entry and comment. Thanks.
- 5 años atrás
vishwa247
- 5 años atrás
The gsheet must be enabled to be opened offline.
- 5 años atrás
augustineugbeda
- 5 años atrás
the link doesnt work and spreadsheet can't be opened
- 5 años atrás
nanda1208
- 5 años atrás
Hi, I've asked for permission to work on it. ID: mf.mendes.silva.
- 5 años atrás
davidmm90
- 5 años atrás
It has permission request, I asked for permission...
- 5 años atrás
Daniel101188
- 5 años atrás
Hi, the spreadsheet can't be opened
- 5 años atrás
hectorjj
- 5 años atrás
Not able to open the spreadsheet
- 5 años atrás
Huzamul
- 5 años atrás
Request Sent..
- 5 años atrás
dpswain
- 5 años atrás
Not able to open the spreadsheet
- 5 años atrás
khaledossonono
- 5 años atrás
this link not work https://zasedenost2018.ghsheet
- 5 años atrás