{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Data Entry","AD-3114","AD-3114 (continuation)","AD-3114 Instructions","ECPR_P1","ECPR_P2","ECPR_P3","ECPR_P4","ECPR","ECPR (2)","PAS","data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"Data Entry","index":0,"n_rows":167,"n_cols":30,"rows_kept":167,"cut":false,"hidden":false,"merged":[[0,2,0,6],[26,2,26,6],[39,2,39,7],[2,5,2,6],[6,3,6,6],[13,2,13,6],[5,3,5,6],[61,2,61,3],[11,10,17,10],[9,5,9,6],[7,4,8,7],[7,8,7,10],[41,6,43,7],[62,2,62,3],[60,2,60,9],[9,2,9,3],[65,2,68,10],[4,8,6,9],[61,4,63,10],[7,2,8,3],[63,2,63,3],[47,2,47,7],[4,3,4,6]]}
[null,null,"CFAP Payment Calculator and AD-3114 Generator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Livestock","Nonspecialty","specialty","Value Loss"]
[null,null,"State:",null,"County:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dairy","All Other Cattle","Barley, Malting","Almonds","Aquaculture"]
[null,null,"Producer:",null,null,null,null,{"$f":"TODAY()","v":"2020-06-02"},"CFAP Payment Calculator\nVersion 1.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeder Cattle:  Less Than 600 Pounds","Canola","Apples","Floriculture"]
[null,null,"Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feeder Cattle:  600 Pounds or More","Corn","Artichokes","Nursery"]
[null,null,"City, State, Zip:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slaughter Cattle: Fed Cattle","Cotton, Upland","ASPARAGUS"]
[null,null,"Note: \nAny production/sales/inventory eligible for payment must be subject to price risk.\n\n**Ensure Macros are enabled to make calculator work.",null,{"$f":"L8&L10","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,"This initial payment below is equal to 80% of the gross payment before payment lmiitation and other reductions.",null,null,{"$f":"\"100% of the estimated gross payment before reduction is $\"&L9","v":"100% of the estimated gross payment before reduction is $0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Slaughter Cattle: Mature Cattle","Millet","AVOCADOS"]
[null,null,null,null,null,null,null,null,{"$f":"G12+H12+G26+H26+G39+H39+H60+J60+I60","v":0},null,null,{"$f":"'ECPR (2)'!R4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hogs: 120 Pounds or More","Oats","Beans"]
[null,null,"Part 1:  Dairy Production Information",null,null,null,null,null,null,null,null,".  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pigs:  Less than 120 Pounds","Sorghum","BLUEBERRIES"]
[null,null,null,"January 2020 \n Production","February 2020 \n Production","March 2020 \n Production","80%\nEstimated CARES Gross Payment before payment limits and other reductions","80%\nEstimated CCC Gross Payment  before payment limits and other reductions","80% \nEstimated Total CARES & CCC Gross Payment before payment limits and other reductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lambs and Yearlings: Less than 2 yrs of age","Soybeans","Broccoli"]
[null,null,"Pounds of Production:",null,null,null,{"$f":"IF(AND(D12=\"\",E12=\"\",F12=\"\"),0,ROUND(ECPR!J7,2))","v":0},{"$f":"IF(OR(D12=\"\",E12=\"\",F12=\"\"),0,ROUND(ECPR!N7,2))","v":0},{"$f":"G12+H12","v":0},null,"Note:  \nUser may enter data in light yellow cells on Data Entry sheet.   Remaining cells will autocalculate.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunflowers","Cabbage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat, Durum","CANTALOUPES"]
[null,null,"Part 2:  Non Specialty Crop and Wool",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat, HRS","Carrots"]
[null,null,"Commodity","Unit of Measure","2019 Total Production","2019  Production Not Sold (as of Jan 15, 2020) ","80%\nEstimated CARES Gross Payment before payment limits and other reductions","80%\nEstimated CCC Gross Payment before payment limits and other reductions","80%\nEstimated Total CARES & CCC Gross Payment before payment limits and other reductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(Z18:Z89)=0,0,SUM(Z18:Z89))","v":0},null,"Wool Graded","Cauliflower"]
[null,{"$f":"IF(C16=\"\",\"\",\"Row Crop \"&C16)","v":""},null,{"$f":"ECPR!D11","v":""},null,null,{"$f":"IF(C16=\"\",0,ROUND(ECPR!K11,2))","v":0},{"$f":"IF(D16=\"\",0,ROUND(ECPR!O11,2))","v":0},{"$f":"G16+H16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wool Ungraded","CELERY"]
[null,{"$f":"IF(C17=\"\",\"\",\"Row Crop \"&C17)","v":""},null,{"$f":"ECPR!D12","v":""},null,null,{"$f":"IF(C17=\"\",0,ROUND(ECPR!K12,2))","v":0},{"$f":"IF(D17=\"\",0,ROUND(ECPR!O12,2))","v":0},{"$f":"G17+H17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cucumbers"]
[null,"",null,{"$f":"ECPR!D13","v":""},null,null,{"$f":"IF(C18=\"\",0,ROUND(ECPR!K13,2))","v":0},{"$f":"IF(D18=\"\",0,ROUND(ECPR!O13,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eggplant"]
[null,"",null,{"$f":"ECPR!D14","v":""},null,null,{"$f":"IF(C19=\"\",0,ROUND(ECPR!K14,2))","v":0},{"$f":"IF(D19=\"\",0,ROUND(ECPR!O14,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GARLIC"]
[null,"",null,{"$f":"ECPR!D15","v":""},null,null,{"$f":"IF(C20=\"\",0,ROUND(ECPR!K15,2))","v":0},{"$f":"IF(D20=\"\",0,ROUND(ECPR!O15,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20=\"\",\"\",1)","v":""},null,null,"GRAPEFRUIT"]
[null,"",null,{"$f":"ECPR!D16","v":""},null,null,{"$f":"IF(C21=\"\",0,ROUND(ECPR!K16,2))","v":0},{"$f":"IF(D21=\"\",0,ROUND(ECPR!O16,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"KIWIFRUIT"]
[null,"",null,{"$f":"ECPR!D17","v":""},null,null,{"$f":"IF(C22=\"\",0,ROUND(ECPR!K17,2))","v":0},{"$f":"IF(D22=\"\",0,ROUND(ECPR!O17,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Lemons"]
[null,"",null,{"$f":"ECPR!D18","v":""},null,null,{"$f":"IF(C23=\"\",0,ROUND(ECPR!K18,2))","v":0},{"$f":"IF(D23=\"\",0,ROUND(ECPR!O18,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Lettuce, Iceberg"]
[null,"",null,{"$f":"ECPR!D19","v":""},null,null,{"$f":"IF(C24=\"\",0,ROUND(ECPR!K19,2))","v":0},{"$f":"IF(D24=\"\",0,ROUND(ECPR!O19,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Lettuce, Romaine"]
[null,"",null,{"$f":"ECPR!D20","v":""},null,null,{"$f":"IF(C25=\"\",0,ROUND(ECPR!K20,2))","v":0},{"$f":"IF(D25=\"\",0,ROUND(ECPR!O20,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"MUSHROOMS"]
[null,null,null,null,null,null,{"$f":"SUM(G16:G25)","v":0},{"$f":"SUM(H16:H25)","v":0},{"$f":"SUM(I16:I25)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONIONS, Green"]
[null,null,"Part 3:  Livestock Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onions, Other"]
[null,null,"Livestock  ","Unit of Measure","Jan 15, 2020 - April 15, 2020 Sales of Owned Inventory as of Jan 15, 2020 & Any Offspring From Owned Inventory"," Inventory\n(Highest Between\n April 16, 2020 -  May 14, 2020)","80% \nEstimated CARES Gross Payment before payment limits and other reductions","80%\nEstimated CCC Gross Payment before payment limits and other reductions","80%\nEstimated Total CARES & CCC Gross Payment before payment limits and other reductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oranges"]
[null,{"$f":"\"Livestock \"&C29","v":"Livestock "},null,{"$f":"ECPR!D24","v":""},null,null,{"$f":"IF(OR(C29=\"\",E29=\"\"),0,ROUND(ECPR!G24,2))","v":0},{"$f":"IF(OR(C29=\"\",F29=\"\"),0,ROUND(ECPR!J24,2))","v":0},{"$f":"G29+H29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PAPAYA"]
[null,{"$f":"\"Livestock \"&C30","v":"Livestock "},null,{"$f":"ECPR!D25","v":""},null,null,{"$f":"IF(OR(C30=\"\",E30=\"\"),0,ROUND(ECPR!G25,2))","v":0},{"$f":"IF(OR(C30=\"\",F30=\"\"),0,ROUND(ECPR!J25,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peaches"]
[null,"Livestock ",null,{"$f":"ECPR!D26","v":""},null,null,{"$f":"IF(OR(C31=\"\",E31=\"\"),0,ROUND(ECPR!G26,2))","v":0},{"$f":"IF(OR(C31=\"\",F31=\"\"),0,ROUND(ECPR!J26,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pears"]
[null,"Livestock ",null,{"$f":"ECPR!D27","v":""},null,null,{"$f":"IF(OR(C32=\"\",E32=\"\"),0,ROUND(ECPR!G27,2))","v":0},{"$f":"IF(OR(C32=\"\",F32=\"\"),0,ROUND(ECPR!J27,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pecans"]
[null,"Livestock ",null,{"$f":"ECPR!D28","v":""},null,null,{"$f":"IF(OR(C33=\"\",E33=\"\"),0,ROUND(ECPR!G28,2))","v":0},{"$f":"IF(OR(C33=\"\",F33=\"\"),0,ROUND(ECPR!J28,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C33=\"\",\"\",1)","v":""},null,null,"Peppers, Bell"]
[null,"Livestock ",null,{"$f":"ECPR!D29","v":""},null,null,{"$f":"IF(OR(C34=\"\",E34=\"\"),0,ROUND(ECPR!G29,2))","v":0},{"$f":"IF(OR(C34=\"\",F34=\"\"),0,ROUND(ECPR!J29,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C34=\"\",\"\",1)","v":""},null,null,"Peppers, Other"]
[null,"Livestock ",null,{"$f":"ECPR!D30","v":""},null,null,{"$f":"IF(OR(C35=\"\",E35=\"\"),0,ROUND(ECPR!G30,2))","v":0},{"$f":"IF(OR(C35=\"\",F35=\"\"),0,ROUND(ECPR!J30,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C35=\"\",\"\",1)","v":""},null,null,"POTATOES"]
[null,"Livestock ",null,{"$f":"ECPR!D31","v":""},null,null,{"$f":"IF(OR(C36=\"\",E36=\"\"),0,ROUND(ECPR!G31,2))","v":0},{"$f":"IF(OR(C36=\"\",F36=\"\"),0,ROUND(ECPR!J31,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raspberries"]
[null,"Livestock ",null,{"$f":"ECPR!D32","v":""},null,null,{"$f":"IF(OR(C37=\"\",E37=\"\"),0,ROUND(ECPR!G32,2))","v":0},{"$f":"IF(OR(C37=\"\",F37=\"\"),0,ROUND(ECPR!J32,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rhubarb"]
[null,"Livestock ",null,{"$f":"ECPR!D33","v":""},null,null,{"$f":"IF(OR(C38=\"\",E38=\"\"),0,ROUND(ECPR!G33,2))","v":0},{"$f":"IF(OR(C38=\"\",F38=\"\"),0,ROUND(ECPR!J33,2))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spinach"]
[null,null,null,null,null,null,{"$f":"SUM(G29:G38)","v":0},{"$f":"SUM(H29:H38)","v":0},{"$f":"SUM(I29:I38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squash"]
[null,null,"Part 4:  Value Loss (Aquaculture/Nursery)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strawberries"]
[null,null,"Crop",null,"Value of  Sales (January 15, 2020 - April 15, 2020)","Value of  Inventory (as of April 15, 2020)","Estimated CARES Gross Payment before payment limits and other reductions","Estimated CCC Gross Payment before payment limits and other reductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweet Corn"]
[null,{"$f":"\"Value Loss \"&C42","v":"Value Loss "},null,null,null,null,"To Be Determined",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sweet Potatoes"]
[null,{"$f":"\"Value Loss \"&C43","v":"Value Loss "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TANGERINES"]
[null,{"$f":"\"Value Loss \"&C44","v":"Value Loss "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TARO"]
[null,{"$f":"\"Value Loss \"&C45","v":"Value Loss "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tomatoes"]
[null,{"$f":"\"Value Loss \"&C46","v":"Value Loss "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WALNUTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WATERMELON"]
[null,null,"Part 5:  Specialty Crop"]
[null,null,"Crop","Unit of Measure","Volume of Production Sold \n(Jan 15, 2020 - April 15, 2020)","Volume of Production Shipped but Not Sold  (Jan 15, 2020 -April 15, 2020)","Acres with Production Not Shipped or Sold (Jan 15, 2020 -April 15)","80%\nEstimated CARES Gross Payment  Volume of Prod. Sold, before payment limits and other reductions","80%\nEstimated CARES Gross Payment Volume of Prod. Shipped but Not Sold, before payment limits and other reductions","80%\nEstimated CCC Gross Payment before payment limits and other reductions","80%\nEstimated Total CARES & CCC Gross Payment before payment limits and other reductions"]
[null,{"$f":"\"Specialty Crops \"&C50","v":"Specialty Crops "},null,{"$f":"ECPR!D44","v":""},null,null,null,{"$f":"IF(C50=\"\",0,ROUND(ECPR!I44,2))","v":0},{"$f":"IF(C50=\"\",0,ROUND(ECPR!L44,2))","v":0},{"$f":"IF(OR(C50=\"\",G50=\"\"),0,ROUND(ECPR!H57,2))","v":0},{"$f":"SUM(H50:J50)","v":0},null,null,null,{"$f":"IF(C50=\"\",\"No\",VLOOKUP(B50,$C$99:$T$167,16,FALSE))","v":"No"},{"$f":"IF(C50=\"\",\"No\",VLOOKUP(B50,$C$99:$T$167,17,FALSE))","v":"No"},{"$f":"IF(C50=\"\",\"No\",VLOOKUP(B50,$C$99:$T$167,18,FALSE))","v":"No"}]
[null,{"$f":"\"Specialty Crops \"&C51","v":"Specialty Crops "},null,{"$f":"ECPR!D45","v":""},null,null,null,{"$f":"IF(C51=\"\",0,ROUND(ECPR!I45,2))","v":0},{"$f":"IF(C51=\"\",0,ROUND(ECPR!L45,2))","v":0},{"$f":"IF(OR(C51=\"\",G51=\"\"),0,ROUND(ECPR!H58,2))","v":0},{"$f":"SUM(H51:J51)","v":0},null,null,null,{"$f":"IF(C51=\"\",\"No\",VLOOKUP(B51,$C$99:$T$167,16,FALSE))","v":"No"},{"$f":"IF(C51=\"\",\"No\",VLOOKUP(B51,$C$99:$T$167,17,FALSE))","v":"No"},{"$f":"IF(C51=\"\",\"No\",VLOOKUP(B51,$C$99:$T$167,18,FALSE))","v":"No"}]
[null,"Specialty Crops ",null,{"$f":"ECPR!D46","v":""},null,null,null,{"$f":"IF(C52=\"\",0,ROUND(ECPR!I46,2))","v":0},{"$f":"IF(C52=\"\",0,ROUND(ECPR!L46,2))","v":0},{"$f":"IF(OR(C52=\"\",G52=\"\"),0,ROUND(ECPR!H59,2))","v":0},{"$f":"SUM(H52:J52)","v":0},null,null,null,"No","No","No"]
[null,"Specialty Crops ",null,{"$f":"ECPR!D47","v":""},null,null,null,{"$f":"IF(C53=\"\",0,ROUND(ECPR!I47,2))","v":0},{"$f":"IF(C53=\"\",0,ROUND(ECPR!L47,2))","v":0},{"$f":"IF(OR(C53=\"\",G53=\"\"),0,ROUND(ECPR!H60,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,{"$f":"IF(C53=\"\",\"\",1)","v":""}]
[null,"Specialty Crops ",null,{"$f":"ECPR!D48","v":""},null,null,null,{"$f":"IF(C54=\"\",0,ROUND(ECPR!I48,2))","v":0},{"$f":"IF(C54=\"\",0,ROUND(ECPR!L48,2))","v":0},{"$f":"IF(OR(C54=\"\",G54=\"\"),0,ROUND(ECPR!H61,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,{"$f":"IF(C54=\"\",\"\",1)","v":""}]
[null,"Specialty Crops ",null,{"$f":"ECPR!D49","v":""},null,null,null,{"$f":"IF(C55=\"\",0,ROUND(ECPR!I49,2))","v":0},{"$f":"IF(C55=\"\",0,ROUND(ECPR!L49,2))","v":0},{"$f":"IF(OR(C55=\"\",G55=\"\"),0,ROUND(ECPR!H62,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,""]
[null,"Specialty Crops ",null,{"$f":"ECPR!D50","v":""},null,null,null,{"$f":"IF(C56=\"\",0,ROUND(ECPR!I50,2))","v":0},{"$f":"IF(C56=\"\",0,ROUND(ECPR!L50,2))","v":0},{"$f":"IF(OR(C56=\"\",G56=\"\"),0,ROUND(ECPR!H63,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,""]
[null,"Specialty Crops ",null,{"$f":"ECPR!D51","v":""},null,null,null,{"$f":"IF(C57=\"\",0,ROUND(ECPR!I51,2))","v":0},{"$f":"IF(C57=\"\",0,ROUND(ECPR!L51,2))","v":0},{"$f":"IF(OR(C57=\"\",G57=\"\"),0,ROUND(ECPR!H64,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,""]
[null,"Specialty Crops ",null,{"$f":"ECPR!D52","v":""},null,null,null,{"$f":"IF(C58=\"\",0,ROUND(ECPR!I52,2))","v":0},{"$f":"IF(C58=\"\",0,ROUND(ECPR!L52,2))","v":0},{"$f":"IF(OR(C58=\"\",G58=\"\"),0,ROUND(ECPR!H65,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,""]
[null,"Specialty Crops ",null,{"$f":"ECPR!D53","v":""},null,null,null,{"$f":"IF(C59=\"\",0,ROUND(ECPR!I53,2))","v":0},{"$f":"IF(C59=\"\",0,ROUND(ECPR!L53,2))","v":0},{"$f":"IF(OR(C59=\"\",G59=\"\"),0,ROUND(ECPR!H66,2))","v":0},0,null,null,null,"No","No","No",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H50:H59)","v":0},{"$f":"SUM(I50:I59)","v":0},{"$f":"SUM(J50:J59)","v":0},{"$f":"SUM(K50:K59)","v":0},null,null,null,"No","No","No"]
[null,null,"Part 6: Increased Payment Limitation for Corporations, Limited Liability Companies, and Limited Partnerships"]
[null,null,null,null,"Applicants who are Corporations, Limited Liability Companies, and Limited Partnerships may seek an increase in the per-person payment limitation from $250,000 to either $500,000 or $750,000 based on the number of members, partners, or stockholders who provide 400 hours or more of personal labor or active personal management to the farming operation as defined in 7 CFR Part 1400.  Identify the names of members, partners, or stockholders who provide at least 400 hours of active personal labor or active personal management, or combination thereof, to the farming operation."]
[]
[]
[]
[null,null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Category","Name","Type","Intended Use","Unit of Measure","Part 1 - Rate","Part 2 - Rate","Part 1 - Payment %","Part 1 - Quantity %","Part 2 - Payment %","Part 2 - Quantity %","Part 3 Quanitity","Price 3","Yield","pmt 1","pmt 2","pmt 3"]
[null,null,"Livestock All Other Cattle","Livestock","All Other Cattle",null,null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Feeder Cattle:  600 Pounds or More","Livestock","Feeder Cattle:  600 Pounds or More",">600 Pounds",null,"Head",139,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Feeder Cattle:  Less Than 600 Pounds","Livestock","Feeder Cattle:  Less Than 600 Pounds","<600 Pounds",null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Hogs: 120 Pounds or More","Livestock","Hogs: 120 Pounds or More","Hogs",null,"Head",18,17,0.8,1,0.3,1,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Lambs and Yearlings: Less than 2 yrs of age","Livestock","Lambs and Yearlings: Less than 2 yrs of age",null,null,"Head",33,7,null,null,null,null,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Pigs:  Less than 120 Pounds","Livestock","Pigs:  Less than 120 Pounds","Pigs",null,"Head",28,17,0.8,1,0.3,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Slaughter Cattle: Fed Cattle","Livestock","Slaughter Cattle: Fed Cattle","Fed Cattle",null,"Head",214,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Livestock Slaughter Cattle: Mature Cattle","Livestock","Slaughter Cattle: Mature Cattle","Mature Cattle",null,"Head",92,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Milk","Dairy","Dairy",null,null,"pounds",4.7100000000000003E-2,1.47E-2,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Barley, Malting","Row Crop","Barley, Malting","Malting",null,"bushels",0.34,0.37,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Canola","Row Crop","Canola",null,null,"pounds",0.01,0.01,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Corn","Row Crop","Corn",null,"Grain","bushels",0.32,0.35,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Cotton, Upland","Row Crop","Cotton, Upland","Upland",null,"pounds",0.09,0.1,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Millet","Row Crop","Millet",null,null,"bushels",0.31,0.34,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Oats","Row Crop","Oats",null,null,"bushels",0.15,0.17,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Sorghum","Row Crop","Sorghum",null,null,"bushels",0.3,0.32,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Soybeans","Row Crop","Soybeans",null,"Grain","bushels",0.45,0.5,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Sunflowers","Row Crop","Sunflowers",null,null,"pounds",0.02,0.02,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Wheat, Durum","Row Crop","Wheat, Durum","Durum","Grain","bushels",0.19,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Wheat, HRS","Row Crop","Wheat, HRS","Hard Red Spring","Grain","bushels",0.18,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Wool Graded","Row Crop","Wool Graded",null,null,"pound",0.71,0.78,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Row Crop Wool Ungraded","Row Crop","Wool Ungraded",null,null,"pound",0.36,0.39,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,null,"Specialty Crops Almonds","Specialty","Almonds",null,null,"pounds",0.26,0.56999999999999995,0.8,1,0.3,1,1,0.11,2160,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Apples","Specialty","Apples",null,null,"pounds",0,0.18,0.8,1,null,1,1,0.03,37500,"No","Yes","Yes"]
[null,null,"Specialty Crops Artichokes","Specialty","Artichokes",null,null,"pounds",0.66,0.49,0.8,1,null,1,1,0.1,13000,"Yes","Yes","Yes"]
[null,null,"Specialty Crops ASPARAGUS","Specialty","ASPARAGUS",null,null,"pounds",0,0.38,null,null,null,1,1,7.0000000000000007E-2,3640,"No","Yes","Yes"]
[null,null,"Specialty Crops AVOCADOS","Specialty","AVOCADOS",null,null,"pounds",0,0.14000000000000001,null,null,null,1,1,0.03,5120,"No","Yes","Yes"]
[null,null,"Specialty Crops Beans","Specialty","Beans",null,null,"pounds",0.17,0.16,0.8,1,0.3,1,1,0.03,7793.0233600000001,"Yes","Yes","Yes"]
[null,null,"Specialty Crops BLUEBERRIES","Specialty","BLUEBERRIES",null,null,"pounds",0,0.62,null,null,null,null,1,0.12,6630,"No","Yes","Yes"]
[null,null,"Specialty Crops Broccoli","Specialty","Broccoli",null,null,"pounds",0.62,0.49,0.8,1,0.3,1,1,0.1,15630.000000000002,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Cabbage","Specialty","Cabbage",null,null,"pounds",0.04,7.0000000000000007E-2,0.8,1,null,1,1,0.01,36730,"Yes","Yes","Yes"]
[null,null,"Specialty Crops CANTALOUPES","Specialty","CANTALOUPES",null,null,"pounds",0,0.1,null,null,null,1,1,0.02,23940,"No","Yes","Yes"]
[null,null,"Specialty Crops Carrots","Specialty","Carrots",null,null,"pounds",0.02,0.11,0.8,1,null,1,1,0.02,62570.000000000007,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Cauliflower","Specialty","Cauliflower",null,null,"pounds",0.11,0.31,0.8,1,null,1,1,0.06,22120,"Yes","Yes","Yes"]
[null,null,"Specialty Crops CELERY","Specialty","CELERY",null,null,"pounds",0,7.0000000000000007E-2,null,null,null,1,1,0.01,56000,"No","Yes","Yes"]
[null,null,"Specialty Crops Cucumbers","Specialty","Cucumbers",null,null,"pounds",0.13,0.15,0.8,1,null,1,1,0.03,14830.000000000002,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Eggplant","Specialty","Eggplant",null,null,"pounds",7.0000000000000007E-2,0.15,0.8,1,null,1,1,0.03,13757.083490744239,"Yes","Yes","Yes"]
[null,null,"Specialty Crops GARLIC","Specialty","GARLIC",null,null,"pounds",0,0.85,null,null,null,1,1,0.17,15500,"No","Yes","Yes"]
[null,null,"Specialty Crops GRAPEFRUIT","Specialty","GRAPEFRUIT",null,null,"pounds",0,0.11,null,null,null,1,1,0.02,24838,"No","Yes","Yes"]
[null,null,"Specialty Crops KIWIFRUIT","Specialty","KIWIFRUIT",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,23400,"No","Yes","Yes"]
[null,null,"Specialty Crops Lemons","Specialty","Lemons",null,null,"pounds",0.08,0.21,0.8,1,0.3,1,1,0.04,35600,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Lettuce, Iceberg","Specialty","Lettuce, Iceberg","Iceberg",null,"pounds",0.2,0.15,0.8,1,0.3,1,1,0.03,37600,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Lettuce, Romaine","Specialty","Lettuce, Romaine","Romaine",null,"pounds",7.0000000000000007E-2,0.12,0.8,1,null,1,1,0.02,31180,"Yes","Yes","Yes"]
[null,null,"Specialty Crops MUSHROOMS","Specialty","MUSHROOMS",null,null,"pounds",0,0.59,null,null,null,1,1,0.11,300999.60000000003,"No","Yes","Yes"]
[null,null,"Specialty Crops ONIONS, Green","Specialty","ONIONS, Green",null,null,"pounds",0,0.3,null,null,null,1,1,0.06,29700,"No","Yes","Yes"]
[null,null,"Specialty Crops Onions, Other","Specialty","Onions, Other",null,null,"pounds",0.01,0.05,0.8,1,null,1,1,0.01,54010,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Oranges","Specialty","Oranges",null,null,"pounds",0,0.14000000000000001,0.8,1,null,1,1,0.03,21161,"No","Yes","Yes"]
[null,null,"Specialty Crops PAPAYA","Specialty","PAPAYA",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,17000,"No","Yes","Yes"]
[null,null,"Specialty Crops Peaches","Specialty","Peaches",null,null,"pounds",0.08,0.32,0.8,1,null,1,1,0.06,18320,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Pears","Specialty","Pears",null,null,"pounds",0.08,0.18,0.8,1,null,1,1,0.03,32200,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Pecans","Specialty","Pecans",null,null,"pounds",0.28000000000000003,0.93,0.8,1,null,1,1,0.18,647,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Peppers, Bell","Specialty","Peppers, Bell",null,null,"pounds",0.14000000000000001,0.22,0.8,1,null,1,1,0.04,31680,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Peppers, Other","Specialty","Peppers, Other",null,null,"pounds",0.15,0.22,0.8,1,null,1,1,0.04,16120,"Yes","Yes","Yes"]
[null,null,"Specialty Crops POTATOES","Specialty","POTATOES",null,null,"pounds",0,0.04,null,null,null,1,1,0.01,44900,"No","Yes","Yes"]
[null,null,"Specialty Crops Raspberries","Specialty","Raspberries",null,null,"pounds",0,1.45,null,null,null,1,1,0.28000000000000003,13500,"No","Yes","Yes"]
[null,null,"Specialty Crops Rhubarb","Specialty","Rhubarb",null,null,"pounds",0.15,1.03,0.8,1,0.3,1,1,0.2,1979.1666666666667,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Spinach","Specialty","Spinach",null,null,"pounds",0.37,0.37,0.8,1,0.3,1,1,7.0000000000000007E-2,14600,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Squash","Specialty","Squash",null,null,"pounds",0.72,0.39,0.8,1,0.3,1,1,0.08,31680,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Strawberries","Specialty","Strawberries",null,null,"pounds",0.84,0.72,0.8,1,0.3,1,1,0.14000000000000001,50300,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Sweet Corn","Specialty","Sweet Corn","Sweet",null,"pounds",0.09,0.13,0.8,1,0.3,1,1,0.03,16119.999999999998,"Yes","Yes","Yes"]
[null,null,"Specialty Crops Sweet Potatoes","Specialty","Sweet Potatoes",null,null,"pounds",0,0.18,null,null,null,1,1,0.04,21790,"No","Yes","Yes"]
[null,null,"Specialty Crops TANGERINES","Specialty","TANGERINES",null,null,"pounds",0,0.22,null,null,null,1,1,0.04,30622,"No","Yes","Yes"]
[null,null,"Specialty Crops TARO","Specialty","TARO",null,null,"pounds",0,0.23,null,null,null,1,1,0.05,9630,"No","Yes","Yes"]
[null,null,"Specialty Crops Tomatoes","Specialty","Tomatoes",null,null,"pounds",0.64,0.38,0.8,1,0.3,1,1,7.0000000000000007E-2,87470,"Yes","Yes","Yes"]
[null,null,"Specialty Crops WALNUTS","Specialty","WALNUTS",null,null,"pounds",0,0.45,null,null,null,1,1,0.09,3580,"No","Yes","Yes"]
[null,null,"Specialty Crops WATERMELON","Specialty","WATERMELON",null,null,"pounds",0,0.02,null,null,null,1,1,0,36390,"No","Yes","No"]
[null,null,"Value Loss Aquaculture","Value Loss","Aquaculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[null,null,"Value Loss Floriculture","Value Loss","Floriculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[null,null,"Value Loss Nursery","Value Loss","Nursery",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]

{"sheet":"AD-3114","index":1,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":false,"merged":[[51,14,51,23],[52,14,52,19],[53,11,53,13],[54,11,54,13],[53,14,53,19],[54,14,54,19],[51,0,51,13],[53,20,53,23],[52,11,52,13],[54,0,54,4],[54,5,54,10],[54,20,54,23],[52,0,52,4],[52,5,52,10],[52,20,52,23],[53,0,53,4],[53,5,53,10],[24,3,24,23],[25,3,25,23],[26,1,26,23],[46,0,46,4],[46,13,46,15],[46,16,46,22],[43,0,43,23],[42,0,42,4],[42,5,42,10],[42,11,42,12],[41,0,41,4],[41,5,41,10],[41,11,41,12],[41,13,41,15],[41,16,41,21],[41,22,41,23],[70,0,70,23],[69,0,69,3],[69,4,69,13],[69,14,69,16],[69,18,69,22],[42,13,42,15],[42,16,42,21],[42,22,42,23],[55,0,55,13],[55,14,55,23],[6,13,6,18],[6,19,6,23],[29,0,29,22],[30,0,30,22],[31,0,31,22],[68,0,68,3],[68,4,68,13],[68,14,68,16],[68,18,68,22],[64,0,64,23],[65,0,65,10],[65,11,65,20],[65,21,65,23],[66,0,66,23],[67,0,67,3],[67,4,67,13],[67,14,67,16],[67,17,67,23],[60,0,60,23],[61,0,61,23],[63,0,63,23],[62,11,62,15],[62,8,62,9],[62,1,62,7],[62,17,62,21],[62,22,62,23],[58,18,58,22],[59,0,59,2],[59,3,59,5],[59,6,59,9],[59,10,59,11],[59,18,59,22],[58,0,58,2],[58,3,58,5],[58,6,58,9],[58,10,58,11],[58,12,58,13],[59,12,59,13],[58,14,58,17],[59,14,59,17],[56,18,56,22],[57,0,57,2],[57,3,57,5],[57,6,57,9],[57,10,57,11],[57,18,57,22],[56,0,56,2],[56,3,56,5],[56,6,56,9],[56,10,56,11],[56,12,56,13],[57,12,57,13],[56,14,56,17],[57,14,57,17],[50,0,50,4],[50,13,50,15],[48,0,48,4],[48,13,48,15],[49,0,49,4],[49,13,49,15],[48,5,48,8],[49,5,49,8],[50,5,50,8],[48,9,48,12],[49,9,49,12],[50,9,50,12],[36,2,36,4],[36,5,36,10],[36,11,36,12],[40,0,40,4],[40,5,40,10],[40,11,40,12],[36,13,36,15],[36,16,36,21],[47,0,47,4],[47,13,47,15],[47,16,47,22],[47,5,47,8],[44,0,44,15],[44,16,44,23],[45,0,45,4],[45,13,45,15],[45,16,45,22],[46,5,46,8],[45,5,45,8],[45,10,45,12],[46,10,46,12],[47,9,47,12],[35,22,35,23],[35,0,35,1],[35,2,35,4],[35,5,35,10],[35,11,35,12],[35,13,35,15],[35,16,35,21],[40,22,40,23],[39,0,39,4],[39,5,39,10],[39,11,39,12],[39,13,39,15],[39,16,39,21],[39,22,39,23],[40,13,40,15],[40,16,40,21],[36,22,36,23],[37,0,37,15],[37,16,37,23],[38,0,38,4],[38,5,38,10],[38,11,38,12],[38,13,38,15],[38,16,38,21],[38,22,38,23],[36,0,36,1],[33,22,33,23],[34,0,34,1],[34,2,34,4],[34,5,34,10],[34,11,34,12],[34,13,34,15],[34,16,34,21],[34,22,34,23],[33,0,33,1],[33,2,33,4],[7,1,7,23],[4,1,6,10],[33,5,33,10],[33,11,33,12],[33,13,33,15],[33,16,33,21],[27,0,27,23],[28,0,28,23],[32,0,32,12],[32,13,32,23],[18,3,18,23],[21,3,21,23],[22,3,22,23],[19,1,19,23],[20,1,20,23],[10,1,10,23],[11,1,11,23],[23,3,23,23],[1,0,1,23],[2,0,2,12],[2,13,2,18],[2,19,2,23],[3,0,3,12],[3,13,3,18],[9,0,9,23],[16,3,16,23],[17,3,17,23],[3,19,3,23],[8,0,8,23],[15,3,15,23],[12,1,12,23],[13,1,13,23],[14,1,14,23],[4,13,4,18],[4,19,4,23],[5,13,5,18],[5,19,5,23]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Form Approved - OMB No. 0560-0295"]
["This form is available electronically.                                                                                                                        OMB  Expiration date 11/30/2020"]
["AD-3114            U.S. DEPARTMENT OF AGRICULTURE",null,null,null,null,null,null,null,null,null,null,null,null,"1.   Recording State",null,null,null,null,null,"2.  Program Year"]
["2020-05-19",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!D3=\"\",\"\",'Data Entry'!D3)","v":""},null,null,null,null,null,2020]
[null,"CORONAVIRUS FOOD ASSISTANCE PROGRAM (CFAP) APPLICATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3.  Recording County",null,null,null,null,null,"4. Application Number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!F3=\"\",\"\",'Data Entry'!F3)","v":""}]
["NOTE:","The following statement is made in accordance with the Privacy Act of 1974 (5 USC 552a - as amended). The authority for requesting the information identified on this form is 7 CFR Part 9, the CARES Act (Pub. L. 116-136), and 15 U.S.C. 714b and 714c.  The information will be used to determine eligibility for program benefits.  The information collected on this form may be disclosed to other Federal, State, and Local government agencies, Tribal agencies, and nongovernmental entities that have been authorized access to the information by statute or regulation and/or as described in applicable Routine Uses identified in the System of Records Notice for USDA/FSA-2, Farm Records File (Automated).  Providing the requested information is voluntary.  However, failure to furnish the requested information will result in a determination of ineligibility for program benefits.  Payments may be made under the program to which the form applies only to the extent permitted by applicable authorities.\n\nPublic Burden Statement (Paperwork Reduction Act):  Public reporting burden for this collection is estimated to average 60 minutes per response, including reviewing instructions, gathering and maintaining the data needed, completing (providing the information), and reviewing the collection of information. You are not required to respond to the collection, or USDA may not conduct or sponsor a collection of information unless it displays a valid OMB control number.  RETURN THIS COMPLETED FORM TO YOUR COUNTY FSA OFFICE."]
["PART A – PRODUCER AGREEMENT"]
["The Department of Agriculture (USDA) will make payments under the CFAP to producers who meet the requirements of the program.  The following information is needed in order for USDA to make a determination that the applicant is eligible to receive a CFAP payment.  By submitting this application, and upon approval by USDA, the applicant agrees:"]
["1.","To comply with regulations set forth in 7 CFR Part 9 and any Notice of Funds Availability published by USDA.  Copies of these documents may be found at www.regulations.gov/docket?D=FSA-2020-0004."]
["2.","That a CFAP payment will only be made with respect to a commodity produced in the United States and intended to be marketed for commercial production;"]
["3.","Any production/sales/inventory eligible for payment must be subject to price risk."]
["4.","To provide to USDA all information that is necessary to verify that the information provided on this form is accurate and to allow USDA representative access to all documents and records of the producer, including those in the possession of a third-party such as a warehouse operator, processor or packer;"]
["5.","To comply with maximum payment limitation and adjusted gross income provisions applicable to the CFAP by completing Forms:"]
[null,null,null,"•\t   CCC-902, Farm Operating Plan for Payment Eligibility (NOTE:  Only Parts A and B of the Form are required)."]
[null,null,null,"•\t   CCC-901, Member Information for Legal Entities, if applicable"]
[null,null,null,"•\t   CCC-941, Average Adjusted Gross Income (AGI) Certification and Consent to Disclosure of Tax Information"]
[null,null,null,"•\t   CCC-942, Certification of Income From Farming, Ranching and Forestry Operations, optional"]
["6.","To provide to USDA all information required for program participation within 60 days from the date the applicant signs this application. Failure of an individual, entity, or member of an entity to timely submit all information required may result in no payment or a reduced payment."]
["7A.","To comply with the provisions of the Food Security Act of 1985 that protect highly erodible land and wetlands. All applicants must complete and submit all portions of form AD-1026, Highly Erodible Land Conservation (HELC) and Wetland Conservation (WC) Certification unless:"]
["7B.",null,"i.→","The applicant does not participate in USDA benefits subject to HELC and WC compliance except Federal Crop Insurance or CFAP, and"]
[null,null,"ii.→","The applicant only has an interest in land devoted to the production of agricultural commodities that are perennial crops, excluding sugar cane, such as tree fruits, tree nuts, grapes, olives, native pasture and perennial forage.  If the applicant produces alfalfa, the applicant must contact the Natural Resources Conservation Service to determine if such production qualifies as the production of a perennial crop; and "]
[null,null,"iii.→","The applicant has not converted a wetland after December 23, 1985; or"]
["7C.",null,"i.→","The applicant does not own or rent land devoted to an agricultural activity including cropland, rangeland, pastureland or forestland"]
[null,null,"ii.→","The applicant is a producer of livestock, nursery crops, honey or similar commodity that is not produced from tillage of land"]
["8.","If the applicant meets either of the conditions in section 6 (B)(certification with box 5 B on AD-1026) or (C) (certification with box 5 A on \nAD-1026), the applicant is only required to complete Parts A and D of form AD-1026"]
["PART B – PRODUCER INFORMATION"]
["5.  Producer’s Name and Address (City, State and Zip Code)"]
[{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""}]
[{"$f":"IF('Data Entry'!D6=\"\",\"\",'Data Entry'!D6)","v":""}]
[{"$f":"IF('Data Entry'!D7=\"\",\"\",'Data Entry'!D7)","v":""}]
["PART C – DAIRY PRODUCTION INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
[6,null,7,null,null,8,null,null,null,null,null,9,null,10,null,null,11,null,null,null,null,null,12]
["Unit of",null,"January 2020",null,null,"February 2020",null,null,null,null,null,"March 2020",null,"COC Adjusted Jan",null,null,"COC Adjusted Feb",null,null,null,null,null,"COC Adjusted March"]
["Measure",null,"Production",null,null,"Production",null,null,null,null,null,"Production",null," 2020 Production",null,null,"2020 Production",null,null,null,null,null,"2020 Production"]
["LBS",null,{"$f":"IF('Data Entry'!D12=\"\",\"\",'Data Entry'!D12)","v":""},null,null,{"$f":"IF('Data Entry'!E12=\"\",\"\",'Data Entry'!E12)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!F12=\"\",\"\",'Data Entry'!F12)","v":""}]
["PART D – NON-SPECIALTY CROP AND WOOL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
["13.\nCommodity",null,null,null,null,"14.\nUnit of Measure",null,null,null,null,null,"15.\n2019 Total \nProduction",null,"16.\n2019 \nProduction Not Sold\n(as of Jan 15, 2020)",null,null,"17.\nCOC Adjusted 2019\nTotal Production",null,null,null,null,null,"18.\nCOC Adjusted 2019 Production Not Sold\n(as of Jan 15, 2020)"]
[{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},null,null,null,null,{"$f":"IF(ECPR!D11=\"\",\"\",ECPR!D11)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!E16=\"\",\"\",'Data Entry'!E16)","v":""},null,{"$f":"IF('Data Entry'!F16=\"\",\"\",'Data Entry'!F16)","v":""}]
[{"$f":"IF('Data Entry'!C17=\"\",\"\",'Data Entry'!C17)","v":""},null,null,null,null,{"$f":"IF(ECPR!D12=\"\",\"\",ECPR!D12)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!E17=\"\",\"\",'Data Entry'!E17)","v":""},null,{"$f":"IF('Data Entry'!F17=\"\",\"\",'Data Entry'!F17)","v":""}]
[{"$f":"IF('Data Entry'!C18=\"\",\"\",'Data Entry'!C18)","v":""},null,null,null,null,{"$f":"IF(ECPR!D13=\"\",\"\",ECPR!D13)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!E18=\"\",\"\",'Data Entry'!E18)","v":""},null,{"$f":"IF('Data Entry'!F18=\"\",\"\",'Data Entry'!F18)","v":""}]
[{"$f":"IF('Data Entry'!C19=\"\",\"\",'Data Entry'!C19)","v":""},null,null,null,null,{"$f":"IF(ECPR!D14=\"\",\"\",ECPR!D14)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!E19=\"\",\"\",'Data Entry'!E19)","v":""},null,{"$f":"IF('Data Entry'!F19=\"\",\"\",'Data Entry'!F19)","v":""}]
["AD-3114 (5/19/20)                                                                                                                                                                                                  Page 2 of 2"]
["PART E – LIVESTOCK INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
[19,null,null,null,null,20,null,null,null,null,21,null,null,22,null,null,23,null,null,null,null,null,null,24]
["Livestock",null,null,null,null,"Unit of Measure",null,null,null,null,"Jan 15, 2020 - April 15, \n2020 Sales of Owned \nInventory as of Jan 15, \n2020 & Any Offspring \nFrom Owned Inventory",null,null," Inventory (Highest Between \nApril 16, 2020 - May\n14, 2020)",null,null,"COC Adjusted Jan 15, 2020 - \nApril 15, 2020 Sales of Owned \nInventory as of Jan 15, 2020 & \nAny Offspring From Owned \nInventory",null,null,null,null,null,null,"COC Adjusted Inventory"]
[{"$f":"IF('Data Entry'!C29=\"\",\"\",'Data Entry'!C29)","v":""},null,null,null,null,{"$f":"IF(ECPR!D24=\"\",\"\",ECPR!D24)","v":""},null,null,null,{"$f":"IF('Data Entry'!E29=\"\",\"\",'Data Entry'!E29)","v":""},null,null,null,{"$f":"IF('Data Entry'!F29=\"\",\"\",'Data Entry'!F29)","v":""}]
[{"$f":"IF('Data Entry'!C30=\"\",\"\",'Data Entry'!C30)","v":""},null,null,null,null,{"$f":"IF(ECPR!D25=\"\",\"\",ECPR!D25)","v":""},null,null,null,{"$f":"IF('Data Entry'!E30=\"\",\"\",'Data Entry'!E30)","v":""},null,null,null,{"$f":"IF('Data Entry'!F30=\"\",\"\",'Data Entry'!F30)","v":""}]
[{"$f":"IF('Data Entry'!C31=\"\",\"\",'Data Entry'!C31)","v":""},null,null,null,null,{"$f":"IF(ECPR!D26=\"\",\"\",ECPR!D26)","v":""},null,null,null,{"$f":"IF('Data Entry'!E31=\"\",\"\",'Data Entry'!E31)","v":""},null,null,null,{"$f":"IF('Data Entry'!F31=\"\",\"\",'Data Entry'!F31)","v":""}]
[{"$f":"IF('Data Entry'!C32=\"\",\"\",'Data Entry'!C32)","v":""},null,null,null,null,{"$f":"IF(ECPR!D27=\"\",\"\",ECPR!D27)","v":""},null,null,null,{"$f":"IF('Data Entry'!E32=\"\",\"\",'Data Entry'!E32)","v":""},null,null,null,{"$f":"IF('Data Entry'!F32=\"\",\"\",'Data Entry'!F32)","v":""}]
["PART F - VALUE LOSS INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
["25.\nCommodity",null,null,null,null,"26.\nValue of Sales\n(Jan 15, 2020 –April 15, \n2020)",null,null,null,null,null,"27.\nValue of Inventory \n(as of April 15, 2020)",null,null,"28.\nCOC Adjusted Value of Sales (Jan 15, 2020 –\nApril 15, 2020)",null,null,null,null,null,"29.\nCOC Adjusted Value o fInventory\n(as of April 15, 2020)"]
[{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""}]
[{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},null,null,null,null,null,{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""}]
["PART G - SPECIALTY CROP INFORMATION (COC DETERMINATION NOT REQUIRED)",null,null,null,null,null,null,null,null,null,null,null,null,null,"AMS USE ONLY"]
["30.\nCrop",null,null,"31.\nUnit of Measure",null,null,"32.\nVolume of Production Sold (Jan 15, 2020 -\nApril 15, 2020)",null,null,null,"33.\nVolume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -April\n15, 2020)",null,"34.\nAcres with Production Not Shipped or Sold (Jan 15, 2020 -April\n15, 2020)",null,"35.\nAMS Adjusted Volume of Production Sold\n(Jan 15, 2020 -\nApril 15, 2020)",null,null,null,"36.\nAMS Adjusted Volume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -\nApril 15, 2020)",null,null,null,null,"37.\nAMS Adjusted Acres with Production Not Shipped or Sold (Jan 15, 2020 -\nApril 15, 2020)"]
[{"$f":"IF('Data Entry'!C50=\"\",\"\",'Data Entry'!C50)","v":""},null,null,{"$f":"IF('Data Entry'!D50=\"\",\"\",'Data Entry'!D50)","v":""},null,null,{"$f":"IF('Data Entry'!E50=\"\",\"\",'Data Entry'!E50)","v":""},null,null,null,{"$f":"IF('Data Entry'!F50=\"\",\"\",'Data Entry'!F50)","v":""},null,{"$f":"IF('Data Entry'!G50=\"\",\"\",'Data Entry'!G50)","v":""}]
[{"$f":"IF('Data Entry'!C51=\"\",\"\",'Data Entry'!C51)","v":""},null,null,{"$f":"IF('Data Entry'!D51=\"\",\"\",'Data Entry'!D51)","v":""},null,null,{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},null,null,null,{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},null,{"$f":"IF('Data Entry'!G51=\"\",\"\",'Data Entry'!G51)","v":""}]
[{"$f":"IF('Data Entry'!C52=\"\",\"\",'Data Entry'!C52)","v":""},null,null,{"$f":"IF('Data Entry'!D52=\"\",\"\",'Data Entry'!D52)","v":""},null,null,{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},null,null,null,{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},null,{"$f":"IF('Data Entry'!G52=\"\",\"\",'Data Entry'!G52)","v":""}]
["PART H – INCREASED PAYMENT LIMITATION FOR CORPORATIONS, LIMITED LIABILITY COMPANIES AND LIMITED PARTNERSHIPS"]
["38. →     Applicants who are Corporations, Limited Liability Companies, and Limited Partnerships may seek an increase in the per-person payment limitation \n              from $250,000 to either $500,000 or $750,000 based on the number of members, partners, or stockholders who provide 400 hours or more of personal \n              labor or active personal management, or combination thereof, to the farming operation as defined in 7 CFR Part 1400, or a maximum of $750,000 if \n              such entity has three members, partners, or stockholders who each provided at least 400 hours or more of personal labor or active personal \n              management, or combination thereof, to the farming operation as defined in 7 CFR Part 1400.  Identify the names of members, partners, or \n              stockholders who provided at least 400 hours of active personal labor or active personal management, or combination thereof, to the farming operation \n              identified in Part B Item 5:"]
["A.",{"$f":"IF('Data Entry'!C62=\"\",\"\",'Data Entry'!C62)","v":""},null,null,null,null,null,null,"B.",null,null,{"$f":"IF('Data Entry'!C63=\"\",\"\",'Data Entry'!C63)","v":""},null,null,null,null,"C.",{"$f":"IF('Data Entry'!C64=\"\",\"\",'Data Entry'!C64)","v":""}]
["PART I – PRODUCER CERTIFICATION"]
["I hereby sign and acknowledge under penalty of perjury in accordance with 28 U.S.C. § 1746 and 18 U.S.C. § 1621 that the foregoing is true and correct."]
["39A.  Signature (By)",null,null,null,null,null,null,null,null,null,null,"39B.  Title/Relationship of the individual signing in the Representative Capacity",null,null,null,null,null,null,null,null,null,"39C.  Date (MM-DD-YYYY)"]
["PART J – COC DETERMINATION"]
["40.\nPayment Part",null,null,null,"41.\nCOC or Designee Signature",null,null,null,null,null,null,null,null,null,"42.\nDate (MM-DD-YYYY)",null,null,"43.\nDetermination"]
["CARES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED",null,null,null,null,"DISAPPROVED"]
["CCC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED",null,null,null,null,"DISAPPROVED"]
["In accordance with Federal civil rights law and USDA civil rights regulations and policies, the USDA, its agencies, offices, and employees participating in or administering USDA programs are prohibited from discriminating based on race, color, national origin, religion, sex, gender identity (including gender expression), sexual orientation, disability, age, marital status, family/parental status, income derived from a public assistance program, political beliefs, or reprisal or retaliation for prior civil rights activity, in any program or activity conducted or funded by USDA (not all bases apply to all programs). Remedies and complaint filing deadlines vary by program or incident.\n \nPersons with disabilities who require alternative means of communication for program information (e.g., Braille, large print, audiotape, American Sign Language, etc.) should contact the responsible agency or USDA’s TARGET Center at (202) 720-2600 (voice and TTY) or contact USDA through the Federal Relay Service at (800) 877-8339. Additionally, program information may be made available in languages other than English. \n\nTo file a program discrimination complaint, complete the USDA Program Discrimination Complaint Form, AD-3027, found online at http://www.ascr.usda.gov/complaint_filing_cust.html and at any USDA office or write a letter addressed to USDA and provide in the letter all of the information requested in the form. To request a copy of the complaint form, call (866) 632-9992. Submit your completed form or letter to USDA by: (1) mail: U.S. Department of Agriculture Office of the Assistant Secretary for Civil Rights 1400 Independence Avenue, SW Washington, D.C. 20250-9410; (2) fax: (202) 690-7442; or (3) email: program.intake@usda.gov.  USDA is an equal opportunity provider, employer, and lender."]

{"sheet":"AD-3114 (continuation)","index":2,"n_rows":51,"n_cols":22,"rows_kept":51,"cut":false,"hidden":false,"merged":[[42,13,42,15],[43,13,43,15],[44,13,44,15],[45,13,45,15],[42,0,42,2],[43,0,43,2],[44,0,44,2],[45,0,45,2],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[42,5,42,8],[43,5,43,8],[44,5,44,8],[45,5,45,8],[47,11,47,12],[40,9,40,10],[41,9,41,10],[46,9,46,10],[47,9,47,10],[40,3,40,4],[41,3,41,4],[46,3,46,4],[47,3,47,4],[40,5,40,8],[41,5,41,8],[46,5,46,8],[47,5,47,8],[42,9,42,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[3,0,5,10],[3,11,3,16],[6,1,6,21],[7,0,7,21],[8,0,8,21],[9,0,9,20],[3,17,3,21],[4,11,4,16],[4,17,4,21],[5,11,5,16],[5,17,5,21],[0,0,0,21],[1,0,1,10],[1,11,1,16],[1,17,1,21],[2,0,2,10],[2,11,2,16],[2,17,2,21],[12,0,12,13],[12,14,12,21],[13,0,13,4],[13,5,13,8],[13,9,13,10],[13,11,13,13],[13,14,13,19],[13,20,13,21],[10,0,10,20],[11,0,11,20],[17,0,17,4],[17,9,17,10],[17,11,17,13],[17,14,17,19],[17,20,17,21],[16,0,16,4],[16,9,16,10],[16,11,16,13],[16,14,16,19],[16,20,16,21],[14,5,17,8],[15,0,15,4],[15,9,15,10],[15,11,15,13],[15,14,15,19],[15,20,15,21],[14,0,14,4],[14,9,14,10],[14,11,14,13],[14,14,14,19],[14,20,14,21],[18,20,18,21],[23,0,23,4],[23,5,23,8],[23,9,23,10],[23,11,23,13],[22,0,22,4],[22,5,22,8],[22,9,22,10],[22,11,22,13],[19,0,19,4],[19,5,19,8],[19,9,19,10],[19,11,19,13],[21,9,21,10],[21,11,21,13],[18,0,18,4],[18,5,18,8],[18,9,18,10],[18,11,18,13],[18,14,18,19],[20,9,20,10],[20,11,20,13],[26,14,26,20],[27,0,27,4],[27,5,27,8],[27,9,27,10],[27,11,27,13],[27,14,27,20],[26,0,26,4],[26,5,26,8],[26,9,26,10],[26,11,26,13],[29,9,29,10],[28,11,28,13],[29,11,29,13],[24,0,24,13],[24,14,24,21],[25,0,25,4],[25,5,25,8],[25,9,25,10],[25,11,25,13],[25,14,25,20],[32,11,32,13],[28,0,28,4],[29,0,29,4],[30,0,30,4],[30,5,30,8],[30,9,30,10],[30,11,30,13],[28,5,28,8],[29,5,29,8],[28,9,28,10],[34,5,34,9],[33,0,33,12],[33,13,33,21],[31,0,31,4],[31,5,31,8],[31,9,31,10],[31,11,31,13],[32,0,32,4],[32,5,32,8],[32,9,32,10],[37,5,37,9],[37,18,37,21],[38,0,38,21],[34,0,34,4],[34,13,34,17],[34,18,34,21],[35,0,35,4],[35,13,35,17],[35,18,35,21],[36,0,36,4],[48,0,48,21],[49,0,49,21],[50,0,50,21],[20,0,20,4],[21,0,21,4],[20,5,20,8],[21,5,21,8],[47,0,47,2],[47,13,47,15],[35,10,35,12],[39,0,39,12],[39,13,39,21],[40,0,40,2],[40,13,40,15],[40,16,40,20],[34,10,34,12],[36,10,36,12],[37,10,37,12],[35,5,35,9],[36,5,36,9],[40,11,40,12],[41,11,41,12],[46,11,46,12],[37,0,37,4],[37,13,37,17],[41,16,41,20],[46,0,46,2],[46,13,46,15],[41,0,41,2],[41,13,41,15]]}
["                                                                                                                                                                                                              Form Approved - OMB No. 0560-0295\nThis form is available electronically.                                                                                                                                                              OMB Expiration date (5-19-20)"]
["AD-3114-A                                  U.S. DEPARTMENT OF AGRICULTURE",null,null,null,null,null,null,null,null,null,null,"1.   Recording State",null,null,null,null,null,"2.  Program Year"]
["(5-19-20)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!D3=\"\",\"\",'Data Entry'!D3)","v":""},null,null,null,null,null,2020]
["CORONAVIRUS FOOD ASSISTANCE PROGRAM (CFAP) APPLICATION\n(Continuation Sheet)"]
[null,null,null,null,null,null,null,null,null,null,null,"3.  Recording County",null,null,null,null,null,"4. Application Number"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data Entry'!F3=\"\",\"\",'Data Entry'!F3)","v":""}]
["NOTE:","The following statement is made in accordance with the Privacy Act of 1974 (5 USC 552a - as amended). The authority for requesting the information identified on this form is 7 CFR Part 9, the CARES Act (Pub. L. 116-136), and 15 U.S.C. 714b and 714c.  The information will be used to determine eligibility for program benefits.  The information collected on this form may be disclosed to other Federal, State, and Local government agencies, Tribal agencies, and nongovernmental entities that have been authorized access to the information by statute or regulation and/or as described in applicable Routine Uses identified in the System of Records Notice for USDA/FSA-2, Farm Records File (Automated).  Providing the requested information is voluntary.  However, failure to furnish the requested information will result in a determination of ineligibility for program benefits.  Payments may be made under the program to which the form applies only to the extent permitted by applicable authorities.\n\nPublic Burden Statement (Paperwork Reduction Act):  Public reporting burden for this collection is estimated to average 60 minutes per response, including reviewing instructions, gathering and maintaining the data needed, completing (providing the information), and reviewing the collection of information. You are not required to respond to the collection, or USDA may not conduct or sponsor a collection of information unless it displays a valid OMB control number.  RETURN THIS COMPLETED FORM TO YOUR COUNTY FSA OFFICE."]
["PART B – PRODUCER INFORMATION"]
["5.  Producer’s Name and Address (City, State and Zip Code)"]
[{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""}]
[{"$f":"IF('Data Entry'!D6=\"\",\"\",'Data Entry'!D6)","v":""}]
[{"$f":"IF('Data Entry'!D7=\"\",\"\",'Data Entry'!D7)","v":""}]
["PART D – NON-SPECIALTY CROP AND WOOL INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
[13,null,null,null,null,14,null,null,null,15,null,16,null,null,17,null,null,null,null,null,18]
["Commodity",null,null,null,null,"Unit of Measure",null,null,null,"2019 Total",null,2019,null,null,"COC Adjusted 2019",null,null,null,null,null,"COC Adjusted 2019"]
[null,null,null,null,null,null,null,null,null,"Production",null,"Production Not Sold",null,null,"Total Production",null,null,null,null,null,"Production"]
[null,null,null,null,null,null,null,null,null,null,null,"(as of Jan 15, 2020)",null,null,null,null,null,null,null,null,"Not Sold"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(as of Jan 15, 2020)"]
[{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C20)","v":""},null,null,null,null,{"$f":"IF(ECPR!D15=\"\",\"\",ECPR!D15)","v":""},null,null,null,{"$f":"IF('Data Entry'!E20=\"\",\"\",'Data Entry'!E20)","v":""},null,{"$f":"IF('Data Entry'!F20=\"\",\"\",'Data Entry'!F20)","v":""}]
[{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},null,null,null,null,{"$f":"IF(ECPR!D16=\"\",\"\",ECPR!D16)","v":""},null,null,null,{"$f":"IF('Data Entry'!E21=\"\",\"\",'Data Entry'!E21)","v":""},null,{"$f":"IF('Data Entry'!F21=\"\",\"\",'Data Entry'!F21)","v":""}]
[{"$f":"IF('Data Entry'!C22=\"\",\"\",'Data Entry'!C22)","v":""},null,null,null,null,{"$f":"IF(ECPR!D17=\"\",\"\",ECPR!D17)","v":""},null,null,null,{"$f":"IF('Data Entry'!E22=\"\",\"\",'Data Entry'!E22)","v":""},null,{"$f":"IF('Data Entry'!F22=\"\",\"\",'Data Entry'!F22)","v":""}]
[{"$f":"IF('Data Entry'!C23=\"\",\"\",'Data Entry'!C23)","v":""},null,null,null,null,{"$f":"IF(ECPR!D18=\"\",\"\",ECPR!D18)","v":""},null,null,null,{"$f":"IF('Data Entry'!E23=\"\",\"\",'Data Entry'!E23)","v":""},null,{"$f":"IF('Data Entry'!F23=\"\",\"\",'Data Entry'!F23)","v":""}]
[{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},null,null,null,null,{"$f":"IF(ECPR!D19=\"\",\"\",ECPR!D19)","v":""},null,null,null,{"$f":"IF('Data Entry'!E24=\"\",\"\",'Data Entry'!E24)","v":""},null,{"$f":"IF('Data Entry'!F24=\"\",\"\",'Data Entry'!F24)","v":""}]
[{"$f":"IF('Data Entry'!C25=\"\",\"\",'Data Entry'!C25)","v":""},null,null,null,null,{"$f":"IF(ECPR!D20=\"\",\"\",ECPR!D20)","v":""},null,null,null,{"$f":"IF('Data Entry'!E25=\"\",\"\",'Data Entry'!E25)","v":""},null,{"$f":"IF('Data Entry'!F25=\"\",\"\",'Data Entry'!F25)","v":""}]
["PART E – LIVESTOCK INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
[19,null,null,null,null,20,null,null,null,21,null,22,null,null,23,null,null,null,null,null,null,24]
["Livestock",null,null,null,null,"Unit of Measure",null,null,null,"Jan 15, 2020 - April 15, 2020\nSales of Owned Inventory as of\nJan 15, 2020 and Any Offspring From \nOwned Inventory",null,"Inventory (Highest Between April 16, 2020 - May\n14, 2020)",null,null,"COC Adjusted Jan 15, 2020 - April 15 2020 Sales of Owned Inventory as of Jan 15, 2020 & Any Offspring From Owned Inventory",null,null,null,null,null,null,"COC Adjusted Inventory"]
[{"$f":"IF('Data Entry'!C33=\"\",\"\",'Data Entry'!C33)","v":""},null,null,null,null,{"$f":"IF(ECPR!D28=\"\",\"\",ECPR!D28)","v":""},null,null,null,{"$f":"IF('Data Entry'!E33=\"\",\"\",'Data Entry'!E33)","v":""},null,{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""}]
[{"$f":"IF('Data Entry'!C34=\"\",\"\",'Data Entry'!C34)","v":""},null,null,null,null,{"$f":"IF(ECPR!D29=\"\",\"\",ECPR!D29)","v":""},null,null,null,{"$f":"IF('Data Entry'!E34=\"\",\"\",'Data Entry'!E34)","v":""},null,{"$f":"IF('Data Entry'!F34=\"\",\"\",'Data Entry'!F34)","v":""}]
[{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":""},null,null,null,null,{"$f":"IF(ECPR!D30=\"\",\"\",ECPR!D30)","v":""},null,null,null,{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},null,{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""}]
[{"$f":"IF('Data Entry'!C36=\"\",\"\",'Data Entry'!C36)","v":""},null,null,null,null,{"$f":"IF(ECPR!D31=\"\",\"\",ECPR!D31)","v":""},null,null,null,{"$f":"IF('Data Entry'!E36=\"\",\"\",'Data Entry'!E36)","v":""},null,{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""}]
[{"$f":"IF('Data Entry'!C37=\"\",\"\",'Data Entry'!C37)","v":""},null,null,null,null,{"$f":"IF(ECPR!D32=\"\",\"\",ECPR!D32)","v":""},null,null,null,{"$f":"IF('Data Entry'!E37=\"\",\"\",'Data Entry'!E37)","v":""},null,{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""}]
[{"$f":"IF('Data Entry'!C38=\"\",\"\",'Data Entry'!C38)","v":""},null,null,null,null,{"$f":"IF(ECPR!D33=\"\",\"\",ECPR!D33)","v":""},null,null,null,{"$f":"IF('Data Entry'!E38=\"\",\"\",'Data Entry'!E38)","v":""},null,{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""}]
["PART F - VALUE LOSS INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,"COC USE ONLY"]
["25.\nCommodity",null,null,null,null,"26.\nValue of Sales\n(Jan 15, 2020 –\nApril 15, 2020)",null,null,null,null,"27.\nValue of Inventory (as of April 15, 2020)",null,null,"28.\nCOC Adjusted Value of Sales (Jan 15, 2020 –\nApril 15, 2020)",null,null,null,null,"29.\nCOC Adjusted Value of Inventory\n(as of April 15, 2020)"]
[{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""}]
[{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""}]
[{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},null,null,null,null,{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""}]
["AD-3114 Continuation Sheet (05/19/20)                                                                                                                                                                                                     Page 2 of 2"]
["PART G - SPECIALTY CROP INFORMATION (COC DETERMINATION NOT REQUIRED)",null,null,null,null,null,null,null,null,null,null,null,null,"AMS USE ONLY"]
["30.\nCrop",null,null,"31.\nUnit of Measure",null,"32.\nVolume of Production Sold (Jan 15, 2020 -\nApril 15, 2020)",null,null,null,"33.\nVolume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -April\n15, 2020)",null,"34.\nAcres with Production Not Shipped or Sold (Jan 15, 2020 -April\n15, 2020)",null,"35.\nAMS Adjusted Volume of Production Sold\n(Jan 15, 2020 -\nApril 15, 2020)",null,null,"36.\nAMS Adjusted Volume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -\nApril 15, 2020)",null,null,null,null,"37.\nAMS Adjusted Acres with Production Not Shipped or Sold (Jan 15, 2020 -\nApril 15, 2020)"]
[{"$f":"IF('Data Entry'!C53=\"\",\"\",'Data Entry'!C53)","v":""},null,null,{"$f":"IF('Data Entry'!D53=\"\",\"\",'Data Entry'!D53)","v":""},null,{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""},null,null,null,{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""},null,{"$f":"IF('Data Entry'!G53=\"\",\"\",'Data Entry'!G53)","v":""}]
[{"$f":"IF('Data Entry'!C54=\"\",\"\",'Data Entry'!C54)","v":""},null,null,{"$f":"IF('Data Entry'!D54=\"\",\"\",'Data Entry'!D54)","v":""},null,{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},null,null,null,{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},null,{"$f":"IF('Data Entry'!G54=\"\",\"\",'Data Entry'!G54)","v":""}]
[{"$f":"IF('Data Entry'!C55=\"\",\"\",'Data Entry'!C55)","v":""},null,null,{"$f":"IF('Data Entry'!D55=\"\",\"\",'Data Entry'!D55)","v":""},null,{"$f":"IF('Data Entry'!E55=\"\",\"\",'Data Entry'!E55)","v":""},null,null,null,{"$f":"IF('Data Entry'!F55=\"\",\"\",'Data Entry'!F55)","v":""},null,{"$f":"IF('Data Entry'!G55=\"\",\"\",'Data Entry'!G55)","v":""}]
[{"$f":"IF('Data Entry'!C56=\"\",\"\",'Data Entry'!C56)","v":""},null,null,{"$f":"IF('Data Entry'!D56=\"\",\"\",'Data Entry'!D56)","v":""},null,{"$f":"IF('Data Entry'!E56=\"\",\"\",'Data Entry'!E56)","v":""},null,null,null,{"$f":"IF('Data Entry'!F56=\"\",\"\",'Data Entry'!F56)","v":""},null,{"$f":"IF('Data Entry'!G56=\"\",\"\",'Data Entry'!G56)","v":""}]
[{"$f":"IF('Data Entry'!C57=\"\",\"\",'Data Entry'!C57)","v":""},null,null,{"$f":"IF('Data Entry'!D57=\"\",\"\",'Data Entry'!D57)","v":""},null,{"$f":"IF('Data Entry'!E57=\"\",\"\",'Data Entry'!E57)","v":""},null,null,null,{"$f":"IF('Data Entry'!F57=\"\",\"\",'Data Entry'!F57)","v":""},null,{"$f":"IF('Data Entry'!G57=\"\",\"\",'Data Entry'!G57)","v":""}]
[{"$f":"IF('Data Entry'!C58=\"\",\"\",'Data Entry'!C58)","v":""},null,null,{"$f":"IF('Data Entry'!D58=\"\",\"\",'Data Entry'!D58)","v":""},null,{"$f":"IF('Data Entry'!E58=\"\",\"\",'Data Entry'!E58)","v":""},null,null,null,{"$f":"IF('Data Entry'!F58=\"\",\"\",'Data Entry'!F58)","v":""},null,{"$f":"IF('Data Entry'!G58=\"\",\"\",'Data Entry'!G58)","v":""}]
[{"$f":"IF('Data Entry'!C59=\"\",\"\",'Data Entry'!C59)","v":""},null,null,{"$f":"IF('Data Entry'!D59=\"\",\"\",'Data Entry'!D59)","v":""},null,{"$f":"IF('Data Entry'!E59=\"\",\"\",'Data Entry'!E59)","v":""},null,null,null,{"$f":"IF('Data Entry'!F59=\"\",\"\",'Data Entry'!F59)","v":""},null,{"$f":"IF('Data Entry'!G59=\"\",\"\",'Data Entry'!G59)","v":""}]
["In accordance with Federal civil rights law and USDA civil rights regulations and policies, the USDA, its agencies, offices, and employees participating in or administering USDA programs are prohibited from discriminating based on race, color, national origin, religion, sex, gender identity (including gender expression), sexual orientation, disability, age, marital status, family/parental status, income derived from a public assistance program, political beliefs, or reprisal or retaliation for prior civil rights activity, in any program or activity conducted or funded by USDA (not all bases apply to all programs). Remedies and complaint filing deadlines vary by program or incident."]
["Persons with disabilities who require alternative means of communication for program information (e.g., Braille, large print, audiotape, American Sign Language, etc.) should contact the responsible agency or USDA’s TARGET Center at (202) 720-2600 (voice and TTY) or contact USDA through the Federal Relay Service at (800) 877-8339. Additionally, program information may be made available in languages other than English."]
["To file a program discrimination complaint, complete the USDA Program Discrimination Complaint Form, AD-3027, found online at http://www.ascr.usda.gov/complaint_filing_cust.html and at any USDA office or write a letter addressed to USDA and provide in the letter all of the information requested in the form. To request a copy of the complaint form, call (866) 632-9992. Submit your completed form or letter to USDA by: (1) mail: U.S. Department of Agriculture Office of the Assistant Secretary for Civil Rights 1400 Independence Avenue, SW Washington, D.C. 20250-9410; (2) fax: (202) 690-7442; or (3) email: program.intake@usda.gov.  USDA is an equal opportunity provider, employer, and lender."]

{"sheet":"AD-3114 Instructions","index":3,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,1,0,2],[8,1,8,2],[7,1,7,2],[11,1,11,2],[19,1,19,2],[26,1,26,2],[41,1,41,2],[1,1,1,2],[27,1,35,1],[47,1,47,2],[56,1,56,2],[58,1,58,2],[9,1,9,2]]}
[null,"AD-3114 Instructions"]
[null,"Note:  Upon completion, only enter the applicants share of the commodity "]
[null,"Item","Instructions"]
[null,1,"Enter the producer’s recording state."]
[null,2,"Enter the applicable program year. "]
[null,3,"Enter the producer’s recording county."]
[null,4,"Enter application number\nNote: This is automated system assigned number."]
[null,"Part A  - Producer Agreement"]
[null,"Applicants who are an individual person must complete CCC-902 Automated or Parts A and B of manual form CCC-902 and provide name, address, taxpayer identification number and citizenship status.  An individual who is not a US resident or lawful alien must also report contributions of labor, capital and land contributions to the farming operation.  \n\nApplicants who are a legal entity, including General Partnership or Joint Venture, must complete CCC-902 Automated or manual form CCC-901 and provide the name, address and taxpayer identification number for the legal entity and all members, partners or stockholders with an ownership interest.  If any member, partner or stockholder is not a U.S. Resident or lawful alien, form CCC-902 must be completed to report contributions of labor to the legal entity.   "]
[null,"Part B - Producer Information"]
[null,5,"Enter the producer’s name and address, including the ZIP code."]
[null,"Part C  - Dairy Production Information"]
[null,6,"Displays the unit of measure for dairy production as pounds (LBS).  "]
[null,7,"Enter the total January 2020 production, including dumped milk, in pounds (LBS)."]
[null,8,"Enter the total February 2020 production, including dumped milk, in pounds (LBS)."]
[null,9,"Enter the total March 2020 production, including dumped milk, in pounds (LBS)."]
[null,10,"COC may enter the adjusted January 2020 production, if applicable.\n\nNote: An entry is only required when COC determines the January 2020 production is different than what is certified to by the producer in item 7."]
[null,11,"COC may enter the adjusted February 2020 production, if applicable.\n\nNote: An entry is only required when COC determines the February 2020 production is different than what is certified to by the producer in item 8."]
[null,12,"COC may enter the adjusted March 2020 production, if applicable.\n\nNote: An entry is only required when COC determines the March 2020 production is different than what is certified to by the producer in item 9."]
[null,"Part D – Non-Specialty Crop Information"]
[null,13,"Enter the eligible non-specialty crop "]
[null,14,"Enter the applicable unit of measure for the crop entered in item 13."]
[null,15,"Enter the 2019 total production from all farms for the crop entered in item 13.\n\n*  Note this is your share of the production."]
[null,16,"Enter the 2019 production from all farms not sold as of January 15, 2020.\n\n*  Note this is your share of the production."]
[null,17,"COC may enter the adjusted 2019 yotal production, if applicable. \n\nNote: An entry is only required when COC determines the 2019 total production is different than what is certified to by the producer in item 15."]
[null,18,"COC may enter the adjusted 2019 production not sold, if applicable.\n\nNote: An entry is only required when COC determines the 2019 production not sold is different than what is certified to by the producer in item 16."]
[null,"Part E – Livestock Information"]
[null,19,"Enter the name of the eligible livestock.\nEligible livestock and definitions are:"]
[null,null,"Feeder Cattle: Less Than 600 Pounds (cattle weighing less than 600 pounds)"]
[null,null,"Feeder Cattle: 600 Pounds or More (cattle weighing more than 600 pounds but less than \"Slaughter Cattle:  Fed Cattle\" as defined)"]
[null,null,"Slaughter Cattle: Fed Cattle (cattle with an average weight of 1,400 pounds, including cattle with a weight of 1,200 pounds or more, which yield average carcass weights of 800 pounds and are intended for slaughter)"]
[null,null,"Slaughter Cattle: Mature Cattle (culled cattle raised or maintained for breeding purposes, but which were removed from inventory and are intended for slaughter)"]
[null,null,"All Other Cattle (commercially raised or maintained bovine animals not meeting the definition of another category of cattle, excluding beefalo, bison, and animals used for dairy production or intended for dairy production)"]
[null,null,"Pigs: Less Than 120 Pounds (any swine weighing less than 120 pounds)"]
[null,null,"Hogs: 120 Pounds or More (any swine 120 pounds or more)"]
[null,null,"Lambs & Yearlings: Less Than 2 Years Old (all sheep less than 2 years old)"]
[null,20,"Enter the applicable unit of measure for the livestock entered in item 19."]
[null,21,"Enter the total sales between January 15, 2020 and April 15, 2020 for owned inventory as of Jan 15, 2020 including sale of any offspring from owned inventory for the livestock entered in item 19, if applicable.\n\n*  Note this is your share of the livestock."]
[null,22,"Enter the highest inventory between April 16, 2020 and May 14, 2020, for the livestock entered in item 19, if applicable.\n\n*  Note this is your share of the livestock."]
[null,23,"COC shall enter the adjusted total sales between January 15, 2020 and April 15, 2020 for owned inventory as of Jan 15, 2020 and any offspring from owned inventory, if applicable. \n\nNote: An entry is only required when COC determines the total sales is different than what is certified to by the producer in item 21."]
[null,24,"COC shall enter the adjusted inventory, if applicable.\n\nNote: An entry is only required when COC determines the inventory is different than what is certified to by the producer in item 22."]
[null,"Part F – Value Loss Information"]
[null,25,"Enter the eligible value loss commodity. "]
[null,26,"Enter the total value of sales from all farms between January 15, 2020 and April 15, 2020, for the value loss commodity entered in item 25.\n\n*Note this is your share of the value."]
[null,27,"Enter the total value of marketable inventory from all farms as of April 15, 2020, for the value loss commodity entered in item 25.\n\n*  Note this is your share of the value."]
[null,28,"COC may enter the adjusted value of sales between January 15, 2020 and April 15, 2020, if applicable. \n\nNote: An entry is only required when COC determines the total value of sales is different than what is certified to by the producer in item 26."]
[null,29,"COC may enter the adjusted value of inventory as of April 15, 2020, if applicable.\n\nNote: An entry is only required when COC determines the value of inventory is different than what is certified to by the producer in item 27."]
[null,"Part G – Specialty Crop Information (COC Determination Not Required)"]
[null,30,"Enter the eligible specialty crop."]
[null,31,"Enter the unit of measure for the crop in item 30."]
[null,32,"Enter the total volume of production sold between January 15, 2020 and April 15, 2020 for the crop in item 30.\n\n*  Note this is your share of the specialty crop."]
[null,33,"Enter the total volume of production shipped but not sold between January 15, 2020 and April 15, 2020 for the crop in item 30.\n\n*  Note this is your share of the specialty crop."]
[null,34,"Enter the total number of Acres left in the field or harvested but not shipped between \nJanuary 15, 2020 and April 15, 2020 for the crop in item 30.\n\n*  Note this is your share of the acres."]
[null,35,"Leave blank. AMS will enter an adjusted number if application is selected for audit.\n\nNote: No action required by producer"]
[null,36,"Leave blank. AMS will enter an adjusted number if application is selected for audit.\n\nNote: No action required by producer"]
[null,37,"Leave blank. AMS will enter an adjusted number if application is selected for audit.\n\nNote: No action required by producer"]
[null,"Part H – Increase Payment Limitation for\nCorporations, Limited Liability Companies and Limited Partnerships"]
[null,"38A-38C","Enter the member/partner or stockholder name(s) who provide 400 hours or more of active personal labor or active personal management, or combination thereof, to the farming operation identified in Part A, item 5.\n\nNote: Entry only required to be completed by Corporations, LLCs and Limited Partnerships."]
[null,"Part I – Producer Certification"]
[null,"39A","Producer applying for CFAP benefits must sign."]
[null,"39B ","Enter title and/or relationship to the individual when signing in a representative capacity.\n\nNote: If the producer signing is not signing representative capacity, this field should be left blank."]
[null,"39C","Enter the date the AD-3114 is signed in item 39A."]

{"sheet":"ECPR_P1","index":4,"n_rows":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,11,1,12],[1,4,1,10],[2,3,2,5],[2,1,2,2],[32,2,32,3],[1,2,1,3],[13,1,13,2],[10,1,12,9],[4,14,13,14],[33,1,37,1],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,null,null,null,{"$f":"'Data Entry'!I9","v":0}]
[null,"Recording County:",null,{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""}]
[null,"Category","Commodity Name","Unit of Measure","7)\nJan.  Prod.","8) \nFeb.  Prod.","9)\nMarch  Prod.","2019 Total  Prod. \n","CARES  Payment Rate\n(per pound)","80%\nEstimated CARES Gross Payment  before payment limits and other reductions\n(H*I*80%)","Quarter 2 National Adjustment","CCC Payment Rate\n(per pound)","80%\nEstimated CCC Gross Payment before payment limits and other reductions\n(K*L*M* 80%)",null,"Category"]
["Milk",{"$f":"ECPR!B7","v":"Dairy"},{"$f":"ECPR!C7","v":"Milk"},{"$f":"ECPR!D7","v":"pounds"},{"$f":"ECPR!E7","v":""},{"$f":"ECPR!F7","v":""},{"$f":"ECPR!G7","v":""},{"$f":"ECPR!H7","v":0},{"$f":"ECPR!I7","v":""},{"$f":"ECPR!J7","v":0},{"$f":"ECPR!L7","v":1.014},{"$f":"ECPR!M7","v":""},{"$f":"ECPR!N7","v":0},{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},"Non-specialty crops and wool"]
[null,null,null,null,null,null,null,null,null,{"$f":"J5","v":0},null,null,{"$f":"M5","v":0},{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected.",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 4",{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"},null,null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-06-02"},{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Category","Commodity",null,"26) \nValue of  Sales (January 15, 2020 - April 15, 2020)","CARES Value Loss Factor","CARES Gross Payment\n(E Adusted by F, if applicable, * H)","27) \nValue of  Inventory (as of April 15, 2020)","CCC Value Loss Factor","CCC Gross Payment \n(K Adusted by L, if applicable, * N)"]
[{"$f":"\"Value Loss \"&C34","v":"Value Loss "},"Value Loss",{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(A34,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E34=\"\",\"\",ROUND(E34*F34,2))","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(A34,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H34=\"\",\"\",ROUND(H34*I34,2))","v":""}]
[{"$f":"\"Value Loss \"&C35","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(A35,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E35=\"\",\"\",ROUND(E35*F35,2))","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(A35,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H35=\"\",\"\",ROUND(H35*I35,2))","v":""}]
[{"$f":"\"Value Loss \"&C36","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E36=\"\",\"\",ROUND(E36*F36,2))","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H36=\"\",\"\",ROUND(H36*I36,2))","v":""}]
[{"$f":"\"Value Loss \"&C37","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E37=\"\",\"\",ROUND(E37*F37,2))","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H37=\"\",\"\",ROUND(H37*I37,2))","v":""}]
[{"$f":"\"Value Loss \"&C38","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(E38*F38,2))","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H38=\"\",\"\",ROUND(H38*I38,2))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G38)","v":0},null,null,{"$f":"SUM(J34:J38)","v":0}]

{"sheet":"ECPR_P2","index":5,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":true,"merged":[[36,2,36,3],[37,1,41,1],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[1,2,1,3],[1,4,1,10],[1,11,1,12],[4,1,13,1],[19,1,20,2],[2,1,2,2],[2,3,2,5],[15,1,17,9]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,null,null,null,{"$f":"'Data Entry'!I9","v":0}]
[null,"Recording County:",null,{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""}]
[null,"Category","Commodity Name","Unit of Measure","15) \n2019 Total Prod","16) \n 2019  Prod Not Sold","Smaller of Total of Production or  Production  ((E *50%) or F])","CARES - Quantity Factor (Part 1)","CARES Payment Quantity \n(G*H)","CARES Payment Rate\n(Part 1)","80%\nEstimated CARES Gross Payment before payment limits and other reductions    \n (I*J *80%)","CCC - Quantity Factor          (Part 2)","CCC Payment Quantity ","CCC  Payment Rate\n(Part 2)","80%\nEstimated CCC Gross Payment before payment limits and other reductions"]
[{"$f":"\"Row Crop \"&C5","v":"Row Crop "},{"$f":"ECPR!B11","v":"Non-specialty crops and wool"},{"$f":"ECPR!C11","v":""},{"$f":"ECPR!D11","v":""},{"$f":"ECPR!E11","v":""},{"$f":"ECPR!F11","v":""},{"$f":"ECPR!G11","v":""},{"$f":"ECPR!H11","v":""},{"$f":"ECPR!I11","v":""},{"$f":"ECPR!J11","v":""},{"$f":"ECPR!K11","v":0},{"$f":"ECPR!L11","v":""},{"$f":"ECPR!M11","v":""},{"$f":"ECPR!N11","v":""},{"$f":"ECPR!O11","v":0}]
[{"$f":"\"Row Crop \"&C6","v":"Row Crop "},null,{"$f":"ECPR!C12","v":""},{"$f":"ECPR!D12","v":""},{"$f":"ECPR!E12","v":""},{"$f":"ECPR!F12","v":""},{"$f":"ECPR!G12","v":""},{"$f":"ECPR!H12","v":""},{"$f":"ECPR!I12","v":""},{"$f":"ECPR!J12","v":""},{"$f":"ECPR!K12","v":0},{"$f":"ECPR!L12","v":""},{"$f":"ECPR!M12","v":""},{"$f":"ECPR!N12","v":""},{"$f":"ECPR!O12","v":0}]
["Row Crop ",null,{"$f":"ECPR!C13","v":""},{"$f":"ECPR!D13","v":""},{"$f":"ECPR!E13","v":""},{"$f":"ECPR!F13","v":""},{"$f":"ECPR!G13","v":""},{"$f":"ECPR!H13","v":""},{"$f":"ECPR!I13","v":""},{"$f":"ECPR!J13","v":""},{"$f":"ECPR!K13","v":0},{"$f":"ECPR!L13","v":""},{"$f":"ECPR!M13","v":""},{"$f":"ECPR!N13","v":""},{"$f":"ECPR!O13","v":0}]
["Row Crop ",null,{"$f":"ECPR!C14","v":""},{"$f":"ECPR!D14","v":""},{"$f":"ECPR!E14","v":""},{"$f":"ECPR!F14","v":""},{"$f":"ECPR!G14","v":""},{"$f":"ECPR!H14","v":""},{"$f":"ECPR!I14","v":""},{"$f":"ECPR!J14","v":""},{"$f":"ECPR!K14","v":0},{"$f":"ECPR!L14","v":""},{"$f":"ECPR!M14","v":""},{"$f":"ECPR!N14","v":""},{"$f":"ECPR!O14","v":0}]
["Row Crop ",null,{"$f":"ECPR!C15","v":""},{"$f":"ECPR!D15","v":""},{"$f":"ECPR!E15","v":""},{"$f":"ECPR!F15","v":""},{"$f":"ECPR!G15","v":""},{"$f":"ECPR!H15","v":""},{"$f":"ECPR!I15","v":""},{"$f":"ECPR!J15","v":""},{"$f":"ECPR!K15","v":0},{"$f":"ECPR!L15","v":""},{"$f":"ECPR!M15","v":""},{"$f":"ECPR!N15","v":""},{"$f":"ECPR!O15","v":0}]
["Row Crop ",null,{"$f":"ECPR!C16","v":""},{"$f":"ECPR!D16","v":""},{"$f":"ECPR!E16","v":""},{"$f":"ECPR!F16","v":""},{"$f":"ECPR!G16","v":""},{"$f":"ECPR!H16","v":""},{"$f":"ECPR!I16","v":""},{"$f":"ECPR!J16","v":""},{"$f":"ECPR!K16","v":0},{"$f":"ECPR!L16","v":""},{"$f":"ECPR!M16","v":""},{"$f":"ECPR!N16","v":""},{"$f":"ECPR!O16","v":0}]
["Row Crop ",null,{"$f":"ECPR!C17","v":""},{"$f":"ECPR!D17","v":""},{"$f":"ECPR!E17","v":""},{"$f":"ECPR!F17","v":""},{"$f":"ECPR!G17","v":""},{"$f":"ECPR!H17","v":""},{"$f":"ECPR!I17","v":""},{"$f":"ECPR!J17","v":""},{"$f":"ECPR!K17","v":0},{"$f":"ECPR!L17","v":""},{"$f":"ECPR!M17","v":""},{"$f":"ECPR!N17","v":""},{"$f":"ECPR!O17","v":0}]
["Row Crop ",null,{"$f":"ECPR!C18","v":""},{"$f":"ECPR!D18","v":""},{"$f":"ECPR!E18","v":""},{"$f":"ECPR!F18","v":""},{"$f":"ECPR!G18","v":""},{"$f":"ECPR!H18","v":""},{"$f":"ECPR!I18","v":""},{"$f":"ECPR!J18","v":""},{"$f":"ECPR!K18","v":0},{"$f":"ECPR!L18","v":""},{"$f":"ECPR!M18","v":""},{"$f":"ECPR!N18","v":""},{"$f":"ECPR!O18","v":0}]
["Row Crop ",null,{"$f":"ECPR!C19","v":""},{"$f":"ECPR!D19","v":""},{"$f":"ECPR!E19","v":""},{"$f":"ECPR!F19","v":""},{"$f":"ECPR!G19","v":""},{"$f":"ECPR!H19","v":""},{"$f":"ECPR!I19","v":""},{"$f":"ECPR!J19","v":""},{"$f":"ECPR!K19","v":0},{"$f":"ECPR!L19","v":""},{"$f":"ECPR!M19","v":""},{"$f":"ECPR!N19","v":""},{"$f":"ECPR!O19","v":0}]
["Row Crop ",null,{"$f":"ECPR!C20","v":""},{"$f":"ECPR!D20","v":""},{"$f":"ECPR!E20","v":""},{"$f":"ECPR!F20","v":""},{"$f":"ECPR!G20","v":""},{"$f":"ECPR!H20","v":""},{"$f":"ECPR!I20","v":""},{"$f":"ECPR!J20","v":""},{"$f":"ECPR!K20","v":0},{"$f":"ECPR!L20","v":""},{"$f":"ECPR!M20","v":""},{"$f":"ECPR!N20","v":""},{"$f":"ECPR!O20","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K14)","v":0},null,null,null,{"$f":"SUM(O5:O14)","v":0}]
[null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]
[]
[]
[]
[null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"}]
[null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-06-02"},null,"Page 2 of 4"]
[]
[]
[]
[]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Category","Commodity",null,"26) \nValue of  Sales (January 15, 2020 - April 15, 2020)","CARES Value Loss Factor","CARES Gross Payment\n(E Adusted by F, if applicable, * H)","27) \nValue of  Inventory (as of April 15, 2020)","CCC Value Loss Factor","CCC Gross Payment \n(K Adusted by L, if applicable, * N)"]
[{"$f":"\"Value Loss \"&C38","v":"Value Loss "},"Value Loss",{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(E38*F38,2))","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H38=\"\",\"\",ROUND(H38*I38,2))","v":""}]
[{"$f":"\"Value Loss \"&C39","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E39=\"\",\"\",ROUND(E39*F39,2))","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H39=\"\",\"\",ROUND(H39*I39,2))","v":""}]
[{"$f":"\"Value Loss \"&C40","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E40=\"\",\"\",ROUND(E40*F40,2))","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H40=\"\",\"\",ROUND(H40*I40,2))","v":""}]
[{"$f":"\"Value Loss \"&C41","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},{"$f":"IF(C41=\"\",\"\",VLOOKUP(A41,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E41=\"\",\"\",ROUND(E41*F41,2))","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF(C41=\"\",\"\",VLOOKUP(A41,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H41=\"\",\"\",ROUND(H41*I41,2))","v":""}]
[{"$f":"\"Value Loss \"&C42","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},{"$f":"IF(C42=\"\",\"\",VLOOKUP(A42,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E42=\"\",\"\",ROUND(E42*F42,2))","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF(C42=\"\",\"\",VLOOKUP(A42,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H42=\"\",\"\",ROUND(H42*I42,2))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G38:G42)","v":0},null,null,{"$f":"SUM(J38:J42)","v":0}]

{"sheet":"ECPR_P3","index":6,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":true,"merged":[[19,1,19,2],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,0,17,8],[1,4,1,8],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[1,2,1,3],[1,9,1,10],[2,1,2,2],[2,3,2,5],[10,9,10,10],[11,9,11,10],[8,9,8,10],[9,9,9,10],[4,1,13,1],[7,9,7,10]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,null,{"$f":"'Data Entry'!I9","v":0}]
[null,"Recording County:",null,{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""}]
[null,"Category","Livestock","Unit of Measure","21)\nJan 15, 2020 – April 15, 2020 Sales of Owned Invetnory as of Jan 15, 2020 and any Offspirng from Owned Inventory","CARES Payment Rate\n(Part 1)","80%\nEstimated CARES Gross Payment  before payment limits and other reductions","22)\n Inventory\n(Highest Between\n April 16, 2020 -  May 14, 2020","CCC Payment Rate\n(Part 2)","80%\nEstimated CCC Gross Payment  before payment limits and other reductions"]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},{"$f":"ECPR!B24","v":"Livestock"},{"$f":"ECPR!C24","v":""},{"$f":"ECPR!D24","v":""},{"$f":"ECPR!E24","v":""},{"$f":"ECPR!F24","v":""},{"$f":"ECPR!G24","v":0},{"$f":"ECPR!H24","v":""},{"$f":"ECPR!I24","v":""},{"$f":"ECPR!J24","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C25","v":""},{"$f":"ECPR!D25","v":""},{"$f":"ECPR!E25","v":""},{"$f":"ECPR!F25","v":""},{"$f":"ECPR!G25","v":0},{"$f":"ECPR!H25","v":""},{"$f":"ECPR!I25","v":""},{"$f":"ECPR!J25","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C26","v":""},{"$f":"ECPR!D26","v":""},{"$f":"ECPR!E26","v":""},{"$f":"ECPR!F26","v":""},{"$f":"ECPR!G26","v":0},{"$f":"ECPR!H26","v":""},{"$f":"ECPR!I26","v":""},{"$f":"ECPR!J26","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C27","v":""},{"$f":"ECPR!D27","v":""},{"$f":"ECPR!E27","v":""},{"$f":"ECPR!F27","v":""},{"$f":"ECPR!G27","v":0},{"$f":"ECPR!H27","v":""},{"$f":"ECPR!I27","v":""},{"$f":"ECPR!J27","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C28","v":""},{"$f":"ECPR!D28","v":""},{"$f":"ECPR!E28","v":""},{"$f":"ECPR!F28","v":""},{"$f":"ECPR!G28","v":0},{"$f":"ECPR!H28","v":""},{"$f":"ECPR!I28","v":""},{"$f":"ECPR!J28","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C29","v":""},{"$f":"ECPR!D29","v":""},{"$f":"ECPR!E29","v":""},{"$f":"ECPR!F29","v":""},{"$f":"ECPR!G29","v":0},{"$f":"ECPR!H29","v":""},{"$f":"ECPR!I29","v":""},{"$f":"ECPR!J29","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C30","v":""},{"$f":"ECPR!D30","v":""},{"$f":"ECPR!E30","v":""},{"$f":"ECPR!F30","v":""},{"$f":"ECPR!G30","v":0},{"$f":"ECPR!H30","v":""},{"$f":"ECPR!I30","v":""},{"$f":"ECPR!J30","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C31","v":""},{"$f":"ECPR!D31","v":""},{"$f":"ECPR!E31","v":""},{"$f":"ECPR!F31","v":""},{"$f":"ECPR!G31","v":0},{"$f":"ECPR!H31","v":""},{"$f":"ECPR!I31","v":""},{"$f":"ECPR!J31","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C32","v":""},{"$f":"ECPR!D32","v":""},{"$f":"ECPR!E32","v":""},{"$f":"ECPR!F32","v":""},{"$f":"ECPR!G32","v":0},{"$f":"ECPR!H32","v":""},{"$f":"ECPR!I32","v":""},{"$f":"ECPR!J32","v":0}]
[{"$f":"\"Row Crop \"&#REF!","v":{"$error":"#REF!"}},null,{"$f":"ECPR!C33","v":""},{"$f":"ECPR!D33","v":""},{"$f":"ECPR!E33","v":""},{"$f":"ECPR!F33","v":""},{"$f":"ECPR!G33","v":0},{"$f":"ECPR!H33","v":""},{"$f":"ECPR!I33","v":""},{"$f":"ECPR!J33","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(G5:G14)","v":0},null,null,{"$f":"SUM(J5:J14)","v":0}]
["Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]
[]
[]
[]
[null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"},null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-06-02"},null,null,"Page 3 of 4"]
[]
[]
[]
[]
[{"$f":"\"Livestock \"&C5","v":"Livestock "}]
["Livestock "]
["Livestock "]
["Livestock "]
["Livestock "]
["Livestock "]
["Livestock "]

{"sheet":"ECPR_P4","index":7,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[[1,12,1,13],[2,1,2,2],[2,3,2,5],[1,4,1,11],[4,1,14,1],[21,1,21,2],[37,2,37,3],[1,2,1,3],[38,1,42,1],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[16,1,18,9]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,null,null,null,null,{"$f":"'Data Entry'!I9","v":0}]
[null,"Recording County:",null,{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""}]
[null,"Category","Commodity","Unit of Measure","Item 32)\nVolume of Production Sold \n(Jan 15, 2020 - April 15, 2020)","CARES - Quantity %","CARES Payment Quantity","CARES  Payment Rate","80%\nEstimated CARES Gross Payment before payment limits and other reductions","33)\nVolume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -April\n15, 2020)","CARES  Payment Rate","80%\nEstimated CARES Gross Payment before payment limits and other reductions\n","34)\nAcres with Production Not Shipped or Sold \n(Jan 15, 2020 -April 15)","CCC Payment Quantity (Production per acre from AMS multiplied by item X (application))","CCC  Payment Rate","80% Estimated CCC Gross Payment before payment limits and other reductions"]
[{"$f":"$B$5&\" \"&C5","v":"Specialty crops "},{"$f":"ECPR!B44","v":"Specialty crops"},{"$f":"ECPR!C44","v":""},{"$f":"ECPR!D44","v":""},{"$f":"IF('Data Entry'!E50=\"\",\"\",'Data Entry'!E50)","v":""},{"$f":"IF(C5=\"\",\"\",VLOOKUP(A5,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E5=\"\",\"\",ROUND(E5*F5,0))","v":""},{"$f":"ECPR!H44","v":""},{"$f":"IF(OR(D5=\"\",C5=\"\",E5=\"\"),0,ROUND(G5*H5*0.8,2))","v":0},{"$f":"IF('Data Entry'!F50=\"\",\"\",'Data Entry'!F50)","v":""},{"$f":"ECPR!K44","v":""},{"$f":"IF(OR(J5=\"\",K5=\"\"),0,ROUND(J5*K5*0.8,2))","v":0},{"$f":"IF('Data Entry'!G50=\"\",\"\",'Data Entry'!G50)","v":""},{"$f":"ECPR!F57","v":""},{"$f":"ECPR!G57","v":""},{"$f":"IF(OR(N5=\"\",O5=\"\"),0,ROUND(N5*O5*0.8,2))","v":0}]
["Specialty crops ",null,{"$f":"ECPR!C45","v":""},{"$f":"ECPR!D45","v":""},{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},{"$f":"IF(C6=\"\",\"\",VLOOKUP(A6,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E6=\"\",\"\",ROUND(E6*F6,0))","v":""},{"$f":"ECPR!H45","v":""},{"$f":"IF(OR(D6=\"\",C6=\"\",E6=\"\"),0,ROUND(G6*H6*0.8,2))","v":0},{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},{"$f":"ECPR!K45","v":""},{"$f":"IF(OR(J6=\"\",K6=\"\"),0,ROUND(J6*K6*0.8,2))","v":0},{"$f":"IF('Data Entry'!G51=\"\",\"\",'Data Entry'!G51)","v":""},{"$f":"ECPR!F58","v":""},{"$f":"ECPR!G58","v":""},{"$f":"IF(OR(N6=\"\",O6=\"\"),0,ROUND(N6*O6*0.8,2))","v":0}]
["Specialty crops ",null,{"$f":"ECPR!C46","v":""},{"$f":"ECPR!D46","v":""},{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},{"$f":"IF(C7=\"\",\"\",VLOOKUP(A7,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H46","v":""},0,{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},{"$f":"ECPR!K46","v":""},0,{"$f":"IF('Data Entry'!G52=\"\",\"\",'Data Entry'!G52)","v":""},{"$f":"ECPR!F59","v":""},{"$f":"ECPR!G59","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C47","v":""},{"$f":"ECPR!D47","v":""},{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""},{"$f":"IF(C8=\"\",\"\",VLOOKUP(A8,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H47","v":""},0,{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""},{"$f":"ECPR!K47","v":""},0,{"$f":"IF('Data Entry'!G53=\"\",\"\",'Data Entry'!G53)","v":""},{"$f":"ECPR!F60","v":""},{"$f":"ECPR!G60","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C48","v":""},{"$f":"ECPR!D48","v":""},{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},{"$f":"IF(C9=\"\",\"\",VLOOKUP(A9,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H48","v":""},0,{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},{"$f":"ECPR!K48","v":""},0,{"$f":"IF('Data Entry'!G54=\"\",\"\",'Data Entry'!G54)","v":""},{"$f":"ECPR!F61","v":""},{"$f":"ECPR!G61","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C49","v":""},{"$f":"ECPR!D49","v":""},{"$f":"IF('Data Entry'!E55=\"\",\"\",'Data Entry'!E55)","v":""},{"$f":"IF(C10=\"\",\"\",VLOOKUP(A10,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H49","v":""},0,{"$f":"IF('Data Entry'!F55=\"\",\"\",'Data Entry'!F55)","v":""},{"$f":"ECPR!K49","v":""},0,{"$f":"IF('Data Entry'!G55=\"\",\"\",'Data Entry'!G55)","v":""},{"$f":"ECPR!F62","v":""},{"$f":"ECPR!G62","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C50","v":""},{"$f":"ECPR!D50","v":""},{"$f":"IF('Data Entry'!E56=\"\",\"\",'Data Entry'!E56)","v":""},{"$f":"IF(C11=\"\",\"\",VLOOKUP(A11,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H50","v":""},0,{"$f":"IF('Data Entry'!F56=\"\",\"\",'Data Entry'!F56)","v":""},{"$f":"ECPR!K50","v":""},0,{"$f":"IF('Data Entry'!G56=\"\",\"\",'Data Entry'!G56)","v":""},{"$f":"ECPR!F63","v":""},{"$f":"ECPR!G63","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C51","v":""},{"$f":"ECPR!D51","v":""},{"$f":"IF('Data Entry'!E57=\"\",\"\",'Data Entry'!E57)","v":""},{"$f":"IF(C12=\"\",\"\",VLOOKUP(A12,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H51","v":""},0,{"$f":"IF('Data Entry'!F57=\"\",\"\",'Data Entry'!F57)","v":""},{"$f":"ECPR!K51","v":""},0,{"$f":"IF('Data Entry'!G57=\"\",\"\",'Data Entry'!G57)","v":""},{"$f":"ECPR!F64","v":""},{"$f":"ECPR!G64","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C52","v":""},{"$f":"ECPR!D52","v":""},{"$f":"IF('Data Entry'!E58=\"\",\"\",'Data Entry'!E58)","v":""},{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H52","v":""},0,{"$f":"IF('Data Entry'!F58=\"\",\"\",'Data Entry'!F58)","v":""},{"$f":"ECPR!K52","v":""},0,{"$f":"IF('Data Entry'!G58=\"\",\"\",'Data Entry'!G58)","v":""},{"$f":"ECPR!F65","v":""},{"$f":"ECPR!G65","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C53","v":""},{"$f":"ECPR!D53","v":""},{"$f":"IF('Data Entry'!E59=\"\",\"\",'Data Entry'!E59)","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,PAS!$A$4:$L$202,10,FALSE))","v":""},"",{"$f":"ECPR!H53","v":""},0,{"$f":"IF('Data Entry'!F59=\"\",\"\",'Data Entry'!F59)","v":""},{"$f":"ECPR!K53","v":""},0,{"$f":"IF('Data Entry'!G59=\"\",\"\",'Data Entry'!G59)","v":""},{"$f":"ECPR!F66","v":""},{"$f":"ECPR!G66","v":""},0]
["Specialty crops 0",null,{"$f":"ECPR!C54","v":0},{"$f":"ECPR!D54","v":0},{"$f":"IF('Data Entry'!E60=\"\",\"\",'Data Entry'!E60)","v":""},{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,PAS!$A$4:$L$202,10,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(E15=\"\",\"\",ROUND(E15*F15,0))","v":""},{"$f":"ECPR!H54","v":0},{"$f":"IF(OR(D15=\"\",C15=\"\",E15=\"\"),0,ROUND(G15*H15*0.8,2))","v":0},{"$f":"IF('Data Entry'!F60=\"\",\"\",'Data Entry'!F60)","v":""},{"$f":"ECPR!K54","v":0},{"$f":"IF(OR(J15=\"\",K15=\"\"),0,ROUND(J15*K15*0.8,2))","v":0},{"$f":"IF('Data Entry'!G60=\"\",\"\",'Data Entry'!G60)","v":""},{"$f":"ECPR!F67","v":0},{"$f":"ECPR!G67","v":0},{"$f":"IF(OR(N15=\"\",O15=\"\"),0,ROUND(N15*O15*0.8,2))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I5:I15)","v":0},null,null,{"$f":"SUM(L5:L15)","v":0},null,null,null,{"$f":"SUM(P5:P15)","v":0}]
[null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]
[]
[]
[]
[]
[null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"},null,null,null,null,"Date",null,null,null,null,{"$f":"TODAY()","v":"2020-06-02"},null,"Page 4 of 4"]
[]
[]
[]
[]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Livestock \"&#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Category","Commodity",null,"26) \nValue of  Sales (January 15, 2020 - April 15, 2020)","CARES Value Loss Factor","CARES Gross Payment\n(E Adusted by F, if applicable, * H)","27) \nValue of  Inventory (as of April 15, 2020)","CCC Value Loss Factor","CCC Gross Payment \n(K Adusted by L, if applicable, * N)"]
[{"$f":"\"Value Loss \"&C39","v":"Value Loss "},"Value Loss",{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E39=\"\",\"\",ROUND(E39*F39,2))","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H39=\"\",\"\",ROUND(H39*I39,2))","v":""}]
[{"$f":"\"Value Loss \"&C40","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E40=\"\",\"\",ROUND(E40*F40,2))","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H40=\"\",\"\",ROUND(H40*I40,2))","v":""}]
[{"$f":"\"Value Loss \"&C41","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},{"$f":"IF(C41=\"\",\"\",VLOOKUP(A41,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E41=\"\",\"\",ROUND(E41*F41,2))","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF(C41=\"\",\"\",VLOOKUP(A41,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H41=\"\",\"\",ROUND(H41*I41,2))","v":""}]
[{"$f":"\"Value Loss \"&C42","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},{"$f":"IF(C42=\"\",\"\",VLOOKUP(A42,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E42=\"\",\"\",ROUND(E42*F42,2))","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF(C42=\"\",\"\",VLOOKUP(A42,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H42=\"\",\"\",ROUND(H42*I42,2))","v":""}]
[{"$f":"\"Value Loss \"&C43","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},{"$f":"IF(C43=\"\",\"\",VLOOKUP(A43,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E43=\"\",\"\",ROUND(E43*F43,2))","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF(C43=\"\",\"\",VLOOKUP(A43,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H43=\"\",\"\",ROUND(H43*I43,2))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G39:G43)","v":0},null,null,{"$f":"SUM(J39:J43)","v":0}]

{"sheet":"ECPR","index":8,"n_rows":284,"n_cols":20,"rows_kept":284,"cut":false,"hidden":false,"merged":[[1,10,3,11],[1,5,3,9],[67,1,68,7],[1,12,1,13],[2,2,2,3],[56,1,65,1],[35,2,35,3],[36,2,36,3],[37,2,37,3],[35,1,39,1],[1,2,1,3],[10,1,19,1],[23,1,32,1],[43,1,52,1],[34,2,34,3],[38,2,38,3],[39,2,39,3]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,null,null,{"$f":"'Data Entry'!I9","v":0},null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"}]
[null,"Recording County:",{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-06-02"}]
[null,"Category","Commodity Name","Unit of Measure","7)\nJan.  Prod.","8) \nFeb.  Prod.","9)\nMarch  Prod.","2019 Total  Prod. \n","CARES  Payment Rate\n(per pound)","80%\nEstimated CARES Gross Payment  before payment limits and other reductions\n(H*I*80%)","Total  Production","Quarter 2 National Adjustment","CCC Payment Rate\n(per pound)","80%\nEstimated CCC Gross Payment before payment limits and other reductions\n(K*L*M* 80%)"]
["Milk","Dairy","Milk",{"$f":"(VLOOKUP(A7,$B100:$S$500,6))","v":"pounds"},{"$f":"IF('Data Entry'!D12=\"\",\"\",'Data Entry'!D12)","v":""},{"$f":"IF('Data Entry'!E12=\"\",\"\",'Data Entry'!E12)","v":""},{"$f":"IF('Data Entry'!F12=\"\",\"\",'Data Entry'!F12)","v":""},{"$f":"SUM(E7:G7)","v":0},{"$f":"IF(AND(E7=\"\",F7=\"\",G7=\"\"),\"\",(VLOOKUP(A7,$B100:$S$500,7)))","v":""},{"$f":"IF(OR(H7=\"\",I7=\"\"),0,ROUND(H7*I7*0.8,2))","v":0},{"$f":"H7","v":0},1.014,{"$f":"IF(AND(E7=\"\",F7=\"\",G7=\"\"),\"\",(VLOOKUP(A7,$B100:$S$500,8)))","v":""},{"$f":"IF(OR(H7=\"\",M7=\"\"),0,ROUND(K7*M7*L7*0.8,2))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J7","v":0},null,null,null,{"$f":"N7","v":0}]
[]
[null,"Category","Commodity Name","Unit of Measure","15) \n2019 Total Prod","16) \n 2019  Prod Not Sold","Smaller of Total of 2019 Production or  Production Not Sold  ((E *50%) or F])","CARES - Quantity Factor (Part 1)","CARES Payment Quantity \n(G*H)","CARES Payment Rate\n(Part 1)","80%\nEstimated CARES Gross Payment before payment limits and other reductions    \n (I*J *80%)","CCC - Quantity Factor          (Part 2)","CCC Payment Quantity \n(K*L)","CCC  Payment Rate\n(Part 2)","80%\nEstimated CCC Gross Payment before payment limits and other reductions     (M*N*80%)"]
[{"$f":"\"Row Crop \"&C11","v":"Row Crop "},"Non-specialty crops and wool",{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},{"$f":"IF(C11=\"\",\"\",VLOOKUP(A11,$B$100:$S500,6))","v":""},{"$f":"IF('Data Entry'!E16=\"\",\"\",'Data Entry'!E16)","v":""},{"$f":"IF('Data Entry'!F16=\"\",\"\",'Data Entry'!F16)","v":""},{"$f":"IF(OR(E11=\"\",F11=\"\"),\"\",IF(E11/2<F11,ROUND(E11/2,2),F11))","v":""},{"$f":"IF(C11=\"\",\"\",(VLOOKUP(A11,$B$100:$O500,10)))","v":""},{"$f":"IF(G11=\"\",\"\",ROUND(G11*H11,2))","v":""},{"$f":"IF(C11=\"\",\"\",(VLOOKUP(A11,$B$100:$L500,7)))","v":""},{"$f":"IF(OR(I11=\"\",J11=\"\"),0,ROUND(I11*J11*0.8,2))","v":0},{"$f":"IF(C11=\"\",\"\",VLOOKUP(A11,$B$100:$S500,12))","v":""},{"$f":"IF(G11=\"\",\"\",ROUND(G11*L11,2))","v":""},{"$f":"IF(C11=\"\",\"\",VLOOKUP(A11,$B$100:$S500,8))","v":""},{"$f":"IF(OR(M11=\"\",N11=\"\"),0,ROUND(M11*N11*0.8,2))","v":0}]
[{"$f":"\"Row Crop \"&C12","v":"Row Crop "},null,{"$f":"IF('Data Entry'!C17=\"\",\"\",'Data Entry'!C17)","v":""},{"$f":"IF(C12=\"\",\"\",VLOOKUP(A12,$B$100:$S501,6))","v":""},{"$f":"IF('Data Entry'!E17=\"\",\"\",'Data Entry'!E17)","v":""},{"$f":"IF('Data Entry'!F17=\"\",\"\",'Data Entry'!F17)","v":""},{"$f":"IF(OR(E12=\"\",F12=\"\"),\"\",IF(E12/2<F12,ROUND(E12/2,2),F12))","v":""},{"$f":"IF(C12=\"\",\"\",(VLOOKUP(A12,$B$100:$O501,10)))","v":""},{"$f":"IF(G12=\"\",\"\",ROUND(G12*H12,2))","v":""},{"$f":"IF(C12=\"\",\"\",(VLOOKUP(A12,$B$100:$L501,7)))","v":""},{"$f":"IF(OR(I12=\"\",J12=\"\"),0,ROUND(I12*J12*0.8,2))","v":0},{"$f":"IF(C12=\"\",\"\",VLOOKUP(A12,$B$100:$S501,12))","v":""},{"$f":"IF(G12=\"\",\"\",ROUND(G12*L12,2))","v":""},{"$f":"IF(C12=\"\",\"\",VLOOKUP(A12,$B$100:$S501,8))","v":""},{"$f":"IF(OR(M12=\"\",N12=\"\"),0,ROUND(M12*N12*0.8,2))","v":0}]
["Row Crop ",null,{"$f":"IF('Data Entry'!C18=\"\",\"\",'Data Entry'!C18)","v":""},{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,$B$100:$S502,6))","v":""},{"$f":"IF('Data Entry'!E18=\"\",\"\",'Data Entry'!E18)","v":""},{"$f":"IF('Data Entry'!F18=\"\",\"\",'Data Entry'!F18)","v":""},"",{"$f":"IF(C13=\"\",\"\",(VLOOKUP(A13,$B$100:$O502,10)))","v":""},"",{"$f":"IF(C13=\"\",\"\",(VLOOKUP(A13,$B$100:$L502,7)))","v":""},0,{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,$B$100:$S502,12))","v":""},"",{"$f":"IF(C13=\"\",\"\",VLOOKUP(A13,$B$100:$S502,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C19=\"\",\"\",'Data Entry'!C19)","v":""},{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,$B$100:$S503,6))","v":""},{"$f":"IF('Data Entry'!E19=\"\",\"\",'Data Entry'!E19)","v":""},{"$f":"IF('Data Entry'!F19=\"\",\"\",'Data Entry'!F19)","v":""},"",{"$f":"IF(C14=\"\",\"\",(VLOOKUP(A14,$B$100:$O503,10)))","v":""},"",{"$f":"IF(C14=\"\",\"\",(VLOOKUP(A14,$B$100:$L503,7)))","v":""},0,{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,$B$100:$S503,12))","v":""},"",{"$f":"IF(C14=\"\",\"\",VLOOKUP(A14,$B$100:$S503,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C20)","v":""},{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,$B$100:$S504,6))","v":""},{"$f":"IF('Data Entry'!E20=\"\",\"\",'Data Entry'!E20)","v":""},{"$f":"IF('Data Entry'!F20=\"\",\"\",'Data Entry'!F20)","v":""},"",{"$f":"IF(C15=\"\",\"\",(VLOOKUP(A15,$B$100:$O504,10)))","v":""},"",{"$f":"IF(C15=\"\",\"\",(VLOOKUP(A15,$B$100:$L504,7)))","v":""},0,{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,$B$100:$S504,12))","v":""},"",{"$f":"IF(C15=\"\",\"\",VLOOKUP(A15,$B$100:$S504,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},{"$f":"IF(C16=\"\",\"\",VLOOKUP(A16,$B$100:$S505,6))","v":""},{"$f":"IF('Data Entry'!E21=\"\",\"\",'Data Entry'!E21)","v":""},{"$f":"IF('Data Entry'!F21=\"\",\"\",'Data Entry'!F21)","v":""},"",{"$f":"IF(C16=\"\",\"\",(VLOOKUP(A16,$B$100:$O505,10)))","v":""},"",{"$f":"IF(C16=\"\",\"\",(VLOOKUP(A16,$B$100:$L505,7)))","v":""},0,{"$f":"IF(C16=\"\",\"\",VLOOKUP(A16,$B$100:$S505,12))","v":""},"",{"$f":"IF(C16=\"\",\"\",VLOOKUP(A16,$B$100:$S505,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C22=\"\",\"\",'Data Entry'!C22)","v":""},{"$f":"IF(C17=\"\",\"\",VLOOKUP(A17,$B$100:$S506,6))","v":""},{"$f":"IF('Data Entry'!E22=\"\",\"\",'Data Entry'!E22)","v":""},{"$f":"IF('Data Entry'!F22=\"\",\"\",'Data Entry'!F22)","v":""},"",{"$f":"IF(C17=\"\",\"\",(VLOOKUP(A17,$B$100:$O506,10)))","v":""},"",{"$f":"IF(C17=\"\",\"\",(VLOOKUP(A17,$B$100:$L506,7)))","v":""},0,{"$f":"IF(C17=\"\",\"\",VLOOKUP(A17,$B$100:$S506,12))","v":""},"",{"$f":"IF(C17=\"\",\"\",VLOOKUP(A17,$B$100:$S506,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C23=\"\",\"\",'Data Entry'!C23)","v":""},{"$f":"IF(C18=\"\",\"\",VLOOKUP(A18,$B$100:$S507,6))","v":""},{"$f":"IF('Data Entry'!E23=\"\",\"\",'Data Entry'!E23)","v":""},{"$f":"IF('Data Entry'!F23=\"\",\"\",'Data Entry'!F23)","v":""},"",{"$f":"IF(C18=\"\",\"\",(VLOOKUP(A18,$B$100:$O507,10)))","v":""},"",{"$f":"IF(C18=\"\",\"\",(VLOOKUP(A18,$B$100:$L507,7)))","v":""},0,{"$f":"IF(C18=\"\",\"\",VLOOKUP(A18,$B$100:$S507,12))","v":""},"",{"$f":"IF(C18=\"\",\"\",VLOOKUP(A18,$B$100:$S507,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},{"$f":"IF(C19=\"\",\"\",VLOOKUP(A19,$B$100:$S508,6))","v":""},{"$f":"IF('Data Entry'!E24=\"\",\"\",'Data Entry'!E24)","v":""},{"$f":"IF('Data Entry'!F24=\"\",\"\",'Data Entry'!F24)","v":""},"",{"$f":"IF(C19=\"\",\"\",(VLOOKUP(A19,$B$100:$O508,10)))","v":""},"",{"$f":"IF(C19=\"\",\"\",(VLOOKUP(A19,$B$100:$L508,7)))","v":""},0,{"$f":"IF(C19=\"\",\"\",VLOOKUP(A19,$B$100:$S508,12))","v":""},"",{"$f":"IF(C19=\"\",\"\",VLOOKUP(A19,$B$100:$S508,8))","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C25=\"\",\"\",'Data Entry'!C25)","v":""},{"$f":"IF(C20=\"\",\"\",VLOOKUP(A20,$B$100:$S509,6))","v":""},{"$f":"IF('Data Entry'!E25=\"\",\"\",'Data Entry'!E25)","v":""},{"$f":"IF('Data Entry'!F25=\"\",\"\",'Data Entry'!F25)","v":""},"",{"$f":"IF(C20=\"\",\"\",(VLOOKUP(A20,$B$100:$O509,10)))","v":""},"",{"$f":"IF(C20=\"\",\"\",(VLOOKUP(A20,$B$100:$L509,7)))","v":""},0,{"$f":"IF(C20=\"\",\"\",VLOOKUP(A20,$B$100:$S509,12))","v":""},"",{"$f":"IF(C20=\"\",\"\",VLOOKUP(A20,$B$100:$S509,8))","v":""},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K20)","v":0},null,null,null,{"$f":"SUM(O11:O20)","v":0}]
[]
[null,"Category","Livestock","Unit of Measure","21)\nJan 15, 2020 – April 15, 2020 Sales of Owned Invetnory as of Jan 15, 2020 and any Offspirng from Owned Inventory","CARES Payment Rate\n(Part 1)","80%\nEstimated CARES Gross Payment  before payment limits and other reductions\n (E*F*80%)","22)\n Inventory\n(Highest Between\n April 16, 2020 -  May 14, 2020","CCC Payment Rate\n(Part 2)","80%\nEstimated CCC Gross Payment  before payment limits and other reductions\n(H*I*80%)"]
[{"$f":"\"Livestock \"&C24","v":"Livestock "},"Livestock",{"$f":"IF('Data Entry'!C29=\"\",\"\",'Data Entry'!C29)","v":""},{"$f":"IF(C24=\"\",\"\",VLOOKUP(A24,$B$100:$L$500,6))","v":""},{"$f":"IF('Data Entry'!E29=\"\",\"\",'Data Entry'!E29)","v":""},{"$f":"IF(C24=\"\",\"\",VLOOKUP(A24,$B$100:$L$500,7))","v":""},{"$f":"IF(OR(C24=\"\",E24=\"\"),0,ROUND(E24*F24*0.8,2))","v":0},{"$f":"IF('Data Entry'!F29=\"\",\"\",'Data Entry'!F29)","v":""},{"$f":"IF(C24=\"\",\"\",VLOOKUP(A24,$B$100:$L$500,8))","v":""},{"$f":"IF(OR(C24=\"\",H24=\"\"),0,ROUND(H24*I24*0.8,2))","v":0}]
[{"$f":"\"Livestock \"&C25","v":"Livestock "},null,{"$f":"IF('Data Entry'!C30=\"\",\"\",'Data Entry'!C30)","v":""},{"$f":"IF(C25=\"\",\"\",VLOOKUP(A25,$B$100:$L$500,6))","v":""},{"$f":"IF('Data Entry'!E30=\"\",\"\",'Data Entry'!E30)","v":""},{"$f":"IF(C25=\"\",\"\",VLOOKUP(A25,$B$100:$L$500,7))","v":""},{"$f":"IF(OR(C25=\"\",E25=\"\"),0,ROUND(E25*F25*0.8,2))","v":0},{"$f":"IF('Data Entry'!F30=\"\",\"\",'Data Entry'!F30)","v":""},{"$f":"IF(C25=\"\",\"\",VLOOKUP(A25,$B$100:$L$500,8))","v":""},{"$f":"IF(OR(C25=\"\",H25=\"\"),0,ROUND(H25*I25*0.8,2))","v":0}]
["Livestock ",null,{"$f":"IF('Data Entry'!C31=\"\",\"\",'Data Entry'!C31)","v":""},"",{"$f":"IF('Data Entry'!E31=\"\",\"\",'Data Entry'!E31)","v":""},"",0,{"$f":"IF('Data Entry'!F31=\"\",\"\",'Data Entry'!F31)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C32=\"\",\"\",'Data Entry'!C32)","v":""},"",{"$f":"IF('Data Entry'!E32=\"\",\"\",'Data Entry'!E32)","v":""},"",0,{"$f":"IF('Data Entry'!F32=\"\",\"\",'Data Entry'!F32)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C33=\"\",\"\",'Data Entry'!C33)","v":""},"",{"$f":"IF('Data Entry'!E33=\"\",\"\",'Data Entry'!E33)","v":""},"",0,{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C34=\"\",\"\",'Data Entry'!C34)","v":""},"",{"$f":"IF('Data Entry'!E34=\"\",\"\",'Data Entry'!E34)","v":""},"",0,{"$f":"IF('Data Entry'!F34=\"\",\"\",'Data Entry'!F34)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":""},"",{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},"",0,{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C36=\"\",\"\",'Data Entry'!C36)","v":""},"",{"$f":"IF('Data Entry'!E36=\"\",\"\",'Data Entry'!E36)","v":""},"",0,{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C37=\"\",\"\",'Data Entry'!C37)","v":""},"",{"$f":"IF('Data Entry'!E37=\"\",\"\",'Data Entry'!E37)","v":""},"",0,{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""},"",0]
["Livestock ",null,{"$f":"IF('Data Entry'!C38=\"\",\"\",'Data Entry'!C38)","v":""},"",{"$f":"IF('Data Entry'!E38=\"\",\"\",'Data Entry'!E38)","v":""},"",0,{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""},"",0]
[null,null,null,null,null,null,{"$f":"SUM(G24:G33)","v":0},null,null,{"$f":"SUM(J24:J33)","v":0}]
[null,"Category","Commodity",null,"26) \nValue of  Sales (January 15, 2020 - April 15, 2020)","CARES Value Loss Factor","CARES Gross Payment\n(E Adusted by F, if applicable, * H)","27) \nValue of  Inventory (as of April 15, 2020)","CCC Value Loss Factor","CCC Gross Payment \n(K Adusted by L, if applicable, * N)"]
[{"$f":"\"Value Loss \"&C36","v":"Value Loss "},"Value Loss",{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,$B100:$L$202,10))","v":""},{"$f":"IF(E36=\"\",\"\",ROUND(E36*F36,2))","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,$B100:$L$202,12))","v":""},{"$f":"IF(H36=\"\",\"\",ROUND(H36*I36,2))","v":""}]
[{"$f":"\"Value Loss \"&C37","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,$B100:$L$202,10))","v":""},{"$f":"IF(E37=\"\",\"\",ROUND(E37*F37,2))","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,$B100:$L$202,12))","v":""},{"$f":"IF(H37=\"\",\"\",ROUND(H37*I37,2))","v":""}]
[{"$f":"\"Value Loss \"&C38","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,$B100:$L$202,10))","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(E38*F38,2))","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,$B100:$L$202,12))","v":""},{"$f":"IF(H38=\"\",\"\",ROUND(H38*I38,2))","v":""}]
[{"$f":"\"Value Loss \"&C39","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,$B100:$L$202,10))","v":""},{"$f":"IF(E39=\"\",\"\",ROUND(E39*F39,2))","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF(C39=\"\",\"\",VLOOKUP(A39,$B100:$L$202,12))","v":""},{"$f":"IF(H39=\"\",\"\",ROUND(H39*I39,2))","v":""}]
[{"$f":"\"Value Loss \"&C40","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,$B100:$L$202,10))","v":""},{"$f":"IF(E40=\"\",\"\",ROUND(E40*F40,2))","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF(C40=\"\",\"\",VLOOKUP(A40,$B100:$L$202,12))","v":""},{"$f":"IF(H40=\"\",\"\",ROUND(H40*I40,2))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G36:G40)","v":0},null,null,{"$f":"SUM(J36:J40)","v":0}]
[]
[null,"Category","Commodity","Unit of Measure","Item 32)\nVolume of Production Sold \n(Jan 15, 2020 - April 15, 2020)","CARES - Quantity %","CARES Payment Quantity\n(Bin 1)\n(E*F)","CARES  Payment Rate","80%\nEstimated CARES Gross Payment before payment limits and other reductions\n(G*H*80%)","33)\nVolume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -April\n15, 2020)","CARES  Payment Rate","80%\nEstimated CARES Gross Payment before payment limits and other reductions\n(J*K*80%)"]
[{"$f":"$B$44&\" \"&C44","v":"Specialty crops "},"Specialty crops",{"$f":"IF('Data Entry'!C50=\"\",\"\",'Data Entry'!C50)","v":""},{"$f":"IF(C44=\"\",\"\",VLOOKUP(A44,$B100:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E50=\"\",\"\",'Data Entry'!E50)","v":""},{"$f":"IF(C44=\"\",\"\",VLOOKUP(A44,$B100:$L$500,10))","v":""},{"$f":"IF(OR(E44=\"\",C44=\"\"),\"\",ROUND(E44*F44,0))","v":""},{"$f":"IF(C44=\"\",\"\",VLOOKUP(A44,$B$100:$L$502,7))","v":""},{"$f":"IF(OR(G44=\"\",C44=\"\"),0,ROUND(G44*H44*0.8,2))","v":0},{"$f":"IF('Data Entry'!F50=\"\",\"\",'Data Entry'!F50)","v":""},{"$f":"IF(C44=\"\",\"\",VLOOKUP(A44,$B$100:$L$502,8))","v":""},{"$f":"IF(OR(J44=\"\",K44=\"\"),0,ROUND(J44*K44*0.8,2))","v":0}]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C51=\"\",\"\",'Data Entry'!C51)","v":""},{"$f":"IF(C45=\"\",\"\",VLOOKUP(A45,$B101:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},{"$f":"IF(C45=\"\",\"\",VLOOKUP(A45,$B100:$L$202,10))","v":""},{"$f":"IF(OR(E45=\"\",C45=\"\"),\"\",ROUND(E45*F45,0))","v":""},{"$f":"IF(C45=\"\",\"\",VLOOKUP(A45,$B$100:$L$502,7))","v":""},{"$f":"IF(OR(G45=\"\",C45=\"\"),0,ROUND(G45*H45*0.8,2))","v":0},{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},{"$f":"IF(C45=\"\",\"\",VLOOKUP(A45,$B$100:$L$502,8))","v":""},{"$f":"IF(OR(J45=\"\",K45=\"\"),0,ROUND(J45*K45*0.8,2))","v":0}]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C52=\"\",\"\",'Data Entry'!C52)","v":""},{"$f":"IF(C46=\"\",\"\",VLOOKUP(A46,$B102:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},{"$f":"IF(C46=\"\",\"\",VLOOKUP(A46,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C53=\"\",\"\",'Data Entry'!C53)","v":""},{"$f":"IF(C47=\"\",\"\",VLOOKUP(A47,$B103:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""},{"$f":"IF(C47=\"\",\"\",VLOOKUP(A47,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C54=\"\",\"\",'Data Entry'!C54)","v":""},{"$f":"IF(C48=\"\",\"\",VLOOKUP(A48,$B104:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},{"$f":"IF(C48=\"\",\"\",VLOOKUP(A48,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C55=\"\",\"\",'Data Entry'!C55)","v":""},{"$f":"IF(C49=\"\",\"\",VLOOKUP(A49,$B105:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E55=\"\",\"\",'Data Entry'!E55)","v":""},{"$f":"IF(C49=\"\",\"\",VLOOKUP(A49,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F55=\"\",\"\",'Data Entry'!F55)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C56=\"\",\"\",'Data Entry'!C56)","v":""},{"$f":"IF(C50=\"\",\"\",VLOOKUP(A50,$B106:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E56=\"\",\"\",'Data Entry'!E56)","v":""},{"$f":"IF(C50=\"\",\"\",VLOOKUP(A50,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F56=\"\",\"\",'Data Entry'!F56)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C57=\"\",\"\",'Data Entry'!C57)","v":""},{"$f":"IF(C51=\"\",\"\",VLOOKUP(A51,$B107:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E57=\"\",\"\",'Data Entry'!E57)","v":""},{"$f":"IF(C51=\"\",\"\",VLOOKUP(A51,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F57=\"\",\"\",'Data Entry'!F57)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C58=\"\",\"\",'Data Entry'!C58)","v":""},{"$f":"IF(C52=\"\",\"\",VLOOKUP(A52,$B108:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E58=\"\",\"\",'Data Entry'!E58)","v":""},{"$f":"IF(C52=\"\",\"\",VLOOKUP(A52,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F58=\"\",\"\",'Data Entry'!F58)","v":""},"",0]
["Specialty crops ",null,{"$f":"IF('Data Entry'!C59=\"\",\"\",'Data Entry'!C59)","v":""},{"$f":"IF(C53=\"\",\"\",VLOOKUP(A53,$B109:$L$499,6))","v":""},{"$f":"IF('Data Entry'!E59=\"\",\"\",'Data Entry'!E59)","v":""},{"$f":"IF(C53=\"\",\"\",VLOOKUP(A53,$B100:$L$202,10))","v":""},"","",0,{"$f":"IF('Data Entry'!F59=\"\",\"\",'Data Entry'!F59)","v":""},"",0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I44:I53)","v":0},null,null,{"$f":"SUM(L44:L53)","v":0}]
[]
[null,"Category","Commodity","Unit of Measure","34)\nAcres with Production Not Shipped or Sold \n(Jan 15, 2020 -April 15)","CCCC Payment Quantity (Production per acre from AMS multiplied by item X (application))","CCCC  Payment Rate","80% Estimated CCC Gross Payment before payment limits and other reductions\n(F*G)"]
[null,"Specialty crops",{"$f":"IF(C44=\"\",\"\",C44)","v":""},"",{"$f":"IF('Data Entry'!G50=\"\",\"\",'Data Entry'!G50)","v":""},{"$f":"IF(E57=\"\",\"\",(ROUND(VLOOKUP(A44,$B$100:$S$500,15)*E57,0)))","v":""},{"$f":"IF(C57=\"\",\"\",VLOOKUP(A44,$B$100:$S$502,14))","v":""},{"$f":"IF(OR(F57=\"\",G57=\"\"),0,ROUND(F57*G57*0.8,2))","v":0}]
[null,null,"","",{"$f":"IF('Data Entry'!G51=\"\",\"\",'Data Entry'!G51)","v":""},{"$f":"IF(E58=\"\",\"\",(ROUND(VLOOKUP(A45,$B$100:$S$500,15)*E58,0)))","v":""},{"$f":"IF(C58=\"\",\"\",VLOOKUP(A45,$B$100:$S$502,14))","v":""},{"$f":"IF(OR(F58=\"\",G58=\"\"),0,ROUND(F58*G58*0.8,2))","v":0}]
[null,null,"","",{"$f":"IF('Data Entry'!G52=\"\",\"\",'Data Entry'!G52)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G53=\"\",\"\",'Data Entry'!G53)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G54=\"\",\"\",'Data Entry'!G54)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G55=\"\",\"\",'Data Entry'!G55)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G56=\"\",\"\",'Data Entry'!G56)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G57=\"\",\"\",'Data Entry'!G57)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G58=\"\",\"\",'Data Entry'!G58)","v":""},"","",0]
[null,null,"","",{"$f":"IF('Data Entry'!G59=\"\",\"\",'Data Entry'!G59)","v":""},"","",0]
[null,null,null,null,null,null,null,{"$f":"SUM(H57:H66)","v":0}]
[null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Category","Name","Type","Intended Use","Unit of Measure","Part 1 - Rate","Part 2 - Rate","Part 1 - Payment %","Part 1 - Quantity %","Part 2 - Payment %","Part 2 - Quantity %","Part 3 Quanitity","Price 3","Yield","pmt 1","pmt 2","pmt 3"]
[null,"Livestock All Other Cattle","Livestock","All Other Cattle",null,null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Livestock Feeder Cattle:  600 Pounds or More","Livestock","Feeder Cattle:  600 Pounds or More",">600 Pounds",null,"Head",139,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Livestock Feeder Cattle:  Less Than 600 Pounds","Livestock","Feeder Cattle:  Less Than 600 Pounds","<600 Pounds",null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Livestock Hogs: 120 Pounds or More","Livestock","Hogs: 120 Pounds or More","Hogs",null,"Head",18,17,0.8,1,0.3,1,null,0,null,"Yes","Yes","No"]
[null,"Livestock Lambs and Yearlings: Less than 2 yrs of age","Livestock","Lambs and Yearlings: Less than 2 yrs of age",null,null,"Head",33,7,null,null,null,null,null,0,null,"Yes","Yes","No"]
[null,"Livestock Pigs:  Less than 120 Pounds","Livestock","Pigs:  Less than 120 Pounds","Pigs",null,"Head",28,17,0.8,1,0.3,0.5,null,0,null,"Yes","Yes","No"]
[null,"Livestock Slaughter Cattle: Fed Cattle","Livestock","Slaughter Cattle: Fed Cattle","Fed Cattle",null,"Head",214,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Livestock Slaughter Cattle: Mature Cattle","Livestock","Slaughter Cattle: Mature Cattle","Mature Cattle",null,"Head",92,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Milk","Dairy","Dairy",null,null,"pounds",4.7100000000000003E-2,1.47E-2,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Barley, Malting","Row Crop","Barley, Malting","Malting",null,"bushels",0.34,0.37,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Canola","Row Crop","Canola",null,null,"pounds",0.01,0.01,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Corn","Row Crop","Corn",null,"Grain","bushels",0.32,0.35,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Cotton, Upland","Row Crop","Cotton, Upland","Upland",null,"pounds",0.09,0.1,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Millet","Row Crop","Millet",null,null,"bushels",0.31,0.34,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Oats","Row Crop","Oats",null,null,"bushels",0.15,0.17,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Sorghum","Row Crop","Sorghum",null,null,"bushels",0.3,0.32,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Soybeans","Row Crop","Soybeans",null,"Grain","bushels",0.45,0.5,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Sunflowers","Row Crop","Sunflowers",null,null,"pounds",0.02,0.02,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Wheat, Durum","Row Crop","Wheat, Durum","Durum","Grain","bushels",0.19,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Wheat, HRS","Row Crop","Wheat, HRS","Hard Red Spring","Grain","bushels",0.18,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Wool Graded","Row Crop","Wool Graded",null,null,"pound",0.71,0.78,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Row Crop Wool Ungraded","Row Crop","Wool Ungraded",null,null,"pound",0.36,0.39,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
[null,"Specialty Crops Almonds","Specialty","Almonds",null,null,"pounds",0.26,0.56999999999999995,0.8,1,0.3,1,1,0.11,2160,"Yes","Yes","Yes",0]
[null,"Specialty Crops Apples","Specialty","Apples",null,null,"pounds",0,0.18,0.8,1,null,1,1,0.03,37500,"No","Yes","Yes",0]
[null,"Specialty Crops Artichokes","Specialty","Artichokes",null,null,"pounds",0.66,0.49,0.8,1,null,1,1,0.1,13000,"Yes","Yes","Yes",0]
[null,"Specialty Crops ASPARAGUS","Specialty","ASPARAGUS",null,null,"pounds",0,0.38,null,null,null,1,1,7.0000000000000007E-2,3640,"No","Yes","Yes",0]
[null,"Specialty Crops AVOCADOS","Specialty","AVOCADOS",null,null,"pounds",0,0.14000000000000001,null,null,null,1,1,0.03,5120,"No","Yes","Yes",0]
[null,"Specialty Crops Beans","Specialty","Beans",null,null,"pounds",0.17,0.16,0.8,1,0.3,1,1,0.03,7793.0233600000001,"Yes","Yes","Yes",0]
[null,"Specialty Crops BLUEBERRIES","Specialty","BLUEBERRIES",null,null,"pounds",0,0.62,null,null,null,null,1,0.12,6630,"No","Yes","Yes",0]
[null,"Specialty Crops Broccoli","Specialty","Broccoli",null,null,"pounds",0.62,0.49,0.8,1,0.3,1,1,0.1,15630.000000000002,"Yes","Yes","Yes",0]
[null,"Specialty Crops Cabbage","Specialty","Cabbage",null,null,"pounds",0.04,7.0000000000000007E-2,0.8,1,null,1,1,0.01,36730,"Yes","Yes","Yes",0]
[null,"Specialty Crops CANTALOUPES","Specialty","CANTALOUPES",null,null,"pounds",0,0.1,null,null,null,1,1,0.02,23940,"No","Yes","Yes",0]
[null,"Specialty Crops Carrots","Specialty","Carrots",null,null,"pounds",0.02,0.11,0.8,1,null,1,1,0.02,62570.000000000007,"Yes","Yes","Yes",0]
[null,"Specialty Crops Cauliflower","Specialty","Cauliflower",null,null,"pounds",0.11,0.31,0.8,1,null,1,1,0.06,22120,"Yes","Yes","Yes",0]
[null,"Specialty Crops CELERY","Specialty","CELERY",null,null,"pounds",0,7.0000000000000007E-2,null,null,null,1,1,0.01,56000,"No","Yes","Yes",0]
[null,"Specialty Crops Cucumbers","Specialty","Cucumbers",null,null,"pounds",0.13,0.15,0.8,1,null,1,1,0.03,14830.000000000002,"Yes","Yes","Yes",0]
[null,"Specialty Crops Eggplant","Specialty","Eggplant",null,null,"pounds",7.0000000000000007E-2,0.15,0.8,1,null,1,1,0.03,13757.083490744239,"Yes","Yes","Yes",0]
[null,"Specialty Crops GARLIC","Specialty","GARLIC",null,null,"pounds",0,0.85,null,null,null,1,1,0.17,15500,"No","Yes","Yes",0]
[null,"Specialty Crops GRAPEFRUIT","Specialty","GRAPEFRUIT",null,null,"pounds",0,0.11,null,null,null,1,1,0.02,24838,"No","Yes","Yes",0]
[null,"Specialty Crops KIWIFRUIT","Specialty","KIWIFRUIT",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,23400,"No","Yes","Yes",0]
[null,"Specialty Crops Lemons","Specialty","Lemons",null,null,"pounds",0.08,0.21,0.8,1,0.3,1,1,0.04,35600,"Yes","Yes","Yes",0]
[null,"Specialty Crops Lettuce, Iceberg","Specialty","Lettuce, Iceberg","Iceberg",null,"pounds",0.2,0.15,0.8,1,0.3,1,1,0.03,37600,"Yes","Yes","Yes",0]
[null,"Specialty Crops Lettuce, Romaine","Specialty","Lettuce, Romaine","Romaine",null,"pounds",7.0000000000000007E-2,0.12,0.8,1,null,1,1,0.02,31180,"Yes","Yes","Yes",0]
[null,"Specialty Crops MUSHROOMS","Specialty","MUSHROOMS",null,null,"pounds",0,0.59,null,null,null,1,1,0.11,300999.60000000003,"No","Yes","Yes",0]
[null,"Specialty Crops ONIONS, Green","Specialty","ONIONS, Green",null,null,"pounds",0,0.3,null,null,null,1,1,0.06,29700,"No","Yes","Yes",0]
[null,"Specialty Crops Onions, Other","Specialty","Onions, Other",null,null,"pounds",0.01,0.05,0.8,1,null,1,1,0.01,54010,"Yes","Yes","Yes",0]
[null,"Specialty Crops Oranges","Specialty","Oranges",null,null,"pounds",0,0.14000000000000001,0.8,1,null,1,1,0.03,21161,"No","Yes","Yes",0]
[null,"Specialty Crops PAPAYA","Specialty","PAPAYA",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,17000,"No","Yes","Yes",0]
[null,"Specialty Crops Peaches","Specialty","Peaches",null,null,"pounds",0.08,0.32,0.8,1,null,1,1,0.06,18320,"Yes","Yes","Yes",0]
[null,"Specialty Crops Pears","Specialty","Pears",null,null,"pounds",0.08,0.18,0.8,1,null,1,1,0.03,32200,"Yes","Yes","Yes",0]
[null,"Specialty Crops Pecans","Specialty","Pecans",null,null,"pounds",0.28000000000000003,0.93,0.8,1,null,1,1,0.18,647,"Yes","Yes","Yes",0]
[null,"Specialty Crops Peppers, Bell","Specialty","Peppers, Bell",null,null,"pounds",0.14000000000000001,0.22,0.8,1,null,1,1,0.04,31680,"Yes","Yes","Yes",0]
[null,"Specialty Crops Peppers, Other","Specialty","Peppers, Other",null,null,"pounds",0.15,0.22,0.8,1,null,1,1,0.04,16120,"Yes","Yes","Yes",0]
[null,"Specialty Crops POTATOES","Specialty","POTATOES",null,null,"pounds",0,0.04,null,null,null,1,1,0.01,44900,"No","Yes","Yes",0]
[null,"Specialty Crops Raspberries","Specialty","Raspberries",null,null,"pounds",0,1.45,null,null,null,1,1,0.28000000000000003,13500,"No","Yes","Yes",0]
[null,"Specialty Crops Rhubarb","Specialty","Rhubarb",null,null,"pounds",0.15,1.03,0.8,1,0.3,1,1,0.2,1979.1666666666667,"Yes","Yes","Yes",0]
[null,"Specialty Crops Spinach","Specialty","Spinach",null,null,"pounds",0.37,0.37,0.8,1,0.3,1,1,7.0000000000000007E-2,14600,"Yes","Yes","Yes",0]
[null,"Specialty Crops Squash","Specialty","Squash",null,null,"pounds",0.72,0.39,0.8,1,0.3,1,1,0.08,31680,"Yes","Yes","Yes",0]
[null,"Specialty Crops Strawberries","Specialty","Strawberries",null,null,"pounds",0.84,0.72,0.8,1,0.3,1,1,0.14000000000000001,50300,"Yes","Yes","Yes",0]
[null,"Specialty Crops Sweet Corn","Specialty","Sweet Corn","Sweet",null,"pounds",0.09,0.13,0.8,1,0.3,1,1,0.03,16119.999999999998,"Yes","Yes","Yes",0]
[null,"Specialty Crops Sweet Potatoes","Specialty","Sweet Potatoes",null,null,"pounds",0,0.18,null,null,null,1,1,0.04,21790,"No","Yes","Yes",0]
[null,"Specialty Crops TANGERINES","Specialty","TANGERINES",null,null,"pounds",0,0.22,null,null,null,1,1,0.04,30622,"No","Yes","Yes",0]
[null,"Specialty Crops TARO","Specialty","TARO",null,null,"pounds",0,0.23,null,null,null,1,1,0.05,9630,"No","Yes","Yes",0]
[null,"Specialty Crops Tomatoes","Specialty","Tomatoes",null,null,"pounds",0.64,0.38,0.8,1,0.3,1,1,7.0000000000000007E-2,87470,"Yes","Yes","Yes",0]
[null,"Specialty Crops WALNUTS","Specialty","WALNUTS",null,null,"pounds",0,0.45,null,null,null,1,1,0.09,3580,"No","Yes","Yes",0]
[null,"Specialty Crops WATERMELON","Specialty","WATERMELON",null,null,"pounds",0,0.02,null,null,null,1,1,0,36390,"No","Yes","No",0]
[null,"Value Loss Aquaculture","Value Loss","Aquaculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[null,"Value Loss Floriculture","Value Loss","Floriculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[null,"Value Loss Nursery","Value Loss","Nursery",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]

{"sheet":"ECPR (2)","index":9,"n_rows":66,"n_cols":18,"rows_kept":66,"cut":false,"hidden":true,"merged":[[1,7,1,9],[1,10,1,11],[1,12,1,13],[41,1,50,1],[54,1,63,1],[8,1,17,1],[1,2,1,3],[1,5,1,6],[65,1,66,9],[21,1,30,1],[32,2,32,3],[33,1,37,1],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3]]}
[]
[null,"Producer Name:",{"$f":"IF('Data Entry'!D5=\"\",\"\",'Data Entry'!D5)","v":""},null,"Recording County:",{"$f":"IF(OR('Data Entry'!D3=\"\",'Data Entry'!F3=\"\"),\"\",'Data Entry'!F3&\", County \"&'Data Entry'!D3)","v":""},null,{"$f":"'Data Entry'!E8","v":"100% of the estimated gross payment before reduction is $0.  Your payment may not exceed $250,000, except if you are a corporation, limited liability company or limited partnership and 2 or 3 members each contribute 400 hours of labor and/or management, then your payment limit is $500,000 or $750,000, respectively.  You will receive an initial payment of 80% of the gross payment, not to exceed 80% of the payment limit. Subsequent payments may be issued at a later date."},null,null,{"$f":"'Data Entry'!I9","v":0},null,{"$f":"'Data Entry'!I5","v":"CFAP Payment Calculator\nVersion 1.2"}]
[null,null,null,null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-06-02"}]
[null,"Category","Commodity Name","Unit of Measure","7)\nJan.  Prod.","8) \nFeb.  Prod.","9)\nMarch  Prod.","2019 Total  Prod. \n","CARES  Payment Rate\n(per pound)","Estimated CARES Gross Payment  before payment limits and other reductions\n(H*I)","Total  Production","Quarter 2 National Adjustment","CCC Payment Rate\n(per pound)","Estimated CCC Gross Payment before payment limits and other reductions\n(K*L*M)",null,null,null,{"$f":"J6+N6+O19+K19+J32+G32+I52+L52+H65","v":0}]
["Milk","Dairy","Milk",{"$f":"ECPR!D7","v":"pounds"},{"$f":"IF('Data Entry'!D12=\"\",\"\",'Data Entry'!D12)","v":""},{"$f":"IF('Data Entry'!E12=\"\",\"\",'Data Entry'!E12)","v":""},{"$f":"IF('Data Entry'!F12=\"\",\"\",'Data Entry'!F12)","v":""},{"$f":"SUM(E5:G5)","v":0},{"$f":"ECPR!I7","v":""},{"$f":"IF(OR(H5=\"\",I5=\"\"),0,ROUND(H5*I5,2))","v":0},{"$f":"H5","v":0},1.014,{"$f":"ECPR!M7","v":""},{"$f":"IF(OR(H5=\"\",M5=\"\"),0,ROUND(K5*M5*L5,2))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J5","v":0},null,null,null,{"$f":"N5","v":0}]
[]
[null,"Category","Commodity Name","Unit of Measure","15) \n2019 Total Prod","16) \n 2019  Prod Not Sold","Smaller of Total of Production or  Production  ((E *50%) or F])","CARES - Quantity Factor (Part 1)","CARES Payment Quantity \n(G*H)","CARES Payment Rate\n(Part 1)","Estimated CARES Gross Payment before payment limits and other reductions    \n (I*J )","CCC - Quantity Factor          (Part 2)","CCC Payment Quantity \n(K*L)","CCC  Payment Rate\n(Part 2)","Estimated CCC Gross Payment before payment limits and other reductions     (M*N)"]
[{"$f":"\"Row Crop \"&C9","v":"Row Crop "},"Non-specialty crops and wool",{"$f":"IF('Data Entry'!C16=\"\",\"\",'Data Entry'!C16)","v":""},{"$f":"ECPR!D11","v":""},{"$f":"IF('Data Entry'!E16=\"\",\"\",'Data Entry'!E16)","v":""},{"$f":"IF('Data Entry'!F16=\"\",\"\",'Data Entry'!F16)","v":""},{"$f":"IF(OR(E9=\"\",F9=\"\"),\"\",IF(E9/2<F9,ROUND(E9/2,2),F9))","v":""},{"$f":"ECPR!H11","v":""},{"$f":"IF(G9=\"\",\"\",ROUND(G9*H9,2))","v":""},{"$f":"ECPR!J11","v":""},{"$f":"IF(OR(I9=\"\",J9=\"\"),0,ROUND(I9*J9,2))","v":0},{"$f":"ECPR!L11","v":""},{"$f":"IF(G9=\"\",\"\",ROUND(G9*L9,2))","v":""},{"$f":"ECPR!N11","v":""},{"$f":"IF(OR(M9=\"\",N9=\"\"),0,ROUND(M9*N9,2))","v":0}]
[{"$f":"\"Row Crop \"&C10","v":"Row Crop "},null,{"$f":"IF('Data Entry'!C17=\"\",\"\",'Data Entry'!C17)","v":""},{"$f":"ECPR!D12","v":""},{"$f":"IF('Data Entry'!E17=\"\",\"\",'Data Entry'!E17)","v":""},{"$f":"IF('Data Entry'!F17=\"\",\"\",'Data Entry'!F17)","v":""},{"$f":"IF(OR(E10=\"\",F10=\"\"),\"\",IF(E10/2<F10,ROUND(E10/2,2),F10))","v":""},{"$f":"ECPR!H12","v":""},{"$f":"IF(G10=\"\",\"\",ROUND(G10*H10,2))","v":""},{"$f":"ECPR!J12","v":""},{"$f":"IF(OR(I10=\"\",J10=\"\"),0,ROUND(I10*J10,2))","v":0},{"$f":"ECPR!L12","v":""},{"$f":"IF(G10=\"\",\"\",ROUND(G10*L10,2))","v":""},{"$f":"ECPR!N12","v":""},{"$f":"IF(OR(M10=\"\",N10=\"\"),0,ROUND(M10*N10,2))","v":0}]
["Row Crop ",null,{"$f":"IF('Data Entry'!C18=\"\",\"\",'Data Entry'!C18)","v":""},{"$f":"ECPR!D13","v":""},{"$f":"IF('Data Entry'!E18=\"\",\"\",'Data Entry'!E18)","v":""},{"$f":"IF('Data Entry'!F18=\"\",\"\",'Data Entry'!F18)","v":""},"",{"$f":"ECPR!H13","v":""},"",{"$f":"ECPR!J13","v":""},0,{"$f":"ECPR!L13","v":""},"",{"$f":"ECPR!N13","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C19=\"\",\"\",'Data Entry'!C19)","v":""},{"$f":"ECPR!D14","v":""},{"$f":"IF('Data Entry'!E19=\"\",\"\",'Data Entry'!E19)","v":""},{"$f":"IF('Data Entry'!F19=\"\",\"\",'Data Entry'!F19)","v":""},"",{"$f":"ECPR!H14","v":""},"",{"$f":"ECPR!J14","v":""},0,{"$f":"ECPR!L14","v":""},"",{"$f":"ECPR!N14","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C20=\"\",\"\",'Data Entry'!C20)","v":""},{"$f":"ECPR!D15","v":""},{"$f":"IF('Data Entry'!E20=\"\",\"\",'Data Entry'!E20)","v":""},{"$f":"IF('Data Entry'!F20=\"\",\"\",'Data Entry'!F20)","v":""},"",{"$f":"ECPR!H15","v":""},"",{"$f":"ECPR!J15","v":""},0,{"$f":"ECPR!L15","v":""},"",{"$f":"ECPR!N15","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C21=\"\",\"\",'Data Entry'!C21)","v":""},{"$f":"ECPR!D16","v":""},{"$f":"IF('Data Entry'!E21=\"\",\"\",'Data Entry'!E21)","v":""},{"$f":"IF('Data Entry'!F21=\"\",\"\",'Data Entry'!F21)","v":""},"",{"$f":"ECPR!H16","v":""},"",{"$f":"ECPR!J16","v":""},0,{"$f":"ECPR!L16","v":""},"",{"$f":"ECPR!N16","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C22=\"\",\"\",'Data Entry'!C22)","v":""},{"$f":"ECPR!D17","v":""},{"$f":"IF('Data Entry'!E22=\"\",\"\",'Data Entry'!E22)","v":""},{"$f":"IF('Data Entry'!F22=\"\",\"\",'Data Entry'!F22)","v":""},"",{"$f":"ECPR!H17","v":""},"",{"$f":"ECPR!J17","v":""},0,{"$f":"ECPR!L17","v":""},"",{"$f":"ECPR!N17","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C23=\"\",\"\",'Data Entry'!C23)","v":""},{"$f":"ECPR!D18","v":""},{"$f":"IF('Data Entry'!E23=\"\",\"\",'Data Entry'!E23)","v":""},{"$f":"IF('Data Entry'!F23=\"\",\"\",'Data Entry'!F23)","v":""},"",{"$f":"ECPR!H18","v":""},"",{"$f":"ECPR!J18","v":""},0,{"$f":"ECPR!L18","v":""},"",{"$f":"ECPR!N18","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C24=\"\",\"\",'Data Entry'!C24)","v":""},{"$f":"ECPR!D19","v":""},{"$f":"IF('Data Entry'!E24=\"\",\"\",'Data Entry'!E24)","v":""},{"$f":"IF('Data Entry'!F24=\"\",\"\",'Data Entry'!F24)","v":""},"",{"$f":"ECPR!H19","v":""},"",{"$f":"ECPR!J19","v":""},0,{"$f":"ECPR!L19","v":""},"",{"$f":"ECPR!N19","v":""},0]
["Row Crop ",null,{"$f":"IF('Data Entry'!C25=\"\",\"\",'Data Entry'!C25)","v":""},{"$f":"ECPR!D20","v":""},{"$f":"IF('Data Entry'!E25=\"\",\"\",'Data Entry'!E25)","v":""},{"$f":"IF('Data Entry'!F25=\"\",\"\",'Data Entry'!F25)","v":""},"",{"$f":"ECPR!H20","v":""},"",{"$f":"ECPR!J20","v":""},0,{"$f":"ECPR!L20","v":""},"",{"$f":"ECPR!N20","v":""},0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K9:K18)","v":0},null,null,null,{"$f":"SUM(O9:O18)","v":0}]
[]
[null,"Category","Livestock","Unit of Measure","21)\nJan 15, 2020 – April 15, 2020 Sales of Owned Invetnory as of Jan 15, 2020 and any Offspirng from Owned Inventory","CARES Payment Rate\n(Part 1)","Estimated CARES Gross Payment  before payment limits and other reductions\n (E*F)","22)\n Inventory\n(Highest Between\n April 16, 2020 -  May 14, 2020","CCC Payment Rate\n(Part 2)","Estimated CCC Gross Payment  before payment limits and other reductions\n(H*I)"]
[{"$f":"\"Livestock \"&C22","v":"Livestock "},"Livestock",{"$f":"IF('Data Entry'!C29=\"\",\"\",'Data Entry'!C29)","v":""},{"$f":"ECPR!D24","v":""},{"$f":"IF('Data Entry'!E29=\"\",\"\",'Data Entry'!E29)","v":""},{"$f":"ECPR!F24","v":""},{"$f":"IF(OR(C22=\"\",E22=\"\"),0,ROUND(E22*F22,2))","v":0},{"$f":"IF('Data Entry'!F29=\"\",\"\",'Data Entry'!F29)","v":""},{"$f":"ECPR!I24","v":""},{"$f":"IF(OR(C22=\"\",H22=\"\"),0,ROUND(H22*I22,2))","v":0}]
[{"$f":"\"Livestock \"&C23","v":"Livestock "},null,{"$f":"IF('Data Entry'!C30=\"\",\"\",'Data Entry'!C30)","v":""},{"$f":"ECPR!D25","v":""},{"$f":"IF('Data Entry'!E30=\"\",\"\",'Data Entry'!E30)","v":""},{"$f":"ECPR!F25","v":""},{"$f":"IF(OR(C23=\"\",E23=\"\"),0,ROUND(E23*F23,2))","v":0},{"$f":"IF('Data Entry'!F30=\"\",\"\",'Data Entry'!F30)","v":""},{"$f":"ECPR!I25","v":""},{"$f":"IF(OR(C23=\"\",H23=\"\"),0,ROUND(H23*I23,2))","v":0}]
["Livestock ",null,{"$f":"IF('Data Entry'!C31=\"\",\"\",'Data Entry'!C31)","v":""},{"$f":"ECPR!D26","v":""},{"$f":"IF('Data Entry'!E31=\"\",\"\",'Data Entry'!E31)","v":""},{"$f":"ECPR!F26","v":""},0,{"$f":"IF('Data Entry'!F31=\"\",\"\",'Data Entry'!F31)","v":""},{"$f":"ECPR!I26","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C32=\"\",\"\",'Data Entry'!C32)","v":""},{"$f":"ECPR!D27","v":""},{"$f":"IF('Data Entry'!E32=\"\",\"\",'Data Entry'!E32)","v":""},{"$f":"ECPR!F27","v":""},0,{"$f":"IF('Data Entry'!F32=\"\",\"\",'Data Entry'!F32)","v":""},{"$f":"ECPR!I27","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C33=\"\",\"\",'Data Entry'!C33)","v":""},{"$f":"ECPR!D28","v":""},{"$f":"IF('Data Entry'!E33=\"\",\"\",'Data Entry'!E33)","v":""},{"$f":"ECPR!F28","v":""},0,{"$f":"IF('Data Entry'!F33=\"\",\"\",'Data Entry'!F33)","v":""},{"$f":"ECPR!I28","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C34=\"\",\"\",'Data Entry'!C34)","v":""},{"$f":"ECPR!D29","v":""},{"$f":"IF('Data Entry'!E34=\"\",\"\",'Data Entry'!E34)","v":""},{"$f":"ECPR!F29","v":""},0,{"$f":"IF('Data Entry'!F34=\"\",\"\",'Data Entry'!F34)","v":""},{"$f":"ECPR!I29","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C35=\"\",\"\",'Data Entry'!C35)","v":""},{"$f":"ECPR!D30","v":""},{"$f":"IF('Data Entry'!E35=\"\",\"\",'Data Entry'!E35)","v":""},{"$f":"ECPR!F30","v":""},0,{"$f":"IF('Data Entry'!F35=\"\",\"\",'Data Entry'!F35)","v":""},{"$f":"ECPR!I30","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C36=\"\",\"\",'Data Entry'!C36)","v":""},{"$f":"ECPR!D31","v":""},{"$f":"IF('Data Entry'!E36=\"\",\"\",'Data Entry'!E36)","v":""},{"$f":"ECPR!F31","v":""},0,{"$f":"IF('Data Entry'!F36=\"\",\"\",'Data Entry'!F36)","v":""},{"$f":"ECPR!I31","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C37=\"\",\"\",'Data Entry'!C37)","v":""},{"$f":"ECPR!D32","v":""},{"$f":"IF('Data Entry'!E37=\"\",\"\",'Data Entry'!E37)","v":""},{"$f":"ECPR!F32","v":""},0,{"$f":"IF('Data Entry'!F37=\"\",\"\",'Data Entry'!F37)","v":""},{"$f":"ECPR!I32","v":""},0]
["Livestock ",null,{"$f":"IF('Data Entry'!C38=\"\",\"\",'Data Entry'!C38)","v":""},{"$f":"ECPR!D33","v":""},{"$f":"IF('Data Entry'!E38=\"\",\"\",'Data Entry'!E38)","v":""},{"$f":"ECPR!F33","v":""},0,{"$f":"IF('Data Entry'!F38=\"\",\"\",'Data Entry'!F38)","v":""},{"$f":"ECPR!I33","v":""},0]
[null,null,null,null,null,null,{"$f":"SUM(G22:G31)","v":0},null,null,{"$f":"SUM(J22:J31)","v":0}]
[null,"Category","Commodity",null,"26) \nValue of  Sales (January 15, 2020 - April 15, 2020)","CARES Value Loss Factor","CARES Gross Payment\n(E Adusted by F, if applicable, * H)","27) \nValue of  Inventory (as of April 15, 2020)","CCC Value Loss Factor","CCC Gross Payment \n(K Adusted by L, if applicable, * N)"]
[{"$f":"\"Value Loss \"&C34","v":"Value Loss "},"Value Loss",{"$f":"IF('Data Entry'!C42=\"\",\"\",'Data Entry'!C42)","v":""},null,{"$f":"IF('Data Entry'!E42=\"\",\"\",'Data Entry'!E42)","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(A34,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E34=\"\",\"\",ROUND(E34*F34,2))","v":""},{"$f":"IF('Data Entry'!F42=\"\",\"\",'Data Entry'!F42)","v":""},{"$f":"IF(C34=\"\",\"\",VLOOKUP(A34,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H34=\"\",\"\",ROUND(H34*I34,2))","v":""}]
[{"$f":"\"Value Loss \"&C35","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C43=\"\",\"\",'Data Entry'!C43)","v":""},null,{"$f":"IF('Data Entry'!E43=\"\",\"\",'Data Entry'!E43)","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(A35,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E35=\"\",\"\",ROUND(E35*F35,2))","v":""},{"$f":"IF('Data Entry'!F43=\"\",\"\",'Data Entry'!F43)","v":""},{"$f":"IF(C35=\"\",\"\",VLOOKUP(A35,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H35=\"\",\"\",ROUND(H35*I35,2))","v":""}]
[{"$f":"\"Value Loss \"&C36","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C44=\"\",\"\",'Data Entry'!C44)","v":""},null,{"$f":"IF('Data Entry'!E44=\"\",\"\",'Data Entry'!E44)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E36=\"\",\"\",ROUND(E36*F36,2))","v":""},{"$f":"IF('Data Entry'!F44=\"\",\"\",'Data Entry'!F44)","v":""},{"$f":"IF(C36=\"\",\"\",VLOOKUP(A36,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H36=\"\",\"\",ROUND(H36*I36,2))","v":""}]
[{"$f":"\"Value Loss \"&C37","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C45=\"\",\"\",'Data Entry'!C45)","v":""},null,{"$f":"IF('Data Entry'!E45=\"\",\"\",'Data Entry'!E45)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E37=\"\",\"\",ROUND(E37*F37,2))","v":""},{"$f":"IF('Data Entry'!F45=\"\",\"\",'Data Entry'!F45)","v":""},{"$f":"IF(C37=\"\",\"\",VLOOKUP(A37,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H37=\"\",\"\",ROUND(H37*I37,2))","v":""}]
[{"$f":"\"Value Loss \"&C38","v":"Value Loss "},null,{"$f":"IF('Data Entry'!C46=\"\",\"\",'Data Entry'!C46)","v":""},null,{"$f":"IF('Data Entry'!E46=\"\",\"\",'Data Entry'!E46)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,10,FALSE))","v":""},{"$f":"IF(E38=\"\",\"\",ROUND(E38*F38,2))","v":""},{"$f":"IF('Data Entry'!F46=\"\",\"\",'Data Entry'!F46)","v":""},{"$f":"IF(C38=\"\",\"\",VLOOKUP(A38,PAS!$A$4:$L$202,12,FALSE))","v":""},{"$f":"IF(H38=\"\",\"\",ROUND(H38*I38,2))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G34:G38)","v":0},null,null,{"$f":"SUM(J34:J38)","v":0}]
[]
[null,"Category","Commodity","Unit of Measure","Item 32)\nVolume of Production Sold \n(Jan 15, 2020 - April 15, 2020)","CARES - Quantity %","CARES Payment Quantity\n(Bin 1)\n(E*F)","CARES  Payment Rate","Estimated CARES Gross Payment before payment limits and other reductions\n(G*H)","33)\nVolume of Production Shipped but Not Sold and Unpaid (Jan 15, 2020 -April\n15, 2020)","CARES  Payment Rate","Estimated CARES Gross Payment before payment limits and other reductions\n(J*K)"]
[{"$f":"$B$42&\" \"&C42","v":"Specialty crops "},"Specialty crops",{"$f":"ECPR!C44","v":""},{"$f":"ECPR!D44","v":""},{"$f":"IF('Data Entry'!E50=\"\",\"\",'Data Entry'!E50)","v":""},{"$f":"ECPR!F44","v":""},{"$f":"IF(E42=\"\",\"\",ROUND(E42*F42,0))","v":""},{"$f":"ECPR!H44","v":""},{"$f":"IF(OR(G42=\"\",C42=\"\"),0,ROUND(G42*H42,2))","v":0},{"$f":"IF('Data Entry'!F50=\"\",\"\",'Data Entry'!F50)","v":""},{"$f":"ECPR!K44","v":""},{"$f":"IF(OR(J42=\"\",K42=\"\"),0,ROUND(J42*K42,2))","v":0}]
["Specialty crops ",null,{"$f":"ECPR!C45","v":""},{"$f":"ECPR!D45","v":""},{"$f":"IF('Data Entry'!E51=\"\",\"\",'Data Entry'!E51)","v":""},{"$f":"ECPR!F45","v":""},{"$f":"IF(E43=\"\",\"\",ROUND(E43*F43,0))","v":""},{"$f":"ECPR!H45","v":""},{"$f":"IF(OR(G43=\"\",C43=\"\"),0,ROUND(G43*H43,2))","v":0},{"$f":"IF('Data Entry'!F51=\"\",\"\",'Data Entry'!F51)","v":""},{"$f":"ECPR!K45","v":""},{"$f":"IF(OR(J43=\"\",K43=\"\"),0,ROUND(J43*K43,2))","v":0}]
["Specialty crops ",null,{"$f":"ECPR!C46","v":""},{"$f":"ECPR!D46","v":""},{"$f":"IF('Data Entry'!E52=\"\",\"\",'Data Entry'!E52)","v":""},{"$f":"ECPR!F46","v":""},"",{"$f":"ECPR!H46","v":""},0,{"$f":"IF('Data Entry'!F52=\"\",\"\",'Data Entry'!F52)","v":""},{"$f":"ECPR!K46","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C47","v":""},{"$f":"ECPR!D47","v":""},{"$f":"IF('Data Entry'!E53=\"\",\"\",'Data Entry'!E53)","v":""},{"$f":"ECPR!F47","v":""},"",{"$f":"ECPR!H47","v":""},0,{"$f":"IF('Data Entry'!F53=\"\",\"\",'Data Entry'!F53)","v":""},{"$f":"ECPR!K47","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C48","v":""},{"$f":"ECPR!D48","v":""},{"$f":"IF('Data Entry'!E54=\"\",\"\",'Data Entry'!E54)","v":""},{"$f":"ECPR!F48","v":""},"",{"$f":"ECPR!H48","v":""},0,{"$f":"IF('Data Entry'!F54=\"\",\"\",'Data Entry'!F54)","v":""},{"$f":"ECPR!K48","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C49","v":""},{"$f":"ECPR!D49","v":""},{"$f":"IF('Data Entry'!E55=\"\",\"\",'Data Entry'!E55)","v":""},{"$f":"ECPR!F49","v":""},"",{"$f":"ECPR!H49","v":""},0,{"$f":"IF('Data Entry'!F55=\"\",\"\",'Data Entry'!F55)","v":""},{"$f":"ECPR!K49","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C50","v":""},{"$f":"ECPR!D50","v":""},{"$f":"IF('Data Entry'!E56=\"\",\"\",'Data Entry'!E56)","v":""},{"$f":"ECPR!F50","v":""},"",{"$f":"ECPR!H50","v":""},0,{"$f":"IF('Data Entry'!F56=\"\",\"\",'Data Entry'!F56)","v":""},{"$f":"ECPR!K50","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C51","v":""},{"$f":"ECPR!D51","v":""},{"$f":"IF('Data Entry'!E57=\"\",\"\",'Data Entry'!E57)","v":""},{"$f":"ECPR!F51","v":""},"",{"$f":"ECPR!H51","v":""},0,{"$f":"IF('Data Entry'!F57=\"\",\"\",'Data Entry'!F57)","v":""},{"$f":"ECPR!K51","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C52","v":""},{"$f":"ECPR!D52","v":""},{"$f":"IF('Data Entry'!E58=\"\",\"\",'Data Entry'!E58)","v":""},{"$f":"ECPR!F52","v":""},"",{"$f":"ECPR!H52","v":""},0,{"$f":"IF('Data Entry'!F58=\"\",\"\",'Data Entry'!F58)","v":""},{"$f":"ECPR!K52","v":""},0]
["Specialty crops ",null,{"$f":"ECPR!C53","v":""},{"$f":"ECPR!D53","v":""},{"$f":"IF('Data Entry'!E59=\"\",\"\",'Data Entry'!E59)","v":""},{"$f":"ECPR!F53","v":""},"",{"$f":"ECPR!H53","v":""},0,{"$f":"IF('Data Entry'!F59=\"\",\"\",'Data Entry'!F59)","v":""},{"$f":"ECPR!K53","v":""},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I42:I51)","v":0},null,null,{"$f":"SUM(L42:L51)","v":0}]
[]
[null,"Category","Commodity","Unit of Measure","34)\nAcres with Production Not Shipped or Sold \n(Jan 15, 2020 -April 15)","CCCC Payment Quantity (Production per acre from AMS multiplied by item X (application))","CCCC  Payment Rate","Estimated CCC Gross Payment before payment limits and other reductions\n(F*G)"]
["Specialty crops ","Specialty crops",{"$f":"IF(C42=\"\",\"\",C42)","v":""},"",{"$f":"IF('Data Entry'!G50=\"\",\"\",'Data Entry'!G50)","v":""},{"$f":"ECPR!F57","v":""},{"$f":"ECPR!G57","v":""},{"$f":"IF(OR(F55=\"\",G55=\"\"),0,ROUND(F55*G55,2))","v":0}]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G51=\"\",\"\",'Data Entry'!G51)","v":""},{"$f":"ECPR!F58","v":""},{"$f":"ECPR!G58","v":""},{"$f":"IF(OR(F56=\"\",G56=\"\"),0,ROUND(F56*G56,2))","v":0}]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G52=\"\",\"\",'Data Entry'!G52)","v":""},{"$f":"ECPR!F59","v":""},{"$f":"ECPR!G59","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G53=\"\",\"\",'Data Entry'!G53)","v":""},{"$f":"ECPR!F60","v":""},{"$f":"ECPR!G60","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G54=\"\",\"\",'Data Entry'!G54)","v":""},{"$f":"ECPR!F61","v":""},{"$f":"ECPR!G61","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G55=\"\",\"\",'Data Entry'!G55)","v":""},{"$f":"ECPR!F62","v":""},{"$f":"ECPR!G62","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G56=\"\",\"\",'Data Entry'!G56)","v":""},{"$f":"ECPR!F63","v":""},{"$f":"ECPR!G63","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G57=\"\",\"\",'Data Entry'!G57)","v":""},{"$f":"ECPR!F64","v":""},{"$f":"ECPR!G64","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G58=\"\",\"\",'Data Entry'!G58)","v":""},{"$f":"ECPR!F65","v":""},{"$f":"ECPR!G65","v":""},0]
["Specialty crops ",null,"","",{"$f":"IF('Data Entry'!G59=\"\",\"\",'Data Entry'!G59)","v":""},{"$f":"ECPR!F66","v":""},{"$f":"ECPR!G66","v":""},0]
[null,null,null,null,null,null,null,{"$f":"SUM(H55:H64)","v":0}]
[null,"Disclaimer:    \n\nThe Gross Payment Amount is determined prior to applying any producer or payment reductions.  The payment data reflected on this Estimated Calculated Payment Report includes payment amounts based on program eligibility and may vary due to changes in commodity data, producer eligibility, producer or member payment share, payment rates, factors, and payment limitation.  \n\nThe distribution of this report does not in any way obligate CCC to disburse the estimated payment amounts reflected."]

{"sheet":"PAS","index":10,"n_rows":277,"n_cols":19,"rows_kept":277,"cut":false,"hidden":true,"merged":[]}
[null,"Program Administration System"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"Category","Name","Type","Intended Use","Unit of Measure","Part 1 - Rate","Part 2 - Rate","Part 1 - Payment %","Part 1 - Quantity %","Part 2 - Payment %","Part 2 - Quantity %","Part 3 Quanitity","Price 3","Yield","pmt 1","pmt 2","pmt 3"]
["Livestock All Other Cattle","Livestock","All Other Cattle",null,null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Livestock Feeder Cattle:  600 Pounds or More","Livestock","Feeder Cattle:  600 Pounds or More",">600 Pounds",null,"Head",139,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Livestock Feeder Cattle:  Less Than 600 Pounds","Livestock","Feeder Cattle:  Less Than 600 Pounds","<600 Pounds",null,"Head",102,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Livestock Hogs: 120 Pounds or More","Livestock","Hogs: 120 Pounds or More","Hogs",null,"Head",18,17,0.8,1,0.3,1,null,0,null,"Yes","Yes","No"]
["Livestock Lambs and Yearlings: Less than 2 yrs of age","Livestock","Lambs and Yearlings: Less than 2 yrs of age",null,null,"Head",33,7,null,null,null,null,null,0,null,"Yes","Yes","No"]
["Livestock Pigs:  Less than 120 Pounds","Livestock","Pigs:  Less than 120 Pounds","Pigs",null,"Head",28,17,0.8,1,0.3,0.5,null,0,null,"Yes","Yes","No"]
["Livestock Slaughter Cattle: Fed Cattle","Livestock","Slaughter Cattle: Fed Cattle","Fed Cattle",null,"Head",214,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Livestock Slaughter Cattle: Mature Cattle","Livestock","Slaughter Cattle: Mature Cattle","Mature Cattle",null,"Head",92,33,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Milk","Dairy","Dairy",null,null,"pounds",4.7100000000000003E-2,1.47E-2,0.8,1,0.25,1,null,0,null,"Yes","Yes","No"]
["Row Crop Barley, Malting","Row Crop","Barley, Malting","Malting",null,"bushels",0.34,0.37,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Canola","Row Crop","Canola",null,null,"pounds",0.01,0.01,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Corn","Row Crop","Corn",null,"Grain","bushels",0.32,0.35,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Cotton, Upland","Row Crop","Cotton, Upland","Upland",null,"pounds",0.09,0.1,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Millet","Row Crop","Millet",null,null,"bushels",0.31,0.34,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Oats","Row Crop","Oats",null,null,"bushels",0.15,0.17,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Sorghum","Row Crop","Sorghum",null,null,"bushels",0.3,0.32,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Soybeans","Row Crop","Soybeans",null,"Grain","bushels",0.45,0.5,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Sunflowers","Row Crop","Sunflowers",null,null,"pounds",0.02,0.02,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Wheat, Durum","Row Crop","Wheat, Durum","Durum","Grain","bushels",0.19,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Wheat, HRS","Row Crop","Wheat, HRS","Hard Red Spring","Grain","bushels",0.18,0.2,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Wool Graded","Row Crop","Wool Graded",null,null,"pound",0.71,0.78,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Row Crop Wool Ungraded","Row Crop","Wool Ungraded",null,null,"pound",0.36,0.39,0.5,0.5,0.55000000000000004,0.5,null,0,null,"Yes","Yes","No"]
["Specialty Crops Almonds","Specialty","Almonds",null,null,"pounds",0.26,0.56999999999999995,0.8,1,0.3,1,1,0.11,2160,"Yes","Yes","Yes",{"$f":"IF(AND(P26=\"No\",Q26=\"No\",R26=\"No\"),1,0)","v":0}]
["Specialty Crops Apples","Specialty","Apples",null,null,"pounds",0,0.18,0.8,1,null,1,1,0.03,37500,"No","Yes","Yes",0]
["Specialty Crops Artichokes","Specialty","Artichokes",null,null,"pounds",0.66,0.49,0.8,1,null,1,1,0.1,13000,"Yes","Yes","Yes",0]
["Specialty Crops ASPARAGUS","Specialty","ASPARAGUS",null,null,"pounds",0,0.38,null,null,null,1,1,7.0000000000000007E-2,3640,"No","Yes","Yes",0]
["Specialty Crops AVOCADOS","Specialty","AVOCADOS",null,null,"pounds",0,0.14000000000000001,null,null,null,1,1,0.03,5120,"No","Yes","Yes",0]
["Specialty Crops Beans","Specialty","Beans",null,null,"pounds",0.17,0.16,0.8,1,0.3,1,1,0.03,7793.0233600000001,"Yes","Yes","Yes",0]
["Specialty Crops BLUEBERRIES","Specialty","BLUEBERRIES",null,null,"pounds",0,0.62,null,null,null,null,1,0.12,6630,"No","Yes","Yes",0]
["Specialty Crops Broccoli","Specialty","Broccoli",null,null,"pounds",0.62,0.49,0.8,1,0.3,1,1,0.1,15630.000000000002,"Yes","Yes","Yes",0]
["Specialty Crops Cabbage","Specialty","Cabbage",null,null,"pounds",0.04,7.0000000000000007E-2,0.8,1,null,1,1,0.01,36730,"Yes","Yes","Yes",0]
["Specialty Crops CANTALOUPES","Specialty","CANTALOUPES",null,null,"pounds",0,0.1,null,null,null,1,1,0.02,23940,"No","Yes","Yes",0]
["Specialty Crops Carrots","Specialty","Carrots",null,null,"pounds",0.02,0.11,0.8,1,null,1,1,0.02,62570.000000000007,"Yes","Yes","Yes",0]
["Specialty Crops Cauliflower","Specialty","Cauliflower",null,null,"pounds",0.11,0.31,0.8,1,null,1,1,0.06,22120,"Yes","Yes","Yes",0]
["Specialty Crops CELERY","Specialty","CELERY",null,null,"pounds",0,7.0000000000000007E-2,null,null,null,1,1,0.01,56000,"No","Yes","Yes",0]
["Specialty Crops Cucumbers","Specialty","Cucumbers",null,null,"pounds",0.13,0.15,0.8,1,null,1,1,0.03,14830.000000000002,"Yes","Yes","Yes",0]
["Specialty Crops Eggplant","Specialty","Eggplant",null,null,"pounds",7.0000000000000007E-2,0.15,0.8,1,null,1,1,0.03,13757.083490744239,"Yes","Yes","Yes",0]
["Specialty Crops GARLIC","Specialty","GARLIC",null,null,"pounds",0,0.85,null,null,null,1,1,0.17,15500,"No","Yes","Yes",0]
["Specialty Crops GRAPEFRUIT","Specialty","GRAPEFRUIT",null,null,"pounds",0,0.11,null,null,null,1,1,0.02,24838,"No","Yes","Yes",0]
["Specialty Crops KIWIFRUIT","Specialty","KIWIFRUIT",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,23400,"No","Yes","Yes",0]
["Specialty Crops Lemons","Specialty","Lemons",null,null,"pounds",0.08,0.21,0.8,1,0.3,1,1,0.04,35600,"Yes","Yes","Yes",0]
["Specialty Crops Lettuce, Iceberg","Specialty","Lettuce, Iceberg","Iceberg",null,"pounds",0.2,0.15,0.8,1,0.3,1,1,0.03,37600,"Yes","Yes","Yes",0]
["Specialty Crops Lettuce, Romaine","Specialty","Lettuce, Romaine","Romaine",null,"pounds",7.0000000000000007E-2,0.12,0.8,1,null,1,1,0.02,31180,"Yes","Yes","Yes",0]
["Specialty Crops MUSHROOMS","Specialty","MUSHROOMS",null,null,"pounds",0,0.59,null,null,null,1,1,0.11,300999.60000000003,"No","Yes","Yes",0]
["Specialty Crops ONIONS, Green","Specialty","ONIONS, Green",null,null,"pounds",0,0.3,null,null,null,1,1,0.06,29700,"No","Yes","Yes",0]
["Specialty Crops Onions, Other","Specialty","Onions, Other",null,null,"pounds",0.01,0.05,0.8,1,null,1,1,0.01,54010,"Yes","Yes","Yes",0]
["Specialty Crops Oranges","Specialty","Oranges",null,null,"pounds",0,0.14000000000000001,0.8,1,null,1,1,0.03,21161,"No","Yes","Yes",0]
["Specialty Crops PAPAYA","Specialty","PAPAYA",null,null,"pounds",0,0.32,null,null,null,1,1,0.06,17000,"No","Yes","Yes",0]
["Specialty Crops Peaches","Specialty","Peaches",null,null,"pounds",0.08,0.32,0.8,1,null,1,1,0.06,18320,"Yes","Yes","Yes",0]
["Specialty Crops Pears","Specialty","Pears",null,null,"pounds",0.08,0.18,0.8,1,null,1,1,0.03,32200,"Yes","Yes","Yes",0]
["Specialty Crops Pecans","Specialty","Pecans",null,null,"pounds",0.28000000000000003,0.93,0.8,1,null,1,1,0.18,647,"Yes","Yes","Yes",0]
["Specialty Crops Peppers, Bell","Specialty","Peppers, Bell",null,null,"pounds",0.14000000000000001,0.22,0.8,1,null,1,1,0.04,31680,"Yes","Yes","Yes",0]
["Specialty Crops Peppers, Other","Specialty","Peppers, Other",null,null,"pounds",0.15,0.22,0.8,1,null,1,1,0.04,16120,"Yes","Yes","Yes",0]
["Specialty Crops POTATOES","Specialty","POTATOES",null,null,"pounds",0,0.04,null,null,null,1,1,0.01,44900,"No","Yes","Yes",0]
["Specialty Crops Raspberries","Specialty","Raspberries",null,null,"pounds",0,1.45,null,null,null,1,1,0.28000000000000003,13500,"No","Yes","Yes",0]
["Specialty Crops Rhubarb","Specialty","Rhubarb",null,null,"pounds",0.15,1.03,0.8,1,0.3,1,1,0.2,1979.1666666666667,"Yes","Yes","Yes",0]
["Specialty Crops Spinach","Specialty","Spinach",null,null,"pounds",0.37,0.37,0.8,1,0.3,1,1,7.0000000000000007E-2,14600,"Yes","Yes","Yes",0]
["Specialty Crops Squash","Specialty","Squash",null,null,"pounds",0.72,0.39,0.8,1,0.3,1,1,0.08,31680,"Yes","Yes","Yes",0]
["Specialty Crops Strawberries","Specialty","Strawberries",null,null,"pounds",0.84,0.72,0.8,1,0.3,1,1,0.14000000000000001,50300,"Yes","Yes","Yes",0]
["Specialty Crops Sweet Corn","Specialty","Sweet Corn","Sweet",null,"pounds",0.09,0.13,0.8,1,0.3,1,1,0.03,16119.999999999998,"Yes","Yes","Yes",0]
["Specialty Crops Sweet Potatoes","Specialty","Sweet Potatoes",null,null,"pounds",0,0.18,null,null,null,1,1,0.04,21790,"No","Yes","Yes",0]
["Specialty Crops TANGERINES","Specialty","TANGERINES",null,null,"pounds",0,0.22,null,null,null,1,1,0.04,30622,"No","Yes","Yes",0]
["Specialty Crops TARO","Specialty","TARO",null,null,"pounds",0,0.23,null,null,null,1,1,0.05,9630,"No","Yes","Yes",0]
["Specialty Crops Tomatoes","Specialty","Tomatoes",null,null,"pounds",0.64,0.38,0.8,1,0.3,1,1,7.0000000000000007E-2,87470,"Yes","Yes","Yes",0]
["Specialty Crops WALNUTS","Specialty","WALNUTS",null,null,"pounds",0,0.45,null,null,null,1,1,0.09,3580,"No","Yes","Yes",0]
["Specialty Crops WATERMELON","Specialty","WATERMELON",null,null,"pounds",0,0.02,null,null,null,1,1,0,36390,"No","Yes","No",0]
["Value Loss Aquaculture","Value Loss","Aquaculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
["Value Loss Floriculture","Value Loss","Floriculture",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
["Value Loss Nursery","Value Loss","Nursery",null,null,null,0,0,null,null,null,null,null,0,0,"No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(G177=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(H177=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(N177=0,\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(G196=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(H196=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(N196=0,\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(G260=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(H260=0,\"No\",\"Yes\")","v":"No"},{"$f":"IF(N260=0,\"No\",\"Yes\")","v":"No"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","No","No","No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"data","index":11,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,"Livestock","Nonspecialty","specialty","Value Loss"]
[]
[null,null,null,null,null,"Dairy","All Other Cattle","Barley, Malting","Almonds","Aquaculture"]
[null,null,null,null,null,null,"Feeder Cattle:  Less Than 600 Pounds","Canola","Apples","Floriculture"]
[null,null,null,null,null,null,"Feeder Cattle:  600 Pounds or More","Corn","Artichokes","Nursery"]
[null,null,null,null,null,null,"Slaughter Cattle: Fed Cattle","Cotton, Upland","ASPARAGUS"]
[null,null,null,null,null,null,"Slaughter Cattle: Mature Cattle","Millet","AVOCADOS"]
[null,null,null,null,null,null,"Hogs: 120 Pounds or More","Oats","Beans"]
[null,null,null,null,null,null,"Pigs:  Less than 120 Pounds","Sorghum","BLUEBERRIES"]
[null,null,null,null,null,null,"Lambs and Yearlings: Less than 2 yrs of age","Soybeans","Broccoli"]
[null,null,null,null,null,null,null,"Sunflowers","Cabbage"]
[null,null,null,null,null,null,null,"Wheat, Durum","CANTALOUPES"]
[null,null,null,null,null,null,null,"Wheat, HRS","Carrots"]
[null,null,null,null,null,null,null,"Wool Graded","Cauliflower"]
[null,null,null,null,null,null,null,"Wool Ungraded","CELERY"]
[null,null,null,null,null,null,null,null,"Cucumbers"]
[null,null,null,null,null,null,null,null,"Eggplant"]
[null,null,null,null,null,null,null,null,"GARLIC"]
[null,null,null,null,null,null,null,null,"GRAPEFRUIT"]
[null,null,null,null,null,null,null,null,"KIWIFRUIT"]
[null,null,null,null,null,null,null,null,"Lemons"]
[null,null,null,null,null,null,null,null,"Lettuce, Iceberg"]
[null,null,null,null,null,null,null,null,"Lettuce, Romaine"]
[null,null,null,null,null,null,null,null,"MUSHROOMS"]
[null,null,null,null,null,null,null,null,"ONIONS, Green"]
[null,null,null,null,null,null,null,null,"Onions, Other"]
[null,null,null,null,null,null,null,null,"Oranges"]
[null,null,null,null,null,null,null,null,"PAPAYA"]
[null,null,null,null,null,null,null,null,"Peaches"]
[null,null,null,null,null,null,null,null,"Pears"]
[null,null,null,null,null,null,null,null,"Pecans"]
[null,null,null,null,null,null,null,null,"Peppers, Bell"]
[null,null,null,null,null,null,null,null,"Peppers, Other"]
[null,null,null,null,null,null,null,null,"POTATOES"]
[null,null,null,null,null,null,null,null,"Raspberries"]
[null,null,null,null,null,null,null,null,"Rhubarb"]
[null,null,null,null,null,null,null,null,"Spinach"]
[null,null,null,null,null,null,null,null,"Squash"]
[null,null,null,null,null,null,null,null,"Strawberries"]
[null,null,null,null,null,null,null,null,"Sweet Corn"]
[null,null,null,null,null,null,null,null,"Sweet Potatoes"]
[null,null,null,null,null,null,null,null,"TANGERINES"]
[null,null,null,null,null,null,null,null,"TARO"]
[null,null,null,null,null,null,null,null,"Tomatoes"]
[null,null,null,null,null,null,null,null,"WALNUTS"]
[null,null,null,null,null,null,null,null,"WATERMELON"]