What the Missy Martinez Scouts Guide Actually Is
It's a resource framework for managing scout group activities, tracking requirements, and keeping records straight across a large troop. Most people search for it thinking they need some official document, but it works best when you treat it like a living spreadsheet or database rather than a rulebook. The original material was put together by Missy Martinez and has been circulating through scout leader communities for a few years now. You can find the current version on the Sargent Fletcher website or through various scout leader forums where people share updated sheets. I got my copy from a thread on the Scouter's Call board. The file is usually in Google Sheets or Excel format, sometimes both. When it was first released it was a single workbook. Now there are separate tabs for individual tracking, merit badge logging, event planning, and rank advancement timelines. Each one is fairly straightforward if you know how to use basic spreadsheet functions. I should mention something most people don't warn you about. The guide assumes a troop size of around 40 to 60 scouts across multiple dens. If you're running a small troop with fewer than 20 kids, you'll end up with a lot of empty cells and dead weight. I found myself basically rewriting half the tab structure when I started working with it at my troop, which had about 18 scouts total. What I ended up doing was combining the rank advancement and merit badge tabs into one sheet and cutting out the event planning section entirely since we barely run events more than twice a month. Saved me about an hour of setup time per month.
How the Tracking System Actually Works
At its core the guide uses conditional formatting to flag scouts who are due for rank transitions or have missing requirements. You enter a scout's name, their current rank, their start date, and then check off requirements as they get completed. The sheet auto-calculates how many months into the rank they've been and highlights anything that's overdue. It sounds complicated but it's really just IF formulas and COUNTIF functions dressed up in color. Here's the thing nobody tells you about the requirement checking system though. The default setup counts a requirement as complete only when it's manually marked. That means if you have a scout who did something three months ago and forgot to check the box, the system will still show them behind even though they're actually fine. I ran into this with my assistant den leader last spring. She was ready for her Arrow of Light transition but the tracker showed she was four requirements behind because she'd completed them during a weekend campout and nobody ever updated the sheet. We ended up just adding a column for "completed date" and a separate column that flags whether the requirement was logged within 48 hours of completion. That way we could tell the difference between actually behind and just poorly documented.
Making It Work For Your Troop
The biggest mistake I see people make is trying to use the guide exactly as designed without adjusting it for how their unit actually operates. Some troops hold meetings every week. Others do two weeks on, one week off. Some have merit badge days. Some don't. The guide doesn't account for any of that variability out of the box. You have to build your own scheduling column if your meeting cadence isn't standard. Another practical issue is data entry consistency. If different leaders are filling in different parts of the tracker and they all use slightly different naming conventions, the formulas break. I saw one troop where the Webelos den used "Tiger den" and another leader used "Tiger" and the lookup tables treated them as two different ranks. Took me about twenty minutes to go through and standardize the terminology across every cell. Maybe set up a data validation dropdown list for each dropdown field so everyone picks from the same options instead of typing freeform. That alone prevents most of the formula errors I see.
Get the Full Details
What the Missy Martinez Scouts Guide Doesn't Cover
It won't handle bsa online registration, it doesn't sync with the official scouting database, and it has no built-in parent communication tools. If you're looking for something that automatically emails parents when their kid is due for a milestone, this isn't it. You'd need to pair it with whatever communication platform your troop already uses. Some units I've worked with connect the spreadsheet to Google Forms so leaders can submit requirement completions from their phones and the data flows into the master sheet automatically. That cuts down on the lag between when something happens and when it gets recorded. The other limitation is reporting. If your council requires specific formatted reports at the end of each quarter, the guide won't generate those for you. It stores the data but doesn't produce the kind of output your local council office expects. I've had to export filtered views and manually format them to match what the council wants. It's not a huge deal but it adds maybe fifteen minutes per quarter that you'd rather not spend. Overall it's a solid starting point and better than keeping track of everything in your head or on loose index cards. Just don't expect it to run itself. You still need to be the one making sure the data gets entered consistently and the structure gets adjusted to fit your actual troop rhythm rather than some theoretical ideal.
