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.
Excel sheet steel weight calculation formula excel.
Aluminium weight calculate formula.
The standard density of steel is 7850 kg m 3.
Stainless sheet weight calculation material alloy steel aluminum beryllium brass bronze cast iron columbium copper copper alloys gold lead magnesium molybdenum nickel plastic silver stainless steel tantalum titanium tungsten zinc zirconium.
Excel metals weight calculator we are creating a shop quoting package and would like to integrate the stock weight calculation within our spreadsheet.
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.
Ss303 ss304 304l 308 309.
Raw material grades.
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.
Online metal weight calculator which helps to calculate the weight of stainless sheet metal.
Stainless steel 300 series weight calculate formula.
In this method the weight of steel is calculated by multiplying the density of the steel with the volume of steel.
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.
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.