PY 2015 09 - Calculo y Distribución de Energía

download PY 2015 09 - Calculo y Distribución de Energía

of 20

description

forma de calcular el consumo, costo y distribución de la energia para un negocio que compra y produce energia.esperemos sea de su ayuda.

Transcript of PY 2015 09 - Calculo y Distribución de Energía

Hoja6Ao2015Cantidad en M3.FundoRubroMesHUALTACOLA HUACALOBO ILOBO IIMONTELIMA 01MONTELIMA 02MONTELIMA 03MONTELIMA 04MONTELIMA 05MONTELIMA 06SAN JOSESAN VICENTETotal generalAGUAJan-1584,153790,4462,780,0253,554,573569,376569,177643,447326,361565,686309,86166,1253,733,20013,992,431REALFeb-15118,837807,2932,621,3653,079,967603,593545,898602,819265,882611,788550,57946,0033,049,34612,903,371REALMar-15133,494904,0393,078,1062,966,842655,422703,959621,207162,949705,539759,07358,3533,358,02814,107,011REALApr-1595,483979,6822,361,3841,752,645681,804722,344631,978181,855689,235782,39636,9103,691,81112,607,527REALMay-15162,743986,5592,820,2851,901,410462,987663,015689,995176,441548,246707,38965,0163,732,00112,916,089REALJun-15128,975664,4892,890,1141,820,640381,567484,622474,514199,717555,895684,69438,4122,405,37110,729,010REALJul-15125,605719,6462,997,1632,361,251526,218561,479563,383158,552577,858783,87732,2282,305,10311,712,362REALAug-1544,176766,9002,392,1652,506,833414,085454,554386,706148,743341,529543,04421,8862,602,43210,623,051REALSep-1565,815698,9962,588,7523,193,951644,950670,403587,199198,202512,580874,2925,4722,921,66612,962,278PROYECCIONOct-1549,932898,3242,339,9113,399,471676,388627,744518,628252,775418,912837,76415,7472,924,20812,959,803PROYECCIONNov-1583,845791,2622,071,7533,275,784619,426537,175571,416289,059419,824683,07117,6513,029,24012,389,504PROYECCIONDec-15125,097802,8752,263,1263,199,350593,842657,187621,900308,011349,267461,82020,7463,041,05612,444,277PROYECCIONTotal AGUA1,218,1559,810,51031,204,14833,012,7176,829,6587,197,5566,913,1912,668,5476,296,3597,977,859424,54936,793,463150,346,714Total general1,218,1559,810,51031,204,14833,012,7176,829,6587,197,5566,913,1912,668,5476,296,3597,977,859424,54936,793,463150,346,714

FundoRubroMesHUALTACOLA HUACALOBO ILOBO IIMONTELIMA 01MONTELIMA 02MONTELIMA 03MONTELIMA 04MONTELIMA 05MONTELIMA 06SAN JOSESAN VICENTETotal generalENERGIAJan-1529,491436,4602,033,3602,258,319315,436420,376521,960296,610196,697283,20328,0101,605,1458,425,066REALFeb-1539,024412,9881,888,1411,981,507303,721377,811468,234224,263205,646454,92824,5881,460,8547,841,704REALMar-1542,008429,5872,141,0562,363,904319,793464,399471,921136,600224,141607,95021,1371,637,0808,859,576REALApr-1554,558438,3021,668,9041,814,444389,575448,111361,105103,910372,141447,05221,0901,780,3937,899,583REALMay-1552,846441,1841,904,3741,907,547239,452457,458522,386147,402183,355591,65825,8381,857,0258,330,524REALJun-1550,097332,3521,744,1141,859,080185,638380,273442,982125,114170,249502,64421,2521,229,1477,042,943REALJul-1549,166350,5982,047,8602,122,255290,716409,945454,156131,931224,636630,51215,5521,219,5307,946,857REALAug-153,685359,6841,838,0302,264,705258,097313,979267,979102,791238,789376,35316,6681,393,1337,433,892REALSep-1523,637338,0541,801,2022,653,879345,735466,264446,786155,164202,505664,8732,6111,430,7288,531,437PROYECCIONOct-1517,932434,4541,628,0632,824,647362,588436,594394,612197,887165,499637,0947,5141,431,9738,538,858PROYECCIONNov-1530,112382,6761,441,4842,721,875332,053373,604434,777226,292165,860519,4558,4221,483,4068,120,015PROYECCIONDec-1544,927388,2921,574,6382,658,365318,338457,072473,190241,129137,985351,2009,8991,489,1938,144,228PROYECCIONTotal ENERGIA437,4824,744,63021,711,22627,430,5273,661,1425,005,8855,260,0862,089,0922,487,5026,066,922202,58218,017,60797,114,683Total general437,4824,744,63021,711,22627,430,5273,661,1425,005,8855,260,0862,089,0922,487,5026,066,922202,58218,017,60797,114,683Factor KWH x M3.0.35910.48360.69580.83090.53610.69550.76090.78290.39510.76050.47720.48970.64040.35910.48360.69580.83090.53610.69550.76090.78290.39510.76050.47720.48970.6404

Jan-15294362,0332,258315420522297197283281,6058,425Feb-15394131,8881,982304378468224206455251,4617,842Mar-15424302,1412,364320464472137224608211,6378,860Apr-15554381,6691,814390448361104372447211,7807,900May-15534411,9041,908239457522147183592261,8578,331Jun-15503321,7441,859186380443125170503211,2297,043Jul-15493512,0482,122291410454132225631161,2207,947Aug-1543601,8382,265258314268103239376171,3937,434Sep-15243381,8012,65434646644715520366531,4318,531Oct-15184341,6282,82536343739519816563781,4328,539Nov-15303831,4412,72233237443522616651981,4838,120Dec-15453881,5752,658318457473241138351101,4898,144Total ENERGIA4374,74521,71127,4313,6615,0065,2602,0892,4886,06720318,01897,115Total general4374,74521,71127,4313,6615,0065,2602,0892,4886,06720318,01897,115

CONSUMO ENERGIAMF MLMF SVMF HCMF LB IMF LB IITOTAL

Jan-152,0921,6054362,0332,2588,425REALFeb-152,0981,4614131,8881,9827,842REALMar-152,2881,6374302,1412,3648,860REALApr-152,1981,7804381,6691,8147,900REALMay-152,2201,8574411,9041,9088,331REALJun-151,8781,2293321,7441,8597,043REALJul-152,2071,2203512,0482,1227,947REALAug-151,5781,3933601,8382,2657,434PROYECCIONSep-152,3081,4313381,8012,6548,531PROYECCIONOct-152,2201,4324341,6282,8258,539PROYECCIONNov-152,0911,4833831,4412,7228,120PROYECCIONDec-152,0341,4893881,5752,6588,144PROYECCION25,21118,0184,74521,71127,431segn simulador25,22519,3095,15123,36325,566141,2924061,651-1,864

CONSUMO AGUAMF MLMF SVMF HCMF LBMF LB IItotal

Jan-153,133,9753,733,200790,4462,780,0253,554,57313,992,219REALFeb-153,345,4003,049,346807,2932,621,3653,079,96712,903,371REALMar-153,799,9963,358,028904,0393,078,1062,966,84214,107,011REALApr-153,822,0053,691,811979,6822,361,3841,752,64512,607,527REALMay-153,475,8333,732,001986,5592,820,2851,901,41012,916,089REALJun-152,948,3962,405,371664,4892,890,1141,820,64010,729,010REALJul-153,329,1992,305,103719,6462,997,1632,361,25111,712,362PROYECCIONAug-152,354,7212,602,432766,9002,392,1652,506,83310,623,051PROYECCIONSep-153,558,9132,921,666698,9962,588,7523,193,95112,962,278PROYECCIONOct-153,397,8892,924,208898,3242,339,9113,399,47112,959,803PROYECCIONNov-153,221,4663,029,240791,2622,071,7533,275,78412,389,504PROYECCIONDec-153,137,8703,041,056802,8752,263,1263,199,35012,444,277PROYECCION39,525,66336,793,4639,810,51031,204,14833,012,717150,346,502

HC010.4836LB010.6958LB020.8309HT010.3591ML010.5361ML020.6955ML030.7609ML040.7829ML050.3951ML060.7605SJ010.4772SV010.4897

Hoja2Necesidad EnergiaNecesidad EnergiaNecesidad EnergiaTOTAL NECESIDADPRODUCCIONCOMPRA DECOMPRA ENERGIA TERCEROSENERGIACONSUMO ENERGIA PROPIA1MesAgricolaSucro-BioAdministracinDE ENERGIAENERGIA BIOENERGIA TERCEROSAGRICOLAINDUSTRIALADMINISTRPROPIAAGRICOLAINDUSTRIALADMINISTRJan-15Feb-15Mar-15Apr-15May-15Jun-15Jul-15Aug-15Sep-15Oct-15Nov-15Dec-15

Jan-158,425,0663,828,21587,96912,341,2506,176,0006,165,1974,208,8271,912,42443,9466,176,0544,216,2391,915,79244,023compra terceros sucro-bio1,9121,8031,5911,6811,6591,4091,5971,6191,5781,8941,6061,738Feb-157,841,7043,674,86293,36611,609,9325,913,2645,697,4263,848,2161,803,39145,8185,912,5063,993,4881,871,47047,548compra terceros administr444687503328293072727272Mar-158,859,5762,360,335129,69611,349,6073,702,7777,650,6425,972,1401,591,07587,4263,698,9662,887,437769,26042,269compra terceros agricola4,2093,8485,9725,1703,4732,5443,1253,1523,5153,8073,1773,333Apr-157,899,5832,567,83876,37910,543,8003,649,3016,900,7055,170,1181,680,59849,9883,643,0952,729,465887,24026,3906,1655,6977,6516,9015,1663,9814,7524,8025,1655,7734,8555,143May-158,330,5243,978,78879,95712,389,2697,287,8675,165,6873,473,3991,658,95033,3387,223,5824,857,1252,319,83846,619Jun-157,042,9433,901,29577,40011,021,6377,045,0003,980,9362,543,8601,409,12027,9567,040,7014,499,0832,492,17549,443Jul-157,946,8574,060,79874,39512,082,0497,330,4534,751,7323,125,4081,597,06529,2597,330,3174,821,4482,463,73245,136consumo energia propia agricola4,2163,9932,8872,7294,8574,4994,8214,2825,0164,7324,9434,812Aug-157,433,8923,818,81371,90511,324,6106,546,8594,801,6743,151,9961,619,19030,4886,522,9364,281,8962,199,62341,417consumo energia propia industrial1,9161,8717698872,3202,4922,4642,2002,2522,3542,5002,510Sep-158,531,4373,830,40071,90512,433,7427,268,4615,165,2813,515,1591,578,21871,9057,268,4615,016,2782,252,1820consumo energia propia admin44484226474945410000Oct-158,538,8584,248,00071,90512,858,7637,085,5865,773,1773,807,2181,894,05471,9057,085,5864,731,6402,353,9460consumo energia propia enosa01466440240000Nov-158,120,0154,106,40071,90512,298,3207,443,4574,854,8633,176,5401,606,41971,9057,443,4574,943,4752,499,98106,1765,9133,7033,6497,2887,0457,3306,5477,2687,0867,4437,321Dec-158,144,2284,248,00071,90512,464,1337,321,2655,142,8683,332,6591,738,30371,9057,321,2654,811,5682,509,6970Costo USD Energa Terceros474,915486,141562,395594,071434,806431,478417,068400,925437,809489,334411,498435,90997,114,68344,623,743978,686142,717,11176,770,29166,050,18745,325,54120,088,807635,83976,666,92551,789,14224,534,936342,847USD / MWH Terceros77.0385.3373.5186.0984.17108.3987.7783.5084.7684.7684.7684.7668%31%1%100%54%46%32%14%0%54%36%17%0%

Mesterceros agricolapropia agricolaPrecio Energa USD x MWH1Jan-1549.96%50.04%77.030.03852Feb-1549.07%50.93%85.330.04193Mar-1567.41%32.59%73.510.04964Apr-1565.45%34.55%86.090.05635May-1541.69%58.31%84.170.03516Jun-1536.12%63.88%108.390.03917Jul-1539.33%60.67%87.770.03458Aug-1542.40%57.60%83.500.03549Sep-1541.20%58.80%84.760.034910Oct-1544.59%55.41%84.760.037811Nov-1539.12%60.88%84.760.033212Dec-1540.92%59.08%84.760.0347

Hoja1precioconsumoJan-1577.036,165Feb-1585.335,697Mar-1573.517,651Apr-1586.096,901May-1584.175,166Jun-15108.393,981Jul-1584.115,169Aug-1577.716,111Sep-1579.265,987Oct-1577.446,132Nov-1584.575,748Dec-1584.415,759