oh sneaking up on me are you no you found me in my office I'm uh working on a spreadsheet
here let me show you the spreadsheet I built for the farm that contains our seating of
the fields what crops we see it in those fields the acreage for acreage reports that we need
to turn in the Harvest uh bushels how do we uh account for the bushels as they come to
the bin and also as far as marketing so without much further ado I don't think there's much
do around here all right let's just get it done come along
all right let's get started so on my spreadsheet that I built first thing I do is I put in
the year 2023 that will tell the rest of the sheets we're working with 2023 on all the
data then I go down and here I have individual uh fields and tracks and there's many many
tracks let me just uh scroll down and show you how many fields there are there's over
125 fields and so each one of those need to be accounted for when you hold the mouse over
uh it gives me a map of those of that track and the fields that are contained in that
track and and that's uh that's cool because then you can visually see oh yeah I remember
that which field that is and and so it's just uh it's a nice uh addition to when you're
uh doing the data input also we have the proposed acres and see that this is where we start
out the year in planning where we're going to seed the crops in which Fields these are
the history of the fields from previous years what crop was on those individual fields and
uh this is all the years of the totals and this is the total of the whole Farm but each
uh unit has its own boxes here so you can check and say yeah there's this many acres
in this one this one that one as we are planning here we look at this one this uh reflective
last year last year it was seated spring wheat let's just go ahead and say we're going to
see duh our Nazi we're gonna can't follow this one all right it's gonna automatically
um check this box as CC because it sees there was no a crop on it if there's not a crop
it's going to be automatically summer fall so this one here was summer fall last year
let's go ahead and do some winter week where do we we plan last fall I would have this
done um and so I we'll just call it that we had it had planted where we did in that one
uh yellow peas uh let's see some yellow peas on this one because that's re-crop uh and
then this one here let's just go ahead and we'll we're going to seed spring wheat on
this uh summer follow uh then we go across this summer and follow oh that was winter
wheat last year and then we'll finish up with this uh example of barley Okay so we've got
uh these four crops and then as we're seeding uh we'll and finish that field we'll check
that box and what that does is that will add up those Acres tied to the the to the crop
um reflective on the upcoming sheets Okay so we've got all all our crops seated we're
done we need to start doing reports so we got to fill out two reports one to the government
to FSA office um and then the other one is to uh Insurance crop insurance uh so the first
one the FSA certification sheet it we every field has to be identified of what was needed
also the date so you can put the date in here so we've got those uh done that's pretty much
all filled out for federal crop and it goes across all all the other units that's on the
farm uh will be filled out automatically just by the seating just checking that box so then
we go to the federal crop to do it and that's different because they go by units not individual
Fields necessarily so it's going to be different totals and so as you can see here on that
one unit unit one we've got uh the summer fall of 208 290 on winter yellow peas 152
151.9 and so that it pretty much fills it out we can put the plant date in and that's
the information we need for federal crop so how we do this one is we'll start bin one
um was 2023.
it was the year that we were doing the Harvest uh was Winter week we had seated when we harvested
winter wheat first so let's go and that was summer follow let's go 200 inches we measure
how many inches of each unit is in the bin uh there might be more than one unit in there
and this way we can keep each unit separate and it was off unit one uh there's many other
units as you can see by this drop uh menu here that has to be accounted for and all
you do is you click down instead of having to type uh that unit nut name in so it really
makes it handy so it's already populated and calculated the the bushels in that bin reason
why it's important about the date let me do bin six and let's just put in uh not 24 let's
go into 2019 we've just kept that bin we never sold it don't ask me why uh and it was uh
uh chip canola okay and it was unit one all right now let's put some 45 in there okay
we had a hundred uh 1400 bushels of canola I'm going to show you why that's important
so those bin levels uh are translated into where the unit is and that also will populate
these uh cells that are important because this is a sharecrop the crop shares and so
this total of the 48 will be divided amongst those who have an interest in that crop um
here we have the the Acres from the previous report when we were planting and this is the
bushels that came out of that bin and it gives us a yield it's automatically calculated I
didn't have to put any of this data in same with the winter week we had this many of almost
5 000 bushels of winter wheat and we had 290 that gave a yield of 17.2 uh same thing with
yellow peas 26 and barley of uh 23.
okay so after harvest um we have the Harvest bin totals this is just reflective of this
sheet of what we harvested this year and the reason why I was telling you about the uh
date as far as the current date on that one box here's that 200 2019 canola there is no
uh bushels because it was not produced this year so that's what's important about the
dates uh if we need a cc loan on it it'll we can check that add the amount uh who who
took the loan out on it and so we'll get a good indication so this gives me a snapshot
of what came in at Harvest Time the as the bands and also there's a box in each one of
the bins to check for protein if you want to add the protein it'll show up here so it
really helps in marketing the bin inventories are your current um Grain on hand it could
be over multiple years and so look at this cannoli see where that canola now shows up
and so this is the total grain and it could also be if we put in a seed it'll show up
in our seed bins as far as seed availability so we can keep an inventory of that also I
have a sheet here for contracts I've redacted a ton of them I just put in a couple examples
here just kind of show I can keep track of the contracts whenever we make a contract
I can put it in here and I can see when the dates do and it'll let me know uh okay and
then the last sheet is the share crops all those crops will come into a total of the
different kinds of crops that are planted on those and then as I can want to know you
know what what their shares worth I can put in in the price I can put a general price
up here and then they all get that price at that certain date or I can put individual
prices uh discounts whatever and then it'll come up what their total worth is and then
I can put a check to see if it's paid or not paid the date it was paid and so I can keep
track of all that hopefully I didn't bore you um You probably finished your popcorn
a long time before this but this is how we uh handle our grain um and uh and then also
uh the seating and keeping a history and so next year this will be two thousand at 24.
and then it will clean itself up uh when I hit a button and then it'll start over and
I can start the next year all right I'm going to turn you back over to Bob okay thanks Bob
for that short presentation I think you spread yourself a little thin anyway guys take care
and we'll catch you on the next rerun [Music]
[Music] foreign