More complex technic are available but if you want to keep it simple, you can try to use the following technic for the calculation of the Z factor: Journal of Petroleum Science and Engineering 73 (2010) 67-72
Hi BT i'm getting very low z outcomes for (e.g.)low S.G. (0,65) gasses at standard conditions 14,7 psia and 60F? z should be approx. 1 is it the code or am I making a mistake somewhere?
@@BoyTechful hello.. Can you send me the code for Z factor function that you made.. And if you can help me more to get Z factor by usingDran Chuk and Abu Kassem method and thank you for all
Your function will not work if you use it to calculate the compressibility factor while solving a differential equation numerically (e.g. transient leakage flowrate of a compressed non-ideal gas). The reason is that the Hall Yarborough relation is not stable numerically and the compressibility factor Z oscillates for certain ranges of Tr and Pr. You can easily notice that if you plot a graph Z=f(Tr=cste, Pr) for different values of Tr. You may sometimes need to zoom in to see the oscilations. Your function will work fine if you just need to calculate the compressibility factor for a simple calculation. I suggest to increase the precision of your calculation by decreasing the iteration step for Y. You can easily find out that the excel solver (or the excel goalseek function) will give you a much more precise estimation than your function if you do not decrease the iteration step for Y. I suggest that in future you perform a sorrow test of your function before using it.
Thanks for the feedback. I developed this function for my natural gas engineering course because it required so many iterations to find the bottom hole pressure. Goal seek required each value to be calculated individually, but with this method I could just drag the function down and be done with it. It worked fairly well for my purposes. I would certainly double check everything if I ever used it in a real life scenario.
The file does not work
More complex technic are available but if you want to keep it simple, you can try to use the following technic for the calculation of the Z factor: Journal of Petroleum Science and Engineering 73 (2010) 67-72
Thanks for the feedback
By the way, it is similar with the Dranchuk relation ..... the function is not stable for certain ranges of Tr, Pr.
I haven't looked in detail on what the this method's limitations are
Hi I'm using your sheet it's great thanks! very helpful for my study petroleum engineering.
Sebastiaan Hop glad you found it useful. if you have any other requests you'd like to see, do let me know. I'm also studying petroleum engineering
Hi BT i'm getting very low z outcomes for (e.g.)low S.G. (0,65) gasses at standard conditions 14,7 psia and 60F? z should be approx. 1 is it the code or am I making a mistake somewhere?
Sebastiaan Hop what values are you using for your Tpr and Ppr?
@@BoyTechful hello.. Can you send me the code for Z factor function that you made.. And if you can help me more to get Z factor by usingDran Chuk and Abu Kassem method and thank you for all
Your function will not work if you use it to calculate the compressibility factor while solving a differential equation numerically (e.g. transient leakage flowrate of a compressed non-ideal gas). The reason is that the Hall Yarborough relation is not stable numerically and the compressibility factor Z oscillates for certain ranges of Tr and Pr. You can easily notice that if you plot a graph Z=f(Tr=cste, Pr) for different values of Tr. You may sometimes need to zoom in to see the oscilations. Your function will work fine if you just need to calculate the compressibility factor for a simple calculation. I suggest to increase the precision of your calculation by decreasing the iteration step for Y. You can easily find out that the excel solver (or the excel goalseek function) will give you a much more precise estimation than your function if you do not decrease the iteration step for Y. I suggest that in future you perform a sorrow test of your function before using it.
Thanks for the feedback. I developed this function for my natural gas engineering course because it required so many iterations to find the bottom hole pressure. Goal seek required each value to be calculated individually, but with this method I could just drag the function down and be done with it. It worked fairly well for my purposes. I would certainly double check everything if I ever used it in a real life scenario.
Bhai ka level hai
thank you
Thank you