Spreadsheets versus MathCAD or SageMATH
Spreadsheets versus MathCAD or SageMATH
(OP)
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?

Source: https://www.ptc.com/~/media/Files/PDFs/Mathcad/Mat...
Thoughts?

Source: https://www.ptc.com/~/media/Files/PDFs/Mathcad/Mat...






RE: Spreadsheets versus MathCAD or SageMATH
You might look into SMathStudio... a freeware Mathcad work alike. Not the same bells and whistles, bur is pretty good.
Dik
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
The real problem is that the people who usually create spreadsheets aren't programmers and don't use good sense in programming the sheets. The next problem is that spreadsheet software, such as Excel, fails to report basic problems, like units mismatch and make it difficult to ensure that region evaluations clearly use the expected region.
For the latter there's a program called Quantix that separates the functions from the cells, so it is easy to see what the program will do. Still no units that I know of, but better.
For targeted use MathCAD, Maple, Mathematica, MatLab, R, and so forth, along with all the 'regular' programming languages are fine, but are not general purpose solutions. Joel Spolsky, a member of an early Excel development team, wrote that their interviews with spreadsheet users turned up the amazing fact that most people used Excel because it was a gridded table and they had no need or use for advanced functionality.
http://www.joelonsoftware.com/items/2012/01/06.htm...
It's an old problem, probably dredged up by PTC marketing.
http://panko.shidler.hawaii.edu/SSR/Mypapers/whatk...
RE: Spreadsheets versus MathCAD or SageMATH
1) I'm probably the world's biggest MathCAD fan, at least up to V15. It does offer some nice QC features. Namely, forced, consistent units and formula transparency.
2) I feel that the "Disaster Waiting to Happen" stuff is fear mongering and I'm a little embarrassed for PTC that they've taken that tack.
3) Most of the stats come from the accounting world. My brother started of as an accountant and I've witnessed him doing his thing. They take huge amounts of data, rotate it, flip it, sort it, and cross pollinate it in a matter of minutes with next to no checking. I'm not surprised that they have problems. Much of their data manipulation would be more appropriately handled in a database in my opinion. In summary, I suspect that there would be far fewer erros in our "template calc" applications. I've no problem with Excel being used in this way.
4) While a handful of errors have cropped up in some of our vetted Excel sheets over the years, I can't say that a single one has really led to any dire consequences. QC is always and for ever about less errors. In practical terms, it's never about no errors. I feel as though we've been batting a pretty good average with Excel so far.
5) Having managed some larger teams, my experience is that most hand calculations will be full of errors and there will be very little consistency between team members. Truly, I'd rather have everybody using the same spreadsheet, even if there is a small chance of a systematic error in that spreadsheet. You gotta pick your poison and I pick that one.
6) In my work, I use both Excel and MathCAD for template calcs. Most of my stuff is MathCAD and most of other people's stuff is Excel. I also use MathCAD for free form, project specific design notes which I love. Due to the transparent nature of MathCAD, we're also sometimes willing to use it for template calcs that haven't yet been properly vetted. If somebody needs to run a calc that already exists as somebody else's MathCAD sheet, it makes sense to give it a quick once over and then roll with it. That also serves as a check on the original which is nice.
I like to debate structural engineering theory -- a lot. If I challenge you on something, know that I'm doing so because I respect your opinion enough to either change it or adopt it.
RE: Spreadsheets versus MathCAD or SageMATH
Some kinds of errors are going to be independent of the software. If your analysis is wrong, your formula is wrong, your input number is wrong, in each case, that's an error, but it'll be an error in hand calcs, in Excel, in Mathcad.
It is time consuming to go through and check an Excel spreadsheet, but even more time consuming to go back and redo hand calcs because you changed one of your initial numbers.
RE: Spreadsheets versus MathCAD or SageMATH
I use a lot of 'that no longer makes sense' checks too.
I have often toyed with switching to MathCAD, but my deep and unabiding hatred of proprietary file formats and our loss of my father's early work to formats which are no longer supported has really precluded the adoption of a locked in format.
Of late I am toying with SageMATH and OpenModelica... One of those may win soon enough.
RE: Spreadsheets versus MathCAD or SageMATH
1) Most file types are proprietary.
2) Hard to imagine an Excel free world short of nuclear/comet issues.
3) With the transparent platforms, I take comfort in the fact that I could recreate my sheets in another platform fairly easily with a printed PDF of the Mathcad sheet in hand.
What was your dad using? Lotus123?
If I had the skills, I kinda like the web app approach with Python etc.
I like to debate structural engineering theory -- a lot. If I challenge you on something, know that I'm doing so because I respect your opinion enough to either change it or adopt it.
RE: Spreadsheets versus MathCAD or SageMATH
So the spreadsheets aren't the real loss. Some of the custom programs would be lovely to have, and while the spreadsheet would be really nice, they are models of calcs which are mostly based on codes and change with such regularity that unless you're constantly updating they are dead in the water. You're right about the Excel format being pretty solid (as well as now effectively reverse engineered so that it should be impossible for it to go away, and I do use it for most of my custom stuff...
But the biggest point is that an Engineer who worked on the PdP series would have never seen that going way. Someone who purchased an Apple II or early Macintosh could never have imagined that a competing brand would nearly wipe Apple from the market. Both happened...
I guess it just annoys me to think that work I am doing, which should be of future value, could become inaccessible based on someone else's business decision. Yes, that's less likely than ever, but still a threat.
Answer me this: MathCAD goes the way of the Dodo, no one releases/opens the file format, and a fundamental shift in computing happens. Where are you with your custom calc sheests, other than reprogramming them into something else?
RE: Spreadsheets versus MathCAD or SageMATH
I didn't notice the link was from PTC the first time I looked, although to be fair, they did but PTC down the bottom in big type.
The headlines by themselves are meaningless. It might have had some value if they compared time to complete work, and error rate between spreadsheets and Mathcad over a range of different tasks, with a range of different users. I have no doubt that there are some tasks and some users where Mathcad would perform better, and some where spreadsheets would perform better.
Whatever tool is used, any calculation where errors may have significant consequences must have an independent verification.
To blame the tool when errors pass unnoticed is just unprofessional.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Spreadsheets versus MathCAD or SageMATH
My A2000 is still in the basement, along with a hundred or more 3.5 inch floppies. My first Amiga was the original A1000 with the development team signatures engraved on the inside of the top cover. (OK engraved in the mold for the top cover.)
It is unlikely that people fail to see computers going obsolete and more likely they did not see value in re-hosting their work to a new platform. I've done small scale moves and it's a pain. If the reason for the calcs is not a continuous money maker, there's some disappointment at the loss, but it's not for the value the software delivers.
**From Wikipedia: Things changed dramatically in 1982 when the Microfloppy Industry Committee, a consortium ultimately of 23 media companies, agreed upon a 3½-inch media specification based upon but differing from the original Sony design.[60] The first single-sided drives compatible with this new media specification shipped in early 1983,[61] followed immediately in 1984 by double-sided compatible versions.[62] In 1984, Apple Computer selected the format for their new Macintosh computers.[63] Then, in 1985, Atari adopted it for their new ST line, and Commodore for their new Amiga. By 1988, the 3½-inch was outselling the 5¼-inch.[64]
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
You've likely already come across the manner in which Excel fails to correctly match seemingly identical items because of internal/hidden data types. In a recent case, it fails to MATCH a text item to a numeric item even though they appear identical on screen. And the reason this is difficult is they are numeric labels for items, some of which include a "-" character that Excel automatically classifies as text, and some don't and are classified as numbers. I don't have write access to the MATCH destination sheet where this classification has taken place and have taken to coercing the MATCH item to be both string and numeric and taking the value that does not fail the match.
Had there been an initial regularity to the typing and it was changed, the spreadsheet would fail to work correctly and been very difficult to diagnose.
Hiding data types from the user is not a good thing.
Even one of the engineers you follow fails to note this particular quirk: http://www.engineerexcel.com/excel-index-match-fun...
RE: Spreadsheets versus MathCAD or SageMATH
Apparently the added advantage of being 8 years older than me is remembering that OUR Amiga had a 3" drive because of how thoroughly annoyed our father was at having all these "perfectly good" 3inch floppies and no way to use them. So he had a guy fit our old Amstrad's 3.0 drive to an external drive bay for the Amiga. I must have one of the only collections of Amiga 3" media on the planet.
How's that for obsolescence??? *sigh*
Apologies to 3DDave... lol
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
I would be screwed. And, really, this has alread come to pass. I tend to develop programming heavy spreadsheets and all if my good stuff is V15. Problems Inhabe now.
1) 15->Prime migration is worthless for complex worksheets.
2) With Express available, few structural firms are willing to pay for a real
license for staff. And you can't use most of the programming features in Express.
I've begrudgingly come to accept that, so long as your using out of house software, nothing lasts forever. Even the software that I've developed myself has problems because of OS changes. Stability / longevity is one of the biggest benefits of Excel in my opinion.
It's a remote possibility but, if PDF reading software ever went the way of the dodo w/o a conversion utility, THEN I'd be in real trouble. I'd probably just drive truck.
I like to debate structural engineering theory -- a lot. If I challenge you on something, know that I'm doing so because I respect your opinion enough to either change it or adopt it.
RE: Spreadsheets versus MathCAD or SageMATH
We have. ADOS, SAP 5 and 7, Hilti HAP, and a printer to drive our 24 bit dot matrix printer all set up and running great. No internet = no Win 10 and no updates.
Before you ask: We print our own NCR paper site sheets with the 24bit dot matrix. Works great and cheap as chips.
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
> billions of usages, so inherent "bugs" should be few
> ubiquity; millions of computers have it, and there are a number of programs that are compatible with, or can read, it.
Nevertheless, Mathcad maintains its unique advantage, its ability to deal with units transparently, and on the fly, as well as having a WYSIWYG display. Being able to see an equation in its native form is an extremely useful capability.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Spreadsheets versus MathCAD or SageMATH
Are these engineering spreadsheets, or something else? KPMG is a accounting, management consulting firm. Are the errors due to something inherently stupid in Excel, or confusion on the part of the Excel operators, or are they bad data?
--
JHG
RE: Spreadsheets versus MathCAD or SageMATH
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Spreadsheets versus MathCAD or SageMATH
It is also clear from the footnotes that some of that data is almost thirty years old.
--
JHG
RE: Spreadsheets versus MathCAD or SageMATH
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Spreadsheets versus MathCAD or SageMATH
Check out Eng-Tips Forum's Policies here:
FAQ731-376: Eng-Tips.com Forum Policies
RE: Spreadsheets versus MathCAD or SageMATH
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Spreadsheets versus MathCAD or SageMATH
Simply entering the data is too hard for some users.
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
Dik
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
RE: Spreadsheets versus MathCAD or SageMATH
Do you want to cross a bridge designed by a person who cannot load a spreadsheet properly? Are they skilled enough to program MathCAD properly?
If someone were to approach me and ask to use one of my analysis spreadsheets for their analysis, I would reply that my spreadsheet is designed for my analysis, not yours. I would then point out that I learned a lot more creating the spreadsheet, than I did using it.
--
JHG
RE: Spreadsheets versus MathCAD or SageMATH
I tried you code.
I have "JustBasic" which does nor recognize a line. What is this line supposed to do?
380 ON T1 GOTO 390,430,520,520
How does the program flow go to 4 lines at the same time?
CEL (and others),
MathCAD is over 20 years old, too. I've been using it for 15 years, myself. Like Excel, it's gone through many transformations, but I still use it for 99% the same way I did when I started.
I think Drawoh's comments are just as valid whether written one way for spreadsheets, or the other way for MathCAD.
STF
RE: Spreadsheets versus MathCAD or SageMATH
How does the program flow go to 4 lines at the same time?"
It doesn't. T1 is assigned a value in 140, and depending on what value T1 is, 380 allows the program to branch to different functions, based on the type inputted by the user.
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers
RE: Spreadsheets versus MathCAD or SageMATH
That's what I love about Basic - you can "drive all over the country" solving things then come back to where you left with your answer.
RE: Spreadsheets versus MathCAD or SageMATH
Not supported by JustBasic, which allows you to GOTO only one line number at a time.
And the ON command is only used for handling error codes in JustBasic.
Got a link for the BASIC compiler that you use?
STF
RE: Spreadsheets versus MathCAD or SageMATH
(drawoh - my point is that a spreadsheet cannot be set to defend against typos without a lot more effort than spreadsheet wonks put into them. There is almost no way to create a sheet that prevents fat-fingering from causing tough-to-notice problems.)
RE: Spreadsheets versus MathCAD or SageMATH
EIT
www.HowToEngineer.com
RE: Spreadsheets versus MathCAD or SageMATH
I wonder how much money we would have to get together to bribe the creator into publically releasing his source code?!?
RE: Spreadsheets versus MathCAD or SageMATH
GNU Octave is Free Software.
--
JHG
RE: Spreadsheets versus MathCAD or SageMATH
I used to count sand. Now I don't count at all.
RE: Spreadsheets versus MathCAD or SageMATH
==========
"Is it the only lesson of history that mankind is unteachable?"
--Winston S. Churchill
RE: Spreadsheets versus MathCAD or SageMATH
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! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers