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

{"sheet":"Home","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"merged":[[0,1,0,11],[1,1,1,11],[3,1,5,11],[7,1,7,3],[7,5,7,7],[7,9,7,11],[8,1,8,3],[8,5,8,7],[8,9,8,11],[16,16,16,17],[20,1,20,3],[20,5,20,7],[20,9,21,11],[21,1,21,3],[21,5,21,7]]}
[null,"Midwest Hazelnut Enterprise Budget Worksheet Tool - BETA"]
[null,"Original Verstion: June 8, 2012, Last Updated: December 15, 2016"]
[]
[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."]
[]
[]
[]
[null,"Establishment Phase",{"$nulls":3},"Pre-Production Phase",{"$nulls":3},"Early-Production Phase"]
[null,"Years 0-1",{"$nulls":3},"Years 2-4",{"$nulls":3},"Years 5-8"]
[]
[{"$nulls":13},"Developed By:"]
[{"$nulls":13},"Jason Fischbach, Agriculture Agent"]
[{"$nulls":13},"Ashland and Bayfield County UW-Extension"]
[{"$nulls":13},"jason.fischbach@ces.uwex.edu"]
[]
[]
[{"$nulls":16},"Helpful Tools"]
[]
[{"$nulls":16},"Iowa Custom Rate Guide"]
[{"$nulls":16},"Machinery Cost Calculator"]
[null,"Renovation",{"$nulls":3},"Full-Production Phase",{"$nulls":3},"Harvest Data"]
[null,"Year 8",{"$nulls":3},"Years 9-15"]

{"sheet":"Steps 1-5","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[3,1,6,2],[10,5,13,7],[19,1,21,3],[19,5,23,8],[26,1,26,3]]}
[]
[null,"Step 1",{"$nulls":3},"Step 3"]
[null,"Determine Your Planting Arrangement",{"$nulls":3},"Determine Your Plant Costs"]
[null,"Enter your row spacing, plant spacing, row length, and number of rows.  You must assume each row is the same length.",{"$nulls":3},"Enter the plant type and source and the cost per plant."]
[{"$nulls":5},"Plant Type and Source","Cost/Plant","# of Plants","Total Cost"]
[{"$nulls":5},"hazelnuts",{"v":3.5,"d":"$3.50"},{"$f":"C15","v":{"v":729.6,"d":"730"}},{"$f":"H6*G6","v":{"v":2553.6,"d":"$2,553.60"}}]
[{"$nulls":8},{"$f":"H7*G7","v":0}]
[null,"Item","Value"]
[null,"Row Spacing (ft)",12,null,null,"Step 4a"]
[null,"Plant Spacing (ft)",5,null,null,"Determine Your Tree Tube Costs (if used)"]
[null,"Number of Rows",19,null,null,"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."]
[null,"Row Length (ft)",192]
[null,"Total Row Feet",{"$f":"C12*C11","v":3648}]
[null,"Total Planting Acres",{"$f":"(C11*C12*C9)/43560","v":{"v":1.0049586776859505,"d":"1.00"}}]
[null,"Total Plants",{"$f":"C13/C10","v":{"v":729.6,"d":"730"}},null,null,"Tree Tube Protector","Cost/Tube","Total Cost"]
[null,"Plants/acre",{"$f":"C15/C14","v":726},{"$nulls":4},{"$f":"G16*C15","v":0}]
[]
[null,"Step 2",{"$nulls":3},"Step 5"]
[null,"Determine Your Land Costs",{"$nulls":3},"Determine Your Drip Irrigation Costs (If used)"]
[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},"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 3/4\" mainline attached to the water source.  If watering by hand from a tank leave this step blank."]
[]
[]
[null,"Item","Cost/Yr","Unit"]
[null,"Property taxes",null,"ac"]
[null,"Mortgage (principal and interest)",null,"ac",null,"Item","#","unit cost","Total Cost"]
[null,"Insurance",null,"ac",null,"1/2 feeder tubing",{"$f":"C13","v":3648},{"v":0.094,"d":"$0.09"},{"$f":"G26*H26","v":{"v":342.912,"d":"$342.91"}}]
[null,"or",{"$nulls":3},"3/4 mainline",{"$f":"(C11*C9)+50","v":278},{"v":0.18,"d":"$0.18"},{"v":50.04,"d":"$50.04"}]
[null,"Cash rent",{"v":100,"d":"$100.00"},"ac",null,"emitters (2/plant)",{"$f":"C15*2","v":{"v":1459.2,"d":"1459"}},{"v":0.25,"d":"$0.25"},{"v":364.8,"d":"$364.80"}]
[{"$nulls":5},"end caps",{"$f":"C11+1","v":20},{"v":1.59,"d":"$1.59"},{"v":31.8,"d":"$31.80"}]
[{"$nulls":5},"T connectors",{"$f":"C11","v":19},{"v":2.59,"d":"$2.59"},{"v":49.209999999999994,"d":"$49.21"}]
[{"$nulls":5},"Head assembly and zone valves",1,{"v":55,"d":"$55.00"},{"v":55,"d":"$55.00"}]
[{"$nulls":5},"Total Drip System",null,null,{"$f":"SUM(I26:I31)","v":{"v":893.762,"d":"$893.76"}}]

{"sheet":"Step 6-7","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[3,1,5,4],[3,6,6,9],[12,1,13,4],[17,6,19,9],[19,1,21,4],[31,1,31,4]]}
[]
[null,"Step 6 (Year 0)",{"$nulls":4},"Step 7 (Year 1)"]
[null,"Determine Your Site Preparation Costs - Equipment",{"$nulls":4},"Determine Your Planting Year Costs - Equipment"]
[null,"List each action you use to prepare your site 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/yr","Cost/hr","Cost/Yr"]
[null,"Tillage - tractor and implement",3,{"v":10,"d":"$10.00"},{"$f":"C8*D8","v":{"v":30,"d":"$30.00"}},null,"Action","Hours/yr","Cost/hr","Cost/Yr"]
[null,"Herbicide burndown (whole field) - sprayer",1,{"v":30,"d":"$30.00"},{"$f":"C9*D9","v":{"v":30,"d":"$30.00"}},null,"Tree planting (custom) - inclusive",16,{"v":30,"d":"$30.00"},{"$f":"H9*I9","v":{"v":480,"d":"$480.00"}}]
[{"$nulls":4},{"$f":"C10*D10","v":0},null,"Mulching (custom) - inclusive",6,{"v":30,"d":"$30.00"},{"v":180,"d":"$180.00"}]
[{"$nulls":6},"Drip irrigation install (custom) - labor only",6,{"v":30,"d":"$30.00"},{"v":180,"d":"$180.00"}]
[null,"Labor",{"$nulls":4},"Cover crop seeding - tractor and implement",3,{"v":50,"d":"$50.00"},{"v":150,"d":"$150.00"}]
[null,"List each action requiring hand labor, management, or consultants.  Note: labor for actions using equipment is included in the table above.",{"$nulls":4},"Deer repellent - backpack sprayer",3,{"v":20,"d":"$20.00"},{"v":60,"d":"$60.00"}]
[{"$nulls":9},0]
[null,"Action","Hours/yr","Cost/hr","Cost/Yr",{"$nulls":4},0]
[null,"Project coordination/planning/consultant",20,0,{"$f":"C16*D16","v":0}]
[{"$nulls":6},"Labor"]
[null,"Step 7b",{"$nulls":4},"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,"Determine Your Mulch and/or Herbicide Costs (Year 0 and 1)"]
[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":6},"Action","Hours/yr","Cost/hr","Cost/yr"]
[{"$nulls":6},"Project coordination/planning/consultant",0,{"v":15,"d":"$15.00"},{"$f":"H22*I22","v":0}]
[null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost",null,"Deer repellent application",3,{"v":15,"d":"$15.00"},{"v":45,"d":"$45.00"}]
[null,"wood chips",{"v":0.1,"d":"0.10"},{"v":5,"d":"$5.00"},{"$f":"C24*'Steps 1-5'!C15*D24","v":{"v":364.80000000000007,"d":"$364.80"}},{"$nulls":4},0]
[{"$nulls":9},0]
[null,"Item - Synthetic mulch","Feet","Cost/ft","Total Cost",{"$nulls":4},0]
[{"$nulls":4},{"$f":"C27*D27","v":0},{"$nulls":4},0]
[]
[null,"Herbicide","Unit","Cost/Unit","Total Cost"]
[null,"Round-up before tillage",1,{"v":18,"d":"$18.00"},{"$f":"C30*D30","v":{"v":18,"d":"$18.00"}}]
[null,"Poast for grass + pre-emergent",1,{"v":80,"d":"$80.00"},{"$f":"C31*D31","v":{"v":80,"d":"$80.00"}}]
[]
[null,"Fertilizer","Units","Cost/Unit","Total Cost"]
[null,"ESN-urea",80,{"v":0.35,"d":"$0.35"},{"$f":"D34*C34","v":{"v":28,"d":"$28.00"}}]
[null,"Potassium sulfate",200,{"v":0.2,"d":"$0.20"},{"$f":"D35*C35","v":{"v":40,"d":"$40.00"}}]
[null,"Triple super phosphate",100,{"v":0.35,"d":"$0.35"},{"$f":"C36*D36","v":{"v":35,"d":"$35.00"}}]

{"sheet":"Step 8","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"merged":[[3,1,5,4],[3,6,5,9],[12,6,12,9],[14,1,15,4],[19,6,20,7]]}
[]
[null,"Step 8 (Years 2-4)",{"$nulls":4},"Step 8b"]
[null,"Determine Your Annual Pre-Production Costs - Equipment",{"$nulls":4},"Determine Your Mulch, Fertilizer, and/or Herbicide Costs (Year 2-4)"]
[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/yr","Cost/hr","Cost/Yr",null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost"]
[null,"Mowing-riding mower",5,{"v":20,"d":"$20.00"},{"$f":"C8*D8","v":{"v":100,"d":"$100.00"}},{"$nulls":4},{"$f":"H8*'Steps 1-5'!C15*I8","v":0}]
[null,"In row weed control (herbicide) - backpack sprayer",3,{"v":20,"d":"$20.00"},{"$f":"C9*D9","v":{"v":60,"d":"$60.00"}}]
[null,"In row weed control (weed whip)",3,{"v":20,"d":"$20.00"},{"$f":"C10*D10","v":{"v":60,"d":"$60.00"}},null,"Herbicide","Units","Cost/Unit","Total Cost"]
[null,"Deer repellent - backpack sprayer",3,{"v":20,"d":"$20.00"},{"$f":"C11*D11","v":{"v":60,"d":"$60.00"}},null,"glyphosate",1,{"v":18,"d":"$18.00"},{"$f":"H11*I11","v":{"v":18,"d":"$18.00"}}]
[{"$nulls":4},{"$f":"C12*D12","v":0},null,"Poast",1,{"v":40,"d":"$40.00"},{"$f":"H12*I12","v":{"v":40,"d":"$40.00"}}]
[]
[null,"Labor",{"$nulls":4},"Fertilizer","Units","Cost/Unit","Total Cost"]
[null,"List each action requiring hand labor, management, or consultants.  Note: labor for actions using equipment is included in the table above.",{"$nulls":4},"ESN-urea",80,{"v":0.35,"d":"$0.35"},{"$f":"I15*H15","v":{"v":28,"d":"$28.00"}}]
[{"$nulls":9},{"$f":"H16*I16","v":0}]
[null,"Action","Hours/yr","Cost/hr","Cost/Yr"]
[null,"Hand fertilizing",3,{"v":15,"d":"$15.00"},{"$f":"C18*D18","v":{"v":45,"d":"$45.00"}},null,"Step 8c"]
[null,"Deer repellent application",3,{"v":15,"d":"$15.00"},{"$f":"C19*D19","v":{"v":45,"d":"$45.00"}},null,"Determine Your Re-Plant Plant Costs"]
[{"$nulls":4},{"$f":"C20*D20","v":0},null,"Enter your percent mortality and the cost of each replacement plant."]
[{"$nulls":4},{"$f":"C21*D21","v":0}]
[{"$nulls":6},"Item","Value"]
[{"$nulls":6},"Percent Replacement",{"v":0.03,"d":"3%"}]
[{"$nulls":6},"Total Plants",{"$f":"H23*'Steps 1-5'!$C$15","v":{"v":21.887999999999998,"d":"22"}}]
[{"$nulls":6},"Plant Cost",{"v":5,"d":"$5.00"}]

{"sheet":"Step 9","index":4,"n_rows":17,"n_cols":10,"rows_kept":17,"merged":[[3,1,5,4],[3,6,5,9],[12,6,12,9]]}
[]
[null,"Step 9a (Years 5-8)",{"$nulls":4},"Step 9b"]
[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/yr","Cost/hr","Cost/yr",null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost"]
[null,"Mowing-riding mower",5,{"v":20,"d":"$20.00"},{"$f":"C8*D8","v":{"v":100,"d":"$100.00"}},{"$nulls":4},{"$f":"H8*'Steps 1-5'!C15*I8","v":0}]
[{"$nulls":4},{"$f":"C9*D9","v":0}]
[{"$nulls":4},{"$f":"C10*D10","v":0},null,"Herbicide","Units","Cost/Unit","Total Cost"]
[{"$nulls":9},{"$f":"H11*I11","v":0}]
[null,"Labor",{"$nulls":7},{"$f":"H12*I12","v":0}]
[null,"Action","Hours/yr","Cost/hr","Cost/yr"]
[{"$nulls":4},{"$f":"C14*D14","v":0},null,"Fertilizer","Units","Cost/Unit","Total Cost"]
[null,"Hand fertilizing",3,{"v":15,"d":"$15.00"},{"$f":"C15*D15","v":{"v":45,"d":"$45.00"}},null,"ESN-Urea",80,{"v":0.35,"d":"$0.35"},{"$f":"H15*I15","v":{"v":28,"d":"$28.00"}}]
[null,"Renewal pruning",20,{"v":15,"d":"$15.00"},{"$f":"C16*D16","v":{"v":300,"d":"$300.00"}}]
[{"$nulls":4},{"$f":"C17*D17","v":0}]

{"sheet":"Step 10","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,"Because available hazelnut plants are primarily seedling origin and genetically unique 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 10 (Year 8)",{"$nulls":4},"Step 10a"]
[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-5'!C15","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 11","index":6,"n_rows":18,"n_cols":10,"rows_kept":18,"merged":[[3,1,5,4],[3,6,5,9],[12,6,12,9]]}
[]
[null,"Step 11a (Years 9-15)",{"$nulls":4},"Step 11b"]
[null,"Determine Your Annual Full Production Costs - Equipment",{"$nulls":4},"Determine Your Mulch, Fertilizer, and/or Herbicide Costs (Years 9-15)"]
[null,"List each action you use to maintain your plants in the full-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/yr","Cost/hr","Cost/yr",null,"Item - Organic mulch","Yds/plant","Cost/yd","Total Cost"]
[null,"Mowing-riding mower",5,{"v":20,"d":"$20.00"},{"$f":"C8*D8","v":{"v":100,"d":"$100.00"}},{"$nulls":4},{"$f":"H8*'Steps 1-5'!C15*I8","v":0}]
[{"$nulls":4},{"$f":"C9*D9","v":0}]
[{"$nulls":4},0,null,"Herbicide","Units","Cost/Unit","Total Cost"]
[{"$nulls":4},0,{"$nulls":4},{"$f":"H11*I11","v":0}]
[{"$nulls":9},{"$f":"H12*I12","v":0}]
[null,"Labor"]
[null,"Action","Hours/yr","Cost/hr","Cost/yr",null,"Fertilizer","Units","Cost/Unit","Total Cost"]
[null,"Hand fertilizing",5,{"v":15,"d":"$15.00"},{"$f":"C15*D15","v":{"v":75,"d":"$75.00"}},null,"ESN-Urea",160,{"v":0.35,"d":"$0.35"},{"$f":"H15*I15","v":{"v":56,"d":"$56.00"}}]
[null,"Renewal pruning",20,{"v":15,"d":"$15.00"},{"v":300,"d":"$300.00"},{"$nulls":4},{"$f":"H16*I16","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]

{"sheet":"Step 12-13","index":7,"n_rows":50,"n_cols":19,"rows_kept":50,"merged":[[3,1,5,7],[6,3,6,4],[7,3,7,4],[8,3,8,4],[26,1,29,4],[26,6,28,9],[27,18,27,19],[28,18,28,19],[29,18,29,19],[30,18,30,19],[32,18,32,19]]}
[]
[null,"Step 12 Production Volumes and Revenue"]
[null,"Determine Your Annual Harvest Production"]
[null,"Enter the name of each market to which you sell your in-shell nuts and the price paid to you for each market.  For each year, enter the average lbs of in-shell nuts harvested per shrub.  Enter the % of the total harvest sold to each market."]
[]
[]
[null,null,"Market 1:","AHC",null,"Price:",{"v":1.5,"d":"$1.50"},"$/lb"]
[null,null,"Market 2:",null,null,"Price:",null,"$/lb"]
[null,null,"Market 3:",null,null,"Price:",null,"$/lb"]
[null,"Year","canopy coverage","lbs kernel/ac","lbs in-shell","% market 1","% market 2","% market 3"]
[null,3,{"v":0.15,"d":"15%"},{"$f":"((C11*43560)*0.02)/16","v":{"v":8.1675,"d":"8.17"}},{"$f":"D11/0.4","v":{"v":20.41875,"d":"20"}},{"v":1,"d":"100%"}]
[null,4,{"v":0.25,"d":"25%"},{"$f":"((C12*43560)*0.17)/16","v":{"v":115.70625000000001,"d":"115.71"}},{"v":289.265625,"d":"289"},{"v":1,"d":"100%"}]
[null,5,{"v":0.4,"d":"40%"},{"$f":"((C13*43560)*0.28)/16","v":304.92},{"v":762.3,"d":"762"},{"v":1,"d":"100%"}]
[null,6,{"v":0.45,"d":"45%"},{"$f":"((C14*43560)*0.42)/16","v":{"v":514.5525,"d":"514.55"}},{"v":1286.38125,"d":"1286"},{"v":1,"d":"100%"}]
[null,7,{"v":0.5,"d":"50%"},{"$f":"((C15*43560)*0.62)/16","v":{"v":843.975,"d":"843.98"}},{"v":2109.9375,"d":"2110"},{"v":1,"d":"100%"}]
[null,8,{"v":0.5,"d":"50%"},{"$f":"((C16*43560)*0.66)/16","v":{"v":898.4250000000001,"d":"898.43"}},{"v":2246.0625,"d":"2246"},{"v":1,"d":"100%"}]
[null,9,{"v":0.5,"d":"50%"},{"$f":"((C17*43560)*0.72)/16","v":{"v":980.0999999999999,"d":"980.10"}},{"v":2450.2499999999995,"d":"2450"},{"v":1,"d":"100%"}]
[null,10,{"v":0.5,"d":"50%"},{"$f":"((C18*43560)*0.72)/16","v":{"v":980.0999999999999,"d":"980.10"}},{"v":2450.2499999999995,"d":"2450"},{"v":1,"d":"100%"}]
[null,11,{"v":0.5,"d":"50%"},{"$f":"((C19*43560)*0.85)/16","v":{"v":1157.0625,"d":"1157.06"}},{"v":2892.65625,"d":"2893"},{"v":1,"d":"100%"}]
[null,12,{"v":0.5,"d":"50%"},{"$f":"((C20*43560)*0.72)/16","v":{"v":980.0999999999999,"d":"980.10"}},{"v":2450.2499999999995,"d":"2450"},{"v":1,"d":"100%"}]
[null,13,{"v":0.5,"d":"50%"},{"$f":"((C21*43560)*0.85)/16","v":{"v":1157.0625,"d":"1157.06"}},{"v":2892.65625,"d":"2893"},{"v":1,"d":"100%"}]
[null,14,{"v":0.5,"d":"50%"},{"$f":"((C22*43560)*0.72)/16","v":{"v":980.0999999999999,"d":"980.10"}},{"v":2450.2499999999995,"d":"2450"},{"v":1,"d":"100%"}]
[null,15,{"v":0.5,"d":"50%"},{"$f":"((C23*43560)*0.85)/16","v":{"v":1157.0625,"d":"1157.06"}},{"v":2892.65625,"d":"2893"},{"v":1,"d":"100%"}]
[]
[null,"Step 13a Harvest Costs",{"$nulls":4},"Step 13b (Drying and Husking Costs)"]
[null,"Determine Your Annual Harvest Cost",{"$nulls":4},"Determine Your Annual Drying and Husking Costs",{"$nulls":7},"Hazelnut Husking Options (For Step 13a)"]
[null,"For each year choose whether to harvest by hand or with a machine.  If your own the machine use an hourly rate equal to the annual depreciation and operating costs for the machine.",{"$nulls":4},"Enter the labor and equipment costs for husking and drying the hazelnuts"]
[{"$nulls":14},"Option",null,"lbs/hr","Custom Rate ($/lb)","Equipment Ownership Cost*"]
[{"$nulls":14},"Hand husking"]
[{"$nulls":7},"Husker Flow-Through Rate:",400,"lbs/hr",{"$nulls":4},"Bucket husker"]
[{"$nulls":7},"Hrs of labor/hr of operation:",{"v":0,"d":"0.00"},"hrs",{"$nulls":4},"Super Squirrel husker"]
[null,null,"Hand Harvest Rate:",13,"lbs/hr",null,null,"Labor Rate:",{"v":10,"d":"$10.00"},"$/hr",{"$nulls":4},"UW-Extension drum husker",null,200,{"v":0.03,"d":"$0.03"},{"$f":"500/15","v":{"v":33.333333333333336,"d":"$33.33"}}]
[null,null,"Hand Harvest Labor:",{"v":15,"d":"$15.00"},"$/hr",null,null,"Husker Lease Rate:",0,"$/hr",{"$nulls":4},"Other"]
[null,null,"Machine Harvest Rate:",1850,"lbs/hr",{"$nulls":9},"* The annual ownership and maintenance cost ammortized over 15 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 Step14a."]
[null,null,"Machine Custom Rate:",{"v":250,"d":"$250.00"},"$/hr",null,"Year","Lbs harvested","Cost/Yr"]
[{"$nulls":6},3,{"$f":"E11","v":{"v":20.41875,"d":"20"}},{"$f":"((H36/$I$30)*$I$33)+(((H36/$I$30)*$I$31)*$I$32)","v":0}]
[null,"Year","Machine/Hand","Cost/Yr",null,null,4,{"v":289.265625,"d":"289"},0]
[null,3,"Hand",{"$f":"IF(C38=\"Hand\",((E11/$D$32)*$D$33),((E11/$D$34)*$D$35))","v":{"v":23.560096153846153,"d":"$23.56"}},null,null,5,{"v":762.3,"d":"762"},0]
[null,4,"Machine",{"v":39.08994932432432,"d":"$39.09"},null,null,6,{"v":1286.38125,"d":"1286"},0]
[null,5,"Machine",{"v":103.01351351351352,"d":"$103.01"},null,null,7,{"v":2109.9375,"d":"2110"},0]
[null,6,"Machine",{"v":173.83530405405403,"d":"$173.84"},null,null,8,{"v":2246.0625,"d":"2246"},0]
[null,7,"Machine",{"v":285.1266891891892,"d":"$285.13"},null,null,9,{"v":2450.2499999999995,"d":"2450"},0]
[null,8,"Machine",{"v":303.5219594594595,"d":"$303.52"},null,null,10,{"v":2450.2499999999995,"d":"2450"},0]
[null,9,"Machine",{"v":331.1148648648648,"d":"$331.11"},null,null,11,{"v":2892.65625,"d":"2893"},0]
[null,10,"Machine",{"v":331.1148648648648,"d":"$331.11"},null,null,12,{"v":2450.2499999999995,"d":"2450"},0]
[null,11,"Machine",{"v":390.8994932432432,"d":"$390.90"},null,null,13,{"v":2892.65625,"d":"2893"},0]
[null,12,"Machine",{"v":331.1148648648648,"d":"$331.11"},null,null,14,{"v":2450.2499999999995,"d":"2450"},0]
[null,13,"Machine",{"v":390.8994932432432,"d":"$390.90"},null,null,15,{"v":2892.65625,"d":"2893"},0]
[null,14,"Machine",{"v":331.1148648648648,"d":"$331.11"}]
[null,15,"Machine",{"v":390.8994932432432,"d":"$390.90"}]

{"sheet":"budget","index":8,"n_rows":34,"n_cols":21,"rows_kept":34,"merged":[[1,2,1,17],[2,2,2,3],[2,4,2,6],[2,7,2,9],[2,11,2,17]]}
[null,"Your Hazelnut Production Enterprise Budget (Year 0 -15)"]
[null,null,"Year"]
[null,null,"Establishment",null,"Pre-Production",null,null,"Early Production",{"$nulls":3},"Full Production"]
[null,"Revenue",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"In-shell nut sales"]
[null,"Market 1",{"$nulls":3},{"$f":"'Step 12-13'!G7*('Step 12-13'!F11*'Step 12-13'!E11)","v":{"v":30.628124999999997,"d":"$31"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F12*'Step 12-13'!E12","v":{"v":433.8984375,"d":"$434"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F13*'Step 12-13'!E13","v":{"v":1143.4499999999998,"d":"$1,143"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F14*'Step 12-13'!E14","v":{"v":1929.5718749999999,"d":"$1,930"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F15*'Step 12-13'!E15","v":{"v":3164.90625,"d":"$3,165"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F16*'Step 12-13'!E16","v":{"v":3369.09375,"d":"$3,369"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F17*'Step 12-13'!E17","v":{"v":3675.374999999999,"d":"$3,675"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F18*'Step 12-13'!E18","v":{"v":3675.374999999999,"d":"$3,675"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F19*'Step 12-13'!E19","v":{"v":4338.984375,"d":"$4,339"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F20*'Step 12-13'!E20","v":{"v":3675.374999999999,"d":"$3,675"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F21*'Step 12-13'!E21","v":{"v":4338.984375,"d":"$4,339"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F22*'Step 12-13'!E22","v":{"v":3675.374999999999,"d":"$3,675"}},{"$f":"'Step 12-13'!G7*'Step 12-13'!F23*'Step 12-13'!E23","v":{"v":4338.984375,"d":"$4,339"}}]
[null,"Market 2",{"$nulls":3},{"$f":"'Step 12-13'!G8*'Step 12-13'!G11*'Step 12-13'!E11","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G12*'Step 12-13'!E12","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G13*'Step 12-13'!E13","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G14*'Step 12-13'!E14","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G15*'Step 12-13'!E15","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G16*'Step 12-13'!E16","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G17*'Step 12-13'!E17","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G18*'Step 12-13'!E18","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G19*'Step 12-13'!E19","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G20*'Step 12-13'!E20","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G21*'Step 12-13'!E21","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G22*'Step 12-13'!E22","v":0},{"$f":"'Step 12-13'!G8*'Step 12-13'!G23*'Step 12-13'!E23","v":0}]
[null,"Market 3",{"$nulls":3},{"$f":"'Step 12-13'!G9*'Step 12-13'!H11*'Step 12-13'!E11","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H12*'Step 12-13'!E12","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H13*'Step 12-13'!E13","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H14*'Step 12-13'!E14","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H15*'Step 12-13'!E15","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H16*'Step 12-13'!E16","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H17*'Step 12-13'!E17","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H18*'Step 12-13'!E18","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H19*'Step 12-13'!E19","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H20*'Step 12-13'!E20","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H21*'Step 12-13'!E21","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H22*'Step 12-13'!E22","v":0},{"$f":"'Step 12-13'!G9*'Step 12-13'!H23*'Step 12-13'!E23","v":0}]
[]
[null,"Total Gross Revenue",{"$f":"SUM(C6:C8)","v":0},0,0,{"v":30.628124999999997,"d":"$31"},{"v":433.8984375,"d":"$434"},{"v":1143.4499999999998,"d":"$1,143"},{"v":1929.5718749999999,"d":"$1,930"},{"v":3164.90625,"d":"$3,165"},{"v":3369.09375,"d":"$3,369"},{"v":3675.374999999999,"d":"$3,675"},{"v":3675.374999999999,"d":"$3,675"},{"v":4338.984375,"d":"$4,339"},{"v":3675.374999999999,"d":"$3,675"},{"v":4338.984375,"d":"$4,339"},{"v":3675.374999999999,"d":"$3,675"},{"v":4338.984375,"d":"$4,339"}]
[]
[null,"Expenses"]
[null,"Land Cost"]
[null,"Owned",{"$f":"SUM('Steps 1-5'!C24:C26)","v":0},{"$f":"C14","v":0},{"$f":"D14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rented",{"$f":"'Steps 1-5'!C28","v":{"v":100,"d":"$100"}},{"$f":"C15","v":{"v":100,"d":"$100"}},{"$f":"D15","v":{"v":100,"d":"$100"}},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"}]
[null,"Supplies and Materials"]
[null,"Plants",0,{"$f":"SUM('Steps 1-5'!I6:I7)","v":{"v":2553.6,"d":"$2,554"}},{"$f":"'Step 8'!H24*'Step 8'!H25","v":{"v":109.44,"d":"$109"}},0,0,0,0,0,{"$f":"'Step 10'!H13*'Step 10'!H14","v":0},0,0,0,0,0,0,0]
[null,"Drip Irrigation",0,{"$f":"'Steps 1-5'!I32","v":{"v":893.762,"d":"$894"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Tree Tubes",0,{"$f":"'Steps 1-5'!H16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Fertilizer",{"$f":"'Step 6-7'!E34+'Step 6-7'!E35+'Step 6-7'!E36","v":{"v":103,"d":"$103"}},0,{"$f":"'Step 8'!J15+'Step 8'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 8'!J15+'Step 8'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 8'!J15+'Step 8'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 9'!J15+'Step 9'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 9'!J15+'Step 9'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 9'!J15+'Step 9'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 9'!J15+'Step 9'!J16","v":{"v":28,"d":"$28"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}},{"$f":"'Step 11'!$J$15+'Step 11'!$J$16","v":{"v":56,"d":"$56"}}]
[null,"Herbicide",0,{"$f":"SUM('Step 6-7'!E30:E31)","v":{"v":98,"d":"$98"}},{"$f":"'Step 8'!J11+'Step 8'!J12","v":{"v":58,"d":"$58"}},{"$f":"SUM('Step 8'!J11:J12)","v":{"v":58,"d":"$58"}},{"$f":"'Step 8'!J11+'Step 8'!J12","v":{"v":58,"d":"$58"}},{"$f":"'Step 9'!J11+'Step 9'!J12","v":0},{"$f":"'Step 9'!J11+'Step 9'!J12","v":0},{"$f":"'Step 9'!J11+'Step 9'!J12","v":0},{"$f":"'Step 9'!J11+'Step 9'!J12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0},{"$f":"'Step 11'!$J$11+'Step 11'!$J$12","v":0}]
[null,"Organic mulch",0,{"$f":"'Step 6-7'!E24","v":{"v":364.80000000000007,"d":"$365"}},{"$f":"'Step 8'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 9'!J8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0},{"$f":"'Step 11'!$J$8","v":0}]
[null,"Synthetic mulch",null,{"$f":"'Step 6-7'!E27","v":0}]
[null,"Total Supplies and Materials",{"$f":"SUM(C17:C22)","v":{"v":103,"d":"$103"}},{"$f":"SUM(D17:D22)","v":{"v":3910.1620000000003,"d":"$3,910"}},{"v":195.44,"d":"$195"},{"v":86,"d":"$86"},{"v":86,"d":"$86"},{"v":28,"d":"$28"},{"v":28,"d":"$28"},{"v":28,"d":"$28"},{"v":28,"d":"$28"},{"v":56,"d":"$56"},{"v":56,"d":"$56"},{"v":56,"d":"$56"},{"v":56,"d":"$56"},{"v":56,"d":"$56"},{"v":56,"d":"$56"},{"v":56,"d":"$56"}]
[]
[null,"Custom Equipment and Operator",{"$f":"SUM('Step 6-7'!E8:E10)","v":{"v":60,"d":"$60"}},{"$f":"SUM('Step 6-7'!J9:J15)","v":{"v":1050,"d":"$1,050"}},{"$f":"SUM('Step 8'!E8:E12)","v":{"v":280,"d":"$280"}},{"$f":"E26","v":{"v":280,"d":"$280"}},{"$f":"F26","v":{"v":280,"d":"$280"}},{"$f":"SUM('Step 9'!E8:E10)","v":{"v":100,"d":"$100"}},{"$f":"H26","v":{"v":100,"d":"$100"}},{"$f":"H26","v":{"v":100,"d":"$100"}},{"$f":"SUM('Step 10'!E13:E19)","v":0},{"$f":"SUM('Step 11'!E8:E11)","v":{"v":100,"d":"$100"}},{"$f":"L26","v":{"v":100,"d":"$100"}},{"$f":"M26","v":{"v":100,"d":"$100"}},{"$f":"N26","v":{"v":100,"d":"$100"}},{"v":100,"d":"$100"},{"v":100,"d":"$100"},{"v":100,"d":"$100"}]
[null,"General Labor",{"$f":"SUM('Step 6-7'!E16)","v":0},{"$f":"SUM('Step 6-7'!J22:J27)","v":{"v":45,"d":"$45"}},{"$f":"SUM('Step 8'!E18:E21)","v":{"v":90,"d":"$90"}},{"$f":"E27","v":{"v":90,"d":"$90"}},{"$f":"F27","v":{"v":90,"d":"$90"}},{"$f":"SUM('Step 9'!E14:E17)","v":{"v":345,"d":"$345"}},{"$f":"H27","v":{"v":345,"d":"$345"}},{"$f":"H27","v":{"v":345,"d":"$345"}},{"$f":"SUM('Step 10'!E25:E29)","v":0},{"$f":"SUM('Step 11'!E15:E18)","v":{"v":375,"d":"$375"}},{"$f":"L27","v":{"v":375,"d":"$375"}},{"$f":"M27","v":{"v":375,"d":"$375"}},{"v":375,"d":"$375"},{"v":375,"d":"$375"},{"v":375,"d":"$375"},{"v":375,"d":"$375"}]
[null,"Custom Harvest Cost",{"$nulls":3},{"$f":"'Step 12-13'!D38","v":{"v":23.560096153846153,"d":"$24"}},{"$f":"'Step 12-13'!D39","v":{"v":39.08994932432432,"d":"$39"}},{"$f":"'Step 12-13'!D40","v":{"v":103.01351351351352,"d":"$103"}},{"$f":"'Step 12-13'!D41","v":{"v":173.83530405405403,"d":"$174"}},{"$f":"'Step 12-13'!D42","v":{"v":285.1266891891892,"d":"$285"}},{"$f":"'Step 12-13'!D43","v":{"v":303.5219594594595,"d":"$304"}},{"$f":"'Step 12-13'!D44","v":{"v":331.1148648648648,"d":"$331"}},{"$f":"'Step 12-13'!D45","v":{"v":331.1148648648648,"d":"$331"}},{"$f":"'Step 12-13'!D46","v":{"v":390.8994932432432,"d":"$391"}},{"$f":"'Step 12-13'!D47","v":{"v":331.1148648648648,"d":"$331"}},{"$f":"'Step 12-13'!D48","v":{"v":390.8994932432432,"d":"$391"}},{"$f":"'Step 12-13'!D49","v":{"v":331.1148648648648,"d":"$331"}},{"$f":"'Step 12-13'!D50","v":{"v":390.8994932432432,"d":"$391"}}]
[null,"Drying and Husking",{"$nulls":3},{"$f":"'Step 12-13'!I36","v":0},{"$f":"'Step 12-13'!I37","v":0},{"$f":"'Step 12-13'!I38","v":0},{"$f":"'Step 12-13'!I39","v":0},{"$f":"'Step 12-13'!I40","v":0},{"$f":"'Step 12-13'!I41","v":0},{"$f":"'Step 12-13'!I43","v":0},{"$f":"'Step 12-13'!I44","v":0},{"$f":"'Step 12-13'!I44","v":0},{"$f":"'Step 12-13'!I45","v":0},{"$f":"'Step 12-13'!I46","v":0},{"$f":"'Step 12-13'!I47","v":0},{"$f":"'Step 12-13'!I48","v":0},null,null,{"$f":"759/2893","v":0.2623574144486692}]
[]
[null,"Total Expenses",{"$f":"C14+C15+C24+C26+C27+C28","v":{"v":263,"d":"$263"}},{"v":5105.162,"d":"$5,105"},{"v":665.44,"d":"$665"},{"v":579.5600961538462,"d":"$580"},{"v":595.0899493243244,"d":"$595"},{"v":676.0135135135135,"d":"$676"},{"v":746.8353040540541,"d":"$747"},{"v":858.1266891891892,"d":"$858"},{"v":431.5219594594595,"d":"$432"},{"v":962.1148648648648,"d":"$962"},{"v":962.1148648648648,"d":"$962"},{"v":1021.8994932432432,"d":"$1,022"},{"v":962.1148648648648,"d":"$962"},{"v":1021.8994932432432,"d":"$1,022"},{"v":962.1148648648648,"d":"$962"},{"v":1021.8994932432432,"d":"$1,022"}]
[]
[null,"Annual Cash Flow",{"$f":"C10-C31","v":{"v":-263,"d":"$(263)"}},{"v":-5105.162,"d":"$(5,105)"},{"v":-665.44,"d":"$(665)"},{"v":-548.9319711538462,"d":"$(549)"},{"v":-161.19151182432438,"d":"$(161)"},{"v":467.4364864864863,"d":"$467"},{"v":1182.736570945946,"d":"$1,183"},{"v":2306.779560810811,"d":"$2,307"},{"v":2937.5717905405404,"d":"$2,938"},{"v":2713.260135135134,"d":"$2,713"},{"v":2713.260135135134,"d":"$2,713"},{"v":3317.0848817567567,"d":"$3,317"},{"v":2713.260135135134,"d":"$2,713"},{"v":3317.0848817567567,"d":"$3,317"},{"v":2713.260135135134,"d":"$2,713"},{"v":3317.0848817567567,"d":"$3,317"}]
[null,"Cumulative Cash Flow",{"$f":"C33","v":{"v":-263,"d":"$(263)"}},{"$f":"C34+D33","v":{"v":-5368.162,"d":"$(5,368)"}},{"$f":"D34+E33","v":{"v":-6033.602000000001,"d":"$(6,034)"}},{"v":-6582.533971153847,"d":"$(6,583)"},{"v":-6743.725482978171,"d":"$(6,744)"},{"v":-6276.288996491685,"d":"$(6,276)"},{"v":-5093.5524255457385,"d":"$(5,094)"},{"v":-2786.7728647349277,"d":"$(2,787)"},{"v":150.79892580561273,"d":"$151"},{"v":2864.059060940747,"d":"$2,864"},{"v":5577.319196075881,"d":"$5,577"},{"v":8894.404077832638,"d":"$8,894"},{"v":11607.664212967771,"d":"$11,608"},{"v":14924.749094724528,"d":"$14,925"},{"v":17638.00922985966,"d":"$17,638"},{"v":20955.094111616418,"d":"$20,955"}]

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

{"sheet":"graph","index":10,"n_rows":18,"n_cols":2,"rows_kept":18,"merged":[[26,2,26,3]]}
[]
["Year","Cumulative"]
[0,{"$f":"budget!C33","v":{"v":-263,"d":"$(263)"}}]
[1,{"$f":"B3+budget!D33","v":{"v":-5368.162,"d":"$(5,368)"}}]
[2,{"$f":"B4+budget!E33","v":{"v":-6033.602000000001,"d":"$(6,034)"}}]
[3,{"$f":"B5+budget!F33","v":{"v":-6582.533971153847,"d":"$(6,583)"}}]
[4,{"$f":"B6+budget!G33","v":{"v":-6743.725482978171,"d":"$(6,744)"}}]
[5,{"$f":"B7+budget!H33","v":{"v":-6276.288996491685,"d":"$(6,276)"}}]
[6,{"$f":"B8+budget!I33","v":{"v":-5093.5524255457385,"d":"$(5,094)"}}]
[7,{"$f":"B9+budget!J33","v":{"v":-2786.7728647349277,"d":"$(2,787)"}}]
[8,{"$f":"B10+budget!K33","v":{"v":150.79892580561273,"d":"$151"}}]
[9,{"$f":"B11+budget!L33","v":{"v":2864.059060940747,"d":"$2,864"}}]
[10,{"$f":"B12+budget!M33","v":{"v":5577.319196075881,"d":"$5,577"}}]
[11,{"$f":"B13+budget!N33","v":{"v":8894.404077832638,"d":"$8,894"}}]
[12,{"$f":"B14+budget!O33","v":{"v":11607.664212967771,"d":"$11,608"}}]
[13,{"$f":"B15+budget!P33","v":{"v":14924.749094724528,"d":"$14,925"}}]
[14,{"$f":"B16+budget!Q33","v":{"v":17638.00922985966,"d":"$17,638"}}]
[15,{"$f":"B17+budget!R33","v":{"v":20955.094111616418,"d":"$20,955"}}]