JPH0359767A - Table data processor - Google Patents

Abstract

PURPOSE:To easily execute operation processing by substituting data inputted to an item set up as a variable based upon an operation expression at the time of inputting data to an item in which the operation expression is not set up to the expression, and when there are no data in the item set up as the variable, executing other operation and then executing the operation expression again. CONSTITUTION:A keying part 12, an input buffer 13, an input/edition data storage part 14, a table data storage part 15, an address control part 16, an operation data storage part 21, 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 data are inputted to an item in which operation expression is not set up, data inputted to the item set up as a variable are substituted to the operation expression and the operation expression is executed, and when there are no data in the item set up as the variable, the operation is executed again after executing other operation and the operated result is processed as the input data of the item setting up the operation expression. Consequently, operation processing can easily be executed without considering the arrangement of items and the order of operation.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a tabular data processing device having a tabulation function for input tabular data.

C. Prior Art] A conventional tabular data processing device is provided with a function of performing settlement using data input into each item (cell).

The above calculation is performed according to an operator's designation after inputting data for one row, after inputting data for one column, or after inputting all data.

Furthermore, when performing eL calculation after inputting all data, there is a method that allows you to specify that the calculation be performed from the top in the row direction and from the left in the column direction.

Problems to be Solved by the Invention] As mentioned above, in the conventional tabular data processing device, calculations are performed using data input to one item.
71 is possible. However, in conventional tabular data processing devices, when an item into which a calculation result is input in an arithmetic expression is set as a variable, after the calculation result is input to that item in 1,
It is necessary to consider in advance the arrangement of items or the order of calculations so that the calculations for the above calculation formulas are performed.

Further, even if the above considerations are taken, the calculation may not be possible depending on the calculation formula.

The present invention has been made in view of the above-mentioned circumstances, and even when an item into which a calculation result is input in an arithmetic expression is set as a variable, it can be used without considering the arrangement of the items or the order of a''!5!5. An object of the present invention is to provide a table data processing device that can perform arithmetic processing.

[Means and effects for solving the problem] The present invention provides a means for setting items and an arithmetic expression setting means for setting an arithmetic expression for one item set by this means using other items as variables. When data is input to an item for which no calculation formula has been set, the input data is assigned to the item set as a variable based on the calculation formula above, and the calculation is performed, and the calculation is performed as the above variable. If there is no data for the set item, the calculation is performed again after performing other calculations, and the calculation result is processed as input data for the calculation formula setting item.

With the above configuration, calculations are performed based on data input, and if there is no data in an item set as a variable, the calculation is performed again after performing another calculation. Therefore, even if the calculation is impossible in the first processing, there is a very high probability that the calculation will become possible in the subsequent processing. can be executed.

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

FIG. 1 is a block diagram showing the overall schematic configuration. 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/collection data storage section 14, a table data storage section 15, an address control section 16, and a calculation data storage section 21. , attribute data 1' section 17, calculation/
A comparison section 18, a display data storage section 19, and a display section 20 are connected.

Further, an address register 22 is connected to the address control section 16.

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.
"Formula setting" key "Search" key, 4 J1+JeL calculation keys Cursor key "Insert" key "Move" key "Delete" key Other various function keys are provided. Data input from the key input section 12 to the control section 11 is sent from the control section 11 to an input buffer 13 and one display data storage section, and the data held in the display data storage section 19 is displayed on the display section 20. be done. This display unit 20 is configured using a liquid crystal display device, and for example, displays 12
Digit X3? Alphanumeric characters, kana characters, and kanji characters can be displayed on the display screen.

The address control section 16 controls the addresses of the input/g collection data storage section 14 , the calculation data storage section 21 , and the table data storage section 15 based on the address data stored in the address register 22 in response to instructions from the control section 11 . Let's do it.

The address register 22 is an insertion address memory f12.
3a, the upper limit address storage section 23b, the cumulative start address storage section 23c, and the calculation page address storage section 23d.
77, the input address for sorting is stored in the input address storage section 23a, and the upper limit address is stored in the upper limit address storage section 23b when the data to be sorted exists over multiple pages. is memorized. The input/collection data storage section 14 is configured to be able to store input/collection data for one page, and when editing of data for one page is completed, the stored data is transferred to the table data storage section. Output to 15.

Based on instructions from the control unit 11, the calculation/comparison unit 18 performs calculations based on preset mathematical formulas or compares data during sorting, and outputs the comparison results to control #11.

The calculation data of II and It are stored in the calculation data storage section 21.
is memorized. The calculation data storage unit 21 is provided with an uncalculated flag counter 21a, a total page counter 21b, a total code counter 21c, and the like.

The attribute data "F+1 cutting section 17 cuts off the attributes of the data input to each item in the table data, and outputs the judgment result to the control section 11. The attribute data includes "character", " There are ``formula'', ``sort'', and ``cumulative 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. In the items for which this sorting is specified, the items located on the left side are given priority over the items on the iT side.

Collection 51': Summarizes the formula items for which the cumulative total has been set based on the character items for which the summation has been set.

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 5 storage area 31, an item data S storage area 32, and a table data storage area 33.

The table index storage area 31 stores the table name (character code), and an end code is written between it and the next item data storage area 32.

The data storage area 32 contains items A and B.

. . . 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 33, the data that makes up one table is stored separately in a plurality of pages, and the input data for each page is stored. C! A storage section 33a and a total data storage section 3 that stores sum=1 data.
It consists of 3b. The input data storage unit 33a stores data for each item A, B,..., and an end code is written between each item, and a page end code is written at the end of each page. . The total data storage unit 33b stores: 1 page identification code, total χ, 1
The item 1-1 flag is used to store aggregated data for each item, and when an end code is written between each item,
A page end code is written at the end of the page.

Although one table is shown in FIG. 2 above, the table data storage unit 15 has a memory capacity (-+
'are doing.

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 the sales results of the 1st and 2nd divisions of a certain company.
Teen Fl! Store name J, rEE attached, rA product sales,""B product sales,""sales ratio by person in charge," and "overall sales ratio" are set, as well as "text/sort/tally" as attributes for items A and B. The attribute of item C is "Character/Sort",
"Formula/Tally" is set as the attribute of H, and "Formula" is set as the attribute of items F and G. Furthermore, set the formula (D+E)/i total (total (D)) ten total (total (E)) 1 for the "formula" of item F, and set the formula (D+E) for the "formula" of item G.
) / 1 total [total (combined 1 (D))] 10 [total (total (
Set the calculation formula for the total (E)).

Further, FIG. 4 shows the results of sorting on "person in charge" and "agency name J, with rlE". In this sorting process, priority is given to the item on the left among the items to be sorted, and the next priority item is sorted within the prioritized sorting range. Figure 5 (a
) to (d) show the process of the above-mentioned sorting process that is performed along with data input.

Details of tabulation processing will be explained below with reference to FIGS. 3 to 5.

When starting tabulation, first operate the "table mode key" in the key input section 12, as shown in FIG. 3(a).
Next, set the "input mode" key to 1. 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 sends the guide message data "Table name?"
is output to one display button storage section and displayed on the display section 20 (FIG. 3(a)). Further, the data input position is indicated by a cursor display. When the name of the table, for example "sales results" is entered by operating the character keys of the key input section 12 in accordance with the above guide message, this input data is stored in the input buffer 13 and then input/collected via the control section 11. The data is stored in the data storage section 14, and is also sent to the display data storage section 19 and displayed on the display section 20.

After entering the name in the table above, operate the "Next Item/Register" key. By this key operation, the name of the table "Sales Results" is sent from the input/edit data storage section 14 to the table data storage section 15, and written into the table index storage area 31 shown in FIG. In addition, at this time, the control unit 11 controls “Term II
A: Outputs J and the registered attribute data "characters, mathematical formulas, sorting, fruit juice," to the display data storage section 19,
A guide is displayed on the display unit 20 (FIG. 3(b)). In this state, if you specify, for example, "character", "sort", or "total" as attribute data, the specified attribute data will be stored in the input/striped data storage section 14, and then "Item A" will be displayed on the screen. :Character/Sort/Total” (3rd page)
Figure (C)). Next, if you input, for example, "in charge" as an item name, this item name is stored in the input/edit data storage unit 14 and displayed on the screen below the above "item A:" (see Figure 3). (d)).

Attribute data and terms for item A]]
After setting the name, operate the "Next item/Register" key. Controlled by this key operation? Part 8 11 contains the following “Section 11B:
J is displayed as a guide on the display unit 20 together with registerable attribute data (FIG. 3(e)). Below, by the same operation,
``Item name'' and its ``attribute'' are set sequentially.

Then, on the input screen for "Section 171 FJ" shown in Figure 3(f), if you enter "Sales ratio by person in charge" as the item name and specify "Formula" as the attribute, the input state will change as shown in Figure 3(f). The screen is displayed as shown in g). Next, after operating the "formula setting" key, set the calculation formula %expression%()))). Also, Section 1 1. Similarly, for lGJ, "mathematical formula" is designated as the attribute, and the calculation formula % formula % ()] + [total (total (total 5l - (E))) is set.

After setting the "item name" and "attribute" for all entries of A to G as described above, the "execute" key is operated. When this "execute" key is operated, the control unit 11 inputs all the terms of A to G stored in the input/master fruit data storage unit 14 and the "term l" name and "attribute data" for 1. The table data is transferred to the table data storage section 15 whose details are shown in FIG.

Thereafter, the control unit 11 executes data input processing to the table data storage area 33 of the table data storage unit 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 32 (step AI), and reads out the attribute data “character, sort, total” in that item to the attribute data determination unit 17 (step A2). . The attribute data determining unit 17 determines whether the input attribute data is a mathematical formula or a character (step A3). If it is a character, the process proceeds to step A4; if it is a mathematical formula, the process proceeds to step A5. In this case, since "character" has been added to the attribute data for the first item, the process proceeds to step A4 and the name of item 11 is displayed in the display data record t5. section 19, and displays "In charge?" as a guide on the display section 2o (third
Figure (j)).

The control unit 11 is in a standby state until a key input is made (step AG).

The user inputs the person in charge according to the guide display on the display unit 20. Now, for example, as shown in Figure 5(a), we are inputting the sales of "Product A" and "Product B" in "January 1989" to "C Electric Machinery", which "Second Section" is in charge of. First, when "Second Section" is input as the person in charge, the content of the key input is determined in step A7. If data has been input, the process advances to step A8, and after writing the input data to the input buffer 13, the process returns to step A6. While data continues to be input, steps A4 and 8 are repeated, and the input data is stored in the input buffer 13.
is stored in Then, after inputting the data for Section 2, press the "Next item F4/Register" key to proceed to step A.
7, the content of the key operation is determined, and the process proceeds to step A9, where the input data "Section 2" stored in the input buffer 13 is transferred to the input/edit data storage section 14. Thereafter, the process advances to step A25 to check whether there is a "next item", and if there is a "next item l", its address is specified in step A2B and the process returns to step A2. And step A
3, the process proceeds to step A4, where "Agency name" is read out from the tabular data storage section 15 to one display data storage section as the item name of the item 1'DB, and is displayed on the display section 20 (see FIG. 3(j). )). Please note that when entering data from page 2 onwards,
When performing simple data input using already registered data, the cursor key is operated in the state of waiting for key input in step A6. By operating this cursor key, the process advances from step A7 to step All, and the process for simple data input is executed through the process up to step A1g.

Thereafter, similar key input operations and processing operations are repeated, with the agency name "C Denki" in item B and the date r89 in item FJC. I
J is set. Next, when setting "A product sales" in the item list, when the attribute data is read out, this attribute data is a "mathematical formula", so steps A3 to A are performed.
Proceed to step 5, and ↑11 is determined whether a mathematical expression (numeric value or arithmetic expression) has been set. 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. Item 1': Since no mathematical formula is set for ID, the sales data r300J of product A is input in the processing from step A4 onwards. Further, sales data rllOJ of product B is inputted to item E in the same manner.

Note that if a numerical value is set as a formula, the item name and numerical value are stored in the table data storage unit 15.
are read out to one display data storage unit and displayed on the screen, and the numerical value is written to the input/edit data storage unit 14 (step Δ20A21>. In this state, until the "Next Item/Registration" key is operated) Waiting step A22),
When the "Next Item Entrance/Registration" key is operated, step A25
The next step is checked to see if there is a next entry.

Since formulas are set for the terms r: IF and G, the process proceeds from step A19 to step A23, where arithmetic processing I is executed. Details of this calculation process 1 will be described later, but since the sum=1 process has not been performed when one page is input, no calculation is performed and an "uncalculated code" is registered.

Then, when the processing for the last "item G" is finished,
In step A25, it is determined that there is no next item, and the process proceeds to step A27, where the data held in the input/edit data storage section 14 is written into the table data storage section 15. After that, total page creation processing (step A2
8) and arithmetic processing 2 (step A29) are executed, and when the processing is completed, display processing (step A30) is performed based on the data stored in the table data storage section 15.

In this display process, the tabular data storage unit 15 has the following information:
Data etc. are transferred to the display data storage section 19. 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 2o is small and all the data stored in one display data storage section cannot be displayed at once, three lines of data are first displayed as shown in FIG. 3(k). do. In this state, when the cursor key indicating the next item is operated, the next data is read out from the display data storage section 19 and displayed (FIG. 3(g)).

Also, if you want to display the next page of data, operate the "Next Page" key. By this "next page" operation, the data of the next page from the table data storage section 15, that is, the total data of "C Denki", which is the Dairanuki store in section 2 in this case, is read out to one display data storage section. , is displayed on the display unit 20 (Fig. m3 (m)). In this state, press the cursor key
- When the data is created again, the continuation of the total data for "C Electric Machine" is read out from one display data storage section and displayed on the display section 20 (FIG. 3(n)).

Furthermore, if you press the "Next Page" key 1/ψ in this state,
The total data for "Second Section" on the next page is read from the table data storage section 15 to the display data storage section 19, and the display section 2
0 (Fig. 3(n)).

However, if you want to enter the next data, click "Run"
Create a key to I:. By operating this "execute" key, the process shown in the flowchart shown in FIG. T56 is started, and as shown in FIG. 3(p), "In charge?" is displayed on the display unit 20 to guide the input of the department in charge. Thereafter, input processing is performed in the same manner as in the above case.

Next, the above calculation process 1 (step A23), registration process (step A27), total page creation process (step A28)
), details of calculation process 2 (step A29) will be explained.

First, the details of calculation process 1 (step A23) will be explained with reference to FIG. In step A19 of FIG. 6, the term [If it is determined that the formula set in IF is an arithmetic expression, the arithmetic expression is read into the arithmetic data storage unit 21 (Step Bl), 'et' Th expression variable item Table data is addressed (step B2). That is, it specifies the table address of the item in the eL formula and the variable item in H, the details of which will be described later. Next, check the presence or absence of data for all variable items, and if there is no data for even one, proceed to step B4, enter the unpaid code, and edit the data! c! Corresponding term LJF in storage section 14.

Write to the table data storage area 33 of G. At first, since the aggregation process is not performed, no data is written to the variable term "I," so the process of step B4 is performed. After that, the unsettled flag counter 21a in the calculation data storage section 21 is r+IJ and the calculation process 1 is ended.

If data has been input to all variable items, the determination result in step B3 is YES, and the process proceeds to step B6, where the table data of variable item 1] is written into the calculation data storage section 21. Then, perform a mathematical calculation based on the set calculation formula (step B7), and input the calculation result.
The data is written to the edited data storage section 14 and the process is completed.

Next, details of the total page creation process (step A28) in FIG. 6 will be explained with reference to the flowchart in FIG. 8. First, in step CI, a total page creation process is executed. This process checks whether "mathematical formula" and "collection 1" are set as the attribute data of the first item. 111, and if it is not set, the attribute data of the next item is sequentially checked. "Formula" as attribute data
and "Aggregation" is set, after specifying the result 11 first n address in the table data storage area 33, the specified XfiH table data is read out to the calculation data storage section 21 and the addition process flI! do. Hereinafter, the same Fl addition process is performed from the first page to the last page, and the specified Ifil-1
Write the final total result on the general meeting total page and process 11.
! to be coded. For example, if you input data for page 1, a comprehensive total page will be created on page 2 "1," and the entry "ID and input data for item E r300J.

rl 10J is written as is as total data.

Next, specify the address of the first item (step C2),
The attribute data is read out to the attribute data determining unit 17 to determine whether it is a "character" (step C4). If "Character" is set as attribute data, "Aggregation"
is set (step C5).

If either "character" or "group 1°" is not set as the attribute data, check the H absence of the next item opening (step C6), and if there is a next item opening, specify the next item lower address (step C7). ) and return to step C3.

In the table shown in Fig. 4, the first term rl A contains attribute data “
Since "Character" and "Collection=1" are set, the address of page 1 of the table data storage area 33 is specified (step C8), and the table data of the specified item 1 is calculated and compared by the operation/comparison unit 18.
is read out and stored in the internal register (step C9).
). Now, assuming that the data for the items on the first page shown in FIG.

Next, the specified page start address is stored in the cumulative start address storage section 23c1. : At the same time, the final address of the specified page is stored in the Ilp address storage unit 23a (steps C10 and CII). Then, it specifies the address of the next page and checks whether that page is a total page (including the total page) (step CI2
．． C13). In this case, since the second page is the total page, the determination result in step C13 is YES, and the process proceeds to step C16, where the item flag and the flag indicating the specified item in the total 41 pages are calculated by the calculation/comparison unit 18.
and compare the matches (steps C1B to C18).

In this case, since they do not match, it is further determined in step CI9 whether or not it is a comprehensive 1 page. If it is not the total page, the process returns to step C12, but if it is the total page, the process proceeds to step C21.

In this case, since it is the total page, step C21
Proceed to 111 people before the total page. That is, the total page for term r1A, that is, "section 2" is suppressed in table data storage area 33 based on the storage address of push address storage section 23B. Then, for this extraction page, the total term [1 flag should be set (step C22), and the aggregation process (step C22), the details of which will be described later.
23) and write the results r300J and rllOJ of the collection 51 of the second lesson on the page;

After performing this totaling process, the next page address for the last designated page is designated and the presence or absence of the next page is checked (steps C24, C25).

If there is no next page, the process advances to step C6, and if there is a next page, the process advances to step C2B. In this step C26,
The f1 analysis is performed to determine whether the designated page is a total page or not, and if it is not a total page, the process returns to step C9, and if it is a total page, it is further determined at step C27 whether or not it is a total page at t'11. If it is not the total page, step C
24, if it is the total page, the process returns to step C6. In this case, since there is no total page for the next page specified in step C24, the next page B is specified in step C7 via steps C25 and CB.

Then, attribute data is checked for item B, and steps C3 to C5 and C8 to C are checked as in the case of item gA.
13, the processes of C8 to C13 are performed. Here, since the next page specified in step C12 is the total page for item A obtained in the previous process, it is determined in step C19 that it is not the total page,
The process returns to step C12 again. And this step CI
The next page specified in step 2 is the total page, so steps C13, C1B to C are performed as in the case of item A.
After the process of 19, the process proceeds to step C2+, and by speaking the address (the final address of the first page) stored in the push address storage section 23a in step C11, χ・I is written to C Electric on the total page of the 2nd section. The total number of pages to be displayed is suppressed.

From item C onwards, there is no item for which both "text" and "total" are set as attribute data, so a total page is not created, and the process ends when it is determined in step CB that there is no entry for the next item. do.

The aggregation process in step C23 is performed according to the flowchart shown in FIG. First, the address of item 1 "1" is specified (step D1), and the attribute data is read out to the attribute data determining section 17 to determine whether "mathematical formula" is set (step D3). If "formula" is set as the attribute data, it is further determined whether "summary" is set (Step D4)
. If either "Formula" or "Aggregation" is not set as attribute data, check -G absent in the next item entry (step D5), and if there is a next item address, specify the next item address (step D6). Then, the process returns to step D2.

In the table of FIG. 4, since "mathematical formula" and "totalization" are not set as attribute data in items A to C, the address is advanced to the item by the steps D2 to D6 described above. In the item list, "formula" and aggregation are set as attribute data, so the i11 disconnection result in step D4 is YES, and the process proceeds to step D7 to calculate the total page top address, in this case "page 2".・
It is output to the comparator 18 and stored in an internal register. Next, the table data storage area 33 is addressed by the address data stored in the aggregation destination address storage section 23c (Step D8), and the specified item 11 table data r300J is read out to the calculation data storage section 21 and added (Step DIO). ). In this one-page addition, the input data r300J becomes the adder's result as it is and is held in the calculation data storage section 21.

Next, the next page address (page 2) is calculated and compared by the comparator 1.
8 and is compared with the address held in its internal register (step D12).

At this time, the total page is set to 2 pages, so
The determination result at step DI2 is YES, and the process advances to step D15. In this step DI5, the specified items,
In other words, the above calculation result r300J is displayed on the total page of items.
is written.

Thereafter, the process proceeds to step D6 via step D5, and the address of the next entry E is designated. Then, through the processing from step D2 onwards, aggregation processing is performed in the same manner as in the case of item 1 above, and as a result of the calculation, in this case, rllOJ, which is the same as the input data, is written to the total page of item 1''E.

Item 1: Since "aggregation" is not set as the attribute data for jF and G, the aggregation process from step D7 onwards is not performed, and the aggregation process ends when it is determined in step D5 that there is no next item. .

The above tabulation section Pl! As a result, as shown in FIG. 5(b), first, the totals are calculated for Section 2, and then for C Electric Machine.

Following the total page creation process, calculation process 2 in step A29 in FIG. 6 is executed. This calculation process 2
is executed according to the flowchart shown in FIG. First, the count value of the incomplete flag counter 21a in the calculation data storage unit 21 is read out to the calculation/comparison unit 18 and stored internally (step El), and the first address of one page is calculated as the calculation page address 5 in the storage unit 23d1. Memorize this 5 things (step E2). After that, the address of the f1 item is specified and its attribute data is read out to the attribute data judgment unit 17, and it is determined whether or not an arithmetic expression is set.
(step E3.E4.E5). Previous On term II
Since no calculation formula is set for A, step E1
Proceed to step 5 and check for the presence of the next item.

If there is a next item address, specify the “next item 1” address and step E
Return to step 4 and check the attribute data.

Since no arithmetic expressions are set for items A to H, aggregation processing is not performed and the next items are designated in sequence.

Then, when item F is specified, since an arithmetic expression has been set, the process proceeds from step E5 to step E6, where the arithmetic expression is output to the arithmetic data storage section 21 and stored in the arithmetic page address storage section 23d. The arithmetic expression variable term [-1 table data address is specified based on the address data (step E6E7). Next, the presence or absence of data is checked in step E8). If table data for the variable items has been created, the process advances to step E9; if no data has been created, the process advances to step E15. Since the table data of the variable items has already been created in the item H, the table data is output to the calculation data storage section 21 and the mathematical calculation is executed (step E10). In the calculation formula for item F, calculations are performed using total data for each person in charge. At the time of Fig. 5(b), the total data of the 2nd section is "300" and rl 10J
The calculation is performed using rl, 00J as the calculation result.
is obtained. This calculation result is stored in the calculation data storage section 21.

Next, step Elf, EI2) checks whether or not there is an uncalculated code in the specified item 11 table data, and if there is an unprocessed code, r-IJ the contents of the unprocessed flag counter 21a, and proceeds to step EI4, where the unprocessed code is checked. If there is no code, the process directly proceeds to step E14, where the calculation result held in the calculation data storage section 21 is outputted to the table data storage section 15 and written into the table data storage area 33.

After that, through step E15 and ELG, step E14
Returning to , the same process is performed on the next item G, and the total total data r300J of the total total page is obtained.

The calculation is executed using "110" as the data of the variable item, and the calculation result r1. Get OOJ. At this point, the data on the total page for the second section and the data on the total page are the same, so the calculation results for items F and G are the same.

When the processing up to item G is completed, check whether there is a next page (Step EI7), and if there is a next page, check 111 whether it is the total page (Step E18).
. If it is the total page, the process returns to step E17 to check whether there is a next page. Through the above processing, the process advances to a page that is not a total page, that is, the next data storage page, updates the contents of the calculation page address storage section 23d, steps E19), and returns to step E3.

Thereafter, the same process is repeated, and when all pages have been processed, the state is detected in step E17, and the process proceeds to step E20, where it is checked whether the count value of the uncalculated flag counter 21a is "0" or not. That is, it is checked whether all the calculations for the items that could not be calculated before the start of the process have been performed. If the above count value is "0", the count value of the uncalculated flag counter 21a is output to the calculation/comparison section 18, and in step El, the calculation/comparison section 1
The count value is compared with the count value held in the internal register of No. 8 (step E22). In this case, if all the calculations for the items that could not be calculated before the start of the above processing could not be completed, an unprocessed code is detected in step E1'2, and the count value of the unprocessed flag counter 21a is set to "-1". Therefore, the 111 decision result in step E22 becomes YES and the process ends.In other words, in the above case, the calculation based on U in the flow of this settlement process 2 is
;I This is because even if the same result is repeated, it is not possible to perform new calculations on the items that could not be calculated, so it is necessary to proceed to the next input process, etc.

However, if the count value of the end calculation flag counter 21a is decreased by 1 due to the detection of an uncalculated code, the judgment result in step E22 becomes No, and the calculations of the items that could not be calculated are performed. Since this may become possible, the process returns to step El and the calculation process is re-executed.

Here, when re-executing, the current value of the rice calculation flag counter 21a is input into the internal register of the calculation/comparison section 18. This arithmetic processing is carried out by the uncalculated flag counter 21.
Although the count value of a becomes "0", the process is repeated until the value of the rice arithmetic flag counter 21a at the start and end of the calculation process (steps El, E22) does not change.

Now, for example, if -8 -C C-D+E D-5+3 E-5+2 is given as an arithmetic expression, the count value ■
A-B calculation not possible "1" B-C calculation not possible "2" C-D+E calculation not possible "3" D-5+3 Execution → D-8 E-5+2 Execution → E-7 ■ A-B? rrL cannot be calculated B-C cannot be calculated C-D+E Execution → 8+7-15 "2J■ A
-B Operation not possible B-C execution -B -15r 1. J ■ A-B Execution-A-15rOJ As shown above, even if an operation is initially impossible, by repeatedly executing it from the beginning, the correct result can be obtained. It becomes possible to

Steps Bl and 10 of calculation process 1 shown in FIG. 7 above.
The table data address search for the arithmetic expression variable item, that is, the total page search in step E7 of the presentation process 2 shown in the figure is performed according to the flowchart shown in FIG.

First, an arithmetic expression is read into the arithmetic data storage unit 21 (step F1), and the number of "total" codes in each term is counted by the total code counter 21c (step F2).
The count value is output to the calculation/comparison section 18 and stored in its internal register (step F3). Then, one page of the table data storage area 33 is addressed and it is determined whether it is the total page (steps F4 and F5). If it is not the total page, the total page counter 21b is reset (step F6), and then the next page is checked for 6'. If there is a next page, the address of the next page is specified in step F8 and the process returns to step F5.

Each page is sequentially checked by the above processing, and if it is a total page, the total page counter 21b is set to r+IJL (step F9), and the count value is output to the calculation/comparison section 18 and compared with the count value of the total code counter 21C. (Step F10. F II). If they do not match, the process advances to step F7 to check whether there is a next page. If it is determined that they match in step Fil, the process advances to step F2, the table data of the specified item is read out to the calculation data storage section 21, and the process returns to step F6.

In the calculation formula set in item F, the number of "r combination = 1" is "2", two consecutive total pages are detected, and the second combination is page J1, that is, for the department in charge. Total page data is specified. In the table shown in FIG. 5, the total data r410J of item LID and the total data r280J of item E for section 1 are addressed and read out to the calculation data storage section 21.

In addition, in the calculation formula set for item G, the number of "total" is "3", and three consecutive total pages are detected,
Data for the last total page, 31 pages in total, is designated. In the table shown in Figure 5, total data r870J and item E on the total page are shown.
The total data r510J is addressed and read out to the calculation data storage section 21.

A total page search is performed as described above, the total data is read into the calculation data storage section 21, and calculation processing is performed based on it.

Next, details of the registration process in step A27 in FIG. 6 will be described with reference to the flowchart in FIG. 12.

In the registration process, first, the final address of the table data storage area 33 in the table data storage section 15 is set in the t and R person address storage sections 23a in the address control section 16 (step Gl). The start address of the storage area 33 is set in the address storage section 23b (step G2).Then, the start address [IA address is specified and the attribute data is read out to the attribute data determination section 17, steps G3 and G4), and sorted. Cut off the presence or absence of the specification (
Step 05). If there is no sort specification, the next item 1-I is passed through step G8, which determines the presence or absence of the next item.
The address for B is specified (step G7).

In this example, since sorting is specified as the attribute data of item A, the process advances from step G5 to step G8, and table data of the specified item is read from the input/cottonseed data storage section 14 and output to the calculation/comparison section 18. do. Figure 5(a)
When registering the input data of page 1 shown in FIG.

In this state, the presence or absence of the previous page for the extraction address is determined in step G9, or since there is no previous page when the first page is registered, the final address of the specified page, that is, the address indicating the first page, is the upper limit address storage. 23
Set to b.

After that, return to step G7 via step G6,
The next item address is specified. From item G onwards,
Since there is no sort specification, the process directly advances from step G5 to step G6. Thereafter, processing for each item is performed in the same manner.

Then, when processing for all items is completed, step G
6 to step 01B, the first item address of the data to be registered is specified, the attribute data is read out to the attribute data determining section 17, and it is determined whether the attribute data is "character j" (step G17. 01g).First term t-
I A has "character" set as the j attribute data, so in this case, it is further determined whether the sort specification is a or not, and if there is a sort specification, the process advances to step G27 and it is determined whether the next item data is a or not. . If there is next item data, step G2
9 specifies the address of the next entry. Since "sort" is designated for items A to G, no particular processing is performed. Further, since "character" is not set as attribute data for items DG, no particular processing is performed.

When the processing of the above items A to G is completed and it is determined in step G27 that there is no next item, the process proceeds to step G28, where input is made.
The edited tabular data stored in the cottonseed data storage section 14, that is, in this case, the tabular data shown in FIG. Register.

Next, with the data shown in FIG. 5(a) set in the tabular data storage unit 15, if the sales results of the first section are entered on the second page, the result will be as shown in FIG. 5(c). Sorting processing is performed. In steps 61 to G5, the same processing as when registering data for one page is performed, and when the attribute data of item A is read out, it is determined in step G5 that there is a sort specification, and the process advances to step G by 8 to input/input. The table data of the specified item is read from the edited data storage section 14 to the calculation/comparison section 18 and stored in the internal register.

If input data for the second page is to be registered, the department in charge, "1st Division", is input to the calculation/comparison unit 18.

In this state, it is determined whether there is 6 in the previous page for the Kijin address (step G9), but if there is a previous page when 2 pages [1] are registered, the process proceeds to step GIO and the previous page address is stored as the upper limit address. It is determined whether the address is greater than or equal to the address stored in the section 23b. If the result of this judgment is NO, the process proceeds to step GI5, and if YES, the process proceeds to step 011. When registering the second page, the previous page address and the address stored in the upper limit address storage section 23b are the same, so the judgment result of step CIO is YES, and the process advances to step Gll to register the specified item of the previous page. Address the table data of , specify the specified term [
JA's table data, that is, "2nd division" which is TA'5r1
is input to the calculation/comparison unit 18, and compared with the above input data for magnitude. If the input data is larger than the table data, the process proceeds to step G15, if the input data is smaller than the table data, the process proceeds to step G14, and if the input data and the table data are equal, the process returns to step G9. In this case, since the input data "Section 1" is smaller than the table data "Section 2," the process advances to step G14 to store the start address of the specified page in the pressed address storage section 23a, and then returns to step G9. When returning from step G13,014 to step G9, the page specified address is "-"
1'' and the processes from step 69 onwards are repeated. That is, if a plurality of pages are already stored in the tabular data storage section 15, the processing of steps 69 to G14 is repeated, and sorting processing is performed by rewriting the data in the matchmaker address storage section 23a. Further, after the specified page start address set in the pressed address storage section 23a is determined by the above sorting process, if the same assigned code as the sorted assigned code has already been registered, steps 69 to G13 are further performed. The above process is repeated to obtain the address of the highest page of the same milling barge 1 code and set it in the upper limit address storage section 23b. That is, in the processing of steps 69 to G13, if it is determined in step G9 that processing up to one page has been completed, it is determined in step GIO that the address stored in the upper limit address storage section 23b is larger than the previous page address. In this case, if it is determined in step GI3 that the table data is smaller than the input data, the address of the highest page of the same city code is determined and written in the upper limit address register t6 section 23b ( Step G15).

Thereafter, the process for the next item is executed through steps Gti and G7.

Thereafter, sorting processing is similarly performed for item 81 item C.

When the processing for all items 1 is completed, the process proceeds from step G6 to step 01B, 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 data is set to ``character''. It is determined whether or not (steps G17 and G18). Item A-
Since "character" is set as attribute data for C,
Furthermore, in step C19, it is determined whether or not sorting is specified.
Since there is a sort specification, proceed directly to step G27. G
29, the process returns to step GL7. Since "character" is not specified as attribute data in item D-G, step G27゜G2 is performed directly from step G18.
9 and returns to step G17. After completing the processing up to item G, the data held in the input/edit data storage unit 14 is transferred to the table data storage unit 15 in step 028.
and register it in the table data storage area 33.

Although it is not shown in the table of FIG. 4 above, if "character" is specified as the attribute data of the item but "sort" is not specified, the process proceeds from step G19 to step G20. The summary process is executed.

That is, in step G20, the tabular data of the specified item is read from the input/fringe data storage unit 14 to the calculation/comparison unit 18, and it is determined whether or not there is a previous page for the insertion address (step G21); if there is a previous page, step G21) is executed. G22
If there is no previous page, the process advances to step G27. If the matchmaker address is on page 1, it is determined that there is no previous page, and the process proceeds to step G27, where the next interitem data is checked for a/no. If there is next item inter-item data, specify the address of the next item [1 (step G29), read the attribute data to the attribute data judgment unit 17, and judge whether "character" is set (step G17.018 ).

If "character" is not set as the attribute data, the presence or absence of the next item data is immediately checked in step G27.

After that, the address of "Next item" is specified (step G2
9) The attribute data is read out to the attribute data determining section 17, and the presence or absence of the attribute data "character" is checked (step 618, G19), and then the presence or absence of sort designation is checked. Below, the contents of each item are checked in the same way. If it is determined in step G27 that there is no next item data, the input data held in the input/edit data storage unit 14 is registered in the table data storage unit 15 according to the matchmaker address stored in the insertion address storage unit 23H. do.

As mentioned above, there is no sort specification, and the attribute data "
Pages are grouped based on the data of the item for which "Character" is set, that is, the pages are grouped so that the interspace data is located on adjacent pages within the sorting range. Also,
If there is the same data in the items after this grouping process is performed, further grouping process is performed by replacing pages within the range where the above first grouping was performed.
- carried out in step G35.

As described above, input data is registered in the table data storage section 15, and a sorting process is performed at the time of data registration. Then, the above-described total page creation process (step A2g) and arithmetic process 2 (step A29) are performed on the data registered in the table data storage section 15, and the table shown in FIG. 4 is created. In other words, if you enter the data for Section 2 shown in Figure 5(a) and then enter the data for Section 1, the sorting process will be performed at the time of registration as shown in Figure 5(C), and then the total page will be created. Processing (Figure 8), calculation processing 2
(Fig. 10), as shown in Fig. 5(d),
The summation process is performed in the same manner as in case b).

[Effects of the Invention] As detailed above, according to the present invention, there is provided a means for setting an item and an arithmetic expression setting means for setting an arithmetic expression for any item set by this means using other items as variables. When data is input to an item for which no calculation formula is set, the input data is substituted for term 11 set as a variable based on the calculation formula, and the calculation is performed. If there is no data in the item set as
Since the calculation is performed again after performing other calculations, even if an item in which the 1+ calculation result is input in the calculation formula is set as a variable, eL Can do a lot of calculations.

[Brief explanation of drawings]

The drawings show one embodiment of the present invention; FIG. 1 is a block diagram showing the circuit configuration, FIG. 2 is a diagram showing the storage configuration of the table data storage unit in the first garden, and FIG. 3 is a diagram showing the key input operation. A diagram showing the correspondence between examples and display contents, Figure 4 is a diagram showing an example of creating a table, and Ts5 diagrams (a) to (d) are for inputting table data.
Figure 6 is a flowchart showing input processing, Figure 7 is a flowchart showing details of arithmetic processing 1, Figure 8 is a flowchart showing details of total page creation processing, Figure 9 10 is a flowchart showing details of calculation processing 2, FIG. 11 is a flowchart showing details of total page search processing, and FIG. 12 is a flowchart showing details of Ω record processing. . 11...Control unit, 12...Key input unit, 13...
Input buffer, 14... input! 1st collection data storage unit,
15... Table data storage section, 16... Address control section, 16a... Insertion address record ta section, 16b... Upper limit address storage section, 17... Attribute data judgment section, 18
... Calculation/comparison section, 19... Display data storage section, 2
0...Display unit, 21...Calculation data storage unit, 21a
...unplayed flag counter, 21b...total page counter, 21C...total code counter, 22...
Address register, 23a... Inhibition address storage section, 23b... Upper limit address storage section, 23c... Total start address storage section, 23d... Calculation page address storage section, 31... Table index storage section area, item data storage area, table data 3 self-memory area. representative of deceased person

Claims (1)

[Scope of Claims] Item setting means for setting an item; Arithmetic expression setting means for setting an arithmetic expression using other items as variables for any item set by this means; Setting by the item setting means. means for inputting data for items for which calculation formulas have not been set among the items that have been set, and data input for items that have been set as variables based on the calculation formulas set by the calculation formula setting means. A calculation means for performing calculations by substituting , a means for performing calculations again after performing other calculations if there is no data in the item set as the above variable, and a calculation formula setting item for calculating the calculation result by the above calculation means. 1. A tabular data processing device, comprising: means for processing input data as input data.