{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Group-A.1","Group-A 2","Group-B.1","Group-B.2"],"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":"Group-A.1","index":0,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[3,0,3,3],[3,4,3,8]]}
["SCHEDULE OF RATE FOR CNG ONLINE COMPRESSOR PACKAGES \nFOR CITY GAS DISTRIBUTION PROJECT AT HYDERABAD GA - GROUP.A     "]
["PROJECT.:  CITY GAS DISTRIBUTION PROJECT OF BHAGYANAGAR GAS LTD. "]
["Bid Document No:  "]
["Name of Bidder:"]
["(This BOQ template must not be modified/replaced by the bidder and the same should be uploaded after filling the relevant columns, else the bidder is liable to be rejected for this tender. Bidders are allowed to enter the Bidder Name and Values only )"]
["S.No.","Item Description","Qty","Units","1. Unit Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes\npaid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable)-For Supply items\n\n2. UNIT RATE INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT EXCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","GST in Percentage\n","Total GST Amount in INR (corresponding to total qty)","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. -For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. [IN WORDS] - For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN WORDS]- For Service items & frieght\n"]
[null,null,null,null,"Amount in INR / No.","%","Amount in INR","Amount in INR","Amount (In Words)"]
["A","B","C","D","E","F","G","H","I"]
["Group-A.1","1200 SCMH Gas Engine Driven Online CNG Compressor Package",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H9)","v":{"$error":"#NAME?"}}]
["Part-1","HYDERABAD",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H10)","v":{"$error":"#NAME?"}}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Gas Engine Driven Reciprocating compressor package with discharge flow capacity of 1200 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16 – 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 9 bank Priority panel along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",2,"Nos.",null,null,{"$f":"C11*E11*F11","v":0},{"$f":"C11*E11+G11","v":0},{"$error":"#NAME?"}]
[{"$f":"A11+1","v":2},"Freight up to store/site at Hyderabad GA. ",2,"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A12+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[4,"LCV Trailer Panels\nLCV trailer panel complete with mass flow meter (with internal local display) based on Coriolis principle of Micro motion, USA (Model CNG 50 with 2700 transmitter) cabling suitable for hazardous area classification. Panel shall be weather proof. Sheet metal work shall be SS 304. LCV trailer panel shall be mounted / installed near LCV stand. Purchaser shall arrange SS316 tubing from compressor to trailer panel and from trailer panel to LCV filling point. Hose & fittings for LCV filling point shall be in bidder’s scope. Hose shall be 5 feet in length along with breakaway coupling & fitting (quick connector coupler & Stem) should have provision of NRV. Dispatch of LCV panels shall be as intimated during dispatch clearance.",2,"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[5,"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[6,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",2,"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[7,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H11+H12+H13+H14+H16","v":0}]
[8,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,null,null,{"$error":"#NAME?"}]
[9,"ITEMS FOR OPERATIONS",null,null,null,null,null,null,{"$error":"#NAME?"}]
[10,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (2 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0075% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"2*3*365","v":2190},"No of Shifts",null,null,{"$f":"C20*E20*F20","v":0},{"$f":"C20*E20+G20","v":0},{"$error":"#NAME?"}]
[11,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (2 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0079% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C20","v":2190},"No of Shifts",null,null,{"$f":"C21*E21*F21","v":0},{"$f":"C21*E21+G21","v":0},{"$error":"#NAME?"}]
[12,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (2 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0082% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C21","v":2190},"No of Shifts",null,null,{"$f":"C22*E22*F22","v":0},{"$f":"C22*E22+G22","v":0},{"$error":"#NAME?"}]
[13,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (2 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0086% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C22","v":2190},"No of Shifts",null,null,{"$f":"C23*E23*F23","v":0},{"$f":"C23*E23+G23","v":0},{"$error":"#NAME?"}]
[14,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (2 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0090% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C23","v":2190},"No of Shifts",null,null,{"$f":"C24*E24*F24","v":0},{"$f":"C24*E24+G24","v":0},{"$error":"#NAME?"}]
[15,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"SUM(H20:H24)","v":0}]
[16,"Total amount for OPERATIONS (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H20*(1+10%)^-1+H21*(1+10%)^-2+H22*(1+10%)^-3+H23*(1+10%)^-4+H24*(1+10%)^-5","v":0}]
[17,"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,null,null,{"$error":"#NAME?"}]
[18,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (2 packages X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"2*12","v":24},"Machine Months",null,null,{"$f":"C28*E28*F28","v":0},{"$f":"C28*E28+G28","v":0},{"$error":"#NAME?"}]
[19,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (2 packages X 12 Months)",null,null,null,null,null,null,{"$error":"#NAME?"}]
[20,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C28","v":24},"Machine Months",null,null,{"$f":"C30*E30*F30","v":0},{"$f":"C30*E30+G30","v":0},{"$error":"#NAME?"}]
[21,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C30","v":24},"Machine Months",null,null,{"$f":"C31*E31*F31","v":0},{"$f":"C31*E31+G31","v":0},{"$error":"#NAME?"}]
[22,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C31","v":24},"Machine Months",null,null,{"$f":"C32*E32*F32","v":0},{"$f":"C32*E32+G32","v":0},{"$error":"#NAME?"}]
[23,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C32","v":24},"Machine Months",null,null,{"$f":"C33*E33*F33","v":0},{"$f":"C33*E33+G33","v":0},{"$error":"#NAME?"}]
[24,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H28+H30+H31+H32+H33","v":0}]
[25,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H28*(1+10%)^-1+H30*(1+10%)^-2+H31*(1+10%)^-3+H32*(1+10%)^-4+H33*(1+10%)^-5","v":0}]
[26,"A. Package Gas Loss:",null,null,null,null,null,null,{"$error":"#NAME?"}]
[27,"The bidder shall design the compressor package so that no venting and leakage of gas takes place. Bidder shall indicate actual vent & leakage losses through the compressor package. If package loss is quoted more than 1% of suction capacity gas consumption than bid shall be rejected. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools and tackles, transportation, erection & commissioning, operations and comprehensive maintenance will be calculated as per following formulas:\nF = G * H * I * N * W Where,\nF = Amount in Rs.\nG = Vent/Leakage rate quoted in percentage\nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nW = 900 kg for 1200 SCMH\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",null,null,null,null,null,null,{"$error":"#NAME?"}]
[28,"Package Gas Loss for 1st year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",2,"Nos.",null,null,null,{"$f":"IF(E38=0,\"0\",E38*52*3650*C38*900)","v":"0"},{"$error":"#NAME?"}]
[29,"Package Gas Loss for 2nd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C38","v":2},"Nos.",null,null,null,{"$f":"IF(E39=0,\"0\",E39*52*3650*C39*900)","v":"0"},{"$error":"#NAME?"}]
[30,"Package Gas Loss for 3rd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C39","v":2},"Nos.",null,null,null,{"$f":"IF(E40=0,\"0\",E40*52*3650*C40*900)","v":"0"},{"$error":"#NAME?"}]
[31,"Package Gas Loss for 4th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C40","v":2},"Nos.",null,null,null,{"$f":"IF(E41=0,\"0\",E41*52*3650*C41*900)","v":"0"},{"$error":"#NAME?"}]
[32,"Package Gas Loss for 5th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C41","v":2},"Nos.",null,null,null,{"$f":"IF(E42=0,\"0\",E42*52*3650*C42*900)","v":"0"},{"$error":"#NAME?"}]
[33,"Total Value of Gas loss based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H38*(1+10%)^-1+H39*(1+10%)^-2+H40*(1+10%)^-3+H41*(1+10%)^-4+H42*(1+10%)^-5","v":0}]
[34,"B. Engine Fuel Consumption:",null,null,null,null,null,null,{"$error":"#NAME?"}]
[35,"The compressor package shall be designed in such a way that Gas Consumption of engine (Kg/Hr) should be minimum for production of CNG.\nBidder shall indicate actual gas consumption for their compressor package. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools & tackles, erection and commissioning will be calculated as per following formulas:\nF = G x H x I x N\nWhere, F = Amount in Rs.\nG = Bidder’s Gas consumption rate quoted in Kg/hr for every 1200 SCMH (900 Kg) of CNG produced \nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nNotes:\n1. Fuel Consumption quoted by the bidder under guaranteed parameters shall lie within the  range of 34 to 36 Kg/hr for 1200 SCMH. No benefit will be given below 34 Kg/hr for 1200 SCMH. In case the fuel consumption quoted by the bidder exceeds the upper limit i.e. 36 Kg/hr for 1200 SCMH the bid will be rejected.\n2. The amount (F) as per the above calculations for 5 years shall be considered on NPV basis with discount factor @10% p.a.\nUnder column 'E', bidder to quote ''Bidder’s Gas consumption rate in Kg/hr for every 1200 SCMH (900 Kg) of CNG produced\".",null,null,null,null,null,{"$f":"E45*52*3650*C45*900","v":0},{"$error":"#NAME?"}]
[36,"Engine Fuel Consumption for 1st year",2,"Nos.",null,null,null,{"$f":"_xlfn.IFS(E46=0,\"0\",E46<35,52*3650*34*C46,E46>34,52*3650*E46*C46)","v":"0"},{"$error":"#NAME?"}]
[37,"Engine Fuel Consumption for 2nd year",{"$f":"C46","v":2},"Nos.",null,null,null,{"$f":"_xlfn.IFS(E47=0,\"0\",E47<35,52*3650*34*C47,E47>34,52*3650*E47*C47)","v":"0"},{"$error":"#NAME?"}]
[38,"Engine Fuel Consumption for 3rd year",{"$f":"C47","v":2},"Nos.",null,null,null,{"$f":"_xlfn.IFS(E48=0,\"0\",E48<35,52*3650*34*C48,E48>34,52*3650*E48*C48)","v":"0"},{"$error":"#NAME?"}]
[39,"Engine Fuel Consumption for 4th year",{"$f":"C48","v":2},"Nos.",null,null,null,{"$f":"_xlfn.IFS(E49=0,\"0\",E49<35,52*3650*34*C49,E49>34,52*3650*E49*C49)","v":"0"},{"$error":"#NAME?"}]
[40,"Engine Fuel Consumption for 5th year",{"$f":"C49","v":2},"Nos.",null,null,null,{"$f":"_xlfn.IFS(E50=0,\"0\",E50<35,52*3650*34*C50,E50>34,52*3650*E50*C50)","v":"0"},{"$error":"#NAME?"}]
[41,"Total IV. Value of Engine Gas consumption based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H46*(1+10%)^-1+H47*(1+10%)^-2+H48*(1+10%)^-3+H49*(1+10%)^-4+H50*(1+10%)^-5","v":0}]
[42,"NOTE :\n1. Inspection shall be carried out by Owner or its authorized consultant/ TPI at bidder’s cost.\n\n2. Inlet piping shall be of class 300# (filter, inlet valve and 3-way valve).\n\n3. Delivery location of the Compressors may change as per requirement and the same shall be intimated to the supplier before dispatch.\n\n4. Maximum limit to quote charges for Repair & Comprehensive Maintenance for 1 Machine Months shall be 1.5% of unit Ex- works price of Sr. No. 1, failing which will be liable for rejection of bid.\n\n5. For SOR Sr. No. 8, Bidder to ensure the minimum wages of Semi-skilled labour/ worker for construction industries per day (in Rupees) of respective state/ Central (whichever is higher).\n\n6. Deployment of Bidder personal/Resources for Operation will be as per the direction of Engineer In Charge/BGL representative/GA in-charge with prior information of minimum one month. In case of installation of 2 nos compressors (for same supplier under difference work orders) at a particular CNG Station/Mother station i.e. in same premises, EIC may ask the supplier/Bidder to deploy one personnel for operations of both compressors and payment will be done of higher SOR Rate of compressor package for one personnel/Resource only.",null,null,null,null,null,null,{"$error":"#NAME?"}]
[43,"Total amount for supply, installation, testing & commissioning, Operations & COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price (without NPV calculation)\n\nNote: The evaluated price as per tender condition i.e. , based on NPV calculations for cost heads (wherever applicable, as per tender) is given at row below (Sl. No. 44)",null,null,null,null,{"$f":"SUM(G11:G33)","v":0},{"$f":"SUM(H11:H33)","v":0},{"$error":"#NAME?"},{"$f":"J17+J26+J35+J43+J51","v":0}]
[{"$f":"A53+1","v":44},"Total in Figures",null,null,null,null,null,{"$f":"SUM(H11:H53)","v":0},{"$error":"#NAME?"}]

{"sheet":"Group-A 2","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[3,0,3,3],[3,4,3,8]]}
["SCHEDULE OF RATE FOR CNG ONLINE COMPRESSOR PACKAGES \nFOR CITY GAS DISTRIBUTION PROJECT AT HYDERABAD GA - GROUP.A     "]
["PROJECT.:  CITY GAS DISTRIBUTION PROJECT OF BHAGYANAGAR GAS LTD. "]
["Bid Document No:  "]
["Name of Bidder:"]
["(This BOQ template must not be modified/replaced by the bidder and the same should be uploaded after filling the relevant columns, else the bidder is liable to be rejected for this tender. Bidders are allowed to enter the Bidder Name and Values only )"]
["S.No.","Item Description","Qty","Units","1. Unit Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes\npaid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable)-For Supply items\n\n2. UNIT RATE INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT EXCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","GST in Percentage\n","Total GST Amount in INR (corresponding to total qty)","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. -For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. [IN WORDS] - For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN WORDS]- For Service items & frieght\n"]
[null,null,null,null,"Amount in INR / No.","%","Amount in INR","Amount in INR","Amount (In Words)"]
["A","B","C","D","E","F","G","H","I"]
["Group-A.2","600 SCMH Gas Engine Driven Online CNG Compressor Package",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H9)","v":{"$error":"#NAME?"}}]
["Part-2","HYDERABAD",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H10)","v":{"$error":"#NAME?"}}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Gas Engine Driven Reciprocating compressor package with discharge flow capacity of 600 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16– 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 7 bank Priority panel along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Air Compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",1,"No.",null,null,{"$f":"C11*E11*F11","v":0},{"$f":"C11*E11+G11","v":0},{"$error":"#NAME?"}]
[{"$f":"A11+1","v":2},"Freight up to store/site at Hyderabad GA. ",1,"No.",null,null,{"$f":"C12*E12*F12","v":0},{"$f":"C12*E12+G12","v":0},{"$error":"#NAME?"}]
[{"$f":"A12+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[4,"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[5,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[6,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H11+J17+H12+H13+H15","v":0}]
[7,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[8,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0081% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"1*3*365","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0085% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C19","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0089% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C20","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0093% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C21","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[13,"Operation charges for 5th year i.e. during Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0097% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C22","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"SUM(H19:H23)","v":0}]
[15,"Total amount for OPERATIONS (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H19*(1+10%)^-1+H20*(1+10%)^-2+H21*(1+10%)^-3+H22*(1+10%)^-4+H23*(1+10%)^-5","v":0}]
[16,"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (1 package X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",12,"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[18,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (1 package X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[19,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C27","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C29","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C30","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C31","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[23,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H27+H29+H30+H31+H32","v":0}]
[24,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H27*(1+10%)^-1+H29*(1+10%)^-2+H30*(1+10%)^-3+H31*(1+10%)^-4+H32*(1+10%)^-5","v":0}]
[25,"A. Package Gas Loss:",null,null,null,null,0,0,{"$error":"#NAME?"}]
[26,"The bidder shall design the compressor package so that no venting and leakage of gas takes place. Bidder shall indicate actual vent & leakage losses through the compressor package. If package loss is quoted more than 1% of suction capacity gas consumption than bid shall be rejected. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools and tackles, transportation, erection & commissioning, operations and comprehensive maintenance will be calculated as per following formulas:\nF = G * H * I * N * W where,\nF = Amount in Rs.\nG = Vent/Leakage rate quoted in percentage\nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nW = 450 kg for 600 SCMH\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[27,"Package Gas Loss for 1st year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",1,"No",null,null,null,{"$f":"IF(E37=0,\"0\",E37*52*3650*C37*450)","v":"0"},{"$error":"#NAME?"}]
[28,"Package Gas Loss for 2nd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C37","v":1},"No",null,null,null,{"$f":"IF(E38=0,\"0\",E38*52*3650*C38*450)","v":"0"},{"$error":"#NAME?"}]
[29,"Package Gas Loss for 3rd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C38","v":1},"No",null,null,null,{"$f":"IF(E39=0,\"0\",E39*52*3650*C39*450)","v":"0"},{"$error":"#NAME?"}]
[30,"Package Gas Loss for 4th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C39","v":1},"No",null,null,null,{"$f":"IF(E40=0,\"0\",E40*52*3650*C40*450)","v":"0"},{"$error":"#NAME?"}]
[31,"Package Gas Loss for 5th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C40","v":1},"No",null,null,null,{"$f":"IF(E41=0,\"0\",E41*52*3650*C41*450)","v":"0"},{"$error":"#NAME?"}]
[{"$f":"A41+1","v":32},"Total Value of Gas loss based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H37*(1+10%)^-1+H38*(1+10%)^-2+H39*(1+10%)^-3+H40*(1+10%)^-4+H41*(1+10%)^-5","v":0}]
[33,"B. Engine Fuel Consumption:",null,null,null,null,null,null,{"$error":"#NAME?"}]
[34,"The compressor package shall be designed in such a way that Gas Consumption of engine (Kg/Hr) should be minimum for production of CNG.\nBidder shall indicate actual gas consumption for their compressor package. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools & tackles, erection and commissioning will be calculated as per following formulas:\nF = G x H x I x N\nWhere, F = amount in Rs.\nG = Bidder’s Gas Consumption Rate quoted in Kg/hr for every 600 SCMH (450 Kg) of CNG produced \nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nNotes:\n1. Fuel Consumption quoted by the bidder under guaranteed parameters shall lie within the  range of 19 to 21 Kg/hr for 600 SCMH. No benefit will be given below 19 Kg/hr for 600 SCMH. In case the fuel consumption quoted by the bidder exceeds the upper limit i.e. 21 Kg/hr for 600 SCMH, the bid will be rejected.\n2. The amount (F) as per the above calculations for 5 years shall be considered on NPV basis with discount factor @10% p.a.\nUnder column 'E', bidder to quote ''Bidder’s Gas consumption rate in Kg/hr for every 600 SCMH (450 Kg) of CNG produced\"",null,null,null,null,null,null,{"$error":"#NAME?"}]
[35,"Engine Fuel Consumption for 1st year",1,"No",null,null,null,{"$f":"_xlfn.IFS(E45=0,\"0\",E45<20,52*3650*19*C45,E45>19,52*3650*E45*C45)","v":"0"},{"$error":"#NAME?"}]
[36,"Engine Fuel Consumption for 2nd year",{"$f":"C45","v":1},"No",null,null,null,{"$f":"_xlfn.IFS(E46=0,\"0\",E46<20,52*3650*19*C46,E46>19,52*3650*E46*C46)","v":"0"},{"$error":"#NAME?"}]
[37,"Engine Fuel Consumption for 3rd year",{"$f":"C46","v":1},"No",null,null,null,{"$f":"_xlfn.IFS(E47=0,\"0\",E47<20,52*3650*19*C47,E47>19,52*3650*E47*C47)","v":"0"},{"$error":"#NAME?"}]
[38,"Engine Fuel Consumption for 4th year",{"$f":"C47","v":1},"No",null,null,null,{"$f":"_xlfn.IFS(E48=0,\"0\",E48<20,52*3650*19*C48,E48>19,52*3650*E48*C48)","v":"0"},{"$error":"#NAME?"}]
[39,"Engine Fuel Consumption for 5th year",{"$f":"C48","v":1},"No",null,null,null,{"$f":"_xlfn.IFS(E49=0,\"0\",E49<20,52*3650*19*C49,E49>19,52*3650*E49*C49)","v":"0"},{"$error":"#NAME?"}]
[{"$f":"A49+1","v":40},"Total IV. Value of Engine Gas consumption based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H45*(1+10%)^-1+H46*(1+10%)^-2+H47*(1+10%)^-3+H48*(1+10%)^-4+H49*(1+10%)^-5","v":0}]
[41,"NOTE :\n1. Inspection shall be carried out by Owner or its authorized consultant/ TPI at bidder's cost.\n\n2. Inlet piping shall be of class 300# (filter, inlet valve and 3-way valve).\n\n3. Delivery location of the Compressors may change as per requirement and the same shall be intimated to the supplier before dispatch.\n\n4. Maximum limit to quote charges for Repair & Comprehensive Maintenance for 1 Machine Months shall be 1.5% of unit Ex- works price of Sr. No. 1, failing which will be liable for rejection of bid.\n\n5. For SOR Sr. No. 7, Bidder to ensure the minimum wages of Semi-skilled labour/ worker for construction industries per day (in Rupees) of respective state/ Central (whichever is higher).\n\n\n6. Deployment of Bidder personal/Resources for Operation will be as per the direction of Engineer In Charge/BGL representative/GA in-charge with prior information of minimum one month. In case of installation of 2 nos compressors (for same supplier under difference work orders) at a particular CNG Station/Mother station i.e. in same premises, EIC may ask the supplier/Bidder to deploy one personnel for operations of both compressors and payment will be done of higher SOR Rate of compressor package for one personnel/Resource only.",null,null,null,null,null,null,{"$error":"#NAME?"}]
[42,"Total amount for supply, installation, testing & commissioning, Operations & COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price (without NPV calculation)\n\nNote: The evaluated price as per tender condition i.e. , based on NPV calculations for cost heads (wherever applicable, as per tender) is given at row below (Sl. No. 43)",null,null,null,null,null,{"$f":"SUM(H10:H32)","v":0},{"$error":"#NAME?"},{"$f":"J16+J50+J42+J34+J25","v":0}]
[43,"Total in Figures",null,null,null,null,null,{"$f":"SUM(H9:H52)","v":0},{"$error":"#NAME?"}]

{"sheet":"Group-B.1","index":2,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[3,0,3,3],[3,4,3,8]]}
["SCHEDULE OF RATE (SOR) FOR CNG ONLINE COMPRESSOR PACKAGES \nFOR CITY GAS DISTRIBUTION PROJECT AT HYDERABAD, VIJAYAWADA & KAKINADA GA - GROUP.B  "]
["PROJECT.:  CITY GAS DISTRIBUTION PROJECT OF BHAGYANAGAR GAS LTD. "]
["Bid Document No:  "]
["Name of Bidder:"]
["(This BOQ template must not be modified/replaced by the bidder and the same should be uploaded after filling the relevant columns, else the bidder is liable to be rejected for this tender. Bidders are allowed to enter the Bidder Name and Values only )"]
["S.No.","Item Description","Qty","Units","1. Unit Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes\npaid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable)-For Supply items\n\n2. UNIT RATE INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT EXCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","GST in Percentage\n","Total GST Amount in INR (corresponding to total qty)","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. -For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. [IN WORDS] - For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN WORDS]- For Service items & frieght\n"]
[null,null,null,null,"Amount in INR / No.","%","Amount in INR","Amount in INR","Amount (In Words)"]
["A","B","C","D","E","F","G","H","I"]
["Group-B.1","1200 SCMH Electric Motor Driven Online CNG Compressor Package",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H9)","v":{"$error":"#NAME?"}}]
["Part-1","HYDERABAD",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H10)","v":{"$error":"#NAME?"}}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Electric Motor Driven Reciprocating compressor package with discharge flow capacity of 1200 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of16 – 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 9 bank Priority panel and 160 KW electric motor along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",5,"Nos.",null,null,{"$f":"C11*E11*F11","v":0},{"$f":"C11*E11+G11","v":0},{"$error":"#NAME?"}]
[{"$f":"A11+1","v":2},"Freight up to store/site at Hyderabad GA. ",{"$f":"C11","v":5},"Nos.",null,null,{"$f":"C12*E12*F12","v":0},{"$f":"C12*E12+G12","v":0},{"$error":"#NAME?"}]
[{"$f":"A12+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",2,"No.",null,null,0,0,{"$error":"#NAME?"}]
[4,"LCV Trailer Panels\nLCV trailer panel complete with mass flow meter (with internal local display) based on Coriolis principle of Micro motion, USA (Model CNG 50 with 2700 transmitter, cabling, suitable for hazardous area classification. Panel shall be weather proof. Sheet metal work shall be SS 304. LCV trailer panel shall be mounted / installed near LCV stand. Purchaser shall arrange SS316 tubing from compressor to trailer panel and from trailer panel to LCV filling point. Hose & fittings for LCV Filling Point shall be in bidder’s scope. Hose shall be 5 feet in length along with breakaway coupling & fitting (quick connector coupler & Stem) should have provision of NRV. Dispatch of LCV panels shall be as intimated during dispatch clearance.",{"$f":"C12","v":5},"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[5,"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[6,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",{"$f":"C14","v":5},"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[7,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H11+H12+H13+H14+H16","v":0}]
[8,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0096% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"5*3*365","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0101% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C20","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0105% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C21","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[13,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0110% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C22","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0115% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C23","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[15,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"SUM(H20:H24)","v":0}]
[null,"Total amount for OPERATIONS based on NPV",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H20*(1+10%)^-1+H21*(1+10%)^-2+H22*(1+10%)^-3+H23*(1+10%)^-4+H24*(1+10%)^-5","v":0}]
[{"$f":"A25+1","v":16},"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (5 packages X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"5*12","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[18,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (5 packages X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[19,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C28","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C30","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C31","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C32","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[23,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H28+H30+H31+H32+H33","v":0}]
[null,"Total amount for COMPREHENSIVE MAINTENANCE based on NPV",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H28*(1+10%)^-1+H30*(1+10%)^-2+H31*(1+10%)^-3+H32*(1+10%)^-4+H33*(1+10%)^-5","v":0}]
["Group-B.1","1200 SCMH Electric Motor Driven Online CNG Compressor Package",null,null,null,null,0,0,{"$error":"#NAME?"}]
["Part-2","KAKINADA",null,null,null,null,0,0,{"$error":"#NAME?"}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Electric Motor Driven Reciprocating compressor package with discharge flow capacity of 1200 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16 – 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 9 bank Priority panel and 160 KW electric motor along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A38+1","v":2},"Freight up to store/site at Kakinada GA. ",{"$f":"C38","v":1},"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A39+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[4,"LCV Trailer Panels\nLCV trailer panel complete with mass flow meter (with internal local display) based on Coriolis principle of Micro motion, USA (Model CNG 50 with 2700 transmitter, cabling, suitable for hazardous area classification. Panel shall be weather proof. Sheet metal work shall be SS 304. LCV trailer panel shall be mounted / installed near LCV stand. Purchaser shall arrange SS316 tubing from compressor to trailer panel and from trailer panel to LCV filling point with hose and fittings. Hose & fittings shall be in bidder’s scope. Hose shall be 5 feet in length along with breakaway coupling & fitting (quick connector coupler & Stem) should have provision of NRV. Dispatch of LCV panels shall be as intimated during dispatch clearance.",{"$f":"C39","v":1},"No.",null,null,0,0,{"$error":"#NAME?"}]
[5,"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[6,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",{"$f":"C41","v":1},"No.",null,null,0,0,{"$error":"#NAME?"}]
[7,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H38+H39+H40+H41+H43","v":0}]
[8,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0068% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"1*3*365","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0071% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C47","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0074% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C48","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[13,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0077% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C49","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0080% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C50","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[15,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"SUM(H47:H51)","v":0}]
[null,"Total amount for OPERATIONS based on NPV",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H47*(1+10%)^-1+H48*(1+10%)^-2+H49*(1+10%)^-3+H50*(1+10%)^-4+H51*(1+10%)^-5","v":0}]
[{"$f":"A52+1","v":16},"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (1 package X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"1*12","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[18,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (1 package X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[19,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C55","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C57","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C58","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C59","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[23,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H55+H57+H58+H59+H60","v":0}]
[1,"Total amount for OPERATIONS (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H55*(1+10%)^-1+H57*(1+10%)^-2+H58*(1+10%)^-3+H59*(1+10%)^-4+H60*(1+10%)^-5","v":0}]
[2,"A. Package Gas Loss:",null,null,null,null,0,0,{"$error":"#NAME?"}]
[3,"The bidder shall design the compressor package so that no venting and leakage of gas takes place. Bidder shall indicate actual vent & leakage losses through the compressor package. If package loss is quoted more than 1% of suction capacity gas consumption than bid shall be rejected. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools and tackles, transportation, erection & commissioning, operations and comprehensive maintenance will be calculated as per following formulas:\nF = G * H * I * N * W Where,\nF = Amount in Rs.\nG = Vent/Leakage rate quoted in percentage\nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours, N = Number of machines\nW = 900 kg for 1200 SCMH\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[4,"Package Gas Loss for 1st year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"1+5","v":6},"No.",null,null,null,{"$f":"IF(E65=0,\"0\",E65*52*3650*C65*900)","v":"0"},{"$error":"#NAME?"}]
[5,"Package Gas Loss for 2nd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C65","v":6},"No.",null,null,null,{"$f":"IF(E66=0,\"0\",E66*52*3650*C66*900)","v":"0"},{"$error":"#NAME?"}]
[6,"Package Gas Loss for 3rd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C66","v":6},"No.",null,null,null,{"$f":"IF(E67=0,\"0\",E67*52*3650*C67*900)","v":"0"},{"$error":"#NAME?"}]
[7,"Package Gas Loss for 4th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C67","v":6},"No.",null,null,null,{"$f":"IF(E68=0,\"0\",E68*52*3650*C68*900)","v":"0"},{"$error":"#NAME?"}]
[8,"Package Gas Loss for 5th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C68","v":6},"No.",null,null,null,{"$f":"IF(E69=0,\"0\",E69*52*3650*C69*900)","v":"0"},{"$error":"#NAME?"}]
[9,"Total Value of Gas loss based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H65*(1+10%)^-1+H66*(1+10%)^-2+H67*(1+10%)^-3+H68*(1+10%)^-4+H69*(1+10%)^-5","v":0}]
[10,"B. Electric Power Consumption:",null,null,null,null,null,null,{"$error":"#NAME?"}]
[11,"The compressor package shall be designed in such a way that Electric Power Consumption of Motor (KW/Hr) should be minimum for production of CNG.\nBidder shall indicate actual electric power consumption for their compressor package. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools & tackles, erection and commissioning will be calculated as per following formulas:\nF = G x H x I x N\nWhere, F = Amount in Rs.\nG = Bidder’s Electric Power Consumption Rate quoted in KW/Hr for every 1200 SCMH (900 Kg) of CNG produced \nH = Cost of Electric Power Consumption per KW/Hr @ Rs. 11/- per KW/Hr\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nNotes:\n1. Electric Power Consumption quoted by the bidder under guaranteed parameters shall lie within the  range of 142 to 146 KW/Hr for 1200 SCMH. No benefit will be given below 142 KW/Hr for 1200 SCMH. In case the fuel consumption quoted by the bidder exceeds the upper limit i.e. 146 KW/Hr for 1200 SCMH, the bid will be rejected.\n2. The amount (F) as per the above calculations for 5 years shall be considered on NPV basis with discount factor @10% p.a.\nUnder column 'E', bidder to quote ''Bidder’s Electric Power Consumption Rate in KW/Hr for every 1200 SCMH (900 Kg) of CNG produced\".",null,null,null,null,null,null,{"$error":"#NAME?"}]
[12,"Electric Power Consumption for 1st year",{"$f":"1+5","v":6},"No.",null,null,null,{"$f":"_xlfn.IFS(E73=0,\"0\",E73<143,11*3650*142*C73,E73>142,11*3650*E73*C73)","v":"0"},{"$error":"#NAME?"}]
[13,"Electric Power Consumption for 2nd year",{"$f":"C73","v":6},"No.",null,null,null,{"$f":"_xlfn.IFS(E74=0,\"0\",E74<143,11*3650*142*C74,E74>142,11*3650*E74*C74)","v":"0"},{"$f":"ConvertCurrencyToEnglish(H74)","v":{"$error":"#NAME?"}}]
[14,"Electric Power Consumption for 3rd year",{"$f":"C74","v":6},"No.",null,null,null,{"$f":"_xlfn.IFS(E75=0,\"0\",E75<143,11*3650*142*C75,E75>142,11*3650*E75*C75)","v":"0"},{"$error":"#NAME?"}]
[15,"Electric Power Consumption for 4th year",{"$f":"C75","v":6},"No.",null,null,null,{"$f":"_xlfn.IFS(E76=0,\"0\",E76<143,11*3650*142*C76,E76>142,11*3650*E76*C76)","v":"0"},{"$error":"#NAME?"}]
[16,"Electric Power Consumption for 5th year",{"$f":"C76","v":6},"No.",null,null,null,{"$f":"_xlfn.IFS(E77=0,\"0\",E77<143,11*3650*142*C77,E77>142,11*3650*E77*C77)","v":"0"},{"$error":"#NAME?"}]
[17,"Total IV. Value of Engine Gas consumption based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H73*(1+10%)^-1+H74*(1+10%)^-2+H75*(1+10%)^-3+H76*(1+10%)^-4+H77*(1+10%)^-5","v":0}]
[18,"NOTE :\n1. Inspection shall be carried out by Owner or its authorized consultant/ TPI at bidder’s cost.\n\n2. Inlet piping shall be of class 300# (filter, inlet valve and 3-way valve).\n\n3. Delivery location of the Compressors may change as per requirement and the same shall be intimated to the supplier before dispatch.\n\n4. Maximum limit to quote charges for Repair & Comprehensive Maintenance for 1 Machine Months shall be 1.5% of unit Ex- works price of Sr. No. 1, failing which will be liable for rejection of bid.\n\n5. For SOR Sr. No. 8, Bidder to ensure the minimum wages of Semi-skilled labour/ worker for construction industries per day (in Rupees) of respective state/ Central (whichever is higher).\n\n\n6. Deployment of Bidder personal/Resources for Operation will be as per the direction of Engineer In Charge/BGL representative/GA in-charge with prior information of minimum one month. In case of installation of 2 nos compressors (for same supplier under difference work orders) at a particular CNG Station/Mother station i.e. in same premises, EIC may ask the supplier/Bidder to deploy one personnel for operations of both compressors and payment will be done of higher SOR Rate of compressor package for one personnel/Resource only.",null,null,null,null,null,null,{"$error":"#NAME?"}]
[19,"Total amount for supply, installation, testing & commissioning, Operations & COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price (without NPV calculation)\n\nNote: The evaluated price as per tender condition i.e. , based on NPV calculations for cost heads (wherever applicable, as per tender) is given at row below (Sl. No. 20)",null,null,null,null,null,{"$f":"SUM(H11:H60)","v":0},{"$error":"#NAME?"},{"$f":"J17+J26+J35+J44+J53+J62+J70+J78","v":0}]
[20,"Total in Figures",null,null,null,null,null,{"$f":"SUM(H9:H80)","v":0},{"$error":"#NAME?"}]

{"sheet":"Group-B.2","index":3,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[4,0,4,8],[3,0,3,3],[3,4,3,8]]}
["SCHEDULE OF RATE (SOR) FOR CNG ONLINE COMPRESSOR PACKAGES \nFOR CITY GAS DISTRIBUTION PROJECT AT HYDERABAD, VIJAYAWADA & KAKINADA GA - GROUP.B  "]
["PROJECT.:  CITY GAS DISTRIBUTION PROJECT OF BHAGYANAGAR GAS LTD. "]
["Bid Document No:  "]
["Name of Bidder:"]
["(This BOQ template must not be modified/replaced by the bidder and the same should be uploaded after filling the relevant columns, else the bidder is liable to be rejected for this tender. Bidders are allowed to enter the Bidder Name and Values only )"]
["S.No.","Item Description","Qty","Units","1. Unit Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes\npaid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable)-For Supply items\n\n2. UNIT RATE INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT EXCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","GST in Percentage\n","Total GST Amount in INR (corresponding to total qty)","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. -For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN FIGURES]-\nFor Service items & frieght\n","1. Total Price including packing & forwarding charges and freight charges (such price to include all costs as well as duties and taxes paid or payable on components and raw materials incorporated or to be incorporated in the goods) including cost of Inspection by Third Party Agency, mandatory spares etc. (wherever applicable) including applicable GST. [IN WORDS] - For Supply items\n\n2. TOTAL AMOUNT INCLUSIVE OF ALL TAXES, DUTIES, LEVIES, ETC. BUT INCLUDING GST AS DEFINED IN BID DOCUMENT [IN WORDS]- For Service items & frieght\n"]
[null,null,null,null,"Amount in INR / No.","%","Amount in INR","Amount in INR","Amount (In Words)"]
["A","B","C","D","E","F","G","H","I"]
["Group-B.2","600 SCMH Electric Motor Driven Online CNG Compressor Package",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H9)","v":{"$error":"#NAME?"}}]
["Part-3","HYDERABAD",null,null,null,null,null,null,{"$f":"ConvertCurrencyToEnglish(H10)","v":{"$error":"#NAME?"}}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Electric Motor Driven Reciprocating compressor package with discharge flow capacity of 600 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16 – 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 7 bank Priority panel and 90 KW electric motor along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",5,"Nos.",null,null,{"$f":"C11*E11*F11","v":0},{"$f":"C11*E11+G11","v":0},{"$error":"#NAME?"}]
[{"$f":"A11+1","v":2},"Freight up to store/site at Hyderabad GA. ",{"$f":"C11","v":5},"Nos.",null,null,{"$f":"C12*E12*F12","v":0},{"$f":"C12*E12+G12","v":0},{"$error":"#NAME?"}]
[{"$f":"A12+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",2,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A13+1","v":4},"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[5,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",5,"Nos.",null,null,0,0,{"$error":"#NAME?"}]
[6,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H11+H12+H13+H15","v":0}]
[7,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[8,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0106% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"5*3*365","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0111% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C19","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0116% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C20","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0121% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C21","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[13,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (5 packages X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0126% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C22","v":5475},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"SUM(H19:H23)","v":0}]
[null,"Total amount for OPERATIONS based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H19*(1+10%)^-1+H20*(1+10%)^-2+H21*(1+10%)^-3+H22*(1+10%)^-4+H23*(1+10%)^-5","v":0}]
[{"$f":"A24+1","v":15},"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[16,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (5 packages X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"5*12","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (5 packages X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[18,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C27","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[19,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C29","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C30","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C31","v":60},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H27+H29+H30+H31+H32","v":0}]
[null,"Total amount for COMPREHENSIVE MAINTENANCE based on NPV Calculation",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H27*(1+10%)^-1+H29*(1+10%)^-2+H30*(1+10%)^-3+H31*(1+10%)^-4+H32*(1+10%)^-5","v":0}]
["Group-B.2","600 SCMH Electric Motor Driven Online CNG Compressor Package",null,null,null,null,0,0,{"$error":"#NAME?"}]
["Part-4","VIJAYAWADA",null,null,null,null,0,0,{"$error":"#NAME?"}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Electric Motor Driven Reciprocating compressor package with discharge flow capacity of 600 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16 – 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 7 bank Priority panel and 90 KW electric motor along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A37+1","v":2},"Freight up to store/site at Vijayawada  GA. ",{"$f":"C37","v":1},"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A38+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A39+1","v":4},"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[5,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[6,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H37+H38+H39+H41","v":0}]
[7,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[8,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0090% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"1*3*365","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0095% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C45","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0099% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C46","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0104% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C47","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[13,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0109% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C48","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"SUM(H45:H49)","v":0}]
[null,"Total amount for OPERATIONS based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H45*(1+10%)^-1+H46*(1+10%)^-2+H47*(1+10%)^-3+H48*(1+10%)^-4+H49*(1+10%)^-5","v":0}]
[{"$f":"A50+1","v":15},"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[16,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (1 package X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"1*12","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (1 package X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[18,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C53","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[19,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C55","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C56","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C57","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H53+H55+H56+H57+H58","v":0}]
[null,"Total amount for COMPREHENSIVE MAINTENANCE based on NPV Calculation",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H53*(1+10%)^-1+H55*(1+10%)^-2+H56*(1+10%)^-3+H57*(1+10%)^-4+H58*(1+10%)^-5","v":0}]
["Group-B.2","600 SCMH Electric Motor Driven Online CNG Compressor Package",null,null,null,null,0,0,{"$error":"#NAME?"}]
["Part-5","KAKINADA",null,null,null,null,0,0,{"$error":"#NAME?"}]
[1,"Design, Engineering, Manufacturing, String test, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of Skid mounted Electric Motor Driven Reciprocating compressor package with discharge flow capacity of 600 SCMH at the specified conditions (as per technical specification and scope of work) with explosion proof electric & control panel complete with power, control cable & 05 nos. of ESDs having suction pressure of 16 kg/cm2(g), inlet line pressure range of 16– 49 kg/cm2(g) (performance range 16 to 19 kg/cm2(g) with discharge pressure 255 kg/cm2(g) with 7 bank Priority panel and 90 KW electric motor along with all special tools and tackles required for erection and commissioning along with CO2 flooding system etc. The compressor shall have provision for overhead mounting of cascade (3000 water liter capacity with approximate weight of 6.5 tons) including the space for operation & maintenance of the cascades. The package shall be inclusive of:\n\na) String test of complete compressor package along with gas engine and accessories at packager’s factory including TPIA (Third Party Inspection Agency) Charges.\n\nb) Design, Engineering, Manufacturing, Supply including packaging and forwarding, insurance, custom clearance, handling, loading and unloading of air compressor with flame proof motor of 7.5KW capacity (approx.) discharge pressure approx. 16 kg/cm2g, 1000 Water litre capacity air receiver for instrumentation air, air dryer along with all accessories and auxiliaries.\n\nLocation(s) for delivery will be finalized at the time of Release Order (s).",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A63+1","v":2},"Freight up to store/site at Hyderabad GA. ",{"$f":"C63","v":1},"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A64+1","v":3},"Re-transportation of packages if delivered at store to respective site including loading & unloading within the same GA.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[{"$f":"A65+1","v":4},"INSTALLATION, COMMISSIONING, TESTING ",null,null,null,null,0,0,{"$error":"#NAME?"}]
[5,"Installation, commissioning & Field performance test of Compressor Package including all accessories/ equipment(s) i.e. air compressor, CO2 flooding system etc. system at site.",1,"No.",null,null,0,0,{"$error":"#NAME?"}]
[6,"Total amount for supply, installation, testing & commissioning (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H63+H64+H65+H67","v":0}]
[7,"SERVICES FOR OPERATIONS & COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[8,"ITEMS FOR OPERATIONS",null,null,null,null,0,0,{"$error":"#NAME?"}]
[9,"Operation charges for 1st year i.e. during Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0075% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"1*3*365","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[10,"Operation charges for 2nd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0079% of unit price (sl.no 1) quoted by the bidder.",{"$f":"C71","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[11,"Operation charges for 3rd year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0082% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C72","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[12,"Operation charges for 4th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0086% of unit price (sl.no 1)  quoted by the bidder.",{"$f":"C73","v":1095},"No of Shifts",null,null,0,0,{"$f":"ConvertCurrencyToEnglish(H74)","v":{"$error":"#NAME?"}}]
[13,"Operation charges for 5th year i.e. after Warranty period per shift of 8hrs (1 package X 3 shifts X 365 days)\nThe quoted rate (for 1 No of shift) for this item must be equal to or more than 0.0090% of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C74","v":1095},"No of Shifts",null,null,0,0,{"$error":"#NAME?"}]
[14,"Total amount for OPERATIONS (inclusive of taxes) based on quoted price",null,null,null,null,{"$f":"C76*E76*F76","v":0},{"$f":"C76*E76+G76","v":0},{"$error":"#NAME?"},{"$f":"SUM(H71:H75)","v":0}]
[null,"Total amount for OPERATIONS based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H71*(1+10%)^-1+H72*(1+10%)^-2+H73*(1+10%)^-3+H74*(1+10%)^-4+H75*(1+10%)^-5","v":0}]
[{"$f":"A76+1","v":15},"ITEMS FOR COMPREHENSIVE MAINTENANCE",null,null,null,null,0,0,{"$error":"#NAME?"}]
[16,"Lump sum Repair & Comprehensive Maintenance charges (excluding the scope covers under warrantee) per Compressor Package including air compressor for 1st year during warrantee period in all Geographical Areas of BGL inclusive of all manpower, spare parts, lubricants and consumables etc. (1 package X 12 Months)\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.40% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"1*12","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[17,"Lump sum Repair & comprehensive maintenance charges (including major overhaul) per Compressor Package including air compressor in all Geographical Area’s under BGL periphery inclusive of all manpower, spare parts, lubricants and consumables etc. For the below mentioned years (1 package X 12 Months)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[18,"For 2nd Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.50% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C79","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[19,"For 3rd year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.55% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C81","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[20,"For 4th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.61% (maximum 1.5%) of unit price  (sl.no 1) quoted by the bidder.",{"$f":"C82","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[21,"For 5th Year\nThe quoted rate (for 1 Machine Month) for this item must be equal to or more than 0.67% (maximum 1.5%) of unit price (sl.no 1) quoted by the bidder.",{"$f":"C83","v":12},"Machine Months",null,null,0,0,{"$error":"#NAME?"}]
[22,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H79+H81+H82+H83+H84","v":0}]
[23,"Total amount for OPERATIONS (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"},{"$f":"H79*(1+10%)^-1+H81*(1+10%)^-2+H82*(1+10%)^-3+H83*(1+10%)^-4+H84*(1+10%)^-5","v":0}]
[24,"Total amount for COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on NPV CALCULATION",null,null,null,null,0,0,{"$error":"#NAME?"}]
[25,"A. Package Gas Loss:",null,null,null,null,0,0,{"$error":"#NAME?"}]
[26,"The bidder shall design the compressor package so that no venting and leakage of gas takes place. Bidder shall indicate actual vent & leakage losses through the compressor package. If package loss is quoted more than 1% of suction capacity gas consumption than bid shall be rejected. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools and tackles, transportation, erection & commissioning, operations and comprehensive maintenance will be calculated as per following formulas:\nF = G * H * I * N * W Where,\nF = Amount in Rs.\nG = Vent/Leakage rate quoted in percentage\nH = Cost of Natural Gas per Kg @ Rs. 52/- per kg\nI = Avg. no. of running hours per year i.e. @ 3650 hours, N = Number of machines\nW = 450 kg for 600 SCMH\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",null,null,null,null,0,0,{"$error":"#NAME?"}]
[27,"Package Gas Loss for 1st year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"1+1+5","v":7},"No.",null,null,null,{"$f":"IF(E90=0,\"0\",E90*52*3650*C90*450)","v":"0"},{"$error":"#NAME?"}]
[28,"Package Gas Loss for 2nd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C90","v":7},"No.",null,null,null,{"$f":"IF(E91=0,\"0\",E91*52*3650*C91*450)","v":"0"},{"$error":"#NAME?"}]
[29,"Package Gas Loss for 3rd year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C91","v":7},"No.",null,null,null,{"$f":"IF(E92=0,\"0\",E92*52*3650*C92*450)","v":"0"},{"$error":"#NAME?"}]
[30,"Package Gas Loss for 4th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C92","v":7},"No.",null,null,null,{"$f":"IF(E93=0,\"0\",E93*52*3650*C93*450)","v":"0"},{"$error":"#NAME?"}]
[31,"Package Gas Loss for 5th year\nUnder column 'E', bidder to quote 'G = Vent/Leakage rate in percentage' (without affixing % symbol)",{"$f":"C93","v":7},"No.",null,null,null,{"$f":"IF(E94=0,\"0\",E94*52*3650*C94*450)","v":"0"},{"$error":"#NAME?"}]
[32,"Total Value of Gas loss based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H90*(1+10%)^-1+H91*(1+10%)^-2+H92*(1+10%)^-3+H93*(1+10%)^-4+H94*(1+10%)^-5","v":0}]
[33,"B. Electric Power Consumption:",null,null,null,null,null,null,{"$error":"#NAME?"}]
[34,"The compressor package shall be designed in such a way that Electric Power Consumption of Motor (KW/Hr) should be minimum for production of CNG.\nBidder shall indicate actual electric power consumption for their compressor package. This quoted figure will be used for evaluation and total quoted price for all compressors towards supply, special tools & tackles, erection and commissioning will be calculated as per following formulas:\nF = G x H x I x N\nWhere, F = Amount in Rs.\nG = Bidder’s Electric Power Consumption Rate quoted in KW/Hr for every 600 SCMH (450 Kg) of CNG produced \nH = Cost of Electric Power Consumption per KW/Hr @ Rs. 11/- per KW/Hr\nI = Avg. no. of running hours per year i.e. @ 3650 hours\nN = Number of machines\nNotes:\n1. Electric Power Consumption quoted by the bidder under guaranteed parameters shall lie within the  range of 72 to 74 KW/Hr for 600 SCMH. No benefit will be given below 72 KW/Hr for 600 SCMH. In case the fuel consumption quoted by the bidder exceeds the upper limit i.e. 74 KW/Hr for 600 SCMH, the bid will be rejected.\n2. The amount (F) as per the above calculations for 5 years shall be considered on NPV basis with discount factor @10% p.a.\nUnder column 'E', bidder to quote ''Bidder’s Electric Power Consumption Rate in KW/Hr for every 600 SCMH (450 Kg) of CNG produced\".",null,null,null,null,null,null,{"$error":"#NAME?"}]
[35,"Electric Power Consumption for 1st year",7,"No.",null,null,null,{"$f":"_xlfn.IFS(E98=0,\"0\",E98<73,11*3650*72*C98,E98>72,11*3650*E98*C98)","v":"0"},{"$error":"#NAME?"}]
[36,"Electric Power Consumption for 2nd year",{"$f":"C98","v":7},"No.",null,null,null,{"$f":"_xlfn.IFS(E99=0,\"0\",E99<73,11*3650*72*C99,E99>72,11*3650*E99*C99)","v":"0"},{"$error":"#NAME?"}]
[37,"Electric Power Consumption for 3rd year",{"$f":"C99","v":7},"No.",null,null,null,{"$f":"_xlfn.IFS(E100=0,\"0\",E100<73,11*3650*72*C100,E100>72,11*3650*E100*C100)","v":"0"},{"$error":"#NAME?"}]
[38,"Electric Power Consumption for 4th year",{"$f":"C100","v":7},"No.",null,null,null,{"$f":"_xlfn.IFS(E101=0,\"0\",E101<73,11*3650*72*C101,E101>72,11*3650*E101*C101)","v":"0"},{"$error":"#NAME?"}]
[39,"Electric Power Consumption for 5th year",{"$f":"C101","v":7},"No.",null,null,null,{"$f":"_xlfn.IFS(E102=0,\"0\",E102<73,11*3650*72*C102,E102>72,11*3650*E102*C102)","v":"0"},{"$error":"#NAME?"}]
[40,"Total IV. Value of Engine Gas Consumption based on NPV CALCULATION",null,null,null,null,null,null,{"$error":"#NAME?"},{"$f":"H98*(1+10%)^-1+H99*(1+10%)^-2+H100*(1+10%)^-3+H101*(1+10%)^-4+H102*(1+10%)^-5","v":0}]
[41,"NOTE :\n1. Inspection shall be carried out by Owner or its authorized consultant/ TPI at bidder’s cost.\n\n2. Inlet piping shall be of class 300# (filter, inlet valve and 3-way valve).\n\n3. Delivery location of the Compressors may change as per requirement and the same shall be intimated to the supplier before dispatch.\n\n4. Maximum limit to quote charges for Repair & Comprehensive Maintenance for 1 Machine Months shall be 1.5% of unit Ex- works price of Sr. No. 1, failing which will be liable for rejection of bid.\n\n5. For SOR Sr. No. 7 , Bidder to ensure the minimum wages of Semi-skilled labour/ worker for construction industries per day (in Rupees) of respective state/ Central (whichever is higher).\n\n6. Deployment of Bidder personal/Resources for Operation will be as per the direction of Engineer In Charge/BGL representative/GA in-charge with prior information of minimum one month. In case of installation of 2 nos compressors at a particular CNG Station/Mother station i.e. in same premises, EIC may ask the supplier/Bidder to deploy one personnel for operations of both compressors and payment will be done for one personnel/Resource only.",null,null,null,null,null,null,{"$error":"#NAME?"}]
[42,"Total amount for supply, installation, testing & commissioning, Operations & COMPREHENSIVE MAINTENANCE (inclusive of taxes) based on quoted price (without NPV calculation)\n\nNote: The evaluated price as per tender condition i.e. , based on NPV calculations for cost heads (wherever applicable, as per tender) is given at row below (Sl. No. 43)",null,null,null,null,{"$f":"SUM(G11:G104)","v":0},{"$f":"SUM(H9:H84)","v":0},{"$error":"#NAME?"},{"$f":"J16+J25+J34+J42+J51+J60+J68+J77+J86+J95+J103","v":0}]
[43,"Total in Figures",null,null,null,null,null,{"$f":"SUM(H9:H105)","v":0},{"$error":"#NAME?"}]