{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Crop and Livestock Data","Overall Net Cash Flow","Per Crop Per Acre Cash Flow"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Crop and Livestock Data","index":1,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[11,1,11,3],[21,1,21,3],[30,1,30,3],[39,1,39,3],[0,1,2,3],[5,1,5,7],[37,1,37,3],[38,1,38,3],[5,9,5,12],[1,14,1,15],[2,14,2,15],[3,14,3,15],[5,14,5,15],[9,9,9,11],[10,1,10,3],[10,9,10,11],[6,1,6,7],[6,9,6,12],[7,1,7,3],[7,9,7,11],[8,1,8,3],[8,9,8,11],[14,14,14,15],[33,1,33,7],[34,1,34,3],[27,1,27,3],[27,9,27,11],[28,1,28,3],[28,9,28,11],[29,1,29,3],[24,1,24,7],[24,9,24,12],[25,1,25,3],[25,9,25,11],[26,1,26,3],[26,9,26,11],[11,18,11,24],[6,14,6,15],[35,1,35,3],[36,1,36,3],[18,1,18,3],[18,9,18,11],[19,1,19,3],[20,1,20,3],[12,1,12,3],[15,1,15,7],[15,9,15,12],[16,1,16,3],[16,9,16,11],[17,1,17,3],[17,9,17,11],[9,1,9,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIHP- Central Illinois High Productivity Farmland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CILP- Central Illinois Low Productivity Farmland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SI- Southern Illinois Farmland"]
[null,null,null,null,null,null,"Southern Illinois"]
[null,"Crops",null,null,null,null,null,null,null,"Livestock",null,null,null,null,"University of Illinois Crop Budget Reference Data"]
[null,"Choose Crop Type",null,null,null,null,null,null,null,"Livestock Sales (ENTER TYPE HERE)",null,null,null,null,"** Please select crop type that you would like data displayed for**"]
[null,"Acres",null,null,null,null,"Chemical",null,null,"# of head sold "]
[null,"Yield (bu) ",null,null,null,null,"Fert/Nitrogen",null,null,"Selling Weight (lbs)"]
[null,"Price/bu",null,null,null,null,"Fuel",null,null,"Selling Price (lbs)",null,null,null,null,null,null,null,null,null,"https://farmdoc.illinois.edu/handbook/2022-budgets-for-all-regions"]
[null,"bu used for livestock feed ",null,null,null,null,"Insurance",null,null,"Total Sales ",null,null,{"$f":"(M8*M9*M10)","v":0},null,null,null,null,null,null,"**Will update with new crop budgets"]
[null,"Gross Income Per Acre",null,null,{"$f":"IFERROR((E13/E8)-H14,)","v":0},null,"Seed",null,null,null,null,null,null,null,null,null,null,null,"Information for the Reference Table (Updated 8/23/2021)"]
[null,"Total Crop Sales ",null,null,{"$f":"(E8*E9*E10)-(E11*E10)","v":0},null,"Other"]
[null,null,null,null,null,null,"Total Crop Inputs",{"$f":"SUM(H8:H13)","v":0},null,null,null,null,null,null,null,null,null,null,"yield","Price","Chemical","Fert","Fuel","Insurance","Seed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CHOOSE(Q1,S30,S31,S32,S33,S34,S35,S36,S37,S38,S39,S40,S41), \" \", R1)","v":"CIHP-Corn Data"},null,null,"CIHP Corn",223,4.5,66,193,20,12,124]
[null,"Choose Crop Type",null,null,null,null,null,null,null,"Livestock Sales (ENTER TYPE HERE)",null,null,null,null,"Yield (bu)",{"$f":"CHOOSE(Q1,S15,S16,S17,S18,S19,S20,S21,S22,S23,S24,S25,S26)","v":223},null,"Soybeans",69,12.35,54,63,13,12,80]
[null,"Acres",null,null,null,null,"Chemical",null,null,"# of head sold ",null,null,null,null,"Price/bu",{"$f":"CHOOSE(Q1,T15,T16,T17,T18,T19,T20,T21,T22,T23,T24,T25,T26,)","v":4.5},null,"Wheat",75,5.9,27,76,20,5,50]
[null,"Yield (bu) ",null,null,null,null,"Fert/Nitrogen",null,null,"Selling Weight (lbs)",null,null,null,null,null,null,null,"Double Crop soybean",43,12.35,42,29,22,0,49]
[null,"Price/bu",null,null,null,null,"Fuel",null,null,"Selling Price (lbs)",null,null,null,null,"Chemical",{"$f":"CHOOSE(Q1,U15,U16,U17,U18,U19,U20,U21,U22,U23,U24,U25,U26)","v":66},null,"CILP corn",211,4.5,66,194,19,13,129]
[null,"bu used for livestock feed ",null,null,null,null,"Insurance",null,null,"Total Sales ",null,null,{"$f":"(M17*M18*M19)","v":0},null,"Fert/Nitrogen",{"$f":"CHOOSE(Q1,V15,V16,V17,V18,V19,V20,V21,V22,V23,V24,V25,V26)","v":193},null,"Soybeans",62,12.35,53,60,13,11,69]
[null,"Gross Income Per Acre",null,null,{"$f":"IFERROR(E22/(H23*E17),)","v":0},null,"Seed",null,null,null,null,null,null,null,"Fuel",{"$f":"CHOOSE(Q1,W15,W16,W17,W18,W19,W20,W21,W22,W23,W24,W25,W26)","v":20},null,"wheat",78,5.9,29,76,12,9,48]
[null,"Total Crop Sales ",null,null,{"$f":"(E17*E18*E19)-(E20*E19)","v":0},null,"Other",null,null,null,null,null,null,null,"Insurance",{"$f":"CHOOSE(Q1,X15,X16,X17,X18,X19,X20,X21,X22,X23,X24,X25,X26)","v":12},null,"Double Crop soybean",43,12.35,37,29,12,0,50]
[null,null,null,null,null,null,"Total Crop Inputs",{"$f":"SUM(H17:H22)","v":0},null,null,null,null,null,null,"Seed",{"$f":"CHOOSE(Q1,Y15,Y16,Y17,Y18,Y19,Y20,Y21,Y22,Y23,Y24,Y25,Y26)","v":124},null,"SI corn",188,4.53,66,180,23,14,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soybeans",55,12.38,55,59,19,14,72]
[null,"Choose Crop Type",null,null,null,null,null,null,null,"Livestock Sales (ENTER TYPE HERE)",null,null,null,null,null,null,null,"Wheat",75,5.9,29,137,16,9,48]
[null,"Acres",null,null,null,null,"Chemical",null,null,"# of head sold ",null,null,null,null,null,null,null,"Double Crop soybean",43,12.38,42,29,14,0,49]
[null,"Yield (bu) ",null,null,null,null,"Fert/Nitrogen",null,null,"Selling Weight (lbs)"]
[null,"Price/bu",null,null,null,null,"Fuel",null,null,"Selling Price (lbs)"]
[null,"bu used for livestock feed ",null,null,null,null,"Insurance",null,null,"Total Sales ",null,null,{"$f":"(M26*M27*M28)","v":0},null,null,null,null,null,"Choose Crop Type"]
[null,"Gross Income Per Acre",null,null,{"$f":"IFERROR(E31/(H32*E26),)","v":0},null,"Seed",null,null,null,null,null,null,null,null,null,null,null,"CIHP-Corn"]
[null,"Total Crop Sales ",null,null,{"$f":"(E26*E27*E28)-(E29*E28)","v":0},null,"Other",null,null,null,null,null,null,null,null,null,null,null,"CIHP-Soybeans"]
[null,null,null,null,null,null,"Total Crop Inputs",{"$f":"SUM(H26:H31)","v":0},null,null,null,null,null,null,null,null,null,null,"CIHP-Wheat"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CIHP-Double Crop Soybeans"]
[null,"Choose Crop Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CILP-Corn"]
[null,"Acres",null,null,null,null,"Chemical",null,null,null,null,null,null,null,null,null,null,null,"CILP-Soybeans"]
[null,"Yield (bu) ",null,null,null,null,"Fert/Nitrogen",null,null,null,null,null,null,null,null,null,null,null,"CILP-Wheat"]
[null,"Price/bu",null,null,null,null,"Fuel",null,null,null,null,null,null,null,null,null,null,null,"CILP-Double Crop Soybeans"]
[null,"bu used for livestock feed ",null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,null,null,"SI-Corn"]
[null,"Gross Income Per Acre",null,null,{"$f":"IFERROR(E40/(H41*E35),)","v":0},null,"Seed",null,null,null,null,null,null,null,null,null,null,null,"SI-Soybeans"]
[null,"Total Crop Sales ",null,null,{"$f":"(E35*E36*E37)-(E38*E37)","v":0},null,"Other",null,null,null,null,null,null,null,null,null,null,null,"SI-Wheat"]
[null,null,null,null,null,null,"Total Crop Inputs",{"$f":"SUM(H35:H40)","v":0},null,null,null,null,null,null,null,null,null,null,"SI-Double Crop Soybeans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]

{"sheet":"Overall Net Cash Flow","index":2,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[78,1,78,2],[77,1,77,2],[76,1,76,2],[75,1,75,5],[84,1,88,9],[82,1,82,2],[80,1,80,4],[79,1,79,2],[66,1,66,4],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[59,1,59,5],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[65,1,65,2],[53,1,53,2],[39,1,39,2],[40,1,40,2],[41,1,41,4],[43,1,43,5],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,4],[50,1,50,2],[52,1,52,3],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[38,1,38,2],[26,1,26,2],[27,1,27,4],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[29,1,29,6],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[6,4,7,9],[68,1,68,6],[12,1,12,2],[1,0,3,2],[4,1,4,9],[6,1,6,3],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[1,5,1,6],[2,5,2,6],[25,1,25,2],[13,1,13,2],[15,1,15,5],[73,1,73,4],[69,1,69,2],[70,1,70,2],[71,1,71,2],[72,1,72,2]]}
[]
[null,null,null,null,"Name "]
[null,null,null,null,"Year "]
[]
[null,"Overall Net Cash Flow Per Acre"]
[]
[null,"Farm Income "]
[null,"Sales Of Livestock & Other Resale Items ",null,{"$f":"'Crop and Livestock Data'!M11+'Crop and Livestock Data'!M20+'Crop and Livestock Data'!M29","v":0}]
[null,"Sales Of Produce Grains & Other Products Raised ",null,{"$f":"'Crop and Livestock Data'!E13+'Crop and Livestock Data'!E22+'Crop and Livestock Data'!E31+'Crop and Livestock Data'!E40","v":0}]
[null,"Agricultural Program Payments (i.e. CSP, CRP)"]
[null,"Cash Rent Received "]
[null,"Custom Hire (Machine Work) "]
[null,"Cooperative Distributions"]
[null,"Total Farm Income ",null,{"$f":"IFERROR(SUM(D8:D13),)","v":0}]
[]
[null,"Farm Operating Expenses "]
[null,"Chemicals ",null,{"$f":"('Crop and Livestock Data'!H8*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H17*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H26*'Crop and Livestock Data'!E26)+ ('Crop and Livestock Data'!H35*'Crop and Livestock Data'!E35)","v":0},"Land Rent "]
[null,"Custom Hire ",null,null,"Other Rent (ENTER TYPE HERE)"]
[null,"Employee Benefits ",null,null,"Repairs/Maintenance "]
[null,"Feed/Grain ",null,null,"Seeds and Plants ",{"$f":"('Crop and Livestock Data'!H12*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H21*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H30*'Crop and Livestock Data'!E26)+('Crop and Livestock Data'!H39*'Crop and Livestock Data'!E35)","v":0}]
[null,"Fertilizers and Lime ",null,{"$f":"('Crop and Livestock Data'!H9*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H18*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H27*'Crop and Livestock Data'!E26)+('Crop and Livestock Data'!H36*'Crop and Livestock Data'!E35)","v":0},"Storage and Warehousing "]
[null,"Freight and Trucking ",null,null,"Supplies "]
[null,"Gasoline, Fuel, and Oil ",null,{"$f":"('Crop and Livestock Data'!H10*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H19*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H28*'Crop and Livestock Data'!E26)+('Crop and Livestock Data'!H37*'Crop and Livestock Data'!E35)","v":0},"Taxes (Real Estate - Farm)"]
[null,"Insurance (other than health) ",null,{"$f":"('Crop and Livestock Data'!H11*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H20*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H29*'Crop and Livestock Data'!E26)+('Crop and Livestock Data'!H38*'Crop and Livestock Data'!E35)","v":0},"Utilities "]
[null,"Labor Hired ",null,null,"Vet, Breeding, & Medicine "]
[null,"Pension, Profit-Sharing Plans ",null,null,"Other (From Per/Acre Breakdown)",{"$f":"('Crop and Livestock Data'!H13*'Crop and Livestock Data'!E8)+('Crop and Livestock Data'!H22*'Crop and Livestock Data'!E17)+('Crop and Livestock Data'!H31*'Crop and Livestock Data'!E26)+('Crop and Livestock Data'!H40*'Crop and Livestock Data'!E35)","v":0}]
[null,"Machinery/Equipment Rent ",null,null,"Other (ENTER TYPE HERE)"]
[null,"Total Farm Operating Expenses ",null,null,null,{"$f":"IFERROR(SUM(D17:D27)+SUM(F17:F27),)","v":0}]
[]
[null,"Farm Debt Schedule (Real Estate, Equipment, Improvements, etc.) "]
[null,"Lender/Description of Debt (i.e. FCI, 40 ac.)",null,"Amount Outstanding","Interest Rate ","Calculated Interest","Principal Due w/in 12 mos. "]
[null,null,null,null,null,{"$f":"D32*E32","v":0}]
[null,null,null,null,null,{"$f":"D33*E33","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total from Farm Debt Schedule ",null,null,null,{"$f":"IFERROR(SUM(F32:F41),)","v":0},{"$f":"IFERROR(SUM(G32:G41),)","v":0}]
[]
[null,"Farm Operating/Input Supplier Schedule "]
[null,"Lender/Description (i.e. FCI/RLOC)",null,"Commitment Amount","Interest Rate ","Estimated Yearly Interest "]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total Operating/Supplier Schedule ",null,null,null,{"$f":"SUM(F46:F48)","v":0}]
[]
[null,"NET FARM CASH FLOW ",null,{"$f":"D14-F28-F42-G42-F49","v":0}]
[]
[null,"Non-Farm Income "]
[null,"Salary/Wages "]
[null,"Other Non-Farm (ENTER TYPE HERE)"]
[null,"Other Non-Farm (ENTER TYPE HERE)"]
[null,"Income Taxes/FICA "]
[null,"Total Non-Farm Income ",null,{"$f":"IFERROR(SUM(D54:D56)-D57,)","v":0}]
[]
[null,"Annual Family Living Expenses "]
[null,"Rent/RE Tax (Use Debt Sch below for Mtg Debt)",null,null,"Gifts/Donations"]
[null,"Food, Including Restaurants ",null,null,"Entertainment/Recreation "]
[null,"Utilities ",null,null,"Cell Phone/Internet/etc. "]
[null,"Health, Including Health/Dental Insurance ",null,null,"Life and Auto Insurance "]
[null,"Childcare Expenses ",null,null,"Transporation/Gas/Fuel"]
[null,"Education ",null,null,"Other (ENTER TYPE HERE)"]
[null,"Total Family Living ",null,null,null,{"$f":"IFERROR(SUM(D61:D66)+SUM(F61:F66),)","v":0}]
[]
[null,"Non-Farm Debt Schedule (outside obligations already included in Family Living above) "]
[null,"Lender/Description of Debt (i.e. FCI, 40 ac.)",null,"Amount Outstanding","Interest Rate ","Calculated Interest","Principal Due w/in 12 mos. "]
[null,null,null,null,null,{"$f":"D71*E71","v":0}]
[null,null,null,null,null,{"$f":"D72*E72","v":0}]
[null,null,null,null,null,0]
[null,"Total from Farm Debt Schedule ",null,null,null,{"$f":"SUM(F71:F73)","v":0},{"$f":"SUM(G71:G73)","v":0}]
[]
[null,"Non-Farm Debt Schedule (outside of obligations already included in Family Living above)"]
[null,"Lender/Description of Debt (i.e. FNB, mortgage)",null,"Amount Outstanding ","Interest Rate ","Total Pmt due w/in 12 mos. "]
[]
[]
[]
[null,"Total Non-Farm Debt Schedule",null,null,null,{"$f":"SUM(F78:F80)","v":0}]
[]
[null,"NET CASH FLOW ",null,{"$f":"D51+D58-F67-F74-G74-F81","v":0}]
[]
[null,"General Notes: ENTER TEXT HERE"]

{"sheet":"Per Crop Per Acre Cash Flow","index":3,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,6],[6,1,6,6],[15,1,15,6],[0,0,2,1]]}
[]
[]
[]
[null,"Per Acre Per Crop Cash Flow"]
[null,"Total Acres",{"$f":"'Crop and Livestock Data'!E8","v":0},{"$f":"'Crop and Livestock Data'!E17","v":0},{"$f":"'Crop and Livestock Data'!E26","v":0},{"$f":"'Crop and Livestock Data'!E35","v":0},{"$f":"IFERROR(SUM(C5:F5),)","v":0},null,null,null,null,"Choose Crop Type"]
[null,null,null,null,null,null,null,null,null,null,null,"CIHP-Corn"]
[null,"Farm Income Per Acre",null,null,null,null,null,null,null,null,null,"CIHP-Soybeans"]
[null,null,"Choose Crop Type","Choose Crop Type","Choose Crop Type","Choose Crop Type","Overall",null,null,null,null,"CIHP-Wheat"]
[null,"Crop Returns/Acre",{"$f":"IFERROR('Crop and Livestock Data'!E13/'Crop and Livestock Data'!E8,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!E21/'Crop and Livestock Data'!E17,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!E30/E5,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!E39/'Crop and Livestock Data'!E35,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D9/'Per Crop Per Acre Cash Flow'!G5,)","v":0},null,null,null,null,"CIHP-Double Crop Soybeans"]
[null,"Agricultural Program Payments/ Acre",{"$f":"IFERROR('Overall Net Cash Flow'!D10/'Per Crop Per Acre Cash Flow'!C5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D10/D5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D10/E5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D10/F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D10/'Per Crop Per Acre Cash Flow'!G5,)","v":0},null,null,null,null,"CILP-Corn"]
[null,"Cash Rent Received/ Acre",{"$f":"IFERROR('Overall Net Cash Flow'!D11/'Per Crop Per Acre Cash Flow'!C5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D11/D5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D11/E5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D11/F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D11/G5,)","v":0},null,null,null,null,"CILP-Soybeans"]
[null,"Custom Hire (Machine Work)/ Acre",{"$f":"IFERROR('Overall Net Cash Flow'!D12/'Per Crop Per Acre Cash Flow'!C5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D12/D5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D12/E5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D12/F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D12/G5,)","v":0},null,null,null,null,"CILP-Wheat"]
[null,"Cooperative Distributions/ Acre",{"$f":"IFERROR('Overall Net Cash Flow'!D13/C5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D13/D5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D13/E5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D13/F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D13/G5,)","v":0},null,null,null,null,"CILP-Double Crop Soybeans"]
[null,"Total Farm Income Per Acre",{"$f":"SUM(C9:C13)","v":0},{"$f":"SUM(D9:D13)","v":0},{"$f":"SUM(E9:E13)","v":0},{"$f":"SUM(F9:F13)","v":0},{"$f":"SUM(G9:G13)","v":0},null,null,null,null,"SI-Corn"]
[null,null,null,null,null,null,null,null,null,null,null,"SI-Soybeans"]
[null,"Farm Operating Expenses Per Acre",null,null,null,null,null,null,null,null,null,"SI-Wheat"]
[null,null,{"$f":"C8","v":"Choose Crop Type"},{"$f":"D8","v":"Choose Crop Type"},{"$f":"E8","v":"Choose Crop Type"},"Choose Crop Type","Overall",null,null,null,null,"SI-Double Crop Soybeans"]
[null,"Chemical",{"$f":"IFERROR('Crop and Livestock Data'!H8,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H17,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H26,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H35,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$D$17/'Per Crop Per Acre Cash Flow'!G5,)","v":0},null,null,null,null,"Other"]
[null,"Fert/Nitrogen",{"$f":"IFERROR('Crop and Livestock Data'!H9,0)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H18,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H27,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H36,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$D$21/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Fuel",{"$f":"IFERROR('Crop and Livestock Data'!H10,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H19,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H28,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H37,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$D$23/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Insurance",{"$f":"IFERROR('Crop and Livestock Data'!H11,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H20,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H29,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H38,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$D$24/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Seed",{"$f":"IFERROR('Crop and Livestock Data'!H12,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H21,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H30,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H39,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$F$20/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Other",{"$f":"IFERROR('Crop and Livestock Data'!H13,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H13,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H31,)","v":0},{"$f":"IFERROR('Crop and Livestock Data'!H40,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!$F$26/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Custom Hire ",{"$f":"IFERROR(('Overall Net Cash Flow'!$D$18*('Per Crop Per Acre Cash Flow'!C5)/'Per Crop Per Acre Cash Flow'!$G$5)/C5,)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$18*('Per Crop Per Acre Cash Flow'!D5)/'Per Crop Per Acre Cash Flow'!$G$5)/D5,)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$18*('Per Crop Per Acre Cash Flow'!E5)/'Per Crop Per Acre Cash Flow'!$G$5)/E5,)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$18*('Per Crop Per Acre Cash Flow'!F5)/'Per Crop Per Acre Cash Flow'!$G$5)/F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D18/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Employee Benefits ",{"$f":"IFERROR(('Overall Net Cash Flow'!$D$19*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$19*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$19*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$19*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D19/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Freight and Trucking ",{"$f":"IFERROR((('Overall Net Cash Flow'!$D$22*('Per Crop Per Acre Cash Flow'!C5))/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5,)","v":0},{"$f":"IFERROR((('Overall Net Cash Flow'!$D$22*('Per Crop Per Acre Cash Flow'!D5))/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5,)","v":0},{"$f":"IFERROR((('Overall Net Cash Flow'!$D$22*('Per Crop Per Acre Cash Flow'!E5))/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5,)","v":0},{"$f":"IFERROR((('Overall Net Cash Flow'!$D$22*('Per Crop Per Acre Cash Flow'!F5))/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5,)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D22/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Labor Hired ",{"$f":"IFERROR(('Overall Net Cash Flow'!$D$25*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$25*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$25*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$25*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D25/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Pension, Profit-Sharing Plans ",{"$f":"IFERROR(('Overall Net Cash Flow'!$D$26*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$26*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$26*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$26*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D26/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Machinery/Equipment Rent ",{"$f":"IFERROR(('Overall Net Cash Flow'!$D$27*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$27*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$27*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$D$27*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!D27/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Land Rent ",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$17*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$17*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$17*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$17*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F17/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Other Rent (ENTER TYPE HERE)",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$18*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$18*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$18*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$18*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F18/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Repairs/Maintenance ",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$19*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$19*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$19*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$19*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F19/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Storage and Warehousing ",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$21*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$21*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$21*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$21*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F21/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Supplies ",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$22*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$22*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$22*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$22*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F22/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Taxes (Real Estate - Farm)",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$23*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$23*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$23*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$23*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F23/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Utilities ",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$24*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$24*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$24*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$24*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F24/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Other",{"$f":"IFERROR(('Overall Net Cash Flow'!$F$27*('Per Crop Per Acre Cash Flow'!C5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!C5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$27*('Per Crop Per Acre Cash Flow'!D5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!D5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$27*('Per Crop Per Acre Cash Flow'!E5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!E5),)","v":0},{"$f":"IFERROR(('Overall Net Cash Flow'!$F$27*('Per Crop Per Acre Cash Flow'!F5/'Per Crop Per Acre Cash Flow'!$G$5)/'Per Crop Per Acre Cash Flow'!F5),)","v":0},{"$f":"IFERROR('Overall Net Cash Flow'!F27/'Per Crop Per Acre Cash Flow'!G5,)","v":0}]
[null,"Total From Above Per Acre",{"$f":"SUM(C18:C37)","v":0},{"$f":"SUM(D18:D37)","v":0},{"$f":"SUM(E18:E37)","v":0},{"$f":"SUM(F18:F37)","v":0},{"$f":"SUM(G18:G37)","v":0}]
[]
[null,"Net From Above Per Acre",{"$f":"C14-C38","v":0},{"$f":"D14-D38","v":0},{"$f":"E14-E38","v":0},{"$f":"F14-F38","v":0},{"$f":"G14-G38","v":0}]