Shift & manpower calulation

yuvaraj859

New Member
Joined
Dec 5, 2021
Messages
4
Office Version
  1. 2010
Platform
  1. 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.


working Days
23​
MCPRd numberDesCYCLE TIMEDemandtotal hrshift hrShift plan per dayshift plan per dayNo of DaysData
Machine 111531BMold 12404000
44.44444​
7.5​
1​
5.9​
Batch 1
Machine 211532BDesign 324034000
377.7778​
7.5​
3​
16.8​
Batch 1
Machine 39116Bcopper 58*344028000
311.1111​
7.5​
2​
20.7​
Batch 2
Machine 491162Bcopper blue 12*4340500
5.555556​
7.5​
1​
0.7​
Batch 2
Machine 59153BPRD disc.Alu .454030000
333.3333​
7.5​
2​
22.2​
Batch 3
Machine 6915BMOLD 434051000
566.6667​
7.5​
3​
25.2​
Batch 4
Machine 7L11793B155-HL_RED4027000
300​
7.5​
2​
20.0​
Batch 5
Machine 8L1179B155 white407600
84.44444​
7.5​
1​
11.3​
Batch 6
Excel Formula:
google sheet
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,223,911
Messages
6,175,334
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top