Ok, I completed it. Not sure I am wrapping my simple mind around this matrix thing though(sorry:( ).
http://hotfile.com/dl/136961760/c142711/MATRIX_OF_VALID_SCHEDULING.xlsx.html
Can we make a matrix of possibilities ? Correct me if I am wrong , but you will start scheduling a driver from day 1 of your schedule ; on the first day , any time is possible , but thereafter , every day’s schedule will be validated against the previous day’s schedule. Is this correct ...
That is a list of all employees in order of seniority. I eliminated all of them but John in order to simplify my question.
'ON Call' indicates a day which the driver is supposed to be available for call in just in case we have extra work or someone calls off sick. The driver should not be...
Hello, and thanks soo much for your time.
I would like to use Validation to ensure that I don't schedule an employee for a night shift and then the immediately succeeding or preceeding day shift and or visa versa. I am close to having what I want but some of the final details are giving me...
Thanks, for the help, but.....
I am sorry, I should have clearified, L9:l79 and M9:m79 are not part of the original report, they are part of my failed attempt to solve this problem. I will try you solution in L and M as I hope to find the most simple and efficient way to do this.
I am not...
Newbie here, thanks in advance for your help.
Here is my sample WB
http://hotfile.com/dl/136404528/302dca1/FMDetailedGPSReport_11_30_2011_(Autosaved).xlsm.html
This had been filtered by the "Status" column when uploaded, please remove that filter to see what I am talking about.
I am...