JP5439328B2 - Environmental load change notification device - Google Patents

Description

The present invention relates to an apparatus for notifying a related scenario when a basic unit necessary for calculating an environmental load throughout a product life cycle is changed or deleted.

  As background art of this technical field, there is JP-A-2008-102877 (Patent Document 1). In this publication. When calculating the environmental load related to products, parts, and materials, a specifying method is described by searching keywords and basic units from association information in order to specify basic unit data from similar items.

  There is also known a technology that issues a warning when deleting data by managing data representing the connection between basic units.

  In this way, although a method for associating a basic unit with a scenario, which is a collection of parameters necessary for performing a life cycle assessment (LCA) such as products, parts, materials, recycling, disposal, etc., is described, There is no means for notifying that there is a possibility that the environmental load value of the product has been changed when the basic unit is changed or deleted.

  In addition, the basic unit refers to data representing resources, energy amount and emission amount required for manufacturing per unit of material, energy, etc., but the basic unit may be created using the basic unit. For example, in the iron cutting process, 10 kwh of electric power is consumed to cut iron for 1 minute. The basic unit used at this time is the electric power basic unit (environmental load / kwh), and the generated basic unit is the iron cutting basic unit (environmental load / min). When there is a connection between such basic units, if the power basic unit is changed, the cutting basic unit is also affected. Furthermore, since there are a plurality of scenarios associated with the power consumption unit or the cutting unit consumption, the influence range when the basic unit is changed is wide, and there is a problem in processing performance only with the conventional 1: n association. .

JP 2008-102877 A

  In the conventional LCA calculation device, when the basic unit is deleted or updated, the fact that the basic unit has been deleted or changed is disclosed to all users, and the user reviews all of his evaluation scenarios. Above, I had to judge at my own risk whether recalculation was necessary. If it has been deleted, the basic unit data at the time of calculation must be managed by a personal PC as a means for indicating past calculation conditions.

The present invention stores a basic unit name storage unit for storing at least a basic unit name, unit, other attribute information, etc., a basic unit and basic unit relationship or a basic unit and environmental load item relationship, and at least related numerical information. A basic unit value storage unit, a basic unit relation storage unit for identifying which fiscal unit value is a value of a basic unit set of which organization, publication agency, country, etc. LCA calculation conditions for each component consisting of stage information such as ID, parts, materials, processing order indicating the order of the manufacturing process of parts and LCA calculation, and stage information such as material manufacturing, product manufacturing, use, recycling, disposal, etc. and basic unit A scenario status management storage unit configured to store at least a calculation execution date, a calculation execution basic unit, and a process execution flag. A basic unit product that lists the changed basic units by calculating the numerical value according to the hierarchical information from the basic unit and the basic unit in the basic unit value storage unit or the relationship between the basic unit and the environmental load item and the numerical information thereof. An upper calculation processing means, a basic unit value storage means for storing the above-mentioned roll calculation processing result, and a calculation execution flag of the scenario status management storage unit by extracting a relevant scenario from the changed basic unit value list Is provided with a scenario recalculation notification means for changing to a recalculation flag only for those already calculated.
In addition, even when the basic unit is deleted, the present invention also provides the basic unit name storage unit, the basic unit value storage unit, the basic unit relation storage unit, the part scenario condition storage unit, the scenario status management storage unit, and the basic unit product. Upper calculation processing means, basic unit value storage means, and scenario recalculation notification means are provided.

  According to the present invention, when the basic unit is changed / deleted, a scenario in which the evaluator himself needs to recalculate can be easily extracted without contacting / disclosing detailed information of the changed part to the related parties.

The representative figure of the environmental load change notification apparatus by this invention. The example of the storage item of a basic unit name memory | storage part. The example of the storage item of a basic value storage part. The example of the storage item of a basic unit relation storage part. The figure explaining the flow of a process of a basic unit roll-up calculation process means and a basic unit value storage means. The figure explaining the flow of a process of a basic unit roll-up calculation process means and a basic unit value storage means (continuation of FIG. 5). An image diagram showing the parent-child relationship as a tree for basic unit code parts processing. An example of an array table for unit value roll-up calculation processing. Correspondence table of basic unit codes and values. An example of items stored in the part scenario condition storage unit. The example of the storage item of a scenario status management memory | storage part. The figure explaining the flow of a process of a scenario recalculation notification means.

  Hereinafter, embodiments of an environmental load notification device will be described with reference to the drawings.

In this embodiment, an apparatus for changing the status of a related scenario and notifying recalculation when changing the basic unit will be described.
FIG. 1 is an example of a configuration diagram of an environmental load notification device according to the present embodiment. Various storage units described below are configured by a storage device such as a hard disk. The various means described below are realized by an arithmetic device such as a CPU.

The environmental load notification device in FIG. 1 includes at least a basic unit name storage unit 1 for storing a basic unit name, unit, other attribute information, and the like, and a basic unit and a basic unit or a basic unit and an environmental load item. A basic unit value storage unit 2 for storing the related numerical value information, a basic unit related storage unit 3 for identifying which year and which unit, publication organization, country, etc. are a basic unit set value, and a scenario The basic unit relation is composed of at least scenario ID, parts, materials, processing order indicating the order of manufacturing process of parts, and stage information such as material manufacturing, product manufacturing, use, recycling, disposal, etc. A scenario including a part scenario condition storage unit 4 that stores LCA calculation conditions for each part to be executed, and scenario calculation processing information including at least a calculation execution date, a calculation execution basic unit, and a process execution flag. The basic unit changed by calculating and accumulating numerical values according to the hierarchy information from the status management storage unit 5 and the basic unit and the basic unit of the basic unit value storage unit or the relationship between the basic unit and the environmental load item and the numerical information thereof The basic unit roll-up calculation processing means 6 for listing, the basic unit value storage means 7 for storing the above-mentioned roll-up calculation processing result, and the related scenario is extracted from the modified basic unit value list, and Scenario recalculation notifying means 8 is provided for changing the calculation execution flag of the scenario status management storage unit to a recalculation flag only for those already calculated.
The components of the first embodiment will be described in order. For the sake of explanation, the configuration of the product, the basic unit, the process, the value of the environmental load, etc. are illustrated, but these are all assumed to be fictitious.

  The basic unit type stored in the basic unit name storage unit 1 is the basic unit when 1 kwh of electric power is manufactured, the basic unit when 1 kg of iron is manufactured, and when iron pressing is performed for 1 minute at the A factory. There are a variety of materials, energy, manufacturing processes, and life cycle processes throughout the life cycle, such as the basic unit, the basic unit when painting is performed once in a specific part process, and the basic unit when 1 kg of aluminum is recycled. The basic unit name storage unit 1 stores a name, a denominator unit, and an input amount at the time of generating the basic unit among such a wide variety of basic units. A specific table is shown in FIG. FIG. 2 shows a basic unit code 11 and a basic unit name 12 for uniquely managing the basic unit, a basic unit classification 13 of attribute information indicating a basic unit type, and an input amount per unit when the basic unit is created. A basic unit creation unit amount 14 and a basic unit creation unit 15 are provided. In addition, a comment for recording information on the basic unit, a creation date, an update date, and the like may be added to the table of FIG. The recording method when the power is manufactured by 1 kWh, as shown in line 17, records power in the basic unit name 12, energy in the basic unit classification 13, 1 in the basic unit creation unit amount 14, and kWh in the basic unit creation unit 15. If the production unit is per part and the environmental load is proportional to kg, the part weight may be written in the basic production unit quantity 14 as shown in row 16. By making the basic unit name unique in the system, recalculation can be easily performed for each basic unit set such as year, organization, publication agency, and country.

  The basic unit value storage unit 2 records the basic unit and the basic unit relationship or the basic unit and the environmental load item. FIG. 3 shows an example of the iron press basic unit. XX codes such as the parent unit code 21, the child unit code / inventory code 22, and the unit-related code 23 in FIG. 3 may be expressed with alphanumeric characters that are easy for the system to recognize. It is preferable to prepare a separate table for the meaning of and the related attributes, but are omitted here for the sake of clarity. FIG. 3 is a table that is uniquely determined by the parent unit code 21, the child unit code / inventory code 22, the unit related code 23, and the accumulation section 24. The iron press intensity is associated with line 19 in FIG. The energy required for processing the 10-minute iron press at the factory A is shown in line 29 of FIG. Electric power of 20.08 (KWh) and LPG of 5.303 (kg) are used as motive energy, and 15.9 (kg-CO2) is discharged along with fuel combustion. The value (per unit) 26 is a value obtained by dividing the value (unit) 27 by 1/10. The energy used here has the same basic unit code in the parent basic unit code. For example, the child unit code / inventory code 22 “power” in the row 29 has the same “power” in the parent unit unit code 21 as 22 in the row 31. “Electric power” in line 22 means the amount of CO 2 emitted when electric power is produced, and 0.324 kg-CO 2 is emitted per kWh. Similarly, the LPG in the row 29 has the same parent unit code 21 in the row 32, and stores the CO2 emission amount when 1 kg of LPG is manufactured. Moreover, although the CO2 emission amount of the iron press is stored in the row 30 with a value different from the above-mentioned CO2 emission amount of 15.9 kg, this is the sum of the CO2 emission amount due to the combustion of energy required for the iron press and the energy production. It is the value.

  As described above, the basic unit has hierarchy information, and the hierarchy covers a plurality of hierarchies. The basic unit value storage unit 2 can identify and store this before and after loading, thereby reducing the inability to process at the time of LCA calculation.

  In addition, the basic unit value storage unit 2 can store the basic unit values depending on the basic unit related code 23 as shown in the row 33 of FIG.

  The basic unit relation storage unit 3 is a recording place for explaining the basic unit relation code 23. An example is shown in FIG. XX codes may be expressed with alphanumeric characters that are easy for the system to recognize. In that case, it is better to prepare a separate table for the meaning of the codes and related attributes, but here the explanation is clear. For the sake of brevity. The base unit related code 31 in FIG. 4 should not be equal to the base unit related code 23 in FIG. The example in the row 36 means a common basic unit prepared for 2010, and only a user with system administrator authority can edit this, but the users who use it are all users registered in the system.

  On the other hand, a row 37 means a basic unit for research and development that can be used only by Research Taro prepared for 2010. The common flag 34 identifies whether there is a basic unit that can be used by all users. When the basic unit value associated with the row 37 does not exist in the basic unit relation storage unit 3, the basic unit value associated with the basic unit related code line 36 in which the common flag 34 of the same year is “common” may be used. Good. There must be one “common” within the same year.

  Although not shown, a screen layout for managing the basic unit will be described. It is preferable that the basic unit can be specified by the basic unit name 12, the basic unit classification 13, the basic unit year 32, and the basic unit set 33 in FIG. The search results can be displayed in a plurality of lines according to the filtering condition, and the selected basic unit is extracted from the basic unit name storage unit 1, the basic unit value storage unit 2, and the basic unit relation storage unit 3, and is collectively collected for the target records. Can be downloaded to spreadsheet software.

  The basic unit roll-up calculation processing means 6 is a means for performing calculation processing from before pre-rolling to post-rolling using the basic unit name storage unit 1, the basic unit value storage unit 2, and the basic unit relation storage unit 3. . For example, line 30 in FIG. 3 is the CO2 emission amount after the iron press basic unit is accumulated, and this is calculated before the accumulation of line 29 and using line 31 and line 32. 2.008 (Kwh / min) * 0.324 (kg-CO2 / Kwh) + 0.5303 * 1.9 (kg-CO2 / kg) +1.59 (kg-CO2 / min) = 3.24 (kg / Min).

  In the following, the basic unit product calculation processing means 6 and the basic unit value storage means 7 will be described along the flow of FIG.

  The process 601 displays a reception screen for newly registering or updating the basic unit. Next, in step 602, the registration data is subjected to input check for each line, and registration information reception processing is performed for data for which there is no input check error.

  A process 603 is a process for identifying whether the registration basic unit is a new registration or an update registration. A process classification is prepared in advance in the registration list so that a new and an update can be determined. In the case of new registration, since the basic unit name needs to be unique in the system, the duplication check of the basic unit name in the process 604 is performed, and if there is no duplication, the process proceeds to the process 605 to record in the basic unit name storage unit 1 And register basic unit name information. If there is a duplicate, an error is returned and the registration process is interrupted. In the case of update registration, the process proceeds to process 606, and a record of the basic unit code that matches the update target is extracted from the basic unit name storage unit 1, and the update date of the basic unit information is updated to the current system date in process 607.

  In order to extract a scenario related to a newly created and updated basic unit, the target basic unit code is recorded in the registration list (i).

  Next, the processing loops 609 and 610 as processing loop initialization processing. Clear the counter i of the target basic unit code to 0. The environmental load items such as CO2, NOx, and SOx are called inventory, but the counter j of the inventory code is cleared to zero.

  Processes 611 and 612 each store the parent unit code in the variable a from the unit value storage unit 2 that defines the relationship between the basic unit and the basic unit or the relationship between the basic unit and the environmental load item, and the child basic unit / inventory. The code is stored in variable b.

  A process 613 is a preprocess for the roll-up calculation process. Since the basic unit value storage unit 2 defines the relationship between the basic unit and the basic unit or the relationship between the basic unit and the environmental load item in the parent-child relationship, the hierarchical level is assigned from the parent-child relationship using the level pseudo column, Generate parent-child data in level order.

  FIG. 7A is an image diagram in which parent-child relationships are displayed in a tree format for only the inventory code CO2 for basic unit code part processing. As a process for processing a part weight of 1 kg, assembling an intermediate part A that is pressed with material A and an intermediate part B that is generated by welding a plurality of parts 5 times, and coating the assembled part once Manufactured by processing the process using 10 g of paint per round three times. At this time, it is assumed that 10 g of CO2 is generated as a result of the press processing per kg of the part weight. The same applies to welding and paint processing. In the process 613, the inventory flag 1 and the child basic unit / inventory code = inventory code, that is, CO2 is set as the starting line, the parent-child relationship is expanded in order with the above a = b as a join condition, and a hierarchical level is added. Get a data list. Level 73 indicates a hierarchical level, and a value (per unit) 75 is a value acquired from the basic unit value storage unit 2. The explanation of the value (per unit) after the accumulation will be given for the later-described processing.

  A process 614 is a process for extracting and recording a target unit code in order to extract a scenario related to the basic unit to be updated. If the basic unit code of the registration list (i) generated in process 608 matches the parent unit code of the data list generated in process 613, if the level is MAX in the data list, it is already registered. Since the basic unit code is recorded in the list (i), additional registration is not required. However, if the level is not MAX, the values are updated for all basic unit codes above the hierarchical level. Record in the registration list (ii) as a unit list.

  A process 617 is an operation part for performing a product calculation. First, in process 615, the data list generated in process 613 is processed from level 1 toward a higher numerical level. If the level of the current row and the next row is level +1 of the current row, the value of the current row * the value of the next row is set to the value of the next row. 76 in FIG. 7B is an example of the value of the calculation result. The second row stores the result 10 of adding the value (per unit) 1 of the second row to the value (per unit) 10 of the first row. Similarly, the third row stores the result 10 of adding the value (per unit) 1 of the third row to the value 10 (per unit) of the second row. Since the fourth line has a level of 1, a new integration process is started. The process 616 stores the calculation result of the process 615 in the array 77 together with the basic unit code. At this time, if the same basic unit code already exists in the array, 78 in FIG. 7C sets the value of the current row + the value of the corresponding basic unit code of the array. Process 617 is repeatedly executed until there is no more data in the data list generated in process 613.

  Next, in process 618, the process proceeds to a process of storing the result of incrementing the basic unit in the basic unit value storage unit 2 for the target inventory code. In the array list of the process 616, the basic unit code and the basic unit value after the roll-up calculation processing for the inventory code are stored, and this is stored in the basic unit value storage unit as the parent basic unit code. The inventory code of the counter j is stored in the child unit / inventory code, and the array value (per unit) is stored in the value (per unit). At that time, the roll-up section is set to 1.

  In the above description, the product of the basic unit values related to the basic unit code a has been processed for the inventory code of the counter j. Therefore, to obtain the next inventory code, the counter of j is incremented by 1 and the processing is repeated from 612. When the counter of j is the MAX value calculated in advance, since there is no inventory code in the basic unit code a, the process proceeds to processing 621 to acquire the next basic unit code. If the parent unit code counter i is not the previously calculated MAX value, the roll-up calculation process is executed for the next unit code, and the process is repeated from 611 by incrementing the counter. If the value is the MAX value, the accumulation calculation process has been executed for all the basic unit codes in the registration list (i), and thus the process ends.

  In addition, the description regarding the said basic unit product calculation process 6 and the said basic unit value storage means 7 may exist on the process in which an inventory code is in the middle. Even in that case, the calculation can be performed by the same processing as described above.

  Next, notification means for extracting a relevant scenario from the registration list (i) and registration list (ii) and prompting recalculation will be described.

  The part scenario condition storage unit 4 is a place where calculation conditions for LCA calculation are stored. An example is shown in FIG. The part scenario condition storage unit 4 includes at least a scenario ID 41 for managing information to be evaluated, a parent part number 42 indicating the configuration information of parts used for LCA evaluation, a child part number 43, and cutting, pressing, etc. until the part is manufactured from the material. A processing order 44 indicating the order of the material processing processes, an evaluation stage code 45 indicating which stage the calculation value is counted in the LCA calculation, a basic unit code 46 used for the calculation, and a calculation logic code 47 indicating the LCA calculation method Have. In addition, the yield rate 48 and parameters 49 and 50 used for calculation are stored as necessary. XX codes may be expressed in alphanumeric characters that are easy for the system to recognize. In this case, it is better to prepare a separate table for the meaning of the codes and related attributes, but here the explanation is clear. To avoid it.

  For example, the row 51 is a row that stores the TOP node recognized by the system, that is, the LCA calculation condition related to the product. In the new PC evaluation, the new PC will consume 200kwh of electricity annually and will be used continuously for 5 years. At this time, the evaluation stage for counting the LCA calculation value is the use stage, and the calculation is performed using the power consumption unit * parameter 1 (200 kwh) * parameter 2 (5 years). In the case of the example of row 56, when the board, which is a component part of the keyboard unic, is transported at a loading rate of 90% at a transport distance of 100 km on a 10 ton truck, the stage for counting the LCA calculation value is the parts transport stage. This is data indicating that calculation is performed by 10 t track basic unit * parameter 1 (100 km) / parameter 2 (90%).

  The LCA calculation is performed based on the value specified in the part scenario condition storage unit 4.

  The scenario status management storage unit 5 is a place where basic information and calculation state of the scenario are stored. An example is shown in FIG. The scenario status management storage unit includes at least a scenario ID 51 for managing a scenario uniquely, a scenario name 52, a calculation execution flag 54 for storing the status of whether the LCA calculation is uncalculated, calculated or recalculated, and the calculated LCA result. A public flag 55 for managing whether or not other than the creator is referred to, a year of the basic unit used for the calculation or used for the calculation, and a basic unit related code 56 for managing the basic unit set. In addition, preliminary attributes such as a calculation execution date, a disassembly time, and an environmentally compatible design evaluation rank may be stored as necessary. XX codes may be expressed in alphanumeric characters that are easy for the system to recognize. In this case, it is better to prepare a separate table for the meaning of the codes and related attributes, but here the explanation is clear. To avoid it.

The scenario recalculation notifying means 8 notifies the possibility that it is necessary to perform recalculation because the basic unit has been changed among the scenarios already evaluated by the roll-up calculation processing means 6 and the basic unit storage means 7. Means. Description will be made along the flow of FIG. 10 and the screen example of FIG. In addition,
A process 1001 is a display screen for displaying a list of scenarios in which the login user is currently performing or managing the LCA evaluation as in the screen example of FIG. A process 1002 can obtain a list of basic units changed in the process of acquiring the registration list (i) and the registration list (ii) created in the flow of FIG. 6 in the initial reading of the screen display. A process 1003 is a process for acquiring a scenario ID list for the scenario to be displayed in the evaluation folder of the screen example.

  A process 1004 extracts a scenario ID in which the basic unit code of the process 1002 is used in the part scenario condition storage unit 4 from the acquired IDs of the process 1003. Thereby, since the basic unit is changed, it is possible to know a scenario in which the LCA calculation result does not use the latest basic unit. Next, in order to notify the recalculation for the scenario, the calculation state of the scenario for which the calculation flag has been calculated is updated to recalculation. The process 1006 displays the scenario in red in the evaluation folder of the screen example and notifies recalculation so that the evaluator can determine that the scenario calculation condition has been changed. For example, when a scenario displayed in red is selected, the processing 1007 reads the basic scenario and then extracts the corresponding basic unit code from the basic unit list obtained in the processing 1002 to change or exist. This is a process of generating a basic unit list that is not performed.

  As described above, by adopting the configuration of the first embodiment, it is possible to acquire the basic unit related to the case where the basic unit value is changed, and the scenario evaluator does not check the data about the evaluated LCA result. Can determine if recalculation is necessary.

1: Basic unit name storage unit 2: Basic unit value storage unit 3: Basic unit relation storage unit 4: Parts scenario condition storage unit 5: Scenario status management storage unit 6: Basic unit product calculation processing means 7: Basic unit value storage Means 8: Scenario recalculation notification means

Claims (3)

An environmental load change notification device for notifying a change in environmental load,
Basic unit name storage unit for storing the basic unit name, unit, other attribute information, etc.
A basic unit value storage unit for storing the basic unit and the basic unit or the basic unit and the environmental load item, and at least the related numerical information;
A basic unit-related storage unit for identifying which basic unit value is a value of a basic unit set of which year, which organization, publication agency, country, etc .;
Relevance of the basic unit of the scenario From at least the scenario ID, part, material, processing order indicating the order of the manufacturing process of the part and LCA calculation, material production, product manufacturing, use, recycling, disposal, etc. A component scenario condition storage unit for storing LCA calculation conditions for each component unit;
Scenario status management storage unit consisting of at least calculation execution date, calculation execution basic unit, and process execution flag for scenario calculation processing information,
A basic unit product that lists the changed basic units by calculating the numerical value according to the hierarchical information from the basic unit and the basic unit in the basic unit value storage unit or the relationship between the basic unit and the environmental load item and the numerical information thereof. Upper calculation processing means;
The basic unit value storage means for storing the above-described rollup calculation processing result, and the scenario execution table in the scenario status management storage unit that has already been calculated by extracting the relevant scenario from the changed basic unit value list. Scenario recalculation notification means for changing to the recalculation flag only for,
An environmental load change notification device comprising: In the environmental load change notification device according to claim 1,
An environmental load change notification device further comprising means for generating a list of basic units changed from the basic unit product calculation processing means. In the environmental load change notification device according to claim 2,
An environmental load change notification device further comprising means for specifying a calculated scenario based on the generated basic unit list and notifying recalculation.

Images