Spreadsheet: 682409d1592071295-cell-value-dependent-on-tablename-within-a-cell-shift-pattern-calculator-katemaz-
Sheet: Sheet1

Name | Week Number | Attribute | Shift Times
pattern1 | 1 | Monday Start | 12:00:00
pattern1 | 1 | Monday Finish | 20:00:00
pattern1 | 1 | Tuesday Start | 08:00:00
pattern1 | 1 | Tuesday Finish | 16:00:00
pattern1 | 1 | Wednesday Start | 08:00:00
pattern1 | 1 | Wednesday Finish | 16:00:00
pattern1 | 1 | Thursday Start | 07:00:00
pattern1 | 1 | Thursday Finish | 15:00:00
pattern1 | 1 | Friday Start | 08:00:00
pattern1 | 1 | Friday Finish | 16:00:00
pattern1 | 1 | Saturday Start
pattern1 | 1 | Saturday Finish
pattern1 | 1 | Sunday Start
pattern1 | 1 | Sunday Finish
pattern1 | 2 | Monday Start | 07:00:00
pattern1 | 2 | Monday Finish | 15:00:00
pattern1 | 2 | Tuesday Start | 12:00:00
pattern1 | 2 | Tuesday Finish | 20:00:00
pattern1 | 2 | Wednesday Start | 08:00:00
pattern1 | 2 | Wednesday Finish | 16:00:00
pattern1 | 2 | Thursday Start | 08:00:00
pattern1 | 2 | Thursday Finish | 16:00:00
pattern1 | 2 | Friday Start | 08:00:00
pattern1 | 2 | Friday Finish | 16:00:00
pattern1 | 2 | Saturday Start
pattern1 | 2 | Saturday Finish
pattern1 | 2 | Sunday Start
pattern1 | 2 | Sunday Finish
pattern1 | 3 | Monday Start | 08:00:00
pattern1 | 3 | Monday Finish | 16:00:00
pattern1 | 3 | Tuesday Start | 07:00:00
pattern1 | 3 | Tuesday Finish | 15:00:00
pattern1 | 3 | Wednesday Start | 08:00:00
pattern1 | 3 | Wednesday Finish | 16:00:00
pattern1 | 3 | Thursday Start | 12:00:00
pattern1 | 3 | Thursday Finish | 20:00:00
pattern1 | 3 | Friday Start | 08:00:00
pattern1 | 3 | Friday Finish | 16:00:00
pattern1 | 3 | Saturday Start
pattern1 | 3 | Saturday Finish
pattern1 | 3 | Sunday Start
pattern1 | 3 | Sunday Finish
pattern1 | 4 | Monday Start | 08:00:00
pattern1 | 4 | Monday Finish | 16:00:00
pattern1 | 4 | Tuesday Start | 08:00:00
pattern1 | 4 | Tuesday Finish | 16:00:00
pattern1 | 4 | Wednesday Start | 07:00:00
pattern1 | 4 | Wednesday Finish | 15:00:00
pattern1 | 4 | Thursday Start | 08:00:00
pattern1 | 4 | Thursday Finish | 16:00:00
pattern1 | 4 | Friday Start | 12:00:00
pattern1 | 4 | Friday Finish | 20:00:00
pattern1 | 4 | Saturday Start | 08:00:00
pattern1 | 4 | Saturday Finish | 16:00:00
pattern1 | 4 | Sunday Start | 08:00:00
pattern1 | 4 | Sunday Finish | 16:00:00
pattern1 | 5 | Monday Start
pattern1 | 5 | Monday Finish
pattern1 | 5 | Tuesday Start
pattern1 | 5 | Tuesday Finish
pattern1 | 5 | Wednesday Start | 12:00:00
pattern1 | 5 | Wednesday Finish | 20:00:00
pattern1 | 5 | Thursday Start | 08:00:00
pattern1 | 5 | Thursday Finish | 16:00:00
pattern1 | 5 | Friday Start | 07:00:00
pattern1 | 5 | Friday Finish | 15:00:00
pattern1 | 5 | Saturday Start
pattern1 | 5 | Saturday Finish
pattern1 | 5 | Sunday Start
pattern1 | 5 | Sunday Finish
pattern2 | 1 | Monday Start
pattern2 | 1 | Monday Finish
pattern2 | 1 | Tuesday Start | 07:00:00
pattern2 | 1 | Tuesday Finish | 17:00:00
pattern2 | 1 | Wednesday Start | 07:00:00
pattern2 | 1 | Wednesday Finish | 17:00:00
pattern2 | 1 | Thursday Start | 07:00:00
pattern2 | 1 | Thursday Finish | 17:00:00
pattern2 | 1 | Friday Start | 07:00:00
pattern2 | 1 | Friday Finish | 17:00:00
pattern2 | 1 | Saturday Start
pattern2 | 1 | Saturday Finish
pattern2 | 1 | Sunday Start
pattern2 | 1 | Sunday Finish
pattern2 | 2 | Monday Start | 07:00:00
pattern2 | 2 | Monday Finish | 17:00:00
pattern2 | 2 | Tuesday Start
pattern2 | 2 | Tuesday Finish
pattern2 | 2 | Wednesday Start | 07:00:00
pattern2 | 2 | Wednesday Finish | 17:00:00
pattern2 | 2 | Thursday Start | 07:00:00
pattern2 | 2 | Thursday Finish | 17:00:00
pattern2 | 2 | Friday Start | 07:00:00
pattern2 | 2 | Friday Finish | 17:00:00
pattern2 | 2 | Saturday Start
pattern2 | 2 | Saturday Finish
pattern2 | 2 | Sunday Start
pattern2 | 2 | Sunday Finish
pattern2 | 3 | Monday Start | 07:00:00
pattern2 | 3 | Monday Finish | 17:00:00
pattern2 | 3 | Tuesday Start | 07:00:00
pattern2 | 3 | Tuesday Finish | 17:00:00
pattern2 | 3 | Wednesday Start
pattern2 | 3 | Wednesday Finish
pattern2 | 3 | Thursday Start | 07:00:00
pattern2 | 3 | Thursday Finish | 17:00:00
pattern2 | 3 | Friday Start | 07:00:00
pattern2 | 3 | Friday Finish | 17:00:00
pattern2 | 3 | Saturday Start
pattern2 | 3 | Saturday Finish
pattern2 | 3 | Sunday Start
pattern2 | 3 | Sunday Finish
pattern2 | 4 | Monday Start | 07:00:00
pattern2 | 4 | Monday Finish | 17:00:00
pattern2 | 4 | Tuesday Start | 07:00:00
pattern2 | 4 | Tuesday Finish | 17:00:00
pattern2 | 4 | Wednesday Start | 07:00:00
pattern2 | 4 | Wednesday Finish | 17:00:00
pattern2 | 4 | Thursday Start
pattern2 | 4 | Thursday Finish
pattern2 | 4 | Friday Start | 07:00:00
pattern2 | 4 | Friday Finish | 17:00:00
pattern2 | 4 | Saturday Start
pattern2 | 4 | Saturday Finish
pattern2 | 4 | Sunday Start
pattern2 | 4 | Sunday Finish
pattern2 | 5 | Monday Start | 07:00:00
pattern2 | 5 | Monday Finish | 17:00:00
pattern2 | 5 | Tuesday Start | 07:00:00
pattern2 | 5 | Tuesday Finish | 17:00:00
pattern2 | 5 | Wednesday Start | 07:00:00
pattern2 | 5 | Wednesday Finish | 17:00:00
pattern2 | 5 | Thursday Start | 07:00:00
pattern2 | 5 | Thursday Finish | 17:00:00
pattern2 | 5 | Friday Start
pattern2 | 5 | Friday Finish
pattern2 | 5 | Saturday Start
pattern2 | 5 | Saturday Finish
pattern2 | 5 | Sunday Start
pattern2 | 5 | Sunday Finish