bristolri_wx Posted October 13 Share Posted October 13 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. 1 1 Link to comment Share on other sites More sharing options...
Ginx snewx Posted October 14 Share Posted October 14 This is a great idea 1 Link to comment Share on other sites More sharing options...
tamarack Posted October 14 Share Posted October 14 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. 1 Link to comment Share on other sites More sharing options...
bristolri_wx Posted October 14 Author Share Posted October 14 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. Link to comment Share on other sites More sharing options...
bristolri_wx Posted October 15 Author Share Posted October 15 See my updated first post above for additional details. I'm ready to start getting people on-boarded into the system. Link to comment Share on other sites More sharing options...
bristolri_wx Posted October 16 Author Share Posted October 16 @tunafish and @rimetree have been setup with their submission forms! 2 Link to comment Share on other sites More sharing options...
Ginx snewx Posted October 16 Share Posted October 16 Sent info Link to comment Share on other sites More sharing options...
Ginx snewx Posted October 17 Share Posted October 17 Cmon time to sign up Link to comment Share on other sites More sharing options...
bristolri_wx Posted October 17 Author Share Posted October 17 @Ginx snewx and @tamarack have been setup with their submission forms. 1 Link to comment Share on other sites More sharing options...
metagraphica Posted October 17 Share Posted October 17 Were we able to grab the data from here?: https://wkevin.com/new_england_snow/ Link to comment Share on other sites More sharing options...
tunafish Posted October 19 Share Posted October 19 On 10/17/2025 at 12:04 PM, metagraphica said: Were we able to grab the data from here?: https://wkevin.com/new_england_snow/ It says he did save the data, and to send him a PM. 1 Link to comment Share on other sites More sharing options...
WxWatcher007 Posted 2 hours ago Share Posted 2 hours ago On 10/13/2025 at 4:13 PM, bristolri_wx said: 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. Is it ok to track both my locations this winter? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now