AgWare ClickForms Form Help

If Land Residual is picked then the math will calculate Sales Indication minus Land CV to calculate the Improvement CV. 

This will also require the Land CV to be entered, unless the appraiser has picked an SCA page that already has the Land CV split out.

If Improvement Residual is selected (the other non-visible option), then the subtraction will work the other way (Indication - Improvement CV = Land CV

When the Import Values button is clicked we will import values (if a form with the context numbers exists,  that will automatically get transferred to this form)

If Land Residual is selected then SalesComparisonApproach_Indication - SalesComparisonApproach_LandCV = SalesComparisonApproach_ImprovementCV

If Improvement Residual selected then SalesComparisonApproach_Indication - SalesComparisonApproach_ImprovementCV   = SalesComparisonApproach_LandCV

Below shows the calculations based on if Improvement Residual or Land Residual is selected.

"Use Sales as Reported" combo in the Component Allocation (Top) area:

 This combo actually affects both the Subject Land Allocation (SLA) and the Subject Improvement Allocation (SIA) sections. There are 5 options:

1. Use Sales -- if this is selected,  the numbers from the Sales CV columns in both SLA  and SIA sections are automatically transferred to the $/Acre and Reported Value columns respectively.
2. Use Cost --if this is selected,  the numbers from the Cost CV columns in both SLA  and SIA sections are automatically transferred to the $/Acre and Reported Value columns respectively.
3. Use Allocation -- if this is selected,  No numbers are changed unless the Allocate with Ratios button is Pressed.
4. Manual -- Don't transfer or try to sync anything up between the lists. Appraisers can manually enter and use the Sum and Difference and modify them as needed.

The "Allocate with Ratios" button under the Land Residual Combobox will allocate the $/Acre Value for the SLA Table based on the Use Sales/Use Cost drop down menu.

If Use Sales is selected then by pressing the Allocate with Ratios button will calculate the $/Acre Value based on the entered ratios and Allocating the Land CV Value  from Sales Comparison Approach across the rows.

If Use Cost is selected then by pressing the Allocate with Ratios button will calculate the $/Acre Value based on the entered ratios and  Allocating the Land CV Value from Cost Approach across the rows.

If Use Allocations is selected then by pressing the Allocate with Ratios button will calculate the $/Acre Value based on the entered ratios and Allocation the Land Contribution Reported Value from the Allocations area of the form (bottom).

Value from the Allocations area of the form (bottom).

SUBJECT LAND ALLOCATION (SLA)

The order that the math will be calculated for the Subject Land Allocation Area is as follows:

1. If Unit Size and $/Unit are numeric than the Reported Value = Unit Size * $/Unit
2. Otherwise the Acres * $/Acre will be entered into the Reported Value
3. The sum of Reported Value is placed into the Sum column for Land Contribution in the Allocations area (bottom)

Formula to calculate  the $/Acre when Allocate with Ratios button is pressed:

1. Use Allocations is selected: Row 1(Acres * $/Acre) + Row 2(Acres * $/Acre) + …. = Reported Land Contribution
2. Use Sales is selected: Row 1(Acres * $/Acre) + Row 2(Acres * $/Acre) + … = Sales Comparison Approach Land CV value
3. Use Cost is selected: Row 1(Acres * $/Acre) + Row 2(Acres * $/Acre) + … = Cost Approach Land CV value

Subject Improvement Allocation (SIA)

If Allocate Proportional button is pressed:

       1. First will look at which value is selected from the drop down menu above

               a. Manual : Does not change any values

               b. Use Allocations: Will use the values in Cost CV first then if not present will use Sales CV to determine ratio

                       i. Will then use that ratio to calculate the Reported Value using the Allocations Improvement Contribution Reported Value as the total that is allocated against.

               c. Use Sales: Will use the values in Sales CV to determine ratio

                       i. Will then use that ratio to calculate the Reported Value using the Sales Comparison Approach Improvement CV Value as the total that is allocated against.

               d. Use Cost:  Will use the values in Cost CV to determine ratio

                       i. Will then use that ratio to calculate the Reported Value using the Cost Approach Improvement CV Value as the total that is allocated against.

If you have questions or need assistance, please don't hesitate to contact us.