|View of my Spreadsheet|
Ok! I'll step through correcting the spelling of the folder and therefore messing up the operation of the workbook on my machine. So revising the path to:
As shown in the following screen shot, this is where the technical library goes along with other workbooks.
whilst the materials library is in a subfolder.
When open schDsgn4600.xls workbook likely to get following message. If you do, then select "Don't Update", as it typically takes longer to update the spreadsheet reading the materials file from disk than it does from memory.
Once the Add-in is selected then the calculations should complete to get the following.
The drop down list for sections, with Fielders Dimond sections shown at bottom of list. The spreadsheet cannot accurately calculate values for Dimond sections, but it can ignore most of the dimensions and treat as a c-section to get an approximate answer.
Display of Section Properties:
The member lengths required:
Design Forces: Moment and Compression (M+C) and Moment and Tension (M+T).
Sectional Moment Capacity phi.Ms:
Member Moment Capacity phi.Mb:
Axial Compression and Tension:
Simple checks for comparison:
Some extra options:
Shear and Bearing Capacity Checks. The diagrams in the code have simply been numbered in the sequence they appear, to get the load case numbers used in the workbook.