Spreadsheet: 57019d1257197956-if-statement-with-formulas-cdb09oct
Sheet: Sales & Trading

 | GSF Call Reports - September 2009 YTD
 | **Disclaimer: These are the call reports per CDB not per emails sent
 |  |  | Rating | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Grand Total | Monthly Average * | Monthly Target | Actual vs Target (%)
 | [NAME] |  | B | 6 | 3 | 0 | 11 | 1 | 2 | 2 | 4 | 3 | 0 |  |  | 32 | 3.2 | 2 | 1.6
 | [NAME] |  | B | 0 | 1 | 3 | 1 | 2 | 1 | 2 | 3 | 1 | 1 |  |  | 15 | 1.5 | 1 | 1.5
 | [NAME] |  | B | 3 | 4 | 2 | 2 | 4 | 0 | 4 | 0 | 0 | 3 |  |  | 22 | 2.2 | 2 | 1.1
 | [NAME] |  | B | 2 | 0 | 2 | 0 | 3 | 0 | 0 | 2 | 0 | 1 |  |  | 10 | 1 | 1 | 1
 | [NAME] |  | B | 4 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 1 |  |  | 10 | 1 | 1 | 1
 | [NAME] |  | B | 0 | 1 | 6 | 5 | 0 | 0 | 2 | 1 | 5 | 9 |  |  | 29 | 2.9 | 3 | 0.9666666666666666
 | [NAME] |  | B | 3 | 0 | 7 | 1 | 1 | 3 | 4 | 0 | 2 | 7 |  |  | 28 | 2.8 | 3 | 0.9333333333333331
 | [NAME] |  | B | 2 | 5 | 4 | 5 | 0 | 2 | 4 | 3 | 0 | 0 |  |  | 25 | 2.5 | 3 | 0.8333333333333334
 | [NAME] |  | B | 3 | 1 | 4 | 3 | 3 | 3 | 1 | 2 | 3 | 1 |  |  | 24 | 2.4 | 3 | 0.7999999999999999
 | Greg |  | B | 1 | 2 | 5 | 4 | 5 | 2 | 0 | 1 | 4 | 0 |  |  | 24 | 2.4 | 4 | 0.6
 | [NAME] |  | B | 2 | 1 | 1 | 2 | 2 | 2 | 0 | 0 | 2 | 0 |  |  | 12 | 1.2 | 2 | 0.6
 | [NAME] |  | D | 1 | 0 | 2 | 2 | 2 | 1 | 2 | 3 | 2 | 2 |  |  | 17 | 1.7 | 3 | 0.5666666666666667
 | Scott |  | D | 0 | 0 | 3 | 3 | 2 | 4 | 4 | 3 | 3 | 0 |  |  | 22 | 2.2 | 4 | 0.55
 | [NAME] |  | D | 0 | 0 | 8 | 3 | 0 | 5 | 0 | 6 | 0 | 0 |  |  | 22 | 2.2 | 4 | 0.55
 | [NAME] |  | D | 2 | 2 | 0 | 3 | 2 | 0 | 2 | 3 | 2 | 4 |  |  | 20 | 2 | 4 | 0.5
 | [NAME] |  | D | 3 | 2 | 0 | 2 | 3 | 2 | 1 | 1 | 0 | 1 |  |  | 15 | 1.5 | 3 | 0.5
 | [NAME] |  | E | 0 | 0 | 0 | 6 | 1 | 1 | 0 | 2 | 1 | 2 |  |  | 13 | 1.3 | 3 | 0.4333333333333333
 | [NAME] |  | E | 0 | 0 | 6 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |  |  | 8 | 0.8 | 2 | 0.4000000000000001
 | [NAME] |  | E | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 3 |  |  | 4 | 0.4 | 1 | 0.4000000000000001
 | Stew |  | E | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 0 | 0 | 1 |  |  | 9 | 0.9 | 3 | 0.3
 | [NAME] |  | E | 0 | 0 | 0 | 1 | 2 | 0 | 3 | 1 | 1 | 1 |  |  | 9 | 0.9 | 3 | 0.3
 | Dawn |  | E | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |  |  | 3 | 0.3 | 1 | 0.3
 | Christel |  | E | 2 | 0 | 3 | 0 | 3 | 0 | 0 | 1 | 1 | 1 |  |  | 11 | 1.1 | 4 | 0.275
 | [NAME] |  | E | 0 | 0 | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |  |  | 4 | 0.4 | 3 | 0.1333333333333334
 | [NAME] |  | E | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0.3 | 3 | 0.09999999999999999
 | Cain |  | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 1 | 0
 | Jeremy |  | No a/c's | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | 0.2
 | [NAME] |  | No a/c's | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | 0.2
 | Hilary |  | No a/c's | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | 0.1
 | Rich |  | No a/c's |  |  |  |  |  |  |  | 4 | 1 | 10 |  |  | 15 | 1.5
 | [NAME] |  | No a/c's | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | 0.3
 | Grand Total |  |  | 38 | 26 | 59 | 58 | 44 | 29 | 37 | 42 | 32 | 49 | 0 | 0 | 414 | 41.39999999999998 | 67
 | * Adjusted for anyone joining during the year
 | Refer to GSF Policy - Staff [NAME] (June 2007) for further information on the ratings
 | GSF Overall (including leavers)
 | 2009 |  |  | 39 | 27 | 59 | 58 | 44 | 29 | 37 | 43 | 32 | 49 |  |  | 417
 | 2008 |  |  | 28 | 44 | 66 | 54 | 48 | 87 | 36 | 39 | 43 | 46 | 102 | 30 | 623
 | 2007 |  |  | 38 | 27 | 48 | 30 | 41 | 72 | 34 | 28 | 67 | 89 | 48 | 28 | 550
 | 2006 |  |  | 65 | 68 | 82 | 57 | 37 | 137 | 83 | 88 | 67 | 166 | 61 | 17 | 928