{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Production","Data","공정","분석테이블"],"not_rendered":{"charts":1,"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Production","index":0,"n_rows":1,"n_cols":4,"rows_kept":1}
["발생일","모델","생산수량","근무조"]

{"sheet":"Data","index":1,"n_rows":9,"n_cols":12,"rows_kept":9}
["발생일","근주조","모델","시리얼번호","공정","그룹","불량코드","불량세부내용","처리결과","수량","원인","대책"]
["2014-12-01",1,3646,null,"공정1",{"$f":"IF(OR(E2=\"공정1\",E2=\"공정2\"),\"그룹1\",\"그룹2\")","v":"그룹1"},"공정1_불량2",null,"폐기",1]
["2014-12-01",1,3646,null,"공정1",{"$f":"IF(OR(E3=\"공정1\",E3=\"공정2\"),\"그룹1\",\"그룹2\")","v":"그룹1"},"공정1_불량4",null,"폐기",2]
["2014-12-02",2,3646,null,"공정2",{"$f":"IF(OR(E4=\"공정1\",E4=\"공정2\"),\"그룹1\",\"그룹2\")","v":"그룹1"},"공정2_불량2",null,"폐기",1]
["2014-12-02",2,3646,null,"공정3","그룹2","공정3_불량4",null,"폐기",3]
["2014-12-03",3,3646,null,"공정1","그룹1","공정1_불량4",null,"폐기",3]
["2014-12-04",2,3646,null,"공정3","그룹2","공정3_불량4",null,"폐기",3]
["2014-12-05",1,3646,null,"공정4",{"$f":"IF(E8=\"\",\"\",IF(OR(E8=\"공정1\",E8=\"공정2\"),\"그룹1\",\"그룹2\"))","v":"그룹2"},"공정4_불량4",null,"폐기",3]
["2015-01-08",1,3646,null,"공정1",{"$f":"IF(E9=\"\",\"\",IF(OR(E9=\"공정1\",E9=\"공정2\"),\"그룹1\",\"그룹2\"))","v":"그룹1"},"공정1_불량3",null,"폐기",6]

{"sheet":"공정","index":2,"n_rows":7,"n_cols":9,"rows_kept":7}
["타입","Shift","판정","공정","그룹","공정1","공정2","공정3","공정4"]
[3645,1,"폐기","공정1","그룹1","공정1_불량1","공정2_불량1","공정3_불량1","공정4_불량1"]
[3646,2,"투입","공정2","그룹1","공정1_불량2","공정2_불량2","공정3_불량2","공정4_불량2"]
[3647,3,"분석대기","공정3","그룹2","공정1_불량3","공정2_불량3","공정3_불량3","공정4_불량3"]
[3648,null,"투입대기","공정4","그룹2","공정1_불량4","공정2_불량4","공정3_불량4","공정4_불량4"]
[3649,{"$nulls":4},"공정1_불량5","공정2_불량5","공정3_불량5","공정4_불량5"]
[3650,{"$nulls":4},"공정1_불량6"]

{"sheet":"분석테이블","index":3,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[{"$nulls":6},"분석날짜"]
[{"$nulls":6},"생산수량",1500]
[{"$nulls":6},"공정","불량수량","목표","불량율"]
[{"$nulls":6},"공정1",12,{"v":0.0005,"d":"0.05%"},{"$f":"IF($H$3=\"\",\"\",H5/H$3)","v":{"v":0.008,"d":"0.80%"}}]
[{"$nulls":6},"공정2",1,{"$f":"I5","v":{"v":0.0005,"d":"0.05%"}},{"$f":"IF($H$3=\"\",\"\",H6/H$3)","v":{"v":6.6666666666666664E-4,"d":"0.07%"}}]
[{"$nulls":6},"공정3",6,{"$f":"I6","v":{"v":0.0005,"d":"0.05%"}},{"$f":"IF($H$3=\"\",\"\",H7/H$3)","v":{"v":0.004,"d":"0.40%"}}]
[{"$nulls":6},"공정4",3,{"v":0.0005,"d":"0.05%"},{"$f":"IF($H$3=\"\",\"\",H8/H$3)","v":{"v":2E-3,"d":"0.20%"}}]
[{"$nulls":6},"합계",{"$f":"SUM(H5:H8)","v":22},{"v":0.0005,"d":"0.05%"},{"$f":"SUM(J5:J8)","v":{"v":0.014666666666666666,"d":"1.47%"}}]
{"$rows_empty":11}
["파란하늘 블로그"]
[]
[]
["불량 리포트"]
["모델","공정","불량유형","수량","기타"]