|
04/24/2007 12:45 PM
|
|
|
Does anyone have a basic collection sheet for OEE
|
|
|
|
|
04/27/2007 01:02 PM
|
|
|
Hello John !
What industry, process are you interested in ? Letting us know, maybe we can help.
BR
György
|
|
|
|
|
04/27/2007 01:02 PM
|
|
|
Dear John,
I tried posting some files in response to your question, but they
were too large. Perhaps the subsequent posts will get through to
your post. There should be 3 files in all: a blank data collection
sheet that our Team Leaders print off and use on their rounds, an
Excel spreadsheet in which they enter their data across all 3
shifts, and a set of instructions for using the spreadsheet. I hope
this helps give you a head start on implementing your OEE
system.
Regards,
Sarah
|
|
|
|
|
04/27/2007 01:02 PM
|
|
|
Dear John:
Attached is a basic data collection sheet that our Team Leaders use
to make their rounds every 2hrs, (record their reason codes for
performance/quality/availability problems), and a basic Excel
spreadsheet we use to calculate the Cell's OEE over the 24hr
period. I hope this gives you a head start toward building your OEE
system.
Regards,
Sarah
|
|
|
|
|
04/27/2007 01:18 PM
|
|
|
|
|
|
|
|
04/27/2007 01:24 PM
|
|
|
OEE Spreadsheet Instructions
|
|
|
|
|
04/27/2007 04:10 PM
|
|
|
Blank Data Collection Sheet
|
|
|
|
|
04/30/2007 02:17 PM
|
|
|
Thanks Sarah , Just what I was looking for
|
|
|
|
|
05/02/2007 08:42 AM
|
|
|
Sarah,
Thanks for the sheet but is it possible to have the password as I need to modify it slightly to incorporate different shift patterns
|
|
|
|
|
05/03/2007 09:50 AM
|
|
|
John
find attached a basic sheet compeled by operators in a mould
shop.
You will need to think about the categories of downtime etc....and
give the users some basic OEE instruction !
Mark
|
|
|
|
|
05/04/2007 08:59 AM
|
|
|
If you save the Excel document as different name on your computer you should be able to unprotect the sheet and make modifications - no password needed.
|
|
|
|
|
05/04/2007 08:59 AM
|
|
|
May I have the password also, I would like to modify it for our
company. Thanks
sdaukas@adelphia.net
|
|
|
|
|
05/04/2007 11:52 AM
|
|
|
Sara, why do you do your data collection manually. Have you looked
at the Traksys solution?
Moderator Note: In the spirit of full disclosure James Cox is an employee of the company that produces the solution he is suggesting.
Edited: 05/04/2007 at 11:52 AM by Lean Moderator
|
|
|
|
|
05/21/2007 09:46 AM
|
|
|
The Japanese prefer that the owner of the info collects it himself
and so becomes the owner of it. By plotting it he becomes the
owner of the problems, and generates his A3 accordingly.
|
|
|
|
|
05/29/2007 09:31 AM
|
|
|
Sorry all. There are no passwords. Simply "unprotecting"
the sheet from the Tools menu will suffice. It merely deters those
less familiar with computers/Excel are entering the data from
making any "tragic" errors in formats or formulae.
I agree with Roger, that's why the area/cell/value stream owners
collect and store their own data so they remain the first line fo
defense in attacking problems.
|
|
|
>
Community >
Forums
Send to a Friend
