JP2016012156A - Slip entry assist system, slip entry assist method, and slip entry assist program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a slip entry assist system which enables accurate data entry in a slip, which is created by general-purpose spreadsheet software, at a construction site for a short period of time.SOLUTION: A slip entry assist system 100 that assists in a work of entering data in a slip that is created by general-purpose spreadsheet software and includes plural cells includes: assist menu display means 101 that displays plural assist menus 104 for use in a work of entering data in the cells; assist menu selection means 102 that selects an assist menu, which is used, from among the plural assist menus 104 on the basis of a worker's manipulation; and assist menu entry means 103 that enters data in the cells according to a worker's manipulation dependent on a selected assist menu. The assist menus 104 include two or more of Ten Keys 10, Keyboard 20, Copy and Paste 30, Terminology 40, Photographs 50, Date 60, Blowout 70, and Delete 80.

Description

  The present invention relates to a form input support system that supports an input operation to a form created by general-purpose spreadsheet software.

  Those who supervise the site at the construction site need to prepare a report as to whether the construction has been performed correctly. There are many types of reports, depending on the content of the work, and the types of reports may vary from owner to owner. Conventionally, when creating such a report, the target construction report paper is brought to the site in a blank form that has been printed out on paper in advance, written down on the paper while checking the construction status, and then a personal computer. I entered the data I wrote down after returning to an office with an environment.

  On the other hand, with the recent spread of tablet terminals, it is also possible to bring tablet terminals etc. that have recorded a large number of report formats into the construction site and input data directly while checking the construction status. It is. In particular, recent reports are often forms created by general-purpose spreadsheet software, and it is efficient if such a form can be input on site.

  On the other hand, in Patent Document 1, a procedure for displaying a work procedure step or work place in a nuclear power plant and a procedure for inputting confirmation information or measurement information that a work has been performed in the work procedure step or work place. And a procedure for storing confirmation information or measurement information in a database, and a procedure for inputting confirmation information or measurement information stored in the database into a form form and storing it as a report. Has been.

  Patent Document 2 describes an invention related to a data input / output device that performs data input / output between a business database and a form of general-purpose spreadsheet software using a template of general-purpose spreadsheet software created by a user. Has been.

JP 2012-159478 A JP 2012-123607 A

  However, the method of bringing in and filling in an unfilled report form printed out on paper and inputting data later on a personal computer requires time, and there is a possibility of omission of input of data, input differences, and the like. In addition, it is necessary to prepare a report sheet for the target construction from a number of types of reports in advance.

  On the other hand, the method of directly inputting data while checking the construction status by bringing a tablet terminal etc. in which a large number of report formats are recorded to the construction site will lead to reduction of time and input mistakes. However, in reality, the input operation on the tablet terminal in the field is an operation with a finger or a touch pen that is unfamiliar, so the reality is that it does not progress easily.

  On the other hand, the invention described in Patent Document 1 is a system in which work execution can be confirmed systematically for work in a limited place in a nuclear power plant. It does not support input to general reports such as created reports.

  Similarly, the invention described in Patent Document 2 relates to a data input / output device that performs data input / output between a business database and a form of general-purpose spreadsheet software. It does not support input.

  The present invention solves the above-described conventional problems, and a form input support system and form input support method that enable accurate data input in a short time at a construction site for a form created by general-purpose spreadsheet software. And a form input support program.

  In order to solve the above problems, a form input support system according to the present invention is a form input support system that supports an input work to a form made up of a plurality of cells created by general-purpose spreadsheet software, and is an input work to a cell. Support menu display means for displaying a plurality of support menus for the user, support menu selection means for selecting a support menu to be used from among the plurality of support menus based on the operation of the operator, and the selected support menu And a support menu input means for performing input to the cell based on the operation of the operator according to the above.

  Preferably, the plurality of support menus are two or more of a numeric keypad, a keyboard, copy / paste, a term, a photograph, a date, a balloon, and a deletion.

  The form input support method of the present invention is a form input support method for supporting an input operation to a form composed of a plurality of cells created by general-purpose spreadsheet software, and a plurality of support for input operations to a cell. A support menu display step for displaying a menu, a support menu selection step for selecting a support menu to be used from among the plurality of support menus based on an operation of the operator, and an operator's action corresponding to the selected support menu And a support menu input step for performing input to the cell based on the operation.

  The form input support program according to the present invention provides a form input support system for supporting an input operation to a form composed of a plurality of cells created by general-purpose spreadsheet software, with a plurality of support menus for the input operation to the cells. A support menu display step for displaying, a support menu selection step for selecting a support menu to be used from among the plurality of support menus based on an operation of the operator, and an operation of the operator according to the selected support menu And a support menu input step for performing input to the cell.

  According to the present invention, in supporting an input operation to a form composed of a plurality of cells created by general-purpose spreadsheet software, an operator can display a plurality of support menus for the input operation to the cells. The support menu that can be used can be easily recognized. Then, by selecting a support menu to be used from a plurality of support menus based on the operator's operation, the operator's intention to select the support menu is easily reflected in the system. Furthermore, by performing input to the cell based on the operator's operation corresponding to the selected support menu, the worker can easily perform input to the cell. Therefore, accurate data input can be performed in a short time at the construction site.

  In addition, by using two or more of the ten support menus such as the numeric keypad, keyboard, copy / paste, terminology, photo, date, callout, and deletion, it is possible to use the support menu as an effective function for the input work on the form. Can do.

  As described above, according to the present invention, a form input support system, a form input support method, and a form input support program that enable accurate data input in a short time on a construction site for a form created by general-purpose spreadsheet software are provided. can do.

It is a software block diagram of the form input assistance system which concerns on embodiment of this invention. It is a figure which shows a tablet terminal and a touch pen. It is a figure which shows an example of a form. It is a flowchart of form input support by a form input support system. It is a figure which shows a support menu screen. It is a figure which shows a ten key screen. It is a figure which shows a keyboard screen. It is a figure which shows a term selection screen. It is a figure which shows a term selection screen. It is explanatory drawing of a photograph menu. It is a figure which shows blowing. It is a figure which shows a blowing selection screen.

  Next, a form input support system according to an embodiment of the present invention will be described with reference to FIGS. First, the configuration of the form input support system according to the present embodiment will be described. FIG. 1 is a software configuration diagram of the form input support system 100.

  The form input support system 100 supports an input operation to a form composed of a plurality of cells created by general-purpose spreadsheet software by using a prepared support menu 104. As shown in FIG. 1, the form input support system 100 includes support menu display means 101, support menu selection means 102, and support menu input means 103.

  The support menu 104 is a plurality of menus for efficiently performing an operation in which the worker 1 inputs data to a plurality of cells of a form created by the general-purpose spreadsheet software. In the present embodiment, the support menu includes a numeric keypad 10, a keyboard 20, a copy / paste 30, a term 40, a photograph 50, a date 60, a balloon 70, and a deletion 80. The support menu may include all of these, or two or more of these. Furthermore, you may provide other menus other than these. In addition, each support menu may be held as a unique function of the form input support system 100, or may be a function owned by general-purpose spreadsheet software or an OS (operating system) of a terminal on which the system operates. . Details of each support menu will be described later.

  The support menu display means 101 has a function of displaying a plurality of support menus 104 for input work to the cell to the worker 1 and easily recognizes the support menu that can be used by the worker 1. Can be done.

  The support menu selection unit 102 has a function of selecting a support menu to be used from a plurality of support menus 104 based on the operation of the worker 1, and the intention of the worker 1 to select the support menu is included in the system. It is easily reflected.

  The support menu input unit 103 has a function of inputting to the cell based on the operation of the worker 1 corresponding to the selected support menu, and the worker can easily input to the cell. It is like that.

  Next, a specific method of using the form input support system 100 according to the present embodiment will be described with reference to FIGS. The form input support system 100 is realized by a tablet terminal 2 as shown in FIG. The tablet terminal 2 can perform an input operation using the touch pen 3, and general-purpose spreadsheet software capable of handling a form to be input is installed. And the tablet terminal 2 functions as the form input assistance system 100 by installing the program for implement | achieving the function mentioned above.

  FIG. 3 is a diagram illustrating an example of a form to be input. The form 4 shown in FIG. 3 is a list related to maintenance and repair of electrical equipment construction, and the cells to be input are diverse, such as date input, text input, selection by ○ mark, and pasting of a site photo. . If such an input operation for each cell is performed using only the functions possessed by the general-purpose spreadsheet software or the OS of the terminal on which the system operates, the menu selection becomes multi-stage and is complicated and inefficient. In particular, input using a tablet terminal in the field is difficult because it becomes an operation with a finger or a touch pen that is unfamiliar. On the other hand, since the menu selection is simplified by using the function of the form input support system 100 according to the present embodiment, the efficiency of the input work is dramatically increased.

  FIG. 4 is a flowchart of the form input support by the form input support system 100 according to the present embodiment. First, when the form input support program is started in the tablet terminal 2 with the form file to be input opened by the general-purpose spreadsheet software, a plurality of support menus 104 are displayed on the screen (step S101). FIG. 5 is a diagram showing the support menu screen S104. The support menu screen S104 is displayed superimposed on the display screen of the general-purpose spreadsheet software.

  The support menu screen S104 includes a numeric keypad 10, keyboard 20, copy / paste 30 (copy 31, paste 32), term 40, photo 50 (photo 1 (51), photo 2 (52)), date 60, balloon 70 and There are menu buttons for deletion 80, and the operator 1 selects each menu by touching the button of the support menu to be used (step S102).

  When a support menu to be used is selected based on the operation of the worker 1, the screen transitions to an input screen corresponding to the selected support menu. Then, input to the cell is performed based on the operation of the operator 1 corresponding to the selected support menu (step S103). The input operation in each support menu will be described below.

(1) Numeric Keypad When the numeric keypad 10 is touched in the state where the input target cell is selected in the general-purpose spreadsheet software, a numeric keypad screen S10 shown in FIG. 6 is displayed. The numeric keypad screen S10 is basically used for inputting numerical values, but in the present embodiment, in addition to numerical values, frequently used symbols and the like can be prepared and selected in advance. Here, ◯ 11, × 12, check box 13, no input 14, good 15 and negative 16 can be selected. Other symbols can also be prepared.

(2) Keyboard When the keyboard button 20 is touched with the input target cell selected in the general-purpose spreadsheet software, the handwriting input screen 21, the character input screen 22, and the numerical value input in the keyboard screen S20 shown in FIG. One of the modes on the screen 23 is displayed. Which mode is displayed may be, for example, the mode used last time, or may be separately selected as to which mode is to be used. Of course, the mode can be changed during the input.

(3) Copy / Paste Touch the copy button 31 with the copy target cell selected in the general-purpose spreadsheet software, and then touch the paste button 32 with the input target cell selected. As a result, the contents of the copy target cell are copied and pasted to the input target cell. It is also possible to copy / paste after selecting a plurality of cells at once. In addition, when copying and pasting, the cell format (display format, layout, font, ruled line, pattern, protection, etc.) is not copied (changed), and the pasted format remains unchanged. It is preferable. This is because the size of the character, the position of the ruled line, and the like are determined in advance depending on the input cell due to a problem in the design of the form, and these formats are prevented from being changed unintentionally.

(4) Term When the term button 40 is touched in the state where the input target cell is selected in the general-purpose spreadsheet software, the term selection screen S40 shown in FIGS. 8 and 9 is displayed. The term selection screen S40 is used to select a term to be input from previously registered terms, and to improve the term input efficiency. Pre-registered terms are displayed on the term selection screen S40. In this embodiment, a “unit other 1” tab 41 shown in FIG. 8 and a “unit other 2” tab 42 shown in FIG. 9 are prepared. ing. In the tab 41, a plurality of terms are registered in each of the “unit (amount)” item 41a, the “unit (dimension)” item 41b, and the “unit (quantity)” item 41c. In the tab 42, a plurality of terms are registered in each of a “unit (electricity)” item 42a, a “unit (empty tube)” item 42b, and a “unit (calculation)” item 42c.

  In the term selection screen S40, when the user touches the selection button 44 after touching the term to be input, the touched term is input to the input target cell. When the selection button 44 is touched after touching a plurality of terms, the plurality of touched terms are input side by side with a space therebetween. Since the data for term input varies greatly depending on the form to be input, it is preferable to register in advance according to the form used by the worker 1 himself. In this embodiment, the term pre-registration has two layers. However, the present invention is not limited to this, and a necessary hierarchical structure may be used according to the type and amount of terms.

(5) Photo (Photo 1)
After taking a field photograph with the built-in camera of the tablet terminal 2 and touching the photograph 1 button 51 in a state where the input target cell is selected in the general-purpose spreadsheet software, the photograph just taken is pasted to the input target cell. . This function can be realized by setting to automatically select the latest photo from photos taken and stored in the camera roll.
(Photo 2)
If the photograph 2 button 52 is touched in a state where the input target cell is selected in the general-purpose spreadsheet software, a list screen of the photograph files stored in the camera roll of the tablet terminal 2 is displayed. When a pasted photo is selected from the displayed photo files, the selected photo is pasted into the input target cell.

  In addition, the function of the photo 1 button can be changed as follows. First, select an input target cell and touch the Photo 1 button. Then, since the built-in camera is activated, the worker 1 takes necessary pictures. The photographed photograph is pasted on the input target cell and is stored in the camera roll of the tablet terminal 2. Finally, the built-in camera ends.

  When pasting a photo, the size of the photographed photo can be enlarged or reduced in accordance with the size of the input target cell. For example, as shown in FIG. 10, when the input target cell 52 is larger than the photographed photograph 51, it is automatically enlarged and pasted according to the size of the cell 52. When the aspect ratio of the photo 51 and the aspect ratio of the cell 52 are different, the aspect ratio may be changed so that the cell 52 is filled, or a blank space is generated in the cell 52 so that the aspect ratio of the photo 51 is maintained. It may be. Furthermore, it may be possible to select the magnification by pasting without enlarging or reducing the size of the photo, for example, by right-clicking or long pressing the photo button.

(6) Date When the date button 60 is touched with the input target cell selected in the general-purpose spreadsheet software, today's date is input. When an arbitrary date is desired to be input, a calendar may be displayed by using a right click or long press of a date button, and an arbitrary date may be selected from the calendar.

(7) Blowout When the blowout button 70 is touched with the input target cell selected in the general-purpose spreadsheet software, a blowout 71 as shown in FIG. 11 is pasted near the selected cell. When other balloons or symbols are to be input, a balloon selection screen S70 as shown in FIG. 12 is displayed by using a right click or long press of the balloon button 70, and the balloons or symbols displayed are displayed. An arbitrary one may be selected from the above.

(8) Deletion When the delete button 80 is touched in a state where the cell to be deleted is selected in the general-purpose spreadsheet software, the contents of the cell are deleted.

  According to the form input support system 100 according to the present embodiment, a plurality of support menus 104 for input work to cells are provided in supporting input work to a form composed of a plurality of cells created by general-purpose spreadsheet software. By displaying, the support menu that can be used by the worker 1 can be easily recognized. Then, by selecting a support menu to be used from among the plurality of support menus 104 based on the operation of the worker 1, the intention of the worker 1 to select the support menu is easily reflected in the system. Furthermore, by performing input to the cell based on the operation of the worker 1 corresponding to the selected support menu, the worker can easily perform input to the cell. Therefore, accurate data input can be performed in a short time at the construction site.

  In addition, as a plurality of support menus 104, two or more of the numeric keypad 10, keyboard 20, copy / paste 30, term 40, photo 50, date 60, balloon 70, and deletion 80 are effective for input into a form. Functions can be used as a support menu.

  As described above, according to the form input support system 100 according to the present embodiment, it is possible to input data accurately in a short time at a construction site for a form created by general-purpose spreadsheet software.

  The form input support system 100 according to the embodiment of the present invention has been described above. However, the present invention is not limited to the above-described embodiment, and various other modifications are possible. For example, in the above-described embodiment, the program is installed in the tablet terminal 2 to form the form input support system. However, the form input support system is configured by connecting the tablet terminal 2 and a server installed in the head office to the network. You may make it do.

  Moreover, it is applicable also to information processing apparatuses other than a tablet terminal. However, application to a tablet terminal is extremely effective when assumed to be used at a construction site.

DESCRIPTION OF SYMBOLS 1 Worker 2 Tablet terminal 3 Touch pen 4 Form 10 Numeric keypad 20 Keyboard 30 Copy and paste 40 Term 50 Photograph 60 Date 70 Callout 80 Delete 100 Form input support system 101 Support menu display means 102 Support menu selection means 103 Support menu input means 104 Support menu

Claims (4)

A form input support system that supports an input operation to a form consisting of a plurality of cells created by general-purpose spreadsheet software,
A support menu display means for displaying a plurality of support menus for input to the cell;
A support menu selection means for selecting a support menu to be used from among the plurality of support menus based on an operation of an operator;
Based on the operator's operation according to the selected support menu, support menu input means for performing input to the cell;
A form input support system characterized by comprising:   2. The form input support system according to claim 1, wherein the plurality of support menus are two or more of a numeric keypad, a keyboard, copy / paste, a term, a photograph, a date, a balloon, and a deletion. A form input support method for supporting an input operation to a form composed of a plurality of cells created by general-purpose spreadsheet software,
A support menu display step for displaying a plurality of support menus for input to the cell;
A support menu selection step of selecting a support menu to be used from among the plurality of support menus based on the operation of the operator;
Based on the operator's operation according to the selected support menu, a support menu input step for performing input to the cell;
A form input support method characterized by comprising: In the form input support system that supports the input work to the form consisting of multiple cells created by general-purpose spreadsheet software,
A support menu display step for displaying a plurality of support menus for input to the cell;
A support menu selection step of selecting a support menu to be used from among the plurality of support menus based on the operation of the operator;
Based on the operator's operation according to the selected support menu, a support menu input step for performing input to the cell;
A form input support program to execute.

Images