{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Welcome","Tutorial","Input-output","Cash flow","Cost Distribution","Yearly Cash flow","Accumulated cash flow","Planting and Est. submodel","Stand Maint. Submodel","Harvest submodel","Trans. submodel","Storage submodel","Biomass harvested submodel"],"not_rendered":{"charts":5,"images":4,"macros":1,"external_links":1,"defined_names":0,"comments":6,"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":"Welcome","index":0,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[4,0,4,3]]}
[]
[null,"Welcome to the "]
[]
["Switchgrass Production Decision Tool"]
["Project Name Here"]
[null,null,null,null,null,"Department of Agricultural & Resource Economics"]
[null,null,null,null,null,"The University of Tennessee"]
[]
[null,null,null,null,null,"Project Size",50,"acres"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Click on the buttons below for the tutorial"]
[null,null,null,null,null,null,null,"or to begin the worksheet"]
[]
[null,null,null,null,null,null,null,"Tutorial"]
[]
[null,null,null,null,null,null,null,"Begin"]
[]
[]
[]
[]
[]
[]
[]
["Developed by Josh Qualls, former Graduate Research Assistant, Department of Agricultural and Resource Economics,  The University of Tennessee."]

{"sheet":"Tutorial","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Tutorial"]
[]
[]
[null,"Getting Started"]
[]
[null,"The first sheet that will come up when the program is loaded is the welcome sheet. In this sheet, the user will   "]
[null,"be asked the size of their project. This value will then transfer throughout the document and will set the foundation for "]
[null,"the values found in the program. After this value is recorded, the user will see two macro buttons. The \"tutorial\" button"]
[null,"will take them to this sheet for a brief introduction on how to operate the program and the \"input-output\" macro button"]
[null,"will take them to the input-output sheet, which is the heart of the program."]
[]
[null,"Input-output Sheet"]
[]
[null,"This sheet allows the user to insert general data figures and to see the net present value of the project in "]
[null,"optimistic terms (+10% revenue, -10% costs) realistic terms, and pessimistic terms (-10% revenue, +10% costs)."]
[null,"It also provides the user with the internal rate of return (IRR). At the bottom of the Input-output sheet, there are "]
[null,"seven macro button that will take the user to each worksheet in the program and present them with the graphs based "]
[null,"off of the data generated in the program."]
[]
[null,"Program limitations"]
[]
[null,"This program assumes that each stand of switchgrass wil have a useful life of 10 years and is not set up to accommodate"]
[null,"projects that last longer. "]

{"sheet":"Input-output","index":2,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,5],[12,9,12,10],[22,1,22,4],[23,1,23,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Input and Output"]
[]
[null,"Input data",null,null,null,null,null,null,null,"Output data"]
[]
[null,"General Data",null,null,null,null,null,null,null,"Financial analysis tools"]
[null,"interest rate","%",3.4700000000000002E-2,null,null,null,null,null,"Net Present Value, expected",null,null,"$",{"$f":"NPV(D7,'Cash flow'!C57:L57)","v":10051.811235831739}]
[null,"Project size","acres",{"$f":"Welcome!$G$9","v":50},null,null,null,null,null,"Net Present Value, optimistic",null,null,"$",{"$f":"NPV(D7,'Cash flow'!C61:L61)","v":26157.051154605993}]
[null,"Project life","yrs",10,10,null,null,null,null,"Net Present Value, pessimistic",null,null,"$",{"$f":"NPV(D7,'Cash flow'!C65:L65)","v":-6053.42868294249}]
[null,"Land costs (tax, lease) and insurance","$/acre/yr",0,0,null,null,null,null,"Internal Rate of Return",null,null,null,{"$f":"IRR('Cash flow'!C22:L22)","v":0.12373676313786364}]
[null,"Internal administration costs","$/acre/yr",0,0]
[null,"Acreage Incentive payments","$/acre/yr",0,0]
[null,"Total years of acreage incentive payment","yrs",0,0,null,null,null,null,"Production costs, revenues, and earnings"]
[null,"Biomass price at plant gate","$/ton",75,75,null,null,null,null,"Average costs per acre",null,null,null,{"$f":"(SUM('Cash flow'!C13:L13)+SUM('Cash flow'!C20:L20))/10","v":360.99550419642867}]
[null,null,null,null,null,null,null,null,null,"Average (Gross) revenue per acre",null,null,null,{"$f":"SUM('Cash flow'!C17:L17)/10","v":394.26750000000004}]
[null,null,null,null,null,null,null,null,null,"Average (net) earning per acre",null,null,null,{"$f":"N15-N14","v":33.271995803571372}]
[null,"Startup loans",null,null,null,null,null,null,null,"Average revenue per ton",null,null,null,{"$f":"(SUM('Cash flow'!C52:L52))/SUM('Biomass harvested submodel'!C12:L12)","v":74.25}]
[null,"Available equity","$",0,null,null,null,null,null,"Average costs per ton",null,null,null,{"$f":"(SUM('Cash flow'!C48:L48)+SUM('Cash flow'!C55:L55))/SUM('Biomass harvested submodel'!C12:L12)","v":67.984087419289764}]
[null,"Loan amount",null,0,null,null,null,null,null,"Average (net) earning per ton",null,null,null,{"$f":"D14-N18","v":7.0159125807102356}]
[null,"Loan interest rate","%",0]
[]
[]
[null,"Yellow cells: insert numbers, insert \"0\" if not applicable"]
[null,"Grey cells: output from previous inputs"]

{"sheet":"Cash flow","index":3,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[1,1,1,6],[36,1,36,6],[71,2,71,9]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Cash Flow diagram (per Acre)"]
[]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Expenditures"]
[null,"land costs and insurance",{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0},{"$f":"'Input-output'!D10","v":0}]
[null,"Administration cost",{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0},{"$f":"'Input-output'!D11","v":0}]
[null,"Planting and establishment cost",{"$f":"'Planting and Est. submodel'!J65","v":175.52799999999999},{"$f":"C8*0.2","v":35.105600000000003},0,0,0,0,0,0,0,0]
[null,"Storage Cost",{"$f":"'Storage submodel'!C84/'Input-output'!$D$8","v":62.449062499999997},{"$f":"'Storage submodel'!D84/'Input-output'!$D$8","v":44.0486875},{"$f":"'Storage submodel'!E84/'Input-output'!$D$8","v":52.639187499999998},{"$f":"'Storage submodel'!F84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!G84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!H84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!I84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!J84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!K84/'Input-output'!$D$8","v":22.41},{"$f":"'Storage submodel'!L84/'Input-output'!$D$8","v":22.41}]
[null,"Stand maintenance cost",0,{"$f":"'Stand Maint. Submodel'!H21","v":178.27499999999998},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001},{"$f":"'Stand Maint. Submodel'!$H$23","v":157.27500000000001}]
[null,"Harvest Cost",{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"'Harvest submodel'!L44","v":136.17169999999999}]
[null,"Transportation Cost",{"$f":"'Trans. submodel'!D30","v":7.5173541666666663},{"$f":"'Trans. submodel'!D39","v":19.867293154761906},{"$f":"'Trans. submodel'!D48","v":32.217232142857142},{"$f":"'Trans. submodel'!D57","v":32.217232142857142},{"$f":"'Trans. submodel'!D66","v":32.217232142857142},{"$f":"'Trans. submodel'!L30","v":32.217232142857142},{"$f":"'Trans. submodel'!L39","v":32.217232142857142},{"$f":"'Trans. submodel'!L48","v":32.217232142857142},{"$f":"'Trans. submodel'!L57","v":32.217232142857142},{"$f":"'Trans. submodel'!L66","v":32.217232142857142}]
[null,"Total Expenditues",{"$f":"SUM(C6:C12)","v":381.66611666666665},413.46828065476188,378.30311964285715,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713]
[null,"Revenues"]
[null,"Acreage incentive Payments",{"$f":"IF('Input-output'!D13-'Cash flow'!C4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!D4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!E4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!F4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!G4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!H4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!I4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!J4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!K4>=1,'Input-output'!D12,0)","v":0},{"$f":"IF('Input-output'!D13-'Cash flow'!L4>=1,'Input-output'!D12,0)","v":0}]
[null,"Biomass",{"$f":"('Storage submodel'!C80/'Input-output'!D8)*'Input-output'!D14","v":103.94999999999999},{"$f":"'Storage submodel'!D80/'Input-output'!D8*'Input-output'!D14","v":274.72500000000002},{"$f":"'Storage submodel'!E80/'Input-output'!D8*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!F80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!G80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!H80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!I80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!J80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!K80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006},{"$f":"('Storage submodel'!L80/'Input-output'!D8)*'Input-output'!D14","v":445.50000000000006}]
[null,"Total Revenue",{"$f":"SUM(C15:C16)","v":103.94999999999999},{"$f":"SUM(D15:D16)","v":274.72500000000002},445.50000000000006,445.50000000000006,445.50000000000006,445.50000000000006,445.50000000000006,445.50000000000006,445.50000000000006,445.50000000000006]
[null,"Total Profit 1",{"$f":"C17-C13","v":-277.71611666666666},{"$f":"D17-D13","v":-138.74328065476186},67.196880357142902,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925]
[null,"Other costs"]
[null,"Loan Payments",{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)/J36","v":0}]
[null,"Total Costs",{"$f":" C20+C13","v":381.66611666666665},{"$f":" D20+D13","v":413.46828065476188},378.30311964285715,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713,348.07393214285713]
[null,"Total Profit 2",{"$f":"C18-C20","v":-277.71611666666666},{"$f":"D18-D20","v":-138.74328065476186},67.196880357142902,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925,97.426067857142925]
[null,"Total 2 per ton of biomass produced",{"$f":"C22/'Biomass harvested submodel'!C8","v":-198.36865476190476},{"$f":"D22/'Biomass harvested submodel'!D8","v":-37.498183960746445},{"$f":"E22/'Biomass harvested submodel'!E8","v":11.199480059523816},{"$f":"F22/'Biomass harvested submodel'!F8","v":16.237677976190486},{"$f":"G22/'Biomass harvested submodel'!G8","v":16.237677976190486},{"$f":"H22/'Biomass harvested submodel'!H8","v":16.237677976190486},{"$f":"I22/'Biomass harvested submodel'!I8","v":16.237677976190486},{"$f":"J22/'Biomass harvested submodel'!J8","v":16.237677976190486},{"$f":"K22/'Biomass harvested submodel'!K8","v":16.237677976190486},{"$f":"L22/'Biomass harvested submodel'!L8","v":16.237677976190486}]
[null,"Total Profit 2 discounted",{"$f":"C22/(1+('Input-output'!$D$7))^'Cash flow'!C4-1","v":-269.40254824264684},{"$f":"D22/(1+('Input-output'!$D$7))^'Cash flow'!D4-1","v":-130.59345284657175},{"$f":"E22/(1+('Input-output'!$D$7))^'Cash flow'!E4-1","v":59.660469027843156},{"$f":"F22/(1+('Input-output'!$D$7))^'Cash flow'!F4-1","v":83.999697143130888},{"$f":"G22/(1+('Input-output'!$D$7))^'Cash flow'!G4-1","v":81.149122589282783},{"$f":"H22/(1+('Input-output'!$D$7))^'Cash flow'!H4-1","v":78.394145732369552},{"$f":"I22/(1+('Input-output'!$D$7))^'Cash flow'!I4-1","v":75.731560580235382},{"$f":"J22/(1+('Input-output'!$D$7))^'Cash flow'!J4-1","v":73.158268657809401},{"$f":"K22/(1+('Input-output'!$D$7))^'Cash flow'!K4-1","v":70.671275401381465},{"$f":"L22/(1+('Input-output'!$D$7))^'Cash flow'!L4-1","v":68.267686673800583}]
[null,"Total Profit 2 accumulated",{"$f":"C24","v":-269.40254824264684},{"$f":"C25+D22","v":-408.14582889740871},{"$f":"D25+E22","v":-340.9489485402658},-243.52288068312288,-146.09681282597995,-48.670744968837027,48.755322888305898,146.18139074544882,243.60745860259175,341.03352645973467]
[null,"Total Profit 2 optimistic",{"$f":"((C17*1.1)-(C13+C20)*0.9)","v":-229.154505},{"$f":"((D17*1.1)-(D13+D20)*0.9)","v":-69.923952589285648},149.5771923214287,176.78346107142869,176.78346107142869,176.78346107142869,176.78346107142869,176.78346107142869,176.78346107142869,176.78346107142869]
[null,"Total Profit 2 optimistic, discounted",{"$f":"C26/(1+('Input-output'!$D$7))^'Cash flow'!C4-1","v":-222.46951290229052},{"$f":"D26/(1+('Input-output'!$D$7))^'Cash flow'!D4-1","v":-66.312614852130494},{"$f":"E26/(1+('Input-output'!$D$7))^'Cash flow'!E4-1","v":134.02743868259469},{"$f":"F26/(1+('Input-output'!$D$7))^'Cash flow'!F4-1","v":153.23531896021416},{"$f":"G26/(1+('Input-output'!$D$7))^'Cash flow'!G4-1","v":148.06283846546262},{"$f":"H26/(1+('Input-output'!$D$7))^'Cash flow'!H4-1","v":143.06382378028664},{"$f":"I26/(1+('Input-output'!$D$7))^'Cash flow'!I4-1","v":138.23245750486774},{"$f":"J26/(1+('Input-output'!$D$7))^'Cash flow'!J4-1","v":133.56311733339879},{"$f":"K26/(1+('Input-output'!$D$7))^'Cash flow'!K4-1","v":129.0503695113548},{"$f":"L26/(1+('Input-output'!$D$7))^'Cash flow'!L4-1","v":124.68896251218207}]
[]
[null,"Total Profit 2 optimistic, accumlated",{"$f":"C26","v":-229.154505},{"$f":"C29+D26","v":-299.07845758928568},{"$f":"D29+E26","v":-149.50126526785698},27.28219580357171,204.0656568750004,380.84911794642909,557.63257901785778,734.41604008928653,911.19950116071527,1087.982962232144]
[null,"Total Profit 2 Pessimistic",{"$f":"((C17*0.9)-(C13+C20)*1.1)","v":-326.27772833333336},{"$f":"((D17*0.9)-(D13+D20)*1.1)","v":-207.5626087202381},-15.183431607142836,18.068674642857161,18.068674642857161,18.068674642857161,18.068674642857161,18.068674642857161,18.068674642857161,18.068674642857161]
[null,"Total Profit 2 Pessimistic, discounted",{"$f":"C30/(1+('Input-output'!$D$7))^'Cash flow'!C4-1","v":-316.33558358300314},{"$f":"D30/(1+('Input-output'!$D$7))^'Cash flow'!D4-1","v":-194.87429084101305},{"$f":"E30/(1+('Input-output'!$D$7))^'Cash flow'!E4-1","v":-14.706500626908324},{"$f":"F30/(1+('Input-output'!$D$7))^'Cash flow'!F4-1","v":14.764075326047614},{"$f":"G30/(1+('Input-output'!$D$7))^'Cash flow'!G4-1","v":14.235406713102943},{"$f":"H30/(1+('Input-output'!$D$7))^'Cash flow'!H4-1","v":13.724467684452442},{"$f":"I30/(1+('Input-output'!$D$7))^'Cash flow'!I4-1","v":13.230663655603017},{"$f":"J30/(1+('Input-output'!$D$7))^'Cash flow'!J4-1","v":12.753419982219983},{"$f":"K30/(1+('Input-output'!$D$7))^'Cash flow'!K4-1","v":12.292181291408124},{"$f":"L30/(1+('Input-output'!$D$7))^'Cash flow'!L4-1","v":11.84641083541908}]
[]
[null,"Total Profit 2 Pessimistic, Accumulated",{"$f":"C30","v":-326.27772833333336},{"$f":"C33+D30","v":-533.84033705357149},{"$f":"D33+E30","v":-549.02376866071427},-530.95509401785716,-512.88641937500006,-494.8177447321429,-476.74907008928574,-458.68039544642858,-440.61172080357142,-422.54304616071425]
[]
[]
[null,null,null,null,null,null,null,null,"Acres",{"$f":"'Input-output'!D8","v":50}]
[null,"Cash Flow diagram (total)"]
[]
[null,"Year",0,1,2,3,4,5,6,7,8,9]
[null,"Expenditures"]
[null,"land costs and insurance",{"$f":"'Input-output'!D10*'Input-output'!D8","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0},{"$f":"'Input-output'!D10*J36","v":0}]
[null,"Administration cost",{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0},{"$f":"'Input-output'!D11*J36","v":0}]
[null,"Planting and establishment cost",{"$f":"'Planting and Est. submodel'!J65*J36","v":8776.4},{"$f":"C43*0.2","v":1755.28},0,0,0,0,0,0,0,0]
[null,"Storage Cost",{"$f":"'Storage submodel'!C84","v":3122.453125},{"$f":"'Storage submodel'!D84","v":2202.4343749999998},{"$f":"'Storage submodel'!E84","v":2631.9593749999999},{"$f":"'Storage submodel'!F84","v":1120.5},{"$f":"'Storage submodel'!G84","v":1120.5},{"$f":"'Storage submodel'!H84","v":1120.5},{"$f":"'Storage submodel'!I84","v":1120.5},{"$f":"'Storage submodel'!J84","v":1120.5},{"$f":"'Storage submodel'!K84","v":1120.5},{"$f":"'Storage submodel'!L84","v":1120.5}]
[null,"Stand maintenance cost",0,{"$f":"'Stand Maint. Submodel'!H21*J36","v":8913.7499999999982},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75},{"$f":"'Stand Maint. Submodel'!$H$23*$J$36","v":7863.75}]
[null,"Harvest Cost",{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991},{"$f":"'Harvest submodel'!L44*J36","v":6808.5849999999991}]
[null,"Transportation Cost",{"$f":"'Trans. submodel'!D30*J36","v":375.86770833333333},{"$f":"'Trans. submodel'!D39*J36","v":993.36465773809527},{"$f":"'Trans. submodel'!D48*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!D57*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!D66*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!L30*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!L39*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!L48*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!L57*J36","v":1610.8616071428571},{"$f":"'Trans. submodel'!L66*J36","v":1610.8616071428571}]
[null,"Total Expenditures",{"$f":"SUM(C41:C47)","v":19083.305833333336},20673.414032738092,18915.155982142856,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858]
[null,"Revenues"]
[null,"Acreage incentive Payments",{"$f":"C15*J36","v":0},{"$f":"D15*J36","v":0},{"$f":"E15*J36","v":0},{"$f":"F15*J36","v":0},{"$f":"G15*J36","v":0},{"$f":"H15*J36","v":0},{"$f":"I15*J36","v":0},{"$f":"J15*J36","v":0},{"$f":"K15*J36","v":0},{"$f":"L15*J36","v":0}]
[null,"Biomass",{"$f":"(('Storage submodel'!C80/'Input-output'!D8)*'Input-output'!D14)*J36","v":5197.4999999999991},{"$f":"(('Storage submodel'!D80/'Input-output'!D8)*'Input-output'!D14)*J36","v":13736.250000000002},{"$f":"(('Storage submodel'!E80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!F80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!G80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!H80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!I80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!J80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!K80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004},{"$f":"(('Storage submodel'!L80/'Input-output'!D8)*'Input-output'!D14)*J36","v":22275.000000000004}]
[null,"Total Revenues",{"$f":"SUM(C50:C51)","v":5197.4999999999991},{"$f":"SUM(D50:D51)","v":13736.250000000002},22275.000000000004,22275.000000000004,22275.000000000004,22275.000000000004,22275.000000000004,22275.000000000004,22275.000000000004,22275.000000000004]
[null,"Total 1",{"$f":"C52-C48","v":-13885.805833333336},-6937.1640327380901,3359.8440178571473,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458]
[null,"Other costs"]
[null,"Loan Payments",{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0},{"$f":"-PMT('Input-output'!D20,'Input-output'!D9,'Input-output'!D19)","v":0}]
[null,"Total Costs",{"$f":"C48+C55","v":19083.305833333336},{"$f":"D48+D55","v":20673.414032738092},18915.155982142856,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858,17403.696607142858]
[null,"Total 2",{"$f":"C53-C55","v":-13885.805833333336},{"$f":"D53-D55","v":-6937.1640327380901},3359.8440178571473,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458,4871.3033928571458]
[null,"Total 2 per ton of biomass produced",{"$f":"C57/'Biomass harvested submodel'!C12","v":-198.36865476190479},{"$f":"D57/'Biomass harvested submodel'!D12","v":-37.498183960746431},{"$f":"E57/'Biomass harvested submodel'!E12","v":11.199480059523824},{"$f":"F57/'Biomass harvested submodel'!F12","v":16.237677976190486},{"$f":"G57/'Biomass harvested submodel'!G12","v":16.237677976190486},{"$f":"H57/'Biomass harvested submodel'!H12","v":16.237677976190486},{"$f":"I57/'Biomass harvested submodel'!I12","v":16.237677976190486},{"$f":"J57/'Biomass harvested submodel'!J12","v":16.237677976190486},{"$f":"K57/'Biomass harvested submodel'!K12","v":16.237677976190486},{"$f":"L57/'Biomass harvested submodel'!L12","v":16.237677976190486}]
[null,"Total 2 discounted",{"$f":"C57/(1+('Input-output'!D7))^'Cash flow'!C39","v":-13885.805833333336},{"$f":"D57/(1+('Input-output'!D7))^'Cash flow'!D39","v":-6704.5172830173869},{"$f":"E57/(1+('Input-output'!D7))^'Cash flow'!E39","v":3138.2693651554678},{"$f":"F57/(1+('Input-output'!D7))^'Cash flow'!F39","v":4397.4593316998762},{"$f":"G57/(1+('Input-output'!D7))^'Cash flow'!G39","v":4249.9848571565444},{"$f":"H57/(1+('Input-output'!D7))^'Cash flow'!H39","v":4107.456129464138},{"$f":"I57/(1+('Input-output'!D7))^'Cash flow'!I39","v":3969.7072866184772},{"$f":"J57/(1+('Input-output'!D7))^'Cash flow'!J39","v":3836.5780290117686},{"$f":"K57/(1+('Input-output'!D7))^'Cash flow'!K39","v":3707.9134328904693},{"$f":"L57/(1+('Input-output'!D7))^'Cash flow'!L39","v":3583.5637700690727}]
[null,"Total 2 accumulated",{"$f":"C59","v":-13885.805833333336},{"$f":"C60+D57","v":-20822.969866071428},{"$f":"D60+E57","v":-17463.12584821428},-12591.822455357134,-7720.5190624999886,-2849.2156696428428,2022.087723214303,6893.3911160714488,11764.694508928595,16635.99790178574]
[null,"Total 2 optimistic",{"$f":"(C50+C51*1.1)-C56","v":-13366.055833333336},{"$f":"(D50+D51*1.1)-D56","v":-5563.5390327380883},{"$f":"(E50+E51*1.1)-E56","v":5587.3440178571509},{"$f":"(F50+F51*1.1)-F56","v":7098.8033928571494},7098.8033928571494,7098.8033928571494,7098.8033928571494,7098.8033928571494,7098.8033928571494,7098.8033928571494]
[null,"Total 2 optimistic, discounted",{"$f":"C61/(1+('Input-output'!D7))^'Cash flow'!C39","v":-13366.055833333336},{"$f":"D61/(1+('Input-output'!D7))^'Cash flow'!D39","v":-5376.9585703470457},{"$f":"E61/(1+('Input-output'!D7))^'Cash flow'!E39","v":5218.870420957528},{"$f":"F61/(1+('Input-output'!D7))^'Cash flow'!F39","v":6408.2847456382742},{"$f":"G61/(1+('Input-output'!D7))^'Cash flow'!G39","v":6193.374645441455},{"$f":"H61/(1+('Input-output'!D7))^'Cash flow'!H39","v":5985.6718328418428},{"$f":"I61/(1+('Input-output'!D7))^'Cash flow'!I39","v":5784.9346021473302},{"$f":"J61/(1+('Input-output'!D7))^'Cash flow'!J39","v":5590.929353578168},{"$f":"K61/(1+('Input-output'!D7))^'Cash flow'!K39","v":5403.4303214247302},{"$f":"L61/(1+('Input-output'!D7))^'Cash flow'!L39","v":5222.2193113218618}]
[]
[null,"Total 2 optimistic, accumlated",{"$f":"C61","v":-13366.055833333336},{"$f":"C64+D61","v":-18929.594866071424},{"$f":"D64+E61","v":-13342.250848214273},-6243.4474553571235,855.3559375000259,7954.1593303571753,15052.962723214325,22151.766116071474,29250.569508928624,36349.372901785769]
[null,"Total 2 Pessimistic",{"$f":"(C50+C51*0.9)-C56","v":-14405.555833333336},{"$f":"(D50+D51*0.9)-D56","v":-8310.7890327380901},1132.3440178571473,2643.8033928571458,2643.8033928571458,2643.8033928571458,2643.8033928571458,2643.8033928571458,2643.8033928571458,2643.8033928571458]
[null,"Total 2 Pessimistic, discounted",{"$f":"C65/(1+('Input-output'!D7))^'Cash flow'!C39","v":-14405.555833333336},{"$f":"D65/(1+('Input-output'!D7))^'Cash flow'!D39","v":-8032.0759956877264},{"$f":"E65/(1+('Input-output'!D7))^'Cash flow'!E39","v":1057.6683093534111},{"$f":"F65/(1+('Input-output'!D7))^'Cash flow'!F39","v":2386.6339177614823},{"$f":"G65/(1+('Input-output'!D7))^'Cash flow'!G39","v":2306.5950688716362},{"$f":"H65/(1+('Input-output'!D7))^'Cash flow'!H39","v":2229.2404260864369},{"$f":"I65/(1+('Input-output'!D7))^'Cash flow'!I39","v":2154.4799710896268},{"$f":"J65/(1+('Input-output'!D7))^'Cash flow'!J39","v":2082.226704445372},{"$f":"K65/(1+('Input-output'!D7))^'Cash flow'!K39","v":2012.3965443562117},{"$f":"L65/(1+('Input-output'!D7))^'Cash flow'!L39","v":1944.9082288162867}]
[]
[null,"Total 2 Pessimistic, Accumulated",{"$f":"C65","v":-14405.555833333336},{"$f":"C68+D65","v":-22716.344866071428},{"$f":"D68+E65","v":-21584.00084821428},-18940.197455357134,-16296.394062499989,-13652.590669642843,-11008.787276785697,-8364.9838839285512,-5721.1804910714054,-3077.3770982142596]
[]
[]
[]
[null,null,"NPV Sensitivity Analysis"]
[null,null,null,60,65,70,75,80,85,"Price/dry ton"]
[null,null,5,-37723.11,-28586.33,-19440.650000000001,-10294.92,-1149.19,7996.54]
[null,null,6,-22158.67,-11421.84,-685.02,10051.81,20788.64,31525.46]
[null,null,7,-6585.23,5742.69,18070.62,30398.54,42726.400000000001,55054.39]
[null,null,8,8988.2000000000007,22907.23,36826.230000000003,50745.27,64664.3,78593.320000000007]
[null,null,"Mature yield"]

{"sheet":"Cost Distribution","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Cost distribution in %, undiscounted"]
[]
[null,"Costs (per acre)","US$/acre","US$ total per year (avg.)","% of total"]
[null,"Planting and Establishment",{"$f":"'Planting and Est. submodel'!J65","v":175.52799999999999},{"$f":"(C5*'Input-output'!D8)/10","v":877.64},{"$f":"D5/SUM($D$5:$D$11)","v":4.7002271965978039E-2}]
[null,"Stand Maintenance",{"$f":"('Stand Maint. Submodel'!H21*(1/9)+'Stand Maint. Submodel'!H23*(8/9))","v":159.60833333333335},{"$f":"SUM('Cash flow'!D45:L45)/9","v":7980.416666666667},{"$f":"D6/SUM($D$5:$D$11)","v":0.42739359483215283}]
[null,"Harvest",{"$f":"'Harvest submodel'!L44","v":136.17169999999999},{"$f":"SUM('Cash flow'!C46:L46)/10","v":6808.5849999999991},0.36463580041187565]
[null,"Land cost and insurance",{"$f":"'Input-output'!D10*'Input-output'!D8","v":0},{"$f":"SUM('Cash flow'!C41:L41)/10","v":0},0]
[null,"administration",{"$f":"'Input-output'!D11*'Input-output'!D8","v":0},{"$f":"SUM('Cash flow'!C42:L42)/10","v":0},0]
[null,"Transportation (average per year)",{"$f":"AVERAGE('Trans. submodel'!D57,'Trans. submodel'!D66,'Trans. submodel'!D48,'Trans. submodel'!D39,'Trans. submodel'!D30,'Trans. submodel'!L30,'Trans. submodel'!L39,'Trans. submodel'!L48,'Trans. submodel'!L57,'Trans. submodel'!L66)","v":28.512250446428574},{"$f":"SUM('Cash flow'!C47:L47)/10","v":1425.6125223214285},7.6349103837855758E-2]
[null,"Storage Cost",{"$f":"D11/'Input-output'!D8/10","v":3.160069375},{"$f":"SUM('Storage submodel'!C84:L84)/10","v":1580.0346875},8.4619228952137693E-2]

{"sheet":"Yearly Cash flow","index":5,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,8],[19,1,19,8],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Yearly Cash flow in US $ (per Acre), Undiscounted"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Yearly Cashflow in US $ (total), Undiscounted"]

{"sheet":"Accumulated cash flow","index":6,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,9],[23,1,23,9],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Accumulated Cash Flow in US $ (per Acre)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Accumulated Cash Flow in US $ (total)"]

{"sheet":"Planting and Est. submodel","index":7,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,1,1,6],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Planting and Establishment Submodel "]
[]
[null,"General data",null,null,null,null,null,"Equipment"]
[null,"Acres to be planted","acre",{"$f":"'Input-output'!D8","v":50}]
[null,"Planting time","hrs/acre",0.68,0.68,null,"Equipment Delivery","Transport for drill","$/mi",0]
[null,"Total planting time","hrs",{"$f":"+D5*D6","v":34},null,null,null,"Transport for tractor","$/mi",0]
[null,null,null,null,null,null,null,"Transport for sprayer","$/mi",0]
[null,"Labor",null,null,null,null,null,"Tranport for mower","$/mi",0]
[null,"No. of crews at site",null,1,1,null,null,"Distance","mi",0]
[null,"Labors/crew",null,1,1,null,null,"Total delivery costs","$",{"$f":"SUM(J6:J9)*J10*2","v":0}]
[null,"Laborer rate","$/hr",9.75,9.75,null,"Tractor","Fixed cost per hour","$/hr",8.2100000000000009,8.2100000000000009]
[null,"hours at site/crew","Hrs",{"$f":"+D7/D10","v":34},null,null,null,"Variable cost per hour","$/hr",29.04,29.04]
[null,"Indirect labor costs","%",0,0,null,null,"Hours per acre","hr/acre",0.54,0.54]
[null,"Total","$",{"$f":"+D10*D7*(D11*D12)*(1+D14)","v":331.5},null,null,null,"Fixed cost per acre","$/acre",{"$f":"J12*J14","v":4.4334000000000007}]
[null,"Per acre",null,{"$f":"+D15/D5","v":6.63},null,null,null,"Variable cost per acre","$/acre",{"$f":"J13*J14","v":15.681600000000001}]
[null,null,null,null,null,null,null,"Repair cost per acre","$/acre",4.38,4.38]
[null,"Travel costs",null,null,null,null,null,"Fuel cost per acre","$/acre",11.31,11.31]
[null,"No. of vehicles",null,1,null,null,null,"Total tractor costs","$",{"$f":"((J15*D5)+(J16*D5))","v":1005.7500000000001}]
[null,"Vehicle costs","$/mi",0.4,null,null,"No-till drill","Fixed cost per hour","$/hr",11.49,11.49]
[null,"Distance","Mi",0,null,null,null,"Variable cost per hour","$/hr",8.5,8.5]
[null,"Total nights",null,0,null,null,null,"Hours per acre","hr/acre",0.24,0.24]
[null,"Hotel","$/night/person",0,null,null,null,"Fixed cost per acre","$/acre",{"$f":"J20*J22","v":2.7576000000000001}]
[null,"Meals","$/day/person",0,null,null,null,"Variable cost per acre","$/acre",{"$f":"J21*J22","v":2.04}]
[null,"Total","$",{"$f":"D19*D21*2*D20+D22*(D23+D24)","v":0},null,null,null,"Repair cost per acre","$/acre",2,2]
[null,null,null,null,null,null,null,"Total drill costs","$",{"$f":"(D5*(J23+J24))","v":239.88}]
[null,"Yellow cells: insert numbers, insert \"0\" if not applicable",null,null,null,null,"Sprayer 60\" boom","Fixed cost per hour","$/hr",5.78,5.78]
[null,"Grey cells: output from previous inputs",null,null,null,null,null,"Variable cost per hour","$/hr",3.92,3.92]
[null,null,null,null,null,null,null,"Hours per acre","hr/acre",0.14000000000000001,0.14000000000000001]
[null,null,null,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"J27*J29","v":0.80920000000000014}]
[null,null,null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"J28*J29","v":0.54880000000000007}]
[null,null,null,null,null,null,null,"Repair cost per acre","$/acre",0.55000000000000004,0.55000000000000004]
[null,null,null,null,null,null,null,"Total sprayer costs","$",{"$f":"(D5*(J30+J31))","v":67.900000000000006}]
[null,null,null,null,null,null,"Rotary mower 15'","Fixed cost per hour","$/hr",5.78,5.78]
[null,null,null,null,null,null,null,"Variable cost per hour","$/hr",3.92,3.92]
[null,null,null,null,null,null,null,"Hours per acre","hr/acre",0.1,0.1]
[null,null,null,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"J34*J36","v":0.57800000000000007}]
[null,null,null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"J35*J36","v":0.39200000000000002}]
[null,null,null,null,null,null,null,"Repair cost per acre","$/acre",1.1399999999999999,1.1399999999999999]
[null,null,null,null,null,null,null,"Total mower costs","$",{"$f":"(D5*(J37+J38))","v":48.500000000000007}]
[null,null,null,null,null,null,null,"Total equipment cost","$",{"$f":"J40+J33+J26+J19+J11","v":1362.0300000000002}]
[null,null,null,null,null,null,null,"Total equipment cost per acre","$/acre",{"$f":"J41/D5","v":27.240600000000004}]
[]
[null,null,null,null,null,null,null,"Supplies"]
[null,null,null,null,null,null,"Seed ","Seed Price","$/pound",8.25]
[null,null,null,null,null,null,null,"Pounds Seed Per Acre","pounds/acre",6,6]
[null,null,null,null,null,null,"Fertilizer ","Fertilizer P205 Price","$/pound",0.8,0.8]
[null,null,null,null,null,null,null,"Fertilizer P205 Pounds per Acre","pounds/acre",40,40]
[null,null,null,null,null,null,null,"Fertilizer K20 Price","$/pound",0.75,0.75]
[null,null,null,null,null,null,null,"Fertilizer K20 Pounds per Acre","pounds/acre",80,80]
[null,null,null,null,null,null,"Burndown and Herbicide ","Fall Burndown Glycophosate Price","$/qt.",7.87,7.87]
[null,null,null,null,null,null,null,"Fall Burndown Glycophosate Qt per Acre","Qt./acre",1,1]
[null,null,null,null,null,null,null,"Other supplies ","$/acre"]
[null,null,null,null,null,null,null,"Establishment grant","$/acre",0,0]
[null,null,null,null,null,null,null,"Total ","$/acre",{"$f":"((J51*J52)+(((J45*J46)+(J47*J48)+(J49*J50)+J53)*D5))","v":7082.87}]
[null,null,null,null,null,null,null,"Total including grant","$/acre",{"$f":"J55-J54*D5","v":7082.87}]
[null,null,null,null,null,null,null,"Total including grant per acre","$/acre",{"$f":"J56/D5","v":141.6574}]
[]
[null,null,null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,"Labor ","$",{"$f":"D15","v":331.5}]
[null,null,null,null,null,null,null,"Travel ","$",{"$f":"+D25","v":0}]
[null,null,null,null,null,null,null,"Equipment ","$",{"$f":"+J41","v":1362.0300000000002}]
[null,null,null,null,null,null,null,"Supplies ","$",{"$f":"+J56","v":7082.87}]
[null,null,null,null,null,null,null,"Total ","$",{"$f":"SUM(J60:J63)","v":8776.4}]
[null,null,null,null,null,null,null,"Total per acre ","$/acre",{"$f":"+J64/D5","v":175.52799999999999}]

{"sheet":"Stand Maint. Submodel","index":8,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,7],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Stand Maintenance Submodel"]
[]
[null,"General input data"]
[null,"Project Size",null,null,null,null,null,{"$f":"'Input-output'!D8","v":50}]
[null,"Nitrogen",null,null,null,null,"Pounds/acre",60,60]
[null,"Nitrogen Price",null,null,null,null,"$/pound",0.76,0.76]
[null,"P2O5",null,null,null,null,"Pounds/acre",40,40]
[null,"P2O5 Price",null,null,null,null,"$/pound",0.8,0.8]
[null,"K2O",null,null,null,null,"Pounds/acre",80,80]
[null,"K2O Price",null,null,null,null,"$/pound",0.75,0.75]
[null,"Spring burndown",null,null,null,null,"Quantity/acre",1.5,1.5]
[null,"Spring burndown Price",null,null,null,null,"$/quantity",7.87,7.87]
[null,"Fall burndown",null,null,null,null,"Quantity/acre",1,1]
[null,"Fall burndown price",null,null,null,null,"$/quantity",7.87,7.87]
[null,"Broadleaf herbicide",null,null,null,null,"Quantity/acre",2,2]
[null,"Broadleaf herbicide price",null,null,null,null,"$/quantity",2.5,2.5]
[null,"Grass herbicide",null,null,null,null,"Quantity/acre",2,2]
[null,"Grass herbicide price",null,null,null,null,"$/quantity",8,8]
[null,"Total stand maintenance cost second year",null,null,null,null,null,{"$f":"H21*H5","v":8913.7499999999982}]
[null,"Total stand maintenance cost second year per acre",null,null,null,null,null,{"$f":"(H6*H7+H8*H9+H10*H11)+(H12*H13+H14*H15+H16*H17+H18*H19)","v":178.27499999999998}]
[null,"Total stand maintenance cost after second year",null,null,null,null,null,{"$f":"H23*H5","v":7863.75}]
[null,"Total stand maintenance cost after second year per acre",null,null,null,null,null,{"$f":"(H6*H7+H8*H9+H10*H11)+(H12*H13+H14*H15)","v":157.27500000000001}]
[null,"Total stand maintence cost second year per ton",null,null,null,null,null,{"$f":"H20/'Biomass harvested submodel'!D12","v":48.182432432432421}]
[null,"Total stand maintence cost after second year per ton",null,null,null,null,null,{"$f":"H22/('Biomass harvested submodel'!E12)","v":26.212499999999999}]

{"sheet":"Harvest submodel","index":9,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,6],[47,8,47,9],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Harvest Submodel"]
[]
[null,"General Input Data",null,null,null,null,null,null,null,"Equipment"]
[null,"Acres to be harvested","acres",{"$f":"+'Input-output'!D8","v":50},null,null,null,null,"Tractor","Fixed cost per hour","$/hr",8.2100000000000009,8.2100000000000009]
[null,"Harvest speed","hr./acre",1.48,1.48,null,null,null,null,"Variable cost per hour","$/hr",29.04,29.04]
[null,null,null,null,null,null,null,null,null,"Hours per acre","hr/acre",2.0299999999999998,3.14]
[null,null,null,null,null,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"(L5*L7)","v":16.6663}]
[null,null,null,null,null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"(L6*L7)","v":58.951199999999993}]
[null,null,null,null,null,null,null,null,null,"Fuel cost per acre","$/acre",42.56,42.56]
[null,null,null,null,null,null,null,null,null,"Total tractor costs","$",{"$f":"((L8*D5)+(L9*D5))","v":3780.8749999999995}]
[null,null,null,null,null,null,null,null,"Mower","Fixed cost per hour","$/hr",3.3,3.3]
[null,null,null,null,null,null,null,null,null,"Variable cost per hour","$/hr",4.88,4.88]
[null,null,null,null,null,null,null,null,null,"Hours per acre","hr/acre",0.26,0.26]
[null,null,null,null,null,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"L12*L14","v":0.85799999999999998}]
[null,"Labor",null,null,null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"L13*L14","v":1.2687999999999999}]
[null,"no. crews at site",null,1,1,null,null,null,null,"Total mower costs","$",{"$f":"((L15*D5)+(L16*D5))","v":106.34}]
[null,"Laborer/ crew ",null,1,1,null,null,null,"Rake","Fixed cost per hour","$/hr",1.37,1.37]
[null,"Foreman/crew ",null,1,1,null,null,null,null,"Variable cost per hour","$/hr",0.72,0.72]
[null,"Laborer rate","$/hr",9.75,9.75,null,null,null,null,"Hours per acre","hr/acre",0.17,0.28999999999999998]
[null,"Foreman rate","$/hr",9.75,9.75,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"L18*L20","v":0.23290000000000002}]
[null,"Hours at site/crew",null,{"$f":"D5*D6","v":74},null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"L19*L20","v":0.12240000000000001}]
[null,"indirect labor costs","%",0,0,null,null,null,null,"Total rake costs","$",{"$f":"((L21*D5)+(L22*D5))","v":17.765000000000001}]
[null,"total","$",{"$f":"D17*D22*(D18*D20*(1+D23*0.01)+D19*D21*(1+(D23*0.01)))","v":1443},null,null,null,null,"Baler","Fixed cost per hour","$/hr",14.62,14.62]
[null,"Total per acre","$/acre",{"$f":"D24/D5","v":28.86},null,null,null,null,null,"Variable cost per hour","$/hr",13.8,13.8]
[null,null,null,null,null,null,null,null,null,"Hours per acre","hr/acre",0.75,0.75]
[null,"Travel Costs",null,null,null,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"L24*L26","v":10.965}]
[null,"No of Vehicles",null,1,1,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"L25*L26","v":10.350000000000001}]
[null,"Vehicle costs","$/mi",0.4,0.4,null,null,null,null,"Total baler costs","$",{"$f":"((L27*D5)+(L28*D5))","v":1065.75}]
[null,"Distance (one way)","mi",50,50,null,null,null,"Loader","Fixed cost per hour","$/hr",7.27,7.27]
[null,"Total nights",null,0,0,null,null,null,null,"Variable cost per hour","$/hr",3,3]
[null,"Hotel costs","$/night/person",0,0,null,null,null,null,"Hours per acre","hr/acre",0.73,1.07]
[null,"Meal costs","$/night/person",0,0,null,null,null,null,"Fixed cost per acre","$/acre",{"$f":"L30*L32","v":5.3070999999999993}]
[null,"Total crew travel costs","$",{"$f":"(D28*D30*D29)+(D31*D32)+(D31*D33)","v":20},null,null,null,null,null,"Variable cost per acre","$/acre",{"$f":"L31*L32","v":2.19}]
[null,null,null,null,null,null,null,null,null,"Total loader costs","$",{"$f":"((L33*D5)+(L34*D5))","v":374.85499999999996}]
[null,"Yellow cells: insert numbers, insert \"0\" if not applicable",null,null,null,null,null,null,null,"Total equipment costs","$",{"$f":"L11+L17+L23+L29+L35","v":5345.5849999999991}]
[null,"Grey cells: output from previous inputs",null,null,null,null,null,null,null,"Total equipment costs per acre","$/acre",{"$f":"L36/D5","v":106.91169999999998}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS"]
[null,null,null,null,null,null,null,null,null,"Labor","$",{"$f":"D24","v":1443}]
[null,null,null,null,null,null,null,null,null,"Travel","$",{"$f":"D34","v":20}]
[null,null,null,null,null,null,null,null,null,"Equipment","$",{"$f":"L36","v":5345.5849999999991}]
[null,null,null,null,null,null,null,null,null,"Total","$",{"$f":"L42+L41+L40","v":6808.5849999999991}]
[null,null,null,null,null,null,null,null,null,"Total per Acre","$/acre",{"$f":"L43/D5","v":136.17169999999999}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Cost per ton by year"]
[null,null,null,null,null,null,null,null,"Year","Harvest cost per ton"]
[null,null,null,null,null,null,null,null,1,{"$f":"$L$43/'Biomass harvested submodel'!C12","v":97.265499999999989}]
[null,null,null,null,null,null,null,null,2,{"$f":"L43/'Biomass harvested submodel'!D12","v":36.80316216216216}]
[null,null,null,null,null,null,null,null,3,{"$f":"L43/'Biomass harvested submodel'!E12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,4,{"$f":"L43/'Biomass harvested submodel'!F12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,5,{"$f":"L43/'Biomass harvested submodel'!G12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,6,{"$f":"L43/'Biomass harvested submodel'!H12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,7,{"$f":"L43/'Biomass harvested submodel'!I12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,8,{"$f":"L43/'Biomass harvested submodel'!J12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,9,{"$f":"L43/'Biomass harvested submodel'!K12","v":22.695283333333329}]
[null,null,null,null,null,null,null,null,10,{"$f":"L43/'Biomass harvested submodel'!L12","v":22.695283333333329}]

{"sheet":"Trans. submodel","index":10,"n_rows":67,"n_cols":13,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,1,1,5],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Transportation Submodel"]
[]
[null,"General Input Data",null,null,null,null,null,null,null,"Equipment"]
[null,"Project size","acres",{"$f":"'Input-output'!D8","v":50},null,null,null,null,null,"Tractor-trailer costs","$/mi",0.5,0.5]
[null,"Highway Speed","mi/hr",50,50,null,null,null,null,"Fuel consumption","mi/g",7,7]
[null,"Field road speed","mi/hr",20,20,null,null,null,null,"Fuel price","$/g",3,3]
[null,"Distance on highway (one way)","mi",25,25,null,null,null,null,"Maximum capacity","tons",{"$f":"IF('Storage submodel'!G10=\"Round bales\",14.4,24)","v":14.4}]
[null,"Distance on field road (one way)","mi",1,1]
[null,"Total driving time roundtrip","hrs",{"$f":"((D8*2)/D6)+((D9*2)/D7)","v":1.1000000000000001}]
[null,"Loading time","min ",5,5]
[null,"unloading time","min ",15,15]
[null,"Total time per trip","hrs",{"$f":"D10+(D11/60)+(D12/60)","v":1.4333333333333333}]
[]
[null,"Labor"]
[null,"Driver wage","$/hr",9.5,9.5]
[null,"Indirect Labor costs","%",0,0]
[null,"Average Loading and unloading cost","$",16.2,16.2]
[]
[null,"Yellow cells: insert numbers, insert \"0\" if not applicable"]
[null,"Grey cells: output from previous inputs"]
[]
[]
[null,"Cost in year 1",null,null,null,null,null,null,null,"Cost in year 6"]
[null,"Total trips",null,{"$f":"'Storage submodel'!C80/L8","v":4.8125},null,null,null,null,null,"Total trips",null,{"$f":"'Storage submodel'!H80/L8","v":20.625}]
[null,"Total time","hrs",{"$f":"D25*D13","v":6.8979166666666671},null,null,null,null,null,"Total time","hrs",{"$f":"L25*D13","v":29.5625}]
[null,"Labor","$",{"$f":"(D18*D25)+((D16+D16*D17)*D26)","v":143.49270833333333},null,null,null,null,null,"Labor","$",{"$f":"(D18*L25)+(D16+D16*D17)*L26","v":614.96875}]
[null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*D25","v":232.375},null,null,null,null,null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*L25","v":995.89285714285711}]
[null,"Total","$",{"$f":"D27+D28","v":375.86770833333333},null,null,null,null,null,"Total","$",{"$f":"L28+L27","v":1610.8616071428571}]
[null,"Total per acre","$/acre",{"$f":"D29/D5","v":7.5173541666666663},null,null,null,null,null,"Total per acre","$/acre",{"$f":"L29/D5","v":32.217232142857142}]
[null,"Total per ton","$/odt",{"$f":"D29/'Storage submodel'!C80","v":5.4237764550264549},null,null,null,null,null,"Total per ton","$/odt",{"$f":"L29/'Storage submodel'!H80","v":5.4237764550264549}]
[]
[null,"Cost in year 2",null,null,null,null,null,null,null,"Cost in year 7"]
[null,"Total trips",null,{"$f":"'Storage submodel'!D80/'Trans. submodel'!L8","v":12.71875},null,null,null,null,null,"Total trips",null,{"$f":"'Storage submodel'!I80/L8","v":20.625}]
[null,"Total time","hrs",{"$f":"D34*D13","v":18.230208333333334},null,null,null,null,null,"Total time","hrs",{"$f":"L34*D13","v":29.5625}]
[null,"Labor","$",{"$f":"(D18*D34+(D16+D16*D17)*D35)","v":379.23072916666666},null,null,null,null,null,"Labor","$",{"$f":"(D18*L34+(D16+D16*D17)*L35)","v":614.96875}]
[null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*D34","v":614.13392857142856},null,null,null,null,null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*L34","v":995.89285714285711}]
[null,"Total","$",{"$f":"D37+D36","v":993.36465773809527},null,null,null,null,null,"Total","$",{"$f":"L37+L36","v":1610.8616071428571}]
[null,"Total per acre","$/acre",{"$f":"D38/D5","v":19.867293154761906},null,null,null,null,null,"Total per acre","$/acre",{"$f":"L38/D5","v":32.217232142857142}]
[null,"Total per ton","$/odt",{"$f":"D38/'Storage submodel'!D80","v":5.4237764550264549},null,null,null,null,null,"Total per ton","$/odt",{"$f":"L38/'Storage submodel'!I80","v":5.4237764550264549}]
[]
[null,"Cost in year 3",null,null,null,null,null,null,null,"Cost in year 8"]
[null,"Total trips",null,{"$f":"'Storage submodel'!E80/L8","v":20.625},null,null,null,null,null,"Total trips",null,{"$f":"'Storage submodel'!K80/L8","v":20.625}]
[null,"Total time","hrs",{"$f":"D43*D13","v":29.5625},null,null,null,null,null,"Total time","hrs",{"$f":"L43*D13","v":29.5625}]
[null,"Labor","$",{"$f":"(D18*D43+(D16+D16*D17)*D44)","v":614.96875},null,null,null,null,null,"Labor","$",{"$f":"(D18*L43+(D16+D16*D17)*L44)","v":614.96875}]
[null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*D43","v":995.89285714285711},null,null,null,null,null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*L43","v":995.89285714285711}]
[null,"Total","$",{"$f":"D46+D45","v":1610.8616071428571},null,null,null,null,null,"Total","$",{"$f":"L46+L45","v":1610.8616071428571}]
[null,"Total per acre","$/acre",{"$f":"D47/D5","v":32.217232142857142},null,null,null,null,null,"Total per acre","$/acre",{"$f":"L47/D5","v":32.217232142857142}]
[null,"Total per ton","$/odt",{"$f":"D47/'Storage submodel'!E80","v":5.4237764550264549},null,null,null,null,null,"Total per ton","$/odt",{"$f":"L47/'Storage submodel'!J80","v":5.4237764550264549}]
[]
[null,"Cost in year 4",null,null,null,null,null,null,null,"Cost in year 9"]
[null,"Total trips",null,{"$f":"'Storage submodel'!F80/L8","v":20.625},null,null,null,null,null,"Total trips",null,{"$f":"'Storage submodel'!K80/L8","v":20.625}]
[null,"Total time","hrs",{"$f":"D52*D13","v":29.5625},null,null,null,null,null,"Total time","hrs",{"$f":"L52*D13","v":29.5625}]
[null,"Labor","$",{"$f":"(D18*D52+(D16+D16*D17)*D53)","v":614.96875},null,null,null,null,null,"Labor","$",{"$f":"(D18*L52+(D16+D16*D17)*L53)","v":614.96875}]
[null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*D52","v":995.89285714285711},null,null,null,null,null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*L52","v":995.89285714285711}]
[null,"Total","$",{"$f":"D55+D54","v":1610.8616071428571},null,null,null,null,null,"Total","$",{"$f":"L55+L54","v":1610.8616071428571}]
[null,"Total per acre","$/acre",{"$f":"D56/D5","v":32.217232142857142},null,null,null,null,null,"Total per acre","$/acre",{"$f":"L56/D5","v":32.217232142857142}]
[null,"Total per ton","$/odt",{"$f":"D56/'Storage submodel'!F80","v":5.4237764550264549},null,null,null,null,null,"Total per ton","$/odt",{"$f":"L56/'Storage submodel'!K80","v":5.4237764550264549}]
[]
[null,"Cost in year 5",null,null,null,null,null,null,null,"Cost in year 10"]
[null,"Total trips",null,{"$f":"'Storage submodel'!G80/L8","v":20.625},null,null,null,null,null,"Total trips",null,{"$f":"'Storage submodel'!L80/L8","v":20.625}]
[null,"Total time","hrs",{"$f":"D61*D13","v":29.5625},null,null,null,null,null,"Total time","hrs",{"$f":"L61*D13","v":29.5625}]
[null,"Labor","$",{"$f":"(D18*D61+(D16+D16*D17)*D62)","v":614.96875},null,null,null,null,null,"Labor","$",{"$f":"D18*L61+(D16+D16*D17)*L62","v":614.96875}]
[null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*D61","v":995.89285714285711},null,null,null,null,null,"Equipment","$",{"$f":"(D8+D9)*2*(L5+L7/L6)*L61","v":995.89285714285711}]
[null,"Total","$",{"$f":"D64+D63","v":1610.8616071428571},null,null,null,null,null,"Total","$",{"$f":"L64+L63","v":1610.8616071428571}]
[null,"Total per acre","$/acre",{"$f":"D65/D5","v":32.217232142857142},null,null,null,null,null,"Total per acre","$/acre",{"$f":"L65/D5","v":32.217232142857142}]
[null,"Total per ton","$/odt",{"$f":"D65/'Storage submodel'!G80","v":5.4237764550264549},null,null,null,null,null,"Total per ton","$/odt",{"$f":"L65/'Storage submodel'!L80","v":5.4237764550264549}]

{"sheet":"Storage submodel","index":11,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,1,0,4],[81,1,81,11],[77,1,77,11],[73,1,73,11],[31,1,31,12],[1,1,1,6],[7,9,7,11],[8,5,8,6],[14,1,14,3],[15,1,15,4],[17,5,17,6],[17,8,17,10]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Storage Submodel"]
[]
[null,"General data"]
[null,"Acres planted",null,null,null,"acres",{"$f":"'Input-output'!D8","v":50}]
[]
[]
[]
[null,"Bailing method^"]
[null,"Round bales",null,null,null,"Choose one","Round bales"]
[null,"Rectangular bales"]
[]
[null,"Storage time^",null,null,null,null,null,null,null,null,null,null,0]
[null,"Storage time up to 200 days",null,null,null,"days",200,null,null,null,null,null,1]
[null,"Percentage going directly to plant gate",null,null,null,"%",0]
[null,"Percentage being stored for up to 200 days",null,null,null,"%",1]
[]
[null,"Storage method^",null,null,null,"1 if yes, 0 if no",null,null,"Dry matter loss after 200 days*"]
[null,"Large round bale"]
[null,"Tarp and Pallet",null,null,0,null,1,null,null,0.01]
[null,"Tarp and gravel",null,null,1,null,0,null,null,8.5000000000000006E-2]
[null,"Tarp on bare ground",null,null,null,null,0,null,null,7.0000000000000007E-2]
[null,"Pallet no tarp",null,null,null,null,0,null,null,0.182]
[null,"Gravel no tarp",null,null,null,null,0,null,null,0.16600000000000001]
[null,"Bare ground no tarp",null,null,null,null,0,null,null,0.128]
[null,"Large rectangular bale"]
[null,"Tarp and pallet",null,null,null,null,0,null,null,0.13700000000000001]
[null,"Tarp and gravel",null,null,null,null,0,null,null,0.28000000000000003]
[null,"Pallet no tarp",null,null,null,null,0,null,null,0.48]
[null,"Gravel no tarp",null,null,null,null,0,null,null,0.57099999999999995]
[]
[null,"*Calculated from unpublished work by Burton English, James Larson and Don Tyler at Milan Research and Education Center."]
[null,"^ Only one storage method and baling type may be used for storage loss calculation in this worksheet."]
[]
[]
[]
[]
[]
[]
[null,"Dry matter loss schedule by year in tons"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Storage method"]
[null,"Large round bale"]
[null,"Tarp and Pallet",{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.01,0)","v":0.70000000000000007},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.01,0)","v":1.85},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.01,0)","v":3},{"$f":"IF(G20=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.01,0)","v":3}]
[null,"Tarp and gravel",{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.085,0)","v":0},{"$f":"IF(G21=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.085,0)","v":0}]
[null,"Tarp on bare ground",{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,'Biomass harvested submodel'!E12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.07,0)","v":0},{"$f":"IF(G22=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.07,0)","v":0}]
[null,"Pallet no tarp",{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.185,0)","v":0},{"$f":"IF(G23=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.185,0)","v":0}]
[null,"Gravel no tarp",{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.166,0)","v":0},{"$f":"IF(G24=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.166,0)","v":0}]
[null,"Bare ground no tarp",{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.128,0)","v":0},{"$f":"IF(G25=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.128,0)","v":0}]
[null,"Large rectangular bale"]
[null,"Tarp and pallet",{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.137,0)","v":0},{"$f":"IF(G27=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.137,0)","v":0}]
[null,"Tarp and gravel",{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.28,0)","v":0},{"$f":"IF(G28=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.28,0)","v":0}]
[null,"Pallet no tarp",{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!G12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.48,0)","v":0},{"$f":"IF(G29=1,(G14/200)*'Biomass harvested submodel'!L12*(G16)*0.48,0)","v":0}]
[null,"Gravel no tarp",{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!C12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!D12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!E12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!F12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!G12*(0.01*G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!H12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!I12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!J12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!K12*(G16)*0.571,0)","v":0},{"$f":"IF(G30=1,(G14/200)*'Biomass harvested submodel'!L12*(0.01*G16)*0.571,0)","v":0}]
[]
[null,"Storage costs per year"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Storage method"]
[null,"Large round bale"]
[null,"Tarp and Pallet",{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!D12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!D12)/0.4))),0)","v":3122.453125},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!D12-0.8*'Biomass harvested submodel'!C12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!D12-0.75*'Biomass harvested submodel'!C12)/0.4))),0)","v":2202.4343749999998},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!E12-0.8*'Biomass harvested submodel'!D12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!E12-0.75*'Biomass harvested submodel'!D12)/0.4))),0)","v":2631.9593749999999},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!F12-0.8*'Biomass harvested submodel'!E12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!F12-0.75*'Biomass harvested submodel'!E12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!G12-0.8*'Biomass harvested submodel'!F12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!G12-0.75*'Biomass harvested submodel'!F12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!H12-0.8*'Biomass harvested submodel'!G12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!H12-0.75*'Biomass harvested submodel'!G12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!I12-0.8*'Biomass harvested submodel'!H12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!I12-0.75*'Biomass harvested submodel'!H12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!J12-0.8*'Biomass harvested submodel'!I12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!J12-0.75*'Biomass harvested submodel'!I12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!K12-0.8*'Biomass harvested submodel'!J12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!K12-0.75*'Biomass harvested submodel'!J12)/0.4))),0)","v":1120.5},{"$f":"IF($G$20=1,((279.09/72)*(('Biomass harvested submodel'!L12-0.8*'Biomass harvested submodel'!K12)/0.4)+((17.25/6)*(('Biomass harvested submodel'!L12-0.75*'Biomass harvested submodel'!K12)/0.4))),0)","v":1120.5}]
[null,"Tarp and gravel",{"$f":"IF($G$21=1,((279.09/72)*('Biomass harvested submodel'!C12/0.4)+((24.31/3)*('Biomass harvested submodel'!C12/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!D12-0.8*'Biomass harvested submodel'!C8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!D12-'Biomass harvested submodel'!C12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!E12-0.8*'Biomass harvested submodel'!D8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!E12-'Biomass harvested submodel'!D12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!F12-0.8*'Biomass harvested submodel'!E8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!F12-'Biomass harvested submodel'!E12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!G12-0.8*'Biomass harvested submodel'!F8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!G12-'Biomass harvested submodel'!F12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!H12-0.8*'Biomass harvested submodel'!G8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!H12-'Biomass harvested submodel'!G12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!I12-0.8*'Biomass harvested submodel'!H8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!I12-'Biomass harvested submodel'!H12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!J12-0.8*'Biomass harvested submodel'!I8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!J12-'Biomass harvested submodel'!I12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!K12-0.8*'Biomass harvested submodel'!J8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!K12-'Biomass harvested submodel'!J12)/0.4))),0)","v":0},{"$f":"IF($G$21=1,((279.09/72)*(('Biomass harvested submodel'!L12-0.8*'Biomass harvested submodel'!K8)/0.4)+((24.31/3)*(('Biomass harvested submodel'!L12-'Biomass harvested submodel'!K12)/0.4))),0)","v":0}]
[null,"Tarp on bare ground",{"$f":"IF($G$22=1,((279.09/72)*('Biomass harvested submodel'!C12/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!D12-0.8*'Biomass harvested submodel'!C12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!E12-0.8*'Biomass harvested submodel'!D12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!F12-0.8*'Biomass harvested submodel'!E12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!G12-0.8*'Biomass harvested submodel'!F12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!H12-0.8*'Biomass harvested submodel'!G12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!I12-0.8*'Biomass harvested submodel'!H12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!J12-0.8*'Biomass harvested submodel'!I12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!K12-0.8*'Biomass harvested submodel'!J12)/0.4)),0)","v":0},{"$f":"IF($G$22=1,((279.09/72)*(('Biomass harvested submodel'!L12-0.8*'Biomass harvested submodel'!K12)/0.4)),0)","v":0}]
[null,"Pallet no tarp",{"$f":"IF($G$23=1,((17.25/6)*('Biomass harvested submodel'!C12/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!D12-0.667*'Biomass harvested submodel'!C12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!E12-0.667*'Biomass harvested submodel'!D12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!F12-0.667*'Biomass harvested submodel'!E12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!G12-0.667*'Biomass harvested submodel'!F12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!H12-0.667*'Biomass harvested submodel'!G12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!I12-0.667*'Biomass harvested submodel'!H12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!J12-0.667*'Biomass harvested submodel'!I12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!K12-0.667*'Biomass harvested submodel'!J12)/0.4)),0)","v":0},{"$f":"IF($G$23=1,((17.25/6)*(('Biomass harvested submodel'!L12-0.667*'Biomass harvested submodel'!K12)/0.4)),0)","v":0}]
[null,"Gravel no tarp",{"$f":"IF($G$24=1,((24.31/3)*('Biomass harvested submodel'!C12/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!D12-0.98*'Biomass harvested submodel'!C12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!E12-0.98*'Biomass harvested submodel'!D12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!F12-0.98*'Biomass harvested submodel'!E12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!G12-0.98*'Biomass harvested submodel'!F12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!H12-0.98*'Biomass harvested submodel'!G12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!I12-0.98*'Biomass harvested submodel'!H12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!J12-0.98*'Biomass harvested submodel'!I12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!K12-0.98*'Biomass harvested submodel'!J12)/0.4)),0)","v":0},{"$f":"IF($G$24=1,((24.31/3)*(('Biomass harvested submodel'!L12-0.98*'Biomass harvested submodel'!K12)/0.4)),0)","v":0}]
[null,"Bare ground no tarp",{"$f":"IF($G$25=1,0,0)","v":0},{"$f":"IF($G$25=1,0,0)","v":0},0,0,0,0,0,0,0,0]
[null,"Large rectangular bale"]
[null,"Tarp and pallet",{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!C12))+((23/5)*(('Biomass harvested submodel'!C12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!D12-0.8*'Biomass harvested submodel'!C12))+((23/5)*(('Biomass harvested submodel'!D12-0.75*'Biomass harvested submodel'!C12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!E12-0.8*'Biomass harvested submodel'!D12))+((23/5)*(('Biomass harvested submodel'!E12-0.75*'Biomass harvested submodel'!D12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!F12-0.8*'Biomass harvested submodel'!E12))+((23/5)*(('Biomass harvested submodel'!F12-0.75*'Biomass harvested submodel'!E12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!G12-0.8*'Biomass harvested submodel'!F12))+((23/5)*(('Biomass harvested submodel'!G12-0.75*'Biomass harvested submodel'!F12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!H12-0.8*'Biomass harvested submodel'!G12))+((23/5)*(('Biomass harvested submodel'!H12-0.75*'Biomass harvested submodel'!G12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!I12-0.8*'Biomass harvested submodel'!H12))+((23/5)*(('Biomass harvested submodel'!I12-0.75*'Biomass harvested submodel'!H12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!J12-0.8*'Biomass harvested submodel'!I12))+((23/5)*(('Biomass harvested submodel'!J12-0.75*'Biomass harvested submodel'!I12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!K12-0.8*'Biomass harvested submodel'!J12))+((23/5)*(('Biomass harvested submodel'!K12-0.75*'Biomass harvested submodel'!J12)))),0)","v":0},{"$f":"IF($G$27=1,((279.09/60)*(('Biomass harvested submodel'!L12-0.8*'Biomass harvested submodel'!K12))+((23/5)*(('Biomass harvested submodel'!L12-0.75*'Biomass harvested submodel'!K12)))),0)","v":0}]
[null,"Tarp and gravel",{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!C12))+((24.31/2.5)*(('Biomass harvested submodel'!C12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!D12-0.8*'Biomass harvested submodel'!C12))+((24.31/2.5)*(('Biomass harvested submodel'!D12-0.98*'Biomass harvested submodel'!C12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!E12-0.8*'Biomass harvested submodel'!D12))+((24.31/2.5)*(('Biomass harvested submodel'!E12-0.98*'Biomass harvested submodel'!D12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!F12-0.8*'Biomass harvested submodel'!E12))+((24.31/2.5)*(('Biomass harvested submodel'!F12-0.98*'Biomass harvested submodel'!E12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!G12-0.8*'Biomass harvested submodel'!F12))+((24.31/2.5)*(('Biomass harvested submodel'!G12-0.98*'Biomass harvested submodel'!F12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!H12-0.8*'Biomass harvested submodel'!G12))+((24.31/2.5)*(('Biomass harvested submodel'!H12-0.98*'Biomass harvested submodel'!G12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!I12-0.8*'Biomass harvested submodel'!H12))+((24.31/2.5)*(('Biomass harvested submodel'!I12-0.98*'Biomass harvested submodel'!H12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!J12-0.8*'Biomass harvested submodel'!I12))+((24.31/2.5)*(('Biomass harvested submodel'!J12-0.98*'Biomass harvested submodel'!I12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!K12-0.8*'Biomass harvested submodel'!J12))+((24.31/2.5)*(('Biomass harvested submodel'!K12-0.98*'Biomass harvested submodel'!J12)))),0)","v":0},{"$f":"IF($G$28=1,((279.09/60)*(('Biomass harvested submodel'!L12-0.8*'Biomass harvested submodel'!K12))+((24.31/2.5)*(('Biomass harvested submodel'!L12-0.98*'Biomass harvested submodel'!K12)))),0)","v":0}]
[null,"Pallet no tarp",{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!C12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!D12-0.75*'Biomass harvested submodel'!C12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!E12-0.75*'Biomass harvested submodel'!D12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!F12-0.75*'Biomass harvested submodel'!E12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!G12-0.75*'Biomass harvested submodel'!F12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!H12-0.75*'Biomass harvested submodel'!G12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!I12-0.75*'Biomass harvested submodel'!H12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!J12-0.75*'Biomass harvested submodel'!I12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!K12-0.75*'Biomass harvested submodel'!J12))),0)","v":0},{"$f":"IF($G$29=1,((23/5)*(('Biomass harvested submodel'!L12-0.75*'Biomass harvested submodel'!K12))),0)","v":0}]
[null,"Gravel no tarp",{"$f":"IF($G$30=1,((24.31/2.5)*('Biomass harvested submodel'!C12/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!D12-0.98*'Biomass harvested submodel'!C12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!E12-0.98*'Biomass harvested submodel'!D12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!F12-0.98*'Biomass harvested submodel'!E12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!G12-0.98*'Biomass harvested submodel'!F12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!H12-0.98*'Biomass harvested submodel'!G12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!I12-0.98*'Biomass harvested submodel'!H12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!J12-0.98*'Biomass harvested submodel'!I12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!K12-0.98*'Biomass harvested submodel'!J12)/0.4)),0)","v":0},{"$f":"IF($G$30=1,((24.31/2.5)*(('Biomass harvested submodel'!L12-0.98*'Biomass harvested submodel'!K12)/0.4)),0)","v":0}]
[]
[]
[]
[null,"Dry matter loss schedule by year in tons"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Loss",{"$f":"SUM(C44:C54)","v":0.70000000000000007},{"$f":"SUM(D44:D54)","v":1.85},3,3,3,3,3,3,3,3]
[]
[null,"Total biobass making it to the plant"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Biomass",{"$f":"('Biomass harvested submodel'!C12-C76)","v":69.3},{"$f":"'Biomass harvested submodel'!D12-D76","v":183.15},{"$f":"'Biomass harvested submodel'!E12-E76","v":297},{"$f":"'Biomass harvested submodel'!F12-F76","v":297},{"$f":"'Biomass harvested submodel'!G12-G76","v":297},{"$f":"'Biomass harvested submodel'!H12-H76","v":297},{"$f":"'Biomass harvested submodel'!I12-I76","v":297},{"$f":"'Biomass harvested submodel'!J12-J76","v":297},{"$f":"'Biomass harvested submodel'!K12-K76","v":297},{"$f":"'Biomass harvested submodel'!L12-L76","v":297}]
[]
[null,"Cost of storage by ton per year"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Total cost",{"$f":"SUM(C60:C70)","v":3122.453125},{"$f":"SUM(D60:D70)","v":2202.4343749999998},2631.9593749999999,1120.5,1120.5,1120.5,1120.5,1120.5,1120.5,1120.5]
[null,"Cost per ton",{"$f":"C84/'Biomass harvested submodel'!C12","v":44.606473214285714},{"$f":"D84/'Biomass harvested submodel'!D12","v":11.905050675675675},{"$f":"E84/'Biomass harvested submodel'!E12","v":8.7731979166666658},{"$f":"F84/'Biomass harvested submodel'!F12","v":3.7349999999999999},{"$f":"G84/'Biomass harvested submodel'!G12","v":3.7349999999999999},{"$f":"H84/'Biomass harvested submodel'!H12","v":3.7349999999999999},{"$f":"I84/'Biomass harvested submodel'!I12","v":3.7349999999999999},{"$f":"J84/'Biomass harvested submodel'!J12","v":3.7349999999999999},{"$f":"K84/'Biomass harvested submodel'!K12","v":3.7349999999999999},{"$f":"L84/'Biomass harvested submodel'!L12","v":3.7349999999999999}]

{"sheet":"Biomass harvested submodel","index":12,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,7],[0,1,0,4]]}
[null,{"$f":"Welcome!$A$5","v":"Project Name Here"}]
[null,"Biomass harvested Submodel"]
[]
[null,"Acres planted",{"$f":"'Input-output'!D8","v":50},null,"Mature stand yield in tons/acre",null,6]
[]
[null,"Estimated harvest in tons per acre"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Tons/acre",1.4,3.7,{"$f":"$G$4","v":6},{"$f":"$G$4","v":6},6,6,6,6,6,6]
[]
[null,"Estimated harvest in tons per year"]
[null,"Year",1,2,3,4,5,6,7,8,9,10]
[null,"Tons/acre",{"$f":"C4*C8","v":70},{"$f":"C4*D8","v":185},{"$f":"C4*E8","v":300},{"$f":"C4*F8","v":300},{"$f":"C4*G8","v":300},{"$f":"C4*H8","v":300},{"$f":"C4*I8","v":300},{"$f":"C4*J8","v":300},{"$f":"C4*K8","v":300},{"$f":"C4*L8","v":300}]