Spreadsheet: 887837d1738168096-generating-list-of-people-in-groups-sixes
Sheet: Intro

Brownie Programme Progress Tracker
This programme tracker has been built by me ([NAME]) to assist me with tracking the programme progress of my Brownie unit. It has taken many hours to get to it's current state but imperfections will likely still remain. I have hopefully caught most issues but if you have any suggestions, feedback, find any issues or need some help please contact me via the Facebook page I have uploaded this to or via email on [EMAIL]
Input
You can adjust the number of clauses required for a Skills Builder (D2) and the UMA hours (D3) required if necessary. Enter the start date of your current term into D4 to produce a printable register in the 'Register' tab.  Enter [NAME] details into the bottom table. When inserting new lines to add new Brownies please make sure you insert above the line marked "INSERT ROWS ABOVE THIS LINE" to retain formulas in other tabs.
UMAs
Enter the date the Brownie completes the UMA against the relevant cell. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down. I have tried to future proof this spreadsheet and have added in some extra columns for new UMAs - all you need to do is enter the title in row 1 and the time in row 2 and these will feed through to other parts of the spreadsheet.
Skills Builders 2-3
Enter either the date each clause completed or 'Y' against the relevant cell once completed by the Brownie. Once sufficient clauses have been achieved "DUE" will appear in the Date Awarded cells - you can overtype this with the date you award the badge. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down.
Interest Badges
Enter either the date each clause completed or 'Y' against the relevant cell once completed by the Brownie. You can then enter the date you award the badge into the relevant cell.  If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down.
Progress
Data recorded in other tabs feeds through here to highlight when Theme Awards are due to be awarded. You will need to enter the date awarded manually into the relevant cells which will then show when Bronze/Silver awards are due. Enter the dates that parts of the Gold Challenge are completed and then enter the date you award Bronze/Silver/Gold. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down.
For Gold Award
This tab is designed to be printed double sided and given out to Brownies so they can easily see their progress and explains how they can earn Theme Awards. To add new Brownies you need to copy the table of the last Brownie and then amend the formula in column I.
Register
This tab is designed to be printed. If you have entered the term start date in the 'Input' tab then this will give you a weekly register of girls and gives you space to track when Subs/Census/Joining Fee payments have come in. I use the space in row 2 (under the date) to record which Skills Builder/UMAs etc we are doing that week. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formula down in Row A.
Anniversary Badges
This tab calculates anniversary badges based on time in Guiding but also takes into account any gaps. Enter "Yes" or "No" into 'Break in Time?' - this is only applicable for that year as calculations for future years are based on the adjusted anniversary date. Enter the number of days break and then enter the date you award the badge. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down.
[NAME]
If your region does Nights Away badges this tab will track a Brownies total nights away with Guiding. You can enter any nights achieved in Rainbows in column B, then enter start and finish dates of residentials into columns D/E - this will automatically calculate how many nights away and add to any previous balance. There is space for some notes if you wish to add these. To enter an additional residential use columns J/K etc.  This tab is set up based on the badges awarded by Anglia, if your region offers badges for different numbers of nights you can amend these in row 2, column AN onwards. If you need to add extra rows for more Brownies, right click the "INSERT ROWS ABOVE THIS LINE" row and select insert, then copy formulas down.
Brownie - Example
This tab shows progress by individual and is designed to be printed double sided on A4. I replace 'Example' with the Brownies initials. When you need to add a new Brownie, create a copy of a previous tab and change the formula in C1 to pick up the new Brownie. Don't forget to add her initials on the tab name.
Changes to previous version
Updated 'For Gold Award' tab as incorrect formula on Express Myself interest badges