{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Home","Steps 1-6","Steps 7-8","Step 9","Step 10","Step 11","Step 12","Step 13","alley-cropping","harvester 1.0","budget","graph","input tables"],"not_rendered":{"charts":1,"images":11,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":22,"n_cols":21,"rows_kept":22,"merged":[[0,1,0,11],[1,1,1,11],[3,1,5,15],[7,1,7,3],[7,5,7,7],[7,9,7,11],[7,13,7,15],[8,1,8,3],[8,5,8,7],[8,9,8,11],[8,13,8,15],[16,20,16,21],[20,1,20,3],[20,5,20,7],[20,9,20,11],[20,13,21,15],[21,1,21,3],[21,5,21,7],[21,9,21,11]]}
[null,"Midwest Hazelnut Enterprise Budget Worksheet Tool "]
[null,"Original Verstion: June 8, 2012, Last Updated: December 4, 2022"]
[]
[null,"This spreadsheet tool helps you build an enterprise budget for your hazelnut enterprise one step at a time.  Starting with Step 1, complete each Step in order by filling in the yellow boxes.  The completed enterprise budget can be seen in the budget tab. This tool separates your planting into two parts: the hazelnut rows and the row-middles."]
[]
[]
[]
[null,"Establishment",{"$nulls":3},"Early-Production",{"$nulls":3},"Full-Production",{"$nulls":3},"Seedling Renovation"]
[null,"Years 0-1",{"$nulls":3},"Years 2-5",{"$nulls":3},"Years 6-15",{"$nulls":3},"Year 8"]
[]
[{"$nulls":17},"Developed By:"]
[{"$nulls":17},"Jason Fischbach"]
[{"$nulls":17},"Emerging Crops Outreach Specialist"]
[{"$nulls":17},"jason.fischbach@wisc.edu"]
[]
[]
[{"$nulls":20},"Helpful Tools"]
[]
[{"$nulls":20},"Iowa Custom Rate Guide"]
[{"$nulls":20},"Machinery Cost Calculator"]
[null,"Yield and Revenue",{"$nulls":3},"Harvest Costs",{"$nulls":3},"Row-Middle/Headland",{"$nulls":3},"Harvester Costs"]
[null,"Years 3-15",{"$nulls":3},"Years 3-15",{"$nulls":3},"Management"]

{"sheet":"Steps 1-6","index":1,"n_rows":37,"n_cols":14,"rows_kept":37,"merged":[[3,5,3,8],[3,10,7,13],[4,1,4,2],[8,10,8,13],[15,5,18,7],[18,10,18,13],[19,1,21,3],[24,5,28,8],[28,10,28,13],[29,1,29,3]]}
[]
[null,"Step 1",{"$nulls":3},"Step 3",{"$nulls":4},"Step 6a - Simple 3-wire 3D Fence"]
[null,"Determine Your Planting Arrangement",{"$nulls":3},"Determine Your Plant Costs",{"$nulls":4},"Determine Your Perimeter Deer Fence Cost (if used)"]
[{"$nulls":5},"Enter the plant type and source, number, and cost per plant.",{"$nulls":4},"Though hazelnuts are not preferred deer browse, a deer fence is recommended in areas with high deer pressure.  Three fencing options are provided below.  Enter costs as appropriate. Perimeter distance includes 15' buffer next to outer rows and headlands as entered in C14. At least 40' is recommended for headlands."]
[null,"Enter information about your hazelnut rows",{"$nulls":3},"Plant Type and Source","Cost/Plant","# of Plants*","Total Cost"]
[null,"Item","Value",null,null,"UMHDI half-sib seedlings",{"v":5,"d":"$5.00"},500,{"$f":"H6*G6","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Total Row Feet To Be Planted (ft)",15000,null,null,"UMHDI 1st Gen Varieties",{"v":5.25,"d":"$5.25"},2000,{"$f":"H7*G7","v":{"v":10500,"d":"$10,500.00"}}]
[null,"In-Row Plant Spacing (ft)",6,{"$nulls":5},{"$f":"H8*G8","v":0}]
[null,"total plants (#)",{"$f":"C7/C8","v":2500},{"$nulls":5},{"$f":"H9*G9","v":0},null,"Step 6a - Simple 3-wire 3D Fence"]
[null,"Row Width at Maturity (ft)",6,{"$nulls":5},{"$f":"H10*G10","v":0},null,"Items","#","unit cost","Total Cost"]
[null,"Total Planted Acres",{"$f":"(C7*C10)/43560","v":{"v":2.0661157024793386,"d":"2.07"}},null,null,"Totals",null,{"$f":"SUM(H6:H10)","v":2500},{"$f":"SUM(I6:I10)","v":{"v":13000,"d":"$13,000.00"}},null,"6' posts (2/20')",{"$f":"((((C7/C13)*2)+(C12*C13*2)+(15*4)+(C14*4))/20)*2","v":{"v":225.49473684210525,"d":"225"}},{"v":4.5,"d":"$4.50"},{"$f":"L11*M11","v":{"v":1014.7263157894737,"d":"$1,014.73"}}]
[null,"Row Spacing at Establishment (ft)",12,null,null,"* The total # of plants must match cell C9 of Step 1.",{"$nulls":4},"Corner posts with bracing",4,{"v":9,"d":"$9.00"},{"v":36,"d":"$36.00"}]
[null,"Number of Rows (#)",19,{"$nulls":7},"Wire/polyrope",{"$f":"(((C7/C13)*2)+(C13*C12*2)+(15*4)+(C14*4))*3","v":{"v":6764.8421052631575,"d":"6765"}},{"v":0.09,"d":"$0.09"},{"v":608.8357894736841,"d":"$608.84"}]
[null,"Headland length (ft)",40,null,null,"Step 4",{"$nulls":4},"Insulators 3 per 20' + corners",{"$f":"(L11/2)+((L11/2)*2)+12","v":{"v":350.2421052631579,"d":"350"}},{"$f":"5.49/25","v":{"v":0.21960000000000002,"d":"$0.22"}},{"v":76.91316631578948,"d":"$76.91"}]
[null,"Total Planting Size (acres)",{"$f":"(((C7/C13)+(C14*2))*((C12*C13)+30))/43560","v":{"v":5.1497752646078006,"d":"5.15"}},null,null,"Determine Your Tree Tube Costs (if used)",{"$nulls":4},"Gate hardware",1,{"v":30,"d":"$30.00"},{"v":30,"d":"$30.00"}]
[{"$nulls":5},"Tree tubes are used to protect plants from herbivory and wind in the first two years.  They can also act as an herbicide shield to allow use of glyphosate (Round-Up) in the establishment years.",{"$nulls":4},"Energizer/grounding rod",1,{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"}]
[{"$nulls":10},"Total 3D Fence",null,null,{"$f":"SUM(N11:N16)","v":{"v":2016.4752715789473,"d":"$2,016.48"}}]
[null,"Step 2"]
[null,"Determine Your Land Costs",{"$nulls":8},"Step 6b - 6 Wire Fence"]
[null,"Enter your annual land ownership costs on a per acre basis OR if you are renting land, enter your annual cash rent payment. ",{"$nulls":3},"Tree Tube Protector + Stake","Cost/Tube","Total Cost",null,null,"Items","#","unit cost","Total Cost"]
[{"$nulls":5},"24\" Vine Grow",{"v":2.2,"d":"$2.20"},{"$f":"C9*G21","v":{"v":5500,"d":"$5,500.00"}},null,null,"10' posts (1/20')",{"$f":"(((C7/C13)*2)+(C12*C13*2)+(15*4)+(C14*4))/20","v":{"v":112.74736842105263,"d":"113"}},null,{"$f":"L21*M21","v":0}]
[{"$nulls":10},"Corner posts with bracing",4,null,0]
[null,"Item","Cost/Yr","Unit",null,"Step 5",{"$nulls":4},"Wire/polyrope",{"$f":"((((C7/C13)*2)+(C12*C13*2)+(15*4)+(C14*4))*6)","v":{"v":13529.684210526315,"d":"13530"}},null,0]
[null,"Property taxes",null,"ac",null,"Determine Your Drip Irrigation Costs (If used)",{"$nulls":4},"Insulators 6 20' + corners",{"$f":"(L21*6)+(24)","v":{"v":700.4842105263158,"d":"700"}},null,0]
[null,"Mortgage (principal and/or interest)",null,"ac",null,"Some form of irrigation is essential in the establishment year.  This chart assumes use of drip irrigation arranged with 1/2\" poly feeder lines and a 1\" mainline attached to the water source.  If watering by hand from a tank leave this step blank.",{"$nulls":4},"Gate hardware",1,null,0]
[null,"Insurance",null,"ac",{"$nulls":6},"Energizer/grounding rod",1,null,0]
[null,"Total Cost Per Acre",{"$f":"SUM(C24:C26)","v":0},"ac",{"$nulls":6},"Total 3D Fence",null,null,{"$f":"SUM(N21:N26)","v":0}]
[null,"% Annual Increase",{"v":0.02,"d":"2%"}]
[{"$nulls":10},"Step 6c - 8' Woven Wire Fence - Installed"]
[null,"or",{"$nulls":3},"Item","#","unit cost","Total Cost",null,"Items","#","unit cost","Total Cost"]
[null,"Cash rent",{"v":100,"d":"$100.00"},"ac",null,"1/2\" feeder tubing",{"$f":"C7","v":15000},{"v":0.11,"d":"$0.11"},{"$f":"G31*H31","v":{"v":1650,"d":"$1,650.00"}},null,"Material costs (per lineal foot)",{"$f":"((C7/C13)*2)+(C12*C13*2)+(15*4)+(C14*4)","v":{"v":2254.9473684210525,"d":"2255"}},null,{"$f":"L31*M31","v":0}]
[null,"% Annual Increase",{"v":0.02,"d":"2%"},null,null,"1\" mainline",{"$f":"(C12*C13)+50","v":278},{"v":0.65,"d":"$0.65"},{"v":180.70000000000002,"d":"$180.70"},null,"Installation labor (per lineal foot)",{"$f":"L31","v":{"v":2254.9473684210525,"d":"2255"}},null,0]
[{"$nulls":5},"emitters (2/plant)",{"$f":"C9*2","v":5000},{"v":0.33,"d":"$0.33"},{"v":1650,"d":"$1,650.00"},null,"Total 3D Fence",null,null,{"$f":"SUM(N31:N32)","v":0}]
[{"$nulls":5},"end caps",{"$f":"C13+1","v":20},{"v":1.59,"d":"$1.59"},{"v":31.8,"d":"$31.80"}]
[{"$nulls":5},"T connectors",{"$f":"C13","v":19},{"v":2.59,"d":"$2.59"},{"v":49.209999999999994,"d":"$49.21"}]
[{"$nulls":5},"Head assembly and zone valves",1,{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"}]
[{"$nulls":5},"Total Drip System",null,null,{"$f":"SUM(I31:I36)","v":{"v":3661.71,"d":"$3,661.71"}}]

{"sheet":"Steps 7-8","index":2,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[1,1,2,9],[7,1,9,4],[7,6,9,9],[18,1,19,4],[20,6,21,9],[25,1,27,4],[38,1,38,4]]}
[null,"Site Preparation and Planting Year Costs (Years 0-1)"]
[null,"This enterprise budgeting tool assumes your planting has two parts: 1) the hazelnut rows, 2) the space between the rows (row middles).  For this model, enter your production costs on a lineal foot basis.  For example, when doing site preparation, how long does it take you to rototill a 1000' long row and how much does that cost you?  You'll enter information on how you manage your row-middles on the \"Alley-Cropping\" step."]
[]
[]
[]
[null,"Step 7a (Year 0)",{"$nulls":4},"Step 8 (Year 1 - Planting Year)"]
[null,"Determine Your Site Preparation Costs - Equipment",{"$nulls":4},"Determine Your Planting Year Costs - Equipment"]
[null,"List each action you use to prepare your rows for planting.  Enter the number of hours per year for each action and the cost per hour.  Lump the equipment cost with the operator labor cost.",{"$nulls":4},"List each action you use in the establishment year to plant, water, weed or otherwise take care of your hazelnuts.  Enter the number of hours per year for each action and the cost per hour.  Lump the equipment cost with the equipment operator labor cost."]
[]
[]
[null,"Action","Hours/1000 lineal feet","Cost/hr","Cost/Yr",null,"Action","Hours/1000 lineal feet","Cost/hr","Cost/Yr"]
[null,"Herbicide burndown (strips) - ATV sprayer",0.5,{"v":40,"d":"$40.00"},{"$f":"C12*D12*('Steps 1-6'!$C$7/1000)","v":{"v":300,"d":"$300.00"}},null,"In row weed control (herbicide) - backpack sprayer",0.25,{"v":20,"d":"$20.00"},{"$f":"H12*I12*('Steps 1-6'!$C$7/1000)","v":{"v":75,"d":"$75.00"}}]
[null,"Ripping (strips) - tractor and implement",0.25,{"v":80,"d":"$80.00"},{"$f":"C13*D13*('Steps 1-6'!$C$7/1000)","v":{"v":300,"d":"$300.00"}},{"$nulls":4},{"$f":"H13*I13*('Steps 1-6'!$C$7/1000)","v":0}]
[null,"Rototilling (strips) - tractor and implement",0.5,{"v":80,"d":"$80.00"},{"$f":"C14*D14*('Steps 1-6'!$C$7/1000)","v":{"v":600,"d":"$600.00"}},{"$nulls":4},{"$f":"H14*I14*('Steps 1-6'!$C$7/1000)","v":0}]
[{"$nulls":4},{"$f":"C15*D15*('Steps 1-6'!$C$7/1000)","v":0},{"$nulls":4},{"$f":"H15*I15*('Steps 1-6'!$C$7/1000)","v":0}]
[{"$nulls":4},{"$f":"C16*D16*('Steps 1-6'!$C$7/1000)","v":0},{"$nulls":4},{"$f":"H16*I16*('Steps 1-6'!$C$7/1000)","v":0}]
[{"$nulls":9},{"$f":"H17*I17*('Steps 1-6'!$C$7/1000)","v":0}]
[null,"Labor",{"$nulls":7},{"$f":"H18*I18*('Steps 1-6'!$C$7/1000)","v":0}]
[null,"List each action requiring hand labor, management, or consultants.  Note: labor for actions using equipment is included in the table above."]
[{"$nulls":6},"Labor"]
[null,"Action","Hours/yr","Cost/hr","Cost/Yr",null,"List each action requiring hand labor, management, or consultants in the establishment year.  Note: labor for actions using equipment is included in the table above."]
[null,"Project coordination/planning/consultant",0,0,{"$f":"C22*D22","v":0}]
[{"$nulls":6},"Action","Hours/1000 lineal feet","Cost/hr","Cost/yr"]
[null,"Step 7b",{"$nulls":4},"Project coordination/planning/consultant",null,null,{"$f":"H24*I24*('Steps 1-6'!$C$7/1000)","v":0}]
[null,"Determine Your Mulch and/or Herbicide Costs (Year 0 and 1)",{"$nulls":4},"Planting",2,{"v":18,"d":"$18.00"},{"$f":"H25*I25*('Steps 1-6'!$C$7/1000)","v":{"v":540,"d":"$540.00"}}]
[null,"Enter the type of mulch, the amount per plant, and the cost per unit.  Enter the herbicide name, the amount per unit, and cost per unit.  Leave the yellow boxes blank if not using mulch and/or herbicides.",{"$nulls":4},"Installing tree tubes",3,{"v":18,"d":"$18.00"},{"$f":"H26*I26*('Steps 1-6'!$C$7/1000)","v":{"v":810,"d":"$810.00"}}]
[{"$nulls":6},"Installing drip irrigation",3,{"v":18,"d":"$18.00"},{"$f":"H27*I27*('Steps 1-6'!$C$7/1000)","v":{"v":810,"d":"$810.00"}}]
[{"$nulls":6},"Applying mulch (organic or synthetic)",3,{"v":18,"d":"$18.00"},{"$f":"H28*I28*('Steps 1-6'!$C$7/1000)","v":{"v":810,"d":"$810.00"}}]
[null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost",null,"Deer repellent application",0.5,{"v":18,"d":"$18.00"},{"$f":"H29*I29*('Steps 1-6'!$C$7/1000)","v":{"v":135,"d":"$135.00"}}]
[null,"wood chips",0.05,{"v":6.6,"d":"$6.60"},{"$f":"C30*'Steps 1-6'!C9*D30","v":{"v":825,"d":"$825.00"}},{"$nulls":4},{"$f":"H30*I30*('Steps 1-6'!$C$7/1000)","v":0}]
[{"$nulls":9},{"$f":"H31*I31*('Steps 1-6'!$C$7/1000)","v":0}]
[null,"Item - Synthetic mulch","Row Feet","Cost/ft","Total Cost"]
[null,null,{"$f":"'Steps 1-6'!C7","v":15000},null,{"$f":"C33*D33","v":0}]
[]
[null,"Herbicide/Deer Repellent","Unit","Cost/Unit","Total Cost"]
[null,"Round-up before tillage and spots after",0.5,{"v":18,"d":"$18.00"},{"$f":"C36*D36","v":{"v":9,"d":"$9.00"}}]
[null,"Plant Skydd",1,{"v":80,"d":"$80.00"},{"$f":"C37*D37","v":{"v":80,"d":"$80.00"}}]
[{"$nulls":4},{"$f":"C38*D38","v":0}]
[]
[null,"Fertilizer","lbs/ac","Cost/Unit","Total Cost"]
[null,"ESN-urea",80,{"v":0.86,"d":"$0.86"},{"$f":"D41*C41*('Steps 1-6'!$C$11)","v":{"v":142.14876033057848,"d":"$142.15"}}]
[null,"Potassium sulfate",200,{"v":0.69,"d":"$0.69"},{"$f":"D42*C42*('Steps 1-6'!$C$11)","v":{"v":285.12396694214874,"d":"$285.12"}}]
[null,"Triple super phosphate",50,{"v":0.7,"d":"$0.70"},{"$f":"D43*C43*('Steps 1-6'!$C$11)","v":{"v":72.31404958677685,"d":"$72.31"}}]

{"sheet":"Step 9","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"merged":[[6,1,8,4],[6,6,8,9],[17,1,18,4],[17,6,17,9],[25,6,26,7]]}
[null,"Early Production Costs (Years 2-5)"]
[null,"As with Steps 7-8, only enter the production costs for the hazelnut rows.  Do not enter costs for managing between the rows.  Those costs are entered in the \"Alley-Cropping\" step."]
[null,"Enter the costs on a 1000 lineal feet basis.  In other words, how long does it take you to weed whip 1000 lineal feet and how much does that cost you?"]
[]
[null,"Step 9a (Years 2-5)",{"$nulls":4},"Step 9b"]
[null,"Determine Your Annual Early-Production Costs - Equipment",{"$nulls":4},"Determine Your Mulch, Fertilizer, and/or Herbicide Costs (Year 2-5)"]
[null,"List each action you use to maintain your plants in the pre-production years.  Enter the number of hours per year for each action and the cost per hour.  Lump the equipment costs with the operator labor costs.",{"$nulls":4},"Enter the type of mulch, the amount per plant, and the cost per unit.  Enter the herbicide name, the amount per unit, and cost per unit.  Leave the yellow boxes blank if not using mulch, fertilizer, and/or herbicides."]
[]
[]
[null,"Action","Hours/1000 lineal feet/yr","Cost/hr","Cost/Yr",null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost"]
[{"$nulls":4},{"$f":"C11*D11*('Steps 1-6'!$C$7/1000)","v":0},{"$nulls":4},{"$f":"H11*'Steps 1-6'!C9*I11","v":0}]
[null,"In row weed control (herbicide) - backpack sprayer",0.25,{"v":20,"d":"$20.00"},{"$f":"C12*D12*('Steps 1-6'!$C$7/1000)","v":{"v":75,"d":"$75.00"}}]
[null,"In row weed control (weed whip)",0.5,{"v":20,"d":"$20.00"},{"$f":"C13*D13*('Steps 1-6'!$C$7/1000)","v":{"v":150,"d":"$150.00"}},null,"Herbicide/Deer Repellent","Units","Cost/Unit","Total Cost"]
[null,"Deer repellent - backpack sprayer",0.25,{"v":20,"d":"$20.00"},{"$f":"C14*D14*('Steps 1-6'!$C$7/1000)","v":{"v":75,"d":"$75.00"}},null,"glyphosate",0.5,{"v":18,"d":"$18.00"},{"$f":"H14*I14","v":{"v":9,"d":"$9.00"}}]
[{"$nulls":4},{"$f":"C15*D15*('Steps 1-6'!$C$7/1000)","v":0},null,"Poast",0.5,{"v":40,"d":"$40.00"},{"$f":"H15*I15","v":{"v":20,"d":"$20.00"}}]
[{"$nulls":9},{"$f":"H16*I16","v":0}]
[null,"Labor",{"$nulls":7},{"$f":"H17*I17","v":0}]
[null,"List each action requiring hand labor, management, or consultants.  Note: labor for actions using equipment is included in the table above."]
[{"$nulls":6},"Fertilizer","lbs/ac","Cost/Unit","Total Cost"]
[null,"Action","Hours/1000 lineal feet/yr","Cost/hr","Cost/Yr",null,"ESN-urea",80,{"v":0.86,"d":"$0.86"},{"$f":"I20*H20*'Steps 1-6'!$C$11","v":{"v":142.14876033057848,"d":"$142.15"}}]
[null,"Hand fertilizing",0.25,{"v":18,"d":"$18.00"},{"$f":"C21*D21*('Steps 1-6'!$C$7/1000)","v":{"v":67.5,"d":"$67.50"}}]
[null,"Deer repellent application",0.25,{"v":18,"d":"$18.00"},{"$f":"C22*D22*('Steps 1-6'!$C$7/1000)","v":{"v":67.5,"d":"$67.50"}},{"$nulls":4},{"$f":"I22*H22*'Steps 1-6'!$C$11","v":0}]
[{"$nulls":4},{"$f":"C23*D23","v":0}]
[{"$nulls":4},{"$f":"C24*D24","v":0},null,"Step 9c"]
[{"$nulls":6},"Determine Your Re-Plant Plant Costs"]
[{"$nulls":6},"Enter your percent mortality and the cost of each replacement plant."]
[]
[{"$nulls":6},"Item","Value"]
[{"$nulls":6},"Percent Replacement",{"v":0.03,"d":"3%"}]
[{"$nulls":6},"Total Plants",{"$f":"H29*'Steps 1-6'!$C$9","v":75}]
[{"$nulls":6},"Plant Cost",{"v":5.75,"d":"$5.75"}]

{"sheet":"Step 10","index":4,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,9],[6,1,8,4],[6,6,8,9],[17,6,17,9]]}
[null,"Full Production Costs (Years 6-15)"]
[null,"As with Steps 7-8, only enter the production costs for the hazelnut rows.  Do not enter costs for managing between the rows.  Those costs are entered in the \"Alley-Cropping\" step. Enter the costs on a 1000 lineal feet basis.  In other words, how long does it take you to weed whip 1000 lineal feet and how much does that cost you?"]
[]
[]
[null,"Step 10a (Years 5-8)",{"$nulls":4},"Step 10b"]
[null,"Determine Your Annual Early Production Costs - Equipment",{"$nulls":4},"Determine Your Mulch, Fertilizer, and/or Herbicide Costs (Years 5-8)"]
[null,"List each action you use to maintain your plants in the early-production years.  Enter the number of hours per year for each action and the cost per hour.  Lump the equipment costs with the operator labor costs.",{"$nulls":4},"Enter the type of mulch, the amount per plant, and the cost per unit.  Enter the herbicide name, the amount per unit, and cost per unit.  Leave the yellow boxes blank if not using mulch, fertilizer, and/or herbicides."]
[]
[]
[null,"Action","Hours/1000 lineal feet/yr","Cost/hr","Cost/yr",null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost"]
[null,"In row weed control (herbicide) - backpack sprayer",0.25,{"v":20,"d":"$20.00"},{"$f":"C11*D11*('Steps 1-6'!$C$7/1000)","v":{"v":75,"d":"$75.00"}},{"$nulls":4},{"$f":"H11*'Steps 1-6'!C9*I11","v":0}]
[null,"In row weed control (weed whip)",0.5,{"v":20,"d":"$20.00"},{"$f":"C12*D12*('Steps 1-6'!$C$7/1000)","v":{"v":150,"d":"$150.00"}}]
[{"$nulls":4},{"$f":"C13*D13*('Steps 1-6'!$C$7/1000)","v":0},null,"Herbicide/Deer Repellent","Units","Cost/Unit","Total Cost"]
[{"$nulls":9},{"$f":"H14*I14","v":0}]
[null,"Labor",{"$nulls":7},{"$f":"H15*I15","v":0}]
[null,"Action","Hours/1000 lineal feet/yr","Cost/hr","Cost/yr",{"$nulls":4},{"$f":"H16*I16","v":0}]
[null,"Hand fertilizing",0.25,{"v":18,"d":"$18.00"},{"$f":"C17*D17*('Steps 1-6'!$C$7/1000)","v":{"v":67.5,"d":"$67.50"}},{"$nulls":4},{"$f":"H17*I17","v":0}]
[{"$nulls":4},{"$f":"C18*D18*('Steps 1-6'!$C$7/1000)","v":0}]
[{"$nulls":4},{"$f":"C19*D19*('Steps 1-6'!$C$7/1000)","v":0},null,"Fertilizer","lbs/ac","Cost/Unit","Total Cost"]
[{"$nulls":4},{"$f":"C20*D20*('Steps 1-6'!$C$7/1000)","v":0},null,"ESN-Urea",80,{"v":0.89,"d":"$0.89"},{"$f":"H20*I20*'Steps 1-6'!$C$11","v":{"v":147.1074380165289,"d":"$147.11"}}]
[{"$nulls":9},{"$f":"H21*I21*'Steps 1-6'!$C$11","v":0}]
[{"$nulls":9},{"$f":"H22*I22*'Steps 1-6'!$C$11","v":0}]
[{"$nulls":9},{"$f":"H23*I23*'Steps 1-6'!$C$11","v":0}]

{"sheet":"Step 11","index":5,"n_rows":29,"n_cols":8,"rows_kept":29,"merged":[[2,1,4,7],[8,1,10,4],[8,6,9,7],[21,1,22,4]]}
[]
[null,"Note About Renovation"]
[null,"If planting seedlings (plants originating from seeds) it is likely that by Year 8 after planting some plants will be inferior to others with less vigor or low yields.  Some growers choose to remove the poorest plants and replace them with new plants.  If you do not plan to renovate leave the yellow boxes blank."]
[]
[]
[]
[null,"Step 11a (Year 8)",{"$nulls":4},"Step 11b"]
[null,"Determine Your Renovation Costs - Equipment",{"$nulls":4},"Determine Your Renovation Plant Costs"]
[null,"List each action you use to renovate your planting.  Enter the number of hours per year for each action and the cost per hour.  Lump the equipment costs with the operator labor costs.",{"$nulls":4},"Enter the percent of plants you plan on replacing and the cost per plant"]
[]
[{"$nulls":6},"Item","Value"]
[null,"Action","Hours/yr","Cost/hr","Cost/yr",null,"Percent Replacement"]
[{"$nulls":4},{"$f":"C13*D13","v":0},null,"Total Plants",{"$f":"H12*'Steps 1-6'!C9","v":0}]
[{"$nulls":4},{"$f":"C14*D14","v":0},null,"Plant Cost"]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[]
[null,"Labor"]
[null,"List each action requiring hand labor, management, or consultants.  Note: labor for actions using equipment is included in the table above."]
[]
[null,"Action","Hours/yr","Cost/hr","Cost/yr"]
[{"$nulls":4},{"$f":"C25*D25","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"Step 12","index":6,"n_rows":29,"n_cols":17,"rows_kept":29,"merged":[[2,1,7,6],[3,8,4,16],[7,12,7,13],[8,3,8,4],[8,5,8,6],[8,12,8,13],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,12,9,13],[10,1,10,2],[10,3,10,4],[10,5,10,6],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[11,9,11,10],[11,11,11,12],[28,1,35,6]]}
[]
[null,"Step 12a Yield Projections",{"$nulls":6},"Step 12b Production Volumes and Revenue"]
[null,"First, enter what percentage of your rows will be covered by hazelnut canopy in each year. Then, enter what percentage of your plants are improved cultivars and what percentage are seedlings (plants from seeds). Then, enter the average percent kernel. Finally, adjust the average projected yields based on whether you think your yields will be higher or lower than the baseline standard. Yields are expressed as ounces of kernel per square foot of canopy coverage.",{"$nulls":6},"Determine Your Annual Harvest Production"]
[{"$nulls":8},"To determine revenue, enter the name of each market to which you sell your in-shell nuts and the price paid to you for each market.  Enter the % of the total harvest sold to each market."]
[]
[]
[]
[{"$nulls":11},"Market 1:","AHC",null,"Price:",{"v":1.5,"d":"$1.50"},"$/lb"]
[{"$nulls":3},"Improved Cultivars",null,"Seedlings",{"$nulls":5},"Market 2:",null,null,"Price:",null,"$/lb"]
[null,"% of Your Planting:",null,{"v":0.9,"d":"90%"},null,{"v":0.1,"d":"10%"},{"$nulls":5},"Market 3:",null,null,"Price:",null,"$/lb"]
[null,"Average % kernel:",null,{"v":0.38,"d":"38%"},null,{"v":0.33,"d":"33%"}]
[{"$nulls":3},"ounces of kernel/sq ft (UMHDI Projection)","ounces of kernel/sq ft (Your Projection)","ounces of kernel/sq ft (UMHDI Projection)","ounces of kernel/sq ft (Your Projection)",null,null,"Cultivars",null,"Seedlings",null,"Total"]
[null,"Year","in-row canopy coverage",{"$nulls":5},"Year","total kernel yield","total in-shell yield","total kernel yield","total in-shell yield","planting in-shell yield","% market 1","% market 2","% market 3"]
[null,3,{"v":0.25,"d":"25%"},0.02,0.02,{"$f":"D14*0.6","v":{"v":0.012,"d":"0.01"}},0.01,null,3,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C14)*$D$10)*E14)/16","v":{"v":25.3125,"d":"25"}},{"$f":"J14/$D$11","v":{"v":66.61184210526315,"d":"67"}},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C14)*$F$10)*G14)/16","v":{"v":1.40625,"d":"1"}},{"$f":"L14/$F$11","v":{"v":4.261363636363636,"d":"4"}},{"$f":"K14+M14","v":{"v":70.87320574162679,"d":"71"}},{"v":1,"d":"100%"}]
[null,4,{"v":0.45,"d":"45%"},0.17,0.17,{"$f":"D15*0.6","v":{"v":0.10200000000000001,"d":"0.10"}},0.1,null,4,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C15)*$D$10)*E15)/16","v":{"v":387.28125,"d":"387"}},{"$f":"J15/$D$11","v":{"v":1019.1611842105264,"d":"1019"}},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C15)*$F$10)*G15)/16","v":{"v":25.3125,"d":"25"}},{"$f":"L15/$F$11","v":{"v":76.70454545454545,"d":"77"}},{"$f":"K15+M15","v":{"v":1095.8657296650717,"d":"1096"}},{"v":1,"d":"100%"}]
[null,5,{"v":0.75,"d":"75%"},0.28,0.28,{"v":0.168,"d":"0.17"},0.17,null,5,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C16)*$D$10)*E16)/16","v":{"v":1063.125,"d":"1063"}},{"v":2797.6973684210525,"d":"2798"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C16)*$F$10)*G16)/16","v":{"v":71.71875,"d":"72"}},{"v":217.32954545454544,"d":"217"},{"v":3015.026913875598,"d":"3015"},{"v":1,"d":"100%"}]
[null,6,{"v":0.85,"d":"85%"},0.42,0.42,{"v":0.252,"d":"0.25"},0.25,null,6,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C17)*$D$10)*E17)/16","v":{"v":1807.3125,"d":"1807"}},{"v":4756.085526315789,"d":"4756"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C17)*$F$10)*G17)/16","v":{"v":119.53125,"d":"120"}},{"v":362.21590909090907,"d":"362"},{"v":5118.301435406698,"d":"5118"},{"v":1,"d":"100%"}]
[null,7,{"v":0.9,"d":"90%"},0.62,0.62,{"v":0.372,"d":"0.37"},0.37,null,7,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C18)*$D$10)*E18)/16","v":{"v":2824.875,"d":"2825"}},{"v":7433.881578947368,"d":"7434"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C18)*$F$10)*G18)/16","v":{"v":187.3125,"d":"187"}},{"v":567.6136363636364,"d":"568"},{"v":8001.495215311004,"d":"8001"},{"v":1,"d":"100%"}]
[null,8,{"v":1,"d":"100%"},0.66,0.66,{"v":0.396,"d":"0.40"},0.4,null,8,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C19)*$D$10)*E19)/16","v":{"v":3341.25,"d":"3341"}},{"v":8792.763157894737,"d":"8793"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C19)*$F$10)*G19)/16","v":225},{"v":681.8181818181818,"d":"682"},{"v":9474.581339712919,"d":"9475"},{"v":1,"d":"100%"}]
[null,9,{"v":1,"d":"100%"},0.72,0.72,{"v":0.432,"d":"0.43"},0.43,null,9,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C20)*$D$10)*E20)/16","v":3645},{"v":9592.105263157895,"d":"9592"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C20)*$F$10)*G20)/16","v":{"v":241.875,"d":"242"}},{"v":732.9545454545454,"d":"733"},{"v":10325.059808612441,"d":"10325"},{"v":1,"d":"100%"}]
[null,10,{"v":1,"d":"100%"},0.72,0.72,{"v":0.432,"d":"0.43"},0.43,null,10,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C21)*$D$10)*E21)/16","v":3645},{"v":9592.105263157895,"d":"9592"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C21)*$F$10)*G21)/16","v":{"v":241.875,"d":"242"}},{"v":732.9545454545454,"d":"733"},{"v":10325.059808612441,"d":"10325"},{"v":1,"d":"100%"}]
[null,11,{"v":1,"d":"100%"},0.85,0.85,0.51,0.51,null,11,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C22)*$D$10)*E22)/16","v":{"v":4303.125,"d":"4303"}},{"v":11324.013157894737,"d":"11324"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C22)*$F$10)*G22)/16","v":{"v":286.875,"d":"287"}},{"v":869.3181818181818,"d":"869"},{"v":12193.331339712919,"d":"12193"},{"v":1,"d":"100%"}]
[null,12,{"v":1,"d":"100%"},0.72,0.72,{"v":0.432,"d":"0.43"},0.43,null,12,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C23)*$D$10)*E23)/16","v":3645},{"v":9592.105263157895,"d":"9592"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C23)*$F$10)*G23)/16","v":{"v":241.875,"d":"242"}},{"v":732.9545454545454,"d":"733"},{"v":10325.059808612441,"d":"10325"},{"v":1,"d":"100%"}]
[null,13,{"v":1,"d":"100%"},0.85,0.85,0.51,0.51,null,13,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C24)*$D$10)*E24)/16","v":{"v":4303.125,"d":"4303"}},{"v":11324.013157894737,"d":"11324"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C24)*$F$10)*G24)/16","v":{"v":286.875,"d":"287"}},{"v":869.3181818181818,"d":"869"},{"v":12193.331339712919,"d":"12193"},{"v":1,"d":"100%"}]
[null,14,{"v":1,"d":"100%"},0.72,0.72,{"v":0.432,"d":"0.43"},0.43,null,14,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C25)*$D$10)*E25)/16","v":3645},{"v":9592.105263157895,"d":"9592"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C25)*$F$10)*G25)/16","v":{"v":241.875,"d":"242"}},{"v":732.9545454545454,"d":"733"},{"v":10325.059808612441,"d":"10325"},{"v":1,"d":"100%"}]
[null,15,{"v":1,"d":"100%"},0.85,0.85,0.51,0.51,null,15,{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C26)*$D$10)*E26)/16","v":{"v":4303.125,"d":"4303"}},{"v":11324.013157894737,"d":"11324"},{"$f":"(((('Steps 1-6'!$C$7*'Steps 1-6'!$C$10)*C26)*$F$10)*G26)/16","v":{"v":286.875,"d":"287"}},{"v":869.3181818181818,"d":"869"},{"v":12193.331339712919,"d":"12193"},{"v":1,"d":"100%"}]
[]
[null,"A Note on Yield Projections:"]
[null,"The UMHDI yield projections shown are based on average yields of the 1st Generation cultivars as measured at the UMHDI Germplasm Trial in Bayfield, WI.  Actual yields for your planting are likely to vary considerably.  We use ounces of kernel per square foot of canopy coverage (yield density) because it better accounts for variation in plant size, making it easier to compare yields across a range of sites and plant ages.  Thus, total yield from a planting depends on yield density and total canopy coverage."]

{"sheet":"Step 13","index":7,"n_rows":27,"n_cols":15,"rows_kept":27,"merged":[[3,1,6,4],[3,6,5,9],[3,14,3,15],[4,14,4,15],[5,14,5,15],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,11,14,15]]}
[]
[null,"Step 13a Harvest Costs",{"$nulls":4},"Step 13b (Drying and Husking Costs)",{"$nulls":4},"Hazelnut De-Husking Options (For Step 13b)"]
[null,"Determine Your Annual Harvest Cost",{"$nulls":4},"Determine Your Annual Drying and Husking Costs"]
[null,"For each year choose whether to harvest by hand or with a machine.  Use the \"Harvester 1.0\" tab to determine machine harvester costs or enter a custom rate if known.",{"$nulls":4},"Enter the labor and equipment costs for husking and drying the hazelnuts",{"$nulls":4},"Option","lbs/hr","Custom Rate ($/lb)","Equipment Ownership Cost*"]
[{"$nulls":11},"Hand husking"]
[{"$nulls":11},"Bucket husker"]
[{"$nulls":7},"Husker Flow-Through Rate:",400,"lbs/hr",null,"Super Squirrel husker"]
[{"$nulls":7},"Hrs of labor/hr of operation:",{"v":0,"d":"0.00"},"hrs",null,"UW-Extension drum husker"]
[null,null,"Hand Harvest Rate:",13,"lbs/hr",null,null,"Labor Rate:",{"v":10,"d":"$10.00"},"$/hr",null,"Hasatsan husker"]
[null,null,"Hand Harvest Labor:",{"v":15,"d":"$15.00"},"$/hr",null,null,"Husker Lease Rate:",0,"$/hr",null,"X12 drum husker"]
[null,null,"Machine Harvest Rate:",{"$f":"'harvester 1.0'!F13","v":4050},"lbs/hr",{"$nulls":6},"Other"]
[null,null,"Machine Custom Rate:",{"$f":"'harvester 1.0'!F20","v":{"v":967.6931428571429,"d":"$967.69"}},"$/lhr",null,"Year","Lbs harvested","Cost/Yr",null,null,"* The annual ownership and maintenance cost ammortized over 7 years.  If the husking equipment is owned, use this annual cost and divide by the annual nut production to determine the annual cost per lb to enter in Step13b."]
[{"$nulls":6},3,{"$f":"'Step 12'!M14","v":{"v":4.261363636363636,"d":"4"}},{"$f":"((H13/$I$7)*$I$10)+(((H13/$I$7)*$I$8)*$I$9)","v":0}]
[null,"Year","Machine/Hand","Cost/Yr",null,null,4,{"$f":"'Step 12'!M15","v":{"v":76.70454545454545,"d":"77"}},0]
[null,3,"Hand",{"$f":"IF(C15=\"Hand\",(('Step 12'!N14/$D$9)*$D$10),(('Step 12'!N14/$D$11)*$D$12))","v":{"v":81.77677585572322,"d":"$81.78"}},null,null,5,{"$f":"'Step 12'!M16","v":{"v":217.32954545454544,"d":"217"}},0]
[null,4,"Machine",{"$f":"IF(C16=\"Hand\",(('Step 12'!N15/$D$9)*$D$10),(('Step 12'!N15/$D$11)*$D$12))","v":{"v":261.84240792321714,"d":"$261.84"}},null,null,6,{"$f":"'Step 12'!M17","v":{"v":362.21590909090907,"d":"362"}},0]
[null,5,"Machine",{"$f":"IF(C17=\"Hand\",(('Step 12'!N16/$D$9)*$D$10),(('Step 12'!N16/$D$11)*$D$12))","v":{"v":720.4002148363332,"d":"$720.40"}},null,null,7,{"$f":"'Step 12'!M18","v":{"v":567.6136363636364,"d":"568"}},0]
[null,6,"Machine",{"$f":"IF(C18=\"Hand\",(('Step 12'!N17/$D$9)*$D$10),(('Step 12'!N17/$D$11)*$D$12))","v":{"v":1222.949432621959,"d":"$1,222.95"}},null,null,8,{"$f":"'Step 12'!M19","v":{"v":681.8181818181818,"d":"682"}},0]
[null,7,"Machine",{"$f":"IF(C19=\"Hand\",(('Step 12'!N18/$D$9)*$D$10),(('Step 12'!N18/$D$11)*$D$12))","v":{"v":1911.8498894964684,"d":"$1,911.85"}},null,null,9,{"$f":"'Step 12'!M20","v":{"v":732.9545454545454,"d":"733"}},0]
[null,8,"Machine",{"$f":"IF(C20=\"Hand\",(('Step 12'!N19/$D$9)*$D$10),(('Step 12'!N19/$D$11)*$D$12))","v":{"v":2263.824047872206,"d":"$2,263.82"}},null,null,10,{"$f":"'Step 12'!M21","v":{"v":732.9545454545454,"d":"733"}},0]
[null,9,"Machine",{"$f":"IF(C21=\"Hand\",(('Step 12'!N20/$D$9)*$D$10),(('Step 12'!N20/$D$11)*$D$12))","v":{"v":2467.0344633047266,"d":"$2,467.03"}},null,null,11,{"$f":"'Step 12'!M22","v":{"v":869.3181818181818,"d":"869"}},0]
[null,10,"Machine",{"$f":"IF(C22=\"Hand\",(('Step 12'!N21/$D$9)*$D$10),(('Step 12'!N21/$D$11)*$D$12))","v":{"v":2467.0344633047266,"d":"$2,467.03"}},null,null,12,{"$f":"'Step 12'!M23","v":{"v":732.9545454545454,"d":"733"}},0]
[null,11,"Machine",{"$f":"IF(C23=\"Hand\",(('Step 12'!N22/$D$9)*$D$10),(('Step 12'!N22/$D$11)*$D$12))","v":{"v":2913.4328706235287,"d":"$2,913.43"}},null,null,13,{"$f":"'Step 12'!M24","v":{"v":869.3181818181818,"d":"869"}},0]
[null,12,"Machine",{"$f":"IF(C24=\"Hand\",(('Step 12'!N23/$D$9)*$D$10),(('Step 12'!N23/$D$11)*$D$12))","v":{"v":2467.0344633047266,"d":"$2,467.03"}},null,null,14,{"$f":"'Step 12'!M25","v":{"v":732.9545454545454,"d":"733"}},0]
[null,13,"Machine",{"$f":"IF(C25=\"Hand\",(('Step 12'!N24/$D$9)*$D$10),(('Step 12'!N24/$D$11)*$D$12))","v":{"v":2913.4328706235287,"d":"$2,913.43"}},null,null,15,{"$f":"'Step 12'!M26","v":{"v":869.3181818181818,"d":"869"}},0]
[null,14,"Machine",{"$f":"IF(C26=\"Hand\",(('Step 12'!N25/$D$9)*$D$10),(('Step 12'!N25/$D$11)*$D$12))","v":{"v":2467.0344633047266,"d":"$2,467.03"}}]
[null,15,"Machine",{"$f":"IF(C27=\"Hand\",(('Step 12'!N26/$D$9)*$D$10),(('Step 12'!N26/$D$11)*$D$12))","v":{"v":2913.4328706235287,"d":"$2,913.43"}}]

{"sheet":"alley-cropping","index":8,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[3,11,3,14],[3,16,4,17],[4,0,5,9],[4,11,6,14],[5,16,6,17],[6,3,6,5],[6,6,6,8],[15,16,16,17]]}
["Alley-Cropping"]
["Use this tool to determine your income (or expenses) from the borders, headlands, and row-middles of your planting."]
[]
["Step 1. Row-Middle/Headland Management",{"$nulls":10},"Step 2. Alley-Cropping Income/Expense",{"$nulls":4},"Step 3. Mowing Costs"]
["Enter the width of the hazelnut rows to determine the area available for alley-cropping. Enter the percentage of the row-middles and headlands that are mowed or alley-cropped each year.",{"$nulls":10},"Enter the following information per year to determine your annual alley-cropping income per year."]
[{"$nulls":16},"If not alley-cropping, use Step 3 to determine your annual mowing costs."]
[{"$nulls":3},"Row Middles",null,null,"Headlands"]
["Year","Hazelnut Row Width","Row Middle Width","Acres","% mowed","% alley-cropped","Acres","% mowed","% alley-cropped","Total Income or Cost",null,"Year","Per Acre Total Costs ($/ac):","Per Acre Total Revenue ($/ac):","Total Alley-Cropping Income per acre",null,"Time to Drive 100ft (min):",{"v":0.57,"d":"0.6"}]
[1,3,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B9","v":9},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B9))*'Steps 1-6'!$C$13)/43560","v":{"v":3.0991735537190084,"d":"3.1"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"(D9*E9*$R$15)+(G9*H9*$R$15)+(D9*F9*O9)+(G9*I9*O9)","v":{"v":565.6847107438017,"d":"$565.68"}},null,1,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"$f":"N9-M9","v":{"v":200,"d":"$200.00"}},null,"Mower Width (ft):",4]
[2,3,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B10","v":9},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B10))*'Steps 1-6'!$C$13)/43560","v":{"v":3.0991735537190084,"d":"3.1"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":565.6847107438017,"d":"$565.68"},null,2,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"$f":"N10-M10","v":{"v":200,"d":"$200.00"}},null,"Mower Efficiency (%)*:",{"v":0.8,"d":"80%"}]
[3,3,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B11","v":9},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B11))*'Steps 1-6'!$C$13)/43560","v":{"v":3.0991735537190084,"d":"3.1"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":565.6847107438017,"d":"$565.68"},null,3,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"Hrs/acre:",{"$f":"(((43560/(R9*100))*R8)/60)/R10","v":{"v":1.2931875,"d":"1.3"}}]
[4,3,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B12","v":9},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B12))*'Steps 1-6'!$C$13)/43560","v":{"v":3.0991735537190084,"d":"3.1"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":565.6847107438017,"d":"$565.68"},null,4,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"Mowings/ac/yr:",4]
[5,4,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B13","v":8},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B13))*'Steps 1-6'!$C$13)/43560","v":{"v":2.7548209366391183,"d":"2.8"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":496.8141873278237,"d":"$496.81"},null,5,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"Total hrs/ac/yr:",{"$f":"R11*R12","v":{"v":5.17275,"d":"5.2"}}]
[6,4.5,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B14","v":7.5},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B14))*'Steps 1-6'!$C$13)/43560","v":{"v":2.5826446280991737,"d":"2.6"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":462.3789256198347,"d":"$462.38"},null,6,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"Cost per hour (mower + operator):",{"v":25,"d":"$25.00"}]
[7,5,{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B15","v":7},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B15))*'Steps 1-6'!$C$13)/43560","v":{"v":2.4104683195592287,"d":"2.4"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":427.94366391184576,"d":"$427.94"},null,7,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"Cost per Acre Per Year:",{"$f":"-R14*R13","v":{"v":-129.31875,"d":"$(129.32)"}}]
[8,{"$f":"'Steps 1-6'!C10","v":6},{"$f":"'Steps 1-6'!$C$12-'alley-cropping'!B16","v":6},{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B16))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":359.07314049586785,"d":"$359.07"},null,8,{"v":500,"d":"$500.00"},{"v":700,"d":"$700.00"},{"v":200,"d":"$200.00"},null,"*Percent of time mowing, as opposed to turning or mowing the same ground"]
[9,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B17))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-321.3375,"d":"$(321.34)"},null,9,null,null,0]
[10,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B18))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-321.3375,"d":"$(321.34)"},null,10,null,null,0]
[11,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B19))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-54.15,"d":"$(54.15)"},null,11,null,null,0]
[12,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B20))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-54.15,"d":"$(54.15)"},null,12,null,null,0]
[13,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B21))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-54.15,"d":"$(54.15)"},null,13,null,null,0]
[14,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B22))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-54.15,"d":"$(54.15)"},null,14,null,null,0]
[15,6,6,{"$f":"((('Steps 1-6'!$C$7/'Steps 1-6'!$C$13)*('Steps 1-6'!$C$12-B23))*'Steps 1-6'!$C$13)/43560","v":{"v":2.066115702479339,"d":"2.1"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"((('Steps 1-6'!$C$13*'Steps 1-6'!$C$12)*40)*2)/43560","v":{"v":0.418732782369146,"d":"0.4"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"v":-54.15,"d":"$(54.15)"},null,15,null,null,0]

{"sheet":"harvester 1.0","index":9,"n_rows":34,"n_cols":6,"rows_kept":34,"merged":[[2,0,4,3],[6,4,6,5]]}
["Harvester 1.0 (For Step 14a) "]
[]
["This tool calculates the per lb cost of mechanical harvest using the assumptions you enter in the yellow boxes below.  For the most accurate calculation possible, enter the assumptions to reflect how many lineal feet the harvester might harvest in a growing season across multiple farms.  "]
[]
[]
[]
["Enter Values For the Variables Below",{"$nulls":3},"Mechanical Harvest Model Results"]
[]
["Harvester Purchase Cost ($):",{"v":100000,"d":"$100,000"},null,null,"Planting Size (acres):",{"$f":"((B19/B22)*(B21*B22))/43560","v":{"v":43.044077134986225,"d":"43.0"}}]
["Ammortization Period (years):",7,null,null,"Yield Per Row-Foot (lbs in-shell nuts):",{"$f":"(B28*F9)/B19","v":{"v":0.7575757575757576,"d":"0.76"}}]
["Annual Maintenance Costs ($):",{"v":3000,"d":"$3,000"},null,null,"Total Harvested Yield (lbs in-shell nuts):",{"$f":"(F10*B19)*B29","v":{"v":85227.27272727274,"d":"85227"}}]
["Annual Insurance Cost ($):",{"v":300,"d":"$300"},null,null,"Annual Operating Time (hrs):",{"$f":"(((B19*B20)/5280)/(B18))/B30","v":{"v":21.043771043771045,"d":"21.0"}}]
["Annual Borrowing Cost ($):",{"v":1000,"d":"$1,000"},null,null,"Harvest Rate (lbs/hr):",{"$f":"F11/F12","v":4050}]
["Annual Storage Costs ($):",0]
["Annual Transportation Costs ($):",0,null,null,"Annual Operator Cost ($):",{"$f":"F12*B25","v":{"v":946.969696969697,"d":"$947"}}]
["Fuel Price ($/gal):",{"v":4.75,"d":"$4.75"},null,null,"Annual Assistant(s) Cost ($):",{"$f":"(F12*B26*B27)","v":{"v":631.3131313131314,"d":"$631"}}]
["Fuel Efficiency (gal/hr):",{"v":2,"d":"2.0"},null,null,"Annual Fuel Cost ($):",{"$f":"(F12*B17)*B16","v":{"v":199.91582491582494,"d":"$199.92"}}]
["Average Drive Speed (mph):",1.5,null,null,"Annual Harvester Ownership Cost ($):",{"$f":"(B9/B10)+B11+B12+B13+B14+B15","v":{"v":18585.714285714286,"d":"$18,586"}}]
["Total Row Length in Planting (linear ft):",125000,null,null,"Mechanical Harvest Cost ($/acre):",{"$f":"(F15+F16+F17+F18)/F9","v":{"v":473.09442539682544,"d":"$473"}}]
["Harvest Passes Per Row (#):",1,null,null,"Mechancial Harvest Cost ($/hr):",{"$f":"(F15+F16+F17+F18)/F12","v":{"v":967.6931428571429,"d":"$968"}}]
["Row Spacing (ft):",15,null,null,"Mechanical Harvest Cost ($/lb in-shell):",{"$f":"(F15+F17+F18+F16)/F11","v":{"v":0.23893657848324512,"d":"$0.24"}}]
["In-Row Plant Spacing (ft):",6]
["Hand-Picking Rate (lbs in-shell/hr):",13,null,null,"Equivalent Hand Harvest Labor Cost ($/lb in-shell):",{"$f":"((F11/B23)*B24)/F11","v":{"v":1.1538461538461537,"d":"$1.15"}}]
["Hand-Picking Labor Rate ($/hr):",{"v":15,"d":"$15.00"}]
["Harvester Operator Rate ($/hr):",{"v":45,"d":"$45.00"}]
["Hours of Assistant Labor Per Hour Of Operator Labor:",2]
["Harvester Assistants Labor Rate ($/hr):",{"v":15,"d":"$15.00"}]
["In-Shell Yield (lbs/acre):",2200]
["Harvest Efficiency (decimal)*:",0.9]
["Field Efficiency (decimal)**:",0.75]
["In-Shell Pay Price ($/lb):",{"v":1.5,"d":"$1.50"}]
[]
["* percentage of total yield captured by harvester unit"]
["** percentage of operating time driving down the rows"]

{"sheet":"budget","index":10,"n_rows":44,"n_cols":19,"rows_kept":44,"merged":[[1,3,1,18],[2,3,2,4],[2,5,2,8],[2,9,2,18]]}
[null,"Your Hazelnut Production Enterprise Budget (Year 0 -15)"]
[{"$nulls":3},"Year"]
[{"$nulls":3},"Establishment",null,"Early-Production",{"$nulls":3},"Full-Production"]
[null,"Revenue",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"In-shell nut production (lbs)",null,0,0,0,{"$f":"'Step 12'!N14","v":{"v":70.87320574162679,"d":"71"}},{"$f":"'Step 12'!N15","v":{"v":1095.8657296650717,"d":"1096"}},{"$f":"'Step 12'!N16","v":{"v":3015.026913875598,"d":"3015"}},{"$f":"'Step 12'!N17","v":{"v":5118.301435406698,"d":"5118"}},{"$f":"'Step 12'!N18","v":{"v":8001.495215311004,"d":"8001"}},{"$f":"'Step 12'!N19","v":{"v":9474.581339712919,"d":"9475"}},{"$f":"'Step 12'!N20","v":{"v":10325.059808612441,"d":"10325"}},{"$f":"'Step 12'!N21","v":{"v":10325.059808612441,"d":"10325"}},{"$f":"'Step 12'!N22","v":{"v":12193.331339712919,"d":"12193"}},{"$f":"'Step 12'!N23","v":{"v":10325.059808612441,"d":"10325"}},{"$f":"'Step 12'!N24","v":{"v":12193.331339712919,"d":"12193"}},{"$f":"'Step 12'!N25","v":{"v":10325.059808612441,"d":"10325"}},{"$f":"'Step 12'!N26","v":{"v":12193.331339712919,"d":"12193"}}]
[null,"In-shell nut sales"]
[null,"Market 1 - price ($/lb in-shell):",{"$f":"'Step 12'!P8","v":{"v":1.5,"d":"$1.50"}},{"$nulls":3},{"$f":"'Step 12'!P8*('Step 12'!O14*'Step 12'!N14)","v":{"v":106.30980861244018,"d":"$106"}},{"$f":"'Step 12'!P8*'Step 12'!O15*'Step 12'!N15","v":{"v":1643.7985944976076,"d":"$1,644"}},{"$f":"'Step 12'!P8*'Step 12'!O16*'Step 12'!N16","v":{"v":4522.540370813397,"d":"$4,523"}},{"$f":"'Step 12'!P8*'Step 12'!O17*'Step 12'!N17","v":{"v":7677.452153110047,"d":"$7,677"}},{"$f":"'Step 12'!P8*'Step 12'!O18*'Step 12'!N18","v":{"v":12002.242822966506,"d":"$12,002"}},{"$f":"'Step 12'!P8*'Step 12'!O19*'Step 12'!N19","v":{"v":14211.872009569379,"d":"$14,212"}},{"$f":"'Step 12'!P8*'Step 12'!O20*'Step 12'!N20","v":{"v":15487.589712918661,"d":"$15,488"}},{"$f":"'Step 12'!P8*'Step 12'!O21*'Step 12'!N21","v":{"v":15487.589712918661,"d":"$15,488"}},{"$f":"'Step 12'!P8*'Step 12'!O22*'Step 12'!N22","v":{"v":18289.99700956938,"d":"$18,290"}},{"$f":"'Step 12'!P8*'Step 12'!O23*'Step 12'!N23","v":{"v":15487.589712918661,"d":"$15,488"}},{"$f":"'Step 12'!P8*'Step 12'!O24*'Step 12'!N24","v":{"v":18289.99700956938,"d":"$18,290"}},{"$f":"'Step 12'!P8*'Step 12'!O25*'Step 12'!N25","v":{"v":15487.589712918661,"d":"$15,488"}},{"$f":"'Step 12'!P8*'Step 12'!O26*'Step 12'!N26","v":{"v":18289.99700956938,"d":"$18,290"}}]
[null,"Market 2 - price ($/lb in-shell):",{"$f":"'Step 12'!P9","v":0},{"$nulls":3},{"$f":"'Step 12'!P9*'Step 12'!P14*'Step 12'!N14","v":0},{"$f":"'Step 12'!P9*'Step 12'!P15*'Step 12'!N15","v":0},{"$f":"'Step 12'!P9*'Step 12'!P16*'Step 12'!N16","v":0},{"$f":"'Step 12'!P9*'Step 12'!P17*'Step 12'!N17","v":0},{"$f":"'Step 12'!P9*'Step 12'!P18*'Step 12'!N18","v":0},{"$f":"'Step 12'!P9*'Step 12'!P19*'Step 12'!N19","v":0},{"$f":"'Step 12'!P9*'Step 12'!P20*'Step 12'!N20","v":0},{"$f":"'Step 12'!P9*'Step 12'!P21*'Step 12'!N21","v":0},{"$f":"'Step 12'!P9*'Step 12'!P22*'Step 12'!N22","v":0},{"$f":"'Step 12'!P9*'Step 12'!P23*'Step 12'!N23","v":0},{"$f":"'Step 12'!P9*'Step 12'!P24*'Step 12'!N24","v":0},{"$f":"'Step 12'!P9*'Step 12'!P25*'Step 12'!N25","v":0},{"$f":"'Step 12'!P9*'Step 12'!P26*'Step 12'!N26","v":0}]
[null,"Market 3 - price ($/lb in-shell):",{"$f":"'Step 12'!P10","v":0},{"$nulls":3},{"$f":"'Step 12'!P10*'Step 12'!Q14*'Step 12'!N14","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q15*'Step 12'!N15","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q16*'Step 12'!N16","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q17*'Step 12'!N17","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q18*'Step 12'!N18","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q19*'Step 12'!N19","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q20*'Step 12'!N20","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q21*'Step 12'!N21","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q22*'Step 12'!N22","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q23*'Step 12'!N23","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q24*'Step 12'!N24","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q25*'Step 12'!N25","v":0},{"$f":"'Step 12'!P10*'Step 12'!Q26*'Step 12'!N26","v":0}]
[]
[null,"Total Gross Revenue",null,{"$f":"SUM(D7:D9)","v":0},0,0,{"v":106.30980861244018,"d":"$106"},{"v":1643.7985944976076,"d":"$1,644"},{"v":4522.540370813397,"d":"$4,523"},{"v":7677.452153110047,"d":"$7,677"},{"v":12002.242822966506,"d":"$12,002"},{"v":14211.872009569379,"d":"$14,212"},{"v":15487.589712918661,"d":"$15,488"},{"v":15487.589712918661,"d":"$15,488"},{"v":18289.99700956938,"d":"$18,290"},{"v":15487.589712918661,"d":"$15,488"},{"v":18289.99700956938,"d":"$18,290"},{"v":15487.589712918661,"d":"$15,488"},{"v":18289.99700956938,"d":"$18,290"}]
[]
[null,"Expenses"]
[null,"Land Cost"]
[null,"Owned",null,{"$f":"(SUM('Steps 1-6'!$C$24:$C$26))*'Steps 1-6'!$C$11","v":0},{"$f":"D15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"E15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"F15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"G15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"H15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"I15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"J15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"K15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"L15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"M15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"N15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"O15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"P15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"Q15*(1+'Steps 1-6'!$C$28)","v":0},{"$f":"R15*(1+'Steps 1-6'!$C$28)","v":0}]
[null,"Rented",null,{"$f":"'Steps 1-6'!$C$31*'Steps 1-6'!$C$11","v":{"v":206.61157024793386,"d":"$207"}},{"$f":"D16*(1+'Steps 1-6'!$C$32)","v":{"v":210.74380165289253,"d":"$211"}},{"$f":"E16*(1+'Steps 1-6'!$C$32)","v":{"v":214.9586776859504,"d":"$215"}},{"$f":"F16*(1+'Steps 1-6'!$C$32)","v":{"v":219.2578512396694,"d":"$219"}},{"$f":"G16*(1+'Steps 1-6'!$C$32)","v":{"v":223.6430082644628,"d":"$224"}},{"$f":"H16*(1+'Steps 1-6'!$C$32)","v":{"v":228.11586842975206,"d":"$228"}},{"$f":"I16*(1+'Steps 1-6'!$C$32)","v":{"v":232.6781857983471,"d":"$233"}},{"$f":"J16*(1+'Steps 1-6'!$C$32)","v":{"v":237.33174951431405,"d":"$237"}},{"$f":"K16*(1+'Steps 1-6'!$C$32)","v":{"v":242.07838450460034,"d":"$242"}},{"$f":"L16*(1+'Steps 1-6'!$C$32)","v":{"v":246.91995219469234,"d":"$247"}},{"$f":"M16*(1+'Steps 1-6'!$C$32)","v":{"v":251.85835123858618,"d":"$252"}},{"$f":"N16*(1+'Steps 1-6'!$C$32)","v":{"v":256.8955182633579,"d":"$257"}},{"$f":"O16*(1+'Steps 1-6'!$C$32)","v":{"v":262.0334286286251,"d":"$262"}},{"$f":"P16*(1+'Steps 1-6'!$C$32)","v":{"v":267.2740972011976,"d":"$267"}},{"$f":"Q16*(1+'Steps 1-6'!$C$32)","v":{"v":272.61957914522156,"d":"$273"}},{"$f":"R16*(1+'Steps 1-6'!$C$32)","v":{"v":278.071970728126,"d":"$278"}}]
[null,"Supplies and Materials"]
[null,"Plants",null,0,{"$f":"SUM('Steps 1-6'!I6:I10)","v":{"v":13000,"d":"$13,000"}},{"$f":"'Step 9'!H30*'Step 9'!H31","v":{"v":431.25,"d":"$431"}},0,0,0,0,0,{"$f":"'Step 11'!H13*'Step 11'!H14","v":0},0,0,0,0,0,0,0]
[null,"Drip Irrigation",null,0,{"$f":"'Steps 1-6'!I37","v":{"v":3661.71,"d":"$3,662"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Deer Fencing",null,null,{"$f":"'Steps 1-6'!N17+'Steps 1-6'!N27+'Steps 1-6'!N33","v":{"v":2016.4752715789473,"d":"$2,016"}}]
[null,"Tree Tubes",null,0,{"$f":"'Steps 1-6'!H21","v":{"v":5500,"d":"$5,500"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Fertilizer",null,{"$f":"'Steps 7-8'!E41+'Steps 7-8'!E42+'Steps 7-8'!E43","v":{"v":499.5867768595041,"d":"$500"}},0,{"$f":"SUM('Step 9'!J20:J22)","v":{"v":142.14876033057848,"d":"$142"}},{"$f":"SUM('Step 9'!$J$20:$J$22)","v":{"v":142.14876033057848,"d":"$142"}},{"$f":"SUM('Step 9'!$J$20:$J$22)","v":{"v":142.14876033057848,"d":"$142"}},{"$f":"SUM('Step 9'!$J$20:$J$22)","v":{"v":142.14876033057848,"d":"$142"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM('Step 10'!$J$20:$J$23)","v":{"v":147.1074380165289,"d":"$147"}}]
[null,"Herbicide/Deer Repellent",null,0,{"$f":"SUM('Steps 7-8'!E36:E38)","v":{"v":89,"d":"$89"}},{"$f":"SUM('Step 9'!J14:J17)","v":{"v":29,"d":"$29"}},{"$f":"SUM('Step 9'!J14:J17)","v":{"v":29,"d":"$29"}},{"$f":"SUM('Step 9'!$J$14:$J$17)","v":{"v":29,"d":"$29"}},{"$f":"SUM('Step 9'!$J$14:$J$17)","v":{"v":29,"d":"$29"}},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0},{"$f":"SUM('Step 10'!$J$14:$J$17)","v":0}]
[null,"Organic mulch",null,0,{"$f":"'Steps 7-8'!E30","v":{"v":825,"d":"$825"}},{"$f":"'Step 9'!J11","v":0},{"$f":"'Step 9'!J11","v":0},{"$f":"'Step 9'!J11","v":0},{"$f":"'Step 9'!J11","v":0},{"$f":"'Step 10'!J11","v":0},{"$f":"'Step 10'!J11","v":0},{"$f":"'Step 10'!J11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0},{"$f":"'Step 10'!$J$11","v":0}]
[null,"Synthetic mulch",null,null,{"$f":"'Steps 7-8'!E33","v":0}]
[null,"Total Supplies and Materials",null,{"$f":"SUM(D18:D25)","v":{"v":499.5867768595041,"d":"$500"}},{"v":25092.185271578946,"d":"$25,092"},{"v":602.3987603305785,"d":"$602"},{"v":171.14876033057848,"d":"$171"},{"v":171.14876033057848,"d":"$171"},{"v":171.14876033057848,"d":"$171"},{"$f":"SUM(J18:J24)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM(K18:K25)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM(L18:L25)","v":{"v":147.1074380165289,"d":"$147"}},{"$f":"SUM(M18:M25)","v":{"v":147.1074380165289,"d":"$147"}},{"v":147.1074380165289,"d":"$147"},{"v":147.1074380165289,"d":"$147"},{"v":147.1074380165289,"d":"$147"},{"v":147.1074380165289,"d":"$147"},{"v":147.1074380165289,"d":"$147"},{"$f":"SUM(S18:S25)","v":{"v":147.1074380165289,"d":"$147"}}]
[]
[null,"Equipment and Operator",null,{"$f":"SUM('Steps 7-8'!E12:E16)","v":{"v":1200,"d":"$1,200"}},{"$f":"SUM('Steps 7-8'!J12:J18)","v":{"v":75,"d":"$75"}},{"$f":"SUM('Step 9'!E11:E15)","v":{"v":300,"d":"$300"}},{"$f":"F28","v":{"v":300,"d":"$300"}},{"$f":"G28","v":{"v":300,"d":"$300"}},{"$f":"H28","v":{"v":300,"d":"$300"}},{"$f":"SUM('Step 10'!E11:E13)","v":{"v":225,"d":"$225"}},{"$f":"J28","v":{"v":225,"d":"$225"}},{"$f":"K28","v":{"v":225,"d":"$225"}},{"$f":"K28","v":{"v":225,"d":"$225"}},{"$f":"M28","v":{"v":225,"d":"$225"}},{"v":225,"d":"$225"},{"v":225,"d":"$225"},{"v":225,"d":"$225"},{"v":225,"d":"$225"},{"v":225,"d":"$225"}]
[]
[null,"General Labor",null,{"$f":"SUM('Steps 7-8'!E22)","v":0},{"$f":"SUM('Steps 7-8'!J24:J31)","v":{"v":3105,"d":"$3,105"}},{"$f":"SUM('Step 9'!E21:E24)","v":{"v":135,"d":"$135"}},{"$f":"F30","v":{"v":135,"d":"$135"}},{"$f":"G30","v":{"v":135,"d":"$135"}},{"$f":"H30","v":{"v":135,"d":"$135"}},{"$f":"SUM('Step 10'!E17:E20)","v":{"v":67.5,"d":"$68"}},{"$f":"J30","v":{"v":67.5,"d":"$68"}},{"$f":"K30","v":{"v":67.5,"d":"$68"}},{"$f":"K30","v":{"v":67.5,"d":"$68"}},{"$f":"M30","v":{"v":67.5,"d":"$68"}},{"v":67.5,"d":"$68"},{"v":67.5,"d":"$68"},{"v":67.5,"d":"$68"},{"v":67.5,"d":"$68"},{"v":67.5,"d":"$68"}]
[null,"Harvest Cost",{"$nulls":4},{"$f":"'Step 13'!D15","v":{"v":81.77677585572322,"d":"$82"}},{"$f":"'Step 13'!D16","v":{"v":261.84240792321714,"d":"$262"}},{"$f":"'Step 13'!D17","v":{"v":720.4002148363332,"d":"$720"}},{"$f":"'Step 13'!D18","v":{"v":1222.949432621959,"d":"$1,223"}},{"$f":"'Step 13'!D19","v":{"v":1911.8498894964684,"d":"$1,912"}},{"$f":"'Step 13'!D20","v":{"v":2263.824047872206,"d":"$2,264"}},{"$f":"'Step 13'!D21","v":{"v":2467.0344633047266,"d":"$2,467"}},{"$f":"'Step 13'!D22","v":{"v":2467.0344633047266,"d":"$2,467"}},{"$f":"'Step 13'!D23","v":{"v":2913.4328706235287,"d":"$2,913"}},{"$f":"'Step 13'!D24","v":{"v":2467.0344633047266,"d":"$2,467"}},{"$f":"'Step 13'!D25","v":{"v":2913.4328706235287,"d":"$2,913"}},{"$f":"'Step 13'!D26","v":{"v":2467.0344633047266,"d":"$2,467"}},{"$f":"'Step 13'!D27","v":{"v":2913.4328706235287,"d":"$2,913"}}]
[null,"Drying and Husking",{"$nulls":4},{"$f":"'Step 13'!I13","v":0},{"$f":"'Step 13'!I14","v":0},{"$f":"'Step 13'!I15","v":0},{"$f":"'Step 13'!I16","v":0},{"$f":"'Step 13'!I17","v":0},{"$f":"'Step 13'!I18","v":0},{"$f":"'Step 13'!I20","v":0},{"$f":"'Step 13'!I21","v":0},{"$f":"'Step 13'!I21","v":0},{"$f":"'Step 13'!I22","v":0},{"$f":"'Step 13'!I23","v":0},{"$f":"'Step 13'!I24","v":0},{"$f":"'Step 13'!I25","v":0}]
[]
[null,"Total Expenses",null,{"$f":"D15+D16+D26+D28+D30+D31","v":{"v":1906.198347107438,"d":"$1,906"}},{"v":28482.92907323184,"d":"$28,483"},{"v":1252.357438016529,"d":"$1,252"},{"v":907.1833874259711,"d":"$907"},{"v":1091.6341765182583,"d":"$1,092"},{"v":1554.6648435966638,"d":"$1,555"},{"v":1895.2350564368348,"d":"$1,895"},{"v":2588.7890770273116,"d":"$2,589"},{"v":2945.5098703933354,"d":"$2,946"},{"v":3153.561853515948,"d":"$3,154"},{"v":3158.5002525598416,"d":"$3,159"},{"v":3609.9358269034155,"d":"$3,610"},{"v":3168.6753299498805,"d":"$3,169"},{"v":3620.3144058412554,"d":"$3,620"},{"v":3179.261480466477,"d":"$3,179"},{"v":3631.1122793681834,"d":"$3,631"}]
[]
[null,"EBITDA (Hazelnut Rows)",null,{"$f":"D11-D34","v":{"v":-1906.198347107438,"d":"$(1,906)"}},{"v":-28482.92907323184,"d":"$(28,483)"},{"v":-1252.357438016529,"d":"$(1,252)"},{"v":-800.8735788135309,"d":"$(801)"},{"v":552.1644179793493,"d":"$552"},{"v":2967.8755272167336,"d":"$2,968"},{"v":5782.217096673212,"d":"$5,782"},{"v":9413.453745939194,"d":"$9,413"},{"v":11266.362139176043,"d":"$11,266"},{"v":12334.027859402713,"d":"$12,334"},{"v":12329.08946035882,"d":"$12,329"},{"v":14680.061182665962,"d":"$14,680"},{"v":12318.914382968782,"d":"$12,319"},{"v":14669.682603728124,"d":"$14,670"},{"v":12308.328232452184,"d":"$12,308"},{"v":14658.884730201196,"d":"$14,659"}]
[null,"Cumulative EBITDA (Hazelnut Rows)",null,{"$f":"D36","v":{"v":-1906.198347107438,"d":"$(1,906)"}},{"$f":"D37+E36","v":{"v":-30389.12742033928,"d":"$(30,389)"}},{"$f":"E37+F36","v":{"v":-31641.48485835581,"d":"$(31,641)"}},{"v":-32442.35843716934,"d":"$(32,442)"},{"v":-31890.194019189992,"d":"$(31,890)"},{"v":-28922.31849197326,"d":"$(28,922)"},{"v":-23140.101395300047,"d":"$(23,140)"},{"v":-13726.647649360853,"d":"$(13,727)"},{"v":-2460.285510184811,"d":"$(2,460)"},{"v":9873.742349217902,"d":"$9,874"},{"v":22202.831809576724,"d":"$22,203"},{"v":36882.89299224269,"d":"$36,883"},{"v":49201.80737521147,"d":"$49,202"},{"v":63871.4899789396,"d":"$63,871"},{"v":76179.81821139179,"d":"$76,180"},{"v":90838.70294159299,"d":"$90,839"}]
[]
[null,"Row-Middle/Headland Income or Expense",null,null,{"$f":"'alley-cropping'!J9","v":{"v":565.6847107438017,"d":"$565.68"}},{"$f":"'alley-cropping'!J10","v":{"v":565.6847107438017,"d":"$565.68"}},{"$f":"'alley-cropping'!J11","v":{"v":565.6847107438017,"d":"$565.68"}},{"$f":"'alley-cropping'!J12","v":{"v":565.6847107438017,"d":"$565.68"}},{"$f":"'alley-cropping'!J13","v":{"v":496.8141873278237,"d":"$496.81"}},{"$f":"'alley-cropping'!J14","v":{"v":462.3789256198347,"d":"$462.38"}},{"$f":"'alley-cropping'!J15","v":{"v":427.94366391184576,"d":"$427.94"}},{"$f":"'alley-cropping'!J16","v":{"v":359.07314049586785,"d":"$359.07"}},{"$f":"'alley-cropping'!J17","v":{"v":-321.3375,"d":"$(321.34)"}},{"$f":"'alley-cropping'!J18","v":{"v":-321.3375,"d":"$(321.34)"}},{"$f":"'alley-cropping'!J19","v":{"v":-54.15,"d":"$(54.15)"}},{"$f":"'alley-cropping'!J20","v":{"v":-54.15,"d":"$(54.15)"}},{"$f":"'alley-cropping'!J21","v":{"v":-54.15,"d":"$(54.15)"}},{"$f":"'alley-cropping'!J22","v":{"v":-54.15,"d":"$(54.15)"}},{"$f":"'alley-cropping'!J23","v":{"v":-54.15,"d":"$(54.15)"}}]
[null,"Entire Field EBITDA",null,{"$f":"D39+D36","v":{"v":-1906.198347107438,"d":"$(1,906)"}},{"v":-27917.24436248804,"d":"$(27,917)"},{"v":-686.6727272727272,"d":"$(687)"},{"v":-235.1888680697292,"d":"$(235)"},{"v":1117.849128723151,"d":"$1,118"},{"v":3464.6897145445573,"d":"$3,465"},{"v":6244.596022293046,"d":"$6,245"},{"v":9841.39740985104,"d":"$9,841"},{"v":11625.43527967191,"d":"$11,625"},{"v":12012.690359402714,"d":"$12,013"},{"v":12007.75196035882,"d":"$12,008"},{"v":14625.911182665963,"d":"$14,626"},{"v":12264.764382968782,"d":"$12,265"},{"v":14615.532603728125,"d":"$14,616"},{"v":12254.178232452185,"d":"$12,254"},{"v":14604.734730201197,"d":"$14,605"}]
[null,"Entire Field Cumulative EBITDA",null,{"$f":"D40","v":{"v":-1906.198347107438,"d":"$(1,906)"}},{"$f":"D41+E40","v":{"v":-29823.442709595478,"d":"$(29,823)"}},{"v":-30510.115436868204,"d":"$(30,510)"},{"v":-30745.304304937934,"d":"$(30,745)"},{"v":-29627.455176214782,"d":"$(29,627)"},{"v":-26162.765461670224,"d":"$(26,163)"},{"v":-19918.169439377176,"d":"$(19,918)"},{"v":-10076.772029526135,"d":"$(10,077)"},{"v":1548.6632501457752,"d":"$1,549"},{"v":13561.353609548489,"d":"$13,561"},{"v":25569.10556990731,"d":"$25,569"},{"v":40195.016752573276,"d":"$40,195"},{"v":52459.781135542056,"d":"$52,460"},{"v":67075.31373927018,"d":"$67,075"},{"v":79329.49197172237,"d":"$79,329"},{"v":93934.22670192356,"d":"$93,934"}]
[]
[null,"Per Acre EBITDA (Entire Field)",null,{"$f":"D40/'Steps 1-6'!$C$15","v":{"v":-370.15175404020493,"d":"$(370)"}},{"$f":"E40/'Steps 1-6'!$C$15","v":{"v":-5421.0607119792785,"d":"$(5,421)"}},{"$f":"F40/'Steps 1-6'!$C$15","v":{"v":-133.340328847345,"d":"$(133)"}},{"$f":"G40/'Steps 1-6'!$C$15","v":{"v":-45.66973430589905,"d":"$(46)"}},{"$f":"H40/'Steps 1-6'!$C$15","v":{"v":217.06755562823278,"d":"$217"}},{"$f":"I40/'Steps 1-6'!$C$15","v":{"v":672.7846433136385,"d":"$673"}},{"$f":"J40/'Steps 1-6'!$C$15","v":{"v":1212.5958321345554,"d":"$1,213"}},{"$f":"K40/'Steps 1-6'!$C$15","v":{"v":1911.0343469717502,"d":"$1,911"}},{"$f":"L40/'Steps 1-6'!$C$15","v":{"v":2257.4645848273317,"d":"$2,257"}},{"$f":"M40/'Steps 1-6'!$C$15","v":{"v":2332.6630274452536,"d":"$2,333"}},{"$f":"N40/'Steps 1-6'!$C$15","v":{"v":2331.7040731627567,"d":"$2,332"}},{"$f":"O40/'Steps 1-6'!$C$15","v":{"v":2840.1066903217284,"d":"$2,840"}},{"$f":"P40/'Steps 1-6'!$C$15","v":{"v":2381.6115758020073,"d":"$2,382"}},{"$f":"Q40/'Steps 1-6'!$C$15","v":{"v":2838.0913443299983,"d":"$2,838"}},{"$f":"R40/'Steps 1-6'!$C$15","v":{"v":2379.5559228904417,"d":"$2,380"}},{"$f":"S40/'Steps 1-6'!$C$15","v":{"v":2835.994578360202,"d":"$2,836"}}]
[null,"Per Acre Cumulative EBITDA (Entire Field)",null,{"$f":"D43","v":{"v":-370.15175404020493,"d":"$(370)"}},{"$f":"D44+E43","v":{"v":-5791.212466019483,"d":"$(5,791)"}},{"v":-5924.552794866828,"d":"$(5,925)"},{"v":-5970.222529172726,"d":"$(5,970)"},{"v":-5753.154973544493,"d":"$(5,753)"},{"v":-5080.370330230855,"d":"$(5,080)"},{"v":-3867.7744980963,"d":"$(3,868)"},{"v":-1956.7401511245496,"d":"$(1,957)"},{"v":300.7244337027821,"d":"$301"},{"v":2633.387461148036,"d":"$2,633"},{"v":4965.091534310793,"d":"$4,965"},{"v":7805.198224632521,"d":"$7,805"},{"v":10186.809800434528,"d":"$10,187"},{"v":13024.901144764526,"d":"$13,025"},{"v":15404.457067654968,"d":"$15,404"},{"v":18240.45164601517,"d":"$18,240"}]

{"sheet":"graph","index":11,"n_rows":18,"n_cols":3,"rows_kept":18,"merged":[[0,1,1,1],[0,2,1,2],[26,3,26,4]]}
[null,"Hazelnut Rows EBITDA","Whole Field EBITDA"]
["Year"]
[0,{"$f":"budget!D36","v":{"v":-1906.198347107438,"d":"$(1,906)"}},{"$f":"budget!D41","v":{"v":-1906.198347107438,"d":"$(1,906)"}}]
[1,{"$f":"B3+budget!E36","v":{"v":-30389.12742033928,"d":"$(30,389)"}},{"$f":"budget!E41","v":{"v":-29823.442709595478,"d":"$(29,823)"}}]
[2,{"$f":"B4+budget!F36","v":{"v":-31641.48485835581,"d":"$(31,641)"}},{"$f":"budget!F41","v":{"v":-30510.115436868204,"d":"$(30,510)"}}]
[3,{"$f":"B5+budget!G36","v":{"v":-32442.35843716934,"d":"$(32,442)"}},{"$f":"budget!G41","v":{"v":-30745.304304937934,"d":"$(30,745)"}}]
[4,{"$f":"B6+budget!H36","v":{"v":-31890.194019189992,"d":"$(31,890)"}},{"$f":"budget!H41","v":{"v":-29627.455176214782,"d":"$(29,627)"}}]
[5,{"$f":"B7+budget!I36","v":{"v":-28922.31849197326,"d":"$(28,922)"}},{"$f":"budget!I41","v":{"v":-26162.765461670224,"d":"$(26,163)"}}]
[6,{"$f":"B8+budget!J36","v":{"v":-23140.101395300047,"d":"$(23,140)"}},{"$f":"budget!J41","v":{"v":-19918.169439377176,"d":"$(19,918)"}}]
[7,{"$f":"B9+budget!K36","v":{"v":-13726.647649360853,"d":"$(13,727)"}},{"$f":"budget!K41","v":{"v":-10076.772029526135,"d":"$(10,077)"}}]
[8,{"$f":"B10+budget!L36","v":{"v":-2460.285510184811,"d":"$(2,460)"}},{"$f":"budget!L41","v":{"v":1548.6632501457752,"d":"$1,549"}}]
[9,{"$f":"B11+budget!M36","v":{"v":9873.742349217902,"d":"$9,874"}},{"$f":"budget!M41","v":{"v":13561.353609548489,"d":"$13,561"}}]
[10,{"$f":"B12+budget!N36","v":{"v":22202.831809576724,"d":"$22,203"}},{"$f":"budget!N41","v":{"v":25569.10556990731,"d":"$25,569"}}]
[11,{"$f":"B13+budget!O36","v":{"v":36882.89299224269,"d":"$36,883"}},{"$f":"budget!O41","v":{"v":40195.016752573276,"d":"$40,195"}}]
[12,{"$f":"B14+budget!P36","v":{"v":49201.80737521147,"d":"$49,202"}},{"$f":"budget!P41","v":{"v":52459.781135542056,"d":"$52,460"}}]
[13,{"$f":"B15+budget!Q36","v":{"v":63871.4899789396,"d":"$63,871"}},{"$f":"budget!Q41","v":{"v":67075.31373927018,"d":"$67,075"}}]
[14,{"$f":"B16+budget!R36","v":{"v":76179.81821139179,"d":"$76,180"}},{"$f":"budget!R41","v":{"v":79329.49197172237,"d":"$79,329"}}]
[15,{"$f":"B17+budget!S36","v":{"v":90838.70294159299,"d":"$90,839"}},{"$f":"budget!S41","v":{"v":93934.22670192356,"d":"$93,934"}}]

{"sheet":"input tables","index":12,"n_rows":77,"n_cols":6,"rows_kept":77}
[]
[{"$nulls":3},"Custom Hire/Rental Rates",null,"Labor"]
[{"$nulls":3},"Year 0 - Site Preparation",null,"Year 0 - Site Preparation"]
[{"$nulls":3},"Activity",null,"Activity"]
[{"$nulls":3},"Herbicide burndown (strips) - ATV sprayer",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"Herbicide burndown (whole field) - sprayer"]
[{"$nulls":3},"Ripping (strips) - tractor and implement",null,"Year 1 - Planting Year"]
[{"$nulls":3},"Ripping (whole field) - tractor and implement",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"Plowing (whole field) - tractor and implement",null,"Planting"]
[{"$nulls":3},"Plowing (strips) - tractor and implement",null,"Applying mulch (organic or synthetic)"]
[{"$nulls":3},"Disking (whole field) - tractor and implement",null,"Installing tree tubes"]
[{"$nulls":3},"Disking (strips) - tractor and implement",null,"Installing drip irrigation"]
[{"$nulls":3},"Rototilling (strips) - tractor and implement",null,"Hand weeding"]
[{"$nulls":3},"Rototilling (whole field) - tractor and implement",null,"Deer repellent application"]
[{"$nulls":3},"Finisher (strips) - tractor and implement",null,"Years 2-4 - Pre-Production Maintenance"]
[{"$nulls":3},"Finisher (whole field) - tractor and implement",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"Cover crop seeding - tractor and implement",null,"Re-planting"]
[{"$nulls":5},"Hand weeding"]
[{"$nulls":5},"Hand fertilizing"]
[{"$nulls":3},"Year 1 - Planting Year",null,"Applying mulch"]
[{"$nulls":3},"Herbicide burndown (strips) - ATV sprayer",null,"Deer repellent application"]
[{"$nulls":3},"Herbicide burndown (whole field) - sprayer",null,"Years 5-7 Early-Production Maintenance"]
[{"$nulls":3},"Tillage - tractor and implement",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"Tree planting-tractor and planter",null,"Hand weeding"]
[{"$nulls":3},"Tree planting-auger",null,"Data collection - plant performance"]
[{"$nulls":3},"Tree planting (custom) - inclusive",null,"Hand fertilizing"]
[{"$nulls":3},"Watering - tractor and tank",null,"Renewal pruning"]
[{"$nulls":3},"Cover crop seeding - tractor and implement",null,"Deer repellent application"]
[{"$nulls":3},"Fertilizing-ATV",null,"Year 8 Renovation"]
[{"$nulls":3},"Fertilizing-Tractor",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"In row weed control (herbicide) - ATV sprayer",null,"Plant removal - hand labor"]
[{"$nulls":3},"In row weed control (mulch application) - tractor",null,"Re-planting - hand labor"]
[{"$nulls":3},"In row weed control (herbicide) - backpack sprayer",null,"Hand weeding"]
[{"$nulls":3},"Clean cultivation-tractor and implement",null,"Data collection - plant performance"]
[{"$nulls":3},"Mowing-Tractor and implement",null,"Hand fertilizing"]
[{"$nulls":3},"Mowing-riding mower",null,"Renewal pruning"]
[{"$nulls":3},"Mulching - labor only"]
[{"$nulls":3},"Drip irrigation install (custom) - labor only",null,"Years 9-15"]
[{"$nulls":3},"Deer repellent - backpack sprayer",null,"Project coordination/planning/consultant"]
[{"$nulls":3},"Years 2-4 - Pre-Production Maintenance",null,"Hand weeding (woodies)"]
[{"$nulls":3},"In row weed control (herbicide) - ATV sprayer",null,"Data collection - plant performance"]
[{"$nulls":3},"In row weed control (herbicide) - backpack sprayer",null,"Hand fertilizing"]
[{"$nulls":3},"In row weed control (weed whip)",null,"Renewal pruning"]
[{"$nulls":3},"Clean cultivation - tractor and implement"]
[{"$nulls":3},"Mowing-tractor and implement"]
[{"$nulls":3},"Mowing-riding mower",null,"Step 13 Harvest Cost"]
[{"$nulls":3},"Fertilizing-ATV",null,"Machine"]
[{"$nulls":3},"Fertilizing-Tractor",null,"Hand"]
[{"$nulls":3},"Watering - tractor and tank"]
[{"$nulls":3},"Deer repellent - backpack sprayer"]
[{"$nulls":3},"Years 5-7 Early Production Maintenance"]
[{"$nulls":3},"In row weed control (herbicide) - ATV sprayer"]
[{"$nulls":3},"In row weed control (herbicide) - backpack sprayer"]
[{"$nulls":3},"In row weed control (weed whip)"]
[{"$nulls":3},"Mowing-tractor and implement"]
[{"$nulls":3},"Mowing-riding mower"]
[{"$nulls":3},"Fertilizing-ATV"]
[{"$nulls":3},"Fertilizing-Tractor"]
[]
[{"$nulls":3},"Year 8 Renovation Year"]
[{"$nulls":3},"Plant removal - backpack sprayer"]
[{"$nulls":3},"Plant removal - backhoe"]
[{"$nulls":3},"In row weed control (herbicide) - ATV sprayer"]
[{"$nulls":3},"In row weed control (herbicide) - backpack sprayer"]
[{"$nulls":3},"Mowing-Tractor and implement"]
[{"$nulls":3},"Mowing-riding mower"]
[{"$nulls":3},"Fertilizing-ATV"]
[{"$nulls":3},"Fertilizing-Tractor"]
[{"$nulls":3},"Watering - tractor and tank"]
[]
[{"$nulls":3},"Years 9-15"]
[{"$nulls":3},"In row weed control (herbicide) - ATV sprayer"]
[{"$nulls":3},"In row weed control (herbicide) - backpack sprayer"]
[{"$nulls":3},"Mowing-Tractor and implement"]
[{"$nulls":3},"Mowing-riding mower"]
[{"$nulls":3},"Fertilizing-ATV"]
[{"$nulls":3},"Fertilizing-Tractor"]