R
RickJ
Need some help with OEE for the current company i am working for
Basically i need to set up a spead sheet that will allow me to enter
quantity and hours worked and provide me with there overall efficenc
for the week and then month. These formulas also would also need to b
able to work over 3 workborks and allow the efficencies the compute fo
the machies as well not only the employees.
What the spread sheet looks like is as follows:\
B3-H3 is an employee name, B4-H4 would be an empty box for the produtio
number.
The obvious answer would to just enter the data and use an averag
function to calcuclate that. My problem is that each guy doesn'
nesscarily run the same machine for the entire day.
Ex:
B3=John
B4=500(parts produced in an 8 hr shift.
B3=John
B4=250(for one operation) 300(for another)
ANY help would be greatly appreciated, i know this isn't the greates
explanation for the problem im trying to convey any questions plz fee
free to ask.
Attached file is a small example with what im working with.
Notice the multiple operations for the one example is really wha
hinders my ability to simply use a AVERAGE formula
+-------------------------------------------------------------------
|Filename: Example1.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=300
+-------------------------------------------------------------------
Basically i need to set up a spead sheet that will allow me to enter
quantity and hours worked and provide me with there overall efficenc
for the week and then month. These formulas also would also need to b
able to work over 3 workborks and allow the efficencies the compute fo
the machies as well not only the employees.
What the spread sheet looks like is as follows:\
B3-H3 is an employee name, B4-H4 would be an empty box for the produtio
number.
The obvious answer would to just enter the data and use an averag
function to calcuclate that. My problem is that each guy doesn'
nesscarily run the same machine for the entire day.
Ex:
B3=John
B4=500(parts produced in an 8 hr shift.
B3=John
B4=250(for one operation) 300(for another)
ANY help would be greatly appreciated, i know this isn't the greates
explanation for the problem im trying to convey any questions plz fee
free to ask.
Attached file is a small example with what im working with.
Notice the multiple operations for the one example is really wha
hinders my ability to simply use a AVERAGE formula
+-------------------------------------------------------------------
|Filename: Example1.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=300
+-------------------------------------------------------------------