Spreadsheet: 885665d1735472701-create-multiple-vertical-lines-programmatically-from-single-cell-sample-workbook
Sheet: WeeklyShiftTemplate

 |  |  |  |  | 1 |  |  |  | 2 |  |  |  |  |  | 3 |  |  |  |  | 4 |  |  |  |  | 5 |  |  |  |  | 6 |  |  |  |  | 7
 |  |  |  |  | Monday |  |  |  | Tuesday |  |  |  |  |  | Wednesday |  |  |  |  | Thursday |  |  |  |  | Friday |  |  |  |  | Saturday |  |  |  |  | Sunday
CODE | Week Template |  |  | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish | Subject | Start | Finish | Call | Call Finish
WDN | WEEKDAY NIGHTS |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00 |  |  | Night | 21:30:00 | 07:30:00
WEN | WEEKEND NIGHTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night (Early Start) | 20:00:00 | 08:30:00 |  |  | Night (Early Start) | 20:00:00 | 08:30:00 |  |  | Night (Early Start) | 20:00:00 | 08:30:00
WEE | WEEKEND EVENING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 7.30 | 17.30 |  |  | Evening | 12.00 | 22.00 | 22.00 | 07:30:00 | Evening | 12.00 | 22.00 | 22.00 | 07:30:00 | Evening | 12.00 | 22.00 | 22.00 | 07:30:00
WDE1 | WEEKDAY EVENING |  |  | Evening | 12.00 | 22.00 | 22.00 | 07:30:00 | Evening | 12.00 | 22.00 |  |  | Evening | 12.00 | 22.00 | 22.00 | 07:30:00 | Evening | 12.00 | 22.00
WDE2 | WEEKDAY EVENING 2 |  |  | Evening | 12.00 | 22.00 |  |  | Evening | 12.00 | 22.00 | 22.00 | 07:30:00 | Evening | 12.00 | 22.00 |  |  | Evening | 12.00 | 22.00 | 22.00 | 07:30:00
WED10 | WEEKEND DAYS 10 |  |  | Day | 07.30 | 17.30 |  |  | Day | 07.30 | 17.30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 07.30 | 17.30 |  |  | Day | 07.30 | 17.30
WED12 | WEEKEND DAYS 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day (12H) | 8.00 | 20.30 |  |  | Day (12H) | 8.00 | 20.30 |  |  | Day (12H) | 8.00 | 20.30
DaysM | DAYS (Mon Off) |  |  |  |  |  |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30
DaysTu | DAYS (Tue Off) |  |  | Day | 7.30 | 17.30 |  |  |  |  |  |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30
DaysW | DAYS (Wed Off) |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  |  |  |  |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30
[NAME] | DAYS (Thu Off) |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  |  |  |  |  |  | Day | 7.30 | 17.30
DaysF | DAYS (Fri Off) |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30
WD3 | [NAME] (after hrs cover) |  |  | Day | 07.30 | 17.30 | 17.30 | 07:30:00 | Day | 07.30 | 17.30 | 17.30 | 07:30:00 | Day | 07.30 | 17.30 | 17.30 | 07:30:00 | Day | 07.30 | 17.30 | 17.30 | 07:30:00
WE3 | WE3rd (after hrs cover) |  |  |  |  |  |  |  | Day | 07.30 | 17.30 |  |  | Day | 07.30 | 17.30 |  |  | Day | 07.30 | 17.30 |  |  | Day | 07.30 | 17.30 | 17.30 | 07:30:00 |  |  |  | 07:30:00 | 07:30:00 |  |  |  | 07:30:00 | 07:30:00
WEP | [NAME] |  |  | Day | 7.30 | 17.30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30 |  |  | Day | 7.30 | 17.30
LEAVE | RLEAVE
CARDIAC1 | CARDIAC Week 1 |  |  | Early 12H | 7.00 | 19.30 |  |  | Early 12H | 7.00 | 19.30 |  |  |  |  |  |  |  | Early 12H | 7.00 | 19.30
[NAME] | CARDIAC Week 2 |  |  | Morning | 08:00:00 | 12:00:00 |  |  | Early 12H | 7.00 | 19.30 |  |  |  |  |  |  |  | Early 12H | 7.00 | 19.30 |  |  | Early 12H | 7.00 | 19.30