ExcelCalcs Welcomes Aeronautical Engineer Richard Abbott - Richard Abbott boldly goes where no other ExcelCalcs User has gone before by uploading some Aerospace calculations. It's a small world because as it turns out I used to work with Richard's eminent engineering father, Barrie Abbott. Richard used to own and run his own commercial recording studio but his engineering genes got the better of him and he now runs Abbott Aerospace an independent
consultancy company offering structural engineering services the
aerospace industry. He is based in London, Ontario, Canada.
I was delighted to receive his lug analysis spreadsheet because I'll use it frequently to analyse pinned joints. Thanks to Richard's spreadsheet the whole process is automated and made easy for me.
How to Go XLC Pro? - All the following calculations featured below earned a free XLC Pro subscription for their authors. Why not earn one for yourself or if you have not got time you can support the site by paying $90USD for an XLC Pro subscription.
 Aerospace_lug_analysis.xls New!
This method of assessment involves reading coefficients from graphical
data for use in subsequent equations. The spreadsheet automates all the
curve reading to determine the proof and ultimate strength of lugs in
an expedient manner.
The spreadsheet has been produced by Abbott Aerospace an independent
consultancy company offering structural engineering services the
aerospace industry. You can contact them by email
|
|
The spreadsheet has been produced by Abbott Aerospace an independent
consultancy company offering structural engineering services the
aerospace industry. You can contact them by email
|
|
In the "JOIST.xls" workbook in the "K-Joist Analysis" worksheet it was
discovered that in a few cells I had an inadvertent and undesirable
extra space at the end of the 2 numbers in the table representing the
allowable total and live loads for the joist sizes and spans. What the
extra space did was prevent the program from correctly extracting the
second number (live load) from the table. These few occurrences were
very obvious to the user due to the erroneous single digit value which
was displayed for the distributed live load (WLL) in the calculation
page. By the way, the load table in the "LH-Joist Analysis" worksheet
was also checked for the presence of any of the extra spaces and none
were found. |
|
Purpose of calculation: To determine the Velocity & Flow of water through pipes of varying diameter, slope & material. |
|
Excel spreadsheet to determine the temperature affect on DC & Brushless DC motors. Based on whitepaper by Edward Hage. http://www.specamotor.com/pdf/overheating_white_paper.pdf
Clyde ()
|
Laminate_Stress_Strain_Analysis.xls
JOIST.xls
Download double counting with Internet Explorer - Some research has also shown that users navigating with IE (Microsoft's Internet Explorer) may double count the download a file from if the site not in the users's trusted zone. Here is some further information on this here. Unfortunately it does not offer a solution. My only suggestion is for IE users to place www.ExcelCalcs.com in their trusted zone to avoid the problem altogether.
