Spreadsheet: 171755d1343847319-populate-schedule-from-shift-selection-sample-sched
Sheet: Info

Hours | Days | Weeky Shift Code | Weekly Shift Description | Work Hours | [NAME]
8A-7P | Fri-Mon | CTX-Shft01 | CTX-Fri-Mon 8A-7P | 10 | 120
8A-7P | Mon, Thurs-Sat | CTX-Shft02 | CTX-Mon, Thurs-Sat 8A-7P | 10 | 120 |  |  | 8-5A | 8-5B | 8-7A | 8-7B | 10-7A | 10-7B | 1-10A | 1-10B
8A-7P | [NAME], Thurs-Fri | CTX-Shft03 | CTX-Mon-Tues, Thurs-Fri 8A-7P | 10 | 120 |  | 8A-9A | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0
8A-7P | Mon-Wed, Fri | CTX-Shft04 | CTX-Mon-Wed, Fri 8A-7P | 10 | 120 |  | 8A-10A | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0
8A-7P | Mon-Wed, Sat | CTX-Shft05 | CTX-Mon-Wed, Sat 8A-7P | 10 | 120 |  | 10A-12p | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
8A-7P | Sat, Mon-Tues, [NAME] | CTX-Shft06 | CTX-Sat, Mon-Tues, Fri 8A-7P | 10 | 120 |  | 8A-12P | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
8A-7P | Sat, [NAME], Thurs-Fri | CTX-Shft07 | CTX-Sat, [NAME], Thurs-Fri8A-7P | 10 | 120 |  | 1P-3P | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0
8A-7P | Sat, Tues-Wed, [NAME] | CTX-Shft08 | CTX-Sat, Tues-Wed, Fri 8A-7P | 10 | 120 |  | 3P-5P | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
8A-7P | Sun-Tues, [NAME] | CTX-Shft09 | CTX-Sun-Tues, Fri 8A-7P | 10 | 120 |  | 1 to 5p | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
8A-7P | Sun-Tues, Thurs | CTX-Shft10 | CTX-Sun-Tues, Thurs 8A-7P | 10 | 120 |  | 5P-7P | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1
8A-7P | Sun-Wed | CTX-Shft11 | CTX-Sun-Wed 8A-7P | 10 | 120 |  | 8A-9P | 0 | 0 | 1 | 1 | 1 | 1 | 3 | 3
8A-7P | [NAME], Thurs-Sat | CTX-Shft12 | CTX-Tues, Thurs-Sat 8A-7P | 10 | 120
8A-7P | Wed-Sat | CTX-Shft13 | CTX-Wed-Sat 8A-7P | 10 | 120
8A-5p | Sun,Mon Wed-Fri | CTX-Shft14 | CTX-Sun,Mon Wed-Fri 8A-5P | 8 | 96 |  | Shift Names
8A-5p | Sun-Thurs | CTX-Shft15 | CTX-Sun-Thurs 8A-5P | 8 | 96 |  |  | FSR1 | FSR2 | FSR3 | FSR4 | [NAME]
1P-10P | Mon-Fri | CTX-Shft16 | CTX-Mon-Fri 1P-10P | 8 | 96 |  | 8-5A | 1A | 2A | 3A | 4A | 5A
10A-7P | Mon-Fri | CTX-Shft17 | CTX-Mon-Fri 10A-7P | 8 | 96 |  | 8-5B | 1B | 2B | 3B | 4B | 5B
8A-5p | Mon-Fri | CTX-Shft18 | CTX-Mon-Fri 8A-5p | 8 | 96 |  | 8-7A | 1C | 2C | 3C | 4C | 5C
8A-5p | Tues-Sat | CTX-Shft19 | CTX-Tues-Sat 8A-5P | 8 | 96 |  | 8-7B | 1D | 2D | 3D | 4D | 5D
8-7p | SU-Mon,Wed-Thurs | CTX-Shft20 | CTX-Sun-Mon,Wed-Thurs 8-7P | 10 | 120
 |  |  |  |  |  |  | 10-7A | 1E | 2E | 3E | 4E | 5E
8A-5p | Mon-Fri-Tues-Sat Alternating | **** | CTX-Mon-Fri-Tues-Sat Alternating 8A-5P | 8 | 96 |  | 10-7B | 1F | 2F | 3F | 4F | 5F
 |  |  |  |  |  |  | 1-10A | 1G | 2G | 3G | 4G | 5G
 |  |  |  |  |  |  | 1-10B | 1H | 2H | 3H | 4H | 5H
**** | Use alternating shifts 18 and 19
Business Title | [NAME] (types) | % of job type |  |  | Quota Groups
FSR1 | Install non tripple play/Cable Off | 80% Install |  |  | 01 | Install
 |  | 20% TC-Cable Off Only |  |  | 02 | SIK Install
 |  |  |  |  | 06 | Sig Home Install
FSR2 | All Install types/Cable Off Calls | 50% Install |  |  | 50 | Disconnects
 |  | 50% TC |  |  | 65 | General [NAME]
 |  |  |  |  | 66 | Sig Home TC
FSR3 | ALL JOB TYPES | 75% TC |  |  | 67 | Cable Off TC
 |  | 25% Install |  |  | 82 | Install SRO
 |  |  |  |  | 83 | Service SRO
FSR4 | All JOB TYPES | 100% TC
[NAME] | ALL JOB TYPES | 100% TC
FSRLT | NO QUOTA LOAD | 0% Quota for all Lead Techs
1hr Formula
0.0416666666666667
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00