PC Review


Reply
Thread Tools Rate Thread

How do I calculate the z factor automatically

 
 
khalid khalid
Guest
Posts: n/a
 
      20th Aug 2007
How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
if any body know .please answer me.

Thank you very much

khalid

INPUT DATA:
T 68 oF
p 1000 psia
SGFG 0.5 air=1

CALCULATE CRITICAL AND REDUCED TEMPERATURE AND PRESSURE:
Tpc=169.0+314.0*SGFG Ppc=708.75-57.5*SGFG
Tpr=(T+460.0)/Tpc t=1/Tpr
Ppr=p/Ppc


CALCULATE TEMPERATURE DEPENDENT TERMS:
A=0.06125*t*EXP(-1.2*(1.-t**2)
B=t*(14.76-9.76*t+4.58*t*t)
C=t*(90.7-242.2*t+42.4*t*t)
D=2.18+2.82*t


CALCULATE REDUCED DENSITY Y
Y = ASSUMED 0.324006985
F=-A*Ppr+(Y+Y*Y+Y**3-Y**4)/(1.-Y)**3-B*Y*Y+C*Y**D
USE goal seek MACRO SOLUTION: goal seek (F) = 0 by changing (Y)

CALCULATE Z-FACTOR:

Z=A*Ppr/Y

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      20th Aug 2007
Check your other post.

khalid, khalid wrote:
>
> How do I calculate the z factor automatically by using Hall-Yarborogh equation without changing (Y) every time to reach F=0 ?
> if any body know .please answer me.
>
> Thank you very much
>
> khalid
>
> INPUT DATA:
> T 68 oF
> p 1000 psia
> SGFG 0.5 air=1
>
> CALCULATE CRITICAL AND REDUCED TEMPERATURE AND PRESSURE:
> Tpc=169.0+314.0*SGFG Ppc=708.75-57.5*SGFG
> Tpr=(T+460.0)/Tpc t=1/Tpr
> Ppr=p/Ppc
>
> CALCULATE TEMPERATURE DEPENDENT TERMS:
> A=0.06125*t*EXP(-1.2*(1.-t**2)
> B=t*(14.76-9.76*t+4.58*t*t)
> C=t*(90.7-242.2*t+42.4*t*t)
> D=2.18+2.82*t
>
> CALCULATE REDUCED DENSITY Y
> Y = ASSUMED 0.324006985
> F=-A*Ppr+(Y+Y*Y+Y**3-Y**4)/(1.-Y)**3-B*Y*Y+C*Y**D
> USE goal seek MACRO SOLUTION: goal seek (F) = 0 by changing (Y)
>
> CALCULATE Z-FACTOR:
>
> Z=A*Ppr/Y
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate the z factor automatically khalid Microsoft Excel Worksheet Functions 7 21st Aug 2007 01:52 PM
How do I calculate the z factor automatically ? khalid Microsoft Excel Discussion 1 20th Aug 2007 07:10 PM
calculate the z factor automatically khalid khalid1111 Microsoft Excel Discussion 0 20th Aug 2007 07:06 PM
How do I calculate the z factor automatically khalid khalid Microsoft Excel Charting 0 20th Aug 2007 07:01 PM
calculate the z factor automatically khalid Microsoft Excel Charting 0 20th Aug 2007 06:29 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:15 AM.