01-03-2014, 09:39 AM
Shortliner,
Happy to share the worksheet. I found two versions of the excel worksheet, I will look for an earlier version in my archives that might be more straightforward & could be adapted and understood easier. Due to personal commitment I'll be busy for the next week or so, will return to this topic afterwards.
The worksheet makes use of named ranges to make formulas easier, and overall is based on concept of dice roll lookup tables once commonly found in wargame strategy boardgames aka combat results tables. Each industry has a table for number of cars needed, and another dependent table for types of cars needed. A waybill switchlist consolidates the resulting random generated car demand for each industry. This worked fairly well generating car demand for a small layout. not so sure it would be useful for a larger one.
later,
Doug
Happy to share the worksheet. I found two versions of the excel worksheet, I will look for an earlier version in my archives that might be more straightforward & could be adapted and understood easier. Due to personal commitment I'll be busy for the next week or so, will return to this topic afterwards.
The worksheet makes use of named ranges to make formulas easier, and overall is based on concept of dice roll lookup tables once commonly found in wargame strategy boardgames aka combat results tables. Each industry has a table for number of cars needed, and another dependent table for types of cars needed. A waybill switchlist consolidates the resulting random generated car demand for each industry. This worked fairly well generating car demand for a small layout. not so sure it would be useful for a larger one.
later,
Doug