{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["사용법","중요도(Y축)","만족도(X축)","IPA"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"사용법","index":0,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["IPA(Importance Performance Analysis) 분석"]
["응답자가 지각하는 특정 요소에 대한 성과(만족도)와 중요도를 각각 X와 Y축으로 하는 2차원상의 평면위에 좌표로 각 요소를 표현하는 분석방법"]
[]
["1. 각 시트 설명",null,null,null,null,null,null,null,null,null,"사분위에 대한 이해",null,null,"해석"]
["중요도(Y축), 만족도(X축)",null,null,null,null,null,null,null,null,null,"1사분면","중요도 ▲","만족도 ▲","유지"]
[null,null,null,null,null,null,null,null,null,null,"2사분면","중요도 ▽","만족도 ▲","과잉"]
["2. 적용범위",null,null,null,null,null,null,null,null,null,"3사분면","중요도 ▽","만족도 ▽","개선(저순위)"]
["X축과 Y축 두 변수는 최대 A~Z까지 26개, 응답 10,000건을 다룰 수 있도록 만들어져있습니다.",null,null,null,null,null,null,null,null,null,"4사분면","중요도 ▲","만족도 ▽","개선(집중)"]
["더 많은 데이터를 다루려면, 두 시트의 적용범위를 직접 조정해주셔야 합니다. ",null,null,null,null,null,null,null,null,null,"각 분위에 대한 해석은 "]
[null,null,null,null,null,null,null,null,null,null,"변수의 속성에 따라"]
["3. 매크로 실행",null,null,null,null,null,null,null,null,null,"다양하게 해석이 가능합니다."]
["VBA로 만든 매크로로 실행이 됩니다."]
["따라서 매크로를 사용할 수 있도록 콘텐츠 사용을 클릭해주셔야만 정상적으로 작동합니다."]
["실행은 Alt + F8 키로 작동합니다."]
[]
["4. 매크로의 수정"]
["매크로 수정을 위해서는 Alt + F11 키를 누르세요."]
["예) 차트 크기 설정: 차트의 크기는 800*600으로 설정되어 있습니다. 너비와 높이를 수정할 수 있습니다."]
["    With cht.Parent"]
["     .Width = 800"]
["     .Height = 600"]
[]
["5. 기타"]
["[IPA] 시트의 기준선 값을 임의로 변경하면, 정한 기준값으로 분류가 가능합니다."]

{"sheet":"중요도(Y축)","index":1,"n_rows":107,"n_cols":26,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["평균"]
[{"$f":"IF(A3=\"\", \"\", AVERAGE(A4:A10003))","v":4.4519230769230766},{"$f":"IF(B3=\"\", \"\", AVERAGE(B4:B10003))","v":4.4519230769230766},4.2884615384615383,3.7884615384615383,3.7692307692307692,3.7115384615384617,4.0480769230769234,4.1730769230769234,4.4038461538461542,"","","","","","","","","","","","","","","","",""]
["변수1","변수2","변수3","변수4","변수5","변수6","변수7","변수8","변수9"]
[4,4,4,3,3,3,3,5,5]
[5,5,5,4,5,5,4,4,4]
[5,5,5,4,5,4,5,5,5]
[4,4,5,4,5,5,3,4,5]
[1,1,1,1,5,4,1,5,5]
[4,4,4,4,3,3,5,4,4]
[5,5,5,5,5,5,5,5,5]
[5,5,4,4,4,3,4,4,4]
[5,4,5,3,3,3,4,5,5]
[5,5,5,4,3,3,4,4,4]
[4,4,4,4,4,4,4,4,5]
[5,5,4,4,4,4,5,4,4]
[4,5,4,4,4,4,4,4,4]
[4,4,5,4,4,4,5,5,5]
[5,5,5,4,4,4,4,4,5]
[4,4,4,3,3,3,3,4,5]
[4,4,3,3,3,3,4,2,2]
[5,5,4,4,4,4,5,5,5]
[5,5,5,5,5,5,5,5,5]
[5,5,5,2,3,4,4,4,4]
[5,5,5,3,2,2,5,5,5]
[4,4,5,4,4,4,5,5,5]
[5,5,5,5,5,5,5,5,5]
[4,4,4,3,3,3,3,3,3]
[5,5,4,5,5,5,4,4,4]
[4,4,4,4,4,3,4,4,4]
[4,4,4,4,4,4,4,4,4]
[5,5,5,5,4,4,4,4,4]
[5,5,5,5,4,4,5,3,5]
[4,5,3,3,3,4,3,3,3]
[5,5,5,5,5,5,5,5,5]
[5,5,5,5,5,5,5,5,5]
[4,5,3,4,4,4,5,4,4]
[4,4,4,4,4,4,4,4,4]
[4,4,5,4,4,4,4,4,5]
[5,5,4,4,3,3,4,5,4]
[5,5,5,5,5,5,5,5,5]
[3,3,4,4,4,3,4,3,4]
[5,5,4,4,4,4,5,4,4]
[4,3,3,4,4,4,3,4,4]
[4,4,4,4,4,4,4,4,4]
[5,5,5,4,4,4,5,5,5]
[5,5,5,4,4,4,5,5,5]
[4,4,5,5,3,3,3,3,4]
[5,5,5,4,4,4,4,4,4]
[5,5,5,4,3,3,3,5,4]
[5,5,4,3,3,2,2,3,5]
[4,5,3,3,3,3,2,2,2]
[4,4,3,3,4,4,4,4,3]
[5,5,5,5,5,5,4,4,5]
[4,5,4,4,4,4,4,4,4]
[5,4,5,3,4,3,4,5,5]
[5,5,4,4,4,4,5,5,5]
[5,4,5,3,3,3,4,5,5]
[5,5,5,3,3,3,4,4,5]
[4,4,3,3,3,3,4,4,3]
[4,4,2,2,2,2,4,4,4]
[4,4,4,3,3,3,3,4,4]
[4,5,4,3,4,4,4,4,5]
[4,3,5,4,4,4,5,4,5]
[5,5,5,5,4,2,4,4,4]
[4,5,4,4,4,4,4,4,4]
[5,5,5,4,4,4,4,4,4]
[5,5,5,5,3,3,5,5,5]
[4,5,5,4,4,4,4,4,5]
[4,4,4,4,4,4,3,4,4]
[5,5,4,4,4,4,4,5,5]
[5,5,5,5,4,4,5,4,5]
[4,4,3,3,3,3,3,4,5]
[5,5,5,3,5,5,3,4,4]
[5,5,5,5,5,5,5,5,5]
[5,5,4,4,3,3,5,4,5]
[4,4,4,3,3,3,3,3,4]
[3,4,4,4,4,4,4,5,5]
[4,4,4,3,3,3,4,4,4]
[4,4,4,4,4,4,4,4,4]
[5,5,5,4,4,4,4,5,5]
[3,4,3,4,3,3,3,4,3]
[5,5,5,5,5,5,5,5,5]
[5,2,4,4,4,4,4,4,4]
[5,4,5,4,4,4,5,5,5]
[5,5,5,3,3,3,4,4,5]
[5,5,5,3,3,3,3,4,4]
[4,4,2,2,3,2,2,4,4]
[5,5,5,3,3,5,5,5,5]
[5,5,5,4,5,5,5,5,5]
[4,4,4,4,5,5,4,4,4]
[4,4,3,4,4,4,4,4,4]
[4,4,4,3,3,3,4,4,5]
[4,5,4,4,3,3,4,4,5]
[5,5,5,3,4,4,5,4,5]
[4,4,3,3,3,3,4,4,3]
[4,2,4,4,2,2,4,4,4]
[3,4,4,3,3,3,4,4,4]
[4,5,4,4,4,4,4,4,4]
[5,5,4,4,3,3,4,4,4]
[4,4,4,4,3,4,4,2,5]
[5,4,4,4,4,4,4,4,4]
[4,4,4,3,4,3,4,3,5]
[5,4,5,4,4,4,4,5,5]
[4,4,4,4,4,4,4,3,3]
[5,5,5,4,4,4,5,5,5]
[5,5,5,5,5,5,5,5,5]
[5,5,5,2,2,2,2,4,5]

{"sheet":"만족도(X축)","index":2,"n_rows":107,"n_cols":26,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["평균"]
[{"$f":"IF(A3=\"\", \"\", AVERAGE(A4:A10003))","v":4.3557692307692308},{"$f":"IF(B3=\"\", \"\", AVERAGE(B4:B10003))","v":4.3173076923076925},4.115384615384615,3.6730769230769229,3.7115384615384617,3.7019230769230771,4.009615384615385,4.1826923076923075,4.384615384615385,"","","","","","","","","","","","","","","","",""]
["변수1","변수2","변수3","변수4","변수5","변수6","변수7","변수8","변수9"]
[4,3,4,3,3,3,4,4,4]
[5,5,5,5,5,5,5,5,5]
[5,5,5,4,5,5,5,5,5]
[4,4,5,4,5,5,3,4,5]
[3,3,1,1,5,4,1,5,5]
[4,4,4,4,4,4,5,4,4]
[5,5,5,5,5,5,5,5,5]
[5,5,4,4,4,4,5,5,5]
[5,4,5,3,3,3,4,5,5]
[5,5,5,4,3,3,4,4,4]
[4,4,4,4,4,4,4,4,5]
[4,4,3,4,3,3,4,4,4]
[5,4,4,4,4,4,4,4,4]
[5,4,5,4,5,5,5,5,5]
[4,5,4,4,4,5,5,4,4]
[4,5,3,3,3,3,3,4,4]
[4,4,3,3,3,3,4,2,2]
[5,5,4,4,4,4,5,5,5]
[5,5,5,5,4,3,4,5,5]
[5,5,5,2,3,4,4,3,4]
[5,5,5,3,2,2,5,5,5]
[4,4,5,4,4,4,5,5,5]
[4,4,4,4,5,5,5,5,5]
[3,3,3,3,3,3,3,3,3]
[5,5,4,4,4,5,4,4,5]
[4,4,4,3,3,3,4,4,4]
[4,4,4,4,4,4,4,4,4]
[5,5,5,5,4,4,4,4,4]
[5,5,5,4,4,4,5,3,5]
[4,4,3,3,3,4,4,3,3]
[5,4,4,4,4,4,4,5,5]
[5,5,5,4,5,4,5,5,5]
[4,4,3,5,5,5,5,4,4]
[4,4,4,4,4,4,4,4,4]
[5,4,5,4,4,4,5,4,5]
[5,4,4,3,3,3,5,4,4]
[5,5,5,4,4,5,3,5,5]
[4,3,4,4,3,3,3,4,3]
[5,5,5,4,4,4,5,4,4]
[4,3,4,3,2,4,4,3,4]
[4,4,4,4,4,4,4,4,4]
[5,4,5,3,3,3,4,5,5]
[4,4,5,4,4,4,4,5,5]
[4,4,4,4,4,3,3,4,4]
[5,5,5,4,4,4,4,4,4]
[4,4,5,3,3,3,3,5,4]
[5,5,4,3,3,2,2,4,5]
[4,5,3,4,3,3,2,3,3]
[3,3,3,3,4,4,4,4,4]
[5,5,5,5,5,5,4,5,5]
[4,4,4,4,4,4,4,3,4]
[5,3,5,3,4,3,4,5,5]
[5,5,4,4,4,4,5,5,5]
[3,3,3,3,3,3,3,4,4]
[5,4,5,3,3,3,4,4,5]
[4,4,4,2,4,4,4,4,4]
[4,4,3,3,3,3,3,4,4]
[4,4,5,3,3,3,3,4,4]
[3,4,4,3,4,4,4,4,5]
[3,2,5,3,4,4,5,4,4]
[4,5,4,5,4,2,5,4,4]
[4,5,4,4,4,4,4,4,4]
[5,5,5,4,4,4,4,4,4]
[4,4,5,4,3,3,5,4,5]
[4,5,3,3,4,4,4,5,5]
[4,4,4,4,4,4,3,4,4]
[4,4,4,4,4,4,4,5,5]
[5,5,5,5,5,4,5,4,5]
[4,4,4,3,3,3,3,4,5]
[5,5,2,2,5,5,3,4,4]
[5,5,5,5,5,5,5,5,5]
[5,5,4,4,3,3,5,4,5]
[4,4,3,3,4,4,3,4,4]
[3,4,4,4,4,4,4,5,5]
[4,4,4,3,3,3,4,3,4]
[4,4,4,4,4,4,4,4,3]
[5,5,5,5,3,3,5,5,5]
[4,5,3,4,3,3,4,3,3]
[5,5,5,5,5,5,5,5,5]
[5,4,2,3,4,4,4,4,4]
[5,4,5,4,4,4,5,4,5]
[4,4,5,4,4,3,4,4,5]
[4,5,3,2,2,2,2,3,3]
[5,5,2,3,3,2,3,5,5]
[5,5,5,5,3,3,5,5,5]
[4,4,4,4,4,4,4,5,5]
[4,5,4,4,5,5,4,4,4]
[4,4,3,4,4,4,4,4,4]
[5,5,4,3,3,3,4,4,5]
[5,5,4,3,3,3,4,4,5]
[5,4,3,2,1,2,4,4,4]
[4,4,3,3,3,3,4,4,3]
[3,2,3,3,2,2,3,4,5]
[3,4,4,3,3,3,4,4,4]
[4,4,4,4,4,4,4,5,5]
[4,5,4,4,3,3,4,4,4]
[4,5,4,3,3,5,4,2,4]
[4,4,4,4,4,4,4,4,4]
[4,5,5,4,4,4,3,4,4]
[5,4,5,4,4,4,4,5,5]
[4,4,4,4,4,4,4,3,3]
[5,5,5,4,4,4,4,5,5]
[5,5,5,5,5,5,5,5,5]
[5,5,4,3,3,3,2,4,5]

{"sheet":"IPA","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["기준선",{"$f":"AVERAGE('중요도(Y축)'!A4:Z10004)","v":4.1207264957264957},{"$f":"AVERAGE('만족도(X축)'!A4:Z10004)","v":4.0502136752136755},null,null,"IPA 차트를 만드려면 Alt + F8을 누르세요."]
[null,null,null,null,null,"CreatIPAChart 매크로를 선택한 후, 실행(R)을 누르세요."]
["변수명","중요도(Y축)","만족도(X축)","사분위",null,"이후 팝업이 뜨면, 데이터가 입력된 범위를 직접 지정해주세요."]
[{"$f":"IF(TRANSPOSE('중요도(Y축)'!A3:Z3)=\"\", \"\", TRANSPOSE('중요도(Y축)'!A3:Z3))","v":"변수1"},{"$f":"IF(TRANSPOSE('중요도(Y축)'!A2:Z2)=\"\", \"\", TRANSPOSE('중요도(Y축)'!A2:Z2))","v":4.4519230769230766},{"$f":"IF(TRANSPOSE('만족도(X축)'!A2:Z2)=\"\", \"\", TRANSPOSE('만족도(X축)'!A2:Z2))","v":4.3557692307692308},{"$f":"IF(A4=\"\",\"\",\n  IF(AND(B4>=$B$1,C4>=$C$1),\"성과 유지 관리\",\n    IF(AND(B4>=$B$1,C4<$C$1),\"개선(중점)\",\n      IF(AND(B4<$B$1,C4>=$C$1),\"과잉 투자\",\n        IF(AND(B4<$B$1,C4<$C$1),\"개선(낮은 순위)\",\"\"))))\n)","v":"성과 유지 관리"},null,"예) A4:C12"]
["변수2",4.4519230769230766,4.3173076923076925,{"$f":"IF(A5=\"\",\"\",\n  IF(AND(B5>=$B$1,C5>=$C$1),\"성과 유지 관리\",\n    IF(AND(B5>=$B$1,C5<$C$1),\"개선(중점)\",\n      IF(AND(B5<$B$1,C5>=$C$1),\"과잉 투자\",\n        IF(AND(B5<$B$1,C5<$C$1),\"개선(낮은 순위)\",\"\"))))\n)","v":"성과 유지 관리"}]
["변수3",4.2884615384615383,4.115384615384615,"성과 유지 관리"]
["변수4",3.7884615384615383,3.6730769230769229,"개선(낮은 순위)"]
["변수5",3.7692307692307692,3.7115384615384617,"개선(낮은 순위)"]
["변수6",3.7115384615384617,3.7019230769230771,"개선(낮은 순위)"]
["변수7",4.0480769230769234,4.009615384615385,"개선(낮은 순위)"]
["변수8",4.1730769230769234,4.1826923076923075,"성과 유지 관리"]
["변수9",4.4038461538461542,4.384615384615385,"성과 유지 관리"]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]
["","","",""]