This may help get you started.
I took this Microsoft Office Employee Scheduling Excel Template:
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.