JPH04102167A - System for data communication between spread sheets - Google Patents

Abstract

PURPOSE:To exchange the same data between plural owners by inputting the owner name of a spread sheet from an input part by a data operation part and identifying the owner by a table preparation part. CONSTITUTION:An input part 1 inputs data for operating or calculating the spread sheet and various data for data communication, and a table preparation part 2 works / updates the spread sheet for each user. A table data preservation part 3 preserves the prepared or updates spread sheet, and a data display part 4 displays the contents of the prepared or preserved spread sheet. Then, a data operation part 5 inputs the owner of the prepared spread sheet, identifies the owner of the preserved spread sheet and operates data between the spread sheets of owners. Thus, the data can be easily managed between plural users.

Description

DETAILED DESCRIPTION OF THE INVENTION The present invention relates to a data communication system for communicating the same data between a plurality of spreadsheets.

Shigeru Takemai In recent years, the basics of LAN and e-mail have been established, and it has become possible for multiple members to work together. Software that helps people work in groups like this is called group software.

We also use spreadsheets (sp) as data processing software.
"ead 5heet" is popular, and it is very meaningful that it can be used as groupware like this. A software system that calculates, displays, etc. according to the rules created and input data on the sheet.

However, spreadsheets can only process personal data, so when dealing with data from a group of multiple users, the system is unable to handle it, and the work still relies on humans.

In other words, when using a spreadsheet to refer to data on multiple spreadsheets and perform aggregation work on another spreadsheet, the data to be aggregated must be obtained in some way, and all of the data must be manually compiled. Either input the data into a spreadsheet, or refer to it from another spreadsheet by fixing the position of the data to be aggregated on the spreadsheet.

Traditionally, when using spreadsheets as groupware, when you create multiple spreadsheets and there is a change in data in at least one of the spreadsheets, all cells affected by the change are ; Ce1l refers to the area delimited and surrounded by vertical and horizontal lines on the spreadsheet) data must be changed across all referenced spreadsheets.

If all the data were processed manually, operations would become complicated when the amount of data became large, leading to operational errors.

Also, if you reference a fixed cell in another spreadsheet, the position of the referenced cell may change due to operations such as inserting or deleting rows or columns on the referenced spreadsheet. This makes it impossible to refer to accurate data. These factors have made it difficult to manage data for multiple users using spreadsheets.

The present invention was made in view of the above-mentioned circumstances.
The purpose of this invention is to provide a data communication method between spreadsheets that allows multiple users to always send and receive the latest data when they create multiple spreadsheets.

In order to achieve the above object, the present invention provides (1) an input section for inputting data etc. in a spreadsheet, a table creation section for creating spreadsheet data, and a table creation section for creating the spreadsheet data. In the spreadsheet creation system, the spreadsheet creation system includes a table data storage unit for storing a spreadsheet created by the table creation unit, and a data display unit for displaying the spreadsheet created by the table creation unit, the data operation unit comprising: The name of the owner of the spreadsheet is input from the input section, and the owner is identified in the table creation section, so that the same data can be sent and received between multiple owners; and (2) ) The data manipulation section is characterized in that the data manipulation section assigns the same name to a plurality of cells having the same data and manipulates the data. An explanation will be given below based on one embodiment of the present invention.

FIG. 1 is a block diagram for explaining an embodiment of the data communication method between spreadsheets according to the present invention.
2 is an input section, 2 is a table creation section, 3 is a table data storage section, 4 is a data display section, and 5 is a data operation section.

The input unit 1 inputs various data for spreadsheet operations, calculation data, and data communication. The table creation unit 2 works and updates a spreadsheet for each user. The table data storage unit 3 stores spreadsheets created or updated.

The data display section 4 displays the contents of a spreadsheet that has been created or saved. The data manipulation unit 5 inputs the owner of the created spreadsheet, identifies the owner of the saved spreadsheet, and performs data manipulation with the spreadsheet between the owners.

A spreadsheet has two sides separated by vertical and horizontal lines. The area surrounded by this line is called a cell. The user creates a table using this Cs1l arranged in a uniform manner vertically and horizontally. A horizontal row is called a row, and a vertical row is called a column.

Each Row, (:olu+wn) is given a number or name.

As an example, a company sells three types of products, A and B.

C to three branches C1tyl, C1ty2, C
Suppose that it is sold at 1ty3. Here, it is assumed that each district organizes the sales of each product every week, and reports the week's sales for each product to the head office on weekends. Create such a spreadsheet as follows.

(1) First, a spreadsheet for the head office (manager) is created by the table creation section. FIG. 3 is a diagram showing a table for this manager. The Total shown in FIG. 3 is the total for each product and each branch. Also 5Grand To
tal is total sales. Since the sales of each branch have not yet been entered, all of these values are complete.

(2) Define cell names on the manager's spreadsheet, as shown in Figure 4.
, .

5ales 2, ... are the names of the cells, and B
2. B3, . . . represent the positions of cells on the spreadsheet.

(3) Manager file (mana) is saved in the table data storage section.
Head office (manager) to save as ger file)
saves the file, the manager file (man
In addition to ager file, e), one more file is created. This file is a file for exchanging data between one head office and each branch office, and is called a 1ink file. The 1ink file is the 1ink file shown in Figure 5.
It stores naIIIe and data.

(4) Create a spreadsheet for each branch (user) in the table creation section. FIG. 6 shows a table for the user. In the cells of the total column corresponding to each product, as shown in Figure 7,
Write the same name as the cell name defined in the manager's spreadsheet.

Sales of each product are input for each day of the week as shown in FIG.

(5) In the table data storage section, the user file (userf
ile). Change the file name of yaanager file indicating the spreadsheet group to the 9th
When each branch (user) saves a file by inputting as shown in the figure, a user file is created, and at the same time, search for the 1ink name in your own spreadsheet from this 1ink file, and save the same 1ink file.
If there is a name, the data contained in that cell in the spreadsheet of the data part of the N, nk file is written. 1ink file after changing this data
e is shown in FIG.

(6) Reopen the spreadsheet for the head office (manager).

(7) Refer to the 1ink file on the disk and select the cell whose name is defined in the cell whose data has been changed.
The changed data is displayed as shown in FIG.

If you create these files in this way, each branch will create the user file (Cj, ty
1.

When the data in C1ty 2, C1ty 3) is rewritten, the data is automatically sent to the spreadsheet at the head office (manager).

FIG. 2 is a flowchart showing the processing flow of the data communication method between spreadsheets according to the present invention. Below, each step will be explained in order.

This system for creating a 7-spread sheet is activated.

Company: Enter the file to save the spreadsheet data as a file.

% ; Based on the file name input in step 2 above, it is determined whether it is an existing file or a new file to be registered.

Determine whether the owner of an existing file is a manager or a user.

If the owner of the existing file is a manager, open the file as a spreadsheet for the manager.

Katsura call and; the data communication file that was already created when creating the file for the existing manager (link f
ile).

7i The data saved in the manager file opened in step 5 above and step 6 above
A spreadsheet for the manager is displayed from the data saved in the communication file opened in .

Katsurafudan; In step 4 above, if the owner of the existing file is a user, open the file as a spreadsheet for the user.

5. Identify the user's manager file name saved in the user file opened in step 8.

The communication file belonging to the manager file identified by the owner in step 9 above (link
file).

Data stored in the user file opened in step 8 and the data saved in the user file opened in step 8
It is saved in the communication file opened with o.
A spreadsheet is displayed for the user based on the data.

Master: Determine whether there is data input.

If the user does not enter new data into the user spreadsheet, the process ends.

User enters new data into user spreadsheet.

7; Save the data input in step 13.

%; The data saved in step 5 is saved in the user file.

Go here” -; The data input in step 13 above.

When the communication file is in a cell with a cell name, the data part in the communication file is replaced with that data and saved.

In step 3 above, if the input file name is one to be newly registered, define the name of the reference cell for communication between the manager's spreadsheet and the user's spreadsheet.

Determine the owner of the newly created table.

Discharge owner: If the owner is a manager, it will be saved as a file for the manager.

nλ"-; If a spreadsheet name is not entered at startup, enter a file name for the manager. If entered, the spreadsheet name will be used as the file name for the manager.

%Up: A new file for the manager is saved.

A new communication file will be saved.

q; In step 18, if the owner is a user, the user inputs data into the spreadsheet.

If the spreadsheet name is not entered at startup, enter the file name for the user. If entered, the spreadsheet name will be used as the file name for the user.

Enter the name of the manager file to be communicated with.

The data entered in step 23 and the created spreadsheet are newly saved in the user's file.

When the data input in step 23 is in a cell with a cell name, the data part in the communication file is replaced with the data and saved.

In this way, when multiple users create multiple spreadsheets, the latest data is always sent and received.

As is clear from the above description, according to the present invention, the same data can be sent and received between multiple spreadsheets, and data management among multiple users is facilitated. Furthermore, the manual input required to change the position or content of data in a single spreadsheet is eliminated, and input errors are also reduced.

[Brief explanation of drawings]

FIG. 1 is a block diagram for explaining an embodiment of the data communication method between spreadsheets according to the present invention, and FIG.
A flowchart showing the processing flow of the data communication method between spreadsheets according to the present invention, FIG. 3 is a diagram showing a table for managers, FIG. 4 is a diagram showing cell definitions of the table for managers, and FIG. is a diagram showing a 1ink file,
Figure 6 is a diagram showing a table for users, Figure 7 is a diagram showing cell definitions of a table for users, Figure 8 is a diagram showing an example of data input, and Figure 9 is a diagram showing a table for users. FIG. 10 is a diagram showing a 1ink file after data has been changed, and FIG. 11 is a diagram showing a table for the manager after data reception. ], Input section, 2. Table creation section, 3. Table data storage section, 4. Data display section, 5. Data operation section.

Claims (1)

[Claims] 1. An input section for inputting data etc. in a spreadsheet, a table creation section for creating spreadsheet data, and a means for storing the spreadsheet created by the table creation section. In a spreadsheet creation system having a table data storage unit and a data display unit for displaying the spreadsheet created by the table creation unit, the data operation unit inputs the owner name of the spreadsheet from the input unit. A data communication method between spreadsheets, characterized in that the same data is transmitted and received between a plurality of owners by inputting the same data and identifying the owner in the table creation section. 2. The data communication system between spreadsheets according to claim 1, wherein the data manipulation section assigns the same name to a plurality of cells having the same data and manipulates the data.