80 likes | 156 Views
Machine data acquisition. Hager Michael. Raw data. 2/8. Hager Michael. 7.11.2012. Goal. Analysing raw data nd find out efficiency and avialability Task setting Efficiency A vialability. 3/8. Hager Michael. 7.11.2012. Working process. Setting filter to my machine
E N D
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