I am using version 2.2 on Mac OS X v10.4.9
In the Calc program
There appears to be a problem with how the Rand() function works in
conjunction with data tables (multiple.operations).
If the formula used for the data table involves a random number
directly (such as NORMINV(RAND(),10,2)) then the data table will be
populated with random numbers. If however, the formula used for the
data table is a function of other cells involving random numbers
(such as "=(C4+C5)/2" where C4 and C5 are each randomly generated
numbers using NORMINV(RAND(),10,2) then the data table will NOT be
populated with randomized numbers, but rather only 1 number.
Example,
A1 formula is "=NORMINV(RAND();10;2)"
A2 formula is "=NORMINV(RAND();10;2)"
A3 formula is "=A1+A2"
If I create a data table of 5 rows using the Multiple Operations and
select A1 as my Formula and any blank cell for column input cell,
then I get 5 rows of random numbers (different in each row).
If I create a data table of 5 rows using the Multiple Operations and
select A3 as my Formula and any blank cell for column input cell,
then I get 5 rows of identical numbers (no randomization).
The program should recalculate the entire sheet (including formulas
of random numbers) for each row of a data table. This is highly
important for performing simulations of outputs that are the
functions of multiple randomized inputs.
Jon Daley
[EMAIL PROTECTED]
www.jondaley.com
