-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/01/2016 21:13, Peter Koch wrote:
> I am trying to generate random numbers without duplicate numbers being generated. Grab the spreadsheet Inglenook.OTS, that should be linked to this email, and downloadable from Box.com. An older, but working version can be found at https://groups.io/g/ODF_Templates/files/Model%20Railroading I think that https://www.dropbox.com/s/n2k6zd4wxjigu8w/inglenook.ods?dl=0 contains a working version. On the page "IQ" is one solution to generating a sequence of random numbers, without duplicating any numbers. For your specific use-case, change the random number multiplier to 69, from whatever the formula uses. Then, if there are less than 69 numbers in the initial column, increase the number to 69, and create additional rows, and columns, as needed. In essence, you need to add one column, for every row that is added. It might take as much as an hour or so playing with the spreadsheet, and studying the formulas, to understand what it is doing. jonathon -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBAgAGBQJWlHnbAAoJEKG7hs8nSMR7ECMQAIAKs1Rjvza05lr0z1nERQfa +dLdKqh/QVoTdX+y237zuuy2GZSU+cybC68lWzkmilDmj3LOxLXUi+baaHArH4Ds kNsA4mNCF0YuUixB5QG/4MuXd0JORLKwBZMDH5pZ1i8qcv1U349Zknsy/WmX5m3g ASoRKvkhbLWdb7Kqr5NLaZI2vBlOA2vJJCLCQ9CAc0+FvnxJeupuNVsjacmW091e PFnfpvEIrSNl1U+bkHTSHD1kuLSZifYYST4N99tEX34xylwj6Fs6S6BOc2IMQqph tzkjlAEbbWSRINRsnbQehQQw3JD9mVpCfUgZYSfEzKy7Fx5zxCLmKJhGJahs2oFE 8W0wdq0ZwzC2ep/ubE7ORi/IK6U3IUaiU8NzZ35/aA/FNqaoeQfHigylFO0it5aX +b/wCCozjKftnAD3JHWP1pyM4x9kL7yEVWGuU93rC5ezLQoA6iz/alCJF781tT3H pORs2fJOhUe2LaeJYTa6Tlk1bvizIA2nbI+1moMGdmuxju/6iekG01c4QwRVCmBQ FLDf7UPFumZEWPRbWVXfE4b2/IAqIS32MMumD054Fv6Z+H71o0PPTgog6Qz9LJL4 8UxhXA1OS26bHeBkDSmVLHyAQmnMEyEm9TDifc5O2ppdkwUS1F3GuhteRLI4XCDB A5XPcgknfE1q1nEglOU8 =Zzrz -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org