{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["利用方法","集計","IHI","集計結果","集計結果サマリー","チェック形骸化症","クレーム軽視症","言い訳過多症","納期意識過剰症","ルール失調症"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
["アンケート集計ツールの利用方法"]
[]
["【前提条件】"]
["・本ツールは複数の組織をまとめて集計し、組織ごとに結果を表示する機能はありません。"]
["　複数の組織での集計を行う場合は、組織ごとに集計してください。"]
[]
["・１つのフォルダ内のアンケート結果を集計します。"]
[]
["【集計手順】"]
["１．集計するためのアンケート結果のファイルを１つのフォルダに配置します。"]
[]
["２．本シートの［参照］ボタンでアンケート結果の配置されたフォルダを指定します。"]
["　　※Ｂ２セルに直接パスを記載（コピペ）でも構いません。"]
[]
["３．本シートの［集計］ボタンで集計を開始します。"]
[]
["４．集計完了後、メッセージが表示され、「集計結果サマリー」シートに切り替わります。"]
[]
["【データのフィルタリング方法】"]
["・「集計結果」シートのフィルター機能でデータをフィルタリングし、「集計結果サマリー」に反映することができます。"]
[]
["■ 「経験年数」（A列）でフィルタリングする場合"]
[null,"2年以下",null,1]
[null,"3年～4年",null,2]
[null,"5年～10年",null,3]
[null,"11年～15年",null,4]
[null,"16年～20年",null,5]
[null,"21年～25年",null,6]
[null,"26年以上",null,7]
[]
["■ 「開発対象システム」（B列からI列）でフィルタリングする場合"]
[null,"B列からI列の集計したい対象システムのTRUEをフィルタリングします。"]
[]
["■ 「職業分類」（J列）でフィルタリングする場合"]
[null,"管理職",null,1]
[null,"一般職",null,2]
[]
["■ 「職種」（K列からQ列）でフィルタリングする場合"]
[null,"K列からQ列の集計したい職種のTRUEをフィルタリングします。"]
[]
[]
["【その他】"]
["・アンケート結果のファイルがネットワーク上に配置されている場合、［参照］ボタンでフォルダを指定後、すぐに［集計］ボタンを押すとエラーが出る現象が確認されています。"]
["　そのような場合は、［参照］ボタンでフォルダ指定後、5秒程度待って［集計］ボタンを押してください。"]

{"sheet":"集計","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"IHI","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"\\\\fsv04.toshiba.local\\jskk\\17品質\\ワーク\\hirosaka\\SQiP品質保証部長の会\\アンケートＶ２\\IHI\\⑤業務支援系.xlsx"]

{"sheet":"集計結果","index":3,"n_rows":1,"n_cols":75,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["経験年数","ゲーム・エンターテイメント","業務支援ソフト","会計・経理システム","基幹業務システム","社会インフラ","組込み","OS・ミドルウェア","その他","管理職／一般職","プロジェクトマネージャ","設計者","プログラマ","テスター","品質検査・管理","運用保守","その他","Ｑ１","Ｑ２","Ｑ３","Ｑ４","Ｑ５","Ｑ６","Ｑ７","Ｑ８","Ｑ９","Ｑ１０","Ｑ１１","Ｑ１２","Ｑ１３","Ｑ１４","Ｑ１５","Ｑ１６","Ｑ１７","Ｑ１８","Ｑ１９","Ｑ２０","Ｑ２１［品質］","Ｑ２１［納期］","Ｑ２１［コスト］","Ｑ２２","Ｑ２３","Ｑ２４","Ｑ２５","Ｑ２６","Ｑ２７","Ｑ２８","Ｑ２９「トレーサビリティを意識して記録（議事録等）を残している」","Ｑ２９「余裕を持った作業をしている」","Ｑ２９「リスクヘッジは上位者の仕事なので、言われたことだけ行う」","Ｑ２９「顧客、上司を満足させるため、必要なことはなんでもやる」","Ｑ２９「業務やＰＪ内の情報は自分の作業に関係なくても把握するようにしている」","Ｑ２９「現在の工程だけでなく、前工程、後工程のことを考えている」","Ｑ２９「適当なところで妥協するようにしている」","Ｑ３０","Ｑ３１","Ｑ３２","Ｑ３３","Ｑ３４","Ｑ３５","Ｑ３６「面白い」","Ｑ３６「停止しない（落ちない）」","Ｑ３６「使いやすい」","Ｑ３６「ビジネスに貢献」","Ｑ３６「仕様通り」","Ｑ３６「安全である」","Ｑ３６「計算結果が正確」","Ｑ３６「顧客業務の効率化に寄与」","Ｑ３６「法律、制度に合致」","Ｑ３６「市場ニーズに合致」","あなたの顧客指向","あなたの職場の雰囲気","あなた自身の思い","あなた自身の行動","あなたの品質意識の大きさ"]

{"sheet":"集計結果サマリー","index":4,"n_rows":294,"n_cols":30,"rows_kept":294,"cut":false,"hidden":false,"merged":[[278,3,282,3],[278,4,282,11],[278,12,278,14],[279,12,279,14],[280,12,280,14],[281,12,281,14],[282,12,282,14],[284,3,293,3],[284,4,293,11],[284,12,284,15],[285,12,285,15],[286,12,286,15],[287,12,287,15],[288,12,288,15],[289,12,289,15],[290,12,290,15],[291,12,291,15],[292,12,292,15],[293,12,293,15],[268,3,272,3],[268,4,272,11],[268,12,268,14],[269,12,269,14],[270,12,270,14],[271,12,271,14],[272,12,272,14],[273,3,277,3],[273,4,277,11],[273,12,273,14],[274,12,274,14],[275,12,275,14],[276,12,276,14],[277,12,277,14],[258,3,262,3],[258,4,262,11],[258,12,258,14],[259,12,259,14],[260,12,260,14],[261,12,261,14],[262,12,262,14],[263,3,267,3],[263,4,267,11],[263,12,263,14],[264,12,264,14],[265,12,265,14],[266,12,266,14],[267,12,267,14],[252,3,252,11],[252,12,252,14],[253,3,257,3],[253,4,257,11],[253,12,253,14],[254,12,254,14],[255,12,255,14],[256,12,256,14],[257,12,257,14],[148,3,152,3],[148,4,152,11],[148,12,148,14],[149,12,149,14],[150,12,150,14],[151,12,151,14],[152,12,152,14],[153,3,157,3],[153,4,157,11],[153,12,153,14],[142,3,142,11],[142,12,142,14],[143,3,147,3],[143,4,147,11],[143,12,143,14],[144,12,144,14],[145,12,145,14],[146,12,146,14],[147,12,147,14],[188,3,192,3],[188,4,192,11],[188,12,188,14],[189,12,189,14],[190,12,190,14],[191,12,191,14],[192,12,192,14],[194,3,199,3],[194,4,199,11],[178,3,182,3],[178,4,182,11],[178,12,178,14],[179,12,179,14],[180,12,180,14],[181,12,181,14],[182,12,182,14],[184,12,184,14],[185,12,185,14],[183,3,187,3],[183,4,187,11],[183,12,183,14],[168,3,172,3],[168,4,172,11],[168,12,168,14],[169,12,169,14],[170,12,170,14],[171,12,171,14],[172,12,172,14],[173,3,177,3],[173,4,177,11],[173,12,173,14],[174,12,174,14],[175,12,175,14],[176,12,176,14],[177,12,177,14],[158,3,162,3],[158,4,162,11],[158,12,158,14],[159,12,159,14],[160,12,160,14],[161,12,161,14],[162,12,162,14],[163,3,167,3],[163,4,167,11],[163,12,163,14],[164,12,164,14],[165,12,165,14],[166,12,166,14],[167,12,167,14],[214,12,214,14],[213,12,213,14],[212,12,212,14],[211,12,211,14],[210,12,210,14],[61,16,61,18],[62,16,62,18],[63,16,63,18],[64,16,64,18],[65,16,65,18],[66,16,66,18],[67,16,67,18],[154,12,154,14],[155,12,155,14],[156,12,156,14],[157,12,157,14],[186,12,186,14],[187,12,187,14],[34,3,35,7],[1,2,1,29],[61,3,61,5],[62,3,62,5],[241,4,247,8],[241,3,247,3],[87,12,87,14],[88,4,92,11],[88,3,92,3],[87,3,87,11],[204,3,204,11],[38,3,38,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[43,3,43,5],[44,3,44,5],[42,3,42,5],[39,16,39,18],[40,16,40,18],[41,16,41,18],[42,16,42,18],[43,16,43,18],[44,16,44,18],[2,27,2,28],[2,23,2,24],[124,12,124,14],[125,12,125,14],[119,12,119,14],[120,12,120,14],[121,12,121,14],[122,12,122,14],[118,4,122,11],[118,12,118,14],[108,4,112,11],[106,12,106,14],[107,12,107,14],[103,4,107,11],[88,12,88,14],[89,12,89,14],[90,12,90,14],[91,12,91,14],[92,12,92,14],[45,16,45,18],[123,12,123,14],[8,21,9,28],[5,3,6,7],[15,21,16,23],[133,3,137,3],[128,4,132,11],[128,3,132,3],[133,12,133,14],[134,12,134,14],[128,12,128,14],[129,12,129,14],[130,12,130,14],[131,12,131,14],[132,12,132,14],[135,12,135,14],[136,12,136,14],[137,12,137,14],[108,3,112,3],[113,12,113,14],[114,12,114,14],[113,4,117,11],[113,3,117,3],[108,12,108,14],[109,12,109,14],[110,12,110,14],[111,12,111,14],[112,12,112,14],[115,12,115,14],[116,12,116,14],[117,12,117,14],[103,3,107,3],[93,3,97,3],[98,12,98,14],[99,12,99,14],[100,12,100,14],[101,12,101,14],[98,4,102,11],[98,3,102,3],[93,12,93,14],[94,12,94,14],[95,12,95,14],[96,12,96,14],[97,12,97,14],[93,4,97,11],[102,12,102,14],[103,12,103,14],[104,12,104,14],[105,12,105,14],[246,9,246,15],[241,9,241,15],[242,9,242,15],[243,9,243,15],[244,9,244,15],[245,9,245,15],[220,12,220,14],[221,12,221,14],[222,12,222,14],[223,12,223,14],[224,12,224,14],[230,12,230,14],[231,12,231,14],[238,12,238,14],[239,12,239,14],[227,12,227,14],[228,12,228,14],[229,12,229,14],[235,4,239,11],[247,9,247,15],[210,4,214,11],[10,3,10,6],[11,3,11,6],[9,3,9,6],[11,21,12,23],[11,24,12,25],[133,4,137,11],[205,3,209,3],[204,12,204,14],[210,3,214,3],[215,12,215,14],[216,12,216,14],[207,12,207,14],[208,12,208,14],[209,12,209,14],[205,4,209,11],[205,12,205,14],[206,12,206,14],[126,12,126,14],[127,12,127,14],[123,4,127,11],[123,3,127,3],[118,3,122,3],[217,12,217,14],[218,12,218,14],[219,12,219,14],[215,4,219,11],[215,3,219,3],[220,3,224,3],[220,4,224,11],[225,12,225,14],[226,12,226,14],[225,4,229,11],[225,3,229,3],[235,3,239,3],[232,12,232,14],[233,12,233,14],[234,12,234,14],[230,4,234,11],[230,3,234,3],[235,12,235,14],[236,12,236,14],[237,12,237,14],[12,3,12,6],[13,3,13,6],[11,26,12,28],[13,21,14,23],[13,24,14,25],[13,26,14,28],[17,21,18,23],[19,21,20,23],[21,21,22,23],[15,24,16,25],[17,24,18,25],[19,24,20,25],[21,24,22,25],[15,26,16,28],[17,26,18,28],[19,26,20,28],[21,26,22,28]]}
[]
[null,null,"品質意識アンケート集計結果"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"集計対象件数：",null,{"$f":"SUBTOTAL(103,集計結果!$A$2:$A$1048576)","v":0},null,"集計件数：",null,{"$f":"COUNTA(集計結果!$A$2:$A$1048576)","v":0}]
[]
[]
[null,null,null,"■ あなたの組織の診断結果"]
[]
[]
[null,null,null,"あなたの組織の品質意識",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"あなたの組織の気になる症状は？"]
[null,null,null,"あなたの組織の「顧客指向」",null,null,null,{"$f":"SUBTOTAL(101,集計結果!BC2:BH1048576)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"あなたの組織の「職場の雰囲気」",null,null,null,{"$f":"SUBTOTAL(101,集計結果!R2:AA1048576)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"（クリックすると原因処方が確認できます）"]
[null,null,null,"あなたの組織の「思い」",null,null,null,{"$f":"SUBTOTAL(101,集計結果!AB2:AK1048576)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"症状",null,null,"ポイント",null,"危険度"]
[null,null,null,"あなたの組織の「行動」",null,null,null,{"$f":"SUBTOTAL(101,集計結果!AO2:AU1048576)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"あなたの組織の品質意識の「大きさ」",null,null,null,{"$f":"(((H13+H11)*H12/2)*H10/3)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"チェック形骸化症",null,null,{"$f":"AVERAGE(R100,R110)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Y14>=0.8,\"なし\",IF(Y14>=0.5,\"小\",IF(Y14>=0.25,\"中\",IF(Y14<0.25,\"大\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"クレーム軽視症",null,null,{"$f":"AVERAGE(R115,R130,R160,R175,R190,R237)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Y16>=0.8,\"なし\",IF(Y16>=0.5,\"小\",IF(Y16>=0.25,\"中\",IF(Y16<0.25,\"大\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"言い訳過多症",null,null,{"$f":"AVERAGE(R110,R120,R150,R190)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Y18>=0.8,\"なし\",IF(Y18>=0.5,\"小\",IF(Y18>=0.25,\"中\",IF(Y18<0.25,\"大\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"納期意識過剰症",null,null,{"$f":"AVERAGE(R170,V196)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Y20>=0.8,\"なし\",IF(Y20>=0.5,\"小\",IF(Y20>=0.25,\"中\",IF(Y20<0.25,\"大\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ルール失調症",null,null,{"$f":"AVERAGE(R110,R125,R150,R170,R222)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Y22>=0.8,\"なし\",IF(Y22>=0.5,\"小\",IF(Y22>=0.25,\"中\",IF(Y22<0.25,\"大\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"■ プロフィール"]
[]
[]
[null,null,null,"経験年数",null,null,null,null,null,null,null,null,null,null,null,null,"開発対象システム"]
[null,null,null,"2年以下",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=1))","v":0},null,null,null,null,null,null,null,null,null,"ゲーム・エンターテイメント",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!B\"&ROW(INDIRECT(\"集計結果!$B$2:$B$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$B$2:$B$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"3年～4年",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=2))","v":0},null,null,null,null,null,null,null,null,null,"業務支援ソフト",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!C\"&ROW(INDIRECT(\"集計結果!$C$2:$C$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$C$2:$C$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"5年～10年",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=3))","v":0},null,null,null,null,null,null,null,null,null,"会計・経理システム",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!D\"&ROW(INDIRECT(\"集計結果!$D$2:$D$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$D$2:$D$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"11年～15年",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=4))","v":0},null,null,null,null,null,null,null,null,null,"基幹業務システム",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!E\"&ROW(INDIRECT(\"集計結果!$E$2:$E$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$E$2:$E$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"16年～20年",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=5))","v":0},null,null,null,null,null,null,null,null,null,"社会インフラ",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!F\"&ROW(INDIRECT(\"集計結果!$F$2:$F$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$F$2:$F$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"21年～25年",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=6))","v":0},null,null,null,null,null,null,null,null,null,"組込み",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!G\"&ROW(INDIRECT(\"集計結果!$G$2:$G$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$G$2:$G$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"26年以上",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!A\"&ROW(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$A$2:$A$\"&$AD$3+1)=7))","v":0},null,null,null,null,null,null,null,null,null,"OS・ミドルウェア",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!H\"&ROW(INDIRECT(\"集計結果!$H$2:$H$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$H$2:$H$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!I\"&ROW(INDIRECT(\"集計結果!$I$2:$I$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$I$2:$I$\"&$AD$3+1)=TRUE))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"職業分類",null,null,null,null,null,null,null,null,null,null,null,null,"職種"]
[null,null,null,"管理職",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$J$2:$J$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$J$2:$J$\"&$AD$3+1)=1))","v":0},null,null,null,null,null,null,null,null,null,"プロジェクトマネージャ",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!K\"&ROW(INDIRECT(\"集計結果!$K$2:$K$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$K$2:$K$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,"一般職",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$J$2:$J$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$J$2:$J$\"&$AD$3+1)=2))","v":0},null,null,null,null,null,null,null,null,null,"設計者",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!L\"&ROW(INDIRECT(\"集計結果!$L$2:$L$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$L$2:$L$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"プログラマ",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!M\"&ROW(INDIRECT(\"集計結果!$M$2:$M$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$M$2:$M$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"テスター",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!N\"&ROW(INDIRECT(\"集計結果!$N$2:$N$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$N$2:$N$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"品質検査・管理",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!O\"&ROW(INDIRECT(\"集計結果!$O$2:$O$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$O$2:$O$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"運用保守",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!P\"&ROW(INDIRECT(\"集計結果!$P$2:$P$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$P$2:$P$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"その他",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!Q\"&ROW(INDIRECT(\"集計結果!$Q$2:$Q$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Q$2:$Q$\"&$AD$3+1)=TRUE))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"あなたの職場の雰囲気"]
[null,null,null,"設問",null,null,null,null,null,null,null,null,"回答",null,null,"個数","割合"]
[null,null,null,"Ｑ１","私の職場では、会社の品質に対する考えを理解し、共に取り組んでいる。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1)=5))","v":0},{"$f":"P89/SUM($P$89:$P$93)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1)=4))","v":0},{"$f":"P90/SUM($P$89:$P$93)","v":{"$error":"#DIV/0!"}},{"$f":"(P89*2+P90*1+P92*-1+P93*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ１",{"$f":"R90","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1)=3))","v":0},{"$f":"P91/SUM($P$89:$P$93)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ２",{"$f":"R95","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1)=2))","v":0},{"$f":"P92/SUM($P$89:$P$93)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R90>=1,\"高い\",IF(R90>=0.5,\"やや高い\",IF(R90>=0,\"やや低い\",IF(R90<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ３",{"$f":"R100","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$R$2:$R$\"&$AD$3+1)=1))","v":0},{"$f":"P93/SUM($P$89:$P$93)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ４",{"$f":"R105","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２","私の職場では、進捗会議や定例会の報告が、日々の改善に繋がっている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1)=5))","v":0},{"$f":"P94/SUM($P$94:$P$98)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ５",{"$f":"R110","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1)=4))","v":0},{"$f":"P95/SUM($P$94:$P$98)","v":{"$error":"#DIV/0!"}},{"$f":"(P94*2+P95*1+P97*-1+P98*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ６",{"$f":"R115","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1)=3))","v":0},{"$f":"P96/SUM($P$94:$P$98)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ７",{"$f":"R120","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1)=2))","v":0},{"$f":"P97/SUM($P$94:$P$98)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R95>=1,\"高い\",IF(R95>=0.5,\"やや高い\",IF(R95>=0,\"やや低い\",IF(R95<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ８",{"$f":"R125","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$S$2:$S$\"&$AD$3+1)=1))","v":0},{"$f":"P98/SUM($P$94:$P$98)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ９",{"$f":"R130","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３","私の職場では、品質を確認するチェックリストのチェックを機械的に行っている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1)=1))","v":0},{"$f":"P99/SUM($P$99:$P$103)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ１０",{"$f":"R135","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1)=2))","v":0},{"$f":"P100/SUM($P$99:$P$103)","v":{"$error":"#DIV/0!"}},{"$f":"(P99*-2+P100*-1+P102*1+P103*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1)=3))","v":0},{"$f":"P101/SUM($P$99:$P$103)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1)=4))","v":0},{"$f":"P102/SUM($P$99:$P$103)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R100>=1,\"高い\",IF(R100>=0.5,\"やや高い\",IF(R100>=0,\"やや低い\",IF(R100<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$T$2:$T$\"&$AD$3+1)=5))","v":0},{"$f":"P103/SUM($P$99:$P$103)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ４","私の職場では、進捗状況や開発状況をふまえて、親身になった指示・指導がされている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1)=5))","v":0},{"$f":"P104/SUM($P$104:$P$108)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1)=4))","v":0},{"$f":"P105/SUM($P$104:$P$108)","v":{"$error":"#DIV/0!"}},{"$f":"(P104*2+P105*1+P107*-1+P108*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1)=3))","v":0},{"$f":"P106/SUM($P$104:$P$108)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1)=2))","v":0},{"$f":"P107/SUM($P$104:$P$108)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R105>=1,\"高い\",IF(R105>=0.5,\"やや高い\",IF(R105>=0,\"やや低い\",IF(R105<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$U$2:$U$\"&$AD$3+1)=1))","v":0},{"$f":"P108/SUM($P$104:$P$108)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ５","私の職場では、品質ルールの目的（なぜそのルールがあるのか）が説明されている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1)=5))","v":0},{"$f":"P109/SUM($P$109:$P$113)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1)=4))","v":0},{"$f":"P110/SUM($P$109:$P$113)","v":{"$error":"#DIV/0!"}},{"$f":"(P109*2+P110*1+P112*-1+P113*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1)=3))","v":0},{"$f":"P111/SUM($P$109:$P$113)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1)=2))","v":0},{"$f":"P112/SUM($P$109:$P$113)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R110>=1,\"高い\",IF(R110>=0.5,\"やや高い\",IF(R110>=0,\"やや低い\",IF(R110<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$V$2:$V$\"&$AD$3+1)=1))","v":0},{"$f":"P113/SUM($P$109:$P$113)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ６","私の職場では、成功事例や失敗事例が、品質ルールの遵守や改善の取組に活かされている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1)=5))","v":0},{"$f":"P114/SUM($P$114:$P$118)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1)=4))","v":0},{"$f":"P115/SUM($P$114:$P$118)","v":{"$error":"#DIV/0!"}},{"$f":"(P114*2+P115*1+P117*-1+P118*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1)=3))","v":0},{"$f":"P116/SUM($P$114:$P$118)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1)=2))","v":0},{"$f":"P117/SUM($P$114:$P$118)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R115>=1,\"高い\",IF(R115>=0.5,\"やや高い\",IF(R115>=0,\"やや低い\",IF(R115<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$W$2:$W$\"&$AD$3+1)=1))","v":0},{"$f":"P118/SUM($P$114:$P$118)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ７","私の職場では、不具合が発生すると、原因や責任は確認せずに、担当者を攻めたてることが多い。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1)=1))","v":0},{"$f":"P119/SUM($P$119:$P$123)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1)=2))","v":0},{"$f":"P120/SUM($P$119:$P$123)","v":{"$error":"#DIV/0!"}},{"$f":"(P119*-2+P120*-1+P122*1+P123*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1)=3))","v":0},{"$f":"P121/SUM($P$119:$P$123)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1)=4))","v":0},{"$f":"P122/SUM($P$119:$P$123)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R120>=1,\"高い\",IF(R120>=0.5,\"やや高い\",IF(R120>=0,\"やや低い\",IF(R120<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$X$2:$X$\"&$AD$3+1)=5))","v":0},{"$f":"P123/SUM($P$119:$P$123)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ８","私の職場では、知識や技能を継続的に維持向上できる教育・訓練が行われている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1)=5))","v":0},{"$f":"P124/SUM($P$124:$P$128)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1)=4))","v":0},{"$f":"P125/SUM($P$124:$P$128)","v":{"$error":"#DIV/0!"}},{"$f":"(P124*2+P125*1+P127*-1+P128*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1)=3))","v":0},{"$f":"P126/SUM($P$124:$P$128)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1)=2))","v":0},{"$f":"P127/SUM($P$124:$P$128)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R125>=1,\"高い\",IF(R125>=0.5,\"やや高い\",IF(R125>=0,\"やや低い\",IF(R125<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Y$2:$Y$\"&$AD$3+1)=1))","v":0},{"$f":"P128/SUM($P$124:$P$128)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ９","私の職場では、お客様からのクレーム情報に対応するルールがあり、活用されている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1)=5))","v":0},{"$f":"P129/SUM($P$129:$P$133)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1)=4))","v":0},{"$f":"P130/SUM($P$129:$P$133)","v":{"$error":"#DIV/0!"}},{"$f":"(P129*2+P130*1+P132*-1+P133*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1)=3))","v":0},{"$f":"P131/SUM($P$129:$P$133)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1)=2))","v":0},{"$f":"P132/SUM($P$129:$P$133)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R130>=1,\"高い\",IF(R130>=0.5,\"やや高い\",IF(R130>=0,\"やや低い\",IF(R130<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$Z$2:$Z$\"&$AD$3+1)=1))","v":0},{"$f":"P133/SUM($P$129:$P$133)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１０","私の職場では、プロジェクト終了時に振り返りを行い、改善を検討している。",null,null,null,null,null,null,null,"振り返り、常に改善につなげる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1)=5))","v":0},{"$f":"P134/SUM($P$134:$P$138)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"振り返り、時々、改善につなげる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1)=4))","v":0},{"$f":"P135/SUM($P$134:$P$138)","v":{"$error":"#DIV/0!"}},{"$f":"(P134*2+P135*1+P137*-1+P138*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"振り返りはするが、改善にはつながらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1)=3))","v":0},{"$f":"P136/SUM($P$134:$P$138)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"必要と思うが振り返りはしない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1)=2))","v":0},{"$f":"P137/SUM($P$134:$P$138)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R135>=1,\"高い\",IF(R135>=0.5,\"やや高い\",IF(R135>=0,\"やや低い\",IF(R135<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"振り返りは必要ない／わからない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AA$2:$AA$\"&$AD$3+1)=1))","v":0},{"$f":"P138/SUM($P$134:$P$138)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,"あなた自身の思い"]
[null,null,null,"設問",null,null,null,null,null,null,null,null,"回答",null,null,"個数","割合"]
[null,null,null,"Ｑ１１","私は、会社の品質に対する考えを、自分の言葉で理解している。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1)=5))","v":0},{"$f":"P144/SUM($P$144:$P$148)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1)=4))","v":0},{"$f":"P145/SUM($P$144:$P$148)","v":{"$error":"#DIV/0!"}},{"$f":"(P144*2+P145*1+P147*-1+P148*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ１１",{"$f":"R145","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1)=3))","v":0},{"$f":"P146/SUM($P$144:$P$148)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ１２",{"$f":"R150","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1)=2))","v":0},{"$f":"P147/SUM($P$144:$P$148)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R145>=1,\"高い\",IF(R145>=0.5,\"やや高い\",IF(R145>=0,\"やや低い\",IF(R145<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ１３",{"$f":"R155","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AB$2:$AB$\"&$AD$3+1)=1))","v":0},{"$f":"P148/SUM($P$144:$P$148)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ１４",{"$f":"R160","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１２","私は、品質ルールには無駄があると思っている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1)=1))","v":0},{"$f":"P149/SUM($P$149:$P$153)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ１５",{"$f":"R165","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1)=2))","v":0},{"$f":"P150/SUM($P$149:$P$153)","v":{"$error":"#DIV/0!"}},{"$f":"(P149*-2+P150*-1+P152*1+P153*2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ１６",{"$f":"R170","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1)=3))","v":0},{"$f":"P151/SUM($P$149:$P$153)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ１７",{"$f":"R175","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1)=4))","v":0},{"$f":"P152/SUM($P$149:$P$153)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R150>=1,\"高い\",IF(R150>=0.5,\"やや高い\",IF(R150>=0,\"やや低い\",IF(R150<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ１８",{"$f":"R180","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AC$2:$AC$\"&$AD$3+1)=5))","v":0},{"$f":"P153/SUM($P$149:$P$153)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ１９",{"$f":"R185","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１３","私は、品質に関して職場の達成すべき目標を理解している。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1)=5))","v":0},{"$f":"P154/SUM($P$154:$P$158)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ２０",{"$f":"R190","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1)=4))","v":0},{"$f":"P155/SUM($P$154:$P$158)","v":{"$error":"#DIV/0!"}},{"$f":"(P154*2+P155*1+P157*-1+P158*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1)=3))","v":0},{"$f":"P156/SUM($P$154:$P$158)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1)=2))","v":0},{"$f":"P157/SUM($P$154:$P$158)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R155>=1,\"高い\",IF(R155>=0.5,\"やや高い\",IF(R155>=0,\"やや低い\",IF(R155<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AD$2:$AD$\"&$AD$3+1)=1))","v":0},{"$f":"P158/SUM($P$154:$P$158)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１４","私は、お客様からのクレームを分析し、対策することが開発プロセスの改善に役に立つとは思わない。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1)=1))","v":0},{"$f":"P159/SUM($P$159:$P$163)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1)=2))","v":0},{"$f":"P160/SUM($P$159:$P$163)","v":{"$error":"#DIV/0!"}},{"$f":"(P159*-2+P160*-1+P162*1+P163*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1)=3))","v":0},{"$f":"P161/SUM($P$159:$P$163)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1)=4))","v":0},{"$f":"P162/SUM($P$159:$P$163)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R160>=1,\"高い\",IF(R160>=0.5,\"やや高い\",IF(R160>=0,\"やや低い\",IF(R160<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AE$2:$AE$\"&$AD$3+1)=5))","v":0},{"$f":"P163/SUM($P$159:$P$163)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１５","私は、仕事のやり方が、どうすればより良くなるかを考えている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1)=5))","v":0},{"$f":"P164/SUM($P$164:$P$168)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1)=4))","v":0},{"$f":"P165/SUM($P$164:$P$168)","v":{"$error":"#DIV/0!"}},{"$f":"(P164*2+P165*1+P167*-1+P168*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1)=3))","v":0},{"$f":"P166/SUM($P$164:$P$168)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1)=2))","v":0},{"$f":"P167/SUM($P$164:$P$168)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R165>=1,\"高い\",IF(R165>=0.5,\"やや高い\",IF(R165>=0,\"やや低い\",IF(R165<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AF$2:$AF$\"&$AD$3+1)=1))","v":0},{"$f":"P168/SUM($P$164:$P$168)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１６","私は、お客さまに約束した納期を守るためなら、社内ルールやプロセスを無視するのはある程度やむ得ないと思う。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1)=1))","v":0},{"$f":"P169/SUM($P$169:$P$173)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1)=2))","v":0},{"$f":"P170/SUM($P$169:$P$173)","v":{"$error":"#DIV/0!"}},{"$f":"(P169*-2+P170*-1+P172*1+P173*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1)=3))","v":0},{"$f":"P171/SUM($P$169:$P$173)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1)=4))","v":0},{"$f":"P172/SUM($P$169:$P$173)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R170>=1,\"高い\",IF(R170>=0.5,\"やや高い\",IF(R170>=0,\"やや低い\",IF(R170<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AG$2:$AG$\"&$AD$3+1)=5))","v":0},{"$f":"P173/SUM($P$169:$P$173)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１７","私は、些細なクレームならば、ほかに重要なことがあるので無視しても仕方ないと考えている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1)=1))","v":0},{"$f":"P174/SUM($P$174:$P$178)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1)=2))","v":0},{"$f":"P175/SUM($P$174:$P$178)","v":{"$error":"#DIV/0!"}},{"$f":"(P174*-2+P175*-1+P177*1+P178*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1)=3))","v":0},{"$f":"P176/SUM($P$174:$P$178)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1)=4))","v":0},{"$f":"P177/SUM($P$174:$P$178)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R175>=1,\"高い\",IF(R175>=0.5,\"やや高い\",IF(R175>=0,\"やや低い\",IF(R175<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AH$2:$AH$\"&$AD$3+1)=5))","v":0},{"$f":"P178/SUM($P$174:$P$178)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１８","私は、仕事全体を考え、他部門の人とも相談や意見交換をすべきと考えている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1)=5))","v":0},{"$f":"P179/SUM($P$179:$P$183)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1)=4))","v":0},{"$f":"P180/SUM($P$179:$P$183)","v":{"$error":"#DIV/0!"}},{"$f":"(P179*2+P180*1+P182*-1+P183*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1)=3))","v":0},{"$f":"P181/SUM($P$179:$P$183)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1)=2))","v":0},{"$f":"P182/SUM($P$179:$P$183)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R180>=1,\"高い\",IF(R180>=0.5,\"やや高い\",IF(R180>=0,\"やや低い\",IF(R180<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AI$2:$AI$\"&$AD$3+1)=1))","v":0},{"$f":"P183/SUM($P$179:$P$183)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ１９","私は、上役や職場のメンバーと、よく対話をし、互いの考え方を理解している。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1)=5))","v":0},{"$f":"P184/SUM($P$184:$P$188)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1)=4))","v":0},{"$f":"P185/SUM($P$184:$P$188)","v":{"$error":"#DIV/0!"}},{"$f":"(P184*2+P185*1+P187*-1+P188*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1)=3))","v":0},{"$f":"P186/SUM($P$184:$P$188)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1)=2))","v":0},{"$f":"P187/SUM($P$184:$P$188)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R185>=1,\"高い\",IF(R185>=0.5,\"やや高い\",IF(R185>=0,\"やや低い\",IF(R185<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AJ$2:$AJ$\"&$AD$3+1)=1))","v":0},{"$f":"P188/SUM($P$184:$P$188)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２０","私は、他部署のクレームの内容や対策が、自分の参考にはならないと考えている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1)=1))","v":0},{"$f":"P189/SUM($P$189:$P$193)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1)=2))","v":0},{"$f":"P190/SUM($P$189:$P$193)","v":{"$error":"#DIV/0!"}},{"$f":"(P189*-2+P190*-1+P192*1+P193*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1)=3))","v":0},{"$f":"P191/SUM($P$189:$P$193)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1)=4))","v":0},{"$f":"P192/SUM($P$189:$P$193)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R190>=1,\"高い\",IF(R190>=0.5,\"やや高い\",IF(R190>=0,\"やや低い\",IF(R190<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AK$2:$AK$\"&$AD$3+1)=5))","v":0},{"$f":"P193/SUM($P$189:$P$193)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Ｑ２１","ソフトウェア開発における「品質」、「納期」、「コスト」について、あなたの重要度で順位付けをしてください。",null,null,null,null,null,null,null,"「品質」→「納期」→「コスト」",null,null,"ＱＤＣ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=1)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=2)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=3))","v":0},null,null,null,null,{"$f":"(Q197+Q198)/SUM(Q195:Q200)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"「品質」→「コスト」→「納期」",null,null,"ＱＣＤ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=1)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=3)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=2))","v":0},null,null,null,null,{"$f":"IF(V195>=0.3,0.2,IF(V195>=0.2,0.25,IF(V195>=0.1,0.5,0.8)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"「納期」→「品質」→「コスト」",null,null,"ＤＱＣ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=2)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=1)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=3))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"「納期」→「コスト」→「品質」",null,null,"ＤＣＱ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=3)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=1)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"「コスト」→「品質」→「納期」",null,null,"ＣＱＤ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=2)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=3)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"「コスト」→「納期」→「品質」",null,null,"ＣＤＱ",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AL$2:$AL$\"&$AD$3+1)=3)*(INDIRECT(\"集計結果!$AM$2:$AM$\"&$AD$3+1)=2)*(INDIRECT(\"集計結果!$AN$2:$AN$\"&$AD$3+1)=1))","v":0}]
[]
[]
[]
[null,null,null,"あなた自身の行動"]
[null,null,null,"設問",null,null,null,null,null,null,null,null,"回答",null,null,"個数","割合"]
[null,null,null,"Ｑ２２","私は、品質目標を達成するために、具体的な行動計画を設定している。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1)=5))","v":0},{"$f":"P206/SUM($P$206:$P$210)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1)=4))","v":0},{"$f":"P207/SUM($P$206:$P$210)","v":{"$error":"#DIV/0!"}},{"$f":"(P206*2+P207*1+P209*-1+P210*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ２２",{"$f":"R207","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1)=3))","v":0},{"$f":"P208/SUM($P$206:$P$210)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ２３",{"$f":"R212","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1)=2))","v":0},{"$f":"P209/SUM($P$206:$P$210)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R207>=1,\"高い\",IF(R207>=0.5,\"やや高い\",IF(R207>=0,\"やや低い\",IF(R207<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ２４",{"$f":"R217","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AO$2:$AO$\"&$AD$3+1)=1))","v":0},{"$f":"P210/SUM($P$206:$P$210)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ２５",{"$f":"R222","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２３","私は、上記で設定した行動計画を、責任を持ってやり遂げている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1)=5))","v":0},{"$f":"P211/SUM($P$211:$P$215)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ２６",{"$f":"R227","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1)=4))","v":0},{"$f":"P212/SUM($P$211:$P$215)","v":{"$error":"#DIV/0!"}},{"$f":"(P211*2+P212*1+P214*-1+P215*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ２７",{"$f":"R232","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1)=3))","v":0},{"$f":"P213/SUM($P$211:$P$215)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ２８",{"$f":"R237","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1)=2))","v":0},{"$f":"P214/SUM($P$211:$P$215)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R212>=1,\"高い\",IF(R212>=0.5,\"やや高い\",IF(R212>=0,\"やや低い\",IF(R212<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AP$2:$AP$\"&$AD$3+1)=1))","v":0},{"$f":"P215/SUM($P$211:$P$215)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２４","私は、目標に対する結果を振り返り、次に実行できることを決めて取り組んでいる。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1)=5))","v":0},{"$f":"P216/SUM($P$216:$P$220)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1)=4))","v":0},{"$f":"P217/SUM($P$216:$P$220)","v":{"$error":"#DIV/0!"}},{"$f":"(P216*2+P217*1+P219*-1+P220*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1)=3))","v":0},{"$f":"P218/SUM($P$216:$P$220)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1)=2))","v":0},{"$f":"P219/SUM($P$216:$P$220)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R217>=1,\"高い\",IF(R217>=0.5,\"やや高い\",IF(R217>=0,\"やや低い\",IF(R217<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AQ$2:$AQ$\"&$AD$3+1)=1))","v":0},{"$f":"P220/SUM($P$216:$P$220)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２５","私は、お客様の要求ならば、組織の品質ルールの優先度は下げている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1)=1))","v":0},{"$f":"P221/SUM($P$221:$P$225)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1)=2))","v":0},{"$f":"P222/SUM($P$221:$P$225)","v":{"$error":"#DIV/0!"}},{"$f":"(P221*-2+P222*-1+P224*1+P225*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1)=3))","v":0},{"$f":"P223/SUM($P$221:$P$225)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1)=4))","v":0},{"$f":"P224/SUM($P$221:$P$225)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R222>=1,\"高い\",IF(R222>=0.5,\"やや高い\",IF(R222>=0,\"やや低い\",IF(R222<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AR$2:$AR$\"&$AD$3+1)=5))","v":0},{"$f":"P225/SUM($P$221:$P$225)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２６","私は、社内の手順書・SOP（マニュアル等）やデータを、有効に活用している。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1)=5))","v":0},{"$f":"P226/SUM($P$226:$P$230)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1)=4))","v":0},{"$f":"P227/SUM($P$226:$P$230)","v":{"$error":"#DIV/0!"}},{"$f":"(P226*2+P227*1+P229*-1+P230*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1)=3))","v":0},{"$f":"P228/SUM($P$226:$P$230)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1)=2))","v":0},{"$f":"P229/SUM($P$226:$P$230)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R227>=1,\"高い\",IF(R227>=0.5,\"やや高い\",IF(R227>=0,\"やや低い\",IF(R227<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AS$2:$AS$\"&$AD$3+1)=1))","v":0},{"$f":"P230/SUM($P$226:$P$230)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ２７","私は、悪い情報であっても、迅速に、報告・連絡・相談を行っている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1)=5))","v":0},{"$f":"P231/SUM($P$231:$P$235)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1)=4))","v":0},{"$error":"#DIV/0!"},{"$f":"(P231*2+P232*1+P234*-1+P235*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1)=3))","v":0},{"$error":"#DIV/0!"},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1)=2))","v":0},{"$error":"#DIV/0!"},{"$f":"IF(R232>=1,\"高い\",IF(R232>=0.5,\"やや高い\",IF(R232>=0,\"やや低い\",IF(R232<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AT$2:$AT$\"&$AD$3+1)=1))","v":0},{"$error":"#DIV/0!"}]
[null,null,null,"Ｑ２８","私は、クレームを上げるお客様側にも原因があると思う場合は、対応を後回しにしている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1)=1))","v":0},{"$error":"#DIV/0!"},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1)=2))","v":0},{"$error":"#DIV/0!"},{"$f":"(P236*-2+P237*-1+P239*1+P240*2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1)=3))","v":0},{"$error":"#DIV/0!"},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1)=4))","v":0},{"$error":"#DIV/0!"},{"$f":"IF(R237>=1,\"高い\",IF(R237>=0.5,\"やや高い\",IF(R237>=0,\"やや低い\",IF(R237<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AU$2:$AU$\"&$AD$3+1)=5))","v":0},{"$error":"#DIV/0!"}]
[]
[null,null,null,"Ｑ２９","私は、ソフトウェア開発の作業では以下の行動を行っている。",null,null,null,null,"トレーサビリティを意識して記録（議事録等）を残している",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AV$2:$AV$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AV$2:$AV$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"余裕を持った作業をしている",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AW$2:$AW$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AW$2:$AW$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"リスクヘッジは上位者の仕事なので、言われたことだけ行う",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AX$2:$AX$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AX$2:$AX$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"顧客、上司を満足させるため、必要なことはなんでもやる",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AY$2:$AY$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AY$2:$AY$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"業務やＰＪ内の情報は自分の作業に関係なくても把握するようにしている",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$AZ$2:$AZ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$AZ$2:$AZ$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"現在の工程だけでなく、前工程、後工程のことを考えている",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BA$2:$BA$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BA$2:$BA$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,"適当なところで妥協するようにしている",null,null,null,null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BB$2:$BB$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BB$2:$BB$\"&$AD$3+1)=TRUE))","v":0}]
[]
[]
[]
[null,null,null,"あなたの顧客指向"]
[null,null,null,"設問",null,null,null,null,null,null,null,null,"回答",null,null,"個数","割合"]
[null,null,null,"Ｑ３０","私は、開発しているシステムや製品の利用者が、どのような人達かを、思い浮かべながら開発をしている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1)=5))","v":0},{"$f":"P254/SUM($P$254:$P$258)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1)=4))","v":0},{"$f":"P255/SUM($P$254:$P$258)","v":{"$error":"#DIV/0!"}},{"$f":"(P254*2+P255*1+P257*-1+P258*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ３０",{"$f":"R255","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1)=3))","v":0},{"$f":"P256/SUM($P$254:$P$258)","v":{"$error":"#DIV/0!"}},"評価",null,null,"Ｑ３１",{"$f":"R260","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1)=2))","v":0},{"$f":"P257/SUM($P$254:$P$258)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R255>=1,\"高い\",IF(R255>=0.5,\"やや高い\",IF(R255>=0,\"やや低い\",IF(R255<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}},null,null,"Ｑ３２",{"$f":"R265","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BC$2:$BC$\"&$AD$3+1)=1))","v":0},{"$f":"P258/SUM($P$254:$P$258)","v":{"$error":"#DIV/0!"}},null,null,null,"Ｑ３３",{"$f":"R270","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３１","私は、開発しているシステムや製品に対しての、お客様が期待している価値がわかっている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1)=5))","v":0},{"$f":"P259/SUM($P$259:$P$263)","v":{"$error":"#DIV/0!"}},"評価点",null,null,"Ｑ３４",{"$f":"R275","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1)=4))","v":0},{"$f":"P260/SUM($P$259:$P$263)","v":{"$error":"#DIV/0!"}},{"$f":"(P259*2+P260*1+P262*-1+P263*-2)/$AD$3","v":{"$error":"#DIV/0!"}},null,null,"Ｑ３５",{"$f":"R280","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1)=3))","v":0},{"$f":"P261/SUM($P$259:$P$263)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1)=2))","v":0},{"$f":"P262/SUM($P$259:$P$263)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R260>=1,\"高い\",IF(R260>=0.5,\"やや高い\",IF(R260>=0,\"やや低い\",IF(R260<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BD$2:$BD$\"&$AD$3+1)=1))","v":0},{"$f":"P263/SUM($P$259:$P$263)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３２","私は、開発しているシステムや製品が使われる業務内容や、利用方法を理解して開発をしている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1)=5))","v":0},{"$f":"P264/SUM($P$264:$P$268)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1)=4))","v":0},{"$f":"P265/SUM($P$264:$P$268)","v":{"$error":"#DIV/0!"}},{"$f":"(P264*2+P265*1+P267*-1+P268*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1)=3))","v":0},{"$f":"P266/SUM($P$264:$P$268)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1)=2))","v":0},{"$f":"P267/SUM($P$264:$P$268)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R265>=1,\"高い\",IF(R265>=0.5,\"やや高い\",IF(R265>=0,\"やや低い\",IF(R265<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BE$2:$BE$\"&$AD$3+1)=1))","v":0},{"$f":"P268/SUM($P$264:$P$268)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３３","私は、開発しているシステムや製品を、お客様の目的に合致させるために、どのような技術が必要かを考えている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1)=5))","v":0},{"$f":"P269/SUM($P$269:$P$273)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1)=4))","v":0},{"$f":"P270/SUM($P$269:$P$273)","v":{"$error":"#DIV/0!"}},{"$f":"(P269*2+P270*1+P272*-1+P273*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1)=3))","v":0},{"$f":"P271/SUM($P$269:$P$273)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1)=2))","v":0},{"$f":"P272/SUM($P$269:$P$273)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R270>=1,\"高い\",IF(R270>=0.5,\"やや高い\",IF(R270>=0,\"やや低い\",IF(R270<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BF$2:$BF$\"&$AD$3+1)=1))","v":0},{"$f":"P273/SUM($P$269:$P$273)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３４","私は、開発しているシステムや製品でトラブルがあった場合、お客様の目線で対応をしている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1)=5))","v":0},{"$f":"P274/SUM($P$274:$P$278)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1)=4))","v":0},{"$f":"P275/SUM($P$274:$P$278)","v":{"$error":"#DIV/0!"}},{"$f":"(P274*2+P275*1+P277*-1+P278*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1)=3))","v":0},{"$f":"P276/SUM($P$274:$P$278)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1)=2))","v":0},{"$f":"P277/SUM($P$274:$P$278)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R275>=1,\"高い\",IF(R275>=0.5,\"やや高い\",IF(R275>=0,\"やや低い\",IF(R275<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BG$2:$BG$\"&$AD$3+1)=1))","v":0},{"$f":"P278/SUM($P$274:$P$278)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Ｑ３５","私は、開発しているシステムや製品でクレームが発生しないように心がけて開発をしている。",null,null,null,null,null,null,null,"非常にあてはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1)=5))","v":0},{"$f":"P279/SUM($P$279:$P$283)","v":{"$error":"#DIV/0!"}},"評価点"]
[null,null,null,null,null,null,null,null,null,null,null,null,"まあまあ当てはまる",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1)=4))","v":0},{"$f":"P280/SUM($P$279:$P$283)","v":{"$error":"#DIV/0!"}},{"$f":"(P279*2+P280*1+P282*-1+P283*-2)/$AD$3","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"どちらとも言えない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1)=3))","v":0},{"$f":"P281/SUM($P$279:$P$283)","v":{"$error":"#DIV/0!"}},"評価"]
[null,null,null,null,null,null,null,null,null,null,null,null,"あまりあてはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1)=2))","v":0},{"$f":"P282/SUM($P$279:$P$283)","v":{"$error":"#DIV/0!"}},{"$f":"IF(R280>=1,\"高い\",IF(R280>=0.5,\"やや高い\",IF(R280>=0,\"やや低い\",IF(R280<0,\"低い\",\"\"))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"全く当てはまらない",null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BH$2:$BH$\"&$AD$3+1)=1))","v":0},{"$f":"P283/SUM($P$279:$P$283)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Ｑ３６","私は、以下の価値を提供することを意識してソフトウェア開発を行っている。",null,null,null,null,null,null,null,"面白い",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BI$2:$BI$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BI$2:$BI$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"停止しない（落ちない）",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BJ$2:$BJ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BJ$2:$BJ$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"使いやすい",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BK$2:$BK$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BK$2:$BK$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ビジネスに貢献",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BL$2:$BL$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BL$2:$BL$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"仕様通り",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BM$2:$BM$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BM$2:$BM$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"安全である",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BN$2:$BN$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BN$2:$BN$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"計算結果が正確",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BO$2:$BO$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BO$2:$BO$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"顧客業務の効率化に寄与",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BP$2:$BP$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BP$2:$BP$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"法律、制度に合致",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BQ$2:$BQ$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BQ$2:$BQ$\"&$AD$3+1)=TRUE))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"市場ニーズに合致",null,null,null,{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"集計結果!J\"&ROW(INDIRECT(\"集計結果!$BR$2:$BR$\"&$AD$3+1))))*(INDIRECT(\"集計結果!$BR$2:$BR$\"&$AD$3+1)=TRUE))","v":0}]

{"sheet":"チェック形骸化症","index":5,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,5,2],[29,1,30,3],[7,1,7,3]]}
[]
[null,"病名",null,"チェック形骸化症"]
[null,"症状",null,"チェックリストを用いてレ点チェックしていても問題が発生する。"]
[]
[null,"放置して\nおくと",null,"・問題点を自身で改善しようとする意識がなくなる。"]
[null,null,null,"・やるべきことはやっているように見えるのに、品質問題が発生し続ける。"]
[]
[null,"原因と処方"]
[]
[null,"１）原因：担当者のチェックが形骸化し、チェックがチェックになっていない。"]
[null,"処方：チェックをすることの意義、目的を教育指導する。"]
[]
[null,"２）原因：チェック項目が過不足、チェック内容が判りずらい。"]
[null,"処方：チェックリストを改訂する。（不足項目は追加、冗長となった項目は削除。）"]
[null,null,"チェックしやすいように、関連する項目を集める。"]
[null,null,"具体的な表現で、チェック目的がわかりやすくする。"]
[null,null,"各項目の背景情報を記載する。"]
[]
[null,"３）原因：担当者の能力不足、担当者が過負荷でチェックの質が低下している。"]
[null,"処方：チェック能力向上のための教育をする。"]
[null,null,"担当者の負荷を考えて、アサインをする。"]
[null,"処方：担当者のレベルに合わせてチェックシートを分ける。"]
[null,null,"（初心者向けはフルセットの項目、ベテラン向けは必要最小限の項目、等。）"]
[]
[null,"４）原因：チェックリスト依存症になっている。"]
[null,"処方：チェックリストでチェックする前に自ら考え、その後に抜けなどがないか"]
[null,null,"チェックリストを使うように指導する。"]
[]
[]
[null,"あるべき姿"]
[]
[]
[null,"・正しいチェックリストの使い方がされており、チェックした内容では、問題は発生"]
[null,"　しない。"]
[]
[null,"・チェックリストは、適切な項目数で、わかりやすくその背景情報が明記されている。"]
[]
[null,"・チェックリストによるチェックは適切なタイミングで、適切なスキルと負荷状況"]
[null,"　の担当者によって実施されている。"]

{"sheet":"クレーム軽視症","index":6,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,2],[5,1,6,2],[8,1,8,3],[23,1,24,3],[2,1,3,2]]}
[]
[null,"病名",null,"クレーム軽視症"]
[null,"症状",null,"些細なクレームは面倒くさいので軽視している。"]
[null,null,null,"忘れてくれることを期待している。"]
[]
[null,"放置して\nおくと",null,"・社員の目線は社内にのみ注目するようになる。"]
[null,null,null,"・顧客から信用を失い、しだいに発注は減少していく。"]
[]
[null,"原因と処方"]
[]
[null,"１）原因：クレームを問題としてとらえて改善する仕組みがない。"]
[null,"処方：適切な問題管理の仕組み（ルール／ツール）を構築する。"]
[null,"　　　　クレーム情報は集約して社内で共有することで、類似問題の発生を防止する。"]
[]
[null,"２）原因：今まで誰もフォローしなかったので、今回も問題ないだろうと思っている。"]
[null,"処方：「いつまでに」「だれが」解決する、「いつ」「誰が」フォローするかを決める"]
[null,null,"改善の必要性について関係者で合意するプロセスを作る。"]
[]
[null,"３）原因：改善すべきことが多く、手が回らない。そのうち、その内忘れてしまう。"]
[null,"処方：優先順位付け、定期的な優先順位の見直しを行い改善を行う。"]
[null,null,"担当者の負荷を調整して改善の時間を確保する。"]
[]
[]
[null,"あるべき姿"]
[]
[]
[null,"・クレームを改善の機会ととらえて、同様の問題が発生しないように改善につなげている。"]
[]
[null,"・改善すべき内容かどうかを、関係者で合意し、計画的に改善している。"]
[]
[null,"・誰かが特別なフォローしなくても、改善がされる。"]

{"sheet":"言い訳過多症","index":7,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,5,2],[7,1,7,3],[40,1,41,3]]}
[]
[null,"病名",null,"言い訳過多症"]
[null,"症状",null,"思わしくない結果に対し　「だって」「でも」といった言い訳が多い。"]
[]
[null,"放置して\nおくと",null,"・全てに対してエビデンスが要求される会社になる。"]
[null,null,null,"・上司と部下やチーム内の信頼関係が崩壊する。"]
[]
[null,"原因と処方"]
[]
[null,"１）原因：自分が原因ではないと思っている。"]
[null,"原因：自分の成果物に対して責任を取る気がない。"]
[null,"処方：お金をもらって仕事をしているプロ意識を植え付ける。"]
[]
[null,"原因：ルールや手順に不備があっても修正する余裕がない。"]
[null,"処方：担当者の負荷状況を確認し、適切なリソースのアサインを実施する。"]
[]
[null,"原因：ルールや手順を間違って解釈していた。"]
[null,"処方：担当者に対してルールの目的と手順を再教育する。"]
[]
[null,"２）原因：原因は前任者にあると思っている。"]
[null,"原因：前任者からの引き継ぎが不十分なままで、作業をしている。"]
[null,"処方：「報告」「連絡」「相談」の基本動作を教育する。"]
[]
[null,"原因：前任者からの引き継ぎが不十分なままで、作業をしている。"]
[null,"処方：作業状況を見える化する仕組みを設定する。"]
[]
[null,"３）原因：原因は他部署や前工程にあると思っている。"]
[null,"原因：自身の作業だけをチャントやればよく、仕事はチームや組織で行う"]
[null,"ものという意識が低い。"]
[null,"処方：チームや組織で良い成果を出すことが重要であることを教育する。"]
[]
[null,"原因：他部署や前工程のやり方に問題があると思っているが、管理者が"]
[null,"気づいていない。"]
[null,"処方：管理者が現場の声を聞くプロセスを構築する。"]
[]
[null,"４）原因：いつも担当者が責め立てられるので予防線を張っている。"]
[null,"原因：すぐに、担当者が原因であると結論づけてしまう。"]
[null,"処方：担当者のせいにせず、原因を掘り下げる仕組みやルールを作る。"]
[]
[]
[null,"あるべき姿"]
[]
[]
[null,"・先ず、言い訳を十分に聴き、その中にある問題の本質を探る職場。"]
[]
[null,"・言い訳で終わらせず、反省へ導く、そして、反省から改善提案につなげる。"]
[]
[null,"・自身の範囲だけでなく、他部署や前工程まで含めた、チームや組織で良い"]
[null,"成果を出す職場。"]

{"sheet":"納期意識過剰症","index":8,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,5,2],[7,1,7,3],[27,1,28,3]]}
[]
[null,"病名",null,"納期意識過剰症"]
[null,"症状",null,"不具合が残っていても平気で出荷される。"]
[]
[null,"放置して\nおくと",null,"・良品を出荷するという意識が麻痺してしまう。"]
[null,null,null,"・いずれは市場から淘汰されてしまう。"]
[]
[null,"原因と処方"]
[]
[null,"１）原因：品質を担保するためのルールを守らないことへの問題意識が希薄"]
[null,"処方：不具合がある状態で出荷すると、社会的な大問題となったり、企業の"]
[null,null,"イメージダウンとなることを、身近な事例や世の中の事例で説明し納得"]
[null,null,"してもらう。"]
[]
[null,"２）原因：品質を担保するためのプロセス／仕組みに問題がある"]
[null,"処方： 出荷に際して品質部門が品質を確認したのち出荷するように出荷判定の"]
[null,null,"プロセスを作り、周知し徹底する。"]
[null,"処方： 品質部門は出荷判定の基準を見直して、不具合の流出を防ぐ。"]
[]
[null,"３）原因：品質より、納期やコストが優先される組織風土"]
[null,"処方：現場の組織長や会社のトップと以下について相談する。"]
[null,null,"・抱えているバックログなどをいったん減らすことでルールを遵守　(応急処置）。"]
[null,null,"・作業量が多いことが原因であるなら、人員採用を行う。"]
[null,null,"・プロセスを見直し不要なものは排除することで時間短縮を図る。"]
[null,null,"・人手で時間をとられているものはツール化することで効率化を図る。"]
[]
[]
[null,"あるべき姿"]
[]
[]
[null,"・通常、出荷時点では不具合は無い。"]
[]
[null,"・不具合が残っている場合は、ユーザ影響度を基に出荷に耐えうるか判断がされる。"]
[]
[null,"・残っている不具合に対し、修正計画を立てて実行している。"]

{"sheet":"ルール失調症","index":9,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[4,1,5,2],[7,1,7,3],[32,1,33,3]]}
[]
[null,"病名",null,"ルール失調症"]
[null,"症状",null,"ルール破りが多い、ルールが無視される。"]
[]
[null,"放置して\nおくと",null,"・ルールの意義を忘れ、守らなくてもいいという雰囲気となる。"]
[null,null,null,"・いずれは大事故が発生する。"]
[]
[null,"原因と処方"]
[]
[null,"１）原因：新人に対して、ルールが十分に教育されていない。"]
[null,"（OJTにまかせっきりの場合もある。）"]
[null,"処方：新人教育の内容を見直して、ルール教育を行う。"]
[]
[null,"原因：新人でなくても、新規参入者へのルール説明がなされていない。"]
[null,"処方：作業開始前に説明すべき内容をきちんとまとめ、説明しておく。"]
[]
[null,"原因：ルール周知の仕方が悪く、見落としがされている。"]
[null,"処方：ルール周知は、いろいろな方法を組み合わせて行うとともに、半期単位などで"]
[null,null,"追加・変更した内容の再教育を行う。"]
[]
[null,"２）原因：ルール通りにやると手間がかかる。"]
[null,"処方：そのルールのできた本質を考えて、不要な内容を削除、必要なものは代替手段"]
[null,null,"を検討をして、ルールそのものを見直す。"]
[]
[null,"３）原因：こんなルールは無駄だと思っている。"]
[null,"処方：ルール遵守の必要性、なぜこのルールがあるのか、その理由・背景を含めて"]
[null,null,"説明し、納得・理解させる。"]
[]
[null,"４）原因：ルール破りを放置してきた結果、無視しても良いと思われている。"]
[null,"処方：プロセスQAでプロセス遵守の状況を確認し、ルール破りを放置しない。"]
[]
[]
[null,"あるべき姿"]
[]
[]
[null,"・ルールは全員がその本質を理解しており、ルールが守られている。"]
[]
[null,"・時代とアンマッチなルールや、最適解を得るためにルールを変更する"]
[null,"必要がある時は、本質を考えてルールが変更されている。"]