Get documents about "Instructions
Document Sample
Instructions to Farm Operators
for Completing the farmdoc Excel Spreadsheet for StarLink Corn Loss Claims
Note: This spreadsheet is an optional tool for use in preparing a Proof of Claim.
These instructions supplement more comprehensive instructions for preparing a
Corn Loss Proof of Claim (click HERE if you have not already read these instructions;
you will be returned to the more comprehensive instructions).
The purpose of this farmdoc Excel Spreadsheet is to:
Make it easier for Farm Operators with several farms to submit a Corn Loss Proof of
Claim by allowing the Farm Operator to compile and summarize data from many
farms on one spreadsheet.
Make it easier for the Claims Administrator’s to review and approve the claim (by
showing how the total corn acres eligible for payment ties back to the corn acres
reported on each form FSA-578 attached by Farm Operator to the Proof of Claim).
Alternatively, the Farm Operator can skip completing the Excel Spreadsheet and, instead,
can enter complete data directly on the Corn Loss Proof of Claim form as describe in the
more comprehensive instructions for completing a Proof of Claim.
Below are the instructions to Farm Operator for completing the optional Excel
Spreadsheet and carrying the summary data to the Corn Loss Proof of Claim form (Note:
By clicking on any of the three tabs appearing at the bottom left of your screen, you can
move back and forth between these instructions, an example of a completed spreadsheet,
and a blank spreadsheet ready to receive your data):
1. For each farm where Farm Operator harvested corn for grain in year 2000,
examine form FSA-578 for Program Year 2000 (copy obtained from your records
or from your Farm Service Agency office).
2. On each FSA-578, identify the Tract Number(s) on which corn was planted.
3. For each Tract Number with corn acres, enter the appropriate information from
the FSA-578 into the Spreadsheet in columns A-H as follows (if the FSA-578
does not have the needed info, just leave that cell blank):
A: State (e.g., Illinois)
B: County (e.g., Champaign)
C: Farm # (e.g., 792)
D: Tract # (e.g., 987): If a farm has more than one Tract # on which corn was
planted, complete a separate line (all columns) for each Tract #.
E: Field #s (e.g., 2B & 3B): A tract may have one or more field numbers on
which corn was planted; enter all field numbers containing corn acres.
F: In Sec. (e.g., 1): Enter the Section in which the preceding Field #s were
located.
G: TwnShp&Range (e.g., T20N, R12E): Enter the Township & Range in the
legal description.
H: Total Corn Acres (e.g., 75.8): Note that all these acres may not be eligible for
payment, e.g., acres planted with StarLink seed, acres harvested for silage, or
acres that drowned out and were not harvested would not be eligible.
4. If any of the corn acres reported in Column H were planted with StarLink seed or
were not harvested for grain, complete Columns I and/or J as described below:
H: Total Corn Acres (e.g., 75.8): Note that all these acres may not be eligible for
payment, e.g., acres planted with StarLink seed, acres harvested for silage, or
acres that drowned out and were not harvested would not be eligible.
4. If any of the corn acres reported in Column H were planted with StarLink seed or
were not harvested for grain, complete Columns I and/or J as described below:
I: Less StarLink Acres (e.g., 0): Enter any corn acres listed in Col. H that were
planted with StarLink seed (these acres are not eligible for payment, but this
number is less than 1% of the 2000 corn acres planted nationwide).
J: Less Other Ac. Not Harvested For Grain (e.g., 0): Enter any corn acres listed
in Col. H that were not harvested for grain, e.g., acres harvested for silage or
drowned out acres not harvested at all (these acres would not be eligible to
share in the settlement).
5. Click on the “Blank Form” tab at the bottom left of your screen and enter data
from your form FSA-578s. As you enter “acres” data, the farmdoc Excel
Spreadsheet will calculate:
(a) For each Farm/Tract reported on a separate line of the spreadsheet:
Acres of Non-StarLink Corn Harvested for Grain in 2000.
(b) For all Farms/Tracts reported on the spreadsheet (see last line):
Total Corn Acres Reported on FSA-578s,
Total StarLink Acres (these acres are subtracted),
Total Other Acres Not Harvested For Grain (these are subtracted), and
Total Acres of Non-StarLink Corn Harvested (i.e., the year 2000 acres
eligible to participate in the multi-million dollar settlement).
6. Print out your completed Spreadsheet (it will be an attachment to your Corn Loss
Proof of Claim).
7. Return to Step 4 of the more comprehensive instructions by clicking HERE.
Attachment II.A. to Corn Loss Proof of Claim and Release, Part II (Statement of Claim), Subpart A (2000 Non-StarLink Corn)
To: StarLink Claims Administrator
1. Information provided in the first eight columns (Col. A - H) of the spreadsheet (grey shaded area) matches info on Form(s) FSA-578 also attached.
2. Acres reported in the 9th and 10th columns (Col. I & J) are not eligible for the StarLink Settlement Corn Loss Payment and are subtracted.
3. The remaining acres reported in the last column (Col. K) of the spreadsheet are eligible for the StarLink Settlement Corn Loss Payment.
4. The sum of all eligible corn acres, for up to thirteen Farms/Tracts operated by Claimant and reported on this Attachment, is the last entry
in the last column (Col. K) of the spreadsheet (in Bold Print ); it is carried to Part II.A of the Corn Loss Proof of Claim form as a summary entry.
Farm Description, including State, County, FSA Farm #, Tract #, Field #s, CornAcres Less Less Other Ac. Acres of Non-
and Section, Township, and Range of these fields, if known Reported StarLink Not Harvested StarLink Corn
State County Farm # Tract # Field #s In Sec. TwnShp&Range on FSA-578 Acres* For Grain** Harvested
IL Champaign 792 987 2B & 3B 1 T20N, R12E 75.8 0 0 75.8
IL Champaign 834 683 1 26 T21N, R12E 40.2 0 8.5 31.7
IL Champaign 946 681 1B 26 T21N, R12E 99.0 0 0 99.0
IL Champaign 1391 712 3C,4C,5C 31 T21N, R11E 119.4 0 0 119.4
IL Champaign 1567 414 1B 20 T21N, R10E 80.1 0 0 80.1
IL Champaign 2171 1027 1A 9 T21N, R11E 70.0 20 0 50.0
IL Champaign 2233 1645 1B, 2B, 25 T20N, R12E 151.2 0 0 151.2
IL Champaign 2267 699 2 25 T21N, R11E 158.8 0 100 58.8
IL Ford 2267 1026 1C 9 T20N, R11E 76.0 0 0 76.0
IL Ford 2589 1010 1 5 T20N, R13E 39.9 0 0 39.9
IN Hoosier 8252 12004 1B, 2B 29 T21N, R13E 86.5 0 0 86.5
______ ______ _______ _________
Total Acres, by Catefory, for All Farms/Tracts Reported Above: 996.9 20 108.5 868.4
* Acres planted with StarLink seed are not eligible for payment out of the settlement and are, therefore, subtracted.
**Acres not "harvested for grain", e.g., acres used as silage or "drowned out" and not harvested, are not eligible for payment; they are subtracted.
Attachment II.A. to Corn Loss Proof of Claim and Release, Part II (Statement of Claim), Subpart A (2000 Non-StarLink Corn)
To: StarLink Claims Administrator
1. Information provided in the first eight columns (Col. A - H) of the spreadsheet (grey shaded area) matches info on Form(s) FSA-578 also attached.
2. Acres reported in the 9th and 10th columns (Col. I & J) are not eligible for the StarLink Settlement Corn Loss Payment and are subtracted.
3. The remaining acres reported in the last column (Col. K) of the spreadsheet are eligible for the StarLink Settlement Corn Loss Payment.
4. The sum of all eligible corn acres, for up to thirteen Farms/Tracts operated by Claimant and reported on this Attachment, is the last entry
in the last column (Col. K) of the spreadsheet (in Bold Print ); it is carried to Part II.A of the Corn Loss Proof of Claim form as a summary entry.
Farm Description, including State, County, FSA Farm #, Tract #, Field #s, CornAcres Less Less Other Ac. Acres of Non-
and Section, Township, and Range of these fields, if known Reported StarLink Not Harvested StarLink Corn
State County Farm # Tract # Field #s In Sec. TwnShp&Range on FSA-578 Acres* For Grain** Harvested
0
0
0
0
0
0
0
0
0
0
0
0
0
Total Acres, by Catefory, for All Farms/Tracts Reported Above: 0 0 0 0
* Acres planted with StarLink seed are not eligible for payment out of the settlement and are, therefore, subtracted.
**Acres not "harvested for grain", e.g., acres used as silage or "drowned out" and not harvested, are not eligible for payment; they are subtracted.
Related docs
