{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Refinery Product Data","COI Fees","Data Export Instructions","Products Lookup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":18,"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":"Refinery Product Data","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,1,11,1],[10,3,11,3],[10,2,11,2],[16,1,16,4]]}
[null,"Subpart Y - Refinery Products"]
[null,"See the DATA EXPORT INSTRUCTIONS tab for instructions on exporting your data in XML format."]
[null,"Version   ","Cal e-GGRT R04"]
[null,"Today's date   ",{"$f":"TODAY()","v":"2019-03-07"}]
[]
[null,"Facility Information"]
[null,"Facility Name:"]
[null,"Reporter Name:"]
[]
[null,"Calcined Coke Production [section 95113(l)(2)]"]
[null,"Product","EIA Product Code","Annual Mass Produced On-site (metric tons)"]
[]
[null,"Calcined Coke, Integrated with Refinery","021 ir"]
[null,"Calcined Coke, Not Integrated with Refinery","021 nir"]
[]
[null,"Refinery Products  [section 95113(l)(1)]"]
[null,"Instructions\nFor each material in Table 2-1 of MRR, enter the annual on-site production amount and/or the amount of product produced elsewhere and brought on-site by doing the following:\n1.  For each row in the table, select a material from the dropdown menu in the Product column.  The EIA product code of the material and unit of measure will be automatically entered into the table once a product has been selected.  \n2.  Enter the annual on-site production amount and/or the annual amount of product produced elsewhere and brought on-site.  To report annual on-site production amounts, follow the instructions for reporting production amounts in Part 5 of the Energy Information Agency’s Form EIA-810, but report amounts for the full year instead of a single month.  To report annual amounts produced elsewhere and brought on-site, follow the instructions for reporting receipts in Part 5 of the Energy Information Agency’s Form EIA-810, but report amounts for the full year instead of a single month.\n3.  To add rows to the table, enter the number of rows to be added to the table in cell B18 and then click the Add Row(s) button. Macros must be enabled for the Add Row(s) button to work.  If you do not wish to enable macros, contact CARB at ghgreport@arb.ca.gov for an alternative method of adding rows to the table."]
[null,"Number of Rows to Add to the Table Below:",1]
[]
[null,"Product","EIA Product Code","Unit of Measure","Annual On-site Production Amount 1","Annual Amount Produced Elsewhere and Brought On-site 1"]
[null,null,{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,'Products Lookup'!$A$4:$C$39, 2,FALSE))","v":""},{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,'Products Lookup'!$A$4:$C$39, 3,FALSE))","v":""}]
[null,null,{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,'Products Lookup'!$A$4:$C$39, 2,FALSE))","v":""},{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,'Products Lookup'!$A$4:$C$39, 3,FALSE))","v":""}]
[null,null,{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,'Products Lookup'!$A$4:$C$39, 2,FALSE))","v":""},{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,'Products Lookup'!$A$4:$C$39, 3,FALSE))","v":""}]
[null,"1 Annual amounts must be reported in standard cubic feet for gaseous products, barrels for liquid products, and short tons for solid products  per 95113(l)(1)."]

{"sheet":"COI Fees","index":1,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,1,29,2],[30,1,31,1],[30,2,31,2],[19,4,20,4],[12,1,13,1],[12,2,13,2],[12,3,13,3],[19,1,20,1],[19,2,20,2],[19,3,20,3]]}
[null,"COI Fees"]
[null,"See the DATA EXPORT INSTRUCTIONS tab for instructions on exporting your data in XML format."]
[null,"Version   ","Cal e-GGRT R04"]
[null,"Today's date   ",{"$f":"TODAY()","v":"2019-03-07"}]
[]
[null,"Facility Information"]
[null,"Complete the following facility information."]
[null,"Facility Name:"]
[null,"Reporter Name:"]
[]
[]
[null,"Cost of Implementation (COI) Fees Data  [section 95113(m)]"]
[null,"Product","Volume (bbl)","Volume of Oxygenate Associated with CARBOB Produced/Imported (bbl)"]
[]
[null,"CARBOB* produced for use in California"]
[null,"CARBOB* imported for use in California"]
[null,"Finished California gasoline** produced for use in California"]
[null,"Finished California gasoline** imported for use in California"]
[]
[null,"Product","Volume (bbl)","Volume of Biodiesel Associated with Fuel (bbl)","Volume of Renewable Diesel Associated with Fuel (bbl)"]
[]
[null,"California Diesel*** produced for use in California"]
[null,"California Diesel*** imported for use in California"]
[]
[null,"*   As defined by \"California reformulated gasoline blendstock for oxygenate blending\" in section 95202 of the AB 32 Cost of Implementation Fee Regulation"]
[null,"** As defined by \"California gasoline\" in section 95202 of the AB 32 Cost of Implementation Fee Regulation"]
[null,"*** As defined by \"California diesel\" in section 95202 of the AB 32 Cost of Implementation Fee Regulation"]
[]
[null,"Cost of Implementation (COI) Fees Data: Refinery Fuel Gas  [section 95204(f)(5) - COI Regulation]"]
[null,"Enter the CO2e emissions for all refinery fuel gas combusted or consumed at the facility. Do not include emissions from pipeline quality natural gas combustion (see section 95204(f)(5) for removing the natural gas). The emissions entered in this field are not included in any facility total emissions and are only used for fees calculations."]
[null,"Refinery Fuel Gas Combusted or Consumed On-Site (excluding natural gas)","Emissions \n(metric tons CO2e)*"]
[]
[null,"Refinery Fuel Gas Emissions"]
[null,null,"*value NOT included in emissions totals for GHG report"]

{"sheet":"Data Export Instructions","index":2,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,4],[10,0,10,4],[11,0,11,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[4,0,4,4],[6,0,6,4],[8,0,8,4]]}
["Guidance for Exporting Data to XML\n"]
["1.  Enter all data for each worksheet within the workbook where indicated. \n     Ensure that all columns of data are completed before exporting your file.  Only completed rows will be imported into the Tool."]
["2.  Save your workbook."]
["3.  Export Excel data to XML."]
["For Excel 2003,  select the menu Data / XML / Export. "]
[]
["For Excel 2007 and Excel 2010,  right click within a linked cell. Select XML / Export."]
[]
["4.  Provide a file name and complete the process. The generated XML file is the file that you will attach and upload within into Cal e-GGRT."]
["5.  Within Cal e-GGRT, navigate to the subpart Y overview page for your facility.  "]
["6.  Upload your newly exported XML document.  Do not upload your Excel template."]
["7.  If successfully attached, the interface will refresh and display the newly added document.  If there are problems with the xml data being uploaded, validation messages will be displayed describing the problem(s)."]

{"sheet":"Products Lookup","index":3,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,39,2]]}
["Table 2-1 Refinery Products (MRR, Section 95113)"]
[]
["Product","EIA Product Code","Unit of Measure"]
["Petroleum Coke, Marketable",21,"short tons",null,null,"Produced On-Site"]
["Still Gas",45,"scf",null,null,"Produced Elsewhere"]
["NGPL and LRG - Ethane/Ethylene, TOTAL (includes EIA Product Codes 631 and 641)",108,"bbl"]
["Finished Aviation Gasoline",111,"bbl"]
["Aviation Gasoline Blending Components",112,"bbl"]
["Motor Gasoline Blending Components - Gasoline Treated as Blendstock",117,"bbl",null,null,"N/A - Produced On-Site"]
["Motor Gasoline Blending Components - Reformulated Blendstock for Oxygenate Blending (RBOB)",118,"bbl",null,null,"Yes"]
["Finished Motor Gasoline - Reformulated, Blended with Fuel Ethanol",125,"bbl",null,null,"No"]
["Finished Motor Gasoline - Reformulated, Other",127,"bbl"]
["Finished Motor Gasoline - Conventional, Other",130,"bbl"]
["Motor Gasoline Blending Components - All Other Motor Gasoline Blending Components",138,"bbl"]
["Motor Gasoline Blending Components - Conventional Blendstock for Oxygenate Blending (CBOB)",139,"bbl"]
["Renewable Fuels - Fuel Ethanol",141,"bbl"]
["Finished Motor Gasoline - Conventional, Blended with Fuel Ethanol (Greater than Ed55)",149,"bbl"]
["Finished Motor Gasoline - Conventional, Blended with Fuel Ethanol (Ed55 and Lower)",166,"bbl"]
["Renewable Fuels - Biomass-Based Diesel Fuel",203,"bbl"]
["Renewable Fuels - Other Renewable Diesel Fuel",205,"bbl"]
["Renewable Fuels - Other Renewable Fuels",207,"bbl"]
["Kerosene-Type Jet Fuel, TOTAL (includes EIA Product Codes 217 and 218)",213,"bbl"]
["NGPL and LRG* - Pentanes Plus",220,"bbl"]
["NGPL and LRG* - Butane/Butylene, TOTAL (includes EIA Product Codes 249, 633, and 643)",244,"bbl"]
["NGPL and LRG* - Isobutane/Isobutylene, TOTAL (includes EIA Product Codes 247, 634 and 644)",245,"bbl"]
["NGPL and LRG* - Propane/Propylene, TOTAL (includes EIA Product Codes 632 and 642)",246,"bbl"]
["Kerosene",311,"bbl"]
["Distillate Fuel Oil - Ultra Low Sulfur (sulfur content < 15 ppm)",465,"bbl"]
["Distillate Fuel Oil - Low Sulfur (15 ppm ≤ sulfur content ≤ 500 ppm)",466,"bbl"]
["Distillate Fuel Oil - High Sulfur (sulfur content > 500 ppm)",467,"bbl"]
["Residual Fuel Oil, TOTAL (includes EIA Product Codes 508, 509, and 510)",511,"bbl"]
["Unfinished Oils - Naphthas and Lighter",820,"bbl"]
["Petrochemical Feedstocks - Naphtha, end-point < 401 °F",822,"bbl"]
["Petrochemical Feedstocks - Other Oils, end-point ≥ 401 °F",824,"bbl"]
["Unfinished Oils - Kerosene and Light Gas Oils",830,"bbl"]
["Unfinished Oils - Heavy Gas Oils",840,"bbl"]
["Unfinished Oils - Residuum",850,"bbl"]
["Lubricants, TOTAL (includes EIA Product Codes 852 and 853)",854,"bbl"]
["Asphalt and Road Oil",931,"bbl"]
["* NGPL and LRG = Natural Gas Plant Liquids and Liquefied Refinery Gases"]