{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Site-Specific Inputs","Pathway Summary","OR-GREET4.0"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":0,"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":[[2,2,2,6],[3,2,3,6],[8,1,8,7],[1,1,1,7],[4,1,7,2],[4,4,7,4],[4,6,7,7]]}
[]
[null,{"$error":"#VALUE!"}]
[null,null,"Low Carbon Fuel Standard\nTier 1 CI Calculator for Wastewater Sludge Biomethane (Release Date: 8/12/2024)"]
[null,null,"The Tier 1 Calculator for Wastewater Sludge Biomethane (T1 WWS Calculator) offers a simplified interface for calculating the carbon intensity (CI) of wastewater sludge biogas that is upgraded to biomethane and used in a transportation vehicle as compressed natural gas (Bio-CNG) or liquified natural gas (Bio-LNG).\n\nTo begin, navigate to the \"Site-Specific Inputs\" worksheet and enter all relevant project data. 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 DEQ prior to pathway certification. The \"OR-GREET4.0\" worksheet contains predefined input values from the OR-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 OR-GREET4.0 Input values may not be modified without DEQ approval via a Tier 2 pathway. \n\nNote: 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,"CFP Website Resources"]
[null,null,null,"User Input",null,"CFP Program Overview"]
[null,null,null,"Calculated Value",null,"Tier 1 Pathway Calculators and Instruction Manuals"]
[null,null,null,"OR-GREET4.0",null,"Tier 1 Pathway Application Process"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"`"]

{"sheet":"Site-Specific Inputs","index":1,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[29,23,29,24],[9,2,10,2],[1,1,1,2],[8,1,8,2],[2,5,2,6],[2,7,2,10],[2,11,2,13],[12,1,13,1],[12,2,13,2],[1,4,1,13],[9,1,10,1],[15,1,15,2]]}
[]
[null,"Section 1: Applicant Information",null,null,"Section 4: Monthly Operational Data"]
[null,"1.1 Application Number",null,null,null,"Wastewater Sludge (WWS) Biogas Collection",null,"Process Energy",null,null,null,"Blending and Injection"]
[null,"1.2 Company Name",null,null,4.0999999999999996,4.2,4.3,4.4000000000000004,4.5,4.5999999999999996,4.7,4.8,4.9000000000000004,4.0999999999999996]
[null,"1.3 Company ID",null,null,"Reporting Month","WWS Biogas Collected","Methane Content","Natural Gas","Grid Electricity","LPG or Propane","Diesel","Natural Gas Blended","LPG or Propane Blended","Total Gas Injected"]
[null,"1.4 WWTP Name and Address",null,null,"MM/YYYY","ft3 @ 60oF","%V/V (CH4/biogas)","MMBtu, HHV","kWh","gallons","gallons","MMBtu, HHV","gallons","MMBtu, HHV"]
[null,"1.5 Fuel Production Facility ID"]
[]
[null,"Section 2: Pathway Inputs"]
[null,"2.1 Process Energy"]
[]
[null,"2.2 Blended Fossil Fuels"]
[null,"2.3 Finished Fuels"]
[]
[]
[null,"Section 3: Static Operational Data"]
[null,"3.1 Electricity Grid Region"]
[null,"3.2 Electricity Grid CI (gCO2e/kWh)"]
[null,"3.3 Distance to CNG Station (miles)"]
[null,"3.4 LNG Facility ID"]
[null,"3.5 Distance to LNG Facility (miles)"]
[null,"3.6 Liquefaction EF (gCO2e/gallon)"]
[null,"3.7 Bio-LNG Trucking Distance (miles)"]
[null,"3.8 Bio-LNG Truck Type"]

{"sheet":"Pathway Summary","index":2,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,4,1],[21,1,23,1],[8,9,8,10],[9,9,9,10],[6,7,6,10],[7,8,7,10],[1,2,2,10],[3,2,4,10],[19,1,20,1],[5,1,5,9],[14,1,18,1],[6,1,6,2],[12,1,12,4],[12,5,12,6],[12,8,12,10],[11,1,11,10],[35,12,35,14],[28,1,28,7],[26,1,26,7],[27,1,27,7],[30,1,30,10],[31,1,31,10]]}
[]
[null,{"$error":"#VALUE!"},"Tier 1 Wastewater Sludge Biomethane Pathway Summary"]
[]
[null,null,"FOR APPLICANT ONLY - CONTAINS CONFIDENTIAL BUSINESS INFORMATION - DO NOT DISTRIBUTE"]
[]
[]
[null,"Applicant Information",null,null,null,null,null,"RNG (MJ, LHV)"]
[null,"Application #",{"$f":"'Site-Specific Inputs'!C3","v":0},null,null,null,null,"Pipeline Injected",{"$f":"SUM('Site-Specific Inputs'!N7:N30)*'OR-GREET4.0'!E9*'OR-GREET4.0'!M6","v":0}]
[null,"Company Name and ID",{"$f":"CONCATENATE('Site-Specific Inputs'!C4,\" \",'Site-Specific Inputs'!C5)","v":" "},null,null,null,null,null,"Bio-CNG","Bio-LNG or Bio-L-CNG"]
[null,"Operational Data Period",{"$f":"IF(SUM('Site-Specific Inputs'!E7:E30)=0,\"\",CONCATENATE(TEXT(MIN('Site-Specific Inputs'!E7:E30),\"mm/yyyy\"),\" — \",TEXT(MAX('Site-Specific Inputs'!E7:E30),\"mm/yyyy\")))","v":""},null,null,null,null,"Max Dispensed",{"$f":"IFERROR(I8*(1-'Site-Specific Inputs'!C19*'OR-GREET4.0'!E14),)","v":0},{"$f":"IFERROR(I8*(1-'Site-Specific Inputs'!C21*'OR-GREET4.0'!E14)*(1-IF('Site-Specific Inputs'!C24=\"Boil-Off Recovery Equipped\",'OR-GREET4.0'!E17,'OR-GREET4.0'!E18)),)","v":0}]
[]
[null,"Carbon Intensity Calculations"]
[null,"Fuel Pathway Inputs",null,null,null,"Emission Factors",null,"Emissions ","gCO2e/MJ, LHV"]
[null,"Category","Name","Value","Unit","Value","Unit","gCO2e",{"$f":"I9","v":"Bio-CNG"},"Bio-LNG","Bio-L-CNG"]
[null,"WWS Upgrading",{"$f":"'Site-Specific Inputs'!H5","v":"Natural Gas"},{"$f":"SUM('Site-Specific Inputs'!H7:H30)*'OR-GREET4.0'!E9","v":0},"MMBtu, LHV",{"$f":"'OR-GREET4.0'!E10","v":75495.751250270754},"gCO2e/MMBtu, LHV",{"$f":"D15*F15","v":0},{"$f":"IF(I10>0,H15/I10,)","v":0},{"$f":"IF(J10>0,H15/J10,)","v":0},{"$f":"IF(J10>0,H15/J10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!I5","v":"Grid Electricity"},{"$f":"SUM('Site-Specific Inputs'!I7:I30)","v":0},{"$f":"'Site-Specific Inputs'!I6","v":"kWh"},{"$f":"'Site-Specific Inputs'!C18","v":0},"gCO2e/kWh",0,{"$f":"IF(I10>0,H16/I10,)","v":0},{"$f":"IF(J10>0,H16/J10,)","v":0},{"$f":"IF(J10>0,H16/J10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!J5","v":"LPG or Propane"},{"$f":"SUM('Site-Specific Inputs'!J7:J30)","v":0},{"$f":"'Site-Specific Inputs'!J6","v":"gallons"},{"$f":"'OR-GREET4.0'!E11","v":7345.27740286076},"gCO2e/gallon",0,{"$f":"IF(I10>0,H17/I10,)","v":0},{"$f":"IF(J10>0,H17/J10,)","v":0},{"$f":"IF(J10>0,H17/J10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!K5","v":"Diesel"},{"$f":"SUM('Site-Specific Inputs'!K7:K30)","v":0},{"$f":"'Site-Specific Inputs'!K6","v":"gallons"},{"$f":"'OR-GREET4.0'!E12","v":12308.3541997418},"gCO2e/gallon",0,{"$f":"IF(I10>0,H18/I10,)","v":0},{"$f":"IF(J10>0,H18/J10,)","v":0},{"$f":"IF(J10>0,H18/J10,)","v":0}]
[null,null,"Fugitive Methane from Upgrading",{"$f":"I8*'OR-GREET4.0'!E13/'OR-GREET4.0'!E7*'OR-GREET4.0'!E8","v":0},"gCH4",25,"gCO2e/gCH4",{"$f":"D19*F19","v":0},{"$f":"IF(I10>0,H19/I10,)","v":0},{"$f":"IF(J10>0,H19/J10,)","v":0},{"$f":"IF(J10>0,H19/J10,)","v":0}]
[null,"Pipeline Transport","Bio-CNG",{"$f":"I8*'Site-Specific Inputs'!C19","v":0},"MJ-Miles, LHV",{"$f":"'OR-GREET4.0'!E15+'OR-GREET4.0'!E14/'OR-GREET4.0'!E7*'OR-GREET4.0'!E8*25","v":5.5112352137811852E-3},"gCO2e/MJ-Mile, LHV",0,{"$f":"IF(I10>0,H20/I10,)","v":0}]
[null,null,"Bio-LNG / Bio-L-CNG",{"$f":"I8*'Site-Specific Inputs'!C21","v":0},"MJ-Miles, LHV",{"$f":"'OR-GREET4.0'!E15+'OR-GREET4.0'!E14/'OR-GREET4.0'!E7*'OR-GREET4.0'!E8*25","v":5.5112352137811852E-3},"gCO2e/MJ-Mile, LHV",0,null,{"$f":"IF(J10>0,H21/J10,)","v":0},{"$f":"IF(J10>0,H21/J10,)","v":0}]
[null,"LNG Production and Transport","Liquefaction",{"$f":"I8","v":0},"MJ RNG, LHV",{"$f":"IFERROR('Site-Specific Inputs'!C22/'OR-GREET4.0'!E4,)","v":0},"gCO2e/MJ RNG, LHV",0,null,{"$f":"IF(J10>0,H22/J10,)","v":0},{"$f":"IF(J10>0,H22/J10,)","v":0}]
[null,null,"LNG Truck Transport",{"$f":"I8*'Site-Specific Inputs'!C23","v":0},"MJ-Miles, LHV",{"$f":"'OR-GREET4.0'!E16","v":6.583068298485404E-3},"gCO2e/MJ-Mile, LHV",0,null,{"$f":"IF(J10>0,H23/J10,)","v":0},{"$f":"IF(J10>0,H23/J10,)","v":0}]
[null,null,"LNG T&D Fugitives",{"$f":"I8","v":0},"MJ RNG, LHV",{"$f":"_xlfn.IFS('Site-Specific Inputs'!C24=\"Boil-Off Recovery Equipped\",'OR-GREET4.0'!E17,'Site-Specific Inputs'!C24=\"No Boil-Off Recovery\",'OR-GREET4.0'!E18,'Site-Specific Inputs'!C24=\"\",)/'OR-GREET4.0'!E7*'OR-GREET4.0'!E8*F19","v":0},"gCO2e/MJ RNG, LHV",0,null,{"$f":"IF(J10>0,H24/J10,)","v":0},{"$f":"IF(J10>0,H24/J10,)","v":0}]
[null,"CNG Station","Compression at Fueling Station",{"$f":"I10","v":0},"MJ RNG, LHV",{"$f":"'OR-GREET4.0'!E19","v":3.73},"gCO2e/MJ RNG, LHV",{"$f":"D25*F25","v":0},{"$f":"IF(I10>0,H25/I10,)","v":0},null,{"$f":"IF(J10>0,H25/I10,)","v":0}]
[null,"Vehicle Tailpipe Emissions","Non-CO2 Emissions",{"$f":"I10","v":0},"MJ RNG, LHV",{"$f":"'OR-GREET4.0'!E20","v":5.5065209100666461},"gCO2e/MJ RNG, LHV",0,{"$f":"IF(I10>0,H26/I10,)","v":0},{"$f":"IF(J10>0,H26/J10,)","v":0},{"$f":"IF(J10>0,I26,)","v":0}]
[null,"Calculated Fuel Pathway Carbon Intensity (gCO2e/MJ, LHV)",null,null,null,null,null,null,{"$f":"SUM(I15:I26)","v":0},{"$f":"SUM(J15:J26)","v":0},{"$f":"SUM(K15:K26)","v":0}]
[null,"Margin of Safety (entered by applicant)"]
[null,"Fuel Pathway Carbon Intensity for Certification (gCO2e/MJ, LHV)",null,null,null,null,null,null,{"$f":"SUM(I27:I28)","v":0},{"$f":"SUM(J27:J28)","v":0},0]
[]
[null,"Operating Conditions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"`"]

{"sheet":"OR-GREET4.0","index":3,"n_rows":52,"n_cols":13,"rows_kept":52,"cut":false,"hidden":false,"merged":[[15,2,17,2],[14,5,15,5],[16,5,17,5],[9,1,12,1],[9,2,11,2],[21,1,50,1],[21,2,50,2],[21,5,50,5],[1,7,1,12],[18,5,20,5],[9,6,20,6],[1,1,1,5],[3,5,5,5],[6,3,7,3],[3,2,7,2],[3,1,8,1],[13,1,18,1],[19,1,20,1],[10,5,11,5],[13,2,14,2]]}
[]
[null," OR-GREET4.0 Emission Factors and Specifications",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","Liquefied Natural Gas (LNG)",78.83,"MJ/gallon, LHV",null,"Joule (J)",1000,1000000,3600000,1055.05585,1055055850]
[null,null,null,"Ultra Low Sulfur Diesel",134.47,null,null,"Kilojoule (kJ)",1,1000,3600,1.05505585,1055055.8500000001]
[null,null,null,"Liquefied Petroleum Gas (LPG)",89.63,null,null,"Megajoule (MJ)",1E-3,1,3.6,1.0550558499999999E-3,1055.05585]
[null,null,null,"Methane",0.96010082349999992,"MJ/ft3, LHV",null,"Watt-hour (Wh)",0.27777777777777779,277.77777777777777,1000,0.29307106944444444,293071.06944444444]
[null,null,null,null,19.2,"grams/ft3",null,"Kilowatt-hour (kWh)",2.7777777777777778E-4,0.27777777777777779,1,2.9307106944444444E-4,293.07106944444445]
[null,null,"LHV/HHV Ratio","Natural Gas",0.90291262135922334,null,null,"British Thermal Unit (BTU)",0.94781712266701335,947.81712266701334,3412.141641601248,1,1000000]
[null,"WWS Upgrading","Process Energy",{"$f":"'Pathway Summary'!C15","v":"Natural Gas"},75495.751250270754,"gCO2e/MMBtu, LHV",null,"Million British Thermal Unit (MMBtu)",9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012479E-3,9.9999999999999995E-7,1]
[null,null,null,{"$f":"'Pathway Summary'!C17","v":"LPG or Propane"},7345.27740286076,"gCO2e/gallon",null,"Mass","1 g","1 kg","1 MT","1 lb","1 short ton"]
[null,null,null,{"$f":"'Pathway Summary'!C18","v":"Diesel"},12308.3541997418,null,null,"Gram (g)",1,1000,1000000,453.59237000000002,907184.74]
[null,null,"Feed Loss","Fugitive Methane",0.01,"% E/E",null,"Kilogram (kg)",1E-3,1,1000,0.45359237000000002,907.18474000000003]
[null,"Biomethane Transport","Pipeline ","Evaporative Losses",3.2477899430252802E-6,"%/mile",null,"Metric Ton (MT)",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
[null,null,null,"Transport Energy",3.8875107730822396E-3,"gCO2e/MJ-Mile, LHV",null,"Pound (lb)",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
[null,null,"LNG Truck","LNG Transport",6.583068298485404E-3,null,null,"Short Ton (US Ton)",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[null,null,null,"Evaporative Losses - With Boil-Off Recovery",3.1186834785788876E-3,"%",null,"Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
[null,null,null,"Evaporative Losses - Without Boil-Off Recovery",1.5593417392894438E-2,null,null,"Cubic Meter (m3)",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
[null,null,"Compression","at Fueling Station",3.73,"gCO2e/MJ, LHV",null,"Milliliter (ml)",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
[null,"Vehicle Tailpipe Emissions","Bio-CNG","Non-CO2 Emissions",5.5065209100666461,null,null,"Liter (L)",1000,1E-3,1,3.7854109999999999,28.316846999999999]
[null,null,"Bio-LNG","Non-CO2 Emissions",5.5065209100666461,null,null,"Gallon (gal)",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
[null,"Grid Electricity","2021 eGRID Region (ORMX from Oregon 2021 Data)","U.S. Average",474.14818114696288,"gCO2e/kWh",null,"Cubic Foot (ft3)",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[null,null,null,"ORMX",403.07602628539564]
[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,"AKGD",739.37369659441038]
[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"]