JP2015035124A - Automatic determination device of environmental load substance - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an automatic determination device which automatically clarifies that a chemical substance is determined not to be used only in some of countries and in which country the chemical substance is an object to be regulated.SOLUTION: An automatic determination device of an environmental load substance includes: environmental load substance information acquisition means for acquiring environmental load substance information including information relating to a use restricted substance for each of a plurality of countries; material information acquisition means for acquiring material information including information relating to a chemical substance in a material; storage means for storing the environmental load substance information and the material information; determination means for determining whether the chemical substance included in the material information is included in the environmental load substance information, and output means for outputting the information to the effect that the chemical substance included in the material information is restricted in use in a specific country only when it is determined that the chemical substance included in the material information is included in the environmental load substance information and information to the effect that the chemical substance included in the material information is designated as a use-restricted substance in a specific country is included in the environmental load substance information.

Description

  The present invention relates to an environmental impact substance automatic determination system.

  In recent years, management of chemical substances and their use has been carried out in order to protect human health and the environment. For example, the EU has enacted REACH, which is a law concerning chemical substances and their safe use, handling, and applications. REACH covers molded products and preparations that are exported to the EU. In the REACH regulation, SVHC (Substance of Very High Concern) is designated as a highly harmful substance. Substances that cannot be used or sold in the EU unless an authorization is filed and approved in SVHC are called substances requiring approval. It is not easy to obtain an approval because an application for approval can only be made in the EU country, and it is not permitted if there is an alternative technology. For this reason, the automobile industry does not apply for approval of substances that require authorization, and is working to switch to another substance within the determined expiration date.

  In the automobile industry, a global automatic declarable maintenance list (GADSL), which is a list of chemical substances managed in common throughout the world, is created and used to manage chemical substances. GADSL contains about 3000 kinds of substances that are subject to regulation, substances that are expected to be regulated in the future, or substances that have been scientifically proven to have serious adverse effects on the human body and the environment. . Since GADSL is a collection of chemical substances that must be prohibited or declared according to the laws and regulations of each country, it is not permitted to use substances that are included in GADSL and fall under the category of prohibited substances. Substances requiring declaration must be declared even if they are contained in extremely small amounts.

  On the other hand, information on what kind of substance each part used in a product can contain can be obtained from IMDS (International Material Data System). IMDS is a system developed in cooperation with many automobile manufacturers all over the world, and all materials used for manufacturing automobiles are managed as data.

  Alternatively, information on substances contained in parts may be obtained based on a form created by a parts supplier. A component supplier inputs component information into a form called a JAMA sheet. The JAMA sheet is a form agreed by the Japan Automobile Manufacturers Association and the Japan Auto Parts Industries Association.

  Each automobile manufacturer grasps chemical substances contained in their products based on IMDS and JAMA sheets, and confirms whether these chemical substances are contained in SVHC or GADSL of REACH. However, the number of people who understand these tools and regulations is limited, and it is difficult for only those who understand the tools and regulations to respond to legal compliance. On the other hand, for example, there is a risk of severe penalties such as the product being unable to be sold within the EU if the REACH regulations are violated, so management of chemical substances contained in the company's products cannot be neglected.

  Therefore, conventionally, a technique has been proposed in which it is automatically determined whether or not a chemical substance contained in an in-house product corresponds to a prohibited substance specified by GADSL or SVHC.

  For example, Patent Document 1 acquires data related to restricted substances whose use is restricted by REACH regulations, RoHS directives, etc., and acquires delivery component data including the mass of substances used, intended use / parts, etc. A technique for automatically determining whether or not a constituent material contains a limiting substance based on the data is disclosed.

  For example, Patent Document 2 discloses, for each part serving as a minimum unit constituting a product, based on content data of a predetermined substance for each part forming a part of a product and reference data for a predetermined substance related to the environment. Discloses a technology for managing contained chemical substances.

JP 2011-59885 A JP 2007-94776 A

  Chemical substances that are subject to regulations on use and sales may differ in each country. For example, GADSL contains substances that are subject to regulation only in certain countries. The REACH regulations are for EU countries. For example, the chemical substances specified by TSCA (Toxic Substances Control Act) for North America and those specified by SVHC are different. is there.

  In the inventions described in Patent Documents 1 and 2, it is not considered that chemical substances subject to regulation differ from country to country. Therefore, if it is judged that a chemical substance contained in a part is not subject to regulation (can be used) even though it is subject to regulation in some countries, the part will be regulated only in some countries later. There is a risk of having to sell the product after replacing it with a non-targeted part. In addition, if it is determined that the product is restricted only in some countries but is not restricted (unusable), even if you do not plan to sell the product in that country, There is a risk of compulsory replacement of parts for compliance.

  Therefore, the present invention, when the determination result of whether or not a chemical substance can be used varies from country to country, the chemical substance is determined to be unusable only in some countries, and is subject to regulation in any country. It is an object to provide an automatic determination device for environmentally hazardous substances that automatically clarifies whether or not a substance is present.

  The invention according to claim 1 acquires environmental load substance information acquisition means for acquiring information on environmental load substances including information on prohibited substances in a plurality of countries, and material information including information on chemical substances contained in the materials. A material information acquisition means; a storage means for storing the environmental load substance information and the material information; a determination means for determining whether a chemical substance included in the material information is included in the environmental load substance information; It is determined that the chemical substance included in the material information is included in the environmentally hazardous substance information, and information that the chemical substance included in the material information is designated as a prohibited substance only in a specific country is the environmentally hazardous substance. And an output means for outputting information indicating that the chemical substance included in the material information is prohibited to use only in the specific country. It is an automatic determination apparatus of quality.

  The invention according to claim 2 is the automatic environmental impact substance determination device according to claim 1, wherein one or more chemical substances included in the environmental impact substance information correspond to prohibited substances. Information indicating a plurality of threshold values that differ for each use of the chemical substance, the material information includes information indicating the content of the chemical substance contained in the material, and the material information acquisition means further includes: The information indicating the use of the chemical substance contained in the material is acquired, and the determination unit includes the threshold value and the material when the chemical substance contained in the material is a chemical substance contained in the environmental load substance information. And determining whether or not a chemical substance contained in the material corresponds to a prohibited substance based on the content and use of the chemical substance.

  The invention according to claim 3 is the automatic environmental impact substance determination device according to claim 1, wherein the material information acquisition means acquires the material information in the csv format in the csv format, and the pdf format An automatic determination device for environmentally hazardous substances, wherein material information is obtained by converting the material information in the csv format into a csv format in which the material information is associated with the data structure.

  According to the present invention, when the determination result of whether or not a chemical substance can be used varies from country to country, the chemical substance is determined to be unusable only in some countries, and is subject to regulation in any country. It can be clarified automatically.

It is a figure which shows the structure of the automatic determination apparatus 10 of the environmental impact substance which concerns on this embodiment. It is a flowchart which shows the flow of a process of the automatic determination apparatus 10 in this embodiment. It is the figure which showed a part of GADSL30. It is the figure which showed the material information which IMDS36 outputs. It is a flowchart which shows the flow of a process of the automatic determination apparatus 10 in other embodiment. It is the figure which showed a part of ELV ANNEX II34. It is a figure which shows a mode that a use and a threshold value are output.

  Hereinafter, an example of an embodiment of an environmental impact substance automatic determination device according to the present invention will be described. FIG. 1 is a diagram showing a configuration of an environmental impact substance automatic determination device 10 according to the present embodiment.

  The automatic determination device 10 is, for example, a personal computer used by an automobile manufacturer. The automatic determination device 10 includes a communication unit 12, an input unit 14, an output unit 16, a storage unit 18 that stores a DB 20, and the like, and an information acquisition unit 24 and a determination unit 26. Means 22 is included.

  The communication unit 12 is a LAN card, for example, and is a unit for connecting to the network 28.

  The input means 14 is, for example, a keyboard or a mouse, and is a means for accepting operations such as character input and mouse clicks on the automatic determination device 10.

  The output unit 16 is, for example, a monitor, and is a unit that displays and outputs a determination result of the automatic determination device 10 and the like. Or the printer etc. which print the determination result of the automatic determination apparatus 10 on a paper medium, etc. may be sufficient.

  The storage unit 18 is, for example, a ROM or a RAM, and stores a program for causing a computer to function as the automatic determination device 10, a calculation result of the automatic determination device 10, and the like. Further, the storage means constructs and stores information included in the GADSL 30 and SVHC 32 described later as the DB 20.

  The control means 22 is, for example, a CPU (Central Processing Unit), and executes general arithmetic control within the automatic determination device 10. The control means 22 transmits the environmental load substance information including information related to prohibited substances such as GADSL and the material information including information related to substances contained in the material from IMDS 36 described later via the communication means 12 and the network 28 such as the Internet. The information acquisition means 24 to acquire is included. Further, it includes a determination unit 26 that determines whether or not a chemical substance contained in a material corresponds to a prohibited substance based on environmental load substance information and material information.

  Hereinafter, the operation of the automatic determination device 10 in the present embodiment will be described. FIG. 2 is a flowchart showing a flow of processing of the automatic determination device 10 in the present embodiment.

  In step S10, the information acquisition unit 24 acquires the GADSL 30 and the SVHC 32 via the communication unit 12 and the network 28, and acquires environmental load substance information from the information included therein. The GADSL 30 and SVHC 32 are made public on the Internet, and the information acquisition unit 24 can acquire the GADSL 30 and SVHC 32 via the network 28.

  FIG. 3 is a diagram showing a part of the GADSL 30. As described above, there are about 3000 types of substances in GADSL30 that are subject to regulation, substances that are expected to be regulated in the future, or substances that are scientifically proven to have serious adverse effects on the human body and the environment. include. The substances described in GADSL30 are classified into three. Prohibited substances, required substances, and prohibited / required substances. If a prohibited substance or prohibited / declarable substance falls under prohibition, use is prohibited. Substances requiring declaration are allowed to be used, but if there is a request for disclosure of information on materials, they must be answered (declared) in IMDS or JAMA sheet even if the amount is extremely small. GADSL 30 includes a substance name column 60 indicating the substance names of these substances, and CAS-NO. CAS-NO. It includes a column 62, a required legal regulation column 64 indicating which regulation the substance is regulated by, and a threshold value column 66 indicating a threshold value.

  For example, referring to No. 21, "reaction product of diphenylamine, styrene and diisobutylene" is CAS-NO. Is "68921-45-9", the required regulation is the law of "Canada", and the threshold value is "0.1 (%)". Referring to No. 23, “N, N-dicyclohexane-1-yl (1,3-benzothiazol-2-yl (sulfanyl) amine” has a CAS-NO of “4979-3-2”. It can be seen that the required laws and regulations are “Japan” laws, and no threshold is set.

  As described above, the GADSL 30 includes information on prohibited substances in a plurality of countries. For example, “reaction product of diphenylamine, styrene, and diisobutylene” is designated as a prohibited substance in Canada, and “N, N-dicyclohexane-1-yl (1,3-benzothiazol-2-yl (sulfanyl) amine” Is designated as a prohibited substance in Japan.

  The SVHC 32 of the REACH rule has the same information as the GADSL 30. SVHC30 includes information on chemical substances designated as prohibited substances in EU countries.

  In the present embodiment, information included in the GADSL 30 and SVHC 32 is acquired as environmental load substance information, but the environmental load substance information is not limited thereto. For example, information included in TSCA or the like for North America may be acquired.

  The information acquisition unit 24 may store the acquired GADSL 30 and SVHC 32 and other data as they are in the storage unit 18, but may extract information from the GADSL 30 and SVHC 32 to construct and store the DB 20. . For example, when the GADSL 30 is a PDF file, the information is extracted using a known text extraction technique. As a result, it is not necessary to obtain environmental load substance information via the network 28 every time an environmental load substance is automatically determined, and the processing speed can be increased. Even when the DB 20 is constructed, since the GADSL 30 and other environmental load substance information may be updated and the contents may be changed, the environmental load substance information is periodically acquired via the network 28 to update the DB 20. Update.

  In step S <b> 12, the information acquisition unit 24 acquires material information including information on chemical substances contained in the parts via the communication unit 12 and the network 28.

  Material information is obtained from the IMDS 36. As described above, the IMDS 36 is a system in which all materials used for manufacturing automobiles are managed as data. The IMDS 36 outputs material information as, for example, a pdf file. FIG. 4 is a diagram showing material information output by the IMDS 36. As shown in FIG. 4, the material information output by the IMDS 36 includes the part name column 70, CAS-NO. The column 72, the mass column 74, and the content rate column 76 are included.

  For example, referring to the bottom row, a part whose name is “plate of control position indicator” is CAS-No. Including the chemical substance “polyethylene” with “9002-88-4”, and the polyethylene content is “4 (%)” of the mass “16.1 (g)” of the plate of the control position indicator I understand. Further, based on the part name, it is possible to determine what purpose the chemical substance is used for.

  Similar material information can be obtained from the JAMA sheet 40. As described above, the JAMA sheet 40 is a form agreed by the Japan Automobile Manufacturers Association and the Japan Auto Parts Industries Association, and is csv format data. A parts supplier who manufactures parts of an automobile uses the parts name on the JAMA sheet 40 at the parts supplier terminal 38 and CAS-NO. Of the chemical substance containing the parts. In addition, the content, usage, and the like are entered and transmitted to the automatic determination device 10 that is a terminal of the automobile manufacturer via the network 28. The information acquisition unit 24 acquires material information by receiving the JAMA sheet 40.

  The information acquisition unit 24 may extract material information from the IMDS 36 and the JAMA sheet 40 and add the information to the DB 20 and store it as in the case of environmentally hazardous substance information. The material information from the IMDS 36 can be obtained in data or pdf format, but since it is free in the case of pdf output, it is preferable to obtain the material information from the IMDS 36 in pdf format.

  The contents of the pdf format from the IMDS 36 are in a table format as shown in FIG. 4, and it is preferable to extract the data after converting it to the csv format. However, in the contents of the pdf format obtained from the IMDS 36, one column has a plurality of meanings, and an appropriate data structure cannot be obtained simply by converting from the pdf format to the csv format using a known tool. . Therefore, when extracting information from the output in the pdf format obtained from the IMDS 36, it is necessary not only to convert the data into the csv format but also to perform a process of data correction. Specific processing for correcting the data will be described later.

  In step S <b> 14, the determination unit 26 reads the environmental load substance information and the material information from the storage unit 18, and determines whether or not a chemical substance included in the material information is included in the environmental load substance information. When the data shown in FIG. 4 is acquired as material information, it is determined whether one of the chemical substances included in the material information (for example, “carbon black”) is included in the acquired environmental load substance information. If the chemical substance included in the material information is included in the environmental load substance information (“Yes” in step S14), the process proceeds to step S16. If the chemical substance included in the material information is not included in the environmental load substance information, the process proceeds to step S24.

  In step S16, the determination unit 26 refers to the threshold value of the chemical substance in the environmental load substance information for the chemical substance determined to be included in the material information and the environmental load substance information. It compares with the content of the said chemical substance in information, and determines whether content is larger than a threshold value. If it is determined that the content of the chemical substance is larger than the threshold (“Yes” in step S16), the process proceeds to step S18. If it is determined that the content of the chemical substance is smaller than the threshold (“No” in step S16), the process proceeds to step S24. Note that threshold values are not set for all chemical substances included in environmentally hazardous substance information. A chemical substance for which no threshold is set means that the use is prohibited regardless of the content of the material. Therefore, for a chemical substance for which no threshold is set in the environmentally hazardous substance information, the process proceeds to step S18 without performing the determination in step S16.

  In step S18, the determination unit 26 determines whether or not the chemical substance determined to be a use-prohibited substance in steps S14 and S16 is a use prohibition determination (NG determination) in all countries. If it is determined that the NG determination is made in all countries (“Yes” in step S18), the process proceeds to step S20. If it is determined that the NG determination is not made in all countries (“NO” in step S18), the process proceeds to step S22.

  For example, the determination unit 26 determines whether or not a specific chemical substance is determined as NG in all countries based on the required legal regulations column 64 included in the GADSL 30. Referring to FIG. 3, for example, referring to the requirement law column 64 of “reaction product of diphenylamine, styrene and diisobutylene” described in the 21st column, the requirement law of the chemical substance is a Canadian law. This means that “a reaction product of diphenylamine, styrene, and diisobutylene” is determined to be a prohibited substance in Canada, but is not prohibited in other countries. Therefore, when information indicating that only a specific country is applicable is described in the required legal regulations column 64 of the GADSL 30, it is determined in step S18 that the determination is not NG in all countries, and the process proceeds to step S22. become.

  In step S20, the determination means 26 determines that the chemical substance determined in steps S14 to S18 is a prohibited substance (NG determination). Thereafter, the determination from step S14 is also performed for other chemical substances included in the material information, and the determination is completed for all chemical substances included in the material information.

  In step S22, the determination means 26 outputs that the chemical substance is NG determination in a specific country. For example, the determination unit 26 displays on the monitor which is the output unit 16 that “parts XX containing chemical substances XX are judged as NG in Canada”. Alternatively, a message indicating that “part XX is for Canada?” Is displayed, and the user operating the automatic determination apparatus 10 inputs whether or not the part is for Canada using the input means 14 and inputs that the part is not for Canada. If it is determined that the determination is OK, an OK determination may be displayed, and if it is input that the destination is for Canada, an NG determination may be displayed.

  In step S24, as in step S20, the determination unit 26 determines that the chemical substance determined in steps S14 to S16 is a usable substance (OK determination). Thereafter, the determination from step S14 is also performed for other chemical substances included in the material substance, and the determination is completed for all chemical substances included in the material substance.

  When the process of step S20 or step S24 is completed, the control unit 22 may automatically create a report indicating the determination result.

  As described above, in the present embodiment, in addition to automatically determining whether or not a chemical substance contained in a material corresponds to an environmentally hazardous substance and is prohibited to use, if the determination results differ in a plurality of countries, Explicitly indicate that NG determination will be made in some countries, and also indicate countries that will be NG determination. This makes it possible to easily and quickly make judgments and create reports even if you are not familiar with tools and regulations related to environmentally hazardous substances, as well as easily understand country-specific judgment results. .

  Hereinafter, examples of other embodiments will be described. In another embodiment, ELV ANNEX II34 is further acquired as environmental load substance information, and a determination based on this is performed. FIG. 5 is a flowchart showing a process flow of the automatic determination device 10 according to another embodiment.

  In step S <b> 40, as in step S <b> 10, the information acquisition unit 24 acquires GADSL 30 and SVHC 32 via the communication unit 12 and the network 28. In step S <b> 40, the information acquisition unit 24 further acquires the ELV ANNEX II 34 via the communication unit 12 and the network 28.

  ELV ANNEX II34 includes information on chemical substances that are permitted to be used according to their usage and content even if they are designated as prohibited substances. For example, lead is designated as a prohibited substance in GADSL30, but lead that is used for lead-acid batteries does not have an appropriate alternative material, so that it does not flow out to the outside by being mixed with another when recovered. It is approved for use because it can be managed. The ELV ANNEX II 34 is also disclosed on the Internet like the GADSL 30 and the SVHC 32, and the information acquisition means 24 can acquire the ELV ANNEX II 34 via the network 28.

  FIG. 6 is a diagram showing a part of the ELV ANNEX II34. FIG. 6 shows that the threshold value differs for each use of lead, which is an environmentally hazardous substance. For example, in the upper left column of FIG. 6, when the application is “processing steel batch type hot-dip galvanized steel”, the threshold value for determining that lead is an unusable substance is 0.35% of the mass of the part. In the lower left column, when the application is “working aluminum”, the threshold is 2 (%) of the mass of the part. Thus, even for the same chemical substance, the threshold may differ depending on the application, and information indicating the threshold corresponding to the application is also included in the ELV ANNEX II34. As in the embodiment shown in FIG. 1, the information acquisition unit 24 may store the acquired ELV ANNEX II 34 data in the storage unit 18 as it is, but the information extracted from the ELV ANNEX II 34 and extracted into the DB 20 May be added.

  In step S <b> 42, as in step S <b> 12, the information acquisition unit 24 acquires material information via the communication unit 12 and the network 28.

  In step S44, as in step S14, the determination unit 26 reads the environmental load substance information and the material information from the storage unit 18, and determines whether or not a chemical substance included in the material information is included in the environmental load substance information. When it is determined that the chemical substance included in the material information is included in the environmental load substance information (“Yes” in step S44), the process proceeds to step S46. If it is determined that the chemical substance included in the material information is not included in the environmental load substance information (“No” in step S44), the process proceeds to step S24 in FIG. 1, and the above-described processing is performed after step S24.

  In step S46, the determination unit 26 determines whether or not the chemical substance determined to be included in the environmental load substance information in step S44 has a plurality of different thresholds for different uses. Whether or not a plurality of threshold values differ depending on the use is determined based on information extracted from the ELV ANNEX II34. If it is determined that there are a plurality of different thresholds for different uses (“Yes” in step S46), the process proceeds to step S48. If it is determined that there are not a plurality of different threshold values for different applications (“No” in step S46), the process proceeds to step S16 in FIG. 1, and the above-described processing is performed after step S16.

  In step S <b> 48, the determination unit 26 extracts a plurality of threshold values that differ depending on the application from the ELV ANNEX II 34, and outputs the threshold values in association with the application and the output unit 16. FIG. 7 is a diagram illustrating a state in which usages and threshold values are output. In the present embodiment, the determination unit 26 displays the pop-up window 80 on the monitor that is the output unit 16 and outputs the usage and the threshold value. The pop-up window 80 determines that the chemical substance “arsenic” is always usable when the application is “semiconductor, lead battery, printed circuit board”, and the threshold is “500 (ppm) when the application is“ metal ”. It is indicated that the threshold is “300 (ppm)” when the application is solder, and the threshold is “100 (ppm)” for other applications.

  In step S48, not only the use and threshold value are displayed, but also the user operating the automatic determination apparatus 10 is made to input by the input means 14 which of the displayed uses the substance corresponds to. Also good. Specifically, an input field 82 is provided in the pop-up window 80, and the usage is input to the input field 82. In the example shown in FIG. 7, when arsenic is used for solder, the user inputs “3” in the input field 82 and clicks the “OK” button.

  In step S50, the determination unit 26 determines whether or not the chemical substance is OK based on the threshold value and material information corresponding to the use designated by the user. For example, when arsenic is used for solder and the user inputs “3” in the input field 82, the determination unit 26 reads the arsenic content from the material information, and the arsenic content and the threshold corresponding to the application Is compared with 300 ppm, and it is determined whether or not arsenic can be used. In the case of OK determination (“Yes” in step S50), the process proceeds to step S24 in FIG. 1, and the above-described processing is performed after step S24. In the case of NG determination (“No” in step S50), the process proceeds to step S18 in FIG. 1, and the above-described processing is performed after step S18.

  In step S50, the determination is made based on the use input in the input field 82, but the use of the chemical substance may be determined from the material information. That is, the determination unit 26 may automatically determine what purpose the chemical substance is used for based on the part name included in the material information.

  As described above, according to the present embodiment, even if the threshold value is different for each application, it is possible to make an appropriate determination according to the application of the chemical substance. Furthermore, by explicitly indicating threshold values for other applications, it is possible to grasp that the chemical substance can be used for other applications, and it can be used for subsequent parts production.

  Hereinafter, the conversion of the data format of the material information will be described particularly when the material information is output from the IMDS 36 in the pdf format.

  As described above, the output from IMDS 36 may be in pdf format, while JAMA sheet 40 is in csv format. Therefore, when the information acquisition unit 24 acquires material information and constructs the DB 20 in the storage unit 18, if the material information having different formats is included, efficient processing cannot be performed. Therefore, the information acquisition unit 24 stores the storage unit 18 in a unified material information format. Specifically, the data in the pdf format output from the IMDS 36 is converted into the csv format that is the same format as the JAMA sheet 40. Furthermore, the processing efficiency is improved by making the data structure of the IMDS 36 correspond to the JAMA sheet 40.

  Simply converting pdf data to csv data is a known technique. However, as shown in FIG. 4, the output of the IMDS 36 may have a plurality of items in one column. For example, CAS-NO. The information described in the column 72 is CAS-NO. (Black triangle next to the number) and part number (black square next to the number). Therefore, by simply converting data in the pdf format into data in the csv format, data of different items is included in one column in the csv format, and appropriate csv format data cannot be obtained. Therefore, in the present embodiment, processing for appropriately dividing a plurality of items included in one column into a plurality of columns is performed.

  For example, CAS-NO. (Compound numbers used in Chemical Abstracts published by American Chemical Society, ACS) are hyphens in the second and fifth digits from the right. Based on this, the information acquisition means 24 is CAS-NO. In the column 72, the numbers where the second digit and the fifth digit from the right are hyphens are calculation formulas called check digits. If a correct calculation result is obtained, CAS-NO. It can be judged that.

The formula for calculating the check digit is as follows.
CAS-No. But,
N7N6N5N4N3-N2N1-R
(R and Ni are numbers 0 to 9 for each digit, and 0 if no digit is present)
R = (8 × N8 + 7 × N7 + 6 × N6 + 5 × N5 + 4 × N4 + 3 × N3 + 2 × N2 + N1) mod 10 (remainder number divided by 10)

For example, since the CAS registration number of water is 7732-18-5, R = 5 as follows.
(6 × 7 + 5 × 7 + 4 × 3 + 3 × 2 + 2 × 1 + 8) = 105
105 mod 10 = 5 (105 = 10 × 10 + 5)

  In the case where only “system” is described or only hyphen is described, CAS-NO. Judge. If these conditions are not met, the part number is determined. And CAS-NO. The cell in which the character string determined to be described and the cell in which the character string determined to be the part number are described are arranged in different columns. In this way, a process of dividing a plurality of items included in one column into a plurality of columns according to the characteristics of the character string of the value indicating each item is performed.

  In addition, column shift may occur in the process of conversion from the pdf format to the csv format. The column shift refers to a phenomenon in which a part of values (partial line values) described in the mass column 74 in the pdf format are included in the content rate column 76 in the csv format. In such a case, for example, the character string described in the content rate column 76 is read, and when it is a value of 100 or more (the content rate cannot take a value of 100 or more), this value is originally the mass column. 74, it is determined that the character string is included in 74, and the character string is correctly moved to the column of the mass column 74 in the csv format.

  Furthermore, line shift may occur in the process of conversion from the pdf format to the csv format. Line shift refers to a phenomenon in which a character string spans multiple lines in the csv format when, for example, the number of characters included in one cell is long and a line feed is included. For example, in the output of the IMDS 36, there is a possibility that a line shift occurs when the part name or the chemical substance name is long. In such a case, for example, the chemical substance name and CAS-NO. Understand the corresponding line based on the correspondence relationship with. In FIG. 4, it is assumed that “Propenentilele, polymer with 1,3-butadio, ethylbenzen...” Described in the top line of the part name column 70 is described in a plurality of lines in the csv format. In such a case, the “Carbon black” and “Carbon black” CAS-NO. Based on the correspondence relationship with “1333-86-4”, line shift is detected, and the line structure is edited so as to correspond to the original pdf format.

  In this way, a plurality of items included in one column are divided into a plurality of columns according to the contents, and the output in the pdf format of the IMDS 36 is converted into csv format data having a data structure corresponding to the data structure of the JAMA sheet 40. To do. The data structure corresponding to the data structure of the JAMA sheet 40 means a data structure in which the items that the JAMA sheet 40 has as columns are similarly included in the columns.

  As described above, the information acquisition unit 24 stores the pdf format output of the IMDS 36 as csv format data in which the JAMA sheet 40 and the data structure are associated with each other, and stores the data in the storage unit 18. As a result, the determination process can be performed more efficiently.

  DESCRIPTION OF SYMBOLS 10 Automatic determination apparatus, 12 Communication means, 14 Input means, 16 Output means, 18 Storage means, 20 DB, 22 Control means, 24 Information acquisition means, 26 Determination means, 28 Network, 30 GADSL, 32 SVHC, 34 ELV ANNEX II 36 IMDS, 38 parts supplier terminal, 40 JAMA sheet, 60 substance name column, 62, 72 CAS-NO. Field, 64 requirement law field, 66 threshold value field, 70 part name field, 74 mass field, 76 content rate field, 80 pop-up window, 82 input field.

Claims (3)

Environmentally hazardous substance information acquisition means for acquiring environmentally hazardous substance information including information on prohibited substances in each country,
Material information acquisition means for acquiring material information including information on chemical substances contained in the material;
Storage means for storing the environmental load substance information and the material information;
Determining means for determining whether or not a chemical substance included in the material information is included in the environmentally hazardous substance information;
It is determined that the chemical substance included in the material information is included in the environmentally hazardous substance information, and information indicating that the chemical substance included in the material information is designated as a prohibited substance only in a specific country When included in the substance information, the output means for outputting information indicating that the chemical substance included in the material information is prohibited to use only in the specific country;
An automatic determination device for environmentally hazardous substances. An automatic determination device for environmentally hazardous substances according to claim 1,
The one or more chemical substances included in the environmentally hazardous substance information include information indicating a plurality of threshold values that are threshold values as to whether or not the substance is a prohibited substance, and differ for each use of the chemical substance,
The material information includes information indicating the content of chemical substances contained in the material,
The material information acquisition means further acquires information indicating the use of a chemical substance contained in the material,
When the chemical substance included in the material is a chemical substance included in the environmental load substance information, the determination unit is included in the material based on the threshold value, the content of the chemical substance included in the material, and the use. Determine whether a chemical substance is a prohibited substance,
An automatic determination device for environmentally hazardous substances. An automatic determination device for environmentally hazardous substances according to claim 1,
The material information acquisition unit acquires the material information in the csv format as it is in the csv format, and acquires the material information in the pdf format by converting the material information in the csv format into a csv format corresponding to the data structure. ,
An automatic determination device for environmentally hazardous substances.