{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Read Me","Farm Info","Tillage","Nutrient Mgt.","Cover Crops","Combined Practice Effects","ONLY CCR","Partial Budget Analysis","Editable PBA","Prices","Machinery Costs","Net Income Values by Crop","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":162,"n_cols":4,"rows_kept":162,"cut":false,"hidden":false,"merged":[[118,1,118,3],[119,1,119,3],[111,1,111,3],[114,1,114,3],[113,1,113,3],[112,1,112,3],[115,1,115,3],[59,0,59,3],[61,2,61,3],[0,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[57,0,57,3],[58,0,58,3],[7,0,55,3],[6,0,6,3],[129,1,129,3],[130,1,130,3],[139,1,139,3],[138,1,138,3],[60,1,60,3],[88,1,88,3],[121,1,121,3],[125,1,125,3],[124,1,124,3],[102,1,103,3],[120,1,120,3],[117,1,117,3],[92,1,92,3],[91,1,91,3],[107,1,107,3],[116,1,116,3],[141,1,141,3],[131,1,131,3],[137,1,137,3],[133,1,133,3],[149,1,149,3],[147,0,147,3],[146,0,146,3],[134,1,134,3],[140,1,140,3],[144,1,144,3],[136,1,136,3],[143,1,143,3],[142,1,142,3],[135,1,135,3],[132,1,132,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[71,1,71,3],[90,1,90,3],[81,1,81,3],[72,1,72,3],[80,1,80,3],[73,1,73,3],[75,1,75,3],[78,1,78,3],[77,1,77,3],[79,1,79,3],[82,1,82,3],[65,2,65,3],[66,2,66,3],[67,1,69,3],[74,1,74,3],[76,1,76,3],[83,1,83,3],[84,1,84,3],[126,1,126,3],[128,1,128,3],[127,1,127,3],[85,1,85,3],[86,1,86,3],[93,1,93,3],[95,1,95,3],[96,1,96,3],[98,1,98,3],[101,1,101,3],[122,1,122,3],[123,1,123,3],[97,1,97,3],[99,1,99,3],[105,1,105,3],[106,1,106,3]]}
[]
[]
[]
["Retrospective Soil Health Economic Calculator (R-SHEC) Tool"]
["ROW CROP VERSION"]
["© 2022 American Farmland Trust "]
["Updated: September 28, 2022"]
["The Row Crop version of the R-SHEC Tool is designed to estimate the economic effects, retrospectively, of soil health practices adopted by \"soil health successful\" row crop farmers. The Tool can be used with row crop farmers that have adopted any combination of No-till or Reduced Tillage, Cover Cropping, and Nutrient Management, OR Conservation Crop Rotation for four or more years and within the last 15 years, on fields growing barley, corn grain, corn silage, grain sorghum (milo), soybeans, oats, wheat, and/or hay.\n\nThe Tool analyzes the costs and benefits of benchmark operations (pre-adoption of soil health practices) versus current operations (post-adoption of soil health practices) that changed with adoption. The farmer must have a clear understanding of their average benchmark versus current costs and benefits.\n\nThe Tool employs a partial budget analysis (PBA) to estimate the change in net income due to adoption of soil health practices. A PBA focuses only on variables that change. This PBA analyzes economic effects within these cost/benefit categories: machinery, fertilizer, pesticide, yield, erosion repair, learning costs, and open-ended \"other costs/benefits\". The Tool compares average costs & benefits in these categories \"before\" & \"after\" soil health practice adoption, relying on a combination of user inputs and standardized cost and price information built into the Tool.  Whenever possible, national prices or costs are used to avoid biasing the results in cases where the farmer's prices may not be representative of typical prices.  However, the user does have the option to use the farmer's own prices for fertilizer and crops.  Prices and their sources are listed on the \"Prices\", \"Machinery Costs\", and \"Net Income Values by Crop\" tabs. Results are displayed in a PBA table on an annual basis for the Study Area on the Partial Budget Analysis tabs.\n\nVisit     https://farmland.salsalabs.org/sh_casestudies_methods/index.html          to download the Soil Health Case Study Tool Kit to gain access to the R-SHEC Questionnaire and for the latest verison of this Tool and associated documents.\n\nNotes:\n    - The Row Crop R-SHEC Tool was designed for use in Mid-Western and Mid-Atlantic states but could be used \n       elsewhere with price or cost adjustments as needed.\n    - Users should first complete the Row Crop R-SHEC Questionnaire so that data needed by the Tool is \n      organized and at hand.\n    - Adoption of a Conservation Crop Rotation cannot be analyzed with other soil health practices. Users can \n      only analyze a Conservation Crop Rotation as a sole soil health practice. See \"ONLY CCR\" tab for more \n      details.\n    - Users cannot analyze corn silage with the adoption of a conservation crop rotation because there is no \n      commodity cost and return data (see \"Net Income Values by Crop\") to calculate the net income value of corn \n      silage.\n\nAmerican Farmland Trust (AFT) used the R-SHEC Tool to conduct the PBA for case studies of soil health successful farms in various states as part of a Conservation Innovation Grant, \"Quantifying the Economic and Environmental Benefits of Soil Health\" (NR183A750008G008).  These case studies as well as a summary of the findings are available on the AFT website:\n\n\nFor more information, please contact:\nMichelle Perez, Project Leader and Water Initiative Director, American Farmland Trust at mperez@farmland.org\nFor trouble-shooting assistance with the R-SHEC Tool, please contact: \nEllen Yeatman, Agricultural Economist, American Farmland Trust at eyeatman@farmland.org\nSpecial thanks to Florence Swartz, Lead Developer of the R-SHEC Tool and Consulting Economist for AFT 2018 - 2021, Retired NRCS-NY Economist"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["BEFORE BEGINNING DATA ENTRY, CREATE A NEW VERSION OF THE WORKBOOK"]
[" FOR YOUR SOIL HEALTH SUCCESSFUL FARMER"]
[]
[null,"Practices Evaluated"]
[null,"NRCS Practice Code","Practice Name"]
[null,329,"Residue and Tillage Management - No-Till"]
[null,345,"Residue and Tillage Management - Reduced Till"]
[null,340,"Cover Crops"]
[null,590,"Nutrient Management"]
[null,328,"Conservation Crop Rotation"]
[null,"Note: With the exception of the two Residue and Tillage Management Practices, data entry for each practice occurs on a separate worksheet.  No-Till and Reduced Tillage data entry is combined into a single worksheet due to similarity between the two practices. "]
[]
[]
[]
[null,"General Information"]
[1,"This workbook is protected in order to protect formulas throughout the workbook.  Data entry is allowed in yellow-shaded cells."]
[null,"In order to adjust any information on the Price, Machinery Costs, Net Income Values by Crop, or Lists tabs (also referred to as "]
[null,"worksheets) or to view formulas, follow these steps for full access to protected sheets:"]
[null,"a. Click on \"File\" in the green banner in the top left corner;"]
[null,"b. Click on \"Info\" to open a page containing a yellow box called \"Protect Workbook\" that lists protected worksheets;"]
[null,"c. Click on \"Unprotect\" adjacent to each worksheet you wish to have access to;"]
[null,"d. To re-protect a worksheet, select \"File\" as before;  select \"Info\"; select \"Protect Workbook\"; select \"Protect Current Sheet\"."]
[null,"    You will be presented with a box offering the options of selecting a password and what access, if any, you wish to allow."]
[null,"    You should allow access to unlocked cells, at a minimum, in order to allow data entry.  Navigate to the next sheet you"]
[null,"    wish to unprotect or protect and follow the same process."]
[2,"Results are stated on an annual basis per acre and for the entire Study Area."]
[3,"Results of all per acre calculations are weighted averages based on the crop rotation."]
[4,"Calculations of costs and benefits for the individual practices (or Combined Practice Effects) occur within each of the worksheets."]
[6,"Enter reductions as negative values and increases as positive values for changes in yield, fertilizer use, and pesticide use."]
[7,"Results are summarized on the Partial Budget Analysis tabs in table format."]
[]
[null,"About Individual Worksheets (aka 'Tabs')"]
[1,"Farm Info:  "]
[null,"a. Records information used throughout the workbook."]
[null,"b. REQUIRED: User must complete \"Benchmark Rotation\" and  \"Current Rotation\" tables even if farmer did not change their rotation"]
[null,"     (in that case fill in both tables with identical information)"]
[null,"c. \"Clear All Data\" button will clear all data entered in yellow-shaded cells."]
[2,"Tillage:  "]
[null,"a. Machinery costs associated with hay establishment is prorated by the number of years of hay in the rotation."]
[null,"b. Acres and years in rotation populate automatically once user selects a crop."]
[null,"c. Captures difference in tillage costs by equipment cost and number of passes over the field \"before\" versus \"after\""]
[null,"     adoption of reduced tillage soil health practices."]
[null,"d. Calculates how changes in tillage affects yield, costs of nutrients, costs of pesticides, and soil erosion."]
[3,"Cover Crops:"]
[null,"a. Captures costs of cover crop and any effects on cash crop yield, costs of nutrients, and costs of pesticides."]
[null,"b. Cover Crop costs prior to hay is prorated based on number of years of hay in the rotation. We are assuming the farmer will not plant a \n    cover crop every year during hay production."]
[]
[4,"Nutrient Management:"]
[null,"a. This worksheet is set up like the Tillage worksheet.  User selects equipment that comes closest to what the "]
[null,"    farmer is using and costs are calculated automatically."]
[null,"b. Machinery costs are for equipment ONLY and do not include costs for fertilizer (that is included in \"change in nutrients used\" tables.)"]
[5,"Combined Practice Effects:"]
[null,"a. This worksheet provides a place to record benefits or costs that cannot be attributed to a single soil health practice."]
[6,"Conservation Crop Rotation:"]
[null,"a. Captures net income change with CCR and any additional effects on yield, costs of nutrients, and costs of pesticides."]
[null,"b. NOTE: Users can only analyze a Conservation Crop Rotation as a sole soil health practice; it cannot be analyzed with other "]
[null,"    soil health practices due to data discrepancies. See \"ONLY CCR\" tab for more details."]
[null,"c. First two tables are populated automatically from Farm Info worksheet."]
[null,"d. Net income vales for establishing, growing, fertilizing, and harvesting crops are loaded from the \"Prices\" and \"Net Income Values by "]
[null,"    Crop\" tabs and used to automatically calculate changes in costs and production with a change in crop rotation."]
[7,"Partial Budget Analysis (PBA):"]
[null,"a. The PBA tab performs a partial budget analysis using calculations from each soil health practice worksheet and placing them in the"]
[null,"    correct quadrant of the PBA table to determine Annual Total and Per Acre Change in Net Income and Return on Investment."]
[null,"b. The PBA table is divided into four quadrants then presents the results at the bottom of the table:"]
[null,"    i. Increase in Income (top left side of PBA Table)"]
[null,"   ii. Decrease in Cost (bottom left side of PBA Table)"]
[null,"   iii. Decrease in Income (top right side of PBA Table)"]
[null,"   ii. Increase in Cost (bottom right side of PBA Table)"]
[null,"  iii. Results are displayed as Change in Total Net Income, Change in Per Acre Net Income, and % Return on Investment"]
[null,"c. This tab should never be unprotected to save results to reference."]
[8,"Editable PBA:"]
[null,"a. This unprotected worksheet can be modified to create a publishable version of the Partial Budget Analysis table. Instructions and"]
[null,"    guidance are provided at the top of the Editable PBA worksheet."]
[9,"Prices:"]
[null,"a. For reference, contains prices used throughout the workbook and relevant Producer Prices Paid Index for updating prices as needed."]
[null,"b. Organic crop prices are included for producers who are certified organic.  These prices will be used automatically if the "]
[null,"    user enters \"Y\" or \"y\" for Is this an organic farm? (Y/N) in the Yield Impacts section on each of the practice worksheets."]
[null,"c. Provides references to all price data sources."]
[10,"Machinery Costs:"]
[null,"a. For reference, contains per acre machinery costs used by the Tillage and Nutrient Management tabs."]
[null,"d. You can add to this list as needed, but we encourage only using published prices as they include depreciation, labor, fuel, interest, \n    discount value, salvage cost, etc. Most farmers will undervalue their per acre machinery costs. "]
[11,"Net Income Values by Crop:"]
[null,"a. For reference, this worksheet provides the 2020 and 2021 commodity costs and returns values by crop compiled by USDA Economic"]
[null,"    Research Service collected through the Agricultural Resource Management Survey."]
[null,"c. Includes a description of how we calculate net income for use on the \"ONLY CCR\" tab."]
[12,"Lists:"]
[null,"a.  This worksheet contains lists used in drop-down menus throughout the workbook."]
[null,"b.  You can add to this list as needed."]
[]
["BEFORE BEGINNING DATA ENTRY, CREATE A NEW VERSION OF THE WORKBOOK"]
[" FOR YOUR SOIL HEALTH SUCCESSFUL FARMER"]
[]
[null,"Data Sources"]
[null,"Item","Release Date","Source"]
[null,"Crop Prices, Non-organic","February","USDA NASS. (February 2022). Crop Values: 2021 Summary. Retrieved on February 28, 2022 from https://usda.library.cornell.edu/concern/publications/k35694332"]
[null,"Crop Prices, Organic","Dec. 15, 2022","USDA NASS. (October 22, 2022). Table 13. Certified Organic Field Crops and Hay Harvested and Value of Sales: 2019 Organic Survey. Retrieved February 28, 2022, from https://www.nass.usda.gov/Surveys/Guide_to_NASS_Surveys/Organic_Production/index.php"]
[null,"Fertilizer Prices","January","Iowa State University Extension and Outreach. (January 2022). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"Hay Production Costs","January","Iowa State University Extension and Outreach. (January 2022). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"Hay Yield, National Average","Indeterminant","USDA NASS. QuickStats: Statistics by Subject: Hay - Yield, Measured in Tons/Acre, National Average 2010-2021. Retrieved on March 2, 2022 from https://quickstats.nass.usda.gov/"]
[null,"Labor Rate, Farm Manager","March 31","U.S. Bureau of Labor Statistics. (March 31, 2022). 45-1011 First-Line Supervisors of Farming, Fishing, and Forestry Workers. Occupational Employment and Wage Statistics, May 2021. Retrieved April 6, 2022, from https://www.bls.gov/oes/current/oes451011.htm"]
[null,"Machinery Cost Estimates","Biennially","University of Illinois at Urbana-Champaign Department of Ag and Consumer Economics. (September 2021). Farm Business Management Machinery Cost Estimates: Field Operations. Retrieved on February 22, 2022 from https://farmdoc.illinois.edu/management#handbook"]
[null,"Machinery Costs for Fertilizer Applications","March","Iowa State University Extension and Outreach. (March 2022). Ag Decision Maker: 2022 Iowa Farm Custom Rate Survey (File A3-10). Retrieved on March 23, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a3-10.html"]
[null,"Net Income Values","May 2 & Oct 3","USDA Economic Research Service. (May 2, 2022). Commodity Costs and Returns: Recent Costs and Returns. Retrieved on June 17, 2022 from https://www.ers.usda.gov/data-products/commodity-costs-and-returns/ "]
[null,"Prices Paid Index","Monthly","USDA NASS. (Ongoing). Prices Paid: Indexes for All Items and Production Items by Month - United States. Retrieved September 22, 2022, from https://www.nass.usda.gov/Charts_and_Maps/Agricultural_Prices/index.php"]
[null,"Prices Received Index","Monthly","USDA NASS. (Ongoing). Prices Received: Indexes for Ag, Crop, and Livestock Production by Month - United States. Retrieved September 22, 2022, from https://www.nass.usda.gov/Charts_and_Maps/Agricultural_Prices/index.php"]

{"sheet":"Farm Info","index":1,"n_rows":75,"n_cols":4,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[3,0,5,6],[17,1,17,3],[24,1,24,3],[6,1,6,3],[61,1,61,6],[16,1,16,6],[34,1,34,6],[39,1,40,2],[54,3,55,3],[56,1,56,3],[57,1,57,3],[44,1,46,6]]}
["Row Crop Farm General Information"]
[]
["ABOUT THIS TAB:"]
["The Farm Info tab records very general information including farmer name, name of farm, location, watershed, Study Area benchmark and current crop rotations, Study Area soil health practices, time spent each year on educational activities, and farmer's fertilizer and crop prices (optional)."]
[]
[]
[]
[null,"Farmer Name","County","State"]
[]
[null,"Farm"]
[]
[null,"Watershed Name"]
[]
[]
[]
[null,"Study Area Crop Rotation (required entry)"]
[null,"Tips: \n(1) Enter information gathered in the R-SHEC Questionnaire Section I for the Study Area Current and Benchmark Rotation.                                                                                                                                                                             \n(2) In order to annualize the costs and benefits analyzed in this Tool, user must calculate acres of each crop in the rotation by dividing the total acres in the rotation by the number of years in rotation, then multiply by the number of years that a specific crop is in rotation: E.g., If the Study Area is 400 acres with a 4-year crop rotation (2-corn, 1-wheat, 1-soybeans), then user enters 200 acres for corn [(400/4) * 2], 100 acres in wheat, and 100 acres in soybeans [(400/4)*1].\n(3) Only enter a crop once per rotation, and adjust the number of years and acres appropriately. \n(4) If there is no change in the rotation, enter identical information for the Benchmark and Current Rotations.\n\nImportant note: If you have changed your crop rotation for soil health, the R-SHEC Tool is unable to analyze this conservation crop rotation (CCR) practice alongside other soil health practices. A change in CCR can only be analyzed alone with no other soil health practices included within the analysis. To learn more, see detailed information on the \"ONLY CCR\" tab."]
[null,"Benchmark Rotation"]
[null,"Crop","# Years","Acres"]
[]
[]
[]
[]
[null,"Total (Study Area)",{"$f":"SUM(C20:C23)","v":0},{"$f":"SUM(D20:D23)","v":0}]
[null,"Current Rotation"]
[null,"Crop","# Years","Acres"]
[]
[]
[]
[]
[null,"Total (Study Area)",{"$f":"SUM(C27:C30)","v":0},{"$f":"IF(SUM(D27:D30)<>D24,\"Total Acres must be the same as Benchmark Rotation\",SUM(D27:D30))","v":0}]
[]
[]
[null,"Study Area Soil Health Practices for Analysis"]
[null,"TIP:  Enter an \"x\" in all that apply."]
[null,"Soil Health Practice"]
[null,"No-Till or Reduced Tillage"]
[null,"Nutrient Management"]
[null,"Cover Crops"]
[null,"Note:  A change in crop rotation cannot be analyzed with other soil health practices due to data discrepancies."]
[]
[null,"Conservation Crop Rotation (CCR)"]
[]
[null,"Time Spent on Educational Activities"]
[null,"TIPS:\n(1) Do not enter hours for individual practices if using Combined Practice Learning Activities.\n(2) Use Combined Practice Learning Activities only when the farmer cannot separate hours spent by practice."]
[]
[]
[null,"Conservation Practice","Hours/Year","Total $/Yr*"]
[null,"Residue and Tillage Mgt. Learning Activities",null,{"$f":"IF(C$56>0,C$56*C49,C49*Prices!$C$61)","v":0}]
[null,"Cover Crops Learning Activities",null,{"$f":"IF(C$56>0,C$56*C50,C50*Prices!$C$61)","v":0}]
[null,"Nutrient Mgt. Learning Activities",null,{"$f":"IF(C$56>0,C$56*C51,C51*Prices!$C$61)","v":0}]
[null,"Conservation Crop Rotation Learning Activities",null,{"$f":"IF(C$56>0,C$56*C52,C52*Prices!$C$61)","v":0}]
[]
[null,"Combined Practices Learning Activities",null,{"$f":"IF(SUM(D49:D52)>0,\"See Tip 3\",IF(C$56>0,C$56*C54,C54*Prices!$C$61))","v":0}]
[null,null,"$/Hr"]
[null,"Farmer's Reported Labor Hourly Rate (Optional)"]
[null,"*Total $/Yr is calculated using Farmer's Hourly Rate (if provided) or default hourly labor rate (see \"Prices\" tab) multiplied by the number of learning activity hours by practice."]
[null,"Click here for default hourly labor rate & data source on Prices tab"]
[]
[]
[null,"Farmer's Fertilizer and Crop Values (optional)"]
[null,"TIP: If the farmer provided values, enter them here and they will be used throughout the workbook. If no values entered, national average prices will be used throughout the workbook (see \"Prices\" tab)."]
[null,"Fertilizer","Unit","$/Unit"]
[null,"Nitrogen","Lb"]
[null,"Phosphorus","Lb"]
[null,"Potassium","Lb"]
[null,"Crop Prices","Unit","$/Unit"]
[null,"Barley","Bu"]
[null,"Corn Grain","Bu"]
[null,"Corn Silage","Ton"]
[null,"Grain sorghum (milo)","Cwt"]
[null,"Hay","Ton"]
[null,"Oats","Bu"]
[null,"Soybeans","Bu"]
[null,"Wheat","Bu"]

{"sheet":"Tillage","index":2,"n_rows":244,"n_cols":6,"rows_kept":244,"cut":false,"hidden":false,"merged":[[21,2,21,3],[74,2,74,3],[126,1,126,5],[84,2,84,3],[53,2,53,3],[54,2,54,3],[63,2,63,3],[104,4,104,5],[104,2,104,3],[103,2,103,3],[103,4,103,5],[123,1,123,5],[110,1,118,6],[105,1,105,5],[223,5,224,5],[225,1,225,2],[187,1,187,5],[188,1,188,4],[229,1,232,6],[216,1,216,2],[239,1,239,4],[233,1,233,4],[210,1,210,2],[211,1,211,2],[189,1,189,4],[213,1,213,2],[142,1,142,5],[136,1,136,5],[220,1,221,5],[220,6,221,10],[139,1,139,4],[140,1,140,4],[141,1,141,5],[162,1,162,4],[163,1,163,4],[146,1,150,6],[168,1,173,6],[193,1,204,6],[164,1,164,5],[132,6,132,9],[10,1,10,6],[0,0,0,6],[3,0,7,6],[1,0,1,6],[9,1,9,4],[2,0,2,6],[96,4,96,5],[96,2,96,3],[96,6,97,13],[33,2,33,3],[32,2,32,3],[42,2,42,3],[75,2,75,3],[11,2,11,3],[12,2,12,3]]}
["Changes due to Changing Tillage"]
[]
["ABOUT THIS TAB:"]
["The Tillage tab calculates the increases and decreases in costs and returns (called economic effects) due to changes in type of tillage used.  Economic effects on this tab include changes in:  (1) machinery costs associated with crop establishment; (2) yield;  (3) fertilizer use; (4) pesticide use; (5) soil erosion; and (6) other benefits or costs as identified by the farmer. All effects on this tab are calculated on an annual per acre basis and for the entire Study Area.  If a particular effect cannot be attributed solely to a change in tillage, the user can enter it on the Combined Practice Effects tab."]
[]
[]
[]
[]
[]
[null,"Impact of Tillage Change on Establishment Cost due to Change in Tillage"]
[null,"TIPS:  \n(1) Benchmark Tillage refers to the field operation(s) used establishing the crop before reducing tillage. \n(2) Current Tillage refers to the current field operation(s) used with no-till or reduced tillage.\n(3) User must enter Crop (using dropdown options) to calculate changes in tillage machinery/implement costs.\n(4) User must enter Passes per Year.\n(5) If growing hay in rotation, the tool adjusts the acreage to account for the fact that hay production involves only one year of machinery costs to establish as a perennial crop.\n(6) Only enter benchmark and current machinery operations if there was a change due to adoption of reduced tillage practices. Make sure you are not double counting if additional soil health practices are being analyzed.\n(7) Review the list of machinery and associated costs on the \"Machinery Costs\" tab to determine the machinery that most closely matches your equipment. Alternatively, follow directions on the \"Machinery Costs\" tab to add your own costs."]
[null,"Crop 1:"]
[null,"Benchmark Tillage:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(IF($C$12=\"Hay\",VLOOKUP($C$12,'Farm Info'!$B$20:$D$23,3,0)/$C15,VLOOKUP($C$12,'Farm Info'!$B$20:$D$23,3,0)),0)","v":0}]
[null,"Benchmark Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C12,'Farm Info'!$C$20:$C$23)","v":0}]
[null," Crop 1 Benchmark Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B17,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D17*C17, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B18,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D18*C18, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B19,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B20,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E17:E20)","v":0}]
[null,"Current Tillage:"]
[null,"Current Acreage:",{"$f":"IFERROR(IF($C$12=\"Hay\",VLOOKUP($C$12,'Farm Info'!$B$27:$D$30,3,0)/$C24,VLOOKUP($C$12,'Farm Info'!$B$27:$D$30,3,0)),0)","v":0}]
[null,"Current Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C12,'Farm Info'!$C$27:$C$30)","v":0}]
[null," Crop 1 Current Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B26,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D26*C26, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B27,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D27*C27, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B28,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B29,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E26:E29)","v":0}]
[]
[]
[null,"Crop 2:"]
[null,"Benchmark Tillage:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(IF($C$33=\"Hay\",VLOOKUP($C$33,'Farm Info'!$B$20:$D$23,3,0)/$C36,VLOOKUP($C$33,'Farm Info'!$B$20:$D$23,3,0)),0)","v":0}]
[null,"Benchmark Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C33,'Farm Info'!$C$20:$C$23)","v":0}]
[null," Crop 2 Benchmark Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B38,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D38*C38, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B39,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D39*C39, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B40,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B41,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E38:E41)","v":0}]
[null,"Current Tillage:"]
[null,"Current Acreage:",{"$f":"IFERROR(IF($C$33=\"Hay\",VLOOKUP($C$33,'Farm Info'!$B$27:$D$30,3,0)/$C45,VLOOKUP($C$33,'Farm Info'!$B$27:$D$30,3,0)),0)","v":0}]
[null,"Current Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C33,'Farm Info'!$C$27:$C$30)","v":0}]
[null," Crop 2 Current Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B47,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D47*C47, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B48,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D48*C48, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B49,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B50,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E47:E50)","v":0}]
[]
[]
[null,"Crop 3:"]
[null,"Benchmark Tillage:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(IF($C$54=\"Hay\",VLOOKUP($C$54,'Farm Info'!$B$20:$D$23,3,0)/$C57,VLOOKUP($C$54,'Farm Info'!$B$20:$D$23,3,0)),0)","v":0}]
[null,"Benchmark Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C54,'Farm Info'!$C$20:$C$23)","v":0}]
[null," Crop 3 Benchmark Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B59,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D59*C59, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B60,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D60*C60, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B61,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B62,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E59:E62)","v":0}]
[null,"Current Tillage:"]
[null,"Current Acres:",{"$f":"IFERROR(IF($C$54=\"Hay\",VLOOKUP($C$54,'Farm Info'!$B$27:$D$30,3,0)/$C66,VLOOKUP($C$54,'Farm Info'!$B$27:$D$30,3,0)),0)","v":0}]
[null,"Current Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C54,'Farm Info'!$C$27:$C$30)","v":0}]
[null," Crop 3 Current Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B68,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D68*C68, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B69,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D69*C69, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B70,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B71,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E68:E71)","v":0}]
[]
[]
[null,"Crop 4:"]
[null,"Benchmark Tillage:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(IF($C$75=\"Hay\",VLOOKUP($C$75,'Farm Info'!$B$20:$D$23,3,0)/$C78,VLOOKUP($C$75,'Farm Info'!$B$20:$D$23,3,0)),0)","v":0}]
[null,"Benchmark Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C75,'Farm Info'!$C$20:$C$23)","v":0}]
[null," Crop 4 Benchmark Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B80,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D80*C80, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B81,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D81*C81, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B82,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B83,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E80:E83)","v":0}]
[null,"Current Tillage:"]
[null,"Current Acres:",{"$f":"IFERROR(IF($C$75=\"Hay\",VLOOKUP($C$75,'Farm Info'!$B$27:$D$30,3,0)/$C87,VLOOKUP($C$75,'Farm Info'!$B$27:$D$30,3,0)),0)","v":0}]
[null,"Current Years in Rotation",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C75,'Farm Info'!$C$27:$C$30)","v":0}]
[null," Crop 4 Current Tillage Machinery","Cost/Ac","# Passes/Yr","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B89,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D89*C89, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B90,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D90*C90, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B91,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,null,{"$f":"IFERROR(VLOOKUP(B92,'Machinery Costs'!B$21:F$118,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E89:E92)","v":0}]
[]
[]
[null,"Change in Machinery Cost due to Change in Tillage"]
[null,null,"Benchmark",null,"Current"]
[null,"Crop","Cost/Ac","Total Cost","Cost/Ac","Total Cost"]
[null,{"$f":"C12","v":0},{"$f":"E21","v":0},{"$f":"IFERROR(C99*C14,0)","v":0},{"$f":"E30","v":0},{"$f":"IFERROR(E99*C23,0)","v":0}]
[null,{"$f":"C33","v":0},{"$f":"E42","v":0},{"$f":"IFERROR(C100*C35,0)","v":0},{"$f":"E51","v":0},{"$f":"IFERROR(E100*C44,0)","v":0}]
[null,{"$f":"C54","v":0},{"$f":"E63","v":0},{"$f":"IFERROR(C101*C56,0)","v":0},{"$f":"E72","v":0},{"$f":"IFERROR(E101*C65,0)","v":0}]
[null,{"$f":"C75","v":0},{"$f":"E84","v":0},{"$f":"IFERROR(C102*C77,0)","v":0},{"$f":"E93","v":0},{"$f":"IFERROR(E102*C86,0)","v":0}]
[null,"Total",null,{"$f":"SUM(D99:D102)","v":0},null,{"$f":"SUM(F99:F102)","v":0}]
[null,null,"Per Acre Change in Cost ($/Ac)",null,"Total Change in Cost \n($)"]
[null,"Weighted Average Change in Cost \n(negative value means decrease in cost)",{"$f":"IFERROR(E105/(C23+C44+C65+C86),0)","v":0},null,{"$f":"F103-D103","v":0}]
[null,"Click here for machinery cost references"]
[]
[]
[null,"Yield Impacts due to Change in Tillage"]
[null,"Is this an organic farm? (Y/N)"]
[null,"TIPS:\n(1) We suggest only entering changes in yield below if Tillage is the only soil health practice analyzed, otherwise enter yield impacts in the Combined Practice Effects tab.\n(2) User must answer above question \"Is this an organic farm?\". The table will use the standard crop price as default otherwise.\n(3) User must enter their \"Benchmark Average Yield\" AND \"% Yield Increase/Decrease\" OR \"Change in Ave. Yield\". If user enters both of the latter, calculation will use % yield change value.\n(4) Benchmark average yield should reflect the average yield under benchmark practices before soil health practice adoption."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cash Crop",{"$f":"C12","v":0},{"$f":"C33","v":0},{"$f":"C54","v":0},{"$f":"C75","v":0}]
[null,"Unit",{"$f":"IFERROR(VLOOKUP(C121,Prices!$B69:$F76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D121,Prices!$B69:$F76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E121,Prices!$B69:$F76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F121,Prices!$B69:$F76,2,FALSE),0)","v":0}]
[null,"Benchmark Average Yield (Unit/Acre)"]
[null,"AND"]
[null,"% Yield Increase/Decrease Due To Changing Tillage (+/- %) "]
[null,"Calculated Change in Ave. Yield Due to Changing Tillage \n(+/- Unit/Ac)",{"$f":"C123*C125","v":0},{"$f":"D123*D125","v":0},0,0]
[null,"AND/OR"]
[null,"Change in Ave. Yield Due to Changing Tillage (+/- Unit/Ac)"]
[null,"HIDDEN: Calculated Current Ave. Yield Due to Changing Tillage (Unit/Ac) [used in \"Current Crop Value Per Acre\"]"]
[]
[null,"Standard Crop Price per Unit1",{"$f":"IFERROR(IF($C$110=\"Y\",VLOOKUP(C$121,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(C121,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$110=\"Y\",VLOOKUP(D$121,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(D121,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$110=\"Y\",VLOOKUP(E$121,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(E121,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$110=\"Y\",VLOOKUP(F$121,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(F121,Prices!$B$69:$F$76,5,FALSE)),0)","v":0}]
[null,"Farmer's Crop Price per Unit (Optional)",{"$f":"IFERROR(VLOOKUP(C121,'Farm Info'!$B$68:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D121,'Farm Info'!$B$68:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E121,'Farm Info'!$B$68:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F121,'Farm Info'!$B$68:$D$75,3,FALSE),0)","v":0}]
[null,"Benchmark Crop Acreage",{"$f":"IFERROR(IF(C123<>0,$C$14,0),0)","v":0},{"$f":"IFERROR(IF(D123<>0,$C$35,0),0)","v":0},{"$f":"IFERROR(IF(E123<>0,$C$56,0),0)","v":0},{"$f":"IFERROR(IF(F123<>0,$C$77,0),0)","v":0}]
[null,"Current Crop Acreage",{"$f":"IFERROR(IF(C123<>0,$C$23,0),0)","v":0},{"$f":"IFERROR(IF(D123<>0,$C$44,0),0)","v":0},{"$f":"IFERROR(IF(E123<>0,$C$65,0),0)","v":0},{"$f":"IFERROR(IF(F123<>0,$C$86,0),0)","v":0}]
[null,"Benchmark Crop Value Per Acre",{"$f":"IF(C123>0,(C123*IF(C132>0,C132,C131)),0)","v":0},{"$f":"IF(D123>0,(D123*IF(D132>0,D132,D131)),0)","v":0},0,0]
[null,"Current Crop Value Per Acre",{"$f":"IF(C129>0,(C129*IF(C132>0,C132,C131)),0)","v":0},{"$f":"IF(D129>0,(D129*IF(D132>0,D132,D131)),0)","v":0},0,0]
[]
[null,"Total Change by Crop ($)",{"$f":"(C134*C136)-(C133*C135)","v":0},{"$f":"(D134*D136)-(D133*D135)","v":0},{"$f":"(E134*E136)-(E133*E135)","v":0},{"$f":"(F134*F136)-(F133*F135)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"IF(C138<>0,C138/C134,0)","v":0},{"$f":"IF(D138<>0,D138/D134,0)","v":0},{"$f":"IF(E138<>0,E138/E134,0)","v":0},{"$f":"IF(F138<>0,F138/F134,0)","v":0}]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C138:F138)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F140/SUM(C134:F134),0)","v":0}]
[null,"1  National average non-organic or organic price."]
[null,"Click here for crop price data sources"]
[]
[]
[null,"Impact of Change in Tillage on Primary Nutrients Used"]
[null,"TIPS:\n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Only enter changes due to adoption of reduced tillage practices (e.g., reduced P and K rates by banding with strip-tillage). Make sure you are not double counting if additional soil health practices are being analyzed.\n(3) In this table, the change in nutrients applied will be applied to the Current Acres that the crop is in rotation."]
[]
[]
[]
[]
[null,"Cash Crop",{"$f":"C$12","v":0},{"$f":"C$33","v":0},{"$f":"C$54","v":0},{"$f":"C$75","v":0}]
[null,"Nitrogen (+/- Lbs/Ac)"]
[null,"Change in Nitrogen Cost/Ac",{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*C153,C153*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*D153,D153*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*E153,E153*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*F153,F153*Prices!$D$106)","v":0}]
[null,"Phosphorus (+/- Lbs/Ac)"]
[null,"Change in Phosphorus Cost/Ac",{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*C155,C155*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*D155,D155*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*E155,E155*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*F155,F155*Prices!$D$107)","v":0}]
[null,"Potassium  (+/- Lbs/Ac)"]
[null,"Change in Potassium Cost/Ac",{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*C157,C157*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*D157,D157*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*E157,E157*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*F157,F157*Prices!$D$108)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C154+C156+C158","v":0},{"$f":"D154+D156+D158","v":0},{"$f":"E154+E156+E158","v":0},{"$f":"F154+F156+F158","v":0}]
[null,"Acres by Crop",{"$f":"IF(C159<>0,$C$23,0)","v":0},{"$f":"IF(D159<>0,$C$44,0)","v":0},{"$f":"IF(E159<>0,$C$65,0)","v":0},{"$f":"IF(F159<>0,$C$86,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C159*C160","v":0},{"$f":"D159*D160","v":0},0,0]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C161:F161)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F163/SUM(C160:F160),0)","v":0}]
[null,"Click here for nutrient prices data sources"]
[]
[]
[null,"Impact of Change in Tillage on Pesticide Use"]
[null,"TIPS:\n(1) User must enter Cost/Ac and % Change for calculations to work.\n(2) Enter negative values for % change values to indicate savings and positive values to indicate an increase in cost.\n(3) Only enter changes due to change in NM activities for soil health. Make sure you are not double counting if additional soil health practices are being analyzed.\n(4) In this table, the change in pesticides applied will be applied to the Current Acres that the crop is in rotation."]
[]
[]
[]
[]
[]
[null,"Cash Crop",{"$f":"C$12","v":0},{"$f":"C$33","v":0},{"$f":"C$54","v":0},{"$f":"C$75","v":0}]
[null,"Herbicide Cost/Ac"]
[null,"Herbicide % Change (+/-)"]
[null,"Herbicide Change in Cost/Ac",{"$f":"C177*C176","v":0},{"$f":"D177*D176","v":0},{"$f":"E177*E176","v":0},{"$f":"F177*F176","v":0}]
[null,"Insecticide Cost/Ac"]
[null,"Insecticide % Change (+/-)"]
[null,"Insecticide Change in Cost/Ac",{"$f":"C180*C179","v":0},{"$f":"D180*D179","v":0},{"$f":"E180*E179","v":0},{"$f":"F180*F179","v":0}]
[null,"Fungicide Cost/Ac"]
[null,"Fungicide % Change (+/-)"]
[null,"Fungicide Change in Cost/Ac",{"$f":"C183*C182","v":0},{"$f":"D183*D182","v":0},{"$f":"E183*E182","v":0},{"$f":"F183*F182","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C184+C181+C178","v":0},{"$f":"D184+D181+D178","v":0},{"$f":"E184+E181+E178","v":0},{"$f":"F184+F181+F178","v":0}]
[null,"Acres by Crop",{"$f":"IF(C185<>0,$C$23,0)","v":0},{"$f":"IF(D185<>0,$C$44,0)","v":0},{"$f":"IF(E185<>0,$C$65,0)","v":0},{"$f":"IF(F185<>0,$C$86,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C185*C186","v":0},{"$f":"D185*D186","v":0},{"$f":"E185*E186","v":0},{"$f":"F185*F186","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C187:F187)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F189/SUM(C186:F186),0)","v":0}]
[]
[]
[null,"Value of Decreased Erosion due to Change in Tillage"]
[null,"TIPS: \n(1) We suggest only entering changes in benchmark versus current erosion and repair costs below if Tillage is the only soil health practice analyzed, otherwise enter erosion impacts in the Combined Practice Effects tab.\n(2) Number of Acres in the area where the reduction in erosion was observed. This could be the entire area where you’ve switched to no-till or reduced tillage in cases where slopes are relatively uniform throughout or, if the area is comprised of a combination of relatively flat areas and steeper ground, the acreage could be the portion encompassed by the steeper ground.  \n(3) Options for Tons Reduced Erosion:\n      a. Enter tons of reduced erosion results (Tons/Acre/Year) modeled using any sediment reduction tool, such as the Nutrient Tracking    \n          Tool;\n      b. Enter the erosion reduction value from RUSLE-2 analysis undertaken by your advisor; or\n      c. Any value that seems reasonable based on soil type including zero.\n(4) Total Annual Change in Repair Cost should only include changes in costs for repairs that occur within the Study Area due to adoption of no-till and/or reduced tillage.\n(5) Enter a negative value if cost of repairs has decreased and a positive value if cost of repairs increased."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Retained Nutrients Benefits","Amounts"]
[null,"Value of N and P per Ton of Soil",{"$f":"Prices!F98","v":2.2904}]
[null,"Number of Acres1"]
[null,"Tons Reduced Erosion (Tons/Acre/Year)"]
[null,"Total Value ($/Year)",{"$f":"C207*C209*C208","v":0}]
[]
[null,"Reduced Mechanical Erosion Repair"]
[null,"Total Annual Change in Repair Cost ($/Year)"]
[]
[null,"Value of Decreased Erosion for Study Area ($/Ac)",{"$f":"IFERROR(((-1*C213)+C210)/'Farm Info'!D31,0)","v":0}]
[null,"1 Do not exceed study area acres:",{"$f":"'Farm Info'!D31","v":0}]
[null,"Click here for value of N and P per Ton of Soil data sources"]
[]
[]
[null,"Annual Financial Assistance Payments"]
[null,"Note: Any financial assistance payments listed are not included in the partial budget analysis because cost-share is temporary and not received by all, but can be noted in the footnote of PBA table."]
[]
[null,"Source","$/Ac/Yr","Acres Funded","Total ($)","Weighted Average ($/Ac)"]
[null,null,null,null,{"$f":"D224*C224","v":0}]
[null,null,null,null,{"$f":"D225*C225","v":0}]
[null,"Total Received",null,{"$f":"SUM(D224:D225)","v":0},{"$f":"SUM(E224:E225)","v":0},{"$f":"IFERROR(E226/D226,0)","v":0}]
[]
[]
[null,"Other Tillage Benefits and Costs"]
[null,"TIPS:  \n(1) Description should detail the benefits, costs, or changes in activities experienced and responsible for change in Per Acre Value.\n(2) Per Acre Value should be positive for BOTH Positive Effects/Decreased Costs and Negative Effects/Increased Costs.\n(3) Acres should not exceed study area acreage. The default value is Study Area acreage."]
[]
[]
[]
[null,"Positive Effects/Decreased Costs  (enter positive Per Acre Values)"]
[null,"Description of Other Benefit(s)","$/Ac","Number of Acres Affected","Total   Benefit"]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D236*C236","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D237*C237","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D238*C238","v":0}]
[]
[null,"Negative Effects/Increased Costs (enter positive Per Acre Values)"]
[null,"Description of Other Cost(s)","$/Ac","Number of Acres Affected","Total         Cost"]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D242*C242","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D243*C243","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D244*C244","v":0}]

{"sheet":"Nutrient Mgt.","index":3,"n_rows":221,"n_cols":6,"rows_kept":221,"cut":false,"hidden":false,"merged":[[0,0,0,6],[2,0,2,6],[81,2,81,3],[3,0,7,6],[10,1,22,6],[89,2,89,3],[23,2,23,3],[24,2,24,3],[32,2,32,3],[43,2,43,3],[42,2,42,3],[61,2,61,3],[62,2,62,3],[70,2,70,3],[80,2,80,3],[51,2,51,3],[216,1,216,4],[108,4,108,5],[139,1,139,5],[142,1,142,4],[143,1,143,4],[210,1,210,4],[149,1,149,6],[165,1,165,5],[108,2,108,3],[202,1,202,2],[129,1,129,5],[172,1,177,6],[206,1,209,6],[145,1,145,5],[168,1,168,5],[100,2,100,3],[100,4,100,5],[200,5,201,5],[107,2,107,3],[107,4,107,5],[166,1,166,4],[167,1,167,4],[191,1,191,5],[192,1,192,4],[193,1,193,4],[197,1,198,5],[126,1,126,5],[109,1,109,5],[114,1,122,6]]}
["Changes in Nutrient Management (NM) Activities"]
[]
["ABOUT THIS TAB:"]
["The Nutrient Management (NM) tab calculates economic effects following a change in NM activities for soil health including changes in:  (1) machinery costs associated with fertilizer application; (2) yield;  (3) fertilizer use; (4) pesticide use; and (5) other benefits or costs as identified by the farmer. All effects on this tab are calculated on an annual per acre basis and for the entire Study Area.  If a particular effect cannot be attributed solely to a change in NM, the user can enter it on the Combined Practice Effects tab.\n\nNote: If growing hay in rotation, the tool assumes nutrient management activities occur annually. Otherwise, user must adjust the number of passes or acres accordingly."]
[]
[]
[]
[]
[]
[null,"Changes in Machinery Costs for Nutrient Management Activities"]
[null,"TIPS:  \n(1) Only enter benchmark and current machinery operations if there was a change in nutrient management activities for soil health. Make sure you are not double counting if additional soil health practices are being analyzed.\n(2) Review the list of machinery and associated costs (included in the dropdown) on the \"Machinery Costs\" tab to determine the machinery that most closely matches your equipment. Follow instructions on \"Machinery Costs\" tab to add your own machinery description and cost.\n(3) Benchmark NM Description should describe the field operation(s) used to apply nutrients prior to change in NM activities for soil health. Select Benchmark NM Machinery from the dropdown list that best matches the machinery used to apply nutrients prior to change. Assess the cost/ac.\n(4) Current NM Description should include description of the field operation(s) used to apply nutrients currently.  Select Current NM Machinery from the dropdown list that best matches the machinery used to apply nutrients currently. Assess the cost/ac.\n(5) User must enter Crop name (using dropdown options) to calculate changes in NM machinery/implement costs.\n(6) User must enter Passes, Gallons, Hours per Year.\n(7) User must adjust the number of passess accordingly if machinery costs do not apply to entire study area nor annually."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Crop 1:"]
[null,"Benchmark NM Description:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(VLOOKUP(C24,'Farm Info'!$B$20:$D$23,3,0),0)","v":0}]
[null,"Benchmark Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C$24,'Farm Info'!$C$20:$C$23)","v":0}]
[null,"Crop 1 Benchmark NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B29,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D29*C29, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B30,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D30*C30, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B31,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E29:E31)","v":0}]
[null,"Current NM Description:"]
[null,"Current Acres:",{"$f":"IFERROR(VLOOKUP(C24,'Farm Info'!$B$27:$D$30,3,0),0)","v":0}]
[null,"Current Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C$24,'Farm Info'!$C$27:$C$30)","v":0}]
[null,"Crop 1 Current NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B37,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D37*C37, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B38,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D38*C38, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B39,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E37:E39)","v":0}]
[]
[]
[null,"Crop 2:"]
[null,"Benchmark NM Description:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(VLOOKUP(C43,'Farm Info'!$B$20:$D$23,3,0),0)","v":0}]
[null,"Benchmark Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C43,'Farm Info'!$C$20:$C$23)","v":0}]
[null,"Crop 2 Benchmark NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B48,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D48*C48, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B49,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D49*C49, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B50,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E48:E50)","v":0}]
[null,"Current NM Description:"]
[null,"Current Acres:",{"$f":"IFERROR(VLOOKUP(C43,'Farm Info'!$B$27:$D$30,3,0),0)","v":0}]
[null,"Current Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C43,'Farm Info'!$C$27:$C$30)","v":0}]
[null,"Crop 2 Current NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B56,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D56*C56, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B57,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D57*C57, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B58,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E56:E58)","v":0}]
[]
[]
[null,"Crop 3:"]
[null,"Benchmark NM Description:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(VLOOKUP(C62,'Farm Info'!$B$20:$D$23,3,0),0)","v":0}]
[null,"Benchmark Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C62,'Farm Info'!$C$20:$C$23)","v":0}]
[null,"Crop 3 Benchmark NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B67,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D67*C67, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B68,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D68*C68, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B69,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E67:E69)","v":0}]
[null,"Current NM Description: "]
[null,"Current Acres:",{"$f":"IFERROR(VLOOKUP(C62,'Farm Info'!$B$27:$D$30,3,0),0)","v":0}]
[null,"Current Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C62,'Farm Info'!$C$27:$C$30)","v":0}]
[null,"Crop 3 Current NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B75,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D75*C75, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B76,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D76*C76, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B77,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E75:E77)","v":0}]
[]
[]
[null,"Crop 4:"]
[null,"Benchmark NM Description:"]
[null,"Benchmark Acres:",{"$f":"IFERROR(VLOOKUP(C81,'Farm Info'!$B$20:$D$23,3,0),0)","v":0}]
[null,"Benchmark Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$20:$B$23,$C81,'Farm Info'!$C$20:$C$23)","v":0}]
[null,"Crop 4 Benchmark NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B86,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D86*C86, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B87,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D87*C87, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B88,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E86:E88)","v":0}]
[null,"Current NM Description:"]
[null,"Current Acres:",{"$f":"IFERROR(VLOOKUP(C81,'Farm Info'!$B$27:$D$30,3,0),0)","v":0}]
[null,"Current Years in Rotation:",{"$f":"SUMIF('Farm Info'!$B$27:$B$30,$C81,'Farm Info'!$C$27:$C$30)","v":0}]
[null,"Crop 4 Current NM Machinery","Cost/Ac","Passes, Gallons, Hours per Year","Total Cost/Ac"]
[null,null,{"$f":"IFERROR(VLOOKUP(B94,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D94*C94, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B95,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,{"$f":"IFERROR(D95*C95, \"See 'Machinery Costs' tab\")","v":0}]
[null,null,{"$f":"IFERROR(VLOOKUP(B96,'Machinery Costs'!$B$121:$F$138,5,FALSE),0)","v":0},null,0]
[null,"Total",null,null,{"$f":"SUM(E94:E96)","v":0}]
[]
[]
[null,"Change in Machinery Costs due to Change in Nutrient Management Activities"]
[null,null,"Benchmark NM",null,"Current NM"]
[null,"Cash Crop","Per Acre","All Acres","Per Acre","All Acres"]
[null,{"$f":"C24","v":0},{"$f":"E32","v":0},{"$f":"IFERROR(C103*C26,0)","v":0},{"$f":"E40","v":0},{"$f":"IFERROR(E103*C34,0)","v":0}]
[null,{"$f":"C43","v":0},{"$f":"E51","v":0},{"$f":"IFERROR(E51*C45,)","v":0},{"$f":"E59","v":0},{"$f":"IFERROR(E104*C53,0)","v":0}]
[null,{"$f":"C62","v":0},{"$f":"E70","v":0},{"$f":"IFERROR(C105*C64,0)","v":0},{"$f":"E78","v":0},{"$f":"IFERROR(E105*C72,0)","v":0}]
[null,{"$f":"C81","v":0},{"$f":"E89","v":0},{"$f":"IFERROR(C106*C83,0)","v":0},{"$f":"E97","v":0},{"$f":"IFERROR(E106*C91,0)","v":0}]
[null,"Average per Acre or Total All Acres",null,{"$f":"SUM(D103:D106)","v":0},null,{"$f":"SUM(F103:F106)","v":0}]
[null,null,"Per Acre Change in Cost ($/Ac)",null,"Total Change in Cost \n($)"]
[null,"Weighted Average Change in Cost \n(negative value means decrease in cost)",{"$f":"IFERROR(E109/(C34+C53+C72+C91),0)","v":0},null,{"$f":"F107-D107","v":0}]
[null,"Click here for machinery cost data sources"]
[]
[]
[null,"Yield Impacts due to Change in Nutrient Management Activities"]
[null,"Is this an organic farm? (Y/N)"]
[null,"TIPS:\n(1) We suggest only entering changes in yield below if NM is the only soil health practice analyzed, otherwise enter yield impacts in the Combined Practice Effects tab.\n(2) User must answer above question \"Is this an organic farm?\". The table will use the standard crop price as default otherwise.\n(3) User must enter their \"Benchmark Average Yield\" AND \"% Yield Increase/Decrease\" OR \"Change in Ave. Yield\". If user enters both of the latter, calculation will use % yield change value.\n(4) Benchmark average yield should reflect the average yield under benchmark practices before soil health practice adoption."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cash Crop",{"$f":"C24","v":0},{"$f":"C43","v":0},{"$f":"C62","v":0},{"$f":"C81","v":0}]
[null,"Unit",{"$f":"IFERROR(VLOOKUP(C124,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D124,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E124,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F124,Prices!$B$69:$F$76,2,FALSE),0)","v":0}]
[null,"Benchmark Average Yield (Unit/Acre)"]
[null,"AND"]
[null,"% Yield Increase/Decrease Due To Changing NM (+/- %) "]
[null,"Calculated Change in Ave. Yield Due to Changing NM (+/- Unit/Ac)",{"$f":"C126*C128","v":0},{"$f":"D126*D128","v":0},0,0]
[null,"AND/OR"]
[null,"Change in Ave. Yield Due to Changing NM (+/- Unit/Ac)"]
[null,"HIDDEN: Calculated Current Ave. Yield Due to Changing NM (Unit/Ac) [used in \"Current Crop Value Per Acre\"]",{"$f":"IF(C129<>0,C126+C129,C126+C131)","v":0},{"$f":"IF(D129<>0,D126+D129,D126+D131)","v":0},{"$f":"IF(E129<>0,E126+E129,E126+E131)","v":0},{"$f":"IF(F129<>0,F126+F129,F126+F131)","v":0}]
[]
[null,"Standard Crop Price per Unit1",{"$f":"IFERROR(IF($C$114=\"Y\",VLOOKUP(C124,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(C124,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$114=\"Y\",VLOOKUP(D124,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(D124,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$114=\"Y\",VLOOKUP(E124,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(E124,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$114=\"Y\",VLOOKUP(F124,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(F124,Prices!$B$69:$F$76,5,FALSE)),0)","v":0}]
[null,"Farmer's Crop Price per Unit (Optional)",{"$f":"IFERROR(VLOOKUP(C124,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D124,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E124,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F124,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0}]
[null,"Benchmark Crop Acreage",{"$f":"IFERROR(IF(C124<>0,$C$26,0),0)","v":0},{"$f":"IFERROR(IF(D124<>0,$C$45,0),0)","v":0},{"$f":"IFERROR(IF(E124<>0,$C$64,0),0)","v":0},{"$f":"IFERROR(IF(F124<>0,$C$83,0),0)","v":0}]
[null,"Current Crop Acreage",{"$f":"IFERROR(IF(C124<>0,$C$34,0),0)","v":0},{"$f":"IFERROR(IF(D124<>0,$C$53,0),0)","v":0},{"$f":"IFERROR(IF(E124<>0,$C$72,0),0)","v":0},{"$f":"IFERROR(IF(F124<>0,$C$91,0),0)","v":0}]
[null,"Benchmark Crop Value Per Acre",{"$f":"IF(C126>0,(C126*IF(C135>0,C135,C134)),0)","v":0},{"$f":"IF(D126>0,(D126*IF(D135>0,D135,D134)),0)","v":0},{"$f":"IF(E126>0,(E126*IF(E135>0,E135,E134)),0)","v":0},{"$f":"IF(F126>0,(F126*IF(F135>0,F135,F134)),0)","v":0}]
[null,"Current Crop Value Per Acre",{"$f":"IF(C132>0,(C132*IF(C135>0,C135,C134)),0)","v":0},{"$f":"IF(D132>0,(D132*IF(D135>0,D135,D134)),0)","v":0},{"$f":"IF(E132>0,(E132*IF(E135>0,E135,E134)),0)","v":0},{"$f":"IF(F132>0,(F132*IF(F135>0,F135,F134)),0)","v":0}]
[]
[null,"Total Change by Crop ($)",{"$f":"(C137*C139)-(C136*C138)","v":0},{"$f":"(D137*D139)-(D136*D138)","v":0},0,0]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"IF(C141<>0,C141/C137,0)","v":0},{"$f":"IF(D141<>0,D141/D137,0)","v":0},{"$f":"IF(E141<>0,E141/E137,0)","v":0},0]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C141:F141)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F143/SUM(C137:F137),0)","v":0}]
[null,"1  National average non-organic or organic price."]
[null,"Click here for crop price data sources"]
[]
[]
[null,"Impact of Change in Nutrient Management Activities on Primary Nutrients Used"]
[null,"TIPS:  \n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Change in Manure/Compost Cost/Ac should only be used when material is purchased off the farm. If so, user must enter their Price of \n      Purchased Manure/Compost ($/Ton) below.\n(3) Only enter changes due to change in NM activities for soil health. Make sure you are not double counting if \n      additional soil health practices are being analyzed.\n(4) In this table, the change in nutrients applied will be applied to the Current Acres that the crop is in rotation."]
[]
[null,"Price of Purchased Manure/Compost ($/Ton)"]
[]
[null,"Cash Crop",{"$f":"'Farm Info'!$B$27","v":0},{"$f":"'Farm Info'!$B$28","v":0},{"$f":"'Farm Info'!$B$29","v":0},{"$f":"'Farm Info'!$B$30","v":0}]
[null,"Nitrogen (+/- Lbs/Ac)"]
[null,"Change in Nitrogen Cost/Ac",{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*C155,C155*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*D155,D155*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*E155,E155*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*F155,F155*Prices!$D$106)","v":0}]
[null,"Phosphorus (+/- Lbs/Ac)"]
[null,"Change in Phosphorus Cost/Ac",{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*C157,C157*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*D157,D157*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*E157,E157*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*F157,F157*Prices!$D$107)","v":0}]
[null,"Potassium  (+/- Lbs/Ac)"]
[null,"Change in Potassium Cost/Ac",{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*C159,C159*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*D159,D159*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*E159,E159*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*F159,F159*Prices!$D$108)","v":0}]
[null,"Manure/Compost (+/- Tons/Ac)"]
[null,"Change in Manure/Compost Cost/Ac",{"$f":"$C$152*C161","v":0},{"$f":"$C$152*D161","v":0},0,0]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C156+C158+C160+C162","v":0},{"$f":"D156+D158+D160+D162","v":0},{"$f":"E156+E158+E160+E162","v":0},{"$f":"F156+F158+F160+F162","v":0}]
[null,"Acres by Crop",{"$f":"IF(OR(C155<>0,C157<>0,C159<>0,C161<>0),C34,0)","v":0},{"$f":"IF(OR(D155<>0,D157<>0,D159<>0,D161<>0),C53,0)","v":0},{"$f":"IF(OR(E155<>0,E157<>0,E159<>0,E161<>0),C72,0)","v":0},{"$f":"IF(OR(F155<>0,F157<>0,F159<>0,F161<>0),C91,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C164*C163","v":0},{"$f":"D164*D163","v":0},0,0]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C165:F165)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F167/SUM(C164:F164),0)","v":0}]
[null,"Click here for nutrient prices data sources"]
[]
[]
[null,"Impact of Change in Nutrient Management Activities on Pesticide Use"]
[null,"TIPS:\n(1) User must enter Cost/Ac and % Change for calculations to work.\n(2) Enter negative values for % change values to indicate savings and positive values to indicate an increase in cost.\n(3) Only enter changes due to change in NM activities for soil health. Make sure you are not double counting if additional soil health practices are being analyzed.\n(4) In this table, the change in pesticides applied will be applied to the Current Acres that the crop is in rotation."]
[]
[]
[]
[]
[]
[null,"Cash Crop",{"$f":"'Farm Info'!$B$27","v":0},{"$f":"'Farm Info'!$B$28","v":0},{"$f":"'Farm Info'!$B$29","v":0},{"$f":"'Farm Info'!$B$30","v":0}]
[null,"Herbicide Cost/Ac"]
[null,"Herbicide % Change (+/-)"]
[null,"Herbicide Change in Cost/Ac",{"$f":"C181*C180","v":0},{"$f":"D181*D180","v":0},{"$f":"E181*E180","v":0},{"$f":"F181*F180","v":0}]
[null,"Insecticide Cost/Ac"]
[null,"Insecticide % Change (+/-)"]
[null,"Insecticide Change in Cost/Ac",{"$f":"C184*C183","v":0},{"$f":"D184*D183","v":0},{"$f":"E184*E183","v":0},{"$f":"F184*F183","v":0}]
[null,"Fungicide Cost/Ac"]
[null,"Fungicide % Change (+/-)"]
[null,"Fungicide Change in Cost/Ac",{"$f":"C187*C186","v":0},{"$f":"D187*D186","v":0},{"$f":"E187*E186","v":0},{"$f":"F187*F186","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C188+C185+C182","v":0},{"$f":"D188+D185+D182","v":0},{"$f":"E188+E185+E182","v":0},{"$f":"F188+F185+F182","v":0}]
[null,"Acres by Crop",{"$f":"IF(OR(C182<>0,C185<C163>0,C188<>0),C34,0)","v":0},{"$f":"IF(OR(D182<>0,D185<>0,D188<>0),C53,0)","v":0},{"$f":"IF(OR(E182<>0,E185<>0,E188<>0),C72,0)","v":0},{"$f":"IF(OR(F182<>0,F185<>0,F188<>0),C91,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C190*C189","v":0},{"$f":"D190*D189","v":0},{"$f":"E190*E189","v":0},{"$f":"F190*F189","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C191:F191)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F193/SUM(C190:F190),0)","v":0}]
[]
[]
[null,"Annual Financial Assistance Payments"]
[null,"Note: Any financial assistance payments listed are not included in the partial budget analysis because cost-share is temporary and not received by all, but can be noted in the footnote of PBA table."]
[]
[null,"Source","$/Ac/Yr","Acres Funded","Total ($)","Weighted Average ($/Ac)"]
[null,null,null,null,{"$f":"D201*C201","v":0}]
[null,null,null,null,{"$f":"D202*C202","v":0}]
[null,"Total Received",null,{"$f":"SUM(D201:D202)","v":0},{"$f":"SUM(E201:E202)","v":0},{"$f":"IFERROR(E203/D203,0)","v":0}]
[]
[]
[null,"Other Benefits and Costs due to Change in Nutrient Management Activities"]
[null,"TIPS:  \n(1) Description should detail the benefits, costs, or changes in activities experienced and responsible for change in Per Acre Value.\n(2) Per Acre Value should be positive for BOTH Positive Effects/Decreased Costs and Negative Effects/Increased Costs.\n(3) Acres should not exceed study area acreage. The default value is Study Area acreage."]
[]
[]
[]
[null,"Positive Effects/Decreased Costs  (enter positive values)"]
[null,"Description of Other Benefit(s)","$/Ac","Number of Acres Affected","Total Benefit"]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D213*C213","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},0]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},0]
[]
[null,"Negative Effects/Increased Costs (enter positive values)"]
[null,"Description of Other Cost(s)","$/Ac","Number of Acres Affected","Total Cost"]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D219*C219","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},{"$f":"D220*C220","v":0}]
[null,null,null,{"$f":"'Farm Info'!$D$31","v":0},0]

{"sheet":"Cover Crops","index":4,"n_rows":186,"n_cols":8,"rows_kept":186,"cut":false,"hidden":false,"merged":[[0,0,0,6],[51,1,51,4],[52,1,52,4],[58,1,58,5],[25,1,25,5],[3,0,10,6],[13,1,14,5],[54,1,54,5],[35,1,35,5],[38,1,38,5],[48,1,48,5],[27,1,27,4],[26,1,26,4],[31,1,31,6],[158,4,158,6],[2,0,2,6],[135,1,135,2],[126,1,126,2],[123,1,123,2],[130,1,131,5],[69,1,69,5],[70,1,70,4],[71,1,71,4],[72,1,72,5],[76,1,82,5],[102,1,114,6],[96,1,96,5],[185,1,185,7],[156,4,156,6],[160,4,160,6],[157,4,157,6],[162,4,162,6],[173,4,173,6],[172,4,172,6],[166,4,166,6],[168,4,168,6],[169,4,169,6],[170,4,170,6],[171,4,171,6],[161,4,161,6],[163,4,163,6],[167,4,167,6],[159,4,159,6],[97,1,97,4],[98,1,98,4],[140,1,140,4],[146,1,146,4],[139,1,139,6],[120,1,120,2],[121,1,121,2],[133,5,134,5]]}
["Changes due to Adopting Cover Crops"]
[]
["ABOUT THIS TAB:"]
["The Cover Crop tab calculates the economic effects attributed to adopting cover crops. Economic effects on this tab include (1) cover crop costs and changes in (2) cash crop yield, (3) fertilizer applied, (4) pesticides used, (5) soil erosion, and (6) other benefits or costs as identified by the farmer. Also, at the end of this tab, user can calculate the effects of grazing and/or harvesting their cover crop as hay (7).  All effects on this tab are calculated on an annual per acre basis for the Study Area.  If a particular effect cannot be attributed solely to introducing cover crops, the user can enter it on the Combined Practice Effects tab.\n\nNote: This tab is setup to only analyze the switch from no cover crop to planting a cover crop. This tab does not analyze switching of cover crop species, changes in establishment methods, nor changes in termination methods, etc."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Cover Crop Costs"]
[null,"TIPS:\n(1)For data entry:\n     Cover Species or Mix Description: Describe species planted.\n     Acres Planted: Enter the average acreage planted to cover (e.g., if farmer only plants every other row in certain cover \n     crop, enter half the crop acreage).\n     Cover Crop Seed Cost:  Enter per acre cost of cover crop seed.\n     Establishment Cost:  Include costs such as seedbed preparation (e.g., disking) and planting costs on average.\n     Termination Cost:  Enter average termination cost if the cover crop does not winter-kill.  E.g., disking, spraying \n     (equipment and herbicide), or tilling.\n     Other Costs:  Any other costs associated with growing cover crops.\n(2) Hay is a multi-year crop, therefore the cost of cover before hay will be divided by the number of years of hay in the \n      rotation. We are assuming the farmer will not plant a cover every year during hay production. If they do, they can \n      adjust the formulas in the hay column below appropriately.\n      (E.g.: If farmer grows 300 acres of hay in a 3-year rotation and plants a cover crop before Year 1 of hay, \n      Acres Planted would be 300 and the Tool will divide cover crop costs by 3 to determine the annual Total \n      Cost/Ac)."]
[]
[null,"Cash Crop Following Cover"]
[null,"Years in Rotation",{"$f":"IFERROR(VLOOKUP(C16,'Farm Info'!$B$27:$C$30,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D16,'Farm Info'!$B$27:$C$30,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E16,'Farm Info'!$B$27:$C$30,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F16,'Farm Info'!$B$27:$C$30,2,FALSE),0)","v":0}]
[null,"Cover Species or Mix Description"]
[null,"Acres Planted"]
[null,"Cover Crop Seed ($/Ac)"]
[null,"Establishment Cost ($/Ac)"]
[null,"Termination Cost ($/Ac)"]
[null,"Other Costs ($/Ac)"]
[null,"Per Acre Cost by Crop ($/Ac)",{"$f":"IFERROR(IF(C16=\"Hay\", (C20+C21+C22+C23)/C17,C20+C21+C22+C23),0)","v":0},{"$f":"IFERROR(IF(D16=\"Hay\", (D20+D21+D22+D23)/D17,D20+D21+D22+D23),0)","v":0},{"$f":"IFERROR(IF(E16=\"Hay\", (E20+E21+E22+E23)/E17,E20+E21+E22+E23),0)","v":0},{"$f":"IFERROR(IF(F16=\"Hay\", (F20+F21+F22+F23)/F17,F20+F21+F22+F23),0)","v":0}]
[null,"Total Cost by Crop ($)",{"$f":"C19*C24","v":0},{"$f":"D19*D24","v":0},{"$f":"E19*E24","v":0},{"$f":"F19*F24","v":0}]
[]
[null,"Study Area Total Cost ($)",null,null,null,{"$f":"IFERROR(SUM(C25:F25),0)","v":0}]
[null,"Study Area Per Acre Cost (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F27/SUM(C19:F19),0)","v":0}]
[]
[null,"Yield Impacts due to Cover Crops"]
[null,"Is this an organic farm? (Y/N)"]
[null,"TIPS:\n(1) We suggest only entering changes in yield below if Cover Cropping is the only soil health practice analyzed, otherwise enter yield impacts in the Combined Practice Effects tab.\n(2) User must answer above question \"Is this an organic farm?\" or the table will not calculate correctly.\n(3) User must enter their \"Benchmark Average Yield\" AND \"% Yield Increase/Decrease\" OR \"Change in Ave. Yield\". If user enters both of the latter, calculation will use % yield change value.\n(4) Benchmark average yield should reflect the average yield under benchmark practices before soil health practice adoption."]
[null,"Cash Crop Following Cover",{"$f":"C16","v":0},{"$f":"D16","v":0},{"$f":"E16","v":0},{"$f":"F16","v":0}]
[null,"Unit",{"$f":"IFERROR(VLOOKUP(C33,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D33,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E33,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F33,Prices!$B$69:$F$76,2,FALSE),0)","v":0}]
[null,"Benchmark Average Yield (Unit/Acre)"]
[null,"AND"]
[null,"% Yield Increase/Decrease Due To Cover Crop (+/- %) "]
[null,"Calculated Change in Ave. Yield Due to Cover Crop \n(+/- Unit/Ac)",{"$f":"C35*C37","v":0},{"$f":"D35*D37","v":0},0,0]
[null,"AND/OR"]
[null,"Change in Ave. Yield Due to Cover Crop (+/- Unit/Ac)"]
[null,"HIDDEN: Calculated Current Ave. Yield Due to Cover Crops (Unit/Ac) [used in \"Current Crop Value Per Acre\"]",{"$f":"IF(C38<>0,C35+C38,C35+C40)","v":0},{"$f":"IF(D38<>0,D35+D38,D35+D40)","v":0},{"$f":"IF(E38<>0,E35+E38,E35+E40)","v":0},0]
[]
[null,"Standard Crop Price per Unit1",{"$f":"IFERROR(IF($C$31=\"Y\",VLOOKUP(C33,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(C33,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$31=\"Y\",VLOOKUP(D33,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(D33,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$31=\"Y\",VLOOKUP(E33,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(E33,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$31=\"Y\",VLOOKUP(F33,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(F33,Prices!$B$69:$F$76,5,FALSE)),0)","v":0}]
[null,"Farmer's Crop Price per Unit (Optional)",{"$f":"IFERROR(VLOOKUP(C33,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D33,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E33,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F33,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0}]
[null,"Benchmark Crop Acreage",{"$f":"IFERROR(IF(C33<>0,VLOOKUP(C33,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D33<>0,VLOOKUP(D33,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E33<>0,VLOOKUP(E33,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F33<>0,VLOOKUP(F33,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0}]
[null,"Current Crop Acreage",{"$f":"IFERROR(IF(C33<>0, VLOOKUP(C33,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D33<>0, VLOOKUP(D33,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E33<>0, VLOOKUP(E33,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F33<>0, VLOOKUP(F33,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0}]
[null,"Benchmark Crop Value Per Acre",{"$f":"IF(C35>0,(C35*IF(C44>0,C44,C43)),0)","v":0},{"$f":"IF(D35>0,(D35*IF(D44>0,D44,D43)),0)","v":0},{"$f":"IF(E35>0,(E35*IF(E44>0,E44,E43)),0)","v":0},0]
[null,"Current Crop Value Per Acre",{"$f":"IF(C41>0,(C41*IF(C44>0,C44,C43)),0)","v":0},{"$f":"IF(D41>0,(D41*IF(D44>0,D44,D43)),0)","v":0},0,0]
[]
[null,"Total Change by Crop ($)",{"$f":"(C46*C48)-(C45*C47)","v":0},{"$f":"(D46*D48)-(D45*D47)","v":0},{"$f":"(E46*E48)-(E45*E47)","v":0},{"$f":"(F46*F48)-(F45*F47)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"IF(C50<>0,C50/C46,0)","v":0},{"$f":"IF(D50<>0,D50/D46,0)","v":0},{"$f":"IF(E50<>0,E50/E46,0)","v":0},{"$f":"IF(F50<>0,F50/F46,0)","v":0}]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C50:F50)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F52/SUM(C46:F46),0)","v":0}]
[null,"1  National average non-organic or organic price."]
[null,"Click here for crop price data sources"]
[]
[]
[null,"Impact of Cover Crops on Primary Nutrients Used"]
[null,"TIPS:  \n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Only enter changes in primary nutrients due to adoption of cover crops. Make sure you are not double counting if \n      additional soil health practices are being analyzed."]
[null,"Cash Crop Following Cover",{"$f":"C16","v":0},{"$f":"D16","v":0},{"$f":"E16","v":0},{"$f":"F16","v":0}]
[null,"Nitrogen (+/- Lbs/Ac)"]
[null,"Change in Nitrogen Cost/Ac",{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*C61,C61*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*D61,D61*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*E61,E61*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*F61,F61*Prices!$D$106)","v":0}]
[null,"Phosphorus (+/- Lbs/Ac)"]
[null,"Change in Phosphorus Cost/Ac",{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*C63,C63*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*D63,D63*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*E63,E63*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*F63,F63*Prices!$D$107)","v":0}]
[null,"Potassium  (+/- Lbs/Ac)"]
[null,"Change in Potassium Cost/Ac",{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*C65,C65*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*D65,D65*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*E65,E65*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*F65,F65*Prices!$D$108)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C62+C64+C66","v":0},{"$f":"D62+D64+D66","v":0},{"$f":"E62+E64+E66","v":0},{"$f":"F62+F64+F66","v":0}]
[null,"Acres",{"$f":"IF(OR(C61<>0,C63<>0,C65<>0),VLOOKUP(C60,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(D61<>0,D63<>0,D65<>0),VLOOKUP(D60,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(E61<>0,E63<>0,E65<>0),VLOOKUP(E60,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(F61<>0,F63<>0,F65<>0),VLOOKUP(F60,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"IFERROR(C67*C68,0)","v":0},{"$f":"IFERROR(D67*D68,0)","v":0},{"$f":"IFERROR(E67*E68,0)","v":0},{"$f":"IFERROR(F67*F68,0)","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C69:F69),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F71/SUM(C68:F68), 0)","v":0}]
[null,"Click here for nutrient prices data sources"]
[]
[]
[null,"Impact of Cover Crops on Pesticide Use"]
[null,"TIPS:  \n(1) Use must enter Cost/Ac and % Change for calculations to work.\n(2) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(3) If cover crop termination cost is included in the Cover Crop Costs table at the top of this sheet, do not enter increased \n      herbicide cost in this table.\n(4) Only enter changes in pesticide costs due to adoption of cover crops. Make sure you are not double counting if \n      additional soil health practices are being analyzed."]
[]
[]
[]
[]
[]
[]
[null,"Cash Crop following Cover",{"$f":"C16","v":0},{"$f":"D16","v":0},{"$f":"E16","v":0},{"$f":"F16","v":0}]
[null,"Herbicide Cost/Ac"]
[null,"Herbicide % Change (+/-)"]
[null,"Herbicide Change in Cost/Ac",{"$f":"C86*C85","v":0},{"$f":"D86*D85","v":0},{"$f":"E86*E85","v":0},{"$f":"F86*F85","v":0}]
[null,"Insecticide Cost/Ac"]
[null,"Insecticide % Change (+/-)"]
[null,"Insecticide Change in Cost/Ac",{"$f":"C89*C88","v":0},{"$f":"D89*D88","v":0},{"$f":"E89*E88","v":0},{"$f":"F89*F88","v":0}]
[null,"Fungicide Cost/Ac"]
[null,"Fungicide % Change (+/-)"]
[null,"Fungicide Change in Cost/Ac",{"$f":"C92*C91","v":0},{"$f":"D92*D91","v":0},{"$f":"E92*E91","v":0},{"$f":"F92*F91","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C$93+C$90+C$87","v":0},{"$f":"D$93+D$90+D$87","v":0},0,0]
[null,"Acres",{"$f":"IF(OR(C87<>0,C90<>0,C93<>0),VLOOKUP(C84,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(D87<>0,D90<>0,D93<>0),VLOOKUP(D84,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(E87<>0,E90<>0,E93<>0),VLOOKUP(E84,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(F87<>0,F90<>0,F93<>0),VLOOKUP(F84,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"IFERROR(C94*C95,0)","v":0},{"$f":"IFERROR(D94*D95,0)","v":0},{"$f":"IFERROR(E94*E95,0)","v":0},{"$f":"IFERROR(F94*F95,0)","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C96:F96),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F98/SUM(C95:F95), 0)","v":0}]
[]
[]
[null,"Value of Decreased Erosion due to Cover Crops"]
[null,"TIPS: \n(1) We suggest only entering changes in erosion and repair costs here if Cover Cropping is the only soil health practice analyzed, otherwise enter erosion impacts in the Combined Practice Effects tab.\n(2) Number of Acres is the area where the reduction in erosion was observed. This could be the entire area where you're using a Cover Crop in cases where slopes are relatively uniform throughout or, if the area is comprised of a combination of relatively flat areas and steeper ground, the acreage could be the portion encompassed by the steeper ground.  \n(3) Options for Tons Reduced Erosion:\n      a. Enter tons of reduced erosion results (Tons/Acre/Year) modeled using any sediment reduction tool, such as the Nutrient Tracking  \n          Tool;\n      b. Enter the erosion reduction value from RUSLE-2 analysis undertaken by your advisor; or\n      c. Any value that seems reasonable based on soil including zero.\n(4) Total Annual Change in Repair Cost should only include changes in costs for repairs that occur within the Study Area.\n(5) Enter a negative value if cost of repairs has decreased and a positive value if cost of repairs increased."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Retained Nutrients Benefits","Amounts"]
[null,"Value of N and P per Ton of Soil",{"$f":"Prices!F98","v":2.2904}]
[null,"Number of Acres1"]
[null,"Tons Reduced Erosion (Tons/Acre/Year)"]
[null,"Total Value ($/Year)",{"$f":"C117*C119*C118","v":0}]
[null,"AND/OR"]
[null,"Reduced Mechanical Erosion Repair due to Cover Crops"]
[null,"Total Annual Change in Repair Cost (+/- $/Year)"]
[]
[null,"Value of Decreased Erosion for Study Area ($/Ac)",{"$f":"IFERROR(((-1*C123+C120))/'Farm Info'!D31,0)","v":0}]
[null,"1 Do not exceed Study Area acreage:",{"$f":"'Farm Info'!D31","v":0}]
[null,"Click here for value of N and P per Ton of Soil data sources"]
[]
[]
[null,"Annual Financial Assistance Payments"]
[null,"Note: Any financial assistance payments listed are not included in the partial budget analysis because cost-share is temporary and not received by all, but can be noted in the footnote of PBA table."]
[]
[null,"Source","$/Ac/Yr","Acres Funded","Total ($)","Weighted Average \n($/Ac)"]
[null,null,null,null,{"$f":"D134*C134","v":0}]
[null,null,null,null,{"$f":"D135*C135","v":0}]
[null,"Total Received",null,{"$f":"SUM(D134:D135)","v":0},{"$f":"SUM(E134:E135)","v":0},{"$f":"IFERROR(E136/D136,0)","v":0}]
[]
[]
[null,"Other Cover Crop Benefits and Costs"]
[null,"TIPS:  \n(1) Description should detail the benefits, costs, or changes in activities experienced and responsible for change in Per Acre Value.\n(2) Per Acre Value should be positive for BOTH Positive Effects/Decreased Costs and Negative Effects/Increased Costs."]
[null,"Positive Effects/Decreased Costs  (enter positive Per Acre Values)"]
[null,"Description","$/Ac","Number of Acres Affected","Total Benefit"]
[null,null,null,null,{"$f":"D143*C143","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,"Negative Effects/Increased Costs (enter positive Per Acre Values)"]
[null,"Description","$/Ac","Number of Acres Affected","Total Cost"]
[null,null,null,null,{"$f":"D149*C149","v":0}]
[null,null,null,null,{"$f":"D150*C150","v":0}]
[null,null,null,null,0]
[]
[]
[null,"Grazing and Haying Cover Crops"]
[null,"Hay Price ($/Ton)",{"$f":"Prices!F73","v":186},{"$f":"IFERROR(IF($C$31=\"Y\",VLOOKUP(\"Hay\",Prices!$B$83:$G$90,6,FALSE),VLOOKUP(C33,Prices!$B$69:$F$76,5,FALSE)),0)","v":0}]
[]
[null,"Grazing Cover Infrastructure and Annual Costs",null,null,"Grazing Cover, Dairy"]
[null,"Planning Horizon (Years)",null,null,"Number of Acres Grazed"]
[null,"Interest Rate",null,null,"Number of Days Grazed"]
[null,"Fence ($/Ac)",null,null,"Stocking Rate (AU/Ac)"]
[null,"Watering Facilities ($/Ac)",null,null,"Forage Demand (LB/AU/Day)"]
[null,"Total Infrastructure Cost ($/Ac)",{"$f":"SUM(C160:C161)","v":0},null,"Total Grazing Benefit ($/Ac)",null,null,{"$f":"((H159*H160*H161)/2000)*$C$155","v":0}]
[null,"Annualized Cost ($/Ac)",{"$f":"IFERROR(PMT(C159,C158,C162)*-1,0)","v":0},null,"Net Grazing Benefit $/Ac)",null,null,{"$f":"H162-C166","v":0}]
[null,"Additional Labor and Management ($/Ac)",null,null,"Net Grazing Benefit all Acres Grazed ($/Yr)",null,null,{"$f":"H163*H158","v":0}]
[null,"Other Annual Grazing Cost ($/Ac)"]
[null,"Total Annual Grazing Cost ($/Ac)",{"$f":"SUM(C163:C165)","v":0}]
[null,null,null,null,"Grazing Cover, Stockers"]
[null,null,null,null,"Number of Acres Grazed"]
[null,"Grazing Cover, Cow/Calf Pair",null,null,"Number of Days Grazed"]
[null,"Number of Acres Grazed",null,null,"Stocking Rate (AU/Ac)"]
[null,"Number of Days Grazed",null,null,"Forage Demand (LB/AU/Day)"]
[null,"Stocking Rate (AU/Ac)",null,null,"Total Grazing Benefit ($/Ac)",null,null,{"$f":"((H169*H170*H171)/2000)*$C$155","v":0}]
[null,"Forage Demand (Lb/AU/Day)",null,null,"Net Grazing Benefit ($/Ac)",null,null,{"$f":"H172-C166","v":0}]
[null,"Total Grazing Benefit ($/Ac)",{"$f":"((C171*C172*C173)/2000)*$C$155","v":0},null,"Net Grazing Benefit all Acres Grazed ($/Yr)",null,null,{"$f":"H173*H168","v":0}]
[null,"Net Grazing Benefit ($/Ac)",{"$f":"C174-C166","v":0}]
[null,"Net Grazing Benefit all Acres Grazed ($/Yr)",{"$f":"C175*C170","v":0}]
[]
[]
[null,"Haying Cover Crops"]
[null,"Number of Acres Hayed"]
[null,"Hay Yield (Tons/Ac)"]
[null,"Income from Harvesting Cover as Hay or Silage ($/Ac)",{"$f":"C181*C155","v":0}]
[null,"Cost of Harvesting Cover as Hay or Silage ($/Ac)"]
[null,"Net Haying Benefit ($/Ac)",{"$f":"(C181*C155)-C183","v":0}]
[null,"Net Haying Benefit all Acres Harvested ($/Yr)",{"$f":"C184*C180","v":0}]
[null,"Click here for crop price data sources"]

{"sheet":"Combined Practice Effects","index":5,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[3,0,3,6],[7,0,7,6],[75,1,75,6],[55,1,55,6],[37,1,37,6],[48,1,48,5],[49,1,49,4],[50,1,50,4],[69,1,69,5],[4,0,6,6],[27,1,27,5],[10,1,10,6],[17,1,17,5],[14,1,14,5],[91,1,91,6],[92,1,92,4],[97,1,97,4],[84,1,84,2],[30,1,30,4],[31,1,31,4],[70,1,70,4],[71,1,71,4],[81,1,81,2],[82,1,82,2],[33,1,33,5],[51,1,51,5],[87,1,87,2]]}
["Changes due to the Combination of Soil Health Practices"]
["Use this page to calculate effects that cannot be attributed to just one practice."]
[]
["ABOUT THIS TAB:"]
["The Combined Practice Effects tab calculates economic effects that are attributed to a combination of soil health practices.  Economic effects on this tab include changes in:  (1) yield;  (2) fertilizer use; (3) pesticide use; (4) soil erosion rate; and (5) other benefits or costs as identified by the farmer.  To avoid double counting, DO NOT enter any effect information that is already covered on the individual practice tabs.  All effects are calculated on an annual basis per acre and for the entire Study Area."]
[]
[]
[]
[null,"Yield Impacts Due to Soil Health Practices"]
[null,"Is this an organic farm? (Y/N)"]
[null,"TIPS:\n(1) User must answer above question \"Is this an organic farm?\" or the table will not calculate correctly.\n(2) User must enter their \"Benchmark Average Yield\" AND \"% Yield Increase/Decrease\" OR \"Change in Ave. Yield\". If user enters both of the latter, calculation will use % yield change value.\n(3) Benchmark average yield should reflect the average yield under benchmark practices before soil health practice adoption."]
[null,"Cash Crop"]
[null,"Unit",{"$f":"IFERROR(VLOOKUP(C12,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D12,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E12,Prices!$B$69:$F$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F12,Prices!$B$69:$F$76,2,FALSE),0)","v":0}]
[null,"Benchmark Average Yield (Unit/Acre)"]
[null,"AND"]
[null,"% Yield Increase/Decrease due to Combined Practices (+/- %) "]
[null,"Calculated Change in Ave. Yield due to Combined Practices (+/- Unit/Ac)",{"$f":"C14*C16","v":0},{"$f":"D14*D16","v":0},0,0]
[null,"AND/OR"]
[null,"Change in Ave. Yield due to Combined Practices (+/- Unit/Ac)"]
[null,"HIDDEN: Calculated Current Ave. Yield Due to Combined Practices (Unit/Ac) [used in \"Current Crop Value Per Acre\"]",{"$f":"IF(C17<>0,C14+C17,C14+C19)","v":0},{"$f":"IF(D17<>0,D14+D17,D14+D19)","v":0},0,0]
[]
[null,"Standard Crop Price per Unit1",{"$f":"IFERROR(IF($C$10=\"Y\",VLOOKUP(C12,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(C12,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$10=\"Y\",VLOOKUP(D12,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(D12,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$10=\"Y\",VLOOKUP(E12,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(E12,Prices!$B$69:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$10=\"Y\",VLOOKUP(F12,Prices!$B$83:$G$90,6,FALSE),VLOOKUP(F12,Prices!$B$69:$F$76,5,FALSE)),0)","v":0}]
[null,"Farmer's Crop Price per Unit (Optional)",{"$f":"IFERROR(VLOOKUP(C12,'Farm Info'!B69:D75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D12,'Farm Info'!C69:E75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E12,'Farm Info'!D69:F75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F12,'Farm Info'!E69:G75,3,FALSE),0)","v":0}]
[null,"Benchmark Crop Acreage",{"$f":"IFERROR(IF(C12<>0,VLOOKUP(C12,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D12<>0,VLOOKUP(D12,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E12<>0,VLOOKUP(E12,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F12<>0,VLOOKUP(F12,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0}]
[null,"Current Crop Acreage",{"$f":"IFERROR(IF(C12<>0,VLOOKUP(C12,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D12<>0,VLOOKUP(D12,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E12<>0,VLOOKUP(E12,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F12<>0,VLOOKUP(F12,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0}]
[null,"Benchmark Crop Value Per Acre",{"$f":"IF(C14>0,(C14*IF(C23>0,C23,C22)),0)","v":0},{"$f":"IF(D14>0,(D14*IF(D23>0,D23,D22)),0)","v":0},{"$f":"IF(E14>0,(E14*IF(E23>0,E23,E22)),0)","v":0},{"$f":"IF(F14>0,(F14*IF(F23>0,F23,F22)),0)","v":0}]
[null,"Current Crop Value Per Acre",{"$f":"IF(C20>0,(C20*IF(C23>0,C23,C22)),0)","v":0},{"$f":"IF(D20>0,(D20*IF(D23>0,D23,D22)),0)","v":0},0,0]
[]
[null,"Total Change by Crop ($)",{"$f":"(C25*C27)-(C24*C26)","v":0},{"$f":"(D25*D27)-(D24*D26)","v":0},{"$f":"(E25*E27)-(E24*E26)","v":0},{"$f":"(F25*F27)-(F24*F26)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"IF(C29<>0,C29/C25,0)","v":0},{"$f":"IF(D29<>0,D29/D25,0)","v":0},{"$f":"IF(E29<>0,E29/E25,0)","v":0},{"$f":"IF(F29<>0,F29/F25,0)","v":0}]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C29:F29)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F31/SUM(C25:F25),0)","v":0}]
[null,"1  National average non-organic or organic price."]
[null,"Click here for crop price data sources"]
[]
[]
[null,"Impact of Soil Health Practices on Primary Nutrients Used"]
[null,"TIP:  Enter negative values to indicate savings and positive values to indicate an increase in cost."]
[null,"Cash Crop"]
[null,"Nitrogen (+/- Lbs/Ac)"]
[null,"Change in Nitrogen Cost/Ac",{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*C40,C40*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*D40,D40*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*E40,E40*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*F40,F40*Prices!$D$106)","v":0}]
[null,"Phosphorus (+/- Lbs/Ac)"]
[null,"Change in Phosphorus Cost/Ac",{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*C42,C42*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*D42,D42*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*E42,E42*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*F42,F42*Prices!$D$107)","v":0}]
[null,"Potassium  (+/- Lbs/Ac)"]
[null,"Change in Potassium Cost/Ac",{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*C44,C44*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*D44,D44*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*E44,E44*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*F44,F44*Prices!$D$108)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C41+C43+C45","v":0},{"$f":"D41+D43+D45","v":0},{"$f":"E41+E43+E45","v":0},{"$f":"F41+F43+F45","v":0}]
[null,"Acres",{"$f":"IF(OR(C40<>0,C42<>0,C44<>0),VLOOKUP(C39,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(D40<>0,D42<>0,D44<>0),VLOOKUP(D39,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(E40<>0,E42<>0,E44<>0),VLOOKUP(E39,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(F40<>0,F42<>0,F44<>0),VLOOKUP(F39,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C46*C47","v":0},{"$f":"D46*D47","v":0},0,0]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C48:F48),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F50/SUM(C47:F47), 0)","v":0}]
[null,"Click here for nutrient prices data sources"]
[]
[]
[null,"Change in Usage of Pesticides due to Soil Health Practices"]
[null,"TIPS:  \n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Make sure you are not double counting if additional soil health practices are being analyzed."]
[null,"Cash Crop"]
[null,"Herbicide Cost/Ac"]
[null,"Herbicide % Change (+/-)"]
[null,"Herbicide Change in Cost/Ac",{"$f":"C59*C58","v":0},{"$f":"D59*D58","v":0},{"$f":"E59*E58","v":0},{"$f":"F59*F58","v":0}]
[null,"Insecticide Cost/Ac"]
[null,"Insecticide % Change (+/-)"]
[null,"Insecticide Change in Cost/Ac",{"$f":"C62*C61","v":0},{"$f":"D62*D61","v":0},{"$f":"E62*E61","v":0},{"$f":"F62*F61","v":0}]
[null,"Fungicide Cost/Ac"]
[null,"Fungicide % Change (+/-)"]
[null,"Fungicide Change in Cost/Ac",{"$f":"C65*C64","v":0},{"$f":"D65*D64","v":0},{"$f":"E65*E64","v":0},{"$f":"F65*F64","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C66+C63+C60","v":0},{"$f":"D66+D63+D60","v":0},{"$f":"E66+E63+E60","v":0},{"$f":"F66+F63+F60","v":0}]
[null,"Acres",{"$f":"IF(OR(C59<>0,C62<>0,C65<>0),VLOOKUP(C57,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(D59<>0,D62<>0,D65<>0),VLOOKUP(D57,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(E59<>0,E62<>0,E65<>0),VLOOKUP(E57,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0},{"$f":"IF(OR(F59<>0,F62<>0,F65<>0),VLOOKUP(F57,'Farm Info'!$B$27:$D$30,3,FALSE),0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C67*C68","v":0},{"$f":"D67*D68","v":0},0,0]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C69:F69),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F71/SUM(C68:F68), 0)","v":0}]
[]
[]
[null,"Value of Decreased Erosion due to Soil Health Practices"]
[null,"TIPS: \n(1) Number of Acres is the area where the reduction in erosion was observed. This could be the entire Study Area in cases where slopes are relatively uniform throughout2 or, if the area is comprised of a combination of relatively flat areas and steeper ground, the acreage could be the portion encompassed by the steeper ground.  \n(2) Options for Reduced Erosion:\n      a. Enter tons of reduced erosion results (Tons/Acre/Year) modeled using any sediment reduction tool, such as the Nutrient Tracking Tool;\n      b. Enter the erosion reduction value from RUSLE-2 analysis undertaken by your advisor; or\n      c. Any value that seems reasonable based on soil including zero.\n(3) Total Annual Change in Repair Cost should only include changes in costs for repairs that occur within the Study Area.\n(4) Enter a negative value if cost of repairs has decreased and a positive value if cost of repairs increased."]
[null,"Retained Nutrients Benefits","Amounts"]
[null,"Value of N and P per Ton of Soil",{"$f":"Prices!F98","v":2.2904}]
[null,"Number of Acres1"]
[null,"Tons Reduced Erosion (Tons/Acre/Year)"]
[null,"Total Value ($/Year)",{"$f":"C78*C79*C80","v":0}]
[null,"AND/OR"]
[null,"Reduced Mechanical Erosion Repair due to SH practices"]
[null,"Total Annual Change in Repair Cost ($/Year)"]
[]
[null,"Total per Acre Value of Decreased Erosion",{"$f":"IFERROR(((-1*C84)+C81)/'Farm Info'!D31,0)","v":0}]
[null,"1 Do not exceed total acres in the Study Area: ",{"$f":"'Farm Info'!D31","v":0}]
[null,"Click here for value of N and P per Ton of Soil data sources"]
[]
[]
[null,"Other Benefits and Costs"]
[null,"TIPS:  \n(1) Description should detail the benefits, costs, or changes in activities experienced and responsible for change in Per Acre Value.\n(2) Per Acre Value should be positive for BOTH Positive Effects/Decreased Costs and Negative Effects/Increased Costs."]
[null,"Positive Effects/Decreased Costs  (enter positive Per Acre Values)"]
[null,"Description of Other Benefit(s)","$/Ac","Number of Acres Affected","Total Benefit"]
[null,null,null,null,{"$f":"D95*C95","v":0}]
[null,null,null,null,{"$f":"D96*C96","v":0}]
[null,null,null,null,{"$f":"D97*C97","v":0}]
[null,"Negative Effects/Increased Costs (enter positive Per Acre Values)"]
[null,"Description of Other Cost(s)","$/Ac","Number of Acres Affected","Total Cost"]
[null,null,null,null,{"$f":"D100*C100","v":0}]
[null,null,null,null,{"$f":"D101*C101","v":0}]
[null,null,null,null,{"$f":"D102*C102","v":0}]

{"sheet":"ONLY CCR","index":6,"n_rows":153,"n_cols":6,"rows_kept":153,"cut":false,"hidden":false,"merged":[[98,9,98,14],[51,1,51,6],[25,1,25,5],[0,0,0,6],[2,0,2,6],[24,1,24,5],[32,1,32,3],[42,1,42,3],[45,1,45,3],[43,1,43,5],[35,1,35,5],[58,1,58,5],[55,1,55,5],[3,0,21,6],[46,1,46,5],[74,1,74,5],[116,1,116,6],[72,1,72,4],[68,1,68,5],[111,1,111,4],[112,1,112,4],[110,1,110,5],[78,1,78,6],[96,1,96,6],[90,1,90,4],[91,1,91,4],[89,1,89,5],[71,1,71,4],[92,1,92,5],[142,1,142,4],[148,1,148,4],[135,5,136,5],[122,1,122,2],[123,1,123,2],[125,1,125,2],[141,1,141,6],[132,1,133,5],[128,1,128,2]]}
["Changes due to Adopting Conservation Crop Rotation"]
[]
["ABOUT THIS TAB:"]
["The Conservation Crop Rotation (CCR) tab estimates economic effects following a change in rotation for improvement in soil health. The change in net income is estimated using USDA Agricultural Resource Management Survey (ARMS) data on commodity costs and returns. These survey data represent average costs of production across the country and are not linked to specific management systems, such as conventional tillage or no-till. Since these estimated economic effects of a change in crop rotation do not correspond to specific management systems, it is not appropriate to combine analysis of CCR with changes in tillage, nutrient managment, or cover crops practices.\n\nWARNING:  Adoption of a Conservation Crop Rotation cannot be analyzed with other soil health practices due to data discrepancies. Users can only analyze a Conservation Crop Rotation as a sole soil health practice. Also, corn silage cannot be analyzed on this tab because there is no net income data for corn silage.\n \nEconomic effects on this tab include changes in:  (1) net income; (2) yield;  (3) fertilizer use; (4) pesticide use; (5) soil erosion rate; and (6) other benefits or costs as identified by the farmer. See the \"Net Income Values by Crop\" tab to learn more about how changes in net income is calculated. All effects are calculated on an annual per acre basis for the entire Study Area.\n\nChanges inherent in switching between two crops, like the difference in volume of fertilizer applied to corn versus soybeans, are captured in the Net Income calculations.  Only quantify change(s) in (2)-(6) listed above if not captured in the change in Net Income calculations (see \"Net Income Values by Crop\" tab) and if change(s) applies to both a crop in the benchmark AND current rotation in order to capture a 'change'. For example, if there was a yield bump or reduction in fertilizer use after changing the crop rotation due to improvements in soil health, capture that change in additional tables.\n\n\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change in Net Income due to Change in Crop Rotation"]
[null,"TIPS: \n(1) No data entry is required in the following table as the values populate automatically using rotation information entered on the \"Farm Info\" tab then subsequently populate Net Income Per Acre from \"Net Income Values by Crop\" tab."]
[null,"BENCHMARK ROTATION"]
[null,"Acreage in Rotation:",{"$f":"'Farm Info'!D24","v":0}]
[null,"Crops Grown","# Years in Rotation","Acres","Net Income Per Acre","Net Income All Acres"]
[null,{"$f":"IF('Farm Info'!B20 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B20)","v":0},{"$f":"'Farm Info'!C20","v":0},{"$f":"'Farm Info'!$D20","v":0},{"$f":"IFERROR(VLOOKUP(B29,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E29*D29","v":0}]
[null,{"$f":"IF('Farm Info'!B21 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B21)","v":0},{"$f":"'Farm Info'!C21","v":0},{"$f":"'Farm Info'!$D21","v":0},{"$f":"IFERROR(VLOOKUP(B30,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E30*D30","v":0}]
[null,{"$f":"IF('Farm Info'!B22 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B22)","v":0},{"$f":"'Farm Info'!C22","v":0},{"$f":"'Farm Info'!$D22","v":0},{"$f":"IFERROR(VLOOKUP(B31,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E31*D31","v":0}]
[null,{"$f":"IF('Farm Info'!B23 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B23)","v":0},{"$f":"'Farm Info'!C23","v":0},{"$f":"'Farm Info'!$D23","v":0},{"$f":"IFERROR(VLOOKUP(B32,Prices!$B$116:$E$121,4,FALSE),0)","v":0},0]
[null,"Weighted Average Annual ",null,null,{"$f":"IFERROR(F33/SUM(D29:D32),0)","v":0},{"$f":"SUM(F29:F32)","v":0}]
[]
[]
[null,"CURRENT ROTATION"]
[null,"Acreage in Rotation:",{"$f":"'Farm Info'!D31","v":0}]
[null,"Cash Crop","# Years in Rotation","Acres","Net Income Per Acre","Net Income All Acres"]
[null,{"$f":"IF('Farm Info'!B27 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B27)","v":0},{"$f":"'Farm Info'!C27","v":0},{"$f":"'Farm Info'!$D27","v":0},{"$f":"IFERROR(VLOOKUP(B39,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E39*D39","v":0}]
[null,{"$f":"IF('Farm Info'!B28 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B28)","v":0},{"$f":"'Farm Info'!C28","v":0},{"$f":"'Farm Info'!$D28","v":0},{"$f":"IFERROR(VLOOKUP(B40,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E40*D40","v":0}]
[null,{"$f":"IF('Farm Info'!B29 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B29)","v":0},{"$f":"'Farm Info'!C29","v":0},{"$f":"'Farm Info'!$D29","v":0},{"$f":"IFERROR(VLOOKUP(B41,Prices!$B$116:$E$121,4,FALSE),0)","v":0},{"$f":"E41*D41","v":0}]
[null,{"$f":"IF('Farm Info'!B30 = \"Corn Silage\", \"*ERROR* Corn Silage Cannot Be Analyzed in CCR*\",'Farm Info'!B30)","v":0},{"$f":"'Farm Info'!C30","v":0},{"$f":"'Farm Info'!$D30","v":0},{"$f":"IFERROR(VLOOKUP(B42,Prices!$B$116:$E$121,4,FALSE),0)","v":0},0]
[null,"Weighted Average Annual ",null,null,{"$f":"IFERROR(F43/SUM(D39:D42),0)","v":0},{"$f":"SUM(F39:F42)","v":0}]
[]
[null,null,null,null,"Per Acre","All Acres"]
[null,"Change in Net Income",null,null,{"$f":"IF(E33>0,E43-E33,0)","v":0},{"$f":"IF(F33>0,F43-F33,0)","v":0}]
[null,"Click here for Net Income data source"]
[]
[]
[null,"Yield Impacts due to Change in Crop Rotation"]
[null,"Is this an organic farm? (Y/N)"]
[null,"TIPS:  \n(1) User must answer above question \"Is this an organic farm?\" or the table will not calculate correctly.\n(2) User must enter their benchmark average yield (unit/acre) AND % Yield Increase/Decrease Due to CCR OR Change in Ave. Yield Due to CCR (+/- Unit/Ac). If user enters both of the latter, calculation will use % yield change value.\n(3) Benchmark average yield should reflect the average yield under benchmark practices before CCR adoption."]
[null,"Cash Crop",{"$f":"B39","v":0},{"$f":"B40","v":0},{"$f":"B41","v":0},{"$f":"B42","v":0}]
[null,"Unit",{"$f":"IFERROR(VLOOKUP(C53,Prices!$B$70:$C$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D53,Prices!$B$70:$C$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E53,Prices!$B$70:$C$76,2,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F53,Prices!$B$70:$C$76,2,FALSE),0)","v":0}]
[null,"Benchmark Average Yield (Unit/Acre)"]
[null,"AND"]
[null,"% Yield Increase/Decrease Due To CCR(+/- %) "]
[null,"Calculated Change in Ave. Yield Due to CCR (+/- Unit/Ac)",{"$f":"C55*C57","v":0},{"$f":"D55*D57","v":0},0,0]
[null,"AND/OR"]
[null,"Change in Ave. Yield Due to CCR (+/- Unit/Ac)"]
[null,"HIDDEN: Calculated Current Ave. Yield Due to Changing NM (Unit/Ac) [used in \"Current Crop Value Per Acre\"]",{"$f":"IF(C58<>0,C55+C58,C55+C60)","v":0},{"$f":"IF(D58<>0,D55+D58,D55+D60)","v":0},0,0]
[]
[null,"Standard Crop Price per Unit1",{"$f":"IFERROR(IF($C$51=\"Y\",VLOOKUP(C53,Prices!$B$83:$G$90,5,FALSE),VLOOKUP(C53,Prices!$B$70:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$51=\"Y\",VLOOKUP(D53,Prices!$B$83:$G$90,5,FALSE),VLOOKUP(D53,Prices!$B$70:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$51=\"Y\",VLOOKUP(E53,Prices!$B$83:$G$90,5,FALSE),VLOOKUP(E53,Prices!$B$70:$F$76,5,FALSE)),0)","v":0},{"$f":"IFERROR(IF($C$51=\"Y\",VLOOKUP(F53,Prices!$B$83:$G$90,5,FALSE),VLOOKUP(F53,Prices!$B$70:$F$76,5,FALSE)),0)","v":0}]
[null,"Farmer's Crop Price per Unit (Optional)",{"$f":"IFERROR(VLOOKUP(C53,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(D53,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(E53,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(F53,'Farm Info'!$B$69:$D$75,3,FALSE),0)","v":0}]
[null,"Benchmark Crop Acreage",{"$f":"IFERROR(IF(C53<>0, VLOOKUP(C53,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D53<>0, VLOOKUP(D53,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E53<>0, VLOOKUP(E53,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F53<>0, VLOOKUP(F53,'Farm Info'!$B$20:$D$23, 3, FALSE), 0),0)","v":0}]
[null,"Current Crop Acreage",{"$f":"IFERROR(IF(C53<>0,VLOOKUP(C53,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(D53<>0,VLOOKUP(D53,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(E53<>0,VLOOKUP(E53,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0},{"$f":"IFERROR(IF(F53<>0,VLOOKUP(F53,'Farm Info'!$B$27:$D$30, 3, FALSE), 0),0)","v":0}]
[null,"Benchmark Crop Value Per Acre",{"$f":"IF(C55>0,(C55*IF(C64>0,C64,C63)),0)","v":0},{"$f":"IF(D55>0,(D55*IF(D64>0,D64,D63)),0)","v":0},{"$f":"IF(E55>0,(E55*IF(E64>0,E64,E63)),0)","v":0},{"$f":"IF(F55>0,(F55*IF(F64>0,F64,F63)),0)","v":0}]
[null,"Current Crop Value Per Acre",{"$f":"IF(C61>0,(C61*IF(C64>0,C64,C63)),0)","v":0},{"$f":"IF(D61>0,(D61*IF(D64>0,D64,D63)),0)","v":0},0,0]
[]
[null,"Total Change by Crop ($)",{"$f":"(C66*C68)-(C65*C67)","v":0},{"$f":"(D66*D68)-(D65*D67)","v":0},{"$f":"(E66*E68)-(E65*E67)","v":0},{"$f":"(F66*F68)-(F65*F67)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"IF(C70<>0,C70/C66,0)","v":0},{"$f":"IF(D70<>0,D70/D66,0)","v":0},{"$f":"IF(E70<>0,E70/E66,0)","v":0},{"$f":"IF(F70<>0,F70/F66,0)","v":0}]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"SUM(C70:F70)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F72/SUM(C66:F66),0)","v":0}]
[null,"1  National average non-organic or organic price."]
[null,"Click here for crop price data sources"]
[]
[]
[null,"Impact of Change in Crop Rotation on Primary Nutrients Used"]
[null,"TIPS:\n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Only enter changes in primary nutrients due to adoption of conservation crop rotation.\n(3) In this table, the change in nutrients applied will be applied to the Current Acres that the crop is in rotation."]
[null,"Cash Crop",{"$f":"IFERROR($B$39,0)","v":0},{"$f":"IFERROR($B$40,0)","v":0},{"$f":"IFERROR($B$41,0)","v":0},{"$f":"IFERROR($B$42,0)","v":0}]
[null,"Nitrogen (+/- Lbs/Ac)"]
[null,"Change in Nitrogen Cost/Ac",{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*C81,C81*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*D81,D81*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*E81,E81*Prices!$D$106)","v":0},{"$f":"IF('Farm Info'!$D64>0,'Farm Info'!$D64*F81,F81*Prices!$D$106)","v":0}]
[null,"Phosphorus (+/- Lbs/Ac)"]
[null,"Change in Phosphorus Cost/Ac",{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*C83,C83*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*D83,D83*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*E83,E83*Prices!$D$107)","v":0},{"$f":"IF('Farm Info'!$D65>0,'Farm Info'!$D65*F83,F83*Prices!$D$107)","v":0}]
[null,"Potassium  (+/- Lbs/Ac)"]
[null,"Change in Potassium Cost/Ac",{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*C85, C85*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*D85, D85*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*E85, E85*Prices!$D$108)","v":0},{"$f":"IF('Farm Info'!$D66>0,'Farm Info'!$D66*F85, F85*Prices!$D$108)","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C82+C84+C86","v":0},{"$f":"D82+D84+D86","v":0},{"$f":"E82+E84+E86","v":0},{"$f":"F82+F84+F86","v":0}]
[null,"Acres",{"$f":"IF(C87<>0,D$39,0)","v":0},{"$f":"IF(D87<>0,D$40,0)","v":0},{"$f":"IF(E87<>0,D$41,0)","v":0},{"$f":"IF(F87<>0,D$42,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C88*C87","v":0},{"$f":"D88*D87","v":0},{"$f":"E88*E87","v":0},{"$f":"F88*F87","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C89:F89),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F91/SUM(C88:F88), 0)","v":0}]
[null,"Click here for nutrient prices data sources"]
[]
[]
[null,"Impact of Change in Crop Rotation on Pesticides Used"]
[null,"TIPS:\n(1) Enter negative values to indicate savings and positive values to indicate an increase in cost.\n(2) Only enter changes in primary nutrients due to adoption of conservation crop rotation.\n(3) In this table, the change in nutrients applied will be applied to the Current Acres that the crop is in rotation."]
[null,"Cash Crop",{"$f":"IFERROR($B$39,0)","v":0},{"$f":"IFERROR($B$40,0)","v":0},{"$f":"IFERROR($B$41,0)","v":0},{"$f":"IFERROR($B$42,0)","v":0}]
[null,"Herbicide Cost/Ac"]
[null,"Herbicide % Change (+/-)"]
[null,"Herbicide Change in Cost/Ac",{"$f":"C100*C99","v":0},{"$f":"D100*D99","v":0},{"$f":"E100*E99","v":0},{"$f":"F100*F99","v":0}]
[null,"Insecticide Cost/Ac"]
[null,"Insecticide % Change (+/-)"]
[null,"Insecticide Change in Cost/Ac",{"$f":"C103*C102","v":0},{"$f":"D103*D102","v":0},{"$f":"E103*E102","v":0},{"$f":"F103*F102","v":0}]
[null,"Fungicide Cost/Ac"]
[null,"Fungicide % Change (+/-)"]
[null,"Fungicide Change in Cost/Ac",{"$f":"C106*C105","v":0},{"$f":"D106*D105","v":0},{"$f":"E106*E105","v":0},{"$f":"F106*F105","v":0}]
[null,"Per Acre Change by Crop ($/Ac)",{"$f":"C107+C104+C101","v":0},{"$f":"D107+D104+D101","v":0},{"$f":"E107+E104+E101","v":0},{"$f":"F107+F104+F101","v":0}]
[null,"Acres",{"$f":"IF(C108<>0,D$39,0)","v":0},{"$f":"IF(D108<>0,D$40,0)","v":0},{"$f":"IF(E108<>0,D$41,0)","v":0},{"$f":"IF(F108<>0,D$42,0)","v":0}]
[null,"Total Change by Crop ($)",{"$f":"C109*C108","v":0},{"$f":"D109*D108","v":0},{"$f":"E109*E108","v":0},{"$f":"F109*F108","v":0}]
[]
[null,"Study Area Total Change ($)",null,null,null,{"$f":"IFERROR(SUM(C110:F110),0)","v":0}]
[null,"Study Area Per Acre Change (Weighted Average, $/Ac)",null,null,null,{"$f":"IFERROR(F112/SUM(C109:F109), 0)","v":0}]
[]
[]
[null,"Value of Decreased Erosion due to Change in Crop Rotation"]
[null,"TIPS: \n(1) Only changes in benchmark versus current erosion and repair costs here if a change in crop rotation is the only soil health \n      practice analyzed.\n(2) Number of Acres is the area where the reduction in erosion was observed. This could be the entire area where you've changed your \n      Crop Rotation in cases where slopes are relatively uniform throughout or, if the area is comprised of a combination of relatively flat \n      areas and steeper ground, the acreage could be the portion encompassed by the steeper ground.  \n(3) Options for Reduced Erosion:\n      a. Enter tons of reduced erosion results (Tons/Acre/Year) modeled using any sediment reduction tool, such as the Nutrient Tracking Tool;\n      b. Enter the erosion reduction value from RUSLE-2 analysis undertaken by your advisor; or\n      c. Any value that seems reasonable based on soil including zero.\n(4) Total Annual Change in Repair Cost should only include changes in costs for repairs that occur within the Study Area.\n(5) Enter a negative value if cost of repairs has decreased and a positive value if cost of repairs increased."]
[null,"Retained Nutrients Benefits","Amounts"]
[null,"Value of N and P per Ton of Soil",{"$f":"Prices!F98","v":2.2904}]
[null,"Number of Acres1"]
[null,"Tons Reduced Erosion (Tons/Acre/Year)"]
[null,"Total Value ($/Year)",{"$f":"C119*C120*C121","v":0}]
[null,"AND/OR"]
[null,"Reduced Mechanical Erosion Repair due to CCR"]
[null,"Total Annual Change in Repair Cost ($/Year)"]
[]
[null,"Total Value/Acre of Decreased Erosion",{"$f":"IFERROR((C122+(-1*C125))/'Farm Info'!D31,0)","v":0}]
[null,"1 Do not exceed Study Area acreage:",{"$f":"'Farm Info'!D31","v":0}]
[null,"Click here for value of N and P per Ton of Soil data sources"]
[]
[]
[null,"Annual Financial Assistance Payments"]
[null,"Note: Any financial assistance payments listed are not included in the partial budget analysis because cost-share is temporary and not received by all, but can be noted in the footnote of PBA table."]
[]
[null,"Source","$/Ac/Yr","Acres Funded","Total ($)","Weighted Average ($/Ac)"]
[null,null,null,null,{"$f":"D136*C136","v":0}]
[null,null,null,null,{"$f":"D137*C137","v":0}]
[null,"Total Received",null,{"$f":"SUM(D136:D137)","v":0},{"$f":"SUM(E136:E137)","v":0},{"$f":"IFERROR(E138/D138,0)","v":0}]
[]
[]
[null,"Other Benefits and Costs due to a Change in Crop Rotation"]
[null,"TIPS:  \n(1) Description should detail the benefits, costs, or changes in activities experienced and responsible for change in Per Acre Value.\n(2) Per Acre Value should be positive for BOTH Positive Effects/Decreased Costs and Negative Effects/Increased Costs."]
[null,"Positive Effects/Decreased Costs  (enter positive Per Acre Values)"]
[null,"Description of Other Benefit(s)","$/Ac","Number of Acres Affected","Total Benefit"]
[null,null,null,null,{"$f":"D145*C145","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[]
[null,"Negative Effects/Increased Costs (enter positive Per Acre Values)"]
[null,"Description of Other Cost(s)","$/Ac","Number of Acres Affected","Total Cost"]
[null,null,null,null,{"$f":"D151*C151","v":0}]
[null,null,null,null,{"$f":"D152*C152","v":0}]
[null,null,null,null,0]

{"sheet":"Partial Budget Analysis","index":7,"n_rows":117,"n_cols":11,"rows_kept":117,"cut":false,"hidden":false,"merged":[[89,1,90,9],[81,1,81,3],[83,6,83,8],[82,6,82,8],[81,6,81,8],[83,1,83,3],[82,1,82,3],[104,10,104,16],[114,1,114,3],[80,1,80,4],[80,6,80,9],[41,1,41,3],[41,6,41,8],[87,6,87,9],[100,1,100,9],[88,1,88,9],[47,6,47,8],[53,6,53,8],[57,6,57,8],[84,1,84,9],[92,1,92,9],[104,1,105,9],[101,1,102,9],[116,1,116,3],[42,1,42,4],[42,6,42,9],[85,1,85,4],[86,1,86,4],[79,1,79,3],[79,6,79,8],[91,1,91,9],[87,1,87,4],[108,1,108,4],[115,1,115,3],[103,1,103,9],[60,6,60,8],[75,6,75,8],[93,1,97,9],[98,1,99,9],[0,1,0,9],[2,1,2,9],[20,1,20,9],[3,1,19,9],[25,1,26,9],[27,1,27,9],[28,1,28,4],[28,6,28,9],[29,1,29,4],[29,6,29,9]]}
[null,"PARTIAL BUDGET ANALYSIS"]
[]
[null,"ABOUT THIS TAB:"]
[null,"DO NOT EDIT THIS TAB: This tab and the table within should not be edited. Create your final PBA table in the subsequent tab called \"Editable PBA\" so if any mistakes are made you have this tab to reference and save results.\n\nThe Partial Budget Analysis tab autopopulates and organizes the effects calculated on the preceeding tabs into four quadrants:  \n     (1) Increase in Income; \n     (2) Decrease in Cost; \n     (3) Decrease in Income; and\n     (4) Increase in Cost\n\nPositive effects are displayed on the left and negative effects on the right.  Effects are sorted automatically into the four quadrants based on their value.  Columns A and K display the effect category from previous tabs assigned to the adjacent cell.   NRCS practice codes are used instead of practice names as follows:  329 represents tillage changes, 340 is Cover Crops, 590 is Nutrient Management, and 328 is Conservation Crop Rotation. The table can house every possible effect from the preceeding tabs.  This means that most of the rows will not be populated.  Totals are summarized at the bottom of the table for the entire Study Area.  These totals are used to calculate the net change in income on a per acre basis and for the Study Area.  The table also calculates the return on investment.  All values are on an annual basis. Suggested footnotes appear at the bottom of the table followed by a summary of financial assistance payments received, if any.  \n\nThis table should not be edited here, but on the subsequent tab called \"Editable PBA\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTE:  Farmer Name and Watershed Name are populated using information entered on the Farm Info tab."]
[null,"Farmer Name"]
[null,{"$f":"'Farm Info'!B9","v":0}]
[null,"Watershed Name"]
[null,{"$f":"'Farm Info'!B13","v":0}]
[null,"WARNING:  DO NOT attempt to edit the table as it contains complex formulas.  The user risks losing the calculated effect information if the formulas are broken.  The \"Editable PBA\" tab is identical to the Partial Budget Analysis tab and can be used for producing a version for publication."]
[]
[null,{"$f":"\"Economic Effects of Soil Health Practices on \"& 'Farm Info'!B11& \" (2021)\"","v":"Economic Effects of Soil Health Practices on  (2021)"}]
[null,"Increases in Net Income",null,null,null,null,"Decreases in Net Income"]
[null,"Increase in Income",null,null,null,null,"Decrease in Income"]
[null,"Item","Per Acre","Acres","Total",null,"Item","Per Acre","Acres","Total"]
["329 Yield",{"$f":"IF(Tillage!F141>0,Tillage!B109,\"NA\")","v":"NA"},{"$f":"IFERROR(IF(Tillage!F141>0,Tillage!F141,0),0)","v":0},{"$f":"IF(Tillage!F141>0,SUM(Tillage!C134:F134),0)","v":0},{"$f":"D32*C32","v":0},null,{"$f":"IF(Tillage!F141<0,Tillage!B109,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F141<0,Tillage!F141*-1,0)","v":0},{"$f":"IF(Tillage!F141<0,SUM(Tillage!C134:F134),0)","v":0},{"$f":"I32*H32","v":0},"329 Yield"]
["340 Yield",{"$f":"IF('Cover Crops'!F53>0,'Cover Crops'!B30,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F53>0,'Cover Crops'!F53,0)","v":0},{"$f":"IF('Cover Crops'!F53>0,SUM('Cover Crops'!C46:F46),0)","v":0},{"$f":"D33*C33","v":0},null,{"$f":"IF('Cover Crops'!F53<0,'Cover Crops'!B30,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F53<0,'Cover Crops'!F53*-1,0)","v":0},{"$f":"IF('Cover Crops'!F53<0,SUM('Cover Crops'!C46:F46),0)","v":0},{"$f":"I33*H33","v":0},"340 Yield"]
["340 Graz Y",{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!B169,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!C174,0)","v":0},{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!C170,0)","v":0},{"$f":"D34*C34","v":0},null,{"$f":"IF('Nutrient Mgt.'!F144<0,'Nutrient Mgt.'!B113,\"NA\")","v":"NA"},{"$f":"IFERROR(IF('Nutrient Mgt.'!F144<0,'Nutrient Mgt.'!F144*-1,0),0)","v":0},{"$f":"IF('Nutrient Mgt.'!F144<0,SUM('Nutrient Mgt.'!C137:F137),0)","v":0},{"$f":"I34*H34","v":0},"590 Yield"]
["340 Graz Y",{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!E167,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!H172,0)","v":0},{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!H168,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!E46<0,'ONLY CCR'!B24,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!E46<0,'ONLY CCR'!E46*-1,0)","v":0},{"$f":"IF('ONLY CCR'!E46<0,SUM('ONLY CCR'!D39:D42),0)","v":0},{"$f":"I35*H35","v":0},"328 Net Income"]
["340 Graz Y",{"$f":"IF('Cover Crops'!H162>0,'Cover Crops'!E157,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!H162>0,'Cover Crops'!H162,0)","v":0},{"$f":"IF('Cover Crops'!H163>0,'Cover Crops'!H158,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F73<0,'ONLY CCR'!B50,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F73<0,'ONLY CCR'!F73*-1,0)","v":0},{"$f":"IFERROR(IF('ONLY CCR'!F73<0,SUM('ONLY CCR'!C66:F66),0),0)","v":0},{"$f":"I36*H36","v":0},"328 Yield "]
["340 Hay Y",{"$f":"IF('Cover Crops'!C182>0,'Cover Crops'!B182,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C182>0,'Cover Crops'!C182,0)","v":0},{"$f":"IF('Cover Crops'!C180>0,'Cover Crops'!C180,0)","v":0},0,null,{"$f":"IF('Combined Practice Effects'!F32<0,'Combined Practice Effects'!B9,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F32<0,'Combined Practice Effects'!F32*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F32<0,SUM('Combined Practice Effects'!C25:F25),0)","v":0},{"$f":"I37*H37","v":0},"All Practices"]
["590 Yield",{"$f":"IF('Nutrient Mgt.'!F144>0,'Nutrient Mgt.'!B113,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F144>0,'Nutrient Mgt.'!F144,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F144>0,SUM('Nutrient Mgt.'!C137:F137),0)","v":0},0]
["328 Net Income",{"$f":"IF('ONLY CCR'!E46>0,'ONLY CCR'!B24,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!E46>0,'ONLY CCR'!E46,0)","v":0},{"$f":"IF('ONLY CCR'!E46>0,SUM('ONLY CCR'!D39:D42),0)","v":0},{"$f":"D39*C39","v":0}]
["328 Yield",{"$f":"IFERROR(IF('ONLY CCR'!F46>0,'ONLY CCR'!B50,\"NA\"),0)","v":"NA"},{"$f":"IFERROR(IF('ONLY CCR'!F73>0,'ONLY CCR'!F73,0),0)","v":0},{"$f":"IFERROR(IF('ONLY CCR'!F73>0,SUM('ONLY CCR'!C66:F66),0),0)","v":0},0]
["All Practices",{"$f":"IF('Combined Practice Effects'!F32>0,'Combined Practice Effects'!B9,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F32>0,'Combined Practice Effects'!F32,0)","v":0},{"$f":"IF('Combined Practice Effects'!F32>0,SUM('Combined Practice Effects'!C25:F25),0)","v":0},{"$f":"D41*C41","v":0}]
[null,"Total Increased Income",null,null,{"$f":"SUM(E32:E41)","v":0},null,"Total Decreased Income",null,null,{"$f":"SUM(J32:J41)","v":0}]
[null,"Decrease in Cost",null,null,null,null,"Increase in Cost"]
[null,"Item","Per Acre","Acres","Total",null,"Item","Per Acre","Acres","Total"]
["329 Machinery",{"$f":"IF(Tillage!C105<0,Tillage!B96,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C105<0,Tillage!C105*-1,0)","v":0},{"$f":"IF(Tillage!C105<0,Tillage!C23+Tillage!C44+Tillage!C65+Tillage!C86,0)","v":0},{"$f":"D45*C45","v":0},null,{"$f":"IF(Tillage!C105>0,Tillage!B96,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C105>0,Tillage!C105,0)","v":0},{"$f":"IF(Tillage!C105>0,Tillage!C14+Tillage!C35+Tillage!C56+Tillage!C77,0)","v":0},{"$f":"I45*H45","v":0},"329 Machinery"]
["329 Nutrients",{"$f":"IF(Tillage!F164<0,Tillage!B146,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F164<0,Tillage!F164*-1,0)","v":0},{"$f":"IF(Tillage!F164<0,SUM(Tillage!C160:F160),0)","v":0},{"$f":"D46*C46","v":0},null,{"$f":"IF(Tillage!F164>0,Tillage!B146,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F164>0,Tillage!F164,0)","v":0},{"$f":"IF(Tillage!F164>0,SUM(Tillage!C160:F160),0)","v":0},0,"329 Nutrients"]
["329 Pesticides",{"$f":"IF(Tillage!F190<0,Tillage!B168,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F190<0,Tillage!F190*-1,0)","v":0},{"$f":"IF(Tillage!F190<0,SUM(Tillage!C186:F186),0)","v":0},0,null,{"$f":"IF(Tillage!F190>0,Tillage!B168,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F190>0,Tillage!F190,0)","v":0},{"$f":"IF(Tillage!F190>0,SUM(Tillage!C186:F186),0)","v":0},0,"329 Pesticides"]
["329 Erosion",{"$f":"IF(Tillage!C215>0,Tillage!B193,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C215>0,Tillage!C215,0)","v":0},{"$f":"IF(Tillage!C215>0,'Farm Info'!D31,0)","v":0},{"$f":"D48*C48","v":0},null,{"$f":"IF('Farm Info'!C49>0,'Farm Info'!B49,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C49>0,'Farm Info'!D49,0)","v":0},"329 Education"]
["340 Nutrients",{"$f":"IF('Cover Crops'!F72<0,'Cover Crops'!$B$58,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F72<0,'Cover Crops'!F72*-1,0)","v":0},{"$f":"IF('Cover Crops'!F72<0,SUM('Cover Crops'!C68:F68),0)","v":0},0,null,{"$f":"IF('Cover Crops'!F28>0,'Cover Crops'!B13,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F28>0,'Cover Crops'!F28,0)","v":0},{"$f":"IF('Cover Crops'!F28>0,SUM('Cover Crops'!C19:F19),0)","v":0},0,"340 Costs"]
["340 Pesticides",{"$f":"IF('Cover Crops'!F99<0,'Cover Crops'!$B76,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F99<0,'Cover Crops'!F99*-1,0)","v":0},{"$f":"IF('Cover Crops'!F99<0,SUM('Cover Crops'!C95:F95),0)","v":0},0,null,{"$f":"IF('Cover Crops'!F72>0,'Cover Crops'!$B$58,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F72>0,'Cover Crops'!F72,0)","v":0},{"$f":"IF('Cover Crops'!F72>0,SUM('Cover Crops'!C68:F68),0)","v":0},0,"340 Nutrients"]
["340 Erosion",{"$f":"IF('Cover Crops'!C125>0,'Cover Crops'!B102,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C125>0,'Cover Crops'!C125,0)","v":0},{"$f":"IF('Cover Crops'!C125>0,'Farm Info'!D31,0)","v":0},0,null,{"$f":"IF('Cover Crops'!F99>0,'Cover Crops'!$B76,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F99>0,'Cover Crops'!F99,0)","v":0},{"$f":"IF('Cover Crops'!F99>0,SUM('Cover Crops'!C95:F95),0)","v":0},0,"340 Pesticides"]
["590 Machinery",{"$f":"IF('Nutrient Mgt.'!C109<0,'Nutrient Mgt.'!B100,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C109<0,'Nutrient Mgt.'!C109*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C109<0,('Nutrient Mgt.'!C26+'Nutrient Mgt.'!C45+'Nutrient Mgt.'!C64+'Nutrient Mgt.'!C83),0)","v":0},0,null,{"$f":"IF('Cover Crops'!C163>0,'Cover Crops'!B166,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C166>0,'Cover Crops'!C166,0)","v":0},{"$f":"IF('Cover Crops'!C166>0,('Cover Crops'!C170+'Cover Crops'!H158+'Cover Crops'!H168),0)","v":0},0,"340 Grazing Infrastructure"]
["590 Nutrients",{"$f":"IF('Nutrient Mgt.'!F168<0,'Nutrient Mgt.'!B149,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F168<0,'Nutrient Mgt.'!F168*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F168<0,SUM('Nutrient Mgt.'!C164:F164),0)","v":0},0,null,{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!B183,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!C183,0)","v":0},{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!C180,0)","v":0},0,"340 Haying Harvest"]
["590 Pesticides",{"$f":"IF('Nutrient Mgt.'!F194<0,'Nutrient Mgt.'!B172,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F194<0,'Nutrient Mgt.'!F194*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F194<0,SUM('Nutrient Mgt.'!C190:F190),0)","v":0},0,null,{"$f":"IF('Farm Info'!C50>0,'Farm Info'!B50,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C50>0,'Farm Info'!D50,0)","v":0},"340 Education"]
["328 Nutrients",{"$f":"IF('ONLY CCR'!F92<0,'ONLY CCR'!B78,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F92<0,'ONLY CCR'!F92*-1,0)","v":0},{"$f":"IF('ONLY CCR'!F92<0,SUM('ONLY CCR'!C88:F88),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C109>0,'Nutrient Mgt.'!B100,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C109>0,'Nutrient Mgt.'!C109,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C109>0,('Nutrient Mgt.'!C26+'Nutrient Mgt.'!C45+'Nutrient Mgt.'!C64+'Nutrient Mgt.'!C83),0)","v":0},0,"590 Machinery"]
["328 Pesticides",{"$f":"IF('ONLY CCR'!F113<0,'ONLY CCR'!B96,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F113<0,'ONLY CCR'!F113*-1,0)","v":0},{"$f":"IF('ONLY CCR'!F113<0,SUM('ONLY CCR'!C109:F109),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!F168>0,'Nutrient Mgt.'!B149,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F168>0,'Nutrient Mgt.'!F168,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F168>0,SUM('Nutrient Mgt.'!C164:F164),0)","v":0},{"$f":"I56*H56","v":0},"590 Nutrients"]
["328 Erosion",{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!B116,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!C127,0)","v":0},{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!C37,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!F194>0,'Nutrient Mgt.'!B172,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F194>0,'Nutrient Mgt.'!F194,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F194>0,SUM('Nutrient Mgt.'!C190:F190),0)","v":0},{"$f":"I57*H57","v":0},"590 Pesticides"]
["329 PosEff 1",{"$f":"IF(Tillage!C236>0,Tillage!B236,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C236>0,Tillage!C236,0)","v":0},{"$f":"IF(Tillage!C236>0,Tillage!D236,0)","v":0},{"$f":"D58*C58","v":0},null,{"$f":"IF('Farm Info'!C51>0,'Farm Info'!B51,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C51>0,'Farm Info'!D51, 0)","v":0},"590 Education"]
["329 PosEff2",{"$f":"IF(Tillage!C237>0,Tillage!B237,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C237>0,Tillage!C237,0)","v":0},{"$f":"IF(Tillage!C237>0,Tillage!D237,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F92>0,'ONLY CCR'!B78,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F92>0,'ONLY CCR'!F92,0)","v":0},{"$f":"IF('ONLY CCR'!F92>0,SUM('ONLY CCR'!C88:F88),0)","v":0},{"$f":"I59*H59","v":0},"328 Nutrients"]
["329 PosEff3",{"$f":"IF(Tillage!C238>0,Tillage!B238,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C238>0,Tillage!C238,0)","v":0},{"$f":"IF(Tillage!C238>0,Tillage!D238,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F113>0,'ONLY CCR'!B96,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F113>0,'ONLY CCR'!F113,0)","v":0},{"$f":"IF('ONLY CCR'!F113>0,SUM('ONLY CCR'!C109:F109),0)","v":0},0,"328 Pesticides"]
["340PosEff1",{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!B143,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!C143,0)","v":0},{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!D143,0)","v":0},0,null,{"$f":"IF('Farm Info'!C52>0,'Farm Info'!B52,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C52>0,'Farm Info'!D52,0)","v":0},"328 Education"]
["340PosEff2",{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!B144,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!C144,0)","v":0},{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!D144,0)","v":0},{"$f":"D62*C62","v":0},null,{"$f":"IF(Tillage!C242>0,Tillage!B242,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C242>0,Tillage!C242,0)","v":0},{"$f":"IF(Tillage!C242>0,Tillage!D242,0)","v":0},{"$f":"I62*H62","v":0},"329 NegEff1"]
["340PosEff3",{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!B145,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!C145,0)","v":0},{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!D145,0)","v":0},0,null,{"$f":"IF(Tillage!C243>0,Tillage!B243,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C243>0,Tillage!C243,0)","v":0},{"$f":"IF(Tillage!C243>0,Tillage!D243,0)","v":0},{"$f":"I63*H63","v":0},"329 NegEff2"]
["590PosEff1",{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!B213,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!C213,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!D213,0)","v":0},0,null,{"$f":"IF(Tillage!C244>0,Tillage!B244,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C244>0,Tillage!C244,0)","v":0},{"$f":"IF(Tillage!C244>0,Tillage!D244,0)","v":0},0,"329 NegEff3"]
["590PosEff2",{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!B214,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!C214,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!D214,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!B149,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!C149,0)","v":0},{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!D149,0)","v":0},0,"340NegEff1"]
["590PosEff3",{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!B215,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!C215,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!D215,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!B150,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!C150,0)","v":0},{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!D150,0)","v":0},{"$f":"I66*H66","v":0},"340NegEff2"]
["328PosEff1",{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!B145,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!C145,0)","v":0},{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!D145,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!B151,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!C151,0)","v":0},{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!D151,0)","v":0},0,"340NegEff3"]
["328PosEff2",{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!B146,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!C146,0)","v":0},{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!D146,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!B219,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!C219,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!D219,0)","v":0},0,"590NegEff1"]
["328PosEff3",{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!B147,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!C147,0)","v":0},{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!D147,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!B220,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!C220,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!D220,0)","v":0},0,"590NegEff2"]
["All Practices NPK",{"$f":"IF('Combined Practice Effects'!F51<0,'Combined Practice Effects'!B37,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F51<0,'Combined Practice Effects'!F51*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F51<0,SUM('Combined Practice Effects'!C47:F47),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!B221,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!C221,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!D221,0)","v":0},0,"590NegEff3"]
["All Practices Pesticides",{"$f":"IF('Combined Practice Effects'!F72<0,'Combined Practice Effects'!B55,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F72<0,'Combined Practice Effects'!F72*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F72<0,SUM('Combined Practice Effects'!C68:F68),0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!B151,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!C151,0)","v":0},{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!D151,0)","v":0},0,"328NegEff1"]
["All Practices Erosion",{"$f":"IF('Combined Practice Effects'!C86>0,'Combined Practice Effects'!B75,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C86>0,'Combined Practice Effects'!C86,0)","v":0},{"$f":"IF('Combined Practice Effects'!C86>0,'Farm Info'!D31,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!B152,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!C152,0)","v":0},{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!D152,0)","v":0},0,"328NegEff2"]
["All PracticesPosEff1",{"$f":"IF('Combined Practice Effects'!E95>0,'Combined Practice Effects'!B95,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C95>0,'Combined Practice Effects'!C95,0)","v":0},{"$f":"IF('Combined Practice Effects'!C95>0,'Combined Practice Effects'!D95,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!B153,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!C153,0)","v":0},{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!D153,0)","v":0},0,"328NegEff3"]
["All PracticesPosEff2",{"$f":"IF('Combined Practice Effects'!E96>0,'Combined Practice Effects'!B96,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C96>0,'Combined Practice Effects'!C96,0)","v":0},{"$f":"IF('Combined Practice Effects'!C96>0,'Combined Practice Effects'!D96,0)","v":0},{"$f":"D74*C74","v":0},null,{"$f":"IF('Combined Practice Effects'!F51>0,'Combined Practice Effects'!B37,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F51>0,'Combined Practice Effects'!F51,0)","v":0},{"$f":"IF('Combined Practice Effects'!F51>0,SUM('Combined Practice Effects'!C47:F47),0)","v":0},0,"All Practices NPK"]
["All PracticesPosEff3",{"$f":"IF('Combined Practice Effects'!E97>0,'Combined Practice Effects'!B97,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C97>0,'Combined Practice Effects'!C97,0)","v":0},{"$f":"IF('Combined Practice Effects'!C97>0,'Combined Practice Effects'!D97,0)","v":0},0,null,{"$f":"IF('Combined Practice Effects'!F72>0,'Combined Practice Effects'!B55,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F72>0,'Combined Practice Effects'!F72,0)","v":0},{"$f":"IF('Combined Practice Effects'!F72>0,SUM('Combined Practice Effects'!C68:F68),0)","v":0},0,"All Practices Pesticides"]
[null,null,null,null,null,null,{"$f":"IF('Farm Info'!C54>0,'Farm Info'!B54,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C54>0,'Farm Info'!D54, 0)","v":0},"All Practices Learning Activities"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!B100,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!C100,0)","v":0},{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!D100,0)","v":0},{"$f":"I77*H77","v":0},"All PracticesNegEff1"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!B101,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!C101,0)","v":0},{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!D101,0)","v":0},{"$f":"I78*H78","v":0},"All PracticesNegEff2"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!B102,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!C102,0)","v":0},{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!D102,0)","v":0},0,"All PracticesNegEff3"]
[null,"Total Decreased Cost",null,null,{"$f":"SUM(E45:E78)","v":0},null,"Total Increased Cost",null,null,{"$f":"SUM(J45:J79)","v":0}]
[]
[null,"Annual Total Increased Net Income",null,null,{"$f":"IFERROR(E80+E42,0)","v":0},null,"Annual Total Decreased Net Income",null,null,{"$f":"IFERROR(J80+J42,0)","v":0}]
[null,"Total Acres in this Study Area",null,null,{"$f":"'Farm Info'!D31","v":0},null,"Total Acres in this Study Area",null,null,{"$f":"'Farm Info'!D31","v":0}]
[null,"Annual Per Acre Increased Net Income",null,null,{"$f":"IFERROR(ROUND(E82/E83,0),0)","v":0},null,"Annual Per Acre Decreased Net Income",null,null,{"$f":"IFERROR(ROUND(J82/J83,0),0)","v":0}]
[]
[null,"Annual Change in Total Net Income",null,null,null,"=",{"$f":"IFERROR(E82-J82,0)","v":0}]
[null,"Annual Change in Per Acre Net Income",null,null,null,"=",{"$f":"IFERROR(G86/E83,0)","v":0}]
[null,"Return on Investment",null,null,null,"=",{"$f":"IFERROR(G86/J82,0)","v":0}]
[null,"Footnotes:"]
[null,"This table represents estimated average costs and benefits attributed to adopting [list SH practices] over the entire study area (### acres) ,where [list crops] are grown, as reported by the farmer. "]
[]
[null,"All values are in 2021 dollars, unless provided by the farmer."]
[null,"Prices are stated as per acre values for items that vary by area. Prices such as learning costs, which don't vary by area, are only given as total costs."]
[null,"2021 standard prices (if used) in the analysis:  Barley: $5.15/bu, Corn Grain: $5.45/bu, Corn Silage: $49.05/ton, Grain Sorghum: $9.75/cwt, Hay: $186/ton, Oats: $4/bu, Soybeans: $13/bu, Wheat: $7.30/bu (Source:  USDA NASS, Crop Values: 2021 Summary).  Nitrogen:  $.72/Lb, Phosphate:  $.62/Lb, Potash:  $.56/Lb (Source:  Iowa State University Extension and Outreach, Ag Decision Maker: Estimated Costs of Crop Production in Iowa, 2022). Net Income (value of production minus operating costs) values for Barley: -$11/ac, Corn Grain: $429/ac, Grain Sorghum: $136/ac, Oats: $11/ac, Soybeans: $325/ac, Wheat: $36/ac (USDA ERS, May 2022, Commodity Costs and Returns); Net income for Hay: $152/ac (calculated from various sources)."]
[]
[]
[]
[]
[null,"Value of decreased erosion ($1.18/ton) is based on estimated N & P content of the soil (2.32 lbs N/ton, 1 lb P/ton) and fertilizer prices (USDA NRCS, May 2010, Final Benefit-Cost Analysis for the EQIP) and [insert farmer name, e.g. Scotty's] estimate of reduced mechanical erosion repair costs."]
[]
[null,"Return on Investment is the ratio of Annual Total Change in Net Income to Annual Total Decreased Net Income, as a percent."]
[null,"For information about: (1) study methodology, see farmland.org/soilhealthcasestudies; (2) USDA's Nutrient Tracking Tool, see ntt.tiaer.tarleton.edu/welcomes/; (3) USDA's COMET-Farm Tool, see comet-farm.com."]
[]
[null,"This material is based on work supported by USDA NRCS CIG grant NR183A750008G008."]
[null,"[insert grower's first name] received [insert amount, e.g., $/ac/yr or $/yr] through the [insert name of program (years active)]. This is not included in the analysis because cost-share is temporary and not received by all."]
[]
[]
[null,"Impact of Financial Assistance Payments"]
[null,"Increase in Income"]
[null,"Soil Health Practice","Per Acre","Acres","Total"]
[null,"Tillage (Residue Management)",{"$f":"IFERROR(Tillage!#REF!,0)","v":0},{"$f":"Tillage!D226","v":0},{"$f":"IFERROR(D111*C111,0)","v":0}]
[null,"Cover Crop",{"$f":"IFERROR('Cover Crops'!F136,0)","v":0},{"$f":"'Cover Crops'!D136","v":0},{"$f":"IFERROR(D112*C112,0)","v":0}]
[null,"Nutrient Management",{"$f":"IFERROR('Nutrient Mgt.'!F203,0)","v":0},{"$f":"'Nutrient Mgt.'!D203","v":0},{"$f":"IFERROR(D113*C113,0)","v":0}]
[null,"Conservation Crop Rotation",{"$f":"IFERROR('ONLY CCR'!F138,0)","v":0},{"$f":"'ONLY CCR'!D138","v":0},{"$f":"IFERROR(D114*C114,0)","v":0}]
[null,"Total Increase due to Financial Assistance",null,null,{"$f":"SUM(E111:E114)","v":0}]
[null,"Annual Change in Total Net Income =",null,null,{"$f":"IFERROR(G86+E115,0)","v":0}]
[null,"Annual Change in  Per Acre Net Income =",null,null,{"$f":"IFERROR(E116/'Farm Info'!D31,0)","v":0}]

{"sheet":"Editable PBA","index":8,"n_rows":111,"n_cols":12,"rows_kept":111,"cut":false,"hidden":false,"merged":[[98,1,99,9],[102,1,102,4],[108,1,108,3],[109,1,109,3],[110,1,110,3],[97,1,97,9],[80,1,80,4],[81,1,81,4],[81,6,81,9],[82,1,82,9],[83,1,84,9],[85,1,85,9],[86,1,86,9],[87,1,91,9],[92,1,93,9],[94,1,94,9],[95,1,96,9],[51,6,51,8],[79,1,79,4],[69,6,69,8],[73,1,73,3],[73,6,73,8],[74,1,74,4],[74,6,74,9],[75,1,75,3],[75,6,75,8],[76,1,76,3],[76,6,76,8],[77,1,77,3],[77,6,77,8],[78,1,78,9],[0,1,0,9],[2,1,2,9],[16,1,16,9],[3,1,15,9],[54,6,54,8],[21,1,21,9],[22,1,22,4],[22,6,22,9],[23,1,23,4],[23,6,23,9],[35,1,35,3],[35,6,35,8],[36,1,36,4],[36,6,36,9],[41,6,41,8],[47,6,47,8]]}
[null,"EDITABLE PARTIAL BUDGET ANALYSIS TABLE"]
[]
[null,"ABOUT THIS TAB:"]
[null,"The Partial Budget Analysis tab autopopulates and organizes the effects calculated on the preceeding tabs into four quadrants:  \n     (1) Increase in Income; \n     (2) Decrease in Cost; \n     (3) Decrease in Income; and\n     (4) Increase in Cost\n\nPositive effects are displayed on the left and negative effects on the right.  Effects are sorted automatically into the four quadrants based on their value.  Columns A and K display the effect category from previous tabs assigned to the adjacent cell.   NRCS practice codes are used instead of practice names as follows:  329 represents tillage changes, 340 is Cover Crops, 590 is Nutrient Management, and 328 is Conservation Crop Rotation. The table can house every possible effect from the preceeding tabs.  This means that most of the rows will not be populated.  Totals are summarized at the bottom of the table for the entire Study Area.  These totals are used to calculate the net change in income on a per acre basis and for the Study Area.  The table also calculates the return on investment.  All values are on an annual basis. Suggested footnotes appear at the bottom of the table followed by a summary of financial assistance payments received, if any."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTE:  Farmer Name and Watershed Name are populated using information entered on the Farm Info tab."]
[null,"Farmer Name"]
[null,{"$f":"'Farm Info'!B9","v":0}]
[null,"Watershed Name"]
[null,{"$f":"'Farm Info'!B13","v":0}]
[null,{"$f":"\"Economic Effects of Soil Health Practices on \"& 'Farm Info'!B11& \" (2021)\"","v":"Economic Effects of Soil Health Practices on  (2021)"}]
[null,"Increases in Net Income",null,null,null,null,"Decreases in Net Income"]
[null,"Increase in Income",null,null,null,null,"Decrease in Income"]
[null,"Item","Per Acre","Acres","Total",null,"Item","Per Acre","Acres","Total"]
["329 Yield",{"$f":"IF(Tillage!F141>0,Tillage!B109,\"NA\")","v":"NA"},{"$f":"IFERROR(IF(Tillage!F141>0,Tillage!F141,0),0)","v":0},{"$f":"IF(Tillage!F141>0,SUM(Tillage!C134:F134),0)","v":0},{"$f":"D26*C26","v":0},null,{"$f":"IF(Tillage!F141<0,Tillage!B109,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F141<0,Tillage!F141*-1,0)","v":0},{"$f":"IF(Tillage!F141<0,SUM(Tillage!C134:F134),0)","v":0},{"$f":"I26*H26","v":0},"329 Yield"]
["340 Yield",{"$f":"IF('Cover Crops'!F53>0,'Cover Crops'!B30,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F53>0,'Cover Crops'!F53,0)","v":0},{"$f":"IF('Cover Crops'!F53>0,SUM('Cover Crops'!C46:F46),0)","v":0},{"$f":"D27*C27","v":0},null,{"$f":"IF('Cover Crops'!F53<0,'Cover Crops'!B30,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F53<0,'Cover Crops'!F53*-1,0)","v":0},{"$f":"IF('Cover Crops'!F53<0,SUM('Cover Crops'!C46:F46),0)","v":0},{"$f":"I27*H27","v":0},"340 Yield"]
["340 Graz Y",{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!B169,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!C174,0)","v":0},{"$f":"IF('Cover Crops'!C174>0,'Cover Crops'!C170,0)","v":0},{"$f":"D28*C28","v":0},null,{"$f":"IF('Nutrient Mgt.'!F144<0,'Nutrient Mgt.'!B113,\"NA\")","v":"NA"},{"$f":"IFERROR(IF('Nutrient Mgt.'!F144<0,'Nutrient Mgt.'!F144*-1,0),0)","v":0},{"$f":"IF('Nutrient Mgt.'!F144<0,SUM('Nutrient Mgt.'!C137:F137),0)","v":0},{"$f":"I28*H28","v":0},"590 Yield"]
["340 Graz Y",{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!E167,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!H172,0)","v":0},{"$f":"IF('Cover Crops'!H172>0,'Cover Crops'!H168,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!E46<0,'ONLY CCR'!B24,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!E46<0,'ONLY CCR'!E46*-1,0)","v":0},{"$f":"IF('ONLY CCR'!E46<0,SUM('ONLY CCR'!D39:D42),0)","v":0},{"$f":"I29*H29","v":0},"328 Net Income"]
["340 Graz Y",{"$f":"IF('Cover Crops'!H162>0,'Cover Crops'!E157,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!H162>0,'Cover Crops'!H162,0)","v":0},{"$f":"IF('Cover Crops'!H163>0,'Cover Crops'!H158,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F73<0,'ONLY CCR'!B50,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F73<0,'ONLY CCR'!F73*-1,0)","v":0},{"$f":"IFERROR(IF('ONLY CCR'!F73<0,SUM('ONLY CCR'!C66:F66),0),0)","v":0},{"$f":"I30*H30","v":0},"328 Yield "]
["340 Hay Y",{"$f":"IF('Cover Crops'!C182>0,'Cover Crops'!B182,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C182>0,'Cover Crops'!C182,0)","v":0},{"$f":"IF('Cover Crops'!C180>0,'Cover Crops'!C180,0)","v":0},0,null,{"$f":"IF('Combined Practice Effects'!F32<0,'Combined Practice Effects'!B9,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F32<0,'Combined Practice Effects'!F32*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F32<0,SUM('Combined Practice Effects'!C25:F25),0)","v":0},{"$f":"I31*H31","v":0},"All Practices"]
["590 Yield",{"$f":"IF('Nutrient Mgt.'!F144>0,'Nutrient Mgt.'!B113,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F144>0,'Nutrient Mgt.'!F144,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F144>0,SUM('Nutrient Mgt.'!C137:F137),0)","v":0},0]
["328 Net Income",{"$f":"IF('ONLY CCR'!E46>0,'ONLY CCR'!B24,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!E46>0,'ONLY CCR'!E46,0)","v":0},{"$f":"IF('ONLY CCR'!E46>0,SUM('ONLY CCR'!D39:D42),0)","v":0},{"$f":"D33*C33","v":0}]
["328 Yield",{"$f":"IFERROR(IF('ONLY CCR'!F46>0,'ONLY CCR'!B50,\"NA\"),0)","v":"NA"},{"$f":"IFERROR(IF('ONLY CCR'!F73>0,'ONLY CCR'!F73,0),0)","v":0},{"$f":"IFERROR(IF('ONLY CCR'!F73>0,SUM('ONLY CCR'!C66:F66),0),0)","v":0},0]
["All Practices",{"$f":"IF('Combined Practice Effects'!F32>0,'Combined Practice Effects'!B9,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F32>0,'Combined Practice Effects'!F32,0)","v":0},{"$f":"IF('Combined Practice Effects'!F32>0,SUM('Combined Practice Effects'!C25:F25),0)","v":0},{"$f":"D35*C35","v":0}]
[null,"Total Increased Income",null,null,{"$f":"SUM(E26:E35)","v":0},null,"Total Decreased Income",null,null,{"$f":"SUM(J26:J35)","v":0}]
[null,"Decrease in Cost",null,null,null,null,"Increase in Cost"]
[null,"Item","Per Acre","Acres","Total",null,"Item","Per Acre","Acres","Total"]
["329 Machinery",{"$f":"IF(Tillage!C105<0,Tillage!B96,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C105<0,Tillage!C105*-1,0)","v":0},{"$f":"IF(Tillage!C105<0,Tillage!C23+Tillage!C44+Tillage!C65+Tillage!C86,0)","v":0},{"$f":"D39*C39","v":0},null,{"$f":"IF(Tillage!C105>0,Tillage!B96,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C105>0,Tillage!C105,0)","v":0},{"$f":"IF(Tillage!C105>0,Tillage!C14+Tillage!C35+Tillage!C56+Tillage!C77,0)","v":0},{"$f":"I39*H39","v":0},"329 Machinery"]
["329 Nutrients",{"$f":"IF(Tillage!F164<0,Tillage!B146,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F164<0,Tillage!F164*-1,0)","v":0},{"$f":"IF(Tillage!F164<0,SUM(Tillage!C160:F160),0)","v":0},{"$f":"D40*C40","v":0},null,{"$f":"IF(Tillage!F164>0,Tillage!B146,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F164>0,Tillage!F164,0)","v":0},{"$f":"IF(Tillage!F164>0,SUM(Tillage!C160:F160),0)","v":0},0,"329 Nutrients"]
["329 Pesticides",{"$f":"IF(Tillage!F190<0,Tillage!B168,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F190<0,Tillage!F190*-1,0)","v":0},{"$f":"IF(Tillage!F190<0,SUM(Tillage!C186:F186),0)","v":0},0,null,{"$f":"IF(Tillage!F190>0,Tillage!B168,\"NA\")","v":"NA"},{"$f":"IF(Tillage!F190>0,Tillage!F190,0)","v":0},{"$f":"IF(Tillage!F190>0,SUM(Tillage!C186:F186),0)","v":0},0,"329 Pesticides"]
["329 Erosion",{"$f":"IF(Tillage!C215>0,Tillage!B193,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C215>0,Tillage!C215,0)","v":0},{"$f":"IF(Tillage!C215>0,'Farm Info'!D31,0)","v":0},0,null,{"$f":"IF('Farm Info'!C49>0,'Farm Info'!B49,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C49>0,'Farm Info'!D49,0)","v":0},"329 Education"]
["340 Nutrients",{"$f":"IF('Cover Crops'!F72<0,'Cover Crops'!$B$58,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F72<0,'Cover Crops'!F72*-1,0)","v":0},{"$f":"IF('Cover Crops'!F72<0,SUM('Cover Crops'!C68:F68),0)","v":0},0,null,{"$f":"IF('Cover Crops'!F28>0,'Cover Crops'!B13,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F28>0,'Cover Crops'!F28,0)","v":0},{"$f":"IF('Cover Crops'!F28>0,SUM('Cover Crops'!C19:F19),0)","v":0},0,"340 Costs"]
["340 Pesticides",{"$f":"IF('Cover Crops'!F99<0,'Cover Crops'!$B76,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F99<0,'Cover Crops'!F99*-1,0)","v":0},{"$f":"IF('Cover Crops'!F99<0,SUM('Cover Crops'!C95:F95),0)","v":0},0,null,{"$f":"IF('Cover Crops'!F72>0,'Cover Crops'!$B$58,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F72>0,'Cover Crops'!F72,0)","v":0},{"$f":"IF('Cover Crops'!F72>0,SUM('Cover Crops'!C68:F68),0)","v":0},0,"340 Nutrients"]
["340 Erosion",{"$f":"IF('Cover Crops'!C125>0,'Cover Crops'!B102,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C125>0,'Cover Crops'!C125,0)","v":0},{"$f":"IF('Cover Crops'!C125>0,'Farm Info'!D31,0)","v":0},0,null,{"$f":"IF('Cover Crops'!F99>0,'Cover Crops'!$B76,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!F99>0,'Cover Crops'!F99,0)","v":0},{"$f":"IF('Cover Crops'!F99>0,SUM('Cover Crops'!C95:F95),0)","v":0},0,"340 Pesticides"]
["590 Machinery",{"$f":"IF('Nutrient Mgt.'!C109<0,'Nutrient Mgt.'!B100,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C109<0,'Nutrient Mgt.'!C109*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C109<0,('Nutrient Mgt.'!C26+'Nutrient Mgt.'!C45+'Nutrient Mgt.'!C64+'Nutrient Mgt.'!C83),0)","v":0},0,null,{"$f":"IF('Cover Crops'!C163>0,'Cover Crops'!B166,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C166>0,'Cover Crops'!C166,0)","v":0},{"$f":"IF('Cover Crops'!C166>0,('Cover Crops'!C170+'Cover Crops'!H158+'Cover Crops'!H168),0)","v":0},0,"340 Grazing Infrastructure"]
["590 Nutrients",{"$f":"IF('Nutrient Mgt.'!F168<0,'Nutrient Mgt.'!B149,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F168<0,'Nutrient Mgt.'!F168*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F168<0,SUM('Nutrient Mgt.'!C164:F164),0)","v":0},0,null,{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!B183,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!C183,0)","v":0},{"$f":"IF('Cover Crops'!C183>0,'Cover Crops'!C180,0)","v":0},0,"340 Haying Harvest"]
["590 Pesticides",{"$f":"IF('Nutrient Mgt.'!F194<0,'Nutrient Mgt.'!B172,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F194<0,'Nutrient Mgt.'!F194*-1,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F194<0,SUM('Nutrient Mgt.'!C190:F190),0)","v":0},0,null,{"$f":"IF('Farm Info'!C50>0,'Farm Info'!B50,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C50>0,'Farm Info'!D50,0)","v":0},"340 Education"]
["328 Nutrients",{"$f":"IF('ONLY CCR'!F92<0,'ONLY CCR'!B78,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F92<0,'ONLY CCR'!F92*-1,0)","v":0},{"$f":"IF('ONLY CCR'!F92<0,SUM('ONLY CCR'!C88:F88),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C109>0,'Nutrient Mgt.'!B100,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C109>0,'Nutrient Mgt.'!C109,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C109>0,('Nutrient Mgt.'!C26+'Nutrient Mgt.'!C45+'Nutrient Mgt.'!C64+'Nutrient Mgt.'!C83),0)","v":0},0,"590 Machinery"]
["328 Pesticides",{"$f":"IF('ONLY CCR'!F113<0,'ONLY CCR'!B96,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F113<0,'ONLY CCR'!F113*-1,0)","v":0},{"$f":"IF('ONLY CCR'!F113<0,SUM('ONLY CCR'!C109:F109),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!F168>0,'Nutrient Mgt.'!B149,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F168>0,'Nutrient Mgt.'!F168,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F168>0,SUM('Nutrient Mgt.'!C164:F164),0)","v":0},{"$f":"I50*H50","v":0},"590 Nutrients"]
["328 Erosion",{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!B116,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!C127,0)","v":0},{"$f":"IF('ONLY CCR'!C127>0,'ONLY CCR'!C37,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!F194>0,'Nutrient Mgt.'!B172,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!F194>0,'Nutrient Mgt.'!F194,0)","v":0},{"$f":"IF('Nutrient Mgt.'!F194>0,SUM('Nutrient Mgt.'!C190:F190),0)","v":0},{"$f":"I51*H51","v":0},"590 Pesticides"]
["329 PosEff 1",{"$f":"IF(Tillage!C236>0,Tillage!B236,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C236>0,Tillage!C236,0)","v":0},{"$f":"IF(Tillage!C236>0,Tillage!D236,0)","v":0},0,null,{"$f":"IF('Farm Info'!C51>0,'Farm Info'!B51,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C51>0,'Farm Info'!D51, 0)","v":0},"590 Education"]
["329 PosEff2",{"$f":"IF(Tillage!C237>0,Tillage!B237,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C237>0,Tillage!C237,0)","v":0},{"$f":"IF(Tillage!C237>0,Tillage!D237,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F92>0,'ONLY CCR'!B78,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F92>0,'ONLY CCR'!F92,0)","v":0},{"$f":"IF('ONLY CCR'!F92>0,SUM('ONLY CCR'!C88:F88),0)","v":0},{"$f":"I53*H53","v":0},"328 Nutrients"]
["329 PosEff3",{"$f":"IF(Tillage!C238>0,Tillage!B238,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C238>0,Tillage!C238,0)","v":0},{"$f":"IF(Tillage!C238>0,Tillage!D238,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!F113>0,'ONLY CCR'!B96,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!F113>0,'ONLY CCR'!F113,0)","v":0},{"$f":"IF('ONLY CCR'!F113>0,SUM('ONLY CCR'!C109:F109),0)","v":0},0,"328 Pesticides"]
["340PosEff1",{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!B143,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!C143,0)","v":0},{"$f":"IF('Cover Crops'!C143>0,'Cover Crops'!D143,0)","v":0},0,null,{"$f":"IF('Farm Info'!C52>0,'Farm Info'!B52,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C52>0,'Farm Info'!D52,0)","v":0},"328 Education"]
["340PosEff2",{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!B144,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!C144,0)","v":0},{"$f":"IF('Cover Crops'!C144>0,'Cover Crops'!D144,0)","v":0},0,null,{"$f":"IF(Tillage!C242>0,Tillage!B242,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C242>0,Tillage!C242,0)","v":0},{"$f":"IF(Tillage!C242>0,Tillage!D242,0)","v":0},{"$f":"I56*H56","v":0},"329 NegEff1"]
["340PosEff3",{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!B145,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!C145,0)","v":0},{"$f":"IF('Cover Crops'!C145>0,'Cover Crops'!D145,0)","v":0},0,null,{"$f":"IF(Tillage!C243>0,Tillage!B243,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C243>0,Tillage!C243,0)","v":0},{"$f":"IF(Tillage!C243>0,Tillage!D243,0)","v":0},{"$f":"I57*H57","v":0},"329 NegEff2"]
["590PosEff1",{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!B213,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!C213,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C213>0,'Nutrient Mgt.'!D213,0)","v":0},0,null,{"$f":"IF(Tillage!C244>0,Tillage!B244,\"NA\")","v":"NA"},{"$f":"IF(Tillage!C244>0,Tillage!C244,0)","v":0},{"$f":"IF(Tillage!C244>0,Tillage!D244,0)","v":0},0,"329 NegEff3"]
["590PosEff2",{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!B214,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!C214,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C214>0,'Nutrient Mgt.'!D214,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!B149,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!C149,0)","v":0},{"$f":"IF('Cover Crops'!C149>0,'Cover Crops'!D149,0)","v":0},0,"340NegEff1"]
["590PosEff3",{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!B215,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!C215,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C215>0,'Nutrient Mgt.'!D215,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!B150,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!C150,0)","v":0},{"$f":"IF('Cover Crops'!C150>0,'Cover Crops'!D150,0)","v":0},0,"340NegEff2"]
["328PosEff1",{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!B145,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!C145,0)","v":0},{"$f":"IF('ONLY CCR'!C145>0,'ONLY CCR'!D145,0)","v":0},0,null,{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!B151,\"NA\")","v":"NA"},{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!C151,0)","v":0},{"$f":"IF('Cover Crops'!C151>0,'Cover Crops'!D151,0)","v":0},0,"340NegEff3"]
["328PosEff2",{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!B146,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!C146,0)","v":0},{"$f":"IF('ONLY CCR'!C146>0,'ONLY CCR'!D146,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!B219,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!C219,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C219>0,'Nutrient Mgt.'!D219,0)","v":0},0,"590NegEff1"]
["328PosEff3",{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!B147,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!C147,0)","v":0},{"$f":"IF('ONLY CCR'!C147>0,'ONLY CCR'!D147,0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!B220,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!C220,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C220>0,'Nutrient Mgt.'!D220,0)","v":0},0,"590NegEff2"]
["All Practices NPK",{"$f":"IF('Combined Practice Effects'!F51<0,'Combined Practice Effects'!B37,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F51<0,'Combined Practice Effects'!F51*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F51<0,SUM('Combined Practice Effects'!C47:F47),0)","v":0},0,null,{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!B221,\"NA\")","v":"NA"},{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!C221,0)","v":0},{"$f":"IF('Nutrient Mgt.'!C221>0,'Nutrient Mgt.'!D221,0)","v":0},0,"590NegEff3"]
["All Practices Pesticides",{"$f":"IF('Combined Practice Effects'!F72<0,'Combined Practice Effects'!B55,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F72<0,'Combined Practice Effects'!F72*-1,0)","v":0},{"$f":"IF('Combined Practice Effects'!F72<0,SUM('Combined Practice Effects'!C68:F68),0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!B151,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!C151,0)","v":0},{"$f":"IF('ONLY CCR'!C151>0,'ONLY CCR'!D151,0)","v":0},0,"328NegEff1"]
["All Practices Erosion",{"$f":"IF('Combined Practice Effects'!C86>0,'Combined Practice Effects'!B75,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C86>0,'Combined Practice Effects'!C86,0)","v":0},{"$f":"IF('Combined Practice Effects'!C86>0,'Farm Info'!D31,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!B152,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!C152,0)","v":0},{"$f":"IF('ONLY CCR'!C152>0,'ONLY CCR'!D152,0)","v":0},0,"328NegEff2"]
["All PracticesPosEff1",{"$f":"IF('Combined Practice Effects'!E95>0,'Combined Practice Effects'!B95,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C95>0,'Combined Practice Effects'!C95,0)","v":0},{"$f":"IF('Combined Practice Effects'!C95>0,'Combined Practice Effects'!D95,0)","v":0},0,null,{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!B153,\"NA\")","v":"NA"},{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!C153,0)","v":0},{"$f":"IF('ONLY CCR'!C153>0,'ONLY CCR'!D153,0)","v":0},0,"328NegEff3"]
["All PracticesPosEff2",{"$f":"IF('Combined Practice Effects'!E96>0,'Combined Practice Effects'!B96,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C96>0,'Combined Practice Effects'!C96,0)","v":0},{"$f":"IF('Combined Practice Effects'!C96>0,'Combined Practice Effects'!D96,0)","v":0},0,null,{"$f":"IF('Combined Practice Effects'!F51>0,'Combined Practice Effects'!B37,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F51>0,'Combined Practice Effects'!F51,0)","v":0},{"$f":"IF('Combined Practice Effects'!F51>0,SUM('Combined Practice Effects'!C47:F47),0)","v":0},0,"All Practices NPK"]
["All PracticesPosEff3",{"$f":"IF('Combined Practice Effects'!E97>0,'Combined Practice Effects'!B97,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C97>0,'Combined Practice Effects'!C97,0)","v":0},{"$f":"IF('Combined Practice Effects'!C97>0,'Combined Practice Effects'!D97,0)","v":0},0,null,{"$f":"IF('Combined Practice Effects'!F72>0,'Combined Practice Effects'!B55,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!F72>0,'Combined Practice Effects'!F72,0)","v":0},{"$f":"IF('Combined Practice Effects'!F72>0,SUM('Combined Practice Effects'!C68:F68),0)","v":0},0,"All Practices Pesticides"]
[null,null,null,null,null,null,{"$f":"IF('Farm Info'!C54>0,'Farm Info'!B54,\"NA\")","v":"NA"},null,null,{"$f":"IF('Farm Info'!C54>0,'Farm Info'!D54, 0)","v":0},"All Practices Learning Activities"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!B100,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!C100,0)","v":0},{"$f":"IF('Combined Practice Effects'!C100>0,'Combined Practice Effects'!D100,0)","v":0},{"$f":"I71*H71","v":0},"All PracticesNegEff1"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!B101,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!C101,0)","v":0},{"$f":"IF('Combined Practice Effects'!C101>0,'Combined Practice Effects'!D101,0)","v":0},{"$f":"I72*H72","v":0},"All PracticesNegEff2"]
[null,null,null,null,null,null,{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!B102,\"NA\")","v":"NA"},{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!C102,0)","v":0},{"$f":"IF('Combined Practice Effects'!C102>0,'Combined Practice Effects'!D102,0)","v":0},0,"All PracticesNegEff3"]
[null,"Total Decreased Cost",null,null,{"$f":"SUM(E39:E72)","v":0},null,"Total Increased Cost",null,null,{"$f":"SUM(J39:J73)","v":0}]
[]
[null,"Annual Total Increased Net Income",null,null,{"$f":"IFERROR(E74+E36,0)","v":0},null,"Annual Total Decreased Net Income",null,null,{"$f":"IFERROR(J74+J36,0)","v":0}]
[null,"Total Acres in this Study Area",null,null,{"$f":"'Farm Info'!D31","v":0},null,"Total Acres in this Study Area",null,null,{"$f":"'Farm Info'!D31","v":0}]
[null,"Annual Per Acre Increased Net Income",null,null,{"$f":"IFERROR(ROUND(E76/E77,0),0)","v":0},null,"Annual Per Acre Decreased Net Income",null,null,{"$f":"IFERROR(ROUND(J76/J77,0),0)","v":0}]
[]
[null,"Annual Change in Total Net Income",null,null,null,"=",{"$f":"IFERROR(E76-J76,0)","v":0}]
[null,"Annual Change in Per Acre Net Income",null,null,null,"=",{"$f":"IFERROR(G80/E77,0)","v":0}]
[null,"Return on Investment",null,null,null,"=",{"$f":"IFERROR(G80/J76,0)","v":0}]
[null,"Footnotes:",null,null,null,null,null,null,null,null,null,"Notes to authors about editing footnotes:"]
[null,"This table represents estimated average costs and benefits attributed to adopting [list SH practices] over the entire study area (### acres) ,where [list crops] are grown, as reported by the farmer. ",null,null,null,null,null,null,null,null,null,"Update with featured farmer's information."]
[]
[null,"All values are in 2021 dollars, unless provided by the farmer."]
[null,"Prices are stated as per acre values for items that vary by area. Prices such as learning costs, which don't vary by area, are only given as total costs.",null,null,null,null,null,null,null,null,null,"Optional footnote (if applicable)."]
[null,"2021 standard prices (if used) in the analysis:  Barley: $5.15/bu, Corn Grain: $5.45/bu, Corn Silage: $49.05/ton, Grain Sorghum: $9.75/cwt, Hay: $186/ton, Oats: $4/bu, Soybeans: $13/bu, Wheat: $7.30/bu (Source:  USDA NASS, Crop Values: 2021 Summary).  Nitrogen:  $.72/Lb, Phosphate:  $.62/Lb, Potash:  $.56/Lb (Source:  Iowa State University Extension and Outreach, Ag Decision Maker: Estimated Costs of Crop Production in Iowa, 2022). Net Income (value of production minus operating costs) values for Barley: -$11/ac, Corn Grain: $429/ac, Grain Sorghum: $136/ac, Oats: $11/ac, Soybeans: $325/ac, Wheat: $36/ac (USDA ERS, May 2022, Commodity Costs and Returns); Net income for Hay: $152/ac (calculated from various sources).",null,null,null,null,null,null,null,null,null,"Only include crop price if there was a change in yield.  Only include fertilizer prices if there was a change in fertilizer use and delete types of fertilizer that did not change."]
[]
[]
[]
[]
[null,"Value of decreased erosion ($1.18/ton) is based on estimated N & P content of the soil (2.32 lbs N/ton, 1 lb P/ton) and fertilizer prices (USDA NRCS, May 2010, Final Benefit-Cost Analysis for the EQIP) and [insert farmer name, e.g. Scotty's] estimate of reduced mechanical erosion repair costs.",null,null,null,null,null,null,null,null,null,"Only include if there was a change in erosion rate, then edit appropriately depending on if farmer provided an annual savings in mechanical erosion repair cost."]
[]
[null,"Return on Investment is the ratio of Annual Total Change in Net Income to Annual Total Decreased Net Income, as a percent."]
[null,"For information about: (1) study methodology, see farmland.org/soilhealthcasestudies; (2) USDA's Nutrient Tracking Tool, see ntt.tiaer.tarleton.edu/welcomes/; (3) USDA's COMET-Farm Tool, see comet-farm.com.",null,null,null,null,null,null,null,null,null,"If NTT or COMET results are not featured in the text, remember to remove the NTT or COMET footnote."]
[]
[null,"This material is based on work supported by USDA NRCS CIG grant NR183A750008G008."]
[null,"[insert grower's first name] received [insert amount, e.g., $/ac/yr or $/yr] through the [insert name of program (years active)]. This is not included in the analysis because cost-share is temporary and not received by all.",null,null,null,null,null,null,null,null,null,"Only include if farmer received financial assistance.  Complete missing information based on farmer's unique circumstances. "]
[]
[]
[null,"Impact of Financial Assistance Payments"]
[null,"Increase in Income"]
[null,"Soil Health Practice","Per Acre","Acres","Total"]
[null,"Tillage (Residue Management)",{"$f":"IFERROR(Tillage!#REF!,0)","v":0},{"$f":"Tillage!D226","v":0},{"$f":"IFERROR(D105*C105,0)","v":0}]
[null,"Cover Crop",{"$f":"IFERROR('Cover Crops'!F136,0)","v":0},{"$f":"'Cover Crops'!D136","v":0},{"$f":"IFERROR(D106*C106,0)","v":0}]
[null,"Nutrient Management",{"$f":"IFERROR('Nutrient Mgt.'!F203,0)","v":0},{"$f":"'Nutrient Mgt.'!D203","v":0},{"$f":"IFERROR(D107*C107,0)","v":0}]
[null,"Conservation Crop Rotation",{"$f":"IFERROR('ONLY CCR'!F138,0)","v":0},{"$f":"'ONLY CCR'!D138","v":0},{"$f":"IFERROR(D108*C108,0)","v":0}]
[null,"Total Increase due to Financial Assistance",null,null,{"$f":"SUM(E105:E108)","v":0}]
[null,"Annual Change in Total Net Income =",null,null,{"$f":"IFERROR(G80+E109,0)","v":0}]
[null,"Annual Change in  Per Acre Net Income =",null,null,{"$f":"IFERROR(E110/'Farm Info'!D31,0)","v":0}]

{"sheet":"Prices","index":9,"n_rows":134,"n_cols":7,"rows_kept":134,"cut":false,"hidden":false,"merged":[[131,1,131,4],[122,4,127,4],[121,1,121,4],[132,1,132,4],[128,1,128,4],[133,1,133,4],[62,1,62,2],[63,1,63,2],[64,1,64,2],[76,1,76,5],[66,1,66,5],[103,1,103,3],[108,1,108,3],[129,1,129,4],[130,1,130,4],[93,1,93,5],[97,1,97,4],[110,1,110,3],[98,1,98,5],[78,1,78,5],[77,1,77,5],[0,1,0,6],[33,1,33,5],[47,1,47,5],[49,1,49,3],[3,0,6,6],[112,1,112,4],[80,1,80,6],[99,1,99,5],[100,1,100,5],[101,1,101,5],[109,1,109,3],[90,1,90,6],[91,1,91,6],[56,1,56,2],[61,1,61,2],[8,1,8,5],[9,1,9,5],[23,1,23,5],[25,1,25,3],[32,1,32,5]]}
[null,"PRICES"]
[]
["ABOUT THIS TAB:"]
["This tab is the source for price information used throughout the workbook.  The prices and costs appearing below are linked to the preceeding tabs to calculate costs and savings as data is entered.  Consequently, changes to values on this tab will automatically update the costs or savings on the Farm Info, Soil Health Practice, and Partial Budget Analysis tabs of the workbook."]
[]
[]
[]
[]
[null,"Prices Paid Index (PPI): All Items"]
[null,"United States: 2011=100"]
[null,"Month",2018,2019,2020,2021]
[null,"January",108.6,110.8,111,113.4]
[null,"February",109.5,110.7,110.6,114.8]
[null,"March",109.7,110.9,109.7,116]
[null,"April ",109.3,111.4,108.5,117]
[null,"May",109.7,110.8,108.6,117.9]
[null,"June",109.4,110.3,108.8,119.2]
[null,"July",109.5,110.4,109.5,120.4]
[null,"August",109.6,109.6,109.8,121]
[null,"September",109.5,109.2,110.3,121.3]
[null,"October",110,109.9,111.2,122.7]
[null,"November ",110.1,110,112,123.7]
[null,"December",110.3,110,112.8,125.2]
[null,"USDA NASS. (Ongoing). Prices Paid: Indexes for All Items and Production Items by Month - United States. Retrieved September 22, 2022, from https://www.nass.usda.gov/Charts_and_Maps/Agricultural_Prices/index.php"]
[]
[null,"Average Prices Paid Index (PPI): All Items"]
[null,"Year","Average PPI (calculated)","% Change in PPI from previous year (calculated)"]
[null,2018,{"$f":"AVERAGE(C13:C24)","v":109.69090909090909}]
[null,2019,{"$f":"AVERAGE(D13:D24)","v":110.2909090909091},{"$f":"C29/C28","v":1.0054699154649429}]
[null,2020,{"$f":"AVERAGE(E13:E24)","v":110.16363636363636},{"$f":"C30/C29","v":0.99884602703593794}]
[null,2021,{"$f":"AVERAGE(F13:F24)","v":119.92727272727274},{"$f":"C31/C30","v":1.0886284865489355}]
[]
[null,"Prices Received Index (PRI): Crop Production"]
[null,"United States: 2011=100"]
[null,"Month",2018,2019,2020,2021]
[null,"January",78.400000000000006,78.5,82.5,88.4]
[null,"February",86.3,84.8,86.4,97.2]
[null,"March",87.7,87.5,87.2,98.4]
[null,"April ",88.4,85.5,86.1,105.2]
[null,"May",88.7,84.7,86.5,106.1]
[null,"June",89.8,89.7,89.2,107.5]
[null,"July",86.5,89,88.3,106.8]
[null,"August",89.3,88.9,90,110]
[null,"September",87.8,88.3,93.2,108.5]
[null,"October",80,83,87.8,106.1]
[null,"November ",83.9,84.9,91.7,107.4]
[null,"December",87.4,85.9,91.3,106]
[null,"USDA NASS. (Ongoing). Prices Received: Indexes for Ag, Crop, and Livestock Production by Month - United States. Retrieved September 22, 2022, from https://www.nass.usda.gov/Charts_and_Maps/Agricultural_Prices/index.php"]
[]
[null,"Average Prices Received Index (PRI): Crop Production"]
[null,"Year","Average PRI (calculated)","% Change in PRI from previous year (calculated)"]
[null,2018,{"$f":"AVERAGE(C36:C47)","v":86.183333333333323}]
[null,2019,{"$f":"AVERAGE(D36:D47)","v":85.891666666666666},{"$f":"C53/C52","v":0.99661574163604727}]
[null,2020,{"$f":"AVERAGE(E36:E47)","v":88.350000000000009},{"$f":"C54/C53","v":1.0286213253128942}]
[null,2021,{"$f":"AVERAGE(F36:F47)","v":103.96666666666665},{"$f":"C55/C54","v":1.1767591020562156}]
[]
[null,"Labor Rate - Farm Manager1,2,3"]
[null,"Year","$/hr"]
[null,2019,25.25]
[null,2020,26.16]
[null,2021,26.18]
[null,"1 U.S. Bureau of Labor Statistics. (2020, March 31). 45-1011 First-Line Supervisors of Farming, Fishing, and Forestry Workers. Occupational Employment and Wage Statistics, May 2019. Retrieved February 17, 2022, from https://www.bls.gov/oes/2019/may/oes451011.htm"]
[null,"2 U.S. Bureau of Labor Statistics. (2021, March 31). 45-1011 First-Line Supervisors of Farming, Fishing, and Forestry Workers. Occupational Employment and Wage Statistics, May 2020. Retrieved February 17, 2022, from https://www.bls.gov/oes/current/oes451011.htm"]
[null,"3 U.S. Bureau of Labor Statistics. (2022, March 31). 45-1011 First-Line Supervisors of Farming, Fishing, and Forestry Workers. Occupational Employment and Wage Statistics, May 2021. Retrieved April 6, 2022, from https://www.bls.gov/oes/current/oes451011.htm"]
[null,"Note: BLS Occupational Employment and Wages Statistic updates will be announced on their homepage: https://www.bls.gov/oes/home.htm (Annual update on March 31)"]
[]
[null,"National Average Row Crop Prices"]
[null,"Crop","Unit","2019 Prices1 ($/unit)","2020 Prices1 ($/unit)","2021 Prices1 ($/unit)*"]
[null,"Barley","Bushel",4.6900000000000004,4.75,5.15]
[null,"Corn Grain","Bushel",3.56,4.53,5.45]
[null,"Corn Silage","Ton",{"$f":"D70*9","v":32.04},{"$f":"E70*9","v":40.770000000000003},{"$f":"F70*9","v":49.050000000000004}]
[null,"Grain Sorghum (milo)","cwt",5.96,9,9.75]
[null,"Hay","Ton",163,156,186]
[null,"Oats","Bushel",2.82,2.77,4]
[null,"Soybeans","Bushel",8.57,10.8,13]
[null,"Wheat","Bushel",4.58,5.05,7.3]
[null,"1 USDA NASS. (February 2022). Crop Values: 2021 Summary. Retrieved on February 28, 2022 from https://usda.library.cornell.edu/concern/publications/k35694332"]
[null,"*Corn Silage price is nine times Corn Grain price based on guidance from Michigan State University Extension. Retrieved on May 9, 2022 from https://www.canr.msu.edu/news/pricing-standing-corn-silage"]
[null,"Note: Used \"Corn for grain\", \"Hay all\", \"Soybean for beans\", \"Wheat all\", \"Barley\", \"Oats\", \"Sorghum for grain\" from Crop Values report."]
[]
[null,"Organic National Average Row Crop Prices"]
[null,"Crop","Unit","Quantity","Dollars","2019 Prices1","2021 Prices*"]
[null,"Barley","Bushels",3405339,27794499,{"$f":"E83/D83","v":8.1620358501752683},{"$f":"F83*($C$55/$C$53)","v":9.879650651672323}]
[null,"Corn Grain","Bushels",32269911,278156872,{"$f":"E84/D84","v":8.6196975256609782},{"$f":"F84*($C$55/$C$53)","v":10.433622424580028}]
[null,"Corn Silage","Tons",284421,18531684,{"$f":"E85/D85","v":65.155821827502194},{"$f":"F85*($C$55/$C$53)","v":78.867180859601945}]
[null,"Grain Sorghum (milo)","Bushels",322225,2332306,{"$f":"E86/D86","v":7.2381286368220961},{"$f":"F86*($C$55/$C$53)","v":8.7613168597062643}]
[null,"Hay","Tons",1210531,191993604,{"$f":"E87/D87","v":158.6027982761284},{"$f":"F87*($C$55/$C$53)","v":191.97909297496631}]
[null,"Oats","Bushels",2555539,13522613,{"$f":"E88/D88","v":5.2914915405321539},{"$f":"F88*($C$55/$C$53)","v":6.4050304123099977}]
[null,"Soybeans","Bushels",5404343,108998945,20.168768895682604,24.413074681530624]
[null,"Wheat","Bushels",16969610,149113177,{"$f":"E90/D90","v":8.7870715355273337},10.636218538589212]
[null,"1 USDA NASS. (2020, October 22). Table 13. Certified Organic Field Crops and Hay Harvested and Value of Sales: 2019 Organic Survey. Retrieved February 28, 2022, from https://www.nass.usda.gov/Surveys/Guide_to_NASS_Surveys/Organic_Production/index.php"]
[null,"2 The 2021 price was calculated using the Prices Received Index; USDA NASS will release their next national organic prices report in 2023."]
[]
[null,"Calculated Value ($/ton) of Reduced Nutrient Loss with Soil Erosion Reduction"]
[null,"Fertilizer","lbs/ton of soil1 ","2020 Price ($/lb)2","2021 Price ($/lb)3","$/ton"]
[null,"Nitrogen",2.3199999999999998,0.34,0.72,{"$f":"E96*C96","v":1.6703999999999999}]
[null,"Phosphorus",1,0.39,0.62,{"$f":"E97*C97","v":0.62}]
[null,"Total Combined Benefit",null,null,null,{"$f":"SUM(F96:F97)","v":2.2904}]
[null,"1 USDA NRCS. (May 24, 2010). Final Benefit-Cost Analysis for the Environmental Quality Incentives Program (EQIP). Retrieved on February 22, 2022, from https://www.blogs.nrcs.usda.gov/Internet/FSE_DOCUMENTS/16/nrcs143_007976.pdf "]
[null,"Note: Following page 23 instructions in the above referece, we estimate the amount of Nitrogen and Phosphorous per ton eroded soil. They assume topsoil contains 40 lbs of organic matter of which 23.2 lbs is carbon. With an average carbon-nitrogren ratio of 10 to 1, each ton of soil eroded contains 2.32 lbs of nitrogen. The soil also contains 0.05% phosphorus, or one pound per ton of soil. "]
[null,"2  Iowa State University Extension and outreach. (January 2021). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2021 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"3 Iowa State University Extension and Outreach. (January 2022). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[]
[null,"Fertilizer Prices by Element"]
[null,"Fertilizer Element","2020 Price ($/lb)1","2021 Price ($/lb)2"]
[null,"Nitrogen",0.34,0.72]
[null,"Phosphate",0.39,0.62]
[null,"Potash",0.3,0.56000000000000005]
[null,"1  Iowa State University Extension and Outreach. (January 2021). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2021 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"2 Iowa State University Extension and Outreach. (January 2022). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"Note: Nitrogen price is the average of  anhydrous ammonia, Urea, and UAN prices. Phosphorus price is for phosphate. Potassium price for potash. "]
[]
[null,"Net Income for Conservation Crop Rotation*"]
[null,"Crop","Unit","2020 \nNet Income1","2021 \nNet Income2"]
[null,"Barley","$/Ac",62.44,-11.23]
[null,"Corn Grain","$/Ac",154.25,428.82]
[null,"Grain Sorghum (Milo)","$/Ac",71.63,136.47]
[null,"Hay","$/Ac","--",{"$f":"IFERROR((((D124/D123)+$D125)*-1+D126),0)","v":0}]
[null,"Oats","$/Ac",-23.65,11.01]
[null,"Soybeans","$/Ac",208.97,324.92]
[null,"Wheat","$/Ac",-1.06,35.630000000000003]
[]
[null,"Years of Hay","Years",{"$f":"IFERROR(VLOOKUP(B118,'Farm Info'!B20:C23,2,TRUE),0)","v":0}]
[null,"Hay Establishment Variable Costs2","$/Ac",168.6]
[null,"Hay Maintenance & Harvest Variable Costs2","$/Ac",123.57]
[null,"Hay Revenue (calculated)","$/Ac",{"$f":"D127*D128","v":444.54}]
[null,"National Average Hay Yield3","Tons",2.39]
[null,"National Average Hay Price4","$/Ac",186]
[null,"*Net Income values are the value of production minus operating costs, hired labor, opportunity cost of unpaid labor, and capital recovery of machinery and equipment. See \"Net Income Values by Crop\" tab for further explanation."]
[null,"1 USDA Economic Research Service. (May 2, 2022). Commodity Costs and Returns: Recent Costs and Returns. Retrieved on June 17, 2022 from https://www.ers.usda.gov/data-products/commodity-costs-and-returns/ "]
[null,"2 Iowa State University Extension and Outreach. (January 2022). Ag Decision Maker: Estimated Costs of Crop Production in Iowa (File A1-20). Retrieved on February 22, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a1-20.html"]
[null,"3 USDA NASS. QuickStats: Statistics by Subject: Hay - Yield, Measured in Tons/Acre, National Average 2010-2021. Retrieved on March 2, 2022 from https://quickstats.nass.usda.gov/"]
[null,"4 USDA NASS. (February 2022). Crop Values: 2021 Summary. Retrieved on February 28, 2022 from https://usda.library.cornell.edu/concern/publications/k35694332"]
[null,"Note: Hay establishment, maintenance, and harvest variable costs are from the \"Oats and Hay Production - Seeding Year Costs\" budget in reference 2. Specifically, Hay Establishment Variable Costs is Alfalfa Seeded with Herbicide: Establishment Costs: Total Establishment Costs, Variable in the budget; and Hay Maintenance & Harvest Variable Costs is Alfalfa Seeded with Herbicide: Annual Costs: Total Fertilizer and Total Harvest Cost, Variable in the budget."]

{"sheet":"Machinery Costs","index":10,"n_rows":142,"n_cols":6,"rows_kept":142,"cut":false,"hidden":false,"merged":[[141,1,141,5],[0,0,0,5],[1,1,1,5],[2,0,2,5],[17,1,17,5],[3,0,15,5],[118,1,118,5],[138,1,138,5],[139,1,139,5],[140,1,140,5]]}
["MACHINERY COSTS"]
[]
["ABOUT THIS TAB:"]
["This tab is the source for machinery costs used on the \"Tillage\" and \"Nutrient Mgt.\" tabs.  This tab contains machinery costs expressed on a per acre basis (with the exception of manure application costs which are either in $/gal or $/hr).  Machinery costs include overhead (depreciation, interest, insurance, housing, and repair charges), fuel and lubrication charges, and labor costs for both the tractor and the implement it is pulling.  These costs are used to calculate changes in either establishment costs due to a change in tillage (on the \"Tillage\" tab) or changes in fertilizer application costs (on the \"Nutrient Mgt.\" tab).  Nearly all costs shown below are from the University of Illinois Farmdoc website.  The fertilizer application costs are from the Iowa State Custom Rate Survey as they were not available from the University of Illinois.  We chose the University of Illinois as a source for machinery costs because their dataset appeared to be the most comprehensive.  Because these costs are from the Midwest, they are most appropriate for use in that region. AFT has used these machinery costs for farms outside the Midwest -- using national prices or costs to avoid biasing the results in cases where the farmer's prices may not be representative of typical prices.  Users should evaluate the costs shown for relevancy in their area and make adjustments as needed, being careful to document all changes.\n\nNote: If a user needs to add their own equipment and per acre cost, you can add to this list as needed in the clearly identified cells with instructions (rows 115-119 & 136-140), but we encourage using published prices as those include depreciation, labor, fuel, interest, storage, insurance, etc. Most farmers will undervalue their per acre machinery costs. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tillage, Fitting and Planting Machinery Costs1"]
[null,null,null,null,2019,2021]
[null,"Item","Source","Tractor HP","($/Acre)","($/Acre)"]
[null,"Air seeder, 28 ft.","Univ. Illinois",285,20.3,21.5]
[null,"Air seeder, 36 ft.","Univ. Illinois",285,18,19.3]
[null,"Air seeder, 44 ft.","Univ. Illinois",310,16.8,18.100000000000001]
[null,"Broadcast seeding, 20 ft.","Univ. Illinois",85,8.9,9.1]
["*","Chisel Plow, 12 ft","Univ. Illinois",140,17.100000000000001,{"$f":"E25*(Prices!C$31/Prices!C$29)","v":18.594065281899113}]
["*","Chisel Plow, 15 ft","Univ. Illinois",155,14.5,{"$f":"E26*(Prices!C$31/Prices!C$29)","v":15.766897461259481}]
[null,"Chisel Plow, 21 ft","Univ. Illinois",205,16,15.7]
[null,"Chisel Plow, 23 ft","Univ. Illinois",225,17.399999999999999,15.7]
[null,"Chisel Plow, 27 ft.","Univ. Illinois",260,15.9,15.8]
[null,"Chisel Plow, 30 ft.","Univ. Illinois",285,15.1,14.9]
[null,"Chisel Plow, 35 ft.","Univ. Illinois",310,12.7,13.6]
[null,"Chisel Plow, 40 ft.","Univ. Illinois",390,11.9,12.2]
[null,"Chisel Plow, 44 ft.","Univ. Illinois",440,12.2,13]
[null,"Chisel Plow, 47 ft.","Univ. Illinois",440,12.1,12.5]
[null,"Chisel Plow, 55 ft.","Univ. Illinois",490,10.7,11.6]
[null,"Chisel Plow, 61 ft.","Univ. Illinois",570,11,11.5]
[null,"Conventional planter, 12-row","Univ. Illinois",175,16.2,18.100000000000001]
[null,"Conventional planter, 16-row","Univ. Illinois",205,14.4,17.2]
[null,"Conventional planter, 24-row","Univ. Illinois",240,13.7,15.7]
[null,"Conventional planter, 32-row","Univ. Illinois",260,16.399999999999999,18.899999999999999]
[null,"Conventional planter, 36-row","Univ. Illinois",310,16.3,18.399999999999999]
[null,"Conventional planter, 6-row","Univ. Illinois",120,16.5,19.7]
[null,"Conventional planter, 8-row","Univ. Illinois",140,15.8,17.600000000000001]
[null,"Field cultivator, 29 ft. 6 in.","Univ. Illinois",240,9.5,12.5]
[null,"Field cultivator, 31 ft. 6 in,","Univ. Illinois",240,10.6,11.9]
[null,"Field cultivator, 35 ft. 6 in.","Univ. Illinois",285,9.8000000000000007,12.2]
[null,"Field cultivator, 40 ft. 6 in.","Univ. Illinois",310,10.9,12.8]
[null,"Field cultivator, 44 ft. 6 in.","Univ. Illinois",310,10.199999999999999,11.8]
[null,"Field cultivator, 48 ft. 6 in.","Univ. Illinois",390,9.9,11.1]
[null,"Field cultivator, 52 ft. 6 in.","Univ. Illinois",390,9.4,10.4]
[null,"Field cultivator, 56 ft. 6 in.","Univ. Illinois",440,9,10.3]
[null,"Field cultivator, 60 ft. 6 in.","Univ. Illinois",490,8.1999999999999993,9.6]
[null,"Field cultivator, 64 ft. 6 in.","Univ. Illinois",590,7.9,10]
[null,"Field Sprayer, 90 ft.","Univ. Illinois",95,3.9,4.5999999999999996]
[null,"Grain drill, 13 ft.","Univ. Illinois",110,16.600000000000001,19.3]
[null,"Grain drill, 25 ft.","Univ. Illinois",140,14.5,15.4]
[null,"Grain drill, 30 ft.","Univ. Illinois",175,14.4,15.4]
[null,"Grain drill, 35 ft.","Univ. Illinois",225,15.5,16.2]
[null,"Moldboard plow, 10 bottom","Univ. Illinois",285,39.200000000000003,40]
[null,"Moldboard plow, 6 bottom","Univ. Illinois",175,35,38.5]
[null,"Moldboard plow, 7 bottom","Univ. Illinois",205,39.799999999999997,40.299999999999997]
[null,"Moldboard plow, 9 bottom ","Univ. Illinois",260,40.299999999999997,41.8]
[null,"Mulch finisher (disk, chisel, and drag), 21 ft 9\"","Univ. Illinois",225,17.600000000000001,18.899999999999999]
[null,"Mulch finisher (disk, chisel, and drag), 24 ft 9\"","Univ. Illinois",240,16.600000000000001,17.899999999999999]
[null,"Mulch finisher (disk, chisel, and drag), 27 ft 9\"","Univ. Illinois",260,15.8,18.7]
[null,"Mulch finisher (disk, chisel, and drag), 30 ft 9\"","Univ. Illinois",285,16.5,18.2]
[null,"Mulch finisher (disk, chisel, and drag), 33 ft 9\"","Univ. Illinois",285,15.5,17.100000000000001]
[null,"Mulch finisher (disk, chisel, and drag), 38 ft 3\"","Univ. Illinois",310,15.4,15.4]
[null,"Mulch finisher (disk, chisel, and drag), 44 ft 3\"","Univ. Illinois",390,14.2,15.7]
[null,"Mulch finisher (disk, chisel, and drag), 50 ft 3\"","Univ. Illinois",490,13.4,15.2]
[null,"Mulch finisher (disk, chisel, and drag), 56 ft 3\"","Univ. Illinois",590,12.6,14.5]
[null,"Mulch tiller (disk, chisel shanks), 11 ft. 3 in.","Univ. Illinois",140,20.5,22.5]
[null,"Mulch tiller (disk, chisel shanks), 13 ft. 9 in.","Univ. Illinois",175,20.399999999999999,21]
[null,"Mulch tiller (disk, chisel shanks), 16 ft. 3 in.","Univ. Illinois",205,21.4,21.6]
[null,"Mulch tiller (disk, chisel shanks), 18 ft. 9 in.","Univ. Illinois",240,24.5,22.3]
[null,"Mulch tiller (disk, chisel shanks), 21 ft 3 in.","Univ. Illinois",260,22.9,22.7]
[null,"No-till drill, 10 ft","Univ. Illinois",110,33.799999999999997,35.9]
[null,"No-till drill, 15 ft","Univ. Illinois",140,25.8,27.2]
[null,"No-till drill, 20 ft.","Univ. Illinois",175,24.9,26.6]
[null,"No-till planter (30\" rows), 12-row","Univ. Illinois",175,17.8,19.5]
[null,"No-till planter (30\" rows), 16-row","Univ. Illinois",225,17.2,19]
[null,"No-till planter (30\" rows), 24-row","Univ. Illinois",260,15.5,18]
[null,"No-till planter (30\" rows), 8-row","Univ. Illinois",140,17,19]
[null,"Offset disk, 10 ft.","Univ. Illinois",120,20,21.7]
[null,"Offset disk, 14 ft.","Univ. Illinois",155,16,17.5]
[null,"Offset disk, 16 ft.","Univ. Illinois",205,14.7,18.8]
[null,"Self-propelled sprayer (High-crop ready), 100 ft boom","Univ. Illinois",85,5,5.7]
[null,"Self-propelled sprayer (High-crop ready), 80 ft boom","Univ. Illinois",85,4.4000000000000004,5.2]
[null,"Self-propelled sprayer (High-crop ready), 90 ft boom","Univ. Illinois",85,5.3,6.4]
[null,"Self-propelled sprayer , 120 ft boom","Univ. Illinois",85,4.4000000000000004,4.5]
[null,"Split-row planter (soybean acres only), 12-row split","Univ. Illinois",205,14.3,17.100000000000001]
[null,"Split-row planter (soybean acres only), 16-row split","Univ. Illinois",225,12.5,14.9]
[null,"Strip Till, 12-row","Univ. Illinois",285,19.3,19.600000000000001]
[null,"Strip Till, 16-row","Univ. Illinois",440,16.7,17.3]
[null,"Strip Till, 24-row","Univ. Illinois",640,11.3,14.2]
[null,"Tandem disk, 23 ft. 7 in.","Univ. Illinois",175,12.7,14.2]
[null,"Tandem disk, 26 ft. 5 in.","Univ. Illinois",205,12.5,15]
[null,"Tandem disk, 29 ft. 3 in.","Univ. Illinois",225,13.4,14.3]
[null,"Tandem disk, 33 ft. 7 in.","Univ. Illinois",240,12.6,13.7]
[null,"Tandem disk, 40 ft. 8 in.","Univ. Illinois",285,"NA",14.4]
[null,"Tandem disk, 44 ft. 11 in.","Univ. Illinois",310,"NA",14.8]
[null,"Vertical tillage, rolling basket, 21 ft 9 in","Univ. Illinois",190,"NA",11.9]
[null,"Vertical tillage, rolling basket, 25 ft 5 in","Univ. Illinois",260,"NA",14]
[null,"Vertical tillage, rolling basket, 30 ft 3 in","Univ. Illinois",285,"NA",13.2]
[null,"Vertical tillage, rolling basket, 33 ft 10 in","Univ. Illinois",390,"NA",12.8]
[null,"Vertical tillage, rolling basket, 43 ft 6 in","Univ. Illinois",440,"NA",11.8]
[null,"Vertical tillage, rolling basket, 49 ft 6 in","Univ. Illinois",590,"NA",12.4]
[null,"V-Ripper (shanks only), 10 ft. 6 in.","Univ. Illinois",175,17.3,22]
[null,"V-Ripper (shanks only), 14 ft. 7 in.","Univ. Illinois",240,20.399999999999999,21.4]
[null,"V-Ripper (shanks only), 15 ft","Univ. Illinois",260,24.4,25.5]
[null,"V-Ripper (shanks only), 18 ft. 4 in.","Univ. Illinois",310,22.5,23.4]
[null,"V-Ripper (shanks only), 21 ft. 8 in.","Univ. Illinois",440,19.2,21.1]
[]
[null,"[insert user machinery description & cost (in 'Machinery Costs' tab)]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert user machinery description & cost]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert user machinery description & cost]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert user machinery description & cost]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert more rows if needed (in 'Machinery Costs' tab)]","[See 'Machinery Costs' tab]",null,null,"[See 'Machinery Costs' tab]"]
[null,"Fertilizer Application Machinery Costs1,2"]
[null,"Item","Source","Tractor HP","2019 ($/ac)","2021 ($/ac)"]
[null,"Anhydrous ammonia applicator, 27 ft. 6 in.","Univ. Illinois",140,17.600000000000001,18.8]
[null,"Anhydrous ammonia applicator, 37 ft. 6 in.","Univ. Illinois",240,17.2,17.899999999999999]
[null,"Anhydrous ammonia applicator, 47 ft. 6 in.","Univ. Illinois",290,16.5,17.100000000000001]
[null,"Anhydrous ammonia applicator, 52 ft. 6 in. ","Univ. Illinois",370,15.3,16.399999999999999]
[null,"Anhydrous ammonia applicator, 62 ft. 6 in.","Univ. Illinois",470,14,14.9]
[null,"Fertilizer Application, Anhydrous, injecting, with tool bar","Iowa State Univ.",null,12.5,13.4]
[null,"Fertilizer Application, Anhydrous, injecting, without tool bar","Iowa State Univ.",null,11.4,11.95]
[null,"Fertilizer application, dry bulk, applied","Iowa State Univ.",null,5.8,6.15]
[null,"Fertilizer application, liquid, side dressing","Iowa State Univ.",null,11.35,11.35]
[null,"Fertilizer application, liquid, spraying","Iowa State Univ.",null,7.3,6.8]
[null,"Manure Application, liquid, drag line ($/gal)","Iowa State Univ.3",null,null,{"$f":"12.7/1000","v":1.2699999999999999E-2}]
[null,"Manure Application, liquid, injected ($/gal)","Iowa State Univ.3",null,null,{"$f":"13.35/1000","v":1.3349999999999999E-2}]
[null,"Manure Application, loading and spreading solid manure ($/hr)","Iowa State Univ.3",null,null,141.65]
[]
[null,"[insert user machinery description & cost (in 'Machinery Costs' tab)]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert user machinery description & cost]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert user machinery description & cost]","[insert source]","[insert horsepower]","NA","[insert user price]"]
[null,"[insert more rows if needed (in 'Machinery Costs' tab)]","[See 'Machinery Costs' tab]",null,null,"[See 'Machinery Costs' tab]"]
[null,"1 University of Illinois at Urbana-Champaign Department of Ag and Consumer Economics. (September 2021). Farm Business Management Machinery Cost Estimates: Field Operations.  Retrieved on February 22, 2022 from https://farmdoc.illinois.edu/management#handbook"]
[null,"2 Iowa State University Extension and Outreach. (March 2022). Ag Decision Maker: 2022 Iowa Farm Custom Rate Survey (File A3-10). Retrieved on March 23, 2022 from https://www.extension.iastate.edu/agdm/crops/html/a3-10.html"]
[null,"3 Liquid manure application costs were converted from $/1000 gallons to $/gallon."]
[null,"* 2021 prices for the Chisel Plow 12' and 15' mahinery calculated using the Prices Paid Index because the September 2021 University of Illinois publication did not include machinery cost estimates for this smaller equipment, but it is used commonly enough by small-scale farmers that we kept it as an option."]

{"sheet":"Net Income Values by Crop","index":11,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,0,63,12],[2,0,19,12],[0,0,0,12],[1,0,1,12],[21,0,21,12]]}
["2020 & 2021 Calculated Net Income by Crop"]
["ABOUT THIS TAB:"]
["The USDA Economic Research Service publish biannual commodity costs and returns values by crop using national average production and cost values collected through the Agricultural Resource Management Survey (ARMS). ARMS is crop-specific. Using data below, we calculate net income in the row highlighted blue for use in the \"ONLY CCR\" tab.\n\nNet income is the value of production minus operating costs, hired labor, opportunity cost of unpaid labor, and capital recovery of machinery and equipment. \n      • Operating costs include seed, fertilizer, chemicals, custom services, fuel/lube/electricity, repairs, purchased irrigation \n         water, and interest on operating capital. The budget items included in this Tool’s partial budget analysis represent \n         variable costs incurred when switching crop production or budget items primarily composed of variable costs. \n         Operating costs are variable costs calculated from direct costing from farmer-provided answers in ARMS. \n      • Three allocated overhead budget items are included in this partial budget analysis: hired labor, opportunity cost of \n         unpaid labor, and capital recover of machinery. \n      • Hired labor is included as it is a variable cost that is calculated similar to other operating costs using direct costing in \n         the ARMS. \n      • Opportunity cost of unpaid labor is measured directly as an estimate of the off-farm wages paid to farm operators \n         working off-farm. Though part of the labor is fixed as an overhead from running the entire farm enterprise, the value \n         also varies by individual production system. \n      • Capital recovery of machinery and equipment is included as it is directly tied to crop production. This category does \n         include both fixed and variable costs, which are attributed to individual production systems.\n\nNote: Only the 2021 net income calculated values in the row highlighted blue (Row 52) are used directly in the Tool. The other values in this table are provided for user reference in order to better understand the calculated net income values. We include 2020 values only for users' reference."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Crop Production Costs and Returns Per Planted Acre, Excluding Government Payments 1"]
[null,"Barley (2020)","Barley (2021)","Corn (2020)","Corn (2021)","Grain Sorghum (2020)","Grain Sorghum (2021)","Oats (2020)","Oats (2021)","Soybeans (2020)","Soybeans (2021)","Wheat (2020)","Wheat (2021)"]
["Gross value of production"]
["Primary product, grain",313.93,246.93,642.58000000000004,927.36,322.52,396.53,192.1,233.05,524.16999999999996,650.69000000000005,238.41,282.32]
["Secondary product, silage",13.65,18.149999999999999,2.13,2.34,6.46,7.24,4.9800000000000004,5.47,null,null,4.99,6.48]
["Secondary product, straw",null,null,null,null,null,null,72.86,80.150000000000006]
["Total, gross value of production",{"$f":"B26+B25","v":327.58},{"$f":"C26+C25","v":265.08},644.71,929.7,{"$f":"F26+F25","v":328.97999999999996},{"$f":"G26+G25","v":403.77},{"$f":"H26+H25+H27","v":269.94},{"$f":"I26+I25+I27","v":318.67},524.16999999999996,650.69000000000005,{"$f":"L26+L25","v":243.4},{"$f":"M26+M25","v":288.8}]
["Operating costs"]
["Seed",19.690000000000001,19.600000000000001,91.84,91.42,13.35,13.22,18.260000000000002,18.23,59.66,59.46,14.53,14.51]
["Fertilizer ¹ ",47.35,47.54,116.93,116.57,39.81,39.97,39.43,39.74,31.35,30.97,44.02,43.63]
["Chemicals",20.54,20.239999999999998,32.630000000000003,31.48,27.4,26.8,6.92,6.74,35.619999999999997,34.58,15.85,15.14]
["Custom services ² ",6.02,6.19,22.94,23.49,17.71,18.21,10.36,10.4,12.68,13.1,13.7,14.33]
["Fuel, lube, and electricity",13.14,13.25,27.19,26.96,8.9499999999999993,8.94,17.62,17.73,13.62,13.79,10.52,10.55]
["Repairs",28.56,30.71,35.56,37.96,26.28,28.13,27.19,29.1,29.18,31.43,25.73,27.51]
["Purchased irrigation water",2.5099999999999998,2.6,0.28000000000000003,0.28000000000000003,0.16,0.16,2.1800000000000002,2.2400000000000002,0.01,0.01,0.79,0.8]
["Interest on operating capital",0.28999999999999998,0.04,0.69,0.1,0.28000000000000003,0.04,0.26,0.04,0.38,0.06,0.26,0.04]
["Total, operating costs",138.1,140.16999999999999,328.06,328.26,133.94,135.47999999999999,122.22,124.22,182.5,183.4,125.4,126.51]
["Allocated overhead"]
["Hired labor",4.2300000000000004,4.55,5.33,5.64,4.26,4.43,2.4300000000000002,2.66,5.0599999999999996,5.37,4.2300000000000004,4.43]
["Opportunity cost of unpaid labor",16.54,17.399999999999999,31.01,32.340000000000003,16.77,17.79,59.61,63.99,17.82,18.77,17.77,18.899999999999999]
["Capital recovery of machinery and equipment",106.27,114.19,126.06,134.63999999999999,102.38,109.6,109.33,116.79,109.82,118.23,97.06,103.33]
["Opportunity cost of land",74.56,78.31,161.86000000000001,163.41,55.77,57.08,100.81,100.78,151.46,154.97,60.04,62.1]
["Taxes and insurance",11.85,12.13,13.22,13.53,10.09,10.38,6.56,7.2,12.91,13.25,6.93,7]
["General farm overhead",19.100000000000001,20.309999999999999,19.62,20.91,14.27,15.3,13.93,14.84,18.690000000000001,19.97,9.4499999999999993,9.99]
["Total, allocated overhead",232.55,246.89,357.1,370.47,203.54,214.59,292.67,306.26,315.76,330.56,195.48,205.75]
["Costs listed"]
["Total, costs listed",{"$f":"B46+B38","v":370.65},{"$f":"C46+C38","v":387.05999999999995},{"$f":"D38+D46","v":685.16000000000008},{"$f":"E38+E46","v":698.73},{"$f":"F46+F38","v":337.48},{"$f":"G46+G38","v":350.07},{"$f":"H46+H38","v":414.89},{"$f":"I46+I38","v":430.48},{"$f":"J38+J46","v":498.26},{"$f":"K38+K46","v":513.96},{"$f":"L46+L38","v":320.88},{"$f":"M46+M38","v":332.26}]
["Net value"]
["Value of production less total costs listed",{"$f":"B28-B48","v":-43.069999999999993},{"$f":"C28-C48","v":-121.97999999999996},{"$f":"D28-D38-D46","v":-40.449999999999989},{"$f":"E28-E38-E46","v":230.97000000000003},{"$f":"F28-F48","v":-8.5000000000000568},{"$f":"G28-G48","v":53.699999999999989},{"$f":"H28-H48","v":-144.94999999999999},{"$f":"I28-I48","v":-111.81},{"$f":"J28-J38-J46","v":25.909999999999968},{"$f":"K28-K38-K46","v":136.73000000000008},{"$f":"L28-L48","v":-77.47999999999999},{"$f":"M28-M48","v":-43.45999999999998}]
["Value of production less operating costs",{"$f":"B28-B38","v":189.48},{"$f":"C28-C38","v":124.91},{"$f":"D28-D38","v":316.65000000000003},{"$f":"E28-E38","v":601.44000000000005},{"$f":"F28-F38","v":195.03999999999996},{"$f":"G28-G38","v":268.28999999999996},{"$f":"H28-H38","v":147.72},{"$f":"I28-I38","v":194.45000000000002},{"$f":"J28-J38","v":341.66999999999996},467.29000000000008,{"$f":"L28-L38","v":118},162.29000000000002]
["Value of production less operating costs, hired labor, OC unpaid labor, capital recovery",{"$f":"B28-B38-B40-B41-B42","v":62.440000000000012},-11.22999999999999,154.25000000000006,428.82000000000005,71.629999999999967,136.46999999999997,-23.650000000000006,11.010000000000005,208.96999999999997,{"$f":"K28-K38-K40-K41-K42","v":324.92000000000007},{"$f":"L28-L38-L40-L41-L42","v":-1.0600000000000023},35.63000000000001]
["Supporting information"]
["Yield (bushels per planted acre)",70,49,178,184,74,72,70,64,54,54,52,42]
["Price (dollars per bushel at harvest)",4.5,5.0599999999999996,3.61,5.04,4.3600000000000003,5.49,2.76,3.67,9.67,11.98,4.6100000000000003,6.67]
["Enterprise size (planted acres)",282,282,278,278,365,365,26,26,314,314,562,562]
["Production practices"]
["Winter wheat (percent of acres)",null,null,null,null,null,null,null,null,null,null,66,69]
["Spring wheat (percent of acres)",null,null,null,null,null,null,null,null,null,null,28,26]
["Durum wheat (percent of acres)",null,null,null,null,null,null,null,null,null,null,6,6]
["Dryland (percent of acres)",84,84,88,89,97,97,99,99,90,90,95,95]
["Irrigated (percent of acres)",16,16,12,11,3,3,1,1,10,10,5,5]
["1 USDA Economic Research Service. (May 2, 2022). Commodity Costs and Returns: Recent Costs and Returns. Retrieved on June 17, 2022 from https://www.ers.usda.gov/data-products/commodity-costs-and-returns/ "]

{"sheet":"Lists","index":12,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,4,2],[0,1,0,2],[1,1,1,2],[2,0,2,2]]}
[null,"LISTS"]
[]
["ABOUT THIS TAB:"]
["The Lists tab contains lists of items used by Excel's Data Validation function.  Items contained in each list below are available for selection from drop down menus on various tabs."]
[]
[]
[null,"Types of Tillage"]
[null,"Conventional"]
[null,"No-Till"]
[null,"Reduced Till"]
[null,"Strip-Till"]
[]
[null,"Crops"]
[null,"Barley"]
[null,"Corn Silage"]
[null,"Corn Grain"]
[null,"Hay"]
[null,"Grain Sorghum (milo)"]
[null,"Oats"]
[null,"Soybeans"]
[null,"Wheat"]