Spreadsheet: 133123d1324200800-finding-sum-and-rank-fruit-stuff-rank
Sheet: Week data and ranks

 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO % |  | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1 |  | 5149.44 | 0 |  | 96 |  | 112 | 12 |  | 7 | 4 |  | 62 | 2 |  | 72 | 5 |  | 1
2 |  | 9579.86 | 100 |  | 188 |  | 244 | 17 |  | 9 | 2 |  | 121 | 1 |  | 129 | 4 |  | 2
3 |  | 6000.62 | 43 |  | 116 |  | 156 | 24 |  | 10 | 4 |  | 60 | 3 |  | 78 | 14 |  | 3
4 |  | 3857.01 | 56 |  | 70 |  | 101 | 6 |  | 5 | 2 |  | 46 | 5 |  | 52 | 1 |  | 4
5 |  | 6171.91 | 0 |  | 101 |  | 152 | 21 |  | 15 | 7 |  | 51 | 2 |  | 63 | 6 |  | 5
6 |  | 0 | 0 |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 |  | 8754.61 | 0 |  | 166 |  | 231 | 35 |  | 16 | 11 |  | 104 | 9 |  | 16 | 11 |  | 7
8 |  | 4781.21 | 0 |  | 41 |  | 70 | 2 |  | 20 | 2 |  | 19 | 0 |  | 23 | 2 |  | 8
9 |  | 1617.66 | 0 |  | 33 |  | 43 | 0 |  | 2 | 0 |  | 22 | 0 |  | 22 | 0 |  | 9
10 |  | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  | 0 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  | 1556.98 |  |  | 22 |  | 38 | 1 |  | 3 | 0 |  | 13 | 0 |  | 14 | 1 |  | 12
13 |  | 209.89 |  |  | 6 |  | 14 | 0 |  | 0 | 0 |  | 5 | 0 |  | 6 | 0 |  | 13
14 |  | 4009.7 |  |  | 82 |  | 116 | 31 |  | 6 | 2 |  | 56 | 0 |  | 61 | 3 |  | 14
15 |  | 1358.22 |  |  | 30 |  | 63 | 0 |  | 1 | 0 |  | 11 | 0 |  | 16 | 0 |  | 15
16 |  | 5892.67 |  |  | 63 |  | 93 | 4 |  | 15 | 1 |  | 44 | 0 |  | 48 | 2 |  | 16
17 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  | 3076.42 |  |  | 65 |  | 90 | 10 |  | 6 | 5 |  | 37 | 6 |  | 42 | 4 |  | 18
19 |  | 5061.32 |  |  | 98 |  | 148 | 4 |  | 8 | 4 |  | 62 | 1 |  | 71 | 1 |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL OF ALL THE WEEKS….
NOV 27 - DEC 3 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1 |  | 3964.85 | 652.25 |  | 102 |  | 120 | 11 |  | 9 | 6 |  | 71 | 9 |  | 81 | 5
2 |  | 4541.88 |  |  | 117 |  | 157 | 7 |  | 8 | 6 |  | 98 | 3 |  | 109 | 4
3 |  | 4803.37 |  |  | 117 |  | 141 | 17 |  | 11 | 6 |  | 71 | 3 |  | 87 | 13
4 |  | 4397.34 |  |  | 86 |  | 119 | 4 |  | 8 | 5 |  | 57 | 15 |  | 65 | 2
5 |  | 1501.57 | 154.25 |  | 48 |  | 57 | 14 |  | 2 | 1 |  | 29 | 10 |  | 32 | 1
6 |  | 0 |  |  | 0
7 |  | 3968.39 | 214.11 |  | 89 |  | 115 | 16 |  | 6 | 6 |  | 61 | 11 |  | 73 | 6
8 |  | 447.17 | 56.78 |  | 12 |  | 15 | 0 |  | 0 | 0 |  | 7 | 0 |  | 7 | 0
9 |  | 228.96 |  |  | 12 |  | 15 | 0 |  | 1 | 0 |  | 14 | 0 |  | 16 | 0
10 |  | 0 |  |  | 0
11 |  | 1573.89 |  |  | 26 |  | 35 | 2 |  | 2 | 1 |  | 16 | 0 |  | 19 | 2
12 |  | 1585.47 |  |  | 31 |  | 35 | 0 |  | 4 | 3 |  | 18 | 0 |  | 20 | 1
13 |  | 513.77 |  |  | 14 |  | 22 | 1 |  | 1 | 0 |  | 13 | 0 |  | 13 | 0
14 |  | 1415.24 |  |  | 25 |  | 34 | 8 |  | 4 | 1 |  | 17 | 3 |  | 18 | 1
15 |  | 914.67 |  |  | 27 |  | 31 | 7 |  | 0 | 0 |  | 16 | 0 |  | 17 | 0
16 |  | 0 |  |  | 0
17 |  | 0 |  |  | 0
18 |  | 1477.2 |  |  | 25 |  | 23 | 6 |  | 4 | 2 |  | 11 | 2 |  | 17 | 3
19 |  | 1795.25 |  |  | 47 |  | 67 | 4 |  | 2 | 1 |  | 38 | 5 |  | 44 | 1
DEC 4 - DEC 10 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1 |  | 42.35 | 17.54 |  | 94 |  | 140 | 25 |  | 13 | 10 |  | 61 | 10 |  | 74 | 4
2 |  | 1054.45 | 652.2 |  | 116 |  | 178 | 31 |  | 9 | 6 |  | 77 | 1 |  | 87 | 6
3 |  | 985.1 | 225.64 |  | 79 |  | 131 | 25 |  | 8 | 6 |  | 50 | 6 |  | 63 | 3
4 |  | 567.16 | 45.56 |  | 136 |  | 219 | 36 |  | 12 | 9 |  | 85 | 17 |  | 98 | 3
5 |  | 254.5 | 61.55 |  | 58 |  | 78 | 27 |  | 1 | 0 |  | 26 | 12 |  | 31 | 1
6 |  |  |  |  | 0
7 |  | 565.64 | 3510.22 |  | 125 |  | 225 | 20 |  | 13 | 7 |  | 74 | 7 |  | 94 | 8
8 |  |  |  |  | 0
9 |  | 646.5 | 387.53 |  | 11 |  | 19 | 1 |  | 1 | 0 |  | 7 | 0 |  | 7 | 0
10 |  |  |  |  | 0
11 |  | 652.66 | 459.64 |  | 22 |  | 35 | 9 |  | 1 | 1 |  | 10 | 2 |  | 13 | 1
12 |  | 121.2 | 323.72 |  | 16 |  | 35 | 8 |  | 0 | 0 |  | 11 | 1 |  | 15 | 2
13 |  |  |  |  | 0
14 |  | 6796.64 | 535.81 |  | 21 |  | 25 | 5 |  | 2 | 3 |  | 11 | 6 |  | 12 | 1
15 |  | 64.64 | 12.6 |  | 28 |  | 39 | 10 |  | 1 | 0 |  | 8 | 3 |  | 13 | 5
16 |  | 6433.89 | 124.45 |  | 13 |  | 9 | 5 |  | 1 | 1 |  | 14 | 0 |  | 15 | 1
17 |  |  |  |  | 0
18 |  | 8632.25 | 593.18 |  | 25 |  | 33 | 11 |  | 3 | 3 |  | 19 | 1 |  | 22 | 0
19 |  | 65.36 | 10.2 |  | 33 |  | 51 | 5 |  | 3 | 3 |  | 22 | 1 |  | 27 | 1
DEC 11 - DEC 17 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
DEC 18 - DEC 24 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
DEC 25 - DEC 31 | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
JAN 1 - JAN 7       2012! | RANK | TOTAL SALES | Apples | APPPLES % | Trans | $ per Trans | ORANGES CHANCES | ORANGES # | Oranges % | BANANA CHANCES | BANANAS | BANANA % | GRAPES CHANCES | GRAPES # | GRAPES % | POTATO CHANCES | POTATOES | POTATO %
Dayna
[NAME]
Darrin
[NAME]
[NAME]
[NAME]
Zach
[NAME]
[NAME]
Jared
[NAME]
Will
Tre
Sierra
[NAME]
Rae
[NAME]
[NAME]
Caleb