Creating a Land Table

PRINT THIS DOCUMENT - CREATING A LAND TABLE (PDF)

Click here to go Back to the Main Help Page.

To create a new land table, go to the Land Mix Analysis section of the sales sheet. Click on the button called “Select Land List”.

The Land List Selector screen should appear. At the top left of this screen, there is a menu called List. Click on this menu and then select New.

You will then be prompted to name this list. Let’s call it “Western SD Land Types”. (You can save as many lists in here as you want.) Type that name in and then select OK.

Now you need to type in the names of the land types and the ratio desired for each type. We will keep this table short and only select four land types: Cropland, Pasture, Creek Bottoms, and FS Permits. For this example, the ratios associated with each will be: 100% for Cropland, 60% for Pasture, 100% for Creek Bottoms, and we will leave the ratio blank for FS Permits. Once all of the land types are entered, click on the List menu again and select Save.

If you wish to rename or delete this list now or at a later date, simply select the correct list from the drop down list and then go up to the List menu and select Rename or Delete.

Now to transfer this Land Table to your sale sheet, simply select the correct land list from the drop down list. Make sure that the ratios are as you want them to appear and then click on the “Transfer List” button.

Now in your Land Mix Analysis section of the sales sheet, your Land Table should be there with the correct ratios. Now you need to enter the acres for each land type. In this example, let’s say there are 300 acres of Cropland and 250 acres of Pasture. Now click on the “Calculate Land Values” button. The land values for the land types entered should have been calculated.

One thing you need to note is that when you are entering land types with acres, only use the first three columns: Ratios, Acres, and $/Acre. If you are using a different type of measurement such as AUMs, only use the next three columns: Unit Size, Unit Type, and $/Unit.