Information processing system and index calculation method

Abstract

To manage the reliability of an index.SOLUTION: An information processing system comprises: an auxiliary storage device 1300 serving as a storage unit for storing a data set 400 that is related to calculation of a predetermined index, and formed by storing, in association with one another, data of an input value necessary for computing the predetermined index, at least one structure of an expression for computing the predetermined index, and data of an output value which is a computing result of the predetermined index; and a CPU 1100 serving as a processing unit capable of outputting, on the basis of the data set, information related to the input value, the expression, or the output value, which are each associated with the predetermined index.SELECTED DRAWING: Figure 2

Description

Technical Field

[0001] The present invention relates to an information processing system and an index calculation method.

Background Art

[0002] As a technology for efficiently managing data, there is a technology described in Japanese Patent Application Laid-Open No. 2023-57944 (Patent Document 1). This publication states that "an information processing apparatus, an information processing method, and an information processing program for realizing simplification of input work in creating documents or application forms, etc., are provided."; "In the low-code development web server apparatus 2, the action setting unit 28 sets a storage area definition indicating a storage area to be stored among the areas in the display screen, and the control setting unit 24 sets a control definition indicating at least a display item or an operation button to be arranged in the storage area set by the storage area setting unit. The dynamic restoration target setting unit 26 sets, as a dynamic restoration target control definition, a control among the controls that dynamically updates and displays a value at the time of the next screen display, and the storage control unit 27 associates the storage area definition, the control definition, and the dynamic restoration target control definition as child elements of the storage area definition, hierarchizes the storage area definition, the control definition, and the dynamic restoration target control definition, and stores them in the storage unit."

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] There are cases where calculations are performed using the input data to calculate the target value. In such cases, it has been difficult to verify the calculated value. For example, when using a certain data calculated from a plurality of data, it is difficult to confirm how the value was calculated. However, when calculating management indicators or greenhouse gas (GHG) emission indicators, there may be multiple calculation methods for the same indicator. For example, if the types and quantities of the data used as the basis are sufficient, the value of the indicator can be calculated accurately. However, even if the types and quantities of the data used as the basis are sufficient, the value of the indicator can be obtained as an approximate value with a certain degree of accuracy. Also, even for the same indicator, the regulations required for the calculation method may differ depending on the use destination. Thus, even for the same indicator, the value may differ depending on the calculation process, and the reliability may also differ. Therefore, it is required to be able to verify by tracing back the calculation process of the indicator, that is, to manage the reliability of the indicator by realizing traceability for the calculation process of the indicator. Patent Document 1 does not consider the above problems.

[0005] Therefore, an object of the present invention is to manage the reliability of an indicator.

Means for Solving the Problems

[0006] In order to achieve the above object, one of the representative information processing systems of the present invention includes a data set related to the calculation of a predetermined indicator, the data of the input value necessary for calculating the predetermined indicator, the structure of at least one or more formulas for performing the calculation of the predetermined indicator, and a storage unit that stores the data set in which the data of the output value that is the calculation result of the predetermined indicator is associated, and a processing unit that can output information related to the input value, the formula, or the output value related to the predetermined indicator based on the data set. Also, one of the representative index calculation methods of the present invention is that an information processing system refers to a data set related to the calculation of a predetermined index, which is associated with data of input values necessary for calculating the predetermined index, the structure of at least one or more formulas for performing the calculation of the predetermined index, and data of output values that are the calculation results of the predetermined index, and includes the steps of obtaining the input values, executing the processing shown in the formula, using the intermediate results and / or the final results of the execution of the processing as output values, and associating and storing the acquisition results of the input values, the execution results of the processing, and the output values as the intermediate results and / or the final results.

Advantages of the Invention

[0007] According to the present invention, the reliability of the index can be managed. Problems, configurations, and effects other than those described above will be clarified by the description of the following embodiments.

Brief Description of the Drawings

[0008]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Figure 18

Figure 19

Figure 20

Figure 21

Figure 22

Figure 23

Figure 24

Figure 25

Mode for Carrying Out the Invention

[0009] Hereinafter, embodiments will be described with reference to the drawings.

Embodiment

[0010] FIG. 1 is an explanatory diagram of the information processing system according to Embodiment 1. The information processing system 500 is a system that calculates indexes. The information processing system 500 uses the dataset 400a when calculating indexes.

[0011] The dataset 400a is a dataset related to the calculation of an index, which associates the data of the input values necessary for calculating the index, the structure of at least one or more formulas for performing the calculation of the index, and the data of the output value that is the calculation result of the index. As an example, the dataset 400a designates three data items A1 to A3 as inputs. Also, the dataset designates B1 and B2 in the formula structure. B1 is a function of inputs A1 and A2. B2 is a function of B1 and A3. Further, the dataset 400a designates using B2 for output C1. This C1 becomes the value of the index obtained using the dataset 400a.

[0012] The information processing system 500 calculates an index based on the dataset 400a. Specifically, the information processing system 500 acquires inputs A1 to A3 from the database 800, calculates according to the formulas B1 to B2, and obtains C1. The information processing system 500 manages by associating the values of inputs A1 to A2, the formulas B1 to B3, and the value of output C1. That is, the information processing system 500 can output the calculation result as a dataset 400b with values added to the dataset 400a. In this way, the information processing system 500 not only outputs only the calculation result of the index, but also manages by associating the input values and formulas used in the calculation of the index and can output them together with the calculation result of the index. For this reason, traceability can be realized for the index calculation process, the index can be verified, and reliability can be managed. In other words, the information processing system 500 can support data traceability. Here, it is desirable that the inputs, formulas, and outputs in the dataset 400a and the dataset 400b be described in a form that can be easily read by humans. This is because it is assumed that humans will directly read them during verification. In this embodiment, it is assumed that the formulas are described in infix notation. Also, it is preferable to impose restrictions on the input values to maintain reproducibility. For example, if the latest value is set to be used as the input value, it becomes difficult to confirm which data point was used when verifying later. Therefore, it is preferable to set the type of input value so that reproduction and verification are easy, such as by specifying a time.

[0013] FIG. 2 is a configuration diagram of an information processing system 500. The information processing system 500 is communicatively connected to a user terminal 600 and can transmit and receive communication packets 700 with the user terminal 600. The user terminal 600 has a user instruction input function 610. The user instruction input function 610 receives a user operation and transmits an instruction indicated by the operation to the information processing system 500. The instructions include storage of the data set 400 related to the calculation of the index, execution of the index calculation, output of the calculation result and intermediate progress, etc.

[0014] The information processing system 500 has a data set 400 related to the calculation of an index, a data set 440 for existing system API (Application Programming Interface) cooperation, a function 100 for converting to calculation processing based on a mathematical formula, an input value state management function 200, an expression executable state management function 210, an output state management function 220, a DBMS (database management system) 230, and a usage management function 300.

[0015] The data set 400 related to the calculation of the index includes input information 410 which is information related to the input, formula information 420 which is information related to the formula, and output information 430 which is information related to the output, as already described.

[0016] The data set 440 for existing system API cooperation has correspondence information 441 from information search parameters to input information and data structure correspondence information 442 for the output information and the cooperation API. The correspondence information 441 from the information search parameter to the input information is data indicating the correspondence relationship between the identification information of the data that can be obtained from the outside and the identification information that uniquely identifies the data within the dataset 400. The data that can be obtained from the outside is, for example, the data that can be obtained from the database 800. The data structure correspondence information 442 for cooperation with the output information is data indicating the correspondence relationship between the identification information that uniquely identifies the data within the dataset 400 and the data format used by the output destination of the index.

[0017] The function 100 for converting to calculation processing based on a mathematical formula is a function for converting the formula information 420 into a notation suitable for processing by a program. For example, it performs a process of converting the formula information 420 described in infix notation into reverse Polish notation. The input value status management function 200 manages, for each input value indicated by the input information 410 of the dataset 400, whether it is in a state that can be obtained from the database 800. Also, when calculating an index in a certain way, the input value status management function 200 can calculate the ratio of how much of the input value is obtainable as the achievement ratio.

[0018] The formula executable state management function 210 manages, for each formula indicated by the formula information 420 of the dataset 400, whether it is in a state where calculation can be executed. Also, the formula executable state management function 210 can calculate the ratio of how many of the multiple formulas included in the dataset are computable as the achievement ratio.

[0019] The output state management function 220 is a function that executes the calculation of the formula and manages the state regarding the final output and intermediate output. The final output is the output of the index indicated by the output information 430 of the dataset 400. The intermediate output is the output of the obtained input value, the progress of the calculation, etc. The output state management function 220 can calculate the ratio of how much of the final output and intermediate output is outputtable as the achievement ratio. The DBMS 230 is software that manages access to the database 800.

[0020] The utilization management function 300 is a function related to the utilization of metrics calculated based on the dataset 400. The utilization management function 300 has an input / expression / output snapshot storage function 310 and a utilization status statistics / monetization information calculation function 320. The input / expression / output snapshot storage function 310 is a function that associates and stores the values obtained for the input, the calculation results of the expressions, the values of the output metrics, and the intermediate progress with the dataset 400. This snapshot corresponds to the dataset 400b in FIG. 1. The utilization status statistics / monetization information calculation function 320 is a function that manages the utilization performance of the values of the output metrics and the snapshots, and calculates the value of the output metrics and the snapshots based on the utilization performance.

[0021] FIG. 3 is a configuration diagram of a computer operable as the information processing system 500. The computer 1000 has a CPU (Central Processing Unit) 1100, a memory 1200, an auxiliary storage device 1300, a communication device 1400, an input device 1500, and an output device 1600.

[0022] The CPU 1100 operates the computer 1000 as the information processing system 500 by expanding and executing a program in the memory which is the main storage device. Also, the CPU 1100 operates as processing for realizing a function 100 that converts into calculation processing based on mathematical formulas, an input value status management function 200, an expression executable status management function 210, an output status management function 220, a DBMS 230, and a utilization management function 300.

[0023] The auxiliary storage device 1300 is, for example, a hard disk drive. The auxiliary storage device 1300 stores the dataset 400 and the dataset 440. Also, the auxiliary storage device 1300 can store the snapshots acquired by the utilization management function 300 and any other data.

[0024] The communication device 1400 is a communication interface for communicating with the user terminal 600 and the database 800. The input device 1500 is a keyboard or a pointing device. The output device 1600 is a display or the like.

[0025] Figure 4 is a specific example of the data stored in the database 800. The database 800 stores, as master data, company information 810, product names 811, production facilities 812, factory structures 813, unit systems 814, raw material / component / work-in-process names 815, business names 816, etc. These master data manage the identification of the target itself and the associated information. The interrelationships between the data are managed in a parent-child relationship or a From-To relationship. For example, the product structure can be shown in a parent-child relationship with the product name 811 as the parent and the raw material / component / work-in-process name 815 as the child. Also, in a From-To relationship, the energy flow, manufacturing process flow, business procedure flow, etc. can be shown. Also, the annual unit constant definition can be shown in a group relationship.

[0026] The database 800 stores, as performance data, energy prices 817, order information 818 as an event, order information 819 as time-series cycle information, energy performance 820 as a time series, etc. These performance data are accumulated as time-stamped events or cycle data. For example, the order information 818 is data that manages orders that occurred during a certain period as individual events, and the order information 819 is data that manages the cumulative transition of orders for each period. These performance data can be compared with statistical prediction data or simulation prediction data. For example, a production plan can be formulated as a schedule based on the orders that occurred. From the order information 819, which is performance data, future orders can be predicted, and production can be predicted from the predicted orders. Also, from the energy performance 820, which is performance data, future fluctuations in energy performance can be predicted. And the various predicted data can be compared with the data obtained as actual results later.

[0027] FIG. 5 is an explanatory diagram of data input / output. The data input / output is performed according to the following procedures (1) to (3). (1) The input value state management function 200 of the information processing system 400 uses the "list of identifiers having the amount of information to narrow down", the "corresponding information 441 from the information search parameter to the input information", and the "narrowing condition using the data search query + value aware of the address of the data table" to send an instruction to the DBMS 441 to obtain the target input value. (2) The DBMS 230 converts the obtained information using the "corresponding information 441 from the information search parameter to the input information" and the "narrowing condition using the data search query + value aware of the address of the data table", and the input value state management function 200 receives it as the "result list". (3) The output state management function 220 uses the "list of the amount of information to narrow down the output destination", the "corresponding information 442 for the data structure corresponding to the output information and the cooperation API", and the "narrowing condition using the data search query + value aware of the address of the data table" to send an instruction to the DBMS 230 to store the target output value in the database 800. In this way, the DBMS 230 obtains and stores information from the database 800 based on the instructions from the input value state management function 200 and the output state management function 220.

[0028] The corresponding information 441 and the corresponding information 442 of the information processing system 500 indicate the correspondence between the identification information of the data in the database 800 and the identification information that uniquely identifies the data within the data set 400. By referring to the corresponding information 441 or the corresponding information 442, the information processing system 500 can convert the name of the data used by the data set 400 into the identification information of the data used by the database 800. The identification information of the data used by the database 800 corresponds to the address of the data table. Therefore, the DBMS can access the data in the database 800 using the narrowing condition using the "data search query + value aware of the address of the data table". The names of the data used by the dataset 400 can be used as "a list of identifiers having the amount of information for narrowing down information" and "a list of the amount of information for narrowing down the output destination", and are stored in the auxiliary storage device 1300.

[0029] Conventional relational databases associate data by relation (table address). In this configuration, data is acquired on the premise that the system design is known. Therefore, when the correspondence between data is undetermined or changed, the data cannot be acquired, and flexible design changes cannot be accommodated. On the other hand, in the system disclosed in the embodiment, reserved words that can specify the type of data managed in the database as the only meaning are managed, and by combining them, the uniqueness of the meaning and data source for the data of the entire dataset can be ensured.

[0030] Figure 6 is a specific example of a dataset. The dataset 400 shown in Figure 6 is an example of a dataset for calculating business indicators. The dataset 400 shown in Figure 6 designates "sales forecast" and "total variable costs" as input values. Also, as output values, "variable cost ratio" and "break-even sales" are designated. Among the contents of the processing performed using the input values, "total variable costs / sales forecast" is designated as the formula for calculating the "variable cost ratio", and "total fixed costs / (1 - variable cost ratio)" or "total fixed costs / profit margin" is designated as the formula for calculating the "break-even sales".

[0031] As shown in Figure 6, the dataset 400 indicates the type of input value data, the content of the processing performed using the input value, and the type of output value data. When the information processing system 500 obtains data of the type designated as the input value, it executes processing using the data to obtain the output value. In addition, the information processing system 500 manages by associating the value of the data used as the input value, the content of the executed processing, and the value of the output value obtained as the execution result of the processing.

[0032] Here, in the dataset 400 of FIG. 6, for the input value, output value, and formula, one line is allocated for each type of data. Therefore, it is easy for humans to directly read the dataset 400. Also, when the data specified as the input value is obtained, the "status" included in the row of that input value is set to "FIX", and the value used as the input value is held as "value". Similarly, the rows of the formula and output can also have "status" and "value". In this way, the dataset 400 can store the processing result and the progress of the process inside. The dataset 400 storing the processing result and progress is managed separately from the original dataset 400 as a snapshot.

[0033] Also, as the input value, the calculation result of the formula can be used. Among the input values, the input value obtained from the outside is called primary data. Also, the input value obtained from the primary data is called secondary data. Note that not only the secondary data directly obtained from the primary data, but also the data obtained from the secondary data is considered a type of secondary data because it is indirectly obtained from the primary data. Also, as the output value, it may include data of the same type but different from at least one of the input value and the formula. In FIG. 6, for the "breakeven point sales", there are two rows with different calculation formulas.

[0034] An electronic signature may be generated from the dataset 400 storing the processing result and progress, and attached to the dataset 400. In FIG. 6, the body is electronically signed, and a signature hash, which is a verifiable code, is embedded in the header. Also, as information, which item corresponds to which regulation and which item is primary data are embedded in the body.

[0035] FIG. 7 is a flowchart showing the processing procedure of the information processing system. The information processing system 500 sequentially executes the following steps S101 to S108. Step S101 The information processing system 500 reads the correspondence information 441 from the input information in the information search parameter, and executes a process of reading the data that can be obtained from the database 800 into the data of the identification information used in the data set 400. Then, it proceeds to step S102. Step S102 The information processing system 500 reads the data set 400. Then, it proceeds to step S103. Step S103 The information processing system 500 performs a process by the input value state management function 200. By this process, it is determined whether all the input information, which is the data used as the input value, is complete. Then, it proceeds to step S104.

[0036] Step S104 The information processing system 500 determines whether all the input information is satisfied. If all are satisfied (step S104; Yes), it proceeds to step S106. If there is input information that is not satisfied (step S104; No), it proceeds to step S105. Step S105 The information processing system 500 sets the input information that is not satisfied as the insufficient item, outputs the ratio of the insufficient item to the whole input information as the insufficient ratio, and ends the process. Step S106 The information processing system 500 activates the formula executable state management function 210 and proceeds to step S107.

[0037] Step S107 The information processing system 500 executes a process of checking the status of the input and the intermediate result by the formula executable state management function 210. Then, it proceeds to step S108. Step S108 The information processing system 500 interprets the formula by the function 100 that converts it into a calculation process based on the formula, and proceeds to step S109. Step S109 The information processing system 500 performs calculations by the output state management function 220 and writes to the calculation and output information 430. The written output information 430 may be used as input as secondary data. Therefore, steps S107 to S109 are repeated until all the output information that can be calculated from the obtained input information is written. Then, it proceeds to step S110.

[0038] Step S110 The information processing system 500 reads and executes the correspondence information 442. As a result, the output value is output as data in a format that conforms to the output destination. Then, it proceeds to step S111. Step S111 The information processing system 500 executes the input·formula·output snapshot saving function 310. As a result, data associating the used input value, the processing content and result of the formula, and the calculated output value is accumulated as a snapshot.

[0039] In FIG. 7, the calculation is started when all the input information is satisfied, but when some input information is obtained, the calculation may be configured to start within the range that can be calculated from the obtained input information. In this case, the progress of the calculation can be output together with the missing items and the missing ratio.

[0040] In FIG. 7, the process of executing the calculation using the data managed by the database 800 is shown. Thereafter, when the same type of data is required, the process of FIG. 7 may be executed again, but it is also possible to refer to and reuse the existing calculation results. In this way, by reusing the existing calculation results, the value of the existing calculation results can be enhanced.

[0041] FIGS. 8 and 9 are explanatory diagrams of the process when reusing the existing calculation results. In the process of FIG. 8, the user terminal 600 and the information processing system 500 sequentially execute the following steps S201 to S204. Step S201 The user terminal 600 obtains the identification of the output desired from the user instruction input function 610. Then, it proceeds to step S202. Step S202 The input / expression / output snapshot storage function 310 of the information processing system 500 searches for the past calculation history. Then, it proceeds to step S203. Step S203 The information processing system 500 creates the result as a communication packet 700 and transmits it to the user terminal 600. Then, it proceeds to step S204. Step S204 The information processing system 500 causes the user terminal 600 to display the ranking of the data used as the reference destination.

[0042] In the process of FIG. 9, the user terminal 600 and the information processing system 500 sequentially execute the following steps S301 to S305. Step S301 The user terminal 600 obtains the identification of the output desired from the user instruction input function 610. Then, it proceeds to step S302. Step S302 The input / expression / output snapshot storage function 310 of the information processing system 500 searches for the past calculation history. Then, it proceeds to step S303. Step S303 The information processing system 500 creates the result as a communication packet 700 and transmits it to the user terminal 600. Then, it proceeds to step S304. Step S304 The user terminal 600 receives, by the user instruction input function 610, the information selected for the data in which the desired output is the same and at least one of the input and the calculation formula is different. Then, it proceeds to step S305. Step S305 The usage status statistics / monetization information calculation function 320 of the information processing system 500 outputs the information to the database 800 and ends the process.

[0043] Hereinafter, a use case will be described in which a data input screen is automatically generated from the data set 400 related to the calculation of an index, items whose status is converted from "default value" to "already described" are detected, and an evaluation is returned to the user.

[0044] FIG. 10 is a specific example of a data input screen. The user instruction input function 610 of the user terminal 600 reads the data set 400 related to the calculation of the index and generates a data input screen from the data set 400. For example, an input field is generated for the input value included in the data set 400. This input field may be able to accept text input or may be a pull-down menu. Similarly, the user instruction input function 610 can display expressions and outputs and accept changes and the like. A default value is displayed in each input field and can be changed by the user's designation.

[0045] The input values for index calculation are not necessarily only the information at hand. At that time, if the field is left blank or filled with zeros, in some cases, the index calculation may cause an error. Therefore, in this system, an input screen reflecting the default value is generated so that the information to be input can be increased while confirming which items need to be improved to change the index.

[0046] FIG. 11 is a flowchart of input control. The user terminal 600 sequentially executes the following steps S401 to S404. Step S401 The user instruction input function 610 obtains the identification information of the output to be obtained. Then, it proceeds to step S402. Step S402 The user instruction input function 610 receives the default value from the information processing system 500. Then, it proceeds to step S403. Step S403 The user instruction input function 610 accepts the input from the user and changes the default value to the input value. Then, it proceeds to step S404. Step S404 The user terminal 600 sends back to the information processing system 500 the values of the items changed within the range understandable by the user and the data in which the status of the items has been changed from the default value to the entered state, and ends the process.

[0047] FIG. 12 is a specific example of the display of input values. The information processing system 500 sets stages according to the number of required input values for different calculation methods for obtaining the same index, obtains the index by a calculation method that satisfies the input values required at the current time, and can provide information on the input values required for the calculation method of the next stage. FIG. 12 is an example of calculating the index of GX (green transformation). Maturity level 1 corresponds to a method of obtaining the GX index with relatively few inputs. Maturity level 2 corresponds to a method of obtaining the GX index using more inputs than maturity level 1. It is assumed that as the maturity level increases, the required inputs increase and the accuracy of the obtained index increases, and it is required to appropriately increase the maturity level.

[0048] In FIG. 12, all the inputs required for calculating the GX index at maturity level 1 have been obtained, and the GX index achievement rate at maturity level 1 is 100%. For maturity level 2, which is the next stage, the inputs are insufficient, and the GX index achievement rate at maturity level 2 is 62%. As shown in the process of FIG. 11, since the status for the item for which the input has been implemented is changed from the "default value" to the "entered state", the ratio of the inputs achieved can be calculated by taking the total number of inputs for the index calculation as the denominator and the number of items whose status has changed to "entered" as the numerator.

[0049] Hereinafter, a process will be described in which a plurality of calculations for the same index are selected and the difference is displayed. In particular, elements that can be displayed in time series will be described. Figure 13 is an explanatory diagram regarding the comparison of the same index. For the same output information, for example, by calculating using different times, different inputs, and different formula information, different values of the same index can be obtained. Figure 13 shows an example of a screen that displays and compares these multiple values in chronological order. Note that for each of the multiple indices, it is possible to obtain different values for time, input, formula information, etc.

[0050] The GX index may have different formulas and their inputs for the same output information due to changes in regulations, etc., or the policies of each group. Therefore, it is required to search for past evidence information from the output information 430, plot multiple data for comparison, and display the differences. In addition, a function to display a snapshot showing the breakdown of the selected output by selecting the output information, and a function to extract and display to the user the differences in inputs and formulas between the selected outputs by selecting the outputs to be compared can be provided.

[0051] Figure 14 is a flowchart showing the comparison process of the same index. The comparison process of the same index includes the following steps S501 to S504. Step S501 The user instruction input function 610 of the user terminal 600 receives the input of the identification information of the output to be compared. Then, it proceeds to step S502. Step S502 The user instruction input function 610 sends the identification information of the output to be compared to the information processing system 500. Then, it proceeds to step S503. Step S503 The user terminal 600 selects the data to be compared in chronological order from the information of the data set related to the calculation of the index. Then, it proceeds to step S504. Step S504 When it can be displayed in chronological order, the user terminal 600 separately identifies and displays on the screen the information calculated by different inputs and formulas to be compared, and ends the process.

[0052] Hereinafter, the process of selecting multiple indices and displaying them in a series will be described. Figure 15 is a specific example of the display of a plurality of indicators. Since the GX indicator is evaluated by indicators from multiple perspectives, it is necessary to overview the comprehensive results of various indicators. In Figure 15, by plotting various indicators on a radar chart, a plurality of indicators can be confirmed. In Figure 15, Input 1 to 4 and Output 1 to 3 are shown as the axes of the radar chart. Also, two patterns of input, output, etc. are displayed with solid lines and dashed lines to make them comparable. By comparing the pattern shown with a solid line and the pattern shown with a dashed line, it can be read that Input 4 is different and the difference in Input 4 has affected Output 1 and Output 3.

[0053] Figure 16 is a flowchart showing the processing procedure of the display processing of a plurality of indicators. The display processing of a plurality of indicators includes the following steps S601 to S603. Step S601 The user instruction input function 610 of the user terminal 600 receives the input of the identification information of a plurality of outputs to be compared. Then, it proceeds to step S602. Step S602 The user instruction input function 610 sends the identification information of the output to be compared to the information processing system 500. Then, it proceeds to step S603. Step S603 The user terminal 600 displays the data to be compared on a radar chart from the information of the data set related to the calculation of the indicators, and ends the processing. In Figures 15 and 16, a radar chart is exemplified, but various indicators such as a pie chart can be compared and displayed in an arbitrary form.

[0054] Hereinafter, the display of information having a structure will be described. Figure 17 is an explanatory diagram of the display of company information. Since companies repeat mergers, company name changes, splits, etc., it is necessary to display and confirm the data having a From-To relationship in the company information. In the display example of FIG. 17, initially there were Company A, Company B, and Company C. Then, Company B was merged into Company A, Company C changed its company name to Company D, Company A changed its company name to Company E, and Company E was merged into Company D, which is shown.

[0055] FIG. 18 is a flowchart showing the procedure of the structure display process. The structure display process includes the following steps S701 to S703. Step S701 The user instruction input function 610 of the user terminal 600 receives the selection of the structure to be displayed and its data. Then, it proceeds to step S702. Step S702 The user instruction input function 610 sends the structure of interest and its data identifier information to the information processing system 500. Then, it proceeds to step S703. Step S703 The user terminal 600 displays the structure of the information based on the information received from the information processing system 500 and ends the process.

[0056] FIG. 19 is an explanatory diagram of data tracing. The information processing system 500 can recognize and identify output information and input information by their identification names. Therefore, one data set can be specified, and the preceding and subsequent data processing related to it can be displayed. For example, when the identification names of output information and input information are hierarchically structured, tracing is possible by following the hierarchical structure. In FIG. 19, it shows that it is possible to trace the data source side (upstream side) and the affected destination side (downstream side) based on the selected data set.

[0057] FIG. 20 is a flowchart showing the procedure of the data trace display process. The data trace display process includes the following steps S801 to S803. Step S801 The user instruction input function 610 of the user terminal 600 receives the specification of the data set to be displayed and an instruction to display the traceability structure. Then, it proceeds to step S802. Step S802 The user instruction input function 610 sends the data set identifier and the instruction information for the traceability structure display to the information processing system 500. Then, it proceeds to step S703. Step S803 The user terminal 600 receives the traceability result from the information processing system 500, displays the structure, and ends the process.

[0058] FIG. 21 is an explanatory diagram for the case of tracing the energy flow. In this case, the user terminal 600 refers to the energy performance and the From-To relationship of the energy flow, and displays the structure of how the combined substation power is supplied from the energy source to the energy consumption side.

[0059] FIG. 22 is an explanatory diagram for the display of the usage status statistics of the data set. In FIG. 22, the usage status statistics and monetization information calculation function 320 graphically displays which data sets are referenced how much for the CO2 aggregated value. Specifically, the CO2 aggregated value of Plant A in 2023 is the most referenced, followed by the CO2 aggregated value of Plant A in 2022, and then the CO2 aggregated value of Plant B in 2022. In this way, by taking the statistics of the reference frequency for the same indicator with different years and locations, the value of each data set can be evaluated.

[0060] FIG. 23 is an explanatory diagram of an example of calculating and displaying the monetization per-unit information from the usage amount of the data set. In FIG. 23, the usage status statistics and monetization information calculation function 320 takes the statistics of how much reference there has been for various data in terms of the data volume. By taking the statistics of the reference amount of each data in this way, the importance of each data type can be evaluated. Here, the usage amount is exemplified, but it is possible to evaluate the importance of each data type using any value such as the accumulation amount of data as an indicator.

[0061] Next, the GX index will be described. In recent years, promoting energy conservation has become an important issue. In order to promote energy conservation, for example, obligations such as "If the unit consumption in the past five years cannot be improved by an average of 1% per year, or if the unit consumption cannot be improved compared to the previous year, report including the reasons." may be imposed on enterprises.

[0062] The energy consumption per unit is used as an index for rationalizing energy use. The energy consumption per unit of a factory (hereinafter abbreviated as "factory energy unit") represents the amount of energy (input to the factory) used to produce a unit quantity of products (output of the factory). Also, the production volume is considered to be proportional to the amount of energy effectively used for product production in the production process. The energy unit can also be interpreted as a quantity proportional to the reciprocal of the "energy efficiency of the factory". Therefore, if the factory energy unit decreases, it means that the energy efficiency of the factory has increased.

[0063] The energy consumption per unit used as an index of the "energy rationalization judgment criteria" can be obtained by the following formula.

Number

[0064] The "production quantity, etc." in the denominator of the formula is defined as "the production quantity, or the gross floor area of the building, or other values closely related to the energy usage". That is, there is room for discretion in the calculation method of the denominator. Enterprises that do not want the production quantity to leak outside may consider calculating it using other gross floor areas, etc. Also, since the gross floor area is, for example, information related to collateral when obtaining equipment financing, there is a possibility that even bank staff can calculate it. That is, situations may occur where bank staff calculate from the gross floor area and the enterprise's power department calculates from the actual measured production quantity for comparison. Thus, even for the same index, it may be calculated based on different input values. The disclosed system enables accurate comparison of the index by managing data traceability and definitions.

[0065] The "energy consumption" in the numerator of the formula is the amount of energy consumed by the factory. When using multiple types of energy such as electricity and fuel, the units must be unified when summing them up. As one of the guidelines, the value obtained by converting the energy consumption into the amount of primary energy (calorific value and crude oil conversion value) is used.

[0066] Primary energy refers to resources that produce energy (such as crude oil, coal, natural gas, etc.). Secondary energy refers to energy in the form of petroleum products (such as gasoline, kerosene, heavy oil, etc.), city gas, electricity, heat, etc. used by energy consumers such as factories and households. Secondary energy is also called final energy. Secondary energy is what results from changing the form of primary energy in the power generation and conversion departments (power plants, oil refineries, etc.) so that it is convenient for consumers to use. In the process of converting energy, power generation and transmission losses occur in the power system, and refining losses occur in the fuel system. Thus, in the process of calculating the indicators, various conversion values are used, making the calculation complicated.

[0067] The granularity of the calculation of the unit consumption is also multi-level and complex. When comparing, evaluating, or considering improvement measures for each output value, it is desirable to be able to determine how each output was produced by what formula and input. The disclosed system can evaluate, as a set, on what basis each value was calculated.

[0068] Here, the calculation of the energy unit consumption considering the inclusion structure of the factory will be explained. The energy usage situation can be not only managed for the entire factory, but also aggregated and managed monthly for the unit consumption by product type, department, process, equipment, and lot. It is desirable to break down and manage the improvement of the unit consumption by department, process, and finally by major equipment. The factory unit consumption, department unit consumption, process unit consumption, and equipment unit consumption are obtained as follows.

Number

Number

Number

Number

[0069] As a specific example, the calculation of the energy consumption per unit of pump equipment and boilers will be described. The energy consumption per unit of the cooling water pump attached to the production equipment is as follows. The numerator is the pump power consumption, and the denominator is the production volume of the production equipment to which the pump is sending cooling water (= related production volume).

Number

Number

[0070] The energy consumption per unit focusing on the fuel of the boiler equipment is as follows. The denominator is the production volume of the production equipment to which the boiler is sending steam (= related production volume). The numerator is the boiler fuel consumption. (Since only the fuel is regarded as energy, its consumption does not need to be converted into crude oil.)

Number

Number

[0071] Figure 24 is a specific example of a dataset related to calculating the boiler equipment unit cost. Figure 24 corresponds to the above formula and shows two patterns of datasets for calculating the boiler equipment unit cost. One dataset does not use the steam amount, applies the floor area to the production quantity, 'Boiler fuel usage amount' / 'Production quantity related to boiler equipment' to calculate the boiler equipment unit cost. The other dataset has a higher maturity level, uses the steam amount, ('Steam amount' / 'Production quantity related to boiler equipment') * ('Boiler fuel usage amount' / 'Steam amount') to calculate the boiler equipment unit cost.

[0072] Next, the management indicators and environmental indicators will be described. The net profit and ROE (Return On Equity), which are management indicators, are obtained as follows. Net profit = Sales - Manufacturing cost - Selling and administrative expenses + Non-operating income and expenses + Special income and expenses - Corporate tax, etc. ROE = Net profit / Shareholders' equity Net profit is used for the calculation of ROE. Thus, the indicators are multi-level, and net profit can be interpreted as an intermediate output.

[0073] As an environmental indicator, the GHG emissions are exemplified. Here, assume an operator in the manufacturing industry that manufactures gelamine using the same products throughout the year, for example, products made of aluminum + copper + magnesium as raw materials. The production quantity is obtained as follows. Production quantity = Ending inventory quantity - Beginning inventory quantity + Sales quantity = Ending inventory quantity - Beginning inventory quantity + Sales / Average unit price of products Assuming that the component composition of the product is (Al:Cu:Mg) = (a:b:c), the GHG emissions (Scope 1), which are the emissions of greenhouse gases directly emitted by the operator in fuel use and industrial processes, are (Usage amount of Al * Emission rate per unit + Usage amount of Cu * Emission rate per unit) × Production quantity =(Usage amount of Al * 1.49 + Usage amount of Cu * 4.49) × Production quantity obtained as such.

[0074] Here, the production quantity can be estimated from sales and the average unit price of products as described above. Therefore, for products with known material composition and component composition, even if the operator does not directly disclose the production quantity, the GHG emissions (Scope 1) can be calculated from the information disclosed to investors, etc.

[0075] The material composition and component composition correspond to the product structure shown in Figure 4. In the case of gelamine, a parent-child relationship with gelamine as the parent and aluminum, copper, and magnesium as the children is registered in the product structure. In addition, the relationship between the product name and product identification information, and the general name and chemical formula is managed in the product name master data in Figure 4. The output status management function 220 has functions of "function to import product name master data and product structure information", "function to formulate the parent-child relationship", and "function to insert GX parameters", and calculates the GX index by these functions.

[0076] Figure 25 is a flowchart of the GX index calculation process. The GX index calculation process includes the following steps S901 to S903. Step S901 The output status management function 220 of the information processing system 500 acquires the product name and product structure by the "function to import product name master data and product structure information", and separates the hierarchies corresponding to input, formula, and output. Then, it proceeds to step S902. Step S902 The output status management function 220 generates a formula by associating the separated hierarchies with the right side (Output) of the formula and each term on the left side by the "function to formulate the parent-child relationship". Then, it proceeds to step S903. Step S903 The output status management function 220 acquires the information available for the input value by the "function to insert GX parameters", and executes the formula processing. Then, the process ends. The information available for the input value is not limited to the information managed by the operator, but also includes the substance names and their multipliers defined by regulations.

[0077] In this way, the information processing system 500 can acquire information in cooperation with the information of a predetermined department such as the financial statements for investors and the product structure. As a result, in addition to automatically creating the necessary item and formula data from the product structure, the formulas and items created there can be traced, so it becomes easier to understand the basis of the index value later.

[0078] In addition, each term of the formula expansion can be expanded at each level such as by department, process, and equipment. Therefore, the input achievement degree at each level can be managed, and appropriate display output and the like are also possible. Also, even if the names of the indicators as outputs are the same, it is possible to identify and visualize that the formulas for calculation and the calculation of the values of each item in the formula are different. For example, it is possible to display whether a standard value is used for a certain value or whether it is cited from the data of a certain department in actuality.

[0079] As described above, the disclosed information processing system is a data set 400 related to the calculation of a predetermined indicator, and includes data of input values necessary for calculating the predetermined indicator, a structure of at least one or more formulas for calculating the predetermined indicator, and data of output values that are the calculation results of the predetermined indicator. It includes an auxiliary storage device 1300 as a storage unit in which they are stored in association with each other, and a CPU 1100 as a processing unit capable of outputting information related to the input value, the formula, or the output value related to the predetermined indicator based on the data set. With this configuration and operation, it is possible to verify by tracing back the calculation process of the indicator, that is, by realizing traceability for the calculation process of the indicator, the reliability of the indicator can be managed.

[0080] The data set indicates the type of the data of the input value, the content of the process performed using the input value, and the type of the data of the output value. When data of the type specified as the input value is obtained, the processing unit executes the process using the data to obtain the output value, and the processing unit associates and manages the value of the data used as the input value, the content of the executed process, and the value of the output value obtained as the execution result of the process. Therefore, it is possible to verify later the input value and the content of the process used for the calculation of the output value.

[0081] Also, the processing unit performs calculations in which at least one of the value of the data of the input value and the content of the process is different and the type of the data of the output value is the same, thereby obtaining a plurality of calculation results for the same indicator. In addition, the processing unit uses the first calculation result and the second calculation result for the same index, and is capable of displaying and outputting a comparison of the difference between the first calculation result and the second calculation result, and also displays and outputs the input value and / or the content of the process related to the first calculation result and the second calculation result. Therefore, it is possible to compare output values of the same type obtained through different processes.

[0082] In addition, the processing unit generates an electronic signature from a combination of the value of the data used as the input value, the content of the process executed, and the value of the output value obtained as the execution result of the process, and attaches it to the combination. Therefore, it is possible to prevent forgery of the calculation process of the output value.

[0083] In addition, the data set distinguishes, for a plurality of input values, primary data that is an input value acquired from the outside and secondary data that is an input value obtained from the primary data, and the processing unit outputs the ratio of the primary data among the plurality of input values together with the output value. Therefore, the ratio of the primary data can be used as an index for evaluation.

[0084] In addition, for different calculation methods for obtaining the same index, the processing unit sets stages according to the number of input values required, obtains the index by a calculation method that satisfies the input values required at the current time, and provides information on the input values required for the calculation method of the next stage. Therefore, it is possible to support an improvement in the maturity level.

[0085] In addition, the processing unit starts the process when a part of the input value is obtained, manages the progress information of the process, and is capable of outputting an intermediate result of the process. Therefore, it is possible to appropriately check the intermediate progress of the index.

[0086] Further, the processing unit refers to the correspondence relationship between the identification information of the data that can be acquired from the outside and the identification information that uniquely identifies the data within the data set, and converts the data acquired from the outside into the data as the input value of the data set. Also, the processing unit refers to the correspondence relationship between the identification information that uniquely identifies the data within the data set and the data format used by the output destination of the index, and converts the calculation result of the index into the data format of the output destination and outputs it. Therefore, reserved words that can uniquely identify the types of data managed in the database are managed, and by combining them, the uniqueness of the meaning and the data source for the data of the entire data set can be ensured.

[0087] In addition, the processing unit manages the usage record of the calculation result of the index, and evaluates the data set used in the calculation of the index based on the usage record of the index. Therefore, how much the data set is referenced and used can be used as an evaluation index.

[0088] Note that the present invention is not limited to the above-described embodiments, and includes various modifications. For example, the above-described embodiments have been described in detail for easy understanding of the present invention, and are not necessarily limited to those having all the configurations described. Further, not only deletion of such a configuration is possible, but also replacement and addition of the configuration are possible.

Explanation of Signs

[0089] 100: Function for converting to calculation processing based on a mathematical formula, 200: Input value state management function, 210: Formula executable state management function, 220: Output state management function, 230: DBMS, 300: Utilization management function, 400: Data set, 500: Information processing system, 600: User terminal, 800: Database, 1000: Computer, 1100: CPU, 1200: Memory, 1300: Auxiliary storage device, 1400: Communication device, 1500: Input device, 1600: Output device

Claims

1. A data set related to the calculation of a predetermined indicator, comprising data of input values necessary for calculating the predetermined indicator, the structure of at least one or more formulas for performing the calculation of the predetermined indicator, and data of output values that are the calculation results of the predetermined indicator, stored in an associated manner in a storage unit; A processing unit capable of outputting information related to the input value, the formula, or the output value related to the predetermined indicator based on the data set; An information processing system comprising the above.

2. The information processing system according to Claim 1, wherein the data set indicates the type of the data of the input value, the content of the processing performed using the input value, and the type of the data of the output value, and when data of the type specified as the input value is obtained, the processing unit executes the processing using the data to obtain the output value, and the processing unit manages by associating the value of the data used as the input value, the content of the executed processing, and the value of the output value obtained as the execution result of the processing. An information processing system characterized by this.

3. The information processing system according to Claim 2, wherein the processing unit performs calculations with at least one of the value of the data of the input value and the content of the processing being different, and the type of the data of the output value being the same, to obtain a plurality of calculation results for the same indicator. An information processing system characterized by this.

4. The information processing system according to Claim 3, wherein the processing unit uses a first calculation result and a second calculation result for the same indicator, comparably displays and outputs the difference between the first calculation result and the second calculation result, and displays and outputs the input value and / or the content of the processing related to the first calculation result and the second calculation result. An information processing system characterized by this.

5. The information processing system according to Claim 2, wherein the processing unit generates an electronic signature from a combination of the value of the data used as the input value, the content of the executed processing, and the value of the output value obtained as the execution result of the processing, and assigns it to the combination. An information processing system characterized by this.

6. The information processing system according to Claim 1, wherein the data set distinguishes, for a plurality of input values, primary data that is an input value acquired from the outside and secondary data that is an input value obtained from the primary data. The information processing system is characterized in that the processing unit outputs the ratio of the primary data in the plurality of input values together with the output value.

7. The information processing system according to claim 1, wherein the processing unit sets stages according to the number of input values required for different calculation methods for obtaining the same index, obtains the index by a calculation method that satisfies the input values required at the current time, and provides information on the input values required for the calculation method of the next stage. The information processing system is characterized by this.

8. The information processing system according to claim 2, wherein the processing unit starts the processing when a part of the input values is obtained, manages the progress information of the processing, and can output the intermediate result of the processing. The information processing system is characterized by this.

9. The information processing system according to claim 1, wherein the processing unit refers to the correspondence relationship between the identification information of the data that can be acquired from the outside and the identification information that uniquely identifies the data within the data set, and converts the data acquired from the outside into data as the input value of the data set. The information processing system is characterized by this.

10. The information processing system according to claim 1, wherein the processing unit refers to the correspondence relationship between the identification information that uniquely identifies the data within the data set and the data format used by the output destination of the index, and converts and outputs the calculation result of the index into the data format of the output destination. The information processing system is characterized by this.

11. The information processing system according to claim 1, wherein the processing unit manages the usage record of the calculation result of the index, and evaluates the data set used for the calculation of the index based on the usage record of the index. The information processing system is characterized by this.

12. An information processing system refers to a data set related to the calculation of a predetermined index, which associates the data of the input values required for calculating the predetermined index, the structure of at least one or more formulas for performing the calculation of the predetermined index, and the data of the output value that is the calculation result of the predetermined index, the step of obtaining the input value, the step of executing the processing shown in the formula, the step of using the intermediate result and / or the final result of the execution of the processing as the output value, the step of associating and storing the acquisition result of the input value, the execution result of the processing, the intermediate result and / or the output value as the final result, An index calculation method characterized by including

Images