{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Price bid "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Price bid ","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10],[4,0,4,2],[51,1,51,9],[41,0,41,5],[5,0,5,9],[47,3,47,9],[49,1,49,9],[50,1,50,9]]}
["     BHARAT HEAVY ELECTRICAL LIMITED , JHANSI              "]
["FACTORY   CIVIL  DEPARTMENT "]
["Price Bid (JS-146)"]
["Name of Work:- Miscellaneous civil works for tiling and rainwater harvesting inside factory area"]
["Tender  Enquiry No-FCX/TW/23/10"]
["Part A-DSR 2016  ITEMS"]
["Sl.no.","DSR 2016  Ref","Descripition of work","% Allocation (Item-wise)","Unit","Total Qty ","Analysed Rate of DSR-2016","Amount (Rs.)","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[1,"2.8.1","Earth  work  in  excavation  by mechanical  means  (Hydraulic excavator)  /  manual  means  in  foundation  trenches or drains, All kinds of soil  (not exceeding 1.5 m in width or 10 sqm on plan) including dressing of sides and ramming of bottoms, lift upto 1.5 m, including getting out the  excavated  soil  and  disposal  of  surplus excavated  soil  as directed, within a lead of 50 m. ",{"$f":"H8*0.82/1059206.71","v":1.9065498555990077E-2},"Cum",148,166.4,{"$f":"F8*G8","v":24627.200000000001},{"$f":"J8/F8","v":0},{"$f":"D8*$J$47","v":0}]
[2,"2.9.1","Excavation  work  by  mechanical  means  (Hydraulic excavator) /manual  means  in foundation  trenches  or  drains, Ordinary rock (not exceeding  1.5  m in width  or  10 sqm  on  plan)  including  dressing  of sides and ramming of bottoms lift upto 1.5 m, including getting out the  excavated  soil  and  disposal  of  surplus  excavated  soils  as directed, within a lead of 50m.  ",{"$f":"H9*0.82/1059206.71","v":3.2032982494984382E-3},"Cum",15,275.85000000000002,{"$f":"F9*G9","v":4137.75},{"$f":"J9/F9","v":0},0]
[3,2.25,"Filling available excavated earth in (excluding rock)",4.8675579103912582E-4,"Cum",5,125.75,628.75,0,0]
[4,"2.28.1","Surface dressing of the ground including removing vegetation and in -equalities not exceeding 15 cm deep and disposal of rubbish lead unto 50 m and lift upto 1.5 m for all kinds of soil.   ",4.3198366823034942E-5,"100sqm",4,13.95,55.8,0,0]
[5,"4.1.3","P and L in position Cement concrete -1:2:4 (1 Cement: 4 coarse sand: 8 graded stone aggregate 20mm nominal size) excluding the cost of entering and shuttering all work up to plinth level.",1.0019481844105763E-2,"cum",4,3235.58,12942.32,0,0]
[6,"4.1.6","Providing and laying in position cement concrete of specified grade excluding the cost of centering and shuttering - All work up to plinth level :1:3:6 (1 Cement : 3 coarse sand (zone-III): 6 graded stone aggregate 40 mm nominal size).",2.2581946256741519E-2,"cum",9,3241.05,29169.45,0,0]
[7,"5.1.3/97","Providing and laying in position specified grade of reinforced cement concrete, excluding the cost of centering, shuttering, finishing and reinforcement - All work up to plinth level : 1:2:4 (1 cement : 2 coarse sand : 4 graded stone aggregate 20 mm  nominal size). ",1.0919556202584857E-2,"cum",4,3526.24,14104.96,0,0]
[8,"5.2.2","Reinforced  cement  concrete  work  in  walls  (any  thickness), including attached pilasters, buttresses, plinth and string courses, fillets, columns, pillars, piers, abutments, posts and struts etc. up tofloor five level excluding cost of  centering, shuttering, finishing and reinforcement : 1:1.5:3 (1 cement : 1.5 coarse sand : 3graded stone aggregate 20 mm nominal size)   ",3.3005952162066649E-3,"cum",1,4263.43,4263.43,0,0]
[9,"5.9.1","Centering and shuttering including strutting, propping etc.  And removal of form for: Foundations, footings, bases of columns, etc.  For mass concrete.  ",7.1385688257205235E-4,"sqm",5,184.42,922.09999999999991,0,0]
[10,"6.1.2","Brick work with FPS bricks of   (II nd class kanpur brick ) upto plinth 1:6 ( 1 cement: 6 fine sand )   ",1.8195477254859913E-2,"cum",6,3917.23,23503.38,0,0]
[11,"6.4.2","Brick  work  with  FPS  bricks  of    (II nd class kanpur brick ) in Super  structure 1:6 (1 cement : 6 fine sand ) upto floor five level ",2.5732400052488343E-2,"Cum",7,4748.42,33238.94,0,0]
[12,"6.13.2","Providing Half Brick masonry in super structure upto floor five level . 1:4 ( 1 cement :4 coarse sand )",1.7505712364680921E-3,"Cum",4,565.30999999999995,2261.2399999999998,0,0]
[13,"7.1.1","R.R.Masonary with hard stone in foundation and plinth -1:6(1 cement: 6 coarse sand) including leveling up with cement concrete 1:6;12 ( 1 cement :6 coarse sand ; 12 graded stone aggregate of 20mm nominal size ) .  ",6.7121343670490899E-2,"Cum",26,3334.68,86701.68,0,0]
[14,"7.2.1","Random rubble masonry with hard stone in superstructure above plinth level and upto floor five level, including leveling up with cement concrete 1:6:12 (1 cement : 6 coarse sand : 12 graded stone aggregate 20 mm nominal size) at window sills, ceiling level and the like.  Cement mortar 1:6 (1 cement : 6 coarse sand)",0.25143934558345082,"Cum",78,4163.95,{"$f":"F21*G21","v":324788.09999999998},0,0]
[15,"11.3.1","Cement concrete flooring 1:2;4 ( 1 cement : 2 coarse sand : 4 graded stone aggregate ) finished with a floating coat of neat cement including cement slurry but excluding the cost of nosing of steps etc complete . 40 mm thick 20 mm nominal size stone aggre",1.4111218762955156E-2,"Sqm",74,246.32,18227.68,0,0]
[16,11.36,"Providing and fixing Ist quality ceramic glazed wall tiles conforming to IS: 15622 (thickness to be specified by the manufacturer), of approved make, in all colours, shades except burgundy, bottle green, black of any size as approved by Engineer-in-Charge, in skirting, risers of steps and dados, over 12 mm thick bed of cement mortar 1:3 (1 cement : 3 coarse sand) and jointing with grey cement slurry @ 3.3kg per sqm, including pointing in white cement mixed with pigment of matching shade complete",0.12792522811718213,"Sqm",260,635.54999999999995,165243,0,0]
[17,11.38,"Providing and laying Ceramic glazed floor tiles of size 300x300 mm (thickness to be specified by the manufacturer), of 1st quality conforming to IS : 15622, of approved make, in all colours, shades, except White, Ivory, Grey, Fume Red Brown, laid on 20 mm thick bed of cement mortar 1:4 (1 Cement : 4 Coarse sand), jointing with grey cement slurry @ 3.3kg/sqm including pointing the joints with white cement and matching pigments etc., complete",4.764903726865552E-2,"Sqm",100,615.49,61549,0,0]
[18,"11.49.2","Providing and laying Vitrified tiles in floor with different sizes (thickness to be specified by the manufacturer), with water absorption less than 0.08% and conforming to IS:15622 , of approved brand & manufacturer, in all colours and shade, laid with cement based high polymer modified quick set tile adhesive (water based) conforming to IS : 15477, in average 6 mm thickness, including grouting of joints (Payment for grouting of joints to be made separately). Size of Tile 600x600 mm",8.1624723091114113E-2,"Sqm",101,1043.92,105435.92000000001,0,0]
[19,"13.1.2"," Plaster -12 mm thick in 1:6 ( 1 cement : 6 fine sand ) ",1.2378112672643472E-2,"Sqm",118,135.5,15989,0,0]
[20,"13.2.2"," Plaster -15 mm thick in 1:6 ( 1 cement : 6 fine sand ) ",5.658343497465192E-3,"Sqm",47,155.51,7308.9699999999993,0,0]
[21,"15.2.1","Demolishing cement concrete manually/ by mechanical means including disposal of material within 50 metres lead as per direction of Engineer - in - charge.Nominal concrete 1: 3:6 or leaner mix (i/c equivalent design\nmix)",1.5437609907135122E-3,"Cum",2,997.05,1994.1,0,0]
[22,"15.44.1","Dismantling G.I. pipes (external work) including excavation and refilling trenches after taking out the pipes, manually/ by mechanical means including stacking of pipes within 50 metres lead as per direction of Engineer-in-charge : 15 mm to 40 mm nominal bore ",2.6116044903076565E-3,"Mtr ",53,63.65,3373.45,0,0]
[23,15.56,"Dismantling old plaster or skirting raking out joints and cleaning the surface for plaster including disposal of rubbish to the dumping ground within 50 metres lead",4.3353199679031489E-3,"sqm",250,22.4,{"$f":"F30*G30","v":5600},0,0]
[24,"17.1.1","Providing and fixing water closet squatting pan (Indian type W.C. pan ) with 100 mm sand cast Iron P or S trap, 10 litre low level white P.V.C. flushing cistern, including flush pipe, with manually controlled device (handle lever) conforming to IS : 7231, with all fittings and fixtures complete, including cutting and making good the walls and floors wherever required:  White Vitreous china Orissa pattern W.C. pan of size 580x440 mm with integral type foot rests",1.4673742012076191E-2,"Nos",6,3159.05,18954.300000000003,0,0]
[25,"17.4.2","Providing and fixing white vitreous china flat back or wall   corner type lipped front urinal basin of 430x260x350 mm and 340x410x265 mm sizes respectively with automatic flushing cistern with standard flush pipe and C.P. brass spreaders with brass unions and G.I clamps complete, including painting of fittings and brackets, cutting and making good the walls and floors wherever required :\nRange of two  urinal basin with 5 litre white P.V.C. automatic flushing cistern.",1.1503423160905014E-2,"each ",3,4953.05,14859.150000000001,0,0]
[26,"17.7.2","Providing and fixing wash basin with C.I. brackets, 15 mm C.P. brass pillar taps, 32 mm C.P. brass waste of standard pattern, including painting of fittings and brackets, cutting and making good the walls wherever require: White Vitreous China Wash basin size 630x450 mm with a single 15 mm C.P. brass pillar tap",8.414623808416016E-3,"Nos",6,1811.55,10869.3,0,0]
[27,17.8,"Providing and fixing white vitreous china pedestal for wash basin completely recessed at the back for the reception of pipes and fittings.",3.9013234725448439E-3,"Nos",6,839.9,5039.3999999999996,0,0]
[28,17.309999999999999,"Providing and fixing 600x450 mm beveled edge mirror of superior glass (of approved quality) complete with 6 mm thick hard board ground fixed to wooden cleats with C.P. brass screws and washers complete.",7.0190378608911931E-3,"each ",12,755.55,9066.5999999999985,0,0]
[29,"18.10.1","Providing and fixing G.I. pipes complete with G.I. fittings and clamps, i/c cutting and making good the walls etc.15 mm dia nominal bore",1.3207242616504949E-2,"Mtr",100,170.6,17060,0,0]
[30,23.5,"Supplying, filling, spreading & leveling stone boulders of size range 5 cm to 20 cm, in recharge pit, in the required thickness, for all leads & lifts, all complete as per direction of Engineer-in-charge. ",1.7777289194098857E-2,"cum ",26,883.2,22963.200000000001,0,0]
[31,23.6,"Supplying, filling, spreading & leveling gravels of size range 5 mm to 10 mm, in the recharge pit, over the existing layer of boulders, in required thickness, for all leads & lifts, all complete as per direction of Engineer-in-charge. ",2.1325872454112382E-2,"cum ",28,983.82,27546.960000000003,0,0]
[32,23.7,"Supplying, filling, spreading & leveling coarse sand of size range 1.5 mm to 2 mm in recharge pit, in required thickness over gravel layer, for all leads & lifts, all complete as per direction of Engineer -incharge.",2.1542638452507541E-2,"cum ",28,993.82,27826.960000000003,0,0]
[33,"DSR 2016","All items of DSR 2016 but not covered above.",1.9354106999567629E-2,"basic value",25000,1,25000,0,0]
[null,null,"Total A ",{"$f":"SUM(D8:D40)","v":0.87112997405388404},null,null,"(A)",{"$f":"SUM(H8:H40)","v":1125252.0900000001}]
["Part B NON-DSR 2016  ITEMS"]
["Sl.no.","NS item","Descripition of work",null,"Unit","Total Qty ","Rate (Rs.)","Amount (Rs.)"]
[33,"NS-1","4” to 6” making boring of all type earth up to 100- 110 feet deep by compressor mechanical machine as per direction of Engineer in charge.",{"$f":"H44/1059206.71","v":5.947847516940296E-2},"ft",350,{"$f":"'[1]CST Budgetary'!H5","v":180},{"$f":"G44*F44","v":63000},0,{"$f":"D44*$J$47","v":0}]
[34,"NS-2","Providing PVC Casing pipe 5\" dia confirming to IS 12818 (2000) as per direction of Engineering in Charge.",{"$f":"H45/1059206.71","v":6.9391554364303457E-2},"ft",150,{"$f":"'[1]CST Budgetary'!H6","v":490},{"$f":"G45*F45","v":73500},0,{"$f":"D45*$J$47","v":0}]
[null,null,"Total B ",{"$f":"SUM(D44:D45)","v":0.12887002953370641},null,null,null,{"$f":"ROUND(SUM(H44:H45),2)","v":136500},null,{"$f":"SUM(J44:J45)","v":0}]
[null,null,"Total C (A+B) ",{"$f":"D41+D46","v":1.0000000035875904},null,null,null,{"$f":"#REF!+H46","v":{"$error":"#REF!"}},null,0]
[null,null,"IN WORDS",{"$f":"rup(J47)","v":0}]
[null,"Note -GST extra as applicable"]
[null,"1. Bidder has to quote in above unlocked cell (J-47) only. Item rate shall be calculated automatically. Calculated item rates upto four decimal points may be adjusted w.r.t. gross total amount and it shall be the itemwise final rate for  execution of contract and all other purposes."]
[null,"2. Quoted gross total amount should be considered only if quoted in this excel sheet and print out of this should only be considered for evaluation.  If Price is quoted in any other format other than the Excel Sheet enclosed to the NIT , the offer of the bidder  will be rejected"]
[null,"3.During the execution , the quantity of various items may vary to any extent depending on requirement of work/site and as per discretion of BHEL."]
[]
[]
[null,null,null,null,"(Signature and Seal of  Contractor  )"]