Scenario Analysis - can excel help?

[colindenovo]

Hi Guys,

I'm trying to do some scenario analysis in Excel and am currently populating the table manually.

Just wondering, is there a way to generate all possible scenarios within excel using a formula?

The first few rows of the table look like below, and as its going to take me until 2018 to finish it I thought I'd ask for help

Thanks,

Colin
[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]Y
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]Y
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]Y
[/TD]
[TD="class: xl63, width: 64, bgcolor: #C5D9F1"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl64, width: 64, bgcolor: #D8E4BC"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]N
[/TD]
[/TR]
</tbody>[/TABLE]