These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Wednesday, April 15, 2015

Elder’s Quorum Contact tools / HT Reporting Tool

In my ward’s Elder’s Quorum we use a Google Form to collect home teaching reports. However, the task of organizing the results from the form to a simple percentage is a manual task. For this reason I have built a tool whose purpose is to gather the data from the Google Form and automatically compile it into a report on home teaching (a final percentage). In addition to this several other functions were built into the program. First, the spreadsheet stores the names, emails, and phone numbers of the quorum members. With the click of a button I can send a mass-text or a mass-email to all the elders. Second, once the numbers are compiled an email can be sent to the need-to-know parties.

No comments:

Post a Comment

Blog Archive