Excel Sheet Steel Weight Calculation Formula Excel

Raw material grades.

Excel sheet steel weight calculation formula excel.

Online metal weight calculator which helps to calculate the weight of stainless sheet metal. 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. Aluminium weight calculate formula. 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.

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

The standard density of steel is 7850 kg m 3. Stainless steel 300 series weight calculate formula. 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. 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.

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. 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.