New Tempest owner: on how to extract data

SOLUTION FOR EXPORTING KEY STATION METRICS:

OK, I found a workflow that works well for me. I know I IFTTT can export to google docs, but it exports WAY too much data and the sheets arbitrary cut off every couple of days. not great for organizing pertinent data. I’ve found that if you link your station to Weather Underground it summarizes daily max/min for all the data categories. That can be copy/pasted into excel…BUT…non-numerical data is also copied into each cell (92 F, for example), so excel doesn’t know what to do with it. below is a link to a macro-enabled excel sheet that I use which can remove the non-numerical data. you simply paste the weather underground data into ‘RAW’ data tab, run the macro (see ‘read me’ tab) then paste the appended data into the last tab. It is partially filled in as an example. I have it set up for MAX/MIN Temp, Wind, Rain, but you can easily adjust to your needs. I wish the Weatherflow people would have a better export system, but this works for me.

Cheers,

Scott

6 Likes