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

(강하넷) www.kangha.net 품질현황-불량발생현황.xlsx Hybrid type 불량현황 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　  불량 수량 총계 : EA 　 221 EA 　 　 　 불량 내역 Spline Spring 1월 1,2차 LEVER 규격 　 제품 단가 서인 하이콤 불량비용(원) 불량계 (EA) 불량률 (%) 제품 단가 　 도금불량 열처리 (역조립) 불량비용(원) 프레스 (찍힘) 불량계 불량률 (%) G.Y SEVER 출고수량(EA) 부품명 사 출 공 정 조 립 공 정 (취급부주의) 불량계 불량률 생산수 합격수 불량수 불량률 비용 생산수 합격수 불량수 불량률 비용 　 　 0 0 　 0 0.00% 　 　 0 0 　 　 0 0.00% 　 　 0 　 　 0 0 0 0.000% 　 0 0 0 0.000% 　 0 0.000% 　 　 0 0 　 0 0.00% 　 　 0 0 　 　 0 0.00% 　 　 0 　 42,902 42,900 2 0.005% 　 42,920 42,900 20 0.047% 　 22 0.051% 　 　 1 0 　 1 0.02% 　 　 0 1 　 　 1 0.02% 　 　 4,900 　 104,100 104,100 0 0.000% 　 104,108 104,100 8 0.008% 　 8 0.008% 　 　 0 0 　 0 0.00% 　 　 2 0 　 　 2 0.04% 　 　 4,800 　 104,103 3 0.003% 　 104,101 1 0.001% 　 4 0.004% 　 　 1 1 　 2 0.02% 　 　 0 0 　 　 0 0.00% 　 　 11,300 　 51,512 51,500 12 0.023% 　 51,507 51,500 7 0.014% 　 19 0.037% 　 　 0 1 　 1 0.00% 　 　 2 0 　 　 2 0.01% 　 　 21,900