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

Primary Tools

Documentation     Region/Area     Council     District

Step-by-Step Instructions for Using Power Pivot Tables

Updated Documentation

3×5 Job Aid Handout (Two-sided, designed for the Avery 5388 stock)

 

Unit Contact Analysis 2018     Region/Area     Council     District

(Autoload & ability to process multiple councils.

Uses BOTH the District_Contact_Stats and the Assigned_Units reports)

Tool Download

Sample Download

 

Roundtable Analysis – Program Year     Council     District

(August – July, uses two Unit Health reports)

Tool Download

Sample Download

 

District Commissioner Visual Analysis 2018     Council     District

Tool Download

Sample Download

 

Units Needing Assistance v2     Region/Area     Council     District

(New version, uses Assigned Units, Priority Needs Units, as well as Unit Health reports.)

Tool Download

Sample Download

Blank Assigned Units report

Blank Priority Needs Units report

 

Units Needing Assistance – Advanced Analysis     Council     District

(New version, uses Assigned Units, Priority Needs Units, Unit Health, and the Trained Leaders reports.)

Tool Download

Sample Download

 

Secondary Tools

Unit Contact Analysis v2

(Autoload & ability to process multiple councils)

Tool Download

Sample Download

 

District Commissioner Visual Analysis

Tool Download

Sample Download

 

Unit Contact Analysis v1 (Looks for data file)

Tool Download

Sample Download

 

Roundtable Analysis – Calendar Year (Looks for data file)

Tool Download

Sample Download

 

Unit Health Analysis (Looks for data file)

Tool Download

Sample Download

 

Commissioner Contact Analysis

(Looks for data file)

Tool Download

Sample Download

 

Units Needing Attention v1

Tool Download

Sample Download

 

Additional Tools

Merge Tools     Region/Area

DCS Merge

UH Merge

PN Merge

AU Merge

Merge Tools Documentation