Spreadsheet: 0278a303-2308-4502-8dcb-ea50f24b2da5
Sheet: Sheet1

NOTES: | Unnamed: 1
 | This spreadsheet was designed to facilitate Pack Leader training class requirements for Cub Scout Packs within the Denver Area Council.
 | Disclaimer - This spreadsheet was designed by [NAME], Cubmaster, [NAME].  This is as-is share-ware.  Please feel free to modify this spreadsheet to meet your needs.
 | While I do not intend to maintain this spreadsheet, you can contact me at [EMAIL] if you have questions.
 | The spreadsheet is designed to automatically calculate required training for each key registered leader position within a Cub Scout Pack.  Renewable training is also calculated.
 | The spreadsheet uses several key EXCEL features to calculate and display required training that is complete and required training that is needed.
 | - EXCEL calculations to calculate the expiry date on the two classes that do expire - The only classes that expire are Youth Protection Training (YPT - 1 year online, 2 years DVD and [NAME]) and Training Development Conference (3 years).
 | - Conditional formatting on specific cells to change their background color to GREEN or RED as needed based on the POSITION held by that person.  Go to FORMAT - CONDITIONAL FORMATTING if you need to change these calculations based on local training rules.
 | - There is a pull-down list of available Positions.  That list is based on the list above in column A.  If you change the Positions List in Column A, it will change the pull-downs at the top.  The CONDITIONAL FORMATTING will also have to be adjusted since it keys of the Position title.
 | - The class titles in column A have comments associated with them that appear when you 'hover' the cursor over the class names.
 | The spreadsheet is Protected so only the correct fields can be modified.  The fields in white are editable.  There is no password on the protection so changes can be made.
 | Positions - If you change the list at the bottom of the LEADER TRAINING TRACKER sheet, it affects the colors in the CONDITIONAL FORMATTING of the cells above.  It also changes the drop down lists.
 | NOTES ON MY INTERPRETATION OF DENVER AREA COUNCIL CUB SCOUT LEADER TRAINING REQUIREMENTS:
 | All leaders must take the online fast start training for their position before beginning the training cycle. This is required to be consider 'trained'.
 | All registered leaders, with the exception of the Chartered Organization Rep, need New Leader Essentials training.
 | All registered leaders need to maintain a current Youth Protection Training certification.  These classes expire in 1-2 years depending on whether the class is taken online or classroom.
 | Charter Organization Representatives also need Chartered Organizations Representative training (taught at Pow Wow and [NAME]).  Not required to have New Leader Essentials.
 | Cubmasters also need  Cubmaster Specific training.
 | Committee Chair also needs Committee Leader Specific training.
 | [NAME] also needs to attend Trainer Development Conference.
 | Tiger Leaders also need Tiger Leader Specific training.
 | Den Leaders ([NAME] and [NAME]) also need Den Leader Specific training.
 | [NAME] also need [NAME] Leader Specific training and Outdoor Leader Skills for Webelos Leader (this is sometimes call Webelos Leader [NAME]).
 | The only courses that have a time limits are:
 | 1. Youth Protection Training - Valid for one year if taken online.  Valid for 2 years if taken in classroom or DVD administered by the Training Chair.
 | 2. Trainer Development Conference - This course, only required by [NAME], is valid for 3 years.
 | BALOO - Basic Adult Leader Outdoor Orientation - One leader must be [NAME] trained for all overnight camp outs.
 | Health and Safety Training - Highly recommended and included in many DAC training events.
 | All training requirements apply to Assistant positions equally.
 | A variety of other online and classroom-oriented classes are available and can also be tracked using this spreadsheet.  This includes Wood Badge for the 21st Century, Pow Wow, [NAME], and advanced trained at the Philmont Training Center.
 | The online courses can be taken by creating a userid within WWW.SCOUTING.ORG.  Click on the MYSCOUTING link at the top.