How to calculate the weight of steel bar with excel

In this construction video tutorial, the eminent engineer S.L.Khan provides you some useful information regarding how to determine the weight of steel bars by creating your own excel sheet.

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.

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.

2) Provide the following formula in the cell right under that cell in which weight is already written and then press enter. Apply formula:
=(C2^2)*(D2)/162.198

3) Now provide the value of diameter and length in the respective cells and press enter.

4) Now check the cell that is assigned for weight and result will be visible.

If you want to convert the measuring unit from KG to TON, just divide the formula (where measuring unit is given in KG) with 1000 i.e. =((C2^2)*(D2)/162.198)/1000

For more clarity, go through the following video.

Video Source: SL Khan