yuvaraj859
New Member
- Joined
- Dec 5, 2021
- Messages
- 4
- Office Version
- 2010
- Platform
- Windows
HI
Formula or macro need for the below request.
1. shift per plan need calculated - formula need ( whether i need to operate 1 , 2or 3 shift) based on the cycle time and shift working hour.
2.based on the shift per days total no of working days calculated ,- how the batch or team need to assign to line with the working days.
for example Mc 1 working days is 5.9 days and mc 2 workings days is 16.8 =total 22.7 .
so 1st 6 days batch need to work in MC 1 and next 6 days in mc 2.--- formula need for this request.
Formula or macro need for the below request.
1. shift per plan need calculated - formula need ( whether i need to operate 1 , 2or 3 shift) based on the cycle time and shift working hour.
2.based on the shift per days total no of working days calculated ,- how the batch or team need to assign to line with the working days.
for example Mc 1 working days is 5.9 days and mc 2 workings days is 16.8 =total 22.7 .
so 1st 6 days batch need to work in MC 1 and next 6 days in mc 2.--- formula need for this request.
working Days | 23 | |||||||||
MC | PRd number | Des | CYCLE TIME | Demand | total hr | shift hr | Shift plan per day | shift plan per day | No of Days | Data |
Machine 1 | 11531B | Mold 12 | 40 | 4000 | 44.44444 | 7.5 | 1 | 5.9 | Batch 1 | |
Machine 2 | 11532B | Design 32 | 40 | 34000 | 377.7778 | 7.5 | 3 | 16.8 | Batch 1 | |
Machine 3 | 9116B | copper 58*34 | 40 | 28000 | 311.1111 | 7.5 | 2 | 20.7 | Batch 2 | |
Machine 4 | 91162B | copper blue 12*43 | 40 | 500 | 5.555556 | 7.5 | 1 | 0.7 | Batch 2 | |
Machine 5 | 9153B | PRD disc.Alu .45 | 40 | 30000 | 333.3333 | 7.5 | 2 | 22.2 | Batch 3 | |
Machine 6 | 915B | MOLD 43 | 40 | 51000 | 566.6667 | 7.5 | 3 | 25.2 | Batch 4 | |
Machine 7 | L11793B | 155-HL_RED | 40 | 27000 | 300 | 7.5 | 2 | 20.0 | Batch 5 | |
Machine 8 | L1179B | 155 white | 40 | 7600 | 84.44444 | 7.5 | 1 | 11.3 | Batch 6
Excel Formula:
|