I understand that I can remove the rounding off, but some users in the past (and future) may not have realised that, so any small values they calculated were off by quite a bit. Would be best if you would update the Sweet Gas spreadsheet yourself in your other topic.
I did not look at the Sour Gas spreadsheet this morning, because of its name, that I interpreted to be for sour gas only.
For HOUTAN's natural gas with dew point of -80.8 F (-63 oC) at 825 psig (5790 kPaa) the Sweet NG spreadsheet would predict a water content of 0.01 lb/MMscf, and the Sour NG spreadsheet 0.04 lb/MMscf.
I earlier guestimated 0.03 lb/MMscf (based on extrapolation of the McKetta-Wehe chart), so I agree with you that the Sour Gas spreadsheet is more accurate in this case.
However if the dewpoint of -80.8 F is actually at atmospheric pressure (see Art's remarks), then the Sweet NG spreadsheet predicts 0.6 lb/MMscf, while the Sour NG spreadsheet predicts 3.1 lb/MMscf.
I earlier guestimated 0.7 lb/MMscf (based on extrapolation of the McKetta-Wehe chart), so in that case it seems the Sweet NG spreadsheet is more accurate.
Edited by PingPong, 08 August 2014 - 07:22 AM.