{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Yield Estimation Calc","Data Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Yield Estimation Calc","index":0,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,1,48,9],[9,1,9,9],[8,1,8,9],[7,1,7,9],[3,1,3,7],[10,1,10,9],[5,1,5,9],[6,1,6,9],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[16,2,16,3],[16,4,16,5],[17,2,17,3],[17,4,17,5],[18,2,18,3],[18,4,18,5],[19,2,19,3],[19,4,19,5],[20,2,20,3],[20,4,20,5],[21,2,21,3],[21,4,21,5],[22,2,22,3],[22,4,22,5],[23,2,23,3],[23,4,23,5],[24,2,24,3],[24,4,24,5],[25,2,25,3],[25,4,25,5],[26,2,26,3],[26,4,26,5],[27,2,27,3],[27,4,27,5],[28,2,28,3],[28,4,28,5],[29,2,29,3],[29,4,29,5],[30,2,30,3],[30,4,30,5],[31,2,31,3],[31,4,31,5],[32,2,32,3],[32,4,32,5],[33,2,33,3],[33,4,33,5],[34,2,34,3],[34,4,34,5],[35,2,35,3],[35,4,35,5],[39,2,39,3],[39,4,39,5],[40,2,40,3],[40,4,40,5],[36,2,36,3],[36,4,36,5],[37,2,37,3],[37,4,37,5],[38,2,38,3],[38,4,38,5]]}
[]
[null,null,null,"Yield Estimation Calculator for Annual Crops"]
[]
[null,"Step 1:  Enter the crop row spacing in inches (leave blank if measuring using a square yard)"]
[null,"Step 2:  Select the crop from the drop down list"]
[null,"Step 3:  Select representative locations in a field, the yield should be assessed separately if the field is highly variable"]
[null,{"$f":"CONCATENATE(\"Step 4: Count the number of viable and harvestable heads (or pods) in a square yard or from all the plants in a representative row \",E13,F13, \" in length\")","v":"Step 4: Count the number of viable and harvestable heads (or pods) in a square yard or from all the plants in a representative row  in length"}]
[null,"Step 5: From the viable heads (or pods) determine the average number of kernels or seeds per pod, using a minimum of 10 heads (or pods)"]
[null,"Step 6: Enter the numbers in the calculator"]
[null,"Step 7: Enter any notes, comments, or labels, if you plan to repeat for multiple fields or parts of fields."]
[null,"Step 8: If you are planning to put an insured crop to alternate use, contact AFSC to arrange for an inspection."]
[]
[null,{"$f":"IF(ISNUMBER(I4),\"1 square yard =\",\"\")","v":""},{"$f":"IFERROR(36*36/I4/12,\"\")","v":""},{"$f":"IF(ISNUMBER(I4),\"feet of row to count =\",\"\")","v":""},null,{"$f":"IFERROR(ROUNDDOWN(C13,0)&\" feet, \"&ROUND((C13-ROUNDDOWN(C13,0))*12,2)&\" inches\",\"\")","v":""}]
[]
[null,"Crop",{"$f":"IF(I4=0,\"head or pods per sq  yard\",\"heads or pods / \" & F13  &  \" of row\")","v":"head or pods per sq  yard"},null,"seeds per head or pod",null,null,"Kg/ac","Bu/ac","Notes"]
[null,"Select Crop",null,null,null,null,null,{"$f":"IF(OR($B16=\"SELECT CROP\",B16=\"\"),\"\",(ROUND((C16*E16/VLOOKUP($B16,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H16*VLOOKUP($B16,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B17=\"SELECT CROP\",B17=\"\"),\"\",(ROUND((C17*E17/VLOOKUP($B17,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H17*VLOOKUP($B17,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B18=\"SELECT CROP\",B18=\"\"),\"\",(ROUND((C18*E18/VLOOKUP($B18,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H18*VLOOKUP($B18,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B19=\"SELECT CROP\",B19=\"\"),\"\",(ROUND((C19*E19/VLOOKUP($B19,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H19*VLOOKUP($B19,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B20=\"SELECT CROP\",B20=\"\"),\"\",(ROUND((C20*E20/VLOOKUP($B20,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H20*VLOOKUP($B20,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(C21*E21/VLOOKUP($B21,'Data Table'!$A$2:$E$55,2,FALSE)*4840,0),\"\")","v":""},{"$f":"IFERROR(ROUND(H21*VLOOKUP($B21,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND(C22*E22/VLOOKUP($B22,'Data Table'!$A$2:$E$55,2,FALSE)*4840,0),\"\")","v":""},{"$f":"IFERROR(ROUND(H22*VLOOKUP($B22,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B23=\"SELECT CROP\",B23=\"\"),\"\",(ROUND((C23*E23/VLOOKUP($B23,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H23*VLOOKUP($B23,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B24=\"SELECT CROP\",B24=\"\"),\"\",(ROUND((C24*E24/VLOOKUP($B24,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H24*VLOOKUP($B24,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B25=\"SELECT CROP\",B25=\"\"),\"\",(ROUND((C25*E25/VLOOKUP($B25,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H25*VLOOKUP($B25,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B26=\"SELECT CROP\",B26=\"\"),\"\",(ROUND((C26*E26/VLOOKUP($B26,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H26*VLOOKUP($B26,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B27=\"SELECT CROP\",B27=\"\"),\"\",(ROUND((C27*E27/VLOOKUP($B27,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H27*VLOOKUP($B27,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B28=\"SELECT CROP\",B28=\"\"),\"\",(ROUND((C28*E28/VLOOKUP($B28,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H28*VLOOKUP($B28,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B29=\"SELECT CROP\",B29=\"\"),\"\",(ROUND((C29*E29/VLOOKUP($B29,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H29*VLOOKUP($B29,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B30=\"SELECT CROP\",B30=\"\"),\"\",(ROUND((C30*E30/VLOOKUP($B30,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H30*VLOOKUP($B30,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B31=\"SELECT CROP\",B31=\"\"),\"\",(ROUND((C31*E31/VLOOKUP($B31,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H31*VLOOKUP($B31,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B32=\"SELECT CROP\",B32=\"\"),\"\",(ROUND((C32*E32/VLOOKUP($B32,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H32*VLOOKUP($B32,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B33=\"SELECT CROP\",B33=\"\"),\"\",(ROUND((C33*E33/VLOOKUP($B33,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H33*VLOOKUP($B33,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B34=\"SELECT CROP\",B34=\"\"),\"\",(ROUND((C34*E34/VLOOKUP($B34,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H34*VLOOKUP($B34,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B35=\"SELECT CROP\",B35=\"\"),\"\",(ROUND((C35*E35/VLOOKUP($B35,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H35*VLOOKUP($B35,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B36=\"SELECT CROP\",B36=\"\"),\"\",(ROUND((C36*E36/VLOOKUP($B36,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H36*VLOOKUP($B36,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B37=\"SELECT CROP\",B37=\"\"),\"\",(ROUND((C37*E37/VLOOKUP($B37,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H37*VLOOKUP($B37,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B38=\"SELECT CROP\",B38=\"\"),\"\",(ROUND((C38*E38/VLOOKUP($B38,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H38*VLOOKUP($B38,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B39=\"SELECT CROP\",B39=\"\"),\"\",(ROUND((C39*E39/VLOOKUP($B39,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H39*VLOOKUP($B39,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B40=\"SELECT CROP\",B40=\"\"),\"\",(ROUND((C40*E40/VLOOKUP($B40,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H40*VLOOKUP($B40,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(OR($B41=\"SELECT CROP\",B41=\"\"),\"\",(ROUND((C41*E41/VLOOKUP($B41,'Data Table'!$A$2:$E$55,2,FALSE))*4840,0)))","v":""},{"$f":"IFERROR(ROUND(H41*VLOOKUP($B41,'Data Table'!$A$1:$D$55,3,FALSE),1),\"\")","v":""}]
[]
[]
[null,"Yield Calculation Formulas"]
[null,"Yield (kg/ac) = heads or pod / sqyd x seeds/head or pod x 4840 sqyd/ac / seeds/kg"]
[null,"Bushels/ac = kg/ac x crop factor for bu/kg"]
[]
[]
[null,"Disclaimer: By using this calculator, you are agreeing to the following terms and conditions. This calculator is provided for informational and illustrative purposes only and is not intended to be a substitute for professional advice or your own independent decision making. While efforts have been made to ensure the reliability of the information contained in this calculator, you are relying on the results from this calculator at your own risk as it is based on the accuracy and completeness of the data you have entered. Agriculture Financial Services Corporation (AFSC) makes no express or implied representations or warranties as to the correctness or quality of results generated by this calculator. AFSC assumes no liability to you or to any third party with respect to your, or anyone else’s, use of this calculator. By using this calculator, you hereby agree to release and discharge AFSC from all liability for any losses or damages arising from any errors or omissions in any information or results, or any action or decision made by you in reliance on any information or results."]

{"sheet":"Data Table","index":1,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
["Name","sd/kg","Kg2Bu","seeds","unit"]
["Alfalfa (for seed)",485000,3.6743999999999999E-2,"seeds","pod"]
["Barley 2 Row",26924,4.4091999999999999E-2,"seeds","head"]
["Barley 6 Row",28355,4.4091999999999999E-2,"seeds","head"]
["Barley Hulless 2 Row",27890,4.4091999999999999E-2,"seeds","head"]
["Barley Hulless 6 Row",30804,4.4091999999999999E-2,"seeds","head"]
["Camelina",933310,4.4091999999999999E-2,"seeds","pod"]
["Canary Seed",136036,4.4091999999999999E-2,"seeds","head"]
["Canola - Argentine",319522,4.4091999999999999E-2,"seeds","pod"]
["Canola - Polish",407000,4.4091999999999999E-2,"seeds","pod"]
["Chick Pea-Desi",4080,3.6743999999999999E-2,"seeds","pod"]
["Chick Pea-Kabuli",3056,3.6743999999999999E-2,"seeds","pod"]
["Creeping Red Fescue",826000,0.1575,"seeds","head"]
["Dry Beans  Black",3530,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans  Red",3223,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Canario",2743,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Cranberry",2250,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Great Northern",2892,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Navy",4762,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Pink",3930,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Pinto",2624,3.6743999999999999E-2,"seeds","pod"]
["Dry Beans Yellow",2445,3.6743999999999999E-2,"seeds","pod"]
["Faba Beans",2306,3.6743999999999999E-2,"seeds","pod"]
["Flax",192169,3.9366999999999999E-2,"seeds","boll"]
["Hemp",{"$f":"27000*2.204","v":59508.000000000007},5.0104999999999997E-2,"seeds","cluster"]
["Lentils - Small Green",29900,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Medium Green",19200,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Large Green",14600,3.6743999999999999E-2,"seeds","pod"]
["Lentils - French Green",27400,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Extra Small Red",33400,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Small Red",25100,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Medium Red",20000,3.6743999999999999E-2,"seeds","pod"]
["Lentils - Large Red",18300,3.6743999999999999E-2,"seeds","pod"]
["Mustard - Brown",397838,4.4091999999999999E-2,"seeds","pod"]
["Mustard - Oriental",397838,4.4091999999999999E-2,"seeds","pod"]
["Mustard - Yellow",185659,4.4091999999999999E-2,"seeds","pod"]
["Oats - Average",30482,null,"seeds","head"]
["Oats - Hulless",32937,null,"seeds","head"]
["Peas - Small",8527,3.6743999999999999E-2,"seeds","pod"]
["Peas - Medium",4969,3.6743999999999999E-2,"seeds","pod"]
["Peas - Large",4207,3.6743999999999999E-2,"seeds","pod"]
["Rye",36899,3.9366999999999999E-2,"seeds","head"]
["Soybeans",6698,3.6743999999999999E-2,"seeds","pod"]
["Timothy",2700000,0.05,"seeds","head"]
["Triticale",24638,4.2396000000000003E-2,"seeds","head"]
["Wheat HRS",32220,3.6743999999999999E-2,"seeds","head"]
["Wheat CPS",28156,3.6743999999999999E-2,"seeds","head"]
["Wheat Durum ",25584,3.6743999999999999E-2,"seeds","head"]
["Wheat ES",25674,3.6743999999999999E-2,"seeds","head"]
["Wheat Hard White",33188,3.6743999999999999E-2,"seeds","head"]
["Wheat Northern Hard Red",30188,3.6743999999999999E-2,"seeds","head"]
["Wheat Soft White Spring",29167,3.6743999999999999E-2,"seeds","head"]
["Wheat Special Purpose",30188,3.6743999999999999E-2,"seeds","head"]
["Wheat Winter",33417,3.6743999999999999E-2,"seeds","head"]
["Select Crop",1,null,null,"head"]