Project management system and program for project management system

Abstract

To provide a project management system for enabling a manager to easily retrieve, totalize and analyze the work information of each user related with a project.SOLUTION: The project management system 100 includes the plurality of user terminals 110 and the servers (120 and 130), the user terminal 110 communicates with the server (120), the browser 111 of the user terminal 110 displays the schedule screen 112 of the user, and when the task information SJ is input and a storage operation is performed on the schedule screen 112, the user identification information UJ and the input task information SJ are transmitted from the user terminal 110 to the server (120). A server (130) collects user identification information UJ and work information SJ from each user terminal 110 in the server (120) and stores them in a predetermined work information input sheet of file data EX in a predetermined cell display format.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a project management system that includes a plurality of user terminals and a server, and that compiles user work information related to a project input from a browser on the user terminal, and a program therefor. [Background technology]

[0002] BACKGROUND ART Conventionally, a business system is known that includes a user terminal and a server, and a browser displayed on the user terminal displays an organization schedule management screen as a predetermined business screen based on a database of the server (for example, Patent Document 1). [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Publication No. 2024-51182 Summary of the Invention [Problem to be solved by the invention]

[0004] However, in the conventional business system described above, the organizational schedule management screen of the browser on the user terminal was only configured to display facial photo data of each of multiple user members pre-registered in the database, today's attendance time-stamping information of each user member recorded in the database, and current attendance status information of each user member recorded in the database.However, since there was no information about the work content or the relationship between that work and the project name, there was a problem in that it was difficult for the administrator to easily search, compile, and analyze each user's work information related to the project.

[0005] Therefore, the present invention solves the problems of the prior art as described above. In other words, the object of the present invention is to provide a project management system and a program therefor that allow an administrator to easily search, compile, and analyze each user's work information related to a project. [Means for solving the problem]

[0006] The invention of claim 1 is a project management system that includes multiple user terminals and a server and compiles user work information related to a project that is input from the browser of the user terminal, wherein the user terminal communicates with the server, the browser of the user terminal displays the user's schedule screen, and when work information is input on the schedule screen and a save operation is performed, the user identification information and the input work information are sent from the user terminal to the server, and the server collects the user identification information and work information from each user terminal and saves it in a specified work information input sheet of file data in a specified cell display format, thereby solving the above-mentioned problem.

[0007] The invention of claim 2 solves the above-mentioned problem by being configured such that, in addition to the configuration of the project management system described in claim 1, when a predetermined time has elapsed or when a predetermined data collection operation is performed by the administrator, the server collects user identification information and work information stored on the server for multiple pre-registered user members and stores it in a predetermined work information input sheet of file data in a predetermined cell display format.

[0008] The invention of claim 3 further solves the above-mentioned problem by configuring the project management system as recited in claim 2, in addition to the configuration of the file data in the predetermined cell display format to have a project list sheet, and project name information and project phase name information are set and input on the project list sheet, and when work information is input on the schedule screen displayed on the browser of the user terminal, the browser displays the project name information and project phase name information in a selectable and freely inputtable manner based on the project name information and project phase name information set in advance on the project list sheet of the file data in the predetermined cell display format via the server.

[0009] The invention of claim 4 further solves the above-mentioned problem by having the configuration of a project management system as recited in claim 3, in addition to the configuration of the project management system as recited in claim 3, wherein when work information is input on the schedule screen, if any date and time location on the schedule screen is selected and operated, the browser displays a first input screen having a title input field, a detailed description input field, and a project details button, and when the project details button is operated, the browser displays a second input screen having a project name input field, a phase input field, and a work information input field, and in the project name input field, project name information is displayed so as to be freely selectable and input based on project name information previously set in a project list sheet of file data in a predetermined cell display format via the server, and in the phase input field, phase name information is displayed so as to be freely selectable and input based on phase name information previously set in a project list sheet of file data in a predetermined cell display format via the server.

[0010] The invention of claim 5 further solves the above-mentioned problem by being configured such that, in addition to the configuration of the project management system described in claim 4, when project name information, phase name information and work information are entered in the project name input field, phase input field and work information input field on the second input screen and a save operation is performed, the browser inputs the project name information, phase name information and work information into the detailed description input field on the first input screen based on the project name information, phase name information and work information entered on the second input screen.

[0011] The invention of claim 6 further solves the above-mentioned problem by being configured such that, in addition to the configuration of the project management system as recited in claim 5, when a selective input operation of project name information and phase name information is performed on the second input screen, the browser determines whether or not there is input in the title input field of the first input screen, and if it determines that there is no input in the title input field, the browser inputs the project name information and phase name information in the title input field of the first input screen based on the project name information and phase name information selectively input on the second input screen, and if it determines that there is input in the title input field, the browser leaves the project name information and phase name information selectively input on the second input screen as is without reflecting it in the title input field of the first input screen.

[0012] The invention of claim 7 further solves the above-mentioned problem by configuring a project management system as defined in any one of claims 1 to 6, in which the file data in the predetermined cell display format has a user list sheet, and user identification information and address information related to the user's schedule screen are set and input on the user list sheet, and the server collects work information saved and registered in the address information destination based on the address information related to the user's schedule screen that is preset in the user list sheet of the file data in the predetermined cell display format, from the address information destination, and saves it in a predetermined work information input sheet of the file data in the predetermined cell display format.

[0013] The invention of claim 8 further solves the above-mentioned problem by having a configuration in addition to the project management system configuration of claim 7, in which the specified work information input sheet of the file data in the specified cell display format is displayed in a browser of an administrator terminal that can communicate with the server, the server issues URL information corresponding to the specified work information input sheet of the file data in the specified cell display format based on a deploy operation by the administrator, and when the administrator terminal accesses the server based on the URL information, the browser of the administrator terminal displays a project management site related to the work information of the project based on a script that is preset in association with the specified work information input sheet of the file data in the specified cell display format and the file data in the specified cell display format.

[0014] The invention of claim 9 is a program for a project management system that compiles user work information related to a project input from a browser on a user terminal, and solves the above-mentioned problem by having a computer execute the following steps: a schedule screen display step in which the user terminal communicates with a server and the browser on the user terminal displays the user's schedule screen; a work information transmission step in which, when work information is input on the schedule screen and a save operation is performed, the user identification information and the input work information are transmitted from the user terminal to the server; and a collection and storage step in which the server collects the user identification information and work information from each user terminal and stores them in a specified work information input sheet in file data of a specified cell display format. [Effects of the Invention]

[0015] The project management system of the present invention is equipped with a plurality of user terminals and a server, which not only enables communication between the plurality of user terminals and the server, but also provides the following unique effects.

[0016] According to the project management system of the invention of claim 1, the work information entered on the schedule screen of the browser on each user's terminal is sent to the server and collected in a specified work information input sheet in a single file data with a specified cell display format, so that the manager can easily search, compile, and analyze each user's work information related to the project.

[0017] According to the project management system of the invention of claim 2, in addition to the effects of the invention of claim 1, work information for multiple pre-registered user members is collected all at once at predetermined time intervals or when a predetermined data collection operation is performed, and saved in a predetermined work information input sheet of file data in a predetermined cell display format, allowing the administrator to easily search, compile, and analyze the work information of each user related to the project.

[0018] According to the project management system of the invention of claim 3, in addition to the effects of the invention of claim 2, when each user inputs their own work information, the project name information and project phase name information are displayed freely and selectively based on the project name information and project phase name information pre-set in the project list sheet of the file data in a predetermined cell display format, so that each user can easily input at least a part of the work information. In other words, because project name information and project phase name information, which are at least part of the work information, can be freely selected and input, the burden on each user for input can be reduced and input errors can be avoided. Furthermore, because input errors are eliminated, the administrator can easily search for each user's work information and significantly improve the accuracy of the aggregation and analysis results.

[0019] According to the project management system of the invention of claim 4, in addition to the effects of the invention of claim 3, the user can freely select project name information and phase name information simply by selecting any date and time location on the schedule screen and pressing the case details button, so the user can easily select and input project name information and phase name information.

[0020] According to the project management system of the invention of claim 5, in addition to the effect achieved by the invention of claim 4, the information entered on the second input screen is reflected in the detailed description input field on the first input screen, so even in a configuration with two input screen displays, the first input screen and the second input screen, an increase in the input burden on the user can be avoided, making it easier to use.

[0021] According to the project management system of the invention of claim 6, in addition to the effects of the invention of claim 5, if the user does not enter a title on the first input screen, they can simply select and enter the project name information and phase name information on the second input screen, which will be reflected in the title input field on the first input screen, allowing them to set an easy-to-understand title and further allowing it to be displayed clearly on the schedule screen. On the other hand, if the user has entered a title on the first input screen, the entered title is respected and the selected input on the second input screen is not reflected in the title input field on the first input screen, so the title entered by the user on the first input screen can be prevented from being overwritten, and the title entered by the user on the first input screen can be clearly displayed on the schedule screen.

[0022] According to the project management system of the invention of claim 7, in addition to the effects of the invention of any one of claims 1 to 6, only work information related to registered users is collected and saved in a specified work information input sheet of file data in a specified cell display format, so that the administrator can easily search, compile, and analyze work information related only to registered users.

[0023] According to the project management system of the invention of claim 8, in addition to the effect of the invention of claim 7, the contents of a specified work information input sheet in file data with a specified cell display format are displayed on the project management site, so that the administrator can easily display the desired contents and search, tally, and analyze them.

[0024] According to the program for the project management system of the invention of claim 9, similar to the effect achieved by the invention of claim 1, the work information entered on the schedule screen of the browser on each user's user terminal is sent to the server and collected in a specified work information input sheet in a single file data of a specified cell display format, allowing the manager to easily search, compile, and analyze each user's work information related to the project. [Brief explanation of the drawings]

[0025] [Figure 1] 1 is a diagram showing the concept of a project management system according to an embodiment of the present invention; [Figure 2] 1 is a chart showing an example of the operation of a project management system according to an embodiment of the present invention; [Figure 3] 3A and 3B are diagrams showing examples of a schedule screen and a first simplified input screen of a browser on a user terminal of a project management system according to an embodiment of the present invention. [Figure 4] FIG. 2 is a diagram showing an example of a first input details screen of a browser on a user terminal of the project management system according to an embodiment of the present invention. [Figure 5] FIG. 10 is a diagram showing an example of a second input screen of a browser on a user terminal of the project management system according to an embodiment of the present invention. [Figure 6] 1 is a diagram showing an example of a project list sheet of file data in a predetermined cell display format in a project management system according to an embodiment of the present invention; [Figure 7] FIG. 10 is a diagram showing an example of a first input details screen after input into a second input screen of a browser on a user terminal of the project management system according to an embodiment of the present invention. [Figure 8] FIG. 10 is a diagram showing an example of a schedule screen after work information is saved on a browser of a user terminal in the project management system according to an embodiment of the present invention. [Figure 9] FIG. 2 is a diagram showing an example of a user list sheet of file data in a predetermined cell display format in the project management system according to an embodiment of the present invention. [Figure 10]10 is a diagram showing an example of a predetermined data collection operation on a project management screen of a browser on an administrator terminal of a project management system according to an embodiment of the present invention; [Figure 11] 1 is a diagram showing an example of a man-hour management sheet, which is a target sheet for inputting file data in a predetermined cell display format in a project management system according to an embodiment of the present invention; [Figure 12] FIG. 10 is a diagram showing an example of a display when a "Man-hours List" tab is selected on the project management screen of the browser of the manager terminal of the project management system according to the embodiment of the present invention. [Figure 13] FIG. 10 is a diagram showing an example of a display when a "summary by project" tab is selected on the project management screen of the browser of the manager terminal of the project management system according to the embodiment of the present invention. [Figure 14] FIG. 10 is a diagram showing an example of a display when a "User-specific summary" tab is selected on the project management screen of the browser of the manager terminal of the project management system according to the embodiment of the present invention. DETAILED DESCRIPTION OF THE INVENTION

[0026] The project management system of the present invention comprises a plurality of user terminals and a server, the user terminals communicate with the server, the browser of the user terminal displays the user's schedule screen, and when work information is entered on the schedule screen and a save operation is performed, the user identification information and the entered work information are sent from the user terminal to the server, and the server collects the user identification information and work information from each user terminal and stores it in a specified work information input sheet in file data with a specified cell display format, so that the specific implementation can be any one that allows the administrator to easily search, compile, and analyze each user's work information related to the project. Furthermore, the program for the project management system of the present invention can be implemented in any specific form as long as it causes a computer to execute the following steps: a schedule screen display step in which a user terminal communicates with a server and the browser of the user terminal displays the user's schedule screen; a work information transmission step in which, when work information is entered on the schedule screen and a save operation is performed, the user identification information and the entered work information are transmitted from the user terminal to the server; and a collection and storage step in which the server collects the user identification information and work information from each user terminal and stores it in a specified work information input sheet in file data with a specified cell display format, thereby allowing the administrator to easily search, aggregate, and analyze each user's work information related to a project.

[0027] For example, the user terminal may be a desktop personal computer terminal, a notebook personal computer terminal, a smartphone terminal, a tablet terminal, a wristwatch terminal, an eyeglass terminal, or any other terminal that displays data on a screen in a browser on the display unit of the user terminal and connects to a server via a communication network including a wide area network such as the Internet, a local network, or a telephone line to send and receive data. Furthermore, the server may be a cloud server created in a cloud environment, and the number of physical servers that make up the server may be one or more. Furthermore, in this case, a "cell display format file" is also called a spreadsheet file, and refers to a so-called matrix cell (mass) format in which the input cell is specified by the matrix number and symbol. A feature of "cell display format files" is that the width and height of the cells can be freely changed on a row-by-row basis. Furthermore, the layout of characters and numbers within a cell can be freely set for each cell. A "cell display format file" is not limited to a sheet, which is a collection of cells, but may also be a file containing multiple sheets. [Example]

[0028] A project management system 100 according to an embodiment of the present invention will be described below with reference to FIGS. 1 is a diagram showing the concept of a project management system 100 according to an embodiment of the present invention, FIG. 2 is a chart showing an example of the operation of the project management system 100 according to an embodiment of the present invention, FIG. 3 is a diagram showing examples of a schedule screen 112 and a first simplified input screen 113 on a browser 111 of a user terminal 110 of the project management system 100 according to an embodiment of the present invention, FIG. 4 is a diagram showing an example of a first detailed input screen 114 on a browser 111 of a user terminal 110 of the project management system 100 according to an embodiment of the present invention, FIG. 5 is a diagram showing an example of a second input screen 115 on a browser 111 of a user terminal 110 of the project management system 100 according to an embodiment of the present invention, FIG. 6 is a diagram showing an example of a project list sheet PS of file data EX in a predetermined cell display format of the project management system 100 according to an embodiment of the present invention, FIG. 7 is a diagram showing an example of a first detailed input screen 114 after input to the second input screen 115 on a browser 111 of a user terminal 110 of the project management system 100 according to an embodiment of the present invention, 9 is a diagram showing an example of a schedule screen 112 after work information SJ on the browser 111 of the user terminal 110 has been saved, FIG. 9 is a diagram showing an example of a user list sheet US of file data EX in a predetermined cell display format of the project management system 100 which is an embodiment of the present invention, FIG. 10 is a diagram showing an example of a predetermined data collection operation on the project management screen 142 of the browser 141 of the manager terminal 140 of the project management system 100 which is an embodiment of the present invention, FIG. 11 is a diagram showing an example of a man-hour management sheet KS which is an input target sheet for file data EX in a predetermined cell display format of the project management system 100 which is an embodiment of the present invention, FIG. 12 is a diagram showing an example of a display when a "man-hour list" tab 142b is selected on the project management screen 142 of the browser 141 of the manager terminal 140 of the project management system 100 which is an embodiment of the present invention, FIG. 13 is a diagram showing an example of a display when a "project-specific summary" tab 142c is selected on the project management screen 142 of the browser 141 of the manager terminal 140 of the project management system 100 which is an embodiment of the present invention,FIG. 10 is a diagram showing an example of a display when a "User-specific summary" tab 142d is selected on a project management screen 142 of a browser 141 of an administrator terminal 140 in a project management system 100 according to an embodiment of the present invention.

[0029] As shown in FIG. 1, a project management system 100 according to an embodiment of the present invention includes a plurality of user terminals 110, a first server 120, and a second server 130, which are examples of servers. Of these, the first server 120 is for calendars and schedules. On the other hand, the second server 130 is for project management. Although the first server 120 and the second server 130 are configured as separate entities, they may also be configured as an integrated entity. The project management system 100 is configured to tally up user work information SJ relating to the project input from the browser 111 of the user terminal 110.

[0030] Specifically, the user terminal 110 communicates with the first server 120 as a server, and the browser 111 of the user terminal 110 displays the schedule screen 112 of the user. Then, when task information SJ is input on schedule screen 112 and a save operation is performed, user identification information UJ and the input task information SJ are transmitted from user terminal 110 to first server 120. Here, the user identification information UJ may be any information that can identify or identify the individual, such as name information, employee number, or email address. The second server 130 as a server is configured to collect user identification information UJ and work information SJ from each user terminal 110 stored in the first server 120 and store it in a man-hour management sheet KS (see Figure 11), which is a sheet for inputting specified work information in file data EX in a specified cell display format.

[0031] As a result, the work information SJ entered on the schedule screen 112 of the browser 111 of each user's user terminal 110 is sent to the server and collected in a man-hour management sheet KS, which is a specified work information input sheet in a single specified cell display format of file data EX. As a result, administrators can easily search, aggregate, and analyze each user's work information SJ related to the project.

[0032] Next, the operation of the project management system 100 will be described in more detail. As shown in FIG. 2, in step S1, as an access determination step, the first server 120 determines whether or not there has been access from the user terminal 110 to the first server 120. Specifically, the user terminal 110 communicates with the first server 120 based on the predetermined URL information and sends an http request. In response, the first server 120 returns data of a login screen as an example of an HTTP response, and determines whether or not a login operation to the calendar and schedule system has been performed on the user terminal 110. If it is determined that there has been access, the process proceeds to step S2, and if it is determined that there has not been access, step S1 is repeated.

[0033] In step S2, as shown in FIG. 3, as a schedule screen display step, browser 111 of user terminal 110 displays schedule screen 112 of the user. In step S3, as a work information input / save operation determination step (work information transmission step), the browser 111 of the user terminal 110 determines whether the user has input work information SJ on the schedule screen 112 and performed a save operation. As shown in FIG. 3, as an example of the input and save operation of the work information SJ, for example, it is assumed that the user selects an arbitrary date and time position 112a on the schedule screen 112. Then, the browser 111 of the user terminal 110 displays a first simplified input screen 113 as an example of the first input screen.

[0034] Here, the first simplified input screen 113 is provided with a title input field 113a, a date and time display field, a detailed explanation input field 113b, and, as an example, a case details button 113c and an "other options" button 113d. The title input field 113a is a field for inputting a title. In the date and time display field, date and time information corresponding to the date and time portion 112a arbitrarily selected by the user is input. The date and time information displayed in the date and time display field can be freely changed. The detailed explanation input field 113b is provided so that text and attached files can be freely input. The case details button 113c is provided so that when operated, the browser 111 of the user terminal 110 displays a second input screen 115, which will be described later. It should be noted that the first simplified input screen 113 does not necessarily have to include the case details button 113c.

[0035] Furthermore, when the "Other options" button 113d is operated, the browser 111 of the user terminal 110 displays a first input details screen 114 as the first input screen, as shown in FIG. The first input details screen 114 is provided with a title input field 114a, a date and time display field, a detailed explanation input field 114b, a case details button 114c, and a "save" button 114d. Here, the relationship between the first simplified input screen 113 and the first detailed input screen 114 is such that the contents of the simplified first simplified input screen 113 are displayed in detail on the detailed first input screen 114, and the display items and roles and functions are basically the same. Of course, when an arbitrary date and time section 112a on the schedule screen 112 of FIG. 3 is selected, the browser 111 may be configured to display the first detailed input screen 114 without displaying the first simplified input screen 113.

[0036] Then, as shown in FIG. 4, it is assumed that the case details button 114c on the first input details screen 114 is operated. Then, as shown in FIG. 5, the browser 111 of the user terminal 110 displays a second input screen 115. As an example, the second input screen 115 has a project name input field 115a, a phase input field 115b, and a work information input field 115c for entering information about the work, as well as a work date and time display field, a department name input field, a department name 2 input field, and a job title input field. Of these, the project name input field 115a and the phase input field 115b are provided so that the input contents can be freely selected.

[0037] Specifically, as shown in FIG. 6, file data EX in a predetermined cell display format includes a project list sheet PS. The file data EX in a predetermined cell display format is stored in the second server 130, for example. Furthermore, project name information PJ and project phase name information PH are set and entered in the project list sheet PS. When work information SJ is entered on the schedule screen 112 displayed on the browser 111 of the user terminal 110, the browser 111 of the user terminal 110 is configured to display the project name information PJ and project phase name information PH in a freely selectable input manner based on the project name information PJ and project phase name information PH that are pre-set in the project list sheet PS of the file data EX in a predetermined cell display format via the first server 120 and the second server 130.

[0038] As a result, when each user inputs their own work information SJ, the project name information PJ and project phase name information PH are displayed freely and selectively based on the project name information PJ and project phase name information PH that are preset in the project list sheet PS of the file data EX in a predetermined cell display format. As a result, each user can easily input at least a portion of the work information SJ. That is, the project name information PJ and project phase name information PH, which are at least part of the work information SJ, are displayed so that the user can freely select and input. As a result, the input burden on each user can be reduced and input errors can be avoided. Furthermore, there is no risk of incorrect writing. As a result, the administrator can easily search and compile each user's work information SJ, and the accuracy of the analysis results can be significantly improved.

[0039] More specifically, when work information SJ is input on the schedule screen 112, an arbitrary date and time position 112a on the schedule screen 112 is selected. Then, the browser 111 of the user terminal 110 displays the first simplified input screen 113 or the first detailed input screen 114 as the first input screen having title input fields 113a, 114a, detailed description input fields 113b, 114b, and case details buttons 113c, 114c. When the project details button 113c on the first simplified input screen 113 or the project details button 114c on the first detailed input screen 114 is operated, the browser 111 of the user terminal 110 displays the second input screen 115 having a project name input field 115a, a phase input field 115b, and a work information input field 115c.

[0040] Then, the browser 111 of the user terminal 110 displays the project name information PJ in the project name input field 115a of the second input screen 115 so that the project name information PJ can be freely selected and input based on the project name information PJ that has been pre-set in the project list sheet PS of the file data EX in a predetermined cell display format via the first server 120 and the second server 130. Similarly, the browser 111 of the user terminal 110 is configured to display the phase name information PH in the phase input field 115b of the second input screen 115 so that it can be freely selected and input based on the phase name information PH that has been pre-set in the project list sheet PS of the file data EX in a predetermined cell display format via the server.

[0041] This allows the user to freely select project name information PJ and phase name information PH simply by selecting any date and time location 112a on the schedule screen 112 and clicking case details buttons 113c and 114c. As a result, the user can easily select and input the project name information PJ and the phase name information PH.

[0042] The work date and time display field on the second input screen 115 is designed to reflect and display the date and time information in the date and time display field on the first simplified input screen 113 and the date and time display field on the first detailed input screen 114. Of course, the work date and time display field on the second input screen 115 may be freely changed or modified. Furthermore, for the department name input field, department name 2 input field, and job title input field, once a user has entered something, the browser 111 may be configured to read a cookie and reflect the previous input from the second time onwards, or it may be configured to reflect the department name information, department name 2 information, and job title information of the user that has been pre-registered in the user list sheet US (see Figure 9) of the file data EX in a specified cell display format, which will be described later.

[0043] Then, the user enters work information SJ, which is the actual work content, into the work information input field 115c of the second input screen 115, and as an example of a saving operation, operates the ``Confirm'' button and the ``Save'' button on the second input screen 115. Then, as shown in Figure 7, the browser 111 of the user terminal 110 is configured to input the project name information PJ, phase name information PH, and work information SJ into the detailed explanation input field 114b on the first input details screen 114, which is an example of the first input screen, based on the project name information PJ, phase name information PH, and work information SJ input on the second input screen 115.

[0044] As a result, the information entered on the second input screen 115 is reflected in the detailed explanation input field 114b on the first detailed input screen 114, which is an example of the first input screen. As a result, even in a configuration in which there is a two-stage input screen display consisting of the first simplified input screen 113 or the first detailed input screen 114 as the first input screen, and the second input screen 115, it is possible to avoid increasing the input burden on the user and improve usability.

[0045] Furthermore, in this embodiment, as shown in Figure 5, when a selection input operation is performed on project name information PJ and phase name information PH on the second input screen 115, the browser 111 of the user terminal 110 determines whether or not there is input in the title input fields 113a, 114a of the first simplified input screen 113 or the first detailed input screen 114 as the first input screen. Then, as shown in FIG. 7, if it is determined that there is no input in the title input fields 113a, 114a, the browser 111 of the user terminal 110 inputs the project name information PJ and the phase name information PH into the title input fields 113a, 114a on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen, based on the project name information PJ and the phase name information PH selected and input on the second input screen 115. On the other hand, if it is determined that there is input in the title input fields 113a, 114a, the browser 111 of the user terminal 110 is configured to leave the project name information PJ and phase name information PH selected and input on the second input screen 115 as is without reflecting them in the title input fields 113a, 114a on the first input screen.

[0046] As a result, as shown in FIG. 7, if the user does not enter a title on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen, the user only needs to select and enter the project name information PJ and the phase name information PH on the second input screen 115, and these will be reflected in the title input fields 113a, 114a on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen. As a result, an easy-to-understand title can be set.

[0047] Then, as shown in FIG. 7, when the "Save" button 114d on the first input details screen 114 serving as the first input screen is operated, the browser 111 of the user terminal 110 determines that an input / save operation has been performed on the work information SJ and proceeds to step S4; on the other hand, if it determines that no input / save operation has been performed yet, step S3 is repeated. Regarding the save operation, the operation of the "Save" button 114d has been given as an example, but instead, a send operation by operating a "Send" button or a registration operation by operating a "Register" button, which are similar in function, may be used.

[0048] In step S4, as a work information transmission step, the user identification information UJ and the input work information SJ are transmitted from the user terminal 110 to the first server 120. More specifically, the content information of the first input details screen 114 shown in FIG. At the same time, as shown in FIG. 8, the browser 111 of the user terminal 110 displays the schedule screen 112, and displays the title information of the title input field 114a, which is part of the content information of the first input details screen 114, and the time information of the date and time information in the arbitrary date and time field 112a.

[0049] This allows the schedule screen 112 (see FIG. 8) to be displayed in an easy-to-understand manner. On the other hand, if the user enters a title on the first simple input screen 113 or the first detailed input screen 114 as the first input screen, the entered title is respected and the selected input on the second input screen 115 is not reflected in the title input fields 113a, 114a of the first simple input screen 113 or the first detailed input screen 114 as the first input screen. As a result, it is possible to prevent the title that the user inputs on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen from being overwritten. Furthermore, the title that the user inputs on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen can be displayed in an easy-to-understand manner on the schedule screen 112 (see FIG. 8).

[0050] In this embodiment, as shown in FIG. 9, the file data EX in a predetermined cell display format includes a user list sheet US. In the user list sheet US, name information, which is an example of user identification information UJ, and a calendar address, which is address information AD relating to the user's schedule screen 112, are set and input. More specifically, as an example, the user list sheet US contains the following information: department name information, department name 2 information, job title information, name information, email address information, and calendar address information, which is address information AD related to the user's schedule screen 112. Here, the department name 2 information is information of a lower group with respect to the department name information.

[0051] The second server 130 is configured to collect, based on address information AD relating to the user's schedule screen 112 preset in the user list sheet US of the file data EX in a predetermined cell display format, work information SJ saved and registered in the first server 120, which is the destination of the address information AD, from the first server 120, which is the destination of the address information AD, and save it in a man-hour management sheet KS (see Figure 11) as a predetermined work information input sheet in the file data EX in a predetermined cell display format of the second server 130.

[0052] As a result, only the work information SJ relating to the registered user is collected and saved in the man-hour management sheet KS, which is a predetermined work information input sheet in the file data EX in a predetermined cell display format. As a result, administrators can easily search, aggregate, and analyze work information SJ related only to registered users.

[0053] Furthermore, in this embodiment, as shown in FIG. 10, a browser 141 of a manager terminal 140 that can communicate with the second server 130 displays a project management screen 142 that is a project management site related to the work information SJ of the project. The project management screen 142 is provided with, for example, a "Latest Data Update" button 142a, a "Man-hours List" tab 142b, a "Project-specific Total" tab 142c, and a "User-specific Total" tab 142d.

[0054] In step S5, as a data collection trigger determination step, second server 130 determines whether a predetermined time has elapsed or whether a predetermined data collection operation has been performed. More specifically, it is assumed that a predetermined time has passed since the previous data collection, or that the "Update to Latest Data" button 142a has been operated as an example of a predetermined data collection operation by the administrator. At this time, the second server 130 determines that a predetermined time has elapsed, or an HTTP request is sent from the administrator terminal 140 to the second server 130 based on the operation of the "Update latest data" button 142a, and the second server 130, upon receiving the HTTP request, determines that a predetermined data collection operation has been performed by the administrator. If it is determined that a predetermined time has elapsed or that a predetermined data collection operation has been performed, the process proceeds to step S6, and if it is determined that no data collection operation has been performed yet, step S5 is repeated. Although a data collection trigger determination step is provided, it is of course possible to omit the data collection trigger determination step and configure the second server 130 to always collect user identification information UJ and work information SJ from the first server 120, if possible.

[0055] In step S6, as shown in FIG. 11, as a collection and storage step, the second server 130 collects the user identification information UJ and work information SJ from each user terminal 110 stored in the first server 120 and stores them in a man-hour management sheet KS, which is a sheet for inputting specified work information in file data EX in a specified cell display format. As a result, as described above, the user can freely select the project name information PJ and the phase name information PH simply by selecting any date and time location 112a on the schedule screen 112 and clicking the case details buttons 113c and 114c. As a result, the user can easily select and input the project name information PJ and the phase name information PH.

[0056] More specifically, as shown in Figures 9 and 11, the second server 130 is configured to collect user identification information UJ and work information SJ stored in the first server 120 for multiple pre-registered user members and store them in a labor-hour management sheet KS, which is a sheet for inputting specified work information in file data EX in a specified cell display format. As a result, at predetermined time intervals or when a predetermined data collection operation is performed, work information SJ for multiple pre-registered user members is collected all at once and saved in a man-hour management sheet KS, which is a sheet for inputting predetermined work information in file data EX in a predetermined cell display format. As a result, administrators can easily search, aggregate, and analyze each user's work information SJ related to the project.

[0057] In this embodiment, the man-hour management sheet KS, which is a sheet for inputting predetermined work information in file data EX in a predetermined cell display format, is displayed on the browser 141 of the administrator terminal 140, which can communicate with a third server (not shown) as a server. Next, based on a deploy operation by the administrator, the third server issues URL information corresponding to the man-hour management sheet KS, which is a predetermined work information input sheet of the file data EX in a predetermined cell display format. As shown in FIG. 12, when the administrator terminal 140 accesses the third server based on the URL information, the browser 141 of the administrator terminal 140 is configured to display a project management screen 142, which is a project management site related to the project work information SJ, based on a script that is preset in association with the man-hour management sheet KS, which is a sheet for inputting specified work information in the file data EX in a specified cell display format, and the file data EX in the specified cell display format.

[0058] As a result, the contents of the man-hour management sheet KS, which is a predetermined work information input sheet in the file data EX in a predetermined cell display format, are displayed on the project management screen 142, which is the project management site. As a result, the administrator can easily display the desired content and perform searches, aggregations, and analyses. For example, as shown in FIG. 12, when the "Man-hour List" tab 142b is selected on the project management screen 142, if conditions such as project name information PJ are entered and the search button is operated, the search results will be displayed within the range of the content collected and saved in the man-hour management sheet KS, which is a sheet for inputting specified work information in file data EX in a specified cell display format. When the "Man-hours List" tab 142b of the project management screen 142 is selected, a project name input field, a date input field, a phase name input field, and a user name input field are provided. Of these, the project name input specification field, phase name input specification field, and user name input specification field are provided in a pull-down format for free selection and input based on the project name information PJ and phase name information PH registered in the project list sheet PS of the file data EX in a specified cell display format, and the user identification information UJ (name information) registered in the user list sheet US. This eliminates input errors. As a result, administrators can easily perform highly accurate searches, aggregations, and analyses.

[0059] Also, as shown in FIG. 13, when the "Project-by-Project Summary" tab 142c on the project management screen 142 is selected, the project name information PJ registered in the project list sheet PS of the file data EX in a predetermined cell display format or the project name information PJ saved in the man-hour management sheet KS is displayed in list form. When the administrator selects any project name from the list, a graph of the amount of work (time spent) by phase for that project is displayed based on the phase name and work time information, which are part of the work information SJ stored in the man-hour management sheet KS of the file data EX in a specified cell display format. Furthermore, for that project, it is configured to display the amount of work (time spent) by user based on the name information and work time information, which is user identification information UJ, which is part of the work information SJ stored in the man-hour management sheet KS of file data EX in a specified cell display format.

[0060] Furthermore, as shown in FIG. 14, when the "User Summary" tab 142d on the project management screen 142 is selected, the user identification information UJ, which is the name information registered in the user list sheet US of the file data EX in a predetermined cell display format, or the user identification information UJ, which is the name information saved in the man-hour management sheet KS, is displayed in list form. When the administrator selects any name from the list, a graph of the amount of work (time spent) by project for the user with that name is displayed based on the project name and work time information that is part of the work information SJ stored in the man-hour management sheet KS of the file data EX in a specified cell display format. Furthermore, for that user, it is configured to display the amount of work (time spent) for each phase by project based on the project name information PJ, phase name information PH, and work time information, which are part of the work information SJ stored in the man-hour management sheet KS of file data EX in a specified cell display format.

[0061] Here, we will explain "deployment" in more detail. The "script previously set in association with the file data EX in cell display format" refers to a script (command, program) for displaying the contents of the file data EX in cell display format on the browser 141 of the administrator terminal 140 when the administrator terminal 140 accesses the third server based on the URL information, and is a so-called container-bound script that is set in association with the file data EX in cell display format. Specifically, it specifies which cell's information in the cell-display format file data EX is to be displayed where on the project management screen 142, which is the project management site, and reflects the displayed action in the specified cell in the cell-display format file data EX. The "script that has been pre-set in association with the file data EX in cell display format" only needs to be set and saved in association with the file data EX in cell display format, and may be saved integrally with the file data EX in cell display format itself, or may be saved separately.

[0062] More specifically, when the browser 141 of the administrator terminal 140 is displaying file data EX in a cell display format containing work information SJ, project name information PJ, phase name information PH, user identification information UJ, etc., as an example of a deployment operation, the "Function Extensions" button in the menu of the browser 141 is operated as a deployment operation button, and the "Apps Script" button is operated as a deployment operation button.

[0063] Then, the browser 141 of the administrator terminal 140 displays an Apps Script screen (not shown). The Apps Script screen displays a pre-set script associated with file data EX in cell display format. Here, the script that is pre-set in association with the file data EX in cell display format is a script (command, program) for displaying the contents of the file data EX in cell display format on the browser 141 of the administrator terminal 140 when the administrator terminal 140 accesses the third server based on the URL information. This script is a so-called container-bound script that is set in association with file data EX in cell display format. Specifically, this script specifies which cell's information in the cell-display format file data EX is to be displayed where on the project management screen 142, which is the project management site, and reflects the displayed action in the specified cell in the cell-display format file data EX.

[0064] As an example of a deployment operation, it is assumed that the "Deploy" button serving as a deployment operation button is operated on the Apps Script screen, and further a "New Deploy" button (not shown) or the like serving as a deployment operation button is operated. Although the deployment operation has been described as an example of a button operation on the browser 141 of the administrator terminal 140, it may also be an operation of selecting an item button by right-clicking or a shortcut key operation on the keyboard.

[0065] Here, "deploy" means "to unfold, to place, etc." In the IT field, "deployment" refers to the process of placing and expanding application functions and services on a server (third server) and making them available during the system development process for web applications and other systems. When the browser 141 of the administrator terminal 140 is displaying file data EX in a cell display format in which work information SJ, project name information PJ, phase name information PH, user identification information UJ, etc. are set, by operating the "Apps Script" button (which is part of the deployment operation), a script (a so-called container-bound script) that operates in a state linked to the file data EX in a cell display format in which work information SJ, project name information PJ, phase name information PH, user identification information UJ, etc. are set is displayed on the browser 141 (Apps Script screen) and can be freely edited. If a container bind script has been set in advance, the set container bind script is displayed in an editable manner.

[0066] Based on a deploy operation by an administrator, the third server issues URL information corresponding to file data EX in a cell display format. More specifically, the browser 141 of the administrator terminal 140 displays a deployment window. The deployment window displays deployment ID information and URL information issued by the third server as a web application. That is, based on the deploy operation, the third server issues URL information associated with the file data EX in cell display format, and based on this information, the browser 141 of the administrator terminal 140 displays the deploy window.

[0067] The project management system 100, an embodiment of the present invention obtained in this manner, comprises a plurality of user terminals 110 and a first server 120 and a second server 130 acting as servers. The user terminals 110 communicate with the first server 120 acting as a server. The browser 111 of the user terminal 110 displays the user's schedule screen 112. When work information SJ is entered on the schedule screen 112 and a save operation is performed, the user identification information UJ and the entered work information SJ are sent from the user terminal 110 to the first server 120. The second server 130 collects the user identification information UJ and work information SJ from each user terminal 110 that is stored in the first server 120 and stores it in a man-hour management sheet KS, which is a specified work information input sheet in file data EX of a specified cell display format on the second server 130. This configuration allows the administrator to easily search, aggregate, and analyze each user's work information SJ related to the project.

[0068] Furthermore, when a predetermined time has passed or when the administrator performs a predetermined data collection operation, the second server 130 collects the user identification information UJ and work information SJ stored in the first server 120 for multiple pre-registered user members and stores them in a man-hour management sheet KS, which is a predetermined work information input sheet in file data EX of a predetermined cell display format on the second server 130, allowing the administrator to easily search, compile, and analyze each user's work information SJ related to the project.

[0069] Furthermore, the file data EX in a predetermined cell display format has a project list sheet PS, in which project name information PJ and project phase name information PH are set and input, and when work information SJ is input on the schedule screen 112 displayed on the browser 111 of the user terminal 110, the browser 111 of the user terminal 110 displays the project name information PJ and project phase name information PH in a manner that allows free selection and input based on the project name information PJ and project phase name information PH that are pre-set in the project list sheet PS of the file data EX in a predetermined cell display format via the first server 120 and the second server 130. This allows each user to easily input at least a portion of the work information SJ, reducing the input burden on each user and preventing input errors, and significantly improving the accuracy of the results of the administrator's easy search, aggregation, and analysis of each user's work information SJ.

[0070] Furthermore, when work information SJ is input on the schedule screen 112, if an arbitrary date and time location 112a on the schedule screen 112 is selected, the browser 111 of the user terminal 110 displays a first simplified input screen 113 or a first detailed input screen 114 as a first input screen having title input fields 113a, 114a, detailed description input fields 113b, 114b, and case detail buttons 113c, 114c. If the case detail buttons 113c, 114c are operated, the browser 111 displays a second input screen 115 having a project name input field 115a, a phase input field 115b, and a work information input field 115c. In a, the project name information PJ is displayed for free selection and input based on the project name information PJ that has been preset in the project list sheet PS of the file data EX in a predetermined cell display format via the first server 120 and the second server 130, and in the phase input field 115b, the phase name information PH is displayed for free selection and input based on the phase name information PH that has been preset in the project list sheet PS of the file data EX in a predetermined cell display format via the first server 120 and the second server 130, thereby allowing the user to easily select and input the project name information PJ and the phase name information PH.

[0071] Furthermore, when project name information PJ, phase name information PH, and work information SJ are entered in the project name input field 115a, phase input field 115b, and work information input field 115c on the second input screen 115 and a save operation is performed, the browser 111 is configured to input the project name information PJ, phase name information PH, and work information SJ into the detailed explanation input fields 113b, 114b on the first simplified input screen 113 or the first detailed input screen 114 as the first input screen based on the project name information PJ, phase name information PH, and work information SJ entered on the second input screen 115.This makes it possible to avoid an increase in the input burden on the user and improve usability, even in a configuration where there is a two-stage input screen display of the first simplified input screen 113 or the first detailed input screen 114 as the first input screen, and the second input screen 115.

[0072] Furthermore, when a selection input operation of project name information PJ and phase name information PH is performed on the second input screen 115, the browser 111 determines whether or not there is input in the title input fields 113a, 114a of the first simplified input screen 113 or the first detailed input screen 114 serving as the first input screen. If it is determined that there is no input in the title input fields 113a, 114a, the browser 111 inputs the project name information PJ and the phase name information PH into the title input fields 113a, 114a of the first simplified input screen 113 or the first detailed input screen 114 serving as the first input screen based on the project name information PJ and the phase name information PH selected and input on the second input screen 115. If it is determined that there is input in the title input fields 113a, 114a, the browser 111 inputs the project name information PJ and the phase name information PH selected and input on the second input screen 115 into the title input fields 113a, 114a of the first simplified input screen 113 or the first detailed input screen 114 serving as the first input screen. Since the title input field 113a, 114a on the first simple input screen 113 or the first detailed input screen 114 is left as it is without being reflected, if the user does not input a title on the first simple input screen 113 or the first detailed input screen 114 as the first input screen, an easy-to-understand title can be set, and the title can be displayed in an easy-to-understand manner on the schedule screen 112. On the other hand, if the user inputs a title on the first simple input screen 113 or the first detailed input screen 114 as the first input screen, it is possible to avoid the title input by the user on the first simple input screen 113 or the first detailed input screen 114 as the first input screen being overwritten, and the title input by the user on the first simple input screen 113 or the first detailed input screen 114 as the first input screen can be displayed in an easy-to-understand manner on the schedule screen 112.

[0073] Furthermore, the file data EX in a predetermined cell display format has a user list sheet US, in which user identification information UJ and address information AD related to the user's schedule screen 112 are set and input. The second server 130 collects work information SJ saved and registered in the first server 120, which is the destination of the address information AD, based on the address information AD related to the user's schedule screen 112 that is preset in the user list sheet US of the file data EX in a predetermined cell display format, from the first server 120, which is the destination of the address information AD, and saves it in a man-hour management sheet KS, which is a predetermined work information input sheet of the file data EX in a predetermined cell display format. This allows the administrator to easily search, compile, and analyze work information SJ related only to registered users.

[0074] Furthermore, a man-hour management sheet KS, which is a sheet for inputting predetermined work information in file data EX in a predetermined cell display format, is displayed on a browser 141 of an administrator terminal 140 that can communicate with the second server 130, and based on a deploy operation by the administrator, a third server (not shown) issues URL information corresponding to the man-hour management sheet KS, which is a sheet for inputting predetermined work information in file data EX in a predetermined cell display format. When the administrator terminal 140 accesses the third server based on the URL information, the browser 141 of the administrator terminal 140 displays a project management screen 142, which is a project management site related to project work information SJ, based on a preset script associated with the man-hour management sheet KS, which is a sheet for inputting predetermined work information in file data EX in a predetermined cell display format, and the file data EX in the predetermined cell display format. This allows the administrator to display the desired content and easily perform searches, aggregations, and analyses.

[0075] Furthermore, the program for the project management system 100, which is an embodiment of the present invention, causes a computer to execute the following steps: a schedule screen display step S2 in which the user terminal 110 communicates with the first server 120 and the browser 111 of the user terminal 110 displays the user's schedule screen 112; work information transmission steps S3 and S4 in which, when work information SJ is entered on the schedule screen 112 and a save operation is performed, the user identification information UJ and the entered work information SJ are transmitted from the user terminal 110 to the first server 120; and a collection and storage step S6 in which the second server 130 collects the user identification information UJ and work information SJ from each user terminal 110 on the first server 120 and stores them in a man-hour management sheet KS, which is a predetermined work information input sheet in file data EX of a predetermined cell display format on the second server 130. This has enormous benefits, such as allowing the manager to easily search, compile, and analyze each user's work information SJ related to a project. [Explanation of symbols]

[0076] 100 ··· Project Management System 110 User terminal 111 ··· (User device) browser 112 ··· Schedule screen 112a... Any date and time 113 First simple input screen (First input screen) 113a··· Title input field 113b...Detailed description input field 113c··· Project details button 113d... "More Options" button 114 ··· First input details screen (First input screen) 114a··· Title input field 114b...Detailed description input field 114c··· Project details button 114d··· "Save" button 115 Second input screen 115a Project name input field 115b Phase input field 115c··· Work information input field 120 - Primary server (for calendar) 130 Secondary server (for project management) 140 ··· Administrator terminal 141 ··· Browser (on administrator's computer) 142 ··· Project management screen (project management site) 142a "Update latest data" button (predetermined data collection operation) 142b... "Man-hours List" tab 142c... "Project Summary" tab 142d "User Summary" tab SJ ··· Work Information UJ User identification information EX: Cell display format file data KS ··· Man-hour management sheet (sheet for inputting work information) PS Project List Sheet US ··· User List Sheet PJ ··· Project name information PH Phase name information AD: Address information (related to the user's schedule screen)

Claims

1. A project management system that includes a plurality of user terminals and a server, and that aggregates user work information related to a project input from a browser on the user terminal, comprising: The user terminal communicates with the server, and the browser of the user terminal displays the user's schedule screen; When work information is input on the schedule screen and a save operation is performed, the user identification information and the input work information are transmitted from the user terminal to the server; A project management system characterized in that the server is configured to collect user identification information and work information from each user terminal and store the collected information in a predetermined work information input sheet in file data in a predetermined cell display format.

2. 2. The project management system of claim 1, wherein the server collects user identification information and work information stored on the server for multiple pre-registered user members and stores the collected information in a predetermined work information input sheet in file data with a predetermined cell display format when a predetermined time has elapsed or when a predetermined data collection operation is performed by an administrator.

3. the file data in the predetermined cell display format has a project list sheet, The project list sheet contains project name information and project phase name information.

3. The project management system according to claim 2, wherein when work information is entered on a schedule screen displayed on a browser on a user terminal, the browser displays project name information and project phase name information in a manner that allows for free selection and input based on project name information and project phase name information preset in a project list sheet of file data in a predetermined cell display format via the server.

4. When work information is input on the schedule screen, if an arbitrary date and time location on the schedule screen is selected, the browser displays a first input screen having a title input field, a detailed description input field, and a case details button, 4. The project management system according to claim 3, wherein, when the case details button is operated, the browser displays a second input screen having a project name input field, a phase input field, and a work information input field, and in the project name input field, project name information is displayed so as to be freely selectable and input based on project name information previously set in a project list sheet of file data in a predetermined cell display format via the server, and in the phase input field, phase name information is displayed so as to be freely selectable and input based on phase name information previously set in a project list sheet of file data in a predetermined cell display format via the server.

5. 5. The project management system according to claim 4, wherein when project name information, phase name information, and work information are entered in the project name input field, phase input field, and work information input field on the second input screen and a save operation is performed, the browser inputs the project name information, phase name information, and work information into a detailed description input field on the first input screen based on the project name information, phase name information, and work information entered on the second input screen.

6. When a selection input operation of project name information and phase name information is performed on the second input screen, the browser determines whether or not there is input in a title input field on the first input screen; When it is determined that there is no input in the title input field, the browser inputs project name information and phase name information into the title input field on the first input screen based on the project name information and phase name information selected and input on the second input screen, 6. A project management system as described in claim 5, characterized in that, when it is determined that there is input in the title input field, the browser leaves the project name information and phase name information selected and input in the second input screen as is without reflecting them in the title input field in the first input screen.

7. the file data in the predetermined cell display format has a user list sheet, The user list sheet contains user identification information and address information related to the user's schedule screen.

7. A project management system according to claim 1, wherein the server is configured to collect work information stored and registered at the address information destination based on address information relating to a user's schedule screen preset in a user list sheet of the file data in the predetermined cell display format, and store the work information in a predetermined work information input sheet of the file data in the predetermined cell display format.

8. The predetermined work information input sheet of the file data in the predetermined cell display format is displayed on a browser of an administrator terminal that can communicate with the server, The server issues URL information corresponding to a predetermined work information input sheet of the file data in the predetermined cell display format based on a deploy operation by an administrator; 8. The project management system according to claim 7, wherein when the manager terminal accesses a server based on the URL information, a browser on the manager terminal displays a project management site relating to work information of the project based on a script that is preset in association with the specified work information input sheet of the file data in the specified cell display format and the file data in the specified cell display format.

9. A project management system program that aggregates user work information related to a project input from a browser on a user terminal, a schedule screen display step in which the user terminal communicates with the server and a browser of the user terminal displays a schedule screen of the user; a work information sending step of sending user identification information and the input work information from the user terminal to a server when work information is input on the schedule screen and a save operation is performed; a collection and storage step in which the server collects user identification information and work information from each user terminal and stores the collected information in a predetermined work information input sheet in file data with a predetermined cell display format.

Images