Modification on google sheets excel file - accomodation

  • Status: Closed
  • Hadiah: €114
  • Penyertaan diterima: 14
  • Pemenang: IgeS

Ringkasan Peraduan

- files is "copy of [login to view URL]"
- link [login to view URL]
- 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"

Kemahiran Disyorkan

Maklum balas Majikan

“great guy to work with”

Gambar Profil alexlexa, Slovenia.

Penyertaan teratas dari peraduan ini

Lihat Lagi Entri

Papan Penjelasan Umum

  • jaflores77
    • 3 bulan yang lalu

    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.

    • 3 bulan yang lalu
  • sunnyland63
    • 3 bulan yang lalu

    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.

    • 3 bulan yang lalu
  • Milon4646
    • 3 bulan yang lalu

    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

    • 3 bulan yang lalu
  • alexlexa
    Penganjur Peraduan
    • 3 bulan yang lalu

    you have the link to the file now in description

    • 3 bulan yang lalu
  • ammar7may
    • 3 bulan yang lalu

    Please see my entry and comment. Thanks.

    • 3 bulan yang lalu
  • vishwa247
    • 3 bulan yang lalu

    The gsheet must be enabled to be opened offline.

    • 3 bulan yang lalu
  • augustineugbeda
    • 3 bulan yang lalu

    the link doesnt work and spreadsheet can't be opened

    • 3 bulan yang lalu
  • nanda1208
    • 3 bulan yang lalu

    Hi, I've asked for permission to work on it. ID: mf.mendes.silva.

    • 3 bulan yang lalu
  • davidmm90
    • 3 bulan yang lalu

    It has permission request, I asked for permission...

    • 3 bulan yang lalu
  • Daniel101188
    • 3 bulan yang lalu

    Hi, the spreadsheet can't be opened

    • 3 bulan yang lalu
  • hectorjj
    • 3 bulan yang lalu

    Not able to open the spreadsheet

    • 3 bulan yang lalu
  • Huzamul
    • 3 bulan yang lalu

    Request Sent..

    • 3 bulan yang lalu
  • dpswain
    • 3 bulan yang lalu

    Not able to open the spreadsheet

    • 3 bulan yang lalu
  • khaledossonono
    • 3 bulan yang lalu

    this link not work https://zasedenost2018.ghsheet

    • 3 bulan yang lalu

Tunjukkan lebih banyak komen

Bagaimana mula dengan peraduan

  • Paparkan peraduan anda

    Paparkan Peraduan Anda Cepat dan mudah

  • Dapatkan berjuta penyertaan

    Dapatkan Bertan-tan Penyertaan Dari serata dunia

  • Anugerahkan penyertaan terbaik

    Anugerahkan penyertaan terbaik Muat turun fail-fail - Mudah!

Paparkan Peraduan Sekarang atau Sertai kami Hari Ini!