Steel Quantity Calculation Excel Sheet

Estimation of steel quantity is an essential skill of any civil engineer.

Steel quantity calculation excel sheet.

Bill of quantities boq building. 1 plan of section or element. Total weight stirrups 71 x 1 592 x 0 395 44 648 kg. Slab beam column foundation 2 section and elevation details.

If don t have cover details let it be they are standard. We must remember than steel is ductile in nature and is subject to elongation. One way slab steel quantity spreadsheet. Each civil engineer should be acquainted with the technique of computation of steel quantity out of drawing.

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. Every civil engineer must know the method of calculation steel quantity from drawing. Hence the length of a bar is increased when bends or hooks are introduced. Design of barrage excel sheet.

Information needed for assessment of steel quantity. Hence certain deductions are needed to offset this increase in length. Data requires for estimation of steel quantity. Calculation of slab reinforcement steel quantity with simple excel sheet this simple excel sheet will help you in calculation of quantity of reinforcement steel required for slabs just put the basic details as shown in above figure it will calculate the steel quantity and show you in a table which you can print and file it for record.

Steps to calculate steel quantity. Slab positive and negative steel estimation. Convert inches to feet enter the thickness of the slab in mm only. 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.

Enter main and distribution steel diameter in excel sheet. Assessment of steel quantity is a vital expertise of a civil engineer. 3 all dimensions must be clear and co related. Steel calculation is quite a lengthy process and doing it manually can cost a lot of time.

Plan of element or section. Beam slab foundation and column elevation as well as section specifications. Free material calculation sheet by haseeb. Beam steel estimation.