{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Boiler 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":"Boiler Price Bid","index":0,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":false,"merged":[[61,4,61,9],[1,0,1,9],[0,0,0,9],[4,0,4,1],[5,0,5,9],[51,0,51,9],[2,0,2,9],[3,0,3,9],[65,0,65,8],[66,0,66,8],[67,0,67,8],[68,4,68,5],[71,4,71,8]]}
["BHARAT HEAVY ELECTRICALS LIMITED JHANSI"]
["FACTORY CIVIL DEPARTMENT"]
["Price bid "]
[{"$f":"[1]Scope!A4","v":"NAME OF WORK: Civil work for 10MTPH capacity Gas fired Boiler Plant inside factory area."}]
["Tender ENQ No-",null,"FCX/TW/22/11"]
["Part (A) -DSR items "]
["Sl. No.","DSR 2016 ","Description of Work","% Allocation (Item-wise)","Unit ","Quantity ","Analysed rate of DSR-2016","Amount ","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[1,"1.1.2/68","By Mechanical Transport including loading, unloading and stacking Earth   upto 1 km .",{"$f":"(H8*0.55*1.05)/1989287.94","v":2.2838865649585155E-3},"Cum",{"$f":"[1]Measurement!H9","v":80},98.34,{"$f":"F8*G8","v":7867.2000000000007},{"$f":"ROUND(J8/F8,2)","v":0},{"$f":"D8*$J$61","v":0}]
[2,"2.6.1/76","Earth work in excavation by mechanical means (Hydraulic excavator)/ manual means over areas (exceeding 30 cm in depth, 1.5 m in width as well as 10 sqm on plan) including getting out and disposal of excavated earth lead upto 50 m and lift upto 1.5 m, as directed by Engineer-in-charge. All kinds of soil",{"$f":"(H9*0.55*1.05)/1989287.94","v":1.7550671925352348E-3},"Cum",{"$f":"[1]Measurement!H17","v":48},125.95,{"$f":"F9*G9","v":6045.6},{"$f":"ROUND(J9/F9,2)","v":0},0]
[3,"2.7.1/76","Earth work in excavation by mechanical means (Hydraulic excavator)/ manual means over areas (exceeding 30 cm in depth, 1.5 m in width as well as 10 sqm on plan) including getting out and isposal of excavated earth lead upto 50 m and lift upto 1.5 m, as directed by Engineer-incharge. - ordinary  rock ",5.1337515271921881E-3,"Cum",{"$f":"[1]Measurement!H22","v":80},221.05,17684,0,0]
[4,"2.7.3/76","Earth work in excavation by mechanical means (Hydraulic excavator)/manual means over areas (exceeding 30 cm in depth, 1.5 m in width as well as 10 sqm on plan) including getting out and disposal of excavated earth lead upto 50 m and lift upto 1.5 m, as directed by Engineer-incharge. - Hard rock (blasting prohibited",5.7577909007984034E-3,"Cum",{"$f":"[1]Measurement!H27","v":32},619.79999999999995,19833.599999999999,0,0]
[5,"2.25/79","Filling available excavated earth (excluding rock) in trenches, plinth, sides of foundations etc. in layers not exceeding 20cm in depth, consolidating each deposited layer by ramming and watering, lead up to 50 m and lift upto 1.5 m.",3.5775722090789939E-3,"Cum",{"$f":"[1]Measurement!H33","v":98},125.75,12323.5,0,0]
[6,"2.31/80","Clearing jungle including uprooting of rank vegetation, grass, brush wood, trees and saplings of girth up to 30 cm measured at a height of 1 m above ground level and removal of rubbish up to a distance of 50 m outside the periphery of the area cleared",6.2705854437543123E-4,"Sqm",{"$f":"[1]Measurement!H37","v":300},7.2,2160,0,0]
[7,"4.1.3/88","Providing and laying in position cement concrete of specified grade excluding the cost of centering and shuttering - All work up to plinth level : \"1:2:4 (1 cement : 2 coarse sand (zone-III) : 4 graded stone aggregate 20 mm nominal size). ",1.878609337972461E-2,"Cum",{"$f":"[1]Measurement!H44","v":20},3235.58,64711.6,0,0]
[8,"4.1.6/88","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). ",1.317249691364439E-2,"Cum",{"$f":"[1]Measurement!H53","v":14},3241.05,45374.700000000004,0,0]
[9,"5.1.2/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:1.5:3 (1 cement : 1.5 coarse sand (zone-III): 3 graded stone aggregate 20 mm nominal size).",6.681066095439156E-2,"Cum",{"$f":"[1]Measurement!H61","v":67},3434.92,230139.64,0,0]
[10,"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.7402639660098678E-2,"Cum",{"$f":"[1]Measurement!H66","v":17},3526.24,59946.079999999994,0,0]
[11,"5.2.2/97","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. above plinth level up to floor five level, excluding cost of centering, shuttering, finishing and reinforcement :1:1.5:3 (1 cement : 1.5 coarse sand(zone-III) : 3 graded stone aggregate 20 mm nominal size).",2.4753890831912457E-3,"Cum",{"$f":"[1]Measurement!H71","v":2},4263.43,8526.86,0,0]
[12,"5.3/97","Reinforced cement concrete work in beams, suspended floors, roofs having slope up to 15° landings, balconies, shelves, chajjas, lintels, bands, plain window sills, staircases and spiral stair cases above plinth level up to floor five level, excluding the cost of centering, shuttering, finishing and reinforcement, with 1:1.5:3 (1 cement: 1.5 coarse sand (zone-III): 3 graded stone aggregate 20 mm nominal size). ",1.3384216263835592E-3,"Cum",{"$f":"[1]Measurement!H75","v":1},4610.3999999999996,4610.3999999999996,0,0]
[13,"5.9.1/98","Centering and shuttering including strutting, propping etc. and removal of form for all heights : Foundations, footings, bases of columns, etc. for mass concrete ",1.6061407882460698E-3,"Sqm",{"$f":"[1]Measurement!H83","v":30},184.42,5532.5999999999995,0,0]
[14,"5.9.3/99","Centering and shuttering including strutting, propping etc. and removal of form for all heights :  Suspended floors, roofs, landings, balconies and access platform ",3.635894459803542E-4,"Sqm",{"$f":"[1]Measurement!H90","v":3},417.48,{"$f":"F21*G21","v":1252.44},0,0]
[15,"5.9.5/98","Centering and shuttering including strutting, propping etc. and removal of form for all heights :  Lintels, beams, plinth beams, girders, bressumers and cantilevers",9.6735392665176488E-4,"Sqm",{"$f":"[1]Measurement!H97","v":10},333.22,3332.2000000000003,0,0]
[16,"5.22.6/100","Steel reinforcement for R.C.C. work including straightening, cutting, bending, placing in position and binding all complete upto plinth level. Thermo-Mechanically Treated bars of grade Fe-500D or more.",1.6654152389824473E-2,"Kg",{"$f":"[1]Measurement!H101","v":5220},10.99,{"$f":"G23*F23","v":57367.8},0,0]
[17,"6.1.2/111","Brick work with common burnt clay F.P.S. (non modular) bricks of class designation 7.5 in foundation and plinth in: Cement mortar 1:6 (1 cement : 6 coarse sand)",1.5920673881931847E-2,"Cum",{"$f":"[1]Measurement!H107","v":14},3917.23,54841.22,0,0]
[18,"6.4.2/111","Brick work with common burnt clay F.P.S. (non modular) bricks of class designation 7.5 in superstructure above plinth level up to floor V level in all shapes and sizes in : Cement mortar 1:6 (1 cement : 6 coarse sand)",9.6494265430473597E-3,"Cum",{"$f":"[1]Measurement!H113","v":7},4748.42,33238.94,0,0]
[19,"7.1.1/119","Random rubble masonry with hard stone in foundation and plinth including levelling up with cement concrete 1:6:12 (1 cement : 6 coarse sand : 12 graded stone aggregate 20 mm nominal size) upto plinth level with :  Cement mortar 1:6 (1 cement : 6 coarse sand) ",9.6807388275826987E-4,"Cum",{"$f":"[1]Measurement!H118","v":1},3334.68,3334.68,0,0]
[20,"9.21.1/148","Providing and fixing ISI marked flush door shutters conforming to IS : 2202 (Part I) non-decorative type, core of block board construction with frame of 1st class hard wood and well matched commercial 3 ply\nveneering with vertical grains or cross bands and face veneers on both faces of shutters: 35 mm thick including ISI marked Stainless Steel butt hinges with necessary screws",1.1823885585914729E-3,"Sqm",{"$f":"[1]Measurement!H123","v":3},1357.64,4072.92,0,0]
[21,"10.2/182","Structural steel work riveted, bolted or welded in built up sections, trusses and framed work, including cutting, hoisting, fixing in position and applying a priming coat of approved steel primer all complete.",6.3709148108543809E-4,"Kg",{"$f":"[1]Measurement!H129","v":108},20.32,2194.56,0,0]
[22,"11.3.1/191","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 with 20 mm nominal size stone aggregate. \n",1.6089277151099604E-3,"sqm",{"$f":"[1]Measurement!H134","v":22.5},246.32,5542.2,0,0]
[23,"11.4/191","52 mm thick cement concrete flooring with concrete hardener topping, under layer 40 mm thick cement concrete 1:2:4 (1 cement : 2 coarse sand : 4 graded stone aggregate 20 mm nominal size) and top layer 12 mm thick cement hardener consisting of mix 1:2 (1 cement hardener mix : 2 graded stone aggregate 6 mm nominal size) by volume, hardening compound mixed @ 2 litre per 50 kg of cement or as per manufacturer's specifications. This includes cost of cement slurry, but excluding the cost of nosing of steps etc. complete. ",1.9306691317899409E-2,"sqm",{"$f":"[1]Measurement!H140","v":169},393.52,66504.87999999999,0,0]
[24,"11.41.2/197","Providing and laying vitrified floor tiles in different sizes (thickness to be specified by the manufacturer) with water absorption less than 0.08% and conforming to IS: 15622, of approved make, in all colours and shades, laid on 20mm thick cement mortar 1:4 (1 cement : 4 coarse sand), jointing with grey cement slurry @ 3.3kg/sqm including grouting the joints with white cement and matching pigments etc., complete.\n Size of Tile 500x500 mm",1.288786458937664E-2,"Sqm",{"$f":"[1]Measurement!H145","v":48},924.88,44394.239999999998,0,0]
[25,"13.1.2/227","12 mm cement plaster of mix :  1:6 (1 cement: 6 fine sand) ",4.6416847527864678E-3,"Sqm",{"$f":"[1]Measurement!H153","v":118},135.5,15989,0,0]
[26,"13.2.2/227","15 mm cement plaster on the rough side of single or half brick wall of mix :  1:6 (1 cement: 6 fine sand) ",2.166974983018296E-3,"Sqm",{"$f":"[1]Measurement!H157","v":48},155.51,7464.48,0,0]
[27,"13.26/229","Providing and applying plaster of paris putty of 2 mm thickness over plastered surface to prepare the surface even and smooth complete.",1.5906803114686358E-2,"Sqm",{"$f":"[1]Measurement!H163","v":468},117.08,54793.440000000002,0,0]
[28,"13.41.1/230","Distempering with oil bound washable distemper of approved brand and manufacture to give an even shade  New  work  (two  or  more  coats)  over  and  including  priming coat with cement primer. ",6.2367765372367372E-3,"Sqm",{"$f":"[1]Measurement!H167","v":234},91.81,21483.54,0,0]
[29,"13.44.1/230","Finishing walls with water proofing cement paint of required shade : New w ork (Two or more coats applied @ 3.84 kg/10 sqm).",3.8184207510954904E-3,"Sqm",{"$f":"[1]Measurement!H171","v":234},56.21,13153.14,0,0]
[30,{"$f":"[1]Measurement!B173","v":"13.62.1/233"},"Painting with synthetic enamel paint of approved brand and manufacture of requird colour to give an even shade two or more coats on new work over an under  coat of suitable shade with ordinary paint of approved brand and manufacture. ",6.7759156675930993E-2,"Sqm",{"$f":"[1]Measurement!H179","v":2168},107.66,233406.88,0,0]
[31,"15.2.1/253","Demolishing cement concrete manually/ by mechanical means including disposal of material within 50 metres lead as per direction of Engineer - in - charge.\nNominal concrete 1:3:6 or richer mix (i/c equivalent design mix)",1.1577939290176365E-3,"Cum",{"$f":"[1]Measurement!H185","v":4},997.05,3988.2,0,0]
[32,"15.3/253","Demolishing R.C.C. work manually/ by mechanical means including stacking of steel bars and disposal of unserviceable material within 50 metres lead as per direction of Engineer - in- charge.",3.4625563180159837E-2,"Cum",{"$f":"[1]Measurement!H191","v":82},1454.55,119273.09999999999,0,0]
[33,"15.7.4/253","Demolishing brick work manually/ by mechanical means including stacking of serviceable material and disposal of unserviceable material within 50 metres lead as per direction of Engineer-in-charge. In cement mortar",2.9358532681799704E-3,"Cum",{"$f":"[1]Measurement!H196","v":12},842.75,10113,0,0]
[34,"15.9.2/253","Demolishing stone rubble masonry manually/ by mechanical means including stacking of serviceable material and disposal of unserviceable material within 50 metres lead as per direction of Engineer-in-charge :  In cement mortar \n",2.6276365753265469E-3,"Cum",{"$f":"[1]Measurement!H202","v":9},1005.7,9051.3000000000011,0,0]
[35,"15.19/255","Dismantling steel work manually/ by mechanical means in built up sections without dismembering and stacking within 50 metres lead as per direction of Engineer-in-charge.",2.068828708628275E-3,"Kg",{"$f":"[1]Measurement!H208","v":4454},1.6,7126.4000000000005,0,0]
[36,"15.28.1/255","Dismantling roofing including ridges, hips, valleys and gutters etc., and stacking the material within 50 metres lead of: G.S. sheet",1.2210223322421592E-4,"Sqm",{"$f":"[1]Measurement!H213","v":6},70.099999999999994,420.59999999999997,0,0]
[37,"15.28.2/255","Dismantling roofing including ridges, hips, valleys and gutters etc., and stacking the material within 50 metres lead of: Asbestos sheet",1.4167447222346306E-2,"Sqm",{"$f":"[1]Measurement!H217","v":1485.6},32.85,48801.96,0,0]
[38,"21.1.2.1/374","Providing and fixing aluminium work for doors, windows, ventilators and partitions with extruded built up standard tubular sections/ appropriate Z sections and other sections of approved make conforming to IS: 733 and IS: 1285, fixing with dash fasteners of required dia and size, including necessary filling up the gaps at\njunctions, i.e. at top, bottom and sides with required EPDM rubber/ neoprene gasket etc. Aluminium sections shall be smooth, rust free, straight, mitred and jointed mechanically wherever required including cleat angle, Aluminium snap beading for glazing / paneling, C.P. brass / stainless steel screws, all complete as per architectural drawings and the directions of Engineer-in-charge. (Glazing, paneling\nand dash fasteners to be paid for separately)For shutters of doors, windows & ventilators including\nproviding and fixing hinges/ pivots and making provision\nfor fixing of fittings wherever required including the cost\nof EPDM rubber / neoprene gasket required (Fittings\nshall be paid for separately)  Anodised aluminium (anodised transparent or dyed to required shade according to IS: 1868, Minimum anodic coating of gradeAC 15)",7.2258975239150158E-3,"Kg",{"$f":"[1]Measurement!H223","v":68},366.04,24890.720000000001,0,0]
[39,21.17,"Providing and fixing anodised aluminium grill (anodised transparent or dyed to required shade according to IS: 1868 with minimum anodic coating of grade AC 15) of approved design/pattern, with approved standard section and fixed to the existing window frame with C.P. brass/ stainless steel screws @ 200 mm centre to centre, including cutting the grill to proper opening size for fixing and operation of handles and fixing approved anodised aluminium standard section around the opening, all complete as per requirement and direction of Engineer-in-charge. (Only weight of grill to be measured for payment). ",5.1582822896920598E-4,"Kg",{"$f":"[1]Measurement!H228","v":5},355.37,1776.85,0,0]
[40,"DSR-16","Items covered in DSR-2016 but not covered above ",{"$f":"(H47*0.55*1.05)/1989287.94","v":8.709146449658766E-3},"DSR-2016",30000,1,30000,0,0]
[null,null,"Sub Total (A)",{"$f":"SUM(D8:D47)","v":0.39555911721105608},null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Rs ",{"$f":"SUM(H8:H47)","v":1362564.4700000004}]
[]
["Part( B ) Non -DSR items  "]
["S No ",null,"DESCRIPTION OF ITEM","% Allocation (Item-wise)","Unit ","Quantity ","Analysed rate of DSR-2016","Amount ","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[41,"NS 1","Supply and installation of coated galvalume steel sheet of approved colour (Maximum height up to 30.0 m) having maximum of pitch of 205 mm c/c and minimum 28 mm crest depth in length for roofing / side cladding as per site requirement. The supplied material is to be manufactured out of 0.50 mm TCT (Total coated thickness) and 550 MPA tensile strength, with zinc aluminium alloy of AZ-150 (As per AS-1397:1993). The sheet shall have a hot dip metalic zinc aluminium alloy coating of zinc (43%), silicon (1.5%) and aluminium (55%) with total mass coating of 150 gms/sqm considering both sides together , self drilling/self tapping screws with EPDM seal fixed to the existing MS purlins/MS runners complete as per drawing and as directed by engineer-in-charge. ",{"$f":"(H54*1.05)/1989287.94","v":0.38986732026335014},"Sqm",{"$f":"[1]Measurement!H243","v":1442},512.22400000000005,{"$f":"G54*F54","v":738627.00800000003},{"$f":"ROUND(J54/F54,2)","v":0},{"$f":"D54*$J$61","v":0}]
[42,"NS-2","Supply & fixing of flashings, ridges, cappings, corner pieces etc. made of 0.5mm TCT galvalume sheet in required shape and size having a  yield strength of 550 Mpa (with 150gsm/sqm minimum coating mass total of both side as per AZ 150), SMP colour coating provided on exposed  face with 20 microns  thick  finish and inner face provided with back-coat pre-coating of 5-7 microns & fixed with stitching screw complete.",{"$f":"(H55*1.05)/1989287.94","v":2.6496166135707835E-2},"Metre",{"$f":"[1]Measurement!H252","v":175},286.84899999999999,{"$f":"G55*F55","v":50198.574999999997},{"$f":"ROUND(J55/F55,2)","v":0},0]
[43,"NS-3","Providing and fixing fire retardant and  U.V. resistant profiled and solid transparent embossed polycarbonate sheet of minimum 3 mm thick with profile to match with that of adjacent galvalume sheets on roof with self drilling/self stitching fasteners with EPDM seal for transmission of light, fixing of the sheet to the existing support system underneath as per the standard practice complete and as directed by engineer-in-charge.The soild  transparent polycarbonate sheet shall be free from scratches and other surface damage and it shall be UV treated and tested as per relevant ASTM or DIN or AS etc.as the case may be.",4.0373069370741775E-2,"Sqm",{"$f":"[1]Measurement!H257","v":45},1699.76,{"$f":"G56*F56","v":76489.2},{"$f":"ROUND(J56/F56,2)","v":0},0]
[44,"Ns-4","Fabrication and erection of structural steel works at all heights(Maximum height up to 30.0 m) consisting of, railing, clamps, purlins with channels & angles,  M.S. flat, M.S. tubes, supports including all connections as per detailed drawings connected steel works etc. cleats, gusset plates all bolts, nuts, washers ,base plates, anchor bolts etc., as per detailed drawings cutting welding and painting 1 coats of red oxide primer before erection & 2 coats of synthetic enamel paint/Aluminium paint of approved brand & colour after erection complete. Advani made electrodes or other approved make electrodes are to be used. All bolts, nuts, washers, gas, electrodes are in contractor's scope. Fabrication to be done as per I.S. codes of latest revision. (All the materials are in contractor scope except the Structural steel. Structural steel shall be provided by BHEL free of cost.) (Make of paint and primer shall be Asian, Berger, Narolac and Shalimar)\n"]
[null,"(a)","Only fabrication",5.9102431898320366E-2,"Kg",{"$f":"[1]Measurement!H277","v":19610},5.71,{"$f":"G58*F58","v":111973.1},0,0]
[null,"(b)","Only erection",8.8601894404487277E-2,"Kg",{"$f":"[1]Measurement!H279","v":19610},8.56,{"$f":"G59*F59","v":167861.6},0,0]
[null,null,"Total(B)",{"$f":"SUM(D54:D59)","v":0.60444088207260738},null,null,null,null,null,{"$f":"D60*$J$61","v":0}]
[null,null,"Grand Total C=(A+B)",{"$f":"D48+D60","v":0.99999999928366345},null,null,null,null,null,0]
[null,null,"In words ",null,{"$f":"Rup(J61)","v":0}]
[]
["GST Shall be paid Extra As applicable. "]
[]
["1. Bidder has to quote in above unlocked cell only. Item rate shall be calculated automatically. Calculated item rates  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."]
["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"]
["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"]