{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Submission","Section A","Section B","SoC","Approval (Internal Use)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":6,"comments":1,"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":"Instructions","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["TECHNOLOGY INNOVATION AND EMISSIONS REDUCTION REGULATION AGGREGATE REFERENCE YEARS NOTIFICATION FORM",null,null,"Hide for internal Python use"]
["Introduction",null,"v24.1","RFY"]
[]
[null,"This form is a requirement for aggregate facilities submitting compliance reports, applications for aggregate facility-specific benchmark, applications for benchmark unit and data reports under the Technology Innovation and Emissions Reduction (TIER) Regulation. \n\nThe person responsible for an aggregate facility that would like to select benchmarking refrence years other than those provided by the default approach must submit this form to EPA by the deadline communicated.\n\nPlease refer to Sections 7, 15  and 23 of the TIER Regulation, the Standard for Completing Greenhouse Gas Compliance and Forecasting Reports and the Standard for Developing Benchmarks for more information regarding reporting requirements."]
["SGER Consolidated Form v3.0 (2012)"]
["Legal Authority"]
[]
[null,"The requirements described above are administered under the authority of the Emissions Management and Climate Resilience Act and the Technology Innovation and Emissions Reduction Regulation."]
[]
["Completion Instructions"]
[]
["1.","Enable macros and use the tabs below to navigate through the sections of this form."]
["2.","More information about certain fields can be found in the form of pop-up comments. To view comments, hover the cursor over each cell with a comment. "]
["3.","Complete all applicable sections of this form. Questions can be submitted to EPA.GHG@gov.ab.ca."]
["4.","For items that are not applicable, the N/A checkbox will be set automatically depending on the content of the associated cell(s). Enter 'N/A' in the field itself if a checkbox is not available."]
["5.","Review and check all calculations and entered values for errors."]
["6.","Ensure that the Statement of Certification has been signed by the designated Certifying Official.  To do so, ask the Certifying Official to open the workbook and double click on the X in the signature box on the SoC tab of the workbook. Make sure this is the last step before submitting the workbook as any further modifications to the workbook will require it to be signed again. "]
["7.","Submit this form electronically as part of the submission package. See \"Submission\" tab for a summary of required submission documents."]
[]
[]
[]
["Submission Address"]
[]
[null,"Submit electronic documents to:"]
[null,"EPA.GHG@gov.ab.ca"]

{"sheet":"Submission","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[42,1,42,4],[43,1,43,4],[0,0,0,5],[32,1,33,4],[36,1,36,4],[40,1,40,4],[39,1,39,4],[38,1,38,4]]}
["Submission Information"]
[]
[]
[null,"Reporting Period"]
[null,null,null,null,null,null,null,1,"Aggregate Reference Years Selection"]
[null,"Currently Approved Reference Years (if applicable):"]
[]
[null,"First:"]
[null,null,null,null,null,null,null,null,null,null,"Eligible Reference Years (All)"]
[null,"Second:"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(YearEntered>=2020,IF(YearEntered<=2025,YearEntered-1,\"\"),\"\")","v":""}]
[null,"Third:",null,null,null,null,null,null,null,null,{"$f":"IF(YearEntered>=2020,IF(YearEntered<=2025,YearEntered,\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(YearEntered>=2020,IF(YearEntered<=2025,YearEntered+1,\"\"),\"\")","v":""}]
[]
[null,"Year of Being Accepted into TIER:",null,"Application Effective Year (if approved)"]
[]
[null,null,null,2024]
[]
[]
[null,"Reference Years Being Requested"]
[]
[null,"After entering the year of being accepted into TIER you will be presented with a set of default reference years."]
[null,"If you would like to have reference years other than default ones overwrite the values offered  below."]
[]
[null,"First:"]
[]
[null,"Second:"]
[]
[null,"Third (optional):"]
[]
[null,"Confidentiality Request"]
[]
[null,"Are you requesting confidentiality under Section 28 of the Technology Innovation and Emissions Reduction (TIER)  Regulation for a portion of the information contained in this report?"]
[]
[null,null,null,null,null,null,null,2,"Yes"]
[null,null,null,null,null,null,null,null,"No"]
[null,"Note: If yes, a written request with appropriate justification and supporting documentation must be submitted with this report. Confidentiality must not be requested for information that is publicly available. EPA will contact you regarding your request. One confidentiality request must be submitted for each facility that is requesting confidentiality.","NOTE: If yes, a written request with appropriate justification and supporting documentation must be submitted with this report. Confidentiality must not be requested for information that is publicly available. Alberta Environment will contact you regarding your request. One confidentiality request must be submitted for each facility that is requesting confidentiality.","NOTE: If yes, a written request with appropriate justification and supporting documentation must be submitted with this report. Confidentiality must not be requested for information that is publicly available. Alberta Environment will contact you regarding your request. One confidentiality request must be submitted for each facility that is requesting confidentiality.","NOTE: If yes, a written request with appropriate justification and supporting documentation must be submitted with this report. Confidentiality must not be requested for information that is publicly available. Alberta Environment will contact you regarding your request. One confidentiality request must be submitted for each facility that is requesting confidentiality."]

{"sheet":"Section A","index":2,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,1,4,3],[6,1,6,3],[10,1,10,3]]}
["Section A: Administrative Information",null,null,null,null,null,"hide"]
[]
[null,"Aggregate Facility Information"]
["Aggregate Facility Name"]
[]
["Aggregate Facility ID"]
[]
[]
[null,"Reporting Company"]
["Reporting Company Legal Name"]
[]
[]
[null,"Reporter"]
["Title",null,null,null,null,null,"Mr."]
[null,null,null,null,null,null,"Ms."]
["First Name",null,"Last Name",null,null,null,"Mrs."]
[null,null,null,null,null,null,"Miss"]
["Position/Title",null,"E-mail Address",null,null,null,"Dr."]
[]
["Telephone Number (eg. 780-123-4567 ext 8)"]
[]
["Mailing Address",null,"City/District/Municipality/County"]
[]
["Province",null,"Postal Code"]
[]
[]
[null,"Certifying Official"]
["Title"]
[]
["First Name",null,"Last Name"]
[]
["Position/Title",null,"E-mail Address"]
[]
["Telephone Number (eg. 780-123-4567 ext 8)"]
[]
["Mailing Address",null,"City/District/Municipality/County"]
[]
["Province",null,"Postal Code"]
[]
[]
[null,"Public Contact"]
["Title"]
[]
["First Name",null,"Last Name"]
[]
["Position/Title",null,"E-mail Address"]
[]
["Telephone Number (eg. 780-123-4567 ext 8)"]
[]
["Mailing Address",null,"City/District/Municipality/County"]
[]
["Province",null,"Postal Code"]

{"sheet":"Section B","index":3,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,109,7]]}
[null,"Section B: Justification for the Reference Years Change Request"]
[]
[null,"Fill out this section if you requesting a change of the previously approved reference years."]
[null,"As per section 7 (6) of the TIER regulation please indicate the reason for seeking reference years change and refer to the pertinent reference documents for the change. "]
[null,"Please provide information supporting the reference years change request (such as production trend analysis, emissions correlation analysis using verbiage, plots, drawings, etc.) in the following space (press Alt + Enter to insert a line break)."]
[null,"Attachments to this document may also be submitted. In such case please provide the list of the attachments in the space below."]

{"sheet":"SoC","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,8,7,10],[0,0,0,11],[1,0,1,11],[7,1,7,2],[7,4,7,6],[5,1,5,2],[11,2,11,6],[13,2,13,6],[25,1,25,10],[16,2,16,3],[16,4,16,10],[17,1,17,10],[22,1,22,2],[19,8,19,10],[22,4,22,6],[24,4,24,6],[24,8,24,10],[19,1,20,6],[24,1,24,2]]}
[]
["Statement of Certification"]
[]
[null,"Aggregate Information"]
[null,"Aggregate Facility Name",null,null,"Aggregate Facility ID"]
[null,{"$f":"'Section A'!B5","v":0},null,null,{"$f":"'Section A'!B7","v":0}]
[null,"Reporting Company Legal Name",null,null,"Application Type",null,null,null,"Application Effective Year"]
[null,{"$f":"'Section A'!B11","v":0},null,null,"Change of Reference Years",null,null,null,{"$f":"Submission!D17","v":2024}]
[]
[]
[null,"New Reference Years Requested"]
[null,null,"Reference Years"]
[null,null,{"$f":"Submission!C25&\" \"&Submission!C27&\" \"&Submission!C29","v":"  "}]
[null,null,{"$f":"IF(AND('[3]Benchmark Unit'!T6=4,'[3]Benchmark Unit'!Y90>1),'[3]Benchmark Unit'!E96,\"\")","v":""}]
[null,"Signature of Certifying Official"]
[]
[null,"I ,",{"$f":"'Section A'!B31&\" \"&'Section A'!D31","v":" "},null,"(Certifying Official), having the authority to bind the reporting company, hereby"]
[null,"certify that I have reviewed the information being submitted, that I have exercised due diligence to ensure that the information is true and complete. I understand and commit to adhere to the regulatory requirements which may result from acceptance of this notification."]
[null,"Signature of Certifying Official (Double click on the X to sign)",null,null,null,null,null,null,"Date (YYYY-MM-DD)"]
[]
[]
[null,"First Name",null,null,"Last Name"]
[null,{"$f":"'Section A'!B31","v":0},null,null,{"$f":"'Section A'!D31","v":0}]
[null,"Position/Title",null,null,"E-mail Address",null,null,null,"Phone Number"]
[null,{"$f":"'Section A'!B33","v":0},null,null,{"$f":"'Section A'!D33","v":0},null,null,null,{"$f":"'Section A'!B35","v":0}]

{"sheet":"Approval (Internal Use)","index":5,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":true,"merged":[[0,0,0,7],[2,6,7,7],[4,1,4,2],[11,1,11,7],[20,1,20,4],[6,1,6,2]]}
["Benchmark Change Request Approval"]
[]
[]
[null,"Aggregate Facility ID",null,null,null,"Approval Effective Year"]
[null,{"$f":"'Section A'!B7:D7","v":0},null,null,null,{"$f":"Submission!D17","v":2024}]
[null,"Reporting Company Legal Name"]
[null,{"$f":"'Section A'!B11","v":0}]
[]
[null,"Summary of Deviation Requests"]
[]
[null,null,null,null,"Director's Comments"]
[]
[]
[null,"Approval "]
[]
[]
[]
[]
[]
[null,"Director, Regulatory and Compliance Approval ",null,null,null,null,"Date"]