Coffeehouse Post

Single Post Permalink

View Thread: Simulations using Excel
  • User profile image
    Maurits

    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.