Scheduling…
This may help get you started.
I took this Microsoft Office Employee Scheduling Excel Template:
[url:1908kchm]http://office.microsoft.com/en-us/templates/TC062561761033.aspx[/url:1908kchm]
And converted it a Quantrix Model. Concepts used were:
– Conditional Formatting to color the cell background based on the cell value.
– Constrain Input to restrict the value of the job cells to the available jobs in the Employee Jobs Matrix
– Added a week dimension so that multiple weeks can be kept in the same model.
This may help you get started – but if not or if you have any additional questions, please don’t hesistate to post again.
-Mike