JP2000315242A - Summary table creating device and storage medium for summary table creating program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a summary table creating device to easily acquire a summary table to extract information desired by a user among pieces of information which are potentially included in a data table, etc., in which pieces of data are stored and a storage medium for summary table creating program which is constituted by storing a summary table creation program to operate a computer system as such a summary table creating device. SOLUTION: Items of registered data are presented as candidates for vertical and horizontal axes (a step S101), input of plural items selected from among the presented items is accepted (a step S102), the registered data is sorted into plural dimensions corresponding to the plural items, the sorted data is summed up (a step 103) and the summary table to indicate a summary result is created (a step S106) by this summary table creating device.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a tally table creating apparatus for tallying data and creating a tally table, and a tally table storing a tally table creating program for operating a computer system as such a tally table creating apparatus. The present invention relates to a creation program storage medium.

[0002]

2. Description of the Related Art In general, in a company or the like, employee data including various items related to employees such as employee numbers and departments, and business data including various items related to tasks such as the date and content of the task are stored in a data table or the like. ing. The data table potentially stores various useful information such as employee trends and business trends. For this reason, when such useful information becomes necessary, data aggregation is performed from the viewpoint of focusing on desired information among the useful information, thereby extracting employee trends and the like. A summary table is created to represent it.

[0003] By the way, with the spread of personal computers, it has been strongly desired that business processes such as data tabulation be replaced by personal computers. Therefore, conventionally, a system engineer has provided a dedicated program for creating a summary table by performing data aggregation from a specific viewpoint aimed at extracting specific information from information potentially stored in a data table. Data compilation and creation of a summary table are performed using a dedicated program. Alternatively, general-purpose spreadsheet software is used to perform data tabulation and tabulation.

[0004]

However, a dedicated program supplied by a system engineer aggregates data from a specific point of view. On the other hand, a viewpoint of information desired by a company or the like is different. It often changes. For this reason, data aggregation using a dedicated program often fails to obtain desired information with the passage of time. In such a case, a dedicated program that aggregates data from the viewpoint of the desired information at that time Need to be re-ordered, resulting in a large burden on time and costs.

[0005] Further, general-purpose software is provided with abundant commands and functions for data tabulation and tabulation table creation, so that the degree of freedom in data tabulation and the like is extremely large. Therefore, in order to extract information desired by the user from the data table among various information potentially included in the data table or the like in which data is stored, sufficient knowledge of abundantly prepared commands and the like is required. is necessary. Moreover, since the data stored as the data table includes various items, it is necessary to make use of advanced functions among functions provided in general-purpose software in order to extract desired information. . On the other hand, in a company or the like, a clerk or the like is in charge of a task of extracting desired information from the data table, and this clerk can generally create a handwritten totaling table. It does not necessarily have the knowledge to use general-purpose software to a high degree, and it is difficult to extract desired information using general-purpose software.

SUMMARY OF THE INVENTION In view of the above circumstances, the present invention provides a tally table creating apparatus that can easily obtain a tally table for extracting desired information as described above, and a tally table that causes a computer system to operate as such a tally table creating apparatus. It is an object of the present invention to provide a tally table creation program storage medium in which a creation program is stored.

[0007]

According to an embodiment of the present invention, there is provided a tabulation table creating apparatus which stores a plurality of sets of individual data corresponding to a plurality of items. An item presenting means for presenting an item; an item selecting means for receiving an operation of selecting a plurality of desired items from the items presented by the item presenting means; and a plurality of data stored in the data storage means. A totaling means for classifying data into a plurality of dimensions corresponding to a plurality of items selected by the operation accepted by the user and totaling the classified data; It is characterized by the following.

In the tallying table creating apparatus according to the present invention, the tallying means includes a plurality of tallying methods for tallying data, and the method presenting means presents the plurality of tallying methods provided in the tallying means. And a method selecting means for receiving an operation of selecting a desired tallying method from the tallying methods presented by the method presenting means, wherein the tallying means selects the tallying method selected by the operation received by the method selecting means. It is preferable that the data be totalized by using.

According to the tallying table creating apparatus of the present invention, from the items and tallying methods presented by the item presenting means and the method presenting means, items matching the desired viewpoint for extracting desired information and the like are included. By being selected by the user,
Data classification and tallying that match a desired viewpoint are performed to create a desired tally table, so that desired information is easily obtained.

[0010] Further, in the tabulation table creating apparatus of the present invention, the data storage means may include a first data set composed of a set of individual data corresponding to each of one or more items.
, A second set formed by collecting second data consisting of a set of individual data corresponding to each of one or more items permitted to include an item different from the above items, and a first set. And storing a correspondence relationship between each of the first data to be configured and each of the second data to be included in the second set,
The item presenting means presents both the first data item and the second data item, and the item selecting means transmits the desired plural items in both the first data item and the second data item. , A set presenting means for presenting the first set and the second set as options for selecting a set, a first set and a second set presented by the set presenting means And a set selecting means for receiving an operation of selecting one set from among:
The counting means converts the long data consisting of the first data and the second data mutually associated according to the correspondence stored in the data storage means into a plurality of items selected by the operation received by the item selection means. It is preferable to classify the data of the sets selected by the operation received by the set selecting means into corresponding plural dimensions from the viewpoint that they are mutually independent, and to total the classified long data.

However, the number of sets of data stored in the data storage means is not limited to two, and three or more sets of data may be stored. When the data storage means stores three or more data sets, two of the data sets correspond to the first set and the second set described above.

In general, in a company or the like, a plurality of types of data corresponding to a plurality of viewpoints such as a viewpoint of data of each employee and a viewpoint of data of each business activity are stored in respective data tables and the like. In many cases, correspondences between types of data are also accumulated. In this case, long information composed of a plurality of types of data correlated with each other in accordance with the correspondence is often classified and aggregated from a desired viewpoint to extract desired information. In addition, the viewpoint in which long data is classified is often a viewpoint focusing on one type of data among a plurality of types of data.

According to the tabulation table creating apparatus having the above-described preferred configuration, the tabulation means determines that the long data consisting of the first data and the second data is independent of the data of the selected set. , And the classified long data is totaled, so that desired information can be easily obtained even when a plurality of types of data are accumulated.

[0014] A tally table creation program storage medium of the present invention that achieves the above object presents data items stored in a data storage means for storing a plurality of data each comprising a set of individual data corresponding to each of a plurality of items. Item presenting means, and an item selecting means for receiving an operation of selecting a desired plurality of items from the items presented by the item presenting means,
Tallying means for classifying the plurality of data stored in the data storage means into a plurality of dimensions corresponding to the plurality of items selected by the operation received by the item selecting means, and for counting the classified data; The program is characterized by storing a tabulation table creating program including a tabulation means for creating a tabulation table showing results.

In the tally table creation apparatus of the present invention and the tally table creation program, the same names as the item presenting means and the tallying means are given as the constituent elements constituting the same. In the case of a tally table creation device,
It refers to the combination of software and hardware that performs such an operation, and in the case of a tally table creation program, refers to only the software portion that performs such an operation.

[0016]

Embodiments of the present invention will be described below.

FIG. 1 is a diagram showing an embodiment of a tally table creating apparatus according to the present invention.

The tabulation table creating apparatus 100 is composed of a computer system, and includes a CPU, a RAM memory,
Main unit 101 and main unit 10 with built-in hard disk etc.
C for displaying a screen on the phosphor screen 102a in accordance with an instruction from
An RT display 102, a keyboard 103 for inputting user's instructions and character information into the computer system, and a mouse 104 for specifying an arbitrary position on the phosphor screen 102a and inputting an instruction corresponding to the position. I have.

The main body 101 further includes a floppy disk loading slot 101a into which the floppy disk 22 and the CDROM 20 are loaded, and a CDROM loading slot 1 in appearance.
01b, and a floppy disk driver and a CDROM driver for driving the loaded floppy disk 22 and CDROM 20 are also built therein.

In this case, the tally table creation program referred to in the present invention is stored in the CDROM 20.
M20 is loaded into the main body 11 through the CDROM loading slot 11b, and the CDRO driver 115
The tally table creation program stored in M20 is installed in the hard disk of this computer system. When the tally table creation program installed in the hard disk of this computer system is started, this computer system operates as one embodiment of the tally table creation device of the present invention.

Therefore, the CDROM 20 in which the tally table creation program is stored corresponds to one embodiment of the tally table creation program storage medium of the present invention.

The tally table creation program stored in the CDROM 20 is installed in the hard disk of the computer system as described above. The hard disk in which the tally table creation program is installed can be used in the present invention. Corresponds to one mode of the storage medium of the totaling table creation program.

Further, when the tally table creation program is downloaded to a floppy disk or the like, the floppy disk or the like in which the downloaded tally table creation program is stored is also stored in the tally table creation program storage medium of the present invention. This corresponds to one embodiment.

FIG. 2 is a hardware configuration diagram of the tabulation table creating apparatus (computer system) having the appearance shown in FIG.

Here, a central processing unit (CPU) 1
11, RAM 112, hard disk controller 11
3, a floppy disk driver 114, a CD ROM driver 115, a mouse controller 116, a keyboard controller 117, and a display controller 118, which are interconnected by a bus 110.

Floppy disk driver 114, CD
As described with reference to FIG. 1, the ROM driver 115 is loaded with the floppy disk 22 and the CDROM 20 and the loaded floppy disk 22 and the CDROM 2
0 is accessed.

Also, here, the hard disk 21 accessed by the hard disk controller 113,
Mouse 1 controlled by mouse controller 116
4. Keyboard 13 controlled by keyboard controller 117, and display controller 118
Also shown is a CRT display 12 controlled by.

As described above, the tally table creation program is stored in the CDROM 20, and the tally table creation program is read from the CDROM 20 by the CDROM driver 115, passed through the bus 110, and stored in the hard disk 21 by the hard disk controller 113. Is stored in In actual execution, the tally table creation program in the hard disk 21 is loaded on the RAM 112 and executed by the CPU 111.

The CRT display 12 displays a tabulation table creation screen and a statement input screen, which will be described later, and displays input information from the keyboard 13 and the mouse 14.

Here, the hard disk 21 is an example of the data storage means according to the present invention, and stores a ledger in which data according to the present invention is registered. Then, in the ledger, data, which will be described later, is accumulated daily by a registration system (not shown) for registering data in accordance with a user operation. Also, here, the hard disk 2
1 also stores a management file that is a list of items according to the present invention and the above-mentioned ledgers and the like.
It is created when the above-described registration system is constructed and stored in the hard disk 21. It should be noted that any number of ledgers may be stored in the hard disk 21, but for simplicity of description, a case where two ledgers are stored will be described here.

FIGS. 3 and 4 are views showing an example of the ledger described above. FIG. 3 shows an employee basic information ledger in which basic information of each employee is registered, and FIG. A qualification acquisition history ledger in which qualification acquisition histories by employees are registered is shown.

In the employee basic information ledger 30 shown in FIG. 3, employee data representing basic information of each employee is registered for each employee, and each employee data includes an employee number item 31 and a name item. 32, an age item 33, and a belonging department item 34. For example, employee number "0001"
, Name "Taro Yamada", age "30", and section "0"
"1" constitutes one employee data 36.

Each time an employee obtains a qualification, one qualification data is registered in the qualification acquisition history ledger 40 shown in FIG. 4, and each qualification data includes an employee number item 41 of the employee who obtained the qualification and a qualification data. Is obtained, and individual data 44 corresponding to each of the date item 42 and the qualification type item 43
It is composed of For example, employee number "0001"
Acquisition date "1997/10/1" and qualification type "01"
Forms one qualification data 45.

The employee data and the qualification data registered in the ledgers shown in FIGS. 3 and 4 are considered as the data according to the present invention or the first data and the second data according to the present invention. A set of employee data and qualification data mutually associated via a number is considered as long data according to the present invention.

The tabulation table creating apparatus according to the present embodiment converts employee data, qualification data, and long data consisting of mutually associated employee data and qualification data in accordance with a plurality of items selected by the user as described later. The data is classified into a plurality of dimensions using individual data corresponding to each of the plurality of items as an index, the classified data is totaled, and the totaled results are arranged vertically and horizontally to create a totaling table. As will be described later, the tallying table creation device can classify data up to six dimensions.

FIGS. 5 and 6 are views showing an example of the management file described above. FIG. 5 shows a ledger management file which is a list of ledgers. 4
An item management file which is a list of items shown in FIG.

In the ledger management file 50 shown in FIG. 5, a ledger number 51 and a ledger name 52 of each ledger are registered.

The item management file 60 shown in FIG. 6 has items 31, 32, 33, 34, and 4 shown in FIGS.
For each of 1, 42 and 43, the number 61 of the ledger containing the item and the number 62 specifying the item
, The name 63 of the item, the name 64 of the field in which the individual data corresponding to the item is registered, the attribute (numerical value, code, date, character, etc.) 65 of the individual data corresponding to the item, Number of digits of individual data corresponding to
And a key flag value 67 indicating whether or not the individual data corresponding to the item is key data for associating the employee data with the qualification data, and the individual data corresponding to the item are represented by a totaling method “total The value 68 of the total target flag indicating whether or not the individual data can be the target of “do”
And a classification flag value 69 indicating whether or not the individual data corresponding to the item is individual data that can be an index of data classification. Here, the value 68 of the sum target flag happens to be all “0”, but among the items of the individual data whose attributes are numerical values, the items of the individual data meaningful to calculate the total value are set as the sum target flag. Becomes “1”.

Next, the operation of the tabulation table creating apparatus according to the present embodiment based on these ledgers and management files will be described.

FIG. 7 is a flowchart showing the operation of the tabulation table creating device.

When the operation of the tabulation table creation device is started, first, in step S101, a tabulation table creation screen for creating a conceptual style of the tabulation table desired by the user is displayed. In addition, the tabulation method and the candidates for the tabulation target are displayed, and the candidates for the items corresponding to each of the vertical and horizontal axes of the tabulation table are also displayed.

FIG. 8 is a diagram showing a tabulation table creation screen.

The tabulation table creation screen 70 is provided with a table number column 71 for inputting a number for specifying the tabulation table, and a table name column 72 for arbitrarily inputting the name of the tabulation table.

The tabulation table creation screen 70 is provided with a tabulation method selection field 73, a total field selection field 74, and a tabulation target selection field 75. The tabulation method selection field 73 is defined in the present invention. It is an example of a method presenting means and a method selecting means. When the tabulation method selection column 73 is clicked, a menu of a tabulation method (also referred to as a tabulation method) is displayed.

FIG. 9 is a diagram showing a menu of the tallying method.

The tallying table creation device of this embodiment includes a tallying method for counting the number of data that satisfies a condition, and a summation of individual data values corresponding to a specific item among individual data constituting data that satisfies the condition. The menu 80 shown in FIG. 9 includes, based on the ledger management file 50 shown in FIG. 5, a tabulation method for counting the number of data from the viewpoint that the employee data is independent from each other. The character string "Number of employees" is displayed, and the character string "Number of qualifications" indicating the number of data is counted from the viewpoint that the above-mentioned qualification data are independent of each other. Is also displayed. Then, each of the displayed strings "number of employees",
When one of the character strings of “number of qualifications” and “total” is clicked, the totaling method is selected. However, when the tabulation method of counting the number of data is selected, not only the tabulation method but also a ledger that is treated as independent data at the time of data classification is eventually selected. That is, the tallying method selection column 73 shown in FIG.
It is also an example of the group presenting means and the group selecting means according to the present invention.

FIG. 9 shows a state in which the character string “number of qualifications” is clicked, and a counting method for counting the number of data in the qualification acquisition history ledger 40 is selected. From the menu 80 shown in FIG. The selected tallying method is displayed in the tallying method selection column 73 of the tallying table creation screen 70 shown in FIG.

When the total field selection field 74 of the tabulation table creation screen 70 is clicked, the style menu of the total field is displayed as shown in FIG.
"None", which is displayed in the same manner as the menu 80, and has no total column, "Vertical total", which has a total column indicating the vertical total of the total table, and a total indicating the horizontal total of the total table One style is selected from the four styles of “horizontal sum” in which a column is provided and “vertical and horizontal sum” in which a total column indicating the total in the vertical and horizontal directions of the tabulation table is provided. Then, the style of the selected total column is displayed in the total column selection column 74.

Tabulation target selection field 75 of tabulation table creation screen 70
Is clicked, the above-described tallying menu 80
Only when "Sum" is selected, the names 63 of items for which the value 68 of the sum target flag of the item management file 60 is "1" are displayed in a list. As mentioned above,
The individual data of the item in which the value 68 of the sum target flag is “1” is an individual data having an attribute of a numerical value and meaningful for obtaining the total value. Then, an item is selected by clicking the name in the list, and the selected item is displayed in the tallying target selection column 75. When the tallying method for counting the number of data is selected in the above-described tallying method menu 80, the ledger for which the number of data is to be counted has already been specified, and the tallying target selection column 75 is blank.

On the tabulation table creation screen 70, tabulation condition columns 76a, 76b, 76c, 78 into which individual data items used as indexes of data classification are selectively inputted.
a, 78b, 78c are provided, and each tabulation condition column includes a major classification on the vertical axis, a middle classification on the vertical axis, a minor classification on the vertical axis, a large classification on the horizontal axis, a middle classification on the horizontal axis of the summary table, And the minor classification on the horizontal axis. That is, here, the data classification can be selected up to a total of six dimensions by three dimensions in the vertical and horizontal directions. When each total condition column is clicked, the classification flag value 6 registered in the item management file 60 shown in FIG.
A list of names 63 of items whose 9 is “1” is displayed. Then, an item is selected by clicking the name in the list, and the selected item is displayed in the total condition column. FIG. 8 shows a state in which “qualification type” is selected as an item of individual data used as an index of the large classification on the vertical axis, and “department” is selected as an item of individual data used as an index of the large classification on the horizontal axis. It is shown.

Further, on the tabulation table creation screen 70, each tabulation condition column 76a, 76b, 76c, 78a, 78b,
Detail input buttons 77a, 77b, 77 corresponding to 78c
c, 79a, 79b, and 79c are provided, and when each detail input button is clicked, the data classification of the data using the individual data of the item selected in the aggregation condition column corresponding to the clicked detail input button as an index. A detail entry screen for entering detailed classification conditions is displayed.

FIG. 10 is a diagram showing a statement input screen.

The detail input screen 90 includes a condition column 91 in which classification conditions for classifying data into several sections using individual data as indices are input for each section, and a section for recognizing each section. Is provided, and when the condition column 91 is clicked, a list of possible values, codes, and the like of the individual data of the item corresponding to the item is displayed on the detailed entry screen 90. You. By specifying one or more values or the like in the list, a classification condition corresponding to one category is specified, and employee data or the like including individual data having a value or the like equal to the value or the like specified as the classification condition is specified. Are classified into one category. Here, as a method of specifying classification conditions, a method of specifying values or the like one by one, a method of specifying a range of values or the like, or a symbol indicating all unspecified values or the like among the values or the like displayed in a list is used. A designation method or the like can be used.

The condition column 91 of FIG. 10 shows a state in which the classification condition that the code of the individual data is "01" and the classification condition that the code of the individual data is "02" are specified. . Further, in the name column 92, the names of the sections corresponding to each classification condition, "first type information processing" and "second type information processing" are shown.

As described above, the summary table creation screen 7 shown in FIG.
0, and a menu such as a tallying method and a tallying object are presented to the user through the specification input screen 90 shown in FIG. 10, so that the user can obtain technical knowledge such as the internal functions of the tallying table creation device and the data format of the ledger. Even if you do not have it, as long as you have the knowledge to create the totals table by hand, you can create the totals table that extracts the desired information from the accumulated data while referring to the presented menu The device can be instructed.

As described above, when the tabulation target and the vertical / horizontal axis classification conditions are input on the tabulation table creation screen 70 shown in FIG. 8 or the detail entry screen 90 shown in FIG. (Step S102 in FIG. 7).

FIG. 11 shows a summary table creation screen 70 shown in FIG.
FIG. 6 is a diagram showing a tallying condition file in which items input in step (1) are stored.

The tabulation condition file 120 includes a number 121 entered in a table number column 71 shown in FIG. 8, a table name 122 entered in a table name column 72, and a tabulation method selection column 73.
The tabulation method 123 selected in and the tabulation target selected in the tabulation target selection field 75 are stored. However, here, the counting method for counting the number of data of the qualification acquisition history ledger 40 is selected as the counting method 123, and therefore, the counting target is blank as described above.

The totalization condition file 120 includes:
A numerical value 124 representing the style of the total column selected in the total column selection column 74 shown in FIG. 8 is stored, the value “0” indicates the style “none”, the value “1” indicates the style “vertical total”, The value “2” indicates the style “sum of width” and the value “3” indicates the style “sum of height and width”.

Further, this totaling condition file 120 includes:
Each of the aggregation condition columns 76a, 76b, 76c, 78 shown in FIG.
The items selected in a, 78b, and 78c are saved. However, in FIG. 8, the items are selected only in the aggregation condition column 76a corresponding to the large classification on the vertical axis of the aggregation table and the aggregation condition column 78a corresponding to the large classification on the horizontal axis of the aggregation table.
Also in FIG. 11, only items 125a and 125b corresponding to the large classification on the vertical axis and the large classification on the horizontal axis are shown.

Further, the tallying condition file 120 includes respective tallying condition columns 76a, 76b, 76c,
The number of sections 126a, 126b, 126c, 126d, 126 of each classification corresponding to 78a, 78b, 78c, respectively.
e and 126f are also stored.

Although FIG. 11 shows a state in which each input item corresponding to one tally table is stored, each input item corresponding to each of a plurality of tally tables may be stored. If entries for multiple tables are saved,
One total table is stored as one line.

FIG. 12 is a detailed input screen 90 shown in FIG.
FIG. 6 is a diagram showing a tallying condition file in which items input in step (1) are stored.

In the tallying condition file 130, items input on the detail input screen 90 are stored, and input items corresponding to one classification condition are stored as one line.

The totaling condition file 130 stores a totaling table number 131 corresponding to each classification condition. In addition, a value 132 indicating whether each classification condition is a large, medium, or small classification condition is stored. A value “1” indicates a large classification, a value “2” indicates a middle classification, and a value “3” indicates a small classification. In addition, the totaling condition file 130 also stores a value 133 indicating whether each classification condition is a vertical or horizontal axis classification condition of the totaling table. The value “1” is the vertical axis, and the value “2” is the horizontal axis. Is shown.

The totaling condition file 130 includes
A serial number 134 assigned to a series of classification conditions input on one statement input screen 90 is stored, and the condition 135 specified in the condition column 91 of the statement input screen 90 and the statement input screen 90
The name 136 entered in the name column 92 is also stored.

In step S102 of FIG. 7, when the tallying target and the like are stored in the tallying condition file, step S1
In step 03, the data registered in the ledger is counted according to the counting condition file and the management file as described later.

FIG. 13 is a flowchart showing the procedure of data totaling.

Here, the ledger management file shown in FIG.
The item management file shown in FIG. 6, the tallying condition file 120 shown in FIG. 11, and the tallying condition file 1 shown in FIG.
According to the procedure 30, long data consisting of a pair of employee data registered in the employee basic information ledger 30 shown in FIG. 3 and qualification data registered in the qualification acquisition history ledger 40 shown in FIG. Will be described.

When the tallying is started, first, the tallying method and the tallying object stored in the tallying condition file 120 shown in FIG. 11 are acquired, and the tallying method is “number of qualifications”. It is specified as a “count” target (step S201). Next, the aggregation condition file 12
From 0, it is confirmed that the major axis of the vertical axis is “qualification type”, the major axis of the horizontal axis is “department”, and there is no small / medium category (step S202). Next, a code “01” (first-type information processing) and a code “0”
2 (second type information processing) is obtained, and the code “0” is set as the classification condition of the horizontal axis large classification.
1 (first department) and code "02" (second department) are obtained (step S20).
3). That is, here, the data is classified into four groups of 2 × 2.

Thereafter, one employee data is obtained from the employee basic information ledger. Also, since the item whose key flag is “1” in the item management file is an item of the employee number, one piece of qualification data including an employee number equal to the employee number of the obtained employee data is also obtained from the qualification acquisition history ledger. . Thereby, substantially one long data is obtained (step S204). However, the long data is treated as if only all combinations of the qualification data and the employee data associated with each other by the key data "employee number" exist, and as shown in FIGS. 3 and 4, the "employee number" If there is one piece of employee data with "0001" and two pieces of qualification data with "Employee number" of "0001", there are two pieces of long data with "Employee number" of "0001". Treated as existing.

Next, the obtained long data is classified according to the individual data corresponding to the item “qualification type” and the item “department” among the individual data included in the long data (step S205). However, here, since the counting method is the “number of qualifications”, the qualification data is classified from the viewpoint of mutually independent data. In other words, the qualification data is different from each other for the two long data whose "employee number" is "0001" as described above, so that even if the long data is classified into the same group, they are individually classified. Is done. Conversely, when the employee data is classified from the viewpoint of being independent of each other, the employee data is the same for the two long data whose "employee number" is "0001" as described above. If the long data is classified into the same group, the overlap is ignored.

Next, the classified long data is stored in step S
Aggregation is performed according to the aggregation method acquired in 201 (step S206). Here, since the counting method is of the “count” type, the number of long data is accumulated. On the other hand, when the totaling method is the “total” type, the values of the individual data of the item to be totaled are totaled.

Thereafter, steps S204 to S2
06 is repeated by the number of long data, and the process returns to the flowchart shown in FIG.

When the data totaling in step S103 shown in FIG. 7 is completed, the totaling result is stored in the totaling result file (step S104). Then, the number 126 of sections stored in the tallying condition file 120 shown in FIG.
a, 126b, 126c, 126d, 126e, 126
The form of the summary sheet is determined according to f and the value 124 indicating the style of the total field, and the layout of the summary table is assembled (step S105). After that, the tabulation results of the tabulation result file are arranged according to the assembled layout, and a form of the tabulation table is created (step S10).
6).

FIG. 14 is a diagram showing a form of the created summary table.

At the upper left of the form 140, the number 12 stored in the total condition file 120 shown in FIG.
1, the same number 141 and name 142 as the name 122 are printed.

The number of sections 126a, 126b, 126c, 126 stored in the totaling condition file 120
In accordance with d, 126e, and 126f, two categories of the vertical axis and two categories of the horizontal axis are prepared.
Names 13a, 143b, 144a, and 144b stored in the tallying condition file 130 shown in FIG.
6 is printed.

Further, since the value 124 indicating the style of the total column stored in the total condition file 120 is “1”, a total column 145 in the vertical axis direction is provided, and each total stored in the total result file is provided. The value 146 is printed at the corresponding position in the tabulation table.

As described above, the tallying table creating apparatus according to the present embodiment operates according to the tallying targets and classification conditions that the user has selectively entered on the tallying table creating screen 70 shown in FIG. 8 or the detail input screen 90 shown in FIG. Create schedules automatically. For this reason, the user can easily acquire a tally table for extracting desired information that is potentially included in the data stored in the ledger.

In the above description, the case where data is stored in two ledgers has been described as an example. However, the tally table creation device of the present invention is stored in each of three or more ledgers, and Three or more types of data associated with each other may be totaled.

In the above embodiment, the data of the two ledgers are associated with each other by the key data indicated by the key flag of the management file. However, the first data and the second data stored in the storage means according to the present invention are different from each other. The correspondence between
The present invention is not limited to the data represented by such key data, and the correspondence between the first data and the second data may be represented in any format.

In the above embodiment, the "counting" type tallying method and the "summing" type tallying method are provided. However, the tallying method according to the present invention is not limited to these tallying methods. For example, a tallying method for calculating an average value may be used.

[0084]

As described above, according to the tabulation table creating apparatus of the present invention, the tabulation table representing the desired information as described above can be easily obtained. A tally table creation program stored in the tally table creation program storage medium of the present invention causes a computer system to operate as such a tally table creation device.

[Brief description of the drawings]

FIG. 1 is a diagram showing one embodiment of a tally table creation device of the present invention.

FIG. 2 is a hardware configuration diagram of a tabulation table creating device (computer system).

FIG. 3 is a diagram showing an employee basic information ledger.

FIG. 4 is a diagram showing a qualification acquisition history ledger.

FIG. 5 is a diagram showing a ledger management file.

FIG. 6 is a diagram showing an item management file.

FIG. 7 is a flowchart illustrating the operation of the tabulation table creating device.

FIG. 8 is a diagram showing a tabulation table creation screen.

FIG. 9 is a diagram showing a menu of an aggregation method.

FIG. 10 is a diagram showing a statement input screen.

FIG. 11 is a diagram showing a tallying condition file in which items input on a tallying table creation screen are stored.

FIG. 12 is a diagram showing a tallying condition file in which items input on a statement input screen are stored.

FIG. 13 is a flowchart illustrating a procedure of data aggregation.

FIG. 14 is a diagram showing a form of a created summary table.

[Explanation of symbols]

 Reference Signs List 20 CDROM (program storage medium) 22 Floppy disk (program storage medium) 30 Employee basic information ledger 40 Qualification acquisition history ledger 50 Ledger management file 60 Item management file 70 Summary table creation screen 90 Detail entry screen 100 Summary table creation device (computer system) ) 120, 130 Total condition file 140 Form (Tab)

Claims (4)

[Claims] 1. An item presenting means for presenting an item of data stored in a data storage means for storing a plurality of data each comprising a set of individual data corresponding to each of a plurality of items, and an item presented by the item presenting means Item selection means for receiving an operation of selecting a desired plurality of items from among a plurality of items, and a plurality of data stored in the data storage means, the plurality of data corresponding to the plurality of items selected by the operation received by the item selection means A tally table creation device, comprising: tally means for classifying data in a dimension and tallying the classified data; and tabulation means for creating a tally table indicating the tally result of the tally means. 2. The method according to claim 1, wherein the totaling unit includes a plurality of types of totaling methods for totalizing data, wherein the type presenting unit presents the plurality of types of totalizing methods provided in the totalizing unit; And a method selecting means for receiving an operation of selecting a desired tallying method from the tallying methods presented by the method, wherein the tallying means totals data in the tallying method selected by the operation received by the method selecting means. The tally table creation device according to claim 1, wherein the tally table is created. 3. The data storage means may include a first set of first data, each of which is a set of individual data corresponding to one or more items, and an item different from the items. A second set in which second data consisting of a set of individual data corresponding to each of the one or more items is collected, and each of the first data and the second set constituting the first set. Storing the correspondence relationship with each of the second data to be constituted, wherein the item presenting means presents both the first data item and the second data item, and wherein the item selecting means comprises: A set presenting means for accepting an operation of selecting a desired plurality of items from the items presented by the item presenting means, and presenting the first set and the second set as options for selecting a set. And before Set selecting means for receiving an operation of selecting one set from the first set and the second set presented by the set presenting means, wherein the counting means stores the correspondence stored in the data storage means. The set selecting means converts the long data consisting of the first data and the second data mutually associated according to the relationship into a plurality of dimensions corresponding to a plurality of items selected by the operation received by the item selecting means. 2. The tallying table creating device according to claim 1, wherein the tallying is performed in such a manner that the data of the set selected by the operation received by the group is independent of each other, and the classified long data is totaled. 4. An item presenting means for presenting an item of data stored in a data storage means for storing a plurality of sets of individual data corresponding to a plurality of items, respectively, and an item presented by the item presenting means. Item selection means for receiving an operation of selecting a desired plurality of items from among a plurality of items, and a plurality of data stored in the data storage means, the plurality of data corresponding to the plurality of items selected by the operation received by the item selection means It is characterized by storing a totaling table creation program comprising: a totaling means for classifying into dimensions and totalizing the classified data; and a tabulation means for generating a totaling table indicating the totaling result by the totalizing means. Total table creation program storage medium.