SPREADSHEETS
Page 53
If you've noticed an error in this article please click here to report it so we can fix it.
Spreadsheets, by their very nature, work in columns, so they are ideal for lists. Here's how to make an automatic duty roster:
Type the names of your staff down the screen, and the days of the week across the top. Level with your first driver — in the example he's called Les Barker — type his hours: Three nights on, three days off, Saturday afternoon. . and then carry on typing because he works a 12-day cycle. . . two more afternoons, three mornings. Use the spreadsheet's COPY facility to copy this three or four times along his row.
This becomes your master roster. You COPY seven-day chunks of it and insert them beside the other drivers. Only you see the long master list beside Les Barker's name: because, when you tell the spreadsheet to PRINT, you instruct it to print only up to Saturday.