JPH0359764A - Table data processor - Google Patents

Abstract

PURPOSE:To simplify the setting of a numerical expression by inputting an operation result to a column corresponding to each item in which no numerical expression is set up, detecting the item setting up a numerical expression, executing operation based upon the previously set expression, and inputting the operation result to the corresponding column. CONSTITUTION:A keying part 12, an input buffer 13, an input/edition data storing part 14, a table data storage part 15, an address control part 16, an attribute data decision part 17, an operation/comparison part 18, a display data storage part 19, and a display part 20 are connected to a control part 11. When numerical expressions corresponding to respective items set up in a table are set up and data are inputted to respective items in which no numerical expressions are set up, the items setting up the expressions are detected, operation based upon the previously set expressions is executed and the operated results of the detected items are inputted. Consequently, it is unnecessary to set up numerical expressions in respective tabulation columns and the setting of numerical expression can be extremely simplified.

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Field of Application] The present invention relates to a tabular data processing device that performs arithmetic processing on input tabular data according to preset mathematical formulas.

[Conventional technology]

Conventionally, so-called electronic notebooks have been widely used as multi-functional small electronic 31-inch calculators, which have functions to memorize telephone numbers, memos, schedules, etc. in addition to reference functions.
Some of the recent electronic notebooks and word processors are equipped with a spreadsheet function. When performing spreadsheet calculations using this spreadsheet function, you can set a formula that instructs the aggregation contents in advance in each cumulative total column (cell), and then give the aggregation instructions after inputting the table data. Calculations are performed on the input data based on the calculated formulas, and the results of the calculations are written in each tally column.

[Problem to be solved by the invention] As mentioned above, conventionally, when performing spreadsheet calculations, it is necessary to set formulas that instruct the aggregation contents in all data aggregation columns in the table, and the setting operation is extremely difficult. It was a hassle.

The present invention has been made in view of the above-mentioned circumstances, and an object of the present invention is to provide a tabular data processing device in which it is extremely easy to set a mathematical formula for instructing the contents of aggregation.

[Means and effects for solving the problem] The present invention sets formulas for items set in a table, and when data is input for each item for which no formula is set, the formula is set. The system detects the items for which the above has been performed, performs calculations based on preset mathematical formulas, and inputs the results of the calculations for the detected items.

By setting a mathematical formula for an item as described above, calculation results based on the above formula are input into each summary column within that item. Therefore, it is not necessary to set a formula for each total column, and setting the formula becomes very simple.

[Example] Hereinafter, one embodiment of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing a schematic configuration of H1 when the present invention is implemented in an electronic notebook. In the figure, 11 is a control section, and this control section 11 includes a key input section 12, an input buffer 13, an input/edit data storage section 14, and a table data storage section 1.
5, an address control section 16, an attribute data judgment section 17, an arithmetic/comparison section 18, a display data storage section 19, and a display section 2o are connected.

The key input section 12 includes a numeric keypad, character keys (alphabetic keys, kana keys, etc.), a "table mode" key, an "input mode" key, an "execute" key, and a "next item/registration" key.
Various function keys are provided, including a "formula setting" key, four arithmetic operation keys, a mark key, a cursor key, a search key, and more. The data input from the key input section 12 to the control section 11 is sent to the input buffer 1 from this control section 11.
3 and one display data storage section, and the data held in this one display data storage section is displayed on the display section 20. The display section 20 is constructed using a liquid crystal display device, and is capable of displaying, for example, alphanumeric characters, one anonymous character, and kanji characters on both sides of a 12-column×3-row display.

The input/edit data storage unit 14 also stores input/edit data for one page.
F+W is performed so that the edited data can be stored, and when data editing for one page is completed, the stored data is transferred to the table data storage section 15. Writing/reading of data to/from the table data storage section 15 is executed by the address control section 16 based on instructions from the control section 11. In addition, the address control unit 16 is provided with a matchmaker address “address storage unit 16A and an upper limit address storage” ((16B), and the insertion address storage unit 16A stores insertion addresses at the time of sorting, and an upper limit address storage unit 16B. 16B stores the upper limit address when data to be sorted exists over multiple pages.

Further, the attribute data determining unit 17 determines the attributes of data input to each item in the tabulation data.

Attribute data includes "characters", "numerical formulas", and "sort"
, ``mark,''``remark,'' and ``total,'' which have the following meanings.

Character: Indicates that the data input to the item is character data.

Numerical formula: Indicates that the data entered in the item is numerical data. In this formula, arithmetic expressions and numerical values can be set.

Sort: Indicates that the data entered in that item will be sorted. For items for which this sort specification is incorrect, items located on the left side have priority over those on the right side.

Mark: Do not output the item name set for that item in display mode.

Note: In display mode, the item name set for that item and the data entered for that item are not displayed.

Cumulative total: Performs a cumulative total of formula items for which aggregation is set based on text items for which aggregation is set.

In addition, the calculation/comparison unit 18 performs calculations based on preset formulas or compares data in sort (1) in response to instructions from the control unit 11, and sends the comparison results to the control unit 11. Output to.

FIG. 2 shows the storage structure of the table data storage section 15. As shown in FIG. The table data storage section 15 is roughly divided into a table index storage area 21, an item data storage area 22, and a table data storage area 23.

Table index storage area 2] stores the table name (character code), and an end code is written between it and the next item data storage area 22.

Items A and B are stored in the item data storage area 22.

. . . and attribute data and item name (character code) are stored for each item. An end code is written in the end portion of each of these items.

In the table data storage area 23, data constituting one table is stored separately in a plurality of pages.

This table data is composed of data for each item A, B, . . . , and an end code is written between each data. In this case, each page has multiple items A, B, .
Data for one column of . . . is stored. and,
A page end code is written at the end of each page.

Although one table is shown in FIG. 2, the table data storage section 15 has a memory capacity capable of storing a plurality of tables.

Next, the processing operation at the time of tabulation in the above embodiment will be explained.

FIG. 3 shows an example of key operations during tabulation and a corresponding display example, and FIG. 4 shows an example of tabulation.

This figure 4 shows high schools in Hokkaido, Tokyo, and Osaka (7
This is a report showing the results of a mock exam in two subjects, ``English'' and ``Mathematics,'' for second-year students at the school. Additionally, Figure 4 shows the results of sorting in descending order based on the city code, with the city codes being Hokkaido as "1", Tokyo as "13", and Osaka prefecture as "26".
” is set. Further, in the table shown in FIG. 4, after the above-mentioned sorting process, a grouping process is performed for those having the same school name within the set range of this sorting. Figure 5 (a
) to (d) show the steps of the sorting process and grouping process that are performed in conjunction with data input.

When starting tabulation, first operate the "family mode key" in the key input section 12, as shown in FIG. 3(a).
Next, operate the "input mode" key. With this key operation, the control unit 11 enters the input mode in tabulation mode.

When the "execute" key is operated in this input mode, the control unit 11 outputs the guide message data "Table name?" to one display data storage unit and displays it on the display unit 20 (
Figure 3(a)). Further, the data input position is indicated by a cursor display. Following the guide message above, operate the character keys on the key input section 12 to name the table, such as "
When the "mock test result sheet" is input, this input data is sequentially stored in the input/edit data storage section 14 via the control section 11, and is also sent to the display data storage section 19 and displayed on the display section 20 ( Figure 3(b)).

After entering the name in the table above, operate the "Next Item/Register" key. By operating this key, you can enter and record parent fruit data.
The name of the table ``mock test result sheet'' is sent from the section 14 to the table data storage section 15 and written into the table index storage area 21 shown in FIG.

In addition, at this time, the control unit 11 outputs “item tJA; and registerable attribute data “remarks, sort, mark, character, formula” to the display data storage unit 19, and displays it as a guide on the display unit 20 ( Figure 3 (C)).

If, for example, "character" and "mark" are specified as attribute data in this state, the specified attribute data will be stored in the input/edit data storage section 14, and will also be displayed on the screen as "character" and "mark".
"Item A: Characters/Marks" is displayed (Figure 3 (d))
. Next, if you enter, for example, "prefecture name" as an item name, this item name is stored in the input/edit data storage section 14 and displayed on the screen below the above "Item A:". (Figure 3(e)).

After setting the attribute data and item 1 name for item 1-IA as described above, operate the ``next item 1/registration'' key. By this key operation, the control unit 11 selects the next “Item B”.
2'' is displayed on the display unit 20 together with the attribute guide data (FIG. 3(f)). Below, use the same operation to change the "Item name"
and its "attributes" are set sequentially. In this case, “Item E
:” is the grade setting as shown in the table in Figure 4, so
Input "grade" as the item name and specify "mathematical formula" as the attribute (Fig. 3 (g), (h)), then operate the "formula setting" key. When this "formula setting" key is operated, the control section 11 displays "grade" as the item name on the display section 20.
is displayed as well as "Formula:" (see Figure 3 (
i)). Following this guide display, the student enters the number of grades, for example, "2" for the second grade (Fig. 3 (j)). With the above operations, the 2nd grade can enter and edit data storage part 1 as a mathematical formula.
Written to 4.

After that, in the same way, for "Item F:" the attribute "Formula"
and set the item name “English”, and also set “Item 1: I G
: Set the attribute "mathematical formula" and the item name "mathematics" for J. In this case, the attribute of “Item F:” and “Item G:” is “
"Numerical formula" indicates that the data input to this item is numerical data, so it is not necessary to set an arithmetic formula. Next, the attribute "Formula" and the item name "Total" are set for "Item H;", but in this case, "Formula" is "
Since it is the sum of "item F" and "item G," after operating the "formula setting key," use the character keys and calculation keys to rF+GJ.
Set the calculation formula (Fig. 3 (k), (R)).

After setting the "item name" and "formula" for all items A to H as described above, the "execute" key is operated. When this "execute" key is operated, the control section 11 displays "item names" and "formulas" for all items A to H stored in the input/edit data storage section 14, details of which are shown in FIG. It is transferred to the table data storage section 15 and stored and set in the item data storage area 22.

Thereafter, the control section 11 executes data input processing to the table data storage area 23 of the table data storage section 15 according to the flowchart of FIG. The control unit 11 first specifies the address of the first item in the item data storage area 22 (step AI), and reads out the attribute data “character/mark” in that item to the attribute data determination unit 17 (step A2).
). The attribute data judgment unit 17 determines whether the input attribute data is a mathematical formula or a character. IJ cutting (step A3
), if it is a character, the process proceeds to step A4, and if it is a mathematical expression, the process proceeds to step A5. In this case, since the attribute data in the preceding item is "character/mark", the process proceeds to step A4, reads out the item name to the display data storage section 19, and displays the item name on the display section 2.
"Prefecture name?" is displayed at 0 to guide data entry of the location of the high school (Fig. 3 (m)). The control unit 11 is in a standby state until a key input is made (step A).
6). The user inputs the name of the prefecture where the school is located on the display unit 20 according to the guide display of "Prefecture name?". Now, for example, as shown in Figure 5(a), the grades of students at "Tokyo High School" located in "Tokyo" are input.
First, when "Tokyo" is input as the prefecture name, the content of the key input is determined in step A7. If any data has been input, the process advances to step A8, and after writing the input data to the power buffer 713, the process returns to step A6. While data is still being input, step A3
- The operation of A3 is repeated 5, and the input data is stored in the input buffer 13. After inputting the data for "Tokyo", press the "Next entry/registration" key, and step A
7, the content of the key operation is determined, and the process proceeds to step A9, where the input data stored in the input buffer 13 is
;('' is transferred to the input/edit data storage unit 14.Then, the process advances to step A25, where the presence or absence of the "next item opening" is checked. If there is a next item opening, its address is specified in step A2G, and the process goes to step A2. Return.In addition, in data input from the second page onward, if you want to perform simple data input using already registered data, operate the cursor keys in the state of waiting for key input in step A6. By pressing the cursor key, proceed from step A7 to step All, and then proceed to step A11l.
Through the processing up to l, processing for simple data input is executed, the details of which will be described later.

Thereafter, similar key input operations and processing operations are repeated, and as shown in FIG. The student's name "Yamashita Nibu" is sequentially set in "Item D". Next, when setting the grade in "Item E", when the attribute data is read out, this attribute data is a "mathematical formula", so the process proceeds from step A3 to step A5, and whether it is a mathematical formula (numeric value or arithmetic formula) is set. It is determined whether the If the formula has not been set, the process advances to step A4; if the formula has been set, the process advances to step A19.

Since a mathematical formula is set in the above "item E", it is determined in step AI9 whether the mathematical formula is an arithmetic formula or a numerical value. In this case, since the content of the formula for "item E" is a numerical value, the process advances to step A20. This step A2
0, the item name "grade" and "number 1it!2J" for "item E" are read out from the table data storage section 15 into one display data storage section, and "grade?" and the numerical value are read as shown in FIG. 3 (0). "2" is displayed on the display section 20, and then step A2
1, enter the above numerical value "2" and edit data storage section 1
Transfer to 4. In this state, the process waits until the "next item 1-1/registration" key is operated (step A22).

Since there is no need to change the display of the numerical value "2" indicating the number of grades, the user simply operates the "Next Item 1; 1/Registration" key. When the control unit 11 detects that the ``next item g/f2 record j key'' is operated (step A22),
Check whether there is a next entry (step A25)
. At this point, there is still the next entry, so step A2
13 and returns to step A2, where the English score is "90" for "Item F" and the math score is "7" for "Item G".
5". In this case, the process is step A3-A
5→A4→A11i-A7→A8-Alt.

Thereafter, processing for "item H" is performed.

In the second item HJ, the calculation formula rF+GJ is set as the formula, so step A19 to step AI
3, the calculation process rF+G-90+75-165J is performed, and the calculation result is stored in the input/edit data storage section 14 (step A24). Below, in the same way, for the input data from page 2 onwards, "
In "Item H", the composition formula rF+ set as P
Arithmetic processing is performed based on GJ. That is, the arithmetic processing is executed without setting a formula for each column (page) of "Item H".

Then, when the processing fψ for the last term r, JH is completed, it is determined in step A25 that the next term is [1 or absent, and the process proceeds to step A27, where the process is held in the input/deception data storage unit 14. The data stored in the tabular data storage section 15 is written into the tabular data storage section 15. Then, display processing is performed based on the data stored in the tabular data storage section 15.

This display processing is performed according to the flowchart shown in FIG. First, in step B1), specify the address of the first item A of the page that has just been inputted to the table data storage unit 15, and output the attribute data to the attribute data judgment unit 17 to determine whether it is a "remarks" or not. (Step B2)
．． B3). If the attribute data is not "remarks", it is further determined whether "mark" is specified (step B4
).

If "mark" is not specified, the item name is output to one display data storage section (step B5), and then the specified item data (table data storage area 23) is addressed (step Be). If "mark" is specified, the process of step B6 is executed without performing the process of step B5. In this example, since "mark" is specified, the process of step B6 is executed without transferring the item name "prefecture name" to one display pig storage section. That is, if "mark" is set as an attribute, the item name set for that item is not displayed. Next, the designated item data "Tokyo" is read from the table data storage section 15 and output to one display data storage section. After that, determine whether there is a next item or not (step B8),
If there is 1 in the next item, the address of the next item 11 is designated and the process returns to step B2.

Since "remarks" is set as attribute data in item B, the determination result in step B3 is Yes. In this case, steps 84 to B7 are not performed and the process immediately proceeds to step B8.

That is, when "remarks" is set as attribute data, the item name set for that item and the data input for that item are not displayed.

Thereafter, processing up to item H is performed in the same manner, and the item name and data are transferred to one display data storage section. and,
When all the items have been processed, the display unit 20 is driven based on the contents stored in the display data storage unit 19. In this case, since the display capacity of the display section 20 is small and all the data stored in the display data storage section 19 cannot be displayed at once, first,
As shown in FIG. 3(p), the prefecture name, school name, name, and grade are displayed. In this state, when you operate the cursor key to indicate the next item, the item name ``English'' and table data ``90'' of ``item F'' are read out from one display data storage section and displayed (see Figure 3 (q). )). Further, by operating the cursor key, the item name of "Item G" is retrieved from the table data storage section 15.
Mathematics” and table data “75” and item name of “Item H” “
"Total" and table data rl 65J indicating the total value are read out and displayed (FIG. 3(r)).

As described above, data input is performed according to the flowchart shown in FIG. 6, and the input data is temporarily stored in the input/edit data storage section 14.

When data input for one page is completed, that is, when data up to the last item H is input, the data temporarily stored in the input/edit data storage section 14 is transferred to step A27 in FIG. It is registered in the table data storage section 15. This data registration process from the input/edit data storage unit 14 to the table data storage unit 15 is performed according to the flowchart shown in FIG.
As shown in FIGS. (a) to (d), sorting processing and grouping processing by school name are performed.

The registration process for the table data storage section 15 will be described below with reference to the flowchart in FIG. In this registration process, first, the final address of the table data storage area 23 in the table data storage section 15 is set in the push address storage section 16A in the address control section 16 (step CI).
At the same time, the start address of the table data storage area 23 is set in the address storage section 16B (step C2).

Next, specify the address of the first item A and read the attribute data to the attribute data judgment unit 17 in steps C3 and C4.
), i11 determines whether there is a sort specification (step C5)
. Since there is no sort specification for item A, in this case, the address for next item B is specified after passing through step C6 in which it is determined whether the next item is empty (step C7).

Then, the attribute data of the next entry B is read out to the attribute data determining unit 17 to determine whether or not sorting is specified.Step C
4, C5), if there is a sort specification, proceed to step C8.

Since sorting is specified as the attribute data of item B, in step C8, input/edit data storage unit 1
4 reads the table data of the specified item and calculates and compares the data
Output to. Now, if you want to register the input data of 1 page 1 shown in Figure 5(a), the city code is 13.
is input to the calculation/comparison section 18.

In this state, it is determined in step C9 whether there is a previous page for the suppression address, but since there is no previous page at the time of registration of 1st page, the specified page final address, that is, the address indicating 1st page, is the upper limit address storage unit 16.
Set to B.

After that, return to step C7 via step C6,
The next entry address is specified. From item C onwards,
Since there is no sort specification, the process directly advances from step C5 to step CG. Hereinafter, the calculations for each item will be performed in the same manner.

Then, when the processing for all entries is completed, step C
6 to step C16, the first item address of the day and night to be registered is specified, and the attribute data is read out to the attribute data judgment unit 17, and it is judged whether the attribute code is "character" (step C17, C1g). First item A
Since "sentence'r" is set as the attribute code,
In this case, it is further determined whether there is a sort specification, and if there is no sort specification, input 1. The tabular data of the specified item is read from the J collection data storage section 14 to the calculation/comparison section 18 (step C20). Next, it is determined whether the previous page is blank or not for the extracted address (step C21), and if there is a previous page, the process proceeds to step C22; if there is no previous page, step C2)
Proceed to step 7. Since there is no previous page when the first page is registered, the process advances to step C27 and the next item [rl-none of data 1' is rejected. If there is F1 data in the next section, please refer to the next section [
The address of I is specified (step C29), the attribute data is read out to the attribute data determining section 17, and it is determined whether "character" is set (steps C17, C1g).

Since "character" is not set as the attribute data of item B, G-absence of the data before the next item is immediately checked in step C27.

If it is determined in step C27 that there is no data for the next item I' It is registered on page 1 of the data storage section 15. Through the above processing, the input data shown in FIG. 5(a) is registered in the tabular data storage section 15 (step 0
28).

Next, with the data shown in FIG. 5(a) set in the tabular data storage section 15, if data for Hokuma High School in Hokkaido is entered on the second page, the following registration process will be performed.

In steps 01 to C7, the same processing as in the case of registering one page of data is performed, and when the attribute data of item B is read out, it is determined in step C5 that sorting is specified, and the process proceeds to step C8.

In this step C8, the Hokkaido city code “1
" is read out and input to the calculation/comparison section 18.

In this state, it is determined whether the previous page is empty or not for the push-in address (step C9), but if there is a previous page when registering the second page, the process proceeds to step CIO and the previous page address is set as the upper limit address. It is determined whether the address is greater than or equal to the address stored in the storage unit 16B. This decision is no
In the case of YES, the process proceeds to step C15, and in the case of YES, the process proceeds to step C1l. When registering the second page, the previous page address and the address stored in the upper limit address storage section 16B are the same, so the step CIO
If the judgment result is YES, proceed to step C1l, address the table data of the specified item on the previous page, and input the table data of specified item B, that is, the city code "13" to the calculation/comparison section 18. , the magnitude relationship is compared with the above input data. If the input data is larger than the table data, the process advances to step CI5; if the input data is smaller than the table data, the process advances to step CI4; if the input data and the table data are equal, the process returns to step C9. In this case, since the input data "1" is smaller than the table data "13", the process advances to step CI4 to store the start address of the designated page in the pressed address storage section 16A, and then returns to step C9. When returning from step CI3°C14 to step C9, the page designation address is incremented by "-1" and the processes from step C9 onwards are repeated. That is,
If the tabular data storage section 15 already stores the pages of the number of bells, the above steps C9 to C14 are repeated, and the sorting process is performed by rewriting the data in the t1j person address storage section 16A. Further, after the specified page start address set in the push-in address storage section 16A is determined by the above sorting process, if the same city code as the sorted city code has already been registered, steps C9 to C13 are further performed. The above process is repeated to obtain the address of the highest page of the same city code and set it in the upper limit address storage section 16B. That is, in the processing of steps 09 to C13, 'I'11 indicates that the processing of up to one page has been completed in step C9.
If it is determined that the address stored in the upper limit address storage unit 16B is greater than the previous page address by step CIO, if it is determined that the table data is smaller than the input data by step C13. Then, the address of the highest page of the same city code is determined and written to the upper limit address storage section 16B (step C).
15).

Thereafter, the process for the next item is executed through steps C6 and C7.

When the processing for [all items 1] is completed, the process proceeds from step C6 to step C1B, where the first item address of the data to be registered is specified, the attribute data is read out to the attribute data judgment unit 17, and the attribute code is "character". I'11 determines whether or not (step C17, Cl11). Since the first item A has "character" set as the attribute code, in this case, it is determined whether the sort specification is -a or not, and
If there is no sort specification, the table data of the specified item]-1 is read out from the input/edit data storage unit 14 to the settlement/comparison unit 18 (step C20). Next, it is determined whether or not there is a previous page for the inserted address (step C21). If there is a previous page, the process proceeds to step C22; if there is no previous page, the process proceeds to step C27. This ■! Since the entry address is page 1 at point , it is determined that there is no previous page, and the process proceeds to step C27, where it is determined whether or not there is next page data.

If there is "next item l" data, specify the address of the next item, in this case, the address of item B (step C29), read the attribute data to the attribute data ill cutter 17, and read the attribute data to the attribute data ill cutter 17.
It is determined at t++ whether "character" is set (steps C17, CI8). The attribute data of term D B is:
Since "Character" is not set, immediately step C2
At step 7, the presence or absence of next entry data is checked.

After that, the address of the next port C is specified (step C2
9), the attribute data "F character/mark" is read out to the attribute data determining section 17, and the presence or absence of the attribute data "character" is checked (steps CI8, Cl9), and then the presence or absence of sort designation is checked. Thereafter, the contents of each item are checked in the same way, but no special processing is performed if the attribute data is not "character" or if the attribute data is "character" but there is no sort specification. Proceed to check the next item. Then, a specific process is performed for an item whose attribute data is "character" and there is no sorting specification, but in the example of FIG. Since the connection is disconnected, no specific processing is performed. Then, in step C27, if the next item [1 data is not found, t, 11 is rejected, the input data held in the input/edit data storage section 14 is stored as table data according to the input address stored in the matchmaker address storage section 16A. Register in section 15. Therefore, Fig. 5(a)
As shown in page 1, if you enter data about Tokyo High School in Tokyo and then enter data about Hokuma High School in Hokkaido, sorting will be performed according to the city code, and the data will be stored in the table data storage unit 15. As shown in FIG. 5(b), data for Hokuma High School is registered on the first page and data for Tokyo High School on the second page (step C28).

Next, when the data of Kita High School in Hokkaido is input, the above-mentioned input processing and registration processing are performed, and the city code (from Kogoetsu Sort 1), table data 11 memory section 15 is shown in Figure 5 (
As shown in c), data for Hokuma High School in Hokkaido is registered on page 1, data for Kita High School in Hokkaido is registered on page 2, and data for Tokyo High School in Tokyo is registered on page 3.

Next, when you input the data of Hokuma High School in Hokkaido, the input processing and registration office Pl! was carried out, as shown in Figure 5(d)
), by sorting based on the city code, Hokuma High School in Hokkaido is ranked higher than Tokyo High School in Tokyo.
In addition to being recorded in the history, there is no sort specification in the history, and the attribute data "character" is specified. High schools with the same name are grouped together and registered higher than Hokkaido's Kitatakabite. Furthermore, if there are /7 students with the same name in the same high school, grouping processing is performed within that range.

In other words, if the data of Hokuma High School in Hokkaido is entered in the 4th page [1], if item C is specified after completing the sorting process in the registration process of FIG. 8, step C2
0, the table data "Hokuma High School" is input to the calculation/comparison section 18. Next, in step C21, it is checked whether the previous page (page 2) corresponding to the designated address has G or not, or in this case, it is determined that there is a previous page, and the process proceeds to step C22. In this step C22, it is determined whether or not the previous page address is greater than or equal to the address stored in the upper limit address storage section 16B. In step C23), input the table data of designation type III on the previous page, ``Kita 1α School'', into the calculation/comparison section 18, and input the above input data ``Kita-Minami High School''. Compare and determine whether they are the same (step C25). In this case, since there is no match, the process returns to step C2+. At this time, the page specified address is set to "-1", and step C
In 2+, the page before this page specified address (
1 page) is checked, and it is compared whether this 1 page has an address greater than or equal to the address stored in the upper limit address storage section 16B (step C22). At this time, the upper limit address storage unit 16B stores an address for one page, so the answer to step C22 is YES, and step C23 proceeds to item 1-I.
One page of C is specified, and its tabular data "Kitanan High School" is read out to the calculation/comparison section 18 (step C24), and compared with the input data "Kitanan High School" by a negative number (step C25).
). As a result, a coincidence signal is output from the calculation/comparison section 18, and the final address of the designated page (page 2) is written into the 11F person address storage section 16A in step C2G. Furthermore, the start address of the designated page is written into the upper limit address storage section 16B (step C35). The grouping process for the same school name is performed as described above.

Thereafter, in step C30, the presence or absence of the previous page (1 page) for the specified address is checked, but in this case, it is determined that there is a previous page, and step C30 is performed.
Proceed to step 31. In step C31, it is determined whether the previous page address is greater than or equal to the address stored in the upper limit address storage section 16B, that is, it is determined whether or not it is within the sorting range of Kitanan High School, and if it is within the range, the previous page address is determined. Address the table data of the specified item on the page Step C32), calculate and compare the table data of specified class 11 C, "Hokkai Convex School"
8. Step C33) Compare 111 to determine whether it is the same as the input data "Kokunan High School" or a cup (Step C33).
34). If they match, 5'Q D of the specified page
n address or is written in upper limit address register t8 section 16B (
Step C35), and then warping to step C30.

At this time, the page designation address is set to "-1" and the operations from step C30 onwards are repeated. As a result, the top address of the specified page with the same high school name is the upper limit address storage unit 1.
It is set to 6B.

Then, if it is determined in step C30 that there is no previous page, and if it is determined No in steps C31 and C34, the process returns to step C27 to check whether there is next page data, and in step C29, the next page is specified. . Furthermore, steps C17 and C1g.

Proceeding to step C20 via C19, the grouping process for student names is performed in the same manner as in the case of school names.

Thereafter, in step C27, if it is determined that there is no data for the next item, the process proceeds to step C2g, where the data stored in the input/collection data storage section 14 is sent to the table data storage section 15, and the stored data is stored in the Jr. address storage section 16A. The data is written to the table data storage area 23 according to the address.

Therefore, when inputting the above data, data already registered in the table data storage section 15 can be used. For example, after completing data entry for up to 4 pages,
When inputting data for "Nishitokyo Gakuen" in "Tokyo" on page 1, if the "execute" key is operated after data entry for the fourth page is completed, the input processing operation shown in the flowchart of FIG. 6 is performed. First, the address of the first [A] is specified (step AI), and then the attribute data is read out to the attribute data determination section 17 (step A2).

Next, proceed to step A3, step A4, and enter the item name "
"Prefecture name" is read out to the display data storage section 19, and "Prefecture name?" is displayed on the display section 20 (FIG. 3(s)).
, enters a state of waiting for key input (step A6). If a cursor key is operated in this state, the operation of this cursor key is determined in step A7, and the process proceeds to step All. In this step All, the table address of specified item A on the first page is specified, and the absence of V-T of the data is checked (
However, since data is stored in item A of the first page, the stored data "Hokkaido" is read out to the input buffer 13 and the display data storage section 19 (steps A13 and A14), and the display section 20 (Fig. 3(t)). In addition, if there is no data in step A12 above? II ItLr, the display data of "Not applicable" is the display data, ;C! The data is sent to the storage section 19 and displayed on the display section 20 (step A15). Then, it waits in the above display state until the next key input is performed (step A18).

When the above "Hokkaido" is displayed on the display section 20, if this displayed data is the data you want to input, press the "Next item 1/Register" key, or if it is 5' from the data you want to input, press the cursor key. If it is an operation error, operate the "release" key. The content of these key operations is determined in step AI7, and if the "next entry/registration" key is pressed 1-ψ, step A9 is performed, and if the cursor key is pressed (-k, step A18 is performed, If the "touch/remove" key is operated, the process returns to step A6 and the next key input is completed.In step A1g, the specified item 11 of the next page or previous page is selected depending on the cursor key operation. Specifies the table data address.In other words, when the cursor key △ indicating the upward direction is operated, the table data address for the specified item on the previous page is specified, and when the cursor key indicating the downward direction is operated tX, the table data address is specified for the specified item on the previous page. Specify the table data address for the specified item on the next page.In this example, you want to input "Tokyo", so operate the cursor keys.This specifies the table data address for the specified item on the next page, and then step A12 The following process is repeated and the prefecture name "Hokkaido" on page 2 is displayed on the display unit 20. Thereafter, by operating the cursor key twice, the prefecture name stored on page 4 is displayed. The prefecture name "Tokyo" is read into the input buffer 13 and the display data storage section 19, and displayed on the display section 20 (third if
l(u)).

In this state, when the "Next entry/registration" key is pressed 1/ψ, the data "Tokyo" held in the input buffer 13 is transferred to the input/cotton seed data storage section 14 (step A9).
. This completes the data input for the prefecture name "Tokyo".

Then, step A25-A2G-A2-A3-A5-
As a result of the process in A4, the item "1 person F city code" of the next item DB is placed in one display data record section ta, and "city code?" is displayed on the display section 20 to guide the next input (third Figure (V)). If the same data as the data to be input is already registered as described above, the registered data can be used to input the data.

[Effects of the Invention] As detailed above, according to the present invention, formulas are set for items that have been determined for the first time in the table, and data are entered in the columns for formula 1 for each item that has not been determined. When you input the formula, the term [] for which the formula has been set is compared to the preset formula to perform a calculation, and the result of the calculation is entered in the column for the detected item. So,
By simply setting a formula for calculating χ·J in the term [1, you can enter the antagonism of the operation in each total column, making setting the formula as simple as 1i.

4, Fig. dtj is a simple explanatory diagram of fj showing one embodiment of the present invention. Fig. 1 is a block diagram showing a four-way configuration, and Fig. 2 is a storage diagram of the tabular data storage unit in Fig. 1. Figure 3 is a diagram showing the correspondence between key input operation examples and display contents. Figure 4 is a diagram showing an example of table creation. Figures 5 (a) to (d) are table data input. 6 is a flowchart showing the input processing, FIG. 7 is a flowchart showing details of the display processing, and FIG. 8 is a flowchart showing details of the registration processing.

11...Control unit, 12...Key input unit, 13...
Input buffer, 14... Input/cotton seed data storage section, 1
5...Table data storage unit, 16...Address control unit,
16a... Insert address storage unit, 16b... Upper address storage unit, 17... Attribute data determination unit, 18...
- Clearing/comparison section, 19...Display data storage section, 20.
...Display section, 21...Table index storage area, 2
2... Item ro data, τ self-memory area, 23... Table data 5 self-memory area.

Claims (1)

[Claims] Means for setting one or more items; A formula setting means for setting a formula for any of the items set by this means; For each item for which no formula has been set. means for inputting data; detection means for detecting items for which formulas have been set by the formula setting means; means for performing calculations based on the set formulas; and calculations for the items detected by the detection means. 1. A tabular data processing device, comprising: means for inputting results.