VisualrotaX Layout

C-DESK

Our software to create new shift patterns
Our software to run your shift patterns

VisualrotaX Layout

Optimising for
Every Type of Workload

Articles on Creating Shift Patterns

VisualrotaX is run in Excel 2007 & 2010, it is spread out onto several worksheets which can be edited as required. There are six worksheets besides the personal calendars to run the shift pattern:

Shift Pattern
Information Sheet
Staff Records
Graphs
Report
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.

VisualrotaX

Layout

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. l

Automated creates individual calendars l

Information

-How many on a shift each day

-Adds up sickness, and holidays, for both the individual and the entire shift pattern

-Gives individuals hours

An individuals calendar automatically created from the shift pattern. This shows all the shifts to be worked over more than one year. It also shows the Start and Finish times for each day and a running total of many parameters such as hours worked or holidays left to take.
The printout can be reduced and laminated, or printed on the web after each change.

Annual Individual Calendars

We can customise everything to your specification.
Want to feed in live workloads as they arrive - no problem.
Want a graph of sickness through the year - no problem.
Want to know how much all the staffing costs in the year - it can do that as well.