AUTOMATIC CREATION OF TIME-SERIES MATRIX OF VERTICAL-AXIS AND HORIZONTAL-AXIS PLURAL ITEM NAMES AND DATABASE INPUT SOFTWARE

摘要

PROBLEM TO BE SOLVED: To provide software for simplifying the creation of an input table format of a matrix table of a time-series manner (hereinafter referred to as input table) in which the vertical axis and the horizontal axis each show plural item names and also for simplifying data input in the input table, thereby promoting usage of the data in the input table.;SOLUTION: The database input software sets a creation condition in an initial setting sheet by means A100 for automatic generation, and automatically creates the formats for an input table and an input screen, and data for the input screen. The input screen acquires the position and the value of the cell of data previously input in the input table, and acquires data on the horizontal-axis item names on the input screen and on database item names and data of the vertical-axis item names by means A200 for preparing a screen for automatically inputting data for the vertical axis and horizontal axis of the input table and for the database in the input screen. A sheet for outputting data of the input screen is provided by means A300 for outputting the data of the input screen to the database, and the data which matches an item name in the database is output to the database.;SELECTED DRAWING: Figure 1;COPYRIGHT: (C)2019,JPO&INPIT