Get Help

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Autofrettagediameter

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Showing results for

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
04:46 AM

02-06-2019
04:46 AM

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

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
02:59 PM

02-06-2019
02:59 PM

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

15 REPLIES 15

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
05:11 AM

02-06-2019
05:11 AM

Re: Autofrettagediameter

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
06:43 AM

02-06-2019
06:43 AM

Re: Autofrettagediameter

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
08:37 AM

02-06-2019
08:37 AM

Re: Autofrettagediameter

I don't see Re cancel, You can divide it on P, to make life simpler. But you can do the same with 2/sqrt(3)...

Anyway, I put the equation in Mathcad 11, solved it and converted it to string:

And to save the tedious retyping here is the string:

1/(-Di^2/De^2/LambertW(-Di^2/De^2*exp(-(RE-P*3^(1/2))/RE)))^(1/2)*Di

Success!

Luc

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
08:52 AM

02-06-2019
08:52 AM

Re: Autofrettagediameter

@LucMeekes wrote:

I don't see Re cancel, You can divide it on P, to make life simpler. But you can do the same with 2/sqrt(3)...

Re is yield stress, P is pressure. The units are the same (force/area), so they can be (as you have) divided to cancel out.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
09:48 AM

02-06-2019
09:48 AM

Re: Autofrettagediameter

@LucMeekes wrote:

I don't see Re cancel,

I erroneously interpreted the first line as an abbreviation to be inserted in the second one 😉

In fact what we see seems to be the result of the infamous static symbolic solve - the second line being the first equation solved for D.p. I am still confused about the "c" we see in the picture at the end of the exponent fraction.

Better to use the dynamic symbolic solve and also let Mathcad simplify the result.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
12:35 PM

02-06-2019
12:35 PM

Re: Autofrettagediameter

Ok thank you!

Im still little bit confused

What is that LambertW ...?!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
12:59 PM

02-06-2019
12:59 PM

Re: Autofrettagediameter

LambertW is a function, like Bessel functions, or others. (Time to hit Google or the math books.)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
01:01 PM

02-06-2019
01:01 PM

Re: Autofrettagediameter

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

02-06-2019
01:57 PM

02-06-2019
01:57 PM

Re: Autofrettagediameter

@FredKohlhepp wrote:

...(Time to hit Google or the math books.)

Or to look up the appropriate Mathcad Quicksheet 😉

See attached