Spreadsheet: 808513d1670502232-is-there-any-smarter-way-on-my-rolling-program-formulas-rolling-programme-for-excel-forum
Sheet: 2023 Master Schedule

 |  |  |  |  |  |  |  | No. of |  | Maintenance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
Unit | Team | Location | Type | Zone | 外門通訊 | [NAME] | Interval | days |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test
[NAME] | A | WEK | [NAME] | Public | ✔ | ✔ | BW |  |  | 2022-11-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-06 00:00:00
LS002 | A | WEK | [NAME] | Public | ✔ | ✔ | BW |  |  | 2022-10-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-04 00:00:00
LS003 | A | WEK | [NAME] | Public | ✔ | ✔ | M |  |  | 2022-12-25 00:00:00 | 2023-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-10 00:00:00
LS004 | B | WEK | [NAME] | Public | ✔ | ✔ | M |  |  | 2022-12-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-05 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-05 00:00:00
LS006 | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-04 00:00:00
LS007 | A | WEK | Escort | Escort |  |  | M |  |  | 2022-12-12 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-05 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-07 00:00:00
LS009 | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-07 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-05 00:00:00
LS011 | B | WEK | Escort | Escort |  |  | M |  |  | 2022-11-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-05 00:00:00
LS012 | B | WEK | Escort | Escort |  |  | M |  |  | 2022-11-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-05 00:00:00
[NAME] | A | WEK | Escort | MPA |  |  | BW |  |  | 2022-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-11 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | M |  |  | 2022-11-24 00:00:00 | 2022-12-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-16 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | BW |  |  | 2022-11-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-08 00:00:00
[NAME] | B | WEK | Escort | Escort |  |  | M |  |  | 2022-11-22 00:00:00 | 2022-12-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-16 00:00:00
LS017 | B | WEK | Escort | Escort |  |  | BW |  |  | 2022-11-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-08 00:00:00
LS018 | B | WEK | Escort | Escort |  |  | M |  |  | 2022-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 00:00:00
[NAME] | B | WEK | Escort | Public | ✔ | ✔ | M |  |  | 2022-12-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-29 00:00:00
LS020 | B | WEK | Escort | Public | ✔ | ✔ | M |  |  | 2022-12-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-29 00:00:00