Spreadsheet: 273316d1382665890-excel-ranking-with-multiple-conditions-rank_function_master_file
Sheet: Sheet3

 |  | Event | Time | Details | lay | RANK (Automation)
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 3.3
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 3.4
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 8.4
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 7.2
 |  | [NAME] 20th Oct | 13:40:00 | 5f Nov Stks | 7.2
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 4.2
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 3.7
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 7.8
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 3.65
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 20
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 44
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 160
 |  | Chelt 20th Oct | 14:00:00 | 3m1f Nov Hrd | 340
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 4.5
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 6.6
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 3.7
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 9.4
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 7.6
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 11
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 110
 |  | Kelso 20th Oct | 14:05:00 | 2m [NAME] | 520
 |  | [NAME] 20th Oct | 14:15:00 | 7f Nursery | 5.1
 |  | [NAME] 20th Oct | 14:15:00 | 7f Nursery | 3.3
 |  | [NAME] 20th Oct | 14:15:00 | 7f Nursery | 2.88
 |  | [NAME] 20th Oct | 14:15:00 | 7f Nursery | 10.5
 |  | [NAME] 20th Oct | 14:15:00 | 7f Nursery | 20
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 5.4
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 11.5
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 14.5
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 9.2
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 19
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 16.5
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 14
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 19.5
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 34
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 15.5
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 19
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 25
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 55
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 75
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 50
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 46
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 60
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 95
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 250
 |  | Chelt 20th Oct | 14:30:00 | 2m4f Hcap Chs | 160
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 2.84
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 2.74
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 7.4
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 7.6
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 270
 |  | Kelso 20th Oct | 14:40:00 | [NAME] | 900
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 8.2
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 10
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 32
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 12.5
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 12.5
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 16.5
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 20
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 19
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 29
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 11.5
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 22
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 10.5
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 70
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 9.2
 |  | [NAME] 20th Oct | 14:50:00 | 5f Hcap | 55
 |  | Chelt 20th Oct | 15:05:00 | 2m [NAME] | 2
 |  | Chelt 20th Oct | 15:05:00 | 2m [NAME] | 3.55
 |  | Chelt 20th Oct | 15:05:00 | 2m [NAME] | 5.5
 |  | Chelt 20th Oct | 15:05:00 | 2m [NAME] | 48
 |  | Chelt 20th Oct | 15:05:00 | 2m [NAME] | 120
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 3.9
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 5.5
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 5.6
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 12
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 13
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 25
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 14
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 36
 |  | Kelso 20th Oct | 15:15:00 | 3m2f Hcap Chs | 16
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 3.45
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 5.3
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 6.6
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 7.4
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 60
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 22
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 12.5
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 26
 |  | [NAME] 20th Oct | 15:25:00 | 7f [NAME] | 26
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 6.4
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 5.9
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 6.4
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 6.4
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 11.5
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 8.8
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 21
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 32
 |  | Kelso 20th Oct | 15:50:00 | 2m [NAME] | 13.5
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 2.78
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 7.8
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 15.5
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 16
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 9.6
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 19.5
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 13.5
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 130
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 12
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 30
 |  | [NAME] 20th Oct | 16:00:00 | 1m4f Claim Stks | 60
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 4.4
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 3.35
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 4.2
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 12
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 15.5
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 34
 |  | Kelso 20th Oct | 16:30:00 | 2m6f Nov Hrd | 21
 | Error | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 8.2
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 8.6
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 8.2
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 6.2
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 36
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 22
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 7.8
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 100
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 9.2
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 9.6
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 44
 |  | [NAME] 20th Oct | 16:40:00 | 7f Hcap | 65
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 18.5
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 6
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 17.5
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 23
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 7.8
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 11
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 13
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 7.4
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 40
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 17.5
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 34
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 9.2
 |  | [NAME] 20th Oct | 17:15:00 | 7f Hcap | 70
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 2.84
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 6.6
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 9
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 14.5
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 30
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 9.8
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 20
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 27
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 55
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 75
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 110
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 150
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 120
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 75
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 110
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 260
 |  | Chelt 20th Oct | 17:30:00 | 2m [NAME] | 500
 |  | Kelso 20th Oct | 17:40:00 | 2m6f Hcap Hrd | 11.5
 |  | Kelso 20th Oct | 17:40:00 | 2m6f Hcap Hrd | 5.4
 |  | Kelso 20th Oct | 17:40:00 | 2m6f Hcap Hrd | 8
 |  | Kelso 20th Oct | 17:40:00 | 2m6f Hcap Hrd | 5.8
 |  | Kelso 20th Oct | 17:40:00 | 2m6f Hcap Hrd | 9