1. pull data a. bld number b. bld name c. bld type d. all comments e. bld cost f. sq ft g. insurance? and overwrite? 2. add standards a. district number b. assessment status "not complete" c. mark for deletion "no" d. round sq ft to 0 decimals 3. add historical a. add live GDB structure layer to table b. create shapefile copy c. based on date of construction, determine original year d. select where year < (current year - 49) e. select by location using current selection f. calculate "historical" as "yes" 4. add ADA a. add live GDB structure layer to table b. select where "accessible" = "y" e. select by location using current selection f. calculate "accessible" as "yes" 6. add replacement a. add joinable replacement/sq ft cost b. join on building type c. select types with per unit replacement d. calculate cost e. select types with per sq ft replacement f. calculate cost (per sq ft * sq ft) g. round to 0 decimals h. don't worry about adding multipliers? that's reference table in qlik? what about any calculations in AGO? complicated arcade i suppose... 7. add insurance a. add joinable insurance table to project b. join on building number c. calculate insurance d. calculate interior insurance