 |
||
| Home |
|
|
| Module 1 | ||
| Module 2 | ||
| Module 3 | ||
| Module 4 | ||
| Module 5 | ||
| Module 6 | ||
| Module 7 | ||
| Module E | ||
| Links | ||
| Maths
Marks |
|
Unit
1 |
|
|
|
|
|
| Pass
mark |
70 |
|
|
|
|
|
|
| |
|
Week
1 |
Week
2 |
Week
3 |
Total |
Average |
|
| Vicky |
|
80 |
74 |
79 |
=SUM(C4:E4) |
=AVERAGE(C4:E4) |
=IF(G4>=$B$2,"PASS","FAIL") |
| Bruce |
Curtis |
75 |
86 |
66 |
=SUM(C5:E5) |
=AVERAGE(C5:E5) |
=IF(G5>=$B$2,"PASS","FAIL") |
| Janine
|
|
45 |
53 |
61 |
=SUM(C6:E6) |
=AVERAGE(C6:E6) |
=IF(G6>=$B$2,"PASS","FAIL") |
| Jodie |
Kopek |
50 |
63 |
59 |
=SUM(C7:E7) |
=AVERAGE(C7:E7) |
=IF(G7>=$B$2,"PASS","FAIL") |
| Amir |
Seleme |
91 |
89 |
78 |
=SUM(C8:E8) |
=AVERAGE(C8:E8) |
=IF(G8>=$B$2,"PASS","FAIL") |
|
Boulters Fixings |
|
|
|
||
|
1st
Quarter Sales Figures |
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales
person |
January |
February |
March |
Total |
% |
|
Ali |
15678 |
11555 |
20234 |
=SUM(B5:D5) |
=(E5/$E$10)*100 |
|
William |
30238 |
15453 |
22923 |
=SUM(B6:D6) |
=(E6/$E$10)*100 |
|
Clare |
25112 |
12034 |
18763 |
=SUM(B7:D7) |
=(E7/$E$10)*100 |
|
Kim |
12001 |
19897 |
23011 |
=SUM(B8:D8) |
=(E8/$E$10)*100 |
|
Quasim |
26856 |
17311 |
24998 |
=SUM(B9:D9) |
=(E9/$E$10)*100 |
|
|
|
|
TOTAL |
=SUM(E5:E9) |
|