I speak from a place of ignorance of AGA-8 not being accepted anymore - perhaps that is just my company. I do know that we would prefer to use the Gross Characterization Method II if possible. However, as it stands right now, it looks like I will need to use the VBA in order to incorporate CO2...
Sorry, yes it is natural gas. And I thought the AGA-8 was no longer recgnized? We are using the NX-19 for whatever reason... I just need to be able to calculate inventory and include N2 and CO2...
You're welcome. I will submit this to my colleague as I know he is interested in this. But I missed where in your results you addressed N2 and CO2 - ? Am I just not seeing/getting it?
Thanks again for your help - now if I might trouble you a little further!
I have an engineer here that was looking at the results as well, and he asked which compressibility selection you are using in Stoner. Also, we were wondering how this model handles changes in N2 and CO2 - I didn't see...
Hi BigInch - sorry for the delay; I struggled to get back to this.
You are right, I was using the wrong factor - .90 was what I needed for compressibility.
I did find a VBA code for the NX-19 method and it was pretty easy to implement and seems to work. However, I like what you have posted...
Okay. First, SCADA is using the same endpoints and variables as I am. I will list them. Also, my VBA user form thingy is pretty much dead on with SCADA. Also, I know the formula that SCADA is using and I will show you that as well. Here are my variables:
P1 = 1085
P2 = 1010
T1 = 104
T2 = 87
Dia...
Hi - thanks for the reply.
I have a table for Z factor in Excel - no problem. I use the 2/3 method for averages of P, T, and Z. That's easy. What I cannot make work is a calculation for the linepack (mcf or mmcf) in a single cell that computes correctly. It SEEMS I have all the components for...
Yes I know! Actually Googling the linepack equation yields many results, so I guess I am looking more for an Excel form if you will, for lack of better description. I have tried to build the equations in Excel but come up short. I found a VBA equation that works well in Excel, but I cannot...
Hello -
I certainly hope I am in the right place for what I would hope is a simple request...
I have to keep hundreds of records in Excel each day for various linepack segments. I have, in separate cells, the necessary pressures, temperatures, gravities, and pipe diameters and lengths. What I...
