creating a Work Roster

[drbolouswki]

I have recently created a spreadsheet (first time ever!) that tracks availability of my employee's over a 3 month period - basically this is so I can track reliability, attendance, punctuality etc

The data sheet I use to track from is all manual though - I create it and just assign the shifts manually as best I can

What I want to do is to make excel assign the shifts for me - but I've no idea where this function is found.

Essentially, I have 300 shifts to cover spread out over 12 days

Each day has 25 shifts

I have 35 employees - 16 fulltime with 10 shifts each
19 part-time to cover the remaining 140 shifts

The availability of the part time employees change quite quickly - some 12 day cycles its 19 - others its 17 etc etc

The full time employees will sometimes look for overtime and can work a maximimum of 12 shifts each - but I can do this part manually I would guess

Is there an easy way to set this up? Essentially - input a list of 16 fulltime names which assigns them thier 10 shifts over a 12 day period, and then input the part-time names which assign the remaining shifts equally between the number of part time employees?

Even advising on the right menu to start with would be great - I'm a quick learner!! And the above sounds really easy!

If there is a post on this or an online tutorial or link, I would be very grateful to be directed that way!!

I'm using Excel 2007

Thanks for any help!!

[Simon Lloyd]

Far too much explanation but not enough information, ideally we need to see the workbook you have so we can see your layout and structure, from there we may be able to help!

[drbolouswki]

Thanks for the reply Simon

I can show you the spreadsheet - but as I mentioned I am filling it all in manually, so it's just really simple (rather embarressing its so simple )- the other spreadsheet that tracks availability etc is unrelated to it

The roster is Monday to Saturday for a two week cycle so 12 Columns

25 shifts per day is 25 rows

Currently I'm filling it in manually - what I'd like to do is to have a table that I fill in with fulltime and part time names, which will then automatically fill the roster depending on how many full and part time names get fed in

Fulltime is 10 shifts standard (can do 12 if not enough part time)
Part time cover the remaining shifts after full time is allocated (up to a max of 12 each)

I know I'm talking very basic stuff here - I'm assuming it's some level of conditional formatting - I'll keep trying but would be very appreciative on any pointers

Once again thanks for the reply