|
Fatigue of Welded Structures Course |
| This course uses real world case studies to understand the engineering principles governing fatigue failure of welded structures. We reduce complex mathematics to simple hand calculations using Excel workbooks so that engineers at all levels can understand the concepts covered. Engineers will leave understanding how to apply the AWS rules for fatigue design and will pick up new engineering and Excel skills along the way. |
| Date: 2011-04-19 11:29:13 - Added by: JohnDoyle |
| Views: 1464 - Votes: 0 - Rating: 0 |
| |
|
Turan Babacan's Excel Beam Analysis Worksheet |
| Static structural analysis of 3D linear elastic frames and trusses. Computes the static deflections, reactions, internal element forces using direct stiffness methods. |
| Date: 2011-01-27 19:26:22 - Added by: JohnDoyle |
| Views: 4619 - Votes: 1 - Rating: 5 |
| |
|
1) XLC Tutorial |
| Ok so you have installed XLC now let’s get up and running. This video explain what to do when you start up Excel for the first time with the XLC addin loaded. Topics covered: Name and show equations; Display above and below a division line; Greek characters. |
| Date: 2010-10-20 17:09:59 - Added by: JohnDoyle |
| Views: 21514 - Votes: 2 - Rating: 4 |
| |
|
Using Tabular Data in Excel Calculations Part 1 of 2 |
| If you want to know how to make excel work with tabular data in a user friendly way then this video tutorial is for you. The first part of the tutorial describes use of the Excel INDEX function for tabular lookups and the use of a combo box for selection. A second video covers the use of data validation boxes and the Excel MATCH function. |
| Date: 2010-10-07 09:14:48 - Added by: JohnDoyle |
| Views: 4539 - Votes: 0 - Rating: 0 |
| |
|
EXCsta.xls - 2D Frame Analysis |
| Turan Babacan's static structural analysis spreadsheet for 2D linear elastic frames and trusses. Repository Link. |
| Date: 2010-04-26 13:59:05 - Added by: JohnDoyle |
| Views: 16112 - Votes: 0 - Rating: 0 |
| |
|
Handling Units in Excel |
| How to make calculations with interchangeable units simply by the use of the XLC template. |
| Date: 2010-04-12 14:30:54 - Added by: JohnDoyle |
| Views: 4333 - Votes: 0 - Rating: 0 |
| |
|
Generalised Motion Solver Demonstration |
| This video shows how a calculation for the solution to a generalised motion problem can be solved. |
| Date: 2009-11-16 09:25:15 - Added by: JohnDoyle |
| Views: 1756 - Votes: 0 - Rating: 0 |
| |
|
Excel Rollercoaster by George Lungu |
| George Lungu's amazing rollercoaster animation generated using Excel scatter charts. |
| Date: 2009-10-07 08:58:19 - Added by: JohnDoyle |
| Views: 7005 - Votes: 1 - Rating: 5 |
| |
|
Bolt Analysis |
| Learn how to size bolts so that they never come loose or break in service. How to select the correct tightening torque. Why you might consider a more accurate tightening method. Why you might choose to lubricate your bolt. How to increase the shear capacity of your joint. Remember to double click the video player. This video needs to be viewed in full screen mode. |
| Date: 2009-10-07 08:56:26 - Added by: JohnDoyle |
| Views: 5357 - Votes: 1 - Rating: 5 |
| |
|
Introducing XLC v10_09 |
| A quick guide around the new features in XLC v10_09 including making equations from tabular data, algebra/number equation toggle and easy switch of the XLC audomatic redraw features. |
| Date: 2009-09-22 10:15:41 - Added by: JohnDoyle |
| Views: 2543 - Votes: 0 - Rating: 0 |
| |