Hello! I am a volunteer manager with (sadly) very basic Excel knowledge.



I am looking to record beneficiary engagement in terms of activity attendance in order to track how many people we are reaching and also by way of comparing our reach month to month.

Our volunteers currently run about 33 activities for the elderly per week so there is a lot of data to compare and I don't want the spreadsheet to look clunky. We have paper registers that they post into our office.

Does anyone have any suggestions for a layout of this sort of thing?

Thanks in advance!

Attached is a simple example - you can expand it.

On sheets Volunteers and Clients in column A full names are calculated. To prevent formulas accidentally been overwritten, the columns with full names are hidden;

As there is always a possibility you'll have to cope with 2 (or more) people having same name, there is possibility to add something what makes such names different (when there is something entered into field Ext, then this is added at end of full name);

Total Time and column Hrs on ActivityRegistry sheet are formatted to display more than 24 hours;

Total Time on sheet ActivityRegistry displays total of filtered records. I.e. when you set in table the autofilter e.g. to some activity, client, volunteer, or date range, or to any combination of them, only Hrs for visible records are summarized.

Attached Files

Activities.xlsx (19.5 KB, 6 views)

Hi and welcome
perhaps also search the web for something that could approximately suit your needs and come back so that our members can tailor it as required

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post