Calculator for assessment of coldformed steel structures to AS4600
 

Description:

A simple calculator for making assessement of structural components to the Australian coldformed steel structures code AS4600. It requires:

schTechLIB

schStruMtrl

Calculation Reference
AS4600
| 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
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:

02 Sep 2010

Submitted By:

InfoJunkie65

File Date:

28 Aug 2010

File Author:

Conrad Harrison

File Version:

1.0

File Size:

520.50 Kb

File Type:

xls

Downloads:

62

Rating:

Total Votes:1

HTML Link:

Copy code below to your web page to create link to this page:

<a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=633">ExcelCalcs.com calculation Calculator for assessment of coldformed steel structures to AS4600</a>

HTML Window:

Copy code below to your web page to create a dynamic window to this download:

<span style="font-size: 8pt">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=633">ExcelCalcs.com</a> website.<br /></span><iframe id="ExcelCalcsSample633" name="ExcelCalcsSample633" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=633" align="top" scrolling="auto" height="650" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>

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  

12

 

#6 InfoJunkie65 2012-02-14 05:44

Click the big red button above: check version history, and reply to topic. Should then allow attachment of a file.

 

 

#5 blackbird 2012-02-14 05:30

I am able to choose the sections from the dropdown meniu. but whatever thin-walled section i choose it still goes to #VALUE! at H54. maybe a printscreen helps but donno how to upload it here. i am pretty sure i am missing something somewhere

 

 

#4 InfoJunkie65 2012-02-14 04:09

Quoting blackbird:

I am getting the #VALUE! in the schDsgn4600 calculator in the H54 cell. what am i missing? thanks. everything else is fine.

If everything else is fine, not sure why that would be. Could check that I100 = 0, eg. not a built-up section. Also check section type. The vba code breaks the section up into plate elements and calculates new section properties based on sectionType.

Otherwise I need more information.

 

 

#3 blackbird 2012-02-14 02:20

I am getting the #VALUE! in the schDsgn4600 calculator in the H54 cell. what am i missing? thanks. everything else is fine.

 

 

#2 InfoJunkie65 2012-01-03 11:48

Sorry. Only just noticed the query. For some reason didn't receive email notification.

The workbook depends on two other workbooks:

1) schTechLib
2) schStruMtrl

can find hyperlinks to above.

These files need to be placed in shared documents folder in subfolder ExelCalcs (note spelling error: not Excel)

The material file in a further subfolder materials.

When the workbook is opened, go to edit/links menu option and open the source files. If necessary adjust the locations if want to place the workbooks somewhere else. Note the workbook needs to be on the c drive. If not then Excel will adjust all link paths by changing the drive reference.

If schStruMtrl is not open then the drop down lists will not work. Strictly Excel 2003 does not permit creating drop down validation lists to data in other workbooks. But it doesn't stop moving worksheets or copying cells. So central library files can be created, just a hindrance to use. Need to use Excel/SaveAs menu option, to save file to another drive, without automatic change of link paths.

 

12

Refresh comments list
RSS feed for comments to this post

Please sign in or register to add a comment.

JComments