Shift Pattern Builder

This tool helps you put a duty pattern together and turn it into the Force Duties spreadsheet, ready to send. Fill in your details, build the pattern a week at a time, then download the finished file. You can only choose shifts that are on the duties list, so everything comes out with a valid code and nothing left to fix.

Your details

Who the pattern is for. This goes on the cover sheet.

Surname

First name

Warrant / collar no.

SAP no.

HR reference

Full or part time

Department / Division

Line manager

Pattern authoriser

Pattern start date (a Monday) Pick a Monday

Build the pattern

Tap any day to choose a shift, a rest day or a free day. The colours show the time of day, so the shape of each week is easy to read.

New to this? Start at Week 1, Monday — tap the day and pick a shift. Set how many weeks your cycle runs to with the menu below. The two small buttons on the left of each week let you copy the week above, or fill a whole week in one go.

Check & download

Have a quick look over the pattern, then download the finished spreadsheet.

Repeat my cycle to fill all 10 weeksOnly needed if Duties ask for the full 10-week grid

This builds the finished Force Duties spreadsheet for you — there's nothing to upload. It saves with the officer's surname and the start date. Open it, have a quick look that the View Here and For Build tabs look right, and it's ready to send.