JP2006119816A - Method and apparatus for processing table format data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an information processing method and an information processor capable of defining a document format by simple operation of the same level as specification operation for specifying a normal document format even in the case of a document format for specifying a change by setting an input condition of a data entry column on the basis of a condition of another data entry column and capable of automatically inputting/outputting data. <P>SOLUTION: The method for inputting/outputting data in a data entry area defined by a derived condition form for specifying a change in a data entry condition on a certain format on the basis of data or a data entry condition in another data entry area having the same item name on the same format comprises a step for defining the contents of a derived condition corresponding to one derived entry area and a reference base entry area and a step for identifying the data or the data entry condition of the corresponding base entry area and then generating data in the corresponding derived entry area on the basis of the determined definition contents of the derived condition. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to an information processing method and apparatus for processing data on a book table format.

  In the table format shown in FIG. 9 below, the matrix of data entry columns (cells) from the third row to the sixth row as viewed from the upper side of the table and from the second column to the seventh column as viewed from the left side are included in the matrix. The data field whose headword is “sales” and the data field whose headword is “YoY” are arranged in parallel, and the combination of these two data fields is three times in the horizontal direction. They are arranged repeatedly.

  In the table format shown in FIG. 9, in the data field having the character string “sales” as a headword, for example, in the data entry column (cell) on the second column and fourth row of the table, the item name “ The data for the item name “Sales” is tabulated and entered according to the aggregation condition that the data for “Year” is “2001” and the data for the item name “Product” is “Radio”. In the data entry column (cell) that is adjacent to the right side (on the third column of the table) and has the character string “YoY change” as the headword, the data is tabulated according to the following entry conditions. It has become so.

That is, in the data entry column (cell) whose headword is “YoY change”, the item name is included in the aggregation conditions of the data entry column (cell) whose headword is “sales” adjacent to the left side. The data of the item name “sales” is once aggregated according to the aggregation condition in which “2001”, which is the aggregation condition data for “year”, is replaced with “2000” corresponding to the “previous year”.
Next, with respect to the total value of the item name “Sales”, the ratio with the total value data in the data entry column (cell) of the item name “Sales” located on the left side is calculated and entered. It is like that.

  The data in the data entry column (cell) with the headline “YoY” has the data entry conditions and data in the data entry column (cell) with the word “sales” adjacent to the left side. In addition, it can be said that it is derived by a conversion operation on it.

In this way, when the data entry conditions of a certain data entry field (cell) are defined in a form that specifies a change or conversion to the data entry condition of another certain data entry field (cell), In this specification, this reference cell is referred to as a “base cell”, and by specifying a certain conversion for this “base cell”, a data entry column cell in which data entry conditions are defined is derived from Called “cell”.
In addition, in order to define the data entry condition of the “derived cell”, the change condition designated for the corresponding “base cell” is referred to as a “derived condition”.

In order to obtain the desired data output on the table format shown in FIG. 9 using the current technology and products, for example, the following series of user operations are required.
First, the table format shown in FIG. 51 is created in the data output application. This table format is the same as the table format shown in FIG. 51, with the column “TV”, “Radio”, and “Car navigation” in the first column as viewed from the left. From the first row, the data of item name “FY”, “2000”, “2001”, “2002”, “2003”, is entered. The data of the item name “sales” is entered in the matrix of the cells from the second column onward when viewed from the left side and the cells after the second row as viewed from above.

  Subsequently, using the data output application, the data file data is output and aggregated on the table format, and the table format of the output result is imported on the sheet of the spreadsheet application. Next, the output processing on the table format of FIG. 51 is processed using the editing processing function prepared in the spreadsheet application to obtain the table format shown in FIG.

That is, on the output result of the table format of FIG. 51, between the third column and the fourth column, and between the fourth column and the fifth column, “YoY change” is the headword, and no data is entered. A column is inserted, and the fourth and sixth columns of the table format of FIG. 52 are newly added. 51 is also added to the right side of the fifth column of the output result of the table format of FIG. 51, and a column in which no data is entered with “YoY change” as the headword is newly added. It is a column.
Further, on the table format of FIG. 52, a row for entering the total value of each column is added to the bottom row.

Next, in the table format shown in FIG. 52 in which the above data has been entered, an arithmetic expression is defined as follows using the arithmetic expression definition function prepared in the spreadsheet application, and is executed. That is, for the second, third, fifth and seventh columns of this table,
The respective data from the third row to the fifth row are summed, and the total result data is written in each cell on the fifth row at the same column position.

  Subsequently, on the table format shown in FIG. 52 created as described above, an arithmetic expression is defined as follows using the arithmetic expression definition function of the spreadsheet application, and is executed. That is, each data item whose headword on the third column of this table is “2001” is divided by each data item on the second column at the same row position, and the data of the division result is placed at the same row position. Fill in each cell on a fourth column.

  Also, each data whose headword on the fifth column of the table is “2002” is divided by each data on the third column at the same row position, and the data of the division result is at the same row position. Fill in each cell on the sixth column. Each piece of data whose headword on the seventh column of the table is “2003” is also divided by each piece of data on the fifth column at the same row position, and the data of the division result is at the same row position. Fill in each cell on the 8th column. The above calculation is similarly performed on the fifth line where the total result data is written.

  Finally, the second column is first deleted from the table format shown in FIG. 52 in which the above data entry has been made by using the edit processing function of the spreadsheet application. Subsequently, using the editing process function, a new row is added on the top row of the table, and the first row, the second row, and the table in FIG. Processing is performed so as to be equivalent in structure, and the target output table format is obtained.

  As described above, it is possible to obtain data output on a desired table format using current technology and products. However, these methods impose a work consisting of a plurality of steps on the user and individually. This work requires time and effort. In addition, these operations and operations cannot be easily performed as a large amount of general users who are not proficient in using these current products, as it requires appropriate learning.

  The present invention has been made in view of the problems of the prior art. As described above, the data entry condition in one data entry field (field) is the same as the data entry condition in another data entry field (field). For the table format defined by specifying the “derivative condition” that expresses the change to it as a standard, the form format definition can be made by the same level of simple operations as the normal format. It is an object of the present invention to propose an information processing method and apparatus capable of performing automatic data input / output with little user operation.

  Another object of the present invention is that the above-mentioned “derivative condition” is defined in a complicated manner by various formats, and even with a simple operation at the same level as the designation operation performed for the normal form format. An object of the present invention is to propose an information processing method and apparatus capable of performing form data definition and performing automatic data input / output that requires almost no user operation.

  Another object of the present invention is that the above-mentioned “derivative conditions” can be performed in a format that is complicatedly defined by various formats, and can be performed by anyone and can be understood and read by anyone. It is an object of the present invention to provide an information processing method and apparatus capable of performing form format definition and performing automatic data input / output requiring almost no user operation.

  Another object of the present invention is that, even for a form format in which the above-mentioned “derivative conditions” are defined in a complex manner by various formats, the derived conditions that are defined in a complex manner by various formats are used in daily communication between humans. It is an object of the present invention to provide an information processing method and apparatus that can be performed with high user affinity by defining natural language expressions as they are.

  Another object of the present invention is to define a derivation condition that uses natural language expressions as they are for everyday communication between humans, even for a form format in which the above-mentioned derivation conditions are defined in a complex manner by various formats. It is an object of the present invention to provide an information processing method and apparatus capable of deterministically achieving both user affinity and user instruction determinism.

In order to achieve the above object, a table format data processing method in an information processing apparatus according to claim 1 of the present invention is a data entry condition for defining data to be entered in one data entry area on a table format. Is a data entry area that is defined by the form of another data entry area with the same item name on the same table format, or by the form of a derived condition that directs changes to the data entry condition A method for inputting / outputting data in a table format including an entry area, the step of determining a content of a corresponding derivation condition for one derivation entry area and a base entry area which is a data entry area as a reference described above;
The method comprises the steps of identifying data in the corresponding base entry area or data entry conditions, and generating data in the corresponding entry entry area based on the above-mentioned definition of the derived condition definition.

The method according to claim 2 is a table format data processing method according to claim 1, wherein as data entry conditions in the corresponding base entry area, data to be referred to simultaneously with the data in the relevant base entry area, Or identifying from the table format a base record that is a combination of data entry areas of data to be referenced simultaneously with the data in the corresponding base entry area;
As a derivation condition, a step of defining a related data difference condition that indicates a change to specific data constituting the base record,
Based on the definition of the related data difference condition, the specific data constituting the base record is changed, and the data to be referred to at the same time as the data in the corresponding derived entry area as the entry condition of the corresponding derived entry area, or the applicable Generating a derived record that is a combination of data entry areas of data to be referenced simultaneously with data in the derived entry area;
And data in the corresponding entry entry area is obtained by outputting data on the derived record.

The method according to claim 3 is the table format data processing method according to claim 1 in which the data in the corresponding base entry area is used as the first operand and a specific operation is instructed. For the defined derivation conditions, an operation instruction condition indicating the type of operation and an operation operand condition indicating the generation condition of the second operand data of the operation having the same item name as the corresponding base entry area are defined. Step to put
Generating the second operand data for the derived entry area based on the operational operand condition;
Between the data in the corresponding base entry area, which is the first operand, and the second operand data, and the operation determined by the corresponding operation instruction condition is entered, and the result data is entered in the corresponding derived entry area. It is characterized by that.

The method according to claim 4 is the table format data processing method according to claim 3, wherein the operation operand condition is data to be referred to simultaneously with data in the corresponding base entry area, or corresponding Defining relevant data variance conditions that direct changes to the specific data comprising the base record, which is a combination of the data entry areas of the data to be referenced simultaneously with the data in the base entry area;
This is a combination of data or data entry areas that should be referred to at the same time when data is output to the corresponding “derived entry area” by making changes based on the relevant data difference conditions for the relevant base record. Generating a derived record;
And outputting data on the derived record to obtain data in the corresponding derived entry area, and using the output data in the derived entry area as the second operand.

  The method according to claim 5 is the table format data processing method according to claim 2 or 4, wherein a specific term used by the user to express the related data difference condition on a daily basis is assigned to the item name to which it belongs. In association with and registered in the dictionary means separately from other registered terms, by searching the dictionary registered terms for the character string associated with the corresponding entry area, the meaning registered in the dictionary Therefore, the definition content of the related data difference condition is defined.

The method according to claim 6 is the table format data processing method according to claim 3 or 4, wherein the user uses the specific term or the operation operand condition as a daily operation instruction condition. A specific term to be classified and registered in the dictionary means;
Based on the arrangement order of terms belonging to each of the above-mentioned sections constituting one character string, which is determined by the syntax rules of the language used, it belongs to each of the above-mentioned sections from the character string associated with the derived entry area. Searching and identifying registered terms;
And the contents of the calculation instruction condition and the calculation operand condition are defined based on the meaning of the registered term belonging to each category identified by the search.

Further, the method according to claim 7 is the table format data processing method according to claim 5, wherein referring to the dictionary, the step of identifying the belonging item name of the corresponding specific registered term is identified. In the order column of the belonging data determined for the belonging item name, obtaining the data in the position on the ordered row shifted by the change represented by the meaning of the corresponding registered term starting from the data in the corresponding base entry area;
And the corresponding item name data in the base record created for the corresponding base entry area is replaced with the data obtained based on the corresponding registered term, and the corresponding derived record is created.

The method according to claim 8 is the table format data processing method according to claim 3 or 4, wherein the user uses a specific term as an operation instruction condition on a daily basis to distinguish it from other registered terms. By registering in the dictionary means and associating the above registered terms with the corresponding derivation entry area,
The calculation type is determined according to the meaning represented by the corresponding registered term.

The method according to claim 9 is the table format data processing method according to claim 3, wherein the dictionary terminology is used by distinguishing a specific term used by the user as the operation operand condition on a daily basis from other registered terms. The steps to register with
Associating this particular registered term with the corresponding derived area;
In accordance with the meaning of the corresponding registered term, after reading the data from the corresponding table format, performing a calculation determined by the meaning of the relevant registered term;
And the obtained operation result data is used as the second operand.

  Further, the method according to claim 10 is the table format data processing method according to claim 5 or 6, wherein for the corresponding character string, based on the dictionary or the syntax rule of the language used, A specific designating operation for designating the definition content configuration information to be analyzed is added.

  The method according to claim 11 is the table format data processing method according to claim 5 or 6, wherein the character string is analyzed based on a dictionary or a syntax rule of the language used. It is characterized by having a specific graphical characterization indicating that it is definition content configuration information.

The method according to claim 12 is the table format data processing method according to claim 1, wherein each base entry area and each derived entry area are on the same line or column in the table format. And identifying data belonging to an item name different from the item names of the corresponding base entry area and the derived entry area;
Share data belonging to item names that are on the same row / column as described above and that are different from the item names in the corresponding base entry area and derived entry area in both the row and column directions of the table format. Identifying the combination of base and derived entry areas to be performed;
To identify the combination of the base entry area and the derived entry area on the table format.

A method according to claim 13 is a table format data processing method according to claim 2, which is on the same row or column in the table format and comprises a base entry area of the same item name. Associating a first calculation result entry field with the first set of data entry areas;
Associating a second calculation result entry field with a second set of data entry areas comprising each derived entry area corresponding to each base entry area constituting the first set of data entry areas; ,
A step of performing an operation defined for the first operation result entry column for the data in each base entry area constituting the first set and entering the operation result data in the first operation result entry column When,
For each data output from the data file in each derived entry area constituting the second set, an operation defined for the first operation result entry field is performed, and the operation result data and the first Performing a calculation in accordance with the calculation instruction condition with the data in the calculation result entry column, and entering the calculation result data in the second calculation result entry column;
It is characterized by having.

The table format data processing apparatus according to claim 14, wherein the data entry condition for defining data to be entered in one data entry area on the table format is another data having the same item name on the same table format. A data input / output device in a table format including a derived entry area, which is a data entry area defined by the form of a derived condition that directs changes to the data in the entry area or a data entry condition based on the data entry condition, Means for determining the contents of the corresponding derivation conditions for one derivation entry area and the base entry area which is the data entry area as the above-mentioned standard;
Means for identifying the data in the corresponding base entry area or the data entry conditions and generating data in the corresponding entry entry area based on the definition of the derived condition defined above;
It is characterized by having.

An information processing apparatus according to claim 15 is the table format data processing apparatus according to claim 14, wherein the data to be referred to simultaneously with the data in the corresponding base entry area as the entry condition in the corresponding base entry area. Or a means for identifying, from the table format, a base record that is a combination of data entry areas of data to be referenced simultaneously with data in the corresponding base entry area;
As a derivation condition, a means for defining a related data difference condition that instructs a change to the specific data constituting the base record;
Based on the definition of the related data difference condition, the specific data constituting the base record is changed, and the data to be referred to at the same time as the data in the corresponding derived entry area as the entry condition of the corresponding derived entry area, or the applicable Means for generating a derived record that is a combination of data fields of data to be referenced simultaneously with data in the derived fields;
And data in the corresponding entry entry area is obtained by outputting data on the derived record.

An information processing apparatus according to claim 16 is the table format data processing apparatus according to claim 14, wherein the data in the corresponding base entry area is used as a first operand, and a specific operation is instructed for the data. For the derivation condition defined in 1., the operation instruction condition indicating the type of the operation and the operation operand condition indicating the generation condition of the second operand data having the same item name as the corresponding base entry area are defined. Means to keep
Means for generating the second operand data for the derived entry area based on the operation operand condition;
Between the data in the corresponding base entry area, which is the first operand, and the second operand data, and the operation determined by the corresponding operation instruction condition is entered, and the result data is entered in the corresponding derived entry area. It is characterized by that.

An information processing apparatus according to claim 17 is the table format data processing apparatus according to claim 16, wherein the operation operand condition is data to be referred to at the same time as data in the corresponding base entry area, or Means for defining a related data difference condition for instructing a change to specific data constituting a base record, which is a combination of data entry areas of data to be referred to simultaneously with data in the corresponding base entry area;
This is a combination of data or data entry areas that should be referred to at the same time when data is output to the corresponding “derived entry area” by making changes based on the relevant data difference conditions for the relevant base record. A means of generating a derived record;
And outputting data on the derived record to obtain data in the corresponding derived entry area, and using the output data in the derived entry area as the second operand.

  As described above, according to the present invention, a data entry condition in a certain data entry field (field) represents a change to the data entry condition in another data entry field (field) as a reference. Even in the book table format that is defined by specifying the `` condition '', it is possible to automatically output data by a simple specification operation on the same book table format as the simple normal book table format The book table definition can be obtained, and the data output to the book table format as described above can be performed with much simpler and quicker than the current method.

  Further, according to the present invention, in the book table format in which the above-described “derivative conditions” are defined in various forms in a complicated manner, the natural language expression that is used daily for communication between humans is used as it is. Since it can be defined in the form used, it is possible to output data to the above table format easily and quickly, and everyone can do it immediately with almost no learning and proficiency, and everyone can immediately understand the definition. It can be done in a form with user affinity.

  Further, according to the present invention, in the book table format in which the above-described “derivative conditions” are defined in various forms in a complicated manner, the “derivative conditions” that use natural language expressions for everyday communication between humans are used as they are. Can be deterministically performed, so that data output to the book table format can be performed in a form that satisfies both user affinity and deterministic definition.

Hereinafter, the present invention will be described with reference to the accompanying drawings.
FIG. 1 shows a hardware system configuration of an information processing apparatus according to an embodiment of the present invention. In this system, the color image scanner 10, the keyboard 12, the mouse 14 and the digitizer 15 are suitable as input devices, the internal memory 16 and the external memory 18 as storage devices, and the display device 20 and the stamp device 22 as appropriate output devices. It is connected to the CPU 24 via an interface circuit (not shown). The CPU 24 is also connected to a telephone line or a communication line 27 via the communication device 26.
The color image scanner 10 reads characters, symbols, and figures in a document written on a sheet as color image information. The internal memory 16 and the external memory 18 store various electronic dictionaries, character fonts, files, and the like in addition to various programs that define processing or control operations of the CPU 24. The communication device 26 has a facsimile communication function.

FIG. 2 shows a list of operation modes related to creation of a book table in the system of the present embodiment. Main modes such as “Create document”, “Definition”, “Environment setting” are set, and these main modes are “Extraction”, “Definition interpretation”, “Definition information setting”, etc. Branches to the submode.
FIG. 3 shows a “main mode-view menu” displayed on the display screen 20 a of the display device 20. When the “mode” button that is always displayed in the lower left corner of the display screen 20a is selected and instructed, this “main mode-view menu” appears on the screen, and “document creation”, “definition”, “environment” appear at the lower right of the screen. A main mode selection button such as “SET” is displayed.

  When the “Environment setting” button is clicked in the “main mode-view menu”, the environment setting mode is selected. When switched to the environment setting mode, a screen as shown in FIG. 4 is displayed on the display screen 20a, and sub-mode selection buttons such as “definition distinction setting” and “definition information setting” are displayed in the lower right portion of the screen. Here, when the “definition information setting” button is clicked, the definition information setting mode is entered and displayed on the “definition element / entry information comparison table” screen as shown in FIG.

  5, in this embodiment, a plurality of definition systems such as “common” and “book table definition” are prepared, and a plurality of definition elements are set in each definition system. Of these, “book table definition” and each definition element of the system are used to set the format for data management on the book table, and each definition element of “common” is also shared with other definition system definitions Is done.

As shown in FIG. 5, each definition element is associated with one or more types of predetermined characters (character strings), symbols or figures. Some definition elements, for example, “round up” corresponding to the definition element “rounding”, represent the definition content of interest only by the entry information, and “ Some of the contents of the definition, such as “<>”, specify other entry information on the document. In addition, characters such as “○” corresponding to the definition element “registered word designation” indicate that the designated contents should be interpreted with reference to the application term dictionary. is there.

  The association between the definition element and the entry information as described above may be prepared from the beginning by the system, or the user may be able to set and register at any time by screen input. In any case, for example, definition element identification data having a variable data length corresponding to the comparison table of FIG. 5 is set for each definition element in a data format as shown in FIG. Each definition element identification data is held in a definition element identification data storage section 48 (FIG. 21) of a definition information recognition section described later.

  In the data format of “definition element identification data” in FIG. 6, the code of the definition system (book table definition) to which the definition element (for example, “rounded up”) belongs is set in the data field of “definition system code”. , The code of the definition element (rounded up) is set in the data field of “definition element type”, and the character string corresponding to the definition element (round up) in each data field of “configuration string / symbol string” A code (rounded up, rounded up ...) is set across predetermined delimiter identification data, and predetermined end identification data indicating the end of this data is attached to the last field.

  As described above, in this embodiment, definition elements for performing various definitions on a document are associated with characters, symbols, or figures that can be used as normal entry information representing normal document contents. However, as will be described later, when used as a definition element, special modification information (for example, color information) is attached to the entry information so as to distinguish it from normal entry information representing the document contents. In other words, the user can use the entry information that he / she is familiar with as normal entry information to represent the document contents as it is, but also add a special modification information to the definition to show the definition contents. It can be used as information.

When the “definition distinction setting” sub-mode selection button is selected on the “environment setting mode screen” in FIG. 4, a “definition information distinction instruction screen” as shown in FIG. 7 appears on the display screen 20a.
In FIG. 7, the “definition system” column lists definition systems such as “form definition”. The user only has to input the modification information or identification information of [color], [line modification], [line thickness], and [handwriting / printing] used for the entry information of each definition system at each position.
In the example of FIG. 7, for example, (blue) is entered in the [Color] field for the definition system of “book table definition”, and (red) is specified for the definition system of “format definition”. Since each definition element of “common” is shared by all definition systems, there is no need to set decoration information unique to “common”.

  When the above specification is completed, when an “end” button on the “definition information distinction instruction screen” is designated, a data format as shown in FIG. The definition information distinction data for each definition system is set in. This definition information distinction data is held in the definition information distinction data storage unit 50 (FIG. 21) of the definition information recognition unit described later.

Next, an example will be described in which data is totaled and output on a tabulation table freely created on a sheet by the user using this system.
For example, the user has the table format shown in FIG. 9 as a sheet, and intends to output the data of another data file or the data of another table format on this format. To do.

When referring to certain data in the table format, the data in the table format that is simultaneously referenced as the data constituting the "record" is generally subject to the creation rules that everyone follows when using the table format. Normally, it must be written in the same row or column in the table format with the corresponding data.
In this specification, when referring to certain data, the data in the table format that is simultaneously referenced as the data constituting the data and the record is referred to as the “related data condition”. In particular, the position on the table format in which the data "" is normally entered is referred to as "related data entry position".

  As described above, in the table format shown in FIG. 9, in the data field having the character string “sales” as a headword, for example, in the data entry column (cell) on the second column and the fourth row of the table. The “related data condition” is “2001” entered in the same second column for the item name “FY”, and “item” “product” is entered in the same fourth row. Radio ". In this data entry column (cell), the data of the item name “sales” is tabulated and entered using this “related data condition” as a tabulation condition.

In the data entry column (cell) that is adjacent to the right side (on the third column of the table) and has the character string “YoY change” as the headword, the data is tabulated according to the following entry conditions. It has come to be.
That is, in this data entry column (cell), data read from the “related data entry position” in the data entry column (cell) (“2001” for the item name “year”, “item” “product”) Is based on “Radio”), and “2001”, which is the data for the item name “FY”, is replaced with “2000”, which is the “previous year”. Once, the data of the item name “Sales” is aggregated, and then the data entry column (cell) of the item name “Sales” located on the left side of the aggregate value data of this item name “Sales” The ratio with the aggregated value data is calculated and entered.

  In order to define the data entry conditions for the data entry column (cell) with the character string “YoY change” as the headword, first the data read from the “related data entry position” (item name “year”) “2001” for item name “radio” for item name “product”) is the same as “related data condition” in the data entry column (cell) with “sales” adjacent to the left side as the headword. .

  Also, the “item name” in the data entry column (cell) whose headline is this character string “YoY” is the same as the data entry column (cell) whose headword is “sales” adjacent to the left side. “Sales”. In general, as one of the rules for creating the above-described table, a data entry column (cell) in which the association by explicit entry of “item name” is omitted is replaced with another data entry column (cell) and “ If the data at the “related data entry position” is shared, both must be regarded as sharing the “item name”.

  From the above, the entry conditions in the data entry column (cell) with the character string “YoY change” in the example of the table format of FIG. 9 as the headword can also be expressed as follows. That is, in this data entry column (cell), the data entry column (cell) of the item name “sales” located on the left side of the data entry column (cell) is used as a reference cell, and once against the “related data condition” of the reference cell. Then, the data of the same item name “Sales” is aggregated according to the “Related Data Condition” with some changes, and then the operation between the same item names is performed between this aggregated data and the standard aggregated data in the cell. The calculation result is entered.

  In the present specification, the cell serving as a reference in the “related data condition” referred to as the aggregation condition when the data is aggregated, which is the previous stage in the above-described two-stage processing for generating the data in the “derived cell”. The changes made to are referred to as “related data difference conditions”, and the operation contents between the same item names that are performed between the data in the reference cell and the aggregated data in the corresponding cell, which is the later stage, are It will be called "condition".

In this specification, as described above, the data entry condition of a certain data entry column (cell) is designated to be changed or converted based on the data or data entry condition of another data entry column (cell). In the present specification, a condition that designates this change is referred to as a “derivative condition”.
Also, the data entry field (cell) that serves as a reference for specifying this change is called a “base cell”, and the data entry field (cell) in which the data entry conditions are defined by specifying the “derivative condition” for the “base cell” This is called “derived cell”.

The “calculation condition” that defines the calculation between the same item names with the reference cell described above indicates one conversion operation for the data in the “base cell”. It can be said that it is one concrete form.
From the above, the data entry column (cell) whose headword is the character string “YoY change” is the data entry column (cell) whose headword is “sales” adjacent to the left side thereof. A “derived cell” that is a “base cell”, and the “derived data” is a “related data condition” in which the “related data difference condition” is changed to the “related data condition” of the corresponding “base cell”. "Derived cell" data output value determined by the "operating condition" with another operand.

  Note that the “calculation condition” may use data generated by other conditions as an operand, as in the example described later (other use example 1). In addition, when the “related data difference condition” is also specified alone without being combined with the “calculation condition” as in the example described later (other usage examples 3 and 4), the “base cell” “ Since the data in the “derived cell” is defined by changing the “related data condition” and generating the related data condition of the “derived cell”, it is one specific form of the “derived condition”. be able to.

  The user reads the above from the entry contents in the table on the premise of some dictionary (for example, product name master file...) Describing the association between each item name and its data name. For example, the item name “FY” is read from the entry data sequence “2001”, “2002”, “2003”, and the item name “product” is entered from the entry data sequence “TV”, In addition to “radio” and “car navigation”, it is read with the help of the headword “product name” written in the upper position adjacent to it. The correspondence between the item name “sales” and its data entry field (field) is read from the title of the table.

  In the table format of FIG. 9, the user uniquely reads the combination of “derived cell” and “derivative condition” from “year-on-year comparison” entered as a headword. That is, from the partial character string “previous year” that constitutes the term “year-on-year”, the “related data difference condition” that is the difference in the data aggregation conditions described above is read, and the “comparison ratio” of the partial character string sandwiching it is read. From the above, “calculation conditions” indicating that the above-described calculation is performed are read.

In this specification, a set of adjacent “derived cells” having the same item name and “derivative condition” is called a “derived data field”, and each cell constituting one “derived data field” is referred to as “derived data field”. A set of “base cells” is referred to as a “base data field”.
In the table of FIG. 9, as described above, headwords are entered in a matrix of cells from the third row to the sixth row as viewed from the upper side of the table and from the second column to the seventh column as viewed from the left side. The “base data field” for “sales” and the “derived data field” with the headline “YoY” are arranged in parallel, and the combination of these two data fields is three times in the horizontal direction. It will be arranged repeatedly.

  For each combination of the “base data field” and “derived data field”, the data of “2001”, “2002”, and “2003”, which are the data of the item name “year” on the first row, are displayed. It corresponds by sharing the horizontal position. For example, for the combination of the “base data field” of the headword “sales” arranged in the second column and the “derived data field” of the headword “YoY” arranged in the third column, “2001” in the data of the item name “year” corresponds in a form of sharing the horizontal position.

  The bottom row of the table has a total column for entering the total value as follows. In other words, the total column cell at the bottom of the data field with the headword “sales” is filled with the total value of the data of the item name “sales” in the same column. . The total column cells at the bottom of the data field having the headword as “YoY” are filled with data under the following conditions.

  That is, as described above, in the “derived cell” in which the headword in the table format is “YoY”, the “related data condition” of the corresponding “base cell” is temporarily processed as the above-described process. On the other hand, the data is aggregated according to the “related data condition” obtained by adding the change indicated by the “related data difference condition”. For each total column cell in the bottom row with the same headword as “YoY”, first, the data aggregated by this previous processing in each “derived cell” belonging to the same column is totaled, Next, the ratio calculation indicated by the corresponding “calculation condition” is performed between the total data and the total data in the total column cell having the headword “sales” located on the left side of the total data, The calculation result data is entered.

  The user enters the above entry conditions for the total column cell in the bottom row with the headword “YoY” as the substring “computation difference condition” in the headword “YoY”. It is read from "..." and the headword "total" written at the right end of the bottom line.

In the present system, the “define” operation shown in FIG. 10 is performed so that the definition contents as recognized by the user as described above are recognized in a regular manner without any ambiguity. This “definition” operation is performed by additionally entering definition support entry information that can be distinguished from normal entry information that is the original entry contents of the tabulation table. In the case of this example, the definition support entry information is distinguished from the normal entry information by filling in the (blue) color assigned to the definition system of “common” and “book table definition” as shown in FIG. I will do it.

  As the basis of “definition” in the summary table, first, “item definition” is performed to associate the item names of all data fields on the summary table. In the present specification, the data field in which “item definition” is performed is hereinafter referred to as “item definition data field”, and the item name used for “item definition” is referred to as “corresponding item name”.

The item definition data field is specified as follows. First, in the table format, data entry area cells that are not “base cells” or “derived cells” (hereinafter referred to as “normal cells”) have the same “corresponding item name” and are adjacent to each other. For each set of cells (hereinafter referred to as “normal data field”), the definition field symbol ““ ”” or “[]” of “field specification” is used to specify the data field range. The definition element symbol ““ ”” of “Field specification”, ““ ”and“ ””, or “[” and “]”, which are constituent symbols of “[]”, respectively, in both end cells of the corresponding cell column Fill in the designated position.
In the present specification, a data field for which a data field range has been designated as described above is referred to as a “designated data field”.

For data entry cells that are “derived cells”, “derived data field” that is a set (cell column) of adjacent “derived cells” that have a common “corresponding item name” and “difference condition” Each time, use the “field specification” definition element and specify the data field range in the same way.
For each data entry area cell that is a “base cell”, each “base data field” that is a set (cell column) of adjacent “base cells” having a common “corresponding item name” Specify the data field range in the same way.

In the case of this example, the above-described data field range is designated for each “base data field” and “derived data field” on each column from the second column to the seventh column of the table.
Note that the cell columns after the second column as viewed from the left on the bottom row of the table belong to the data entry column (data field) whose “corresponding item name” is “sales”, but this part is the data in the table. Since it is also a total value entry column, for the convenience of processing by the system, only the total column data field to be described later is defined and not included in the data field that is the subject of “item definition” that is to be performed now.

  Next, “corresponding item name” is defined for each “specified data field” defined as described above. In this system, this "corresponding item name" is defined by giving a character string specified as "item name" on the document to the specified field and the "specific relationship" described below. .

  First, if you want to use the character string originally written as a headword in the “specific adjacent position” of the corresponding data field as the “corresponding item name”, specify “item name designation” on both sides of the character string. It is only necessary to add each component symbol “<” and “>” of the definition element symbol “<>”. In this specification, the character string defined as “item name” using the definition element of “item name designation” on the document in this way, in particular, “item name designation character string” I will call it.

Here, the “specific adjacent position” of the data field is a position adjacent to the left side of the field when the cell column of the data field is arranged in the horizontal direction, and the cell column of the data field is In the case of being arranged in the vertical direction, it means a position adjacent to the upper side of the field.
In the case of this example, this method is used to specify the original entry contents on the table-the character string "product" and "sales" that are entered as headwords of the normal entry information, each adjacent to the lower side. It is defined as the “corresponding item name” of the data field.

  If the character string you want to use as the “corresponding item name” is not entered in the “specific adjacent position” of the corresponding data field as the entry word of the original entry content-normal entry information, the character string (blue ) Using the color definition support information, fill in the blank near the corresponding data field, specify the “item name” by the above definition element, and then use the “join line” of the definition element to Just connect with the specified data field.

In this example, by this method, the character string “year” added using the (blue) color definition support information is defined as the “corresponding item name” of the corresponding “designated data field”.
When the character string “year” is used as the “corresponding item name”, it is confirmed that it is registered as the “year / month / day item” category in the applied term dictionary 52 (see FIG. 29). Do it. Further, the definition of “corresponding item name” of “derived data field” may be omitted when the corresponding “base data field” is uniquely determined as in this example.

  In this output destination table format, “aggregation category” may be designated for each “corresponding item name”. For example, for the item name “Sales”, in order to specify that “Aggregation Category” is “Aggregation Value”, the definition element “Aggregation Value Specification” is placed on the right shoulder of the item name string “Sales”. Add "○" symbol as (blue) color definition support entry information. If there is numeric data that cannot be aggregated, such as the item name “Unit Price” on the table format, a definition element symbol indicating “Non-aggregated numeric data” is provided, and the right shoulder of the corresponding item name character string It should be attached to.

In addition, “key classification” may be designated for the item name that becomes a key at the time of aggregation. In a normally created multidimensional summary table, the data field of each key item is first a cell column arranged in one row or one column, and is parallel to each other at the uppermost end or the leftmost end of the table. Are arranged adjacent to each other, and no data of other item names is arranged in the upper or left direction in the cell column direction. A data field having the above conditions is referred to as an “independent item entry area” in this specification.

  In this system, as a general treatment to specify the key item of aggregation, by providing a definition element symbol indicating that it is a key item of aggregation, and attaching it to the right shoulder of the corresponding item name character string, Specify each data field individually. However, if the definition element symbol of this “key item specification” is not added to the table as in this example, the data field of the above “independent item entry area” is aggregated as the default user rule. The data field provided in the other table area is regarded as a data field of “non-key item” which is an item that is not a key item of aggregation.

  Next, on the document, for each “derived data field”, the “derivative condition” is defined. In this system, this definition is made by giving the above-mentioned “specific relationship” to the corresponding data field with the “derivative condition specification word” that is a character string defined as “derivative condition” in writing. Do it.

  In the case of this example, as the headword of each “derived data field”, the character string “YoY” in the “specific adjacent position” is defined as “interpretation designation” using (blue) definition support entry information. Enclose with element “○”. However, in the designation by the “interpretation designation” definition element “◯”, “partial ratio” and “previous year” which are partial character strings in the character string to be designated are respectively applied to the application term dictionary 52 (see below). 29), after confirming that the terms are registered as the “calculation designation 2” category and the “relative designation” category.

  In this example, as described above, the registered term “previous year” in the application term dictionary 52 in the system is used to define the contents of the “related data difference condition”. In the present specification, the specific term previously registered in the dictionary means of the system used for the definition of the “related data difference condition” is particularly referred to as “related data difference condition registration word”. To.

  The basic concept of this system is to let the system interpret and process the information according to the intended meaning when the user wrote it, using the information such as the character string written on the document as it is. To do. In order to make the system interpret the entry information by the user deterministically, the system performs the following.

First, as an interface with the user, a term that the system wants to interpret according to the meaning that the user uses everyday is registered in a specific dictionary means (application term dictionary 52) that can be referred to by both the user and the system. A part to be interpreted by the system on the document is specified by a specific specifying means. (Enclosed by the “interpretation specification” definition element “○”)
If the meaning of the registered terms in the dictionary means remains ambiguous and ambiguous, add meaning annotations in the interface with the user of the application term dictionary 52 (for example, user manual) Confirm the following.

  The system first interprets the designated character string portion according to the meaning determined by the dictionary means, and further interprets the relationship between terms in the language used (this example). In the case of, the meaning of the entire character string is determined after interpretation according to the syntax rules of Japanese).

  As described above, the character string whose meaning is uniquely defined as the definition information that constitutes the definition content satisfies the format and condition as the “derivative condition” defined by this system, and between a certain data field. When the above-mentioned “specific relationship” is given, the corresponding character string is defined as the “derivative condition designation word” of this data field. “Specific relationship” between a character string and a data field means that both are in a “specific adjacent position” or are connected by a “joint line” of the definition elements as described above. It is.

  The character string designated as the “derivative condition designation word” may include a term defined by the user in this system (for example, a character string defined as “item name”) in addition to the registered term of the dictionary means. Good. Even if the specified string satisfies the format and condition as a “derivative condition”, if it still has the possibility of being interpreted as a definition other than the “derivative condition” for the data field, For a corresponding character string, a “designating condition” is designated using a specific designating means. (For example, add “Define Condition Specification” definition element “△” to the corresponding character string)

  In this example, the partial character string “previous year” in the character string enclosed by the definition element of “interpretation designation” is “the previous year” of a standard year according to the meaning that the user normally uses. Is registered in the application term dictionary 52 as a registered term in the “relative designation” category, and “comparison ratio” is a registered term in the “arithmetic designation 2” category, which means a ratio to a certain reference data. It is registered in the application term dictionary 52.

  Now, for example, as shown in the following example, if the partial character string “previous year” in the headword character string “previous year value” of the derived data field is surrounded by the definition element of “interpretation designation”, the item of the corresponding data field The data for the name “FY” is “Derived Data Field” in which “2000” is the “previous year” of the data in the corresponding base data field, “2000”. To be defined.

  Further, as shown in FIG. 10 of this example, this character string “previous year” is used as a headword character string of “derived data field” as a registered word “comparison” in the “operation designation 2” category of the application term dictionary 52. When the sandwiched character string “YoY change” is surrounded by the definition element “O”, this character string “YoY change” refers to the registered words in the application term dictionary 52 and follows the Japanese syntax rules. Interpreted, and each “derived cell” in the “derived data field” should be filled with the ratio obtained by dividing the data in the relevant “base cell” by the data in the relevant “derived cell” obtained in the above case. Will be instructed definitely to the system.

  In addition, character strings other than “Item name specification character string” in the above-mentioned “specific correspondence” with the specified data field must be interpreted in the same way as when specified by the “interpretation specification” definition element “○”. It is also possible to omit the “interpretation designation” definition element “◯” by adding the promise of being performed between the user and the device.

  Finally, on the bottom row of the table, a total column in which the total value of each data field is entered is defined. In this system, first, for each continuous cell column (hereinafter referred to as “calculation result column data field”) in the calculation result entry column of the same type of calculation (for example, addition or average calculation...) In the same way as the specification of the field range of the definition data field, it is specified using the definition element symbol “[]” of “Field specification”. That is, for each “operation result column data field”, the constituent symbols “[” and “]” of the definition element symbol “[]” of “field designation” are entered in the cells at both ends thereof.

  Next, the “calculation result column designation word” of the “calculation result column data field” is defined. For the “calculation result column data field”, after confirming that the character string written in the “specific adjacent position” is a registered term of the “calculation designation 1” classification in the application term dictionary 52, The definition element symbol “○” of “interpretation designation” may be enclosed.

  In this example, the “total” characters entered in the cell adjacent to the left end of the total data field in the bottom row and the cell adjacent to the top end of the total data field in the rightmost column are stored in the application term dictionary 52 as “ After confirming that the term is registered as the “operation designation 1” category, it is surrounded by the definition element symbol “◯” of “interpretation designation”.

  When the registered term in the application term dictionary 52 that is to be used as the “calculation result column designation word” is not entered in the “specific adjacent position” of the “calculation result column data field” as the original entry content of the document—normally entered information In (blue) definition support entry information, the corresponding registered term is entered in a blank area near the corresponding “calculation result column data field”, and both are connected by the “joining line” of the definition element.

  In this system, as described above, specific terms used by the user on a daily basis (as normal entry information) are registered in the application term dictionary 52 (see FIG. 29), By enclosing this registered term with a definition element symbol “◯” of “interpretation designation”, it is converted into definition information having a predetermined meaning as understood by the user.

  That is, the “total” character surrounded by the definition element symbol “○” of “interpretation designation” is integrated with a separately designated data field to constitute one definition information in data management, and this designated total Each column (cell) in the data field will define that the sum of the numerical data entered in the other specific fields should be entered.

  If a term character string indicating operations such as “average” and “dispersion” is written at the position of the “total” character on the table format shown in FIG. After confirming that the term is registered as the “calculation designation 1” category in 52, it may be enclosed by the “interpretation designation” definition element symbol “◯”.

  “Interpretation designation” definition element symbol “○” surrounded by terms such as “average” and “variance” are the same as in “total”, and each column (cell) in the field specified separately Defines that the result value obtained by performing the corresponding operation should be entered for each numerical data entered in another specific field.

In the present specification, a set of specific entry fields (cells) storing the operation target data in the operation result entry field defined as described above is referred to as an “operation object data field”.
In the case of this example, for a total column cell, the “calculation target data field” is set on the upper side in the perpendicular direction to the total data field including the total column cell or on the left side in the perpendicular direction, and the item name “sales” Is a set of cells belonging to the data field.
For example, the “calculation target data field” of the total column cell in the second column from the left of the bottom row is the data field portion of the item name “sales” defined on the upper side in the vertical direction of the same column.

  Next, various functions for obtaining the desired data output by inputting the table format entry form defined by adding the definition support entry information as described above to the system will be described.

  FIG. 11 shows the configuration of the document input and document element data generation unit in the system of this embodiment. The document image input unit 30 includes an input device such as a color image scanner 10, a keyboard 12, and a mouse 14, a CPU 24 that executes an input routine, an internal memory 16 or an external memory 18 that once captures an input color screen, and the like. Consists of.

  The document image storage unit 32, the character / graphic pattern dictionary 36, and the document element data storage unit 38 use storage areas of the internal memory 16 or the external memory 18. The character / graphic element recognition unit 34 includes a CPU 24 that executes a character / graphic recognition processing program. The document image output unit 40 is mainly configured by a CPU 24 that executes a display control program, and a display device 20 that performs display output of a document image under the control of the CPU 24 or a communication device 26 that performs transmission output of a document image. The

The user sets a book cover sheet in the color image scanner 10, selects the “document creation” mode on the display screen 20a, and clicks the “character / graphic recognition” button.
In response to this click operation, first, a reading operation is performed by the image scanner 10, and a color image signal representing an image (all entry contents) of the book table document shown in FIG. 10 is taken into the image storage unit of the input unit 30. . The color image signal captured by the input unit 30 is decomposed into (black), (blue), and (red) color image signals in the form of signals, and the (black) image signal (( A blue image signal (blue) and an image signal (red) are stored in the black image storage unit 32a, the blue image storage unit 32b, and the red image storage unit 32c, respectively.

  Next, the character / graphic element recognition unit 34 recognizes individual characters and graphic elements in the document for each color (black, blue, red) for each document pixel data stored in the document image storage unit 32. To do. Here, the graphic element is a group of simple graphic patterns that can be easily recognized as lines, rectangles, and circles.

  For image recognition in this embodiment, for example, “image management data” set in advance in a data format as shown in FIG. 12 is referred to. In this “image management data”, as shown in FIG. 13, assuming that the input image is composed of a large number of pixels PX arranged on a matrix, data representing the number, dimensions, pitch, etc. of the pixels PX is set. ing.

  Character / graphic recognition in the character / graphic element recognition unit 34 is basically performed by recognizing line elements constituting individual characters and graphic elements. For the identification of the line element, various conventionally known methods may be used. For example, first, a set of dots having a specific color is found, and then a search is made in the adjacent quasi or surroundings to determine the direction in which the set of dots extends. This process is repeated, and the trace drawn by the set of dots is traced until it disappears (ends). If there is a location where the direction of the trajectory changes abruptly during the tracking, the location is identified as a bending point or cusp.

  The line element extracted in this way can be identified as one of the line element patterns set in advance by its shape and size. In the present embodiment, the character / graphic pattern dictionary 36 stores in advance the type of line elements constituting each character and figure and the significant positional relationship between the constituent line elements in a predetermined electronic dictionary system ( Registered). The character / graphic element recognition unit 34 combines the adjacent line elements extracted as described above with each other, and repeats the process of collating this with the character / graphic pattern dictionary 36, whereby individual characters, symbols, Recognize shapes.

  For example, a ruled line constituting a table such as a list is recognized as follows. That is, a line element extracted as a straight line in the recognition of a line element as described above is an order of magnitude longer than other line elements, and the straight line direction is relative to a horizontal line (X axis) or a vertical line (Y axis). If the inclination falls within a certain angle, the straight line is regarded as a horizontal ruled line or a vertical ruled line, and the position information is corrected so as to be parallel to the horizontal line or the vertical line. Further, when the distance between the end points of two extracted ruled lines or the distance between the end point of one ruled line and the other ruled line is within a certain value, the end points of both ruled lines overlap each other, It is considered that the end point of the ruled line is overlapped with the other ruled line, and the respective position information is corrected so that both ruled lines overlap in this way.

  The character / graphic element recognition unit 34 performs the character / graphic recognition processing as described above on each color (black, blue, red) image of the document inputted as an image, so that, for example, a character / graphic element recognition unit 34 Document element data is generated in a data format as shown in FIGS.

  FIG. 14 shows a data format example of document element data (character data) corresponding to one character. As shown in the figure, the character code, typeface, color, line thickness, line modification (solid line, dotted line, chain line, etc.), handwriting / printing (distinguishing whether it is handwritten or printed), entry position and size Data representing character length (character size) is sequentially set in a predetermined data field, and end identification data indicating the end of the document element data is added at the end.

  FIG. 15 shows a data format example of document element data (character string data) corresponding to one character string. As shown in the figure, "first character position" and "end line position" indicating the arrangement position of the character string, "line pitch" and "character pitch" indicating the format of the character string are set, and the character string Are set in the order of arrangement.

  FIGS. 16, 17, and 18 are data format examples of document element data (graphic element data) corresponding to one graphic element or symbol, respectively. As shown in FIG. 17, the data of the start end position and the end position is incorporated for the line segment. As shown in FIG. 18, for the ellipse, data of the center position (X / Y direction) and the diameter size (X, Y direction) are incorporated. As shown in FIG. 19, data indicating the position of a bending point or a cusp (a point where the direction of a line segment changes sharply) is incorporated in addition to the start and end positions for a rectangle, “<”, and the like.

If the table is constituted by ruled lines, the cells constituting the table are detected, and “cell data” is created for each detected cell. (FIG. 19) A cell is a rectangular area surrounded by a ruled line in the table and serving as a unit for entering data.
Cell detection can be performed, for example, as follows. The ruled line data constituting the table is sequentially taken out, and the ruled line or the ruled line position delimited by the extension is obtained in both the vertical and horizontal directions of the document. Next, for each square of the matrix generated by this ruled line position, whether or not each of the four sides is a ruled line part is searched. If it is a ruled line part, it is set as a cell boundary. By merging adjacent cells and repeating the same determination for the merged cells, the boundaries of the four sides of the cell are identified.
In the created “cell data”, only the position information (for example, the positions of the upper left corner point and the lower right corner point) is set at this stage.

  As described above, all entry information in each document inputted as an image is decomposed into individual characters, symbols, and figures and converted into document element data by the character / graphic element recognition unit 34. These document element data are stored in the document element data storage unit 38 for each document. Note that the image information corresponding to the entry information that has been subjected to the character / graphic recognition process and converted into the document element data may be deleted from the document image storage unit 32.

  The document image output unit 40 not only outputs a document image based on the image signal held in the document image storage unit 32 but also outputs it from the document element data stored in the document element data storage unit 38. The document image is output after being converted into an image signal via the graphic pattern dictionary 36.

When the document input and document element data generation processing is completed, a message to that effect is given from the system to the user through the display screen 20a, for example.
Next, the user selects the “definition” mode by clicking the “mode” button that is always displayed at the lower right of the display 20a, and selects and instructs the “definition interpretation” button on the screen. In response to this instruction, the following processing is performed in the system.

  FIG. 20 shows the configuration of the definition information recognition and format setting unit in the system of this embodiment. The definition element data generation unit 42 and the definition data generation unit 46 are configured by the CPU 24 that executes definition element data and definition data generation processing. The definition information identification data storage unit 48, the definition information distinction data storage unit 50, the applied term dictionary 52, the definition data storage unit 54, and the sheet group definition data storage unit 56 are stored in a predetermined storage area of the internal memory 16 or the external memory 18. Expanded on top.

  In this definition information recognition and format setting unit, first, the definition element generation unit 42 defines definition element identification data (FIG. 6) and definition held in the definition element identification data storage unit 48 and the definition information distinction data storage unit 50, respectively. With reference to the information distinction data (FIG. 8), each definition element entry information entered in each document based on the document element data (FIGS. 14 to 19) stored in the document element data storage unit 38 Data (definition element data) is generated.

  FIG. 21 shows a data format example of the definition element data. A “definition code” and “definition element code” for identifying the definition element entry information are set, and a pointer for referring to the document element data corresponding to the characters, graphics, and symbols constituting the definition element entry information Is set. For example, in the case of “[]” of “field designation”, a pointer for designating the address of the document element data corresponding to the constituent symbol “[”, “]” is set.

  When the data corresponding to the constituent symbols of the definition element entry information is detected not as character data representing one character but as partial data (for example, data for one character) in character string data representing a plurality of characters The character data or character string data is created for the newly applicable portion, and the character string data is newly created for the remaining portion excluding the portion of the corresponding constituent symbol from the corresponding character string. If the corresponding part is not located at both ends of the corresponding character string, another character string data may be created across the corresponding part.

  In order to generate definition element data, search is made for document element data having modification information assigned to the corresponding definition system, for example, (blue) color information. For character string data, the data for the corresponding character is further searched. When the definition element is composed of a pair of two symbols like the “field designation” definition element ““ ”, first, one component symbol is detected and the other component symbol paired with it is detected. Find out.

  When a plurality of other constituent symbols forming a pair are detected for one definition element constituent symbol, the selection may be performed as follows. For example, in the case of the definition element ““ ”of“ Field specification ”, a combination that does not include the same type of definition element constituent symbol“ “” or “” ”within the rectangle formed by the pair of constituent symbols is selected. do it.

For each definition element, the “definition code” and “definition element code” are determined by the above method, and the address of the document element data (graphic element data) of the symbols constituting the definition element entry information is designated. You can also decide the pointer.
Each definition element data obtained from the definition element data generation unit 42 as described above is stored in the definition element data storage unit 44.

  Next, the definition data generation unit 46 refers to the definition information distinction data (FIG. 8) held in the definition information distinction data storage unit 50, and defines the definition element data ( 21), with reference to the document element data (FIGS. 14 to 19) accumulated in the document element data storage unit 38, definition data is generated for each definition information written on the document.

  The procedure for creating the entire definition data in this example is shown in FIG. In this procedure, first, “field definition data” (FIG. 23) that defines all “specified data fields” in the table is created. (Step Al) Next, for each “designated data field”, “item definition processing” for identifying and defining the “corresponding item name” is performed. (Step A2) Subsequently, with respect to the “designated data field” that becomes the “derived data field”, “derived field definition processing” for identifying and defining the “difference condition” and the “base data field” is performed. (Step A3) Finally, “calculation result column definition data” for defining the “calculation result column” is created. (Step A4)

  In the procedure for creating the entire definition data, first, “field definition data” (FIG. 23) is created for all “designated data fields” in the summary table. (Step Al) A “field designation” definition element symbol “[]” or ““ ”” already extracted as definition element data is identified one by one, and a cell that is designated as a data field, Alternatively, the cell column is identified as a “designated data field”.

Detection of cell columns that make up the “designated data field” is performed by detecting cells that contain the definition element symbols of “field designation”, for example, “[]” and “[” and “]” respectively. Then, it can be performed by sequentially detecting cells connecting the cells at both ends.
For the detected cell row, a “cell data chain” (not shown) is created in which the cell data is sequentially connected from the first cell by the “pointer data” in the cell data, and then the cell data of the first cell The address is set to “first cell data address” in “field definition data”.

  If the “designated data field” cell configuration forms a matrix, for example, the cells in the first row are connected in order from the left, and the leftmost cell in the next second row is connected to the rightmost cell. Thereafter, the procedure of connecting the cells in the second row in order may be repeated.

  When “field definition data” is created for all “designated data fields”, “item definition processing” for identifying and defining the corresponding corresponding item names is performed for each “designated data field” detected above. (Step A2)

First, the definition element “joining line” drawn from the cell row of “designated data field” is searched. If there is a “join line” drawn from within the cell column and there is a character string (“item name specification character string”) specified as “item name” adjacent to the other end, this The character string is determined as the “corresponding item name” of the corresponding data field.
In this example, “item name designation character string” “year” added to the outside of the table is identified as “corresponding item name” of the corresponding “designated data field”.

If the “specified data field” does not have the “item name specification character string” connected by the “join line” of the definition element, the “item in the specified adjacent position” described above with respect to this “specified data field” The “name designation character string” is determined as the “corresponding item name” of the corresponding data field.
In this example, this method identifies “item name specification string” “sales” and “item name specification string” “product” as “corresponding item name” of the corresponding “designated data field”. become.

For each “designated data field”, the “corresponding item name” identified as described above is the character string data address of the corresponding character string in the “item name character string data address” in the corresponding “field definition data”. Is set. In this specification, “field definition data” in which “corresponding item names” are registered in this way is also referred to as “item definition data”.
As for the “designated data field” for which the “corresponding item name” is identified as described above, a code indicating that it is “normal data field” as an initial value in the “derivation classification” column in the field definition data Set “0”.

  Next, the following “category” is determined for the “item definition data” created above. First, it is determined whether each item definition is defined as a common condition “out-of-line” or on the “in-table” field. When an "item definition data field" is defined on the table as a set of multiple cells that are adjacent to each other, it is regarded as an "inside table" field and "common category" in the "item definition data" The corresponding code “0” is set in the column. In addition, the corresponding item “1” is set in the “item definition data” defined for the “out of line” field. In this example, “0” is set in the “item definition data” of all item names.

  Next, for each item definition on the table format, the item name is determined to be “total category”. For the character string that is the “corresponding item name” in each item definition, the definition element symbol “○” for “aggregate numeric specification” in “blue” and the definition element symbol “●” for “specify non-aggregate numeric value” What is necessary is just to detect that it is additionally written in the upper right adjacent part of the character string which is the predetermined position of the character string.

  If the definition element symbol “◯” of “aggregate numerical value designation” is detected and determined as “total numerical value”, the corresponding code “1” is set in the “aggregation classification” portion of the corresponding item definition data. When the definition element symbol “●” of “Non-aggregate numeric category designation” is detected and judged as “Non-aggregate numeric value”, the corresponding code “2” is set in the “Aggregate category” part of the corresponding item definition data In other cases, the corresponding code “0” is set in the “aggregation category” section as “non-aggregate non-numeric value”.

In the “item definition process” (step A2), subsequently, it is determined that the “corresponding item name” of each “item definition data” is registered in the applied term dictionary 52 as the “year / month / day item” category. If the determination is obtained, the corresponding code “3” is set in the “total category” column.

  In addition, for the item name of the “Year / Month / Day / Date” category, read the format in which the data character string belonging to the item name is entered from the corresponding table format, and create “Year / Month / Date Data Format Data”. Then, point from the “year / month / day data format data pointer” of “item definition data”. The “year / month / day data format definition data” is created in a different data format for each registered word (“year”, “monthly”,...) Belonging to the “year / month / day item” category. For example, “year format data” is created for the registered word “year”, and “monthly format data” is created for the registered word “monthly”.

  “Year format data” can be created, for example, as follows. First, it is determined whether the entry format of the corresponding character string is “era name type” or “year type”. Take out one data name character string written in it from the corresponding data field, and from the front of the character string, character strings representing the era name “Heisei”, “H”, “Showa”, If a portion matching “S”... Can be searched, it is determined as “era name type”, and if it cannot be searched, it is determined as “year type”. Character strings “Heisei”, “H”, “Showa”, “S”... Representing the era name are registered in advance in the specific dictionary means attached to the search process.

Next, the postfix “year” and “year” are searched from the rear of the corresponding character string, and the presence and type of these postfixes are identified. The character strings “year” and “year” representing these postfix words are also registered in advance in the specific dictionary means attached to the search process.
Finally, after confirming that the character string remaining from the above search is a numeric character string, the "numeric type" and the "number of digits" are identified. The determination result obtained above is registered in the “year format data”. The format of “Year format data” is shown in FIG.

  In the case of this example, for the item name “year”, for example, the data name character string “2001” is extracted from the corresponding data field, and the “era name / year type distinction” is “year type”, “ “Number of digits” is determined as “4”, “Number type” as “Arithmetic numbers”, “Postfix classification” as “Year”, and the corresponding data is set in “Year format data” .

  If the data name string is not entered in the corresponding data field, the definition support entry information (blue) will be used in the blank area near the relevant data field at the definition operation stage. A dummy character string indicating the format is entered and connected to the corresponding data field by the definition element “joint line”. As this dummy character string, the era name character string and the postfix character string are entered according to the target format, and the numeric data part is a specific symbol (for example, “*”) of the desired “number of digits”. Enter only the number.

  In the “item definition process” (step A2), it is determined that a “corresponding item name” is registered as the “year / month / day item” category in the applied term dictionary 52, and the corresponding data field contains If the data name character string is not entered, it is connected to the corresponding data field by the definition element “join line”, and the character string entered with the definition support entry information in (blue) Perform detection.

  If a constituent character string (an era name character string, a postfix character string ...) other than a numeric character string is detected from a predetermined position, and the specific symbol is detected from the position of the numeric character string, this character string is The date data format is regarded as a character string, and “year / month / day data format data” in which the detection result is registered may be created in the same manner as described above.

  In the “item definition process” (step A2), finally, “key classification” is determined for each created item definition data as follows. For the corresponding item name character string of each item definition data, it is detected that the definition element symbol “▽” of “key item designation” in (blue) color is additionally entered in the upper right adjacent part of the character string. If it is obtained, it is determined that the corresponding item name is “key item name”.

  When the corresponding item name character string of certain item definition data is determined as “key item name”, the corresponding code “1” is set in the “key item” portion of the corresponding item definition data. Also, other item definition data having the same corresponding item name is searched, and the corresponding code “1” is set in the “key classification” portion.

  After the above determination is made for the corresponding item name character strings of all item definition data on the document, it is determined that the item definition data that has not been designated as “key item” is “non-key item name”. The corresponding code “0” is set in the “key classification” portion.

  For all corresponding item name character strings in the table format, if the “key item specification” definition element is not additionally filled in, the above-mentioned “independent item” is defined for each data field defined in accordance with the default rule. If an item definition data field is "independent item entry area", the item name is determined as "key item name" and the other item names are "non-key item name". And

  The above "independent item entry area" can be detected on the table format as follows. First, the item definition data field arranged in the uppermost row or the leftmost column of the table is detected. Each item definition data defined on the table format is taken out, and it can be detected by repeatedly collating the cell data position information of the constituent cell with the cell data position information of other cells on the table format.

  Next, for the item definition data field on the top row or leftmost column of this detected table, confirm that no other item name data is placed in the upper or leftward position in the cell column direction. If this confirmation is obtained, the item definition data feed on the top row or the leftmost column of this table is regarded as an “independent item entry area”.

  Next, find the item definition data field that is arranged adjacent to and parallel to the detected “independent item entry area”, and similarly, the data of the other item names at the upper or left position in the cell column direction. After confirming that is not located, add it as an “independent entry area”. Accordingly, the item definition data fields arranged in parallel and adjacent to each other can be detected based on the cell data position information. By repeating the above procedure, all “independent item entry areas” on the table format can be detected.

  In the case of this example, since the definition element of “key item designation” is not additionally entered for all the corresponding item name character strings in the table format, the item name “year” and “ The data field of “commodity” is determined as the above “independent item entry area” and is registered as “key item”.

  When the “item definition process” (step A2) is finished, subsequently, the “designated data field” is identified as the “derived data field”, and the “base” corresponding to the “derivative condition” is identified. “Derived field definition processing” for identifying and defining “data field” is performed. (Step A3)

In this system, the category shown in FIG. 25 is handled as the format of the “derivative condition”. In FIG. 25, type 1 and type 2 are cases where the “derivative condition” consists only of the “related data difference condition”. In this case, the data value output by the “related data condition” obtained by changing the “related data condition” of the “base cell” according to the instruction of the “related data difference condition” is entered in the “derived cell”. The
Type 3 is a case consisting of only “calculation conditions”, and the calculation result of the data value in the corresponding base cell and the specified specific value is entered in the derived cell.

  Type 4 and type 5 are cases where the “derivative condition” is a combination of “related data difference condition” and “calculation condition”, and the “related data condition” of the corresponding “base cell” is included in the “derived cell”. An operation result of the data value output by the “related data condition” changed by the instruction of the “related data difference condition” and the data value in the corresponding “base cell” is entered. Type 1 and type 4 are when the “related data difference condition” designation method is “direct indication”. Type 2 and type 5 are when the “related data difference condition” designation method is “indirect indication” It is.

In this system, as a method for designating “calculation conditions”, it is assumed that designation by registered words in the “calculation designation 2” category in the application term dictionary 52 is handled. The designation method by “direct indication” of “related data difference condition” is handled as designation by “data name”, and the designation method by “indirect indication” of “related data difference condition” is applied term dictionary 52. It shall handle the designation by registered words in the “relative designation” category.
In the case of only “calculation difference condition” (type 3), the case where the registered term of the “calculation operand designation” classification in the application term dictionary 52 is used as its operand is handled.

In the “derived field definition process” (step A3), the procedure shown in FIG. 26 is performed. First, for each character string on the document, for example, it is determined that the format and condition as the “derivative condition designation word” are satisfied by the procedures of FIGS. 27, 28, and 29. (Step P1)

First, it is determined that the entire character string to be determined or a part of the character string has been specified by the definition element symbol “◯” of “interpretation specification”. (Step D1)
As in this example, if the character string to be judged has been designated by the “interpretation designation” definition element symbol “○”, then the character string to which the designation is received is placed at a predetermined position in the character string portion. Then, it is determined that a registered term of “calculation designation 2” in the applied term dictionary 52 is included. (Step D2)

  If it is determined in step D1 that the character string to be determined has not been designated by the “interpretation designation” definition element symbol “◯”, the procedure after step D15 is performed. This procedure will be described later in “Other use example 4”.

  FIG. 30 shows examples of terms included in the application term dictionary 52. In the applied term dictionary 52, registered terms are registered using “representative name” as a key, and information such as “synonyms” and “classification” is registered in association with each “representative name”. Each registered word whose “category” is “relative designation” is registered in association with “affiliation item name”. For example, a registered word “previous year” whose “category” belongs to “relative designation” is registered in association with the belonging item name “year”.

  FIG. 31 shows a data format of applied term definition data which is a unit of inclusion in the applied term dictionary. Application term definition data is created for each “representative name”. A corresponding character code string is set in the data field of “representative name”, “affiliation item name”, and “synonym”, and corresponding ID data is set in the data field of “classification”.

Registered terms in the “calculation designation 2” category in the application term dictionary 52 are usually used in Japanese by forming a compound word with other terms that are operands.
Registered terms in the “calculation designation 2” category in the application term dictionary 52 are “double-ended type” such as “to ** ratio”, “to ** ratio”, etc. ”And“ post ratio ”such as“ ** ratio ”and“ ** ratio ”. This arrangement relationship in forming the compound word is indicated in the applied term dictionary 52 by using a specific character string “**” for the position of the term as an operand.

  In order to detect registered terms in the “calculation designation 2” category in the application term dictionary 52, in the case of the above-mentioned “double sandwich type”, the character string to be determined is the front character (for example, “pair”) of this registered term. And a backward match with a rear character (for example, “pair”) may be determined. When the applied English dictionary registered term in the “calculation designation 2” category is “postfix type” as described above, it is only necessary to determine whether the character string to be determined is backwardly matched with the rear character of each registered term.

  In step D2, if no application term dictionary registered term in the “calculation designation 2” category is detected, the procedure after step D12 is performed. The procedure after step 12 will be described later in “Other use example 3”.

In step D2, when an application term dictionary registered term in the “calculation designation 2” category is detected as in this example, the remaining partial character strings in the determination target character string correspond to the operation operands. The thing is judged from the following items.
(1) Registered terms in the “relative designation” category in the application term dictionary (Step D3)
(2) Registered terms in the “operation operand specification” category in the application term dictionary (step D6)
(3) "Data name" defined by the user (Step D8)

  First, the “related data difference condition registration word” is determined for the remaining partial character strings of the determination target character string. (Step D3) As described above, in the present system, registered terms in the “relative designation” category in the application term dictionary 52 are handled as “related data difference condition registered words”. In this example, in step D3, the corresponding character string “previous year” is searched in the applied term dictionary 52 as a registered term of the “relative designation” category.

  If it is determined in step D3 that the partial character string to be determined is not a registered term in the “relative designation” category of the applied term dictionary 52, the procedure from step 6 is performed. The procedure after step 6 will be described in “other use example 1” described later.

  When the determination in step D3 is obtained as in this example, subsequently, the “affiliation item” registered in the applied term dictionary 52 in association with the corresponding “related data difference condition registration word”. Refer to "Name" and confirm that the "Affiliation Item Name" is defined as the corresponding item name of the item definition on the corresponding table format. (Step D4)

  In the case of this example, in this step D4, for the registered term “previous year” of the detected “relative designation” category, the belonging item name “year” is referred to in the applied term dictionary 52, and the item name “year”. Is defined as a corresponding item name in the item definition data field (data “2001”, “2002”, “data field in the top row in which 2003” is entered) on the table format) .

  When the above confirmation is obtained, the character string to be judged is combined with that of the type (5) as the “derivative condition” of the “derived data field” described above, together with the previous judgment process. It is determined that the condition is satisfied. (Step D5)

  In this system, a character string that is given the above-mentioned “specific relationship” with one data field and satisfies the above format and conditions is defined as the “derivative condition” of that data field. It is determined that the corresponding data field is a “derived data field” of a certain other data field, and the corresponding character string is its “derived condition designation word”. Is done.

  In the case of this example, each designated data field on the third column, the fifth column, and the seventh column is a character string “YoY change” written in its upper cell, and “derived condition designation word”. It is determined that it is a “derived data field”.

  In the “derived data field definition process”, next, the “designated data field” that is the “base data field” of the “derived data field” identified as described above is identified. (Step P2) This “base data field” can be identified by, for example, the procedure shown in FIG.

  As described above, a “base cell” corresponding to a certain “derived cell” is a cell sharing the data in the “related data entry position” with the corresponding “derived cell”. From the “specified data field” defined above, the data in the “related data entry position” of each constituent cell is the “derived data field” in the “related data entry position” of each constituent cell. Select the same data. (Step Q1)

  First of all, from the “designated data field” defined on the document, select the “designated data field” that is “placed in parallel” with the corresponding “derived data field”, and then select the cell. The data entered in the “related data condition position” on the upper side or the left side in the column direction may be the same as the corresponding “derived data field”.

  Here, the two data fields (cell rows) are arranged in parallel means that both constituent cells exist in one-to-one correspondence at the same position in the direction perpendicular to the cell row direction. is there. For example, by selecting a data field that is "parallelly arranged", the cell column direction and the positions of both ends of the cell column are the same as those of the corresponding "derived data field" and the positions of both ends of the cell column. Obtainable.

In the case of this example, for example, the designated data field on the second column is detected as the “base data field” corresponding to the “derived data field” on the third column of the above table.
“Derived cells” and their corresponding “base cells” belonging to both are on the same row, and the same data of the item name “product” on that row is used as the data in the “related data entry position” in the row direction. “Year” written in the cell created by merging across the 2nd and 3rd columns as data at the “related data entry position” in the column direction The data “2001” is shared.

Subsequently, when a “corresponding item name” is explicitly defined in the corresponding “derived data field”, the “corresponding item name” is further selected from the “specified data field” selected as described above. Is the same as the “corresponding item name” of the corresponding “derived data field”. (Step Q2)
At the beginning of step Q2, it is determined that “corresponding item name” is defined in the corresponding “derived data field”. If “corresponding item name” is not defined, the subsequent processing in step Q2 Is skipped and the process proceeds to the next step Q3.

  Finally, if, as a result of the above selection, the “base data field” is not yet uniquely determined for the corresponding “derived data field”, the “table placement rules that users normally follow when creating a table” ”Is placed on the left side of the corresponding“ derived data field ”(the upper side if the“ derived data field ”is arranged horizontally) and closest to the corresponding“ derived data field ” Select the designated field. (Step Q3)

  In the present example, in the case of the “derived data field” on the third column of the above table, the “corresponding item name” is not explicitly defined, so the selection process in step Q2 is skipped. In Step Q1, one “designated data field” is selected.

  As described above, in the table format, the “corresponding item name” in the data entry column (cell) in which the “corresponding item name” is not explicitly defined is the data sharing the data in the “related data entry position”. It is the same as the entry column (cell). From the above, the designated field on the second column selected in step Q1 is determined as the corresponding “base data field”.

  As described above, when a pair of “Base Data Field” and “Derived Data Field” and its “Derived Condition Specification Word” are identified, “Derived Condition Definition Data” is created and its address is set to “Derived Data Field”. "Derived condition definition data pointer" in the field definition data on the "" side. (Step P3)

  In step P3, the code “2” indicating “derived data field” is set in the “derived data field” in the corresponding field definition data on the “derived data field” side, and the corresponding field definition data is set. Is set in the “derived data field definition data pointer” portion in the field definition data on the corresponding “base data field” side. Further, a code “1” indicating “base data field” is set in the “derivation classification” column in the field definition data on the “base data field” side.

  As described above, since the code “0” is set as the initial value in the “derivation classification” column of all the field definition data fields, the “base data field” or “derived data field” is set. The code “0” is set only in the “derivation classification” column of the field definition data of the “normal data field”, which is the remaining data field that is not identified as.

  The configuration of “derivative condition definition data” is shown in FIG. The “derivative condition definition data” includes a “basic part” and an “operation designating part”. The “basic part” further includes a “type classification” entry field, an “item name text” entry field, a “data name text” entry field, and a “registered word text” entry field.

In the “form classification” entry field of “derivative condition definition data”, the “classification” of the above “derivative condition” is set. In the “item name text” entry field and the “data name text” entry field, a code string of the corresponding character string is entered. In the “registered word text” entry field, a code string of “representative name” in the applied term dictionary 52 is entered.
In the “calculation type part” in the “calculation designation part” of the “derivative condition definition data”, a corresponding code of the calculation type is entered. If there is no “operation designation”, the code “0” is set.

  In the “arithmetic operand section” in the “arithmetic designation section”, the distinction of the data to be operated on the corresponding base cell data is set. When "Related data difference condition" is defined and calculation is defined between the data in the corresponding base cell and the output data in derived cell based on "Related data difference condition" In the case of other than type 3, the “operation operand classification” is set to “data in derived cell”, and a code “0” indicating it is set.

  When "Related data difference condition" is not defined and calculation is defined between the data in the corresponding base cell and specific data defined separately (when "Division" of "Difference condition" is type 3) ) Is set as “specific designation data” in the “operation operand classification”, and a code “1” indicating it is set.

  In this example, first, the corresponding “representative name” “previous year” in the application term dictionary 52 is set in the “registered word” entry field in the “basic part”, and the “calculation” in the “calculation designation part”. Corresponding code “1” corresponding to “to ** ratio” is set in “Type section”, and code “0” indicating “Data in derived cell” is set in “Operation operand section” Is done.

  Further, when the “calculation operand classification” is “data in derived cell” as in this example, the item name to which the relevant data difference condition belongs is set in the “item name text” entry field. In this example, the related data difference condition is the registered term “previous year” in the “relative designation” category in the application term dictionary 52, and the item name “year” referred to in step D4 is entered as the belonging item name. The

When the “derived field definition process” is finished, “calculation result column definition data” is created. (Step A4)
First, on the document, a term that is surrounded by the definition element symbol “◯” of “interpretation designation” and registered in the applied term dictionary 52 as the “operation designation 1” category is designated as “calculation result entry column designation word”. Are identified one by one. The definition element symbol “◯” of “Registered word designation” is searched on the document, and the character string enclosed by it is a term registered as “Operation designation 1” category in the application term dictionary 52. You should judge that. The registered terms in the application term dictionary 52 are determined by including the following “synonyms” in addition to the following “representative names”.

  For each “calculation result entry field designation word” identified as described above, the corresponding computation result entry field is identified as follows. First, from the specified data field for which “Field definition data” has already been created, select the “corresponding item name” that has not been defined yet, and then select the corresponding “Calculation result field specification word” And the above-mentioned “specific association” may be selected.

That is, first, the designated data field connected by the “computation result field designation word” and the “join line” of the definition element is searched, and the designated data connected by the “operation result field designation word” and the “join line”. If there is no field, the designated data field in the “specific adjacent position” is searched for the “calculation result field designation word”.
If the designated data field having the above relationship with the “calculation result column designation word” can be searched, this designated data field is determined as the “calculation result column data field”, and “calculation result column definition data” (FIG. 34) is created. .

A “representative name” in the applied term dictionary 52 of the corresponding “calculation result field designation word” is set in the “calculation category” portion of the “calculation result field definition data”. In the “calculation designation 1” section in the application term dictionary 52, one “representative name” is registered corresponding to one computation type.
In the “First cell data address” section of the “Calculation result column definition data”, the cell data address of the first cell of the cell data chain pointed to from the “first cell address” of the corresponding “field definition data” is set. To do. At this time, the body of the corresponding “field definition data” is deleted.

  In the case of this example, the “specified data field” on the bottom row of the table has “total” entered as the “calculation result column specification word” in the left adjacent cell that is the “specific adjacent position”. Thus, “calculation result column data field” is determined, and “calculation result column definition data” in which “representative name” and “total” are set in the “calculation category” portion is created.

  If the character string “average” is entered instead at the entry position of the “total” character string in FIG. 9, the “average” of this entry term is “calculation designation 1” in the application term dictionary 52. "Registered term" definition data "in which" representative name "and" average "corresponding to the" calculation type "part are set is created in the same manner as in this example. Become.

  When “calculation result column definition data” is created, each cell constituting the corresponding “calculation result column data field” (hereinafter referred to as “calculation result column cell”) is sequentially taken out, and each “calculation result column” For each “cell”, a “calculation target field” that is a set of cells in which calculation target data is entered is detected.

  When each “calculation result column cell” that constitutes the “calculation result column data field” is arranged in the horizontal direction, the item of “aggregation category” is “summary item” in the upward direction on the same column as the component cell. Search the definition data field. When the cells constituting the “calculation result column data field” are arranged in the vertical direction, the left side on the same row of the constituent cells may be searched.

  In the “calculation result column data field”, as described above, for the “calculation result column cell” in which the “calculation target field” is detected, the cell data is sequentially connected by “pointer data”. The “cell data chain” is recreated, and the address of the head cell data is set to “head cell data address” of the corresponding “calculation result column definition data”.

  In the case of this example, on the bottom row of the table, each cell constituting the specified data field is the same column as the own cell or a part on the same column on the data field of the item name “Sales”. Is a “computation result column cell” (total column cell).

  As described above, when all the definition data has been generated for the document containing the definition information input to the system, the processing performed by the system, particularly the recognition processing (character / graphic recognition, position / size, etc.) has been performed so far. Display and output the result of the correction, etc., and confirm the definition content).

  In this display output, the document contents of each document recognized by the system are sequentially displayed on the display screen 20a in a toggle manner, for example. In order to display this document image, the document image output unit 40 queries the character / graphic pattern dictionary 36 for the document element data for each document stored in the document element data storage unit 38 and determines the pattern of each document element. Each pattern is identified, and each pattern is converted into image data in a bitmap format by a development program to generate a video signal.

  When the document contents of the book table corresponding to the recognition processing result of the system are displayed on the display screen 20a, the user corrects each document from the screen using the keyboard 12, the mouse 14, or the digitizer 15. New entry information can be entered.

  With respect to the entry information input from the keyboard 12, document element data can be generated by the character / graphic element input unit 37 (FIG. 11) without performing character / graphic recognition processing. For entry information input from the mouse 14 or the digitizer 15, each entry information is input by the character / graphic element input unit 37, and the character / graphic element recognition unit 34 sequentially (for each input entry information) performs character / graphic recognition processing. To generate document element data.

  Even when definition information is input by the input devices 12, 14, and 15 using these screen input methods, the modification information for each definition system is set and input in the “definition information distinction” mode (FIG. 7) of “environment setting”. If entry information is entered from the screen under the desired definition submode, the system will display the entered entry information with the definition distinction modifier specified in that submode. It is also possible. In this case, the definition information is recognized from the entry information with the definition distinction modification.

When entry information is input on the screen in this way, each time entry information is input, the character / graphic element input unit 37 (FIG. 11) is a document element corresponding to each entry information based on the input data. Data will be generated or modified.
The entry information (character string, symbol, figure) input from the screen is expressed in the form of document element data (FIGS. 14 to 19) in the system, as in the case of image input from paper.

  The information entered in the form of an image from the form and the information entered by the command on the screen are managed in the form of the same document element data in the system, so the original entry information (normal entry information) of the book table or its Regardless of the definition entry information added above, any entry information can be input from either image input or screen input.

  As described above, the user confirms the document content or the definition content of each document at the stage of the output display for confirmation after inputting the document in which the document content is described in advance by the image scanner 10. However, arbitrary entry information, particularly definition support information can be additionally written from the keyboard 12, mouse 14 or digitizer 15, and can be changed or canceled.

  The method for defining a book table format having derived data fields according to the present embodiment has been described above, but various modifications are possible. For example, FIG. 35 shows an example in which the definition content is specified on the screen. As shown in FIG. 35, the document content of the input book table document is displayed on the display screen 20a, and a desired definition is made by making a predetermined designation from the keyboard 12 or the mouse 14 while confirming the input document content. Information can be entered.

  35, when the “screen designation” button is designated under the “definition” mode and the “screen designation” sub-mode is entered, “1. field”, “2. data” are displayed at appropriate positions in the display screen 20a. A sub-screen 94 that lists various definition items such as “item” and “3. data name” appears. Here, when the character string “sales” 90 of the normal entry information is clicked and instructed, and “2. Data item” is selected on the sub-screen 94, the normal entry information “sales” is changed to “sales” of the data item. At the same time, the click display part changes to the special display assigned to “2. Data item”.

  Similarly, when the user clicks on the area 92 below the “sales” column and designates “1. field” on the sub-screen 94 for this area 2, the area 92 is used as a field for entering “sales” data. At the same time, the click part changes to a special display assigned to “1. Field”. Here, the specific display assigned to the data item, field,... Appears in advance as defined in the “definition element / entry information comparison table” shown in FIG.

For convenience of explanation, FIG. 35 shows a state in which the “data item” portion 90 and the “field” region 92 are selected and instructed at the same time. Selection is instructed.
Similarly, for the total field, after instructing to click the “total” which is the operation result column designation word, instructed “4. Interpretation designation” on the sub-screen 94 and clicked on the corresponding data field range. Then, “1. Field” may be indicated.

  As for the derived data field, similarly, after clicking the corresponding data field range, “1. Field” is designated, and “Derivation condition” written in the upper adjacent cell is designated as “Derivation condition”. It is only necessary to instruct the user to click on the designated word “YoY” and select and specify “5.

  After performing the above definition operation for all the data fields, if the “define interpretation” button 95 on the screen is designated, the system receives it and stores the click position on the screen and the document element data storage unit 38. The matching with the “position” information of the retained document element data is repeated to identify the corresponding document element data. Then, necessary definition data is generated from the identified document element data and the instruction content on the sub-screen.

  In addition, as a method of defining from the screen, the following method is also possible. After designating a certain data field on the screen, when “1. field” is designated on the sub-screen 94, an “item name designation menu” 96 shown in FIG. 36 is displayed. In the “item name designation menu”, in addition to the “item name entry field” 98 and the “field format entry field” 104, a “derivative condition designation area” 130 is provided separately, and further, “item name entry field” Column "110," Data name entry column "112," Registered word entry column "113," Calculation entry column "115, and" Field format entry column "114 are provided.

  In the “data name entry field” 112 in the “derivative condition designation area” 130, the data name of the “related data difference condition” is entered. In the “item name entry field” 110 in the “derivative condition designation area” 130, the item belonging to the data name entered in the “data name entry field” 112 is entered.

  In the “registered word entry column” 113, registered words of the “relative designation” category in the application term dictionary 52 are entered as designations of “related data difference condition registered words”. In addition, a registered word of the “arithmetic operand” category in the application term dictionary 52 is also entered as a designation of the “arithmetic operand” of type 3 derivation condition. In the “calculation entry column” 115, registered words of the “calculation designation 2” classification in the application term dictionary 52 are entered as indicating “calculation conditions”.

  In the case of the table format shown in FIG. 9, for each “normal data field” and each “base data field”, the name of the corresponding item name may be entered in the “item name entry field” 98. For each “Derived Data Field”, enter “Year Previous Year” in “Registered Word Entry Field” 113 in “Derived Data Field Information Entry Area” 130 and “Ratio” in “Calculation Entry Field” 115. do it.

  When the above entry is made and the “end button” 120 on the “item name designation menu” is clicked, for each “derivative data field”, the system registers “registered word entry column” 113 among the above entry columns. The registered terms in the “relative designation” category and the registered terms in the “arithmetic operand” category in the applied term dictionary 52 are searched for the entered terms, and the entered terms in the “calculated entry column” 115 are searched in the applied term dictionary 52. Search for registered terms in the “calculation designation 2” category.

  In this example, “previous year” entered in the “registered word entry column” 113 is searched as a registered term of the “relative designation” category in the application term dictionary 52 and “ratio” entered in the “calculation entry column” 115. Is searched as a registered term in the “calculation designation 2” category in the application term dictionary 52, and the above designation is judged as designation of the above-described type 5 derivation condition in accordance with the above criteria for derivation condition judgment. The corresponding “derivative condition definition data” is created.

  In addition, the code “2” indicating “derived data field” is set in the “derived field” column of the corresponding field definition data of the corresponding data field, and the address of the created “derived condition definition data” is It is set in the “Derived condition definition data pointer” part.

  After performing the above definition operations for all the data fields, if the “Define interpretation” button on the screen is instructed, the system receives the corresponding “base data field” for each “derived data field”. The code “1” indicating “base data field” is set in the “derivation classification” column in the field definition data on the “base data field” side, and the “derived data field definition data pointer” part Set the address of the field definition data of the “derived data field” corresponding to.

The definition of “derivative conditions” on the screen can be performed in the same manner for the “other usage examples”. In the case of “another usage example 1” to be described later, “entire” may be entered in the “registered word entry column” 113 and “ratio” may be entered in the “calculation entry column” 115.
The “total” entered in the “registered word entry column” 113 is searched as a registered term in the “arithmetic operand” section in the applied term dictionary 52 and the “ratio” entered in the “calculated entry column” 115 is applied to the applied term dictionary. The registered terms in the “calculation designation 2” section in 52 are searched, and the above designation is judged as the designation of the type 3 derivation condition according to the criteria for the derivation condition judgment described above.

In the case of “other use example 2” described later, “year” is entered in the “item name entry field” 110 in the “derived data field side information entry area” 130, and “2000” is entered in the “data name entry field” 112. “Year” may be entered, and “Ratio” may be entered in the “Calculation entry field” 115. In the case of “other use example 3”, “previous year” may be entered in the “registered word entry column” 113 and the “calculation entry column” 115 may be left blank.
In the case of “other use example 4”, “year” is entered in the “item name entry field” 110 in the “derived data field side information entry area” 130, and “2000” is entered in the “data name entry field” 112. And the “calculation entry field” 115 may be left blank. In each case, the corresponding “derivative condition definition data” is created.

In the “item name designation menu”, in addition to the above entry fields, a “derivative condition entry field” 100 is also provided. When the above-mentioned derivation condition category is other than 1 type or 4 type, a derived condition character string You may fill in the whole.
In the case of this example, “Year-on-Year comparison” is entered in the “derivative condition entry field” 100. The character string entered in the “derivative condition entry field” 100 is the same as the character string “interpretation specified” described above, and the registered terms in the application term dictionary 52 constituting it are interpreted according to the meanings defined in the dictionary. Assuming that the relationship between terms is interpreted in accordance with Japanese syntax rules, derived condition definition data is created in the same manner according to the above-described “determination condition determination procedure”.

The above definition can be automatically performed by the system. In the system, an item name dictionary in which terms used as item names on the document are registered and a master data file in which data names belonging to the item names are registered are prepared in advance.
For example, it is assumed that the document shown in FIG. 9 is input to the system, and corresponding document data is created in the system. When the user performs a specific operation for instructing this automatic definition to the system, first, the system first selects “calculation designation 1” in the registered term of the item name dictionary and the application term dictionary 52 from the table format. The registered terms in the category are detected as “corresponding item name candidates” and “calculation result field designation word candidates”, respectively.

  The system also performs the procedures after Step D2 and Step D15 in the above-mentioned “Derivation Condition Specification Word Determination Procedure” (FIGS. 27, 28, and 29) for character strings entered in other cells in the table. And “derivative condition designation word candidate” is detected. However, in the detection of type 1 and type 4 of the derivation condition in the “derivation condition determination procedure”, the processing part using the corresponding “item name” added by the definition support entry information is not performed in this procedure. .

  Next, for each of the “corresponding item name candidates”, “calculation result field designation word candidates” and “derivative condition designation word candidates” detected above, the corresponding “data field candidates” or “data name candidates” As described above, the cell string or the character string at the above-mentioned “specific adjacent position” is detected. If a character string is entered in the cell string detected as “data field candidate”, the corresponding master data file is searched to confirm that the data name belongs to the corresponding item name. Similarly, the character string detected as “data name candidate” is confirmed to be a data name belonging to the corresponding item name.

  Next, in addition to the terms detected as “corresponding item name candidates”, “calculation result field designation word candidates”, and “derivative condition designation word candidates” as described above, the system uses the characters entered in the table format. The following determination is performed for a character string that is not in the “data field candidate” detected as described above or that is not a “data name candidate” detected as described above.

  The term to be determined is first determined by searching the corresponding master data file to be a data name belonging to each item name detected as “corresponding item name candidate”. In addition, if there is an item name of the above-mentioned “year / month / day item” classification among the detected “corresponding item name candidates”, the format of the term to be judged is detected as described above, and the corresponding It is determined that the data is entered in the same format as the data name of the item name.

  In the determination of this format, when a specific term such as “value” is added as a postfix of the data name character string belonging to each item name detected as “corresponding item name candidate” Is also acceptable. In addition, this specific term is attached as a postfix of a character string written in the same format as the data name of the item name of the “year / month / day item” category detected as “corresponding item name candidate” It is also acceptable if there is. To emphasize that this particular term is a type of “derivative condition” as used herein. It is a term used in daily life, and is registered in a dictionary attached to the process for performing the determination process.

  If any of the above determinations is obtained, a cell string in “specific adjacent position” is detected for the corresponding determination target term, and if a cell string in “specific adjacent position” is detected, the corresponding The term to be determined is regarded as the above-described type 1 “derivative condition” in which the detected cell string is a derived data field.

  Finally, for each detected “corresponding item name candidate”, each “calculation result field designation word candidate” and each “derivative condition designation word candidate”, a corresponding “data field candidate” can be detected, and each “corresponding item” If it is determined that “data field candidates” can be detected without having overlapping areas, corresponding to each “name candidate” and each “derivative condition designation word candidate”, the above detection result is estimated by the system as one estimation. As a result, it displays to the user and asks for user confirmation.

  In displaying the above estimation results, the above-mentioned “definition element / entry information comparison” is applied to the corresponding “corresponding item name candidate”, “calculation result field designation word candidate”, and “derivative condition designation word candidate”. In the “table”, each is added with a graphic characterization such as a symbol assigned for “item name” designation or “interpretation designation” and a background pattern.

  In the case of “derivative condition designation word candidate” of type 1 and type 4 derivation conditions, the system uses the definition support entry information of (blue) for the corresponding item name and the corresponding “derivative condition designation word candidate” outside the table. Add a note at an appropriate position near the entry and connect the two with a connecting line. If there is a space for entry in the position adjacent to the corresponding “derivative condition designation word candidate”, it may be entered there. The item name to be entered is also displayed in the “definition element / entry information comparison table” with a graphic characterization such as a symbol and background pattern assigned for designating the “item name”.

The connecting line connecting the “derivative condition designation word candidate” and this additional item name is: For both the character string of “derivative condition designation word candidate” and the postscript item name character string, a rectangle circumscribing it is obtained, the sides that face each other among the sides constituting these two circumscribed rectangles, and both sides are obtained. What is necessary is just to produce | generate the line segment data showing the line segment to connect. Upon receiving a specific instruction operation indicating user confirmation, the above estimation result is confirmed and corresponding definition data can be obtained.

  Next, an example in which data is actually output and totalized on the tabulation table that has been defined as described above will be described. In general, a data file is attached with “record definition data” that defines the data structure of the record that is the data storage unit, and attributes such as “summarization category” and data storage area length are defined for each data item name. is doing.

  In this example, for example, a data file having record definition data shown in FIG. As shown in FIG. 37, the record which is a unit constituting the data file includes item names “branch name”, “product category”, “product code” “number of sales”, “sales amount”, “unit price”, “ The data is divided into division fields “profit”, and the corresponding data is stored. The set of item names constituting the data output source data file must always include the item names of the item definitions defined in the output destination table format.

  In the embodiment apparatus, the data output process is performed in the “data output mode”. When the “mode” button on the display screen 20a is clicked and “data output” is selected from the mode list menu, the system switches to the “data output” mode, and the “output source” as shown in FIG. 38 is displayed on the display screen 20a. The “File List” screen appears. The user may select “1. Sales file” as a desired output source from the displayed data files and click the “Execute output” button.

  In the system of this embodiment, the data output unit in charge of “data output processing” is constituted by a CPU 24 that executes a predetermined conversion or processing program, and an internal memory 16 or an external memory 18 that stores the program and related data. .

  When an output source data file is designated, an “item name association screen” (not shown) is displayed on the screen. On the “Item name mapping screen”, the item name defined on the output destination summary table and the definition item name of the output source data file are displayed in two columns, and the user can output the output destination and output on the screen. The corresponding item names can be associated with each other by, for example, an operation of connecting them with a mouse.

  When the above-mentioned item name association operation is completed, when the “end” button on the screen is designated, the “item name association table”, which is a pair of columns in which the corresponding item names of the output destination and the output source are arranged, is displayed in the system. (Not shown), and “data output overall processing” starts.

  The procedure of “the entire data output process” is shown in the flow of FIG. First, the data of the output source file is output and totaled in cells other than the total column on the totaling table as the output destination. ("Data output processing" -step F1) However, in this "data output processing" (step F1), data output into the derived data field is performed with reference to only the related data difference conditions in the derived conditions. It is. When the difference condition consists only of the calculation condition (in the case of the category 3 type of the derivation condition described above), data output to the derivation data field is not performed.

Next, on the tabulation table, the data in each cell that has been output is tabulated in the total column. (In-table calculation process-Step F2) Subsequently, when “calculation condition” is defined in the derived data field, the calculation defined between the data in the derived cell and the data in the corresponding base cell is executed. Then, the data in the derived cell is replaced with the calculation result data. (Corresponding cell calculation process—step F3) If the difference condition does not include the calculation condition (in the case of the above-mentioned categorized type 1 and type 2 of the derivation condition), this process is not performed. Finally, all the data output and entered on the summary table is converted into the corresponding character string data. (Character string data conversion process-Step F4)

  The “data output process” (step F1) is performed in such a manner that one record is taken out from the output destination tabulation table and the output source data file, and matching and matching are repeated. Since the system according to the present embodiment performs matching between data in this way, the notation of data is unified in the output destination summary table and the output source data file as a premise for using the system of the present embodiment. Shall.

  In general, “record” which is a combination of data referred to at the same time or data entry area cell can be identified as follows on a normal table format having no “derived data field”. First, in the table format, the data constituting each item definition data field or the data entry area cell which is on the same line and has a different corresponding item name from the data entry area cell Is identified as the parent of the “record”.

  Next, for each data or each data entry area cell constituting the matrix of the identified “record”, a search is performed on a column in a perpendicular direction including the data. If there is data belonging to the data field of a new item name or a data entry area cell that is different from each item name constituting the “record” matrix on the searched column, this is added to the “record” matrix, and “record” Can be obtained. Also, if there is an “item definition” set as a common condition outside the table, that data is also added to the “record”.

As in this example, in the table format having “derived data field”, “record” can be identified as follows. Since the “base cell” and the corresponding “derived cell” have the same “corresponding item name”, different “records” are formed for both.
First, a “record” (hereinafter referred to as a “base record”) including a cell that is a “base cell” is the same as the normal table format described above, except for the “derived data field” on the table format. They can be identified in the same way.

  A record that includes a cell that is a “derived cell” (hereinafter referred to as a “derived cell”) corresponds to the “base cell” in the “base record” that includes the corresponding “base cell”. Replace the cell with the “derived cell” to be changed, and change the other specific part in the “base record” indicated by the “related data difference condition” in the “derivative condition definition data”. Can be obtained.

In the case of the table format shown in FIG. 9, for example, as “base record” including “base cell” in the fourth row from the upper side of the table and the second column from the left side,
About item name “Sales” Data “null”
For the item name "Product", the data is "Radio"
About the item name "FY""Datais" 2001 "
"Record" is obtained.

“Derived record” including the corresponding derived cell adjacent to the right of the base cell (the fourth row from the top of the table, the second column from the left) is the “related data difference condition” in the derived condition. In response to the instruction of the registered word “previous year” in the application term dictionary 52, the data “2001” corresponding to “base record” is used as the data for the item name “year” as “2000”. It is obtained by replacing “ That is,
For the item name “sales”, data “null”,
For the item name “product”, the data is “radio”,
For the item name “FY”, the data is “2000”
"Record" is obtained.

FIG. 40 shows the procedure of “data output processing” on the table in which “derived data field” is set. The procedure of the “data output process” process is divided depending on whether or not the related data difference condition of the derivation condition is included. When “data output processing” is entered, first, referring to the “format classification” part of “derivative condition definition data” (step M1), when the derived condition includes a related data difference condition, that is, the format of the derived condition If the category is other than type 3, “data output process-1” (step M2) is performed, and if the derived condition does not include the related data difference condition, that is, if the type category of the derived condition is type 3, Data output process-2 "(step M3) is performed.
In the case of this example, since the format classification of the derivation condition is type 5, “data output processing-1” is performed.

  In the procedure of “data output process-1”, after the “base record” take-out position is initialized, first, “base records” are taken out one by one from the output destination table, and the output source data is placed thereon. Output and aggregate all record data in the file.

  Next, based on the “base record” that is being taken out, create the “derived record” by making the changes specified by the “related data difference condition” in the derived condition definition data. Above, output all the record data of the output source. The above procedure is repeated for all “base records” extracted from the table format.

  The range for extracting the “base record” from the table format can be obtained as follows, for example. In the table, if rows are extracted in order from the top and a row in which two or more item definition data fields are set is found, the next row is extracted and cells belonging to the same column in both rows are extracted. Confirm that they belong to the same item definition data field. If this confirmation is obtained, this line is determined as the “takeout start line” of the “base record”.

  Subsequently, the rows are sequentially extracted downward, and it is repeated that it is determined that cells belonging to the same column belong to the same item definition data field between vertically adjacent rows. Thus, the cells belonging to the same column identify the set of rows belonging to the item definition data field of the same item, and this is determined as the “base record extraction range row”.

  When cells with the same item name are repeated on one line, as in the data field for the item name “Sales” in this example, the cells are extracted from the left cell sequentially from the repeated cell set. It is sufficient to repeat the identification of the “base record” that includes the issued cell. That is, for the extracted cell, a search is performed on the columns in the right-angle direction, a cell with a new item name “year” is added, and “base record” is repeatedly obtained.

  In the case of this example, first, on the second row of the table, a cell having the item name “product” (on the first column) and a cell on the second column in the cell set having the item name “sales” are formed. After obtaining the base of the “base record”, the required “record” is obtained as described above.

In addition, in this specification, the position (order) of the cell taken out in the “record” in the cell set in which the cells having the same item name are repeated on one row is referred to as “in-row repetition”. It will be called "cell position".
By repeating the above procedure for all the lines after the “retrieval start line”, all “base records” on the table format can be extracted. Note that the order of retrieving records from the output source data file may also be determined for convenience of processing, such as the order of file storage.

  Details of the “data output process-1” will be described according to the procedure shown in FIG. When “data output processing” is entered, first, in “initial processing” (step G1), records extracted from the data output destination and the data output source are set, and a tabulation management table for performing mutual collation is created. The format of the tabulation management table is shown in FIG.

  An item name is entered in each column of the first row on the tabulation management table. Enter the item name defined as the corresponding item name of the item definition data field on the output destination summary table. The order of entry may be random. In this example, the item name “sales”, “product name”, and “year” are entered and set.

In the second row on the tabulation management table, the item name “tabulation classification” is entered. The section value read from the “record definition data” attached to the data output source data file is set in the column corresponding to each item name. Further, the field definition data corresponding to each item name is taken out, and when the “aggregation category” is “year / month / day item”, the set value of the corresponding column on the aggregation management table is updated with the corresponding code “3”.
In addition, when “summary classification” of all item names is defined on the data output destination table format, it may be set by referring to the corresponding “aggregation classification” data in the corresponding field definition data.

  In the case of this example, the column corresponding to the item name “sales” (the column in the same column as the column in which the item name “sales” is entered) is filled with a code “1” indicating “aggregate numerical value”. The In the column corresponding to the item name “product”, a code “0” indicating “non-aggregated non-numeric item” is entered. In the column corresponding to the item name “year”, a code “3” is entered as a registered term of the “year / month / day item name” classification in the applied term dictionary 52.

  Subsequently, referring to the “key classification” of each item definition data, if it is “non-key item”, the code data set on the second row of the aggregation management table indicates “non-key item” Add the flag data. In this example, specific flag data indicating “non-key item” is added to the code data set for the item name “sales”.

  In the third row on the tabulation management table, the cell data address of each cell constituting the “record” extracted from the output destination tabulation table is set. When the output destination is a data file, the address in the record of the data file may be entered.

    On the fourth row of the aggregation management table, data stored in the “in-cell data storage unit” in the corresponding cell data is set as entry data in each cell of the output destination aggregation table. The corresponding numeric data is entered in the column for the item “Numeric” (“Aggregated numeric value” or “Non-aggregated numeric value”), and the corresponding text data is entered in the “Non-numeric item” column. Set. A distinction flag between numerical data and text data is added to the head of the data to be set.

  In addition, when the item name is registered as the “year / month / day item” category in the applied term dictionary 52 such as “year”, the code “3” is displayed in the “aggregation category” column of the second row. Set), the corresponding data is converted into a standard expression format for data comparison and collation. For example, if the item name is “Year”, and the standard expression format is, for example, “Western calendar notation”, “4 digits for arithmetic”, “No postfix”, “Year” from the extracted data name character string The postfix part such as “is removed and set as text data consisting of the remaining numeric character string.

The conversion to the standard expression format can be performed by referring to the “year format data” already created for the corresponding item name “year”.
Also, if the data extracted from the table is, for example, a two-digit year notation such as “01” or “02”, an upper two-digit number “20” is added. For example, if the first two digits added are “0”, “20” is added, and the last two digits added is “9”. For example, “19” is added, and an appropriate threshold value can be set for the first two digits.
In addition, when the corresponding data name character string is expressed in the era name, it may be converted into the corresponding era name using a table that associates the era name and the year notation prepared in advance.

  In the fifth row on the tabulation management table, when the output source is a table, the cell data address of each cell constituting the output source is set. When the output source table is a data file as in this example, the address in the record of the data file may be entered. Refer to “Item name association table” and set in the same column where the corresponding item name of the output destination is set.

  In the sixth row on the tabulation management table, entry data in each cell constituting the output source table or each data in the record taken out from the output source data file is set. As with the fourth line, a numerical data and text data distinction flag is added to the top of the same column and set. As in the case of the fifth row, the “item name association table” is referred to and set in the same column where the corresponding item name of the output destination is set.

  In the seventh row on the tabulation management table, the corresponding field definition data address of the belonging item definition data field of the extracted record constituent cell is set in the corresponding column. In the eighth row on the tabulation management table, “base cell flag data” indicating whether or not the extracted record constituent cell is a “base cell” is set.

In practice, the tabulation management table can be implemented as follows, for example. List data (not shown) is provided for each entry field on the tabulation management table. Each list data stores the data entered in each entry field, and has row direction pointer data and column direction pointer data. The data in each data entry column adjacent in the row direction or the column direction can be traced sequentially.
In addition, a “main / sub flag” is provided in the tabulation management table, and “0” is set when the base record is set there, and “1” is set when the derived record is set, The usage state may be determined.

  In “Initial processing” (step G1), the tabulation management table is created, and when the corresponding data is set on the first and second rows as described above, the items on the table format are subsequently displayed. For all the cells included in the definition data field, the data character string entered therein is identified, and the character string data address is set in the “character string data address portion” in the corresponding cell data. Further, the character string data is converted into data of an appropriate format and stored in the “in-cell data storage unit” in the corresponding cell data.

As a known method, the character string written in the cell can be identified by repeatedly collating the position information of the corresponding cell with the position information of each character string data on the document.
First, the corresponding text code string can be identified from each character string data of the character string identified to be entered in the cell. When the corresponding cell belongs to the item definition data field whose item name is “numeric classification” (including aggregated numeric values and non-aggregated numeric values), the corresponding text code string (numeric code string) is further publicly known. Is converted into numerical data by the above and stored in the “in-cell data storage unit” of the corresponding cell data. For other cells, the corresponding text code string data is stored as it is.

  In addition, for cells that belong to the item definition data field whose item name is “Aggregation Item” (“Aggregation Numerical Value”), and for which data has not been entered from the beginning, the “In-cell data” of the corresponding cell data is used as the aggregation start value. A numerical value “0” is set in the “storage section”.

When the above "initial processing" (step G1) is completed, the "extraction position" of the "base record" is set to the "start position" from the output destination table. (Step G2)
The parameter representing the “takeout position” of the “base record” can be represented by, for example, a pair of the row position from which the “record” is taken out and the above “in-row repeated cell position”.

  Subsequently, in the table format, “base record” is sequentially extracted from the first “base record”, and the cell data address of each cell constituting it is displayed in the corresponding column on the third row of the tabulation management table. set. Subsequently, the data stored in the “in-cell data storage unit” in the corresponding cell data of each cell constituting the extracted “record” is respectively stored in the corresponding column on the fourth row of the tabulation management table. set. (Step G3)

  In this step G3, for convenience of subsequent processing, the corresponding field definition data address of the belonging item definition data field taken out in the process of identifying each cell constituting the “base record” is stored in the seventh field. Set it in the appropriate column on the line. In addition, for a cell that is “base cell”, “base cell flag data” indicating it is set in the corresponding column on the eighth row.

  Next, all the data in the output source data file is output and totaled for the “base record” taken out from the output destination tabulation table format and set on the tabulation management table. (Step G4) Hereinafter, this procedure will be described with reference to FIG.

The record extraction position from the output source data file is set to the start position (step H1), the records are sequentially extracted one by one from the output source data file, and the addresses in the records of the respective classification fields are stored in the fifth table in the tabulation management table. Set on line. Subsequently, the corresponding data is read out by the set in-record address, and set in the corresponding column on the sixth row in the total management table. (Step H2)
Each piece of data in the retrieved file record is prefixed with a “numeric / text distinction flag” indicating whether it is “text data” or “numeric data”, and in each column on the sixth line. Set.

The order of retrieving records from the output source data file may be determined for convenience of processing, for example, the order of file storage. For each record data extracted from the output source data file, refer to the item name association data (created at the beginning of the entire output process), and enter it in the entry column on the same column as the corresponding item name on the output destination summary table. set.
When the “total category” of the item name is the “year / month / day” category, the corresponding data is converted into a standard expression format for data comparison and collation and set.

Next, the comparison management is performed between the output destination data and the output source data having the same item name on the tabulation management table. (Step H3) The collation between the data is not performed for the item of “non-key item” and the item for which data is not set in the corresponding column on the fourth row of the tabulation management table. The item “non-key item” is identified as data to which the above-described flag indicating “non-key item” is attached on the second row of the aggregation management table.
The comparison between the data is performed by comparing the data on the sixth row on the tabulation management table with the data on the fourth row on the corresponding column.

  In the above comparison and collation, if the output destination data and the output source data are the same for all the compared items, the following addition processing is performed. That is, the output source data whose item is “total number” is added to the data of the output destination record. Also, if it is an item of “non-aggregation item” and data is not initially set on the output destination side, the output source data (upper row on the aggregation management table) is displayed in the corresponding column of the output destination record. Post to (Aggregation management table 4th line) (Step H4)

  In this example, if the data of the item name “product” and “year” other than the item name “sales” is the same, the data of the output source record of the item name “sales” is added to the data of the output destination record It will be. This addition is performed by adding the data on the sixth row to the data on the fourth row on the corresponding column in the tabulation management table.

  If even one item of the comparison-matched data is not the same between the output destination data and the output source data, this addition is not performed, and the process returns to the step of extracting the next record from the output source file. (Step H5)

When all the record data of the output source data file is aggregated for one “base record” extracted from the output destination table, the data aggregated on the output destination record in the aggregation management table is output to the output destination table. It is transferred to the “in-cell data storage” of the corresponding cell in the table. (Step G5)
That is, the data on the fourth row of the tabulation management table is transferred to the “in-cell data storage unit” of the cell data pointed from the cell data address of the third row. At this time, each piece of data to be transferred is stored in the “in-cell data storage unit” with the above-described numerical value / text distinction flag attached.

  As described above, when the total posting to one “base record” obtained from the output destination table is finished, next, based on the “base record” currently set on the total management table, the one is recorded. "Derived record" is created in the form of updating and changing the data of the part. (Step G6)

In step G6, first, the cell that is the “base cell” in the tabulation management table is replaced with the corresponding “derived cell”. That is, on the third row of the tabulation management table, the cell data address of the cell which is the “base cell” is replaced with the cell data address of the corresponding “derived cell”.
In addition, the entry data character string in the corresponding “derived cell” is converted into an appropriate data format in the same manner as the entry data character string in the “base cell” described above, and the corresponding data in the fourth row is displayed. set.

  In the tabulation management table, the column position where the “base cell” to be replaced is set is the column position where the “base cell flag” data is set by looking at the eighth row of the tabulation management table as described above. Can be found as

The “derived cell” to be replaced can be found as follows. First, on the seventh row of the tabulation management table, the field definition data of the corresponding “base data field” is extracted from the field definition data address set at the column position found as described above, and set in the field definition data. The “field definition data” of the corresponding “derived data field” is extracted from the “derived data field pointer”.
Next, the cell data chain pointed to from the “field definition data” is sequentially traced, and the cell in the same row position on the table format as the “record” currently extracted on the tabulation management table may be identified.

In step G6, as described above, when the cell that is the “base cell” is replaced with the corresponding “derived cell” in the tabulation management table, the instruction content of the corresponding “derived condition definition data” is then displayed. Based on the above, the specific data in the “base record” is changed.
The “derived condition definition data” referred to here may be extracted by the “derived condition definition data pointer” in the “field definition data” of the corresponding “derived data field”. As described above, even if the derivation condition includes the “calculation condition”, the “derivative record” is created with reference to only the “related data difference condition” in the present stage.

The data change of the “base record” based on the instruction content of the “derivative condition definition data” is performed according to the procedure shown in FIG. First, the data to be changed in the “base record” is identified. (Step J1)
The data to be changed in this “base record” is identified as data with the same item name as that on the “base record” by referring to the “item name text” part in the “basic part” of the “derivative condition definition data” be able to. The “base record” is currently set on the fourth row of the tabulation management table, and the data to be changed is data on a column corresponding to the corresponding item name therein.
In the case of this example, numeric character string data corresponding to the item name “year” registered in the “item name text” portion in the “derivative condition definition data” is identified.

Next, it is determined that the “related data difference condition” in the “derivative condition” is “indirect designation” (step J2). What is necessary is just to determine that the corresponding code representing type 2 or type 5 is set in the “type classification” portion of “derivative condition definition data”.
When the “related data difference condition” is determined as “indirect designation” as in this example, according to the meaning of the “related data difference condition registration word” that defines the content of the “related data difference condition”, A predetermined change is made to the corresponding data of the “base record”. (Step J3)

  The processing content of this step J3 is determined for each registered word in the “relative designation” category in the applied term dictionary 52, which is a “related data difference condition registered word”. For example, as in this example, if the “related data difference condition registration word” is “previous year”, the “previous year” is applied to the corresponding data of the “base record” according to the meaning that the user normally understands. Is a process for obtaining data representing the year.

Step J3 for making a predetermined change to the corresponding data of the “base record” is the process shown in FIG. 45 as a general form when the “related data difference condition registration word” is “previous year”.
This procedure will be described with reference to this example. First, from the data name character string of the “base record” to be changed already extracted in step J1, for example, “2002”, the numeric character string portion “2002” "Is identified. (Step K1) This identification can be performed by referring to the “year format data” already created for the corresponding item name “year”.

As described above, when the corresponding data of the “base record” has already been expressed only as a numeric character string, for example, “2002” as the standard expression format for data comparison and collation, this step K1 Will be skipped.
Next, the numeric character string portion “2002” is converted into a corresponding numerical value “2002” (step K2), and then according to the meaning defined in “previous year” which is the relevant “related data difference condition registration word”. Then, the numerical value “1” is subtracted to obtain the numerical value “2001”. (Step K3)

  Finally, the obtained numerical value is converted again into a standard expression format for data comparison and collation. If this standard expression format is a numeric character string representation, the numerical value “2001” is converted into the numeric character string text “2001” by a known method. (Step K4) If the standard expression format for data comparison and collation has a postfix “year”, the postfix “year” is added to the end of the standard postfix to obtain the character string text “2001”. (Step K5) The process of converting this format into the standard expression format can also be performed by referring to the “year format data”.

  In addition, in the data change processing by “previous year” of this “related data difference condition registration word”, the data name character string of the “base record” to be changed is displayed as the standard expression format for data comparison and verification. In step K3, if the subtraction result is “0” (when the data to be changed is “Heisei 1”), branch to a special process that changes the era to “Showa 63” Good.

  The step J3 for making a predetermined change to the corresponding data of the “base record” can be performed in the same manner for other “related data difference condition registration words”. For example, if the “related data difference condition registration word” is “next year”, step K3 in the procedure shown in FIG. 45 can be replaced with a process of adding a numerical value “1”.

  In addition, when the “related data difference condition registration word” is “previous month”, it is usually performed in the same manner as the procedure of FIG. 45, and the subtraction result is “0” (the data to be changed is “January”). ), The “year” data is reduced by “1” and the “monthly” data is changed to “12”. Alternatively, in the applied term dictionary 52, the registered word “monthly” in the “year / month / day item” category is assigned a name string in the order of the month name (for example, “January”, “February”,..., Or “ Jan. ”,“ Feb. ”,...), And the name data may be traced back one time.

  Finally, the data to be changed in the corresponding “base record” is replaced with the data obtained as described above to obtain the “derived record”. (Step J4) Since the configuration data of the corresponding “base record” has already been set in the fourth row on the management table to be aggregated, the “derived record” has obtained the data to be changed in the above manner. Just replace it with data.

  In the case of this example, if the change target data of the set “base record” is “2002” in the fourth row on the tabulation management table as the item “year”, for example, It may be replaced with the obtained data “2001”.

  As described above, all the data in the output source data file is aggregated and transferred to the “derived record” created and set on the aggregation management table, as in the case of “base record”. (Step G7). As in the case of “base record”, the records are taken out one by one from the output data file to the sixth row on the tabulation management table, and then the process of comparing and collating with the data on the fourth row is repeated. I will do it.

  When all the record data of the output source file is transferred and totaled to the “derived record” (upper line 4 of the summary management table) of the output destination table, the “derived cell” in the “derived record” obtained on the summary management table Is stored in the corresponding cell data in the table format. (Step G8) That is, the data of the item name (in this example, “sales”) in which “base cell” is defined among the data on the fourth row of the tabulation management table is the cell data of the same third row. The data is transferred to “in-cell data storage” in “cell data” pointed to by the address. At this time, each piece of data to be transferred is stored in the “in-cell data storage unit” with the above “numerical value / text distinction flag” attached.

When the above processing is completed for one “base record” extracted from the output destination table, the “next base record” is extracted from the output destination table and the same processing is repeated. (Step G9) In the output destination table, the “next base record” is a cell of the same corresponding item name on one row of the output destination table among the cells constituting the “record” taken out on the aggregation management table. A repeated cell (in this example, a cell constituting the data field of the item name “sales”) can be obtained by replacing it with a cell positioned next in the first row.
After all the “base records” have been extracted on one row, in the next row, the cell located at the head is selected as the cell of this repeated item, and “base record” is extracted. Can be repeated.

  The above processing is repeated for all the “base records” extracted from the output destination, and when the “data output processing” (step F1) is completed, these output data are then displayed in the total column defined in the table. The “in-table calculation process” (step F2) is performed.

  In the “in-table calculation process”, for each calculation result column cell in the calculation result column data field to which the above “calculation result column definition data” is applied, a predetermined value is assigned to the data group in the calculation target data field. And the result of the calculation is entered in the corresponding cell. In the case of this example, for each calculation result column cell (total column cell) set in the bottom row of the table, an addition that is a predetermined calculation is performed on the data group of the item name “sales” on the same column. , The result of addition will be written in it.

  Each calculation result column cell can be taken out by sequentially tracing the cell data chain pointed to from the corresponding calculation result column definition data. For the type of calculation, the “calculation category” in the corresponding “calculation result column definition data” may be referred to.

  As described above, the calculation target data field for each calculation result column cell is defined in the direction perpendicular to the corresponding calculation result column definition data field, and the corresponding “calculation result column” in one item definition data field. It is detected as a portion in the same column and same row as the “column cell”.

  Cell data is sequentially extracted from the cell data chain pointed to from the field definition data created for each item definition data field defined on the document, and the corresponding calculation result column cell and the above-mentioned position from the position information. It can be taken out by detecting the cells in relation. When “derived data field” is defined as in this example, the same operation is performed for each “derived data field”.

  For each cell in the corresponding calculation target data field, the data stored in the “in-cell data storage unit” in the corresponding cell data is read out and subjected to a predetermined calculation, and the result is stored in the cell data of the corresponding calculation result column cell. In the “in-cell data storage unit”.

  When the above processing is completed for all “calculation result column definition data”, “in-table calculation processing” (step F2) is ended, and “corresponding cell calculation processing” (step F3) is entered. The procedure of “corresponding cell calculation processing” is shown in FIG.

  In “corresponding cell calculation processing”, first, the “calculation designating part” in “derivative condition definition data” is referred to, and it is determined that “calculation condition” is included in the derivation condition (step N1). If the derivation condition does not include the “calculation condition” (when “0” is set in the “calculation type part” in the “calculation designation part”), the next “character string data conversion process” is immediately performed. ”(Step F4).

  If the "calculation condition" is included in the derivation condition, next, refer to the "calculation operand section" in the "calculation specification part" and determine that it is a "data value in the derivation cell" . (Step N2)

  When the determination in step N2 is obtained as in this example, the operation designated with the data in the corresponding “derived cell” is performed for each cell that is the “base cell” (step N3). ), The data in the “derived cell” is updated with the operation result data. That is, the data in the “in-cell data storage section” of the corresponding “derived cell” is replaced with the calculation result data. (Step N4)

  Each cell that is a “base cell” on the document has a code (“base data field”) in the “derivation classification” information in the “field definition data” created on the document ( Identification can be made by selecting a set of “1”) and then following the cell data chain pointed to.

On the other hand, the “derived data field” corresponding to the “base data field” can be identified from the “derived data field pointer” of the “field definition data” defined for the “base data field” as described above. .
Therefore, the “derived cell” corresponding to the “base cell” is orthogonal to the corresponding “base data field” (“derived data field”) in the cells constituting the “derived data field”, and this It can be identified as being on the same row or column as the “base cell”.

  The type of operation to be performed between the data in the “base cell” and the corresponding data in the “derived cell” is the “derivation condition” defined for the “derived data field” including the corresponding “derived cell”. Reference may be made to the “calculation type” information in the “calculation designation section” in the definition data. In this example, the data set in the “in-cell data storage” of the “base cell” is stored in the “derived cell” set in the “in-cell data storage” of the corresponding “derived cell”. Dividing by data, the result of division is again stored in the “in-cell data storage unit” of the same “derived cell”.

  In this step F3, when the calculation result column data field is defined in the table format as in this example, the “base data field” and the “derived data field” corresponding thereto are respectively calculated. Find a pair of calculation result column cells as the target data field. The pair of calculation result cells is regarded as a pair of “base cell” and the corresponding “derived cell”, and the same specified calculation is performed between the two. Replace the data in the calculation result column cell regarded as the “derived cell” side.

  The pair of “base cell” and the corresponding “derived cell” in the calculation result column data field identifies the calculation target data field for each calculation result column cell constituting the calculation result column data field as described above. Then, a pair of “derived data field” corresponding to “base data field” can be determined by identifying them as described above.

  In the case of this example, the data set in the “in-cell data storage unit” of the “base cell” in the second column, the fourth column, and the sixth column of the table are respectively represented by the corresponding third column, Divide by the data in the current “derived cell” that is set in the “in-cell data storage” of the “derived cell” in the column 7th column, and the division result is re-applied to the corresponding “derived cell”. Are stored in the “in-cell data storage unit”.

  Even in the total data field defined on the bottom row of the table, the data in the “base cell” on the second column, the fourth column, and the sixth column, and the corresponding third column and fifth column, respectively. , Divide by the data in the current “derived cell” set in the “in-cell data storage” of the “derived cell” on the seventh column, and divide the result of division again for the corresponding “derived cell”. It is stored in the “in-cell data storage unit”.

If the derivation condition specification word is “YoY increase” instead of “YoY change” in this example,
The registered term “vs. increase” in the “calculation designation 2” category of the application term dictionary 52 is detected, and the corresponding code (“2”) is set in the “calculation type” portion of the difference condition definition data.
In the “data output process” (step F1) and the “in-table calculation process” (step F2), the same process as in this example is performed. In this “corresponding cell calculation process (step F3),“ base cell The data in "" is subtracted by the data in the current "derived cell", and the subtraction result is stored again in the "in-cell data storage" of the corresponding "derived cell".

  If the derivation condition designation word is “%” instead of “YoY” in this example, the registered term “%” in the “operation designation 2” category of the application term dictionary 52 is detected, and the derivation condition definition data. Corresponding code (“11”) is set in the “calculation type” part.

  The “data output process” (step F1) and the “in-table calculation process” (step F2) are performed in exactly the same way as in this example. In this “inter-corresponding cell calculation process (step F3)”, the “base cell” The result obtained by dividing the data in the current “derived cell” by the value “100” is multiplied and the result is stored again in the “in-cell data storage” of the corresponding “derived cell”.

When “corresponding processing between corresponding cells” is completed, “character string data conversion processing” is performed on the data that has been transferred and aggregated on the output destination table. (Step F4) For each cell for which data has been output, the data stored in the “in-cell data storage section” in the corresponding cell data is extracted, and the corresponding character string data is created.
This is performed for data in cells constituting all data fields on the output destination table format except for the data of non-aggregated items originally entered on the output destination table format.

A cell in which a data character string is entered from the beginning can be detected by repeatedly collating the position information of the corresponding cell with the position information of each character string data on the document.
Also, if the data string entered from the beginning is aggregated numerical data, character string data is generated for the newly aggregated data and the corresponding character string data of the data entered from the beginning. Is deleted.

  Creation of character string data representing in-cell entry data is performed as follows. First, if the data extracted from the “in-cell data storage” in the cell data is numeric data, the numeric data is converted into text data by a known method. As a result, for example, data that simply represents the size of the numerical value “396” as numerical data is converted into text data that is an array of the characters “3”, “9”, and “6”.

  Corresponding character string data (position information is also defined) is created from text data as follows. The entry destination (position information) of the corresponding character string data can be determined from the position information of the corresponding cell and the in-cell arrangement format. The in-cell arrangement format can be read from the field format information attached to the field definition data to which the corresponding cell belongs. The character size, the character pitch, the arrangement position (for example, designation of right justification, centering, etc.), the color of the entered character, and the like. If the layout format is not specified by the user as in this example, it is determined by the device default.

  First, a rectangle that circumscribes the character string is obtained from the size and pitch of each character registered in the format information of the cell. Subsequently, the in-cell position of the circumscribed rectangle is obtained with reference to the in-cell arrangement position information of the character string (for example, designation of right justification, centering, etc.). Next, the document position of the corresponding character string can be obtained by referring to the document position of the corresponding cell (set in the corresponding cell data) and obtaining the document position of the circumscribed rectangle. . Corresponding character string data is created from the text data and position information thus obtained, and the address is set in the in-cell character string data address portion of the corresponding cell data (FIG. 19).

  The character string data generated as described above is stored in the document element data storage unit 38 together with other document element data originally written in the book table. Accordingly, the document image output unit 40 reads out all the document element data corresponding to the normal entry information (black) from the document element data storage unit 38, and stores the read document element data in the character / graphic pattern dictionary 36. The target document output document as shown in FIG. 47 is displayed on, for example, the display screen 20a by inquiring and identifying the pattern of each document element and converting each pattern into image data in bitmap format by a development program. can do. Further, it can be printed out by the printing device 22 or can be faxed by the communication device 24.

In the table format shown in FIG. 9, if no data is entered in the data field of the item name “Year” on the first row or the data field of the item name “Product” on the first column, Data output is performed as follows.
That is, first, in the cell name “year data” included in the record cell column extracted first from the output destination table format, or in the cell data “cell data storage” for the cell of the item name “product” As described above, the data of the corresponding item extracted first from the output source data file is set as it is.

  Thereafter, when the corresponding cell is included in another record cell column to be retrieved from the output destination table format, the first transferred data described above is used as the entry data of the corresponding cell, and the corresponding “in-cell data storage” The data is taken out from the “part” and set on the tabulation management table, and is collated with the data taken out from the output source data file.

  After all data is output, the entry data is sorted in the order specified for the data field of the item name “Year” or the data field of the item name “Product”, and then the data to be sorted The data on the same row or column may be sorted into corresponding positions.

(Other usage example 1)
Next, in FIG. 9, a table format in which “YoY comparison” entered as a headword in the third column, fifth column, and seventh column in the table is replaced with “Yellow ratio” (FIG. 48, black part). ), The handling performed by this system will be explained.

  In the case of this example, each of the data fields on the third, fifth, and seventh columns having the heading as “total ratio” has the item name “sales” adjacent to the left side thereof. As a “derived data field” in which the data field is “base data field”, each cell in the structure has the same “sales” as the data in the “base cell” adjacent to the left side and the item name in the table. The ratio to the total value of all data is entered.

  The user reads the entry conditions for the “derived data field” in the third, fifth and seventh columns in the table from the headword character string “vs. the overall ratio”. The substring “whole” in this headword is generally written as “the same item name in the same table” as a common promise among users who use the table unless otherwise defined in writing by the user. It is read as indicating “total value of all data belonging to (sales)”.

  In order to define the derivation condition character string of each “derivative data field” on the third, fifth, and seventh columns in this table, each headword character string “overall ratio” is “interpretation specified”. You can enclose it in the definition element “○”. Other table formats are defined in the same manner as in FIG. ((Blue portion in FIG. 48)) With the above definition, the meaning understood by the user is definitely defined.

  The designation by the “interpretation designation” definition element “◯” indicates that “partition ratio” and “whole” which are further partial character strings in the designated partial character string are “calculation designation” in the applied term dictionary 52, respectively. 2 ”and“ operation operand specification ”are registered terms. Furthermore, for the registered term“ whole ”, in the user interface (such as a user manual) of the application term dictionary 52, the comment sentence“ whole ” , Which is used as an operand for operation specification and means the total value of data belonging to the same item name in one table unless otherwise specified by the user. Do it.

  Now, the partial character string “whole” in the character string “whole ratio” surrounded by the specification element “○” of the “interpretation specification” is not specially specified by the user. According to the meaning registered in the dictionary 52 (meaning that is usually used by the user), it is determined as “the total value of data belonging to the same item name in the corresponding table”, and “comparison ratio” is also applied to the application term dictionary 52. According to the meaning registered as the “calculation designation 2” category, it is determined that the term indicates the ratio of the character string sandwiched between the data and the meaning of the character string.

  Then, the composite character string composed of the two, “overall ratio”, is interpreted according to the syntax rules of Japanese, which is the creation language of this table format, based on the meaning of each constituent word determined as described above. It is uniquely interpreted as “ratio of data belonging to the same item name with total value data”.

When the paper with the definition as described above is input to the system, the same process as described above is performed until the “derived field definition process” (step A3).
In the “derived field definition process” process (step A3), as in the case of FIG. 10, in step D1 in the “determination condition character string determination” procedure (FIG. 26), the corresponding character string “overall ratio” The designation by the “interpretation designation” definition element symbol “◯” is determined, and in the subsequent step D2, the application term dictionary registered term “contrast ratio” in the “calculation designation 2” section is detected.

  In the subsequent determination in step D3, it is determined that the remaining partial character string “whole” excluding the detected term “contrast ratio” is not an applied term dictionary registered term in the “relative designation” category, and the determination in step D6 Branch to In the determination of step D6, it is determined that the remaining partial character string “whole” excluding the detected term is a term registered as an “operating operand designation” category in the applied term dictionary 52. In the case of this example, it is determined that the corresponding character string “whole” is a term registered in the applied term dictionary 52 as the “operation operand specification” category, and the type 3 difference condition format and conditions are satisfied. It is determined as a thing. (Step D7)

  In this system, a character string that is in the above-mentioned “specific association” with one data field and satisfies the above format and conditions is used for purposes other than the definition of “derivative condition” of the data field. As such, the corresponding character string is definitely interpreted as the “derivative condition designator” of the corresponding “derived data field”.

  In this example, “derivative condition definition data” in which data is set as follows is created. First, in the “registered word” entry field in the “basic part” of the same data, the “representative name” “whole” in the applied term dictionary 52 is set, and the “calculation type part” in the “calculation designation part” ”Is set to the corresponding code“ 1 ”corresponding to“ to ** ratio ”, and“ operation operand section ”is set to the code“ 0 ”corresponding to“ specific specified value ”.

In the “data output process” (F1), since it is determined as “derivative condition type 3” in the leading step M1, the process branches to “data output process-2”. The “data output process-2” corresponds to a process in which the data output (step G6 to step G8) to the “derived cell” is skipped in the “data output process-1”.
The “in-table calculation process” (F2) is also performed only for the “normal data field” and the “base data field”.

  In “corresponding cell calculation” (F3), it is determined that “there is a calculation condition” by referring to the “calculation designating part” in the derived condition definition data in the leading step N1, and then in step N2. In the determination, since the “arithmetic operand section” of the same data is “specific designated value”, the process branches to the processing of step N5 and subsequent steps.

  In step N5, “specific specified value” as an operand is obtained by referring to “registered word text portion” in “basic portion” of the derived condition definition data. (Step N5) Since “whole” is now registered as the “registered word text portion”, this “specific specified value” is defined in the application term dictionary 52 according to the meaning on the corresponding table format. The total value of all data belonging to the corresponding “base data field” is obtained. In the case of this example, it is obtained as a total value of all data in the “base data field” whose corresponding item name is “sales”.

  Next, a specified operation is performed between the data in the “base cell” and the “specific specified value” obtained as described above. (Step N6) In the case of this example, the data in each “base cell” of the item name “sales” is divided.

  Finally, the calculation result data is entered in the corresponding “derived cell”. That is, the calculation result data is stored in the “in-cell data storage unit” in the cell data of the corresponding “derived cell”. (Step N4) “Derived cells” corresponding to each “base cell” can be obtained as described above. The subsequent “character string data conversion processing” (step F4) is performed in exactly the same manner as in FIG.

(Other use example 2)
Next, in the table of FIG. 9, a table in which “YoY comparison” entered as the data field heading in the third, fifth, and seventh columns is replaced with “Year 2000 comparison”. The handling performed by this system will be described.

  In the case of this example, each cell in the data field on the second column, the fourth column, and the sixth column with the heading “Sales” is entered in the top row on the same column in the table format. "2001", "2002", and "2003" are related data conditions for the item name "FY", but the headword is "compared to 2000" on the third column, The related data conditions for the item name “year” in the data field on the fifth column and the seventh column are all “2000”. The related data conditions for the item names other than “year” are all the same as the related data conditions of the data fields on the second column, the fourth column, and the sixth column adjacent to the left side thereof.

The data fields on the third column, the fifth column, and the seventh column that have this headword as “compared to 2000” are each based on the data field of the item name “FY” adjacent to the left side of each column. As a “derived data field”, which is a “data field”, first, data is aggregated and output based on the above-mentioned related data conditions to each cell constituting the data field, and further, a “base” adjacent to the left side with respect to this output data value. The ratio of the data in the “cell” is calculated, and this calculated value is entered.
The above entry conditions for each “derived data field” on the third column, the fifth column, and the seventh column of the table are as follows. We read from “compared to 2000”.

  As the definition of the derivation condition designation word of each “derivative data field” on the third, fifth, and seventh columns in this table, each headword character string “compared to 2000” is “interpretation designation”. The definition element “○” may be enclosed. Other definitions on the table format are performed in the same manner as in FIG. With the above definition, the meaning understood by the user is definitely defined.

  In the designation by the “interpretation designation” definition element “◯”, the “partial ratio” which is a further partial character string in the designated partial character string is classified into “operation designation 2” in the application term dictionary 52. Confirm that it is a registered term. In addition, a partial character string (in this example, “2000”) obtained by removing the above-mentioned applied term dictionary registered terms from the corresponding partial character string is defined as “data name” in other places on the same document. Make sure.

  As shown in this example, if the partial character string excluding the above application term dictionary registered term from the corresponding partial character string is not defined as “data name” elsewhere in the same document, As shown in (a) of 49, the corresponding item name “year” is entered in the appropriate position near the corresponding partial character string “2000” using the definition support entry information in (blue) color. It is surrounded by the definition element “<>” of “name designation” and connected by the “joining line” of the definition element.

  The relationship with the item name designation character string is any one of the three character strings “compared to 2000” repeatedly entered in the third, fifth, and seventh columns of the table. You can do it. When the corresponding item name is entered adjacent to the corresponding partial character string, the association by the definition element “joining line” may be omitted.

  With the above definition, as described above, the meaning of “contrast ratio” is determined according to the application term dictionary 52 in the character string that has received “interpretation designation”, and “2000” is the item name “year” ", And the whole meaning of the combination of both is uniquely interpreted by the syntax rules, and the meaning understood by the user is definitively defined.

    When the sheet with the definition as described above is input to the system, the same process as in FIG. 10 is performed until the “derived field definition process” (step A3). In the “derived field definition processing” process (step A3), as in the case of FIG. 10, in step D1 in the “determination condition character string determination” procedure (FIG. 26), the corresponding character string “compared with 2000” The designation by the “interpretation designation” definition element symbol “◯” is determined, and in the subsequent step D2, the application term dictionary registered term “to ... ratio” in the “calculation designation 2” section is detected.

  In the subsequent determination of step D3, the remaining partial character string “2000” excluding the detected term “comparison ratio” is not searched as a registered term in the “relative designation” category in the applied term dictionary 52. The process branches to the determination in step D6. The corresponding character string “2000” is not searched as a registered term in the “operating operand designation” category in the applied term dictionary 52 even in the determination in step D6, and therefore the determination proceeds to step D8.

  In step D8, first, it is determined that the character string “2000” to be determined is defined as “data name” in another location on the same document. For all the item definition data fields defined on the document, it is only necessary to take out one data character string written therein and collate it. If it can be detected that the partial character string to be judged is entered as “data name” in the item definition data field defined on the document, this partial character string is the “data name” defined by the user. And the process proceeds to the confirmation process after step D9.

  If the above determination cannot be obtained, the character string enclosed by the definition item “<>” of “Item name specification” is entered adjacent to the character string part to be determined, or the character to be determined It is determined that it is connected to the column part by a connecting line. The adjacent positional relationship between these character strings, or the positional relationship between the character string and the connecting line can be determined by repeating collation of the position information on the document for each corresponding character string data or each line segment data. . Judgment of the adjacency relationship between character strings is determined that a circumscribed rectangle of two character strings has a common range when viewed from one direction in the vertical and horizontal directions, and is located within a certain threshold when viewed from the right angle direction. You can do that.

  If the above judgment cannot be obtained for the character string part to be judged, the character string with the same name as the character string part to be judged is defined in the other parts of the same document by defining the definition item “item name designation” < It is determined that the character string enclosed by “>” is connected by a connecting line.

  In this example, the determination target character string “2000” in the third column of the table is surrounded by the definition item “<>” of “item name designation”, and the determination target character string portion and the connecting line Is detected, and the determination in step D8 is obtained. Therefore, the determination target character string “2000” on the fifth column and the seventh column of the table is also determined in step D8. Is obtained.

  If the determination in step D8 is obtained, it is determined that the partial character string to be determined is a “data name” defined by the user, and the process proceeds to the confirmation process in step D9 and subsequent steps. If the above determination cannot be obtained, an appropriate message is displayed on the display, and the procedure for creating the entire definition data (FIG. 22) is completed.

  In step D9, it is confirmed that the corresponding item name of the partial character string to be determined is defined as the corresponding item name of the item definition at another location on the document. What is necessary is just to perform the same thing as above-mentioned step D4. In step D8, if the determination defined as “data name” is obtained elsewhere in the same document, this step D9 may be skipped because the process is duplicated.

  In the case of this example, the character string “2000” to be determined has a corresponding item name “year” whose item definition data field (data “2001”, “2002”, “2003” on the top row) in the table format. It is confirmed that it is also defined as the corresponding item name of the data field in which the year is entered.

  If the confirmation of step D9 is obtained, the process proceeds to the confirmation process of step D10. In step D10, it is first determined that the corresponding item name of the data name character string to be determined is a term registered as the “year / month / day item” category in the applied term dictionary 52, and the determination is obtained. If it is, the data name character string to be judged is entered in the same entry form as the data character string entered in the item definition data field of the same item name defined elsewhere in the document. Make sure.

The format of the partial character string to be judged is obtained by analyzing the same procedure as the procedure for obtaining the “year / month / day format data” described above, and the “item definition data field of the same item name already obtained on the document” Compare with "Date format data".
In the case of this example, it is determined that the character string “2000” to be determined is a term whose corresponding item name “year” is registered as the “year / month / day item” category in the applied term dictionary 52, In addition, it is confirmed that the data is entered in the same format as the character string data “2001”... In the item definition data field on the top line in the table format.

If the confirmation in step D10 is obtained, it is determined that the corresponding character string satisfies the format and condition of the type 4 derivative condition. (Step D11)
In this system, a character string that is in the above-mentioned “specific association” with one data field and satisfies the above format and conditions is used for purposes other than the definition of “derivative condition” of the data field. The corresponding character string is definitely interpreted as the “derived condition character string” of the corresponding “derived data field”.

  In this example, “derivative condition definition data” is created as follows. The corresponding “year” and “2000” are set in the “item name text” entry field and “data name text” entry field in the “basic part” of the data, respectively. In addition, in the “calculation type part” in the “calculation designation part”, the corresponding code “1” corresponding to “to ** ratio” is set, and in the “operation operand classification part”, “data in derived cell” A code “0” corresponding to is set.

In the “data output process” (F1), in the leading step M1, it is determined that the “derivative condition type 4”, and “data output process-1” (step M2) is performed. In “data output processing-1”, processing different from the case of FIG. 10 is performed in step G7.
That is, in step J2 “determination of related data difference condition” in step G7 (FIG. 41), this example corresponds to the case of “direct designation”. Therefore, the process branches to step J5 and the corresponding data in the main record is changed to “ It is directly replaced by the data in “Data name text part” in “Basic part” in “Derived condition definition data”.

  In the case of this example, the “corresponding data on the fourth row of the tabulation management table” is replaced with the data “2000.” The following “in-table calculation process” (step F2), “corresponding cell calculation process” ( Step F3) and “character string data conversion processing” (step F4) are performed in the same manner as in FIG.

(Other usage example 3)
Next, in the table of FIG. 9, the handling performed by this system for the table in which “Year-on-Year comparison” entered as the headword in the third, fifth and seventh columns is replaced with “previous year” explain.

  In this example, each cell in the data field of the second column, the fourth column, and the sixth column with the heading “Sales” is entered in the top row on the same column in the table format. "2001", "2002", and "2003" are related data conditions for the item name "FY", but the headword is "previous price" on the third and fifth columns The related data condition for the item name “year” of the data field in the seventh column is the year corresponding to “the previous year” of the related data condition for the item name “year” of the adjacent data field on the left side thereof. The related data conditions for the item names other than “year” are all the same as the related data conditions of the data field on the second column or the fourth column adjacent to the left side thereof.

  The data fields on the third column, the fifth column, and the seventh column that have the headword as “previous year value” are “derived data” in which each data field adjacent to the left side is “base data field”. As the “field”, data is tabulated and output based on the related data conditions described above. The user reads the above entry conditions for each “derived data field” in the third column, the fifth column, and the seventh column from the headword character string “previous year value” entered thereon. ing.

  To define this derivation condition, the partial character string “previous year” in the headword character string “previous year value” may be enclosed by the definition element “o” of “interpretation designation”. Other definitions are made in the same manner as in FIG. With the above definition, the meaning understood by the user is definitely defined.

When the sheet with the definition as described above is input to the system, the same process as in FIG. 10 is performed until the “derived field definition process” (step A3).
In the “derived field definition processing” process (step A3), as in the case of FIG. 10, in step D1 in the “determination condition designation word determination” procedure (FIG. 26), for the corresponding character string “previous year” The designation by the “interpretation designation” definition element symbol “◯” is determined. However, in the subsequent step D2, the application term dictionary registered term in the “calculation designation 2” section is not detected, so the process branches to step D12.

  In step D12, it is determined that the character string designated by the “interpretation designation” definition element is registered as a “relative designation” category in the applied term dictionary 52. In this example, the character string “previous year” to be determined is searched in the applied term dictionary 52 as a registered term in the “relative designation” category.

  If the determination in step D12 is obtained as in this example, then, in the applied term dictionary 52, the “affiliation item name” registered in a form associated with the corresponding registered term is identified, Confirm that “Affiliation Item Name” is defined as the corresponding item name of the item definition on the corresponding table. (Step D13) In this example, in this step D13, the corresponding “affiliation item name” “year” is defined as the corresponding item name of the item definition data field defined in the top row of the table format. It is confirmed.

  If the determination in step D13 is obtained, it is determined that the type 2 derivation condition type and condition are satisfied. (Step D14) In this example, it is determined that the corresponding character string “previous year” corresponds to this case. In this system, a character string that is in the above-mentioned “specific association” with one data field and satisfies the above format and conditions is used for purposes other than the definition of “derivative condition” of the data field. As such, the corresponding character string is definitely interpreted as the “derivative condition character string” of the corresponding composite field.

  In this example, “derivative condition definition data” is created as follows. First, the corresponding “representative name” “previous year” in the applied term dictionary 52 is set in the “registered word” entry field in the “basic part”, and the “calculation type part” in the “calculation designation part” The corresponding code “0” corresponding to “No operation specified” is set, and the code “0” corresponding to “Derived cell data” is set in the “Operation operand section”.

Further, when the “operation operand classification” is “derived cell data” as in this example, the belonging item name of the data in the corresponding derived area is set in the “item name text” entry field.
In this example, for the registered term “previous year” in the “relative designation” category in the applied term dictionary 52, the affiliation item name “year” referred to in step D4 is entered.

  The “data output process” (step F1) is exactly the same as the case of FIG. 10 because the “related data difference condition” is the same. The “in-table calculation process” (step F2) is similarly performed. However, in this example, the following “operation between corresponding cells” (step F3) is set to “no operation specified” in the “operation type part” in the “derivative condition definition data” in the first determination in step M1. It is referred to that the corresponding code is set, and the subsequent processing is skipped. The subsequent “character string data conversion processing” (step F4) is performed in exactly the same manner as in FIG.

(Other use example 4)
Next, in the table of FIG. 9, this system will handle the table in which “Year-on-Year” entered as the headword in the third, fifth, and seventh columns is replaced with “2000 value”. Will be described.

  In the case of this example, each cell in the data field on the second column, the fourth column, and the sixth column with the heading “Sales” is entered in the top row on the same column in the table format. "2001", "2002", and "2003" are related data conditions for the item name "FY", but the headword is "compared to 2000" on the third column, The related data conditions for the item name “year” in the data field on the fifth column and the seventh column are all “2000”. The related data conditions for the item names other than “year” are all the same as the related data conditions of the data field adjacent to the left side thereof.

  The data fields on the third column, the fifth column, and the seventh column that have this headword as “compared with 2000” are the data fields adjacent to the left side of each column as “base data fields”. As the “derived data field”, data is aggregated and output in each constituent cell based on the above related data conditions.

  The user enters the above entry conditions for each “derived data field” on the third column, the fifth column, and the seventh column from the headword character string “2000” entered thereon, respectively. I'm reading.

  In order to define the derivation condition designation word for each “derived data field” in the third, fifth, and seventh columns in this table, the partial characters in each headword character string “2000 value” are as follows. The column “2000” may be enclosed by the definition element “[]” of “Data name designation”. If the partial character string enclosed by the definition element of “data name designation” is not defined as “data name” elsewhere in the same document as in this example, (b) in FIG. As shown in the table, the corresponding item name “Year” is entered in the appropriate position near the corresponding partial character string “2000” using (blue) definition support entry information, and the definition of “item name designation” is defined. Enclose with element “<>” and connect with “join line” of definition element.

  The relationship with the item name designation character string is any one of the three character strings “compared to 2000” repeatedly entered in the third, fifth, and seventh columns of the table. You can do it. When the corresponding item name is entered adjacent to the corresponding partial character string, the association by the definition element “joining line” may be omitted. Other definitions are made in the same manner as in FIG. With the above definition, the meaning understood by the user is definitely defined.

  When the sheet with the definition as described above is input to the system, the same process as in FIG. 10 is performed until the “derived field definition process” (step A3). In the “derived field definition processing” process (step A3), in step D1 in the “determination condition character string determination” procedure (FIG. 26), the corresponding character string is designated by the “interpretation designation” definition element symbol “◯”. Since it is not determined, the process branches to the determination in step D15.

  In step D15, it is determined that the definition element symbol “[]” of “data name designation” is attached to the corresponding character string. If this determination is obtained, as in the case of the second usage example, It is determined that the character string enclosed by these symbols is defined as “data name” elsewhere in the same document.

If this determination is not obtained, is a character string enclosed by the definition item “<>” of “item name specification” adjacent to the character string enclosed by the definition element symbol of “data name specification”? Or it is determined that they are connected by a connecting line.
If the above judgment cannot be obtained for the character string part to be judged, the character string with the same name as the character string part to be judged is defined as the “element name designation” definition element in other places on the same document. It is determined that the character string enclosed by <> ”is connected by a connecting line.

  In the case of this example, for the character string “2000” to be judged on the third column of the table, the character string “year” surrounded by the definition item “<>” of “item name designation” is connected by a connecting line. Since the determination in step D15 is obtained, the determination in step D15 is also obtained for the character string “2000” on the fifth column and the seventh column in the table. Become.

  If the above detection and determination are obtained in step D15, the confirmation processing in steps D16 and D17 is subsequently performed. The confirmation process of step D16 and step D17 is the same as the confirmation process of step D9 and step D10 described above. If confirmation in step D17 is obtained, it is determined that the character string satisfies the type 1 condition and condition of the type 1 difference condition. (Step D18)

  In the case of this example, the character string “2000” to be determined is defined as the corresponding item name of the item definition data field on the top row in the table format in the confirmation in step D16. In the confirmation of step D17, it is confirmed that the data is entered in the same format as the character string data “2001”... In this item definition data field. The

  In this system, a character string that is in the above-mentioned “specific association” with one data field and satisfies the above format and conditions is used for purposes other than the definition of “derivative condition” of the data field. As such, the corresponding character string is definitely interpreted as the “derivative condition character string” of the corresponding composite field.

  In this example, the “item name text” entry field and the “data name text” entry field in the “basic part” in the “derivative condition definition data” are respectively “year” and “2000”. Is set. In addition, in the “calculation type part” in the “calculation designation part” in the same data, the corresponding code “0” corresponding to “no operation designation” is set, and in the “operation operand classification part”, “derived cell” A code “0” corresponding to “internal data” is set.

The “data output process” (step F1) is performed in exactly the same way because the “related data difference condition” is the same as in the case of the “other use example 2”. The “in-table calculation process” (step F2) is similarly performed. However, in this example, since “calculation conditions” are not defined, the subsequent “inter-corresponding cell calculation processing” (step F3) is performed in the “derivation condition definition data” in the first determination in step M1. It is referred to that the corresponding code of “no operation specified” is set in the “operation type part”, and the subsequent processing is skipped. The subsequent “character string data conversion processing” (step F4) is performed in exactly the same manner as in FIG.

  The handling performed by the system in the case of the table format shown in FIG. 50 will be described. The definition operation for the table format shown in FIG. 50 is performed in the same manner as described above (the (blue) color portion in FIG. 50). The data “2003” entered as a common condition outside the table is enclosed by the definition element symbol of “”, and the character string “FY” is entered as the (blue) definition support entry information at the left adjacent position. The definition element symbol specified by “Item name” is enclosed.

  In the definition data creation process by the system, “field definition data” and “derivative condition definition data” are created in the same manner as described above. However, for the common condition data “2003” outside the table, “field definition data” in which the corresponding code “1” is set in the “common category” column is created, and the “first cell data address” portion is created. The character string data representing the character string “2003” is set instead of the cell data address of the first cell in the cell string.

  In the “identification of base data field” process (step P2) in the definition data creation process by the system, for each “derived data field” having the headword “YoY comparison” in the third column and the fifth column from the left side, The “base data field” is not determined in steps Q1 and Q2. In step Q3, for each of them, “designated data field” having “sales” in the second column as an entry word and on the fourth column. A “designated data field” having “profit” as a headword is determined.

  In the case of this example, in the set of “base records” on the tabulation management table in “data output processing” (step G3), the data “2003” of the item name “year” is included in all the base records extracted from the table. Year "is set. The derived record is created from the “base record” in the same manner as described above, and the data in the derived area can be obtained by outputting data thereon.

  It is also possible to partially extend and change the embodiment apparatus so that data entry in the “derived data field” in which the above-described three types of derivation conditions are defined can be performed in the form of an in-table calculation function. . For example, it is assumed that data has already been entered by the user in the data field of the item name “sales” in the format of the table shown in FIG. No data has been entered yet in the “derived data field” on the third, fifth, and seventh columns, with the total field on the bottom row and the “overall ratio” as the headword.

  The defining operation is performed on the paper or on the screen in the same manner as described in “Other use example 1”, and each definition data is created in the same manner. When the user performs a specific instruction operation for in-table calculation instead of the “output” instruction operation described above (clicking the “execute output” button), the system first fills in each item definition data field. Character string data representing numbers is converted into corresponding numerical data by a known method, and the obtained numerical data is stored in the “in-cell data storage unit” in the cell data of the corresponding cell.

  Subsequently, the system performs “in-table calculation processing” (F2) and subsequent steps in “total output processing”. In this example, the “in-table calculation process” (F2) is performed only for the “normal data field” and the “base data field”. In the “corresponding cell calculation” (F3), in the same manner as in the above case (“other usage example 1”), in step N5, the “specific designated value” is similarly obtained, and the data in the “base cell” An operation specified with the “specific specified value” obtained as described above is performed. The calculation result data is stored in the “in-cell data storage unit” in the cell data of the corresponding “derived cell”. The “character string data conversion process” (step F4) is performed in exactly the same manner.

  The present invention uses a program or software for realizing the functions of the present invention described above. Such software can be installed in the system of the present invention via an arbitrary medium, for example, by a storage medium or online. Therefore, an act of transferring a storage medium storing software for implementing the present invention as a business, an act of installing the software in a system online, and the like are one embodiment of the present invention.

It is a block diagram which shows the system configuration example on the hardware of the information processing apparatus by one Example of this invention. It is a figure which shows the list of main modes in the system of an Example. It is a figure which shows the "main mode-view menu screen" in the system of an Example. It is a figure which shows the "environment setting mode screen" in the system of an Example. It is a figure which shows the "definition element / entry information comparison table" in the system of an Example. It is a figure which shows the data format example of the "definition element identification data" in the system of an Example. It is a figure which shows the "definition information distinction instruction | indication screen" in the system of an Example. It is a figure which shows the data format example of the "definition information distinction data" in the system of an Example. It is a figure which shows the 1st book table format in the system of an Example. It is a figure which shows an example which additionally entered the definition support entry information in the 1st book table format in the system of an Example. It is a block diagram which shows the structure of the document input and document element data generation part in the system of an Example. It is a figure which shows the example of a data format of "image management data" in the system of an Example. It is a figure which shows the structure of the input image used as the object of "image management data" in the system of an Example. It is a figure which shows the example of a data format of "character data" in the system of an Example. It is a figure which shows the data format example of the "character string data" in the system of an Example. It is a figure which shows the example of a data format of "graphic element data" corresponding to the line segment in the system of an Example. It is a figure which shows the data format example of the "graphic element data" corresponding to an ellipse in the system of an Example. It is a figure which shows the data format example of the "graphic element data" corresponding to the rectangle etc. in the system of an Example. It is a figure which shows the data format example of the "cell data" in the system of an Example. It is a block diagram which shows the structure of the definition information recognition and format setting part in a system of an Example, and a definition execution process part. It is a figure which shows the data format example of the "definition element data" in the system of an Example. It is a figure which shows an example of the whole procedure of the definition data creation in the system of an Example. It is a figure which shows the example of a data format of the "field definition data" in the system of an Example. It is a figure which shows the data format of the "year format definition data" in the system of an Example. It is a figure which shows the "form classification of a derivation condition" in the system of an Example. It is a figure which shows the flowchart of the "derivation field definition process" in the system of an Example. It is a figure which shows the flowchart of "derivation condition determination" in the system of an Example. It is a figure which shows the flowchart of "derivation condition determination" in the system of an Example. It is a figure which shows the flowchart of "derivation condition determination" in the system of an Example. It is a figure which shows the example of the term currently contained in the application vocabulary dictionary in the system of an Example. It is a figure which shows the data format example of the "application term definition data" in the system of an Example. It is a figure which shows the flowchart of the "base field identification" in the system of an Example. It is a figure which shows the example of a data format of "derivative condition definition data" in the system of an Example. It is a figure which shows the data format of the "calculation result column definition data" in the system of an Example. It is a figure which shows the screen of the definition by the instruction | indication from the screen in the system of an Example. It is a figure which shows an example of the "item name designation menu" in the system of an Example. It is a figure which shows the example of a record structure of the file of the output source in the system of an Example. It is a figure which shows an example of the data output mode screen in the system of an Example. It is a figure which shows the flowchart of the "data output whole process" in the system of an Example. It is a figure which shows the flowchart of the "data output process" in the system of an Example. It is a figure which shows the flowchart of the "data output process 1" in the system of an Example. It is a figure which shows the image of the "total management table" in the system of an Example. It is a figure which shows the flowchart of the "record data output process" in the system of an Example. It is a figure which shows the flowchart of the "data change process for derivative records" in the system of an Example. It is a figure which shows the flowchart of the "data change process" based on the registration word "previous year" in the system of an Example. It is a figure which shows the flowchart of the "corresponding cell calculation process" in the system of an Example. It is a figure which shows the example of a data output to the book table format of FIG. 9 in the system of an Example. It is a figure which shows an example which additionally filled in the definition assistance entry information in the other book table format in the system of an Example. It is a figure which shows an example which additionally filled in the definition assistance entry information in the other book table format in the system of an Example. It is a figure which shows an example which additionally filled in the definition assistance entry information in the other book table format in the system of an Example. It is a figure which shows an example of the table format produced when performing the data output to the book table format of FIG. 9 using the present technique. It is a figure which shows an example of the table format produced when performing the data output to the book table format of FIG. 9 using the present technique.

Explanation of symbols

10 Color Image Scanner 12 Keyboard 14 Mouse 15 Digitizer 16 Internal Memory 18 External Memory 20 Display Device 24 CPU
27 Communication Device 30 Document Image Input Unit 32 Document Image Storage Unit 34 Character / Graphic Element Recognition Unit 36 Character / Graphic Pattern Dictionary 37 Character / Graphic Element Input Unit 38 Document Element Data Storage Unit 40 Document Image Display Output Unit 42 Definition Element Data Generation Unit 44 definition element data storage unit 46 definition data generation unit 48 definition element identification data storage unit 50 definition information distinction data storage unit 52 applied term dictionary 54 book table definition data storage unit 90 data item name 92 field 94 definition element designation subscreen 95 Definition interpretation button 96 Item name designation menu 98 Item name entry field 100 Derived condition designation field 104 Field format instruction field 110 Derived data field side item name entry field 112 Derived data field side data name entry field 113 Derived data field side registered word entry field 114 Derived data field side field book Instruction column 115 operation entry column 120 end button
130 Derived condition specification area

Claims (17)

The data entry conditions that define the data to be entered in one data entry area on the table format are based on the data entry conditions of the other data entry areas having the same item name on the same table format or the data entry conditions. A table format data input / output method including a derived entry area that is a data entry area defined by the format of a derived condition that indicates a change. A step of defining a base entry area which is a reference data entry area;
Identifying the data in the base entry area or the data entry conditions, and generating the data in the derived entry area based on the definition of the derived condition defined above;
Table format data processing method in an information processing apparatus having The base record that is a combination of the data entry area of the data to be referred to simultaneously with the data in the corresponding base entry area or the data to be referred to at the same time as the data in the relevant base entry area as the entry condition in the applicable base entry area. Identifying from the table format;
As a derivation condition, a step of defining a related data difference condition that indicates a change to specific data constituting the base record,
Based on the definition of the related data difference condition, the specific data constituting the base record is changed, and the data to be referred to at the same time as the data in the corresponding derived entry area as the entry condition of the corresponding derived entry area, or the applicable Generating a derived record that is a combination of data entry areas of data to be referenced simultaneously with data in the derived entry area;
The method according to claim 1, further comprising: obtaining data in a corresponding entry entry area by outputting data on the derived record. For the derivation condition defined in such a way that the data in the corresponding base entry area is designated as the first operand and a specific operation is designated for it, it is the same as the operation instruction condition indicating the type of the operation and the corresponding base entry area. Defining an operation operand condition having an item name and representing a condition for generating the second operand data of the operation;
Generating the second operand data for the derived entry area based on the operational operand condition;
Between the data in the corresponding base entry area, which is the first operand, and the second operand data, and the operation determined by the corresponding operation instruction condition is entered, and the result data is entered in the corresponding derived entry area. The method according to claim 1. Specification that constitutes a base record that is a combination of data to be referred to at the same time as data in the corresponding base entry area or data entry area of data to be referred to at the same time as data in the relevant base entry area as the above-mentioned operation operand condition Defining relevant data variance conditions that direct changes to the data;
This is a combination of data or data entry areas that should be referred to at the same time when data is output to the corresponding “derived entry area” by making changes based on the relevant data difference conditions for the relevant base record. Generating a derived record;
The data in the derived entry area is obtained by outputting data on the derived record, and the output data in the derived entry area is used as the second operand. The method described.   A specific term used by a user on a daily basis to express the above related data difference condition is associated with its belonging item name, separated from other registered terms and registered in the dictionary means, and then entered in the corresponding entry entry area. 5. The method according to claim 2, wherein, for the associated character string, the definition content of the related data difference condition according to the meaning registered in the dictionary is determined by searching the dictionary registration term. A step in which a specific term used by the user as a daily operation instruction condition or a specific term used as the operation operand condition is registered in the dictionary means separately from each other;
Based on the arrangement order of terms belonging to each of the above-mentioned sections constituting one character string, which is determined by the syntax rules of the language used, it belongs to each of the above-mentioned sections from the character string associated with the derived entry area. Searching and identifying registered terms;
5. The method according to claim 3, further comprising: defining contents of an operation instruction condition and an operation operand condition based on a meaning of a registered term belonging to each category identified by search. Referring to the dictionary and identifying the belonging item name of the particular registered term;
Obtaining the data in the position on the order sequence shifted by the change represented by the meaning of the corresponding registered term starting from the data in the corresponding base entry area in the order sequence of the belonging data determined for the identified belonging item name;
6. The corresponding record is created by replacing the data of the corresponding item name in the base record created for the corresponding base entry area with the data obtained based on the corresponding registered term, and generating the corresponding derived record. the method of. By registering the specific term used as the calculation instruction condition on a daily basis by the user in the dictionary means separately from other registered terms, and associating the registered term with the corresponding entry entry area,
The method according to claim 3 or 4, wherein an operation type is determined according to the meaning represented by the corresponding registered term. A step of registering a specific term used as an arithmetic operand condition by the user on a daily basis separately from other registered terms in the dictionary means;
Associating this particular registered term with the corresponding derived area;
In accordance with the meaning of the corresponding registered term, after reading data from the corresponding table format, performing a calculation determined by the meaning of the relevant registered term;
The method according to claim 3, wherein the operation result data obtained is used as the second operand.   7. A specific designating operation for designating that the character string is definition content configuration information to be analyzed based on the dictionary or a syntax rule of a language to be used. The method described in 1.   6. The specific characterizing that indicates that the character string is the definition content configuration information to be analyzed based on a dictionary or a syntax rule of a language to be used is attached to the corresponding character string. 6. The method according to 6. Identifies data that is on the same row or column as each base entry area and each derived entry area in the table format, and that belongs to an item name that is different from the item names in the corresponding base entry area and derived entry area Steps,
Share data belonging to item names that are on the same row / column as described above and that are different from the item names in the corresponding base entry area and derived entry area in both the row and column directions of the table format. Identifying the combination of base and derived entry areas to be performed;
The method of claim 1, wherein a combination of a base entry area and a derived entry area on a table format is identified by comprising: Associating a first operation result entry field with a set of first data entry areas that are on the same row or in the same column on the table format and are composed of base entry areas having the same item names;
Associating a second calculation result entry field with a second set of data entry areas comprising each derived entry area corresponding to each base entry area constituting the first set of data entry areas; ,
A step of performing an operation defined for the first operation result entry column for the data in each base entry area constituting the first set and entering the operation result data in the first operation result entry column When,
For each data output from the data file in each derived entry area constituting the second set, an operation defined for the first operation result entry field is performed, and the operation result data and the first Performing a calculation in accordance with the calculation instruction condition with the data in the calculation result entry column, and entering the calculation result data in the second calculation result entry column;
The method of claim 2 comprising: The data entry conditions that define the data to be entered in one data entry area on the table format are based on the data entry conditions of the other data entry areas having the same item name on the same table format or the data entry conditions. A data input / output device in a table format that includes a derived entry area that is a data entry area defined by the format of a derived condition that indicates a change. Means for defining a base entry area, which is a standard data entry area;
Means for identifying the data in the corresponding base entry area or the data entry conditions and generating data in the corresponding entry entry area based on the definition of the derived condition defined above;
A table format data processing apparatus. The base record that is a combination of the data entry area of the data to be referred to simultaneously with the data in the corresponding base entry area or the data to be referred to at the same time as the data in the relevant base entry area as the entry condition in the applicable base entry area. Means for identifying from the table format;
As a derivation condition, a means for defining a related data difference condition that instructs a change to the specific data constituting the base record;
Based on the definition of the related data difference condition, the specific data constituting the base record is changed, and the data to be referred to at the same time as the data in the corresponding derived entry area as the entry condition of the corresponding derived entry area, or the applicable Means for generating a derived record that is a combination of data fields of data to be referenced simultaneously with data in the derived fields;
15. The table format data processing apparatus according to claim 14, wherein the data in the corresponding entry entry area is obtained by outputting data on the derived record. For the derived condition defined in the form of designating a specific operation for the data in the corresponding base entry area as the first operand, the same as the operation instruction condition indicating the type of the operation and the corresponding base entry area Means for defining an operation operand condition having an item name and representing a condition for generating the second operand data of the operation;
Means for generating the second operand data for the derived entry area based on the operation operand condition;
Between the data in the corresponding base entry area, which is the first operand, and the second operand data, and an operation determined by the corresponding operation instruction condition is entered, and the result data is entered in the corresponding derived entry area. 15. The table format data processing apparatus according to claim 14, wherein the table format data processing apparatus is a table format data processing apparatus. Specification that constitutes a base record that is a combination of data to be referred to at the same time as data in the corresponding base entry area or data entry area of data to be referred to at the same time as data in the relevant base entry area as the above-mentioned operation operand condition A means for defining relevant data difference conditions that direct changes to the data;
This is a combination of data or data entry areas that should be referred to at the same time when data is output to the corresponding “derived entry area” by making changes based on the relevant data difference conditions for the relevant base record. A means of generating a derived record;
The data in the derived entry area is obtained by outputting data on the derived record, and the output data in the derived entry area is used as the second operand. The table format data processing device described.