Hundred scenarios

[qtmspin]

I would like to create / manage / run around one hundred scenarios w/ 5 inputs. Is there a better way then creating them manually?

Thanks,
Matt

[darkyam]

Hi, qtmspin, welcome to the forum. Your question is a bit vague. What scenarios, exactly, are we talking about? Can you have 100 different lines with the data input and a formula on each line, or is the sheet setup so that you have to do one at a time and want Excel to store the results of all 100? If possible, please post a workbook with dummy data and a clearer explanation.

[qtmspin]

On the first sheet I have 5 inputs:

A
B
C
D
E

On the 2nd sheet I have 50,000 rows of price data with formulas that use the values on the first sheet that equate to 1 or 0, at then end I sum them up, and use thoses values for my results.

I would like a sheet where I can plug in 10 different values for each of my A B C inputs. The get the results from the sums on the 2nd sheet in a pivot table.

The only way that Ive seen this is to use scenario manager because I have more then 2 inputs, however it would take forever to input 100+ different scenarios unless I can create them 'programatically'

1 0 1 0 0 1
1 1 0 1 1 0
1 1 1 0 0 0

results:
3 2 2 1 1 1