Calculator for assessment of steel structures to AS4100
A simple calculator for assessing steel structural members and some connection components to AS4100: Australian Steel Structures Code. It requires:
16 Feb 2014
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
I have checked and only AS4600 functions make use of Data Access Objects (DAO), so AS4100 should not require the struMtrl.mdb. It should be noted that DAO is available on all Windows computers and MS Access is not required.
Do not allow Excel to update link values when open schDsgn4100.xls.
It is necessary to make sure schTechLIB.xla is added to Excel add-in's before attempt to update any links.
Before updating the link to schStruMtrl.xls, open the file first, the update will be a lot faster.
I have tested by creating ExcelCalc, and materials folders in my documents under my profile. I have also tested in shared documents. I also created a new profile and set up under my documents there. I didn't time but a rough guess is took less than a minute to break the links to previous set up, and then fix the links for the new set up.
If done in the correct sequence, Excel more or less up dates all the paths itself. Some times this is beneficial most of the time I find it annoying. If want to save a copy of schDsgn4100.xls with each project on another drive and retain links to a central location: then do not copy the file to the project folder, use Excel "Save As" command to create a copy.
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.
PS I can be emailed at tpcooper.qinetiq.com.au, if needed.