WXforum.net

Weather Software => Weather Display => Topic started by: HovelintheHills on May 21, 2021, 03:52:33 AM

Title: Wunderground compatible Excel based analysis spreadsheets
Post by: HovelintheHills 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
Title: Re: Wunderground compatible Excel based analysis spreadsheets
Post by: zoomx on May 22, 2021, 07:33:08 AM
I have to to copy and paste the daily stats every day?
Title: Re: Wunderground compatible Excel based analysis spreadsheets
Post by: PaulMy 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
Title: Re: Wunderground compatible Excel based analysis spreadsheets
Post by: zoomx 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