Calculator for assessment of steel structures to AS4100
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:


A simple calculator for assessing steel structural members and some connection components to AS4100: Australian Steel Structures Code. It requires:

schTechLIB

schStruMtrl

Calculation Reference
AS4100
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural Analysis
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Section Properties
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
16 Feb 2014
Submitted By:
InfoJunkie65
File Date:
16 Feb 2014
File Author:
Conrad Harrison
File Version:
2.0
File Size:
575.00 Kb
File Type:
xls
Downloads:
154
Rating:
stars/5.gifTotal Votes:3
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#3 InfoJunkie65 2016-09-25 06:47
Have prepared a blog post with general information on setting up MS Excel environment for using my spreadsheets. Activating the add-in, updating the links, and making modifications which may be caused by using other versions of Excel. The spreadsheets are created in Excel 2003, the post is based on opening files in Excel 2016.

http://miscion.com.au/setting-up-spreadsheet-environment/
 
 
#2 InfoJunkie65 2014-02-14 03:48
Sorry! All my spreadsheets make use of vba, and some of the functions use data access objects (DAO) to get information from MS Access tables. It is done this way because traditionally a database was/is the proper place to store data not a spreadsheet. Additionally vba code is useful across more applications than a worksheet cell formula, and vlookup has some tight restrictions and is not all that reliable. Also unfortunately Excel and Access are not as tightly integrated as Borland Quattro Pro and Paradox were, which is where most of my spreadsheets started. At one stage I did have Excel worksheets grabbing data from Access tables directly, but an upgrade on one computer resulted in needing Access tables compatible with each version of Office. The other problem with Excel database queries is that it is near impossible to update the links to the database if the database file changes location. Consequently vba and DAO is actually easier to manage than using the Excel commands, as doesn't have these problems: though it may not seem so easy.

There are two sets of functions in schTechLIB, one set which make use of DAO and the other which require passing all the section and material parameters. In most instances the DAO functions call the latter.

There are thus two options available to you: Modify the workbook and remove all the functions which use DAO, or modify the vba code and change the path to the MS Access database.

I did upload a new version of schTechLIB as a quick fix to similar problem with AS4600, but that may have now crippled everything else.

I'll see if I can find time to revise schTechLIB and write some configuration macros.
 
 
#1 Djuric 2014-02-13 23:23
Can you please provide instructions on how to get the AS4100 calculator working. I have downloaded all files, (schDsgn4100.xls, schStruMtrl.xls, schTechLIB.xla and struMtrl (access database - why do I need this?). I have tried updating the links to the .xls and .xla files, enabled the add-in, but it doesn't work. this is very disappointing so far.
Tim.
PS I can be emailed at tpcooper.qinetiq.com.au, if needed.
 

Please sign in or register to add a comment.

We have 21 guests and 42 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.