Author Topic: Wunderground compatible Excel based analysis spreadsheets  (Read 3463 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

  • Senior Contributor
  • ****
  • Posts: 188
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: 5509
    • 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

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

Offline Timster

  • Member
  • *
  • Posts: 6
Re: Wunderground compatible Excel based analysis spreadsheets
« Reply #4 on: September 28, 2022, 06:40:40 PM »
Late to the party on this topic, but never hurts to say thanks.
Steve has sent me his spreadsheets, and they look great.  Thanks for the effort and for sharing!

Cheers
Tim