Convert from "Math Style" to "Spreadsheet Style" equation?
Convert from "Math Style" to "Spreadsheet Style" equation?
(OP)
.
Does anyone know of a software package that will convert big, long, ugly equations entered 'math style' into 'spreadsheet style'? My hp48 can do this using the equation editor and then placing the equation on the stack, but it is a cumbersome process. Does this make sense? Any help is appreciated!
Thanks!
.
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com






RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Best regards
Morten
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
h
As an added benefit, Studyworks and Mathcad come with built-in, live, unit conversions.
An alternative, which goes from Excel to symbolic, is Mathlook, from the makers ot TkSolver, but I don't think it goes the other way: http://www
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
For example, if your formula is (base * height)/2, you can enter "=(base * height)/2" into cell A1, rename cell B1 to 'base' and rename cell C1 to 'height' and the formula will work (when you enter values).
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Sorry for the poor explanation. I would like to find a software application that would allow me to enter equations 'math style' (see Format 1 on uploaded file) - as can be done with Mathcad - and have the software application convert the equation to 'inline' (see Format 2 on uploaded file).
http:
.
Thanks!
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Best regards
Morten
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Yeah, you can make artwork that looks like an equation in Excel, but you have to stand on your head and spit nickels to do it, and Excel can't make sense of it anyway.
Or you can use MathCad, which I have tried on several occasions, and gave up on, because:
- a la carte 'solution paks' were/are expensive, and I'd had to kiss some ugly anatomy just to get the vanilla Mcad.
- it crashed, hard, on some hardware, notably non-Intel math chips, which was all I could find on a weekend.
- it ran out of steam very rapidly as problems got larger.
- I could never remember how to run it if I didn't use it every day.
- Jack Crenshaw didn't like it. Then he did. Then he didn't. I lost track.
Mike Halloran
Pembroke Pines, FL, USA
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
http://hp.giesselink.com/emu48.htm
I tend to use it as a replacement for windows calculator or when I need a small calculation program for which Excel VBA would be overkill.
I don't know that it would be any less tedious than using your actual calculator, but it should run faster and it has a copy and paste functionality (of sorts) to other programs.
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
I have EMU48 and some of the ROMs may work, but there is at least one bug with parentheses in the EMU48 ROM I employed, pretty much preventing its usefulness. I was hoping someone knew of an easily available solution. I've used Mathcad since version 6 and regularly use several various other mathematics software applications. None I've found has this capability. The closest I've found (outside hp calcluators/emulators) are the 'equation writers' in various word processors, but these are less efficient than the hp calc route...
.
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
I thought it was to take an equation in "math style" (presumably from some equation editor) and convert it into a string that could be pasted directly into a spreadsheet.
But if that is the case I don't understand how the calculator emulators (or actual calculators) help.
If it is the translation of the equation that is what is wanted, I can't help, but if evaluation of the equation once entered in "spreadsheet style" is what is wanted, the link below should help:
htt
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
.
IDS - You are correct. The aim of the 'excercise' is "...to take an equation in "math style" (presumably from some equation editor) and convert it into a string that could be pasted directly into a spreadsheet."
hp48 calculators (the best calculators ever made, especially the 's' series!) allow you to do this. An equation editor is built in and is automatically translated to 'inline format' (spreadsheet style) once dumped to the stack. I can save the inline equation as a variable and transfer it from the calculator to my computer as a text file using Kermit or (I think) Xmodem protocol. That is, however, a somewhat lengthy and cumbersome process and I was hoping to find a software application that would do this easily and directly.
.
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
For example if I enter solve(a3*x^3+a2*x^2+a1*x+a4=0,x) into Maple, then it returns three solutions in pretty eye-readable math form. If I select Maple's first solution and and paste/special/UnformattedText into Word, then I get:
CODE
1 - Put the inputs in cells A1, A2, A3, A4 and paste the equation into another cell with an equals sign in front of it.
2 - In case my variable names don't correspond to cell addresses, then I can use word to replace variables with cell adddresses and then proceed as in 1.
3 - Create a vba module and feed the equation the variables with the names it wants.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
Cheers
Greg Locock
New here? Try reading these, they might help FAQ731-376: Eng-Tips.com Forum Policies http://eng-tips.com/market.cfm?
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
You still haven't said how you are creating the original equations in the first place. Is it in a program that actually does something with the equations, or are you simply looking for something that will have both Excel formulas and prettified equations?
Please clarify what you are doing with these equations.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
.
My goal is fairly straightforward, to enter a 'big, long, ugly equation' into a spreadsheet without making parentheses or typographical errors. I am really bad for making such errors and it takes me some time to track down what I've done - usually resorting to splitting the equation into simpler components, assessing the results, and then recombining the corrected components to make the whole. Below is a link to an image of a current equation (two, really) which faces me. Ideally, I'd like to type this into something like Mathcad so I can visually see the equation layout and then have the software application convert the equation into an inline format of the same equation. In spreadsheet form, for further example, the equation as presented for 0<=(t/td)<=r in inline format could be: "($B$5*($B$3-$B$4)*(($B$7*((EXP(((-$B$1*(($B$5*$B$6)-A12))/($B$5))))-(EXP(-$B$1*$B$6)))/($B$1*$B$6))+((1-$B$7)*((EXP(((-$B$2*(($B$5*$B$6)-A12))/($B$5))))-(EXP(-$B$2*$B$6)))/($B$2*$B$6))))+($B$4*(A12/$B$6))". Emu48 will allow this in some fashion, but I don't see a way to copy an equation from the stack to the clipboard in an editable format (graphical/bitmap, yes) - though numerical copy/paste is allowed. So, I was really just wondering if there was a software application available (hopefully free and open source) that provided for this process.
.
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
To find ->STR, press the PRG key then the TYPE menu button and ->STR will be on the first menu page (that's for the 48G version, the S version is probably similar).
RE: Convert from "Math Style" to "Spreadsheet Style" equation?
.
Cowski - Thanks very much, I will try out the procedure you described.
Everyone else - Thanks for input!
.
tsgrue: site engineering, stormwater
management, landscape design, ecosystem
rehabilitation, mathematical simulation
http://hhwq.blogspot.com
RE: Convert from "Math Style" to "Spreadsheet Style" equation?