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

WEEK |  | 3 |  |  |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 2 |  |  |  | WEEK |  | 4 |  |  |  |  |  | PAY PERIOD |  | 2013 | 23 | 1
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-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 | WEEKLY TOTALS |  |  | RTE. / SDO |  |  |  |  | 10 |  | 2013-10-19 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00
SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  |  | F | A | B | C | D | E |  |  |  | SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  | E | F | A | B | C | D | D
 |  | 4 | A | [NAME] |  | 24.89 | OT | NS | COLUMBUS | 1.29 | 1.09 | SL | SL | 2.38 | 27.27 |  |  |  | 10 | D | [NAME] |  | 30.12 |  |  |  |  |  |  |  | 1-D | 56-B
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
 |  | 7 | A | TAYLOR |  | 21.08 | OT | W |  | 1.78 | 1.9 | 0.62 | W | 4.3 | 25.38 |  |  |  | 53 | A | PERKINS |  | 28.74 |  |  |  |  |  |  |  | 2-A | 57-E
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
 |  | 53 | A | PERKINS |  | 24.58 | OT | W | DAY | 1.73 | 1.44 | 0.99 | W | 4.16 | 28.74 |  |  |  | 58 | D | DREW |  | 28.04 |  |  |  |  |  |  |  | 3-F | 58-D
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
A | F |  |  | BOWLING |  | 3.28 | OT | W |  | 1.81 | 1.24 | W | 0.49 | 3.54 | 6.82 |  |  |  | 4 | A | [NAME] |  | 27.27 |  |  |  |  |  |  |  | 4-A | 61-B
 | 29 |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
 |  | 8 | B | SMITH | ü | 14.6 | OT | 0.27 | COLUMBUS | 8 | 1.51 | W | 1.37 | 11.15 | 25.75 |  |  |  | 8 | B | SMITH | ü | 25.75 |  |  |  |  |  |  |  | 7-A | 63-F
 |  |  |  |  |  |  | POP |  |  | 7.80 ACTUAL |  |  |  | 0
 |  | 23 | B | YAWITZ |  | 8.57 | OT | W |  | 8 | 1.95 | 0.09 | 0.77 | 10.81 | 19.38 |  |  |  | 7 | A | TAYLOR |  | 25.38 |  |  |  |  |  |  |  | 8-B | 64-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 56 | B | SEROTTE |  | 10.91 | OT | 0.82 | DAY | NS | 1.69 | 0.94 | 0.27 | 3.72 | 14.63 |  |  |  | 16 | D | FREEBERSYSER |  | 25.31 |  |  |  |  |  |  |  | 9-E | 65-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 68 | B | WILCOX |  | 0 | OT | SL |  | NS | SL | SL | SL | 0 | 0 |  |  |  | 63 | F | [NAME] |  | 24.45 |  |  |  |  |  |  |  | 10-D | 68-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U5 | B | ROBY |  | 15.75 | OT | 1.28 | COLUMBUS | NS | 1.49 | W | 0.37 | 3.14 | 18.89 |  |  |  | U7 | D | MORGAN |  | 22.76 |  |  |  |  |  |  |  | 11-D | U2-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 22 | C | CRAWFORD |  | 7.489999999999999 | OT | W / |  | 1.49 | 8 | 0.1 | W / | 9.59 | 17.08 |  |  |  | 57 | E | BELINSKI | ü | 20.41 |  |  |  |  |  |  |  | 12-E | U3-C
 |  |  |  |  |  |  | POP |  |  |  | 7.31 ACTUAL |  |  | 0
 |  | 52 | C | FICHTINGER |  | 0 | OT | SL | DAY | SL | NS | SL | SL | 0 | 0 |  |  |  | 46 | E | RIEFLE | ü | 19.76 |  |  |  |  |  |  |  | 16-D | U4-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U3 | C | MORAN |  | 8.059999999999999 | OT | 1 |  | 1.93 | 8 | W | 0.18 | 11.11 | 19.17 |  |  |  | 23 | B | YAWITZ |  | 19.38 |  |  |  |  |  |  |  | 17-A | U5-B
 |  |  |  |  |  |  | POP | REFUSED |  |  | 7.94 ACTUAL |  |  | 0
 |  | U4 | C | HRUBY | ü | 6.05 | OT | 0.15 | COLUMBUS | 0.93 | 8 | W / | AL | 9.08 | 15.13 |  |  |  | U3 | C | MORAN |  | 19.17 |  |  |  |  |  |  |  | 18-F | U6-C
 |  |  |  |  |  |  | POP |  |  |  | 7.68 ACTUAL |  |  | 0
 |  | 10 | D | [NAME] |  | 16.54 | OT | 0.83 |  | 1.62 | 1.69 | 8 | 1.44 | 13.58 | 30.12 |  |  |  | U5 | B | ROBY |  | 18.89 |  |  |  |  |  |  |  | 20-E | U7-D
 |  |  |  |  |  |  | POP |  |  |  |  | 7.21 ACTUAL |  | 0
 |  | 16 | D | FREEBERSYSER |  | 15.51 | OT | 0.24 | DAY | 1.56 | W / | 8 | W / | 9.8 | 25.31 |  |  |  | 28 | E | HUSTER | ü | 18.01 |  |  |  |  |  |  |  | 22-C
 |  |  |  |  |  |  | POP |  |  |  |  | 7.91 ACTUAL |  | 0
 |  | 58 | D | DREW |  | 18.04 | OT | W |  | W | W | 8 | 2 | 10 | 28.04 |  |  |  | 22 | C | CRAWFORD |  | 17.08 |  |  |  |  |  |  |  | 23-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U7 | D | MORGAN |  | 10.36 | OT | 0.86 | COLUMBUS | 2 | 0.29 | 8 | 1.25 | 12.4 | 22.76 |  |  |  | U4 | C | HRUBY | ü | 15.13 |  |  |  |  |  |  |  | 25-D
 |  |  |  |  |  |  | POP |  |  |  |  | 7.88 ACTUAL |  | 0
 |  | 28 | E | HUSTER | ü | 8.08 | OT | W / |  | 1.02 | 0.91 | W / | 8 | 9.93 | 18.01 |  |  |  | 56 | B | SEROTTE |  | 14.63 |  |  |  |  |  |  |  | 26-A
 |  |  |  |  |  |  | POP |  |  |  |  |  | 7.42 ACTUAL | 0
 |  | 46 | E | RIEFLE | ü | 15.97 | OT | 0.43 | DAY | 2 | 1.16 | W / | NS | 3.59 | 19.76 |  |  |  | 29 | F | HEITMAN | ü | 13.96 |  |  |  |  |  |  |  | 28-E
 |  |  |  |  |  |  | POP |  |  | 0.2 |  |  |  | 0.2
 |  | 57 | E | BELINSKI | ü | 17.81 | OT | W |  | 1.71 | 0.69 | 0.2 | NS | 2.6 | 20.41 |  |  |  | 36 | F | KESLER |  | 8.82 |  |  |  |  |  |  |  | 29-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 29 | F | HEITMAN | ü | 13.96 | OT | 7.72 OT | COLUMBUS | AL | AL | AL | AL | 0 | 13.96 |  |  |  | 68 | C | BOWLING |  | 6.82 |  |  |  |  |  |  |  | 30-AUX
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 36 | F | KESLER |  | 5.48 | OT | 7.42 OT |  | 1.6 | 1.04 | 0.3 | 0.4 | 3.34 | 8.82 |  |  |  | 68 | B | WILCOX |  | 0 |  |  |  |  |  |  |  | 36-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 63 | F | [NAME] |  | 17.81 | OT | 8.00 OT | DAY | 1.94 | 1.75 | 1.49 | 1.46 | 6.64 | 24.45 |  |  |  | 52 | C | FICHTINGER |  | 0 |  |  |  |  |  |  |  | 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
 |  |  |  | COLUMN TOTAL |  |  |  | 5.88 | 0 | 40.61000000000001 | 43.83999999999999 | 36.73 | 18 | 145.06 | 429.8799999999999
 |  |  |  | COLUMN AVERAGE |  |  |  | 0.2556521739130435 | 0 | 1.765652173913044 | 1.906086956521739 | 1.596956521739131 | 0.782608695652174 | 6.30695652173913 | 18.69043478260869
WEEK |  | 3 |  | WORK ASSIGNMENT |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 2
HOLDOWN |  |  |  | NO OVERTIME |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 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 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | F | A | B | C | D | E
 |  | 11 | D | DULANEY | WA | 7.48 | OT |  | COLUMBUS | 2 | 1.99 | NS |  | 3.99 | 11.57
 |  |  |  |  |  |  | POP |  |  | 0.1 |  |  |  | 0.1
 |  | 25 | D | SCROGGINS | WA | 2.77 | OT | 0.98 |  | 1.93 | SL | NS |  | 2.91 | 5.68
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 18 | F | [NAME] | WA | 8.89 | OT | 8 | DAY | 2 | 1.67 | 1.59 |  | 13.26 | 22.15
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 9 | E | HORBELT | WA | 5.91 | OT | 0.11 |  | AL | AL | AL | NS | 0.11 | 6.02
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 17 | A | HUMBERD | WA | 7.92 | OT | NS | COLUMBUS | 2 | 1.61 | 0.5 |  | 4.11 | 12.03
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
 |  | 20 | E | MALIN | NONE | 0.8200000000000001 | OT |  |  | AL | AL | AL | NS | 0 | 0.8200000000000001
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 12 | E | GRILLO | WA | 4.92 | OT |  | DAY | 1.69 | 0.54 | 0.54 | NS | 2.77 | 7.69
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 65 | F | WELBY | WA | 0.61 | OT | 7.93 |  | 1.71 |  |  |  | 9.64 | 10.25
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 64 | C | FRAZIER | WA | 0.63 | OT | AL | COLUMBUS | 0.44 | NS |  |  | 0.44 | 1.07
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U2 | C | [NAME] | WA | 0 | OT |  |  | 1.5 | NS |  |  | 1.5 | 1.5
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 61 | B | DAVIS | WA | 2.31 | OT |  | DAY | NS | 0.62 |  |  | 0.62 | 2.93
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 2 | A | [NAME] | WA | 10.67 | OT | NS |  | 2 | 1.89 | 0.5 | 0.88 | 5.27 | 15.94
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 0
 |  | 1 | D | BOLIN | WA | 1.02 | OT | 0.19 | COLUMBUS | 1.55 | 0.38 | NS |  | 2.12 | 3.14
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 3 | F | GREEN | WA | 2.82 | OT | NS |  | AL | AL | AL | AL | 0 | 2.82
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U6 | C | SPENCE | WA | 16 | OT | HL | DAY | HL | HL | NS | HL | 0 | 16
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 26 | A | HENLEY | WA | 10.63 | OT | NS |  | 1.84 | 1.19 | 1.93 | 0.87 | 5.83 | 16.46
 |  |  |  |  |  |  | POP | HOLIDAY |  |  |  |  |  | 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 |  | 3 |  | CCA |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 2
HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 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 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | F | A | B | C | D | E
 |  |  |  | EAISLEY | CCA | 82.13 | W | 8 |  | 9.87 | 8.53 | 7.91 | 8.41 | 42.72 | 124.85
 |  |  |  |  |  | 18.1 | OT |  |  | 1.87 | 0.53 |  | 0.41 | 2.81 | 20.91
 |  |  |  |  |  | 0.04 | POP |  |  |  |  |  |  | 0 | 0.04
 |  |  |  | BENSINGER | CCA | 85.59 | W | NS | 4.5 | 9.53 | 9.56 | 8.17 | 7.95 | 39.71 | 125.3
 |  |  |  |  |  | 18.97 | OT |  |  | 1.53 | 1.56 | 0.17 |  | 3.26 | 22.23
 |  |  |  |  |  | 2.62 | POP |  |  |  |  |  |  | 0 | 2.62
 |  |  |  | HASKELL | CCA | 84.9 | W | 9.01 |  | 9.85 | 9.02 | 7.94 | 8.71 | 44.53 | 129.43
 |  |  |  |  |  | 20.09 | OT | 1.01 |  | 1.85 | 1.02 |  | 0.71 | 4.59 | 24.68
 |  |  |  |  |  | 0.81 | POP |  |  |  |  |  |  | 0 | 0.81
 |  |  |  | EVANS | CCA | 85.22 | W | NS |  | 9.87 | 9.01 | 8.91 | 9.18 | 36.97 | 122.19
 |  |  |  |  |  | 19.13 | OT |  |  | 1.87 | 1.01 | 0.91 | 1.18 | 4.97 | 24.1
 |  |  |  |  |  | 2.09 | POP |  |  |  |  |  |  | 0 | 2.09
 |  |  |  |  |  | 0 | W |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | POP |  |  |  |  |  |  | 0 | 0