View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Gas Temperature correction factors in an excel spreadsheet.

hi Greg

With meter reading in A1 and Temperature in B1 enter in C1
=A1+A1*ABS(A2-65)*0.002488*(SIGN(A2-65))

--
Regards
Roger Govier

"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