Mass Appraisal Tables – Averages Option
Specification
Averages are used to provide a single value based on the average of multiple entries.
Can be setup for Land Adjustments and Buildings Rate and Cama adjustments
See also Links Options
Setup
Averages are setup with the first entry in the group.
For instance, Sequence 100, 200 and 300 should be averaged.
- Sequence 200 will be set to average and linked to 100.
- Sequence 300 will be set to average and linked to 100.
Example
Example A – Land Adjustment Averages – Amount
The following land adjustment tables (a) are used to create a Land Adjustment Matrix
Sequence | Table | Column | Description | |||
810 | QUALAVG | A_01 | Quality 1 of 3 | |||
812 | QUALAVG | A_02 | Quality 2 of 3 | |||
814 | QUALAVG | A_03 | Quality 3 of 3 |
In this example, the same quality average table is used. Sequence 814 is linked to 810 and 812 is linked with 810.
Quality #1 Math = ‘+’ / Amount |
Quality #2 Math = ‘+’ Amount |
Quality #3 Math = ‘+’ / Amount |
||
A=50000 B=25000 C=10000 |
A=50000 B=25000 C=10000 |
A=50000 B=25000 C=10000 |
The result = 50,000 + 25,000 + 10,000 = 85,000
85,000 / 3 = 28,333.33 rounded to 28, 334.
Computation
Average Calculation
Click here for the complete Land Value or Building Value Computation page.
Land
We perform the average calculation of MA_LAND.(MA_TABLES.COLUMN_NAME)_AM by selecting all MA_TABLES.LANDADJT_AVG = -1
The average is performed and stored on the column pointed by MA_TABLES_LAND.ADJT_POINTER based on the number of entries.. All the other columns are set to NULL.
Example: MA_TABLES has 5 land adjustment rates and MA_LAND has the following values
MA_LAND.ADJ10_AM = 7
MA_LAND.ADJ20_AM = 5
MA_LAND.ADJ30_AM = 8.5
MA_LAND.ADJ40_AM = 3
MA_LAND.ADJ50_AM = 9.5
COMPUTATION_SEQ | COLUMN_NAME | LANDADJT_AVG | LANDADJT_POINTER
10 ADJ10 NULL NULL
20 ADJ20 -1 10
30 ADJ30 NULL NULL
40 ADJ40 -1 10
50 ADJ50 -1 30
Average is calculated as (7+5+3)/3 = 5 so the result will be stored in MA_LAND.ADJ10_AM
Average is calculated as (8.5+9.5)/2 = 9 so the result will be stored in MA_LAND.ADJ30_AM
After this step the values are
MA_LAND.ADJ10_AM = 5, MA_LAND.ADJ20_AM = NULL, MA_LAND.ADJ30_AM = 9, MA_LAND.ADJ40_AM = NULL, MA_LAND.ADJ50_AM = NULL
103-ma-parm-Tables-Averages