{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introduction","Site-Specific Inputs","Pathway Summary","OR-GREET4.0"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[[8,1,8,7],[2,2,2,6],[3,2,3,6],[1,1,1,7],[4,1,7,2],[4,4,7,4],[4,6,7,7]]}
[]
[null,{"$error":"#VALUE!"}]
[null,null,"Low Carbon Fuel Standard\nTier 1 CI Calculator for Corn and Sorghum Ethanol (Release Date: 08/12/2024)"]
[null,null,"The Tier 1 Calculator for Corn and Sorghum Ethanol (T1 CSE Calculator) offers a simplified interface for calculating the carbon intensity of starch and fiber ethanol produced from corn or sorghum feedstocks. \n\nTo begin, navigate to the \"Site-Specific Inputs\" worksheet and enter all relevant project data. For Tier 1 pathways, a minimum of 3 months of operational data is required. Carbon Intensity (CI) results are provided on the \"Pathway Summary\" worksheet, along with calculated input results and finished fuel quantities. Pathway-specific Operating Conditions may be added by DEQ prior to pathway certification. The \"OR-GREET4.0\" worksheet contains predefined input values from the OR-GREET4.0 model. \n\nData entered by the applicant are limited to User Input cells (see Color Key below). Additional worksheets may be added to the calculator by the applicant to document and support User Input cell values, but existing worksheets and cells containing Calculated Value or OR-GREET4.0 Input values may not be modified without DEQ approval via a Tier 2 pathway. \n\nPlease note that this calculator contains macros that allow the user to hide site-specific input fields that are not relevant to a given pathway. In order for macros to function properly, the \"Enable Content\" button in Microsoft Excel must be selected upon opening this calculator.  In order to ensure that CI calculations reflect the most recent inputs, select \"Automatic\" calculations from the \"Calculation Options\" in the \"Formulas\" toolbar or press F9 (if using Microsoft Excel)."]
[null,null,null,"Color Key",null,"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,"`"]

{"sheet":"Site-Specific Inputs","index":1,"n_rows":34,"n_cols":59,"rows_kept":34,"cut":false,"hidden":false,"merged":[[14,1,16,1],[11,2,13,2],[14,2,16,2],[7,1,7,2],[19,1,20,1],[19,2,20,2],[17,2,18,2],[5,58,6,58],[5,57,6,57],[11,1,13,1],[5,48,6,48],[5,49,6,49],[5,50,6,50],[5,52,6,52],[5,53,6,53],[5,42,6,42],[5,44,6,44],[5,43,6,43],[5,46,6,46],[5,47,6,47],[5,35,6,35],[5,36,6,36],[5,31,6,31],[5,55,6,55],[5,56,6,56],[5,29,6,29],[5,30,6,30],[5,32,6,32],[5,33,6,33],[5,34,6,34],[5,54,6,54],[5,6,6,6],[5,7,6,7],[5,8,6,8],[5,9,6,9],[5,11,6,11],[5,21,6,21],[5,22,6,22],[5,23,6,23],[5,24,6,24],[5,25,6,25],[5,27,6,27],[5,28,6,28],[5,51,6,51],[5,45,6,45],[5,39,6,39],[2,19,2,23],[3,19,3,20],[3,22,3,23],[3,24,3,28],[3,29,3,33],[2,24,2,49],[3,45,3,49],[3,5,3,11],[3,12,3,18],[5,4,6,4],[22,1,22,2],[3,50,3,53],[3,34,3,37],[3,42,3,44],[5,26,6,26],[5,20,6,20],[5,19,6,19],[5,10,6,10],[5,5,6,5],[5,37,6,37],[5,38,6,38],[5,40,6,40],[5,41,6,41],[30,76,30,77],[1,1,1,2],[1,4,1,58],[3,54,3,58],[3,38,3,41],[2,50,2,58],[2,4,3,4],[17,1,18,1],[5,12,6,12],[5,13,6,13],[5,14,6,14],[5,17,6,17],[5,18,6,18],[5,15,6,15],[5,16,6,16],[2,5,2,18]]}
[]
[null,"Section 1: Applicant Information",null,null,"Section 4: Monthly Operational Data"]
[null,"1.1 Application Number",null,null,null,"Feedstocks",null,null,null,null,null,null,null,null,null,null,null,null,null,"Process Energy",null,null,null,null,"Coproducts"]
[null,"1.2 Company Name",null,null,null,"Corn",null,null,null,null,null,null,"Sorghum",null,null,null,null,null,null,"Methane",null,"Alternative Fuels","Electricity",null,"Dry Distiller's Grains with Soluables (DDGS)",null,null,null,null,"Modified Distiller's Grains with Soluables (MDGS)",null,null,null,null,"Wet Distiller's Grains with Soluables (WDGS)",null,null,null,"Syrup",null,null,null,"Distiller's Oil",null,null,"Combined Heat and Power (CHP)",null,null,null,null,null,null,null,null,"Ethanol Production"]
[null,"1.3 Company ID",null,null,4.0999999999999996,4.2,4.3,4.4000000000000004,4.5,4.5999999999999996,4.7,4.8,4.9000000000000004,4.0999999999999996,4.1100000000000003,4.12,4.13,4.1399999999999997,4.1500000000000004,4.16,4.17,4.18,4.1900000000000004,4.2,4.21,4.22,4.2300000000000004,4.24,4.25,4.26,4.2699999999999996,4.28,4.29,4.3,4.3099999999999996,4.32,4.33,4.34,4.3499999999999996,4.3599999999999897,4.3699999999999903,4.3799999999999901,4.3899999999999899,4.3999999999999897,4.4099999999999904,4.4199999999999902,4.4299999999999899,4.4399999999999897,4.4499999999999904,4.4599999999999902,4.46999999999999,4.4799999999999898,4.4899999999999904,4.4999999999999902,4.50999999999999,4.5199999999999898,4.5299999999999896,4.5399999999999903,4.5499999999999901]
[null,"1.4 Facility ID",null,null,"Reporting Month","Beginning Corn Inventory","Corn Delivered","Ending Corn Inventory","Corn Transported by Truck ","Transport Distance by Truck","Corn Transported by Rail "," Transport Distance by Rail","Beginning Sorghum Inventory","Sorghum Delivered","Ending Sorghum Inventory","Sorghum Transported by Truck","Transport Distance by Truck","Sorghum Transported by Rail","Transport Distance by Rail","North American Natural Gas","Direct Supply Biomethane","Alternative Fuel","Grid Electricity","Direct Supply Low-CI Electricity","Beginning DDGS Inventory ","DDGS Sold","Ending DDGS Inventory ","DDGS Moisture Content","DDGS Metered Drying Energy ","Beginning MDGS Inventory ","MDGS Sold","Ending MDGS Inventory ","MDGS Moisture Content","MDGS Metered Drying Energy ","Beginning WDGS Inventory ","WDGS Sold","Ending WDGS Inventory ","WDGS Moisture Content ","Beginning Syrup Inventory","Syrup Sold ","Ending Syrup Inventory","Syrup Moisture Content","Beginning Distiller's Oil Inventory ","Distiller's Oil Sold","Ending Distiller's Oil Inventory ","Natural Gas Combusted in CHP","Electricity Produced","Electricity Exported","Steam Produced","Steam Exported","Beginning Cellulosic Enzyme Inventory","Cellulosic Enzyme Purchased","Ending Cellulosic Enzyme Inventory","Fiber Ethanol Allocation ","Beginning Undenatured Ethanol Inventory","Undenatured Ethanol Sold ","Denaturant Added","Denatured Ethanol Sold","Ending Undenatured Ethanol Inventory"]
[]
[null,"Section 2: Pathway Inputs",null,null,"MM/YYYY","bushels","bushels","bushels","bushels","weighted av. miles","bushels","weighted av. miles","bushels","bushels","bushels","bushels","weighted av. miles","bushels","weighted av. miles","MMBtu, HHV","MMBtu, HHV","MMBtu, HHV","kWh","kWh","short tons","short tons","short tons"," %","MMBtu, HHV","short tons","short tons","short tons"," %","MMBtu, HHV","short tons","short tons","short tons","%","short tons","short tons","short tons"," %","lbs","lbs","lbs","MMBtu, HHV","kWh","kWh","MMBtu","MMBtu","lbs","lbs","lbs","%","gallons @ 60o F","gallons @ 60o F","gallons @ 60o F","gallons @ 60o F","gallons @ 60o F"]
[null,"2.1 Pathway CIs",null,null,null,null,null,null,null,{"$f":"IF(I9>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K9>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P9>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R9>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"2.2 Feedstocks",null,null,null,null,null,null,null,{"$f":"IF(I10>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K10>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P10>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R10>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"2.3 Feedstock Transport",null,null,null,null,null,null,null,{"$f":"IF(I11>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K11>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P11>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R11>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"2.4 Process Energy",null,null,null,null,null,null,null,{"$f":"IF(I12>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K12>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P12>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R12>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I13>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K13>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P13>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R13>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I14>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K14>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P14>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R14>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"2.5 Coproducts",null,null,null,null,null,null,null,{"$f":"IF(I15>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K15>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P15>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R15>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I16>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K16>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P16>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R16>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I17>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K17>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P17>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R17>0,'OR-GREET4.0'!E$16,)","v":0}]
[null," 2.6 Ethanol Produced",null,null,null,null,null,null,null,{"$f":"IF(I18>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K18>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P18>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R18>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I19>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K19>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P19>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R19>0,'OR-GREET4.0'!E$16,)","v":0}]
[null," 2.7 Ethanol Transport",null,null,null,null,null,null,null,{"$f":"IF(I20>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K20>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P20>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R20>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I21>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K21>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P21>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R21>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I22>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K22>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P22>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R22>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"Section 3: Static Operational Data",null,null,null,null,null,null,null,{"$f":"IF(I23>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K23>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P23>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R23>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.1 Feedstock Transport Data","Default for Oregon",null,null,null,null,null,null,{"$f":"IF(I24>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K24>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P24>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R24>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.2 Grid Electricity Region",null,null,null,null,null,null,null,{"$f":"IF(I25>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K25>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P25>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R25>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.3 Grid CI (gCO2e/kWh)",null,null,null,null,null,null,null,{"$f":"IF(I26>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K26>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P26>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R26>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.4 Alternate Fuel Type",null,null,null,null,null,null,null,{"$f":"IF(I27>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K27>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P27>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R27>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.5 Alt. Fuel EF (gCO2e/MMBtu, HHV)",null,null,null,null,null,null,null,{"$f":"IF(I28>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K28>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P28>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R28>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.6 Biomethane EF (gCO2e/MJ, LHV)",null,null,null,null,null,null,null,{"$f":"IF(I29>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K29>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P29>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R29>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.7 Low-CI Electricity CI (gCO2e/kWh)",null,null,null,null,null,null,null,{"$f":"IF(I30>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K30>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P30>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R30>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.8 Denaturant Blended",null,null,null,null,null,null,null,{"$f":"IF(I31>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K31>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P31>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R31>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.9 Ethanol Transport - Truck (miles)",null,null,null,null,null,null,null,{"$f":"IF(I32>0,'OR-GREET4.0'!E$13,)","v":0},null,{"$f":"IF(K32>0,'OR-GREET4.0'!E$14,)","v":0},null,null,null,null,{"$f":"IF(P32>0,'OR-GREET4.0'!E$15,)","v":0},null,{"$f":"IF(R32>0,'OR-GREET4.0'!E$16,)","v":0}]
[null,"3.10 Ethanol Transport - Rail (miles)"]
[null,"3.11 Ethanol Transport - Barge (miles)"]

{"sheet":"Pathway Summary","index":2,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[[50,22,50,26],[45,1,45,16],[46,1,46,16],[6,4,6,16],[12,8,12,16],[42,1,42,7],[43,1,43,7],[32,1,36,1],[41,1,41,7],[14,1,17,1],[18,1,20,1],[44,1,44,16],[24,1,31,1],[0,1,0,16],[0,0,46,0],[1,1,4,1],[1,2,2,16],[3,2,4,16],[12,5,12,6],[12,1,12,4],[10,1,10,16],[5,1,5,16],[6,3,9,3],[21,1,23,1],[11,1,11,16],[37,1,40,1]]}
[]
[null,{"$error":"#VALUE!"},"Corn and Sorghum Ethanol Pathway Summary"]
[]
[null,null,"FOR APPLICANT ONLY - CONTAINS CONFIDENTIAL BUSINESS INFORMATION - DO NOT DISTRIBUTE"]
[]
[]
[null,"Application #",{"$f":"'Site-Specific Inputs'!C3","v":0},null,"Finished Fuel Quantities"]
[null,"Company Name and ID",{"$f":"CONCATENATE('Site-Specific Inputs'!C4,\" \",'Site-Specific Inputs'!C5)","v":" "},null,"Unit","Undenatured Ethanol","Denaturant Added","Denatured Ethanol",{"$f":"I14","v":"Corn Composite"},"Sorghum Composite","Corn DDGS","Corn MDGS","Corn WDGS","Sorghum DDGS","Sorghum MDGS","Sorghum WDGS","Fiber"]
[null,"Facility ID",{"$f":"'Site-Specific Inputs'!C6","v":0},null,"Gallons Produced",{"$f":"SUM('Site-Specific Inputs'!BF9:BF32,-'Site-Specific Inputs'!BE9:BE32,'Site-Specific Inputs'!BD9:BD32,'Site-Specific Inputs'!BG9:BG32,-'Site-Specific Inputs'!BC9:BC32)","v":0},{"$f":"SUM('Site-Specific Inputs'!BE9:BE32)","v":0},{"$f":"SUM(F9:G9)","v":0},{"$f":"SUM(K9:M9)","v":0},{"$f":"SUM(N9:P9)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D15/SUM(D15:D16),)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D15/SUM(D15:D16),)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D15/SUM(D15:D16),)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D16/SUM(D15:D16),)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D16/SUM(D15:D16),)","v":0},{"$f":"IFERROR((H9-Q9)*SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32))/(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32)))*D16/SUM(D15:D16),)","v":0},{"$f":"SUMPRODUCT('Site-Specific Inputs'!BG9:BG32+'Site-Specific Inputs'!BD9:BD32+'Site-Specific Inputs'!BF9:BF32-'Site-Specific Inputs'!BC9:BC32, 'Site-Specific Inputs'!BB9:BB32)","v":0}]
[null,"Operational Data Period",{"$f":"IF('Site-Specific Inputs'!E9>0,CONCATENATE(TEXT(MIN('Site-Specific Inputs'!E9:E32),\"mm/yyyy\"),\" — \",TEXT(MAX('Site-Specific Inputs'!E9:E32),\"mm/yyyy\")),)","v":0},null,"MJ Dispensed, LHV",{"$f":"F9*'OR-GREET4.0'!E6/'OR-GREET4.0'!E37","v":0},{"$f":"G9*'OR-GREET4.0'!E4","v":0},{"$f":"SUM(F10:G10)","v":0},{"$f":"SUM(K10:M10)","v":0},{"$f":"SUM(N10:P10)","v":0},{"$f":"IFERROR(K9*H10/H9,)","v":0},{"$f":"IFERROR(L9*H10/H9,)","v":0},{"$f":"IFERROR(M9*H10/H9,)","v":0},{"$f":"IFERROR(N9*H10/H9,)","v":0},{"$f":"IFERROR(O9*H10/H9,)","v":0},{"$f":"IFERROR(P9*H10/H9,)","v":0},{"$f":"IFERROR(Q9*H10/H9,)","v":0}]
[]
[null,"Carbon Intensity Calculations"]
[null,"Fuel Pathway Inputs",null,null,null,"Emission Factors",null,"Emissions","Carbon Intensity, gCO2e/MJ d-EtOH, LHV"]
[null,"Category","Name","Value","Unit","Value","Unit","gCO2e","Corn Composite","Sorghum Composite","Corn DDGS","Corn MDGS","Corn WDGS","Sorghum DDGS","Sorghum MDGS","Sorghum WDGS","Fiber"]
[null,{"$f":"'OR-GREET4.0'!B8","v":"Feedstock Production"},"Corn Farming",{"$f":"SUM('Site-Specific Inputs'!F9:G32,-'Site-Specific Inputs'!H9:H32)","v":0},"bushels",{"$f":"'OR-GREET4.0'!E8","v":7111.1766454755361},"gCO2e/bushel",{"$f":"D15*F15","v":0},{"$f":"IF(I10>0,H15/I10,)","v":0},null,{"$f":"IF(K10>0,H15/I10,)","v":0},{"$f":"IF(L10>0,H15/I10,)","v":0},{"$f":"IF(M10>0,H15/I10,)","v":0}]
[null,null,"Sorghum Farming",{"$f":"SUM('Site-Specific Inputs'!M9:N32,-'Site-Specific Inputs'!O9:O32)","v":0},"bushels",{"$f":"'OR-GREET4.0'!E9","v":7600.8560242279509},"gCO2e/bushel",{"$f":"D16*F16","v":0},null,{"$f":"IF(J10>0,H16/J10,)","v":0},null,null,null,{"$f":"IFERROR(H16/J10,)","v":0},{"$f":"IFERROR(H16/J10,)","v":0},{"$f":"IFERROR(H16/J10,)","v":0}]
[null,null,"Corn Land Use Change",{"$f":"IFERROR((F10-Q10*(1-(G10/H10)))*(D15/SUM(D15:D16)),)","v":0},"MJ, LHV",{"$f":"'OR-GREET4.0'!E10","v":7.6},"gCO2e/MJ, LHV",{"$f":"D17*F17","v":0},{"$f":"IF(I10>0,H17/I10,)","v":0},null,{"$f":"IF(K10>0,H17/I10,)","v":0},{"$f":"IF(L10>0,H17/I10,)","v":0},{"$f":"IF(M10>0,H17/I10,)","v":0},null,null,null,null,null,"MJ (LHV)"]
[null,null,"Sorghum Land Use Change",{"$f":"IFERROR((F10-Q10*(1-(G10/H10)))*(D16/SUM(D15:D16)),)","v":0},"MJ, LHV",{"$f":"'OR-GREET4.0'!E11","v":19.399999999999999},"gCO2e/MJ, LHV",{"$f":"D18*F18","v":0},null,{"$f":"IF(J10>0,H18/J10,)","v":0},null,null,null,{"$f":"IF(N10>0,H18/J10,)","v":0},{"$f":"IF(O10>0,H18/J10,)","v":0},{"$f":"IF(P10>0,H18/J10,)","v":0}]
[null,"Corn Transport","Field to Stack Transport ",{"$f":"D15*'OR-GREET4.0'!E12","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E22","v":9.8765573243504488},"gCO2e/bushel-mile",{"$f":"D19*F19","v":0},{"$f":"IF(I10>0,H19/I10,)","v":0},null,{"$f":"IF(K10>0,H19/I10,)","v":0},{"$f":"IF(L10>0,H19/I10,)","v":0},{"$f":"IF(M10>0,H19/I10,)","v":0}]
[null,null,"Stack to Facility Truck Transport ",{"$f":"SUMPRODUCT('Site-Specific Inputs'!I9:I32,'Site-Specific Inputs'!J9:J32)","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E23","v":4.8793579265605551},"gCO2e/bushel-mile",0,{"$f":"IF(I10>0,H20/I10,)","v":0},null,{"$f":"IF(K10>0,H20/I10,)","v":0},{"$f":"IF(L10>0,H20/I10,)","v":0},{"$f":"IF(M10>0,H20/I10,)","v":0}]
[null,null,"Stack to Facility Rail Transport ",{"$f":"SUMPRODUCT('Site-Specific Inputs'!K9:K32,'Site-Specific Inputs'!L9:L32)","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E25","v":0.72746222587974607},"gCO2e/bushel-mile",0,{"$f":"IF(I10>0,H21/I10,)","v":0},null,{"$f":"IF(K10>0,H21/I10,)","v":0},{"$f":"IF(L10>0,H21/I10,)","v":0},{"$f":"IF(M10>0,H21/I10,)","v":0}]
[null,"Sorghum Transport","Field to Stack Transport ",{"$f":"D16*'OR-GREET4.0'!E12*'OR-GREET4.0'!E21","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E22","v":9.8765573243504488},"gCO2e/bushel-mile",{"$f":"D22*F22","v":0},null,{"$f":"IF(J10>0,H22/J10,)","v":0},null,null,null,{"$f":"IFERROR(H22/J10,)","v":0},{"$f":"IFERROR(H22/J10,)","v":0},{"$f":"IFERROR(H22/J10,)","v":0}]
[null,null,"Stack to Facility Truck Transport ",{"$f":"SUMPRODUCT('Site-Specific Inputs'!P9:P32,'Site-Specific Inputs'!Q9:Q32)*'OR-GREET4.0'!E21","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E24","v":4.8793579265605551},"gCO2e/bushel-mile",0,null,{"$f":"IF(J10>0,H23/J10,)","v":0},null,null,null,{"$f":"IFERROR(H23/J10,)","v":0},{"$f":"IFERROR(H23/J10,)","v":0},{"$f":"IFERROR(H23/J10,)","v":0}]
[null,null,"Stack to Facility Rail Transport ",{"$f":"SUMPRODUCT('Site-Specific Inputs'!R9:R32,'Site-Specific Inputs'!S9:S32)*'OR-GREET4.0'!E21","v":0},"bushel-miles",{"$f":"'OR-GREET4.0'!E25","v":0.72746222587974607},"gCO2e/bushel-mile",0,null,{"$f":"IF(J10>0,H24/J10,)","v":0},null,null,null,{"$f":"IFERROR(H24/J10,)","v":0},{"$f":"IFERROR(H24/J10,)","v":0},{"$f":"IFERROR(H24/J10,)","v":0}]
[null,"Fuel Production",{"$f":"'Site-Specific Inputs'!T6","v":"North American Natural Gas"},{"$f":"SUM('Site-Specific Inputs'!T9:T32-'Site-Specific Inputs'!AC9:AC32-'Site-Specific Inputs'!AH9:AH32)*'OR-GREET4.0'!E7","v":0},"MMBtu, LHV",{"$f":"'OR-GREET4.0'!E26","v":75495.751250270754},"gCO2e/MMBtu, LHV",0,{"$f":"IF(I10>0,H25/H10,)","v":0},{"$f":"IF(J10>0,H25/H10,)","v":0},{"$f":"IF(K10>0,H25/H10,)","v":0},{"$f":"IF(L10>0,H25/H10,)","v":0},{"$f":"IF(M10>0,H25/H10,)","v":0},{"$f":"IF(N10>0,H25/H10,)","v":0},{"$f":"IF(O10>0,H25/H10,)","v":0},{"$f":"IF(P10>0,H25/H10,)","v":0},{"$f":"IF(Q10>0,H25/H10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!U6","v":"Direct Supply Biomethane"},{"$f":"SUM('Site-Specific Inputs'!U9:U32)*'OR-GREET4.0'!E7*'OR-GREET4.0'!M6","v":0},"MJ, LHV",{"$f":"'Site-Specific Inputs'!C29","v":0},"gCO2e/MJ, LHV",0,{"$f":"IF(I10>0,H26/H10,)","v":0},{"$f":"IF(J10>0,H26/H10,)","v":0},{"$f":"IF(K10>0,H26/H10,)","v":0},{"$f":"IF(L10>0,H26/H10,)","v":0},{"$f":"IF(M10>0,H26/H10,)","v":0},{"$f":"IF(N10>0,H26/H10,)","v":0},{"$f":"IF(O10>0,H26/H10,)","v":0},{"$f":"IF(P10>0,H26/H10,)","v":0},{"$f":"IF(Q10>0,H26/H10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!V6","v":"Alternative Fuel"},{"$f":"SUM('Site-Specific Inputs'!V9:V32)","v":0},{"$f":"'Site-Specific Inputs'!V8","v":"MMBtu, HHV"},{"$f":"'Site-Specific Inputs'!C28","v":0},"gCO2e/dry short ton",0,{"$f":"IF(I10>0,H27/H10,)","v":0},{"$f":"IF(J10>0,H27/H10,)","v":0},{"$f":"IF(K10>0,H27/H10,)","v":0},{"$f":"IF(L10>0,H27/H10,)","v":0},{"$f":"IF(M10>0,H27/H10,)","v":0},{"$f":"IF(N10>0,H27/H10,)","v":0},{"$f":"IF(O10>0,H27/H10,)","v":0},{"$f":"IF(P10>0,H27/H10,)","v":0},{"$f":"IF(Q10>0,H27/H10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!W6","v":"Grid Electricity"},{"$f":"SUM('Site-Specific Inputs'!W9:W32)","v":0},{"$f":"'Site-Specific Inputs'!W8","v":"kWh"},{"$f":"'Site-Specific Inputs'!C26","v":0},"gCO2e/kWh",0,{"$f":"IF(I10>0,H28/H10,)","v":0},{"$f":"IF(J10>0,H28/H10,)","v":0},{"$f":"IF(K10>0,H28/H10,)","v":0},{"$f":"IF(L10>0,H28/H10,)","v":0},{"$f":"IF(M10>0,H28/H10,)","v":0},{"$f":"IF(N10>0,H28/H10,)","v":0},{"$f":"IF(O10>0,H28/H10,)","v":0},{"$f":"IF(P10>0,H28/H10,)","v":0},{"$f":"IF(Q10>0,H28/H10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!X6","v":"Direct Supply Low-CI Electricity"},{"$f":"SUM('Site-Specific Inputs'!X9:X32)","v":0},{"$f":"'Site-Specific Inputs'!X8","v":"kWh"},{"$f":"'Site-Specific Inputs'!C30","v":0},"gCO2e/kWh",0,{"$f":"IF(I10>0,H29/H10,)","v":0},{"$f":"IF(J10>0,H29/H10,)","v":0},{"$f":"IF(K10>0,H29/H10,)","v":0},{"$f":"IF(L10>0,H29/H10,)","v":0},{"$f":"IF(M10>0,H29/H10,)","v":0},{"$f":"IF(N10>0,H29/H10,)","v":0},{"$f":"IF(O10>0,H29/H10,)","v":0},{"$f":"IF(P10>0,H29/H10,)","v":0},{"$f":"IF(Q10>0,H29/H10,)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!BE6","v":"Denaturant Added"},{"$f":"G10","v":0},"MJ, LHV",{"$f":"'OR-GREET4.0'!E5","v":100.59704233635868},"gCO2e/MJ, LHV",0,{"$f":"IF(I10>0,H30/H10,)","v":0},{"$f":"IF(J10>0,H30/H10,)","v":0},{"$f":"IF(K10>0,H30/H10,)","v":0},{"$f":"IF(L10>0,H30/H10,)","v":0},{"$f":"IF(M10>0,H30/H10,)","v":0},{"$f":"IF(N10>0,H30/H10,)","v":0},{"$f":"IF(O10>0,H30/H10,)","v":0},{"$f":"IF(P10>0,H30/H10,)","v":0},{"$f":"IF(Q10>0,H30/H10,)","v":0}]
[null,null,"Chemicals",{"$f":"F10","v":0},"MJ, LHV",{"$f":"'OR-GREET4.0'!E27","v":2.02},"gCO2e/MJ, LHV",0,{"$f":"IF(I10>0,H31/H10,)","v":0},{"$f":"IF(J10>0,H31/H10,)","v":0},{"$f":"IF(K10>0,H31/H10,)","v":0},{"$f":"IF(L10>0,H31/H10,)","v":0},{"$f":"IF(M10>0,H31/H10,)","v":0},{"$f":"IF(N10>0,H31/H10,)","v":0},{"$f":"IF(O10>0,H31/H10,)","v":0},{"$f":"IF(P10>0,H31/H10,)","v":0}]
[null,null,"Cellulosic Ethanol Enzymes",{"$f":"SUM('Site-Specific Inputs'!AY9:AZ32,-'Site-Specific Inputs'!BA9:BA32)","v":0},"lb enzyme",{"$f":"'OR-GREET4.0'!E28","v":525.37109799999996},"gCO2e/lb enzyme",0,null,null,null,null,null,null,null,null,{"$f":"IFERROR(H32/Q10,)","v":0}]
[null,"Coproducts",{"$f":"'Site-Specific Inputs'!AC6","v":"DDGS Metered Drying Energy "},{"$f":"SUM('Site-Specific Inputs'!AC9:AC32)*'OR-GREET4.0'!E7","v":0},"MMBtu, LHV",{"$f":"'OR-GREET4.0'!E26","v":75495.751250270754},"gCO2e/MMBtu, LHV",{"$f":"D33*F33","v":0},{"$f":"IF(I10>0,H33/H10,)","v":0},{"$f":"IF(J10>0,H33/H10,)","v":0},{"$f":"IF(K10>0,H33/(K10+N10),)","v":0},null,null,{"$f":"IF(N10>0,H33/(K10+N10),)","v":0}]
[null,null,{"$f":"'Site-Specific Inputs'!AH6","v":"MDGS Metered Drying Energy "},{"$f":"SUM('Site-Specific Inputs'!AH9:AH32)*'OR-GREET4.0'!E7","v":0},"MMBtu, LHV",{"$f":"'OR-GREET4.0'!E26","v":75495.751250270754},"gCO2e/MMBtu, LHV",{"$f":"D34*F34","v":0},{"$f":"IF(I10>0,H34/H10,)","v":0},{"$f":"IF(J10>0,H34/H10,)","v":0},null,{"$f":"IF(L10>0,H34/(L10+O10),)","v":0},null,null,{"$f":"IF(O10>0,H34/(L10+O10),)","v":0}]
[null,null,"DGS Displacement Credit",{"$f":"(SUMPRODUCT('Site-Specific Inputs'!AA9:AA32+'Site-Specific Inputs'!Z9:Z32-'Site-Specific Inputs'!Y9:Y32,(1-'Site-Specific Inputs'!AB9:AB32))+SUMPRODUCT('Site-Specific Inputs'!AF9:AF32+'Site-Specific Inputs'!AE9:AE32-'Site-Specific Inputs'!AD9:AD32,(1-'Site-Specific Inputs'!AG9:AG32))+SUMPRODUCT('Site-Specific Inputs'!AK9:AK32+'Site-Specific Inputs'!AJ9:AJ32-'Site-Specific Inputs'!AI9:AI32,(1-'Site-Specific Inputs'!AL9:AL32))+SUMPRODUCT('Site-Specific Inputs'!AN9:AN32+'Site-Specific Inputs'!AO9:AO32-'Site-Specific Inputs'!AM9:AM32,(1-'Site-Specific Inputs'!AP9:AP32)))*'OR-GREET4.0'!M15+SUM('Site-Specific Inputs'!AS9:AS32+'Site-Specific Inputs'!AR9:AR32-'Site-Specific Inputs'!AQ9:AQ32)*(1-'OR-GREET4.0'!E29)","v":0},"lbs, dry basis",{"$f":"-IFERROR(SUM(H15:H16,H19:H24)/SUM(D15:D16)*0.781/56+70.81+13.13,)","v":0},"gCO2e/lb coproduct",{"$f":"D35*F35","v":0},{"$f":"IF(I10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(J10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(K10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(L10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(M10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(N10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(O10>0,H35/(H10-Q10),)","v":0},{"$f":"IF(P10>0,H35/(H10-Q10),)","v":0}]
[null,null,"Exported CHP Electricity",{"$f":"SUM('Site-Specific Inputs'!AV9:AV32)","v":0},{"$f":"'Site-Specific Inputs'!AV8","v":"kWh"},{"$f":"-'Site-Specific Inputs'!C26","v":0},"gCO2e/kWh",0,{"$f":"IF(I10>0,H36/H10,)","v":0},{"$f":"IF(J10>0,H36/H10,)","v":0},{"$f":"IF(K10>0,H36/H10,)","v":0},{"$f":"IF(L10>0,H36/H10,)","v":0},{"$f":"IF(M10>0,H36/H10,)","v":0},{"$f":"IF(N10>0,H36/H10,)","v":0},{"$f":"IF(O10>0,H36/H10,)","v":0},{"$f":"IF(P10>0,H36/H10,)","v":0},{"$f":"IF(Q10>0,H36/H10,)","v":0}]
[null,null,"Exported CHP Steam",{"$f":"SUM('Site-Specific Inputs'!AX9:AX32)","v":0},{"$f":"'Site-Specific Inputs'!AX8","v":"MMBtu"},{"$f":"-'OR-GREET4.0'!E26/0.8","v":-94369.689062838443},"gCO2e/MMBtu, LHV",0,{"$f":"IF(I10>0,H37/H10,)","v":0},{"$f":"IF(J10>0,H37/H10,)","v":0},{"$f":"IF(K10>0,H37/H10,)","v":0},{"$f":"IF(L10>0,H37/H10,)","v":0},{"$f":"IF(M10>0,H37/H10,)","v":0},{"$f":"IF(N10>0,H37/H10,)","v":0},{"$f":"IF(O10>0,H37/H10,)","v":0},{"$f":"IF(P10>0,H37/H10,)","v":0},{"$f":"IF(Q10>0,H37/H10,)","v":0}]
[null,"Finished Fuel Transport","Truck Transport to Terminal",{"$f":"'Site-Specific Inputs'!C32*H9","v":0},"gallon-miles",{"$f":"'OR-GREET4.0'!E35","v":0.57397040858210169},"gCO2e/gallon-mile",0,{"$f":"IF(I10>0,H38/H10,)","v":0},{"$f":"IF(J10>0,H38/H10,)","v":0},{"$f":"IF(K10>0,H38/H10,)","v":0},{"$f":"IF(L10>0,H38/H10,)","v":0},{"$f":"IF(M10>0,H38/H10,)","v":0},{"$f":"IF(N10>0,H38/H10,)","v":0},{"$f":"IF(O10>0,H38/H10,)","v":0},{"$f":"IF(P10>0,H38/H10,)","v":0},{"$f":"IF(Q10>0,H38/H10,)","v":0}]
[null,null,"Rail Transport to Terminal",{"$f":"'Site-Specific Inputs'!C33*H9","v":0},"gallon-miles",{"$f":"'OR-GREET4.0'!E33","v":8.557310148193352E-2},"gCO2e/gallon-mile",0,{"$f":"IF(I10>0,H39/H10,)","v":0},{"$f":"IF(J10>0,H39/H10,)","v":0},{"$f":"IF(K10>0,H39/H10,)","v":0},{"$f":"IF(L10>0,H39/H10,)","v":0},{"$f":"IF(M10>0,H39/H10,)","v":0},{"$f":"IF(N10>0,H39/H10,)","v":0},{"$f":"IF(O10>0,H39/H10,)","v":0},{"$f":"IF(P10>0,H39/H10,)","v":0},{"$f":"IF(Q10>0,H39/H10,)","v":0}]
[null,null,"Barge Transport to Terminal",{"$f":"'Site-Specific Inputs'!C34*H9","v":0},"gallon-miles",{"$f":"'OR-GREET4.0'!E34","v":0.13954470745728467},"gCO2e/gallon-mile",0,{"$f":"IF(I10>0,H40/H10,)","v":0},{"$f":"IF(J10>0,H40/H10,)","v":0},{"$f":"IF(K10>0,H40/H10,)","v":0},{"$f":"IF(L10>0,H40/H10,)","v":0},{"$f":"IF(M10>0,H40/H10,)","v":0},{"$f":"IF(N10>0,H40/H10,)","v":0},{"$f":"IF(O10>0,H40/H10,)","v":0},{"$f":"IF(P10>0,H40/H10,)","v":0},{"$f":"IF(Q10>0,H40/H10,)","v":0}]
[null,null,"Terminal to Fuel Station ",{"$f":"H9*'OR-GREET4.0'!E36","v":0},"gallon-miles",{"$f":"'OR-GREET4.0'!E32","v":0.57397040858210169},"gCO2e/gallon-mile",{"$f":"D41*F41","v":0},{"$f":"IF(I10>0,H41/H10,)","v":0},{"$f":"IF(J10>0,H41/H10,)","v":0},{"$f":"IF(K10>0,H41/H10,)","v":0},{"$f":"IF(L10>0,H41/H10,)","v":0},{"$f":"IF(M10>0,H41/H10,)","v":0},{"$f":"IF(N10>0,H41/H10,)","v":0},{"$f":"IF(O10>0,H41/H10,)","v":0},{"$f":"IF(P10>0,H41/H10,)","v":0},{"$f":"IF(Q10>0,H41/H10,)","v":0}]
[null,"Fuel Pathway Carbon Intensity (gCO2e/MJ Denatured Ethanol, LHV)",null,null,null,null,null,null,{"$f":"SUM(I15:I41)","v":0},0,0,0,0,0,0,0,0]
[null,"Margin of Safety (entered by applicant)"]
[null,"Certified Fuel Pathway Carbon Intensity (gCO2e/MJ Denatured Ethanol, LHV)",null,null,null,null,null,null,{"$f":"I42+I43","v":0},{"$f":"J42+J43","v":0},0,0,0,0,0,0,0]
[]
[null,"Operating Conditions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"`"]

{"sheet":"OR-GREET4.0","index":3,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[37,1,66,1],[37,2,66,2],[37,5,66,5],[1,1,1,5],[25,1,30,1],[31,1,36,1],[31,2,33,2],[34,2,36,2],[7,1,10,1],[26,2,27,2],[9,2,10,2],[7,2,8,2],[12,2,19,2],[11,1,24,1],[21,2,24,2],[3,3,4,3],[3,1,6,1],[1,7,1,12],[3,2,5,2]]}
[]
[null," OR-GREET4.0 Emission Factors and Specifications",null,null,null,null,null,"Unit Conversion"]
[null,"Category","Sub-Category","Name","Value","Unit",null,"Energy","1 kJ","1 MJ","1 kWh","1 BTU","1 MMBtu"]
[null,"Fuel Specifications","Energy Density","California Reformulated Gasoline Before Oxygenate Blending (CARBOB)",119.53,"MJ/gal, LHV",null,"Joule (J)",1000,1000000,3600000,1055.05585,1055055850]
[null,null,null,null,100.59704233635868,"gCO2e/MJ, LHV",null,"Kilojoule (kJ)",1,1000,3600,1.05505585,1055055.8500000001]
[null,null,null,"Ethanol",80.53,"MJ/gal, LHV",null,"Megajoule (MJ)",1E-3,1,3.6,1.0550558499999999E-3,1055.05585]
[null,null,"Heating Value Ratio","Natural Gas",0.90291262135922334,"LHV/HHV",null,"Watt-hour (Wh)",0.27777777777777779,277.77777777777777,1000,0.29307106944444444,293071.06944444444]
[null,"Feedstock Production","Farming, Fertilizers and Pesticides","Corn ",7111.1766454755361,"gCO2e/bushel",null,"Kilowatt-hour (kWh)",2.7777777777777778E-4,0.27777777777777779,1,2.9307106944444444E-4,293.07106944444445]
[null,null,null,"Sorghum",7600.8560242279509,"gCO2e/bushel",null,"British Thermal Unit (BTU)",0.94781712266701335,947.81712266701334,3412.141641601248,1,1000000]
[null,null,"Land Use Change","Corn ",7.6,"gCO2e/MJ corn EtOH",null,"Million British Thermal Unit (MMBtu)",9.4781712266701337E-7,9.4781712266701326E-4,3.4121416416012479E-3,9.9999999999999995E-7,1]
[null,null,null,"Sorghum",19.399999999999999,"gCO2e/MJ sorghum EtOH",null,"Mass","1 g","1 kg","1 MT","1 lb","1 short ton"]
[null,"Feedstock Transport","Field to Stack Standard Distance","Corn or Sorghum",10,"miles",null,"Gram (g)",1,1000,1000000,453.59237000000002,907184.74]
[null,null,"Stack to Fuel Production Facility Distance","OR Facility, Truck, Corn",50,"miles",null,"Kilogram (kg)",1E-3,1,1000,0.45359237000000002,907.18474000000003]
[null,null,null,"OR Facility, Rail, Corn",1900,"miles",null,"Metric Ton (MT)",9.9999999999999995E-7,1E-3,1,4.5359237000000004E-4,0.90718474000000004]
[null,null,null,"OR Facility, Truck, Sorghum",50,"miles",null,"Pound (lb)",2.2046226218487759E-3,2.2046226218487757,2204.6226218487759,1,2000]
[null,null,null,"OR Facility, Rail, Sorghum",1900,"miles",null,"Short Ton (US Ton)",1.102311310924388E-6,1.1023113109243879E-3,1.1023113109243878,5.0000000000000001E-4,1]
[null,null,null,"9 Midwest States Facility, Truck, Corn",40,"miles",null,"Volume","1 m3","1 ml","1 L","1 gal","1 ft3"]
[null,null,null,"9 Midwest States Facility, Truck, Sorghum",80,"miles",null,"Cubic Meter (m3)",1,9.9999999999999995E-7,1E-3,3.7854109999999998E-3,2.8316846999999999E-2]
[null,null,null,"9 Midwest States Facility, Rail, Corn",40,"miles",null,"Milliliter (ml)",1000000,1,1000.0000000000001,3785.4110000000001,28316.847000000002]
[null,null,null,"9 Midwest States Facility, Rail, Sorghum",80,"miles",null,"Liter (L)",1000,1E-3,1,3.7854109999999999,28.316846999999999]
[null,null,"Sorghum Transport ","Transport Loss Factor",1.0204081632653061,"%W/%W",null,"Gallon (gal)",264.17210707106841,2.6417210707106839E-4,0.26417210707106842,1,7.4805211375990615]
[null,null,"Transport Emissions","Medium Heavy-Duty Truck ",9.8765573243504488,"gCO2e/bushel-mile",null,"Cubic Foot (ft3)",35.314666212661322,3.5314666212661319E-5,3.5314666212661321E-2,0.13368052594273649,1]
[null,null,null,"Heavy Heavy-Duty Truck, Corn ",4.8793579265605551,"gCO2e/bushel-mile"]
[null,null,null,"Heavy Heavy-Duty Truck, Sorghum ",4.8793579265605551,"gCO2e/bushel-mile"]
[null,null,null,"Rail",0.72746222587974607,"gCO2e/bushel-mile"]
[null,"Fuel Production","Process Fuel","Natural Gas Combustion in Boiler",75495.751250270754,"gCO2e/MMBtu NG (LHV)"]
[null,null,"Chemicals and Enzymes","Chemicals",2.02,"gCO2e/MJ ethanol (LHV)"]
[null,null,null,"Cellulosic Enzymes Used",525.37109799999996,"gCO2e/lb enzyme (normalized)"]
[null,null,"Coproducts","Default Distiller's Oil Moisture Content",0.01,"%W/%W"]
[null,null,"Evaporative Emissions","Standard Value",8.6694746909554699E-2,"gCO2e/MJ EtOH"]
[null,null,"Denaturant","Default Blend Value",2.5000000000000001E-2,"%V/%V"]
[null,"Denatured Ethanol Transport","Fuel Production Facility to Terminal","Heavy Heavy-Duty Truck ",0.57397040858210169,"gCO2e/gal-mile"]
[null,null,null,"Rail",8.557310148193352E-2,"gCO2e/gal-mile"]
[null,null,null,"Barge",0.13954470745728467,"gCO2e/gal-mile"]
[null,null,"Terminal to Fueling Station","Heavy Heavy-Duty Truck ",0.57397040858210169,"gCO2e/gal-mile"]
[null,null,null,"Standard Distance",90,"miles"]
[null,null,null,"Loss Factor",1.0005044983835301,"%V/%V"]
[null,"Grid Electricity","2021 eGRID Region (ORMX from Oregon 2021 Data)",null,null,"gCO2e/kWh"]
[null,null,null,"ORMX",403.07602628539564]
[null,null,null,"AKMS",305.05954532367315]
[null,null,null,"AZNM",452.59799644549014]
[null,null,null,"CAMX",329.31550896542888]
[null,null,null,"ERCT",470.46037472212373]
[null,null,null,"FRCC",500.08978131814308]
[null,null,null,"HIMS",729.76964401039049]
[null,null,null,"HIOA",993.04090753329433]
[null,null,null,"MROE",835.17296460818841]
[null,null,null,"MROW",522.27552659353967]
[null,null,null,"NEWE",343.93337546212689]
[null,null,null,"NWPP",341.73208620640725]
[null,null,null,"NYCW",522.5910041112935]
[null,null,null,"AKGD",739.37369659441038]
[null,null,null,"NYUP",153.92030405584592]
[null,null,null,"PRMS",864.84803647299793]
[null,null,null,"RFCE",403.02327991490318]
[null,null,null,"RFCM",647.65601416559605]
[null,null,null,"RFCW",571.73848830541249]
[null,null,null,"RMPA",581.24471143848814]
[null,null,null,"SPNO",518.57796111835]
[null,null,null,"SPSO",538.18467102575312]
[null,null,null,"SRMV",480.14759046268892]
[null,null,null,"SRMW",820.12969419368847]
[null,null,null,"SRSO",508.71583031653392]
[null,null,null,"SRTV",503.56199416646967]
[null,null,null,"SRVC",370.78940202248185]
[null,null,null,"Brazil",110.5727335921882]
[null,null,null,"Canada",142.58733454776279]
[null,null,null,"User Defined"]