{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sugar Beet Production Worksheet","Draft changes for 2021","Data Validations"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":39,"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":"Sugar Beet Production Worksheet","index":0,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,11,0,13],[10,2,10,4],[9,2,9,4],[6,1,6,13],[19,9,19,10],[15,9,15,10],[16,9,16,10],[7,1,7,13],[8,2,8,4],[8,6,8,7],[9,11,9,12],[9,5,9,6],[11,9,11,13],[29,9,29,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[25,9,25,10],[30,9,30,10],[10,5,10,6],[12,1,12,7],[12,9,12,13],[13,9,13,10],[11,1,11,7],[26,1,26,3],[26,9,26,10],[27,1,27,3],[27,9,27,10],[28,1,28,3],[17,9,17,10],[18,9,18,10],[14,9,14,10],[30,1,30,3],[29,1,29,3],[39,1,39,3],[38,1,38,3],[35,9,35,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[37,1,37,13],[33,12,35,13],[35,1,35,7],[36,9,36,10],[31,1,31,3],[31,5,31,6],[32,1,33,6]]}
[null,null,null,null,null,null,null,null,null,null,null,"Save and/or print, if needed, before hitting 'Clear'",null,null,"HIDE","HIDE"]
[]
[]
[]
[]
[]
[null,"Input content in the cells that are this color.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N10-66","v":-66}]
[null,"Sugar Beet Production Reporting Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N10-46","v":-46}]
[null,"Insured Name: ",null,null,null,"Agency: ",null,null,null,"Policy Number: ",null,null,"Crop Year:  ",null,null,{"$f":"_xlfn.CONCAT(\"_\",N9)","v":"_"}]
[null,"Unit EH Acres: ",null,null,null,"Unit Non-EH Acres:  ",null,null,null,"Unit Total Acres: ",{"$f":"SUM(C10+H10)","v":0},"End of Insurance Period:  "]
[null,"Unit Number: ",null,null,null,"Legal Description:  ",null,null,null,null,null,null,"Unit Approved Yield:  "]
[null,{"$f":"IF(OR(G15>65,G16>65, G17>65,G18>65,G19>65,G20>65,G21>65,G22>65,G23>65, G24>65),\"EH days appears excessive.  Are you sure you've entered the correct EH date?\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(C10<(K10*0.15),\"EH Minimum 15% of Unit Acreage not achieved.  Enter in Non-EH section.\", \"\")","v":""},null,null,null,null,null,{"$f":"IF(J12=\"\",1,2)","v":1}]
[null,"Early Harvested (EH) Acreage and Production",null,null,null,null,null,null,null,"Non-Early Harvested Acreage and Production"]
[null,"Entity/Farm Name","Early Harvest Date (m/d/yyyy)","Early Harvest Net Tons","Early Harvest Sugar %","Early Harvest Lbs. of Raw Sugar","Early Harvest Days Early Factor","Early Harvest Adjusted  Lbs. of Raw Sugar               ",null,"Entity/Farm Name",null,"   Stockpile Net Tons (Non-EH)","   Non-EH Sugar %"," Lbs. Raw Sugar  (Non-EH)                       "]
[null,null,null,null,null,{"$f":"IFERROR(IF(D15=\"\",\"\",(ROUND(ROUND(D15,2)*2000*ROUND(E15,3),0))),0)","v":""},{"$f":"IFERROR(IF(C15=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C15),\"\")","v":0},{"$f":"IFERROR(IF(F15=0,\"\",ROUND(F15*(1+(G15/100)),0)),0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(L15=\"\",\"\",ROUND(ROUND(L15,2)*2000*ROUND(M15,3),0)),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(D16=\"\",\"\",(ROUND(ROUND(D16,2)*2000*ROUND(E16,3),0))),0)","v":""},{"$f":"IFERROR(IF(C16=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C16),\"\")","v":0},{"$f":"IFERROR(IF(F16=0,\"\",ROUND(F16*(1+(G16/100)),0)),0)","v":0},null,null,null,null,null,{"$f":"IFERROR(IF(L16=\"\",\"\",ROUND(ROUND(L16,2)*2000*ROUND(M16,3),0)),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(D17=\"\",\"\",(ROUND(ROUND(D17,2)*2000*ROUND(E17,3),0))),0)","v":""},{"$f":"IFERROR(IF(C17=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C17),\"\")","v":0},{"$f":"IFERROR(IF(F17=0,\"\",ROUND(F17*(1+(G17/100)),0)),0)","v":0},null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C18=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C18),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C19=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C19),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C20=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C20),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C21=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C21),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C22=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C22),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C23=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C23),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,null,null,"",{"$f":"IFERROR(IF(C24=\"\",0,$N$10-VLOOKUP($N$10,'Data Validations'!$E$15:$F$34,2,0)-C24),\"\")","v":0},0,null,null,null,null,null,""]
[null,null,null,{"$f":"SUM(D15:D24)","v":0},null,{"$f":"SUM(F15:F24)","v":0},null,{"$f":"ROUND(SUM(H15:H24),0)","v":0},null,null,null,{"$f":"SUM(L15:L24)","v":0},null,{"$f":"SUM(N15:N24)","v":0}]
[]
[null,"Unit Early Harvest Summary",null,null,"EH Prod","EH Acres","EH Yield",null,null,"Unit Non-Early Harvest Summary",null,"Non-EH Prod","Non-EH Acres","Non-EH Yield"]
[null,"Unadjusted Early Harvested Production and Yield/Acre: ",null,null,{"$f":"F25","v":0},{"$f":"C10","v":0},{"$f":"IFERROR(ROUND(E28/F28,3),0)","v":0},null,null,"Non-EH Prod and Yield/Acre",null,{"$f":"N25","v":0},{"$f":"H10","v":0},{"$f":"IFERROR(ROUND(L28/M28,0),0)","v":0}]
[null,"Adjusted Early Harvested Production and Yield/Acre: ",null,null,{"$f":"H25","v":0},{"$f":"C10","v":0},{"$f":"IFERROR(ROUND(E29/F29,3),0)","v":0}]
[null," Approved Yield Cap: ",null,null,{"$f":"F30*G30","v":0},{"$f":"C10","v":0},{"$f":"N11","v":0},null,null,"Unit Harvest Summary",null,{"$f":"C11","v":0}]
[null,"Non Early Harvest Actual Yield Cap: ",null,null,{"$f":"ROUND(G31*F31,0)","v":0},{"$f":"C10","v":0},{"$f":"ROUND(N28,3)","v":0},null,null,"Total Net Tons: ",null,{"$f":"D25+L25","v":0}]
[null,"* Production Allowed for Early Harvested acres: ",null,null,{"$f":"ROUND(E44,6)*ROUND(F31,3)","v":0},"               To Unit Harvest Summary ",null,null,null,"Allowable EH Production: ",null,{"$f":"E32","v":0}]
[null,"* Uses actual EH Production if yield is > Approved yield and > Non EH Actual Yield. If not, uses Adjusted EH Production not to exceed higher of Approved yield Production or Non EH Actual yield Production.",null,null,null,null,null,null,null,"Non-EH Production : ",null,{"$f":"L28","v":0}]
[null,null,null,null,null,null,null,null,null,"Total Unit Production: ",null,{"$f":"SUM(L32:L33)","v":0},"    Carry to Production Certification Form"]
[null,null,null,null,null,null,null,null,null,"Total Unit Acres: ",null,{"$f":"K10","v":0}]
[null,"Expected use limited to one unit per page.  If more rows are needed to complete the unit, please start a new page.",null,null,null,null,null,null,null,"Unit Yield/Acre: ",null,{"$f":"IFERROR(L34/L35,0)","v":0}]
[]
[null,"The use of this Sugar Beet Production Reporting Worksheet is for informational purposes only and is not a statement of contract, binder, or agreement to extend insurance coverage. Although all reasonable efforts have been made to ensure the spreadsheet is accurate, FMH makes no warranties, expressed or implied, or representations as to the accuracy of the information provided by the spreadsheet. This worksheet does not constitute an acceptable production record to support your production certification. You must maintain acceptable production evidence supporting your certification as defined under the record retention requirements of the Common Crop Insurance Policy. This worksheet shall not be used in any manner by an agent or agency to assist policyholders with determining and/or allocating crop production with respect to a claim for indemnity under a Federally reinsured crop insurance policy."]
[]
[]
[]
[null,null,null,"Calcs used in E32",{"$f":"ROUND(MAX(G28,G30,G31),3)","v":0}]
[null,null,null,"Calcs used in E32",{"$f":"ROUND(IF(G29>MAX(G30,G31),MAX(G30,G31),G29),6)","v":0}]
[null,null,null,"New 9/16/20",{"$f":"ROUND(IF(E42>G29,G29,E42),3)","v":0}]

{"sheet":"Draft changes for 2021","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":true,"merged":[[7,0,8,10],[4,0,4,2],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2]]}
["Unit Early Harvest Summary",null,null,"EH Prod","EH Acres","EH Yield"]
["Early Harvested Production and Yield/Acre: ",null,null,53040,25.11,2112.31]
["Adjusted Early Harvested Production and Yield/Acre: ",null,null,61308,25.11,2442]
[" Approved Yield Cap: ",null,null,55543.32,25.11,2212]
["Non EH Actual Yield Cap:",null,null,56272,25.11,2241]
["* Production Allowed for Early Harvested acres: ",null,null,56272,"To Unit Harvest Summary "]
[]
["* Uses actual EH Production if yield is > Approved yield and > Non EH Actual yield.     If not, uses lesser of Adjusted EH  Production not to exceed higher of or Approved yield Production or Non EH Actual yield Production.  "]

{"sheet":"Data Validations","index":2,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["mi","2019-10-15",null,null,null,null,null,"11/21/23 - Questions for Grant"]
[null,null,null,null,null,null,null,"Are the End of Insurance Periods still accurate for 2023 and 2024? Yes"]
[{"$f":"'Sugar Beet Production Worksheet'!N10","v":"00:00:00"},null,null,null,null,null,null,"Do we still need to show 2020, 2021 or 2022?"]
[null,null,null,null,null,null,null,"Do we account for Michigan within this spreadsheet?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Years",null,"Year","End of Insurance Period:  "]
[null,2019,null,2018,"2018-11-15",45]
[null,2020,null,2018,"2018-12-05",45]
[null,2021,null,2019,"2019-11-15",45]
[null,2022,null,2019,"2019-12-05",65,"Only Michigan"]
[null,2023,null,2019,"2019-07-31",45]
[null,2024,null,2020,"2020-11-15",45]
[null,2025,null,2020,"2020-12-05",65,"Only Michigan"]
[null,2026,null,2020,"2020-07-31",45]
[null,2027,null,2021,"2021-11-15",45]
[null,2028,null,2021,"2021-12-05",65,"Only Michigan"]
[null,2029,null,2021,"2021-07-31",45]
[null,null,null,2022,"2022-11-15",45]
[null,null,null,2022,"2022-12-05",65,"Only Michigan"]
[null,null,null,2022,"2022-07-31",45]
[null,null,null,2023,"2023-11-15",45]
[null,null,null,2023,"2023-12-05",65,"Only Michigan"]
[null,null,null,2023,"2023-07-31",45]
[null,null,null,2024,"2024-11-15",45]
[null,null,null,2024,"2024-12-05",65,"Only Michigan"]
[null,null,null,2024,"2024-07-31",45]
[null,null,null,2025,"2025-11-15",45]
[null,null,null,2025,"2025-12-05",65,"Only Michigan"]
[null,null,null,2025,"2025-07-31",45]
[null,null,null,2026,"2026-11-15",45]
[null,null,null,2026,"2026-12-05",65,"Only Michigan"]
[null,null,null,2026,"2026-07-31",45]
[null,null,null,2027,"2027-11-15",45]
[null,null,null,2027,"2027-12-05",65,"Only Michigan"]
[null,null,null,2027,"2027-07-31",45]
[null,null,null,2028,"2028-11-15",45]
[null,null,null,2028,"2028-12-05",65,"Only Michigan"]
[null,null,null,2028,"2028-07-31",45]
[null,null,null,2029,"2029-11-15",45]
[null,null,null,2029,"2029-12-05",65,"Only Michigan"]
[null,null,null,2029,"2029-07-31",45]