81
 PRIMER NOMBRE PRIMER APELLIDO CÉDULA FACULTAD CARRERA NIVEL DOCENTE

Johana Excel 2

Embed Size (px)

DESCRIPTION

2

Citation preview

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 1/81

PRIMER NOMBRE

PRIMER APELLIDO

CÉDULA

FACULTADCARRERA

NIVEL

DOCENTE

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 2/81

 Johanna

Ontaneda

2300199656

CIENCIAS DE LA INGENIERIA

ING AMBIENTAL

1

MIRIAM LEÓN

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 3/81

TEMA: Funciones de búsqueda !e"e!enciaRE#ERVACI$N DE TIC%ET# AÉREO#IAJAEC!ADOR e" #na e$%&e"a de "e&'()(o" ded()ada a *a &e"e&'a)(+n de t(),et" a-&eo" de"deEn *a "(#(ente ta*a "e de")&(e *a Ae&o*nea d("%on(*e de a)#e&do a *a )(#dad de de"t(no *a

&ORA DE #ALIDADE#TINO '(&'' ')&'' **&'' *+&'' *,&''

Cuenca  Ta$e LAN Ta$e LAN-uaaqui. Ae&oa* Ta$e LAN LANMan/a LAN Ta$e Ta$eLo0a  Ta$e LANE. Coca Ae&oa* LAN Ae&oa*La1o A1!io Ae&oa* Ta$e Ta$e Ae&oa*#an/a E.ena  Ta$e Ae&oa* Ae&oa* Ae&oa*

En *a "(#(ente ta*a "e (nd()an *a" ta&(/a" de *o" t(),et" a-&eo" de a)#e&do a* t(%o de )a(na4

CABINA

DE#TINO Econ23ica

Cuenca 91453 11343 170425-uaaqui. 88425 93413 17041Man/a 90425 98460 138425Lo0a 96475 123417 152413E. Coca 85412 96417 126412La1o A1!io 8416 947 12415#an/a E.ena 92450 102436 175425

P!ob.e3a:E")oe& de *a" *("ta" de"%*ea*e" e* DESTINO :ORA DE SALIDA CABINA ; <OMA DE =AGO>

DE#TINO Manta&ORA DE #ALIDA 09:00AEROL4NEA  Ta$e a5 a5 Des6.e1a! .a ae!o.7nea diCABINA E)on+$()aTARIFA POR PA#A;ERO   90425 b5 b5 Des6.e1a! .a /a!i"a 6o! 6a> DE ADULTO# 7> DE NI?O# 1FORMA DE PA-O Che?#eTARIFA TOTAL   33467 c5 c5 Ca.cu.a! .a /a!i"a /o/a. de

Los nios 6a1an .a 3i/a #i e. 6a1o se 8ace en e" #i no 8a =ue.o .a ce.da

P!e3iu3

Econo3

P!e3iu3

Business

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 4/81

.#(to ha)(a d(/e&ente" )(#dade" de* E)#ado&  ho&a de "a*(da de"de e* Ae&o%#e&o de .#(to4

*(&''

 Ta$e

LAN

 Ta$e

  6onib.e de acue!do a. des/ino 8o!a de sa.ida9 Indica! si no eis/e !u/a en ese 8o!a!i

sa0e!o< /o3ando en cuen/a e. /i6o de cabina9 #i no 8a =ue.o .a ce.da debe queda! =a

  a!i"a< conside!ando .a c.ase de 6asa0e!os @adu./os o nios5 .a "o!3a de 6a1o9de .a /a!i"a de. /ice/9

c/i=o o c8eque !eciben e. de descuen/o9ebe queda! =ac7a9

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 5/81

9

  7a9

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 6/81

Te3a: Funciones de búsqueda !e"e!encia

RE#ERVA DE TIC%ET# CINEC2di1o Cine Cine Di!ecci2nC@03 C(neMa&, A'4 Na)(one" !n(da" A$-&()a

C2di1o Pe.7cu.a Pe.7cu.a Fo!3a/o!S@2D@578 I&on Man 3 ID

Va.o! Uni/a!io Can/idad Tice/s #ub/o/a.3 5 15

C2di1o Cines Di!ecci2nC@01 M#*t()(ne" CCI A'4 A$aona" A'4 NN!!

C@02 M#*t()(ne" E* Condado Condado Sho%%(nC@03 C(neMa&, A'4 Na)(one" !n(da" A$-&()aC@07 S#%e&C(ne" A'4 6 de D()(e$&e =o&t#a*C@05 C(ne=*e ent#&a Ma** T#$a)o

C2di1o Pe.7cu.a Pe.7cu.as de es/!eno Ti6o Pe.7cu.aEC@2D@012 Mono )on Ga**(na" A))(+n!S@2D@236 E* ata?#e A))(+n!S@3D@235 Lo" =(t#/o" 2 In/ant(*!S@2D@875 Ch()a" A&$ada" =e*(&o"a" A))(+n!S@2D@369 Son )o$o n(o" 2 Co$ed(a!S@3D@38 M( '(**ano /a'o&(to 2 In/ant(*!S@2D@127 R%(do" <#&(o"o" 6 A))(+n!S@2D@578 I&on Man 3 A))(+n!S@2D@82 :an"e* G&ete* Te&&o&!S@2D@02 .#(ene" "on *o" M(**e&" Co$ed(a!S@3D@756 A'(one" In/ant(*!S@3D@076 Mon"te& !n('e&"(t In/ant(*!S@3D@1 S#%e&Man A))(+n

a En *a )e*da B*' e")oe& e* )+d(o de* C(ne4 En *a )e*da C*' $o"t&a& e* no3b!e en *a D*' *a Di!ecci2n  e En *a )e*da B*+ e")oe& e* )+d(o de *a =e*)#*a4 En *a )e*da C*+ $o"t&a& e* no$&e de *a %e*)#*a4) En *a )e*da D*+ e")oe& e* /o&$ato de *a %e*)#*a4 En *a )e*da E*+ $o"t&a&> E. /i6o de 6e.7cu.a< .a c.asicd En *a )e*da -*+ e")oe& e* da en *a &*+ *a ho&a4 !t(*(a& *("ta" de"%*ea*e" ?#e to$en *o" dato" de *a" ta

e En *a )e*da B*G )a*)#*a& e* 'a*o& #n(ta&(o a %aa& to$ando en )#enta *o" =a.o!es de. "o!3a/o e. d7a se.En *a )e*da C*G e")oe& *a )ant(dad de T(),et" en *a" )e*da" D*G< E*G F*G en)ont&a& *o" 'a*o&e" )o&&e"%on

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 7/81

Te.H"ono275896

Desc!i6ci2n D7a &o!aA))(+n@Cen"#&a 12 ao"@Inde%en M(-&)o*e" 7>00>00 =M

I=a To/a.148 1648

Te.H"ono2356698 Cod Fo!3a/o Va.o!

326598 2D No&$a* 2D 5400275896 3D 3D 4003265552 NC Na)(ona* 7400256987 ID Inde%end(ente 3450

D7a P!o3oci2n De/a..eC.asicaci2n L#ne" No&$a* a*o& no&$a*

 Todo %F*()o Ma&te" M(tad de =&e)(o 50 de* %&e)(oCen"#&a 12 ao" M(-&)o*e" E"%e)(a* Toda ho&a 3 C#a*?#(e& /o&$ato Todo %F*()o J#e'e" M(tad de =&e)(o 2 %e&"ona" %o& e* %&e)(o de #naCen"#&a 18 ao" (e&ne" No&$a* a*o& no&$a*Cen"#&a 15 ao" Sado No&$a* a*o& no&$a* Todo %F*()o Do$(no No&$a* a*o& no&$a*Cen"#&a 15 ao"Cen"#&a 12 ao" &o!aCen"#&a 15 ao" 10>00Cen"#&a 12 ao" 12>00 Todo %F*()o 17>00 Todo %F*()o 16>00Cen"#&a 12 ao" 18>00

20>00

  *a -*' e* /e.H"ono de* C(ne e")o(do en *a )e*da B*'

ci2n e. no3b!e de. "o!3a/o esco1ido*a" )o&&e"%ond(ente"

ccionado4d(ente"

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 8/81

Te3a: Funciones de búsqueda !e"e!encia

a Mo"t&a& e* no$&e de* H#ado& ?#e t(ene e* 'a*o& de t&a"%a"o $" aHo Mo"t&a& e* no$&e de* %a" ?#e a)#$#*e $ao& nF$e&o de De*ante&o"

L.ene .a 6!i3e!a Fi.a de .a Tab.a ;u1ado!es< en .a co.u3na ;u1ado! 6on1a su NoNota> =#ede aad(& )o*#$na" ad()(ona*e" %a&a otene& *o" &e"#*tado" "o*()(tado"

TABLA ;U-ADORE#

Equi6o Ac/ua. ;u1ado! Posici2n de 0ue1o

 J!G@1120 Rea* Mad&(d Johanna Ontaneda Med(o

 J!G@1121 De%o&t('o *a Co&#a Roe&t(ho Med(o

 J!G@1122 <C Ba&)e*ona L(one* Me""( De*ante&o

 J!G@1123 Rea* Mad&(d Gona*o :(#an De*ante&o

 J!G@1127 Rea* Mad&(d O(* Med(o

 J!G@1125 <C Ba&)e*ona Rona*d(ho Med(o

 J!G@1126 a*en)(a So*dado Med(o

 J!G@112 Rea* Mad&(d RaF* Gon*e De*ante&o J!G@1128 De%o&t('o *a Co&#a <e&nnde Med(o

 J!G@1129 At*-t()o Mad&(d Rada$e* <a*)ao De*ante&o

 J!G@1130 <C Ba&)e*ona Dan A*'e" De/en"a

 J!G@1131 Che*"ea Da'(d L#( De/en"a

 J!G@1132 =a&(" St4 Ge&$a(n I&ah($o'()h De*ante&o

 J!G@1133 At*-t()o Mad&(d Da'(d (**a De*ante&o

 J!G@1137 Inte& M(*an L*o&ente Med(o

 J!G@1135 <C Ba&)e*ona Ne$a& J&4 De*ante&o

 J!G@1136 Rea* Mad&(d Ga&eth Ba*e De*ante&o

 J!G@113 J#'ent#" Ca&*o" T-'e De*ante&o J!G@1138 Bo)a J#n(o& Ro$n R(?#e*$e Med(o

 J!G@1139 Co&(nt(an" :e&nn Ba&)o" De*ante&o

 J!G@1170 Man)he"te& !ntd4 Anton(o a*en)(a Late&a*

 J!G@1171 Man)he"te& C(t Joe :a&t A&?#e&o

 J!G@1172 M*aa Ro?#e Santa C&# De*ante&o

 J!G@1173 =S Ed("on M-nde Med(o

 J!G@1177 Che*"ea <&an, La$%a&d Med(o

 J!G@1175 L('e&%oo* L#(" S#&e De*ante&o

 J!G@1176 Rea* Mad&(d I,e& Ca"(**a" A&?#e&o

 J!G@117 Ga*ata"a&a D(d(e& D&oa De*ante&o J!G@1178 A$-&()a M-()o C&("t(an Bente De*ante&o

 J!G@1179 M+na)o Ed("on Ca'ann( De*ante&o

 J!G@1150 Rea* Mad&(d Ane* D( Ma&a De*ante&o

 J!G@1151 Bae& M#n()h C*a#d(o =(a&&o De*ante&o

 J!G@1152 J#'ent#" Mata" <e&nnde Med(o

 J!G@1153 <(o&ent(na Da'(d =(a&&o Med(o

 J!G@1157 Santo" La#na :#$e&to S#ao De*ante&o

 J!G@1155 !d(ne"e Ga& Mede* De/en"a

Con *a (n/o&$a)(+n de *a /ab.a de ;u1ado!es otene& *a (n/o&$a)(+n "(#(ente>

C2di1o ;u1ado!

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 9/81

 J!G@1156 Inte& M(*an <&ed G#a&n De/en"a

 J!G@115 M+na)o Ja$e" Rod&#e Med(o

 J!G@1158 C&# A#* L#(" A$a&anto =e&ea De/en"a

 J!G@1159 L('e&%oo* Ste'en Ge&a&d Med(o

 J!G@1160 Che*"ea <e&nando To&&e" De*ante&o

 J!G@1161 Inte& M(*an Eto+ De*ante&o

 J!G@1162 Bae& M#n()h A&Hen Roen Med(o J!G@1163 Mo&e*(a Jee&"on Monte&o De*ante&o

 J!G@1167 Bae& M#n()h <&an, R(e&( De*ante&o

 J!G@1165 Bae& M#n()h Ba"t(an S)he(n"te(e& Med(o

 J!G@1166 Bo&#"(a Do&$#nth Roe&t Leando",( De*ante&o

 J!G@116 Bo)a J#n(o& <e&nando Gao Med(o

 J!G@1168 Man)he"te& C(t Se&(o AKe&o De*ante&o

 J!G@1169 Rea* Mad&(d Sa$( hed(&a Med(o

 J!G@110 A&"ena* Ce)" <a&ea" Med(o

 J!G@111 Rea* Mad&(d Roe&to Ca&*o" De/en"a

 J!G@112 Che*"ea =ete& Ce)h A&?#e&o J!G@113 At*-t()o Mad&(d D(eo <o&*n De*ante&o

 J!G@117 Bae& M#n()h Ma&(o G+$e De*ante&o

 J!G@115 a")o Da Ga$a Ca&*o" Teno&(o De*ante&o

 J!G@116 =o&to <C Ja),"on Ma&tne De*ante&o

 J!G@11 Man)he"te& C(t Da'(d S(*'a Med(o

 J!G@118 Che*"ea Jhon Te&& De/en"a

 J!G@119 AHa BoHan &,() Med(o

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 10/81

 Johanna Ontaneda E&&>507A&ent(na

b!e a6e..ido

Pa7s O!i1en Aui.ia! * Aui.ia!

1 E)#ado&

15 B&a"(*

100A&ent(na A&ent(na 618 A&ent(na A&ent(na 675 A*e$an(a

35 B&a"(*

20 E"%aa

20 E"%aa E"%aa 310 E"%aa

25 Co*o$(a Co*o$(a 215 B&a"(*

35 B&a"(*

28 S#e)(a S#e)(a 19 E"%aa E"%aa 3

15 E"%aa

35 B&a"(* B&a"(* 128 A*e$an(a A*e$an(a 3

20 A&ent(na A&ent(na 6 A&ent(na

A&ent(na A&ent(na 627 E)#ado&

15 In*ate&&a

12 =a&a#a =a&a#a 110 E)#ado&

15 In*ate&&a

26 !&##a !&##a 311 E"%aa

16 Co"ta de Ma&* Co"ta de M 110 E)#ado& E)#ado& 335 !&##a !&##a 317 A&ent(na A&ent(na 6 =e&F =e&F 16 Ch(*e

20 Ch(*e

7 Ch(*e Ch(*e 15 Ch(*e

Va.o! T!as6aso @U#D3i..ones5

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 11/81

21 Co*o$(a

20 Co*o$(a

12 Co*o$(a

18 In*ate&&a

25 E"%aa E"%aa 38 Ca$e&Fn Ca$e&Fn 1

35 :o*anda6 E)#ado& E)#ado& 3

70 <&an)(a <&an)(a 112 A*e$an(a

28 A*e$an(a A*e$an(a 35 A&ent(na

30 A&ent(na A&ent(na 635 A*e$an(a

25 E"%aa

28 B&a"(*

30 Re%F*()a Che)a20 !&##a !&##a 330 A*e$an(a A*e$an(a 310 E)#ado& E)#ado& 315 Co*o$(a Co*o$(a 219 E"%aa

23 In*ate&&a

11 E"%aa

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 12/81

Te3a: Fo!3a/os condiciona.es

TRAN#PORTE

NOMBRE EMPRE#A PROVINCIA DE#TINO AÉREO TERRE#TREAM N MELISSA BA;ER =IC:INC:A NO SIANG!LO MIRE;A =<IER G!A;AS SI SIARCOS ELA LI<E MANABP NO SIA;ALA ;ESENIA GR!NENTAL MANABP SI SIBENALCQAR LER BA;ER G!A;AS SI SICADENA SA L .!IM=AC =IC:INC:A SI NOCAIA EDISON LI<E IMBAB!RA SI NOCANDO MA4 LO!RDES GR!NENTAL T!NG!RA:!A NO SICOBO REGINA BA;ER IMBAB!RA NO NOCOLOMA MA4 JOS =<IER IMBAB!RA SI SICÓRDOA QNGEL LI<E COTO=AI SI SICORTS ALERIA .!I<ATE T!NG!RA:!A NO SI

GALARA CECILIA BA;ER =IC:INC:A NO NOG ME DANIELA =<IER IMBAB!RA SI SI JARAMILLO JANNIS LI<E G!A;AS SI SI JARAMILLO ;ADIRA =<IER MANABP SI SILASTRA ALEJANDRA BA;ER =IC:INC:A SI SILESCANO L!C A =<IER =IC:INC:A NO NOMACAS MARPA SOL LI<E COTO=AI SI NOMERA GRACE GR!NENTAL COTO=AI SI SIMOLINA MA4 JOS BA;ER =IC:INC:A SI SIMOS.!ERA <ERNANDO ACROMA =IC:INC:A SI NONORO A ADRIANA LI<E =IC:INC:A SI SI=AC:ECO REN NOARTIS IMBAB!RA NO SI

=EA DIEGO BA;ER T!NG!RA:!A SI SI=RE GRACE =<IER MANABP SI SIRIOS JENN;<ER LI<E IMBAB!RA NO SIR!ALES SILANA GR!NENTAL COTO=AI NO NOSALGADO <RANCISCO BA;ER G!A;AS SI SISILA SANTIAGO =<IER =IC:INC:A SI NO TERQN MONSERRAT LI<E G!A;AS SI SI TERQN =ABLO GR!NENTAL MANABP SI SIACA ADRIANA BA;ER MANABP NO SIARELA ER NICA =<IER G!A;AS SI SI SCONE LOL;TA LI<E =IC:INC:A SI NOAMBRANO LEIDIANA NOARTIS MANABP SI SIAMBRANO MARCELO BA;ER =IC:INC:A SI NO

A=ATA JOS L!IS =<IER IMBAB!RA NO SI

  4 4 4

A *a" *a" de dato" de *a ta*a (n/e&(o& a%*()a& /o&$ato" "eFn *a" "(#(ente" )ond()(one"4 #e debe esc!iba5 Co*o& de &e**eno na&anHa %a&a *o" '("(tado&e" $-d()o" ?#e no %e&tene)en a *a" e$%&e"a" L(/e o Bae& ?b5 Co*o& de &e**eno )e*e"te %a&a *o" '("(tado&e" $-d()o" de *a" E$%&e"a" G&#nenta* o =e& ?#e no t(enenc5 Co*o& de &e**eno 'e&de %a&a *o" '("(tado&e" $-d()o" de *a E$%&e"a G&#nenta* ?#e t(enen )o$o de"t(no *

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 13/81

4

i! .as condiciones de .os "o!3a/ose t(enen )o$o de"t(no *a =&o'(n)(a de =()h(n)ha o I$a#&a4)o$o de"t(no *a =&o'(n)(a de Mana "e t&an"%o&tan %o& 'a a-&ea te&&e"t&e4" =&o'(n)(a de T#n#&ah#a o I$a#&a no "e t&an"%o&tan %o& 'a te&&e"t&e4

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 14/81

Te3a: Fo!3a/o Condiciona.A%*()a& /o&$ato )ond()(ona* de a)#e&do a *a" "(#(ente" &e*a">a Co*o& de /ondo a$a&(**o a *a" <ILAS de* I$%o&tado& USna),U de"de Uene#e*aU en e* ao 2012 Co*o& de /ondo )e*e"te a *a" <ILAS de *o" =&od#)to" ?#e haan "(do ($%o&tado" de"de UCo*o$(aU o de

Desc!i6ci2n de. P!oduc/o Ti6o I36o!/ado! Pa7s O!i1en111 Ga**eta" Co$e"t(*e Sna), SA E"%aa112 Ja+n de $ano" A"eo Reon E"%aa

113 Dete&ente L($%(ea L($%(on Ltda4 A&ent(na117 Manana 'e&de <&#ta" Sna), SA ene#e*a115 De"(n/e)tante L($%(ea Sna), SA E"%aa116 <(deo" Co$e"t(*e Reon E"%aa11 A&&o Co$e"t(*e L($%(on Ltda4 Co*o$(a118 AtFn Co$e"t(*e Sna), SA E"%aa119 Maone"a Co$e"t(*e Sna), SA A&ent(na120 !'a" <&#ta" Sna), SA E"%aa

121 =a%e* h((-n()o A"eo Reon E"%aa122 (no t(nto L()o&e" L()o&e" e)#ato&(ano ene#e*a123 Ma Co$e"t(*e Sna), SA A&ent(na127 A)e(te de o*('a Co$e"t(*e Reon A&ent(na125 aH(**a 27 % a&(o" D("t&(#(do&a AV= !SA

126 <#nda" de a"#&a a&(o" D("t&(#(do&a AV= A&ent(na12 Sa&d(na" Co$e"t(*e Sna), SA A&ent(na128 Dete&ente L($%(ea Reon E"%aa

129 Ja n de &o%a L($%(ea L($%(on Ltda4 A&ent(na130 Sha$%oo A"eo Sna), SA ene#e*a131 Se&'(**eta" a&(o" D("t&(#(do&a AV= E"%aa132 Ca&ne de &e" Co$e"t(*e Reon Co*o$(a133 Ge*at(na Co$e"t(*e L($%(on Ltda4 Co*o$(a

137 .#e"o Co$e"t(*e Sna), SA !SA135 Re'("ta" a&(o" D("t&(#(do&a AV= Co*o$(a136 Mo&tade*a Et&a Co$e"t(*e Don J#&(" Co*o$(a13 <&#t(**a" <&#ta" La <(n)a E"%aa138 Mante?#(**a Co$e"t(*e La)teo" SA E"%aa139 ;o#&t Co$e"t(*e La)teo" SA ene#e*a170 Na)ho" Co$e"t(*e Sna), SA ene#e*a171 J#o de* %&a$o L()o&e" L()o&e" e)#ato&(ano E"%aa

172 Moa&e**a ?#e"o Co$e"t(*e La)teo" SA Co*o$(a173 =a%a" Co$e"t(*e L($%(on Ltda4 E"%aa177 Sa*"a de To$ate Co$e"t(*e Reon Co*o$(a175 (no *an)o L()o&e" L()o&e" e)#ato&(ano E"%aa176 C&e$a de a/e(ta& A"eo D("t&(#(do&a AV= E"%aa

17 C#)ha&a" %*"t()a" a&(o" D("t&(#(do&a AV= M-()o178 Man Co$e"t(*e Sna), SA A&ent(na179 AF)a& Co$e"t(*e Inen(o San a*d-" E"%aa

150 C*o&o L($%(ea D("t&(#(do&a AV= Co*o$(a151 =an no Co$e"t(*e Sna), SA ene#e*a152 Re/&e")o G#a&an <ant"t()a Co$e"t(*e Sna), SA E"%aa153 N#e)e" <&#ta" Sna), SA A&ent(na157 O"(to" de o$a G#$W& Co$e"t(*e Sna), SA !SA

155 Cho)o*ate S)ho( Co$e"t(*e Sna), SA Co*o$(a156 Co* /e&$entada RX""*e Co$e"t(*e Sna), SA !SA

15 Ja n de %*ato" L($%(ea L($%(on Ltda4 Co*o$(a

) Co*o& de /ondo 'e&de a *a" <ILAS de *o" %&od#)to" ?#e haan "(do ($%o&tado" ent&e /e&e&o H#n(o de*

C2di1oP!oduc/o

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 15/81

158 A&en?#e *an)o de* no&oe"te Co$e"t(*e Sna), SA E"%aa159.#e"o o&ono*a Te*(no Co$e"t(*e La)teo" SA A&ent(na160 !'a" 'e&de" "(n "e$(**a <&#ta" Sna), SA E"%aa161 .#e"o /&e")o Co$e"t(*e Sna), SA ene#e*a162 <&e"a" <&#ta" Sna), SA E"%aa163 A$(enta* de a#to L($%(ea L($%(on Ltda4 M-()o

167 E")ae)he de a&en?#e Co$e"t(*e Sna), SA ene#e*a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 16/81

2012  UA&ent(naU ?#e no tenan IA

2Y1Y2011

P!ecio uni/a!io IVA Unidades #/oc Va.o! To/a. A!  0438 No 1YY2013 G&a$o" 150 5400 2013  1458 S( 2Y26Y2012 )$3 87 178465 2012  2489 S( 10Y25Y2011G&a$o" 53 11455 2011  146 No 7Y10Y2012G&a$o" 91 160416 2012  7483 S( 7Y19Y2013 )$3 86 765423 2013  0415 No 2Y5Y2013 G&a$o" 95 17425 2013  0493 No 6Y10Y2013 G&a$o" 139 12942 2013  7405 No 6Y5Y2011 G&a$o" 2 1121485 2011  2479 No 11Y29Y2011 )$3 292 2408 2011  7405 No 11Y18Y2011 G&a$o" 163 660415 2011  9427 S( 6Y16Y2011 #n(dad 179 ZZZ 2011  0493 S( 2Y3Y2012 )$3 6 6949 2012  7405 No 3Y29Y2011 G&a$o" 291 118455 2011  2479 No 3Y13Y2012 )$3 21 6749 2012  25498 S( 12Y18Y2011 #n(dad 92 266498 2011  340 S( Y9Y2012#n(dad 265 911418 2012  7405 No 12YY2012 G&a$o" 297 119040 2012  5461 S( 9YY2011 )$3 27 1551495 2011  2479 S( 10Y17Y2012 G&a$o" 261 2488 2012  141 S( 5Y21Y2011 )$3 268 51342 2011  7483 S( 6YY2011 #n(dad 213 ZZZ 2011  141 No 6Y2Y2012 G&a$o" 55 97405 2012  141 No 1Y30Y2013 )$3 180 30480 2013

  141 No 3Y17Y2011 G&a$o" 155 265405 2011  342 S( 3Y1Y2011#n(dad 19 21479 2011  2495 S( 2YY2012G&a$o" 50 165420 2012  347 No 5Y30Y2012 G&a$o" 78 19452 2012  2429 No 10Y10Y2012 G&a$o" 62 171498 2012  7403 No 7Y9Y2011 )$3 76 185438 2011  3456 S( 5Y27Y2011 G&a$o" 103 710468 2011  2403 S( Y28Y2012 )$3 175 32946 2012  6425 S( 9Y30Y2011G&a$o" 6 532400 2011  0493 No 3Y21Y2011 G&a$o" 21 19453 2011  7405 No 1YY2012 )$3 27 110940 2012  5461 S( 10Y8Y2011 )$3 205 1288406 2011  6432 S( 11Y30Y2012 #n(dad 33 233459 2012

  0499 S( 10Y30Y2011 #n(dad 150 166432 2011  04 No 7Y3Y2011 G&a$o" 67 79428 2011  1408 No 12Y17Y2011 G&a$o" 258 28467 2011  1458 S( 3Y28Y2011 )$3 131 231482 2011  1488 No Y12Y2012 G&a$o" 180 33450 2012  2450 S( 2Y6Y2012 )$3 13 787470 2012  7438 No 12Y9Y2011 G&a$o" 21 979438 2011  7438 S( 1Y3Y2013 G&a$o" 212 1038480 2013  1425 S( 1Y8Y2012 )$3 276 377470 2012  1425 No 2Y3Y2012 G&a$o" 167 205400 2012  3413 S( 12Y22Y2011 G&a$o" 200 00400 2011

2011 ?#e no "ean Co$e"t(*e" o <&#ta"

Fec8a dei36o!/aci2n

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 17/81

  1425 No 10Y2Y2012 G&a$o" 19 22345 2012  1488 S( 9Y25Y2012G&a$o" 163 372430 2012  2450 No 11Y19Y2012 G&a$o" 122 305400 2012  2450 S( 11Y23Y2011 G&a$o" 21 60460 2011  2450 No Y23Y2012 G&a$o" 236 590400 2012  3475 S( 5Y2Y2012 )$3 196 5437 2012  7438 No 10Y20Y2012 G&a$o" 127 572450 2012

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 18/81

6Y30Y2011

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 19/81

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 20/81

TEMA: Fi./!os a=anJadosLa ta*a (n/e&(o& $#e"t&a dato" %e&"ona*e" "o&e e"t#d(ante" de d(/e&ente" E")#e*a"D("ea& *t&o" a'anado" %a&a "e*e))(ona& *a" *a" de dato" ?#e )#$%*an *a" "(#(ente" )ond()(onDeHa& e%&e"ado e* *t&o en *a" *a" en *an)o

a5 Es/udian/es de 1Hne!o Fe3enino de .a escue.a de A!qui/ec/u!a que /en1an en/!e ,

APELLIDO NOMBRE E#CUELA FEC&A IN-RE#O VALOR MATR4CULA

A&?#(te)t#&a

b5 Es/udian/es de 1Hne!o Mascu.ino de .as escue.as de A!qui/ec/u!a o Pub.icidad< que

E#CUELA VALOR MATR4CULA

A&?#(te)t#&a [31Y12Y1987 \1000 [1500=#*()(dad

c5 Es/udian/es de .a Escue.a de Meca/!2nica que es/udien + o 3s aosK .a .a "ec8a d

E#CUELAA! A!

Me)at&+n()a \3 \2005 [2010

d5 Es/udian/es que sean 8o3b!es o 3u0e!es de .a Escue.a de Econo37a que 6a1uen 3

APELLIDO NOMBRE E#CUELA FEC&A IN-RE#O VALOR MATR4CULA

E)ono$a \112250

e5 Es/udian/es en/!e , +' aos< que in1!esa!on des6uHs de. ao '' a .a escue.a d

APELLIDO NOMBRE E#CUELA FEC&A IN-RE#O VALOR MATR4CULA

E)ono$a \112250

"5 Es/udian/es 3u0e!es de .a escue.a de Meca/!2nica que in1!esa!on en e. ao '' co

15 Es/udian/es de .a escue.a de Pub.icidad o A!qui/ec/u!a que in1!esa!on e. 6!i3e! d7a

FEC&A DENACIMIENTO

VALORMATR4CULA

TIEMPOE#TUDIO#

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 21/81

APELLIDO NOMBRE E#CUELA FEC&A IN-RE#O VALOR MATR4CULA

#&(ta A*eHand&a A&?#(te)t#&a 5Y22Y2009 1768400And&e" <&an)e" =#*()(dad 8Y20Y200 1171400Ba)h Sh(&*e Me)at&+n()a 6Y13Y2010 21400

Da'(d"on =a#* E)ono$a 5Y17Y2009 119400E"t&e**a Cathe&(ne A&?#(te)t#&a 3Y31Y2009 1190400<a*)+n Cha&*e" =#*()(dad 1Y5Y200 1150400<o&d :#nte& Me)at&+n()a 12Y22Y200 1198400G#e'a&a :-)to& E)ono$a 9Y26Y2009 1108400A#(&&e Tat(ana E)ono$a 6Y2Y2010 1352400Gandet De(e Me)at&+n()a 12Y23Y2009 1083400Ga&)a M(#e* =#*()(dad 9Y13Y2008 1711400Enda&a C&("t(na A&?#(te)t#&a 12Y23Y2010 1232400:a*'o&"on Mon()a =#*()(dad 2Y18Y200 1757400

Gonaa Ga&(e* A&?#(te)t#&a 5Y31Y2008 97400 Ja)," &(" =#*()(dad 1Y13Y2009 880400ahn Bo E)ono$a 1Y21Y2010 117400:(noHo"a M(#e* Me)at&+n()a 3Y29Y2008 1031400La,e L("a Me)at&+n()a 2Y10Y2008 90400Bena'(de" A*eand&a E)ono$a 6Y17Y2011 1765400M(**e& a)ha& =#*()(dad 11YY2009 111400('a" Ed("on A&?#(te)t#&a 5Y5Y200 29400Nea* Ste'e A&?#(te)t#&a 8Y3Y2010 1290400Ae&'e Ma&a =#*()(dad 11Y30Y2009 1297400=a** D(), A&?#(te)t#&a Y28Y200 899400a*d('(eo J#*(a E)ono$a 7Y25Y2010 1299400

Monte&o e&+n()a Me)at&+n()a 11Y30Y2008 1396400(**ea" Ad&(ana =#*()(dad 8Y6Y2010 973400:a&o <e&nando A&?#(te)t#&a 10Y1Y2009 1725400]h(te Conn(e E)ono$a Y28Y2009 837400Ronn(e a&*a Me)at&+n()a 12Y15Y2008 859400

 Tan?#(no =ed&o =#*()(dad 8Y5Y2008 6400e*a"te#( <&edd =#*()(dad 10Y28Y2010 27400Ca"a&e" Nohe$ A&?#(te)t#&a 8Y31Y2009 1392400=#ente Dan(e*a A&?#(te)t#&a 9Y7Y2010 103400a**ada&e" <&edd =#*()(dad 12Y15Y2009 952400Ro$e&o Ana A&?#(te)t#&a 2Y17Y2010 1181400Mo&eno =a*o E)ono$a 8Y19Y200 82400Ca"t(**o J#an Me)at&+n()a 8Y20Y2010 1081400O&t( =a$e*a A&?#(te)t#&a 6Y16Y200 1188400B#)he*( M+n()a =#*()(dad 7Y21Y2011 106400G#ano)hana Ma&a&(ta A&?#(te)t#&a 6Y28Y2009 1269400Go&d+n Ma&)e*o =#*()(dad 7Y5Y2009 1329400"?#e =ao*a Me)at&+n()a 2YY2011 122400Be*t&n C*a#d(a E)ono$a 5Y31Y2008 907400So*a&( R()ha&d E)ono$a 11Y27Y2010 965400e*a Pta*o A&?#(te)t#&a Y22Y2010 170400Ch(*#(a Eda& A&?#(te)t#&a 10Y2Y2009 98400Ma&tne Ma&a =#*()(dad 3Y27Y2009 138400e*a")o Toa E)ono$a 11Y16Y2009 1271400:e&nnde =a*o Me)at&+n()a 6Y22Y2010 1089400

Ch'e G("e**e =#*()(dad 7Y30Y2011 1275400Id&o'o Ro)o =#*()(dad 8Y29Y2008 1288400Lede"$a Roe&to E)ono$a 3Y3Y2010 1289400

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 22/81

Sa*aa& M(#e* Me)at&+n()a 1Y18Y200 93400Soto$ao& Ga*o Me)at&+n()a 11Y8Y2010 860400

 ;#nan Beat&( Me)at&+n()a 7Y20Y2010 1058400G&(Ha*'a Nan) A&?#(te)t#&a 7Y6Y200 1400

 Ta(%e Geo'ann A&?#(te)t#&a 11Y19Y2008 1123400=a&ede" E*o =#*()(dad Y31Y2010 1737400Bo&Ha Do&(" E)ono$a 7Y12Y200 1355400NHe&a Ma&a Me)at&+n()a Y30Y2011 800400

1122450

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 23/81

e">

+, aosK su a6!o=ec8a3ien/o acadH3ico sea 3ao! a. 6!o3edio9

FEC&A DE NACIMIENTO EDAD EDAD -ÉNERO

\25 [35 <e$en(no

  nacie!on an/es de. ao *) un 3a/!7cu.a en/!e *9''' *,''9

in1!eso es/H en/!e e. ao '', '*'9

  /!7cu.as 3ao!es a. 6!o3edio9

FEC&A DE NACIMIENTO -ÉNERO -ÉNERO

Ma")#*(no <e$en(no

e Pub.icidad9

FEC&A DE NACIMIENTO -ÉNERO -ÉNERO

Ma")#*(no <e$en(no

un a6!o=ec8a3ien/o acadH3ico su6e!io! a G9

  de. 3es9

TIEMPO

E#TUDIO#

TIEMPOE#TUDIO#

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 24/81

FEC&A DE NACIMIENTO EDAD -ÉNERO

5Y16Y1981 37 <e$en(no 73Y9Y1986 29 <e$en(no 6

2Y19Y1985 30 <e$en(no 3

8Y30Y198 3 Ma")#*(no 711Y16Y1986 29 <e$en(no 73Y2Y1980 35 Ma")#*(no 610Y3Y1986 29 Ma")#*(no 67Y10Y1982 33 Ma")#*(no 71Y7Y198 38 <e$en(no 35Y1Y1986 29 <e$en(no 7

9Y1Y199 36 Ma")#*(no 59Y16Y1983 32 <e$en(no 38Y1Y1985 30 <e$en(no 6

6Y28Y199 36 Ma")#*(no 52Y17Y199 36 Ma")#*(no 77Y5Y1983 32 Ma")#*(no 3

5Y10Y1983 32 Ma")#*(no 55Y23Y1987 31 <e$en(no 58Y25Y198 3 <e$en(no 21Y31Y1980 36 Ma")#*(no 711YY1980 35 Ma")#*(no 61Y31Y199 3 Ma")#*(no 38Y13Y199 36 <e$en(no 75Y27Y1987 31 Ma")#*(no 612Y5Y1981 37 <e$en(no 3

Y9Y1985 30 <e$en(no 55Y8Y1983 32 <e$en(no 3Y17Y1980 35 Ma")#*(no 78Y25Y1982 33 <e$en(no 79Y1Y1983 32 <e$en(no 5Y6Y1980 35 Ma")#*(no 5

11Y17Y1986 29 Ma")#*(no 3Y15Y1986 29 <e$en(no 7

10Y16Y1983 32 <e$en(no 39Y30Y1980 35 Ma")#*(no 72Y12Y1983 32 <e$en(no 37Y28Y1987 31 Ma")#*(no 67Y25Y1983 32 Ma")#*(no 3

11Y29Y1981 37 <e$en(no 66Y28Y199 36 <e$en(no 23Y31Y1981 37 <e$en(no 7Y28Y1983 32 Ma")#*(no 72Y20Y1986 29 <e$en(no 27Y23Y1985 30 <e$en(no 52Y1Y198 3 Ma")#*(no 37Y9Y1980 35 Ma")#*(no 31Y8Y199 3 Ma")#*(no 7

5Y12Y1981 37 <e$en(no 78Y9Y198 3 <e$en(no 7

8Y27Y1985 30 Ma")#*(no 3

1Y16Y1987 32 <e$en(no 21Y26Y1983 33 <e$en(no 511Y3Y1982 33 Ma")#*(no 3

TIEMPOE#TUDIO#

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 25/81

9Y30Y1985 30 Ma")#*(no 67Y25Y198 3 Ma")#*(no 3

10Y13Y1982 33 <e$en(no 37Y12Y1986 29 <e$en(no 6

12Y12Y1987 31 Ma")#*(no 55Y2Y1985 30 Ma")#*(no 3

8Y30Y1985 30 <e$en(no 66Y12Y198 3 <e$en(no 2

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 26/81

TIEMPO E#TUDIO#

a4

APELLIDO

\26 E"t&e**aEnda&aCa"a&e"=#enteG&(Ha*'a

4

APELLIDO

#&(ta

And&e"<a*)+nGa&)aEnda&a:a*'o&"on

 Ja),"

M(**e&Nea*Ae&'e(**ea":a&o

 Tan?#(noe*a"te#(

=#entea**ada&e"Ro$e&oO&t(

B#)he*(G#ano)hanaGo&d+ne*aMa&tneId&o'o

)4

APELLIDO

<o&dGandet

APROVEC&

AMIENTOACADÉMICO

APROVEC&AMIENTO

ACADÉMICO

APROVEC&AMIENTOACADÉMICO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 27/81

La,eMonte&o

A! Ronn(e22 2009 Sa*aa&28 2002 2010

30 2009 d4

APELLIDO

28 200923 20022 20030 200929 201021 200929 20082 201026 200

23 200830 200928 201026 200828 200826 201129 200921 2002 201025 200925 20023 2010

30 200829 201025 200926 200923 200823 200827 201028 200928 201021 200922 201026 2002 201025 20027 201126 20092 200923 201123 20082 201028 201029 200926 200927 200925 2010

30 20112 20082 2010

APROVEC&AMIENTOACADÉMICO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 28/81

2 20021 201028 201029 20029 20082 201022 20030 2011

26

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 29/81

NOMBRE E#CUELA FEC&A IN-RE#O EDAD

Cathe&(ne A&?#(te)t#&a 3Y31Y2009 1190400 11Y16Y1986 29C&("t(na A&?#(te)t#&a 12Y23Y2010 1232400 9Y16Y1983 32Nohe$ A&?#(te)t#&a 8Y31Y2009 1392400 Y15Y1986 29Dan(e*a A&?#(te)t#&a 9Y7Y2010 103400 10Y16Y1983 32Nan) A&?#(te)t#&a 7Y6Y200 1400 7Y12Y1986 29

NOMBRE E#CUELA FEC&A IN-RE#O EDAD

A*eHand&a A&?#(te)t#&a 5Y22Y2009 1768400 5Y16Y1981 37

<&an)e" =#*()(dad 8Y20Y200 1171400 3Y9Y1986 29Cha&*e" =#*()(dad 1Y5Y200 1150400 3Y2Y1980 35M(#e* =#*()(dad 9Y13Y2008 1711400 9Y1Y199 36C&("t(na A&?#(te)t#&a 12Y23Y2010 1232400 9Y16Y1983 32Mon()a =#*()(dad 2Y18Y200 1757400 8Y1Y1985 30&(" =#*()(dad 1Y13Y2009 880400 2Y17Y199 36

a)ha& =#*()(dad 11YY2009 111400 1Y31Y1980 35Ste'e A&?#(te)t#&a 8Y3Y2010 1290400 1Y31Y199 36Ma&a =#*()(dad 11Y30Y2009 1297400 8Y13Y199 36Ad&(ana =#*()(dad 8Y6Y2010 973400 5Y8Y1983 32<e&nando A&?#(te)t#&a 10Y1Y2009 1725400 Y17Y1980 35=ed&o =#*()(dad 8Y5Y2008 6400 Y6Y1980 35<&edd =#*()(dad 10Y28Y2010 27400 11Y17Y1986 29

Dan(e*a A&?#(te)t#&a 9Y7Y2010 103400 10Y16Y1983 32<&edd =#*()(dad 12Y15Y2009 952400 9Y30Y1980 35Ana A&?#(te)t#&a 2Y17Y2010 1181400 2Y12Y1983 32=a$e*a A&?#(te)t#&a 6Y16Y200 1188400 11Y29Y1981 37

M+n()a =#*()(dad 7Y21Y2011 106400 6Y28Y199 36Ma&a&(ta A&?#(te)t#&a 6Y28Y2009 1269400 3Y31Y1981 37Ma&)e*o =#*()(dad 7Y5Y2009 1329400 Y28Y1983 32Pta*o A&?#(te)t#&a Y22Y2010 170400 7Y9Y1980 35Ma&a =#*()(dad 3Y27Y2009 138400 5Y12Y1981 37Ro)o =#*()(dad 8Y29Y2008 1288400 1Y26Y1983 32

NOMBRE E#CUELA FEC&A IN-RE#O EDAD

:#nte& Me)at&+n()a 12Y22Y200 1198400 10Y3Y1986 29De(e Me)at&+n()a 12Y23Y2009 1083400 5Y1Y1986 29

+

VALORMATR4CULA FEC&A DENACIMIENTO

VALORMATR4CULA

FEC&A DENACIMIENTO

VALORMATR4CULA

FEC&A DENACIMIENTO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 30/81

L("a Me)at&+n()a 2Y10Y2008 90400 5Y23Y1987 31e&+n()a Me)at&+n()a 11Y30Y2008 1396400 Y9Y1985 30

a&*a Me)at&+n()a 12Y15Y2008 859400 9Y1Y1983 32M(#e* Me)at&+n()a 1Y18Y200 93400 9Y30Y1985 30

NOMBRE E#CUELA FEC&A IN-RE#O EDADVALOR

MATR4CULAFEC&A DE

NACIMIENTO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 31/81

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 32/81

-ÉNERO

<e$en(no 7 28<e$en(no 3 2<e$en(no 7 28<e$en(no 3 28<e$en(no 6 29

-ÉNERO

<e$en(no 7 22

<e$en(no 6 28Ma")#*(no 6 23Ma")#*(no 5 29<e$en(no 3 2<e$en(no 6 26Ma")#*(no 7 30

Ma")#*(no 7 29Ma")#*(no 3 2<e$en(no 7 25<e$en(no 3 29Ma")#*(no 7 25Ma")#*(no 5 23Ma")#*(no 3 27

<e$en(no 3 28Ma")#*(no 7 21<e$en(no 3 22<e$en(no 6 25

<e$en(no 2 27<e$en(no 7 26Ma")#*(no 7 2Ma")#*(no 3 28<e$en(no 7 26<e$en(no 5 2

-ÉNERO

A!Ma")#*(no 6 22 200<e$en(no 7 21 2009

TIEMPOE#TUDIO#

APROVEC&

AMIENTOACADÉMICO

TIEMPOE#TUDIO#

APROVEC&AMIENTOACADÉMICO

TIEMPOE#TUDIO#

APROVEC&AMIENTO

ACADÉMICO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 33/81

<e$en(no 5 28 2008<e$en(no 5 30 2008

<e$en(no 5 23 2008Ma")#*(no 6 2 200

-ÉNEROTIEMPO

E#TUDIO#

APROVEC&AMIENTO

ACADÉMICO

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 34/81

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 35/81

Te3a: #ub/o/a.esCon .os da/os de .a /ab.a in"e!io! !ea.iJa! .o si1uien/e:a O&dena& en /o&$a a")endente aHo *o" )&(te&(o"> AO SEMESTRE =ROINCIA CI!DAD Gene&a& "#tota*e" %o& =ROINCIA %a&a )a*)#*a& e* %&o$ed(o de* %#ntaHe oten(do en e

APELLIDO NOMBRE A?O #EME#TRE

LINARES MARCELO 2010 1

A=ATA ELIABET: 2010 1G!ERRA CIND; 2010 1L!.!E CARMEN 2010 1CARDENAS ANA 2010 1I!ETE =AMELA 2010 1=RE DARIO 2010 1

COLOMA GRACE 2010 1:O;OS ERIA 2010 1SALGADO CRISTINA 2010 1MORENO IMENA 2010 1ES=ARA JENNI<ER 2010 1BENALCQAR <ERNANDO 2010 1 JARAMILLO DIEGO 2010 1

DQILA ALERIA 2010 1MORALES CAROLINA 2010 1C:AMORRO BRA;AN 2010 1G!ATEMAL ALEANDRA 2010 1LESCANO GABRIELA 2010 1=ERALO DAIS; 2010 1CASTILLO  JENN;<ER 2010 1SORIA ADRIANA 2010 1ERGARA :ENR; 2010 1

9

CLAIJO ;ADIRA 2010 1AG!ILAR REGINA 2010 1ROJAS <ERNANDO 2010 1BARRERA ANGIE 2010 1GALAN ALEJANDRA 2010 1MARTINE MIRE;A 2010 1ORTEGA OMAR 2010 1MOLINA ISABEL 2010 1R!ALES REN 2010 1

9AMBRANO  JANNIS 2010 2BECERRA GABRIELA 2010 2CADENA RA.!EL 2010 2

<ERNQNDE BLADIMIR 2010 2MONTES AIER 2010 2M!O CECILIA 2010 2ORTEGA MARIA 2010 2

AA ;ADIRA 2010 2REINOSO ALEANDRA 2010 2R!SSO GRACIELA 2010 2GARCIA ADRIANA 2010 2QSCONE GABRIELA 2010 2ES=INOA ALERIA 2010 2

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 36/81

ALENCIA SAMANT:A 2010 2 TO=ÓN RODRIGO 2010 2

8SILA =RE 2010 2COBO MONSERRAT 2010 2MQRMOL ELIABET: 2010 2 JARAMILLO DAMARIS 2010 2SANC:E <ERNANDO 2010 2

5G!EARA DANIEL 2010 2

1<LORES ANDRES 2011 1CASTRO ANESSA 2011 1CARRERA  JESSICA 2011 1ANDRADE RIGOBERTO 2011 1

7 TORRES ANGEL 2011 1 JARAMILLO ANESSA 2011 1G!ERRERO ANDREA 2011 1MONTENEGRO MONICA 2011 1AMN  JONAT:AN 2011 1ALTAMIRANO ICTOR 2011 1ARCOS BELEN 2011 1CONSTANTE ED!ARDO 2011 1ILLAMARIN ELIECER 2011 1CASTRO DIANA 2011 1LOGAC:O CAROLINA 2011 1BELALCAAR <ERNANDO 2011 1BERNAL ELIANA 2011 1

13BALAREO GRACE 2011 1GARCIA MARPA 2011 1ABRIL ED]IN 2011 1

MEJIA JONAT:AN 2011 1A;ALA ERÓNICA 2011 1A;ALA SO<PA 2011 1

6.!INATOA GENESIS 2011 1ANDRADE CECILIA 2011 1A;ALA C:RISTIAN 2011 1 TERQN MARI!I 2011 1

7C:!.!ER SEBASTIQN 2011 2G!MQN  JONAT:AN 2011 2MOLINA ED]IN 2011 2G!ERRÓN ]ILSON 2011 2

SALCAN SILIA 2011 25

MACAS  J:OANA 2011 2ILLAGRQN MA;RA 2011 2MERA DAID 2011 2ALARE MAN!EL 2011 2 JQCOME EDGAR 2011 2SALADOR =ATRICIA 2011 2NACIMBA MARPA 2011 2CASTRO SILANA 2011 2

8

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 37/81

=RE NORBERTO 2011 2ARGAS ERICA 2011 2CAIA ALEANDER 2011 2G!ERRERO  ;ADIRA 2011 2LEDESMA JOAO 2011 2MACIAS JACELINE 2011 2=AC:ECO NOEMP 2011 2SALAAR MILENA 2011 2

RE;ES ELIABET: 2011 29

ANG!LO  JONAT:AN 2011 2CS=EDES DIANA 2011 2

2ARELA SILANA 2012 1<LORES ALEANDER 2012 1MOROC:O ELBA 2012 1ES=INOSA EST:ER 2012 1=AC:ECO INGRID 2012 1AMBRANO <RANCISCO 2012 1C:AE ALBERTO 2012 1 JARAMILLO MIRIAM 2012 1RIADENEIRA EDGAR 2012 1

9CR! =AOLA 2012 1MOS.!ERA CECILIA 2012 1ANDRADE ROGER 2012 1IAR ERIC  2012 1CASTELLANOS ROCPO 2012 1CABEAS DIEGO 2012 1

6ARGAS DIANA 2012 1ITERI AIER 2012 1BARROS DANIEL 2012 1

 TERQN MARIA 2012 1G!ERRA  TANIA 2012 1DE<AS <ERNANDA 2012 1CADENA QNGEL 2012 1ALMEIDA SANDRA 2012 1=EA ADRIANA 2012 1REA IGNACIO 2012 1

10=AREDES =ABLO 2012 1ARIAS DANIELA 2012 1MERA ELA 2012 1

3<LORES DIANA 2012 2

NEGRETE ALE 2012 2CANDO ISRAEL 2012 2CASTRO DIEGO 2012 2CARAJAL MELISSA 2012 2OJEDA RONN; 2012 2

6EST!=IQN DE 2012 2G!ERRA <ERNANDO 2012 2RIOS DIEGO 2012 2GARATE SILIA 2012 2CORTS SAL 2012 2

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 38/81

GÓME ]END; 2012 2ROSERO <RANCISCO 2012 2MALES =A!LA 2012 2

8=IEDRA <RED; 2012 2BORJA ;ESENIA 2012 2RIADENIERA SANTIAGO 2012 2G!AC:AMIN ED!ARDO 2012 2

MOROC:O CSAR 2012 2=INTO SILANA 2012 2IN!EA ANDRES 2012 2=AREDES EDISON 2012 2

8SALAAR DIANA 2012 2ORTEGA TANIA 2012 2

2156

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 39/81

CARRERA A=ELLIDO ; NOMBRE  * ea$en de ad$("(+n e* nF$e&o de e"t#d(ante"4

PROVINCIA CIUDAD CARRERA

A#a Cho&de*e 925 Inen(e&a

A#a C#en)a 912 Inen(e&aA#a C#en)a 85 Med()(naA#a S("( 32 Ed#)a)(+nA#a S("( 962 Inen(e&aA#a S("( 967 Inen(e&aA#a S("( 826 Med()(na

Cuen/a AJua G#aa" G#aa?#(* 957 Inen(e&aG#aa" G#aa?#(* 979 Inen(e&aG#aa" G#aa?#(* 913 Inen(e&aG#aa" M(*a&o 673 A&?#(te)t#&aG#aa" M(*a&o 563 E)ono$aG#aa" M(*a&o 85 Med()(naG#aa" Na&anHa* 912 Inen(e&a

Cuen/a -uaas =()h(n)ha Caa$e 681 A&?#(te)t#&a=()h(n)ha Caa$e 68 A&?#(te)t#&a=()h(n)ha Ma)ha)h( 85 Med()(na=()h(n)ha .#(to 529 E)ono$a=()h(n)ha .#(to 522 E)ono$a=()h(n)ha .#(to 02 Ed#)a)(+n=()h(n)ha .#(to 872 Med()(na=()h(n)ha Sano*?#   502 E)ono$a=()h(n)ha Sano*?#   996 Inen(e&a

Cuen/a Pic8inc8a 9

S#)#$o" Ca")a*e" 539 E)ono$aS#)#$o" Ca")a*e" 67 Ed#)a)(+nS#)#$o" Ca")a*e" 6 Ed#)a)(+nS#)#$o" Ca")a*e" 858 Med()(naS#)#$o" N#e'a LoHa 53 E)ono$aS#)#$o" N#e'a LoHa 570 E)ono$aS#)#$o" N#e'a LoHa 50 Ed#)a)(+nS#)#$o" N#e'a LoHa 981 Inen(e&aS#)#$o" N#e'a LoHa 908 Inen(e&a

Cuen/a #ucu3b7os 9A#a Cho&de*e 52 E)ono$aA#a Cho&de*e 62 Ed#)a)(+nA#a Cho&de*e 82 Med()(na

A#a Cho&de*e 857 Med()(naA#a Cho&de*e 807 Med()(naA#a S("( 680 A&?#(te)t#&aA#a S("( 67 A&?#(te)t#&a

Cuen/a AJua G#aa" G#aa?#(* 678 A&?#(te)t#&aG#aa" M(*a&o 5 Ed#)a)(+nG#aa" M(*a&o 91 Ed#)a)(+nG#aa" M(*a&o 900 Inen(e&aG#aa" M(*a&o 968 Inen(e&aG#aa" M(*a&o 869 Med()(na

PUNTA;E EAMENADMI#I$N

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 40/81

G#aa" M(*a&o 895 Med()(naG#aa" Na&anHa* 853 Med()(na

Cuen/a -uaas 8=()h(n)ha Caa$e 988 Inen(e&a=()h(n)ha .#(to 962 Inen(e&a=()h(n)ha .#(to 906 Inen(e&a=()h(n)ha .#(to 895 Med()(na=()h(n)ha Sano*?#   561 E)ono$a

Cuen/a Pic8inc8a 5S#)#$o" N#e'a LoHa 85 Med()(na

Cuen/a #ucu3b7os 1A#a Cho&de*e 690 A&?#(te)t#&aA#a C#en)a 562 E)ono$aA#a S("( 535 E)ono$aA#a S("( 906 Inen(e&a

Cuen/a AJua 7G#aa" G#aa?#(* 521 E)ono$aG#aa" G#aa?#(* 12 Ed#)a)(+nG#aa" G#aa?#(* 936 Inen(e&aG#aa" G#aa?#(* 995 Inen(e&aG#aa" G#aa?#(* 899 Med()(naG#aa" M(*a&o 0 Ed#)a)(+nG#aa" M(*a&o 08 Ed#)a)(+nG#aa" M(*a&o 80 Ed#)a)(+nG#aa" M(*a&o 883 Med()(naG#aa" Na&anHa* 658 A&?#(te)t#&aG#aa" Na&anHa* 603 A&?#(te)t#&aG#aa" Na&anHa* 51 Ed#)a)(+nG#aa" Na&anHa* 830 Med()(na

Cuen/a -uaas 13=()h(n)ha Caa$e 31 Ed#)a)(+n=()h(n)ha Caa$e 913 Inen(e&a=()h(n)ha .#(to 63 A&?#(te)t#&a

=()h(n)ha .#(to 52 Ed#)a)(+n=()h(n)ha .#(to 975 Inen(e&a=()h(n)ha Sano*?#   959 Inen(e&a

Cuen/a Pic8inc8a 6S#)#$o" Ca")a*e" 96 Inen(e&aS#)#$o" N#e'a LoHa 38 Ed#)a)(+nS#)#$o" N#e'a LoHa 821 Med()(naS#)#$o" N#e'a LoHa 888 Med()(na

Cuen/a #ucu3b7os 7A#a Cho&de*e 19 Ed#)a)(+nA#a Cho&de*e 79 Ed#)a)(+nA#a Cho&de*e 90 Inen(e&aA#a C#en)a 67 Ed#)a)(+n

A#a C#en)a 31 Ed#)a)(+nCuen/a AJua 5

G#aa" G#aa?#(* 637 A&?#(te)t#&aG#aa" G#aa?#(* 633 A&?#(te)t#&aG#aa" G#aa?#(* 53 Ed#)a)(+nG#aa" M(*a&o 691 A&?#(te)t#&aG#aa" M(*a&o 622 A&?#(te)t#&aG#aa" M(*a&o 893 Med()(naG#aa" Na&anHa* 662 A&?#(te)t#&aG#aa" Na&anHa* 559 E)ono$a

Cuen/a -uaas 8

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 41/81

=()h(n)ha Caa$e 599 E)ono$a=()h(n)ha Caa$e 972 Inen(e&a=()h(n)ha .#(to 6 A&?#(te)t#&a=()h(n)ha .#(to 53 E)ono$a=()h(n)ha .#(to 51 E)ono$a=()h(n)ha .#(to 81 Ed#)a)(+n=()h(n)ha .#(to 932 Inen(e&a=()h(n)ha .#(to 907 Inen(e&a

=()h(n)ha Sano*?#   53 E)ono$aCuen/a Pic8inc8a 9

S#)#$o" Ca")a*e" 977 Inen(e&aS#)#$o" N#e'a LoHa 566 E)ono$a

Cuen/a #ucu3b7os 2A#a Cho&de*e 698 A&?#(te)t#&aA#a Cho&de*e 512 E)ono$aA#a Cho&de*e 571 E)ono$aA#a C#en)a 559 E)ono$aA#a C#en)a 520 E)ono$aA#a C#en)a 56 E)ono$aA#a C#en)a 55 Ed#)a)(+nA#a C#en)a 16 Ed#)a)(+nA#a S("( 652 A&?#(te)t#&a

Cuen/a AJua 9G#aa" G#aa?#(* 69 A&?#(te)t#&aG#aa" G#aa?#(* 968 Inen(e&aG#aa" M(*a&o 996 Inen(e&aG#aa" M(*a&o 86 Med()(naG#aa" Na&anHa* 60 A&?#(te)t#&aG#aa" Na&anHa* 962 Inen(e&a

Cuen/a -uaas 6=()h(n)ha Caa$e 686 A&?#(te)t#&a=()h(n)ha Caa$e 936 Inen(e&a=()h(n)ha Caa$e 805 Med()(na

=()h(n)ha Ma)ha)h( 886 Med()(na=()h(n)ha .#(to 695 A&?#(te)t#&a=()h(n)ha .#(to 997 Inen(e&a=()h(n)ha .#(to 855 Med()(na=()h(n)ha Sano*?#   6 A&?#(te)t#&a=()h(n)ha Sano*?#   622 A&?#(te)t#&a=()h(n)ha Sano*?#   93 Inen(e&a

Cuen/a Pic8inc8a 10S#)#$o" Ca")a*e" 598 E)ono$aS#)#$o" Ca")a*e" 952 Inen(e&aS#)#$o" N#e'a LoHa 820 Med()(na

Cuen/a #ucu3b7os 3A#a Cho&de*e 28 Ed#)a)(+n

A#a C#en)a 1000 Inen(e&aA#a C#en)a 891 Med()(naA#a S("( 691 A&?#(te)t#&aA#a S("( 955 Inen(e&aA#a S("( 902 Inen(e&a

Cuen/a AJua 6G#aa" M(*a&o 656 A&?#(te)t#&aG#aa" M(*a&o 605 A&?#(te)t#&aG#aa" M(*a&o 600 A&?#(te)t#&aG#aa" M(*a&o 519 E)ono$aG#aa" M(*a&o 73 Ed#)a)(+n

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 42/81

G#aa" M(*a&o 93 Ed#)a)(+nG#aa" M(*a&o 37 Ed#)a)(+nG#aa" Na&anHa* 03 Ed#)a)(+n

Cuen/a -uaas 8=()h(n)ha Caa$e 693 A&?#(te)t#&a=()h(n)ha Caa$e 63 Ed#)a)(+n=()h(n)ha Ma)ha)h( 522 E)ono$a=()h(n)ha Ma)ha)h( 935 Inen(e&a

=()h(n)ha .#(to 972 Inen(e&a=()h(n)ha .#(to 965 Inen(e&a=()h(n)ha .#(to 828 Med()(na=()h(n)ha Sano*?#   61 Ed#)a)(+n

Cuen/a Pic8inc8a 8S#)#$o" Ca")a*e" 615 A&?#(te)t#&aS#)#$o" N#e'a LoHa 973 Inen(e&a

Cuen/a #ucu3b7os 2Cuen/a 1ene!a. 156

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 43/81

Te3a: Tab.as din3icasEn *a ta*a de dato" (n/e&(o& "e &e("t&a e* )a%(ta* (n()(a* )on e* )#a* "e )on"t(t#e&on *ea*$eD("ea& #na ta*a d(n$()a ?#e $#e"t&e %o& %a" e* %&o$ed(o de CA=ITAL INICIAL )on e* ?#e

NOMBRE EMPRE#A CLA#E PA4#=a*o A&&e%()he C Co*o$(a

Me&)ado" de <a$(*(a S4A A E)#ado&O*$edo De*ado A Co*o$(aA*/&edo G#e&&e&o B Co*o$(aCa&*o" A##"to Bon(**a Ba&&aan D Co*o$(a Todo***anta" Ltda C Co*o$(a()to& J#*(o No'a A B&a"(*L#(" <&an)(")o =e&e Te**e A Co*o$(a:e&$e" C#(de" B Co*o$(aL($aHo Ltda B Co*o$(aA&t#&o de Je"#" Ge*'e D(a A Co*o$(aL#(" E4 A*dana A Co*o$(aAe* =a&&ado B Co*o$(aG*o&(a Ine" So*ano =a&&a A Co*o$(aE*e)t&()ado&a de Santande& C Co*o$(aL#(" A*/&edo A#(**on A Co*o$(aCa&*o" And&e" R#( A Co*o$(a:e)to& <4 Lo%e (**a B Co*o$(aC*a#d(a M#&)(a To&&e" A Co*o$(a<e*(%e .#(nte&o A&t#aa A B&a"(*G*o&(a a$%a&o Sa*aa& <*o&e C Co*o$(a=ana$e&()ana S4A C Co*o$(aM(#e* A*a&)on Ga&on A Co*o$(aSantande&eana de '(aHe" Ltda B E)#ado&Ca&*o" A*e&to Ja&a$(**o B Co*o$(aS(*'e&(o <aHa&do R#eda D Co*o$(a

Ma&a&(ta Ga&)(a RoHa" A Co*o$(aCa&o*(na .#(one A Co*o$(aCent&a* To&n(**o" &e$a)he" B Co*o$(a J#*(o Ca$a)ho B Co*o$(a](*"on San)he A Co*o$(a<&ed O&d(o Ga(tan B Co*o$(aRodo*/o Ta%(e&o A Co*o$(aA*on"o Moo**on A Co*o$(aCa&*o" G#t(e&&e To&&e" A Co*o$(a:#$e&to Be)e&&a C(a Ltda C Co*o$(aSa( (**a J#*(a A Co*o$(aD(ana T(nHa)a :o*#(n A Co*o$(a:e&nando :#&tado Montoa A Co*o$(a

A*e Gona*e A Co*o$(aEda& A*'a&e .#(one B B&a"(*G#"ta'o Go$e B#eno A Co*o$(aNe"to& S#a&e S(*'a A Co*o$(aE"te**a To&&e" A Co*o$(aAna Ma&(a L(e'ano A E)#ado&Ed#a&do Daa Ma*a#e&a A Co*o$(a Jan Ga&)(a A*'a&e D B&a"(*O"$an ;e&*e Ce*(" Ta%(a" A Co*o$(a Jo"e !*("e" Ba#t("ta A Co*o$(ae*ota Ltda A Co*o$(a

Obse!=aci2n: !()a& en *a" *a" *a CI!DAD en *a" )o*#$na" *a CLASE4

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 44/81

Ca&$en Ota*o&a A Co*o$(aICA A Co*o$(aL#(" Ed#a&do A&ano G#t(e&&e A Co*o$(aD&o$ao& de* **ano S4A A Co*o$(aAnd(net C Co*o$(aAna Betae Man&(?#e A Co*o$(aD(ana Co*$ena&e" A Co*o$(aMa&(a de* Ca&$en To&&e" A Co*o$(a

<SC Ltda C(a SCA A Co*o$(a:a&'e :enao e&a&a B E)#ado&Rodo*/o .#(&oa T&#H(**o A Co*o$(a Jhon E"tean S(*'a A B&a"(*L#(" Ca&*o" <o&e&o A Co*o$(a:e&$an N(*"on G#t(e&&e S#a&e C Co*o$(aA*/on"o A)#a B Co*o$(aCen(de Ban?#e&o A E)#ado&Ca&#**a ('e&o S4A C Co*o$(aNe*"on Ca"t&o Sedano D Co*o$(aNe*) Mo&eno Contento A Co*o$(aO")a& a&ate A Co*o$(aM(&(a$ To&&e" Londoo A Co*o$(a<e&nando Ca&dena" B Co*o$(aEda& :e&nan Ca$%o" A Co*o$(aG&ande" S#%e&)(e" de Co*o$(a A Co*o$(aI"(d&o Rod&(#e a&a" C Co*o$(a<a(an Maae* A Co*o$(a Jo"e A4 Ba?#e&o A Co*o$(aAd&(ana Ca*de&on A Co*o$(a Ja($e :e&nande A Co*o$(a=a#*(na =(n(**a Mo&eno A Co*o$(aL(a&do Montoa A Co*o$(aAnton(o Mon&o #*#aa B Co*o$(aA*$a)ene" E(to S4A A B&a"(*

O)4 In"t&#$4 =#*4 =to Lo%e B Co*o$(a:e*ade&(a *o" S(e&&a A Co*o$(a=*#ta&)o Rod&(#e A Co*o$(a<e&ne Londoo A*/on"o A E)#ado&=ed&o E4 Moano B Co*o$(aL#)e&o ea D Co*o$(aG#(**e&$o Le(n Ga'(&(a B4 D Co*o$(aA*eHand&a Ca&&(on J($ene A Co*o$(a ;o&*e Monte" A Co*o$(aOno/&e =(n(**a R#(ano A Co*o$(a Ja($e Londoo A Co*o$(a Jo"e A*e&to Go$e Co&te" A Co*o$(a<e&&o@A&o B Co*o$(a

A&t#&o :e&nande A Co*o$(aEda& .#(one B Co*o$(aA&$e* a&a" Go$e B Co*o$(aEd#a&do Roo R(n)on A Co*o$(aE*(e)e& N4 C&("t(ano A Co*o$(aA$a*(a ]e")ot A Co*o$(a Jo&e N#e A)eedo A Co*o$(a:en& San)he B B&a"(*A'(an)a C Co*o$(a()to& =a*a)(o" M#ne&a A Co*o$(a Jo&e =ed&o C#$ana()a C Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 45/81

Sa( e* A*)a&a'an E4! A E)#ado&And&ea =a&do Ra$o" A Co*o$(aA$(o" de* o"?#e A Co*o$(aL#)(nda Ma&t(ne M D Co*o$(aG&a"ot Ltda B Co*o$(aITALDEC E4! B Co*o$(aRa$on E*(a" A*'a&e C Co*o$(a=a*o Ga(tan C Co*o$(a

=a%e*e&(a D(da)t()a C Co*o$(a Jo"e <e&nande B Co*o$(aM("ae* Ga(tan A Co*o$(a!e& Be*t&an C Co*o$(a(aneth Bo'ea A Co*o$(aL#(" Ne&eo Ba&&aan B Co*o$(aMa&tha L#da& Ca"t&o D(a A Co*o$(aMa&(a L#("a Ba)a A Co*o$(a=&o"%e&a& CTA A Co*o$(aR(oe&to A%onte A&e'a*o A B&a"(*A&n#*/o Ba&o"a B Co*o$(a<&ed M#&)(a Re B Co*o$(aCa"a Ja%one"a A Co*o$(aA"ota'an B E)#ado&Sand&a L#)(a Rod&(#e A Co*o$(aE"t&#)t#&a" Meta*()a" =&oa)e&o Ltda A Co*o$(aA&t#&o L(na&e" D Co*o$(aSant(ao Mano"a*'a C Co*o$(aRo"a Mende A Co*o$(a=*aneta Inte&net A Co*o$(aL#(" A*/on"o Ro"o A*'a&e A Co*o$(aA*/on"o Ga&)(a RoHa" A Co*o$(aBo$e&o" de Mede**n A Co*o$(aC(#dade*a )(a* !n()ent&o A Co*o$(aMa#&()(o Mate#" A Co*o$(a

Ma&(a L#("a Lo A Co*o$(a JG A Co*o$(aGona*o Montene&o A Co*o$(aIn"o/t Ltda B Co*o$(aM(#e* Ca")a'(to A Co*o$(aMa&oth Ra$(&e )o*on A B&a"(*=a*o En&(?#e A&(a" A Co*o$(aCo%"e&'(& Ltda A Co*o$(a Jo"e Dane&"on Ga(tan M4 C Co*o$(aAd$on )o*o$(ana de :ote*e" A E)#ado&O*a Janeth Santo" Ma&(n A Co*o$(aL#(" En&(?#e Ga&)(a RoHa" A Co*o$(a=ed&o Ne* A#de*o D Co*o$(a

Ma#&()(o =#*(do Ma)(a" D Co*o$(a

A*/&edo R(n)on :oo" @ Se&'()ent&o *o" A&()#*to&e" B Co*o$(aA&(*a C Co*o$(a J#an Ca&*o" M(**an C Co*o$(aD#& Anto*(ne :e&nande A Co*o$(a Jo"e !&(e* Gona*e Mo&a C Co*o$(aMo'a$o" Ltda C Co*o$(a J#an Ca&*o" Go$e A Co*o$(aDe$et&(o Sana&(a A&e'a*o C Co*o$(aMe&"a&o C Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 46/81

R(oe&to To*oa A Co*o$(aA$a*(a ]e")oth A Co*o$(a=a#*(no Montene&o 4 A Co*o$(aG(o'ana A4 Rod&(#e A B&a"(* J#*(o Cano A*a&&a)(n A Co*o$(aC*a#d(a M#&)(a Mo&a*e" A Co*o$(a Je"#" A4 Ca*de&on B Co*o$(a Ja(&o =enao" C E)#ado&

<&an)(")o RoHa" A Co*o$(aRodo*/o a&a" Rod&(#e B Co*o$(a=a*o E"*a'a R4 A Co*o$(a Jo"e C&("toa* e*a"?#e R('e&a D Co*o$(aA*e&to Ro*dan San)he A Co*o$(aCa&*o" N4 D( Ma&)o B Co*o$(aGe&$an Mate#" Gona*e C Co*o$(aMa&o&( Ra$o" A Co*o$(aBa Se)#&(t Ltda A Co*o$(a=&o)a$ S4A A Co*o$(a Jo"e Man#e* Ced(e* B Co*o$(aAna Beat&( <(e&&o A Co*o$(aA&o'ete&(na&(a *o" )aa**o" A Co*o$(aGe&$an S(e&&a C Co*o$(aMa&(a L#("a Ba)a A Co*o$(aLeoh(*da Cont&e&a" A Co*o$(aL#(" Lo%e O"o&(o A B&a"(*Beat&( G#t(e&&e Bad(**o A B&a"(*<e&nando A&aon B Co*o$(aMa&)o" =a&&a A Co*o$(aA*a(t Re"t&e%o C#a?#eta A E)#ado&Ge&$an Ca&dona R4 A Co*o$(aA*e&to Con)ha RoHa" C(a Ltda A Co*o$(aCa&$en Anton(a =e&ea Go$e A Co*o$(aGe&$an Mate#" Gona*e D Co*o$(a

O&*ando =e&a*ta D Co*o$(a Ja'(e& J($ene A Co*o$(aSo)(edad B#*e'a& Ltda B Co*o$(aCa&o*(na Ce*(" A Co*o$(a Jo"e Anton(o Ma&t(ne A Co*o$(a Jo&e A&$ando Se&&ano A Co*o$(aGe&$an E"%a&a Ga(tan A Co*o$(a J#*(o E&ne"t&o a&a" Ce*(" A Co*o$(aAd&(ano :e&nande A Co*o$(aC(a a)#ed#)to $et&o%o*(tano de B#)a&a$ana C Co*o$(aCa&*o" Ca&e&a Ta$ao A Co*o$(a Jo"e M(#e* e*a"?#e T&(ana A Co*o$(aI'an And&e" O*('a Se&&ano A B&a"(*

O$a& O&H#e*a A Co*o$(aMa&(a =at&()(a Ca&dena" A Co*o$(a Jo"e !&?#(Ho A Co*o$(aA"("tenet C E)#ado&Ma&*on =ea A Co*o$(aAnan(a" RoHa" Ma&t(ne A Co*o$(aM(#e* Geo'an Ga(tan J&4 C Co*o$(a Jo&e !&ano Ba*dan A Co*o$(a Jo"e Re(na*do Ga(tan C#$ana()a D Co*o$(aSe&n)o Ltda B Co*o$(a<a(o Leon O"o&(o B Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 47/81

L#(" :4 Ba?#e&o A Co*o$(aA#toota S4A C Co*o$(a Jo"e A*eande& M#o A Co*o$(aLeone* !&(e Be*t&an B E)#ado&A*eand&a M4 :(da*o A Co*o$(a=ed&o Anton(o Ga(tan B*("" A Co*o$(aEda& L#na A Co*o$(aI'on Ma&(a O"o&(o A Co*o$(a

An)("a& N#e A Co*o$(aL#(" :4 Ba?#e&o A B&a"(* Jo"e L#(" To&&e" Ga*(ndo A Co*o$(a Jo"e E"tean :e&nande Ba?#e&o C Co*o$(aSe&'(a)o%*e" $an#e&a" de* **ano A Co*o$(a

Co&%o&a)(on Co*o$(ana de In'e"t(a)(on A&o%e)#a&(a A E)#ado&Ge&$an G(* =e&e B Co*o$(a Jo&e E4 =(non C Co*o$(aRa#* Ca")a'(ta A Co*o$(a Jo"#e Ca"t&o A Co*o$(a(**a <&an) Ltda D Co*o$(aEd(n <e&nando Ron)an)(o <*o&e D Co*o$(aOoh C#&&a$a B Co*o$(a<e&ne a)a A&(a" A Co*o$(aCa&*o" E4 Ga&)(a C Co*o$(a Jo"e A*eHand&o Moo**on G4 A Co*o$(aI"$ae* (de" Bote&o A Co*o$(aA*$a)en =o%#*a& Ca*( B Co*o$(aL# :e*ena Ba**e"te&o" A Co*o$(a:e&ne"to =e&e :e&nande C Co*o$(aeh()#*o" de* **ano Ltda B Co*o$(a J#an Ca&*o" R('e&a A Co*o$(a Je"#" Sa&$(ento A#(*a& B B&a"(*Ma&(a L#$(*a S#e")#n A Co*o$(a

E&(na&)o Ba**e"te&o" A Co*o$(aIn'(a" A Co*o$(aLed Con"#e*o G#$an A E)#ado&Ma&(a Lea* de :e&nande A Co*o$(aIn"t(t#to de T&an"(to T&an"%o&te de* Meta A Co*o$(aLeona&do Anton(o Ma&t(ne O&t( A Co*o$(a T&an"$#*t($a) Ltda C Co*o$(aAna Ce)(*(a A)e&o G#t(e&&e A Co*o$(aLa#&eano D#a&te !&&ea D Co*o$(aCa&*o" S(*'a B Co*o$(aCo*"#"(d(o B Co*o$(a<&an)(")o <&e"neda Ma&)e*o A Co*o$(aCoo%&o%(eta&(o" Cent&o Co$e&)(a* Caa'e&a* B Co*o$(a

 J#*(o Mon&o A Co*o$(aA* o"to S4A B Co*o$(aSe$(**ano B Co*o$(a<&ed M#&)(a Rod&(#e A Co*o$(aA*eand&a Sana&(a RoHa" A Co*o$(aL#(" Ro$e&o B Co*o$(aCo*Ha% Ind#"t&(a A&o?#($()a S4A A B&a"(*O&*ando Ga(tan A Co*o$(aA&oe?#(%o" Ltda A Co*o$(a<e&nando N#e e*and(a A Co*o$(aMa&* M#o A E)#ado&

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 48/81

And&e" <e*(%e R#a To&&e" B Co*o$(a:ote* Mede**n =*aa B Co*o$(aA&o/#$(a)(one" de* $eta *tda A Co*o$(a:ote* San Jo&e C(a Ltda A Co*o$(aE"tean Ana&(ta A Co*o$(a<&an)(")o R#eda =e&e D Co*o$(a Jo"e Sa*aa& B Co*o$(a J#d(th =o&te*a Ga&on A Co*o$(a

Co$#n()a)(one" :(*$a& A Co*o$(aEn&(?#e Ca&&(**o <*o&(an A Co*o$(a<#ente =o&te*a C(a Ltda A Co*o$(a:e&nando Ca"t(**o A Co*o$(a]($% Co*o$(ana Ltda B Co*o$(a Te&%e* C Co*o$(aE#en(o O)a$%o B Co*o$(aCC de Neo)(o" And(no B Co*o$(aMa&(a de* T&an"(to T(ata A B&a"(*L#(" A*e&to Bote&o :e&&e&a A Co*o$(a Je$ anea" Leon A Co*o$(aO$a& (a B Co*o$(aSnenta "e)to& "e$(**a" C E)#ado& Te*e)o$ B Co*o$(aO$a& O"a*do =(n(**a B Co*o$(a:e&nan O&o)o Ma&t(ne C Co*o$(aL#(" A*/on"o Ma&(n :e&nande B Co*o$(aRo"ana Lad(no de Bena'(de" A Co*o$(aD(ana M4 <o&e&o Rod&(#e D Co*o$(a=&ote(na" de* O&(ente S4A D Co*o$(aCe"a& A##"to &#( Re C Co*o$(aNo&( Adee Betan)o#&t A Co*o$(aAna A#&o&a Ca&&(**o A Co*o$(a=a%e*e&(a Ce&'ante" A Co*o$(aDon#)o* A Co*o$(a

N('e& S4A B Co*o$(aMa)o**ano" C Co*o$(aO$a& Anton(o =ed&aa Ma&t(ne A Co*o$(aDan(e*a <&(n O&t( A Co*o$(aIn'e&"(one" A*o Ltda B B&a"(*L#(" Ja($e =a)he)o A Co*o$(aA#"t(n Rod&(#e A Co*o$(a J#an And&e" Ra$(&e C Co*o$(a Ja(d A)o"ta A E)#ado&No&a L#)(a O'a**e A Co*o$(aE/&a(n A%a&()(o O&tea C E)#ado&A(&e" B Co*o$(a<&ed Ja&a G#t(e&&e A Co*o$(a

M(**e& <e&nando Go$e e*a"?#e B Co*o$(aD:L Inte&na)(ona* Ltda C Co*o$(a Jenn =ao*a =aon R#( D Co*o$(aAnd&e" Gona*e Soto A Co*o$(aAnde" Bee/ Ltda C Co*o$(aBeno( J4 Ata**ah A Co*o$(a<oto)o%(a" D(an A Co*o$(aA*e&to G#e&&e&o B Co*o$(aCon)e"(on de )a&&ete&a" de* $eta C Co*o$(aDaoe&to To&&e" A Co*o$(aIn'4 E* Co&&a* )(a Ltda A Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 49/81

A'e")o B Co*o$(aB44B4 )o$#n()a)(one" E! A B&a"(*L#(" A*on"o San)he A Co*o$(aA*e&to D#&an Rod&(#e C Co*o$(aRo$#*o de J4 M#o A4 A Co*o$(aA*$a)en Roda$(ento" S4A C E)#ado&:e)to& G#(o RoHa" A Co*o$(aA&oe%o&t de Co*o$(a Ltda C Co*o$(a

:(e*o %o*a&( C Co*o$(a Jo&e a&a" A Co*o$(aD(d(e& R#(o R(o" C Co*o$(aMata)ho" E4! C Co*o$(aG*o&(a =e&e Ca"t&o D Co*o$(aC*a#d(a Ren(/o No'oa A Co*o$(a()ente BeHa&ano A)o"ta A Co*o$(aAe* to&&e" !"e)he A Co*o$(aCa&*o" Ma&(n A%a&()(o A Co*o$(aCa&*o" A*/&edo O""a A Co*o$(a Jo"e O$a& Ga(tan A&&e%()he B Co*o$(a<*o& Ro$e&o A&)(n(ea" A Co*o$(a T#*(o Ra$(&o R('a" C Co*o$(aSan)ho%an E%&e"" A Co*o$(aI"(d&o Rod&(#e A&a" C B&a"(*In'e&"(one" La&&a&te So*ano Ltda B Co*o$(a<&an)(")o Ja'(e& D#?#e C Co*o$(aCo% "e&'()(o" de* **ano A Co*o$(aA)e" A E)#ado& Ja($e Lo&a A Co*o$(a ;e"(d Anton(o <o&e&o Ca$%o" A Co*o$(aGe&$an D(a A Co*o$(aEd(n Se#&a A Co*o$(a:ote* e* Ca($(to B Co*o$(aO%e(n'(a" Ltda A Co*o$(a

<(de* Ga(tan J&4 C Co*o$(aL#(" A*/on"o Ma&(n :e&nande D Co*o$(aM(&(a$ C&# R4 )(a Ltda B Co*o$(a]enh Chen Shen B Co*o$(aMa&(a L#("a de L(e'ano A Co*o$(aMa&tha R4 )o&te( Mo&eno A Co*o$(aRo)a& Ltda A Co*o$(aMa&*# BeHa&ano A Co*o$(aSa( Te*e)o$ B Co*o$(aS#%e&$e&)ado A#to"e&'()(o R B B Co*o$(aSo&aa de Be*en %aon Ra$(&e A B&a"(*Ca/ete&(a e&a)&# C Co*o$(aBe*,(" Rente&(a A'(*e A Co*o$(a

A#to**ano" S4A C Co*o$(aNe"to& G#$an A E)#ado&E*,(n Bon(**a =a&do A Co*o$(a=ed&o Ga(tan Caa&te J&4 A Co*o$(aG(*$a R#(ano San)he A Co*o$(a Jo"e Ra$on Len(" A Co*o$(aEda& e*e S#aa A Co*o$(aRa$(&o Oando B Co*o$(aA##"to S(*'a Ca"t(**o A Co*o$(aCa&*o" En&(?#e S(*'a =#*e)(o D Co*o$(aCo$e&)(a*(ado&a de Co*e))(one" A Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 50/81

 Jo"e Man#e* Man)e&a A Co*o$(aEda& E*( Monte" R#( A Co*o$(a Jo"e ()ente Gona*e A Co*o$(aMa&tha !nda A Co*o$(aMan#e* S#a&e A4 A Co*o$(aL#(" E4 B#(t&ao B Co*o$(a Te*e"an E4! B Co*o$(a:e*ena Caa" A B&a"(*

R()a&do <e&(a A Co*o$(a=ed&o J4 Ca$%o" A Co*o$(aAIDESA MAC =OLLO S4A B Co*o$(aRene Ca)e&e" <*o&e A E)#ado&D(heo Ltda B Co*o$(aMa&(a L#)e* O&t( =a&&a A Co*o$(a ;a$(*e =(non A Co*o$(aM(#e* Ga(tan Man)ha C Co*o$(aL#(" Anton(o Ca&e&a Ch('ate C Co*o$(a

E$%&e"a de Te*e)o$#n()a)(one" de B#)a&a$ana B Co*o$(a J#an C4 Ca"taeda Leon B Co*o$(aa&en =ao*a S#a&e R#a D Co*o$(aMa&(a L#)e* O&t( A Co*o$(a Jo"e A*/&edo J($ene A Co*o$(aEd#a&do Lo%e =a&&a A Co*o$(a(ne** Ltda C Co*o$(a Ja($e Ma&t(ne =o*an(a A Co*o$(aA*(&(o To?#()a Montene&o C Co*o$(aSe$(**a" a**e S4A4 C Co*o$(aC&e%e" ]a^e" S4A C Co*o$(aRe"ta#&ante e* Ca($(to A B&a"(*A"ado" *a a&a A E)#ado&A*eHand&o O&t( A Co*o$(a<e&ne A*'a&e C Co*o$(a

 Ja'(e& And&e" Ne(&a A E)#ado&Ma&)o" Ga(tan C Co*o$(a J#an =a*o E"t#%(an Ca)e&e" A Co*o$(aDa'(d C#(de" Santo" A Co*o$(aL#(" A*on"o Ca"t&(**on D(o"a B Co*o$(a Ja($e Rod&(#e a&a" A Co*o$(a ;o*anda J($ene A Co*o$(aSand&a A&(a" A Co*o$(a:e&nando =enao" Soto A Co*o$(aCa&o*(na Leon D Co*o$(a ;o*anda Mo&a*e" San)he A Co*o$(a()ente Soto C&("tan)ho C Co*o$(aA*e&to A&)(n(ea" :e&nande A Co*o$(a

L#(" Ed#a&do Mo&eno A Co*o$(aMa&(a de* S4 Ja&a$(**o de a&)(a A Co*o$(aDan(e* OHeda A Co*o$(aNan) B((ana E"%a&a A Co*o$(aR#%e&to Me*o A Co*o$(aI"ae* Leton Ra$o" A B&a"(* Te*e)o$ Sa( Te&$(na* Mede**n A Co*o$(a<&an)(")o G4 To&&e" Med(na A Co*o$(aCo$#n(?#e$o" E4! C E)#ado&Ca&*o" En&(?#e San)he =a&ada B Co*o$(aCe"a& <&an)o A Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 51/81

=a%e*e&(a *a =o%#*a& B Co*o$(a Ta Meta C Co*o$(a Je"#" A4 G#t(e&&e A Co*o$(aRoa* S#n Se#&o" Co*o$(a S4A B Co*o$(a J#an E"%a&a San)he A Co*o$(a T#*(o Ga(tan B Co*o$(aInd#"t&(a" E"t&a S4A D Co*o$(aAnd&e" <e*(%e A&ano A Co*o$(a

=e*ae :e&$ano" S4A A Co*o$(aCaHa Santande&eana de S#"(d(o <a$(*(a& B Co*o$(aSand&a M(*ena Co*$ena&e" A Co*o$(aGa" de Ca*( S4A C Co*o$(aRa#* Rod&(#e C&# C Co*o$(aA#to&&o**(n" M#*t(te)a Ltda C Co*o$(aMa&*en Ca"t&(**on G&aHa*e" A Co*o$(a Je"#" DA'(d Ca&dona R#( C B&a"(*Ma&)e*a Ra$(&e A Co*o$(aA* "e&'()(o C Co*o$(aA&$ando RoHa" T&(na A E)#ado& J($ena B*an)o A Co*o$(aMa&)o T4 San)he A Co*o$(a To&n(**o" an)*aHe" de* **ano B Co*o$(aRene Ca"t(**o :e&&e&a A Co*o$(a J#an Mena C Co*o$(a()to& D(a D#&an B Co*o$(aE*,(n Ga&)(a Ga(tan A Co*o$(a T&an" Mo*()ha* S4A B Co*o$(aSe&(o A4 Ca$a)ho =e&e D Co*o$(aCe*#*a& t($e B Co*o$(aIdda& S(*'a a*de&&a$a A Co*o$(aN#(a Co&te de Lo%e A Co*o$(aDo&(" Ta($a* A Co*o$(aO&*ando Ga(tan C Co*o$(a

=a&,(n Inte&na)(ona* C Co*o$(a:e&$(de" N(eto A Co*o$(a=o$%(*(o No'oa Ce"%ede" A Co*o$(aSa#* R(n)on Ga$oa A B&a"(*Mono$e&o" Co*o$o eneo*ano" S4A C Co*o$(aL#da& Saa'ed&a A Co*o$(a Jo"e Sa#* San)he B E)#ado&M(*ena R('e&a A Co*o$(a Ja($e L(e'ano Ca$a&o A Co*o$(aNe&* <a&(th a%ata D#a&te A Co*o$(a(aHe" Co*on de Co*o$(a S4A A Co*o$(aO$a& Rod&(o =ea RoHa" A Co*o$(aMa&(a de* )a&$en 'e&a A Co*o$(a

 Te"o&e&(a M#n()(%a* ^o&(da C Co*o$(aCa"a (**ea" A Co*o$(a Ja'(e& <e&nande A Co*o$(aCa&*o" A4 Ja($e" M4 D Co*o$(aCa&*o" Ed#a&do S(*'a A Co*o$(aSa(d Ada*a A Co*o$(a Jo"e Anton(o Do$(n#e A Co*o$(a T#&("$o Inte&na)(ona* A Co*o$(a Jo"e :e&&e&a =a&&ado A Co*o$(aMa&(a L4 S#e")#n A Co*o$(aGe)o*"a A Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 52/81

 ;o*anda R(o#eno de )a"tao A B&a"(*Ma")ota" Sa#e"o" A Co*o$(a J#an Ca&*o" R#( C Co*o$(aSe&'(ent&ea Inte&na)(ona* B E)#ado&L(*(ana Ca&o*(na A*'a&e A Co*o$(aE"%e&ana I"aa de =a&&a A Co*o$(aI"ae* Mo&eno A Co*o$(a<&a)o S4A B Co*o$(a

 Jo"e D4 Lo%e De*ado A Co*o$(aSe#&o" Co*%at&(a S4A A Co*o$(aL#(" Sa$#d(o C Co*o$(aG*(d"a ($ena To&&e" C&# B Co*o$(aLa %et(te "o#&)e B B&a"(* J#an =a*o C&# Tae&a D E)#ado&And&e" D(a A Co*o$(aS(*'(a Ca'(de Gona*e A Co*o$(a:#$e&to Ga&)(a A Co*o$(aR()a&do Rod&(#e A Co*o$(aL#(" Ba&&aan Ota*o&a A Co*o$(aIn'4 Ma&?#e B#"to" C(a Ltda A Co*o$(aSa( Te*e$e" E4! C Co*o$(aSe&'(ent&ea S4A A B&a"(*Ma#&()(o D#?#e A Co*o$(aI*$a Mo&eno O)hoa A Co*o$(aAne* de Je"#" Mo"?#e&a A E)#ado&<&an)(")o =e&e anea" B Co*o$(a Te&%e* A Co*o$(aA"ade&o e* Ca&e"te&o A Co*o$(aCo$#n()a)(one" de Santande& Ltda A Co*o$(aMa&tha Gona*e" :e&nande A Co*o$(a Te*e"e&'()(o" A Co*o$(aEda& !"e)he B Co*o$(aM(#e* Anton(o RoHa" 4 B Co*o$(a

=a#*o And&e" Ca()edo A Co*o$(a:#$e&to ](*)he" =(n(**a D Co*o$(aL#(" enned G#t(e&&e =(n(**a D Co*o$(aB*a" Anton(o (**a$(* C Co*o$(aMa&tha ;a$(*e Ga&)(a A Co*o$(aS#" L(a&ao B4 A Co*o$(a Jo"e ()ente Ca#ea" A Co*o$(aMa&a&(ta O&t( A Co*o$(aNe** Co&&ea A Co*o$(aCe"a& =o"ada A B&a"(*And&ea J#*(ana Ga&n()a A4 A Co*o$(aCon)e"(one" CC<CSA B Co*o$(aBe**"o#th Co*o$(a S4A A E)#ado&

=et&o <ood Se&'()e Ltda C Co*o$(a:ee& Na&anHo B Co*o$(a T&an"%o&te" A&($ena A Co*o$(a!n('e&"(dad de *o" **ano" C Co*o$(aL((a Soto Betan)#& A Co*o$(aDe()( =a&&a A'(*a A Co*o$(a()to& A*e&to RoHa" San)he A Co*o$(aCa&*o" En&(?#e San)he =a&ada C Co*o$(aStee* de Co*o$(a S4A B Co*o$(aO$a(&a S(*ena G(* (de" A Co*o$(aR#en Mate#" E)he'e&& D Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 53/81

M#"() Band Ltda B Co*o$(a=anade&(a Co"$o%o*(tana A Co*o$(a J#an =a*o L(e'ano A Co*o$(a=a&&ado Ga&)(a C(a Ltda B Co*o$(aRa/ae* D4 Ja&a$(**o San)he A Co*o$(a=&o'eedo&e" I$%o&ta)(on B B&a"(*Inte&*#)e" Te)n()a" Ltda B B&a"(*Ca&*o" And&e" La&&a&te C Co*o$(a

D("t&(#(do&a =(o L*ano C Co*o$(aMa&(a C4 Boho&?#e A E)#ado&M()&o/e&t("a ]4<4V C(a Ltda A Co*o$(aL#(" A*/on"o A&e'a*o A&ano A Co*o$(a(d&(o" *a $an"(on A Co*o$(aSa(na G#a'(ta de To&&e" A Co*o$(aSe$(**a" a$e&#n Ltda C Co*o$(aIn'e&"(one" (**a*a Ga&)(a A Co*o$(a](n"ton M#&)(a B Co*o$(aMa&tha =e&e Ca"t&o A Co*o$(a Jane& L#)a aa*eta Cont&e&a" A Co*o$(aCo$%a(a A&()o*a de* L*ano A Co*o$(aE*(a" <(e&&o M#&)(a D Co*o$(a J#an Ca&*o" Loano B Co*o$(a Ja($e Med(na R(n)on A Co*o$(a:e)to& Be&na* <aHa&do A Co*o$(a<e&nando Rod&(#e E4! C Co*o$(a Ja&&(n"on R#eda Ca$%o" A Co*o$(a<(de* Ga(tan C Co*o$(a](**(a$ A*e B&a'o B&()eo A B&a"(*<&(" S4A B Co*o$(a:e&nando =e&do$o :e&&e&a B Co*o$(aN(d(a D#ea" A E)#ado& T#*(o Ra$(no G#a)ane$e <o&e&o B Co*o$(a(**a)e* E4! C Co*o$(a

A&aha$ !$aa Lea* A Co*o$(aRa#* Mo&a*e" To&&e" @ <e&&ete&(a G#a'(a&e A Co*o$(a:e&nando e*a D(a A Co*o$(aG*o&(a =at&()(a N(eto =(neda A Co*o$(aC*a&a Ine" A&aon A Co*o$(aSa( C(#dad Ja&d(n A Co*o$(a<*ota *a Ma)a&ena C Co*o$(aCo"ea&o Ltda C Co*o$(aM(&(a$ <o&e&o D Co*o$(a J#an Ja'(e& Mene"e" To&&e" A Co*o$(a Ja'(e& =&(eto A Co*o$(aCa&*o" A*ate A Co*o$(aMa#&()(o Ca*de&on C Co*o$(a

<&an)(")o Ga*'(" =ea A Co*o$(aE*(e)e& (**aona C Co*o$(aA#to"e&'()(o Mo&)e* A B&a"(*A"de)o$ =*#" A Co*o$(aDe*tha) 1 Se#&(dad C Co*o$(aCa&*o" Be*t&an C E)#ado&:ote* Se*e)ta A Co*o$(aN#& Janet e*a"?#e G4 A Co*o$(aAne* Ra$(&o R('a" A Co*o$(aG*o'e&t( G#e&&e&o A Co*o$(aRe"ta#&ante "an Gena&o C Co*o$(a

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 54/81

!&(e* Ca"t(**o A Co*o$(aO*a L#)(a =a&do A Co*o$(aRad(o)o$#n()a)(one" Condo&e" Ltda C Co*o$(a=an %a a Ltda B Co*o$(aMa&(a de* )a&$en A#(*a& A Co*o$(aCo$#n()a)(one" A#de*o E4! C Co*o$(aE"t#d(o" de* **ano *tda D Co*o$(aO$a& And&e" =e&e C Co*o$(a

A*eande& A&ena" R#(o C Co*o$(aS#%e& Ta)o S4A B Co*o$(aA&(*a Ltda B Co*o$(aLet()(a Ca"a**a" A Co*o$(a](**(a$ :e&&e&a =#e&to A B&a"(*

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 55/81

te *a" e$%&e"a" en *at(noa$-&()a4"e )on"t(t#e&on *a" e$%&e"a"4

CIUDAD CAPITAL INICIAL FEC&A DE CON#TITUCI$NMede**n 8100400 Y15Y2005

.#(to 9000400 6Y18Y2005Ca*( 600400 9Y8Y2005Mede**n 100400 8Y22Y2005Mede**n 8100400 9Y11Y2005Mede**n 8700400 Y2Y2005Sao =a*o 5700400 8Y10Y2005Mede**n 5900400 6Y1Y2005B#)a&a$ana 700400 8Y12Y2005Boot 8000400 Y8Y2005Mede**n 11800400 Y27Y2005Mede**n 23300400 Y19Y2005Mede**n 900400 Y17Y2005Mede**n 8500400 Y11Y2005B#)a&a$ana 9000400 6Y25Y2005<*o&(da*an)a 5300400 9Y12Y2005G(ante 7900400 8Y8Y2005Mede**n 10700400 6Y1Y2005Mede**n 1900400 Y1Y2005Sao =a*o 200400 6Y28Y2005Mede**n 15000400 Y13Y2005Boot 600500400 Y18Y2005Mede**n 2800400 8Y5Y2005.#(to 7800400 8Y28Y2005Ca&tao 12500400 9Y2Y2005Mede**n 8700400 6Y23Y2005

Mede**n 8100400 9Y1Y2005Mede**n 16100400 Y15Y2005Boot 6700400 Y16Y2005Ca*( 20500400 9Y1Y2005Mede**n 800400 Y7Y2005Ca*( 10300400 YY2005Mede**n 16000400 Y25Y2005Mede**n 18500400 8Y21Y2005Mede**n 6700400 6Y30Y2005B#)a&a$ana 17000400 Y5Y2005Mede**n 1900400 8Y25Y2005Mede**n 6900400 8Y3Y2005Mede**n 2100400 Y5Y2005

Mede**n 21200400 8Y5Y2005Sao =a*o 3200400 9Y19Y2005Ca*( 17000400 8Y21Y2005Mede**n 30000400 Y1Y2005Ca*( 22600400 6Y18Y2005.#(to 10500400 9Y13Y2005Mede**n 500400 6Y25Y2005B&a"(*(a 18700400 6Y18Y2005Mede**n 10900400 8Y25Y2005Mede**n 8000400 8Y17Y2005G(&on 297700400 6Y26Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 56/81

Mede**n 79900400 Y3Y2005Mede**n 398600400 Y6Y2005Boot 100400 Y9Y2005Mede**n 9600400 Y6Y2005Mede**n 9700400 9Y10Y2005D#(ta$a 5500400 8Y23Y2005Mede**n 7000400 9Y13Y2005Mede**n 16100400 Y29Y2005

Boot 9200400 6Y18Y2005.#(to 73700400 Y15Y2005Mede**n 11900400 6Y20Y2005Sao =a*o 6000400 6Y1Y2005Mede**n 15800400 8Y9Y2005Mede**n 17500400 6Y1Y2005Mede**n 800400 9Y10Y2005.#(to 70000400 6Y29Y2005Ba&&an?#(**a 000400 9Y10Y2005Man(a*e" 200400 Y3Y2005Mede**n 7900400 Y21Y2005Ca*( 150300400 Y29Y2005Mede**n 1600400 9Y10Y2005Ca*( 108000400 Y10Y2005Mede**n 17600400 8Y30Y2005Boot 39000400 8Y10Y2005Mede**n 233200400 Y28Y2005G(ante 18500400 8Y30Y2005Mede**n 92600400 Y1Y2005<*o&(da*an)a 7100400 Y11Y2005B#)a&a$ana 900400 9Y8Y2005Mede**n 300400 Y11Y2005Man(a*e" 2100400 8Y12Y2005Mede**n 12700400 8Y19Y2005Sao =a*o 16000400 9Y17Y2005

Ca*( 23100400 8Y5Y2005Ca*( 500400 Y12Y2005Man(a*e" 117330400 8Y2Y2005.#(to 2800400 9YY2005Ca*( 15500400 9Y18Y2005Mede**n 10600400 9Y1Y2005Ca*( 3000400 Y12Y2005Mede**n 19500400 8Y12Y2005Ca*( 12500400 6Y18Y2005Ca*( 9300400 8Y3Y2005Mede**n 9700400 9Y8Y2005Mede**n 3700400 Y30Y2005Mede**n 7300400 Y17Y2005

<*o&(da*an)a 3800400 8Y7Y2005Man(a*e" 8600400 Y23Y2005Ca*( 55700400 Y3Y2005Boot 8600400 8Y1Y2005Mede**n 1300400 8Y6Y2005=#e*o N#e'o 13300400 Y15Y2005Ca*( 7200400 6Y26Y2005Sao =a*o 8100400 Y13Y2005Man(a*e" 33200400 9Y2Y2005Mede**n 13300400 9Y21Y2005Mede**n 50000400 6Y20Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 57/81

.#(to 6800400 Y29Y2005Boot 16600400 9Y19Y2005Mede**n 5700400 6Y18Y2005Ca*( 13100400 8Y28Y2005Man(a*e" 2200400 9Y1Y2005Boot 6200400 8Y3Y2005Mede**n 8700400 6Y2Y2005Ca*( 8000400 8Y20Y2005

B#)a&a$ana 6900400 Y27Y2005Mede**n 9900400 8Y12Y2005Man(a*e" 2100400 Y23Y2005Ca*( 17000400 6Y30Y2005Ca*( 21700400 Y3Y2005Ca*( 100400 Y1Y2005Mede**n 11500400 9Y21Y2005Mede**n 7800400 6Y18Y2005Boot 8600400 8Y28Y2005Sao =a*o 13000400 Y13Y2005Ca*( 700400 Y5Y2005Mede**n 1200400 9Y3Y2005Mede**n 178990400 Y31Y2005.#(to 3600400 8Y22Y2005Ca*( 80000400 6Y25Y2005Boot 7200400 Y13Y2005Mede**n 1300400 Y30Y2005Mede**n 100000400 Y1Y2005Boot 12500400 6Y20Y2005Mede**n 28900400 6Y29Y2005Mede**n 11900400 Y20Y2005Mede**n 123700400 9Y16Y2005Mede**n 3000400 9Y10Y2005Boot 7500400 Y12Y2005D#(ta$a 13000400 6Y1Y2005

Mede**n 500400 Y3Y2005Boot 13100400 YY2005Mede**n 35500400 Y17Y2005Man(a*e" 9700400 8Y5Y2005Mede**n 2100400 8Y6Y2005Sao =a*o 200400 8Y20Y2005Boot 2500400 Y29Y2005Mede**n 1000400 9Y1Y2005B#)a&a$ana 10700400 6Y18Y2005.#(to 8700400 6Y26Y2005Mede**n 5200400 Y29Y2005Mede**n 1000400 8Y7Y2005Ca*( 5800400 8Y1Y2005

Ca*( 11300400 Y3Y2005

Ca*( 183004006Y22Y2005

Boot 0050400 9Y23Y2005Mede**n 268600400 Y22Y2005Boot 900400 Y1Y2005Mede**n 73000400 9Y22Y2005Mede**n 10500400 Y6Y2005<*o&(da*an)a 25600400 6Y2Y2005Mede**n 60090400 8Y16Y2005Mede**n 10800400 9Y23Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 58/81

Mede**n 3700400 Y7Y2005=#e*o N#e'o 1700400 6Y18Y2005Mede**n 2700400 6Y28Y2005Sao =a*o 000400 9Y11Y2005Mede**n 11500400 Y18Y2005Ca*( 23500400 8Y25Y2005<*o&(da*an)a 30100400 6Y23Y2005.#(to 9500400 8Y22Y2005

Mede**n 8000400 Y13Y2005Mede**n 200000400 8Y15Y2005Mede**n 3500400 Y5Y2005Ca*( 28800400 8Y7Y2005Mede**n 12500400 8Y2Y2005B#)a&a$ana 2800400 Y13Y2005Mede**n 15000400 Y31Y2005Ca*( 20600400 Y8Y2005Boot 5200400 9Y9Y2005Boot 500000400 6Y16Y2005Mede**n 3100400 9Y7Y2005Boot 12100400 8Y28Y2005Boot 5600400 8Y1Y2005Boot 13500400 Y21Y2005Mede**n 798970400 8Y11Y2005B#)a&a$ana 30900400 9Y22Y2005Sao =a*o 5700400 Y10Y2005<o&$o"a 12700400 Y19Y2005Mede**n 1200400 Y26Y2005Mede**n 7600400 8Y9Y2005.#(to 1100400 Y10Y2005Boot 200400 6Y27Y2005Man(a*e" 11000400 6Y27Y2005Mede**n 5300400 Y30Y2005Mede**n 7000400 9Y5Y2005

Mede**n 8100400 6Y30Y2005Boot 11500400 9Y23Y2005Boot 10900400 9Y15Y2005Man(a*e" 10200400 6Y20Y2005Mede**n 10600400 Y5Y2005B#)a&a$ana 3100400 Y20Y2005Mede**n 56700400 9Y8Y2005Mede**n 9600400 6Y19Y2005Mede**n 32900400 6Y21Y2005B#)a&a$ana 7600400 9Y1Y2005Mede**n 70000400 Y22Y2005Mede**n 32700400 Y12Y2005Sao =a*o 70300400 8Y31Y2005

Mede**n 10000400 9Y21Y2005Mede**n 26100400 9Y16Y2005Ca*( 2900400 Y6Y2005.#(to 21300400 Y31Y2005Mede**n 5100400 8Y2Y2005=#e&to Ga(tan 100400 Y2Y2005B#)a&a$ana 2300400 9Y23Y2005Mede**n 25300400 9Y18Y2005Ca*( 800400 9Y23Y2005Boot 16200400 Y1Y2005Mede**n 10500400 9Y9Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 59/81

Mede**n 6900400 Y1Y2005Boot 8500400 8Y22Y2005Man(a*e" 2900400 8Y17Y2005.#(to 16100400 Y12Y2005Mede**n 17100400 Y16Y2005Man(a*e" 7800400 8Y6Y2005Boot 300400 6Y18Y2005Mede**n 12800400 8Y12Y2005

A#a)h()a 70500400 Y1Y2005Sao =a*o 1300400 8Y23Y2005Mede**n 9300400 Y16Y2005Mede**n 70100400 9Y17Y2005Mede**n 5300400 9Y1Y2005

.#(to 13004009Y1Y2005

Mede**n 3100400 9Y19Y2005Mede**n 300400 8Y20Y2005Mede**n 301000400 8Y8Y2005Ca*( 00400 9Y12Y2005Mede**n 3700400 6Y1Y2005Ca*( 300400 Y20Y2005Mede**n 1100400 6Y27Y2005Man(a*e" 21900400 9Y27Y2005Mede**n 65300400 8Y18Y2005Ca*( 17800400 Y9Y2005Mede**n 2500400 8Y2Y2005Ca*( 1500400 Y11Y2005<*o&(da*an)a 600400 8Y23Y2005Mede**n 1300400 Y1Y2005Mede**n 33000400 8Y12Y2005B#)a&a$ana 7000400 8Y9Y2005Sao =a*o 33200400 9Y16Y2005Mede**n 5600400 Y12Y2005

<*o&(da*an)a 126300400 9Y3Y2005Man(a*e" 2900400 Y23Y2005.#(to 8700400 8Y9Y2005Mede**n 5300400 8Y26Y2005Mede**n 21300400 Y29Y2005Boot 9800400 6Y28Y2005Mede**n 18100400 9Y9Y2005Mede**n 3500400 8Y16Y2005Mede**n 200000400 9Y20Y2005Mede**n 83800400 8Y30Y2005Boot 3100400 8Y25Y2005Mede**n 26100400 Y29Y2005<*o&(da*an)a 8300400 8Y17Y2005

Mede**n 2200400 6Y25Y2005Mede**n 2100400 Y8Y2005Mede**n 5300400 Y5Y2005=#e&to Ga(tan 9700400 Y23Y2005Mede**n 100400 Y1Y2005Mede**n 8800400 9Y15Y2005Sao =a*o 20100400 8Y11Y2005Mede**n 11990400 9Y5Y2005Mede**n 11900400 Y6Y2005Ca*( 8500400 8Y21Y2005.#(to 11700400 8Y29Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 60/81

Mede**n 9300400 Y1Y2005Mede**n 6600400 6Y23Y2005Mede**n 1900400 9Y3Y2005Mede**n 9300400 Y30Y2005Mede**n 900400 Y2Y2005Mede**n 100400 8Y11Y2005Ca*( 21800400 8YY2005Ne('a 6300400 Y26Y2005

Boot 7700400 6Y30Y2005Mede**n 5500400 6Y23Y2005Ne('a 2100400 9Y19Y2005Mede**n 10500400 Y5Y2005Boot 5000400 9Y10Y2005Mede**n 2800400 6Y22Y2005Ca*( 272000400 Y2Y2005Boot 16700400 9Y3Y2005Sao =a*o 5300400 Y7Y2005Man(a*e" 80015400 Y25Y2005Mede**n 6900400 8Y21Y2005Ca*( 1900400 6Y21Y2005.#(to 8200400 8Y6Y2005Man(a*e" 13800400 8Y10Y2005Mede**n 92200400 9Y23Y2005Ca*( 21700400 9Y11Y2005Mede**n 6500400 Y3Y2005Mede**n 900400 Y30Y2005Mede**n 17900400 8Y25Y2005Mede**n 8100400 Y31Y2005Mede**n 13200400 Y22Y2005Mede**n 1300400 8Y27Y2005Mede**n 7500400 9Y20Y2005<*o&(da*an)a 2300400 Y16Y2005Boot 6800400 Y15Y2005

Boot 3000400 8Y19Y2005Mede**n 16100400 YY2005Ca*( 900400 Y2Y2005Mede**n 700000400 Y10Y2005Sao =a*o 36300400 6Y19Y2005Boot 7200400 YY2005Mede**n 9000400 8Y30Y2005Mede**n 1600400 8Y3Y2005.#(to 19000400 Y7Y2005Boot 100000400 Y2Y2005.#(to 11900400 8Y9Y2005Boot 7100400 Y16Y2005Mede**n 15600400 Y2Y2005

Mede**n 3600400 8Y20Y2005B#)a&a$ana 11200400 6Y1Y2005Boot 11500400 Y8Y2005Mede**n 52900400 Y22Y2005Boot 9100400 8Y28Y2005Ca*( 28700400 8Y21Y2005Mede**n 1300400 6Y23Y2005Mede**n 6200400 Y5Y2005Mede**n 12600400 YY2005Mede**n 15800400 9Y16Y2005Man(a*e" 300400 9Y6Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 61/81

Mede**n 77500400 9Y17Y2005Sao =a*o 600400 Y19Y2005Mede**n 13300400 8Y2Y2005Mede**n 332700400 8Y31Y2005=#e&to Ga(tan 300400 Y31Y2005.#(to 7200400 9Y10Y2005Mede**n 200400 9Y11Y2005Mede**n 800400 Y16Y2005

Ca*( 18100400 9Y2Y2005Ca*( 85500400 9Y3Y2005Mede**n 1800400 8Y21Y2005Man(a*e" 1000400 Y6Y2005Mede**n 65000400 9Y20Y2005Mede**n 3500400 6Y23Y2005Mede**n 26600400 9Y11Y2005Ca*( 25500400 9Y17Y2005Mede**n 7000400 8Y3Y2005Mede**n 3700400 Y20Y2005Ca*( 5800400 Y16Y2005Ca?#ea 22600400 Y25Y2005Mede**n 1600400 8Y25Y2005Mede**n 17600400 Y26Y2005Sao =a*o 13700400 8Y29Y2005Mede**n 15900400 Y23Y2005Man(a*e" 50000400 Y12Y2005Mede**n 9300400 9Y15Y2005.#(to 0020400 Y2Y2005Mede**n 900400 9Y13Y2005Mede**n 1500400 8Y25Y2005Mede**n 500400 6Y20Y2005Man(a*e" 2600400 8Y25Y2005Mede**n 200000400 Y25Y2005Mede**n 1300400 8Y19Y2005

B#)a&a$ana 156800400 8Y26Y2005Man(a*e" 12700400 Y6Y2005Man(a*e" 2338100400 8Y9Y2005Mede**n 8300400 6Y27Y2005<*o&(da*an)a 11800400 Y27Y2005Boot 76600400 9Y13Y2005Man(a*e" 1700400 Y25Y2005Ca*( 6000400 6Y20Y2005=#e&to Ga(tan 71900400 8Y8Y2005Ca*( 3500400 Y25Y2005Sao =a*o 900400 Y23Y2005Mede**n 8700400 Y13Y2005Mede**n 2200400 8Y18Y2005

Boot 5500400 Y23Y2005.#(to 11500400 Y23Y2005Mede**n 3700400 6Y23Y2005Man(a*e" 9600400 8Y12Y2005Mede**n 15000400 8Y12Y2005B#a 17000400 Y16Y2005Mede**n 6500400 8Y1Y2005Ca*( 9800400 8Y10Y2005Mede**n 23800400 9Y17Y2005<*o&(da*an)a 16600400 9Y3Y2005Boot 19100400 6Y1Y2005

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 62/81

Mede**n 7900400 6Y25Y2005Mede**n 6100400 9Y10Y2005Mede**n 2700400 Y31Y2005=#e&to Ga(tan 19500400 8Y15Y2005Mede**n 28900400 8Y25Y2005Mede**n 1500400 Y11Y2005Man(a*e" 5000400 8Y27Y2005Sao =a*o 3700400 6Y18Y2005

Mede**n 1100400 8Y29Y2005Ca*( 10500400 9Y1Y2005<*o&(da*an)a 9000400 9Y16Y2005.#(to 10600400 Y16Y2005Man(a*e" 8600400 8Y2Y2005Boot @Mede**n 19300400 6YY2007Mede**n 17600400 5Y23Y2007Mede**n 200000400 6Y29Y2007

B#)a&a$ana 2885004007Y25Y2007

Mede**n 12000400 7Y25Y2007Mede**n 2700400 5Y12Y2007Boot 2700400 7Y20Y2007Man(a*e" 8700400 5Y26Y2007Mede**n 9300400 7Y29Y2007Mede**n 50800400 5Y27Y2007Mede**n 300400 5Y11Y2007Mede**n 10700400 5Y19Y2007 ;#$o 3100400 7YY2007Boot 1300400 7Y13Y2007Sao =a*o 9100400 3Y27Y2007.#(to 11600400 7Y18Y2007Mede**n 8500400 7Y10Y2007Mede**n 300400 5Y26Y2007

.#(to 12900400 5Y3Y2007Ca*( 9200400 5Y1Y2007Mede**n 63200400 5Y25Y2007Mede**n 2500400 6Y19Y2007Mede**n 5800400 5Y2Y2007Mede**n 13300400 6Y2Y2007Ca*( 8600400 7Y18Y2007Ca*( 1900400 6Y28Y2007Mede**n 11200400 6Y2Y2007Mede**n 8700400 6Y26Y2007<*o&(da*an)a 10300400 6Y29Y2007Mede**n 10000400 7Y10Y2007Mede**n 0010400 5Y2Y2007

Mede**n 12300400 5YY2007Boot 28300400 7Y26Y2007Ca*( 6100400 5Y2Y2007<*o&(da*an)a 13300400 6Y7Y2007Mede**n 5500400 6Y3Y2007Sao =a*o 5100400 6Y5Y2007Mede**n 600400 6Y13Y2007Man(a*e" 8000400 5Y10Y2007.#(to 19300400 6Y18Y2007Mede**n 200000400 5Y31Y2007B#a 11900400 6Y7Y2007

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 63/81

Ca*( 30500400 7Y29Y2007Man(a*e" 1600400 6Y2Y2007Mede**n 8700400 5Y21Y2007B#)a&a$ana 800400 7Y29Y2007Mede**n 60020400 7Y12Y2007Ca*( 900510400 5Y30Y2007Mede**(n 1200400 6Y29Y2007Mede**n 28900400 5Y23Y2007

Mede**n 16200400 Y1Y2007B#)a&a$ana 35000400 7Y2Y2007Mede**n 2700400 5Y2Y2007Ca*( 500400 7Y23Y2007Mede**n 7000400 7Y1Y2007Mede**n 5200400 5Y26Y2007Mede**n 0000400 6Y30Y2007Sao =a*o 100400 6Y12Y2007Mede**n 10100400 5Y13Y2007Boot 2900400 7Y1Y2007.#(to 1700400 5Y15Y2007Mede**n 8900400 6Y19Y2007Mede**n 9600400 3Y28Y2007Mede**n 17600400 5Y12Y2007Mede**n 17200400 5Y1Y2007Mede**n 500400 6Y21Y2007Mede**n 1700400 6Y12Y2007Mede**n 3200400 7Y19Y2007Man(a*e" 27100400 6Y11Y2007Mede**n 10000400 5Y12Y2007Mede**n 200400 7Y25Y2007Mede**n 152820400 3Y2Y2007Mede**n 101200400 6Y26Y2007Mede**n 5200400 5Y15Y2007B#)a&a$ana 10300400 6Y11Y2007

Boot 20300400 6Y11Y2007Mede**n 6100400 6Y8Y2007Mede**n 1700400 5Y20Y2007Sao =a*o 200400 5Y19Y2007Ba&&an?#(**a 000400 5Y2Y2007Mede**n 35200400 6Y16Y2007.#(to 6600400 7Y13Y2007Mede**n 500000400 6Y26Y2007<*o&(da*an)a 10000400 6Y12Y2007Mede**n 22300400 6Y2Y2007<*o&(da*an)a 19800400 6Y11Y2007Mede**n 656300400 7Y12Y2007Mede**n 300400 5Y2Y2007

<*o&(da*an)a 25500400 5Y23Y2007B#)a&a$ana 7200400 6Y2Y2007Mede**n 11200400 5Y23Y2007B#)a&a$ana 8900400 6Y17Y2007Mede**n 600400 6Y2Y2007Ca*( 2100400 7Y12Y2007Mede**n 1200400 5Y22Y2007Man(a*e" 6800400 7Y23Y2007Mede**n 328300400 5Y19Y2007Ca*( 9800400 3Y25Y2007B#)a&a$ana 121600400 7Y18Y2007

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 64/81

Sao =a*o 10200400 5Y29Y2007Mede**n 1500400 7Y10Y2007Mede**n 19800400 7Y10Y2007.#(to 21300400 6Y22Y2007Mede**n 13000400 5Y29Y2007<*o&(da*an)a 10000400 3Y28Y2007Mede**n 26100400 7Y9Y2007Boot 10700400 6Y8Y2007

Mede**n 27100400 6Y30Y2007Mede**n 1300400 7Y13Y2007Mede**n 000400 5Y30Y2007Mede**n 16900400 3Y30Y2007B&a"(*(a 6100400 5Y22Y2007.#(to 11100400 6Y20Y2007Mede**n 8700400 5Y17Y2007Ca*( 3900400 5Y10Y2007Ca*( 19300400 7Y1Y2007Mede**n 00870400 3Y25Y2007Mede**n 7900400 6Y12Y2007Boot 1900400 7Y6Y2007Mede**n 5900400 7Y1Y2007Sao =a*o 5800400 7Y1Y2007Mede**n 15300400 7Y5Y2007Ca*( 7800400 5Y2Y2007.#(to 6200400 7Y16Y2007Mede**n 2300400 7Y23Y2007B#)a&a$ana 1900400 6Y26Y2007Man(a*e" 7800400 5Y19Y2007B#)a&a$ana 50000400 5Y7Y2007Mede**n 11700400 6Y12Y2007<*o&(da*an)a 5300400 7Y26Y2007Mede**n 26000400 6Y2Y2007Mede**n 5100400 5Y12Y2007

B#a 6900400 5Y1Y2007Mede**n 1600400 5Y1Y2007Mede**n 11600400 5Y20Y2007Mede**n 1000400 7Y3Y2007Ca*( 13500400 7Y11Y2007Mede**n 600400 7Y6Y2007Mede**n 27900400 7Y18Y2007Mede**n 11100400 5Y30Y2007Ca*( 3700400 3Y28Y2007Sao =a*o 600400 5Y28Y2007B#)a&a$ana 100400 7Y25Y2007Man(a*e" 36200400 6Y10Y2007.#(to 17600400 6Y11Y2007

Boot 15900400 5Y29Y2007Ca*( 500400 7Y29Y2007Boot 1100400 5Y8Y2007Mede**n 15100400 3Y28Y2007Mede**n 8000400 6Y8Y2007Mede**n 00400 7Y17Y2007B#)a&a$ana 8100400 6Y11Y2007Mede**n 186700400 5Y2Y2007Boot 1700400 5Y18Y2007R(one&o 2800400 5Y21Y2007Mede**n 113700400 7Y16Y2007

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 65/81

<*o&(da*an)a 3100400 5YY2007Mede**n 1900400 5Y3Y2007<*o&(da*an)a 2600400 5Y20Y2007Mede**n 1700400 6Y18Y2007Mede**n 130900400 7Y26Y2007Sao =a*o 1700400 6Y15Y2007Sao =a*o 230000400 5Y5Y2007Mede**n 2600400 6Y26Y2007

Mede**n 9000400 7Y17Y2007.#(to 3200400 6Y17Y2007Boot 70300400 3Y2Y2007Mede**n 2700400 7Y30Y2007Mede**n 9600400 6Y17Y2007Mede**n 9600400 6Y29Y2007Ca&tao 9800400 5Y9Y2007Ca*( 22900400 7Y1Y2007Mede**n 10200400 7Y12Y2007Mede**n 11800400 3Y28Y2007<*o&(da*an)a 25500400 5Y11Y2007Mede**n 11000400 7Y10Y2007Mede**n 1200400 5Y6Y2007<*o&(da*an)a 200400 3Y23Y2007Mede**n 200500400 6Y13Y2007Mede**n 17000400 7Y26Y2007Man(a*e" 20000400 7Y21Y2007Mede**n 15600400 6Y10Y2007Mede**n 8000400 5Y19Y2007Sao =a*o 28900400 5Y2Y2007Mede**n 2800400 5Y12Y2007Mede**n 2100400 5Y26Y2007.#(to 9700400 5Y7Y2007Ca*( 9500400 5Y11Y2007Mede**n 31700400 3Y31Y2007

Mede**n 83000400 5Y17Y2007Mede**n 10000400 7Y1Y2007Mede**n 8600400 5Y23Y2007Mede**n 900400 5Y26Y2007Mede**n 7200400 6Y20Y2007Boot 7300400 5Y20Y2007Mede**n 2500400 7Y8Y2007Mede**n 33500400 5Y31Y2007Mede**n 60020400 7Y8Y2007Ca*( 5000400 5Y1Y2007Mede**n 17200400 3Y31Y2007Boot 2200400 7Y11Y2007B#)a&a$ana 6200400 3Y30Y2007

Mede**n 9000400 5Y8Y2007Ca*( 38600400 5Y5Y2007Sao =a*o 7500400 5Y20Y2007B#)a&a$ana 300400 6Y17Y2007B#)a&a$ana 5900400 5Y7Y2007.#(to 3000400 6Y20Y2007Mede**n 9100400 5Y19Y2007Mede**n 35800400 6Y22Y2007Mede**n 355200400 5Y2Y2007Mede**n 7900400 6Y30Y2007Boot 100400 5Y13Y2007

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 66/81

=#e&to Ga(tan 1000400 6Y11Y2007B#)a&a$ana 200400 5Y27Y2007Mede**n 100400 5Y9Y2007Boot 51900400 5Y2Y2007B#)a&a$ana 9500400 6Y25Y2007Mede**n 11000400 5Y23Y2007Mede**n 6000400 5Y20Y2007Mede**n 7800400 5Y2Y2007

Mede**n 12900400 6Y9Y2007Boot 18000400 7Y29Y2007Boot 6100400 7Y25Y2007Ca*( 0300400 5Y6Y2007Sao =a*o 3100400 7Y2Y2007

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 67/81

Te3a: Tab.as din3icasLa ta*a de dato" (n/e&(o& &e("t&a dato" de *a %o*a)(+n $#nd(a* en $(*e" de %e&"ona"4D("ea& #na ta*a &)o d(n$()o ?#e $#e"t&e %o& CONTINENTE e* %&o$ed(o de :ABITANTES =OR GNE

CONTINENTE PA4# IDIOMA &OMBRE# MU;ERE#

Q/&()a N(e&(a <&an)-" 57033 57912Q/&()a E(%to <&an)-" 37096 33130Q/&()a Et(o%a In*-" 30659 30736Q/&()a Cono Re%#*()a De$ de* <&an)-" 27907 25732Q/&()a S#d/&()a In*-" 1959 20303Q/&()a Tanan(a Re% !n(da de A*e$n 16251 16571Q/&()a A&e*(a <&an)-" 1555 15199Q/&()a ena In*-" 17805 1777Q/&()a S#dn In*-" 17780 17702Q/&()a Ma&&#e)o" <&an)-" 13976 13920Q/&()a !anda A*e$n 10523 10620Q/&()a Ghana <&an)-" 993 9885

Q/&()a Moa$(?#e In*-" 9525 961Q/&()a Madaa")a& In*-" 692 807Q/&()a Ca$e&Fn <&an)-" 302 390Q/&()a C_te d`I'o(&e <&an)-" 397 133Q/&()a Ano*a In*-" 6168 6310Q/&()a B#&,(na <a"o In*-" 59 5819Q/&()a ($ae A*e$n 523 5806Q/&()a Ma* <&an)-" 5709 5551Q/&()a Ma*a( <&an)-" 527 5366Q/&()a Ne& In*-" 5175 5256Q/&()a So$a*(a In*-" 7801 781Q/&()a TFne <&an)-" 78 7682Q/&()a Senea* In*-" 7608 7632

Q/&()a a$(a In*-" 7739 753Q/&()a Chad <&an)-" 368 31Q/&()a G#(nea E"%ao* 301 3658Q/&()a Randa <&an)-" 352 3663Q/&()a B#&#nd( In*-" 3212 3353Q/&()a Ben(n A*e$n 2926 3011Q/&()a L((a Ja$ah(&(a A&ae <&an)-" 2835 2635Q/&()a S(e&&a Leona In*-" 2315 2702Q/&()a Too In*-" 223 225Q/&()a E&(t&ea <&an)-" 1876 187Q/&()a Cent&oa/&()anaRe%F*()a In*-" 125 1827Q/&()a L(e&(a <&an)-" 171 1759Q/&()a Cono Re%F*()a de* In*-" 1700 1767Q/&()a Ma#&(tan(a <&an)-" 1288 1310Q/&()a Le"otho <&an)-" 1038 100Q/&()a Na$((a In*-" 875 850Q/&()a Bot"ana <&an)-" 87 813Q/&()a Ga$(a <&an)-" 62 671Q/&()a Ga+n In*-" 592 605Q/&()a G#(nea@B(""a# E"%ao* 587 603Q/&()a Ma#&()(o In*-" 53 56Q/&()a Sa(*and(a <&an)-" 72 508Q/&()a Re#n(+n In*-" 338 353

O"e&'a)(+n> !()a& en *a" *a" e* no$&e de* =APS e* TOTAL =APS en *a )o*#$na" e* IDIOMA4

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 68/81

Q/&()a Co$o&a" In*-" 338 338Q/&()a DH(o#t( <&an)-" 308 321Q/&()a G#(nea E)#ato&(a* E"%ao* 218 227Q/&()a Cao e&de E"%ao* 195 223Q/&()a Saha&a O))(denta* <&an)-" 171 173Q/&()a Santo To$- =&(n)(%e E"%ao* 0 0Q/&()a Se)he**e" In*-" 0 0Q/&()a Santa E*ena E"%ao* 0 0

A$-&()a E"tado"!n(do" de A$-&()a In*-" 136128 170091A$-&()a B&a"(* =o&t##-" 8299 87991A$-&()a M-()o E"%ao* 78198 79168A$-&()a Co*o$(a E"%ao* 20538 21026A$-&()a A&ent(na E"%ao* 1970 1863A$-&()a Canad <&an)-" 1527 15583A$-&()a =e&F E"%ao* 12517 1216A$-&()a ene#e*a Re% Bo*(' de E"%ao* 11930 116A$-&()a Ch(*e E"%ao* 735 587A$-&()a E)#ado& E"%ao* 6233 618A$-&()a C#a E"%ao* 5593 556A$-&()a G#ate$a*a E"%ao* 5593 579A$-&()a Do$(n()ana Re%F*()a E"%ao* 7253 7112A$-&()a Bo*('(a E"%ao* 7079 7093A$-&()a :a(t E"%ao* 393 7117A$-&()a :ond#&a" E"%ao* 3183 3132A$-&()a E* Sa*'ado& E"%ao* 3019 3135A$-&()a =a&a#a E"%ao* 202 265A$-&()a N()a&a#a E"%ao* 2755 2783A$-&()a Co"ta R()a E"%ao* 1997 1939A$-&()a =#e&to R()o E"%ao* 1851 1988A$-&()a !&##a E"%ao* 160 106A$-&()a =ana$ E"%ao* 1719 1393A$-&()a Ja$a()a In*-" 120 1291A$-&()a T&(n(dad Taao In*-" 671 67

A$-&()a G#ana In*-" 722 733A$-&()a G#ada*#%e E"%ao* 220 230A$-&()a S#&(na$e In*-" 206 210A$-&()a Ma&t(n()a In*-" 190 202A$-&()a Baha$a" In*-" 178 153A$-&()a Ba&ado" In*-" 130 139A$-&()a Be*()e In*-" 119 116A$-&()a Ant(**a" Nee&*ande"a" A*e$n 107 111A$-&()a G#aana <&an)e"a <&an)-" 0 0A$-&()a Santa L#)a E"%ao* 0 0A$-&()a San ()enteYG&anad(na" E"%ao* 0 0A$-&()a &ene" E4! I"*a" In*-" 0 0A$-&()a G&anada In*-" 0 0

A$-&()a Do$(n()a In*-" 0 0A$-&()a Ant(#a Ba&#da In*-" 0 0A$-&()a Be&$#da" In*-" 0 0A$-&()a G&oen*and(a In*-" 0 0A$-&()a Sa(nt (tt" Ne'(" <&an)-" 0 0A$-&()a Ca($n I"*a" In*-" 0 0A$-&()a &ene" B&(tn()a" I" In*-" 0 0A$-&()a T#&)a" Ca()o" I"*a" <&an)-" 0 0A$-&()a Mont"e&&at In*-" 0 0A$-&()a An#(**a In*-" 0 0A$-&()a San =ed&o M(?#e*+n E"%ao* 0 0

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 69/81

A$-&()a Ma*'(na" b<a*,*and I" In*-" 0 0A"(a Ch(na Ch(no 655632 61875A"(a Ind(a In*-" 515255 782801A"(a Indone"(a In*-" 107703 107852A"(a =a,("tn <&an)-" 8632 3698A"(a Ban*ade"h <&an)-" 65001 6197A"(a Ja%+n Ja%on-" 6199 67508A"(a (et Na$ In*-" 3887 39858

A"(a <(*(%(na" E"%ao* 3558 36896A"(a I&n Re% I"*$()a de In*-" 33886 32910A"(a T#&?#a <&an)-" 33110 32736A"(a Ta(*and(a Ch(no 3037 30782A"(a Co&ea Re%F*()a de In*-" 2373 23072A"(a Man$a& <&an)-" 22726 22633A"(a !e,("tn R#"o 1188 12057A"(a Co&ea Re% =o% De$ In*-" 11882 11820A"(a Ne%a* In*-" 11878 11538A"(a I&a? <&an)-" 11719 11031A"(a A/an("tn <&an)-" 11251 1062A"(a Ma*a"(a Ch(no 11065 1065A"(a A&a(a Sa#d(ta <&an)-" 11566 9333A"(a S&( Lan,a In*-" 922 9712A"(a ;e$en <&an)-" 8809 869A"(a aaH"tn R#"o 91 8352A"(a S(&(a Re%F*()a A&ae <&an)-" 973 82A"(a Ca$oa In*-" 5305 5671A"(a Ae&a(n R#"o 30 392A"(a Ta(,("tn R#"o 3070 3067A"(a I"&ae* In*-" 3026 305A"(a Lao" In*-" 2668 2629A"(a Geo&(a In*-" 2392 2613A"(a Jo&dan(a <&an)-" 2519 2303A"(a (&#("tn R#"o 2289 2380

A"(a T#&,$en("tn R#"o 2169 2215A"(a A&$en(a R#"o 117 1811A"(a S(na%#& In*-" 17 178A"(a Lano In*-" 1582 1657A"(a Mono*(a <&an)-" 1317 130A"(a O$n <&an)-" 1305 1155A"(a E$(&ato" A&ae" !n(do" <&an)-" 1521 86A"(a Bh#tn <&an)-" 1072 1022A"(a #a(t In*-" 991 906A"(a C("Ho&dan(a <&an)-" 830 829A"(a ona de Gaa <&an)-" 577 533A"(a T($o& O&(enta* In*-" 778 723A"(a Ch(%&e <&an)-" 389 390

A"(a Bah&e(n <&an)-" 376 261A"(a .ata& In*-" 385 207A"(a B&#ne( Da&#""a*a$ In*-" 168 153A"(a Ma*d('a" In*-" 173 135E#&o%a <ede&a)(+n de R#"(a R#"o 6882 8368E#&o%a A*e$an(a A*e$n 7019 71980E#&o%a Re(no !n(do In*-" 2897 3002E#&o%a <&an)(a <&an)-" 2805 30181E#&o%a Ita*(a In*-" 2830 29513E#&o%a !)&an(a R#"o 23583 205E#&o%a E"%aa E"%ao* 19383 20250

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 70/81

E#&o%a =o*on(a In*-" 18832 19909E#&o%a R#$an(a <&an)-" 11002 11700E#&o%a =a"e" BaHo" In*-" 90 975E#&o%a ;#o"*a'(a Re% <ed In*-" 5286 5351E#&o%a G&e)(a In*-" 5230 5396E#&o%a B-*()a@L#e$#&o <&an)-" 5181 5398E#&o%a Be*a&F" <&an)-" 7826 5779E#&o%a Che)a Re%F*()a In*-" 799 5266

E#&o%a B-*()a <&an)-" 792 5180E#&o%a :#n&a In*-" 7816 5259E#&o%a =o&t#a* =o&t##-" 750 5123E#&o%a S#e)(a In*-" 7708 7787E#&o%a B#*a&(a In*-" 7031 7279E#&o%a A#"t&(a In*-" 7029 7178E#&o%a S#(a In*-" 3631 317E#&o%a E"*o'a?#(a <&an)-" 2622 259E#&o%a D(na$a&)a In*-" 2612 261E#&o%a <(n*and(a In*-" 2518 267E#&o%a C&oa)(a In*-" 2167 2313E#&o%a No&#ea In*-" 2201 2271E#&o%a Mo*do'a Re%F*()a de <&an)-" 2096 2283E#&o%a Bo"n(a :e&eo'(na <&an)-" 1899 1939E#&o%a I&*anda In*-" 1839 1866E#&o%a L(t#an(a R#"o 138 1977E#&o%a A*an(a In*-" 1592 1521E#&o%a Leton(a R#"o 1086 1303E#&o%a Ma)edon(a La e Re% ;# In*-" 1005 1006E#&o%a E"*o'en(a In*-" 966 1023E#&o%a E"ton(a In*-" 667 78E#&o%a L#e$#&o <&an)-" 209 21E#&o%a Ma*ta In*-" 191 195E#&o%a I"*and(a In*-" 170 139E#&o%a Ando&&a <&an)-" 0 0

E#&o%a <e&oe I"*a" <&an)-" 0 0E#&o%a L(e)hten"te(n In*-" 0 0E#&o%a M+na)o <&an)-" 0 0E#&o%a San Ma&(no <&an)-" 0 0E#&o%a G(&a*ta& In*-" 0 0O)eana A#"t&a*(a In*-" 9288 9713O)eana =a%#a N#e'a G#(nea E"%ao* 2723 229O)eana N#e'a e*and(a <&an)-" 1886 1972O)eana <(H( I"*a" In*-" 710 396O)eana Sa*o$+n I"*a" In*-" 221 209O)eana =o*(ne"(a <&an)e"a <&an)-" 119 112O)eana N#e'a Ca*edon(a In*-" 108 103O)eana an#at# <&an)-" 93 93

O)eana Sa$oa <&an)-" 92 85O)eana G#a$ <&an)-" 8 8O)eana M()&one"(a E"tado" <ed In*-" 0 0O)eana Tona In*-" 0 0O)eana (&(at( <&an)-" 0 0O)eana Ma&(ana" Se%tent I"*a" <&an)-" 0 0O)eana Sa$oa A$e&()ana In*-" 0 0O)eana Ma&"ha** I"*a" <&an)-" 0 0O)eana Coo, I"*a" In*-" 0 0O)eana =a*a# <&an)-" 0 0O)eana ]a**(" <#t#na I"*a" A*e$n 0 0

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 71/81

O)eana Na#&# <&an)-" 0 0O)eana T#'a*# =o&t##-" 0 0O)eana N(#e =o&t##-" 0 0O)eana To,e*a# =o&t##-" 0 0

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 72/81

RO4

RURAL URBANA TOTAL PA4# P9 RURAL

62031 76917 108975 5649736519 3008 622 5743250600 10795 61095 8248235257 15081 50335 040719892 20008 39900 7948523917 888 3292 24931263 18011 307 714720050 9799 29579 64851872 10171 28883 6748912679 15218 286 7543918221 2922 21173 8641812230 778 1968 62415

1192 797 19286 6141711027 772 15796 1417633 060 17693 51495860 6666 17526 574118295 7183 1278 664789535 2081 11616 82409573 3986 11529 6547371 3219 10960 04639050 1591 10671 854058313 208 10700 9493050 2622 962 24893331 6129 9760 354217960 729 9239 53469

5006 390 896 554508 150 758 64575002 235 359 64969 738 235 93495599 568 6565 91435375 2762 593 58453

02 769 571 124833022 1695 71 67403035 178 7513 64253035 687 319 814612103 177 3550 594271577 1386 2930 5240109 16 2867 384301137 1767 2598 734651536 51 210 24901020 65 1695 60418

769 1128 159 2943865 703 1268 68422579 678 119 75486910 2 118 64666 73 1150 5848670 370 980 65431206 785 691 29481

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 73/81

755 220 65 647110 522 629 1401237 20 771 53406165 253 718 394717 20 287 74938 66 177 574132 77 6 724112 7 6 33433

63573 21265 26218 2340032739 135579 16988 1943125126 2239 9365 2548110612 30952 71567 254533988 32589 365 10490099 2358 3085 23401696 18262 25229 2462301 20636 230 124952337 12687 15018 15457757 656 12710 384312512 8678 11160 224516678 7772 11090 594952968 5396 8367 354792935 520 8172 364055318 269 808 65463397 2922 6316 53473307 2850 6157 534692398 2961 5359 7745168 310 7938 354801917 2019 3933 7846

965 287 3839 25417297 3019 3313 848

1200 1611 2811 72469113 1727 2561 77470

371 978 1289 26475

533 322 855 624371 778 779 0422201 217 715 7847321 31 392 543636 265 301 11496

136 133 269 50456126 109 235 5346265 150 215 3042339 135 17 2247195 5 152 6245053 60 113 7649051 73 97 5742658 35 93 6243

21 50 1 2945873 25 68 634270 67 67 0400

10 76 56 148626 13 39 66460 3 3 04008 12 20 704009 16 564259 2 11 81482 1 8 84501 6 17429

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 74/81

0 2 2 0400873136 73091 12710 66411585 28071 998056 149012231 82027 209255 604809667 5556 152331 63452

100839 26109 126978 947326930 9955 126505 2142963223 15782 805 80433

31517 72970 7757 7243326001 7095 6696 3849316997 78552 65576 254937926 12930 60856 845689 39583 76780 17487

3257 12305 75059 246913853 10089 23972 54868890 17812 2302 3451

20687 201 23385 884755309 1171 22750 23465

121 70 21927 84539795 12335 21830 734503106 193 20899 17486

17305 7337 18639 6451100 6781 1788 624976303 9966 16269 3847231 8797 1525 75498877 2798 10975 4183317 7383 69 73406710 199 6107 6428

577 555 6101 84927085 1212 529 4121991 3015 5006 394122 3551 7823 26432810 1859 7669 60418

2395 1989 7387 574631069 2756 3525 304330 3522 3522 0400

37 2889 3236 104290 1650 2620 340273 2023 2760 146378 2079 239 17452

1921 172 2063 9341278 1879 189 2453

738 1222 1660 2643959 1018 10 5478

806 65 81 92457371 738 9 734

79 55 606 840976 577 590 48092 230 322 2845

200 8 28 14973335 113821 17196 224610711 16 8218 12466335 52639 5897 1047

17795 77391 58886 2746218969 3837 5373 3340817166 36792 50658 24968962 3062 39637 22461

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 75/81

13792 25278 3870 374839769 12933 22702 7242168 17078 1535 10427371 6296 1063 704817259 636 10626 70408

31 10262 1059 34002698 56 1027 264263780 682 10262 33491

26 986 10152 242339 6696 1005 33457611 303 987 62450178 705 8892 16422508 51 829 304292895 5281 816 3547122 753 375 3472118 3263 5381 39436

59 7523 5282 1743182 3338 5165 35431910 256 77 724661156 3286 7772 264021995 2387 739 754562198 1670 3838 5421577 2161 305 7146

953 229 3682 25488190 1206 3113 61426

622 168 2390 264033 1238 2011 38477978 1071 1989 746636 1075 1712 2549970 386 726 943938 378 386 948722 256 28 4917 1 5 5433

28 15 73 6541226 33 8490 33 33 04001 25 26 34850 25 25 0400

2863 15838 1801 15431389 806 703 82486

509 3320 3829 13429768 338 806 58406378 82 730 80493100 132 232 734106 137 210 36419

179 36 185 80457

139 38 1 8453100 65 165 6046182 37 116 046957 77 98 5541052 30 82 6347137 70 7 7549532 37 66 7847818 75 63 2845 13 20 354005 17 19 26432

17 0 17 100400

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 76/81

0 11 11 04006 5 11 574551 1 2 504001 0 1 100400

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 77/81

Te3a: Busca! Ob0e/i=o

Co"te" Ho" $en"#a*e" b 89500400=ao" $en"#a*e" de (n'e&"(one" b 5690400

Co"te 'a&(a*e bY'enta" 35Bene)(o e((do bY'enta" 20C(/&a de %&od#))(+n b

Se ?#(e&e )a*)#*a& *a )(/&a +%t($a de %&od#))(+n de #na e$%&e"a4En e* "(#(ente )#ad&o de dato" *a F*t($a *a e" e* )*)#*o de *a %&od#))(+n +%t($a ?#e dee ha)e& #na($%o&te de *a" (n'e&"(one" b)a%(ta* de %&-"ta$o" %o& eHe$%*o ?#e $en"#a*$ente %aa *a e$%&e"a d

Dado ?#e *a e$%&e"a e"t en )&("(" *a )(/&a de %&od#))(+n $ed(a e" tan "+*o de 754000 c.#- )ant(dadEL )*)#*o de *a %&od#))(+n +%t($a "e ot(ene> b)o"te" Ho" $en"#a*e" %ao" $en"#a*e" (n'e&"(one" Y

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 78/81

  $%&e"a ten(endo )o$o )ond()(+n *o" dato"> )o"te" Ho" $en"#a*e")o"te 'a&(a*e e* ene)(o ?#e e* e$%&e"a&(o e(e>

de )o"te" Ho" %#ede %e&$(t(&"e )o$o $($o  b1 @ )o"te 'a&(a*e @ ene)(o e((do

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 79/81

=ROD!CTOS ENSAMBLAR GANANCIA CAR=INTER$e"a" 60 135 2"(**a" 15 2

50tota* de ho&a" 7800ho&a" t&aaHada" 7800

Te3a: #o.=e!La )o$%aa ; e$%*ea 7 )a&%(nte&o" d#&ante 10 da" %a&a en"a$*a& $e"a" "(**"(**a4 =o& *o )o$Fn *o" )*(ente" )o$%&an ent&e 7 6 "(**a" )on )ada $e"a4 La" #t(*(daa* da4

Dete&$(na& *a )ant(dad de $e"a" "(**a" ?#e deen /a&()a&"e en 10 da" %a&a )on

Res/!icciones>Cant(dad de "(**a" e" $n($o 7 'e)e" *a )ant(dad de $e"a" $($o 6 'e)e" *a )an

La $($a )ant(dad de ho&a" d("%on(*e" %a&a *a /a&()a)(+n de $e"a" "(**a" e"t%o& *a" ho&a"4

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 80/81

CANTIDAD !TILIDAD7 570

307 15200

1570

  a"4 Se &e?#(e&en 2 ho&a" %a&a en"a$*a& 1 $e"a 30 $(n#to" %a&a en"a$*a& #nade" "on de 135 %o& $e"a 50 %o& "(**a4 La )o$%aa o%e&a #n t#&no de 8 ho&a"

e#(& ?#e *a #t(*(dad tota* "ea *a $($a %o"(*e4

t(dad de $e"a"4

dada %o& e* nF$e&o de da" *a" ho&a" ?#e "e *ao&an %o& da b$#*t(%*()a& *o" da"

7/18/2019 Johana Excel 2

http://slidepdf.com/reader/full/johana-excel-2 81/81