Microsoft Office Forums Looking for a way to create a spreadsheet for monitoring activity engagement and data

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2019, 03:20 AM
volunteermanager volunteermanager is offline Looking for a way to create a spreadsheet for monitoring activity engagement and data Windows 10 Looking for a way to create a spreadsheet for monitoring activity engagement and data Office 2013
Novice
Looking for a way to create a spreadsheet for monitoring activity engagement and data
 
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
  #2  
Old 04-05-2019, 04:08 AM
ArviLaanemets ArviLaanemets is offline Looking for a way to create a spreadsheet for monitoring activity engagement and data Windows 8 Looking for a way to create a spreadsheet for monitoring activity engagement and data Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

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
  #3  
Old 04-05-2019, 11:24 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Looking for a way to create a spreadsheet for monitoring activity engagement and data Windows 7 64bit Looking for a way to create a spreadsheet for monitoring activity engagement and data Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
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 lightPecoflyer is a glorious beacon of light
Default

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
Reply

Tags
analytics excel word, help a novice

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a way to create a spreadsheet for monitoring activity engagement and data 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
Looking for a way to create a spreadsheet for monitoring activity engagement and data 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
Looking for a way to create a spreadsheet for monitoring activity engagement and data 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 09:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft