JP2019121002A - Information processing method, information processing device, and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processing method, an information processing device, and a program capable of improving work efficiency when inputting data to a data sheet. An information processing method is a tabular data sheet that is composed of a plurality of columns each including a plurality of cells and a plurality of rows each including a plurality of cells, and enables editing of each cell. Identifying at least one column selected in step 1, identifying at least one row selected in the data sheet, and defining a first cell at which the selected column and the selected row intersect. And a step of permitting editing of the first cell of the plurality of cells included in each of the selected column and the selected row. [Selection diagram] Fig. 10

Description

  The present invention relates to an information processing method, an information processing apparatus, and a program.

  A plurality of cells are arranged in the column direction and the row direction, and tabular data sheets capable of inputting data in each cell are used in various fields. An example of the data sheet is a spreadsheet in spreadsheet software.

  Here, an example of the utilization aspect of the said data sheet is shown below.

  For example, a user of the accommodation facility performs a reservation operation using a reservation management system managed by the accommodation facility. In the reservation management system, the user terminal is made to display a reservation status page in which a travel plan (commodity) which can be reserved, a number of rooms and the like are formed in a calendar format, and a user reservation is accepted.

  A manager (worker) who manages the reservation management system creates a reservation management table (data sheet) which constitutes the reservation status page. Specifically, the manager inputs data such as the available travel plan name and the number of rooms in each cell of the data sheet. For example, in the data sheet, the worker inputs "10" to the "weekday" and "plan A" cells as the number of available rooms, and "20" to the "holiday" and "plan B" cells. Enter The data sheet created by the administrator is displayed on the user terminal as a reservation status page.

  The data input operation performed by the worker in the data sheet is a common operation in various fields using the data sheet. In particular, if the number of input target cells is large, the input operation is a troublesome operation for the operator, and may cause an operator's input error.

  Therefore, it is conceivable to apply a technology (see, for example, Patent Document 1) of selecting a plurality of cells and collectively inputting desired data to the selected plurality of cells in the input operation of the data sheet. For example, the operator selects a plurality of adjacent cells, and inputs the same data to the selected plurality of cells at one time.

Japanese Patent Application Laid-Open No. 63-159977

  However, in the prior art, data is collectively input to all selected cells. For this reason, when there is a cell which does not require data input among the plurality of selected cells, the worker must cancel the selection of the cell which does not require input among the plurality of selected cells. It does not. In addition, there is a method in which the worker selects only the cells that need to be input. However, in this method, the worker must select the cells that need to be input while checking one by one. As described above, it is difficult to apply the conventional technology to various usage modes, and there is a problem that the work efficiency of the worker is reduced.

  An object of the present invention is to provide an information processing method, an information processing apparatus, and a program capable of improving work efficiency when inputting data in a data sheet.

  The information processing method according to the present invention includes a plurality of columns each including a plurality of cells and a plurality of rows each including a plurality of cells, and a tabular data sheet that enables editing of each of the cells. Identifying at least one column selected in step; identifying at least one row selected in the data sheet; and first cells at which the selected column intersects the selected row. And a step of identifying and allowing editing of the first cell among the plurality of cells included in each of the selected column and the selected row.

  An information processing apparatus according to the present invention includes a plurality of columns each including a plurality of cells and a plurality of rows each including a plurality of cells, and a tabular data sheet which enables editing of each of the cells. A column specifying unit specifying at least one column selected at step (d), a row specifying unit specifying at least one row selected in the data sheet, and the selected column and the selected row A cell identification unit for identifying a first cell, and a cell editing unit for permitting editing of the first cell among the plurality of cells included in each of the selected column and the selected row; Prepare.

  The program according to the present invention comprises a plurality of columns each including a plurality of cells and a plurality of rows each including a plurality of cells, and is selected in a tabular data sheet that enables editing of each of the cells. Identifying at least one column to be selected, identifying at least one row to be selected in the data sheet, and identifying a first cell where the selected column intersects the selected row The program is for causing a computer to execute steps and a step of permitting editing of the first cell among the plurality of cells included in each of the selected column and the selected row.

  According to the present invention, an information processing method, an information processing apparatus, and a program capable of improving the work efficiency when inputting data in a data sheet are provided.

FIG. 1 is a block diagram showing the configuration of an information processing system according to an embodiment of the present invention. FIG. 2 is a view showing an example of a data sheet used in the information processing system according to the embodiment of the present invention. FIG. 3 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 4 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 5 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 6 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 7 is a view showing an example of a data sheet page displayed on the facility terminal in the information processing system according to the embodiment of the present invention. FIG. 8 is a diagram showing an example of a reservation status page displayed on the user terminal in the information processing system according to the embodiment of the present invention. FIG. 9 is a view showing an example of a reservation status page displayed on the user terminal in the information processing system according to the embodiment of the present invention. FIG. 10 is a flowchart showing an example of the procedure of the data sheet editing process executed by the information processing apparatus in the information processing system according to the embodiment of the present invention. FIG. 11 is a view showing an example of a data sheet page displayed on the facility terminal in the information processing system according to the embodiment of the present invention. FIG. 12 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 13 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 14 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 15 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 16 is a view showing an example of a data sheet page displayed on a facility terminal in the information processing system according to the embodiment of the present invention. FIG. 17 is a view showing an example of a data sheet page displayed on the facility terminal in the information processing system according to the embodiment of the present invention.

  Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings for understanding of the present invention. The following embodiments are merely specific examples of the present invention, and do not limit the technical scope of the present invention.

[Information processing system 1]
An information processing system 1 according to an embodiment of the present invention includes a plurality of columns each including a plurality of cells (cells) and a plurality of rows each including a plurality of cells (cells). Applied to a system that controls editing of a tabular data sheet that enables editing. In the data sheet, for example, a plurality of cells are arranged in a column direction and a row direction (matrix), and data can be input to each cell, or data input to each cell can be deleted or changed. Table. Examples of the data sheet include so-called worksheets and spreadsheets.

  Column information and row information for specifying each cell are registered in the data sheet. Information corresponding to the field in which the data sheet is used is registered in the column information and the row information. For example, the data sheet may be a reservation management table in a reservation management system introduced to a travel company, an accommodation facility, a restaurant, a golf course, etc., a financial management table and an inventory management table in a management system introduced to a company Are used for various tables used in personal computers. For example, when the data sheet is used as a reservation management table indicating the reservation status of accommodation facilities, a plurality of dates (calendars) are registered as the column information, and a plurality of travel plans (the row information) The plan name (product name) of the sightseeing plan, room plan, meal plan, etc. is registered. In this case, the number of available rooms, the number of people, the number of sets, or the number of plans is input to each cell. The data input of each cell is performed by, for example, a manager (worker) of the accommodation facility. Moreover, when the said data sheet is utilized as a reservation management table showing the reservation status etc. of a restaurant, a plurality of dates (calendars) are registered as the column information, and courses of a plurality of dishes are registered as the row information. Name (product name) is registered. In this case, the number of people who can make a reservation is input to each cell. The data input of each cell is performed, for example, by a manager (worker) of the restaurant.

  In the following, as an example, a case where the data sheet is used as a reservation management table representing the reservation status and the like of the facility (particularly, an accommodation facility) will be described as an example. In this case, the information processing system 1 can be applied to the reservation management system.

  As shown in FIG. 1, an information processing system 1 according to an embodiment of the present invention includes an information processing apparatus 10, one or more facility terminals 20, and one or more user terminals 30. The information processing apparatus 10 and the facility terminal 20 can communicate via a communication network N1 such as the Internet, a LAN, a WAN, or a public telephone line. The same applies to the information processing apparatus 10 and the user terminal 30.

  In the information processing system 1, the facility terminal 20 is a device operated by a facility manager, and the user terminal 30 is a device operated by a user who uses the facility. The information processing apparatus 10 receives, for example, a reservation to be reserved in response to a request from the user, and manages a reservation status. Further, the information processing apparatus 10 creates or edits the data sheet constituting the reservation management page, for example, in response to a request from the administrator, and controls the display content of the data sheet. The facility terminal 20 is installed, for example, inside a facility (here, an accommodation facility). The information processing apparatus 10 may be installed inside the facility or may be installed outside the facility.

[Information processing apparatus 10]
The information processing apparatus 10 includes a communication I / F 110, an operation display unit 120, a storage unit 130, a control unit 140, and the like. The information processing apparatus 10 may be a single computer or a computer system in which a plurality of computers operate in cooperation with each other. Also, the functions of the information processing apparatus 10 may be realized by being distributed by a plurality of computers.

  The communication I / F 110 connects the information processing apparatus 10 to the communication network N1 by wire or wireless, and follows a predetermined communication protocol with external devices such as the facility terminal 20 and the user terminal 30 via the communication network N1. Communication interface for executing the data communication.

  The operation display unit 120 includes a display unit such as a liquid crystal display or an organic EL display that displays various types of information, and an operation unit such as a mouse, a keyboard, or a touch panel that receives an operation of an operator who operates the information processing apparatus 10. It is a user interface.

  The storage unit 130 is a non-volatile storage unit such as a hard disk drive (HDD) or a solid state drive (SSD) that stores various types of information. Specifically, the storage unit 130 is selected by the administrator as column information 131 which is item information of a column constituting the data sheet, row information 132 which is item information of a row which constitutes the data sheet, and Data such as selection information 133 which is column and row information and reservation information 134 indicating reservation status is stored. In the case of the reservation management system of the accommodation facility, for example, the column information 131 is information of date and time (calendar), and the row information 132 is information of plan name (or course name) of travel. The selection information 133 is, for example, position information (coordinate information) of columns and rows selected by the administrator.

  FIG. 2 is a view showing an example of the data sheet. The data sheet is generated by a data sheet generation unit 141 described later. As shown in FIG. 2, the data sheet DS includes a plurality of columns C1 each including a plurality of cells, and a plurality of rows R1 each including a plurality of cells. Column numbers "A", "B", "C", ... are attached to column C1, and row numbers "1", "2", "3", ... are attached to row R1. There is. When one column number and one row number are specified, one cell (hereinafter referred to as a crossing cell) where the corresponding column and row intersect is specified. For example, when the column number "K" and the row number "6" are specified, one crossing cell "K6" is specified. The data sheet DS includes, for example, a reservation management table S1 (also referred to as an input sheet S1). Date and day information (column information 131) is registered in the column item of the reservation management table S1 shown in FIG. 2, and plan name information (row information 132) is registered in the line item. In the data sheet DS, it is possible to switch between a plurality of input sheets S1. For example, although the input sheet S1 of "December" is shown in FIG. 2, when "January" of the sheet selection tab M1 in the lower section of the data sheet DS is selected, "December" is input. The sheet S1 is switched to an input sheet (not shown) of "January".

  The storage unit 130 also stores a control program such as a program (data sheet editing processing program) for causing the control unit 140 to execute a later-described data sheet editing processing (see FIG. 10). For example, the data sheet editing process program is non-temporarily recorded on a computer readable recording medium such as a CD or a DVD, and a reading device (not shown) such as a CD drive or a DVD drive included in the information processing apparatus 10 Are read and stored in the storage unit 130.

  The control unit 140 includes control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which control programs such as a BIOS and an OS for causing the CPU to execute various kinds of arithmetic processing are stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (work area) of various types of processing executed by the CPU. Then, the control unit 140 controls the information processing apparatus 10 by causing the CPU to execute various control programs stored in advance in the ROM or the storage unit 130.

  By the way, in general, in a reservation management system that receives reservations for accommodation facilities, a manager of the accommodation facilities determines in advance the number of rooms that can be reserved for each day or each day of the week for each of a plurality of travel plans. At this time, the administrator selects a plurality of cells and collectively inputs the same numerical value in the data sheet DS (see FIG. 2) or selects a cell one by one to input a numerical value. This input operation is a troublesome operation for the administrator, and may cause input errors. On the other hand, in the information processing system 1 according to the present embodiment, it is possible to improve the work efficiency when inputting data such as numerical values to the data sheet DS by the configuration and operation as described below. .

  Specifically, as shown in FIG. 1, the control unit 140 includes a data sheet generation unit 141, a column selection range specification unit 142, a row selection range specification unit 143, an intersection cell specification unit 144, a cell editing processing unit 145, and display processing. It includes various processing units such as the unit 146 and the reservation processing unit 147. The control unit 140 functions as the processing unit by executing various processing according to the data sheet editing processing program by the CPU. In addition, part or all of the processing units may be configured by an electronic circuit. Note that the data sheet editing processing program may be a program for causing a plurality of processors to function as the processing unit, and may be, for example, a collection of a plurality of program modules.

  In response to a request from the facility terminal 20 or the user terminal 30, the data sheet generation unit 141 generates a data sheet DS (see FIG. 2) including the input sheet S1. For example, when the administrator of the facility terminal 20 instructs the generation of the data sheet DS, the data sheet generation unit 141 receives the column information 131 and the row information 132 (item information) of the storage unit 130 according to the generation instruction. Acquire and generate a data sheet DS (see FIG. 2).

  The display processing unit 146 displays the data sheet page DP (see FIG. 3) including the data sheet DS generated by the data sheet generation unit 141 and an operation area for the administrator to edit the data sheet DS. The data is generated and transmitted to the facility terminal 20. The display data is, for example, an HTML document of the data sheet page DP. When the facility terminal 20 receives the display data (HTML document) from the information processing apparatus 10, based on the HTML document, for example, the web page of the data sheet page DP (reservation management page) shown in FIG. It is displayed on the display unit 220.

  In the data sheet page DP shown in FIG. 3, in the operation area, an edit month column P1, an input column P2, a "confirm" button P3, a "clear" button P4, a "return" button P5, an "end" button P6, , Sheet selection tab M1 is included. The "month" corresponding to the sheet selection tab M1 is displayed in the editing month column P1. When the administrator selects “December” of the sheet selection tab M1, the “December” data sheet page DP shown in FIG. 3 is displayed.

  The column selection range specification unit 142 (column specification unit) acquires information (column selection information) of at least one column C1 selected in the data sheet DS by the manager of the facility terminal 20, and specifies the column C1. Do. For example, when the administrator selects the column C1 of "Saturday" and "Sunday" of "December" in the data sheet DS shown in FIG. 3 (see FIG. 4), the column selection range specification unit 142 selects "December 2nd (Sat), "December 3rd (Sun)", "December 9th (Sat)", "December 10th (Sun)", "December 16th (Sat)", "December 17th (Sun), "December 23 (Sat)", "December 24 (Sun)", "December 30 (Sat)", "December 31 (Sun)" as column C1 , “D”, “E”, “K”, “L”, “R”, “S”, “Y”, “Z”, “AF”, “AG” are identified. The column selection range specification unit 142 stores the column selection information as the selection information 133 in the storage unit 130. The column selection information may be position information (coordinate information) of a column in the data sheet DS.

  The row selection range specification unit 143 (row specification unit) acquires information (row selection information) of at least one row R1 selected in the data sheet DS by the manager of the facility terminal 20, and specifies the row R1. Do. For example, when the administrator selects row R1 of "plan B" and "plan D" in the data sheet DS shown in FIG. 3 (see FIG. 5), the row selection range specification unit 143 selects "plan B" and "plan B" "6" and "8" are specified as row R1 of plan D ". The row selection range specification unit 143 stores the row selection information as the selection information 133 in the storage unit 130. The row selection information may be position information (coordinate information) of a row in the data sheet DS.

  The intersection cell identification unit 144 determines, based on the selection information 133 of the storage unit 130, the intersection cell (first cell) at which the column C1 and the row R1 selected in the data sheet DS by the administrator of the facility terminal 20 intersect. Identify. In the example illustrated in FIG. 5, the crossing cell identification unit 144 sets “D6”, “E6”, “K6”, “L6”, “R6”, “S6”, “Y6”, “Z6” as the crossing cells. , "AF6", "AG6", "D8", "E8", "K8", "L8", "R8", "S8", "Y8", "Z8", "AF8", "AG8" Do.

  The cell editing processing unit 145 permits editing at the facility terminal 20 for the crossing cell among the plurality of cells included in each of the column C1 and the row R1 selected in the data sheet DS by the manager of the facility terminal 20 And prohibits editing at the facility terminal 20 with respect to non-intersecting cells (second cells) excluding the intersecting cells. In the example illustrated in FIG. 5, the cell editing processing unit 145 selects “D6”, “E6”, “K6”, “L6”, “R6”, “S6”, “Y6”, “Z6”, and so on of the intersection cells. Facility terminal for "AF6", "AG6", "D8", "E8", "K8", "L8", "R8", "S8", "Y8", "Z8", "AF8", "AG8" 20 allow editing at 20 and prohibit editing at the facility terminal 20 for the other non-intersecting cells. In addition to the input, deletion, and change of data, the cell display mode (frame color, frame size, background color, background pattern) setting and change, and input data display, as well as data editing. It includes setting and changing of aspects (character color, size, font, style, decoration, etc.).

  When editing of the intersection cell is permitted, the manager of the facility terminal 20 can edit the data sheet DS. For example, the manager of the facility terminal 20 can make data “5” (for example, reservation possible) in any one of the plurality of crossing cells (for example, crossing cell “D6”) in the data sheet DS in FIG. When the number of rooms) is input, the cell editing processing unit 145 acquires the input data (input data), and inputs “5” of the input data to each intersection cell. The display processing unit 146 generates display data of the data sheet page DP including the data sheet DS in which the input data is input, and transmits the display data to the facility terminal 20. As a result, as shown in FIG. 7, the data sheet page DP in which the input data is input to each intersection cell is displayed on the operation display unit 220 of the facility terminal 20.

  When data is input to any one of the crossing cells by the manager of the facility terminal 20, the data sheet page DP to which the input data is input is temporarily displayed on the facility terminal 20, and thereafter, the manager When the “confirm” button P3 is selected, the cell editing processing unit 145 may confirm (store) the input processing.

  The reservation processing unit 147 receives a request from the user and performs facility reservation and management of reservation status (reservation management processing). In addition, since the well-known process can be applied to the reservation management process executed by the information processing apparatus 10, the detailed description will be omitted.

  Specifically, the reservation processing unit 147 generates the initially set reservation status page (see FIG. 8) based on the data sheet page DP generated by the cell editing processing unit 145. The reservation status page is a table (reservation management table) listing the reservation status. For example, the reservation processing unit 147 generates display data of the reservation status page in response to a request from the user of the user terminal 30, and transmits the display data to the user terminal 30. Data “5” of the reservation status page shown in FIG. 8 is a value input (set) by the manager of the facility terminal 20 (see FIG. 7). The data “○” of the reservation status page may be input (set) by the manager of the facility terminal 20 or may be input by the reservation processing unit 147. In FIG. 8, for example, it is shown that the quantity which can provide "plan B" and "plan D" to a user on Saturday and Sunday of December is limited to five. The other "o" plans indicate that the quantity available to the user is large or unlimited.

  The display content of the reservation status page is updated according to the user's reservation operation. Specifically, when the user selects “Plan D” on “December 10” in the reservation status page shown in FIG. 8 and performs a reservation operation, the reservation processing unit 147 selects the reservation status page. Update "5" to "Remaining 4". FIG. 9 shows a reservation status page updated by accepting reservations from a plurality of users. In the reservation status page shown in FIG. 9, for example, "○" is displayed when the number of possible reservations is equal to or more than the first threshold, and "△" when the number of possible reservations is more than the second threshold and less than the first threshold (however, 2 threshold is displayed <first threshold), “remaining n” (n is an integer) is displayed when the number of available reservations is 1 or more and less than the second threshold, “×” (cross) is the available number of available reservations “0 Is displayed in the case of

  Thus, the reservation processing unit 147 creates the reservation status page or updates the reservation status according to the operation of the user. The reservation processing unit 147 transmits display data of the updated reservation status page to the facility terminal 20 when the reservation status page is updated so that the facility manager can grasp the reservation status.

[Facility terminal 20]
As shown in FIG. 1, the facility terminal 20 includes a communication I / F 210, an operation display unit 220, a storage unit 230, a control unit 240, and the like. The facility terminal 20 is, for example, a device such as a mobile phone, a smartphone, a tablet terminal, or a personal computer.

  Specifically, the manager of the facility (accommodation facility) logs in to the information processing apparatus 10 by inputting the user ID and password (login operation) on the predetermined login page displayed on the facility terminal 20, and It instructs to generate the data sheet page DP (reservation management page) of the accommodation facility, and accesses the generated data sheet page DP.

  In addition, the administrator performs an operation of selecting one or more columns C1 and one or more rows R1 in the process of generating the data sheet page DP. Here, in the data sheet page DP, it is possible for the administrator to select all the cells included in the column of the column number (collective selection) by selecting the column number (for example, click operation with a mouse). The administrator can select all the cells included in the row of the row number (batch selection) by selecting the row number (for example, clicking operation with a mouse). Note that the administrator may manually select desired cells in columns and rows.

  Also, the administrator performs the editing (data input, etc.) operation on the intersection cell (first cell) where the selected column C1 and row R1 intersect. For example, the administrator selects the column items (date and day of the week) and the row items (travel plan name) constituting the data sheet DS (input sheet S1), and sets the number of available rooms. .

  The communication I / F 210 connects the facility terminal 20 to the communication network N1 by wire or wirelessly, and executes data communication according to a predetermined communication protocol with an external device such as the information processing apparatus 10 via the communication network N1. Is a communication interface to

  The operation display unit 220 is a display unit such as a liquid crystal display or an organic EL display that displays information such as various web pages, and an operation unit such as a mouse, a keyboard, or a touch panel that receives an operation of a manager operating the facility terminal 20 And a user interface.

  The storage unit 230 is a non-volatile storage unit such as a hard disk drive (HDD), a solid state drive (SSD), or a flash memory that stores various types of information. For example, the storage unit 230 stores a control program such as a browser program. Specifically, the browser program is a control program for causing the control unit 240 to execute communication processing with an external apparatus such as the information processing apparatus 10 according to a communication protocol such as HTTP (Hypertext Transfer Protocol).

  The control unit 240 includes control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which a control program such as a BIOS and an OS for causing the CPU to execute various processes is stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (work area) of various types of processing executed by the CPU. Then, the control unit 240 controls the facility terminal 20 by causing the CPU to execute various control programs stored in advance in the ROM or the storage unit 230.

  Specifically, the control unit 240 functions as a browser processing unit 241 by executing various processes in accordance with the browser program stored in the storage unit 230. The browser processing unit 241 causes the operation display unit 220 to display a web page (such as a data sheet page DP) provided from the information processing apparatus 10 via the communication network N1, and causes the information processing apparatus 10 to operate the operation display unit 220. It is possible to execute input browser processing. A part or all of the processing units included in the control unit 240 may be configured by an electronic circuit.

[User terminal 30]
As shown in FIG. 1, the user terminal 30 includes a communication I / F 310, an operation display unit 320, a storage unit 330, a control unit 340, and the like. The user terminal 30 is an apparatus such as a mobile phone, a smartphone, a tablet terminal, or a personal computer, for example.

  Specifically, the user of the facility (accommodation facility) acquires the display data of the reservation status page as shown in FIG. 8 or 9 from the information processing apparatus 10 by inputting a predetermined URL in the user terminal 30. Then, the reservation status page is displayed on the operation display unit 320. Then, the user of the accommodation facility can apply for a reservation by selecting a field that matches the desired date and time and plan name. For example, the user selects one of “O”, “Δ”, and “remaining n” of the reservation status page.

  The communication I / F 310 connects the user terminal 30 to the communication network N1 by wire or wirelessly, and performs data communication according to a predetermined communication protocol with an external device such as the information processing apparatus 10 via the communication network N1. It is a communication interface to execute.

  The operation display unit 320 is a user interface including a display unit such as a liquid crystal display or an organic EL display that displays information such as various web pages, and an operation unit such as a mouse, a keyboard, or a touch panel that receives an operation.

  The storage unit 330 is a non-volatile storage unit such as a hard disk drive (HDD), a solid state drive (SSD), or a flash memory that stores various types of information. For example, the storage unit 330 stores a control program such as a browser program. Specifically, the browser program is a control program for causing the control unit 340 to execute communication processing with an external apparatus such as the information processing apparatus 10 according to a communication protocol such as HTTP (Hypertext Transfer Protocol).

  The control unit 340 includes control devices such as a CPU, a ROM, and a RAM. The CPU is a processor that executes various arithmetic processes. The ROM is a non-volatile storage unit in which a control program such as a BIOS and an OS for causing the CPU to execute various processes is stored in advance. The RAM is a volatile or non-volatile storage unit that stores various types of information, and is used as a temporary storage memory (work area) of various types of processing executed by the CPU. Then, the control unit 340 controls the user terminal 30 by causing the CPU to execute various control programs stored in advance in the ROM or the storage unit 330.

  Specifically, the control unit 340 functions as a browser processing unit 341 by executing various processes in accordance with the browser program stored in the storage unit 330. The browser processing unit 341 causes the operation display unit 320 to display a web page (such as a reservation status page) provided from the information processing apparatus 10 via the communication network N1, and inputs an operation on the operation display unit 320 into the information processing apparatus 10. Browser processing can be performed. A part or all of the processing units included in the control unit 340 may be configured by an electronic circuit.

[Datasheet Editing Process]
Hereinafter, an example of a data sheet editing process performed by the control unit 140 of the information processing device 10 will be described with reference to FIG.

<Step S11>
First, in step S11, in response to a request from the facility terminal 20, the data sheet generation unit 141 generates a data sheet DS (see FIG. 2) including the input sheet S1. For example, when the manager of the facility terminal 20 selects the items (date and day of the week, travel plan name) of the columns and rows of the input sheet S1, the data sheet generating unit 141 displays the column information 131 of the storage unit 130 (date And the day information and row information 132 (plan name) to obtain a data sheet DS (see FIG. 2).

<Step S12>
In step S12, the display processing unit 146 transmits display data of the data sheet page DP (see FIG. 3) including the data sheet DS generated by the data sheet generation unit 141 to the facility terminal 20.

  When the facility terminal 20 receives the display data from the information processing apparatus 10, the facility terminal 20 displays a data sheet page DP (reservation management page) according to the display data on the operation display unit 220, and receives an operation from the administrator. The administrator performs an operation of selecting a desired column and row, for example, in the data sheet DS. The facility terminal 20 transmits information (selection information) corresponding to the operation of the administrator to the information processing apparatus 10.

<Step S13>
In step S13, the column selection range specification unit 142 acquires operation information (selection information) by the administrator from the facility terminal 20. Specifically, the column selection range specification unit 142 acquires information (column selection information) of the column C1 selected by the administrator in the data sheet DS. Here, it is assumed that the administrator selects the column C1 of "Saturday" and "Sunday" of "December" as shown in FIG. The column selection range specification unit 142 stands by until the column selection information is acquired from the facility terminal 20 (S13: NO).

<Step S14>
In step S14, the column selection range specification unit 142 specifies the column C1 selected by the administrator based on the acquired column selection information. Here, the column selection range specification unit 142 sets “D”, “E”, “K”, “L”, “R”, “S”, “S”, “Y”, “Z”, “AF” as the column C1. , "AG" to identify.

<Step S15>
In step S <b> 15, the row selection range specification unit 143 acquires operation information (selection information) by the administrator from the facility terminal 20. Specifically, the row selection range specification unit 143 acquires information (row selection information) of the row R1 selected by the administrator in the data sheet DS. Here, it is assumed that the administrator selects a row R1 of "plan B" and "plan D" as shown in FIG. The row selection range specification unit 143 stands by until the row selection information is acquired from the facility terminal 20 (S15: NO).

<Step S16>
In step S16, the row selection range specification unit 143 specifies the row R1 selected by the administrator based on the acquired row selection information. Here, the row selection range specification unit 143 specifies “6” and “8” as the row R1.

<Step S17>
In step S17, the intersecting cell identification unit 144 identifies an intersecting cell (first cell) at which the column C1 and the row R1 selected (identified) in the data sheet DS intersect. Here, as shown in FIG. 5, the crossing cell identification unit 144 sets “D6”, “E6”, “K6”, “L6”, “R6”, “S6”, “Y6”, as the crossing cells. "Z6", "AF6", "AG6", "D8", "E8", "K8", "L8", "R8", "S8", "Y8", "Z8", "AF8", "AG8" Identify ".

<Step S18>
In step S18, the cell editing processing unit 145 permits the facility terminal 20 to edit the intersection cell among the plurality of cells included in each of the column C1 and the row R1 selected (specified) in the data sheet DS. And a process of prohibiting editing at the facility terminal 20 with respect to non-intersecting cells excluding the intersecting cells.

  When the editing of the intersection cell is permitted, the cell editing processing unit 145 receives an editing operation from the facility terminal 20. The facility terminal 20 receives an editing operation on the data sheet page DP from the administrator. For example, as shown in FIG. 6, the administrator uses data sheet DS to input data (for example, the number of reservables “5”) to be input to the plurality of crossing cells, any of the plurality of crossing cells. Input to one or the other (for example, crossing cell "D6"). The facility terminal 20 transmits information (input data) corresponding to the operation of the administrator to the information processing apparatus 10.

<Step S19>
In step S19, the cell editing processing unit 145 acquires information (input data) corresponding to the operation of the administrator from the facility terminal 20.

<Step S20>
In step S20, the cell editing processing unit 145 inputs (edits) (reflects) the acquired input data in each intersection cell of the data sheet DS. Here, as shown in FIG. 7, the cell editing processing unit 145 sets “D6”, “E6”, “K6”, “L6”, “R6”, “S6”, “Y6”, “Z6”, Input data to AF6 "," AG6 "," D8 "," E8 "," K8 "," L8 "," R8 "," S8 "," Y8 "," Z8 "," AF8 "," AG8 " Enter "5" of at once. That is, the cell editing processing unit 145 collectively edits a plurality of crossing cells into the same content ("5"). In addition, the cell editing processing unit 145 does not perform input processing of input data and other editing processing for non-intersecting cells. That is, the cell editing processing unit 145 does not receive the editing operation of the administrator on the non-intersecting cell.

<Step S21>
In step S21, the display processing unit 146 generates display data of the data sheet page DP (see FIG. 7) including the data sheet DS in which the input data is input, and transmits the display data to the facility terminal 20.

  When the facility terminal 20 receives the display data from the information processing apparatus 10, the facility terminal 20 displays a data sheet page DP (reservation management page) according to the display data on the operation display unit 220, and receives an operation from the administrator.

<Step S22>
In step S22, when the control unit 140 acquires the end of the editing process from the facility terminal 20, the control unit 140 ends the data sheet editing process (S22: YES). For example, when the manager of the facility terminal 20 selects the “end” button P6 in the data sheet DS, the control unit 140 ends the data sheet editing process.

  On the other hand, when the administrator does not select the “end” button P6 (S22: NO), and the other column C1 is selected (S13), the control unit 140 executes the processing of S13 and thereafter again. Thus, the data sheet editing process is repeated.

  In the process example described above, the administrator of the facility terminal 20 selects the row R1 after selecting the column C1, but the administrator may select the column C1 after selecting the row R1. . Therefore, in the process example described above, the processes of S13 and S14 and the processes of S15 and S16 may be reversed.

  As described above, in the information processing apparatus 10 according to the present embodiment, it is possible to edit an intersection cell where a column and a row selected by a worker (administrator) intersect, and is included in the selected column and row Prohibit editing of non-intersecting cells. This allows the worker to input (edit) desired data only in cells intersecting by the selected column and row. Also, for example, even in the case where there is a cell in which the input of data is unnecessary among the plurality of cells included in the selected column and row, the worker does not need to input the plurality of selected cells. There is no need to deselect the cell. Furthermore, since the cell to which data is to be input can be reliably selected, input errors can be suppressed. Therefore, the work efficiency at the time of inputting data to the data sheet DS can be improved.

[Modification]
Although the case where a plurality of columns C1 and a plurality of rows R1 are selected by the manager of the facility terminal 20 is shown in the example described above, one column C1 and one row R1 may be selected by the manager. FIG. 11 shows a state in which the column “V” and the row “5” are selected by the administrator in the data sheet page DP. In this case, the crossing cell identification unit 144 identifies one cell “V5” as the crossing cell. Then, the cell editing processing unit 145 causes the facility terminal 20 to execute the intersection cell “V5” among the plurality of cells included in each of the column “V” and the row “5” selected (specified) in the data sheet DS. Editing is permitted, and processing is performed to prohibit editing at the facility terminal 20 with respect to non-crossing cells other than the crossing cell "V5".

  Moreover, the data which the management of the facility terminal 20 inputs to the crossing cell may be characters or symbols without being limited to numerical values. For example, in the data sheet page DP shown in FIG. 11, when the administrator inputs “x” (cross) as input data, the cell editing processing unit 145 receives input data “cross” (cross) acquired from the facility terminal 20. In the intersection cell "V5" of the data sheet DS. As a result, as shown in FIG. 12, an “x” (cross) is displayed on the intersection cell “V5” of the data sheet page DP.

  Further, the method of the manager of the facility terminal 20 to input data to the intersection cell is not limited to the method of directly inputting to any one of the plurality of intersection cells (see FIG. 6). For example, as shown in FIG. 13, even if the administrator inputs data (for example, “5”) (input data) to be input to the plurality of crossing cells in the data sheet page DP, in the input column P2. Good. In this case, the cell editing processing unit 145 acquires the input data from the facility terminal 20, and inputs (edits) the acquired input data into each intersection cell of the data sheet DS. As a result, as shown in FIG. 7, the data sheet page DP in which the input data is input to each intersection cell is displayed on the operation display unit 220 of the facility terminal 20. Moreover, as shown in FIG. 14, the administrator of the facility terminal 20 may select from the pull-down menu in the input field P2.

  Further, in the above-described example, the same content (for example, “5”) as the data input to the intersection cell by the administrator of the facility terminal 20 is displayed in the intersection cell, but the present invention is limited thereto I will not. The cell editing processing unit 145 may cause the intersection cell to input and display the content based on the data input (set) to the intersection cell by the administrator of the facility terminal 20. For example, FIG. 15 shows a data sheet page DP including a data sheet DS in which date and day information are registered in column items of the input sheet S1 and plan name and amount information are registered in row items. . In the data sheet page DP shown in FIG. 15, when the manager of the facility terminal 20 inputs "+3000 yen" in the input field P2, the intersection cell of the data sheet DS (for example, "Plan D", "Plan E" Saturday And the amount of money on Sunday) is switched (updated) from “10000 (yen)” and “8000 (yen)” set initially to “13000 (yen)” and “11000 (yen)” respectively. Further, in the data sheet page DP shown in FIG. 15, when the manager of the facility terminal 20 inputs “+ 20%” in the input field P2, crossing cells of the data sheet DS (for example, “plan D”, “plan E”) (Saturday and Sunday) is switched from “10000 (yen)” and “8000 (yen)” initially set to “12000 (yen)” to “9600 (yen)” (updated) (updated) Not shown). As described above, the cell editing processing unit 145 inputs the amount of money (for example, “10000 yen”) registered (initially set) in the intersection cell into the amount of money input by the administrator (“10000 yen”) The amount obtained by adding "3000 yen" ("13000 yen") is updated to the amount obtained by subtracting the input amount ("3000 yen") from the amount ("10000 yen") ("7000 yen"). In addition, the cell editing processing unit 145 inputs the amount (“10000 yen”) registered in the intersection cell to the input rate (“+ 20%” or “−20”) input by the administrator to the amount (“10000 yen”). Update to the amount (“12000 yen” or “8000 yen”) according to%) That is, the cell editing processing unit 145 may change the respective values input to the plurality of crossing cells based on the input data (parameters) input by the administrator. The input operation of the data ("+3000 yen or the like") may be a method of direct input to any one of the plurality of crossing cells.

  In addition, the cell editing processing unit 145 may cause the facility terminal 20 to display the column C1 selected by the administrator, the row R1, and the crossing cell in different display modes. The display mode is, for example, the color of the frame of the cell, the size of the frame, the color of the background, and the pattern of the background. For example, the cell editing processing unit 145 may cause the facility terminal 20 to display the non-crossing cells and the crossing cells in different colors or background patterns (see FIG. 16). In addition, the cell editing processing unit 145 causes the facility terminal 20 to display the non-crossing cells included in the column C1 and the non-crossing cells included in the row R1 in the same color (first color), The intersection cell may be displayed on the facility terminal 20 in a color different from the color (second color). The cell editing processing unit 145 may change the color of the crossing cell to the color of the non-crossing cell when the editing of the crossing cell is completed.

  Further, as shown in FIG. 17, the cell editing processing unit 145 may calculate the number (selection number) of the crossing cells, and display the calculated number on the data sheet page DP. As a result, the manager of the facility terminal 20 can grasp the number of the crossing cells to be input by itself. In this case, each time the administrator inputs data to the intersection cell, the number may be subtracted and displayed.

  In addition, when there are a plurality of crossing cells, the cell editing processing unit 145 may receive input operations to the crossing cells of the administrator in a predetermined order (individually). For example, the cell editing processing unit 145 may receive the input of the intersection cell in the order of the numbers in the column C1 and in the order of the numbers in the row R1. Specifically, in the data sheet page DP shown in FIG. 5, the cell editing processing unit 145 selects “D6”, “E6”, “K6”, “L6”, “R6”, “S6”, “Y6”, "Z6", "AF6", "AG6", "D8", "E8", "K8", "L8", "R8", "S8", "Y8", "Z8", "AF8", "AG8" Accept data input in the order of In this case, it is preferable that the cell editing processing unit 145 make the display mode of the intersection cell different from that of other cells so that the administrator can easily grasp the intersection cell currently receiving input. A configuration example for realizing the above input operation will be described below.

  For example, in the case of inputting data in order (individually) to the plurality of crossing cells, the administrator performs an operation of switching the input mode. Specifically, when the administrator presses a predetermined key (for example, "CTRL" key) of the keyboard of the operation display unit 220 of the facility terminal 20, the mode is switched to an input mode in which data is sequentially input to each intersection cell. For example, when the administrator inputs data to a specific intersection cell ("D6") while pressing the predetermined key ("CTRL" key), the cell editing processing unit 145 inputs the data to the intersection cell "D6". Input data is acquired, and the acquired input data is reflected (inputted) on the intersection cell "D6". When the input data is input to the intersection cell "D6", editing of the next intersection cell "E6" becomes possible, and the administrator presses the predetermined key ("CTRL" key) and the intersection cell " Input data to E6 ". The cell editing processing unit 145 acquires input data input to the intersection cell “E6”, and reflects (inputs) the acquired input data to the intersection cell “E6”. In this manner, data can be input and displayed in order (individual) on the plurality of crossing cells. Further, in the above configuration, the same or different data can be input to the plurality of crossing cells. The administrator may directly input data to the plurality of crossing cells in order or may sequentially input data to the input field P2.

  As described above, when there are a plurality of crossing cells, the cell editing processing unit 145 may cause the plurality of crossing cells to input and display the same content value, or input and display different values from one another. It is also good.

  The information processing apparatus 10 may be installed, for example, in a facility and function as the facility terminal 20. Further, each processing unit of the control unit 140 of the information processing apparatus 10 may be included in the control unit 240 of the facility terminal 20. In this case, the storage unit 230 of the facility terminal 20 stores a control program such as an application program (data sheet editing process program) for causing the control unit 240 to execute the data sheet editing process (see FIG. 10).

  For example, the application program corresponding to the data sheet editing process by the control unit 140 of the information processing apparatus 10 may be installed in the facility terminal 20. The application program is a control program (data sheet editing processing program) for causing the control unit 240 of the facility terminal 20 to execute the data sheet editing processing. The control unit 240 functions as each processing unit by executing various processing according to the application program by the CPU.

  Specifically, the manager of the facility terminal 20 activates an application of the facility terminal 20 to execute a login operation. When the login operation is completed, the control unit 240 causes the operation display unit 220 of the facility terminal 20 to display a data sheet page DP (see FIG. 5) including the initialized data sheet DS (calendar format). Thereafter, the control unit 240 receives an operation of the administrator (selection of columns and rows, data input to crossing cells, etc.). Then, the control unit 240 acquires input data input to the intersection cell, and displays on the operation display unit 220 a data sheet page DP (see FIG. 7) in which the acquired input data is input (reflected). The control unit 240 may execute a process (S11 shown in FIG. 10) of generating the data sheet DS (for example, calendar format) when the administrator executes the login operation.

[Supplementary Note of the Invention]
Hereinafter, the summary of the invention extracted from the above-described embodiment will be additionally stated. The configurations and the processing functions described in the following appendices can be arbitrarily selected and combined.

<Supplementary Note 1>
At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell Identifying steps,
Identifying at least one row selected in the data sheet;
Identifying a first cell where the selected column and the selected row intersect;
Allowing editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
Information processing method including:

<Supplementary Note 2>
When there are a plurality of first cells, batch editing the plurality of first cells,
The information processing method according to appendix 1.

<Supplementary Note 3>
Further including the step of acquiring input data;
When there are a plurality of first cells, the plurality of first cells are collectively edited to the same content based on the acquired input data.
The information processing method according to appendix 2.

<Supplementary Note 4>
Further including the step of acquiring input data;
Changing respective values input to the plurality of first cells based on the acquired input data;
The information processing method according to appendix 2.

<Supplementary Note 5>
Obtaining input data;
Displaying a content based on the acquired input data on a display unit;
Finalizing the input of the content to the first cell when acquiring an operation for determining the content from the user;
The information processing method according to any one of appendices 1 to 4, further comprising

<Supplementary Note 6>
The data sheet is a data sheet for managing the quantity of a predetermined product for a predetermined date and time,
Information of the date and time is registered in one item of the plurality of columns and the plurality of rows, and information of the product is registered in the other of the plurality of columns and the plurality of rows.
Allow editing of the quantity of the product in the first cell,
The information processing method according to any one of appendices 1 to 5.

<Supplementary Note 7>
The data sheet is a data sheet for managing the price of a predetermined product.
Information on the product is registered in one of the plurality of columns and one item of the plurality of rows, and the amount of the product is registered in the plurality of cells.
Further including the step of obtaining an input amount,
The amount of the product registered in the first cell is updated to the amount obtained by adding the acquired input amount to the amount or the amount obtained by subtracting the input amount obtained from the amount.
The information processing method according to any one of appendices 1 to 5.

<Supplementary Note 8>
The data sheet is a data sheet for managing the price of a predetermined product.
Information on the product is registered in one of the plurality of columns and one item of the plurality of rows, and the amount of the product is registered in the plurality of cells.
Further including the step of obtaining the input rate,
Updating the amount of the product registered in the first cell to an amount according to the input ratio;
The information processing method according to any one of appendices 1 to 5.

<Supplementary Note 9>
Displaying the first cell and the second cell in a display mode different from each other.
The information processing method according to any one of appendices 1 to 8.

<Supplementary Note 10>
Displaying the first cell and the second cell on the display unit in different colors;
The information processing method according to appendix 9.

<Supplementary Note 11>
The second cell included in the selected column and the second cell included in the selected row are displayed on the display unit in a first color, and the first cell is displayed as the first color. Further comprising displaying on the display in a second different color,
The information processing method according to any one of appendices 1 to 8.

<Supplementary Note 12>
When editing of the first cell is finished, the color of the first cell is changed to the color of the selected column or the selected row.
The information processing method according to appendix 10 or 11.

<Supplementary Note 13>
And displaying the number of first cells on a display unit.
The information processing method according to any one of appendices 1 to 11.

<Supplementary Note 14>
At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell A column identification unit to identify,
A row identification unit that identifies at least one row selected in the data sheet;
A cell identification unit that identifies a first cell at which the selected column and the selected row intersect;
A cell editing processing unit which permits editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
An information processing apparatus comprising:

<Supplementary Note 15>
At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell Identifying steps,
Identifying at least one row selected in the data sheet;
Identifying a first cell where the selected column and the selected row intersect;
Allowing editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
A program to make a computer run.

1 information processing system 10 information processing apparatus 110 communication I / F
120 operation display unit 130 storage unit 131 column information 132 row information 133 selection information 134 reservation information 140 control unit 141 data sheet generation unit 142 column selection range specification unit 143 row selection range specification unit 144 intersection cell specification unit 145 cell edit processing unit 146 Display processing unit 147 Reservation processing unit 20 Facility terminal 210 Communication I / F
220 operation display unit 230 storage unit 240 control unit 241 browser processing unit 30 user terminal 310 communication I / F
320 operation display unit 330 storage unit 340 control unit 341 browser processing unit

Claims (15)

At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell Identifying steps,
Identifying at least one row selected in the data sheet;
Identifying a first cell where the selected column and the selected row intersect;
Allowing editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
Information processing method including: When there are a plurality of first cells, batch editing the plurality of first cells,
The information processing method according to claim 1. Further including the step of acquiring input data;
When there are a plurality of first cells, the plurality of first cells are collectively edited to the same content based on the acquired input data.
The information processing method according to claim 2. Further including the step of acquiring input data;
Changing respective values input to the plurality of first cells based on the acquired input data;
The information processing method according to claim 2. Obtaining input data;
Displaying a content based on the acquired input data on a display unit;
Finalizing the input of the content to the first cell when acquiring an operation for determining the content from the user;
The information processing method according to any one of claims 1 to 4, further comprising The data sheet is a data sheet for managing the quantity of a predetermined product for a predetermined date and time,
Information of the date and time is registered in one item of the plurality of columns and the plurality of rows, and information of the product is registered in the other of the plurality of columns and the plurality of rows.
Allow editing of the quantity of the product in the first cell,
The information processing method according to any one of claims 1 to 5. The data sheet is a data sheet for managing the price of a predetermined product.
Information on the product is registered in one of the plurality of columns and one item of the plurality of rows, and the amount of the product is registered in the plurality of cells.
Further including the step of obtaining an input amount,
The amount of the product registered in the first cell is updated to the amount obtained by adding the acquired input amount to the amount or the amount obtained by subtracting the input amount obtained from the amount.
The information processing method according to any one of claims 1 to 5. The data sheet is a data sheet for managing the price of a predetermined product.
Information on the product is registered in one of the plurality of columns and one item of the plurality of rows, and the amount of the product is registered in the plurality of cells.
Further including the step of obtaining the input rate,
Updating the amount of the product registered in the first cell to an amount according to the input ratio;
The information processing method according to any one of claims 1 to 5. Displaying the first cell and the second cell in a display mode different from each other.
The information processing method according to any one of claims 1 to 8. Displaying the first cell and the second cell on the display unit in different colors;
The information processing method according to claim 9. The second cell included in the selected column and the second cell included in the selected row are displayed on the display unit in a first color, and the first cell is displayed as the first color. Further comprising displaying on the display in a second different color,
The information processing method according to any one of claims 1 to 8. When editing of the first cell is finished, the color of the first cell is changed to the color of the selected column or the selected row.
The information processing method according to claim 10. And displaying the number of first cells on a display unit.
The information processing method according to any one of claims 1 to 11. At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell A column identification unit to identify,
A row identification unit that identifies at least one row selected in the data sheet;
A cell identification unit that identifies a first cell at which the selected column and the selected row intersect;
A cell editing processing unit which permits editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
An information processing apparatus comprising: At least one column selected in a tabular data sheet, comprising a plurality of columns each comprising a plurality of cells and a plurality of rows each comprising a plurality of cells, enabling editing of each said cell Identifying steps,
Identifying at least one row selected in the data sheet;
Identifying a first cell where the selected column and the selected row intersect;
Allowing editing of the first cell among the plurality of cells included in each of the selected column and the selected row;
A program to make a computer run.

Images