Coffeehouse Post

Single Post Permalink

View Thread: Simulations using Excel
  • User profile image

    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.