Excel-based Rostering Systems

 

 

 

We offer, for purchase or rental, these 2 systems which we have developed over the years, both written in Excel, which assist the production of rotas and rosters.

 

 

 

 

RotaPlan

 

RotaPlan assists the design of (alternative) shift patterns and full-year rosters for sub-groups within a workforce.

 

It also provides a mechanism to evaluate the "unsocial-ness" of different shift patterns including, typically, the mix of day, afternoon and night shifts - but also for different groups who work e.g. more/less Saturdays and/or Sundays.

 

Further details on RotaPlan

 

 

 

 

RosterBuilder

 

RosterBuilder is available in several versions - suitable for different numbers of employees  for up to a year.

 

Further details on RosterBuilder

 

 

 

 

 

 

 

 

Rosters available for purchase are provided in Excel format.

 

Each file contains 4 worksheets as follows:

 

  • Commentary – describes the roster, and how to customise it.

 

  • Setup -  inputs for Start Date, Bank Holiday Dates, Employee/Crew Names, Shift Names and Worked/Paid Lengths.

 

  • Roster View – A 365-day roster for all crews (or individuals), with shift counts for each day, and for each crew/individual.

 

  Click image to enlarge

 

  • Calendars - An individual shift calendar for each crew/individual (53 weeks or 371 days).

 

  Click image to enlarge

 

 

Costs of these rosters is available on application and will be sent by email following receipt of payment or a Purchase Order.

 (Please email  for details.)

 

If the roster you require is not provided, please contact us to discuss your needs and we will give you a quote to produce it.

  

 

 

For further details of our services, or to arrange a face-to-face or telephone discussion, please contact us.

 

contact Information

EMail:  info@workforce-logistics.com

Phone:   +44 (0)1709 - 326518

 

© Workforce Logistics Ltd 2010