设备运行效率分析表（自动计算每日）

生产管理工具——生产计划与控制管理,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

设备运行效率分析表（自动计算每日）,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

说明：本文档主要用于计算和分析某一设备在一个月内每天以及本月总体的运行效率（包括时间稼动率、性能稼动率、良品率、设备综合效率等关键数据和信息分析）。本表格对部分关键数据的计算方式进行了详细说明，且在表格中以自动函数形式呈现。（表格中内含自动计算公式，只需录入部分基本数据即可，白色为录入数据部分，颜色标注部分为自动函数。）日期以2016年3月为例，若需修改，只需要修改起始日期即可，其他日期及星期皆为自动函数。,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

1.每日总计划时间设定：1天8小时*60=480分钟；2.基准生产周期设定为2分钟，也可以根据理论生产节拍设定；3.时间稼动率=实际运行时间/计划开机时间；,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

4.性能稼动率=基准生产周期*实际生产数量/稼动时间（或者实际产能/标准产能）；5.良品率=实际良品数/实际产能；6.设备综合效率（OEE）=时间稼动率*性能稼动率*良品率,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

设备编号,,,,,,设备名称,,,,,,部门/车间,,,,,日期,,,,,,,,,,,,,,,,,

日期,,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,五,六,日,一,二,三,四,全月总计,

,,1/Mar,2/Mar,3/Mar,4/Mar,5/Mar,6/Mar,7/Mar,8/Mar,9/Mar,10/Mar,11/Mar,12/Mar,13/Mar,14/Mar,15/Mar,16/Mar,17/Mar,18/Mar,19/Mar,20/Mar,21/Mar,22/Mar,23/Mar,24/Mar,25/Mar,26/Mar,27/Mar,28/Mar,29/Mar,30/Mar,31/Mar,,

理论总工作时间（分）,,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,480,14880,

"计划

停止

时间（分）",固定晨会,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,工间休息,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,点检保养,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,465,

,计划维修,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,停产调整,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,930,

负荷时间（计划开机时间）,,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,420,13020,

"计划

外

停止

时间（分）",故障维修,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,930,

,中断/调整/更换,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,20,620,

,停工/迟滞,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

,其它,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,310,

稼动时间（实际运行时间）,,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,350,10850,

实际生产总数,,160,150,120,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,155,165,150,150,150,160,150,4660,

不良品数,,2,0,5,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,63,

基准生产周期(分/个),,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,2.00,需要输入

实际生产周期(分/个),,2.19,2.33,2.92,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.33,2.26,2.12,2.33,2.33,2.33,2.19,2.33,2.33,

时间稼动率,,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,83.33%,

性能稼动率,,91.43%,85.71%,68.57%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,88.57%,94.29%,85.71%,85.71%,85.71%,91.43%,85.71%,85.90%,

良品率,,98.75%,100.00%,95.83%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.67%,98.71%,98.79%,98.67%,98.67%,98.67%,98.75%,98.67%,98.65%,

速度稼动率,,91.43%,85.71%,68.57%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,85.71%,88.57%,94.29%,85.71%,85.71%,85.71%,91.43%,85.71%,85.90%,

有效运行效率,,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,100.00%,

设备综合效率（OEE）,,75.24%,71.43%,54.76%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70.48%,70