Hi there! Debut post =)
I'm trying to do some calculations but I can only see a long manual way round so looking for a much easier way!
What I'm trying to do is work out how much solar energy (kWh) has been generated since the installation date of some solar panels.
I have a bunch of dates in column A which are assigned to annual kWh values in column B. So I need to multiply that value by the number of years that have passed since that date.
I then need to multiply the remaining months by a multiplier (a percentage) specific to each month that is left over.
A B
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]16-09-12[/TD]
[TD="class: xl65, width: 64"] 22,246[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]06-09-13[/TD]
[TD="class: xl63, width: 64"] 7,150[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]07-05-14[/TD]
[TD="class: xl65, width: 64"] 57,753[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
January 3.1
February 5
March 8.7
April 11.4
May 12.3
June 12.3
July 13.3
August 10.8
September 9.7
October 6.5
November 3.8
December 3.1
Any help is greatly appreciated thank you!
I'm trying to do some calculations but I can only see a long manual way round so looking for a much easier way!
What I'm trying to do is work out how much solar energy (kWh) has been generated since the installation date of some solar panels.
I have a bunch of dates in column A which are assigned to annual kWh values in column B. So I need to multiply that value by the number of years that have passed since that date.
I then need to multiply the remaining months by a multiplier (a percentage) specific to each month that is left over.
A B
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]16-09-12[/TD]
[TD="class: xl65, width: 64"] 22,246[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]06-09-13[/TD]
[TD="class: xl63, width: 64"] 7,150[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"]07-05-14[/TD]
[TD="class: xl65, width: 64"] 57,753[/TD]
[/TR]
[TR]
[TD="class: xl66, align: right"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
January 3.1
February 5
March 8.7
April 11.4
May 12.3
June 12.3
July 13.3
August 10.8
September 9.7
October 6.5
November 3.8
December 3.1
Any help is greatly appreciated thank you!