PART-A
I ELECTRONIC SPREAD SHEET USING SOFTWARE
SOLVING PROBLEMS INVOLVING ESTIMATION, ANALYSIS AND DESIGN
USING ANY ONE OF THE AVAILABLE PACKAGES MENTIONED BELOW OR
ANY OTHER SUITABLE PACKAGES FOR THE FOLLOWING EXERCISES
1.PREPARE THE ESTIMATE SHEET WITH GIVEN DATA (PROVIDE ALL THE
MEASUREMENT DETAILS) AND CALCULATE THE QUANTITY USING
FORMULA BAR.
2.PREPARE THE ABSTRACT SHEET FOR THE GIVEN DATA AND
CALCULATE AMOUNT AND TOTAL AMOUNT USING FORMULA BAR (USE
SEPARATE COLUMN FOR RATES AND UNITS)
3.DESIGN AND ANALYSIS PROBLEMS
I) CALCULATE AREA AND ELONGATION USING FORMULA BAR
II) CALCULATE EFFECTIVE DEPTH ‘D’ AND AREA OF STEEL ‘AST’ USING
FORMULA BAR.
4.FOR GIVEN DIMENSION OF MASONRY/R.C.C DAM IE. TOP WIDTH,
BOTTOM WIDTH, HEIGHT OF DAM, HEIGHT OF WATER, SPECIFIC WEIGHT
OF MASONRY/R.C.C. SP. WT OF WATER ETC, FIND THE BASE
PRESSURE AND CHECK THE STABILITY OF THE DAM.
5.FINDING CENTRE OF GRAVITY: IZZ AND IYY OF I AND LSECTIONS.