160 likes | 528 Views
Machine data collection (MDC). Defininition. We have a lot of data sets and with these we calculate availability and capacity factor . Given data sets. Step 1-4. Choice one of 24 machine File „ xls “ in a siutable form Filtering to machine one Sort to date h,m,s. Step 5-7.
E N D
Defininition Wehave a lotofdatasetsandwiththesewecalculateavailabilityandcapacityfactor.
Step 1-4 • Choice oneof 24 machine • File „xls“ in a siutable form • Filteringtomachineone • Sorttodateh,m,s
Step 5-7 • Calculatedeadlock beginn with=ZEIT(B2;C2;D2) • Deadlock time in seconds =G2/86400
Step 8-10 • Calculate Deadlock end with =H2+I2 • Delete lapmistakewith=WENN(F2=1;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=2;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=5;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");WENN(F2=9;WENN(A2=A3;WENN(J2>H3;"JA";"Nein");"");""))))
Step 11-14 • Lap time withWENN(A2=A3;WENN(J2>H3;J2-H3;"");"") • Mistakes in twocleaving:=WENN(F2=3;WERT(I2);WENN(F2=4;WERT(I2);WENN(F2=6;WERT(I2);WENN(F2=7;WERT(I2);WENN(F2=8;WERT(I2);""))))) =WENN(F2=1;WERT(I2);WENN(F2=2;WERT(I2);WENN(F2=5;WERT(I2);WENN(F2=9;WERT(I2); "")))))
Step 15-21 • All datas in seconds • Calculate time ofmachinewith=39*24 • Calculatedeadlock time with=SUMME(I:I) • Lap time with=SUMME(M:M) • Deadlock time with=R10-R12; =SUMME(N:N)
Mistakes • Wehave a bigproblemwhichweeliminatewith a complicatedformel