2025-2026 New England Snow Recordkeeping Thread

[bristolri_wx]

Post Edited 10/15/25 5:30 PM

I believe I have a working system in place using Google Sheets, Google Maps, and Google Blogs (blogger) to take over the previous system we were using thanks to our gracious host KevinW.  The new system consists of:

• A primary Google Sheet, that collects all the information.
  • There is one "summary" sub-sheet that shows the season-to-date totals for each contributor.
  • Each contributor will have their own sheet that keeps their record for each storm/submission.
• A Google Form, that collects the data.  Data collected:
  • Date, GPS location, Snowfall Total for Date (in inches)
  • Each contributor gets their own uniques Google form/link for the 25-26 season, which submits the data to it's own page on the Google Sheet.
• A Google Map (using the "My Maps" feature) which will import data from the Google Sheet summary sub-sheet, to geographically show the current data on the map.
  • Each participant gets a snowflake on the map that you click on for info. 
• A Blogger site that provides a quick and easy way to find and view the data and links.

Links:

New England Snowfall Records Blog:
https://newenglandsnowfallrecords.blogspot.com/

Google Sheet:
https://docs.google.com/spreadsheets/d/1qyjv-cCA8hNYcbiCbT8b5qHthqm5AoAOhG9A-LJgqBo/edit?usp=sharing

Google Map:
https://www.google.com/maps/d/u/1/edit?mid=171bInqG2J1NNOqucnyZBV_2FSskeCJ8&usp=sharing

Instructions to Participate:

Send DM to bristolri_wx with following information:

• City/Town/State Info you would want displayed.
• Longitude/Latitude Info in the following format: 40.0000 (latitude) -70.0000 (longitude)
  • Longitude/Latitude information can be found by looking for your address on Google Maps. (Instructions)

I will reply back by DM with a link to your personal Google Form for submitting your snowfall reports.  I will use your AMWX username to identify you on the spreadsheet.

[Ginx snewx]

This is a great idea 

[tamarack]

Thanks - but recommend starting simple.  I enjoyed seeing the blow-by-blow records by participants, but I'm sure that added lots of formulas to make it work smoothly.

[bristolri_wx]

6 hours ago, tamarack said:

Thanks - but recommend starting simple.  I enjoyed seeing the blow-by-blow records by participants, but I'm sure that added lots of formulas to make it work smoothly.

Thanks for the feedback.  Everyone's per storm entries should also be viewable on the spreadsheet.  May not be apparent until more people are added.  You can switch at the bottom of the spreadsheet to the person you want to check out.

[bristolri_wx]

See my updated first post above for additional details.  I'm ready to start getting people on-boarded into the system.