LinkBack URL
About LinkBacks
Hey all, I could use some tips with my current excel project. I've attached the sheet I am working on to this post.
The part I am specifically trying to work on is the far right of the first tab. where it shows Class room usage and 13 weeks of information. Below that is the same table but in green. When you place a figure in the top section of the weeks that creates a training class that starts that week. Down below you'll see the week you chose go red as well as the 3 weeks after that going red as well. The values in the lower cells become 0, which changes the total available in the cells like AH12 for example.
While this almost works like I need it to I need the bottom class room usage table to also zero out days that can't really be the start of a training class. For example If I put an X in cell AX2 that will block out AX-BA36 then if I put an X in say BD2 it will block out the corresponding cells down below and lower the values in them to 0. The problem arises with the two green cells between the scheduled classes.
On the left cells like AH12 are showing the total slots available to put people into training for that week, these draw from the values in the bottom classroom usage table. When I have something like the situation I described it's still showing those two weeks between the training classes as available, I need to set up some kind of condition that if there is not a block of 4 available they will turn to 0 and go red. So the two between the weeks i selected will also zero out since they cant be used.
These won't be scheduled after that 13 week mark so a class can be scheduled at the end without having the 3 weeks after available here since the table does not reach that far.
Any help would be appreciated.
Register To Reply
I've been going through different scenarios but they always end up cascading back onto the previous columns that should remain available. This is driving me nuts. 
Bookmarks