{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Introduction","Pathway Summary","Manure-to-Biogas (LOP Inputs)","Avoided Emissions","Biogas-to-RNG","EF Table","Reference"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":5,"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":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[11,1,11,7],[1,1,1,7],[2,1,2,7],[3,2,4,6],[6,1,9,2],[6,4,9,4],[6,6,9,7]]}
[]
[null,{"$error":"#VALUE!"}]
[null,"Low Carbon Fuel Standard\nTier 1 CI Calculator for Dairy and Swine Manure Biomethane (Release Date: 08/12/2024)"]
[null,null,"The Tier 1 Calculator for Biomethane from Anaerobic Digestion of Dairy and Swine Manure offers a simplified interface for calculating the carbon intensity (CI) of biomethane produced from the anaerobic digestion of dairy and swine manure. To begin, please navigate to the \"Manure-to-Biogas (LOP Inputs)\", \"Biogas-to-RNG\", and \"Avoided Emissions\" worksheets and enter all relevant data. Inputs entered by the applicant are limited to all yellow cells (see Color Key below) and are subject to be validated and verified by a third-party verifier. Inputs that do not apply to the fuel pathway may be left blank. Cells containing calculated or predefined input values may not be modified without DEQ approval via a Tier 2 pathway. \n\nThe carbon Intensity (CI) summary is provided in the \"Pathway Summary\" worksheet. A conservative margin of safety may be added to the calculated CI in this worksheet to establish the final CI. Pathway-specific Operating Conditions may be added by DEQ prior to pathway certification.\n\nNotes:\n1. \"Manure-to-Biogas (LOP Inputs)\" worksheet\n    • Annual lagoon cleanout is required for the baseline modeling (Fields L1.(1-6).15) for both Tier 1 and Tier 2 pathways. Please refer to the Instruction Manual of the calculator for more details. \n    • Field L3.1 is not a user input, to adjust the operational data period, please update Field 2.3 in the \"Biogas-to-RNG\" worksheet. \n    • Please select either \"12\" or \"24” months for Field L1.1.2. If the number of baseline reporting month entered in Fields L1.(1-6).7 does not match the entry in Field L1.1.2, an \"ERROR\" message will appear in the total baseline methane emission from Anaerobic Storage/Treatment Systems (cells N33, AB33, AP33, BD33, BR33, and CF33). Once 24 months are selected for the baseline reporting period, the applicant must continue to model the 24-month baseline moving forward (including Annual Fuel Pathway Reports). Please refer to the Instruction Manual of the calculator for more details.\n    • Calculated herd populations are not allowed to establish the initial VS carryover (Fields L1.(1-6).16). If herd populations used to establish the initial VS carryover are not verifiable, enter zero for the initial VS carryover. \n\n2. \"Biogas-to-RNG\" worksheet\n    • For Section 1, the \"Company Name\" represents the fuel pathway applicant (\"Fuel Producer\" in AFP), whereas the \"Facility Name\" represents the fuel production facility (\"Facility\" in the AFP).\n    • A minimum of 3 months of project operational data is required in Section 2. The project reporting month populated in Field 2.3 must be entirely covered by the baseline reporting month populated in Fields L1.(1-6).7 in the \"Manure-to-Biogas (LOP Inputs)\" worksheet. If the number of project reporting months is fewer than the number of baseline reporting months, the project reporting month must align with the latest baseline reporting month.    \n    • If less than 24 months of project operational data is reported in the Annual Fuel Pathway Reports, the operational data period must include the reported months established during pathway initial certification. \n    • Please enter the name of each joint applicant/intermediate facility included in this fuel pathway in Field 1.11. All joint applicants must also be registered in the AFP to align with the legal name of the facility or with US EPA facility registration. \n\n3. This calculator contains macros. If using Microsoft Excel, users will have to select the \"Enable Content\" button upon opening this calculator and select \"Automatic\" calculations from the \"Calculation Options\" in the \"Formulas\" toolbar or press F9 to ensure that the calculator results are accurate."]
[]
[]
[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 Input",null,"Tier 1 Pathway Application Process"]
[null,null,null,"Pathway CI Results"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"`"]

{"sheet":"Pathway Summary","index":1,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[[79,0,85,5],[5,1,5,3],[7,4,7,5],[78,0,78,5],[0,0,0,3],[0,4,0,5],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3]]}
["SUMMARY AND OPERATING CONDITIONS OF DAIRY/SWINE MANURE TO CNG/LNG/L-CNG PATHWAY",null,null,null,"(FOR APPLICANT TO REVIEW ONLY - CONTAINS CONFIDENTIAL BUSINESS INFORMATION - DO NOT DISTRIBUTE)"]
["AXXXX/BXXXX","Input Data",null,null,"Output Results, gCO2e/MJ","Biogas"]
["Applicant",{"$f":"IF('Biogas-to-RNG'!C15=\"\",\"\",'Biogas-to-RNG'!C15)","v":""},null,null,"CNG Carbon Intensity: ",{"$f":"IF(F59=0,\"N/A\",F59)","v":"N/A"}]
["Digester Location:",{"$f":"IF('Biogas-to-RNG'!C18=\"\",\"\",'Biogas-to-RNG'!C18)","v":""},null,null,"Certification Date: ","TBD"]
["Pathway Description:",null,null,null,"FPC Code: ","TBD"]
[null,null,null,null,"First Reporting Month for Certification",{"$f":"IF('Biogas-to-RNG'!B28<>\"\", 'Biogas-to-RNG'!B28, \"\")","v":""}]
[null,null,null,null,"Number of Project Reporting Month",{"$f":"IF('Biogas-to-RNG'!J24<>0, 'Biogas-to-RNG'!J24, \"\")","v":""}]
["User Inputs Parameters","Value","Unit","Note","CI Breakdown (gCO2e/MJ)"]
["1) Project Background Information"]
["Average total livestock population",{"$f":"IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!D9:D32),0)+IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!R9:R32),0)+IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!AF9:AF32),0)+IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!AT9:AT32),0)+IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!BH9:BH32),0)+IFERROR(AVERAGE('Manure-to-Biogas (LOP Inputs)'!BV9:BV32),0)","v":0},"head"]
["Average ambient temperature",{"$f":"IFERROR(SUMPRODUCT('Manure-to-Biogas (LOP Inputs)'!G9:G32,'Manure-to-Biogas (LOP Inputs)'!F9:F32)/SUM('Manure-to-Biogas (LOP Inputs)'!F9:F32),0)","v":0},"°C"]
["Full lagoon cleanouts in baseline?",{"$f":"IF(COUNTIF('Manure-to-Biogas (LOP Inputs)'!L9:L32,\">0\")<COUNT('Manure-to-Biogas (LOP Inputs)'!L9:L32), \"YES\",\"NO\")","v":"YES"}]
["Digester type",{"$f":"'Avoided Emissions'!C4","v":"Covered Lagoon"}]
["Manure Biogas Production Electricity Mix",{"$f":"'Biogas-to-RNG'!D24","v":"ORMX"}]
[]
["2) Baseline Methane Production"]
["Diesel consumption",{"$f":"'Biogas-to-RNG'!I52","v":0},"Gallons"]
["Electricity consumption",{"$f":"'Biogas-to-RNG'!K52","v":0},"kWh"]
["Baseline CH4 emissions from anaerobic storage/treatment systems",{"$f":"IFERROR(('Manure-to-Biogas (LOP Inputs)'!N33+'Manure-to-Biogas (LOP Inputs)'!AB33+'Manure-to-Biogas (LOP Inputs)'!AP33+'Manure-to-Biogas (LOP Inputs)'!BD33+'Manure-to-Biogas (LOP Inputs)'!BR33+'Manure-to-Biogas (LOP Inputs)'!CF33)/'Manure-to-Biogas (LOP Inputs)'!B9,0)","v":0},"MT CH4 / month"]
["Baseline CH4 emissions from non-anaerobic storage/treatment systems",{"$f":"IFERROR('Manure-to-Biogas (LOP Inputs)'!J47/'Manure-to-Biogas (LOP Inputs)'!B9,0)","v":0},"MT CH4 / month"]
["Total Baseline CH4 atmospheric emissions",{"$f":"SUM(B19:B20)","v":0},"MT CH4 / month",null,"Methane Avoided / CO2 Diverted Credits",{"$f":"'Biogas-to-RNG'!G95+'Biogas-to-RNG'!G96","v":0}]
[]
[]
[]
["3) Project Methane Production"]
["Raw Inlet Gas as Feedstock ",{"$f":"'Biogas-to-RNG'!G52","v":0},"SCF at 60°F"]
["Average Methane Content ",{"$f":"'Biogas-to-RNG'!H52","v":0},"% CH4"]
["Biogas Production",{"$f":"IFERROR(('Biogas-to-RNG'!D53*Reference!E52/1000000)/F7,0)","v":0},"MT CH4 / month",null,"Biogas Production & Upgrading",{"$f":"'Biogas-to-RNG'!G70+SUM('Biogas-to-RNG'!G71:G77)","v":0}]
["CH4 emissions from venting events ",{"$f":"'Avoided Emissions'!D32","v":0},"MT CH4 / month"]
["CH4 emissions from effluent pond(s) ",{"$f":"'Avoided Emissions'!E32","v":0},"MT CH4 / month"]
["CH4 emissions from non-BCS-related sources",{"$f":"IFERROR('Manure-to-Biogas (LOP Inputs)'!J108/'Manure-to-Biogas (LOP Inputs)'!B9,0)","v":0},"MT CH4 / month",null,"Post-Digester Fugitives",{"$f":"'Biogas-to-RNG'!G80","v":0}]
["Digester Leakage (standard value)",{"$f":"'Avoided Emissions'!G32","v":0},"MT CH4 / month",null,"Flared Biomethane",{"$f":"'Biogas-to-RNG'!G79","v":0}]
["Upgrading Fugitives (2% minimum)",{"$f":"IFERROR(('Biogas-to-RNG'!H53*Reference!E52/1000000)/F7*'Biogas-to-RNG'!AH55,0)","v":0},"MT CH4 / month"]
["Flared Biomethane",{"$f":"IFERROR(('Biogas-to-RNG'!AC53*Reference!E52/1000000)/F7,0)","v":0},"MT CH4 / month"]
["Total Project CH4 atmospheric emissions",{"$f":"SUM(B29:B34)","v":0},"MT CH4 / month",null,"Biomethane Transmission",{"$f":"'Biogas-to-RNG'!G82+'Biogas-to-RNG'!G83","v":0}]
["Net reduction in atmospheric CH4 emissions from baseline",{"$f":"IFERROR(1-(B35/B21),0)","v":0},"%"]
[]
["NG Transport Electricity Mix",{"$f":"'Biogas-to-RNG'!B82","v":"US Average"}]
["Pipeline Distance to Centroid of CNG stations",{"$f":"'Biogas-to-RNG'!AH34","v":0},"miles"]
["Pipeline Distance to LNG facility",{"$f":"'Biogas-to-RNG'!AH40","v":0},"miles"]
[]
["4) Project Energy Usage",null,null,null,"LNG Production & Transmission ",{"$f":"'Biogas-to-RNG'!G86+'Biogas-to-RNG'!G89","v":0}]
["Diesel",{"$f":"IFERROR(\n    IF(\n        'Biogas-to-RNG'!AA27=\"Diesel (Gallons)\",\n        ('Biogas-to-RNG'!P52 + 'Biogas-to-RNG'!W52 + 'Biogas-to-RNG'!AA52) * Reference!D9 * Reference!G45 / F7,\n        ('Biogas-to-RNG'!P52 + 'Biogas-to-RNG'!W52) * Reference!D9 * Reference!G45 / F7\n    ),\n    0\n)","v":0},"MJ / month"]
["Electricity (including on-site electricity from biogas)",{"$f":"IFERROR(\n    IF(\n        'Biogas-to-RNG'!AA27=\"Grid Electricity (kWh)\",\n        ('Biogas-to-RNG'!L52 + 'Biogas-to-RNG'!U52 + 'Biogas-to-RNG'!V52 + 'Biogas-to-RNG'!AA52) * Reference!F45 / F7,\n        ('Biogas-to-RNG'!L52 + 'Biogas-to-RNG'!U52 + 'Biogas-to-RNG'!V52) * Reference!F45 / F7\n    ),\n    0\n)","v":0},"MJ / month"]
["Natural Gas ",{"$f":"IFERROR(\n    IF(\n        'Biogas-to-RNG'!AA27=\"NG (MMBtu, LHV)\",\n        ('Biogas-to-RNG'!O52+'Biogas-to-RNG'!R52+'Biogas-to-RNG'!Y52+'Biogas-to-RNG'!AA52)*Reference!H45/F7,\n        ('Biogas-to-RNG'!O52+'Biogas-to-RNG'!R52+'Biogas-to-RNG'!Y52)*Reference!H45/F7\n    ),\n    0\n)","v":0},"MJ / month"]
["Propane (process energy)",{"$f":"IFERROR(\n    (\n        IF('Biogas-to-RNG'!Q27=\"Propane (Gallons)\", 'Biogas-to-RNG'!Q52, 0) +\n        IF('Biogas-to-RNG'!X27=\"Propane (Gallons)\", 'Biogas-to-RNG'!X52, 0) +\n        IF('Biogas-to-RNG'!AA27=\"Propane (Gallons)\", 'Biogas-to-RNG'!AA52, 0) +\n        'Biogas-to-RNG'!Z52\n    ) * Reference!D12 * Reference!G45 / F7,\n    0\n)","v":0},"MJ / month"]
["Raw Biogas (heat+process fuel)",{"$f":"IFERROR(('Biogas-to-RNG'!M55+'Biogas-to-RNG'!M55)*Reference!H45/F7, 0)","v":0},"MJ/month"]
["Biomethane (heating + process fuel)",{"$f":"IFERROR(('Biogas-to-RNG'!N52+'Biogas-to-RNG'!T52)*Reference!H45/F7, 0)","v":0},"MJ/month",null,"CNG Production",{"$f":"'Biogas-to-RNG'!G91","v":3.73}]
[{"$f":"'EF Table'!C80","v":"User-Defined Fuel-1 (MJ)"},{"$f":"IFERROR(\n    (\n        IF('Biogas-to-RNG'!Q27='EF Table'!C80, 'Biogas-to-RNG'!Q52, 0) +\n        IF('Biogas-to-RNG'!X27='EF Table'!C80, 'Biogas-to-RNG'!X52, 0) +\n        IF('Biogas-to-RNG'!AA27='EF Table'!C80, 'Biogas-to-RNG'!AA52, 0)\n    ) / F7,\n    0\n)","v":0},"MJ/month",null,"Tailpipe Emissions",{"$f":"'Biogas-to-RNG'!G92","v":61.559634743751531}]
[{"$f":"'EF Table'!C81","v":"User-Defined Fuel-2 (MJ)"},{"$f":"IFERROR(\n    (\n        IF('Biogas-to-RNG'!Q27='EF Table'!C81, 'Biogas-to-RNG'!Q52, 0) +\n        IF('Biogas-to-RNG'!X27='EF Table'!C81, 'Biogas-to-RNG'!X52, 0) +\n        IF('Biogas-to-RNG'!AA27='EF Table'!C81, 'Biogas-to-RNG'!AA52, 0)\n    ) / F7,\n    0\n)","v":0},"MJ/month"]
[{"$f":"'EF Table'!C82","v":"User-Defined Fuel-3 (MJ)"},{"$f":"IFERROR(\n    (\n        IF('Biogas-to-RNG'!Q27='EF Table'!C82, 'Biogas-to-RNG'!Q52, 0) +\n        IF('Biogas-to-RNG'!X27='EF Table'!C82, 'Biogas-to-RNG'!X52, 0) +\n        IF('Biogas-to-RNG'!AA27='EF Table'!C82, 'Biogas-to-RNG'!AA52, 0)\n    ) / F7,\n    0\n)","v":0},"MJ/month"]
["Fuel for Biomethane transport ",{"$f":"'Biogas-to-RNG'!AA52","v":0},{"$f":"'Biogas-to-RNG'!AA27","v":"User-Defined Fuel-3 (MJ)"}]
["Natural Gas (Gas Btu Enhancement)",{"$f":"'Biogas-to-RNG'!Y52","v":0},"HHV in MMBtu"]
["Propane (Gas Btu Enhancement)",{"$f":"'Biogas-to-RNG'!Z52","v":0},"HHV in MMBtu"]
["Energy Return on Investment",{"$f":"IFERROR(B70/SUM(B43:B51),0)","v":0},"MJ Outputs / MJ Inputs"]
[null,null,null,null,"1) CNG CI Breakdown"]
[null,null,null,null,"Subtotal CI (gCO2e/MJ)",{"$f":"'Biogas-to-RNG'!G97","v":0}]
[null,null,null,null,"Conservative Margin of Safety (gCO2e/MJ)"]
["5) Fuel Production",null,null,null,"Total CI (gCO2e/MJ)",{"$f":"SUM(F57:F58)","v":0}]
["Compressed Natural Gas (CNG) Production"]
["CNG Production Electricity Mix",{"$f":"'Biogas-to-RNG'!D24","v":"ORMX"}]
[]
[]
["LNG Transport & Dispense",null,null,null,"2) LNG CI Breakdown"]
[" Truck",{"$f":"'Biogas-to-RNG'!AL25","v":0},"miles",null,"Subtotal CI",{"$f":"'Biogas-to-RNG'!G98","v":0}]
["Dispense",{"$f":"IFERROR('Biogas-to-RNG'!AL29*Reference!H45/F7,0)","v":0},"MJ/month",null,"Conservative Margin of Safety (gCO2e/MJ)"]
[null,null,null,null,"Total CI (gCO2e/MJ)",{"$f":"SUM(F65:F66)","v":0}]
[]
["6) Finished Fuel"]
["Biomethane Injected into Pipeline",{"$f":"IFERROR('Biogas-to-RNG'!AD52*Reference!H45/F7,0)","v":0},"MJ / month"]
["Parasitic (On-site) Electricity from Biogas",{"$f":"IFERROR('Biogas-to-RNG'!U52*Reference!F45/F7,0)","v":0},"MJ / month"]
["% Exported",{"$f":"IFERROR(B70/(B70+B71),0)","v":0},"%",null,"2) L-CNG CI Breakdown"]
[null,null,null,null,"Subtotal CI",{"$f":"'Biogas-to-RNG'!G99","v":0}]
[null,null,null,null,"Conservative Margin of Safety (gCO2e/MJ)"]
[null,null,null,null,"Total CI (gCO2e/MJ)",{"$f":"SUM(F73:F74)","v":0}]
[]
[]
[]
["Operating Conditions: "]
["\n\n"]

{"sheet":"Manure-to-Biogas (LOP Inputs)","index":2,"n_rows":108,"n_cols":84,"rows_kept":108,"cut":false,"hidden":false,"merged":[[91,1,91,8],[92,3,92,8],[1,2,1,7],[35,1,35,8],[36,3,36,8],[80,1,80,10],[83,8,88,8],[83,9,88,9],[83,10,88,10],[49,1,49,8],[50,1,51,1],[50,2,50,5],[50,6,50,7],[50,8,51,8]]}
[]
[null,{"$error":"#VALUE!"},"Calculations Based on Selected Equations from the \n\"Compliance Offset Protocol Livestock Projects\" (LOP)"]
[]
[]
[null,"Section L1: Baseline Methane Emissions from Anaerobic Storage/Treatment Systems (BECH4,AS) (Reference: [Equation 5.3 in LOP])"]
[null,"L1.1.1 \nLivestock Category (L)\n1","L1.1.7\nReporting Month ","L1.1.8\nLivestock Population","L1.1.9\nCalendar Days of the Month","L1.1.10\nNumber of Reporting Days","L1.1.11\nAverage Temperature","L1.1.12\nVan't Hoff-Arrhenius factor ","L1.1.13\n Fraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.1.14\nVolatile Solids Available for Degradation","L1.1.15\nRetention Time and Drainage","L1.1.16\nCarryover from Previous Month","L1.1.17\nVolatile Solids Degraded","L1.1.18\nBaseline Methane Emissions, AS",null,"L1.2.1 \nLivestock Category (L)\n2","L1.2.7\nReporting Month ","L1.2.8\nLivestock Population","L1.2.9\nCalendar Days of the Month","L1.2.10\nNumber of Reporting Days","L1.2.11 \nAverage Temperature","L1.2.12\nVan't Hoff-Arrhenius factor ","L1.2.13 \nFraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.2.14 \nVolatile Solids Available for Degradation","L1.2.15\nRetention Time and Drainage","L1.2.16\nCarryover from Previous Month","L1.2.17\nVolatile Solids Degraded","L1.2.18\nBaseline Methane Emissions, AS",null,"L1.3.1 \nLivestock Category (L)\n3","L1.3.7\nReporting Month ","L1.3.8\nLivestock Population","L1.3.9\nCalendar Days of the Month","L1.3.10 \nNumber of Reporting Days","L1.3.11\nAverage Temperature","L1.3.12\nVan't Hoff-Arrhenius factor ","L1.3.13\nFraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.3.14\nVolatile Solids Available for Degradation","L1.3.15\nRetention Time and Drainage","L1.3.16\nCarryover from Previous Month","L1.3.17\nVolatile Solids Degraded","L1.3.18\nBaseline Methane Emissions, AS",null,"L1.4.1 \nLivestock Category (L)\n4","L1.4.7\nReporting Month ","L1.4.8\nLivestock Population","L1.4.9\nCalendar Days of the Month","L1.4.10\nNumber of Reporting Days","L1.4.11\nAverage Temperature","L1.4.12\nVan't Hoff-Arrhenius factor ","L1.4.13\nFraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.4.14\nVolatile Solids Available for Degradation","L1.4.15\nRetention Time and Drainage","L1.4.16\nCarryover from Previous Month","L1.4.17\nVolatile Solids Degraded","L1.4.18\nBaseline Methane Emissions, AS",null,"L1.5.1 \nLivestock Category (L)\n5","L1.5.7\nReporting Month ","L1.5.8\nLivestock Population","L1.5.9\nCalendar Days of the Month","L1.5.10\nNumber of Reporting Days","L1.5.11 \nAverage Temperature","L1.5.12\nVan't Hoff-Arrhenius factor ","L1.5.13\nFraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.5.14 \nVolatile Solids Available for Degradation","L1.5.15\nRetention Time and Drainage","L1.5.16\nCarryover from Previous Month","L1.5.17\nVolatile Solids Degraded","L1.5.18\nBaseline Methane Emissions, AS",null,"L1.6.1 \nLivestock Category (L)\n6","L1.6.7\nReporting Month ","L1.6.8 \nLivestock Population","L1.6.9\nCalendar Days of the Month","L1.6.10\nNumber of Reporting Days","L1.6.11\nAverage Temperature","L1.6.12\nVan't Hoff-Arrhenius factor ","L1.6.13\nFraction of Volatile Solids Sent to Anaerobic Storage/Treatment System","L1.6.14 \nVolatile Solids Available for Degradation","L1.6.15\nRetention Time and Drainage","L1.6.16\nCarryover from Previous Month","L1.6.17\nVolatile Solids Degraded","L1.6.18\nBaseline Methane Emissions, AS"]
[null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)",null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)",null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)",null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)",null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)",null,"-","(MM/YYYY)","PL","days","RDrm  (days)","T2 (°C)","f","MSAS,L (fraction)","VSavail,AS (kg)","Select \"System Emptied in This Month\" for each September","(VSavail-1,AS -VSdeg-1,AS) (kg)","VSdeg,AS (kg)","BECH4,AS (MT CH4)"]
[null,"L1.1.2 Baseline Reporting Period (Months)",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1.2.2 Baseline Reporting Period (Months)",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1.3.2 Baseline Reporting Period (Months)",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1.4.2 Baseline Reporting Period (Months)",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1.5.2 Baseline Reporting Period (Months)",null,null,null,null,null,null,null,null,null,null,null,null,null,"L1.6.2 Baseline Reporting Period (Months)"]
[null,"-",null,null,null,null,null,{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((G9+273)-303.16)/(1.987*(G9+273)*303.17))))","v":0.104},null,{"$f":"(B$20*D9*I9*E9*0.8)+L9","v":0},"Not Applicable",0,{"$f":"J9*H9","v":0},{"$f":"IFERROR(M9*B$16*0.68*0.001*(F9/E9), 0)","v":0},null,{"$f":"$B$9","v":"-"},{"$f":"IF($C9=0, \"\", $C9)","v":""},null,{"$f":"E9","v":0},null,{"$f":"G9","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((U9+273)-303.16)/(1.987*(U9+273)*303.17))))","v":0.104},null,{"$f":"(P$20*R9*W9*S9*0.8)+Z9","v":0},"Not Applicable",0,{"$f":"X9*V9","v":0},{"$f":"IFERROR(AA9*P$16*0.68*0.001*(T9/S9), 0)","v":0},null,{"$f":"$B$9","v":"-"},{"$f":"IF($C9=0, \"\", $C9)","v":""},null,{"$f":"E9","v":0},null,{"$f":"G9","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((AI9+273)-303.16)/(1.987*(AI9+273)*303.17))))","v":0.104},null,{"$f":"(AD$20*AF9*AK9*AG9*0.8)+AN9","v":0},"Not Applicable",0,{"$f":"AL9*AJ9","v":0},{"$f":"IFERROR(AO9*AD$16*0.68*0.001*(AH9/AG9), 0)","v":0},null,{"$f":"$B$9","v":"-"},{"$f":"IF($C9=0, \"\", $C9)","v":""},null,{"$f":"E9","v":0},null,{"$f":"G9","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((AW9+273)-303.16)/(1.987*(AW9+273)*303.17))))","v":0.104},null,{"$f":"(AR$20*AT9*AY9*AU9*0.8)+BB9","v":0},"Not Applicable",0,{"$f":"AZ9*AX9","v":0},{"$f":"IFERROR(BC9*AR$16*0.68*0.001*(AV9/AU9), 0)","v":0},null,{"$f":"$B$9","v":"-"},{"$f":"IF($C9=0, \"\", $C9)","v":""},null,{"$f":"E9","v":0},null,{"$f":"G9","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((BK9+273)-303.16)/(1.987*(BK9+273)*303.17))))","v":0.104},null,{"$f":"(BF$20*BH9*BM9*BI9*0.8)+BP9","v":0},"Not Applicable",0,{"$f":"BN9*BL9","v":0},{"$f":"IFERROR(BQ9*BF$16*0.68*0.001*(BJ9/BI9), 0)","v":0},null,{"$f":"$B$9","v":"-"},{"$f":"IF($C9=0, \"\", $C9)","v":""},null,{"$f":"E9","v":0},null,{"$f":"G9","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((BY9+273)-303.16)/(1.987*(BY9+273)*303.17))))","v":0.104},null,{"$f":"(BT$20*BV9*CA9*BW9*0.8)+CD9","v":0},"Not Applicable",0,{"$f":"CB9*BZ9","v":0},{"$f":"IFERROR(CE9*BT$16*0.68*0.001*(BX9/BW9), 0)","v":0}]
[null,"L1.1.3 Livestock Average Mass",null,null,null,null,null,{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((G10+273)-303.16)/(1.987*(G10+273)*303.17))))","v":0.104},null,{"$f":"(B$20*D10*I10*E10*0.8)+L10","v":0},"Not Applicable",{"$f":"IF(K9=\"Not Applicable\", (J9-M9), 0)","v":0},0,{"$f":"IFERROR(M10*B$16*0.68*0.001*(F10/E10), 0)","v":0},null,"L1.2.3 Livestock Average Mass",{"$f":"IF($C10=0, \"\", $C10)","v":""},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((U10+273)-303.16)/(1.987*(U10+273)*303.17))))","v":0.104},null,0,"Not Applicable",{"$f":"IF(Y9=\"Not Applicable\", (X9-AA9), 0)","v":0},0,{"$f":"IFERROR(AA10*P$16*0.68*0.001*(T10/S10), 0)","v":0},null,"L1.3.3 Livestock Average Mass",{"$f":"IF($C10=0, \"\", $C10)","v":""},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((AI10+273)-303.16)/(1.987*(AI10+273)*303.17))))","v":0.104},null,0,"Not Applicable",{"$f":"IF(AM9=\"Not Applicable\", (AL9-AO9), 0)","v":0},0,{"$f":"IFERROR(AO10*AD$16*0.68*0.001*(AH10/AG10), 0)","v":0},null,"L1.4.3 Livestock Average Mass",{"$f":"IF($C10=0, \"\", $C10)","v":""},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((AW10+273)-303.16)/(1.987*(AW10+273)*303.17))))","v":0.104},null,0,"Not Applicable",{"$f":"IF(BA9=\"Not Applicable\", (AZ9-BC9), 0)","v":0},0,{"$f":"IFERROR(BC10*AR$16*0.68*0.001*(AV10/AU10), 0)","v":0},null,"L1.5.3 Livestock Average Mass",{"$f":"IF($C10=0, \"\", $C10)","v":""},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((BK10+273)-303.16)/(1.987*(BK10+273)*303.17))))","v":0.104},null,0,"Not Applicable",{"$f":"IF(BO9=\"Not Applicable\", (BN9-BQ9), 0)","v":0},0,{"$f":"IFERROR(BQ10*BF$16*0.68*0.001*(BJ10/BI10), 0)","v":0},null,"L1.6.3 Livestock Average Mass",{"$f":"IF($C10=0, \"\", $C10)","v":""},null,{"$f":"E10","v":0},null,{"$f":"G10","v":0},{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((BY10+273)-303.16)/(1.987*(BY10+273)*303.17))))","v":0.104},null,0,"Not Applicable",{"$f":"IF(CC9=\"Not Applicable\", (CB9-CE9), 0)","v":0},0,{"$f":"IFERROR(CE10*BT$16*0.68*0.001*(BX10/BW10), 0)","v":0}]
[null,"(MassL, kg)",null,null,null,null,null,0.104,null,0,"Not Applicable",{"$f":"IF(K10=\"Not Applicable\", (J10-M10), 0)","v":0},0,0,null,"(MassL, kg)","",null,0,null,0,0.104,null,0,"Not Applicable",{"$f":"IF(Y10=\"Not Applicable\", (X10-AA10), 0)","v":0},0,0,null,"(MassL, kg)","",null,0,null,0,0.104,null,0,"Not Applicable",{"$f":"IF(AM10=\"Not Applicable\", (AL10-AO10), 0)","v":0},0,0,null,"(MassL, kg)","",null,0,null,0,0.104,null,0,"Not Applicable",{"$f":"IF(BA10=\"Not Applicable\", (AZ10-BC10), 0)","v":0},0,0,null,"(MassL, kg)","",null,0,null,0,0.104,null,0,"Not Applicable",{"$f":"IF(BO10=\"Not Applicable\", (BN10-BQ10), 0)","v":0},0,0,null,"(MassL, kg)","",null,0,null,0,0.104,null,0,"Not Applicable",{"$f":"IF(CC10=\"Not Applicable\", (CB10-CE10), 0)","v":0},0,0]
[null,{"$f":"IFERROR(VLOOKUP(B7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(P7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AD7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AR7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BF7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BT7, Reference!$A$94:$B$103, 2, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,{"$f":"IFERROR(M13*B$16*0.68*0.001*(F13/E13), 0)","v":0},null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,"L1.1.4 Maximum CH4 Potential",null,null,null,null,null,0.104,null,0,"Not Applicable",{"$f":"IF(K13=\"Not Applicable\", (J13-M13), 0)","v":0},{"$f":"J14*H14","v":0},{"$f":"IFERROR(M14*B$16*0.68*0.001*(F14/E14), 0)","v":0},null,"L1.2.4 Maximum CH4 Potential","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.3.4 Maximum CH4 Potential","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.4.4 Maximum CH4 Potential","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.5.4 Maximum CH4 Potential","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.6.4 Maximum CH4 Potential","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,"(Bo,L , m3 CH4/kg VS)",null,null,null,null,null,{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((G15+273)-303.16)/(1.987*(G15+273)*303.17))))","v":0.104},null,0,"Not Applicable",0,0,0,null,"(Bo,L , m3 CH4/kg VS)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(Bo,L , m3 CH4/kg VS)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(Bo,L , m3 CH4/kg VS)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(Bo,L , m3 CH4/kg VS)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(Bo,L , m3 CH4/kg VS)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(B7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(P7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AD7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AR7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BF7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BT7, Reference!$A$94:$D$103,4, FALSE), 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,"L1.1.5 Livestock Excretion Rate",null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,"L1.2.5 Livestock Excretion Rate","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.3.5 Livestock Excretion Rate","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.4.5 Livestock Excretion Rate","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.5.5 Livestock Excretion Rate","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.6.5 Livestock Excretion Rate","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,"(VSL, dry kg/animal/day)",null,null,null,null,null,{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((G19+273)-303.16)/(1.987*(G19+273)*303.17))))","v":0.104},null,0,"Not Applicable",0,0,0,null,"(VSL, dry kg/animal/day)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(VSL, dry kg/animal/day)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(VSL, dry kg/animal/day)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(VSL, dry kg/animal/day)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"(VSL, dry kg/animal/day)","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,{"$f":"IFERROR(VLOOKUP(B7, Reference!$A$94:$D$103, 3, FALSE)*B12/1000, 0)","v":0},null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(P7, Reference!$A$94:$D$103, 3, FALSE)*P12/1000, 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AD7, Reference!$A$94:$D$103, 3, FALSE)*AD12/1000, 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(AR7, Reference!$A$94:$D$103, 3, FALSE)*AR12/1000, 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BF7, Reference!$A$94:$D$103, 3, FALSE)*BF12/1000, 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,{"$f":"IFERROR(VLOOKUP(BT7, Reference!$A$94:$D$103, 3, FALSE)*BT12/1000, 0)","v":0},"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,{"$f":"MIN(0.95, MAX(0.104, EXP(15175*((G21+273)-303.16)/(1.987*(G21+273)*303.17))))","v":0.104},null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,"L1.1.6  Farm Name",null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,"L1.2.6  Farm Name","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.3.6  Farm Name","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.4.6  Farm Name","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.5.6  Farm Name","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,"L1.6.6  Farm Name","",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,null,null,null,null,null,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0,null,null,"",null,0,null,0,0.104,null,0,"Not Applicable",0,0,0]
[null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(C9:C32,\">0\")<>B9,\"ERROR\",IF(B9=12,SUM(N9:N20),IF(B9=24,SUM(N9:N32),IF(B9=\"-\",\"ERROR\"))))","v":"ERROR"},null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Q9:Q32,\">0\")<>P9,\"ERROR\",IF(P9=12,SUM(AB9:AB20),IF(P9=24,SUM(AB9:AB32),IF(P9=\"-\",\"ERROR\"))))","v":"ERROR"},null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AE9:AE32,\">0\")<>AD9,\"ERROR\",IF(AD9=12,SUM(AP9:AP20),IF(AD9=24,SUM(AP9:AP32),IF(AD9=\"-\",\"ERROR\"))))","v":"ERROR"},null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(AS9:AS32,\">0\")<>AR9,\"ERROR\",IF(AR9=12,SUM(BD9:BD20),IF(AR9=24,SUM(BD9:BD32),IF(AR9=\"-\",\"ERROR\"))))","v":"ERROR"},null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BG9:BG32,\">0\")<>BF9,\"ERROR\",IF(BF9=12,SUM(BR9:BR20),IF(BF9=24,SUM(BR9:BR32),IF(BF9=\"-\",\"ERROR\"))))","v":"ERROR"},null,null,"Total",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(BU9:BU32,\">0\")<>BT9,\"ERROR\",IF(BT9=12,SUM(CF9:CF20),IF(BT9=24,SUM(CF9:CF32),IF(BT9=\"-\",\"ERROR\"))))","v":"ERROR"}]
[]
[]
[null,"Section L2: Baseline Methane Emissions from Other Storage/Treatment Systems (BECH4,nAS) (Reference:[Equation 5.4 in LOP])"]
[null,null,"L2.2  Methane Conversion Factor \n(MCFnAS, fraction)","L2.3\nManure Managed in Other Storage/Treatment System (MSL,nAS, fraction)"]
[null,"Livestock Category (L)",null,{"$f":"$B$7","v":"-"},{"$f":"$P$7","v":"-"},{"$f":"$AD$7","v":"-"},{"$f":"$AR$7","v":"-"},{"$f":"$BF$7","v":"-"},{"$f":"$BT$7","v":"-"}]
[null,"L2.1  Other storage/treatment Systems"]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B40>0, VLOOKUP(B40, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B41>0, VLOOKUP(B41, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B42>0, VLOOKUP(B42, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B43>0, VLOOKUP(B43, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B44>0, VLOOKUP(B44, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B45>0, VLOOKUP(B45, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B46>0, VLOOKUP(B46, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0},null,null,null,null,null,null,"Total (BECH4,nAS , MT CH4)"]
[null,"L2.4\nBaseline Methane Emissions, non-AS \n(BECH4,L,nAS , MT CH4)",null,{"$f":"IFERROR(($D$84*$E$84*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,D40:D46)*$C$84*0.001, 0)","v":0},{"$f":"IFERROR(($D$85*$E$85*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,E40:E46)*$C$85*0.001,0)","v":0},{"$f":"IFERROR(($D$86*$E$86*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,F40:F46)*$C$86*0.001,0)","v":0},{"$f":"IFERROR(($D$87*$E$87*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,G40:G46)*$C$87*0.001,0)","v":0},{"$f":"IFERROR(($D$88*$E$88*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,H40:H46)*$C$88*0.001,0)","v":0},{"$f":"IFERROR(($D$89*$E$89*$I$84*0.68)*SUMPRODUCT($C$40:$C$46,I40:I46)*$C$89*0.001,0)","v":0},{"$f":"SUM(D47:I47)","v":0}]
[]
[]
[null,"Section L3: Project Methane Emissions from Venting Events (CH4 vent) in the Biogas Control System (BCS) (Reference: [Equation 5.6-Venting in LOP])"]
[null,"L3.1\nReporting Month\n(MM/YYYY)\n","Method 1",null,null,null,"Method 2",null,"L3.8\nProject Methane Emissions from Venting"]
[null,null,"L3.2\nMaximum Biogas Storage of the BCS System","L3.3\nAverage Daily Biogas Production for the 7 Days Preceding the Venting","L3.4\nNumber of Days for the Uncontrolled Venting","L3.5\nQuarterly Methane Concentration","L3.6 Vented Biogas Flow, (metered)","L3.7\nBiomethane Content in Vented Biogas (metered)\n"]
[null,null,"MSBCS (scf)","Fpw (scf/day)","t (days)","CCH4 (fraction)","Standard Cubic Feet \n@ 60oF, 1 atm","% Methane","CH4 vent  (MT)"]
[null,{"$f":"IF('Biogas-to-RNG'!B28=0, \" \",'Biogas-to-RNG'!B28)","v":" "},null,null,null,null,null,null,{"$f":"((D54*E54+C54)*F54)*0.0423*0.000454+G54*H54*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B29=0, \" \",'Biogas-to-RNG'!B29)","v":" "},null,null,null,null,null,null,{"$f":"((D55*E55+C55)*F55)*0.0423*0.000454+G55*H55*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B30=0, \" \",'Biogas-to-RNG'!B30)","v":" "},null,null,null,null,null,null,{"$f":"((D56*E56+C56)*F56)*0.0423*0.000454+G56*H56*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B31=0, \" \",'Biogas-to-RNG'!B31)","v":" "},null,null,null,null,null,null,{"$f":"((D57*E57+C57)*F57)*0.0423*0.000454+G57*H57*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B32=0, \" \",'Biogas-to-RNG'!B32)","v":" "},null,null,null,null,null,null,{"$f":"((D58*E58+C58)*F58)*0.0423*0.000454+G58*H58*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B33=0, \" \",'Biogas-to-RNG'!B33)","v":" "},null,null,null,null,null,null,{"$f":"((D59*E59+C59)*F59)*0.0423*0.000454+G59*H59*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B34=0, \" \",'Biogas-to-RNG'!B34)","v":" "},null,null,null,null,null,null,{"$f":"((D60*E60+C60)*F60)*0.0423*0.000454+G60*H60*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B35=0, \" \",'Biogas-to-RNG'!B35)","v":" "},null,null,null,null,null,null,{"$f":"((D61*E61+C61)*F61)*0.0423*0.000454+G61*H61*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B36=0, \" \",'Biogas-to-RNG'!B36)","v":" "},null,null,null,null,null,null,{"$f":"((D62*E62+C62)*F62)*0.0423*0.000454+G62*H62*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B37=0, \" \",'Biogas-to-RNG'!B37)","v":" "},null,null,null,null,null,null,{"$f":"((D63*E63+C63)*F63)*0.0423*0.000454+G63*H63*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B38=0, \" \",'Biogas-to-RNG'!B38)","v":" "},null,null,null,null,null,null,{"$f":"((D64*E64+C64)*F64)*0.0423*0.000454+G64*H64*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B39=0, \" \",'Biogas-to-RNG'!B39)","v":" "},null,null,null,null,null,null,{"$f":"((D65*E65+C65)*F65)*0.0423*0.000454+G65*H65*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B40=0, \" \",'Biogas-to-RNG'!B40)","v":" "},null,null,null,null,null,null,{"$f":"((D66*E66+C66)*F66)*0.0423*0.000454+G66*H66*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B41=0, \" \",'Biogas-to-RNG'!B41)","v":" "},null,null,null,null,null,null,{"$f":"((D67*E67+C67)*F67)*0.0423*0.000454+G67*H67*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B42=0, \" \",'Biogas-to-RNG'!B42)","v":" "},null,null,null,null,null,null,{"$f":"((D68*E68+C68)*F68)*0.0423*0.000454+G68*H68*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B43=0, \" \",'Biogas-to-RNG'!B43)","v":" "},null,null,null,null,null,null,{"$f":"((D69*E69+C69)*F69)*0.0423*0.000454+G69*H69*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B44=0, \" \",'Biogas-to-RNG'!B44)","v":" "},null,null,null,null,null,null,{"$f":"((D70*E70+C70)*F70)*0.0423*0.000454+G70*H70*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B45=0, \" \",'Biogas-to-RNG'!B45)","v":" "},null,null,null,null,null,null,{"$f":"((D71*E71+C71)*F71)*0.0423*0.000454+G71*H71*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B46=0, \" \",'Biogas-to-RNG'!B46)","v":" "},null,null,null,null,null,null,{"$f":"((D72*E72+C72)*F72)*0.0423*0.000454+G72*H72*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B47=0, \" \",'Biogas-to-RNG'!B47)","v":" "},null,null,null,null,null,null,{"$f":"((D73*E73+C73)*F73)*0.0423*0.000454+G73*H73*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B48=0, \" \",'Biogas-to-RNG'!B48)","v":" "},null,null,null,null,null,null,{"$f":"((D74*E74+C74)*F74)*0.0423*0.000454+G74*H74*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B49=0, \" \",'Biogas-to-RNG'!B49)","v":" "},null,null,null,null,null,null,{"$f":"((D75*E75+C75)*F75)*0.0423*0.000454+G75*H75*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B50=0, \" \",'Biogas-to-RNG'!B50)","v":" "},null,null,null,null,null,null,{"$f":"((D76*E76+C76)*F76)*0.0423*0.000454+G76*H76*Reference!$E$16/(10^6)","v":0}]
[null,{"$f":"IF('Biogas-to-RNG'!B51=0, \" \",'Biogas-to-RNG'!B51)","v":" "},null,null,null,null,null,null,{"$f":"((D77*E77+C77)*F77)*0.0423*0.000454+G77*H77*Reference!$E$16/(10^6)","v":0}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I54:I77)","v":0}]
[]
[]
[null,"Section L4: Project Methane Emissions from the BCS Effluent Pond(s) (PECH4,EP) (Reference: [Equation 5.8 in LOP])"]
[null,"L4.1\nLivestock Category","L4.2\nAverage Population","L4.3\nLivestock Excretion Rate","L4.4\nMaximum CH4 Potential","L4.5 Fraction of Volatile Solids Sent to BCS System","L4.6\nFraction of Volatile Solids Removed before Effluent is Sent to Effluent Ponds","L4.7\nMethane Potential of the VS to Effluent Ponds","L4.8\nNumber of Reporting Days","L4.9\nMethane Conversion Factor","L4.10\nProject Methane Emission from Effluent Ponds"]
[null," L","PL","VSL \n(dry kg/animal/day)","Bo,L \n(m3 CH4/kg VS)","MSL,BCS \n(fraction)","%","VSep,L \n(m3 CH4/day)","RDrp \n(days)","MCFep \n(fraction)","PECH4,EP \n(MT CH4)"]
[null,{"$f":"B7","v":"-"},{"$f":"IFERROR(IF(B7=\"-\", 0, SUMPRODUCT(D9:D32,F9:F32)/SUM(F9:F32)),0)","v":0},{"$f":"B20","v":0},{"$f":"B16","v":0},null,null,{"$f":"C84*D84*E84*F84*(1-G84)*0.3","v":0},{"$f":"SUM(F9:F32)","v":0},{"$f":"IFERROR(HLOOKUP('Biogas-to-RNG'!F20,Reference!A168:T174,7,FALSE),\"\")","v":""},{"$f":"IFERROR(SUM(H84:H89)*I84*0.68*J84*0.001,\"\")","v":""}]
[null,{"$f":"P7","v":"-"},{"$f":"IFERROR(IF(P7=\"-\", 0, SUMPRODUCT(R9:R32,T9:T32)/SUM(T9:T32)),0)","v":0},{"$f":"P20","v":0},{"$f":"P16","v":0},null,null,{"$f":"C85*D85*E85*F85*(1-G85)*0.3","v":0}]
[null,{"$f":"AD7","v":"-"},{"$f":"IFERROR(IF(AD7=\"-\", 0, SUMPRODUCT(AF9:AF32,AH9:AH32)/SUM(AH9:AH32)),0)","v":0},{"$f":"AD20","v":0},{"$f":"AD16","v":0},null,null,0]
[null,{"$f":"AR7","v":"-"},{"$f":"IFERROR(IF(AR7=\"-\", 0, SUMPRODUCT(AT9:AT32,AV9:AV32)/SUM(AV9:AV32)),0)","v":0},{"$f":"AR20","v":0},{"$f":"AR16","v":0},null,null,0]
[null,{"$f":"BF7","v":"-"},{"$f":"IFERROR(IF(BF7=\"-\", 0, SUMPRODUCT(BH9:BH32,BJ9:BJ32)/SUM(BJ9:BJ32)),0)","v":0},{"$f":"BF20","v":0},{"$f":"BF16","v":0},null,null,0]
[null,{"$f":"BT7","v":"-"},{"$f":"IFERROR(IF(BT7=\"-\", 0, SUMPRODUCT(BV9:BV32,BX9:BX32)/SUM(BX9:BX32)),0)","v":0},{"$f":"BT20","v":0},{"$f":"BT16","v":0},null,null,0]
[]
[]
[null,"Section L5: Project Methane Emissions from Non-BCS Related Sources (PECH4,nBCS) (Reference: [Equation 5.9 in LOP])"]
[null,null,"L5.2  Methane Conversion Factor \n(MCFS, fraction)","L5.3\nManure/Effluent Managed in Non-BCS (Other) Systems (MSL,S, fraction)"]
[null,"Livestock Category (L)",null,{"$f":"$B$7","v":"-"},{"$f":"$P$7","v":"-"},{"$f":"$AD$7","v":"-"},{"$f":"$AR$7","v":"-"},{"$f":"$BF$7","v":"-"},{"$f":"$BT$7","v":"-"}]
[null,"L5.1.a  Non-BCS Storage/Treatment Systems for Manure"]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B96>0, VLOOKUP(B96, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B97>0, VLOOKUP(B97, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B98>0, VLOOKUP(B98, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B99>0, VLOOKUP(B99, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B100>0, VLOOKUP(B100, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"L5.1.b   Other Storage/Treatment Systems for Effluent"]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B102>0, VLOOKUP(B102, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B103>0, VLOOKUP(B103, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B104>0, VLOOKUP(B104, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B105>0, VLOOKUP(B105, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"~~Select Storage/Treatment~~",{"$f":"IFERROR(IF(B106>0, VLOOKUP(B106, Reference!$A$168:$T$184, MATCH('Biogas-to-RNG'!$F$20, Reference!$A$168:$T$168), FALSE),0),0)","v":0}]
[null,"L5.4  \nCH4 Emission Factor, non-BCS \n(EFCH4,L,nBCSs , kg CH4/head)",null,{"$f":"($D$84*$E$84*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,D96:D106)","v":0},{"$f":"($D$85*$E$85*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,E96:E106)","v":0},{"$f":"($D$86*$E$86*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,F96:F106)","v":0},{"$f":"($D$87*$E$87*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,G96:G106)","v":0},{"$f":"($D$88*$E$88*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,H96:H106)","v":0},{"$f":"($D$89*$E$89*$I$84*0.68)*SUMPRODUCT($C$96:$C$106,I96:I106)","v":0},"Total\n(PECH4,non-BCS , MT CH4)"]
[null,"L5.5\nProject Methane Emissions, non-BSC \n(PECH4,L,nBCS , MT CH4)",null,{"$f":"D107*$C$84*0.001","v":0},{"$f":"E107*$C$85*0.001","v":0},{"$f":"F107*$C$86*0.001","v":0},{"$f":"G107*$C$87*0.001","v":0},{"$f":"H107*$C$88*0.001","v":0},{"$f":"I107*$C$89*0.001","v":0},{"$f":"SUM(D108:I108)","v":0}]

{"sheet":"Avoided Emissions","index":3,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[45,1,45,3],[45,5,45,7],[34,1,34,3],[34,5,34,7],[34,8,35,9],[36,8,36,9],[37,5,39,7],[38,1,38,3],[2,1,2,6],[4,1,5,1],[4,2,5,2],[4,3,4,6],[7,4,30,4],[7,5,30,5]]}
[null,null,"Calculations of the Avoided Emissions"]
[]
[null,"Section P1. Results from the \"Manure-to-Biogas (LOP Inputs)\" tab"]
[null,"P1.1  Select Digester Type","Covered Lagoon"]
[null,"P1.2 Reporting Month\n(MM/YYYY)","P1.3 Baseline methane emissions (BECH4 Mod)","P1.4 Project methane emissions"]
[null,null,null,"P1.4.a Venting methane (CH4 vent)","P1.4.b Effluent ponds methane (PECH4,EP)","P1.4.c Storage/Treatment methane (PECH4,nBCS)","P1.4.d Digester leakage"]
[null,null,"Metric Ton","Metric Ton","Metric Ton","Metric Ton","Metric Ton"]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C9=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C9)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N9+'Manure-to-Biogas (LOP Inputs)'!AB9+'Manure-to-Biogas (LOP Inputs)'!AP9+'Manure-to-Biogas (LOP Inputs)'!BD9+'Manure-to-Biogas (LOP Inputs)'!BR9+'Manure-to-Biogas (LOP Inputs)'!CF9","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I54","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C28*'Biogas-to-RNG'!D28)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C28*'Biogas-to-RNG'!D28*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C10=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C10)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N10+'Manure-to-Biogas (LOP Inputs)'!AB10+'Manure-to-Biogas (LOP Inputs)'!AP10+'Manure-to-Biogas (LOP Inputs)'!BD10+'Manure-to-Biogas (LOP Inputs)'!BR10+'Manure-to-Biogas (LOP Inputs)'!CF10","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I55","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C29*'Biogas-to-RNG'!D29)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C29*'Biogas-to-RNG'!D29*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C11=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C11)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N11+'Manure-to-Biogas (LOP Inputs)'!AB11+'Manure-to-Biogas (LOP Inputs)'!AP11+'Manure-to-Biogas (LOP Inputs)'!BD11+'Manure-to-Biogas (LOP Inputs)'!BR11+'Manure-to-Biogas (LOP Inputs)'!CF11","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I56","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C30*'Biogas-to-RNG'!D30)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C30*'Biogas-to-RNG'!D30*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C12=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C12)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N12+'Manure-to-Biogas (LOP Inputs)'!AB12+'Manure-to-Biogas (LOP Inputs)'!AP12+'Manure-to-Biogas (LOP Inputs)'!BD12+'Manure-to-Biogas (LOP Inputs)'!BR12+'Manure-to-Biogas (LOP Inputs)'!CF12","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I57","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C31*'Biogas-to-RNG'!D31)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C31*'Biogas-to-RNG'!D31*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C13=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C13)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N13+'Manure-to-Biogas (LOP Inputs)'!AB13+'Manure-to-Biogas (LOP Inputs)'!AP13+'Manure-to-Biogas (LOP Inputs)'!BD13+'Manure-to-Biogas (LOP Inputs)'!BR13+'Manure-to-Biogas (LOP Inputs)'!CF13","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I58","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C32*'Biogas-to-RNG'!D32)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C32*'Biogas-to-RNG'!D32*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C14=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C14)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N14+'Manure-to-Biogas (LOP Inputs)'!AB14+'Manure-to-Biogas (LOP Inputs)'!AP14+'Manure-to-Biogas (LOP Inputs)'!BD14+'Manure-to-Biogas (LOP Inputs)'!BR14+'Manure-to-Biogas (LOP Inputs)'!CF14","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I59","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C33*'Biogas-to-RNG'!D33)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C33*'Biogas-to-RNG'!D33*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C15=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C15)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N15+'Manure-to-Biogas (LOP Inputs)'!AB15+'Manure-to-Biogas (LOP Inputs)'!AP15+'Manure-to-Biogas (LOP Inputs)'!BD15+'Manure-to-Biogas (LOP Inputs)'!BR15+'Manure-to-Biogas (LOP Inputs)'!CF15","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I60","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C34*'Biogas-to-RNG'!D34)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C34*'Biogas-to-RNG'!D34*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C16=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C16)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N16+'Manure-to-Biogas (LOP Inputs)'!AB16+'Manure-to-Biogas (LOP Inputs)'!AP16+'Manure-to-Biogas (LOP Inputs)'!BD16+'Manure-to-Biogas (LOP Inputs)'!BR16+'Manure-to-Biogas (LOP Inputs)'!CF16","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I61","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C35*'Biogas-to-RNG'!D35)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C35*'Biogas-to-RNG'!D35*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C17=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C17)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N17+'Manure-to-Biogas (LOP Inputs)'!AB17+'Manure-to-Biogas (LOP Inputs)'!AP17+'Manure-to-Biogas (LOP Inputs)'!BD17+'Manure-to-Biogas (LOP Inputs)'!BR17+'Manure-to-Biogas (LOP Inputs)'!CF17","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I62","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C36*'Biogas-to-RNG'!D36)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C36*'Biogas-to-RNG'!D36*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C18=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C18)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N18+'Manure-to-Biogas (LOP Inputs)'!AB18+'Manure-to-Biogas (LOP Inputs)'!AP18+'Manure-to-Biogas (LOP Inputs)'!BD18+'Manure-to-Biogas (LOP Inputs)'!BR18+'Manure-to-Biogas (LOP Inputs)'!CF18","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I63","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C37*'Biogas-to-RNG'!D37)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C37*'Biogas-to-RNG'!D37*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C19=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C19)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N19+'Manure-to-Biogas (LOP Inputs)'!AB19+'Manure-to-Biogas (LOP Inputs)'!AP19+'Manure-to-Biogas (LOP Inputs)'!BD19+'Manure-to-Biogas (LOP Inputs)'!BR19+'Manure-to-Biogas (LOP Inputs)'!CF19","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I64","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C38*'Biogas-to-RNG'!D38)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C38*'Biogas-to-RNG'!D38*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C20=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C20)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N20+'Manure-to-Biogas (LOP Inputs)'!AB20+'Manure-to-Biogas (LOP Inputs)'!AP20+'Manure-to-Biogas (LOP Inputs)'!BD20+'Manure-to-Biogas (LOP Inputs)'!BR20+'Manure-to-Biogas (LOP Inputs)'!CF20","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I65","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C39*'Biogas-to-RNG'!D39)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C39*'Biogas-to-RNG'!D39*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C21=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C21)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N21+'Manure-to-Biogas (LOP Inputs)'!AB21+'Manure-to-Biogas (LOP Inputs)'!AP21+'Manure-to-Biogas (LOP Inputs)'!BD21+'Manure-to-Biogas (LOP Inputs)'!BR21+'Manure-to-Biogas (LOP Inputs)'!CF21","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I66","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C40*'Biogas-to-RNG'!D40)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C40*'Biogas-to-RNG'!D40*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C22=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C22)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N22+'Manure-to-Biogas (LOP Inputs)'!AB22+'Manure-to-Biogas (LOP Inputs)'!AP22+'Manure-to-Biogas (LOP Inputs)'!BD22+'Manure-to-Biogas (LOP Inputs)'!BR22+'Manure-to-Biogas (LOP Inputs)'!CF22","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I67","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C41*'Biogas-to-RNG'!D41)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C41*'Biogas-to-RNG'!D41*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C23=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C23)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N23+'Manure-to-Biogas (LOP Inputs)'!AB23+'Manure-to-Biogas (LOP Inputs)'!AP23+'Manure-to-Biogas (LOP Inputs)'!BD23+'Manure-to-Biogas (LOP Inputs)'!BR23+'Manure-to-Biogas (LOP Inputs)'!CF23","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I68","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C42*'Biogas-to-RNG'!D42)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C42*'Biogas-to-RNG'!D42*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C24=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C24)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N24+'Manure-to-Biogas (LOP Inputs)'!AB24+'Manure-to-Biogas (LOP Inputs)'!AP24+'Manure-to-Biogas (LOP Inputs)'!BD24+'Manure-to-Biogas (LOP Inputs)'!BR24+'Manure-to-Biogas (LOP Inputs)'!CF24","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I69","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C43*'Biogas-to-RNG'!D43)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C43*'Biogas-to-RNG'!D43*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C25=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C25)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N25+'Manure-to-Biogas (LOP Inputs)'!AB25+'Manure-to-Biogas (LOP Inputs)'!AP25+'Manure-to-Biogas (LOP Inputs)'!BD25+'Manure-to-Biogas (LOP Inputs)'!BR25+'Manure-to-Biogas (LOP Inputs)'!CF25","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I70","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C44*'Biogas-to-RNG'!D44)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C44*'Biogas-to-RNG'!D44*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C26=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C26)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N26+'Manure-to-Biogas (LOP Inputs)'!AB26+'Manure-to-Biogas (LOP Inputs)'!AP26+'Manure-to-Biogas (LOP Inputs)'!BD26+'Manure-to-Biogas (LOP Inputs)'!BR26+'Manure-to-Biogas (LOP Inputs)'!CF26","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I71","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C45*'Biogas-to-RNG'!D45)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C45*'Biogas-to-RNG'!D45*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C27=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C27)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N27+'Manure-to-Biogas (LOP Inputs)'!AB27+'Manure-to-Biogas (LOP Inputs)'!AP27+'Manure-to-Biogas (LOP Inputs)'!BD27+'Manure-to-Biogas (LOP Inputs)'!BR27+'Manure-to-Biogas (LOP Inputs)'!CF27","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I72","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C46*'Biogas-to-RNG'!D46)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C46*'Biogas-to-RNG'!D46*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C28=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C28)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N28+'Manure-to-Biogas (LOP Inputs)'!AB28+'Manure-to-Biogas (LOP Inputs)'!AP28+'Manure-to-Biogas (LOP Inputs)'!BD28+'Manure-to-Biogas (LOP Inputs)'!BR28+'Manure-to-Biogas (LOP Inputs)'!CF28","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I73","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C47*'Biogas-to-RNG'!D47)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C47*'Biogas-to-RNG'!D47*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C29=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C29)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N29+'Manure-to-Biogas (LOP Inputs)'!AB29+'Manure-to-Biogas (LOP Inputs)'!AP29+'Manure-to-Biogas (LOP Inputs)'!BD29+'Manure-to-Biogas (LOP Inputs)'!BR29+'Manure-to-Biogas (LOP Inputs)'!CF29","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I74","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C48*'Biogas-to-RNG'!D48)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C48*'Biogas-to-RNG'!D48*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C30=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C30)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N30+'Manure-to-Biogas (LOP Inputs)'!AB30+'Manure-to-Biogas (LOP Inputs)'!AP30+'Manure-to-Biogas (LOP Inputs)'!BD30+'Manure-to-Biogas (LOP Inputs)'!BR30+'Manure-to-Biogas (LOP Inputs)'!CF30","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I75","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C49*'Biogas-to-RNG'!D49)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C49*'Biogas-to-RNG'!D49*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C31=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C31)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N31+'Manure-to-Biogas (LOP Inputs)'!AB31+'Manure-to-Biogas (LOP Inputs)'!AP31+'Manure-to-Biogas (LOP Inputs)'!BD31+'Manure-to-Biogas (LOP Inputs)'!BR31+'Manure-to-Biogas (LOP Inputs)'!CF31","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I76","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C50*'Biogas-to-RNG'!D50)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C50*'Biogas-to-RNG'!D50*Reference!$E$16/10^6)","v":0}]
[null,{"$f":"IF('Manure-to-Biogas (LOP Inputs)'!C32=0, \" \", 'Manure-to-Biogas (LOP Inputs)'!C32)","v":" "},{"$f":"'Manure-to-Biogas (LOP Inputs)'!N32+'Manure-to-Biogas (LOP Inputs)'!AB32+'Manure-to-Biogas (LOP Inputs)'!AP32+'Manure-to-Biogas (LOP Inputs)'!BD32+'Manure-to-Biogas (LOP Inputs)'!BR32+'Manure-to-Biogas (LOP Inputs)'!CF32","v":0},{"$f":"'Manure-to-Biogas (LOP Inputs)'!I77","v":0},null,null,{"$f":"(('Biogas-to-RNG'!C51*'Biogas-to-RNG'!D51)*Reference!$E$16/(10^6)/(IF('Avoided Emissions'!$C$4=\"Covered Lagoon\",(100%-Reference!$D$107),(100%-Reference!$D$109))))-('Biogas-to-RNG'!C51*'Biogas-to-RNG'!D51*Reference!$E$16/10^6)","v":0}]
[null,"Monthly Average",{"$f":"IFERROR(SUM(C8:C31)/'Manure-to-Biogas (LOP Inputs)'!B9+'Manure-to-Biogas (LOP Inputs)'!J47/'Manure-to-Biogas (LOP Inputs)'!B9, 0)","v":0},{"$f":"IFERROR(SUM(D8:D31)/'Biogas-to-RNG'!J24,0)","v":0},{"$f":"IFERROR('Manure-to-Biogas (LOP Inputs)'!K84/'Manure-to-Biogas (LOP Inputs)'!B9,0)","v":0},{"$f":"IFERROR('Manure-to-Biogas (LOP Inputs)'!J108/'Manure-to-Biogas (LOP Inputs)'!B9,0)","v":0},{"$f":"IFERROR(SUM(G8:G31)/'Biogas-to-RNG'!J24,0)","v":0}]
[]
[]
[null,"Section P2. Avoided CH4 Emissions Calculation Detail",null,null,null,"Section P3. Avoided CO2 Emissions Calculation Detail"]
[null,null,"Value","Unit (of Methane)",null,null,"Value","Unit"]
[null,"Subtotal Project Methane emissions (Calculation)",{"$f":"(D32+E32+F32+G32)*'Biogas-to-RNG'!J24","v":0},"MT CH4",null,"Avoided CO2",{"$f":"IF((-C38=C40),0,-(C40+C37-C32*'Biogas-to-RNG'!J24)*(44/16))","v":0},"MT CO2"]
[null,"Net methane emissions avoided  (Calculation)",{"$f":"IF((C37-C32*'Biogas-to-RNG'!J24)<(C40*-1),(C40*-1),(C37-C32*'Biogas-to-RNG'!J24))","v":0},"MT CH4",null,"This is avoided emissions from carbon that would not convert to CH4 but CO2 in the baseline case. This carbon would release as CH4 in the project scenario. \n\n(Excess CH4 x 44 g/mol CO2:16 g/mol CH4)"]
[null,"Metered Methane Quantities (project monitoring parameter, metered)"]
[null,"Total methane produced from digester (metered)",{"$f":"'Biogas-to-RNG'!C52*'Biogas-to-RNG'!D52*Reference!$E$16/1000000","v":0},"MT CH4"]
[null,"Methane at inlet to cleanup/upgrading facility",{"$f":"'Biogas-to-RNG'!G52*'Biogas-to-RNG'!H52*Reference!$E$16/1000000","v":0},"MT CH4"]
[null,"Directly flared biogas (excluded from LCFS pathway system boundary)",{"$f":"C40-C41","v":0},"MT CH4"]
[null,"Biomethane Sales Gas (delivered to pipeline/qualifying end use)",{"$f":"'Biogas-to-RNG'!AD52/Reference!$D$16*Reference!$E$16","v":0},"MT CH4"]
[null,"RNG in tail gas flared (from upgrading)",{"$f":"'Biogas-to-RNG'!AC53*Reference!$E$16/1000000","v":0},"MT CH4"]
[null,"RNG associated with onsite electricity production",{"$f":"'Biogas-to-RNG'!AE52/Reference!D16*Reference!E16","v":0},"MT CH4"]
[null,"Avoided Methane and CO2 calculations"]
[null,"%  alloc. factor for CH4 avoided - RNG (vehicle use)",{"$f":"IFERROR((C41-C45*IF('Biogas-to-RNG'!AF52=0, 0, 'Biogas-to-RNG'!AG52/'Biogas-to-RNG'!AF52))/(C40),0)","v":0},"%"]
[null,"%  alloc. factor for diverted  CO2 - RNG",{"$f":"C47","v":0},"%"]
[null,"Net CH4 avoided, allocated to RNG ",{"$f":"C38*C47","v":0},"MT CH4"]
[null,"Net allocated MT CH4 avoided per MT RNG",{"$f":"IFERROR(C49/C43,0)","v":0},"MT avoided/MT produced",null,"Diverted CO2 allocated to RNG (vehicle use)",{"$f":"G37*C48","v":0},"MT CO2"]
[null,"Avoided (g CH4) per MJ RNG",{"$f":"C50*1000000/Reference!B16*Reference!E16/Reference!H45","v":0},"g CH4/MJ",null,"Diverted CO2 emissions from land application",{"$f":"IFERROR(G50/C43,0)","v":0},"MT CO2/MT CH4 produced"]
[null,"Avoided (g CO2e) per RNG output:",{"$f":"IFERROR(C51*Reference!B20,0)","v":0},"g CO2e/MJ",null,null,{"$f":"IFERROR(G51*1000000/Reference!B16*Reference!E16/Reference!H45,0)","v":0},"g CO2e/MJ"]

{"sheet":"Biogas-to-RNG","index":4,"n_rows":99,"n_cols":38,"rows_kept":99,"cut":false,"hidden":false,"merged":[[91,6,92,6],[93,3,93,4],[83,5,84,5],[83,6,84,6],[94,2,95,4],[83,1,88,1],[83,2,85,2],[83,3,84,3],[83,4,84,4],[85,3,85,5],[88,3,88,5],[90,1,98,1],[90,3,90,4],[91,2,93,2],[91,5,92,5],[91,3,92,4],[26,37,27,37],[29,33,31,33],[81,1,82,1],[81,2,82,2],[32,34,37,34],[28,36,29,36],[28,37,29,37],[35,33,38,33],[41,33,44,33],[60,1,60,6],[63,2,69,2],[69,3,69,5],[70,2,80,2],[80,3,80,5],[53,33,53,34],[54,33,54,34],[23,14,23,15],[23,19,23,23],[24,17,24,29],[24,30,24,32],[26,36,27,36],[24,11,24,16],[16,5,16,6],[17,2,17,3],[18,2,18,3],[19,2,19,3],[1,17,1,23],[4,2,4,7],[15,5,15,6],[15,7,19,9],[16,2,16,3],[17,4,18,4],[17,5,18,6],[5,27,5,34],[9,3,9,9],[10,3,10,9],[86,2,87,2],[55,33,56,34],[57,33,57,34],[19,5,19,6],[11,3,11,9],[24,2,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,10],[14,2,14,3],[14,5,14,6],[14,7,14,9],[15,2,15,3]]}
[]
[]
[]
[]
[null,null,"Tier 1 CI Calculator for\nDairy and Swine Manure Biomethane"]
[]
[]
[]
[null,"Pathway Summary and Estimated CI (g/MJ)"]
[null,"CNG CI",{"$f":"G97","v":0},{"$f":"CONCATENATE(\"Pathway Description: RNG produced from livestock manure, pipelined to \",F15, \" for Compressed Natural Gas\")","v":"Pathway Description: RNG produced from livestock manure, pipelined to  for Compressed Natural Gas"}]
[null,"LNG CI",{"$f":"G98","v":0},{"$f":"CONCATENATE(\"Pathway Description: RNG produced from livestock manure, pipelined to \",C20, \" for liquefaction, then transported by truck to Oregon LNG stations\")","v":"Pathway Description: RNG produced from livestock manure, pipelined to  for liquefaction, then transported by truck to Oregon LNG stations"}]
[null,"L-CNG CI",{"$f":"G99","v":0},{"$f":"CONCATENATE(\"Pathway Description: RNG produced from livestock manure, pipelined to \",C20, \" for liquefaction, then transported by truck to Oregon LNG stations, re-gasified and compresses to Liquefied CNG\")","v":"Pathway Description: RNG produced from livestock manure, pipelined to  for liquefaction, then transported by truck to Oregon LNG stations, re-gasified and compresses to Liquefied CNG"}]
[]
[null,"Section  1. Applicant Information"]
[null,"1.1  Company Name and ID \nEx. Applicant, LLC (CXXXX)",null,null,"1.6  CNG Dispensing Station(s) Location (Street, City, State)",null,null,"1.11  Names of All Intermediate Facilities (e.g., manure sources not co-located with the biogas upgrading facility) "]
[null,"1.2  Facility Name and ID\nEx. Production, LLC (F0XXXX)",null,null,"1.7 LNG Dispensing Station(s) Location (Street, City, State)"]
[null,"1.3  Facility Physical Address\n(Upgrading facility for RNG)",null,null,"1.8 LNG and/or L-CNG Dispensing Station(s) Location (Street, City, State)"]
[null,"1.4.a  Digester Location \n(Street, City)",null,null,"1.9 Digester Type",{"$f":"'Avoided Emissions'!C4","v":"Covered Lagoon"}]
[null,"1.4.b  Digester Location \n(State)","Oregon"]
[null,"1.5  LNG Liquefaction Facility Location (Street, City, State)",null,null,"1.10 Average Annual Temperature (°C)",{"$f":"IFERROR(IF(AVERAGE('Manure-to-Biogas (LOP Inputs)'!G9:G32)<=10,\"≤10\",IF(AVERAGE('Manure-to-Biogas (LOP Inputs)'!G9:G32)>=28,\"≥28\", ROUNDUP(AVERAGE('Manure-to-Biogas (LOP Inputs)'!G9:G32), 0))), \"\")","v":""}]
[]
[]
[null,"Section 2. Biomethane Production Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 3. LNG and L-CNG Production and Transport Data"]
[null,"Data Years","2.1  Select Electricity Mix for Biomethane","ORMX",null,{"$f":"IF(D24=\"User Defined Mix\", \"Enter User Defined Mix EF in cell E5 in 'EF Table' worksheet\",\"\")","v":""},"2.2a   Provisional Pathway?",{"$f":"IF(COUNTA(B28:B51)=24, \"No\", \"Yes\")","v":"Yes"},"2.2b  Number of Project Reporting Month ",{"$f":"COUNTA(B28:B51)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.1 LNG, L-CNG Facility Name and ID"]
[null,"Process ","Raw Biogas Production",null,"Flared Biogas",null,"Raw Biogas Feedstock \n(at Inlet to cleanup/upgrading)",null,"Baseline energy use",null,null,"Digester energy use (Project)",null,null,null,null,null," Upgrading and compression energy use (Project)",null,null,null,null,null,null,null,null,null,null,null,null,"On-site Electricity Production From RNG",null,null,"Biomethane Transport",{"$f":"IF($D$24=\"User Defined Mix\", \"User-Defined Electricity EF\",\"\")","v":""},null,"3.2 Transport Distance from Liquefaction Plant to station by HD Truck (miles)"]
[null,"2.3 \nReporting Month\n","2.4 \n Total Raw Biogas Flow, (metered)","2.5\nBiomethane Content \n","2.6 \nFlared Biogas Flow, (metered)","2.7\nBiomethane Content \n","2.8\n Raw Biogas Flow to Upgrading, (metered)","2.9\nBiomethane Content \n","2.10 \nDiesel (baseline manure transport and handling)","2.11 \n Utility Sourced NG (baseline)","2.12 \nGrid Electricity (baseline manure pumping and solids separation)","2.13 \nGrid Electricity (for digester )","2.14\nRaw Biogas (for digester )","2.15\nBiomethane (for digester )","2.16\nUtility Sourced NG (for digester)","2.17\nDiesel (digester project manure transport and handling)","2.18\nOther Fuel Used\n(for digester )","2.19\nUtility Sourced NG (upgrading and compression)","2.20\nRaw Biogas (as Process Fuel for upgrading and compression)","2.21\nBiomethane (as Process Fuel for upgrading and compression)"," 2.22\nOn-Site Electricity from Biogas (upgrading and compression)","2.23\nGrid Electricity (upgrading and compression) ","2.24\nDiesel \n(upgrading and compression)","2.25\nOther fuel used \n(upgrading and compression)","2.26\nBuy back fossil NG to boost Btu prior to pipeline injection","2.27\nPropane used (boost Btu prior to pipeline injection, other purpose)","2.28\nFuel used for Biomethane transport","2.29\nFlared biomethane including tail gas from upgrading, (metered)","2.30\nBiomethane Content in Flared Gas\n","2.31\nBiomethane Injected into Pipeline for Transportation Fuel Production (metered), (subtract buyback NG and Propane if used to boost Btu)","2.32\nBiomethane to Electricity Production","2.33\n On-site Electricity Production","2.34\nExport Electricity","2.35\nNG pipeline Transmission",{"$f":"IF(D24=\"User Defined Mix\", \"2.36  \nUser Defined Electricity Mix\",\"2.36 User Defined Parameters \")","v":"2.36 User Defined Parameters "},null,"3.3 Liquefaction EF (gCO2e/gallon LNG)"]
[null,"(MM/YYYY)","Standard Cubic Feet @ 60oF, 1 atm","% Methane","Standard Cubic Feet \n@ 60oF, 1 atm","% Methane","Standard Cubic Feet @ 60oF, 1 atm","% Methane","Gallons","MMBtu, HHV","kWh","kWh","MMBtu, LHV","MMBtu, HHV","MMBtu, HHV","Gallons","User-Defined Fuel-1 (MJ)","MMBtu, HHV","MMBtu, LHV","MMBtu, HHV","kWh","kWh","Gallons","User-Defined Fuel-2 (MJ)","MMBtu, HHV","Gallons","User-Defined Fuel-3 (MJ)","Standard Cubic Feet @ 60oF, 1 atm","% Methane","MMBtu, HHV","MMBtu, HHV","kWh","kWh","Miles",{"$f":"IF($D$24=\"User Defined Mix\", \"gCO2e/kWh\",\"N/A\")","v":"N/A"},null,"3.4 LNG Truck Type","Boil-Off Recovery Equipped"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('EF Table'!E5<>\"\",'EF Table'!E5, \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.5 Dispensed LNG L-CNG (MMBtu, LHV)",{"$f":"AD55*AH46*(1-AH40*'EF Table'!F37)*(1-IF(AL27=\"Boil-Off Recovery Equipped\",'EF Table'!F40,'EF Table'!F41))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.35.a  From upgrading facility to CNG station.",{"$f":"IF(D24=\"User Defined Mix\", \"\",\"N/A\")","v":"N/A"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.35.b  From upgrading facility to LNG plant"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.35.c  Percentage of injected CNG that is converted into LNG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total ",{"$f":"SUM(C28:C51)","v":0},{"$f":"IFERROR(SUMPRODUCT(D28:D51,C28:C51)/C52,0)","v":0},{"$f":"SUM(E28:E51)","v":0},{"$f":"IFERROR(SUMPRODUCT(F28:F51,E28:E51)/E52,0)","v":0},{"$f":"SUM(G28:G51)","v":0},{"$f":"IFERROR(SUMPRODUCT(H28:H51,G28:G51)/G52,0)","v":0},{"$f":"SUM(I28:I51)","v":0},{"$f":"SUM(J28:J51)","v":0},{"$f":"SUM(K28:K51)","v":0},{"$f":"SUM(L28:L51)","v":0},{"$f":"SUM(M28:M51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(SUMPRODUCT(AC28:AC51,AB28:AB51)/AB52,0)","v":0},{"$f":"SUM(AD28:AD51)","v":0},{"$f":"SUM(AE28:AE51)","v":0},{"$f":"SUM(AF28:AF51)","v":0},{"$f":"IFERROR(AVERAGE(AG28:AG51),0)","v":0}]
[null,"Methane, SCF",null,{"$f":"C52*D52","v":0},null,{"$f":"E52*F52","v":0},null,{"$f":"G52*H52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB52*AC52","v":0}]
[null,"MMBtu, HHV",null,{"$f":"D53*Reference!D16/1000000","v":0},null,{"$f":"F53*Reference!D16/1000000","v":0},null,{"$f":"H53*Reference!$D$16/10^6","v":0},null,{"$f":"J52","v":0},null,null,null,{"$f":"N52","v":0},{"$f":"O52","v":0},null,null,{"$f":"R52","v":0},null,{"$f":"T52","v":0},null,null,null,null,null,null,null,null,{"$f":"AC53*Reference!$D$16/10^6","v":0},{"$f":"AD52","v":0},{"$f":"AE52","v":0},null,null,"2.37 Fugitive methane from upgrading (%)"]
[null,"MMBtu, LHV",null,{"$f":"D53*Reference!$C$16/1000000","v":0},null,{"$f":"F53*Reference!$C$16/1000000","v":0},null,{"$f":"H53*Reference!$C$16/1000000","v":0},null,{"$f":"J54*Reference!F15","v":0},null,{"$f":"L52","v":0},{"$f":"M52","v":0},{"$f":"N54*Reference!F16","v":0},{"$f":"O52*Reference!F15","v":0},null,{"$f":"Q52","v":0},{"$f":"R54*Reference!$C$15/Reference!$D$15","v":0},{"$f":"S52","v":0},{"$f":"T54*Reference!$F$16","v":0},null,null,null,{"$f":"X52","v":0},null,null,{"$f":"AA52","v":0},null,{"$f":"AC53*Reference!$C$16/1000000","v":0},{"$f":"AD52*Reference!F16","v":0},{"$f":"AE54*Reference!F16","v":0},null,null,{"$f":"IF(AA52>0,MAX(IFERROR(1-((AD55+AE55+AC55+T55+N55)/H55),0),0.0235), MAX(IFERROR(1-((AD55+AE55+AC55+T55+N55)/H55),0),0.02))","v":0.02}]
[null,"EF Units",null,null,null,null,null,null,"gCO2e/gallon","gCO2e/MMBtu","gCO2e/kWh",{"$f":"K56","v":"gCO2e/kWh"},"gCO2e/MMBtu","gCO2e/MMBtu","gCO2e/MMBtu",{"$f":"I56","v":"gCO2e/gallon"},{"$f":"VLOOKUP(Q27,'EF Table'!C76:E82, 3, FALSE)","v":"gCO2e/MJ"},"gCO2e/MMBtu","gCO2e/MMBtu","gCO2e/MMBtu","gCO2e/kWh","gCO2e/kWh","gCO2e/gallon",{"$f":"VLOOKUP(X27,'EF Table'!C76:E82, 3, FALSE)","v":"gCO2e/MJ"},null,null,{"$f":"VLOOKUP(AA27,'EF Table'!C76:E82, 3, FALSE)","v":"gCO2e/MJ"},null,"gCO2e/MMBtu",null,null,null,null,"2.38 Maximum available biomethane for dispensing   (MMBtu, LHV)"]
[null,"EF",null,null,null,null,null,null,{"$f":"'EF Table'!D76","v":12308.3541997418},{"$f":"'EF Table'!D77","v":75495.751250270798},{"$f":"VLOOKUP(D24,'EF Table'!D4:E34,2,FALSE)","v":403.07602628539564},{"$f":"VLOOKUP(D24,'EF Table'!D4:E34,2,FALSE)","v":403.07602628539564},{"$f":"'EF Table'!D62*Reference!H45","v":60403.800714157704},{"$f":"'EF Table'!I52*Reference!H45","v":59501.074964157706},{"$f":"'EF Table'!D77","v":75495.751250270798},{"$f":"'EF Table'!D76","v":12308.3541997418},{"$f":"VLOOKUP(Q27,'EF Table'!C76:E82, 2, FALSE)","v":0},{"$f":"'EF Table'!D77","v":75495.751250270798},{"$f":"'EF Table'!D62*Reference!H45","v":60403.800714157704},{"$f":"'EF Table'!$I$52*Reference!$H$45","v":59501.074964157706},{"$f":"'EF Table'!$D$72","v":641.42841673741543},{"$f":"VLOOKUP(D24,'EF Table'!D4:E34,2,FALSE)","v":403.07602628539564},{"$f":"'EF Table'!D76","v":12308.3541997418},{"$f":"VLOOKUP(X27,'EF Table'!C76:E82, 2, FALSE)","v":0},null,null,{"$f":"VLOOKUP(AA27,'EF Table'!C76:E82, 2, FALSE)","v":0},null,{"$f":"'EF Table'!D62*Reference!H45","v":60403.800714157704}]
[null,"GHG Emissions, gCO2e",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R55*R57","v":0},null,{"$f":"T52*T57","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD55*(1-AH34*'EF Table'!F37)","v":0}]
[]
[]
[null,"Section 4. CI Calculation Details"]
[]
[null,"Manure to CNG, LNG, L-CNG",null,null,"GHG emissions CO2e","CI, gCO2e/MMBtu","gCO2e/MJ"]
[null,{"$f":"D24","v":"ORMX"},"Raw Biogas Production-Digester","Net-Diesel",{"$f":"IF(I52>P52,0,P52-I52)*I57","v":0},{"$f":"IFERROR(E64/$AH$58,0)","v":0},{"$f":"F64/Reference!$H$45","v":0}]
[null,null,null,"Net-Grid electricity",{"$f":"IF(K52>L52,0,L52-K52)*K57","v":0},0,{"$f":"F65/Reference!$H$45","v":0}]
[null,null,null,"Utility source NG",{"$f":"O55*O57","v":0},0,{"$f":"F66/Reference!$H$45","v":0}]
[null,null,null,"Raw Biogas (heat)",{"$f":"M55*M57","v":0},0,{"$f":"F67/Reference!$H$45","v":0}]
[null,null,null,"Biomethane (heat)",{"$f":"N55*N57","v":0},0,{"$f":"F68/Reference!$H$45","v":0}]
[null,null,null,{"$f":"CONCATENATE(Q27, \" used for digester\")","v":"User-Defined Fuel-1 (MJ) used for digester"},{"$f":"Q55*Q57","v":0},0,{"$f":"F69/Reference!$H$45","v":0}]
[null,null,null,"Subtotal",null,null,{"$f":"SUM(G64:G69)","v":0}]
[null,null,"Biogas upgrading & Compression & Biomethane transport","Grid electricity",{"$f":"V52*V57","v":0},{"$f":"IFERROR(E71/$AH$58,0)","v":0},{"$f":"F71/Reference!$H$45","v":0}]
[null,null,null,"Utility source NG",{"$f":"R55*R57","v":0},0,{"$f":"F72/Reference!$H$45","v":0}]
[null,null,null,"Raw Biogas (process fuel)",{"$f":"S55*S57","v":0},0,{"$f":"F73/Reference!$H$45","v":0}]
[null,null,null,"Biomethane (process fuel)",{"$f":"T55*T57","v":0},0,{"$f":"F74/Reference!$H$45","v":0}]
[null,null,null,"Onsite electricity from biomethane",{"$f":"U52*U57","v":0},0,{"$f":"F75/Reference!$H$45","v":0}]
[null,null,null,"Diesel",{"$f":"W52*W57","v":0},0,{"$f":"F76/Reference!$H$45","v":0}]
[null,null,null,{"$f":"CONCATENATE(X27, \" used for upgrading and compression\")","v":"User-Defined Fuel-2 (MJ) used for upgrading and compression"},{"$f":"X55*X57","v":0},0,{"$f":"F77/Reference!$H$45","v":0}]
[null,null,null,{"$f":"CONCATENATE(\"Biomethane transported by truck (\", AA27, \")\")","v":"Biomethane transported by truck (User-Defined Fuel-3 (MJ))"},{"$f":"AA55*AA57","v":0},0,{"$f":"F78/Reference!$H$45","v":0}]
[null,null,null,"Biomethane (flaring)",{"$f":"AC55*AC57","v":0},0,{"$f":"F79/Reference!$H$45","v":0}]
[null,null,null,"Feed Loss (fugitive methane)",{"$f":"H53*AH55*Reference!E16*Reference!B20","v":0},0,{"$f":"F80/Reference!$H$45","v":0}]
[null,null,null,"Subtotal",null,null,{"$f":"SUM(G71:G80)","v":0}]
[null,"US Average","Biomethane Transmission","by pipeline to LNG Plant",{"$f":"($AD$55*AH46*Reference!H45*AH40)*('EF Table'!F38+('EF Table'!F37/(Reference!C16*Reference!G45)*Reference!E16*Reference!B20))","v":0},{"$f":"IFERROR(E82/$AL$29,0)","v":0},{"$f":"F82/Reference!$H$45","v":0}]
[null,null,null,"by pipeline to CNG Plant",{"$f":"$AD$55*Reference!H45*AH34*('EF Table'!F38+('EF Table'!F37/(Reference!C16*Reference!G45)*Reference!E16*Reference!B20))","v":0},{"$f":"IFERROR(E83/$AH$58,0)","v":0},{"$f":"F83/Reference!$H$45","v":0}]
[null,null,"LNG Production","Liquefaction Process",{"$f":"(AD55*AH46*Reference!H45)*(AL26/(Reference!B13*Reference!G45))","v":0},{"$f":"IFERROR(E84/$AL$29,0)","v":0},{"$f":"F84/Reference!$H$45","v":0}]
[]
[null,null,null,"Subtotal",null,null,{"$f":"SUM(G84:G85)","v":0}]
[null,null,"LNG Transport and Distribution","LNG Truck ",{"$f":"(AD55*AH46*Reference!H45)*AL25*'EF Table'!F39","v":0},{"$f":"IFERROR(E87/$AL$29,0)","v":0},{"$f":"F87/Reference!$H$45","v":0}]
[null,null,null,"LNG T&D Fugitives",{"$f":"AD55*AH46*_xlfn.IFS(AL27=\"Boil-Off Recovery Equipped\",'EF Table'!F40,AL27=\"No Boil-Off Recovery\",'EF Table'!F41)/(Reference!C16*Reference!G45)*Reference!E16*Reference!B20","v":0},{"$f":"IFERROR(E88/$AL$29,0)","v":0},{"$f":"F88/Reference!$H$45","v":0}]
[null,null,null,"Subtotal",null,null,{"$f":"G87+G88","v":0}]
[null,"Manure to CNG, LNG, L-CNG",null,null,"GHG emissions CO2e","CI, gCO2e/MMBtu","gCO2e/MJ"]
[null,"ORMX","L-CNG and CNG Production","CI for Compression of CNG (standard Value)",null,{"$f":"G91/Reference!D49","v":3935.3583205},{"$f":"'EF Table'!$F$42","v":3.73}]
[null,null,"Reciprocating engine emissions","CNG Vehicles",null,{"$f":"(Reference!C59+Reference!C60+Reference!C61)*Reference!H45","v":64948.852760258298},{"$f":"F92/Reference!$H$45","v":61.559634743751531}]
[]
[null,null,null,"LNG Vehicles",null,{"$f":"(Reference!E59+Reference!E60+Reference!E61)*Reference!H45","v":64948.852760258298},{"$f":"F94/Reference!$H$45","v":61.559634743751531}]
[null,null,"Credits",null,null,"Methane avoided",{"$f":" 'Avoided Emissions'!C52","v":0}]
[null,null,null,null,null,"CO2 diverted",{"$f":"'Avoided Emissions'!G52","v":0}]
[null,null,null,null,null,"Final CNG CI, g/MJ",{"$f":"IF(AD52=0,0,(G70+G81+G83+G95+G96+G91+G92))","v":0}]
[null,null,null,null,null,"Final LNG CI, g/MJ",{"$f":"IF(AH46=0,0,(G70+G81+G82+G86+G89+G95+G96+G94))","v":0}]
[null,null,null,null,null,"Final L-CNG CI, g/MJ",{"$f":"IF(AH46=0,0,(G70+G81+G82+G86+G89+G95+G96+G91+G92))","v":0}]

{"sheet":"EF Table","index":5,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[1,2,1,5],[73,2,73,4],[54,3,55,3],[36,3,37,3],[37,6,38,6],[39,6,40,6],[3,2,33,2],[3,5,33,5],[38,3,40,3],[36,2,41,2]]}
[]
[null,null,"OR-GREET 4.0 Emission Factor"]
[]
[null,null,"Grid Electricity\n (2021 eGRID Region, ORMX from Oregon 2021 Data)","U.S. Average",474.148181146963,"gCO2e/kWh"]
[null,null,null,"User Defined Mix"]
[null,null,null,"ORMX",403.07602628539564]
[null,null,null,"AKMS",305.05954532367298]
[null,null,null,"AZNM",452.59799644549003]
[null,null,null,"CAMX",329.31550896542899]
[null,null,null,"ERCT",470.46037472212402]
[null,null,null,"FRCC",500.08978131814303]
[null,null,null,"HIMS",729.76964401039004]
[null,null,null,"HIOA",993.04090753329399]
[null,null,null,"MROE",835.17296460818795]
[null,null,null,"MROW",522.27552659354001]
[null,null,null,"NEWE",343.933375462127]
[null,null,null,"NWPP",341.73208620640702]
[null,null,null,"NYCW",522.59100411129396]
[null,null,null,"AKGD",739.37369659441003]
[null,null,null,"NYUP",153.920304055846]
[null,null,null,"PRMS",864.84803647299805]
[null,null,null,"RFCE",403.02327991490301]
[null,null,null,"RFCM",647.65601416559605]
[null,null,null,"RFCW",571.73848830541203]
[null,null,null,"RMPA",581.24471143848803]
[null,null,null,"SPNO",518.57796111835]
[null,null,null,"SPSO",538.184671025753]
[null,null,null,"SRMV",480.14759046268898]
[null,null,null,"SRMW",820.12969419368801]
[null,null,null,"SRSO",508.71583031653398]
[null,null,null,"SRTV",503.56199416647001]
[null,null,null,"SRVC",370.78940202248202]
[null,null,null,"Brazil",110.572733592188]
[null,null,null,"Canada",142.58733454776299]
[]
[]
[null,null,"Biomethane Transport","Pipeline ","Evaporative Losses",3.2477899430252798E-6,"%/mile"]
[null,null,null,null,"Transport Energy",3.88751077308224E-3,"gCO2e/MJ-Mile, LHV"]
[null,null,null,"LNG Truck+Storage","LNG Transport",6.5830682984853997E-3]
[null,null,null,null,"Evaporative Losses - \nWith Boil-Off Recovery",3.1186834785788902E-3,"%"]
[null,null,null,null,"Evaporative Losses - Without Boil-Off Recovery",1.5593417392894399E-2]
[null,null,null,"Compression","at Fueling Station",3.73,"gCO2e/MJ, LHV"]
[]
[]
[null,null,"Natural Gas EF for Stationary/Facility Use"]
[null,null,"Details in g/MMBtu of NG","NG Extraction","NG Processing","NG Transport, \n1000 miles pipeline","Feedstock CI Total","Natural Gas Flaring","Small Industrial Boiler (10-100 MMBtu/hr input)","Final CI, gCO2e/MJ"]
[null,null,"VOC",2.5511998252707828,4.7050523180272235,5.7704039883854659,{"$f":"SUM(D47:F47)","v":13.026656131683472},2.5,2.54]
[null,null,"CO",12.87981575118523,2.7292511097303613,29.546589257434974,{"$f":"SUM(D48:F48)","v":45.155656118350564},26,24.97]
[null,null,"CH4",197.28910542091313,32.643829056841838,118.17221225995459,{"$f":"SUM(D49:F49)","v":348.10514673770956},48.900001525878899,1.06]
[null,null,"N2O",2.6255949947239794E-2,2.0070311129236261E-2,2.0424623098924766,{"$f":"SUM(D50:F50)","v":2.0887885709689527},1.1000000238418579,0.35]
[null,null,"CO2",3089.2391715582471,2446.8450768571302,2590.6035997762237,{"$f":"SUM(D51:F51)","v":8126.687848191601},59189.791154633895,59323.120059395798]
[null,null,"Subtotal gCO2e/MJ",{"$f":"(D47*Reference!$B$22+D48*Reference!$B$23+D49*Reference!$B$20+D50*Reference!$B$21+D51)/Reference!$H$45","v":7.6370194336981578},{"$f":"(E47*Reference!$B$22+E48*Reference!$B$23+E49*Reference!$B$20+E50*Reference!$B$21+E51)/Reference!$H$45","v":3.1163038988804623},{"$f":"(F47*Reference!$B$22+F48*Reference!$B$23+F49*Reference!$B$20+F50*Reference!$B$21+F51)/Reference!$H$45","v":5.8935055001441352},{"$f":"(G47*Reference!$B$22+G48*Reference!$B$23+G49*Reference!$B$20+G50*Reference!$B$21+G51)/Reference!$H$45","v":16.646828832722754},{"$f":"(H47*Reference!$B$22+H48*Reference!$B$23+H49*Reference!$B$20+H50*Reference!$B$21+H51)/Reference!$H$45","v":57.616608646271715},{"$f":"(I47*Reference!$B$22+I48*Reference!$B$23+I49*Reference!$B$20+I50*Reference!$B$21+I51)/Reference!$H$45","v":56.396137668122222},{"$f":"G52+H52","v":74.263437478994462}]
[null,null,null,null,null,null,"Biomethane (gCO2e/MJ)",{"$f":"(H47*Reference!$B$22+H48*Reference!$B$23+H49*Reference!$B$20+H50*Reference!$B$21)/Reference!$H$45","v":1.515511102825178},{"$f":"(I47*Reference!$B$22+I48*Reference!$B$23+I49*Reference!$B$20+I50*Reference!$B$21)/Reference!$H$45","v":0.16866870579591095}]
[]
[null,null,"RNG flaring "]
[null,null,"Details in g/MMBtu"]
[null,null,"VOC",23.666]
[null,null,"CO",41.469000000000001]
[null,null,"CH4",31.587]
[null,null,"N2O",1.1000000000000001]
[null,null,"CO2",59147.401109395796]
[null,null,"Subtotal gCO2e/MJ",{"$f":"(D57*Reference!$B$22+D58*Reference!$B$23+D59*Reference!$B$20+D60*Reference!$B$21+D61)/Reference!$H$45","v":57.251756591044639}]
[]
[null,null,"Biogas electricity production"]
[null,null,"Stationary Reciprocating Engine"]
[null,null,"VOC",62.701000000000001]
[null,null,"CO",273.49700000000001]
[null,null,"CH4",445.95800000000003]
[null,null,"N2O",0.86699999999999999]
[null,null,"CO2",57521.606347491041]
[null,null,"Subtotal gCO2e/MJ",{"$f":"(D66*Reference!$B$22+D67*Reference!$B$23+D68*Reference!$B$20+D69*Reference!$B$21+D70)/Reference!$H$45","v":65.924587275789918}]
[null,null,"gCO2e/kWh",{"$f":"D71*3.6/(0.37)","v":641.42841673741543},"Assuming 37% efficiency"]
[]
[null,null,"Fuels used in pathway"]
[null,null,"Fuel Name and Unit","EF","EF Unit"]
[null,null,"Diesel (Gallons)",12308.3541997418,"gCO2e/gal"]
[null,null,"NG (MMBtu, LHV)",75495.751250270798,"gCO2e/MMBtu"]
[null,null,"Grid Electricity (kWh)",{"$f":"VLOOKUP('Biogas-to-RNG'!D24,D4:E34,2,FALSE)","v":403.07602628539564},"gCO2e/kWh"]
[null,null,"Propane (Gallons)",7345.27740286076,"gCO2e/gallon"]
[null,null,"User-Defined Fuel-1 (MJ)",null,"gCO2e/MJ"]
[null,null,"User-Defined Fuel-2 (MJ)",null,"gCO2e/MJ"]
[null,null,"User-Defined Fuel-3 (MJ)",null,"gCO2e/MJ"]

{"sheet":"Reference","index":6,"n_rows":227,"n_cols":21,"rows_kept":227,"cut":false,"hidden":false,"merged":[[186,0,186,3],[106,0,107,0],[164,0,164,20],[165,1,165,20],[166,1,166,5],[166,6,166,16],[166,17,166,19],[166,20,167,20]]}
[]
[]
[]
["1) Specifications of Fuels"]
["Fuel","Heating Value",null,null,"Density"]
[null,"Calculation: LHV","LHV","HHV",null,"LHV/HHV"]
["Use LHV or HHV in calculations?",1,"1 -- LHV; 2 -- HHV"]
["Liquid Fuels:","Btu/gal","Btu/gal","Btu/gal","grams/gal"]
["U.S. conventional diesel",128450,128450,137380,3167,0.93499781627602274]
["CA conventional diesel"]
["Low-sulfur diesel",127460,127460,133075.138792035,3142,0.95780474968498719]
["Liquefied petroleum gas (LPG)",84950,84950,91410,1923,0.9293293950333662]
["Liquefied natural gas (LNG)",74720,74720,84820,1621,0.88092431030417351]
["Gaseous Fuels (at 60F and 1atm):","Btu/ft3","Btu/ft3","Btu/ft3","gms/ft3","LHV/HHV"]
["Natural gas",930,930,1030,20.8,0.90291262135922334]
["Pure Methane",910,910,1010,19.2,0.90074906367041196]
[]
["2) Global Warming Potentials of Greenhouse Gases: relative to CO2"]
["CO2",1]
["CH4",25]
["N2O",298]
["VOC",3.1166666666666667]
["CO",1.5714285714285714]
["NO2",0]
[]
[]
["3) Unit Conversion"]
["Mass","1 g","1 kg","1 metric tonne","1 lb","1 short ton"]
["g",1,1000,1000000,453.59237000000002,907184.74]
["kg",1E-3,1,1000,0.45359237000000002,907.18474000000003]
["metric tonne",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
["lb",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
["short ton",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[]
["Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
["m3",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
["ml",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
["L",1000,1E-3,1,3.7854109999999999,28.316846999999999]
["gal",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
["ft3",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[]
["Energy","1 J","1kJ","1 MJ","1Wh","1 kWh","1 BTU","1 mmBTU"]
["J",1,1000,1000000,3600,3600000,1055.05585,1055055850]
["kJ",1E-3,1,1000,3.6,3600,1.05505585,1055055.8500000001]
["MJ",9.9999999999999995E-7,1E-3,1,3.5999999999999999E-3,3.6,1.0550558499999999E-3,1055.05585]
["Wh",2.7777777777777778E-4,0.27777777777777779,277.77777777777777,1,1000,0.29307106944444444,293071.06944444444]
["kWh",2.7777777777777776E-7,2.7777777777777778E-4,0.27777777777777779,1E-3,1,2.9307106944444444E-4,293.07106944444445]
["BTU",9.4781712266701337E-4,0.94781712266701335,947.81712266701334,3.4121416416012482,3412.141641601248,1,1000000]
["mmBTU",9.4781712266701324E-10,9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012478E-6,3.4121416416012479E-3,9.9999999999999995E-7,1]
[null,null,"LHV","HHV"]
[null,null,"Btu/ft3","Btu/ft3","gms/ft3"]
["Methane specs",null,910.32327505619207,1010.4588353123728,19.208837934783901]
[]
[]
["Tailpipe GHG Emissions from Oregon CNG - LNG Fleet","CNG and L-CNG",null,"LNG"]
[null,"g/MMBtu","gCO2e/MJ","g/MMBtu","gCO2e/MJ"]
["VOC"]
["CO"]
["CH4",85.099746622744902,{"$f":"B59*B20/$H$45","v":2.0164749245915488},85.099746622744902,{"$f":"D59*B20/$H$45","v":2.0164749245915488}]
["N2O",12.3563538045118,{"$f":"B60*B21/$H$45","v":3.4900459854750974},12.3563538045118,{"$f":"D60*B21/$H$45","v":3.4900459854750974}]
["CO2",59139.16566094516,{"$f":"B61/$H$45","v":56.053113833684883},59139.16566094516,{"$f":"D61/Reference!$H$45","v":56.053113833684883}]
["Total, gCO2e/MMBtu",{"$f":"(B59*B20+B60*B21+B61*B19)","v":64948.852760258298},null,{"$f":"(D59*B20+D60*B21+D61*B19)","v":64948.852760258298}]
["g/MJ",null,{"$f":"SUM(C59:C62)","v":61.559634743751531},null,{"$f":"SUM(E59:E62)","v":61.559634743751531}]
[]
[]
["Details of Boil-Off Effects of Liquefied Natural Gas"]
[null,"Storage at Production Plant","Transportation from Plant to Bulk Terminal","Bulk Terminal Storage","Distribution from Bulk Terminal to Refueling Station","Refueling Station Storage for Central Plant H2 Pathway","Refueling Station Storage for Station H2 Pathway","Storage at Landfill Gas Plant","Distribution from Landfill Gas Plant to Refueling Station","Refueling Station Storage for CNG from RNG pathway"]
["Boil-Off Rate: % per Day"]
["Liquefied Natural Gas",1E-3,1E-3,1E-3,1E-3,1E-3,null,1E-3,1E-3,1E-3]
["Liquid H2",3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3,3.0000000000000001E-3]
["Duration of Storage or Transit: Days"]
["LNG as a final transportation fuel",5,0,5,0.1,3,null,3,0.1,3]
["LNG as an intermediate product from NNA NG ",5,10.416666666666666,5,0.1,3]
["LNG as an intermediate product from NNA FG ",5,12.291666666666666,5,0.1,3]
["Liquid H2 from NG",5,0,5,0.1,3,3]
["Recovery Rate for Boil-Off Gas"]
["LNG",0.8,0.8,0.8,0.8,0.8,null,0.8,0.8,0.8]
["Liquid H2",0.8,0.8,0.8,0.8,0.8,0.8]
[]
["-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Emissions Factor Tables (Appendix A of the \"Compliance Offset Protocol Livestock Projects\")"]
[]
["Table A.1 and A.2: Typical Average Mass (MassL), Volatile Solids, and Maximum Methane Potential of all Livestock Category"]
["Livestock Category (L)","Livestock Typical Average Mass (TAM) in kg","VSL \n(kg/day per 1,000 kg mass)","Bo,L \n(m3 CH4/kg VS added)"]
["Dairy cows (on feed)",680,{"$f":"VLOOKUP('Biogas-to-RNG'!C19:D19, Reference!A113:E162, 2, FALSE)","v":10.57},0.24]
["Non-milking dairy cows (on feed)",684,5.56,0.24]
["Heifers (on feed)",407,{"$f":"VLOOKUP('Biogas-to-RNG'!C19:D19, Reference!A113:E162, 3, FALSE)","v":8.44},0.17]
["Bulls (grazing)",874,6.04,0.17]
["Calves (grazing)",118,7.7,0.17]
["Heifers (grazing)",351.5,{"$f":"VLOOKUP('Biogas-to-RNG'!C19:D19, Reference!A113:E162, 4, FALSE)","v":15.75},0.17]
["Cows (grazing)",582.5,{"$f":"VLOOKUP('Biogas-to-RNG'!C19:D19, Reference!A113:E162, 5, FALSE)","v":7.82},0.17]
["Nursery swine",12.5,8.89,0.48]
["Grow/finish swine",70,5.36,0.48]
["Breeding swine",198,2.71,0.35]
["-"]
["Table A.3. Biogas Collection Efficiency by Digester Type"]
["Digester Type","Cover Type","Biogas Collection Efficiency (BCE)","Methane Leakage"]
["Covered Lagoon","Fully Covered\n(Bank-to-Bank)",0.95,{"$f":"1-C107","v":5.0000000000000044E-2}]
[null,"Partially Covered \n(Modular)","0.95 x % area covered","1 - (0.95 x % area covered)"]
["Complete mix, plug flow, or fixed film digester","Enclosed Vessel",0.98,{"$f":"1-C109","v":2.0000000000000018E-2}]
[]
["Table A.4. 2012 Volatile Solid (VS) Default Values for Dairy Cows, Heifers, Heifers-Grazing and Cows-Grazing by State (kg/day/1,000 kg mass)"]
["~~~~ State ~~~~","Dairy cows \n(on feed)","Heifers \n(on feed)","Heifers \n(grazing)","Cows (grazing)"]
["Alabama",8.6199999999999992,8.44,19.670000000000002,7.82]
["Alaska",8.7100000000000009,8.44,30.94,8.89]
["Arizona",11.64,8.44,22.32,8.89]
["Arkansas",8.44,8.44,18.38,7.82]
["California",11.41,8.44,13.96,8.89]
["Colorado",11.64,8.44,12.28,8.89]
["Connecticut",10.41,8.44,23.35,7.87]
["Delaware",10.18,8.44,16.82,7.87]
["Florida",10.36,8.44,21.99,7.82]
["Georgia",10.4,8.44,19.170000000000002,7.82]
["Hawaii",8.6999999999999993,8.44,20.25,8.89]
["Idaho",11.45,8.44,13.75,8.89]
["Illinois",10.3,8.44,11.42,7.47]
["Indiana",10.85,8.44,11.72,7.47]
["Iowa",10.96,8.44,9.5399999999999991,7.47]
["Kansas",10.94,8.44,8.99,7.47]
["Kentucky",9.1999999999999993,8.44,14.69,7.82]
["Louisiana",8.41,8.44,21.36,7.82]
["Maine",10.01,8.44,15.12,7.87]
["Maryland",10.199999999999999,8.44,17.18,7.87]
["Massachusetts",9.91,8.44,20.89,7.87]
["Michigan",11.56,8.44,12.19,7.47]
["Minnesota",10.29,8.44,11.47,7.47]
["Mississippi",8.9600000000000009,8.44,19.309999999999999,7.82]
["Missouri",8.92,8.44,14.84,7.47]
["Montana",10.85,8.44,18.5,7.82]
["Nebraska",10.79,8.44,11.97,8.89]
["Nevada",11.33,8.44,14.77,7.47]
["New Hampshire",10.34,8.44,23.83,8.92]
["New Jersey",10.01,8.44,16.559999999999999,7.87]
["New Mexico",11.85,8.44,14.27,7.87]
["New York",10.93,8.44,16.72,8.89]
["North Carolina",10.79,8.44,19.93,7.87]
["North Dakota",10.220000000000001,8.44,14.61,7.82]
["Ohio",10.39,8.44,13.24,7.47]
["Oklahoma",9.76,8.44,12.67,7.47]
["Oregon",10.57,8.44,15.75,7.82]
["Pennsylvania",10.32,8.44,16.190000000000001,8.89]
["Rhode Island",9.93,8.44,20.89,7.87]
["South Carolina",9.85,8.44,19.71,7.87]
["South Dakota",10.86,8.44,12.77,7.82]
["Tennessee",9.49,8.44,16.25,7.47]
["Texas",11.06,8.44,11.15,7.82]
["Utah",10.95,8.44,16.649999999999999,7.82]
["Vermont",10.23,8.44,16.079999999999998,8.89]
["Virginia",10.06,8.44,17.93,7.87]
["Washington",11.58,8.44,12.06,7.82]
["West Virginia",9.18,8.44,19.13,8.89]
["Wisconsin",10.87,8.44,17.03,7.47]
["Wyoming",10.69,8.44,18.18,8.89]
[]
["Table A.5. IPCC 2006 Methane Conversion Factors by Manure Management System Component/Methane Source 'S'"]
["MCF Values by Temperature for Manure Management Systems"]
[null,"MCFs by average reporting period temperature (°C)"]
[null,"Cool",null,null,null,null,"Temperate",null,null,null,null,null,null,null,null,null,null,"Warm",null,null,"Comments"]
["System","≤10",11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,"≥28"]
["Pasture/Range/Paddock",0.01,0.01,0.01,0.01,0.01,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,0.02,0.02,0.02,"Judgment of IPCC Expert Group in combination with Hashimoto and Steed (1994)."]
["Daily spread",1E-3,1E-3,1E-3,1E-3,1E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0.01,0.01,0.01,"Hashimoto and Steed (1993)."]
["Solid storage",0.02,0.02,0.02,0.02,0.02,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.05,0.05,0.05,"Judgment of IPCC Expert Group in combination with Amon et al. (2001), which shows emissions of approximately 2% in winter and 4% in summer. Warm climate is based on judgment of IPCC Expert Group and Amon et al. (1998)."]
["Dry lot",0.01,0.01,0.01,0.01,0.01,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,0.02,0.02,0.02,"Judgment of IPCC Expert Group in combination with Hashimoto and Steed (1994)."]
["Liquid/slurry w/natural crust cover",0.1,0.11,0.13,0.14000000000000001,0.15,0.17,0.18,0.2,0.22,0.24,0.26,0.28999999999999998,0.31,0.34,0.37,0.41,0.44,0.48,0.5,"Judgment of IPCC Expert Group in combination with Mangino et al. (2001) and Sommer (2000). The estimated reduction due to the crust cover (40%) is an annual average value based on a limited data set and can be highly variable dependent on temperature, rainfall, and composition."]
["Liquid/slurry uncovered",0.17,0.19,0.2,0.22,0.25,0.27,0.28999999999999998,0.32,0.35,0.39,0.42,0.46,0.5,0.55000000000000004,0.6,0.65,0.71,0.78,0.8,"Judgment of IPCC Expert Group in combination with Mangino et al. (2001). "]
["Uncovered anaerobic lagoon",0.66,0.68,0.7,0.71,0.73,0.74,0.75,0.76,0.77,0.77,0.78,0.78,0.78,0.79,0.79,0.79,0.79,0.8,0.8,"Judgment of IPCC Expert Group in combination with Mangino et al. (2001). Uncovered lagoon MCFs vary based on several factors, including temperature, retention time, and loss of volatile solids from the system (through removal of lagoon effluent and/or solids)."]
["Pit storage below animal confinements (<1 month)",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,"Judgment of IPCC Expert Group in combination with Moller et al. (2004) and Zeeman (1994). Note that the ambient temperature, not the stable temperature is to be used for determining the climatic conditions."]
["Pit storage below animal confinements (>1 month)",0.17,0.19,0.2,0.22,0.25,0.27,0.28999999999999998,0.32,0.35,0.39,0.42,0.46,0.5,0.55000000000000004,0.6,0.65,0.71,0.78,0.8,"Judgment of IPCC Expert Group in combination with Mangino et al. (2001). Note that the ambient temperature, not the stable temperature is to be used for determining the climatic conditions."]
["Anaerobic digester","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","0 - 1","Should be subdivided in different categories, considering amount of recovery of the biogas, flaring of the biogas and storage after digestion. Calculation with Formula 1."]
["Burned for fuel",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,"Judgment of IPCC Expert Group in combination with Safley et al. (1992)."]
["Cattle and swine deep bedding (<1 month)",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.3,0.3,0.3,"Judgment of IPCC Expert Group in combination with Moller et al. (2004). Expect emissions to be similar, and possibly greater, than pit storage, depending on organic content and moisture content."]
["Cattle and swine deep bedding (>1 month)",0.17,0.19,0.2,0.22,0.25,0.27,0.28999999999999998,0.32,0.35,0.39,0.42,0.46,0.5,0.55000000000000004,0.6,0.65,0.71,0.78,0.9,"Judgment of IPCC Expert Group in combination with Mangino et al. (2001)."]
["Composting - in-vessel or static pile",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,"Judgment of IPCC Expert Group and Amon et al. (1998). MCFs are less than half of solid storage. Not temperature dependant."]
["Composting - passive or intensive windrow",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,"Judgment of IPCC Expert Group and Amon et al. (1998). MCFs are slightly less than solid storage. Less temperature dependant."]
["Aerobic treatment",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"MCFs are near zero. Aerobic treatment can result in the accumulation of sludge which may be treated in other systems. Sludge requires removal and has large VS values. It is important to identify the next management process for the sludge and estimate the emissions from that management process if significant."]
[]
["Table A.6. Biogas Destruction Efficiency Default Values by Destruction Device"]
["If available, the actual source test results for the measured methane destruction efficiency must be used in place of the default methane destruction efficiency. Otherwise, the Offset Project Operator or Authorized Project Designee must use the default methane destruction efficiencies provided below."]
["Biogas Destruction Device","Biogas Destruction Efficiency (BDE)"]
["Open Flare",0.96]
["Enclosed Flare",0.995]
["Lean-burn Internal Combustion Engine",0.93600000000000005]
["Rich-burn Internal Combustion Engine",0.995]
["Boiler",0.98]
["Microturbine or large gas turbine",0.995]
["Upgrade and use of gas as CNG/LNG fuel",0.95]
["Upgrade and injection into natural gas transmission and distribution pipeline",0.98]
["Direct pipeline to an end-user","Per corresponding destruction device"]
[]
["Table A.9. Volatile Solids Removed Through Solids Separation (modified)"]
["Type of Solids Separation","Volatile Solids Removed (fraction), MSL,nAS or MSL,S","Volatile Solids Sent to Appropriate Manure Management System (fraction), MSAS,L or MSL,BCS"]
["Gravity",0.45,{"$f":"1-B201","v":0.55000000000000004}]
["Mechanical:"]
["Stationary Screen",0.17,{"$f":"1-B203","v":0.83}]
["Vibrating screen",0.15,{"$f":"1-B204","v":0.85}]
["Screw press",0.25,0.75]
["Centrifuge",0.5,0.5]
["Roller drum",0.25,0.75]
["Belt press/screen",0.5,{"$f":"1-B208","v":0.5}]
[]
[]
["Manure Management Storage/Treatment Systems "]
["~~Select Storage/Treatment~~"]
["Uncovered anaerobic lagoon"]
["Liquid/Slurry uncovered"]
["Liquid/Slurry w/natural crust cover"]
["Pasture/Range/Paddock"]
["Daily spread"]
["Solid storage"]
["Dry lot"]
["Pit storage below animal confinements (<1 month)"]
["Pit storage below animal confinements (>1 month)"]
["Cattle and Swine deep bedding (<1 month)"]
["Cattle and Swine deep bedding (>1 month)"]
["Composting - in-vessel or static pile"]
["Composting - passive or intensive windrow"]
["Aerobic treatment"]
["Burned for fuel"]