Spreadsheet: 274084d1383003695-help-creating-a-formula-descending-numbers-with-names-attach-to-them-2013-q4-week-4
Sheet: WEEK 2

WEEK |  | 2 |  |  |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 1 |  |  |  | WEEK |  | 3 |  |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 2
HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE |  | HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK | SAT. | MON. | TUE. | WED. | THUR. | FRI. | SAT
RTE. / SDO |  |  |  |  | 10 |  |  | 2013-10-05 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | WEEKLY TOTALS |  |  | RTE. / SDO |  |  |  |  | 10 |  | 2013-10-12 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00
SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  |  | A | B | C | D | E | F |  |  |  | SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  | F | A | B | C | D | E | E
 |  | 4 | A | [NAME] |  | 12.63 | OT | 8 | 1.57 | W / | 1.66 | 1.03 | W | 12.26 | 24.89 |  |  |  | 4 | A | [NAME] |  | 24.89 |  | COLUMBUS |  |  |  |  |  | 1-D | 56-B
 |  |  |  |  |  |  | POP | REFUSED |  |  |  |  |  | 0
 |  | 7 | A | TAYLOR |  | 11.18 | OT | 8 | SL | SL | SL | 1.26 | 0.64 | 9.9 | 21.08 |  |  |  | 53 | A | PERKINS |  | 24.58 |  |  |  |  |  |  |  | 2-A | 57-E
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 53 | A | PERKINS |  | 12.44 | OT | 8 | 1.92 | 0.28 | 1.94 | W | W | 12.14 | 24.58 |  |  |  | 7 | A | TAYLOR |  | 21.08 |  | DAY |  |  |  |  |  | 3-F | 58-D
 |  |  |  |  |  |  | POP | REFUSED |  |  |  |  |  | 0
 |  | R1 | A | BOWLING |  | 0 | OT | NS | LP | 1.41 | 1.87 | W / | W / | 3.28 | 3.28 |  |  |  | 58 | D | DREW |  | 18.04 |  |  |  |  |  |  |  | 4-A | 61-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 8 | B | SMITH | ü | 5.23 | OT | 1.37 | 8 | W | W / | W | W | 9.370000000000001 | 14.6 |  |  |  | 57 | E | BELINSKI | ü | 17.81 |  | COLUMBUS |  |  |  |  |  | 7-A | 63-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 23 | B | YAWITZ |  | 4.1 | OT | W / | NS | W / | 1.93 | 1.77 | 0.77 | 4.470000000000001 | 8.57 |  |  |  | 63 | F | [NAME] |  | 17.81 |  |  |  |  |  |  |  | 8-B | 64-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 56 | B | SEROTTE |  | 5.49 | OT | 1.46 | NS | 1 | W | 1.92 | 1.04 | 5.42 | 10.91 |  |  |  | 10 | D | [NAME] |  | 16.54 |  | DAY |  |  |  |  |  | 9-E | 65-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 68 | B | WILCOX |  | 0 | OT | SL | NS | SL | SL | SL | SL | 0 | 0 |  |  |  | 46 | E | RIEFLE | ü | 15.97 |  |  |  |  |  |  |  | 10-D | 68-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U5 | B | ROBY |  | 10.19 | OT | 1.84 | NS | 0.68 | W | 2 | 1.04 | 5.56 | 15.75 |  |  |  | U5 | B | ROBY |  | 15.75 |  | COLUMBUS |  |  |  |  |  | 11-D | U2-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 22 | C | CRAWFORD |  | 1.46 | OT | 1.3 | 1.88 | NS | 1.83 | W | 1.02 | 6.029999999999999 | 7.489999999999999 |  |  |  | 16 | D | FREEBERSYSER |  | 15.51 |  |  |  |  |  |  |  | 12-E | U3-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 52 | C | FICHTINGER |  | 0 | OT | SL | SL | NS | SL | SL | SL | 0 | 0 |  |  |  | 8 | B | SMITH | ü | 14.6 |  | DAY |  |  |  |  |  | 16-D | U4-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U3 | C | MORAN |  | 4.67 | OT | 1.21 | 0.61 | NS | 0.14 | W | 1.43 | 3.39 | 8.059999999999999 |  |  |  | 29 | F | HEITMAN | ü | 13.96 |  |  |  |  |  |  |  | 17-A | U5-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U4 | C | HRUBY | ü | 3.47 | OT | 0.85 | 1.73 | NS | W / | W / | W | 2.58 | 6.05 |  |  |  | 56 | B | SEROTTE |  | 10.91 |  | COLUMBUS |  |  |  |  |  | 18-F | U6-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 10 | D | [NAME] |  | 12.34 | OT | 1.93 | 0.74 | W / | NS | 1.53 | SL | 4.2 | 16.54 |  |  |  | U7 | D | MORGAN |  | 10.36 |  |  |  |  |  |  |  | 20-E | U7-D
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 16 | D | FREEBERSYSER |  | 10.4 | OT | SL | 1.78 | 1.74 | NS | 1.59 | W | 5.11 | 15.51 |  |  |  | 23 | B | YAWITZ |  | 8.57 |  | DAY |  |  |  |  |  | 22-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 58 | D | DREW |  | 13.8 | OT | 1.75 | 0.75 | W | NS | 1.74 | W | 4.24 | 18.04 |  |  |  | 28 | E | HUSTER | ü | 8.08 |  |  |  |  |  |  |  | 23-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U7 | D | MORGAN |  | 9.03 | OT | SL | 0.77 | W / | NS | SL | 0.56 | 1.33 | 10.36 |  |  |  | U3 | C | MORAN |  | 8.059999999999999 |  | COLUMBUS |  |  |  |  |  | 25-D
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 28 | E | HUSTER | ü | 3.48 | OT | 0.99 | 1.69 | W | 1.92 | NS | W | 4.6 | 8.08 |  |  |  | 22 | C | CRAWFORD |  | 7.489999999999999 |  |  |  |  |  |  |  | 26-A
 |  |  |  |  |  |  | POP |  |  |  |  | CALLED |  | 0
 |  | 46 | E | RIEFLE | ü | 11.64 | OT | 1.18 | 1.93 | W | 1.22 | NS | W | 4.33 | 15.97 |  |  |  | U4 | C | HRUBY | ü | 6.05 |  | DAY |  |  |  |  |  | 28-E
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 57 | E | BELINSKI | ü | 4.5 | OT | 0.42 | 1.68 | W | 1.61 | 8 | 1.6 | 13.31 | 17.81 |  |  |  | 36 | F | KESLER |  | 5.48 |  |  |  |  |  |  |  | 29-F
 |  |  |  |  |  |  | POP |  |  |  |  | REFUSED |  | 0
 |  | 29 | F | HEITMAN | ü | 10.79 | OT | 1.4 | W | W | 0.88 | 0.89 | NS | 3.17 | 13.96 |  |  |  | R1 | A | BOWLING |  | 3.28 |  | COLUMBUS |  |  |  |  |  | 30-AUX
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 36 | F | KESLER |  | 0 | OT | SL | 1.65 | 0.62 | 1.96 | 1.25 | NS | 5.48 | 5.48 |  |  |  | 68 | B | WILCOX |  | 0 |  |  |  |  |  |  |  | 36-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 63 | F | [NAME] |  | 11.75 | OT | 2 | 1.99 | W | 1.5 | 0.57 | NS | 6.06 | 17.81 |  |  |  | 52 | C | FICHTINGER |  | 0 |  | DAY |  |  |  |  |  | 46-E
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | EAISLEY |  |  |  | CCA |  |  |  |  |  | 52-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | BENSINGER |  |  |  | CCA |  |  |  |  |  | 53-A
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | HASKELL |  |  |  | CCA
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | EVANS |  |  |  | CCA
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
[NAME] |  |  |  | COLUMN TOTAL |  |  |  | 41.7 | 28.69 | 5.73 | 18.46 | 23.55 | 8.1 | 126.23 | 284.82
 |  |  |  | COLUMN AVERAGE |  |  |  | 1.81304347826087 | 1.247391304347826 | 0.2491304347826087 | 0.802608695652174 | 1.023913043478261 | 0.3521739130434782 | 5.488260869565218 | 12.38347826086956
WEEK |  | 2 |  | WORK ASSIGNMENT |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 1
HOLDOWN |  |  |  | NO OVERTIME |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | A | B | C | D | E | F
 |  | 11 | D | DULANEY | WA | 3.98 | OT |  | 2 |  | NS | 1.5 |  | 3.5 | 7.48
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 25 | D | SCROGGINS | WA | 0 | OT | AL | 1.76 | 0.24 | NS | SL | 0.77 | 2.77 | 2.77
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 18 | F | [NAME] | WA | 4.1 | OT |  | 2 | 0.43 | 1.51 | 0.66 | NS | 4.600000000000001 | 8.89
 |  |  |  |  |  |  | POP |  | 0.19 |  |  |  |  | 0.19
 |  | 9 | E | HORBELT | WA | 2.05 | OT |  | 1.88 | 0.48 | 0.97 | NS | 0.53 | 3.86 | 5.91
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 17 | A | HUMBERD | WA | 2.86 | OT | NS | 2 | 0.51 | 1.95 |  |  | 4.46 | 7.92
 |  |  |  |  |  |  | POP |  | 0.6 |  |  |  |  | 0.6
 |  | 20 | E | MALIN | NONE | 0 | OT |  | 0.31 |  | 0.51 | NS |  | 0.8200000000000001 | 0.8200000000000001
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 12 | E | GRILLO | WA | 0 | OT | 1.5 | 1.93 | 0.88 | 0.61 | NS |  | 4.92 | 4.92
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 65 | F | WELBY | WA | 0 | OT |  | 0.61 |  |  |  | NS | 0.61 | 0.61
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 | D | 64 | C | FRAZIER | WA | 0 | OT |  | 0.63 |  | NS | AL | AL | 0.63 | 0.63
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U2 | C | [NAME] | WA | 0 | OT | AL | AL | NS | AL |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 61 | B | DAVIS | WA | 2.31 | OT |  | NS |  |  |  |  | 0 | 2.31
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 2 | A | [NAME] | WA | 3.49 | OT | NS | 1.71 |  | 2 | 2 | 1.47 | 7.18 | 10.67
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 1 | D | BOLIN | WA | 0.15 | OT |  | 0.87 |  | NS |  |  | 0.87 | 1.02
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 3 | F | GREEN | WA | 0.81 | OT |  | 1.82 |  | 0.19 |  | NS | 2.01 | 2.82
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U6 | C | SPENCE | WA | 8 | OT | HL | HL | HL | HL | 8 | HL | 8 | 16
 |  |  |  |  |  |  | POP |  |  |  |  | HL |  | 0
 |  | 26 | A | HENLEY | WA | 3.63 | OT | NS | 1.77 |  | 1.82 | 1.94 | 1.47 | 6.999999999999999 | 10.63
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
WEEK |  | 2 |  | CCA |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 1
HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 2013-10-05 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | A | B | C | D | E | F
 |  |  |  | EAISLEY | CCA | 36.37 | W | NS | 9.28 | 9.03 | 10.04 | 9.42 | 7.99 | 45.76 | 82.13
 |  |  |  |  |  | 12.37 | OT |  | 1.28 | 1.03 | 2 | 1.42 |  | 5.73 | 18.1
 |  |  |  |  |  | 0 | POP |  |  |  | 0.04 |  |  | 0.04 | 0.04
 |  |  |  | BENSINGER | CCA | 39.54 | W | 9.3 | 9.46 | NS | 9.67 | 9.53 | 8.09 | 46.05 | 85.59
 |  |  |  |  |  | 12.92 | OT | 1.3 | 1.46 |  | 1.67 | 1.53 | 0.09 | 6.05 | 18.97
 |  |  |  |  |  | 2.62 | POP |  |  |  |  |  |  | 0 | 2.62
 |  |  |  | HASKELL | CCA | 37.11 | W | 9.72 | 9.89 | NS | 9.93 | 9.46 | 8.79 | 47.79 | 84.9
 |  |  |  |  |  | 12.3 | OT | 1.72 | 1.89 |  | 1.93 | 1.46 | 0.79 | 7.79 | 20.09
 |  |  |  |  |  | 0.81 | POP |  |  |  |  |  |  | 0 | 0.81
 |  |  |  | EVANS | CCA | 37.23 | W | 9.5 | 11.36 | NS | 9.14 | 9.6 | 8.39 | 47.99 | 85.22
 |  |  |  |  |  | 12.5 | OT | 1.5 | 2 |  | 1.14 | 1.6 | 0.39 | 6.63 | 19.13
 |  |  |  |  |  | 0.7300000000000001 | POP |  | 1.36 |  |  |  |  | 1.36 | 2.09
 |  |  |  |  |  | 0 | W |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | POP |  |  |  |  |  |  | 0 | 0