Your figures are not consistent.
..002488 per degree does not give 1.0612 at 30 degrees, nor does it give
0.9123 at 110 degrees.
You need to recheck your calculations.
--
David Biddulph


"greg" wrote in message
...
I am working on a spreadsheet for calculating natural gas usage. Our meters
aren't temperature adjusted so I need to incorporate a calculation in our
spreadsheet that takes the temperature we input and adjusts our gas usage
accordingly.
The temp. factor sheet I have goes from -20 degrees to 139 degrees. I am
mainly concerned with 30 degrees (meter reading*1.0612) to 110 degrees
(meter
reading*.9123), 60 degrees being meter reading * 1. The factor increase
from
30 to 59 is .002488 per degree (60 is not corrected) and then at 61
degrees
and above the factor decreases by the same .002488.
Any help or suggestions would be greatly appreciated.
Thank You,
Greg