The first 25 not actually created at the rate of one a week, but representative of what could be done. Most however were created over a single weekend during the past 25 years or so: some started in As Easy As, and others in QPro, now all in MS Excel. After the initial creation they were then expanded, on an as needs basis.
This list is a work in progress and I will update as I release the workbooks. {NB: The links on the file names lead to posts with more detail about the workbook. See post link at bottom of page for bundled package. Those without a blog post link can be found on my ExcelCalcs profile}
| Period | Type | Category | Description | File Name | |
| 1 | Function Library | vba Functions for Structural Design | schTechLIB.xla | ||
| 2 | Loading | Simplified Wind Loading | as4055.xls | ||
| ... | Loading | Simplified Wind Loading | as4055v1.xls | ||
| 3 | Loading | Wind Loading to AS1170.2 | schWindAssessment_r02.xls | ||
| 4 | Materials Library | Steel Sections/Materials Properties | schStruMtrl.xls | ||
| 5 | Materials Library | Timber Sections/Materials Properties | schTimberMatrl.xls | ||
| 6 | Member Design | Cold-formed Steel Design | schDsgn4600.xls | ||
| 7 | Member Design | Steel Design | schDsgn4100.xls | ||
| 8 | Member Design | Timber Design | schDsgn1720.xls | ||
| 9 | Dimension & Geometry | Long Section Profile Plotter | schAcadLTCivilScriptWriter.xls | ||
| 10 | Dimension & Geometry | Draw Cold-Formed Sections | schDrawSection.xls | ||
| 11 | Structural Design | Doubly Pitched Timber Canopy | schGableCanopyTimber.xls | ||
| 12 | Structural Analysis | Kleinlogel Formula | schKleinlogel03.xls | ||
| 13 | ... | Planner Calendar. | schPlannerCalendar.xls | ||
| 14 | ... | IE: Work study flow process chart. | schWorkStudy.xls | ||
| 15 | ... | ... | bomStructureTreeStage3.xls | ||
| 16 | ... | IE/POM/CAPM Automatic Explosion of Bill of Materials. | mrpBOMv2.xls [ExplodedBOM.zip] | ||
| 17 | ... | ... | schBOMStructureTreeStage1.xls | ||
| 18 | ... | Experiments with Parametric Sketches using XY Charts. | drawWorkSheet2009.xls | ||
| 19 | ... | Dimension and Geometry of Gable Frame shed Frame Member Lengths and Bracing Lengths | schBuildingDimensions.xls | ||
| 20 | ... | CADD | schCADDv2.xls | ||
| 21 | ... | Estimating: Hole punching requirements for roll-formed sections. | schHolePunching.xls | ||
| 22 | ... | Beaufort wind Scale | Beaufort.xls | ||
| 23 | ... | Example Using Circular References to Force Iteration: Calculation Effective Section Modulus for Coldformed C-Section to AS4600. | schColdformedCee.xls | ||
| 24 | ... | Tables for strength of bolted joints in thin cold-formed steel sheets to AS4600. | schTechNote022pt2.xls | ||
| 25 | ... | Wind Loads on Gable Frame to Australian Wind Code AS1170.2 | schShedDesignerR01.xls | ||
| 26 | ... | Experiments with Geographical Information System (GIS) central places | centralPlaces4.zip | ||
| 27 | ... | VBA Experiments with Abstract Data Structures. | dataStruct.zip | ||
| 28 | ... | CAD: Automatic generation of framing plans and elevations simple gable frame. | drawShed.zip | ||
| 29 | ... | CAD: Experiments with DesignCAD: Draw 3D framing of American Barn type structure. | drawShedDC1.zip | ||
| 30 | ... | VBA Experiments with ACAD Script Automation. | drawTut.zip | ||
| 31 | ... | VBA Experiments with Excel Shapes Layer: Structural Framing Plans. | ExcelShapes.zip | ||
| 32 | ... | Application for Generation of Height Span Charts Gable Frame Sheds. | schDesignEngineR01.zip | ||
| 33 | ... | VBA Experiments Parsing ACAD DXF files | vbaDXF.zip | ||
| 34 | ... | VBA Experiments with Class Objects. | vbaObjects.zip | ||
| 35 | ... | Excel/VBA Tutorials. | vbaTuts.zip |
All the above are available as separate downloads from ExcelCalc's or from my blog's as a single bundled package {see post link at bottom of page}.
The workbooks listed below are available via this blog and and some over on MiScion Pty Ltd.
Beyond ExcelCalcs
Today 23/06/2015 is week 26 for 2015, so with the above now upto date with respect to week 26, should now be able to release one workbook per week. Changed my mind [28/6/2015], decided to list all the spreadsheets that I have released already: turns out that exceeds 52 spreadsheets, so the rest will be listed on the one workbook per day challenge.The workbooks listed below are available via this blog and and some over on MiScion Pty Ltd.
| Period | Type | Category | Description | File Name |
| 36 | ... | ... | bcaImportanceLevels.xls | |
| 37 | ... | ... | BuiltUpSection.xls | |
| 38 | ... | ... | dbExperiments.xls | |
| 39 | ... | ... | exportNamedToXML.xls | |
| 40 | ... | ... | importXML.xls | |
| 41 | ... | ... | PocketFooting.xls | |
| 42 | ... | ... | Rutledge.xls | |
| 43 | ... | ... | schGoogleToolBox.xls | |
| 44 | ... | ... | surfaceRoughnessLength.xls | |
| 45 | ... | ... | treeExperiments2014.xls | |
| 46 | ... | ... | wbk6dsgnBarrierPost.xls | |
| 47 | ... | ... | windBarrierPost.xls | |
| 48 | ... | ... | windRiskAssessment2014.xls | |
| 49 | ... | ... | xmlExperiments.xls | |
| 50 | ... | ... | backEndPFrame.xls | |
| 51 | ... | ... | frontEndPFrame01.xls | |
| 52 | ... | ... | stairCalculator.xls |
Related Posts:
Revisions:
[22/06/2015] : Original
[23/06/2015] : Split the table
[24/06/2015] : Added Type Column to Tables
[28/06/2015] : Added Spreadsheets I have previously released.
[30/06/2015] ; Added Extra Links and Descriptions
