New Workflow System for Based on The R Earth Package

A new workflow for URAR appraisals based on the R/earth version of MARS (Multivariate Adaptive Regression Splines) has been added to our toolset.     

The conversion has added some improvements, such as full automation of the processing of MLS input through submission to earth(), parsing of the R::earth  output to Excel spreadsheets with adjustments, and aggregation of the adjustments to URAR fields per configuration files the user can modify to alter:

  • the fields to be analyzed,
  • the activation of two-way vs. one-way interactions,
  • the variables allowed for two-way interactions when the user chooses that option, and
  • the URAR fields to aggregate the model-specified adjustments.

The automated workflow does significantly speed up the appraisal process and improve the accuracy of the appraisal.

The accuracy improvements come from a more accurate CQA to Residual mapping (or function).  This function,   written in C++, replaces the function generation previously done through Minitab/Salford-Systems MARS.

I used R Studio to develop the new workflow system in R script and C++.  R Studio is also used for execution,  although I plan to create a front end in C# to manage workflow. The system contains about 1500 lines for R script code and 500 lines of C++ code.

The system will generate URAR adjustments for an unlimited number of sales comparables, adjusting all to within 0.00001% of their average. 

I used the variation of the Sales Comparison Approach variously called the

  • Subjective Value Containment Approach (SVCA),
  • Intangible Value Containment Approach (ICVA), or
  • Contribution Value Approach (CVA)

for this workflow.  Of these names, probably the Contribution Value Approach is the most accurate.  Although “Intangible Value Containment Approach” emphasizes the real advantage of the approach, that is, a far more precise term for estimating Market Value.  However,   a downside of this description is that the value captured through the regression residual more accurately contains the value contributions of all variables that did not enter the Stage I regression analysis.  More specifically, some of these variables may be partially tangible, although just unmeasurable for various reasons.   The term CVA or Contribution Value Approach also emphasizes that the calculation of adjustments occurs as a result of first calculating the contribution values of property features, plus a typical basis value.

Basic Software Toolkit for Valuation Engineers

Here is a short list of the main software tools used in my office:

  • MARS
    • Salford Systems MARS ($15,000) or
    • R-Language Earth Package (Free)

  • R-Language – Hundreds of other useful statistics, graphing and related products.
  • Quantum GIS https://www.qgis.org/en/site/ (Free)
  • ArcGIS ($$$)
  •  
  • Chief Architect Home Designer Pro (You can always upgrade to Chief Architect Premium)  (Cost $499)
  •  
  • JetBrains 
    • Rider (C#)
    • PyCharm (Python)
    • CLion (C/C++)
    • Intellij (Java, …)
  • Microsoft Visual Studio (C#, Python, …)
  • PostgresSQL (free)
  • SQL Server (May cost)
  • Oracle MySQL (free)
  • Oracle SQL
  • SQLite (free)
  • MS Word 
  • MS Excel
  • Acrobat DC
  • Photoshop 
  • Also recommend the Adobe Creative Suite Full Package – if you can use the other Adobe products).
  • IrfanView (free) for bulk processing of photos
  • Notepad++
  • 1Password to manage passwords
  • WordPress for websites
Translate »