Let me explain my problem
I have Flange Width W in 1 column and Depth d in Column on one worksheet. I have the section data including the Fireproofing quantity/ft on one sheet. I want a formula that checks the depth and width matches it to fireproof quantity n returns that value in sheet 1.
i...
I am trying to use excel to return a value by matching two criteria. Basically im using it to return fire-proofing area for a specific w section. The formula should look up the width of flange then look up the depth and return the corresponding value for FP. Can anyone please help me with this...
I found a good way to extract data for the steel props
http://www.efunda.com/math/areas/IndexArea.cfm
Scroll to the bottom of the page and click on "STEEL W TYPE I-BEAMS". Then click on "ALL" and then "GET".
I used this suggestion by TampaBridgeDesign and when the page came up used print to...
I have been searching the internet for a long time for a database/excel file for structural steel props. The only place i found was aisc and for that i have to be a member which is expensive.....does anybody know aof any other source for the same!!
Thank you.