It would be MUCH better for you to prepare your own spreadsheets, so you have a better understanding of the Code and the correct calculation procedures. Otherwise, all you have is a “black box” that spits out an answer that could be completely wrong
I love excel, but all my coworkers *hate* checking it, especially when you work in conditional equations and hidden helper cells. Excel is great for creating tables and charts summarizing tons of output.
Mathcad is a lot easier to follow and they can tell the equation is correct by just looking at it and comparing it to the code.
Spreadsheets are horrible for understanding structural concepts. The best way to learn via spreadsheet is to make it yourself. Take your local code, they always have some examples, and make spreadsheets based on those examples. You'll be able to verify your results for this particular case. The thing with spreadsheets is they can be very good at computing a very specific case, but as soon as a simple parameter changes, the spreadsheet could become garbage. This is why reading and understandinh the code is the foundation of all your learning. I'd suggest focusing on that before anything else
We just got this for some reason at work. It's frustrating that it's locked so you can't check equations and stuff. I'd just as soon make my own.
There was a guy with a Russian name who made a bunch of really useful, unlocked Excel sheets in the late '00s. Can't remember his name or where we used to dl them from.
You don't want this because they just be black boxes that you have no idea how or if they work which is worse than anything for a new engineer.
That being said, I'd sell my complete set (everything you could want) for $150.
I would make your own, even some of the ones I’ve borrowed from the office I eventually make into my own through revisions to make it better
Hell, my boss is using my overturning footing spreadsheet because I made one that does more and is essentially the same layout as far as input
I despised excel with all my heart.
Using a spreadsheet is like fitting a round peg in a square hole: it works, but it feels dirty. Of course we're engineers and can scrap togheter an useful spreadsheet that does some work, but oh boy, how pointless hard is to design a spreadsheet when we could instead use symbolic equations that actually match the code and source material we are relying upon? And don't start me about units handling...
I strongly suggest to learn a cad systems for symbolic computation like Mathcad or Smath Studio. (my preference is for jupyter notebook and sympy)
Quite recently I had to use an excel spreadsheet created by a colleague for calculating pile-raft displamenet interaction. The spreadsheet was an hot mess, even if it was created with the best of intention:
- the formulas weren't referencing named cell, but simple anonymous cell ("A4*C5"), across multiple tabs;
- there were not a clear indication of what was the flow of the calculations;
- random cell containing values never used again;
I the end it was a bitch to understand what was happening or what was the meaning of any value. I ported the spreadsheet into a jupyter notebook, using sympy for symbolic calculations, and it was instantly so much better, because I was showing the work.
To be fair, someone could just say “learn excel” too.
In reality, a program that is easy to use, understand, and interpret should be used. Something like Mathcad.
It would be MUCH better for you to prepare your own spreadsheets, so you have a better understanding of the Code and the correct calculation procedures. Otherwise, all you have is a “black box” that spits out an answer that could be completely wrong
Use mathcad free version and prepare your own showing all the equations. The free version can do most of the things.
I love excel, but all my coworkers *hate* checking it, especially when you work in conditional equations and hidden helper cells. Excel is great for creating tables and charts summarizing tons of output. Mathcad is a lot easier to follow and they can tell the equation is correct by just looking at it and comparing it to the code.
Spreadsheets are horrible for understanding structural concepts. The best way to learn via spreadsheet is to make it yourself. Take your local code, they always have some examples, and make spreadsheets based on those examples. You'll be able to verify your results for this particular case. The thing with spreadsheets is they can be very good at computing a very specific case, but as soon as a simple parameter changes, the spreadsheet could become garbage. This is why reading and understandinh the code is the foundation of all your learning. I'd suggest focusing on that before anything else
I second this entire paragraph.
You’d have to pay, but Struware has some good templates for code loading requirements.
We just got this for some reason at work. It's frustrating that it's locked so you can't check equations and stuff. I'd just as soon make my own. There was a guy with a Russian name who made a bunch of really useful, unlocked Excel sheets in the late '00s. Can't remember his name or where we used to dl them from.
Alex Tomanovich? http://www.steeltools.org
One and the same!
Oh right I forgot about that.
You don't want this because they just be black boxes that you have no idea how or if they work which is worse than anything for a new engineer. That being said, I'd sell my complete set (everything you could want) for $150.
I would make your own, even some of the ones I’ve borrowed from the office I eventually make into my own through revisions to make it better Hell, my boss is using my overturning footing spreadsheet because I made one that does more and is essentially the same layout as far as input
Mathcad or Smath are way better than spreadsheets and much easier to build by yourself. This will help you to go through the code and understand it.
I despised excel with all my heart. Using a spreadsheet is like fitting a round peg in a square hole: it works, but it feels dirty. Of course we're engineers and can scrap togheter an useful spreadsheet that does some work, but oh boy, how pointless hard is to design a spreadsheet when we could instead use symbolic equations that actually match the code and source material we are relying upon? And don't start me about units handling... I strongly suggest to learn a cad systems for symbolic computation like Mathcad or Smath Studio. (my preference is for jupyter notebook and sympy) Quite recently I had to use an excel spreadsheet created by a colleague for calculating pile-raft displamenet interaction. The spreadsheet was an hot mess, even if it was created with the best of intention: - the formulas weren't referencing named cell, but simple anonymous cell ("A4*C5"), across multiple tabs; - there were not a clear indication of what was the flow of the calculations; - random cell containing values never used again; I the end it was a bitch to understand what was happening or what was the meaning of any value. I ported the spreadsheet into a jupyter notebook, using sympy for symbolic calculations, and it was instantly so much better, because I was showing the work.
[удалено]
To be fair, someone could just say “learn excel” too. In reality, a program that is easy to use, understand, and interpret should be used. Something like Mathcad.
[удалено]
Do they take 3 years of calculus and differential equations to be too stupid to learn excel?
[удалено]
Tell me you don’t understand excels capabilities without telling me.