JPH02244227A - Data entry method - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

[Detailed Description of the Invention] (Industrial Application Field) The present invention automatically generates a rule for writing data into a table, and uses this rule and data entered by an operator in a part of the table to create a table. Concerning how to input table data to create a table.

[Conventional technology]

In the conventional automatic table data input method, a rule creator organizes and analyzes the performance data in one table, finds data regularities between operator input items and automatic input items, and creates rules based on the results. This is a method of automatically inputting information using this rule.

In addition, as a prior art related to the present invention, for example, the knowledge benefit method MAKE for expert system development (Source): Information Processing Society of Japan 36th National Conference (first half of 1988) Collected Papers (If) p 1483 +p148
4J is mentioned.

[Problem to be solved by the invention]

In the above-mentioned conventional technology, (1) Before inputting the rules into a computer, the rule creator must organize and analyze the performance data in one table to find the regularity of the data among the input items in the table.

(2) Due to changes in business, etc., the regularity of data between input items changes. Therefore, the rule creator must investigate all historical locations and modify the rules that have already been created.

As a result of the above, there has been a problem in that it takes time and effort to create or modify rules.

An object of the present invention is to save the effort of creating and modifying rules by automatically generating rules for writing data into automatic input items of tables.

[Means to solve the problem]

In order to achieve the above object, one aspect of the present invention is as follows.

(1) means for generating automatic input rules; and (2) means for creating data for automatic input items using the automatic input rules. The above means (1) and (2) will be explained below.

(1) Automatic input rule generation means This means generates automatic input rules according to the steps (a) to (e) above.

(a) Create arbitrary pairs for operator input items and automatic input items.

(b) For each set of operator input items, create a combination with a set of automatic input items.

A certain set of operator input items is O1, and a set of automatic input items is Ai.
If (i = 1.2 - n, where n indicates the number of sets of automatic input items), the combination of a certain set of operator input items and each set of automatic input items is (O, AI ) It can be expressed as

(O) Obtain the actual value of the above combination (O, AI) from the actual value in the table.

(d) Then, for each different performance value of 0, count the number of cases where the AI takes different performance values.

(e) If this total value is more than a certain number, set the input rule as if (O=O*), then(At
=A-). (Here, 0 = (Ot s
, 0 + *...0f-) , O fist = (O
Low, 012 umbrella...OIn skewer), Ol- is OIJ
This is the actual value. ) Then, the steps (b) to (e) above are performed for all sets of operator input items to create input rules.

(2) Means for creating data for automatic input items This means:
It consists of (a) means for extracting automatic input rules, and (b) means for writing data into automatic input items.

(a) Means for extracting automatic input rules The computer stores the input data input by the operator into the operator input items of the table.

Next, for each row, the input operator input data is
Select a rule that matches the conditions on the f side.

(b) Method of writing data into automatic input items (
Using the automatic input rule extracted in step a), write the actual value of the set of automatic input items held by the automatic input rule into the automatic input item of the corresponding row of the table.

In addition, in (b) above, any automatic input order 1 of a certain line
For one set, multiple rules for inputting data are extracted, and between the multiple rules.

When the performance values of sets of automatic input items held by rules are different, a rule with a large number of input items in the set of operator input items is extracted.

[Effect]

In the method of creating automatic input rules, a combination of input data consisting of operator input data and automatic input data is created using actual data for each row of a table, and the number of occurrences is determined from among the created combinations. Since combinations that reach a value are extracted and automatic input rules are created using the extracted combinations, input rules can be automatically generated without the intervention of a rule creator.

Further, by defining a set of operator input items and a set of automatic input items in advance and creating automatic input rules within these ranges, the rule creation process can be simplified.

In addition, in the method of automatically generating automatic input rules, the table created using the automatic input rule is stored in the computer, and when the number of stored tables reaches a preset number, the actual data of the table is Since automatic input rules are automatically generated using

In addition, in the method of writing data into the automatic input items of a table using automatic input rules, even if multiple rules for inputting data are extracted for a given set of automatic input items in a certain row, the operator input Since a rule with a large number of input items in a sequential set is activated, it is possible to prevent data with different values from being duplicated and output to automatic input items in a table.

〔Example〕

An embodiment of the present invention will be described below with reference to FIG.

FIG. 1 is a flow diagram showing a procedure for creating an automatic input rule and using the rule to create data for automatic input items.

The processing details will be explained below.

Process 11: Record data in a table with m rows and n columns consisting of operator input items and automatic input items.

An example of the performance data in the table is shown in Figure 4.

Process 12: Using the performance data in the table, create a combination of input data consisting of data for operator input items and one data for automatic input items for each row. Then, combinations with a large number of occurrences are extracted from among the combinations. Then, using the extracted combinations, operator input data is stored in the if part of the rule statement, and then automatic input data is stored in the than part to create an automatic input rule.

Process 13: Store the table in which data is entered into the operator input items in the computer.

An example of the table stored in the computer is shown in FIG. 8-(a).

Process 14: Create data for automatic input items in one table using operator input data and automatic input rules.

Figure 8 shows the state in which the data for the automatic input items in the table has been created.
Shown in (b).

FIG. 2 is a flow diagram showing a procedure for automatically generating automatic input rules.

The processing details will be explained below.

Process 21: Arbitrary sets are provided for operator input items and automatic input 1. Then, for each set of operator input items, a combination with a set of automatic input items is created.

For example, in the table data of FIG. 4, operator input item 6
Assume that the sets of 1 are (AiB) and (AiC), respectively,
Each set of automatic input items (X).

(X, Y)... and set the operator input item set (A).

If B) is fixed and a combination of that set and each set of automatic input items is created, ((Ai )l).

(X))t ((AiB), (X, Y))... roar.

Process 22: For each combination created in process 21, its performance value is acquired from the performance values in the table.

FIG. 5 shows the results of obtaining the actual values of the combinations from the first row 60 of the table data of FIG.

Process 23: Using the acquired combination of performance values, for each set of operator input items with different performance values, the number of occurrences of automatic input items having different performance values is totaled. Figure 6-(a),
(b) shows the results of counting the number of occurrences for each combination.

Process 24: Extract combinations for which the number of occurrences counted in Process 3 is greater than or equal to a certain number.

FIG. 1 shows the result of extracting combinations whose number of occurrences is a certain number or more from among FIGS. 6-(a) and (b).

Process 25: Using the actual values of the combinations extracted in Process 24, store the actual values of the set of operator input items in the if part of the rule, and store the actual values of the set of automatic input items in the than part of the rule. , create an input rule.

FIG. 3 is a flowchart for creating an input rule by defining a set of operator input items and a set of automatic input items in advance in a method for creating an automatic input rule.

Process 31: First, a set of operator input items and a set of automatic input items are set in advance.

Process 32: A combination with a set of automatic input items is created for each set of operator input items within a preset range.

In the process 33 and subsequent steps, rules are created using the same procedure as the process 22 and subsequent steps explained in FIG.

FIG. 9 is a flowchart illustrating the procedure for updating automatic input rules.

Process 91: Create a table using automatic input rules.

Process 92: Store the created table in the computer.

Process 93: Check whether the number of stored tables has reached a preset number.

Process 94: If the number of stored tables has reached the preset number, use the actual data of one table,
Create combinations of input data.

Process 95: Create a statistical table using the combination of input data.

Process 96: Create an automatic input rule using the combination of input data of the statistical table.

FIG. 10 is a flow diagram illustrating a method for inputting data into automatic input items in a table using automatic input rules.

Process 101: Import the input data entered by the operator into the operator input items in the table into the computer, and check that the actual value of the set of operator input items held by the input rule matches the value of the input data. Extract the rules from the auto-input rules.

Process 102: For each row, it is checked whether a plurality of rules for inputting data have been extracted for the set of automatic input items.

Process 103: If multiple rules for inputting data are extracted in process 102, check whether the actual values of the set of automatic input items held by the rules are different between the rules. .

Also, in process 102, the rule for inputting data is 1.
If the data is extracted, the data is written into the automatic input field using that rule.

Process 104: If it is determined in process 103 that the actual values of the set of automatic input items are different between the rules, select the rule with the largest number of items in the set of operator input items from among the extracted rules. Activate it and write the actual value of the set of automatic input items held by the rule to the set of automatic input items in the corresponding row of the table.

Further, in process 3, if it is determined that the actual values of the set of automatic input items match between the rules, data is written into one input item of the table using any of the rules.

[Effects of the Invention] According to the present invention, it is possible to automatically generate input rules for writing data into automatic input items in a table, thereby eliminating the need for the operator to create rules.

[Brief explanation of drawings]

Fig. 1 is a flowchart of automatic input rule creation and table creation according to an embodiment of the present invention, Fig. 2 is a flowchart of automatic input rule creation according to an embodiment of the present invention, and No. 3N is a flowchart of automatic input rule creation according to an embodiment of the present invention. Rule creation flow diagram. Fig. 4 is an explanatory diagram of the actual data in the table, Fig. 5 is an explanatory diagram of input data combinations, Fig. 6 is an explanatory diagram showing the relationship between combinations and the number of occurrences, Fig. 7 is an explanatory diagram of the statistical table, FIG. 8 is an explanatory diagram of a creation table, FIG. 9 is a flow diagram showing an embodiment of an automatic input rule updating method, and FIG. 10 is a flow diagram showing a method of starting an automatic input rule in the embodiment. Fig. 1. Fig. 1. Fig. 1. Otsumata [α]. 5th leap 5a F5'-bl and $1. 3rd sword (α) (b) 4.

Claims (1)

[Claims] 1. A method for inputting data into a table consisting of operator input items into which data is input by an operator and automatic input items into which data is written by activating an input rule. ,
Rules for creating data for automatic input items (hereinafter referred to as automatic input rules) are automatically generated using the actual data in the table, and when the operator inputs data into the operator input items when creating the table, A data input method characterized by creating data for automatic input items using the input data and automatic input rules. 2. In a method of automatically generating input rules, (1) for each arbitrary set of operator input items, a combination with an arbitrary set of automatic input items is provided, and (2) a certain set of operator input items is set to O. , the set of automatic input items is A_i (i = 1, 2...n, where n is the number of sets of automatic input items), (3) For each different actual value of O, a different actual value of A_i (4) If this total value is greater than or equal to a certain number, register the input rule as if (O=O*), then (A_i=A_i*) (here, O=(O_i_1 , O_i_2・
..., O_i_m), O*=(O_i_1*, O_i_
2*..., O_i_n*), O_i_j* is O_i_
This is the actual value of j. ) (5) An automatic rule generation method characterized by performing the steps (2) to (4) above for all O's to create an input rule. 3. In the method according to claim 2, a set of operator input items and a set of automatic input items are defined in advance, and this set of operator input items is designated as O, and the set of automatic input items is designated as A. Within the range of the combination of O and A, (3) of the above claim 2, (
4) An automatic rule generation method characterized by creating an input rule according to the procedure of 4). 4. In the method of automatically generating automatic input rules, a table created using the automatic input rules is stored in a computer,
An automatic rule generation method characterized in that when the number of stored tables reaches a preset number, an input rule is created according to the input rule creation procedure according to claim 2 or claim 3. 5. In a method of creating data for automatic input items using automatic input rules, multiple rules for inputting data are extracted for a given set of automatic input items in a certain row, and the multiple rules are extracted. A data input method characterized by activating a rule having a larger number of items in a set of operator input items when the actual values of sets of automatic input items held by the rules are different.