Daily data shaping device

Abstract

A management server (20) as a daily data shaping device comprises an extraction item character storage unit (31), an extraction item search unit (33), a candidate cell setting unit (34), an attribute determination unit (35), and a daily list generation unit (36). In the extraction item character storage unit (31), extraction item characters as characters of daily items and attributes of daily items are registered by identification symbols. The extraction item search unit (33) searches for an extraction item cell in one record of daily data containing a plurality of records, the extraction item cell being a cell containing a specified extraction item character or a synonym thereof. The candidate cell setting unit (34) sets cells surrounding the searched extraction item cell as candidate cells. The attribute determination unit (35) searches for a matching cell in which a character matching the attribute of the daily item corresponding to the specified extraction item character is input from the candidate cells. The daily list generation unit (36) associates the specified extraction item character with the character in the matching cell.

Description

Technical Field

[0001] The invention relates to a shaping device for daily report data. Background Art

[0002] In the so-called building maintenance business, in which the owner of a building or the like entrusts the maintenance and security of the facilities of the building to the owner, a daily report is generated as a report to the entrusting party such as the owner.

[0003] Such daily reports are generated on a computer as electronic data, for example. For example, a computer held by a field operator performing maintenance stores tabular data of the daily reports. The field operator inputs necessary items according to the date and time, work content, etc. shown in the tabular data.

[0004] For example, Fig.13 As shown in the example, the format of one record of the daily report form 100A, 100B is a label format in which the cells of the input grid are spread over multiple rows and columns. Data in such a label format is aggregated into a list format in which one record of data is arranged in one row by item and multiple records are arranged in columns, thereby being able to obtain statistical trends of maintenance work (for example, time periods with frequent inquiries, etc.).

[0005] Regarding such data processing, for example, patent document 1 discloses an information sharing / flexible application system, which has: a data collection function for collecting data; an indexing function for indexing the collected data; a data retrieval / filtering function for searching or filtering data based on the indexed data; and a data flexible application function for flexibly applying data.

[0006] In addition, patent document 2 discloses an information processing device that performs the following processing: a first extraction processing, taking multiple items on a handwritten manuscript as object items, respectively, and extracting an area image corresponding to the object item from the scanned image; a second extraction processing, extracting a character string from the area image; a first reading processing, reading feature data corresponding to the object item; a first calculation processing, calculating the consistency between the feature of the extracted character string and the feature represented by the feature data; and a storage processing, storing error item information representing the object item in response to a judgment that the consistency is less than a threshold.

[0007] In addition, patent document 3 discloses an electronic receipt server device, which detects vertical and horizontal lines constituting the electronic receipt based on table data in the form of a specified electronic receipt requested to be displayed by a client device, detects a rectangle constituting the electronic receipt based on the detected vertical and horizontal lines, extracts an item rectangle containing a table character within the rectangle from the detected rectangle, and when a specified table character is specified by the client device, retrieves the actual receipt data contained in a previously detected rectangle adjacent to a specified item rectangle containing the specified table character in a specified direction.

[0008] Prior art literature

[0009] Patent Literature

[0010] Patent Document 1: Japanese Patent Application Publication No. 2012-215992

[0011] Patent Document 2: Japanese Patent Application Publication No. 2018-186411

[0012] Patent Document 3: Japanese Patent Application Publication No. 2007-179203 Summary of the invention

[0013] Problems to be solved by the invention

[0014] However, for example, Fig.13 The form (format) of the daily report may differ for each building 110A, 110B, such as the daily report forms 100A, 100B of FIG. For example, the focus may differ for each owner, or the form of the daily report may differ between buildings due to the judgment of the on-site workers such as adding a free description column.

[0015] In such a case, when comparing statistical trends among multiple buildings, such as comparing time periods with a large number of consultation calls among buildings, as described above, the tables of daily reports vary among buildings, making it difficult to convert them into unified tabular data.

[0016] Therefore, an object of the present invention is to provide a daily data shaping device capable of aggregating a plurality of daily data in tag formats having different formats into a list format.

[0017] Means for solving problems

[0018] The daily data shaping device of the present invention shapes daily data in a label format in which item cells and input cells are arranged over a plurality of rows and columns. The daily data shaping device comprises an extraction item character storage unit, an extraction item search unit, a candidate cell setting unit, an attribute determination unit, and a list generation unit. In the extraction item character storage unit, extraction item characters as characters of daily items and attributes of daily items are registered according to identification symbols. The extraction item search unit searches for an extraction item cell in one record of daily data containing a plurality of records, the extraction item cell being a cell containing a prescribed extraction item character or a synonym thereof. The candidate cell setting unit sets cells around the searched extraction item cell as candidate cells. The attribute determination unit searches for a matching cell in which a character matching the attribute of the daily item corresponding to the prescribed extraction item character is input from the candidate cells. The list generation unit associates the prescribed extraction item character with the character in the matching cell.

[0019] According to the above invention, extraction item characters and characters of attributes corresponding to the characters can be associated with each other and extracted from daily report data, and a list based on the association can be formed regardless of the format of the daily report data.

[0020] In the above invention, the candidate cell setting unit may set the candidate cells by excluding cells including extraction item characters or their synonyms given identification symbols different from predetermined extraction item characters from cells surrounding the searched extraction item cell.

[0021] According to the above invention, it is possible to avoid extracting characters of daily items as characters associated with extraction item cells.

[0022] Furthermore, in the above invention, a search range determination unit may be provided for finding a boundary of a single record based on an identification code assigned to each record in daily report data including a plurality of records.

[0023] According to the above invention, the boundary of a single record can be easily obtained.

[0024] Furthermore, in the above invention, a daily report list generating unit may be provided for arranging characters in a row in a daily report list, characters in a corresponding cell extracted from each record and associated with a predetermined extraction item character.

[0025] According to the above invention, it is possible to generate a daily report list in which characters in matching cells of each record are arranged in a row according to the extracted items.

[0026] In the above invention, the position of the priority cell in the cells surrounding the extraction item cell may be stored in the extraction item character storage unit. In this case, when a plurality of matching cells are found, the list generation unit associates the characters of the matching cells corresponding to the position of the priority cell with the specified extraction item characters.

[0027] According to the above invention, in addition to the attribute of the item, the selection of the appropriate cell is performed based on the relative position to the cell into which the extraction item character is input. Therefore, it is possible to narrow down the appropriate cells corresponding to the format of the daily report cell.

[0028] Furthermore, in the above invention, when a plurality of matching cells are found and the position of any of the cells does not correspond to the position of the priority cell, the list generating unit may associate characters of the plurality of matching cells with a predetermined extraction item character.

[0029] According to the above invention, it is possible to prevent a character string whose number of characters corresponds to a cell from being reflected in the daily list data by omission.

[0030] Effects of the Invention

[0031] According to the present invention, a plurality of daily data in label formats having different formats can be collected in a list format. BRIEF DESCRIPTION OF THE DRAWINGS

[0032] Figure 1 This is a diagram illustrating the overall configuration of a building operation management system including the daily report shaping device according to the present embodiment.

[0033] Figure 2 This is a diagram illustrating the functional blocks of the daily report shaping device according to the present embodiment.

[0034] Figure 3 This is a diagram illustrating an example of a daily newspaper on a paper medium.

[0035] Figure 4 The diagram exemplifies daily report data in a label format (daily report label data).

[0036] Figure 5 This is a diagram illustrating daily data in a list format (daily list data).

[0037] Figure 6 This is a diagram illustrating a list (extraction setting list) stored in the extraction item character storage unit.

[0038] Figure 7 This is a flowchart (1 / 2) illustrating the daily report shaping process according to this embodiment.

[0039] Figure 8 This is a flowchart (2 / 2) illustrating the daily report shaping process according to this embodiment.

[0040] Fig. 9 This is a diagram for explaining the step (S16) of finding the record boundary.

[0041] Fig.10 This is a diagram for explaining the search step (S20) of extracting item cells.

[0042] Fig.11 It is a diagram for explaining the step ( S22 ) of setting candidate cells.

[0043] Fig.12 This is a diagram for explaining the step (S24) of excluding other extraction item cells from candidate cells.

[0044] Fig.13 This is a diagram illustrating a table (format) of daily reports for each building. DETAILED DESCRIPTION

[0045] Hereinafter, preferred embodiments of the present invention will be described with reference to the accompanying drawings.

[0046] exist Figure 1 , an overall structure diagram of an embodiment of a building operation management system including the daily report shaping device of the present invention is illustrated. In the building operation management system, data of a plurality of buildings are used. The building operation management system is configured to include a plurality of central management devices 10A, 10B and a management server 20.

[0047] The central management devices 10A and 10B are respectively installed in the buildings. The building operation management data related to the maintenance management and security of each building is stored in the central management devices 10A and 10B. The central management devices 10A and 10B are composed of computers, for example. In addition, the central management devices 10A and 10B may also have Figure 1 The hardware configuration shown is the same as that of the management server 20 .

[0048] Daily report data is sent from the computers 12A and 12B to the central management devices 10A and 10B. For example, when the owner of a building entrusts a building maintenance company to operate the building, on-site workers such as employees of the building maintenance company create daily reports for reporting the operation and management content to the owner. The daily reports are electronic data input from the computers 12A and 12B held by the on-site workers, and the electronic data are sent to the central management devices 10A and 10B. The daily report data will be described later.

[0049] The management server 20 can communicate with a plurality of central management devices 10A and 10B via a network 14 such as the Internet. The management server 20 can receive respective building operation management data from the central management devices 10A and 10B. The building operation management data also includes daily report data. As described later, the management server 20 functions as a daily report data shaping device that processes and shapes the daily report data from each central management device 10A and 10B.

[0050] The management server 20 is composed of a computer. That is, the management server 20 has an input / output controller 21, a CPU 22, a ROM 23, a RAM 24, and a hard disk drive (HDD) 25, which are connected to an internal bus 28. In addition, the management server 20 has an input unit 26 such as a mouse and a keyboard, and a display unit 27 such as a display, which are connected to the internal bus 28.

[0051] The ROM 23 as the storage unit of the management server 20 stores Figure 7 , Figure 8 The program for executing the daily report shaping process is illustrated. In addition, the program can of course be provided through the communication unit, or can be stored in a computer-readable recording medium such as a CD-ROM or a USB memory.

[0052] The program stored in the ROM 23 or provided from the communication unit or recording medium is executed by the CPU 22 of the computer constituting the management server 20. By executing the program, the management server 20 has Figure 2 The functional block serves as a daily report shaping device.

[0053] That is, the management server 20 includes an extraction item character storage unit 31, a search range determination unit 32, an extraction item search unit 33, a candidate cell setting unit 34, an attribute determination unit 35, a daily report list generation unit 36, and a setting change unit 37. The processing contents of these functional blocks will be described later.

[0054] As described above, the building operation management data including the daily report data is transmitted from the central management devices 10A and 10B to the management server 20. As described later, the management server 20 functions as a daily report shaping device to shape the received daily report data and generate a daily report list covering multiple buildings (in other words, across buildings).

[0055] Figure 3The example of printing the daily report data sent from the central management device 10A on a paper medium is shown. In the daily report, a record is generated for each corresponding task performed by the field operator. For example, as the content of the corresponding task, the following is recorded in the record ID1: the field operator received a request related to the setting of blinds, lighting, and air conditioning in a specified area and specified date and time in the building, and the operator executed the request content.

[0056] The daily report includes items for grasping the outline of the corresponding work, such as the occurrence date and time, the correspondent, the content of the corresponding work and its handling, and the end date and time as the items to be reported.

[0057] As described above, daily report data serving as the basis for such daily reports are input from a computer held by a field worker. Figure 4 An example of daily data displayed on a display unit (display) of a computer is shown. Daily data is in a tabbed format with item cells and input cells arranged over a plurality of rows and columns, as one record, that is, one corresponding business report data. Hereinafter, daily data in tabbed format will be appropriately described as "daily tabbed data", and daily data in list format will be described as "daily list data".

[0058] Figure 4 The daily label data is generated using a spreadsheet software of a computer. For example, a table (format) of the daily label data is generated using Excel (registered trademark) of Microsoft (registered trademark).

[0059] In the daily label data, a plurality of item cells 40A to 40F and input cells 44B to 44F are provided for one record 46. Item characters indicating input contents are input in advance to the item cells 40A to 40F. In addition, the contents of the corresponding business corresponding to each item cell 40B to 40F are input to the input cells 44B to 44F.

[0060] In addition, Figure 4 In the illustrated daily label data, multiple cells based on spreadsheet software are connected to form an item cell and an input cell. In addition, grid lines are drawn on the boundaries of the connected item cells and input cells. In the following description, except for special cases, the adjacent relationship between cells is described based on the connected cells.

[0061] As described later, the daily report label data having item cells and input cells arranged in a plurality of rows and columns is shaped into a daily report data shaping process by the management server 20 (daily report data shaping device). Figure 5Example of daily list data. In the daily list data, one record is arranged in one column for each item. And the same items in each record are arranged in the row direction.

[0062] in addition, Figure 4 The items of daily label data are Figure 5 For example, the item cells 40A to 40F of the daily label data correspond to the item cells 50A, 50C to 50G of the daily list data.

[0063] As described later, the management server 20 can generate such daily list data based on the daily tag data of only one building (for example, the daily tag data provided from the central management device 10A). In addition, the management server 20 can generate such daily list data based on the daily tag data of multiple buildings (for example, the daily tag data provided from the central management devices 10A and 10B).

[0064] Reference Figure 2 , Figure 6 , the extraction item character storage unit 31 stores an extraction setting table, which is information for generating daily list data based on daily label data. For example, the daily label data (refer to Figure 4 ) is used as the extracted item character.

[0065] For example, as these extraction item characters, the extraction item character storage unit 31 has registered (stored) Figure 4 The item cells of the daily label data record the occurrence date (item character of item cell 40B), end date (item character of item cell 40C), correspondent (item character of item cell 40D), content (item character of item cell 40E) and disposal (item character of item cell 40F).

[0066] Reference Figure 6 The extraction setting table assigns identification codes (ID) to these extraction item characters. Figure 7 In the example, the identification symbol is shown as the extracted item character ID (k_CID). Substitute Figure 6 The number marked in the ID column.

[0067] A so-called word library is formed in the extraction setting table. For example, a synonym column is formed next to the extraction item character column. In the synonym column, synonyms of the extraction item characters are registered. For example, as synonyms of the extraction item character "occurrence date and time", "receipt date and time", and "occurrence date and time" are registered.

[0068] When characters corresponding to these synonyms are searched during the daily report shaping process described later, the input characters corresponding to the synonyms (e.g., "occurrence date and time") (e.g., "August 1, 2019 09:50") are arranged in the same column as the input characters corresponding to the extracted item characters (e.g., "occurrence date and time") when generating the daily report list.

[0069] In addition, the extraction setting table sets the attributes of the extraction items as daily items. For example, for the extraction item character "occurrence date and time", "date and time" is set as the attribute of the character string to be input. In addition, for the extraction item character "content", "character string" is set as the attribute of the character string to be input.

[0070] In addition, the number of characters to be input for each item is set in the extraction setting table. For example, for the extraction item character "occurrence date and time", the number of characters is set to less than 15 characters. In addition, for the extraction item character "content", the number of characters is set to be unlimited.

[0071] In addition, the position of the priority cell is set in the extraction setting table. The priority cell is set for the cells surrounding the searched item cell, and determines which position of the surrounding cells is preferentially processed as the input cell (corresponding input cell) for the item cell. For example, as described later, when multiple matching cells that meet the attribute condition and the character number condition are extracted for a certain item cell, the matching cell located at the priority cell is extracted and finally used as the corresponding input cell.

[0072] In addition, the setting contents of the extraction setting table can be obtained from the input unit 26 (see Figure 1 ) via the setting change unit 37 (refer to Figure 2 For example, the setting change unit 37 performs changes such as adding synonyms or adding extraction item characters.

[0073] <Daily News Forming Process>

[0074] exist Figure 7 , Figure 8 In FIG. 1 , a flowchart of a daily report shaping process based on the daily report shaping device (management server 20) of this embodiment is illustrated. Figures 9 to 12 , the operation contents for daily label data are illustrated.

[0075] When the central management devices 10A and 10B (refer to Figure 1 ) receives the daily tag data, the search range determination unit 32 (refer to Figure 2) Extract the record ID (k_RID) of the daily label data (S10). The record ID is input into the item cell 40A (refer to Fig. 9 ) number.

[0076] Then, the search range determination unit 32 counts the record ID (k_RID) of the daily record tag data (S12). In other words, the search range determination unit 32 counts the number of records recorded in the daily record tag data.

[0077] The search range determination unit 32 then finds the boundary of a single record based on the record ID assigned to each record. Specifically, the search range determination unit 32 sets the record ID to an initial value (k_RID=1) (S14) and sets the search range within the boundary 50 of k_RID=1 (S16).

[0078] Next, the extraction item search unit 33 refers to the extraction setting table (reference Figure 6 ), the extraction item character ID (k_CID) is set to an initial value (k_CID=1) (S18). Thus, the extraction item character is set to "occurrence date and time" and its synonyms.

[0079] Next, the extraction item search unit 33 searches for an extraction item cell that is a cell containing the set extraction item character (predetermined extraction item character) or a synonym thereof within the record boundary 50. Specifically, it is determined whether the set extraction item cell exists within the record boundary 50 (S20). If there is no extraction item cell within the boundary 50, the listing of the set extraction item character is postponed (S38).

[0080] On the other hand, Fig.10 As shown in the example of item cell 40B, in step S20, when the extraction item cell exists within the boundary 50 of the record, the management server 20 searches for an input cell corresponding to the set extraction item character (hereinafter referred to as a corresponding input cell as appropriate).

[0081] Specifically, the candidate cell setting unit 34 sets the cells around the extraction item cell searched in step S20 as candidate cells (S22). Fig.11 As shown in the example, the adjacent cells within the border 50 of the item cell 40B, which is the extracted item cell, are set as candidate cells. The adjacent cells are, for example, cells that share at least a portion of the border (ruled lines) with the extracted item cell. Fig.11 , the item cells 40A, 40D and the input cell 44B surrounded by the dotted lines are selected as candidate cells.

[0082] Then, the candidate cell setting unit 34 excludes cells containing extraction item characters or their synonyms having IDs different from the currently set (i.e., specified) extraction item character ID (k_CID) from the candidate cells (S24). Figure 6 and Fig.12 , exclude the item cell 40D containing the extraction item character (correspondent) having an ID (CID=3) different from the currently set extraction item character ID (k_CID=1) from the candidate cells. By setting such an exclusion process, it is possible to suppress the extraction of cells containing extraction item characters different from the currently set extraction item characters as corresponding input cells.

[0083] Then, the candidate cell setting unit 34 determines whether there is any remaining candidate cell in which the attribute "date and time" corresponding to the currently set extraction item character "occurrence date and time" is input (refer to Figure 6 ) of the character (hereinafter appropriately described as an attribute-matching cell) (S26).

[0084] If there is no cell with the attribute matching among the candidate cells, the daily report list generation unit 36 ​​(refer to Figure 2 ) Daily list data (refer to Figure 5 ) is set to a blank column (S28), and the process proceeds to step S38. For example, the cell of the row with record ID=1 in the column of the occurrence date and time cell 50C is set to a blank column.

[0085] On the other hand, when there is an attribute-matching cell among the candidate cells, the attribute determination unit 35 determines whether the number of characters in the attribute-matching cell satisfies (or clears) the character number limit set in the extraction setting table (S30). In addition, in this determination, multiple attribute-matching cells may be extracted.

[0086] If there is no cell satisfying the character limit among the attribute matching cells (hereinafter referred to as a character count matching cell as appropriate), the daily report list generating unit 36 ​​(refer to Figure 2 ) Daily list data (refer to Figure 5 ) is set to a blank cell (S28) and the process goes to step S38.

[0087] On the other hand, when a cell matching the number of characters is extracted from the attribute matching cells, the attribute determination unit 35 determines whether there are multiple cells matching the number of characters (S32). In the case where there is only one cell matching the number of characters (for example, only the input cell 44B), the daily list generation unit 36 ​​associates the character number matching cell as the corresponding input cell and the character string "9 / 417:44" in the cell with the currently set extraction item character. In addition, the daily list generation unit 36 ​​generates a daily list (see Figure 5 ), a character string "9 / 417:44" is input into the cell (corresponding cell) of the row of record ID=1 in the column of the occurrence date and time cell 50C (S34).

[0088] On the other hand, if there are a plurality of cells with the same number of characters in step S32, the daily report list generating unit 36 ​​refers to the extraction setting table (reference Figure 6 ) of the priority cell column, extracting the item cell 40B ( Fig.12 ) is located in the priority position (priority cell) as the corresponding input cell. Then, the daily list generation unit 36 ​​associates the character string ("9 / 4 17:44") in the corresponding input cell with the currently set extraction item character. Then, the daily list generation unit 36 ​​generates a daily list data (refer to Figure 5 ), a character string "9 / 417:44" is input into the cell (corresponding cell) of the row of record ID=1 in the column of the occurrence date and time cell 50C (S36).

[0089] In addition, when none of the plurality of matching cells matches the priority cell, the character strings in the plurality of matching cells may be collectively input into the daily list data, thereby preventing the character strings in the matching cells from being omitted from being reflected in the daily list data.

[0090] After the daily list data is input, the search range determination unit 32 (refer to Figure 2 ) determines whether the currently set extraction item character ID (k_CID) is the maximum value (k_CID = MAX) (S38). If the extraction item character ID (k_CID) is not the maximum value, the search range determination unit 32 increments the extraction item character ID (k_CID) (S40) and returns to step S18.

[0091] On the other hand, when the ID (k_CID) of the extracted item character is the maximum value, the search range determination unit 32 determines whether the record ID is the maximum value (k_RID=MAX) (S42). When the record ID (k_RID) is not the maximum value, the search range determination unit 32 increments the record ID (k_RID) (S44) and returns to step S16. When the record ID is the maximum value (k_RID=MAX), the daily report shaping process ends.

[0092] By executing the above steps for all the IDs (k_CID) of the extracted item characters, the characters input for each item in one record are input to the daily list data in a mutually associated state by the daily list generation unit 36. Furthermore, by executing the above steps for all the records of the daily label data, the characters extracted from the corresponding cells of each record, which are associated with each item in the record, are arranged in a column by item in the daily list by the daily list generation unit 36.

[0093] Thus, in the daily report formatting process of this embodiment, regardless of the format of the daily report tag data, the items and their input contents can be associated, and the daily report list data can be generated based on the association. Therefore, daily report tag data of different formats can be collected to generate one daily report list data.

[0094] Description of symbols

[0095] 10A, 10B: central management unit; 12A, 12B: computers; 20: management server (daily data shaping device); 31: extracted item character storage unit; 32: search range determination unit; 33: extracted item search unit; 34: candidate cell setting unit; 35: attribute judgment unit; 36: daily list generation unit; 37: setting change unit; 40A~40F: item cells of daily label data; 44A~44F: input cells of daily label data; 46: record; 50: record boundary; 50A~50G: item cells of daily list data.

Claims

1. A daily data shaping device that shapes daily data in a label format in which item cells and input cells are arranged over a plurality of rows and columns, wherein: The daily data shaping device has: an extracted item character storage unit in which extracted item characters as characters of daily report items and attributes of the daily report items are registered by identification symbols; an extraction item search unit that searches for an extraction item cell in one record of the daily data including a plurality of records, the extraction item cell being a cell including a predetermined extraction item character or a synonym thereof; a candidate cell setting unit that sets the cells around the searched extraction item cell as candidate cells; an attribute determination unit that searches, from among the candidate cells, a matching cell in which a character matching an attribute of the daily item corresponding to the predetermined extraction item character is input; as well as a list generating unit that associates the prescribed extraction item characters with the characters in the matching cells, The candidate cell setting unit sets the candidate cell by excluding cells including the extraction item character or a synonym thereof to which an identification symbol different from the predetermined extraction item character is assigned, from among cells surrounding the searched extraction item cell; The extraction item character storage unit stores the position of a priority cell among cells surrounding the extraction item cell. When a plurality of the matching cells are found, the list generating unit associates the characters of the matching cells corresponding to the positions of the priority cells with the predetermined extraction item characters; When a plurality of the matching cells are found and the position of any of the cells does not correspond to the position of the priority cell, the list generating unit associates the characters of the plurality of matching cells with the specified extraction item characters; The list generating unit further collects characters in the associated plurality of matching cells and inputs the characters into a daily report list.

2. The daily report data shaping device according to claim 1, wherein: The daily report data shaping device includes a search range determination unit for finding a boundary of a single record based on an identification code given to each record in the daily report data including a plurality of records.

3. The daily report data shaping device according to claim 1 or 2, wherein: The list generating unit arranges the characters in the matching cells extracted from each record in a row in a daily report list in association with the predetermined extraction item characters.

4. The daily report data shaping device according to claim 3, wherein: The list generating unit arranges the characters of the corresponding cells associated with the extracted item characters in a column of cells in the order of recording in the daily report list, Furthermore, when there is no matching cell among the candidate cells around the predetermined extraction item characters in a predetermined record, the list generation unit sets a cell corresponding to the record and the extraction item characters in the daily report list as a blank.

Images