{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sugar Beet Production Worksheet","Data Validations"],"not_rendered":{"charts":0,"images":2,"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":"Sugar Beet Production Worksheet","index":0,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[29,1,29,3],[29,9,29,10],[30,1,30,3],[30,5,30,6],[39,1,39,3],[35,1,35,13],[38,1,38,3],[34,9,34,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[33,1,33,3],[33,9,33,10],[37,1,37,13],[32,12,34,13],[26,1,26,3],[26,9,26,10],[27,1,27,3],[27,9,27,10],[28,1,28,3],[10,5,10,6],[12,1,12,7],[12,9,12,13],[13,9,13,10],[11,1,11,7],[7,1,7,13],[8,2,8,4],[8,6,8,7],[9,11,9,12],[9,5,9,6],[50,1,50,7],[0,11,0,13],[10,2,10,4],[9,2,9,4],[6,1,6,13],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[25,9,25,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[14,9,14,10]]}
[null,null,null,null,null,null,null,null,null,null,null,"Save and/or print, if needed, before hitting 'Clear'"]
[]
[]
[]
[]
[]
[null,"Input content in the cells that are this color."]
[null,"Sugar Beet Production Reporting Worksheet (Crop Year 2019)"]
[null,"Insured Name: ",null,null,null,"Agency: ",null,null,null,"Policy Number: ",null,null,"Crop Year: ",2019,null,{"$f":"_xlfn.CONCAT(\"_\",N9)","v":"_2019"}]
[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>60,G16>60, G17>60,G18>60,G19>60,G20>60,G21>60,G22>60,G23>60, G24>60),\"EH days appears excessive.  Are you sure you've entered the correct EH date?\",\"\")","v":""}]
[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 (mm/dd/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(D15*2000*ROUND(E15,3),0))),0)","v":""},{"$f":"IFERROR(IF(C15=\"\",0,$N$10-45-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(L15*2000*ROUND(M15,3),0)),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(IF(D16=\"\",\"\",(ROUND(D16*2000*ROUND(E16,3),0))),0)","v":""},{"$f":"IFERROR(IF(C16=\"\",0,$N$10-45-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(L16*2000*ROUND(M16,3),0)),\"\")","v":""}]
[null,null,null,null,null,"",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,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",0,0,null,null,null,null,null,""]
[null,null,null,null,null,"",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,"Early Harvested Production and Yield/Acre: ",null,null,{"$f":"F25","v":0},{"$f":"C10","v":0},{"$f":"IFERROR(ROUND(E28/F28,2),0)","v":0},null,null,"Non-EH Prod and Yield/Acre",null,{"$f":"N25","v":0},{"$f":"H10","v":0},{"$f":"IFERROR(L28/M28,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,0),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,"* Production Allowed for Early Harvested acres: ",null,null,{"$f":"IFERROR(IF(G28>G30,(G28*C10),MIN(E29:E30)),0)","v":0},"To Unit Harvest Summary ",null,null,null,"Allowable EH Production: ",null,{"$f":"E31","v":0}]
[null,"* Uses actual EH Production if yield is > Approved yield.   If not, uses lesser of Adjusted EH  Production  or Approved 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(L31:L32)","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,null,null,null,null,null,null,null,null,"Unit Yield/Acre: ",null,{"$f":"IFERROR(L33/L34,0)","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,"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,{"$f":"IF(OR(G54>60,G55>60, G56>60, G57>60, G58>60, G59>60, G60>60, G61>60, G62>60, G63>60, G64>60, G65>60, G66>60, G67>60, G68>60, G69>60, G70>60, G71>60, G72>60, G73>60, G74>60,G75>60, G76>60, G77>60),\"EH days appears excessive.  Are you sure you've entered the correct EH date?\",\"OK\")","v":"OK"}]

{"sheet":"Data Validations","index":1,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["mi","2019-10-15"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,2018,"2018-11-15"]
[null,null,null,2018,"2018-12-05"]
[null,null,null,2019,"2019-11-15"]
[null,null,null,2019,"2019-12-05"]
[null,null,null,2019,"2019-07-31"]
[null,null,null,2020,"2020-11-15"]
[null,null,null,2020,"2020-12-05"]
[null,null,null,2020,"2020-07-31"]
[null,null,null,2021,"2021-11-15"]
[null,null,null,2021,"2021-12-05"]
[null,null,null,2021,"2021-07-31"]
[null,null,null,2022,"2022-11-15"]
[null,null,null,2022,"2022-12-05"]
[null,null,null,2022,"2022-07-31"]