Version: AgWare Maven 2022.1.28.2488
Release Date: May 20, 2022
Download Link: Download Now
- Boundary Lines have been changed in regards to how they are handled by the system. This is largely a behind-the-scenes update but there are some UI changes as well. Boundary Lines are now drawn using Google Maps’s built-in drawing controls:There are 2 drawing controls: A Line control for drawing lines, and a Hand control that can be used to select and drag the map/lines. The Line control is selected by default. Lines are drawn by clicking on the map with the Line control active, and clicking on additional points to create line segments. To stop drawing a line, either switch to the Hand tool or click on the last point that was added to the line. Existing lines can be modified by clicking and dragging the semi-transparent circles between line segments. To delete a line, click on it with the Hand tool. The line will turn red and a “Delete Selected” button will appear at the top of the Map.
- An option to adjust Improvement comparisons based on Remaining Life has been added. This is an option for SCA Land Mix and SCA Component Models. A new “Improvements” tab has been added to the configuration for those Model types.
- The Subject Map has been updated to allow polygons to be drawn in addition to placing a simple Marker. The Marker continues to act exactly as before, however new controls have been added to the bottom of the map that allow polygons to be drawn. Polygons can be deleted the same way Boundary Lines are, by using the Hand tool and selecting them: SCA Model Boundary Lines. Polygons are optional and separate from the Map marker, which is linked to Latitude and Longitude fields and still required for Subjects.
- The Valuation Override Report now lists details of the overridden Sales. Expanding a Valuation index in the grid will list individual Added/Removed Sales and their reasons.
- Permanent Plantings have been added to the Sale Info popup. It contains two tabs: Blocks and Summary. In the Blocks view each row can be expanded to show Values and Depreciation.
- Controls for adding secondary values to the Property Type, Land Use, and Attribute fields for Subjects have been added. The secondary values are entered by using the buttons attached to the primary inputs for these valuesThe number on the button shows how many secondary values are set for the field. Clicking the button opens a popup where the values can be entered.The popup has a dropdown menu that contains the same options as the primary input it is attached to. To enter a secondary value, select an option from the dropdown and click “Add”. This will add the selected value to the list in the lower area of the popup. To delete a value, click the ‘X’ next to it in the list.
- The report template editor has been updated to allow files to be saved with a different name with a Save As command. After opening a template, users can selected Save As to save the modified template as a different name without updating the original file. With this change new templates can also be created in the editor and saved with a name specified.
- Comparison Values can now use Secondary values for Property Type, Land Use, and Attributes. The formula for coming up with a rating for a Sale Comparison is as follows:Each Subject value is rated against every Sale value. All of these individual ratings are summed together. The sum is then divided by the number of distinct values between the two sets. By default, these comparisons use the rating scheme of 1 if they match and 0 if they do not match, however they also support Rating Matrices.
- Changes have been made with how signing information is managed when performing a Rollback of a Finalized Report. When a Report is rolled back, the Signature, Name, and Signed Date fields for the Appraiser and Co-Appraiser are cleared out. Other information such as certification and inspection fields are kept.When previewing a Report as an Appraiser (first signature), the Co-Appraiser fields should not be shown in the preview. If no Co-Appraiser is required at the time of signing, all remaining Co-Appraiser information is deleted from the Report.
- Range of Value models can be saved without approval. If attempting to Save a RoV model via the ‘Save’ link above the form that appears after editing a field, the Model should save without warning provided all other fields are valid. Users should no longer receive a “Name field is required” error. When saving an RoV model this way, it will be placed in the “Modified” state. To approve an RoV model a Name must still be entered and the “Approve” button used.
- A new “Sale Search” tab has been added to the Valuation Details form. The tab contains new controls for finding Sale Comparison to add to the report via override. This replaces the old method of only being able to add a Sale Comparison manually by entering in its Sale Index. The form currently allows the user to search for Sales using the Sale Index, a Date Range, a size range for Deeded Acres, and a Distance. The Distance parameter restricts search results to within a specified number of miles from the Subject property.
- Sale Index: Entering text in this field will return Sales whose Index matches all or part of the Index entered. For example, if “SD21” is used as a Sale Index in the search box, then Sales SD21001, SD21002, SD21003, etc. will be returned as results.
- Date: Using a Min and/or Max Date will return Sales whose Sale Date falls on or after the Min Date and on or before the Max Date. Both parameters are optional. If a Min Date is entered with no Max Date, then all Sales with a Sale Date after the Min Date will be returned with no upper limit.
- Deeded Acres: Works the same as Date, only using the Deeded Acres field of the Sale.
- Max Distance: The map contains a green marker indicating the location of the Subject. When a value is entered into the Max Distance field, a circle around the Subject is created showing the area covered by the distance entered, only Sales within this area will be included in search results.
Clicking the “Search” button will perform the search. Results are shown in the grid on the right and markers for each result are placed on the map.
The Sales returned as results are filtered and adjusted for use in the Report. Sales that are incompatible (ex. Sales whose Land Mix will not work for the Subject in a Report using a Traditional Land-Mix model) are excluded from the results. Ideally, every Sale returned in the search should be usable as a Sale Comparison in the report. To add Sales as Sale Comparisons, click the checkbox next to them in the Grid, or click the checkbox in the popup that appears when clicking on their map marker.
Multiple Sales can be selected at once. Once all desired Sales are chosen, clicking the “Add Selected” button will add them to the Valuation.
- The grids used to update Valuations in the Override tab have been replaced with new controls for Improvements, Sale Comparisons, and Land Rows (Component Valuations only). The new grids omit the “Update” buttons that used to be needed to push through the changes after entering new values in the grid. Now, the Valuation is updated in real-time once the fields are changed in the grid.For Sale Comparisons, in place of the old method of adding them directly by Sale Index, the Add (+) button now copies whatever value is entered in to the old Sale Index field and copies it to the Sale Index field on the new Sale Search tab and begins a search automatically.
- “Effective Date” has been added as a new field when choosing a Model and starting a Valuation. The date entered here will be used as the Effective Date of Appraisal, instead of using the Subject’s date has before. The default value of the Effective Date field is the current date.
- Fields on the Sale Search tab for Valuations are now initialized to default values. The default values are:
- The Valuation Override report has had some updates. The Username dropdown has been removed, now only Start Date and End Date are used as parameters. The results from the search will be displayed in two grids: Users and Models. The first tab shows the User report. This is similar to the old grid. The results are shown summarized per-user, with filtering options on the User column. This is the reason the Username search parameter was removed.A new column showing the average change from the original Model-derived value has been added. This shows, as an average, how much that user is overriding the value by.Expanding a User row shows the individual overridden valuations as before. A new column showing how much the value was changed, as a percentage of the original value, has been added. Expanding a valuation will list the overridden sales for that valuation. This has been changed from the old version to include both Added and Removed Sales in the same grid instead of showing them in separate lists. An “Action” column has been added to indicate if the Sale was Added or Removed. This column is filterable.The second tab on the page shows the same data as the first, but grouped together by the Model used instead of by User.A third tab displays all valuations with override, without being grouped by a User or Model. It contains the same data as the second-level grids of the previous two tabs.
- The db-update tool will now prompt for user input to prevent it from closing after running. This is useful when opening the program from Windows Explorer. A new command line option -c or –close has been added to allow the program to close normally without the prompt.
- New statistics are shown after running a Model Evaluation. The new stats are:
- Coefficient of Dispersion
- Weighted Coefficient of Dispersion
- Coefficient of Variation
- Weighted Coefficient of Variation
- Q1, Q3
- Low, High, Mean, and Median price spread
- The old “Coefficient of Dispersion” has been renamed to “Quartile CoD”
The Low, High, Mean, and Median price spread values represent summaries of the spread between the lowest adjusted price of a Sale Comparison and the highest. For SCA Land Mix valuations this is simply the spread between the Sale Comparisons. For SCA Component valuations we calculate a spread for each land row, and then use the highest of these to display a spread for the overall valuation.
When the evaluation finishes, the statistics are shown as a summary with just the valued count, average, and Quartile CoD shown.
A Help link is shown in the upper-right corner of a panel and opens up a page explaining the statistics.
Expanding the panel shows all of the statistics:
- Sale Comparisons can now be reordered by dragging-and-dropping on the Override tab. To move a Sale, click the icon in the Order column of the grid and drag it to the row on the grid you want it to be in. When moving a Sale up, the Sale it gets dropped onto will be moved down along with all Sales in-between. When moving down, the Sale it gets dropped onto will be moved up along with all Sales in-between.
- The Valuation Details form has been updated to use the same new layout as other report types. The Override tab contains grids for inputting the unit value for Land and Improvements. Since RoV valuation types do no use Sale Comparisons, the Sale Search tab is not included on the form.
- When updating the selection of Sales for a Land-Mix valuation, the per-unit value no longer changes, instead a calculated value based on the selected sales is displayed, however the user must manually input the actual per-unit value used by the valuation.
- When cloning a Sale or Subject to a new Subject, the Date is no longer copied and instead set to the current Date. This may be tricky to test since we no longer show the Date field for Subjects. It’s only real purpose now is for use when generating Subject Indices. To verify this a Subject Index Prefix should be used that incorporates the date.
- Added Contract Price to Valuation search results.
- Disabled autocomplete for Subject and Report details forms.
- Fixed Report Generator so templates without mergefields do not crash.
- Updated Sale Info popup to show a Not Found message if no Sale data exists.
- Fixed error causing Rating Matrix Item deletion to fail.
- Fixed check so that Subjects with an Effective Unit Size greater than 0 but less than 1 can be valued.
- Added Delete option to Pending and Pending Approval grids on My Valuations page.
- Added Contract Price to Valuation Counts Report grid.
- “Edit Items” and “Edit Ratings” links no longer show when adding a new Rating Matrix.
- Model Evaluations and Subject Valuations should no longer crash if the Model uses a Comparison Value for a Rating or Attribute that doesn’t exist.
- Fixed division-by-zero error when only Land Row has a Ratio of 0.
- Cloning a Subject or Sale with a corrupt or invalid Attachment will copy the file as empty instead of crashing.
- Added Excel export option to Valuation Overrides report.
- Sale Comparisons should be sorted by Rating by default even if not auto-selecting Sales.
- Removed Subject Date field when creating a new Subject.
- Removed Subject Date field from Subject Details form.
- Renamed Report Editor to Template Editor.