{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Price Bid 07"],"not_rendered":{"charts":0,"images":1,"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 07","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,1,33,9],[4,0,4,9],[5,0,5,9],[24,0,24,9],[23,0,23,7],[30,0,30,2],[30,3,30,9],[3,0,3,9],[2,0,2,9],[1,0,1,9],[0,0,0,9],[32,1,32,9]]}
["BHARAT HEAVY ELECTRICAL LIMITED, JHANSI"]
["FACTORY CIVIL DEPARTMENT"]
["Price bid "]
["Name of Work : Repair and modification of aluminium work inside factory Area."]
["Tende No- FCX/TW/24/07"]
["Part A -DSR items "]
["Sl.no.","Ref. No.","Descripition of work","% Allocation (Item-wise)","Unit","Qty.","Rate","Amount (Rs.)","Rate per Unit (in Rs.)","Amount (in Rs.)"]
[1,"9.95.1/158","Providing and fixing ISI marked aluminium butt hinges anodised (anodic coating not less than grade AC 10 as per IS: 1868) transparent or dyed to required colour or shade with necessary screws etc. complete: 125x75x4 mm",{"$f":"H8*0.9901/1409209.82","v":3.1519977798621919E-3},"Each",44,101.96,{"$f":"F8*G8","v":4486.24},{"$f":"ROUNDUP(J8/F8,4)","v":0},{"$f":"$J$30*D8","v":0}]
[2,"9.96.1/158","Providing and fixing aluminium sliding door bolts, ISI marked anodised (anodic coating not less than grade AC 10 as per IS : 1868), transparent or dyed to required colour or shade, with nuts and screws etc. complete : 300x16 mm",{"$f":"H9*0.9901/1409209.82","v":2.0722538989970986E-3},"Each",16,184.34,{"$f":"F9*G9","v":2949.44},{"$f":"ROUNDUP(J9/F9,4)","v":0},0]
[3,"9.97.3/158","Providing and fixing aluminium tower bolts, ISI marked, anodised (anodic coating not less than grade AC 10 as per IS : 1868 ) transparent or dyed to required colour or shade, with necessary screws etc. complete : 200x10 mm",1.8450074382819726E-3,"Each",40,65.650000000000006,2626,0,0]
[4,"9.101.1/159","Providing and fixing aluminium hanging floor door stopper, ISI marked, anodised (anodic coating not less than grade AC 10 as per IS : 1868) transparent or dyed to required colour and shade, with necessary screws etc. complete. Single rubber stopper",2.3292340667907063E-4,"Each",14,23.68,331.52,0,0]
[5,"9.113/161","Providing and fixing bright finished 100 mm mortice lock with 6 levers without pair of handles of approved quality for aluminium door, with necessary screws etc complete as per direction of Engineer- in-charge.",5.2239565900839375E-3,"Each",18,413.07,7435.26,0,0]
[6,"12.52.3/218","Providing and fixing tiled false ceiling of specified materials of size 595x595 mm in true horizontal level, suspended on inter locking metal grid of hot dipped galvanized steel sections ( galvanized @ 120 grams/ sqm, both side inclusive) consisting of main \"T\" runner with suitably spaced joints to get required length and of size 24x38 mm made from 0.30 mm thick (minimum) sheet, spaced at 1200 mm center to center and cross \"T\" of size 24x25 mm made of 0.30 mm thick (minimum) sheet, 1200 mm long spaced between main \"T\" at 600 mm center to center to form a grid of 1200x600 mm and secondary cross \"T\" of length 600 mm and size 24x25 mm made of 0.30 mm thick (minimum) sheet to be interlocked at middle of the 1200x600 mm panel to form grids of 600x600 mm and wall angle of size 24x24x0.3 mm ",0.12379817236868246,"sqm",200,881.01,{"$f":"F13*G13","v":176202},0,0]
[7,"21.1.1.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 junctions, 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 and dash fasteners to be paid for separately) : For fixed portion Anodised aluminium (anodised transparent or dyed to required shade according to IS: 1868, Minimum anodic coating of grade AC 15)",0.30693630046094256,"Kg",1377,317.25678166207899,{"$f":"F14*G14","v":436862.5883486828},0,0]
[8,"21.1.2.1/374","Providing and fixing aluminium work For shutters of doors, windows & ventilators including providing and fixing hinges/ pivots and making provision for fixing of fittings wherever required including the cost of EPDM rubber / neoprene gasket required (Fittings shall be paid for separately) Anodised aluminium (anodised transparent or dyed to required shade according to IS:1868, Minimum anodic coating of grade AC 15)",5.9150685538084037E-2,"Kg",230,366.04,84189.200000000012,0,0]
[9,"21.2.2/374","Providing and fixing 12 mm thick prelaminated particle board flat pressed three layer or graded wood particle board conforming to IS:12823 Grade l Type ll, in panelling fixed in aluminum doors, windows shutters and partition frames with C.P. brass / stainless steel screws etc. complete as per architectural drawings and directions of Engineer-in-charge. Pre-laminated particle board with decorative lamination on both sides",0.17241113179242981,"sqm",325,755.05492063492056,245392.84920634917,0,0]
[10,"21.3.1/375","Providing and fixing glazing in aluminium door, window, ventilator shutters and partitions etc. with EPDM rubber / neoprene gasket etc. complete as per the architectural drawings and the directions of Engineer-in-charge . (Cost of aluminium snap beading shall be paid in basic item):With float glass panes of 4.0 mm thickness",9.6314165906110416E-2,"sqm",200,685.42,137084,0,0]
[11,"21.4.1/375","Providing and fixing double action hydraulic floor spring of approved brand and manufacture conforming to IS : 6315, having brand logo embossed on the body / plate with double spring mechanism and door weight upto 125 kg, for doors, including cost of cutting floors,  embedding in floors as required and making good the same matching to the existing floor finishing and cover plates with brass pivot and single piece M.S. sheet outer box with slide plate etc. complete as per the direction of Engineer-in-charge. With stainless steel cover plate minimum 1.25 mm thickness",1.1222078582307919E-2,"Each",9,1774.71,15972.39,0,0]
[12,"21.15.1/377","Providing and fixing aluminium casement windows fastener of required length for aluminium windows with necessary screws etc. complete.  Anodized (AC 15) aluminium",1.1920782223358406E-3,"Each",38,44.649619047619055,1696.6855238095241,0,0]
[13,"21.17/377","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).",3.7452035034782824E-3,"kg",15,355.37,5330.55,0,0]
[14,"7385/38"," Providing 3 mm thick translucent white acrylic plastic sheet ",3.8988253147426967E-2,"Sqm ",100,554.91999999999996,{"$f":"F21*G21","v":55491.999999999993},0,0]
[15,"DSR 2016","Any or all items not covered above but covered in DSR 2016 ",1.4051846445407256E-2,"Basic Value",1,20000,{"$f":"F22*G22","v":20000},0,0]
[null,null,"Sub Total  A1",{"$f":"SUM(D8:D22)","v":0.84033605508110976},null,null,null,{"$f":"SUM(H8:H22)","v":1196050.7230788416},null,{"$f":"SUM(J8:J22)","v":0}]
[]
["Part B -Non DSR items "]
[]
[16,"NS1","Dismantling of existing Aluminum structure in doors, windows, ventilator, partition, cabins, cubicles etc. as per site condition. The work includes dismantling of various Aluminum Sections, removing of Nova Pan Board, glass, neoprene bidding etc. as per site condition and stacking of dismantled material at designated place as per the instruction of Engineer-in-Charge. The work must be carried out with caution and without damaging the dismantled material.",{"$f":"H27/1409209.82","v":5.7479020405917972E-2},"Sqm",300,270,{"$f":"F27*G27","v":81000},{"$f":"ROUNDUP(J27/F27,4)","v":0},{"$f":"D27*$J$30","v":0}]
[17,"NS2","Refixing of old dismantled Aluminum structure in doors, windows, ventilator, partition, cabins, cubicles etc. as per site condition. The work includes assembling of dismantled Aluminum Sections, fixing of Nova Pan Board, glass, neoprene bidding etc. as per site condition and as per the instruction of Engineer-in-Charge. All the material (except screws) shall be provided by BHEL free of cost. Material to be used in this work shall be earlier dismantled material and contractor has to make necessary modifications in the old material for installation as per new requirement.",{"$f":"H28/1409209.82","v":0.1021849251660764},"Sqm",300,480,{"$f":"F28*G28","v":144000},0,{"$f":"D28*$J$30","v":0}]
[null,null,"Sub Total  B",{"$f":"SUM(D27:D28)","v":0.15966394557199437},null,null,null,{"$f":"+H27+H28","v":225000},null,{"$f":"SUM(J27:J28)","v":0}]
[null,null,"Total ( A+ B) = C",{"$f":"D23+D29","v":1.0000000006531042},null,null,null,null,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 (I-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."]
[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,null,null,"(Signature and Seal of  Contractor  )"]