How do I calculate the z factor automatically

[khalid]

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

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

[ShaneDevenshire]

Hi,

I don't know the Hall-Yarborogh equation, however, if you need to check a
series of Y to determine a desired F value you could consider a VBA routine
to substitute Y values until the desired F value is reached. You might also
look at the Solver tool. This is an Excel Add-In that you attach by choosing
Tools, Add-ins, and checking Solver. Then there will be a Solver command on
the Tools menu. This tool allows you to search for a value based on many
criteria.

--
Cheers,
Shane Devenshire