Author Topic: Wunderground compatible Excel based analysis spreadsheets  (Read 435 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: 114
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: 5066
    • 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

Offline zoomx

  • Contributor
  • ***
  • Posts: 114
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

 

anything