Spreadsheet: 106259d1303414699-solved-drop-down-lists-automatic-timesheet2104
Sheet: Data Cells

Index | Day | Times | [NAME] | Higher | Basic | hours | overrun | dekit | payortoil |  | Shifts |  | Abcodes |  | Pin | Name | Station | hours | Payroll
 | mon | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  |  |  | 2834 | [NAME] | Cowbridge | 37.5 | 10255543
 | mon | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  | 07-16 |  | RD
 | mon | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 08-17 |  | AL
 | mon | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 16-01 |  | LL
 | mon | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  | 17-02 |  | TOIL
 | mon | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 17-04 |  | AU
 | tue | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  | 22-07 |  | UU
 | tue | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | C
 | tue | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | M/P
 | tue | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | T
 | tue | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | UE
 | tue | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | SL
 | wed | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | DC
 | wed | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | SM
 | wed | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | TU
 | wed | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | PD
 | wed | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | SD
 | wed | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | BH
 | thu | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | O
 | thu | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S10
 | thu | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S11
 | thu | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S12
 | thu | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S13
 | thu | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S14
 | fri | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S15
 | fri | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S16
 | fri | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S17
 | fri | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S18
 | fri | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S19
 | fri | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S20
 | sat | 07-16 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S21
 | sat | 08-17 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S22
 | sat | 16-01 | 7.5 | 1 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S23
 | sat | 17-02 | 6.5 | 2 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S24
 | sat | 17-04 | 6.5 | 4 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S25
 | sat | 22-07 | 2 | 6.5 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S26
 | [NAME] | 07-16 |  | 8.5 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | [NAME]
 | [NAME] | 08-17 |  | 8.5 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S28
 | [NAME] | 16-01 | 1 | 7.5 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S29
 | [NAME] | 17-02 | 2 | 6.5 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S30
 | [NAME] | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S31
 | [NAME] | 22-07 | 6.5 | 2 |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S32
 |  |  |  |  |  |  |  |  |  |  |  |  | S98
 |  |  |  |  |  |  |  |  |  |  |  |  | I10
 |  |  |  |  |  |  |  |  |  |  |  |  | I11
 |  |  |  |  |  |  |  |  |  |  |  |  | I12
 |  |  |  |  |  |  |  |  |  |  |  |  | I13
 |  |  |  |  |  |  |  |  |  |  |  |  | I14
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | I16
 |  |  |  |  |  |  |  |  |  |  |  |  | I17
 |  |  |  |  |  |  |  |  |  |  |  |  | I18
 |  |  |  |  |  |  |  |  |  |  |  |  | I19
 |  |  |  |  |  |  |  |  |  |  |  |  | I20
 |  |  |  |  |  |  |  |  |  |  |  |  | I21
 |  |  |  |  |  |  |  |  |  |  |  |  | I22
 |  |  |  |  |  |  |  |  |  |  |  |  | I23
 |  |  |  |  |  |  |  |  |  |  |  |  | I24
 |  |  |  |  |  |  |  |  |  |  |  |  | I25
 |  |  |  |  |  |  |  |  |  |  |  |  | I26
 |  |  |  |  |  |  |  |  |  |  |  |  | I27
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | I29
 |  |  |  |  |  |  |  |  |  |  |  |  | I30
 |  |  |  |  |  |  |  |  |  |  |  |  | I31
 |  |  |  |  |  |  |  |  |  |  |  |  | I32
 |  |  |  |  |  |  |  |  |  |  |  |  | I98