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

WEEK |  | 1 |  |  |  |  |  |  | PAY PERIOD |  | 2013 | 21 | 2 |  |  |  | WEEK |  | 2 |  |  |  |  |  | PAY PERIOD |  | 2013 | 22 | 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-09-28 00:00:00 | 2013-09-30 00:00:00 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | WEEKLY TOTALS |  |  | 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 | 2013-10-12 00:00:00
SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  |  | B | C | D | E | F | A |  |  |  | SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  | A | B | C | D | E | F | F
 |  | 4 | A | [NAME] |  |  | OT | OLD | OLD | 1.5 | 1.14 | 1.99 | 8 | 12.63 | 12.63 |  |  |  | 58 | D | DREW |  | 13.8 |  |  |  |  |  |  |  | 1-D | 56-B
 |  |  |  |  |  |  | POP |  |  |  |  |  | REFUSED | 0
 |  | 7 | A | TAYLOR |  |  | OT | QUARTER | QUARTER | 1.62 | W | 1.56 | 8 | 11.18 | 11.18 |  |  |  | 4 | A | [NAME] |  | 12.63 |  |  |  |  |  |  |  | 2-A | 57-E
 |  |  |  |  |  |  | POP |  |  |  |  |  | 7.98 ACTUAL | 0
 |  | 53 | A | PERKINS |  |  | OT | OLD | OLD | 1.42 | 1.3 | 1.72 | 8 | 12.44 | 12.44 |  |  |  | 53 | A | PERKINS |  | 12.44 |  |  |  |  |  |  |  | 3-F | 58-D
 |  |  |  |  |  |  | POP |  |  |  |  |  | 4.09 ACTUAL | 0
 |  | R1 | A | BOWLING |  |  | OT | QUARTER | QUARTER | LP | LP | LP | NS | 0 | 0 |  |  |  | 10 | D | [NAME] |  | 12.34 |  |  |  |  |  |  |  | 4-A | 61-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 8 | B | SMITH | ü |  | OT | OLD | OLD | W | 1.96 | 1.58 | 1.69 | 5.23 | 5.23 |  |  |  | 63 | F | [NAME] |  | 11.75 |  |  |  |  |  |  |  | 7-A | 63-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 23 | B | YAWITZ |  |  | OT | QUARTER | QUARTER | SL | 0.95 | 1.25 | 1.9 | 4.1 | 4.1 |  |  |  | 46 | E | RIEFLE | ü | 11.64 |  |  |  |  |  |  |  | 8-B | 64-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 56 | B | SEROTTE |  |  | OT | OLD | OLD | 1.78 | 1.79 | W | 1.92 | 5.49 | 5.49 |  |  |  | 7 | A | TAYLOR |  | 11.18 |  |  |  |  |  |  |  | 9-E | 65-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 68 | B | WILCOX |  |  | OT | QUARTER | QUARTER | SL | SL | SL | SL | 0 | 0 |  |  |  | 29 | F | HEITMAN | ü | 10.79 |  |  |  |  |  |  |  | 10-D | 68-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 | D | U5 | B | ROBY |  |  | OT | OLD | OLD | 8 | 0.47 | W / | 1.72 | 10.19 | 10.19 |  |  |  | 16 | D | FREEBERSYSER |  | 10.4 |  |  |  |  |  |  |  | 11-D | U2-C
 | 25 |  |  |  |  |  | POP |  |  | 7.57 ACTUAL |  |  |  | 0
 |  | 22 | C | CRAWFORD |  |  | OT | OLD | OLD | SL | LP | LP | 1.46 | 1.46 | 1.46 |  |  |  | U5 | B | ROBY |  | 10.19 |  |  |  |  |  |  |  | 12-E | U3-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 52 | C | FICHTINGER |  |  | OT | QUARTER | QUARTER | SL | SL | SL | SL | 0 | 0 |  |  |  | U7 | D | MORGAN |  | 9.03 |  |  |  |  |  |  |  | 16-D | U4-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U3 | C | MORAN |  |  | OT | OLD | OLD | 0.92 | 1.29 | W | 2 | 4.21 | 4.67 |  |  |  | 56 | B | SEROTTE |  | 5.49 |  |  |  |  |  |  |  | 17-A | U5-B
 |  |  |  |  |  |  | POP |  |  |  |  |  | 0.46 | 0.46
 |  | U4 | C | HRUBY | ü |  | OT | QUARTER | QUARTER | 1.17 | 1.21 | W | 1.09 | 3.47 | 3.47 |  |  |  | 8 | B | SMITH | ü | 5.23 |  |  |  |  |  |  |  | 18-F | U6-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 10 | D | [NAME] |  |  | OT | OLD | OLD | 8 | 0.92 | 1.18 | 2 | 12.1 | 12.34 |  |  |  | U3 | C | MORAN |  | 4.67 |  |  |  |  |  |  |  | 20-E | U7-D
 |  |  |  |  |  |  | POP |  |  | 7.52 ACTUAL |  |  | 0.24 | 0.24
 |  | 16 | D | FREEBERSYSER |  |  | OT | QUARTER | QUARTER | 8 | 1.28 | 1.12 | SL | 10.4 | 10.4 |  |  |  | 57 | E | BELINSKI | ü | 4.5 |  |  |  |  |  |  |  | 22-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 58 | D | DREW |  |  | OT | OLD | OLD | 8 | 1.8 | 2 | 2 | 13.8 | 13.8 |  |  |  | 23 | B | YAWITZ |  | 4.1 |  |  |  |  |  |  |  | 23-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U7 | D | MORGAN |  |  | OT | QUARTER | QUARTER | 8 | 1.03 | SL | SL | 9.03 | 9.03 |  |  |  | 28 | E | HUSTER | ü | 3.48 |  |  |  |  |  |  |  | 25-D
 |  |  |  |  |  |  | POP |  |  | 7.86 ACTUAL |  |  |  | 0
 |  | 28 | E | HUSTER | ü |  | OT | QUARTER | QUARTER | W / | NS | 1.85 | 1.63 | 3.48 | 3.48 |  |  |  | U4 | C | HRUBY | ü | 3.47 |  |  |  |  |  |  |  | 26-A
 |  |  |  |  |  |  | POP |  |  |  | CALLED |  |  | 0
 |  | 46 | E | RIEFLE | ü |  | OT | OLD | OLD | 1.49 | 8 | W / | 2 | 11.49 | 11.64 |  |  |  | 22 | C | CRAWFORD |  | 1.46 |  |  |  |  |  |  |  | 28-E
 |  |  |  |  |  |  | POP |  |  |  | 7.57 ACTUAL |  | 0.15 | 0.15
 |  | 57 | E | BELINSKI | ü |  | OT | QUARTER | QUARTER | 1.2 | NS | 1.99 | 1.31 | 4.5 | 4.5 |  |  |  | R1 | A | BOWLING |  | 0 |  |  |  |  |  |  |  | 29-F
 |  |  |  |  |  |  | POP |  |  |  | CALLED |  |  | 0
 |  | 29 | F | HEITMAN | ü |  | OT | OLD | OLD | 0.53 | 0.71 | 8 | 1.55 | 10.79 | 10.79 |  |  |  | 68 | B | WILCOX |  | 0 |  |  |  |  |  |  |  | 30-AUX
 |  |  |  |  |  |  | POP |  |  |  |  | 7.87 ACTUAL |  | 0
 |  | 36 | F | KESLER |  |  | OT | QUARTER | QUARTER | SL | SL | NS | SL | 0 | 0 |  |  |  | 52 | C | FICHTINGER |  | 0 |  |  |  |  |  |  |  | 36-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 63 | F | [NAME] |  |  | OT | OLD | OLD | 1.76 | W | 8 | 1.99 | 11.75 | 11.75 |  |  |  | 36 | F | KESLER |  | 0 |  |  |  |  |  |  |  | 46-E
 |  |  |  |  |  |  | POP |  |  |  |  | 7.99 ACTUAL |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | EAISLEY |  | CCA |  |  |  |  |  |  |  | 52-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | BENSINGER |  | CCA |  |  |  |  |  |  |  | 53-A
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | HASKELL |  | CCA
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  | EVANS |  | CCA
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  | COLUMN TOTAL |  |  |  | 0 | 0 | 53.39 | 23.85 | 32.23999999999999 | 49.11000000000001 | 158.59 | 158.59
 |  |  |  | COLUMN AVERAGE |  |  |  | 0 | 0 | 2.321304347826087 | 1.036956521739131 | 1.401739130434782 | 2.135217391304348 | 6.895217391304348 | 6.895217391304348
WEEK |  | 1 |  | WORK ASSIGNMENT |  |  |  |  | PAY PERIOD |  | 2013 | 21 | 2
HOLDOWN |  |  |  | NO OVERTIME |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 2013-09-28 00:00:00 | 2013-09-30 00:00:00 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | B | C | D | E | F | A
 |  | 11 | D | DULANEY | WA |  | OT | OLD | OLD | NS | 1.99 | 0.42 | 1.57 | 3.98 | 3.98
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 25 | D | SCROGGINS | WA |  | OT | QUARTER | QUARTER | NS | AL | AL | AL | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 18 | F | [NAME] | WA |  | OT | OLD | OLD | 0.76 | 2 | NS | 1.34 | 4.1 | 4.1
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 9 | E | HORBELT | WA |  | OT | QUARTER | QUARTER | 0.93 | NS | 1.12 |  | 2.05 | 2.05
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 17 | A | HUMBERD | WA |  | OT | OLD | OLD | 0.84 | 2 |  | NS | 2.84 | 2.86
 |  |  |  |  |  |  | POP |  |  |  | 0.02 |  |  | 0.02
 |  | 20 | E | MALIN | NONE |  | OT | QUARTER | QUARTER |  | NS |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 12 | E | GRILLO | WA |  | OT | OLD | OLD | SL | NS | SL | SL | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 65 | F | WELBY | WA |  | OT | QUARTER | QUARTER |  |  | NS |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 64 | C | FRAZIER | WA |  | OT | OLD | OLD | SL |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U2 | C | [NAME] | WA |  | OT | QUARTER | QUARTER | AL | AL | AL | AL | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 61 | B | DAVIS | WA |  | OT | OLD | OLD | 0.5 |  |  | 1.81 | 2.31 | 2.31
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 2 | A | [NAME] | WA |  | OT | QUARTER | QUARTER |  | 1.98 | 1.51 | NS | 3.49 | 3.49
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 1 | D | BOLIN | WA |  | OT | OLD | OLD | NS | 0.15 |  |  | 0.15 | 0.15
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 3 | F | GREEN | WA |  | OT | QUARTER | QUARTER |  | 0.17 | NS | 0.64 | 0.81 | 0.81
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U6 | C | SPENCE | WA |  | OT | OLD | OLD | HL | HL | 8 | HL | 8 | 8
 |  |  |  |  |  |  | POP |  |  |  |  | HL |  | 0
 |  | 26 | A | HENLEY | WA |  | OT | QUARTER | QUARTER | 1.97 | 1.66 |  | NS | 3.63 | 3.63
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
WEEK |  | 1 |  | CCA |  |  |  |  | PAY PERIOD |  | 2013 | 21 | 2
HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 2013-09-28 00:00:00 | 2013-09-30 00:00:00 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | B | C | D | E | F | A
 |  |  |  | EAISLEY | CCA |  | W | OLD | OLD | 8.46 | 9.55 | 8.89 | 9.47 | 36.37 | 36.37
 |  |  |  |  |  |  | OT |  |  | 0.46 | 1.55 | 0.89 | 9.47 | 12.37 | 12.37
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 | 0
 |  |  |  | BENSINGER | CCA |  | W | QUARTER | QUARTER | 9.98 | 9.68 | 9.96 | 9.92 | 39.54 | 39.54
 |  |  |  |  |  |  | OT |  |  | 1.98 | 1.68 | 1.96 | 7.3 | 12.92 | 12.92
 |  |  |  |  |  |  | POP |  |  |  |  |  | 2.62 | 2.62 | 2.62
 |  |  |  | HASKELL | CCA |  | W | OLD | OLD | 9.43 | 9.86 | 7.84 | 9.98 | 37.11 | 37.11
 |  |  |  |  |  |  | OT |  |  | 1.43 | 1.86 |  | 9.01 | 12.3 | 12.3
 |  |  |  |  |  |  | POP |  |  |  |  |  | 0.81 | 0.81 | 0.81
 |  |  |  | EVANS | CCA |  | W | QUARTER | QUARTER | 8.49 | 9.48 | 10.17 | 9.09 | 37.23 | 37.23
 |  |  |  |  |  |  | OT |  |  | 0.49 | 1.48 | 2 | 8.53 | 12.5 | 12.5
 |  |  |  |  |  |  | POP |  |  |  |  | 0.17 | 0.56 | 0.7300000000000001 | 0.7300000000000001
 |  |  |  |  |  |  | W |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 | 0