{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["サプライヤ情報収集シート記入用","記入要領"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":96,"n_cols":62,"rows_kept":96,"cut":false,"hidden":false,"merged":[[7,2,7,4],[8,2,11,2],[8,4,11,4],[8,5,8,10],[8,3,11,3],[7,5,7,16],[9,16,11,16],[9,9,11,9],[9,10,11,10],[9,12,11,12],[8,11,8,16],[9,27,11,27],[8,17,8,26],[9,11,11,11],[9,26,11,26],[9,13,11,13],[9,14,11,14],[9,15,11,15],[9,5,11,5],[10,34,11,34],[9,7,11,7],[9,8,11,8],[9,32,11,32],[9,6,11,6],[9,25,11,25],[9,17,11,17],[9,18,11,18],[10,20,11,20],[9,55,11,55],[7,38,7,48],[10,43,11,43],[10,19,11,19],[10,40,11,40],[9,30,11,30],[9,31,11,31],[9,29,11,29],[8,42,11,42],[8,27,8,37],[8,57,8,58],[9,37,11,37],[8,41,11,41],[8,52,8,54],[8,38,11,38],[9,54,11,54],[9,52,11,52],[8,50,11,50],[9,53,11,53],[8,49,11,49],[8,39,11,39],[8,59,8,60],[7,52,7,61],[8,61,11,61],[9,56,11,56],[9,57,11,57],[9,58,11,58],[9,59,11,59],[9,60,11,60],[8,55,8,56],[8,44,8,47],[8,48,11,48],[9,44,11,44],[10,45,11,45],[10,47,11,47],[8,51,11,51],[9,46,11,46],[64,49,64,51],[10,35,11,35],[9,19,9,24],[10,21,10,24],[7,17,7,37],[10,36,11,36],[9,34,9,36],[9,28,11,28],[9,33,11,33],[7,49,7,51],[65,38,68,38],[65,39,68,39],[48,17,48,21],[64,2,64,4],[64,5,64,16],[64,17,64,37],[64,38,64,48],[65,48,68,48],[66,5,68,5],[66,6,68,6],[65,49,68,49],[65,50,68,50],[64,52,64,61],[65,2,68,2],[65,3,68,3],[65,4,68,4],[65,5,65,10],[65,11,65,16],[65,17,65,26],[65,51,68,51],[65,52,65,54],[65,55,65,56],[65,57,65,58],[65,59,65,60],[65,61,68,61],[66,54,68,54],[66,55,68,55],[66,56,68,56],[66,57,68,57],[66,26,68,26],[66,7,68,7],[66,8,68,8],[66,9,68,9],[66,10,68,10],[66,11,68,11],[66,12,68,12],[66,31,68,31],[66,13,68,13],[66,14,68,14],[66,15,68,15],[66,16,68,16],[66,33,68,33],[66,17,68,17],[66,18,68,18],[66,19,66,24],[66,25,68,25],[66,44,68,44],[66,27,68,27],[66,52,68,52],[66,53,68,53],[67,43,68,43],[67,45,68,45],[67,47,68,47],[66,28,68,28],[66,29,68,29],[66,30,68,30],[65,41,68,41],[65,42,68,42],[65,44,65,47],[65,27,65,37],[82,2,82,61],[66,32,68,32],[67,36,68,36],[67,40,68,40],[66,34,66,36],[66,37,68,37],[91,2,91,23],[66,58,68,58],[66,59,68,59],[66,60,68,60],[67,19,68,19],[67,20,68,20],[67,21,67,24],[67,34,68,34],[67,35,68,35],[66,46,68,46]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日：XX年YY月ZZ日",null,null,null,null,null,null,"2013.12.10"]
[null,"記入項目"]
[null,"初報",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"○","○","○","○","○","○","○","○",null,null,"○","○","○",null,null,"○","○"]
[null,"2報",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,"3報以降",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,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,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,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,"当社納入状況",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,null,"一次仕入先様\n欠品日","月当たり\n所要量",null,"在庫日数\n（2次以降仕入先様分も含めた合計）","在庫量 計\n（2次以降仕入先様分も含めた合計）",null,"在庫の内訳（左記の内訳）",null,null,null,"備考","当社\n在庫日数","当社\n製品\n最短欠品日","当社\n製品\n納入再開日","対策",null,null,"設変",null,"工程変更",null,"顧客認証",null,"評価要否"]
[null,null,null,null,null,"顧客名\n(カーメーカー等)","車両名等","重点車種等\nへの該当","顧客\n製品名","品番点数","顧客\n生産拠点","会社名","Assy\n製品名","事業部","営業\n担当者名","調達\n担当部署","調達担当者","会社名","所在地","被害状況",null,null,null,null,null,"被災部材の\n型式/材料グレード等","復旧見込み\n時期","仕入先名","仕入先コード","メーカー名\n(一次仕入先様が商社の場合)","被災会社との取引関係\n（直取/他社経由）","被災部材の\n自支給層別","当社への\n供給影響有無","影響のある\n部材名\n（当社への\n納入製品名）","当社品番、型式",null,null,"納入先製造部\n（納入のある製造部を全て記入）",null,null,null,null,null,null,"一次仕入先様の\n在庫量",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,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,"人的被害","建物設備被害","ｲﾝﾌﾗ\n（電気ｶﾞｽ水道）","工場周辺地域"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"JAPIA標準C表　記入要領",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日：2014.12.1"]
[null,"1.有事の際の報告内容(概略)と日程"]
[null,"n日・・・リスク発生日"]
[null,null,"納期",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"報告内容"]
[null,"※ 初報","n（+1）日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被災の概要、当社への納入影響有無"]
[null,"　（当社への納入影響ない場合は「初報」のみで終了です。）"]
[null,"　当社への納入影響あり　⇒　品番別管理のため「2報」をお願いします。 　⇒「リスク調査表(C表)_記入用」の「2報開く」ボタンをプッシュするとインプット項目が現れます"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　　　　(予め、エクセルの「マクロ」実施の設定をお願いします)"]
[null,"※ 2報","n+2日",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,"　（在庫があり枯渇以前に復旧が見込まれるものは、状況をウオッチしていただき、変化があった場合以外は、報告は不要です。）"]
[null,"　復旧見込み日以前に枯渇するもの　⇒　納入継続には対策が必要のため「3報」で対策について検討をお願いします。　⇒「リスク調査表(C表)_記入用」の「3報開く」ボタンをプッシュするとインプット項目が現れます"]
[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,"※ 3報","1週間以内",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,"2.記入項目と記入ルール"]
[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,null,null,null,null,null,null,null,"　　※：可能な範囲で記入"]
[null,"(1)仕入先様の記入項目"]
[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,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,null,null,null,null,"当社の一次仕入先様情報",null,null,null,null,null,null,null,null,null,null,"一次仕入先様\n欠品日","月当たり\n所要量",null,"在庫日数\n（2次以降仕入先様分も含めた合計）","在庫量 計\n（2次以降仕入先様分も含めた合計）",null,"在庫の内訳（左記の内訳）",null,null,null,"備考","当社\n在庫日数","当社\n製品\n最短欠品日","当社\n製品\n納入再開日","対策",null,null,"設変",null,"工程変更",null,"顧客認証",null,"評価要否"]
[null,null,null,null,null,"顧客名\n(カーメーカー等)","車両名等","重点車種等\nへの該当","顧客\n製品名","品番点数","顧客\n生産拠点","会社名","Assy\n製品名","事業部","営業\n担当者名","調達\n担当部署","調達担当者","会社名","所在地","被害状況",null,null,null,null,null,"被災部材の\n型式/材料グレード等","復旧見込み\n時期","仕入先名","仕入先コード","メーカー名\n(一次仕入先様が商社の場合)","被災会社との取引関係\n（直取/他社経由）","被災部材の\n自支給層別","当社への供給影響有無","影響のある\n部材名\n（当社への\n納入製品名）","当社品番、材質コード、型式",null,null,"納入先製造部\n（納入のある製造部を全て記入）",null,null,null,null,null,null,"一次仕入先様の\n在庫量",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,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,"記入例","2014-11-28","④欠品リスク有り",1,"△△△自動車","××××","○(該当)",null,null,null,"△△△","××××Assy","熱",null,"調達△部",null,"△△△化学","△△県△△市","火災により第一工場が北半分が焼失","否","③被害なし","④被害なし","②被害なし","③被害無し","××××","2015-01-15","ABC工業","B000",null,"直取","自達","供給影響あり","△△△△","AAAAAAAAAA","BBBBBB","CCCC","△△製造1部\n△△製造3部","2014-12-22",50000,"個",15,37500,"個",35000,"個",12500,"個","10日分：一次仕入先様\n5日分：二次仕入先様以降",3,"2014-12-25","2014-12-25","③他社にて代替","2014-12-22","①代替案立案：12月8日\n②代替案評価完：12月15日（サンプル材入荷～評価完了）\n③生産準備完了：12月22日（初品納入が可能日）","要",null,"要",null,"要",null,"要"]
[]
[null,"(2)項目別報告スケジュール　　（○：報告していただきたい項目）"]
[null,"初報　※","n(＋1)日",null,null,"○",null,null,null,null,null,"○","○",null,"○","○","○","○","○","○","○","○","○","○","○",null,null,"○","○","○",null,null,"○","○"]
[null,"2報　※","n＋2日",null,null,null,"○","○","○","○","○",null,null,"○",null,null,null,null,null,null,null,null,null,null,null,"○","○",null,null,null,"○","○",null,null,"○","○","○","○","○","○","○","※","※","※","○","○","※","※","※"]
[null,"3報　※","1週間以内",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,null,null,null,null,null,null,"○","○","○",null,null,"○","○","○","○","○","○","○","○","○","○","○","○","○","○","○","○"]
[]
[null,"(3)C表記入のルール"]
[null,"記入の納期","記入都度","1週間","n+1日","n+1日","n+2日","n+2日","n+2日","n+2日","n+2日","n+1日","n+1日","n+2日","n+1日","n+1日","n+1日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n+2日","n+2日","n（+1）日","n（+1）日","n（+1）日","n+2日","n+2日","n（+1）日","n（+1）日","n+2日","n+2日","n+2日","n+2日","n+2日","n+2日","n+2日","1週間","1週間","1週間","n+2日","n+2日","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間"]
[null,"記入担当者","一次仕入先様","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","当社","当社","当社","一次仕入先様","一次仕入先様","一次仕入先様","当社","当社","当社","当社","当社","当社","当社"]
[null,"一次仕入先様への\n展開項目","●",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●",null,null,null,"●","●","●"]
[null,"記入内容の\n主旨補足\n(一次仕入先様向け)","データの更新日はいつですか?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被災会社の社名を教えて下さい","被災会社の所在地を教えて下さい","被災の具体的な内容について補足をお願いします","被災会社（当該工場）での生産可否を回答して下さい（選択肢より選択）","被災会社（当該工場）の人的被害レベルを選択して下さい\n（選択肢より選択）","被災会社（当該工場）の建物設備の被害レベルを選択して下さい（選択肢より選択）","被災会社（当該工場）のインフラの被害レベルを選択して下さい（選択肢より選択）","被災会社（当該工場）周辺の状況を選択して下さい（選択肢より選択）\n","電子部品、材料の場合はご記入ください。\nそれ以外の部品は記入不要です。","被災会社の復旧見込み時期を教えて下さい","当社に部材を納入する一次仕入先様の会社名を教えて下さい。","当社に部材を納入する一次仕入先様の仕入先コードを記入下さい","一次仕入先様が商社の場合、メーカー名を記入。\n一次仕入先様がメーカの場合、記入不要","一次仕入先様から見た、被災会社のサプライチェーン上の関係を教えてください\n（直取/他社経由）を選択してください\n\n（選択肢より選択）","被災部材の自支給層別を教えて下さい\n(材料でない場合は記入不要)\n\n","被災会社の影響が当社へ及ぶかどうかについて、選択して下さい。","影響を受ける部材名(図面に記載の部材名、あるいは通称)を記入下さい\n\n影響が無い場合は「無し」と記入してください。","影響を受ける部材の●●品番を記入下さい。\n\n1つのセルに記入するのは1品番としてください。","影響を受ける部材の材質コードを記入下さい。\n\n1つのセルに記入するのは1コードとしてください。","電子部品、材料の場合は型式を記入ください","当社納入製造部を全て記入ください。\n\n納入製造部が複数ある場合は、改行して記入ください。","リスク会社の生産が継続されない場合、一次仕入先様から当社への納入がいつ止まりますか","リスク部材の月産流動数(直近または今後の平均値)を教えて下さい","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫日数を教えて下さい（稼働日ベース）","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","在庫の状態（製品、材料etc.）、二次仕入先様以下の在庫の内訳　等",null,null,null,"リスク部品の代替の方向性を教えて下さい\n\n（選択肢より選択）","再開または代替可能となる日時をインプットして下さい","「対策の方向性」で「その他検討中」を選択した場合、必ず具体的な内容をインプットしてください\n「他社にて代替」の場合は、代替先をインプットして下さい\n「他工場にて代替」の場合は、代替工場名をインプットして下さい\n\n【重要】\n対策を進める上での節目イベントとその日程(デッドライン)を明確にしてください。\n(目的：●●調達部において、対策節目日程管理)\n\n例)代替検討を進める場合\n　　①代替案立案：●月●日\n　　②代替案評価完：●月●日",null,null,null,null,"顧客に確認の上記入","顧客に確認の上記入"]
[null,"記入方法","手入力","選択","手入力","手入力","手入力","選択","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","選択","選択","選択","選択","選択","手入力","手入力","手入力","手入力","手入力","選択","手入力","選択","手入力","手入力","手入力","手入力","手入力","手入力","手入力","選択","手入力","手入力","選択","手入力","選択","手入力","選択","手入力","手入力","手入力","手入力","選択","手入力","手入力","選択","手入力","選択","手入力","選択","手入力","選択"]
[null,"記入ルール\n(共通)","①カタカナ：全角にて記入\n②英文字：半角にて記入\n③更新箇所は赤字でマーキングする\n④品番情報は一つのセルに1品番のみ記入する(改行して複数インプットはNG)"]
[null,"記入ルール\n(項目別)","20●●年\n　/●●月\n　　/●●日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"㈱は不要","●●県●●市",null,null,null,null,null,null,null,"20●●年\n　/●●月\n　　/●●日","㈱は不要",null,"㈱は不要",null,null,null,null,"・10桁品番\n・ハイフンは不要",null,null,null,"20●●年\n　/●●月\n　　/●●日","・数字のみ",null,"・日数でインプットする\n(月数ではない)","・数字のみ",null,"・数字のみ",null,"・数字のみ",null,null,null,"20●●年\n　/●●月\n　　/●●日","20●●年\n　/●●月\n　　/●●日",null,"20●●年\n　/●●月\n　　/●●日"]
[]
[]
[null,"(4)注意事項"]
[null,"C表を記入いただく目的は、リスク部品の生産継続可否を見極めることです。"]
[null,"つきましては、C表をご提出いただく前に、以下ポイントについて事前確認をお願いします。"]
[null,"1.リスク部品に関し、「一次仕入先様欠品日（AM列）」より先に「再開または代替可能日(BB列）」が来ているかどうか？"]
[null,"2.BC欄には対策のパターンに応じて、以下の観点で記入をお願いします。"]
[null,"パターン","BC欄に記入いただきたい内容"]
[null,"復旧待ち","①代替検討開始着手が必要なデッドライン　●●月●●日"]
[]
[null,"他工場で代替","①代替検討の節目日程　→　代替案立案：●●月●●日、代替案評価開始：●●月●●日、代替案評価完了：●●月●●日"]
[null,"他社で代替"]

{"sheet":"記入要領","index":1,"n_rows":52,"n_cols":62,"rows_kept":52,"cut":false,"hidden":false,"merged":[[20,5,20,16],[22,31,24,31],[4,17,4,21],[22,29,24,29],[22,11,24,11],[22,26,24,26],[22,13,24,13],[22,16,24,16],[22,9,24,9],[22,10,24,10],[47,2,47,23],[22,27,24,27],[20,2,20,4],[21,2,24,2],[21,4,24,4],[21,5,21,10],[21,3,24,3],[22,6,24,6],[22,7,24,7],[22,8,24,8],[21,11,21,16],[22,18,24,18],[22,14,24,14],[22,15,24,15],[21,17,21,26],[23,20,24,20],[22,12,24,12],[38,2,38,61],[22,28,24,28],[22,33,24,33],[22,5,24,5],[23,34,24,34],[23,36,24,36],[22,34,22,36],[22,55,24,55],[23,40,24,40],[22,30,24,30],[21,41,24,41],[20,38,20,48],[23,43,24,43],[22,17,24,17],[23,19,24,19],[22,32,24,32],[22,25,24,25],[21,27,21,37],[21,39,24,39],[22,37,24,37],[21,52,21,54],[21,38,24,38],[22,54,24,54],[22,52,24,52],[21,50,24,50],[22,53,24,53],[21,49,24,49],[21,51,24,51],[22,46,24,46],[21,42,24,42],[21,55,21,56],[21,57,21,58],[21,59,21,60],[20,52,20,61],[21,61,24,61],[22,56,24,56],[22,57,24,57],[22,58,24,58],[22,59,24,59],[22,60,24,60],[23,35,24,35],[22,19,22,24],[23,21,23,24],[20,49,20,51],[21,44,21,47],[21,48,24,48],[22,44,24,44],[23,45,24,45],[23,47,24,47],[20,17,20,37]]}
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"更新日：2014.12.1"]
[null,"1.有事の際の報告内容(概略)と日程"]
[null,"n日・・・リスク発生日"]
[null,null,"納期",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"報告内容"]
[null,"※ 初報","n（+1）日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被災の概要、当社への納入影響有無"]
[null,"　（当社への納入影響ない場合は「初報」のみで終了です。）"]
[null,"　当社への納入影響あり　⇒　品番別管理のため「2報」をお願いします。 　⇒「サプライヤ情報収集シート_記入用」の「2報開く」ボタンをプッシュするとインプット項目が現れます"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　　　　(予め、エクセルの「マクロ」実施の設定をお願いします)"]
[null,"※ 2報","n+2日",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,"　（在庫があり枯渇以前に復旧が見込まれるものは、状況をウオッチしていただき、変化があった場合以外は、報告は不要です。）"]
[null,"　復旧見込み日以前に枯渇するもの　⇒　納入継続には対策が必要のため「3報」で対策について検討をお願いします。　⇒「サプライヤ情報収集シート_記入用」の「3報開く」ボタンをプッシュするとインプット項目が現れます"]
[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,"※ 3報以降","随時更新",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,"2.記入項目と記入ルール"]
[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,null,null,null,null,null,null,null,"　　※：可能な範囲で記入"]
[null,"(1)仕入先様の記入項目"]
[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,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,null,null,null,null,"当社の一次仕入先様情報",null,null,null,null,null,null,null,null,null,null,"一次仕入先様\n欠品日","月当たり\n所要量",null,"在庫日数\n（2次以降仕入先様分も含めた合計）","在庫量 計\n（2次以降仕入先様分も含めた合計）",null,"在庫の内訳（左記の内訳）",null,null,null,"備考","当社\n在庫日数","当社\n製品\n最短欠品日","当社\n製品\n納入再開日","対策",null,null,"設変",null,"工程変更",null,"顧客認証",null,"評価要否"]
[null,null,null,null,null,"顧客名\n(カーメーカー等)","車両名等","重点車種等\nへの該当","顧客\n製品名","品番点数","顧客\n生産拠点","会社名","Assy\n製品名","事業部","営業\n担当者名","調達\n担当部署","調達担当者","会社名","所在地","被害状況",null,null,null,null,null,"被災部材の\n型式/材料グレード等","復旧見込み\n時期","仕入先名","仕入先コード","メーカー名\n(一次仕入先様が商社の場合)","被災会社との取引関係\n（直取/他社経由）","被災部材の\n自支給層別","当社への供給影響有無","影響のある\n部材名\n（当社への\n納入製品名）","当社品番、材質コード、型式",null,null,"納入先製造部\n（納入のある製造部を全て記入）",null,null,null,null,null,null,"一次仕入先様の\n在庫量",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,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,"記入例","2014-11-28","④欠品リスク有り",1,"△△△自動車","××××","○(該当)",null,null,null,"△△△","××××Assy","熱",null,"調達△部",null,"△△△化学","△△県△△市","火災により第一工場が北半分が焼失","否","③被害なし","④被害なし","②被害なし","③被害無し","××××","2015-01-15","ABC工業","B000",null,"直取","自達","供給影響あり","△△△△","AAAAAAAAAA","BBBBBB","CCCC","△△製造1部\n△△製造3部","2014-12-22",50000,"個",15,37500,"個",35000,"個",12500,"個","10日分：一次仕入先様\n5日分：二次仕入先様以降",3,"2014-12-25","2014-12-25","③他社にて代替","2014-12-22","①代替案立案：12月8日\n②代替案評価完：12月15日（サンプル材入荷～評価完了）\n③生産準備完了：12月22日（初品納入が可能日）","要",null,"要",null,"要",null,"要"]
[]
[null,"(2)項目別報告スケジュール　　（○：報告していただきたい項目）"]
[null,"初報　※","n(＋1)日",null,null,"○",null,null,null,null,null,"○","○",null,"○","○","○","○","○","○","○","○","○","○","○",null,null,"○","○","○",null,null,"○","○"]
[null,"2報　※","n＋2日",null,null,null,"○","○","○","○","○",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,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,"(3)サプライヤ情報収集シート記入のルール"]
[null,"記入の納期","記入都度","1週間","n+1日","n+1日","n+2日","n+2日","n+2日","n+2日","n+2日","n+1日","n+1日","n+2日","n+1日","n+1日","n+1日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n（+1）日","n+2日","n+2日","n（+1）日","n（+1）日","n（+1）日","n+2日","n+2日","n（+1）日","n（+1）日","n+2日","n+2日","n+2日","n+2日","n+2日","n+2日","n+2日","1週間","1週間","1週間","n+2日","n+2日","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間","1週間"]
[null,"記入担当者","一次仕入先様","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","当社","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","一次仕入先様","当社","当社","当社","一次仕入先様","一次仕入先様","一次仕入先様","当社","当社","当社","当社","当社","当社","当社"]
[null,"一次仕入先様への\n展開項目","●",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●","●",null,null,null,"●","●","●"]
[null,"記入内容の\n主旨補足\n(一次仕入先様向け)","データの更新日はいつですか?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"被災会社の社名を教えて下さい","被災会社の所在地を教えて下さい","被災の具体的な内容について補足をお願いします","被災会社（当該工場）での生産可否を回答して下さい（選択肢より選択）","被災会社（当該工場）の人的被害レベルを選択して下さい\n（選択肢より選択）","被災会社（当該工場）の建物設備の被害レベルを選択して下さい（選択肢より選択）","被災会社（当該工場）のインフラの被害レベルを選択して下さい（選択肢より選択）","被災会社（当該工場）周辺の状況を選択して下さい（選択肢より選択）\n","電子部品、材料の場合はご記入ください。\nそれ以外の部品は記入不要です。","被災会社の復旧見込み時期を教えて下さい","当社に部材を納入する一次仕入先様の会社名を教えて下さい。","当社に部材を納入する一次仕入先様の仕入先コードを記入下さい","一次仕入先様が商社の場合、メーカー名を記入。\n一次仕入先様がメーカの場合、記入不要","一次仕入先様から見た、被災会社のサプライチェーン上の関係を教えてください\n（直取/他社経由）を選択してください\n\n（選択肢より選択）","被災部材の自支給層別を教えて下さい\n(材料でない場合は記入不要)\n\n","被災会社の影響が当社へ及ぶかどうかについて、選択して下さい。","影響を受ける部材名(図面に記載の部材名、あるいは通称)を記入下さい\n\n影響が無い場合は「無し」と記入してください。","影響を受ける部材の●●品番を記入下さい。\n\n1つのセルに記入するのは1品番としてください。","影響を受ける部材の材質コードを記入下さい。\n\n1つのセルに記入するのは1コードとしてください。","電子部品、材料の場合は型式を記入ください","当社納入製造部を全て記入ください。\n\n納入製造部が複数ある場合は、改行して記入ください。","リスク会社の生産が継続されない場合、一次仕入先様から当社への納入がいつ止まりますか","リスク部材の月産流動数(直近または今後の平均値)を教えて下さい","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫日数を教えて下さい（稼働日ベース）","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","「最新更新日」を起点とした在庫量を教えて下さい\n（部品の場合は、個数に置き換えて記入）","選択肢より選択。「他」を選択した場合は、AU欄に単位を記入下さい。","在庫の状態（製品、材料etc.）、二次仕入先様以下の在庫の内訳　等",null,null,null,"リスク部品の代替の方向性を教えて下さい\n\n（選択肢より選択）","再開または代替可能となる日時をインプットして下さい","「対策の方向性」で「その他検討中」を選択した場合、必ず具体的な内容をインプットしてください\n「他社にて代替」の場合は、代替先をインプットして下さい\n「他工場にて代替」の場合は、代替工場名をインプットして下さい\n\n【重要】\n対策を進める上での節目イベントとその日程(デッドライン)を明確にしてください。\n(目的：●●調達部において、対策節目日程管理)\n\n例)代替検討を進める場合\n　　①代替案立案：●月●日\n　　②代替案評価完：●月●日",null,null,null,null,"顧客に確認の上記入","顧客に確認の上記入"]
[null,"記入方法","手入力","選択","手入力","手入力","手入力","選択","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","手入力","選択","選択","選択","選択","選択","手入力","手入力","手入力","手入力","手入力","選択","手入力","選択","手入力","手入力","手入力","手入力","手入力","手入力","手入力","選択","手入力","手入力","選択","手入力","選択","手入力","選択","手入力","手入力","手入力","手入力","選択","手入力","手入力","選択","手入力","選択","手入力","選択","手入力","選択"]
[null,"記入ルール\n(共通)","①カタカナ：全角にて記入\n②英文字：半角にて記入\n③更新箇所は赤字でマーキングする\n④品番情報は一つのセルに1品番のみ記入する(改行して複数インプットはNG)"]
[null,"記入ルール\n(項目別)","20●●年\n　/●●月\n　　/●●日",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"㈱は不要","●●県●●市",null,null,null,null,null,null,null,"20●●年\n　/●●月\n　　/●●日","㈱は不要",null,"㈱は不要",null,null,null,null,"・10桁品番\n・ハイフンは不要",null,null,null,"20●●年\n　/●●月\n　　/●●日","・数字のみ",null,"・日数でインプットする\n(月数ではない)","・数字のみ",null,"・数字のみ",null,"・数字のみ",null,null,null,"20●●年\n　/●●月\n　　/●●日","20●●年\n　/●●月\n　　/●●日",null,"20●●年\n　/●●月\n　　/●●日"]
[]
[]
[null,"(4)注意事項"]
[null,"サプライヤ情報収集シートを記入いただく目的は、リスク部品の生産継続可否を見極めることです。"]
[null,"つきましては、サプライヤ情報収集シートをご提出いただく前に、以下ポイントについて事前確認をお願いします。"]
[null,"1.リスク部品に関し、「一次仕入先様欠品日（AM列）」より先に「再開または代替可能日(BB列）」が来ているかどうか？"]
[null,"2.BC欄には対策のパターンに応じて、以下の観点で記入をお願いします。"]
[null,"パターン","BC欄に記入いただきたい内容"]
[null,"復旧待ち","①代替検討開始着手が必要なデッドライン　●●月●●日"]
[]
[null,"他工場で代替","①代替検討の節目日程　→　代替案立案：●●月●●日、代替案評価開始：●●月●●日、代替案評価完了：●●月●●日"]
[null,"他社で代替"]