Spreadsheet: 790087d1659533106-formula-to-lookup-and-display-next-in-line-match-template2-1-
Sheet: AION

Account Name |  | AION PARTNERS LLC
 |  |  |  |  |  |  |  |  |  | Account Contacts
Acc Number in Admin: |  |  |  |  | Total Communities |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Phone Number |  |  |  |  | Total Current Unit Count |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Date Created |  |  |  |  |  |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
PMS System |  |  |  |  |  |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Products |  |  |  |  |  |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Policy Number |  |  |  |  |  |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Current Policy Dates |  |  |  |  |  |  |  |  |  | Name |  | Phone Number |  | [NAME] |  |  | Title
Current Status/Notes
 |  |  |  |  |  |  |  |  |  | Elite Endorsement
 |  |  |  |  |  |  |  |  |  | Carrier | Policy Dates | Payout Amount
Communities
Community | Community ID | Total Units | Regional Manager | Phone Number | Address | City | State | Zip | Integration Software | Property Code | Coverage | Premium Only | Policy Fee | Stamping Fee | Premium | Admin Fee | Tax Rate | [NAME] | [NAME] | Admin Fee LeaseTerm | Director Commission | CoDirector Commission | Brokerage | Tax State | Product
 | 8399 | 210 |  |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Aspen Court | 4010 | 413 | Kimberly Price |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 10413 | 96 | Region |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Bethlehem Townhomes | 4094 | 122 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Bethlehem Townhomes II | 5118 | 147 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Chatham On Main | 9354 | 119 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] Towers | 3593 | 434 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 9598 | 404 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Chesterfield Flats | 10208 | 278 |  |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Cosmopolitan Apartments | 3960 | 149 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 9854 | 71 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 2985 | 246 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Franklin Commons | 2986 | 703 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Greenspring Apartments | 3594 | 276 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Harborstone | 5200 | 296 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Have New Providence | 9767 | 232 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Hickory Point | 6844 | 175 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Holly Court | 2987 | 188 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 3014 | 680 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 3137 | 156 | Ronni Groenthal | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 10207 | 538 | Katia Singletary |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Joralemon Street | 2988 | 62 | Kimberly Price | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Landmark At Glenmont Station | 4260 | 625 | [NAME] | (301) 605-9783 |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 2990 | 220 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] B | 6694 | 24 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 3015 | 136 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Mariner's Pointe | 10041 | 466 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Metal Works | 9960 | 56 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 3656 | 493 | Ronni Groenthal | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Orchard Park | 2993 | 282 | Kimberly Price | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Overlook at Flanders | 2994 | 1224 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc at Cherry Hill | 8471 | 176 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc at Lyndhurst | 9730 | 161 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc at Maplewood | 7443 | 50 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc at Roxbury | 8038 | 230 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc at Summit | 4556 | 57 | Kimberly Price | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Parc At West Point | 9471 | 250 | Regional | (215) 699-9225 |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Pointe at River City | 9337 | 1184 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Reserves at Tidewater | 8591 | 640 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
River Oaks | 8401 | 111 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
River Pointe | 2991 | 211 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
SilverLake | 8037 | 232 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Springhouse Townhomes | 10408 | 34 |  |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Stonegate Apartments | 4259 | 260 | Ronni Groenthal | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Terminal 21 | 9599 | 205 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Addison | 10034 | 598 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Alden | 3072 | 1050 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Brunswick | 6845 | 200 | Kimberly Price | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The [NAME] | 4170 | 25 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Commons | 8035 | 92 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Flats at Columbia Pike | 5648 | 529 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The George | 7147 | 220 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Meridian North | 7148 | 478 |  |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Meridian South | 7149 | 728 |  |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The [NAME] | 7096 | 148 |  | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Nolan | 7442 | 80 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The [NAME] | 8031 | 420 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The View North Hills | 8033 | 436 | [NAME] |  |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
The Woodlands | 3138 | 404 | Kimberly Price | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Townhomes at Stoneybrook | 9442 | 52 | Katrina Richter | (717) 755-5700 |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Valley Park | 3001 | 276 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Wellington Apartments | 3177 | 150 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
Yorkshire | 5199 | 326 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll
[NAME] | 4187 | 144 | [NAME] | [PHONE] |  |  |  |  |  |  | 300000 | 10.19 | 0 | 0 | 10.19 | 3.5 | 0.03 | 0 | 0.75 | 0.25 | 0.018 | 0.002 | 0 | PA | Auto Enroll