{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["StateUTs","DC Sectors with Thresholds","TGSet 102","TGSet 151","TMaster","BMaster","Boiler 102","Boiler 151","Instructions & Notes","Formulae Used","CPPSummary","TGSet 0","Boiler 0"],"not_rendered":{"charts":0,"images":55,"macros":1,"external_links":66,"defined_names":2639,"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":"StateUTs","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
["Sl No.","State/ UT","State category"]
[35,"Andaman and Nicobar Island","Normal",null,null,"Target Quarter","Type of obligation(s) of Obligated Designated Consumer#"]
[1,"Andhra Pradesh","Normal",null,null,"Q1","Discom"]
[2,"Arunachal Pradesh","NER",null,null,"Q2","Captive Power Plant(CPP)"]
[3,"Assam","NER",null,null,"Q3","Open Access"]
[4,"Bihar","Normal",null,null,"Q4"]
[32,"Chandigarh","Normal"]
[5,"Chhattisgarh","Normal"]
[33,"Daman & Diu and Dadra & Nagar Haveli","Normal"]
[6,"Delhi","Normal"]
[7,"Goa","Normal"]
[8,"Gujarat","Normal"]
[9,"Haryana","Normal"]
[10,"Himachal Pradesh","Hilly"]
[11,"Jammu & Kashmir","Hilly"]
[13,"Jharkhand","Normal"]
[14,"Karnataka","Normal"]
[15,"Kerala","Normal"]
[12,"Ladakh","Hilly"]
[36,"Lakshadweep","Normal"]
[16,"Madhya Pradesh","Normal"]
[17,"Maharashtra","Normal"]
[18,"Manipur","NER"]
[20,"Meghalaya","NER"]
[19,"Mizoram","NER"]
[21,"Nagaland","NER"]
[22,"Odisha","Normal"]
[34,"Puducherry","Normal"]
[23,"Punjab","Normal"]
[24,"Rajasthan","Normal"]
[25,"Sikkim","NER"]
[26,"Tamil Nadu","Normal"]
[27,"Telangana","Normal"]
[28,"Tripura","NER"]
[29,"Uttar Pradesh","Normal"]
[30,"Uttarakhand","Hilly"]
[31,"West Bengal","Normal"]

{"sheet":"DC Sectors with Thresholds","index":1,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
["S.No"," Notified Sector","Threshold Energy Consumption in Metric tonne of oil equivalent (mtoe) per year and above.","DC Sectors with Thresholds"]
[3,"Cement:"]
[6,"Chemical"]
[7,"Commercial Building or establishments:"]
[19,"Petrochemical Manufacturing units:"]
[21,"Railway"]
[1,"Aluminum",7500,{"$f":"CONCATENATE(B8,\", Threshold: \", C8, \" toe\")","v":"Aluminum, Threshold: 7500 toe"}]
[2,"Automobile Assembly Unit",3000,{"$f":"CONCATENATE(B9,\", Threshold: \", C9, \" toe\")","v":"Automobile Assembly Unit, Threshold: 3000 toe"}]
[null,"Cement : Integrated Cement Unit",30000,{"$f":"CONCATENATE(B10,\", Threshold: \", C10, \" toe\")","v":"Cement : Integrated Cement Unit, Threshold: 30000 toe"}]
[null,"Cement : Cement grinding Unit",10000,"Cement : Cement grinding Unit, Threshold: 10000 toe"]
[4,"Ceramic",5000,"Ceramic, Threshold: 5000 toe"]
[5,"Chlor_Alkali",12000,"Chlor_Alkali, Threshold: 12000 toe"]
[null,"Chemical : Alkali Chemical (Soda Ash, Potassium Hydroxide)",3000,"Chemical : Alkali Chemical (Soda Ash, Potassium Hydroxide), Threshold: 3000 toe"]
[null,"Chemical : Inorganic Chemicals",3000,"Chemical : Inorganic Chemicals, Threshold: 3000 toe"]
[null,"Chemical : Organic Chemicals",3000,"Chemical : Organic Chemicals, Threshold: 3000 toe"]
[null,"Chemical : Pesticides ",3000,"Chemical : Pesticides , Threshold: 3000 toe"]
[null,"Chemical : Dyes and Pigments",3000,"Chemical : Dyes and Pigments, Threshold: 3000 toe"]
[null,"Chemical : Pharmaceuticals (Active Pharmaceutical Ingredient)",3000,"Chemical : Pharmaceuticals (Active Pharmaceutical Ingredient), Threshold: 3000 toe"]
[null,"Commercial Building or establishments : Hotel",500,"Commercial Building or establishments : Hotel, Threshold: 500 toe"]
[null,"Commercial Building or establishments : Airports",500,"Commercial Building or establishments : Airports, Threshold: 500 toe"]
[8,"Copper",10000,"Copper, Threshold: 10000 toe"]
[9,"Dairy",2500,"Dairy, Threshold: 2500 toe"]
[11,"Fertilizer",30000,{"$f":"CONCATENATE(B24,\", Threshold: \", C24, \" toe\")","v":"Fertilizer, Threshold: 30000 toe"}]
[12,"Forging",1500,{"$f":"CONCATENATE(B25,\", Threshold: \", C25, \" toe\")","v":"Forging, Threshold: 1500 toe"}]
[13,"Foundry",5000,"Foundry, Threshold: 5000 toe"]
[14,"Glass",10000,"Glass, Threshold: 10000 toe"]
[15,"Iron and Steel",20000,"Iron and Steel, Threshold: 20000 toe"]
[16,"Pulp and Paper",75000,"Pulp and Paper, Threshold: 75000 toe"]
[17,"Petroleum Refinery",90000,"Petroleum Refinery, Threshold: 90000 toe"]
[18,"Petrochemical units having gas crackers or naphtha crackers or both","1,00,000","Petrochemical units having gas crackers or naphtha crackers or both, Threshold: 1,00,000 toe"]
[null,"Petrochemical Manufacturing units : Fiber Intermediates",50000,"Petrochemical Manufacturing units : Fiber Intermediates, Threshold: 50000 toe"]
[null,"Petrochemical Manufacturing units : Polymers",10000,"Petrochemical Manufacturing units : Polymers, Threshold: 10000 toe"]
[null,"Petrochemical Manufacturing units : Detergent intermediates",9000,"Petrochemical Manufacturing units : Detergent intermediates, Threshold: 9000 toe"]
[null,"Petrochemical Manufacturing units : Performance Plastics",3000,"Petrochemical Manufacturing units : Performance Plastics, Threshold: 3000 toe"]
[null,"Petrochemical Manufacturing units : Other petrochemical products",6000,"Petrochemical Manufacturing units : Other petrochemical products, Threshold: 6000 toe"]
[null,"Petrochemical Manufacturing units : Synthetic rubbers",15000,"Petrochemical Manufacturing units : Synthetic rubbers, Threshold: 15000 toe"]
[null,"Petrochemical Manufacturing units : Aromatics",20000,"Petrochemical Manufacturing units : Aromatics, Threshold: 20000 toe"]
[20,"Port Trust",500,"Port Trust, Threshold: 500 toe"]
[null,"Railway : All Zonal Railways (Traction)",70000,"Railway : All Zonal Railways (Traction), Threshold: 70000 toe"]
[null,"Railway : Workshops",750,"Railway : Workshops, Threshold: 750 toe"]
[null,"Railway : 8 Production factories of Railways namely ICF, RCF, CLW, BLW, PLW, RW, MCF and RWP",null,"Railway : 8 Production factories of Railways namely ICF, RCF, CLW, BLW, PLW, RW, MCF and RWP "]
[22,"Refractories",3000,{"$f":"CONCATENATE(B43,\", Threshold: \", C43, \" toe\")","v":"Refractories, Threshold: 3000 toe"}]
[23,"Sugar",10000,{"$f":"CONCATENATE(B44,\", Threshold: \", C44, \" toe\")","v":"Sugar, Threshold: 10000 toe"}]
[24,"Textiles",3000,{"$f":"CONCATENATE(B45,\", Threshold: \", C45, \" toe\")","v":"Textiles, Threshold: 3000 toe"}]
[25,"Tyre manufacturer",7000,{"$f":"CONCATENATE(B46,\", Threshold: \", C46, \" toe\")","v":"Tyre manufacturer, Threshold: 7000 toe"}]
[26,"Zinc",20000,{"$f":"CONCATENATE(B47,\", Threshold: \", C47, \" toe\")","v":"Zinc, Threshold: 20000 toe"}]

{"sheet":"TGSet 102","index":2,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,0,1,17],[2,0,2,17],[3,0,3,3],[3,4,3,17],[4,0,4,3],[4,4,4,17],[5,0,5,3],[5,4,5,17],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[8,0,8,3],[8,4,8,17],[9,0,9,3],[9,4,9,17],[10,0,10,3],[10,4,10,17],[11,0,11,3],[11,4,11,17],[17,0,18,0],[17,1,17,7],[17,8,17,10],[17,11,17,17],[46,0,51,17],[32,0,33,8],[32,9,33,11],[32,12,33,15],[32,16,33,17],[34,0,34,17],[35,0,35,17],[36,0,36,17],[37,0,38,17],[39,0,40,17],[41,0,42,17],[43,0,45,17]]}
[]
["Quarterly RCO Compliance Data reporting - Quarterly TG Set Wise Electricity Generation"]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",null,null,null,{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",null,null,null,{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",null,null,null,{"$f":"'CPPSummary'!D10","v":0}]
["TG Set ID",null,null,null,"TGSet 102"]
["Name / Description of TG Set"]
[]
[null,null,null,null,null,null,null,null,"Select from existing Boilers:"]
[]
[]
[]
["TG Set 102","Energy Input to Boiler",null,null,null,null,null,null,"Energy Output of Boiler",null,null,"Energy Input to TG Set"]
[null,"Total Boiler Input Energy (Mega Cal)","Fossil Based Energy at Boiler Input \n(Mega Cal)","Non-Fossil Based Energy at Boiler Input (Mega Cal)","Fossil based WHR Energy from Process execpt GT Flue Gas \n(Mega Cal)","Is this Boiler a WHRB? (Yes = 1 / No = 0)","Energy Input by Auxiliary Firing of Non-Fossil Fuel in WHRBs (Mega Cal)","Energy Input by Auxiliary Firing of Fossil Fuel in WHRBs (Mega Cal)","Steam Qty at Boiler Output (Tons)","Enthalpy* at Boiler Output (kCal/kg)","Total Energy at Boiler Output \n(Mega Cal)","% of Steam Input to TG Set!!","Steam Qty Before!! PRDS / Microturbine\n(Tons)","Steam Qty at TG Set Input After## PRDS / Microturbine\n(Tons)","Enthalpy** at TG Set Input After$ PRDS / Microturbine (kCal/kg)","Total Energy at TG Set Input \n(Mega Cal)","Fossil Based Energy at TG Set Input \n(Mega Cal)","Non-Fossil Based Energy at TG Set Input  \n(Mega Cal)"]
["Col A","Col B","Col C","Col D","Col E","Col F","Col G","Col H","Col I","Col J","Col K","Col L","Col M","Col N","Col O","Col P","Col Q","Col R"]
["Boiler 0",{"$f":"'Boiler 0'!$E$36","v":0},{"$f":"'Boiler 0'!$E$37","v":0},{"$f":"'Boiler 0'!$E$38","v":0},{"$f":"'Boiler 0'!$E$34","v":0},{"$f":"IF(OR('Boiler 0'!$E$30>0, 'Boiler 0'!$E$31>0),1,0)","v":0},{"$f":"NonFossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 0'!$C$45","v":0},{"$f":"'Boiler 0'!$D$45","v":0},{"$f":"'Boiler 0'!$E$45","v":0},{"$f":"'Boiler 0'!$E$52","v":0},{"$f":"I21*L21/100","v":0},null,null,{"$f":"N21*O21","v":0},{"$f":"IF(B21=0,0,P21*C21/B21)","v":0},{"$f":"IF(B21=0,0,P21*D21/B21)","v":0}]
["Boiler 102",{"$f":"'Boiler 102'!$E$38","v":0},{"$f":"'Boiler 102'!$E$39","v":0},{"$f":"'Boiler 102'!$E$40","v":0},{"$f":"'Boiler 102'!$E$36","v":0},{"$f":"IF(OR('Boiler 102'!$E$32>0, 'Boiler 102'!$E$33>0),1,0)","v":0},{"$f":"NonFossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 102'!$C$47","v":0},{"$f":"'Boiler 102'!$D$47","v":0},{"$f":"'Boiler 102'!$E$47","v":0},{"$f":"'Boiler 102'!$E$54","v":0},{"$f":"I22*L22/100","v":0},null,null,{"$f":"N22*O22","v":0},{"$f":"IF(B22=0,0,P22*C22/B22)","v":0},{"$f":"IF(B22=0,0,P22*D22/B22)","v":0}]
["Boiler 151",{"$f":"'Boiler 151'!$E$37","v":0},{"$f":"'Boiler 151'!$E$38","v":0},{"$f":"'Boiler 151'!$E$39","v":0},{"$f":"'Boiler 151'!$E$35","v":0},{"$f":"IF(OR('Boiler 151'!$E$31>0, 'Boiler 151'!$E$32>0),1,0)","v":0},{"$f":"NonFossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets102[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 151'!$C$46","v":0},{"$f":"'Boiler 151'!$D$46","v":0},{"$f":"'Boiler 151'!$E$46","v":0},{"$f":"'Boiler 151'!$E$53","v":0},{"$f":"I23*L23/100","v":0},null,null,{"$f":"N23*O23","v":0},{"$f":"IF(B23=0,0,P23*C23/B23)","v":0},{"$f":"IF(B23=0,0,P23*D23/B23)","v":0}]
["Total",{"$f":"SUBTOTAL(109,TGSets102[Col B])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col C])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col D])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col E])","v":0},null,{"$f":"SUBTOTAL(109,TGSets102[Col G])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col H])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col I])","v":0},null,{"$f":"SUBTOTAL(109,TGSets102[Col K])","v":0},null,{"$f":"SUBTOTAL(109,TGSets102[Col M])","v":0},null,{"$f":"SUBTOTAL(109,TGSets102[Col O])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col P])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col Q])","v":0},{"$f":"SUBTOTAL(109,TGSets102[Col R])","v":0}]
[null,"% Share of Energy Input by Auxiliary Firing of Fossil Fuel in WHRB",null,null,null,null,{"$f":"IF(TGSets102[[#Totals],[Col B]]=0,0,TGSets102[[#Totals],[Col G]]/TGSets102[[#Totals],[Col B]])","v":0},{"$f":"IF(TGSets102[[#Totals],[Col B]]=0,0,TGSets102[[#Totals],[Col H]]/TGSets102[[#Totals],[Col B]])","v":0},"Percentage Share of RE at TG Set Input (%)",null,null,null,null,null,null,null,null,{"$f":"IF(TGSets102[[#Totals],[Col P]]=0,0,TGSets102[[#Totals],[Col R]]/TGSets102[[#Totals],[Col P]])","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (Million kWh) #"]
[null,null,null,null,null,null,null,null,"Electricity Generation at TG Set Output (Million kWh)"]
[null,null,null,null,null,null,null,null,"Renewable Component of Electricity Generation at TG Set Output (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R25*R27","v":0}]
[null,null,null,null,null,null,null,null,"Energy Exempt from RCO (Corresponding to Fossil based WHR) (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*IF(TGSets102[[#Totals],[Col B]]=0,0,(TGSets102[[#Totals],[Col E]]/TGSets102[[#Totals],[Col B]]))","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Non-Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*G25","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*H25","v":0}]
[]
["Legend",null,null,null,null,null,null,null,null,"Data Entry Not Allowed",null,null,"Data to be Entered by User",null,null,null,"Calculated Data"]
[]
["Notes:"]
["* This is the Weighted Average Enthalpy of Steam at the Output of the respective Boiler during the quarter, with quantity of steam as the weight. "]
["** This is the Weighted Average Enthalpy of Steam at the Input of this TG Set, during the quarter, with quantity of steam as the weight. "]
["!! These columns represent the % share or absolute quantity of steam from the respective Boiler to the input of this TG Set. In cases where there is a Pressure Reducing and De-superheating Station (PRDS) or a Microturbine for steam pressure adjustment prior  to the TG Set, this is the value of steam prior to entering the respective PRDS / Microturbine."]
[]
["$ Please enter weighted average enthalpy of steam (with quantity of steam as the weight) at the respective TG Set input, after the PRDS / Microturbine (if installed). The enthalpy after PRDS / Microturbine will be less than the enthaly at boiler output. In case of direct connection without PRDS / Microturbine, please enter the same value as in column J."]
[]
["## Please enter the Steam Quantity at the input of this TG Set, after the PRDS / Microturbine (if installed). In case of PRDS, this steam quantity cannot be more that 5% in excess of the steam quantity before the PRDS. In case of Microturbine, or in case of direct connection without PRDS / Microturbine, please enter the same value as in column M."]
[]
["# Please enter the Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (in Million kWh). This value is aggregated for all Microturbines in the 'CPPSummary' sheet. Microturbine generates electricity by leveraging the pressure drop that would otherwise have occured across the PRDS / PRV. Only make entry for instances where the energy generated by Microturbine is metered separately and NOT inlcuded in total electricity generation from this TG Set or CPP. This energy would NOT be exempt from RCO Compliance obligations."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"TGSet 151","index":3,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,0,1,17],[2,0,2,17],[3,0,3,3],[3,4,3,17],[4,0,4,3],[4,4,4,17],[5,0,5,3],[5,4,5,17],[6,0,6,3],[6,4,6,17],[7,0,7,3],[7,4,7,17],[8,0,8,3],[8,4,8,17],[9,0,9,3],[9,4,9,17],[10,0,10,3],[10,4,10,17],[11,0,11,3],[11,4,11,17],[17,0,18,0],[17,1,17,7],[17,8,17,10],[17,11,17,17],[46,0,51,17],[32,0,33,8],[32,9,33,11],[32,12,33,15],[32,16,33,17],[34,0,34,17],[35,0,35,17],[36,0,36,17],[37,0,38,17],[39,0,40,17],[41,0,42,17],[43,0,45,17]]}
[]
["Quarterly RCO Compliance Data reporting - Quarterly TG Set Wise Electricity Generation"]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",null,null,null,{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",null,null,null,{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",null,null,null,{"$f":"'CPPSummary'!D10","v":0}]
["TG Set ID",null,null,null,"TGSet 151"]
["Name / Description of TG Set"]
[]
[null,null,null,null,null,null,null,null,"Select from existing Boilers:"]
[]
[]
[]
["TG Set 151","Energy Input to Boiler",null,null,null,null,null,null,"Energy Output of Boiler",null,null,"Energy Input to TG Set"]
[null,"Total Boiler Input Energy (Mega Cal)","Fossil Based Energy at Boiler Input \n(Mega Cal)","Non-Fossil Based Energy at Boiler Input (Mega Cal)","Fossil based WHR Energy from Process execpt GT Flue Gas \n(Mega Cal)","Is this Boiler a WHRB? (Yes = 1 / No = 0)","Energy Input by Auxiliary Firing of Non-Fossil Fuel in WHRBs (Mega Cal)","Energy Input by Auxiliary Firing of Fossil Fuel in WHRBs (Mega Cal)","Steam Qty at Boiler Output (Tons)","Enthalpy* at Boiler Output (kCal/kg)","Total Energy at Boiler Output \n(Mega Cal)","% of Steam Input to TG Set!!","Steam Qty Before!! PRDS / Microturbine\n(Tons)","Steam Qty at TG Set Input After## PRDS / Microturbine\n(Tons)","Enthalpy** at TG Set Input After$ PRDS / Microturbine (kCal/kg)","Total Energy at TG Set Input \n(Mega Cal)","Fossil Based Energy at TG Set Input \n(Mega Cal)","Non-Fossil Based Energy at TG Set Input  \n(Mega Cal)"]
["Col A","Col B","Col C","Col D","Col E","Col F","Col G","Col H","Col I","Col J","Col K","Col L","Col M","Col N","Col O","Col P","Col Q","Col R"]
["Boiler 0",{"$f":"'Boiler 0'!$E$36","v":0},{"$f":"'Boiler 0'!$E$37","v":0},{"$f":"'Boiler 0'!$E$38","v":0},{"$f":"'Boiler 0'!$E$34","v":0},{"$f":"IF(OR('Boiler 0'!$E$30>0, 'Boiler 0'!$E$31>0),1,0)","v":0},{"$f":"NonFossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 0'!$C$45","v":0},{"$f":"'Boiler 0'!$D$45","v":0},{"$f":"'Boiler 0'!$E$45","v":0},{"$f":"'Boiler 0'!$E$52","v":0},{"$f":"I21*L21/100","v":0},null,null,{"$f":"N21*O21","v":0},{"$f":"IF(B21=0,0,P21*C21/B21)","v":0},{"$f":"IF(B21=0,0,P21*D21/B21)","v":0}]
["Boiler 102",{"$f":"'Boiler 102'!$E$38","v":0},{"$f":"'Boiler 102'!$E$39","v":0},{"$f":"'Boiler 102'!$E$40","v":0},{"$f":"'Boiler 102'!$E$36","v":0},{"$f":"IF(OR('Boiler 102'!$E$32>0, 'Boiler 102'!$E$33>0),1,0)","v":0},{"$f":"NonFossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 102'!$C$47","v":0},{"$f":"'Boiler 102'!$D$47","v":0},{"$f":"'Boiler 102'!$E$47","v":0},{"$f":"'Boiler 102'!$E$54","v":0},{"$f":"I22*L22/100","v":0},null,null,{"$f":"N22*O22","v":0},{"$f":"IF(B22=0,0,P22*C22/B22)","v":0},{"$f":"IF(B22=0,0,P22*D22/B22)","v":0}]
["Boiler 151",{"$f":"'Boiler 151'!$E$37","v":0},{"$f":"'Boiler 151'!$E$38","v":0},{"$f":"'Boiler 151'!$E$39","v":0},{"$f":"'Boiler 151'!$E$35","v":0},{"$f":"IF(OR('Boiler 151'!$E$31>0, 'Boiler 151'!$E$32>0),1,0)","v":0},{"$f":"NonFossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets151[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 151'!$C$46","v":0},{"$f":"'Boiler 151'!$D$46","v":0},{"$f":"'Boiler 151'!$E$46","v":0},{"$f":"'Boiler 151'!$E$53","v":0},{"$f":"I23*L23/100","v":0},null,null,{"$f":"N23*O23","v":0},{"$f":"IF(B23=0,0,P23*C23/B23)","v":0},{"$f":"IF(B23=0,0,P23*D23/B23)","v":0}]
["Total",{"$f":"SUBTOTAL(109,TGSets151[Col B])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col C])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col D])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col E])","v":0},null,{"$f":"SUBTOTAL(109,TGSets151[Col G])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col H])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col I])","v":0},null,{"$f":"SUBTOTAL(109,TGSets151[Col K])","v":0},null,{"$f":"SUBTOTAL(109,TGSets151[Col M])","v":0},null,{"$f":"SUBTOTAL(109,TGSets151[Col O])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col P])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col Q])","v":0},{"$f":"SUBTOTAL(109,TGSets151[Col R])","v":0}]
[null,"% Share of Energy Input by Auxiliary Firing of Fossil Fuel in WHRB",null,null,null,null,{"$f":"IF(TGSets151[[#Totals],[Col B]]=0,0,TGSets151[[#Totals],[Col G]]/TGSets151[[#Totals],[Col B]])","v":0},{"$f":"IF(TGSets151[[#Totals],[Col B]]=0,0,TGSets151[[#Totals],[Col H]]/TGSets151[[#Totals],[Col B]])","v":0},"Percentage Share of RE at TG Set Input (%)",null,null,null,null,null,null,null,null,{"$f":"IF(TGSets151[[#Totals],[Col P]]=0,0,TGSets151[[#Totals],[Col R]]/TGSets151[[#Totals],[Col P]])","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (Million kWh) #"]
[null,null,null,null,null,null,null,null,"Electricity Generation at TG Set Output (Million kWh)"]
[null,null,null,null,null,null,null,null,"Renewable Component of Electricity Generation at TG Set Output (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R25*R27","v":0}]
[null,null,null,null,null,null,null,null,"Energy Exempt from RCO (Corresponding to Fossil based WHR) (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*IF(TGSets151[[#Totals],[Col B]]=0,0,(TGSets151[[#Totals],[Col E]]/TGSets151[[#Totals],[Col B]]))","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Non-Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*G25","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*H25","v":0}]
[]
["Legend",null,null,null,null,null,null,null,null,"Data Entry Not Allowed",null,null,"Data to be Entered by User",null,null,null,"Calculated Data"]
[]
["Notes:"]
["* This is the Weighted Average Enthalpy of Steam at the Output of the respective Boiler during the quarter, with quantity of steam as the weight. "]
["** This is the Weighted Average Enthalpy of Steam at the Input of this TG Set, during the quarter, with quantity of steam as the weight. "]
["!! These columns represent the % share or absolute quantity of steam from the respective Boiler to the input of this TG Set. In cases where there is a Pressure Reducing and De-superheating Station (PRDS) or a Microturbine for steam pressure adjustment prior  to the TG Set, this is the value of steam prior to entering the respective PRDS / Microturbine."]
[]
["$ Please enter weighted average enthalpy of steam (with quantity of steam as the weight) at the respective TG Set input, after the PRDS / Microturbine (if installed). The enthalpy after PRDS / Microturbine will be less than the enthaly at boiler output. In case of direct connection without PRDS / Microturbine, please enter the same value as in column J."]
[]
["## Please enter the Steam Quantity at the input of this TG Set, after the PRDS / Microturbine (if installed). In case of PRDS, this steam quantity cannot be more that 5% in excess of the steam quantity before the PRDS. In case of Microturbine, or in case of direct connection without PRDS / Microturbine, please enter the same value as in column M."]
[]
["# Please enter the Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (in Million kWh). This value is aggregated for all Microturbines in the 'CPPSummary' sheet. Microturbine generates electricity by leveraging the pressure drop that would otherwise have occured across the PRDS / PRV. Only make entry for instances where the energy generated by Microturbine is metered separately and NOT inlcuded in total electricity generation from this TG Set or CPP. This energy would NOT be exempt from RCO Compliance obligations."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"TMaster","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["TG Set Master Table"]
[]
[null,"TG Set ID"]
[null,"TGSet 102"]
[null,"TGSet 151"]
[null,"TGSet 0"]
[null,{"$f":"SUBTOTAL(103,TMaster[TG Set ID])","v":3}]

{"sheet":"BMaster","index":5,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Boiler Master Table"]
[]
[null,"Boiler ID"]
[null,"Boiler 102"]
[null,"Boiler 151"]
[null,"Boiler 0"]
[null,{"$f":"SUBTOTAL(103,BMaster[Boiler ID])","v":3}]

{"sheet":"Boiler 102","index":6,"n_rows":98,"n_cols":5,"rows_kept":98,"cut":false,"hidden":true,"merged":[[13,0,13,4],[1,0,1,4],[2,0,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[37,0,37,3],[20,0,20,1],[20,2,20,4],[24,0,24,1],[24,2,24,4],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[60,0,60,4],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[43,0,43,4],[44,2,44,4],[48,0,48,4],[58,0,59,0],[58,1,59,1],[58,2,59,3],[58,4,59,4],[86,0,91,4],[61,0,65,4],[66,0,66,4],[67,0,67,4],[68,0,69,4],[70,0,73,4],[74,0,75,4],[76,0,77,4],[78,0,80,4],[81,0,82,4],[83,0,84,4],[85,0,85,4]]}
[]
["Quarterly RCO Compliance Data reporting - Boiler wise Quarterly Energy Input and Output  "]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of DC",{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated DC",{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated DC",{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",{"$f":"'CPPSummary'!D10","v":0}]
["Boiler ID","Boiler 102"]
["Name / Description of Boiler"]
[]
["Boiler Input"]
[]
[]
[]
[]
[]
[]
["Fossil Fuels (1)",null,"Energy Input"]
["Boiler 102","Name / Description of Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Fossil_Fuel 1",null,null,null,{"$f":"C23*D23","v":0}]
["Total Input Energy of Fossil Fuels",null,{"$f":"SUBTOTAL(109,FossilFuels102[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,FossilFuels102[Energy (Mega Cal)])","v":0}]
["Non-Fossil Fuels (1)",null,"Energy Input"]
["Boiler 102","Name / Description of Non-Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Non_Fossil_Fuel 1",null,null,null,{"$f":"C27*D27","v":0}]
["Non_Fossil_Fuel 2",null,null,null,{"$f":"C28*D28","v":0}]
["Non_Fossil_Fuel 3",null,null,null,{"$f":"C29*D29","v":0}]
["Total Input Energy of Non-Fossil Fuels",null,{"$f":"SUBTOTAL(109,NonFossilFuels102[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,NonFossilFuels102[Energy (Mega Cal)])","v":0}]
["Energy Input from WHR (Mega Cal)"]
["WHR Energy from Gas Turbine Flue Gas %%"]
["WHR Energy from Processes except GT Flue Gas %%"]
["Input RE Ratio for WHR Energy from Processes except GT Flue Gas (2)"]
["Non-Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E33*E34","v":0}]
["Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E33*(1-E34)","v":0}]
["Total Energy Input (Mega Cal) and Percentage Shares"]
["Grand Total Energy Input",null,null,null,{"$f":"FossilFuels102[[#Totals],[Energy (Mega Cal)]]+NonFossilFuels102[[#Totals],[Energy (Mega Cal)]]+E33+E32","v":0}]
["Total Fossil based Energy Input",null,null,null,{"$f":"FossilFuels102[[#Totals],[Energy (Mega Cal)]]+E32+E36","v":0}]
["Total Non-fossil based Energy Input",null,null,null,{"$f":"NonFossilFuels102[[#Totals],[Energy (Mega Cal)]]+E35","v":0}]
["Percentage share of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"IF(E38=0,0,E33/E38)","v":0}]
["Percentage Share of RE",null,null,null,{"$f":"IF(E38=0,0,E40/E38)","v":0}]
[]
["Boiler Output"]
["Boiler 102",null,"Energy Output (3)"]
[null,"Boiler Efficiency (%) $","Steam Qty (Tons)","Enthalpy** (kCal/kg)","Total Energy (Mega Cal)"]
[null,{"$f":"IF(E38=0,0,E47*100/E38)","v":0},null,null,{"$f":"C47*D47","v":0}]
[]
["Steam Distribution to Multiple TG Sets and / or Process"]
["Select from existing TG Sets:",null,"Select from connected TG Sets:"]
[]
[]
["Distribution of Boiler Steam Output:!!","Column3","Column1","Column2","% Input to TG/Process!!"]
["TGSet 0"]
["Total Distribution to TG Set(s) #",null,null,null,{"$f":"SUBTOTAL(109,BoilerTG102[% Input to TG/Process!!])","v":0}]
["Input to Process and Boiler Auxiliaries ##",null,null,null,{"$f":"100-BoilerTG102[[#Totals],[% Input to TG/Process!!]]","v":100}]
[]
[]
["Legend","Data Entry Not Allowed","Data to be Entered by User",null,"Calculated Data"]
[]
["Notes:"]
["(1) For all fuels fired at boiler input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The calculations shall be done to the accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report.\nQuarterly aggregation of fuel quantities (for each fuel) is to be done by addition, and quarterly aggregation of GCVs (i.e. Grsolid) to be done by calculating weighted average GCV with weightage taken as the fuel quantity."]
[]
[]
[]
[]
["* Please enter the Weighted Average GCV of all Quantity Consumed during the quarter. "]
["** Please enter the Weighted Average Enthalpy of all Steam Quantity Generated during the quarter. "]
["%% If there is Flue Gas entering at Boiler input as heat souces, this indicates that this is a WHR Boiler. Any additional fuel firing in such boiler will be considered as auxiliary fuel fired to the WHRB."]
[]
["(2) This represents the share of input energy from Non-fossil Fuels fired out of input energy from Total Fuels fired at the process input. The same input RE ratio is carried over to the Flue Gas entering at the input of the WHR boiler. For all fuels fired at process input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The ratio shall be calculated upto an accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report."]
[]
[]
[]
["(3) At boiler output, quarterly aggregation of steam generation is to be done as cumulative, and aggregation of Enthlpy to be done by calculating weighted average Enthalpy with weightage taken as the steam quantity."]
[]
["$ This is the boiler efficiency by direct method (i.e. Boiler Output Energy / Boiler Input Energy). It is provided as an approximate checkpoint for the values entered in the worksheet."]
[]
["!! This table indicates the distribution of boiler steam output to multiple TG Sets and / or Process. Under column '% Input to TG/Process', please enter the percentage share of steam output from this boiler, that goes into the respective TG Set. Value should be between 0 to 100, and the total % share of steam to TG Sets should not exceed 100%."]
[]
[]
["# This represents the total steam output from this boiler, to all TG Sets that are connected to it. This is calculated based on the value(s) entered in  under column '% Input to TG/Process'."]
[]
["## This represents the total steam output from this boiler, to the plant process and boiler auxiliaries. All the balance steam output from the boiler after deducting the steam output to all TG Sets is attributed to steam supply to plant process and boiler auxiliaries."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"Boiler 151","index":7,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":true,"merged":[[13,0,13,4],[1,0,1,4],[2,0,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[36,0,36,3],[20,0,20,1],[20,2,20,4],[25,0,25,1],[25,2,25,4],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[59,0,59,4],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[42,0,42,4],[43,2,43,4],[47,0,47,4],[57,0,58,0],[57,1,58,1],[57,2,58,3],[57,4,58,4],[85,0,90,4],[60,0,64,4],[65,0,65,4],[66,0,66,4],[67,0,68,4],[69,0,72,4],[73,0,74,4],[75,0,76,4],[77,0,79,4],[80,0,81,4],[82,0,83,4],[84,0,84,4]]}
[]
["Quarterly RCO Compliance Data reporting - Boiler wise Quarterly Energy Input and Output  "]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of DC",{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated DC",{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated DC",{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",{"$f":"'CPPSummary'!D10","v":0}]
["Boiler ID","Boiler 151"]
["Name / Description of Boiler"]
[]
["Boiler Input"]
[]
[]
[]
[]
[]
[]
["Fossil Fuels (1)",null,"Energy Input"]
["Boiler 151","Name / Description of Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Fossil_Fuel 1",null,null,null,{"$f":"C23*D23","v":0}]
["Fossil_Fuel 2",null,null,null,{"$f":"C24*D24","v":0}]
["Total Input Energy of Fossil Fuels",null,{"$f":"SUBTOTAL(109,FossilFuels151[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,FossilFuels151[Energy (Mega Cal)])","v":0}]
["Non-Fossil Fuels (1)",null,"Energy Input"]
["Boiler 151","Name / Description of Non-Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Non_Fossil_Fuel 1",null,null,null,{"$f":"C28*D28","v":0}]
["Total Input Energy of Non-Fossil Fuels",null,{"$f":"SUBTOTAL(109,NonFossilFuels151[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,NonFossilFuels151[Energy (Mega Cal)])","v":0}]
["Energy Input from WHR (Mega Cal)"]
["WHR Energy from Gas Turbine Flue Gas %%"]
["WHR Energy from Processes except GT Flue Gas %%"]
["Input RE Ratio for WHR Energy from Processes except GT Flue Gas (2)"]
["Non-Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E32*E33","v":0}]
["Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E32*(1-E33)","v":0}]
["Total Energy Input (Mega Cal) and Percentage Shares"]
["Grand Total Energy Input",null,null,null,{"$f":"FossilFuels151[[#Totals],[Energy (Mega Cal)]]+NonFossilFuels151[[#Totals],[Energy (Mega Cal)]]+E32+E31","v":0}]
["Total Fossil based Energy Input",null,null,null,{"$f":"FossilFuels151[[#Totals],[Energy (Mega Cal)]]+E31+E35","v":0}]
["Total Non-fossil based Energy Input",null,null,null,{"$f":"NonFossilFuels151[[#Totals],[Energy (Mega Cal)]]+E34","v":0}]
["Percentage share of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"IF(E37=0,0,E32/E37)","v":0}]
["Percentage Share of RE",null,null,null,{"$f":"IF(E37=0,0,E39/E37)","v":0}]
[]
["Boiler Output"]
["Boiler 151",null,"Energy Output (3)"]
[null,"Boiler Efficiency (%) $","Steam Qty (Tons)","Enthalpy** (kCal/kg)","Total Energy (Mega Cal)"]
[null,{"$f":"IF(E37=0,0,E46*100/E37)","v":0},null,null,{"$f":"C46*D46","v":0}]
[]
["Steam Distribution to Multiple TG Sets and / or Process"]
["Select from existing TG Sets:",null,"Select from connected TG Sets:"]
[]
[]
["Distribution of Boiler Steam Output:!!","Column3","Column1","Column2","% Input to TG/Process!!"]
["TGSet 0"]
["Total Distribution to TG Set(s) #",null,null,null,{"$f":"SUBTOTAL(109,BoilerTG151[% Input to TG/Process!!])","v":0}]
["Input to Process and Boiler Auxiliaries ##",null,null,null,{"$f":"100-BoilerTG151[[#Totals],[% Input to TG/Process!!]]","v":100}]
[]
[]
["Legend","Data Entry Not Allowed","Data to be Entered by User",null,"Calculated Data"]
[]
["Notes:"]
["(1) For all fuels fired at boiler input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The calculations shall be done to the accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report.\nQuarterly aggregation of fuel quantities (for each fuel) is to be done by addition, and quarterly aggregation of GCVs (i.e. Grsolid) to be done by calculating weighted average GCV with weightage taken as the fuel quantity."]
[]
[]
[]
[]
["* Please enter the Weighted Average GCV of all Quantity Consumed during the quarter. "]
["** Please enter the Weighted Average Enthalpy of all Steam Quantity Generated during the quarter. "]
["%% If there is Flue Gas entering at Boiler input as heat souces, this indicates that this is a WHR Boiler. Any additional fuel firing in such boiler will be considered as auxiliary fuel fired to the WHRB."]
[]
["(2) This represents the share of input energy from Non-fossil Fuels fired out of input energy from Total Fuels fired at the process input. The same input RE ratio is carried over to the Flue Gas entering at the input of the WHR boiler. For all fuels fired at process input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The ratio shall be calculated upto an accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report."]
[]
[]
[]
["(3) At boiler output, quarterly aggregation of steam generation is to be done as cumulative, and aggregation of Enthlpy to be done by calculating weighted average Enthalpy with weightage taken as the steam quantity."]
[]
["$ This is the boiler efficiency by direct method (i.e. Boiler Output Energy / Boiler Input Energy). It is provided as an approximate checkpoint for the values entered in the worksheet."]
[]
["!! This table indicates the distribution of boiler steam output to multiple TG Sets and / or Process. Under column '% Input to TG/Process', please enter the percentage share of steam output from this boiler, that goes into the respective TG Set. Value should be between 0 to 100, and the total % share of steam to TG Sets should not exceed 100%."]
[]
[]
["# This represents the total steam output from this boiler, to all TG Sets that are connected to it. This is calculated based on the value(s) entered in  under column '% Input to TG/Process'."]
[]
["## This represents the total steam output from this boiler, to the plant process and boiler auxiliaries. All the balance steam output from the boiler after deducting the steam output to all TG Sets is attributed to steam supply to plant process and boiler auxiliaries."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"Instructions & Notes","index":8,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[15,1,15,2],[26,1,26,2],[7,1,7,2]]}
[]
[null,"Co-Firing and WHR Tool for RCO Compliance Data reporting  "]
[null,"(Simulates CPP/TPP Configuration and Calculates RE Component in CPP/TPP Power due to Co-Firing of Fossil Based and Renewable Based Fuels)"]
[null,"Important Instructions - First Things First!"]
[null,"I ","This is a Macro Enabled workbook, and may not work correctly on legacy versions of MS Excel. Please use excel versions from 2021 and later."]
[null,"II","Please ensure that Macros are enabled before using this tool. This can be ensured in the following way:\ni) Close this file and from the File Explorer, right click this excel file, select 'Properties' and from the bottom of the file properties dialog box, select the option to unblock macros, under the 'Security' section as highlighted in the screenshot.\nii) With this file open; In excel, please select File --> Options. In the 'File Options' dialog box, please select Trust Center --> Trust Center Settings --> Macro Settings --> Disable VBA Macros"]
[]
[null,"Instructions and Notes - General:"]
[null,1,"Name, Address and other basic details of Obligated Designated Consumers to be entered in worksheet named 'CPPSummary'. These details will be populated automatically in other sheets based on input in 'CPPSummary'."]
[null,2,"Electrical Energy Consumption is to be entered in Million kWh (MU) throughout all worksheets in this workbook. "]
[null,"3a","Similarly, Steam and Fuel Quantity is to be entered in Tons throughout all worksheets in this workbook. "]
[null,"3b","Similarly, Enthaly of Steam and GCV of Fuel is to be entered in kCal/kg throughout all worksheets in this workbook. "]
[null,4,"The formulae used in this tool for various scenarios, and the corresponding schematic diagrams providing details of each scenario, are provided in the worksheet named \"Formulae Used\""]
[null,5,"Please refer carefully to the Legend and Notes provided on each worksheet while filling in the details"]
[null,6,"This Co-firing tool is to be used in conjunction with the Form A and Form B for RCO compliance data reporting. Inputs from the 'CPPSummary' sheet in this tool will feed into Quarter wise details to be filled in Annexure - 1 of the Form A. \n\nA separate copy of this co-firing tool will need to be used for each of the four quarters of the target financial year."]
[null,"Instructions and Notes - Replicating CPP/TPP Configuration in the tool:"]
[null,7,"This excel tool is capable of adding worksheets as needed to simulate the CPP / TPP configuration in terms of the Boilers, TG Sets and their interconnections :\n●  In addition to this worksheets named 'Instructions & Notes', and 'Formulae Used', the workbook will initially contain one visible worksheet named 'CPPSummary'\n●  The 'Add TG Set' Button in CPPSummary worksheet sheet Adds a new TG Set worksheet, and a corresponding row in the CPPSummary worksheet \n● Example: \n   * On the first click of 'Add TG Set' Button, a new worksheet named TGSet 1 is created, and a corresponding TGSet 1 row is created in the CPPSummary Worksheet. \n   * On every subsequent click, new worksheets and corresponding rows named progressively as TGSet 2, TGSet 3 etc. are created.\n●  Thus, each TG Set is represented by a worksheet named after the TG Set, and a corresponding row in the CPP Summary worksheet."]
[]
[null,8,"Each TG Set worksheet is further capable of adding worksheets as needed to simulate boilers feeding into the TG Set:\n●  The 'Add Boiler' Button in respective TG Set worksheet sheet Adds a new Boiler worksheet, and a corresponding row in the respective TG Set worksheet \n● Example: \n   * On the first click of 'Add Boiler' Button, in the TGSet 1 worksheet, a new worksheet named Boiler 1 is created, and a corresponding Boiler 1 row is created in the TGSet 1 Worksheet. \n   * On every subsequent click, new worksheets and corresponding rows named progressively as Boiler 2, Boiler 3 etc. are created.\n●  Thus, each Boiler is represented by a worksheet named after the Boiler, and a corresponding row in the TG Set worksheet, to which the boiler is connected."]
[]
[null,9,"Each Boiler worksheet is divided into a 'Boiler Input' section and a 'Boiler Output' section. \n●  The 'Boiler Input' section records the Fuel Name / Description, Quantity, and GCV for each of the Fossil and Non-fossil fuels fired. It also records WHR energy input from GT Flue Gas or Process Flue Gas in case of WHR Boilers.\n●  The  'Boiler Output' section records the steam output quantity and enthalpy to calculate the energy in steam output.\n● The  'Boiler Output' section also  records the steam distribution from the boiler to multiple TG Sets and / or Process. "]
[null,10,"The 'Boiler Input' section is further capable of adding rows corresponding to various Fossil Fuels and Non-fossil Fuels Fired:\n●  The 'Add Fossil Fuel' Button in respective Boiler worksheet sheet Adds a new row for Fossil Fuel in the 'Boiler Input' section. \n● Example: \n   * On the first click of 'Add Fossil Fuel' Button, a new row for 'Fossil Fuel 2' is added in addition to the existing row for 'Fossil Fuel 1'.\n   * On every subsequent click, new rows named progressively as  'Fossil Fuel 3',  'Fossil Fuel 4' etc. are created.\n●  The 'Add Non-Fossil Fuel' Button in respective Boiler worksheet sheet Adds a new row for Non-Fossil Fuel in the 'Boiler Input' section. \n● Example: \n   * On the first click of 'Add Non-Fossil Fuel' Button, a new row for 'Non-Fossil Fuel 2' is added in addition to the existing row for 'Non-Fossil Fuel 1'. \n   * On every subsequent click, new rows named progressively as  'Non-Fossil Fuel 3',  'Non-Fossil Fuel 4' etc. are created.\n●  Further explanatory notes on the Input fields and Calculated fields in the 'Boiler Input' section is provided in the respective Boiler worksheet"]
[]
[]
[null,11,"The 'Boiler Output' section is further capable of connecting the respective boiler to additional TG Sets over and above the primary TG Set that it is connected to. This is achieved in the sub-section named 'Steam Distribution to Multiple TG Sets and / or Process':\n●  The 'Add Additional TG Set' Button in respective Boiler worksheet sheet Adds a new row for the Additional TG Set in the 'Steam Distribution' sub-section. \n● The Additional TG Set to be added to the respective Boiler can be selected through the combo box provided for the same.\n● A new row for the respective Boiler is also added simultaneously in the Additional TG Set worksheet.\n● A visual illustration of the same is provided below. \n●  Further explanatory notes on the Input field and Calculated fields in the 'Boiler Output' section is provided in the respective Boiler worksheet"]
[]
[null,"Instructions and Notes - Editing CPP/TPP Configuration in the tool:"]
[null,12,"The 'Boiler Output' section is further capable of disconnecting the respective boiler from any of the multiple TG Sets that it is connected to. This is again achieved in the sub-section named 'Steam Distribution to Multiple TG Sets and / or Process':\n●  The 'Remove Connected TG Set' Button in respective Boiler worksheet sheet removes a connected TG Set in the 'Steam Distribution' sub-section. \n● The Connected TG Set to be removed from the respective Boiler can be selected through the combo box provided for the same.\n● The row for the respective Boiler is also removed simultaneously in the Connected TG Set worksheet.\n● Example:\n   * Boiler 2 is connected to multiple TG Sets say, 'TGSet 2' and  'TGSet 1'\n   * Any of the connected TG Sets (i.e. 'TGSet 2' or 'TGSet 1') can be selected through the combo box provided\n   * Once the required TG Set (say, 'TGSet 1') is selected in the combo box, pressing the 'Remove Connected TG Set' button will remove the corresponding TGSet row from the 'Steam Distribution' sub-section in the 'Boiler 2' sheet.\n   * Simultaneously, the 'Boiler 2' row from connected TGSet worksheet (i.e. 'TGSet 1' worksheet) will also be removed, thus disconnecting 'Boiler 2' from 'TGSet 1'\n● In case the boiler is connected to only a single TG Set, the 'Remove Connected TG Set' button will not disconnect the last remaining TG Set."]
[]
[null,13,"The 'Boiler Input' section is further capable of deleting rows corresponding to various Fossil Fuels and Non-fossil Fuels Fired:\n●  The 'Remove Fossil Fuel' Button in respective Boiler worksheet sheet deletes the last row for Fossil Fuel in the 'Boiler Input' section. \n● Example: \n   * On the first click of 'Remove Fossil Fuel' Button, the last row for 'Fossil Fuel 4' is deleted. \n   * On every subsequent click, the last Fossil Fuel row gets deleted, e.g. 'Fossil Fuel 3',  'Fossil Fuel 2' etc. \n   * If only the last Fossil Fuel row remains, i.e. Fossil Fuel 1, then this row cannot be deleted with the 'Remove Fossil Fuel' Button\n●  The 'Remove Non-Fossil Fuel' Button in respective Boiler worksheet deletes the last row for Non-Fossil Fuel in the 'Boiler Input' section. \n● Example: \n   * On the first click of 'Remove Non-Fossil Fuel' Button,the last row for 'Non-Fossil Fuel 4' is deleted. \n   * On every subsequent click, the last Non-Fossil Fuel rows named progressively as  'Non-Fossil Fuel 3',  'Non-Fossil Fuel 2' etc. are deleted.\n   * If only the last Non-Fossil Fuel row remains, i.e. Non-Fossil Fuel 1, then this row cannot be deleted with the 'Remove Non-Fossil Fuel' Button."]
[]
[null,14,"Each TG Set worksheet is further capable of removing Boilers that are feeding into the TG Set:\n●  The 'Remove Boiler' Button in respective TG Set worksheet sheet removes the selected Boiler worksheet, and its corresponding row in the TG Set worksheet.\n● The Boiler to be deleted can be selected from the combo box provided for the purpose.\n● Only those Boilers that are connected to a single TG Set can be removed. If the boiler is connected to multiple TG Sets, then it cannot be deleted using the 'Remove Boiler' Button in any of the connected TG Sets.\n● To delete such a Boiler, connected to multiple TG Sets, the boiler will need to be disconnected from all but one of the TG Sets. Then it can be removed using the 'Remove Boiler' Button in the connected TG Set.\n● Example: \n   * Boiler 2 is connected to multiple TG Sets say, 'TGSet 2' and 'TGSet 1'.\n   * Then the 'Remove Boiler' Button in either 'TGSet 2' or 'TGSet 1' will not allow the deletion of 'Boiler 2'.\n   * First, from the 'Boiler 2' worksheet, any of the connected TG Sets (i.e. 'TGSet 2' or 'TGSet 1') can be selected and deleted through the combo box provided in the in the 'Steam Distribution' sub-section of the 'Boiler Output' section. Process for this is already described in point 12 above.\n● Example: \n   * Now, let us say, 'Boiler 2' is connected to only 'TGSet 2'.\n   * Now, to delete 'Boiler 2', select the boiler from the combo box provided in the 'TGSet 2' worksheet.\n   * Then, on pressing the 'Remove Boiler' Button, in the 'TGSet 2' worksheet, the 'Boiler 2' worksheet, and the corresponding 'Boiler 2' row in the 'TGSet 2' worksheet are deleted. "]
[]
[]
[null,15,"Similarly, TG Sets can be removed as needed from the CPP / TPP configuration, through 'CPPSummary' worksheet:\n●  The TG Set to be removed can be selected from the combo box provided for the purpose, in 'CPPSummary' worksheet\n●  The 'Remove TG Set' Button in CPPSummary worksheet sheet deletes the selected TGSet worksheet, and the corresponding row in the CPPSummary worksheet \n● Only TG Sets that are NOT connected to any Boiler, can be deleted.\n● If the TG Set already has a connected Boiler, the Boiler can first be removed as explained in point 14 above. \n● Example: \n    * Now, let us say, 'TGSet 1' is connected to 'Boiler 1'.\n    * The 'Remove TG Set' Button in CPPSummary worksheet will therefore NOT delete 'TGSet 1'.\n    * Hence, to delete 'TGSet 1' its connection to 'Boiler 1' needs to be removed first, in this case, by deleting 'Boiler 1'.\n● Example:\n    * Now, let us say, connection between 'TGSet 1' and 'Boiler 1' is removed (in this case, by deleting 'Boiler 1').\n    * Now, to delete 'TGSet 1', select the TG Set from the combo box provided in the 'CPPSummary' worksheet.\n    * Then, on pressing the 'Remove TG Set' Button in the 'CPPSummary' worksheet, 'TGSet 1' worksheet and the corresponding 'TGSet 1' row in the CPPSummary worksheet are deleted. "]

{"sheet":"Formulae Used","index":9,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,20,63,21],[64,20,64,21],[62,20,62,21],[52,18,55,21],[57,20,57,21],[59,20,59,21],[58,20,58,21],[61,20,61,21],[60,20,60,21],[41,20,41,21],[42,20,42,21],[43,20,43,21],[45,20,45,21],[36,18,38,21],[40,20,40,21],[2,0,2,21],[20,0,32,17],[5,0,5,21],[4,0,4,17],[19,0,19,21],[6,18,7,21],[13,20,13,21],[6,0,18,17],[14,20,14,21],[15,20,15,21],[16,20,16,21],[17,20,17,21],[18,20,18,21],[20,18,21,21],[27,20,27,21],[28,20,28,21],[46,20,46,21],[34,0,48,17],[50,0,64,17],[4,18,4,21],[49,0,49,21],[33,0,33,21],[48,20,48,21],[47,20,47,21],[34,18,35,21],[50,18,51,21],[29,20,29,21],[30,20,30,21],[31,20,31,21],[44,20,44,21],[32,20,32,21],[22,18,25,21]]}
[]
[]
["Illustrative Schematics and Corresponding Formulae Used  in the Tool for various Scenarios"]
[]
[" Illustrative Schematic Diagram",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Formulae Used"]
["Case 1: Co-firing of multiple renewable fuels along with fossil fuels in the same boiler in CPP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The quantum of RE generation is determined based on the ratio of the energy input through co-fired non-fossil fuel with respect to the energy input through total fuel quantity fired in CPP."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Er(G)","=","Electrical energy generated by renewable fuels at Generator terminal during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qr","=","Quantity of renewable fuels consumed during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gr","=","Weighted average Gross Calorific Value (GCV) of biomass (other renewable sources) consumed during quarter (kCal/kg);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E(GT)","=","Gross electrical energy generated at Generator Terminal during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qf","=","Quantity of coal or other fossil fuel burnt during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gf","=","Weighted average GCV of coal or other fossil fuel burnt during the quarter (kCal/kg)"]
["Case 2: Co-firing of multiple renewable fuels (e.g., black liquor dry solids - BLDS) and fossil fuels, each in separate boiler"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The quantum of RE generation is determined based on the ratio of the energy input through co-fired non-fossil fuel with respect to the energy input through total fuel quantity fired in CPP. The input energy ratio is calculated at the steam side, i.e. at turbine input."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Er(G)","=","Electrical energy generated by renewable fuels at Generator terminal during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qr","=","Quantity of steam generated from renewable fuels consumed during quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hr","=","Weighted average enthalpy of steam generated from renewable fuels consumed during quarter (kCal/kg));"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qf","=","Quantity of steam generated from coal or other fossil fuel burnt during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hf","=","Weighted average enthalpy of steam generated from fossil fuel burnt during the quarter (kCal/kg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E(GT)","=","Gross electrical energy generated at Generator Terminal during the quarter (Million kWh);"]
["Case 3: Co-firing of multiple fossil and renewable fuels in multiple boilers (Combination of Case 1 and Case 2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The quantum of RE generation is determined based on the ratio of the energy input through co-fired non-fossil fuel with respect to the energy input through total fuel quantity fired in CPP. The input energy ratio is calculated at two levels. First, the energy input ratio at boiler input or ERBI, and then at turbine input, using ERBI."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Er(G)","=","Electrical energy generated by renewable fuels at Generator terminal during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qr","=","Quantity of steam generated from renewable fuels consumed during quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hr","=","Weighted average enthalpy of steam generated from renewable fuels consumed during quarter (kCal/kg));"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qf","=","Quantity of steam generated from coal or other fossil fuel burnt during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hf","=","Weighted average enthalpy of steam generated from fossil fuel burnt during the quarter (kCal/kg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ERBI","=","Energy Ratio at Boiler Input (ratio of energy from co-firing of non-fossil fuels to energy from firing of all fuels at boiler input);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IP + UP","=","Energy input at WHR Boiler through recovery of heat generated from process (by combustion of fossil fuel and by exothermic reactions) during the quarter (Mega Cal). Applicable in case of WHR Boiler only. Refer to Case 4 for schematic diagram;"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RERpi","=","Input Energy Ratio of RE Fuels to total Fuels fired at the Process Input. Applicable in case of WHR Boiler only. Refer to Case 4 for schematic diagram;"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E(GT)","=","Gross electrical energy generated at Generator Terminal during the quarter (Million kWh);"]
["Case 4: Electricity Generation from WHR System including Auxiliary Firing of Fossil Fuel in WHR Boiler"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The quantum of RE generation is determined based on the ratio of the energy input through co-fired non-fossil fuel with respect to the energy input through total fuel quantity fired in CPP."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Where,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ef(G)AUX","=","Electrical energy generated at Generator terminal of WHR system by auxiliary firing of fossil fuels during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Er(G)AUX","=","Electrical energy generated at Generator terminal of WHR system by auxiliary firing of renewable fuels during the quarter (Million kWh);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qf","=","Quantity of steam generated from coal or other fossil fuel burnt during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hf","=","Weighted average enthalpy of steam generated from fossil fuel burnt during the quarter (kCal/kg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Qr","=","Quantity of renewable fuels consumed during the quarter (Tons);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gr","=","Weighted average Gross Calorific Value (GCV) of biomass (other renewable sources) consumed during quarter (kCal/kg);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IP + UP","=","Energy input at WHR Boiler through recovery of heat generated from process (by combustion of fossil fuel and by exothermic reactions) during the quarter (Mega Cal);"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E(GT)WHR","=","Gross electrical energy generated at Generator Terminal through WHR during the quarter (Million kWh);"]

{"sheet":"CPPSummary","index":10,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,3,6,7],[7,3,7,7],[8,3,8,7],[9,3,9,7],[21,5,22,6],[21,0,22,3],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[21,4,22,4],[1,0,1,7],[2,0,2,7],[3,3,3,7],[4,3,4,7],[5,3,5,7],[3,0,3,2],[5,0,5,2],[4,0,4,2],[23,0,23,7],[24,0,25,7],[26,0,27,7],[30,0,31,7],[21,7,22,7],[32,0,33,7],[36,0,37,7],[39,0,44,7],[34,0,35,7],[28,0,29,7]]}
[]
["Quarterly RCO Compliance Data reporting - Quarterly CPP Electricity Generation"]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer"]
["Energy Intensive Sector of Designated Consumer"]
["Registration No. of Obligated Designated Consumer"]
["Type of obligation(s) of Obligated Designated Consumer"]
["Target Year FY (__-__)"]
["Quarter"]
["Location - State"]
[]
[null,null,null,null,null,"Select from existing TG Sets:"]
[]
[]
[]
["CPP Summary","Total Electricity Generation (Million kWh) (1)","Electricity Generation from Microturbine(s) installed across PRDS / PRV where applicable \n(Million kWh) (2)","Electricity Generation at TG Set Output (Million kWh) (3)","Renewable Component of Electricity Generation at TG Set Output (Million kWh) (4)","Energy Exempt from RCO (Corresponding to WHR) (Million kWh) (5)","Electricity Generation by Auxiliary Firing of Non-Fossil Fuel\n(Million kWh)(6)","Electricity Generation by Auxiliary Firing of Fossil Fuel (Million kWh) (7)"]
["TG Set 0",{"$f":"C17+D17","v":0},{"$f":"'TGSet 0'!$R$26","v":0},{"$f":"'TGSet 0'!$R$27","v":0},{"$f":"'TGSet 0'!$R$28","v":0},{"$f":"'TGSet 0'!$R$29","v":0},{"$f":"'TGSet 0'!$R$30","v":0},{"$f":"'TGSet 0'!$R$31","v":0}]
["TG Set 102",{"$f":"C18+D18","v":0},{"$f":"'TGSet 102'!$R$26","v":0},{"$f":"'TGSet 102'!$R$27","v":0},{"$f":"'TGSet 102'!$R$28","v":0},{"$f":"'TGSet 102'!$R$29","v":0},{"$f":"'TGSet 102'!$R$30","v":0},{"$f":"'TGSet 102'!$R$31","v":0}]
["TG Set 151",{"$f":"C19+D19","v":0},{"$f":"'TGSet 151'!$R$26","v":0},{"$f":"'TGSet 151'!$R$27","v":0},{"$f":"'TGSet 151'!$R$28","v":0},{"$f":"'TGSet 151'!$R$29","v":0},{"$f":"'TGSet 151'!$R$30","v":0},{"$f":"'TGSet 151'!$R$31","v":0}]
["Total",{"$f":"SUBTOTAL(109,CPPSummary[Total Electricity Generation (Million kWh) (1)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Electricity Generation from Microturbine(s) installed across PRDS / PRV where applicable \n(Million kWh) (2)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Electricity Generation at TG Set Output (Million kWh) (3)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Renewable Component of Electricity Generation at TG Set Output (Million kWh) (4)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Energy Exempt from RCO (Corresponding to WHR) (Million kWh) (5)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Electricity Generation by Auxiliary Firing of Non-Fossil Fuel\n(Million kWh)(6)])","v":0},{"$f":"SUBTOTAL(109,CPPSummary[Electricity Generation by Auxiliary Firing of Fossil Fuel (Million kWh) (7)])","v":0}]
[]
["Legend",null,null,null,"Data Entry Not Allowed","Data to be Entered by User",null,"Calculated Data"]
[]
["Notes:"]
["(1) This is the total Electricity Generation from the respective TG Set and the Microturbines. The aggregated total value represents the total generation from the CPP and all Microturbines."]
[]
["(2) The aggregated total value represents the total electricity generation from all Microturbine(s) installed across PRDS / PRV where appliacble. Electricity generation from Microturbines are not exempt from RCO. This value is to be taken over to Annexure - 1 in the main RCO data reporting format as Emicroturbine"]
[]
["(3) This is the total Electricity Generation from the respective TG Set. The aggregated total value represents the total generation from the CPP. This aggregated value is to be taken over to Annexure - 1 in the main RCO data reporting format as ECPP"]
[]
["(4) This is the total Renewable Component of Electricity Generation at the respective TG Set Output. The aggregated total value represents the Renewable Component of Electricity Generation from the CPP. This aggregated value is to be taken over to Annexure - 1 in the main RCO data reporting format as ErCPP"]
[]
["(5) This is the WHR component of the total Electricity Generation from the respective TG Set. The aggregated total value represents the WHR component of total generation from the CPP. This aggregated value is to be taken over to Annexure - 1 in the main RCO data reporting format as E(WHR)CPP"]
[]
["(6) This is the total Electricity Generation component corresponding to Auxiliary Firing of Non-Fossil Fuel in WHRBs from the respective TG Set. The aggregated total value represents the total generation by auxiliary firing of non-fossil fuel from the CPP. This aggregated value is already included ErCPP, and is hence not taken over to Annexure - 1 in the main RCO data reporting format."]
[]
["(7) This is the total Electricity Generation component corresponding to Auxiliary Firing of Fossil Fuel in WHRBs from the respective TG Set. The aggregated total value represents the total generation by auxiliary firing of fossil fuel from the CPP. This aggregated value is to be taken over to Annexure - 1 in the main RCO data reporting format as Ef(WHR)AUX"]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"TGSet 0","index":11,"n_rows":58,"n_cols":18,"rows_kept":58,"cut":false,"hidden":true,"merged":[[46,0,51,17],[41,0,42,17],[37,0,38,17],[32,0,33,8],[32,9,33,11],[32,12,33,15],[32,16,33,17],[34,0,34,17],[35,0,35,17],[36,0,36,17],[43,0,45,17],[39,0,40,17],[1,0,1,17],[10,0,10,3],[11,0,11,3],[2,0,2,17],[10,4,10,17],[11,4,11,17],[7,0,7,3],[8,0,8,3],[9,0,9,3],[3,0,3,3],[5,0,5,3],[6,0,6,3],[3,4,3,17],[7,4,7,17],[8,4,8,17],[9,4,9,17],[5,4,5,17],[6,4,6,17],[4,0,4,3],[17,1,17,7],[17,8,17,10],[17,11,17,17],[4,4,4,17],[17,0,18,0]]}
[]
["Quarterly RCO Compliance Data reporting - Quarterly TG Set Wise Electricity Generation"]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated Designated Consumer",null,null,null,{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",null,null,null,{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",null,null,null,{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",null,null,null,{"$f":"'CPPSummary'!D10","v":0}]
["TG Set ID",null,null,null,"TGSet 0"]
["Name / Description of TG Set"]
[]
[null,null,null,null,null,null,null,null,"Select from existing Boilers:"]
[]
[]
[]
["TG Set 0","Energy Input to Boiler",null,null,null,null,null,null,"Energy Output of Boiler",null,null,"Energy Input to TG Set"]
[null,"Total Boiler Input Energy (Mega Cal)","Fossil Based Energy at Boiler Input \n(Mega Cal)","Non-Fossil Based Energy at Boiler Input (Mega Cal)","Fossil based WHR Energy from Process execpt GT Flue Gas \n(Mega Cal)","Is this Boiler a WHRB? (Yes = 1 / No = 0)","Energy Input by Auxiliary Firing of Non-Fossil Fuel in WHRBs (Mega Cal)","Energy Input by Auxiliary Firing of Fossil Fuel in WHRBs (Mega Cal)","Steam Qty at Boiler Output (Tons)","Enthalpy* at Boiler Output (kCal/kg)","Total Energy at Boiler Output \n(Mega Cal)","% of Steam Input to TG Set!!","Steam Qty Before!! PRDS / Microturbine\n(Tons)","Steam Qty at TG Set Input After## PRDS / Microturbine\n(Tons)","Enthalpy** at TG Set Input After$ PRDS / Microturbine (kCal/kg)","Total Energy at TG Set Input \n(Mega Cal)","Fossil Based Energy at TG Set Input \n(Mega Cal)","Non-Fossil Based Energy at TG Set Input  \n(Mega Cal)"]
["Col A","Col B","Col C","Col D","Col E","Col F","Col G","Col H","Col I","Col J","Col K","Col L","Col M","Col N","Col O","Col P","Col Q","Col R"]
["Boiler 0",{"$f":"'Boiler 0'!$E$36","v":0},{"$f":"'Boiler 0'!$E$37","v":0},{"$f":"'Boiler 0'!$E$38","v":0},{"$f":"'Boiler 0'!$E$34","v":0},{"$f":"IF(OR('Boiler 0'!$E$30>0, 'Boiler 0'!$E$31>0),1,0)","v":0},{"$f":"NonFossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels0[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 0'!$C$45","v":0},{"$f":"'Boiler 0'!$D$45","v":0},{"$f":"'Boiler 0'!$E$45","v":0},{"$f":"'Boiler 0'!$E$52","v":0},{"$f":"I21*L21/100","v":0},null,null,{"$f":"N21*O21","v":0},{"$f":"IF(B21=0,0,P21*C21/B21)","v":0},{"$f":"IF(B21=0,0,P21*D21/B21)","v":0}]
["Boiler 102",{"$f":"'Boiler 102'!$E$38","v":0},{"$f":"'Boiler 102'!$E$39","v":0},{"$f":"'Boiler 102'!$E$40","v":0},{"$f":"'Boiler 102'!$E$36","v":0},{"$f":"IF(OR('Boiler 102'!$E$32>0, 'Boiler 102'!$E$33>0),1,0)","v":0},{"$f":"NonFossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels102[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 102'!$C$47","v":0},{"$f":"'Boiler 102'!$D$47","v":0},{"$f":"'Boiler 102'!$E$47","v":0},{"$f":"'Boiler 102'!$E$54","v":0},{"$f":"I22*L22/100","v":0},null,null,{"$f":"N22*O22","v":0},{"$f":"IF(B22=0,0,P22*C22/B22)","v":0},{"$f":"IF(B22=0,0,P22*D22/B22)","v":0}]
["Boiler 151",{"$f":"'Boiler 151'!$E$37","v":0},{"$f":"'Boiler 151'!$E$38","v":0},{"$f":"'Boiler 151'!$E$39","v":0},{"$f":"'Boiler 151'!$E$35","v":0},{"$f":"IF(OR('Boiler 151'!$E$31>0, 'Boiler 151'!$E$32>0),1,0)","v":0},{"$f":"NonFossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"FossilFuels151[[#Totals],[Energy (Mega Cal)]]*TGSets0[[#This Row],[Col F]]","v":0},{"$f":"'Boiler 151'!$C$46","v":0},{"$f":"'Boiler 151'!$D$46","v":0},{"$f":"'Boiler 151'!$E$46","v":0},{"$f":"'Boiler 151'!$E$53","v":0},{"$f":"I23*L23/100","v":0},null,null,{"$f":"N23*O23","v":0},{"$f":"IF(B23=0,0,P23*C23/B23)","v":0},{"$f":"IF(B23=0,0,P23*D23/B23)","v":0}]
["Total",{"$f":"SUBTOTAL(109,TGSets0[Col B])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col C])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col D])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col E])","v":0},null,{"$f":"SUBTOTAL(109,TGSets0[Col G])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col H])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col I])","v":0},null,{"$f":"SUBTOTAL(109,TGSets0[Col K])","v":0},null,{"$f":"SUBTOTAL(109,TGSets0[Col M])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col N])","v":0},null,{"$f":"SUBTOTAL(109,TGSets0[Col P])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col Q])","v":0},{"$f":"SUBTOTAL(109,TGSets0[Col R])","v":0}]
[null,"% Share of Energy Input by Auxiliary Firing of Fossil Fuel in WHRB",null,null,null,null,{"$f":"IF(TGSets0[[#Totals],[Col B]]=0,0,TGSets0[[#Totals],[Col G]]/TGSets0[[#Totals],[Col B]])","v":0},{"$f":"IF(TGSets0[[#Totals],[Col B]]=0,0,TGSets0[[#Totals],[Col H]]/TGSets0[[#Totals],[Col B]])","v":0},"Percentage Share of RE at TG Set Input (%)",null,null,null,null,null,null,null,null,{"$f":"IF(TGSets0[[#Totals],[Col P]]=0,0,TGSets0[[#Totals],[Col R]]/TGSets0[[#Totals],[Col P]])","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (Million kWh) #"]
[null,null,null,null,null,null,null,null,"Electricity Generation at TG Set Output (Million kWh)"]
[null,null,null,null,null,null,null,null,"Renewable Component of Electricity Generation at TG Set Output (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R25*R27","v":0}]
[null,null,null,null,null,null,null,null,"Energy Exempt from RCO (Corresponding to Fossil based WHR) (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*IF(TGSets0[[#Totals],[Col B]]=0,0,(TGSets0[[#Totals],[Col E]]/TGSets0[[#Totals],[Col B]]))","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Non-Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*G25","v":0}]
[null,null,null,null,null,null,null,null,"Electricity Generation by Auxiliary Firing of Fossil Fuel (Million kWh)",null,null,null,null,null,null,null,null,{"$f":"R27*H25","v":0}]
[]
["Legend",null,null,null,null,null,null,null,null,"Data Entry Not Allowed",null,null,"Data to be Entered by User",null,null,null,"Calculated Data"]
[]
["Notes:"]
["* This is the Weighted Average Enthalpy of Steam at the Output of the respective Boiler during the quarter, with quantity of steam as the weight. "]
["** This is the Weighted Average Enthalpy of Steam at the Input of this TG Set, during the quarter, with quantity of steam as the weight. "]
["!! These columns represent the % share or absolute quantity of steam from the respective Boiler to the input of this TG Set. In cases where there is a Pressure Reducing and De-superheating Station (PRDS) or a Microturbine for steam pressure adjustment prior  to the TG Set, this is the value of steam prior to entering the respective PRDS / Microturbine."]
[]
["$ Please enter weighted average enthalpy of steam (with quantity of steam as the weight) at the respective TG Set input, after the PRDS / Microturbine (if installed). The enthalpy after PRDS / Microturbine will be less than the enthaly at boiler output. In case of direct connection without PRDS / Microturbine, please enter the same value as in column J."]
[]
["## Please enter the Steam Quantity at the input of this TG Set, after the PRDS / Microturbine (if installed). In case of PRDS, this steam quantity cannot be more that 5% in excess of the steam quantity before the PRDS. In case of Microturbine, or in case of direct connection without PRDS / Microturbine, please enter the same value as in column M."]
[]
["# Please enter the Electricity Generation from Microturbine(s) installed across PRDS / PRV where appliacble (in Million kWh). This value is aggregated for all Microturbines in the 'CPPSummary' sheet. Microturbine generates electricity by leveraging the pressure drop that would otherwise have occured across the PRDS / PRV. Only make entry for instances where the energy generated by Microturbine is metered separately and NOT inlcuded in total electricity generation from this TG Set or CPP. This energy would NOT be exempt from RCO Compliance obligations."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AEA Number and Signature of Authorised AEA"]

{"sheet":"Boiler 0","index":12,"n_rows":96,"n_cols":5,"rows_kept":96,"cut":false,"hidden":true,"merged":[[59,0,63,4],[9,1,9,4],[4,1,4,4],[58,0,58,4],[64,0,64,4],[20,0,20,1],[24,0,24,1],[11,1,11,4],[56,0,57,0],[56,1,57,1],[56,2,57,3],[56,4,57,4],[31,0,31,3],[32,0,32,3],[33,0,33,3],[36,0,36,3],[37,0,37,3],[3,1,3,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[1,0,1,4],[2,0,2,4],[46,0,46,4],[13,0,13,4],[41,0,41,4],[42,2,42,4],[38,0,38,3],[39,0,39,3],[29,0,29,3],[30,0,30,3],[35,0,35,3],[34,0,34,3],[24,2,24,4],[28,0,28,3],[20,2,20,4],[10,1,10,4],[84,0,89,4],[68,0,71,4],[76,0,78,4],[79,0,80,4],[65,0,65,4],[83,0,83,4],[81,0,82,4],[66,0,67,4],[72,0,73,4],[74,0,75,4]]}
[]
["Quarterly RCO Compliance Data reporting - Boiler wise Quarterly Energy Input and Output  "]
["(Co-firing and WHR Tool for Fossil based and Renewables based Fuels)"]
["Name of Obligated Designated Consumer",{"$f":"'CPPSummary'!D4","v":0}]
["Energy Intensive Sector of DC",{"$f":"'CPPSummary'!D5","v":0}]
["Registration No. of Obligated DC",{"$f":"'CPPSummary'!D6","v":0}]
["Type of obligation(s) of Obligated DC",{"$f":"'CPPSummary'!D7","v":0}]
["Target Year FY (__-__)",{"$f":"'CPPSummary'!D8","v":0}]
["Quarter",{"$f":"'CPPSummary'!D9","v":0}]
["Location - State",{"$f":"'CPPSummary'!D10","v":0}]
["Boiler ID","Boiler 0"]
["Name / Description of Boiler"]
[]
["Boiler Input"]
[]
[]
[]
[]
[]
[]
["Fossil Fuels (1)",null,"Energy Input"]
["Boiler 0","Name / Description of Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Fossil_Fuel 1",null,null,null,{"$f":"C23*D23","v":0}]
["Total Input Energy of Fossil Fuels",null,{"$f":"SUBTOTAL(109,FossilFuels0[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,FossilFuels0[Energy (Mega Cal)])","v":0}]
["Non-Fossil Fuels (1)",null,"Energy Input"]
["Boiler 0","Name / Description of Non-Fossil Fuel(s)","Fuel Qty (Tons)","GCV* (kCal/kg)","Energy (Mega Cal)"]
["Non_Fossil_Fuel 1",null,null,null,{"$f":"C27*D27","v":0}]
["Total Input Energy of Non-Fossil Fuels",null,{"$f":"SUBTOTAL(109,NonFossilFuels0[Fuel Qty (Tons)])","v":0},null,{"$f":"SUBTOTAL(109,NonFossilFuels0[Energy (Mega Cal)])","v":0}]
["Energy Input from WHR (Mega Cal)"]
["WHR Energy from Gas Turbine Flue Gas %%"]
["WHR Energy from Processes except GT Flue Gas %%"]
["Input RE Ratio for WHR Energy from Processes except GT Flue Gas (2)"]
["Non-Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E31*E32","v":0}]
["Fossil Component of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"E31*(1-E32)","v":0}]
["Total Energy Input (Mega Cal) and Percentage Shares"]
["Grand Total Energy Input",null,null,null,{"$f":"FossilFuels0[[#Totals],[Energy (Mega Cal)]]+NonFossilFuels0[[#Totals],[Energy (Mega Cal)]]+E31+E30","v":0}]
["Total Fossil based Energy Input",null,null,null,{"$f":"FossilFuels0[[#Totals],[Energy (Mega Cal)]]+E30+E34","v":0}]
["Total Non-fossil based Energy Input",null,null,null,{"$f":"NonFossilFuels0[[#Totals],[Energy (Mega Cal)]]+E33","v":0}]
["Percentage share of WHR Energy from Processes except GT Flue Gas",null,null,null,{"$f":"IF(E36=0,0,E31/E36)","v":0}]
["Percentage Share of RE",null,null,null,{"$f":"IF(E36=0,0,E38/E36)","v":0}]
[]
["Boiler Output"]
["Boiler 0",null,"Energy Output (3)"]
[null,"Boiler Efficiency (%) $","Steam Qty (Tons)","Enthalpy** (kCal/kg)","Total Energy (Mega Cal)"]
[null,{"$f":"IF(E36=0,0,E45*100/E36)","v":0},null,null,{"$f":"C45*D45","v":0}]
[]
["Steam Distribution to Multiple TG Sets and / or Process"]
["Select from existing TG Sets:",null,"Select from connected TG Sets:"]
[]
[]
["Distribution of Boiler Steam Output:!!","Column3","Column1","Column2","% Input to TG/Process!!"]
["TGSet 0"]
["Total Distribution to TG Set(s) #",null,null,null,{"$f":"SUBTOTAL(109,BoilerTG0[% Input to TG/Process!!])","v":0}]
["Input to Process and Boiler Auxiliaries ##",null,null,null,{"$f":"100-BoilerTG0[[#Totals],[% Input to TG/Process!!]]","v":100}]
[]
[]
["Legend","Data Entry Not Allowed","Data to be Entered by User",null,"Calculated Data"]
[]
["Notes:"]
["(1) For all fuels fired at boiler input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The calculations shall be done to the accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report.\nQuarterly aggregation of fuel quantities (for each fuel) is to be done by addition, and quarterly aggregation of GCVs (i.e. Grsolid) to be done by calculating weighted average GCV with weightage taken as the fuel quantity."]
[]
[]
[]
[]
["* Please enter the Weighted Average GCV of all Quantity Consumed during the quarter. "]
["** Please enter the Weighted Average Enthalpy of all Steam Quantity Generated during the quarter. "]
["%% If there is Flue Gas entering at Boiler input as heat souces, this indicates that this is a WHR Boiler. Any additional fuel firing in such boiler will be considered as auxiliary fuel fired to the WHRB."]
[]
["(2) This represents the share of input energy from Non-fossil Fuels fired out of input energy from Total Fuels fired at the process input. The same input RE ratio is carried over to the Flue Gas entering at the input of the WHR boiler. For all fuels fired at process input, the input energy by firing of fuels shall be estimated using quantity of fuel fired and the weighted average GCV of the fuel fired during the quarter. The ratio shall be calculated upto an accuracy of 3 decimal places, and backup documents justifying the calculations shall be appended by the DC and verified by Empaneled AEA Agency in their report."]
[]
[]
[]
["(3) At boiler output, quarterly aggregation of steam generation is to be done as cumulative, and aggregation of Enthlpy to be done by calculating weighted average Enthalpy with weightage taken as the steam quantity."]
[]
["$ This is the boiler efficiency by direct method (i.e. Boiler Output Energy / Boiler Input Energy). It is provided as an approximate checkpoint for the values entered in the worksheet."]
[]
["!! This table indicates the distribution of boiler steam output to multiple TG Sets and / or Process. Under column '% Input to TG/Process', please enter the percentage share of steam output from this boiler, that goes into the respective TG Set. Value should be between 0 to 100, and the total % share of steam to TG Sets should not exceed 100%."]
[]
[]
["# This represents the total steam output from this boiler, to all TG Sets that are connected to it. This is calculated based on the value(s) entered in  under column '% Input to TG/Process'."]
[]
["## This represents the total steam output from this boiler, to the plant process and boiler auxiliaries. All the balance steam output from the boiler after deducting the steam output to all TG Sets is attributed to steam supply to plant process and boiler auxiliaries."]
[]
[]
["Undertaking\nI/We undertake that the information supplied in this Renewable Consumption Obligations Compliance Declaration Form For Obligated Designated Consumers is accurate to the best of my knowledge and if any of the information supplied is found to be incorrect and such information results into loss to the Central Government or any of the authority under them or any other person affected, I/we undertake to indemnify such loss.\n\nI /We agree to extend necessary assistance in case of any enquiry to be made in the matter."]
[]
[]
[]
[]
[]
["For Designated Consumer",null,null,null,"For Empaneled AEA Agency"]
[]
[]
[]
["Signature and Seal of Energy Manager / Plant Head",null,null,null,"Seal of Empanelled AEA Agency"]
[null,null,null,null,"AEA Number and Signature of Authorised AEA"]