ClearBlueSky

10 Reputation

One Badge

16 years, 11 days

MaplePrimes Activity


These are questions asked by ClearBlueSky

Maple is providing answers with the gamma function and LambertW function.  I am not a math major.  Although I did take advanced engineering mathematics in grad school, I am not familiar with transcendental functions.  

I did look at some of the help.  I tried to use the convert command to convert to elementary functions, however it did not help.  I looked at the definition for the Gamma function, GAMMA(z), and the upper incomplete Gamma function, GAMMA(a,z) that uses the generalized hypergeometric function 1F1.  Looking at the generalized hypergeometric function 1F1 defintion, hypergeom(n, d, z), it references the general pochhammer function, pochhammer(z, a), and product functions, product(f,k=m..n).  This all seems way too complicated.  

 

eqn1:= R = exp(t/MTBF) * (t/MTBF) * sum(1/(i!), i=0..n);

exp(t/MTBF) * (t/MTBF) * Sum(1/(i!), i=0..n)

exp(t/MTBF) * (t/MTBF) * sum(1/(i!), i=0..n)

 

eqn2:= MTBF = solve(eqn1,MTBF);

solve(R = exp(t/MTBF) * (t/MTBF) * sum(1/(i!), i=0..n),MTBF)

 

Is there any easy way to convert to use basic functions like sum, int, etc.??

I am wanting to use the answer in Excel.  I have found some custom Excel VBA code that I could use to implement these non-standard function in Excel, but that seems like a lot of effort.

Lambert W function for Excel, work on real and complex number (VBForums)

Excel Add-Ins Incomplete Gamma Function (PC Review)

 

Update: Some more background on the problem is as follows. R is the expected reliability say 90%. MTBF is mean time between failures in hours. t is the time period of operation excluding allowable downtime. n is the allowed number of failures. I am looking to find the MTBF needed to achieve a certain required reliability, with the number of failures allowed, and the up-time operational period, being defined by the requirements as well.

To clarify the simplification does not necessarily have to be closed form, and an approximation would be acceptable. (in Excel I currently am using iteration over a number of rows, then using the Goal Seek tool to find the MTBF, however this is less than desirable to have to do everytime when looking at different trade studies) I am not that familiar with how to use assumptions in Maple, and do not know what would be the appropriate assumptions to make when simplifying. Thanks for your help.

Page 1 of 1