Is There A Multiplier To Get From Sheet Metal Gauge To Actual Thickness Or Weight?
I want to add a function to a spread sheet to automatically calculate the weight of the material based on the steel gauge and square footage.
1 Answer - Sort by: Date | Rating
The data on this site appears to be piece-wise linear, having eight linear segments between 7/0 and 38 ga. Each higher numbered gauge is approximately 90% of the weight per square of the one before, but that approximation is not sufficiently close that it can be relied upon.
A spreadsheet should be able to compute a piecewise linear function using a lookup table.
7/0 ga 320 oz/ft2 decreasing by 20 oz/ft2 for each ga.
1 ga 180 oz/ft2 decreasing by 10 oz/ft2 for each ga.
14 ga 50 oz/ft2 decreasing by 5 oz/ft2 for each ga.
16 ga 40 oz/ft2 decreasing by 4 oz/ft2 for each ga.
20 ga 24 oz/ft2 decreasing by 2 oz/ft2 for each ga.
26 ga 12 oz/ft2 decreasing by 1 oz/ft2 for each ga.
31 ga 7 oz/ft2 decreasing by 1/2 oz/ft2 for each ga.
36 ga 4 1/2 oz/ft2 decreasing by 1/4 oz/ft2 for each ga.
38 ga 4 oz/ft2
You need to figure out the density to convert to thickness. It looks like 20 oz/ft2 corresponds to about 1/32 inch thickness.
A spreadsheet should be able to compute a piecewise linear function using a lookup table.
7/0 ga 320 oz/ft2 decreasing by 20 oz/ft2 for each ga.
1 ga 180 oz/ft2 decreasing by 10 oz/ft2 for each ga.
14 ga 50 oz/ft2 decreasing by 5 oz/ft2 for each ga.
16 ga 40 oz/ft2 decreasing by 4 oz/ft2 for each ga.
20 ga 24 oz/ft2 decreasing by 2 oz/ft2 for each ga.
26 ga 12 oz/ft2 decreasing by 1 oz/ft2 for each ga.
31 ga 7 oz/ft2 decreasing by 1/2 oz/ft2 for each ga.
36 ga 4 1/2 oz/ft2 decreasing by 1/4 oz/ft2 for each ga.
38 ga 4 oz/ft2
You need to figure out the density to convert to thickness. It looks like 20 oz/ft2 corresponds to about 1/32 inch thickness.
1
0
- What Is Key Board?
- Where I Can Get Maharashtra Boards Paper 12th Commerce?
- Identify The Measures How Will U Keep Your Surroundings Clean?
- How To Impres Girls?
- When Is The Date And Time University Wrote Their Potume Jamb?
- How Statistics Is Applied In Education?
- What Materials Are In A Usb?
- Who Are The Passers In PNPA, October 25 Examination?
- What Would Be The Alternative For Convenience Sampling And Why?
- What Are The Factors Affecting Planning In Management?
- Where Can I Find A Good Argument Letter?
- Did We Forget The Well Known Saying, "TODAY WE ARE, WHERE OUR THOUGHTS HAVE TAKEN US"?
- How To Get On Gangsterparadise2 In School?
- Can I Get The Teacher Form For Government Jobs, From Hinduja College?
- I Am A Student Of Commerce, Recently Doing My Enter. I Am Indifferent About My Future. May Someone Suggest Me Plz, What Relevant Field Would Be Valid For Me To Make My Future Bright?
- What Is The Operation Management Objectives?
- When Bca Third Semester Exam Will Held?
- How To Write A Letter To Your Friend Who Passing The Examination?
- Why Use Sampling Techniques To Obtain Information?
- What Was The Most Amount Of People That People In A Ww1 Trench?
- What Is The Internal Or External Environmental Factor And How Manager With Them?
- How Can I Get A High Mark In Toefl?
- How Long Will It Take To Earn 1000000. If I Invest 2500. Per Month?
- What Is Scope And Limitations Of The Study?
- What Are The Duties Of Facility - Sourcing Manager?
- What Is The Reason For The System Of Gauge Thickness For Sheet Metal?
- Can Anyone Tell About The Thickness Measurement Gauge For Measuring The Metal Sheet?
- Can Anyone Give The List Of Sheet Metal Thickness Gauge In Inches?
- Can Any One Please Tell Me Something About "Sheet Metal And Its Thickness"?
- Is 16 Gauge Thicker Than 18 Gauge Sheet Metal?
- Which Is Thicker In Sheet Metal 14 Gauge Or 19 Gauge?
- Can Anyone Give Me The Tips For The Care And Upkeep Of Metal Sheet Gauge?
- What Is The Inch Thickness Of 24 Gauge?
- How Many Times Does A Sheet Of Paper Need To Be Folded To Have A Thickness Of 5 Feet 10 Inches?
- What Does Gauge Mean When Working With A Metal?

New Comment - Comments are editable for 5 min.