Program for graphing by transcribing single numerical time-series dataset into a plurality of data columns

Abstract

To provide a method for generating a time-series graph.SOLUTION: A system transcribes data values from a single numerical time-series dataset entered in a worksheet of a spreadsheet program into multiple data columns at arbitrary locations, and visualizes the transcribed columns of data of information processing as a graph.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] A program that creates a graph by transferring a single piece of numerical time series data onto multiple lines on a worksheet using the AutoSUM and graph functions of a spreadsheet application software. [Background technology]

[0002] Numerical time series data consists of a sequence of time and values. A single numerical time series data is a single column of closing prices, or a four-column column 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 described above involves directly setting the graph display range for the numerical time series data entered into a spreadsheet. [Prior art documents] [Patent documents]

[0003] I searched the literature on time series graphs, but due to my lack of search skills I was unable to find a program that would create a graph with multiple lines, which was what I wanted. Technical graphs and the like are not formulas based on real data values, so they cannot be handled on a desk or worksheet, which would result in false errors, and are therefore not included in this study. [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 The problem that the invention is trying to solve

[0005] current The current time series graph is a passive visualization of the recorded data. As long as you set the graph display range directly on the numerical time series data values ​​entered into the spreadsheet software worksheet, it is an integrated structure, and active graphs that are based on personal convenience are not possible. It is essential to invent a method that does not directly graph the input numerical time series data, which is the integral configuration. Means to solve the problem

[0006] Time series graphs such as candlestick charts and bar charts are pre-made software. These are visualizations that can only reproduce records, and are passive, fixed, and not active. On a worksheet, which is the basis for graphs, the only graph that can be created is a line graph of numbers. Active, self-serving visualization involves freely arranging data values ​​using multiple columns and blank cells in a worksheet. Multi-column data is a requirement for moving away from the single-column structure where data can be freely arranged. Breaking away from the structure involves depicting (transcribing) a single input numerical time series data in another location. Using the AutoSUM function of the spreadsheet software, The data values ​​are arranged in a different location in the order desired by the user, and the arranged data columns are visualized in a graph to solve the problem. Effect of the invention

[0007] Although time series graphs are said to be an infrastructure, in reality, the only one "right shoulder..." Shaku 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 tools are immeasurable. If combined with AI, improved predictions may eliminate market prices. [Brief explanation 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. [Figure 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 development line and main line, shifted by one day, drawn (transcribed) using the AutoSUM function, and a diagram of the data column drawing (transcription). [Figure 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 and main line graphs for the 5th, 10th, and 20th days drawn (transcribed) using the AutoSUM function, and the layout of the drawn (transcribed) data columns. [Figure 4] flowchart DETAILED DESCRIPTION OF THE INVENTION

[0009] Time series data is a tool of information, and a tool is only truly a tool when it is used with ingenuity and skill. Simply reproducing time series data will not tell you when the "right shoulder..." starts and when it ends, and if things continue as they are, you will be left to make hindsight and it will be a permanent infrastructure where common sense will prevail, leaving it up to you to make assumptions without any responsibility. To use time series data as a tool, it is essential to break away from the unified 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 single numerical time series data is depicted (transcribed) into multiple data strings, Graph that range with a line. Multiple data columns are arranged in a sequence of ideas, and are arranged according to a predetermined idea. The aim of this program is to concretely overcome 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 target numerical time series data into a spreadsheet. Then, using the AutoSUM function of Excel in the spreadsheet software worksheet, the input numerical time series data is visualized by depicting (transcribing) and arranging it into multiple columns of data that are not in a single column but are conveniently arranged using multiple columns or multiple columns and blank cells in any desired location. The command used in the AutoSum function of this application does not alter the data value, but rather This is a process that stores, identifies, extracts, and depicts (transcribes) the data values ​​used to create multiple data columns from the Excel AutoSUM function into the cells at the corresponding depiction placement positions. There is a certain phenomenon that occurs when drawing a line graph on an Excel worksheet. For example, if you enter a single piece of basic numerical time series data in 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 one 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 considers the need to incorporate the effects of descending time differences by overlapping events in multiple columns or blank cells, highlighting events in descending order, and following a chronological order.

[0011] As a process, based on the position information of the worksheet of the input numerical time series data, The relationship between the positions of the data values ​​stored in the cells used to create multiple data strings from the cell string that holds data from the last data cell position to the most recent data is based on the relationship between the positions of the data values ​​stored in the cells via the cell addresses of the position information. The process of information processing involves exchanging data values ​​to establish the positional relationship between cells and the corresponding cells used to depict (transcribe) and place multiple data columns within 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 highest column as an arbitrary starting point position in 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 Excel's AutoSum function is to identify the final data value and place it in the cell at the starting point. Using multiple columns and blank cells, you can create a time lag in descending order to follow a chronological order. The order in which the data values ​​to be created into multiple data columns are depicted (transcribed) into multiple columns or blank cells can be determined by the following: descending order of time in multiple data columns, descending order of time in intervals using blank cells, whether to use overlapping or offsetting, whether to use continuous blank cells or only multiple data columns, etc. For each corresponding drawing cell that corresponds to the position where the drawing (transcription) is to be placed towards the bottom row in order to arrange the thoughts, The data values ​​to be used from the input numerical time series data are placed in the corresponding depiction (transcription) cells at the corresponding depiction positions, with no limit on the number of times they can be used or how they are placed. This is done by storing the command for Excel's AutoSUM function to create multiple data columns, and then setting a line range within the multiple depiction (transcription) placed 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 cells and their positions are the idea and expression, and the visualization attempts to convey this through the graph itself, which is the resultant data column. The graph is generated and displayed based on the positional relationship between the cell that holds the data and the corresponding cell that is being depicted (transferred), rather than the data value. The AutoSum function uses the descending order of cells from the last data of a single input numeric time series data to the most recent data, and searches for the position and order based on the idea of ​​which cell in a given order should have its data value depicted (transcribed) to which cell in multiple columns or blank cells. Then, using commands such as [=sum(A1)] or [=MAX(A1:A2)] via cell addresses, the AutoSum function searches for the position and order based on the idea of ​​which cell in a given order should have its data value depicted (transcribed) to which cell in multiple columns or blank cells. The data value held by the cell from the single numerical time series data is identified and extracted via the cell address of the AutoSUM function, and is depicted (transcribed), and the relevant data value identified for each relevant depiction cell is depicted (transcribed), and information processing is performed to determine how to arrange multiple data columns in any location and what multiple data columns are depicted (transcribed) as multiple data columns.

[0013] In this application, the command of Excel's AutoSUM function is a command that depicts (transcribes) only actual data values, and is information processing of a non-arithmetic command. If it does not have true values, it is just a theoretical and useless thing. The attached [figure] is 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 position data value, and the formula bar also displays the command [=sum(e5)] to identify the data value. [Figure] shows a graph generated using the AutoSum function's cell addresses and real data values. This is an active graph with multiple data columns, and is no longer in existence. The line function in spreadsheet software is a system that displays a series of data values ​​on a worksheet as a line, and if there are multiple data columns, it 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 data columns for personal convenience are an act of thought, visualizing and graphing thoughts. Thought is essential, but since it is an ideological act, there will be pros and cons and superiority or inferiority. [Industrial Applicability]

[0014] A personal time series graph is a visualization of data from the user's perspective. The competition is about using data as a tool to communicate information. No matter what technology you have, ideas will not be born as long as you are bound by a single fixed idea. It is an action on a worksheet and is an active action that anyone can do. A rapid decision infrastructure that responds to all on-site data requests. For the graph of reproduction only, The creation of graphs for personal convenience will increase options and be beneficial for humanity in the future. .

Claims

1. A program to plot one numerical time series data into multiple arbitrary data columns and make a graph is Enter the relevant numerical time series data into a spreadsheet. The order of the cells from the last data cell of the input numerical time series data to the most recent data is considered to be in chronological order, and based on the position information of the cells, Give your worksheet space to plot any number of columns of data, The cell address of the cell that holds the final data value of the starting point in the inputted numerical time series data is stored in the depiction cell corresponding to the depiction position that is the starting point of any of the first columns in the set location, using the Excel SUM function of the autoSUM function; The final data in the inputted numerical time series data is specified in a depiction cell set as an arbitrary starting point, and the final data is depicted and arranged as the latest data, using an Excel function for depicting any plurality of data strings in a chronological order; An Excel function command via a cell address that extracts and specifies data values ​​to be used for depicting arbitrary multiple data strings from the data values ​​held in the cell of the input numerical time series data in an arbitrary order of tempo, tone, pattern, etc., and depicts the data values. The data column in which the final data is drawn as the starting data value in the location for drawing in any of the multiple data columns that are arbitrarily set is set as the first data column, including the drawing cell of the starting point, Information processing to draw and arrange the inputted numerical time series data in any of a plurality of data columns by using an Excel function command via a cell address while planning the arrangement of the drawing in descending order, interval, emphasis, tone, pattern, balance, etc. according to the time series using any of a plurality of columns or blank cells, and to draw and arrange the data in any of a plurality of data columns by using an Excel function command via a cell address while giving a series of commands to a drawing cell corresponding to any of the relevant drawing positions, A graph is drawn using a plurality of lines by setting a drawing range of a broken line in advance within the range of information processing for depicting a plurality of columns or a plurality of data columns including blank cells at the arbitrary positions set up. A program for plotting one piece of numerical time series data as multiple lines on a graph by a computer, characterized by executing the above.

2. A computer-readable recording medium on which the computer program according to claim 1 is recorded.

Images