Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations GregLocock on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Spreadsheets versus MathCAD or SageMATH 5

Status
Not open for further replies.

CELinOttawa

Structural
Jan 8, 2014
1,456
This says it all in terms of what I want to discuss; do you believe it? How do you approach your own work? I have always been an avowed spreadsheet guy, but this had the exact intended effect and has made me *pause* to think.

Thoughts?

Spreadsheet_Error_Rate_hcbwrq.png


Source:
 
Replies continue below

Recommended for you

My preference, when I have time, is to work the problem in Mathcad Express and then put it into a spreadsheet, try a few values to prove it, and then use the spreadsheet for crunching multiple scenarios. When I share results, I run one scenario in Mathcad as a "proof" and then all of them in Excel to form tables, plots, and graphs. Excel has many more plotting options which look great next to the Mathcad sheets in a report.

I used to count sand. Now I don't count at all.
 
Besides units, another advantage to Mathcad is that you can completely rebuild a worksheet from scratch if the only thing you have of it is a printed copy (assuming no hidden regions). With a spreadsheet, you need a printout of the formula view and few people I know go to the trouble to do that (I've only done a handful of times myself).



==========
"Is it the only lesson of history that mankind is unteachable?"
--Winston S. Churchill
 
" you can completely rebuild a worksheet from scratch"

IFF they didn't try to hide anything from you. You can reference other sheets for functionality, and unless you have those sheets as well, it can be problematic. Additionally, you can embed stuff on the sheet in math regions that can be collapsed and locked.

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor