엑셀 자동화 업무 프로그램, 문서 및 양식

GAGE R&R DATA SHEET 결 재 작성 검토 승인 　 　 　 검측일 　 DATA SHEET No. 　 기록자 　 계측자 (a) 　 시험대상 　 계측자 (b) 　 제품명 　 관리번호 　 검교정일 　 계측자(c) 　 구자원 PART AVERAGE TRIAL A B C D E F G H I J 1 (a) 　 　 　 　 　 　 　 　 　 　 　 0 2 (a) 　 　 　 　 　 　 　 　 　 　 　 0 3 (a) 　 　 　 　 　 　 　 　 　 　 　 0 AVE 0 0 0 0 0 0 0 0 0 0 Xa= 0 R 　 　 　 　 　 　 　 　 　 　 Ra= 0 김정훈 PART AVERAGE TRIAL A B C D E F G H I J 1 (b) 　 　 　 　 　 　 　 　 　 　 　 0 2 (b) 　 　 　 　 　 　 　 　 　 　 　 0 3 (b) 　 　 　 　 　 　 　 　 　 　 　 0 AVE 0 0 0 0 0 0 0 0 0 0 Xb= 0 R 　 　 　 　 　 　 　 　 　 　 Rb= 0 김정훈 PART AVERAGE TRIAL A B C D E F G H I J 1 (b) 　 　 　 　 　 　 　 　 　 　 　 0 2 (b) 　 　 　 　 　 　 　 　 　 　 　 0 3 (b) 　 　 　 　 　 　 　 　 　 　 　 0 AVE 0 0 0 0 0 0 0 0 0 0 Xb= 0 R 　 　 　 　 　 　 　 　 　 　 Rb= 0 # 기초 DATA PART AVERAGE = ( Xa + Xb+.......) / (# OF APPRAISERS) = X= 0 R AVERAGE = (Ra + Rb +…...) / (# OF APPRAISERS) = R= 0 Max X - Min x Rp= 0 Xdiff = MAX R -MIN R = Xdiff= 0 www.kangha.net Email : kangha@daum.net