Solve Complex Equation with Mathematica/Excel

  • Context: Mathematica 
  • Thread starter Thread starter Saladsamurai
  • Start date Start date
Click For Summary

Discussion Overview

The discussion revolves around the challenges of solving complex equations using Mathematica and transferring the results to Excel in a usable format. Participants explore various methods and tools to facilitate this process, including the potential use of MATLAB and VBA for creating calculators.

Discussion Character

  • Technical explanation
  • Debate/contested
  • Experimental/applied

Main Points Raised

  • One participant expresses difficulty in obtaining a usable format for equations solved in Mathematica, specifically needing a simpler output for Excel.
  • Another participant mentions Mathematica Link for Excel but questions the unique capabilities of Excel compared to Mathematica.
  • A participant shares their workflow of building calculators in VBA, highlighting the collaboration between engineers and computer scientists.
  • There is a suggestion that computer scientists should learn Mathematica, with a recommendation to use "InputForm" or "FullForm" to avoid formatting issues with long equations.
  • A later reply indicates satisfaction with the suggested function, implying it resolved their issue.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the best approach to solve the formatting issue, with multiple tools and methods being discussed. Some express confidence in the solutions proposed, while others remain uncertain about the best practices.

Contextual Notes

Participants mention limitations in their familiarity with Mathematica and the context of their corporate environment, which may affect their ability to implement suggested solutions.

Who May Find This Useful

This discussion may be useful for individuals working with Mathematica and Excel, particularly those in engineering or computer science fields who need to transfer complex equations between software platforms.

Saladsamurai
Messages
3,009
Reaction score
7
I have been struggling to solve the following for over a month now. If you have any ideas, feel free to advise.

I am using Mathematica (I am about to try this in MATLAB).

I have an equation that is literally a page long. I use MATHEMATICA to solve the equation for a particular variable of interest.

I now have an expression for that variable. I need to plug that expression into Excel, but as you know, if you Copy/Paste from Mathematica to a txt file, you get either MarkUp language or some other Gobblety-gok...

For example if I solve 2ZX=7Y for Y in Mathematica, it will make the answer 'pretty' like this:
Y=\frac{2}{7}ZX when i need it to come out like this: Y=(1/2)*Z*X

Similarly, exponents should be outputted like this X^7 instead of X7.

Any ideas?

I was thinking of using MATLAB instead. Won't the output come out as desired if I use it instead?
 
Physics news on Phys.org
There is a product called Mathematica Link for Excel. But what can you do in Excel that you can't in Mathematica?
 
We (my work) build all of our 'calculators' in VBA as prototypes and then send them off for JAVA development.

The JAVA guys (computer scientists) don't know Mathematica and us Engineers aren't exactly JAVA wizards.

VBA is a nice compromise.
 
The computer scientists should learn Mathematica. It should be easy for them to learn, after all it is part of their skillset to be able to learn new languages quickly.

However, in order to parse a long equation without making it pretty try "InputForm" or even "FullForm".
 
DaleSpam said:
The computer scientists should learn Mathematica. It should be easy for them to learn, after all it is part of their skillset to be able to learn new languages quickly.

However, in order to parse a long equation without making it pretty try "InputForm" or even "FullForm".

It's a coorparation, so I'll send that on up the ladder :smile:

Do you know what settings that is under by chance? I am not terribly familiar with Mathematica. I usually don't need symbolic, so I use MATLAB.

Thanks again :smile:
 
Oh..I get it. It's a Function! And it works Brilliantly!

Thank you so much DaleSpam
 
Excellent, glad it helped!

Saladsamurai said:
It's a coorparation, so I'll send that on up the ladder :smile:
Hehe, while you are at it be sure to ask for the address where I should send my invoice for consulting services :smile:
 

Similar threads

Mathematica Problems solving this differential equation for a Pendulum with Mathematica
  • · Replies 4 ·
Replies
4
Views
4K
Mathematica Mathematica - How to Graph Direction Fields of ODEs?
  • · Replies 9 ·
Replies
9
Views
3K
Mathematica Solve equation perturbatively
  • · Replies 2 ·
Replies
2
Views
2K
MATLAB Matlab's numeric solution to det of Matrix is incorrect
  • · Replies 5 ·
Replies
5
Views
4K
Mathematica Mathematica : NDSolve on 2-D steady state heat eqn
  • · Replies 1 ·
Replies
1
Views
3K
Mathematica Solve complex equation analytically
  • · Replies 19 ·
Replies
19
Views
3K
Mathematica Mathematica 3D Graphing (3D Plot) Issue
  • · Replies 4 ·
Replies
4
Views
3K
Mathematica Neural networks in Wolfram Mathematica
  • · Replies 1 ·
Replies
1
Views
4K
Mathematica How can I rederive this Mathematica result for a complex equation?
  • · Replies 2 ·
Replies
2
Views
2K
Mathematica How to neglect specific terms in an expression?
  • · Replies 1 ·
Replies
1
Views
2K