{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Intro","Start Sheet","FSA-156EZ","FSA-578-2012","FSA-578-2011","FSA-578-2010","FSA-578-2009","FSA-578-2008","Acreage Summary Sheet","Cotton Yield Sheet","2018 Seed Cotton Base Sheet","Final Seed Cotton Base Decision"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":6,"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":"Intro","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,8,10]]}

{"sheet":"Start Sheet","index":1,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,46,13],[9,2,11,12],[9,1,15,1],[19,2,19,12],[0,0,7,13],[12,2,15,13],[17,2,17,3],[17,5,17,12],[35,2,35,7],[37,2,37,7],[20,2,20,3],[24,2,24,4],[24,5,26,13],[28,2,28,4],[31,2,31,7],[33,2,33,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"!!!","Before starting this spreadsheet program, please make sure that you have read the worksheet \"Intro\" to fully understand the calculation instruction.  "]
[]
[]
[null,null,"This spreadsheet uses Macros. First time this spreadsheet is opened, please enable the use of Macros and then save it on your computer Desktop before proceeding to Step 1. The file name will be \"2018 Seed Cotton Generic Base And Payment Yield Updating Calculator.xlsm\" Since Macros are embedded into this spreadsheet, you may need to save it as an embedded macro spreadsheet."]
[]
[]
[" "]
[]
[null,"Step 1.","Please click",null,null,"It will create a new folder called \"2018SeedCottonBase\" under C: Drive"]
[" "]
[null,null,"Input Your 2018 Farm Serial Number (FSN)"]
[null,"Step 2."]
[]
[null,"Step 3."]
[]
[null,"Step 4.","FSA-156 EZ Form Input",null,null,"This Step 4 allows you to input your bases and CC yields for each of the tracts associated with this FSN based on your FSA-156EZ. If the 2018 FSN did not exist for all of the previous years of 2009-2012, you will need to obtain the Tract level information for the years 2009-2012."]
[]
[]
[null,null,null,null,null,"Step 5a.",null,"Step 5b.",null,"Step 5c.",null,"Step 5d.",null,"Step 5e."]
[null,"Step 5.","FSA-578 Form Input",null,null,2012,null,2011,null,2010,null,2009,null,2008]
[]
[]
[null,"Step 6.","Acreage Summary Sheet"]
[]
[null,"Step 7.","Cotton Yields Sheet"]
[]
[null,"Step 8.","2018 Seed Cotton Base Sheet"]
[]
[null,"Step 9.","Final Seed Cotton Base Decision"]
[]
[]
[null,"Version 1, Feb 13, 2018  The calculator was developed by the NCPC after reviewing the text of the seed cotton provision in the recently passed budget agreement and disaster aid package. The contents followed the procedures outlined in the 2014 Farm Bill for the other covered commodities payment yield updating and base reallocation provisions. Thus, the NCPC was able to utilize their previous decision aid built in 2014 that was based on the 2014 Farm Bill. Funding for the development of this decision tool was from Georgia peanut producers checkoff to the Georgia Peanut Commission and the National Peanut Board. Funding from peanut producers of Alabama, Florida, Mississippi and Texas also aided in the development of the decision aid."]

{"sheet":"FSA-156EZ","index":2,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,1],[17,2,17,3],[18,2,18,3],[17,4,17,5],[18,4,18,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[]
["Step 1.","How Many Tracts Under This FSN?",null,"Enter the Total Number of Tracts for This FSN"]
[]
["Step 2.","Click the Add Tracts Button",null,"This Creates the Number of Tracts for Each Worksheet Needed for Inputting the Data"]
[]
["Step 3.","Input Each Tract Number and the Associated Base Acreage by Crop. For CC Yield, only cotton CC Yield is required and input the 2013 cotton CC Yield for the respective tract."]
[]
["Step 4a.","Click the Summary Button",null,"To Get Summary of Base Acreage and Weighted CC Yield for the FSN After Completing the Tract Data."]
[]
["Step 4b.","Double Check the FSN Base Acreage and the cotton CC Yield that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 5.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 6.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Base Acreage and CC Yield Input (1)"]
[null,"Tract","FSN Summary",null,"Tract1"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Covered Crops + Cotton(Generic)","Base Acreage","CC Yields","Base Acreage","CC Yields"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Generic(Cotton)"]
[null,"Total Base Acres "]
[]
[null,"Note: (1) Existing Base Can Be Found on Form FSA-156EZ for that FSN and the Associated Tracts."]

{"sheet":"FSA-578-2012","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[19,2,19,3],[18,4,18,6],[17,4,17,6],[19,4,19,6],[0,0,0,1],[2,0,2,1],[1,3,2,14],[17,2,17,3],[18,2,18,3],[16,1,16,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[null,null,null,"Please Check to See That the Number of Tracts Matches the Number Reported Earlier for This FSN. If the 2018 FSN Did Not Exist for 2012, You Will Need to Obtain the Tract Level Information for Those Tracts for the Year 2012"]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0}]
[]
["Step 1.","Click Copy Tracts Button",null,"This Will Copy the Number of Tracts for Each Worksheet Needed for Inputting the Data"]
[]
["Step 2.","Input Each Tract Number's 2012 Planted and Prevented Planted Acres. For Proven Yield, Only Cotton Yield Is Required And Input The Cotton  Yield for the Respective Tract."]
[]
["Step 3a.","Click the Summary Button",null,"To Get 2012 FSN Summary of Planted and Prevented Planted Acres and the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 3b.","Double Check the FSN Planted and Prevented Planted Acres that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 4.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 5.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Planted and Prevented Planted Acres(1) and the Cotton Proven Yields(2) in 2012"]
[null,"Tract","FSN Summary",null,"Tract1"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Associated Tract Number for 2012 if 2018 Tract Number did not exist in 2012",{"$f":"C19","v":"FSN - 0"}]
[null,"Covered Crops + Cotton","Planted & Prevented Acres","Proven Yields","Planted Acres","Prevented Acres","Proven Yields"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Cotton"]
[null,"Total Crop Acreage"]
[null,"Note: (1) Planted and Prevented Planted Acres Can Be Found on Form FSA-578 for 2012."]
[null,"         (2) If Proven Yields Are Not Available, Crop Insurance Yields May Be Used. The Cotton Proven Yield Is Based On PLANTED Acres NOT Harvested Acres."]
[null,"              If Proven Yield Is Less Than 75% of The Respective County 5 Year Average, Use 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry.      "]
[null,"              Also, If Tract Level Proven Yields Are Not Available, Input the Farm Serial Number's Proven Yield for Every Tract Listed That Has Acreage Reported."]
[null,"              If Proven Yields Are Not Available, Enter The 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry."]

{"sheet":"FSA-578-2011","index":4,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,3,2,14],[0,0,0,1],[2,0,2,1],[18,2,18,3],[19,2,19,3],[17,2,17,3],[16,1,16,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[null,null,null,"Please Check to See That the Number of Tracts Matches the Number Reported Earlier for This FSN. If the 2018 FSN Did Not Exist for 2011, You Will Need to Obtain the Tract Level Information for Those Tracts for the Year 2011"]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0}]
[]
["Step 1.","The Sheet of FSA-578-2012 Has Already Created the Number of Tracts for 2011 Worksheet Needed for Inputting the Data"]
[]
["Step 2.","Input Each Tract Number's 2011 Planted and Prevented Planted Acres. For Proven Yield, Only Cotton Yield Is Required And Input The Cotton  Yield for the Respective Tract."]
[]
["Step 3a.","Click the Summary Button",null,"To Get 2011 FSN Summary of Planted and Prevented Planted Acres and the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 3b.","Double Check the FSN Planted and Prevented Planted Acres that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 4.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 5.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Planted and Prevented Planted Acres(1) and the Cotton Proven Yields(2) in 2011"]
[null,"Tract","FSN Summary"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Associated Tract Number for 2011 if 2018 Tract Number did not exist in 2011",{"$f":"C19","v":"FSN - 0"}]
[null,"Covered Crops + Cotton","Planted & Prevented Acres","Proven Yields"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Cotton"]
[null,"Total Crop Acreage"]
[null,"Note: (1) Planted and Prevented Planted Acres Can Be Found on Form FSA-578 for 2011."]
[null,"         (2) If Proven Yields Are Not Available, Crop Insurance Yields May Be Used. The Cotton Proven Yield Is Based On PLANTED Acres NOT Harvested Acres."]
[null,"              If Proven Yield Is Less Than 75% of The Respective County 5 Year Average, Use 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry.      "]
[null,"              Also, If Tract Level Proven Yields Are Not Available, Input the Farm Serial Number's Proven Yield for Every Tract Listed That Has Acreage Reported."]
[null,"              If Proven Yields Are Not Available, Enter The 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry."]

{"sheet":"FSA-578-2010","index":5,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,3,2,15],[0,0,0,1],[2,0,2,1],[18,2,18,3],[19,2,19,3],[17,2,17,3],[16,1,16,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[null,null,null,"Please Check to See That the Number of Tracts Matches the Number Reported Earlier for This FSN. If the 2018 FSN Did Not Exist for 2010, You Will Need to Obtain the Tract Level Information for Those Tracts for the Year 2010"]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0}]
[]
["Step 1.","The Sheet of FSA-578-2012 Has Already Created the Number of Tracts for 2010 Worksheet Needed for Inputting the Data"]
[]
["Step 2.","Input Each Tract Number's 2010 Planted and Prevented Planted Acres. For Proven Yield, Only Cotton Yield Is Required And Input The Cotton  Yield for the Respective Tract."]
[]
["Step 3a.","Click the Summary Button",null,"To Get 2010 FSN Summary of Planted and Prevented Planted Acres and the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 3b.","Double Check the FSN Planted and Prevented Planted Acres that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 4.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 5.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Planted and Prevented Planted Acres(1) and the Cotton Proven Yields(2) in 2010"]
[null,"Tract","FSN Summary"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Associated Tract Number for 2010 if 2018 Tract Number did not exist in 2010",{"$f":"C19","v":"FSN - 0"}]
[null,"Covered Crops + Cotton","Planted & Prevented Acres","Proven Yields"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Cotton"]
[null,"Total Crop Acreage"]
[null,"Note: (1) Planted and Prevented Planted Acres Can Be Found on Form FSA-578 for 2010."]
[null,"         (2) If Proven Yields Are Not Available, Crop Insurance Yields May Be Used. The Cotton Proven Yield Is Based On PLANTED Acres NOT Harvested Acres."]
[null,"              If Proven Yield Is Less Than 75% of The Respective County 5 Year Average, Use 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry.      "]
[null,"              Also, If Tract Level Proven Yields Are Not Available, Input the Farm Serial Number's Proven Yield for Every Tract Listed That Has Acreage Reported."]
[null,"              If Proven Yields Are Not Available, Enter The 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry."]

{"sheet":"FSA-578-2009","index":6,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[19,2,19,3],[1,3,2,15],[0,0,0,1],[2,0,2,1],[17,2,17,3],[18,2,18,3],[16,1,16,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[null,null,null,"Please Check to See That the Number of Tracts Matches the Number Reported Earlier for This FSN. If the 2018 FSN Did Not Exist for 2009, You Will Need to Obtain the Tract Level Information for Those Tracts for the Year 2009"]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0}]
[]
["Step 1.","The Sheet of FSA-578-2012 Has Already Created the Number of Tracts for 2009 Worksheet Needed for Inputting the Data"]
[]
["Step 2.","Input Each Tract Number's 2009 Planted and Prevented Planted Acres. For Proven Yield, Only Cotton Yield Is Required And Input The Cotton  Yield for the Respective Tract."]
[]
["Step 3a.","Click the Summary Button",null,"To Get 2009 FSN Summary of Planted and Prevented Planted Acres and the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 3b.","Double Check the FSN Planted and Prevented Planted Acres that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 4.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 5.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Planted and Prevented Planted Acres(1) and the Cotton Proven Yields(2) in 2009"]
[null,"Tract","FSN Summary"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Associated Tract Number for 2009 if 2018 Tract Number did not exist in 2009",{"$f":"C19","v":"FSN - 0"}]
[null,"Covered Crops + Cotton","Planted & Prevented Acres","Proven Yields"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Cotton"]
[null,"Total Crop Acreage"]
[null,"Note: (1) Planted and Prevented Planted Acres Can Be Found on Form FSA-578 for 2009."]
[null,"         (2) If Proven Yields Are Not Available, Crop Insurance Yields May Be Used. The Cotton Proven Yield Is Based On PLANTED Acres NOT Harvested Acres."]
[null,"              If Proven Yield Is Less Than 75% of The Respective County 5 Year Average, Use 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry.      "]
[null,"              Also, If Tract Level Proven Yields Are Not Available, Input the Farm Serial Number's Proven Yield for Every Tract Listed That Has Acreage Reported."]
[null,"              If Proven Yields Are Not Available, Enter The 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry."]

{"sheet":"FSA-578-2008","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[19,2,19,3],[0,0,0,1],[2,0,2,1],[17,2,17,3],[18,2,18,3],[2,3,2,13],[16,1,16,5]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0},"Please Check to See That the Number of Tracts Matches the Number Reported Earlier for This FSN. "]
[]
["Step 1.","The Sheet of FSA-578-2012 Has Already Created the Number of Tracts for 2008 Base Worksheet Needed for Inputting the Data"]
[]
["Step 2.","Input Each Tract Number's 2008 Cotton Planted and Prevented Planted Acres and the Coton Proven Yield."]
[]
["Step 3a.","Click the Summary Button",null,"To Get 2008 FSN Summary of Planted and Prevented Planted Acres and the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 3b.","Double Check the FSN Planted and Prevented Planted Acres that Should Be Matched With Your Records, Otherwise, Please Check with County FSA Personnel              "]
[]
["Step 4.","Click the Save Button              ",null,"To Save All Data Input for This FSN."]
[]
["Step 5.","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[null,"Planted and Prevented Planted Acres(1) and the Cotton Proven Yields(2) in 2008"]
[null,"Tract","FSN Summary"]
[null,"2018 Tract Number #",{"$f":"\"FSN - \" & C1","v":"FSN - 0"}]
[null,"Associated Tract Number for 2008-13 if 2018 Tract Number did not exist in 2008-2013",{"$f":"C19","v":"FSN - 0"}]
[null,"Cotton","Planted & Prevented Acres","Proven Yields"]
[null,2008]
[]
[]
[null,"Note: (1) Planted and Prevented Planted Acres Can Be Found on Form FSA-578 for 2008."]
[null,"         (2) If Proven Yields Are Not Available, Crop Insurance Yields May Be Used. The Cotton Proven Yield Is Based On PLANTED Acres NOT Harvested Acres."]
[null,"              If Proven Yield Is Less Than 75% of The Respective County 5 Year Average, Use 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry.      "]
[null,"              Also, If Tract Level Proven Yields Are Not Available, Input the Farm Serial Number's Proven Yield for Every Tract Listed That Has Acreage Reported."]
[null,"              If Proven Yields Are Not Available, Enter The 75% Of The County's 5 Year (2008-2012) Average Yield For The Proven Yield Entry."]

{"sheet":"Acreage Summary Sheet","index":8,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[24,7,24,9],[19,2,19,6],[12,1,18,6]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21","v":0}]
[]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3","v":0}]
[]
["Step 1.","Click the Summary Button",null,"To Get 2009-2012 FSN Summary of Planted and Prevented Planted Acres."]
[]
["Step 2:","Click the Save Button              ",null,"To Save All Data for this FSN."]
[]
["Step 3:","Click the Print Button              ",null,"To Print This Table"]
[]
["Step 4:","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"FSN - \" & C1","v":"FSN - 0"},"Planted and Prevented Planted Acreage Summary"]
[null,"Covered Crops + Cotton",2009,"2010","2011","2012","Average"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Cotton"]
[null,"Total Crops Acreage"]

{"sheet":"Cotton Yield Sheet","index":9,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[19,9,20,9],[19,8,20,8],[12,1,18,9],[19,2,19,7]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21:D21","v":0}]
[]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3:D3","v":0}]
[]
["Step 1.","Click the Summary Button",null,null,"To Get 2008-2012  FSN Summary of the Weighted Proven Yield by Cotton ONLY"]
[]
["Step 2:","Click the Save Button              ",null,null,"To Save All Data for this FSN"]
[]
["Step 3:","Click the Print Button              ",null,null,"To Print This Table"]
[]
["Step 4:","Click the Start Sheet Button              ",null,null,"To Go Back to the Start Sheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"FSN - \" & C1","v":"FSN - 0"},"Cotton Yields by Year(1)",null,null,null,null,null,"90% of the 5-Year Average Yields(2)","2013 CC Yields(3)"]
[null,"Crop",2008,2009,2010,2011,2012,"Average"]
[null,"Cotton"]
[]
[null,"Note: (1) Obtained From the FSA-578 Worksheets for the Respective Years."]
[null,"         (2)The 90% of the 5-Year (2008-2012) Average Yield Column Provides What the Updated Cotton CC Yield Would Be."]
[null,"         (3) Obtained Cotton Yields From the FSA-156EZ Worksheet."]

{"sheet":"2018 Seed Cotton Base Sheet","index":10,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[18,3,20,3],[11,1,17,6],[18,1,19,1],[18,2,20,2],[18,4,18,6],[19,4,20,4],[19,5,20,5],[19,6,20,6]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21","v":0}]
[]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3","v":0}]
[]
["Step 1.","Click the Summary Button",null,"To Get Current Base and 2009-2012 FSN Summary of Planted and Prevented Planted Acres."]
[]
["Step 2:","Click the Save Button              ",null,"To Save All Data for this FSN."]
[]
["Step 3:","Click the Print Button              ",null,"To Print This Table"]
[]
["Step 4:","Click the Start Sheet Button              ",null,"To Go Back to the Start Sheet"]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"FSN - \" & C1","v":"FSN - 0"},"2018 Base Acreages(1)","4-Year Avg of the Planted & Prevented Acreage(2)","Allocated Base Acreage (Option 2)"]
[null,null,null,null,"% of 4-Year Avg Acres to Total Acres(3)","Generic Base Allocated(4)","Total Base(5)"]
[null,"Covered Crops + Cotton"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Seed Cotton"]
[null,"Generic Base"]
[null,"Total Acres"]
[]
[]
[null,"Note: (1) Obtained From the FSA-156EZ Sheet. There is NO Seed Cotton Base Reports."]
[null,"         (2)Obtained From Acreage Summary Sheet."]
[null,"         (3) The Percentage of Each Crop 4-Year Average Acre Accounted for Total Average Acres."]
[null,"         (4) The Results of Percentage of Each Crop 4-Year Average Acre Times Total Generic Base(C37)."]
[null,"         (5) The Sum of Column C and Column F."]

{"sheet":"Final Seed Cotton Base Decision","index":11,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[19,3,19,4],[19,2,20,2],[12,1,18,4]]}
["2018 This Farm Serial Number is",null,{"$f":"'Start Sheet'!C21","v":0}]
[]
["This FSN Total of Tracts Number(s) are",null,{"$f":"'FSA-156EZ'!C3","v":0}]
[]
["Step 1.","Click the Summary Button",null,"To Get Final Seed Cotton Base Decision."]
[]
["Step 2:","Click the Save Button              ",null,"To Save All Data for this FSN."]
[]
["Step 3:","Click the Print Button              ",null,"To Print This Table"]
[]
["Step 4:","Click Start A New FSN Button              ",null,"To Start a New Farm Series Number For a Farm After Finishing This FSN Farm"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"FSN - \" & C1","v":"FSN - 0"},"2018 Base Acres","Alternative Base Choices(1)"]
[null,"Covered Crops",null,"Option 1 (2)","Option 2 (3)"]
[null,"Barley"]
[null,"Chickpeas"]
[null,"Corn"]
[null,"Dry Beans"]
[null,"Dry Peas"]
[null,"Grain Sorghum"]
[null,"Lentils"]
[null,"Long Grain Rice"]
[null,"Medium Grain Rice"]
[null,"Oats"]
[null,"Other Oilseeds"]
[null,"Peanut"]
[null,"Soybeans"]
[null,"Wheat"]
[null,"Seed Cotton"]
[null,"Unassigned Base"]
[null,"Total Base Acres"]
[]
[null,"Note: (1)Farmer Must Choose Either Option 1 or Option 2 For Their Generic Base Allocation. "]
[null,"         (2)Option 1 Choose the Higher Number Between 80% of Generic Base and 2009-2012 Planted Cotton Averaged Acres, "]
[null,"                     But If Choose the 2009-2012 Planted Cotton Averaged Acres, It Can't Exceed the Generic Base."]
[null,"         (3)Option 2 Copied the Total Bases From 2018 Seed Cotton Base Sheet(Column G)."]