#VALUE!

Se realizó el calculo de la siguiente formula para definir cargos por demandas maximas de potencias
 totales kw

totales a pagar

inyecciones mensuales

kw/h

total generado$

total a pagar ala compañía despues de inyecciones

 totales kw

totales a pagar

inyecciones mensuales
kw/h

total generado

total a pagar ala compañía despues de la inyeccion

 2875.56 2839.2 2813.25
enero febrero marzo
684.73 684.73 684.73
0.508 0.508 0.508
22110.18084 21830.6088 21631.07925
0 0 0
0 0 0
13080.92244 12915.5208 12797.47425
1570.05576 1550.2032 1536.0345
36761.15904 36296.3328 35964.588

226864.43064 223995.8448 221948.5455

45077.27856 44507.2992 44100.507

52616.99688 51951.6816 51476.8485

324558.70608 320454.8256 317525.901

enero febrero marzo

723324.96824 714187.5548 707666.216

enero febrero marzo

1899.23341121296 1700.07889666925 1774.05134496356

151938.672897037 136006.31173354 141924.107597085

571386,295 578181,2431 565742,108402915

 2875.56 2839.2 2813.25
enero febrero marzo
745.12 745.12 745.12
1460.78448 1442.3136 1429.131
22110.18084 21830.6088 21631.07925
0 0 0
0 0 0
13080.92244 12915.5208 12797.47425
1570.05576 1550.2032 1536.0345
36761.15904 36296.3328 35964.588

226864.43064 223995.8448 221948.5455

45881400.1584 45301253.088 44887204.23

pp pp pp
enero febrero marzo

46183992.8116 45600029.032 45183256.2025

enero febrero marzo

1899.23341121296 1700.07889666925 1774.05134496356

151938.672897037 136006.31173354 141924.107597085

46032054,138703 45464022,7202665 45041332,0949029

 2625.3 2538.9 2548.5
abril mayo junio
684.73 684.73 684.73
0.508 0.508 0.508
20185.9317 19521.6021 19595.4165
0 0 0
0 0 0
11942.4897 11549.4561 11593.1265
1433.4138 1386.2394 1391.481
33561.8352 32457.2976 32580.024

207120.4182 200303.9766 201061.359

41154.2028 39799.7964 39950.286

48037.7394 46456.7922 46632.453

296312.3604 286560.5652 287644.098

abril mayo junio

660433.6292 638720.9636 641133.482

abril mayo junio

1420.11753443965 1076.64526403597 886.712757977301

113609.402755172 86131.6211228778 70937.0206381841

546824,226444829 552589,342477122 570196,461361816

 2625.3 2538.9 2548.5
abril mayo junio
745.12 745.12 745.12
1333.6524 1289.7612 1294.638
20185.9317 19521.6021 19595.4165
0 0 0
0 0 0
11942.4897 11549.4561 11593.1265
1433.4138 1386.2394 1391.481
33561.8352 32457.2976 32580.024

207120.4182 200303.9766 201061.359

41888341.692 40509774.396 40662948.54

pp pp pp
abril mayo junio

42164664.553 40777027.849 40931209.705

abril mayo junio

1420.11753443965 1076.64526403597 886.712757977301

113609.402755172 86131.6211228778 70937.0206381841

42051055,1502448 40690896,2278771 40860272,6843618

 2537.35 2866.57 2790.3
julio agosto septiembre
684.73 684.73 684.73
0.508 0.508 0.508
19509.68415 22041.05673 21454.6167
0 0 0
0 0 0
11542.40515 13040.02693 12693.0747
1385.3931 1565.14722 1523.5038
32437.4824 36646.23088 35671.1952

200181.6909 226155.17358 220137.9282

39775.4986 44936.35132 43740.7428

46428.4303 52452.49786 51056.9094

286385.6198 323544.02276 314935.5804

julio agosto septiembre

638331.4424 721065.74528 701898.7892

julio agosto septiembre

949.128293056726 1049.78996302692 1286.41644409525

75930.2634445381 83983.1970421535 102913.31552762

562401,178955462 637082,548237847 598985,47367238

 2537.35 2866.57 2790.3
julio agosto septiembre
745.12 745.12 745.12
1288.9738 1456.21756 1417.4724
19509.68415 22041.05673 21454.6167
0 0 0
0 0 0
11542.40515 13040.02693 12693.0747
1385.3931 1565.14722 1523.5038
32437.4824 36646.23088 35671.1952

200181.6909 226155.17358 220137.9282

40485043.154 45737958.9548 44521022.292

pp pp pp
julio agosto septiembre

40752133.9035 46039607.9277 44814665.203

julio agosto septiembre

949.128293056726 1049.78996302692 1286.41644409525

75930.2634445381 83983.1970421535 102913.31552762

40676203,6400555 45955624,7306579 44711751,8874724

 2583.106 2351.7 2801.16
octubre noviembre diciembre
684.73 684.73 684.73
0.508 0.508 0.508
19861.502034 18082.2213 21538.11924
0 0 0
0 0 0
11750.549194 10697.8833 12742.47684
1410.375876 1284.0282 1529.43336
33022.427104 30064.1328 35810.02944

203791.564764 185535.0198 220994.71704

40492.769656 36865.2492 43910.98416

47265.673588 43031.4066 51255.62568

291550.008008 265431.6756 316161.32688

octubre noviembre diciembre

649830.108224 591676.8548 704627.95064

octubre noviembre diciembre

1523.84116712404 1730.64293002643 1895.08358907925

121907.293369923 138451.434402114 151606.68712634

527922,814854077 453225,420397886 553021,26351366

 2583.106 2351.7 2801.16
octubre noviembre diciembre
745.12 745.12 745.12
1312.217848 1194.6636 1422.98928
19861.502034 18082.2213 21538.11924
0 0 0
0 0 0
11750.549194 10697.8833 12742.47684
1410.375876 1284.0282 1529.43336
33022.427104 30064.1328 35810.02944

203791.564764 185535.0198 220994.71704

41215109.41784 37522878.588 44694300.5424

pp pp pp
octubre noviembre diciembre

41487003.17466 37770481.657 44989083.4276

octubre noviembre diciembre

1523.84116712404 1730.64293002643 1895.08358907925

121907.293369923 138451.434402114 151606.68712634

41365095,8812901 37632030,2225979 44837476,7404737

 00:00 a [Link] 1:00
Enero a Dici 1.96587768 0 0
Enero 2.55273308 0 0
Febrero 2.52987931 0 0
Marzo 2.38447761 0 0
Abril 1.97238546 0 0
Mayo 1.44710385 0 0
Junio 1.2315455 0 0
Julio 1.27571007 0 0
Agosto 1.41100801 0 0
Septiembre 1.78668951 0 0
Octubre 2.04817361 0 0
Noviembre 2.40367074 0 0
Diciembre 2.54715536 0 0

total generado en un año 1375339.33

total generado en un año 1375339.33
 generacion fotovoltaica

2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00

0 0 0 0 0.02084378 0.25497762 1.51018735 3.54159864
0 0 0 0 0.01963536 0.39991348 2.24854966 4.40956274
0 0 0 0 0 0.22468846 1.98725049 4.24905515
0 0 0 0 0 0.05264906 1.88448725 4.06193116
0 0 0 0 0 0 1.4701632 3.54792412
0 0 0 0 0 0 0.108595 2.59496364
0 0 0 0 0 0 0.01574153 2.13758859
0 0 0 0 0 0 0.02315816 1.99674223
0 0 0 0 0 0 0.61074343 2.42130943
0 0 0 0 0 0.13301594 1.72506253 3.35988653
0 0 0 0 0.00239379 0.63429992 2.40652075 4.1043301
0 0 0 0 0.10085953 0.89525311 2.89839469 4.8391469
0 0 0 0 0.12723672 0.71991152 2.74358155 4.77674312

demanda leida mensual

enero 2875.56
febrero 2839.2
marzo 2813.25
abril 2625.3
mayo 2538.9
junio 2548.5
julio 2537.35
agosto 2866.57
septiembre 2790.3
octubre 2583.106
noviembre 2351.7
diciembre 2801.16
eneracion fotovoltaica

10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00

4.94873172 5.90770744 6.33268005 6.36194805 5.92773857 5.22866091 4.03454613 2.41039576
6.11278044 7.24790308 7.80964919 7.89555197 7.50579302 6.77074402 5.4235413 3.63653397
5.98579733 7.20178677 7.80621059 7.93512776 7.53219651 6.81138742 5.53047968 3.72769415
5.87280352 6.96684065 7.52219882 7.63064699 7.24633974 6.40716031 5.13282083 3.24662522
4.97254184 6.12412421 6.49959839 6.58759252 6.11534639 5.26164561 4.09733023 2.3880383
3.81572922 4.61555654 5.07845993 5.03027353 4.62581326 4.11017401 2.95519727 1.79573
3.26146511 4.06355644 4.46319593 4.55155579 4.20096137 3.71872902 2.74351649 0.40078166
3.20346645 3.93413894 4.28025457 4.39713543 4.1494626 3.74005426 2.79350402 2.09912507
3.61928927 4.49609996 4.76907269 4.74404489 4.41351231 3.89224847 3.0291984 1.82124047
4.62140979 5.42066738 5.67288912 5.83802352 5.39880544 4.65053009 3.5349754 1.94994153
5.34579914 6.2356651 6.68766224 6.44562559 5.79059024 5.04477048 3.71457488 2.10639986
6.20905686 7.14556823 7.55686966 7.43820208 6.84939254 5.88578303 4.44732049 2.59484255
6.36464167 7.44058202 7.84609947 7.8495965 7.30464937 6.45070414 5.01209454 3.15779635
18:00 19:00 20:00 21:00 22:00 23:00
0.64101911 0.06002909 0 0 0 0
1.5340958 0.25133989 0 0 0 0
1.56639863 0.1590305 0 0 0 0
1.19771133 0.00524785 0 0 0 0
0.27294632 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
0.04743302 0 0 0 0 0
0.57534086 0 0 0 0 0
0.63753459 0 0 0 0 0
0.74443129 0.08297672 0 0 0 0
1.11633754 0.22175417 0 0 0 0
totales mensual

2875.56
10 Consumo diario Ener
9
8
7
6 5.
5.5
5 5.2 5.3
4.3
4
3.6 3.8
3 3.1
2 2
1.5
1 1.2 1.12
0.5 0.3 0.4 0.5
0 0.2
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
 hora kw
0 1.2
umo diario Enero kW 1 0.5
9.2 2 0.3
8.5
8.04 8.3 3 0.2
4 0.4
6.5
5 0.5
5.8
5.5 6 1.12
5.2 5.3
4.7
4.3 7 1.5
3.6 3.8 8 2
3.1 3.2
9 3.1
2
1.5 10 3.6
1.12
5 11 3.8
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 12 4.3
13 5.2
14 5.3
15 5.5
16 5.8
17 6.5
18 8.5
19 8.04
20 9.2
21 8.3
22 4.7
23 3.2
 hora kw
0 1.3
1 0.8
2 0.4
totales mensu 3 0.6 Consumo diario Febrero kW
2839.2 4 0.2 10
5 0.5 9
6 1.2 8
7 2.2 7
8 3.1 6 5.8 6
9 3.8 5.3 5.
5
4.6
10 4.6 4 3.8
11 5.3 3 3.1
12 5.8 2 2.2
13 6 1.3 1.2
1 0.8
14 5.2 0.4 0.6 0.2 0.5
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 1
15 5.9
16 6.4
17 7
18 8.5
19 8.2
20 9
21 7.3
22 5.6
23 2.5
sumo diario Febrero kW
9
8.5
8.2
7.3
7
6.4
5.8 6 5.9
5.6
5.3 5.2
4.6
3.8
3.1
2.5
2.2
1.2
0.5
0.2
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.9
1 0.2
totales mensu 2 0.3
2813.25 3 0.1
4 0.3
5 0.2
10
Consumo diario Ma
6 0.5
7 1.1 9
8 2.1 8
9 2.5 7
6.6
10 3.5 6
11 4 5.3
5 4.75
12 4.75 4 4
13 5.3 3.5
3
14 6.6 2.5
2 2.1
15 5.4
1 0.9 1.1
16 6 0.2 0.3 0.3 0.2
0.5
0 0.1
17 6.2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
18 9
19 8.3
20 9.4
21 7.9
22 4.2
23 2
onsumo diario Marzo kW
9.4
9
8.3
7.9

6.6
6 6.2
5.3 5.4
4.75
4 4.2
3.5
2.5
2.1 2
1.1
0.3 0.2 0.5
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 1.4
1 0.8
2 0.5
3 0.4
totales mensu 4 0.1
2625.3 5 0.2
6 0.5
7 0.9
8 1.5
10
Consumo
9 2.5
10 3.3 9
11 3.8 8
12 4.2 7
13 4 6
14 6.1 5
15 5.1 4
16 6.3 3
17 7 2.
2
18 8.2 1.4 1.5
1 0.8 0.9
19 8.3 0.5 0.4 0.5
0 0.1 0.2
20 9.2 1 2 3 4 5 6 7 8 9 1
21 8.6
22 3.2
23 1.41
10
Consumo diario Abril kW
9 9.2
8.6
8 8.2 8.3

7 7
6.1 6.3
6
5 5.1
4 4.2 4
3.8
3.3 3.2
3
2.5
2
1.4 1.5 1.41
1 0.8 0.9
0.5 0.4 0.5
0 0.1 0.2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 1.2
1 0.8
2 0.5
10
Consumo diario Mayo
3 0.4
9
4 0.1
8
totales mensu 5 0.3
7
2538.9 6 0.2
6 6.2 6
7 0.9 5.5
8 1.1 5
9 2.3 4
3.6
3.9
10 3.6 3 3 3.2
11 3 2.3
2
12 3.2 1 1.2 0.8 0.9 1.1
0.5 0.4
13 3.9 0 0.1 0.3 0.2
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1
14 5.5
15 6.2
16 6.1
17 5.9
18 6.4
19 7.2
20 8.9
21 8.1
22 3.6
23 2.5
nsumo diario Mayo kW
8.9
8.1
7.2
6.2 6.1 6.4
5.9
5.5

3.9
3.6 3.6
3 3.2
2.3 2.5

0.9 1.1
.3 0.2
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.8
1 0.2
10
Consumo diario Junio
2 0.3
totales mensu 3 0.5 9

2548.5 4 0.2 8

5 0.6 7
6 0.5 6 5.9 6
7 0.5 5 5.2
8 0.8 4 3.9 4
3.5
9 1.1 3 2.9
10 2.9 2
11 3.5 1 0.8 1.1
12 3.9 0.5 0.6 0.5 0.5 0.8
0 0.2 0.3 0.2
13 4 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
14 5.2
15 5.9
16 6.1
17 6.8
18 8.3
19 8.12
20 8.93
21 9
22 5
23 1.8
nsumo diario Junio kW
8.93 9
8.38.12

6.8
5.9 6.1
5.2 5
3.9 4
3.5
2.9
1.8
1.1
0.6 0.5 0.5 0.8
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
J
hora kw
0 1.4
1 0.5
10
Consumo diario Julio kW
2 0.2
9
3 0.5 8.61
8
8
4 0.7
5 0.1 7
6 6.21
totales mensu 6 0.6 5.9
2537.35 7 0.7 5
4.6
4.3
8 0.5 4 4 4.2
3.6
9 1.1 3 3
10 3 2
11 3.6 1.4
1 1.1
12 4 0.5 0.7
0.5 0.6 0.7 0.5
0 0.2 0.1
13 4.2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 2

14 4.6
15 4.3
16 5.9
17 6.21
18 8.61
19 8.3
20 9.23
21 8.1
22 3.2
23 2.3
mo diario Julio kW
9.23
8.61
8.3 8.1

6.21
5.9

4.6
4.3
4 4.2
3.6
3 3.2
2.3

1.1
0.5
9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.9
1 0.2
2 0.9 10
Consumo diario Agosto
3 0.5 9
4 0.6 8
5 0.4
7
6.7
totales mensu 6 0.8 6.2
6
2866.57 7 1.2
5 5 5
8 2.1 4.5
4 3.9
9 2.6
3 2.9
10 2.9 2.6
2 2.1
11 3.9
1 0.9 1.2
12 4.5 0.9 0.8
0.5 0.6 0.4
0.2
13 5 0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
14 6.7
15 5
16 6.2
17 6
18 8
19 8.2
20 9.5
21 8.1
22 5.12
23 3.15
umo diario Agosto kW
9.5

8 8.2 8.1

6.7
6.2 6

5 5 5.12
4.5
3.9
2.9 3.15
2.6
2.1
1.2
0.8

7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 1.4
1 0.8
2 0.6 12
Consumo diario Septiemb
3 0.5
4 0.33 10
5 0.8
8
6 0.9
7 1.3
6 6.12
totales mensu 8 1.6 5.7
5.014.98 5.2
2790.3 9 2.6 4.6
4
10 3.5 3.5
2.6
11 4.6 2
1.4 1.3 1.6
12 5.01 0.8 0.6 0.5 0.8 0.9
0 0.33
13 4.98 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
14 6.12
15 5.2
16 5.7
17 6.1
18 7.9
19 7.89
20 9.75
21 8.1
22 5.23
23 2.1
mo diario Septiembre kW

9.75

7.97.89 8.1

6.12 6.1
5.7
5.014.98 5.2 5.23
4.6
3.5
2.6
2.1
1.3 1.6
0.9

7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.5
1 0.9 10
Consumo diario Oct
2 0.456 9
3 0.5
8
4 0.3
7
totales mensu 5 0.8
6
6 0.99 5.6
5
2583.106 7 1.1 4
8 1.3 4 4

9 1.8 3
2.4 2.6
10 2.4 2 1.8
11 2.6 1 1.1 1.3
0.9 0.80.99
0.5 0.4560.5 0.3
12 4 0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 1
13 5.6
14 4.5
15 5.1
16 5.7
17 6.1
18 8.2
19 7.6
20 9.26
21 8.12
22 4.2
23 1.3
Consumo diario Octubre kW
9.26
8.2 8.12
7.6

6.1
5.6 5.7
5.1
4.5
4 4.2

2.4 2.6
1.8
1.1 1.3 1.3
0.80.99
.5 0.3
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.9
1 0.5
totales mensu 2 0.6
12
Consumo diario Noviem
2351.7 3 0.4
4 0.3
10
5 0.6
6 0.8
8
7 0.99
8 1.1 6 6
9 1.7 5.2
10 1.5 4 4.3
3.5
11 1.9 2.8
12 2.8 2 1.7 1.5 1.9
13 3.5 0.9 0.991.1
0.5 0.6 0.4 0.3 0.6 0.8
0
14 4.3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1
15 5.2
16 6.2
17 5.9
18 7.9
19 8.3
20 9.8
21 7.5
22 3.1
23 2.6
umo diario Noviembre kW

9.8

8.3
7.9
7.5
6.2 5.9
5.2
4.3
3.5
2.8 3.1
2.6
1.7 1.5 1.9
0.991.1
.6 0.8
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
 hora kw
0 0.6
1 0.5
2 0.6 12
Consumo diario Diciemb
totales mensu 3 0.4
2801.16 4 0.63 10
5 0.6
6 0.8 8
7 0.88
6 5
8 0.99 5.7
5.35
5
9 1.6 4.6
4 4.1
10 2.5
11 4.1 2.5
2
1.6
12 4.6 [Link]
0.6 0.5 0.6 [Link]
13 5 0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1
14 5.7
15 5.35
16 5.9
17 6.9
18 8.2
19 8.9
20 10.2
21 9.11
22 4.2
23 2.1
umo diario Diciembre kW
10.2
8.9 9.11
8.2
6.9
5.7 5.9
5.35
5
4.6
4.1 4.2

2.5
2.1
1.6
.6 [Link]

6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24