Spreadsheet: 97264d1296498253-using-max-with-sumifs-example
Sheet: All Data

New Location - Building ID | Full Time HRT1 | Flex/WAH HRT1 | Full Time HRT2 | Flex/WAH HRT2 | [NAME] | Flex/WAH HRNP | Full Time HRNQ | Flex/WAH HRNQ | Building ID | Floor | Workspace ID | Occupant ID | First | Last | GRADE | Occupancy | Associate / Non-Associate | Department ID | Department ID | Department ID | Department Desc. | MBU | SUB MBU | Span Level 3 | Span Level 4 | Span Level 5 | Provide Full-Time Contractor | Provide Full-Time Seat | Space Utilized During Survey Period | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | 8:30 to 9:30 | 9:30 to 10:30 | 10:30 to 11:30 | noon to 1:00 | 1:00 to 2:00 | 2:00 to 3:00 | 3:00 to 4:00 | 4:00 to 5:00 | Space Utilized During Day |  |  |  | Morning Only Use | Lunch Only Use | Afternoon Only Use | Morning & Lunch Use | Morning & Afternoon Use | Morning, Lunch, & Afternoon | Lunch & Afternoon User | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Total % Used | Days in the Office |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL | Morning TOTAL | Lunch TOTAL | Afternoon TOTAL
HRNP |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2057 | AC20400 | [NAME] | Choi | E12 |  | Associate | [NAME] | Decare | 6090021200 | [NAME] and Part D Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1084 | ZAAEU11 | Victor | Cherdsuriya | [NAME] |  | Associate | Victor | 6090031100 | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1087 | AB71621 | [NAME] | Slaven | O17 |  | Associate | [NAME] | 6090031100 | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1104 | AAEU73 | Wanlin | [NAME] | [NAME] |  | Associate | Wanlin | 6090031100 | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1124 | AB30148 | [NAME] | [NAME] | #N/A |  | Associate | [NAME] | 2600055000 | 2600055000 | State Sponsored Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Marko,[NAME] |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1125 | AB89888 | [NAME] | Honey | O17 |  | Associate | [NAME] | 2600055000 | 2600055000 | State Sponsored Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Marko,[NAME] |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1141 | AAEU73 | Wanlin | [NAME] | [NAME] |  | Associate | Wanlin | 6090031100 | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1142 | AA89305 | [NAME] | Murphy | E12 |  | Associate | [NAME] | #N/A | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  | 1 |  | 1 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRCC-C | 1st Floor | C1176 | AB89888 | [NAME] | Honey | O17 |  | Associate | [NAME] | #N/A | 2600055000 | State Sponsored Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Marko,[NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCE-Dental | 1st Floor | 1322 | AA42919 | [NAME] | [NAME] | E15 |  | Associate | [NAME] | 5500897700 | 5500897700 | Specialty Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Oyen,[NAME] | Bremer,Lori J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCE-Dental | 1st Floor | 1339 | AA47054 | Sharlene | Jewell | O16 |  | Associate | Sharlene | 5500897700 | 5500897700 | Specialty Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Oyen,[NAME] | Bremer,Lori J |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRCE-Dental | 1st Floor | 1342 | AA46621 | [NAME] | Loreti | E14 |  | Associate | [NAME] | 5500897700 | 5500897700 | Specialty Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Oyen,[NAME] | Bremer,Lori J |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRCE-Dental | 1st Floor | 1347 | AC14566 | Mallory | [NAME] | O17 |  | Associate | Mallory | 5501700700 | 5500897700 | Specialty Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Oyen,[NAME] | Bremer,Lori J |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2006 | AA30136 | [NAME] | [NAME] | [NAME] |  | Associate | [NAME] | 6090037300 | 6090037300 | West Zone Individual Pricing a | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | BUSCH,FREDERICK S |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2008 | AAIN27 | Yuna | Mindlin | E14 |  | Associate | Yuna | 6090037300 | 6090037300 | West Zone Individual Pricing a | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | BUSCH,FREDERICK S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2013 | AA26524 | [NAME] | [NAME] | E14 |  | Associate | [NAME] | 2600055000 | 2600055000 | State Sponsored Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Marko,[NAME] |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2014 | AA30354 | [NAME] | Margus | E14 |  | Associate | [NAME] | 6090037300 | 6090037300 | West Zone Individual Pricing a | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | BUSCH,FREDERICK S |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2017 | siin008 | [NAME] | Railey | [NAME] |  | Associate | [NAME] | 6090037300 | 6090037300 | West Zone Individual Pricing a | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | BUSCH,FREDERICK S |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2018 | AA27169 | [NAME] | Kuai | [NAME] |  | Associate | [NAME] | 6090037300 | 6090037300 | West Zone Individual Pricing a | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | BUSCH,FREDERICK S |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2054 | AA40080 | Szu-hui | [NAME] | [NAME] |  | Associate | Szu-hui | 5500159800 | 5500159800 | Medicare Advantage | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2055 | AB02637 | Min | Zhang | E12 |  | Associate | Min | 6090021200 | 6090021200 | [NAME] and Part D Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2058 | aain40 | Sean | Donohoe | E14 |  | Associate | Sean | 6090021100 | 6090021100 | Medicare Supp Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2060 | aa08669 | [NAME] | DenHartog | E14 |  | Associate | [NAME] | 5500159800 | 5500159800 | Medicare Advantage | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2062 | AA43520 | [NAME] | Wang | E12 |  | Associate | [NAME] | 6090021200 | 6090021200 | [NAME] and Part D Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  | 1 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2064 | AB70992 | Christine | [NAME] | E12 |  | Associate | Christine | 6090031100 | 6090031100 | Senior and State Sponsored Hea | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | Hanson,Kurt D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2065 | AB20346 | [NAME] | Zhang | E15 |  | Associate | [NAME] | 6090031400 | 6090031400 | Med Strategies, Ops & Integrat | CHIEF ACTUARIAL OFFICER | HEALTH SERVICES | SEAMAN,[NAME] R | GILL,V TAYLOR | [NAME],[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2067 | AAGP44 | Luba | Neymit | E15 |  | Associate | Luba | 6090021200 | 6090021200 | [NAME] and Part D Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 2075 | aa53408 | Rajesh | [NAME] | E12 |  | Associate | Rajesh | 6090021100 | 6090021100 | Medicare Supp Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 | 1
HRT1 |  |  |  |  |  |  |  |  | HRT1 | 2nd Floor | 02E141S39 | AAEU19 | Grace | Kiang | M16 |  | Associate | Grace | 6090021200 | 6090021200 | [NAME] and Part D Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] | Kiang,[NAME] |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2004 | AA63700 | Wei | [NAME] | E12 |  | Associate | Wei | 6030622000 | 6030622000 | CA Commercial Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | [NAME],[NAME] | [NAME],[NAME] |  |  |  | 1 | 1 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2005 | AAGP07 | [NAME] | Wang | E12 |  | Associate | [NAME] | 6030622000 | 6030622000 | CA Commercial Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | [NAME],[NAME] | [NAME],[NAME] |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2011 | AA39269 | Rong | [NAME] | [NAME] |  | Associate | Rong | 6030622000 | 6030622000 | CA Commercial Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | [NAME],[NAME] | [NAME],[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2012 | ZAAEU04 | Grigoriy | Makarov | [NAME] |  | Associate | Grigoriy | 6090037500 | 6090037500 | Commercial Bus Info Systems | CHIEF ACTUARIAL OFFICER | ADVANCED ANALYTICS & INNOVATIO | SEAMAN,[NAME] R | FEARRINGTON JR,RICHARD D | FLATTO,GRETCHEN A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2015 | ZAAEU24 | Zhao | Sun | E14 |  | Associate | Zhao | 6090037400 | 6090037400 | Consumer and Enterprise Bus In | CHIEF ACTUARIAL OFFICER | ADVANCED ANALYTICS & INNOVATIO | SEAMAN,[NAME] R | FEARRINGTON JR,RICHARD D | Worley,[NAME] |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRNQ | 2nd Floor | 2021 | AAIN05 | [NAME] | Cole | E15 |  | Associate | [NAME] | 6030622000 | 6030622000 | CA Commercial Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | [NAME],[NAME] | [NAME],[NAME] |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 1045 | AB92152 | [NAME] | Kotnik | M15 |  | Associate | [NAME] | 6090037500 | 6090037500 | Commercial Bus Info Systems | CHIEF ACTUARIAL OFFICER | ADVANCED ANALYTICS & INNOVATIO | SEAMAN,[NAME] R | FEARRINGTON JR,RICHARD D | FLATTO,GRETCHEN A |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 1049 | AAEU48 | Christine | Valdez | E14 |  | Associate | Christine | 6030622000 | 6030622000 | CA Commercial Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | [NAME],[NAME] | [NAME],[NAME] |  |  |  | 1 | 1 | 1 |  |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 1167 | AAGP85 | [NAME] | Baumann | E15 |  | Associate | [NAME] | 6090037900 | 6090037900 | Commercial Forecasting and [NAME] | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | DENO,[NAME] | Norbutt,[NAME] A |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 1169 | AA27134 | Carol | [NAME] | E12 |  | Associate | Carol | 6090037600 | 6090037600 | Experience Analysis | CHIEF ACTUARIAL OFFICER | ADVANCED ANALYTICS & INNOVATIO | SEAMAN,[NAME] R | FEARRINGTON JR,RICHARD D | LAUDENSCHLAGER,CARMEN L
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 1179 | ZGOSP08 | Marti | [NAME] | O16 |  | Associate | Marti | 6090021000 | 6090021000 | VP Consumer Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
HRT2 |  |  |  |  |  |  |  |  | HRT2 | 1st Floor | 01E117S130 | AB72321 | [NAME] | Shane | X14 |  | Associate | [NAME] | 6090021000 | 6090021000 | VP Consumer Pricing | CHIEF ACTUARIAL OFFICER | PRICING | SEAMAN,[NAME] R | Shane,[NAME] |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  | 1