Modification on google sheets excel file - accomodation

Status: Closed
Nagroda: €114
Uzyskane Zgłoszenia: 14
Zwycięzca: IgeS

Winner

Opis Konkursu

- 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"

Zalecane Umiejętności

Winner

Opublikuj Konkurs Taki Jak Ten

Opinie o Pracodawcy

“great guy to work with”

alexlexa, Slovenia.

Najlepsze zgłoszenia do tego konkursu

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

Zobacz więcej zgłoszeń

Publiczna Tablica Wyjaśnień

jaflores77
- 5 lat temu
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 lat temu
sunnyland63
- 5 lat temu
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 lat temu
Milon4646
- 5 lat temu
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 lat temu
Organizator Konkursu
- 5 lat temu
you have the link to the file now in description
- 5 lat temu
ammar7may
- 5 lat temu
Please see my entry and comment. Thanks.
- 5 lat temu
vishwa247
- 5 lat temu
The gsheet must be enabled to be opened offline.
- 5 lat temu
augustineugbeda
- 5 lat temu
the link doesnt work and spreadsheet can't be opened
- 5 lat temu
nanda1208
- 5 lat temu
Hi, I've asked for permission to work on it. ID: mf.mendes.silva.
- 5 lat temu
davidmm90
- 5 lat temu
It has permission request, I asked for permission...
- 5 lat temu
Daniel101188
- 5 lat temu
Hi, the spreadsheet can't be opened
- 5 lat temu
hectorjj
- 5 lat temu
Not able to open the spreadsheet
- 5 lat temu
Huzamul
- 5 lat temu
Request Sent..
- 5 lat temu
dpswain
- 5 lat temu
Not able to open the spreadsheet
- 5 lat temu
khaledossonono
- 5 lat temu
this link not work https://zasedenost2018.ghsheet
- 5 lat temu