JP2005190197A - Power feed record management method and apparatus - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a power feed record management method for quickly and accurately summarizing and organizing power feed records in power facilities in various places by using a computer. <P>SOLUTION: The power feed record management method includes a step for summarizing individual power feed record data in each of power facilities and preparing a daily file and a monthly file which are expressed by a spreadsheet format in which each individual power feed record data in each of power facilities can be specified by a line-column position, a step for giving the same name to daily files and monthly files of the same power facilities, storing a prepared daily file in the directory of the date which is the lowermost layer in a daily directory system in which directories are prepared in the order of years, months and dates, storing the monthly file in a monthly directory of the month which is the lowermost layer in a monthly directory system in which directories are prepared in the order of the monthly report and months on the lower layer of directories of the previous year, a step for acquiring data on a specified line-column position of a specified daily file or monthly file, and a step for copying the acquired data on the specified line-column position of a summarizing sheet. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a method for centrally managing power supply records at various power facilities such as a power plant and a substation.

  Various surveys and procedures are required for the construction of new power facilities. Whether it is possible to construct an electric power facility is determined through various long-term procedures / procedures such as site survey of the proposed construction site, basic design of the facility, site negotiation, local explanation, and government procedures.

  An important requirement for deciding whether or not to construct a power facility is the trend of power demand. A new power facility is required by predicting trends in power demand by collecting and organizing information such as the maximum power transition in existing power facilities, the usage rate of distribution transformers, and the average possible power consumption of power plants. Whether or not, and if necessary, what to do with the scale and construction site.

  Currently, information necessary for predicting power demand is extracted from power supply records sequentially recorded at power facilities in various locations. A computer system called a power supply information collection / distribution device (SDX) that collects power supply records at power facilities in various places via a communication network has already been in operation.

  However, the power supply records recorded from time to time are for investigating the power supply trends in the power supply areas of each power facility, and the power supply records handled by SDX are filed for each power facility. It has become a thing.

  For this reason, when a construction plan for a new power facility is drawn up, specific information is extracted, aggregated, and organized from individual files that exist for each power facility in each region, and candidate sites and sizes are determined. In this consolidation process, desired information is manually read from power supply record files at various locations, and the information is transferred to a single piece of data by manual input.

  In other words, although the data format of the power supply record and its recording format are unified, it is investigated one by one when and which facility is the power supply record, and it takes a lot of time and money to transfer the recorded contents of the power supply record to the destination. It was necessary to copy according to the data format.

  This not only takes a great deal of time and money, but also has the problem that data may not be accurately transferred due to the possibility of erroneous input during information transfer. If a new power facility is built based on an inappropriate plan due to erroneous data entry, the damage will be significant.

  The present invention has been created in view of the above problems. An object of the present invention is to provide a method for collecting and organizing power supply records recorded at power facilities in various places in a short time and accurately.

  The present invention is a power supply record management method for collecting and organizing and managing power supply record data recorded at any time in power facilities such as power stations and substations in various places, and supplying power record data in each power facility When creating a spreadsheet file that aggregates individual data so that it can be specified by matrix position, a power supply record file creation step that creates a daily report file that is aggregated on a daily basis and a monthly report file that is aggregated on a monthly basis For the same power facility, the same name is assigned to the daily report file created every day and the monthly report file created every month, and the directory of the daily report file is in the order of year, month, and date according to the date of creation. Is stored in the lowest date directory in the daily report directory system where A file storage step for storing in the monthly directory of the lowest layer in the monthly report directory system in which the directory is created in the order of the monthly report and the monthly in the lower layer of the year directory, and the directory and file name A data acquisition step for specifying a matrix position and acquiring data at a specified matrix position of a specified daily report file or monthly report file in a specified directory, and the data acquired by the data acquisition step as data in a spreadsheet format A data totaling step for copying to a specified matrix position of the totaling sheet file.

  Moreover, it can also be set as the electric power feeding record management method including the step which presents the data described in the predetermined | prescribed matrix range in the said data totalization sheet as a graph. The computer that executes the power supply record management method is also within the scope of the present invention, and the power supply record data in each power facility is created in a spreadsheet file that is aggregated so that individual data can be specified by the matrix position. The same name is given to the daily report file that is created daily and the monthly report file that is created every month for the same power facility, the means to create the daily report file that is tabulated on a daily basis, and the monthly report file that is tabulated on a monthly basis. The daily report file is stored in the lowest date directory in the daily report directory system in which the directory is created in the order of year, month, and date according to the date of creation. In accordance with the monthly directory system, the directory is created in the order of monthly report and monthly in the lower layer of the year directory. Means for storing in a monthly directory at the lowest layer, means for acquiring a record at a designated position of a designated daily report file or monthly report file in a designated directory by specifying a directory, a file name, and a matrix position; And a means for copying the record acquired by the means to the designated matrix position of the spreadsheet file for data tabulation in the spreadsheet format.

  According to the power supply record management method of the present invention, power supply records recorded at power facilities in various places can be collected and organized accurately in a short time. Thereby, for example, it is possible to strongly support the complicated and long-running analysis work that has been conventionally performed manually, such as the trend of power demand that is an important requirement when constructing a new power facility.

=== File storage structure ===
In the power supply record management method according to the embodiment of the present invention, the power supply record data for each power facility is collected on the SDX at any time, and the SDX collects the power supply records for each facility on a daily or monthly basis into a CSV file. The created file is stored in the magneto-optical disk (MO). Then, the files recorded in the MO are tabulated and managed using a known spreadsheet program. Here, a file corresponding to the daily power supply record data group is referred to as a daily report file, and the monthly power supply record data group is referred to as a monthly report file.

  FIG. 1 shows a file storage structure in the MO. A daily report or a monthly report file based on a power supply record collected daily from each power facility is stored only in the lowest layer in the well-known directory structure. In this example, a system (daily report directory system) in which directories (2 to 4) are configured in the order of year, month, and date from the root directory 1 to the lower layer, and a directory from the root directory 1 to the lower layer in the order of year, month, and month. There are configured systems (monthly report directory systems: 2, 6, 7).

  The daily report file 5 collected on the SDX is stored in the corresponding date directory 4 according to the file creation date, and the monthly report file 8 is stored in the corresponding monthly directory 7. The names of these files (5, 8) correspond to one file name for one power facility. That is, the daily report file 5 and the monthly report file 8 having the same name exist, and the contents of the data can be understood by the stored directory.

  For example, if a file name with a certain name exists in the date directory 4, the content of the file is a daily report file 5 corresponding to the power supply record recorded on that date, and in the monthly directory 7 which is also a file with the same name. For example, the content of the file is a power supply record (monthly report file) 8 through the month.

  A spreadsheet program for counting and organizing power supply records based on the power supply record management method of this embodiment is installed in a general-purpose computer such as a personal computer. This program can handle CSV files and has a macro execution function to perform automatic calculation processing and automatic data collection processing.

=== Data tabulation method ===
In this embodiment, when a CSV daily report (monthly report) file is read by a predetermined spreadsheet program, a record corresponding to a predetermined item is written in a cell corresponding to a predetermined matrix. The processing of the spreadsheet program is shown in FIGS. 2 to 5 by the schematic diagram of the spreadsheet sheet. In this example, the data file for the spreadsheet program is a file in a format including a plurality of sheets (hereinafter referred to as a book format). Sheet (FIG. 3:20, FIG. 5:40).

  The setting sheet (10, 30) and the data display sheet (20, 40) are classified into A (10, 20) and B (30, 40) depending on how the daily report (monthly report) files are tabulated. In tabulation method A, a directory is specified and daily report (monthly report) files in the directory are tabulated. In tabulation method B, the files for the same power facility are tabulated from a plurality of directories.

=== Aggregation Method A ===
As a specific example of the counting method A, an example in which daily report files related to a certain power facility are tabulated is given. In the setting sheet A (FIG. 2: 10), the date directory 12 and the file name 13 corresponding to a certain power facility are entered in a predetermined cell. In addition, the matrix information (cell position) 14 in which information about a specific item is described in the daily report file is entered in a predetermined cell of the setting sheet A10. In this example, one row corresponds to one data series 11, and each data series 11 corresponds to the contents of a daily report file relating to a certain power facility on a certain day.

  The setting sheet A10 is provided with an “execution A” button 15 for executing a predetermined macro. When the daily report file (12, 13) and the cell position 14 are designated, the button 15 is designated. For each data series 11, data at the designated cell position in the designated daily report file is acquired, and the data 22 is automatically input to a predetermined cell of the data display sheet A (FIG. 3: 20).

  On the other hand, in the data display sheet A20, the file storage position and the file name 25 for the tabulation sheet prepared as a separate file are designated, and the cell position of the tabulation sheet for each data 22 acquired from the daily report file. Information (copy destination cell) 23 is entered in association with it. When the macro execution “copy execution” button 26 in the data display sheet A20 is instructed, the data acquired from the daily report file is copied to the corresponding copy destination cell of the designated aggregation sheet.

=== Counting method B ===
Next, the counting method B will be described. Here, the example which collects the monthly report file regarding the predetermined electric power facility in a certain year collectively is given. In the setting sheet B (FIG. 4:30), a monthly report directory name 31 for a certain year and a monthly 32 to be tabulated are designated. In this example, “all”, that is, all monthly in the year is specified. Then, the file name 33 corresponding to the predetermined power facility is entered in a predetermined cell. In addition, the matrix information (cell position) 34 in which information about a specific item is described in the monthly report file is entered in a predetermined cell of the setting sheet B30.

  The setting sheet B30 is provided with an “execution B” button 35 for executing a predetermined macro. When the file name 33 and the cell position information 34 are designated and this button 35 is designated, the designated sheet B30 is designated. For all files with the specified name under the directory, the data at the specified cell position is acquired and the data is automatically input to a predetermined cell of the data display sheet B (FIG. 5: 40).

  Further, in the data display sheet B40, the file storage position and the file name 45 of the previous tabulation sheet prepared as a separate file are designated, and the tabulation is performed for each data 41 entered in the data display sheet B40. Sheet cell position information (copy destination cell) 42 is entered in association with each other.

  In this aggregation method B, data for each item is acquired from a plurality of files having the same name. Therefore, a correspondence table 43 between the acquired data and the copy destination cell is created for each item. That is, there are as many correspondence tables 43 as the number of items. Then, when the macro execution “copy execution” button 44 in the data display sheet B40 is instructed, the data 41 acquired from the file with the specified name is copied to the corresponding copy destination cell 42 of the specified aggregation sheet.

=== Results ===
FIG. 6 shows the data collected by the methods A and B summarized in a predetermined table. In this tabulation sheet 50, various types of information for each power facility are displayed in a list. FIG. 7 is a graph showing the predetermined data range in this list. In this example, the graph 60 visualizes the total result based on various power supply records in the entire power facility in a certain area.

It is the schematic of the file storage structure based on the electric power feeding record management method in the Example of this invention. It is the schematic of the setting sheet | seat A of a spreadsheet format at the time of totaling a feeding record based on the said feeding management method. It is the schematic of the data display sheet | seat A of the table calculation format at the time of totaling a power supply record based on the said power supply management method. It is the schematic of the setting sheet | seat B of the spreadsheet format at the time of totaling a power supply record based on the said power supply management method. It is the schematic of the data display sheet | seat B of the spreadsheet form at the time of totaling a power supply record based on the said power supply management method. ... It is the schematic of the totalization sheet | seat of the spreadsheet form by which power supply recording is totaled based on the said power supply management method. It is the schematic of the graph produced based on the data entered on the said aggregation sheet.

Explanation of symbols

10 Setting sheet A
20 Data display sheet A
30 Setting sheet B
40 Data display sheet B
50 Total sheet 60 Graph

Claims (3)

A power feeding record management method for collecting and organizing and managing power feeding record data recorded at any time in power facilities such as power plants and substations in various places,
For the power supply record data at each power facility, when creating a spreadsheet file that aggregates individual data so that it can be specified at the matrix position, a daily report file that is aggregated daily and a monthly report file that is aggregated monthly A power supply record file creation step to be created;
For the same power facility, the same name is assigned to the daily report file created every day and the monthly report file created every month, and the directory is created in the order of year, month, and date according to the date of creation. The monthly report directory is created in the order of monthly report and monthly report in the lower layer of the year directory for the monthly report file. A file storage step for storing in a monthly directory at the lowest level in the system;
A data acquisition step for specifying a directory, a file name, and a matrix position, and acquiring data at a specified matrix position of a specified daily report file or monthly report file in a specified directory;
A data totaling step for copying the data acquired in the data acquisition step to a specified matrix position in a spreadsheet file for data totaling in a spreadsheet format;
A power supply record management method comprising:   2. The power feeding record management method according to claim 1, further comprising a step of presenting the data described in a predetermined matrix range in the data totalization sheet in a graph. A computer that collects and organizes and manages power supply record data recorded at any time in power facilities such as power plants and substations in various locations,
Regarding the power supply record data at each power facility, when creating a spreadsheet file that aggregates the individual data so that it can be specified by the matrix position, the daily report file that is tabulated daily and the monthly report file that is tabulated monthly Means to create,
For the same power facility, the same name is assigned to the daily report file created every day and the monthly report file created every month, and the directory is created in the order of year / month / date for the daily report file according to the date of creation. The monthly report directory is stored in the lowermost date directory in the daily report directory system, and for monthly report files, the directory is created in the order of the monthly report and the monthly order in the lower layer of the year directory according to the date of aggregation. Means for storing in a monthly directory at the lowest level in the system;
Means for specifying a directory, a file name, and a matrix position, and obtaining a record at a specified position of a specified daily report file or monthly report file in a specified directory;
Means for copying the record obtained by the means to a specified matrix position of a spreadsheet file for data aggregation in a spreadsheet format;
A power supply record management apparatus comprising:

Images