Whilst my preference is that my spreadsheets are downloaded via ExcelCalcs and that queries are placed in the ExcelCalcs forum, it is apparent that people request the spreadsheets without need to join ExcelCalcs. Most of my spreadsheets are dependent on links to other workbooks, some .xls and others .xla, in consequence the download limits on ExcelCalcs may prevent new users from obtaining a fully working set of my workbooks. None of my spreadsheets are dependent on XLC , whilst I believe it is good software, I have moved beyond the need to format my calculations in standard text book format. For my comparison of MathCAD/SMath type applications versus spreadsheets read:
Electronic Calculations (eCalc's) .
My primary concern is calculating results and making decisions, not documenting the journey taken, as a consequence I make extensive use of visual basic for applications (vba), with MS Excel primarily being used to provide: a file format, editor, and reporting capability.
The spreadsheets are primarily concerned with structural design of manufactured structural products (MSP). Such products mainly comprise of steel, cold-formed steel, and timber sheds and canopies. The spreadsheets are modifications of the production spreadsheets we have used for design for many years at MiScion Pty Ltd (also Trading as Roy Harrison and Associates).
The spreadsheets we use in-house are for more complete buildings, involving member and connection design (eg. schShedDesignerR01.xls is a cut down version). The idea of releasing the spreadsheets was to provide the building blocks for others to build custom workbooks for other more specific building forms. If people want custom workbooks or vb.net/vba applications for their structural product then I can be contacted at MiScion Pty Ltd.
Structural design of a product can be divided between the following three major activities:
- Brief Description: Design Brief
- Evidence-of-Suitability
- Detail Description:Specification
Structural design can also be considered divided into the following:
- Product Structure/Description
- Dimension & Geometry
- Design Actions
- Design Action-Effects
- System/Component Stability/Resistance
- Design/Assessment of Structural Form
- Design/Assessment of Members
- Design/Assessment of Connections
- Design/Assessment of Interface/Supports (Footings)
| (c)Copyright 2015 Steven Conrad Harrison | |||
| The Bundled Package Comprises of the following Files: | |||
| FILENAME | DESCRIPTION | Blog | ExcelCalcs |
| gpl.txt | |||
| readme.txt | |||
| Chart9BTC3 y04m06d14.pdf | ColdFormed Steel Sheds Australia Height Span Limits of C-Sections. | blog | ExcelCalcs |
| TECHNICAL LIBRARY | |||
| schTechLIB.xla | Libary of functions. schTechLIB contents | blog | ExcelCalcs |
| schTechLIBV2.xla | Library without DAO references | ||
| ENVIRONMENT | |||
| Beaufort.xls | Beaufort wind Scale | blog | ExcelCalcs |
| as4055.xls | AS4055 Simplified wind loading for products | blog | ExcelCalcs |
| as4055v1.xls | AS4055v2 Simplified wind loading for products | blog | ExcelCalcs |
| schWindAssessment_r02.xls | Wind Loading to AS1170.2 | blog | ExcelCalcs |
| DIMENSION & GEOMETRY | |||
| drawWorkSheet2009.xls | Experiments with Parametric Sketches using XY Charts. | blog | ExcelCalcs |
| schAcadLTCivilScriptWriter.xls | Civil engineering Long Profiles and Sections. | blog | ExcelCalcs |
| schBuildingDimensions.xls | Dimension and Geometry of Gable Frame shed Frame Member Lengths and Bracing Lengths. | blog | ExcelCalcs |
| schDrawSection.xls | Draw Sections. | blog | ExcelCalcs |
| schCADDv2.xls | CADD. | blog | ExcelCalcs |
| drawShed.zip | CAD: Automatic generation of framing plans and elevations simple gable frame. | blog | ExcelCalcs |
| sample.dwg | |||
| schDrawShed.xls | |||
| vbaDXF.zip | VBA Experiments Parsing ACAD DXF files. | blog | ExcelCalcs |
| DXFtoolsV01.xls | |||
| vbaDXF1.xls | |||
| vbaDXF2.xls | |||
| vbaDXF3.xls | |||
| drawShedDC1.zip | CAD: Experiments with DesignCAD: Draw 3D framing of American Barn type structure. | blog | ExcelCalcs |
| Column1.dcd | |||
| schDrawShedDC1.xls | |||
| ExcelShapes.zip | VBA Experiments with Excel Shapes Layer: Structural Framing Plans. | blog | ExcelCalcs |
| struMtrl.mdb | |||
| shapesTut01B.xls | |||
| drawTut.zip | VBA Experiments with ACAD Script Automation. | blog | ExcelCalcs |
| drawTut01.xls | |||
| drawTut02.xls | |||
| drawTut03.xls | |||
| drawTut04.xls | |||
| drawTut05.xls | |||
| SampleSCR1.xls | |||
| UnSymmetricalGableSCR.xls | |||
| vbaDraw01punch.xls | |||
| vbaDraw02.xls | |||
| vbaDraw03.xls | |||
| vbaDraw04.xls | |||
| schHolePunching.xls | Estimating: Hole punching requirements for roll-formed sections. | ||
| PRODUCT STRUCTURE TREE | |||
| bomStructureTreeStage3.xls | exploded BOM (Bill of Materials). | blog | ExcelCalcs |
| schBOMStructureTreeStage1.xls | Indented Bill of Material. | blog | ExcelCalcs |
| explodedBOM.zip | IE/POM/CAPM Automatic Explosion of Bill of Materials. | blog | ExcelCalcs |
| Assemblies.xls | |||
| Materials.xls | |||
| mrpBOMv2.xls | |||
| ASSEMBLY ANALYSIS/DESIGN | |||
| schGableCanopyTimber.xls | Gable Canopy to Australian Codes. | blog | ExcelCalcs |
| schKleinlogel03.xls | Kleinlogel. | blog | ExcelCalcs |
| schShedDesignerR01.xls | Wind Loads on Gable Frame to Australian Wind Code AS1170.2. | blog | ExcelCalcs |
| schDesignEngineR01.zip | Application for Generation of Height Span Charts Gable Frame Sheds. | blog | ExcelCalcs |
| AcadScript.xls | |||
| BeamCalc.xls | |||
| Building00.xls | |||
| DBGtrace.xls | |||
| DataCosmos.xlt | |||
| DesignEngine.xls | |||
| GUI_lib.xls | |||
| Geom3D.xls | |||
| HeightSpanTableForm.xlt | |||
| Klein3.xlt | |||
| Primer.xls | |||
| RigidFrame.xls | |||
| Structure.xls | |||
| XStrings.xls | |||
| Xmaths.xls | |||
| as1170.xls | |||
| as4600.xls | |||
| struMtrl.mdb | |||
| MATERIALS | |||
| schStruMtrl.xls | Structural Materials Data Steel. | blog | ExcelCalcs |
| schTimberMatrl.xls | Timber Data for AS1720. | blog | ExcelCalcs |
| struMtrl.mdb | MS Access database of properties. origin of schStruMtrl.xls. | ||
| MEMBER DESIGN | |||
| schDsgn1720.xls | Calculator assessment of timber structures to AS1720. | blog | ExcelCalcs |
| schColdformedCee.xls | Example Using Circular References to Force Iteration: Calculation Effective Section Modulus for Coldformed C-Section to AS4600. | blog | ExcelCalcs |
schDsgn4600R2013.xls | Calculator for assessment of cold-formed steel structures to AS4600.
Further information on set up can be found here. |
blog | ExcelCalcs |
| schDsgn4100.xls | Calculator for assessment of steel structures to AS4100. | blog | ExcelCalcs |
| CONNECTIONS DESIGN | |||
| schTechNote022pt2.xls | Tables for strength of bolted joints in thin cold-formed steel sheets to AS4600. | blog | ExcelCalcs |
| PRODUCTION AND OPERATION MANAGEMENT | |||
| schPlannerCalendar.xls | Planner Calendar. | blog | ExcelCalcs |
| schWorkStudy.xls | IE: Work study flow process chart. | blog | ExcelCalcs |
| GEOGRAPHICAL INFORMATION SYSTEMS | |||
| centralPlaces4.zip | Experiments with Geographical Information System (GIS) central places. | blog | ExcelCalcs |
| CentralPlaces4ShedSuppliers.xls | |||
| MISCELLANEOUS | |||
| vbaObjects.zip | VBA Experiments with Class Objects. | blog | ExcelCalcs |
| objTut01.xls | |||
| objTut02.xls | |||
| objTut03.xls | |||
| dataStruct.zip | VBA Experiments with Abstract Data Structures. | blog | ExcelCalcs |
| dataStruct00.xls | |||
| dataStruct01.xls | |||
| dataStruct02.xls | |||
| dataStruct03.xls | |||
| dataStruct04.xls | |||
| dataStruct05.xls | |||
| orgDataStru.xls | |||
| treeExperiments.xls | |||
| vbaTuts.zip | Excel/VBA Tutorials. | blog | ExcelCalcs |
| Node.dwg | |||
| NodeA.dwg | |||
| MyTest.txt | |||
| MyTest2.txt | |||
| TestNodes2.txt | |||
| vbaTut33.TXT | |||
| vbaTut00index.xls | |||
| vbaTut01.xls | |||
| vbaTut02.xls | |||
| vbaTut03.xls | |||
| vbaTut04.xls | |||
| vbaTut05.xls | |||
| vbaTut06.xls | |||
| vbaTut07.xls | |||
| vbaTut08.xls | |||
| vbaTut09.xls | |||
| vbaTut10.xls | |||
| vbaTut11.xls | |||
| vbaTut12.xls | |||
| vbaTut13.xls | |||
| vbaTut14.xls | |||
| vbaTut15.xls | |||
| vbaTut16.xls | |||
| vbaTut17.xls | |||
| vbaTut18.xls | |||
| vbaTut19.xls | |||
| vbaTut20.xls | |||
| vbaTut21.xls | |||
| vbaTut22.xls | |||
| vbaTut23.xls | |||
| vbaTut24.xls | |||
| vbaTut25.xls | |||
| vbaTut26.xls | |||
| vbaTut27.xls | |||
| vbaTut28.xls | |||
| vbaTut29.xls | |||
| vbaTut30.xls | |||
| vbaTut31.xls | |||
| vbaTut32.xls | |||
| vbaTut33.xls | |||
| vbaTut34.xls | |||
| vbaTut35.xls | |||
| vbaTut36.xls | |||
| vbaTut37.xls | |||
| vbaTut38.xls | |||
| vbaTut39.xls | |||
| vbaTut40.xls | |||
| vbaTut41.xls | |||
| vbaTut42.xls | |||
| vbaTut43.xls | |||
| vbaTut44.xls | |||
| vbaTut45.xls | |||
| vbaTut46.xls | |||
| vbaTut47.xls | |||
The zip package can be downloaded free off charge from MiScion Pty Ltd: spreadsheet Bundle . MS Excel should automatically update the workbook links to the current folder. If create a subfolder of "My Documents" called eCalcs and below this create a folder called materials. The materials data files should be placed in this folder. The materials files are:
- struMtrl.mdb
- schStruMtrl.xls
- schTimberMatrl.xls
Revisions:
- [26/5/2015] : Original Bundle Release
- [11/6/2015] : Updated the zip file to include revised versions of workbooks which had previously been uploaded to ExcelCalcs. These mainly comprise of changes to the AS4600 and AS4100 workbooks, which now have a button to open the section library, and also worksheet application parameters to enable the DAO functions to find the MS Access database of sections properties (this currently only required for AS4600.). For more information refer to : My spreadsheets DAO and 64 bit Windows 7. For those not using AS4600 there is also a alternate version of schTechLIB which does not have the references to Microsoft DAO 3.6 object library, this is named schTechLIBV2.
- [01/02/2016] : Changed source of zip file from dropbox to MiScion Pty Ltd (the family business)
