Start Date | Plt Qty | Pcs | Line Rate / Hr | Time (Hrs) | Time (Days) | Estimated Completion Date | HOLIDAYLIST |
=$H$1 | =VLOOKUP(B4,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F4*D4 | =VLOOKUP(B4,Rates!C:I,7,FALSE) | =F4/H4 | =(F4/H4)/24 | =IF( (A4+J4-INT(A4))>(14/24), WORKDAY.INTL(INT(A4),1,1,HOLIDAYLIST)+6/24+ (A4+J4-INT(A4)-14/24), A4+I4/24) | 44940 |
=K4 | =VLOOKUP(B5,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F5*D5 | =VLOOKUP(B5,Rates!C:I,7,FALSE) | =F5/H5 | =(F5/H5)/24 | =IF( (A5+J5-INT(A5))>(14/24), WORKDAY.INTL(INT(A5),1,1,HOLIDAYLIST)+6/24+ (A5+J5-INT(A5)-14/24), A5+I5/24) | 44941 |
=K5 | =VLOOKUP(B6,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F6*D6 | =VLOOKUP(B6,Rates!C:I,7,FALSE) | =F6/H6 | =(F6/H6)/24 | =IF( (A6+J6-INT(A6))>(14/24), WORKDAY.INTL(INT(A6),1,1,HOLIDAYLIST)+6/24+ (A6+J6-INT(A6)-14/24), A6+I6/24) | |
=K6 | =VLOOKUP(B7,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F7*D7 | =VLOOKUP(B7,Rates!C:I,7,FALSE) | =F7/H7 | =(F7/H7)/24 | =IF( (A7+J7-INT(A7))>(14/24), WORKDAY.INTL(INT(A7),1,1,HOLIDAYLIST)+6/24+ (A7+J7-INT(A7)-14/24), A7+I7/24) | |
=K7 | =VLOOKUP(B8,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F8*D8 | =VLOOKUP(B8,Rates!C:I,7,FALSE) | =F8/H8 | =(F8/H8)/24 | =IF( (A8+J8-INT(A8))>(14/24), WORKDAY.INTL(INT(A8),1,1,HOLIDAYLIST)+6/24+ (A8+J8-INT(A8)-14/24), A8+I8/24) | |
=K8 | =VLOOKUP(B9,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F9*D9 | =VLOOKUP(B9,Rates!C:I,7,FALSE) | =F9/H9 | =(F9/H9)/24 | =IF( (A9+J9-INT(A9))>(14/24), WORKDAY.INTL(INT(A9),1,1,HOLIDAYLIST)+6/24+ (A9+J9-INT(A9)-14/24), A9+I9/24) | |
=K8 | =VLOOKUP(B10,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F10*D10 | =VLOOKUP(B10,Rates!C:I,7,FALSE) | =F10/H10 | =(F10/H10)/24 | =IF( (A10+J10-INT(A10))>(14/24), WORKDAY.INTL(INT(A10),1,1,HOLIDAYLIST)+6/24+ (A10+J10-INT(A10)-14/24), A10+I10/24) | |
=K10 | =VLOOKUP(B11,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F11*D11 | =VLOOKUP(B11,Rates!C:I,7,FALSE) | =F11/H11 | =(F11/H11)/24 | =IF( (A11+J11-INT(A11))>(14/24), WORKDAY.INTL(INT(A11),1,1,HOLIDAYLIST)+6/24+ (A11+J11-INT(A11)-14/24), A11+I11/24) | |
=K11 | =VLOOKUP(B12,'U:\Distribution and Transportation\Supply Chain\Kitting Schedule\[407 Kitting Schedule Wksheet 3.29.xlsx]Rates'!C:G,5,FALSE) | =F12*D12 | =VLOOKUP(B12,Rates!C:I,7,FALSE) | =F12/H12 | =(F12/H12)/24 | =IF( (A12+J12-INT(A12))>(14/24), WORKDAY.INTL(INT(A12),1,1,HOLIDAYLIST)+6/24+ (A12+J12-INT(A12)-14/24), A12+I12/24) | |