Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.

1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).

2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.

-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.

3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.

-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.

-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank. 

4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings. 

Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.

If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated?

Sorry this is a lot of info and hopefully makes sense.

​Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank. 4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings. Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated? Sorry this is a lot of info and hopefully makes sense.   Read More

​