{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DT NR Plots","DT LTE Plots (anchored)","DT NR Histogram","Analyze report description","Report log","WorkSheetHistograme to be hiden"],"not_rendered":{"charts":8,"images":21,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DT NR Plots","index":0,"n_rows":82,"n_cols":27,"rows_kept":82,"cut":false,"hidden":false,"merged":[[53,0,53,10],[53,13,53,23],[53,26,53,36],[81,0,81,10],[81,13,81,23],[81,26,81,36],[1,0,1,10],[1,13,1,23],[1,26,1,36],[27,0,27,10],[27,13,27,23],[27,26,27,36]]}
[]
["NR PCI",null,null,null,null,null,null,null,null,null,null,null,null,"NR SS-RSRP",null,null,null,null,null,null,null,null,null,null,null,null,"NR SS-RSRQ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NR SS-SINR",null,null,null,null,null,null,null,null,null,null,null,null,"NR DL Throughput",null,null,null,null,null,null,null,null,null,null,null,null,"NR MULTI RAT DL Throughput"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NR RI",null,null,null,null,null,null,null,null,null,null,null,null,"Serving Cell NR ARFCN DL",null,null,null,null,null,null,null,null,null,null,null,null,"NR MODULATION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NR UL Throughput",null,null,null,null,null,null,null,null,null,null,null,null,"Tx power PUSCH plot ",null,null,null,null,null,null,null,null,null,null,null,null,"Beam Index plot DL"]

{"sheet":"DT LTE Plots (anchored)","index":1,"n_rows":55,"n_cols":27,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,0,54,10],[54,13,54,23],[1,0,1,10],[1,13,1,23],[1,26,1,36],[27,0,27,10],[27,13,27,23],[27,26,27,36]]}
[]
["PCI",null,null,null,null,null,null,null,null,null,null,null,null,"RSRP",null,null,null,null,null,null,null,null,null,null,null,null,"RSRQ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SINR",null,null,null,null,null,null,null,null,null,null,null,null," RI",null,null,null,null,null,null,null,null,null,null,null,null," CQI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["EARFCN",null,null,null,null,null,null,null,null,null,null,null,null," MODULATION"]

{"sheet":"DT NR Histogram","index":2,"n_rows":314,"n_cols":15,"rows_kept":314,"cut":false,"hidden":false,"merged":[[1,0,1,14],[21,0,21,14],[44,0,44,14],[66,0,66,13]]}
[]
["NR SS-RSRP"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:43",-86.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:43",-86.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:44",-87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:44",-87.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:45",-86.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:45",-86.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:46",-87.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:47",-89.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:47",-88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:48",-85.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:48",-84.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:49",-83.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:49",-87.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:50",-86.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:50",-84.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:51",-88.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:51",-90]
["NR SS-RSRQ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:52",-89.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:53",-89.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:53",-89.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:54",-76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:55",-79.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:55",-87.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:56",-92.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:56",-87.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:57",-86.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:57",-86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:58",-85.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:58",-84.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:59",-82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:40:59",-79.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:00",-77.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:00",-76.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:01",-73.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:01",-72.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:02",-68.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:02",-70.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:03",-70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:03",-69.599998474121094]
["NR SS-SINR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:04",-73.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:05",-74.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:05",-80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:06",-78.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:06",-77.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:07",-80.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:07",-78.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:08",-80.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:08",-80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:09",-79.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:09",-83.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:10",-84.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:10",-87.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:11",-86.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:11",-85.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:12",-87.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:12",-88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:13",-88.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:13",-89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:14",-93.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:14",-91.900001525878906]
[" DL Throughput",null,null,null,null,null,null,null,null,null,null,null,null,null,-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:15",-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:16",-92.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:16",-94.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:17",-94.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:17",-95.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:18",-93.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:18",-93.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:19",-93.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:19",-92.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:20",-92.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:20",-90.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:21",-87.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:21",-86.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:22",-88.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:22",-90.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:23",-88.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:23",-85.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:24",-85.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:24",-87.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:25",-87.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:25",-81.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:26",-85.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:26",-85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:27",-84.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:27",-86.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:28",-86.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:28",-85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:29",-83.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:30",-79.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:30",-73.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:31",-75.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:31",-79.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:32",-81.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:32",-82.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:33",-80.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:33",-78.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:34",-76.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:34",-75.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:35",-72.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:35",-69.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:36",-65.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:36",-62.799999237060547]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:37",-65.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:37",-68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:38",-67.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:38",-66.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:39",-66.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:39",-68.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:40",-73.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:40",-74.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:41",-71.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:41",-72.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:42",-76.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:42",-83.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:43",-88.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:43",-90.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:44",-91.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:44",-92.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:45",-91.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:45",-89.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:46",-84.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:46",-82.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:47",-87.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:47",-85.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:48",-83.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:48",-83.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:49",-79.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:49",-80.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:50",-80.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:50",-80.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:51",-78.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:51",-72.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:52",-70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:52",-70.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:53",-73.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:53",-78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:54",-80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:54",-83.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:55",-85.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:55",-84.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:56",-86.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:56",-87.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:57",-88.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:57",-91.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:58",-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:58",-91.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:59",-93.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:41:59",-91.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:00",-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:00",-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:01",-90.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:01",-91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:02",-91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:02",-90.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:03",-93.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:03",-92.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:04",-89.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:04",-89.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:05",-87.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:05",-89.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:06",-92.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:07",-91.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:07",-88.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:08",-88.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:08",-89.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:09",-88.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:09",-90.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:10",-91.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:10",-91.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:11",-93.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:11",-94.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:12",-94.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:12",-94.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:13",-93.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:13",-91.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:14",-92.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:14",-93.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:15",-92.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:15",-91.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:16",-90.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:16",-91.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:17",-91.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:17",-93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:18",-94.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:18",-96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:19",-94.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:19",-93.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:20",-91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:20",-91.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:21",-89.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:21",-88.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:22",-88.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:22",-88.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:23",-90]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:23",-86.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:24",-87.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:24",-89.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:25",-89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:25",-89.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:26",-89.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:26",-91.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:27",-91.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:27",-89.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:28",-89.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:28",-89.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:29",-90.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:29",-88.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:30",-84.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:30",-85.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:31",-85.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:31",-84.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:32",-84.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:32",-80.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:33",-80.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:33",-82.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:34",-85.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:34",-85.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:35",-85.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:35",-85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:36",-83.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:36",-83.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:37",-84.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:37",-84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:38",-80.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:38",-79.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:39",-78.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:39",-82.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:40",-85.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:40",-83.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:41",-77.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:41",-78.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:42",-81.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:42",-81.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:43",-81.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:43",-81.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:44",-81.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:44",-78.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:45",-78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:45",-72.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:46",-71.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:46",-77.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:47",-77.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:47",-79.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:48",-81.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:48",-77.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:49",-76.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:49",-80.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:50",-78.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:51",-80.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:51",-78.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:52",-80.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:52",-83.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:53",-82.699996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:53",-82.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:54",-83.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:54",-78.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:55",-80.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:55",-83.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:56",-83.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:56",-81.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:57",-78.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:57",-79.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:58",-80.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:58",-79.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:59",-82.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:42:59",-82.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:00",-81.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:00",-83.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:01",-79.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:01",-82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:02",-83.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:02",-82.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:03",-81.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:03",-84.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:04",-81.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:04",-80.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:05",-83.199996948242188]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:05",-82.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:06",-86.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:06",-84.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:07",-82.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:07",-79.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:08",-76.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:08",-79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:09",-79.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:09",-79.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:10",-73.099998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:10",-67.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:11",-63.799999237060547]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:11",-68.599998474121094]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:12",-72.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:12",-76.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:13",-78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:13",-79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:14",-79.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:14",-80.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:15",-83.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:15",-83.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:16",-86.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:16",-87.300003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:17",-87.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:17",-86.800003051757813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:18",-86.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:18",-86.400001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:19",-88.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:19",-90.900001525878906]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"01:43:20",-90]

{"sheet":"Analyze report description","index":3,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Query","<query sheet=\"WorkSheetHistograme to be hiden\" row=\"1\" column=\"0\"><column_settings><column name=\"lower_bound\" title=\"lower_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"upper_bound\" title=\"upper_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"cumulation\" title=\"cumulation\" type=\"double\" format=\"0.0##\" /><column name=\"cumulation_sampled\" title=\"cumulation_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"density\" title=\"density\" type=\"double\" format=\"0.0##\" /><column name=\"density_sampled\" title=\"density_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"group\" title=\"group\" type=\"string\" /></column_settings></query>","<parameter device=\"0\" filter_level=\"2\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_rsrp\" title=\"SS-RSRP Nth best\" color_set=\"RSRP (dBm)\" description=\"SS-RSRP of the Nth strongest cell/beam\" query_title=\"RSRP {?N}. best\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= -80\" /><ColorsetLabel id=\"2\" label=\"&gt;= -90 and &lt; -80\" /><ColorsetLabel id=\"3\" label=\"&gt;= -100 and &lt; -90\" /><ColorsetLabel id=\"4\" label=\"&gt;= -110 and &lt; -100\" /><ColorsetLabel id=\"5\" label=\"&gt;= -130 and &lt; -110\" /><ColorsetLabel id=\"6\" label=\"&lt; -130\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, 'select * from Nemo.SCRIPT(&lt;#39:1&gt;nemo.analyze.kpi.QueryWithTimeBasedEventBlocks&lt;#39:1&gt;,&lt;#39:1&gt;\" postfix=\"&lt;#39:1&gt;) as (&quot;the_event&quot; bigint,&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;          &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;          &quot;gps_longitude&quot; double precision,&#xD;&#xA;          &quot;gps_latitude&quot; double precision,&#xD;&#xA;          &quot;gps_height&quot; smallint,&#xD;&#xA;          &quot;_exclude_sql_time&quot; timestamp,&#xD;&#xA;          _exclude_time_interval bigint,&#xD;&#xA;          &quot;the_device&quot; bigint&#xD;&#xA;          {!qsr_output_columns} )') &#xD;&#xA;        as (&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;        &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;        &quot;gps_longitude&quot; double precision,&#xD;&#xA;        &quot;gps_latitude&quot; double precision,&#xD;&#xA;        &quot;gps_height&quot; smallint,&#xD;&#xA;        &quot;_exclude_sql_time&quot; timestamp without time zone,&#xD;&#xA;        _exclude_time_interval bigint, &#xD;&#xA;        &quot;the_device&quot; bigint&#xD;&#xA;        {!qsr_output_columns} )\" tail=\"{!columns}, sql_time, time_interval {!procedure_qsr_columns}  FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type}  AND x.file_id = {!file} {!procedure_filter}  &lt;#39:1&gt;, &lt;#39:1&gt;&lt;#39:1&gt;, &lt;#39:1&gt;\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"{?N}. best RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:2&gt;cellular_system_band_int&lt;#39:2&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"((nr_pci)::text || &lt;#39:2&gt;_&lt;#39:2&gt; || (nr_beam_index)::text)\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best RSRP\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best RSRP\" value_parameter=\"nr_rp\" direction=\"up\" min=\"-140\" max=\"-35\" interval=\"10\" threshold=\"-90\" condition=\"&lt;\" default_action=\"folder, measurement\" selected_type=\"qsr\" colorset_name=\"RSRP (dBm)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -80 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -90 AND &quot;{!kpi column}&quot; &lt; -80 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -100 AND &quot;{!kpi column}&quot; &lt; -90 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -110 AND &quot;{!kpi column}&quot; &lt; -100 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -130 AND &quot;{!kpi column}&quot; &lt; -110 THEN 5&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -130 THEN 6&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter>"]
["Query","<query sheet=\"WorkSheetHistograme to be hiden\" row=\"1\" column=\"9\"><column_settings><column name=\"lower_bound\" title=\"lower_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"upper_bound\" title=\"upper_bound\" type=\"string\" format=\"0\" horizontal_align=\"right\" /><column name=\"cumulation\" title=\"cumulation\" type=\"double\" format=\"0\" /><column name=\"cumulation_sampled\" title=\"cumulation_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"density\" title=\"density\" type=\"double\" format=\"0.0##\" /><column name=\"density_sampled\" title=\"density_sampled\" type=\"double\" format=\"0\" /><column name=\"group\" title=\"group\" type=\"string\" /></column_settings></query>","<parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_rsrq\" title=\"SS-RSRQ Nth best\" color_set=\"RSRQ (dB)\" description=\"Nth best SS-RSRQ. N prompted at time of executing the query. Note that the sorting (N) is based on SS-RSRP.\" query_title=\"RSRQ {?N}. best\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= -5\" /><ColorsetLabel id=\"2\" label=\"&lt; -5 and &gt;= -10\" /><ColorsetLabel id=\"3\" label=\"&lt; -10 and &gt;= -15\" /><ColorsetLabel id=\"4\" label=\"&lt; -15 and &gt;= -20\" /><ColorsetLabel id=\"5\" label=\"&lt; -20\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\"') as (&quot;{?N}. best RSRQ&quot; real,&quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&quot;the_parent&quot; bigint,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}&#xD;&#xA;                FROM Nemo.NR_CELLMEAS_Cell_ x &#xD;&#xA;                WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type}  AND x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"&quot;nr_rq&quot;\" output_name=\"{?N}. best RSRQ\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:1&gt;cellular_system_band_int&lt;#39:1&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"(nr_pci)::text || &lt;#39:1&gt;_&lt;#39:1&gt; || (nr_beam_index)::text\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"&quot;the_parent&quot; AS &quot;the_parent&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Bar X\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Bar X sub\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Group by\" column=\"_oid\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best RSRQ\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best RSRQ\" value_parameter=\"nr_rq\" direction=\"up\" min=\"-30\" max=\"0\" interval=\"2\" threshold=\"-20\" condition=\"&lt;\" default_action=\"folder, measurement\" selected_type=\"qsr\" colorset_name=\"RSRQ (dB)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -5 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -5 AND &quot;{!kpi column}&quot; &gt;= -10 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -10 AND &quot;{!kpi column}&quot; &gt;= -15 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -15 AND &quot;{!kpi column}&quot; &gt;= -20 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -20 THEN 5&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter>"]
["Query","<query sheet=\"WorkSheetHistograme to be hiden\" row=\"1\" column=\"17\"><column_settings><column name=\"lower_bound\" title=\"lower_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"upper_bound\" title=\"upper_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"cumulation\" title=\"cumulation\" type=\"double\" format=\"0.0##\" /><column name=\"cumulation_sampled\" title=\"cumulation_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"density\" title=\"density\" type=\"double\" format=\"0.0##\" /><column name=\"density_sampled\" title=\"density_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"group\" title=\"group\" type=\"string\" /></column_settings></query>","<parameter device=\"mobile\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_sinr_nth_best\" title=\"SS-SINR Nth best\" color_set=\"SINR (dB)\" description=\"Nth best SS-SINR. N prompted at time of executing the query. Note that the sorting (N) is based on SS-RSRP.\" query_title=\"SS-SINR {?N}. best\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= 30\" /><ColorsetLabel id=\"2\" label=\"&gt;= 25 and &lt; 30\" /><ColorsetLabel id=\"3\" label=\"&gt;= 20 and &lt; 25\" /><ColorsetLabel id=\"4\" label=\"&gt;= 15 and &lt; 20\" /><ColorsetLabel id=\"5\" label=\"&gt;= 10 and &lt; 15\" /><ColorsetLabel id=\"6\" label=\"&gt;= 5 and &lt; 10\" /><ColorsetLabel id=\"7\" label=\"&gt;= 0 and &lt; 5\" /><ColorsetLabel id=\"8\" label=\"&gt;= -10 and &lt; 0\" /><ColorsetLabel id=\"9\" label=\"&lt; -10\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\"') as (&quot;{?N}. best SS-RSRP&quot; real,&quot;{?N}. best SS-SINR&quot; real,&quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}&#xD;&#xA;                FROM Nemo.NR_CELLMEAS_Cell_ &#xD;&#xA;                WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type} AND nr_sinr IS NOT NULL  AND file_id = {!file} {!procedure_filter}\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"{?N}. best SS-RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"nr_sinr\" output_name=\"{?N}. best SS-SINR\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:1&gt;cellular_system_band_int&lt;#39:1&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"(nr_pci)::text || &lt;#39:1&gt;_&lt;#39:1&gt; || (nr_beam_index)::text\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Bar X sub\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Bar X\" column=\"nr_beam_index\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Print value\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best SS-SINR\" value_parameter=\"nr_sinr\" direction=\"up\" min=\"-30\" max=\"40\" interval=\"10\" threshold=\"20\" condition=\"&lt;\" default_action=\"folder, measurement\" selected_type=\"qsr\" colorset_name=\"SINR (dB)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 30 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 25 AND &quot;{!kpi column}&quot; &lt; 30 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 20 AND &quot;{!kpi column}&quot; &lt; 25 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 15 AND &quot;{!kpi column}&quot; &lt; 20 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 10 AND &quot;{!kpi column}&quot; &lt; 15 THEN 5&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 5 AND &quot;{!kpi column}&quot; &lt; 10 THEN 6&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 0 AND &quot;{!kpi column}&quot; &lt; 5 THEN 7&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= -10 AND &quot;{!kpi column}&quot; &lt; 0 THEN 8&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; -10 THEN 9&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter>"]
["Query","<query sheet=\"WorkSheetHistograme to be hiden\" row=\"1\" column=\"25\"><column_settings><column name=\"lower_bound\" title=\"lower_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"upper_bound\" title=\"upper_bound\" type=\"string\" format=\"0.0##\" horizontal_align=\"right\" /><column name=\"cumulation\" title=\"cumulation\" type=\"double\" format=\"0.0##\" /><column name=\"cumulation_sampled\" title=\"cumulation_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"density\" title=\"density\" type=\"double\" format=\"0.0##\" /><column name=\"density_sampled\" title=\"density_sampled\" type=\"double\" format=\"0.0##\" /><column name=\"group\" title=\"group\" type=\"string\" /></column_settings></query>","<parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"lte_nr_total_mac_dl_bit_rate\" title=\"LTE + 5G MAC DL throughput total\" color_set=\"Throughput (0-1Gbps)\" description=\"Total MAC DL throughput\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= 1G\" /><ColorsetLabel id=\"2\" label=\"&gt;= 500M and &lt; 1G\" /><ColorsetLabel id=\"3\" label=\"&gt;= 200M and &lt; 500M\" /><ColorsetLabel id=\"4\" label=\"&gt;= 100M and &lt; 200M\" /><ColorsetLabel id=\"5\" label=\"&gt;= 20M and &lt; 100M\" /><ColorsetLabel id=\"6\" label=\"&lt; 20M\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /><group name=\"LTE\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"select * from Nemo.SCRIPT('nemo.analyze.kpi.Query_2_Sum','SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as &quot;Interval&quot;,                  SUM(CAST(lte_mac_dl_bit_rate as double precision)) as &quot;lte_mac_dl_bit_rate&quot;,                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order {!procedure_qsr_columns}                  FROM Nemo.LTE_MACRATE_ x                  WHERE 0 = 0  AND x.file_id = {!file} {!filter}                  GROUP BY sql_time  ,x.lr_id ORDER BY _exclude_order   ,x.lr_id ;SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as &quot;Interval&quot;,                  SUM(CAST(nr_mac_dl_bit_rate as double precision)) as &quot;nr_mac_dl_bit_rate&quot;,                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order {!procedure_qsr_columns}                  FROM Nemo.NR_MACRATE_ x                  WHERE 0 = 0 AND x.file_id = {!file}  {!filter}                  GROUP BY sql_time ,x.lr_id  ORDER BY _exclude_order  ,x.lr_id  ;Interval:1;GROUP_BY:sql_time,time,gps_longitude,gps_latitude,gps_height;add:lte_mac_dl_bit_rate,nr_mac_dl_bit_rate,lte_mac_dl_bit_rate_total;qsr:{!procedure_qsr_columns}','{!procedure_filter}','file_id={!file}') as (&quot;sql_time&quot; timestamp,&quot;time&quot; bytea,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint,&quot;lte_mac_dl_bit_rate&quot; double precision,&quot;nr_mac_dl_bit_rate&quot; double precision   {!qsr_output_columns}  ,&quot;lte_mac_dl_bit_rate_total&quot; double precision)\"><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"sql_time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /></aliases></sql><qsr value_column=\"lte_mac_dl_bit_rate_total\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"200000000\" interval=\"10000000\" threshold=\"100000000\" condition=\"&lt;\" default_action=\"folder, measurement\" selected_type=\"qsr\" colorset_name=\"Throughput (0-1Gbps)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 1000000000 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 500000000 AND &quot;{!kpi column}&quot; &lt; 1000000000 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 200000000 AND &quot;{!kpi column}&quot; &lt; 500000000 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 100000000 AND &quot;{!kpi column}&quot; &lt; 200000000 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 20000000 AND &quot;{!kpi column}&quot; &lt; 100000000 THEN 5&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; 20000000 THEN 6&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"MIN(to_interval(time)) AS qsr_duration\" /><option type=\"distance\" duration_column=\"MIN(distance_interval) AS qsr_duration\" /><option type=\"sample\" duration_column=\"MIN(1) AS qsr_duration\" /></qsr></parameter>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"2\" left=\"0\" top=\"40.266666666666666\" width=\"747.42414951324463\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"Physical cell identity;\" aspect=\"Stretch\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_pci\" SplitMapColumnCaption=\"Physical cell identity\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_pci\" SplitMapColumnCaptionH=\"Physical cell identity\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"0\" SnapRowBottom=\"25\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"2\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT NR Plots\" row=\"0\" column=\"0\"><column_settings><column name=\"nr_rp\" title=\"RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"mobile\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_nr_ss_pci_nth_best_selected_carrier\" title=\"PCI Nth best selected carrier\" system=\"NR;LTE FDD;LTE TDD\" color_set=\"Physical cell identity\" description=\"Physical Cell Identity of the best SS Block Reference beam measured based on SS-RSRP among all SS Block beams of all cells of selected carrier.\" query_title=\"PCI {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\" order by lr_id ') as (&quot;nr_rp&quot; real,&quot;time&quot; bytea,&quot;nr_pci&quot; smallint,&quot;nr_arfcn&quot; integer,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}  FROM Nemo.NR_CELLMEAS_Cell_ WHERE nr_rp IS NOT NULL AND nr_arfcn {?Carrier number} AND nr_meas_type = 1  AND file_id = {!file} {!procedure_filter}\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Print value\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"Carrier number\" sql=\"select * from Nemo.ONE_AND_ONLY('Nemo','NR_CELLMEAS_Cell','nr_arfcn','{!file1}') as (nr_arfcn integer)\" default=\"&gt; 0\" /></parameters></sql><qsr value_column=\"qsr_duration\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"100\" interval=\"0\" threshold=\"50\" condition=\"&lt;\" default_action=\"folder, measurement\" statistics=\"count\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"5\" left=\"883.31944942474354\" top=\"40.266666666666666\" width=\"747.42414951324474\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"RSRP_(dBm);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_arfcn\" SplitMapColumnCaption=\"NR-ARFCN\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_arfcn\" SplitMapColumnCaptionH=\"NR-ARFCN\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"13\" SnapRowBottom=\"25\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best &lt; 1000 RSRP\" title=\"1. best &lt; 1000 RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"Band (MHz)\" title=\"Band (MHz)\" type=\"int32\" format=\"0\" /><column name=\"NR PCI Beam index\" title=\"NR PCI Beam index\" type=\"string\" /><column name=\"_oid\" title=\"_oid\" type=\"int64\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_selected_cell_type_rsrp\" title=\"SS-RSRP Nth best selected cell type\" system=\"NR;LTE FDD;LTE TDD\" color_set=\"RSRP (dBm)\" description=\"SS-RSRP of the Nth strongest cell/beam of selected cell type\" query_title=\"RSRP {?N}. {?Cell type}\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\" order by x.lr_id ') &#xD;&#xA;&#x9;&#x9;&#x9;&#x9;as &#xD;&#xA;&#x9;&#x9;&#x9;&#x9;(&quot;{?N}. best {?Cell type} RSRP&quot; real,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;time&quot; bytea,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;nr_arfcn&quot; integer,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;nr_pci&quot; smallint,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;nr_beam_index&quot; smallint,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;nr_beam_type&quot; integer,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;Band&quot; text,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;Band (MHz)&quot; integer,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;NR PCI Beam index&quot; text,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;_oid&quot; bigint,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;gps_longitude&quot; double precision,&#xD;&#xA;&#x9;&#x9;&#x9;&#x9;&quot;gps_latitude&quot; double precision {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns} FROM Nemo.NR_CELLMEAS_Cell_ x WHERE  nr_meas_type = 1 AND &quot;nr_cell_type&quot; {?Cell type}  AND x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"&quot;nr_rp&quot;\" output_name=\"{?N}. best {?Cell type} RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:1&gt;cellular_system_band_int&lt;#39:1&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"(nr_pci)::text || &lt;#39:1&gt;_&lt;#39:1&gt; || (nr_beam_index)::text\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best {?Cell type} RSRP\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best {?Cell type} RSRP\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best {?Cell type} RSRP\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best {?Cell type} RSRP\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best {?Cell type} RSRP\" quotes=\"true\" /><alias name=\"Group by\" column=\"_oid\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"Cell type\" default=\"All\"><value text=\"PCell\" enum=\"= 0\" /><value text=\"SCell 1\" enum=\"= 1\" /><value text=\"SCell 2\" enum=\"= 2\" /><value text=\"SCell 3\" enum=\"= 3\" /><value text=\"SCell 4\" enum=\"= 4\" /><value text=\"SCell 5\" enum=\"= 5\" /><value text=\"SCell 6\" enum=\"= 6\" /><value text=\"SCell 7\" enum=\"= 7\" /><value text=\"SCell 8\" enum=\"= 8\" /><value text=\"SCell 9\" enum=\"= 9\" /><value text=\"SCell 10\" enum=\"= 10\" /><value text=\"SCell 11\" enum=\"= 11\" /><value text=\"SCell 12\" enum=\"= 12\" /><value text=\"SCell 13\" enum=\"= 13\" /><value text=\"SCell 14\" enum=\"= 14\" /><value text=\"SCell 15\" enum=\"= 15\" /><value text=\"SCell 16\" enum=\"= 16\" /><value text=\"SCell 17\" enum=\"= 17\" /><value text=\"SCell 18\" enum=\"= 18\" /><value text=\"SCell 19\" enum=\"= 19\" /><value text=\"SCell 20\" enum=\"= 20\" /><value text=\"SCell 21\" enum=\"= 21\" /><value text=\"SCell 22\" enum=\"= 22\" /><value text=\"SCell 23\" enum=\"= 23\" /><value text=\"SCell 24\" enum=\"= 24\" /><value text=\"SCell 25\" enum=\"= 25\" /><value text=\"SCell 26\" enum=\"= 26\" /><value text=\"SCell 27\" enum=\"= 27\" /><value text=\"SCell 28\" enum=\"= 28\" /><value text=\"SCell 29\" enum=\"= 29\" /><value text=\"SCell 30\" enum=\"= 30\" /><value text=\"SCell 31\" enum=\"= 31\" /><value text=\"SCG PSCell\" enum=\"= 199\" /><value text=\"SCG SCell 0\" enum=\"= 100\" /><value text=\"SCG SCell 1\" enum=\"= 101\" /><value text=\"SCG SCell 2\" enum=\"= 102\" /><value text=\"SCG SCell 3\" enum=\"= 103\" /><value text=\"SCG SCell 4\" enum=\"= 104\" /><value text=\"SCG SCell 5\" enum=\"= 105\" /><value text=\"SCG SCell 6\" enum=\"= 106\" /><value text=\"SCG SCell 7\" enum=\"= 107\" /><value text=\"SCG SCell 8\" enum=\"= 108\" /><value text=\"SCG SCell 9\" enum=\"= 109\" /><value text=\"SCG SCell 10\" enum=\"= 110\" /><value text=\"SCG SCell 11\" enum=\"= 111\" /><value text=\"SCG SCell 12\" enum=\"= 112\" /><value text=\"SCG SCell 13\" enum=\"= 113\" /><value text=\"SCG SCell 14\" enum=\"= 114\" /><value text=\"SCG SCell 15\" enum=\"= 115\" /><value text=\"SCG SCell 16\" enum=\"= 116\" /><value text=\"SCG SCell 17\" enum=\"= 117\" /><value text=\"SCG SCell 18\" enum=\"= 118\" /><value text=\"SCG SCell 19\" enum=\"= 119\" /><value text=\"SCG SCell 20\" enum=\"= 120\" /><value text=\"SCG SCell 21\" enum=\"= 121\" /><value text=\"SCG SCell 22\" enum=\"= 122\" /><value text=\"SCG SCell 23\" enum=\"= 123\" /><value text=\"SCG SCell 24\" enum=\"= 124\" /><value text=\"SCG SCell 25\" enum=\"= 125\" /><value text=\"SCG SCell 26\" enum=\"= 126\" /><value text=\"SCG SCell 27\" enum=\"= 127\" /><value text=\"SCG SCell 28\" enum=\"= 128\" /><value text=\"SCG SCell 29\" enum=\"= 129\" /><value text=\"SCG SCell 30\" enum=\"= 130\" /><value text=\"SCG SCell 31\" enum=\"= 131\" /><value text=\"SCG SCell\" enum=\"= 198\" /><value text=\"Listed or detected\" enum=\"= 1000\" /><value text=\"Listed\" enum=\"= 1001\" /><value text=\"Detected\" enum=\"= 1002\" /><value text=\"All\" enum=\"&lt; 1000\" /></parameter><parameter id=\"N\" default=\"1\" /></parameters></sql><qsr value_column=\"{?N}. best {?Cell type} RSRP\" value_parameter=\"nr_rp\" direction=\"up\" min=\"-140\" max=\"-35\" interval=\"10\" threshold=\"-90\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"6\" left=\"1766.6388988494871\" top=\"40.266666666666666\" width=\"747.42414951324463\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"RSRQ (dB);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_arfcn\" SplitMapColumnCaption=\"NR-ARFCN\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_arfcn\" SplitMapColumnCaptionH=\"NR-ARFCN\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"26\" SnapRowBottom=\"25\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best RSRQ\" title=\"1. best RSRQ\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"Band (MHz)\" title=\"Band (MHz)\" type=\"int32\" format=\"0\" /><column name=\"NR PCI Beam index\" title=\"NR PCI Beam index\" type=\"string\" /><column name=\"_oid\" title=\"_oid\" type=\"int64\" format=\"0\" /><column name=\"the_parent\" title=\"the_parent\" type=\"int64\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_rsrq\" title=\"SS-RSRQ Nth best\" system=\"NR;LTE FDD;LTE TDD\" color_set=\"RSRQ (dB)\" description=\"Nth best SS-RSRQ. N prompted at time of executing the query. Note that the sorting (N) is based on SS-RSRP.\" query_title=\"RSRQ {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\"') as (&quot;{?N}. best RSRQ&quot; real,&quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&quot;the_parent&quot; bigint,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}&#xD;&#xA;                FROM Nemo.NR_CELLMEAS_Cell_ x &#xD;&#xA;                WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type}  AND x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"&quot;nr_rq&quot;\" output_name=\"{?N}. best RSRQ\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:1&gt;cellular_system_band_int&lt;#39:1&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"(nr_pci)::text || &lt;#39:1&gt;_&lt;#39:1&gt; || (nr_beam_index)::text\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"&quot;the_parent&quot; AS &quot;the_parent&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Bar X\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Bar X sub\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Group by\" column=\"_oid\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best RSRQ\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best RSRQ\" value_parameter=\"nr_rq\" direction=\"up\" min=\"-30\" max=\"0\" interval=\"2\" threshold=\"-20\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"7\" left=\"0\" top=\"563.73333333333335\" width=\"747.42414951324463\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"SINR (dB);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_pci\" SplitMapColumnCaption=\"Physical cell identity\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_pci\" SplitMapColumnCaptionH=\"Physical cell identity\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"0\" SnapRowBottom=\"51\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best SS-RSRP\" title=\"1. best SS-RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"1. best SS-SINR\" title=\"1. best SS-SINR\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"Band (MHz)\" title=\"Band (MHz)\" type=\"int32\" format=\"0\" /><column name=\"NR PCI Beam index\" title=\"NR PCI Beam index\" type=\"string\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /></column_settings><parameter device=\"mobile\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_sinr_nth_best\" title=\"SS-SINR Nth best\" system=\"NR;LTE FDD;LTE TDD\" color_set=\"SINR (dB)\" description=\"Nth best SS-SINR. N prompted at time of executing the query. Note that the sorting (N) is based on SS-RSRP.\" query_title=\"SS-SINR {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\"') as (&quot;{?N}. best SS-RSRP&quot; real,&quot;{?N}. best SS-SINR&quot; real,&quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}&#xD;&#xA;                FROM Nemo.NR_CELLMEAS_Cell_ &#xD;&#xA;                WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type} AND nr_sinr IS NOT NULL  AND file_id = {!file} {!procedure_filter}\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"{?N}. best SS-RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"nr_sinr\" output_name=\"{?N}. best SS-SINR\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:1&gt;cellular_system_band_int&lt;#39:1&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"(nr_pci)::text || &lt;#39:1&gt;_&lt;#39:1&gt; || (nr_beam_index)::text\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Bar X sub\" column=\"nr_pci\" quotes=\"true\" /><alias name=\"Bar X\" column=\"nr_beam_index\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Print value\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best SS-SINR\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best SS-SINR\" value_parameter=\"nr_sinr\" direction=\"up\" min=\"-30\" max=\"40\" interval=\"10\" threshold=\"20\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"8\" left=\"883.31944942474354\" top=\"563.73333333333335\" width=\"747.42414951324474\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"Throughput (0-50Mbps);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_serving_cell_type\" SplitMapColumnCaption=\"Serving cell type\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_serving_cell_type\" SplitMapColumnCaptionH=\"Serving cell type\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"13\" SnapRowBottom=\"51\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"2\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_mac_dl_bit_rate\" title=\"MAC DL bitrate\" type=\"double\" format=\"0.0##\" /><column name=\"nr_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_mac_dl_bit_rate\" title=\"MAC DL throughput (5G)\" color_set=\"Throughput (0-200Mbps)\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= 15M\" /><ColorsetLabel id=\"2\" label=\"&gt;= 10M and &lt; 15M\" /><ColorsetLabel id=\"3\" label=\"&gt;= 5M and &lt; 10M\" /><ColorsetLabel id=\"4\" label=\"&gt;= 1M and &lt; 5M\" /><ColorsetLabel id=\"5\" label=\"&gt;= 500K and &lt; 1M\" /><ColorsetLabel id=\"6\" label=\"&lt; 500K\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G;MAC\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_MACRATE_ x WHERE (nr_serving_cell_type {?NR serving cell type})  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"CAST(nr_mac_dl_bit_rate as double precision)\" output_name=\"nr_mac_dl_bit_rate\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"nr_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_mac_dl_bit_rate\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_mac_dl_bit_rate\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_mac_dl_bit_rate\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"nr_mac_dl_bit_rate\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_serving_cell_type\" quotes=\"true\" /><alias name=\"3D value\" column=\"nr_mac_dl_bit_rate\" quotes=\"true\" /></aliases><parameters><parameter id=\"NR serving cell type\" default=\"All\"><value text=\"PCell\" enum=\"= 0\" /><value text=\"SCell 1\" enum=\"= 1\" /><value text=\"SCell 2\" enum=\"= 2\" /><value text=\"SCell 3\" enum=\"= 3\" /><value text=\"SCell 4\" enum=\"= 4\" /><value text=\"SCell 5\" enum=\"= 5\" /><value text=\"SCell 6\" enum=\"= 6\" /><value text=\"SCell 7\" enum=\"= 7\" /><value text=\"SCell 8\" enum=\"= 8\" /><value text=\"SCell 9\" enum=\"= 9\" /><value text=\"SCell 10\" enum=\"= 10\" /><value text=\"SCell 11\" enum=\"= 11\" /><value text=\"SCell 12\" enum=\"= 12\" /><value text=\"SCell 13\" enum=\"= 13\" /><value text=\"SCell 14\" enum=\"= 14\" /><value text=\"SCell 15\" enum=\"= 15\" /><value text=\"SCell 16\" enum=\"= 16\" /><value text=\"SCell 17\" enum=\"= 17\" /><value text=\"SCell 18\" enum=\"= 18\" /><value text=\"SCell 19\" enum=\"= 19\" /><value text=\"SCell 20\" enum=\"= 20\" /><value text=\"SCell 21\" enum=\"= 21\" /><value text=\"SCell 22\" enum=\"= 22\" /><value text=\"SCell 23\" enum=\"= 23\" /><value text=\"SCell 24\" enum=\"= 24\" /><value text=\"SCell 25\" enum=\"= 25\" /><value text=\"SCell 26\" enum=\"= 26\" /><value text=\"SCell 27\" enum=\"= 27\" /><value text=\"SCell 28\" enum=\"= 28\" /><value text=\"SCell 29\" enum=\"= 29\" /><value text=\"SCell 30\" enum=\"= 30\" /><value text=\"SCell 31\" enum=\"= 31\" /><value text=\"SCG PSCell\" enum=\"= 199\" /><value text=\"SCG SCell 0\" enum=\"= 100\" /><value text=\"SCG SCell 1\" enum=\"= 101\" /><value text=\"SCG SCell 2\" enum=\"= 102\" /><value text=\"SCG SCell 3\" enum=\"= 103\" /><value text=\"SCG SCell 4\" enum=\"= 104\" /><value text=\"SCG SCell 5\" enum=\"= 105\" /><value text=\"SCG SCell 6\" enum=\"= 106\" /><value text=\"SCG SCell 7\" enum=\"= 107\" /><value text=\"SCG SCell 8\" enum=\"= 108\" /><value text=\"SCG SCell 9\" enum=\"= 109\" /><value text=\"SCG SCell 10\" enum=\"= 110\" /><value text=\"SCG SCell 11\" enum=\"= 111\" /><value text=\"SCG SCell 12\" enum=\"= 112\" /><value text=\"SCG SCell 13\" enum=\"= 113\" /><value text=\"SCG SCell 14\" enum=\"= 114\" /><value text=\"SCG SCell 15\" enum=\"= 115\" /><value text=\"SCG SCell 16\" enum=\"= 116\" /><value text=\"SCG SCell 17\" enum=\"= 117\" /><value text=\"SCG SCell 18\" enum=\"= 118\" /><value text=\"SCG SCell 19\" enum=\"= 119\" /><value text=\"SCG SCell 20\" enum=\"= 120\" /><value text=\"SCG SCell 21\" enum=\"= 121\" /><value text=\"SCG SCell 22\" enum=\"= 122\" /><value text=\"SCG SCell 23\" enum=\"= 123\" /><value text=\"SCG SCell 24\" enum=\"= 124\" /><value text=\"SCG SCell 25\" enum=\"= 125\" /><value text=\"SCG SCell 26\" enum=\"= 126\" /><value text=\"SCG SCell 27\" enum=\"= 127\" /><value text=\"SCG SCell 28\" enum=\"= 128\" /><value text=\"SCG SCell 29\" enum=\"= 129\" /><value text=\"SCG SCell 30\" enum=\"= 130\" /><value text=\"SCG SCell 31\" enum=\"= 131\" /><value text=\"SCG SCell\" enum=\"= 198\" /><value text=\"All\" enum=\"&lt; 1000\" /><value text=\"All secondary\" enum=\"&lt; 199\" /></parameter></parameters></sql><qsr value_column=\"nr_mac_dl_bit_rate\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"1000000000\" interval=\"50000000\" threshold=\"200000000\" condition=\"&lt;\" default_action=\"folder, measurement\" colorset_name=\"Throughput (0-200Mbps)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 15000000 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 10000000 AND &quot;{!kpi column}&quot; &lt; 15000000 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 5000000 AND &quot;{!kpi column}&quot; &lt; 10000000 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 1000000 AND &quot;{!kpi column}&quot; &lt; 5000000 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 500000 AND &quot;{!kpi column}&quot; &lt; 1000000 THEN 5&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; 500000 THEN 6&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"9\" left=\"0\" top=\"1650.9333333333334\" width=\"747.42414951324463\" height=\"463.06666666666661\" maptype=\"Google street\" map=\"\" colorset=\"Throughput (0-15Mbps);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_mac_ul_bit_rate\" SplitMapColumnCaption=\"MAC uplink throughput\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_mac_ul_bit_rate\" SplitMapColumnCaptionH=\"MAC uplink throughput\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"82\" SnapColumn=\"0\" SnapRowBottom=\"105\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_mac_ul_bit_rate\" title=\"MAC UL bitrate\" type=\"int64\" format=\"0\" /><column name=\"nr_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_mac_ul_bit_rate\" title=\"MAC UL throughput (5G)\" color_set=\"Throughput (0-15Mbps)\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= 30M\" /><ColorsetLabel id=\"2\" label=\"&gt;= 20M and &lt; 30M\" /><ColorsetLabel id=\"3\" label=\"&gt;= 10M and &lt; 20M\" /><ColorsetLabel id=\"4\" label=\"&gt;= 5M and &lt; 10M\" /><ColorsetLabel id=\"5\" label=\"&gt;= 1M and &lt; 5M\" /><ColorsetLabel id=\"6\" label=\"&lt; 1M\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G;MAC\" /><group name=\"NB-IoT;MAC\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_MACRATEU_ x WHERE (nr_serving_cell_type {?NR serving cell type})  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_mac_ul_bit_rate\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_mac_ul_bit_rate\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_mac_ul_bit_rate\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_mac_ul_bit_rate\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"nr_mac_ul_bit_rate\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_serving_cell_type\" quotes=\"true\" /><alias name=\"3D value\" column=\"nr_mac_ul_bit_rate\" quotes=\"true\" /></aliases><parameters><parameter id=\"NR serving cell type\" default=\"All\"><value text=\"PCell\" enum=\"= 0\" /><value text=\"SCell 1\" enum=\"= 1\" /><value text=\"SCell 2\" enum=\"= 2\" /><value text=\"SCell 3\" enum=\"= 3\" /><value text=\"SCell 4\" enum=\"= 4\" /><value text=\"SCell 5\" enum=\"= 5\" /><value text=\"SCell 6\" enum=\"= 6\" /><value text=\"SCell 7\" enum=\"= 7\" /><value text=\"SCell 8\" enum=\"= 8\" /><value text=\"SCell 9\" enum=\"= 9\" /><value text=\"SCell 10\" enum=\"= 10\" /><value text=\"SCell 11\" enum=\"= 11\" /><value text=\"SCell 12\" enum=\"= 12\" /><value text=\"SCell 13\" enum=\"= 13\" /><value text=\"SCell 14\" enum=\"= 14\" /><value text=\"SCell 15\" enum=\"= 15\" /><value text=\"SCell 16\" enum=\"= 16\" /><value text=\"SCell 17\" enum=\"= 17\" /><value text=\"SCell 18\" enum=\"= 18\" /><value text=\"SCell 19\" enum=\"= 19\" /><value text=\"SCell 20\" enum=\"= 20\" /><value text=\"SCell 21\" enum=\"= 21\" /><value text=\"SCell 22\" enum=\"= 22\" /><value text=\"SCell 23\" enum=\"= 23\" /><value text=\"SCell 24\" enum=\"= 24\" /><value text=\"SCell 25\" enum=\"= 25\" /><value text=\"SCell 26\" enum=\"= 26\" /><value text=\"SCell 27\" enum=\"= 27\" /><value text=\"SCell 28\" enum=\"= 28\" /><value text=\"SCell 29\" enum=\"= 29\" /><value text=\"SCell 30\" enum=\"= 30\" /><value text=\"SCell 31\" enum=\"= 31\" /><value text=\"SCG PSCell\" enum=\"= 199\" /><value text=\"SCG SCell 0\" enum=\"= 100\" /><value text=\"SCG SCell 1\" enum=\"= 101\" /><value text=\"SCG SCell 2\" enum=\"= 102\" /><value text=\"SCG SCell 3\" enum=\"= 103\" /><value text=\"SCG SCell 4\" enum=\"= 104\" /><value text=\"SCG SCell 5\" enum=\"= 105\" /><value text=\"SCG SCell 6\" enum=\"= 106\" /><value text=\"SCG SCell 7\" enum=\"= 107\" /><value text=\"SCG SCell 8\" enum=\"= 108\" /><value text=\"SCG SCell 9\" enum=\"= 109\" /><value text=\"SCG SCell 10\" enum=\"= 110\" /><value text=\"SCG SCell 11\" enum=\"= 111\" /><value text=\"SCG SCell 12\" enum=\"= 112\" /><value text=\"SCG SCell 13\" enum=\"= 113\" /><value text=\"SCG SCell 14\" enum=\"= 114\" /><value text=\"SCG SCell 15\" enum=\"= 115\" /><value text=\"SCG SCell 16\" enum=\"= 116\" /><value text=\"SCG SCell 17\" enum=\"= 117\" /><value text=\"SCG SCell 18\" enum=\"= 118\" /><value text=\"SCG SCell 19\" enum=\"= 119\" /><value text=\"SCG SCell 20\" enum=\"= 120\" /><value text=\"SCG SCell 21\" enum=\"= 121\" /><value text=\"SCG SCell 22\" enum=\"= 122\" /><value text=\"SCG SCell 23\" enum=\"= 123\" /><value text=\"SCG SCell 24\" enum=\"= 124\" /><value text=\"SCG SCell 25\" enum=\"= 125\" /><value text=\"SCG SCell 26\" enum=\"= 126\" /><value text=\"SCG SCell 27\" enum=\"= 127\" /><value text=\"SCG SCell 28\" enum=\"= 128\" /><value text=\"SCG SCell 29\" enum=\"= 129\" /><value text=\"SCG SCell 30\" enum=\"= 130\" /><value text=\"SCG SCell 31\" enum=\"= 131\" /><value text=\"SCG SCell\" enum=\"= 198\" /><value text=\"All\" enum=\"&lt; 1000\" /><value text=\"All secondary\" enum=\"&lt; 199\" /></parameter></parameters></sql><qsr value_column=\"nr_mac_ul_bit_rate\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"50000000\" interval=\"2000000\" threshold=\"10000000\" condition=\"&lt;\" default_action=\"folder, measurement\" colorset_name=\"Throughput (0-15Mbps)\" weight_by=\"time\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"10\" left=\"0\" top=\"1087.2\" width=\"747.42414951324463\" height=\"463.06666666666672\" maptype=\"Google street\" map=\"\" colorset=\"NR Rank;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_serving_cell_type\" SplitMapColumnCaption=\"Serving cell type\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_serving_cell_type\" SplitMapColumnCaptionH=\"Serving cell type\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"54\" SnapColumn=\"0\" SnapRowBottom=\"77\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_rank_indicator\" title=\"RI\" type=\"int16\" format=\"0\" /><column name=\"nr_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_rank_indicator\" system=\"NR\" color_set=\"NR Rank\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G;Link adaptation\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_CQI_ x WHERE (nr_serving_cell_type {?NR serving cell type})  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_rank_indicator\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_rank_indicator\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_rank_indicator\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_rank_indicator\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"nr_rank_indicator\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_serving_cell_type\" quotes=\"true\" /></aliases><parameters><parameter id=\"NR serving cell type\" default=\"All\"><value text=\"PCell\" enum=\"= 0\" /><value text=\"SCell 1\" enum=\"= 1\" /><value text=\"SCell 2\" enum=\"= 2\" /><value text=\"SCell 3\" enum=\"= 3\" /><value text=\"SCell 4\" enum=\"= 4\" /><value text=\"SCell 5\" enum=\"= 5\" /><value text=\"SCell 6\" enum=\"= 6\" /><value text=\"SCell 7\" enum=\"= 7\" /><value text=\"SCell 8\" enum=\"= 8\" /><value text=\"SCell 9\" enum=\"= 9\" /><value text=\"SCell 10\" enum=\"= 10\" /><value text=\"SCell 11\" enum=\"= 11\" /><value text=\"SCell 12\" enum=\"= 12\" /><value text=\"SCell 13\" enum=\"= 13\" /><value text=\"SCell 14\" enum=\"= 14\" /><value text=\"SCell 15\" enum=\"= 15\" /><value text=\"SCell 16\" enum=\"= 16\" /><value text=\"SCell 17\" enum=\"= 17\" /><value text=\"SCell 18\" enum=\"= 18\" /><value text=\"SCell 19\" enum=\"= 19\" /><value text=\"SCell 20\" enum=\"= 20\" /><value text=\"SCell 21\" enum=\"= 21\" /><value text=\"SCell 22\" enum=\"= 22\" /><value text=\"SCell 23\" enum=\"= 23\" /><value text=\"SCell 24\" enum=\"= 24\" /><value text=\"SCell 25\" enum=\"= 25\" /><value text=\"SCell 26\" enum=\"= 26\" /><value text=\"SCell 27\" enum=\"= 27\" /><value text=\"SCell 28\" enum=\"= 28\" /><value text=\"SCell 29\" enum=\"= 29\" /><value text=\"SCell 30\" enum=\"= 30\" /><value text=\"SCell 31\" enum=\"= 31\" /><value text=\"SCG PSCell\" enum=\"= 199\" /><value text=\"SCG SCell 0\" enum=\"= 100\" /><value text=\"SCG SCell 1\" enum=\"= 101\" /><value text=\"SCG SCell 2\" enum=\"= 102\" /><value text=\"SCG SCell 3\" enum=\"= 103\" /><value text=\"SCG SCell 4\" enum=\"= 104\" /><value text=\"SCG SCell 5\" enum=\"= 105\" /><value text=\"SCG SCell 6\" enum=\"= 106\" /><value text=\"SCG SCell 7\" enum=\"= 107\" /><value text=\"SCG SCell 8\" enum=\"= 108\" /><value text=\"SCG SCell 9\" enum=\"= 109\" /><value text=\"SCG SCell 10\" enum=\"= 110\" /><value text=\"SCG SCell 11\" enum=\"= 111\" /><value text=\"SCG SCell 12\" enum=\"= 112\" /><value text=\"SCG SCell 13\" enum=\"= 113\" /><value text=\"SCG SCell 14\" enum=\"= 114\" /><value text=\"SCG SCell 15\" enum=\"= 115\" /><value text=\"SCG SCell 16\" enum=\"= 116\" /><value text=\"SCG SCell 17\" enum=\"= 117\" /><value text=\"SCG SCell 18\" enum=\"= 118\" /><value text=\"SCG SCell 19\" enum=\"= 119\" /><value text=\"SCG SCell 20\" enum=\"= 120\" /><value text=\"SCG SCell 21\" enum=\"= 121\" /><value text=\"SCG SCell 22\" enum=\"= 122\" /><value text=\"SCG SCell 23\" enum=\"= 123\" /><value text=\"SCG SCell 24\" enum=\"= 124\" /><value text=\"SCG SCell 25\" enum=\"= 125\" /><value text=\"SCG SCell 26\" enum=\"= 126\" /><value text=\"SCG SCell 27\" enum=\"= 127\" /><value text=\"SCG SCell 28\" enum=\"= 128\" /><value text=\"SCG SCell 29\" enum=\"= 129\" /><value text=\"SCG SCell 30\" enum=\"= 130\" /><value text=\"SCG SCell 31\" enum=\"= 131\" /><value text=\"SCG SCell\" enum=\"= 198\" /><value text=\"All\" enum=\"&lt; 1000\" /><value text=\"All secondary\" enum=\"&lt; 199\" /></parameter></parameters></sql><qsr value_column=\"nr_rank_indicator\" value_parameter=\"\" direction=\"up\" min=\"1\" max=\"8\" interval=\"1\" threshold=\"4\" condition=\"&lt;\" default_action=\"0\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"12\" left=\"1766.6388988494871\" top=\"1087.2\" width=\"747.42414951324463\" height=\"463.06666666666672\" maptype=\"Google street\" map=\"\" colorset=\"NR modulation;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_la_dl_scheduled_modulation_0\" SplitMapColumnCaption=\"nr_la_dl_scheduled_modulation_0\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_la_dl_scheduled_modulation_0\" SplitMapColumnCaptionH=\"nr_la_dl_scheduled_modulation_0\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"54\" SnapColumn=\"26\" SnapRowBottom=\"77\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"1\" GridLineWidth=\"2\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_la_dl_scheduled_modulation_0\" title=\"PDSCH modulation 0\" type=\"int16\" format=\"0\" /><column name=\"Modulation CW0\" title=\"Modulation CW0\" type=\"string\" /><column name=\"nr_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" filter_target=\"x\" id=\"nr_la_dl_scheduled_modulation_0\" title=\"PDSCH modulation codeword 0\" system=\"NR\" color_set=\"NR modulation\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G;Link adaptation\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_PLAID_ x WHERE (x.nr_serving_cell_type {?NR serving cell type})  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_la_dl_scheduled_modulation_0\" output_name=\"nr_la_dl_scheduled_modulation_0\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"VAL_TO_STRING('nr_la_dl_scheduled_modulation_0',nr_la_dl_scheduled_modulation_0)\" output_name=\"Modulation CW0\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_la_dl_scheduled_modulation_0\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_la_dl_scheduled_modulation_0\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"nr_la_dl_scheduled_modulation_0\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_la_dl_scheduled_modulation_0\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_serving_cell_type\" quotes=\"true\" /></aliases><parameters><parameter id=\"NR serving cell type\" default=\"All\"><value text=\"PCell\" enum=\"= 0\" /><value text=\"SCell 1\" enum=\"= 1\" /><value text=\"SCell 2\" enum=\"= 2\" /><value text=\"SCell 3\" enum=\"= 3\" /><value text=\"SCell 4\" enum=\"= 4\" /><value text=\"SCell 5\" enum=\"= 5\" /><value text=\"SCell 6\" enum=\"= 6\" /><value text=\"SCell 7\" enum=\"= 7\" /><value text=\"SCell 8\" enum=\"= 8\" /><value text=\"SCell 9\" enum=\"= 9\" /><value text=\"SCell 10\" enum=\"= 10\" /><value text=\"SCell 11\" enum=\"= 11\" /><value text=\"SCell 12\" enum=\"= 12\" /><value text=\"SCell 13\" enum=\"= 13\" /><value text=\"SCell 14\" enum=\"= 14\" /><value text=\"SCell 15\" enum=\"= 15\" /><value text=\"SCell 16\" enum=\"= 16\" /><value text=\"SCell 17\" enum=\"= 17\" /><value text=\"SCell 18\" enum=\"= 18\" /><value text=\"SCell 19\" enum=\"= 19\" /><value text=\"SCell 20\" enum=\"= 20\" /><value text=\"SCell 21\" enum=\"= 21\" /><value text=\"SCell 22\" enum=\"= 22\" /><value text=\"SCell 23\" enum=\"= 23\" /><value text=\"SCell 24\" enum=\"= 24\" /><value text=\"SCell 25\" enum=\"= 25\" /><value text=\"SCell 26\" enum=\"= 26\" /><value text=\"SCell 27\" enum=\"= 27\" /><value text=\"SCell 28\" enum=\"= 28\" /><value text=\"SCell 29\" enum=\"= 29\" /><value text=\"SCell 30\" enum=\"= 30\" /><value text=\"SCell 31\" enum=\"= 31\" /><value text=\"SCG PSCell\" enum=\"= 199\" /><value text=\"SCG SCell 0\" enum=\"= 100\" /><value text=\"SCG SCell 1\" enum=\"= 101\" /><value text=\"SCG SCell 2\" enum=\"= 102\" /><value text=\"SCG SCell 3\" enum=\"= 103\" /><value text=\"SCG SCell 4\" enum=\"= 104\" /><value text=\"SCG SCell 5\" enum=\"= 105\" /><value text=\"SCG SCell 6\" enum=\"= 106\" /><value text=\"SCG SCell 7\" enum=\"= 107\" /><value text=\"SCG SCell 8\" enum=\"= 108\" /><value text=\"SCG SCell 9\" enum=\"= 109\" /><value text=\"SCG SCell 10\" enum=\"= 110\" /><value text=\"SCG SCell 11\" enum=\"= 111\" /><value text=\"SCG SCell 12\" enum=\"= 112\" /><value text=\"SCG SCell 13\" enum=\"= 113\" /><value text=\"SCG SCell 14\" enum=\"= 114\" /><value text=\"SCG SCell 15\" enum=\"= 115\" /><value text=\"SCG SCell 16\" enum=\"= 116\" /><value text=\"SCG SCell 17\" enum=\"= 117\" /><value text=\"SCG SCell 18\" enum=\"= 118\" /><value text=\"SCG SCell 19\" enum=\"= 119\" /><value text=\"SCG SCell 20\" enum=\"= 120\" /><value text=\"SCG SCell 21\" enum=\"= 121\" /><value text=\"SCG SCell 22\" enum=\"= 122\" /><value text=\"SCG SCell 23\" enum=\"= 123\" /><value text=\"SCG SCell 24\" enum=\"= 124\" /><value text=\"SCG SCell 25\" enum=\"= 125\" /><value text=\"SCG SCell 26\" enum=\"= 126\" /><value text=\"SCG SCell 27\" enum=\"= 127\" /><value text=\"SCG SCell 28\" enum=\"= 128\" /><value text=\"SCG SCell 29\" enum=\"= 129\" /><value text=\"SCG SCell 30\" enum=\"= 130\" /><value text=\"SCG SCell 31\" enum=\"= 131\" /><value text=\"SCG SCell\" enum=\"= 198\" /><value text=\"All\" enum=\"&lt; 1000\" /></parameter></parameters></sql><qsr value_column=\"nr_la_dl_scheduled_modulation_0\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"5\" interval=\"1\" threshold=\"1\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"13\" left=\"1766.6388988494871\" top=\"563.73333333333335\" width=\"747.42414951324463\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"Throughput (0-50Mbps);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"current_lte_physical_layer_cell_id\" SplitMapColumnCaption=\"Physical cell identity\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"current_lte_physical_layer_cell_id\" SplitMapColumnCaptionH=\"Physical cell identity\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"26\" SnapRowBottom=\"51\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"sql_time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /><column name=\"lte_mac_dl_bit_rate\" title=\"MAC DL bitrate\" type=\"double\" format=\"0.0##\" /><column name=\"nr_mac_dl_bit_rate\" title=\"MAC DL bitrate\" type=\"double\" format=\"0.0##\" /><column name=\"lte_mac_dl_bit_rate_total\" title=\"Total MAC DL throughput\" type=\"double\" format=\"0.0##\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"lte_nr_total_mac_dl_bit_rate\" title=\"LTE + 5G MAC DL throughput total\" color_set=\"Throughput (0-500Mbps)\" description=\"Total MAC DL throughput\"><ColorsetLabelMap><ColorsetLabel id=\"1\" label=\"&gt;= 500M\" /><ColorsetLabel id=\"2\" label=\"&gt;= 400M and &lt; 500M\" /><ColorsetLabel id=\"3\" label=\"&gt;= 300M and &lt; 400M\" /><ColorsetLabel id=\"4\" label=\"&gt;= 200M and &lt; 300M\" /><ColorsetLabel id=\"5\" label=\"&gt;= 100M and &lt; 200M\" /><ColorsetLabel id=\"6\" label=\"&gt;= 100M and &lt; 1M\" /><ColorsetLabel id=\"7\" label=\"&gt;= 1K and &lt; 1M\" /><ColorsetLabel id=\"8\" label=\"&lt; 1K\" /></ColorsetLabelMap><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /><group name=\"LTE\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"select * from Nemo.SCRIPT('nemo.analyze.kpi.Query_2_Sum','SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as &quot;Interval&quot;,                  SUM(CAST(lte_mac_dl_bit_rate as double precision)) as &quot;lte_mac_dl_bit_rate&quot;,                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order {!procedure_qsr_columns}                  FROM Nemo.LTE_MACRATE_ x                  WHERE 0 = 0  AND x.file_id = {!file} {!filter}                  GROUP BY sql_time  ,x.lr_id ORDER BY _exclude_order   ,x.lr_id ;SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as &quot;Interval&quot;,                  SUM(CAST(nr_mac_dl_bit_rate as double precision)) as &quot;nr_mac_dl_bit_rate&quot;,                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order {!procedure_qsr_columns}                  FROM Nemo.NR_MACRATE_ x                  WHERE 0 = 0 AND x.file_id = {!file}  {!filter}                  GROUP BY sql_time ,x.lr_id  ORDER BY _exclude_order  ,x.lr_id  ;Interval:1;GROUP_BY:sql_time,time,gps_longitude,gps_latitude,gps_height;add:lte_mac_dl_bit_rate,nr_mac_dl_bit_rate,lte_mac_dl_bit_rate_total;qsr:{!procedure_qsr_columns}','{!procedure_filter}','file_id={!file}') as (&quot;sql_time&quot; timestamp,&quot;time&quot; bytea,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;gps_height&quot; smallint,&quot;lte_mac_dl_bit_rate&quot; double precision,&quot;nr_mac_dl_bit_rate&quot; double precision   {!qsr_output_columns}  ,&quot;lte_mac_dl_bit_rate_total&quot; double precision)\"><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"sql_time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"lte_mac_dl_bit_rate_total\" quotes=\"true\" /></aliases></sql><qsr value_column=\"lte_mac_dl_bit_rate_total\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"200000000\" interval=\"10000000\" threshold=\"100000000\" condition=\"&lt;\" default_action=\"folder, measurement\" colorset_name=\"Throughput (0-500Mbps)\" colorset_query=\"CASE&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 500000000 THEN 1&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 400000000 AND &quot;{!kpi column}&quot; &lt; 500000000 THEN 2&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 300000000 AND &quot;{!kpi column}&quot; &lt; 400000000 THEN 3&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 200000000 AND &quot;{!kpi column}&quot; &lt; 300000000 THEN 4&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 100000000 AND &quot;{!kpi column}&quot; &lt; 200000000 THEN 5&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 100000000 AND &quot;{!kpi column}&quot; &lt; 1000000 THEN 6&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &gt;= 1000 AND &quot;{!kpi column}&quot; &lt; 1000000 THEN 7&#xD;&#xA;WHEN &quot;{!kpi column}&quot; &lt; 1000 THEN 8&#xD;&#xA; END AS colorset\" weight_by=\"time\"><option type=\"time\" duration_column=\"MIN(to_interval(time)) AS qsr_duration\" /><option type=\"distance\" duration_column=\"MIN(distance_interval) AS qsr_duration\" /><option type=\"sample\" duration_column=\"MIN(1) AS qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"14\" left=\"883.31944942474354\" top=\"1087.2\" width=\"747.42414951324474\" height=\"463.06666666666672\" maptype=\"Google street\" map=\"\" colorset=\"NR ARFCN;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"the_measured_system\" SplitMapColumnCaption=\"System\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"the_measured_system\" SplitMapColumnCaptionH=\"System\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"54\" SnapColumn=\"13\" SnapRowBottom=\"77\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"2\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"the_measured_system\" title=\"System\" type=\"int64\" format=\"0\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"mobile\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_pscell_arfcn_mobile\" title=\"Primary serving cell NR ARFCN\" system=\"NR\" color_set=\"NR ARFCN\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_CELLMEAS_Cell_ WHERE (nr_arfcn IS NOT NULL AND nr_arfcn &gt; 0) AND nr_cell_type IN(0, 199) AND (nr_beam_type = 1 OR nr_beam_type IS NULL) AND the_measured_system = 4194304  AND file_id = {!file} {!filter} ORDER BY _exclude_order_1, _exclude_order_2 \"><columns><column name=\"DISTINCT time\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"the_measured_system\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"the_device_title || '.' || the_device_extension AS _exclude_order_1\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"sql_time AS _exclude_order_2\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"System\" column=\"the_measured_system\" quotes=\"true\" /><alias name=\"Description\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_arfcn\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases></sql><qsr value_column=\"nr_arfcn\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"3279165\" interval=\"100000\" threshold=\"0\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"16\" left=\"883.31944942474354\" top=\"1650.9333333333334\" width=\"747.42414951324474\" height=\"463.06666666666661\" maptype=\"Google street\" map=\"\" colorset=\"TX power (dBm);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_serving_cell_type\" SplitMapColumnCaption=\"Serving cell type\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_serving_cell_type\" SplitMapColumnCaptionH=\"Serving cell type\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"82\" SnapColumn=\"13\" SnapRowBottom=\"105\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT NR Plots\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"d.m.yyyy h:mm:ss.000\" /><column name=\"nr_pusch_tx_power\" title=\"PUSCH TX power\" type=\"single\" format=\"0.0#\" /><column name=\"nr_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"nr_sul_indication\" title=\"UL type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_pusch_tx_power\" system=\"NR\" color_set=\"TX power (dBm)\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.NR_TXPC_ x WHERE nr_pusch_tx_power IS NOT NULL  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pusch_tx_power\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_sul_indication\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"nr_pusch_tx_power\" quotes=\"true\" /><alias name=\"Color set\" column=\"nr_pusch_tx_power\" quotes=\"true\" /><alias name=\"Correlate\" column=\"nr_pusch_tx_power\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"nr_pusch_tx_power\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Group by\" column=\"nr_serving_cell_type\" quotes=\"true\" /></aliases></sql><qsr value_column=\"nr_pusch_tx_power\" value_parameter=\"\" direction=\"up\" min=\"-50\" max=\"40\" interval=\"5\" threshold=\"0\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT NR Plots\" id=\"17\" left=\"1766.6388988494871\" top=\"1650.9333333333334\" width=\"747.42414951324463\" height=\"463.06666666666661\" maptype=\"Google street\" map=\"\" colorset=\"Beam Index;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"Base 5G.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"nr_arfcn\" SplitMapColumnCaption=\"NR-ARFCN\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"nr_arfcn\" SplitMapColumnCaptionH=\"NR-ARFCN\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"82\" SnapColumn=\"26\" SnapRowBottom=\"105\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"1\" GridLineWidth=\"2\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"Sheet1\" row=\"0\" column=\"0\"><column_settings><column name=\"nr_rp\" title=\"RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"BI 1. best\" title=\"BI 1. best\" type=\"int16\" format=\"0\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"mobile\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_nr_ss_BI_nth_best_selected_carrier\" title=\"Beam Index Nth best selected carrier\" system=\"NR\" color_set=\"Beam Index\" description=\"Beam Index of the best SS Block Reference beam measured based on SS-RSRP among all SS Block beams of all cells of selected carrier.\" query_title=\"BI {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\" order by lr_id ') as (&quot;nr_rp&quot; real,&quot;time&quot; bytea,&quot;BI {?N}. best&quot; smallint,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns} FROM Nemo.NR_CELLMEAS_Cell_ WHERE nr_meas_type = 1 AND nr_rp IS NOT NULL AND nr_arfcn {?Carrier number}   AND file_id = {!file} {!procedure_filter}\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"BI {?N}. best\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Color set\" column=\"BI {?N}. best\" quotes=\"true\" /><alias name=\"Print value\" column=\"BI {?N}. best\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"Carrier number\" sql=\"select * from Nemo.ONE_AND_ONLY('Nemo','NR_CELLMEAS_Cell','nr_arfcn','{!file1}') as (nr_arfcn integer)\" default=\"&gt; 0\" /></parameters></sql><qsr value_column=\"qsr_duration\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"100\" interval=\"0\" threshold=\"50\" condition=\"&lt;\" default_action=\"folder, measurement\" statistics=\"count\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"3\" left=\"0\" top=\"40.266666666666666\" width=\"747.4241090698066\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"Physical cell identity;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"true\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"false\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"lte_physical_layer_cell_id\" SplitMapColumnCaption=\"Physical cell identity\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"lte_physical_layer_cell_id\" SplitMapColumnCaptionH=\"Physical cell identity\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"0\" SnapRowBottom=\"25\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"lte_physical_layer_cell_id\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"lte_physical_layer_cell_id\" system=\"LTE FDD;LTE TDD\" color_set=\"Physical cell identity\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE\" /><group name=\"NB-IoT\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.LTE_CHI_ x  WHERE x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_physical_layer_cell_id\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Print value\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases></sql><qsr value_column=\"qsr_duration\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"100\" interval=\"0\" threshold=\"50\" condition=\"&lt;\" default_action=\"folder, measurement\" statistics=\"count\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"4\" left=\"883.31985622644424\" top=\"40.266666666666666\" width=\"747.42449373006821\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"RSRP (dBm);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"channel_number\" SplitMapColumnCaption=\"Channel number\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"channel_number\" SplitMapColumnCaptionH=\"Channel number\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"13\" SnapRowBottom=\"25\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best RSRP\" title=\"1. best RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"channel_number\" title=\"Ch\" type=\"int32\" format=\"0\" /><column name=\"lte_physical_layer_cell_id\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_nth_best_rsrp\" title=\"RSRP Nth best\" system=\"LTE FDD;LTE TDD\" color_set=\"RSRP (dBm)\" description=\"RSRP of the Nth strongest cell, where the strongest cell is selected in terms of RSRP\" query_title=\"RSRP {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE\" /><group name=\"NB-IoT\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\" order by x.lr_id ') as (&quot;{?N}. best RSRP&quot; real,&quot;time&quot; bytea,&quot;channel_number&quot; integer,&quot;lte_physical_layer_cell_id&quot; smallint,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}  FROM Nemo.LTE_CELLMEAS_Cell_ x   WHERE x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"&quot;lte_received_power&quot;\" output_name=\"{?N}. best RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"channel_number\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_physical_layer_cell_id\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /></parameters></sql><qsr value_column=\"{?N}. best RSRP\" value_parameter=\"lte_received_power\" direction=\"up\" min=\"-140\" max=\"-35\" interval=\"10\" threshold=\"-90\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"5\" left=\"1766.6397124528885\" top=\"40.266666666666666\" width=\"747.42449373006821\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"RSRQ (dB);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"17\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"channel_number\" SplitMapColumnCaption=\"Channel number\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"channel_number\" SplitMapColumnCaptionH=\"Channel number\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"2\" SnapColumn=\"26\" SnapRowBottom=\"25\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"lte_received_power\" title=\"RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"1. best RSRQ\" title=\"1. best RSRQ\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"channel_number\" title=\"Ch\" type=\"int32\" format=\"0\" /><column name=\"lte_physical_layer_cell_id\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_nth_bestt_rsrq\" title=\"RSRQ Nth best\" system=\"LTE FDD;LTE TDD\" color_set=\"RSRQ (dB)\" description=\"RSRQ of the Nth strongest cell, where strongest cell is selected in terms of RSRP\" query_title=\"RSRQ {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE\" /><group name=\"NB-IoT\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, '\" postfix=\" order by x.lr_id ') as (&quot;lte_received_power&quot; real,&quot;{?N}. best RSRQ&quot; real,&quot;time&quot; bytea,&quot;channel_number&quot; integer,&quot;lte_physical_layer_cell_id&quot; smallint,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision {!qsr_output_columns})\" tail=\"{!columns}{!procedure_qsr_columns}  FROM Nemo.LTE_CELLMEAS_Cell_ x  WHERE x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"lte_received_power\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"&quot;lte_received_quality&quot;\" output_name=\"{?N}. best RSRQ\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"channel_number\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_physical_layer_cell_id\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Bar X\" column=\"lte_physical_layer_cell_id\" quotes=\"true\" /><alias name=\"Bar X sub\" column=\"channel_number\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRQ\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /></parameters></sql><qsr value_column=\"{?N}. best RSRQ\" value_parameter=\"lte_received_quality\" direction=\"up\" min=\"-30\" max=\"0\" interval=\"1\" threshold=\"-15\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"6\" left=\"0\" top=\"563.73333333333335\" width=\"747.42449373006821\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"SINR (dB);\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"lte_serving_cell_type\" SplitMapColumnCaption=\"Serving cell type\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"lte_serving_cell_type\" SplitMapColumnCaptionH=\"Serving cell type\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"0\" SnapRowBottom=\"51\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"lte_rs_snr\" title=\"SNR\" type=\"single\" format=\"0.0##\" /><column name=\"lte_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"lte_rs_snr\" system=\"LTE FDD;LTE TDD\" color_set=\"RS SNR (dB)\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE\" /><group name=\"NB-IoT\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.LTE_CI_ x WHERE (lte_serving_cell_type {?LTE serving cell type}) AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_rs_snr\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_rs_snr\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_rs_snr\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_rs_snr\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"lte_rs_snr\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Group by\" column=\"lte_serving_cell_type\" quotes=\"true\" /><alias name=\"3D value\" column=\"lte_rs_snr\" quotes=\"true\" /></aliases><parameters><parameter id=\"LTE serving cell type\" default=\"Primary\"><value text=\"Primary\" enum=\"= 0 OR lte_serving_cell_type IS NULL\" /><value text=\"Secondary 1\" enum=\"= 1\" /><value text=\"Secondary 2\" enum=\"= 2\" /><value text=\"Secondary 3\" enum=\"= 3\" /><value text=\"Secondary 4\" enum=\"= 4\" /><value text=\"All\" enum=\"= 0 OR lte_serving_cell_type = 1 OR lte_serving_cell_type = 2 OR lte_serving_cell_type = 3 OR lte_serving_cell_type = 4 OR lte_serving_cell_type IS NULL\" /></parameter></parameters></sql><qsr value_column=\"lte_rs_snr\" value_parameter=\"\" direction=\"up\" min=\"-40\" max=\"50\" interval=\"5\" threshold=\"0\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"9\" left=\"1766.6397124528885\" top=\"563.73333333333335\" width=\"747.42449373006821\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"CQI;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"lte_cqi_subband_index\" SplitMapColumnCaption=\"CQI subband index\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"lte_cqi_subband_index\" SplitMapColumnCaptionH=\"CQI subband index\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"26\" SnapRowBottom=\"51\" SnapColumnRight=\"37\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"lte_cqi_subband_index\" title=\"SB index\" type=\"int16\" format=\"0\" /><column name=\"lte_cqi_subband_cqi_0\" title=\"CQI 0/SB\" type=\"int16\" format=\"0\" /><column name=\"lte_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"lte_cqi_subband_cqi_0\" system=\"LTE FDD;LTE TDD\" color_set=\"CQI\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE;Link adaptation\" /><group name=\"NB-IoT;Link adaptation\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.LTE_CQI_SubBand_ x WHERE (lte_serving_cell_type {?LTE serving cell type})  AND x.file_id = {!file} {!filter} order by x.lr_id \"><columns><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_cqi_subband_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_cqi_subband_cqi_0\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_cqi_subband_cqi_0\" quotes=\"true\" /><alias name=\"Group by\" column=\"lte_cqi_subband_index\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_cqi_subband_cqi_0\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_cqi_subband_cqi_0\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"lte_cqi_subband_cqi_0\" quotes=\"true\" /></aliases><parameters><parameter id=\"LTE serving cell type\" default=\"Primary\"><value text=\"Primary\" enum=\"= 0 OR lte_serving_cell_type IS NULL\" /><value text=\"Secondary 1\" enum=\"= 1\" /><value text=\"Secondary 2\" enum=\"= 2\" /><value text=\"Secondary 3\" enum=\"= 3\" /><value text=\"Secondary 4\" enum=\"= 4\" /><value text=\"All\" enum=\"= 0 OR lte_serving_cell_type = 1 OR lte_serving_cell_type = 2 OR lte_serving_cell_type = 3 OR lte_serving_cell_type = 4 OR lte_serving_cell_type IS NULL\" /></parameter></parameters></sql><qsr value_column=\"lte_cqi_subband_cqi_0\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"15\" interval=\"1\" threshold=\"7\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"11\" left=\"883.31985622644424\" top=\"1107.3333333333333\" width=\"747.42449373006821\" height=\"463.06666666666661\" maptype=\"Google street\" map=\"\" colorset=\"LTE modulation;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"true\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"Distance Bin\" SplitMapColumnCaption=\"Distance Bin\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"Distance Bin\" SplitMapColumnCaptionH=\"Distance Bin\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"55\" SnapColumn=\"13\" SnapRowBottom=\"78\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"1\" GridLineWidth=\"2\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"lte_la_dl_modulation_0\" title=\"Modulation 0\" type=\"int16\" format=\"0\" /><column name=\"lte_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"Measurement title\" title=\"Measurement title\" type=\"string\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"Percentage\" title=\"Percentage\" type=\"single\" format=\"0.0##\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_la_dl_modulation_0_distribution\" title=\"PDSCH modulation codeword 0 (distribution)\" system=\"LTE FDD;LTE TDD\" color_set=\"LTE modulation\" description=\"The PDSCH modulation codeword 0 over the reporting period\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE;Link adaptation\" /><group name=\"NB-IoT;Link adaptation\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND \" postfix=\"\"><filter type=\"enum\" name=\"PDSCH modulation\" column=\"lte_la_dl_modulation_0\" quotes=\"false\" /></filters><sql tail=\"select * from Nemo.SCRIPT('nemo.analyze.kpi.PdschModulationCodeword0','Mode:0;qsr:{!procedure_qsr_columns}','(lte_serving_cell_type {?LTE serving cell type}) AND 0=0 {!procedure_filter}','file_id={!file}') as (&quot;time&quot; bytea,&quot;lte_la_dl_modulation_0&quot; smallint,&quot;lte_serving_cell_type&quot; smallint,&quot;Measurement title&quot; text,&quot;_exclude_order_1&quot; text,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision,&quot;_exclude_order_3&quot; smallint,&quot;_exclude_order_4&quot; smallint,&quot;Percentage&quot; real {!qsr_output_column2})\"><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"lte_la_dl_modulation_0\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_la_dl_modulation_0\" quotes=\"true\" /><alias name=\"Group by\" column=\"lte_la_dl_modulation_0\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_la_dl_modulation_0\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_la_dl_modulation_0\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"LTE serving cell type\" default=\"Primary\"><value text=\"Primary\" enum=\"= 0 OR lte_serving_cell_type IS NULL\" /><value text=\"Secondary 1\" enum=\"= 1\" /><value text=\"Secondary 2\" enum=\"= 2\" /><value text=\"Secondary 3\" enum=\"= 3\" /><value text=\"Secondary 4\" enum=\"= 4\" /><value text=\"All\" enum=\"= 0 OR lte_serving_cell_type = 1 OR lte_serving_cell_type = 2 OR lte_serving_cell_type = 3 OR lte_serving_cell_type = 4 OR lte_serving_cell_type IS NULL\" /></parameter></parameters></sql><qsr value_column=\"lte_la_dl_modulation_0\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"5\" interval=\"1\" threshold=\"1\" condition=\"&lt;\" default_action=\"0\"><option type=\"sample\" duration_column=\"1 AS qsr_duration\" /></qsr></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"12\" left=\"883.31985622644424\" top=\"563.73333333333335\" width=\"747.42449373006821\" height=\"463.06666666666666\" maptype=\"Google street\" map=\"\" colorset=\"Rank;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"lte_la_dl_rank\" SplitMapColumnCaption=\"PDSCH rank\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"lte_la_dl_rank\" SplitMapColumnCaptionH=\"PDSCH rank\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"28\" SnapColumn=\"13\" SnapRowBottom=\"51\" SnapColumnRight=\"24\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"lte_la_dl_rank\" title=\"Rank\" type=\"int16\" format=\"0\" /><column name=\"lte_serving_cell_type\" title=\"Cell type\" type=\"int16\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"1\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_lte_la_dl_rank_mode\" title=\"PDSCH rank (mode)\" system=\"LTE FDD;LTE TDD\" color_set=\"Rank\" description=\"The most common value of the PDSCH rank over the reporting period\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"LTE;Link adaptation\" /><group name=\"NB-IoT;Link adaptation\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST(1, 0, 0, 0, '\" postfix=\" order by x.lr_id ') as (&quot;time&quot; bytea,&quot;lte_la_dl_rank&quot; smallint,&quot;lte_serving_cell_type&quot; smallint,&quot;gps_longitude&quot; double precision,&quot;gps_latitude&quot; double precision)\" tail=\"{!columns} FROM Nemo.LTE_PLAID_MCS_ x WHERE (lte_serving_cell_type {?LTE serving cell type}) AND &quot;lte_la_dl_modulation_0&quot; IS NOT NULL  AND x.file_id = {!file} {!procedure_filter}\"><columns><column name=\"&quot;the_event&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"percentage\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_la_dl_rank\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"lte_serving_cell_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"lte_la_dl_rank\" quotes=\"true\" /><alias name=\"Correlate\" column=\"lte_la_dl_rank\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"lte_la_dl_rank\" quotes=\"true\" /><alias name=\"Color set\" column=\"lte_la_dl_rank\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /></aliases><parameters><parameter id=\"LTE serving cell type\" default=\"Primary\"><value text=\"Primary\" enum=\"= 0 OR lte_serving_cell_type IS NULL\" /><value text=\"Secondary 1\" enum=\"= 1\" /><value text=\"Secondary 2\" enum=\"= 2\" /><value text=\"Secondary 3\" enum=\"= 3\" /><value text=\"Secondary 4\" enum=\"= 4\" /><value text=\"All\" enum=\"= 0 OR lte_serving_cell_type = 1 OR lte_serving_cell_type = 2 OR lte_serving_cell_type = 3 OR lte_serving_cell_type = 4 OR lte_serving_cell_type IS NULL\" /></parameter></parameters></sql></parameter></query></Map>"]
["MapImage","<Map name=\"\" worksheet=\"DT LTE Plots (anchored)\" id=\"14\" left=\"0\" top=\"1107.3333333333333\" width=\"747.42449373006821\" height=\"463.06666666666661\" maptype=\"Google street\" map=\"\" colorset=\"Serving system and band;\" aspect=\"Fill\" parametersOnSeparateMaps=\"false\" measurementsOnSeparateMaps=\"false\" floorplansOnSeparateMaps=\"false\" filterUnusedRanges=\"false\" SortByColorCount=\"false\" drawGPSRoute=\"false\" gpsRouteColor=\"#5EFFF5\" interpolateRoute=\"false\" drawScaleBar=\"true\" scaleBarSize=\"100\" linewidth=\"8\" uselogmap=\"false\" showMarker=\"false\" samplingtype=\"Default\" scalebarPlacement=\"Bottom Right\" btsColumn=\"lte_physical_layer_cell_id\" btsColorset=\"Physical cell identity\" showSiteLabel=\"true\" defaultBTSFilter=\"true\" allBTSFiltersToggled=\"true\" showSiteLabelHighlight=\"true\" siteLabelHighlightColor=\"#FFFFFF\" showBTS=\"true\" showBTSColorLegend=\"false\" btsWildcardText=\"\" btsFiles=\"base_4G final.nbf;\" btsFilters=\"NR,system,True;UMTS,system,True;Unknown,system,True;0,channel,True;65535,channel,True;3024,channel,True;\" btsCustomFilters=\"\" btsPieSizeFactor=\"2\" btsLabelSizeFactor=\"2\" btsLabelDataColumns=\"\" cloudBTS=\"false\" cloudConnection=\"\" snapToCell=\"true\" osmServerURL=\"default\" osmServerLayerName=\"\" osmServerLayerStyle=\"\" osmServerLayerCRS=\"\" osmServerLayerTitle=\"\" mapAreaType=\"Measurement route\" mapOffset=\"0\" mapAreaPolygonFile=\"\" SplitMapFlag=\"false\" SplitMapColumnName=\"System and band\" SplitMapColumnCaption=\"System and band\" SplitMapFlagH=\"false\" SplitMapColumnNameH=\"System and band\" SplitMapColumnCaptionH=\"System and band\" ColumnSpacing=\"2\" RowSpacing=\"3\" SnapRow=\"55\" SnapColumn=\"0\" SnapRowBottom=\"78\" SnapColumnRight=\"11\" MapLegendPosition=\"Right\" EnableGrid=\"false\" GridUnit=\"Kilometers\" GridSize=\"100\" GridLineWidth=\"1\" GridColor=\"#2F4F4F\" DrawPolygons=\"false\" PolygonDelimiter=\"\" PolygonComboIndexes=\"\" PolygonLabelHighlightColor=\"#FFFFFF\" ShowPolygonLabelHighlight=\"false\" ShowPolygonLabel=\"false\" PolygonLabelSizeFactor=\"3\" UseIntervalLimiter=\"false\" IntervalLimiter=\"0\" EventIconSizeFactor=\"3\" InbuildingMapNorthIsUp=\"true\"><query sheet=\"DT LTE Plots (anchored)\" row=\"0\" column=\"0\"><column_settings><column name=\"cellular_system_band\" title=\"Band\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"System and band\" title=\"System and band\" type=\"string\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /></column_settings><parameter device=\"0\" filter_level=\"0\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"np_serving_system_and_frequency\" title=\"Serving system and band\" system=\"TETRA;GSM;UMTS TDD;UMTS FDD;CdmaOne;Cdma2000;AMPS;TDMA;LTE FDD;LTE TDD;iDEN;NR\" color_set=\"Serving system and band\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"GSM\" /><group name=\"UMTS\" /><group name=\"CDMA\" /><group name=\"TDMA\" /><group name=\"AMPS\" /><group name=\"TETRA\" /><group name=\"GAN\" /><group name=\"LTE\" /><group name=\"NB-IoT\" /><group name=\"iDEN\" /><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND \" postfix=\"\" /><sql tail=\"{!columns}{!qsr_columns} FROM Nemo.Event_ WHERE event_id = 'CHI'  AND file_id = {!file} {!filter} ORDER BY &quot;_exclude_order&quot;, &quot;_exclude_order_2&quot; ,lr_id \"><columns><column name=\"SB_2_FF2SB(the_serving_system, the_serving_band_downlink, the_serving_band_uplink) AS cellular_system_band\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"VAL_TO_STRING('cellular_system_band',SB_2_FF2SB(the_serving_system, the_serving_band_downlink, the_serving_band_uplink)) AS &quot;Band&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"VAL_TO_STRING('the_serving_system', &quot;the_serving_system&quot;) || ' ' || (&quot;the_serving_band&quot;)::text\" output_name=\"System and band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"&quot;sql_time&quot; AS &quot;_exclude_order&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"to_interval(&quot;time&quot;) AS &quot;_exclude_order_2&quot;\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Color set\" column=\"Band\" quotes=\"true\" /><alias name=\"System\" column=\"the_serving_system\" quotes=\"true\" /><alias name=\"Band\" column=\"the_serving_band\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"Description\" column=\"the_serving_system\" quotes=\"true\" /><alias name=\"Group by\" column=\"cellular_system_band\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"cellular_system_band\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"cellular_system_band\" quotes=\"true\" /></aliases></sql><qsr value_column=\"qsr_duration\" value_parameter=\"\" direction=\"up\" min=\"0\" max=\"100\" interval=\"0\" threshold=\"50\" condition=\"&lt;\" default_action=\"0\" discrete_column=\"cellular_system_band\" statistics=\"count, discrete\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></Map>"]
["ReportChart","<ReportChart Name=\"Report_Chart_DT NR Histogram_ID18\" Worksheet=\"DT NR Histogram\" Id=\"18\" ChartType=\"Line\" SnapToCell=\"true\" RowEnd=\"26\" ColumnEnd=\"24\" Row=\"3\" Column=\"13\" PieXColumn=\"\" PieDescriptionColumn=\"\" ScatterXColumn=\"time\" ScatterYColumn=\"{?N}. best RSRP\"><chartitem LineWidth=\"1\" SeriesColor=\"#FF9966\" SeriesColorAuto=\"true\" ScaleAutomaticValues=\"true\" ScaleTop=\"-35\" ScaleBottom=\"-140\" MarkerStyle=\"Circle\"><query sheet=\"DT NR Histogram\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best RSRP\" title=\"1. best RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"Band (MHz)\" title=\"Band (MHz)\" type=\"int32\" format=\"0\" /><column name=\"NR PCI Beam index\" title=\"NR PCI Beam index\" type=\"string\" /><column name=\"_oid\" title=\"_oid\" type=\"int64\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /><column name=\"the_device\" title=\"the_device\" type=\"int64\" format=\"0\" /></column_settings><parameter device=\"0\" filter_level=\"2\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_rsrp\" title=\"SS-RSRP Nth best\" color_set=\"RSRP (dBm)\" description=\"SS-RSRP of the Nth strongest cell/beam\" query_title=\"RSRP {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, 'select * from Nemo.SCRIPT(&lt;#39:1&gt;nemo.analyze.kpi.QueryWithTimeBasedEventBlocks&lt;#39:1&gt;,&lt;#39:1&gt;\" postfix=\"&lt;#39:1&gt;) as (&quot;the_event&quot; bigint,&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;          &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;          &quot;gps_longitude&quot; double precision,&#xD;&#xA;          &quot;gps_latitude&quot; double precision,&#xD;&#xA;          &quot;gps_height&quot; smallint,&#xD;&#xA;          &quot;_exclude_sql_time&quot; timestamp,&#xD;&#xA;          _exclude_time_interval bigint,&#xD;&#xA;          &quot;the_device&quot; bigint&#xD;&#xA;          {!qsr_output_columns} )') &#xD;&#xA;        as (&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;        &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;        &quot;gps_longitude&quot; double precision,&#xD;&#xA;        &quot;gps_latitude&quot; double precision,&#xD;&#xA;        &quot;gps_height&quot; smallint,&#xD;&#xA;        &quot;_exclude_sql_time&quot; timestamp without time zone,&#xD;&#xA;        _exclude_time_interval bigint, &#xD;&#xA;        &quot;the_device&quot; bigint&#xD;&#xA;        {!qsr_output_columns} )\" tail=\"{!columns}, sql_time, time_interval {!procedure_qsr_columns}  FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type}  AND x.file_id = {!file} {!procedure_filter}  &lt;#39:1&gt;, &lt;#39:1&gt;&lt;#39:1&gt;, &lt;#39:1&gt;\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"{?N}. best RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:2&gt;cellular_system_band_int&lt;#39:2&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"((nr_pci)::text || &lt;#39:2&gt;_&lt;#39:2&gt; || (nr_beam_index)::text)\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best RSRP\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best RSRP\" value_parameter=\"nr_rp\" direction=\"up\" min=\"-140\" max=\"-35\" interval=\"10\" threshold=\"-90\" condition=\"&lt;\" default_action=\"folder, measurement\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></chartitem></ReportChart>"]
["ReportChart","<ReportChart Name=\"Report_Chart_DT NR Histogram_ID19\" Worksheet=\"DT NR Histogram\" Id=\"19\" ChartType=\"Line\" SnapToCell=\"true\" RowEnd=\"52\" ColumnEnd=\"40\" Row=\"22\" Column=\"28\" PieXColumn=\"\" PieDescriptionColumn=\"\" ScatterXColumn=\"\" ScatterYColumn=\"\" />"]
["ReportChart","<ReportChart Name=\"Report_Chart_DT NR Histogram_ID20\" Worksheet=\"DT NR Histogram\" Id=\"20\" ChartType=\"Pie\" SnapToCell=\"true\" RowEnd=\"26\" ColumnEnd=\"11\" Row=\"3\" Column=\"0\" PieXColumn=\"1. best RSRP\" PieDescriptionColumn=\"\" ScatterXColumn=\"time\" ScatterYColumn=\"{?N}. best RSRP\"><chartitem LineWidth=\"2\" SeriesColor=\"#FF9966\" SeriesColorAuto=\"true\" ScaleAutomaticValues=\"true\" ScaleTop=\"-35\" ScaleBottom=\"-140\" MarkerStyle=\"Circle\"><query sheet=\"DT NR Histogram\" row=\"0\" column=\"0\"><column_settings><column name=\"1. best RSRP\" title=\"1. best RSRP\" type=\"single\" format=\"0.0##\" /><column name=\"time\" title=\"Time\" type=\"datetime\" format=\"h:mm:ss.000\" /><column name=\"nr_arfcn\" title=\"NR-ARFCN\" type=\"int32\" format=\"0\" /><column name=\"nr_pci\" title=\"PCI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_index\" title=\"BI\" type=\"int16\" format=\"0\" /><column name=\"nr_beam_type\" title=\"BT\" type=\"int32\" format=\"0\" /><column name=\"Band\" title=\"Band\" type=\"string\" /><column name=\"Band (MHz)\" title=\"Band (MHz)\" type=\"int32\" format=\"0\" /><column name=\"NR PCI Beam index\" title=\"NR PCI Beam index\" type=\"string\" /><column name=\"_oid\" title=\"_oid\" type=\"int64\" format=\"0\" /><column name=\"gps_longitude\" title=\"Lon.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_latitude\" title=\"Lat.\" type=\"double\" format=\"0.0#####\" /><column name=\"gps_height\" title=\"Height\" type=\"int16\" format=\"0\" /><column name=\"the_device\" title=\"the_device\" type=\"int64\" format=\"0\" /></column_settings><parameter device=\"0\" filter_level=\"2\" menu=\"0\" number_presentation=\"default\" scope=\"true\" id=\"nr_np_nth_best_rsrp\" title=\"SS-RSRP Nth best\" color_set=\"RSRP (dBm)\" description=\"SS-RSRP of the Nth strongest cell/beam\" query_title=\"RSRP {?N}. best\"><btsFileFilter btsWildcardText=\"\" btsSelectedFiles=\"\" /><groups><group name=\"5G\" /></groups><filters basic_filters=\"header, device, measurement\" prefix=\"AND (\" postfix=\")\" /><sql prefix=\"select * from Nemo.Nth_BEST({?N}, 0, 1, 0, 'select * from Nemo.SCRIPT(&lt;#39:1&gt;nemo.analyze.kpi.QueryWithTimeBasedEventBlocks&lt;#39:1&gt;,&lt;#39:1&gt;\" postfix=\"&lt;#39:1&gt;) as (&quot;the_event&quot; bigint,&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;          &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;          &quot;gps_longitude&quot; double precision,&#xD;&#xA;          &quot;gps_latitude&quot; double precision,&#xD;&#xA;          &quot;gps_height&quot; smallint,&#xD;&#xA;          &quot;_exclude_sql_time&quot; timestamp,&#xD;&#xA;          _exclude_time_interval bigint,&#xD;&#xA;          &quot;the_device&quot; bigint&#xD;&#xA;          {!qsr_output_columns} )') &#xD;&#xA;        as (&quot;{?N}. best RSRP&quot; real,&#xD;&#xA;        &quot;time&quot; bytea,&quot;nr_arfcn&quot; integer,&quot;nr_pci&quot; smallint,&quot;nr_beam_index&quot; smallint,&quot;nr_beam_type&quot; integer,&quot;Band&quot; text,&quot;Band (MHz)&quot; integer,&quot;NR PCI Beam index&quot; text,&quot;_oid&quot; bigint,&#xD;&#xA;        &quot;gps_longitude&quot; double precision,&#xD;&#xA;        &quot;gps_latitude&quot; double precision,&#xD;&#xA;        &quot;gps_height&quot; smallint,&#xD;&#xA;        &quot;_exclude_sql_time&quot; timestamp without time zone,&#xD;&#xA;        _exclude_time_interval bigint, &#xD;&#xA;        &quot;the_device&quot; bigint&#xD;&#xA;        {!qsr_output_columns} )\" tail=\"{!columns}, sql_time, time_interval {!procedure_qsr_columns}  FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(&quot;nr_beam_type&quot;, -999) {?NR Beam type}  AND x.file_id = {!file} {!procedure_filter}  &lt;#39:1&gt;, &lt;#39:1&gt;&lt;#39:1&gt;, &lt;#39:1&gt;\"><columns><column name=\"the_event\" output_name=\"\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_rp\" output_name=\"{?N}. best RSRP\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"time\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_arfcn\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_pci\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_index\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"nr_beam_type\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"VAL_TO_STRING(&lt;#39:2&gt;cellular_system_band_int&lt;#39:2&gt;, cellular_system_band_int)\" output_name=\"Band\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END \" output_name=\"Band (MHz)\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"((nr_pci)::text || &lt;#39:2&gt;_&lt;#39:2&gt; || (nr_beam_index)::text)\" output_name=\"NR PCI Beam index\" type=\"string\" quotes=\"false\" default=\"false\" /><column name=\"nr_pci::int8*1000 +nr_beam_index AS _oid\" output_name=\"\" type=\"number\" quotes=\"false\" default=\"false\" /><column name=\"gps_longitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_latitude\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /><column name=\"gps_height\" output_name=\"\" type=\"string\" quotes=\"true\" default=\"false\" /></columns><aliases><alias name=\"Time\" column=\"time\" quotes=\"true\" /><alias name=\"Line X\" column=\"time\" quotes=\"true\" /><alias name=\"Line Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Correlate\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Scatter X\" column=\"time\" quotes=\"true\" /><alias name=\"Scatter Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Bar Y\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Color set\" column=\"{?N}. best RSRP\" quotes=\"true\" /><alias name=\"Longitude\" column=\"gps_longitude\" quotes=\"true\" /><alias name=\"Latitude\" column=\"gps_latitude\" quotes=\"true\" /><alias name=\"3D value\" column=\"{?N}. best RSRP\" quotes=\"true\" /></aliases><parameters><parameter id=\"N\" default=\"1\" /><parameter id=\"NR Beam type\" default=\"Any\"><value text=\"Any\" enum=\"!= -1\" /><value text=\"Detected beam\" enum=\"= 0\" /><value text=\"Serving beam\" enum=\"&gt;= 1\" /></parameter></parameters></sql><qsr value_column=\"{?N}. best RSRP\" value_parameter=\"nr_rp\" direction=\"up\" min=\"-140\" max=\"-35\" interval=\"10\" threshold=\"-90\" condition=\"&lt;\" default_action=\"folder, measurement\" selected_type=\"qsr\"><option type=\"time\" duration_column=\"time_interval AS qsr_duration\" /><option type=\"distance\" duration_column=\"distance_interval AS qsr_duration\" /><option type=\"sample\" duration_column=\"1 as qsr_duration\" /></qsr></parameter></query></chartitem></ReportChart>"]

{"sheet":"Report log","index":4,"n_rows":397,"n_cols":2,"rows_kept":397,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0,"Report execution started 05/04/2025 10:29:03."]
[0.02,"Handling map image configuration 1/20 to worksheet."]
[2.1999999999999999E-2,"Started executing query: np_nr_ss_pci_nth_best_selected_carrier"]
[2.1999999999999999E-2,"BuildSQL"]
[2.1999999999999999E-2,"Check SQL attributes"]
[2.1999999999999999E-2,"Build columns"]
[2.1999999999999999E-2,"Check statistics columns"]
[2.1999999999999999E-2,"Replace placeholders"]
[2.1999999999999999E-2,"BuildSQL finished"]
[2.1999999999999999E-2,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT the_event,\"nr_rp\",\"time\",\"nr_pci\",\"nr_arfcn\",\"nr_beam_index\",\"nr_beam_type\",\"gps_longitude\",\"gps_latitude\"  FROM Nemo.NR_CELLMEAS_Cell_ WHERE nr_rp IS NOT NULL AND nr_arfcn > 0 AND nr_meas_type = 1  AND file_id = MEAS1(''rue_asma_dt_dl:1'')  order by lr_id ') as (\"nr_rp\" real,\"time\" bytea,\"nr_pci\" smallint,\"nr_arfcn\" integer,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"gps_longitude\" double precision,\"gps_latitude\" double precision )"]
[2.1999999999999999E-2,"run query  "]
[5.0999999999999997E-2,"Query was finished in 0,029 seconds, 312 row(s). Time 05/04/2025 10:29:03"]
[5.2999999999999999E-2,"Started executing query: "]
[5.2999999999999999E-2,"BuildSQL"]
[5.2999999999999999E-2,"Check SQL attributes"]
[5.2999999999999999E-2,"Build columns"]
[5.2999999999999999E-2,"Check statistics columns"]
[5.2999999999999999E-2,"Replace placeholders"]
[5.2999999999999999E-2,"BuildSQL finished"]
[5.2999999999999999E-2,"Full SQL: SELECT *, VAL_TO_STRING('the_serving_system', \"bts_system\") bts_system_text FROM \"bts\".\"site\"\r\n                    INNER JOIN \"bts\".\"cell\" ON\r\n                    \"bts\".\"site\".\"lr_id\"=\"bts\".\"cell\".\"the_site\" Where bts.site.bts_file_id=ANY(BTS('Base 5G.nbf'))"]
[5.2999999999999999E-2,"run query  "]
[8.4000000000000005E-2,"Query was finished in 0,031 seconds, 664 row(s). Time 05/04/2025 10:29:03"]
[0.42299999999999999,"Handling map image configuration 2/20 to worksheet."]
[1.232,"Started executing query: nr_np_nth_best_selected_cell_type_rsrp"]
[1.232,"BuildSQL"]
[1.232,"Check SQL attributes"]
[1.232,"Build columns"]
[1.232,"Check statistics columns"]
[1.232,"Replace placeholders"]
[1.232,"BuildSQL finished"]
[1.232,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT \"the_event\",\"nr_rp\" AS \"1. best < 1000 RSRP\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''cellular_system_band_int'', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",(nr_pci)::text || ''_'' || (nr_beam_index)::text AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"gps_longitude\",\"gps_latitude\" FROM Nemo.NR_CELLMEAS_Cell_ x WHERE  nr_meas_type = 1 AND \"nr_cell_type\" < 1000  AND x.file_id = MEAS1(''rue_asma_dt_dl:1'')  order by x.lr_id ') \r\n\t\t\t\tas \r\n\t\t\t\t(\"1. best < 1000 RSRP\" real,\r\n\t\t\t\t\"time\" bytea,\r\n\t\t\t\t\"nr_arfcn\" integer,\r\n\t\t\t\t\"nr_pci\" smallint,\r\n\t\t\t\t\"nr_beam_index\" smallint,\r\n\t\t\t\t\"nr_beam_type\" integer,\r\n\t\t\t\t\"Band\" text,\r\n\t\t\t\t\"Band (MHz)\" integer,\r\n\t\t\t\t\"NR PCI Beam index\" text,\r\n\t\t\t\t\"_oid\" bigint,\r\n\t\t\t\t\"gps_longitude\" double precision,\r\n\t\t\t\t\"gps_latitude\" double precision )"]
[1.232,"run query  "]
[1.248,"Query was finished in 0,016 seconds, 312 row(s). Time 05/04/2025 10:29:04"]
[1.774,"Handling map image configuration 3/20 to worksheet."]
[1.776,"Started executing query: nr_np_nth_best_rsrq"]
[1.776,"BuildSQL"]
[1.776,"Check SQL attributes"]
[1.776,"Build columns"]
[1.776,"Check statistics columns"]
[1.776,"Replace placeholders"]
[1.776,"BuildSQL finished"]
[1.776,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT \"the_event\",\"nr_rq\" AS \"1. best RSRQ\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''cellular_system_band_int'', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",(nr_pci)::text || ''_'' || (nr_beam_index)::text AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"the_parent\" AS \"the_parent\",\"gps_longitude\",\"gps_latitude\",\"gps_height\"\r\n                FROM Nemo.NR_CELLMEAS_Cell_ x \r\n                WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1  AND x.file_id = MEAS1(''rue_asma_dt_dl:1'') ') as (\"1. best RSRQ\" real,\"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\"the_parent\" bigint,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint )"]
[1.776,"run query  "]
[1.7929999999999999,"Query was finished in 0,016 seconds, 312 row(s). Time 05/04/2025 10:29:05"]
[2.0030000000000001,"Handling map image configuration 4/20 to worksheet."]
[2.0049999999999999,"Started executing query: nr_np_sinr_nth_best"]
[2.0049999999999999,"BuildSQL"]
[2.0049999999999999,"Check SQL attributes"]
[2.0049999999999999,"Build columns"]
[2.0049999999999999,"Check statistics columns"]
[2.0049999999999999,"Replace placeholders"]
[2.0049999999999999,"BuildSQL finished"]
[2.0049999999999999,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT the_event,nr_rp AS \"1. best SS-RSRP\",nr_sinr AS \"1. best SS-SINR\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''cellular_system_band_int'', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",(nr_pci)::text || ''_'' || (nr_beam_index)::text AS \"NR PCI Beam index\",\"gps_longitude\",\"gps_latitude\",\"gps_height\"\r\n                FROM Nemo.NR_CELLMEAS_Cell_ \r\n                WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1 AND nr_sinr IS NOT NULL  AND file_id = MEAS1(''rue_asma_dt_dl:1'') ') as (\"1. best SS-RSRP\" real,\"1. best SS-SINR\" real,\"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint )"]
[2.0049999999999999,"run query  "]
[2.0179999999999998,"Query was finished in 0,013 seconds, 312 row(s). Time 05/04/2025 10:29:05"]
[2.2330000000000001,"Handling map image configuration 5/20 to worksheet."]
[2.234,"Started executing query: nr_mac_dl_bit_rate"]
[2.234,"BuildSQL"]
[2.234,"Check SQL attributes"]
[2.234,"Build columns"]
[2.234,"Check statistics columns"]
[2.234,"Replace placeholders"]
[2.234,"BuildSQL finished"]
[2.234,"Full SQL: SELECT \"time\",CAST(nr_mac_dl_bit_rate as double precision) AS \"nr_mac_dl_bit_rate\",\"nr_serving_cell_type\",\"gps_longitude\",\"gps_latitude\",\"gps_height\" FROM Nemo.NR_MACRATE_ x WHERE (nr_serving_cell_type < 1000)  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[2.234,"run query  "]
[2.2469999999999999,"Query was finished in 0,012 seconds, 309 row(s). Time 05/04/2025 10:29:05"]
[2.4550000000000001,"Handling map image configuration 6/20 to worksheet."]
[2.456,"Started executing query: nr_mac_ul_bit_rate"]
[2.456,"BuildSQL"]
[2.456,"Check SQL attributes"]
[2.456,"Build columns"]
[2.456,"Check statistics columns"]
[2.456,"Replace placeholders"]
[2.4569999999999999,"BuildSQL finished"]
[2.4569999999999999,"Full SQL: SELECT \"time\",\"nr_mac_ul_bit_rate\",\"nr_serving_cell_type\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.NR_MACRATEU_ x WHERE (nr_serving_cell_type < 1000)  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[2.4569999999999999,"run query  "]
[2.4649999999999999,"Query was finished in 0,008 seconds, 309 row(s). Time 05/04/2025 10:29:06"]
[2.6749999999999998,"Handling map image configuration 7/20 to worksheet."]
[2.6760000000000002,"Started executing query: nr_rank_indicator"]
[2.6760000000000002,"BuildSQL"]
[2.6760000000000002,"Check SQL attributes"]
[2.6760000000000002,"Build columns"]
[2.6760000000000002,"Check statistics columns"]
[2.6760000000000002,"Replace placeholders"]
[2.6760000000000002,"BuildSQL finished"]
[2.6760000000000002,"Full SQL: SELECT \"time\",\"nr_rank_indicator\",\"nr_serving_cell_type\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.NR_CQI_ x WHERE (nr_serving_cell_type < 1000)  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[2.6760000000000002,"run query  "]
[2.6840000000000002,"Query was finished in 0,007 seconds, 309 row(s). Time 05/04/2025 10:29:06"]
[2.8969999999999998,"Handling map image configuration 8/20 to worksheet."]
[2.899,"Started executing query: nr_la_dl_scheduled_modulation_0"]
[2.899,"BuildSQL"]
[2.899,"Check SQL attributes"]
[2.899,"Build columns"]
[2.899,"Check statistics columns"]
[2.899,"Replace placeholders"]
[2.899,"BuildSQL finished"]
[2.899,"Full SQL: SELECT time,nr_la_dl_scheduled_modulation_0 AS \"nr_la_dl_scheduled_modulation_0\",VAL_TO_STRING('nr_la_dl_scheduled_modulation_0',nr_la_dl_scheduled_modulation_0) AS \"Modulation CW0\",nr_serving_cell_type,gps_longitude,gps_latitude FROM Nemo.NR_PLAID_ x WHERE (x.nr_serving_cell_type < 1000)  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[2.899,"run query  "]
[2.9119999999999999,"Query was finished in 0,013 seconds, 309 row(s). Time 05/04/2025 10:29:06"]
[3.121,"Handling map image configuration 9/20 to worksheet."]
[3.1219999999999999,"Started executing query: lte_nr_total_mac_dl_bit_rate"]
[3.1219999999999999,"BuildSQL"]
[3.1219999999999999,"Check SQL attributes"]
[3.1219999999999999,"Build columns"]
[3.1219999999999999,"Check statistics columns"]
[3.1219999999999999,"Replace placeholders"]
[3.1219999999999999,"BuildSQL finished"]
[3.1219999999999999,"Full SQL: select * from Nemo.SCRIPT('nemo.analyze.kpi.Query_2_Sum','SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as \"Interval\",                  SUM(CAST(lte_mac_dl_bit_rate as double precision)) as \"lte_mac_dl_bit_rate\",                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order                   FROM Nemo.LTE_MACRATE_ x                  WHERE 0 = 0  AND x.file_id = MEAS1(''rue_asma_dt_dl:1'')                   GROUP BY sql_time  ,x.lr_id ORDER BY _exclude_order   ,x.lr_id ;SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as \"Interval\",                  SUM(CAST(nr_mac_dl_bit_rate as double precision)) as \"nr_mac_dl_bit_rate\",                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order                   FROM Nemo.NR_MACRATE_ x                  WHERE 0 = 0 AND x.file_id = MEAS1(''rue_asma_dt_dl:1'')                    GROUP BY sql_time ,x.lr_id  ORDER BY _exclude_order  ,x.lr_id  ;Interval:1;GROUP_BY:sql_time,time,gps_longitude,gps_latitude,gps_height;add:lte_mac_dl_bit_rate,nr_mac_dl_bit_rate,lte_mac_dl_bit_rate_total;qsr:','','file_id=MEAS1(''rue_asma_dt_dl:1'')') as (\"sql_time\" timestamp,\"time\" bytea,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint,\"lte_mac_dl_bit_rate\" double precision,\"nr_mac_dl_bit_rate\" double precision     ,\"lte_mac_dl_bit_rate_total\" double precision)"]
[3.1219999999999999,"run query  "]
[3.2029999999999998,"Query was finished in 0,08 seconds, 318 row(s). Time 05/04/2025 10:29:06"]
[3.4180000000000001,"Handling map image configuration 10/20 to worksheet."]
[3.419,"Started executing query: nr_pscell_arfcn_mobile"]
[3.419,"BuildSQL"]
[3.419,"Check SQL attributes"]
[3.419,"Build columns"]
[3.419,"Check statistics columns"]
[3.419,"Replace placeholders"]
[3.419,"BuildSQL finished"]
[3.419,"Full SQL: SELECT DISTINCT time,the_measured_system,nr_arfcn,the_device_title || '.' || the_device_extension AS _exclude_order_1,sql_time AS _exclude_order_2,gps_longitude,gps_latitude FROM Nemo.NR_CELLMEAS_Cell_ WHERE (nr_arfcn IS NOT NULL AND nr_arfcn > 0) AND nr_cell_type IN(0, 199) AND (nr_beam_type = 1 OR nr_beam_type IS NULL) AND the_measured_system = 4194304  AND file_id = MEAS1('rue_asma_dt_dl:1')  ORDER BY _exclude_order_1, _exclude_order_2 "]
[3.419,"run query  "]
[3.4289999999999998,"Query was finished in 0,01 seconds, 312 row(s). Time 05/04/2025 10:29:06"]
[3.6360000000000001,"Handling map image configuration 11/20 to worksheet."]
[3.637,"Started executing query: nr_pusch_tx_power"]
[3.637,"BuildSQL"]
[3.637,"Check SQL attributes"]
[3.637,"Build columns"]
[3.637,"Check statistics columns"]
[3.637,"Replace placeholders"]
[3.637,"BuildSQL finished"]
[3.637,"Full SQL: SELECT \"time\",\"nr_pusch_tx_power\",\"nr_serving_cell_type\",\"nr_sul_indication\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.NR_TXPC_ x WHERE nr_pusch_tx_power IS NOT NULL  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[3.637,"run query  "]
[3.65,"Query was finished in 0,012 seconds, 309 row(s). Time 05/04/2025 10:29:07"]
[3.86,"Handling map image configuration 12/20 to worksheet."]
[3.863,"Started executing query: np_nr_ss_BI_nth_best_selected_carrier"]
[3.863,"BuildSQL"]
[3.863,"Check SQL attributes"]
[3.863,"Build columns"]
[3.863,"Check statistics columns"]
[3.863,"Replace placeholders"]
[3.863,"BuildSQL finished"]
[3.863,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT the_event,\"nr_rp\",\"time\",nr_beam_index AS \"BI 1. best\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.NR_CELLMEAS_Cell_ WHERE nr_meas_type = 1 AND nr_rp IS NOT NULL AND nr_arfcn > 0   AND file_id = MEAS1(''rue_asma_dt_dl:1'')  order by lr_id ') as (\"nr_rp\" real,\"time\" bytea,\"BI 1. best\" smallint,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"gps_longitude\" double precision,\"gps_latitude\" double precision )"]
[3.863,"run query  "]
[3.875,"Query was finished in 0,012 seconds, 312 row(s). Time 05/04/2025 10:29:07"]
[4.0810000000000004,"Handling map image configuration 13/20 to worksheet."]
[4.0830000000000002,"Started executing query: lte_physical_layer_cell_id"]
[4.0830000000000002,"BuildSQL"]
[4.0830000000000002,"Check SQL attributes"]
[4.0830000000000002,"Build columns"]
[4.0830000000000002,"Check statistics columns"]
[4.0830000000000002,"Replace placeholders"]
[4.0830000000000002,"BuildSQL finished"]
[4.0830000000000002,"Full SQL: SELECT \"time\",\"lte_physical_layer_cell_id\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.LTE_CHI_ x  WHERE x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[4.0830000000000002,"run query  "]
[4.093,"Query was finished in 0,01 seconds, 24 row(s). Time 05/04/2025 10:29:07"]
[4.093,"Started executing query: "]
[4.093,"BuildSQL"]
[4.093,"Check SQL attributes"]
[4.093,"Build columns"]
[4.093,"Check statistics columns"]
[4.093,"Replace placeholders"]
[4.093,"BuildSQL finished"]
[4.093,"Full SQL: SELECT *, VAL_TO_STRING('the_serving_system', \"bts_system\") bts_system_text FROM \"bts\".\"site\"\r\n                    INNER JOIN \"bts\".\"cell\" ON\r\n                    \"bts\".\"site\".\"lr_id\"=\"bts\".\"cell\".\"the_site\" Where bts.site.bts_file_id=ANY(BTS('base_4G final.nbf'))"]
[4.093,"run query  "]
[4.1779999999999999,"Query was finished in 0,085 seconds, 4041 row(s). Time 05/04/2025 10:29:07"]
[4.3769999999999998,"Handling map image configuration 14/20 to worksheet."]
[4.3780000000000001,"Started executing query: np_nth_best_rsrp"]
[4.3780000000000001,"BuildSQL"]
[4.3780000000000001,"Check SQL attributes"]
[4.3780000000000001,"Build columns"]
[4.3780000000000001,"Check statistics columns"]
[4.3780000000000001,"Replace placeholders"]
[4.3780000000000001,"BuildSQL finished"]
[4.3780000000000001,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT \"the_event\",\"lte_received_power\" AS \"1. best RSRP\",\"time\",\"channel_number\",\"lte_physical_layer_cell_id\",\"gps_longitude\",\"gps_latitude\"  FROM Nemo.LTE_CELLMEAS_Cell_ x   WHERE x.file_id = MEAS1(''rue_asma_dt_dl:1'')  order by x.lr_id ') as (\"1. best RSRP\" real,\"time\" bytea,\"channel_number\" integer,\"lte_physical_layer_cell_id\" smallint,\"gps_longitude\" double precision,\"gps_latitude\" double precision )"]
[4.3780000000000001,"run query  "]
[4.45,"Query was finished in 0,071 seconds, 313 row(s). Time 05/04/2025 10:29:08"]
[4.8499999999999996,"Handling map image configuration 15/20 to worksheet."]
[4.851,"Started executing query: np_nth_bestt_rsrq"]
[4.851,"BuildSQL"]
[4.851,"Check SQL attributes"]
[4.851,"Build columns"]
[4.851,"Check statistics columns"]
[4.851,"Replace placeholders"]
[4.851,"BuildSQL finished"]
[4.851,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, ' SELECT \"the_event\",\"lte_received_power\",\"lte_received_quality\" AS \"1. best RSRQ\",\"time\",\"channel_number\",\"lte_physical_layer_cell_id\",\"gps_longitude\",\"gps_latitude\"  FROM Nemo.LTE_CELLMEAS_Cell_ x  WHERE x.file_id = MEAS1(''rue_asma_dt_dl:1'')  order by x.lr_id ') as (\"lte_received_power\" real,\"1. best RSRQ\" real,\"time\" bytea,\"channel_number\" integer,\"lte_physical_layer_cell_id\" smallint,\"gps_longitude\" double precision,\"gps_latitude\" double precision )"]
[4.851,"run query  "]
[4.9020000000000001,"Query was finished in 0,05 seconds, 313 row(s). Time 05/04/2025 10:29:08"]
[4.9029999999999996,"Started executing query: "]
[4.9029999999999996,"BuildSQL"]
[4.9029999999999996,"Check SQL attributes"]
[4.9029999999999996,"Build columns"]
[4.9029999999999996,"Check statistics columns"]
[4.9029999999999996,"Replace placeholders"]
[4.9029999999999996,"BuildSQL finished"]
[4.9029999999999996,"Full SQL: SELECT *, VAL_TO_STRING('the_serving_system', \"bts_system\") bts_system_text FROM \"bts\".\"site\"\r\n                    INNER JOIN \"bts\".\"cell\" ON\r\n                    \"bts\".\"site\".\"lr_id\"=\"bts\".\"cell\".\"the_site\" Where bts.site.bts_file_id=ANY(BTS('Base 5G.nbf|base_4G final.nbf'))"]
[4.9029999999999996,"run query  "]
[4.9989999999999997,"Query was finished in 0,096 seconds, 4705 row(s). Time 05/04/2025 10:29:08"]
[5.4260000000000002,"Handling map image configuration 16/20 to worksheet."]
[5.4269999999999996,"Started executing query: lte_rs_snr"]
[5.4269999999999996,"BuildSQL"]
[5.4269999999999996,"Check SQL attributes"]
[5.4269999999999996,"Build columns"]
[5.4269999999999996,"Check statistics columns"]
[5.4269999999999996,"Replace placeholders"]
[5.4269999999999996,"BuildSQL finished"]
[5.4269999999999996,"Full SQL: SELECT \"time\",\"lte_rs_snr\",\"lte_serving_cell_type\",\"gps_longitude\",\"gps_latitude\",\"gps_height\" FROM Nemo.LTE_CI_ x WHERE (lte_serving_cell_type = 0 OR lte_serving_cell_type IS NULL) AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[5.4269999999999996,"run query  "]
[5.4390000000000001,"Query was finished in 0,011 seconds, 313 row(s). Time 05/04/2025 10:29:09"]
[5.4390000000000001,"Started executing query: "]
[5.4390000000000001,"BuildSQL"]
[5.44,"Check SQL attributes"]
[5.44,"Build columns"]
[5.44,"Check statistics columns"]
[5.44,"Replace placeholders"]
[5.44,"BuildSQL finished"]
[5.44,"Full SQL: SELECT *, VAL_TO_STRING('the_serving_system', \"bts_system\") bts_system_text FROM \"bts\".\"site\"\r\n                    INNER JOIN \"bts\".\"cell\" ON\r\n                    \"bts\".\"site\".\"lr_id\"=\"bts\".\"cell\".\"the_site\" Where bts.site.bts_file_id=ANY(BTS('base_4G final.nbf'))"]
[5.44,"run query  "]
[5.524,"Query was finished in 0,084 seconds, 4041 row(s). Time 05/04/2025 10:29:09"]
[5.915,"Handling map image configuration 17/20 to worksheet."]
[5.9160000000000004,"Started executing query: lte_cqi_subband_cqi_0"]
[5.9160000000000004,"BuildSQL"]
[5.9160000000000004,"Check SQL attributes"]
[5.9160000000000004,"Build columns"]
[5.9160000000000004,"Check statistics columns"]
[5.9160000000000004,"Replace placeholders"]
[5.9160000000000004,"BuildSQL finished"]
[5.9160000000000004,"Full SQL: SELECT \"time\",\"lte_cqi_subband_index\",\"lte_cqi_subband_cqi_0\",\"lte_serving_cell_type\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.LTE_CQI_SubBand_ x WHERE (lte_serving_cell_type = 0 OR lte_serving_cell_type IS NULL)  AND x.file_id = MEAS1('rue_asma_dt_dl:1')  order by x.lr_id "]
[5.9160000000000004,"run query  "]
[5.9850000000000003,"Query was finished in 0,069 seconds, 2745 row(s). Time 05/04/2025 10:29:09"]
[6.5049999999999999,"Handling map image configuration 18/20 to worksheet."]
[6.5069999999999997,"Started executing query: np_la_dl_modulation_0_distribution"]
[6.5069999999999997,"BuildSQL"]
[6.5069999999999997,"Check SQL attributes"]
[6.5069999999999997,"Build columns"]
[6.5069999999999997,"Check statistics columns"]
[6.5069999999999997,"Replace placeholders"]
[6.5069999999999997,"BuildSQL finished"]
[6.5069999999999997,"Full SQL: select * from Nemo.SCRIPT('nemo.analyze.kpi.PdschModulationCodeword0','Mode:0;qsr:','(lte_serving_cell_type = 0 OR lte_serving_cell_type IS NULL) AND 0=0 ','file_id=MEAS1(''rue_asma_dt_dl:1'')') as (\"time\" bytea,\"lte_la_dl_modulation_0\" smallint,\"lte_serving_cell_type\" smallint,\"Measurement title\" text,\"_exclude_order_1\" text,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"_exclude_order_3\" smallint,\"_exclude_order_4\" smallint,\"Percentage\" real )"]
[6.5069999999999997,"run query  "]
[8.1859999999999999,"Query was finished in 1,679 seconds, 855 row(s). Time 05/04/2025 10:29:11"]
[8.7330000000000005,"Handling map image configuration 19/20 to worksheet."]
[8.734,"Started executing query: np_lte_la_dl_rank_mode"]
[8.734,"BuildSQL"]
[8.734,"Check SQL attributes"]
[8.734,"Build columns"]
[8.734,"Check statistics columns"]
[8.734,"Replace placeholders"]
[8.734,"BuildSQL finished"]
[8.734,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 0, 0, ' SELECT \"the_event\",\"percentage\",\"time\",\"lte_la_dl_rank\",\"lte_serving_cell_type\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.LTE_PLAID_MCS_ x WHERE (lte_serving_cell_type = 0 OR lte_serving_cell_type IS NULL) AND \"lte_la_dl_modulation_0\" IS NOT NULL  AND x.file_id = MEAS1(''rue_asma_dt_dl:1'')  order by x.lr_id ') as (\"time\" bytea,\"lte_la_dl_rank\" smallint,\"lte_serving_cell_type\" smallint,\"gps_longitude\" double precision,\"gps_latitude\" double precision)"]
[8.734,"run query  "]
[9.1340000000000003,"Query was finished in 0,399 seconds, 308 row(s). Time 05/04/2025 10:29:12"]
[9.6839999999999993,"Handling map image configuration 20/20 to worksheet."]
[9.6859999999999999,"Started executing query: np_serving_system_and_frequency"]
[9.6859999999999999,"BuildSQL"]
[9.6859999999999999,"Check SQL attributes"]
[9.6859999999999999,"Build columns"]
[9.6859999999999999,"Check statistics columns"]
[9.6859999999999999,"Replace placeholders"]
[9.6869999999999994,"BuildSQL finished"]
[9.6869999999999994,"Full SQL: SELECT SB_2_FF2SB(the_serving_system, the_serving_band_downlink, the_serving_band_uplink) AS cellular_system_band,VAL_TO_STRING('cellular_system_band',SB_2_FF2SB(the_serving_system, the_serving_band_downlink, the_serving_band_uplink)) AS \"Band\",VAL_TO_STRING('the_serving_system', \"the_serving_system\") || ' ' || (\"the_serving_band\")::text AS \"System and band\",\"sql_time\" AS \"_exclude_order\",to_interval(\"time\") AS \"_exclude_order_2\",\"time\",\"gps_longitude\",\"gps_latitude\" FROM Nemo.Event_ WHERE event_id = 'CHI'  AND file_id = MEAS1('rue_asma_dt_dl:1')  ORDER BY \"_exclude_order\", \"_exclude_order_2\" ,lr_id "]
[9.6869999999999994,"run query  "]
[9.7059999999999995,"Query was finished in 0,019 seconds, 24 row(s). Time 05/04/2025 10:29:13"]
[10.382999999999999,"Started executing query: nr_np_nth_best_rsrp"]
[10.382999999999999,"BuildStatisticsSQL"]
[10.382999999999999,"Check weights"]
[10.382999999999999,"Check SQLColumns"]
[10.382999999999999,"Check groupBy"]
[10.382999999999999,"Check SQL attributes"]
[10.382999999999999,"Build columns"]
[10.382999999999999,"Check statistics columns"]
[10.382999999999999,"Replace placeholders"]
[10.382999999999999,"BuildSQL finished"]
[10.382999999999999,"GetSQLString for procedure"]
[10.382999999999999,"Replace strings"]
[10.382999999999999,"Check ValueColumn"]
[10.382999999999999,"Get ParameterInfo for nr_rp"]
[10.382999999999999,"Replace placeholders"]
[10.382999999999999,"Check groupByColumn"]
[10.382999999999999,"BuildStatisticsSQL finished"]
[10.382999999999999,"Full SQL: SELECT * FROM Nemo.QSR('up', -140, -35, 10, '', -90, '<', 1, 262225, '1. best RSRP', 'qsr_duration', '', 'select * from Nemo.Nth_BEST(1, 0, 1, 0, ''select * from Nemo.SCRIPT(''''nemo.analyze.kpi.QueryWithTimeBasedEventBlocks'''','''' SELECT the_event,nr_rp AS \"1. best RSRP\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''''''''cellular_system_band_int'''''''', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",((nr_pci)::text || ''''''''_'''''''' || (nr_beam_index)::text) AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"gps_longitude\",\"gps_latitude\",\"gps_height\", sql_time, time_interval ,time_interval AS qsr_duration  FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1  AND x.file_id = MEAS1(''''''''rue_asma_dt_dl:1'''''''')   '''', '''''''', '''''''') as (\"the_event\" bigint,\"1. best RSRP\" real,\r\n          \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n          \"gps_longitude\" double precision,\r\n          \"gps_latitude\" double precision,\r\n          \"gps_height\" smallint,\r\n          \"_exclude_sql_time\" timestamp,\r\n          _exclude_time_interval bigint,\r\n          \"the_device\" bigint\r\n          ,qsr_duration int8 )'') \r\n        as (\"1. best RSRP\" real,\r\n        \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n        \"gps_longitude\" double precision,\r\n        \"gps_latitude\" double precision,\r\n        \"gps_height\" smallint,\r\n        \"_exclude_sql_time\" timestamp without time zone,\r\n        _exclude_time_interval bigint, \r\n        \"the_device\" bigint\r\n        ,qsr_duration int8 )')"]
[10.382999999999999,"run query  "]
[10.457000000000001,"Query was finished in 0,073 seconds, 14 row(s). Time 05/04/2025 10:29:14"]
[10.457000000000001,"Writing query results to WorkSheetHistograme to be hiden!A2."]
[10.61,"Started executing query: nr_np_nth_best_rsrq"]
[10.61,"BuildStatisticsSQL"]
[10.61,"Check weights"]
[10.61,"Check SQLColumns"]
[10.61,"Check groupBy"]
[10.61,"Check SQL attributes"]
[10.61,"Build columns"]
[10.61,"Check statistics columns"]
[10.61,"Replace placeholders"]
[10.61,"BuildSQL finished"]
[10.61,"GetSQLString for procedure"]
[10.61,"Replace strings"]
[10.611000000000001,"Check ValueColumn"]
[10.611000000000001,"Get ParameterInfo for nr_rq"]
[10.611000000000001,"Replace placeholders"]
[10.611000000000001,"Check groupByColumn"]
[10.611000000000001,"BuildStatisticsSQL finished"]
[10.611000000000001,"Full SQL: SELECT * FROM Nemo.QSR('up', -30, 0, 2, '', -20, '<', 1, 262225, '1. best RSRQ', 'qsr_duration', '', 'select * from Nemo.Nth_BEST(1, 0, 1, 0, '' SELECT \"the_event\",\"nr_rq\" AS \"1. best RSRQ\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''''cellular_system_band_int'''', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",(nr_pci)::text || ''''_'''' || (nr_beam_index)::text AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"the_parent\" AS \"the_parent\",\"gps_longitude\",\"gps_latitude\",\"gps_height\",time_interval AS qsr_duration\r\n                FROM Nemo.NR_CELLMEAS_Cell_ x \r\n                WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1  AND x.file_id = MEAS1(''''rue_asma_dt_dl:1'''') '') as (\"1. best RSRQ\" real,\"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\"the_parent\" bigint,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint ,qsr_duration int8)')"]
[10.611000000000001,"run query  "]
[10.635,"Query was finished in 0,024 seconds, 18 row(s). Time 05/04/2025 10:29:14"]
[10.635,"Writing query results to WorkSheetHistograme to be hiden!J2."]
[10.789,"Started executing query: nr_np_sinr_nth_best"]
[10.789,"BuildStatisticsSQL"]
[10.789,"Check weights"]
[10.789,"Check SQLColumns"]
[10.789,"Check groupBy"]
[10.789,"Check SQL attributes"]
[10.789,"Build columns"]
[10.789,"Check statistics columns"]
[10.789,"Replace placeholders"]
[10.789,"BuildSQL finished"]
[10.789,"GetSQLString for procedure"]
[10.789,"Replace strings"]
[10.789,"Check ValueColumn"]
[10.789,"Get ParameterInfo for nr_sinr"]
[10.789,"Replace placeholders"]
[10.789,"Check groupByColumn"]
[10.789,"BuildStatisticsSQL finished"]
[10.789,"Full SQL: SELECT * FROM Nemo.QSR('up', -30, 40, 10, '', 20, '<', 1, 262225, '1. best SS-SINR', 'qsr_duration', '', 'select * from Nemo.Nth_BEST(1, 0, 1, 0, '' SELECT the_event,nr_rp AS \"1. best SS-RSRP\",nr_sinr AS \"1. best SS-SINR\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''''cellular_system_band_int'''', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",(nr_pci)::text || ''''_'''' || (nr_beam_index)::text AS \"NR PCI Beam index\",\"gps_longitude\",\"gps_latitude\",\"gps_height\",time_interval AS qsr_duration\r\n                FROM Nemo.NR_CELLMEAS_Cell_ \r\n                WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1 AND nr_sinr IS NOT NULL  AND file_id = MEAS1(''''rue_asma_dt_dl:1'''') '') as (\"1. best SS-RSRP\" real,\"1. best SS-SINR\" real,\"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint ,qsr_duration int8)')"]
[10.789,"run query  "]
[10.811,"Query was finished in 0,022 seconds, 10 row(s). Time 05/04/2025 10:29:14"]
[10.811,"Writing query results to WorkSheetHistograme to be hiden!R2."]
[10.964,"Started executing query: lte_nr_total_mac_dl_bit_rate"]
[10.964,"BuildStatisticsSQL"]
[10.964,"Check weights"]
[10.964,"Check SQLColumns"]
[10.964,"Check groupBy"]
[10.964,"Check SQL attributes"]
[10.964,"Build columns"]
[10.964,"Check statistics columns"]
[10.964,"Replace placeholders"]
[10.964,"BuildSQL finished"]
[10.964,"GetSQLString for procedure"]
[10.964,"Replace strings"]
[10.964,"Check ValueColumn"]
[10.964,"Get ParameterInfo for lte_mac_dl_bit_rate_total"]
[10.964,"Replace placeholders"]
[10.964,"Check groupByColumn"]
[10.964,"BuildStatisticsSQL finished"]
[10.964,"Full SQL: SELECT * FROM Nemo.QSR('up', 0, 200000000, 10000000, '', 100000000, '<', 1, 262225, 'lte_mac_dl_bit_rate_total', 'qsr_duration', '', 'select * from Nemo.SCRIPT(''nemo.analyze.kpi.Query_2_Sum'',''SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as \"Interval\",                  SUM(CAST(lte_mac_dl_bit_rate as double precision)) as \"lte_mac_dl_bit_rate\",                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order ,MIN(to_interval(time)) AS qsr_duration                  FROM Nemo.LTE_MACRATE_ x                  WHERE 0 = 0  AND x.file_id = MEAS1(''''rue_asma_dt_dl:1'''')                   GROUP BY sql_time  ,x.lr_id ORDER BY _exclude_order   ,x.lr_id ;SELECT sql_time,                  T_TI_2_T(MIN(time),MIN(to_interval(time))) AS time,                  MIN(to_interval(time)) as \"Interval\",                  SUM(CAST(nr_mac_dl_bit_rate as double precision)) as \"nr_mac_dl_bit_rate\",                  MIN(gps_longitude) AS gps_longitude,                  MIN(gps_latitude) AS gps_latitude,                  MIN(gps_height) as gps_height,                  sql_time AS _exclude_order ,MIN(to_interval(time)) AS qsr_duration                  FROM Nemo.NR_MACRATE_ x                  WHERE 0 = 0 AND x.file_id = MEAS1(''''rue_asma_dt_dl:1'''')                    GROUP BY sql_time ,x.lr_id  ORDER BY _exclude_order  ,x.lr_id  ;Interval:1;GROUP_BY:sql_time,time,gps_longitude,gps_latitude,gps_height;add:lte_mac_dl_bit_rate,nr_mac_dl_bit_rate,lte_mac_dl_bit_rate_total;qsr:,MIN(to_interval(time)) AS qsr_duration'','''',''file_id=MEAS1(''''rue_asma_dt_dl:1'''')'') as (\"sql_time\" timestamp,\"time\" bytea,\"gps_longitude\" double precision,\"gps_latitude\" double precision,\"gps_height\" smallint,\"lte_mac_dl_bit_rate\" double precision,\"nr_mac_dl_bit_rate\" double precision   ,qsr_duration int8  ,\"lte_mac_dl_bit_rate_total\" double precision)')"]
[10.964,"run query  "]
[11.132,"Query was finished in 0,168 seconds, 23 row(s). Time 05/04/2025 10:29:14"]
[11.132,"Writing query results to WorkSheetHistograme to be hiden!Z2."]
[11.134,"Started executing query: nr_np_nth_best_rsrp"]
[11.134,"BuildSQL"]
[11.134,"Check SQL attributes"]
[11.134,"Build columns"]
[11.134,"Check statistics columns"]
[11.134,"Replace placeholders"]
[11.134,"BuildSQL finished"]
[11.134,"Full SQL: select * from Nemo.Nth_BEST(1, 0, 1, 0, 'select * from Nemo.SCRIPT(''nemo.analyze.kpi.QueryWithTimeBasedEventBlocks'','' SELECT the_event,nr_rp AS \"1. best RSRP\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''''cellular_system_band_int'''', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",((nr_pci)::text || ''''_'''' || (nr_beam_index)::text) AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"gps_longitude\",\"gps_latitude\",\"gps_height\", sql_time, time_interval   FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1  AND x.file_id = MEAS1(''''rue_asma_dt_dl:1'''')   '', '''', '''') as (\"the_event\" bigint,\"1. best RSRP\" real,\r\n          \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n          \"gps_longitude\" double precision,\r\n          \"gps_latitude\" double precision,\r\n          \"gps_height\" smallint,\r\n          \"_exclude_sql_time\" timestamp,\r\n          _exclude_time_interval bigint,\r\n          \"the_device\" bigint\r\n           )') \r\n        as (\"1. best RSRP\" real,\r\n        \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n        \"gps_longitude\" double precision,\r\n        \"gps_latitude\" double precision,\r\n        \"gps_height\" smallint,\r\n        \"_exclude_sql_time\" timestamp without time zone,\r\n        _exclude_time_interval bigint, \r\n        \"the_device\" bigint\r\n         )"]
[11.134,"run query  "]
[11.167999999999999,"Query was finished in 0,034 seconds, 310 row(s). Time 05/04/2025 10:29:14"]
[11.18,"Started executing query: nr_np_nth_best_rsrp"]
[11.18,"BuildStatisticsSQL"]
[11.18,"Check weights"]
[11.18,"Check SQLColumns"]
[11.18,"Check groupBy"]
[11.18,"Check SQL attributes"]
[11.18,"Build columns"]
[11.18,"Check statistics columns"]
[11.18,"Replace placeholders"]
[11.18,"BuildSQL finished"]
[11.18,"GetSQLString for procedure"]
[11.18,"Replace strings"]
[11.18,"Check ValueColumn"]
[11.18,"Get ParameterInfo for nr_rp"]
[11.18,"Replace placeholders"]
[11.18,"Check groupByColumn"]
[11.18,"BuildStatisticsSQL finished"]
[11.18,"Full SQL: SELECT * FROM Nemo.QSR('up', -140, -35, 10, '', -90, '<', 1, 262225, '1. best RSRP', 'qsr_duration', '', 'select * from Nemo.Nth_BEST(1, 0, 1, 0, ''select * from Nemo.SCRIPT(''''nemo.analyze.kpi.QueryWithTimeBasedEventBlocks'''','''' SELECT the_event,nr_rp AS \"1. best RSRP\",\"time\",\"nr_arfcn\",\"nr_pci\",\"nr_beam_index\",\"nr_beam_type\",VAL_TO_STRING(''''''''cellular_system_band_int'''''''', cellular_system_band_int) AS \"Band\",CASE        WHEN FF2SB_2_DB(cellular_system_band_int) NOT IN(0,1,2)        THEN FF2SB_2_DB(cellular_system_band_int)        ELSE FF2SB_2_UB(cellular_system_band_int) END  AS \"Band (MHz)\",((nr_pci)::text || ''''''''_'''''''' || (nr_beam_index)::text) AS \"NR PCI Beam index\",nr_pci::int8*1000 +nr_beam_index AS _oid,\"gps_longitude\",\"gps_latitude\",\"gps_height\", sql_time, time_interval ,time_interval AS qsr_duration  FROM Nemo.NR_CELLMEAS_Cell_ x WHERE nr_meas_type = 1 AND COALESCE(\"nr_beam_type\", -999) != -1  AND x.file_id = MEAS1(''''''''rue_asma_dt_dl:1'''''''')   '''', '''''''', '''''''') as (\"the_event\" bigint,\"1. best RSRP\" real,\r\n          \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n          \"gps_longitude\" double precision,\r\n          \"gps_latitude\" double precision,\r\n          \"gps_height\" smallint,\r\n          \"_exclude_sql_time\" timestamp,\r\n          _exclude_time_interval bigint,\r\n          \"the_device\" bigint\r\n          ,qsr_duration int8 )'') \r\n        as (\"1. best RSRP\" real,\r\n        \"time\" bytea,\"nr_arfcn\" integer,\"nr_pci\" smallint,\"nr_beam_index\" smallint,\"nr_beam_type\" integer,\"Band\" text,\"Band (MHz)\" integer,\"NR PCI Beam index\" text,\"_oid\" bigint,\r\n        \"gps_longitude\" double precision,\r\n        \"gps_latitude\" double precision,\r\n        \"gps_height\" smallint,\r\n        \"_exclude_sql_time\" timestamp without time zone,\r\n        _exclude_time_interval bigint, \r\n        \"the_device\" bigint\r\n        ,qsr_duration int8 )')"]
[11.18,"run query  "]
[11.214,"Query was finished in 0,034 seconds, 14 row(s). Time 05/04/2025 10:29:14"]
[11.215,"Waiting for report macro tasks to finish."]
[11.215,"Report macro tasks have finished."]
[11.215,"Report completed 05/04/2025 10:29:14."]

{"sheet":"WorkSheetHistograme to be hiden","index":5,"n_rows":24,"n_cols":32,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAC DL 5G Thp"]
["lower_bound","upper_bound","cumulation","cumulation_sampled","density","density_sampled","group",null,null,"lower_bound","upper_bound","cumulation","cumulation_sampled","density","density_sampled","group",null,"lower_bound","upper_bound","cumulation","cumulation_sampled","density","density_sampled","group",null,"lower_bound","upper_bound","cumulation","cumulation_sampled","density","density_sampled","group"]
["...",-140,100,157528,0,0,null,null,null,"...",-30,100,158107.00099999999,0,0,null,null,"...",-30,100,158107.00099999999,0,0,null,null,"...",0,100,159141.005,0,0]
[-140,-130,100,157528,0,0,null,null,null,-30,-28,100,158107.00099999999,0,0,null,null,-30,-20,100,158107.00099999999,0,0,null,null,0,10000000,100,159141.005,8.4321459999999995,13419.002]
[-130,-120,100,157528,0,0,null,null,null,-28,-26,100,158107.00099999999,0,0,null,null,-20,-10,100,158107.00099999999,0.27512999999999999,435,null,null,10000000,20000000,91.567853999999997,145722.003,0.64219800000000005,1022.001]
[-120,-110,100,157528,0,0,null,null,null,-26,-24,100,158107.00099999999,0,0,null,null,-10,0,99.724869999999996,157672.00099999999,6.7384750000000002,10654,null,null,20000000,30000000,90.925656000000004,144700.00200000001,0.94570200000000004,1505]
[-110,-100,100,157528,0,0,null,null,null,-24,-22,100,158107.00099999999,0,0,null,null,0,10,92.986395000000002,147018.00099999999,54.18356,85668.001000000004,null,null,30000000,40000000,89.979952999999995,143195.00200000001,0.99283100000000002,1580.002]
[-100,-90,100,157528,19.871388,31303,null,null,null,-22,-20,100,158107.00099999999,0,0,null,null,10,20,38.802835999999999,61350,35.599308999999998,56285,null,null,40000000,50000000,88.987121999999999,141615,2.5530819999999999,4063]
[-90,-80,80.128612000000004,126225,53.115001999999997,83671,null,null,null,-20,-18,100,158107.00099999999,0,0,null,null,20,30,3.2035269999999998,5065,3.2035269999999998,5065,null,null,50000000,60000000,86.434039999999996,137552,1.5822449999999999,2518]
[-80,-70,27.01361,42554,21.857067000000001,34431,null,null,null,-18,-16,100,158107.00099999999,0,0,null,null,30,40,0,0,0,0,null,null,60000000,70000000,84.851794999999996,135034,4.1215020000000004,6559]
[-70,-60,5.1565440000000002,8123,5.1565440000000002,8123,null,null,null,-16,-14,100,158107.00099999999,1.6052420000000001,2538,null,null,40,"...",0,0,0,0,null,null,70000000,80000000,80.730293000000003,128475,4.1252719999999998,6565]
[-60,-50,0,0,0,0,null,null,null,-14,-12,98.394757999999996,155569.00099999999,31.975814,50556.000999999997,null,null,null,null,null,null,null,null,null,null,80000000,90000000,76.605020999999994,121910,7.3035860000000001,11623]
[-50,-40,0,0,0,0,null,null,null,-12,-10,66.418943999999996,105013,66.418943999999996,105013,null,null,null,null,null,null,null,null,null,null,90000000,100000000,69.301434999999998,110287,12.396554,19728]
[-40,-35,0,0,0,0,null,null,null,-10,-8,0,0,0,0,null,null,null,null,null,null,null,null,null,null,100000000,110000000,56.904881000000003,90559,10.830018000000001,17235]
[-35,"...",0,0,0,0,null,null,null,-8,-6,0,0,0,0,null,null,null,null,null,null,null,null,null,null,110000000,120000000,46.074863000000001,73324,5.0942239999999996,8107]
[null,null,null,null,null,null,null,null,null,-6,-4,0,0,0,0,null,null,null,null,null,null,null,null,null,null,120000000,130000000,40.980638999999996,65217,6.6796110000000004,10630]
[null,null,null,null,null,null,null,null,null,-4,-2,0,0,0,0,null,null,null,null,null,null,null,null,null,null,130000000,140000000,34.301028000000002,54587,6.6494489999999997,10582]
[null,null,null,null,null,null,null,null,null,-2,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,140000000,150000000,27.651579000000002,44005,7.9206490000000001,12605]
[null,null,null,null,null,null,null,null,null,0,"...",0,0,0,0,null,null,null,null,null,null,null,null,null,null,150000000,160000000,19.730930000000001,31400,7.2929040000000001,11606]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160000000,170000000,12.438026000000001,19794,4.7850650000000003,7615]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170000000,180000000,7.6529619999999996,12179,4.147894,6601]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180000000,190000000,3.5050680000000001,5578,2.5505680000000002,4059]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190000000,200000000,0.95449899999999999,1519,0.95449899999999999,1519]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200000000,"...",0,0,0,0]