JP2006053689A - Time series data display system, and program for time series data display - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily create charts of a wide variety of forms desired by users on the basis of various time series data such as economic statistics data provided from a database company or the like. <P>SOLUTION: A data code specifying the type of the time series data, and a set of functions functioning on spreadsheet software, capable of specifying a constant, a function, and cell reference as a parameter, and including at least a data reading function functioning to read one predetermined time series data from a database, and returning it to the spreadsheet software as a function value are prepared beforehand. When the data reading function is described in a cell on a worksheet, the data code and a particular point of time are recognized from its parameter, the database is searched to specify corresponding individual data, the data are read from the database and sent to a client terminal, and by returning the data as a function value to the data reading function, the data can be used on the spreadsheet software. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a system and a computer program for displaying various time series data such as economic statistical data stored in a database on a worksheet of so-called spreadsheet software.

  The economic statistical database service is a business that provides economic statistical data that is open to the public for a fee. The source of paying for free is to collect as much economic data as possible and provide it centrally, thereby minimizing the user's effort to collect data. Especially in the research section of companies that handle large amounts of data for economic analysis, forecasting, report creation, etc., the data collection cost is enormous and the utility value of the economic statistical database service is high.

  However, as economic statistical data is released on the Internet, the labor of collection becomes less difficult than before, and it can be said that the value of the economic statistical database has decreased.

  Now, in using economic statistical data, it takes time to collect the data together with the work of converting the acquired data into a format that one wants to express, specifically, the work of creating tables and graphs. Each database company provides data in the form of tables and graphs, but it is impossible to prepare all the various tables that users require. For this reason, the user is still forced to take the table provided by the database company into his / her spreadsheet software and convert it again into his / her favorite expression format. Therefore, this reduction in labor is hardly solved by the existing economic statistical database service.

  An object of the present invention is to provide a system that makes it possible to easily create a table in various forms desired by a user based on various time series data such as economic statistical data provided by a database company, etc. To provide a computer program.

In order to solve the above-described problems, the present invention reads specific time-series data from a database storing a plurality of time-series data, and can be used on a spreadsheet of spreadsheet software operating on a client terminal. A computer program for
A set of functions that function on the spreadsheet software and can specify constants, functions, and cell references as parameters, and read out one of the predetermined time series data from the database and use it as a function value As a set of functions including at least a data read function that functions to return to the spreadsheet software in advance, a data code that identifies the type of time-series data is prepared in advance,
When the data read function is described in a certain cell on the worksheet,
A first function for recognizing a data code and a specific time point from a parameter of a data read function described in the cell;
A second function for searching the database based on the data code and the time point recognized by the first function and identifying the corresponding individual data;
Realizes a third function that enables use on spreadsheet software by reading the individual data specified by the second function from the database, transferring it to the client terminal, and returning it to the data read function as a function value It is characterized by making it.

Further, the function set includes an attribute information read function that reads the attribute information of the time series data stored in the database together with the time series data and returns it to the spreadsheet software as a function value. ,
When the attribute information read function is described in a cell on the worksheet, the computer
A fourth function for recognizing a data code and a specific attribute from the attribute information read function described in the cell;
A fifth function for searching the database based on the data code and the attribute recognized by the fourth function and identifying the corresponding individual data;
A sixth function that enables use on spreadsheet software by reading the individual attribute data specified by the fifth function from the database, transferring it to the client terminal, and returning it to the attribute information read function as a function value; ,
Is preferably realized.

Furthermore, the data read function can have a time designation parameter for designating a specific time point, and an operation designation parameter for designating an operation to be performed on a plurality of data,
When the data read function is described together with the time specification parameter and the operation specification parameter in a certain cell on the worksheet,
A seventh function for recognizing a plurality of time points obtained from a data code, a time point specifying parameter and a calculation specifying parameter from the parameters of the data read function described in the cell;
An eighth function that searches the database based on the data code recognized by the seventh function and a plurality of time points, and identifies a plurality of corresponding individual data;
A ninth function of reading a plurality of individual data specified by the eighth function from the database and transferring the data to a client terminal, and executing the specified operation on the plurality of individual data;
A tenth function enabling use on a spreadsheet software by returning the result calculated by the ninth function as a function value to the data read function;
It is recommended to make it realize.

  The above computer program connects a database server that controls a database storing a plurality of time-series data, a client terminal in which spreadsheet software is operated, and the database server and the client terminal. By operating on hardware provided with a computer network, a time-series data display system having a predetermined effect can be constructed.

  An embodiment of the present invention will be described below with reference to the drawings. The method and program of this embodiment are realized by incorporating a newly developed predetermined add-in program into “Excel” (registered trademark of Microsoft Corporation), which is a spreadsheet software of Microsoft Corporation. Thereby, the user of Excel can operate in the operating environment equivalent to Excel.

  FIG. 1A is a functional block diagram showing the configuration of the entire system according to this embodiment. In the figure, a database server 10 is a server prepared by a database vendor that provides customers with time series data such as economic statistical data, and has a statistical value master database 11 and an attribute information master database 12. Yes. The client PC 13 is a client terminal of a user (also a database vendor customer) of the system according to the present embodiment. The database server 10 and the client PC 13 are connected via the Internet 20. However, the network connecting the database server 10 and the client PC 13 is not limited to the Internet, and may be an intranet or other network.

  Spreadsheet software (Excel) is installed in the client PC 13. In this spreadsheet software, a computer program 14 “INDB-II” is incorporated in the form of an add-in. INDB-II is a central part of the system according to the present embodiment and has various functions. Among these, INDB-II has a function of controlling a newly prepared function (hereinafter referred to as “INDB-”). II "is also referred to as" program 14 of this embodiment "). This will be described in detail later.

  In addition, the client PC 13 is provided with a statistical value cache database 15 and an attribute information database 16. These databases have a function of temporarily storing data provided from the database server 10. The reason why the statistical value cache database 15 and the attribute information database 16 are provided is to shorten the time for data transfer from the database server 10, and is not essential depending on how the system is designed.

  FIG. 1B is a table showing data update timings and data units to be updated in various databases included in FIG. As shown in the table, the statistical value master database 11 and the attribute information master database 12 included in the database server 10 are both updated when information is announced, and only changed information is added or changed.

  The statistical value cache database 15 included in the client PC 13 is empty in the initial state where the system is installed, and when the data update is performed on the program 14 of the present embodiment, the necessary data is updated or accumulated in the client PC 13. Have been to. On the other hand, the attribute information database 16 included in the client PC 13 is the same as the attribute information master database of the database server 10 in the initial installation state of the system. Every time data is updated on the program 14 of this embodiment, the database server 10 is completely synchronized.

  In addition to the name, unit, and source of the time series data, the attribute information includes a tabulation method specific to the time series data (for example, if you want to view monthly production quantity data as annual data, use monthly data. If you want to see the monthly stock price information on an annual basis, “average” the monthly data.Convert the monthly determined by the type of such time series data into annual etc. For example).

[Representation of data by function]
In the program 14 of the present embodiment, a function “indbs” is prepared in order to acquire time series data from a database. This function can use, as parameters, a data code that specifies the type of time-series data, which will be described later, and a specific time that is a component of the time-series data. What can be realized by using this function will be described in comparison with the conventional method. Here, “conventional method” means a method in which execution is performed using only the functions originally provided in the conventional format = standard table and “Excel” obtained by the program provided by the database vendor. .

  Figure 2 is a time-series table that shows the most recent changes in the unemployment rate on a monthly, quarterly, and annual basis. Consider a case where such a time series table is obtained from necessary data from the database server 10 in which various time series data is stored and displayed on a worksheet operating on the client PC 13.

  FIG. 3 shows a state in which the user inputs necessary information to the worksheet on his client PC 13 based on the program 14 of the present embodiment in order to display the time series table shown in FIG. FIG. 4 shows a state in which functions necessary for displaying the table of FIG. 2 and related information are input according to the conventional method. Both are screens in a display state in which the formula of each cell is displayed by the function of the spreadsheet software. 3 and 4, both seem to contain complicated mathematical formulas, but the labor required to create them is very different.

  For example, in FIG. 2, the D4 cell wants to display the value of the unemployment rate as of January 2003 (specified by the C4 cell).

  [= Indbs ($ B $ 3, $ C4)] is described in the D4 cell of FIG. Here, the function “indbs” is a function that retrieves data from the database as described above. And the description “($ B $ 3, $ C4)” in the parameter part is time series data corresponding to the data code “LAF & URS” described in the B3 cell (this “LAF & URS” represents the complete unemployment rate). Is a data code) at a specific time (January 2003) described in the C4 cell. In this example, only two parameters are used, but in reality, up to six parameters can be specified in this function as will be described later.

  In each of the cells D5 to D15 in FIG. 3, the function “indbs” and parameters similar to those of the D4 cell are described in the same manner. The program 14 of this embodiment interprets the function described there for each cell in this way, extracts individual data from the database, and passes it to Excel as a function value. Excel displays the value in the specified cell (in this case, the cell in which the function is described). In this way, a function can be described for each cell, and time series data desired to be displayed in that cell can be specified. Therefore, from the user's point of view, the designation method is straightforward and very easy to understand. This is a characteristic point of the program of this embodiment.

  Note that the numbers displayed in the cells C4 to C22 are specific to Excel in which date data is displayed as a numerical value when Excel is displayed in the function display state. Date data as shown in FIG. 2 is stored.

  On the other hand, in order to create a time series table as shown in FIG. 2 by the conventional method, first, separately from FIG. 2, the original data is put on a sheet as a standardized table by a program provided by a database vendor. The procedure of outputting and extracting data in the form of a link from this table is required. FIG. 5 is an example of this original table. That is, when retrieving data from the database server 10, only retrieving as a standard table with a prepared pattern is supported, and retrieving individual data is not supported.

  Looking at the D4 cell in FIG. 4, [= A! B46] is described. This specifies that the value of cell B46 of the worksheet shown in FIG. Although this description itself is simple, there is no meaning in the “worksheet B46 cell” in FIG. 5, and the user knows that the target value is contained in the B46 cell of the sheet in FIG. 5. It is necessary to grasp and describe it. Although it is a simple designation, it is a designation that is only a link to another sheet and has no meaning in itself, so it is difficult to understand and maintenance is difficult.

  Next, consider the D16 cell of FIG. Here, the quarterly averaged values are displayed based on monthly figures. The program 14 of the present embodiment has a function of extracting a plurality of predetermined time-series data from the database to the data reading function “indbs”, performing a predetermined operation on them, and returning the operation result to Excel. Is given. By using this function, even if only the monthly data is stored in the database, the quarterly average value can be displayed based on the monthly data.

  Specifically, in order to display the quarterly averaged value in the D16 cell, [= indbs ($ B $ 3, $ C16 ,,, "quarter")] is designated as shown in the D16 cell of FIG. Here, the program 14 of the present embodiment recognizes the data code from the first parameter, recognizes that the quarter average of the data is taken from the fifth parameter, and takes the quarterly average from the second parameter. It recognizes the time of 3 months (the year ended March 2003) (in this example, the third, fourth, and sixth parameters are not specified). Based on this, the database is searched, the corresponding three-month data is read out and transferred to the client terminal, and the calculation for calculating the average is performed on the three-month data, and the result is returned to Excel as a function value. . Excel displays this function value in the cell specified by the function. The series of processes described above can be performed with only one function “indbs”. This way of designation is also very straightforward.

  On the other hand, in the conventional method, [= AVERAGE (A! B46: B48)] is designated as shown in the D16 cell of FIG. Although this is a simple designation itself, it means that the values from the B46 to B48 cells of the sheet of FIG. 5 are averaged, and the necessary data from the B46 to B48 cells of the sheet of FIG. It is essential for the user to know that it is in.

  Finally, consider cell F20 in FIG. Here, the annual average of the figures released in the month and the rate of growth compared to the previous year are displayed. In the program 14 of the present embodiment, [= indbs ($ B $ 3, $ C20, “previous ratio” ,, “calendar year”)] is input as shown in the F20 cell of FIG. This is the result of averaging the numerical values of the time series data (first parameter) specified by the data code contained in cell B3 (calendar year) (fifth parameter), and calculating the previous period (third parameter), C20 This indicates that the value at the time point specified in the cell (year ended December 2000) (second parameter) is displayed. In this example, the fourth parameter is omitted. This is also a simple and clear specification.

  On the other hand, in the conventional method, [= (AVERAGE (A! B22: B33) / AVERAGE (A! B10: B21) -1) * 100] is designated as shown in the F20 cell of FIG. Although explanation of the meaning of this description is omitted, it is a calculation using values stored in 24 cells from B10 to B33 of the sheet of FIG. 5, and it is necessary to understand this. That is, it is necessary for the user himself / herself to always make a mathematical formula while being aware of the form of the sheet in FIG. 5, and this makes it difficult to specify and understand.

  For example, when actually creating a quarterly table, in the method of this embodiment, after inputting three cells from D16 to F16, the function is copied and pasted into each cell of D17 to F19 to correct the date. Just do it.

  On the other hand, in the conventional method, all the equations (for 12 cells) must be input one by one while confirming the address of the cell to be linked. In the example of FIG. 2, the number of time points is 4, so that the labor required for input is not so much even in the conventional method. However, if this is, for example, 80 points for 20 years, input will require considerable effort and labor. When the same thing is executed by the method of this embodiment, it can be easily executed by copy and paste.

  Furthermore, since time-series data increases with time, generally, even a table once created needs to be maintained as needed. In the system of the present embodiment, the direct expression is adopted, so that the mathematical formula described in the cell can be easily reviewed. On the other hand, in the conventional method, it is difficult to understand how the link is made to the original table, and therefore, it is difficult to cope with the increasing time series data as compared with the method of the present embodiment.

  In addition, according to the system of the present embodiment, if a time series table for certain time series data is created, a similar time series table can be easily created for different types of time series data. For example, FIG. 2 is a time series table for the unemployment rate, but when it is desired to create a time series table similar to FIG. 2 for another type of time series data, it is described in the B3 cell. It is only necessary to change the data code to another data code. Fig. 6 is a time series table showing the transition of automobile production volume. This is the data code "LAF & URS" described in cell B3 of the time series table for the complete unemployment rate in Fig. 2 and represents the automobile production volume. It can be obtained simply by changing the data code to “I04060PDQ”.

  On the other hand, when trying to do the same with the conventional method, it is necessary to replace the original table shown in FIG. 5 with a table showing the transition of the automobile production quantity. There are various methods for this replacement depending on the service provided by the database vendor, but at least compared to the simple procedure of replacing the data code described in the B3 cell, more labor and effort are required. It is clear that it will hang.

  Furthermore, in the conventional method, when the type of time-series data is automobile production volume, when the monthly base value is changed quarterly or annually, the total is not averaged as in the case of the full unemployment rate. It is necessary to take That is, in the table of FIG. 4, it is necessary to change the description of the cell using the “AVERAGE function” to the “SUM function”.

  On the other hand, in the method of the present embodiment, the database has a typical aggregation method for each data code as an attribute (stored in the attribute information master database 12), and there is no specification from the user. In some cases, the calculation is performed by the aggregation method. For this reason, even if the function is not normally changed, the calculation is performed by the aggregation method suitable for the data, and the convenience for the user is further improved.

  Up to this point, an example using a function for obtaining “numerical value = statistical value” has been shown. In addition, since the function of the attribute information is prepared in the program according to the present embodiment, an example in which a table in which attribute information is extracted by combining these functions will be described. These pieces of attribute information are stored in the attribute information master database 12 and the attribute information database 16 shown in FIG.

  FIG. 7 shows a state in which actual data is displayed on the left side and a corresponding mathematical expression is displayed on the right side. In each cell of C3, C4, C5, and C6 on the right side of the same figure, “INDBZ” that is a function for acquiring attribute information of time series data from the database and displaying it in the cell is described. As a result, according to the parameters of each cell, the name, unit, start time, latest time of data ("LAF & URS", that is, time series data of complete unemployment rate) having the data code described in cell C2, respectively. Is obtained.

  Also, [= indbdym (c6,1,1)] is described in the B7 cell of the sheet on the right side of FIG. This is a function that is prepared separately from the above function, and returns to the year one year before on the year basis from the point specified in the C6 cell, and finds the January point of that year. is there. Therefore, if the latest time acquired in C6 cell is from January 2004 to December of the same year, January 2003 will be returned, and if the latest time is January 2005, January 2004 will be returned. Will return.

  In the sheet on the right side of FIG. 7, another function [= indbd (b7,1, “monthly”)] is described in the cells after B8 in the B column. This is a function indicating that the value is incremented by 1 on the B7 cell on a monthly basis, that is, incremented by one month. The function described in the C7 and subsequent cells in the C column is a function for acquiring the time series data described above, and outputs statistical values corresponding to the years described in the B7 to B30 cells. Is a function.

  By combining such functions, data is automatically added to the worksheet on the client terminal as the data stored in the database is updated every month, and the start year of the table changes when the year starts. It is feasible to create a dynamically changing table.

  Since the time series tables exemplified so far are rather basic, it is not impossible for database vendors to prepare them as regular tables under the conventional method and provide them to users. . However, the table considered by the user is not limited to such a basic one, and there are actually a myriad of types.

  FIG. 8 is an example of a table created by the user based on his / her request, which belongs to a rather special category. This is a very complex one where each cell is shaded or displayed with a “+” sign depending on the statistics displayed in that cell. If a database vendor incorporates such a table in a fixed pattern, the fixed pattern must be prepared indefinitely, which is virtually impossible.

  Note that FIG. 8 is created by designating with this function. For example, when the above B3 cell is changed from quarter to month, the function is recalculated and immediately becomes a monthly basis table. Moreover, if the C3 cell is changed from the previous year to the previous year, this is also a table that is immediately calculated from the previous year. Further, when a new time point comes out, the value of the D3 cell may be changed. For example, FIG. 9 is a table in which B3 is changed to monthly in the table of FIG. 8, and the description of D3 is changed to “2004/03”, but this table only changes the values of the B3 cell and the D3 cell. The cell function is recalculated and the desired table is obtained immediately.

[Update data]
Data acquired by the function is stored in the statistical value cache database 15 on the client PC (client terminal) 13. This database becomes the latest value by acquiring and updating data from the database server 13 via the Internet 20. I will explain how to do this.

  Referring to FIG. 10, there is a palette (menu palette) with menu buttons arranged in the middle and right. Here, when the “numerical value update” menu button is clicked, all data used in this file are searched, and the update data is requested to the database server 10 via the Internet 20. If there is update data, the database server 10 sends it to the client PC 13, and the update data is stored in the local database 15.

  The above is the update of the numerical data. The update of the attribute information database is also realized by clicking the menu button “Update Code Book” on the menu palette, and the data of the attribute information database 16 is updated. In this case, not only the data used in the file, but all attribute information is synchronized with the database server 13 on the Internet.

[Supplemental functions]
Furthermore, although not an essential function of the present invention, a convenient function for using functions is prepared in the program 14 of the present embodiment, which will be described.

(1) Data code search The user needs to know the data code “LAF & URS” representing the unemployment rate and the data code “I04060PDQ” representing the number of automobiles produced before using this system. Therefore, in this embodiment, a tool is prepared that allows the user to easily know the data code of the time series data that the user wants to use.

  When the “series search” screen on the menu palette is clicked, a screen as shown in FIG. 11 is opened. Here, as shown in the figure, the data code can be searched by entering a search keyword such as “unemployment rate seasonal adjustment” in the series name column. In addition to outputting this data code directly to the sheet, it is also possible to create a table that is a certain amount and paste it on the sheet.

(2) Data display / graph display As described above, in the method of this embodiment, the function is input to the worksheet to display the data, but the degree of freedom of table creation is increased. However, for the time being, you may want to see the overall values in a table or graph. Prepared for such a case are the functions of “data display” and “graph display” on the menu palette.

  For example, when the cursor is placed on the cell D4 in FIG. 20 and “Data Display” on the menu palette is clicked, the screen in FIG. 12 is opened and the numerical value can be viewed. . If “Graph Display” is clicked, the graph display of FIG. 13 is made. Both functions find the code used in the cell where the cursor is placed and display graphs and data.

[Function specifications]
14 to 17 show detailed specifications of the four functions “indbs”, “indbz”, “indbd”, and “indbdym” prepared in the program 14 of the present embodiment. The numbers in parentheses of each function represent parameters that can be specified. In the function “indbs”, the first and second parameters are required, and up to six parameters can be specified. Furthermore, any function can describe not only constants but also cell references and functions themselves as parameters.

The functional block diagram which showed the structure of the whole system which concerns on this embodiment, and the table | surface which showed the timing of the data update in various databases, and the unit of the data updated are shown. This is a time series that shows the most recent changes in the unemployment rate on a monthly, quarterly, and annual basis. It is the figure which showed the state which the user input required information into the worksheet on own client PC13 based on the program 14 of this embodiment in order to display the time series table | surface shown in FIG. It is the figure which showed the state which input the function required in order to display the table | surface of FIG. 2 by a conventional system, and related information. It is the figure which showed the original table required in order to make the time series table of FIG. 2 with a conventional system. It is the figure which showed the time series table showing transition of automobile production quantity. The left side shows a state where actual data is displayed, and the right side shows a state where a corresponding mathematical expression is displayed. It is the figure which showed an example of the special table which the user created based on his request. FIG. 9 is a diagram showing a table in which B3 cell is changed to monthly in the table of FIG. 8, and the description of D3 cell is changed to “2004/03”. It is a figure for demonstrating the data update of this embodiment. It is a figure for demonstrating the search method of a data code. It is a figure for demonstrating the function of a data display. It is a figure for demonstrating the function of a graph display. FIG. 10 is a diagram illustrating detailed specifications of a function “indbs”. It is the figure which showed the detailed specification of function “indbz”. FIG. 10 is a diagram illustrating detailed specifications of a function “indbd”. It is the figure which showed the detailed specification of function “indbdym”.

Explanation of symbols

10 Database Server 11 Statistics Master Database 12 Attribute Information Master Database 13 Client PC
14 Program of this embodiment 15 Statistics cache database 16 Attribute information database 20 Internet

Claims (6)

A computer program that reads specific time-series data from a database in which a plurality of time-series data is stored, and makes it available on a spreadsheet software worksheet that runs on a client terminal,
A set of functions that function on the spreadsheet software and can specify constants, functions, and cell references as parameters, and read out one of the predetermined time series data from the database and use it as a function value A set of functions including at least a data read function that functions to return to the spreadsheet software is prepared in advance.
A data code specifying the type of time series data is prepared in advance,
When the data read function is described in a certain cell on the worksheet,
A first function for recognizing a data code and a specific time point from a parameter of a data read function described in the cell;
A second function for searching the database based on the data code and the time point recognized by the first function and identifying the corresponding individual data;
A third function that enables use on spreadsheet software by reading the individual data specified by the second function from the database, transferring it to the client terminal, and returning it to the data read function as a function value;
A computer program characterized by realizing the above. The set of functions includes an attribute information read function that reads the attribute information of the time series data stored in the database together with the time series data, and functions to return it to the spreadsheet software as a function value.
When the attribute information read function is described in a cell on the worksheet, the computer
A fourth function for recognizing a data code and a specific attribute from the attribute information read function described in the cell;
A fifth function for searching the database based on the data code and the attribute recognized by the fourth function and identifying the corresponding individual data;
A sixth function that enables use on spreadsheet software by reading the individual attribute data specified by the fifth function from the database, transferring it to the client terminal, and returning it to the attribute information read function as a function value; ,
The computer program according to claim 1, wherein: 3. The computer program according to claim 1, wherein the data read function can have a time specification parameter for specifying a specific time point and an operation specification parameter for specifying an operation to be performed on a plurality of data. Has been
When the data read function is described together with the time specification parameter and the operation specification parameter in a certain cell on the worksheet,
A seventh function for recognizing a plurality of time points obtained from a data code, a time point specifying parameter and a calculation specifying parameter from the parameters of the data read function described in the cell;
An eighth function that searches the database based on the data code recognized by the seventh function and a plurality of time points, and identifies a plurality of corresponding individual data;
A ninth function of reading a plurality of individual data specified by the eighth function from the database and transferring the data to a client terminal, and executing the specified operation on the plurality of individual data;
A tenth function enabling use on a spreadsheet software by returning the result calculated by the ninth function as a function value to the data read function;
The computer program according to claim 1, wherein the computer program is realized. A database server that controls a database in which a plurality of time-series data is stored, a client terminal in which spreadsheet software is operated, and a computer network that connects the database server and the client terminal A time series data display system,
The spreadsheet software includes an add-in program, and the add-in program is
It reads specific time-series data from the database in which a plurality of time-series data is stored, makes it available on the spreadsheet software worksheet that runs on the client terminal, and functions on the spreadsheet software. , A constant, a function, and a function set that can specify a cell reference as a parameter, and functions to read one of predetermined time-series data from the database and return it to a spreadsheet as a function value A set of functions including at least a data read function is prepared in advance, and a data code for specifying the type of time series data is prepared in advance.
When the data read function is described in a certain cell on the worksheet on the client terminal, the add-in program
A first function for recognizing a data code and a specific time point from a parameter of a data read function described in the cell;
A second function for searching the database based on the data code and the time point recognized by the first function and identifying the corresponding individual data;
A third function that enables use on spreadsheet software by reading the individual data specified by the second function from the database, transferring it to the client terminal, and returning it as a function value to the data read function;
A time-series data display system characterized by realizing the above. The set of functions includes an attribute information read function that reads the attribute information of the time series data stored in the database together with the time series data and functions to return it as a function value.
When the attribute information read function is described in a certain cell on the worksheet on the client terminal, the client terminal
A fourth function for recognizing a data code and a specific attribute from the attribute information read function described in the cell;
A fifth function for searching the database based on the data code and the attribute recognized by the fourth function and identifying the corresponding individual data;
A sixth function that enables use on spreadsheet software by reading the individual attribute data specified by the fifth function from the database, transferring it to the client terminal, and returning it to the attribute information read function as a function value; ,
The time-series data display system according to claim 4, wherein: 6. The add-in program according to claim 4, wherein the data read function can have a time specification parameter for specifying a specific time point and an operation specification parameter for specifying an operation to be performed on a plurality of data. And
When the data read function is described in a certain cell on the worksheet together with the time specification parameter and the operation specification parameter, the client terminal
A seventh function for recognizing a plurality of time points obtained from a data code, a time point specifying parameter and a calculation specifying parameter from the parameters of the data read function described in the cell;
An eighth function that searches the database based on the data code recognized by the seventh function and a plurality of time points, and identifies a plurality of corresponding individual data;
A ninth function of reading a plurality of individual data specified by the eighth function from the database and transferring the data to a client terminal, and executing the specified operation on the plurality of individual data;
A tenth function enabling use on a spreadsheet software by returning the result calculated by the ninth function as a function value to the data read function;
The time-series data display system according to claim 4 or 5, characterized in that:

Images