{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Crop and Feed Check"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":34,"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":"Crop and Feed Check","index":0,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
["Year",null,2017,{"$f":"\"1/1/\"&C1","v":"1/1/2017"}]
[null,null,{"$f":"C1+1","v":2018},{"$f":"\"1/1/\"&C2","v":"1/1/2018"}]
["Crop Summary",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"Market Value",135]
[null,"Crop","Corn"]
[null,"Type of Crop","Grain"]
[null,"Unit","Bushels"]
[null,"Unit Weight",56]
[]
["Beginning Inventory"]
[null,{"$f":"\"Beginning Inventory\" &\" \"&D1","v":"Beginning Inventory 1/1/2017"}]
[null,"Tons of Crop, As-Fed",{"$f":"C11*C8/2000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Beginning Inventory Value\"&\"--\"&D1","v":"Beginning Inventory Value--1/1/2017"},{"$f":"C4*C12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C13:Q13)","v":0}]
[]
["Crop Production"]
[null,{"$f":"\"Produced\"&\"--\"&C1&\" unit\"","v":"Produced--2017 unit"}]
[null,{"$f":"\"Produced\"&\"--\"&C1&\",\"&\" tons\"","v":"Produced--2017, tons"},{"$f":"C16*C8/2000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Cost/ton to produce\"&\" \"&C1&\" crop\"","v":"Cost/ton to produce 2017 crop"}]
[null,{"$f":"\"Value of\"&\" \"&C1&\" Crop\"","v":"Value of 2017 Crop"},{"$f":"C17*C18","v":0},{"$f":"D17*D18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C19:Q19)","v":0}]
[]
["Crop Purchases"]
[null,{"$f":"\"Purchased\"&\"--\"&C1&\" unit\"","v":"Purchased--2017 unit"},8000]
[null,{"$f":"\"Purchased\"&\"--\"&C1&\", tons\"","v":"Purchased--2017, tons"},{"$f":"IFERROR(C22*C8/2000,\"\")","v":224},{"$f":"IFERROR(D22*D8/2000,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Purchase Cost/ton\"&\"--\"&C1","v":"Purchase Cost/ton--2017"}]
[null,{"$f":"\"Total Purchase Cost\"&\"--\"&C1","v":"Total Purchase Cost--2017"},{"$f":"IFERROR(C23*C24,\"\")","v":0},{"$f":"IFERROR(D23*D24,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C25:Q25)","v":0}]
[]
["Total Sources, tons",null,{"$f":"IFERROR(C12+C17+C23,\"\")","v":224},{"$f":"IFERROR(D12+D17+D23,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Crop Sales"]
[null,{"$f":"\"Sold\"&\"--\"&C1&\" unit\"","v":"Sold--2017 unit"}]
[null,{"$f":"\"Sold\"&\"--\"&C1&\", tons\"","v":"Sold--2017, tons"},{"$f":"IFERROR(C30*C8/2000,\"\")","v":0},{"$f":"IFERROR(D30*D8/2000,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Sale Price\"&\" \"&C1&\" \"&\"Crop\"&\"--\"&\"/ton\"","v":"Sale Price 2017 Crop--/ton"}]
[null,{"$f":"\"Crop Sales\"&\"--\"&C1","v":"Crop Sales--2017"},{"$f":"IFERROR(C32*C31,\"\")","v":0},{"$f":"IFERROR(D32*D31,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C33:Q33)","v":0}]
[]
["Crop Fed"]
[null,{"$f":"\"Fed\"&\"--\"&C1&\" unit\"","v":"Fed--2017 unit"},{"$f":"IFERROR(C37*2000/C8,\"\")","v":8000},{"$f":"IFERROR(D37*2000/D8,\"\")","v":""},"","","","","","","","","","","","",""]
[null,{"$f":"\"Fed\"&\"--\"&C1&\", tons\"","v":"Fed--2017, tons"},{"$f":"IFERROR(C27-C42-C31,\"\")","v":224},{"$f":"IFERROR(D27-D42-D31,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Value of Crop Fed\"&\"--\"&C1","v":"Value of Crop Fed--2017"},{"$f":"IFERROR((C37-C22)*C18+C25,\"\")","v":0},{"$f":"IFERROR((D37-D22)*D18+D25,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C38:Q38)","v":0}]
[]
["Ending Inventory"]
[null,{"$f":"\"Ending Inventory\"&\"--\"&D2&\" unit\"","v":"Ending Inventory--1/1/2018 unit"}]
[null,{"$f":"\"Ending Inventory\"&\"--\"&D2&\", tons\"","v":"Ending Inventory--1/1/2018, tons"},{"$f":"C41*C8/2000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Ending Inventory Value\"&\"--\"&D2","v":"Ending Inventory Value--1/1/2018"},{"$f":"C42*C4","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C43:Q43)","v":0}]
[]
["Total uses, tons",null,{"$f":"IFERROR(C31+C42+C37,\"\")","v":224},{"$f":"IFERROR(D31+D42+D37,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Discrepancy",null,{"$f":"IFERROR(C27-C45,\"\")","v":0},{"$f":"IFERROR(D27-D45,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Hay Equivalents"]
[null,"Hay Beginning",{"$f":"IF(C6=\"Hay\",C12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C50:Q51)","v":0}]
[null,"Haylage Beginning",{"$f":"IF(C6=\"Haylage\",C12/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Hay Produced",{"$f":"IF(C6=\"Hay\",C17,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C52:Q53)","v":0}]
[null,"Haylage Produced",{"$f":"IF(C6=\"Haylage\",C17/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Hay Purchased",{"$f":"IF(C6=\"Hay\",C23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C54:Q55)","v":0}]
[null,"Haylage Purchased",{"$f":"IF(C6=\"Haylage\",C23/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R50:R54)","v":0}]
[null,"Hay Sold",{"$f":"IF(C6=\"Hay\",C31,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C56:Q57)","v":0}]
[null,"Haylage Sold",{"$f":"IF(C6=\"Haylage\",C31/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Hay Fed",{"$f":"IF(C6=\"Hay\",C37,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C58:Q59)","v":0}]
[null,"Haylage Fed",{"$f":"IF(C6=\"Haylage\",C37/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Hay Ending",{"$f":"IF(C6=\"Hay\",C42,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C60:Q61)","v":0}]
[null,"Haylage Ending",{"$f":"IF(C6=\"Haylage\",C42/2,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(R56:R60)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R55-R61","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hay"]
[null,"Haylage"]
[null,"Grain"]
[null,"Silage"]
[]
[null,"Bushels"]
[null,"Tons"]
[null,"Lb."]