# random number generation help

A

Greetings,

I am writing an attack simulator for a game I play. In the game,
combat begins with ships on both sides attacking opposing ships at
random. Part of my program contains a 2 dimensional array where a
random number is assigned for each ship through a series of loops,
if's, select cases, etc...For the random number assignment, I am using
the code line:

ATM(ShipCount, 5) = Int((TotalDefenseShips * Rnd) + 1)

This appears to be working great and is randomly assigning numbers
througout my array, as I want. HOWEVER, I have noticed that the series
is the same with every run of the program. I need to alter my code so
the random number does not follow the same sequence, even if I don't
change any variables. With every run of my simulation, every point in
the array must have a random number assigned to it that was different
than the last simulation run.

Any ideas?

G

#### GS

A Mad Doberman has brought this to us :
Greetings,

I am writing an attack simulator for a game I play. In the game,
combat begins with ships on both sides attacking opposing ships at
random. Part of my program contains a 2 dimensional array where a
random number is assigned for each ship through a series of loops,
if's, select cases, etc...For the random number assignment, I am using
the code line:

ATM(ShipCount, 5) = Int((TotalDefenseShips * Rnd) + 1)

This appears to be working great and is randomly assigning numbers
througout my array, as I want. HOWEVER, I have noticed that the series
is the same with every run of the program. I need to alter my code so
the random number does not follow the same sequence, even if I don't
change any variables. With every run of my simulation, every point in
the array must have a random number assigned to it that was different
than the last simulation run.

Any ideas?

Here's a good place to start...

http://www.cpearson.com/excel/randomNumbers.aspx

J

#### Jim Cone

You should use the "Randomize" statement on a single line before initiating a call to the Rnd
function.
Also, do not use the statement inside a loop, but place it 'outside' before the For or Do.
Multiple statements within a procedure are usually not necessary.
The later versions of Excel (2003 +) have been promoted as having better Rnd implementation.
'---
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware

wrote in message