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

Location	kWh Per Annum (PA)	Installation Date
A	22,246	16-09-12
B	7,150	06-09-2013
C	57,753	07-05-14
D	44,303	08-10-14

<tbody>
</tbody>

Page 2

Month	Solar Percentage	Cumulative Percentage	Rest of Year Percentage
January	3.1	3.1	100
February	5	8.1	96.9
March	8.7	16.8	91.9
April	11.4	28.2	83.2
May	12.3	40.5	71.8
June	12.3	52.8	59.5
July	13.3	66.1	47.2
August	10.8	76.9	33.9
September	9.7	86.6	23.1
October	6.5	93.1	13.4
November	3.8	96.9	6.9
December	3.1	100	3.1

<tbody>
</tbody>

Page 3 - kWh produced annually.

Location	2012	2013	2014	2015	2016	2017
A	Insert Code here
B
C
D

<tbody>
</tbody>

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.