|Pathways Member Progress|
This spreadsheet takes the raw data available from Base Camp and turns it into a more useful, readable dashboard than the ones currently available.
This is a manual process, not automatic, so the Base Camp Manager has to update this spreadsheet periodically to get an accurate picture of the club's progress.
The Summary tab will visually display each member's progress on each path and give you actionable next steps to encourage each member along their journey.
Make your own copy of this document by going to File > Make a Copy. This is just a template.
|1||Log in as Base Camp Manager.|
|2||Navigate to Member Progress and to the Individual Progress tab.|
|3||Under Options, click Refresh.|
|4||Hover over the Level 1 graph, click the arrow, and select Export to Excel.|
|5||Once the Excel opens, scroll down and copy the full table with the path details.|
|6||Paste the table into the PASTE HERE tab of this spreadsheet.|
Repeat steps 4 to 6 for every graph/level. Paste the data below previously pasted content.
|8||Review the Summary tab.|
|Developed by Dalmo Mendonca|
|Send feedback to email@example.com|