Equation into Excel using PEMDAS

[Spasmodic]

Hello All,

I am trying to put formula A13 into Excel but am not sure how to write it using PEMDAS. Any help would be appreciated as I can just plug in the numbers for things like Pmax and etc. Thank you in advance.

http://download.lww.com/wolterskluw.../MSS_44_2_2011_12_14_SAMOZINO_202175_SDC1.pdf

 

[Spasmodic]

A12=(-(g^2)/(3*Pmax)) - ((-(g^4*hpo^4)-12*g*hpo^3*Pmax^2)/(3*hpo^2*Pmax*Z(Pmax,hpo))) - (Z(Pmax,hpo)/(3*hpo^2*Pmax)) where I have Z(Pmax,hpo) referencing the cell with the formula you gave

Z(Pmax,hpo) is in cell B1

 

[shg]

Could you PLEASE post the actual formula you have in the cell?

 

[Spasmodic]

A12 = (-(H4^2)/(3*K8)-((-(H4^4*G4^4)-12*H4*G4^3*K8^2)/(3*G4^2*K8*N8)))-(N8)/(3*G4^2*K8)

Z (Which is in cell N8) = (-(H4^6)*G4^6-18*H4^3*K8^2-54*G4^4*K8^4+6*SQRT(3)*SQRT(2*H4^3*G4^9*K8^6+27*G4^8*K8^8))^(1/3)

 

[shg]

You're missing an hp0 term in Z:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

G​

[/td][td="bgcolor:#C0C0C0"]

H​

[/td][td="bgcolor:#C0C0C0"]

K​

[/td][td="bgcolor:#C0C0C0"]

N​

[/td][td="bgcolor:#C0C0C0"]

O​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

SFv​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

-32.0437​

[/td][td][/td][td][/td][td][/td][td]G2: = -(g^2)/(3 * Pmax) - (-(g^4 * hp0^4) - 12 * g * hp0^3 * Pmax^2) / (3 * hp0^2 * Pmax * Z) - Z/(3 * hp0^2 * Pmax)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td="bgcolor:#F3F3F3"]

hp0​

[/td][td="bgcolor:#F3F3F3"]

g​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

0.5​

[/td][td]

9.8​

[/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td][/td][td][/td][td="bgcolor:#F3F3F3"]

Pmax​

[/td][td="bgcolor:#F3F3F3"]

Z​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td][/td][td][/td][td]

1​

[/td][td]

-24.3028​

[/td][td]N8: =(-(g^6) * hp0^6 - 18 * g^3 * hp0^5 * Pmax^2 - 54 * hp0^4 * Pmax^4 + 6 * SQRT(3) * SQRT(2 * g^3 * hp0^9 * Pmax^6 + 27 * hp0^8 * Pmax^8))^(1/3)[/td][/tr]
[/table]

Everything else look correct to me.

 

[shg]

You're missing an hp0 term in Z

Probably because it's missing in my first post

 

[Spasmodic]

Ahhh, it's finally yielding a number that looks correct! Thank you very much for the help. I wouldn't have been able to figure this out without you, very much appreciated.

 

[shg]

You're welcome, glad you got it sorted.