Spreadsheet: 758727d1639042680-recognising-data-entries-from-a-specific-date-range-book1
Sheet: Test Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lock Code (No.'s & Letters Only!): | ABCD |  | Key:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABCD |  |  | M | Mobilisation has completed and this is the first day of operation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period |  | D | This is the last full day of operations and Demobilisation will commence going forward
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start: | 2021-11-29 00:00:00 |  | M/D | Mobilised and demobilised and worked a single day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End: |  |  | S | Standby
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | Engineering / Repair / Sickness
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Contract No.: | 12345 |  | 1 | Working Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B Contract No.: | 12345
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project name: | [NAME]
1 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  |  | Site: | [NAME] |  |  |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
Contract Schedule | Cat. | Sub-Cat. | Type | Specification | Mob | Demob | WORKING Hourly (Standard Working Hours) | WORKING Hourly (Non- Standard Working Hours) | WORKING Daily | WORKING Weekly 5 days / wk | WORKING Monthly | STANDBY Hourly (Standard Working Hours) | STANDBY Hourly (Non- Standard Working Hours) | STANDBY Daily | STANDBY Weekly | STANDBY Monthly |  | Ref.: | Resource | Location | Work in period ? | Qty. | Fleet No. | Notes e.g. This could be: • Fleet Number • Name of person • Free Text | 27-Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 1 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 1 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 1 | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M/D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Schedule | Original Order | Cat. | Sub-Cat. | Type