Spreadsheet: 784363d1655697434-index-aggregate-need-to-exclude-based-on-criteria-sample1
Sheet: Sheet1

[NAME] | SSN | First Name | Last Name | Carrier | Plan | Type | Enrollment Start Date | Enrollment End Date | Event | Changed Field | Changed On | From | To |  |  | Worksheet Helper 1 | GTL  $50,000|Benefit Amount |  | Active Enrollments
GTL  $50,000|Monthly Plan Cost | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Monthly Plan Cost | 44718.79335648148 |  | $5.60
GTL  $50,000|Benefit Amount | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Benefit Amount | 44718.79335648148 |  | $50,000
GTL  $50,000|Coverage Level | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Coverage Level | 44718.79335648148 |  | Employee
GTL  $50,000|Total Cost | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Total Cost | 44718.79335648148 |  | $0
GTL  $50,000|Employee Per Pay Cost | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Employee Per Pay Cost | 44718.79335648148 |  | $0
GTL  $50,000|Client Per Pay Cost | 1234 | First 1 | Last 1 | PFG | GTL  $50,000 | Current | 2022-08-01 00:00:00 |  | Enrollment changed | Client Per Pay Cost | 44718.79335648148 |  | $2.58
GTL  $50,000|Plan ID | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Plan ID | 44716.01787037037 |  | GTL  $50,000
GTL  $50,000|Coverage Level | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Coverage Level | 44716.01787037037 |  | Employee
GTL  $50,000|Monthly Employee Cost | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Employee Cost | 44716.01787037037 |  | $0
GTL  $50,000|Monthly Plan Cost | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Plan Cost | 44716.01787037037 |  | $3.64
GTL  $50,000|Total Cost | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Total Cost | 44716.01787037037 |  | $0
GTL  $50,000|Benefit Amount | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Benefit Amount | 44716.01787037037 |  | $32,500
GTL  $50,000|Employee Per Pay Cost | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Employee Per Pay Cost | 44716.01787037037 |  | $0
GTL  $50,000|Client Per Pay Cost | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Client Per Pay Cost | 44716.01787037037 |  | $1.68
GTL  $50,000|Start Date | 2345 | First 2 | Last 2 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Start Date | 44716.01787037037 |  | [NAME]
GTL  $50,000|Plan ID | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Plan ID | 44695.32900462963 |  | GTL  $50,000
GTL  $50,000|Coverage Level | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Coverage Level | 44695.32900462963 |  | Employee
GTL  $50,000|Monthly Employee Cost | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Employee Cost | 44695.32900462963 |  | $0
GTL  $50,000|Monthly Plan Cost | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Plan Cost | 44695.32900462963 |  | $5.60
GTL  $50,000|Total Cost | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Total Cost | 44695.32900462963 |  | $0
GTL  $50,000|Benefit Amount | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Benefit Amount | 44695.32900462963 |  | $50,000
GTL  $50,000|Employee Per Pay Cost | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Employee Per Pay Cost | 44695.32900462963 |  | $0
GTL  $50,000|Client Per Pay Cost | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Client Per Pay Cost | 44695.32900462963 |  | $2.58
GTL  $50,000|Start Date | 3456 | First 3 | Last 3 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Start Date | 44695.32900462963 |  | [NAME]
GTL  $50,000|End Date | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | End Date | 44718.60962962963 |  | 05/31/2022
GTL  $50,000|Plan ID | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Plan ID | 44718.60962962963 | --no change-- | GTL  $50,000
GTL  $50,000|Plan ID | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Plan ID | 44716.01788194444 |  | GTL  $50,000
GTL  $50,000|Coverage Level | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Coverage Level | 44716.01788194444 |  | Employee
GTL  $50,000|Monthly Employee Cost | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Monthly Employee Cost | 44716.01788194444 |  | $0
GTL  $50,000|Monthly Plan Cost | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Monthly Plan Cost | 44716.01788194444 |  | $5.60
GTL  $50,000|Total Cost | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Total Cost | 44716.01788194444 |  | $0
GTL  $50,000|Benefit Amount | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Benefit Amount | 44716.01788194444 |  | $50,000
GTL  $50,000|Employee Per Pay Cost | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Employee Per Pay Cost | 44716.01788194444 |  | $0
GTL  $50,000|Client Per Pay Cost | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Client Per Pay Cost | 44716.01788194444 |  | $2.58
GTL  $50,000|Start Date | 4567 | First 5 | Last 5 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 | 2022-05-31 00:00:00 | Enrollment changed | Start Date | 44716.01788194444 |  | [NAME]
GTL  $50,000|Plan ID | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Plan ID | 44704.74751157407 |  | GTL  $50,000
GTL  $50,000|Coverage Level | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Coverage Level | 44704.74751157407 |  | Employee
GTL  $50,000|Monthly Employee Cost | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Employee Cost | 44704.74751157407 |  | $0
GTL  $50,000|Monthly Plan Cost | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Monthly Plan Cost | 44704.74751157407 |  | $5.60
GTL  $50,000|Total Cost | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Total Cost | 44704.74751157407 |  | $0
GTL  $50,000|Benefit Amount | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Benefit Amount | 44704.74751157407 |  | $50,000
GTL  $50,000|Employee Per Pay Cost | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Employee Per Pay Cost | 44704.74751157407 |  | $0
GTL  $50,000|Client Per Pay Cost | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Client Per Pay Cost | 44704.74751157407 |  | $2.58
GTL  $50,000|Start Date | 5678 | First 6 | Last 6 | PFG | GTL  $50,000 | Current | 2022-06-01 00:00:00 |  | Enrollment changed | Start Date | 44704.74751157407 |  | [NAME]