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

(강하넷) www.kangha.net 2021년 조립검사일지 검사일자 모델명 제품명 불량유형별 수량  총불량수량  비고 용접불량 RING들뜸 P/NUT들뜸 RING누락 P/NUT누락 RING휨 P/NUT휨 PRESS품불량 BRA'T불량 RING불량 P/NUT불량 단품불량 기타 07-01-02 D840 FRONT ASS'Y 5 2 　 　 　 　 　 　 　 　 　 　 　         7 　 07-01-03 D841 FRONT ASS'Y 5 　 5 　 　 　 　 　 　 10 5 　 　        25 　 07-02-04 D842 FRONT ASS'Y 　 　 　 　 　 　 　 　 5 　 　 　 　         5 　 07-03-05 D843 FRONT ASS'Y 10 　 2 　 　 　 　 　 10 　 5 　 　        27 　 07-03-06 D844 FRONT ASS'Y 　 　 　 　 1 　 　 　 　 5 10 　 　        16 　 07-03-07 D845 FRONT ASS'Y 　 10 5 　 　 　 　 15 　 　 　 　 　        30 　 07-04-08 D843 FRONT ASS'Y 　 　 　 5 　 　 　 　 　 　 2 　 　         7 　 07-06-09 D841 FRONT ASS'Y 　 　 　 　 　 　 6 　 　 　 　 　 7        13 　 07-05-10 D848 FRONT ASS'Y 　 5 2 　 　 9 　 　 　 2 　 　 　        18 　 07-10-11 D843 FRONT ASS'Y 5 　 　 　 　 　 　 　 10 　 5 8 　        28 　 07-10-12 D850 FRONT ASS'Y 　 　 　 　 　 　 　 　 　 　 　 　 　         - 　 07-10-12 D851 FRONT ASS'Y 10 　 2 　 　 　 　 　 5 10 　 　 　        27