JP2007219862A - Business form creation device, method, and program, and business form display device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide information not obtainable by a conventional way of use when creating a business form by use of marketed table creation software. <P>SOLUTION: When some data number displayed on the business form is selected as processing requirement by inserting information about layout of the business form to a sheet when displaying the business form on the sheet by sticking the business form comprising a list of data numbers to the sheet created by the table creation software, a configuration allowing specification of retrieval of an item value of the data number is adopted. According to the configuration, data configuring the data number selected as the processing requirement can be retrieved. Thereby, detailed contents of the data configuring the data number selected as the processing requirement can be displayed, or the data configuring the data number selected as the processing requirement can be more minutely classified and displayed. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a form creation apparatus and method for creating a form, a form display apparatus for displaying a form created by the form creation apparatus, and a form creation program used for realizing the form creation apparatus, Form creation device and method capable of providing information required by the user to the user while using widely used table creation software, and form display device for displaying the form created by the form creation device And a form creation program used for realizing the form creation apparatus.

  As one method of creating a form, it is widely performed to create a form by using a table creation software (spreadsheet software) such as Excel (registered trademark) provided by Microsoft Corporation.

  Excel enables the input of data described in a list format and creates a form by pasting the input data on a sheet. Various useful functions such as a sort function, a tabulation function, an extraction function, and a calculation function are available. It has a special function.

  From now on, when a form is created using Excel, the user can obtain an advantage that a form of a desired format can be created very easily by using these functions.

Of course, creating a form without using general-purpose software such as Excel is also widely performed, and various mechanisms have been proposed to make it easy (for example, patent documents). 1).
JP 2004-199662 A

  Certainly, if a form is created using Excel, the user can create a form of the desired format very easily by using various functions of Excel.

  However, when using Excel, the data input to Excel can be manipulated in various ways, but any operation other than the input data is performed even if the data is related to the input data. I can't.

  For example, when using Excel to create a form that summarizes the number of patients who have visited a certain hospital according to the department in which those patients have taken, for example, Even if you want to know the age group, you can't create data on the number of patients by age group of internal medicine unless you have entered data on the number of patients by age group for each department. is there.

  Thus, when creating a form using Excel, the user can perform various operations on the data input to Excel, but cannot perform any operation on data other than the input data. There is a problem that information required by the user cannot be provided to the user.

  The present invention has been made in view of such circumstances, and when creating a form while using widely used table creation software, information that could not be provided by using the conventional table creation software. The purpose is to realize a new form creation technology that enables the user to provide information required by the user.

[1] Form Creation Device of the Present Invention To achieve this object, the form creation device of the present invention has a configuration in which a form is created using table creation software such as Excel, and ) Design means to design the layout of the form by setting the item values of the form, and (b) those data requests to the data storage mechanism by searching the number of data with the item value set by the design means The number of data is obtained, the creation means for creating form data according to the layout designed by the design means, and (c) the form data created by the creation means is pasted on the sheet created by the table creation software, and further on the sheet On the other hand, the insertion means for inserting the layout information designed by the design means, and (d) the form pasted on the sheet displayed on the sheet by the table creation software When there is a processing request specifying a certain number of data, an execution means for specifying an item value associated with the number of data according to the layout information inserted in the sheet and executing a predetermined process corresponding thereto The structure to be provided is taken.

  When adopting this configuration, the form creation device of the present invention further selects the layout information to be edited when there is a request to edit the layout of the form on the sheet created by the table creation software, and uses the design means. In this case, the design means should design the layout of the form while clearly indicating the item values defined by the layout information selected by the activation means. The layout information may be edited.

  Then, when adopting this configuration, the form creation device of the present invention further obtains layout information about the form to be used when there is a use request for the created form, and obtains the acquisition means. A new form is created by designating a search period that is different from the search period designated when creating the form to be used in accordance with the layout information and requesting the data storage mechanism to perform a search. And creating means.

  Each of the above processing means can also be realized by a computer program. This computer program is provided by being recorded on an appropriate computer-readable recording medium or provided via a network, and is used when implementing the present invention. The present invention is realized by being installed and operating on a control means such as a CPU.

  In the form creation device of the present invention configured as described above, when the form layout is designed by setting the item value of the form, the data storage mechanism is requested to search for the number of data having the set item value. The number of such data is acquired, the form data according to the layout is created, the created form data is pasted on the sheet created by the table creation software, and the form layout designed for the sheet is also created. Insert the information.

  In this way, the form creation device of the present invention displays the form created by pasting the form composed of the list of the number of data having the item values in association with the item values on the sheet created by the table creation software. At the same time, the form layout information is inserted into the sheet.

  Upon receiving this form display, the user makes a processing request by designating a certain number of data on the form displayed on the sheet. When this processing request is issued, the form creation device of the present invention According to the layout information inserted in the sheet, the item value associated with the specified number of data is specified, for example, by requesting the data storage mechanism to search for data having the specified item value. Acquire data by displaying the data and displaying it on the sheet, setting the classification method for the data with the specified item value, and requesting the data storage mechanism to search for the data Then, the acquired data is classified according to the classification method, and the classification result is displayed on the sheet.

  Thus, in the form creation device of the present invention, when displaying a form on a sheet by pasting a form composed of a list of the number of data to the sheet created by the table creation software, By inserting the information of the layout of the form, when any number of data to be displayed on the form is selected as a processing request, what item value the data number has been searched for It is configured so that it can be identified.

  In accordance with this configuration, the form creation device of the present invention can search for data constituting the number of data selected as the processing request, thereby configuring the number of data selected as the processing request. The detailed contents of the data can be displayed, and the data constituting the number of data selected as the processing request can be further classified and displayed.

  The form creation apparatus of the present invention uses a table creation software, and such a table creation software has a function that allows the user to freely edit the layout of the form pasted on the sheet.

  However, if the layout editing of the form by such a table creation software is permitted, the layout information inserted in the sheet cannot be matched, and any number of data to be displayed on the form is selected as a processing request. In this case, it becomes impossible to specify what item value the data number has been searched for.

  Therefore, in the form creation device of the present invention, when there is a request to edit the layout of the form on the sheet created by the table creation software, the layout information to be edited is selected, the design means is activated, and the activated design is started. The selected layout information is edited by designing the layout of the form while clearly indicating what the item values defined by the selected layout information are.

  When editing layout information in this way, a form that is different from the form created by the layout information that was the editing source will be created, so the newly created form can be overwritten and saved. The newly created form is stored in a form that also leaves the form created based on the layout information as the editing source.

  The form creation apparatus of the present invention uses table creation software. Such a table creation software has the same layout as the form displayed on the current sheet, but has a different search period. You cannot create a form.

  Therefore, in the form creation device of the present invention, in order to realize this, when there is a use request for the created form, the layout information about the form to be used is obtained, and according to the obtained layout information, A search period with the same layout as the created form is different by specifying a search period different from the search period specified when creating the form to be used and requesting the data storage mechanism to perform a search. It is trying to realize the form which becomes.

[2] Form Display Device of the Present Invention The form display device of the present invention performs processing for displaying the form created by the form creation device of the present invention, and (a) created by the form creation device of the present invention. (B) display means for displaying the form obtained by controlling the form obtained by the obtaining means with the table creation software; and (c) certain data on the form displayed by the display means. When there is a processing request with the number specified, the form creation device of the present invention specifies the item value associated with the number of data according to the layout information inserted in the form, and executes a predetermined process according to that And an execution means for taking the configuration.

  Each of the above processing means can also be realized by a computer program. This computer program is provided by being recorded on an appropriate computer-readable recording medium or provided via a network, and is used when implementing the present invention. The present invention is realized by being installed and operating on a control means such as a CPU.

  In the form display device of the present invention configured as described above, when a form created by the form creation apparatus of the present invention is obtained from a database or the like, the obtained form is controlled by the table creation software. indicate.

  Upon receiving this form display, the user makes a processing request by designating a certain number of data on the form displayed on the sheet. When this processing request is issued, the form display device of the present invention According to the layout information inserted into the form by the form creation device of the invention, the item value associated with the designated number of data is specified, and for example, data having the specified item value for the data storage mechanism The data is acquired by requesting the search and displayed on the sheet, and the classification method for the data having the specified item value is set, and the data storage mechanism is requested to search for the data. Then, the data is acquired, the acquired data is classified according to the classification method, and the classification result is displayed on the sheet.

  Thus, in the form display apparatus of the present invention, when obtaining and displaying the form created by the form creation apparatus of the present invention, according to the layout information inserted into the form by the form creation apparatus of the present invention, When any number of data to be displayed on the form is selected as a processing request, the configuration is such that it is possible to specify what item value the data number has been searched for.

  In accordance with this configuration, the form display apparatus of the present invention can search for data constituting the number of data selected as the processing request, thereby configuring the number of data selected as the processing request. The detailed contents of the data can be displayed, and the data constituting the number of data selected as the processing request can be further classified and displayed.

  In the present invention, when a form composed of a list of data numbers is pasted on a sheet created by the table creation software to display the form on the sheet, the layout information of the form is inserted into the sheet. Therefore, when any number of data to be displayed on the form is selected as a processing request, it is possible to specify what item value the data number has been searched for. .

  In accordance with this configuration, according to the present invention, when a form composed of a list of the number of data is displayed using the table creation software, data constituting the number of data selected as the processing request can be searched. Therefore, it is possible to display the detailed contents of the data constituting the number of data selected as the processing request, or display the data constituting the number of data selected as the processing request in more detail. become able to.

  Thus, according to the present invention, when creating a form while using widely used table creation software, it is possible to provide information that could not be provided by using the conventional table creation software. As a result, information required by the user can be provided to the user.

  In addition, according to the present invention, it is possible to create a form that has the same layout as the created form and has a different search period using the created form.

  Hereinafter, the present invention will be described in detail according to an embodiment applied to a hospital medical management system.

  FIG. 1 illustrates a system configuration of a medical management system including the present invention.

  As shown in this figure, in the medical management system comprising the present invention, a client 1 operated by an operator who performs medical management work and a server 2 that provides patient information to the client 1 are connected via a network. It is constituted by being done.

  The client 1 performs a process of creating a form of patient information using Excel and displaying it on a display. In order to perform this process, a book (hereinafter referred to as a form 100) referred to Excel is used. ), An add-in form design unit 11 prepared as having an add-in function for Excel, an add-in drill-down menu display unit 12 prepared as having an add-in function for Excel, and an add-in function for Excel A breakdown display unit 13 prepared as having, a detailed classification unit 14 prepared as having an add-in function for Excel, an add-in form design function calling unit 15 prepared as having an add-in function for Excel, and a fixed form And a form creation unit 16.

  On the other hand, the server 2 includes a database 20 that manages information about patients, a data search unit 21 that acquires and provides patient information requested by the client 1 by searching the database 20, and an add-in form design unit 11 and the like. A metadata management unit 22 that manages various types of created / set information as metadata and provides them to the client 1, a form 100 (created by the client 1 shown in the figure or other clients not shown), and a form design. And a shared folder 23 that manages necessary information such as image information and information about the server name and provides the information to the client 1.

  Next, each processing unit included in the client 1 will be described.

  When the form 100 realizes the present invention, the sheet 110 to be excel to which the form 100 is pasted, the form information 120 inserted into the sheet 110, the layout definition 130 inserted into the sheet 110, The layout definition data 140 is inserted into the sheet 110.

  The add-in form design unit 11 designs a form for information on the number of patients and the number of medical treatment points, requests the data search unit 21 to search according to the design, and obtains data to be described in the form, and pastes it on the sheet 110. Create form data. Then, the form 100 is created by pasting the created form data on the sheet 110, information about the created form 100 is inserted as form information 120, and the designed design information is inserted as the layout definition 130. The created form data is inserted as layout definition data 140.

  The add-in drill-down menu display unit 12 displays the add-in drill-down menu on the sheet 110 when an instruction to display the add-in drill-down menu is issued in accordance with an operator operation on the form 100 pasted on the sheet 110.

  When a breakdown display request is issued according to an operator operation on the add-in drill-down menu displayed by the add-in drill-down menu display unit 12, the breakdown display unit 13 determines a search condition by referring to the form information 120 and the layout definition 130, By designating the search condition and requesting the search to the data search unit 21, data to be displayed for breakdown is acquired, and the acquired data is displayed as a new form.

  When a detailed classification request is issued in accordance with an operator operation on the add-in drill-down menu displayed by the add-in drill-down menu display unit 12, the detailed classification unit 14 determines a detailed classification method, and further refers to the form information 120 and the layout definition 130. The search condition is determined, the search condition is specified, the search is requested to the data search unit 21 to acquire the data subject to the detailed classification, and the acquired detailed classification is determined for the acquired data. According to the method, the classification result is displayed as a new form.

  The add-in form design function calling unit 15 edits the form design by calling the add-in form design unit 11 when an edit request for the form design is issued in accordance with an operator operation on the add-in down menu displayed by the add-in down menu display unit 12. .

  The fixed form creation unit 16 acquires a list of the forms 100 created so far by the add-in form design unit 11 according to the metadata provided by the metadata management unit 22, and the operator is targeted for use from the form list. When the form 100 is selected, the form 100 is read from the shared folder 23 and written in the memory 10 to operate on Excel, and the form information 120 and the layout definition 130 possessed by the form 100 are acquired, and the form is read accordingly. While specifying a search period that is different from the search period specified when creating the form 100, the search condition specified when creating the read form 100 is specified and the data search unit 21 is requested to search. This creates a new form requested by the operator (having the same layout as the read form) and creates a new form A simple form 100 is displayed by writing it into the memory 10.

  FIG. 2 shows an example of the processing flow executed by the add-in form design unit 11. FIGS. 3 and 4 show the add-in drill-down menu display unit 12 / breakdown display unit 13 / detail classification unit 14 / add-in form design function calling unit. 15 shows an example of the processing flow executed, and FIG. 5 shows an example of the processing flow executed by the fixed form creation unit 16.

  Next, processing executed by the client 1 configured as described above will be described in detail according to these processing flows.

  First, processing executed by the add-in form design unit 11 will be described.

  When a new form creation request is issued, the add-in form design unit 11 first determines the form type of the creation request form by interacting with the operator in step S10, as shown in the processing flow of FIG. In the subsequent step S11, the dates to be counted are input by interacting with the operator.

  For example, a form type selection screen as shown on the left side of FIG. 6 is displayed and dialogue with the operator is selected. For example, a user selects to create a monthly form, and then inputs a date as shown on the right side of FIG. By displaying the screen and interacting with the operator, an aggregation date such as December is input.

  Subsequently, in step S12, the type of the table is selected by interacting with the operator, and in step S13, the tabulation purpose is selected by interacting with the operator.

  For example, by selecting a table type selection screen as shown on the left side of FIG. 7 and interacting with the operator, for example, selecting to create a tabulation table, the tabulation purpose as shown on the right side of FIG. For example, the totaling purpose of examining the number of outpatients is selected by displaying the above selection screen and interacting with the operator.

  Subsequently, in step S14, the vertical axis classification item of the form created by interacting with the operator is selected, and in step S15, the horizontal axis classification item of the form created by interacting with the operator is selected.

  For example, the vertical axis classification item selection screen as shown on the left side of FIG. 8 is displayed and the operator interacts with the operator to select the vertical axis classification item of the form, for example, a department name, and then the right side of FIG. By displaying such a horizontal axis classification item selection screen and interacting with the operator, for example, the horizontal axis classification item of the form called gender name is selected.

  Here, on the selection screen for the vertical axis classification item and the selection screen for the horizontal axis classification item, it is possible to set to obtain the total, maximum value, minimum value, and the like. Also, the form creation image is displayed using the preview screen.

  In addition, the hospital side can set in advance what kind of items the selected vertical axis classification item and horizontal axis classification item are configured. In the example described below, it is assumed that the department names “internal medicine / pediatrics / surgery / shaping / ophthalmology / otolaryngology / radiology / urology / respiratory surgery” are set in this order. Further, it is assumed that “male / female” is set in this order as the gender name. On the preview screen, displaying such a large number of department names becomes cumbersome, so what is prepared on the system side is displayed.

  Subsequently, in step S16, a total item is selected by interacting with the operator, and in step S17, a condition is selected by interacting with the operator.

  For example, by displaying a total item selection screen as shown on the left side of FIG. 9 and interacting with the operator, for example, after selecting a total item called the total number, a condition selection screen as shown on the right side of FIG. By displaying the above and interacting with the operator, conditions regarding the age and date of birth of the patient are selected. In the example of this figure, it is assumed that no condition is selected on the condition selection screen.

  Subsequently, in step S18, an output method is selected by interacting with the operator. For example, by displaying an output method selection screen as shown on the left side of FIG. 10 and interacting with the operator, for example, an output method of outputting to a worksheet (sheet 110) without dividing the result is selected. .

  Here, when the operator operates the “next button” on this selection screen, the process proceeds to step S18. The add-in form design unit 11 sets the “next button” before proceeding to the process. In response to the operation, the search condition determined by the layout definition set by the processing so far is specified, and the data search unit 21 is requested to search, thereby acquiring information on the number of patients as form data. Process.

  In this example, for the data search unit 21, patients by gender who visited the department of “Internal Medicine / Pediatrics / Surgery / Shaping / Ophthalmology / Otolaryngology / Radiation / Urology / Respiratory Surgery” in December. A process of requesting a number of searches and receiving the form data of the search results is performed.

  Subsequently, in step S19, a part of the form data obtained by the search is selected as a pasting source by interacting with the operator. For example, by displaying a pasting source selection screen as shown on the right side of FIG. 10 and interacting with the operator, for example, it is selected that all form data is to be pasted.

  Subsequently, in step S20, the paste destination on the sheet 110 is selected by interacting with the operator, and in the subsequent step S21, the form data selected in step S19 is pasted to the selected paste destination.

  For example, as shown on the left side of FIG. 11, the sheet position “A1” on the sheet 110 is selected as the pasting destination in accordance with the operator's selection instruction, and then the selected pasting is performed as shown on the right side of FIG. First, the form data selected in step S19 (in this example, all form data) is pasted.

  Subsequently, in step S22, the layout definition set by the processing so far is given a name, and the form data is inserted into the pasted sheet 110 and saved.

  For example, by displaying a layout definition saving screen as shown on the left side of FIG. 12 and interacting with the operator, a name such as “layout definition 1” is given to the sheet 110 on which the form data is pasted. By inserting, the layout definition set by the processing so far is saved.

  Subsequently, in step S23, the form created by the processing so far is given a name, and information about the form is stored by being inserted into the sheet 110 on which the form data is pasted.

  For example, by displaying a form name input screen as shown on the right side of FIG. 12 and interacting with the operator, a name such as “the number of outpatients by gender by department” is given, and the processing so far Information about the created form is saved by inserting it into the sheet 110 to which the form data is pasted.

  Finally, in step S24, the form data pasted on the sheet 110 is inserted into the sheet 110 to be saved as layout definition data, and the process is terminated.

  In this way, the add-in form design unit 11 designs the form for the information on the number of patients by executing the processing flow of FIG. 2, and requests the data search unit 21 to perform the search according to the design and enter the form in the form. The form data to be pasted on the sheet 110 is created by obtaining the data to be created, and the form 100 is created by pasting the created form data on the sheet 110, and information about the created form 100 is created as the form. Information 120 is inserted into the sheet 110, the design information is inserted into the sheet 110 as the layout definition 130, and the created form data is processed into the sheet 110 as the layout definition data 140.

  In accordance with this process, as shown on the left side of FIG. 13, the Excel sheet 110 is displayed in December for each hospital department of “Internal Medicine / Pediatrics / Surgery / Orthopedics / Ophthalmology / Otolaryngology / Radiation / Urology / Respiratory Surgery” The form 100 describing the number of patients by gender who visited the hospital will be displayed.

  When there is a display request for “layout definition 1” inserted in the sheet 110, the contents of “layout definition 1” are displayed as shown on the right side of FIG.

  The form 100 created in this way is stored in the shared folder 23 of the server 2 and used when creating the form executed by the standard form creation unit 16.

  Here, in the form 100 shown on the left side of FIG. 13, data relating to the rate is added, which is created by the operator using the calculation function of Excel. That is, the form data retrieved from the database 20 is as shown in FIG. 14, and this form data is pasted on the sheet 110, whereas the form 100 shown on the left side of FIG. This is created by the operator using the calculation function of Excel.

  FIG. 15 illustrates an example of the form information 120 inserted into the sheet 110 by executing the processing flow of FIG. 2, and FIGS. 16 and 17 illustrate insertion of the form information 120 into the sheet 110 by executing the processing flow of FIG. An example of the defined layout definition 130 is illustrated.

  In the form information 120 inserted in the sheet 110, as shown in FIG. 15, the form name, form ID, form type, date type, date (the search period), medical institution code, creation date, etc. are recorded. Yes.

  On the other hand, in the layout definition 130 inserted in the sheet 110, as shown in FIG. 16, according to the format of the XML document, the item name of the vertical axis classification item is recorded in the A part in the figure, and in the B part in the figure Record that the total column of the vertical axis classification items is displayed last, record that the item names of the vertical axis classification items are displayed in ascending order of the item codes in the part C in the figure, and in the part D in the figure Record the item name of the horizontal axis classification item, record that the total column of the horizontal axis classification item is displayed at the end of E in the figure, and record the item name of the horizontal axis classification item in the F part of the figure Record that item codes are displayed in ascending order, record the total number of items for each item in the G part of the figure, record that the total is displayed in the total field in the H part of the figure, By recording where the paste destination is in the I part, the layer of the form 100 It has saved the door information.

  Next, processing executed by the add-in deep menu display unit 12 / breakdown display unit 13 / detail classification unit 14 / add-in form design function call unit 15 will be described.

  The add-in drill-down menu display unit 12 / breakdown display unit 13 / detail classification unit 14 / add-in form design function calling unit 15 is described in the cell when the operator double-clicks the cell of the form 100 displayed on the sheet 110. When a drilling request for the number of data to be issued is issued, as shown in the processing flow of FIGS. 3 and 4, first, in step S30, on the sheet 110 as shown on the left side of FIG. Displays the add-in drill-down menu.

  In this add-in drill-down menu, a menu item “display breakdown details” for starting the breakdown display unit 13 for executing the breakdown display process and “further classification for starting the detailed classification unit 14 for executing the detailed classification process” are shown. And a menu item “edit definition” for activating the add-in form design function calling unit 15.

  Subsequently, in step S31, an operator operation for the add-in drill-down menu is awaited, and when an operator operation is detected, the process proceeds to step S32, where the operator selects a menu item “display breakdown details” to display the breakdown display process. It is determined whether or not it has been requested.

  When it is determined according to this determination processing that the operator has requested the breakdown display processing for the number of data described in the cell double-clicked, the process proceeds to step S33, and the breakdown display processing is performed according to the layout definition 130 inserted in the sheet 110. Identifies the item value of the requested cell.

  That is, as described in FIG. 16, the layout definition 130 indicates what the vertical axis classification item is and what the horizontal axis classification item is. In addition, for example, when a department name is set as a vertical axis classification item, the list of item values is “Internal Medicine / Pediatrics / Surgery / Shaping / Ophthalmology / Otolaryngology / Radiation / Urology / Respiration”. “Surgery” is known, and when the gender name is set as the horizontal axis classification item, the item value list is “male / female” Therefore, the item value of the cell having the breakdown display processing request is specified in accordance with these pieces of information.

  Subsequently, in step S34, a search condition is determined according to the specified item value and the search period specified from the form information 120 inserted in the sheet 110, and this time the data search unit 21 is searched for the number of data. Rather than requesting it, requesting a search for patient data having that search condition obtains data with a breakdown display processing request.

  That is, since the search period used to create the form 100 is described in the form information 120 inserted in the sheet 110, the search condition is determined according to the search period and the item value specified in step S33, and the data search is performed. By requesting the unit 21 to search for patient data having the search condition, data for which a breakdown display processing request is made is acquired.

  Subsequently, after the acquired data is displayed on the sheet 110 in step S35, the process returns to step S31 to wait for the next operator operation.

  Thus, for example, when a breakdown display processing request is made by double-clicking a cell having an item value of “ophthalmology” / “female”, as shown on the right side of FIG. Detailed information of two patients with item values is displayed.

  On the other hand, when it is determined that the operator has not selected the menu item “display breakdown details” according to the determination process in step S32, the process proceeds to step S36, where the operator selects the menu item “further classification and aggregation”. Is selected, it is determined whether or not the detailed classification process is requested.

  When it is determined according to this determination processing that the operator has requested a detailed classification process for the number of data described in the double-clicked cell, the process proceeds to step S37 and a classification method for the detailed classification is selected.

  That is, when the add-in drill-down menu as shown on the left side of FIG. 19 is displayed, the operator selects the menu item “further classification and aggregation”, so that the number of data described in the double-clicked cell is When the detailed classification process is requested, a grouping selection screen as shown on the right side of FIG. 19 is displayed, and a selection instruction for the classification method displayed on the selection screen is received. A classification method is selected.

  Subsequently, in step S38, the item value of the cell having the detailed classification processing request is specified according to the layout definition 130 inserted in the sheet 110. As described above, according to the layout definition 130 inserted in the sheet 110, the item value of the cell double-clicked by the operator can be specified. It is specified.

  Subsequently, in step S39, the search condition is determined according to the specified item value and the search period specified from the form information 120 inserted into the sheet 110, and this time the data search unit 21 is searched for the number of data. Rather than requesting it, requesting a search for patient data having that search condition obtains data with a detailed classification processing request.

  That is, since the search information used to create the form 100 is described in the form information 120 inserted in the sheet 110, the search condition is determined according to the search period and the item value specified in step S38, and the data search is performed. By requesting the unit 21 to search for patient data having the search conditions, data with a detailed classification processing request is acquired.

  Subsequently, in step S40, the acquired data is classified according to the selected classification method, the classification result is displayed on the sheet 110, and then the process returns to step S31 to wait for the next operator operation.

  In this way, for example, when a cell having an item value of “otolaryngology” / “female” is double-clicked, there is a detailed classification processing request, and at that time, a classification method of classifying by age group is selected. Then, as shown in FIG. 20, information on the age groups of 40 patients having the item values is displayed on the sheet 110.

  On the other hand, when it is determined that the operator has not selected the menu item “further classification and aggregation” according to the determination process of step S36, the process proceeds to step S41, and the operator selects the menu item “edit definition”. Is selected, it is determined whether editing of the layout definition 130 is requested.

  When it is determined that the operator has requested editing of the layout definition 130 according to this determination processing, the process proceeds to step S42, and the add-in form design unit 11 has created so far according to the metadata provided by the metadata management unit 22. A list of layout definitions 130 is acquired and displayed, and a selection instruction for the list display is received to select a layout definition 130 to be edited.

  That is, when the add-in drill down menu as shown on the left side of FIG. 21 is displayed, it is determined that the operator has requested editing of the layout definition 130 by selecting the menu item “edit definition”. The layout definition 130 created so far as shown in the right side of FIG. 21 is displayed, and a selection instruction for the layout definition 130 displayed on the list screen is received, so that the layout definition 130 to be edited is displayed. Make a choice.

  Subsequently, in step S43, the selected layout definition 130 is designated and the add-in form design unit 11 is activated, and then the process ends.

  When started in this way, the add-in form design unit 11 edits the layout definition 130 by executing the process of FIG. 2 starting from the process of step S12 of the process flow of FIG. Thus, the form 100 is created.

  At this time, the add-in form design unit 11 knows what the layout definition 130 to be edited is, so when the selection instruction is given to the operator using the screen, The selection process is performed while clearly indicating whether such a layout is selected in the layout definition 130 to be edited.

  In addition, since the layout definition 130 is edited in this way, a form 100 different from the form 100 created by the layout definition 130 that is the editing source is created, so that a response from a selection from the operator is made. Then, the newly created form 100 is saved in an overwritten form, or the newly created form 100 is saved in such a form that the form 100 created by the layout definition 130 as the editing source is also retained. It will be.

  On the other hand, when it is determined that the operator has not selected the menu item “edit definition” according to the determination process in step S41, the process proceeds to step S44 to determine whether or not the operator has requested the end of the process. If it is determined that the operator has requested the end of the process, the process ends.

  When it is determined in accordance with the determination process in step S44 that the operator has requested a process other than the end of the process, the process proceeds to step S45 to execute the process requested by the operator and wait for the next operator operation. The process returns to step S31.

  In this way, the add-in drill-down menu display unit 12 / breakdown display unit 13 / detail classification unit 14 / add-in form design function call unit 15 are characteristic of the present invention by executing the processing flow of FIGS. A breakdown display process as shown in FIG. 18 which is a simple process, a detailed classification process as shown in FIGS. 19 and 20 which is a characteristic process of the present invention, and a form displayed by Excel The layout definition 130 editing process, which is a characteristic process of the present invention, is executed without using Excel.

  Next, processing executed by the fixed form creation unit 16 will be described.

  When a request for creating a standard form is issued, the standard form creation unit 16 first adds an add-in form according to the metadata provided by the metadata management unit 22 in step S50 as shown in the processing flow of FIG. The design unit 11 acquires a list of the forms 100 created so far, displays the list, receives a selection instruction for the list display, and selects the form 100 to be used in creating the standard form.

  For example, by displaying a list screen of the form 100 created so far as shown on the left side of FIG. 22 and receiving a selection instruction for the form 100 displayed on the list screen, the form 100 used for creating the standard form 100 Is selected.

  Subsequently, in step S51, the selected form 100 is read from the shared folder 23 of the server 2 and written into the memory 10 to be operated on Excel.

  Subsequently, in step S52, the form type is specified according to the form information 120 of the selected form 100, the input screen for the totaling date corresponding to the form type is displayed, and the input for that is received, thereby creating the selected form 100 The aggregation date is determined to be a search period different from the search period specified at the time.

  For example, when specifying that the form type is a monthly form according to the form information 120 of the selected form 100, by displaying a date input screen as shown on the right side of FIG. 22 and interacting with the operator, For example, a total date such as November is input.

  Subsequently, in step S53, the item value of the selected form 100 is specified according to the layout definition 130 of the selected form 100.

  That is, as described in FIG. 16, the layout definition 130 indicates what the vertical axis classification item is and what the horizontal axis classification item is. In addition, for example, when a department name is set as a vertical axis classification item, the list of item values is “Internal Medicine / Pediatrics / Surgery / Shaping / Ophthalmology / Otolaryngology / Radiation / Urology / Respiration”. “Surgery” is known, and when the gender name is set as the horizontal axis classification item, the item value list is “male / female” Therefore, the item value of the selected form 100 is specified according to these pieces of information.

  Subsequently, in step S54, the search condition is determined according to the specified item value and the search period defined by the determined aggregation date, and the data search unit 21 is requested to search for the number of patients having the search condition. Thus, the form data having a search period different from the form data of the form 100 read from the shared folder 23 of the server 2 is acquired.

  Subsequently, in step S55, a new form 100 is created by updating the form 100 read from the shared folder 23 operated on Excel based on the acquired form data, and the process is terminated.

  In this way, the fixed form creation unit 16 uses the form 100 created by the add-in form design unit 11 to create a new form 100 very easily without performing layout creation processing. It will be realized.

  In the client 1 shown in FIG. 1, when a form 100 is created, it is stored in the server 2.

  From this point, another client, which is not shown in FIG. 1, may obtain the form 100 from the server 2 and display it.

  In this case, when the client 100 (not shown) is displaying the form 100 obtained from the server 2, the operator double-clicks the cell of the form 100 displayed on the sheet 110 and is described in the cell. When a digging-down processing request for the number of data is issued, the processing described in steps S33 to S35 of the processing flow in FIGS. 3 and 4 is executed, or steps S37 to S37 in the processing flow in FIGS. Processing is performed so as to execute the processing described in step S40.

  As described above, according to the present invention, when creating a form while using a widely used table creation software such as Excel, information that cannot be provided by using the conventional table creation software. Therefore, it is possible to provide the information required by the user to the user.

1 is a system configuration diagram of a medical management system including the present invention. It is an example of the processing flow which a client performs. It is an example of the processing flow which a client performs. It is an example of the processing flow which a client performs. It is an example of the processing flow which a client performs. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is a figure which shows an example of the form data searched from the database. It is a figure which shows an example of form information. It is a figure which shows an example of a layout definition. It is a figure which shows an example of a layout definition. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays. It is explanatory drawing of the screen which a client displays.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Client 2 Server 10 Memory 11 Add-in form design part 12 Add-in deepening menu display part 13 Breakdown display part 14 Detailed classification part 15 Add-in form design function calling part 16 Standard form creation part 20 Database 21 Data search part 22 Metadata management part 23 Sharing Folder 100 Form 110 Sheet 120 Form information 130 Layout definition 140 Layout definition data

Claims (8)

A form creation device for creating a form,
A means to design the layout of the form by setting the item value of the form,
Means for requesting the data storage mechanism to search for the number of data having the set item value to obtain the number of data, and creating form data according to the layout;
Means for pasting the form data on a sheet created by the table creation software, and inserting the layout information into the sheet;
When there is a processing request specifying a certain number of data on the pasted form displayed on the sheet by the table creation software, an item associated with the number of data according to the layout information inserted in the sheet Means for specifying a value and executing a predetermined process corresponding to the value,
A form creation device. In the form creation device according to claim 1,
The means for executing obtains the data by requesting the data storage mechanism to search for data having the specified item value, and displays the data on the sheet.
A form creation device. In the form creation device according to claim 1,
The means for executing sets the classification method for the data having the specified item value, and obtains the data by requesting the data storage mechanism to search for the data. Classifying the acquired data according to the classification method, and displaying the classification result on the above sheet,
A form creation device. In the form creation device according to any one of claims 1 to 3,
When there is an edit request for the layout of the form on the sheet, the layout information to be edited is selected, and means for starting the design means is provided.
The design means, when activated by the activation means, selects the layout by designing the layout of the form while clearly indicating what the item values defined by the selected layout information are. To edit the layout information
A form creation device. In the form creation device according to any one of claims 1 to 3,
Means for acquiring the layout information about a form to be used when there is a use request for the created form;
Create a new form by requesting a search to the data storage mechanism by specifying a search period that is different from the search period specified when creating the form to be used according to the acquired layout information. Providing means for
A form creation device. Design the layout of the form by setting the item values of the form, request the data storage mechanism to search for the number of data with the set item value, and acquire the data number Create the form data that creates the form data by pasting the created form data into the sheet created by the table creation software and inserting the layout information into the sheet. A form display device for displaying a form created by a device,
Means for obtaining a form created by the form creation apparatus;
Means for displaying the form by controlling the obtained form with the table creation software;
When there is a processing request by designating a certain number of data on the displayed form, an item value associated with the number of data is specified according to the layout information inserted in the form by the form creation device, and Means for executing a predetermined process according to
Feature form display device. A form creation method executed by a form creation apparatus for creating a form,
Design the layout of the form by setting the item value of the form,
By requesting the data storage mechanism to retrieve the number of data having the set item value, obtain the number of data, create form data according to the layout,
Paste the form data into a sheet created by the table creation software, and insert the layout information into the sheet.
When there is a processing request specifying a certain number of data on the pasted form displayed on the sheet by the table creation software, an item associated with the number of data according to the layout information inserted in the sheet To specify a value and execute a predetermined process accordingly,
Characteristic form creation method. A form creation program used to realize a form creation apparatus for creating a form,
Computer
A means to design the layout of the form by setting the item value of the form,
Means for requesting the data storage mechanism to search for the number of data having the set item value to obtain the number of data, and creating form data according to the layout;
Means for pasting the form data on a sheet created by the table creation software, and inserting the layout information into the sheet;
When there is a processing request specifying a certain number of data on the pasted form displayed on the sheet by the table creation software, an item associated with the number of data according to the layout information inserted in the sheet A form creation program for specifying a value and causing it to function as a means for executing a predetermined process corresponding to the value.

Images