{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","1-Title","2-Contents","3-Background","4-Instructions","5-Facility Inputs","6-Waste Inputs","7-Economic Inputs","8-Default Values","9-Outputs","10-Wet AD","11-Dry AD","12-Tool Assumptions","13-Sources"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":1,"defined_names":108,"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":"Cover","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"1-Title","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Title"]
[]
[null,"Title","OrganEcs – Cost Estimating Tool for Anaerobic Digestion"]
[null,"Version","3 (Anerobic Digestion Edition)"]
[null,"Acknowledgements","OrganEcs, was developed by the U.S. Environmental Protection Agency under the auspices of the Global Methane Initiative and in support of the Climate and Clean Air Coalition.. Tom Frankiewicz (EPA’s International Biogas Team Lead) managed the tool’s development with technical support from Abt Associates.\n\nThe U.S. EPA recommends users cite OrganEcs with the following citation when citing the tool in published work: \nU.S. EPA. 2021. OrganEcs-Anaerobic Digestion V3.0. "]
[null,"Disclaimer","The tool is meant to provide planning-level assistance, outputs should be verified through a detailed feasibility study (or through the solicitation of bids from qualified proposers) before project development commences."]

{"sheet":"2-Contents","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contents"]
[]
[null,1,null,"Title"]
[null,{"$f":"B4+1","v":2},null,"Contents"]
[null,{"$f":"B5+1","v":3},null,"Background"]
[null,4,null,"Instructions"]
[null,5,null,"Facility Inputs"]
[null,6,null,"Waste Inputs"]
[null,7,null,"Economic Inputs"]
[null,8,null,"Default Values"]
[null,9,null,"Outputs"]
[null,10,null,"Wet Anaerobic Digestion"]
[null,11,null,"Dry Anaerobic Digestion"]
[null,12,null,"Tool Assumptions"]
[null,13,null,"Sources"]

{"sheet":"3-Background","index":3,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Background"]
[]
[null,"Introduction ",null,"The Global Methane Initiative works with cities worldwide to improve solid waste management and reduce emissions of short-lived climate pollutants. OrganEcs was developed by the U.S. Environmental Protection Agency under the auspices of the Global Methane Initiative and in support of the Climate and Clean Air Coalition. Organic waste management projects (i.e., composting, and anaerobic digestion) represent a key opportunity for achieving these objectives. Planning and development of such projects require a detailed understanding of the costs involved in construction and operation of organic waste management facilities.\n\nOrganEcs is a tool for estimating the costs associated with organic waste management projects. It provides planning-level assistance to local governments, waste professionals, policymakers, facility operators, and project developers to help them make financial decisions about their potential organic projects. Specifically, the tool assists users in determining the expected IRR (internal rate of return), given user inputs for an anerobic digestion project. \n\nModel outputs should be viewed as preliminary results that can be used for planning purposes. These estimates should be verified through detailed feasibility studies prior to project development, or through the solicitation of bids from qualified firms. "]

{"sheet":"4-Instructions","index":4,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,1,14,3],[15,1,15,3],[9,2,9,3],[1,1,1,3],[12,1,12,3],[13,1,13,3],[10,1,10,3],[11,1,11,3],[3,1,3,3],[4,1,4,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[5,1,5,3]]}
[]
[null,"Instructions"]
[]
[null,"Model Organization"]
[null,"This tool has 13 sheets, and the tabs are color coded as follows: \n  •  BLUE tabs: User inputs.\n  •  YELLOW tab: Default values.\n  •  BLACK tab: Results or Outputs.\n  •  GRAY tabs: Organic waste treatment technologies\n  •  GREEN tabs: Assumptions and additional resources. "]
[null,"Operating the Tool"]
[null,"Version Control","•  Please ensure that you have downloaded the latest version of OrganEcs from the Global Methane Initiative.\n•  Ensure you save the file as “Type: Excel Macro-Enabled Workbook.”\n•  Please do not use a version that was previously used, or has data, for any other city."]
[null,"Macros","•  You must ENABLE the macros by clicking the \"Enable Content\" button next to the warning message at the top of the spreadsheet."]
[null,"Cell Colors","•  Input cells are BLUE and will change to a lighter shade once you enter data. \n•  Default cells are YELLOW and will change to brown if they are altered.\n•  Some cells have an automatic validity check. If you enter an incorrect value or make an invalid selection, the cell will turn RED, and an error message will appear. Please correct the error before continuing."]
[null,"Data Entry","•  Enter all required user inputs into the blue cells in the input tabs (“5-Facility Inputs,” “6-Waste Inputs,” and “7-Economic Inputs”). Please fill in all blue tabs in order to receive accurate outputs.\n•  Review the default values on tab \"8-Default Values\" and alter if desired.\n•  Additional instructions and source references can be found at the top of each tab and in the notes attached to the relevant input cells. "]
[null,"Help"]
[null,"If you need assistance while using the model, please send any questions to BiogasTools@abtassoc.com."]
[null,"Tool Limitations"]
[null,"(1) Cost estimates are for source-separated organic feedstocks and do not include pre-sorting costs or revenues associated with an upstream materials recovery facility. Additional costs associated with establishing source-separated collection are not considered.\n\n(2) Facility performance (e.g., electricity and compost production, water demand, wastewater generation, equipment lifespan, operating days/year) is based on published data for typical facilities and will vary based on a number of factors, including, but not limited to, operating and maintenance (O&M) practices, feedstock characteristics, selected technology, and climate.\n\n(3) The tool requires a minimum waste throughput of 5,000 TPY to 20,000 TPY for AD, and thus is not suitable for modeling small, decentralized projects.\n\n(4) Tool construction requires that equity be provided to the project. Minimum values must be entered for Internal Rate of Return (IRR), Equity Payback, and % Equity on the \"7-Economic Inputs\" tab in order for the tool to return values. Minimum value requirements are located in notes attached to the relevant cells."]
[null,"Tool Assumptions"]
[null,"Tool assumptions and default values can be found throughout the tool in hovering messages and on the \"8-Default Values\" tab. The user may elect to overwrite default values with actual data from local processing facilities or a select technology vendor. \n\nSome of the default values in the \"8-Default Values\" tab are calculations based on user inputs in tabs 5-7. \n"]

{"sheet":"5-Facility Inputs","index":5,"n_rows":177,"n_cols":80,"rows_kept":177,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,3],[7,1,7,2],[10,1,10,2]]}
[]
[null,"Facility Inputs - Design Parameters for New Facility"]
[]
[null,"Instructions: ","Make sure you ENABLE macros by pressing the \"Enable Content\" button next to the warning message at the top of the spreadsheet; you may also have been asked to enable macros through a warning message upon opening the model. If you forgot to enable macros, please close and reopen the tool. Choose which technologies you are interested in developing and/or comparing in rows 9 and 10. Enter design parameters into the blue cells, or select values from the drop-down menus, only for facility(ies) to be developed or compared. Cell color will change to a lighter shade of blue once you enter data. You may alter current default values (yellow cells), if necessary. Cell color will change to brown if altered."]
[]
[]
[null,"Technology Selection"]
[null,"Please choose \"Yes\" in the dropdown list for the technologies you are interested in developing/ comparing. If you are not interested in the technology, please choose \"No.\""]
[null,"Wet Anaerobic Digestion","CHOOSE ONE"]
[null,"Dry Anaerobic Digestion","CHOOSE ONE"]
[null,{"$f":"IF(AND(C9<>\"Yes\",C10<>\"Yes\",E9<>\"Yes\",E10<>\"Yes\"),\"ERROR - Please choose 'Yes' for at least one technology.\", \"\")","v":"ERROR - Please choose 'Yes' for at least one technology."}]
[]
[null,"Facility Operations",null,null,null,"Units"]
[null,"Investment Year"]
[null,"Construction Period",null,null,null,"Years"]
[null,"Operations Start Year",null,null,{"$f":"E14+E15","v":0}]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(E15>3,\"ERROR- Shorten construction period to 3 or fewer years.\",IF(E15<1,\"ERROR - Model requires a minimum 1-year construction period.\",\"OK\"))","v":"ERROR - Model requires a minimum 1-year construction period."}]
[null,"Maintenance Begins",null,null,null,"Year"]
[null,"Facility Lifespan",null,null,null,"Years"]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(DepreciationADandAllInfrastructure>FacilityLifespan,\"ERROR- Depreciation Period Greater than Facility Lifespan\",\"OK\")","v":"ERROR- Depreciation Period Greater than Facility Lifespan"}]
[null,"Average Round-trip Distance from Waste Generators to Landfill",null,null,null,"km"]
[null,"Average Round-trip Distance from Waste Generators to Organics Management Facility",null,null,null,"km"]
[null,"Round-trip Distance from Organics Management Facility to Landfill",null,null,null,"km"]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(OR(DistanceGeneratorsToLandfill=0,DistanceGeneratorsToOrganicsFacility=0,DistanceOrganicsFacilityToLandfill=0), \"ERROR - Please enter a non-zero value for all distances (cells E21-E23).\", \"OK\")","v":"ERROR - Please enter a non-zero value for all distances (cells E21-E23)."}]
[]
[null,"Facility Design - Anaerobic Digestion Technologies",null,"Wet Anaerobic Digestion","Dry Anaerobic Digestion","Units"]
[null,"Percentage of Equipment Capex Subject to VAT (Value-Added Tax; same as Goods and Services Tax)",null,null,null,"%"]
[null,"Ancillary Costs",null,null,null,"$"]
[null,"Include Wastewater Treatment Infrastructure Onsite",null,"CHOOSE ONE","N/A","Yes/No"]
[null,"Percentage of Peak Throughput Waste Digested in Year 0",null,0.01,0.01,"%",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,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,0.01,0.01]
[null,"Percentage of Peak Throughput Waste Digested in Year 1",null,0.3,0.3,"%",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,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,0.3,0.3]
[null,"Percentage of Peak Throughput Waste Digested in Year 2",null,0.5,0.5,"%",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,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,0.5,0.5]
[null,"Percentage of Peak Throughput Waste Digested in Year 3",null,0.7,0.7,"%",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,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,0.7,0.7]
[null,"Percentage of Peak Throughput Waste Digested in Year 4 - 20",null,0.95,0.95,"%",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,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,0.95,0.95]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CHOOSE ONE"]
[null,"Compost"]
[null,"Digestate"]
[]
[null,"CHOOSE ONE"]
[null,"Digestate (No Dewatering)"]
[null,"Liquid Digestate + Dewatered Digestate"]
[null,"Dewatered Digestate (Liquid Recycled/Discharged to Sewer)"]
[null,"Compost (Liquid Recycled/Discharged to Sewer)"]
[null,"Liquid Digestate + Compost"]
[]
[null,"CHOOSE ONE"]
[null,"Not Applicable"]
[null,"Composting W/O Forced Aeration"]
[null,"Composting With Forced Aeration - Aerated Static Pile"]
[null,"Composting With Forced Aeration - In-vessel"]
[null,"CHOOSE ONE"]
[null,"Yes"]
[null,"No"]
[]
[null,"CHOOSE ONE"]
[null,"No Yard Waste Under Management"]
[null,"Compost Yard Waste"]
[null,"Give Away Yard Waste"]
[null,"Sell Mulch"]
[]
[]
[null,"CHOOSE ONE"]
[null,"No Yard Waste Under Management"]
[null,"Digest"]
[null,"Compost"]
[]
[]
[null,"CHOOSE ONE"]
[null,"Aerated Static Pile"]
[null,"In-vessel"]

{"sheet":"6-Waste Inputs","index":6,"n_rows":69,"n_cols":86,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,2,68,6],[53,2,53,3],[3,3,8,7],[3,2,8,2],[39,2,39,5],[37,2,37,3],[15,2,15,10],[16,2,16,10],[17,4,17,10]]}
[]
[null,null,"Waste Inputs - Feedstock Characteristics"]
[]
[null,null,"Instructions: ","- User should enter tonnes/year of available feedstock in the first table (\"ALL SCENARIOS\") and the projected growth rate of waste in the  \"Total Incoming Feedstock\" table, regardless of which technology user intends to pursue. Feedstock characteristics will vary by location and season.  \n- Input cells will change to light blue once user has entered local data. \n- User may choose to use default feedstock characteristics or enter data from laboratory analysis into the yellow-green cells. \n- Default cells will change to dark brown if value is altered. \n- Based on feedstock blending calculations, user should modify the amount of purchased bulking agent required to meet the target values in red, which are unique to each type of technology. If target values are not met, cell will be highlighted in red."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Purchased Bulking Agent for Compost  (e.g., Woo+H14d Chips) "]
[]
[null,null,"Please fill out cells E20 to J20 (\"Yard Waste\" through \"Corrugated Cardboard\"). If you are planning to develop an anaerobic digestion project in which you will compost the digestate, modify the bulking agent in cells G42 or J42, as appropriate; do not modify the value in cell L20."]
[null,null,"Note: Tool requires a minimum waste throughput of 5,000 TPY for Dry AD and 20,000 TPY for Wet AD. Throughput requirements for all Wet AD technologies are exclusive of yard waste. Dry AD scenarios require minimum throughput AND that food, manure, and/or sludge also be part of the feedstock mix. "]
[null,null,"ALL SCENARIOS",null,"Feedstock Availability Bulking Agent"]
[null,null,"Feedstock",null,"Yard Waste","Food Waste","Manure","Sewage Sludge","Mixed Paper","Corrugated\nCardboard","Purchased Bulking Agent (e.g., Wood Chips) ","Feedstock Availability (Excl. Purchased Bulking Agent)"]
[null,null,"Tonnes Per Year",null,null,null,null,null,null,null,null,{"$f":"SUM(YardWasteTonnes:CardboardTonnes)","v":0}]
[null,null,"Carbon (% dry weight)",null,{"$f":"E22*E23","v":0.21959999999999999},{"$f":"F22*F23","v":0.83519999999999994},0.38159999999999999,0.48060000000000003,0.38125000000000003,{"$f":"J22*J23","v":0.56300000000000006},{"$f":"K22*K23","v":0.495}]
[null,null,"Nitrogen (% dry weight)",null,7.1999999999999998E-3,3.5999999999999997E-2,2.4E-2,4.4499999999999998E-2,2.5000000000000001E-3,1E-3,3.5999999999999999E-3,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,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,7.1999999999999998E-3,3.5999999999999997E-2,2.4E-2,4.4499999999999998E-2,2.5000000000000001E-3,1E-3,3.5999999999999999E-3]
[null,null,"C:N Ratio (parts carbon to 1 part nitrogen)",null,30.5,23.2,15.9,10.8,152.5,563,137.5,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,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,30.5,23.2,15.9,10.8,152.5,563,137.5]
[null,null,"Moisture %",null,0.53610000000000002,0.67,0.8,0.78,0.25,0.17,0.46949999999999997,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,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,0.53610000000000002,0.67,0.8,0.78,0.25,0.17,0.46949999999999997]
[null,null,"Volatile Solids ",null,0.90600000000000003,0.95299999999999996,0.82640000000000002,0.8,0.91500000000000004,0.89,0.90600000000000003,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,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,0.90600000000000003,0.95299999999999996,0.82640000000000002,0.8,0.91500000000000004,0.89,0.90600000000000003]
[null,null,"Tonnes Carbon",null,{"$f":"E21*E20","v":0},0,0,0,0,0,{"$f":"K21*K20","v":0}]
[null,null,"Tonnes Nitrogen",null,{"$f":"E20*E22","v":0},0,0,0,0,0,0]
[null,null,"Tonnes of Moisture",null,{"$f":"E24*E20","v":0},0,0,0,0,0,0]
[null,null,"Tonnes of Volatile Solids",null,{"$f":"E20*E25","v":0},0,0,0,0,0,0]
[null,null,"Methane Yield (m3 CH4/dry metric tonne)",null,11.6,260,12.74,120,132.1,152.30000000000001,11.6,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,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,11.6,260,12.74,120,132.1,152.30000000000001,11.6]
[null,null,"Methane Yield (m3 CH4)",null,{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (E20-E28)*E30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (F20-F28)*F30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (G20-G28)*G30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (H20-H28)*H30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (I20-I28)*I30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (J20-J28)*J30)","v":0},{"$f":"IF(AND('5-Facility Inputs'!$E$9=\"No\",'5-Facility Inputs'!$E$10=\"No\"), \"AD Technology Not Chosen\", (K20-K28)*K30)","v":0}]
[null,null,"C:N RATIO",null,{"$f":"SUM(E26:K26)/SUM(E27:K27)","v":{"$error":"#DIV/0!"}},"Target = 25-35%"]
[null,null,"PERCENT MOISTURE",null,{"$f":"SUM(E28:K28)/SUM(E20:K20)","v":{"$error":"#DIV/0!"}},"Target = 50-65%"]
[null,null,"PERCENT VOLATILE SOLIDS",null,{"$f":"SUM(E29:K30)/SUM(E20:K20)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"ALL SCENARIOS - Total Incoming Feedstock"]
[null,null,"Feedstock Availability (Excl. Purchased Bulking Agent)",null,{"$f":"SUM(YardWasteTonnes:CardboardTonnes)","v":0},"TPY"]
[null,null,"Facility Stretch Capacity",null,null,"% of Feedstock Availabilty"]
[null,null,"Note: Tool requires a minimum waste throughput of 5,000 TPY for Dry AD, and 20,000 TPY for Wet AD. Throughput requirements for all Wet AD technologies are exclusive of yard waste. Dry AD scenarios require minimum throughput AND that food, manure, and/or sludge also be part of the feedstock mix. Default values can be modified, however.  The user should update the capital cost assumptions database with site-specific capital cost data that correspond with the modelled throughput. "]
[]
[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,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,null,null,null,null,null,null,2000]
[null,null,"MINIMUM THROUGHPUT REQUIREMENTS",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,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,null,null,null,2000]
[null,null,"Wet AD",null,20000,"TPY",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,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,20000]
[null,null,"Dry AD",null,5000,"TPY",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,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,5000]
[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,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,null,null,null,null,null,null,10000]
[]
[null,null,"Energy & Gas Yields",null,"Dry AD","Wet AD ","Units"]
[null,null,"Methane Yield",null,{"$f":"SUM(E31:J31)","v":0},{"$f":"SUM(F31:J31)","v":0},"m3/year"]
[null,null,"Methane Content",null,0.55000000000000004,0.63,"%",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,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,0.55000000000000004,0.63]
[null,null,"Total Biogas Yield",null,{"$f":"E49/E50","v":0},{"$f":"F49/F50","v":0},"m3/year"]
[null,null,"Biogas Yield/Tonne",null,{"$f":"IF(ISERROR(E51/SUM(E20:J20)),0,(E51/SUM(E20:J20)))","v":0},{"$f":"IF(ISERROR(F51/SUM(F20:J20)),0,(F51/SUM(F20:J20)))","v":0},"m3/tonne"]
[null,null,"Methane Calorific Value",null,35.700000000000003,35.700000000000003,"MJ/m3",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,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,35.700000000000003,35.700000000000003]
[null,null,"Total Calorific Value of Methane (= Total Net Calorific Value of Biogas)",null,{"$f":"E53*E49","v":0},{"$f":"F53*F49","v":0},"MJ"]
[null,null,"Electrical Conversion Efficiency",null,0.4,0.4,"%",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,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,0.4,0.4]
[null,null,"Thermal Conversion Efficiency",null,0.48,0.48,"%",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,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,0.48,0.48]
[null,null,"Electrical Energy Produced",null,{"$f":"E54*E55","v":0},{"$f":"F54*F55","v":0},"MJ"]
[null,null,"Thermal Energy Production",null,{"$f":"E56*E54","v":0},{"$f":"F56*F54","v":0},"MJ"]
[null,null,"Gross Electricity Production",null,{"$f":"CONVERT(E57,\"MJ\",\"kWh\")","v":0},{"$f":"CONVERT(F57,\"MJ\",\"kWh\")","v":0},"kWh"]
[null,null,"Gross Heat Production",null,{"$f":"CONVERT(E58,\"MJ\",\"kWh\")","v":0},{"$f":"CONVERT(F58,\"MJ\",\"kWh\")","v":0},"kWh"]
[null,null,"Parasitic Load - Electricity",null,0.1,0.1,"%",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,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,0.1,0.1]
[null,null,"Parasitic Load - Heat",null,0.5,0.5,"%",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,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,0.5,0.5]
[null,null,"Net Electricity Produced",null,{"$f":"E59*(1-E61)","v":0},{"$f":"F59*(1-F61)","v":0},"kWh/year"]
[null,null,"Net Heat Produced",null,{"$f":"E60*(1-E62)","v":0},0,"kWh/year"]
[null,null,"Net Electricity Produced",null,{"$f":"IF(ISERROR(E63/SUM(YardWasteTonnes:CardboardTonnes)),0,(E63/SUM(YardWasteTonnes:CardboardTonnes)))","v":0},{"$f":"IF(ISERROR(F63/SUM(YardWasteTonnes:CardboardTonnes)),0,(F63/SUM(YardWasteTonnes:CardboardTonnes)))","v":0},"kWh/tonne"]
[null,null,"Net Heat Produced (kWh)",null,{"$f":"IF(ISERROR(E64/SUM(YardWasteTonnes:CardboardTonnes)),0,(E64/SUM(YardWasteTonnes:CardboardTonnes)))","v":0},{"$f":"IF(ISERROR(F64/SUM(FoodWasteTonnes:CardboardTonnes)),0,(F64/SUM(FoodWasteTonnes:CardboardTonnes)))","v":0},"kWh/tonne"]
[null,null,"Net Heat Produced (MMBtu)",null,{"$f":"CONVERT(E66,\"kWh\",\"BTU\")/1000000","v":0},{"$f":"CONVERT(F66,\"kWh\",\"BTU\")/1000000","v":0},"MMBtu/tonne"]
[]
[null,null,"Did you enter the projected waste growth rate in the \"Total Incoming Feedstock\" table (cell E39)?"]

{"sheet":"7-Economic Inputs","index":7,"n_rows":496,"n_cols":79,"rows_kept":496,"cut":false,"hidden":false,"merged":[[3,2,5,6],[3,1,5,1],[14,1,14,4],[14,7,14,10]]}
[]
[null,"Economic Inputs - Costs, Revenues, & Financial Parameters"]
[]
[null,"Instructions: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"PROJECT COSTS",null,null,null,"Units",null,"PROJECT REVENUES",null,null,null,"Units"]
[null,"ENTER ALL COSTS IN US DOLLARS, NOT THE LOCAL CURRENCY.",null,null,null,null,null,"ENTER ALL COSTS IN US DOLLARS, NOT THE LOCAL CURRENCY."]
[null,"Labor ($ in Current Year)",null,null,null,null,null,"Facility Operations ($ in Current Year)"]
[null,"Manager/Engineer - Labor Cost per Person",null,null,null,"$/person/year",null,"Gate Fee (Tipping Fee) to be Charged - Yard Wastes",null,null,null,"$/tonne"]
[null,"Operator - Labor Cost per Person",null,null,null,"$/person/year",null,"Gate Fee (Tipping Fee) to be Charged - Food Wastes",null,null,null,"$/tonne"]
[null,"Total Number of Managers/Engineers",null,null,null,"Full-time Employees",null,"Gate Fee (Tipping Fee) to be Charged - Manure/Sludge",null,null,null,"$/tonne"]
[null,"Total Number of Operators",null,null,null,"Full-time Employees",null,"Gate Fee (Tipping Fee) to be Charged - Other Wastes",null,null,null,"$/tonne"]
[null,"Facility Operations ($ in Current Year)"]
[null,"Process Water Purchase Price",null,null,null,"$/m3",null,"Avoided Landfill Disposal Fee",null,null,null,"$/tonne"]
[null,"Wastewater Treatment Cost",null,null,null,"$/m3",null,"Residual Disposal Fee",null,null,null,"$/tonne"]
[null,"Purchased Bulking Agent Cost (e.g., Wood Chips)",null,null,null,"$/tonne",null,"Transportation Fee",null,null,null,"$/tonne/km"]
[]
[null,"Energy Purchases ($ in Current Year)",null,null,null,null,null,"Sellable End Products ($ in Current Year)"]
[null,"Electricity Purchase Price",null,null,null,"$/kWh",null,"Market Price for Digestate from Wet AD",null,null,null,"$/tonne"]
[null,"Diesel Purchase Price",null,null,null,"$/liter",null,"Market Price for Digestate Effluent (Liquid Digestate) from Wet AD",null,null,null,"$/tonne"]
[null,null,null,null,null,null,null,"Market Price for Dewatered Digestate (from Dry AD or Dewatered from Wet AD)",null,null,null,"$/tonne"]
[null,"Land ($ in Current Year)",null,null,null,null,null,"Market Price for Mulch",null,null,null,"$/tonne"]
[null,"Purchase or Lease Land",null,null,"CHOOSE ONE",null,null,"Wholesale Electricity Sale Price",null,null,null,"$/kWh"]
[null,"Land - Purchase Price",null,null,null,"$/ha",null,"Government Subsidy",null,null,null,"$/kWh"]
[null,"Land - Lease Price",null,null,null,"$/ha/year",null,"Duration of Government Subsidy",null,null,null,"Years"]
[null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(AND(E32=\"Lease\",E34>0),\"OK\",IF(AND(E32=\"Purchase\",E33>0),\"OK\",\"ERROR-Enter Lease/Purchase Price Value\"))","v":"ERROR-Enter Lease/Purchase Price Value"},null,null,"Sell Heat?"]
[null,"Estimated Capital and Equipment Costs",null,null,null,null,null,"Wholesale Heat Price",null,null,null,"$/MMBtu"]
[null,"Infrastructure & Site Development Cost",null,null,null,"$",null,"Percent of Heat Sold",null,null,95,"%",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,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,95]
[null,"Other Misc. Equipment Costs",null,null,null,"$",null,"Inflation and Taxes"]
[null,"Dewatering Equipment Costs",null,null,null,"$",null,"Construction Cost Factor ",null,null,0.5,"ratio",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,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,0.5]
[null,"CHP Equipment Costs",null,null,null,"$",null,"Equipment Cost Factor",null,null,0.5,"ratio",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,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,0.5]
[null,null,null,null,null,null,null,"Inflation Rate - General ",null,null,null,"%"]
[null,"End Products",null,null,null,null,null,"Inflation Rate - Disposal Fee, Gate Fee",null,null,null,"%"]
[null,"Liquid Digestate Products",null,null,null,null,null,"Inflation Rate - Electricity and Fuel",null,null,null,"%"]
[null,"Soil Product Land Application Cost",null,null,0,"$/tonne",null,"Inflation Rate -  Compost, Digestate, Bulking Agent",null,null,null,"%"]
[null,"Soil Product Transport Cost",null,null,0,"$/tonne",null,"Tax Paid on Gross Profits",null,null,null,"%"]
[null,"Solid Soil Digestate Products",null,null,null,null,null,"VAT (Value-Added Tax; same as Goods and Services tax)",null,null,null,"%"]
[null,"Soil Product Land Application Cost",null,null,0,"$/tonne"]
[null,"Soil Product Transport Cost",null,null,0,"$/tonne",null,"Financing"]
[null,"Compost Product",null,null,null,null,null,"Grant Funding",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,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,20]
[null,"Soil Product Land Application Cost",null,null,0,"$/tonne",null,"Depreciation Life - AD Equipment, AD & Composting Infrastructure ",null,null,20,"Years"]
[null,"Soil Product Transport Cost",null,null,0,"$/tonne"]
[null,null,null,null,null,null,null,"Equity Payback",null,null,null,"Years"]
[]
[null,null,null,null,null,null,null,"Percent Debt (% of project financed through debt)",null,null,null,"%"]
[null,null,null,null,null,null,null,"Percent Equity (% of project financed through equity)",null,null,null,"%"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(K54+K55=100%,\"OK\",\"ERROR-Debt + Equity Must Equal 100%\")","v":"ERROR-Debt + Equity Must Equal 100%"}]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(K55>0,\"OK\",\"ERROR-Equity Must be a Minimum of 0.1% for Model to Return Values\")","v":"ERROR-Equity Must be a Minimum of 0.1% for Model to Return Values"}]
[null,null,null,null,null,null,null,"Annual Interest Rate - Short-term Debt ",null,null,null,"%"]
[null,null,null,null,null,null,null,"Annual Interest Rate - Long-term Debt",null,null,null,"%"]
[null,null,null,null,null,null,null,"Tenor (amount of time left to repay loan) - Short-term Debt",null,null,null,"Years"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(AND(K60<=K50,K60>0),\"OK\",IF(K60=0,\"ERROR-Enter Short-term Debt Tenor\", \"ERROR-Debt Tenor Cannot Exceed Composting Equipment Life\"))","v":"ERROR-Enter Short-term Debt Tenor"}]
[null,null,null,null,null,null,null,"Tenor (amount of time left to repay loan) - Long-term Debt ",null,null,null,"Years"]
[null,null,null,null,null,null,null,null,null,"AUTOMATIC VALIDITY CHECK",{"$f":"IF(AND(K62<=K50,K62>0),\"OK\",IF(K62=0,\"ERROR-Enter Long-term Debt Tenor\",\"ERROR-Debt Tenor Cannot Exceed AD Equipment Life\"))","v":"ERROR-Enter Long-term Debt Tenor"}]
[null,null,null,null,null,null,null,"Use Debt/Equity to Finance Purchase of New Composting Equipment at End of Useful Life? ",null,null,"CHOOSE ONE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CHOOSE ONE","CHOOSE ONE"]
[null,"Purchase","Yes"]
[null,"Lease","No"]

{"sheet":"8-Default Values","index":8,"n_rows":128,"n_cols":80,"rows_kept":128,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,5]]}
[]
[null,"Default Values"]
[]
[null,"Instructions:"]
[]
[]
[]
[]
[]
[null,"Technology","Wet AD","Dry AD"]
[null,"Total Annual Waste to AD in YR 1 of Operations",{"$f":"'10-Wet AD'!D20","v":0},{"$f":"'11-Dry AD'!D21","v":0}]
[null,"Facility Design Capacity",{"$f":"IF(C11=0,0,SUM(FoodWasteTonnes:CardboardTonnes)*(1+WasteGrowthRate))","v":0},{"$f":"IF(D11=0,0,SUM(YardWasteTonnes:CardboardTonnes)*(1+WasteGrowthRate))","v":0}]
[]
[null,"Scenario"]
[null,"Facility Operations",5.0000000000000002E-5]
[null,"Operating Days/Year",310,310,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,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,null,null,310,310]
[null,"Land Requirement (ha/tonne)",2.5000000000000001E-5,2.5000000000000001E-5,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,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,null,null,2.5000000000000001E-5,2.5000000000000001E-5]
[null,"Electricity Demand (kWh/tonne) ",0,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,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,null,null,null,null,null,0,0]
[null,"Fuel Demand (liters/tonne) ",0.3,0.3,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,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,null,null,0.3,0.3]
[null,"Net Electricity Output (kWh/tonne)",{"$f":"'6-Waste Inputs'!F65","v":0},{"$f":"'6-Waste Inputs'!E65","v":0}]
[null,"Net Heat Output (MMBtu/tonne)",{"$f":"IF(C12=0,0,'6-Waste Inputs'!F67)","v":0},{"$f":"IF(D12=0,0,'6-Waste Inputs'!E67)","v":0}]
[null,"Primary Screening Residues (% of incoming feedstock)",0.99,0.99,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,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,null,null,0.99,0.99]
[null,"Process Water Requirements (m3/tonne)",3.89,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,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,null,null,null,null,null,3.89,0]
[null," Digestate Produced (% of incoming feedstock)",0.9,0.9,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,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,null,null,0.9,0.9]
[null,"Dewatered Solids Fraction Produced (% of incoming feedstock)",0.15,"Not Applicable",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,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,null,null,0.15,"Not Applicable"]
[null," Liquid Fraction Produced (% of incoming feedstock)",0.85,"Not Applicable",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,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,null,null,0.85,"Not Applicable"]
[null,"Percentage of Liquid Returned to Digestion Process (%)",0.84899999999999998,"Not Applicable",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,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,null,null,0.84899999999999998,"Not Applicable"]
[null,"Wastewater Treatment Requirements (m3/tonne)",{"$f":"0.552","v":0.55200000000000005},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,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,null,null,null,null,null,{"$f":"0.552","v":0.55200000000000005},0]
[null,"Final Screening Residues (% of incoming feedstock)",0.1,0.1,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,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,null,null,0.1,0.1]
[null,"Digestion System Capex"]
[null,"Equipment Cost in Investment Year ($/tonne of installed capacity)",10000,10000]
[null,"Dewatering Cost in Investment Year ($/tonne of installed capacity)",10000,10000]
[null,"CHP Cost in Investment Year ($/kW of installed capacity)",10000,10000]
[null,"Mulching Cost ($/tonne)",{"$f":"IF(C12=0,0,8.47)","v":0},{"$f":"IF(D12=0,0,8.47)","v":0}]
[null,"Infrastructure and Site Development Cost in Investment Year ($/tonne of installed capacity)",10000,10000]
[null,"Capital Cost Contingency (%)",0.1,0.1,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,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,null,null,0.1,0.1]
[null,"All Systems O&M"]
[null,"Maintenance Cost (% of Capex)",0.02,0.02,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,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,null,null,0.02,0.02]
[null,"Insurance (% of total Capex excl. VAT and grants)",0.01,0.01,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,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,null,null,0.01,0.01]
[null,"Outside Services and Supplies (% of O&M before contingency)",0.02,0.02,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,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,null,null,0.02,0.02]
[null,"O&M Cost Contingency (% of O&M)",0.1,0.1,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,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,null,null,0.1,0.1]
[]
[]
[null,"Facility Operations"]
[null,"Net Electricity Output (kWh/Tonne)",{"$f":"IF(C12=0,0,IF('9-Outputs'!#REF!=\"Elec Gen As Is\",'6-Waste Inputs'!F65,IF('9-Outputs'!#REF!=\"Elec Gen Plus X%\",'6-Waste Inputs'!F65*(1+'9-Outputs'!#REF!),IF('9-Outputs'!#REF!=\"Elec Gen Minus X%\",'6-Waste Inputs'!F65*(1-'9-Outputs'!#REF!)))))","v":0},{"$f":"IF(D12=0,0,IF('9-Outputs'!#REF!=\"Elec Gen As Is\",'6-Waste Inputs'!E65,IF('9-Outputs'!#REF!=\"Elec Gen Plus X%\",'6-Waste Inputs'!E65*(1+'9-Outputs'!#REF!),IF('9-Outputs'!#REF!=\"Elec Gen Minus X%\",'6-Waste Inputs'!E65*(1-'9-Outputs'!#REF!)))))","v":0}]
[null,"Net Heat Output (MMBtu/Tonne)",{"$f":"IF(C12=0,0,'6-Waste Inputs'!F67)","v":0},{"$f":"IF(D12=0,0,'6-Waste Inputs'!E67)","v":0}]
[null,"Process Water Requirements (m3/Tonne)",{"$f":"IF(OR('5-Facility Inputs'!#REF!=\"Compost (Liquid Recycled/Discharged to Sewer)\",'5-Facility Inputs'!#REF!=\"Dewatered Digestate (Liquid Recycled/Discharged to Sewer)\"),0.777,0.777+3.111)","v":{"$error":"#REF!"}},0]
[null,"Dewatered Solids Fraction Produced (% of digested feedstock)",{"$f":"IF('5-Facility Inputs'!#REF!=\"Digestate (No Dewatering)\",0,916/1000)","v":{"$error":"#REF!"}},"Not Applicable"]
[null,"Dewatered Liquid Fraction Produced (% of digested feedstock)",{"$f":"IF('5-Facility Inputs'!#REF!=\"Digestate (No Dewatering)\",0,C24-C48)","v":{"$error":"#REF!"}},"Not Applicable"]
[null,"Percentage of Dewatered Liquid Returned to Digestion Process (%)",{"$f":"IF(OR('5-Facility Inputs'!#REF!=\"Compost (Liquid Recycled/Discharged to Sewer)\",'5-Facility Inputs'!#REF!=\"Dewatered Digestate (Liquid Recycled/Discharged to Sewer)\"),84.9%,0)","v":{"$error":"#REF!"}},"Not Applicable"]
[null,"Wastewater Treatment Requirements (m3/Tonne)",{"$f":"IF(OR('5-Facility Inputs'!#REF!=\"Compost (Liquid Recycled/Discharged to Sewer)\",'5-Facility Inputs'!#REF!=\"Dewatered Digestate (Liquid Recycled/Discharged to Sewer)\"),0.001,0)","v":{"$error":"#REF!"}},0]
[null,"Compost Production (% of incoming feedstock) ",{"$f":"IF(OR(#REF!=\"Compost (Liquid Recycled/Discharged to Sewer)\",#REF!=\"Liquid Digestate + Compost\"),65%,IF(OR(#REF!=\"Digestate, Yard Waste Compost\",#REF!=\"Liquid Digestate, Dewatered Digestate, Yard Waste Compost\",#REF!=\"Dewatered Digestate, Yard Waste Compost\"),50%,0%))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Compost\",65%,IF(#REF!=\"Yard Waste Compost, Digestate\",50%,0))","v":{"$error":"#REF!"}}]
[null,"Final Screening Residues (% of incoming feedstock)",{"$f":"IF(OR(#REF!=\"Compost (Liquid Recycled/Discharged to Sewer)\",#REF!=\"Liquid Digestate + Compost\"),20%,IF(OR(#REF!=\"Digestate, Yard Waste Compost\",#REF!=\"Liquid Digestate, Dewatered Digestate, Yard Waste Compost\",#REF!=\"Dewatered Digestate, Yard Waste Compost\"),2%,0%))","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"Compost\",20%,IF(#REF!=\"Yard Waste Compost, Digestate\",2%,0))","v":{"$error":"#REF!"}}]
[null,"Digestion System Capex"]
[null,"Equipment Cost in Investment Year ($/TPY)",{"$f":"IF(C12<20000,0,IF(AND(CapexSensitivity=\"Capex As Is\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Plus X%\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Minus X%\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex As Is\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Plus X%\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Minus X%\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor))))))-C56)","v":0},{"$f":"IF(D12=0,0,IF(CapexSensitivity=\"Capex As Is\",(#REF!*'11-Dry AD'!D23^#REF!)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Plus X%\",(#REF!*'11-Dry AD'!D23^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Minus X%\",(#REF!*'11-Dry AD'!D23^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor))))","v":0}]
[null,"Dewatering Cost in Investment Year ($/TPY)",{"$f":"IF(C12<20000,0,IF(CapexSensitivity=\"Capex As Is\",(#REF!*'10-Wet AD'!D22^#REF!)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Plus X%\",(#REF!*'10-Wet AD'!D22^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Minus X%\",(#REF!*'10-Wet AD'!D22^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor))))","v":0},0]
[null,"CHP Cost in Investment Year ($/kW)",{"$f":"IF(C11<20000,0,IF(CapexSensitivity=\"Capex As Is\",1000*1.15*1.3196964658*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Plus X%\",1000*1.15*1.3196964658*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Minus X%\",1000*1.15*1.3196964658*(1-CapexSensitivityPercent)*EquipmentCostFactor))))","v":0},{"$f":"IF(D12=0,0,IF(CapexSensitivity=\"Capex As Is\",1000*1.15*1.3196964658*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Plus X%\",1000*1.15*1.3196964658*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(CapexSensitivity=\"Capex Minus X%\",1000*1.15*1.3196964658*(1-CapexSensitivityPercent)*EquipmentCostFactor))))","v":0}]
[null,"Mulching Cost ($/Tonne)",{"$f":"IF(C12=0,0,8.47)","v":0},{"$f":"IF(D12=0,0,8.47)","v":0}]
[null,"Infrastructure & Site Development Cost in Investment Year ($/TPY)",{"$f":"IF(C12<20000,0,IF(AND(CapexSensitivity=\"Capex As Is\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Plus X%\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Minus X%\",WWTreatmentOnsite=\"Yes\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex As Is\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Plus X%\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1+CapexSensitivityPercent)*EquipmentCostFactor,IF(AND(CapexSensitivity=\"Capex Minus X%\",WWTreatmentOnsite=\"No\"),(#REF!*'10-Wet AD'!D22^#REF!)*(1-CapexSensitivityPercent)*EquipmentCostFactor)))))))","v":0},{"$f":"IF(D12=0,0,IF(CapexSensitivity=\"Capex As Is\",(#REF!*'11-Dry AD'!D23^#REF!)*ConstructionCostFactor,IF(CapexSensitivity=\"Capex Plus X%\",(#REF!*'11-Dry AD'!D23^#REF!)*ConstructionCostFactor*(1+CapexSensitivityPercent),IF(CapexSensitivity=\"Capex Minus X%\",(#REF!*'11-Dry AD'!D23^#REF!)*ConstructionCostFactor*(1-CapexSensitivityPercent)))))","v":0}]
[null,"Composting System Capex"]
[null,"Equipment Cost in Investment Year ($/TPY)",{"$f":"IF(C11<20000,0,IF('10-Wet AD'!#REF!=0,0,IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,0))))))))","v":0},{"$f":"IF('11-Dry AD'!#REF!=0,0,IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!)*EquipmentCostFactor,0)))))))","v":{"$error":"#REF!"}}]
[null,"Infrastructure & Site Development Cost in Investment Year ($/TPY)",{"$f":"IF(C11<20000,0,IF('10-Wet AD'!#REF!=0,0,IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1-'8-Default Values'!#REF!),IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('10-Wet AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1-'8-Default Values'!#REF!),IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('10-Wet AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'10-Wet AD'!#REF!^#REF!)*ConstructionCostFactor*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),0))))))))","v":0},{"$f":"IF('11-Dry AD'!#REF!=0,0,IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1-'8-Default Values'!#REF!),IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('11-Dry AD'!#REF!=\"Composting W/O Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex As Is\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1-'8-Default Values'!#REF!),IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Plus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1+CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),IF(AND('11-Dry AD'!#REF!=\"Composting With Forced Aeration\",CapexSensitivity=\"Capex Minus X%\"),(#REF!*'11-Dry AD'!#REF!^#REF!)*ConstructionCostFactor*(1-CapexSensitivityPercent)*(1-'8-Default Values'!#REF!),0)))))))","v":{"$error":"#REF!"}}]
[null,"Facility Operations - Electricity Demand"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Operating Days/Year",310,310]
[null,"Land Requirement (ha/tonne)",2.5000000000000001E-5,2.5000000000000001E-5]
[null,"Electricity Demand (kWh/tonne) ","Not Applicable","Not Applicable"]
[null,"Fuel Demand (liters/tonne) ",0.3,0.3]

{"sheet":"9-Outputs","index":9,"n_rows":545,"n_cols":8,"rows_kept":545,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,4]]}
[]
[null,"Outputs"]
[]
[null,"Instructions: ","This sheet summarizes and visualizes some basic information about the project based on user inputs from tab “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.” "]
[]
[]
[]
[null,"Wet Anaerobic Digestion",null,"USD",null,"Dry Anaerobic Digestion",null,"USD"]
[null,"Initial Capital Investment - AD ($)",null,{"$f":"IF(ISERROR(ROUNDUP('10-Wet AD'!D42,-2)),0,(ROUNDUP('10-Wet AD'!D42,-2)))","v":0},null,"Initial Capital Investment - AD ($)",null,{"$f":"IF(ISERROR(ROUNDUP('11-Dry AD'!D42,-2)),0,(ROUNDUP('11-Dry AD'!D42,-2)))","v":0}]
[null,"Capex/tonne ($/TPY)",null,{"$f":"IF(ISERROR(ROUNDUP(D9/D15,0)),0,ROUNDUP(D9/D15,0))","v":0},null,"Capex/tonne ($/TPY)",null,{"$f":"IF(ISERROR(ROUNDUP(H9/H15,0)),0,(ROUNDUP(H9/H15,0)))","v":0}]
[null,"Total Annual Expenses in YR 1 Operations ($/year)",null,{"$f":"IF(ISERROR(ROUNDUP(MIN('10-Wet AD'!D207:Z207),-2)),0,(ROUNDUP(MIN('10-Wet AD'!D207:Z207),-2)))","v":0},null,"Total Annual Expenses in YR 1 Operations ($/year)",null,{"$f":"IF(ISERROR(ROUNDUP(MIN('11-Dry AD'!D197:Z197),-2)),0,(ROUNDUP(MIN('11-Dry AD'!D197:Z197),-2)))","v":0}]
[null,"O&M/tonne in YR 1 Operations ($/tonne of waste processed)",null,{"$f":"IF(ISERROR(ROUNDUP(D11/(D14),0)),0,ROUNDUP(D11/(D14),0))","v":0},null,"O&M/tonne in YR 1 Operations ($/tonne of waste processed)",null,{"$f":"IF(ISERROR(ROUNDUP(H11/(H14),0)),0,(ROUNDUP(H11/(H14),0)))","v":0}]
[null,"Total Land Required (ha)",null,{"$f":"'10-Wet AD'!$D$24","v":0},null,"Total Land Required (ha)",null,{"$f":"'11-Dry AD'!D25","v":0}]
[null,"Total Organic Waste Available In YR 1 (tonnes/year)",null,{"$f":"FeedstockAvailability","v":0},null,"Total Organic Waste Available in YR 1 (tonnes/year)",null,{"$f":"FeedstockAvailability","v":0}]
[null,"Total Waste to AD in YR 1 (tonnes/year)",null,{"$f":"'10-Wet AD'!D20","v":0},null,"Total Waste to AD in YR 1 (tonnes/year)",null,{"$f":"'11-Dry AD'!D21","v":0}]
[null,"Digestate Produced in YR 1 (tonnes/year)",null,{"$f":"MIN('10-Wet AD'!D200:Z200)","v":0},null,"Digestate Produced in YR 1 (tonnes/year)",null,{"$f":"MIN('11-Dry AD'!D190:Z190)","v":0}]
[null,"Waste Diverted from Landfill in YR 1 (tonnes/year)",null,{"$f":"IF(ISERROR('10-Wet AD'!$D$73),0,'10-Wet AD'!$D$73)","v":0},null,"Waste Diverted from Landfill in YR 1 (tonnes/year)",null,{"$f":"IF(ISERROR('11-Dry AD'!$D$73),0,'11-Dry AD'!$D$73)","v":0}]
[null,"Percent of Waste Diverted from Landfill in YR 1 (%)",null,{"$f":"IF(ISERROR($D$17/('10-Wet AD'!$D$73+'10-Wet AD'!$D$72)),0,$D$17/('10-Wet AD'!$D$73+'10-Wet AD'!$D$72))","v":0},null,"Percent of Waste Diverted from Landfill (%)",null,{"$f":"IF(ISERROR($D$17/('11-Dry AD'!$D$73+'10-Wet AD'!$D$72)),0,$D$17/('11-Dry AD'!$D$73+'11-Dry AD'!$D$72))","v":0}]
[null,"Net Electricity Produced by AD System in YR 1 (kWh/year)",null,{"$f":"IF(ISERROR(MIN('10-Wet AD'!D204:Z204)),0,(MIN('10-Wet AD'!D204:Z204)))","v":0},null,"Net Electricity Produced by AD System in YR 1 (kWh/year)",null,{"$f":"IF(ISERROR(MIN('11-Dry AD'!D194:Z194)),0,(MIN('11-Dry AD'!D194:Z194)))","v":0}]
[null,"Electricity Sold in YR 1 (kWh/year)",null,{"$f":"IF(ISERROR(MIN('10-Wet AD'!D205:Z205)),0,(MIN('10-Wet AD'!D205:Z205)))","v":0},null,"Electricity Sold in YR 1 (kWh/year)",null,{"$f":"IF(ISERROR(MIN('11-Dry AD'!D195:Z195)),0,(MIN('11-Dry AD'!D195:Z195)))","v":0}]
[null,"Levered IRR (%)",null,{"$f":"IF(ISERROR('10-Wet AD'!D53),\"Not Viable\",'10-Wet AD'!D53)","v":""},null,"Levered IRR (%)",null,{"$f":"IF(ISERROR('11-Dry AD'!D53),\"Not Viable\",'11-Dry AD'!D53)","v":""}]
[]
[null,"Wet Anaerobic Digestion",null,"USD",null,"Dry Anaerobic Digestion",null,"USD"]
[null,"Project Revenues vs. Expenses",null,null,null,"Project Revenues vs. Expenses"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Wet Anaerobic Digestion",null,"USD",null,"Dry Anaerobic Digestion",null,"USD"]
[null,"Gross Profit",null,null,null,"Gross Profit"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CHOOSE ONE"]
[null,"O&M As Is"]
[null,"O&M Plus X%"]
[null,"O&M Minus X%"]

{"sheet":"10-Wet AD","index":10,"n_rows":207,"n_cols":26,"rows_kept":207,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,4],[52,3,52,4],[53,1,53,4]]}
[]
[null,"Wet Anaerobic Digestion"]
[]
[null,"Guidance: ","This sheet shows the hypothetical project’s estimated annual Income Statement and Balance Sheet, which are used to determine the Internal Rate of Return (IRR). The IRR is the rate that the modeled project’s cash flows break even with initial investment. IRR is determined by setting the net present value of all cash flows (both positive and negative) from the investment equal to zero. Note this model estimates Equity IRR. To estimate Project IRR, please set total debt on the “7-Economic Inputs” tab equal to zero. To find the assumed differences between high and low CAPEX, look on the “8-Default Values” tab. Interpret these values as a range in which the hypothetical project may fall in-between. \n\nThe sheet is organized by first listing important assumptions based on user inputs from tabs “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.” Below this are estimated project costs and revenues, debt schedules, interest, depreciation, and other important information. Lastly, the model estimates the free cash flow in a given year based on the project costs and revenues to estimate IRR (cell D315). "]
[]
[]
[null,"Key Prices"]
[null,"Electricity Sale Price",null,{"$f":"WholesaleElectricitySalePrice","v":0},"$/kWh"]
[null,"Gate Fee - Yard Wastes",null,{"$f":"GateFeeYardWaste","v":0},"$/tonne"]
[null,"Gate Fee - Food Wastes",null,{"$f":"GateFeeFoodWaste","v":0},"$/tonne"]
[null,"Gate Fee - Manure/Sludge Waste",null,{"$f":"GateFeeManure","v":0},"$/tonne"]
[null,"Gate Fee - Paper/Cardboard",null,{"$f":"GateFeeOther","v":0},"$/tonne"]
[]
[null,"AD Facility Assumptions",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationADandAllInfrastructure","v":20},"years"]
[null,"Incoming Yard Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$44,0,YardWasteTonnes)*PerPeakYr1Wet","v":0},"tonnes/year"]
[null,"Incoming Food Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$44,0,FoodWasteTonnes)*PerPeakYr1Wet","v":0},"tonnes/year"]
[null,"Incoming Manure/Sludge Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$44,0,ManureTonnes+SewageTonnes)*PerPeakYr1Wet","v":0},"tonnes/year"]
[null,"Incoming Paper/Cardboard in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$44,0,MixedPaperTonnes+CardboardTonnes)*PerPeakYr1Wet","v":0},"tonnes/year"]
[null,"Total Annual Waste to AD in YR 1",null,{"$f":"IF('5-Facility Inputs'!E9=\"No\",0,SUM(D16:D19))","v":0},"tonnes/year"]
[null,"Daily Waste Throughput in YR 1",null,{"$f":"D20/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"AD Facility Design Capacity",null,{"$f":"SUM('6-Waste Inputs'!E20:K20)","v":0},"tonnes/year"]
[null,"Design Capacity Daily Throughput",null,{"$f":"D22/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"Total AD Land Requirement",null,{"$f":"'8-Default Values'!C17*D22","v":0},"ha"]
[null,"Incoming Bulking Agent",null,{"$f":"PurchasedBulkingAgent","v":0},"tonnes/year"]
[]
[null,"Post Treatment Assumptions",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationADandAllInfrastructure","v":20},"years"]
[null,"Replacement 1",null,{"$f":"IF(D28+OperationsStartYear<(OperationsStartYear+FacilityLifespan),D28+OperationsStartYear,\"N/A\")","v":"N/A"},"year"]
[null,"Replacement 2",null,{"$f":"IF(D29=\"N/A\",\"N/A\",IF(D28+D29<(OperationsStartYear+FacilityLifespan),D28+D29,\"N/A\"))","v":"N/A"},"year"]
[null,"Replacement 3",null,{"$f":"IF(D30=\"N/A\",\"N/A\",IF(D28+D30<(OperationsStartYear+FacilityLifespan),D28+D30,\"N/A\"))","v":"N/A"},"year"]
[]
[null,"Capital Cost Assumptions",null,null,"Units"]
[null,"Infrastructure and Site Development Cost in Investment Year ",null,{"$f":"'7-Economic Inputs'!$E$37","v":0},"$"]
[null,"AD Equipment Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!$E$38","v":0},"$"]
[null,"CHP Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!$E$40","v":0},"$"]
[null,"Dewatering Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!$E$39","v":0},"$"]
[null,"VAT",null,{"$f":"SUM(D35:D37)*'5-Facility Inputs'!D27*VAT","v":0},"$"]
[null,"Land Purchase in Investment Year",null,{"$f":"IF('7-Economic Inputs'!$E$32=\"Purchase\",(LandPurchasePrice*D24),0)","v":0},"$"]
[null,"Ancillary Costs",null,{"$f":"'5-Facility Inputs'!D28","v":0},"$"]
[null,"Capital Cost Contingency",null,{"$f":"'8-Default Values'!C36*(D35+D34+D36+D37)","v":0},"$"]
[null,"AD Capital Investment",null,{"$f":"SUM(D34:D41)","v":0},"$"]
[null,"Grant Funding",null,{"$f":"IF(D20=0,0,GrantFunding)","v":0},"$"]
[null,"TOTAL NET CAPEX IN INVESTMENT YEAR",null,{"$f":"IF(D42-D43>0, D42-D43, 0)","v":0},"$"]
[]
[null,"Financing Assumptions",null,null,"Units"]
[null,"Total Debt in Investment Year",null,{"$f":"PercentDebt*D44","v":0},"$"]
[null,"Total Equity in Investment Year",null,{"$f":"D44*PercentEquity","v":0},"$"]
[null,"Short-term Debt in Investment Year",null,{"$f":"D35*InflationRateCompostDigestateBulking","v":0},"$"]
[null,"Long-term Debt in Investment Year",null,{"$f":"D47-D49","v":0},"$"]
[null,"Finance New Equipment",null,{"$f":"'7-Economic Inputs'!K64","v":"CHOOSE ONE"}]
[]
[null,"Equity IRR",null,{"$f":"IFERROR(IRR(D$169:Z$169),\"\")","v":""}]
[null,"A typical target IRR for an infrastructure project may range between 9% and 15%. If the IRR for the modeled organic waste project falls outside this range, carrying out one or more of the following troubleshooting steps may return a more acceptable IRR:\n• Reduce project expenses such as electricity costs, labor costs, water treatment costs, and land or equipment purchases.\n• Increase project revenue by increasing gate fees, accepting more waste, or raising the price(s) of sellable end product(s).\n• Change project cost of debt and check the interest rate on debt obligations is reasonable.\n• Debt/Equity Ratio: Ensure the debt to equity ratio is reasonable. Is there a way to use more equity to finance a project? "]
[]
[null,"Calendar Year",null,{"$f":"InvestmentYear","v":0},{"$f":"D56+1","v":1},{"$f":"E56+1","v":2},{"$f":"F56+1","v":3},4,5,6,7,{"$f":"K56+1","v":8},{"$f":"L56+1","v":9},10,11,12,13,14,15,16,17,18,19,20,{"$f":"X56+1","v":21},{"$f":"Y56+1","v":22}]
[null,"Operating Year",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,1,IF(D56>OperationsStartYear,C57+1,IF(D56>=D56+#REF!,0))))","v":1},{"$f":"IF(E56<OperationsStartYear,0,IF(E56=OperationsStartYear,1,IF(E56>OperationsStartYear,D57+1,IF(E56>=E56+#REF!,0))))","v":2},{"$f":"IF(F56<OperationsStartYear,0,IF(F56=OperationsStartYear,1,IF(F56>OperationsStartYear,E57+1,IF(F56>=F56+#REF!,0))))","v":3},{"$f":"IF(G56<OperationsStartYear,0,IF(G56=OperationsStartYear,1,IF(G56>OperationsStartYear,F57+1,IF(G56>=G56+#REF!,0))))","v":4},{"$f":"IF(H56<OperationsStartYear,0,IF(H56=OperationsStartYear,1,IF(H56>OperationsStartYear,G57+1,IF(H56>=H56+#REF!,0))))","v":5},{"$f":"IF(I56<OperationsStartYear,0,IF(I56=OperationsStartYear,1,IF(I56>OperationsStartYear,H57+1,IF(I56>=I56+#REF!,0))))","v":6},{"$f":"IF(J56<OperationsStartYear,0,IF(J56=OperationsStartYear,1,IF(J56>OperationsStartYear,I57+1,IF(J56>=J56+#REF!,0))))","v":7},{"$f":"IF(K56<OperationsStartYear,0,IF(K56=OperationsStartYear,1,IF(K56>OperationsStartYear,J57+1,IF(K56>=K56+#REF!,0))))","v":8},{"$f":"IF(L56<OperationsStartYear,0,IF(L56=OperationsStartYear,1,IF(L56>OperationsStartYear,K57+1,IF(L56>=L56+#REF!,0))))","v":9},{"$f":"IF(M56<OperationsStartYear,0,IF(M56=OperationsStartYear,1,IF(M56>OperationsStartYear,L57+1,IF(M56>=M56+#REF!,0))))","v":10},{"$f":"IF(N56<OperationsStartYear,0,IF(N56=OperationsStartYear,1,IF(N56>OperationsStartYear,M57+1,IF(N56>=N56+#REF!,0))))","v":11},{"$f":"IF(O56<OperationsStartYear,0,IF(O56=OperationsStartYear,1,IF(O56>OperationsStartYear,N57+1,IF(O56>=O56+#REF!,0))))","v":12},{"$f":"IF(P56<OperationsStartYear,0,IF(P56=OperationsStartYear,1,IF(P56>OperationsStartYear,O57+1,IF(P56>=P56+#REF!,0))))","v":13},{"$f":"IF(Q56<OperationsStartYear,0,IF(Q56=OperationsStartYear,1,IF(Q56>OperationsStartYear,P57+1,IF(Q56>=Q56+#REF!,0))))","v":14},{"$f":"IF(R56<OperationsStartYear,0,IF(R56=OperationsStartYear,1,IF(R56>OperationsStartYear,Q57+1,IF(R56>=R56+#REF!,0))))","v":15},{"$f":"IF(S56<OperationsStartYear,0,IF(S56=OperationsStartYear,1,IF(S56>OperationsStartYear,R57+1,IF(S56>=S56+#REF!,0))))","v":16},{"$f":"IF(T56<OperationsStartYear,0,IF(T56=OperationsStartYear,1,IF(T56>OperationsStartYear,S57+1,IF(T56>=T56+#REF!,0))))","v":17},{"$f":"IF(U56<OperationsStartYear,0,IF(U56=OperationsStartYear,1,IF(U56>OperationsStartYear,T57+1,IF(U56>=U56+#REF!,0))))","v":18},{"$f":"IF(V56<OperationsStartYear,0,IF(V56=OperationsStartYear,1,IF(V56>OperationsStartYear,U57+1,IF(V56>=V56+#REF!,0))))","v":19},{"$f":"IF(W56<OperationsStartYear,0,IF(W56=OperationsStartYear,1,IF(W56>OperationsStartYear,V57+1,IF(W56>=W56+#REF!,0))))","v":20},{"$f":"IF(X56<OperationsStartYear,0,IF(X56=OperationsStartYear,1,IF(X56>OperationsStartYear,W57+1,IF(X56>=X56+#REF!,0))))","v":21},{"$f":"IF(Y56<OperationsStartYear,0,IF(Y56=OperationsStartYear,1,IF(Y56>OperationsStartYear,X57+1,IF(Y56>=Y56+#REF!,0))))","v":22},{"$f":"IF(Z56<OperationsStartYear,0,IF(Z56=OperationsStartYear,1,IF(Z56>OperationsStartYear,Y57+1,IF(Z56>=Z56+#REF!,0))))","v":23}]
[null,"Waste Assumptions"]
[null,"Incoming Yard Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Food Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Manure/Sludge Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Paper/Cardboard Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Incoming Waste (tonnes/year)",null,{"$f":"D59+D60+D61+D62","v":0},0,{"$f":"F59+F60+F61+F62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Waste to AD (tonnes/year)",null,{"$f":"D63","v":0},{"$f":"E63","v":0},{"$f":"F63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Screening Residues (tonnes/year)",null,{"$f":"D64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"E64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"F64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"G64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"H64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"I64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"J64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"K64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"L64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"M64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"N64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"O64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"P64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Q64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"R64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"S64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"T64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"U64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"V64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"W64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"X64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Y64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Z64*(1-'8-Default Values'!$C$22)","v":0}]
[null,"Digestate Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$24","v":0},{"$f":"E64*'8-Default Values'!$C$24","v":0},{"$f":"F64*'8-Default Values'!$C$24","v":0},{"$f":"G64*'8-Default Values'!$C$24","v":0},{"$f":"H64*'8-Default Values'!$C$24","v":0},{"$f":"I64*'8-Default Values'!$C$24","v":0},{"$f":"J64*'8-Default Values'!$C$24","v":0},{"$f":"K64*'8-Default Values'!$C$24","v":0},{"$f":"L64*'8-Default Values'!$C$24","v":0},{"$f":"M64*'8-Default Values'!$C$24","v":0},{"$f":"N64*'8-Default Values'!$C$24","v":0},{"$f":"O64*'8-Default Values'!$C$24","v":0},{"$f":"P64*'8-Default Values'!$C$24","v":0},{"$f":"Q64*'8-Default Values'!$C$24","v":0},{"$f":"R64*'8-Default Values'!$C$24","v":0},{"$f":"S64*'8-Default Values'!$C$24","v":0},{"$f":"T64*'8-Default Values'!$C$24","v":0},{"$f":"U64*'8-Default Values'!$C$24","v":0},{"$f":"V64*'8-Default Values'!$C$24","v":0},{"$f":"W64*'8-Default Values'!$C$24","v":0},{"$f":"X64*'8-Default Values'!$C$24","v":0},{"$f":"Y64*'8-Default Values'!$C$24","v":0},{"$f":"Z64*'8-Default Values'!$C$24","v":0}]
[null,"Liquid Fraction Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$26","v":0},{"$f":"E64*'8-Default Values'!$C$26","v":0},{"$f":"F64*'8-Default Values'!$C$26","v":0},{"$f":"G64*'8-Default Values'!$C$26","v":0},{"$f":"H64*'8-Default Values'!$C$26","v":0},{"$f":"I64*'8-Default Values'!$C$26","v":0},{"$f":"J64*'8-Default Values'!$C$26","v":0},{"$f":"K64*'8-Default Values'!$C$26","v":0},{"$f":"L64*'8-Default Values'!$C$26","v":0},{"$f":"M64*'8-Default Values'!$C$26","v":0},{"$f":"N64*'8-Default Values'!$C$26","v":0},{"$f":"O64*'8-Default Values'!$C$26","v":0},{"$f":"P64*'8-Default Values'!$C$26","v":0},{"$f":"Q64*'8-Default Values'!$C$26","v":0},{"$f":"R64*'8-Default Values'!$C$26","v":0},{"$f":"S64*'8-Default Values'!$C$26","v":0},{"$f":"T64*'8-Default Values'!$C$26","v":0},{"$f":"U64*'8-Default Values'!$C$26","v":0},{"$f":"V64*'8-Default Values'!$C$26","v":0},{"$f":"W64*'8-Default Values'!$C$26","v":0},{"$f":"X64*'8-Default Values'!$C$26","v":0},{"$f":"Y64*'8-Default Values'!$C$26","v":0},{"$f":"Z64*'8-Default Values'!$C$26","v":0}]
[null,"Liquid Fraction Recycled (tonnes/year)",null,{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!D67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!E67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!F67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!G67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!H67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!I67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!J67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!K67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!L67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!M67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!N67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!O67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!P67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!Q67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!R67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!S67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!T67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!U67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!V67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!W67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!X67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!Y67","v":0},{"$f":"'8-Default Values'!$C$27*'10-Wet AD'!Z67","v":0}]
[null,"Liquid Fraction Available for Selling/Gifting (tonnes/year)",null,{"$f":"D67-D68","v":0},{"$f":"E67-E68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dewatered Solids Fraction Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$25","v":0},{"$f":"E64*'8-Default Values'!$C$25","v":0},{"$f":"F64*'8-Default Values'!$C$25","v":0},{"$f":"G64*'8-Default Values'!$C$25","v":0},{"$f":"H64*'8-Default Values'!$C$25","v":0},{"$f":"I64*'8-Default Values'!$C$25","v":0},{"$f":"J64*'8-Default Values'!$C$25","v":0},{"$f":"K64*'8-Default Values'!$C$25","v":0},{"$f":"L64*'8-Default Values'!$C$25","v":0},{"$f":"M64*'8-Default Values'!$C$25","v":0},{"$f":"N64*'8-Default Values'!$C$25","v":0},{"$f":"O64*'8-Default Values'!$C$25","v":0},{"$f":"P64*'8-Default Values'!$C$25","v":0},{"$f":"Q64*'8-Default Values'!$C$25","v":0},{"$f":"R64*'8-Default Values'!$C$25","v":0},{"$f":"S64*'8-Default Values'!$C$25","v":0},{"$f":"T64*'8-Default Values'!$C$25","v":0},{"$f":"U64*'8-Default Values'!$C$25","v":0},{"$f":"V64*'8-Default Values'!$C$25","v":0},{"$f":"W64*'8-Default Values'!$C$25","v":0},{"$f":"X64*'8-Default Values'!$C$25","v":0},{"$f":"Y64*'8-Default Values'!$C$25","v":0},{"$f":"Z64*'8-Default Values'!$C$25","v":0}]
[null,"Final Screening Residues (tonnes/year)",null,{"$f":"MAX((D65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((E65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((F65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((G65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((H65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((I65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((J65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((K65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((L65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((M65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((N65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((O65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((P65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Q65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((R65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((S65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((T65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((U65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((V65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((W65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((X65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Y65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Z65)*'8-Default Values'!$C$29,0)","v":0}]
[null,"Total Waste to Landfill (tonnes/year)",null,{"$f":"D65+D71","v":0},{"$f":"E65+E71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"R65+R71","v":0},0,0,0,0,0,0,0,0]
[null,"Waste Diverted from Landfill (tonnes/year)",null,{"$f":"D59+D60+D61+D62-D72","v":0},{"$f":"E60+E61+E62-E72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Operating Assumptions "]
[null,"Net Electricity Generation from AD (kWh/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),NetElecProducedWet*D64,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net Heat Generation (MMBtu/year)",null,{"$f":"D64*NetHeatProducedWet","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sold (MMBtu/year)",null,{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",D77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",E77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",F77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",G77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",H77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",I77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",J77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",K77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",L77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",M77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",N77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",O77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",P77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Q77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",R77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",S77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",T77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",U77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",V77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",W77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",X77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Y77,0)*PerHeatSold","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Z77,0)*PerHeatSold","v":0}]
[null,"Diesel Consumption - AD (liters/year)",null,{"$f":"D64*'8-Default Values'!$C$19","v":0},{"$f":"E64*'8-Default Values'!$C$19","v":0},{"$f":"F64*'8-Default Values'!$C$19","v":0},{"$f":"G64*'8-Default Values'!$C$19","v":0},{"$f":"H64*'8-Default Values'!$C$19","v":0},{"$f":"I64*'8-Default Values'!$C$19","v":0},{"$f":"J64*'8-Default Values'!$C$19","v":0},{"$f":"K64*'8-Default Values'!$C$19","v":0},{"$f":"L64*'8-Default Values'!$C$19","v":0},{"$f":"M64*'8-Default Values'!$C$19","v":0},{"$f":"N64*'8-Default Values'!$C$19","v":0},{"$f":"O64*'8-Default Values'!$C$19","v":0},{"$f":"P64*'8-Default Values'!$C$19","v":0},{"$f":"Q64*'8-Default Values'!$C$19","v":0},{"$f":"R64*'8-Default Values'!$C$19","v":0},{"$f":"S64*'8-Default Values'!$C$19","v":0},{"$f":"T64*'8-Default Values'!$C$19","v":0},{"$f":"U64*'8-Default Values'!$C$19","v":0},{"$f":"V64*'8-Default Values'!$C$19","v":0},{"$f":"W64*'8-Default Values'!$C$19","v":0},{"$f":"X64*'8-Default Values'!$C$19","v":0},{"$f":"Y64*'8-Default Values'!$C$19","v":0},{"$f":"Z64*'8-Default Values'!$C$19","v":0}]
[null,"Process Water Required (m3/year)",null,{"$f":"D64*'8-Default Values'!$C$23-D68","v":0},{"$f":"E64*'8-Default Values'!$C$23","v":0},{"$f":"F64*'8-Default Values'!$C$23","v":0},{"$f":"G64*'8-Default Values'!$C$23","v":0},{"$f":"H64*'8-Default Values'!$C$23","v":0},{"$f":"I64*'8-Default Values'!$C$23","v":0},{"$f":"J64*'8-Default Values'!$C$23","v":0},{"$f":"K64*'8-Default Values'!$C$23","v":0},{"$f":"L64*'8-Default Values'!$C$23","v":0},{"$f":"M64*'8-Default Values'!$C$23","v":0},{"$f":"N64*'8-Default Values'!$C$23","v":0},{"$f":"O64*'8-Default Values'!$C$23","v":0},{"$f":"P64*'8-Default Values'!$C$23","v":0},{"$f":"Q64*'8-Default Values'!$C$23","v":0},{"$f":"R64*'8-Default Values'!$C$23","v":0},{"$f":"S64*'8-Default Values'!$C$23","v":0},{"$f":"T64*'8-Default Values'!$C$23","v":0},{"$f":"U64*'8-Default Values'!$C$23","v":0},{"$f":"V64*'8-Default Values'!$C$23","v":0},{"$f":"W64*'8-Default Values'!$C$23","v":0},{"$f":"X64*'8-Default Values'!$C$23","v":0},{"$f":"Y64*'8-Default Values'!$C$23","v":0},{"$f":"Z64*'8-Default Values'!$C$23","v":0}]
[null,"Wastewater Generated (m3/year)",null,{"$f":"D64*'8-Default Values'!$C$28","v":0},{"$f":"E64*'8-Default Values'!$C$28","v":0},{"$f":"F64*'8-Default Values'!$C$28","v":0},{"$f":"G64*'8-Default Values'!$C$28","v":0},{"$f":"H64*'8-Default Values'!$C$28","v":0},{"$f":"I64*'8-Default Values'!$C$28","v":0},{"$f":"J64*'8-Default Values'!$C$28","v":0},{"$f":"K64*'8-Default Values'!$C$28","v":0},{"$f":"L64*'8-Default Values'!$C$28","v":0},{"$f":"M64*'8-Default Values'!$C$28","v":0},{"$f":"N64*'8-Default Values'!$C$28","v":0},{"$f":"O64*'8-Default Values'!$C$28","v":0},{"$f":"P64*'8-Default Values'!$C$28","v":0},{"$f":"Q64*'8-Default Values'!$C$28","v":0},{"$f":"R64*'8-Default Values'!$C$28","v":0},{"$f":"S64*'8-Default Values'!$C$28","v":0},{"$f":"T64*'8-Default Values'!$C$28","v":0},{"$f":"U64*'8-Default Values'!$C$28","v":0},{"$f":"V64*'8-Default Values'!$C$28","v":0},{"$f":"W64*'8-Default Values'!$C$28","v":0},{"$f":"X64*'8-Default Values'!$C$28","v":0},{"$f":"Y64*'8-Default Values'!$C$28","v":0},{"$f":"Z64*'8-Default Values'!$C$28","v":0}]
[null,"Total Number of Managers/Engineers",null,{"$f":"TotalNumberofEngineers","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Operators",null,{"$f":"TotalNumberofOperators","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Economic Assumptions"]
[null,"Electricity Sale Price ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$8*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sale Price ($/MMBtu)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WholesaleHeatPrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Purchase Price ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),ElectricityPurchasePrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Digestate Sale Price ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WetADDigestateMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liquid Fraction Sale Price ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WetADDigestateEffluentMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dewatered Solids Fraction Sale Price ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),DryADDigestateMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mulch Sale Price ($/tonne) ",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),MulchMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fee ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),AvoidedLandfillDisposalFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fee ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),TransportationFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Government Subsidy ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=GovtSubsidyDuration),GovtSubsidy,0)","v":0},{"$f":"IF(AND(E57>0,E57<=GovtSubsidyDuration),GovtSubsidy,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Yard Waste ($/Tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$9*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Food Waste ($/Tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$10*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Manure/Sludge Waste ($/Tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$11*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$12*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Diesel Purchase Price ($/liter)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),DieselPurchasePrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water ($/m3)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WaterPurchasePrice*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wastewater Treatment ($/m3)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WastewaterTreatmentCost*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Transportation ($/tonne/km)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),TransportationFee*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Disposal ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),ResidualDisposalFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mulch Production Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},{"$f":"IF(AND(E57>0,E57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(E56-$D$56)),0)","v":0},{"$f":"IF(AND(F57>0,F57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(F56-$D$56)),0)","v":0},{"$f":"IF(AND(G57>0,G57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(G56-$D$56)),0)","v":0},{"$f":"IF(AND(H57>0,H57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(H56-$D$56)),0)","v":0},{"$f":"IF(AND(I57>0,I57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(I56-$D$56)),0)","v":0},{"$f":"IF(AND(J57>0,J57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(J56-$D$56)),0)","v":0},{"$f":"IF(AND(K57>0,K57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(K56-$D$56)),0)","v":0},{"$f":"IF(AND(L57>0,L57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(L56-$D$56)),0)","v":0},{"$f":"IF(AND(M57>0,M57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(M56-$D$56)),0)","v":0},{"$f":"IF(AND(N57>0,N57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(N56-$D$56)),0)","v":0},{"$f":"IF(AND(O57>0,O57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(O56-$D$56)),0)","v":0},{"$f":"IF(AND(P57>0,P57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(P56-$D$56)),0)","v":0},{"$f":"IF(AND(Q57>0,Q57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(Q56-$D$56)),0)","v":0},{"$f":"IF(AND(R57>0,R57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(R56-$D$56)),0)","v":0},{"$f":"IF(AND(S57>0,S57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(S56-$D$56)),0)","v":0},{"$f":"IF(AND(T57>0,T57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(T56-$D$56)),0)","v":0},{"$f":"IF(AND(U57>0,U57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(U56-$D$56)),0)","v":0},{"$f":"IF(AND(V57>0,V57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(V56-$D$56)),0)","v":0},{"$f":"IF(AND(W57>0,W57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(W56-$D$56)),0)","v":0},{"$f":"IF(AND(X57>0,X57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(X56-$D$56)),0)","v":0},{"$f":"IF(AND(Y57>0,Y57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(Y56-$D$56)),0)","v":0},{"$f":"IF(AND(Z57>0,Z57<=FacilityLifespan),'8-Default Values'!$C$34*((1+InflationRateCompostDigestateBulking)^(Z56-$D$56)),0)","v":0}]
[null,"Lease Price ($/ha/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LandLeasePrice*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Managers - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LaborManager*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operators - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LaborOperator*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),BulkingAgentCost*(1+InflationRateCompostDigestateBulking)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liquid Digestate Soil Product Land Application Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LiquidDigestateLandAppCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liquid Digestate Soil Product Transportation Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LiquidDigestateTransportCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Land Application Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),SolidSoilDigestateLandAppCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Transportation Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),SolidSoilDigestateTransportCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual Maintenance Cost ($/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan,D56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND(E57>0,E57<=FacilityLifespan,E56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND(F57>0,F57<=FacilityLifespan,F56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND(G57>0,G57<=FacilityLifespan,G56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND(H57>0,H57<=FacilityLifespan,H56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND(I57>0,I57<=FacilityLifespan,I56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND(J57>0,J57<=FacilityLifespan,J56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND(K57>0,K57<=FacilityLifespan,K56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND(L57>0,L57<=FacilityLifespan,L56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND(M57>0,M57<=FacilityLifespan,M56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND(N57>0,N57<=FacilityLifespan,N56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND(O57>0,O57<=FacilityLifespan,O56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND(P57>0,P57<=FacilityLifespan,P56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND(Q57>0,Q57<=FacilityLifespan,Q56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND(R57>0,R57<=FacilityLifespan,R56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND(S57>0,S57<=FacilityLifespan,S56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND(T57>0,T57<=FacilityLifespan,T56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND(U57>0,U57<=FacilityLifespan,U56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND(V57>0,V57<=FacilityLifespan,V56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND(W57>0,W57<=FacilityLifespan,W56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND(X57>0,X57<=FacilityLifespan,X56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND(Y57>0,Y57<=FacilityLifespan,Y56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND(Z57>0,Z57<=FacilityLifespan,Z56>=MaintenanceBegins),($D$42)*'8-Default Values'!$C$38*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[null,"Annual Insurance Cost ($/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan,D56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND(E57>0,E57<=FacilityLifespan,E56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND(F57>0,F57<=FacilityLifespan,F56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND(G57>0,G57<=FacilityLifespan,G56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND(H57>0,H57<=FacilityLifespan,H56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND(I57>0,I57<=FacilityLifespan,I56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND(J57>0,J57<=FacilityLifespan,J56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND(K57>0,K57<=FacilityLifespan,K56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND(L57>0,L57<=FacilityLifespan,L56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND(M57>0,M57<=FacilityLifespan,M56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND(N57>0,N57<=FacilityLifespan,N56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND(O57>0,O57<=FacilityLifespan,O56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND(P57>0,P57<=FacilityLifespan,P56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND(Q57>0,Q57<=FacilityLifespan,Q56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND(R57>0,R57<=FacilityLifespan,R56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND(S57>0,S57<=FacilityLifespan,S56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND(T57>0,T57<=FacilityLifespan,T56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND(U57>0,U57<=FacilityLifespan,U56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND(V57>0,V57<=FacilityLifespan,V56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND(W57>0,W57<=FacilityLifespan,W56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND(X57>0,X57<=FacilityLifespan,X56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND(Y57>0,Y57<=FacilityLifespan,Y56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND(Z57>0,Z57<=FacilityLifespan,Z56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$C$39)*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[]
[null,"Consolidated Profit & Loss"]
[null,"Electricity Sales ($/year)",null,{"$f":"D76*D86","v":0},{"$f":"E76*E86","v":0},{"$f":"F76*F86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Government Subsidy ($/year)",null,{"$f":"D95*D76","v":0},{"$f":"E95*E76","v":0},0,0,0,0,0,{"$f":"K95*K76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sales ($/year)",null,{"$f":"D87*D78","v":0},0,0,0,0,0,0,{"$f":"K87*K78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Digestate Sales ($/year)",null,{"$f":"D89*D66","v":0},{"$f":"E89*E66","v":0},{"$f":"F89*F66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dewatered Liquid Fraction Sales ($/year)",null,{"$f":"D90*D69","v":0},{"$f":"E90*E69","v":0},{"$f":"F90*F69","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dewatered Solids Fraction Sales ($/year)",null,{"$f":"D91*D70","v":0},{"$f":"E91*E70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Yard Waste ($/year)",null,{"$f":"D59*D96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Food Waste ($/year)",null,{"$f":"D97*D60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Manure/Sludge ($/year)",null,{"$f":"D98*D61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Other Waste ($/year)",null,{"$f":"D99*D62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fees ($/year)",null,{"$f":"D93*D73","v":0},{"$f":"E93*E73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fees ($/year)",null,{"$f":"(DistanceGeneratorsToLandfill-DistanceGeneratorsToOrganicsFacility)*D94*D73","v":0},{"$f":"(DistanceGeneratorsToLandfill-DistanceGeneratorsToOrganicsFacility)*E94*E73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Land Sale at End of Project Life ($/year)",null,{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",D56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",E56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",F56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",G56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",H56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",I56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",J56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",K56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",L56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",M56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",N56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",O56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",P56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Q56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",R56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",S56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",T56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",U56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",V56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",W56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",X56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Y56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Z56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[null,"Total Revenues ($/year)",null,{"$f":"SUM(D119:D131)","v":0},{"$f":"SUM(E119:E131)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Cost ($/year)",null,{"$f":"(D101*D79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Cost ($/year)",null,{"$f":"D88*'8-Default Values'!$C$18*'10-Wet AD'!D64","v":0},{"$f":"E88*'8-Default Values'!$C$18*'10-Wet AD'!E64","v":0},{"$f":"F88*'8-Default Values'!$C$18*'10-Wet AD'!F64","v":0},{"$f":"G88*'8-Default Values'!$C$18*'10-Wet AD'!G64","v":0},{"$f":"H88*'8-Default Values'!$C$18*'10-Wet AD'!H64","v":0},{"$f":"I88*'8-Default Values'!$C$18*'10-Wet AD'!I64","v":0},{"$f":"J88*'8-Default Values'!$C$18*'10-Wet AD'!J64","v":0},{"$f":"K88*'8-Default Values'!$C$18*'10-Wet AD'!K64","v":0},{"$f":"L88*'8-Default Values'!$C$18*'10-Wet AD'!L64","v":0},{"$f":"M88*'8-Default Values'!$C$18*'10-Wet AD'!M64","v":0},{"$f":"N88*'8-Default Values'!$C$18*'10-Wet AD'!N64","v":0},{"$f":"O88*'8-Default Values'!$C$18*'10-Wet AD'!O64","v":0},{"$f":"P88*'8-Default Values'!$C$18*'10-Wet AD'!P64","v":0},{"$f":"Q88*'8-Default Values'!$C$18*'10-Wet AD'!Q64","v":0},{"$f":"R88*'8-Default Values'!$C$18*'10-Wet AD'!R64","v":0},{"$f":"S88*'8-Default Values'!$C$18*'10-Wet AD'!S64","v":0},{"$f":"T88*'8-Default Values'!$C$18*'10-Wet AD'!T64","v":0},{"$f":"U88*'8-Default Values'!$C$18*'10-Wet AD'!U64","v":0},{"$f":"V88*'8-Default Values'!$C$18*'10-Wet AD'!V64","v":0},{"$f":"W88*'8-Default Values'!$C$18*'10-Wet AD'!W64","v":0},{"$f":"X88*'8-Default Values'!$C$18*'10-Wet AD'!X64","v":0},{"$f":"Y88*'8-Default Values'!$C$18*'10-Wet AD'!Y64","v":0},{"$f":"Z88*'8-Default Values'!$C$18*'10-Wet AD'!Z64","v":0}]
[null,"Process Water Costs ($/year)",null,{"$f":"D102*D80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wastewater Treatment Costs ($/year)",null,{"$f":"D103*D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Transportation Cost ($/year)",null,{"$f":"D104*D72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Disposal Cost ($/year)",null,{"$f":"D105*D72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Cost ($/year)",null,{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((D107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((E107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((F107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((G107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((H107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((I107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((J107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((K107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((L107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((M107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((N107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((O107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((P107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Q107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((R107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((S107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((T107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((U107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((V107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((W107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((X107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Y107*$D$24)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Z107*$D$24)),0)","v":0}]
[null,"Labor Cost ($/year)",null,{"$f":"(D108*D82)+(D83*D109)","v":0},{"$f":"(E108*E82)+(E83*E109)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/year)",null,{"$f":"$D$25*D110","v":0},{"$f":"$D$25*E110","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liquid Digestate Soil Product Land Application Cost ($/year)",null,{"$f":"D111*$D$64","v":0},{"$f":"E111*$D$64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Liquid Digestate Soil Product Transportation Cost ($/year)",null,{"$f":"D112*$D$64","v":0},{"$f":"E112*$D$64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Land Application Cost ($/year)",null,{"$f":"D113*$D$64","v":0},{"$f":"E113*$D$64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Transportation Cost ($/year)",null,{"$f":"D114*$D$64","v":0},{"$f":"E114*$D$64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance Costs ($/year)",null,{"$f":"D115","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance Costs ($/year)",null,{"$f":"D116","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Outside Services and Supplies ($/year)",null,{"$f":"SUM(D133:D147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(E133:E147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(F133:F147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(G133:G147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(H133:H147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(I133:I147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(J133:J147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(K133:K147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(L133:L147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(M133:M147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(N133:N147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(O133:O147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(P133:P147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(Q133:Q147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(R133:R147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(S133:S147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(T133:T147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(U133:U147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(V133:V147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(W133:W147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(X133:X147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(Y133:Y147)*'8-Default Values'!$C$40","v":0},{"$f":"SUM(Z133:Z147)*'8-Default Values'!$C$40","v":0}]
[null,"Operating Cost Contingency ($/year)",null,{"$f":"SUM(D133:D148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(E133:E148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(F133:F148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(G133:G148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(H133:H148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(I133:I148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(J133:J148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(K133:K148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(L133:L148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(M133:M148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(N133:N148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(O133:O148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(P133:P148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(Q133:Q148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(R133:R148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(S133:S148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(T133:T148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(U133:U148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(V133:V148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(W133:W148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(X133:X148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(Y133:Y148)*'8-Default Values'!$C$41","v":0},{"$f":"SUM(Z133:Z148)*'8-Default Values'!$C$41","v":0}]
[null,"Cost of Goods Sold (COGS)",null,{"$f":"SUM(D133:D136)+SUM(D139:D148)+D164","v":0},{"$f":"SUM(E133:E136)+SUM(E139:E148)+E164","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenses ($/year)",null,{"$f":"SUM(D133:D149)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total O&M/Tonne of Waste Processed",null,{"$f":"IF(D57>0,D151/(D63),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E57>0,E151/(E63),0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F57>0,F151/(F63),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Adjusted COGS ($/year)",null,{"$f":"D150","v":0},{"$f":"E150","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted Expenses ($/year)",null,{"$f":"D151","v":0},{"$f":"E151","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Profit",null,{"$f":"D119+SUM(D121:D128)-D153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBITDA",null,{"$f":"D132-D154","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation",null,{"$f":"D176","v":0},{"$f":"E176","v":0},{"$f":"F176","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y176","v":0},{"$f":"Z176","v":0}]
[null,"EBIT",null,{"$f":"D156-D157","v":0},{"$f":"E156-E157","v":0},{"$f":"F156-F157","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y156-Y157","v":0},{"$f":"Z156-Z157","v":0}]
[]
[null,"Operating Cash Flow"]
[null,"EBIT",null,{"$f":"D158","v":0},{"$f":"E158","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y158","v":0},{"$f":"Z158","v":0}]
[null,"Taxes",null,{"$f":"IF(D155>0,-D155*TaxPaidGrossProfits,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBIAT (After Tax EBIT)",null,{"$f":"D161+D162","v":0},{"$f":"E161+E162","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y161+Y162","v":0},{"$f":"Z161+Z162","v":0}]
[null,"Depreciation",null,{"$f":"D176","v":0},{"$f":"E176","v":0},{"$f":"F176","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y176","v":0},{"$f":"Z176","v":0}]
[null,"Operating Cash Flow",null,{"$f":"D163+D164","v":0},{"$f":"E163+E164","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y163+Y164","v":0},{"$f":"Z163+Z164","v":0}]
[null,"Debt Service",null,{"$f":"-D197","v":0},{"$f":"-E197","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-Y197","v":0},{"$f":"-Z197","v":0}]
[null,"Initial Equity ",null,{"$f":"IF(D56=InvestmentYear,$D$48,0)","v":0},{"$f":"IF(E56=InvestmentYear,$D$48,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Initial Debt",null,{"$f":"IF(D56=InvestmentYear,$D$47,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Levered Free Cash Flow",null,{"$f":"(-D167)+D165+(-D197)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Capex and Depreciation Schedule"]
[null,"AD Equipment, Infrastructure, and Site Development Investment",null,{"$f":"IF(D56=InvestmentYear,$D$35+$D$34+$D$36+$D$37,0)","v":0},{"$f":"IF(E56=InvestmentYear,$D$35+$D$34+$D$36+$D$37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation - Infrastructure and Site Development",null,null,{"$f":"IF(AND(E57<=EquipmentCostFactor,E57>0),(SUM($D$173:D173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(F57<=EquipmentCostFactor,F57>0),(SUM($D$173:E173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(G57<=EquipmentCostFactor,G57>0),(SUM($D$173:F173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(H57<=EquipmentCostFactor,H57>0),(SUM($D$173:G173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(I57<=EquipmentCostFactor,I57>0),(SUM($D$173:H173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(J57<=EquipmentCostFactor,J57>0),(SUM($D$173:I173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(K57<=EquipmentCostFactor,K57>0),(SUM($D$173:J173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(L57<=EquipmentCostFactor,L57>0),(SUM($D$173:K173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(M57<=EquipmentCostFactor,M57>0),(SUM($D$173:L173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(N57<=EquipmentCostFactor,N57>0),(SUM($D$173:M173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(O57<=EquipmentCostFactor,O57>0),(SUM($D$173:N173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(P57<=EquipmentCostFactor,P57>0),(SUM($D$173:O173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Q57<=EquipmentCostFactor,Q57>0),(SUM($D$173:P173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(R57<=EquipmentCostFactor,R57>0),(SUM($D$173:Q173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(S57<=EquipmentCostFactor,S57>0),(SUM($D$173:R173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(T57<=EquipmentCostFactor,T57>0),(SUM($D$173:S173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(U57<=EquipmentCostFactor,U57>0),(SUM($D$173:T173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(V57<=EquipmentCostFactor,V57>0),(SUM($D$173:U173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(W57<=EquipmentCostFactor,W57>0),(SUM($D$173:V173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(X57<=EquipmentCostFactor,X57>0),(SUM($D$173:W173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Y57<=EquipmentCostFactor,Y57>0),(SUM($D$173:X173)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Z57<=EquipmentCostFactor,Z57>0),(SUM($D$173:Y173)/EquipmentCostFactor),0)","v":0}]
[null,"Depreciation Initial Investment",null,null,{"$f":"E174","v":0},{"$f":"F174","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Depreciation",null,null,{"$f":"SUM(E175:E175)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Financing"]
[null,"Short-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,$D$49,C184))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)),0,(-IPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)))","v":0},{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,E57,TenorShortTermDebt,$D$49)),0,(-IPMT(InterestRateShortTermDebt,E57,TenorShortTermDebt,$D$49)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)),0,(-PPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D181+D182","v":0},{"$f":"E181+E182","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y181+Y182","v":0},{"$f":"Z181+Z182","v":0}]
[null,"EOY Balance",null,{"$f":"D180-D182","v":0},{"$f":"E180-E182","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y180-Y182","v":0},{"$f":"Z180-Z182","v":0}]
[]
[null,"Long-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,$D$50,C191))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)),0,(-IPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)),0,(-PPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D188+D189","v":0},{"$f":"E188+E189","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y188+Y189","v":0},{"$f":"Z188+Z189","v":0}]
[null,"EOY Balance",null,{"$f":"D187-D189","v":0},{"$f":"E187-E189","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y187-Y189","v":0},{"$f":"Z187-Z189","v":0}]
[]
[]
[null,"Summary"]
[null,"Interest Payment",null,{"$f":"D181+D188","v":0},{"$f":"E181+E188","v":0},{"$f":"F181+F188","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"D182+D189","v":0},{"$f":"E182+E189","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D183+D190","v":0},{"$f":"E183+E190","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"DO NOT DELETE"]
[null,"Digestate Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D66=0,\"\",D66)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Liquid Fraction Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D67=0,\"\",D67)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Dewatered Solids Fraction Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D70=0,\"\",D70)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Waste Diverted from Landfill in YR 1 (tonnes/year)",null,{"$f":"IF(D73=0,\"\",D73)","v":""},{"$f":"IF(E73=0,\"\",E73)","v":""},{"$f":"IF(F73=0,\"\",F73)","v":""},"","","","","","","","","","","","","","","","","","","",""]
[null,"Net Electricity Produced by AD System (kWh/year)",null,{"$f":"IF(D76=0,\"\",D76)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Electricity Sold (kWh/year)",null,{"$f":"IF(D120=0,\"\",D120)","v":""},{"$f":"IF(E120=0,\"\",E120)","v":""},"","","","","",{"$f":"IF(K120=0,\"\",K120)","v":""},"","","","","","","","","","","","","","",""]
[null,"Total Revenues",null,{"$f":"IF(D132=0,\"\",D132)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Expenses",null,{"$f":"IF(D154=0,\"\",D154+D197)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"11-Dry AD","index":11,"n_rows":197,"n_cols":26,"rows_kept":197,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,4],[52,3,52,4],[53,1,53,4]]}
[]
[null,"Dry Anaerobic Digestion"]
[]
[null,"Guidance: ","This sheet shows the hypothetical project’s estimated annual Income Statement and Balance Sheet, which are used to determine the Internal Rate of Return (IRR). The IRR is the rate that the modeled project’s cash flows break even with initial investment. IRR is determined by setting the net present value of all cash flows (both positive and negative) from the investment equal to zero. Note this model estimates Equity IRR. To estimate Project IRR, please set total debt on the “7-Economic Inputs” tab equal to zero. To find the assumed differences between high and low CAPEX, look on the “8-Default Values” tab. Interpret these values as a range in which the hypothetical project may fall in-between. \n\nThe sheet is organized by first listing important assumptions based on user inputs from tabs “5-Faculty Inputs,” “6-Waste Inputs,” “7-Economic Inputs,” and “8-Default Values.” Below this are estimated project costs and revenues, debt schedules, interest, depreciation, and other important information. Lastly, the model estimates the free cash flow in a given year based on the project costs and revenues to estimate IRR (cell D299)."]
[]
[]
[null,"Key Outputs"]
[null,"Electricity Sale Price",null,{"$f":"WholesaleElectricitySalePrice","v":0},"$/kWh"]
[null,"Gate Fee - Yard Waste",null,{"$f":"GateFeeYardWaste","v":0},"$/tonne"]
[null,"Gate Fee - Food Waste",null,{"$f":"GateFeeFoodWaste","v":0},"$/tonne"]
[null,"Gate Fee - Manure/Sludge Waste",null,{"$f":"GateFeeManure","v":0},"$/tonne"]
[null,"Gate Fee - Other Waste",null,{"$f":"GateFeeOther","v":0},"$/tonne"]
[]
[null,"AD Facility Assumptions",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationADandAllInfrastructure","v":20},"years"]
[null,"Incoming Yard Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$45,0,YardWasteTonnes)*PerPeakYr1Dry","v":0},"tonnes/year"]
[null,"Incoming Food Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$45,0,FoodWasteTonnes)*PerPeakYr1Dry","v":0},"tonnes/year"]
[null,"Incoming Manure/Sludge Waste in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$45,0,ManureTonnes+SewageTonnes)*PerPeakYr1Dry","v":0},"tonnes/year"]
[null,"Incoming Paper/Cardboard in YR 1",null,{"$f":"IF(SUM(FoodWasteTonnes:CardboardTonnes)<'6-Waste Inputs'!$E$45,0,MixedPaperTonnes+CardboardTonnes)*PerPeakYr1Dry","v":0},"tonnes/year"]
[null,"Total Annual Waste to AD in YR 1",null,{"$f":"IF('5-Facility Inputs'!E8=\"No\",0,SUM(D16:D19))","v":0},"tonnes/year"]
[null,"Daily Waste Throughput in YR 1",null,{"$f":"D20/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"AD Facility Design Capacity",null,{"$f":"SUM('6-Waste Inputs'!E20:K20)","v":0},"tonnes/year"]
[null,"Design Capacity Daily Throughput",null,{"$f":"D22/'8-Default Values'!C16","v":0},"tonnes/day"]
[null,"Total AD Land Requirement",null,{"$f":"'8-Default Values'!C17*D22","v":0},"ha"]
[null,"Total AD Land Requirement",null,{"$f":"PurchasedBulkingAgent","v":0},"ha"]
[]
[null,"Post Treatment Assumptions",null,null,"Units"]
[null,"Equipment Lifespan",null,{"$f":"DepreciationADandAllInfrastructure","v":20},"years"]
[null,"Replacement 1",null,{"$f":"IF(D28+OperationsStartYear<(OperationsStartYear+FacilityLifespan),D28+OperationsStartYear,\"N/A\")","v":"N/A"},"year"]
[null,"Replacement 2",null,{"$f":"IF(D29=\"N/A\",\"N/A\",IF(D28+D29<(OperationsStartYear+FacilityLifespan),D28+D29,\"N/A\"))","v":"N/A"},"year"]
[null,"Replacement 3",null,{"$f":"IF(D30=\"N/A\",\"N/A\",IF(D28+D30<(OperationsStartYear+FacilityLifespan),D28+D30,\"N/A\"))","v":"N/A"},"year"]
[]
[null,"Capital Cost Assumptions",null,null,"Units"]
[null,"Infrastructure and Site Development Cost in Investment Year ",null,{"$f":"'7-Economic Inputs'!$E$37","v":0},"$"]
[null,"AD Equipment Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!$E$38","v":0},"$"]
[null,"CHP Cost in Investment Year",null,{"$f":"'7-Economic Inputs'!$E$40","v":0},"$"]
[null,"Dewatering Cost in Investment Year",null,0,"N/A"]
[null,"VAT",null,{"$f":"SUM(D35:D37)*'5-Facility Inputs'!D27*VAT","v":0},"$"]
[null,"Land Purchase in Investment Year",null,{"$f":"IF('7-Economic Inputs'!$E$32=\"Purchase\",(LandPurchasePrice*D24),0)","v":0},"$"]
[null,"Ancillary Costs",null,{"$f":"'5-Facility Inputs'!D28","v":0},"$"]
[null,"Capital Cost Contingency",null,{"$f":"'8-Default Values'!C36*(D35+D34+D36+D37)","v":0},"$"]
[null,"AD Capital Investment",null,{"$f":"SUM(D34:D41)","v":0},"$"]
[null,"Grant Funding",null,{"$f":"IF(D20=0,0,GrantFunding)","v":0},"$"]
[null,"TOTAL NET CAPEX IN INVESTMENT YEAR",null,{"$f":"IF(D42-D43>0, D42-D43, 0)","v":0},"$"]
[]
[null,"Financing Assumptions",null,null,"Units"]
[null,"Total Debt in Investment Year",null,{"$f":"PercentDebt*D44","v":0},"$"]
[null,"Total Equity in Investment Year",null,{"$f":"D44*PercentEquity","v":0},"$"]
[null,"Short-term Debt in Investment Year",null,{"$f":"D35*InflationRateCompostDigestateBulking","v":0},"$"]
[null,"Long-term Debt in Investment Year",null,{"$f":"D47-D49","v":0},"$"]
[null,"Finance New Equipment",null,{"$f":"'7-Economic Inputs'!K64","v":"CHOOSE ONE"}]
[]
[null,"Equity IRR",null,{"$f":"IFERROR(IRR($D$160:$Z$160),\"\")","v":""}]
[null,"A typical target IRR for an infrastructure project may range between 9% and 15%. If the IRR for the modeled organic waste project falls outside this range, carrying out one or more of the following troubleshooting steps may return a more acceptable IRR:\n• Reduce project expenses such as electricity costs, labor costs, water treatment costs, and land or equipment purchases.\n• Increase project revenue by increasing gate fees, accepting more waste, or raising the price(s) of sellable end product(s).\n• Change project cost of debt and check the interest rate on debt obligations is reasonable.\n• Debt/Equity Ratio: Ensure the debt to equity ratio is reasonable. Is there a way to use more equity to finance a project? "]
[]
[null,"Calendar Year",null,{"$f":"InvestmentYear","v":0},{"$f":"D56+1","v":1},{"$f":"E56+1","v":2},3,4,5,6,7,{"$f":"K56+1","v":8},{"$f":"L56+1","v":9},10,11,12,13,14,15,16,17,18,19,20,{"$f":"X56+1","v":21},{"$f":"Y56+1","v":22}]
[null,"Operating Year",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,1,IF(D56>OperationsStartYear,C57+1)))","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"Waste Assumptions"]
[null,"Incoming Yard Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),YardWasteTonnes*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Food Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),FoodWasteTonnes*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Manure/Sludge Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Incoming Paper/Cardboard Waste (tonnes/year)",null,{"$f":"IF(AND(D$57>0,D$57<=FacilityLifespan),(ManureTonnes+SewageTonnes)*PerPeakYr0Wet,0)","v":0},{"$f":"IF(AND(E$57>0,E$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr1Wet,0)","v":0},{"$f":"IF(AND(F$57>0,F$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr2Wet,0)","v":0},{"$f":"IF(AND(G$57>0,G$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr3Wet,0)","v":0},{"$f":"IF(AND(H$57>0,H$57<=FacilityLifespan),(MixedPaperTonnes+CardboardTonnes)*PerPeakYr4Wet,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Incoming Waste (tonnes/year)",null,{"$f":"D59+D60+D61+D62","v":0},0,{"$f":"F59+F60+F61+F62","v":0},0,0,0,{"$f":"J59+J60+J61+J62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Waste to AD (tonnes/year)",null,{"$f":"D63","v":0},{"$f":"E63","v":0},{"$f":"F63","v":0},0,0,0,{"$f":"J63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Screening Residues (tonnes/year)",null,{"$f":"D64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"E64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"F64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"G64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"H64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"I64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"J64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"K64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"L64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"M64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"N64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"O64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"P64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Q64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"R64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"S64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"T64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"U64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"V64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"W64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"X64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Y64*(1-'8-Default Values'!$C$22)","v":0},{"$f":"Z64*(1-'8-Default Values'!$C$22)","v":0}]
[null,"Digestate Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$24","v":0},{"$f":"E64*'8-Default Values'!$C$24","v":0},{"$f":"F64*'8-Default Values'!$C$24","v":0},{"$f":"G64*'8-Default Values'!$C$24","v":0},{"$f":"H64*'8-Default Values'!$C$24","v":0},{"$f":"I64*'8-Default Values'!$C$24","v":0},{"$f":"J64*'8-Default Values'!$C$24","v":0},{"$f":"K64*'8-Default Values'!$C$24","v":0},{"$f":"L64*'8-Default Values'!$C$24","v":0},{"$f":"M64*'8-Default Values'!$C$24","v":0},{"$f":"N64*'8-Default Values'!$C$24","v":0},{"$f":"O64*'8-Default Values'!$C$24","v":0},{"$f":"P64*'8-Default Values'!$C$24","v":0},{"$f":"Q64*'8-Default Values'!$C$24","v":0},{"$f":"R64*'8-Default Values'!$C$24","v":0},{"$f":"S64*'8-Default Values'!$C$24","v":0},{"$f":"T64*'8-Default Values'!$C$24","v":0},{"$f":"U64*'8-Default Values'!$C$24","v":0},{"$f":"V64*'8-Default Values'!$C$24","v":0},{"$f":"W64*'8-Default Values'!$C$24","v":0},{"$f":"X64*'8-Default Values'!$C$24","v":0},{"$f":"Y64*'8-Default Values'!$C$24","v":0},{"$f":"Z64*'8-Default Values'!$C$24","v":0}]
[null,"Liquid Fraction Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$26","v":0},{"$f":"E64*'8-Default Values'!$C$26","v":0},{"$f":"F64*'8-Default Values'!$C$26","v":0},{"$f":"G64*'8-Default Values'!$C$26","v":0},{"$f":"H64*'8-Default Values'!$C$26","v":0},{"$f":"I64*'8-Default Values'!$C$26","v":0},{"$f":"J64*'8-Default Values'!$C$26","v":0},{"$f":"K64*'8-Default Values'!$C$26","v":0},{"$f":"L64*'8-Default Values'!$C$26","v":0},{"$f":"M64*'8-Default Values'!$C$26","v":0},{"$f":"N64*'8-Default Values'!$C$26","v":0},{"$f":"O64*'8-Default Values'!$C$26","v":0},{"$f":"P64*'8-Default Values'!$C$26","v":0},{"$f":"Q64*'8-Default Values'!$C$26","v":0},{"$f":"R64*'8-Default Values'!$C$26","v":0},{"$f":"S64*'8-Default Values'!$C$26","v":0},{"$f":"T64*'8-Default Values'!$C$26","v":0},{"$f":"U64*'8-Default Values'!$C$26","v":0},{"$f":"V64*'8-Default Values'!$C$26","v":0},{"$f":"W64*'8-Default Values'!$C$26","v":0},{"$f":"X64*'8-Default Values'!$C$26","v":0},{"$f":"Y64*'8-Default Values'!$C$26","v":0},{"$f":"Z64*'8-Default Values'!$C$26","v":0}]
[null,"Liquid Fraction Recycled (tonnes/year)",null,{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!D67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!E67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!F67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!G67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!H67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!I67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!J67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!K67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!L67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!M67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!N67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!O67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!P67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!Q67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!R67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!S67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!T67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!U67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!V67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!W67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!X67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!Y67","v":0},{"$f":"'8-Default Values'!$C$27*'11-Dry AD'!Z67","v":0}]
[null,"Liquid Fraction Available for Selling/Gifting (tonnes/year)",null,{"$f":"D67-D68","v":0},{"$f":"E67-E68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Dewatered Solids Fraction Produced (tonnes/year)",null,{"$f":"D64*'8-Default Values'!$C$25","v":0},{"$f":"E64*'8-Default Values'!$C$25","v":0},{"$f":"F64*'8-Default Values'!$C$25","v":0},{"$f":"G64*'8-Default Values'!$C$25","v":0},{"$f":"H64*'8-Default Values'!$C$25","v":0},{"$f":"I64*'8-Default Values'!$C$25","v":0},{"$f":"J64*'8-Default Values'!$C$25","v":0},{"$f":"K64*'8-Default Values'!$C$25","v":0},{"$f":"L64*'8-Default Values'!$C$25","v":0},{"$f":"M64*'8-Default Values'!$C$25","v":0},{"$f":"N64*'8-Default Values'!$C$25","v":0},{"$f":"O64*'8-Default Values'!$C$25","v":0},{"$f":"P64*'8-Default Values'!$C$25","v":0},{"$f":"Q64*'8-Default Values'!$C$25","v":0},{"$f":"R64*'8-Default Values'!$C$25","v":0},{"$f":"S64*'8-Default Values'!$C$25","v":0},{"$f":"T64*'8-Default Values'!$C$25","v":0},{"$f":"U64*'8-Default Values'!$C$25","v":0},{"$f":"V64*'8-Default Values'!$C$25","v":0},{"$f":"W64*'8-Default Values'!$C$25","v":0},{"$f":"X64*'8-Default Values'!$C$25","v":0},{"$f":"Y64*'8-Default Values'!$C$25","v":0},{"$f":"Z64*'8-Default Values'!$C$25","v":0}]
[null,"Final Screening Residues (tonnes/year)",null,{"$f":"MAX((D65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((E65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((F65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((G65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((H65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((I65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((J65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((K65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((L65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((M65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((N65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((O65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((P65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Q65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((R65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((S65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((T65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((U65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((V65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((W65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((X65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Y65)*'8-Default Values'!$C$29,0)","v":0},{"$f":"MAX((Z65)*'8-Default Values'!$C$29,0)","v":0}]
[null,"Total Waste to Landfill (tonnes/year)",null,{"$f":"D65+D71","v":0},{"$f":"E65+E71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Waste Diverted from Landfill (tonnes/year)",null,{"$f":"D59+D60+D61+D62-D72","v":0},{"$f":"E59+E60+E61+E62-E72","v":0},{"$f":"F59+F60+F61+F62-F72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Operating Assumptions "]
[null,"Net Electricity Generation from AD (kWh/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),NetElecProducedWet*D64,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Net Heat Generation (MMBtu/year)",null,{"$f":"D64*NetHeatProducedWet","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sold (MMBtu/year)",null,{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",D77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",E77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",F77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",G77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",H77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",I77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",J77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",K77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",L77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",M77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",N77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",O77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",P77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Q77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",R77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",S77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",T77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",U77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",V77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",W77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",X77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Y77,0)","v":0},{"$f":"IF('7-Economic Inputs'!$K$35=\"Yes\",Z77,0)","v":0}]
[null,"Diesel Consumption - AD (liters/year)",null,{"$f":"D64*'8-Default Values'!$C$19","v":0},{"$f":"E64*'8-Default Values'!$C$19","v":0},{"$f":"F64*'8-Default Values'!$C$19","v":0},{"$f":"G64*'8-Default Values'!$C$19","v":0},{"$f":"H64*'8-Default Values'!$C$19","v":0},{"$f":"I64*'8-Default Values'!$C$19","v":0},{"$f":"J64*'8-Default Values'!$C$19","v":0},{"$f":"K64*'8-Default Values'!$C$19","v":0},{"$f":"L64*'8-Default Values'!$C$19","v":0},{"$f":"M64*'8-Default Values'!$C$19","v":0},{"$f":"N64*'8-Default Values'!$C$19","v":0},{"$f":"O64*'8-Default Values'!$C$19","v":0},{"$f":"P64*'8-Default Values'!$C$19","v":0},{"$f":"Q64*'8-Default Values'!$C$19","v":0},{"$f":"R64*'8-Default Values'!$C$19","v":0},{"$f":"S64*'8-Default Values'!$C$19","v":0},{"$f":"T64*'8-Default Values'!$C$19","v":0},{"$f":"U64*'8-Default Values'!$C$19","v":0},{"$f":"V64*'8-Default Values'!$C$19","v":0},{"$f":"W64*'8-Default Values'!$C$19","v":0},{"$f":"X64*'8-Default Values'!$C$19","v":0},{"$f":"Y64*'8-Default Values'!$C$19","v":0},{"$f":"Z64*'8-Default Values'!$C$19","v":0}]
[null,"Process Water Required (m3/year)",null,{"$f":"D64*'8-Default Values'!$C$23-D68","v":0},{"$f":"E64*'8-Default Values'!$C$23-E68","v":0},{"$f":"F64*'8-Default Values'!$C$23-F68","v":0},{"$f":"G64*'8-Default Values'!$C$23-G68","v":0},{"$f":"H64*'8-Default Values'!$C$23-H68","v":0},{"$f":"I64*'8-Default Values'!$C$23-I68","v":0},{"$f":"J64*'8-Default Values'!$C$23-J68","v":0},{"$f":"K64*'8-Default Values'!$C$23-K68","v":0},{"$f":"L64*'8-Default Values'!$C$23-L68","v":0},{"$f":"M64*'8-Default Values'!$C$23-M68","v":0},{"$f":"N64*'8-Default Values'!$C$23-N68","v":0},{"$f":"O64*'8-Default Values'!$C$23-O68","v":0},{"$f":"P64*'8-Default Values'!$C$23-P68","v":0},{"$f":"Q64*'8-Default Values'!$C$23-Q68","v":0},{"$f":"R64*'8-Default Values'!$C$23-R68","v":0},{"$f":"S64*'8-Default Values'!$C$23-S68","v":0},{"$f":"T64*'8-Default Values'!$C$23-T68","v":0},{"$f":"U64*'8-Default Values'!$C$23-U68","v":0},{"$f":"V64*'8-Default Values'!$C$23-V68","v":0},{"$f":"W64*'8-Default Values'!$C$23-W68","v":0},{"$f":"X64*'8-Default Values'!$C$23-X68","v":0},{"$f":"Y64*'8-Default Values'!$C$23-Y68","v":0},{"$f":"Z64*'8-Default Values'!$C$23-Z68","v":0}]
[null,"Wastewater Generated (m3/year)",null,{"$f":"D64*'8-Default Values'!$C$28","v":0},{"$f":"E64*'8-Default Values'!$C$28","v":0},{"$f":"F64*'8-Default Values'!$C$28","v":0},{"$f":"G64*'8-Default Values'!$C$28","v":0},{"$f":"H64*'8-Default Values'!$C$28","v":0},{"$f":"I64*'8-Default Values'!$C$28","v":0},{"$f":"J64*'8-Default Values'!$C$28","v":0},{"$f":"K64*'8-Default Values'!$C$28","v":0},{"$f":"L64*'8-Default Values'!$C$28","v":0},{"$f":"M64*'8-Default Values'!$C$28","v":0},{"$f":"N64*'8-Default Values'!$C$28","v":0},{"$f":"O64*'8-Default Values'!$C$28","v":0},{"$f":"P64*'8-Default Values'!$C$28","v":0},{"$f":"Q64*'8-Default Values'!$C$28","v":0},{"$f":"R64*'8-Default Values'!$C$28","v":0},{"$f":"S64*'8-Default Values'!$C$28","v":0},{"$f":"T64*'8-Default Values'!$C$28","v":0},{"$f":"U64*'8-Default Values'!$C$28","v":0},{"$f":"V64*'8-Default Values'!$C$28","v":0},{"$f":"W64*'8-Default Values'!$C$28","v":0},{"$f":"X64*'8-Default Values'!$C$28","v":0},{"$f":"Y64*'8-Default Values'!$C$28","v":0},{"$f":"Z64*'8-Default Values'!$C$28","v":0}]
[null,"Total Number of Managers/Engineers",null,{"$f":"TotalNumberofEngineers","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Number of Operators",null,{"$f":"TotalNumberofOperators","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Economic Assumptions"]
[null,"Electricity Sale Price ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$8*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sale Price ($/MMBtu)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WholesaleHeatPrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Purchase Price ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),ElectricityPurchasePrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Digestate Sale Price ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),DryADDigestateMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Mulch Sale Price ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),MulchMarketPrice*((1+InflationRateCompostDigestateBulking)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fee ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),AvoidedLandfillDisposalFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fee ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),TransportationFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Government Subsidy ($/kWh)",null,{"$f":"IF(AND(D57>0,D57<=GovtSubsidyDuration),GovtSubsidy,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Yard Waste ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$9*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Food Waste ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$10*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Manure/Sludge Wastes ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$11*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fee - Paper/Cardboard Waste ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),$D$12*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Diesel Purchase Price ($/liter)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),DryADDigestateMarketPrice*((1+InflationRateElectricityFuel)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Process Water ($/m3)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WaterPurchasePrice*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wastewater Treatment ($/m3)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),WastewaterTreatmentCost*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Transportation ($/tonne/km)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),TransportationFee*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residuals Disposal ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),ResidualDisposalFee*((1+InflationRateDisposalGate)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Price ($/ha/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LandLeasePrice*((1+InflationRateGeneral)^(D56-$D$56)),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Managers - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LaborManager*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Operators - Labor Cost ($/person/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),LaborOperator*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),BulkingAgentCost*(1+InflationRateCompostDigestateBulking)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Land Application Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),SolidSoilDigestateLandAppCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Transportation Cost ($/tonne)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan),SolidSoilDigestateTransportCost*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Annual Maintenance Cost ($/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan,D56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND(E57>0,E57<=FacilityLifespan,E56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND(F57>0,F57<=FacilityLifespan,F56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND(G57>0,G57<=FacilityLifespan,G56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND(H57>0,H57<=FacilityLifespan,H56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND(I57>0,I57<=FacilityLifespan,I56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND(J57>0,J57<=FacilityLifespan,J56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND(K57>0,K57<=FacilityLifespan,K56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND(L57>0,L57<=FacilityLifespan,L56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND(M57>0,M57<=FacilityLifespan,M56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND(N57>0,N57<=FacilityLifespan,N56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND(O57>0,O57<=FacilityLifespan,O56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND(P57>0,P57<=FacilityLifespan,P56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND(Q57>0,Q57<=FacilityLifespan,Q56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND(R57>0,R57<=FacilityLifespan,R56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND(S57>0,S57<=FacilityLifespan,S56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND(T57>0,T57<=FacilityLifespan,T56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND(U57>0,U57<=FacilityLifespan,U56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND(V57>0,V57<=FacilityLifespan,V56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND(W57>0,W57<=FacilityLifespan,W56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND(X57>0,X57<=FacilityLifespan,X56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND(Y57>0,Y57<=FacilityLifespan,Y56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND(Z57>0,Z57<=FacilityLifespan,Z56>=MaintenanceBegins),($D$42)*'8-Default Values'!$D$38*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[null,"Annual Insurance Cost ($/year)",null,{"$f":"IF(AND(D57>0,D57<=FacilityLifespan,D56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND(E57>0,E57<=FacilityLifespan,E56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND(F57>0,F57<=FacilityLifespan,F56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND(G57>0,G57<=FacilityLifespan,G56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND(H57>0,H57<=FacilityLifespan,H56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND(I57>0,I57<=FacilityLifespan,I56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND(J57>0,J57<=FacilityLifespan,J56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND(K57>0,K57<=FacilityLifespan,K56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND(L57>0,L57<=FacilityLifespan,L56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND(M57>0,M57<=FacilityLifespan,M56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND(N57>0,N57<=FacilityLifespan,N56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND(O57>0,O57<=FacilityLifespan,O56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND(P57>0,P57<=FacilityLifespan,P56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND(Q57>0,Q57<=FacilityLifespan,Q56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND(R57>0,R57<=FacilityLifespan,R56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND(S57>0,S57<=FacilityLifespan,S56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND(T57>0,T57<=FacilityLifespan,T56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND(U57>0,U57<=FacilityLifespan,U56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND(V57>0,V57<=FacilityLifespan,V56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND(W57>0,W57<=FacilityLifespan,W56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND(X57>0,X57<=FacilityLifespan,X56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND(Y57>0,Y57<=FacilityLifespan,Y56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND(Z57>0,Z57<=FacilityLifespan,Z56>=OperationsStartYear),(($D$42-$D$38)*'8-Default Values'!$D$39)*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[]
[null,"Consolidated Profit and Loss"]
[null,"Electricity Sales ($/year)",null,{"$f":"D76*D86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Government Subsidy ($/year)",null,{"$f":"D93*D76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Heat Sales ($/year)",null,{"$f":"D87*D78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Digestate Sales ($/year)",null,{"$f":"D89*D66","v":0},{"$f":"E89*E66","v":0},{"$f":"F89*F66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Yard Waste ($/year)",null,{"$f":"D59*D94","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Food Waste ($/year)",null,{"$f":"D95*D60","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Manure/Sludge ($/year)",null,{"$f":"D96*D61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gate Fees - Other Waste ($/year)",null,{"$f":"D97*D62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Landfill Disposal Fees ($/year)",null,{"$f":"D91*D72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Avoided Transportation Fees ($/year)",null,{"$f":"(DistanceGeneratorsToLandfill-DistanceGeneratorsToOrganicsFacility)*D92*D72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Land Sale at End of Project Life ($/year)",null,{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",D56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(D56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",E56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(E56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",F56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(F56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",G56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(G56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",H56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(H56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",I56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(I56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",J56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(J56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",K56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(K56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",L56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(L56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",M56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(M56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",N56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(N56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",O56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(O56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",P56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(P56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Q56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Q56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",R56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(R56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",S56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(S56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",T56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(T56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",U56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(U56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",V56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(V56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",W56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(W56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",X56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(X56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Y56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Y56-$D$56),0)","v":0},{"$f":"IF(AND('7-Economic Inputs'!$E$32=\"Purchase\",Z56=OperationsStartYear+FacilityLifespan-1),($D$39)*(1+InflationRateGeneral)^(Z56-$D$56),0)","v":0}]
[null,"Total Revenues ($/year)",null,{"$f":"SUM(D114:D124)","v":0},{"$f":"SUM(E114:E124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Diesel Cost ($/year)",null,{"$f":"(D99*D79)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Electricity Purchased ($/year)",null,{"$f":"D88*'8-Default Values'!$D$18","v":0},{"$f":"E88*'8-Default Values'!$D$18","v":0},{"$f":"F88*'8-Default Values'!$D$18","v":0},{"$f":"G88*'8-Default Values'!$D$18","v":0},{"$f":"H88*'8-Default Values'!$D$18","v":0},{"$f":"I88*'8-Default Values'!$D$18","v":0},{"$f":"J88*'8-Default Values'!$D$18","v":0},{"$f":"K88*'8-Default Values'!$D$18","v":0},{"$f":"L88*'8-Default Values'!$D$18","v":0},{"$f":"M88*'8-Default Values'!$D$18","v":0},{"$f":"N88*'8-Default Values'!$D$18","v":0},{"$f":"O88*'8-Default Values'!$D$18","v":0},{"$f":"P88*'8-Default Values'!$D$18","v":0},{"$f":"Q88*'8-Default Values'!$D$18","v":0},{"$f":"R88*'8-Default Values'!$D$18","v":0},{"$f":"S88*'8-Default Values'!$D$18","v":0},{"$f":"T88*'8-Default Values'!$D$18","v":0},{"$f":"U88*'8-Default Values'!$D$18","v":0},{"$f":"V88*'8-Default Values'!$D$18","v":0},{"$f":"W88*'8-Default Values'!$D$18","v":0},{"$f":"X88*'8-Default Values'!$D$18","v":0},{"$f":"Y88*'8-Default Values'!$D$18","v":0},{"$f":"Z88*'8-Default Values'!$D$18","v":0}]
[null,"Process Water Costs ($/year)",null,{"$f":"D100*D80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Wastewater Treatment Costs ($/year)",null,{"$f":"D101*D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Transportation Cost ($/year)",null,{"$f":"D102*D71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Residual Disposal Cost ($/year)",null,{"$f":"D103*D71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lease Cost ($/year)",null,{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((D104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((E104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((F104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((G104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((H104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((I104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((J104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((K104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((L104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((M104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((N104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((O104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((P104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Q104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((R104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((S104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((T104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((U104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((V104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((W104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((X104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Y104*$D$25)),0)","v":0},{"$f":"IF('7-Economic Inputs'!$E$32=\"Lease\",((Z104*$D$25)),0)","v":0}]
[null,"Labor Cost ($/year)",null,{"$f":"(D105*D82)+(D83*D106)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Bulking Agent Cost ($/year)",null,{"$f":"D68*D107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Land Application Cost ($/year)",null,{"$f":"D108","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Solid Digestate Soil Product Transportation Cost ($/year)",null,{"$f":"D109","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maintenance Costs ($/year)",null,{"$f":"D110","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Insurance Costs ($/year)",null,{"$f":"D111","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Outside Services and Supplies ($/year)",null,{"$f":"SUM(D126:D138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(E126:E138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(F126:F138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(G126:G138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(H126:H138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(I126:I138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(J126:J138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(K126:K138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(L126:L138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(M126:M138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(N126:N138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(O126:O138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(P126:P138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(Q126:Q138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(R126:R138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(S126:S138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(T126:T138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(U126:U138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(V126:V138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(W126:W138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(X126:X138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(Y126:Y138)*'8-Default Values'!$D$40","v":0},{"$f":"SUM(Z126:Z138)*'8-Default Values'!$D$40","v":0}]
[null,"Operating Cost Contingency ($/year)",null,{"$f":"SUM(D126:D139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(E126:E139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(F126:F139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(G126:G139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(H126:H139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(I126:I139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(J126:J139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(K126:K139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(L126:L139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(M126:M139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(N126:N139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(O126:O139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(P126:P139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(Q126:Q139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(R126:R139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(S126:S139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(T126:T139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(U126:U139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(V126:V139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(W126:W139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(X126:X139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(Y126:Y139)*'8-Default Values'!$D$41","v":0},{"$f":"SUM(Z126:Z139)*'8-Default Values'!$D$41","v":0}]
[null,"Cost of Goods Sold",null,{"$f":"SUM(D126:D129)+SUM(D132:D139)+D155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Expenses ($/year)",null,{"$f":"SUM(D126:D140)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total O&M/Tonne of Waste Processed",null,{"$f":"IF(D57>0,D142/(D68+D63),0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Adjusted COGS ($/year)",null,{"$f":"D141","v":0},{"$f":"E141","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Adjusted Expenses ($/year)",null,{"$f":"D142","v":0},{"$f":"E142","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Gross Profit",null,{"$f":"D114+SUM(D116:D121)-D144","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBITDA",null,{"$f":"D125-D145","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation",null,{"$f":"D167","v":0},{"$f":"E167","v":0},{"$f":"F167","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y167","v":0},{"$f":"Z167","v":0}]
[null,"EBIT",null,{"$f":"D147-D148","v":0},{"$f":"E147-E148","v":0},{"$f":"F147-F148","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y147-Y148","v":0},{"$f":"Z147-Z148","v":0}]
[]
[null,"Operating Cash Flow"]
[null,"EBIT",null,{"$f":"D149","v":0},{"$f":"E149","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y149","v":0},{"$f":"Z149","v":0}]
[null,"Taxes",null,{"$f":"IF(D146>0,-D146*TaxPaidGrossProfits,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"EBIAT (After Tax EBIT)",null,{"$f":"D152+D153","v":0},{"$f":"E152+E153","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y152+Y153","v":0},{"$f":"Z152+Z153","v":0}]
[null,"Depreciation",null,{"$f":"D167","v":0},{"$f":"E167","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y167","v":0},{"$f":"Z167","v":0}]
[null,"Operating Cash Flow",null,{"$f":"D154+D155","v":0},{"$f":"E154+E155","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y154+Y155","v":0},{"$f":"Z154+Z155","v":0}]
[null,"Debt Service",null,{"$f":"-D187","v":0},{"$f":"-E187","v":0},{"$f":"-F187","v":0},{"$f":"-G187","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-Y187","v":0},{"$f":"-Z187","v":0}]
[null,"Initial Equity ",null,{"$f":"IF(D56=InvestmentYear,$D$48,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Initial Debt",null,{"$f":"IF(D56=InvestmentYear,$D$47,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Levered Free Cash Flow",null,{"$f":"(-D158)+D156+(-D187)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Capex and Depreciation Schedule"]
[null,"AD Equipment, Infrastructure, and Site Development Investment",null,{"$f":"IF(D40=InvestmentYear,$D$35+$D$34+$D$36+$D$37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation - Infrastructure and Site Development",null,null,{"$f":"IF(AND(E57<=EquipmentCostFactor,E57>0),(SUM($D$164:D164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(F57<=EquipmentCostFactor,F57>0),(SUM($D$164:E164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(G57<=EquipmentCostFactor,G57>0),(SUM($D$164:F164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(H57<=EquipmentCostFactor,H57>0),(SUM($D$164:G164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(I57<=EquipmentCostFactor,I57>0),(SUM($D$164:H164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(J57<=EquipmentCostFactor,J57>0),(SUM($D$164:I164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(K57<=EquipmentCostFactor,K57>0),(SUM($D$164:J164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(L57<=EquipmentCostFactor,L57>0),(SUM($D$164:K164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(M57<=EquipmentCostFactor,M57>0),(SUM($D$164:L164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(N57<=EquipmentCostFactor,N57>0),(SUM($D$164:M164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(O57<=EquipmentCostFactor,O57>0),(SUM($D$164:N164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(P57<=EquipmentCostFactor,P57>0),(SUM($D$164:O164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Q57<=EquipmentCostFactor,Q57>0),(SUM($D$164:P164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(R57<=EquipmentCostFactor,R57>0),(SUM($D$164:Q164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(S57<=EquipmentCostFactor,S57>0),(SUM($D$164:R164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(T57<=EquipmentCostFactor,T57>0),(SUM($D$164:S164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(U57<=EquipmentCostFactor,U57>0),(SUM($D$164:T164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(V57<=EquipmentCostFactor,V57>0),(SUM($D$164:U164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(W57<=EquipmentCostFactor,W57>0),(SUM($D$164:V164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(X57<=EquipmentCostFactor,X57>0),(SUM($D$164:W164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Y57<=EquipmentCostFactor,Y57>0),(SUM($D$164:X164)/EquipmentCostFactor),0)","v":0},{"$f":"IF(AND(Z57<=EquipmentCostFactor,Z57>0),(SUM($D$164:Y164)/EquipmentCostFactor),0)","v":0}]
[null,"Depreciation Initial Investment",null,null,{"$f":"E165","v":0},{"$f":"F165","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Depreciation",null,null,{"$f":"SUM(E166:E166)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Financing"]
[null,"Short-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,$D$49,C174))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)),0,(-IPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)),0,(-PPMT(InterestRateShortTermDebt,D57,TenorShortTermDebt,$D$49)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D171+D172","v":0},{"$f":"E171+E172","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y171+Y172","v":0},{"$f":"Z171+Z172","v":0}]
[null,"EOY Balance",null,{"$f":"D170-D172","v":0},{"$f":"E170-E172","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y170-Y172","v":0},{"$f":"Z170-Z172","v":0}]
[]
[null,"Long-term Debt"]
[null,"BOY Balance",null,{"$f":"IF(D56<OperationsStartYear,0,IF(D56=OperationsStartYear,$D$50,C181))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interest Payment",null,{"$f":"IF(ISERROR(-IPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)),0,(-IPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"IF(ISERROR(-PPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)),0,(-PPMT(InterestRateLongTermDebt,D57,TenorLongTermDebt,$D$50)))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D178+D179","v":0},{"$f":"E178+E179","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y178+Y179","v":0},{"$f":"Z178+Z179","v":0}]
[null,"EOY Balance",null,{"$f":"D177-D179","v":0},{"$f":"E177-E179","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Y177-Y179","v":0},{"$f":"Z177-Z179","v":0}]
[]
[]
[null,"Summary"]
[null,"Interest Payment",null,{"$f":"D171+D178","v":0},{"$f":"E171+E178","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Principal Payment",null,{"$f":"D172+D179","v":0},{"$f":"E172+E179","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Debt Service",null,{"$f":"D173+D180","v":0},{"$f":"E173+E180","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"DO NOT DELETE"]
[null,"Digestate Produced in YR 1 (tonnes/year)",null,{"$f":"IF(D66=0,\"\",D66)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Non-Digestable Yard Waste to Composting in YR 1 (tonnes/year)",null,{"$f":"IF(D67=0,\"\",D67)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Bulking Agent to Composting in YR 1 (tonnes/year)",null,{"$f":"IF(D68=0,\"\",D68)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Waste Diverted from Landfill in YR 1 (tonnes/year)",null,{"$f":"IF(D72=0,\"\",D72)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Net Electricity Produced by AD System (kWh/year)",null,{"$f":"IF(D76=0,\"\",D76)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Electricity Sold (kWh/year)",null,{"$f":"IF(D76=0,\"\",D76)","v":""},{"$f":"IF(E76=0,\"\",E76)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Revenues",null,{"$f":"IF(D125=0,\"\",D125)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Total Expenses",null,{"$f":"IF(D145=0,\"\",D145+D187)","v":""},"","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"12-Tool Assumptions","index":12,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,3,4,3]]}
[]
[null,"Tool Assumptions"]
[]
[null,"Guidance: ",null,"This tab provides a list of additional assumptions used throughout the model, and their sources."]
[]
[]
[null,null,null,"Assumption",null,"Source"]
[null,1,null,"Revenues and expenses are projected over the same 20-year operating period for all technologies. The tool can tolerate construction periods greater than 1 and less than 3 years. "]
[null,2,null,"AD scenarios produce electricity and heat with a CHP system. Alternative energy/fuel products such as heat and transportation fuels are also proven outputs but are not considered a part of this tool."]
[null,3,null,"When electing to purchase land, it is assumed that the land is financed along with the facility, but is sold at the end of the project life. The value of the land is inflated at the general rate of inflation."]
[null,4,null,"Short-term debt is used to finance the purchase of composting equipment. Long-term debt is used to finance composting and AD site development and infrastructure costs, land purchases, and AD equipment costs. When the debt tenor specified by the user exceeds the remaining life of the project, the model shortens the tenor and defaults to the remaining life of the project."]
[null,6,null,"Interest does not accrue during the construction period. Debt service begins in YR 1 of operations."]
[null,7,null,"Capex calculated in the investment year will always reflect dollars in the year that the construction cost and consumer price indices are set to. Indices must be updated annually. "]
[null,8,null,"Only yard waste is sent to composting without forced aeration. All organics are sent to composting with forced aeration. Yard waste bypasses the wet anaerobic digesters scenarios (both high tech and low tech), but can be introduced into the composting process, should the user elect to compost digestate or produce yard waste compost."]
[null,9,null,"Maintenance and insurance expenses are calculated as a percentage of capex prior to contingencies being added in."]
[null,10,null,"Operating and performance assumptions for WET AD scenarios include fuel consumption, net electricity and heat outputs, labor requirements, maintenance and insurance costs, digestate yields, water requirements, and wastewater generation."]
[null,11,null,"Wet AD scenarios: Yard waste bypasses the digestion system and can be introduced to the composting process IF the user elects to produce compost from the digestate or yard waste compost."]
[null,12,null,"Dry AD scenarios: Yard waste enters the system in a quantity equal to 30% of the total annual incoming feedstock. Excess yard waste can be used to produce compost from digestate, yard waste compost, mulch, or given away. When available yard waste does not equal 30% of the total available feedstock, 100% of the yard waste enters the digestion process."]
[null,13,null,"For some small facilities it may be possible for employee labor costs to be shared with other cost centers for employees to be part-time. The model conservatively rounds up the number of employees needed and assumes the cost of the full-time employee is borne by the facility."]
[null,14,null,"Scenarios require a minimum waste throughput of: Composting = 2,000 TPY, High Tech Wet AD = 20,000 TPY, Dry AD = 5,000 TPY, and Low Tech Wet AD = 10,000 TPY. For Wet AD scenarios, the total of food, sludge, manure, and paper wastes must total the minimum throughput. "]

{"sheet":"13-Sources","index":13,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sources"]
[]
[null,null,"Source"]
[null,1,"Angelonidi, Eleni and Stephen R. Smith. \"A Comparison of Wet and Dry Anaerobic Digestion Processes for the Treatment of Municipal Solid Waste and Food Waste.\" Water and Environment Journal 29, 2015, pp. 549-557."]
[null,{"$f":"B5+1","v":2},"Frost, Peter and Stephen Gilkinson. \"FIRST 18 MONTH PERFORMANCE SUMMARY FOR ANAEROBIC DIGESTION OF DAIRY COW SLURRY AT AFBI HILLSBOROUGH.\" Agri-Food and Biosciences Institute. August 2010. "]
[null,{"$f":"B6+1","v":3},"Bioferm Energy Systems. \"Anaerobic Digestion FAQ\". Bioferm Energy Systems. n.d. Accssed August 2014."]
[null,4,"Blair, Charlie. \"Energy from Waste Potential in Scotland.\" January 2010.  https://www.webarchive.org.uk/wayback/archive/3000/https://www.gov.scot/resource/doc/311011/0098129.pdf. Accessed December 2014."]
[null,5,"Chastain, John P. and James J. Camberato. \"Dairy Manure Production and Nutrient Content.\" Confined Animal Manure Manager Certification Program Manual: Dairy Version. 2004."]
[null,6,"Crowe, Matt, Kirsty Nolan, Caitríona Collins, Gerry Carty, Brian Donlon, Merete Kristoffersen, Morten Brøgger, Morten Carlsbæk, Reto Michael Hummelshøj, and Claus Dahl Thomsen (European Topic Centre on Waste). \"Biodegradable Municipal Waste\nManagement in Europe Part 3: Technology and Market Issues.\" January 2002. https://www.eea.europa.eu/publications/topic_report_2001_15_Part3. Accessed July 2014."]
[null,{"$f":"B10+1","v":7},"Endeco Spa. \"Anaerobic Processing Principles & Technologies.\" February 2017. https://www.endeco.it/wp/wp-content/uploads/2017/02/CatalogueAnaerobicDigestionPrinciples.pdf. Accessed June 2021."]
[null,{"$f":"B11+1","v":8},"Eunomia Research & Consulting. \"Annexes.\" Costs for Municipal Waste Management in the EU. European Commission, 2002. Web."]
[null,9,"Fachagentur Nachwachsende Rohstoffe (FNR). Biogas: An Introduction. 2013. https://www.fnr.de/fileadmin/Projekte/2021/Mediathek/brosch.biogas-2013-en-web-pdf.pdf."]
[null,10,"Goldstein, Nora. \"High Solids Anaerobic Digestion and Composting in San Jose.\" Biocycle Magazine, March/April 2014, https://www.biocycle.net/2014/03/28/high-solids-anaerobic-digestion-composting-in-san-jose/. Accessed October 2014."]
[null,11,"Italian Composting and Biogas Association. Biogas e Compost: da rifiuti organici selezionati. October 2011. https://www.compost.it/attachments/604_CIC_biogas_e_compost_2011_definitivo.pdf."]
[null,12,"Italian Composting and Biogas Association. July 2014."]
[null,13,"Lansing, Stephanie, Raúl Botero Botero, and Jay F. Martin. \"Waste treatment and biogas quality in small-scale agricultural digesters.\" Bioresource Technology, 99, 13, 2008, pp. 5881-5890."]
[null,14,"Levis, James W. and Morton A. Barlaz (North Carolina State University). Anaerobic Digestion Process Model Documentation. September 2013. Accessed September 2014."]
[null,15,"Levis, James W. and Morton A. Barlaz (North Carolina State University). Composting Process Model Documentation. November 2013. Accessed September 2014."]
[null,16,"Liebrand, Carolyn B., and K. Charles Ling. Cooperative Approaches for Implementation of Dairy Manure Digesters. USDA Rural Development Research Report 217, 2009. https://naldc.nal.usda.gov/catalog/35107."]
[null,17,"Logan, Mohanakrishnan and Chettiyappan Visvanathan. \"Management strategies for anaerobic digestate of organic fraction of municipal solid waste: Current status and future prospects.\" Waste Management & Research: The Journal for a Sustainability Circular Economy 37, 1, 2019, pp. 27-39. "]
[null,18,"Mata-Alvarez, J. Biomethanization of the organic fraction of municipal solid wastes. IWA Publishing. 2003. Accessed October 2014."]
[null,19,"Midwest Plan Service. Livestock Waste Facilities Handbook.1985."]
[null,20,"Moriarty, Kristi. \"Feasibility Study of Anaerobic Digestion of Food Waste in St. Bernard, Louisiana: A Study Prepared in Partnership with the Environmental Protection Agency for the RE-Powering America’s Land Initiative: Siting Renewable Energy on Potentially Contaminated Land and Mine Sites.\" National Renewable Energy Laboratory, 2013. Accessed Oct 2014."]
[null,21,"NNFC. The Official Information Portal on Anaerobic Digestion. n.d. https://www.biogas-info.co.uk/about/digestate/#:~:text=Digestate%20is%20a%20nutrient%2Drich,was%20fed%20into%20the%20digester. Accessed June 2021."]
[null,22,"Pier for California Energy Commission Report. \"Characterization of Food and Green Wastes As Feedstock for Anaerobic Digesters.\" July 2005. Accessed November 2014."]
[null,23,"Rigby, Hannah and Stephen R. Smith (WRAP). \"New Markets for Digestate from Anaerobic Digestion.\" August 2011. https://archive.wrap.org.uk/sites/files/wrap/New_Markets_for_AD_WRAP_format_Final_v2.c6779ccd.11341.pdf. Accessed November 2014."]
[null,24,"Rogroff, Clark. Rogroff, Clark. “TFC Recycling: Going the Extra Mile.” Waste Advantage Magazine 5, 7, 2014, pp. 21-25. https://www.scsengineers.com/wp-content/uploads/2015/03/Rogoff_Clark_Anaerobic_Digestion_WASTEADVANTAGE.pdf. Accessed November 2014."]
[null,25,"Rynk, R., Maarten va de Kamp, George B. Willson, Mark E. Singley, Tom L. Richard, John J. Kolega, Francis R. Gouin, Lucien Laliberty, Jr., David Kay, Dennis W. Murphy, Harry A.J. Hotink, and William F. Brinton. On-Farm Composting Handbook. Ithaca: Northeast Regional Agricultural Engineering Service, 1992. https://campus.extension.org/pluginfile.php/48384/course/section/7167/NRAES%20FarmCompost%20manual%201992.pdf. Accessed October 2014."]
[null,26,"SmartFerm for Zero Waste Energy. California. "]
[null,27,"Sniffer (2010). \"Review of Available Literature on the Carbon and Nitrogen Contents and C:N Ratios of Composting Input Feedstock.\" Accessed September 2014."]
[null,28,"Swedish Gas Center. Basic Data on Biogas - Second Edition. 2014. ISBN: 978-91-85207-10-7. "]
[null,29,"Tolvik Consulting. The Economics of Anaerobic Digestion of Source Segregated Organic Wastes in the UK. Edition 2. 2010. Accessed September 2014."]
[null,30,"University of Minnesota. \"Anaerobic Digester Economics\" Spreadsheet. 2009. "]
[null,31,"US Environmental Protection Agency. \"The Benefits of Anaerobic Digestion of Food Waste At Wastewater Treatment Facilities.\" n.d. https://archive.epa.gov/region9/organics/web/pdf/why-anaerobic-digestion.pdf. "]
[null,32,"Wheeler, PA and L de Rome.  Waste Pre-Treatment: A Review. R&D Technical Report PI-344/TR. Bristol: Environment Agency, 2002."]
[null,33,"World Bank. PPP conversion factor, private consumption (LCU per international $). n.d. https://data.worldbank.org/indicator/PA.NUS.PRVT.PP. Accessed October 2017."]
[null,34,"WRAP. Summary Report – Material Bulk Densities, Report prepared by Resource Futures. 2009. https://silo.tips/download/material-bulk-densities. Accessed June 2015."]