Monday, January 23, 2017

Excel Advancement Spreadsheet to track the BEAR DEN in the New Cub Scout Program in Excel - Similar to the Cub Trax Spreadsheets


This Bear Advancement Excel Spreadsheet is a workbook of FREE spreadsheets developed by Todd M. Lynch, Cubmaster for Pack 444 from Elkton, MD, and in the DelMarVa Council.  This is for use by Cub Scouters to keep track of scouts advancement using the new requirements being implemented in 2017.  Many scouters have used the Cub Trax spreadsheets for the current system, these spreadsheets operate in a similar manner.  The spreadsheets have an instructions page with details on how to use them and how to contact Steve with questions.

A special thank you to Jeff Freeman from Pack 3673 in Bozeman, MT for updating these spreadsheets and donating them to us.


  • To download the NEW FOR 2017 Bear Spreadsheet, CLICK HERE
  • To download the OLD Bear Spreadsheet, CLICK HERE
  • Having trouble downloading the document?  If you right click and "save link as" instead of download, it will be able to be opened.
  • To download the Tiger Spreadsheet, CLICK HERE 
  • To download the Wolf Spreadsheet, CLICK HERE
  • To download the Webelos Spreadsheet, CLICK HERE 
  • To download the Arrow of Light Spreadsheet, CLICK HERE

  • To see other Bear Tracking Sheets, CLICK HERE
  • To see all the Tracking Sheets, CLICK HERE

** PLEASE do not download these files and email or send them digitally to others.  These are for your personal use only.  If you would like to share these files with others, please copy the link to this post and send them to our site so they can print off their own.  We would love to have everyone that would like a copy to come here to get their own copy absolutely free.  We receive money to keep our website open where we store all of our documents and PDF files by people visiting our blog.  Please don't take money out of our pockets by bypassing our blog.




20 comments:

  1. I would love to be able to edit the files to add the boys' names rather than have Scout 1, Scout 2, etc...

    ReplyDelete
    Replies
    1. right click on tab at bottom of workbook "Scout 1" left click on RENAME
      type in scouts actual name

      Delete
  2. Thank you so much! Melissa

    ReplyDelete
  3. These are wonderful! Thank you so much for doing all of the work of this.

    ReplyDelete
  4. Great spreadsheets. Is there any way for Steve to replace the original spreadsheets with the unlocked version on this blog? Primarily all of my work is done via my Android phone since we don't have Internet at home, and the app for the Excel spreadsheet does not allow for unlocking with password or using "save as" described in the directions above. I really love the idea of having this information compiled so neatly at the touch of my fingers.

    ReplyDelete
  5. I am having problems with the Webelos Spreadsheet - When I try to print the Electives worksheet, the printout is incomplete. Any suggestions?

    ReplyDelete
  6. I found an incorrect formula on the "Core Adventures" tab. The formula for "Paws for Action" should be (for column E - copy to remaining columns):

    =IF(COUNTIF(E51:E62,"A")>0,IF(COUNTIF(E51:E54,"A")>3,IF(COUNTIF(E56:E60,"A")>1,IF(COUNTIF(E61:E62,"A")>1,"C","P"),"P"),"P")," ")

    ReplyDelete
  7. This is awesome! Thank You so much - I was just about to make up a spreadsheet for our den when I found this! Thank you for your hard work!

    ReplyDelete
  8. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. I have been using your spreadsheets as a den leader for a while now and find them very useful. I am now the training coordinator for my pack and intend to share this resource with the new den leaders. We added Lion Cubs to our pack this year. Do you have any plans to create a spreadsheet for Lion Cub dens?

      Delete
  9. Any plans to update the Bear spreadsheet with the revised requirements that happened at the end of 2016?

    ReplyDelete
    Replies
    1. We did not do these trackers, so it will be up to the individual who donated them, and we have not heard anything yet. Thank you for asking.

      Delete
  10. The revised Bear tracking sheet is wonderful -- thanks so much for putting this out! One question: Is there a way to add additional sheets for more Scouts? I need one for that 15th Cub . . . .

    ReplyDelete
  11. Thank you so much for these tracking sheets.... I used your Wolf one last year and I can't wait to use the revised Bear one this year. Your time/effort in creating these spreadsheets is so very appreciated!!!

    ReplyDelete
  12. These are so wonderful, I have been using them since my Tiger year, thank you so much! Just curious if anyone has seen updated Webelos and AOL sheets. We have Trooptrack, but I keep these sheets on my own and thank goodness I did, on more then one occasion they have been a lifesaver!
    Thanks again!

    ReplyDelete
  13. This comment has been removed by the author.

    ReplyDelete
  14. These spreadsheets are amazing!!! One little thought...can you add on the following awards: (1) Summertime Pack Award Attendance, (2) Outdoor Activity Award, (3) World Conservation Award, (4) First Aid Pin. That would GREATLY be appreciated!

    ReplyDelete