Converting from mathcad to excel
Converting from mathcad to excel
(OP)
Hi
I have a few very large definate integrals I am trying to solve symbolically in mathcad and then enter them into excel. I'm having difficulty because mathcad won't solve some of them saying they are too large and some of them use imaginary numbers.
My question is this, is there a way I can convert the mathcad solution into excel and still be able to change values in excel and have them calculated by mathcad?
Thanks,
Mike
I have a few very large definate integrals I am trying to solve symbolically in mathcad and then enter them into excel. I'm having difficulty because mathcad won't solve some of them saying they are too large and some of them use imaginary numbers.
My question is this, is there a way I can convert the mathcad solution into excel and still be able to change values in excel and have them calculated by mathcad?
Thanks,
Mike





RE: Converting from mathcad to excel
I questioning the intent, here. If you're going to put stuff into Excel, why do you need symbolic solutions? As far as I know, Mathcad can usually crank numerical integrals pretty easily.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Converting from mathcad to excel
RE: Converting from mathcad to excel
Not very nicely, admittedly.
Cheers
Greg Locock
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Converting from mathcad to excel
Greg,
When you say excel can handle imaginary problems are you referring to the imaginary(), real(), ect. commands?
Mike
RE: Converting from mathcad to excel
Cheers
Greg Locock
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Converting from mathcad to excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Converting from mathcad to excel
I need to be able to change the values of variables within the integral for different bearing applications. That is why I need to solve the integral symbolically so I can then change values in my program.
This add in for excel, where do I get it from?
Thanks,
Mike
RE: Converting from mathcad to excel
The add-in is downloadable from the Mathsoft website
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Converting from mathcad to excel
On smaller integrals I was able to solve the integral using the symboic evaluation command and then type the solution into excel. I could then change the variables and find a solution for the integral using different variables if I wanted to.
I think we are saying the same thing.
RE: Converting from mathcad to excel
You've still said nothing that demonstrates a need for a symbolic solution.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Converting from mathcad to excel
If I have the integral solution solved symbolically and entered into excel all I need to do is change that value and I have a new solution for the new value.
I need it solved symbolically so I can then enter the solved equation into excel. I know I can solve it numericaly in mathcad, but that isn't my objective here. In my first post I should have said I want to enter the symbolically solved equation into excel, not just the numeric results.
I apologize if that is where the confusion is.
Mike
RE: Converting from mathcad to excel
RE: Converting from mathcad to excel
RE: Converting from mathcad to excel
If you have Mathcad 7 Professional, you can use an Excel component within Mathcad. Get the input for numeric calculation of the integrals from input variables in the Excel component. Put the results in output variables in the Excel component, which will be put into cells of the Excel workbook.
If you have Mathcad 7 Standard, seriously think about upgrading.
In your OP, you said Mathcad couldn't solve some of the integrals symbolically. I don't understand what you mean by converting the Mathcad solution into Excel if there is no Mathcad solution.
RE: Converting from mathcad to excel
This raises another question I think I know the answer to. In order to run the excel component the person using the excel program will have to also have mathcad loaded on their computer, correct?
Mike
RE: Converting from mathcad to excel
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Converting from mathcad to excel