JP2022084807A - Calculation processing apparatus, calculation processing method, and calculation processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow for easy settings of a computation expression using a formula.

SOLUTION: A calculation definition master is set which uses an article kind as a key and associates an operator with item classification for use in classifying at least article fluctuation characteristic and an article number fixed characteristic as items. An operator in the calculation definition master and an item identifier corresponding to item classification associated with the operator are coupled to each other in a record of the calculation definition master to generate a character string. The character strings generated in the respective records are coupled with one another in an order of the records to create a formula. A characteristic value corresponding to an input article number is acquired from a characteristic setting master associating an item identifier corresponding to the article number fixed characteristic and a characteristic value corresponding to the item identifier with each other. The acquired characteristic value is used to carry out calculation based on the formula.

SELECTED DRAWING: Figure 2

COPYRIGHT: (C)2022,JPO&INPIT

Description

The present invention relates to a calculation processing device, a calculation processing method, and a calculation processing program.

In Patent Document 1, "On the steel selection screen, the client can select the corresponding steel as long as the client inputs a predetermined condition including the items necessary for steel selection (FIGS. 3, FIG. 4, and Fig. 4). See paragraph "0050"). As for the weight calculation screen, as in the case of steel selection, the weight is calculated by inputting conditions such as size (see Fig. 3, paragraph "0054"). " ing.

JP-A-2002-24562

However, although there is a default formula for weight calculation of steel materials, there is also a complicated formula, and there is a problem that it is necessary to formulate a calculation program for each formula pattern. This also applies to examples other than the weight calculation of steel materials, for example, the volume calculation of wood. In addition, there are cases where the formula is mastered and dealt with, but there is a problem that it is necessary to set the same level as the program creation when mastering, and the difficulty of setting is high.

The present invention has been made in view of the above, and an object of the present invention is to provide a calculation processing device, a calculation processing method, and a calculation processing program capable of easily setting a calculation formula by a formula.

In order to solve the above-mentioned problems and achieve the object, the calculation processing device according to the present invention is a calculation processing device including a control unit and a storage unit, and the control unit uses a product type as a key and an operator. In the calculation definition setting means for setting the calculation definition master in which the calculation definition master associated with at least the product fluctuation characteristic or the product number fixed characteristic which is a characteristic peculiar to the product number is classified as an item, and the calculation definition master. , The operator and the item identifier corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master to create a character string, and each character string created in each record of the calculation definition master is created. , The characteristic set in the storage unit by associating the calculation formula creation means that creates the calculation formula by concatenating according to the record order of the calculation definition master, the item identifier corresponding to the product number specific characteristic, and the characteristic value corresponding to the item identifier. It is characterized by including a calculation processing means for acquiring a characteristic value corresponding to an input product number from a setting master and performing a calculation by a calculation formula using the acquired characteristic value.

Further, in the calculation processing apparatus according to the present invention, the calculation definition setting means includes at least an item classification in which a product variation characteristic, a product number fixed characteristic, or a product fixed characteristic which is a characteristic fixed to a product is input, and an operator. It is characterized in that the calculation definition master associated with is set in the storage unit.

Further, in the calculation processing apparatus according to the present invention, the control unit further includes a screen generation means for generating a screen for displaying the calculation formula created by the calculation formula creation means by using an operator and an item identifier. It is a feature.

Further, in the calculation processing apparatus according to the present invention, the screen generation means replaces the characteristic value corresponding to the input product number acquired from the characteristic setting master with the item identifier corresponding to the characteristic value in the calculation formula. It is characterized by further generating a screen for displaying an expression.

Further, in the calculation processing apparatus according to the present invention, the calculation definition setting means has at least the product fluctuation characteristic, the product number fixed characteristic, and the start position and the end position of the parentheses for designating the range in which the calculation is preferentially executed in the calculation formula. It is characterized in that a calculation definition master associated with an operator and an item classification in which a dummy indicating the above or a dummy indicating that the record is specified only for an operator is input is set in the storage unit.

Further, in the calculation processing apparatus according to the present invention, the calculation definition setting means is at least the product variation characteristic, the product number fixed characteristic, the fixed value used in the formula corresponding to the calculation formula defined in the calculation definition master, and the calculation formula. On the other hand, it is characterized in that a calculation definition master associated with an operator and an item classification in which information for specifying fractional processing or information for specifying multiplier calculation for a calculation formula is input is set in the storage unit. ..

Further, the calculation processing method according to the present invention is a calculation processing method executed by a calculation processing device including a control unit and a storage unit, and is executed by the control unit using a type as a key and an operator. A calculation definition setting step for setting a calculation definition master associated with at least a product variation characteristic or an item category in which a product number fixed characteristic which is a fixed characteristic for a product number is input in a storage unit, and an operator in the calculation definition master. A character string is created by concatenating the item identifier corresponding to the item classification associated with the operator in the record of the calculation definition master, and each character string created in each record of the calculation definition master is used in the calculation definition master. Input from the characteristic setting master set in the storage unit by associating the calculation formula creation step that creates the calculation formula by concatenating according to the record order, the item identifier corresponding to the product number fixed characteristic, and the characteristic value corresponding to the item identifier. It is characterized by including a calculation processing step of acquiring a characteristic value corresponding to the obtained product number and performing a calculation by a calculation formula using the acquired characteristic value.

Further, the calculation processing program according to the present invention is a calculation processing program for being executed by an information processing apparatus including a control unit and a storage unit, and is an operator with a product type as a key for execution by the control unit. A calculation definition setting step for setting a calculation definition master associated with at least a product variation characteristic or an item classification in which a product number fixed characteristic which is a fixed characteristic for a product number is input in a storage unit, and an operator in the calculation definition master. And the item identifier corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master to create a character string, and each character string created in each record of the calculation definition master is calculated and defined. From the calculation formula creation step that concatenates and creates the calculation formula according to the record order of the master, and the characteristic setting master that is set in the storage unit by associating the item identifier corresponding to the product number fixed characteristic and the characteristic value corresponding to the item identifier. It is characterized by including a calculation processing step of acquiring a characteristic value corresponding to an input product number and performing a calculation by a calculation formula using the acquired characteristic value.

According to the present invention, there is an effect that a formula can be easily set by a formula.

FIG. 1 is a block diagram showing an example of a hardware configuration applicable to the calculation processing device according to the embodiment. FIG. 2 is a functional block diagram for explaining the functions of the calculation processing apparatus according to the embodiment. FIG. 3 is a diagram showing an example of a characteristic definition master for each product type applicable to the embodiment. FIG. 4 is a diagram showing an example of a characteristic setting master for each category applicable to the embodiment. FIG. 5 is a diagram showing an example of a product number master applicable to the embodiment. FIG. 6 is a diagram showing an example of a variety master applicable to the embodiment. FIG. 7 is a diagram showing an example of a unit master applicable to the embodiment. FIG. 8 is a diagram showing a list of items that can be used in the calculation definition according to the embodiment. FIG. 9 is a diagram showing an example of a calculation definition master according to an embodiment. FIG. 10 is a diagram for explaining a first application example of the calculation definition master according to the embodiment. FIG. 11 is a diagram showing an example of a calculation definition master maintenance screen, which is a screen for editing the calculation definition master. FIG. 12 is a diagram showing an example of a formula check screen according to an embodiment. FIG. 13 is a diagram showing an example of an expanded formula check screen applicable to the embodiment. FIG. 14 is a diagram showing an example of an input screen for inputting information for performing a calculation by the calculation formula master, which is applicable to the embodiment. FIG. 15 is an example flowchart showing the calculation process according to the embodiment. FIG. 16 is a diagram for explaining a second application example of the calculation definition master according to the embodiment. FIG. 17 is a diagram for explaining a second application example of the calculation definition master according to the embodiment. FIG. 18 is a diagram for explaining a third application example of the calculation definition master according to the embodiment. FIG. 19 is a diagram for explaining a third application example of the calculation definition master according to the embodiment. FIG. 20 is a diagram for explaining a third application example of the calculation definition master according to the embodiment. FIG. 21 is a diagram for explaining a third application example of the calculation definition master according to the embodiment. FIG. 22 is a diagram for explaining a third application example of the calculation definition master according to the embodiment. FIG. 23 is a diagram for explaining a third application example of the calculation definition master according to the embodiment.

Hereinafter, embodiments of a calculation processing apparatus, a calculation processing method, and a calculation processing program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
Although there are default formulas for weight calculation of steel materials and volume calculation of wood, there are also complicated formulas, and it was necessary to create a calculation program for each formula pattern. In addition, there are cases where the formula is mastered and dealt with, but it is necessary to set the same level as the program creation when mastering, and the difficulty of setting is high. Furthermore, in these cases, the comparison between the created calculation program or master setting and the formula is a confirmation while decoding the program or setting, and requires a certain skill. Furthermore, for natural objects such as logs, it may be necessary to change the formula according to the length in consideration of the tapering due to the length, and it was difficult to deal with it only by patterning a simple setting for the formula.

Therefore, in the present embodiment, it is possible to set a master of the calculation formula in a form close to the formula for each product group called a variety. At this time, when the product fluctuation characteristic value that fluctuates depending on the product such as length is used as a threshold value when applying the calculation formula, the formula fluctuates due to the difference in the product fluctuation characteristic value such as length even for the same product. It was made possible to correspond to. At the same time, in consideration of the case where multiple calculations such as weight are required, it is possible to have a formula for each type of intended unit as a calculation result.

In addition, in each calculation formula set in the master, the product type-specific characteristics (specific gravity, etc.) that are unique to each product type, the product number-specific characteristics (fixed dimensions, etc.) that are unique to each product number, variable dimensions, handling quantity, etc. The input value and the fixed coefficient, which is a fixed value, can be used as the number of calculations. Furthermore, it is possible to use rounding and exponentiation calculations that can be executed at any time in the formula, and priority calculations using the parentheses operator. Furthermore, the calculation formula derived from the setting contents and the formula when each value is assigned to the calculation formula are displayed on the screen so that the calculation formula can be easily confirmed.

[2. Constitution]
The configuration of the calculation processing apparatus according to this embodiment will be described. FIG. 1 shows an example of a hardware configuration applicable to the calculation processing apparatus according to the embodiment. In FIG. 1, the calculation processing device 10 includes a CPU (Central Processing Unit) 1000, a ROM (Read Only Memory) 1001, a RAM (Random Access Memory) 1002, a graphic I / F (interface) 1003, and a storage 1004. , Input / output I / F 1005 and communication I / F 1006, and each of these parts is communicably connected to each other by a bus 1010. As described above, the calculation processing device 10 according to the embodiment can be configured by using a general computer.

The storage 1004 is a non-volatile storage medium such as a hard disk drive or a flash memory, and stores a program for operating the CPU 1000 and various data. The CPU 1000 uses the RAM 1002 as a work memory according to a program stored in the storage 1004 and the ROM 1001 to control the overall operation of the calculation processing device 10.

The graphic I / F 1003 converts a display control signal generated by the CPU 1000 according to a program into an image signal compatible with the display 1020 and outputs the signal. As a result, the screen according to the program can be displayed on the display 1020.

The input / output I / F 1005 is an interface for inputting / outputting data to / from an external device. As the input / output I / F 1005, for example, USB (Universal Serial Bus) can be applied. In the example of FIG. 1, an input device 1021 that outputs a control signal corresponding to a user operation is connected to the input / output I / F 1005. The control signal output from the input device 1021 in response to the user operation is sent to the CPU 1000 via the input / output I / F 1005.

A keyboard or a pointing device can be applied to the input device 1021. Not limited to this, as the input device 1021, a touch panel configured integrally with the display device may be applied, or a microphone for performing voice input may be applied. When applying a microphone as the input device 1021, the input / output I / F 1005 includes an A / D converter that converts an analog audio signal into a digital audio signal. Further, a printer or a speaker can be connected to the input / output I / F 1005 as an output device. When applying a speaker as an output device, the input / output I / F 1005 includes a D / A converter that converts a digital audio signal into an analog audio signal.

The communication I / F 1006 communicates with a network such as a LAN (Local Area Network) or the Internet according to the instruction of the CPU 1000.

FIG. 2 is a functional block diagram for explaining the function of the calculation processing device 10 according to the embodiment. In FIG. 2, the calculation processing device 10 includes a control unit 110, a storage unit 120, an input / output I / F (interface) unit 130, and a communication I / F 140 unit. Of these control unit 110, storage unit 120, input / output I / F unit 130, and communication I / F unit 140, the control unit 110, input / output I / F unit 130, and communication I / F unit 140 operate on the CPU 1000. It is composed of execution by a calculation processing program. For the storage unit 120, for example, a predetermined storage area of the storage 1004 is used.

It is also possible to configure a part or all of the control unit 110, the storage unit 120, the input / output I / F unit 130, and the communication I / F unit 140 by a hardware circuit that operates in cooperation with each other.

The storage unit 120 stores each master of the product type characteristic definition master 121, the category-specific characteristic setting master 122, the product number master 123, the product type master 124, the unit master 125, and the calculation definition master 126. In the following, each of these masters shall be configured as a table of records containing a plurality of items. Details of each master will be described later.

The control unit 110 includes a master management unit 111, a calculation definition setting unit 112, a calculation formula creation unit 113, a calculation processing unit 114, and a screen generation unit 115.

The master management unit 111 manages each master stored in the storage unit 120. For example, the master management unit 111 extracts data conforming to the requested conditions from each master stored in the storage unit 120. Further, for example, the master management unit 111 updates the information of each master, adds a new record, and the like according to the request.

The calculation formula definition setting unit 112 sets the elements of the calculation formula in the calculation definition master 126, and defines the calculation formula. That is, the calculation formula definition setting unit 112 uses the product type, the product fluctuation characteristic threshold, which is a threshold for the product fluctuation characteristic, which is a characteristic used in the composition of the product and is a characteristic that fluctuates in the product, and the unit, as keys. A calculation definition master 126 in which the operator is associated with at least the item classification that classifies the product variation characteristic and the product number fixed characteristic, which is a characteristic unique to the product number, as items, is set in the storage unit 120.

The calculation formula creation unit 113 creates a calculation formula based on the calculation formula elements set in the calculation formula definition setting unit 112. That is, the operator in the calculation definition master 126 and the item identifier (thickness, width, outline, etc.) corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master 126 to form a character string. Create and concatenate each character string created in each record of the calculation definition master 126 according to the record order of the calculation definition master 126 to create a calculation formula.

The calculation processing unit 114 applies the input value to the calculation formula created by the calculation formula creation unit 113, and performs numerical calculation by the calculation formula. That is, the calculation processing unit 114 corresponds to the product number input from the category-specific characteristic setting master 122 set in the storage unit 120 in association with the item identifier corresponding to the product number unique characteristic and the characteristic value corresponding to the item identifier. Acquire the characteristic value to be used, and perform the calculation by the calculation formula using the acquired characteristic value.

The screen generation unit 115 generates screen information for displaying the screen on the display 1020. For example, the screen generation unit 115 causes the display 1020 to display a screen for setting the elements of the calculation formula by the calculation formula definition setting unit 112 and a screen for confirming the calculation formula created by the calculation formula creation unit 113. Generate screen information for. Further, the screen generation unit 115 causes the display 1020 to display a screen for displaying an input value for executing a calculation according to the calculation formula created by the calculation formula creation unit 113 and a calculation result corresponding to the input value. Generate screen information for.

In the calculation processing device 10, the input / output I / F 130 unit is connected to the input device 150 and the output device 151. The input device 150 corresponds to, for example, the input device 1021 in FIG. 1, and the input / output I / F unit 130 controls the input / output I / F 1005 to input input data corresponding to the control signal output from the input device 1021. Generate and pass to the control unit 110. The output device 151 is, for example, the display 1020 in FIG. 1, and the input / output I / F unit 130 controls the graphic I / F 1003 to convert the display control signal generated by the CPU 1000 into an image signal and display the display 1020. Supply to.

The communication I / F unit 140 controls the communication I / F 1006 in FIG. 1 to perform communication with the network 30.

The calculation processing device 10 can communicate with the server 20 via the network 30 under the control of the communication I / F unit 140. Each master stored in the storage unit 120 may be stored in the server 20.

The calculation processing program for realizing each function according to the embodiment in the calculation processing apparatus 10 is provided by recording a file in an installable format or an executable format on a recording medium readable by a computer. Recording media that can be read by this computer include memory cards, USB (Universal Serial Bus) memories, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), and EEPROMs (registered). Any portable use such as (Electrically Erasable and Programmable Read Only Memory), CD (Compact Disk), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc. It shall include physical media. Therefore, a recording medium containing a program for executing a process or a process method as described below in the present specification also constitutes the present invention.

Not limited to this, the calculation processing program may be provided by storing it on a computer connected to a network such as the Internet and downloading it via the network. Further, the calculation processing program may be configured to be provided or distributed via a network such as the Internet.

The calculation processing program includes a control unit 110 (master management unit 111, calculation definition setting unit 112, calculation formula creation unit 113, calculation processing unit 114 and screen generation unit 115), input / output I / F unit 130, and communication I / F. It has a module configuration including a unit 140. As actual hardware, when the CPU 1000 reads the calculation processing program from a storage medium such as ROM 1001 and executes it, each of the above-described units is loaded onto a main storage device such as RAM 1002, and the control unit 110 (master management unit 111) is used. , Calculation definition setting unit 112, calculation formula creation unit 113, calculation processing unit 114 and screen generation unit 115), input / output I / F unit 130 and communication I / F unit 140 are now generated on the main storage device. ing.

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by an OS (Operating System). Including those that achieve the function.

[3. Details of each master according to the embodiment]
Next, with reference to FIGS. 3 to 7, for each of the above-mentioned masters (characteristic definition master 121 for each product type, characteristic setting master 122 for each category, product number master 123, product type master 124, unit master 125, and calculation definition master 126). It will be explained in more detail.

FIG. 3 shows an example of the characteristic definition master 121 for each product type applicable to the embodiment. The characteristic definition master 121 for each product type includes each item of "product type", "category classification", "row NO", and "characteristic" in the record, and the group specified by the item "product type" is composed of what common elements. And a master for defining what is classified.

For example, a product number belonging to the group of the product type "plate steel" has the characteristics of "specific gravity", "thickness", "width" and "length". Among these characteristics, "specific gravity" is a numerical value common to all sheet steels and is a characteristic fixed for each product type (product type fixing characteristic). On the other hand, fixed dimensions such as "thickness" and "width" are fixed characteristics for each product number (product number fixing characteristics). Further, the "length" is a characteristic (commodity variation characteristic) that becomes a value different for each individual when the sheet steel is cut.

In FIG. 3, three varieties of "plate steel", "pipe" and "log" are set as the item "variety". The item "category classification" sets the category classification for showing the characteristics of the variety. In the example of FIG. 3, in the item "category classification", three characteristics of "product number fixed characteristic", "product number fixed characteristic" and "product variation characteristic" are classified and set as characteristic categories. In addition, at least two characteristics, "product number fixed characteristic" and "product fluctuation characteristic", are set for each product type.

Among the category categories, the item "Cultivar fixed characteristic" indicates a characteristic that is fixed to the variety. The item "Product number fixed characteristic" indicates a characteristic that is fixed to the product number in the product type. For example, when there are a plurality of standards having different characteristics such as size for a certain product type, different product numbers are assigned to each of the plurality of standards. The item "product fluctuation characteristics" indicates characteristics that differ from product to product. The item "row NO" indicates a number for identifying a plurality of characteristics when a plurality of characteristics are defined for the product number. The item "characteristic" is an item in which the content of the characteristic is set, and is an item identifier for identifying each characteristic set in the item "category category".

As an example, the product type "plate steel" is set into three category categories: product type fixing characteristic, product number fixing characteristic, and product variation characteristic. As for the product type fixing characteristic, only "specific density" is set as the characteristic, and the row NO is set to "1". As the product number fixing characteristic, two characteristics, "thickness" and "width", are set, and the row number is set to "2". That is, the product type "plate steel" can include a plurality of standards having different "thickness" and "width". Further, as the product variation characteristic, "length" is set as a characteristic, and the row number is set to "1".

As another example, for the product type "log", two category categories, a fixed product number characteristic and a product variation characteristic, are set. As described above, the varieties can be set not to include the cultivar fixing characteristics as the category classification.

FIG. 4 shows an example of a category-specific characteristic setting master 122 applicable to the embodiment. The category-specific characteristic setting master 122 manages the specific contents of the characteristics in each category (product fixed characteristic → product number fixed characteristic → product variation characteristic) classified in the product type characteristic definition master 121 described with reference to FIG. It is a master to do. The category-specific characteristic setting master 122 can manage each category and characteristic for each product type.

In the example of FIG. 4, the category-specific characteristic setting master 122 includes each item of "category classification", "category code", "characteristic", and "characteristic numerical value" in the record. In FIG. 4, the rightmost column is an explanation for the category division and does not have to be included as the information constituting the category-specific characteristic setting master 122.

The item "category classification" corresponds to the item "category classification" in the characteristic definition master 121 for each type of FIG. In the category-specific characteristic setting master 122, for the item "category classification", among the above-mentioned three categories of "product number fixed characteristic", "product number fixed characteristic" and "product variation characteristic", the category "product fixed characteristic" and The category "Product number fixed characteristics" is set.

Information for specifying the product type and product number is set in the item "category code". More specifically, the product type (product number name) is set in the record whose category category is "product number fixed characteristic", and the product number (product number name) is set in the record whose category category is "product number fixed characteristic".

Further, in the category-specific characteristic setting master 122, the product type included in the character string set in the item "category code" and the category classification are set to the values set in the item "row NO" of the product type-specific characteristic definition master 121. Records are created accordingly. In the example of FIG. 4, for the type “plate steel”, one record is created according to the value “1” (see FIG. 3) set in the row NO for the type fixing characteristic with respect to the category-specific characteristic setting master 122. To. Further, two records having a common category code are created according to the values "1" and "2" (see FIG. 3) set in the row NO for the fixed product number characteristic.

The item "characteristic" corresponds to the item "characteristic" in the characteristic definition master 121 for each type of FIG. 3, and the content of the characteristic corresponding to the item "category classification" and the item "category code" of the record is set. Further, in the item "characteristic numerical value", a specific numerical value is set for the characteristic set in the item "characteristic".

In the example of FIG. 4, the characteristic numerical value "7.85 (Kg / 1m ³ )" is set for the characteristic "specific gravity" of the category classification "type fixing characteristic" and the category code "plate steel". Regarding the category category "fixed product number", the characteristic values "6.0 mm" and "width" for the characteristics "thickness" and "width" of the two records in common with the category code "plate steel 914 x 1829 x 6", respectively. "914 mm" is set.

In another example of FIG. 4, the variety fixing characteristic is not set when the category category is “variety fixing characteristic” and the category code is “log” (see FIG. 3). Further, regarding the category category "product number fixed characteristic", the characteristic numerical values "50 cm" and "55 cm" are set for the characteristic "diameter" of the category codes "log D50" and "log D55", respectively.

FIG. 5 shows an example of a product number master 123 applicable to the embodiment. The product number master 123 includes each item of "product number code (CD)", "product number name", "product type", and "number unit" in the record. In the item "product number code", the product number identification information for identifying the product number is set.

The name given to the product number is set in the item "product number name". For the item "product number name", a value (such as "plate steel 914 x 1829 x 6") in the item "category code" of the category-specific characteristic setting master 122 of FIG. 4 is set. The item "product type" corresponds to the item "product type" in the characteristic definition master 121 for each product type in FIG. 3, and the product type of the product number identified by the item "product number code" is set. In the item "number unit", a unit (for example, "sheet", "book") for counting the individual of the product identified by the item "product number code" is set.

FIG. 6 shows an example of the product type master 124 applicable to the embodiment. The variety master 124 includes each item of "variety code (CD)", "variety name" and "conversion unit" in the record. In the item "variety code", the variety identification information for identifying the variety is set. In the item "variety name", the name of the variety identified by the variety code is set. The item "product name" has a value in the item "product" in the characteristic definition master 121 for each product type in FIG. 3 and the product number master 123 in FIG. 5 (in this example, "plate steel", "pipe", and "log"). Set. In the item "conversion unit", a unit (for example, "Kg", "m ³ ") used for the calculation result obtained by performing the calculation for the variety indicated by the item "variety code" is set.

FIG. 7 shows an example of the unit master 125 applicable to the embodiment. The unit master 125 is a master that manages units, and includes each item of "unit code (CD)", "unit name", and "unit classification". In the item "unit code", unit identification information for identifying the unit is set. For the item "unit name", the display name of the unit is set (in this example, "Kg", "m ³ ", "sheet", "book"). The item "unit classification" is set to the unit classification (in this example, "weight", "volume", "number of members").

[4. Calculation definition according to the embodiment]
Next, the calculation definition according to the embodiment will be described. In the embodiment, a calculation formula for performing weight calculation, volume calculation, or the like is defined by using the calculation definition master 126. The definition of the calculation formula by the calculation definition master 126 is performed for each product type. At this time, it is necessary to assume a case where a plurality of different calculations are performed even for the same product type. For example, in the product type "log", the calculation method may differ depending on the product variation characteristic value (length). Therefore, in the embodiment, the product type, the threshold value for the product variation characteristic value, and the unit classification for the calculation result are set as keys in the calculation definition master 126. Here, the threshold value for the product variation characteristic value set as the key is the lower limit value (definition application lower limit value) to which the definition is applied.

FIG. 8 shows a list of items that can be used in the calculation definition according to the embodiment. As shown in the item classification in FIG. 8, the calculation definition according to the embodiment includes “product number fixed characteristic”, “product number fixed characteristic”, “product fluctuation characteristic numerical value”, “number of members”, “other fixed value”, and the like. Each item of "rounding start / end", "exponentiation start / end" and "dummy" can be used. One of these items is set for the record of the calculation definition master 126, and the item defined in the record is classified.

Each item shown in FIG. 8 will be described. The item "Fixed product type characteristic" is a set value in the record in which the item "Category classification" of the characteristic setting master 122 for each category in FIG. 4 is "Fixed product type characteristic" (category category = 2: product type) with respect to the calculation definition master 126. Set (characteristics, characteristic values). As the value set in the record including the item "type fixed characteristic", for example, the substance specific density and its value are assumed as the characteristic and the characteristic value.

Similarly, the item "fixed product number characteristic" is a record in which the item "category classification" of the characteristic setting master 122 for each category in FIG. 4 is "product number fixed characteristic" (category classification = 0: product number) with respect to the calculation definition master 126. Set the set values (characteristics, characteristic values) in. As the value set for the record including the item "product number fixed characteristic", fixed dimensions such as thickness, width, and diameter are assumed for each product number.

In the item "product fluctuation characteristic numerical value", the input value by the user for the characteristic value (product fluctuation characteristic value) that fluctuates for each product is set in the calculation definition master 126. As the product fluctuation characteristic value set in the item "product fluctuation characteristic numerical value", dimensions such as length that may be changed for each product and each input are assumed. Similarly, an input value is applied to the item "number of members" by the user. As the value applied to the item "number of members", physical distribution quantities such as the number of pieces and the number of sheets are assumed.

In the item "Other fixed values", a value such as a fixed coefficient used in the formula corresponding to the calculation formula defined in the calculation definition master 126 is set.

The item "Rounding start / end" sets the rounding for the calculation formula in the calculation definition master 126. When the item "start / end of rounding" is placed at the start position of rounding in the calculation formula, the rounding method is specified. The specified rounding method is assumed to be rounding, rounding up, and rounding down, but is not limited to these. Further, when the item "start / end of rounding" is placed at the end position of rounding in the calculation formula, it specifies a valid decimal digit in the result of rounding.

The item "Exponentiation start / end" sets the start position, end position, and root of exponentiation for the calculation formula in the calculation definition master 126. The roots are specified at the end of the exponentiation calculation.

The item "dummy" indicates to the calculation definition master 126 the start position and end position of parentheses (parentheses operator) that specify the range in which the calculation is preferentially executed in the calculation formula, and the record that specifies only the operator. Set.

[5. Specific example of calculation definition master according to the embodiment]
Next, the calculation definition master 126 according to the embodiment will be described more specifically. The storage unit 120 can set a plurality of calculation definition masters 126. For example, the calculation definition master 126 can be set for each different combination of the items "variety code", "variation characteristic threshold value", and "calculation result" in the key item. In the following, unless otherwise specified, the calculation definition master 126 refers to any one of the plurality of calculation definition masters 126 stored in the storage unit 120.

FIG. 9 shows an example of the calculation definition master 126 according to the embodiment. In the calculation definition master 126, "product code", "variation characteristic threshold", "calculation result", "serial number", "item classification", "parentheses and other Starts", "operator", and "item value code" are recorded in the record. (CD) ”,“ constant ”and“ parentheses and other Ends ”are included.

Of these, each item of "variety code", "variation characteristic threshold", "calculation result" and "serial number" is a key item of the calculation definition master 126, and the items "variety code" and "variation characteristic threshold". And "calculation result" are set to common values in all the records of the calculation definition master 126. The item "serial number" is set to a value that increases in the order of records. For example, the calculation formula creation unit 113 (see FIG. 2) can specify the formula to be calculated according to the values of these items “variety code”, “variation characteristic threshold value”, and “calculation result”.

In the item "variety code", the value of the item "variety code" or the item "variety name" of the variety master 124 of FIG. 6 is set, and the variety of the product to be calculated by the calculation definition master 126 is specified. In the item "variation characteristic threshold value", a threshold value for the product variation characteristic value is set. When there are a plurality of calculation definition masters 126 having the same item "product code" and the item "calculation result" described later, the calculation definition master 126 used for the calculation is used for the input product variation characteristic value and this item "variation characteristic". It is specified based on the value set in the "threshold value".

In the item "calculation result", the unit of the calculation result by the calculation formula defined in the calculation definition master 126 is set.

Of each item of the calculation definition master 126, the item "item classification" and the items "parentheses and other Starts", "operators", "item value code (CD)", and "constants" arranged in order from left to right. "And" Parentheses and others End "are set with each element for creating an expression character string which is a character string indicating a calculation formula. In the item "item classification", items that can be used in the calculation definition according to the embodiment described with reference to FIG. 8 are set.

The item "Brackets and others Start" and the item "Brackets and others End" are priority range specification operations for specifying the start position and end position of the range that is preferentially calculated in the formula, such as parenthesis calculation or exponentiation calculation, respectively. Set the child. The start position of the parenthesis calculation is set by setting the value of the item "parentheses and other Start" to the value "(", and the end position is set by setting the value of the item "parentheses and other End" to the value ")". To. The start position of the exponentiation calculation is set by setting the value of the item "parentheses and other Starts" to "start of exponentiation (". It is set by setting it as a value (for example, ") squared" in combination with the roots.

Further, the item "parentheses and others Start" and the item "parentheses and others End" set the start position and the end position of the rounding, respectively. In this case, the item "parentheses and other Starts" sets the type of rounding as well as the start position of rounding. In addition, the item "parentheses and others End" sets the number of digits of the rounding process together with the end position of the rounding process.

Symbols (for example, "+", "-", "x", and "÷") indicating four arithmetic operations are set in the item "operator".

The item "item value code" is an item specified from the product type characteristic definition master 121 described with reference to FIG. 3 based on the value of the key item "product code" of the record and the value of the item "item classification". The value of "Characteristics" is set. The item "constant" is an item for which a value is set when the value of the item "item classification" of the record is "fixed value".

Here, referring to FIG. 2, in each record of the calculation definition master 126, the calculation formula creation unit 113 includes the items “parentheses and other Start”, “operator”, “item value code”, “constant”, and “constant”. The values of "parentheses and others End" are concatenated from left to right according to the order in the calculation definition master 126 to generate a character string. Further, the calculation formula creation unit 113 concatenates each character string generated in each record in the order of the item "serial number" of each record, and generates an expression character string representing the final calculation formula.

In the calculation definition master 126, the parentheses, roots, and operators set in each item of "start of parentheses and others", "operator", and "End of parentheses and others" are displayed on, for example, the calculation definition master maintenance screen described later. It is a character string to make it. The calculation processing unit 114 includes, for example, a function for executing a calculation according to a character string set in each of these "start of parentheses and others", "operator", and "End of parentheses and others". The calculation processing unit 114 acquires the character strings set in each of these "parentheses and other Starts", "operators", and "parentheses and other Ends" from the calculation definition master 126, and applies each of the above-mentioned formulas. Get the number. The calculation processing unit 114 passes each acquired character string and numerical value to the function, and executes a calculation by the function using each of these character strings and numerical values.

[6. First application example of the embodiment]
A first application example of the calculation definition master 126 according to the embodiment will be described with reference to FIG. The first application example is an example in which the calculation definition master 126 is applied to the weight calculation of sheet steel. FIG. 10A shows a formula for calculating the weight of sheet steel. The weight of the sheet steel is calculated using the formula "(thickness x width x length x specific gravity) / constant" as a formula. Here, the constant is a value for unit conversion, the unit of thickness, width and length is "mm", the unit of specific gravity is "Kg / 1m ³ ", and the unit required as a calculation result is "". In the case of "Kg", the constant is "1,000,000" as in the example of FIG. 10 (a).

FIG. 10B shows an example of a calculation definition master 126a that defines a calculation formula corresponding to the formula of FIG. 10A. In the example of FIG. 10B, the value "plate steel" of the item "type code" in the key item, the value "0" of the item "variation characteristic threshold", and the value "Kg" of the item "calculation result" Therefore, the formula of FIG. 10 (a) is specified. Here, in the case of weight calculation of sheet steel, since a single formula is applied regardless of the product variation characteristic value (length), the item “variation characteristic threshold” can be ignored. When the formula is expressed by a fractional expression containing a plurality of terms in the numerator or denominator, the opening parenthesis and the closing parenthesis are implicitly set for the entire of the plurality of terms.

In the record where the item "serial number" is "0" (hereinafter referred to as the record with the serial number "0", etc.) according to the specified formula and the value of the item "item classification", the value is set to the item "parentheses and other Start". The value "thickness" is set for "(" and the item "item code", respectively, and in the record with serial number "1", the value "x" is set for the item "operator" and the value "width" is set for the item "item code". In the record of the serial number "2", the value "x" is set in the item "operator" and the value "specific weight" is set in the item "item code".

In the record of serial number "3", the value "x" is set in the item "operator". Since this record is a record of the product variation characteristic value and the value used for the calculation is input by the user on the input screen described later, the item "item value code" of the record is left blank. The record with the serial number "4" is a dummy record, and the value ")" is set in the item "parentheses and other Ends". The record with the serial number "5" is a record with a fixed value, and the value "÷" is set in the item "operator", and the value "1," as a fixed value officially specified in the item "constant". "Million" is set.

FIG. 10 (c) shows an example in which a concrete numerical value is substituted for the calculation definition master 126a of FIG. 10 (b) assuming the sheet steel of the product number name “plate steel 914 × 1829 × 6”. In the example of FIG. 10 (c), the items "item value code" and "constant" in the calculation definition master 126a of FIG. 10 (b) are collectively applied as numerical values. For example, in each record of the serial numbers "0" to "2", the calculation processing unit 114 has corresponding values from the category-specific characteristic setting master 122 of FIG. 4 according to the values of the item "variety code" and the item "item classification". Acquire "6" (thickness), "914" (width) and "7.85" (specific weight), and set them as officially applicable values. Further, in the record of the product variation characteristic of the serial number "3", the value "1,000" (length) input by the user is set as a numerical value to be officially applied. Further, in the record of the fixed value of the serial number "5", the value "1,000,000" is set according to the formula.

FIG. 11 shows an example of the calculation definition master maintenance screen 200, which is a screen for editing the calculation definition master 126. With reference to FIG. 2, the calculation definition setting unit 112 refers to each master set in the storage unit 120, acquires each information for displaying the calculation definition master maintenance screen 200, and passes it to the screen generation unit 115. .. The screen generation unit 115 generates screen information based on the information passed from the calculation definition setting unit 112, and passes the generated screen information to, for example, an output device 151 which is a display 1020 via the input / output I / F unit 130. , The calculation definition master maintenance screen 200 is displayed on the display 1020.

In FIG. 11, the calculation definition master maintenance screen 200 includes input units 210, 211 and 212, a master display unit 213, and a button 214. The calculation definition master maintenance screen 200 shown in FIG. 11 is a weight calculation definition master maintenance screen for editing the calculation definition master 126a for performing the weight calculation of the sheet steel described with reference to FIG. 10 (b). I'm assuming.

The input units 210, 211 and 212 are provided to set the key items of the calculation definition master 126 for each item of "variety code", "variation characteristic threshold value" and "calculation result".

The input unit 210 includes an input area 2101 for inputting a value set in the item "product code" and a display area 2102 for displaying a product type corresponding to the value input in the input area 2101. In the input area 2101, the value set in the item "variety code" of the variety master 124 shown in FIG. 6 is input. The input to the input area 2101 may be performed manually by the user, or the user may be made to select from a drop-down list including a list of product types. For example, the calculation definition setting unit 112 refers to the product type master 124 to acquire a list of product type codes, and passes the acquired list of product type codes to the screen generation unit 115. The screen generation unit 115 generates a drop-down list or the like based on this list of product code and displays it in the display area 2102.

Further, the calculation definition setting unit 112 refers to the product type master 124, acquires a value corresponding to the value input to the input area 2101 from the item “product name”, and displays the acquired value by the screen generation unit 115. Displayed in area 2102. In the example of FIG. 11, the product code “ITA” is input to the input area 2101, and the product code “ITA” is displayed with the product type name “plate steel” associated with the product type master 124 in the display area 2102.

The input unit 211 has an input area 2111 for inputting a value (product variation characteristic threshold value) set in the item "variation characteristic threshold value" and a display area for displaying a unit corresponding to the value input in the input area 2111. Includes 2112. The variation characteristic threshold is a threshold value for the product variation characteristic value when the formula applied differs depending on the product variation characteristic value (“length” or the like). If the formula does not change depending on the product variation characteristic value, the value "0" is input as the variation characteristic threshold. Further, the calculation definition setting unit 112 refers to the category-specific characteristic setting master 122, and causes the display area 2112 to display a predetermined unit for the product type indicated by the product type code input to the input area 2101. In the example of FIG. 11, the value “0.00” is input to the input area 2111, and the unit name “mm” corresponding to the product type code input to the input area 2101 is displayed in the display area 2112.

The input unit 212 displays an input area 2121 for inputting a value (unit code) set in the item "calculation result" and a unit (calculation result unit) corresponding to the value input in the input area 2121. Includes display area 2122. In the input area 2121, the value set in the item "unit code" of the unit master 125 shown in FIG. 7 is input. The input to the input area 2121 may be performed manually by the user or may be made to select from the drop-down list. For example, the calculation definition setting unit 112 refers to the unit master 125 to acquire a list of unit codes, and passes the acquired list of unit name codes to the screen generation unit 115. The screen generation unit 115 creates a drop-down list based on this list of product code and displays it in the display area 2122. In the example of FIG. 11, the unit code “13” is input to the input area 2121, and the unit name “Kg” associated with the unit code “13” in the unit master 125 is displayed in the display area 2122.

The master display unit 213 includes the item "serial number" in the calculation definition master 126 and each item on the right side of the item "serial number" (item "item classification", item "parentheses and other constants", "operator", "item". The value code (CD) ”,“ constant ”, and“ parentheses and other Ends ”) are displayed including the set values.

The calculation definition setting unit 112 is a calculation definition master set in the storage unit 120 using the values of the “type code”, the “variation characteristic threshold”, and the “calculation result” input to the input areas 2101, 2111, and 2121 as keys. From 126, the calculation definition master 126 corresponding to the key is specified. The screen generation unit 115 includes an item "serial number", an item "item classification", an item "parentheses and other Starts", an "operator", and an "item value code" of the calculation definition master 126 specified by the calculation definition setting unit 112. (CD) ”,“ constant ”and“ parentheses and other Ends ”are set to be displayed in the corresponding records and items of the master display unit 213.

Further, when the calculation definition setting unit 112 cannot specify the calculation definition master 126 corresponding to the input key from the storage unit 120, the screen generation unit 115 calculates that each record is blank in the master display unit 213. Display the definition master 126. This corresponds to, for example, the case of setting a new calculation definition master 126. In this case, the user can operate the input device 150 to directly set a value for each column of the calculation definition master 126 displayed on the master display unit 213.

In the example of FIG. 11, the master display unit 213 has the item “item classification” and the item “parentheses” of each record corresponding to the serial numbers “0” to “5” in the calculation definition master 126a of FIG. 10 (b). The values set in "Other Start", "Operator", "Item value code", "Constant" and "Parentheses and others End" are displayed at the corresponding positions of the record and the item, respectively.

For example, the calculation definition setting unit 112 is set in the storage unit 120 according to the information input and displayed in the input units 210 to 212 of the calculation definition master maintenance screen 200 and the master display unit 213. Update the calculation definition master 126. Not limited to this, the calculation definition setting unit 112 temporarily stores the information input and displayed in the input units 210 to 212 of the calculation definition master maintenance screen 200 and the master display unit 213 in the RAM 1002 or the like, and determines the information. The calculation definition master 126 stored in the storage unit 120 may be updated based on the stored information in response to the trigger of.

On the calculation definition master maintenance screen 200, the button 214 is a button for confirming the calculation formula defined on the calculation definition master maintenance screen 200. FIG. 12 shows an example of the formula check screen 300 displayed by operating the button 214 according to the embodiment. The formula check screen 300 includes display areas 310 and 311 and a button 312.

In the display area 310, the calculation formula set on the calculation definition master maintenance screen 200 is displayed. As described above, the calculation formula creation unit 113 (see FIG. 2) has the items “parentheses and other Starts”, “operators”, “item value codes”, which are displayed on the master display unit 213 of the calculation definition master maintenance screen 200. In each record, the values set in "constant" and "parentheses and other Ends" are concatenated from left to right according to the order in which the items are arranged in the record to generate a character string. Further, the calculation formula creation unit 113 concatenates each character string created in each record in the order of the item "serial number" of each record, and generates an expression character string representing the final calculation formula. The screen generation unit 115 displays the formula character string created by the calculation formula creation unit 113 in the display area 310.

More specifically, referring to FIG. 11, the calculation formula creation unit 113 has the item "item value code" to the right of the value "(") set in the item "parentheses and other Starts" of the record with the serial number "0". The value "thickness" set in is concatenated to generate the character string "(thickness". The item "item value" to the right of the value "x" set in the item "operator" of the record with serial number "1". The value "width" set in "code" is concatenated to generate the character string "x width". This process is executed in each record of the serial numbers "2" to "5", and the character string "x specific weight" is executed. , "X length", ")" and "÷ 1,000,000" respectively.

In addition, in the record of the serial number "3" in which the value "product fluctuation characteristic" is set in the item "item classification", the calculation formula creation unit 113 has the product type master 124 and the product based on the product type code input in the input area 2101. With reference to the type characteristic definition master 121, the value (“length” in this example) of the item “characteristic” corresponding to the category category “product variation characteristic” corresponding to the product type code is acquired. The calculation formula creation unit 113 regards the value of the item "characteristic" corresponding to the acquired category category "product fluctuation characteristic" as the value of the item "item value code", and sets it in the item "operator". Concatenate to the right of the value "x".

The calculation formula creation unit 113 creates a final calculation formula by concatenating the character strings generated in each record of the serial numbers "0" to "5" in the order of the serial numbers. In the example of FIG. 11, each character string "(thickness", "x width", "x specific weight", "x length", ")" and "÷ 1,000," of the serial numbers "0" to "5" 000 ”is concatenated to create an expression character string“ (thickness × width × specific weight × length) ÷ [constant 1,000,000]] representing a calculation formula displayed in the display area 310 in FIG. Each character string of "[constant" and "]" included in this expression character string is supplemented by the control unit 110 according to the item "constant".

On the formula check screen 300, the display area 311 displays a calculation formula in which a specific numerical value is applied to the calculation formula displayed in the display area 310. For example, the calculation formula creation unit 113 acquires a product number code and a product variation characteristic value input from the input device 150 on another screen, for example, an order input screen for inputting an order for a product. The calculation formula creation unit 113 refers to the product number master 123 and the category-specific characteristic setting master 122 based on the acquired product number code, and the characteristic numerical value in the category category “type fixed characteristic” corresponding to the product number code and the category category “ Acquire the characteristic numerical value in "Product number fixed characteristic".

In the example of FIG. 12, the calculation formula creating unit 113 inputs, for example, the product number code “ITA_914 × 1829 × 6” input to another screen. The calculation processing unit 114 refers to the product number master 123, and acquires the product number name “plate steel 914 × 1829 × 6” and the product type “plate steel” corresponding to the input product number code “ITA_914 × 1829 × 6”. The calculation processing unit 114 acquires the characteristic "specific gravity" corresponding to the acquired type "plate steel" and the characteristic numerical value "7.85 (Kg / 1m ³ )" with reference to the category-specific characteristic setting master 122. .. Similarly, the calculation processing unit 114 refers to the category-specific characteristic setting master 122, and corresponds to the characteristics “thickness” and “width” corresponding to the acquired product number name “plate steel 914 × 1829 × 6”, respectively. The characteristic numerical values "6.0 mm" and "914 mm" are acquired.

In addition, the calculation formula creation unit 113 acquires the product variation characteristic value (“1,000 mm” in this example) input to the other screen.

Not limited to this, for example, in response to an operation on the button 214 on the calculation definition master maintenance screen 200, the screen generation unit 115 may display the product number input screen for inputting the product number code and the product variation characteristic value. good. On the product number input screen, the user may manually input the product number code from the input device 150, or the screen generation unit 115 refers to the product number master 123 to generate a drop-down list or the like, and the user is informed of this. You may select from the drop-down list. The calculation formula creation unit 113 refers to the product number master 123 and the category-specific characteristic setting master 122 based on the product number code input on the product number input screen, and corresponds to the input product number code in the category classification “product fixed characteristic”. Acquire the characteristic numerical value and the characteristic numerical value in the category category "fixed product number characteristic".

The calculation formula creation unit 113 has the acquired characteristics "thickness", "width" and "specific gravity" set to the respective values "6.0 mm" and "914 mm", and the product variation characteristic value "7.85 (Kg / 1 m)". ³ ) ”is replaced with the corresponding character string of the calculation formula displayed in the display area 310, respectively, to create the calculation formula. The calculation formula "(6 * 914 * 7.85 * 1,000) / 1,000,000" created in this way is displayed in the display area 311. In this example, the operator "x" in the character string expression is replaced with "*" to display the calculation expression.

The user can easily determine whether or not the calculation formula set on the calculation definition master maintenance screen 200 is intended by displaying the display areas 310 and 311.

In the formula check screen 300, the button 312 is a button for enlarging or reducing the formula check screen 300. By operating the button 312 in the state of the formula check screen 300 shown in FIG. 12, the formula check screen 300 can be expanded to display more detailed information about the calculation formula.

FIG. 13 shows an example of an expanded expression check screen 300'applicable to the embodiment, which is displayed by operating the button 312 on the expression check screen 300. In FIG. 13, the same reference numerals are given to the portions common to those in FIG. 12 described above, and detailed description thereof will be omitted.

In the formula check screen 300', input units 216, 217 and 218, a display unit 220, and a characteristic value display unit 230 are added to the above-mentioned formula check screen 300.

The input unit 216 includes an input area 2161 and a display area 2162. The input area 2161 is an area for inputting a product number code, and as an initial value, the above-mentioned other screen (for example, an order input screen) or the product number code input to the product number input screen is displayed. In the input area 2161, the product number code may be manually input by the user, or the user may be allowed to select from a drop-down list including a list of product number codes. For example, the calculation definition setting unit 112 refers to the product number master 123 to acquire a list of product number codes, and passes the acquired list of product number codes to the screen generation unit 115. The screen generation unit 115 generates and displays a drop-down list or the like based on the list of product number codes. In the display area 2162, the product number name corresponding to the product number code displayed in the input area 2161 is displayed.

The input unit 217 includes an input area 2171 and a display area 2172. The input area 2171 is an area for inputting the value of the product variation characteristic. In the input area 2171, as the initial value, the product variation characteristic value input to the above-mentioned other screen (for example, the order input screen) or the product number input screen is displayed.

The input unit 218 includes an input area 2181 and a display area 2182. The input area 2181 is an area for inputting a unit code indicating a unit of the calculation result, and as an initial value, the unit code input to the input area 2121 described with reference to FIG. 11 is displayed. In the input area 2181, the unit code may be manually input by the user, or the user may be allowed to select from a drop-down list including a list of unit codes. For example, the calculation definition setting unit 112 refers to the unit master 125 to acquire a list of unit codes, and passes the acquired list of unit codes to the screen generation unit 115. The screen generation unit 115 generates and displays a drop-down list or the like based on the list of unit codes. In the display area 2182, the unit name corresponding to the unit code displayed in the input area 2181 is displayed.

The display unit 220 includes a display area 2201 for displaying the product type code and a display area 2202 for displaying the product type corresponding to the product type code displayed on the display area 2201. In the display area 2201, the value input to the input area 2101 of FIG. 11 is displayed. Further, in the display area 2202, the product type name corresponding to the value input in the display area 2201 is displayed. In the display area 2201, the displayed value cannot be changed.

The characteristic value display unit 230 includes each item of "category classification", "characteristic", and "characteristic numerical value" in the characteristic setting master 122 for each category, and corresponds to the product number code input to the input area 2161 for each item. Each value set in the above is displayed. For example, the screen generation unit 115 causes the characteristic value display unit 230 to display the characteristics and characteristic numerical values acquired when the calculation processing unit 114 displays the calculation formula in the display area 311 described above in association with the category classification.

By displaying the characteristic value display unit 230, it is possible to easily confirm the correspondence between the calculation formula displayed on the display area 310 and the calculation formula using specific numerical values displayed on the display unit 311.

Further, in the characteristic value display unit 230, each value set in the item "characteristic numerical value" can be changed. Also in this case, similarly to the above-mentioned example of the calculation definition master maintenance screen 200, the calculation definition setting unit 112 is set in the storage unit 120 according to the value changed in the characteristic value display unit 230 of the formula check screen 300'. The corresponding calculation definition master 126 is updated. Not limited to this, the calculation definition setting unit 112 temporarily stores the information input and displayed in the characteristic value display unit 230 of the formula check screen 300'in the RAM 1002 or the like, and stores the stored information in response to a predetermined trigger. The calculation definition master 126 stored in the storage unit 120 may be updated based on the above.

The button 312 is a button for switching the formula check screen 300'to the formula check screen 300 of FIG.

[7. Calculation example according to the calculation definition master]
Next, an example of calculation according to the calculation definition master 126 according to the embodiment will be described. Here, the calculation definition master 126a for performing the weight calculation of the sheet steel described with reference to FIGS. 10 (a) to 10 (c) will be described as an example.

FIG. 14 shows an example of an input screen for inputting information for performing a calculation by the calculation formula master 126, which is applicable to the embodiment. The input screen 400 exemplified in FIG. 14 is an example of a movement input screen for performing a calculation related to the movement of a product. The input screen 400 includes an input unit 410 for inputting a product number code, an input unit 411 for inputting a product variation characteristic value, and an input unit 412 for inputting the number of members. Further, the input screen 400 further includes a display unit 413 for displaying the calculation result. In the example of FIG. 14, the calculation result is shown as "asset quantity". Furthermore, the input screen 400 further includes a button 420 for instructing recalculation and a button 421 for performing an expression check.

The input unit 410 includes an input area 4101 for inputting a product number code and a display area 4102 for displaying the product number name corresponding to the product number code input to the input area 4101. In the input area 4101, the value set in the item "product number code (CD)" of the product number master 123 shown in FIG. 5 is input. The input to the input area 4101 may be manually performed by the user, or the user may be made to select from a drop-down list including a list of product number codes. For example, the calculation processing unit 114 refers to the product number master 123 to acquire a list of product number codes, and passes the acquired list of product number codes to the screen generation unit 115. The screen generation unit 115 generates a drop-down list or the like based on this list of product number codes and displays it in the display area 4101.

Further, the calculation processing unit 114 refers to the product number master 123, acquires a value corresponding to the value input to the input area 4101 from the item “product number name”, and passes it to the screen generation unit 115. The screen generation unit 115 causes the display area 4102 to display the value of the product number name passed from the calculation processing unit 114. In the example of FIG. 14, the product number code “ITA_914 × 1829 × 6” is input to the input area 4101, and the product number code “ITA_914 × 1829 × 6” is associated with the product number code “ITA_914 × 1829 × 6” in the display area 4102 in the product number master 123. Steel 914 x 1829 x 6 "is displayed.

The input unit 411 includes an input area 4111 for inputting a value to be set in the item "commodity variation characteristic value" and a display area 4112 for displaying a unit corresponding to the value input in the input area 4111. The calculation processing unit 114 refers to the category-specific characteristic setting master 122, acquires a predetermined unit for the product type corresponding to the product number code input to the input area 4101, and acquires the acquired unit as the screen generation unit 115. Pass to. The screen generation unit 115 displays the unit passed from the calculation processing unit 114 in the display area 4112. In the example of FIG. 14, the value “1,000,00.000” is input to the input area 4111, and the unit “mm” corresponding to the product type corresponding to the product number code input to the input area 4101 is input to the display area 4112. Is displayed.

The input unit 412 includes an input area 4121 for inputting a value for setting the number of members, and a display area 4122 for displaying a unit corresponding to the value input to the input area 4121. The calculation processing unit 114 acquires a value corresponding to the product number code input to the input area 4101 with reference to the item “number unit” of the product number master 123, and passes the acquired value to the screen generation unit 115. The screen generation unit 115 causes the display area 4122 to display the value corresponding to the product number code passed from the calculation processing unit 114. In the example of FIG. 14, the value “100” is input to the input area 4121, and the unit “sheet” corresponding to the product number code input to the input area 4101 is displayed in the display area 4122.

The display unit 413 includes display areas 4131 and 4132. The display area 4131 displays the calculation result based on the values input to the input units 410, 411 and 412. The display area 4132 displays a unit for the value displayed in the display area 4131. The calculation processing unit 114 refers to the product number master 123 based on the product number code input to the input area 4101 to acquire the value of the item "type", and further refers to the product type master 124 based on the acquired value of the item "product". Then, the value of the item "conversion unit" corresponding to the value of the acquired item "variety" is acquired, and the acquired value is passed to the screen generation unit 115. The screen generation unit 115 causes the display area 4132 to display the value of the item “conversion unit” passed from the calculation processing unit 114.

On the input screen 400, the button 420 is a conversion quantity recalculation button for instructing the calculation processing unit 114 to recalculate according to the values input to the input areas 4101, 4111 and 4121 of the input screen 400. For example, when the input values to be input to the input areas 4101, 4111 and 4121 are changed, the calculation processing unit 114 recalculates using the changed input values by operating this button 420.

The button 421 is an expression check button for instructing the expression check. The screen generation unit 115 displays the formula check screen 300 described with reference to FIG. 12 in response to an operation on the button 421. Even in this case, the screen generation unit 115 switches the display of the formula check screen 300 to the formula check screen 300'shown in FIG. 13 in response to the operation of the button 312 of the formula check screen 300. When the transition from the input screen 400 to the formula check screen 300', the values displayed in the input areas 2161, 2171 and 2181 and the characteristic value display unit 230 cannot be changed and can only be viewed.

FIG. 15 is an example flowchart showing the calculation process according to the embodiment. Prior to executing the process according to the flowchart of FIG. 15, the user inputs the product number code, the product variation characteristic value, and the number of members in the input areas 4101, 4111, and 4121 in the above-mentioned input screen 400, respectively. When the input to the input areas 4101, 4111 and 4121 is completed, the process according to the flowchart of FIG. 15 is started.

In step S10, the calculation processing unit 114 receives the product number code (product code), the product variation characteristic value, and the number of members, which are input to the input areas 4101, 4111, and 4121 of the input screen 400 at the time of executing the calculation. Further, the calculation processing unit 114 acquires the value of the item "conversion unit" displayed in the display area 4132 as a unit for the calculation result.

In the next step S11, the calculation processing unit 114 refers to the product number master 123 based on the product number code acquired in step S10, and from the items "product number name" and "product type", the product number name and product type corresponding to the product number code are selected. Identify. The calculation processing unit 114 refers to the product type master 124 and specifies the product type code corresponding to the specified product type from the item “product code”. Further, the calculation processing unit 114 refers to the characteristic definition master 121 for each product type, and acquires the category category corresponding to the specified product type from the item “category category”. Here, the calculation processing unit 114 specifies at least the value of the item "characteristic" of the category category "product number fixed characteristic" corresponding to the product type. When the category classification corresponding to the product type further includes the “product type fixing characteristic”, the calculation processing unit 114 further specifies the value of the corresponding item “characteristic”.

In the next step S12, the calculation processing unit 114 specifies the target calculation definition master 126. That is, the calculation processing unit 114 has the product type (R100) specified at the time of specifying the product type code in step S11, the calculation result unit (R101) acquired in step S10, and the product variation characteristic value (R102) acquired in step S10. The target calculation definition master 126 is specified based on the threshold determination for.

The threshold value determination for the product variation characteristic value in step S12 will be described. For example, when a plurality of calculation definition masters 126 whose product types and calculation result units match are stored in the storage unit 120, the calculation processing unit 114 may use the item "key item" from each of the plurality of calculation definition masters 126. The value of "variation characteristic threshold" (variation characteristic threshold) is acquired. The calculation processing unit 114 specifies the maximum fluctuation characteristic threshold value that is equal to or less than the product fluctuation characteristic value acquired in step S10 among the plurality of acquired fluctuation characteristic threshold values. The calculation processing unit 114 specifies the calculation definition master 126 in which the specified fluctuation characteristic threshold value is set from a plurality of calculation definition masters 126 stored in the storage unit 120 as the target calculation identification master 126.

In the next step S13, the calculation processing unit 114 acquires the calculation definition master 126 of the target specified in step S12 from the storage unit 120. That is, in steps S10 to S12 described above, the key items "type", "variation characteristic threshold value" and "calculation result (calculation result unit)" in the calculation definition master 126 are specified (R103, R104, R105). The calculation processing unit 114 acquires the target calculation definition master 126 from the plurality of calculation definition masters 126 stored in the storage unit 120 based on the value of the specified key item.

In the next step S14, the calculation processing unit 114 maps a numerical value for each item category to the target calculation definition master 126 acquired in step S13.

More specifically, the calculation processing unit 114 uses the target calculation definition master 126 as a driving table, and sets the values of each characteristic of the product type fixing characteristic and the product number fixing characteristic specified in step S11 from the category-specific characteristic setting master 122. Acquire (R106). The calculation processing unit 114 associates each acquired value with the value of the item "item value code" corresponding to each value of the target calculation definition master 126. Further, the calculation processing unit 114 holds the product variation characteristic value input to the input area 4111 on the input screen 400 in step S10 as a value corresponding to the value "product variation characteristic" of the item "item classification" in the calculation definition master 126. (R107). Further, the calculation processing unit 114 holds the value of the number of members input to the input area 4121 in the input screen 400 in step S10 as a multiplier for the calculation result by the calculation formula defined in the calculation definition master 126 (R108). Furthermore, the calculation processing unit 114 is a fixed value set in the item "constant" of the calculation definition master 126 acquired in step S13, and a rounding process set in the items "parentheses other Start" and "parentheses other End". Holds the set value of (R109).

In the next step S15, the calculation processing unit 114 sets the values of the items "parentheses and other Starts", "operators", "item value codes", "constants" and "parentheses and other Ends" of the calculation definition master 126 in the record. Create an expression character string that represents the calculation formula by concatenating the order of the items and the item "serial number" of each record. The calculation processing unit 114 applies each numerical value mapped in step S14 to the created formula character string, and executes the calculation of the calculation formula by the formula character string. The calculation processing unit 114 multiplies the calculation result by the calculation formula by the number of members held in step S14 to calculate the final calculation result. This calculation result is displayed in the display area 4131 of the input screen 400 shown in FIG.

When the button 420 instructing the conversion quantity recalculation is operated on the input screen 400, the calculation processing unit 114 re-executes the processing from step S10 in the flowchart of FIG. Further, when the button 421 instructing the expression check is operated, the calculation processing unit 114 applies the expression character string created in step S15 and each numerical value mapped in step S14 to the expression character string. The calculated formula is passed to the screen generation unit 115.

The calculation processing unit 114 can perform unit conversion on the calculation result calculated in step S15, if necessary. The unit conversion is instructed by, for example, a user operation.

Each process according to the flowchart of FIG. 15 described above will be described more specifically by taking as an example the calculation definition master 126a for performing the weight calculation of the sheet steel described with reference to FIG. 10 (b).

Prior to executing the process according to the flowchart of FIG. 15, the user has a product number code “ITA_914 × 1829 × 6” and a product variation characteristic value “1,000” for the input areas 4101, 4111 and 4121 in the above input screen 400. , 000.00 ”and the number of members“ 100 ”, respectively. When the input to the input areas 4101, 4111 and 4121 is completed, the process according to the flowchart of FIG. 15 is started.

In step S10, when the calculation processing unit 114 executes the calculation, the product number code “ITA_914 × 1829 × 6” and the product variation characteristic value “1,000. Receive "00" and the number of members "100" respectively. Further, the calculation processing unit 114 acquires the value "Kg" of the item "conversion unit" displayed in the display area 4132 as a unit for the calculation result.

In the next step S11, the calculation processing unit 114 refers to the product number master 123 based on the product number code “ITA_914 × 1829 × 6” acquired in step S10, and changes from the items “product number name” and “product number” to the product number code. The corresponding product number name "plate steel 914 x 1829 x 6" and the type "plate steel" are specified. The calculation processing unit 114 refers to the product type master 124 and specifies the product type code “ITA” corresponding to the specified product type “plate steel” from the item “product code”. Further, the calculation processing unit 114 refers to the characteristic definition master 121 for each product type, and acquires the category category “type fixed characteristic” and “product number fixed characteristic” corresponding to the specified product type “plate steel” from the item “category category”. do. Further, the calculation processing unit 114 acquires the characteristic "specific gravity" corresponding to the acquired category category "type fixed characteristic" and the characteristics "thickness" and "width" corresponding to the category category "product number fixed characteristic".

In the next step S12, the calculation processing unit 114 identifies the target calculation definition master 126a. That is, the calculation processing unit 114 includes the product type “plate steel” specified when the product type code is specified in step S11, the calculation result unit “Kg” acquired in step S10, and the product variation characteristic value “1” acquired in step S10. , 000.00 ”, and the target calculation definition master 126 is specified.

The calculation processing unit 114 identifies a calculation definition master 126a in which the product type “plate steel” and the calculation result unit “Kg” match from the plurality of calculation definition masters 126 stored in the storage unit 120, and the specified calculation definition master From 126a, the value "0" of the item "variation characteristic threshold" which is a key item is acquired. In this case, only one calculation definition master 126a is acquired, the value of the item "variation characteristic threshold" in the calculation definition master 126a is "0", and the product variation characteristic value acquired in step S10 is "1,". Since it is "000.00", the fluctuation characteristic threshold value is specified as "0". Since the calculation definition master 126a satisfies this condition, it is specified as the target calculation definition master 126a. In the next step S13, the calculation processing unit 114 acquires the target calculation definition master 126a specified in step S12 from the storage unit 120.

In the next step S14, the calculation processing unit 114 maps a numerical value for each item category to the target calculation definition master 126a acquired in step S13.

More specifically, the calculation processing unit 114 uses the target calculation definition master 126a as a drive table, and has the value “7.85” of the product type fixing characteristic “specific gravity” and the product number fixing characteristic “thickness” specified in step S11. , And the respective values "6" and "914" of "width" are acquired from the category-specific characteristic setting master 122. The calculation processing unit 114 sets the acquired density value “7.85” and the thickness and width values “6” and “914” into the item “item” corresponding to each value of the target calculation definition master 126a. It is associated with the values "specific weight", "thickness" and "width" of "value code", respectively.

Further, the calculation processing unit 114 calculates the product variation characteristic value "1,000.00" input to the input area 4111 on the input screen 400 in step S10, and the value "product variation characteristic" of the item "item classification" in the calculation definition master 126a. Is retained as the corresponding value. Further, the calculation processing unit 114 holds the value “100” of the number of members input to the input area 4121 in the input screen 400 in step S10 as a multiplier for the calculation result by the calculation formula defined in the calculation definition master 126a. Furthermore, the calculation processing unit 114 holds a fixed value "1,000,000" set in the item "constant" of the calculation definition master 126a acquired in step S13. In the calculation definition master 126a, since the rounding is not set, the setting value of the rounding is not retained.

In the next step S15, the calculation processing unit 114 sets the values of the items "parentheses and other Starts", "operators", "item value codes", "constants" and "parentheses and other Ends" of the calculation definition master 126a in the record. Create an expression character string "(thickness x width x specific weight x length) ÷ constant" that represents the calculation formula by concatenating the order of the items and the item "serial number" of each record. The calculation processing unit 114 applies each numerical value mapped in step S14 to the created formula character string “(thickness × width × specific gravity × length) ÷ constant”, and applies the calculation formula “(6 × 914 × 7.85 ×”. "1,000.00) ÷ 1,000,000" is created, and the calculation of the formula is executed. In this example, the value "43.0494" is obtained as a calculation result. The calculation processing unit 114 stores the calculation result in, for example, the RAM 1002 or the storage 1004.

The calculation processing unit 114 multiplies the calculation result by the calculation formula by the number of members "100" held in step S14 to calculate the final calculation result "4304.94 kg". This calculation result is displayed in the display area 4131 of the input screen 400 shown in FIG.

[8. Second application example of the embodiment]
A second application example of the calculation definition master 126 according to the embodiment will be described with reference to FIGS. 16 and 17. The second application example is an example in which the calculation definition master 126 is applied to the weight calculation of the pipe material (pipe). FIG. 16 (a) shows a formula for calculating the weight of a pipe. The weight per 1 m of pipe (pipe material) is calculated using the formula "((outer shape-thickness) x thickness x 3.1416 x specific gravity) / constant". The constant is an example of FIG. 16A when the unit of thickness, width and length is "mm", the unit of specific gravity is "Kg / 1m ³ " and the unit required as a calculation result is "Kg". It becomes "1,000" like.

FIG. 16B shows an example of a calculation definition master 126b that defines a calculation formula corresponding to the formula of FIG. 16A. In the example of FIG. 16B, the figure according to the value "pipe" of the item "variety code" in the key item, the value "0" of the item "variation characteristic threshold", and the value "Kg" of the item "calculation result". The formula of 16 (a) is specified.

In FIG. 16 (b), according to the specified formula and the value of the item "item classification", the records of the serial numbers "0" to "8" are subjected to the "item classification", according to the order of the formula of FIG. 16 (a). The values of each item of "parentheses and others Start", "operator", "item value code", "constant" and "parentheses and others End" are set.

In FIG. 16B, for the serial number "0", the item "item classification" is set to the value "dummy", and the value "(" is set to the item "parentheses and other Start".

For each of the serial numbers "1" to "3", the item "item classification" is set to the value "product number fixed characteristic". For the serial number "1", the value "(" is set in the item "parentheses and other Starts", and the value "outer diameter" is set in the item "item value code". The serial number "2" is the item "operator". The value "-" is set in "", the value "thickness" is set in the item "item value code", and the value "(") of the item "brackets and others Start" of the serial number "1" is set in the item "parentheses and others End". The value ")" paired with is set. For the serial number "3", the value "x" is set in the item "operator", and the value "thickness" is set in the item "item value code".

For the serial number "4", the value "fixed value" is set in the item "item classification", the value "x" is set in the item "operator", and the value "3.1416" is set in the item "constant". To. For the serial number "5", the value "type fixed characteristic" is set in the item "item classification", the value "x" is set in the item "operator", and the value "specific weight" is set in the item "item value code". Will be done. For the serial number "6", the value "commodity fluctuation characteristic" is set in the item "item classification", and the value "x" is set in the item "operator".

For the serial number "7", the item "item classification" is set to the value "dummy", and the item "parentheses and others End" is paired with the value "(") of the item "parentheses and others Start" of the serial number "0". ")" Is set.

As shown in the pair of parentheses of serial numbers "0" and "7" and the pair of parentheses of serial numbers "1" and "2", multiple bracket operations can be set in the calculation definition master 126b. be. Further, as shown in the serial numbers "2" and "3", it is possible to set a plurality of the same item categories and item value codes.

FIG. 16 (c) shows an example in which a specific numerical value is substituted for the calculation definition master 126b of FIG. 16 (b) assuming a pipe (pipe material) having the product number name “pipe 165.0 × 5.0”. Is shown. For example, the calculation processing unit 114 may use the category-specific characteristic setting master 122 in FIG. 4 according to the values of the item “product code” and the item “item classification” in each record of the serial numbers “1” to “3” and “5”. Acquire the corresponding values "165" (outer diameter), "5" (thickness) and "7.85" (specific gravity), and set them as officially applicable values. The value "5" indicating the thickness is repeatedly used in the serial numbers "2" and "3". Further, in the record of the product variation characteristic of the serial number "6", the value "1,000" (length) input by the user is set as a numerical value to be officially applied. Further, in the record of the fixed value of the serial number "8", the value "1,000,000" is set according to the formula.

Since the calculation definition master maintenance screen 200 described with reference to FIG. 11 is similarly applicable to the calculation definition master 126b, detailed description thereof will be omitted here.

FIG. 17 shows an example of the formula check screen 300 corresponding to FIGS. 16 (b) and 16 (c). In FIG. 17, the same reference numerals are given to the portions common to those in FIG. 12 described above, and detailed description thereof will be omitted. Further, here, it is assumed that the formula check screen 300 is a screen displayed in response to the operation for the button 214 of the calculation definition master maintenance screen 200 described above.

The calculation formula creation unit 113 has the same items as the description on the formula check screen 300 of FIG. 12 according to the above-mentioned calculation definition master maintenance screen 200, that is, each item “parentheses and other Start”, “operator”, and “item” of the calculation definition master 126b. In each record, the values set in "value code", "constant", and "parentheses and other Ends" are concatenated from left to right according to the order in the record to create a character string. Further, the calculation formula creation unit 113 concatenates each character string created in each record in the order of the item "serial number" of each record, and generates an expression character string representing the final calculation formula. In the display area 310 of the formula check screen 300, the formula character string created in this way "((outer diameter-thickness) x thickness x [constant 3.1416] x specific gravity x length) / [constant 1,000" 000] ”is displayed.

On the formula check screen 300, the display area 311 displays a calculation formula in which a specific numerical value is applied to the calculation formula displayed in the display area 310. For example, the calculation formula creation unit 113 is input with reference to the product number master 123 and the category-specific characteristic setting master 122 based on the product number code input to the product number input screen displayed by the screen generation unit 115 in the same manner as described above. Acquire the characteristic numerical value in the category category "fixed product number characteristic" and the characteristic numerical value in the category category "fixed product number characteristic" corresponding to the product number code.

In the example of FIG. 17, for example, the product number code “PA_165.0 × 5.0” is input to the product number input screen. The calculation formula creation unit 113 refers to the product number master 123, and acquires the product number name “pipe 165.0 × 5.0” and the product type “pipe” corresponding to the input product number code “PA_165.0 × 5.0”. do. The calculation formula creation unit 113 refers to the category-specific characteristic setting master 122, and acquires the characteristic "specific gravity" corresponding to the acquired product type "pipe" and the characteristic numerical value "7.85 (Kg / 1m ³ )". .. Similarly, the calculation formula creation unit 113 refers to the category-specific characteristic setting master 122, and has the characteristics “thickness” and “outer diameter” corresponding to the acquired product number name “pipe 165.0 × 5.0”, respectively. The characteristic numerical values "5 mm" and "165 mm" corresponding to the above are acquired.

Further, the calculation formula creation unit 113 acquires the product variation characteristic value (“1,000 mm” in this example) input to the product number input screen.

The calculation formula creation unit 113 describes the acquired characteristics "outer diameter", "thickness" and "specific gravity" as the respective values "5 mm", "165 mm" and "7.85 (Kg / 1 m ³ )", and the product. A calculation formula is created by replacing the variation characteristic value "1,000" with the corresponding character string of the calculation formula displayed in the display area 310. The calculation formula "((165-5) * 5 * 3.1416 * 7.85 * 1,000) / 1,000,000" created in this way is displayed in the display area 311.

For example, when the calculation processing unit 114 executes the calculation according to this calculation formula, the value "19.729248" is obtained as the calculation result. The calculation processing unit 114 stores the calculation result in, for example, the RAM 1002 or the storage 1004.

[9. Third application example of the embodiment]
A third application example of the calculation definition master 126 according to the embodiment will be described with reference to FIGS. 18 to 23. The third application example is an example in which the calculation definition master 126 is applied to the volume calculation of a log. Logs are natural objects, and it is necessary to consider the taper according to the "length". Therefore, in this third application example, the formula used for the calculation is switched according to the "length". More specifically, two calculation definition masters 126 are prepared, one in which the taper is not considered and the other in which the taper is considered. A threshold value is determined for the input "length" as the product variation characteristic value, and which of the two calculation definition masters 126 is used is specified according to the determination result. In the following, the threshold value for "length" will be set to "6 m".

With reference to FIG. 18, the formula and calculation definition master 126 for performing the volume calculation of the log without considering the tapering will be described according to the third application example of the embodiment. FIG. 18 (a) shows a formula for calculating the volume of a log when tapering is not taken into consideration (“length” is less than 6 m). In this case, the volume of the log is calculated using the formula "(diameter x diameter x length) / constant" as a formula. Here, it is assumed that the unit of "diameter" is "cm", the unit of "length" is "m", the unit of the calculation result is "m ³ ", and the constant is "10,000". Further, in the case of log volume calculation, it is assumed that the calculation result is rounded to the third decimal place (for example, rounding).

FIG. 18 (b) shows an example of the calculation definition master 126c ₁ that defines the calculation formula corresponding to the formula of FIG. 18 (a). In the example of FIG. 18B, the value "log" of the item "variety code" in the key item, the value "0" of the item "variation characteristic threshold", and the value "cm ³ " of the item "calculation result" According to this, the formula of FIG. 18 (a) is specified.

According to the specified formula and the value of the item "item classification", the record with the serial number "0" is a record for setting the rounding, and the item "parentheses and other Starts" indicates the start position of the rounding. The value "rounding to the nearest whole number (") is set. In the record of the serial number "1", the value "(" is set in the item "parentheses and other Starts" and the value "diameter" is set in the item "item value code". In the record of "2", the value "x" is set in the item "operator" and the value "diameter" is set in the item "item value code". The record of the serial number "3" is set in the item "operator". The value "x" is set. Since this record is a record of the product variation characteristic value and the value used for the calculation is input by the user on the input screen described later, the item "item value code" of the record is set. Is left blank.

The record with the serial number "4" is a dummy record, and the value "(" paired with the value "(") of the item "parentheses and others Start" of the record with the serial number "1" is added to the item "parentheses and others End". Is set. The record with the serial number "5" is a record with a fixed value, and the value "÷" is set in the item "operator", and the officially specified value "10,000" is set in the item "constant". Will be done. The record with the serial number "6" is a record for setting the rounding that is paired with the record with the serial number "0", and the end position and the number of digits of the rounding are set in the item "parentheses and other Ends". The indicated value ") Rounding end (3 digits)" is set.

A formula and a calculation definition master 126 for performing a log volume calculation in the case of considering tapering according to the third application example of the embodiment will be described with reference to FIG. FIG. 19A shows a formula for calculating the volume of a log when tapering is taken into consideration (“length” is 6 m or more). In this case, the volume of the log is calculated using the formula "([diameter + {(length-4) / 2}] ^ 2 x length) / constant" as a formula. Here, it is assumed that the unit of "diameter" is "cm", the unit of "length" is "m", the unit of the calculation result is "m ³ ", and the constant is "10,000". Further, as in the formula of FIG. 18A, it is assumed that the calculation result is rounded to the third decimal place. Further, as can be seen from FIG. 19 (a), this formula includes triple brackets (quadruple brackets including the brackets for the entire numerator of the fraction) and a power calculation with the value "2" as the root. ..

FIG. 19 (b) shows an example of the calculation definition master 126c ₂ that defines the calculation formula corresponding to the formula of FIG. 19 (a). In the example of FIG. 19B, the value "6" is set in the item "variation characteristic threshold" in the key item, the value "log" of the item "variety code" in the key item, and the item "variation characteristic threshold". The formula of FIG. 19A is specified according to the value “6” of the item “calculation result” and the value “m ³ ” of the item “calculation result”.

According to the specified formula and the value of the item "item classification", the record with the serial number "0" is a record for setting the rounding, and the item "parentheses and other Starts" indicates the start position of the rounding. The value "rounding to the nearest whole number (") is set. The record with the serial number "1" is a record for setting the start position of the exponentiation according to the value "exponentiation" of the item "item classification", and is the record for setting the start position of the exponentiation calculation. In "Other Start", the value "power start (") indicating the start position of the power calculation is set.

In the record of serial number "2", the value "diameter" is set in the item "item value code". The record with the serial number "3" is a dummy record, and the value "+" is set in the item "operator". The record of the serial number "4" is a dummy record, and the value "(" is set in the item "parentheses and other Starts".

In the record of the serial number "5", the value "(" is set in the item "parentheses and other Start". This record is a record of the product fluctuation characteristic value, and the value used for the calculation is set by the user on the input screen. Since it is input, the item "item value code" of the record is left blank.

The record with the serial number "6" is a record with a fixed value, and the value "-" is set in the item "operator", and the value "4" specified in the formula is set in the item "constant". .. Further, in this record, the value "(" and the paired value ")" set in the item "parentheses and others Start" of the serial number "5" are set in the item "parentheses and others End". The record with the serial number "7" is a record with a fixed value, and the value "÷" is set in the item "operator", and the officially specified value "2" is set in the item "constant". .. Further, in this record, the value "(" and the paired value ")" set in the item "parentheses and others Start" of the serial number "4" are set in the item "parentheses and others End".

The record of the serial number "8" is a record for setting the end position and the root of the exponentiation whose start position is set in the record of the serial number "1" according to the value "exponentiation" of the item "item classification". Therefore, in the item "parentheses and other Ends", a value ") squared" indicating the end position and roots of the roots calculation is set.

For the record with the serial number "9", the value "x" is set in the item "operator". Since this record is a record of the product variation characteristic value and the value used for the calculation is input by the user on the input screen, the item "item value code" of the record is left blank. The record with the serial number "10" is a record with a fixed value, and the value "÷" is set in the item "operator", and the officially specified value "10,000" is set in the item "constant". Will be done. The record with the serial number "11" is a record for setting the rounding that is paired with the record with the serial number "0", and the end position and the number of digits of the rounding are set in the item "parentheses and other Ends". The indicated value ") Rounding end (3 digits)" is set.

Which of the above-mentioned calculation definition masters 126c ₁ and 126c ₂ is used depends on the product number input screen for displaying the calculation formula in the above-mentioned display area 311 or the information for performing the calculation by the calculation formula master 126. It is determined according to the product variation characteristic value input to the input screen 400 to be input.

In the calculation definition masters 126c ₁ and 126c ₂ , the values of the item "variety" and the item "calculation result" match. In this case, as described in step S12 of the flowchart of FIG. 15, the calculation processing unit 114 acquires the value of the item “variation characteristic threshold” from each of the calculation definition masters 126c ₁ and 126c ₂ . The calculation processing unit 114 specifies a fluctuation characteristic threshold that satisfies the condition of "the input fluctuation characteristic value or less and the maximum fluctuation characteristic threshold" among the acquired fluctuation characteristic thresholds.

As an example, when the value "5" is input as the product variation characteristic value, the value "6" set in the item "variation characteristic threshold" of the calculation definition master 126c ₂ is the input product variation characteristic value. It does not meet the conditions because it exceeds. On the other hand, since the value "0" set in the item "variation characteristic threshold" of the calculation definition master 126c ₁ satisfies this condition, the calculation processing unit 114 selects the calculation definition master 126c ₁ .

As another example, when the value "8" is input as the product variation characteristic value, both the calculation definition masters 126c ₁ and 126c ₂ are set to the item "variation characteristic threshold" (each is "0"). And "6") is less than or equal to the input value "8". On the other hand, in the calculation definition masters 126c ₁ and 126c ₂ , the value of the item “variation characteristic threshold” is larger in the calculation definition master 126c ₂ , so that the calculation processing unit 114 selects the calculation definition master 126c ₂ .

FIG. 20 shows a log having a product number name “log D55” with respect to the calculation definition master 126c ₁ of FIG. 18B, in which a value “5” having a threshold value “6” or less is input and selected as a product variation characteristic value. Here is an example of substituting specific numerical values assuming.

For example, in the record of the serial number "0", the calculation processing unit 114 sets the value "rounding off (") instructing the start and method of fraction processing according to the value of the item "parentheses and other Starts". In each record of "1" and "2", the corresponding value "55" (diameter) is acquired from the category-specific characteristic setting master 122 of FIG. 4 according to the values of the item "product code" and the item "item classification", and the formula is obtained. The value "55" indicating the diameter is repeatedly used in the serial numbers "1" and "2". In the record of the product variation characteristic of the serial number "3", the value "55" is set by the user. The input value "5" (length) is set as a numerical value to be officially applied. Further, in the fixed value record of the serial number "5", the value "10,000" is set according to the formula.

Since the calculation definition master maintenance screen 200 described with reference to FIG. 11 is similarly applicable to the calculation definition master 126c ₁ , detailed description here will be omitted.

FIG. 21 shows an example of the formula check screen 300 corresponding to FIGS. 18 (b) and 20. In FIG. 21, the same reference numerals are given to the portions common to those in FIG. 12 described above, and detailed description thereof will be omitted. Further, here, it is assumed that the formula check screen 300 is a screen displayed in response to the operation for the button 214 of the calculation definition master maintenance screen 200 described above.

The calculation formula creation unit 113 has the same items as the description on the formula check screen 300 of FIG. 12 according to the above-mentioned calculation definition master maintenance screen 200, that is, each item “parentheses and other Starts”, “operator”, and “s) of the calculation definition master 126c ₁ . In each record, the values set in "item value code", "constant" and "parentheses and other Ends" are concatenated from left to right according to the order in the record to create a character string. Further, the calculation formula creation unit 113 concatenates each character string created in each record in the order of the item "serial number" of each record, and generates an expression character string representing the final calculation formula. In the display area 310 of the formula check screen 300, the formula character string "rounded ((diameter x diameter x length) / [constant 10,000], 3 digits)" created in this way is displayed. The "3 digits" at the end of the character string expression indicates the number of digits in the rounding process.

On the formula check screen 300, the display area 311 displays a calculation formula in which a specific numerical value is applied to the calculation formula displayed in the display area 310. For example, the calculation formula creation unit 113 is input with reference to the product number master 123 and the category-specific characteristic setting master 122 based on the product number code input to the product number input screen displayed by the screen generation unit 115 in the same manner as described above. Acquire the characteristic numerical value in the category category "fixed product number characteristic" and the characteristic numerical value in the category category "fixed product number characteristic" corresponding to the product number code.

In the example of FIG. 21, for example, the product number code “LOG_D55” is input to the product number input screen. The calculation formula creation unit 113 refers to the product number master 123, and acquires the product number name “log D55” and the product type “log” corresponding to the input product number code “LOG_D55”. The calculation formula creation unit 113 refers to the category-specific characteristic setting master 122, and acquires the characteristic “diameter” corresponding to the acquired product number name “log D55” and the corresponding characteristic numerical value “55 cm”. In the cultivar "log", the cultivar fixing characteristic has not been set, and the corresponding characteristic is not acquired.

Further, the calculation formula creation unit 113 acquires the product variation characteristic value (“5” in this example) input to the product number input screen.

The calculation formula creation unit 113 replaces the value "55 cm" set in the acquired characteristic "diameter" and the product variation characteristic value "5" with the corresponding character strings of the calculation formula displayed in the display area 310, respectively. And create a calculation formula. The calculation formula "ROUND ((55 * 55 * 5) / 10,000,3)" created in this way is displayed in the display area 311. The "3" at the end of the calculation formula indicates the number of digits in the rounding process.

For example, when the calculation processing unit 114 executes the calculation according to this calculation formula, the value "1.5125" is obtained as the calculation result excluding the fraction processing, and the value is rounded to three decimal places to obtain the value. "1.513" is obtained as the final calculation result. The calculation processing unit 114 stores the calculation result in, for example, the RAM 1002 or the storage 1004.

FIG. 22 shows a log having the product number “Log D55” with respect to the calculation definition master 126c ₂ of FIG. 19B, in which a value “8” exceeding the threshold value “6” is input and selected as the product variation characteristic value. Here is an example of substituting specific numerical values assuming.

For example, in the record of the serial number "2", the calculation processing unit 114 has the corresponding value "55" (diameter) from the category-specific characteristic setting master 122 of FIG. 4 according to the values of the item "variety code" and the item "item classification". And set it as a numerical value that is officially applied. The records of the serial numbers "5" and "9" are records of the product variation characteristic, and the value "8" input by the user is set as the officially applied product variation characteristic value, respectively.

Since the calculation definition master maintenance screen 200 described with reference to FIG. 11 is similarly applicable to the calculation definition master 126c ₂ , detailed description here will be omitted.

FIG. 23 shows an example of the formula check screen 300 corresponding to FIGS. 19 (b) and 22. In FIG. 23, the same reference numerals are given to the portions common to those in FIG. 12 described above, and detailed description thereof will be omitted. Further, here, it is assumed that the formula check screen 300 is a screen displayed in response to the operation for the button 214 of the calculation definition master maintenance screen 200 described above.

The calculation formula creation unit 113 has the same items as the description on the formula check screen 300 of FIG. 12 according to the above-mentioned calculation definition master maintenance screen 200, that is, each item “parentheses and others Start”, “operator”, and “s) of the calculation definition master 126c ₂ . In each record, the values set in "item value code", "constant" and "parentheses and other Ends" are concatenated from left to right according to the order in the record to create a character string. Further, the calculation formula creation unit 113 concatenates each character string created in each record in the order of the item "serial number" of each record, and generates an expression character string representing the final calculation formula. In the display area 310 of the formula check screen 300, the formula character string created in this way is rounded ((diameter + ((length- [constant 4]) / [constant 2])) ^ 2 x length / [Constant 10,000], 3 digits) ”is displayed.

On the formula check screen 300, the display area 311 displays a calculation formula in which a specific numerical value is applied to the calculation formula displayed in the display area 310. For example, the calculation formula creation unit 113 is input with reference to the product number master 123 and the category-specific characteristic setting master 122 based on the product number code input to the product number input screen displayed by the screen generation unit 115 in the same manner as described above. Acquire the characteristic numerical value in the category category "fixed product number characteristic" and the characteristic numerical value in the category category "fixed product number characteristic" corresponding to the product number code.

In the example of FIG. 23, for example, the product number code “LOG_D55” is input to the product number input screen. The calculation formula creation unit 113 refers to the product number master 123, and acquires the product number name “log D55” and the product type “log” corresponding to the input product number code “LOG_D55”. The calculation formula creation unit 113 refers to the category-specific characteristic setting master 122, and acquires the characteristic “diameter” corresponding to the acquired product number name “log D55” and the corresponding characteristic numerical value “55 cm”. In the cultivar "log", the cultivar fixing characteristic has not been set, and the corresponding characteristic is not acquired.

Further, the calculation formula creation unit 113 acquires the product variation characteristic value (“8” in this example) input to the product number input screen.

The calculation formula creation unit 113 replaces the value "55 cm" set in the acquired characteristic "diameter" and the product variation characteristic value "5" with the corresponding character strings of the calculation formula displayed in the display area 310, respectively. And create a calculation formula. The calculation formula "ROUND ((55+ ((8-4) / 2)) ^ 2 * 8) / 10,000,3)" created in this way is displayed in the display area 311.

For example, when the calculation processing unit 114 executes the calculation according to this calculation formula, the value "2.5992" is obtained as a calculation result excluding the fraction processing, and the value is rounded to three decimal places to obtain the value. "2.599" is obtained as the final calculation result. The calculation processing unit 114 stores the calculation result in, for example, the RAM 1002 or the storage 1004.

As described above, in the embodiment, the calculation definition master 126 in which each element such as parentheses, operators, and values constituting the calculation formula is set for each item category is set for each product type, and the weight calculation and the volume are set. I try to do calculations. Therefore, it is possible to easily confirm and set a calculation formula for calculating the weight and volume of a product having a product number belonging to a product type, and point out an illegal part.

Further, the threshold value is determined for the product variation characteristic value that fluctuates for each product, and the calculation definition master 126 can be switched according to the determination result. Therefore, it is possible to easily perform a calculation for a product to which a formula different depending on the length is applied, such as a log.

[10. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed may be performed manually, or all the processes described as being performed manually may be performed. Alternatively, a part can be automatically performed by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and master configurations shown in this specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, in the above description, the calculation processing device 10 according to the embodiment is described to be composed of one computer, but this is not limited to this example. That is, the calculation processing device 10 according to the embodiment can also be configured as a system that operates a plurality of computers in an integrated manner.

Furthermore, the specific form of distribution / integration of the device is not limited to the one shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. Can be distributed and integrated into the configuration. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is particularly useful in the steel, wood and building materials industries.

10 Calculation processing device 110 Control unit 112 Calculation definition setting unit 113 Calculation formula creation unit 114 Calculation processing unit 115 Screen generation unit 120 Storage unit 121 Type-specific characteristic definition master 122 Category-specific characteristic setting master 123 Product number master 124 Product type master 125 Unit master 126 , 126a, 126b, 126c ₁ , 126c ₂ Calculation definition master 200 Calculation definition master maintenance screen 300, 300'Expression check screen 400 Input screen 1000 CPU
1002 RAM
1004 storage 1020 display

Claims (8)

It is a calculation processing device equipped with a control unit and a storage unit.
The control unit
A calculation definition setting means for setting a calculation definition master in the storage unit, which is associated with an operator and an item classification in which at least a product number fixed characteristic, which is a characteristic fixed to a product number, is input, using a product type as a key. ,
The operator in the calculation definition master and the item identifier corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master to create a character string, and the calculation definition master is used. A calculation formula creation means for creating a calculation formula by concatenating each of the character strings created in each record according to the record order of the calculation definition master.
The characteristic value corresponding to the input product number is acquired from the characteristic setting master set in the storage unit by associating the item identifier corresponding to the part number fixed characteristic with the characteristic value corresponding to the item identifier. , A calculation processing means for performing a calculation by the above formula using the acquired characteristic value, and
A calculation processing device characterized by comprising. The calculation definition setting means is
The calculation definition master in which the operator is associated with the item classification in which at least the product variation characteristic, the product number fixed characteristic, or the product fixed characteristic which is a characteristic fixed to the product type is input is set in the storage unit. thing,
The calculation processing apparatus according to claim 1. The control unit
Further provided with a screen generation means for generating a screen for displaying the calculation formula created by the calculation formula creation means by using the operator and the item identifier.
The calculation processing apparatus according to claim 1 or 2. The screen generation means is
To further generate a screen for displaying a calculation formula in which the characteristic value corresponding to the input product number acquired from the characteristic setting master is replaced with the item identifier corresponding to the characteristic value in the calculation formula.
The calculation processing apparatus according to claim 3. The calculation definition setting means is
It is a record that specifies at least the product variation characteristic, the product number fixed characteristic, a dummy indicating the start position and end position of parentheses for specifying the range in which the calculation is preferentially executed in the calculation formula, or only the operator. To set the calculation definition master in which the item classification in which a dummy indicating that is input is associated with the operator is set in the storage unit.
The calculation processing apparatus according to any one of claims 1 to 4, wherein the calculation processing apparatus is characterized. The calculation definition setting means is
At least the product fluctuation characteristic, the product number fixed characteristic, the fixed value used in the formula corresponding to the calculation formula defined in the calculation definition master, the information for specifying fraction processing for the calculation formula, or the calculation formula. To set the calculation definition master in which the item classification in which the information for specifying the exponentiation calculation is input and the operator are associated with the storage unit.
The calculation processing apparatus according to any one of claims 1 to 5, wherein the calculation processing apparatus is characterized. It is a calculation processing method executed by a calculation processing device having a control unit and a storage unit.
Executed by the control unit,
A calculation definition setting step for setting a calculation definition master in the storage unit, which is associated with an operator and an item category in which at least a product number fixed characteristic, which is a characteristic fixed to a product number, is input, using a product type as a key. ,
The operator in the calculation definition master and the item identifier corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master to create a character string, and the calculation definition master is used. A calculation formula creation step for creating a calculation formula by concatenating each of the character strings created in each record according to the record order of the calculation definition master, and
The characteristic value corresponding to the input product number is acquired from the characteristic setting master set in the storage unit by associating the item identifier corresponding to the part number fixed characteristic with the characteristic value corresponding to the item identifier. , A calculation processing step for performing a calculation by the above formula using the acquired characteristic value, and
A calculation processing method characterized by including. It is a calculation processing program to be executed by an information processing device having a control unit and a storage unit.
To be executed by the control unit
A calculation definition setting step for setting a calculation definition master in the storage unit, which is associated with an operator and an item category in which at least a product number fixed characteristic, which is a characteristic fixed to a product number, is input, using a product type as a key. ,
The operator in the calculation definition master and the item identifier corresponding to the item classification associated with the operator are concatenated in the record of the calculation definition master to create a character string, and the calculation definition master is used. A calculation formula creation step for creating a calculation formula by concatenating each of the character strings created in each record according to the record order of the calculation definition master, and
The characteristic value corresponding to the input product number is acquired from the characteristic setting master set in the storage unit by associating the item identifier corresponding to the part number fixed characteristic with the characteristic value corresponding to the item identifier. , A calculation processing step for performing a calculation by the above formula using the acquired characteristic value, and
A computational processing program characterized by including.

Images