{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Site-Specific Inputs","Pathway Summary","CA-GREET4.0"],"not_rendered":{"charts":0,"images":27,"macros":1,"external_links":0,"defined_names":90,"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":"Introduction","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[3,2,3,6],[1,1,1,7],[2,1,2,7],[4,1,7,2],[8,1,8,7],[4,4,7,4],[4,6,7,7]]}
[]
[]
[null,"Low Carbon Fuel Standard\nTier 1 CI Calculator for Hydrogen (Release Date: 08/12/2024)"]
[null,null,"The Tier 1 Calculator for Hydrogen (T1 H2 Calculator) offers a simplified interface for calculating the carbon intensity (CI) of gaseous hydrogen (GH2) or liquified hydrogen (LH2) produced from either electrolysis of water or steam reformation of methane (SMR). This calculator can be used for hydrogen that is either dispensed as a transportation fuel or used as an input for renewable diesel, renewable naphtha and alternative jet fuel (HEFA fuel) pathways. \n\nTo begin, navigate to the \"Site-Specific Inputs\" and enter all relevant project data. The T1 H2 Calculator allows applicants to either enter site-specific data or default values for hydrogen production. All hydrogen transportation and distribution data requires site-specific inputs. For Tier 1 pathways, a minimum of 3 months of operational data is required. Carbon Intensity (CI) results are provided on the \"Pathway Summary\" worksheet, along with calculated input results and finished fuel quantities. Pathway-specific Operating Conditions may be added by CARB prior to pathway certification. The \"CA-GREET4.0\" worksheet contains predefined input values from the CA-GREET4.0 model. \n\nData entered by the applicant are limited to User Input cells (see Color Key below). Additional worksheets may be added to the calculator by the applicant to document and support User Input cell values, but existing worksheets and cells containing Calculated Value or CA-GREET4.0 Input values may not be modified without CARB approval via a Tier 2 pathway. \n\nPlease note that this calculator contains macros that allow the user to hide site-specific input fields that are not relevant to a given pathway. In order for macros to function properly, the \"Enable Content\" button in Microsoft Excel must be selected upon opening this calculator.  In order to ensure that CI calculations reflect the most recent inputs, select \"Automatic\" calculations from the \"Calculation Options\" in the \"Formulas\" toolbar or press F9 (if using Microsoft Excel)."]
[null,null,null,"Color Key",null,"LCFS Website Resources"]
[null,null,null,"User Input",null,"LCFS Program Overview"]
[null,null,null,"Calculated Value",null,"Tier 1 Pathway Calculators and Instruction Manuals"]
[null,null,null,"CA-GREET4.0 Input",null,"Tier 1 Pathway Application Process"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"`"]

{"sheet":"Site-Specific Inputs","index":1,"n_rows":34,"n_cols":31,"rows_kept":34,"cut":false,"hidden":false,"merged":[[24,1,24,2],[14,1,17,1],[14,2,17,2],[18,1,21,1],[18,2,21,2],[5,19,6,19],[5,9,6,9],[5,17,6,17],[5,18,6,18],[5,11,6,11],[5,16,6,16],[5,14,6,14],[5,13,6,13],[5,12,6,12],[5,15,6,15],[5,10,6,10],[5,28,6,28],[5,30,6,30],[1,21,1,30],[2,21,3,26],[2,27,3,30],[5,24,6,24],[5,26,6,26],[5,21,6,21],[5,22,6,22],[5,25,6,25],[5,29,6,29],[5,27,6,27],[5,23,6,23],[1,1,1,2],[2,4,3,4],[2,14,2,19],[1,4,1,19],[2,11,3,11],[2,12,3,13],[2,5,2,10],[3,14,3,16],[3,17,3,19],[3,5,3,10],[11,1,12,1],[5,8,6,8],[5,4,6,4],[5,5,6,5],[5,6,6,6],[5,7,6,7],[7,1,7,2],[11,2,12,2]]}
[]
[null,"Section 1: Applicant Information",null,null,"Section 4: Monthly Operational Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 5: Book-and-Claim Accounting"]
[null,"1.1 Application Number",null,null,null,"Energy Inputs",null,null,null,null,null,"Coproducts","Facility-Wide Hydrogen Production",null,"Hydrogen Transport",null,null,null,null,null,null,"RNG",null,null,null,null,null,"Low-CI Electricity for Hydrogen as a Finished Fuel Only"]
[null,"1.2 Company Name",null,null,null,"Facility-Wide Inputs",null,null,null,null,null,null,null,null,"Gaseous Hydrogen",null,null,"Liquified Hydrogen"]
[null,"1.3 Company ID",null,null,4.0999999999999996,4.2,4.3,4.4000000000000004,4.5,4.5999999999999996,4.7,4.8,4.9000000000000004,4.0999999999999996,4.1100000000000003,4.12,4.13,4.1399999999999997,4.1500000000000004,4.16,null,5.0999999999999996,5.2,5.3,5.4,5.5,5.6,5.7,5.8,5.9,5.0999999999999996]
[null,"1.4 Facility ID",null,null,"Reporting Month","North American Natural Gas","Light Hydrocarbons","Grid Electricity","Direct Supply Low-CI Electricity","Submetered Electricity for Electrolysis","Submetered Electricity for Liquefaction","Exported Steam","Total Hydrogen Production","Total Liquified Hydrogen Production","Dispensed at Fuel Production Facility","Delivered by Tube Trailer Truck","Delivered by Pipeline",{"$f":"O6","v":"Dispensed at Fuel Production Facility"},"Delivered by Tanker Truck","Delivered to Transfill",null,"Fuel Pathway Code","CI Score","Pipeline Distance for Certified RNG Pathway","Distance from RNG Injection to H2 Facility","RNG Matched to GH2","RNG Matched to LH2","Fuel Pathway Code","CI Score","Low-CI Electricity Matched to GH2","Low-CI Electricity Matched to LH2"]
[]
[null,"Section 2: Pathway Inputs",null,null,"MM/YYYY","MMBtu, HHV","MMBtu, HHV","kWh","kWh","kWh","kWh","MMBtu","kg","kg","kg","kg","kg","kg","kg","kg",null,null,"gCO2e/MJ, LHV","miles","miles","MMBtu, HHV","MMBtu, HHV",null,"gCO2e/kWh","kWh","kWh"]
[null,"2.1 Pathway Type",null,null,null,{"$f":"M9*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M9*'CA-GREET4.0'!E$9+(M9-N9)*'CA-GREET4.0'!E$11+N9*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N9*'CA-GREET4.0'!E$12","v":0},null,{"$f":"SUM(O9:T9)","v":0},{"$f":"SUM(R9:T9)","v":0}]
[null,"2.2 Hydrogen Production",null,null,null,{"$f":"M10*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M10*'CA-GREET4.0'!E$9+(M10-N10)*'CA-GREET4.0'!E$11+N10*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N10*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.3 SMR Feedstock",null,null,null,{"$f":"M11*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M11*'CA-GREET4.0'!E$9+(M11-N11)*'CA-GREET4.0'!E$11+N11*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N11*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.4 Process Energy",null,null,null,{"$f":"M12*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M12*'CA-GREET4.0'!E$9+(M12-N12)*'CA-GREET4.0'!E$11+N12*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N12*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M13*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M13*'CA-GREET4.0'!E$9+(M13-N13)*'CA-GREET4.0'!E$11+N13*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N13*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.5 Coproducts",null,null,null,{"$f":"M14*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M14*'CA-GREET4.0'!E$9+(M14-N14)*'CA-GREET4.0'!E$11+N14*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N14*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.6 GH2 Transport",null,null,null,{"$f":"M15*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M15*'CA-GREET4.0'!E$9+(M15-N15)*'CA-GREET4.0'!E$11+N15*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N15*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M16*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M16*'CA-GREET4.0'!E$9+(M16-N16)*'CA-GREET4.0'!E$11+N16*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N16*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M17*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M17*'CA-GREET4.0'!E$9+(M17-N17)*'CA-GREET4.0'!E$11+N17*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N17*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M18*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M18*'CA-GREET4.0'!E$9+(M18-N18)*'CA-GREET4.0'!E$11+N18*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N18*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.7 LH2 Transport",null,null,null,{"$f":"M19*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M19*'CA-GREET4.0'!E$9+(M19-N19)*'CA-GREET4.0'!E$11+N19*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N19*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M20*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M20*'CA-GREET4.0'!E$9+(M20-N20)*'CA-GREET4.0'!E$11+N20*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N20*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M21*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M21*'CA-GREET4.0'!E$9+(M21-N21)*'CA-GREET4.0'!E$11+N21*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N21*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M22*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M22*'CA-GREET4.0'!E$9+(M22-N22)*'CA-GREET4.0'!E$11+N22*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N22*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"2.8 Book-and-Claim (B&C)",null,null,null,{"$f":"M23*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M23*'CA-GREET4.0'!E$9+(M23-N23)*'CA-GREET4.0'!E$11+N23*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N23*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,null,null,null,null,{"$f":"M24*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M24*'CA-GREET4.0'!E$9+(M24-N24)*'CA-GREET4.0'!E$11+N24*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N24*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"Section 3: Static Operational Data",null,null,null,{"$f":"M25*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M25*'CA-GREET4.0'!E$9+(M25-N25)*'CA-GREET4.0'!E$11+N25*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N25*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.1 Grid Electricity Region",null,null,null,{"$f":"M26*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M26*'CA-GREET4.0'!E$9+(M26-N26)*'CA-GREET4.0'!E$11+N26*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N26*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.2. Electricity Grid EF (gCO2e/kWh)",null,null,null,{"$f":"M27*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M27*'CA-GREET4.0'!E$9+(M27-N27)*'CA-GREET4.0'!E$11+N27*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N27*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.3 Light HC EF (gCO2e/MMBtu, HHV)",null,null,null,{"$f":"M28*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M28*'CA-GREET4.0'!E$9+(M28-N28)*'CA-GREET4.0'!E$11+N28*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N28*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.4 Low-CI Electricity EF (gCO2e/kWh)",null,null,null,{"$f":"M29*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M29*'CA-GREET4.0'!E$9+(M29-N29)*'CA-GREET4.0'!E$11+N29*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N29*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.5 GH2 Direct to Fueling Station (miles)",null,null,null,{"$f":"M30*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M30*'CA-GREET4.0'!E$9+(M30-N30)*'CA-GREET4.0'!E$11+N30*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N30*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.6 LH2 Direct to Fueling Station (miles)",null,null,null,{"$f":"M31*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M31*'CA-GREET4.0'!E$9+(M31-N31)*'CA-GREET4.0'!E$11+N31*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N31*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.7 Production to Transfill (miles)",null,null,null,{"$f":"M32*('CA-GREET4.0'!E$7+'CA-GREET4.0'!E$8)","v":0},null,{"$f":"M32*'CA-GREET4.0'!E$9+(M32-N32)*'CA-GREET4.0'!E$11+N32*'CA-GREET4.0'!E$12","v":0},null,null,{"$f":"N32*'CA-GREET4.0'!E$12","v":0},null,0,0]
[null,"3.8 Transfill to Fueling Station (miles)"]
[null,"3.9 Hydrogen Pipeline Transport (miles)"]

{"sheet":"Pathway Summary","index":2,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":false,"merged":[[13,8,13,10],[11,11,11,13],[12,11,12,13],[9,8,9,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[1,2,2,13],[3,2,4,13],[7,11,7,13],[45,1,45,7],[44,1,44,7],[43,1,43,7],[7,4,7,5],[6,4,6,13],[10,4,13,4],[8,8,8,10],[15,4,16,5],[14,4,14,7],[13,11,13,13],[8,11,8,13],[9,11,9,13],[10,11,10,13],[48,1,48,13],[21,1,21,4],[6,1,6,2],[21,5,21,6],[24,1,30,1],[21,8,21,10],[7,8,7,10],[31,1,34,1],[20,1,20,13],[21,11,21,13],[47,1,47,13],[36,1,42,1],[17,4,17,5],[18,4,18,5],[12,5,13,5],[8,4,9,5]]}
[]
[null,null,"Tier 1 Hydrogen Pathway Summary"]
[]
[null,null,"FOR APPLICANT ONLY - CONTAINS CONFIDENTIAL BUSINESS INFORMATION - DO NOT DISTRIBUTE"]
[]
[]
[null,"Applicant Information",null,null,"Hydrogen Production Quantities"]
[null,"Application #",{"$f":"'Site-Specific Inputs'!C3","v":0},null,null,null,"Unit","Total","Gaseous Hydrogen (GH2)",null,null,"Liquified Hydrogen (LH2)"]
[null,"Company Name",{"$f":"'Site-Specific Inputs'!C4","v":0},null,"Total Hydrogen Produced",null,"kg",{"$f":"SUM(I9:N9)","v":0},{"$f":"SUM('Site-Specific Inputs'!M9:M32)-L9","v":0},null,null,{"$f":"SUM('Site-Specific Inputs'!N9:N32)","v":0}]
[null,"Company ID",{"$f":"'Site-Specific Inputs'!C5","v":0},null,null,null,"MJ, LHV",{"$f":"SUM(I10:N10)","v":0},{"$f":"I9*'CA-GREET4.0'!E4","v":0},null,null,{"$f":"L9*'CA-GREET4.0'!E4","v":0}]
[null,"Facility ID",{"$f":"'Site-Specific Inputs'!C6","v":0},null,"H2 for LCFS Pathway(s)","Produced","kg",{"$f":"SUM(I11:N11)","v":0},{"$f":"SUM('Site-Specific Inputs'!O9:Q32)","v":0},null,null,{"$f":"SUM('Site-Specific Inputs'!R9:T32)","v":0}]
[null,"Pathway Type","Steam Methane Reformation",null,null," T&D Loss Factor","%",{"$f":"IFERROR((I12*I9+L12*L9)/SUM(I9:N9),)","v":0},{"$f":"IFERROR(1-(SUM('Site-Specific Inputs'!O9:O32)/'CA-GREET4.0'!E20+SUM('Site-Specific Inputs'!P9:P32)/'CA-GREET4.0'!E22+SUM('Site-Specific Inputs'!Q9:Q32))/SUM('Site-Specific Inputs'!O9:Q32),)","v":0},null,null,{"$f":"IFERROR(1-(SUM('Site-Specific Inputs'!R9:R32)/'CA-GREET4.0'!E21+SUM('Site-Specific Inputs'!S9:S32)/'CA-GREET4.0'!E23+SUM('Site-Specific Inputs'!T9:T32)/'CA-GREET4.0'!E24)/SUM('Site-Specific Inputs'!R9:T32),)","v":0}]
[null,"H2 Production Data","Default Values",null,null,"Dispensed (Calculated)","kg",{"$f":"SUM(I13:N13)","v":0},{"$f":"I11*(1-I12)","v":0},null,null,{"$f":"L11*(1-L12)","v":0}]
[null,"Operational Data Period",{"$f":"IF(SUM('Site-Specific Inputs'!E9:E32)=0,\"\",CONCATENATE(TEXT(MIN('Site-Specific Inputs'!E9:E32),\"mm/yyyy\"),\" — \",TEXT(MAX('Site-Specific Inputs'!E9:E32),\"mm/yyyy\")))","v":""},null,null,null,"MJ, LHV",{"$f":"SUM(I14:N14)","v":0},{"$f":"I13*'CA-GREET4.0'!E4","v":0},null,null,{"$f":"L13*'CA-GREET4.0'!E4","v":0}]
[null,null,null,null,null,null,null,null,"Without B&C ","With B&C RNG","With B&C Electricity",{"$f":"I15","v":"Without B&C "},{"$f":"J15","v":"With B&C RNG"},"With B&C Electricity"]
[null,null,null,null,"Maximum Matchable B&C",null,"MMBtu, HHV",{"$f":"J16+M16","v":0},null,{"$f":"IFERROR(SUM('Site-Specific Inputs'!F9:F32)*I11/SUM(I9:N9),)","v":0},null,null,{"$f":"IFERROR(SUM('Site-Specific Inputs'!F9:F32)*L11/SUM(I9:N9),)","v":0}]
[null,null,null,null,null,null,"kWh",{"$f":"K17+N17","v":0},null,null,{"$f":"IFERROR(SUM('Site-Specific Inputs'!H9:H32)*I11/SUM(I9:N9),)","v":0},null,null,{"$f":"IFERROR(SUM('Site-Specific Inputs'!H9:H32)*L11/SUM(I9:N9),)","v":0}]
[null,null,null,null,"Hydrogen Reportable by Pathway",null,"kg",{"$f":"SUM(I18:N18)","v":0},{"$f":"I11-J18-K18","v":0},{"$f":"IFERROR(I11*D32/J16,)","v":0},{"$f":"IFERROR(I11*D34/K17,)","v":0},{"$f":"L11-M18-N18","v":0},{"$f":"IFERROR(L11*D33/M16,)","v":0},{"$f":"IFERROR(L11*D35/N17,)","v":0}]
[null,null,null,null,"Delivered H2 for CI Calculations",null,"MJ, LHV",{"$f":"SUM(I19:N19)","v":0},{"$f":"IFERROR(H14*I18/H18,)","v":0},{"$f":"IFERROR(H14*J18/H18,)","v":0},{"$f":"IFERROR(H14*K18/H18,)","v":0},{"$f":"IFERROR(H14*L18/H18,)","v":0},{"$f":"IFERROR(H14*M18/H18,)","v":0},{"$f":"IFERROR(H14*N18/H18,)","v":0}]
[]
[null,"Carbon Intensity (CI) Calculations"]
[null,"Fuel Pathway Inputs",null,null,null,"Emission Factors",null,"Emissions ","GH2 CI (gCO2e/MJ, LHV)",null,null,"LH2 CI (gCO2e/MJ, LHV)"]
[null,"Category","Name","Value","Unit","Value","Unit","gCO2e",{"$f":"I15","v":"Without B&C "},{"$f":"J15","v":"With B&C RNG"},{"$f":"K15","v":"With B&C Electricity"},{"$f":"I23","v":"Without B&C "},{"$f":"J23","v":"With B&C RNG"},"With B&C Electricity"]
[null,"Feedstock",{"$f":"'Site-Specific Inputs'!F6","v":"North American Natural Gas"},{"$f":"SUM('Site-Specific Inputs'!F9:F32)*'CA-GREET4.0'!E5*'CA-GREET4.0'!E7/SUM('CA-GREET4.0'!E7:E8)","v":0},"MMBtu, LHV",{"$f":"'CA-GREET4.0'!E13","v":75495.751250270754},"gCO2e/MMBtu, LHV",{"$f":"D24*F24","v":0},{"$f":"IF(I19>0,H24/H10/(1-I12),)","v":0},null,{"$f":"IF(K19>0,H24/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H24/H10/(1-L12),)","v":0},null,{"$f":"IF(N19>0,H24/H10/(1-L12),)","v":0}]
[null,"Process Energy",{"$f":"'Site-Specific Inputs'!F6","v":"North American Natural Gas"},{"$f":"SUM('Site-Specific Inputs'!F9:F32)*'CA-GREET4.0'!E5*'CA-GREET4.0'!E8/SUM('CA-GREET4.0'!E7:E8)","v":0},"MMBtu, LHV",{"$f":"'CA-GREET4.0'!E13","v":75495.751250270754},"gCO2e/MMBtu, LHV",{"$f":"D25*F25","v":0},{"$f":"IF(I19>0,H25/H10/(1-I12),)","v":0},null,{"$f":"IF(K19>0,H25/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H25/H10/(1-L12),)","v":0},null,{"$f":"IF(N19>0,H25/H10/(1-L12),)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!G6","v":"Light Hydrocarbons"},{"$f":"SUM('Site-Specific Inputs'!G9:G32)","v":0},"MMBtu, HHV",{"$f":"'Site-Specific Inputs'!C28","v":0},"gCO2e/MMBtu, HHV",0,{"$f":"IF(I19>0,H26/H10/(1-I12),)","v":0},{"$f":"IF(J19>0,H26/H10/(1-I12),)","v":0},{"$f":"IF(K19>0,H26/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H26/H10/(1-L12),)","v":0},{"$f":"IF(M19>0,H26/H10/(1-L12),)","v":0},{"$f":"IF(N19>0,H26/H10/(1-L12),)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!J6","v":"Submetered Electricity for Electrolysis"},{"$f":"SUM('Site-Specific Inputs'!J9:J32)","v":0},"kWh",{"$f":"IFERROR(('Site-Specific Inputs'!C27*SUM('Site-Specific Inputs'!H9:H32)+'Site-Specific Inputs'!C29*SUM('Site-Specific Inputs'!I9:I32))/SUM('Site-Specific Inputs'!H9:I32),)","v":0},"gCO2e/kWh",0,{"$f":"IF(I19>0,H27/H10/(1-I12),)","v":0},null,null,{"$f":"IF(L19>0,H27/H10/(1-L12),)","v":0}]
[null,null,"LH2 Liquefaction",{"$f":"SUM('Site-Specific Inputs'!K9:K32)","v":0},"kWh",{"$f":"IFERROR(('Site-Specific Inputs'!C27*SUM('Site-Specific Inputs'!H9:H32)+'Site-Specific Inputs'!C29*SUM('Site-Specific Inputs'!I9:I32))/SUM('Site-Specific Inputs'!H9:I32),)","v":0},"gCO2e/kWh",0,null,null,null,{"$f":"IF(L19>0,H28/L10/(1-L12),)","v":0},{"$f":"IF(M19>0,H28/L10/(1-L12),)","v":0},{"$f":"IF(N19>0,H28/L10/(1-L12),)","v":0}]
[null,null,"GH2 Compression",{"$f":"MIN(I9*'CA-GREET4.0'!E11,SUM('Site-Specific Inputs'!H9:I32))","v":0},"kWh",{"$f":"IFERROR(('Site-Specific Inputs'!C27*SUM('Site-Specific Inputs'!H9:H32)+'Site-Specific Inputs'!C29*SUM('Site-Specific Inputs'!I9:I32))/SUM('Site-Specific Inputs'!H9:I32),)","v":0},"gCO2e/kWh",0,{"$f":"IF(I19>0,H29/I10/(1-I12),)","v":0},{"$f":"IF(J19>0,H29/I10/(1-I12),)","v":0},{"$f":"IF(K19>0,H29/I10/(1-I12),)","v":0}]
[null,null,"Balance of Low-CI Electricity",{"$f":"IFERROR(SUM('Site-Specific Inputs'!I9:I32)-SUM(D27:D29)*SUM('Site-Specific Inputs'!I9:I32)/SUM('Site-Specific Inputs'!H9:I32),)","v":0},{"$f":"'Site-Specific Inputs'!I8","v":"kWh"},{"$f":"'Site-Specific Inputs'!C29","v":0},"gCO2e/kWh",{"$f":"D30*F30","v":0},{"$f":"IF(I19>0,H30/H10/(1-I12),)","v":0},{"$f":"IFERROR(H30/H10/(1-I12),)","v":0},{"$f":"IFERROR(H30/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H30/H10/(1-L12),)","v":0},{"$f":"IF(M19>0,H30/H10/(1-L12),)","v":0},{"$f":"IF(N19>0,H30/H10/(1-L12),)","v":0}]
[null,null,"Balance of Grid Electricity",{"$f":"IFERROR(SUM('Site-Specific Inputs'!H9:H32)-SUM(D27:D29)*SUM('Site-Specific Inputs'!H9:H32)/SUM('Site-Specific Inputs'!H9:I32),)","v":0},{"$f":"'Site-Specific Inputs'!H8","v":"kWh"},{"$f":"'Site-Specific Inputs'!C27","v":0},"gCO2e/kWh",0,{"$f":"IF(I19>0,H31/H10/(1-I12),)","v":0},{"$f":"IF(J19>0,H31/H10/(1-I12),)","v":0},{"$f":"IF(K19>0,H31/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H31/H10/(1-L12),)","v":0},{"$f":"IF(M19>0,H31/H10/(1-L12),)","v":0},{"$f":"IF(N19>0,H31/H10/(1-L12),)","v":0}]
[null,"Book-and-Claim",{"$f":"'Site-Specific Inputs'!Z6","v":"RNG Matched to GH2"},{"$f":"MIN(J16,SUM('Site-Specific Inputs'!Z9:Z32))","v":0},"MMBtu, HHV",{"$f":"IFERROR(SUMPRODUCT(((INDEX('Site-Specific Inputs'!W:W, ROW('Site-Specific Inputs'!9:33)) - 2.96 - 5.51 + (INDEX('Site-Specific Inputs'!Y:Y, ROW('Site-Specific Inputs'!9:33)) - INDEX('Site-Specific Inputs'!X:X, ROW('Site-Specific Inputs'!9:33))) * 'CA-GREET4.0'!E14)* 'CA-GREET4.0'!M6* 'CA-GREET4.0'!E5), INDEX('Site-Specific Inputs'!Z:Z, ROW('Site-Specific Inputs'!9:33)))/SUM('Site-Specific Inputs'!Z9:Z32),)","v":0},"gCO2e/MMBtu, HHV",0,null,{"$f":"IF(J19>0,H32/J19,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!AA6","v":"RNG Matched to LH2"},{"$f":"MIN(M16,SUM('Site-Specific Inputs'!AA9:AA32))","v":0},"MMBtu, HHV",{"$f":"IFERROR(SUMPRODUCT(((INDEX('Site-Specific Inputs'!W:W, ROW('Site-Specific Inputs'!9:33)) - 2.96 - 5.51 + (INDEX('Site-Specific Inputs'!Y:Y, ROW('Site-Specific Inputs'!9:33)) - INDEX('Site-Specific Inputs'!X:X, ROW('Site-Specific Inputs'!9:33))) * 'CA-GREET4.0'!E14)* 'CA-GREET4.0'!M6* 'CA-GREET4.0'!E5), INDEX('Site-Specific Inputs'!AA:AA, ROW('Site-Specific Inputs'!9:33)))/SUM('Site-Specific Inputs'!AA9:AA32),)","v":0},"gCO2e/MMBtu, HHV",0,null,null,null,null,{"$f":"IF(M19>0,H33/M19,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!AD6","v":"Low-CI Electricity Matched to GH2"},{"$f":"MIN(K17,SUM('Site-Specific Inputs'!AD9:AD32))","v":0},"kWh",{"$f":"IFERROR(SUMPRODUCT('Site-Specific Inputs'!AC9:AC32,'Site-Specific Inputs'!AD9:AD32)/SUM('Site-Specific Inputs'!AD9:AD32),)","v":0},"gCO2e/kWh",0,null,null,{"$f":"IF(K19>0,H34/K19,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!AE6","v":"Low-CI Electricity Matched to LH2"},{"$f":"MIN(N17,SUM('Site-Specific Inputs'!AE9:AE32))","v":0},"kWh",{"$f":"IFERROR(SUMPRODUCT('Site-Specific Inputs'!AC9:AC32,'Site-Specific Inputs'!AE9:AE32)/SUM('Site-Specific Inputs'!AE9:AE32),)","v":0},"gCO2e/kWh",0,null,null,null,null,null,{"$f":"IF(N19>0,H35/N19,)","v":0}]
[null,"Coproducts",{"$f":"'Site-Specific Inputs'!L6","v":"Exported Steam"},{"$f":"SUM('Site-Specific Inputs'!L9:L32)","v":0},"MMBtu",{"$f":"-'CA-GREET4.0'!E13/0.8","v":-94369.689062838443},"gCO2e/MMBtu",0,{"$f":"IF(I19>0,H36/H10/(1-I12),)","v":0},{"$f":"IF(J19>0,H36/H10/(1-I12),)","v":0},{"$f":"IF(K19>0,H36/H10/(1-I12),)","v":0},{"$f":"IF(L19>0,H36/H10/(1-L12),)","v":0},{"$f":"IF(M19>0,H36/H10/(1-L12),)","v":0},{"$f":"IF(N19>0,H36/H10/(1-L12),)","v":0}]
[null,"Transportation and Distribution","GH2 Tube Trailer Truck",{"$f":"SUM('Site-Specific Inputs'!P9:P32)*'Site-Specific Inputs'!C30","v":0},"kg-miles",{"$f":"'CA-GREET4.0'!E15","v":12.010503186024181},"gCO2e/kg-mile",{"$f":"D37*F37","v":0},{"$f":"IF(I19>0,H37/I14,)","v":0},{"$f":"IF(J19>0,H37/I14,)","v":0},{"$f":"IF(K19>0,H37/I14,)","v":0}]
[null,null,"LH2 Tanker Truck",{"$f":"SUM('Site-Specific Inputs'!S9:S32)*'Site-Specific Inputs'!C31","v":0},"kg-miles",{"$f":"'CA-GREET4.0'!E17","v":1.1998575198369197},"gCO2e/kg-mile",0,null,null,null,{"$f":"IF(L19>0,H38/L14,)","v":0},{"$f":"IF(M19>0,H38/L14,)","v":0},{"$f":"IF(N19>0,H38/L14,)","v":0}]
[null,null,"Transfill Trucking",{"$f":"SUM('Site-Specific Inputs'!T9:T32)*('Site-Specific Inputs'!C32+'Site-Specific Inputs'!C33)","v":0},"kg-miles",{"$f":"IFERROR((F37*'Site-Specific Inputs'!C33+'Pathway Summary'!F38*'Site-Specific Inputs'!C32)/SUM('Site-Specific Inputs'!C32:C33),)","v":0},"gCO2e/kg-mile",{"$f":"D39*F39","v":0},null,null,null,{"$f":"IF(L19>0,H39/L14,)","v":0},{"$f":"IF(M19>0,H39/L14,)","v":0},{"$f":"IF(N19>0,H39/L14,)","v":0}]
[null,null,"Pipeline",{"$f":"SUM('Site-Specific Inputs'!Q9:Q32)*'Site-Specific Inputs'!C34","v":0},"kg-miles",{"$f":"'CA-GREET4.0'!E16","v":0.70341733966189246},"gCO2e/kg-mile",0,{"$f":"IF(I19>0,H40/I14,)","v":0},{"$f":"IF(J19>0,H40/I14,)","v":0},{"$f":"IF(K19>0,H40/I14,)","v":0}]
[null,null,"GH2 Fueling",{"$f":"I14","v":0},"MJ GH2, LHV",{"$f":"'CA-GREET4.0'!E18","v":3.4067988358504966},"gCO2e/MJ H2, LHV",0,{"$f":"IF(I19>0,H41/I14,)","v":0},{"$f":"IF(J19>0,H41/I14,)","v":0},{"$f":"IF(K19>0,H41/I14,)","v":0}]
[null,null,"Transfill LH2 Fueling",{"$f":"IFERROR(L14*SUM('Site-Specific Inputs'!T9:T32)/SUM('Site-Specific Inputs'!R9:T32),)","v":0},"MJ LH2, LHV",{"$f":"'CA-GREET4.0'!E18","v":3.4067988358504966},"gCO2e/MJ H2, LHV",0,null,null,null,{"$f":"IF(L19>0,H42/L14,)","v":0},{"$f":"IF(M19>0,H42/L14,)","v":0},{"$f":"IF(N19>0,H42/L14,)","v":0}]
[null,null,"LH2 Fueling",{"$f":"L14-D42","v":0},"MJ LH2, LHV",{"$f":"'CA-GREET4.0'!E19","v":4.2213683236473276},"gCO2e/MJ H2, LHV",0,null,null,null,{"$f":"IF(L19>0,H43/L14,)","v":0},{"$f":"IF(M19>0,H43/L14,)","v":0},{"$f":"IF(N19>0,H43/L14,)","v":0}]
[null,"Fuel Pathway CI (gCO2e/MJ H2, LHV)",null,null,null,null,null,null,{"$f":"SUM(I24:I43)","v":0},{"$f":"SUM(J24:J43)","v":0},0,0,0,0]
[null,"Margin of Safety (entered by applicant)"]
[null,"Fuel Pathway CI with Margin of Safety",null,null,null,null,null,null,{"$f":"I44+I45","v":0},{"$f":"J44+J45","v":0},0,0,0,0]
[]
[null,"Operating Conditions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"`"]

{"sheet":"CA-GREET4.0","index":3,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[[24,1,53,1],[24,2,53,2],[24,5,53,5],[14,1,16,1],[14,2,15,2],[14,5,16,5],[19,2,23,2],[19,5,23,5],[17,1,18,1],[17,5,18,5],[19,1,23,1],[8,5,11,5],[4,2,5,2],[4,5,5,5],[3,1,5,1],[1,7,1,12],[6,2,7,2],[1,1,1,5],[6,1,11,1],[8,2,11,2]]}
[]
[null," CA-GREET4.0 Emission Factors",null,null,null,null,null,"Unit Conversion"]
[null,"Category","Sub-Category","Name","Value","Unit",null,"Energy","1 kJ","1 MJ","1 kWh","1 BTU","1 MMBtu"]
[null,"Fuel Specifications","Energy Density","Hydrogen",120,"MJ/kg, LHV",null,"Joule (J)",1000,1000000,3600000,1055.05585,1055055850]
[null,null,"Heating Value Ratio","Natural Gas",0.90291262135922334,"LHV/HHV",null,"Kilojoule (kJ)",1,1000,3600,1.05505585,1055055.8500000001]
[null,null,null,"Hydrogen",0.84307692307692306,null,null,"Megajoule (MJ)",1E-3,1,3.6,1.0550558499999999E-3,1055.05585]
[null,"Default Energy Usage Values","Natural Gas","SMR Feedstock",0.1244744982501443,"MMBtu NG feedstock/kg H2, HHV",null,"Watt-hour (Wh)",0.27777777777777779,277.77777777777777,1000,0.29307106944444444,293071.06944444444]
[null,null,null,"SMR Process Energy",5.3761117309339822E-2,"MMBtu NG process energy/kg H2, HHV",null,"Kilowatt-hour (kWh)",2.7777777777777778E-4,0.27777777777777779,1,2.9307106944444444E-4,293.07106944444445]
[null,null,"Electricity","SMR Process Energy",0.1315406323987667,"kWh/kg H2",null,"British Thermal Unit (BTU)",0.94781712266701335,947.81712266701334,3412.141641601248,1,1000000]
[null,null,null,"Electrolysis",55.505550555055493,null,null,"Million British Thermal Unit (MMBtu)",9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012479E-3,9.9999999999999995E-7,1]
[null,null,null,"GH2 Compression",1.9,null,null,"Mass","1 g","1 kg","1 MT","1 lb","1 short ton"]
[null,null,null,"LH2 Liquifaction",11.368896565733134,null,null,"Gram (g)",1,1000,1000000,453.59237000000002,907184.74]
[null,"Process Fuels","Natural Gas","Combusted in Boiler or CHP",75495.751250270754,"MMBtu, LHV",null,"Kilogram (kg)",1E-3,1,1000,0.45359237000000002,907.18474000000003]
[null,"B&C RNG","Transport Emissions","Transport Energy and Fugitive Methane",6.6164807003846766E-3,"gCO2e/MJ-Mile, LHV",null,"Metric Ton (MT)",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
[null,"Finished Fuel Transport","Gaseous H2 (GH2)","Gas Tube Trailer Truck",12.010503186024181,"gCO2e/kg-mile H2",null,"Pound (lb)",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
[null,null,null,"Pipeline",0.70341733966189246,null,null,"Short Ton (US Ton)",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[null,null,"Liquified H2 (LH2)","Liquid Tanker Truck",1.1998575198369197,null,null,"Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
[null,"Fueling Station","GH2","Compression, Precooling and Pumping",3.4067988358504966,"gCO2e/MJ H2, LHV",null,"Cubic Meter (m3)",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
[null,null,"LH2","Storage and Dispensing",4.2213683236473276,null,null,"Milliliter (ml)",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
[null,"Loss Factors","Compound Loss Factors","Onsite Fueling - GH2",1.0050251256281406,null,null,"Liter (L)",1000,1E-3,1,3.7854109999999999,28.316846999999999]
[null,null,null,"Onsite Fueling - LH2",1.0222482100433843,null,null,"Gallon (gal)",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
[null,null,null,"GH2 Tube Trailer Truck",1.01718563070247,null,null,"Cubic Foot (ft3)",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[null,null,null,"LH2 Tanker Truck",1.07605377381533]
[null,null,null,"LH2 Trucked to Transfill Terminal, Delivered as GH2",1.0882690524057044]
[null,"Grid Electricity","2021 eGRID Region","U.S. Average",474.14818114696288,"gCO2e/kWh"]
[null,null,null,"AKGD",739.37369659441038]
[null,null,null,"AKMS",305.05954532367315]
[null,null,null,"AZNM",452.59799644549014]
[null,null,null,"CAMX",329.31550896542888]
[null,null,null,"ERCT",470.46037472212373]
[null,null,null,"FRCC",500.08978131814308]
[null,null,null,"HIMS",729.76964401039049]
[null,null,null,"HIOA",993.04090753329433]
[null,null,null,"MROE",835.17296460818841]
[null,null,null,"MROW",522.27552659353967]
[null,null,null,"NEWE",343.93337546212689]
[null,null,null,"NWPP",341.73208620640725]
[null,null,null,"NYCW",522.5910041112935]
[null,null,null,"NYLI",603.06056459569584]
[null,null,null,"NYUP",153.92030405584592]
[null,null,null,"PRMS",864.84803647299793]
[null,null,null,"RFCE",403.02327991490318]
[null,null,null,"RFCM",647.65601416559605]
[null,null,null,"RFCW",571.73848830541249]
[null,null,null,"RMPA",581.24471143848814]
[null,null,null,"SPNO",518.57796111835]
[null,null,null,"SPSO",538.18467102575312]
[null,null,null,"SRMV",480.14759046268892]
[null,null,null,"SRMW",820.12969419368847]
[null,null,null,"SRSO",508.71583031653392]
[null,null,null,"SRTV",503.56199416646967]
[null,null,null,"SRVC",370.78940202248185]
[null,null,null,"Brazil",110.5727335921882]
[null,null,null,"Canada",142.58733454776279]
[null,null,null,"User Defined"]