Convert from "Math Style" to "Spreadsheet Style" equation? 1

[tsgrue]

.

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

 

[SteveGregory]

You might want to try excelcalcs. You enter the spreadsheet equation in the normal fashion and excelcalcs will give you a graphical representation for your documentation purposes. It is an Excel plug-in.

 

[tsgrue]

.

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

 

[IRstuff]

There may be something you could modify in Sourceforge:

http://sourceforge.net/search/?word..._search=soft&pmode=0&words=symbolic+equation+

TTFN

FAQ731-376

 

[cowski]

I don't see a way to copy an equation from the stack to the clipboard in an editable format

Once you get it on the stack, convert it to a string with the ->STR function then from the edit menu choose 'copy string' and paste into Excel.

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).

 

[tsgrue]

.

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

 

[dgallup]

As mentioned above,

http://www.ExcelCalcs.com

has a plug-in that lets you write and evaluate equations in a nice clear algebraic manor. The downside is it makes Excel run very slowly.