A program that depicts (transcribes) one numerical time series data into multiple data columns and creates a graph.

Abstract

A method for generating a time series graph is provided. [Solution] Data values ​​from a single piece of numerical time series data entered into a worksheet of a spreadsheet software are transcribed into multiple data strings at any location, and the transcribed multiple data strings of information processing are visualized as a graph.

Description

[Technical field]

[0001] A program that uses the AutoSUM and graph functions of a spreadsheet application software to transfer a single piece of numerical time series data into multiple lines on a worksheet and create a graph. [Background technology]

[0002] Numerical time series data consists of a sequence of time and values. A numerical time series data is a single row of closing prices, or a four-row row of opening, high, low, and closing prices. When displayed on a line graph, it appears as one or four lines. The method for displaying a numerical time series graph as shown above involves setting the graph display range directly on the numerical time series data entered into the spreadsheet software worksheet. [Prior art documents] [Patent documents]

[0003] I searched the literature on time series graphs, but due to my lack of search ability I was unable to find a program that would create a graph with multiple lines as I desired. Technical graphs and the like are not included in the study because they are not formulas based on real data values ​​and cannot be handled on a desk or in a worksheet, where they would introduce false errors. [Non-patent literature]

[0004] I searched for non-patent literature but couldn't find anything. All of humanity is depicted in ready-made time series graphs on spreadsheets. As a collection of books, Easy Excel 2007, Easy Windows Vista 2007, Gijutsu Hyoronsha Editorial Department, I also went to the library, No literature was found on graphs in self-paced programs using worksheets. Summary of the Invention Problem that the invention is trying to solve

[0005] current What is now known as a time series graph is a passive visualization of a recorded event. As long as you set the graph display range directly on the numerical time-series data values ​​entered into the spreadsheet software worksheet, it will be an integrated structure, and active graphs for personal use will not be possible. It is essential to invent a method that does not directly graph the integral composition of the input numerical time series data. Means for solving the problem

[0006] Time series graphs such as candlestick charts and bar charts are ready-made software products. These are visualizations that can only reproduce records; they are passive, fixed and not active. On a worksheet, which is the basis for graphs, the only thing that can be graphed is a line graph of numbers. For active, self-serving visualization, you can freely arrange data values ​​using multiple columns and blank cells in a worksheet. Multiple columns are a requirement to move away from the single-column structure that allows for arbitrary arrangement of data values. Breaking away from structure involves a method of depicting (transcribing) a single input numerical time series data in another location. Using the AutoSUM function of a spreadsheet, The data values ​​required by the user are arranged in a different location, and the arranged data columns are visualized in a graph to solve the problem. Effect of the Invention

[0007] Time series graphs are said to be infrastructure, but in reality, the only one "right shoulder..." Shakyamuni continues to devour peace throughout the world. The program is a technical paintbrush that actively tries to use numerical time series data. Questions and dissatisfaction that have traditionally been suppressed by stereotypes about the inconveniences and contradictions of time series graphs have now been resolved. Personalized graphs can lead to innovation, and the ripple effects of graphs as a tool are immeasurable. When combined with AI, improved predictive capabilities could eliminate market prices. [Brief description of the drawings]

[0008] [Figure 1] (Left side) The underlying Nikkei average stock price from February 8th to March 8th, 2024 (20 days), (right side) a four-value graph drawn (transcribed) using the AutoSUM function and its data column drawing (transcription) layout. [Diagram 2] (Left side) The underlying Nikkei average stock price from 2 / 8 / 2024 to 3 / 8 / 2024 (20 days), (right side) A graph of the 4-day expansion line and main line with a one-day shift drawn (transcribed) using the AutoSUM function, and a diagram of the data column drawing (transcription). [Diagram 3] (Left side) The underlying Nikkei average stock price from 2 / 8 / 2024 to 3 / 8 / 2024 (20 days), (right side) The maximum and minimum data columns for the 5th, 10th, and 20th days depicted (transcribed) using the AutoSUM function, as well as a graph of the main line and the layout of the depicted (transcribed) data columns. [Figure 4] flowchart DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0009] Time series data is an information tool, and a tool only becomes a true tool when it is used creatively and with skill. Simply reproducing time series data will not tell you when the "right shoulder" starts and when it will end, and if things continue as they are, hindsight will be rampant, leaving it up to you, who have no responsibility, to make hindsight decisions. This is a permanent infrastructure that is common sense. To use time series data as a tool, it is essential to break away from the integrated arrangement of time and value. Instead of clicking on the input numerical time series data itself to directly create a graph, An arbitrary location is set, and the one numerical time series data is depicted (transcribed) into a plurality of data strings, Graph that range with a line. Multiple data columns are arranged in a sequence of ideas, and are arranged according to a predefined idea. The aim of this program is to make concrete the hurdle between the idea in your head and the reality on your worksheet. It is the embodiment of the satisfaction of desires such as wanting a marker line here.

[0010] First, enter the numerical time series data of one of your targets into a spreadsheet. Then, using the AutoSUM function of Excel, a spreadsheet software, a single numerical time series data entry can be visualized by plotting (transcribing) and arranging it into multiple columns of data of your own convenience, rather than into a single column, using multiple columns or blank cells in any desired location. The command handled by the AutoSUM function of this application does not alter the data values, but This is a process in which the data values ​​used to create multiple data columns from the above are stored, identified, extracted, and depicted (transcribed) in cells at the corresponding depiction placement positions using the Excel AutoSUM function commands. There is a certain phenomenon that occurs when drawing a line graph on an Excel worksheet, a spreadsheet software. For example, if you enter a single piece of basic numerical time series data into columns A, B, and C of a worksheet in the same way and plot the three columns as a line graph, the data will overlap and only a single line will be visible for the topmost column, column C; when the same values ​​overlap, it will not be possible to draw three lines as you would on paper. In other words, events that are split into multiple data columns take on a different world than a single line. The program will need to incorporate the need to introduce time differences in descending order by using multiple columns or blank cells for events, or by highlighting events in descending order to follow a chronological order.

[0011] As a process, based on the position information of the worksheet of the input numerical time series data, The data value stored in the cell used to create multiple data strings from the cell string that holds the data from the last data cell position toward the most recent data is based on the relationship between the positions via the cell addresses of the position information. This is an information processing process in which the positional relationship between cells is established by exchanging data values, in order to depict (transfer) and place multiple data columns into multiple columns or blank cells in any location. First, the final data value of the numerical time series data starting point is stored in a cell of the top row as an arbitrary starting point position of a location set as the first process for conforming to the time series, and the cell address of the cell that holds the final data value is stored as a starting point position data value for forming a plurality of data columns; The first step in the process of Excel's AutoSum function is to identify the final data value and draw (transfer) it to the corresponding cell at the starting point. Use multiple columns and blank cells to create a time lag in descending order to follow a chronological order. The order in which the corresponding data values ​​are depicted (transcribed) into multiple columns or blank cells to create multiple data columns can be determined by the idea of ​​using overlapping or shifting, whether to use blank cells to make a continuous blank cell or only multiple data columns, etc., depending on the time sequence in multiple data columns or the descending order of time in blank cells. For each corresponding depiction cell that corresponds to the position where the depiction (transcription) is to be placed toward the bottom row in order to arrange the thoughts, The data values ​​to be used from a single input numerical time series data are placed in the relevant depiction (transcription) cell at the relevant depiction position, with no limit on the number of times they can be used or how they are placed. The command for Excel's AutoSUM function is stored in the relevant depiction (transcription) cell, and a line range is set within the multiple depiction (transcription) columns or multiple data columns including blank cells to depict a graph with multiple lines.

[0012] Specifically, the data values ​​held by the cells in the input numeric time series data are The order in which the cells are depicted in the set locations, and the relationship between the locations and the cells are the ideas and expressions, and the visualization attempts to convey this from the graph itself, which is the result data column. It is not the data values ​​but the position of the cells that hold the data and the positional relationship between the corresponding cells to be depicted (transferred) that determines how the graph is generated and how it is viewed. The AutoSUM function uses the descending order of cells from the last data of a single input numeric time series data pointing to the most recent data to find the position and order of the data value stored in a cell in a certain order to be depicted (transcribed) to a certain cell in multiple columns or blank cells, and then uses commands such as the AutoSUM function command [=sum(A1)] or [=MAX(A1:A2)] via cell addresses to find the position and order. The data value held by the cell from that single numerical time series data is identified and extracted via the cell address of the AutoSUM function, and then the relevant data value identified for each relevant cell for depiction is depicted (transcribed), and information is processed as to how multiple data columns are arranged in any location and what multiple data columns are to be depicted (transcribed).

[0013] In this application, the command for Excel's AutoSUM function is a command that depicts (transcribes) only actual data values, and is a non-arithmetic information processing command. If it does not contain true values, it is just a theoretical object and is useless. The attached figure shows the cell that holds the final data value of the starting point (cell address E5). The AutoSUM function remembers the command ``=sum(e5)'' to identify the cell and plots (transcribes) it as the starting data value, and the formula bar also displays the command ``=sum(e5)'' to identify the data value. [Figure] shows a graph generated using the true data values ​​in the cell addresses of the AutoSUM function. An active, multi-column graph that no longer exists. The line function in a spreadsheet software is a system that displays successive data values ​​on a worksheet as lines, and if there are multiple columns of data, they will be displayed as multiple lines. This application is not a graph application, but a program for creating graphs at one's own convenience. Multiple columns of data for one's own convenience are an act of thought, a way of visualizing and graphing thoughts. Thought is essential, but since it is an ideological act, there will be pros and cons and superiority / inferiority. [Industrial Applicability]

[0014] A time series graph for personal use is a visualization of data from the user's perspective. The competition is about using the data itself as a tool to convey information. No matter what technology you have, as long as you are bound by a single fixed idea, no new ideas will be born. It is an action on a worksheet and is an active action that anyone can do. An infrastructure for rapid decision making to meet any on-site data request. For the graph showing only reproduction, The emergence of self-serving graphs will increase options and I think this will be a positive thing for humanity in the future. .

Claims

1. A program for causing a computer to execute a process of inputting a single target numerical time series data into a worksheet of a spreadsheet software, extracting from the data series relevant data values ​​used to create multiple data series from the multiple data series at an arbitrary location set as the relevant depiction position in the multiple data series, storing a command for an AutoSUM function of Excel to extract, identify, and depict the relevant data values ​​by cell address in a relevant depiction cell, depicting the multiple data series with the relevant data values ​​extracted and identified by cell address, and setting a range of a broken line within the range of the multiple data series at the arbitrary location depicted to depict a graph, The command to extract and identify the relevant data value using the AutoSUM function of Excel includes the following steps: storing a command via a cell address of the AutoSUM function of Excel in a depiction cell at a relevant depiction position at any location for depicting the data values ​​held by the cells in multiple data columns based on the cell positions and order of the cells, starting from the cell position of the last data of the numerical time series data entered into the worksheet and proceeding toward the most recent data, regarding the descending order of the cell column as a chronological order; extracting and identifying the relevant data value from the numerical time series data column; arranging the command in the relevant depiction cell at any location as the relevant data value to be used in the multiple data columns, and depicting the relevant data value extracted and identified using the cell address of the command; and generating multiple data columns at any location using the relevant data value extracted and identified using the cell address of the command. The above-mentioned command for rendering the corresponding data value using the Excel AutoSUM function is configured as follows: the cell address of the cell that holds the final data value of the starting point of the numerical time series data is stored in a rendering cell at a starting point rendering position that is the top row of a given location, and the final data value is specified as the starting point position data value according to a time series graph and rendered as a plurality of data rows; the first Excel AutoSUM function command is configured to be arranged to render the plurality of data rows; the next configuration is to use a plurality of columns and blank cells in descending order for multiplexing and balancing to render the plurality of data rows; the Excel AutoSUM function command is arranged in a plurality of columns and blank cells in a corresponding rendering cell at a corresponding rendering position from the starting point rendering cell toward the lowest row; the data value extracted and specified via the cell address from the starting point of the numerical time series data is rendered in the rendering cell at the corresponding rendering position as the corresponding data value for rendering the plurality of data rows; and a process of generating a plurality of data rows in descending order according to a chronological order at an arbitrary location; The above-mentioned graph is drawn by a command via the cell address of the Excel AutoSUM function at any location, extracting and identifying the relevant data values ​​and drawing them in multiple columns or multiple data columns including blank cells, and then drawing the graph with multiple lines by setting the drawing range of the line graph in advance. A program for causing the computer to execute the above.

2. 2. A computer-readable recording medium having the computer program according to claim 1 recorded thereon.

Images