Calculating changeover frequency

vxk5018

New Member
Joined
Sep 30, 2014
Messages
9
Hi,

I am looking for help and I think the sum(if(frequency formula can help me but I can't fully understand what is going on. I have 2 types of changeovers I need to calculate. A minor changeover is a change from SKU to SKU. A major changeover is a change from 1 size to another size. The minor changeover is only 6 hours and a major changeover is 32 hours. Based off the table below, there are 4 changeovers, 2 of which are major. I need two formulas - one to identify how many major changeovers there are and then apply the hours per changeover accordingly and one to identify how many minor changeovers there are (total - major) or vice versa (how many minor changeovers and then major changeovers (total-minor). I plan on having a dropdown for each site where production is running so the number of SKU's, the sizes and number of sizes, and the production amounts will change with each dropdown selection.


SKUSizeOct 14 Production
240
3432
40.50
510
6210
7430
8215

<tbody>
</tbody>

Minor Changeover: should be 2 minor changes * 6 hours = 12
Major Changeover: should be 2 major changes * 32 hours = 64

Thanks for your help. Let me know if you need more information.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,109,465
Messages
5,528,962
Members
409,848
Latest member
Blomsten
Top