JPH02288957A - Calculation processing system for page data in table format data - Google Patents

Abstract

PURPOSE:To easily perform the calculation processing of data by designating the computing equation and the computed result of the four operations, the functional calculus, and the date of plural binder groups for numeric value data in table format data, and writing a sum computed result at a position designated by the table format data. CONSTITUTION:A command control part 3 retrieves and controls a command corresponding to menu data selected from a menu part 4 from a command group 5 based on an analysis instruction by an input data analysis part 2, and executes and processes the function of the command, and also, displays menu display selected at the menu part 4 on a display part 7 via a menu table control part 6. And by designating the computing equation and the computed result of the four operations, the functional calculus, and the date of the plural binder groups for the numeric value data in the table format data, the sum computed result is written at the position designated by the table format data. In such a way, the calculation processing of the data can be easily performed.

Description

Detailed Description of the Invention (Field of Application of Industry-1-) In a data processing device that uses an interactive format between a computer and a human, it relates to tabular data created by a computer in an arbitrary format, and in particular to data processing in the tabular data. Regarding the calculation processing method.

(Prior art and problems) It is possible to read tables in an interactive manner without having to acquire specialized computer programming skills by simply inputting commands and other marks etc. in an interactive manner according to the closing lines displayed on the screen. A simple language that can be used to create, edit table data, calculate table data, etc. is included in the box. Such a simple Mt i! Along with the inclusion of 74, computer special 1
At present, the number of people using this personal combination is increasing, and it is now being used in various fields. For example, aggregation and reports for business schedule management, patent business management, sales performance management, inventory management, report card management, etc. are now processed and submitted by computers.

Data processing and storage for aggregation and reporting of these tabular data is done using office supplies such as / = 1 and /-.
The calculation process for tabular data with a structure that can be processed hierarchically, such as a binder as a bundle of objects and a cabinet as an east of the binder, is complicated.

For example, specifying the data to be processed for Jl calculation, specifying the d1 formula, specifying the location where the calculation result is displayed, and calculating excluding table formats that include ruled lines, characters, etc. 29. Complex processing is required. It required skill.

(Summary of the Invention) The present invention solves such conventional problems and allows tabular data in a computer to be processed and stored interactively as data with structures such as cabinets, binders, and pages. The aim is to create and edit a table of any 7 oats in an interactive manner based on the instructions displayed on the computer display screen. In the data processing η11 method that allows input means such as a keyboard or mouse, commands input from the input means and menu selections displayed on the screen in place of the command input are processed and stored in a storage device. a manual analysis means for analyzing and processing data to be displayed; a menu group for storing menu data to be displayed on a display; and a command analysis processing number by the input data analysis means; 1
and 1,000f'9 for displaying menu data stored in the menu group controlled by the control means. Save a bundle of several pages of data as a binder7, and then use multiple binder groups to perform four arithmetic operations, function calculations, and calculation formulas for numerical data in tabular format data. By specifying the calculation result as 71, the total JI calculation result is written into the specified position of the tabular data. (2) The range to be calculated in the tabular data includes the rows and ruled lines of the item name. In cases where the data is within the entire range except for the following, calculations were made for characters in tabular data in which characters such as names were entered (
The feature is that the calculation is performed by excluding columns or rows that do not exist from the calculation target. (3) Even if you do not exclude from calculation the columns or rows in which you do not want to perform 81 arithmetic on characters, etc. in tabular data in which characters such as names are entered, characters, ruled lines #! When adding or subtracting data that cannot be calculated, such as 1-01, the calculation is performed by replacing it with 1-01. When input, the conditions for specifying the range are displayed on the message line, and in order to clarify the contents of the specified range, the contents of the range of the calculation formula specified from the board are displayed on one screen. It is especially important to do this.

(Example) Figure 1 is a block diagram showing the configuration of the present invention, Figure 2 is a diagram showing the configuration of the display screen according to the present invention, and Figure 3 is an example of the screen according to the present invention. FIG.

In the figure, 1 is an input section, 2 is an input data analysis section, 3 is a command control section, 4 is a part of a menu, 5 is a command group, 6 is a menu screen control section, 7 is a display section, 8 is a printer, and 9 is an external device A storage device, 10 a data transfer unit, 11 a part of a menu bar,
12 is a scale part, 13 is a window number part, 14 is a line number part,
15 is a message input section, 16 is an input line section, 17 is a tabular data display section, 18 is a pull-down menu, and 19 is a help menu window.

The input unit 1 is an input device such as a mouse or a keyboard.

The input data analysis section 2 analyzes the data input from the input section 1 to determine whether the input is from an arrow key or a mouse, or whether it is an input of a command name meaning an execution command. If the input is via a window menu displayed on the screen instead of inputting a command name from the input unit 1, it instructs the selection operation of menu data in the menu part 4, and inputs a command group via the command control unit 3. Instructs to call the command in step 5. By operating the input unit 1, the cursor is moved in the pull-down menu to select a command or highlight the function of the selected item, and if it is an execution command, the command is searched from the command group 5 via the command control unit 3. .

The command control unit 3 searches and controls a command corresponding to the menu data selected from the menu part 4 based on the analysis instruction by the input data analysis unit 2 from the command group 5, executes the function of the command, and also executes the function of the command. It controls the operation until the menu display selected by section 4 is displayed on display section 7 via menu table control section 6.

Menu part 4 includes menu bar, pull-down menu,
This memory stores items to be displayed on the display screen 4, such as a selection item pull-down menu, help menu, error menu, calculator menu, and title menu.

The command group 5 is a memory that stores commands that control execution, and is divided into "common command group,""input command group,""line editing command group,""column editing command group,""table editing command group," and "table editing command group" based on the function of the command. Arithmetic aggregation command group”
"Search classification command group""Display command group""Management command group""Setting command group""Transfer communication command group"
They are classified into ``Print graph command group'', ``Data conversion command group'', etc. (Please refer to the attached table for the contents of the command group).

The menu screen control section 6 controls data for executing the commands of the command group 5 selected by the command control section 3 and displaying the menu data of the menu part 4 as one menu screen on the display section 7.

Based on the search control command, control the table data corresponding to the command with the search control command from the table group 5,
Display the table data on the display screen 4.

The display unit 7 is a display device such as a liquid crystal, plasma, or other CRT, and the screen can be displayed in a split screen manner, and can also display the system menu in Menu Part 4 [Appendix] (3) Contents A menu bar section 11, a scale section 12, a window number section 13, a line number section 14, a message entry section 15, an input line section 16, and a tabular data display section 17 are displayed, as well as a pull-down menu window 18 and a help menu. Window number 19 is also displayed. In addition, part of the menu 4
Menu data such as error menu, calculator menu, title menu, etc. stored in is displayed.

The printer 8 is a printer that prints the execution processing result of the command selected by the command control unit 3.

The storage unit 9 is an external storage device that stores tabular data whose processing is controlled by executing commands in a hierarchical manner like pages, bins, and cabinets.

5IO (serial input/output) 10 is a processing unit for transferring tabular data to and from an external device through command execution processing.

The menu data 11 categorizes the processor 11B of the computer viewer into the uppermost category. This is an RF-facing display area, and by moving the arrow keys, the cursor moves on the display screen, and the menu item corresponding to the cursor is displayed in reverse video.

When you specify a highlighted item on the menu bar and press the execution key, a pull-down menu with contents corresponding to the highlighted item is displayed on the screen, and a help menu is also displayed at the same time.

The menu bars according to the present invention are classified into four types, and each menu bar is selected by using arrow keys and displayed on the screen.

The scale section 12 displays the title name, column number, and column number of the table to be displayed.
This is a display area on the screen that displays the number of column digits, item names, number of character digits, etc.

The window number section 13 is an area for identifying the screen displayed on the display screen, and the display screen displays tabular data input from the input section 1 and controlled and processed by the input data analysis section 2 and command control section 3 as is. The main screen and tabular data of the main screen may be temporarily transferred to memory and saved, and a sub screen may be displayed. In this case, this is an area for identifying whether the currently displayed screen is the "main screen" or the "sub screen." Further, since the display screen according to the present invention can be divided into four screens, it becomes easy to identify whether displayed data is a main screen or a sub screen.

Normally, the tabular data on the sub-screen cannot be seen, but it can be seen by dividing the display screen using the screen splitting function. Assign a number to each divided screen. This number is called the window number. You can work while simultaneously displaying tabular data on different parts of the main screen or on sub-screens.

In this case, commands can only process data in the table displayed on the main screen.

For this reason, the main screen is also called a work screen. The identification notation for the main screen and sub-screen is [A window number surrounded by 1 means the main screen, and a window number surrounded by () means the sub-screen. Furthermore, if the identification notation cannot be used to distinguish between the two screens, the 7-frame pattern is displayed in a different manner along with the identification notation to identify both screens.

The line number section 14 is an area on the screen that displays the line number of the table of tabular data, and is an area for identifying which line the tabular data called up on the screen is.

The message input section 15 is an area on the screen that displays command selection and selected item processing operation instructions from the pull-down menu using commands or the mouse in an interactive manner from the input section 1. do(
(also called prompt area). The message input unit 15 prompts for selection items or operation instructions when executing a command, and data processing can be executed in an interactive manner by inputting a command or the like from the keyboard in response to the message.

The input line section 16 is an area on the screen in which contents input from the keyboard according to instructions from the message input section 15 are temporarily displayed. When the operator confirms the contents displayed in the input line section 16 and presses the execution key, the contents are sent to the desired tabular data (also referred to as "cell j") and displayed.

In response to instructions from the message typing section 15, commands, characters, numbers, etc. are input from the keyboard. When you finish entering characters and press the execution key, the entered contents will be entered. The present invention includes an input line section 16 and a pull-down menu window 18.
Since processing can be executed in conjunction with the selection of commands listed in , commands etc. can be input directly to the input line section 16 and executed.

The tabular data display section 17 has M rows and N columns as one page, and displays the page in units of pages on the screen. If the data consists of multiple pages, it is possible to organize and save the data in a binder, and expand the data processing unit to the binder. Data processing using commands can process multiple pages. That is, when performing editing and processing such as adding or deleting items of tabular data, it is possible to add or delete data items across multiple pages by executing one command.

As shown in FIG. 3, the display screen displays tabular data as well as a pulldown menu window 18 and a help menu window 19, as well as an error window, calculator window, cabinet, and binder titles (not shown). Windows are displayed as windows individually or in a stacked manner. When the message "Please input command" is displayed on the message input section 15, a function on the menu bar can be selected. Use the arrow keys to move the menu bar functions (reverse display),
Select and execute by pressing the execution key.

Move the highlighted display to the desired function and press the execution key to display a pull-down menu. When selecting a function, press the execution key to execute the selection. If you type the left or right arrow key while the pull-down menu is displayed, a pull-down menu with the specified force will appear. For example, in the case of "→-1", the pull-down menu of the function menu bar on the right side is displayed.

The Burgundy menu 18 is an area for displaying each function group corresponding to the top-level desired processing function displayed on the menu bar part 11. The pull-down menu window 18 displays functions for controlling the computer, classified into a -1-level desired function group and a lower-level desired function group. Each function displayed in the pull-down menu window 18 is executed by moving the arrow keys to highlight item L1, selecting the desired location as appropriate, and pressing the execution key.

The help menu window 19 includes the menu bar section 11 and the pull-down menu section 18 (an area that explains each function of the displayed upper and lower function groups. The operator can use the menu bar section 11 and the pull-down menu window 18 to explain each function of the displayed upper and lower function groups. You can operate by referring to the help menu provided.

There are four types of menus displayed on the menu bar part 11: Menu (1), Menu (2), Menu (3),
Consists of menu (4). Menu (1) is [Commonly used 1,
[Input 1. Consists of 1 row editing 1, [column editing 1] Menu (2) includes E table editing 1, [operation collection H11, [search classification 1,
It consists of [Display], and menu (3) is [Tube Fl'! ],
Menu (4) consists of [Settings 1, [Transfer Communication], and [Print Graph 1], and the menu (4) is classified into [Data Exchange 1] and [Option 1], respectively. A pull-down menu is displayed for each function classified in each menu bar. In other words, each function on the menu bar (1) [Commonly used 1 "Input"] [
Row Edit 1 [Column Edit 1 has individual pull-down menus (see "Appendix"). Further, a lower pull-down menu window 18 is displayed, and a pull-down menu listing the selection order I for each function of menu bar (1), (2), (3>(4)) is displayed.This pull-down menu The tabular data in the computer is processed by interactively selecting the selection items displayed in the window 18.

A help menu window 19 is displayed that provides explanations and operations for each of the functions listed in the menu bar section 11 and pull-down menu window 18. If you are unable to understand the operations when processing the computer interactively, explanations or operation guides for functions corresponding to the highlighted display position of the menu or command execution status are displayed in the help menu window 19. Operation becomes easier.

Next, examples of the present invention will be described.

(1) Example of total calculation of tabular data When you want to freely calculate numerical data in tabular data, especially in tabular data, total J1 calculation can be done by giving a formula. , four arithmetic operations, functional calculations, daily and other time subtractions, and total calculation results can be automatically entered into a table by specifying the position of the tabular data.

■Use the arrow keys to highlight the menu bar according to the present invention.
Move to "Calculation Total" and press the Execute key. The pull-down menu for "Calculation aggregation" includes 1 table calculation - subtotal, 2-page calculation 1, continuous page calculation 11 moving average calculation, cross-tabulation and interval aggregation, and carryover calculation. function is displayed (see separate table).

■Use the arrow keys to move the cursor to "CAL, table calculation" and press the execution key. The message line on the screen related to the present invention is "What is the calculation formula?" No comma, rounding off to the nearest whole number, no row area specified, no column area specified] are displayed.

■Enter the calculation formula from the keyboard and press the execution key. For example, inputting a calculation formula for calculating ``column sum, 111'' of tabular data will be explained. Here, a calculation formula for calculating the sum of the 4th column "Japanese", 6th column "English", and 8th column "Mathematics" and displaying the result in the 10th column will be specifically explained. In this example, since the ruled lines of the table are counted as one column, ruled lines are drawn in the fifth and seventh columns, and there is no numerical data. rc4+c8=/C
10J In this calculation formula, "C" means column, and here it means the first column. "4" is a column number meaning the fourth column. "+" means addition sign. “=” means equal, and is a symbol for obtaining a calculation result.

"/" is a symbol that requires continuous calculation, and "8 from the 4th column
It means the symbol that represents the calculation of "up to column". "C10"
means the specification of the column in which the total calculation result is written, and means "10 columns, 1 column". In other words, the above formula is "8 from the 4th column.
Add the data in the columns and write the total result in the 10th column.''

■The total score for "Japanese", "English", and "Mathematics" is entered in the 10th column, and "Please input command [C/SAMPLE: P I PS10] J" is displayed on the message line.

(2) Next, an example of conditional calculation processing on tabular data will be described. If the range to be calculated in tabular data is the entire range excluding rows and ruled lines of item names, columns or columns in which you do not want to calculate characters, etc. in tabular data containing characters such as names, etc. This is a case where the calculation is performed by excluding the row from the calculation. The present invention replaces data that cannot be calculated, such as characters and ruled lines, with "0" in the case of addition or subtraction, without excluding columns or rows in table format data that do not want to be calculated. and calculate.

■In the message line related to the present invention, click [What is the calculation formula? ] is displayed, enter the "specific calculation formula" from the keyboard. First, as an example, a case will be described in which "the range from the 2nd column and the 10th column to the 12th column" of tabular data is specified.

■Enter C[2/10,121 from the keyboard.

[C] means column specification, and [] means range specification condition. The numerical value "2" means the column number "second column". "/" indicates the meaning of "and". "," comma means "
10.124i indicates the 12th column from the 10th dari.

Next, create one table of tabular data with ruled lines in odd-numbered columns (if you want to exclude the second column "Name" column from calculations and specify all other columns except the second column) Explain using two.

■Enter C[4,TI from the keyboard and press the execution key. 1-C” means column designation. [ ] means range specification. "4" means the column number, and "T" means the last column. That is, J4. TJ means "from the 14th column to the last column."

■Enter "C" from the keyboard and press the execution key.

``Current column area specification 4.T'' is displayed in the main line of the screen according to the present invention.

Further, as an embodiment, the present invention can confirm whether a single area is designated as "existence" or "absence" in a message line according to the present invention, and can further specify an area with specific contents such as 1. menu to confirm whether to
Display the screen and display the range specified data 20-.

■Enter calculation formula C[2/10,12] from the keyboard and press the execution key. [C1 means column designation. "
] means a symbol indicating a condition for specifying a range. Numeric value “
2” means column number “2”. "/" indicates the meaning of "and". "," comma indicates the meaning of "from", [
IO, 12J indicates [columns 10 to 12]. Therefore, [CJ means that a column is specified, and the numerical value etc. in [] means the specified area data of the column. [R]
In the case of , it means that a row is specified, and it means that it is the specified area data of the row.

■The message line on the screen related to the present invention is "What is the calculation formula?"
"No comma, rounding off to the nearest whole number, row area not specified, column area specified" is displayed. Note that when a line range is specified, the line area specification ``no'' display is changed to ``1'', and the operator can recognize whether a range has been specified even from the message line in the calculation formula.

■Enter "C" or rRJ from the keyboard and press the execution key.
Press.

■Current column area specification 2/10, 1.2J is displayed on the screen. In the case of item area designation, instead of column area designation, it is displayed as [Current column area designation 2/1('), 12J].

(Effects of the Invention) Since the present invention has the above configuration, it has the effect of simplifying data calculation processing in tabular data in a recitation format.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the configuration of the present invention, FIG. 2 is a diagram showing the configuration of a display screen according to the present invention, and FIG. 3 is a diagram showing an embodiment of the display screen according to the present invention. 1... Input section 2... Input data analysis section 3...
Command Y Control 8K 4... Menu part 5...
・Command group 6... Menu screen control section 7...
Display section 8... Printer 9... External storage device 10... Data transfer section 11
...Menu bar part 12...Scale part 13.
...Window number section 14...Line number section 15...Message entry section 16...Input line section J7...Tabular data display section 18...Purgran menu 19...Help menu window

Claims (4)

[Claims] (1) In a data processing method that allows the creation and editing of tables in any format in an interactive manner based on instructions displayed on a computer display screen, data input from input means such as a keyboard or mouse, etc. an input analysis means for processing commands and selection items on a menu displayed on the side in place of the command input, and analyzing data to be stored in a storage device; and a menu group for storing menu data to be displayed on a display unit; means for controlling menu data from the menu group by command analysis processing by the input data analysis means; and means for displaying menu data stored in the menu group controlled by the control means; The created tabular data can be saved page by page, and a bundle of multiple pages of data can be saved as a binder, and multiple binders can be used to perform arithmetic operations, function calculations, and dates on the numerical data in the tabular data. A calculation processing method for page data in tabular data, characterized in that by specifying a calculation formula and calculation result, a total calculation result is written at a specified position in tabular data. (2) If the range to be calculated in tabular data is the entire range excluding rows and ruled lines of item names, I would like to have the characters, etc. in the tabular data in which characters such as names are entered be calculated. A calculation processing method for page data in tabular data, characterized in that calculations are performed by excluding columns or rows that do not exist from calculation targets. (3) Add or subtract data that cannot be calculated, such as characters or ruled lines, without excluding columns or rows that do not want to be calculated, such as characters, etc., from calculations in tabular data in which characters such as names are entered. A calculation processing method for page data in tabular data, characterized in that in the case of , the calculation is performed by replacing it with "0". (4) When a "calculation formula with a specified range" is entered from the keyboard in the message line, the range specification conditions are displayed on the message line, and the calculation specified from the keyboard is made to make the content of the range specification clearer. A calculation processing method for page data in tabular data that is characterized by displaying the contents of the expression range on the screen.