JPH05242268A - Automatic tabulating system for time-point data - Google Patents

Abstract

PURPOSE:To tabulate data expressed with time-point at every period. CONSTITUTION:When sales data 11a, 11b are written on a table data storing file 13, the data representing the time is converted to format according to a constant rule, that is, a time value by a time-point data conversion processing part 12. A tabulation processing part 16 receives table data line by line from a table data input part 14, and performs an arithmetic operation according to a method and the period designated by a tabulating method decision part 15. A tabulation result is written on the table data storing table 13, line by line, at a table data output part 17. When the sales data 11a, 11b are generated, the time-point value can be changed to arbitrary description by the time-point data conversion processing part 12.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic totaling system for time data, and more particularly to an automatic totaling system for performing a calculation process for each cycle of tabular data by using data representing time displayed in a matrix as a key.

[0002]

2. Description of the Related Art Conventionally, in the case of totaling for each cycle, a separate program is created depending on the combination of the expression format and unit (year, month, day, etc.) of data representing time and the cycle to be summarized. Was.

[0003]

In the conventional point-in-time data automatic totaling system, processing programs are required for the number of combinations of the types of data representing the time in the table data and the cycle to be summarized. In the case of table data having sales data of, there are cycles such as January, quarter, half year, and year, and programs were created for each.

Further, the data representing time in the table data includes
Since there are types such as seasonal, monthly, quarterly, and semi-annual, the number of programs will be extremely large.

[0005]

According to the automatic time point data totalizing system of the present invention, an arbitrary expression format representing time is represented by a unified format time point value consisting of a period type identification code indicating a unit of time and a numerical sequence. A first converting means for converting to, a data storing means for registering data using the time point value as a key, an upper limit value and a lower limit value of the period type identification code and the numeral string, and searching the data storing means. And a totalizing means for totaling and secondly converting the point-in-time value into an arbitrary expression format representing the time
And the conversion means of.

[0006]

The present invention will be described below with reference to the drawings.

Referring to FIG. 1, one embodiment of the present invention is
Monthly sales data 11a in the Japanese calendar format, monthly sales data 11b in the Western calendar format, and time point data conversion processing units 12a and 12
b, the table data storage file 13, and the table data input unit 1
4, a tabulation method determination unit 15, a tabulation processing unit 16, and a table data output unit 17.

The point-in-time data conversion processing unit 12a converts the display format representing time such as the Japanese calendar, the Western calendar, "year" and "month" into one predetermined expression format. The expression format "January" is converted to the expression format "M199001". In this case, the expression "M" represents the month.

Similarly, "day" is replaced by "Dyyyymmd"
d ”(yyyy: AD, 01 ≦ mm ≦ 12, 01 ≦ dd
≤31), (Note) Consider big month, small month, and leap year.

"Season" is changed to "Jyyyymmj" (early (j
= 1), middle (j = 2), late (j = 3)), "quarter" to "Qyyyyq" (first quarter (q = 1), second
Quarter (q = 2), third quarter (q = 3), fourth quarter (q = 4)), "half year" to "Hyyyyh" (first half (h
= 1), second half (h = 2)), and "year" are represented as "Yyyyy".

Here, "Y", "H", "Q",
“M”, “J”, and “D” are identification codes that represent the unit of time and are called “period type”, and the expression form consisting of this period type and a number string is called “time point value”.

The table data input unit 14 reads data for one line from the table data storage file 13, that is, sales data corresponding to one time point value.

The tally method determining unit 15 decides which period type data is to be collected in what period, or
Decide what kind of calculation such as total value, average value, maximum value and minimum value.

The tabulation processing unit 16 performs the processing described below on the data read by the table data input unit 14, and outputs the data for one line created as a result to the table data output unit 17.

The point-in-time data conversion processing unit 12b performs the reverse conversion of the above-mentioned point-in-time data conversion processing unit 12a, that is, the point-in-time value is converted into an arbitrary expression format to create a form or the like.

Further, in the time point data conversion processing unit 12b,
It is also possible to convert the time value into an arbitrary display format and create a form or the like.

Next, the operation of the totalization processing unit 16 of this embodiment will be described with reference to FIG.

The time value validity checking unit 21 checks whether or not the time value in the data read by the table data input unit 14 matches the period type specified by the counting method determination unit 15, and if they match. For this purpose, the time value period check unit 22 checks the time value period. For example, when "Calculate the total value of one year cycle from 1990" is specified in the aggregation method determination unit 15, the lower limit value is "January 1990" and the upper month value is "December 1990". In addition, "January 1990" to "December 1990" are the targets of aggregation.

When the above-mentioned summation target is applied, the arithmetic unit 23 performs addition processing (total value
Perform the average value) and the replacement process (maximum value / minimum value).

When the upper limit is exceeded, the calculation result editing unit 24
At, the data stored in the arithmetic unit 23 is taken out, and the time value of the corresponding cycle is edited to create one row of total result data, and the tabular data output unit 17 directs the tabular data storage files 11a and 11b. Write to.

Then, the contents of the arithmetic unit 23 are all replaced with the data currently read, the contents of the period check unit 22 are added with a period, and the lower limit value is "January 1991" and the upper limit value is "Heisei 3 December of the year ".

The above flow is repeated until the data disappears, and when the data disappears, the data remaining in the arithmetic unit 23 is edited by the final result editing unit 25, and the table data output unit 1
The data is written in 7, and the process is completed.

[0023]

As described above, according to the present invention, no matter what kind of time the user uses the data, and in what cycle the data is collected, the processing is performed by one method. Therefore, it is possible to perform the aggregation very efficiently.

[Brief description of drawings]

FIG. 1 is a block diagram of an embodiment of the present invention.

FIG. 2 is an operation diagram of a totalization processing unit 16 in FIG.

[Explanation of symbols]

 11a Monthly sales data in Japanese calendar format 11b Monthly sales data in Western calendar format 12a, 12b Time data conversion processing unit 13 Table data storage file 14 Table data input unit 15 Aggregation method determination unit 16 Aggregation processing unit 17 Table data output unit 21 Time value Validity check section 22 Time value period check section 23 Calculation section 24 Calculation result editing section 25 Final result editing section

Claims (1)

[Claims] 1. A first conversion means for converting an arbitrary expression format representing time into a time value in a unified format consisting of a period type identification code indicating a unit of time and a numerical sequence, and the time value. Data storage means for registering data as a key, totalizing means for searching and totalizing the data storage means by designating the period type identification code and the upper limit value and the lower limit value of the numeric string, and the time point value for the time An automatic time point data totaling system, comprising: a second conversion means for converting to an arbitrary expression format.