{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Price bid 17"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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 17","index":0,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[34,0,34,9],[31,0,31,7],[19,0,19,2],[21,0,21,9],[5,0,5,9],[32,0,32,8],[33,0,33,9],[28,0,28,2],[29,0,29,2],[20,0,20,9],[30,0,30,2],[30,3,30,9]]}
["BHARAT HEAVY ELECTRICALS LIMITED JHANSI"]
["FACTORY CIVIL DEPARTMENT"]
["Price bid "]
["NAME OF WORK: Civil and allied work for Vande Bharat Project in BHEL Jhansi."]
["Tender Enquiry Number - FCX/TW/24/17 "]
["Part A - DSR Items "]
["Sl. No.","DSR 2021 ","Description of Work","% Allocation (Item-wise)","Unit ","Quantity ","Analysed rate of DSR-2021","Amount (in Rs.)","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[1,"1.1.1","By Mechanical Transport including loading,unloading and stacking: Lime, moorum, building, rubbish (Upto 1 Km)",{"$f":"H8*0.5041/3010739.55","v":2.1575059760411925E-4},"Cum",10,128.85714285714283,{"$f":"F8*G8","v":1288.5714285714284},{"$f":"ROUND(J8/F8,4)","v":0},{"$f":"D8*$J$30","v":0}]
[{"$f":"A8+1","v":2},"1.1.2","Carriage of Earth  up 1 km",{"$f":"H9*0.5041/3010739.55","v":3.1553524899602444E-3},"Cum",117,161.07142857142856,18845.357142857141,{"$f":"ROUND(J9/F9,4)","v":0},0]
[{"$f":"A9+1","v":3},"2.6.1","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:\nAll kinds of soil",4.8220452907492438E-3,"Cum",157,183.43749999999997,28799.687499999996,0,0]
[4,"2.7.1","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.: Ordinary  rock ",4.6300344346220752E-3,"Cum",75,368.70535714285711,27652.901785714283,0,0]
[5,2.25,"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.",4.4038416396491586E-3,"Cum",116,226.74107142857139,26301.964285714283,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) derived from natural sources : 6 graded stone aggregate 40 mm\nnominal size derived from natural sources",7.8492214150743894E-2,"Cum",101,4641.5357142857147,468795.10714285716,0,0]
[7,"5.1.2","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 :\n1:1.5:3 (1 cement : 1.5 coarse sand (zone-III) derived from natural sources : 3 graded stone aggregate 20 mm nominal size de rived from natural sources)",0.2040895409141015,"Cum",240,5078.8571428571422,1218925.7142857141,0,0]
[8,"5.1.3","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:\n1:2:4 (1 cement : 2 coarse sand (zone-III) derived from natural sources : 4 graded stone aggregate 20 mm nominal size derived from natural sources)",5.8143178987428046E-2,"Cum",67,5182.9910714285706,347260.40178571426,0,0]
[9,"5.9.1","Centering and shuttering including strutting, propping etc. and removal of form for:\nFoundations, footings, bases of columns, etc. for mass concrete",1.2844283974834116E-2,"Sqm",279,274.95535714285711,76712.54464285713,0,0]
[10,"5.22.6","Steel reinforcement for R.C.C. work including straightening, cutting, bending, placing in position and binding all complete upto plinth level.\nThermo-Mechanically Treated bars of grade Fe-500D or more.",8.8448536150717988E-2,"Kg",24560,21.508928571428569,528259.28571428568,0,0]
[11,15.3,"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.",{"$f":"H18*0.5041/3010739.55","v":4.3773511976484313E-3},"Cum",10,2614.3749999999995,26143.749999999996,0,0]
[12,"DSR-2021","Covered in DSR-2021 but not covered above ",2.9898918736712761E-3,"DSR -21",20000,0.89285714285714279,17857.142857142855,0,0]
["Sub Total (A)",null,null,{"$f":"SUM(D8:D19)","v":0.46661202170173005},null,null,null,{"$f":"SUM(H8:H19)","v":2786842.4285714282},null,{"$f":"SUM(J8:J19)","v":0}]
[]
["Non - DSR Items "]
["S No ",null,"DESCRIPTION OF ITEM","% Allocation (Item-wise)","Unit ","Quantity ","Analysed rate of DSR-2021","Amount (in Rs.)","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[1,"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":"H24/3010739.55","v":0.18697392140744956},"Sqm",1099,512.22,{"$f":"F24*G24","v":562929.78},{"$f":"ROUND(J24/F24,4)","v":0},{"$f":"D24*$J$30","v":0}]
[2,"NS-2","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.",{"$f":"H25/3010739.55","v":6.437730556932432E-2},"Sqm",110,1762.03,{"$f":"F25*G25","v":193823.3},0,0]
[1,"Ns-3","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 Salimar)\n"]
[null,"(a)","Only fabrication",{"$f":"H27/3010739.55","v":0.1127802635734466},"Kg",51840,6.55,{"$f":"F27*G27","v":339552},{"$f":"ROUND(J27/F27,4)","v":0},0]
[null,"(b)","Only erection",{"$f":"H28/3010739.55","v":0.16925648716442446},"Kg",51840,9.83,{"$f":"F28*G28","v":509587.20000000001},{"$f":"ROUND(J28/F28,4)","v":0},0]
["Sub Total (B)",null,null,{"$f":"SUM(D24:D28)","v":0.53338797771464497},null,null,null,{"$f":"SUM(H24:H28)","v":1605892.28},null,{"$f":"SUM(J24:J28)","v":0}]
["Total C=(A+B)",null,null,{"$f":"D20+D29","v":0.99999999941637507},null,null,null,{"$f":"#REF!+H29","v":{"$error":"#REF!"}}]
["In words ",null,null,{"$f":"rup(J30)","v":0}]
[]
["Note -GST extra as applicable"]
["1. Bidder has to quote in above unlocked cell (J-30) 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."]
["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,null,null,null,null,null,null,null,"(Signature and Seal of  Contractor  )"]