Executive Summary
As the Advancement Chair for my Boy Scout Troop, I am
responsible for tracking merit badges, rank advancements, courts of honor,
leadership positions etc. I currently use three different systems to track this
information: (1) etrailtoeagle.com, (2) BSA Internet Advancement, and (3)
Excel. The website etrailtoeagle.com is a third-party subscription site that
parents, leaders and committee members can access and edit. This is a
comprehensive site that tracks almost everything that happens in the troop.
Unfortunately, it only allows the user to see one scout’s information at a time
unless you print a report that is not very easy to read or manipulate. The BSA
Internet Advancement is the Boy Scouts of America official advancement site
that only the Advancement Chair has access to. The only thing that is entered
on this site is rank advancements and merit badges and their respective dates
earned. This information is transmitted to the local Boy Scout Council.
Finally, in order to view and track all of this information in one location in
an easy to read format, I create a separate Excel file that contains a summary
of all of the advancement information. Each time I receive advancement
information from one of the scouts, I have to update the information in these
three places. In addition, because parents and leaders can access and edit
etrailtoeagle.com, sometimes merit badges and advancement has been recorded,
but I am unware of the change. This problem is faced by almost every
Advancement Chair that uses etrailtoeagle.com.
My VBA solution focuses on the scout merit badges and performs
three basic steps:
1.
Pull and format merit badge information from
Internet Advancement
a.
Login and pull Troop Information
b.
Login and pull Team Information
c.
Login and pull Crew Information
2.
Login, pull and format merit badge information
from eTrailToEagle.com
3.
Produce a comparison report
- http://files.gove.net/shares/files/15w/jomerza/Final_Project_Write-Up.pdf
- http://files.gove.net/shares/files/15w/jomerza/Final_Project.xlsm
No comments:
Post a Comment