Solar Calculator

[NetZero]

Hi guys,

I posted a question regarding this recently but I don't think I worded it quite correctly and after some consideration have come up with a clearer (wordy) way of trying to calculate something which would be awesome if someone could convert to excel language for me!

I am trying to determine the kWh produced by several solar systems from installation to today, but have to multiply months in incomplete years by a percentage due to the fact that solar power is not generated evenly throughout the year.

So I have 3 pages.

Page 1

[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]kWh Per Annum (PA)[/TD]
[TD]Installation Date[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]22,246[/TD]
[TD]16-09-12[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]7,150[/TD]
[TD]06-09-2013[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]57,753[/TD]
[TD]07-05-14[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]44,303[/TD]
[TD]08-10-14[/TD]
[/TR]
</tbody>[/TABLE]

Page 2

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Solar Percentage[/TD]
[TD]Cumulative Percentage[/TD]
[TD]Rest of Year Percentage[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD]3.1[/TD]
[TD]3.1[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD]5[/TD]
[TD]8.1[/TD]
[TD]96.9[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD]8.7[/TD]
[TD]16.8[/TD]
[TD]91.9[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD]11.4[/TD]
[TD]28.2[/TD]
[TD]83.2[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]12.3[/TD]
[TD]40.5[/TD]
[TD]71.8[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD]12.3[/TD]
[TD]52.8[/TD]
[TD]59.5[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]13.3[/TD]
[TD]66.1[/TD]
[TD]47.2[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]10.8[/TD]
[TD]76.9[/TD]
[TD]33.9[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]9.7[/TD]
[TD]86.6[/TD]
[TD]23.1[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD]6.5[/TD]
[TD]93.1[/TD]
[TD]13.4[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD]3.8[/TD]
[TD]96.9[/TD]
[TD]6.9[/TD]
[/TR]
[TR]
[TD]December[/TD]
[TD]3.1[/TD]
[TD]100[/TD]
[TD]3.1[/TD]
[/TR]
</tbody>[/TABLE]

Page 3 - kWh produced annually.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Location[/TD]
[TD]2012[/TD]
[TD]2013[/TD]
[TD]2014[/TD]
[TD]2015[/TD]
[TD]2016[/TD]
[TD]2017[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Insert Code here[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


An idea of what the code is trying to achieve is broken down into 4 steps:

1. IF installation date (year) > column header (year) THEN input 0
2. IF installation date (year) = column header (year) THEN find month (page 2) and multiply kWh PA (page 1) by rest of year percentage (page 2) of relevant month.
3. IF installation date (year) = 2017 THEN find month (page 2) and multiply kWh PA (page 1) by cumulative % (page 2) of relevant month.
4. ELSE input kWh PA (page 1).

Help is greatly appreciated!!

 

[RoryA]

Please don't repost the same question, especially after you had a rely to your original question to which you did not respond. This thread will now be closed, so please continue in your original one.