Spreadsheet: 103360d1301085714-countifs-for-multiple-conditions-gemma
Sheet: Queen's Legacy

 | 2009-08-06 00:00:00 |  |  |  | Queen's Legacy
 | Past race performance/ placement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last updated |  |  |  | 2009-08-06 00:00:00
 |  | fast | firm | good | yield | mud | soft | Totals |  | Runs | Place | Win | PL% | Win% | Total | Seasons
 | 1000 |  |  |  |  |  |  |  | 1000 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! |  | Noms |  | earnings |  | P/L |  | Runs |  | Places |  | Wins |  | %
 | 1200 |  |  |  |  |  |  |  | 1200 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | 20th |  |  |  |  | 0 |  |  |  |  |  |  |  | #[NAME]!
 | 1400 |  |  |  |  |  |  |  | 1400 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | 21st |  |  |  |  | 0 |  |  |  |  |  |  |  | #[NAME]!
 | 1600 |  |  |  |  |  |  |  | 1600 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | 22nd |  |  |  |  | 0 |  |  |  |  |  |  |  | #[NAME]!
 | 1800 |  |  |  |  |  |  | 1 | 1800 | 1 | 0 | 1 | 0 | 1 | 1 | 23rd |  |  |  |  | 0 |  |  |  |  |  |  |  | #[NAME]!
 | 2200 |  |  |  |  |  |  | 0.62 | 2200 | 4 | 2 | 1 | 0.5 | 0.25 | 0.75 | 24th |  |  |  |  | 0 |  |  |  |  |  |  |  | #[NAME]!
 | 2400 |  |  |  |  |  |  | 0.77 | 2400 | 3 | 3 | 0 | 1 | 0 | 1 | 25th | 56.55 |  | 87.1 |  | 30.55 |  | 8 |  | 5 |  | 2 |  | 0.875
 | 2850 |  |  |  |  |  |  | 0.62 | 2850 | 1 | 0 | 0 | 0 | 0 | 0 | 26th | 7.68 |  | 0 |  | -7.68 |  | 1 |  | 0 |  | 0 |  | 0
 | 3200 |  |  |  |  |  |  |  | 3200 |  |  |  | #[NAME]! | #[NAME]! | #[NAME]! | Total | 64.22999999999999 |  | 87.1 |  | 22.87 |  | 9 |  | 5 |  | 2 |  | 0.7777777777777778
 | Totals | 1 | 1 | 0.63 | 0.5 |  | 0.75 | 0.71
 |  |  | 2yrs | Grades |  | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200 |  | Above or below random average |  |  |  |  |  |  |  | Death Date |  |  |  | 2011-03-31 00:00:00
 |  |  | Fast |  |  |  | 20 |  |  |  |  | 12 | 13 | 27
 | Rating |  | Firm |  |  |  | 20 |  |  |  | 12 | 12 | 13 |  |  | Random |  |  |  |  | 0.2203 |  |  | Career Profit Possible |  |  |  | 831.8475120385233
 | 27.96950240770465 |  | Good |  |  | 25 | 19 | 16 | 15 | 14 | 10 | 9 | 10 | 23
 |  |  | Yielding |  |  |  |  |  |  |  | 23 | 19 | 21 |  |  | Had some very decent randoms so what out for the tide to turn, appears to be best on 2400m train fully at that distance for 2 cycles but without a doubt only to run on fast,firm and good so it seems.
 |  |  | Muddy |  |  |  | 23 |  |  |  |  | 15 | 16
 |  |  | Soft |  |  |  |  |  |  |  |  | 17 | 16
 |  |  | 3yrs | Grades |  | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200
 |  |  | Fast
 | Rating |  | Firm |  |  |  |  |  |  |  |  | 10
 | 43.25 |  | Good |  |  |  |  |  |  |  | 8 | 9 | 12
 |  |  | Yielding |  |  |  |  |  |  |  |  | 18
 |  |  | Muddy
 |  |  | Soft |  |  |  |  |  |  |  |  | 13
 |  |  | 4yrs+ | Grades |  | 1000 | 1200 | 1400 | 1600 | 1800 | 2200 | 2400 | 2850 | 3200
 |  |  | Fast
 | Rating |  | Firm
 | 0 |  | Good
 |  |  | Yielding
 |  |  | Muddy
 |  |  | Soft
 |  |  | Barriers last updated |  |  |  |  | 2009-08-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days left |  | 601.2925152777752 |  |  | Auction Value left
 | Grades |  | Champ ? |  | High added |  | Low added |  | $100 |  | $75 |  | $50 |  | $35 |  | $25 |  | $15
 | 4yr+ |  | 1 to 3 |  | 4 to 6 |  | 7 to 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 to 15 |  | 16 to 20 |  |  | % |  | 0.8236883770928428 |  |  | 436.839125688117
 | 3yr |  | 1 to 4 |  | 5 to 8 |  | 9 to 12 |  | [NAME] for when conditions are completed.
 | 2yr |  | 1 to 5 |  | 6 to 10 |  | 11 to 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Gr1 [NAME] |  |  |  | = | 21.3658507223114