{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,1,22,2],[23,1,23,2],[27,1,27,2],[0,0,0,2],[4,0,4,2],[6,1,6,2],[2,1,2,2],[1,1,1,2]]}
["How Much Do I Want to Pay Myself?"]
[null,"Fill in the green cells"]
["Desired personal income from farming",150000]
[]
["What Kind of Return Do I Want the Farm to Have?"]
[]
["Net return to investment in this year's crops",0.1]
[]
[]
[null,"Corn","Soybeans"]
["Acres Farmed",800,200]
["Percent of Income per Crop",0.8,0.2]
["Cost of Production Per Acre",750,450]
["Dollars Per Acre Needed for Personal Income",{"$f":"B3*B12/B11","v":150},{"$f":"B3*C12/C11","v":150}]
["Dollars Per Acre Needed for Farm ROI",{"$f":"B13*B7","v":75},{"$f":"C13*B7","v":45}]
[]
["Total Dollars Needed Per Acre",{"$f":"SUM(B13:B15)","v":975},{"$f":"SUM(C13:C15)","v":645}]
[]
["Average Yield",4.5,1]
[]
["Target Price to Achieve Your Goals",{"$f":"B17/B19","v":216.66666666666666},{"$f":"C17/C19","v":645}]
[]
["Whole Farm Cost",{"$f":"B13*B11+C13*C11","v":690000}]
["Desired Whole Farm Revenue",{"$f":"B17*B11+C17*C11","v":909000}]
[]
[null,"Corn","Soybeans"]
["Current Prices",2.89,8.57]
["Current Whole Farm Revenue",{"$f":"B27*B19*B11+C27*C19*C11","v":12118}]
["Our Current New Crop Bid",5.5,11.65]

{"sheet":"Sheet2","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6],[7,0,7,6]]}
["Gross Revenue Per Acre at Current New Crop Price"]
[null,"New Crop Bid",null,"Average Yield",null,"Gross Revenue"]
["Corn ",5.5,"x",4.5,"=",{"$f":"D3*B3","v":24.75},"/acre"]
["Soybeans",11.5,"x",3,"=",{"$f":"D4*B4","v":34.5},"/acre"]
["Wheat",6.25,"x",2,"=",{"$f":"D5*B5","v":12.5},"/acre"]
[]
[]
["Target Price to Generate Desired Gross Revenue Per Acre"]
[null,"Desired"]
[null,"Gross Revenue",null,"Average Yield",null,"Target Price"]
["Corn ",1000,"÷",4.5,"=",{"$f":"B11/D11","v":222.22222222222223},"/mt."]
["Soybeans",700,"÷",3,"=",{"$f":"B12/D12","v":233.33333333333334},"/mt."]
["Wheat",500,"÷",2,"=",250,"/mt."]