Hello guys
I have the need to book reservations for rooms/apartments created, do anyone has something like that?
Insert new reservation
Calendar with conditional format for reserved days
Have a great day
Hello guys
I have the need to book reservations for rooms/apartments created, do anyone has something like that?
Insert new reservation
Calendar with conditional format for reserved days
Have a great day
Do you have a sample Excel workbook that you could share with us, to show exactly what you would like? There is a yellow banner at the top of the screen which explains how you can attach a workbook to one of your posts.
Pete
Would this do ?
Hello guys
Thank for your help, i was looking more like this:
https://www.youtube.com/watch?v=6roYrzZXhTs&t=7s
Like hotel/room/home reservations, with checkin and checkout date, with data for reservation (daily price / number of days to stay etc)
Hello mike
I ve checked all that vídeo, the problem is that i cannot get statistic by time, nor have daily cost/booking cost for statistic by date/occupation and so on
Need to have yearly view instead of month, like online pc learning vídeo
Last edited by brainzlp; 10-02-2023 at 03:49 PM.
Hello @brainzlp. I definitely wont help you with this, Im not good at this. Sorry, I dropped the link because I somehow came across it on YouTube.
Thanks anyway, hopefully someone has something similar
it is like a booking management complete (reservation, costs by day or stay and statistics)
How about this?
https://www.youtube.com/watch?v=l8nD1uawIII
There are also several templates in the download available here: https://spreadsheetpage.com/reservation/calendar/
What you need to do is choose a template that fits your needs in terms of recording data (you can add your own columns to its master sheet), then decide what analysis you need to do. We can help you with that here, but you need first to have a workbook with which to work.
Last edited by AliGW; 10-04-2023 at 03:44 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello, thanks for you help
There is where i am struggling, i cannot make a template that has:
- Room reservation on yearly calendar with start-end, name of person and daily value/stay value
- daily revenue
- monthly costs for each room on input to each reservation to check break-even
Basicly this responds to everything: https://www.youtube.com/watch?v=BBYDleQHx6I
But Trevor website is no longer active and i cannot do that by myself without guidance, his tutorials are incomplete, something should have happened
Last edited by AliGW; 10-05-2023 at 06:47 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
Perhaps I can help you. I looked for it and yes, there are these files. They may not be complete samples, but they may still help you in some way. But then finish it yourself. Good luck.
Last edited by MikeVol; 10-05-2023 at 05:50 AM. Reason: Update
Thank you mike
Another person has sent me today a more complete version that i attach, but i cannot have the analysis working like the video
Besides that, it only allows me to book for a Maximum stay of 22 days, and i want 365 days
Can anyone help?
https://www.youtube.com/watch?v=6roYrzZXhTs&t=7s
Last edited by brainzlp; 10-05-2023 at 06:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks