NorthShoreWx Posted 1 hour ago Share Posted 1 hour ago 1 hour ago, donsutherland1 said: Thank you. It seems that the formula dropped "T" rather than counting it as 0 on the spreadsheet. Mean: 3.5"; median: 2.0" I have that problem with the excel files I maintain for my climate records. For my monthly snowfall summary ( https://www.northshorewx.com/ClimateData/SmithtownDailySnowfall.pdf ) I have a 0 for months where there were traces so that the averages don't get messed up (excluding October and May where the average is 0). I keep sheets with the daily data including traces, but I can't calculate an average value for a given date (e.g., December 3) because of all the years that have a trace on that date. As a result, the difference between the actual average seasonal snowfall and the sum of the daily averages for the season in excel is significant; 36.2" vs 41.0" Link to comment Share on other sites More sharing options...
coastalplainsnowman Posted 57 minutes ago Share Posted 57 minutes ago 3 hours ago, Neblizzard said: We may have to toss December Definitely. January and the first three weeks of February as well. Best chance right now is looking like February 22nd. Not the morning, but the afternoon. After that, with the sun angle there's no chance anyway. 1 1 Link to comment Share on other sites More sharing options...
MANDA Posted 43 minutes ago Share Posted 43 minutes ago Do with it as you wish but WPC not enthused for much precip in any form over the next 7 days. I.E. cold and dry. That said any subtle change in the flow could allow for a northward drift in the precip shield to our south but seems a long shot attm. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now