excellpf_version3 (1).xlsx
TRANSCRIPT
-
8/17/2019 ExcellPf_Version3 (1).xlsx
1/154
Parámetros del modelo de
Análisis Estadísticos
Matriz Origen-Destimo
-
8/17/2019 ExcellPf_Version3 (1).xlsx
2/154
Libro de Ruta
RUTA A-74
-
8/17/2019 ExcellPf_Version3 (1).xlsx
3/154
Tasas de llegada
Tiempo entre buses
Observaciones Genrales
-
8/17/2019 ExcellPf_Version3 (1).xlsx
4/154
Variables o AtributoDescripción igni!cado
PBPi Personas bajadas en la parada iPMPi Personas montándose en la parada iPersonasenelBus Capacidad Ocupada en el BusCapacidad Capacidad Disponible en el Bus
GPPi Grupo de personas montadas en la estación i
-
8/17/2019 ExcellPf_Version3 (1).xlsx
5/154
"#u$ es% &otas
Atributo i=JA..!Atributo i=JA.."AtributoAtributo
Variable i=JA.."
-
8/17/2019 ExcellPf_Version3 (1).xlsx
6/154
Vol#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
7/154
k=1 ()* am
+olmogorov-mirnov Test
,eibull
DP%&' (.()(*)+DM$,&' (.(!-)-D, (.()(*)+PValue (.-))/
k=2 )* pm
+olmogorov-mirnov Test
,eibull
Histogram
-0,2 0,8 1,8
Tasa de Llegada 1
0
20
40
60
80
100
f r e
q
u
e
n
c
y
Histogram
-0,4 1,6 3,6 5,6 ,
Tasa de Llegada 2
0
40
80
120
160
f r e
q
u
e
n
c
y
-
8/17/2019 ExcellPf_Version3 (1).xlsx
8/154
DP%&' (.(*+*/!"DM$,&' (.(()/-0D, (.(*+*/!"PValue (.0"/-)0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
9/154
Tasas de 'legada
Count /))A#era1e (.+")!/
(.)*"0!
/+!./!2
Minimum (.((Ma3imum +.0!04an1e +.0!(0
,eibull
s.ape / (.-+"+)+scale / (.+0"--
Count 0+!A#era1e (.)")+)"
(.-"(-00
/+0.!/2
Minimum (.(())Ma3imum ).)/(+4an1e ).)(!
,eibull
s.ape / (.-)!"
'tandardde#iation
Coe5. o6#ariation
'tandardde#iation
Coe5. o6#ariation
2,8 3,8
!,6
-
8/17/2019 ExcellPf_Version3 (1).xlsx
10/154
scale / (."*0)
-
8/17/2019 ExcellPf_Version3 (1).xlsx
11/154
Vol#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
12/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
13/154
Actual Montar 0a1ar Total 2 De 3ue ba1an
4A ( - ( - (.(2P5 - ( ( - (.(2P) - / /( /.+2P6 /( /( (.(2P7 /( /( (.(2
P /( /( (.(2P8 /( + / /0 /(.(2P( /0 /0 (.(2P9 /0 /0 (.(2P:* /0 ( / // !.+2P:: // / ( /0 (.(2P:5 /0 /0 (.(2P:) /0 /0 (.(2P:6 /0 / ( /+ (.(2P:7 /+ /+ (.(2
P: /+ ( / /0 -.-2P:8 /0 /0 (.(2P:( /0 /0 (.(2P:9 /0 ) 0 /) /*.-2P5* /) /) (.(2P5: /) /) (.(2P55 /) /) (.(2P5) /) /( /+ /0 !*.-2P56 /0 / ( /+ (.(2P57 /+ /+ (.(2P5 /+ /+ (.(2P58 /+ / / /+ -.-2P5( /+ ( / /0 -.-2P59 /0 ( + " 0).(2P)* " ( / ! //./2P): ! ! (.(2P)5 ! / 0 - 0).(2P)) - / 0 * 0!.*2P)6 * * (.(2P)7 * / / * /*.-2P) * / ( - (.(2P)8 - - (.(2P)( - - (.(2P)9 - - (.(2P6* - / ( ! (.(2P6: ! / ( " (.(2P65 " / ( /( (.(2P6) /( + / /0 /(.(2P66 /0 /0 (.(2
-
8/17/2019 ExcellPf_Version3 (1).xlsx
14/154
P67 /0 /0 (.(2P6 /0 /0 (.(2P68 /0 / ( /+ (.(2P6( /+ /+ ( /((.(2
;/5
Actual Montar 0a1ar Total 2 De 3ue ba1an
4A ( /+ ( /+ (.(2P5 /+ /+ (.(2P) /+ 0 // +(.!2P6 // / /( "./2P7 /( / " /(.(2P " " (.(2P8 " " (.(2
P( " / ! //./2P9 ! ! (.(2P:* ! / - /0.)2P:: - - (.(2P:5 - 0 ) 0!.*2P:) ) ) (.(2P:6 ) / 0(.(2P:7 (.(2P: (.(2P:8 0 * (.(2
P:( * / - (.(2P:9 - / / - /.+2P5* - - (.(2P5: - / / - /.+2P55 - - (.(2P5) - ! * " !).-2P56 " " (.(2P57 " " (.(2P5 " " (.(2P58 " 0 - 00.02P5( - - (.(2P59 - / ! (.(2P)* ! ! (.(2P): ! ! (.(2P)5 ! ! (.(2P)) ! ! (.(2P)6 ! ! (.(2P)7 ! / " (.(2P) " " (.(2
-
8/17/2019 ExcellPf_Version3 (1).xlsx
15/154
P)8 " " (.(2P)( " 0 - 00.02P)9 - - (.(2P6* - - (.(2P6: - / )-./2P65 (.(2
P6) (.(2P66 - / /( 0).(2P67 /( 0 /0 (.(2P6 /0 0 / (.(2P68 / / (.(2P6( / / ( /((.(2
7=+Actual Montar 0a1ar Total 2 De 3ue ba1an
4A ( + + (.(2
P5 + + (.(2P) + + (.(2P6 + + (.(2P7 + + (.(2P + + (.(2P8 + / 0 ++.+2P( 0 / / )(.(2P9 / / (.(2P:* / / (.(2P:: / / (.(2
P:5 / / (.(2P:) / / (.(2P:6 / / ( /((.(2P:7 ( ( (.(2P: ( ( (.(2P:8 ( ( (.(2P:( ( ( (.(2P:9 ( ( (.(2P5* ( ( ( (.(2P5: ( ( ( (.(2P55 ( ( ( (.(2P5) ( / ( / (.(2P56 / ( / (.(2P57 / / ( /((.(2P5 ( ( ( (.(2P58 ( ( ( (.(2P5( ( ( ( (.(2P59 ( / ( / (.(2P)* / ( / (.(2
-
8/17/2019 ExcellPf_Version3 (1).xlsx
16/154
P): / ( / (.(2P)5 / 0 ( + (.(2P)) + ( + (.(2P)6 + ( + (.(2P)7 + 0 ( ) (.(2P) ) / ( * (.(2
P)8 * 0 ( ! (.(2P)( ! / ( " (.(2P)9 " ( " (.(2P6* " ( " (.(2P6: " ( " (.(2P65 " ( " (.(2P6) " ( " (.(2P66 " ( " (.(2P67 " ( " (.(2P6 " ( " (.(2
P68 " ( " (.(2P6( " " ( /((.(2
7=
Actual Montar 0a1ar Total 2 De 3ue ba1an
4A ( ! ( ! (.(2P5 ! ( 0 * 0).(2P) * / ) 0 !+.+2P6 0 0 (.(2
P7 0 0 (.(2P 0 0 (.(2P8 0 0 (.(2P( / + 0).(2P9 + + (.(2P:* + + (.(2P:: + + (.(2P:5 + + (.(2P:) + / (.(2P:6 / ) (.(2P:7 ) ) (.(2P: ) ) (.(2P:8 ) / * (.(2P:( * 0 ! (.(2P:9 ! ! (.(2P5* ! ! (.(2P5: ! ! (.(2P55 ! ! (.(2P5) ! - - ! (.(2
-
8/17/2019 ExcellPf_Version3 (1).xlsx
17/154
P56 ! ! (.(2P57 ! ! (.(2P5 ! ! (.(2P58 ! ! (.(2P5( ! / / ! (.(2P59 ! ! (.(2
P)* ! / 0 - 0).(2P): - 0 ) 0!.*2P)5 ) ) (.(2P)) ) / 0(.(2P)6 (.(2P)7 (.(2P) (.(2P)8 / ) (.(2P)( ) / 0(.(2P)9 (.(2
P6* (.(2P6: (.(2P65 / / 0).(2P6) (.(2P66 / + 0).(2P67 + / (.(2P6 (.(2P68 / ) (.(2P6( ) ) ( /((.(2
7=)
Actual Montar 0a1ar Total 2 De 3ue ba1an
4A ( ( (.(2P5 ( ( 8D$V9(:P) ( ( 8D$V9(:P6 ( ( 8D$V9(:P7 ( ( 8D$V9(:P ( ( 8D$V9(:P8 ( ( 8D$V9(:P( ( ( 8D$V9(:P9 ( ( 8D$V9(:P:* ( ( 8D$V9(:P:: ( ( 8D$V9(:P:5 ( ( 8D$V9(:P:) ( ( 8D$V9(:P:6 ( ( 8D$V9(:P:7 ( ( (.(2
-
8/17/2019 ExcellPf_Version3 (1).xlsx
18/154
P: ( ( (.(2P:8 ( ( (.(2P:( ( ( (.(2P:9 ( ( (.(2P5* ( ( (.(2P5: ( ( (.(2
P55 ( ( (.(2P5) ( ( (.(2P56 ( ( 8D$V9(:P57 ( ( 8D$V9(:P5 ( ( (.(2P58 ( ( (.(2P5( ( ( (.(2P59 ( ( (.(2P)* ( ( 8D$V9(:P): ( ( 8D$V9(:
P)5 ( ( 8D$V9(:P)) ( ( 8D$V9(:P)6 ( ( 8D$V9(:P)7 ( ( 8D$V9(:P) ( ( 8D$V9(:P)8 ( ( 8D$V9(:P)( ( ( 8D$V9(:P)9 ( ( 8D$V9(:P6* ( ( 8D$V9(:P6: ( ( 8D$V9(:P65 ( ( 8D$V9(:P6) ( ( 8D$V9(:P66 ( ( 8D$V9(:P67 ( ( 8D$V9(:P6 ( ( 8D$V9(:P68 ( ( 8D$V9(:P6( ( ( 8D$V9(:
-
8/17/2019 ExcellPf_Version3 (1).xlsx
19/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
20/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
21/154
//;0(;(( AM
//;0+;(( AM
//;0";(( AM//;+(;(( AM//;+0;(( AM
//;+);(( AM
-
8/17/2019 ExcellPf_Version3 (1).xlsx
22/154
Observación
((;((.)0 (.(("();".!) ).!+/(0;))./ 0."/"(0;00."* 0.+!+
((;".*+ (.!0-(/;0).0- /.0/((;)0.!+ (.!!/((;!.0( (.!(+(/;/(.+( /./-0((;!./ (.!(0((;)+.+) (.!!"(/;/*.+- /.0-+(/;0*."/ /."(/;/."* /.0"((;+).!+ (.)"-(/;++.!( /.)*+(/;)*.( /."((/;/".!- /.++/((;)).- (."0"((;/+.)/ (.00)((;)+.** (.!"((;!."+ (.!/*((;!./" (.!(+
TE'' =ormato>ec.a
TE'' =ormatoDecimal ?min@
-
8/17/2019 ExcellPf_Version3 (1).xlsx
23/154
(/;)-.)/ /.")"((;-.// (.-!)(/;/(.)" /./--(/;//.*( /./"+(0;+(."/ 0.)/)((;)(."* (.!"
((;)*.!" (."!((;+/."/ (.)+0(/;0*.-- /.*((;+).!) (.)"!((;+!.)/ (.*0((;+0./0 (.)+)(0;(0.* 0.(/(/;//./" /./!-(/;(+.0* /.()(/;0(.+0 /.++"
(/;(/.!! /.(+/((;0".0 (.!-(/;*.)/ /.--)(0;++.(- 0.))/(/;0.!! /.-/)((;/(.(* (./*!(/;/-./0 /.0!)(/;+/.-! /.)+((0;).( 0.-)/
Observación
(;)*.)! ."+(/;/(.! /./!/(/;(+.+- /.()*(0;(.+0 0.*-0(/;(/.+ /.(0(/;(+."- /.(**((;)-.+* (.")*(/;0(.++ /.++"(+;(+.+ +.()-((;)".-0 (."")(/;+-.)0 /.*0)(/;(". /./)-(+;//.*0 +./"((;)-.(! (.")/((;+-.+0 (.*00
TE'' =ormato>ec.a
TE'' =ormatoDecimal ?min@
-
8/17/2019 ExcellPf_Version3 (1).xlsx
24/154
(/;/(.)- /./-*(/;)/.+- /.!)*((;0.+/ (.-()((;)).(" (."/!((;/*.! (.0!/(/;//./ /./!*
((;+-.(! (.*/!(/;0).! /.+/(+;(+.)( +.()!((;".!* (.!+/(/;0(.++ /.++"((;0.*) (.//(0;)".*0 0.""(+;/*.0( +.0-((0;)+.( 0.!"(((;)*.00 (."+-
(/;0(.++ /.++"((;+!.+) (.*+"(/;().(" /.(!)(/;+-."( /.*+0(0;+).-+ 0.)"*(/;0+.(+ /.+!(/;/.!" /.0!((;)".)( (.""0(/;(+.* /.()!((;!.- (.!/0(/;*./0 /.-*"((;).*0 (."/((0;0.! 0.-(!(+;+-.0* +.*0/(;(*.)0 ./("(/;00./0 /.+*"
(+;(*.(" +./(0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
25/154
Parada
Calle 76 No. 43B - 05
Calle 76 con carrera 42B U. Metropolitana Occidente
Calle 76 con carrera 39 C.C. Único Lado Occidente
Carrera 38 No. 76-06Calle 79! No. 35C-43 Lado Occidente
Calle 79! con carrera 33 "ar#$e Lado Occidente
Calle 79! con carrera 27 Lado Occidente
Carrera 26C7 No. 75-77 Lado %$r
Carrera 27 con calle 72 Lado %$r
Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r
Carrera 27 con calle 64 Me&a()* Lado %$r
Carrera 27 con calle 6 "ar#$e Lo* !nde*
Calle 6 No. 25-3Carrera 24 No. 59-45
Carrera 24 con calle 53 e*#.
+ia&onal 56 Me&a Cole&io Lado Norte
Carrera 26 No. 47C-0
Carrera 26 con calle 47C
Calle 48 No. 23-29
Carrera 23 No. 52-32
Carrera 23 con calle 53+ e*#.
Carrera 2B con calle 53+ ,*#.
Carrera 2B No. 60-28
Carrera 2B No. 64-26 ,. i(ne/
Carrera 2B con calle 65B e*#.
Carrera 2B No. 68C-4
Calle 70C con carrera 22+ ,*#.
Calle 70C con carrera 22+ ,*#.
Calle 70C No. 26B-44
Carrera 27 No. 72-0 Lado Norte
Calle 74B con carrera 26C7 Lado Noroccidente
Carrera 26C7 No. 75B-68 Lado Norte
Calle 79! con carrera 28 Lado Oriente
Calle 79! No. 34-22 Lado Oriente
Calle 79! No. 35+-50 Lado Oriente
Calle 76 con carrea 38! Lado Oriente
Calle 76 con carrera 42 U. Metropolitana Oriente
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
Calle 76 con carrera 39 C.C. Único Lado Oriente
-
8/17/2019 ExcellPf_Version3 (1).xlsx
26/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
27/154
Calle 74B con carrera 26C7 Lado Noroccidente
Carrera 26C7 No. 75B-68 Lado Norte
Calle 79! con carrera 28 Lado Oriente
Calle 79! No. 34-22 Lado Oriente
Calle 79! No. 35+-50 Lado Oriente
Calle 76 con carrea 38! Lado Oriente
Calle 76 con carrera 42 U. Metropolitana Oriente
Calle 79 con carrera 42 C.,. Litoral
Calle 79 con carrera 45
Carrera 46 No. 76 - 09 Lado %$r
Parada
Calle 76 No. 43B - 05Calle 76 con carrera 42B U. Metropolitana Occidente
Calle 76 con carrera 39 C.C. Único Lado Occidente
Carrera 38 No. 76-06
Calle 79! No. 35C-43 Lado Occidente
Calle 79! con carrera 33 "ar#$e Lado Occidente
Calle 79! con carrera 27 Lado Occidente
Carrera 26C7 No. 75-77 Lado %$r
Carrera 27 con calle 72 Lado %$r Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r
Carrera 27 con calle 64 Me&a()* Lado %$r
Carrera 27 con calle 6 "ar#$e Lo* !nde*
Calle 6 No. 25-3
Carrera 24 No. 59-45
Carrera 24 con calle 53 e*#.
+ia&onal 56 Me&a Cole&io Lado Norte
Carrera 26 No. 47C-0
Carrera 26 con calle 47C
Calle 48 No. 23-29
Carrera 23 No. 52-32
Carrera 23 con calle 53+ e*#.
Carrera 2B con calle 53+ ,*#.
Carrera 2B No. 60-28
Carrera 2B No. 64-26 ,. i(ne/
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
-
8/17/2019 ExcellPf_Version3 (1).xlsx
28/154
Carrera 2B con calle 65B e*#.
Carrera 2B No. 68C-4
Calle 70C con carrera 22+ ,*#.
Calle 70C con carrera 22+ ,*#.
Calle 70C No. 26B-44
Carrera 27 No. 72-0 Lado Norte
Calle 74B con carrera 26C7 Lado NoroccidenteCarrera 26C7 No. 75B-68 Lado Norte
Calle 79! con carrera 28 Lado Oriente
Calle 79! No. 34-22 Lado Oriente
Calle 79! No. 35+-50 Lado Oriente
Calle 76 con carrea 38! Lado Oriente
Calle 76 con carrera 42 U. Metropolitana Oriente
Calle 79 con carrera 42 C.,. Litoral
Calle 79 con carrera 45
Carrera 46 No. 76 - 09 Lado %$r
10:00 AM
Parada
Calle 76 No. 43B - 05
Calle 76 con carrera 42B U. Metropolitana Occidente
Calle 76 con carrera 39 C.C. Único Lado Occidente
Carrera 38 No. 76-06
Calle 79! No. 35C-43 Lado Occidente
Calle 79! con carrera 33 "ar#$e Lado Occidente
Calle 79! con carrera 27 Lado Occidente
Carrera 26C7 No. 75-77 Lado %$r
Carrera 27 con calle 72 Lado %$r
Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r
Carrera 27 con calle 64 Me&a()* Lado %$r
Carrera 27 con calle 6 "ar#$e Lo* !nde*
Calle 6 No. 25-3
Carrera 24 No. 59-45
Carrera 24 con calle 53 e*#.
+ia&onal 56 Me&a Cole&io Lado Norte
Carrera 26 No. 47C-0
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
-
8/17/2019 ExcellPf_Version3 (1).xlsx
29/154
Carrera 26 con calle 47C
Calle 48 No. 23-29
Carrera 23 No. 52-32
Carrera 23 con calle 53+ e*#.
Carrera 2B con calle 53+ ,*#.
Carrera 2B No. 60-28
Carrera 2B No. 64-26 ,. i(ne/Carrera 2B con calle 65B e*#.
Carrera 2B No. 68C-4
Calle 70C con carrera 22+ ,*#.
Calle 70C con carrera 22+ ,*#.
Calle 70C No. 26B-44
Carrera 27 No. 72-0 Lado Norte
Calle 74B con carrera 26C7 Lado Noroccidente
Carrera 26C7 No. 75B-68 Lado Norte
Calle 79! con carrera 28 Lado Oriente
Calle 79! No. 34-22 Lado OrienteCalle 79! No. 35+-50 Lado Oriente
Calle 76 con carrea 38! Lado Oriente
Calle 76 con carrera 42 U. Metropolitana Oriente
Calle 79 con carrera 42 C.,. Litoral
Calle 79 con carrera 45
Carrera 46 No. 76 - 09 Lado %$r
6:45 AM
Parada
Calle 76 No. 43B - 05
Calle 76 con carrera 42B U. Metropolitana Occidente
Calle 76 con carrera 39 C.C. Único Lado Occidente
Carrera 38 No. 76-06
Calle 79! No. 35C-43 Lado Occidente
Calle 79! con carrera 33 "ar#$e Lado Occidente
Calle 79! con carrera 27 Lado Occidente
Carrera 26C7 No. 75-77 Lado %$r
Carrera 27 con calle 72 Lado %$r
Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r
Carrera 27 con calle 64 Me&a()* Lado %$r
Carrera 27 con calle 6 "ar#$e Lo* !nde*
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
-
8/17/2019 ExcellPf_Version3 (1).xlsx
30/154
Calle 6 No. 25-3
Carrera 24 No. 59-45
Carrera 24 con calle 53 e*#.
+ia&onal 56 Me&a Cole&io Lado Norte
Carrera 26 No. 47C-0
Carrera 26 con calle 47C
Calle 48 No. 23-29
Carrera 23 No. 52-32
Carrera 23 con calle 53+ e*#.
Carrera 2B con calle 53+ ,*#.
Carrera 2B No. 60-28
Carrera 2B No. 64-26 ,. i(ne/
Carrera 2B con calle 65B e*#.
Carrera 2B No. 68C-4Calle 70C con carrera 22+ ,*#.
Calle 70C con carrera 22+ ,*#.
Calle 70C No. 26B-44
Carrera 27 No. 72-0 Lado Norte
Calle 74B con carrera 26C7 Lado Noroccidente
Carrera 26C7 No. 75B-68 Lado Norte
Calle 79! con carrera 28 Lado Oriente
Calle 79! No. 34-22 Lado Oriente
Calle 79! No. 35+-50 Lado Oriente
Calle 76 con carrea 38! Lado Oriente
Calle 76 con carrera 42 U. Metropolitana Oriente
Calle 79 con carrera 42 C.,. Litoral
Calle 79 con carrera 45
Carrera 46 No. 76 - 09 Lado %$r
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
-
8/17/2019 ExcellPf_Version3 (1).xlsx
31/154
K=1
Parada 2 De 3ue ba1an
(.(2Calle 76 No. 43B - 05 (.(2Calle 76 con carrera 42B U. Metropolitana Occidente /.+2Calle 76 con carrera 39 C.C. Único Lado Occidente (.(2
(.(2Carrera 38 No. 76-06 (.(2Calle 79! No. 35C-43 Lado Occidente /(.(2Calle 79! con carrera 33 "ar#$e Lado Occidente (.(2Calle 79! con carrera 27 Lado Occidente (.(2Carrera 26C7 No. 75-77 Lado %$r !.+2
(.(2Carrera 27 con calle 72 Lado %$r (.(2Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r (.(2Carrera 27 con calle 64 Me&a()* Lado %$r (.(2
Carrera 27 con calle 6 "ar#$e Lo* !nde* (.(2Calle 6 No. 25-3 -.-2Carrera 24 No. 59-45 (.(2
(.(2/*.-2
Carrera 24 con calle 53 e*#. (.(2+ia&onal 56 Me&a Cole&io Lado Norte (.(2
(.(2Carrera 26 No. 47C-0 !*.-2Carrera 26 con calle 47C (.(2
Calle 48 No. 23-29 (.(2
Carrera 23 No. 52-32 (.(2Carrera 23 con calle 53+ e*#. -.-2Carrera 2B con calle 53+ ,*#. -.-2Carrera 2B No. 60-28 0).(2Carrera 2B No. 64-26 ,. i(ne/ //./2Carrera 2B con calle 65B e*#. (.(2Carrera 2B No. 68C-4 0).(2Calle 70C con carrera 22+ ,*#. 0!.*2Calle 70C con carrera 22+ ,*#. (.(2Calle 70C No. 26B-44 /*.-2Carrera 27 No. 72-0 Lado Norte (.(2Calle 74B con carrera 26C7 Lado Noroccidente (.(2Carrera 26C7 No. 75B-68 Lado Norte (.(2Calle 79! con carrera 28 Lado Oriente (.(2Calle 79! No. 34-22 Lado Oriente (.(2Calle 79! No. 35+-50 Lado Oriente (.(2Calle 76 con carrea 38! Lado Oriente (.(2
/(.(2
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
Calle 76 con carrera 39 C.C. Único Lado Oriente
-
8/17/2019 ExcellPf_Version3 (1).xlsx
32/154
Calle 76 con carrera 42 U. Metropolitana Oriente (.(2Calle 79 con carrera 42 C.,. Litoral (.(2Calle 79 con carrera 45 (.(2Carrera 46 No. 76 - 09 Lado %$r (.(2
/((.(2
K=1
Parada 0a1ar
(Calle 76 No. 43B - 05 (Calle 76 con carrera 42B U. Metropolitana Occidente /Calle 76 con carrera 39 C.C. Único Lado Occidente (
(Carrera 38 No. 76-06 (Calle 79! No. 35C-43 Lado Occidente /Calle 79! con carrera 33 "ar#$e Lado Occidente (
Calle 79! con carrera 27 Lado Occidente (Carrera 26C7 No. 75-77 Lado %$r /
(Carrera 27 con calle 72 Lado %$r (Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r (Carrera 27 con calle 64 Me&a()* Lado %$r (Carrera 27 con calle 6 "ar#$e Lo* !nde* (Calle 6 No. 25-3 /Carrera 24 No. 59-45 (
(
0Carrera 24 con calle 53 e*#. (+ia&onal 56 Me&a Cole&io Lado Norte (
(Carrera 26 No. 47C-0 /+Carrera 26 con calle 47C (Calle 48 No. 23-29 (Carrera 23 No. 52-32 (Carrera 23 con calle 53+ e*#. /Carrera 2B con calle 53+ ,*#. /Carrera 2B No. 60-28 +Carrera 2B No. 64-26 ,. i(ne/ /Carrera 2B con calle 65B e*#. (Carrera 2B No. 68C-4 0Calle 70C con carrera 22+ ,*#. 0Calle 70C con carrera 22+ ,*#. (Calle 70C No. 26B-44 /Carrera 27 No. 72-0 Lado Norte (Calle 74B con carrera 26C7 Lado Noroccidente (
,*t. oe !rro'o
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
-
8/17/2019 ExcellPf_Version3 (1).xlsx
33/154
Carrera 26C7 No. 75B-68 Lado Norte (Calle 79! con carrera 28 Lado Oriente (Calle 79! No. 34-22 Lado Oriente (Calle 79! No. 35+-50 Lado Oriente (Calle 76 con carrea 38! Lado Oriente (
/
Calle 76 con carrera 42 U. Metropolitana Oriente (Calle 79 con carrera 42 C.,. Litoral (Calle 79 con carrera 45 (Carrera 46 No. 76 - 09 Lado %$r (
/+
K=4
Parada TEP
(.(("Calle 76 No. 43B - 05 ).!+/
Calle 76 con carrera 42B U. Metropolitana Occidente 0."/"Calle 76 con carrera 39 C.C. Único Lado Occidente 0.+!+
(.!0-Carrera 38 No. 76-06 /.0/Calle 79! No. 35C-43 Lado Occidente (.!!/Calle 79! con carrera 33 "ar#$e Lado Occidente (.!(+Calle 79! con carrera 27 Lado Occidente /./-0Carrera 26C7 No. 75-77 Lado %$r (.!(0
(.!!"Carrera 27 con calle 72 Lado %$r /.0-+
Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r /."Carrera 27 con calle 64 Me&a()* Lado %$r /.0"Carrera 27 con calle 6 "ar#$e Lo* !nde* (.)"-Calle 6 No. 25-3 /.)*+Carrera 24 No. 59-45 /."(
/.++/(."0"
Carrera 24 con calle 53 e*#. (.00)+ia&onal 56 Me&a Cole&io Lado Norte (.!"
(.!/*Carrera 26 No. 47C-0 (.!(+Carrera 26 con calle 47C /.")"Calle 48 No. 23-29 (.-!)Carrera 23 No. 52-32 /./--Carrera 23 con calle 53+ e*#. /./"+Carrera 2B con calle 53+ ,*#. 0.)/)Carrera 2B No. 60-28 (.!"Carrera 2B No. 64-26 ,. i(ne/ (."!Carrera 2B con calle 65B e*#. (.)+0
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
-
8/17/2019 ExcellPf_Version3 (1).xlsx
34/154
Carrera 2B No. 68C-4 /.*Calle 70C con carrera 22+ ,*#. (.)"!Calle 70C con carrera 22+ ,*#. (.*0Calle 70C No. 26B-44 (.)+)Carrera 27 No. 72-0 Lado Norte 0.(/Calle 74B con carrera 26C7 Lado Noroccidente /./!-
Carrera 26C7 No. 75B-68 Lado Norte /.()Calle 79! con carrera 28 Lado Oriente /.++"Calle 79! No. 34-22 Lado Oriente /.(+/Calle 79! No. 35+-50 Lado Oriente (.!-Calle 76 con carrea 38! Lado Oriente /.--)
0.))/Calle 76 con carrera 42 U. Metropolitana Oriente /.-/)Calle 79 con carrera 42 C.,. Litoral (./*!Calle 79 con carrera 45 /.0!)Carrera 46 No. 76 - 09 Lado %$r /.)+(
0.-)/
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
-
8/17/2019 ExcellPf_Version3 (1).xlsx
35/154
K=2 K=3 K=4
2 De 3ue ba1an 2 De 3ue ba1an 2 De 3ue ba1an
(.(2 (.(2 (.(2 /(.(2 (.(2 0).(2 + (.-)
+(.!2 (.(2 !+.+2 / (.0)"./2 (.(2 (.(2 + (.-)
/(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 1(.(2 ++.+2 (.(2 0 (.)
//./2 )(.(2 0).(2 / (.0)(.(2 (.(2 (.(2 /
/0.)2 (.(2 (.(2 0 (.)(.(2 (.(2 (.(2 /
0!.*2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 /
0(.(2 /((.(2 (.(2 0 (.)
(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 /
/.+2 (.(2 (.(2 0 (.)(.(2 (.(2 (.(2 /
/.+2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 /
!).-2 (.(2 (.(2 0 (.)(.(2 (.(2 (.(2 /(.(2 /((.(2 (.(2 + (.-)(.(2 (.(2 (.(2 /
00.02 (.(2 (.(2 0 (.)(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 0).(2 0 (.)(.(2 (.(2 0!.*2 + (.-)(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 0(.(2 0 (.)(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 + (.-)(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 /
00.02 (.(2 0(.(2 0 (.)(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 /
)-./2 (.(2 (.(2 + (.-)(.(2 (.(2 0).(2 + (.-)(.(2 (.(2 (.(2 + (.-)
-
8/17/2019 ExcellPf_Version3 (1).xlsx
36/154
0).(2 (.(2 0).(2 0 (.)(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 /(.(2 (.(2 (.(2 /
/((.(2 /((.(2 /((.(2 ( (
K=2 K=3 K=4
0a1ar 0a1ar 0a1ar
( (( 0 )//(( // / /
(/(0(/ /((((
/( (/ (( (* ( -( (( /( (0 (( ( /( (( ( 0( ( 0( (( ( /( (( (( (( (
-
8/17/2019 ExcellPf_Version3 (1).xlsx
37/154
0 ( /( (( ( (( ( /( (
/ ( +( (( (( (
/ " )
K=5
TEP
."+/./!/
/.()*0.*-0/.(0/.(**(.")*/.++"+.()-(."")/.*0)/./)-
+./"(.")/(.*00/./-*/.!)*(.-()(."/!(.0!//./!*(.*/!/.+/+.()!(.!+//.++"(.//0.""+.0-(0.!"((."+-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
38/154
/.++"(.*+"/.(!)/.*+00.)"*/.+!
/.0!(.""0/.()!(.!/0/.-*"(."/(0.-(!+.*0/./("/.+*"
+./(0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
39/154
Vol#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
40/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
41/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
42/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
43/154
(/;(0.!! /.(!(
((;((.!! (.(/-((;)0.-* (.!-"+((;)-.!/ (."*+)((;((.** (.(//(((;0!.0* (.-/(((;/*."+ (.0!00((;(.0+ (.(-()((;//.0) (./!-)((;".)! (.!0*+((;)).+/ (."0/!
((;)).0* (."0/(((;(/."! (.(++(((;)0.!- (.!!/0((;((."" (.(/*)(/;0/.)) /.+)"0((;((.!! (.(/-((;/0."! (.0/*+((;(*.") (.//)!((;(!.+( (./+!+((;(*.( (./((-
((;(/." (.(0!((;(".( (./)(-((;(!.!* (./--((;((."" (.(/*)((;(/."/ (.(+/!((;((.*( (.(/((((;((.-+ (.(/00((;((.!* (.(/+((;(.*! (.(-!(((;/-.-* (.0"*(
((;(+.!! (.(*-((;/.!+ (.0-0(/;//.+! /./!"-((;(.- (.(-"(((;/!.(+ (.+(()((;(/.* (.(0+((;0+.)+ (.+"00((;(/.+ (.(00+((;(/.( (.(0++
Tiempo Entre'legadas
?minpersona@
Tiempo Entre'legadas?ersión Decimal@
minpersonas
-
8/17/2019 ExcellPf_Version3 (1).xlsx
44/154
((;0!.*/ (.-*!((;(.)- (.(-*0((;/!.-( (.+//-((;((.+! (.((*+((;+/.0" (.)0/)(/;+0.+" /.)+"!
((;0/.- (.+)-!((;(-./) (.//"0((;+. (.)-(((;/0.)! (.0("-((;((.+! (.((*+((;((.)" (.(("!((;//.*/ (./"+)((;((."/ (.(/)0((;).) (.-)-)(/;(*.)+ /./(!!
((;(+.+ (.()-0((;(/.)0 (.(0)+((;//.+ (./!"(((;(*.) (./(-)((;(".*" (./*/)((;(0.*0 (.(+-((;0(./* (.++*(((;(-.)0 (./0)+((;(+.() (.()(!((;((.) (.(("(((;/+.-) (.00"0(/;)-.!" /."*!((;0/.) (.+)"(((;0-.+0 (.))+((;(".)0 (./)!-((;(!.(+ (./++!((;/+."- (.0+0!((;((.! (.(/(((;+)."- (.)"")((;)*.*( (."++((;((.*" (.(//)
((;/(."- (./!0!((;.0) (.-+-)((;/"./) (.+/"0((;0.!/ (./+)((;(/.- (.(0"(((;/".( (.+/-+((;)./" (."(+0(/;+-.!0 /.*+(+
-
8/17/2019 ExcellPf_Version3 (1).xlsx
45/154
(/;(0.0+ /.(+-0((;(0.*" (.(!((;0.+" (.(*)((;/!.!/ (.+/+)(/;0.0) /.(0((;/!.*( (.+/((
((;(*.-! (.//+(((;(.(* (.(*--((;+(.!0 (.)/+-((;(-."" (./++0((;(-./0 (.//!-((;(-.( (.//-+((;((.0 (.(((((;0).+/ (.0/!((;+/.+( (.)0/-(/;)(.() /.!+0
((;//./- (./!*0((;(/.*! (.(0!((/;+*./* /.*(0-((;(.// (.(*!)((;(/.-0 (.(0!-((;+0.(0 (.)++-((;(-.*! (./0!(((;))./" (."/"!((;+. (.)-(((;0!./) (.*"0((;/!.+- (.+(*0((;()." (.(""(((;(.)) (.(-)!((;((.!* (.(/+((;(!.+* (./+"+((;(/.)+ (.(0))((;/!. (.+(-+((;+.** (.)---(0;/+.(" 0.0/!0((;(*.* (.//(-((;(0.- (.(/0((;/0."! (.0/*+((;(/.)* (.(0*(((;/-.*) (.0"0((;0/.)* (.+)"+((;(!.* (./(((;*.+ (.--+!((;(+.+( (.())(((;(".)" (./)"!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
46/154
((;(/.00 (.(0(+((;().(" (.(!!((;0)."0 (.+0(((;0/.)+ (.+)!!((;(+.)+ (.()!!((;()."/ (.("!)
((;(".)* (./)"+((;(0.+* (.(+"+((;(*.-) (.//0)((;(0.0- (.(+-!((;0+./- (.+!*0(0;+-.(0 0.*/-(((;((.-* (.(/0-((;/"."* (.++0-((;(-.*( (./0*-(/;)/.- /.!*0+
((;(/.(/ (.(/*!((;)*.)+ (."00((;+-.)" (.*0*)(/;!.-- /.!/0!((;((.-* (.(/0-((;(0.! (.(/+((;(!.+" (./+"!(+;/-.() +.0!0((;/*./+ (.0*!!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
47/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
48/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
49/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
50/154
((;(0.+! (.(+"-
((;(/.0( (.(0((((;(/." (.(0!((;(/.0- (.(0/0((;0+.!) (.+"-)((;/).0+ (.0)+!((;0/./ (.+)*!((;/*.-! (.0-"-((;+-.+* (.*00-((;(.(* (.(*--((;(0.!- (.(-!
((;(/.!+ (.(+()((;/0.+) (.0()!(/;0".!) /."-)((;(/.*- (.(0-!((;(.-* (.(-"+((;(0.0/ (.(+*!((;(/." (.(0!((;((.!- (.(/)((;(!." (./"(((;(+./ (.()*!
((;(0./0 (.(+)+((;(.** (.*---((;+*.+) (.*()!((;(/./ (.(0+)((;)).!* (."+/(((;(+.)/ (.()!)((;)*.!/ (."*!(/;//.*0 /./"+-(/;/*.)" /.0-*)((;+!.*/ (.*+)
((;/)."+ (.0*))((;0+.)* (.+"0-(0;+-.0* 0.*0/(((;0.-/ (.//!((;((.*! (.(//+((;/0." (.0(!0((;/*."+ (.0!00((;(*.0( (./(++((;0/."/ (.+*)0
Tiempo Entre'legadas
?minpersona@
Tiempo Entre'legadas?ersión Decimal@
minpersonas
-
8/17/2019 ExcellPf_Version3 (1).xlsx
51/154
((;+(.-/ (.)//!((;/*.-/ (.0-!)((;(/.!( (.(+((((;((.+" (.((*)((;)).(0 (."/-(((;/".) (.+00
((;().- (.(")-((;(/.(/ (.(/*!((;((.-) (.(/0)((;(/.0- (.(0/0((;(." (.(-!(/;0!."" /.!+0((;(/.+ (.(0+!((;/0.0! (.0(-((;(*."" (.//*)((;0!.0 (.-(-
(0;/!.-" 0.+/+0((;(/.*- (.(0-!(/;+).0! /.)!!(((;+0.)! (.)+((/;(+.)- /.()")((;(.*+ (.(--0((;(!.0" (./+!0((;".0! (.!0/+(/;)0.!! /.!!/+((;/0."0 (.0/)+((;(+./+ (.()00((;0!.(( (.**-((;).(+ (."(()((;(0.+ (.(()(/;().0 /.(!-+((;".(! (.!/!(((;+/./( (.)/!+((;(/."" (.(++0(/;.// /.-+)0((;(-.// (.//!)(;+.! .)!(-
((;(*.+" (./(*)((;0+."+ (.+"!!(/;/.)! /.0+(((;//.+) (./!"0((;+.(0 (.-/-((/;+".)+ /.*)!!((;/(.+ (./-0+((;+-.(- (.*/-!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
52/154
((;/.(0 (.0++-((;+".+- (.*)*0((;0".+! (.!"-((;(.-" (.(-"!((;(+."- (.(**0((;.) (.-0+
((;/!.(0 (.+((+(+;)0.*- +.!--!(/;+0.+/ /.)+!)(/;*.++ /.--00((;/(.- (./-"(((;+(.! (.)(!((/;((.+" /.((*)((;//.*0 (./"+-((;(.*+ (.(--0((;0.! (./(
((;).0) (.-)0((;(0.// (.(+)0((;(/./" (.(/"!((;(0.+ (.(+"(((;)*./( (."+)(((;((.+ (.((-0((;((.-" (.(/+0((;+/.+ (.)00+((;((.!+ (.(/+!((;(+.- (.()-!((;(0.-) (.()!((;+(./" (.)(+0((;(".-/ (./*/!((;)+.)! (.!"+((/;)(.)+ /.!00((;+).(* (.)!+((;0).( (.0++((;/)./" (.0)+0((;(+.!/ (.(*+)((;(*.+( (./()(((;+/.0/ (.)0(0((;(*.() (./((!((;/"./ (.+/"(((;)+.0) (.!!-)((;(*.*) (.//(!((;(-.") (./+0)((;().*0 (.("+-((;/.!/ (.0*!((;/+.!( (.0+((
-
8/17/2019 ExcellPf_Version3 (1).xlsx
53/154
((;(/.(- (.(/-!((;((.++ (.(())(0;(*.+) 0./()!(/;00.(- /.+*-!(0;(".-! 0./*+(((;(/.*" (.(0!0
((;(/.-/ (.(0!)((;(/./) (.(/"0((;((.+! (.((*+((;((.*! (.(//+((;((. (.((-+((;0-.(( (.)((((;(+.*) (.(*(!(/;0(.*( /.+++(/;+.+! /.-0+((/;0!./+ /.*!!
((;+.*+ (.-0-0((;(-.() (.//-)((;)-.)! (.")"-((;(-.*+ (./0-0((;//.* (./"/(((;/*.+) (.0-0)((;).*) (."/(!((;+).)) (.)"0)((;0!."* (.!0-(/;(".- /./)-!((;0/."- (.+**0((;("./! (./)+(((;/*.(/ (.0**!((;(./) (.(*"0((;/0.-* (.0/0-((;+".)0 (.*)!-((;(."- (.(!0!((;(.0 (.(-(-(/;0/.(* /.+)/(((;(.0 (.(-(-((;(+.( (.()(-((;(+./* (.()0-((;(-./0 (.//!-((;()./" (.(!*)((;0+.)( (.+"/-((;(0.!* (.(--(/;0+. /.+"(-((;+.!) (.)!(!((;/-.+ (.0!"(
-
8/17/2019 ExcellPf_Version3 (1).xlsx
54/154
(+;(."" +.(!+0(/;/"." /.++0+((;//.+! (./!"-(/;/-.-0 /.0")+((;)0.-( (.!-!+((;/(.0- (./-/0
(/;+.+ /.-0+!((;(".( (./)(-((;(0./- (.(+*0(/;+./) /.)*"0((;/*.!" (.0!/)((;/-.0" (.0!!0((;(.0* (.(-/((/;0+."* /.+""+((;)!.!+ (."!()((;(/.-! (.(0"-
(0;)!.)/ 0."-)0((;(0."+ (.(!!(/;/-.) /.0"(!((;(0. (.((-((;.)" (.-+0((;/!.+ (.+(-0((;(-.+- (./00!((;0!./* (.*"+((;((.") (.(/)!(/;)-.") /."*)!((;+0."! (.)"-((;(*.)) (./("0((;()./" (.(!*)((;0(.0) (.++-)((;)".+* (."!"+((;/+.-/ (.00!)((;(.0/ (.(-(0((;(.(" (.(*!0((;(.+( (.(-/-((;(+.// (.()/!(/;".( /.!0++
(/;)+.)- /.!"0!((;+).)- (.)"0!((;((.+- (.((*0((;/(.+! (./-+(((;/".0! (.+0/+(0;)0.-/ 0.!-!)((;0(.// (.++)0((;0*."+ (.!!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
55/154
((;/0."/ (.0/)0(/;/+."+ /.0+00(/;0/." /.+*)-((;0+.)/ (.+"/!(/;(-.(! /.//!((/;(-.-0 /./0!-
((;00./ (.+-+)();+(.*0 ).)/(+((;0!.0- (.-/0((;+.)/ (.-0)0(/;).-" /."/+0(/;+.++ /.-000((;/*.! (.0--(/;00.0( /.+-((((;().(" (.(!!((;/(.(+ (./*-0
((;(0.(+ (.(++!(0;0+.(( 0.+!++
-
8/17/2019 ExcellPf_Version3 (1).xlsx
56/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
57/154
((;(/./0 (.(/!-
(/;)+.)( /.!"/-((;(".-* (./*0-((;("./" (./)+0((;(-.+0 (./00(((;(*.*! (.///+((;(*.+( (./()((/;0.!0 /.-/+-(/;(./" /.**"!(;/(.-( ./-!+((;/(."( (./!/-
((;().0 (.("(+((;(+.+/ (.())0((;0/.-+ (.+*00((;((.*- (.(//0((;/).) (.0)-)(+;+./0 +.-/!-((;//.-* (./"*(((;/0.+) (.0()!((;/(.* (./--+((;/".+- (.+00!
((;//."/ (./"!)((;)!.0! (."-/+();(*."/ ).//)0(/;/+.!! /.0+/+((;((.*" (.(//)((;(*.-+ (.//00((;0*.* (./(();00.") ).+!0)
Tiempo Entre'legadas
?minpersona@ 5-7PM
Tiempo Entre'legadas?ersión
Decimal@minpersonas Vol#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
58/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
59/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
60/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
61/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
62/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
63/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
64/154
((;(-.-" (./0"! ((;(".//
((;(/.-) (.(0"0 ((;//.-)((;((./ (.((*! ((;((.0!((;((.)/ (.((!) ((;((.*/((;((."- (.(/*0 ((;("./)((;((.** (.(//( ((;((.!(((;((.)" (.(("! ((;(.(/((;((.*! (.(//+ (/;("."!((;((.)" (.(("! (0;+.0)((;((.! (.((!( ((;/+.!-((;(+.*! (.(*/+ ((;((.-!
((;((.* (.((-- ((;/+.()((;((.+ (.((-0 ((;+!."/((;((.+" (.((*) ((;(.//((;((.++ (.(()) (0;(*.-(((;((."/ (.(/)0 (/;//./(((;(+.( (.()*- ((;0!.--((;(./ (.(-+) ((;+".0(((;((." (.((!0 ((;(/.-(((;(.0 (.(-(- ((;0/.*!((;(+./! (.()+( ((;0.+)
((;(0."( (.(!+ ((;(/.!-((;/)." (.0)!0 ((;/+."((;(/.!0 (.(+(+ ((;((."+((;((." (.(/)- ((;(/.((((;/0.0* (.0(+ ((;(".!((;(/. (.(0( (/;(-./)((;(/./ (.(/"( ((;((.-/((;((.! (.((!( ((;/!.-((;((.+! (.((*+ (/;0.-0((;((.+! (.((*+ ((;((.))
((;((.++ (.(()) ((;0/."*((;((. (.((-+ (/;/*.((;((.** (.(//( ((;(/.)+((;((./ (.((*! ((;0(.-(((;((.-/ (.(//! ((;(."+((;/0.- (.0(-! ((;00.++((;((.+! (.((*+ ((;)(.//((;(/.00 (.(0(+ ((;(.)((;((.+/ (.(()0 (/;0*./+
Tiempo Entre'legadas
?minpersona@5-7
Tiempo Entre'legadas?ersión
Decimal@minpersonas
Tiempo Entre'legadas
?minpersona@ -9
-
8/17/2019 ExcellPf_Version3 (1).xlsx
65/154
((;((.0* (.((+ ((;0.-*((;((.0+ (.((+! ((;((.+!((;((.0+ (.((+! (/;/.+0((;((.0+ (.((+! ((;(/.**((;((.0 (.((( ((;(+.((;((.0) (.((0 ((;0/.-+
((;(.!+ (.(!() (0;)-.!(((;(+.*) (.(*(! ((;(+."+((;((.+0 (.(()+ (0;(+./(((;((.0" (.((! (/;0.+*((;0-.0 (.)( ((;("./*((;(/.0- (.(0/0 ((;(/.*"(/;0.*/ /./(0 ((;(!.0/((;((.)! (.(("- (/;0/.*)((;((.+0 (.(()+ ((;)*."((/;().)" /.("+0 ((;(+.)-
((;((." (.((!0 ((;((.*+((;(/.(" (.(/!0 ((;/*.)((;((.+" (.((*) ((;(0.!(/;(0./) /.(+)! ((;(/.)*((;(/.( (.(/-+ ((;(.+-((;((.)* (.(("+ (/;+0.0((;((.! (.((!( ((;((.)+((;((.-/ (.(//! (/;(.0"((;((.! (.((!( ((;((.*)((;((.* (.((-- ((;((.)-((;((.+* (.((*( ((;((.0(0;//.+* 0./!"+ ((;(-.+((;((.0! (.((- ((;((.+/((;((.+! (.((*+ ((;/(.-0((;((.+" (.((*) (/;*.!*((;((.) (.(("( ((;((.-(((;(!.// (./+)0 ((;((.*((;((. (.((-+ ((;((.0)((;((.! (.((!( (;+*.)/((;()./! (.(!*+ ((;((.*((;((.)( (.((!+ ((;((.+!
((;(!./( (./+)( ((;(-.(-((;(".+* (./)*( ((;((.!!((;/.)/ (.0/! ((;/.!((;(/.0) (.(0(! (/;)!."-((;0./ (.(*! (/;//.+!((;((.*" (.(//) (/;0-.**((;/(.*0 (./--( ((;*.0+((;((.!/ (.(/+) (;((.0-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
66/154
((;(".-* (./*0- (+;00.**((;((."- (.(/*0 ((;(*.0*((;((."* (.(/*( ((;-.-((;((. (.((-+ ((;+-.)*((;((.+! (.((*+ ((;((.+((;)0.*+ (.!--0 (/;0.!)
((;((.)" (.(("! ((;(0.+)((;().!- (.("-! ((;0*./((;((.+" (.((*) ((;/0.-+((;((.+! (.((*+ ((;!.-/(/;(-.0! /./0/+ ((;(/.))((;((.* (.(/(- ((;+*.!-((;(*.-( (.///-((;(+.*+ (.(*()((;().0 (.("(+((;().) (.("0+
((;((.- (.(/0+((;(0.!/ (.(*!((;(/.- (.(0"(((;((.+ (.((-0((;(/.0- (.(0/0((;(+.-+ (.(*00((;((. (.((-+((;0.!0 (.-/+-((;((.* (.((--((;((.) (.(("(((;((.+ (.((-0((;((.0 (.((-(((;(." (.(-!((;(/."+ (.(+00((;(+.- (.(*0+((;(+.! (.()!(((;((.) (.(("(((;+".) (.*)"(((;(/.)0 (.(0)+((;)-./+ (.")00((;(/.*/ (.(0*!((;((.!* (.(/+((;(*.(- (./(/0((;((.0 (.((((+;+*.+) +.*()!(+;0(.0* +.++--(/;(.++ /.*-00((;0".0( (.!*-((;((." (.((!0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
67/154
(/;+.!+ /.)!()((;((.! (.((!(((;((.+! (.((*+((;((.0 (.((-((/;(!.*! /./-((;((.+! (.((*+
((;((.+" (.((*)((;0).! (.0-((;((.)" (.(("!((;/.-) (.0)!((;(+.0" (.()!((;/*.*! (.0-!(((;((.*/ (.(/(0((;+.0 (.)-(-((;(0.* (.(((!;0).(+ !./-0
((;((.*+ (.(/()((;/.)* (.00-((;((.)* (.(("+((;(+.!* (.(*+((;/0.( (.0((-((;(.! (.(--((;0.** (.//(((;((.0 (.((-((0;0)./( 0./!+((;((.)+ (.((!!(/;0(." /.+/)((;((.* (.((--(0;()." 0.("/)((;((.** (.(//(((;(/.(+ (.(/-0((;((.)+ (.((!!(0;)(.-( 0.!)(((;+(.*( (.)/((((;((.* (.((--(0;)!."! 0."!+(((;((.+ (.((-0((;(*./0 (./(0(((;+(.)/ (.)(!)(/;0(."- /.+")((;((.*! (.(//+((;((.*/ (.(/(0((;((.*( (.(/((((;((.!+ (.(/+!((;(.0/ (.*-(0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
68/154
((;((.)* (.(("+(/;+(.+- /.)(*0((;((.)+ (.((!!((;((.*+ (.(/()((;(/./" (.(/"!((;((.! (.((!(
((;((.* (.(/(-((;/(.*+ (./--0((;((.** (.(//(((;)+.! (.!"/+((;((.*" (.(//)(+;)!.0- +."-/0((;((.)/ (.((!)((;((. (.((-+((;((.! (.((!((+;)).(- +."/-!
((;((.)/ (.((!)((;((.)* (.(("+(+;/-.) +.0"0+(+;/0.0) +.0(0((;((.)0 (.((!-((;((. (.((-+((;((.)/ (.((!)(/;/*."( /.0!/-((;((./ (.((*!((;((./ (.((*!((;((.! (.((!(((;((.+ (.((-0((;((. (.((-+((;((.)/ (.((!)((;((.) (.(("(((;((.*/ (.(/(0((;((.)! (.(("-((;((.*+ (.(/()((;((.*+ (.(/()((;((.)* (.(("+((;(+.0 (.()(
(/;*."! /.-!+(((;((.)! (.(("-((;((.)* (.(("+((;((.) (.((-)(/;/0.)- /.0(")((;((.! (.((!((!;/.0! !.0+!(((;(/.( (.(/-+
-
8/17/2019 ExcellPf_Version3 (1).xlsx
69/154
((;((."( (.(/)(((;((.!0 (.(/+-(/;/*./+ /.0*!!(/;00." /.+!0+((;((.)+ (.((!!((;((." (.((!0
((;00.-/ (.+-!)((;((.*/ (.(/(0(/;0."* /./*((0;0.)* 0.("+(0;)/.!- 0.!*)(/;/+."( /.0+/-((;((.)" (.(("!((;/+.(* (.0/--((;(/.+- (.(00!(/;/0.*) /.0/(!
((;((.)/ (.((!)((;((.)" (.(("!((;((.)" (.(("!((;+!./+ (.*+))((;((.)/ (.((!)((;((.)! (.(("-((;((.)! (.(("-((;(0.-+ (.())(/;0(.0+ /.++-0((;((.*" (.(//)((;(+.(- (.()/0((;((."" (.(/*)((;((."* (.(/*(((;/.)* (.00-((;(-.-+ (./0!!(/;(!.0( /./+*-((;((.)* (.(("+((;((.* (.(/(-((;(/.)" (.(0*)((;(0.!0 (.(-(((;(.-- (.(-")((;(.*+ (.(--0((;/!.- (.+/0+((;((.!) (.(/0((;)+.+- (.!!")((;(/.)- (.(0*0(0;(/./ 0.(0+)(/;0(.!( /.+*-((;(/.0 (.(0+-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
70/154
((;/).! (.0)!(((;((.!- (.(/)((;((."* (.(/*(((;((."/ (.(/)0((;)*.00 (."+-(((;((."" (.(/*)
((;(/.+/ (.(0/!((;(/.// (.(/!)((;(/.0 (.(0(-((;+-."! (.*++((0;/.0 0.*!-+((;(/.() (.(/-)((;((."0 (.(/)+((;(/.++ (.(000(0;(".*" 0./*/)(/;(0./ /.(+)-
((;(/.// (.(/!)(/;/./ /.0(0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
71/154
(./)/!
(./")!(.((-(.(/(0(./)0)(.(/++(.***!/./**+0.)-(!(.0+/0(.(/+(
(.0/-)(.*!)(.(*!)0.///-/./!)((.-")(.*)++(.(0!+(.+*/+(.-()!
(.(+/0(.00!(.(/))(.(/*-(./*(/.//"0(.(//!(.+/0+/.-/0((.(("0
(.+**(/.0-((.(0))(.+)((.(!00(.+-00(.!+)0(.(-)-/.+))
Tiempo Entre'legadas?ersión
Decimal@minpersonas
-
8/17/2019 ExcellPf_Version3 (1).xlsx
72/154
(./0-(.((*+/.0+!-(.(0--(.()-+(.+*00
0."*++(.(*))0.()/-/.(*((./)0-(.(0!0(./+*!/.+*(!(."!+(.()")
(.(/()(.0-)-(.(-+(.(0*((.(-0!/.)(+(.((!!/.*-/)(.(/(!(.((")(.((((./0+!(.(()0(./-!-/.-!/((.(//-(.((--(.((0.*(!)(.((--(.((*+
(.//-!(.(/-(.0/+/."!0!/./!"-/.*/((.--().(()
-
8/17/2019 ExcellPf_Version3 (1).xlsx
73/154
+.+---(./(+(.-")-(.*0*((.(()-/.-/0
(.(+"0(.(0(.0/00(.!//!(.(0)!(.*/)
-
8/17/2019 ExcellPf_Version3 (1).xlsx
74/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
75/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
76/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
77/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
78/154
Estación 4oe ArroBo
-
8/17/2019 ExcellPf_Version3 (1).xlsx
79/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
80/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
81/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
82/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
83/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
84/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
85/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
86/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
87/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
88/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
89/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
90/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
91/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
92/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
93/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
94/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
95/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
96/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
97/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
98/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
99/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
100/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
101/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
102/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
103/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
104/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
105/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
106/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
107/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
108/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
109/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
110/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
111/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
112/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
113/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
114/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
115/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
116/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
117/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
118/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
119/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
120/154
Placa %)" ";(* ";(- (;(/ (;(" >?0-) ";/+ ";/+ (;(( (;(-'%)*/ ";0( ";0/ (;(/ (;(-
D@((+ ";+) ";+* (;(/ (;/)>M))! "; "; (;(( (;(">M))- ";)/ ";)0 (;(/ (;(->%))- /(;(/ /(;(/ (;(( (;/(
Placa
-
8/17/2019 ExcellPf_Version3 (1).xlsx
121/154
DV)* ;0 ;0 (;(( (;/('%))- ;" ;" (;(( (;(-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
122/154
Primera Muestra
egunda Muestra
En decimal
!/+"+!/-!"
"--
/)"-
/(
ercera MuestraEn decimal 0) pm-)
/+!""
//--")
//-
/(!-"
V
-
8/17/2019 ExcellPf_Version3 (1).xlsx
123/154
/(-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
124/154
l#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
125/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
126/154
Matriz
i
:5
)
6
7
8
(
9
:*
:::5
:)
:6
:7
:
:8
:(
:9
5*
5:55
5)
56
57
5
58
5(
59
)*
):)5
))
)6
)7
)
)8
)(
)9
-
8/17/2019 ExcellPf_Version3 (1).xlsx
127/154
6*
6:
65
6)
66
67
668
6(
-
8/17/2019 ExcellPf_Version3 (1).xlsx
128/154
Parámetros encontrados
rigen y Destino: Porcentaje de personas que se bajan en parada i=1,2,3
Parada 2DePersonas
Calle 76 No. 43B - 05 (2Calle 76 con carrera 42B U. Metropolitana Occidente /2Calle 76 con carrera 39 C.C. Único Lado Occidente (2
(2Carrera 38 No. 76-06 (2Calle 79! No. 35C-43 Lado Occidente /(2Calle 79! con carrera 33 "ar#$e Lado Occidente (2Calle 79! con carrera 27 Lado Occidente (2Carrera 26C7 No. 75-77 Lado %$r !2
(2Carrera 27 con calle 72 Lado %$r (2Carrera 27 No. 68 - 49 Cole&io Ola'a Lado %$r (2Carrera 27 con calle 64 Me&a()* Lado %$r (2Carrera 27 con calle 6 "ar#$e Lo* !nde* (2Calle 6 No. 25-3 !2Carrera 24 No. 59-45 (2
(2/-2
Carrera 24 con calle 53 e*#. (2
+ia&onal 56 Me&a Cole&io Lado Norte (2(2Carrera 26 No. 47C-0 !-2Carrera 26 con calle 47C (2Calle 48 No. 23-29 (2Carrera 23 No. 52-32 (2Carrera 23 con calle 53+ e*#. !2Carrera 2B con calle 53+ ,*#. !2Carrera 2B No. 60-28 0)2Carrera 2B No. 64-26 ,. i(ne/ //2
Carrera 2B con calle 65B e*#. (2
Carrera 2B No. 68C-4 0)2Calle 70C con carrera 22+ ,*#. 0"2Calle 70C con carrera 22+ ,*#. (2Calle 70C No. 26B-44 /-2Carrera 27 No. 72-0 Lado Norte (2Calle 74B con carrera 26C7 Lado Noroccidente (2Carrera 26C7 No. 75B-68 Lado Norte (2Calle 79! con carrera 28 Lado Oriente (2
Est 4oe ArroBo
Calle 76 No. 38!-53 Col. Betania Lado Occidente
Calle 74B con carrera 26C7 Lado %$roriente
Carrera 24 con calle 54 %e&$ro de Lo* !nde*
Carrera 24 No. 53+-29
Carrera 24 No. 48-03
-
8/17/2019 ExcellPf_Version3 (1).xlsx
129/154
Calle 79! No. 34-22 Lado Oriente (2Calle 79! No. 35+-50 Lado Oriente (2Calle 76 con carrea 38! Lado Oriente (2
/(2Calle 76 con carrera 42 U. Metropolitana Oriente (2Calle 79 con carrera 42 C.,. Litoral (2
Calle 79 con carrera 45 (2Carrera 46 No. 76 - 09 Lado %$r (2
/((2
Calle 76 con carrera 39 C.C. Único Lado Oriente
,*t. oe !rro'o
-
8/17/2019 ExcellPf_Version3 (1).xlsx
130/154
!"#
Vol#er a $nicio
-
8/17/2019 ExcellPf_Version3 (1).xlsx
131/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
132/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
133/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
134/154
001" 00"00"0#! ((;(-.-"002" 00"00"01#5 ((;(/.-)003" 00"00"00#41 ((;((./004" 00"00"00#51 ((;((.)/005" 00"00"00#! ((;((."-
006" 00"00"00#66 ((;((.**00" 00"00"00#5! ((;((.)"008" 00"00"00#68 ((;((.*!00!" 00"00"00#5! ((;((.)"010" 00"00"00#48 ((;((.!011" 00"00"03#68 ((;(+.*!012" 00"00"00#46 ((;((.*013" 00"00"00#43 ((;((.+014" 00"00"00#3! ((;((.+"015" 00"00"00#33 ((;((.++
016" 00"00"00#!1 ((;((."/01" 00"00"03#40 ((;(+.(018" 00"00"04#41 ((;(./01!" 00"00"00#4! ((;((."020" 00"00"04#24 ((;(.0021" 00"00"03#18 ((;(+./!022" 00"00"02#!0 ((;(0."(023" 00"00"15#4! ((;/)."024" 00"00"01#82 ((;(/.!0025" 00"00"00#!4 ((;((."026" 00"00"12#26 ((;/0.0*02" 00"00"01#44 ((;(/.028" 00"00"01#14 ((;(/./02!" 00"00"00#48 ((;((.!030" 00"00"00#38 ((;((.+!031" 00"00"00#38 ((;((.+!032" 00"00"00#33 ((;((.++033" 00"00"00#44 ((;((.034" 00"00"00#66 ((;((.**035" 00"00"00#41 ((;((./036" 00"00"00#1 ((;((.-/03" 00"00"12#4 ((;/0.-038" 00"00"00#38 ((;((.+!03!" 00"00"01#22 ((;(/.00040" 00"00"00#31 ((;((.+/041" 00"00"00#26 ((;((.0*042" 00"00"00#23 ((;((.0+043" 00"00"00#23 ((;((.0+044" 00"00"00#23 ((;((.0+
-
8/17/2019 ExcellPf_Version3 (1).xlsx
135/154
045" 00"00"00#24 ((;((.0046" 00"00"00#25 ((;((.0)04" 00"00"04#83 ((;(.!+048" 00"00"03#65 ((;(+.*)04!" 00"00"00#32 ((;((.+0050" 00"00"00#2! ((;((.0"
051" 00"00"2#24 ((;0-.0052" 00"00"01#2 ((;(/.0-053" 00"01"24#61 (/;0.*/054" 00"00"00#58 ((;((.)!055" 00"00"00#32 ((;((.+0056" 00"01"05#5! (/;().)"05" 00"00"00#4! ((;((."058" 00"00"01#0! ((;(/.("05!" 00"00"00#3! ((;((.+"060" 00"01"02#15 (/;(0./)
061" 00"00"01#04 ((;(/.(062" 00"00"00#56 ((;((.)*063" 00"00"00#48 ((;((.!064" 00"00"00#1 ((;((.-/065" 00"00"00#48 ((;((.!066" 00"00"00#46 ((;((.*06" 00"00"00#36 ((;((.+*068" 00"02"11#36 (0;//.+*06!" 00"00"00#28 ((;((.0!00" 00"00"00#38 ((;((.+!01" 00"00"00#3! ((;((.+"02" 00"00"00#54 ((;((.)03" 00"00"08#11 ((;(!.//04" 00"00"00#44 ((;((.05" 00"00"00#48 ((;((.!06" 00"00"05#18 ((;()./!0" 00"00"00#50 ((;((.)(08" 00"00"08#10 ((;(!./(0!" 00"00"0!#36 ((;(".+*080" 00"00"14#51 ((;/.)/081" 00"00"01#25 ((;(/.0)082" 00"00"24#41 ((;0./083" 00"00"00#6! ((;((.*"084" 00"00"10#62 ((;/(.*0085" 00"00"00#81 ((;((.!/086" 00"00"0!#6 ((;(".-*08" 00"00"00#! ((;((."-088" 00"00"00#!6 ((;((."*08!" 00"00"00#44 ((;((.
-
8/17/2019 ExcellPf_Version3 (1).xlsx
136/154
0!0" 00"00"00#38 ((;((.+!0!1" 00"00"52#63 ((;)0.*+0!2" 00"00"00#5! ((;((.)"0!3" 00"00"05#8 ((;().!-0!4" 00"00"00#3! ((;((.+"0!5" 00"00"00#38 ((;((.+!
0!6" 00"01"0#28 (/;(-.0!0!" 00"00"00#64 ((;((.*0!8" 00"00"06#0 ((;(*.-(0!!" 00"00"03#63 ((;(+.*+100" 00"00"05#42 ((;().0101" 00"00"05#54 ((;().)102" 00"00"00#4 ((;((.-103" 00"00"02#81 ((;(0.!/104" 00"00"01#4 ((;(/.-105" 00"00"00#43 ((;((.+
106" 00"00"01#2 ((;(/.0-10" 00"00"03#3 ((;(+.-+108" 00"00"00#44 ((;((.10!" 00"00"42#82 ((;0.!0110" 00"00"00#46 ((;((.*111" 00"00"00#54 ((;((.)112" 00"00"00#43 ((;((.+113" 00"00"00#42 ((;((.0114" 00"00"04#4! ((;(."115" 00"00"01#!3 ((;(/."+116" 00"00"03#4 ((;(+.-11" 00"00"03#48 ((;(+.!118" 00"00"00#54 ((;((.)11!" 00"00"3!#54 ((;+".)120" 00"00"01#52 ((;(/.)0121" 00"00"5#13 ((;)-./+122" 00"00"01#61 ((;(/.*/123" 00"00"00#86 ((;((.!*124" 00"00"06#0 ((;(*.(-125" 00"00"00#24 ((;((.0126" 00"03"36#35 (+;+*.+)12" 00"03"20#26 (+;0(.0*128" 00"01"40#33 (/;(.++12!" 00"00"2!#20 ((;0".0(130" 00"00"00#4! ((;((."131" 00"01"34#83 (/;+.!+132" 00"00"00#48 ((;((.!133" 00"00"00#38 ((;((.+!134" 00"00"00#42 ((;((.0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
137/154
135" 00"01"08#68 (/;(!.*!136" 00"00"00#38 ((;((.+!13" 00"00"00#3! ((;((.+"138" 00"00"25#48 ((;0).!13!" 00"00"00#5! ((;((.)"140" 00"00"14#5 ((;/.-)
141" 00"00"03#2! ((;(+.0"142" 00"00"16#68 ((;/*.*!143" 00"00"00#61 ((;((.*/144" 00"00"34#24 ((;+.0145" 00"00"02#64 ((;(0.*146" 00"08"25#03 (!;0).(+14" 00"00"00#63 ((;((.*+148" 00"00"14#56 ((;/.)*14!" 00"00"00#56 ((;((.)*150" 00"00"03#86 ((;(+.!*
151" 00"00"12#04 ((;/0.(152" 00"00"04#48 ((;(.!153" 00"00"24#66 ((;0.**154" 00"00"00#42 ((;((.0155" 00"02"25#10 (0;0)./(156" 00"00"00#53 ((;((.)+15" 00"01"20#4! (/;0(."158" 00"00"00#46 ((;((.*15!" 00"02"05#4! (0;()."160" 00"00"00#66 ((;((.**161" 00"00"01#03 ((;(/.(+162" 00"00"00#53 ((;((.)+163" 00"02"50#0 (0;)(.-(164" 00"00"30#60 ((;+(.*(165" 00"00"00#46 ((;((.*166" 00"02"58#!8 (0;)!."!16" 00"00"00#43 ((;((.+168" 00"00"06#12 ((;(*./016!" 00"00"30#51 ((;+(.)/10" 00"01"20#! (/;0(."-11" 00"00"00#68 ((;((.*!12" 00"00"00#61 ((;((.*/13" 00"00"00#60 ((;((.*(14" 00"00"00#83 ((;((.!+15" 00"00"40#21 ((;(.0/16" 00"00"00#56 ((;((.)*1" 00"01"30#3 (/;+(.+-18" 00"00"00#53 ((;((.)+1!" 00"00"00#63 ((;((.*+
-
8/17/2019 ExcellPf_Version3 (1).xlsx
138/154
180" 00"00"01#1! ((;(/./"181" 00"00"00#48 ((;((.!182" 00"00"00#64 ((;((.*183" 00"00"10#63 ((;/(.*+184" 00"00"00#66 ((;((.**185" 00"00"53#48 ((;)+.!
186" 00"00"00#6! ((;((.*"18" 00"03"58#2 (+;)!.0-188" 00"00"00#51 ((;((.)/18!" 00"00"00#44 ((;((.1!0" 00"00"00#48 ((;((.!1!1" 00"03"55#0 (+;)).(-1!2" 00"00"00#51 ((;((.)/1!3" 00"00"00#56 ((;((.)*1!4" 00"03"1#54 (+;/-.)1!5" 00"03"12#25 (+;/0.0)
1!6" 00"00"00#52 ((;((.)01!" 00"00"00#44 ((;((.1!8" 00"00"00#51 ((;((.)/1!!" 00"01"16#!0 (/;/*."(200" 00"00"00#41 ((;((./201" 00"00"00#41 ((;((./202" 00"00"00#48 ((;((.!203" 00"00"00#43 ((;((.+204" 00"00"00#44 ((;((.205" 00"00"00#51 ((;((.)/206" 00"00"00#54 ((;((.)20" 00"00"00#61 ((;((.*/208" 00"00"00#58 ((;((.)!20!" 00"00"00#63 ((;((.*+210" 00"00"00#63 ((;((.*+211" 00"00"00#56 ((;((.)*212" 00"00"03#24 ((;(+.0213" 00"01"46#!8 (/;*."!214" 00"00"00#58 ((;((.)!215" 00"00"00#56 ((;((.)*216" 00"00"00#45 ((;((.)21" 00"01"12#5 (/;/0.)-218" 00"00"00#48 ((;((.!21!" 00"08"14#28 (!;/.0!220" 00"00"01#04 ((;(/.(221" 00"00"00#!0 ((;((."(222" 00"00"00#82 ((;((.!0223" 00"01"16#13 (/;/*./+224" 00"01"22#!4 (/;00."
-
8/17/2019 ExcellPf_Version3 (1).xlsx
139/154
225" 00"00"00#53 ((;((.)+226" 00"00"00#4! ((;((."22" 00"00"22#1 ((;00.-/228" 00"00"00#61 ((;((.*/22!" 00"01"24#!6 (/;0."*230" 00"02"24#56 (0;0.)*
231" 00"02"51#8 (0;)/.!-232" 00"01"13#!0 (/;/+."(233" 00"00"00#5! ((;((.)"234" 00"00"13#06 ((;/+.(*235" 00"00"01#3 ((;(/.+-236" 00"01"12#65 (/;/0.*)23" 00"00"00#51 ((;((.)/238" 00"00"00#5! ((;((.)"23!" 00"00"00#5! ((;((.)"240" 00"00"38#13 ((;+!./+
241" 00"00"00#51 ((;((.)/242" 00"00"00#58 ((;((.)!243" 00"00"00#58 ((;((.)!244" 00"00"02#3 ((;(0.-+245" 00"01"20#23 (/;0(.0+246" 00"00"00#6! ((;((.*"24" 00"00"03#0 ((;(+.(-248" 00"00"00#!! ((;((.""24!" 00"00"00#!6 ((;((."*250" 00"00"14#56 ((;/.)*251" 00"00"0#3 ((;(-.-+252" 00"01"08#20 (/;(!.0(253" 00"00"00#56 ((;((.)*254" 00"00"00#64 ((;((.*255" 00"00"01#5! ((;(/.)"256" 00"00"02#82 ((;(0.!025" 00"00"04# ((;(.--258" 00"00"04#63 ((;(.*+25!" 00"00"18#4 ((;/!.-260" 00"00"00#85 ((;((.!)261" 00"00"53#3 ((;)+.+-262" 00"00"01#5 ((;(/.)-263" 00"02"01#41 (0;(/./264" 00"01"20#80 (/;0(.!(265" 00"00"01#42 ((;(/.0266" 00"00"15#48 ((;/).!26" 00"00"00#8 ((;((.!-268" 00"00"00#!6 ((;((."*26!" 00"00"00#!1 ((;((."/
-
8/17/2019 ExcellPf_Version3 (1).xlsx
140/154
20" 00"00"56#22 ((;)*.0021" 00"00"00#!! ((;((.""22" 00"00"01#31 ((;(/.+/23" 00"00"01#11 ((;(/.//24" 00"00"01#24 ((;(/.025" 00"00"3#!8 ((;+-."!
26" 00"02"41#24 (0;/.02" 00"00"01#05 ((;(/.()28" 00"00"00#!2 ((;((."02!" 00"00"01#33 ((;(/.++280" 00"02"0!#6! (0;(".*"281" 00"01"02#14 (/;(0./282" 00"00"01#11 ((;(/.//283" 00"01"14#41 (/;/./
-
8/17/2019 ExcellPf_Version3 (1).xlsx
141/154
(;)*.)!(/;/(.!(/;(+.+-(0;(.+0(/;(/.+
(/;(+."-((;)-.+*(/;0(.++(+;(+.+((;)".-0(/;+-.)0(/;(".(+;//.*0((;)-.(!((;+-.+0
(/;/(.)-(/;)/.+-((;0.+/((;)).("((;/*.!(/;//./((;+-.(!(/;0).!(+;(+.)(((;".!*(/;0(.++((;0.*)(0;)".*0(+;/*.0((0;)+.(((;)*.00(/;0(.++((;+!.+)(/;().("(/;+-."((0;+).-+
(/;0+.(+(/;/.!"((;)".)((/;(+.*((;!.-(/;*./0((;).*0(0;0.!
01 04"56#58 04"56#58
02 06"0#42 01"10#84
03 0"10#! 01"03#3
04 0!"51#11 02"40#32
05 10"52#54 01"01#43
06 11"56#51 01"03#! 0 12"53#8 00"5#36
08 14"14#20 01"20#33
0! 1"1#63 03"03#43
10 18"1#35 00"5!#2
11 1!"54#8 01"3#52
12 21"04#31 01"0!#44
13 24"15#!3 03"11#62
14 25"13#01 00"5#08
15 25"50#33 00"3#32
16 2"00#!0 01"10#5 1 28"52#2 01"51#3
18 2!"34#58 00"42#31
1! 30"2!#6 00"55#0!
20 30"46#51 00"16#84
21 31"5#65 01"11#14
22 32"34#3 00"3#08
23 34"00#5 01"25#84
24 3"04#0 03"03#50
25 3"53#!3 00"4!#86
26 3!"14#26 01"20#33
2 3!"38#!1 00"24#65
28 42"38#53 02"5!#62
2! 45"54#3 03"16#20
30 48"48#13 02"53#40
31 4!"44#35 00"56#22
32 51"04#68 01"20#33
33 51"43#03 00"38#35
34 52"48#12 01"05#0!
35 54"26#02 01"3#!0
36 5"01#5 02"35#3
3 58"24#8 01"23#03
38 5!"3!#6 01"14#8!
3! 01"00"3!#1 00"00"5!#50
40 01"01"42#63 00"01"03#46
41 01"02"31#3 00"00"48#4
42 01"04"1#4! 00"01"46#12
43 01"05"12#11 00"00"54#62
44 01"0"54#5! 00"02"42#48
-
8/17/2019 ExcellPf_Version3 (1).xlsx
142/154
(+;+-.0*(;(*.)0(/;00./0(+;(*.("
45 01"11"31#85 00"03"3#26
46 01"15"38#3 00"04"06#52
4 01"1"00#4! 00"01"22#12
48 01"20"06#58 00"03"06#0!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
143/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
144/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
145/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
146/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
147/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
148/154
01$ 00"00"14#552 % 00"00"14#552 ((;/.))02$ 00"00"01#06! % 00"00"15#621 ((;(/.(*03$ 00"00"0!#10! % 00"00"24#30 ((;("./(04$ 00"00"03#06 % 00"00"28#436 ((;(+.-(05$ 00"01"40#6! % 00"02"0!#115 (/;(.*-
06$ 00"00"06#!85 % 00"02"16#100 ((;(*."!0$ 00"01"0!#40! % 00"03"25#50! (/;(".(08$ 00"00"06#164 % 00"03"31#63 ((;(*./*0!$ 00"01"4#!!0 % 00"05"1!#663 (/;-.""10$ 00"00"2!#824 % 00"05"4!#48 ((;0".!011$ 00"00"32#!!6 % 00"06"22#483 ((;+0.""12$ 00"03"54#343 % 00"10"16#826 (+;).+13$ 00"00"00#22 % 00"10"1#548 ((;((.-014$ 00"00"01#!34 % 00"10"1!#482 ((;(/."+15$ 00"00"01#105 % 00"10"20#58 ((;(/./(
16$ 00"00"02#086 % 00"10"22#63 ((;(0.(!1$ 00"00"03#51! % 00"10"26#1!2 ((;(+.)/18$ 00"00"01#128 % 00"10"2#320 ((;(/./01!$ 00"00"02#65! % 00"10"2!#!! ((;(0.*)20$ 00"00"22#4 % 00"10"52#26 ((;00.-21$ 00"00"0#06! % 00"10"5!#!5 ((;(-.(*22$ 00"00"5#!31 % 00"11"5#26 ((;)-."+23$ 00"00"05#81 % 00"12"03#50 ((;().-!24$ 00"00"01#556 % 00"12"05#063 ((;(/.))25$ 00"00"13#856 % 00"12"18#!1! ((;/+.!)26$ 00"00"14#100 % 00"12"33#01! ((;/./(2$ 00"00"32#63 % 00"13"05#82 ((;+0.-*28$ 00"00"02#388 % 00"13"08#10 ((;(0.+!2!$ 00"00"02#404 % 00"13"10#54 ((;(0.(30$ 00"00"00#2 % 00"13"11#346 ((;((.--31$ 00"00"00#6!6 % 00"13"12#042 ((;((.*"32$ 00"00"05#6!0 % 00"13"1#32 ((;().*"33$ 00"00"05#84 % 00"13"23#606 ((;().!-34$ 00"00"00#36 % 00"13"23#!3 ((;((.+*35$ 00"00"00#630 % 00"13"24#603 ((;((.*+36$ 00"00"00#262 % 00"13"24#865 ((;((.0*3$ 00"00"58#65 % 00"14"23#522 ((;)!.*)38$ 00"00"01#228 % 00"14"24#50 ((;(/.003!$ 00"00"3#13 % 00"15"01#88 ((;+-./+40$ 00"00"53#20 % 00"15"55#60 ((;)+.-041$ 00"00"00#88 % 00"15"56#3!5 ((;((.-!42$ 00"00"00#821 % 00"15"5#216 ((;((.!043$ 00"00"0#153 % 00"16"04#36! ((;(-./)44$ 00"00"03#48 % 00"16"0#84 ((;(+.-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
149/154
45$ 00"00"01#!81 % 00"16"0!#828 ((;(/."!46$ 00"00"33#865 % 00"16"43#6!3 ((;++.!*4$ 00"03"22#010 % 00"20"05#03 (+;00.(/48$ 00"00"01#8!3 % 00"20"0#5!6 ((;(/.!"4!$ 00"00"04#652 % 00"20"12#248 ((;(.*)50$ 00"00"03#15 % 00"20"15#405 ((;(+./)
51$ 00"00"01#42 % 00"20"16#832 ((;(/.052$ 00"00"02#26 % 00"20"1!#558 ((;(0.-053$ 00"00"00#811 % 00"20"20#36! ((;((.!/54$ 00"00"11#!13 % 00"20"32#282 ((;//."/55$ 00"01"31#5! % 00"22"03#861 (/;+/.)-56$ 00"00"16#061 % 00"22"1!#!22 ((;/*.(*5$ 00"00"23#238 % 00"22"43#160 ((;0+.0+58$ 00"01"1#642 % 00"24"00#802 (/;/-.*5!$ 00"00"02#808 % 00"24"03#610 ((;(0.!(60$ 00"00"05#123 % 00"24"08#33 ((;()./0
61$ 00"00"0!#08 % 00"24"1#811 ((;(".(-62$ 00"00"3#1! % 00"24"55#530 ((;+-.-/63$ 00"00"00#655 % 00"24"56#185 ((;((.*)64$ 00"00"00#652 % 00"24"56#83 ((;((.*)65$ 00"01"36#!22 % 00"26"33#5! (/;+*."066$ 00"00"06#!44 % 00"26"40#03 ((;(*."6$ 00"00"10#308 % 00"26"51#011 ((;/(.+(68$ 00"00"05#13 % 00"26"56#148 ((;()./+6!$ 00"00"03#4!1 % 00"26"5!#63! ((;(+."0$ 00"00"00#!!4 % 00"2"00#633 ((;((.""1$ 00"00"01#465 % 00"2"02#0!8 ((;(/.*2$ 00"00"02#156 % 00"2"04#254 ((;(0./)3$ 00"00"14#48 % 00"2"18#32 ((;/.-4$ 00"00"0#233 % 00"2"25#!65 ((;(-.0+5$ 00"00"00#56 % 00"2"26#21 ((;((.-)6$ 00"00"20#40! % 00"2"4#130 ((;0(.($ 00"00"0!#406 % 00"2"56#536 ((;(".(8$ 00"00"01#406 % 00"2"5#!42 ((;(/.(!$ 00"00"01#68 % 00"2"5!#62! ((;(/.*!80$ 00"00"01#406 % 00"28"01#035 ((;(/.(81$ 00"00"01#048 % 00"28"02#083 ((;(/.(82$ 00"00"04#5!2 % 00"28"06#65 ((;(.)"83$ 00"00"02#16 % 00"28"08#851 ((;(0./-84$ 00"00"00#83! % 00"28"0!#6!0 ((;((.!+85$ 00"00"06#1!1 % 00"28"15#881 ((;(*./"86$ 00"00"00#8 % 00"28"16#65! ((;((.--8$ 00"00"00#633 % 00"28"1#2!2 ((;((.*+88$ 00"00"02#0!0 % 00"28"1!#382 ((;(0.("8!$ 00"00"05#321 % 00"28"24#03 ((;().+0
-
8/17/2019 ExcellPf_Version3 (1).xlsx
150/154
!0$ 00"00"00#50 % 00"28"25#210 ((;((.)(!1$ 00"00"41#82 % 00"2!"06#!!2 ((;/.-!!2$ 00"00"08#114 % 00"2!"15#106 ((;(!.//!3$ 00"01"11#610 % 00"30"26#16 (/;//.*/!4$ 00"03"3!#325 % 00"34"06#041 (+;+".+0!5$ 00"00"06#256 % 00"34"12#2! ((;(*.0)
!6$ 00"00"00#5 % 00"34"12#84 ((;((.)-!$ 00"01"30#02! % 00"35"42#!03 (/;+(.(0!8$ 00"01"06#463 % 00"36"4!#366 (/;(*.*!!$ 00"00"05#134 % 00"36"54#500 ((;()./+100$ 00"00"0!#111 % 00"3"03#611 ((;(".//101$ 00"00"11#5 % 00"3"15#368 ((;//.-)102$ 00"00"00#288 % 00"3"15#656 ((;((.0!103$ 00"00"00#61! % 00"3"16#25 ((;((.*/104$ 00"00"0!#152 % 00"3"25#42 ((;("./)105$ 00"00"00#806 % 00"3"26#233 ((;((.!(
106$ 00"00"40#016 % 00"38"06#24! ((;(.(/10$ 00"01"0!#!86 % 00"3!"16#235 (/;("."!108$ 00"02"34#25 % 00"41"50#4!2 (0;+.0)10!$ 00"00"13#81 % 00"42"04#363 ((;/+.!-110$ 00"00"00#83 % 00"42"05#146 ((;((.-!111$ 00"00"13#056 % 00"42"18#202 ((;/+.()112$ 00"00"38#!13 % 00"42"5#115 ((;+!."/113$ 00"00"04#113 % 00"43"01#228 ((;(.//114$ 00"02"06#02 % 00"45"0#!30 (0;(*.-(115$ 00"01"11#106 % 00"46"1!#036 (/;//./(116$ 00"00"28#5 % 00"46"4#811 ((;0!.--11$ 00"00"3!#204 % 00"4"2#015 ((;+".0(118$ 00"00"01#01 % 00"4"28#16 ((;(/.-(11!$ 00"00"21#686 % 00"4"50#402 ((;0/.*!120$ 00"00"42#358 % 00"48"32#60 ((;0.+)121$ 00"00"01#83 % 00"48"34#633 ((;(/.!-122$ 00"00"13#4!1 % 00"48"48#124 ((;/+."123$ 00"00"00#!38 % 00"48"4!#062 ((;((."+124$ 00"00"01#003 % 00"48"50#065 ((;(/.((125$ 00"00"0!#848 % 00"48"5!#!13 ((;(".!126$ 00"01"0#153 % 00"50"0#066 (/;(-./)12$ 00"00"00#14 % 00"50"0#80 ((;((.-/128$ 00"00"18#44 % 00"50"26#524 ((;/!.-12!$ 00"01"42#26 % 00"52"0!#250 (/;0.-0130$ 00"00"00#556 % 00"52"0!#806 ((;((.))131$ 00"00"21#!6 % 00"52"31#3 ((;0/."*132$ 00"01"16#440 % 00"53"48#213 (/;/*.133$ 00"00"01#533 % 00"53"4!#46 ((;(/.)+134$ 00"00"20#06 % 00"54"10#452 ((;0(.-(
-
8/17/2019 ExcellPf_Version3 (1).xlsx
151/154
135$ 00"00"04#!32 % 00"54"15#384 ((;(."+136$ 00"00"22#335 % 00"54"3#1! ((;00.++13$ 00"00"50#110 % 00"55"2#82! ((;)(.//138$ 00"00"04#54! % 00"55"32#38 ((;(.)13!$ 00"01"26#13 % 00"56"58#515 (/;0*./+140$ 00"00"24#68 % 00"5"23#283 ((;0.-*
141$ 00"00"00#380 % 00"5"23#663 ((;((.+!142$ 00"01"14#325 % 00"58"3#!88 (/;/.+0143$ 00"00"01#663 % 00"58"3!#651 ((;(/.**144$ 00"00"03#44 % 00"58"43#0!8 ((;(+.145$ 00"00"21#3 % 00"5!"04#835 ((;0/.-+146$ 00"02"5#802 % 01"02"02#63 (0;)-.!(14$ 00"00"03#!34 % 01"02"06#51 ((;(+."+148$ 00"02"03#105 % 01"04"0!#66 (0;(+./(14!$ 00"01"24#364 % 01"05"34#040 (/;0.+*150$ 00"00"0!#161 % 01"05"43#201 ((;("./*
151$ 00"00"01#6!6 % 01"05"44#8! ((;(/.*"152$ 00"00"08#21 % 01"05"53#114 ((;(!.0/153$ 00"01"21#650 % 01"0"14#64 (/;0/.*)154$ 00"00"56#!0! % 01"08"11#63 ((;)*."(155$ 00"00"03#50 % 01"08"15#243 ((;(+.)-156$ 00"00"00#634 % 01"08"15#8 ((;((.*+15$ 00"00"16#545 % 01"08"32#422 ((;/*.)158$ 00"00"02#84! % 01"08"35#21 ((;(0.!15!$ 00"00"01#560 % 01"08"36#831 ((;(/.)*160$ 00"00"04#35 % 01"08"41#206 ((;(.+-161$ 00"01"32#424 % 01"10"13#630 (/;+0.0162$ 00"00"00#532 % 01"10"14#162 ((;((.)+163$ 00"01"40#2!6 % 01"11"54#458 (/;(.0"164$ 00"00"00#65! % 01"11"55#11 ((;((.*)165$ 00"00"00#5 % 01"11"55#6!4 ((;((.)-166$ 00"00"00#246 % 01"11"55#!40 ((;((.016$ 00"00"0#430 % 01"12"03#30 ((;(-.+168$ 00"00"00#311 % 01"12"03#681 ((;((.+/16!$ 00"00"10#24 % 01"12"14#405 ((;/(.-010$ 00"01"46#86 % 01"14"01#22 (/;*.!*11$ 00"00"00#05 % 01"14"01#! ((;((.-(12$ 00"00"00#46 % 01"14"02#444 ((;((.*13$ 00"00"00#251 % 01"14"02#6!5 ((;((.0)14$ 00"04"36#513 % 01"18"3!#208 (;+*.)/15$ 00"00"00#460 % 01"18"3!#668 ((;((.*16$ 00"00"00#380 % 01"18"40#048 ((;((.+!1$ 00"00"0#00 % 01"18"4#118 ((;(-.(-18$ 00"00"00#882 % 01"18"48#000 ((;((.!!1!$ 00"00"14#484 % 01"1!"02#484 ((;/.!
-
8/17/2019 ExcellPf_Version3 (1).xlsx
152/154
180$ 00"01"58#!1 % 01"21"01#455 (/;)!."-181$ 00"01"11#381 % 01"22"12#836 (/;//.+!182$ 00"01"2#66 % 01"23"40#503 (/;0-.**183$ 00"00"46#23! % 01"24"26#42 ((;*.0+184$ 00"04"00#28 % 01"28"2#020 (;((.0-185$ 00"03"22#661 % 01"31"4!#681 (+;00.**
186$ 00"00"06#264 % 01"31"55#!45 ((;(*.0*18$ 00"00"4#41 % 01"32"43#686 ((;-.-188$ 00"00"3#56 % 01"33"21#253 ((;+-.)*18!$ 00"00"00#348 % 01"33"21#601 ((;((.+1!0$ 00"01"42#850 % 01"35"04#451 (/;0.!)1!1$ 00"00"02#35! % 01"35"06#810 ((;(0.+)1!2$ 00"00"26#415 % 01"35"33#225 ((;0*./1!3$ 00"00"12#34 % 01"35"45#!5! ((;/0.-+1!4$ 00"00"48#1! % 01"36"34#68 ((;!.-/1!5$ 00"00"01#550 % 01"36"36#228 ((;(/.))
1!6$ 00"00"36#82 % 01"3"13#100 ((;+*.!-
-
8/17/2019 ExcellPf_Version3 (1).xlsx
153/154
-
8/17/2019 ExcellPf_Version3 (1).xlsx
154/154