Any Excel experts out there please..?

C_Mababejive

Hello..

I am only a very basic Excel user and am looking to construct a simple Excel calculator for calculations incorporating the Mueller formula for fluid flow as shown here

http://plasticpipe.org/publications/software-ppi-calculator.html

Click accept>gas flow>low pressure flow..

Thanks for any input !

rmg1

Can you supply some test figures with the expected output and I'll see if I can construct an Excel formula based on that one?

rmg1

I'm close with this:-
=(((2971*POWER(B2,2.725))/POWER(B1,0.425))*POWER(((B3-B4)/B5),0.425))

Where:-
B1 is the Sg value
B2 is the Di value
B3 is the H1 value
B4 is the H2 value
B5 is the L value

Hopefully it should give you the right direction to head in.

robmar0se

C_Mababejive wrote: »

Hello..

I am only a very basic Excel user and am looking to construct a simple Excel calculator for calculations incorporating the Mueller formula for fluid flow as shown here

http://plasticpipe.org/publications/software-ppi-calculator.html

Click accept>gas flow>low pressure flow..

Thanks for any input !

Difficult to show you on here, I also have a coiuple of questions regarding the formula, eg Di is the number 2.725 supposed to represent to the power (eg 10 to power of 2 is 100)?

Assuming this, and taking the norm where numbers are co-joined it means multiply, I would create a sheet with the 10 variables and fixed values (eg enter 2.725 into its own cell as a fixed value, etc).

One could create one big formula, but it may be easier to build it up in stages

1. Assuming to the power, one could use the formula @power(cellnumber, to the power no), to create a new cell (a) with this number, repeat for Sg (b)

2. Next calc take power Di number multiply by the cell representing 2971, and divide by the power sg number and place in a new cell (c)

3. Do the h1 - h2 next, new cell (d)

4. Divide step 3 by L, into new cell (e)

5. convert the answer to 4 using the power formala again to cell (f)

6. Lastly multiply cell c with cell f.

If you use cell addresses in the formulas, eg use the cell address for example a9, rather than 2.725, in formulas/calculations, then hopefully (i) the answer would show automatically in the cell identified in step 6 when you entered the values, also if the fixed values change it would jsut be a case of changing one of the entries.

Hope this makes sense, maybe a better teacher is around who could explain it better than I.

robmar0se

rmg1 wrote: »

I'm close with this:-
=(((2971*POWER(B2,2.725))/POWER(B1,0.425))*POWER(((B3-B4)/B5),0.425))

Where:-
B1 is the Sg value
B2 is the Di value
B3 is the H1 value
B4 is the H2 value
B5 is the L value

Hopefully it should give you the right direction to head in.

Faster than me (a little rusty I have to say), haven't checked it but bit looks good. Very well done!

rmg1

Thanks Rob, but it's not quite there.
For values of 2,2,4,2,2 (in order of the cells) it works bang on.
It falls over for anything else, so I think I've either got some bracketing wrong or mis-typed something.

C_Mababejive

OMG didnt expect such a learned response..!

For the formula in post #3 how would i tabulate that on the excel sheet ?

Thanks again peeps..

rmg1

Put the formula into any cell you like (apart from A1-B5)
The headers (Di,Sg, etc) go into column A in the same order they are posted.
The actual values go into column B against the relevant header.

robmar0se

rmg1 wrote: »

I'm close with this:-
=(((2971*POWER(B2,2.725))/POWER(B1,0.425))*POWER(((B3-B4)/B5),0.425))

Where:-
B1 is the Sg value
B2 is the Di value
B3 is the H1 value
B4 is the H2 value
B5 is the L value

Hopefully it should give you the right direction to head in.

There is possibly a typos in the formula? Shouldn't the last number be 0.575 ?

C_Mababejive

robmar0se wrote: »

There is possibly a typos in the formula? Shouldn't the last number be 0.575 ?

Ye p..scrub my last post,,,with the typo fixed,the rsults are the same..!

job done,,thanks boys n girls...now i wonder if i can find a metric version....

I wonder if it can be adapted so that it auto transposes to calculate the unknown value when all the other values are input?

rmg1

So it should(!!)

It shouldn't be too hard to change the calculation to give you the other variables where necessary.
It won't auto-transpose, you'd have to adjust the formula for each scenario and save it in a different place.