Use this forum to discuss issues that are not found in any of the other clerk and stake technology specialist forums.
2 posts • Page 1 of 1
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.
- (43.89 KiB) Downloaded 1303 times