Creating rotas from Nova-T6 using Excel

[johnston63]

It must be possible to take the strain out of creating break duty rotas by using Excel and the IF function. Has anyone done this?

[RootsSchImp]

Let's say you wanted to allocated BD to staff free after break up to a max of 2 per staff member and 5 staff per break.

 

If you have staff in rows the use countif to give a count per staff in column C and a count of BDs per break in row 101.

 

Then in your first break column (say that's F) use: =if(and(g2="",$c2<2,f$101<5),"BD","")

 

This won't guarantee you'll get 5 staff per break but it'll give you a basis to work from.

[johnston63]

Thanks very much. That's great.