| Foreclosure
Auction Greatbridge Auction Analysis System |
| System
Components |
|
| Build
Tables.xls xxxxxxxxxxxxxx |
Concatenates
APNs, imported into the table 1 tab ( T1) from the Trustee List for an auction date into strings of 15 APNs to reduce querying to mlx. Accumulated mlx property characteristic data is imported into table 2 tab (T2) and tables 1 and 2 are integrated in T1&2. |
| Daily Master.xls |
Values from Build Tables.xls tab
T1&2 are pasted into a Daily Master list file for further analysis
and for integration with Master List.xls |
| Master
List.xls |
Daily
Master Lists are pasted into the master list in which Table 3 (comp
data) and table 4 (mortgage history data) is entered. Records in
Master List are purged as properties sell or are cancelled or
whatever. Records for sales that are postponed are saved until
the postponement date. |
| Update.xls |
After
the auction, the trustee list for an auction date is downloaded from
Nevada Legal News and imported into update. A Macro in Master
List.xls creates a new column A in that file which displayse the status
reschedule date of any parcels for which a status is found in
Update.xls (See Update Procedure) |
| Comp
Work.xls |
CompWork.xls
display information from MasterList for any selected APN. Tab 3
displays information required for comping and allows entry of Table 4
data (mortgage history). Up to 25 comp records that are imported
into the Import tab of CompWork are displayed in the data entry
screen and all data from the screen is stored in MasterFile.xls
by the Save Procedure. Tab T4 displays data about any selected parcel and allows entry or editing of tabe 4 (mortgage history) data which is stored in MasterFile.xls by the save procedure. |
|
|
- Wednessday to Wednessday schedule
Wishful thinking stage
- Grandfather Master file on a CD. Maintain one CD for each day of the week.
- Purge closed sales from Master list using Update.xls
- Add any new daily listings, being sure to delete from the daily listing, records for parcels that already exist in Master File
- Open Print.xls, enter date of auction and print
the three reports.
- Excel import
- File Linking
- control keys