{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Form Information","General Application Form","Schedule A","Schedule B","(hidden) Schedule B - Appendix","Schedule C","Schedule D","Schedule E","Schedule F","dropdowns"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":36,"comments":2,"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":"Form Information","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[28,1,28,14],[0,1,0,7],[27,1,27,14],[30,1,30,14],[4,1,4,14],[6,1,6,14],[19,1,19,14],[20,1,20,14],[24,1,24,14],[29,1,29,14],[21,1,21,14],[22,1,22,14],[25,1,25,14],[23,1,23,14],[26,1,26,14],[5,1,5,14]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> FORM INFORMATION"]
[]
[null,"The Cost Containment program is intended to provide relief to facility owners experiencing economic hardship as a result of compliance costs under the Technology Innovation and Emission Reduction Regulation."]
[null,"Note: As a first step in completing the application form, please enter the anticipated 'application date' in the \"General Application Form\" tab as some form functionality is dependant on this input. "]
[null,"All applications must include the following completed forms of this application package to be considered for program designation:"]
[null,"o  General Application Form"]
[null,"o  Schedule A – General Eligibility Assessment"]
[null,"o  Schedule B – Economic Hardship Tests"]
[null,"o  Schedule D – Funding and Benefits Disclosure"]
[null,"o  Schedule E – Previous Cost Containment Program Status Disclosure (as necessary)"]
[null,"o  Schedule F – Agreement and Statement of Certification"]
[]
[null,"An application may also include: "]
[null,"o A completed Schedule C - Additional Cost Containment Allocation (BCCA) Application. "]
[null,"A BCCA application should only be completed if the applicant believes the facility is eligible for BCCA support (review the Standard for Developing Benchmarks for eligibility information). "]
[null,"Otherwise it may be left blank."]
[null,"Each applicant must also submit the following documents as part of the application package:"]
[null,"Attachment 1 – Financial Statements - facility-specific financial statements for three calendar years of operation occurring immediately prior to the application submission date (subject to audit as per requirements of the Standard for Validation, Verification and Audit). "]
[null,"Attachment 2 – Financial Forecast - facility-specific financial forecast for each calendar year the applicant is applying for cost containment status."]
[null,"Attachment 3 - Net Electricity Import and Export Forecast (if applicable) - annual facility-specific forecast of net electricity import and exports for each calendar year the applicant is applying for cost containment status."]
[null,"Attachment 4 - Net Heat Import or Export Forecast (if applicable) - annual facility-specific forecast of net heat imports and exports for each calendar year the applicant is applying for cost containment status."]
[null,"Attachment 5 - Net Hydrogen Import and Export Forecast (if applicable) - annual facility-specific forecast of net hydrogen imports and exports for each calendar year the applicant is applying for cost containment status. "]
[null,"Attachment 6 – Emissions Reduction Plan "]
[null,"Attachment 7 – Statement of Validation for the Emissions Reduction Plan"]
[null,"Requirements for preparing financial statements, all applicable forecasts, and the emissions reduction plan for purposes of the application are provided in the Standard for Developing Benchmarks and the Standard for Validation, Verification and Audit. These standards should be carefully reviewed prior to preparing the application. "]
[null,"Application Timelines: The deadline to submit a cost containment program application is 23:59:59 March 31 of the year following the first year the cost containment designation is requested.   \n\nApplications will be assessed on a rolling basis.\n"]
[null,"Incomplete application forms, or applications that do not include all of the necessary attachments, will not be evaluated and the applicant will be notified."]
[null,"Submission: Application forms and application attachments must be formally submitted by email to AEP.CCP@gov.ab.ca. An email receipt will be sent to an applicant confirming an application has been received for consideration. "]
[null,"Confidentiality: As per section 28(1) of the Technology Innovation and Emission Reduction Regulation, an applicant may include a letter to the Director with their application requesting  that certain information be kept confidential for a period of 5 years after the date of submission.  The information must be commercial, financial scientific or technical information that would reveal proprietary business, competitive, or trade secret information about a specific facility, technology or corporate initiative for the confidentiality clause to be considered.  The information must also reveal proprietary business, competitive, or trade secret information about a specific facility, technology or corporate initiative.  To address a request for confidentiality, a director is required to consider the impact to the organization’s competitive or negotiating position or the resulting undue financial loss or gain.\n\nConfidentiality requests for this type of information fall under section 16(1) of Alberta’s Freedom of Information and Protection of Privacy Act, which states that the head of the public body must refuse to disclose information that meets the above requirements.  To assure appropriate considerations can be made to address a confidentiality request, it is strongly recommended that each applicant include a letter to the director, as an additional attachment to their application package, that would demonstrate why the information should be kept confidential.\n\nInformation submitted as part of an application will be stored on a secure Government of Alberta server for a period of up to 5 years. "]

{"sheet":"General Application Form","index":1,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[13,3,13,14],[15,13,15,14],[0,1,0,7],[5,1,5,3],[5,6,5,14],[8,1,8,2],[11,3,11,7],[11,10,11,14],[17,3,17,4],[17,9,17,10],[19,3,19,4],[19,9,19,14],[15,3,15,5],[46,1,46,3],[46,6,46,8],[49,1,49,2],[23,1,23,9],[31,3,31,6],[31,9,31,12],[26,3,26,14],[28,3,28,5],[28,13,28,14],[34,1,34,5],[37,1,37,5],[40,1,40,5],[43,6,43,8],[43,1,43,3],[71,1,71,2],[74,1,79,14],[70,1,70,14],[52,1,52,2],[55,1,58,14],[61,1,68,14]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> GENERAL APPLICATION FORM"]
[]
[null,"Application Date (mm/dd/yyyy)",null,null,null,null,"Legal Business Name of Applicant"]
[]
[]
[null,"Is this business licensed in Alberta? (Yes/No)"]
[null,"select answer…"]
[]
[null,"Facility Owner Representative Contact Information (Responsible Official)"]
[null,null,"Name:",null,null,null,null,null,null,"Title:"]
[]
[null,null,"Address:"]
[]
[null,null,"City / Town:",null,null,null,null,null,"Province:",null,null,null,"Postal Code:"]
[]
[null,null,"Phone (office):",null,null,null,null,null,"Phone (mobile):"]
[]
[null,null,"Fax:",null,null,null,null,null,"Email:"]
[]
[]
[null,"Facility Name"]
[]
[]
[null,"Facility Mailing Address"]
[null,null,"Address:"]
[]
[null,null,"City / Town:",null,null,null,null,null,"Province:",null,null,null,"Postal Code:"]
[]
[null,"Facility Geographic Coordinates (longitude and latitude in NAD 83)"]
[null,null,"Longitude:",null,null,null,null,null,"Latitude:"]
[]
[null,"Nearest City / District / Municipality / County to Facility"]
[]
[]
[null,"Facility Operator (if different than applicant)"]
[]
[]
[null,"Sector"]
[]
[]
[null,"Facility Completion Date (mm/dd/yyyy)",null,null,null,null,"Date of First Operation (mm/dd/yyyy)"]
[]
[]
[null,"EPEA Approval Number (if applicable)"]
[]
[]
[null,"Facility Nominal Electric Generating Capacity (if applicable)"]
[null,null,null,"MW"]
[]
[null,"Is the facility co-located with another facility? (Yes/No)"]
[null,"select answer…"]
[]
[null,"If yes, please describe"]
[]
[]
[]
[]
[]
[null,"Facility description and outputs (include primary and secondary products)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Is the facility expected to experience any extended shutdowns or major operational changes during the period the applicant is applying for cost containment status? (Yes/No)"]
[null,"select answer…"]
[]
[null,"If yes, please describe"]

{"sheet":"Schedule A","index":2,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,7],[14,1,14,2],[16,1,16,14],[17,1,17,2],[5,1,5,2],[8,1,8,2],[7,1,7,14],[11,1,11,2],[13,1,13,14]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> SCHEDULE A: GENERAL ELIGIBILITY ASSESSMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eligibility"]
[null,"Is the facility a large emitter or opted-in facility regulated under the Technology Innovation and Emissions Reduction Regulation(TIER)?"]
[null,"select answer…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B6=\"select answer…\",\"\",(IF(B6=\"yes\",\"Eligible\",\"Ineligible\")))","v":""}]
[]
[null,"Is the applicant expected to experience economic hardship attributable to the compliance costs incurred in respect of the facility under TIER, as defined within the Technology Innovation and Emission Reduction Regulationand the Standard for Developing Benchmarks?"]
[null,"select answer…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9=\"select answer…\",\"\",(IF(B9=\"yes\",\"Eligible\",\"Ineligible\")))","v":""}]
[]
[null,"Is the facility the subject of receivership, insolvency or bankruptcy proceeds, or proceedings under the Companies’ Creditors Arrangement Act?"]
[null,"select answer…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"select answer…\",\"\",(IF(B12=\"no\",\"Eligible\",\"Ineligible\")))","v":""}]
[]
[null,"Is the applicant in contravention of any compliance obligations to which they are subject under the Envrionmental Protection and Enhancement Act,the Technology Innocation and Emission Regulation,or any other applicable law with respect to the facility?"]
[null,"select answer…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=\"select answer…\",\"\",(IF(B15=\"no\",\"Eligible\",\"Ineligible\")))","v":""}]
[]
[null,"Has the applicant prepared an emissions reduction plan for the facility in accordance with the requirements set out in the Standard for Developing Benchmarks?"]
[null,"select answer…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"select answer…\",\"\",(IF(B18=\"yes\",\"Eligible\",\"Ineligible\")))","v":""}]

{"sheet":"Schedule B","index":3,"n_rows":79,"n_cols":38,"rows_kept":79,"cut":false,"hidden":false,"merged":[[72,5,72,7],[72,10,72,12],[72,15,72,17],[72,20,72,22],[72,25,72,27],[66,5,66,7],[66,10,66,12],[66,15,66,17],[66,20,66,22],[66,25,66,27],[68,5,68,7],[68,10,68,12],[68,15,68,17],[68,20,68,22],[68,25,68,27],[60,5,60,7],[60,10,60,12],[60,15,60,17],[60,20,60,22],[60,25,60,27],[62,5,62,7],[62,10,62,12],[62,15,62,17],[62,20,62,22],[62,25,62,27],[54,5,54,7],[54,10,54,12],[54,15,54,17],[54,20,54,22],[54,25,54,27],[56,5,56,7],[56,10,56,12],[56,15,56,17],[56,20,56,22],[56,25,56,27],[48,5,48,7],[48,10,48,12],[48,15,48,17],[48,20,48,22],[48,25,48,27],[50,5,50,7],[50,10,50,12],[50,15,50,17],[50,20,50,22],[50,25,50,27],[44,5,44,7],[44,10,44,12],[44,15,44,17],[44,20,44,22],[44,25,44,27],[46,5,46,7],[46,10,46,12],[46,15,46,17],[46,20,46,22],[46,25,46,27],[42,5,42,7],[42,10,42,12],[42,15,42,17],[42,20,42,22],[42,25,42,27],[40,5,40,7],[40,10,40,12],[40,15,40,17],[40,20,40,22],[40,25,40,27],[36,30,36,32],[38,5,38,7],[38,10,38,12],[38,15,38,17],[38,20,38,22],[38,25,38,27],[34,5,34,7],[34,10,34,12],[34,15,34,17],[34,20,34,22],[34,25,34,27],[36,5,36,7],[36,10,36,12],[36,15,36,17],[36,20,36,22],[36,25,36,27],[28,30,28,32],[26,5,26,7],[26,10,26,12],[26,15,26,17],[26,20,26,22],[26,25,26,27],[30,5,30,7],[30,10,30,12],[30,15,30,17],[30,20,30,22],[30,25,30,27],[20,30,20,32],[22,5,22,7],[22,10,22,12],[22,15,22,17],[22,20,22,22],[22,25,22,27],[18,5,18,7],[18,10,18,12],[18,15,18,17],[18,20,18,22],[18,25,18,27],[20,5,20,7],[20,10,20,12],[20,15,20,17],[20,20,20,22],[20,25,20,27],[12,25,12,27],[14,5,14,7],[14,10,14,12],[14,15,14,17],[14,20,14,22],[14,25,14,27],[16,5,16,7],[16,10,16,12],[16,15,16,17],[16,20,16,22],[16,25,16,27],[72,1,73,3],[0,1,0,7],[3,20,3,22],[3,25,3,27],[3,5,3,15],[7,5,7,7],[7,10,7,12],[7,15,7,17],[7,20,7,22],[7,25,7,27],[8,5,8,7],[8,10,8,12],[8,15,8,17],[8,20,8,22],[8,25,8,27],[10,5,10,7],[10,10,10,12],[10,15,10,17],[10,20,10,22],[10,25,10,27],[12,5,12,7],[12,10,12,12],[12,15,12,17],[12,20,12,22],[24,5,24,7],[24,10,24,12],[24,15,24,17],[24,20,24,22],[24,25,24,27],[32,5,32,7],[32,10,32,12],[32,15,32,17],[32,20,32,22],[32,25,32,27],[28,5,28,7],[28,10,28,12],[28,15,28,17],[28,20,28,22],[28,25,28,27]]}
[null,"Cost Containment Designation Application Package"]
[null,"> SCHEDULE B: ECONOMIC HARDSHIP TESTS"]
[]
[null,"NAICS Industry Group (select)",null,null,null,"Conventional Oil and Gas Extraction "]
[]
[]
[null,"Emission Information",null,null,null,"Certified Actuals",null,null,null,null,"Forcasted "]
[]
[null,null,null,null,null,{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},null,null,null,null,{"$f":"F9+1","v":0},null,null,null,null,{"$f":"K9+1","v":1},null,null,null,null,{"$f":"P9+1","v":2},null,null,null,null,{"$f":"U9+1","v":3}]
[]
[null,"Total Regulated Emissions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq",null,null,null,null,"Indirect Allocations"]
[]
[null,"Imported Electricity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MWh",null,null,null,null,"Electricity benchmark for the current year:",null,0.37]
[]
[null,"Imported Heat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GJ",null,null,null,null,"Heat",null,6.2990000000000004E-2]
[]
[null,"Imported Hydrogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tonnes",null,null,null,null,"Hydrogen",null,9.0679999999999996]
[]
[null,"Production Item 1"]
[]
[null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Enter Units]"]
[]
[null,"Assigned Facility Specific Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[null,"Product High Performance Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[null,"Production Item 2"]
[]
[null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Enter Units]"]
[]
[null,"Assigned Facility Specific Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[null,"Product High Performance Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[null,"Production Item 3"]
[]
[null,"Quantity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Enter Units]"]
[]
[null,"Assigned Facility Specific Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[null,"Product High Performance Benchmark",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tonnes CO2eq per unit"]
[]
[]
[]
[null,"Change in Alberta Resource Royalty Payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[]
[null,"Gross Sales Revenue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[]
[null,"Fund Credit Price",null,null,null,{"$f":"VLOOKUP(F9,'(hidden) Schedule B - Appendix'!$B$7:$C$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP(K9,'(hidden) Schedule B - Appendix'!$B$7:$C$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP(P9,'(hidden) Schedule B - Appendix'!$B$7:$C$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP(U9,'(hidden) Schedule B - Appendix'!$B$7:$C$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP(Z9,'(hidden) Schedule B - Appendix'!$B$7:$C$17,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"$ per tonne CO2eq"]
[]
[null,"Profit Margin",null,null,null,{"$f":"IFERROR(VLOOKUP($F$4,'(hidden) Schedule B - Appendix'!$C$22:$D$34,2,FALSE)*100,0)","v":21.3},null,null,null,null,{"$f":"IFERROR(VLOOKUP($F$4,'(hidden) Schedule B - Appendix'!$C$22:$D$34,2,FALSE)*100,0)","v":21.3},null,null,null,null,{"$f":"IFERROR(VLOOKUP($F$4,'(hidden) Schedule B - Appendix'!$C$22:$D$34,2,FALSE)*100,0)","v":21.3},null,null,null,null,{"$f":"IFERROR(VLOOKUP($F$4,'(hidden) Schedule B - Appendix'!$C$22:$D$34,2,FALSE)*100,0)","v":21.3},null,null,null,null,{"$f":"IFERROR(VLOOKUP($F$4,'(hidden) Schedule B - Appendix'!$C$22:$D$34,2,FALSE)*100,0)","v":21.3},null,null,null,null,"%"]
[]
[null,"Compliance Obligations (potential EPCs)"]
[]
[null,"Allowable Emissions (AE)",null,null,null,{"$f":"F21*MAX(F23,F25)+F29*MAX(F31,F33)+F37*MAX(F39,F41)-(F13*$AL$77+F15*$AL$79+F17*$AL$78)","v":0},null,null,null,null,{"$f":"K21*MAX(K23,K25)+K29*MAX(K31,K33)+K37*MAX(K39,K41)-(K13*$AL$77+K15*$AL$79+K17*$AL$78)","v":0},null,null,null,null,{"$f":"P21*MAX(P23,P25)+P29*MAX(P31,P33)+P37*MAX(P39,P41)-(P13*$AL$77+P15*$AL$79+P17*$AL$78)","v":0},null,null,null,null,{"$f":"U21*MAX(U23,U25)+U29*MAX(U31,U33)+U37*MAX(U39,U41)-(U13*$AL$77+U15*$AL$79+U17*$AL$78)","v":0},null,null,null,null,{"$f":"Z21*MAX(Z23,Z25)+Z29*MAX(Z31,Z33)+Z37*MAX(Z39,Z41)-(Z13*$AL$77+Z15*$AL$79+Z17*$AL$78)","v":0},null,null,null,null,"tonnes CO2eq",null,null,null,null,"Allowable Emission =max(sum of products for facility specific benchmark,sum of products for high performance benchmark)- imported electricity/heat/hydrogen"]
[]
[null,"True-up Obligations",null,null,null,{"$f":"IFERROR(F$11-F$55,\"Check the information\")","v":0},null,null,null,null,{"$f":"IFERROR(K$11-K$55,\"Check the information\")","v":0},null,null,null,null,{"$f":"IFERROR(P$11-P$55,\"Check the information\")","v":0},null,null,null,null,{"$f":"IFERROR(U$11-U$55,\"Check the information\")","v":0},null,null,null,null,{"$f":"IFERROR(Z$11-Z$55,\"Check the information\")","v":0},null,null,null,null,"tonnes"]
[]
[null,"Sales Test Ratio"]
[]
[null,"Sales Test Ratio",null,null,null,{"$f":"IFERROR(ROUND(((F57*F49)*(1-VLOOKUP(F9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+F45)/F47,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(((K57*K49)*(1-VLOOKUP(K9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+K45)/K47,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(((P57*P49)*(1-VLOOKUP(P9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+P45)/P47,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(((U57*U49)*(1-VLOOKUP(U9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+U45)/U47,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(((Z57*Z49)*(1-VLOOKUP(Z9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+Z45)/Z47,5),0)","v":0}]
[]
[null,"Does Sales Test Ratio exceed 0.03 threshold?",null,null,null,{"$f":"IF(F61>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(K61>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(P61>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(U61>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(Z61>=0.03,\"Yes\",\"No\")","v":"No"}]
[]
[null,"Profit Test Ratio"]
[]
[null,"Profit Test Ratio",null,null,null,{"$f":"IFERROR(ROUND(F61*100/F51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(K61*100/K51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(P61*100/P51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(U61*100/U51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(Z61*100/Z51,5),0)","v":0}]
[]
[null,"Does Profit Test Ratio exceed 0.10 threshold?",null,null,null,{"$f":"IF(F67>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(K67>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(P67>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(U67>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(Z67>=0.1,\"Yes\",\"No\")","v":"No"}]
[]
[null,"Eligibility Determination"]
[]
[null,"Is the facility eligible for cost containment based on above data?",null,null,null,{"$f":"IF(OR(F63=\"Yes\",F69=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(K63=\"Yes\",K69=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(P63=\"Yes\",P69=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(U63=\"Yes\",U69=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(Z63=\"Yes\",Z69=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table   Established Benchmarks for Products",{"$f":"COLUMN()","v":38}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product","Established benchmark for 2018 (tonnes of CO2e per benchmark unit)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electricity",0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hydrogen",9.0679999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Industrial heat",6.2990000000000004E-2]

{"sheet":"(hidden) Schedule B - Appendix","index":4,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[[1,1,1,5]]}
[null,"Cost Containment Designation Application Package"]
[null,"> SCHEDULE B & C APPENDIX"]
[]
[null,"Table 1: Climate Change Emissions Management Fund (CCEMF) Credit Price Assumption"]
[]
[null,"Year","CCEMF Credit Price ($ per Tonne CO2eq)"]
[null,2015,15]
[null,2018,30]
[null,2019,30]
[null,2020,30]
[null,2021,40]
[null,2022,50]
[null,2023,50]
[null,2024,50]
[null,2025,50]
[null,2026,50]
[null,2027,50]
[]
[null,"Table 2: Net Operating Ratio Margins for Sectors"]
[]
[null,"NAICS","NAICS Industry Group","Net Operating Margin Ratio"]
[null,3251,"Basic Chemical Manufacturing",0.23599999999999999]
[null,3273,"Cement and concrete product manufacturing",0.10100000000000001]
[null,2121,"Coal Mining",0.111]
[null,211113,"Conventional Oil and Gas Extraction ",0.21299999999999999]
[null,3253,"Fertilizers",0.13600000000000001]
[null,5622,"Waste treatment and disposal",2.0299999999999999E-2]
[null,3116,"Meat Product Manufacturing",3.2000000000000001E-2]
[null,211114,"Non-conventional oil extraction",0.27800000000000002]
[null,3314,"Non-ferrous metal (except aluminium) production and processing",8.5999999999999993E-2]
[null,3274,"Lime and gypsum product manufacturing",0.13100000000000001]
[null,3241,"Petroleum and coal product manufacturing",0.125]
[null,4862,"Pipeline Transportation of Natural Gas",6.2E-2]
[null,3221,"Pulp, paper and paperboard mills",0.05]
[]
[null,"Table 3: Corporate Tax Rates for Facilities"]
[]
[null,"Year","Tax Rate"]
[null,2020,0.25]
[null,2021,0.24]
[null,2022,0.23]
[null,2023,0.23]
[null,2024,0.23]
[null,2025,0.23]
[null,2026,0.23]
[null,2027,0.23]
[]
[null,"Table 4: Compliance Flex Valuation"]
[]
[null,"Fixed Credit Use Limit","Credit Price Discount"]
[null,0.6,0.15]

{"sheet":"Schedule C","index":5,"n_rows":66,"n_cols":31,"rows_kept":66,"cut":false,"hidden":false,"merged":[[4,25,4,27],[0,1,0,7],[4,5,4,7],[4,10,4,12],[4,15,4,17],[4,20,4,22],[35,5,35,7],[35,10,35,12],[35,15,35,17],[35,20,35,22],[35,25,35,27],[5,5,5,7],[5,10,5,12],[5,15,5,17],[5,20,5,22],[5,25,5,27],[39,5,39,7],[39,10,39,12],[39,15,39,17],[39,20,39,22],[39,25,39,27],[37,5,37,7],[37,10,37,12],[37,15,37,17],[37,20,37,22],[37,25,37,27],[47,5,47,7],[47,10,47,12],[47,15,47,17],[47,20,47,22],[47,25,47,27],[43,5,43,7],[43,10,43,12],[43,15,43,17],[43,20,43,22],[43,25,43,27],[45,5,45,7],[45,10,45,12],[45,15,45,17],[45,20,45,22],[45,25,45,27],[18,5,18,7],[18,10,18,12],[18,15,18,17],[18,20,18,22],[18,25,18,27],[20,25,20,27],[24,5,24,7],[24,10,24,12],[24,15,24,17],[24,20,24,22],[24,25,24,27],[20,5,20,7],[20,10,20,12],[20,15,20,17],[20,20,20,22],[30,1,31,3],[30,5,30,7],[30,10,30,12],[30,15,30,17],[30,20,30,22],[30,25,30,27],[26,5,26,7],[26,10,26,12],[26,15,26,17],[26,20,26,22],[26,25,26,27]]}
[null,"Cost Containment Designation Application Package"]
[null,"> SCHEDULE C – ADDITIONAL COST CONTAINMENT ALLOCATION (BCCA) APPLICATION "]
[]
[null,"Application to Request a BCCA"]
[]
[null,null,null,null,null,{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},null,null,null,null,{"$f":"F6+1","v":0},null,null,null,null,{"$f":"K6+1","v":1},null,null,null,null,{"$f":"P6+1","v":2},null,null,null,null,{"$f":"U6+1","v":3}]
[]
[null,"Request BCCAs"]
[]
[]
[null,"BCCAs Requested"]
[]
[]
[null,"Products"]
[]
[]
[null,"BCCA Sales Test Ratio"]
[]
[null,"BCCA Sales Test Ratio",null,null,null,{"$f":"IFERROR(('Schedule B'!F61*'Schedule B'!F47-'Schedule B'!F57*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)*'Schedule B'!F49)/'Schedule B'!F47,0)","v":0},null,null,null,null,{"$f":"IFERROR(('Schedule B'!K61*'Schedule B'!K47-'Schedule B'!K57*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)*'Schedule B'!K49)/'Schedule B'!K47,0)","v":0},null,null,null,null,{"$f":"IFERROR(('Schedule B'!P61*'Schedule B'!P47-'Schedule B'!P57*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)*'Schedule B'!P49)/'Schedule B'!P47,0)","v":0},null,null,null,null,{"$f":"IFERROR(('Schedule B'!U61*'Schedule B'!U47-'Schedule B'!U57*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)*'Schedule B'!U49)/'Schedule B'!U47,0)","v":0},null,null,null,null,{"$f":"IFERROR(('Schedule B'!Z61*'Schedule B'!Z47-'Schedule B'!Z57*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)*'Schedule B'!Z49)/'Schedule B'!Z47,0)","v":0}]
[]
[null,"Does the BCCA Sales Test Ratio exceed 0.03 threshold?",null,null,null,{"$f":"IF(F19>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(K19>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(P19>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(U19>=0.03,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(Z19>=0.03,\"Yes\",\"No\")","v":"No"}]
[]
[null," BCCA Profit Test Ratio"]
[]
[null,"BCCA Profit Test Ratio",null,null,null,{"$f":"IFERROR(ROUND(F19*100/'Schedule B'!F51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(K19*100/'Schedule B'!K51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(P19*100/'Schedule B'!P51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(U19*100/'Schedule B'!U51,5),0)","v":0},null,null,null,null,{"$f":"IFERROR(ROUND(Z19*100/'Schedule B'!Z51,5),0)","v":0}]
[]
[null,"Does the BCCA Profit Test Ratio exceed 0.10 threshold?",null,null,null,{"$f":"IF(F25>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(K25>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(P25>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(U25>=0.1,\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(Z25>=0.1,\"Yes\",\"No\")","v":"No"}]
[]
[null,"Eligibility Determination"]
[]
[null,"Is the facility eligible for additional cost containment allocations?",null,null,null,{"$f":"IF(OR(F21=\"Yes\",F27=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(K21=\"Yes\",K27=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(P21=\"Yes\",P27=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(U21=\"Yes\",U27=\"Yes\"),\"Yes\",\"No\")","v":"No"},null,null,null,null,{"$f":"IF(OR(Z21=\"Yes\",Z27=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[]
[]
[null,"Revenue Ratios by Product"]
[]
[null,"Production Item 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of total Gross Revenue"]
[]
[null,"Production Item 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of total Gross Revenue"]
[]
[null,"Production Item 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of total Gross Revenue"]
[]
[null,"Requested BCCAs"]
[]
[null,"Production Item 1",null,null,null,{"$f":"IFERROR(IF(F$31=\"No\",\"\",F51),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(K$31=\"No\",\"\",K51),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(P$31=\"No\",\"\",P51),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(U$31=\"No\",\"\",U51),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(Z$31=\"No\",\"\",Z51),)","v":""},null,null,null,null,{"$f":"CONCATENATE(\"tonnes of CO2 per \",'Schedule B'!AE21)","v":"tonnes of CO2 per [Enter Units]"}]
[]
[null,"Production Item 2",null,null,null,{"$f":"IFERROR(IF(F$31=\"No\",\"\",F52),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(K$31=\"No\",\"\",K52),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(P$31=\"No\",\"\",P52),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(U$31=\"No\",\"\",U52),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(Z$31=\"No\",\"\",Z52),)","v":""},null,null,null,null,{"$f":"CONCATENATE(\"tonnes of CO2 per \",'Schedule B'!AE29)","v":"tonnes of CO2 per [Enter Units]"}]
[]
[null,"Production Item 3",null,null,null,{"$f":"IFERROR(IF(F$31=\"No\",\"\",F53),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(K$31=\"No\",\"\",K53),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(P$31=\"No\",\"\",P53),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(U$31=\"No\",\"\",U53),)","v":""},null,null,null,null,{"$f":"IFERROR(IF(Z$31=\"No\",\"\",Z53),)","v":""},null,null,null,null,{"$f":"CONCATENATE(\"tonnes of CO2 per \",'Schedule B'!AE37)","v":"tonnes of CO2 per [Enter Units]"}]
[]
[]
[null,"BCCA_1_n",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"BCCA_2_n",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"BCCA_3_n",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,"Updated Compliance Obligation",null,null,null,{"$f":"'Schedule B'!F57-(F51*'Schedule B'!F21+'Schedule C'!F52*'Schedule B'!F29+'Schedule C'!F53*'Schedule B'!F37)","v":0},null,null,null,null,{"$f":"'Schedule B'!K57-(K51*'Schedule B'!K21+'Schedule C'!K52*'Schedule B'!K29+'Schedule C'!K53*'Schedule B'!K37)","v":0},null,null,null,null,{"$f":"'Schedule B'!P57-(P51*'Schedule B'!P21+'Schedule C'!P52*'Schedule B'!P29+'Schedule C'!P53*'Schedule B'!P37)","v":0},null,null,null,null,{"$f":"'Schedule B'!U57-(U51*'Schedule B'!U21+'Schedule C'!U52*'Schedule B'!U29+'Schedule C'!U53*'Schedule B'!U37)","v":0},null,null,null,null,{"$f":"'Schedule B'!Z57-(Z51*'Schedule B'!Z21+'Schedule C'!Z52*'Schedule B'!Z29+'Schedule C'!Z53*'Schedule B'!Z37)","v":0}]
[null,"A_n",null,null,null,{"$f":"(F54*'Schedule B'!F49)*(1-VLOOKUP('Schedule B'!F9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!F45-('Schedule B'!F49*F54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!D37+'Schedule D'!I37+'Schedule D'!N37))-0.03*'Schedule B'!F47","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(K54*'Schedule B'!K49)*(1-VLOOKUP('Schedule B'!K9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!K45-('Schedule B'!K49*K54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!E37+'Schedule D'!J37+'Schedule D'!O37))-0.03*'Schedule B'!K47","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(P54*'Schedule B'!P49)*(1-VLOOKUP('Schedule B'!P9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!P45-('Schedule B'!P49*P54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!F37+'Schedule D'!K37+'Schedule D'!P37))-0.03*'Schedule B'!P47","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(U54*'Schedule B'!U49)*(1-VLOOKUP('Schedule B'!U9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!U45-('Schedule B'!U49*U54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!G37+'Schedule D'!L37+'Schedule D'!Q37))-0.03*'Schedule B'!U47","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(Z54*'Schedule B'!Z49)*(1-VLOOKUP('Schedule B'!Z9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!Z45-('Schedule B'!Z49*Z54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!H37+'Schedule D'!M37+'Schedule D'!R37))-0.03*'Schedule B'!Z47","v":{"$error":"#N/A"}}]
[null,"B_n",null,null,null,{"$f":"(F54*'Schedule B'!F49)*(1-VLOOKUP('Schedule B'!F9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!F45-('Schedule B'!F49*F54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!D37+'Schedule D'!I37+'Schedule D'!N37))-0.1*'Schedule B'!F47*'Schedule B'!F51*0.01","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(K54*'Schedule B'!K49)*(1-VLOOKUP('Schedule B'!K9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!K45-('Schedule B'!K49*K54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!E37+'Schedule D'!J37+'Schedule D'!O37))-0.1*'Schedule B'!K47*'Schedule B'!K51*0.01","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(P54*'Schedule B'!P49)*(1-VLOOKUP('Schedule B'!P9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!P45-('Schedule B'!P49*P54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!F37+'Schedule D'!K37+'Schedule D'!P37))-0.1*'Schedule B'!P47*'Schedule B'!P51*0.01","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(U54*'Schedule B'!U49)*(1-VLOOKUP('Schedule B'!U9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!U45-('Schedule B'!U49*U54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!G37+'Schedule D'!L37+'Schedule D'!Q37))-0.1*'Schedule B'!U47*'Schedule B'!U51*0.01","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"(Z54*'Schedule B'!Z49)*(1-VLOOKUP('Schedule B'!Z9,'(hidden) Schedule B - Appendix'!$B$38:$C$46,2,FALSE))+'Schedule B'!Z45-('Schedule B'!Z49*Z54*'(hidden) Schedule B - Appendix'!$C$51*(1-'(hidden) Schedule B - Appendix'!$B$51)+('Schedule D'!H37+'Schedule D'!M37+'Schedule D'!R37))-0.1*'Schedule B'!Z47*'Schedule B'!Z51*0.01","v":{"$error":"#N/A"}}]
[null,"C_n",null,null,null,{"$f":"MAX(F55,F56)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"MAX(K55,K56)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"MAX(P55,P56)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"MAX(U55,U56)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"MAX(Z55,Z56)","v":{"$error":"#N/A"}}]
[null,"BCCA_1_n+1",null,null,null,{"$f":"F51+(1/'Schedule B'!F$49)*'Schedule C'!F57*'Schedule C'!F36*(1/'Schedule B'!F21)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"K51+(1/'Schedule B'!K$49)*'Schedule C'!K57*'Schedule C'!K36*(1/'Schedule B'!K21)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"P51+(1/'Schedule B'!P$49)*'Schedule C'!P57*'Schedule C'!P36*(1/'Schedule B'!P21)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"U51+(1/'Schedule B'!U$49)*'Schedule C'!U57*'Schedule C'!U36*(1/'Schedule B'!U21)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"Z51+(1/'Schedule B'!Z$49)*'Schedule C'!Z57*'Schedule C'!Z36*(1/'Schedule B'!Z21)","v":{"$error":"#N/A"}}]
[null,"BCCA_2_n+1",null,null,null,{"$f":"F52+(1/'Schedule B'!F$49)*'Schedule C'!F57*'Schedule C'!F38*(1/'Schedule B'!F29)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"K52+(1/'Schedule B'!K$49)*'Schedule C'!K57*'Schedule C'!K38*(1/'Schedule B'!K29)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"P52+(1/'Schedule B'!P$49)*'Schedule C'!P57*'Schedule C'!P38*(1/'Schedule B'!P29)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"U52+(1/'Schedule B'!U$49)*'Schedule C'!U57*'Schedule C'!U38*(1/'Schedule B'!U29)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"Z52+(1/'Schedule B'!Z$49)*'Schedule C'!Z57*'Schedule C'!Z38*(1/'Schedule B'!Z29)","v":{"$error":"#N/A"}}]
[null,"BCCA_3_n+1",null,null,null,{"$f":"F53+(1/'Schedule B'!F$49)*'Schedule C'!F57*'Schedule C'!F40*(1/'Schedule B'!F37)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"K53+(1/'Schedule B'!K$49)*'Schedule C'!K57*'Schedule C'!K40*(1/'Schedule B'!K37)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"P53+(1/'Schedule B'!P$49)*'Schedule C'!P57*'Schedule C'!P40*(1/'Schedule B'!P37)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"U53+(1/'Schedule B'!U$49)*'Schedule C'!U57*'Schedule C'!U40*(1/'Schedule B'!U37)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"Z53+(1/'Schedule B'!Z$49)*'Schedule C'!Z57*'Schedule C'!Z40*(1/'Schedule B'!Z37)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Request BCCAs",null,null,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false]
[null,"Products",null,1,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false]
[null,null,null,2,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false]
[null,null,null,3,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false,null,null,null,null,false]

{"sheet":"Schedule D","index":6,"n_rows":81,"n_cols":18,"rows_kept":81,"cut":false,"hidden":false,"merged":[[63,1,63,3],[64,1,64,3],[57,1,57,3],[57,4,57,9],[66,1,66,3],[64,10,64,12],[65,10,65,12],[62,10,62,12],[63,10,63,12],[60,10,60,12],[61,10,61,12],[58,10,58,12],[59,10,59,12],[65,4,65,9],[65,1,65,3],[58,1,58,3],[59,1,59,3],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[62,4,62,9],[63,4,63,9],[64,4,64,9],[24,13,24,17],[55,13,55,15],[56,13,56,15],[57,13,57,15],[58,13,58,15],[78,10,78,11],[79,10,79,11],[56,10,56,12],[57,10,57,12],[55,10,55,12],[59,13,59,15],[60,13,60,15],[61,13,61,15],[62,13,62,15],[63,13,63,15],[64,13,64,15],[65,13,65,15],[73,10,73,11],[66,13,66,15],[69,12,69,13],[70,12,70,13],[71,12,71,13],[72,12,72,13],[73,12,73,13],[4,1,4,14],[5,1,5,14],[6,1,6,14],[16,5,16,6],[16,7,16,9],[16,10,16,12],[12,7,12,9],[13,7,13,9],[14,7,14,9],[11,1,11,2],[11,7,11,9],[10,7,10,9],[11,5,11,6],[11,3,11,4],[12,1,12,2],[13,1,13,2],[14,1,14,2],[0,1,0,7],[7,1,7,2],[51,1,51,14],[52,1,52,2],[10,3,10,4],[10,5,10,6],[10,10,10,12],[11,10,11,12],[12,10,12,12],[13,10,13,12],[14,10,14,12],[14,3,14,4],[14,5,14,6],[15,1,15,2],[12,3,12,4],[12,5,12,6],[13,3,13,4],[20,7,20,9],[13,5,13,6],[10,1,10,2],[15,5,15,6],[15,7,15,9],[15,10,15,12],[16,3,16,4],[17,5,17,6],[17,7,17,9],[18,3,18,4],[18,5,18,6],[18,7,18,9],[15,3,15,4],[26,1,26,2],[21,10,21,12],[19,10,19,12],[20,10,20,12],[17,10,17,12],[18,10,18,12],[21,3,21,4],[21,5,21,6],[21,7,21,9],[19,3,19,4],[19,5,19,6],[19,7,19,9],[20,3,20,4],[20,5,20,6],[24,3,24,7],[24,8,24,12],[17,3,17,4],[60,1,60,3],[61,1,61,3],[62,1,62,3],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[24,1,25,2],[21,1,21,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[55,4,55,9],[55,1,55,3],[56,1,56,3],[56,4,56,9],[44,1,44,2],[45,1,45,2],[46,1,46,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[47,1,47,2],[48,1,48,2],[48,3,48,17],[39,3,39,17],[40,3,40,17],[41,3,41,17],[42,3,42,17],[43,3,43,17],[44,3,44,17],[45,3,45,17],[46,3,46,17],[47,3,47,17],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[69,4,69,5],[70,4,70,5],[71,4,71,5],[72,4,72,5],[73,4,73,5],[69,1,69,3],[70,1,70,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[75,1,75,3],[80,4,80,5],[74,4,74,5],[75,4,75,5],[76,4,76,5],[77,4,77,5],[78,4,78,5],[79,4,79,5],[80,6,80,7],[69,8,69,9],[70,8,70,9],[71,8,71,9],[72,8,72,9],[73,8,73,9],[74,8,74,9],[75,8,75,9],[80,12,80,13],[80,8,80,9],[69,6,69,7],[70,6,70,7],[71,6,71,7],[72,6,72,7],[73,6,73,7],[74,6,74,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[69,10,69,11],[70,10,70,11],[71,10,71,11],[72,10,72,11],[80,10,80,11],[78,6,78,7],[79,6,79,7],[66,10,66,12],[74,10,74,11],[75,10,75,11],[76,10,76,11],[77,10,77,11],[74,12,74,13],[75,12,75,13],[76,12,76,13],[77,12,77,13],[78,12,78,13],[79,12,79,13],[76,8,76,9],[77,8,77,9],[78,8,78,9],[79,8,79,9],[66,4,66,9]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> SCHEDULE D: FUNDING AND BENEFITS DISCLOSURE"]
[]
[null,"Is the applicant receiving, or will they receive, any benefits or funding attributable to the facility under an initiative of the Government of Alberta, an agency of the Government of Alberta, or a provincial corporation related to:"]
[null,"o  industrial energy efficiency, \no emissions reductions, \no green innovation and technology, or\no renewable energy? \n"]
[]
[null,"select answer…"]
[]
[null,"If yes, please identify for each benefit:"]
[null,"Benefit (name)",null,"Agreement Number\n(if applicable)",null,"Agreement Number\n(if applicable)",null,"Total grant or funding amount ($) committed to the applicant by the Government of Alberta, an agency of the Government of Alberta, or a provincial corporation over the life of the agreement (if applicable)",null,null,"Total funding ($) received by the applicant from any of those three sources prior to the date of application (if applicable)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL",null,{"$f":"SUM(H12:J21)","v":0},null,null,{"$f":"SUM(K12:M21)","v":0}]
[]
[null,"Anticipated calendar year disbursements of the amount identified above, for each benefit, from each of the three sources ($ thousands)"]
[null,"Benefit (name)",null,"Grant or funding amount committed to the applicant by the Government of Alberta",null,null,null,null,"Grant or funding amount committed to the applicant by an agency of the Government of Alberta",null,null,null,null,"Grant or funding amount committed to the applicant by a provincial corporation"]
[null,null,null,{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},{"$f":"D26+1","v":0},{"$f":"E26+1","v":1},{"$f":"F26+1","v":2},{"$f":"G26+1","v":3},{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},{"$f":"I26+1","v":0},{"$f":"J26+1","v":1},{"$f":"K26+1","v":2},{"$f":"L26+1","v":3},{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},{"$f":"N26+1","v":0},{"$f":"O26+1","v":1},{"$f":"P26+1","v":2},{"$f":"Q26+1","v":3}]
[null,{"$f":"IF(B12>0,B12,\"\")","v":""}]
[null,{"$f":"IF(B13>0,B13,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,"TOTAL",null,{"$f":"SUM(D27:D36)","v":0},{"$f":"SUM(E27:E36)","v":0},{"$f":"SUM(F27:F36)","v":0},{"$f":"SUM(G27:G36)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Briefly describe the funding or benefits provided, including intent and outcomes"]
[null,{"$f":"IF(B12>0,B12,\"\")","v":""}]
[null,{"$f":"IF(B13>0,B13,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[]
[null,"Is the applicant receiving, or will they receive, other funding or support from the Government of Alberta, an agency of the Government of Alberta, or a provincial corporation?"]
[null,"select answer…"]
[]
[null,"If yes, please identify for each benefit:"]
[null,"Benefit (name)",null,null,"Description of Benefit Source",null,null,null,null,null,"Total Amount of Public Funding ($)\n(if applicable)",null,null,"Funding ($) Allocated to Facility for which this Application is being Submitted?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"TOTAL",null,null,null,null,null,{"$f":"SUM(K57:M66)","v":0},null,null,{"$f":"SUM(N57:P66)","v":0}]
[]
[null,"Anticipated calendar year disbursements of the public funding amount identified above, for each benefit ($ thousands)"]
[null,"Benefit (name)",null,null,{"$f":"_xlfn.NUMBERVALUE(RIGHT('General Application Form'!$B$6,4),\".\",\",\")-1","v":-1},null,{"$f":"E70+1","v":0},null,{"$f":"G70+1","v":1},null,{"$f":"I70+1","v":2},null,{"$f":"K70+1","v":3}]
[null,{"$f":"IF(B57>0,B57,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,"TOTAL",null,null,{"$f":"SUM(E71:E80)","v":0},null,{"$f":"SUM(G71:G80)","v":0},null,{"$f":"SUM(I71:I80)","v":0},null,{"$f":"SUM(K71:K80)","v":0},null,{"$f":"SUM(M71:M80)","v":0}]

{"sheet":"Schedule E","index":7,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,7],[5,1,5,2],[4,1,4,14],[8,1,9,14],[12,1,12,7],[38,1,41,14],[28,1,31,14],[15,3,15,6],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[21,1,21,2],[19,1,19,2],[20,1,20,2],[17,1,17,2],[18,1,18,2],[15,1,15,2],[16,1,16,2],[34,1,34,14],[35,1,35,2],[24,1,24,2],[24,3,24,6],[25,1,25,2],[25,3,25,6],[20,3,20,6],[21,3,21,6],[22,1,22,2],[22,3,22,6],[23,1,23,2],[23,3,23,6]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> SCHEDULE E: PREVIOUS COST CONTAINMENT PROGRAM STATUS"]
[]
[null,"Has the applicant received cost containment status in one or more previous years in respect to the facility for which this application is being submitted?"]
[null,"select answer…"]
[]
[null,"If yes, which year(s)?"]
[]
[]
[]
[null,"Which relief mechanisms did the applicant receive for the facility as a result of the status?"]
[]
[]
[null,"Additional Allocations Details (if applicable)"]
[null,"Compliance Year(s) Received",null,"Quantify additional allocations received for each applicable year"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Why was the applicant deemed no longer eligible for cost containment status with respect to the facility?"]
[]
[]
[]
[]
[]
[]
[null,"Has the applicant received cost containment status in one or more previous years in respect to any other facility?"]
[null,"select answer…"]
[]
[null,"If yes, name of facility and years cost containment status granted"]

{"sheet":"Schedule F","index":8,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,1,13,3],[13,5,13,6],[13,8,13,10],[0,1,0,7],[5,1,5,3],[5,6,5,14],[9,1,9,14],[10,1,10,3],[10,5,10,6],[10,8,10,10],[10,12,10,14]]}
[null,"Cost Containment Designation Application Package"]
[]
[null,"> SCHEDULE F: AGREEMENT AND STATEMENT OF CERTIFICATION"]
[]
[null,"Application Date (mm/dd/yyyy)",null,null,null,null,"Legal Business Name of Applicant"]
[]
[]
[null,"Signature of Certifying Official"]
[]
[null,"I, the undersigned, having the authority to bind the applicant, hereby certify that I have reviewed the information being submitted in the application forms and supporting documents being submitted. I certify that I have exercised due dilligence to ensure that the information is reasonable and complete, and that, to the best of my knowledge, the historical quantities submitted herein are accurate and that forecasted information is based on reasonable estimates using available data. \n\nI understand that any incomplete question or schedule will result in the application to be considered ineligible and subsequently rejected."]
[]
[null,"Signature of Certifying Official",null,null,null,"Date",null,null,"Full Name",null,null,null,"Title"]
[]
[]
[null,"Signature of Witness",null,null,null,"Date",null,null,"Print Witness Name"]

{"sheet":"dropdowns","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,"Y/N",null,"Provinces"]
[null,"select answer…",null,"AB"]
[null,"Yes",null,"BC"]
[null,"No",null,"MB"]
[null,null,null,"NB"]
[null,null,null,"NL"]
[null,null,null,"NT"]
[null,null,null,"NS"]
[null,null,null,"NU"]
[null,null,null,"ON"]
[null,null,null,"PE"]
[null,null,null,"QC"]
[null,null,null,"SK"]
[null,null,null,"YT"]