{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["import codes","FY specification & file import","FB","Linedata","company comment","year-on-year comparison","database","B_question_result","answer list","database for FB (hidden)"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"import codes","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["company code"]

{"sheet":"FY specification & file import","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Fiscal year in the YY format.",null,null,null,null,null,"For importing text files in the \"Storage\" folder, and adding following sheet."]
[20,null,"year",null,null,null," - [YY]_database"]
[null,null,null,null,null,null," - [YY]_B question result"]
[null,null,null,null,null,null," - [YY]_answer list"]
[null,null,null,null,null,null,"For updating \"FB\" sheet."]
[]
[]
[]
[]
[null,null,null,null,null,null,"For swapping contents in \"FB\" sheet to [YY] year."]

{"sheet":"FB","index":2,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,0,1,7],[19,14,19,15],[3,3,3,11],[7,13,7,15],[8,13,8,15],[9,13,9,15],[10,13,10,15],[11,13,11,15],[17,13,17,15],[18,13,18,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[15,13,15,15],[16,13,16,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/2"]
["The summary of your Self-examination Sheet \nfor the Guidelines for Managing Chemicals in Products"]
[]
[null,"company code",null,{"$f":"VLOOKUP(C4,'database for FB (hidden)'!A:B,2,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
["Your answers about Preparatory questions",null,null,null,null,null,null,null,null,null,null,null,"Answer","Example"]
[null,"C1. Do you deliver parts or materials for currently mass-produced products?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),3,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M8,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),16,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C2. Do you deliver parts or materials to support old models (after discontinuation)?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),4,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M9,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),17,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C3. Do you deliver prototype parts?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),5,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M10,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),18,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C4. Do you deliver plant facilities or secondary plant materials?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),6,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M11,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),19,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C5. Do you design and develop parts and materials?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),7,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M12,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),20,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C6. Do you deliver parts and materials as a trading company or distributor without actually manufacturing them?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),8,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M13,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),21,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C7. Do your manufacturing processes include conversion processes listed in Table 4.2 in the Guidelines?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),9,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M14,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),22,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C8. Do your domestic and overseas subsidiaries and subcontractors perform production activities?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),10,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M15,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),23,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C9. Do you use industry-standard communication tools for chemicals in your products?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),11,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M16,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),24,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C10. Do you apply the latest versions of management criteria for the tools you use mentioned in question C9?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),12,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M17,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),25,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C11. Do you use the latest version of customer management criteria?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),13,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M18,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),26,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C12. Do you refer to the latest version of the customer-specified IMDS manual?",null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),14,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(M19,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),27,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[null,"C13　資本金3億円以下、または従業員数が300人以下である",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),15,FALSE)","v":{"$error":"#REF!"}},{"$f":"IF(N20,VLOOKUP(C4,INDIRECT(D27&\"!A:AB\"),28,FALSE)&\"\",\"\")","v":{"$error":"#REF!"}}]
[]
["1) Total score"]
[]
[]
[]
[]
[null,null,null,{"$f":"'FY specification & file import'!B4 & \"_B_question_result\"","v":"_B_question_result"},null,null,null,{"$f":"'FY specification & file import'!B4-2 & \"_result\"","v":"-2_result"}]
[null,null,null,null,null,null,"X","Y"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4-2 & \"_database\"&\"!A:E\"),3,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4-2 & \"_database\"&\"!A:E\"),5,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'FY specification & file import'!B4-1 & \"_result\"","v":"-1_result"}]
[null,null,null,null,null,null,"X","Y"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4-1 & \"_database\"&\"!A:E\"),3,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4-1 & \"_database\"&\"!A:E\"),5,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'FY specification & file import'!B4 & \"_result\"","v":"_result"}]
[null,null,null,null,null,null,"X","Y"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:E\"),3,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(C4,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:E\"),5,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
["2) The radar chart for process and operation score"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"State of the organization and management system","Basic policy and management framework","Management of chemicals in products","Operation of management of chemicals in products","Management of information and data on chemicals and operation of conformity check operations","Management of human resources as well as documents and information"]
[null,{"$f":"C4","v":0},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),6,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),7,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),8,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),9,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),10,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT(H37&\"!A:W\"),11,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3) The radar chart for process score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2/2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check operations","6_Management of human resources as well as documents and information"]
[null,{"$f":"C4","v":0},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),7,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),8,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),9,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),10,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),11,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),12,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4) The radar chart for operation score"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check operations","6_Management of human resources as well as documents and information"]
[null,{"$f":"C4","v":0},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),19,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),20,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),21,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),23,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B53,INDIRECT('FY specification & file import'!B4 & \"_database\"&\"!A:X\"),24,FALSE)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
["5) comment"]
[]
[null,{"$f":"VLOOKUP('company comment'!G3,'company comment'!G6:I14,2,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"VLOOKUP('company comment'!G3,'company comment'!G6:I14,3,FALSE)","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"'company comment'!B21","v":""}]
[null,{"$f":"'company comment'!B26","v":""}]
[]
[null,{"$f":"'year-on-year comparison'!C6","v":""}]
[null,{"$f":"'year-on-year comparison'!C7","v":""}]
[]
[]
[]
[]
[null,"We maybe ask to plan for improvement, when needed."]
[null,"Your cooperation will be highly appreciated with us."]

{"sheet":"Linedata","index":3,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,null,"Score"]
[null,"1/3 of X",60,{"$f":"C2","v":60}]
[null,"2/3 of X",90,{"$f":"C3","v":90}]
[null,"1/3 of Y",60,60]
[null,"2/3 of Y",80,80]

{"sheet":"company comment","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
[null,"company code","X","Y"]
[null,{"$f":"FB!C4","v":0},{"$f":"FB!G39","v":{"$error":"#REF!"}},{"$f":"FB!H39","v":{"$error":"#REF!"}},{"$f":"IF(C3>Linedata!C3,1,IF(C3>Linedata!C2,2,3))","v":{"$error":"#REF!"}},{"$f":"IF(D3>Linedata!C5,\"a\",IF(D3>Linedata!C4,\"b\",\"c\"))","v":{"$error":"#REF!"}},{"$f":"E3&F3","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,"1st line","2nd line"]
[null,null,null,null,null,null,"1a","Good score for both process and operation.","Your company is one of the best practice company and expected to lead your suppliers."]
[null,null,null,null,null,null,"1b","Good score for process and acceptable score for operation.","Your company is expected to lead your suppliers about process, and expected to keep on improving about operation."]
[null,null,null,null,null,null,"1c","Good score for process and there is still room for improvement about operation.","Your company is expected to lead your suppliers about process, and required to plan for improvement about operation."]
[null,null,null,null,null,null,"2a","Acceptable score for process and good score for operation.","Your company is expected to keep on improving about process, and expected to lead your suppliers about operation."]
[null,null,null,null,null,null,"2b","Acceptable score for both process and operation.","Your company is expected to keep on improving about both process and operation."]
[null,{"$f":"'FY specification & file import'!B4 & \"_database\"","v":"_database"},null,null,null,null,"2c","Acceptable score for process and there is still room for improvement about operation.","Your company is expected to keep on improving about process, and required to plan for improvement about operation."]
[{"$f":"'FY specification & file import'!B4-2 & \"FY\"","v":"-2FY"},{"$f":"'FY specification & file import'!B4-2 & \"_database\"","v":"-2_database"},null,null,null,null,"3a","There is still room for improvement about process and good score for operation.","Your company is required to plan for improvement about process, and expected to lead your suppliers about operation."]
[null,null,null,null,null,null,"3b","There is still room for improvement about process and acceptable score for operation.","Your company is required to plan for improvement about process, and expected to keep on improving about operation."]
[null,null,null,null,null,null,"3c","There is still room for improvement about both process and operation.","Your company is required to plan for improvement about both process and operation."]
[]
[]
["Score for Process","1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check operations","6_Management of human resources as well as documents and information"]
[null,{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A:W\"),6,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),7,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),8,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),9,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),10,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),11,FALSE)","v":{"$error":"#REF!"}}]
[{"$f":"IF(B19&C19&D19&E19&F19&G19&B20&C20&D20&E20&F20&G20=\"\",\"\",\"Process Level \")","v":{"$error":"#REF!"}},{"$f":"IF(B18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),6,FALSE)>1.2,\"1*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(C18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),7,FALSE)>1.2,\"2*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),8,FALSE)>1.2,\"3*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(E18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),9,FALSE)>1.2,\"4*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),10,FALSE)>1.2,\"5*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(G18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),11,FALSE)>1.2,\"6*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(B19&C19&D19&E19&F19&G19=\"\",\"\",\"are good.\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(B18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),6,FALSE)<0.8,\"1*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(C18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),7,FALSE)<0.8,\"2*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),8,FALSE)<0.8,\"3*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(E18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),9,FALSE)<0.8,\"4*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),10,FALSE)<0.8,\"5*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(G18/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),11,FALSE)<0.8,\"6*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(B20&C20&D20&E20&F20&G20=\"\",\"\",\"Improvements are needed.\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IFERROR(A19&B19&C19&D19&E19&F19&G19&H19&B20&C20&D20&E20&F20&G20&H20&IF(A19=\"\",\"\",\" Compared to the average of \"&A12),\"\")","v":""}]
["Score for Operation","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check operations","6_Management of human resources as well as documents and information"]
[null,{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),20,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),21,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(B3,INDIRECT(B11&\"!A3:W300\"),23,FALSE)","v":{"$error":"#REF!"}}]
[{"$f":"IF(B24&C24&D24&E24&B25&C25&D25&E25=\"\",\"\",\"Operation Level \")","v":{"$error":"#REF!"}},{"$f":"IF(B23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),20,FALSE)>1.2,\"3*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(C23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),21,FALSE)>1.2,\"4*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),22,FALSE)>1.2,\"5*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(E23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),23,FALSE)>1.2,\"6*\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(B24&C24&D24&E24=\"\",\"\",\"are good.\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(B23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),20,FALSE)<0.8,\"3*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(C23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),21,FALSE)<0.8,\"4*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(D23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),22,FALSE)<0.8,\"5*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(E23/VLOOKUP(B3,INDIRECT(B12&\"!A:W\"),23,FALSE)<0.8,\"6*,\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(B25&C25&D25&E25=\"\",\"\",\"Improvements are needed.\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IFERROR(A24&B24&C24&D24&E24&F24&B25&C25&D25&E25&F25&IF(A24=\"\",\"\",\" Compared to the average of \"&A12),\"\")","v":""}]

{"sheet":"year-on-year comparison","index":5,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
[null,null,"FY",null,{"$f":"'FY specification & file import'!B4-1 & \"FY\"","v":"-1FY"},null,"difference"]
[null,"company code","X","Y","X","Y","X","Y","X","Y"]
[null,{"$f":"FB!C4","v":0},{"$f":"FB!G39","v":{"$error":"#REF!"}},{"$f":"FB!H39","v":{"$error":"#REF!"}},{"$f":"FB!G34","v":{"$error":"#REF!"}},{"$f":"FB!H34","v":{"$error":"#REF!"}},{"$f":"C3-E3","v":{"$error":"#REF!"}},{"$f":"D3-F3","v":{"$error":"#REF!"}},{"$f":"IF(G3>0,\"a\",IF(G3=0,\"b\",\"c\"))","v":{"$error":"#REF!"}},{"$f":"IF(H3>0,\"a\",IF(H3=0,\"b\",\"c\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"+","a","About process, some improvements of score are found from previous year."]
[null,null,"comment",null,null,null,null,null,null,null,0,"b","About process, same score as previous year."]
[null,null,{"$f":"IFERROR(VLOOKUP(I3,L4:M6,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"-","c","About process, score dropped from previous year."]
[null,null,{"$f":"IFERROR(VLOOKUP(J3,L8:M10,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"+","a","About operation, some improvements of score are found from previous year."]
[null,null,null,null,null,null,null,null,null,null,0,"b","About operation, same score as previous year."]
[null,null,null,null,null,null,null,null,null,null,"-","c","About operation, score dropped from previous year."]

{"sheet":"database","index":6,"n_rows":2,"n_cols":30,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4]]}
["company code","company name","Score for Process\nX","Internal score for Process","Score for Operation\nY","Internal score for Operation","Score for Process",null,null,null,null,null,"Internal score for Process",null,null,null,null,null,"Score for Operation",null,null,null,null,null,"実施状況"]
[null,null,null,null,null,null,"1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check","6_Management of human resources as well as documents and information","1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check","6_Management of human resources as well as documents and information","1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check","6_Management of human resources as well as documents and information","1_State of the organization and management system","2_Basic policy and management framework","3_Management of chemicals in products","4_Operation of management of chemicals in products","5_Management of information and data on chemicals and operation of conformity check","6_Management of human resources as well as documents and information"]

{"sheet":"B_question_result","index":7,"n_rows":2,"n_cols":28,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["company code","company name","C1","C2","C3","C4","C5","C6","C7","C8","C9","C10","C11","C12","C13","C1_exmaples","C2_exmaples","C3_exmaples","C4_exmaples","C5_exmaples","C6_exmaples","C7_exmaples","C8_exmaples","C9_exmaples","C10_exmaples","C11_exmaples","C12_exmaples","C13_exmaples"]

{"sheet":"answer list","index":8,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[2,0,4,1],[2,2,4,3],[2,4,4,5],[2,6,3,7],[58,1,59,1],[58,2,58,5],[59,2,59,5],[58,6,58,7],[59,6,59,7]]}
[null,null,null,null,null,"company code"]
[null,null,null,null,null,"company name"]
["Level 1",null,"Level 2",null,"Level 3",null,"Answer"]
[]
[null,null,null,null,null,null,"Process","Operation"]
["1","State of the organization and management system",1.1000000000000001,"Management system","1.1.1","Acquisition of management system certifications (acquisition of ISO14001 or other environmental certification (simplified EMS)) and operation of it"]
[]
[]
[]
[]
[2,"Basic policy and management framework",2.1,"Basic policy on chemicals in products","2.1.1","Existence of policy on management of chemicals in products and dissemination in and outside the company (organization)"]
[]
[null,null,2.2000000000000002,"Management framework for chemicals in products","2.2.1","Existence and operation of a management framework for chemicals in products in the company (organization)"]
[null,null,2.2999999999999998,"Governance over domestic and overseas subsidiaries and subcontractors","2.3.1","Establishment and operation of a governance and management framework for domestic and overseas subsidiaries and subcontractors"]
[null,null,2.4,null,"2.4.1"]
[3,"Management of chemicals in products",3.1,"Management criteria for chemicals in products ","3.1.1","Existence of management criteria for chemicals in products (e.g., laws and regulations to be observed, restricted substances, and management methods)"]
[null,null,3.2,"Provisions for division of roles and work procedures to reliably manage chemicals in products","3.2.1","Existence of provisions for division of roles and work procedures to manage chemicals in products and their operation"]
[null,null,null,null,"3.2.2"]
[null,null,3.3,"Goals and action plan","3.3.1","Existence of goals according to the policy in question 2.1.1 and an action plan to achieve the goals as well as how operations are performed according to the plan"]
[null,null,3.4,"System related to the management of chemicals in products by customers","3.4.1","Contact department for operations related to the management of chemicals in products (e.g., IMDS, criteria, and studies), maintenance of person-in-charge information, and how they are communicated to customers"]
[null,null,null,null,"3.4.2","Compliance with customers’ provisions for management of chemicals in products"]
[null,null,null,null,"3.4.3"]
[4,"Operation of management of chemicals in products",4.0999999999999996,"Management of chemicals in products during design and development","4.1.1","Existence of provisions for operations management and how operations are performed and managed according to the provisions"]
[null,null,4.2,"Management of chemicals in products at time of purchase and acceptance of parts and materials","4.2.1","Existence of provisions for acquisition and verification of information on chemicals in products from suppliers and how operations are performed according to the provisions"]
[null,null,null,null,"4.2.2","Existence of provisions for management of chemicals in products at the first and routine acceptance of products and how operations are performed according to the provisions"]
[null,null,4.3,"Management of chemicals in products in manufacturing processes in the company","4.3.1","Existence of management provisions for management criteria in manufacturing processes and how operations are performed according to the provisions"]
[null,null,null,null,"4.3.2","Existence of provisions for management of products associated with conversion processes (manufacturing processes in which the composition of chemical substances changes due to oxidation reaction, reduction reaction, or other phenomenon or manufacturing processes in which the concentration of chemical substances changes due to condensation, evaporation, or other phenomenon) and how operations are performed according to the provisions"]
[null,null,null,null,"4.3.3","Existence of provisions for operations management related to traceability and how operations are performed according to the provisions"]
[null,null,null,null,"4.3.4","Existence of management criteria and provisions for changes in processes and materials and abnormalities in processes (including misuse and entry of foreign matter) and how operations are performed according to the provisions"]
[null,null,4.4000000000000004,"Management of chemicals in products in the shipment process in the company","4.4.1","Existence of work procedures and provisions in the shipment process and how operations are performed according to the provisions"]
[null,null,null,null,"4.4.2"]
[null,null,null,null,"4.4.3"]
[null,null,4.5,"Management of suppliers","4.5.1","Existence and operation of a system to provide suppliers with management requirements for chemicals in products"]
[null,null,null,null,"4.5.2","Existence of provisions for verification of suppliers’ management framework for chemicals in products and how operations are performed according to the provisions"]
[null,null,4.5999999999999996,"Points to be noted on management of chemicals in products in other processes in the company","4.6.1","Existence of procedures and rules in case of an abnormality or nonconforming product and how operations are performed according to the rules"]
[null,null,null,null,"4.6.2","Existence of a system for recurrence prevention and lateral dissemination and how operations are performed"]
[null,null,null,null,"4.6.3"]
[null,null,null,null,"4.6.4"]
[null,null,null,null,"4.6.5"]
[5,"Management of information and data on chemicals and operation of conformity check operations",5.0999999999999996,"Overall operation","5.1.1","Existence of provisions for the operation of data management and conformity check operations related to the management of chemicals in products in general and how operations are performed"]
[null,null,5.2,"Acquisition of data from suppliers and verification of acquired data","5.2.1","Existence of rules for data exchange with suppliers (request for submission and acquisition) and how operations are performed according to the rules"]
[null,null,null,null,"5.2.2","Existence of rules for conformity checks of data received from suppliers and actions in case of a nonconformity and how operations are performed according to the rules"]
[null,null,null,null,"5.2.3"]
[null,null,5.3,"Creation of data on your own products","5.3.1","Existence of rules and a manual on the creation of data on your own products (to be submitted to customers) and how data is created according to them"]
[null,null,null,null,"5.3.2","Whether conversion processes in the manufacturing processes in the company are covered in created data and how data is created"]
[null,null,5.4,"Submission of data to customers","5.4.1","Existence of rules for submission of data to customers and how data is submitted according to them"]
[null,null,null,null,"5.4.2","Existence of a system to meet the submission deadline and whether data is submitted by the deadline"]
[null,null,null,null,"5.4.3","Existence of a clear procedure if submitted data is rejected by customers and how the procedure is implemented"]
[null,null,5.5,"Data storage","5.5.1","Existence of rules for storage of acquired data and how data is stored according to them"]
[null,null,null,null,"5.5.2","Existence of rules for storage of data submitted to customers and how data is stored according to them"]
[null,null,5.6,"Data update","5.6.1","Existence of provisions for updating data (creation, submission, and storage) in case of changes in laws, regulations, or customer criteria and how data is handled according to the provisions"]
[6,"Management of human resources as well as documents and information",6.1,"Education and human resource development","6.1.1","Existence and operation of a system to maintain the sustainability of management operations for chemicals in products (ability requirements, passing on experience/knowledge, in-house education)"]
[null,null,null,null,"6.1.2"]
[null,null,6.2,"Management of documents (various information and records related to the management of chemicals in products)","6.2.1","Existence and management of provisions for records management (written procedures and manuals)"]
[null,null,6.3,"Evaluation and improvement of how education (6.1.1) and document management (6.2.1) are performed","6.3.1","Existence and operation of provisions for evaluation and improvement of the implementation status"]
[]
[]
[]
[null,"Free-form comment","If you have requests or concerns regarding chemical substances management by you or us in general, please feel free to let us know"]
[null,null,"If you have requests, opinions, or other comments on the JAMA and JAPIA Guidelines for Managing Chemicals in Products or the self-examination sheet, please feel free to let us know using the space below."]

{"sheet":"database for FB (hidden)","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}