Page 8 - Graficas Diarias
P. 8

7,000  Aguazul Enr
    Categoria  09#Aguazul Enr                                    Aguazul Enr
    Descripcion  1   2   3   4   5   6   7   8   9   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   MTD   AVGTD   TTL   PY
    PPTO   6,000                   4,684                   5,894                   5,604                   4,331                   3,159                   3,080                   4,186                   4,125                   4,511                   3,773                   3,422                   3,622                   5,259                   4,325                   4,827                   3,669                   3,297                   2,846                   3,904                   3,721                   3,158                   2,963                   3,193                   3,505                   6,114
    2018                   3,368                   4,823                   5,021                   3,704                   2,554                   2,689                   4,264                   4,239                   3,953                   3,974                   3,896                   4,443                   5,211                   4,122                   4,282                   3,864                   3,332                   3,782                   4,610                   4,709                   4,039                   4,374                        89,253               4,057                    89,253
    2017                   4,429                   5,573                   5,299                   4,096                   2,988                   2,912                   3,958                   3,901                   4,266                   3,568                   3,236                   3,425                   4,973                   4,090                   4,565                   3,469                   3,118                   2,692                   3,692                   3,518                   2,986                   2,802                   3,020                   3,314                   5,781
    Var   5,000  -             1,061   -                751  -                278  -                392  -                433  -                223                  305                  338  -                313                  406                  660               4,443                1,786   -                851                  192  -                700  -                137                  664               1,919                1,018                   521               1,388   -             2,802   -             3,020   -             3,314   -             5,781                       8,501                  212  -
    Var%   -24%  -13%  -5%  -10%  -15%  -8%  8%  9%  -7%  11%  20%  #DIV/0!  52%  -17%  5%  -15%  -4%  21%  71%  28%  15%  46%  -100%  -100%  -100%  -100%  11%  6%  -7%  11%
       4,000
       3,000
       2,000
                                                                                                                             PPTO
                                                                                                                             2018
       1,000
                                                                                                                             2017
        -
          1    2    3   4    5    6    7   8    9    10  11   12   13   14  15   16   17   18  19   20   21   22  23   24   25   26
         lun-01  mar-02  mié-03  jue-04  vie-05  lun-08  mar-09  mié-10  jue-11  vie-12  sáb-13  lun-15  mar-16  mié-17  jue-18  vie-19  sáb-20  lun-22  mar-23  mié-24  jue-25  vie-26  sáb-27  lun-29  mar-30  mié-31
    Dia Habil  1   2   3   4   5   6   7   8    9    10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   MTD   AVGTD   TTL   PY OCT
    PPTO                 4,684                 5,894                 5,604                 4,331                 3,159                 3,080                 4,186                 4,125                 4,511                 3,773                 3,422                 3,622                 5,259                 4,325                 4,827                 3,669                 3,297                 2,846                 3,904                 3,721                 3,158                 2,963                 3,193                 3,505                 6,114                      85,397              4,067               101,173
    2018                 3,368                 4,823                 5,021                 3,704                 2,554                 2,689                 4,264                 4,239                 3,953                 3,974                 3,896                 4,443                 5,211                 4,122                 4,282                 3,864                 3,332                 3,782                 4,610                 4,709                 4,039                 4,374  #N/A  #N/A                      89,253              4,057                 89,253                    105,481
    2017                 4,429                 5,573                 5,299                 4,096                 2,988                 2,912                 3,958                 3,901                 4,266                 3,568                 3,236                 3,425                 4,973                 4,090                 4,565                 3,469                 3,118                 2,692                 3,692                 3,518                 2,986                 2,802                 3,020                 3,314                 5,781                      80,752              3,845                 95,669
    Var  -          1,061   -              751  -              278  -              392  -              433  -              223                305                338  -              313                406                660             4,443             1,786  -              851                192  -              700  -              137                664             1,919             1,018                521             1,388                    8,501                 212  -                 6,416                    9,812
    Var%  -23.9%  -13.5%  -5.3%  -9.6%  -14.5%  -7.7%  7.7%  8.7%  -7.3%  11.4%  20.4%  #DIV/0!  52.1%  -17.1%  4.7%  -15.3%  -4.0%  21.3%  71.3%  27.6%  14.8%  46.5%  10.5%  5.5%  -6.7%  10.3%
    %Ppto  -28.1%  -18.2%  -10.4%  -14.5%  -19.2%  -12.7%  1.9%  2.8%  -12.4%  5.3%  13.8%  #DIV/0!  43.9%  -21.6%  -1.0%  -19.9%  -9.2%  14.7%  62.0%  20.6%  8.6%  38.5%  4.5%  4.3%
                                                                                                        MTD 18              89,253
                                                                                                        MTD 17              80,752
                                                                                                        VAR              8,501
    Mensual                                                                                             % MTD  10.5%
                                            Aguazul Enr
     160,000
     140,000
     120,000
     100,000
     80,000
     60,000
     40,000
     20,000
      -
         ENE    FEB    MAR    ABR     MAY    JUN    JUL    AGO    SEP     OCT    NOV    DIC
                                            PPTO  2018  2017
            1    2        3    4         5    6        7    8        9    10       11   12
    DESCRIPCION  ENE  FEB  I BIM  MAR  ABR  II BIM  MAY  JUN  III BIM  JUL  AGO  IV BIM  SEP  OCT  V BIM  NOV  DIC  VI BIM  YTD
     PPTO                 90,638                 95,570              186,208               115,721               133,688              249,409               137,568               126,765              264,333               120,398               124,478              244,876               136,000               101,173                 95,000               102,999            1,080,827
     2018                 79,421                 92,841              172,262               143,698               122,925              266,623               135,296               125,641              260,937               132,372               130,684              263,056               136,175  #N/A  #N/A  #N/A            1,099,053
     2017                 84,267                 90,571              174,838               108,772               126,423              235,195               130,542               120,218              250,760               113,687               117,790              231,477               135,994                 95,669                 88,913                 71,118            1,028,264
     Var  -            4,846                2,270   -            2,576              34,926   -            3,498             31,428                4,754                5,423             10,177              18,685              12,894             31,579                   181  7078904%
     % AA  -5.8%  2.5%  -1.5%  32.1%  -2.8%  13.4%  3.6%  4.5%  4.1%  16.4%  10.9%  13.6%  0.1%   7%
     % PPTO  -12.4%  -2.9%  -7.5%  24.2%  -8.1%  6.9%  -1.7%  -0.9%  -1.3%  9.9%  5.0%  7.4%  0.1%  2%
                                                                  ACUM SEP
                                                         PPTO             1,080,827
                                                         2018             1,099,053
                                                         2017             1,028,264
                                                          Var                  70,789
                                                         % AA      6.9%
                                                         % PPTO    1.7%
   3   4   5   6   7   8   9   10   11   12   13