JP2008146378A - Data processor and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily prepare a transition table for checking time series transition. <P>SOLUTION: This data processor 1 having a function as a spread sheet tool P1 for performing chart output on the basis of table data accepts the input of information relating to items extracted from a record file 46 in which data are stored for every item and the extraction period of the data relating to those items by a transition table wizard dialog P2 for displaying a dialog picture at a display part, and for accepting an operation from an input part, and calculates a time series period divided within the extraction period on the basis of information relating to the extraction period input by a transition table wizard engine P3, and prepares data components by extracting and totaling data relating to the items input in each time series period from a record file 46, and generates table data for outputting the transition table by combining the data components. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

  The present invention relates to a data processing apparatus and a program.

  Conventionally, in office work using information equipment such as a PC (Personal Computer), a time series transition is performed on data specified by the user by performing a spreadsheet based on information stored in a database or the like. It is known to create a transition table for examination.

For example, Patent Document 1 discloses a technique relating to an accounting processing system for creating various tables for accounting work in which a period desired by a user is an accounting period and a period desired by the user within the accounting period is a tabulation target period. Is disclosed.
JP 2002-197248 A

  However, the above-described conventional technology is specialized in a specific data structure, and the system configuration and software are dedicated so as to perform only specific business processing (for example, accounting processing). For this reason, when using this dedicated system, when creating a transition table and examining time-series data fluctuations, the type and layout of the data to be output to the transition table are dedicated. Limited to those related to specific paperwork. In addition, when examining time-series transitions for arbitrary data, it is necessary to customize the dedicated system and software, which is time consuming and expensive, which is very complicated. It was.

  An object of the present invention is to facilitate creation of a transition table for examining time-series transitions.

The invention according to claim 1 is a data processing apparatus having a form output means for outputting a form based on table data.
Storage means for storing record data in which data is stored for each item;
An input means for receiving input of information relating to an item to be extracted from record data stored in the storage means and an extraction period of data relating to the item;
A period calculation means for calculating a time-series period divided within the extraction period based on the input information about the extraction period;
For each calculated time-series period, data component generation means for generating data parts for extracting and tabulating data related to the input items from record data stored in the storage means;
A transition table table data generation means for generating table data for outputting a time series transition of data related to the input item by combining data parts for each time series period generated by the data part generation means; ,
It is characterized by providing.

The invention according to claim 2 is the invention according to claim 1, wherein the storage means stores in advance template data related to a combination of data parts for each time-series period in the transition table table data generation means,
The transition table table data creation means combines data parts for each time series period based on the template data.

The invention according to claim 3 is the invention according to claim 1 or 2, wherein the input means accepts input of information including a unit period divided within the extraction period as information relating to the extraction of the data,
The period calculation means calculates the time series period based on the input unit period.

According to a fourth aspect of the present invention, in the invention according to any one of the first to third aspects, the input means inputs information including the end of the extraction period as information relating to the extraction of the data. Accept,
The period calculation means calculates the time series period so as to go back from the end of the input extraction period.

The invention according to claim 5 is a computer of a data processing apparatus having storage means for storing record data in which data is stored for each item, and form output means for outputting a form based on table data.
Input means for accepting input of an item to be extracted from record data stored in the storage means and information relating to an extraction period of data relating to the item;
A period calculating means for calculating a time-series period divided within the extraction period based on the input information regarding the extraction period;
Data component generating means for generating data parts for extracting and summing up data relating to the input items from record data stored in the storage means for each calculated time-series period;
A transition table table data generation unit that generates table data for outputting a time series transition of data related to the input item by combining data components for each time series period generated by the data component generation unit,
It is a program that functions as

  According to the present invention, when creating a transition table based on table data created by extracting data of any item from record data in which data is accumulated for each item, the item to be extracted and the item By inputting the data extraction period, the data items to be extracted and aggregated for each time-series section based on the input data are generated, and the data items are combined to input items. Since it is a configuration that generates table data for outputting time-series transition of such data, it is possible to generate table data for outputting a transition table simply by combining data parts. A transition table for examining time-series transition of data can be easily created.

  Hereinafter, embodiments will be described with reference to FIGS. This embodiment shows the most preferable form, and is not particularly limited to this form.

  First, the configuration of a data processing apparatus which is an information device such as a PC (Personal Computer) or WS (Work Station) will be described in detail with reference to FIG. 1A which is a block diagram schematically showing a functional configuration. To do. As shown in FIG. 1A, the data processing apparatus 1 includes a CPU 10, an input unit 20, a display unit 30, a storage unit 40, a printing unit 50, and a communication unit 60, and each unit is connected by a bus 70. The

  The CPU 10 (Central Processing Unit) has a built-in RAM (Random Access Memory), ROM (Read Only Memory), etc., not shown, and program data stored in the storage unit 40 or ROM is expanded into the RAM and sequentially executed. By doing so, it is a functional unit that comprehensively controls the processing operation of each unit of the data processing device 1 in cooperation with the program.

  The input unit 20 is a pointing device such as a mouse or a keyboard, and receives an operation instruction such as an operation of the pointing device or a key operation, and outputs an operation signal corresponding to the operation instruction to the CPU 10.

  The display unit 30 is a display such as an LCD (Liquid Crystal Display) or a CRT (Cathode-Ray Tube), and displays an image according to a display signal input from the CPU 10.

  The storage unit 40 is a magnetic or optical storage medium, a non-volatile memory such as a semiconductor (for example, an HDD (Hard Disk Drive), etc.), and has a configuration capable of reading and writing data based on an instruction from the CPU 10. . The storage unit 40 stores various application programs (to be described later), data files, or record data for storing data for each item.

  The printing unit 50 is a printer that forms an image on a recording medium such as paper by an image forming method such as a thermal transfer method, an electrophotographic method, and an ink jet method, and performs print output based on print data input from the CPU 10.

  The communication unit 60 has a communication circuit for performing data communication with other information devices (not shown) and a communication interface for connection with the other information devices, and a functional unit that performs data communication under the control of the CPU 10. It is. Specifically, the communication unit 60 performs network communication using the Internet or a LAN Local Area Network (USB), data communication such as USB (Universal Serial Bus), IEEE 1394 (Institute of Electrical and Electronic Engineers 1394).

  In this embodiment, the configuration of the data processing apparatus 1 alone is exemplified, but the data processing apparatus 1 is connected to another information device via the communication unit 60 and acquires record data from the other information device. The device configuration is not particularly limited to the present embodiment. Specifically, as shown in FIG. 1B illustrating the configuration of the data processing system, the data processing device 1 and the database 2 storing the record data are connected via a communication network N such as a LAN. The data processing system 100 may be used.

  Here, data stored in the storage unit 40 will be described with reference to FIG. FIG. 2A is a conceptual diagram schematically showing data stored in the storage unit 40. As shown in FIG. 2A, the data stored in the storage unit 40 is a spreadsheet program 41, a transition table wizard program 42, a transition table, which is a program data that is read and sequentially executed by the CPU 10 to perform various data processing. There are a table wizard engine program 43, a form automatic creation engine program 44, a template file 45 which is a data file referred to by the program data, a record file 46 for storing data for each item, and the like.

  The software configuration based on the data stored in the storage unit 40 is as shown in FIG. 2B schematically showing the configuration of the software executed by the data processing device 1. The spreadsheet tool P1 is a so-called spreadsheet function realized by the CPU 10 executing the spreadsheet program 41, and numerical values and computations input to cells (cells) arranged vertically and horizontally in a spreadsheet (table data). The rules are analyzed, and the calculation results are output in a table format from the display unit 30 or from the printing unit 50.

  The transition table wizard dialog P2 is a function realized by the CPU 10 executing the transition table wizard program 42 and performing processing described later. The transition table wizard dialog P2 reads the template file 45 including the table data related to the table template, and displays it on the display unit 30. An interactive input screen (wizard setting screen) is displayed, and input of data to be embedded in the table template is accepted from the input unit 20.

  The transition table wizard engine P3 is a function that is realized by the CPU 10 executing the transition table wizard engine program 43 and performing processing described later. The transition table wizard engine P3 stores the transition table wizard engine P3 in the template file 45 based on the data input in the transition table wizard dialog P2. Data is embedded in each cell of the table data that is a model of the included table, and table data to be used by the spreadsheet tool P1 is generated.

  By performing the processing in the transition table wizard dialog P2 and the transition table wizard engine P3 described above, the data processing apparatus 1 accepts any item in the record file 46 and the data extraction period from the input unit 20, Table data relating to the transition table for displaying the transition of data relating to the input item using the spreadsheet function of the spreadsheet tool P1 is generated.

  The form automatic creation engine P4 is a function realized by the CPU 10 executing the form automatic creation engine program 44 and performing processing described later. The data of the record file 46 is stored in each cell of the table data used by the spreadsheet tool P1. When creating a table such as a form by referring to the data, the data designated in each cell is retrieved from the record file 46 and substituted.

  As the record file 46, specifically, there is a sales record file or the like as shown in FIG. The record file 46 illustrated in FIG. 3A is table data for storing a sales record in each item (field), and is a so-called sales database file. Each item in the sales record file includes "slip number", "product name", "dealer", "person in charge", "unit price", "quantity", "slip date", etc. The item is set as a record key.

  When the data is stored in the record file 46 which is the sales record file described above, the data contents of the record file 46 are specifically shown in FIG. As shown in the figure, for example, in a sales record with “slip number” “00010”, “carrot”, “radish” and “potato” were sold on the date “2006/07/31” (stores) , Person in charge, unit price, quantity).

  Here, the table data used for the spreadsheet (table data handled by the spreadsheet tool P1 and the form automatic creation engine P4) will be described with reference to FIG. FIG. 4 is a conceptual diagram illustrating the data configuration of table data. As shown in FIG. 4, table data used for the table calculation includes characters and numerical values (for example, “slip number”), calculation rules (for example, “= COUNT (C13)” (counting of data regarding the cell C13), etc.), “Cells” (cells C11 to C23) into which reference rules of the record file 46 (for example, “= slip number. Sales record” (refer to the slip number in the sales record file)) and the like are input are arranged vertically and horizontally. A “row attribute” is set for setting the cell attribute for each cell.

  The cell attribute set as “row attribute” for each row in the table data is data that specifies the timing at which the form automatic creation engine P4 refers to the data in the record file 46. Examples of cell attributes include “title”, “group”, “detail”, and the like, as shown in FIG. Since the cell with “title” set as the attribute refers only to the top of the record, the top of the table is displayed as a result. A cell in which “group” is set is a cell that refers to data when the value of the grouping key item in the record changes. If the value is not set as in the present embodiment, the start of the record Browse and display the data. A cell in which “detail” is set is displayed with reference to data for each detail in the record. In addition, although the attribute of a cell may be set collectively for every row as mentioned above, you may set individually for every cell.

  Further, with respect to the part (cells C13 and C23) relating to the reference rule of the record file 46, by executing the form automatic creation engine P4, data (for example, “00010” or “0”) obtained from the record file 46 as shown in FIG. “Carrot” or the like is assigned to the cells (cells C13 to C15, cells C23 to C25).

  Next, the transition table wizard dialog P2 and transition table wizard engine P3 executed by the CPU 10 will be described with reference to FIG. FIG. 5 is a flowchart illustrating an operation related to layout table layout generation in the data processing apparatus 1.

  As shown in FIG. 5, when processing related to transition table layout creation is started, selection of a target file such as a template file 45 to be used as a transition table template or a record file 46 to be referenced is completed. Is performed based on the input instruction of the input unit 20 until the instruction is given (steps S11 and S12).

  Next, after the addition selection of the target file is finished, the transition table is started in order to activate an input screen (wizard setting screen) for accepting data to be embedded in the template of the transition table in the template file 45 that is the selected target file. The wizard activation process is started (step S13).

  Here, the transition table wizard activation process will be described with reference to FIG. 6 which is a flowchart illustrating the transition table wizard activation process.

  As shown in FIG. 6, when the transition table wizard activation process is started, a template item 45 that is a template of the selected transition table is used to classify and display data transitions for each item in the transition table. Reading of template (step S131), reading of template relating to data parts to be extracted and summed up from record file 46 within the set period (step S132), title area template for displaying title of transition table, etc. Reading is performed (step S133), and the data relating to the read template is expanded as a transition table template in the RAM of the CPU 10 or the like, and a work area relating to the layout generation of the transition table is generated (step S134).

  Here, a transition table template generated as a work area in the RAM of the CPU 10 will be described with reference to FIGS. FIG. 7 is a conceptual diagram illustrating the transition table template T, FIG. 8 (a) is a conceptual diagram illustrating the classification item region R2, and FIG. 8 (b) is a conceptual diagram illustrating the data part Dn. .

  As shown in FIG. 7, the transition table template T generated as a work area in step S134 is an area that combines a form title area R1, a classification item area R2, and a plurality of data parts D1,. And a transition table region R5 having a transition table data display region R4 for displaying the result of data aggregation in that period.

  As shown in FIG. 8A, the classification item region R2 is data related to items extracted from the record file 46, and is embedded with “classification items”, “date items”, “ Data item "and the like.

  As shown in FIG. 8B, the data part Dn includes “start date” and “end date” indicating the total period in the header area R3, and data within the total period from the record file 46 in the transition table data display area R4. (For example, “= IF (AND (end date> = date item, start date <= date item), data item, 0”, etc.)) and a calculation expression (for example, “ In other words, the data part Dn is a part that aggregates and displays the data of the record file 46 during the period from the “start date” to the “end date”. The region R5 is configured to display data aggregated for each time series period as a transition table by combining a plurality of data parts Dn.

Returning to FIG. 6, the continuation of the transition table wizard activation process will be described.
Following step S134, a list of items (“category item”, “date item”, “data item” in the above example) embedded in the transition table layout generated as the work area based on the input from the input unit 20 is read. In step S135, a transition table wizard dialog for accepting data input relating to a period for extracting data from the record file 46 to create the item and transition table is displayed on the display unit 30 (step S136). The wizard activation process ends.

  Here, FIG. 9A illustrates the dialog screen G displayed on the display unit 30 in step S136. As shown in FIG. 9A, the dialog screen G accepts an input of the “category item” classification item input area In1 and “date item” based on the item list read in step S135. Date item input area In2, data item input area In3 that accepts input of "data item", end date input area In4 that accepts "end date", "period unit", "number of periods", etc. as data related to the period, period unit input area In5 and the period number input area In6 are displayed.

  As shown in FIG. 5, following the transition table wizard activation process (step S13), the above-described “category item”, “date item”, “data item”, “end date”, “period unit” from the transition table wizard dialog ”,“ Number of periods ”and the like are accepted (steps S14 to S19), and it is determined whether or not the input contents are all OK by pressing the“ OK ”button for confirming the input contents (step S20). If it is OK, the transition table wizard engine process is performed with the input contents (step S21), and the process ends.

  The data input in steps S14 to S19 is, for example, as shown in FIG. In “category item”, “item name.sales record” in which the item of the sales record file extracts the product name is input to the category item input area In1. In “date item”, “slip date.sales record” for extracting item data of the slip date from the sales record is input to the date item input area In2. In “data item”, item data such as unit price and quantity is extracted from the sales record file, and “unit price.sales record * quantity.sales record” for calculating the sales is input to the data item input area In3. In “End Date”, “2006/09/30”, which is the final date of extraction, is input to the end date input area In4. In “period unit”, “month”, which is a period for which one data component is tabulated, is input to the period unit input area In5. In “Number of periods”, the number of periods to be tabulated in the period unit, that is, “3” which is the number of data parts to be generated is input to the period number input area In6.

  In steps S14 to S19, the data types input in the classification item input area In1, the date item input area In2, the data item input area In3, the end date input area In4, the period unit input area In5, and the period number input area In6. There are a character type, a numerical type, a selection type, and the like, which are set in advance for each item of the template file 45. For example, as clearly shown in FIG. 9 (b) showing an outline of data set in the transition table wizard, “character type” or “(positive) numerical value”, “1 .. year, 2 .. half year, 3. Some of them select a preset one such as “quarter, 4. month, 5. lap, 6. day”.

  Here, the transition table wizard engine process will be described with reference to FIG. When the transition table wizard engine process is started in step S21, as shown in FIG. 10, the setting data input in the transition table wizard dialog is read (step S211), and the operation is performed in step S134 based on the setting data. A classification item area data generation process for generating data related to item display by replacing the data of the classification item area R2 of the transition table template T generated as an area is performed (step S212).

  This classification item area data generation processing is as illustrated in the flowchart of FIG. That is, when the classification item area data generation process is started, a template related to the classification item area R2 generated in the work area of the RAM is acquired (step S2121), as shown in FIG. The “classification item” in R2 is replaced with the contents input in the classification item input area In1 (step S2122). Similarly, the “date item” is the content input in the date item input area In2, and the “data item” is the data item. The contents are replaced with the contents input in the input area In3 (steps S2123 and S2124), and the process ends.

  Subsequent to the classification item area data generation process (step S212), the date calculation process (step S213) and the data component generation / merge process (step S214) from the end date set in the end date input area In4 to the period number input area In6 It is performed until it is determined that the number of periods set in step S1 has ended (step S215: YES). That is, in steps S213 to S215, a loop process is performed for the number of periods set in the period number input area In6.

  The date calculation process is as illustrated in the flowchart of FIG. Specifically, when the date calculation process is started, as shown in FIG. 11B, the end date input area In4 and the “end date” of the period set in the previous date calculation process are acquired (step S2131), the acquired “end date” is converted into a date sequence number (specifically, a date value that can be calculated by the spreadsheet tool P1) and set as the “end date” (step S2132). A “start date” is set by subtracting the date for the period set in the period unit input area In5 from the “date” (step S2133), and a value obtained by subtracting one day from the “start date” is performed next time. Is stored as the “end date” (step S2134).

  That is, in the date calculation process in the loop process of steps S213 to S215, as is clear from FIG. 13A illustrating the generation of the date condition, from the “end date” set in the end date input area In4, the period unit The “start date” and “end date” are calculated so as to go back by the number of periods set in the period number input area In6 in the period unit set in the input area In5.

  The data component generation / merging process is as illustrated in the flowchart of FIG. Specifically, when the data component generation / merging process is started, as shown in FIG. 12, a template related to the data component Dn generated in the work area of the RAM is acquired, and the transition table generated as the work area is obtained. In the region R5, the acquired data part Dn is copied to the cell position based on the period currently being processed (step S2141).

  The cell position where the data part Dn is copied in the transition table area R5 is a cell position where the row attribute of the data part Dn and the row attribute of the transition table area R5 match, and the date is traced back as shown in the present embodiment. In the case of processing in this way, the position is to be inserted into the first column of the transition table region R5. Note that the data part already copied to the transition table region R5 is shifted in cell position and cell content (information when referring to other cells) based on the insertion of the data part Dn.

  Next, the “start date” and “end date” set in the date calculation process are set in the “start date” and “end date” of the copied data part Dn (step S2142), and each of the data parts Dn in the data part Dn is set. Information for referring to another cell in the cell is set based on the copied cell position in the transition table region R5 (step S2143).

  In the set of information at the time of reference in each cell in the data part Dn, for example, “date item”, “data item”, etc. that refer to the cell in the classification item region R2 illustrated in FIG. Replaced by “$ B $ 4”, “$ C $ 4”, etc. that specifically indicate the corresponding cell position of the classification item region R2 as shown in FIG. Is done.

  In addition, the row attribute illustrated in FIG. 8B refers to other cells in the data part Dn, such as “detailed coordinates” in the group and row attributes “start date” and “end date” in the detail. The part is replaced with “D4”, “D1”, “D1”, and the like referring to the data part Dn as shown in FIG. At the time of this replacement, “$” or the like is added to a portion (for example, a portion that refers to a cell in the classification item region R2) where the cell coordinates to be referred to are not shifted by the shift based on the insertion of the data component Dn described above To distinguish.

  That is, in the data processing device 1, by performing the above-described classification item region data generation processing, as shown in FIG. 14A illustrating the generated classification item region R2, the content of the template related to the classification item region R2 is changed. Replaced based on the setting data entered in the Transition Table Wizard dialog.

  Next, by performing date calculation processing and data component generation / merging processing based on the information related to the period set in the end date input area In4, the period unit input area In5, and the period number input area In6 of the transition table wizard dialog, As shown in FIG. 14B exemplifying a combination of the classification item region R2 and the data component D1, a data component D1 that aggregates data for each time series is generated and merged in a work area related to layout table layout generation. .

  Further, this date calculation processing and data component generation / merging processing are performed in a loop for the number of periods set in the period number input area In6, and the generated data parts are inserted into the work area for generating the layout of the transition table. As shown in FIG. 14C illustrating how data parts are sequentially combined, table data for generating time-series transitions by combining data parts in time-series order is generated.

  Next, in the generated table data, a process for searching the record file 46 for the extracted data from the record file 46 for the part from which the data part extracts data from the record file 46 (step S216), that is, the form automatic creation engine P4 described later. Processing is completed.

  Here, processing related to the automatic form creation engine P4 executed by the CPU 10 will be described with reference to FIG. FIG. 15 is a flowchart illustrating an operation related to the form automatic creation engine process in the data processing apparatus 1.

  As shown in FIG. 15, when the form automatic creation engine process is started, the row attribute of the table data is read (step S31), and the rank of the row to be processed is set based on the read row attribute. (Step S32). The processing order of the rows based on the row attributes is set so that processing is performed preferentially from the row including the reference source cell referenced from other cells. For example, “detail” that refers to the data in the record file 46 for each detail, “group” that is referred to by other cells such as “detail” when the value of the grouping key item in the record changes, or simply the beginning of the record Are set in the order of “title” in which only characters are displayed.

  Next, based on the set processing rank, the first rank row is set as the processing target row (step S33), and it is determined in step S39 that there is no next ranking processing target row. Steps S34 to S38 are performed in the order of rank until it is determined that the processing of the current row has been completed.

  In the processing for the rows in this order, it is determined whether or not the processing target row refers to the record file 46 (step S34). If it is determined to refer to the record file 46 (YES), the referenced record file is set (step S34). In step S35, all the records are sequentially read from the set record file and processed in units of cells (steps S36 to S38), and the process proceeds to the process target row of the next rank according to the determination in step S39. If it is determined in step S34 that the reference is not made (NO), the process directly proceeds to the determination in step S39.

  Here, the processing in units of cells will be described with reference to FIG. 16 illustrating the flowchart. When processing in units of cells is started, as shown in FIG. 16, the first cell in the processing target row is set as the processing target cell (step S371), and it is determined in step S378 that there is no next cell information. That is, the processes in steps S372 to S377 are sequentially performed on the cells up to the last cell in the target row.

  In the process for this cell, the data in the target cell is read and the cell coordinates (vertical and horizontal cell positions) of the target cell are acquired (steps S372 and S373), and the record file is referred to the read data. It is determined whether or not data relating to the item name of the record file is included (step S374).

  If it is determined in step S374 that data for referring to the record file is included (YES), the item read from the target cell in the current record that is the target in the processing in steps S36 to S37. Data relating to the name is acquired (step S375), and the item name portion in the data of the target cell is replaced with the acquired data (step S376). That is, the part that refers to the record file in the target cell is replaced with the data extracted from the record file.

  If it is determined in step S374 that data for referring to the record file is not included (NO), the data read from the target cell is set as it is in the target cell (step S377).

  As described above, the generated table data is processed by the form automatic creation engine P4, and the part that refers to the record file in the generated table data is obtained by searching the record file by the item name or the like. The assigned data is substituted.

  Specifically, as shown in FIG. 17 illustrating the table data created by the process up to the form automatic creation engine P4, the item of the product name is referred to by extracting data from the corresponding item in the sales record file. The product name such as “=“ carrot ”” is assigned to the part to be replaced, the date serial number such as “=” 20060731 ”is assigned to the part that refers to the date item, and the part that refers to the unit price * quantity is referred to. Numerical data such as “= 98 * 150” is substituted.

  The data processing apparatus 1 performs calculation of each cell by the spreadsheet tool P1 based on the table data generated by the form automatic creation engine P4, thereby enabling screen display by the display unit 30 and print output by the printing unit 50. A transition table can be output.

  Specifically, when outputting the transition table by the spreadsheet tool P1 based on the table data of the transition table as shown in FIG. 17, it is based on the table data created by the processing up to the form automatic creation engine P4. A transition table as illustrated in FIG. 18 illustrating the displayed transition table is output. That is, for the row having the row attribute “title” or “group”, the result calculated based on the data included in “detail” or the like is output to the transition table region R5.

  As described above, the data processing apparatus 1 having a function as the spreadsheet tool P1 that outputs a table (form etc.) based on the table data stores the record file 46 in which data is stored for each item. And an input unit 20 that receives input of information relating to an extraction period of data related to the item extracted from the record file 46 stored in the storage unit 40, and the input by the processing executed by the CPU 10 Based on the information about the extraction period, a time series period divided within the extraction period is calculated, and for each calculated time series section, an item input from the record file 46 stored in the storage unit 40 Generate data parts Dn to extract and aggregate data, and output the transition of time series by combining the generated data parts Dn It is configured to generate table data for.

    Therefore, when the data processing device 1 creates the transition table based on the table data created by extracting the data of any item from the record data in which the data is accumulated for each item, the data processing device 1 Table data for outputting a transition table can be generated simply by combining data components that are extracted and aggregated into a data table, and a transition table for examining the time-series transition of data related to any item Can be easily created.

  In the data processing apparatus 1, a template file 45 that is data related to the layout of the transition table is stored in the storage unit 40 in advance, and in the transition table region R 5 of the transition table template T based on the data included in the template file 45. In this configuration, data parts Dn are combined to generate table data for outputting a transition table.

  For this reason, the data processing apparatus 1 can adjust the layout of the transition table output in the template file 45. For example, by adjusting the position of the transition table region R5 in the template file 45, the time-series data is displayed. The area can be adjusted.

  Further, the data processing device 1 receives an input of a unit period divided within the extraction period by an input to the period unit input area In5 from the input unit 20, and performs a date calculation process based on the input unit period. It is a configuration. For this reason, the data processing apparatus 1 can set the time series section of the data component as a unit period set by the user, and can output transition table data aggregated for each period desired by the user.

  Further, the data processing apparatus 1 accepts an input at the end of the extraction period by an input to the end date input area In4 from the input unit 20, and performs date calculation processing so as to go back based on the input end time. It is a configuration. For this reason, the data processing apparatus 1 can output the transition table data totaled for every previous period from the time when a user desires totalization.

  Note that the description in the present embodiment shows an example of the data processing apparatus 1 and is not limited to this. The configuration and operation in this embodiment can be changed as appropriate.

(A) is a block diagram schematically showing a functional configuration of the data processing apparatus 1, and (b) is a block diagram schematically showing a configuration of the data processing system 100. (A) is a conceptual diagram schematically showing data stored in the storage unit 40, and (b) is a conceptual diagram schematically showing a configuration of software executed by the data processing device 1. (A) is a conceptual diagram schematically showing the configuration of the record file 46, and (b) is a conceptual diagram specifically illustrating the data contents of the record file 46. It is a conceptual diagram which illustrates the data structure of table data. 5 is a flowchart illustrating an operation related to layout table layout generation in the data processing apparatus 1; It is a flowchart which illustrates a transition table wizard starting process. 4 is a conceptual diagram illustrating a transition table template T. FIG. (A) is a conceptual diagram which illustrates classification item field R2, and (b) is a conceptual diagram which illustrates data part Dn. (A) is a conceptual diagram which illustrates the dialog screen G in a transition table wizard, (b) is a conceptual diagram which illustrates the outline | summary of the data set by a transition table wizard. It is a flowchart which illustrates a transition table wizard engine process. (A) is a flowchart illustrating classification item region data generation processing, and (b) is a flowchart illustrating date period calculation processing. It is a flowchart which illustrates a data components production | generation / merge process. (A) is a conceptual diagram illustrating generation of date conditions, and (b) is a conceptual diagram illustrating generated data parts. (A) is a conceptual diagram illustrating the generated classification item region R2, (b) is a conceptual diagram illustrating a combination of the classification item region R2 and the data component D1, and (c) is a data component. It is a conceptual diagram which illustrates a mode that these are combined sequentially. 4 is a flowchart illustrating an operation related to a form automatic creation engine process in the data processing apparatus 1; It is a flowchart which illustrates the process of a cell unit. It is a conceptual diagram which illustrates the table data produced by the process to form automatic creation engine P4. It is a conceptual diagram which illustrates the transition table displayed by the spreadsheet tool P1 based on the table data created by the process up to the form automatic creation engine P4.

Explanation of symbols

1 Data processing device 2 Database N Communication network 10 CPU
20 Input unit 30 Display unit 40 Storage unit 41 Spreadsheet program 42 Transition table wizard program 43 Transition table wizard engine program 44 Automatic report creation engine program 45 Template file 46 Record file 50 Printing unit 60 Communication unit 70 Bus 100 Data processing system C11- C25 cells D1 to Dn Data part G Dialog screen In1 Classification item input area In2 Date item input area In3 Data item input area In4 End date input area In5 Period unit input area In6 Period number input area P1 Spreadsheet wizard P2 Transition table wizard dialog P3 Transition table wizard engine P4 Automatic document creation engine T Transition table template R1 Form title area R2 Classification item area R3 Heading area R4 Transition table data display area R5 Transition table area

Claims (5)

In a data processing apparatus having a form output means for outputting a form based on table data,
Storage means for storing record data in which data is stored for each item;
An input means for receiving input of information relating to an item to be extracted from record data stored in the storage means and an extraction period of data relating to the item;
A period calculation means for calculating a time-series period divided within the extraction period based on the input information about the extraction period;
For each of the calculated time series periods, data component generation means for generating data parts for extracting and summing up data relating to the input items from record data stored in the storage means;
A transition table table data generation means for generating table data for outputting a time series transition of data related to the input item by combining data parts for each time series period generated by the data part generation means; ,
A data processing apparatus comprising: The storage means stores in advance template data relating to a combination of data parts for each time-series period in the transition table table data generation means,
The data processing apparatus according to claim 1, wherein the transition table table data creation unit combines data parts for each time-series period based on the template data. The input means accepts input of information including a unit period divided within the extraction period as information on the extraction of the data,
The data processing apparatus according to claim 1, wherein the period calculation unit calculates the time series period based on the input unit period. The input means accepts input of information including the end of the extraction period as information on extraction of the data,
The data processing apparatus according to claim 1, wherein the period calculation unit calculates the time-series period so as to go back from the end of the input extraction period. A storage means for storing record data in which data is stored for each item, a computer of a data processing apparatus having a form output means for outputting a form based on table data,
Input means for accepting input of an item to be extracted from record data stored in the storage means and information relating to an extraction period of data relating to the item;
A period calculating means for calculating a time-series period divided within the extraction period based on the input information regarding the extraction period;
Data component generating means for generating data parts for extracting and summing up data relating to the input items from record data stored in the storage means for each calculated time-series period;
A transition table table data generation unit that generates table data for outputting a time series transition of data related to the input item by combining data components for each time series period generated by the data component generation unit,
Program to function as.

Images