Example Using Circular References to Force Iteration: Calculation Effective Section Modulus for Coldformed C-Section to AS4600
 

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

Description:

Calculation of effective section modulus (Zex) using effective width methods of AS4600, for a coldformed c-section. The workbook is dependent on: schTechLib It uses circular references to force iteration on the calculation of the section centroid. The web has a stress gradient and so the portion which is in compression and not effective is unknown. Has chunks are removed to determine effective width of plates, the section modulus of the c-section changes and so does the location of the neutral axis, and so the portion of the web in compression is different than initially assumed. The circular references force iteration until the difference between the initial assumption and the calculated value is insiginificant.

Calculation Reference
Cold Form Sections
| 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:
29 Aug 2010
Submitted By:
InfoJunkie65
File Date:
28 Aug 2010
File Author:
Conrad Harrison
File Version:
1.0
File Size:
79.00 Kb
File Type:
xls
Downloads:
56
Rating:
stars/4.gifTotal Votes:1
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  

 
#1 syj0103 2010-11-25 09:05
good
 

Please sign in or register to add a comment.

We have 23 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.