1. ## Finding equation constants

Hey Guys, this is kind of an engineering type problem but it's only the math portion. I have a column of concentration in gal/MMSCF (C). This is the concentration of hydrocarbons in the natural gas stream. MMSCF = Million standard cubic feet. I also have a column of flow rates, MMSCF/day (F). This is the flow rate of natural gas.

When I multiply the two, I get how much hydrocarbons are removed from the gas, theoretically. We also record the amount of hydrocarbons we collect. This amount compared to the theoretical amount are very much off, like 50%-60%.

So my equation is L (theoretical) = C * F

How would I created another equation, ex L = k*C*F, where k is some constant that compensates for the difference between the theoretical liquid value and the actual liquid value? My question is, how would I find that constant?

Any help is appreciated, thanks.

2. Can't say from the information that you provide.
Do you have a table of values that we can work with ?

3. Here you go.

4. If the model is to be $\displaystyle L=kCF,$ you can get a feel for the value (?) of $\displaystyle k$ by creating another column on your spreadsheet.
Produce a column of $\displaystyle k$ values and sort the table so that the 'actual liqiud values' are in ascending order. You should find that the values of $\displaystyle k$ range between about 0.12 and 0.42 generally increasing as as the 'actual' values increase, (though with a few anomalous values thrown in).
The best (?) value for $\displaystyle k$ seems to be about 0.24, though that still leads to some fairly significant errors.