Spreadsheet: 883781d1732482238-index-match-and-if-isna-one-formula-make-the-other-fault-schedule-7-
Sheet: Work Schedule 

 |  | Staff Available
 |  | No. of jobs (✔
 |  |  | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00
 |  |  | Tue | Wed | Thu | Fri | Sat | Sun
 | Rig1 | ✔ |  |  |  |  | ✔ | ✔
 |  |  |  |  |  |  | Client
 |  |  |  |  |  |  | Contact
 |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  | Accommodation booked
 | [NAME] | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | Jye            Harry | [NAME]
 | Rig3 | ✔
 | Rig4 | ✔
 | Rig5 | ✔ | ✔ | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | Accommodation booked |  |  | Demob
 | Rig6 | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | Brad               Nick               Dev | Brad               Nick               Dev | Brad               Nick               Dev | Brad               Nick               Dev
 |  |  | 14 wells to 10m could go erlier
 | Rig7 | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | [NAME]SteveC       Billy | [NAME]SteveC       Billy | [NAME]SteveC       Billy | [NAME]
 |  |  | In Out Rest Day
 | Rig8 | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | ShaunA               Marcus        [NAME] | ShaunA               Marcus [NAME] | Sean               [NAME] | Sean               [NAME] | Sean               [NAME] | [NAME]Marcus DaveG
 |  |  |  |  |  |  |  | Crew in
 | Rig9 | ✔ |  |  |  |  |  | ✔
 |  |  |  |  |  |  |  | Client
 |  |  |  |  |  |  |  | Contact
 |  |  |  |  |  |  |  | [NAME]
 |  |  | Mob | Mob
 | Rig10 | ✔ | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | Callum | Callum
 | Rig11 | ✔ |  |  | ✔ | ✔
 |  |  |  |  | Client
 |  |  |  |  | Contact
 |  |  |  |  | [NAME] | [NAME]
 | Rig12 | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | Wayne ShaunB | Wayne ShaunB | DaveH        [NAME] | Callum         Harry
 | Rig13 | ✔ | ✔ | ✔ | ✔ | ✔
 |  |  | Client
 |  |  | Contact
 |  |  | [NAME] | [NAME]DaveH | [NAME] | [NAME]
 | Rig14 | ✔
 | Rig15 | ✔
 | Field Job1 | ✔ | ✔ |  |  | ✔
 |  |  | Client |  |  | Client
 |  |  | Contact |  |  | Contact
 |  |  | DaveH |  |  | DaveH
 | Field Job 2 | ✔ |  |  | ✔
 |  |  |  |  | Client
 |  |  |  |  | Contact
 |  |  |  |  | Jye
[NAME] |  |  | DaveG | DaveG | DaveG | DaveG | DaveG
 |  |  | [NAME] |  | Wayne ShaunA | SteveC Jye    ShaunA
Annual Leave RDO / Leave  Leave Aproved
Personal Leave |  |  | [NAME] |  | [NAME] | [NAME]
Training
Management                          Office                                   Workshop |  |  | [NAME][NAME] | [NAME][NAME]       [NAME] | [NAME][NAME] | [NAME][NAME]       Ron              [NAME] | [NAME]
Depot                                     Spare                                     Available                                          for Jobs
Rows hidden
People count |  |  | People count | People count | People count | People count | People count | People count
People count |  |  | People count | People count | People count | People count | People count | People count
Not available people combine |  |  | Not available people combine | Not available people combine | Not available people combine | Not available people combine | Not available people combine | Not available people combine
Split Not Available |  |  | Split Not Available | Split Not Available | Split Not Available | Split Not Available | Split Not Available | Split Not Available
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Wayne | [NAME]
 |  |  | Scott | Scott | Scott | Scott | DaveG | Nick
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Sean | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Marcus | Sean
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Marcus
 |  |  | [NAME] | [NAME] | [NAME] | Wayne | Kurt | DaveG
 |  |  | [NAME] | DaveG | Wayne | Wayne | Jed | Kurt
 |  |  | DaveG | [NAME] | ShaunA | [NAME] | Fuat | Jed
 |  |  | DaveH | DaveH | DaveG | SteveC | Nathan | Fuat
 |  |  | [NAME] | Wayne | Jye | Jye | [NAME] | Nathan
 |  |  | [NAME] | ShaunB | [NAME] | ShaunA |  | [NAME]
 |  |  | Wayne | Callum | [NAME] | DaveG
 |  |  | ShaunB | ShaunA | DaveH | DaveH
 |  |  | Callum | Marcus | [NAME] | [NAME]
 |  |  | ShaunA | [NAME] | [NAME] | [NAME]
 |  |  | Marcus | Sean | ShaunB | Callum
 |  |  | [NAME] | [NAME] | Sean | [NAME]
 |  |  | Sean | Nathan | Marcus | [NAME]
 |  |  | [NAME] | SteveC | [NAME] | ShaunB
 |  |  | Nathan | Billy | [NAME] | Sean
 |  |  | SteveC | [NAME] | Nathan | Marcus
 |  |  | Billy | Nick | SteveC | [NAME]
 |  |  | [NAME] | Dev | Billy | [NAME]
 |  |  | Nick | Kurt | [NAME] | Nathan
 |  |  | Dev | Jed | Nick | Billy
 |  |  | Kurt | Fuat | Dev | [NAME]
 |  |  | Jed | Jye | Kurt | Nick
 |  |  | Fuat | [NAME] | Jed | Dev
 |  |  | Jye |  | Fuat | Kurt
 |  |  | [NAME] |  |  | Jed
 |  |  |  |  |  | Fuat
Depot Available Index Match |  |  | Depot Available Index Match | Depot Available Index Match | Depot Available Index Match | Depot Available Index Match | Depot Available Index Match | Depot Available Index Match
1 | [NAME]
2 | Callum
3 | [NAME]
4 | DaveG
5 | DaveH
6 | [NAME]
7 | Jye
8 | [NAME]
9 | Kurt
10 | Dev
11 | [NAME]
12 | Nathan
13 | [NAME]
14 | [NAME]
15 | Scott
16 | ShaunB
17 | ShaunA
18 | [NAME]
19 | SteveC
20 | Wayne
21 | [NAME]
22 | Jed
23 | [NAME]
24 | [NAME]
25 | Sean
26 | [NAME]
27 | Marcus
28 | Billy
29 | Fuat
30 | Nick
30 | [NAME]
Depot Available Split |  |  | Depot Available Split | Depot Available Split | Depot Available Split | Depot Available Split | Depot Available Split | Depot Available Split
Depot Available |  |  | Depot Available | Depot Available | Depot Available | Depot Available | Depot Available | Depot Available
Find Repeated |  |  | Find Repeated | Find Repeated | Find Repeated | Find Repeated | Find Repeated | Find Repeated
Find repeated step 1
[NAME] |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Find repeated Step 2 Split into cells
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | Scott | [NAME] | [NAME] | [NAME] | Callum | [NAME]
 |  |  | [NAME] | [NAME] | Scott | Scott | [NAME] | DaveH
 |  |  | [NAME] | Scott | [NAME] | [NAME] | DaveH | Dev
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Dev | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | Wayne | [NAME] | Jye
 |  |  | DaveG | [NAME] | Wayne | Wayne | [NAME] | [NAME]
 |  |  | DaveH | DaveG | ShaunA | [NAME] | Jye | [NAME]
 |  |  | [NAME] | [NAME] | DaveG | SteveC | [NAME] | [NAME]
 |  |  | [NAME] | DaveH | Jye | Jye | Nick | [NAME]
 |  |  | Wayne | Wayne | [NAME] | ShaunA | [NAME] | Scott
 |  |  | ShaunB | ShaunB | [NAME] | DaveG | [NAME] | [NAME]
 |  |  | Callum | Callum | DaveH | DaveH | [NAME] | ShaunA
 |  |  | ShaunA | ShaunA | [NAME] | [NAME] | Scott | ShaunB
 |  |  | Marcus | Marcus | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | ShaunB | Callum | ShaunA | SteveC
 |  |  | Sean | Sean | Sean | [NAME] | ShaunB | Wayne
 |  |  | [NAME] | [NAME] | Marcus | [NAME] | [NAME] | Callum
 |  |  | Nathan | Nathan | [NAME] | ShaunB | SteveC | [NAME]
 |  |  | SteveC | SteveC | [NAME] | Sean | Wayne | Nick
 |  |  | Billy | Billy | Nathan | Marcus | Wayne | [NAME]
 |  |  | [NAME] | [NAME] | SteveC | [NAME] | DaveG | Sean
 |  |  | Nick | Nick | Billy | [NAME] | Sean | Marcus
 |  |  | Dev | Dev | [NAME] | Nathan | Marcus | DaveG
 |  |  | Kurt | Kurt | Nick | Billy | [NAME] | Kurt
 |  |  | Jed | Jed | Dev | [NAME] | Kurt | Jed
 |  |  | Fuat | Fuat | Kurt | Nick | Jed | Fuat
 |  |  | Jye | Jye | Jed | Dev | Fuat | Nathan
 |  |  | [NAME] | [NAME] | Fuat | Kurt | Nathan | [NAME]
 |  |  |  |  |  | Jed | [NAME]
 |  |  |  |  |  | Fuat
Rows hidden