Author Topic: Wunderground compatible Excel based analysis spreadsheets  (Read 808 times)

0 Members and 1 Guest are viewing this topic.

Offline HovelintheHills

  • Member
  • *
  • Posts: 1
Wunderground compatible Excel based analysis spreadsheets
« on: May 21, 2021, 03:52:33 AM »
Hi
For anyone using a weatherstation with Wunderground.
I have written a set of spreadsheets for data analysis in Excel.
Currently these allow detailed visualisation by day, month, summer, winter, year. Year on year, month on month season on season comparison etc.
I have 2+ years of data from my site ILLAND3 (using Youshiko YC9390 but this solution is generic) to illustrate capbility
You simply paste the daily stats from wunderground into the sheets (or other data sorce with a bit of manipulation) and the analysis builds itself over time
Available free currently and I will support to the best of my ability.
Email me if you're interested.
Steve

Offline zoomx

  • Contributor
  • ***
  • Posts: 139
Re: Wunderground compatible Excel based analysis spreadsheets
« Reply #1 on: May 22, 2021, 07:33:08 AM »
I have to to copy and paste the daily stats every day?

Offline PaulMy

  • Forecaster
  • *****
  • Posts: 5196
    • KomokaWeather
Re: Wunderground compatible Excel based analysis spreadsheets
« Reply #2 on: May 27, 2021, 11:35:30 AM »

Great job Steve!

The each day copy and paste is somewhat of a chore but quite easy though.  For past months and years catch up, using the WU Monthly table becomes relative easy.  Just need to remove or ignore the first column before paste in the spreadsheet. 


I've decided to download all my WU data into a spreadsheet by year with month tabs.


Enjoy,
Paul
Davis Vantage Pro 2 Plus 24-FARS Wireless - Komoka, ON Canada
Envoy/USB Logger/Cumulus v1.9.4  www.komokaweather.com  
WFL/CMX www.komokaweather.com/komokaweather-ca2/index.php
WLL/CMX www.komokaweather.com/cumulusmxwll/index.htm
WLL/CMX www.komokaweather.com/cumulusmxwll/index.html
WLL/CMX www.komokaweather.com/cumulusmxwll/index.php
Blitzortung Station #1076


Offline zoomx

  • Contributor
  • ***
  • Posts: 139
Re: Wunderground compatible Excel based analysis spreadsheets
« Reply #3 on: May 28, 2021, 02:44:42 AM »
Firefox has an extension named Table to Excel wich can be used to copy or save the Wunderground tables as CSV or XLSX