Spreadsheet: 702716d1604502036-returning-the-latest-status-example-2
Sheet: Master Service Id - KOSMOS

Service ID | DTL-Invoice line item | [NAME] service start date | [NAME] service end date | dtl - service status
805335145 |  | 2019-08-14 00:00:00 |  | Active
805335414 |  | 2019-01-28 00:00:00 |  | Active
805337155 |  | 2019-08-06 00:00:00 |  | #MULTIVALUE
805434849 |  | 2019-02-15 00:00:00 |  | Active
805434953 |  | 2019-02-15 00:00:00 |  | Active
805436141 |  | 2019-06-10 00:00:00 |  | Active
805436297 |  | 2019-06-10 00:00:00 |  | Active
805436767 |  | 2020-01-20 00:00:00 |  | Active
805437331 |  | 2019-08-13 00:00:00 |  | #MULTIVALUE
805437704 |  | 2019-02-18 00:00:00 |  | Active
805437706 |  | 2019-02-18 00:00:00 |  | Active
805437812 |  | 2019-01-10 00:00:00 | 2019-01-10 00:00:00 | Ceased
805437817 |  | 2019-08-13 00:00:00 |  | #MULTIVALUE
805437894 |  | 2019-02-18 00:00:00 |  | Active
805438011
805438069 |  | 2020-06-04 00:00:00 |  | Active
805438250 |  | 2019-02-18 00:00:00 |  | Active
805438264 |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Ceased
805438280 |  | 2019-02-18 00:00:00 |  | Active
805438513 |  | 2019-02-18 00:00:00 |  | Active
805438558 |  | 2018-12-28 00:00:00 | 2018-12-28 00:00:00 | Ceased
805438767 |  | 2019-02-18 00:00:00 |  | Active
805438772 |  | 2019-08-07 00:00:00 |  | #MULTIVALUE
805438932 |  | 2019-02-18 00:00:00 |  | Active
805441339 |  | 2019-02-18 00:00:00 |  | Active
805441419 |  | 2019-02-18 00:00:00 |  | Active
805441421 |  | 2019-05-28 00:00:00 |  | Active
805441430 |  | 2019-02-15 00:00:00 |  | Active
805441668 |  | 2019-05-22 00:00:00 |  | Active
805441684 |  | 2019-02-15 00:00:00 |  | Active
805441806 |  | 2019-05-28 00:00:00 |  | Active
805444802 |  | 2019-05-28 00:00:00 |  | Active
805445238 |  | 2019-05-28 00:00:00 |  | Active
805445947 |  | 2019-08-14 00:00:00 |  | Active
805446700 |  | 2019-08-14 00:00:00 |  | Active
805446790 |  | 2019-02-18 00:00:00 |  | Active
805449353 |  | 2020-06-09 00:00:00 |  | Active
805450189 |  | 2019-04-08 00:00:00 |  | Active
805453386 |  | 2020-06-11 00:00:00 |  | Active
805453901 |  | 2019-08-14 00:00:00 |  | Active
805454661 |  | 2019-06-13 00:00:00 |  | Active
805454665 |  | 2019-06-13 00:00:00 |  | Active
805454736 |  | 2019-01-16 00:00:00 | 2019-01-16 00:00:00 | Ceased
805454751 |  | 2019-02-18 00:00:00 |  | Active
805455051 |  | 2019-06-13 00:00:00 |  | Active
805455168 |  | 2019-08-14 00:00:00 |  | #MULTIVALUE
805455453 |  | 2019-06-13 00:00:00 |  | Active
805455507 |  | 2019-06-17 00:00:00 |  | Active
805455911 |  | 2019-06-17 00:00:00 |  | Active
805612910 |  | 2019-08-13 00:00:00 |  | Active
805613648 |  | 2019-08-14 00:00:00 |  | #MULTIVALUE
805613684 |  | 2019-08-13 00:00:00 |  | Active
805613773 |  | 2019-01-15 00:00:00 | 2019-01-15 00:00:00 | Ceased
805613782 |  | 2019-02-18 00:00:00 |  | Active
805613845 |  | 2019-09-17 00:00:00 |  | Active
805614221 |  | 2020-07-13 00:00:00 |  | Active
805614343 |  | 2020-09-23 00:00:00 |  | Active
805614465 |  | 2019-04-05 00:00:00 |  | Active
805614522 |  | 2019-08-16 00:00:00 |  | #MULTIVALUE
805614912 |  | 2019-04-24 00:00:00 |  | Active
805615070 |  | 2019-01-15 00:00:00 | 2019-01-15 00:00:00 | Ceased
805624678 |  | 2019-02-18 00:00:00 |  | Active
805625303 |  | 2019-02-18 00:00:00 |  | Active
805626626 |  | 2019-08-14 00:00:00 |  | Active
805626873 |  | 2019-02-18 00:00:00 |  | Active
805627838 |  | 2019-02-19 00:00:00 |  | Active
AXS004215729
AXS1498126 |  | 2020-06-09 00:00:00 |  | Active
AXS3693649 |  | 2020-06-10 00:00:00 |  | Active
CPE004215730
CPE1500771 |  | 2019-02-19 00:00:00 |  | Active
CPE1501916 |  | 2020-01-20 00:00:00 |  | Active
CPE1502868 |  | 2020-07-03 00:00:00 |  | #MULTIVALUE
[NAME] |  | 2019-02-18 00:00:00 |  | Active
CPE1506108 |  | 2020-07-03 00:00:00 |  | Active
CPE1506370 |  | 2020-05-29 00:00:00 |  | Active
CPE1509751 |  | 2019-02-15 00:00:00 |  | Active
CPE1509761 |  | 2019-05-22 00:00:00 |  | Active
CPE1512023 |  | 2019-02-15 00:00:00 |  | Active
CPE1513186 |  | 2019-02-18 00:00:00 |  | Active
CPE1513203 |  | 2019-09-17 00:00:00 |  | Active
CPE1515421 |  | 2020-01-20 00:00:00 |  | Active
CPE1515424 |  | 2020-01-20 00:00:00 |  | Active
CPE1516563 |  | 2019-06-24 00:00:00 |  | Active
CPE1517483 |  | 2019-05-28 00:00:00 |  | Active
CPE1517736 |  | 2019-02-15 00:00:00 |  | Active
CPE1517753 |  | 2019-02-18 00:00:00 |  | Active
CPE1517767 |  | 2019-02-15 00:00:00 |  | Active
CPE1519402 |  | 2019-02-18 00:00:00 |  | Active
CPE1519403 |  | 2019-02-15 00:00:00 |  | Active
CPE1519438 |  | 2019-02-14 00:00:00 |  | Active
CPE1519832 |  | 2020-06-01 00:00:00 |  | Active
CPE1519834 |  | 2019-02-18 00:00:00 |  | Active
CPE1520835 |  | 2019-02-18 00:00:00 |  | Active
CPE1520837 |  | 2019-02-15 00:00:00 |  | Active
CPE1520839 |  | 2019-10-16 00:00:00 |  | Active
CPE1520842 |  | 2019-02-14 00:00:00 |  | Active
CPE1520853 |  | 2019-02-14 00:00:00 |  | Active
CPE1521537 |  | 2019-05-28 00:00:00 |  | Active
CPE3695114 |  | 2019-02-19 00:00:00 |  | Active
CPE4277140
CPE4278708
IA000304494 |  | 2020-03-12 00:00:00 |  | Active
IA005414995 |  | 2020-01-21 00:00:00 |  | Active
IPVPN004210392
IPVPN004210393
IPVPN004215693
IPVPN004221613
IPVPN005403798
IPVPN005419486
IPVPNQ000001947 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000027932 |  | 2019-08-20 00:00:00 |  | Active
IPVPNQ000034405 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000041013 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000041048 |  | 2020-01-20 00:00:00 |  | Active
IPVPNQ000041050 |  | 2020-01-20 00:00:00 |  | Active
IPVPNQ000041050
IPVPNQ000046409 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000061794
IPVPNQ000065633 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000086925 |  | 2020-06-01 00:00:00 |  | Active
IPVPNQ000086925
IPVPNQ000088671 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000089250 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000098300 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000099212
IPVPNQ000101316 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000105622 |  | 2019-08-20 00:00:00 |  | Active
IPVPNQ000108132 |  | 2019-02-15 00:00:00 |  | Active
IPVPNQ000109179 |  | 2020-07-03 00:00:00 |  | Active
IPVPNQ000109271 |  | 2020-07-03 00:00:00 |  | #MULTIVALUE
IPVPNQ000111331 |  | 2020-01-23 00:00:00 |  | Active
IPVPNQ000111331
IPVPNQ000120545 |  | 2020-09-23 00:00:00 |  | Active
IPVPNQ000120901
IPVPNQ000120918
IPVPNQ000120963
IPVPNQ000120985
IPVPNQ000120996 |  | 2019-06-24 00:00:00 |  | Active
IPVPNQ000121003 |  | 2019-06-24 00:00:00 |  | Active
IPVPNQ000121038
IPVPNQ000121048
IPVPNQ000121072
IPVPNQ000122747 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000128406 |  | 2019-12-27 00:00:00 |  | Active
IPVPNQ000128406
IPVPNQ000131117 |  | 2020-01-20 00:00:00 |  | Active
IPVPNQ000131123 |  | 2019-02-14 00:00:00 |  | Active
IPVPNQ000131139 |  | 2019-02-14 00:00:00 |  | Active
IPVPNQ000131156 |  | 2020-01-20 00:00:00 |  | Active
IPVPNQ000132696 |  | 2020-05-29 00:00:00 |  | Active
IPVPNQ000133864
IPVPNQ000133865 |  | 2020-05-30 00:00:00 |  | Active
IPVPNQ000133868 |  | 2020-05-30 00:00:00 |  | Active
IPVPNQ000141339 |  | 2020-01-25 00:00:00 |  | Active
IPVPNQ000141347
IPVPNQ000141425
IPVPNQ000141854 |  | 2020-01-28 00:00:00 |  | Active
IPVPNQ000144712 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000147153 |  | 2019-02-19 00:00:00 |  | Active
IPVPNQ000160225 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000160751 |  | 2019-02-18 00:00:00 |  | Active
IPVPNQ000160751
IPVPNQ000193430 |  | 2020-05-19 00:00:00 |  | #MULTIVALUE
IPVPNQ000198665 |  | 2020-09-23 00:00:00 |  | Active
IPVPNQ000200532 |  | 2019-04-03 00:00:00 |  | Active
IPVPNQ000205797 |  | 2020-06-05 00:00:00 |  | Active
IPVPNQ000214899 |  | 2020-05-19 00:00:00 |  | #MULTIVALUE
IPVPNQ000214899.
IPVPNQ000218102 |  | 2020-07-25 00:00:00 |  | #MULTIVALUE
IPVPNQ000226015 |  | 2020-06-15 00:00:00 |  | #MULTIVALUE
IPVPNQ000226028 |  | 2020-06-12 00:00:00 |  | #MULTIVALUE
IPVPNQ000228907 |  | 2020-06-15 00:00:00 |  | #MULTIVALUE
IPVPNQ000229586 |  | 2020-05-29 00:00:00 |  | Active
IPVPNQ000251526 |  | 2020-07-01 00:00:00 |  | #MULTIVALUE
IPVPNQ000253970 |  | 2020-06-12 00:00:00 |  | #MULTIVALUE
IPVPNQ000282907 |  | 2020-06-08 00:00:00 |  | Active
IPVPNQ000291247 |  | 2020-02-27 00:00:00 |  | Active
IPVPNQ000918793 |  | 2020-02-05 00:00:00 |  | Active
IPVPNQ000922711 |  | 2019-08-02 00:00:00 |  | Active
IPVPNQ000927741 |  | 2019-02-06 00:00:00 |  | Active
IPVPNQ004215144 |  | 2019-04-12 00:00:00 |  | Active
IPVPNQ004215176 |  | 2019-04-12 00:00:00 |  | Active
IPVPNQ004222700 |  | 2019-06-20 00:00:00 |  | Active
MSPDAB000034416 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000041184 |  | 2020-01-20 00:00:00 |  | Active
MSPDAB000041185 |  | 2020-01-20 00:00:00 |  | Active
MSPDAB000046620
MSPDAB000046641 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000046668 |  | 2019-03-18 00:00:00 |  | Active
MSPDAB000073672 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000087118 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000089088 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000089587 |  | 2019-02-19 00:00:00 |  | Active
[NAME] |  | 2020-06-12 00:00:00 |  | #MULTIVALUE
MSPDAB000098332 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000101455 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000107659 |  | 2020-07-03 00:00:00 |  | #MULTIVALUE
MSPDAB000108272 |  | 2019-02-15 00:00:00 |  | Active
MSPDAB000109195 |  | 2020-07-03 00:00:00 |  | Active
MSPDAB000109240 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000109275 |  | 2020-07-03 00:00:00 |  | #MULTIVALUE
MSPDAB000122315 |  | 2019-06-24 00:00:00 |  | Active
MSPDAB000122835 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000128672 |  | 2019-12-27 00:00:00 |  | Active
MSPDAB000133088 |  | 2020-05-29 00:00:00 |  | Active
MSPDAB000145236 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000145236
MSPDAB000147511 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000147511
MSPDAB000160499 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000161181 |  | 2019-02-18 00:00:00 |  | Active
MSPDAB000193819 |  | 2020-05-19 00:00:00 |  | #MULTIVALUE
MSPDAB000206692 |  | 2019-02-19 00:00:00 |  | Active
MSPDAB000226296 |  | 2020-06-12 00:00:00 |  | #MULTIVALUE
MSPDAB000226297 |  | 2020-06-15 00:00:00 |  | #MULTIVALUE
MSPDAB000229344 |  | 2020-06-15 00:00:00 |  | #MULTIVALUE
MSPDAB000251549 |  | 2020-07-01 00:00:00 |  | #MULTIVALUE
MSPDAB000253978 |  | 2020-06-12 00:00:00 |  | #MULTIVALUE
MSPSAB000131706 |  | 2020-01-20 00:00:00 |  | Active
MSPSAB000131724 |  | 2019-02-14 00:00:00 |  | Active
MSPSAB000133159 |  | 2019-02-14 00:00:00 |  | Active
MSPSAB000161672 |  | 2019-02-15 00:00:00 |  | Active
MSPSAB000270588 |  | 2019-02-15 00:00:00 |  | Active
MSPSAB000271340
MSPSAB000271362 |  | 2019-09-17 00:00:00 |  | Active
MSPSAB000271824 |  | 2019-02-18 00:00:00 |  | Active
MSPSAB000271905 |  | 2019-02-15 00:00:00 |  | Active
MSPSAB000272176 |  | 2019-02-14 00:00:00 |  | Active
MSPSAB000273091 |  | 2019-02-19 00:00:00 |  | Active
MSPSAB000274501 |  | 2019-02-18 00:00:00 |  | Active
MSPSAB000278577 |  | 2019-02-18 00:00:00 |  | Active
MSPSAB000282927 |  | 2019-02-19 00:00:00 |  | Active
MSPSAB000291264 |  | 2019-02-19 00:00:00 |  | Active
MSPSAB000293656 |  | 2019-02-15 00:00:00 |  | Active
MSPSAB000293860 |  | 2019-02-18 00:00:00 |  | Active
MSPSAB000294300 |  | 2019-02-18 00:00:00 |  | Active
[NAME] |  | 2019-06-24 00:00:00 |  | Active
MSPSAB000300149 |  | 2019-02-18 00:00:00 |  | Active
MSPSAB000304736 |  | 2019-07-22 00:00:00 |  | Active
MSPSAB000923233 |  | 2019-02-19 00:00:00 |  | Active
MSPSAB000923248 |  | 2019-02-19 00:00:00 |  | Active
MSPSAB005415003 |  | 2020-01-21 00:00:00 |  | Active
N/A
SPGC/458733/0056 |  | 2019-04-10 00:00:00 |  | Active
SPGC/458733/0058 |  | 2019-08-06 00:00:00 |  | Active
SPGC/458733/0081 |  | 2019-08-02 00:00:00 |  | Active
SPGC/458733/0082 |  | 2019-05-03 00:00:00 |  | Active
SPGC/458733/0083 |  | 2019-02-18 00:00:00 |  | Active
SPGC/458733/0084 |  | 2018-12-20 00:00:00 | 2018-12-20 00:00:00 | Ceased
SPGC/458733/0085
SPGC/458733/0089 |  | 2019-05-22 00:00:00 |  | Active
SPGC/458733/0090
SPGC/458733/0091 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0099 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0100 |  | 2019-02-18 00:00:00 |  | Active
SPGC/458733/0103
SPGC/458733/0107 |  | 2019-07-22 00:00:00 |  | Active
SPGC/458733/0109 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0110 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0117 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0125
SPGC/458733/0128 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0131 |  | 2020-10-21 00:00:00 |  | Active
SPGC/458733/0142 |  | 2019-02-14 00:00:00 |  | Active
SPGC/458733/0151 |  | 2020-06-23 00:00:00 |  | Active
SPGC/458733/0160
SPGC/458733/0165 |  | 2019-02-14 00:00:00 |  | Active
SPGC/458733/0166 |  | 2019-02-18 00:00:00 |  | Active
SPGC/458733/0168 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0169 |  | 2019-07-19 00:00:00 |  | Active
[NAME]
SPGC/458733/0171 |  | 2019-02-15 00:00:00 |  | Active
SPGC/458733/0178 |  | 2019-02-18 00:00:00 |  | Active
[NAME] |  | 2019-02-18 00:00:00 |  | Active
SPGC/458733/0200 |  | 2020-06-01 00:00:00 |  | Active
SPGC/458733/0221 |  | 2019-02-18 00:00:00 |  | Active
SPGC/458733/0256 |  | 2020-09-22 00:00:00 |  | Active
SPGC/458733/0269 |  | 2019-02-14 00:00:00 |  | Active
SPGC/473814/0303 |  | 2020-09-23 00:00:00 |  | Active