How to select a make a random selection in a chemical spreadsheet.

[Andrew Orry]

Q. How to select a make a random selection in a chemical spreadsheet.

A.

For table called 't'

s_tab = "t"   # enter table name here

find table $s_tab select index=Random(1 Nof( $s_tab ) Nof( $s_tab )/2 )   # will select ~half of random rows in the table