Spreadsheet: 795887d1662990702-remove-matches-example-spreadsheet
Sheet: Sheet2

Exchange Assigned Subscriber ID | Issuer Assigned Policy ID | Last Name | First Name | Exchange Assigned QHP ID | Policy Total Premium Amount | APTC Transaction Amount | Member Responsibility Amount | Coverage Period Start Date | Coverage Period End Date | APTC Transaction Post Date | Unique ID | PPR Payment Amount | MR | PPR Payment + MR | Policy Premium Total
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220201 | 20220228 | 1/6/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220301 | 20220331 | 2/3/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220401 | 20220430 | 3/3/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220501 | 20220531 | 4/5/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220601 | 20220630 | 5/3/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220701 | 20220731 | 6/3/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1049 | 111111111 | Oneal | Shaq | 87416WI003004701 | 415.37 | 170 | 245.37 | 20220801 | 20220831 | 7/5/2022 | 1.04920220201202e+19 | 170 | 245.37 | 415.37 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220101 | 20220131 | 11/25/2021 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220201 | 20220228 | 1/6/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220301 | 20220331 | 2/3/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220401 | 20220430 | 3/3/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220501 | 20220531 | 4/5/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220601 | 20220630 | 5/3/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220701 | 20220731 | 6/3/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1052 | 2222222222 | [NAME] | [NAME] | 87416WI003004706 | 785.71 | 750 | 35.71 | 20220801 | 20220831 | 7/5/2022 | 1.05220220101202e+19 | 750 | 35.71000000000004 | 785.71 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | 842.99 | 842.99 | 0 | 20220101 | 20220131 | 12/4/2021 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | 842.99 | 842.99 | 0 | 20220201 | 20220228 | 1/6/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | 842.99 | 842.99 | 0 | 20220301 | 20220331 | 2/3/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | 842.99 | 842.99 | 0 | 20220401 | 20220430 | 3/3/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | -842.99 | -842.99 | 0 | 20220401 | 20220430 | 5/12/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | False
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | 842.99 | 842.99 | 0 | 20220501 | 20220531 | 4/5/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | True
1096 | 3333333333 | Jordan | [NAME] | 87416WI003003101 | -842.99 | -842.99 | 0 | 20220501 | 20220531 | 5/12/2022 | 1.09620220101202e+19 | 842.99 | 0 | 842.99 | False
1210 | 4444444444 | Patton | General | 87416WI003002701 | 628.85 | 625 | 3.85 | 20220101 | 20220131 | 12/7/2021 | 1.21020220101202e+19 | 625 | 3.850000000000023 | 628.85 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220301 | 20220331 | 2/3/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220401 | 20220430 | 3/3/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220501 | 20220531 | 4/5/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220601 | 20220630 | 5/3/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220701 | 20220731 | 6/3/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True
1210 | 4444444444 | Patton | General | 87416WI003004706 | 732.93 | 732.93 | 0 | 20220801 | 20220831 | 7/5/2022 | 1.21020220101202e+19 | 732.93 | 0 | 732.93 | True