Excel Sheet Steel Weight Calculation Formula Excel

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.

As we think that calculating steel quantity for the slab is a too difficult task it required good skills in civil engineering. In this method the weight of steel is calculated by multiplying the density of the steel with the volume of steel. 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. 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.

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. The standard density of steel is 7850 kg m 3. 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. 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.

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. Online metal weight calculator which helps to calculate the weight of stainless sheet metal. Ss303 ss304 304l 308 309. Aluminium weight calculate formula.

Stainless steel 300 series weight calculate formula. Raw material grades.