JPS62189555A - Update processor for data on spreadsheet program - Google Patents

Abstract

PURPOSE:To allow even an ordinary user to update data through the easy operation of a keyboard by providing a means which updates a page, which is specified by inputting definition from an input means, according to said definition. CONSTITUTION:A data update processor 1 is configured with a control part composed of processors, etc., a storage device 3, the keyboard 4, a display device 5 and a printer 6. For inputting the definition required for data updating, a page storing a previously generated definition table is called by specifying through the keyboard 4, or a conditional equation and an execution equation are inputted through the keyboard 4 at the time of updating data. If is such a way the keyboard 4 is operated according to a message which is displayed at every step of work procedure for a command updating data, data is easily updated.

Description

DETAILED DESCRIPTION OF THE INVENTION (Technical Field of the Invention) The present invention relates to data update processing in a simple computer language i!
It is related to the device.

(Background of the Invention) Recently, in order to make it easier for users to recognize the information processing structure of a computer and operate the computer, simple language processing for computers has been developed, which processes information as if it were recorded in a ledger. For example, if the device is known,
A data area in which a certain amount of character information corresponding to the amount of character information per page of a ledger is displayed or stored is called a page, and information is processed in units of pages consisting of rows and columns. Each page is provided with a title, and a data file consisting of a plurality of pages is formed in the storage device.

When writing to a data file formed in a storage device, or displaying or printing the contents of a data file, this is done via the page-based buffer 7 area of the internal storage device. That is, when displaying, printing, etc. the contents of a data file, the operator specifies the page number of the data file.

By the way, in data processing by computer, creating a new data table based on previously input data,
It is often necessary to process past data under certain conditions. For example, when evaluating the business performance of each branch nationwide, it is conceivable that each branch is evaluated by comparing the data of each branch with standard data, and the results of 7' are added to the data of each branch.

Conventionally, in order to perform updates such as adding data based on certain conditions based on data that has already been entered into a computer, it was necessary to create a new data processing program, which was done by ordinary people without specialized computer knowledge. The user was unable to perform processes such as updating data.

(Objective of the Invention) The present invention was invented under these circumstances, and its purpose is to enable general users without computer expertise to perform processes such as updating data with simple keyboard operations. The goal is to enable people to do what they do.

(One Embodiment of the Invention) FIG. 1 shows a simple language data update processing device 1 according to the present invention.
2 is a block diagram of a control unit including a processor, 3 is a storage device, 4 is a keyboard, 5 is a display device,
6 is a printer. FIG. 2 shows the display screen 7 of the display device 5.
8 is a prompt display area.

FIG. 3 is an explanatory diagram showing the data file structure, and the data file 9 consists of a plurality of pages 10.

Simple language data update command (hereinafter referred to as MP) used in the present invention
The summary of LI (abbreviated as LI) is as follows.

Command Functional explanation MPU...Updates data based on the specified definition for the specified page.

The command MPU consists of the following work procedure.

Work procedure MPtJ - Page specification - Key column specification → Definition specification - Main page - Conditional expression - Sub page - Execution expression The work procedure above is stored in the storage device 3, and is called up by inputting the command MPU from the keyboard 4. It is activated and executed by the control section 2.

As an example of data updating, a case will be described in which the performance table of each branch stored in the data file 9 as shown in Table 1 below is evaluated.

Table 1 Title list page Title 20 Standard table 21 Each branch performance table 30 The 20th page of the evaluation definition data file 9 contains the following 2! ! A standard table for each branch shown in is stored.

(Unit: 1,000 yen) The 21st page of the data file 9 stores the performance table of each branch shown in Table 3 below.

The performance of each branch will be evaluated based on the standard table shown in Table 2, and the degree of performance will be calculated using the following formula.

Furthermore, the degree of performance is ranked in six stages according to its value as shown in Table 4 below.

Table 4 Rank Achievement level A　　　　　　3≦Achievement level B　　　　　　2.5≦Actual performance 3 C2≦Actual performance<2.5 D　　　　　1.5≦Actual score 2 E　　　　　1≦Actual performance 2 F　　　　　　　　　　Achievements

The above calculation formula and the ranking of performance shown in the tjSJ table are stored under the title "Evaluation Definition" in, for example, page #S30 of the data file 9 as shown in Table 5 below.

Table 5 (conditional expression) @Achievements>=3A=@Rank 3>@Achievement>=2.5 B=@Rank 2.5>@
Achievement degree＞=2 C=@Rank 2>@Achievement degree＞=1
．． 5 D=@Rank L5>@Achievement degree>=IE=@Rank 1>@Achievement degree>=3 F=@Rank (Execution expression) % expression % Now, from the keyboard 4 to the prompt display area 8 of the display screen 7, select [ If you input the command rMPUJ while the message "Please input command" is displayed, the control unit 2 calls up the work procedure of the command MPU stored in the storage device 5, activates it, and first displays the prompt. F to area 8
What is the main page? ([M], [S] or page number)" is displayed. As shown in Table 1 above, the ``each branch performance table'' is stored on the 21st page, so input ``21'' from the keyboard 4. Note that [M] displayed in the above prompt display area 8 is a master buffer (not shown).
, [S] indicates a sub-buffer (not shown), and the data stored in the master buffer and sub-buffer are
This ends with specifying the page as the main page.

When the 21st page is designated as the main page using the keyboard 4, the display screen 7 displays the "branch performance table" shown in Table 3 above, and the prompt display area 8 displays "What is the secondary page?" ([M], [S] or page number [RET
Only [URN] is omitted. ] is displayed.

Since the "standard table" serving as the evaluation standard is stored on the 20th page as shown in Table 1 above, "20" is inputted from the keyboard 4. When the secondary page is specified, the prompt display area 8 will display the message “What is the key sequence of the main page?” rR
ETURN] is 1.'' is displayed.

Since we will be evaluating each branch in the second column in the "Each branch performance table" shown in Table 3 above, press "2" from keyboard 4.
Enter. When the key string of the main page is specified, the prompt display area 8 displays “What is the key string of the secondary page? [RETU
Only RN] is 1. " is displayed. Since "branch name" is in the second column in the "standard table" shown in the second table specified as the sub-page, input [2] from the keyboard 4.

When the key column of the secondary page is specified, the prompt display area 8
``What is the page number of the definition table?'' Only ``RETURN'' must be entered from the keyboard. " is displayed. Since the "evaluation definition" is stored on the 30th page as shown in Table 1 above, "30" is input from the keyboard 4. Once the definition table is specified, the "conditional expressions" and "V" shown in Table 5 above are
It is checked whether the execution formula etc. (also referred to as update formula) are correct. If the item is checked, "Update formula checking" is displayed blinking in the prompt display area 8. As a result of the check, if there are no errors, "Can I execute this?" is displayed in prompt display area 8. Yes [Y] / No [N]
"Only [RETLJRN] is Y." is displayed. When you press the rY] or RETURNI key from the keyboard 4, the (conditional expressions) and (executive expressions) shown in Table 5 are executed.
indicates the item name, and "()" indicates that it is a sub page.

While the (conditional expression) and (execution expression) are being executed, "Update processing in progress!" is displayed blinking in the prompt display area 8, indicating to the operator that the processing is in progress.

When the "evaluation definition" shown in Table 5 above is executed, the performance value and its rank will be displayed in the "Performance" and "Rank" items of "Each branch performance table" as shown in Table 6 below. is input.

Table 16 Performance Tables for Each Branch The processing results of these performance levels and ranks are input into the "Each Branch Performance Table" displayed on the display screen 7 and the "Each Branch Performance Table" stored on the 21st page of the data file 9. be done.

The above embodiment shows a case in which a definition table is provided in advance in the data file 9, but next, a case in which a conditional expression and an execution expression are inputted from the keyboard 4 and executed will be explained.

Specify each step of each work procedure by inputting the command MPU from the keyboard 4, and when you finish specifying the key sequence of the sub page, the prompt display area 8 will display the message ``What is the page number of the definition table?'' ``Only RETURNI must be entered on the keyboard.'' is displayed. At this time, from keyboard 4 to l'
When you enter the RETURNJ key, the prompt display area 8
[Conditional expression 1: [Enter only RETURNI.

" is displayed. At this time, the conditional expressions shown in Table 5 above may be input from the keyboard 4. When you finish inputting the (conditional expression) and press the rRETURNJ key from the keyboard 4, the prompt display area 8 will display “Execution expression 1: [RETURNJ]”.
Finish entering only RNI. " is displayed. Similarly, input the (executable formula) shown in Table 5 from the keyboard 4 (6).
After inputting the execution formula), press the rRETt3RNJ key.
When an input is made from the board 4, the prompt display area 8 displays the message ``What is the storage page for the definition table? Only [RETLIRN] is not stored.''

When storing (conditional expressions) and (executive expressions) input from the keyboard 4 as a definition table, input the page number to be stored from the keyboard 4. When the page number is specified, "What is the title?" is displayed in the prompt display area 8, prompting the operator to input the title sill of the definition table. For example, if you enter "Evaluation Definition" as the title from the keyboard 4, the definition table shown in Table 5 above is stored on the specified page, and the prompt display area 8 displays "Can I execute?" Yes [Y] / No [N] [Y for RETURNI only] will be displayed, so you can perform the same operation from now on.

As in the above embodiment, the definitions used for data update can be entered by calling up the page in which the definition table created in advance is stored by specifying them from the keyboard 4, or by inputting the conditional expression or execution expression from the keyboard 4 when updating the data. This is done by inputting .

As described above, in the present invention, by operating the keyboard 4 according to the display displayed for each step of the instruction MPU's work procedure, it is possible to easily perform processes such as updating data.

Note that in Tables 2, 3, and 6, numbers outside the frame indicate rows and columns (effects of the invention).The present invention allows the data update work procedure to be updated at each step by inputting a data update command from the keyboard. displayed for each
The desired data can be updated by specifying and inputting data from the keyboard for each step, so even general users without computer knowledge can update data with simple keyboard operations. be.

[Brief explanation of drawings]

The drawings show one embodiment of the present invention; FIG. 1 is a block diagram, FIG. 2 is an explanatory diagram of a display screen, and FIG. 3 is a diagrammatic explanatory diagram of a data file.

Claims (1)

[Scope of Claims] A means for inputting a data update command, data, etc. in a simple language, a display means for prompting the input means to input a designation of a page to perform data update by inputting a data update command from the input means, A display means that prompts the user to specify a key column for a page by inputting a specified value; a display means that prompts the user to input a data update definition by specifying a key column from the input means; 1. A data update processing device for a simple language, comprising: means for updating data based on .