{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["問題データとグラフ"],"not_rendered":{"charts":1,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"問題データとグラフ","index":0,"n_rows":17,"n_cols":5,"rows_kept":17}
[null,"問題分析 - パレート図"]
[null,"このセルには、すべての問題領域の発生回数の累積割合についてのパレート図があります。"]
[]
[null,"問題データ"]
[]
[null,"問題領域","発生回数","全体に占める割合","累積率"]
[null,"トランスミッション",35,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.23178807947019867,"d":"23.18%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.23178807947019867,"d":"23.18%"}}]
[null,"燃料システム",25,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.16556291390728478,"d":"16.56%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.3973509933774834,"d":"39.74%"}}]
[null,"その他",21,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.1390728476821192,"d":"13.91%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.5364238410596026,"d":"53.64%"}}]
[null,"騒音",18,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.11920529801324503,"d":"11.92%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.6556291390728477,"d":"65.56%"}}]
[null,"ドライバー制御",13,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.08609271523178808,"d":"8.61%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.7417218543046358,"d":"74.17%"}}]
[null,"その他の電気系統",12,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.07947019867549669,"d":"7.95%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.8211920529801324,"d":"82.12%"}}]
[null,"点火装置",10,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.06622516556291391,"d":"6.62%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.8874172185430463,"d":"88.74%"}}]
[null,"冷却システム",7,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.046357615894039736,"d":"4.64%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.9337748344370861,"d":"93.38%"}}]
[null,"ブレーキ",5,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.033112582781456956,"d":"3.31%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.9668874172185431,"d":"96.69%"}}]
[null,"排ガス",3,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.019867549668874173,"d":"1.99%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":0.9867549668874173,"d":"98.68%"}}]
[null,"ステアリング",2,{"$f":"IFERROR(データ[[#This Row],[発生回数]]/SUM(データ[発生回数]), \"\")","v":{"v":0.013245033112582781,"d":"1.32%"}},{"$f":"IFERROR(SUM(INDEX(データ[発生回数],1):データ[[#This Row],[発生回数]])/SUM(データ[発生回数]), \"\")","v":{"v":1,"d":"100.00%"}}]