In just a few seconds, Power Pivot tables can take your raw Commissioner Tools report data and create advanced reports. The Power Pivot table files were volunteer-developed and are NOT supported by the BSA’s Information Delivery Group.
Presently, these tools work only on a Windows-based computer with Excel 2013 and newer; they do not work with Excel 2010 and earlier.
We hope to expand the supported user base in the future. For assistance with these Power Pivot tables, please contact commissioner.support@scouting.org and a volunteer will respond to you.
Primary Tools
Documentation Region/Area Council District
Step-by-Step Instructions for Using Power Pivot Tables
3×5 Job Aid Handout (Two-sided, designed for the Avery 5388 stock)
Unit Contact Analysis Region/Area Council District
(Autoload & ability to process multiple councils.
Uses BOTH the District_Contact_Stats and the Assigned_Units reports)
Roundtable Analysis – Program Year Council District
(August – July, uses two Roundtable Attendance reports)
District Commissioner Visual Analysis Council District
A web app is available at: http://bit.ly/unit-contact-visual and there is a link in Commissioner Tools to perform this function.
Units Needing Assistance v2 Region/Area Council District
(New version, uses Assigned Units, Priority Needs Units, as well as Roundtable Attendance reports.)
Blank Priority Needs Units report
Units Needing Assistance – Advanced Analysis Council District
(New version, uses Assigned Units, Priority Needs Units, Roundtable Attendance, and the Trained Leaders reports.)
Tool Download