设备综合效率oee计算表(1)

1、部门/区域：Department生产部生产线/设备名称:Equipment/line Name代号日期12345A上班到下班的时间-包括加班时间(分)Work to the work time-i nclud ing overtime (poi nts)840840840840840B1用餐时间(分)+工间休息时间(分)Dinner time (po in ts) and tak ing coffee breaks time (po in ts)3030303030B2设备点检、润滑及做5S的时间(分)Equipme nt tally, lubricati on and do5 S time

2、(poi nts)2020202020B3开会时间(分)Meeting time(points)00000B净利用时间(分)Net use time (po in ts)B=A-B1-B2-B3790790790790790B4产品转型/换模时间(分)Product the conv ersi on /Tooli ng cha nge time (po in ts)300000B5设备故障停机时间(分)Equipme nt dow ntime (po in ts)00000B6工装/模具故障停机时间(分)Tooli ng/mould dow ntime (po in ts)00000B7生产前

3、准备时间(分)Production preparation time(poi nts)00000B8物料短缺时间(分)Material shortage time(poi nts)00000B9质里缺陷时间(分)Quality defect time(poi nts)00000B10操作失误时间(分)Operational error time(points)00000C作业时间(分)Homework time (poi nts) C=B-B4-B5-B6-B7-B8-B9 -B10760790790790790D设备利用率Equipme nt utilizati onD=C/B96.2%10

4、0.0%100.0%100.0%100.0%E产量 producti on(包括合格与不合格的) (in clud ing qualified and the1080011600129001080010800Funq ualiTied)理想节拍时间(分)The ideal takt time (poi nts)0.0570.0570.0570.0570.057G设备性能效率Equipme nt efficie ncyG=(F*E)/C81.0%83.7%93.1%77.9%77.9%E1返工数量(件)Rework nu mber (piece)108000000E2报废数量(件)Scrap a

5、mount (Piece)0350250H质量率 Quality rate H=(E-E1-E2)/E0.0%99.7%100.0%99.8%100.0%MOEE 目标值 Desired value70%70%70%70%70%NOEE=D*G*H0.0%83.4%93.1%77.7%77.9%P设备故障停机率Equipme nt breakdow n rateP=B5/B0%0%0%0%0%Q工装/模具故障停机率Tooli ng/Mould breakdow n rateQ=B6/B0%0%0%0%0%异常记录：（将异常情况记录下来，作为后续追踪、统计、分析、对策之重要资料）Abnormal

6、 records: （wil记录Record设备效率数据收集表（OEE DATA WORKSline 1678910111213141596066036001320144084013201320132040203003030303030301010100101010101010000000000091063032001280140080012801280128000000200000000000000000000000000000000000000000000000000000000000000000910630320012801380800128012801280100.0%100.0%10

7、0.0%#DIV/0!100.0%98.6%100.0%100.0%100.0%100.0%116001290050000148001890075001756016500175000.0570.0450.06200.0750.070.0970.070.070.0772.7%92.1%96.9%#DIV/0!86.7%95.9%90.9%96.0%90.2%95.7%0000000000400000002001599.7%100.0%100.0%#DIV/0!100.0%100.0%100.0%99.9%100.0%99.9%70%70%70%70%70%70%70%70%70%70%72.4%

8、92.1%96.9%#DIV/0!86.7%94.5%90.9%95.9%90.2%95.6%0%0%0%#DIV/0!0%0%0%0%0%0%0%0%0%#DIV/0!0%0%0%0%0%0%林bnormal records: (will record the abnormal situation, as a follow-up tracking, statistical analysis, the counterme检查check upDATA WORKSHEET):Equipme nt N16171819202122232425132013201320132013801440108007

9、203003030303050303001010101010102020100101000001000000128012801280128013001390104007002800000101520000000000000000000480000000000000000000000000000000000000000000001280128012801280129089510200700280设备编号2016 年6月100.0%100.0%100.0%100.0%99.2%64.4%98.1%#DIV/0!100.0%100.0%14800175001250017500169009500129

10、000700026000.070.070.070.070.0750.0870.07800.0970.09780.9%95.7%68.4%95.7%98.3%92.3%98.6%#DIV/0!97.0%90.1%000000000000350000000100.0%100.0%99.7%100.0%100.0%100.0%100.0%#DIV/0!100.0%100.0%70%70%70%70%70%70%70%70%70%70%80.9%95.7%68.2%95.7%97.5%59.5%96.8%#DIV/0!97.0%90.1%0%0%0%0%0%0%0%#DIV/0!0%0%0%0%0%0

11、%0%35%0%#DIV/0!0%0%an alysis, the coun termeasures of importa nt material),审核Exam ine2016 年6月编号:Equipment N o. 125-26262728293031综合13201320132013201320030540101010101007201010101010035000000010130013001300130013000294600000009500000000000004800000000000000000000000000000130013001300130013000288852016 年6月100.0%100.0%100.0%100.0%100.0%#DIV/0!#DIV/0!1250014500125001350011500125003673600.070.070.070.070.070.0767.3%78.1%67.3%72.7%61.9%#DIV/