Spreadsheet: 107012d1304163280-adding-cell-reference-numbers-together-random-rotation-v5
Sheet: Random

Generates random numbers |  |  | and ranks these numbers
Case 1 |  |  | Case 2 |  |  | Case 3 |  |  | Case 4 |  |  | Case 5
0.7970893271949704 | 5 |  | 0.5483422330510503 | 9 |  | 0.9221262033874882 | 1 |  | 0.511573497926971 | 8 |  | 0.9801763925342346 | 1
0.6988662070873435 | 7 |  | 0.7773852981324305 | 4 |  | 0.184481149318624 | 14 |  | 0.5213489434921987 | 7 |  | 0.4773644352625839 | 10
0.3804972490695251 | 11 |  | 0.049692693404225 | 18 |  | 0.6442425705691923 | 5 |  | 0.904008324433752 | 1 |  | 0.1508659142586417 | 19
0.3639170470707667 | 12 |  | 0.4339506488669571 | 12 |  | 0.147646283302695 | 16 |  | 0.008123940297495302 | 19 |  | 0.956291842666672 | 2
0.9958512874067387 | 2 |  | 0.4454991324443833 | 11 |  | 0.6379789051595488 | 6 |  | 0.3778741273588366 | 10 |  | 0.5333194419497835 | 8
0.02126657375754704 | 18 |  | 0.07405882233202021 | 17 |  | 0.2016912113807812 | 13 |  | 0.3222538498837537 | 13 |  | 0.410533528545012 | 11
0.3087522958678681 | 13 |  | 0.3552028805357232 | 14 |  | 0.07328869461079757 | 17 |  | 0.1855787425842137 | 15 |  | 0.1945128901044866 | 16
0.2009966019635654 | 16 |  | 0.008857504954522977 | 19 |  | 0.3885458795745893 | 10 |  | 0.4513276967306712 | 9 |  | 0.2660984514913756 | 14
0.4481980541986701 | 9 |  | 0.5193868660174776 | 10 |  | 0.5665165272937012 | 7 |  | 0.53221895934196 | 6 |  | 0.3463886774918485 | 12
0.9965469602888988 | 1 |  | 0.8666519835173943 | 2 |  | 0.8958006417196884 | 2 |  | 0.9013601953365138 | 2 |  | 0.7119147410405084 | 6
0.4126425201573349 | 10 |  | 0.3775155617955823 | 13 |  | 0.4336497873291763 | 9 |  | 0.6282261328452918 | 5 |  | 0.5877653815146333 | 7
0.01909113485841374 | 19 |  | 0.73727417936996 | 5 |  | 0.866145257051032 | 3 |  | 0.7826926373571252 | 3 |  | 0.1694169392534415 | 18
0.208111738523914 | 15 |  | 0.6106467829671516 | 7 |  | 0.327076602678956 | 12 |  | 0.1734617338625686 | 16 |  | 0.9111463446148758 | 3
0.9410678293716344 | 3 |  | 0.6069184956134874 | 8 |  | 0.02040124494867968 | 19 |  | 0.1909023903316331 | 14 |  | 0.1909344403010149 | 17
0.707708343074329 | 6 |  | 0.6115025753849839 | 6 |  | 0.4526993052198414 | 8 |  | 0.1541932649927764 | 18 |  | 0.4909692824918741 | 9
0.5126752225619324 | 8 |  | 0.8806067941647386 | 1 |  | 0.05670373807779261 | 18 |  | 0.3582567258724918 | 12 |  | 0.1978551404267448 | 15
0.308258441091112 | 14 |  | 0.1692075072237069 | 16 |  | 0.6973304702309 | 4 |  | 0.3640428271283236 | 11 |  | 0.3262951478128362 | 13
0.03881822601932039 | 17 |  | 0.2975553695908464 | 15 |  | 0.3567713237822714 | 11 |  | 0.7623301526111774 | 4 |  | 0.8415876954570738 | 5
0.9382722579566236 | 4 |  | 0.8496809855922056 | 3 |  | 0.1817558820351852 | 15 |  | 0.16777338120077 | 17 |  | 0.8958006578284579 | 4
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20
0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20 |  | 0 | 20