JPH03158964A - Spread sheet preparing method - Google Patents

Abstract

PURPOSE:To prepare the spread sheet in which input information (information of the other party side) of the other machine kind side is taken into consideration by giving and receiving the data between the machine kinds by procedure data. CONSTITUTION:Procedure data for preparing a spread sheet is inputted by one machine kind 1, and this procedure is brought to on-line transfer to the other machine kind 2. Subsequently, the procedure data brought to on-line transfer is updated by the other machine kind 2. Next, the updated procedure data is brought to on-line return to one machine kind by the other machine kind 2. Thereafter, by one machine kind 1, the spread sheet is prepared, based on the updated procedure brought to on-line return from the other machine kind 2. In such a way, by giving and receiving the data between the machine kinds by the procedure data, the spread sheet in which input information (information of the other party side) of the other machine kind 2 side is taken in consideration is prepared.

Description

DETAILED DESCRIPTION OF THE INVENTION (Field of Industrial Application) The present invention relates to a spreadsheet creation method that allows a spreadsheet to be created quickly and accurately, taking input information from the other model into consideration.

(Prior Art) Conventionally, spreadsheets and the like are created by inputting local information (information that can only be used on that terminal) into a personal computer or workstation. Here, the term "spreadsheet" refers to a table in which various actual data are written in a table format in order to extract necessary data values, and used for spreadsheet calculations.

However, in recent years, there has been an increasing demand for the creation of integrated spreadsheets that include, for example, common information across departments within a company and information grasped by other departments.

In response to this demand, a system has emerged in which distributed database information (actual data) is exchanged between personal computers/workstations. This is because with this method, a spreadsheet can be created based on the actual data sent and received from the other party.

(Problem to be Solved by the Invention) However, in the above-mentioned method of sending and receiving distributed database information between each personal computer/workstation, the sending and receiving of distributed database information is based on the exchange of actual data specified independently by each manufacturer. Therefore, actual data could not be exchanged unless the devices were of the same manufacturer and model. Note that when real data is exchanged between machines of the same model, a spreadsheet can be created based on the real data sent and received from the other machine.

Therefore, actual data cannot be exchanged between different models (models from different manufacturers or other models from the same manufacturer) due to differences in protocols, data formats, interfaces, communication line speeds, etc. . For this reason, there is a problem in that when using different models, it is not possible to create a spreadsheet that takes into account input information from the other model.

SUMMARY OF THE INVENTION Therefore, an object of the present invention is to provide a spreadsheet creation method that can quickly and accurately create a spreadsheet that takes into account input information from the other model.

(Means for Solving the Problems) The spreadsheet creation method of the present invention is a data exchange system that exchanges data between models, in which procedural data for creating a spreadsheet is input in one model, and the procedure Transfer the data online to the other model, update the procedure data that has been transferred online in the other model, and send it back online to the one model, and send it back online from the other model in the one model. A spreadsheet is created based on the updated procedure data that has been updated.

(Function) Input procedural data for creating a spreadsheet on one model, and transfer this procedural data online to the other model. Next, the procedure data transferred online is updated on the other model. Here, for example, when exchanging data between machines of the same model, a spreadsheet is created based on the procedure data in the other model, and the procedure data is updated based on this. Further, for example, when exchanging data between different models, the other model displays the procedure data on a CRT display screen and updates the procedure data based on database information.

Next, the other model sends the updated procedure data back to one model online.

Next, one model creates a spreadsheet based on the updated procedure data sent back online from the other model.

In this way, since data is exchanged between models using procedure data, data can be easily exchanged even between different models. Therefore, one model can obtain update procedure data that takes into account the input information of the other model, and this allows the input information of the other model (
It is possible to create a spreadsheet that takes into account the other party's information), allowing it to respond to the demands of the times.

In addition, since data is exchanged between models using procedural data, the length of the transferred data is short, resulting in faster processing times and fewer errors on the communication line. Quickly upload your spreadsheets.
and can be created accurately.

(Example) Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 shows an embodiment of the spreadsheet creation method according to the present invention, particularly when applied to the same model.

In the figure, 1 is the terminal (A) side, and 2 is the terminal (B) side.
) side. On the terminal (A) side 1, 3 is the terminal (A)
It consists of a personal computer or workstation. Further, 4 is a hard disk, but the present invention is not limited to this, and any storage medium such as a flexible disk may be used.

Further, on the terminal (B) side 2, 5 is a terminal (B), which is composed of a personal computer or a workstation.

Further, 6 is a hard disk, but the present invention is not limited to this, and any storage medium such as a flexible disk may be used.

Note that the model of the terminal (A) 3 and the model of the terminal (B) 5 are the same model, and the terminal (A) 3 and the terminal (B) 5 are connected online.

Next, the operation will be explained with reference to FIGS. 4 to 6.

Furthermore, Figure 4 is a diagram showing an example of the created spreadsheet.
FIG. 5 is a diagram showing an example of a procedure file in which the spreadsheet creation procedure of FIG. 4 is registered, and FIG. 6 is an explanatory diagram showing an example of a procedure file updating method.

If you try to create a spreadsheet as shown in Figure 4 on terminal (A) side 1, use the keyboard to input the spreadsheet from terminal (A) 3 while looking at the spreadsheet in Figure 4. . Here, while looking at the spreadsheet in Figure 4, enter the "product name" in cell A1, the "unit price" in cell B1, and so on in the format shown in Figure 5 (A). In particular,
Enter the procedure for creating a spreadsheet.

Next, the input procedure input based on the control of the control unit of the terminal (A) 3 is registered in a file (referred to as a procedure file) provided on the hard disk 4. Here, the procedure file refers to a file in which procedures to be executed to create a table are registered as one file, or a file in which the procedure is registered.

When the input procedure for creating a spreadsheet as shown in FIG. 4 is registered in the procedure file provided on the hard disk 4, the result will be as shown in FIG. 5(A). In FIG. 5(A), numbers 2 to N11L9 are word inputs for each cell in FIG. 4, numbers 410-No and 15 are data inputs for each cell in FIG. The steps up to this point involve registering calculation formulas for calculating the values of each cell in FIG. 4, and step 20 actually performs calculations and displays the values in the cells in FIG.

Next, the control unit of the terminal (A) 3 transfers the content of the procedure file registered in the hard disk 4 online to the other terminal (B) 5, and the control unit of the terminal (B) 5 transfers this to the hard disk 6. Register in the created procedure file.

Next, the terminal (B) 5 executes the transferred procedure data and creates a spreadsheet. here,
The control unit of the terminal (B) 5 is programmed to create a spreadsheet from the contents of the procedure file. Therefore, the terminal (B) 5 can create a spreadsheet as shown in FIG. 4 from the contents of the procedure file as shown in FIG. 5(A).

Next, once the spreadsheet has been created on terminal (B) 5, while looking at the spreadsheet screen displayed on the CRT display screen, use the keyboard to change the spreadsheet or enter data as necessary. Modify the procedure to add. For example, if you want to change the "pencil" in cell A2 to "fountain pen" and the unit price in cell B2 from rloooJ to rlooo in the spreadsheet in Figure 4, use 1 in the procedure file in Figure 5 (A).
Rewrite the parts lh6 and 10 to create a procedure file as shown in Figure 5 (B).

Next, the control unit of the terminal (B) 5 registers the modified procedure file as shown in FIG. 5(B) in the procedure file on the hard disk 6.

Next, the control unit of the terminal (B) 5 sends back the contents of the procedure file registered in the hard disk 6 as shown in FIG. 5(B) online to the terminal (A) 3. Terminal (A) 3
The control unit registers the contents of the returned procedure file in the procedure file on the hard disk 4. next,
The terminal (A) 3 retrieves the contents of the returned procedure file from the hard disk 4, executes the procedure, and creates a spreadsheet. Here, terminal (A)
3 is programmed to create a spreadsheet from the contents of the procedure file. Therefore,
Here, in the spreadsheet in Figure 4, cell A2 is "
You can create a spreadsheet with 0 changes from ``Pencil'' to ``Fountain Pen J, -t'/1zB2+7) Unit Price R100'' and Color ``1000''.

As can be seen from the above explanation, when exchanging procedure data between the same models in Figure 1, the other terminal (B)
5 can create a spreadsheet by executing the procedure data transferred online, and can display this spreadsheet on the screen of a CRT display. You can update the contents of the procedure file using the keyboard while viewing the spreadsheet screen. Then, the terminal (B) 5 sends the updated procedure data back to the terminal (A) 3 online. At terminal (A) 3,
A spreadsheet can be created by executing the updated procedure data. In this way, devices of the same model have the same protocols, data formats, interfaces, communication line speeds, etc.
Both A) 3 and terminal (B) 5 can create a spreadsheet from the procedure data.

FIGS. 2 and 3 show other embodiments of the spreadsheet creation method according to the present invention, particularly when applied to different models (different models).

In FIG. 2, 11 is the model (A) side, and 12 is the model (B) side. On the model (A) side 11, 13 is the model (A), which is composed of a host computer, an office processor, other workstations, and the like. Further, although 14 is a hard disk, the present invention is not limited to this, and any storage medium such as a flexible disk may be used.

Further, on the model (B) side 12, 15 is the model (B), which is composed of a host computer, an office processor, other workstations, and the like. Further, although 16 is a hard disk, the present invention is not limited to this, and any storage medium such as a flexible disk may be used.

Note that the model (A) 13 and the model (B) 15 are different models, and the model (A) 13 and the model (B) 15 are connected online.

Next, the operation will be explained with reference to FIGS. 4 to 6. When an attempt is made to create a spreadsheet as shown in FIG. 41 on the model (A) side 11, input procedures for the spreadsheet are performed on the model (B) 13 using the keyboard while looking at the spreadsheet shown in FIG. Here, while looking at the spreadsheet in Figure 4, write cell A1 in the format shown in Figure 5 (A).
Enter the "product name" in , enter the "unit price" in cell Bl,
... Enter the procedure for creating a spreadsheet in the same way as when using the same model.

Next, under the control of the control unit of the model (A) 13, the input procedure is registered in a file (referred to as a procedure file) provided on the hard disk 14. When the input procedure for creating a spreadsheet as shown in FIG. 4 is registered in the procedure file provided on the hard disk 14, the result will be as shown in FIG. 5(A). Regarding FIG. 5(A), it is as described above.

Next, the control unit of model (A) 13 controls the hard disk 14
Transferring the contents of the procedure file registered to another model (B) 15
The control unit of model (B) 2 15 registers this in the procedure file provided on the hard disk 16. Therefore, the contents of the procedure file for model (A) 13 and the procedure file for model (B) 15 are the same. Therefore, hard disk 1
In the procedure file above 6, the contents of the procedure file shown in FIG. 5(A) are registered.

Next, necessary data (actual data to be added to the spreadsheet) is extracted from the database 17 of the model (B) 15. Here, the actual data is the data that is actually required, and the procedure data is the procedure itself that is executed to create the table, which is the registered content of the procedure file.
It is predetermined. In this example, database 17
As shown in FIG. 6, the quantities of pencils, erasers, and compasses are extracted as 10 and 15.20, respectively.

Next, the control unit of the model (B) 15 executes the procedure 3 transferred online, which is registered in the procedure file (this will be referred to as procedure file (A)) on the hard disk 16, as shown in FIG. 4 Database 17 is added to the procedure data extracted from the data.
The extracted data is added to form a procedure file (B) as shown in the figure, and the contents of this procedure file (B) are registered in the procedure file on the hard disk 16 (
(See Figure 3). In addition, when extracting procedure data from the procedure data of procedure file (A), CR
The contents of the procedure file (A) are displayed on the T-display screen, and the procedure is performed while looking at the CRT display screen.

Next, the control unit of the model (B) 15 sends back the contents of the updated procedure file to the model (A) 13 online.

The control unit of model (A) 130 transfers this to the hard disk 14.
Register in the procedure file above.

Next, the model (A) 13 executes the procedure according to the returned procedure data and creates a spreadsheet. In this example, in the spreadsheet of FIG. 4, cell C2 is 10. A spreadsheet with cell C3 changed to 15 and cell C4 changed to 20 can be created.

As can be seen from the above explanation, when exchanging procedure data between different models in Figure 2, the procedure data that is the content of the procedure file created in one model (A) 13 is transferred to the other model (B). Even if 15 receives the procedure data, the procedure data can be displayed on one screen of the CRT display, but a spreadsheet cannot be created. In other words, even if model (B) 15 receives the procedure data created by model (A) 13, there are differences in protocols, data formats, interfaces, communication line speeds, etc. based on the differences in models. Therefore, the procedure data cannot be executed and therefore the spreadsheet cannot be created.

Therefore, in model (B) 15, the procedure data transferred online is displayed on the CRT display screen. Then, while looking at the procedure data on the CRT display screen, read the database 17 on the model (B) side 12.
Add the actual data extracted from the procedure file (A) to the procedure data extracted from the procedure file (A) as shown in Figure 3 (or
The procedure data can be updated by replacing the corresponding part of the procedure data with actual data from the database 17). Model (B) 15 sends this updated procedure data back to model (A) 13 online, and model (A) 13 executes the updated procedure data sent back online and executes the updated procedure data in real time. Can create spreadsheets. This is because the model (A) 13 can create a spreadsheet by executing procedure data before update and procedure data after update.

As described above, in the present invention, since data is exchanged between models using procedure data, data can be easily exchanged even between different models. Therefore, one model side can obtain update procedure data that takes into account the input information of the other model side, and this allows a spreadsheet that takes into account the input information of the other model side (information on the other side). 1 that meets the demands of the times.
Nito is made.

In addition, since data is exchanged between models using procedural data, the length of the transferred data is short (for example, actual data may be 30 to 40 KB, but procedural data may only be about IKB), which results in faster processing times. Since errors on the communication line are also reduced, it is possible to quickly and accurately create a spreadsheet that takes into account input information from the other model.

(Effects of the Invention) As described above, if the present invention is used, the following various effects can be achieved.

(1) Since data is exchanged between models using procedural data, data can be easily exchanged even between different models. Therefore, one model side can obtain update procedure data that takes into account the input information of the other model side, and this allows a spreadsheet that takes into account the input information of the other model side (information on the other side). can be created and respond to the demands of the times.

7 8 (2) Since data is exchanged between models using procedural data, the transfer data length is short, processing time is fast, and errors on the communication line are reduced, so input information on the other model side is Quickly create spreadsheets that take into account
and can be created accurately.

[Brief explanation of the drawing]

Fig. 1 is an explanatory diagram showing one embodiment of the spreadsheet creation method according to the present invention, Figs. 2 and 3 are explanatory diagrams showing other embodiments of the invention, and Fig. 4 is an explanatory diagram showing an example of the spreadsheet creation method. Figure 5 is a diagram showing an example of a procedure file in which the spreadsheet creation procedure shown in Figure 4 is registered;
The figure is an explanatory diagram showing an example of a method for updating a procedure file. 3...Terminal (A), 4.6, 14.16...Hard disk, 5...Terminal (B), 13...Model (A), 15...Model (B)
), 17...Database. Book DENPYO Al: Product name B1: Unit price C1: Quantity D1 = Amount A2: Pencil A3: Eraser A4: Compass A5: Total B2: 100 B3: 50 B4: 300 C2: 10 □ - C3: 15 Ha J + M □

Claims (1)

[Claims] In a data exchange system that exchanges data between models, procedure data for creating a spreadsheet is input in one model, this procedure data is transferred online to the other model, and the other model includes: update the procedure data that was transferred online by the other model and send it back online to the one model, and use the one model to update the procedure data that was sent online from the other model. A spreadsheet creation method characterized by creating a spreadsheet.