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.

0 Replies