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.