New Land Mix Analysis Tool

The Select Land List screen should appear.  If you are creating a new sale from scratch, the list along the left would be blank.  In this example, we are editing a sale that already had a land list entered, which is the list on the left (Current Land List).

Under the ‘New Land List’ section is where you can insert a different land list that you like better than the current list. The acres are automatically matched from the land uses in the current land list to the land uses in the selected land list (in the example above, the selected land list is called ‘Moreau River project’). Notice that the line highlighted in purple on the left was not matched to anything; therefore, the total acreage will be different from the Current Land List to the New Land List (See ‘Acre Difference’ at the bottom right of the screen). If you add 430 acres to one of the Land Uses in the list, the Total Acres will match on both lists.

The idea with this new screen is that when you receive sales from someone who uses a different land list than you do, you can come here and see the previous land list right beside the land list that you use regularly to compare and make appropriate changes. If you want to compare the ‘Current Land List’ to a different land list than the ‘Moreau River project’ list pulled up, click on the down arrow under ‘New Land List’ and select the new list. We will select ‘Western SD Revised 2003’. Notice that the land list changed, but we still have the ‘Irrigated Subby’ that was not matched to anything on the new list. We will have to either create another land use at the bottom of our ‘Western SD Revised 2003’ list or add it to a land use already in the list.

If you don’t have any land lists set up, there will be nothing in the ‘New Land List’ section, as shown below. A balloon will come up telling you that there are no land lists set up and to click on the button ‘Create/Edit Land List’ to start a new list. Go ahead and click on this button.

Clicking on this button will open up two new screens: the first screen is where you name the land list you are going to create. We will name it ‘Western SD Cropland’. The second screen is where you create the list using Land Use names and Land Use Ratios. We will create six land types: Cropland A, Cropland B, Pasture, CRP Land, Hayland and Roads/Waste. For this example, the ratios associated with each will be: 100% for Cropland A, 60% for Cropland B, 45% for Pasture, 50% for CRP Land, 25% for Hayland, and 5% for Roads/Waste. Once you have the list complete, click on the 'Land List Options' button and select 'Save' and then click on ‘OK’.

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 ‘Land List Options’ menu and select Rename or Delete.

You will now be brought back to the ‘Select Land List’ screen where you can edit the acreages for each land use that was automatically transferred from the previous land list and you can make any other changes necessary to the new land list you just created.

One new feature that was added to this screen is in the drop-down arrow in the ‘Size’ column next to the acreage value. It is a calculator that you can use to figure out the correct acreage values for each Land Use.

Once you have the acreage and ratios correct, click on ‘Transfer List’ to transfer the land list to the sale sheet.

Now in your Land Mix Analysis section of the sales sheet, your Land List should be there with the correct acreages and ratios. Now click on the ‘Calculate Land Values’ button. The land values for the land types entered should have been calculated.

NOTE: If the sale is improved, you will have to enter a $/Acre value for the 100% Land Use in order for the 'Calculate Land Values' to work properly. If the sale is unimproved, you do not need to enter a $/Acre value for the 100% Land Use.

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.

Please note that any non-deeded values in the ‘Current Land List’ will be not be transferred to the ‘New Land List’. An example of a non-deeded value would be Forest Service permits (those Land Uses that do not use Acres as the measurement).