WXforum.net

General Weather/Earth Sciences Topics => Weather Conditions Discussion => Topic started by: chescopawxman on September 03, 2019, 09:53:26 PM

Title: Tools to general a daily almanac based off my own data set from 1983 to Present
Post by: chescopawxman on September 03, 2019, 09:53:26 PM
Hello all,
I am not sure if this is the right place for this question. But I have a daily data set for every day back to 1983. I have used excel pivot table to determine averages, highs, lows etc. but was looking for a tool/program that could take this data and allow me to run simple queries and generate canned almanac reports that will automatically highlight the current day's average high/low/precip/snow plus the record high/low/precip/snow etc. and the associated record years etc. Can anyone point me in the right direction/program or tutorial to help me access this kind of functionality with my data set?
Any help will be greatly appreciated!
Thanks so much in advance!!
Paul