Instructions 1. Open TiPP-G with latest work 2. Export Log Files from TiPP-G #. Enter inp$ts in !ellow fields of '. (elect path of F)T files* cel fi +. (elect and ,$n rele"ant macr . (ee (tat$s ar for Progress a Function //0 (can )eas$rements ,xLe" ! (canner ,adio )eas$rements ,etainailit! ccessiilit! $alit! 3ata Thro$ghp$t FTP 3ata Latenc! Pings Output Sheets ll cells in !ellow can e edited ll cells in l$e sho$ld not e ed
space and cel file loaded ! loading the export t!pe pro"ided %&np$t &ndex% le and o$tp$t files o as per elow nd )essages Notes &ndi"id$al (&/4//0 if in top 25 3ispla!s est (er"er ,xLe" and /ell 3ispla!s ,xLe"*,x$al*TxPwr*T*(peech /odec 3rops locks 6oice7 E,* FE,. 3ata7 ,L/ LE, 3ata FTP7 ,L/ Thro$ghp$t 3ata Latenc!7 Ping ($ccess and Latenc! from &dle and cti"e states
! the $ser to fit needs ited
Binned 8es
Test Type 3ri"eTest
8es 8es 94 94 8es 8es 94
3ri"eTest ll ll ll ll ll ll
Enter the workspace thematic settings below Rxe! Le"elfrom Le"elto /olo$r (hape (i:e -115 -155 lack /ircle -155 -=5 P$rple /ircle -=5 -;5 )agenta /ircle -;5 -<5 ,ed /ircle -<5 -5 Orange /ircle -5 -+5 8ellow /ircle -+5 -'# Green /ircle defa$lt >hite /ircle
#apin$o %ro&ection >G(;'
Rx"ual Le"elfrom Le"elto ; < ; + ; # ; 1 ; defa$lt ; ; ;
/olo$r (hape + LightGreen/ ircle # LightGreen/ ircle 1 LightGreen/ ircle 5 LightGreen /ircle >hite /ircle
(i:e 1' 15 ; ';
S"I Le"elfrom Le"elto /olo$r (hape #5 25 Green /ircle 25 12 Lightl$e/ ircle 12 5 Orange /ircle 5 -25 ,ed /ircle defa$lt >hite /ircle
(i:e
T# x% Sower Le"elfrom Le"elto /olo$r ; -+5 -15 Green ; -15 15 LightGreen ; 15 25 Orange ; 25 #5 ,ed ; defa$lt >hite
(hape /ircle /ircle /ircle /ircle /ircle
(i:e ; ; ; ; ;
BER Le"elfrom Le"elto /olo$r (hape 5 1.+ Light Gree /ircle 1.+ + Green /ircle + 155 ,ed /ircle defa$lt >hite /ircle
(i:e
'ata(' Le"elfrom Le"elto ' 5 1 1 #2 15 #2 ' '; ' 12; 12; 2+ 2+ #;' #;' 15555 defa$lt
/olo$r ,ed )agenta Orange 8ellow 3arkl$e/ Lightl$e/ Green >hite
(hape /ircle /ircle /ircle /ircle ircle ircle /ircle /ircle
(i:e ; ; ; ; ; ; ; ;
'ata() Le"elfrom Le"elto /olo$r (hape 5 ; ,ed /ircle ; 1 P$rple /ircle 1 #2 Orange /ircle #2 ' 8ellow /ircle ' 12; 3arkl$e/ ircle 12; +555 Green /ircle defa$lt >hite /ircle
(i:e ; ; ; ; ; ; ;
*hoices +do not change, /olo$r &ndex (hape &ndex >hite 1<<<21+ /ircle #+ 8ellow 1<<=5 (?$are ## Orange 1<+5'53 iamond #' ,ed 1<11;5 /ross +< LightGreen 11+==<=2 (tar # Green +2;5 9one Light l$e ++#+ 3ark l$e 2++ )agenta P$rple Gre! lack 9one
1<11=#+ ;#;;<# ='<'1=2 5
(i:e ' ; 15 12 1' 1 1; 25 #2 '; 9one
Yellow Cells below are for user input before starting the macros Enter TE#S .ersion Ente#r* Son$iguration )(1 )(2 )(# )(' )(+ )( Set Test Type@see &nstr$ctions sheet for macros in (tationar! modeA Set Binning
Note- This workbook
6ersion =.x #T Sype 6oice G()
(canner G() 3ri"e Test
Enter inning T!pe ! 3istance ins Enter in (i:e @in metresA - $se with inning T!pe %3istance ins% onl! +5 %ath o$ Input F#T $iles /7B3oc$ments and (ettingsBepadima.EP/B3esktopBT&PPBLogsBG()Bnthon! $straliaBlank , &nsert Path D File name %ath o$ cel $ile &nsert Path
%ath o$ Output $iles /7B3oc$ments and (ettingsBepadima.EP/B3esktopBT&PPBLogsBG()Bnthon! $straliaBlank , &nsert Path og $ile names below 511;C151.F)T 511;C152.F)T 511;C15#.F)T 511;C15'.F)T 511;C15+.F)T 511;C15.F)T 511;C15<.F)T 511;C15;.F)T 511;C15=.F)T 511;C115.F)T
must be closed be$ore each run (canner F$nctions
BCCH/BSIC Scans
)( T!pes G()(can G()6oice G()3ata
RxLev by Scanner
E F$nctions
RxLev/RxQual/TxPwr/TA Retainability Accessibility Quality (BLER) ata T!r"u#!$ut (%TP) ata Latency (Pin#s) ,eports
&eneric 'PI Re$"rt
1 1 1 1 1 1 1 1 1 5 5 5 5 5 5 5 5 5 5
#acro
'etails
Impact
Solution
og File Names
B**/ Number BSI* Number
B**/(BSI* Filename
0Samples raw
0Samples binned
#et ric )E Type /all ttempts /all ($ccesses *S .oice Ser!ice #etrics
/all (et$p ($ccess ,ate )ean /all (et$p Time @sA Total /all Time @minsA /all 3rop ,ate "erage E, P3P ttempts P3P cti"ations
%S 'ata Ser!ice #etrics
Packet ttach ($ccess ,ate )ean Packet ttach Time @sA (essions (ession 3rop ,ate "erage LE, "g 3L ,L/ Thro$ghp$t @kpsA "g L ,L/ Thro$ghp$t @kpsA )ax 3L ,L/ Thro$ghp$t @kpsA )ax L ,L/ Thro$ghp$t @kpsA
#S1
# S2
# S3
#S4
# S5
# S6
Rxe! e!els Rx"ual e!els -125 -11< -11' -111 -15; -15+ -152 -== -= -=# -=5 -;< -;' -;1 -<; -<+ -<2 -= - -# -5 -+< -+' -+1 -'; -'+ -'2 -#= -# -## -#5 -2< -2' -21 -1; -1+ -12 -=
S"I 5 1 2 # ' + <
-25 -1< -1' -11 -; -+ -2 1 ' < 15 1# 1 1= 22 2+ 2; #1
#S Tx %ower T7 le!els 'ata Throughput 5 5 2 2 ' ' ; ; 15 15 12 12 1' 1' 1 1 1; 1; 25 22 2' 2 2; #5 #2 #' # #; '5
25 22 2' 2 2; #5 #2 #' # #; '5 '2 '' ' '; +5 +2 +' + +; 5 2 '
9ote7 Le"els ao"e m$st e e?$idistant. Email de"eloper if non-e?$idistant le"els needed
5 15 25 #5 '5 +5 5 <5 ;5 =5
155 115 125 1#5 1'5 1+5 15 1<5 1;5 1=5 255 215 225 2#5 2'5
To create /istrograms manually +eg $or Rxe!,1. Load %3ata nal!sis% @or %nal!sis ToolPak%A mod$le to Excel7 Tools dd-&ns.. 2. Go to O$tp$t sheet. Eg %,F% sheet #. ,$n Tools 3ata nal!sis 0istogram &np$t ,ange7 (elect the ,xLe" col$mn @from row2 downA in ,F sheet in ,ange7 (elect the ,xLe" Le"els area @no headerA in this sheet O$tp$t ,ange7 /hoose top cell in empt! col$mn in ,F sheet* recommended /ol$mn O and e!ond '. /heck /$m$lati"e Percentage +. /reate P3F and /3F graphs from tale generated
Excel 6ersion 15m5@$ild72A
.ersion 1.5.1 1.5.2 1.1 1.1.1 1.2 1.2.1 1.2.2 1.2.# 1.2.' 1.2.+
'ate 24154255+ 24124255+ 241#4255+ +4#14255< +4#14255< #41;4255; +42+4255; 42+4255; 42+4255; <4154255;
7uthor 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io
1.2. 1.# 1.#.1 1.#.2 1.#.# 1.#.' 1.#.+
<4114255; <41+4255; <42;4255; 15414255; 1541+4255; 114#4255; 124154255;
3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io 3amian 3imar:io
1.#. F$t$re
3amian3imar:io
*hanges dded //0 (can )eas$rement )acro inning now done in text format d$e to +555 limit in Excel. lso fixed $g in finding //0C(&/ in //0 list Release /hange //0 to top 15. dd 3rops* ccess* LE,* ,xLe"4,x$al4)( Tx Power4T Release dd G() (canner ,xLe" F$nction. /hanged tex file @(canned ,xLe"-(trongest (canned ,xLe"A and added /ell 9ame dd con"ersion of coordinates from (4> dddd.dddd to H4- dd.dddd dd 3ata Thro$ghp$t macro. Fix P( ccess and LE, dd 3ata Latenc! )acro. Fix gridfree inning for non-linear entities dd /odec T!pe &E to ,F )eas$rements. dd ,eport7 asic (tats and Graphs @,xLe"*,x$al*)( TxPower*T*3ata Thro dd 3istance inning to //0 (cans* dd )apinfo Plot for (er"ing /ell Release dded some new messages4e"ents for access4drops /hange )apinfo workspace for 3rop calls. )essage was incorrect. dd search for Lat4Long in cel file rather than ass$min dd //0 to ,F)eas$rements )acro dd (&* workspace for (peech /odec dded T&"= capailit! Fix $g where latit$de coordinates so$th of e?$ator are positi"e. (et (& to non-mandator! in ,F meas$rements* add wa dd ProJection selection in )apinfo settings sheet /hange latlong inp$t format from ddddd.dddd to dddmm.mmmm dd 0O E"ents and IP&s
'istribution 9one 9one 9K ) x3ri"e 9K ) x3ri"e x3ri"e none 9K )*)orocco*rgentina )orocco )orocco I(Tool $stralia $stralia* (o$th frica angladesh angladesh )ala!sia
$stralia )ala!sia
T!I89: x S# Time )( Frame9$mer 3irection )essageT!pe E"ent E"ent&nfo ll-Latit$de ll-Longit$de ll-(trongest (canned ,F/95M ll-(trongest (canned (&/5M ll-(trongest (canned ,xLe" @dmA5M ll-(trongest (canned /ell 9ame5M ll-(trongest (canned ,F/91M ll-(trongest (canned (&/1M ll-(trongest (canned ,xLe" @dmA1M ll-(trongest (canned /ell 9ame1M ll-(trongest (canned ,F/92M ll-(trongest (canned (&/2M ll-(trongest (canned ,xLe" @dmA2M ll-(trongest (canned /ell 9ame2M ll-(trongest (canned ,F/9#M ll-(trongest (canned (&/#M ll-(trongest (canned ,xLe" @dmA#M ll-(trongest (canned /ell 9ame#M ll-(trongest (canned ,F/9'M ll-(trongest (canned (&/'M ll-(trongest (canned ,xLe" @dmA'M ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest
(canned /ell 9ame'M (canned ,F/9+M (canned (&/+M (canned ,xLe" @dmA+M (canned /ell 9ame+M (canned ,F/9M (canned (&/M (canned ,xLe" @dmAM (canned /ell 9ameM (canned ,F/9
ll-(trongest (canned ,F/9=M ll-(trongest (canned (&/=M ll-(trongest (canned ,xLe" @dmA=M ll-(trongest (canned /ell 9ame=M ll-,F/9 //0
T!I;9: x S# Time )( Frame9$mer 3irection )essageT!pe E"ent E"ent&nfo ll-Latit$de ll-Longit$de ll-(trongest (canned ,F/95M ll-(trongest (canned (&/5M ll-(trongest (canned ,xLe" @dmA5M ll-(trongest (canned /ell 9ame5M ll-(trongest (canned ,F/91M ll-(trongest (canned (&/1M ll-(trongest (canned ,xLe" @dmA1M ll-(trongest (canned /ell 9ame1M ll-(trongest (canned ,F/92M ll-(trongest (canned (&/2M ll-(trongest (canned ,xLe" @dmA2M ll-(trongest (canned /ell 9ame2M ll-(trongest (canned ,F/9#M ll-(trongest (canned (&/#M ll-(trongest (canned ,xLe" @dmA#M ll-(trongest (canned /ell 9ame#M ll-(trongest (canned ,F/9'M ll-(trongest (canned (&/'M ll-(trongest (canned ,xLe" @dmA'M ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest ll-(trongest
(canned /ell 9ame'M (canned ,F/9+M (canned (&/+M (canned ,xLe" @dmA+M (canned /ell 9ame+M (canned ,F/9M (canned (&/M (canned ,xLe" @dmAM (canned /ell 9ameM (canned ,F/9
ll-(trongest (canned ,F/9=M ll-(trongest (canned (&/=M ll-(trongest (canned ,xLe" @dmA=M ll-(trongest (canned /ell 9ame=M ll-,F/9 //0
ll-,F/9 T/0 ll-E, ct$al @NA ll-(&/ @9$mA ll-/4& est5M ll-/4& >orst5M ll-/ell &d ll-/ell 9ame ll-3ata )ode ll-FE, ct$al @NA ll-)ode ll-)( TxPower @dmA ll-,L/ LE, 3L @NA ll-,L/ LE, L @NA ll-,L/ Thro$ghp$t 3L @kit4sA ll-,L/ Thro$ghp$t L @kit4sA ll-,xLe" F$ll @dmA ll-,xLe" ($ @dmA ll-,x$al F$ll ll-,x$al ($ ll-(& ll-T ll-(peech /odec
ll-,F/9 T/0 ll-E, ct$al @NA ll-(&/ @9$mA ll-/4& est5M ll-/4& >orst5M ll-/ell &d ll-/ell 9ame ll-3ata )ode ll-FE, ct$al @NA ll-)ode ll-)( TxPower @dmA ll-,L/ LE, 3L @NA ll-,L/ LE, L @NA ll-,L/ Thro$ghp$t 3L @kit4sA ll-,L/ Thro$ghp$t L @kit4sA ll-,xLe" F$ll @dmA ll-,xLe" ($ @dmA ll-,x$al F$ll ll-,x$al ($ ll-(& ll-T ll-(peech /odec
IEs to be re!iewed $or next release G() 9eigh ,F/91M G() 9eigh (&/1M G() 9eigh ,xLe"1M
