Scribd
Upload
76 views3 pages

3 Pass Schedule With Multiple Calendars: W/C Calendar

The document describes a 3 pass schedule for multiple work centers using different calendars. Work centers 6, 7, and 8 will complete jobs A, B, and C over 3 passes or operations, but since they use different calendars, the start and end dates and times for each job and operation will vary between work centers based on complex calendar formulas. The schedule is expanded to include the calendar formulas so that each date and time in the schedule accurately reflects the translation between calendars.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views3 pages

3 Pass Schedule With Multiple Calendars: W/C Calendar

The document describes a 3 pass schedule for multiple work centers using different calendars. Work centers 6, 7, and 8 will complete jobs A, B, and C over 3 passes or operations, but since they use different calendars, the start and end dates and times for each job and operation will vary between work centers based on complex calendar formulas. The schedule is expanded to include the calendar formulas so that each date and time in the schedule accurately reflects the translation between calendars.

Uploaded by

sahilsahni20
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

3 Pass Schedule With Multiple Calendars

Centre 6 will translate into 3/15/00 5:30 PM according to Calendar 2, but if Work Centre 7 works to Calend
another date and time, will have to pass through the calendar formulas. That's an awful lot of formulas, but

W/C Calendar
6 Calendar 2
7 Calendar 1
8 Calendar 2

Start of first job:

Pu
Prev. Op
W/C Calendar Jobs Op Job/Op Hours Days Due Prev. Op Row
6 Calendar 2 job A 1 A/1 6 0.25 A/0 #N/A
6 Calendar 2 job B 1 B/1 12 0.5 B/0 #N/A
6 Calendar 2 job C 1 C/1 8 0.333333 C/0 #N/A
7 Calendar 1 job A 2 A/2 8 0.333333 A/1 15
7 Calendar 1 job B 2 B/2 20 0.833333 B/1 16
7 Calendar 1 job C 2 C/2 8 0.333333 C/1 17
8 Calendar 2 job A 3 A/3 16 0.666667 ### A/2 18
8 Calendar 2 job B 3 B/3 8 0.333333 ### B/2 19
8 Calendar 2 job C 3 C/3 16 0.666667 22/3 8:00 C/2 20
k Centre 7 works to Calendar 1, hour 17 may translate into a completely different date and time. Every instance were
an awful lot of formulas, but lets start by adding the calendar formulas to the schedule in Section 33:

14/3 6:00

Push 1 Pull
Stop of Next Op Start of
Prev. Op Start Calc1 Calc2 Calc3 Stop Next Op Row Next Op Stop
### 14/3 6:00 6 0.375 8 ### A/2 18 ### ###
### ### 8 0.625 14 16/3 8:00 B/2 19 ### ###
### 16/3 8:00 14 1.125 17 ### C/2 20 ### ###
### ### 9 0.75 13 ### A/3 21 ### ###
16/3 8:00 16/3 8:00 17 1.5 25 ### B/3 22 ### ###
### ### 25 2.333333 29 ### C/3 23 ### ###
### ### 11 0.833333 18 17/3 8:00 A/4 #N/A ### ###
### ### 22 1.833333 25 ### B/4 #N/A ### ###
### ### 25 2.166667 32 ### C/4 #N/A 22/3 8:00 22/3 8:00
d time. Every instance were a duration is added or subtracted from a date and time, to get to
Section 33:

Pull Push 2
Stop of
Calc4 Calc5 Calc6 Start Prev. Op Start Calc7 Calc8 Calc9 Stop
7 0.5 4 ### ### 14/3 6:00 6 0.375 8 ###
12 1 7 ### ### ### 8 0.625 14 16/3 8:00
19 1.625 15 ### ### ### 15 1.291667 19 ###
13 1.166667 10 ### ### ### 10 0.833333 13 ###
22 2.083333 14 ### 16/3 8:00 16/3 8:00 17 1.5 25 ###
26 2.458333 23 ### ### ### 25 2.333333 29 ###
18 1.583333 11 ### ### ### 11 0.916667 18 ###
22 1.916667 18 ### ### ### 22 1.833333 25 ###
30 2.583333 22 ### ### ### 25 2.166667 32 ###

You might also like