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

WEEK |  | 4 |  |  |  |  |  |  | PAY PERIOD |  | 2013 | 23 | 1 |  |  |  | WEEK |  | 5 |  |  |  |  |  | PAY PERIOD |  | 2013 | 23 | 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-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 | WEEKLY TOTALS |  |  | RTE. / SDO |  |  |  |  | 10 |  | 2013-10-26 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00 | 2013-10-30 00:00:00 | 2013-10-31 00:00:00 | 2013-11-01 00:00:00 | 2013-11-02 00:00:00
SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  |  | E | F | A | B | C | D |  |  |  | SAT. | M - F | RTE. | SDO | CARRIER | HOUR |  | D | E | F | A | B | C | C
 |  | 4 | A | [NAME] |  | 27.27 | OT | SL | SL | NS | SL | SL | SL | 0 | 27.27 | 4.01 |  |  | 68 | D | WILCOX |  | 42.04 |  |  |  |  |  |  |  | 1-D | 56-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 7 | A | TAYLOR |  | 25.38 | OT | 1.1 | 0.48 | NS | 1.38 | W | 1.71 | 4.67 | 30.05 | 7.01 |  |  | 58 | D | DREW |  | 41.31999999999999 |  |  |  |  |  |  |  | 2-A | 57-E
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 53 | A | PERKINS |  | 28.74 | OT | W | AL | NS | 1.17 | W | W | 1.17 | 29.91 | 53.01 |  |  | 56 | F | SEROTTE |  | 36.67 |  |  |  |  |  |  |  | 3-F | 58-D
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
F | C |  |  | BOWLING |  | 6.82 | OT | 1.89 | 2 | W | 1.21 | NS | 1.83 | 6.93 | 13.87 | 0 |  |  | 52 | E | FICHTINGER | ü | 31.26 |  |  |  |  |  |  |  | 4-A | 61-B
 | 68 |  |  |  |  |  | POP |  | 0.12 |  |  |  |  | 0.12 |  | 0
 |  | 8 | B | SMITH | ü | 25.75 | OT | 0.52 | 1.5 | W | NS | W | 1.4 | 3.42 | 29.17 | 8.01 |  |  | 36 | A | KESLER |  | 30.05 |  |  |  |  |  |  |  | 7-A | 63-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 23 | B | YAWITZ |  | 19.38 | OT | W / | 1.64 | W / | NS | 1.02 | 1.11 | 3.77 | 23.15 | 23.01 |  |  | 28 | A | HUSTER |  | 29.91 |  |  |  |  |  |  |  | 8-B | 64-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 56 | B | SEROTTE |  | 14.63 | OT | 1.95 | 1.97 | W | NS | SL | SL | 3.92 | 18.55 | 56.01 |  |  | 22 | B | CRAWFORD | ü | 29.17 |  |  |  |  |  |  |  | 9-E | 65-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 68 | B | WILCOX |  | 0 | OT | AL | SL | SL | NS | SL | SL | 0 | 0 | 68.01 |  |  | 10 | D | [NAME] |  | 28.15 |  |  |  |  |  |  |  | 10-D | 68-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | U5 | B | ROBY |  | 18.89 | OT | 2 | 1.76 | 0.43 | NS | W | SL | 4.19 | 23.26 | 0 |  |  | 7 | A | TAYLOR |  | 27.27 |  |  |  |  |  |  |  | 11-D | U2-C
 |  |  |  |  |  |  | POP | 0.18 |  |  |  |  |  | 0.18 |  | 0
 |  | 22 | C | CRAWFORD |  | 17.08 | OT | 1.26 | 1.97 | W / | 0.78 | NS | 1.27 | 5.279999999999999 | 22.36 | 22.01 |  |  | 0 | D | 0 |  | 26.76 |  |  |  |  |  |  |  | 12-E | U3-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 52 | C | FICHTINGER |  | 0 | OT | SL | 1.49 | 0.21 | 1.45 | NS | 1.04 | 4.19 | 4.19 | 52.01 |  |  | 0 | E | 0 | ü | 24.58000000000001 |  |  |  |  |  |  |  | 16-D | U4-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | U3 | C | MORAN |  | 19.17 | OT | 1.18 | 1.28 | W | 0.58 | NS | 0.78 | 3.82 | 22.99 | 0 |  |  | 0 | B | 0 |  | 23.26 |  |  |  |  |  |  |  | 17-A | U5-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | U4 | C | HRUBY | ü | 15.13 | OT | AL | 1.37 | W / | AL | NS | AL | 1.37 | 16.5 | 0 |  |  | 0 | B | 0 |  | 23.15 |  |  |  |  |  |  |  | 18-F | U6-C
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 10 | D | [NAME] |  | 30.12 | OT | 1.98 | W | W / | 1.22 | W | 8 | 11.2 | 41.31999999999999 | 10.01 |  |  | 0 | C | 0 |  | 22.99 |  |  |  |  |  |  |  | 20-E | U7-D
 |  |  |  |  |  |  | POP |  |  |  |  |  | 7.97 ACTUAL | 0 |  | 0
 |  | 16 | D | FREEBERSYSER |  | 25.31 | OT | 0.76 | 1.09 | W | 0.99 | W | NS | 2.84 | 28.15 | 16.01 |  |  | 0 | C | 0 |  | 22.36 |  |  |  |  |  |  |  | 22-C
 |  |  |  |  |  |  | POP |  |  |  |  |  | CALLED | 0 |  | 0
 |  | 58 | D | DREW |  | 28.04 | OT | 2 | 2 | W | 0.75 | 1.25 | 8 | 14 | 42.04 | 58.01 |  |  | 0 | E | 0 | ü | 22.28 |  |  |  |  |  |  |  | 23-B
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | U7 | D | MORGAN |  | 22.76 | OT | 1.08 | 0.97 | 0.37 | 1.58 | AL | NS | 4 | 26.76 | 0 |  |  | 0 | B | 0 |  | 18.55 |  |  |  |  |  |  |  | 25-D
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 28 | E | HUSTER | ü | 18.01 | OT | NS | 1.42 | W | 0.96 | 0.7 | 1.19 | 4.27 | 22.28 | 28.01 |  |  | 0 | C | 0 | ü | 16.5 |  |  |  |  |  |  |  | 26-A
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 46 | E | RIEFLE | ü | 19.76 | OT | 8 | 1.75 | W / | 0.77 | 0.39 | 0.59 | 11.5 | 31.26 | 46.01 |  |  | 0 | F | 0 | ü | 15.66 |  |  |  |  |  |  |  | 28-E
 |  |  |  |  |  |  | POP | 7.29 ACTUAL |  |  |  |  |  | 0 |  | 0
 |  | 57 | E | BELINSKI | ü | 20.41 | OT | NS | 1.97 | W | 1.19 | W | 1.01 | 4.17 | 24.58000000000001 | 57.01 |  |  | 0 | ? | 0 |  | 13.87 |  |  |  |  |  |  |  | 29-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 29 | F | HEITMAN | ü | 13.96 | OT | AL | NS | 0.34 | 0.85 | W | 0.51 | 1.7 | 15.66 | 29.01 |  |  | 0 | F | 0 |  | 9.93 |  |  |  |  |  |  |  | 30-AUX
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 36 | F | KESLER |  | 8.82 | OT | 0.22 | NS | W | 0.27 | 0.62 | NS | 1.11 | 9.93 | 36.01 |  |  | 0 | C | 0 |  | 4.19 |  |  |  |  |  |  |  | 36-F
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0 |  | 0
 |  | 63 | F | [NAME] |  | 24.45 | OT | 2 | 8 | 0.97 | 1.24 | W | W | 12.21 | 36.67 | 63.01 |  |  | 0 | B | 0 |  | 0 |  |  |  |  |  |  |  | 46-E
 |  |  |  |  |  |  | POP | 0.01 |  |  |  |  |  | 0.01 |  | 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 |  |  |  | 26.13 | 32.77999999999999 | 2.32 | 16.39 | 3.98 | 28.44 | 110.04 | 539.92
 |  |  |  | COLUMN AVERAGE |  |  |  | 1.136086956521739 | 1.425217391304348 | 0.1008695652173913 | 0.7126086956521738 | 0.1730434782608696 | 1.236521739130435 | 4.784347826086957 | 23.47478260869565
WEEK |  | 4 |  | WORK ASSIGNMENT |  |  |  |  | PAY PERIOD |  | 2013 | 23 | 1
HOLDOWN |  |  |  | NO OVERTIME |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 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 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | E | F | A | B | C | D
 |  | 11 | D | DULANEY | WA | 11.57 | OT | SL | 2 |  |  |  | NS | 2 | 13.68
 |  |  |  |  |  |  | POP |  | 0.11 |  |  |  |  | 0.11
 |  | 25 | D | SCROGGINS | WA | 5.68 | OT | 0.4 | 1.31 |  | 0.34 |  | NS | 2.05 | 7.73
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 18 | F | [NAME] | WA | 22.15 | OT | 1.78 | NS |  | AL | 0.26 | 0.51 | 2.55 | 24.7
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 9 | E | HORBELT | WA | 6.02 | OT | NS | AL | AL | AL | AL | AL | 0 | 6.02
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 17 | A | HUMBERD | WA | 12.03 | OT | 0.93 | 1.91 | NS | 0.51 |  |  | 3.35 | 15.38
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 20 | E | MALIN | NONE | 0.8200000000000001 | OT | NS | 0.48 |  |  |  |  | 0.48 | 1.3
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 12 | E | GRILLO | WA | 7.69 | OT | NS | 1.73 |  |  |  | 0.26 | 1.99 | 9.68
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 65 | F | WELBY | WA | 10.25 | OT |  | NS |  |  |  |  | 0 | 10.25
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 64 | C | FRAZIER | WA | 1.07 | OT |  |  |  |  | NS |  | 0 | 1.07
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U2 | C | [NAME] | WA | 1.5 | OT |  | 0.47 |  |  | NS |  | 0.47 | 1.97
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 61 | B | DAVIS | WA | 2.93 | OT | 0.35 | SL | SL | NS |  |  | 0.35 | 3.28
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 2 | A | [NAME] | WA | 15.94 | OT | 1.96 | 2 | NS | 1.4 |  | 2 | 7.359999999999999 | 23.67
 |  |  |  |  |  |  | POP |  | 0.37 |  |  |  |  | 0.37
 |  | 1 | D | BOLIN | WA | 3.14 | OT |  | SL |  |  |  | NS | 0 | 3.14
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | 3 | F | GREEN | WA | 2.82 | OT | AL | NS |  |  |  |  | 0 | 2.82
 |  |  |  |  |  |  | POP |  |  |  |  |  |  | 0
 |  | U6 | C | SPENCE | WA | 16 | OT | HL | HL | HL | HL | 8 | HL | 8 | 24
 |  |  |  |  |  |  | POP |  |  |  |  | HL |  | 0
 |  | 26 | A | HENLEY | WA | 16.46 | OT | 1.94 | 1.96 | NS | 1.78 |  | 1.79 | 7.47 | 23.93
 |  |  |  |  |  |  | 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 |  | 4 |  | CCA |  |  |  |  | PAY PERIOD |  | 2013 | 23 | 1
HOLDOWN |  |  |  |  |  | TOTALS FROM PREVIOUS WEEK |  | SAT. | MON. | TUE. | WED. | THUR. | FRI. |  | RUNNING TOTALS TO DATE
RTE. / SDO |  |  |  |  |  |  |  | 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 | WEEKLY TOTALS
SAT. | M - F | RTE. | SDO | CARRIER |  |  |  | E | F | A | B | C | D
 |  |  |  | EAISLEY | CCA | 124.85 | W | 8.23 | 8.8 | 7.93 | 8.76 | 7.9 | 8.56 | 50.18 | 175.03
 |  |  |  |  |  | 20.91 | OT | 0.23 | 0.8 |  | 0.76 |  | 8.39 | 10.18 | 31.09
 |  |  |  |  |  | 0.04 | POP |  |  |  |  |  |  | 0 | 0.04
 |  |  |  | BENSINGER | CCA | 125.3 | W | NS | 7.98 | 7.97 | 7.97 | 8.41 | 9.45 | 41.78 | 167.08
 |  |  |  |  |  | 22.23 | OT |  |  |  |  | 0.41 | 1.45 | 1.86 | 24.09
 |  |  |  |  |  | 2.62 | POP |  |  |  |  |  |  | 0 | 2.62
 |  |  |  | HASKELL | CCA | 129.43 | W | 8.88 | 9.01 | 7.85 | NS | 8.56 | 8.76 | 43.06 | 172.49
 |  |  |  |  |  | 24.68 | OT | 0.88 | 1.01 |  |  | 0.56 | 0.76 | 3.21 | 27.89
 |  |  |  |  |  | 0.81 | POP |  |  |  |  |  |  | 0 | 0.81
 |  |  |  | EVANS | CCA | 122.19 | W | 9.45 | 10.18 | NS | NS | 8.02 | 9.16 | 36.81 | 159
 |  |  |  |  |  | 24.1 | OT | 1.45 | 2 |  |  | 0.02 | 1.16 | 4.63 | 28.73
 |  |  |  |  |  | 2.09 | POP |  | 0.18 |  |  |  |  | 0.18 | 2.27
 |  |  |  |  |  | 0 | W |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | OT |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | POP |  |  |  |  |  |  | 0 | 0