{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Calculator","Incentive Payment Estimate","2023 Carbon Tax rates"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":14,"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":"Instructions","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
[]
["CleanBC Industrial Incentive Program (CIIP) \nApplication Support"]
["Introduction"]
[]
[null,"This spreadsheet was created to support reporting operations in applying to the CleanBC Industrial Incentive Program (CIIP). In order to reduce the risk of user-error, formulas have been included in the spreadsheet that will facilitate the calculation of fields that are required as part of the CIIP application. The cells containing formulas have been locked for editing.\n\nThis spreadsheet does not need to be submitted with the CIIP applicaton. The Province may request the spreadsheet or equivalent information from the operator to assess CIIP applications.\n\nThe reporting operation is responsible for the accuracy of all inputs included in the CIIP application. \n\nIf there are any questions related to this spreadsheet, or related to the CleanBC Industrial Incentive Program, please contact GHGRegulator@gov.bc.ca"]
[]
["Instructions for Calculator"]
[]
[null,"This spreadsheet assists in the calculation of emissions allocated between solid and liquid sugar. In order to complete the spreadsheet, you will need facility information about solid and liquid sugar production amounts."]
[]
[null,"This is NOT an application form and is designed, along with the sector-specific guidance document, to support the completion of a CIIP application."]
[]
[]
[]
[null,"Information regarding CIIP can be found at: "]
[null,"CleanBC Industrial Incentive Program"]

{"sheet":"Calculator","index":1,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[31,1,31,10],[0,1,0,8],[29,3,29,5],[4,1,4,10],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[18,1,18,10]]}
[null,"CALCULATOR - DISTRICT ENERGY"]
[]
[null,null,"**Blue cells require an input.** Non-input cells are locked."]
[]
[null,"Purchased Electricity"]
[]
[null,"INPUT each variable listed below:"]
[]
[null,"Purchased Electricity"]
[null,null,null,null,"Electrical Grid:",null,"Amount","Units"]
[null,null,"Emissions Intensity Factor of Grid",null,"Integrated Grid","EIFEl.Grid",{"$f":"VLOOKUP(E11,$C$15:$D$16,2,FALSE)","v":11.3},"tCO2e/GWh"]
[null,null,"Amount of electricity purchased",null,null,"QEL_PURCHASED",null,"GWh"]
[null,null,"Emissions from Purchased Electricity",null,null,"EEL_PURCHASED",{"$f":"IFERROR(IF(($G11*G12)=0,\"\",(G11*G12)),\"\")","v":""},"tCO2e"]
[]
[null,null,"Integrated Grid",11.3]
[null,null,"Fort Nelson Grid",466]
[]
[]
[null,"Calculation of total delivered heat in MWh"]
[]
[]
[null,null,null,"Delivery pressure (bar g)","Delivered Steam (Kg)","Enthalpy (KJ/Kg)","Delivered Heat\n(MWh)"]
[null,null,1,null,null,{"$f":"IFERROR(h_px(D23,1),0)","v":0},{"$f":"E23*F23/3600000","v":0}]
[null,null,2,null,null,{"$f":"IFERROR(h_px(D24,1),0)","v":0},{"$f":"E24*F24/3600000","v":0}]
[null,null,3,null,null,{"$f":"IFERROR(h_px(D25,1),0)","v":0},0]
[null,null,4,null,null,{"$f":"IFERROR(h_px(D26,1),0)","v":0},0]
[null,null,5,null,null,{"$f":"IFERROR(h_px(D27,1),0)","v":0},0]
[null,null,6,null,null,{"$f":"IFERROR(h_px(D28,1),0)","v":0},0]
[null,null,7,null,null,{"$f":"IFERROR(h_px(D29,1),0)","v":0},0]
[null,null,null,"Total Delivered Heat in MWh:",null,null,{"$f":"SUM(G23:G29)","v":0}]
[]
[null,"CIIP Facility Emissions (for estimating incentive payment only; CIIP Facility Emissions are automatically calculated in the CIIP system)"]
[]
[null,"INPUT emissions where applicable:"]
[null,null,"Do not leave blank - enter zero if needed"]
[]
[null,null,null,null,"Emissions","Units"]
[null,null,null,"SWRS Attributable Emissions",null,"tCO2e"]
[null,null,"--  ","CO2 emissions  from Schedule C biomass",null,"tCO2e"]
[null,null,"+  ","Emissions from Purchased Electricity",{"$f":"IF(G13=\"\",\"\",G13)","v":""},"tCO2e"]
[]
[null,null,null,"CIIP Facility Emissions",{"$f":"IF(AND(ISNUMBER(E38),ISNUMBER(E39),ISNUMBER(E40)),E38-E39+E40,0)","v":0},"tCO2e"]

{"sheet":"Incentive Payment Estimate","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,8],[6,1,6,8],[29,1,29,8]]}
[null,"CALCULATOR - INCENTIVE PAYMENT ESTIMATE"]
[]
[]
[null,"Instructions: This tool is designed to help estimate the Incentive payment"]
[null,null,"**Blue cells require an input.** Non-input cells are locked."]
[]
[null,"Fuel information and Carbon Tax paid"]
[]
[null,"Select Fuel name from the list"]
[]
[null,"Fuel Name (dropdown menu)","Fuel Amount","Carbon Tax Rate","Carbon Tax Paid","Maximum Incentive"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B12,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},{"$f":"IFERROR(C12*D12,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,'2023 Carbon Tax rates'!A:E,5,FALSE)*C12,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B13,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},{"$f":"IFERROR(C13*D13,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,'2023 Carbon Tax rates'!A:E,5,FALSE)*C13,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B14,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B14,'2023 Carbon Tax rates'!A:E,5,FALSE)*C14,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B15,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B15,'2023 Carbon Tax rates'!A:E,5,FALSE)*C15,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B16,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B16,'2023 Carbon Tax rates'!A:E,5,FALSE)*C16,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B17,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B17,'2023 Carbon Tax rates'!A:E,5,FALSE)*C17,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B18,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B18,'2023 Carbon Tax rates'!A:E,5,FALSE)*C18,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B19,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B19,'2023 Carbon Tax rates'!A:E,5,FALSE)*C19,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B20,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B20,'2023 Carbon Tax rates'!A:E,5,FALSE)*C20,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B21,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B21,'2023 Carbon Tax rates'!A:E,5,FALSE)*C21,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B22,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B22,'2023 Carbon Tax rates'!A:E,5,FALSE)*C22,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B23,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B23,'2023 Carbon Tax rates'!A:E,5,FALSE)*C23,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B24,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B24,'2023 Carbon Tax rates'!A:E,5,FALSE)*C24,\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B25,'2023 Carbon Tax rates'!A:E,4,FALSE),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(B25,'2023 Carbon Tax rates'!A:E,5,FALSE)*C25,\"\")","v":""}]
[]
[null,null,null,"Total Carbon Tax paid : ",{"$f":"SUM(E12:E25)","v":0}]
[null,null,null,"Incremental Carbon Tax over $30/tCO2e : ",{"$f":"SUM(F12:F25)","v":0}]
[]
[null,"Emissions and Production information"]
[]
[null,"INPUT confidential product threshold"]
[]
[null,"Product name (dropdown menu)","Quantity","Units","Allocated Product Emissions","Emissions Intensity","Benchmark","Threshold","Product Incentive Ratio"]
[null,"Delivered heat",{"$f":"Calculator!G30","v":0},"MWh delivered heat",{"$f":"Calculator!E42","v":0},{"$f":"IFERROR(E35/C35,0)","v":0},6.4899999999999999E-2,null,{"$f":"IF(E35=0,0,IFERROR(IF((H35-F35)/(H35-G35)<0,0,IF((H35-F35)/(H35-G35)>1,1,(H35-F35)/(H35-G35))),0))","v":0}]
[]
[]
[null,"Estimated Incentive Payment : ",{"$f":"I35*E28","v":0}]

{"sheet":"2023 Carbon Tax rates","index":3,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Fuel name","Carbon taxed","Base CT Rate","2023 Tax rate","Incremental CT Rate"]
["Acetylene (Sm^3)","N",{"$f":"D2*30/65","v":0},0,{"$f":"D2-C2","v":0}]
["Agricultural Byproducts (bone dry tonnes)","N",{"$f":"D3*30/65","v":0},0,0]
["Anthracite Coal (tonnes)","Y",66.932307692307702,145.02000000000001,78.087692307692308]
["Asphalt & Road Oil (kilolitres)","Y",95.630769230769232,207.2,111.56923076923076]
["Aviation Gasoline (kilolitres)","Y",73.476923076923072,159.19999999999999,85.723076923076917]
["Aviation Turbo Fuel (kilolitres)","Y",73.476923076923072,159.19999999999999,85.723076923076917]
["Biodiesel (100%) (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["Biogas (captured methane) (Sm^3)","N",0,0,0]
["Bituminous Coal (tonnes)","Y",66.932307692307702,145.02000000000001,78.087692307692308]
["Bone char - organics (tonnes)","N",0,0,0]
["Butane (kilolitres)","Y",53.4,115.7,62.300000000000004]
["Butylene (kilolitres)","N",0,0,0]
["C/D Waste - Plastic (tonnes)","N",0,0,0]
["C/D Waste - Wood (tonnes)","N",0,0,0]
["Cloth (tonnes)","N",0,0,0]
["CNCGs (Sm^3)","N",0,0,0]
["Coal Coke (tonnes)","Y",95.390769230769237,206.68,111.28923076923077]
["Coal/PetCoke  blend (tonnes)","Y",95.390769230769237,206.68,111.28923076923077]
["Coke Oven Gas (Sm^3)","Y",6.4430769230769222E-2,0.1396,7.516923076923078E-2]
["Combustible Tall Oil (kilolitres)","N",0,0,0]
["Crude Oil (kilolitres)","N",0,0,0]
["Crude Sulfate Turpentine (CST) (kilolitres)","N",0,0,0]
["Crude Tall Oil (CTO) (kilolitres)","N",0,0,0]
["Diesel (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["Digester Gas (Sm^3)","N",0,0,0]
["Distilate Fuel Oil No.1 (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["Distilate Fuel Oil No.2 (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["Distilate Fuel Oil No.4 (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["DNCGs (Sm^3)","N",0,0,0]
["Ethane (kilolitres)","Y",30.553846153846155,66.2,35.646153846153851]
["Ethanol (100%) (kilolitres)","N",0,0,0]
["Ethylene (kilolitres)","N",0,0,0]
["E-Waste (tonnes)","N",0,0,0]
["Explosives (tonnes)","N",0,0,0]
["Field Gas (Sm^3)","Y",5.7184615384615389E-2,0.1239,6.6715384615384607E-2]
["Field gas or process vent gas  (Sm^3)","Y",5.7184615384615389E-2,0.1239,6.6715384615384607E-2]
["Foreign Bituminous Coal (tonnes)","Y",66.932307692307702,145.02000000000001,78.087692307692308]
["Isobutane (kilolitres)","Y",53.4,115.7,62.300000000000004]
["Isobutylene (kilolitres)","N",0,0,0]
["Kerosene (kilolitres)","Y",77.446153846153848,167.8,90.353846153846163]
["Kerosene-type Jet Fuel (kilolitres)","Y",77.446153846153848,167.8,90.353846153846163]
["Landfill Gas (Sm^3)","N",0,0,0]
["Light Fuel Oil (kilolitres)","Y",77.769230769230774,168.5,90.730769230769226]
["Lignite (tonnes)","Y",53.173846153846149,115.21,62.036153846153844]
["Liquified Petroleum Gases (LPG) (kilolitres)","Y",49.892307692307689,108.1,58.207692307692305]
["Lubricants (kilolitres)","N",0,0,0]
["Motor Gasoline - Off-Road (kilolitres)","Y",66.046153846153842,143.1,77.053846153846152]
["Motor Gasoline (kilolitres)","Y",66.046153846153842,143.1,77.053846153846152]
["Municipal Solid Waste - biomass component (bone dry tonnes)","N",0,0,0]
["Municipal Solid Waste - non-biomass component (tonnes)","N",0,0,0]
["Naphtha (kilolitres)","Y",67.615384615384613,146.5,78.884615384615387]
["Natural Gas (Sm^3)","Y",5.7184615384615389E-2,0.1239,6.6715384615384607E-2]
["Natural Gasoline (kilolitres)","Y",66.046153846153842,143.1,77.053846153846152]
["Nitrous Oxide (Sm^3)","N",0,0,0]
["Peat (tonnes)","Y",30.66,66.430000000000007,35.77000000000001]
["PEF (tonnes)","N",0,0,0]
["Petrochemical Feedstocks (kilolitres)","Y",67.615384615384613,146.5,78.884615384615387]
["Petroleum Coke - Refinery Use (kilolitres)","Y",113.16923076923077,245.2,132.03076923076924]
["Petroleum Coke (kilolitres)","Y",113.16923076923077,245.2,132.03076923076924]
["Plastic (tonnes)","N",0,0,0]
["Propane (kilolitres)","Y",46.430769230769229,100.6,54.169230769230765]
["Propylene (kilolitres)","N",0,0,0]
["Refinery Fuel Gas (Sm^3)","Y",6.4430769230769222E-2,0.1396,7.516923076923078E-2]
["Rendered Animal Fat (kilolitres)","N",0,0,0]
["Residual Fuel Oil (#5 & 6) (kilolitres)","Y",95.630769230769232,207.2,{"$f":"D66-C66","v":111.56923076923076}]
["RFG - Mix Drum (Sm^3)","Y",{"$f":"D67*30/65","v":6.4430769230769222E-2},0.1396,7.516923076923078E-2]
["RFG - Reformer Gas (Sm^3)","Y",6.4430769230769222E-2,0.1396,7.516923076923078E-2]
["Roofing Tear-off (tonnes)","N",0,0,0]
["SMR PSA Tail Gas (Sm^3)","N",0,0,0]
["Sodium Bicarbonate (tonnes)","N",0,0,0]
["Solid Byproducts (bone dry tonnes)","N",0,0,0]
["Spent Pulping Liquor (bone dry tonnes)","N",0,0,0]
["Still Gas - Refineries (Sm^3)","Y",6.4430769230769222E-2,0.1396,7.516923076923078E-2]
["Still Gas (Sm^3)","Y",6.4430769230769222E-2,0.1396,7.516923076923078E-2]
["Sub-Bituminous Coal (tonnes)","Y",53.173846153846149,115.21,62.036153846153844]
["Tail Gas (Sm^3)","N",0,0,0]
["Tall Oil (kilolitres)","N",0,0,0]
["Tires - biomass component (bone dry tonnes)","Y",59.916923076923077,129.82,69.903076923076924]
["Tires - non-biomass component (tonnes)","Y",59.916923076923077,129.82,69.903076923076924]
["Trona (tonnes)","N",0,0,0]
["Turpentine (kilolitres)","N",0,0,0]
["Vegetable Oil (kilolitres)","N",0,0,0]
["Waste Oil (kilolitres)","N",0,0,0]
["Wood Waste (bone dry tonnes)","N",0,0,0]
["Flared Natural Gas","Y",5.7184615384615389E-2,0.1239,6.6715384615384607E-2]
["Vented Natural Gas","Y",5.7184615384615389E-2,0.1239,6.6715384615384607E-2]