Home Teaching Excel Tool

Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
Post Reply
clarkburbidge
New Member
Posts: 13
Joined: Thu Aug 30, 2012 9:26 pm

Home Teaching Excel Tool

#1

Post by clarkburbidge »

I've created an Excel spreadsheet to help me organize our Home Teaching assignments. Hopefully someone else will find it useful. It requires a dump of the HomeTeaching.csv which I think only a Bishop and Ward Clerk can export and save for you. This data is pasted into the first sheet and then the pivot tables help organize the data to show where changes need to be made. By saving the spreadsheets each time changes are made a record can be kept of who was assigned to whom and when. In order to reassign someone, the home teacher's name must be changed in the HomeTeacherX column for the given household. As changes are made I refresh the pivot tables to see who is missing and an assignment, not in a district, without a companion or not assigned. Once all the required changes have been made it still needs to be hand entered into the MLS, but anything I can do to distance myself from the MLS is a plus in my book.
Attachments
HomeTeachingTool.xlsx
(43.89 KiB) Downloaded 1438 times
kerrykmiles
New Member
Posts: 8
Joined: Sun Nov 28, 2010 10:21 pm
Location: Tumwater, WA USA

Re: Home Teaching Excel Tool

#2

Post by kerrykmiles »

I have my hometeaching.csv file and could use a little more instruction in how to use your tool. Can you publish a set of instructions for how to use this? Thank you!
Post Reply

Return to “General Clerk Discussions”