Bundle of my ExcelCalcs UpLoads

{The link to download the bundle is at the bottom of the post.}

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:

1. Brief Description: Design Brief
2. Evidence-of-Suitability
3. Detail Description:Specification

Provision of Structural Calculations primarily falls into the evidence-of-suitability activity. Whilst drawing falls into both the design brief and specification activities.

Structural design can also be considered divided into the following:

1. Product Structure/Description
2. Dimension & Geometry
3. Design Actions
4. Design Action-Effects
5. System/Component Stability/Resistance
• Design/Assessment of Structural Form
• Design/Assessment of Members
• Design/Assessment of Connections
• Design/Assessment of Interface/Supports (Footings)

The spreadsheets are listed below roughly divide into the above categories. For further information links to ExcelCalcs and Blog posts are provided. At present most of the blog posts simple display the ExcelCalcs page, but in the future I will add more detail about the workbooks. Also note that the graphics on the ExcelCalcs page were put there by the site administrator not myself, and don't always reflect the nature of the spreadsheet: and editing the page is limited, therefore the blog posts here will be up dated and modified first.

(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
schDsgn4600.xls 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:

1. [26/5/2015] : Original Bundle Release
2. [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.
3. [01/02/2016] : Changed source of zip file from dropbox to MiScion Pty Ltd (the family business)

Plane Frame Analysis with Graphics

I've now got the screen graphics back into plane frame application, which had been taken out to provide a command line application (cpframe) which can be run from with in other applications. This version I have named gpframe, for graphics plane frame its is still a DOS based application. When converted to run in Windows I will name it wpframe.

It can be called by typing the following in a command prompt:

gpframe

It will then bring up a menu system which will allow selecting a file. (The file name needs to conform with 8.3 conventions, as does the folder structure where the file is located. Which messes up using it under "Documents and Settings\user name\My Documents". The files also need to be in the same folder as the application as it doesn't support moving around folders: the current working directory. The things we now take for granted, though never really a problem in DOS as always worked in the folder where the files were, and called the applications via batch files.)

Opening Screen

Main Menu

Plot Menu

Geometry

Loads

Moment Diagram

Shear Force

Axial Force

Deflection

On first look I did think the deflections were incorrect, with an expectation that the whole frame would sway to the right, but a check with Multiframe indicates similar deflection at the nodes, with an inward pull towards the centre of the frame from both sides. Which is where the Kleinlogel formula and associated diagrams are a useful reference for checking influence of individual loads. The formula typically give a single direction of loading (vertical, horizontal or normal) on a single element of a frame. Unfortunately I don't have the book with me. So I'm guessing (well slightly better than a guess) the vertical component of the wind load on the central gable frame has the net effect of pulling the frame inwards and exceeds the sway that would be produced by the horizontal components of load on the whole frame. If the central span was smaller then the behaviour would be different. It is something which can be assessed by creating additional models of the structure and looking at the influence of individual loads.

It can be downloaded here.

DISCLAIMER :
Users of the software must accept this disclaimer of warranty :
The software is supplied as is. The author disclaims all warranties, expressed or implied, including without limitation, the warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from the use of the software.

---

Related Posts:

---

Revisions:
[27/01/2014] Original

[23/04/2016] Changed download links to MiScion Pty Ltd Web Store

Plane Frame Analysis

Sample03

I have taken the plane plane frame analysis application I previously blogged about here, and ripped out all the DOS based full screen graphics and reduced it to a command line application, and made available for download. To me this is not diminished capability but an enhancement. I never used the user interface as I auto-generated the data files using Borland Quattro Pro (QPro) spreadsheet. However whilst I could launch pframe from within QPro I had to open the data file, run the analysis and then save the results: three steps where one would have done. Now with a command line parameter, the data file can be created and then cpframe can be called from an MS Excel routine to run the analysis on the data file and produce the results file. Though it can be simply used at the command prompt. If type name in without a file name then it will show a brief message on how to use.

cpframe usage

run cpframe

Other wise it is simply called with a data file containing the definition of the structural model, a single load case per file, for example:
               cpframe refF_wrk.dat

screen dump as program runs

Which will then display its progress and generate a results file with the file extension .rpt for report. The report can be read with a simple text editor like notepad, and similarly data files can be created with notepad. Though the primary intent is that data files will be auto-generated by some other application.

Sample01

There are no graphics with this version. Since the graphics in the original version have full control of the graphics screen, its not fully compatible with use in Windows. It works in the Windows XP command prompt but does not seem to work in Windows 7. However can always load FreeDOS onto a bootable flashdrive and run from there.

Noting the benefit of being able to see the geometry and the direction of loading to check the validity of the model, in the near future I will release a version with the menus and graphics put back. However I will be removing the menus for data file creation, as objective is that data files will be created by an external application and I don't wish to expend time fixing such menus up. The source code has already been transferred to Delphi and a windows version part written. We also have a version in Excel/vba (.xla) which is providing the structures engine for cold-formed steel carport and veranda software. {Sorry! Cannot release the original version as the report file it produces implies we did the design of the structure being analysed. Plus it was compiled back in 1996 using Turbo Pascal, and finding the complete source code to compile something similar got complicated.}

Any case the idea isn't to write a stand alone frame analysis application but provide a library, or COM automation server or .net component which can be referenced in other applications, which need structural analysis as a component of a much larger system. A command line application provides a stepping stone towards such objective, it allows use in other applications, but in a more limited way than is possible if can send data direct into the analysis.

In future posts I will provide more sample data files, and an MS Excel workbook with vba code to write such data files. Resources for calculating wind loads and checking capacity of members can be found over on my ExelCalcs profile. Of course meshing it all together to fully automate simple buildings at the point of sale is a fairly massive exercise.

For small manufacturers approaching small engineering consultancies the one thing the consulting engineers have missing from their tool box is frame analysis. The consultants typically use MicroStran, Spacegass or Multiframe to conduct analysis, and therefore the engineers do not have their own tools to integrate into the software they are asked to develop. The simple solution to this is to use Kleinlogel formula, however new publications with such formula are now rare, and the older publications difficult to get hold of. Further there is the problem of finding the appropriate formula for the structure being considered. Sure they could attempt to derive the appropriate formula but that is more time and effort, and as the manufacturer introduces more variety into the structures more formulae are required. Where as  matrix structural analysis is more general purpose, once again there is still the problem of writing the source code and testing it. Also transforming theory into source code not so easy, and books with sample source not so readily available. Though a search of the web indicates recent engineering students/graduates may have experimented with matrix structural analysis using either MatLAB or SciLAB.

My previous contribution to easing this shortfall of analysis tools has been:

1. Release height/span charts showing the limitations of c-sections for the typical gable frame shed so that can limit the number of standard designs produce detailed calculations for.
2. Release MS Excel workbooks with Kleinlogel calculations in the worksheet.
3. Release MS Excel workbook with Kleinlogel formula as vba code for gable frame.
4. Release table of Contents of Kleinlogel formula book
5. Release a simple program for checking gable frame size based on Kleinlogel formula.

All of these tools we use in-house for quick decision making, though admittedly my gable frame spreadsheet contains the full design for cold-formed steel: still I believe I've provided all the resources for interested parties to build something similar better adapted to their needs. All the previous releases however have been focused on the gable frame (sample01) where as design of the so called American barn style structure (sample03) is often wanted by manufacturers.  Using plane frame application this is now more practical to accomplish than setting up worksheet calculations in Excel.

The program can be downloaded here. 

DISCLAIMER :
Users of the software must accept this disclaimer of warranty :
The software is supplied as is. The author disclaims all warranties, expressed or implied, including without limitation, the warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from the use of the software.

---

Related Posts:

Plane Frame Analysis History our Development

Plane Frame Analysis with Graphics
Plane Frame Analysis Front-End
Plane Frame Analysis Alternative Front-End
Plane Frame Analysis Back-End

Plane Frame Analysis Future Developments

---

Revisions:
[25/01/2014] Original

[23/04/2016] Changed download links to MiScion Pty Ltd Web Store

Kleinlogel Rigid Frame Formulas

Extracts Kleinlogel Rigid Frame Formulas

---

Now made available a simple 2D plane frame analysis command line program see:
Plane Frame Analysis

Alternatively have MS Excel worksheets for some of the common frames see:
Kleinlogel Formula at ExcelCalcs

Kleinlogel Formula at ExcelCalcs

An alternative source of the file is over on MiScion Pty Ltd: workbook for rigid frames using kleinlogel-formula.

---

Taken from the ExcelCalcs.com website.

---

Notes:

1. Now made available a simple 2D plane frame analysis command line program see:

Plane Frame Analysis

---

Revisions:
[28/11/2011] : Original
[12/05/2016] : Added alternative link to MiScion Pty Ltd