ࡱ> vw  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuRoot Entry FJrAPWorkbookOle SummaryInformation( Oh+'0`(0 LXLiliana Espinosa@l4K՜.+,0HP X`hp x  EjemploEjemplo de RegistrosSaldosFechaValor Hojas \pLiliana Espinosa Ba==x<8^@"1>Arial1>Arial1>Arial1>Arial1>Verdana1>Verdana10>Verdana10>Verdana1>Arial1>Arial1>Arial1>Arial1 >Arial1>Arial1>Arial"$"\ #,##0;"$"\ \-#,##0!"$"\ #,##0;[Red]"$"\ \-#,##0""$"\ #,##0.00;"$"\ \-#,##0.00'""$"\ #,##0.00;[Red]"$"\ \-#,##0.00=*8_ "$"\ * #,##0_ ;_ "$"\ * \-#,##0_ ;_ "$"\ * "-"_ ;_ @_ .))_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ E,@_ "$"\ * #,##0.00_ ;_ "$"\ * \-#,##0.00_ ;_ "$"\ * "-"??_ ;_ @_ 6+1_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ 0.00_);[Red]\(0.00\) 0.000000!0.000000_);[Red]\(0.000000\)50_(* #,##0.00_);_(* \(#,##0.00\);_(* \-??_);_(@_)0.0000000000000000A<_(* #,##0.000000_);_(* \(#,##0.000000\);_(* \-??????_);_(@_))$#,##0.000000_);[Red]\(#,##0.000000\) dd/mm/yy m/d/yyyy                + ) , *    1    1     H 1 L  L   L         1   1       "     "      x+    "8   (  "<  "<   ,     l   l  l      (  (  h   (   h   ,   h   ,  ,  ,  h  h  (  h  ,  (  ,  ,  ,  ,  , #8   h # #8ww66  (ww66  ,ww66  !8  !8  "8  "8  !8  "|  x+  "8 !8  "< 83ffff̙̙3f3fZZd3f3f33333f33333\`^"Ejemplo&kEjemplo de RegistrosUSaldosFechaValor"Q"tTRANSACCIONES NORMALES VISTA Cod Cont.Cuenta(Transacciones (Tasa 3.5% entre 0 y $100) Saldo Cap (2)21.01.05 Saldo Int (6) 25.01.05 (6)Saldo Int Cont(2)25.01.05Provisin Diaria&CR Provisin: Sal hoy(2) - Sal ayer(2)DB Provisin por CapitalizacinEl saldo de las provisiones se actualizara en linea normalmente con 6 decimales, las transacciones de provisin se grabaran solo a fin de da agrupadas por cdigo contableTRANSACCIONES BACK VALUE DATE$50 al 8 $20 al 10 Rev $50 al 8Saldo Fecha Valor (2)Inters diarioSaldo Inters FV DiferenciaAjuste por fecha valor 25.01.05 Provisin diaria25.01.05 (da)ZEl Saldo de la provisin de hoy es el saldo de ayer + el inters de hoy + el ajuste por FVTRANSACCIONES FUTURE DATE $100 FV 9 25.01.05 (2)NLas provisiones se calculan para todas las categorias que calculan intereses. Si la transaccin se ejecuta en back value se calcula intereses desde esa fecha y se realiza ajustes a la provisin calculada previamente. 8Almacenamiento Normal Sin Transacciones con Fecha ValorTSaldosMonedaCuentaZEn este caso el calculo de provisiones se realiza desde la fecha contable del movimiento. Depsito $100 Retiro $50 Sub Cuenta Categoria Tipo SaldoCodigo ContableEstado de MaduracionEFESALVIGINTACC Valor a Contabilizar DiariamenteTSaldosFechaValor8Almacenamiento Normal Con Transacciones Back Value DateHEl calculo de la provisin se hace desde la fecha valor del movimiento. Depsito $100 Fecha 3Retiro $50 Fecha 6&Diferencial de Acumulados de Provisin4Almacenamiento Normal Con Transacciones Future DateDepsito $100 Fecha 8Retiro $50 Fecha 128Ejemplo con manjeo de saldos en una tabla de 365 campos.DaSaldoInteres ContabilizarA pagar o Cobrar-El interes se calcula sobre el saldo del da.XEl valor a contabiliar es el valor redondeado de hoy menos el valor redondeado de ayer. <El valor a cobrar o pagar es el round(2) del interes dario hsaldo acumulado es la provision no pagada o cobrada hasta ayer valordia * (fhasta  fdesde +1) + ajuste/Ejemplo de manejo de saldos date from date to. Deposito con fecha 5 de enerofdesdefhasta valordiasaldoMonto paratasa Prov total 31/12/2999 diaFormulaAyerHoy"Prov a conr = prov hoy - prov ayer Prov dia 1 Prov dia 2 Prov dia 3 Prov dia 4 Prov dia 5wEl da se obtiene de la fecha a contabilizar menos la fecha desde de la tabla de saldos en moneda de la cuenta mas un 1\La provision a contabilizar se obtiene round(valordia * dias) - roun(valordia * (dias - 1)) MEl valor a cobrar o pagar se obtiene round( ((valordia * dias ) + saldo ),2)sc tmon%Provisones de movimientos fecha valorGDeposito con fecha valor de $100 fcontable 5 enero fecha valor 3 enero Diferencia  0La diferencia a ajustar se calucula diariamente Ediferencia = provision fecha valor - provision en moneda de la cuentaBLa provison de hoy en moneda cuenta = nuevo calculo + diferencia. 4Calculo de intereses con transacciones fecha valor. AjusteMontoHDeposito de $100 con fecha valor 3 de enero, fecha contable 5 de enero. En las transacciones con fecha valor, el monto para tasa siempre se calcula sumando o restando segn sea el caso del grupo de balance. El registro de provision sigue los mismos pasos difinidos para el manejo de saldos en lo corserniente a crear registro y su fechas desde hasta>La provision se calcula sobre el valor del saldo fecha valor. El ajuste se obtiene restando restando la provision fecha valor calculada menos la provision fecha valor actual de la cuenta para cada da hay que tener en cuenta dque puede existir registros intermedio en la tabla de saldos fecha valor y en moneda de la cuenta. QPara contabizar hay que sumar el valor del ajuste para fecha de contabilizacin. !Deposito fcontable 10 fvalor nullDeposito fcontable 10 fvalor 5!Deposito fcontable 20 fvalor nullDiamontotasainteres Acumulado8Ejemplo con manejo de saldos en una tabla de 365 campos.z2 !C4xruO   ^8 lk!Ecc  DR#Bij  dMbP?_*+%&?'?('}'}?)'}'}?" d,, ` `? ` `?U } } I } }  m }  }  } m }  } !mD!!!!!!!!! ! !  !  !!!!!!!!!'!!)!)!)!&!*!,!*   l "&*.26:>BF  ~ R ~  ~ :!Q?  DA"   ~  D4@( LL4@(4@(4@(4@( 4@(  4@(  4@(  4@(  4@( ^@(^@(^@(Q@(p= ׃Q@(p= ׃Q@(  ~ ) DQ?hS_?(#LLQ?hSo?(K~w?(S?(>>?(  K~?(  6h$?(  Sۏ?(  Q?(  >>?(S۟?(<+ ?(5h$?(\(\?(-3JHB{? DQ?h/3JHB? DDQ?h  %\(\ D   ~  (    L S_?(   So?(   K~w?(   S?(   >>?(   K~?(   6h$?(   Sۏ?(   Q?(   >>?(   S۟?(   <+ ?(   5h$?(   \(\?(   3JHB{?(   3JHB?(     % !\(\ D   ~   (   LQ?m  )5k_?(    )5k_?(    )5k_?(    )5k_?(    )5k_?(   )5k_?(   )5k_?(   )5k_?(   )5k_?(   )5k_?(    u+琇?(    u+琇?(    u+琇?(    c~{?(    z|tk{?(    z|tk{?(     ! "  DA "(  ! LALA "(   "{Gz?(   "(   "(   "(   "(   "{Gz?(   "(   "(   "zGz?(   "|Gz?(   "|Gz?(   "xGz?(  % "{Gz? DA- " DADA """"""""""""" D""""""""""""""""""""""""""""""  \(\ D #  $ "" % %   ~ R &&R::!?  D"A" D())))))))))))))))))))))))))))))  ~  "D4@(" LL4@("4@("4@("4@(" 4@("  4@("  4@("  4@("  4@(" ^@("a@("V@("D@("fffffD@(fffffD@( ( )I@  2 )I@  2 )I@  2 )I@ 2( )R)R)R(* ):):):):):): &~ (&( -&4@(&4@(&4@(&4@(&4@(  &4@(  &4@(  &4@(  &D@(  &D@(&V@(&V@(&V@(&D@(&fffffD@(&fffffD@( *~ (*(LQ?h*S_?(*S_?(*S_?(*S_?(*S_?(  *S_?(  *S_?(  *S_?(  *So?(  *So?(*Q?(*Q?(*Q?(*So?(*o?(*o?( %%~ +, D,S_?( LL,So?(,K~w?(,S?(,>>?(  ,K~?(  ,6h$?(  ,Sۏ?(  ,>>?(  ,K~?(,n:m?(,鴁N?(,d/b?(, ` `?(,o?  D!,?  DD ' '(-( LL-(-(-(-(-(  -(  -(  -(  -S_?(  -So?(.NPa꒿(.ݝ((- DD"A(- "DD"A!- " DD"!- # DD"< R3t3ZH7 ">HR~&8FLX !'!!*"!#!$! %! '!(!)!+!.!/!0!1!'2!3!)4!&5!*6!,7!*8!'9!*:!;!<! =! ?! ( /////// !*!(!*>>?!*K~w?!*ݝ " "~ ")" DQ?h"S_?("#"" LLQ?h"So?(""K~w?(""S?("">>?( "" K~?( "" 6h$?( "" Sۏ?( "" Q?( "" >>?("9"0|j? #D" DQ?h>>?9"0Q? #D"DQ?hK~w?:"0\/b? $D"DQ?hݝ/"` `? D"DQ?h-"o? DQ?h/"? D"DQ?h " # #~ ##(#### L#S_?(###So?(###K~w?(###S?(###>>?(# ## K~?(# ## 6h$?(# ## Sۏ?(# ## Q?(# ## >>?(###|j?(###Q?(###\/b?(###` `?(###o?(###?($# # $%$!` ` %D# %  % ~ %% (%%%%LQ?m% )5k_?(%%% )5k_?(%%% )5k_?(%%% )5k_?(%%% )5k_?(% %% )5k_?(% %% )5k_?(% %% )5k_?(% %% )5k_?(% %% )5k_?(%%% u+琇?(%%% c~?(%%% `?(%%% )5ko?(%%% <uo?(%%% <uo?('% ' '!'" ' D"A'"(''!''LALA'"('''"{Gz?('''"('''"(' '' "(' '' "(' '' "{Gz?(' '' "(' '' "('''"Q?('''"|Gz?('''"|Gz('''"(''%'" 'D"A-'"{Gz? )D"AD"A '""""""""""""" D("""""""""""""""""""""""""""""" ) ))` ` 2D$ + ..."//" /% /%% 0 0~ 0R 0~ 0&80&& D1()))))))))))))))))))))))))))))) 2 2~ 22 2D024@(2222 LL24@(2224@(222^@(222^@(2 22 ^@(2 22 ^@(2 22 ^@(2 22 ^@(2 22 ^@(222^@(222^@(222^@(222^@(222^@(222^@(423( 4&~ 4(#4& 4 %23#4&4@ 4 %23#4&4@ 4 %23#4&4@ 4 %23)4&4@ 4%23D0)4&4@ 4 %23D0)4 &4@ 4 %23 D0)4 &4@ 4 %23 D04 &^@(4 4 44  -4 &^@(4 4 4 &^@(44 4&^@(44 4&^@(44 4&^@(44 4&^@(44 4&^@(44 4&^@(54 5*~ 5(5*(5555LQ?h5*S_?(555*S_?(555*S_?(555*S_?(555*S_?(5 55 *S_?(5 55 *S_?(5 55 *K~?(5 55 *K~?(5 55 *K~?(555*K~?(555*K~?(555*K~?(555*K~?(555*K~?(555*K~?(65 6%6%~ 6+6, 6D56,S_?(6666 LL6,So?(666,K~w?(666,S?(666,>>?(6 66 ,K~?(6 66 ,6h$?(6 66 ,|j?(6 66 ,@Pa?(6 66 ,98?(666,2Tvܮ?(666,|j?(666,ͫg?(666,Sd?(666,K~? 6 D5!6,K~? : D6D5 7' 7'(7-(:777 LL7-(:77-(:77-(:77-`<(:77-@<(: 77 -`<(: 77 -@<(: 77 -@<(: 77 -@<(: 77 -@<(:77.@<(:77.<(:7(7- :D6D:A(7- :D6D:A!7- : D6D:!7- ; D6D:8(8 /////// 9*9(9*>>郿9*>>郿9 *>>郿9 *>>郿 : :~ :): 7D2Q?h/:S_? 7D:D2Q?h/:So? 7D:D2Q?h/:K~w? 7D:D2Q?h9:S? 7#D:D2Q?h>>?9:>>? 7#D:D2Q?h>>?9:  K~? 7 #D:D2 Q?h>>?9: h$? 7 #D: D2 Q?h>>?: |j?(7 : #:: LLQ?h: Pa?(7 : : 8?(7 : :0Svܮ?(7: :0|j?(7: :0ͫg?(7: :Rd?(7: -:K~? 7D2Q?h/:K~? 7D:D2Q?h : ; ;~ ;;(;;;; L;S_?(;;;So?(;;;K~w?(;;;S?(;;;>>?(; ;;  K~?(; ;; h$?(; ;; |j?(; ;; Pa?(; ;; 8?(;;;Svܮ?(;;;|j?(;;;ͫg?(;;;Rd?(;;;K~?(;;;K~?(<; ; <%<!Rd =D; =  = ~ == (====LQ?m= )5k_?(=== )5k_?(=== )5k_?(=== u+琇?(=== u+琇?(= == u+琇?(= == u+琇?(= == u+琇?(= == u+琇?(= == u+琇?(=== u+琇?(=== u+琇?(=== u+琇?(=== u+琇?(=== u+琇?(=== u+琇?(?= ? ?!?" ? D:A?"(??!??LALA?"(???"{Gz?(???"(???"(? ?? "(? ?? "(? ?? "zGz?(? ?? "|Gz?(? ?? "|Gz?(???"xGz?(???"Gz?(???"xGz?(???"|Gz?(??%?"{Gz? ?D:A-?"{Gz? AD:AD:A ?""""""""""""" :x&"N't3ZH7"0HR LXj"`lt3Z@!A!C!D@"""""""""""""""""""""""""""""" A AARd \D< C (H7 A >@A @GG 7  ;lDԪ  dMbP?_*+%&?'?('}'}?)'}'}?" d,, ` `? ` `?U } 1} 1} 1} 1}  1}  m2} 2} m2} m 2;;   4 7 ==7;p47 = _2______________________ `2``````````````````````4```````````````````````4```````````````````````4```````````````````````4``````````````````````` a 8aaaaaaaaaaaaaaaaaaaaaaaaa b!8 bbbbbbbbbbbbbbbbbbbbbbbbb c"8 ccccccccccccccccccccccc33 5# 5$ 6 6% 6& 6' 6( 6)~ 66 666666"6&6*6.62666:6>6B6F6J6N6R 88 8* 8+~ 8 8,~ 9 9Y@ D  9Y@ D  9Y@ D  9i@ D d 9i@ D  9i@ D  9i@ D  9b@  D 2 9b@(    L 9b@(   9b@(   9b@(   9b@(   9b@(   9b@(   9b@(   9b@(   9b@(   9b@( :: :- :.~ :' ;,$<? D h<?(LhL<?(  <?(  <?(  <?(  <UUUUUU?(  <?(<?(<?(<?(<333333?(<?(<gfffff?(<?(<?(<533333?(<?(<ifffff?(<?( d/ddddd!>{Gz?  DA>zGz? Z>|Gz?( !LALA >|Gz?(  >Q?(  >Q?(  >|Gz?(  >Q?(>Q?(>xGz?(>Q?(>pGz?(>Q?(>pGz?(>Q?(>Gz?(>Q?(>Gz?(>Q?(>Gz?( b08bbbbbbbbbbbbbbbbbbbbbbbbb 6 6% 6& 6' ee~66 666666"6&6*6.62666:6>6B6F6J6N6R88 8* 8+ ff~ 99Y@ D9Y@  D 9Y@  D 9i@  D d 9i@  D  9i@  D  9i@ D 9b@  D 29b@( L9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(88 8- 8. ff$<? Dh<?(LhL<?(  <?(  <?(  <?(  <UUUUUU?(  <?(<?(<?(<?(<333333?(<?(<gfffff?(<?(<?(<533333?(<?(<ifffff?(<?( a18aaaaaaaaaaaaaaaaaaaaaaaaa b!8bbbbbbbbbbbbbbbbbbbbbbbbb g28ggggggggggggggggggggggggg:33333333333333333333333333  53 54 6 6% 6& 6' 6( 6)~66 666666"6&6*6.62666:6>6B6F6J6N6R88 8* 8+~ 8 8,~ 99Y@ D9Y@  D 9Y@  D 9i@  D d 9i@  D  9i@  D  9i@ D 9b@  D 29b@( L9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(9b@(  :: :- :.~ :' ;,$ <? Dh* <? DhD * <? DhD * <? D hD 4 < =E? D hD P?* <7eRU? D hD * <{͖? D hD * < ? D hD 4 < ? DhD ? <y"?(    LhL <*8 "?(   <U?(   <G]kSU?(   <?(   <{"?(   <*8 "?(   <U?(   <I]kSU?(   <?(   <>HOCD?(( 8DD8888JJJJJJJ>!="=$&7'(+;-./@01234689: !h5!hhhhh!<('!!! LL!<('!!<?(' !! <?(' !! ?^>(' !! <0S(' !! < q(' !! <:('!!?^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>('!!<^>("! "d/"ddddd!">{Gz? " D A">zGz?(""!""LALA">|Gz?(" "" >|Gz?(" "" >Q?(" "" >|Gz?(" "" >Q?(" "" >Q?(""">(""">Q?(""">Gz?(""">Q?(""">Gz?(""">Q?(""">Gz?(""">Q?(""">Gz?(""">Q?(""">pGz?(""">Q?(1" $b08$bbbbbbbbbbbbbbbbbbbbbbbbb &6 &6% &6& &6' &ee~&66 666666"6&6*6.62666:6>6B6F6J6N6R'88 '8* '8+ 'ff~ '9'9Y@ (D''9i@ ( D'd' 9i@ ( D'' 9i@ ( D' ' 9b@ ( D' 2' 9b@(( ' '' L' 9b@(( ' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' '9b@((' (88 (8- (8. (ff$(<? !D'h(<?(!(((LhL(<?(!(( <?(! (( <?(! (( <DDDDDD?(! (( <wwwwww?(! (( <?(! ((<?(!((<?(!((<""""""?(!((<?(!((<VUUUUU?(!((<?(!((<?(!((<$"""""?(!((<?(!((<XUUUUU?(!((<?(!((<FDDDDD?(!( +a68+aaaaaaaaaaaaaaaaaaaaaaaaa -b!8-bbbbbbbbbbbbbbbbbbbbbbbbb .g"8.ggggggggggggggggggggggg33/4444444444 / 57 / 444 /58/44444444444 06 06% 06& 06' 06( 06)~066 666666"6&6*6.62666:6>6B6F6J6N6R188 18* 18+~ 18 18,~ 1919Y@ 1D119Y@ 1 D11 9Y@ 1 D11 9i@ 1 D1 d1 9i@ 1 D1 1 9i@ 1 D1 1 9i@ 1D1 19b@ 1 D1 219b@(1111 L19b@(1119b@(1119b@(1119b@(1119b@(1119b@(1119b@(1119b@(1119b@(1119b@(212:: 2:- 2:.~ 2:' 2;,$2<? 9D9h2<?(9222LhL2<?(9 22 <?(9 22 <UUUUUU?(9 22 <?(9 22 <ݽ?(9 22 <333333?(922<wwwwww?(922<?(922<?(922<?(922<333333?(922<?(922<gfffff?(922<?(922<?(922<533333?(922<?(922<ifffff?(:2 3h53hhhhh3<(:333 LL3<(:33<(: 33 <(: 33 @(: 33 <(: 33 <(: 33 ?(:33@(:33<(:33<(:33?(:33<(:33<(:33<(:33<(:33<(:33<(:33<(:33<(43 4d/4ddddd!4>{Gz? 4 D2A4>zGz?(44!44LALA4>|Gz?(4 44 >|Gz?(4 44 >xGz?(4 44 >|Gz?(4 44 >xGz?(4 44 >Q?(444>Q?(444>|Gz?(444>Q?(444>Q?(444>pGz?(444>Q?(444>pGz?(444>Q?(444>Gz?(444>Q?(444>Gz?(444>Q?(\4 6b086bbbbbbbbbbbbbbbbbbbbbbbbb 86 86% 86& 86' 8ee~866 666666"6&6*6.62666:6>6B6F6J6N6R988 98* 98+ 9ff~ 9999Y@(2999 L99Y@(299 9Y@(2 99 9Y@(2 99 9Y@(2 99 9Y@(2 99 9i@ 2 D9 d99i@ 2D9 99i@ 2D999i@ 2D999b@ 2 D9299b@(2999L99b@(2999b@(2999b@(2999b@(2999b@(2999b@(2999b@(29:88 :8- :8. :ff$:<? 3D9h:<?(3:::LhL:<?(3:: <?(3 :: <UUUUUU?(3 :: <?(3 :: <ݽ?(3 :: <333333?(3 ::<wwwwww?(3::<?(3::<?(3::<?(3::<333333?(3::<?(3::<gfffff?(3::<?(3::<?(3::<533333?(3::<?(3::<ifffff?(3:*T!hJJJJjJ$  if 4 >@ GG 9:33446688'(++--..!!""$$&&   7  ]I>  dMbP?_*+%&?'?('}'}?)'}'}?" d,, ` `? ` `?U } m A} IA}  A} m A}  A} m A} I A} m A]                                 BsCCCCCCCCCCC C D:<DD DEEEEE"E& C F;<FFFFF"FFFG C F<$H?DhH? LhLH?H?H?Hݽ?H?  H333333?  HUUUUUU?C G=!H{Gz? DAHzGz?! LALAH|Gz?H|Gz?HQ?HxGz?HGz?  HxGz?  HGz?C I>J{Gz? LAJQ?J?JQ?J?JQ?Jp= ף?  J333333?  J(\?CCCCCCCCCCC C I?CCCCCCCCC  C C@ CCCCCCCCC  C IA CCCKKCLCC  C IB CCCKKCLCC  CCCCCKKCLCC  C MC CCCCCCCCC CCCCCCCCCCC C NDCCCCCCCCC CN OE OF OG PH PIO PJ  CC CCQ\QZ$H?DhRRR!S? DD  CC CC~ Q^ QK$H?DhT? D~ R"R!S? DD  CC CCUUJVCCWCC CCCC XL CCC XM  XN  XO  AP CC CQH?D~ C!W{Gz? DA CC!L{Gz? DA~  C' W{Gz? DDA! Y{Gz? D D  CC CRH?D~ C !W{Gz? DA CC>CzGz? (DDADDA, W{Gz? DDA' WQ? DDA! YzGz? D D  CC CSH?D~ C!W{Gz? DA KC>C|Gz? (DDADDA, WQ? DDA' W? DDA! Y|Gz? D D  CC CTH?D~ N!W{Gz? DA KC>C|Gz? (DDADDA, W? DDA' WQ? DDA! Y|Gz? D D  CC CUW?D~ N!WQ? DA KC>CQ? (DDADDA, W DDA' WQ? DDA! YQ? D D CCCCC#W)\(? % CC#W? %  CC # Y?& % C CVCCCCCCCCC C CWCCCCCCCCC C CXCCCCCCCCC CCCCCCCCCCC CCCCCCCCC  CY CDl XXZZH 4444 4 4z h>>>>444  ! " # $ % & ' ( + , - . / 1 2 3 5 6 7 8 9 ; < = > ?  C ZZ CCCCCCCCC !CCCCCCCCCCC "C "B9#CCCCCCCCCCC $D:<$DD DEEEEE"E& %F;<%FFFFF"FFFG &F<$&H?&D%h&H?&&&& LhL&H?&&&H?&&&H?&&&Hݽ?&&&H?& && H333333?& && HUUUUUU?'& 'G=!'H{Gz?' D&A'HzGz?''!'' LALA'H|Gz?'''H|Gz?'''HQ?'''HxGz?'''HGz?' '' HxGz?' '' HGz?(' (I>(J{Gz?(((( LA(JQ?(((J?(((JQ?(((J?(((JQ?(((Jp= ף?( (( J333333?( (( J(\?.( +I[ ,D:<,DD DEEEEE"E& -F;<-FFF"F"F"FFFG .F<$.H?.D-h.H?.... LhL.H?...H?...H?...H333333?...HUUUUUU?. .. Hwwwwww?. .. H?/. /G\/H//// LL/H///H?///H?///H?///H?///H?/ // H?/ // H?8/ / A] 1I^ 2I_ 3I` 5Ma 6ND6CCCCCCC7N 7OE 7OF 7OG 7PH 7Pb 7Oc 7PJ8C~ 8Q^ 8QK$8H?8D8h8RRR"!8S?9 D8D89C9Q]Qb^$9H?9D9h9RRR!9S?I D9D9 ;Ad <Ae =Af >Ng ?Nh: 4  NNPP>NNPL&l@ B F G H I J K L M N O PQRSTUVWXYZ[\ @Ni BAj FAk FAl GAm GAm H[n H[o H[p H[q H[r H\n H\o H \p H \q H \r H \bIA*ABA/IYUUUUUU?III\LLIYUUUUUU?I DII]*]B]/ I ^UUUUUU?I I I\ LLI ^UUUUUU?I DI I ^?J DI JA&@JJJ\ LJABA/JYUUUUUU?JIJYUUUUUU?JJJR LLJ]&@J JJ\ LJ]B]/ J ^UUUUUU?J I J ^UUUUUU?KJ JR LLJ ^KA(@KJKABA/KYUUUUUU?KIKY?KJK](@K JK]B]/ K ^UUUUUU?K I K ^?LJ K ^LA*@LJLABA/LYUUUUUU?LILYUUUUUU?LJL]*@L JL]B]/ L ^UUUUUU?L I L ^UUUUUU?MJ L ^MA,@MJMABA/MYUUUUUU?MIMY?MJM],@M JM]B]/ M ^UUUUUU?M I M ^?NJ M ^NA.@NJNABA/NYUUUUUU?NINY?NJN].@N JN]B]/ N ^UUUUUU?N I N ^?OJ N ^OA0@OJOABA/OYUUUUUU?OIOY?OJO]0@O JO]B]/ O ^UUUUUU?O I O ^?PJ O ^PA1@PJPABA/PYUUUUUU?PIPYUUUUUU?PJP]1@P JP]B]/ P ^UUUUUU?P I P ^UUUUUU?QJ P ^QA2@QJQABA/QYUUUUUU?QIQY?QJQ]2@Q JQ]B]/ Q ^UUUUUU?Q I Q ^?RJ Q ^RA3@RJRABA/RYUUUUUU?RIRY?RJR]3@R JR]B]/ R ^UUUUUU?R I R ^?R J R ^!R Y? S DR DI SA4@SJSA>ASYqq?SISYS]4@S JS]>] S ^qq?TI S ^^ TA5@TJTA>ATYqq?TITYT]5@T JT]>] T ^qq?UI T ^^ UA6@UJUA>AUYqq?UIUYU]6@U JU]>] U ^qq?VI U ^^ VA7@VJVA>AVYqq?VIVYV]7@V JV]>] V ^qq?WI V ^^ WA8@WJWA>AWYqq?WIWYW]8@W JW]>] W ^qq?XI W ^^ XA9@XJXA>AXYqq?XIXYX]9@X JX]>] X ^qq?YI X ^^ YA:@YJYA>AYYqq?YIYYY]:@Y JY]>] Y ^qq?ZI Y ^^ ZA;@ZJZA>AZYqq?ZIZYZ];@Z JZ]>] Z ^qq?[I Z ^^ [A<@[J[A>A[Yqq?[I[Y[]<@[ J[]>] [ ^qq?\I [ ^^ \A=@\J\A>A\Yqq?\I\Y\]=@\ J\]>] \ ^qq?'iI \ ^^ 6hP ^ 'i>@ 7 DocumentSummaryInformation8CompObj mde clculo F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q