{"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 for consultation [EBR #019-2061]."]
["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 is a draft version of sample calculations for which the results are shown in Appendix B of the guideline and has not been peer-reviewed or reviewed for accuracy or completeness. This document is being shared as a courtesy and should not be relied upon."]
["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":17,"n_cols":6,"rows_kept":17,"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 concentration-based NOx emission limit (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}]
["Proposed applicable concentration-based NOx emission limit (Table 2 or Equation 8)","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}]

{"sheet":"B.2 Cogeneration","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"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)*C16","v":78.680000000000007},{"$f":"(D7*3.6)*D18+(D10+D11)*D16","v":5628},{"$f":"(E7*3.6)*E18+(E10+E11)*E16","v":9560},{"$f":"((F7+F8)*3.6)*F18+(F10+F11)*F16","v":33000}]
["Calculated maximum concentration-based NOx emission limit (Equation 2)","ppmv",{"$f":"C19/C17/(C2+C4)/(0.00188)*(20.9-15)/20.9","v":49.226729783840639},{"$f":"D19/D17/(D2+D4)/(0.00188)*(20.9-15)/20.9","v":88.030006108113596},{"$f":"E19/E17/(E2+E4)/(0.00188)*(20.9-15)/20.9","v":21.361733637769472},{"$f":"F19/F17/(F2+F4)/(0.00188)*(20.9-15)/20.9","v":30.815964967993178}]
["Proposed applicable concentration-based NOx emission limit (Table 3 or Equation 8)","ppmv",60,100,{"$f":"E20","v":21.361733637769472},{"$f":"F20","v":30.815964967993178}]
["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":13.276217634688503},{"$f":"F21*0.95/46.01*30.1","v":19.151978227771462}]
["5% of NOx as NO2","ppmv",{"$f":"C21*0.05","v":3},{"$f":"D21*0.05","v":5},{"$f":"E21*0.05","v":1.0680866818884736},{"$f":"F21*0.05","v":1.540798248399659}]