儲能項目工具【Excel計算表】風(fēng)電場儲能系統(tǒng)投資收益計算表(帶公式)

20xx年,,,,,,,,,,,,,,,,,

一月,,,二月,,,三月,,,四月,,,五月,,,六月,,

日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量

1日,438.689,79.23,1日,60.029,0.00,1日,279.295,528.51,1日,469.258,99.37,1日,352.887,9.70,1日,148.633,0.00

2日,372.647,324.57,2日,185.919,0.37,2日,358.872,335.26,2日,68.396,0.00,2日,455.534,3.65,2日,449.03,25.93

3日,256.812,338.50,3日,299.747,0.00,3日,144.198,14.58,3日,143.393,0.00,3日,467.856,46.87,3日,58.654,0.00

4日,87.179,0.00,4日,337.64,0.00,4日,468.696,87.26,4日,105.877,0.00,4日,487.739,234.65,4日,21.85,0.00

5日,54.741,0.00,5日,178.879,0.00,5日,550.872,344.89,5日,92.752,0.00,5日,744.785,316.40,5日,314.737,0.00

6日,26.722,0.00,6日,0,0.00,6日,528.968,386.84,6日,281.604,0.00,6日,772.838,127.73,6日,172.848,0.00

7日,0,0.00,7日,374.497,34.08,7日,649.599,19.33,7日,344.494,0.00,7日,145.795,0.00,7日,352.616,0.00

8日,209.897,95.89,8日,767.655,67.12,8日,635.517,20.73,8日,396.8,0.00,8日,117.621,0.00,8日,297.856,0.00

9日,355.481,151.60,9日,532.071,340.78,9日,408.129,15.84,9日,127.929,0.00,9日,511.319,116.67,9日,216.784,0.00

10日,459.436,74.73,10日,402.027,250.43,10日,93.025,0.00,10日,507.444,7.74,10日,360.778,96.21,10日,140.35,0.00

11日,366.609,260.07,11日,325.867,235.14,11日,520.497,42.58,11日,511.715,0.00,11日,528.424,471.24,11日,163.824,0.00

12日,311.277,333.35,12日,365.913,26.82,12日,425.229,0.00,12日,552.478,18.41,12日,695.721,345.01,12日,87.928,0.00

13日,160.108,0.00,13日,146.823,0.00,13日,226.907,0.00,13日,237.062,0.00,13日,595.286,0.00,13日,57.912,0.00

14日,1.432,0.00,14日,201.625,13.24,14日,0.46,0.00,14日,325.222,0.00,14日,180.562,0.00,14日,50.084,0.00

15日,40.867,0.00,15日,253.781,555.09,15日,3.453,0.00,15日,346.665,0.00,15日,42.596,0.00,15日,13.803,0.00

16日,29.631,0.00,16日,503.433,296.60,16日,147.287,0.00,16日,462.278,3.83,16日,300.081,0.00,16日,91.853,0.00

17日,260.876,89.25,17日,241.594,64.50,17日,63.616,0.00,17日,694.613,12.66,17日,61.983,0.00,17日,264.671,0.00

18日,214.042,0.00,18日,323.829,700.89,18日,0,0.00,18日,478.274,0.00,18日,111.874,0.00,18日,167.81,0.00

19日,516.645,494.22,19日,267.172,737.58,19日,0,0.00,19日,635.693,225.54,19日,292.112,0.00,19日,251.483,0.00

20日,314.453,286.75,20日,138.787,86.98,20日,149.064,0.00,20日,380.391,0.00,20日,102.34,0.00,20日,77.01,0.00

21日,409.704,466.12,21日,195.404,325.79,21日,45.207,0.00,21日,490.022,1.07,21日,242.724,0.00,21日,153.721,0.00

22日,416.923,47.28,22日,124.748,899.76,22日,1.768,0.00,22日,602.258,373.54,22日,627.186,0.00,22日,8.623,0.00

23日,236.793,0.00,23日,184.164,267.44,23日,140.262,0.00,23日,619.768,0.00,23日,199.149,0.00,23日,26.718,0.00

24日,87.252,0.00,24日,341.534,500.22,24日,261.615,0.00,24日,624.169,0.00,24日,448.27,100.08,24日,292.242,0.00

25日,229.196,390.28,25日,407.343,187.29,25日,690.819,7.27,25日,104.475,0.00,25日,41.706,0.00,25日,325.981,0.00

26日,356.615,698.76,26日,145.94,0.00,26日,418.803,22.54,26日,198.135,0.00,26日,118.658,0.00,26日,22.141,0.00

27日,193.136,150.05,27日,388.033,52.46,27日,33.274,0.00,27日,414.155,293.93,27日,422.504,0.00,27日,164.718,0.00

28日,152.274,346.71,28日,399.34,67.45,28日,71.1,0.00,28日,719.99,126.33,28日,309.911,49.75,28日,477.086,6.92

29日,255.648,423.00,,,,29日,210.771,0.00,29日,493.126,0.00,29日,212.606,0.00,29日,91.953,0.00

30日,123.334,0.00,,,,30日,575.682,0.00,30日,29.435,0.00,30日,19.217,0.00,30日,7.84,0.00

31日,324.363,48.26,,,,31日,293.527,0.00,,,,31日,547.417,2.05,,,

合計,7262.782,5098.62,合計,8093.794,5710.04,合計,8396.512,1825.61,合計,11457.871,1162.42,合計,10517.479,1920.01,合計,4970.759,32.85

,,,,,,,,,,,,,,,,,,

20xx年,,,,,,,,,,,,,,,,,

七月,,,八月,,,九月,,,十月,,,十一月,,,十二月,,

日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量,日期,發(fā)電量,限電量

1日,15.218,0.00,1日,42.704,0.00,1日,209.324,0.00,1日,260.085,0.00,1日,347.532,0.00,1日,610.472,100.93

2日,100.552,0.00,2日,14.073,0.00,2日,83.378,0.00,2日,66.334,0.00,2日,551.701,0.00,2日,313.856,194.88

3日,147.747,0.00,3日,285.266,0.00,3日,281.642,4.64,3日,7.37,0.00,3日,153.988,0.00,3日,676.619,97.41

4日,40.699,0.00,4日,119.23,0.00,4日,312.714,0.00,4日,357.294,26.45,4日,304.532,0.00,4日,756.412,352.34

5日,176.359,0.00,5日,381.147,0.00,5日,292.76,0.00,5日,457.113,125.39,5日,391.428,0.00,5日,637.932,391.21

6日,174.167,0.00,6日,425.218,0.00,6日,97.42,0.00,6日,225.233,206.04,6日,626.21,30.96,6日,692.468,0.00

7日,468.347,83.80,7日,69.878,0.00,7日,374.279,48.56,7日,65.237,0.00,7日,684.586,172.18,7日,646.168,457.89

8日,356.286,81.79,8日,120.119,0.00,8日,361.175,0.25,8日,273.354,0.00,8日,168.592,0.00,8日,635.926,289.34

9日,468.678,1.39,9日,268.896,0.00,9日,258.677,5.04,9日,587.044,0.00,9日,774.938,126.16,9日,533.013,74.96

10日,205.047,0.00,10日,376.202,0.00,10日,236.233,0.00,10日,121.051,0.00,10日,494.589,54.10,10日,901.056,155.14

11日,268.361,0.00,11日,214.368,0.00,11日,11.249,0.00,11日,155.788,0.00,11日,701.684,23.35,11日,413.624,0.00

12日,327.419,0.00,12日,110.296,0.00,12日,62.37,0.00,12日,309.533,3.21,12日,598.768,237.89,12日,315.019,0.00

13日,312.087,0.00,13日,53.352,0.00,13日,149.418,0.00,13日,115.944,0.00,13日,793.843,184.34,13日,13.412,0.00

14日,38.268,0.00,14日,34.194,0.00,14日,157.316,0.00,14日,144.874,0.00,14日,686.325,44.26,14日,268.037,0.00

15日,49.087,0.00,15日,105.988,0.00,15日,113.9,0.00,15日,85.342,0.00,15日,342.749,0.00,15日,820.58,129.01

16日,116.699,0.00,16日,136.685,0.00,16日,414.993,46.14,16日,94.111,0.00,16日,572.873,2.35,16日,895.036,208.78

17日,82.787,0.00,17日,24.968,0.00,17日,61.195,0.00,17日,169.094,0.00,17日,847.875,107.62,17日,893.511,231.50

18日,17.804,0.00,18日,58.172,0.00,18日,397.262,95.00,18日,39.759,0.00,18日,724.93,87.63,18日,884.446,228.65

19日,88.759,0.00,19日,56.916,0.00,19日,186.925,0.00,19日,155.142,0.00,19日,597.808,85.49,19日,813.255,46.68

20日,262.099,0.00,20日,130.155,0.00,20日,277.044,2.01,20日,252.522,0.97,20日,774.358,46.11,20日,523.473,185.74

21日,9.84,0.00,21日,83.517,0.00,21日,497.426,355.11,21日,233.25,0.00,21日,714.324,252.50,21日,539.036,176.81

22日,42.862,0.00,22日,196.289,0.00,22日,401.911,95.05,22日,262.774,0.00,22日,857.975,168.99,22日,318.499,173.93

23日,77.441,0.00,23日,232.865,0.00,23日,243.345,366.39,23日,20.788,0.00,23日,865.16,229.61,23日,429.27,252.46

24日,67.519,0.00,24日,430.344,0.00,24日,126.219,2.41,24日,107.49,0.00,24日,764.392,162.25,24日,93.881,472.07

25日,50.171,0.00,25日,402.045,0.00,25日,315.286,45.85,25日,29.479,0.00,25日,777.963,124.36,25日,81.41,243.32

26日,114.098,0.00,26日,142.609,0.00,26日,62.337,0.00,26日,238.076,94.05,26日,371.208,37.23,26日,149.671,87.23

27日,193.933,0.00,27日,24.027,0.00,27日,354.575,142.46,27日,500.192,0.00,27日,739.858,254.19,27日,68.774,148.41

28日,35.425,0.00,28日,293.358,0.00,28日,445.917,0.00,28日,670.655,65.41,28日,458.581,88.39,28日,153.083,20.85

29日,78.398,0.00,29日,227.732,0.00,29日,357.476,6.03,29日,494.478,0.00,29日,316.179,0.00,29日,274.585,198.75

30日,85.191,0.00,30日,347.911,0.00,30日,526.372,59.85,30日,586.24,40.74,30日,493.742,0.00,30日,465.46,252.76

31日,55.789,0.00,31日,57.208,0.00,,,,31日,639.802,63.40,,,,31日,87.211,177.36

合計,4527.137,166.98,合計,5465.732,0.00,合計,7670.138,1274.79,合計,7725.448,625.66,合計,17498.691,2519.96,合計,14905.195,5348.41

"注：1、表中發(fā)電量與限電量單位均為（MW·h）。

2、風(fēng)電場總裝機容量為49.5MW（批復(fù)），目前運行48MW，32臺風(fēng)機。

3、含稅電價為0.51元。",,,,,,,,,,,,,,,,,

,,,,,,,,