Spreadsheet: 78847d1279140454-excel-2007-copy-data-from-a-cell-based-on-the-colour-of-the-cell-and-paste-into-another-cell-test-spreadsheet
Sheet: Sheet1

 |  |  |  | Test |  |  | TA |  |  | Est | Subject | % chance of achieving [NAME] |  |  |  |  |  |  |  | % chance |  | Grades
Name | DoB | Sex | KS | EN | MA | SC | EN | MA | SC | Basis | Group | G | F | E | D | C | B | A | A* | A*-C | Pass | Est1 | Est2
Smith, Fred | 1995-10-10 00:00:00 | M | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | Art&Des | G | F | E | D | C | B | A | A* | 0.91 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | Art&Des | G | F | E | D | C | B | A | A* | 0.92 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | CreatArt | G | F | E | D | C | B | A | A* | 0.96 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | CreatArt | G | F | E | D | C | B | A | A* | 0.97 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | D&T | G | F | E | D | C | B | A | A* | 0.94 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | D&T | G | F | E | D | C | B | A | A* | 0.95 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | English | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | English | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | Geography | G | F | E | D | C | B | A | A* | 0.98 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | Geography | G | F | E | D | C | B | A | A* | 0.98 | 0.99 | * | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | History | G | F | E | D | C | B | A | A* | 0.97 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | History | G | F | E | D | C | B | A | A* | 0.98 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | Hu'ties | G | F | E | D | C | B | A | A* | 0.96 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | Hu'ties | G | F | E | D | C | B | A | A* | 0.97 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | ICT | G | F | E | D | C | B | A | A* | 0.94 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | ICT | G | F | E | D | C | B | A | A* | 0.96 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | Maths | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | Maths | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | * | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | MFL | G | F | E | D | C | B | A | A* | 0.92 | 0.99 | A | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | MFL | G | F | E | D | C | B | A | A* | 0.93 | 0.99 | A | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | PE | G | F | E | D | C | B | A | A* | 0.97 | 0.99 | * | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | PE | G | F | E | D | C | B | A | A* | 0.97 | 0.99 | * | *
 |  |  | 2 | 5.4 | 5.7 | 5.4 | 5 | 5 | 5 | SE | Science | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | * | *
 |  |  | 3 |  |  |  | 7 | 8 | 6 | SE | Science | G | F | E | D | C | B | A | A* | 0.99 | 0.99 | A | *
Jones, [NAME] | 1994-12-19 00:00:00 | M | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | Art&Des | G | F | E | D | C | B | A | A* | 0.77 | 0.99 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | Art&Des | G | F | E | D | C | B | A | A* | 0.71 | 0.99 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | CreatArt | G | F | E | D | C | B | A | A* | 0.72 | 0.99 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | CreatArt | G | F | E | D | C | B | A | A* | 0.69 | 0.99 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | D&T | G | F | E | D | C | B | A | A* | 0.69 | 0.98 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | D&T | G | F | E | D | C | B | A | A* | 0.61 | 0.98 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | English | G | F | E | D | C | B | A | A* | 0.67 | 0.99 | C | B
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | English | G | F | E | D | C | B | A | A* | 0.69 | 0.99 | C | B
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | Geography | G | F | E | D | C | B | A | A* | 0.73 | 0.99 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | Geography | G | F | E | D | C | B | A | A* | 0.62 | 0.99 | C | B
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | History | G | F | E | D | C | B | A | A* | 0.64 | 0.99 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | History | G | F | E | D | C | B | A | A* | 0.59 | 0.99 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | Hu'ties | G | F | E | D | C | B | A | A* | 0.65 | 0.99 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | Hu'ties | G | F | E | D | C | B | A | A* | 0.62 | 0.98 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | ICT | G | F | E | D | C | B | A | A* | 0.69 | 0.98 | C | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | ICT | G | F | E | D | C | B | A | A* | 0.65 | 0.98 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | Maths | G | F | E | D | C | B | A | A* | 0.92 | 0.99 | B | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | Maths | G | F | E | D | C | B | A | A* | 0.82 | 0.99 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | MFL | G | F | E | D | C | B | A | A* | 0.54 | 0.99 | D | B
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | MFL | G | F | E | D | C | B | A | A* | 0.52 | 0.99 | D | B
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | PE | G | F | E | D | C | B | A | A* | 0.77 | 0.99 | B | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | PE | G | F | E | D | C | B | A | A* | 0.71 | 0.99 | C | A
 |  |  | 2 | 3.7 | 5 | 5.2 | 4 | 5 | 5 | SE | Science | G | F | E | D | C | B | A | A* | 0.88 | 0.99 | B | A
 |  |  | 3 |  |  |  | 5 | 6 | 5 | SE | Science | G | F | E | D | C | B | A | A* | 0.76 | 0.99 | C | A