Flat product includes plate sheet strip coil and flat bar densities carbon steel 7800 stainless steel austenitic 7900 aluminium alloys 2700 copper alloy 385 8470 rd group carbon ferritic stainless steels austenitic stainless steels copper alloys note aluminium alloys note others note 7800 00 7900 00 8470 00 2700 00 5000 00 1.
Excel sheet steel weight calculation formula excel.
After generating this formula it is required to enter only diameter and length of bar and the excel will provide the weight of that bar directly.
The basic task in the calculation of steel is the multiplication and sorting of the lengths as per the diameter of the bars and then later finding their weights for the ordering.
Ss303 ss304 304l 308 309.
The formula for calculation of the volume of steel is different for different sections.
As we think that calculating steel quantity for the slab is a too difficult task it required good skills in civil engineering.
Aluminium weight calculate formula.
Online metal weight calculator which helps to calculate the weight of stainless sheet metal.
In this method the weight of steel is calculated by multiplying the density of the steel with the volume of steel.
But i am sharing with you an excel sheet which will make slab steel quantity calculation too easy for anyone who wants to know the exact quantity of steel required for his her slab.
Excel metals weight calculator we are creating a shop quoting package and would like to integrate the stock weight calculation within our spreadsheet.
I prepared an overview of how the process can be automated in excel and a number of steps could be eliminated saving a lot of time.
Raw material grades.
Currently we open mso metals weight calculator in a separate window enter the pertinent information and then copy the resulting weight calculation into the appropriate cell.
Given below the complete process for calculation 1 at first open your excel and write diameter in one cell then write length of bar and weight in the next cells.