Spreadsheet: 209324d1359062918-selecting-top-10-with-many-duplicates-in-column-worst-cells-output-wid-formula-for-excelforum
Sheet: 2G TOP 10 NEWdaily Template

GSM Daily Watchlist
Top 10 High TCH Drop Rate: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  | GSM CELL | TCH Drop [NAME] (%) |  |  |  |  |  |  | 12/14/2012 |  |  | 12/15/2012 |  |  | 12/16/2012 |  |  | 12/17/2012 |  |  | 12/18/2012 |  |  | 12/19/2012 |  |  | 12/20/2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 9.333333333333334 |  | 2G_Alofau-3 | 2.325581395348837 |  | 2G_Alofau-3 | 5.228758169934641 |  | 2G_Alofau-3 | 7.746478873239436 |  | 2G_Alofau-3 | 7.407407407407407 |  | 2G_Alofau-3 | 4.347826086956522 |  | 2G_Alofau-3 | 5.025125628140704
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 3.070175438596491 |  | 2G_TradewindsHotel-1 | 2.222222222222222 |  | 2G_Masefau-2 | 3.03030303030303 |  | 2G_Masefau-1 | 4.020100502512562 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 4.25531914893617 |  | 2G_Utulei-3 | 1.6878612716763 |  | 2G_Amanave-1 | 3.940886699507389
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 1.522842639593909 |  | 2G_Amanave-1 | 1.496259351620948 |  | 2G_Amanave-1 | 2.73972602739726 |  | 2G_Aunuu-1 | 3.084832904884319 |  | 2G_Aunuu-1 | 2.038369304556355 |  | 2G_Laulii-1 | 1.506024096385542 |  | 2G_Laulii-1 | 1.621621621621622
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Amanave-1 | 1.194029850746269 |  | 2G_Aoa-1 | 1.388888888888889 |  | 2G_Masefau-1 | 2.510460251046025 |  | 2G_TradewindsHotel-1 | 1.492537313432836 |  | 2G_Onenoa-1 | 1.643192488262911 |  | 2G_Aoa-1 | 1.496259351620948 |  | 2G_Tula-2 | 1.507537688442211
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenOffice 2ndFlr-1 | 0.9433962264150944 |  | 2G_Faganeanea-2 | 1.304347826086957 |  | 2G_Aunuu-1 | 1.466992665036675 |  | 2G_Amanave-1 | 1.379310344827586 |  | 2G_Masefau-1 | 1.612903225806452 |  | 2G_Matuu-1 | 1.444444444444444 |  | 2G_Malaeimi-3 | 1.363636363636364
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Matuu-1 | 0.9009009009009009 |  | 2G_Aunuu-1 | 1.274509803921569 |  | 2G_Faganeanea-2 | 1.392757660167131 |  | 2G_Onenoa-1 | 1.17096018735363 |  | 2G_Matuu-1 | 1.609657947686117 |  | 2G_Tula-2 | 1.420454545454545 |  | 2G_Faganeanea-2 | 1.24777183600713
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_BreakersPoint-1 | 0.8038585209003215 |  | 2G_Onenoa-1 | 1.259842519685039 |  | 2G_Utulei-3 | 1.360749924402782 |  | 2G_Masefau-2 | 1.114206128133705 |  | 2G_Aoa-1 | 1.583710407239819 |  | 2G_ForsgrenOffice 2ndFlr-1 | 1.379310344827586 |  | 2G_Tula-1 | 1.179941002949852
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-2 | 0.7028504490433425 |  | 2G_Malaeimi-3 | 0.8583690987124464 |  | 2G_Malaeimi-3 | 1.333333333333333 |  | 2G_ForsgrenOffice 2ndFlr-1 | 1.030927835051546 |  | 2G_TradewindsHotel-1 | 1.538461538461539 |  | 2G_Onenoa-1 | 1.25 |  | 2G_Onenoa-1 | 1.079913606911447
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Onenoa-1 | 0.6956521739130435 |  | 2G_Masefau-1 | 0.8368200836820083 |  | 2G_Utulei-2 | 1.056338028169014 |  | 2G_Tula-2 | 1.017811704834606 |  | 2G_Aunuu-2 | 0.9586578789694428 |  | 2G_Faganeanea-2 | 1.171875 |  | 2G_Matuu-1 | 1.076233183856502
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Tula-2 | 0.6651884700665188 |  | 2G_Matuu-1 | 0.7678676904902539 |  | 2G_Matuu-1 | 1.056338028169014 |  | 2G_Matuu-1 | 0.9874326750448833 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0.847457627118644 |  | 2G_Aunuu-1 | 1.133501259445844 |  | 2G_Aunuu-1 | 1.015228426395939
Top 10 High TCH Congestion: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%) |  | GSM CELL | TCH Congestion Avg (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_PagoMafa-1 | 2.37440277978862 |  | 2G_Olotele-1 | 4.303809538945662 |  | 2G_Olotele-1 | 8.165682976878001 |  | 2G_PagoMafa-1 | 1.756734147565668 |  | 2G_PagoMafa-1 | 2.826666666666667 |  | 2G_Olotele-1 | 1.401242140775955 |  | 2G_PagoMafa-1 | 2.898768398918594
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Olotele-1 | 1.210495546614395 |  | 2G_PagoMafa-1 | 2.995425704589051 |  | 2G_PagoMafa-1 | 3.689899366380917 |  | 2G_Olotele-1 | 1.629221119676874 |  | 2G_Olotele-1 | 0.6271356783919598 |  | 2G_PagoMafa-1 | 1.189492813480919 |  | 2G_Olotele-1 | 1.066378884600611
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Faganeanea-1 | 0.07600709399543958 |  | 2G_Onenoa-1 | 0.4319654427645789 |  | 2G_Masefau-1 | 0.2570694087403599 |  | 2G_Faganeanea-1 | 0.2052861175263023 |  | 2G_Faganeanea-1 | 0.112391121101433 |  | 2G_Utulei-3 | 0.1165871754107048 |  | 2G_Faganeanea-1 | 0.0764915859255482
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Satala-2 | 0.02501667778519013 |  | 2G_TradewindsHotel-1 | 0.425531914893617 |  | 2G_Tafuna-1 | 0.05319148936170213 |  | 2G_Matuu-1 | 0.08435259384226065 |  | 2G_Satala-3 | 0.01845358922310389 |  | 2G_Satala-1 | 0.01618646811265782 |  | 2G_Tafuna-1 | 0.009409993413004612
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Leone-1 | 0.01371553970648745 |  | 2G_Matuu-1 | 0.2645502645502645 |  | 2G_Aunuu-2 | 0.04315925766076824 |  | 2G_Aunuu-2 | 0.048828125 |  | 2G_Satala-2 | 0.009311853990129435 |  | 2G_Tafuna-1 | 0.01506099703800392 |  | 2G_Satala-1 | 0.006724949562878279
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Utulei-3 | 0.01019264091326062 |  | 2G_Afono-1 | 0.2285714285714286 |  | 2G_Faganeanea-1 | 0.04103405826836274 |  | 2G_Tafuna-1 | 0.03302042549176848 |  | 2G_Malaeimi-2 | 0.008640801866413203 |  | 2G_Olotele-2 | 0.006975933031042901 |  | 2G_Alofau-3 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Olotele-2 | 0.006515931452401121 |  | 2G_Faganeanea-2 | 0.2085505735140772 |  | 2G_Leone-3 | 0.03165558721114277 |  | 2G_Satala-2 | 0.02623524267599475 |  | 2G_Tafuna-3 | 0.006393044367727913 |  | 2G_Tafuna-2 | 0.005606323933396872 |  | 2G_Amanave-1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 0 |  | 2G_Faganeanea-1 | 0.02560819462227913 |  | 2G_Iliili-1 | 0.01876407305479109 |  | 2G_Utulei-3 | 0.009763718023823472 |  | 2G_Tafuna-1 | 0.005123475765959627 |  | 2G_Alofau-3 | 0 |  | 2G_Laulii-1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 0 |  | 2G_Iliili-3 | 0.01366306872523569 |  | 2G_Utulei-3 | 0.01359989120087039 |  | 2G_Malaeimi-2 | 0.009699321047526672 |  | 2G_Alofau-3 | 0 |  | 2G_Laulii-1 | 0 |  | 2G_Tula-2 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_Iliili-2 | 0.01034607625058197 |  | 2G_Malaeimi-2 | 0.01170411985018727 |  | 2G_Satala-1 | 0.00844451950684006 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_Aoa-1 | 0 |  | 2G_Malaeimi-3 | 0
Top 10 Low Immediate Assign Success: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%) |  | GSM CELL | Success Rate of Immediate Assignments (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 92.74192857142857 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 86.45833333333333 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0 |  | 2G_Alofau-3 | 95.10849999999999 |  | 2G_ForsgrenOffice 2ndFlr-1 | 88.66666666666667 |  | 2G_Alofau-3 | 95.11895833333335 |  | 2G_ForsgrenOffice 2ndFlr-1 | 92.89673333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 96.48843478260869 |  | 2G_ForsgrenOffice 2ndFlr-1 | 93.33333333333333 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_BreakersPoint-1 | 97.37891666666667 |  | 2G_Alofau-3 | 95.38608333333333 |  | 2G_TradewindsHotel-1 | 98.39745454545454 |  | 2G_Alofau-3 | 96.05641666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 96.69095833333334 |  | 2G_Alofau-3 | 96.50287499999997 |  | 2G_Alofau-3 | 92.372125 |  | 2G_Utulei-3 | 97.95325000000001 |  | 2G_TradewindsHotel-1 | 97.81204761904762 |  | 2G_ForsgrenOffice 2ndFlr-1 | 98.46153846153847 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 97.67916666666666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Faganeanea-2 | 97.05291666666665 |  | 2G_Faganeanea-2 | 97.761125 |  | 2G_Utulei-1 | 93.42870833333332 |  | 2G_Aunuu-1 | 98.11479166666668 |  | 2G_Faganeanea-2 | 97.83241666666667 |  | 2G_Tula-2 | 98.65879166666667 |  | 2G_Matuu-1 | 98.23408333333333
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Aunuu-1 | 97.62358333333334 |  | 2G_TradewindsHotel-1 | 97.77134782608695 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 97.15172727272726 |  | 2G_Matuu-1 | 98.43716666666666 |  | 2G_Aunuu-1 | 98.16645454545454 |  | 2G_Iliili-3 | 98.79949999999998 |  | 2G_Malaeimi-3 | 98.82604166666665
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Matuu-1 | 98.62583333333332 |  | 2G_Aunuu-1 | 97.98825 |  | 2G_TradewindsHotel-1 | 97.27395652173912 |  | 2G_Utulei-1 | 98.448125 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 98.70086363636364 |  | 2G_BreakersPoint-2 | 98.84033333333332 |  | 2G_BreakersPoint-2 | 98.87837500000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Iliili-3 | 98.6798333333333 |  | 2G_Aunuu-3 | 98.071875 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 97.77779166666666 |  | 2G_Iliili-3 | 98.80779166666667 |  | 2G_Tula-2 | 98.83679166666667 |  | 2G_Faganeanea-2 | 98.95570833333333 |  | 2G_Amanave-1 | 98.888875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_LaufouShoppingCtr 1stFlr-1 | 98.82295454545455 |  | 2G_Iliili-3 | 98.89845833333334 |  | 2G_Faganeanea-2 | 98.10283333333332 |  | 2G_BreakersPoint-2 | 98.82008333333334 |  | 2G_BreakersPoint-2 | 98.97904166666667 |  | 2G_Iliili-2 | 98.96133333333334 |  | 2G_Iliili-3 | 99.19000000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_BreakersPoint-1 | 98.92916666666667 |  | 2G_Olotele-1 | 99.01024999999998 |  | 2G_Aoa-1 | 98.22441666666667 |  | 2G_Aoa-1 | 98.87908333333333 |  | 2G_Onenoa-1 | 98.99666666666667 |  | 2G_Matuu-1 | 99.01704166666666 |  | 2G_Olotele-1 | 99.27608333333332
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_BreakersPoint-2 | 99.05375000000004 |  | 2G_Tula-2 | 99.05375 |  | 2G_Utulei-2 | 98.58804166666668 |  | 2G_Faganeanea-2 | 99.12395833333335 |  | 2G_Iliili-3 | 99.12737499999999 |  | 2G_Onenoa-1 | 99.09304166666668 |  | 2G_Iliili-2 | 99.30279166666666
Top 10 Low SDCCH Setup Success: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%) |  | GSM CELL | SDCCH Setup Success Rate Avg (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 99.37106918238993 |  | 2G_Olotele-1 | 99.76792518184968 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0 |  | 2G_Aunuu-1 | 99.79674796747967 |  | 2G_Aunuu-1 | 99.74823766364553 |  | 2G_Olotele-1 | 99.95047311211323 |  | 2G_Olotele-1 | 99.82000143998849
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Olotele-1 | 99.82372348408151 |  | 2G_TradewindsHotel-1 | 99.79035639412997 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_Aunuu-2 | 99.88665344290168 |  | 2G_Aunuu-3 | 99.77272727272727 |  | 2G_PagoMafa-1 | 99.97733711048159 |  | 2G_PagoMafa-1 | 99.98930710008554
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_PagoMafa-1 | 99.98960931005819 |  | 2G_Aunuu-3 | 99.8073217726397 |  | 2G_Masefau-1 | 99.84399375975039 |  | 2G_Olotele-1 | 99.93070362473347 |  | 2G_Aunuu-2 | 99.89381470666314 |  | 2G_Alofau-3 | 100 |  | 2G_ForsgrenOffice 2ndFlr-1 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 100 |  | 2G_Aunuu-2 | 99.88893824966681 |  | 2G_Olotele-1 | 99.92765239101755 |  | 2G_Alofau-3 | 100 |  | 2G_Olotele-1 | 99.97994411092243 |  | 2G_TradewindsHotel-1 | 100 |  | 2G_Alofau-3 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 100 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 100 |  | 2G_Alofau-3 | 100 |  | 2G_BreakersPoint-1 | 100 |  | 2G_ForsgrenOffice 2ndFlr-1 | 100 |  | 2G_ForsgrenOffice 2ndFlr-1 | 100 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Faganeanea-2 | 100 |  | 2G_ForsgrenOffice 2ndFlr-1 | 100 |  | 2G_Utulei-1 | 100 |  | 2G_Utulei-3 | 100 |  | 2G_Alofau-3 | 100 |  | 2G_Tula-2 | 100 |  | 2G_Matuu-1 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Aunuu-1 | 100 |  | 2G_Alofau-3 | 100 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 100 |  | 2G_Matuu-1 | 100 |  | 2G_TradewindsHotel-1 | 100 |  | 2G_Iliili-3 | 100 |  | 2G_Malaeimi-3 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Matuu-1 | 100 |  | 2G_Faganeanea-2 | 100 |  | 2G_TradewindsHotel-1 | 100 |  | 2G_Utulei-1 | 100 |  | 2G_Faganeanea-2 | 100 |  | 2G_BreakersPoint-2 | 100 |  | 2G_BreakersPoint-2 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Iliili-3 | 100 |  | 2G_Aunuu-1 | 100 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 100 |  | 2G_Iliili-3 | 100 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 100 |  | 2G_Faganeanea-2 | 100 |  | 2G_Amanave-1 | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_LaufouShoppingCtr 1stFlr-1 | 100 |  | 2G_Iliili-3 | 100 |  | 2G_Faganeanea-2 | 100 |  | 2G_BreakersPoint-2 | 100 |  | 2G_Tula-2 | 100 |  | 2G_Iliili-2 | 100 |  | 2G_Iliili-3 | 100
Top 10 High SDCCH Drop Rate: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%) |  | GSM CELL | SDCCH Drop Rate Avg (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Utulei-2 | 0.03074085459575776 |  | 2G_Alofau-1 | 0.03685956505713232 |  | 2G_Utulei-2 | 0.04623208506703652 |  | 2G_Laulii-1 | 0.1709401709401709 |  | 2G_Alofau-3 | 0.4065040650406505 |  | 2G_Aunuu-1 | 0.07457121551081282 |  | 2G_Faganeanea-2 | 0.1019367991845056
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Iliili-2 | 0.01098116729808379 |  | 2G_Matuu-1 | 0.02480774001488464 |  | 2G_BreakersPoint-2 | 0.0343819838404676 |  | 2G_Masefau-2 | 0.1270648030495553 |  | 2G_BreakersPoint-3 | 0.03145643284051589 |  | 2G_Iliili-2 | 0.02571355104139882 |  | 2G_Afono-1 | 0.07204610951008646
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Satala-2 | 0.006378771448618995 |  | 2G_BreakersPoint-2 | 0.02195630694917115 |  | 2G_Alofau-2 | 0.03371544167228591 |  | 2G_Alofau-1 | 0.04631773969430292 |  | 2G_Utulei-2 | 0.01825483753194597 |  | 2G_Alofau-2 | 0.02503128911138924 |  | 2G_PagoMafa-1 | 0.01368363437328955
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Satala-1 | 0.005588153115395362 |  | 2G_Leone-1 | 0.01469507714915503 |  | 2G_Malaeimi-1 | 0.01674761346508123 |  | 2G_Matuu-1 | 0.04248088360237893 |  | 2G_Leone-1 | 0.01792757260666906 |  | 2G_Satala-3 | 0.01265822784810127 |  | 2G_Utulei-2 | 0.01296512381693245
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Olotele-1 | 0.004572961602365745 |  | 2G_Iliili-3 | 0.00768403258029814 |  | 2G_Olotele-1 | 0.009762192979030809 |  | 2G_Tula-1 | 0.03868471953578336 |  | 2G_Iliili-2 | 0.01387732445184569 |  | 2G_Leone-1 | 0.01216397031991242 |  | 2G_Olotele-2 | 0.01284274064085276
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 0 |  | 2G_Satala-1 | 0.006247266820765915 |  | 2G_Olotele-2 | 0.007905138339920948 |  | 2G_Leone-1 | 0.0186880956830499 |  | 2G_Satala-2 | 0.01341111781667002 |  | 2G_Utulei-3 | 0.0120033609410635 |  | 2G_Iliili-2 | 0.01050696086157079
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_PagoMafa-1 | 0 |  | 2G_Olotele-1 | 0.005913835417960318 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0 |  | 2G_Olotele-2 | 0.01775095411378362 |  | 2G_Utulei-3 | 0.01142204454597373 |  | 2G_BreakersPoint-2 | 0.009555661729574772 |  | 2G_Satala-3 | 0.01003310926055985
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_Tafuna-3 | 0.00523642456930408 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_Iliili-3 | 0.01727861771058315 |  | 2G_Malaeimi-2 | 0.007966857871255577 |  | 2G_Tafuna-2 | 0.005520287054926856 |  | 2G_BreakersPoint-2 | 0.00848320325755005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 0 |  | 2G_Tafuna-1 | 0.003677687470118789 |  | 2G_Masefau-1 | 0 |  | 2G_BreakersPoint-2 | 0.01550147263990079 |  | 2G_Iliili-1 | 0.007840062720501764 |  | 2G_Olotele-1 | 0.005073309319669221 |  | 2G_Iliili-3 | 0.007699414844471821
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Faganeanea-2 | 0 |  | 2G_TradewindsHotel-1 | 0 |  | 2G_Alofau-3 | 0 |  | 2G_Leone-2 | 0.01267266506146243 |  | 2G_Tafuna-3 | 0.005163155720776539 |  | 2G_PagoMafa-1 | 0 |  | 2G_Olotele-1 | 0.004658095770449041
Top 10 Low TCH Seizures Setup Success: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%) |  | GSM CELL | TCH Seizures Success Rate Avg (%)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 97.1830985915493 |  | 2G_Alofau-3 | 96.91358024691358 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0 |  | 2G_Alofau-3 | 98.29059829059828 |  | 2G_PagoMafa-1 | 97.67441860465115 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 95.68345323741008 |  | 2G_Alofau-3 | 97.0873786407767
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_PagoMafa-1 | 98.73002867677182 |  | 2G_Masefau-1 | 98.26839826839827 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 0 |  | 2G_PagoMafa-1 | 98.62238622386224 |  | 2G_Alofau-3 | 97.97297297297297 |  | 2G_Alofau-3 | 97.75280898876404 |  | 2G_PagoMafa-1 | 98.35922117698534
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Fagasa-2 | 99.26605504587155 |  | 2G_PagoMafa-1 | 98.7143775444611 |  | 2G_PagoMafa-1 | 97.35718099305927 |  | 2G_Malaeimi-3 | 99.1304347826087 |  | 2G_Poloa-2 | 98.9247311827957 |  | 2G_Utulei-3 | 98.29963235294117 |  | 2G_Tula-1 | 99.1929567131328
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Fagasa-1 | 99.41747572815534 |  | 2G_Tula-2 | 98.74371859296483 |  | 2G_Alofau-3 | 98.74213836477988 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 99.25595238095238 |  | 2G_TradewindsHotel-1 | 99.13793103448276 |  | 2G_PagoMafa-1 | 99.2914501653283 |  | 2G_Seetaga-1 | 99.32735426008968
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_BreakersPoint-2 | 99.53313253012048 |  | THIS PAGE HAS THE FORMULAS FOR AUTO UPDATING THE SHEET FOR TOP TEN IN 2G. PROBLEM IS THAT WHEN THERE ARE DUPLICATE |  |  |  |  |  |  |  |  | 2G_Onenoa-1 | 99.29906542056075 |  | 2G_Poloa-2 | 99.36708860759494 |  | 2G_Faganeanea-2 | 99.46808510638297
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Olotele-1 | 99.55215121845755 |  | VALUES AND MATCH JUST TAKES THE FIRST VALUES. NEED TO FIX |  |  |  |  |  |  |  |  | 2G_Alofau-2 | 99.43074003795066 |  | 2G_Tula-2 | 99.38461538461539 |  | 2G_Tula-2 | 99.48186528497409
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Aunuu-1 | 99.6201329534663 |  | 2G_Fagasa-2 | 99.25925925925925 |  | 2G_Matuu-1 | 99.45255474452554 |  | 2G_Aunuu-1 | 99.34383202099738 |  | 2G_Poloa-1 | 99.43609022556392 |  | 2G_Laulii-2 | 99.43661971830986 |  | 2G_Matuu-1 | 99.55035971223022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Onenoa-1 | 99.644128113879 |  | 2G_Olotele-1 | 99.33984836691747 |  | 2G_Olotele-3 | 99.55863808322825 |  | 2G_Fagasa-2 | 99.39393939393939 |  | 2G_Seetaga-1 | 99.45504087193461 |  | 2G_Olotele-1 | 99.52138175007804 |  | 2G_Olotele-1 | 99.57887810495147
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Iliili-1 | 99.6682791983414 |  | 2G_Faganeanea-2 | 99.36842105263159 |  | 2G_Onenoa-1 | 99.58762886597938 |  | 2G_Matuu-1 | 99.43449575871819 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 99.48652118100128 |  | 2G_Afono-1 | 99.52380952380952 |  | 2G_Masefau-2 | 99.59839357429718
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Amanave-1 | 99.69040247678018 |  | 2G_Onenoa-1 | 99.37304075235109 |  | 2G_Malaeimi-1 | 99.62042788129745 |  | 2G_Masefau-1 | 99.48186528497409 |  | 2G_Utulei-3 | 99.55135773317592 |  | 2G_Leone-2 | 99.52941176470588 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 99.65397923875432
Top 10 Low Traffic Volume: | 2012-12-28 00:00:00 |  |  | 2012-12-29 00:00:00 |  |  | 2012-12-30 00:00:00 |  |  | 2012-12-31 00:00:00 |  |  | 2013-01-01 00:00:00 |  |  | 2013-01-02 00:00:00 |  |  | 2013-01-03 00:00:00
GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl) |  | GSM CELL | Traffic Volume on TCH(Erl)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TestPico-1 | 0 |  | 2G_ForsgrenOffice 2ndFlr-1 | 1.558 |  | 2G_ForsgrenOffice 2ndFlr-1 | 0.003 |  | 2G_ForsgrenOffice 2ndFlr-1 | 2.183 |  | 2G_Aunuu-3 | 1.977 |  | 2G_ForsgrenOffice 2ndFlr-1 | 2.355 |  | 2G_ForsgrenOffice 2ndFlr-1 | 1.969
 |  |  | 2G_Poloa-2 | 2.447 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenOffice 2ndFlr-1 | 1.952 |  | 2G_Poloa-2 | 2.447 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 0.241 |  | 2G_Poloa-2 | 2.33 |  | 2G_ForsgrenOffice 2ndFlr-1 | 2.18 |  | 2G_TradewindsHotel-1 | 2.415 |  | 2G_Alofau-3 | 4.055000000000001
 |  |  | 2G_TradewindsHotel-1 | 2.778 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 3.377 |  | 2G_TradewindsHotel-1 | 2.778 |  | 2G_TradewindsHotel-1 | 2.127 |  | 2G_Alofau-3 | 2.506 |  | 2G_Poloa-2 | 2.493 |  | 2G_Aunuu-3 | 2.719 |  | 2G_TradewindsHotel-1 | 4.619000000000001
 |  |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 3.534 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_TradewindsHotel-1 | 4.172000000000001 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 3.534 |  | 2G_Alofau-3 | 4.061 |  | 2G_TradewindsHotel-1 | 2.788 |  | 2G_Alofau-3 | 2.669 |  | 2G_Alofau-3 | 3.148 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 4.764999999999999
 |  |  | 2G_Alofau-3 | 5.439 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Alofau-3 | 4.302 |  | 2G_Alofau-3 | 5.439 |  | 2G_LaufouShoppingCtr 1stFlr-1 | 4.22 |  | 2G_Malaeimi-3 | 3.43 |  | 2G_TradewindsHotel-1 | 3.041 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 4.341 |  | 2G_Poloa-2 | 5.616
 |  |  | 2G_Malaeimi-3 | 6.321999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Poloa-2 | 4.365 |  | 2G_Malaeimi-3 | 6.321999999999999 |  | 2G_Malaeimi-3 | 4.401999999999999 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 3.77 |  | 2G_ForsgrenShoppingCtr 1stFlr-1 | 3.572 |  | 2G_Poloa-2 | 4.747999999999999 |  | 2G_Malaeimi-3 | 5.861000000000001
 |  |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 6.736000000000001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Aunuu-3 | 4.61 |  | 2G_LaufouShoppingCtr 2ndFlr-1 | 6.736000000000001 |  | 2G_Aunuu-3 | 4.839 |  | 2G_Aunuu-3 | 3.806 |  | 2G_Malaeimi-3 | 4.568000000000001 |  | 2G_Malaeimi-3 | 4.808999999999999 |  | 2G_Amanave-1 | 6.210999999999999
 |  |  | 2G_Aunuu-3 | 6.805 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Masefau-1 | 4.774999999999999 |  | 2G_Aunuu-3 | 6.805 |  | 2G_Poloa-2 | 5.205 |  | 2G_Masefau-1 | 5.903 |  | 2G_Masefau-2 | 6.963 |  | 2G_Masefau-1 | 5.921 |  | 2G_Aunuu-3 | 8.132
 |  |  | 2G_Masefau-1 | 8.424 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Malaeimi-3 | 4.849 |  | 2G_Masefau-1 | 8.424 |  | 2G_Laulii-1 | 10.267 |  | 2G_Amanave-1 | 9.535 |  | 2G_Tula-2 | 8.82 |  | 2G_Tula-2 | 8.776000000000002 |  | 2G_Masefau-1 | 9.248
 |  |  | 2G_Faganeanea-2 | 10.904 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2G_Masefau-2 | 10.375 |  | 2G_Faganeanea-2 | 10.904 |  | 2G_Utulei-1 | 11.74 |  | 2G_Masefau-2 | 9.99 |  | 2G_Masefau-1 | 9.053999999999998 |  | 2G_Masefau-2 | 9.011 |  | 2G_Laulii-1 | 10.882