{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Disclaimer","B.1 Power Generation","B.2 Cogeneration"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Disclaimer","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["This spreadsheet relating to the updates to Guideline A-5 “Atmospheric Emissions from Stationary Combustion Turbines” has been prepared by the Ontario Ministry of the Environment, Conservation and Parks and finalized as of March 2021."]
["The calculations are based on the “Guidelines for the Reduction of Nitrogen Oxide Emissions from Natural Gas-fuelled Stationary Combustion Turbines” published by Environment and Climate Change Canada in 2017."]
["This represents the sample calculations for which the results are shown in Appendix B of Guideline A-5. This document is being shared as a courtesy and should not be relied upon, rather all calculations are the responsibility of the user to be checked and verified."]
["This workbook includes two (2) calculation worksheets, B.1 for \"Power Generation\" that includes both simple cycle and combined cycle configurations, and B.2 for \"Cogeneration\" (CHP) that likewise includes both simple cycle and combined cycle configurations."]
["Any concerns, comments, identification of errors or suggestions for improvement should be communicated to Steven Law, P. Eng. by email at Steven.Law@ontario.ca."]

{"sheet":"B.1 Power Generation","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Parameter","Units","B.1-Site 1","B.1-Site 2","B.1-Site 3","B.1-Site 4"]
["Heat input to combustion turbine","GJ/hr",1,40,190,400]
["Heat input to combustion turbine","MW",{"$f":"C2/3.6","v":0.27777777777777779},{"$f":"D2/3.6","v":11.111111111111111},{"$f":"E2/3.6","v":52.777777777777779},{"$f":"F2/3.6","v":111.11111111111111}]
["Heat input to auxiliary burner(s)","GJ/hr",0,0,0,270]
["Heat input to auxiliary burner(s)","MW",{"$f":"C4/3.6","v":0},{"$f":"D4/3.6","v":0},{"$f":"E4/3.6","v":0},{"$f":"F4/3.6","v":75}]
["Cycle configuration","-","simple","simple","simple","combined"]
["Power output, combustion turbine","MW",7.0000000000000007E-2,3,15,45]
["Power output, Rankine cycle turbine","MW",0,0,0,55]
["Total power generation/output","MW",{"$f":"C7+C8","v":7.0000000000000007E-2},{"$f":"D7+D8","v":3},{"$f":"E7+E8","v":15},{"$f":"F7+F8","v":100}]
["Thermal efficiency (Equation 10)","%",{"$f":"C7/C3","v":0.252},{"$f":"D7/D3","v":0.27},{"$f":"E7/E3","v":0.28421052631578947},{"$f":"(F7+F8)/(F3+F5)","v":0.53731343283582089}]
["F-factor for natural gas on a dry basis","DSm³/GJ",240,240,240,240]
["Output-based NOx emission limit (Table 1)","g/GJ",290,500,140,140]
["Calculated maximum NOx emission rate (Equation 5)","g/hr",{"$f":"(C7*3.6)*C12","v":73.080000000000013},{"$f":"(D7*3.6)*D12","v":5400},{"$f":"(E7*3.6)*E12","v":7560},{"$f":"((F7+F8)*3.6)*F12","v":50400}]
["Calculated maximum NOx emission concentration (Equation 2)","ppmv",{"$f":"C13/C11/(C2+C4)/(0.00188)*(20.9-15)/20.9","v":45.723047948691843},{"$f":"D13/D11/(D2+D4)/(0.00188)*(20.9-15)/20.9","v":84.463758525908574},{"$f":"E13/E11/(E2+E4)/(0.00188)*(20.9-15)/20.9","v":24.894581460267787},{"$f":"F13/F11/(F2+F4)/(0.00188)*(20.9-15)/20.9","v":47.064382860207765}]
["Applicable NOx emission limit (Table 2 or Equation 8) (note 1)","ppmv",42,75,{"$f":"E14","v":24.894581460267787},{"$f":"F14","v":47.064382860207765}]
["95% of NOx as NO","ppmv",{"$f":"C15*0.95/46.01*30.1","v":26.10280373831776},{"$f":"D15*0.95/46.01*30.1","v":46.612149532710283},{"$f":"E15*0.95/46.01*30.1","v":15.471866047736521},{"$f":"F15*0.95/46.01*30.1","v":29.250294020596417}]
["5% of NOx as NO2","ppmv",{"$f":"C15*0.05","v":2.1},{"$f":"D15*0.05","v":3.75},{"$f":"E15*0.05","v":1.2447290730133895},{"$f":"F15*0.05","v":2.3532191430103881}]
[]
["Note 1: Table 2 applies for Sites 1 and 2, whereas Equation 8 applies for Sites 3 and 4"]

{"sheet":"B.2 Cogeneration","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Parameter","Units","B.2-Site 1","B.2-Site 2","B.2-Site 3","B.2-Site 4"]
["Heat input to combustion turbine","GJ/hr",1,40,190,400]
["Heat input to combustion turbine","MW",{"$f":"C2/3.6","v":0.27777777777777779},{"$f":"D2/3.6","v":11.111111111111111},{"$f":"E2/3.6","v":52.777777777777779},{"$f":"F2/3.6","v":111.11111111111111}]
["Heat input to auxiliary burner(s)","GJ/hr",0,0,90,270]
["Heat input to auxiliary burner(s)","MW",{"$f":"C4/3.6","v":0},{"$f":"D4/3.6","v":0},{"$f":"E4/3.6","v":25},{"$f":"F4/3.6","v":75}]
["Cycle configuration","-","simple","simple","simple","combined"]
["Power output, combustion turbine","MW",7.0000000000000007E-2,3,15,45]
["Power output, Rankine cycle turbine","MW",0,0,0,55]
["Total power generation/output","MW",{"$f":"C7+C8","v":7.0000000000000007E-2},{"$f":"D7+D8","v":3},{"$f":"E7+E8","v":15},{"$f":"F7+F8","v":100}]
["Heat recovery, combustion turbine","MW",0.14000000000000001,5.7,32,30]
["Heat recovery, auxiliary burner(s)","MW",0,0,18,30]
["Total heat recovery / output","MW",{"$f":"C10+C11","v":0.14000000000000001},{"$f":"D10+D11","v":5.7},{"$f":"E10+E11","v":50},{"$f":"F10+F11","v":60}]
["Power efficiency","%",{"$f":"C7/C3","v":0.252},{"$f":"D7/D3","v":0.27},{"$f":"E7/E3","v":0.28421052631578947},{"$f":"(F7+F8)/(F3+F5)","v":0.53731343283582089}]
["Heat recovery efficiency","%",{"$f":"(C10+C11)/(C3+C5)","v":0.504},{"$f":"(D10+D11)/(D3+D5)","v":0.51300000000000001},{"$f":"(E10+E11)/(E3+E5)","v":0.6428571428571429},{"$f":"(F10+F11)/(F3+F5)","v":0.32238805970149254}]
["Thermal efficiency (Equation 10)","%",{"$f":"(C7+C10+C11)/(C3+C5)","v":0.75600000000000001},{"$f":"(D7+D10+D11)/(D3+D5)","v":0.78299999999999992},{"$f":"(E7+E10+E11)/(E3+E5)","v":0.83571428571428574},{"$f":"(F7+F8+F10+F11)/(F3+F5)","v":0.85970149253731343}]
["Cogeneration coefficient","g/GJ",40,40,40,40]
["F-factor for natural gas on a dry basis","DSm³/GJ",240,240,240,240]
["Output-based NOx emission limit (Table 1)","g/GJ",290,500,140,85]
["Calculated maximum NOx emission rate (Equation 6)","g/hr",{"$f":"(C7*3.6)*C18+(C10+C11)*3.6*C16","v":93.240000000000009},{"$f":"(D7*3.6)*D18+(D10+D11)*3.6*D16","v":6220.8},{"$f":"(E7*3.6)*E18+(E10+E11)*3.6*E16","v":14760},{"$f":"(F7*3.6)*F18+(F10+F11)*3.6*F16","v":22410}]
["Calculated maximum NOx emission concentration (Equation 2)","ppmv",{"$f":"C19/C17/(C2+C4)/(0.00188)*(20.9-15)/20.9","v":58.336302555227519},{"$f":"D19/D17/(D2+D4)/(0.00188)*(20.9-15)/20.9","v":97.302249821846686},{"$f":"E19/E17/(E2+E4)/(0.00188)*(20.9-15)/20.9","v":32.981086662497631},{"$f":"F19/F17/(F2+F4)/(0.00188)*(20.9-15)/20.9","v":20.926841664628089}]
["Applicable NOx emission limit (Table 3 or Equation 8) (note 1)","ppmv",60,100,{"$f":"E20","v":32.981086662497631},{"$f":"F20","v":20.926841664628089}]
["95% of NOx as NO","ppmv",{"$f":"C21*0.95/46.01*30.1","v":37.289719626168228},{"$f":"D21*0.95/46.01*30.1","v":62.149532710280383},{"$f":"E21*0.95/46.01*30.1","v":20.497591243514886},{"$f":"F21*0.95/46.01*30.1","v":13.005934305586615}]
["5% of NOx as NO2","ppmv",{"$f":"C21*0.05","v":3},{"$f":"D21*0.05","v":5},{"$f":"E21*0.05","v":1.6490543331248817},{"$f":"F21*0.05","v":1.0463420832314045}]
[]
["Note 1: Table 3 applies for Sites 1 and 2, whereas Equation 8 applies for Sites 3 and 4"]