Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Events
Happy Thanksgiving to all.
I am programming a simulation of a storage facility. It cycles through the 365 days in a year and calculates the change in inventories. I have 55 events which have to occur randomly through the year. Does anyone have an idea how to do this. I figure somehow the Random number generator could be used, however, I can't figure out how to tie it in. Thanks in advance for your help! Ray |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Events
myday = Int(rnd()*365 + 1)
would generate a uniformly distributed random number between 1 and 365 inclusive. -- Regards, Tom Ogilvy "Ray Batig" wrote in message ink.net... Happy Thanksgiving to all. I am programming a simulation of a storage facility. It cycles through the 365 days in a year and calculates the change in inventories. I have 55 events which have to occur randomly through the year. Does anyone have an idea how to do this. I figure somehow the Random number generator could be used, however, I can't figure out how to tie it in. Thanks in advance for your help! Ray |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Random Events
Thanks Tom! Works fine!!
Ray Tom Ogilvy wrote in message ... myday = Int(rnd()*365 + 1) would generate a uniformly distributed random number between 1 and 365 inclusive. -- Regards, Tom Ogilvy "Ray Batig" wrote in message ink.net... Happy Thanksgiving to all. I am programming a simulation of a storage facility. It cycles through the 365 days in a year and calculates the change in inventories. I have 55 events which have to occur randomly through the year. Does anyone have an idea how to do this. I figure somehow the Random number generator could be used, however, I can't figure out how to tie it in. Thanks in advance for your help! Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting random Data created from a random formula | Excel Discussion (Misc queries) | |||
Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Need some events... | Excel Programming |