Best way to track Sacrament Meeting talks

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
User avatar
wrigjef
Member
Posts: 493
Joined: Sun Mar 01, 2009 8:38 am
Location: Chesapeake, Virginia
Contact:

Best way to track Sacrament Meeting talks

Postby wrigjef » Sat May 13, 2017 9:57 am

What are some best practices to track who has given talks?

User avatar
showseason
Member
Posts: 136
Joined: Sat Feb 26, 2011 9:56 pm
Location: Oregon

Re: Best way to track Sacrament Meeting talks

Postby showseason » Thu May 18, 2017 8:44 am

wrigjef wrote:What are some best practices to track who has given talks?


The attached simple spreadsheet application is all I use. Shows speakers by date and also how long it has been since they spoke (calculated formula used).
Attachments
example.pdf
(34.61 KiB) Downloaded 284 times

quandmeme
New Member
Posts: 28
Joined: Wed Jul 13, 2011 4:55 pm

Re: Best way to track Sacrament Meeting talks

Postby quandmeme » Sun Jun 04, 2017 8:25 am

The method working its way through Vegas wards is a google spreadsheet that all the bishopric members of that ward can see concurrently.
There is a count query that updates in real time the last time the adults and the youth have spoken.
We track the prayers and the conducting rotation on the same sheet --we haven't needed the query mechanism for prayers.

We would never go back to non-cloud solutions, it's so important for us to all be seeing it in meetings and then during the week for the bishopric member who is making the assignments to have a single list that is always up to date (i.e. that we never have to synchronize).

quandmeme
New Member
Posts: 28
Joined: Wed Jul 13, 2011 4:55 pm

Re: Best way to track Sacrament Meeting talks

Postby quandmeme » Sun Jun 11, 2017 11:27 am

Here's a version of the spreadsheet for reference if you want to see the query mechanism:

https://docs.google.com/spreadsheets/d/ ... sp=sharing

quandmeme
New Member
Posts: 28
Joined: Wed Jul 13, 2011 4:55 pm

Re: Best way to track Sacrament Meeting talks

Postby quandmeme » Sun Dec 03, 2017 11:38 pm

Sorry, that link lets you see but not duplicate now. Here is a version that currently saves a copy:

https://docs.google.com/spreadsheets/d/ ... Lgz5Y/copy

sdross
New Member
Posts: 1
Joined: Mon Jan 01, 2018 8:06 pm

Re: Best way to track Sacrament Meeting talks

Postby sdross » Mon Feb 05, 2018 5:32 pm

Are there instructions on importing and updating ward members? Thanks...it looks like a great program...

jspalmer6
New Member
Posts: 0
Joined: Wed Aug 30, 2017 10:16 am

Re: Best way to track Sacrament Meeting talks

Postby jspalmer6 » Thu Feb 22, 2018 3:26 pm

In addition to importing and updating ward members, do you have any explanation on the formulas used? i'm not an excel expert, but know enough to tweak formulas to handle maybe a new 2018 tab, but can't seem to understand nor find where 'Table_2017, or 'Table_2016', etc. are located?

quandmeme
New Member
Posts: 28
Joined: Wed Jul 13, 2011 4:55 pm

Re: Best way to track Sacrament Meeting talks

Postby quandmeme » Fri Feb 23, 2018 11:56 am

The theory of this would be that it would live in google docs so that everyone in the bishopric could see it in real time. So if you try exporting it to Excel, I don't know if the SQL expressions will work. If you prefer Excel, you might be able to convert it to a vllookup?

In google sheets the ranges are under Data>Named Ranges... From there, just click "+ Add a range" after you have created the 2018 tab. Someone may upload their updated if they have time.

You can do an initial population of the table by exporting a csv file from MLS or LCR and taking the names from there. When I did it, I wanted last name first so I could sort lists and find people more easily. I just used a concatenate function to generate a whole ward's worth of names in last comma first order. The query is supposed to handle last first or first first, though if you sort differently.

Because I took out people that we never were going to ask to speak, I didn't just reimport the list each time I updated because that would restore them to the list. Every once and a while, I or the execsec would just look at the move-in move-out report and the youth birthday reports (i.e. action and interview list) and add members to the appropriate table.

I'm remembering that MLS let me export birthdays easier than LCR but that may have changed and you may not care about the age of the youth on this sheet. (Our bishop at the time wanted the older youth speaking more frequently so that was useful for his tracking.)


Return to “General Clerk Discussions”

Who is online

Users browsing this forum: Bing [Bot] and 1 guest