(Msg. 1) Posted: Mon Aug 20, 2007 10:43 am
Post subject: How do I calculate the z factor automatically Archived from groups: microsoft>public>excel>datamap (more info?)
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.
(Msg. 2) Posted: Thu Sep 27, 2007 4:26 pm
Post subject: RE: How do I calculate the z factor automatically [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"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
>
>
> EggHeadCafe - .NET Developer Portal of Choice
> http://www.eggheadcafe.com >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office