Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 04-05-2019, 03:20 AM
volunteermanager volunteermanager is offline Windows 10 Office 2013
Join Date: Apr 2019
Posts: 1
volunteermanager is on a distinguished road
Smile Looking for a way to create a spreadsheet for monitoring activity engagement and data

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!

Last edited by volunteermanager; 04-05-2019 at 03:22 AM. Reason: typo
Reply With Quote
Old 04-05-2019, 04:08 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 426
ArviLaanemets will become famous soon enough

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
File Type: xlsx Activities.xlsx (19.5 KB, 2 views)
Reply With Quote
Old 04-05-2019, 11:24 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,367
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light

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
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote

analytics excel word, help a novice

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Spreadsheet or any program to manage contracts from which I can create invoices midrees Excel 4 11-22-2016 09:51 AM
I want to continue a spreadsheet I did not create jgrubby Excel 2 10-01-2015 04:15 PM
Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes esherwood Mail Merge 1 07-21-2014 09:55 PM
activity id number showing together with activity name ketanco Project 1 04-08-2014 01:27 PM
Create template that auto-fills from excel spreadsheet m.buskirk5 Publisher 0 07-02-2012 03:09 PM

All times are GMT -7. The time now is 08:49 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft