Spreadsheet Bundle for Cold-formed Steel Structures Design


Price: (name your price) : As a start consider your own hourly rate and the time it is likely to take to create such workbook and the time needed to learn how to use. Divide the estimated cost by 1000 as that is the maximum number of units expect will ever be downloaded. For students the hourly rate is zero therefore price is zero, for consultants working on multimillion dollar buildings a reasonable price should be greater than zero. {NB: without income and without feedback the capabilities of the workbook will never be enhanced}

Design of cold-formed steel structures to AS4600.  Contains materials library, technical library add-in, calculator for member checks, bolt capacity tables, and example of using spreadsheet iteration to calculate effective section modulus for cold-formed c-section. The technical library contains functions to obtain effective section modulus directly so do not need the page of calculations illustrated in the iteration example. It is primarily for checking cold-formed C-sections and sections built up from c-sections (boxed, nested, back-to-back). The main quick calculator workbook covers:

  1. Sectional Moment Capacity
  2. Member Moment Capacity
  3. Tensile Capacity
  4. Compressive Capacity
  5. Shear Capacity

For information on setting up MS Excel environment refer to the following resources:

  1. SpreadsheetEnvironmentIssue1 (pdf file)
  2. Setting Up Spreadsheet Environment (online)