{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Option 1","Option 2","Option 3","Option 4","ELAP Feed Transportation","Instructions","Above Normal Calculator"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Option 1","index":0,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,4,4,10],[3,1,3,10],[2,2,2,10],[9,1,9,6],[4,2,4,3]]}
[]
[null,"Feed Transportation Tool vs. 1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socially Disadvantaged"]
[null,"Do you meet any of the following definitions for Socially Disadvantaged, Limited Resource, Beginning Farmer or Rancher, Veteran Farmer or Rancher?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limited Resource"]
[null,"Use Dropdown for choices\n--->","Limited Resource",null,{"$f":"IF(C5=U3,U8,IF(C5=U4,U9,IF(C5=U5,U10,IF(C5=U6,U11,\"None Apply\"))))","v":"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beginning Farmer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteran Farmer"]
[null,null,null,"Total Producer's Mileage","National Mileage Rate","Program Factor","Total Estimated Payment"]
[null,null,null,{"$f":"SUM(H12:H27)","v":9250},{"$f":"IF(D8=0,0,6.6)","v":6.6},{"$f":"IF(C5=\"None\",0.6,0.9)","v":0.9},{"$f":"ROUND(D8*E8*F8,2)","v":54945},null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[null,"FEED TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and substantially participate in the operation."]
[null,"Additional Load from Normal","Number of Truckloads","Mileage Over Normal \n","Share","Producer's Share of Mileage Inccurred","Local Deduction","Total Producer's Mileage","National Mileage Rate","Program Factor","Total Estimated Payment","Comments",null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and am a veteran (as defined in 38 U.S.C. 101(2)) who first\nobtained status as a veteran during the most recent 10-year period."]
[null,"No",10,100,1,{"$f":"IF(OR(E12=\"\",D12=\"\",C12=\"\"),\"\",ROUND(C12*E12*D12,0))","v":1000},{"$f":"IF(F12=\"\",\"\",IF(B12=\"Yes\",C12*25,\"Not Applicable\"))","v":"Not Applicable"},{"$f":"IF(F12=\"\",\"\",IF(D12>1000,1000*C12,IF(B12=\"Yes\",F12-(25*C12),F12)))","v":1000},{"$f":"IF(F12=\"\",\"\",IF(OR(D12<25),0,6.6))","v":6.6},{"$f":"IF(H12=\"\",\"\",IF(OR($C$5=\"None\"),0.6,0.9))","v":0.9},{"$f":"IF(H12=\"\",\"\",ROUND(H12*I12*J12,0))","v":5940},{"$f":"IF(D12>1000,\"*  Limited to 1000 total miles\",\"\")","v":""}]
[null,"Yes",30,300,1,9000,750,8250,6.6,{"$f":"IF(H13=\"\",\"\",IF(OR($C$5=\"None\"),0.6,0.9))","v":0.9},{"$f":"IF(H13=\"\",\"\",ROUND(H13*I13*J13,0))","v":49005},{"$f":"IF(D13>1000,\"*  Limited to 1000 total miles\",\"\")","v":""}]
[null,null,null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,"Yes"]
[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,null,null,null,null,"","","","","","",""]

{"sheet":"Option 2","index":1,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":true,"merged":[[2,2,2,10],[4,2,4,3],[9,1,9,6],[4,4,4,11]]}
[]
[null,"Feed Transportation Tool vs. 1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socially Disadvantaged"]
[null,"Do you meet any of the following definitions for Socially Disadvantaged, Limited Resource, Beginning Farmer or Rancher, Veteran Farmer or Rancher?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limited Resource"]
[null,"Use Dropdown for choices\n--->","Limited Resource",null,{"$f":"IF(C5=U3,U8,IF(C5=U4,U9,IF(C5=U5,U10,IF(C5=U6,U11,\"None Apply\"))))","v":"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beginning Farmer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteran Farmer"]
[null,null,null,"Total Producer's Mileage","National Mileage Rate","Program Factor","Total Estimated Payment"]
[null,null,null,{"$f":"SUM(H12:H27)","v":18250},{"$f":"IF(D8=0,0,6.6)","v":6.6},{"$f":"IF(C5=\"None\",0.6,0.9)","v":0.9},{"$f":"ROUND(D8*E8*F8,2)","v":108405},null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[null,"FEED TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and substantially participate in the operation."]
[null,"Additional Load from Normal","Number of Truckloads","Mileage Over Normal \n","Share","Producer's Share of Mileage Inccurred","Local Deduction","Total Producer's Mileage","National Mileage Rate","Program Factor","Total Estimated Payment","Comments",null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and am a veteran (as defined in 38 U.S.C. 101(2)) who first\nobtained status as a veteran during the most recent 10-year period."]
[null,"No",10,1200,1,{"$f":"IF(OR(E12=\"\",D12=\"\",C12=\"\"),\"\",ROUND(C12*E12*D12,0))","v":12000},{"$f":"IF(F12=\"\",\"\",IF(B12=\"Yes\",C12*25,\"Not Applicable\"))","v":"Not Applicable"},{"$f":"IF(F12=\"\",\"\",IF(D12>1000,1000*C12,IF(B12=\"Yes\",F12-(25*C12),F12)))","v":10000},{"$f":"IF(F12=\"\",\"\",IF(OR(D12<25),0,6.6))","v":6.6},{"$f":"IF(H12=\"\",\"\",IF(OR($C$5=\"None\"),0.6,0.9))","v":0.9},{"$f":"IF(H12=\"\",\"\",ROUND(H12*I12*J12,0))","v":59400},{"$f":"IF(D12>1000,\"*  Limited to 1000 total miles\",\"\")","v":"*  Limited to 1000 total miles"}]
[null,"Yes",30,300,1,9000,750,8250,6.6,{"$f":"IF(H13=\"\",\"\",IF(OR($C$5=\"None\"),0.6,0.9))","v":0.9},{"$f":"IF(H13=\"\",\"\",ROUND(H13*I13*J13,0))","v":49005},{"$f":"IF(D13>1000,\"*  Limited to 1000 total miles\",\"\")","v":""}]
[null,null,null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,"Yes"]
[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,null,null,null,null,"","","","","","",""]

{"sheet":"Option 3","index":2,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":true,"merged":[[2,2,2,6],[6,1,6,5],[19,5,19,6],[4,2,4,3],[13,5,13,6],[4,4,4,6],[3,1,3,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[12,1,12,6],[24,5,24,6],[25,5,25,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6]]}
[]
[null,"Feed Transportation Tool vs. 1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socially Disadvantaged"]
[null,"Do you meet any of the following definitions for Socially Disadvantaged, Limited Resource, Beginning Farmer or Rancher, Veteran Farmer or Rancher?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limited Resource"]
[null,"Use Dropdown for choices\n--->","None",null,{"$f":"IF(C5=U3,U8,IF(C5=U4,U9,IF(C5=U5,U10,IF(C5=U6,U11,\"None Apply\"))))","v":"None Apply"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beginning Farmer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteran Farmer"]
[null,"How many loads were hauled this year that you normally don't haul under 1,000 miles?",null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[null,"Total Producer's Mileage","Local Mileage Deduction","Net Producer's Mileage","National Mileage Rate","Program Factor","Total Estimated Payment",null,null,null,null,null,null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and substantially participate in the operation."]
[null,{"$f":"SUM(E15:E30)","v":10000},{"$f":"G7*25","v":750},{"$f":"B11-C11","v":9250},{"$f":"IF(B11=0,0,6.6)","v":6.6},{"$f":"IF(C5=\"None\",0.6,0.9)","v":0.6},{"$f":"ROUND(D11*E11*F11,2)","v":36630},null,null,null,null,null,null,null,null,null,null,null,null,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and am a veteran (as defined in 38 U.S.C. 101(2)) who first\nobtained status as a veteran during the most recent 10-year period."]
[]
[null,"FEED TRANSPORTATION"]
[null,"Number of Truckloads","Mileage Over Normal \n","Share","Total Producer's Mileage Inccurred","Comments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,10,100,1,{"$f":"IF(OR(D15=\"\",C15=\"\",B15=\"\"),\"\",ROUND(B15*D15*C15,0))","v":1000},{"$f":"IF(C15>1000,\"*  Limited to 1000 total miles\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,30,300,1,9000,{"$f":"IF(C16>1000,\"*  Limited to 1000 total miles\",\"\")","v":""}]
[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":"Option 4","index":3,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":true,"merged":[[2,2,2,10],[5,1,5,13],[6,1,6,3],[6,5,6,7],[3,12,4,13]]}
[]
[null,"Feed Transportation Tool vs. 1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socially Disadvantaged"]
[null,null,"Total Producer's Mileage","National Mileage Rate",null,"Socially Disadvantage, Limited Resource, Beginning or Veteran Farmer or Rancher","Program Factor","Total Estimated Payment",null,null,null,null,{"$f":"IF(F5=Q3,Q8,IF(F5=Q4,Q9,IF(F5=Q5,Q10,IF(F5=Q6,Q11,\"\"))))","v":""},null,null,null,"Limited Resource"]
[null,null,{"$f":"SUM(M9:M24)-SUM(O9:O25)","v":3125},{"$f":"IF(C5=0,0,6.6)","v":6.6},null,"None",{"$f":"IF(F5=\"None\",0.6,0.9)","v":0.6},{"$f":"ROUND(C5*D5*G5,2)","v":12375},null,null,null,null,null,null,null,null,"Beginning Farmer"]
[null,"FEED TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteran Farmer"]
[null,"Step 1: How much feed did you transport this year?",null,null,null,"Step 2:  How much do you normally haul?"]
[null,"Number of Truckloads This Year","Mileage per Truckload This Year","Share of Feed Cost","Producer's Current Miles","Normal Number of Truckloads","Normal Mileage per Truckload ","Share","Producers Normal Miles","Producer's Mileage Over Normal \n","Additional Load from Normal","Local Deduction","Total Producer's Mileage","Comments",null,null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[null,4,1200,1,{"$f":"IF(C9>1000,1000*D9*B9,ROUND(B9*C9*D9,2))","v":4000},12,100,1,{"$f":"IF(OR(F9=\"\",G9=\"\",H9=\"\"),0,ROUND(F9*G9*H9,2))","v":1200},{"$f":"IF(OR(B9=\"\",C9=\"\",D9=\"\"),\"\",IF(ROUND(C9*D9,0)<25,0,IF(K9=\"No\",E9-I9,IF(AND(K9=\"Yes\",G9=\"\"),E9,IF(E9-I9<25,0,E9-I9)))))","v":2800},{"$f":"IF(OR(B9=\"\",C9=\"\",D9=\"\"),\"\",IF(OR(G9=\"\",G9=0,G9=\" \",B9>F9),\"Yes\",\"No\"))","v":"No"},{"$f":"IF(J9=\"\",\"\",IF(AND(K9=\"yes\",C9>1000),0,IF(K9=\"Yes\",IF(B9-F9<0,0,(B9-F9)*25),0)))","v":0},{"$f":"IF(J9=\"\",\"\",IF(K9=\"Yes\",J9-L9,J9))","v":2800},{"$f":"IF(M9=\"\",\"\",IF(C9>1000,\"*  Limited to 1000 total miles\",\"\"))","v":"*  Limited to 1000 total miles"},{"$f":"IF(AND(I9>0,E9=0),I9,0)","v":0},null,"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[null,4,400,1,{"$f":"IF(C10>1000,1000*D10*B10,ROUND(B10*C10*D10,2))","v":1600},1,1200,1,{"$f":"IF(OR(F10=\"\",G10=\"\",H10=\"\"),0,ROUND(F10*G10*H10,2))","v":1200},{"$f":"IF(OR(B10=\"\",C10=\"\",D10=\"\"),\"\",IF(ROUND(C10*D10,0)<25,0,IF(K10=\"No\",E10-I10,IF(AND(K10=\"Yes\",G10=\"\"),E10,IF(E10-I10<25,0,E10-I10)))))","v":400},{"$f":"IF(OR(B10=\"\",C10=\"\",D10=\"\"),\"\",IF(OR(G10=\"\",G10=0,G10=\" \",B10>F10),\"Yes\",\"No\"))","v":"Yes"},{"$f":"IF(J10=\"\",\"\",IF(AND(K10=\"yes\",C10>1000),0,IF(K10=\"Yes\",IF(B10-F10<0,0,(B10-F10)*25),0)))","v":75},{"$f":"IF(J10=\"\",\"\",IF(K10=\"Yes\",J10-L10,J10))","v":325},{"$f":"IF(M10=\"\",\"\",IF(C10>1000,\"*  Limited to 1000 total miles\",\"\"))","v":""},{"$f":"IF(AND(I10>0,E10=0),I10,0)","v":0},null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and substantially participate in the operation."]
[null,null,null,null,0,null,null,null,0,"","","","","",0,null,"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and am a veteran (as defined in 38 U.S.C. 101(2)) who first\nobtained status as a veteran during the most recent 10-year period."]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0,null,"No"]
[null,null,null,null,0,null,null,null,0,"","","","","",0,null,"Yes"]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0,null,"Additional Miles"]
[null,null,null,null,0,null,null,null,0,"","","","","",0,null,"Extra Loads"]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]
[null,null,null,null,0,null,null,null,0,"","","","","",0]

{"sheet":"ELAP Feed Transportation","index":4,"n_rows":30,"n_cols":25,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,6,29,15],[4,14,4,15],[9,6,9,9],[9,11,9,14],[11,15,27,15],[7,6,7,15],[5,10,5,11],[6,10,6,11],[9,10,27,10],[5,14,6,15],[4,7,4,9],[4,10,4,11],[4,12,4,13]]}
[]
[]
[]
[null,null,null,null,null,null,"Feed and LivestockTransportation Tool vs. 1.4",null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-04-09"},null,"None"]
[null,null,null,null,null,null,"Name:",null,null,null,"Program Year: ",null,null,null,"SDA/LR/Beginning or Veteran Farmer Or Rancher Definitions",null,null,"Socially Disadvantaged",null,null,null,null,null,2021,6.6]
[null,null,null,null,null,null,"Total Producer's Mileage Above Normal","Producer's Local Mileage Reduction","Eligible Mileage Above Normal","National Mileage Rate","Socially Disadvantaged, Limited Resource, Beginning or Veteran Farmer or Rancher",null,"Program Factor","Total Estimated Payment",{"$f":"IF(K7=R5,R11,IF(K7=R6,R12,IF(K7=R7,R13,IF(K7=R8,R14,\"None Selected\"))))","v":"None Selected"},null,null,"Limited Resource",null,null,null,null,null,2022,6.44]
[null,null,null,null,null,null,{"$f":"SUM(J12:J27)-SUM(O12:O28)","v":0},{"$f":"A30","v":0},{"$f":"G7-H7","v":0},{"$f":"IF(G7=0,0,VLOOKUP(M5,X5:Y16,2,FALSE))","v":0},"None",null,{"$f":"IF(K7=\"None\",0.6,0.9)","v":0.6},{"$f":"MAX(0,ROUND(I7*J7*M7,2))","v":0},null,null,null,"Beginning Farmer",null,null,null,null,null,2023,6.6]
[null,null,null,null,null,null,"FEED TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,"Veteran Farmer"]
[]
["current",null,"normal",null,null,null,"How much feed to livestock, or livestock to feed, did you transport this year?",null,null,null,2,"How much do you normally haul?",null,null,null,null,null,null,null,null,null,null,null,2024,6.6]
["<1000 miles truckloads",">1000 mile truckloads",null,"<1000 miles truckloads",">1000 mile truckloads",null,"Number of Truckloads This Year","Mileage per Truckload This Year","Share of Feed Cost This Year","Producer's Current Miles",null,"Normal Number of Truckloads","Normal Mileage per Truckload ","Share of Normal Feed Cost","Producer's Normal Miles","Comments",null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[{"$f":"IF(H12<=25,0,IF(H12<1000,G12,0))","v":0},{"$f":"IF(H12>1000,G12,0)","v":0},{"$f":"IF(M12<1000,L12,0)","v":0},{"$f":"IF(M12>1000,L12,0)","v":0},null,null,null,null,null,{"$f":"IF(G12=\"\",\"\",IF(H12>1000,1000*I12*G12,IF(H12<=25,0,ROUND(G12*H12*I12,2))))","v":""},null,null,null,null,{"$f":"IF(L12=\"\",\"\",IF(OR(L12=\"\",M12=\"\",N12=\"\"),0,IF(M12>=1000,1000*L12,ROUND(L12*M12*N12,2))))","v":""},{"$f":"R20&\"\n\"&R21&\"\n\"&R22&\"\n\"&R23&\"\n\"&R24&\"\n\"&R25","v":"\n\n\n\n\n"},{"$f":"IF(AND(G12>0,H12=\"\"),\"Enter Mileage per Truckload This Year\",IF(AND(G12>0,I12=\"\"),\"Enter Share of Current Feed Cost This Year\",IF(AND(L12>0,M12=\"\"),\"Enter Normal Mileage per Truckload\",IF(AND(L12>0,N12=\"\"),\"Enter Share of Normal Feed Cost\",IF(AND(H12>0,H12<=25),\"Mileage 25 miles or less will not be paid\",\"\")))))","v":""},"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[{"$f":"IF(H13<=25,0,IF(H13<1000,G13,0))","v":0},0,{"$f":"IF(M13<1000,L13,0)","v":0},{"$f":"IF(M13>1000,L13,0)","v":0},null,null,null,null,null,{"$f":"IF(G13=\"\",\"\",IF(H13>1000,1000*I13*G13,IF(H13<=25,0,ROUND(G13*H13*I13,2))))","v":""},null,null,null,null,{"$f":"IF(L13=\"\",\"\",IF(OR(L13=\"\",M13=\"\",N13=\"\"),0,IF(M13>=1000,1000*L13,ROUND(L13*M13*N13,2))))","v":""},null,{"$f":"IF(AND(G13>0,H13=\"\"),\"Enter Mileage per Truckload This Year\",IF(AND(G13>0,I13=\"\"),\"Enter Share of Current Feed Cost This Year\",IF(AND(L13>0,M13=\"\"),\"Enter Normal Mileage per Truckload\",IF(AND(L13>0,N13=\"\"),\"Enter Share of Normal Feed Cost\",IF(AND(H13>0,H13<=25),\"Mileage 25 miles or less will not be paid\",\"\")))))","v":""},"I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and substantially participate in the operation."]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"","I (or if applicable, the entity or joint operation) have not operated a farm or ranch for more than 10 years and am a veteran (as defined in 38 U.S.C. 101(2)) who first obtained status as a veteran during the most recent 10-year period."]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"","No"]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"","Yes"]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IFERROR(INDEX($Q$12:$Q$28, MATCH(0, COUNTIF($R$19:R19,$Q$12:$Q$28),0)), \"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IFERROR(INDEX($Q$12:$Q$28, MATCH(0, COUNTIF($R$19:R20,$Q$12:$Q$28),0)), \"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IFERROR(INDEX($Q$12:$Q$28, MATCH(0, COUNTIF($R$19:R21,$Q$12:$Q$28),0)), \"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IFERROR(INDEX($Q$12:$Q$28, MATCH(0, COUNTIF($R$19:R22,$Q$12:$Q$28),0)), \"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IF(OR(B30>0,D30>0),\"- Loads Greater than 1,000 miles limited to 1,000 miles\",\"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,"",{"$f":"IF(A30>0,\"- \"&A30/25&\" load(s) will have a 25 mile reduction applied\",\"\")","v":""}]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[0,0,0,0,null,null,null,null,null,"",null,null,null,null,"",null,""]
[{"$f":"SUM(A12:A28)","v":0},{"$f":"SUM(B12:B28)","v":0},0,0,null,"loads >1000",null,null,null,{"$f":"SUM(J12:J28)","v":0},null,null,null,{"$f":"SUM(O12:O28)","v":0}]
[{"$f":"IF(A29>C29,(A29-C29)*25,0)","v":0},{"$f":"IF(B29>D29,B29-D29,0)","v":0},null,{"$f":"SUM(D12:D28)","v":0},null,null,"Disclaimer:    \nThis Estimated Calculated Payment Report is an estimate and is for informational purposes only.   The Total Estimated Payment reflected on this Report takes into account several factors, including the producer’s current and normal year number of truckloads and mileage per truckload of livestock transported or livestock feed transported, which may vary due to changes in program regulations, producer eligibility, or member payment share.  \nThis report does not in any way obligate CCC to disburse the estimated payment amounts reflected and has no effect on a producer’s determination of eligibility or payment calculation under ELAP.  "]

{"sheet":"Instructions","index":5,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[12,1,12,2],[17,1,17,2]]}
[]
[null,"Instructions"]
[null,"Name:","Enter Name"]
[null,"Enter Program Year","Using the dropdown menu, select the year."]
[null,"Total Producer's Mileage Above Normal","No Entry Required.  \nCalculator will display the difference between Producer's Current Year Miles and Producer's Normal Year Miles."]
[null,"Producer's Local Mileage Reduction","No Entry Required.  \nCalculator will display the result of multiplying 25 mile local reduction per truckload, times the number of truckloads under 1,000 miles in excess of normal number of truckloads."]
[null,"Eligible Mileage Above Normal","No Entry Required.  \nCalculator will display the difference between Total Producer's Mileage Above Normal and Producer's Local Mileage Reduction."]
[null,"National Mileage Rate","No Entry Required.  \nCalculator will display the determined National Mileage Rate."]
[null,"Socially Disadvantaged, Limited Resource, Beginning or Veteran Farmer or Rancher","Using the dropdown menu, select if you meet the definition of Socially Disadvantaged, Limited Resource, Beginning Farmer or Rancher, or Veteran Farmer or Rancher."]
[null,"Program Factor","No Entry Required.  \nIf a selection was made for the Socially Disadvantaged, Limited Resource, Beginning or Veteran Farmer or Rancher 90% will display.  If none is selected then 60% will display."]
[null,"Total Estimated Payment","No Entry Required.  \nThe total estimated payment will display the resulot of Eligible Mileage Above Normal multiplied by the National Mileage Rate, multiplied by the Program Factor."]
[null,"SDA/LR/Beginning or Veteran Farmer Or Rancher Definitions","Definitions will display for the entry in Socially Disadvantaged, Limited Resource, Beginning Farmer or Rancher, or Veteran Farmer or Rancher."]
[null,{"$f":"'ELAP Feed Transportation'!G10","v":"How much feed to livestock, or livestock to feed, did you transport this year?"}]
[null,"Number of Truckloads This Year","Enter the number of truckloads of livestock feed, or livestock hauled to feed, you hauled this year."]
[null,"Mileage per Truckload This Year","Enter the miles per truckload you hauled of livestock feed, or livestock hauled to feed, this year for the applicable truckloads."]
[null,"Share of Feed Cost This Year","Enter your share of the feed or livestock transportation cost for the truckloads."]
[null,"Producer's Current Miles","No Entry Required.\nCalculator will display the number of truckloads multiplied by the mileage per truckload multiplied by the share.  \nIf the mileage per truckload exceeds 1000, 1000 times the number of truckloads will display.  \nIf the mileage per truckload is 25 miles or less a 0 will display."]
[null,{"$f":"'ELAP Feed Transportation'!L10","v":"How much do you normally haul?"}]
[null,"Normal Number of Truckloads","Enter the number of truckloads of livestock feed, or livestock hauled to feed, you normally haul."]
[null,"Normal Mileage per Truckload ","Enter the miles per truckload you normally haul of livestock feed, or livestock hauled to feed, for the applicable truckloads."]
[null,"Share of Normal Feed Cost","Enter your share of the feed or livestock transportation cost for the truckloads."]
[null,"Producer's Normal Miles","No Entry Required.\nCalculator will display the number of truckloads multiplied by the mileage per truckload multiplied by the share.  \nIf the mileage per truckload exceeds 1000, 1000 times the number of truckloads will display. "]
[null,"Comments","General Comments such as missing shares, mileage, or if an entry was reduced will display."]

{"sheet":"Above Normal Calculator","index":6,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":true,"merged":[[2,2,2,6],[4,1,4,5],[24,11,24,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[10,11,10,12],[9,11,9,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[11,11,11,12],[8,11,8,12],[11,1,11,3],[8,6,8,9],[11,6,11,8],[9,1,9,3],[10,1,10,3],[9,6,9,8],[10,6,10,8],[8,1,8,4]]}
[]
[null,"Feed Transportation Tool vs. 1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Socially Disadvantaged?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veteran Farmer?"]
[null,"How many loads were hauled this year that you normally don't haul under 1,000 miles?",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I am a member of a group listed below, whose members have been subject to racial, ethnic, or gender prejudice because of their identity as members of a group without regard to their individual qualities."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"My/our direct or indirect gross farm sales (as individuals, if applicable for the entity or joint operation) do not exceed the amount identified in the Limited Resource Farmer/Rancher Self-Determination Tool (https://lrftool.sc.egov.usda.gov/) for the 2 calendar years that precede the complete taxable year before the relevant program year, adjusted upwards in later years for any general inflation.\n\nMy/our total household income (as individuals, if applicable for the entity or joint operation) was at or below the national poverty level for a family of four in each of the same 2 previous years referenced above."]
[]
[null,"NORMAL YEAR FEED TRANSPORTATION",null,null,null,null,"CURRENT YEAR FEED TRANSPORTATION",null,null,null,null,"Weighted Average Mileage Above Normal"]
[null,"Total Miles",null,null,{"$f":"B31","v":2100},null,"Total Miles",null,null,{"$f":"G31","v":8400},null,{"$f":"J12-E12","v":438}]
[null,"Total Truckloads",null,null,{"$f":"C31","v":13},null,"Total Truckloads",null,null,{"$f":"H31","v":14},null,"Loads hauled this year, normally not hauled, under 1000 miles."]
[null,"Weighted Average Normal Year\n(Miles/Truckload)",null,null,{"$f":"D31","v":162},null,"Weighted Average Current Year\n(Miles/Truckload)",null,null,{"$f":"I31","v":600},null,{"$f":"IF(J11-E11-K31<0,0,J11-E11-K31)","v":0}]
[]
[null,"Number of Truckloads","Mileage\n","Share","Total Producer's Mileage Inccurred",null,"Number of Truckloads","Mileage Over Normal \n","Share","Total Producer's Mileage Inccurred","Number of truckloads over 1000 miles","Comments",null,null,null,null,null,null,null,null,null,"No"]
[null,1,100,1,{"$f":"IF(OR(D15=\"\",C15=\"\",B15=\"\"),\"\",ROUND(B15*D15*C15,0))","v":100},null,4,300,1,{"$f":"IF(OR(I15=\"\",H15=\"\",G15=\"\"),\"\",IF(H15>1000,1000*G15,ROUND(G15*I15*H15,0)))","v":1200},{"$f":"IF(H15>1000,G15,0)","v":0},{"$f":"IF(H15>1000,\"*  Limited to 1000 total miles\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"Yes"]
[null,2,200,1,400,null,3,100,1,300,{"$f":"IF(H16>1000,G16,0)","v":0},{"$f":"IF(H16>1000,\"*  Limited to 1000 total miles\",\"\")","v":""}]
[null,3,40,1,120,null,1,900,1,900,0,""]
[null,6,{"$f":"280/6","v":46.666666666666664},1,280,null,6,1200,1,{"$f":"IF(OR(I18=\"\",H18=\"\",G18=\"\"),\"\",IF(H18>1000,1000*G18,ROUND(G18*I18*H18,0)))","v":6000},6,"*  Limited to 1000 total miles"]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,1,1200,1,1200,null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,null,null,null,"",null,null,null,null,"",0,""]
[null,{"$f":"SUM(E15:E30)","v":2100},{"$f":"SUM(B15:B30)","v":13},{"$f":"ROUND(B31/C31,0)","v":162},null,null,{"$f":"SUM(J15:J30)","v":8400},{"$f":"SUM(G15:G30)","v":14},{"$f":"ROUND(G31/H31,0)","v":600},null,{"$f":"SUM(K15:K30)","v":6}]