DataLog Overview Video
Hello, and welcome to the AgWare DataLog Overview Video. This video is meant to be a quick overview of the features of DataLog.
First, let’s start by opening up the program. When you installed DataLog, it should have automatically placed a shortcut on your desktop. Double click on the icon to open the program. Notice that there are four sections in the main screen of DataLog. In the upper left hand corner you will see the directory of the My Sales folder. You can easily add a new folder by right clicking on the my sales folder and selecting create folder. It will then place a new folder at the bottom of your folders and you can name it. If you would like to rename a folder, you can do so by right clicking on the desired folder and selecting rename folder. You can delete any folder by right clicking on the folder and selecting delete folder. Right underneath the folder section, you will see a tools section. The upper right hand section is a sales grid or list of the sales in the selected folder. Below the sales grid, you will see a sales viewer section that displays the currently selected sale. You can resize any section by dragging the separator bar that is between any two sections to the desired location.
To enter a new sale, go to the menu options above the sales grid and click the new sale button. You will notice that you can open a new blank sale, use current sale as a template, or use your own template. More than likely, you won’t have any sales yet, and won’t have any templates set up to use the template options, so click new blank sale. This is what a new blank sale looks like. You’ll notice that there are many different sections.
The first section is the sales identification section, and then you have the sale analysis section. The information in these two sections is very important and shows many different details for sales such as location, highest and best use, financing information, property details, etc. The next section is the land mix analysis section. This section is where you will enter all of your various land and/or soil types and allocate the respective values. The maximum number of land and/or soil types you can enter is ten. Next, you’ll see the permanent plantings section – this section can be very useful if you have permanent plantings you want to include such as pecans, walnuts, oranges, grapes, etc. Notice that there is an option to expand each line of the permanent plantings section to include more detailed information. Similar to the land mix analysis section, the permanent plantings section has a maximum of ten planting types.
The next section is the income analysis section – there are two tabs in this section; the capitalization rate tab and the discounted cash flows tab. On the capitalization rate tab you would enter any income you have for your sale, and also any expenses. You’ll notice that the expense ratio and cap rate are calculated on this tab. You can enter up to seven different income sources. The next tab is the discounted cash flows tab. This provides a spreadsheet interface for calculating your discount rate. Once you enter your information here you’ll need to set the discount rate cell, so that the yield rate field will be populated. The next section is the improvement analysis section. You can enter up to twenty improvements for any given sale. There are three input methods for entering improvements. To view and/or change your options, click on the improvement options button and click input method – this will bring up a dialog box that shows your different input options.
The next section is the comments section. You’ll notice that there are four tabs in this section – sale comments, sale comparison, cost comparison, and general. If you have various comments for your sale, you would enter them in the respective tab. Each tab has the same big comment box, and it does have spell check. The next section is mapping. Here you can enter a latitude and longitude, or simply add a marker to a map if you know the exact location. If you enter latitude and longitude, be sure to enter the longitude with a negative sign in front of it. There are also different mapping options within this section if you click on the map options button. The next section is photo pages. This is where you can add up to twenty photo pages, or ten PDF exhibit pages. To add a photo page click the add button – you’ll see you have different photo quantity and size options for your page. If you click insert PDF as exhibit, you can insert up to a ten page PDF document. It will create a separate exhibit page for each PDF page. These photo pages can transfer over to ClickFORMS or print with the sale sheet in DataLog. The next section is attachments. Here you can attach as many items as you want, but it’s good to know that if you attach too many things, it may increase the sale size significantly and can slow things down quite a bit. You can attach any type of file in the attachments section – word, excel, PDF, jpg, png, etc. The last section is the allocation section. This section is always displayed at the bottom of your sale. It shows how much you have entered in your land section, permanent plantings section, and improvements section. It also shows you the difference in your sale price and allocated dollars as well as the difference between your deeded acres and allocated acres. This section cannot be edited because all the fields in this section are calculated fields that transfer in from another place in the sale.
To save a sale you can either go to the sale menu option and click save, or save and close. You’ll also see an option to close the sale without saving. This is a good option if you opened an existing sale and you want to make sure that you didn’t make any changes. You can also click the x in the upper right hand corner because the sale automatically saves upon closing. To demonstrate, I’ll just enter a grantor and grantee for this sale and save it. I’ll enter John Smith for the grantor and Jim Davis for the grantee and click the x in the upper right hand corner. Now, you’ll see the sale in the sales grid, as well as in the sale viewer below the sales grid. There are many different sale views and you can see and change them here. You can also print a sale from here as well. Whatever view you have selected is the way your sale will look when printed. If you want to print the sale simply click print sale. If you need to edit your sale, you can either click the edit sale button or double click on the sale in the sales grid and it will open the sale.
To produce a land analysis or improvement analysis report in DataLog, click the reports button and then click the desired option: analyze land or analyze improvements. To transfer sales to ClickFORMS, highlight the sale in the sales grid, click the transfer button, and then click copy to clipboard. Then open ClickFORMS, and click paste or paste special in the home tab ribbon.
If you would like further explanation on any of the topics mentioned in this video, please refer to the other videos and topics on our website, give us a call at 605-787-7871, or send an email to [email protected]. I hope this video was helpful for you today. Thank you for taking the time to watch it, and thank you for choosing the AgWare software.