Autofrettagediameter

Forum|Forum|7 years ago
February 6, 2019
2 replies
7101 views

Hallo,

i have a Formula to calculate the elastic plastic transition diameter for autofrettage:

Dp is the elastic plastic diameter. The problem is i need to plement the calculation for DP into microsoft excel.

I need a formula to directly calculate DP. Now im using the solve function in excel but the solver is not trustable and does not give always a result where a result is calculateable.

Is there a way to transform the equation so that DP=..... for microsoft excel?

Transforming gives this block in Mathcad

where RE Yield Stress @20°C

Di inside diameter

Re Outside diameter

lg

Stefan

Best answer by Werner_E

Maybe you don't have to dig into the subject that deep.

What about this thread

http://www.office-loesung.de/ftopic524762_0_0_asc.php

and the link in the first post.

Or maybe this ready made plug-in can be useful: https://github.com/mdscheuerell/Lambert-W-in-Excel

L

LucMeekes

23-Emerald IV

The function you found using mathcad uses the LambertW() function. Please find out first if Excel knows/supports that function.

The conversion to string should not be difficult. If you save your files as Mathcad 11, I can (try to) convert it to string just like:

But... As said: Your Excel needs to support the LambertW function, and I have my doubts about that...

Success!
Luc

W

Werner_E

25-Diamond I

Excel seems not to include a ready made Lambert-W function but if you search the net you'll find a lot of links showing how to implement that function (e.g.: http://bfy.tw/MA2i)

The rest seems to be just a lot of tedious and failure prone typing work but, alas, we know that Excel sure is not the right tool for math and engineering work.

You may also want to simplify the formula first. E.g. Re cancels and does not have any influence. You also can cancel De^2, etc. This sure would make it a bit easier to convert the formula.