Summary table analysis system and method

Abstract

To analyze the contents of a summary table at a low cost.SOLUTION: A two dimensional table in which a plurality of choices or data contents are arranged in each of a row item and a column item is created on the basis of a recorded form conforming to an extraction condition, the row item being one of record items included in the recorded form and the column item being another one of the record items, and a tabulation table in which a frequency is stored in each of cells where rows and columns intersect is created. A CSV file is created from the created summary table (step 55), and the created CSV file and a processing command statement containing a request to analyze the characteristics of the CSV file are transmitted to the generation and AI device (step 55,61,71).SELECTED DRAWING: Figure 4

Description

[Technical Field]

[0001] The present invention relates to a spreadsheet analysis system and method. [Background technology]

[0002] Patent document 1 describes a system that determines whether expert intervention is required by using a trained model that inputs features obtained from sensor shoes and outputs the probability that a subject will fall within a specified period of time and the probability that they will not fall within a specified period of time. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2023-155681

[0004] Generating a trained model generally requires a large amount of training data, and generating a trained model to obtain highly accurate output requires a certain cost. Outputting the probability of falling or not falling is, in a sense, data analysis, and spending more than necessary on data analysis may not be desirable or necessary. Summary of the Invention [Problem to be solved by the invention]

[0005] An object of the present invention is to enable the content of a summary table to be analyzed at low cost.

[0006] The summary table analysis system of the present invention includes: a readout means for reading out a recorded form that conforms to given extraction conditions from a recorded form storage means that stores recorded forms in which data has been recorded using a record form in which multiple types of record items are defined; a summary table creation means for creating a two-way table based on the recorded form read out by the readout means, in which record items selected from the multiple types of record items included in the recorded form are used as row items and column items, with different data contents or options listed for each of the row items and column items, and creating a summary table in which frequencies are stored in each cell where the data contents or options in the row items intersect with the data contents or options in the column items; a tabular text data creation means for creating tabular text data from the summary table created by the summary table creation means; a processing command creation means for creating the created tabular text data and a processing command including a request for feature analysis of the tabular text data; a transmission means for transmitting the created processing command to a generation AI device; and a receiving means for receiving the generation results by the generation AI device. The tabular text data can be, for example, CSV (Comma Separated Values) data.

[0007] A recording form is used for data recording. The recording form has multiple types of recording items defined in advance, and by entering data into the multiple types of recording items defined in the recording form, data can be recorded without excess or deficiency.

[0008] For example, an accident report form used in a nursing home may have six record items: reporter, date of occurrence, time of occurrence, location of occurrence, type of accident, and accident circumstances. In this case, an accident report is completed by recording data in each of the six record items.

[0009] A recorded form that meets given extraction conditions is read from a storage means that stores recorded forms with data recorded in the record form. The extraction conditions include the type of recorded form, a period based on the date and time included in the recorded form, etc.

[0010] Based on the recorded form read from the storage means in accordance with the extraction conditions, a two-way table (matrix table) is created in which row items and column items are selected from the multiple types of recorded items provided in the recorded form, and different data contents or options are listed in each of the row items and column items, and a summary table is created in which frequencies are stored in each cell where the data contents or options in the row items intersect with the data contents or options in the column items.

[0011] In one embodiment, the multiple record items defined by the recorded form include optional record items in which any character or number is recorded as data, and selected record items in which an option selected from a plurality of pre-prepared options is recorded as data, and when the optional record items are selected as row items and / or column items, the data contents of the selected optional record items included in the recorded form read by the reading means are arranged in the row items and / or column items of the two-dimensional table, and when the selected record items are selected as row items and / or column items, the options defined by the selected selected record items are arranged in the row items and / or column items of the two-dimensional table.

[0012] Taking the above-mentioned accident report record form as an example, of the six record items (reporter, date of occurrence, time of occurrence, location of occurrence, type of accident, and accident circumstances), the four record items (reporter, date of occurrence, time of occurrence, and situation of accident) can be designated as "optional record items," while the two (location of occurrence and type of accident) can be designated as "selective record items." The location of occurrence has options such as room, living room, toilet, and dressing room, and by selecting one option from these, the location of occurrence will be recorded as data. The type of accident has options such as tripping, falling, medication error / misdelivery, and by selecting one option from these, the type of accident will be recorded as data.

[0013] For example, suppose "Date of occurrence," one of the optional record items, is selected as the row item, and "Type of accident," one of the selected record items, is selected as the column item. In this case, the row items in the two-way table are arranged with the dates (data content) representing the dates of occurrence recorded in the read-out recorded accident report record forms. For example, if there are 10 read-out recorded accident report record forms, and the dates of occurrence recorded in the 10 record forms are different from one another, 10 different dates are arranged as row items. The column items are arranged with multiple options (such as tripping or falling) prepared in advance for the type of accident.

[0014] For example, if one accident report record form that has been read has the date of occurrence recorded as "July 31, 2024" and the type of accident recorded as "Fall," then a frequency of "1" will be stored in the cell where one of the row items, "July 31, 2024," intersects with one of the column items, "Fall." If another accident report record form that has been read is similar, then a frequency of "2" will be stored in the above cell. In other words, the recorded form that has been read from the storage means in accordance with the extraction conditions is processed, and a numerical value (this is the "frequency") representing the number of times "Fall" accidents occurred on "July 31, 2024" is stored in the cell where the row item, "July 31, 2024," intersects with the column item, "Fall."

[0015] According to this invention, tabular text data is created from a summary table, and a processing command statement including the created tabular text data and a request for feature analysis of the tabular text data is sent to a generation AI device, and the results generated by the generation AI device are received. Instead of or in addition to a summary table (two-way table) in which frequencies are stored in each of multiple cells, the results generated by the generation AI device can be used to understand the features of recorded forms that meet extraction conditions. While a summary table has frequencies (numerical values) scattered across multiple cells, the results generated by the generation AI device are expressed in natural language, for example, which makes it easier to take prompt measures afterwards and is useful for improving operations at nursing care facilities.

[0016] In a preferred embodiment, the recorded form includes a user code, and the system further includes a user information storage means for storing information about the user identified by the user code, and the information about the user identified by the user code stored in the user information storage means is used as a selection candidate for row items and / or column items of the two-way table. The information about the user includes name, gender, level of care, etc. For example, the level of care required for a person to easily fall, or the gender that is likely to suffer a fracture, can be represented in the two-way table.

[0017] In one embodiment, the two-way table and the summary table have a hierarchical structure of multiple types of row items. In another embodiment, the two-way table and the summary table have a hierarchical structure of multiple types of column items. For example, if care level is selected as the column item in the first row (upper layer) and gender is selected as the column item in the second row (lower layer), the column items will be represented in two layers in the two-way table and the summary table, and for example, a two-way table and a summary table will be represented with columns distinguishing between males and females for each of care levels 1 to 5. The generation AI device can be made to analyze the characteristics of the summary table in more detail.

[0018] In another embodiment, the processing instruction statement includes an explanatory portion of the tabular text data, and the explanatory portion of the tabular text data includes the form name of the recorded form, and the selected record item names used in the row items of the summary table and the selected record item names used in the column items of the summary table. This makes it easier for the generation AI device to generate generated sentences (analysis sentences) that are in line with the content of the tabular text data.

[0019] The present invention also provides a summary table analysis method. [Brief explanation of the drawings]

[0020] [Figure 1A] FIG. 2 is a block diagram showing the hardware configuration of the care content input system. [Figure 1B] FIG. 10 is a block diagram showing another example of the hardware configuration of the care content input system. [Figure 2] Shows the contents of the database. [Figure 3] An accident report form is shown. [Figure 4] 10 is a flowchart showing the flow of a spreadsheet analysis process. [Figure 5] A general-purpose summary screen is shown. [Figure 6] The summary table screen is shown. [Figure 7] 10 shows another example of the summary table screen. [Figure 8] Shows CSV data. [Figure 9] Indicates processing instructions and generated statements. [Figure 10] Examples of processing instructions and generated statements are shown below. [Figure 11] 10 shows another example of the tally screen. [Figure 12] Shows CSV data. [Figure 13] Examples of processing instructions and generated statements are shown below. [Example]

[0021] FIG. 1A is a block diagram showing the hardware configuration of a care content input system.

[0022] Referring to Figure 1A, the care content input system includes a record management server 10, a generation AI device 20, and an operation terminal 30, which are connected via a network (e.g., the Internet) so that they can send and receive data to and from each other. A database 11 is connected to the record management server 10, and a large number of masters and tables are stored in the database 11. The large number of masters and tables are related to each other by key items, forming a so-called relational database.

[0023] The operation terminal 30 is used to input various care (support) details provided to users (typically elderly people or people with disabilities) of a care business (care facility) (hereinafter simply referred to as "business") by staff (employees, etc.) and to record (save) the input care details (care records). The care records are used to consider care plans for users of the business, to utilize them in high-quality care services and care management, to improve the qualifications of staff at the business, and to share information. The care content input system is used in common at multiple business offices and is operated by staff at each of the multiple business offices. Multiple operation terminals 30 operated by multiple staff members are used to input care details (care records).

[0024] As mentioned above, there are multiple facilities, each of which generally has multiple users (elderly people and people with disabilities). Nursing care (assistance) for each of the multiple users at the multiple facilities is provided almost daily, and records are kept almost daily. The recorded care details include numerous items (care items), such as the user's vital signs (body temperature, blood pressure, transcutaneous arterial oxygen saturation, etc.), dietary details (amount of food eaten), oral care, height, weight, exercise, visitors, and recreational activities. The care (assistance) details recorded in the care content input system include not only details related to personal care for the user, but also the user's own personal records (such as the aforementioned body temperature, height, and weight), accident reports, etc. In addition to the operation terminal 30, data transmitted from other devices, such as a nurse call terminal (such as call time and response time) and bed sensors (such as heart rate, respiratory rate, and bed exit alerts), can also be used as input data for the care content input system.

[0025] A record management server 10 is connected to the operation terminal 30 via a network (such as the Internet). The record management server 10 manages the care (support) provided and to be provided for each user of the facility (record management, schedule management). Various reports are also managed (stored) in the record management server 10.

[0026] The record management server 10 and the operation terminal 30 are both computer devices equipped with a CPU that comprehensively controls overall operation, RAM that temporarily stores data and programs, an operating system, storage (SSD, HDD, etc.) that stores various application programs, etc., an input device (keyboard, etc.) for inputting letters, numbers, etc., a communication device that sends and receives data via a network, and a display device that displays record forms / document forms, etc. The record management server 10 can be a stationary computer device that can be connected to a network. The operation terminal 30 can be a portable computer device that can be connected to a network.

[0027] In this embodiment, the generation AI device 20 is used for analyzing data in a table format (a two-way table with row items and column items), as described below. The generation AI device 20 can be a device capable of executing a program capable of natural language processing, such as ChatGPT, Bard, or Bing.

[0028] Fig. 1B is a block diagram showing another example of the hardware configuration of the care content input system. It differs from the care content input system shown in Fig. 1A in that each of the operation terminals 30A to 30C has the functions of the record management server 10 described above and communicates directly with the generation AI device 20. The care (support) content input using each of the operation terminals 30A to 30C is recorded in databases 11A to 11C provided in each of the operation terminals 30A to 30C.

[0029] Below, we will explain a care content input system having the hardware configuration shown in Figure 1A.

[0030] FIG. 2 shows an example of master data and table data stored in the database 11 provided in the care content input system.

[0031] Referring to FIG. 2, database 11 connected to record management server 10 includes business establishment master 11A, service type master 11B, form master 11C, user master 11D, and care record table 11E.

[0032] The establishment master 11A includes data such as "service type code," "establishment code," and "establishment name."

[0033] The "service type code" is a code that indicates the type (kind) of service provided by the establishment. The "establishment code" is a code that identifies each establishment, and the name of the establishment identified by the establishment code is the "establishment name."

[0034] The service type master 11B includes data such as a "service type code," a "service type name," etc. The service type code associates the establishment master 11A and the service type master 11B described above.

[0035] The service type name is the name of the service type specified by the service type code. For example, it is "home care," "day care," "nursing care facility service," etc. The service type code and the name of the service type corresponding to the service type code are stored in the service type master 11B.

[0036] The form master 11C includes data such as a "service type code," a "form code," and a "form name." The service type code associates the above-described service type master 11B with the form master 11C.

[0037] The "form code" is a code for identifying various record forms and report forms, and the "form name" is the name of the form identified by the form code. In the care content input system, multiple forms for inputting care records are prepared in advance, and by selecting one of the multiple forms, a specific form can be displayed on the display screen of the operation terminal 30. Data recording fields (selection fields) are prepared in advance in the forms, and the form is filled out by inputting data or making selections according to the form. An example of a form will be described later.

[0038] The user master 11D includes data such as "establishment code," "user code," "name," "gender," "age," "level of care required," etc. The establishment master 11A and the user master 11D are associated with each other by the establishment code.

[0039] The "user code" is a code for identifying a user who uses a specific establishment identified by the establishment code. The name, gender, age, level of care required, etc. of the specific user identified by the user code are stored in the user master 11D.

[0040] In addition to the business code, user code, and form code mentioned above, the care record table 11E stores the "recording date and time" which indicates the date and time the record was made, and the "care record content" which indicates the actual content such as numbers, characters, etc. entered into or selected from the form.

[0041] Figure 3 shows an example of a form, Accident Report Form 41.

[0042] The accident report form 41 is a form that is entered (created, recorded) when an accident occurs to a user of the business, and has defined record items (data entry fields) for entering (selecting) the reporter, date of occurrence, time of occurrence, location of occurrence, type of accident, and accident occurrence circumstances. By entering data in order according to these record items in the accident report form 41, a complete recorded accident report is created, and this is stored in the nursing care record table 11E.

[0043] Multiple record items can be broadly divided into two types:

[0044] The first type is an item in which any character or number is recorded as data. In the case of the accident report form 41, these would be "reporter," "date of occurrence," "time of occurrence," and "accident occurrence circumstances." Items in which any character, number, etc. is recorded as data will be referred to as "optional recording items" hereinafter. For "date of occurrence" and "time of occurrence," numbers representing the date and time are typically entered, so the type of characters that can be entered may be limited to numbers.

[0045] The second type is an item in which one of multiple pre-prepared options is selected and the selected option is recorded as data, and in the case of the accident report form 41, this corresponds to "location of occurrence" and "type of accident." Such an item in which one of the pre-prepared options is selected is hereinafter referred to as a "selected recording item."

[0046] Fig. 4 is a flowchart showing the flow of the summary table analysis process, which is one of the functions of the care content input system. Fig. 5 shows a general summary screen 81, and Figs. 6 and 7 show a summary table screen 82. The general summary screen 81 and the summary table screen 82 are displayed on the display device of the operation terminal 30.

[0047] The summary table analysis process is a process for analyzing the care records stored in the care record table 11E of the database 11 of the record management server 10, and is a process for deriving various trends and characteristics using the large amount of data stored in the care record table 11E as care details are recorded on a daily basis.

[0048] First, the general-purpose tally screen 81 is displayed on the display screen of the operation terminal 30 (step 51).

[0049] 5, the general-purpose tally screen 81 includes a business establishment selection field 81A, a tally period input field 81B, a tally target selection field 81C, and a data display field 81D. Fig. 5 shows the general-purpose tally screen 81 using the recorded accident report form 41 (see Fig. 3) as an example.

[0050] The establishment selection field 81A displays the establishment names registered in the above-mentioned establishment master 11A in a selectable manner. The aggregation period input field 81B is used to input the period of the form to be aggregated (start and end periods based on the occurrence date, recording date, etc.). The aggregation target selection field 81C displays the form names registered in the above-mentioned form master 11C in a selectable manner. Record data (recorded forms) that have an establishment code corresponding to the establishment name selected in the establishment selection field 81A, a recording date and time (occurrence date and time) within the aggregation period input in the aggregation period input field 81B, and a form code corresponding to the form name selected in the aggregation target selection field 81C are read from the care record table 11E. On the general-purpose aggregation screen 81 shown in FIG. 5, the read record data is combined with the user's name, sex, age, and care level (these are record data stored in the user master 11D) associated with the user code in the record data, and displayed in the data display field 81D.

[0051] The general-purpose tally screen 81 includes a tally button 81E. Clicking this tally button 81E inputs a tally instruction (step 52). In accordance with the tally instruction, a tally sheet screen 82 is displayed on the operation terminal 30 in place of the general-purpose tally screen 81 (step 53).

[0052] 6, the summary table screen 82 includes a column item type selection field 82A, a row item type selection field 82B, a column item detail display field 82C, a row item detail display field 82D, and a summary field 82E.

[0053] The column item type selection field 82A and row item type selection field 82B display, in a selectable manner, the item names displayed in the data display field 81D of the general-purpose summary screen 81 (FIG. 5), i.e., the record item names of the summary target form selected on the general-purpose summary screen 81 and some of the record item names of the user master 11D. If the summary target is an "accident report," the accident report form 41 has six record items, "reporter," "date of occurrence," "time of occurrence," "location of occurrence," "accident type," and "accident occurrence circumstances," as described above, and therefore these six record item names and some of the record items of the user master 11D, name, sex, age, and care level, are displayed in a selectable manner.

[0054] The summary table screen 82 shown in FIG. 6 shows an example in which "accident type" is selected in the column item type selection field 82A, and "location of occurrence" is selected in the row item type selection field 82B.

[0055] The record item "Accident Type" is a selective record item that includes six options: "Fall," "Fall," "Medication Error / Misdelivery," "Fracture, Contusion, Bruise, or Injury While Caring for a Person," "Fracture, Contusion, Bruise, or Injury of Unknown Cause," and "Other." The record item "Location of Occurrence" is a selective record item that includes eight options: "Room," "Living Room," "Toilet," "Dressing Room," "Bathroom," "Stairs," "Communication Room," and "Other." When a selective record item is selected in the column item type selection field 82A and / or row item type selection field 82B, the option is displayed for each column or row in the column item detail display field 82C and / or row item detail display field 82D. As a result, a two-way table (matrix) is displayed in the summary field 82E.

[0056] In the tally column 82E, the number of occurrences is tallied for each combination of the accident type option and the accident location option recorded in the accident report form 41 according to the recorded accident report form 41 read from the nursing care record table 11E, and a tally table is displayed in which the frequency is stored in each cell where an option in the column item intersects with an option in the row item. Referring to Figure 6, for example, the number "8" is entered in the cell where the column for the accident type "fall" intersects with the row for the accident location "room." This means that, of the recorded accident report forms 41 read from the nursing care record table 11E, there are eight recorded accident report forms 41 in which "fall" is recorded as the accident type and "room" is recorded as the accident location.

[0057] FIG. 7 shows an example in which "care level" is selected in the column item type selection field 82A, and "accident type" is selected in the row item type selection field 82B.

[0058] As described above, the "accident type" selected in the line item type selection field 82B is a selected record item, so the line item detail display field 82D displays six options for the selected record item "accident type" on a line-by-line basis.

[0059] On the other hand, the "care level" selected in the column item type selection field 82A is an "optional record item" in which any characters, numbers, etc. are recorded as data. When an optional record item is selected in the column item type selection field 82A and / or the row item type selection field 82B, the record data displayed on the general-purpose summary screen 81 (FIG. 5), that is, the record data (recorded form) read from the nursing care record table 11E, which has an establishment code corresponding to the establishment name selected in the establishment selection field 81A, has a recording date and time (occurrence date and time) within the summary period entered in the summary period input field 81B, and has a form code corresponding to the form name selected in the summary target selection field 81C, is used, and the record data for the selected optional record item is displayed in the column item detail display field 82C and / or the row item detail display field 82D with duplicates eliminated.

[0060] For example, when the optional record item "Care Level" is selected in the column item type selection field 82A, the record data (Care Level 1, Care Level 2, Care Level 3, etc.) used to display "Care Level" on the general summary screen 81 (Fig. 5) is used, duplicates are eliminated, and the data is displayed in a row in the column item detail display field 82C. Fig. 7 shows that the record data for "Care Level" on the general summary screen 81 includes five record data items: "Care Level 1," "Care Level 2," "Care Level 3," "Care Level 4," and "Care Level 5," and these five record data items are displayed in a row in the column item detail display field 82C.

[0061] In the tally column 82E, the number of accidents for each combination of accident type options and care level types is tallied, and a tally table is displayed in which the frequency is stored in each cell where the column item and row item intersect. For example, referring to Figure 7, the cell where the column for care level "Care Level 1" intersects with the row for accident type "Fall" contains the value "7." This means that in the recorded accident report form 41 read from the care record table 11E, "Fall" is recorded as the accident type, and the number of users who fell with a care level of "Care Level 1" is seven.

[0062] Even when other optional record items such as "Name," "Sex," "Age," "Date of Occurrence," "Time of Occurrence," and "Reporter" are selected in the column item type selection field 82A, the record data for the selected optional record items is displayed in the column item detail display field 82C, with duplicates eliminated. This also applies to the row item type selection field 82B and the row item detail display field 82D.

[0063] The summary table screen 82 shown in Fig. 6 makes it possible to understand, for example, what types of accidents tend to occur in what locations. The summary table screen 82 shown in Fig. 7 makes it possible to understand what types of accidents tend to occur in what level of care users. However, it is necessary to closely check the multiple numerical values ​​scattered and displayed in the summary column 82E of the summary table screen 82, and the more row and column items there are in the summary column 82E, the more difficult it may become to perform analysis using only the numerical values.

[0064] Therefore, in the care content input system, analysis processing that goes one step further than the display of the summary table screen 82 is performed.

[0065] An analysis button 82F is provided on the spreadsheet screen 82. When this analysis button 82F is clicked, an analysis instruction is input to the operation terminal 30 (step 54).

[0066] Upon receiving the input of the analysis instruction, the operation terminal 30 creates CSV (comma separated value) data from the display data in the summary column 82E of the summary table screen 82, and sends a processing command statement including the CSV data, such as a feature analysis request, to the record management server 10 (step 55).

[0067] Fig. 8 shows CSV data 83 created from data representing the summary column 82E of the summary table screen 82 shown in Fig. 6. The CSV data 83 is text data that corresponds one-to-one to the tabular data, with column data separated by commas and row data separated by line breaks.

[0068] Upon receiving a processing instruction (prompt) including the CSV data shown in Figure 8, the record management server 10 sends the processing instruction to the generation AI device 20 (step 61). The generation AI device 20 generates a generated statement according to the processing instruction (step 71). The generated statement is sent from the generation AI device 20 to the operation terminal 30 via the record management server 10 (steps 72, 62). For example, information is input into the generation AI device 20 using an API (application programming interface) provided by the business operator that provides the generation AI device 20, and the information generated by the generation AI device 20 is obtained.

[0069] Figure 9 shows a processing command statement 91 sent from the operation terminal 30 to the generation AI device 20 via the record management server 10 based on the summary table screen 82 shown in Figure 6, and a generated statement 92 generated in the generation AI device 20. Figure 9 shows a simplified version of the CSV data 83 included in the processing command statement 91.

[0070] More specifically, the processing command statement 91 includes an explanation section ("The following is...") and a processing command section ("Please return... from the tabulation results.") for the CSV data 83. A common prompt can be used for the processing command section regardless of the type of CSV data. On the other hand, a different prompt is created for the explanation section for each CSV data. That is, the explanation section includes the form name ("Accident Report") used to display the summary table screen 82, the name of the service type ("Nursing Care Facility Service") provided by the establishment whose name is selected on the general summary screen 81 (identified from the establishment master 11A and the service type master 11B), and the names of two selected record items ("Location of Occurrence" and "Type of Accident") used on the summary table screen 82. The operation terminal 30 creates the processing command statement 91 including these specific terms (words) in the explanation section. This enables the generated sentences (analysis sentences) generated by the generation AI device 20 to be in accordance with the content of the CSV data.

[0071] The generated sentence is displayed on the display screen of the operation terminal 30 (step 56). In the generated sentence 92, the characteristics grasped from the numerical values ​​scattered in the summary column 82E of the summary table screen 82 are expressed in natural language, which makes it easier to take prompt measures afterwards, and is useful for improving operations at nursing care facilities.

[0072] FIG. 10 shows a processing command statement 93 and a generated statement 94 generated by the generation AI device 20 based on the data representing the summary column 82E of the summary table screen 82 shown in FIG.

[0073] Fig. 11 shows another example of the spreadsheet screen 85. It differs from the spreadsheet screen 82 shown in Fig. 6 and Fig. 7 in that it has two selection fields for column items, a first column item type selection field 85A and a second column item type selection field 85B, and two selection fields for row items, a first row item type selection field 85C and a second row item type selection field 85D, and in that two column item detail display fields 85E and 85F are displayed hierarchically, one above the other, in response to the selection of the first and second column items for the column items.

[0074] 11, "Care Level" is selected in the first column item type selection field 85A, and "Gender" is selected in the second column item type selection field 85B. Accordingly, five column items, "Care Level 1" to "Care Level 5," are arranged in the column item detail display field 85E of the summary table screen 85 (first hierarchical level), and directly below each of the column items, "Care Level 1" to "Care Level 5," the column items "Male" and "Female" are arranged (second hierarchical level). As for row items, "Accident Type" is selected in the first row item type selection field 85C, and the second row item type selection field 85D is blank (nothing selected), so only the six options for the selected record item, "Accident Type," are displayed row by row in the row item detail display field 85G.

[0075] In the summary column 85H, the number of accidents is tallied for each combination of the accident type options and the type of care level by gender, and a summary table is displayed in which the frequency is stored in each cell where the column item and row item intersect. Figure 12 shows CSV data 86 created from the data representing the summary column 85H of the summary table screen 85 shown in Figure 11.

[0076] 13 shows a processing command statement 95 based on the summary table screen 85 shown in FIG. 11, which is created when the analysis button 85I on the summary table screen 85 is clicked, and a generated statement 96 generated by the generation AI device 20. Since the care level is summarized by gender in the summary column 85H, a generated statement 96 that distinguishes between genders is generated. [Explanation of symbols]

[0077] 10 Records Management Server 11 Database 11A Business establishment master 11B Service type master 11C Form Master 11D User Master 11E Nursing care record table 20 Generation AI device 30 Operation terminal 41 Accident Report Form 81 General purpose summary screen 81A Business establishment selection field 81B Aggregation period input field 81C Aggregation target selection field 81D Data display column 81E tally button 82,85 Summary table screen 82A, 85A, 85B Column item type selection field 82B, 85C, 85D Line item type selection field 82C,85E,85F Column item details display field 82D,85G Line item details display field 82E, 85H Summary column 82F,85I Analysis button 83,86 CSV data 91, 93, 95 Processing Instruction Statements 92,94,96 Generated sentence

Claims

1. a reading means for reading a recorded form that conforms to given extraction conditions from a recorded form storage means that stores a recorded form in which data has been recorded using a recording form having a plurality of types of record items defined; a summary table creation means for creating a two-way table in which record items selected from a plurality of types of record items included in the recorded form are set as row items and column items, respectively, based on the recorded form read by the reading means, and in which different data contents or options are arranged in the row items and column items, and creating a summary table in which frequencies are stored in each cell where the data contents or options in the row items intersect with the data contents or options in the column items; a tabular text data creation means for creating tabular text data from the summary table created by the summary table creation means; a processing instruction statement creation means for creating the created tabular text data and a processing instruction statement including a request for feature analysis of the tabular text data; A transmitting means for transmitting the created processing instruction statement to the generating AI device; A receiving means for receiving the generation result by the generation AI device is provided. Summary table analysis system.

2. The recorded form includes a user code, further comprising a user information storage means for storing information about the user identified by the user code, information about the user identified by the user code stored in the user information storage means is used as a selection candidate for row items and / or column items of the two-way table; The spreadsheet analysis system according to claim 1 .

3. The plurality of record items defined by the recorded form include an optional record item in which any character or number is recorded as data, and a selection record item in which an option selected from a plurality of options prepared in advance is recorded as data, When the optional record items are selected as row items and / or column items, the data contents of the selected optional record items included in the recorded form read by the reading means are arranged in the row items and / or column items of the two-dimensional table, When the selection record item is selected as a row item and / or a column item, the options specified by the selected selection record item are arranged in the row items and / or column items of the two-dimensional table. The spreadsheet analysis system according to claim 1 or 2.

4. The above two-way table and summary table have a hierarchical structure with multiple types of line items. The spreadsheet analysis system according to claim 1 or 2.

5. The above two-way table and summary table have a hierarchical structure with multiple types of column items. The spreadsheet analysis system according to claim 1 or 2.

6. the processing command statement includes an explanatory part of the tabular text data, The description part of the tabular text data includes the form name of the recorded form, and the record item names used in the row items of the summary table and the record item names used in the column items of the summary table. The spreadsheet analysis system according to claim 1 or 3.

7. The reading means reads out a recorded form that conforms to the given extraction conditions from a recorded form storage means that stores recorded forms in which data is recorded using a recording form in which a plurality of types of recording items are defined; A summary table creation means creates a two-way table based on the read recorded form, in which two record items selected from a plurality of types of record items provided in the recorded form are used as row items and column items, and in which different data contents or options are arranged in each of the row items and column items, and creates a summary table in which frequencies are stored in each cell where the data contents or options in the row items intersect with the data contents or options in the column items; The tabular text data creation means creates tabular text data from the created summary table, The transmission means transmits the processing instruction to the generation AI device, The receiving means receives the generation result by the generation AI device. Summary table analysis method.

Images