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

G A U G E R & R 데이터 표 　 부분은 반드시 입력 　 　 　 　 　 　 　 　 부서명 　 작성일 　 게이지 게이지 명 관리번호 　 작성자 　 　 책임자 　 　 주요 기능 　 　 　 측정대상 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 사양 규격상한(USL): 　 규격하한(LSL): 　 공 차 0.00 반복회수(r) : 　 시료수(n) : 　 작업자수 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 평가자 　 A 　 　 　 　 B 　 　 　 　 C 　 　 　 Parts 시료(n) 1차 2차 3차 평균 범위 1차 2차 3차 평균 범위 1차 2차 3차 평균 범위 평균 1 　 　 　 　 　 　 　 　 　 　 2 　 　 　 　 　 　 　 　 　 　 3 　 　 　 　 　 　 　 　 　 　 4 　 　 　 　 　 　 　 　 　 　 5 　 　 　 　 　 　 　 　 　 　 6 　 　 　 　 　 　 　 　 　 　 7 　 　 　 　 　 　 　 　 　 　 8 　 　 　 　 　 　 　 　 　 　 9 　 　 　 　 　 　 　 　 　 　 10 　 　 　 　 　 　 　 　 　 　 TOTAL 　 　 　 　 평균 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 Rp = 　 X Double BAR 　 UCL(Average) 　 UCL(Range) 　 EV = 　 % EV = 　 % EV = 　 R Double BAR 　 LCL(Average) 　 LCL(Range) 　 AV = 　 % AV = 　 % AV = 　 X BAR diff 　 　 MAX x Bar 　 　 MIN x Bar 　 　 R&R = 　 % R&R = 　 % R&a