JP3846306B2 - Table processing apparatus and program - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a table processing apparatus that performs spreadsheet processing and a program related to the processing.
[0002]
[Prior art]
The spreadsheet software is executed by a computer or the like, and a character, a numerical value, and an expression for one cell with a partition (hereinafter referred to as “cell”) generated by the intersection of the row and column of the table as a basic unit. One piece of data representing etc. is registered, a given operation is performed based on the data registered in the cell, and the result is displayed in the cell.
[0003]
A normal table has data respectively in the vertical and horizontal directions of the table. However, in order to enhance the data processing function of the spreadsheet software, as shown in Japanese Patent Laid-Open No. 2001-101328, each of the table rows, columns, and depths is provided. By giving parameters to, a table representing data having three or more parameters can be created.
[0004]
In recent years, such data processing by spreadsheet software has been used as part of learning to solve textbook problems such as mathematics.
[0005]
[Problems to be solved by the invention]
However, for example, if you want to input multiple data into a single cell in a textbook problem using a matrix, etc. or data input of repeated tests, it is necessary to define a special input method in conventional spreadsheet software. It was. In addition, when a special input method for a cell cannot be defined, since one data is repeatedly input to one cell as before, the user's labor has increased. However, the tables created in this way are difficult to understand and may not be suitable for learning, which hinders the use of spreadsheet software.
[0006]
An object of the present invention is to provide a table processing apparatus that registers one or a plurality of data in cells constituting a table and performs a given process based on the registered data.
[0007]
[Means for Solving the Problems]
  In order to solve the above-described problems, the invention according to claim 1 is a table processing apparatus in which a plurality of cells are arranged vertically and horizontally to register data in each cell constituting a table and perform a given operation based on the registered data. For each cellRegistration to register multiple numeric data or single numeric datameans(For example, steps A3 to A5 in FIG. 7) and among the cells of the table in which the numerical data is registered by the registration means, the cell corresponding to the plurality of numerical data corresponds to the cell in which the plurality of numerical data is registered. An arithmetic processing means (for example, C9 and C10 in FIG. 12) for executing a given operation on the table data in which the cell is inserted, the numerical data is distributed to the inserted cell, and rearranged;It is characterized by providing.
[0008]
  According to a thirteenth aspect of the invention, there is provided a program for registering each cell in a table processing apparatus for registering data in each cell constituting a table arranged in a row and column and performing a given operation based on the registered data. AgainstRegistration to register multiple numeric data or single numeric datameans(For example, steps A3 to A5 in FIG. 7) and among the cells of the table in which the numerical data is registered by the registration means, the cell corresponding to the plurality of numerical data corresponds to the cell in which the plurality of numerical data is registered. An arithmetic processing means (for example, C9 and C10 in FIG. 12) for executing a given operation on the table data in which the cell is inserted, the numerical data is distributed to the inserted cell, and rearranged;Is made to function.
[0009]
  According to the inventions of claims 1 and 13, for one cell,Register multiple numeric data or single numeric dataCanOf the cells in the registered table, for cells in which multiple numeric data are registered, insert the cells corresponding to the multiple numeric data, and distribute the multiple numeric data to the inserted cells for relocation. A given operation can be performed on the tabulated data. Therefore, the number of numerical data registered in each cell of the table can be arbitrarily changed, and an operation can be performed on an easy-to-understand table corresponding to the learning content.
[0010]
  Further, as in the invention according to claim 2, the table processing apparatus according to claim 1Among the cells of the table in which data is registered by the registration means, the size of the cell is enlarged for a cell in which a plurality of numerical data is registered.indicateCell expansionDisplay means(For example, step A6 in FIG. 7)May be further provided.
[0011]
  According to the invention of claim 2,A cell that contains multiple numeric dataIf the cell isMagnifyDisplayed.A cell that contains multiple numeric dataCan be displayed easily.
[0012]
  When changing the size, the width of the column to which the cell belongs or the height of the row may be automatically changed. In the cellMultiple numbersAs a data display methodMultiple numbersThe data may be displayed separated by commas or with line feeds.
[0013]
  Further, as in the invention according to claim 3, the table processing apparatus according to claim 1 or 2The registration means includes a plurality of numerical data surrounded by braces “{” and “}” input by a user operation and separated by commas “,”, or input data for registering single numerical data Registration means (for example, step A2 in FIG. 7)May be further provided.
[0014]
  According to the invention of claim 3,You can enter multiple numeric data in a format that is enclosed by curly brackets “{” and “}” and separated by commas “,” by user operation, or you can enter single numeric data. Multiple or single numerical data can be easily input to the cell.
[0015]
  Further, as in the invention according to claim 4, the claim1Listed processing equipmentInSaidThe arithmetic processing means performs a graph drawing process or a regression calculation on the rearranged table data as a given operation based on the numerical data of the corresponding cells in each column.You may comprise as follows.
[0016]
  According to the invention of claim 4,As a given operation, graph drawing processing or regression calculation can be appropriately performed based on each numerical data of the corresponding cell in each column..
[0017]
  AlsoAs in the invention according to claim 5, in the table processing apparatus according to any one of claims 1 to 3, the data is registered in each of the plurality of cells designated by the designation means for designating the plurality of cells and the designation means. Updating means for updating the numerical data of each cell in the table so as to read out data and register it in association with one of the designated cells (for example, steps E3 to E5 in FIG. 17); You may make it provide.
[0018]
  According to invention of Claim 5,Data registered in a plurality of cells can be re-registered in one cell.
[0019]
  AlsoAs in a sixth aspect of the invention, in the table processing apparatus according to the fifth aspect, the designating unit may designate a plurality of cells based on data registered in the cells.
[0020]
  According to the sixth aspect of the present invention, for example, the cell in the nth column is designated as a cell for designation by the designation means, and based on the data registered in the cell in the nth column, for example, the data is the same or not (For example, the same “1” is registered), a plurality of cells can be designated, and numerical data of the designated cells can be registered in association with one cell.
[0031]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, an embodiment of a table processing apparatus 1 that is a scientific calculator to which the present invention is applied will be described in detail with reference to FIGS. A plurality of embodiments will be described. First, the configuration of the table processing apparatus 1 common to the embodiments will be described.
[0032]
FIG. 1 is a circuit configuration diagram of the table processing apparatus 1. A CPU (Central Processing Unit) 11, an input unit 12, a display unit 13, a communication control unit 14, a RAM (Random Access Memory) 15, and a ROM (Read Only Memory). 16 and an external storage device 17, and each unit is connected by a bus 19. A storage medium 18 is connected to the external storage device 17.
[0033]
The CPU 11 registers, in the RAM 15, specified application programs in various application programs stored in the ROM 16 or the storage medium 18, various data corresponding to various instruction signals input from the input unit 12, and the like. In accordance with the input data, various processes are executed according to the application program registered in the RAM 15, and the processing results are registered in the RAM 15 and displayed on the display unit 13. That is, the CPU 11 executes various programs stored in the ROM 16 or the storage medium 18 to realize various functions in the table processing apparatus 1.
[0034]
The input unit 12 is composed of a numeric keypad, a keyboard, or the like, and outputs an input signal to the CPU 11 when a user inputs a numerical value or instructs execution of an application program.
[0035]
The display unit 13 displays characters and codes input from the input unit 12, processing results of the application program, and the like, and includes an LCD (Liquid Crystal Display) or the like.
[0036]
The communication control unit 14 is an interface for transmitting and receiving data, signals, and the like to an external device via a communication line, and operates according to a signal from the CPU 11.
[0037]
The RAM 15 stores data created by executing various application programs. Details of the data structure will be described later.
[0038]
The ROM 16 stores a basic program corresponding to the table processing apparatus 1. For example, a basic program such as a startup program executed when the power of the table processing apparatus 1 is turned on, various function calculation programs, and a processing program executed in various processing modes is stored.
[0039]
The external storage device 17 stores a program, data, and the like in advance, and includes a storage medium 18 that can be read by the CPU 11 such as a magnetic or optical storage medium or a semiconductor memory.
[0040]
The storage medium 18 is composed of a portable medium such as a CD-ROM or a fixed medium such as a hard disk. Some or all of the programs, data, and the like stored in the storage medium 18 may be received from the communication control unit 14 via a transmission medium such as a communication line from a server or a client. May be a storage medium of a server constructed on a network. Furthermore, the program may be transmitted to a server or a client via a transmission medium such as a communication line and installed in these devices.
[0041]
Further, as processing programs stored in the storage medium 18, data input processing, formula input processing, cell correspondence processing, plural → single conversion processing, single → multiple conversion processing, sort processing, nesting processing, statistical result display processing, statistical Processing, information display / non-display processing, identification display processing, approximate value display processing, multiple information display processing, priority information setting processing, and the like.
[0042]
FIG. 2 is a diagram showing a data configuration of the RAM 15. The RAM 15 includes a work data area 21, a table data area 22, a regression calculation data area 23, a graph drawing data area 24, a statistical calculation data area 25, and an information table 26.
[0043]
The work data area 21 temporarily stores designated application programs, data input to and output from the CPU 11, processing results, and the like as various application programs are executed.
[0044]
The table data area 22 stores table data to be displayed on the display unit 13. The table data is composed of an array of cells, and one or a plurality of data is stored in the cell. Details of the area will be described later.
[0045]
In the regression calculation data area 23, the calculation result of the regression calculation obtained by the cell correspondence processing (see FIG. 12) described later is stored.
[0046]
In the graph drawing data area 24, graph drawing data obtained by cell correspondence processing (see FIG. 12) described later is stored.
[0047]
The statistical calculation data area 25 stores statistical data obtained by statistical processing (see FIG. 30) described later.
[0048]
The information table 26 stores information related to data that is set in statistical processing (see FIG. 30) to be described later and that is subject to statistical processing. Details of the information table 26 will be described later with reference to FIG.
[0049]
FIG. 3 is a diagram showing the data structure of the table data stored in the table data area 22. A column number or a list name is stored in the first row of the table data stored in the table data area 22, and a row number or the like is stored in the first column. A section defined by the intersection of rows and columns of table data is defined as a cell, and data such as one or a plurality of numerical values, characters, and mathematical expressions is registered in the cell.
[0050]
[First Embodiment]
The table processing apparatus 1 in the first embodiment will be described with reference to FIGS.
[0051]
4 and 5 are diagrams showing a table displayed on the display unit 13 and input keys operated when the data input process shown in FIG. 7 is executed.
[0052]
As shown in FIG. 4A, when “1” is input from the input unit 12 by the user to the cell (for example, the cell (List1, 1)) where the cursor 41 is located, the CPU 11 displays FIG. ), “1”, which is the input content, is displayed at the lower left of the table. Subsequently, when the “EXE” key is input by the user, the CPU 11 determines “1” as data to be registered in the cell (List1, 1) and displays it in the cell (FIG. 4B). “1” is registered in the area corresponding to the cell (List1, 1) in the area 22.
[0053]
Further, as shown in FIG. 5A, when the user inputs “{1, 2, 3}” as a plurality of data to the cell (List1, 1) from the input unit 12, the CPU 11 The input content “{1, 2, 3}” is displayed at the lower left of the table 5 (a). Subsequently, when the “EXE” key is input by the user, the CPU 11 determines “1, 2, 3” as data to be registered in the cell (List1, 1) and displays it in the table cell (FIG. 5 ( b)), “1, 2, 3” is stored as one integrated data in the area corresponding to the cell (List1, 1) of the table data area 22. After the data is registered in the cell (List1, 1), when the cell is selected by the user, as shown in FIG. 5C, the cursor 41 is positioned in the cell (List1, 1), and the CPU 11 displays the table. The data registered in the cell is displayed at the lower right of.
[0054]
Here, a plurality of data arranged in braces “{” and “}” and separated by commas “,” indicate integrated data registered in one cell.
[0055]
FIG. 6 is a diagram illustrating an example of a table display method when integrated data is registered in one cell. In FIG. 6A, the same number of frames (for example, frames 61 to 63) as the data are overlapped and displayed in a cell in which a plurality of data are registered. This shows how to display the data registered at the beginning of.
[0056]
For example, as shown in FIG. 5B, when three pieces of data are registered in the cell (List1, 1), the CPU 11 displays the frames 61 to 63 in an overlapping manner on the cell (List1, 1). In the frame 61, “1”, which is data registered at the head of the cell (List1, 1), is displayed. When the user selects the frame 62 or 63 from the input unit 12, the CPU 11 sequentially displays the second or third data registered in the cell (List1, 1).
[0057]
FIG. 6B shows a method in which a cell in which a plurality of data is registered is divided into the same number of sections as the data, and the data registered in the sections is displayed.
[0058]
For example, as shown in FIG. 5B, when three data are registered in the cell (List1, 1), the CPU 11 divides the cell (List1, 1) into three, and registers them in the divided sections. Each of the data being displayed is displayed.
[0059]
FIG. 7 is a flowchart for explaining the operation of the data input process executed by the table processing apparatus 1. This processing shows the operation of data input processing for one cell, and this processing is repeatedly executed when data is continuously input to cells.
[0060]
First, the CPU 11 determines whether or not a key is input from the input unit 12 by the user (step A1), and repeats the process of step A1 until there is a key input. When the input is made (step A1: Yes), the CPU 11 determines whether or not the input data is data stored in the table data area 22 (step A2). When the input data is not data stored in the table data area 22 (step A2: No), the CPU 11 executes another process.
[0061]
On the other hand, when the input data is data stored in the table data area 22 (step A2: Yes), the CPU 11 determines whether or not there is a plurality of input data (step A3). When the input data is not plural (step A3: No), the CPU 11 registers the input data in the table data area 22 (step A4), and advances the processing to step A7. When there are a plurality of input data (step A3: Yes), the CPU 11 registers the plurality of data in the table data area 22 as one integrated data (step A5).
[0062]
Subsequently, the CPU 11 performs an extended display process on the cell in which the integrated data is registered in step A5 in the table displayed on the display unit 13 (step A6). In order to display all or part of the integrated data registered in step A5 in the table cell displayed on the display unit 13, the column width or row height of the cell is changed. It is a process to display.
[0063]
Next, the CPU 11 displays the data registered in the table data area 22 in step A4 or step A5 in the table cell displayed on the display unit 13 (step A7). Next, when the user inputs to end the data input process (step A8: Yes), the CPU 11 ends the process. If it is input that the process is not ended (step A8: No), the CPU 11 executes another process.
[0064]
As described above, in the data input process executed in the table processing apparatus 1 according to the first embodiment, the CPU 11 determines whether or not there is a plurality of input data for the data input by the user, and the table data The input data is registered in the area 22 and the input data is displayed in the table cell displayed on the display unit 13. When the data registered in the cell is integrated data, the CPU 11 changes the size of the cell to be displayed, and then displays the integrated data in the cell.
[0065]
Thus, when a plurality of data is input to one cell, the plurality of data can be registered in the cell without defining a special input method that has been conventionally performed. Therefore, for example, textbook problems and test result data can be easily expressed in a table, and the table processing apparatus 1 that can be easily used for learning can be realized.
[0066]
[Second Embodiment]
With reference to FIGS. 8-10, the table processing apparatus 1 in the 2nd Embodiment of this invention is demonstrated.
[0067]
8 and 9 are diagrams showing contents displayed on the display unit 13 and input keys operated when the formula input process shown in FIG. 10 is executed. When the CPU 11 reads the processing program stored in the storage medium 18 and executes the formula data input process, the CPU 11 waits for a formula input by the user. In the second embodiment, an expression is a command statement for registering data in a cell, and is input using a program command or the like stored in advance in the ROM 16.
[0068]
First, as shown in FIG. 8A, when the user inputs “{1, 2, 3} → List1” and further inputs the “EXE” key, the CPU 11 displays “{1, 2, 2 3} → List1 ”,“ 1 ”is registered in the first cell of the List1 column of the table data area 22,“ 2 ”is registered in the second cell, and“ 3 ”is registered in the third cell.
[0069]
Subsequently, when “List1” is input by the user, as shown in FIG. 8B, the CPU 11 displays the contents of the data registered in the List1 column in the table data in the table data area 22. To display.
[0070]
Further, as shown in FIG. 9A, the user inputs “{{1, 2, 3}, {4, 5, 6}, {7, 8, 9}} → List1”, and further “EXE” When the key is input, the CPU 11 determines “{{1, 2, 3}, {4, 5, 6}, {7, 8, 9}} → List1” as the formula data, and stores the table data area 22. “1, 2, 3” is registered in the first cell of the column of List1, “4, 5, 6” is registered in the second cell, and “7, 8, 9” is registered in the third cell.
[0071]
Subsequently, when “List1” is input by the user, as shown in FIG. 9B, the CPU 11 displays the contents of the data registered in the List1 column in the table data in the table data area 22. To display.
[0072]
FIG. 10 is a flowchart for explaining the operation of the formula input process executed by the table processing apparatus 1. This processing shows the operation of data input processing for one cell group, for example, a column. When data is continuously input, this processing is repeatedly executed.
[0073]
First, the CPU 11 determines whether or not a key is input from the input unit 12 by the user (step B1), and repeats the process of step B1 until there is a key input. If an input has been made (step B1: Yes), it is determined whether or not the input data is formula data representing storing data in the table data area 22 (step B2). When it is not formula data (step B2: No), CPU11 performs another process.
[0074]
On the other hand, if it is formula data (step B2: Yes), the CPU 11 determines whether there is a plurality of data to be registered in one cell (step B3). If the data is not plural (step B3: No), the CPU 11 compiles the formula data (step B4) and registers the data in the table data area 22 (step B5). And CPU11 advances a process to step B9.
[0075]
When there are a plurality of data to be registered in one cell (step B3: Yes), the CPU 11 compiles the formula data (step B6) and registers the plurality of data in the table data area 22 as one integrated data (step B7). . Subsequently, the CPU 11 performs an extended display process on the cell in which the integrated data is registered in Step B7 in the table displayed on the display unit 13 (Step B8).
[0076]
Next, the CPU 11 displays the data registered in the table data area 22 in step B5 or step B7 in the table cell displayed on the display unit 13 (step B9). Next, when the user inputs to end the data input process (step B10: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step B10: No), the CPU 11 executes another process.
[0077]
As described above, in the formula input process executed in the table processing apparatus 1 according to the second embodiment, the CPU 11 determines whether or not there is a plurality of data to be registered in one cell for the formula data input by the user. Is determined. The CPU 11 registers the data in the table data area 22 and displays the data in the corresponding cell of the table displayed on the display unit 13. When the data registered in the cell is integrated data, the CPU 11 changes the size of the cell to be displayed, and then displays the integrated data in the cell.
[0078]
In this way, by inputting formula data using a program command, a plurality of data can be registered in one cell, and registration of data for a plurality of cells can be performed collectively.
[0079]
[Third Embodiment]
A table processing apparatus 1 according to the third embodiment will be described with reference to FIGS.
[0080]
FIG. 11 is a diagram showing the contents displayed on the display unit 13 and the processing results when the cell correspondence processing shown in FIG. 12 is executed. The cell correspondence process is a process for executing a given process by associating data of two cell groups having the same number of data.
[0081]
For example, when the CPU 11 executes the cell association processing for the columns List1 and List2 in the table shown in FIG. 11A, the CPU 11 associates each data registered in the cells in the same row of List1 and List2. At this time, the CPU 11 counts the number of rows and the number of data of List1 and List2. If the number of rows and the number of data are the same, for a cell in which multiple data are registered, the new cell is connected to the cell and a new cell is inserted to change the configuration of the cell, and the integration registered in the cell Sort and register data in each cell where data is inserted. The table data at this time is as shown in FIG.
[0082]
Then, the process proceeds to the next process according to the user's input instruction. In the present embodiment, regression calculation and graph drawing will be described as the content of the process instructed by the user, but the content of the process is not limited to this.
[0083]
When the regression calculation is executed on the table data displayed in FIG. 11A, the user selects the CALC button 110 using the input unit 12. As a result, as shown in FIG. 11C, the CPU 11 displays the selection item column 111, and further displays the selection item column 112 when "3: REG" is selected by the user. For example, when “1: Linear” is selected by the user, the CPU 11 executes a cell handling process.
[0084]
Then, the CPU 11 executes linear regression calculation based on the table data shown in FIG. 11B with the data registered in the List1 column as the variable X and the data registered in the List2 column as the variable Y, The execution result is displayed on the display unit 13 (FIG. 11D).
[0085]
In addition, when the graph drawing is executed on the table data displayed in FIG. 11A, the user selects the GRPH button 113 by the input unit 12. As a result, the CPU 11 displays the selection item column 114 as shown in FIG. Subsequently, for example, when “1: S-Gph1” is selected by the user, the CPU 11 executes a cell handling process.
[0086]
Then, based on the table data shown in FIG. 11B, the CPU 11 uses the data registered in the List1 column as X coordinate data (or Y coordinate data) and the data registered in the List2 column as Y coordinate data ( Or X coordinate data), a graph is created based on the processing of the graph instructed by the user, and is displayed on the display unit 13 (FIG. 11 (d ′)).
[0087]
12 and 13 are flowcharts for explaining the operation of the cell correspondence processing executed by the table processing apparatus 1. First, the CPU 11 determines whether or not a command is input from the input unit 12 by the user (step C1), and repeats the process of step C1 until a command is input. If an input has been made (step C1: Yes), it is determined whether or not the content of the command is a process that requires execution of a cell correspondence process (step C2). If the cell-corresponding process is not a required process (step C2: No), the CPU 11 executes another process.
[0088]
On the other hand, if the command is a process requiring execution of the cell correspondence process (step C2: Yes), the CPU 11 displays the first cell group of the table data displayed on the display unit 13 (for example, List1 in FIG. 11A). For the second cell group and the second cell group (for example, the column List2 in FIG. 11A), the table data stored in the table data area 22 is read and stored in the work data area 21 (step C3).
[0089]
Subsequently, the CPU 11 determines whether or not there is integrated data registered in one cell among the table data stored in the work data area 21 (step C4). When there is no integrated data (step C4: No), the CPU 11 determines whether or not the number of rows in the first cell group and the second cell group stored in the work data area 21 is the same (step C5). If the number of rows is the same (step C5: Yes), the CPU 11 advances the process to step C10. When the number of lines is different (step C5: No), the CPU 11 displays an error message on the display unit 13 (step C7) and ends the process.
[0090]
On the other hand, when there is integrated data (step C4: Yes), the CPU 11 determines whether or not the number of rows in the first cell group and the second cell group stored in the work data area 21 is the same (step C6). When the number of lines is different (step C6: No), the CPU 11 shifts the process to step C7.
[0091]
When the number of rows is the same (step C6: Yes), the CPU 11 determines whether or not the number of data is the same in the cells in the same row where the integrated data of the first cell group and the second cell group is registered ( Step C8). When the number of data is different (step C8: No), the CPU 11 shifts the process to step C7.
[0092]
If the number of data is the same (step C8: Yes), the CPU 11 inserts a new cell in the table stored in the work data area 21 by linking to the cell where the integrated data is registered. The configuration of the cells is changed, and the integrated data registered in the cell is distributed and registered to each inserted cell. (Step C9).
[0093]
Then, the CPU 11 determines whether the instruction input by the user is regression calculation or graph drawing (step C10). When an instruction for regression calculation is input (step C10: regression), the CPU 11 executes the regression calculation based on the regression calculation formula stored in the ROM 16 and the table data stored in the work data area 21. Then, the calculation result is stored in the regression calculation data area 23 (step C11). Subsequently, the CPU 11 displays the data stored in the regression calculation data area 23 on the display unit 13 (step C12), and advances the process to step C15.
[0094]
On the other hand, when a graph drawing instruction is input (step C10: graph), the CPU 11 creates a graph based on the table data stored in the work data area 21, and stores data related to graph drawing in the graph drawing data area 24. (Step C13). Subsequently, the CPU 11 displays a graph on the display unit 13 based on the data stored in the graph drawing data area 24. (Step C14).
[0095]
Next, when it is input by the user to end the process that requires execution of the cell handling process (step C15: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step C15: No), the CPU 11 executes another process.
[0096]
As described above, in the cell correspondence processing executed in the table processing apparatus 1 according to the third embodiment, the CPU 11 selects the first cell group designated for processing from the table data stored in the table data area 22. Read the table data of the second cell group and store it in the work data area 21, count the number of rows and the number of data for the first cell group and the second cell group stored in the work data area 21, Compare. If the number of rows and the number of data are the same, for the cell in which the integrated data is registered, it is connected to the cell, a new cell is inserted, the cell configuration is changed, and the cell is registered in the cell. Sort and register each cell into which the integrated data is inserted. Based on the table data stored in the work data area 21 reconstructed in this way, the CPU 11 executes a given process.
[0097]
As a result, when a given process is executed for a table including cells in which integrated data is registered in one cell, the user distributes the integrated data registered in one cell to individual cells and re-executes the processing. There is no need to input again, and the table processing apparatus 1 can easily execute processing such as regression calculation and graph drawing.
[0098]
[Fourth Embodiment]
With reference to FIGS. 14 and 15, a table processing apparatus 1 according to a fourth embodiment of the present invention will be described.
[0099]
FIG. 14 is a diagram showing the contents displayed on the display unit 13 and the processing results when the plural → single conversion processing shown in FIG. 15 is executed. The plural → single conversion process is a process of allocating and registering each data to each cell in the cell in which the integrated data is registered.
[0100]
First, the user sets the cursor 140 in a cell of a column to be subjected to a plurality → single conversion process (FIG. 14A), and selects the CONU button 141 using the input unit 12. Thereby, as shown in FIG. 14B, the CPU 11 displays the selection item column 142, and when “1: Norm” is selected by the user, the CPU 11 executes the plural → single conversion process.
[0101]
Next, when the integrated identifier is stored in the processing target cell of the plural → single conversion process, the CPU 11 displays an input field 143 for inputting the column number of the column in which the integrated identifier is registered as shown in FIG. . Here, the integrated identifier is identification information indicating whether or not the data is integrated data, and is a unique number for each integrated data. Note that the user can select whether or not to acquire the integrated identifier.
[0102]
Next, when the user inputs, for example, “3” as the column number of the column in which the integrated identifier is registered, and subsequently the “EXE” key is input, the CPU 11 confirms that the integrated identifier is registered in the List3 column. (FIG. 14D). Then, the CPU 11 executes plural → single conversion processing and displays the processing result on the display unit 13 as shown in FIG.
[0103]
Here, data registered in the List3 cell as an integrated identifier of data registered in the List1 cell in FIG. 14E will be described. Since the data registered in the first to third cells of List1 is the integrated data registered in the first cell of List1 before the multiple-to-single conversion process, the cells in the first to third rows of List3 “1” is registered in all. Similarly, the data registered in the 4th and 5th rows of List1 is also the integrated data registered in the second cell of List1 before the multiple-to-single conversion process, so the 4th and 5th rows of List3. “2” is registered in this cell. The data registered as the integrated identifier may be a symbol such as an alphabet in addition to the cell number.
[0104]
FIG. 15 is a flowchart for explaining the operation of the plural → single conversion process executed by the table processing apparatus 1. First, the CPU 11 determines whether or not a command is input from the input unit 12 by the user (step D1), and repeats the process of step D1 until a command is input. If an input has been made (step D1: Yes), it is determined whether or not the input command is a command for instructing execution of a plurality → single conversion process (step D2). If the command is not a command for instructing the execution of the plural → single conversion process (step D2: No), the CPU 11 executes another process.
[0105]
If it is a command for instructing the execution of the plural-to-single conversion process (step D2: Yes), the CPU 11 determines whether or not to acquire the integrated identifier based on the instruction data input by the user (step D3). . When not acquiring an integrated identifier (step D3: No), CPU11 advances a process to step D6.
[0106]
When the integrated identifier is acquired (step D3: Yes), an input field 143 for inputting a column for registering the integrated identifier is displayed on the display unit 13. Then, the user inputs a column number for registering the integrated identifier (step D4). Then, the CPU 11 registers the cell number of the data in the table data stored in the table data area 22 in the cell of the column number input in step D4 (step D5).
[0107]
Next, the CPU 11 reads out the table data of the cell to be processed and the integrated identifier from the table data stored in the table data area 22, and stores it in the work data area 21 (step D6). Subsequently, in the table data stored in the work data area 21, the CPU 11 inserts a new cell by connecting to the cell in which the integrated data is registered, changes the configuration of the cell, The integrated data registered in the cell is distributed and registered to the individual cells inserted. (Step D7). Then, the CPU 11 displays the reconstructed table data stored in the work data area 21 on the display unit 13 (step D8).
[0108]
Next, when the user inputs to end the plural → single conversion process (step D9: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step D9: No), the CPU 11 executes another process.
[0109]
As described above, in the multiple-to-single conversion process executed in the table processing apparatus 1 according to the fourth embodiment, the table data stored in the table data area 22 is registered in the cell group designated for the process. When the user selects an instruction to acquire an integrated identifier for the current data, the CPU 11 acquires the integrated identifier for the data and stores it in the table data area 22. Then, out of the table data stored in the table data area 22, the table data of the cell group designated for processing and the integration identifier is read out, stored in the work data area 21, and the cell in which the integration data is registered is read out. Then, by connecting to the cell and inserting a new cell to change the configuration of the cell, the integrated data registered in the cell is distributed and registered to each inserted cell. Then, the CPU 11 displays the reconstructed table data of the work data area 21 on the display unit 13.
[0110]
As a result, when converting a table containing cells with integrated data registered in one cell to a table with one data registered in one cell, the user assigns the data to each cell and re-enters the data. There is no need to redo, and it is possible to make the table processing apparatus 1 continue to easily execute processing such as regression calculation and graph drawing.
[0111]
[Fifth Embodiment]
With reference to FIGS. 16 and 17, a table processing apparatus 1 according to a fifth embodiment of the present invention will be described.
[0112]
FIG. 16 is a diagram showing the contents and processing results displayed on the display unit 13 when the single-to-multiple conversion process shown in FIG. 17 is executed. Single-to-multiple conversion processing is processing in which data registered in individual cells is collectively registered in one cell as integrated data.
[0113]
First, as shown in FIG. 16A, the user sets the cursor 150 in a cell of List1 that is a column for performing a single-to-multiple conversion process, and selects the CONU button 151 by the input unit 12. As a result, the CPU 11 displays the selection item column 152 as shown in FIG. When “2: Expand” is selected by the user, as shown in FIG. 16C, the CPU 11 inputs an input field 153 for inputting a column number in which the integrated identifier of data registered in the cell of List 1 is registered. Is displayed. When the user inputs, for example, “3” as the column number in which the integrated identifier is stored as shown in FIG. 16D, and subsequently inputs the “EXE” key, the column number in FIG. As described above, the CPU 11 executes the single-to-multiple conversion process on the data registered in the List1 column based on the integrated identifier registered in the List3 column. Then, the CPU 11 displays the processing result.
[0114]
FIG. 17 is a flowchart for explaining the operation of the single-to-multiple conversion process executed by the table processing apparatus 1. First, the CPU 11 determines whether or not a command is input from the input unit 12 by the user (step E1), and repeats the process of step E1 until a command is input. If an input has been made (step E1: Yes), it is determined whether or not the input command is a command for instructing execution of a single-to-multiple conversion process (step E2). If it is not a command for instructing execution of a single-to-multiple conversion process (step E2: No), the CPU 11 executes another process.
[0115]
In the case of a command for instructing execution of a single-to-multiple conversion process (step E2: Yes), the CPU 11 displays an input field 153 for inputting a column in which the integrated identifier of the column to be processed is registered on the display unit 13. Then, the user inputs the column number in which the integrated identifier is registered. (Step E3). Next, the CPU 11 reads out the table data including the column to be processed and the column in which the integration identifier is registered from the table data area 22 and stores it in the work data area 21 (step E4).
[0116]
Then, the CPU 11 registers the table data stored in the work data area 21 in one cell as the integrated data based on the integrated identifier, and changes the configuration of the cells ( Step E5). Subsequently, the CPU 11 displays the reconstructed table data stored in the work data area 21 on the display unit 13 (step E6).
[0117]
Next, when the user inputs to end the cell handling process (step E7: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step E7: No), the CPU 11 executes another process.
[0118]
As described above, in the single-to-multiple conversion process executed in the table processing apparatus 1 according to the fifth embodiment, the table data stored in the table data area 22 is registered in the cell group designated for the process. Based on the integrated identifier for the data being stored, the data registered in the individual cells is registered as integrated data in one cell, and the reconstructed table data in the work data area 21 is displayed on the display unit 13.
[0119]
Thereby, the integrated data distributed and registered in each cell can be registered again in one cell by executing the single-to-multiple conversion process described in the fifth embodiment.
[0120]
[Sixth Embodiment]
With reference to FIGS. 18-20, the table processing apparatus 1 in the 6th Embodiment of this invention is demonstrated.
[0121]
FIG. 18 is a diagram showing the contents displayed on the display unit 13 and the processing results when the sort processing shown in FIG. 19 is executed. The sort process is a process of rearranging data registered in the cell group in ascending order or descending order.
[0122]
First, as shown in FIG. 18A, the user sets the cursor 190 in a cell of List1 that is a column on which sorting processing is performed, and selects the SORT button 191 by the input unit 12. Thereby, the CPU 11 displays a selection item column 192 as shown in FIG. Here, “1: SortH” indicates an ascending sort, and “2: SortD” indicates a descending sort. For example, when “1: SortH” is selected by the user, the CPU 11 selects one registered in the cell or the data registered at the head of the cell after sorting the order of the integrated data for each cell. As shown in FIG. 18C, an input field 193 for inputting whether or not to further sort the cells is displayed. Then, as shown in FIG. 18D, when “0” is input by the user and subsequently the “EXE” key is input, the CPU 11 sorts the data registered in the List 1 column for each cell. The result of the sort process is displayed on the display unit 13 as shown in FIG.
[0123]
In addition, when “1” is input by the user and subsequently the “EXE” key is input to the input field 193 as shown in FIG. 18D ′, the CPU 11 stores the data registered in the List 1 column. Are sorted for each cell, and the cell order is further sorted based on the data registered at the head of the cell. Then, as shown in FIG. 18 (e ′), the CPU 11 displays the result of the sorting process on the display unit 13.
[0124]
19 and 20 are flowcharts for explaining the sort processing operation executed by the table processing apparatus 1. First, the CPU 11 determines whether or not a command is input from the input unit 12 by the user (step F1), and repeats the process of step F1 until a command is input. If an input has been made (step F1: Yes), it is determined whether or not the input command is a command for instructing execution of sort processing (step F2). If it is not a command for instructing execution of sort processing (step E2: No), the CPU 11 executes other processing.
[0125]
Next, the user inputs whether to perform ascending order sorting or descending order sorting (step F3), and then inputs whether to sort the cell order (step F4). When input is made to sort the cell order by the user (step F4: Yes), the CPU 11 assigns 1 to the variable C (step F5). If it is input that the cell order is not sorted (step F4: No), the CPU 11 assigns 0 to the variable C (step F6).
[0126]
Next, the CPU 11 reads out the table data of the column to be processed from the table data area 22 and stores it in the work data area 21 (step F7), and executes sort processing for the cells in which the integrated data is registered (step F8). . Subsequently, the CPU 11 determines the value of the variable C (step F9). When C = 0 (step F9: No), the CPU 11 advances the process to step F11. On the other hand, when C = 1 (step F9: Yes), the CPU 11 executes the cell order sorting process based on the top data of each cell of the table data stored in the work data area 21 (step F10). .
[0127]
Then, the CPU 11 displays the table data subjected to the sorting process stored in the table data area 21 on the display unit 13 (step F11). Subsequently, when the user inputs that the sort process is to be ended (step F12: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step F12: No), the CPU 11 executes another process.
[0128]
As described above, in the sort process executed in the table processing apparatus 1 according to the sixth embodiment, the CPU 11 is registered in the cell group designated for processing among the table data stored in the table data area 22. Sort processing is performed for each cell for a plurality of data. Further, according to the user's selection, the CPU 11 executes a cell order sorting process based on the data registered at the head of the cell.
[0129]
Thereby, when the integrated data is registered in one cell, the sort process can be executed without the user distributing the integrated data to each cell and re-inputting.
[0130]
[Seventh Embodiment]
A table processing apparatus 1 according to a seventh embodiment of the present invention will be described with reference to FIGS.
[0131]
21 to 24 are diagrams showing the contents and processing results displayed on the display unit 13 when the nesting process shown in FIG. 25 is executed. Nesting is a process in which the same data as the data registered in the column of the column number is registered in the cell when another cell range, for example, the column number of a different column is registered as data registered in the cell. It is.
[0132]
21 and 22 show a case where the CPU 11 displays the column number in the cell when another cell range, such as a column number, is registered in the cell by the user. First, as shown in FIG. 21A, the user designates a column for registering data with the cursor 221, inputs “{List1, List2, 3}” as data, and finally inputs an “EXE” key. As a result, the CPU 11 associates the data registered in List1 with the first cell of List3 in the table data area 22, the data registered with List2 in the second cell, and "3" in the third cell. Then, it is registered and displayed on the display unit 13 as shown in FIG.
[0133]
The user can also execute data nesting by inputting an expression. For example, as shown in FIG. 22A, “{List1, List2, 3} → List3” is input, and finally “EXE "Enter the key. As a result, the CPU 11 associates the data registered in List1 with the first cell of List3 in the table data area 22, the data registered with List2 in the second cell, and "3" in the third cell. Then, it is registered and displayed on the display unit 13 as shown in FIG.
[0134]
23 and 24 show a case where the data registered in the column of the column number registered by the user is displayed in the cell.
[0135]
First, as shown in FIG. 23A, the user designates a column for registering data with the cursor 231, inputs “{List1, List2, 3}” as data, and finally inputs an “EXE” key. . As a result, the CPU 11 has data “1, 2, 3” registered in the first cell of List3 in the table data area 22 and data registered in List2 in the second cell “ “4, 5” is registered in association with “3” in the third cell and displayed on the display unit 13 as shown in FIG.
[0136]
In addition, when the user executes data nesting by inputting an expression, for example, as shown in FIG. 24A, “{List1, List2, 3} → List3” is input, and finally the “EXE” key is input. To do. As a result, the CPU 11 sets the data “1, 2, 3” that is registered in the first cell of List3 in the table data area 22 to the data “4, 4” that is registered in List2 in the second cell. “5” is registered in association with “3” in the third cell and displayed on the display unit 13 as shown in FIG. 24B (FIG. 24B).
[0137]
By executing the nesting process by the CPU 11 as shown in FIGS. 21 to 24, the contents of List1 and the cells (List3, 1) are associated with each other. The CPU 11 automatically changes the contents of the data registered in the cell (List3, 1) and simultaneously changes the contents of the cell displayed on the display unit 13.
[0138]
FIG. 25 is a flowchart for explaining the operation of the nesting process executed by the table processing apparatus 1. First, the CPU 11 determines whether or not a key is input from the input unit 12 by the user (step G1), and repeats the process of step G1 until there is a key input. If an input has been made (step G1: Yes), it is determined whether or not the input data is data indicating a nesting process (step G2). When there is no data indicating the nesting process (step G2: No), the CPU 11 executes another process.
[0139]
On the other hand, when the data indicates nesting processing (step G2: Yes), the CPU 11 compiles the data with respect to the data input by the expression input (step G3). Then, the input data (for example, List1) is displayed as it is for the cell in which the data is registered, or the data registered in the cell group indicated by the input data (for example, registered in the column of List1). Display data “1, 2, 3”) is displayed. When an input for displaying the input data as it is is made (step G4: Yes), the input data is registered in association with the designated cell (step G5), and the CPU 11 advances the process to step G8. .
[0140]
On the other hand, when an input is made to display data registered in the cell group indicated by the input data in the designated cell (step G4: No), the CPU 11 registers in the cell group indicated by the input data. The registered data is registered in association with the designated cell (step G6), and an extended display process for changing the size of the cell is performed (step G7).
[0141]
Then, the CPU 11 displays the table data stored in the table data area 22 on the display unit 13 (step G8), and when the user inputs that the nesting process is to be terminated (step G9: Yes), the CPU 11 performs processing. Exit. When it is input that the process is not ended (step G9: No), the CPU 11 executes another process.
[0142]
As described above, in the nesting process executed in the table processing apparatus 1 in the seventh embodiment, data including another cell range, for example, a column number of a different column, is input by the user as data to be registered in the cell. Then, the CPU 11 registers the same data as the data registered in the cell group indicated by the input data. Further, when registering data in a cell, the CPU 11 processes whether to display a column number or data registered in a column of the column number according to a user instruction.
[0143]
Thus, nested processing can be realized in a table in which a plurality of data is registered in one cell, and complicated data processing can be performed.
[0144]
[Eighth Embodiment]
A table processing apparatus 1 according to an eighth embodiment of the present invention will be described with reference to FIGS.
[0145]
FIG. 26A is a diagram showing the table data displayed on the display unit 13, and FIG. 26B is a table showing statistics on data registered in List 1 in the table data shown in FIG. 26A. It is the figure which showed the processing result (henceforth "information") when performing a process (refer FIG. 30). Further, the processing result shown in FIG. 26B is stored in the statistical calculation data area 25.
[0146]
FIGS. 26A and 26B are not displayed on the display unit 13 at the same time, but are switched and displayed according to a screen switching instruction from the user. In addition to switching and displaying two screens as described above, a method of displaying data on one screen in correspondence with each other's data will be described.
[0147]
FIG. 27 (a) creates an information column in the column adjacent to List1 of the table data shown in FIG. 26 (a), and among the data registered in List1, It is the figure which registers and displays the item of the calculation result in the cell which is the same line as the said data, and is an information column.
[0148]
Here, referring to the result of the statistical processing in FIG. 26B, since minX = 1, the item “minX” is registered in the cell adjacent to “1” registered first in List1. Further, since maxX = 7, the item “maxX” is registered in the cell adjacent to “7” registered in the fourth of List1. The correspondence relationship between the data in the table data and the statistical calculation items is stored in the information table 26. The information table 26 will be described later in detail with reference to FIG.
[0149]
FIG. 27B shows a case where the information column is not displayed. At this time, in order to show that information related to the statistical processing of List1 is stored in the information table 26, “List1” in the first row is displayed. The mark 271 is displayed on the left side of “”.
[0150]
FIG. 28 shows the data structure of the information table 26. The information table 26 is set in statistical processing to be described later, and the vertical direction is the target data for statistical processing (List1 in FIG. 26A), and the horizontal direction is an item (information) obtained by statistical processing. For example, referring to FIG. 26B, since minX = 1 from the result of the statistical processing, a flag is set in an area where “1” in the vertical direction and “minX” in the horizontal direction intersect in the information table 26. Set. In the figure, ◯ indicates that the flag is set.
[0151]
FIG. 29 is a flowchart for explaining the operation of the statistical result display process executed by the table processing apparatus 1. First, the CPU 11 assigns the column number of the column to be subjected to statistical processing to the variable A (step H1), and performs statistical processing (step H2). Then, the user selects a mode related to result display or display setting (step H3). The CPU 11 performs information display / non-display processing (step H4), identification display processing (step H5), approximate value display processing (step H6), multiple information display processing (step H7), and priority order information according to the mode input by the user. One of the setting processes (step H8) is executed.
[0152]
Subsequently, when another display process is input by the user (step H9: Yes), the CPU 11 shifts the process to step H3. If it is input that no other display processing is to be performed (step H9: No), the CPU 11 determines whether or not the processing can be terminated (step H10). When input is made to end the process (step H10: Yes), the CPU 11 ends the process. When it is input that the process is not ended (step H10: No), the CPU 11 executes another process.
[0153]
FIG. 30 is a flowchart for explaining the operation of statistical processing executed by the table processing apparatus 1. First, the CPU 11 executes statistical processing on the column A according to a statistical processing program or the like stored in advance in the ROM 16 (step J1). Then, the CPU 11 stores the calculation result in the statistical calculation data area 25.
[0154]
Next, the CPU 11 substitutes 1 for the variable n (step J2), and compares the data registered in the nth cell of the column A with the calculation result stored in the statistical calculation data area 25 (step J3). ). If there is no calculation result that matches the data registered in the nth cell of column A (step J3: mismatch), the CPU 11 advances the process to step J5. When there is a calculation result that matches the data registered in the nth cell of column A (step J3: match), in the information table 26, the data registered in the nth cell of column A and the processing result A flag is set in the area corresponding to the item (step J4), and 1 is added to the variable n (step J5).
[0155]
Subsequently, the CPU 11 determines whether or not data is registered in the nth cell in the column A (step J6). When the data is registered (step J6: present), the CPU 11 shifts the processing to step J3. When the data is not registered (step J6: None), the CPU 11 ends the statistical process.
[0156]
As described above, in the statistical processing executed in the table processing apparatus 1, the CPU 11 performs statistical calculation on the data registered in the process-specified column, and stores the calculation result in the statistical calculation data area 25. . The CPU 11 compares the calculation result with the data registered in the process-designated column, and sets a flag in the corresponding area of the information table 26 when there is a match.
[0157]
FIG. 31 is a flowchart for explaining the operation of the information display / non-display process executed by the table processing apparatus 1. First, the CPU 11 determines whether or not to display statistical processing information corresponding to the column A stored in the information table 26 based on a key input by the user (step K1). When displaying information (step K1: Yes), the CPU 11 inserts a column of information into a column adjacent to the column A of the table data displayed on the display unit 13 (step K2), and is stored in the information table 26. The items are displayed in the information column according to the statistical processing information corresponding to the existing column A (step K3).
[0158]
If the information is not displayed (step K1: No), the CPU 11 deletes the information column displayed next to the column A (step K4), and performs statistical processing corresponding to the data registered in the column A. In order to indicate that the information is stored in the information table 26, a mark is displayed in the column number column (step K5). Then, the CPU 11 ends the process.
[0159]
Thereby, as shown in FIG. 27A, the data to be subjected to the statistical processing and the result of the statistical processing can be associated with each other and displayed on the display unit 13 at the same time. For this reason, the user can know the result of the statistical processing in an easy-to-understand manner visually.
[0160]
FIG. 32 is a diagram showing a display screen related to the identification display process of step H5 in the statistical result display process of FIG. As shown in FIG. 32, in the identification display process, shading and color are set in advance corresponding to the items of the statistical processing result, and the data that matches the statistical processing result among the data subject to the statistical processing This is a process of displaying the setting contents for the cell in which the data is registered.
[0161]
For example, when the item minX is set by hatching, referring to the result of the statistical processing in FIG. 26B, the cell “1” registered first in List 1 in FIG. 32 is hatched. Is displayed. When the item maxX is set with polka dot shading, the fourth cell “7” registered in List 1 is displayed with polka dot shading.
[0162]
FIG. 33 is a flowchart for explaining the operation of the identification display process executed by the table processing apparatus 1. The CPU 11 performs color display on the data of the column A displayed on the display unit 13 based on the statistical processing result information corresponding to the column A stored in the information table 26 (step M1). Here, shading, character color, and the like are set in advance corresponding to each information. Then, the CPU 11 ends the process.
[0163]
As described above, according to the identification display processing, it is possible to display the data that matches the result of the statistical processing by identifying and displaying it, so that it can be displayed visually and easily.
[0164]
FIG. 34 is a diagram showing a display screen related to the approximate value display process of step H6 in the statistical result display process of FIG. As shown in FIG. 34, the approximate value display process is a process of displaying the statistical processing items corresponding to the data approximated to the result of the statistical processing for the data to be statistically processed.
[0165]
For example, referring to the result of the statistical processing in FIG._n-1Is 2.16024689, but there is no matching data in the data registered in List 1 of FIG. Therefore, among the data registered in List1, the sixth “2” is xσ._n-1The CPU 11 assigns “xσ to the cell adjacent to“ 2 ”in the table data area 22 because_n-1"Is displayed on the display unit 13, and a mark 341 for indicating an approximate value is displayed as" xσ "._n-1"And display.
[0166]
FIG. 35 is a flowchart for explaining the operation of the approximate value display process executed by the table processing apparatus 1. First, the CPU 11 searches the data registered in the column A for data closest to the calculation result of the item having no flag among the information of the statistical processing result corresponding to the column A of the information table 26 (step N1). . When flags are set for all items, or when data close to the calculation result of items for which no flags are set does not exist in column A (step N1: None), the CPU 11 ends the process.
[0167]
When there is data close to the calculation result of the item for which the flag is not set in the column A (step N1: present), the CPU 11 sets a flag indicating an approximate value in the corresponding area of the information table 26 (step N2). ). Subsequently, the CPU 11 inserts an information column in the column adjacent to the column A (step N3), and displays information having a flag indicating an approximate value together with the mark 341 (step N4). Then, the CPU 11 ends the process.
[0168]
As described above, according to the approximate value display process, the data that is the target of the statistical process is further displayed by associating and displaying the approximate item in addition to the item that matches the result of the statistical process. More information about the results can be provided.
[0169]
FIG. 36 is a diagram showing a display screen related to the multiple information display process of step H7 in the statistical result display process of FIG. In the multiple information display process, as shown in FIG. 36, in addition to the display of FIG. 27A, when one piece of data that is the target of the statistical process matches the result of the multiple statistical processes, the CPU 11 registers the data. In this process, a plurality of items are registered in the adjacent cell as integrated data, and a mark 361 is displayed on the right side of the item to indicate that a plurality of calculation results are registered.
[0170]
Referring to the result of the statistical processing in FIG._n, Q1, Mod values are “2”, and approximate value xσ_n-1Including a total of four items match “2”. Therefore, the cell adjacent to the sixth “2” of List1 contains xσ._n, Q1, Mod and xσ_n-1In the cell displayed on the display unit 13, the item registered at the top is displayed together with the mark 361. Further, the CPU 11 sequentially displays other values by the user's key operation from the input unit 12.
[0171]
FIG. 37 is a flowchart for explaining the operation of the multiple information display process executed by the table processing apparatus 1. First, the CPU 11 inserts an information column in the column adjacent to the column A (step P1), reads out information on the result of statistical processing corresponding to the data registered in the column A from the information table 26, and reads the information column. (Step P2). In addition, the CPU 11 displays a mark 361 for the cell in which the integrated data is registered among the cells in the information column (step P3), and ends the process.
[0172]
Thus, according to the multiple information display process, when there are multiple results that match the data to be statistically processed, more information regarding the statistical process can be obtained by registering multiple items in the cell as integrated data. Can be displayed.
[0173]
FIG. 38 is a diagram showing a display screen related to the priority order information setting process of step H8 in the statistical result display process of FIG. As shown in FIG. 38, the priority order information setting process displays a screen for setting the display order when a plurality of items are registered in one cell as shown in FIG. When the priority is set for each item by the user and a plurality of items are registered as integrated data in one cell, the CPU 11 displays according to the set priority.
[0174]
FIG. 39 is a flowchart for explaining the operation of the priority order information display process executed by the table processing apparatus 1. First, the CPU 11 inserts an information column in the column adjacent to the column A (step Q1), reads out information on the result of statistical processing corresponding to the data registered in the column A from the information table 26, and reads the information column. (Step Q2).
[0175]
Next, the CPU 11 displays a screen for setting a priority order for displaying information on the display unit 13. When the priority is set by the user (step Q3), the CPU 11 rearranges information on the cells in which the integrated data is registered based on the set priority, and the integrated data is further registered. Is displayed in the cell (step Q4), and the process is terminated.
[0176]
As described above, according to the priority order information setting process, the user can set an environment that can be easily used by setting the data display order for the cells in which the integrated data is registered.
[0177]
By using the table processing apparatus 1 as described above, a plurality of data can be registered as integrated data in one cell, so that it is possible to easily input matrix data and the like that are difficult to process in the conventional method, Further, it can be displayed in an easy-to-understand manner. Also, by integrating and registering the integrated data into individual cells, it is possible to execute processes such as regression calculation and graph drawing. Furthermore, data registered in other rows and columns can be specified and registered in one cell by data input by nesting processing. Even when integrated data is registered in one cell by the sorting process, the sorting can be easily executed. At that time, it is possible to select either a sort to be executed for each cell or a sort to change the order of the cells, and the user can execute a desired sort process. Further, since the related information for the data registered in the cell can be registered in another cell corresponding to the data, the related information for the data can be easily and easily displayed.
[0178]
【The invention's effect】
  According to the inventions of claims 1 and 13, for one cellRegister multiple numeric data or single numeric dataCanOf the cells in the registered table, for cells in which multiple numeric data are registered, insert the cells corresponding to the multiple numeric data, and distribute the multiple numeric data to the inserted cells for relocation. A given operation can be performed on the tabulated data. Therefore, the number of numerical data registered in each cell of the table can be arbitrarily changed, and an operation can be performed on an easy-to-understand table corresponding to the learning content.
[0179]
  According to invention of Claim 2,A cell that contains multiple numeric dataIf the cell isMagnifyDisplayed.A cell that contains multiple numeric dataCan be displayed easily.
[0180]
  According to invention of Claim 3,You can enter multiple numeric data in a format that is enclosed by curly brackets “{” and “}” and separated by commas “,” by user operation, or you can enter single numeric data. Multiple or single numerical data can be easily input to the cell.
[0181]
  According to invention of Claim 4,As a given operation, graph drawing processing or regression calculation can be appropriately performed based on each numerical data of the corresponding cell in each column..
[0182]
  According to invention of Claim 5,Numerical data registered in a plurality of cells can be re-registered in one cell.
[0183]
  According to the invention described in claim 6,For example, the cell in the nth column is designated as a cell for designation by the designation means, and based on the data registered in the cell in the nth column, for example, whether the data is the same (for example, the same “1” is registered) For example, a plurality of cells can be specified, and numerical data of the specified cells can be registered in association with one cell.
[Brief description of the drawings]
FIG. 1 is a circuit configuration diagram of a table processing apparatus 1;
FIG. 2 is a diagram showing a data structure of a RAM.
FIG. 3 is a diagram showing a data configuration of a table data area.
FIG. 4 is a diagram showing a table displayed on the display unit and input keys operated when data input processing is executed.
FIG. 5 is a diagram showing a table displayed on the display unit and input keys operated when data input processing is executed.
FIG. 6 is a diagram showing a table display method when integrated data is registered in one cell.
FIG. 7 is a flowchart for explaining the operation of data input processing;
FIG. 8 is a diagram showing contents displayed on the display unit and input keys operated when the expression input process is executed.
FIG. 9 is a diagram showing contents displayed on the display unit and input keys operated when the expression input process is executed.
FIG. 10 is a flowchart for explaining the operation of expression input processing.
FIG. 11 is a diagram showing the contents displayed on the display unit and the processing results when the cell correspondence processing is executed.
FIG. 12 is a flowchart for explaining the operation of cell correspondence processing;
FIG. 13 is a flowchart for explaining the operation of the cell correspondence process, following FIG. 12;
FIG. 14 is a diagram showing the contents displayed on the display unit and the processing results when the plural → single conversion processing is executed.
FIG. 15 is a flowchart for explaining the operation of a plurality → single conversion process;
FIG. 16 is a diagram showing the contents displayed on the display unit and the processing results when a single-to-multiple conversion process is executed.
FIG. 17 is a flowchart for explaining the operation of single-to-multiple conversion processing;
FIG. 18 is a diagram showing the contents displayed on the display unit when the sort process is executed and the processing result.
FIG. 19 is a flowchart for explaining the sort processing operation;
FIG. 20 is a flowchart for explaining the sort processing operation following FIG. 19;
FIG. 21 is a diagram showing the contents displayed on the display unit when the nesting process is executed and the processing result.
FIG. 22 is a diagram showing the contents displayed on the display unit when the nesting process is executed and the processing result.
FIG. 23 is a diagram showing the content displayed on the display unit and the processing result when the nesting processing is executed.
FIG. 24 is a view showing the contents displayed on the display unit and the processing result when the nesting process is executed.
FIG. 25 is a flowchart for explaining the operation of nesting processing;
FIG. 26 is a diagram showing table data stored in a table data area and data stored in a statistical result data area.
FIG. 27 is a diagram showing a processing result displayed on the display unit when information display / non-display processing is executed;
28 is a view showing the data structure of the information table 26. FIG.
FIG. 29 is a flowchart for explaining the operation of statistical result display processing;
FIG. 30 is a flowchart illustrating an operation of statistical processing.
FIG. 31 is a flowchart for explaining an operation of information display / non-display processing executed by the table processing apparatus.
FIG. 32 is a diagram showing a processing result displayed on the display unit when the identification display processing is executed.
FIG. 33 is a flowchart for explaining the operation of identification display processing;
FIG. 34 is a diagram showing a processing result displayed on the display unit when the approximate value display processing is executed.
FIG. 35 is a flowchart for explaining the operation of approximate value processing;
FIG. 36 is a diagram showing a processing result displayed on the display unit when the multiple information display processing is executed.
FIG. 37 is a flowchart for explaining the operation of the multiple information display process.
FIG. 38 is a diagram showing a processing result displayed on the display unit when the priority order information setting display processing is executed.
FIG. 39 is a flowchart for explaining the operation of priority order information setting processing;
[Explanation of symbols]
1 Table processing device
11 CPU
12 Input section
13 Display section
14 Communication control unit
15 RAM
21 Work data area
22 Table data area
23 Regression calculation data area
24 Graph drawing data area
25 Statistical data area
26 Information table
16 ROM
17 External storage device
18 Storage media

Claims (13)

In a table processing apparatus that registers data in each cell constituting a table arranged in a plurality of rows and columns and performs a given operation based on the registered data,
Registration means for registering a plurality of numerical data or single numerical data for each cell;
Among the cells of the table in which numerical data is registered by the registration means, for cells in which a plurality of numerical data is registered, a cell corresponding to the plurality of numerical data is inserted, and the plurality of numerical data is inserted. Arithmetic processing means for performing a given operation on the table data that has been sorted and rearranged into the cells;
A table processing apparatus comprising: The table processing apparatus according to claim 1,
Cell magnifying display means for enlarging and displaying the size of each cell of the table in which data is registered by the registration means for a cell in which a plurality of numerical data is registered is further provided. A table processing apparatus. The table processing apparatus according to claim 1 or 2,
The registration means is a plurality of numerical data surrounded by braces “{” and “}” input by a user operation and separated by commas “,”, or input data registration means for registering single numerical data Table processing apparatus comprising: a. The table processing apparatus according to claim 1,
The calculation processing means performs, as a given calculation, a graph drawing process or a regression calculation on the rearranged table data based on the numerical data of the corresponding cells in each column. apparatus. In the table | surface processing apparatus in any one of Claims 1-3, the designation | designated means to designate a some cell,
Among the designated cell reads registered in each specified plurality of cell data by he said specifying means, to register in association with one cell, and updates the numeric data in each cell of the table further and new means,
A table processing apparatus, further comprising: 6. The table processing apparatus according to claim 5 , wherein the designating unit designates a plurality of cells based on data registered in the cells. In the table | surface processing apparatus in any one of Claims 1-6,
If multiple numerical data in any cell of said table is registered, the table processing apparatus further comprising a sorting unit for sorting the order of the multiple data. The table processing apparatus according to claim 7, wherein
Said sorting means further, when it changes the position of each cell on the basis of the data registered in each cell, this time, that a plurality of numerical data is registered in any cell, the plurality A table processing apparatus that changes an arrangement position based on data of a predetermined order among the numerical data. In the table | surface processing apparatus in any one of Claims 1-8,
First cell group designating means for designating a first cell group;
As it when a plurality of numerical data in any cell in the specified cell group that has been registered for counting the number of the plurality of numerical data, is registered in each cell of the first cell group Second cell group designating means for designating a second cell group in which the same number of data as the number of data is registered;
Execution means for executing a given process in association with each data of the first cell group and each data of the second cell group;
A table processing apparatus, further comprising: The table processing apparatus according to claim 9, wherein
Calculating means for calculating the related information of the first cell group for each cell included in the first cell group;
When displaying the first cell group, related information display means for displaying the related information of each cell included in the first cell group calculated by the calculating means in association with the corresponding cell;
A table processing apparatus, further comprising: The table processing apparatus according to claim 10, wherein
A table processing apparatus, further comprising: an identification display unit that identifies and displays a cell associated with related information according to the related information. The table processing apparatus according to claim 10 or 11,
The related information display means, when there is a plurality of related information for the cell, displays the plurality of related information in association with the cell. In a table processing device that registers data in each cell that constitutes a table arranged in a plurality of rows and columns and performs a given operation based on the registered data,
Registration means for registering a plurality of numerical data or single numerical data for each cell;
Among the cells of the table in which numerical data is registered by the registration means, for cells in which a plurality of numerical data is registered, a cell corresponding to the plurality of numerical data is inserted, and the plurality of numerical data is inserted. Arithmetic processing means for performing a given operation on the table data that has been sorted and rearranged into the cells;
Program to make it work.

Images