JPH02288958A - Processing system for making data into graph in table format data - Google Patents

Abstract

PURPOSE:To easily make table format data into a graph with an interactive format by making the graph in table, the pile bar, the synthetic point, and the block graph, etc., of numeric data with table format into graphs, displaying a scale on each graphed graph, and preserving graphed 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 the graph in table, the pile graph, the synthetic point, and the block graph, etc., of the numeric data in the table format data which preserves and stores plural binder groups are made into the graphs, and the scale is displayed on each graphed graph, and also, the data made into the graph is preserved. In such a way, it is possible to easily make the table format data into the graph.

Description

DETAILED DESCRIPTION OF THE INVENTION (Industrial Application Field) The present invention relates to interactive data processing, and particularly to graphing processing of tabular data created by a computer in an arbitrary format.

(Prior art and problem 7α) Tables can be created interactively without having to acquire specialized computer programming skills by simply inputting commands and other marks etc. in an interactive manner according to the messages displayed on the screen. , simple languages that can perform processing such as editing table data and calculating table data are becoming popular. With the increasing popularity of computers, the number of people using computers, especially personal computers, is increasing, and the current situation is that they are now being used in a variety of fields. For example, aggregation and reports for business schedule call management, patent business management, sales performance management, inventory management, report card management, etc. have come to be processed and submitted by computers.

When processing and storing data for aggregating and reporting such tabular data, tabular data is stored hierarchically like office supplies such as notebooks, binders, and cabinets, and when reporting, etc., tabular data is converted into graphs. There is a demand to become

Graphing has become possible in response to these demands due to the development of computer technology.

However, there is a problem in that it requires extremely difficult processing to graph tabular data created in arbitrary formats by each operator in various formats.

(Summary of the Invention) The present invention solves such conventional problems, and enables the storage of tabular data created interactively in a fun computer in an interactive format such as in a cabinet, binder, or page office supplies. The object of the present invention is to provide a processing method for storing and storing created tabular data in a 14-step manner and easily graphing such tabular data.

The present invention also provides instructions 1 and 21 displayed on the display screen of a computer in a data processing JJP method that allows for the creation and editing of tables for any 7-sized table in an interactive format, using input from a keyboard or mouse. means, an input analysis means for processing commands manually input from the human power means and menu selection items displayed on the screen in place of the human power of the commands, and analyzing data to be stored in the storage device; a menu group for storing menu data to be processed; a means for controlling menu data from the menu group described in +1if; and a menu group 11 controlled by the control means; It is equipped with means for displaying menu data stored in = 3 in tabular data for storing binder groups Convert numerical data in tabular format into graphs such as graphs in tables, product double bars, composite point and interval graphs, display 11 scales on each graph, and The method is characterized in that the graphed data is saved.

(Margin below) (Example) Figure 1 is a professional 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 a diagram showing the configuration of the display screen according to the present invention. It is a figure showing an example.

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,
Reference numeral 15 indicates a message entry section, 16 indicates an input line section, 1''7 indicates a tabular data display section, 18 indicates a pull-down menu, and 19 indicates a help menu.

Human power section 1 uses human power such as a mouse or N-board 'J = '&
It is t.

The input data analysis section 2 analyzes the input data from the human power section 1, such as input from arrow keys or a mouse, or 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 the command via the command control unit 3. Instructs the calling operation of group 5 commands. 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 the section 4 is displayed on the display section 7 via the menu table control section 6.

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

Command group 5 is a memory that stores commands that control execution, and is divided into "common command group", "input command group", "edit command group", "column edit command group", and "table edit command group" based on the function of the command. "Calculation aggregation command group", "Search classification command group", "Display command group", "Management command group", "Setting command group", "Sending communication command group"
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 unit 6 executes the command execution process of the command group 5 selected by the command control H1s 3 in the menu part 4.
The menu data displayed on the display section 7 as one screen is controlled.

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 liquid crystal, plasma, or other CR, T'4 display device, and the screen is capable of split-screen display. ) The menu bar part 11, the scale part 12, the window number part 13, the line number part 14, the mesocene input part 15, the input row part 16, and the tabular data display part 17, which are the contents of P^♂ and ρ, are displayed. , a pull-down menu window 18, and a help menu window 19 are also displayed.Furthermore, menu data such as an error menu, a calculator menu, and a title menu stored in the menu portion 4 are 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 such as pages, bins, and cabinets.

5IO (Serial Input 1/A 1Top NT) 1
0 is a processing unit for transferring tabular data to and from an external device through command execution processing.

The menu bar part 11 is the display area of the screen L that categorizes the processing functions of the computer into thoughts.By moving the arrow keys, the cursor can be moved by 1 degree on the display screen, and the menu bar at the corresponding location of the cursor] " is displayed in reverse video. When the highlighted item I on the menu bar is specified and the execution key is pressed, a pull-down menu with contents corresponding to the highlighted item is displayed on screen 1, and at the same time a help menu is displayed.

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, character numbers, etc.

The window number section 13 is an area for identifying the screen displayed on the display screen, and the display screen displays the tabular data that has been manually input from the input section 1 and controlled and processed by the input data analysis section 2 and command control section 3 as is. In some cases, the main screen and tabular data of the main screen are transferred to memory and saved, and a sub screen is displayed. In this case, this area identifies whether the currently displayed screen is the sub-screen 1 or not. 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. Display tabular data from different parts of the main screen or sub-screens at the same time to improve your work.

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

For this reason, the main screen is also called a work screen. The identification notation of the main screen and sub-screen is that a window number surrounded by [] 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, both screens are displayed with different identification notations and different frame designs.

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 that identifies which line the tabular data called up on the screen is.

The message writing section 15 uses an interactive command from the human resources section 1 or the mouse to send messages! This is an area on the screen that displays command selection and selected item processing instructions in --, and displays items such as [Please input commands] (also referred to as a prompt area). Message batting section 15
When executing a command, prompts for selection items or operation instructions, and in response to this message, inputs commands from the keyboard, allowing data processing to be executed in an interactive format.

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 called "cell") 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 manually entered content will be entered. The present invention includes an input line section 16 and a pull-down menu window 18.
When used in conjunction with the selection of commands listed in J! ! Since it can be executed, commands and the like can be input directly to the input line section 16 and executed.

The tabular data display section 17 defines M rows and N columns as one page, and displays the page on the screen page by page. If the data is in multiple bins, it is possible to organize and save the data as 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 increasing or deleting items of tabular data, it is possible to increase or delete data items across multiple pages by executing one command.

On the display screen, as shown in FIG. 3, a pull-down menu window 18 and a help menu window are displayed along with tabular data, as well as an error window, a calculator window, a cabinet window, and a binder title window (not shown). displayed individually or in layers. When the message "Please input command" is displayed on the message input section 15, a function on the menu bar can be selected. Functions on the menu bar are selected and executed by moving the highlighted display (reverse display) using the arrow keys and 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 a pull-down menu is displayed, the selected pull-down menu will be displayed. For example, in the case of "→", a pull-down menu of the function menu bar on the right side is displayed.

The pull-down menu window 18 is part of the menu bar 1
This is an area for displaying each function group corresponding to the processing function of the upper level idea displayed in 1. The pull-down menu window 18 displays functions for controlling the computer classified into a higher-level function group and a lower-level function group. Each function displayed in the pull-down menu window 18 is executed by moving the blank key to highlight the item, selecting the desired location as appropriate, and pressing the execution key.

One help menu window is an area for explaining each function of the upper and lower function groups displayed on the menu bar section 11 and the pull-down menu window 18. The operator can perform the operation by referring to the help menu 221 displayed on the display screen without referring to the manual.

There are four types of menus displayed on menu bar part 11: menu (1,), menu (2), and menu (3).
, consisting of menu (4). Menu (1) is [commonly used]
Menu (2) consists of [Table editing], [Calculation summary 1, [Search classification 1,
[Display], menu (3) consists of [Management 1, "Settings", [Transfer communication 1], and [Print graph], and menu (4) consists of [Data exchange 1, Option 1]. be done. A pull-down menu is displayed for each function classified in each menu bar. That is,
Individual pull-down menus are displayed for each function [Commonly Used] [Input] [Row Edit 11 Column Edit 1] on the menu bar (1) (see "Appendix"). In addition, the lower pull-down menu window 18 or the menu bar (18) is displayed.
) (2), (3), and (4) according to the selection order 1.
A pull-down menu listing items 1 is displayed. The user selects "selection order 1" displayed in the pull-down menu window 18 in an interactive manner to process tabular data on the computer.

A help menu window 19 is displayed for each of the functions listed in the menu bar portion 11 and the pull-down menu window 18, which explains the explanation and operation of each function. If you become confused about what to do when using a computer in a text-based format, explanations or operation guides for functions that are centered around the highlighted display position of the menu or command execution status are displayed in the help menu window 9. , furthermore, it becomes easier to operate the computer.

Next, an embodiment will be described in which tabular data consisting of 77 formats arbitrarily created in an interactive format according to the present invention is graphed for visual explanation.

■ Use the arrow keys to highlight the menu bar according to the present invention.
- Common Use] and press the Execute key.

■Confirm that the pull-down menu related to the "Commonly Used" invention is displayed. The "Common" pull-down menu includes "Call page", "Save vane", and "Print".
[-List of various titles,” “Table calculations,” “Cross collection,” “
"Simple graph", "Business graph", "Sort", "Condition search", "Exit", "Exchange media", "Manage binder"
"1 table of information" and "list of explanations" are displayed, and can be selected as appropriate by moving the arrow keys.

■Use the arrow keys to move the highlighted display in the pull-down menu to "GR Simple Graph" and press the execution key.

``What is the processing range (graph creation target)? (M, vane, binder)'' is displayed in the message line related to the present invention on the 0th screen.

■Press the execution key. If you want the tabular data displayed on the screen to be an illusion, input only the execution key without any manual input from the keyboard.

-16=0 The pull-down menu for Graph 7-1 is displayed on the screen, and the contents of the pull-down menu are [-graph in the table-11 product-] 2 bars/synthesis point] ``Interval graph-1.At the same time, the message The same contents as the display contents of the pull-down menu are displayed on the line.Use the arrow keys to move the highlighted display on the pull-down menu to 1-Product-L frame/Synthesis point, and press the execution key. In the pull-down menu that appears, move the highlight to [Stacked Bar Graph] and press the Enter key.

0 In the message line of the screen, write ``The rule column is (column to be graphed)
? " is displayed, and you manually enter the column number to graph from the input row. For example, if you want to graph the 4th column, 6th column 1] and the 8th column, enter "r 4 / 6 / 8".

Then, the message line is 1 - What is the number of digits in the graph? -1(
10 to 117/scale division number) 1 is displayed.

For example, a case will be explained in which if the total score of 3 subjects is 300 points and the division number 1j is 60, each division will be 5 points. If you want to divide by ``60'', type ``601'' and press the execution key. Furthermore, "What is the minimum value?" is displayed in the menu message line. In this embodiment, the minimum value "0" is specified in order to see all the accumulations. Therefore, enter "10" and press the execution key.

The message line on screen 0 displays a message asking whether to save the graphed data, such as ``Would you like to save a new light?''. If you do not want to save, press the execute key. Then, the data graphing process starts and a stacked bar graph is displayed on the fourth row of the table format on the screen.

(Effects of the Invention) Since the present invention has the above configuration, it has the effect that tabular data that can be stored hierarchically can be easily graphed in an interactive 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. j...Input section 2...Input data analysis section 3...
Command l1llflS 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...Manual entry section 17...Tabular data display section 18...Pull-down menu 19...Help menu window

Claims (1)

[Claims] A data processing method that allows for the creation and editing of tables in any format in an interactive manner based on instructions displayed on a computer display screen. an input analysis means for processing menu selections to be displayed on a screen in place of command input and for analyzing data to be stored in a storage device; a menu group for storing menu data to be displayed on a display; and the input data. The table created in the interactive format includes means for controlling menu data from the menu group by command analysis processing by the analysis means, and means for displaying menu data to be stored in the menu group controlled by the control means. Format data can be saved in page units, bundles of multiple pages of data in page units can be saved as binders, and multiple binder groups can be saved and stored. Numerical data in tabular format can be graphed and stacked in tables. A method for graphing tabular data, which is characterized by graphing bar, composite point, and interval graphs, displaying scales on each graphed graph, and saving the graphed data.