AgWare's ClickForms


AgWare is pleased to announce additions and changes to our 2020 ClickForms release.  The current AgWare products and their status, as of mid-August, are:


  1. DataLog; major revisions the last 3 years to include permanent plantings & ER Factor [equivalency rating] to calculate the land-mix adjustment
  2. ClickForms; approximately 20 forms added in this release and re-ordering location to match with the procedure an appraiser follows to assemble a report (NOTE: the cost approach will be addressed in a later release in 2020)
  3. MAVEN; on-going advancement since 2018 and 2019 implementation
  4. Chattel; August 2020 release and currently in testing
  5. MGR; major revisions in 2018-19 and currently implemented in several states.


Real Estate Markets & What They Tell Us


Appraisers are not professionally engaged to express opinions.  Instead, they are employed for their knowledge of accepted valuation methods, and techniques of data analysis.  Their ability to apply professional judgment as to how those methods should be applied depends on the facts of the assignment. Trained appraisers are required by professional, state, and federal standards to let market evidence dictate the parameters of value.  In cases of Market Value, adhering to these standards ensures that appraisers do not express personal opinions. Research and analysis may determine broader research is necessary, if results are mixed or inconclusive. Through this process appraisers ensure that they can ultimately express their findings as to the market’s opinion of value rather than their own. Findings are not intended to please or displease clients or others --- only report what market evidence supports. Findings are based upon a financial, economic, and societal system that was established during the 1920s and 1930s to provide more stable markets in which market participants and others could have confidence and knowledge in “real estate values.”  Prior to the evolution of this system, loans generally were not available, and abuses were widespread.


AgWare's Appraisal Forms


Each of the forms is a summary of sales transaction data from which the approaches to value are summarized.  Those forms may be accompanied with narratives, but most readers, including financial intermediaries and review appraisers, are likely to read at the summaries first, and perhaps only later review the underlying support.  Thus, if the summaries are incorrect or lack explanation, errors, or misleading elements are contained therein, the appraiser has created a misleading appraisal report.  Thus, the forms must stand on their own and the appraiser must explain the strengths and weakness of each market and their research beyond just what the form may require.  In valuation circles, this means matching the research and analysis with the appraisal complexity to solve the valuation problem --- not simply corresponding to a blank on the form.


ClickForms Additions & Changes


These comments are directed to the ClickForms portion, a release with the following pages that are now our new standard and visible in the “ “UAAR (New)” or “Common” folders.  We recognize hesitancy for change, but please take the time to open, view, and/or print each new page. The 2020 Case Study is available in the "Template" folder and "page help" linked to that case study.  We believe most of the changes benefit data analysis and the reporting process centering on a higher degree of DataLog integration.  AgWare hopes our users also transition into geo-referencing (lat/long) to allow distance measurement between properties displayed in the Sales Comparison Grid (type "Distance to" into the grid, but sales AND subject must have coordinates).


Common Folder (forms typically used for all reports)


  1. Subject QuickStart (SQS) that synchronizes with DataLog files to enable "save a 'subject' as a “sale” and visa versa --- and populate the Report Summary, Subject Property information, and the Reconciliation pages, including the allocation of the final value opinion
  2. Introduction
    1. Cover pages
      1. Cover Page (Auto fill with Image)
      2. Cover Page (Auto fill)
      3. Cover Page (Manual)
  3. Definitions & Assumptions
    1. General Appraisal Definitions
    2. Value Definition
    3. Standard Limiting Conditions

UAAR (New)


  1. Introduction (Identifying the Subject and Base Information)
    1. Report Summary (Single Property situation [typical])
    2. Report Summary (Dual Properties in same report)
    3. Scope of Work & Approaches Used or Omitted
    4. Market Area Description
    5. Highest & Best Use
    6. Subject Land Description
    7. Subject Improvement Description
  2. Income Approach
    1. Income Approach
    2. Income Capitalization Rate Source
  3. Sales Comparison Approach
    1. Sales Comparison (ER Procedure)
      1. ER Land-Mix Adjustment Worksheet
    2. Improvements (Head to Head): Traditional Procedure
      1. Improvement Adjustment – Multiple Improvements on one page
      2. Improvement Adjustment – Single Improvement (one at a time)
    3. Improvements (Non Head to Head):  New Procedure
      1. Improvement Value ONCE from sale contributions (page can be replicate many times, i.e., multiple locations or multiple specialty improvements
        1. Improvement Adjustment Summary:  One or more pages above summarized and improvement adjustment applicable between each sale and subject reflecting the subject’s mixture
    4. Feature Pairings (comparisons to measure differences between properties with a feature v. those without)
      1. Paired Sales – 1 Feature
      2. Paired Sales – 3 Features (similar to original pairing page in Classic Forms (traditional)
  4. Conclusion
    1. Reconciliation – Single Property
    2. Reconciliation – Dual Property Situations (before v. after, “as is” v. “as proposed”, current v. retrospective, etc.)


UAAR (Classic)


An AgWare user can continue to use those forms for the time they are supported but alerts the user a new option is available.

NOTE:  The remaining Classic pages in use, that have been used in past years, are still available --- including the traditional land and building-mix forms.  Those folders are now identified as:

  1. QuickStart Page (traditional)
  2. Report Introduction
  3. Definition of Value
  4. Specialty Improvements
  5. Subject Description
  6. Highest and Best Use
  7. Data Analysis
    1. Cost Info Worksheet
    2. Depreciation Analysis
    3. Excess Land Worksheet
    4. Land Table Worksheet
    5. Other Improvements Worksheet
    6. Ratio Analysis Worksheet
    7. Time Trend Analysis Worksheet
  8. Approaches
  9. Reconciliation
  10. Condemnation
  11. Certifications


Archived Forms


This folder contains the remaining historic forms used in prior years.  Those pages “retired” have been moved to the Archived Forms folder.  Your old reports will still open, but the pages “archived” will appear in RED in the Forms Manager.  Archived forms should not be used, i.e., math calculations may not work and/or contain outdated USPAP requirements/definitions.  

AgWare also added an Outdated Folder containing functional forms but a new format exists with a superior layout.  These forms will NOT appear in RED.