Tarea Excel

Sum Sum - SUEL SUELDO DO BASI BASICO CO OCUPACION ABOGADO ADMINISTRADOR ANALISTA AUX,CONTADOR CONTADOR GERENTE SECRETARIA Total Result

SEX SEXO FEMENINO

MASCULINO Total Result 1000   1000   1500 1500 1250

 

300

1500 2000 2000 300

1550

8300

1250  

1500

 

2000

 

2000 600 9850

NRO APELLIDOS Y NOMBRES 1 AGUILAR AMAYA, NELLY 2 CHAVE NEYRA, DIANA 3 ESCOBAR VELASCO DANIEL ! GUTIERRE SANCHE DANIEL 5 LIADIANE ALEXEY " MEA APUY LUIS # NIAMA VAS$UE, %HORDAN & PASSUNI CORI A'IN ( $UINTANA ESPINOA 'ETERENIE 10 RAMOS BURBAN' %AIR 11 SALAAR VILCHES %AC'ELINE 12 VARGAS MAR$UINA RENO

SEXO FEMENINO MASCULINO MASCULINO MASCULINO MASCULINO MASCULINO MASCULINO MASCULINO FEMENINO MASCULINO FEMENINO MASCULINO

ESTADO CIVIL SOLTERO SOLTERO SOLTERO SOLTERO CASADO SOLTERO SOLTERO SOLTERO CASADO CASADO CASADO SOLTERO

NRO DE HI%OS OCUPACION ANALISTA SECRETARIA ADMINISTRADOR ABOGADO 2 GERENTE AUX,CONTADOR CONTADOR AUX,CONTADOR 2 SECRETARIA 3 CONTADOR ! ANALISTA AUX,CONTADOR

CONDICION LABORAL CONTRATADO ESTABLE ESTABLE CONTRATADO ESTABLE ESTABLE ESTABLE CONTRATADO ESTABLE ESTABLE ESTABLE ESTABLE

SUELDO AFILIADO A BASICO AFP 1000 NO 300 NO 1500 SI 1000 SI 2000 SI "50 NO 1000 SI 250 NO 300 SI 1000 NO 250 SI "00 NO

D*+* Sum - T P*.+*//* /*.* Sum - T/4 LCD Sum - 6+ DVD Sum - P/*7 DVD Sum - F/m*84* H & Sum - F/m*84* D9+*/ & Sum - F/m*84* M. DV Sum - DVD H*.87:*m

A)O 2000

2001 2002 2003 200! 2005 1(2330 22"320 11#1!5 1#!#(# 231(12 22013# 1"((#3 1&&!#! 125&(5 1&2### 20#(05 15!!"3 202!!! 212&5" 22"!(3 1"00(& 12&2&3 1&&0(& 2123!( 1"#("3 2&3252 22"25" 2#1#5( 12#531 3#3!"3 1"33&( 21(#(5 255("! 2"0(&2 1(3!&2 1&&(1! 25!503 115252 22(0&1 21501" 1&!"02 330((# 1#2#&1 2("!3! 30(&"1 1"#3(2 1&!3&3 22((!1 2&&5&! 1&2353 2!(!#& 1"1525 133#50

Total Result 1162641 1029487 1118272 1289110 1467075 1187368 1461848 1245631

A)O TRIMESTRE 2000 I 2000 II 2000 III 2000 IV 2001 I 2001 II 2001 III 2001 IV 2002 I 2002 II 2002 III 2002 IV 2003 I 2003 II 2003 III 2003 IV 200! I 200! II 200! III 200! IV 2005 I 2005 II 2005 III 2005 IV

T P*.+*//* /*.* #013# "0#"3 !55&5 15&!5 !&0"& #53& (!3(# #"31# "12( 1(!"" 151(0 #"3"0 &2 10(#( 1&"&# 5##!( 311"1 (330# (550& 11(3" 2(0#3 &#(!3 ##3#3 25#!&

T/4 LCD 3#13( ##"(5 1!(!# !01(2 1&!( 520"( (5(1" 3&"!0 1"255 52!51 330! 53&&5 !5## !("!( 515&! #"("# 5"#(1 (30&& &&"& !(15& !#!#( 10"03 25&3 (3#(&

6+ DVD #15#" "!3"2 1&1&! !&322 # ("0"& 1(25( 10!02 ""#00 52201 #2(#0 3!"22 &102" 31"1! 31((# 15!"1 ""12# 3("03 1(5(! 2(5( 1(!3# 55� (#05# 15#3!

P/*7 DVD F/m*84* H & #"35! 2#&15 (3&! (&#(" 1#"( 111"2 #0#2! &!30& &2&1! (052( "0"31 !(2#& ##&50 ##!! "&(1( #1#!3 "1"2" #13(3 5!##5 &3("5 1(023 2&!"1 2#!#2 525#5

(&23& (5!#1 &22(( (#!55 (#"31 !#0&# &1"& 10503 3(3&! ((!3 �!" &3!22 (11#! #"02# #50(& 13""5 5(#&2 #&115 #53&1 !##0! 5!3(# !2&#! 2#!#3 "&

F/m*84* D9+*/ & 21&25 !"2#5 &"5"" 3!2!& "!2#! "3&5# !&050 #&322 15(10 ## !5(& 1"&"( !33"2 (0#2& "3#5" 31235 !&#"1 (3(1& !!(#" 2#3"1 "033# &##!1 350(0 1!3!

F/m*84* M. DV #3"#2 (31&1 " ##02& 5(021 "&&05 2305( 21&(" #&"13 3#1&1 &1"!0 ((000 &0"50 #0055 #355& &55(& !!25 (5133 33(#& 33&5" (2&12 3220# !&"&2 10"&2

DVD H*.87:*m "30#2 5505# &(13! 22"#& #20#& 5(5"3 &(253 "#"(0 &1&2! &!(3( 1!#(0 &00 (!5!1 31!22 3&350 &51"5 &501( 2&!1" 221!5 25(!5 31!&0 321!0 33"32 3"!(&

TABLA DE PORCENTA%ES Y VALORES CODIGO DE AFP

EMPRESA

CUENTA INDIVIDUAL

SEGINVALID GTOSSEPELIO

1 2 3 !

INTEGRA PRIMA HORIONTE PROFUTURO

1000; 1000; 1000; 1000;

0&&; 0(0; 0&&; 0(&;

COMISION TOTAL VARIABLE DESCUENTO 1&0; 150; 1(5; 1(&;

12"&; 12!0; 12&3; 12(";

C4894 11AB&3MSC 11CO#"FSE 11OP&2MSE 11PR"5MCC 12AD"&FSE 12AN#1FSE 12EM##FSC 12MA"(FCC 12MA#&FSE 12OB#"MCC 12PR&2MSE 13AL#5MSC 13CO#!MCE 13EM#3FSE 13MA#"FCE 13OB#5FSC 13SE&3FCC 1!AB&!FCC 1!AN##MCE 1!EM&3FCE 1!OB"&MSC 1!OP&2MCC 1!SE"5MSC 1!SE&2FCC 15AL"#MSC 15AL#!MSE 15OB#"MCC 15SE#1MCE 15TE#&MCC 1"EM"#FSC 1"OB"#MSC 1"SE"5FSE 1#AB&3MSC 1#EM##FCE 1#PR#5FSC 1&GE&3FCE 1&SE#!MCC 1(TE"5MSC 1(TE"#MSC (AN#"MSC

APELLIDOS O%EDA AMAUT GIL STEFANO 'OHIRA HIGO LINGAN LEON ARATA VARELA VIVES BERNAL ALVA FUERTES GONGORA RUI ACHA LINARES ARRIOLA RIOS GALVE GOME LEON EVALLOS RAMOS BURBAN' FLORES COELLO SALINAS SOLIS URTECHO BRAVO GALVE GUERRA GALVE SANCHE CASTA)EDA POMA MONCADA ARROYO FLORES RAMIRE MONCADA ARROYO URRUTIA RATE FLORES RAMIRE BAASANTES SANT MERINO CARRASCO PACHECO PA%UELO CASTILLO CHAVE %URADO CARRASCO TERRONES DELGADO LLORENTE VILCHE CABRE%OS $UEVEDO NAVARRO RODRIGUE CHIRINOS CHIRINOS DEL VALLE VELASCO MARTTINI RODRIGUE PUMAPILLO TARRILLO PARRAGUE ECHEGARAY BUSTAMANTE GONALES MEA APUY

NOMBRE S:4< A/= L8* A/4. R.@4 '44 A.I*/ O/*.84 D*/m* C.* G. V*/* M** I*/ A/=*.8* E/@*+ A.8* N*+*/ E/@*+ Lu S*.*94 R:*84 %u*. '.. B*. %* A/4.4 I. L4.* S/7 '..7 A/*.8* S+*. T**.* M*/. M*.u/ F.*.84 S+*. M/*94 D94 Au9u+4 R4+4 Au9u+4 A/*4 Em*.u/ R4* C/+ C*/4 S*.*94 %*.F*.:4 %* Lu F/ T*84 Gu+*4 A84/4 N/ %u C/** I*/ C* E.u A.9/* M** S*/*+4 R4m*. M**.9/* '** R*7@* S+*.7 %4*.+ %4 Lu A44. A.8 C*. Lu A.9/

SEXO

OCUPACION

M F M M F F F F F M M M M F F F F F M F M M M F M M M M M F M F M F F F M M M M

ABOGADO CONTADOR>*? OPERADOR PROGRAMADOR>*? ADMINISTRADORA ANALISTA EMPLEADO>*? MAR'ETING MAR'ETING OBRERO>*? PROGRAMADOR>*? ALMACEN CONTADOR>*? EMPLEADO>*? MAR'ETING OBRERO>*? SECRETARIA ABOGADO ANALISTA EMPLEADO>*? OBRERO>*? OPERADOR SERVICIOS SERVICIOS ALMACEN ALMACEN OBRERO>*? SECRETARIA TECNICO EMPLEADO>*? OBRERO>*? SECRETARIA ABOGADO EMPLEADO>*? PROGRAMADOR>*? GERENTE SERVICIOS TECNICO TECNICO ANALISTA

EST CIVIL

NRO HI%OS

COND LABORAL

SALARIO

AFP

CODIGO AFP

S S S C S S S C S C S S C S C S C C C C S C S C S S C C C S S S S C S C C S S S

0 0 0 2 0 0 0 3 0 1 0 0 0 0 1 0 0 1 1 1 0 0 0 0 0 0 0 2 0 0 0 0 0 2 0 1 2 0 0 0

C E E C E E C C E C E C E E E C C C E E C C C C C E C E C C C E C E C E C C C C

2000 2000 #00 1000 3000 2!00 "00 1200 1!00 500 1200 #00 2000 &00 1!00 500 (00 1000 2!00 &00 500 "00 500 500 500 500 500 1000 #00 #00 500 1000 !00 &00 1000 !000 500 2000 #00 2000

S S S N S N N N N N S N N N N N N N S N N N N N N N N S N N N N S S N S N N N N

! 2 3 1

3

!

2

! 3 1

Im4+*:4. CHAVI)A DATOS PERSONALES C4894

A//84 7 N4m

11AB&3MSC O%EDA AMAUT S:4< A/= 11CO#"FSE GIL STEFANO L8* A/4. 11OP&2MSE 'OHIRA HIGO R.@4 '44 11PR"5MCC LINGAN LEON A.I*/ O/*.84 12AD"&FSE ARATA VARELA D*/m* C.* 12AN#1FSE VIVES BERNAL G. V*/* 12EM##FSC ALVA FUERTES M** I*/ A/=*.8* 12MA"(FCC GONGORA RUI E/@*+ A.8* 12MA#&FSE ACHA LINARES N*+*/ E/@*+ 12OB#"MCCARRIOLA RIOS Lu S*.*94 12PR&2MSE GALVE GOME R:*84 %u*. 13AL#5MSC LEON EVALLOS '.. B*. 13CO#!MCE RAMOS BURBAN' %* A/4.4 13EM#3FSE FLORES COELLO I. 13MA#"FCE SALINAS SOLIS L4.* S/7 13OB#5FSC URTECHO BRAVO '..7 A/*.8* 13SE&3FCC GALVE GUERRA S+*. 1!AB&!FCC GALVE SANCHE T**.* M*/. 1!AN##MCE CASTA)EDA POMA M*.u/ F.*.84 1!EM&3FCE MONCADA ARROYO S+*. M/*94 1!OB"&MSC FLORES RAMIRE D94 Au9u+4 1!OP&2MCC MONCADA ARROYO R4+4 Au9u+4 1!SE"5MSC URRUTIA RATE A/*4 Em*.u/ 1!SE&2FCC FLORES RAMIRE R4* C/+ 15AL"#MSC BAASANTES SANT C*/4 S*.*94 15AL#!MSE MERINO CARRASCO %*.F*.:4 %* 15OB#"MCC PACHECO PA%UELO Lu F/ T*84 15SE#1MCE CASTILLO CHAVE Gu+*4 A84/4 15TE#&MCC %URADO CARRASCO N/ %u 1"EM"#FSC TERRONES DELGADO C/** I*/ 1"OB"#MSC LLORENTE VILCHE C* E.u 1"SE"5FSE CABRE%OS $UEVEDO A.9/* M** 1#AB&3MSC NAVARRO RODRIGUE S*/*+4 R4m*. 1#EM##FCE CHIRINOS CHIRINOS M**.9/* 1#PR#5FSC DEL VALLE VELASCO '** R*7@* 1&GE&3FCE MARTTINI RODRIGUE S+*.7 %4*.+ 1&SE#!MCC PUMAPILLO TARRILLO %4 Lu 1(TE"5MSC PARRAGUE ECHEGARAY A44. A.8 1(TE"#MSC BUSTAMANTE GONALES C*.

O:u*:4. ABOGADO CONTADOR>*? OPERADOR PROGRAMADOR>*? ADMINISTRADORA ANALISTA EMPLEADO>*? MAR'ETING MAR'ETING OBRERO>*? PROGRAMADOR>*? ALMACEN CONTADOR>*? EMPLEADO>*? MAR'ETING OBRERO>*? SECRETARIA ABOGADO ANALISTA EMPLEADO>*? OBRERO>*? OPERADOR SERVICIOS SERVICIOS ALMACEN ALMACEN OBRERO>*? SECRETARIA TECNICO EMPLEADO>*? OBRERO>*? SECRETARIA ABOGADO EMPLEADO>*? PROGRAMADOR>*? GERENTE SERVICIOS TECNICO TECNICO

(AN#"MSC MEA APUY Lu A.9/

ANALISTA

PLANILLA DE PAGOS INGRESOS C48 AFP

H* M.u*/ ! 2 3 0 1 0 0 0 0 0 3 0 0 0 0 0 0 0 ! 0 0 0 0 0 0 0 0 2 0 0 0 0 ! 3 0 1 0 0 0

2000 2000 #00 1000 3000 2!00 "00 1200 1!00 500 1200 #00 2000 &00 1!00 500 (00 1000 2!00 &00 500 "00 500 500 500 500 500 1000 #00 #00 500 1000 !00 &00 1000 !000 500 2000 #00

DESCUENTO DEL EMPLEAD

TOTAL I.:.4 A9.*:F G*J:*: *m/* 4. REMUNER 100 100 35 50 150 120 30 "0 #0 25 "0 35 100 !0 #0 25 !5 50 120 !0 25 30 25 25 25 25 25 50 35 35 25 50 20 !0 50 200 25 100 35

0 0 0 &5 0 0 0 &5 0 &5 0 0 0 0 &5 0 0 &5 &5 &5 0 0 0 0 0 0 0 &5 0 0 0 0 0 &5 0 &5 &5 0 0

2000 2000 #00 1000 3000 2!00 "00 1200 1!00 500 1200 #00 2000 &00 1!00 500 (00 1000 2!00 &00 500 "00 500 500 500 500 500 1000 #00 #00 500 1000 !00 &00 1000 !000 500 2000 #00

!100 !100 1!35 2135 "150 !(20 1230 25!5 2� 1110 2!"0 1!35 !100 1"!0 2(55 1025 1&!5 2135 5005 1#25 1025 1230 1025 1025 1025 1025 1025 2135 1!35 1!35 1025 2050 &20 1#25 2050 &2&5 1110 !100 1!35

SNP>13;? 0 0 0 2##55 0 "3(" 15(( 330&5 3#31 1!!3 0 1&"55 533 2132 3&!15 13325 23(&5 2##55 0 22!25 13325 15(( 13325 13325 13325 13325 13325 0 1&"55 1&"55 13325 2""5 0 0 2""5 0 1!!3 533 1&"55

5+* :*+94* !15"25 #1#5 0 3#3"25 #53&"#1&& 5"503125 0 3155!0313 300&&3#&( 0 33"&""25 0 501"53(&3 0 331350#(# 0 0 2!&#& "#((1&&2 0 0 0 0 0 0 0 0 2(55(" 0 0 0 1(#&0222# 0 0 2&0#21 131112"!! 0 5""5"25 0

AFP

0

2000

100

0

2000

!100

533 10#2&"0"!

UIT K

3,!5000

TOTAL DESC

NETO A PAGAR

!15"25 #1#5 0 "511#5 #53&"#1&& 120!"3125 15(( "!"3(0313 !031&&3#( 1!!3 33"&""25 1&"55 103!"53(& 2132 #15500#(# 13325 23(&5 52"33 "#((1&&2 22!25 13325 15(( 13325 13325 13325 13325 13325 2(55(" 1&"55 1&"55 13325 !"!30222# 0 0 5!#221 131112"!! 1!!3 10((5"25 1&"55

3"&!3#5 33&25 1!35 1!&3&25 53("132&1 3#153" 10#01 1&(&"0("( 2!""&11"2 ("5# 2123133#5 12!&!5 30"53!"02 1!2"& 223(!((2 &(1#5 1"0515 1"0&"# !3250&11& 1500#5 &(1#5 10#01 &(1#5 &(1#5 &(1#5 &(1#5 &(1#5 1&3(!0313 12!&!5 12!&!5 &(1#5 15&5"(### &20 1#25 1502##&13 "(#3#" ("5# 3000!3#5 12!&!5

"!02&"0"! 3!5(#13(!