This set of Centennial Quality Unit Award worksheets by Richard Diesslin is located on the NetCommish web site at http://usscouts.org/commish/resources.asp

 

Click HERE to get a blank copy you can use for your unit. It will help you plug in your data on each of the

Begin by entering your unit's goals  on the Training, Membership, Support, and Program "detail" worksheets.  The summary pages for each year will automatically display data you enter on the "detail" worksheets.

 

Disclaimer: Use this spreadsheet at your own risk. Every attempt has been made to ensure the proper tracking using this spreadsheet, but the developer is not liable for any results in any way.

Adult Training Goals and Actuals
           
  Total # Adult Goal Actual Goal
Year Leaders* Training % # Trained % Met
2005          
2006          
2007          
2008          
2009          
2010          
 

* = this includes any adult assisting as direct contact leaders (a.k.a. working with the scouts)

The goals set should be realistic based on the number of adults that will need training for new positions, youth protection, fast start, basic, Baloo and etc.

 Note: count each person trained during the year as "1" (even if they went to more than one training event) 

 

Unit Youth Retention and Recruitment Goals and Rates
                     
  Goal

                  Actual

Goal Attainment
Year # New Scouts % Retained Jan. 1st # Dec. 1st # # New Scouts % Retained New Retained On Time Qualify
2006                    
2007                    
2008                    
2009                    
2010                    

Note: 

Actual Jan.1st # is the total number of scouts on record at the end of the year (e.g., Jan. 1, 2007 for 2007 tracking year.)
Actual Dec. 1 # is the total number of scouts on roster (e.g., Dec. 1, 2007 roster count for 2007 tracking year.)
Actual # New Scouts is the total that joined your unit in the past year (e.g., new recruits, transfers, cross-overs)
% Retained is Jan 1st # / Dec. 1st # (can be more than 100%)
Recommendation: it is okay to be mildly ambitious, but goals should be reasonably achievable.The idea is to assist with planning, not    punish a unit for failing to meet overly aggressive goals.

 

 Must Meet all goals for this requirement

To meet the retained scout goal, the actual % retained should equal or exceed the goal.

To meet the new scout goal, the actual number of new scouts should equal or exceed the goal

Also, the re-charter must be turned in on time to get credit for this requirement (hence the "On Time" check box).

 

Example:                  
  Goal Actual Goal Attainment
Year # New Scouts % Retained Jan. 1st  # Dec.1st  # # New Scouts % Retained New Retained On Time Qualify
2006     40 30 10 75.0%        
2007 5 70.0% 50 40 8 80.0% Yes Yes x Yes
2008 5 75.0% 43 40 3 93.0% No Yes x No
2009 5 80.0% 45 35 15 77.8% Yes No x No
2010 5 80.0% 55 60 8 109.1% Yes Yes x Yes
                     

 

Adult Recruitment Goals  
         
  Goal Actual Goal  
Year # New Adults # New Adults* Met  
2005        
2006        
2007        
2008        
2009        
2010        
    *=This includes transfers and multiples

 

Rank Advancement Goals and Rates