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.
The User input cells are light blue background with bold dark blue text.
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
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
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.