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.


Time Per Passenger

Passenger Loading Time

Bus Travel Time

Total Travel Time






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.