Modification on google sheets excel file - accomodation

Hali: Closed
Zawadi: €114
Wasilisho Zilizopokelewa: 14
Mshindi: IgeS

Winner

Maelezo ya Shindano

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

Ujuzi unaopendekezwa

Winner

Tuma Shindano kama Hili

Maoni ya Muajiri

“great guy to work with”

alexlexa, Slovenia.

Wasilisho kuu kwenye hili shindano

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

Angalia wasilisho zaidi

Bodi ya Ufafanuzi ya Umma

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