You should be able to put your model, including all variables and relationships between them, in two rows; with the first row being the variable names, and the second row being the formulas.
|
Passengers |
Time Per Passenger |
Passenger Loading Time |
Bus Travel Time |
Total Travel Time |
|
=Rand(…) |
10 |
=A2*B2 |
500 |
=C2+D2 |
Then you can fill the second row down through row 1001 and get 1000 random samplings.
Then you can make a chart using the last column to show the distribution.
EDIT: meh... what DCMonkey said.
