{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Price bid "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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 ","index":0,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[5,1,5,9],[4,1,4,7],[3,0,3,9],[2,0,2,9],[35,1,35,9],[28,1,28,2],[29,1,29,2],[23,0,23,7],[30,0,30,2],[30,3,30,9],[33,1,33,9],[34,1,34,9]]}
["BHARAT HEAVY ELECTRICALS LIMITED, JHANSI"]
["FACTORY CIVIL  DEPARTMENT"]
["Price bid "]
["Name of work - Renovation & modification in water supply system at ADM building. "]
[]
[null,"Part (A) DSR  items "]
["Sl. No.","DSR 2016 ","Description of Work","% allocation ","Unit ","Quantity ","Analysed rate of DSR-2016","Amount (RS)","Rate ","Amount (Rs)"]
[1,"15.44.1/257","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 ",{"$f":"H8/239619.2","v":5.3125959856305333E-2},"Mtr ",200,63.65,{"$f":"F8*G8","v":12730},{"$f":"ROUND(J8/F8,2)","v":0},{"$f":"$J$30*D8","v":0}]
[2,"17.1.1/292","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",{"$f":"H9/239619.2","v":2.6367252707629438E-2},"Nos",2,3159.05,{"$f":"F9*G9","v":6318.1},{"$f":"ROUND(J9/F9,2)","v":0},{"$f":"$J$30*D9","v":0}]
[3,"17.4.1/292","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 :  One urinal basin with 5 litre white P.V.C. automatic flushing ",4.0589026254991251E-2,"each ",3,3241.97,{"$f":"F10*G10","v":9725.91},0,0]
[4,"17.4.2/292","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.",8.2682022141798317E-2,"each ",4,4953.05,19812.2,0,0]
[5,"17.7.2/293","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",3.7800601955102091E-2,"Nos",5,1811.55,9057.75,0,0]
[6,"17.8/294","Providing and fixing white vitreous china pedestal for wash basin completely recessed at the back for the reception of pipes and fittings.",1.7525724148983051E-2,"Nos",5,839.9,4199.5,0,0]
[7,"17.16A","Providing and fixing 8 mm dia C.P. / S.S. Jet with flexible tube upto 1 metre long with S.S. triangular plate to Eureopean type W.C. of quality and make as approved by Engineer - in - charge",3.6641471134199596E-3,"each ",4,219.5,878,0,0]
[8,"17.28.1.","Providing and fixing P.V.C. waste  Semi rigid pipe for sink or wash basin including P.V.C. waste fittings complete.",1.0976791509194589E-2,"each ",35,75.150000000000006,{"$f":"F15*G15","v":2630.25},0,0]
[9,"17.29/297","Providing and fixing 100 mm sand cast Iron grating for gully trap.",2.1742831960043269E-3,"each ",20,26.05,521,0,0]
[10,"17.31/297","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.",3.1531279630346819E-2,"each ",10,755.55,7555.5,0,0]
[11,"18.7.2/325","Providing and fixing Chlorinated Polyvinyl Chloride (CPVC) pipes, having  thermal stability for hot & cold water supply, including all CPVC plain & brass threaded fittings, including fixing the pipe with clamps at 1.00 m spacing. This includes jointing of pipes & fittings with one step CPVC solvent cement and testing of joints complete as per direction of Engineer in Charge\n20 mm nominal outer dia Pipes ",0.1393043629225037,"Mtr ",200,166.9,33380,0,0]
[12,"18.7.3/326","Providing and fixing Chlorinated Polyvinyl Chloride (CPVC) pipes, having thermal stability for hot & cold water supply, including all CPVC plain & brass threaded fittings, including fixing the pipe with clamps at 1.00 m spacing. This includes jointing of pipes & fittings with one step CPVC solvent cement and testing of joints complete as per direction of Engineer in Charge. The work is to be carried out on exposed face of the Admin building upto 3rd Floor (25 mm nominal outer dia Pipes)",8.246417649336947E-2,"Nos.",100,197.6,19760,{"$f":"ROUND(J19/F19,2)","v":0},0]
[13,"18.52.1/334","Providing and fixing C.P. brass stop cock 15 mm nominal (concealed) of standard design and of approved make onforming to IS:8931. ",5.8305010616845392E-2,"each ",30,465.7,13971,0,0]
[14,"DSR ref ","Any other items covered in DSR-2016 but not covered in  above Items ",8.3465765681548051E-2,"DSR-2016",20000,1,20000,0,0]
[null,null,"Total A",{"$f":"SUM(D8:D21)","v":0.66997640422804172},null,null,null,{"$f":"SUM(H8:H21)","v":160539.21},null,0]
[]
["Part (B) NON DSR  items "]
[]
[15,"NS-1","Providing and fixing pressmatic brass pillar cock with aerator, chrome plated suitable for wash basin mounting. Material should be approved with Engineer-in-charge before installation. The minimum weight of the pillar cock shall be 500 gm. The material should be ISI marked. ",{"$f":"H26/239619.2","v":0.13563186923251558},"each ",25,{"$f":"[1]CST!H7","v":1300},{"$f":"F26*G26","v":32500},{"$f":"J26/F26","v":0},0]
[16,"NS-2","Providing and fixing pressmatic brass push cock  with aerator and wall flange, chrome plated suitable for wall mounting in drinking place and inside toilets. Material should be approved with Engineer-in-charge before installation. The minimum weight of the pillar cock shall be 400 gm. The material should be ISI marked. \n",0.1752781079312509,"each ",35,{"$f":"[1]CST!H8","v":1200},{"$f":"F27*G27","v":42000},0,0]
[17,"NS3","Providing and fixing white vitreous china flat back or wall   corner type lipped front urinal basin of 340x410x265 mm size without  automatic flushing cistern with brass unions, G.I clamps and all other necessary fittings complete, including painting of fittings and brackets, cutting and making good the walls and floors wherever required. This item is required to replace the existing damaged urinal basins thus the installed item should match with existing urinals to the best possible extent.",1.9113660341074503E-2,"each ",4,{"$f":"[1]CST!H9","v":1145},{"$f":"F28*G28","v":4580},0,0]
[null,"Total(B)",null,{"$f":"SUM(D26:D28)","v":0.33002363750484093},null,null,null,{"$f":"SUM(H26:H28)","v":79080},null,{"$f":"$J$30*D29","v":0}]
[null,"Total C=(A+B)",null,{"$f":"D22+D29","v":1.0000000417328827},null,null,null,{"$f":"H22+H29","v":239619.21},null,0]
["In words ",null,null,{"$f":"rup(J30)","v":0}]
[null,"Note -GST extra as applicable"]
[]
[null,"1. Bidder has to quote in above unlocked cell (J-30) only. Item rate shall be calculated automatically. Calculated item rates upto two 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,"(Signature and Seal of  Contractor  )"]