Group Abstract Group Abstract

Message Boards Message Boards

0
|
3.9K Views
|
3 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Calculation using Kelvin Function?

Posted 9 years ago

Hi, it's the first time I try to use Mathematica,so I apologize if I will write inaccuracies or banality. The problem is that I need to calculate mathematical expressions you can find attached, there is kelvin functions also and is a proble using excel. I need to continue use excel because all the rest of calculation is in excel. What I would do is to is to give as input the parameters Xa, v* and Q3 and having as output Za,Zd,Zv,Zw,Fm and Ft. The first thing is if it's possible with mathematica, even creating a macro or an algorithm which returns the value in my excel sheet, without working with two programs. The second thing if you know someone who can do this and if not a software that allows me to do it. Thank you all.

Attachments:
3 Replies
Posted 9 years ago

All of your functions look similar to the example function which I showed. It should not be too difficult to use my example as a model for the rest of the functions.

Your functions look simple enough that you might be able to write all of this in Excel and avoid the usually much more difficult problem of getting two programs to cooperate with each other and pass data back and forth.

POSTED BY: Bill Simpson

thank you Bill. If someone was able to complete the algorithm would make me a great pleasure becouse I use another engineering software.

Posted 9 years ago

There is the product Excel Link which allows you to use the power of Mathematica from within Excel without having to manually operate two programs.

Just as a very small example to try to introduce you to Mathematica, this uses Mathematica by itself to calculate Za[Xa]

Clear[vstar, m]; 
ber[x_] := Sum[(-1)^n*(x/2)^(4 n)/((2 n)!)^2, {n, 0, m-1}];
bei[x_] := Sum[(-1)^(n-1)*(x/2)^(4 n-2)/((2 n-1)!)^2, {n, 1, m}];
berprime[x_] := Sum[(-1)^(n-1)*(2 n)*(x/2)^(4 n-1)/((2 n)!)^2, {n, 1, m}]; 
beiprime[x_] := Sum[(-1)^(n-1)*(2 n-1)*(x/2)^(4 n-3)/((2 n-1)!)^2, {n, 1, m}];
psi1[x_] := bei[x]+(1-vstar)/x*berprime[x]; 
psi2[x_] := ber[x]+(1-vstar)/x*beiprime[x]; 
Za[Xa_] := beiprime[Xa]*psi2[Xa]-berprime[Xa]*psi1[Xa];

Then

m = 3;
vstar = 5.5;
Xa = 7.2;
Za[Xa]

returns a value of

-368.605

There is more that Mathematica could do, but perhaps this simple example can give you an idea how to define your other functions and verify that all the results are correct. After that you might be able to look at further automation of the process.

POSTED BY: Bill Simpson
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Reply Preview
Attachments
Remove
or Discard