Efficiency and Availability Analysis for Machined Data Acquisition
80 likes | 168 Vues
Analyze raw data to determine efficiency and availability of machine processes. Set filters and parameters to calculate utilization and identify issues.
Efficiency and Availability Analysis for Machined Data Acquisition
E N D
Presentation Transcript
Machinedataacquisition Hager Michael
Rawdata 2/8 Hager Michael 7.11.2012
Goal • Analysingrawdatand find out efficiencyandavialability Task setting • Efficiency • Avialability 3/8 Hager Michael 7.11.2012
Working process • Setting filtertomymachine • Event start: converthh:mm:ss • Event end: „=H2+ZEIT(0;0;G2) • Stoodcauseconvert:=SVERWEIS“(F2;Tabelle2!$A$2:$B$10;2) • Plausibility: =WENN(I2<H3;“positiv“;WENN(A2<A3;“positiv“;“negativ“)) • Delete negatives 4/8 Hager Michael 7.11.2012
Working process • TRU: • TI: 5/8 Hager Michael 7.11.2012
Working process • Utilization rate • =((P21-P22-P23-P24)/P21)*100 6/8 Hager Michael 7.11.2012
Working process • availability • =(O30/(O30+O31))*100 7/8 Hager Michael 7.11.2012
End product 8/8 Hager Michael 7.11.2012