Boy Scouts of America

Instructions for Creating Advanced Power Pivot Table Reports from Commissioner Tools Reports

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)

New Tool Download December 2021

Sample Download

 

Roundtable Analysis – Program Year     Council     District

(August – July, uses two Roundtable Attendance reports)

Tool Download

Sample Download

 

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     Region/Area     Council     District

(New version, uses Assigned Units, Priority Needs Units, as well as Roundtable Attendance reports.)

New Tool Download June 2021

New Tool Download January 2021

Sample Download

Blank Assigned Units report

Blank Priority Needs Units report

 

Trained Commissioners Analysis     Council     District

(uses Trained Leaders Report)

Instructions for Using the Tool

Tool Download

Bray Barnes

Director, Global Security Innovative
Strategies

Bray Barnes is a recipient of the Distinguished Eagle Scout Award, Silver
Beaver, Silver Antelope, Silver Buffalo, and Learning for Life Distinguished
Service Award. He received the Messengers of Peace Hero award from
the royal family of the Kingdom of Saudi Arabia, and he’s a life member of
the 101st Airborne Association and Vietnam Veterans Association. Barnes
serves as a senior fellow for the Global Federation of Competitiveness
Councils, a nonpartisan network of corporate CEOs, university presidents, and
national laboratory directors. He has also served as a senior executive for the
U.S. Department of Homeland Security, leading the first-responder program
and has two U.S. presidential appointments

David Alexander

Managing Member Calje

David Alexander is a Baden-Powell Fellow, Summit Bechtel Reserve philanthropist, and recipient of the Silver Buffalo and Distinguished Eagle Scout Award. He is the founder of Caljet, one of the largest independent motor fuels terminals in the U.S. He has served the Arizona Petroleum Marketers Association, Teen Lifeline, and American Heart Association. A triathlete who has completed hundreds of races, Alexander has also mentored the women’s triathlon team at Arizona State University.

Glenn Adams

President, CEO & Managing Director
Stonetex Oil Corp.

Glenn Adams is a recipient of the Silver Beaver, Silver Antelope, Silver Buffalo, and Distinguished Eagle Scout Award. He is the former president of the National Eagle Scout Association and established the Glenn A. and Melinda W. Adams National Eagle Scout Service Project of the Year Award. He has more than 40 years of experience in the oil, gas, and energy fields, including serving as a president, owner, and CEO. Adams has also received multiple service awards from the Texas Alliance of Energy Producers.