Where did you get this? What are the formulas behind those cells?
Having had pools forever those numbers just don't add up. I noticed you are using therms, that is a billing calculation number.
You need to use actual btu (gas) and kwh (electric) converted to btus to determine the energy need to change the temp of the water.
Home heat pumps use heating strips (resistive heat) as backup when the units cannot produce enough energy to meet the demand. If these pool units have none then the system is useless below 50F. Gas will always produce.
Thanks. I made the spreadsheet myself but the values themselves are copied out of an online calculator at noanderson.com where you enter a bunch of assumptions and it spits out the monthly costs. In my case I chose the assumptions listed at the top of the image.
Based on your experience are the monthly costs coming out too high?