• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Dashboard - To find Rooms available along with Trainers

MaunishP

Member
Hi Team,

I would like to build a dashboard to know which all training room are occupied from which date to which date, along with time in all mentioned location after inserting data manually. These training rooms should be occupied 24 * 7.
Would also like to know which trainer has no projects from which date to which date.
If in case we cancel any training room for particular 1 or 2 days it should show us as available with time duration.

Please find below given ask :

Should be able to check which Trainer is available in each site.
What room is available for training?
What time they are available?
For cancelled classed, put a diff color with cancelled note


I have added location, trainer name, project, training room names.

Would request you to kindly help on this project as i need to show for approval on 01/25.


Regards,
Maunish Patel
 

Attachments

  • ProjectBookings.xlsx
    11.6 KB · Views: 10
MaunishP
With Your data ...
it would be do something 'opposite way' ...
... when something is free? ... there would be a lot of frees ... a lot!
Why not track/show - when something is occupied?
... then all other times those are available!

... or You gotta have a lot of data to share
and much more ideas from You!
 

Attachments

  • ProjectBookings.xlsx
    20.8 KB · Views: 17
Thanks for your reply @vletm

Below given are responses to each questions :

... when something is free? ... there would be a lot of frees ... a lot! - We want to track Training Room, Trainers, Date and Timings when its free / available so that front desk team can book it accordingly. As we will be utilizing training rooms 24 hours * 7 days. We need to find which one is available

Why not track/show - when something is occupied?
... then all other times those are available!

... or You gotta have a lot of data to share - I have inserted random data, let me insert some more data for you to work
and much more ideas from You! - Its something similar to conference rooms bookings however i would like to see this information in a week wise format regarding which training room is available, trainers, date and timings.

Regards,
Maunish P
 

Attachments

  • ProjectBookings.xlsx
    12.1 KB · Views: 9
MaunishP
You wrote: Below given are responses to each questions :
#1) Yes ... You copied almost same phrases as in Your original case.
You could see those Your needed from my sample as there are total two rows!
#2) Seems to be skipped
#3) Yes ... You uploaded same file as original! ... not even my file.
My version show those a week wise format as You would notice as well as other informations too.

Which Year this should be show for approval? Hmm?
Any ideas?
 
Extremely sorry for uploading incorrect file :-(

I need to get this file for approval by 01/25/19 max by 01/31/19

Also find attached file which we were using it earlier, however still i am not able to find training rooms availability, trainers, date and timing.

Regards,
Maunish Patel
 

Attachments

  • ProjectBookings-vletm.xlsx
    22.4 KB · Views: 24
  • Trainingrequest.xlsx
    41.6 KB · Views: 13
Thankyou @vletm

Show your file and thoughts came nearby what they was as expectation. Once i received update for final confirmation will again thank you.

Regards,Maunish Patel
 
Back
Top