How to set up volunteer rota

%3CLINGO-SUB%20id%3D%22lingo-sub-183931%22%20slang%3D%22en-US%22%3EHow%20to%20set%20up%20volunteer%20rota%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183931%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20the%20rotas%2Fschedule%20for%20volunteers%20at%20my%20church.%20Is%20it%20possible%20for%20excel%20to%20allocate%20volunteers%20to%20a%20rota%20whilst%20taking%20into%20account%20the%20days%20they%20are%20not%20available%3F%20Each%20rota%20has%20a%20list%20of%20names%20of%20volunteers%20prepared%20to%20be%20on%20the%20rota.%20Before%20the%20rota%20is%20completed%20we%20ask%20them%20to%20tell%20us%20the%20dates%20they%20can%20not%20help%3B%20then%20the%20names%20are%20allocated%20to%20the%20rota%20as%20fairly%20as%20possible%20making%20sure%20they%20are%20not%20rostered%20on%20a%20day%20they%20are%20unavailable.%20Then%20the%20rota%20is%20published%20paper%20format.%20I%20made%2C%20what%20i%20thought%20would%20be%20a%20helpful%2C%20start%20to%20a%20spreadsheet%20but%20can%20not%20find%20a%20way%20to%20easily%20take%20into%20account%20the%20days%20people%20are%20not%20available.%20Help%20with%20amending%20the%20sheet%20very%20welcome%20alternatively%20examples%20of%20how%20others%20have%20achieved%20similar.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-183931%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20%26amp%3B%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I do the rotas/schedule for volunteers at my church. Is it possible for excel to allocate volunteers to a rota whilst taking into account the days they are not available? Each rota has a list of names of volunteers prepared to be on the rota. Before the rota is completed we ask them to tell us the dates they can not help; then the names are allocated to the rota as fairly as possible making sure they are not rostered on a day they are unavailable. Then the rota is published paper format. I made, what i thought would be a helpful, start to a spreadsheet but can not find a way to easily take into account the days people are not available. Help with amending the sheet very welcome alternatively examples of how others have achieved similar.

1 Reply

@Roger Pollard 

Hi Roger,

 

I hope you managed to solve your problem.

 

However, several churches and charities use our web-based application RotaCentral, which handles volunteers being able to set up their unavailabilities and works around them when allocating.  Optionally, it also does a host of other things such as ensuring that allocations are shared fairly, sending reminders by email or SMS text message, allowing volunteers to choose their own shifts and letting them swap with each other.

 

It's a great way to maximise the convenience for your volunteers while saving you admin time.

You can find us here: https://www.rotacentral.com and we do online on-to-one demos to explain everything and get you started.

I do recommend that you take a look.

 

I hope this helps.


Adam