Spreadsheet: 106347d1303519715-help-with-autofilling-cells-auto-timesheet2204-1-1freezepane-master
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 |  |  |  |  |  |  | 0000          Dummy User | [NAME] | dummy station | 37.5 | dummy |  | 01    Aberdare
 | mon | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  | 07-16 |  | RD |  |  | 2198          [NAME] | [NAME] | Cowbridge | 37.5 | 10256557 |  | 02    Aberbeeg
 | mon | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 08-17 |  | AL |  |  | 2202          T O Conner | Teresa O Conner | Cowbridge | 37.5 | 10256445 |  | 03    Abergavenny
 | mon | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 16-01 |  | LL |  |  | 2241          P Ruck | [NAME] | Cowbridge | 37.5 | 10255850 |  | 09    Bargoed
 | mon | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  | 17-02 |  | TOIL |  |  | 2327          S Leaves | [NAME] | Cowbridge | 37.5 | 10256623 |  | 11    Barry
 | mon | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  | 17-04 |  | AU |  |  | 2337          M Dyer | [NAME] | Cowbridge | 37.5 | 10254840 |  | 12    Bassaleg
 | tue | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  | 22-07 |  | UU |  |  | 2347          [NAME] | [NAME] | Cowbridge | 37.5 | 10255106 |  | 13    Blackweir
 | tue | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | C |  |  | 2539          J K Jordan | J K Jordan | Cowbridge | 37.5 | 10254239 |  | 14    Blackwood
 | tue | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | M/P |  |  | 2834          [NAME] | [NAME] | Cowbridge | 37.5 | 10255543 |  | 18    Bryncethin
 | tue | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | T |  |  | 2896          A Dunscombe | [NAME] | Cowbridge | 37.5 | 10254936 |  | 21    Caerphilly
 | tue | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | UE |  |  | 3204          G Hodges | [NAME] | Cowbridge | 37.5 | 21501597 |  | 23    Cardiff East
 | tue | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | SL |  |  | 3688          [NAME] | [NAME] | Cowbridge | 37.5 | 10255257 |  | 25    Chepstow
 | wed | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | DC |  |  | 3762          [NAME] | [NAME] | Cowbridge | 37.5 | 10255479 |  | 30    Cowbridge
 | wed | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | SM |  |  | 3764          [NAME] | [NAME] | Cowbridge | 37.5 | 10255340 |  | 32    Cwmbran
 | wed | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | TU |  |  | 3790          A Edwards | [NAME] | Cowbridge | 37.5 | 22158732 |  | 36    Ferndale
 | wed | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | PD |  |  | 6044          Laurence Lewis | [NAME] | Cowbridge | 37.5 | 10255084 |  | 39    [NAME]
 | wed | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | SD |  |  | 6359          [NAME] | [NAME] | Cowbridge | 37.5 | 10254415 |  | 44    Hawthorn
 | wed | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | BH |  |  | 6768          N Mealey | [NAME] | Cowbridge | 37.5 | 21025104 |  | 45    Hensol
 | thu | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | O |  |  | 7214          G H Evans | [NAME] | Cowbridge | 37.5 | 10255150 |  | 61    Maesteg
 | thu | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S10 |  |  |  |  |  |  |  |  | 62    Merthyr Tydfil
 | thu | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S11 |  |  |  |  |  |  |  |  | 65    Monmouth
 | thu | 17-02 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S12 |  |  |  |  |  |  |  |  | 67    [NAME]
 | thu | 17-04 |  |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S13 |  |  |  |  |  |  |  |  | 69    Newport
 | thu | 22-07 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S14 |  |  |  |  |  |  |  |  | 73    Pontypool
 | fri | 07-16 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S15 |  |  |  |  |  |  |  |  | 75    Porthcawl
 | fri | 08-17 |  |  | 8.5 | 8.5 | 0.25 | dekit | PAY |  |  |  | S16 |  |  |  |  |  |  |  |  | 82    Swansea
 | fri | 16-01 | 8.5 |  |  | 8.5 | 0.25 | dekit | PAY |  |  |  | S17 |  |  |  |  |  |  |  |  | 84    Tredegar
 | 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