CÁLCULO CANALMIN

4
Ant. Act. Ant. Reac. Act. Act Act. Reac Dif. Act. Dif. Rea En. Act. 8311.67 8843.57 8792.71 9012.73 481.04 169.16 330480 8792.71 9012.73 9005.33 9179.62 212.62 166.89 186043 9005.33 9179.62 9245.13 9290 239.8 110.38 209825 9245.13 9290 9492.67 9458.25 247.54 168.25 216598 9492.62 9458.25 9692.11 9580.5 199.49 122.25 174553.8 Ant. Act. Ant. Reac. Act. Act Act. Reac Dif. Act. Dif. Rea En. Act. 8311.67 8843.57 8792.71 9012.73 481.04 169.16 420910 8792.71 9012.73 8840.2 9040.25 47.49 27.52 41553.75 8840.2 9040.25 9245.13 9290 404.93 249.75 354313.7 9245.13 9290 9492.62 9458.25 247.49 168.25 216554 9492.62 9458.25 9692.11 9580.5 199.49 122.25 174553.8 9692.11 9580.5 9964.88 9941.18 272.77 360.68 238673.7 9964.88 9941.18 10171.2 10059.89 206.27 118.71 180486.3 70 50 276 169 206 119 180250 EMPRESA MINERA PATIÑO MES LEC. ACT. LEC. ANT. DIFER. ENE. ACT. ENE. REAC. RE./AC. ARCTAN. Mar-13 2185.49 1582.45 603.04 274112 67445 0.246 0.24 Apr-13 2695.6 2185.49 510.11 231871 68441 0.295 0.29 May-13 3192.41 2695.6 496.81 225825 57864 0.256 0.25 Jun-13 3656.93 3192.41 464.52 211148 47209 0.224 0.22 Jul-13 4175.67 3656.93 518.74 235793 64850 0.275 0.27 Aug-13 4884.85 4175.67 709.18 322358 113532 0.352 0.34 Sep-13 5514.1 4884.85 629.25 286026 100300 0.351 0.34 Oct-13 5964.48 5514.1 450.38 204720 60150 0.294 0.29 Nov-13 6516.16 5964.48 551.68 250766 78095 0.311 0.30 Dec-13 7030.35 6516.16 514.19 233725 4595 0.020 0.02 Jan-14 7572.64 7030.35 542.29 246498 127273 0.516 0.48 Feb-14 8024.64 7572.64 452.00 205457 104236 0.507 0.47 Mar-14 8616.13 8024.64 591.49 268862 214168 0.797 0.67 0.5755 0.52 0.553 0.5500 -0.0030 483.875 0.48125

description

CÁLCULO DE PRESUPUESTO

Transcript of CÁLCULO CANALMIN

Page 1: CÁLCULO CANALMIN

Ant. Act. Ant. Reac. Act. Act. Act. Reac. Dif. Act. Dif. Reac.En. Act. En. ReacReac./Act.8311.67 8843.57 8792.71 9012.73 481.04 169.16 330480 148015 0.458792.71 9012.73 9005.33 9179.62 212.62 166.89 186043 146029 0.789005.33 9179.62 9245.13 9290 239.8 110.38 209825 96582 0.469245.13 9290 9492.67 9458.25 247.54 168.25 216598 ### 0.689492.62 9458.25 9692.11 9580.5 199.49 122.25 174554 106969 0.61

Ant. Act. Ant. Reac. Act. Act. Act. Reac. Dif. Act. Dif. Reac.En. Act. En. ReacReac./Act.8311.67 8843.57 8792.71 9012.73 481.04 169.16 420910 148015 0.3516547488792.71 9012.73 8840.2 9040.25 47.49 27.52 41553.75 24080 0.579490419

8840.2 9040.25 9245.13 9290 404.93 249.75 354314 218531 0.6167732699245.13 9290 9492.62 9458.25 247.49 168.25 216554 147219 0.6798254479492.62 9458.25 9692.11 9580.5 199.49 122.25 174554 106969 0.6128126729692.11 9580.5 9964.88 9941.18 272.77 360.68 238674 315595 1.3222861759964.88 9941.18 10171.15 10059.89 206.27 118.71 180486 103871 0.57550783

70 50 276 169 206 119 180250 104125 0.577669903EMPRESA MINERA PATIÑO

MES LEC. ACT. LEC. ANT. DIFER. ENE. ACT. ENE. REAC. RE./AC. ARCTAN. F. DE P. M.P.B.F.P

Mar-13 2185.49 1582.45 603.04 274112 67445 0.246 0.24 0.9710 -0.0732

Apr-13 2695.6 2185.49 510.11 231871 68441 0.295 0.29 0.9591 -0.0616

May-13 3192.41 2695.6 496.81 225825 57864 0.256 0.25 0.9687 -0.0709

Jun-13 3656.93 3192.41 464.52 211148 47209 0.224 0.22 0.9759 -0.0778

Jul-13 4175.67 3656.93 518.74 235793 64850 0.275 0.27 0.9642 -0.0666

Aug-13 4884.85 4175.67 709.18 322358 113532 0.352 0.34 0.9432 -0.0458

Sep-13 5514.1 4884.85 629.25 286026 100300 0.351 0.34 0.9437 -0.0463

Oct-13 5964.48 5514.1 450.38 204720 60150 0.294 0.29 0.9594 -0.0620

Nov-13 6516.16 5964.48 551.68 250766 78095 0.311 0.30 0.9548 -0.0574

Dec-13 7030.35 6516.16 514.19 233725 4595 0.020 0.02 0.9998 -0.0998

Jan-14 7572.64 7030.35 542.29 246498 127273 0.516 0.48 0.8885 0.0129

Feb-14 8024.64 7572.64 452.00 205457 104236 0.507 0.47 0.8918 0.0092

Mar-14 8616.13 8024.64 591.49 268862 214168 0.797 0.67 0.7822 0.1506

0.5755 0.52 0.8667 0.0384

0.553 0.5500 -0.0030 483.8750.48125

Page 2: CÁLCULO CANALMIN

F. P. Mult. B. F. Dem. Máx. Pre. Ener. Car. Energ. Prec. Dem. Car. Dem.0.91 0.000 459 0.363 119964.24 69.386 31848.174

0.7866 0.144 459 0.365 67905.51 69.586 31939.971 0.00 459 0.364 76376.30 69.496 31898.664

0.827 0.088 459 0.365 79058.09 69.593 31943.1870.8526 0.056 459 0.365 63712.12 69.676 31981.284

F. P. Mult. B. F. Dem. Máx. Pre. Ener. Car. Energ. Prec. Dem. Car. Dem.0.94 0.000 459 0.363 152790.33 69.386 31848.17

0.8652 0.040 459 0.365 15167.1188 69.586 31939.970.8511 0.057 218 0.364 128970.2 69.496 15150.130.8270 0.088 428 0.365 79042.12 69.593 29785.800.8526 0.056 428 0.365 63712.12 69.68 29821.33

0.85 0.490 459 0.365 87115.92 69.68 31983.12

-11282.2627

Apr-13 6973.34 6710.48 262.86 230003May-13 7205.12 6973.34 231.78 202807Jun-13 7358.22 7205.12 153.1 133963Jul-13 7581.69 7358.22 223.47 195536

Aug-13 7757.96 7581.69 176.27 154236Sep-13 8065.66 7757.96 307.7 269237Oct-13 8311.67 8065.66 246.01 215259Nov-13 8792.71 8311.67 481.04 420910Dec-13 9005.33 8792.71 212.62 186043Jan-14 9245.13 9005.33 239.8 209825Feb-14 9492.67 9245.13 247.54 216598Mar-14 9692.11 9492.62 199.49 174554Apr-14 9964.88 9692.11 272.77 238674

Page 3: CÁLCULO CANALMIN

Alum. Pub. G. Res. Sól. Pre. M. B. F. Total15655.33 1728.75 0 169196.497 noviem. 2013

8861.67 1728.75 14377.78 124813.686 diciem. 20149967.11 1823.93 0 120066.001 ener. 2014

10317.08 1823.93 9768.112156 132910.397 febr. 20148314.43 1823.93 5358.830554 111190.595 marz. 2014

658177.176

Alum. Pub. G. Res. Sól. Pre. M. B. F. Total19939.1381 1728.75 0 206306.392 noviem. 2013

1979.309 1728.75 1894.7374337726 52709.8892 diciem. 201416830.6118 1823.93 8214.86 170989.77 ener. 201410314.9965 1823.93 9576.857202 130543.706 febr. 2014

8314.4315 1823.93 5237.873018 108909.681 marz. 2014 11368.6274 1823.93 58358.5289875 190650.125 abr. 2014

669459.439

154096 0.66997533164526 0.81124219

99741 0.74454418150596 0.77016921123165 0.79854768209335 0.77751056177625 0.82516971148015 0.35165475146029 0.7849228

96582 0.46029787147218 0.67968467106969 0.6128141315595 1.32228618