The Volunteer Analyst downloads, summarizes and publishes the hours reported by Montclair Soccer families.

Responsibilities

• Request Survey Monkey download

• Paste results into MSC reporting Excel spreadsheet, pivot to summarize, and copy/paste into Google spreadsheet.

Time Commitment

Required Experience

Schedule

Location

Minimum Term

Detailed Instructions

1. Use this link to Survey Monkey http://www.surveymonkey.com/sr.aspx?sm=yRfeN20UQFPCcqdNAgyRlxa_2bDeQ1kyEbct36_2fnRC8ig_3d to access the survey results (reported hours by parent.) Request the password from the Volunteer Coordinator.
2. Ask for a download, select All Responses Collected, Spreadsheet Format, and enter your email address.
3. When you receive the email from SurveyMonkey, click the link and save the results.
4. Open the SurveyMonkey Excel sheet  and select all the data in the spreadsheet. Copy.
5. Open the Excel sheet linked here and paste the SurveyMonkey data into the worksheet called "PasteSurveyDataHere".
6. Close SurveyMonkey's spreadsheet.
7. Click in Data tab of the remaining spreadsheet. Make sure things look OK. (This tab is just formulas pulling & tidying data from the "paste" tab.)
8. Click in the Pivot tab, click into the Pivot table somewhere, and click on the ! icon (for Excel 2003) or hit Refresh (for Excel 2007) to rerun the pivot. Copy the data - starting in row 5 so that you are selecting only the data - to be ready for pasting in the next step.
9. Open the Google spreadsheet that we use to publish the data. It's located here.  Paste the data from the Excel pivot table - minus headings - into the "Report for Coordinators" tab.
10. Please take a moment to eyeball the data. The pivot table in the last step summarizes at the lowest level of detail, so the parent name is missing from some records (because it lists parent, then kids, age groups, etc. - but puts the parent name only once.)  If there are blank cells, copy the parent names from the cells above into these blank fields. This will help the Team Volunteer Coordinators to find their parents.  (You can confirm by looking at the Excel sheet that has that pivot table in it.)
11. Sort this report. Google Spreadsheets does not (yet) allow a multi-level sort, so you must do it in 3 steps: by Team, then by Boy or Girl, then by Age Group.
12. Click in the "Publish" tab. Copy the last row down so that all the rows on the "Report for Coordinators" tab are reflected in the "Publish" sheet too.  Then update the heading "Last updated on " with yesterday's date, save and close the spreadsheet.
13. Wait 5 minutes or so, then click this link to see if the update looks right.