Contact Details

If you require further information on any of our services please do not hesitate to contact us by telephone or e-mail. All enquiries are extremely welcome.

T: 01636 816 466

The Old Vicarage
Station Road, Rolleston
NG23 5SE                              

Operational Research

You can always be more efficient

Operational Research is all about using analysis to improve decision making. Dr Angela Moore uses mathematical modeling, statistical analysis, optimisation, sequencing and scheduling techniques to create simple heuristics you can employ to run your operation more efficiently.


Shift pattern software for creating and running an efficient shift pattern. VisualrotaX is run in Excel stacked with features to make running your shift pattern effortless. 

Easy to create new shift patterns 
Shift patterns can be uploaded into the program 
Automated creates individual calendars 
Information on:
How many on a shift each day (can be separated by skill)
Adds up sickness, and holidays, for both the individual and the entire shift pattern 
Gives individuals hours 

VisualrotaX is a brand new shift pattern software run in Excel to make running and creating shift patterns effortless. 
Shift Patterns can either be uploaded directly into the software from our Shift Pattern Book or quickly created by hand. The shift information is inputted into VisualrotaX and then the shifts recorded in the shift pattern sheet added at the top of the sheet. If the number of shifts to be worked each day does not meet the requirements then these days are highlighted in red. This table means that you can tell at a glance when you are and are not meeting you workload requirements. This makes creating shift patterns very quick.


 VisualrotaX is spread out onto several worksheets for easy of reference. There are six worksheets besides the personal calendars to run the shift pattern: 

1.     Shift Pattern

2.     Information Sheet

3.     Staff Records

4.     Graphs

5.     Report

6.     Starters tables

You can either start with the Staff Records sheet or the Information Sheet. Staff Records allows you to record all your staff’s relevant details, such as contact information to allow you to get hold of them to update them with the latest copy of the shift pattern or to arrange cover. This is all voluntary information and not required for the shift pattern except for the individuals Alias which is used in the shift pattern to identify the person and their contacted hours and holiday allocation.

Once a shift pattern is created as shown above, running the shift pattern is also effortless with all of the special features. The shift pattern is highlighted if a night shift, or training day is worked, or if holiday is booked and a sick shift is reported. This means that you know when people are available, working or absent. All of this data is recorded and summarised in the program. On the Shift Pattern sheet the shifts to be worked are recoded in the shifts table at the top of the page. If the number of shifts to be worked on any day do not meet your requirements then they are automatically highlighted in red, indicating a problem. This can happen when you are creating the shift pattern, or when running it as someone goes either off sick or on holiday. Then you can see who is available to cover the shift and the hours that individual is already scheduled to work. This makes organising cover easy. The highlighted night shifts also make planning easier because it is easy to spot where you cannot follow a night shift by a day shift etc. 

One of the main features of this software are the individuals calendars. These are automatically created for all individuals from the shift pattern. They inform the individual when they are expected to work, the start and finish times of the shifts and when they are absent due to holidays or sickness. They also summarise the hours that individual is due to work and the holidays they have left to book.