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
E: alec@oranalysts.com

The Old Vicarage
Station Road, Rolleston
Newark
Notts
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.

angelamoore@visualrota.co.uk

Yearly Planners

Our latest product are Yearly Planners that you downlaod, via e-books. They are for office workers who want to manage their holidays and absences. Included in the e-book is a link to download an excel file that manages your holidays, and records absences and training. The excel spreadsheet is interactive so that you can record your absence and holidays and have it calculate how many people will be in each day and your Annual Absence Rate for you automatically.

Planner 04

Yearly Planner

The year is set out in one long row, and there is space for up to 25 people to be recorded on the planner. Once you have entered their names and the amount of holiday they are each entitled to during the year, you can begin to record their holidays, training and absence.

The planner is designed for people who work office hours. E.g. one shift Monday to Friday. The planner can be used if you work weekends as well.

There are four types of interactive activities you can record on the planner;

  • H for Holiday

  • S for Sickness

  • T for Training

  • A for Authorised Absence

Using these shifts you can see at a glance, how many people will be in the office each day, how much holiday each person has taken and is entitled to, how often they have been sick or absent and the amount of training each person has received during the year. These can be either full or half day events.

You can also record notes and comments of any other events.

Calculations

The planner does a number of calculations for you. You can enter the number of holidays, Bank Holidays and Carry Over of holidays from last year. Then the spreadsheet will automatically calculate how many holidays each person is entitled to during the year. As holidays are taken the Holidays Left column will count down.

The planner will also add up the number of sickness days, absence days and training days each person has taken during the year.

At the top of the planner the number of absences are calculated, and the number of people in complete attendance each day.

At the bottom of the planner, the Absence and Sickness Rates for the year is automatically calculated for you.

Holidays

Holidays are always difficult to manage. This planner calculates the number of holidays each person is entitled to and then counts down as holidays and even half days of holiday are taken. This way you can manage your office better. You can see at a glance how many other people are either absent or on holiday each day and how much holiday they are entitled to. This will make the choice of accepting or refusing each holiday request quicker.

If a person requests too much holiday during the year, they will automatically cause the holiday calculator to alert you and continue counting. This means that if you allow holidays to be brought forward, you can still record the holidays and then enter a negative number in the Holiday Carry Over cell next year.

Many countries have a minimum holiday entitlement. This means that by law, dependent upon the country you are working in, you need to legally ensure that all of your employees take or have the opportunity to take their minimum holiday entitlements. In the UK for example the current minimum holiday entitlement is 5.6 weeks at time of writing.

 Professional Yearly Planners

The Professional Yearly Planners also have additional spreadsheets. The first spreadsheet is the “Year”. On the “Year” spreadsheet you enter all of the information. The following 12 spreadsheets are the months of the year. These are created automatically from the information you enter on the “Year” spreadsheet. Each one is designed to be printed out on to an A4 sheet. It highlights what holidays, sickness, absence and training everyone will be taking or has taken that month. Also everyone’s names and the number of holidays they have remaining till the end of the year is included. The calculations on the number of sick days, training and authorised leave taken is hidden. This way people in the office cannot see at a glance how much sickness etc. everyone has taken.

 

pLANNER 13

 

In the figure  above you can see how each month is laid out. At the top is your Company Name (Acme) and Department (Office). The name of the month (May) and year (2016) is clearly visible as is the date (21/04/15) it was printed. This way it is easy for you to identify which sheet you printed out when.

The names of the people in the group are displayed on the left hand side, with the number of holidays they have left. This way they can plan their holiday requests based on what holidays they and others have already booked.

When they book a holiday it is highlighted on the printout, as is sickness, training and authorised leave. Above each day is a count to show how many people will be in the office and how many will be absent. In this way people can plan meetings, training and their holidays to tie in with what everyone else is doing.

There is also a space at the bottom to write notes, this can be either before or after it is printed.

The professional yearly planners also have graphs that show you when and how, holiday, and absence has been taken over the year. This means that you can see easily if your holiday management is working or when it fell down.

UK Amazon Links

Calendar 2015

Fiscal 2015-16

Academic 2015-16

Professional Fiscal 2015-16

Calendar 2016

Professional Calendar 2016

US Amazon Links

Calendar 2015

Fiscal 2015-16

Academic 2015-16

Professional Fiscal 2015-16

Calendar 2016

Professional Calendar 2016