Re: Bad random number generator : Microsoft Excel (office XP)

From: Paul Nutteing (nutteing_at_quickfindit.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 18:18:23 +0100

"Michael Jørgensen" <ingen@ukendt.dk> wrote in message
news:40c974a0$0$168$edfadb0f@dread11.news.tele.dk...
>
> "Paul Nutteing" <nutteing@quickfindit.com> wrote in message
> news:2it1quFr3la1U1@uni-berlin.de...
> > ***********
> > Randomize
> > a = 214013
> > c = 2531011
> > x0 = Timer
> >
> > temp = x0 * a + c
> > temp = temp / z
> > x1 = (temp - Fix(temp)) * z
> > x0 = x1
> > phj = x1 / z
> > ***********
>
> What value did you use for 'z'?
>
> -Michael.
>
>

Sorry about that - sloppy cut and paste

z = 2 ^ 24

Quantcast