Home teaching analysis in Excel?

Discussions about the Leader and Clerk Resources on lds.org.
Post Reply
CWatsonJr
Member
Posts: 67
Joined: Sun Jun 27, 2010 9:25 pm
Location: United States

Home teaching analysis in Excel?

#1

Post by CWatsonJr »

I want to be able to create a one sheet analysis (using Excel) where I can show our critical families (widows, singles, children and/or youth in the home, single parents, etc.) home teachers and the last quarter history (using percentages) of visits; perspective elders that need assignments; if perspective elders & AP youth are assigned EQ or HP companions; number of companionships for both EQ and HP; and a few other things as well. The data to do this used to be available in MLS but with the advent of LCR is no longer available (at least I have been unable to find it).

I have already created a report which shows all of the EQ, HP, PE, Teachers, and Priests and which quorum/group their companion is in along with statistical breakdown of the companionships but I had to hand enter the companionships.

I have not been able to figure out a way to get the data out of LCR to create this report. I have thought of scraping it out but didn't really want to do that if I didn't have to.

Any ideas?
Post Reply

Return to “Leader and Clerk Resources”