{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Refinery Product Data","COI Fees & Finished Products","Data Export Instructions","PR Products Lookup","F Products Lookup"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[22,3,22,16],[13,1,14,1],[13,3,14,3],[13,2,14,2],[19,1,19,6]]}
[null,"Subpart Y - Primary Refinery Products"]
[null,"See the DATA EXPORT INSTRUCTIONS tab for instructions on exporting your data in XML format."]
[null,"Version   ","Cal e-GGRT R03"]
[null,"Today's date   ",{"$f":"TODAY()","v":"2015-03-16"}]
[]
[null,"Facility Information"]
[null,"Facility Name:"]
[null,"Reporter Name:"]
[]
[null,"Solomon Energy Intensity Index®"]
[null,"Solomon Energy Intensity Index (EII)®"]
[]
[null,"Calcined Coke Production"]
[null,"Product","EIA Product Code","Production Amount \n(metric tons)"]
[]
[null,"Calcined Coke, Integrated with Refinery","021 ir"]
[null,"Calcined Coke, Not Integrated with Refinery","021 nir"]
[]
[null,"Primary Refinery Products  [section 95113(l)(1)]"]
[null,"NOTE: Within each row, enter data from left to right, since data entered in previous columns may affect the available input choices for columns to the right.\n\n1.  Add a row to the table below for each material to be reported by entering the number of rows to be added and then clicking 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 ARB at ghgreport@arb.ca.gov for an alternative method of adding rows to the table.\n2.  For each row in the table, select a material in the Product or Blending Component column, and then enter the production volume in barrels in the Volume column.  The EIA product code of the material will be automatically entered into the table.\n3.  If the material is a primary refinery product, answer whether that amount was produced on-site or produced elsewhere.  If it was produced elsewhere, answer whether any of the material was used for purposes other than blending. If it was produced on-site, the \"N/A - Produced On-Site\" option must be selected in column F.\n4.  If the material is a blending component, select that it was produced elsewhere.  Blending components that were produced on-site should not be reported in this table; they should be reported only in the Finished Products Table on the “COI Fees and Finished Products” tab.  Then enter whether any of the material was used for purposes other than blending.  \n5.  The total primary refinery product volume will be automatically calculated in cell C23 based on user input to the table.  The final column in the table automatically states the contribution to the total primary refinery product volume for the material in that row.  The volume is added to the total if the material was produced on-site, it is subtracted from the total if the material was produced elsewhere and used only for blending, and it is excluded from the total if the material was produced elsewhere and used for purposes other than blending.\n6.  An error message in the final column that states, “Invalid Data:  Correct the data entered in this row,” indicates invalid data.  Possible reasons for invalid data include designating that a blending component was produced on-site, or selecting the “N/A – Produced On-Site” in column F when “Produced Elsewhere” is selected in column E.  If an invalid data error occurs, re-enter the data in the row from left to right to be presented with viable input options.\n"]
[null,"Number of Rows to Add to the Table Below:",1]
[]
[null,"Total Primary Refinery Product (barrels):",{"$f":"SUMIF(G26:H103,\"Added\",D26:D103)-SUMIF(G26:H103,\"Subtracted\",D26:D103)","v":0}]
[]
[null,"Product or Blending Component","EIA Product Code","Volume (bbl)","Was the material produced on-site, or was it produced elsewhere and then brought on-site?","If produced elsewhere, was the material used for purposes other than blending?","\nContribution to Total Primary Refinery Product"]
[null,null,{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$C$33, 2,FALSE))","v":""},null,null,null,{"$f":"IF(AND(E26=\"Produced On-Site\",IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F26=\"N/A - Produced On-Site\"),\"Added\",IF(AND(E26=\"Produced Elsewhere\",IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F26=\"Yes\"),\"Excluded\",IF(AND(E26=\"Produced Elsewhere\",IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F26=\"Yes\"),\"Excluded\",IF(AND(E26=\"Produced Elsewhere\",IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F26=\"No\"),\"Subtracted\",IF(AND(E26=\"Produced Elsewhere\",IF($B26=\"\",\"\",VLOOKUP($B26,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F26=\"No\"),\"Subtracted\",IF(AND(E26<>\"\",B26<>\"\",F26<>\"\"),\"Invalid Data: Correct the data entered in this row.\",\"\"))))))","v":""}]
[null,null,{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$C$33, 2,FALSE))","v":""},null,null,null,{"$f":"IF(AND(E27=\"Produced On-Site\",IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F27=\"N/A - Produced On-Site\"),\"Added\",IF(AND(E27=\"Produced Elsewhere\",IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F27=\"Yes\"),\"Excluded\",IF(AND(E27=\"Produced Elsewhere\",IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F27=\"Yes\"),\"Excluded\",IF(AND(E27=\"Produced Elsewhere\",IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F27=\"No\"),\"Subtracted\",IF(AND(E27=\"Produced Elsewhere\",IF($B27=\"\",\"\",VLOOKUP($B27,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F27=\"No\"),\"Subtracted\",IF(AND(E27<>\"\",B27<>\"\",F27<>\"\"),\"Invalid Data: Correct the data entered in this row.\",\"\"))))))","v":""}]
[null,null,{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$C$33, 2,FALSE))","v":""},null,null,null,{"$f":"IF(AND(E28=\"Produced On-Site\",IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F28=\"N/A - Produced On-Site\"),\"Added\",IF(AND(E28=\"Produced Elsewhere\",IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F28=\"Yes\"),\"Excluded\",IF(AND(E28=\"Produced Elsewhere\",IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F28=\"Yes\"),\"Excluded\",IF(AND(E28=\"Produced Elsewhere\",IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"primary refinery product\",F28=\"No\"),\"Subtracted\",IF(AND(E28=\"Produced Elsewhere\",IF($B28=\"\",\"\",VLOOKUP($B28,'PR Products Lookup'!$A$4:$D$33, 4,FALSE))=\"blending component\",F28=\"No\"),\"Subtracted\",IF(AND(E28<>\"\",B28<>\"\",F28<>\"\"),\"Invalid Data: Correct the data entered in this row.\",\"\"))))))","v":""}]

{"sheet":"COI Fees & Finished Products","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[19,4,20,4],[29,1,29,16],[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,"Subpart Y - COI Fees and Finished Products Data"]
[null,"See the DATA EXPORT INSTRUCTIONS tab for instructions on exporting your data in XML format."]
[null,"Version   ","Cal e-GGRT R.03"]
[null,"Today's date   ",{"$f":"TODAY()","v":"2015-03-16"}]
[]
[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,"Finished Products  [section 95113(l)(3)]"]
[null,"For each row in the table, select a product from the Finished Product dropdown and enter the corresponding Production Amount.  \nIf you need to add rows to the table, enter the number of rows to be added and click the Add Row(s) button.  \nNOTE: You will need to enable macros for the button to work.  If you do not wish to enable macros, contact ARB for an alternative method of adding rows to the table."]
[null,"Number of rows to add to the table below:",1]
[]
[]
[null,"Finished Product","EIA Product Code","Production Amount","Unit of Measure","Column1","1","2","3","4","5","6","7"]
[null,null,{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,'F Products Lookup'!$A$4:$C$45,2,FALSE))","v":""},null,{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,'F Products Lookup'!$A$4:$C$45,3,FALSE))","v":""}]
[null,null,{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,'F Products Lookup'!$A$4:$C$45,2,FALSE))","v":""},null,{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,'F Products Lookup'!$A$4:$C$45,3,FALSE))","v":""}]
[null,null,{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,'F Products Lookup'!$A$4:$C$45,2,FALSE))","v":""},null,{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,'F Products Lookup'!$A$4:$C$45,3,FALSE))","v":""}]

{"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":"PR Products Lookup","index":3,"n_rows":33,"n_cols":21,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Primary Refinery Products Lookup Table"]
[]
["Product","EIA","Unit (scf, bbl, tons)","Primary Refinery Product or Blending Component",null,null,null,null,null,null,null,null,null,null,null,null,null,"Produced On-site",null,null,"Yes"]
["Asphalt and Road Oil","931","bbl","primary refinery product",null,null,"Produced On-Site",null,null,null,null,null,null,null,null,null,null,"Produced Elsewhere",null,null,"No"]
["Aviation Gasoline","111","bbl","primary refinery product",null,null,"Produced Elsewhere",null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A - Produced on-site"]
["Aviation Gasoline Blending Components","112","bbl","primary refinery product"]
["Distillate Fuel Oil - High Sulfur (greater than 500 ppm)","467","bbl","primary refinery product"]
["Distillate Fuel Oil, Other 15 ppm Sulfur and Under","465","bbl","primary refinery product"]
["Distillate Fuel Oil, Other Greater than 15 ppm to 500 ppm Sulfur (inclusive)","466","bbl","primary refinery product",null,null,"N/A - Produced On-Site"]
["Kerosene-Type Jet Fuel, Bonded","213","bbl","primary refinery product",null,null,"Yes"]
["Motor Gasoline Blending Components - All Other","138","bbl","primary refinery product",null,null,"No"]
["Motor Gasoline Blending Components - Conventional Blendstock for Oxygenate Blending (CBOB)","139","bbl","primary refinery product"]
["Motor Gasoline Blending Components - Gasoline Treated as Blendstock (GTAB)","117","bbl","primary refinery product"]
["Motor Gasoline Blending Components - Reformulated Blendstock for Oxygenate Blending (RBOB)","118","bbl","primary refinery product"]
["Motor Gasoline, Finished, Conventional (Other)","130","bbl","primary refinery product"]
["Motor Gasoline, Finished, Conventional, Ed 55 & Lower","166","bbl","primary refinery product"]
["Motor Gasoline, Finished, Conventional, Greater than ED 55","149","bbl","primary refinery product"]
["Motor Gasoline, Finished, Reformulated (Blended with Fuel Ethanol)","125","bbl","primary refinery product"]
["Motor Gasoline, Finished, Reformulated (Other)","127","bbl","primary refinery product"]
["Renewable Fuel, Biomass Based Diesel","203","bbl","primary refinery product"]
["Renewable Fuel, Other","207","bbl","primary refinery product"]
["Renewable Fuel, Other Renewable Diesel Fuel","205","bbl","primary refinery product"]
["Fuel Ethanol",141,"bbl","blending component"]
["Ethyl Tertiary Butyl Ether (ETBE)",142,"bbl","blending component"]
["Methyl Tertiary Butyl Ether (MTBE)",144,"bbl","blending component"]
["Other Oxygenates",445,"bbl","blending component"]
["Normal Butane - NGPL",249,"bbl","blending component"]
["Normal Butane - LRG",643,"bbl","blending component"]
["Butylene",633,"bbl","blending component"]
["Isobutane - NGPL",247,"bbl","blending component"]
["Isobutane - LRG",644,"bbl","blending component"]
["Isobutylene",634,"bbl","blending component"]
["Pentanes Plus",220,"bbl","blending component"]

{"sheet":"F Products Lookup","index":4,"n_rows":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Finished Products Lookup Table"]
[]
["Product","EIA","Unit (scf, bbl, tons)"]
["Ethanol","141","bbl"]
["Biomass-based diesel","203","bbl"]
["Other renewable diesel","205","bbl"]
["Other renewable fuels","207","bbl"]
["ETBE","142","bbl"]
["MTBE","144","bbl"]
["Other Oxygenates","445","bbl"]
["LPG/LRG Ethane","641","bbl"]
["LPG/LRG Ethylene","631","bbl"]
["LPG/LRG Propane","642","bbl"]
["LPG/LRG Propylene","632","bbl"]
["LPG/LRG Butane","643","bbl"]
["LPG/LRG Butylene","633","bbl"]
["LPG/LRG Isobutane","644","bbl"]
["LPG/LRG Isobutylene","634","bbl"]
["LPG/LRG Pentanes Plus","220","bbl"]
["Unfinished Oils","812","bbl"]
["Naphtha and Lighter","820","bbl"]
["Kerosene and Light Gas Oils","830","bbl"]
["Heavy Gas Oils","840","bbl"]
["Residuum","850","bbl"]
["Finished Motor Gasoline - Reformulated, blended with Fuel Ethanol","125","bbl"]
["Finished Motor Gasoline - Conventional, Blended with Fuel Ethanol","166&149","bbl"]
["Finished Motor Gasoline - Other","127&130","bbl"]
["Motor Gasoline - Reformulated Blendstock for Oxygenate Blending (RBOB)","118","bbl"]
["Motor Gasoline - Conventional Blendstock for Oxygenate Blending (CBOB)","139","bbl"]
["Motor Gasoline Blendstocks—Other","138","bbl"]
["Finished Aviation Gasoline","111","bbl"]
["Aviation Gasoline Blending Components","112","bbl"]
["Kerosene-Type Jet Fuel, TOTAL",213,"bbl"]
["Kerosene","311","bbl"]
["Distillate Fuel Oil - Ultra Low Sulfur (less than or equal to 15 ppm)","465","bbl"]
["Distillate Fuel Oil - Low Sulfur (less than or equal to 500 ppm and greater than 15 ppm)","466","bbl"]
["Distillate Fuel Oil - High Sulfur (greater than 500 ppm)","467","bbl"]
["Residual Fuel Oil, TOTAL","511","bbl"]
["Lubricants, TOTAL","854","bbl"]
["Asphalt and Road Oil","931","bbl"]
["Wax","070","short tons"]
["Still Gas","045","scf"]
["Petrochemical Feedstocks - Naphthas (less than 401 deg F)","822","bbl"]
["Petrochemical Feedstocks - Other Oil (greater than or equal to 401 deg F)","824","bbl"]
["Petroleum Coke","021","short tons"]