Control seed in @rand of Lotus 1-2-3?

Article View: comp.apps.spreadsheets

Article #296

Back to comp.apps.spreadsheets Previous Next

#296

From: fcs$1224
Date: Fri, 22 Jan 1993 01:30

14 lines
835 bytes

Hi:

The @rand function in Lotus 1-2-3 generates numbers such that 0 <
x < 1.  Is there a way to set the beginning seed to a value?  The
purpose is to aid in debugging simulations by getting the same set
of random numbers each time.  I could use the same set of random
numbers by putting all of them in the spreadsheet, but I would
rather generate the same set of random numbers each time.  The
number of random numbers I am using does not lend itself to storing
them.

Thanks,

Tom

Technical Details

Message-ID: <1993Jan21.193100.1392@altair.selu.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!altair.selu.edu!fcs$1224

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!altair.selu.edu!fcs$1224
From: fcs$1224@altair.selu.edu
Newsgroups: comp.apps.spreadsheets
Subject: Control seed in @rand of Lotus 1-2-3?
Message-ID: <1993Jan21.193100.1392@altair.selu.edu>
Date: 21 Jan 93 19:30:59 -0600
Organization: Southeastern Louisiana University
Lines: 14