Pennsylvania > Ice Fishing Pennsylvania

Ice Growth Spreadsheet

(1/7) > >>

dickerson_jared:
I will be updating this on Mondays throughout the winter. I have developed a spreadsheet for rough early season ice growth that I've been using the last couple of seasons. It works on the theory that it takes 15 freezing degrees in 24 hours to make 1 inch of ice. I have found that it is pretty accurate until ice reaches 6 or so inches of thickness. The spreadsheet works on the input of WeatherUnderground, Weather.com, and Accuweather forecasts that are averaged into highs and lows for the day for the area I live. The Rightmost column represents theoretical inches of ice growth. I will note that there is no way in the spreadsheet to factor in things such as wind or snow cover and the effect it has on ice growth. This first chart is for forecasted temps on the 12th - 26th with recorded highs and lows for earlier in the month.

esoxnepa:
Nice work.  We will have to see what the storm coming on Thursday through Friday does.  It does sound like that might be rain, then followed up by a nice cold snap after it passes.

cor2016:
So if I understand your spreadsheet correct, the number bottom right is the inches of ice or ice growth?

dickerson_jared:

--- Quote from: cor2016 on Dec 12, 2022, 04:14 PM ---So if I understand your spreadsheet correct, the number bottom right is the inches of ice or ice growth?

--- End quote ---
That is correct. The right most column are predicted inches per week the rightmost column at the bottom is predicted inches for the month.

Steidyj:
Hey Jared,
I've used this method since finding it a couple years back, never inputting it into a spreadsheet, until yours gave me inspiration. Thanks for posting this, I should have ~ 3-4 inches by Christmas within an hour of driving!

Jake

Navigation

[0] Message Index

[#] Next page