JP2018036880A - Information processing device and information processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information processing device that has a tag (except for the tag on which a processing result is described) attached on a mounting sheet as a processing object, and that enables outputting the processing result as the tag on the mounting sheet.SOLUTION: In an information processing device, identification means identifies a set to which a tag attached on a mounting sheet belongs, extraction means extracts a rule associated with the set identified, processing means extracts information associated with an attribute of the tag using the tag as an object according to the rule, and performs processing of the information, generation means generates the tag having a processing result by the processing means as content, and output means outputs the tag generated by the generation means on the mounting sheet, and the processing means does not have the tag generated by the generation means as the object for the processing.SELECTED DRAWING: Figure 1

Description

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

  In Patent Document 1, it is an object to display a result of adding up additional information added to information such as an electronic document in an easily viewable manner, and sticky note totaling information is displayed in a display area of the display unit. It consists of a sticky note frequency display area and a page display area where document pages are displayed. The sticky note frequency display area displays grayscale images according to the frequency level (that is, the number of sticky notes), that is, the frequency level. A dark image is displayed in a segment area with a large frequency, and a thin image is displayed in a segment area with a low frequency level.By browsing the frequency level of a tag in the immediate vicinity of the document in this way, the user can It is disclosed that it is possible to visually recognize which part of a page is noted by another user.

  Patent Document 2 has an object of enabling a calculation process for information included in a range by arbitrarily specifying a range, even for target data that does not have the concept of a cell in a spreadsheet application. The selection range information indicating the selection range in the form data and the calculation method designation information indicating the calculation method for the information belonging to the selection range of the form data are input, and the information and selection concerning the information arrangement in the form data are input. Based on the range information, it is disclosed that a numerical value in the form data belonging to the selected range is extracted, and the form server performs a calculation process of the calculation method indicated by the calculation method designation information on the extracted numerical value. ing.

  According to Patent Document 3, it is an object to change the display position of an electronic sticky note according to changes in the layout and structure of the content of a web page, and the electronic sticky note generation and display program designates the electronic sticky note pasting to a computer. A step of estimating the location most similar to the location where the electronic sticky note is pasted from the web page based on the location information indicating the location of the content of the web page, and the web so that the electronic sticky note is displayed at the estimated location. Rewriting the source of the page, wherein the location information includes the tag of the location of the content where the electronic sticky tag is pasted, the attribute, and the content in the tag, and the location where the electronic sticky tag is pasted It is disclosed that the place most similar to is the place where the number of matches of the tag, the attribute, and the content in the tag is the maximum.

  In Patent Document 4, the conventional information processing apparatus has a problem that the information indicated by the sticky note cannot be shared appropriately, and the display form designation receiving unit that receives the form identification information of the form and the display form designation receiving unit are accepted. A screen configuration unit that reads out the form information used for the form corresponding to the form identification information and the screen configuration information constituting the screen of the form from the information storage unit for the form and the screen configuration information storage unit, and configures the screen of the form; Placed on the form using the sticky information acquisition unit that acquires the sticky information associated with the form information corresponding to the form identification information received by the display form designation receiving unit from the sticky information storage unit, and the acquired sticky information It is disclosed that the apparatus includes a sticky note screen composing unit that constitutes a screen of a sticky note to be performed, a screen composing unit, and an output unit that outputs a screen composed of the sticky note screen composing unit.

  Patent Document 5 aims to provide a network system, a server device, and a groupware program that link various information between functions of groupware to improve user operability. Data associated with an object is stored in association with a window that is displayed in a superimposed manner, and all data associated with an image object is stored in a data item regardless of the data associated with the image object. When the image object on the first window is moved to the seat image on the seating chart window, the client device requests the server device to update the data attached to the image object, and the storage means , While inheriting the data attached to the image object, There in association with the user data and the message view window accompanying the seat image is moved or copied operation, be stored in the data item is disclosed.

JP 2008-181336 A Japanese Patent Laid-Open No. 2005-165542 Patent No. 5704508 JP 2009-093389 A JP 2011-164696A

In the technique described in the above-described Patent Document 1 or the like, an electronic sticky note (also referred to as an electronic card or the like; hereinafter simply referred to as a sticky note) is attached to a form or the like.
In addition, a system using sticky notes is provided for discussion and the like. As discussion using this system, for example, sticky notes filled with text, numbers, etc. are pasted on templates and frameworks prepared for discussion, and the character information and number information in the sticky notes are aggregated. Has been done.
However, it is not possible to extract information for a sticky note, perform processing equivalent to that of a spreadsheet application on the information, and synthesize the result of the processing on a mount and output it.
In view of this, the present invention is directed to an information processing apparatus that can process a sticky note (excluding a sticky note on which a processing result is written) pasted on a mount, and output the processing result as a sticky note on the mount. And an information processing program.

The gist of the present invention for achieving the object lies in the inventions of the following items.
The invention according to claim 1 is directed to specifying means for specifying a set to which a tag attached on a mount belongs, extraction means for extracting a rule related to the specified set, and subjecting the tag in accordance with the rule. Extracting information about the attribute of the sticky note, processing means for processing the information, generating means for generating a sticky note containing the processing result of the processing means, and the sticky note generated by the generating means The information processing apparatus includes an output unit configured to output on a mount, and the processing unit does not process the tag generated by the generation unit.

  According to a second aspect of the present invention, the specifying unit specifies a set to which the sticky note belongs by specifying a cell in the mount on which the sticky note is pasted from a position of the sticky note on a mount having a plurality of cells. The information processing apparatus according to claim 1.

  The invention according to claim 3 is the information processing apparatus according to claim 2, wherein the extraction means extracts a related rule from the position of the tag or the cell.

  The invention according to claim 4 is the information processing apparatus according to claim 1, wherein the extraction unit extracts a rule related to the set from a rule defined in the mount.

  The invention according to claim 5 further includes accepting means for accepting a rule defined on the displayed mount, and the extracting means extracts a rule related to the position from the rule accepted by the accepting means. The information processing apparatus according to any one of claims 1 to 4.

  According to a sixth aspect of the present invention, when the extraction unit extracts both a rule related to the cell and a rule related to the location, the processing unit preferentially applies the rule related to the location. 6. An information processing apparatus according to claim 5, which is dependent on claim 4.

  A seventh aspect of the present invention is the information processing apparatus according to any one of the first to sixth aspects, wherein the generating means performs numerical conversion as a generation of a sticky note indicating a processing result.

  According to the invention of claim 8, the computer is configured to identify a set to which a tag attached on a mount belongs, an extraction means to extract a rule related to the specified set, and the rule according to the rule. Information on the attribute of the sticky note is extracted for the sticky note, processing means for processing the information, generation means for generating a sticky note containing the processing result by the processing means, and the generation means generated by the generation means An information processing program that functions as output means for outputting a sticky note on the mount, and wherein the processing means does not process the sticky note generated by the generating means.

  According to the information processing apparatus of claim 1, a sticky note (excluding a sticky note on which a processing result is described) pasted on a mount is set as a processing target, and the processing result is output as a sticky on the mount.

  According to the information processing apparatus of the second aspect, it is possible to specify a set to which the sticky note belongs from a plurality of cells of the mount.

  According to the information processing apparatus of the third aspect, the processing is performed according to the rule related to the position of the tag or the cell.

  According to the information processing apparatus of the fourth aspect, processing is performed according to the rules defined in the mount.

  According to the information processing apparatus of the fifth aspect, the processing is performed according to the rules defined on the displayed mount.

  According to the information processing apparatus of the sixth aspect, when both the rule related to the cell and the rule related to the position are set, the rule related to the position is preferentially applied.

  According to the information processing apparatus of the seventh aspect, the numerical value is converted into a graphic as the generation of the sticky note indicating the processing result.

  According to the information processing program of claim 8, a sticky note (excluding a sticky note on which a processing result is described) pasted on a mount is set as a processing target, and the processing result is output as a sticky note on the mount.

It is a conceptual module block diagram about the structural example of 1st Embodiment. It is explanatory drawing which shows the system configuration example using this Embodiment. It is explanatory drawing which shows the usage example of a shared tag information processing apparatus and a tag information processing apparatus. It is explanatory drawing which shows the example of a process of display control. It is explanatory drawing which shows the related example of a spreadsheet processing module, an intermediate | middle layer processing module, and a tag processing module. It is a flowchart which shows the process example by 1st Embodiment. It is explanatory drawing which shows the process example by 1st Embodiment. It is explanatory drawing which shows the example of the rule defined within the spreadsheet. It is explanatory drawing which shows the example which affixed the tag to the spreadsheet. It is explanatory drawing which shows the example which displayed the process result. It is a flowchart which shows the process example by 1st Embodiment. It is explanatory drawing which shows the process example by 1st Embodiment. It is explanatory drawing which shows the example which displayed the process result. It is explanatory drawing which shows the example when a some sticky note is affixed in 1 cell. It is explanatory drawing which shows the example when a some sticky note is affixed in 1 cell. It is explanatory drawing which shows the example when a some sticky note is affixed in 1 cell. It is explanatory drawing which shows the example of a data structure of a tag information table. It is explanatory drawing which shows the example of a data structure of a base_sheet | cell table. It is a flowchart which shows the process example by 1st Embodiment. It is explanatory drawing which shows the process example by 1st Embodiment. It is explanatory drawing which shows the process example by 1st Embodiment. It is explanatory drawing which shows the process example by 1st Embodiment. It is a conceptual module block diagram about the structural example of 2nd Embodiment. It is a flowchart which shows the process example by 2nd Embodiment. It is explanatory drawing which shows the example of a data structure of a tag information table. It is explanatory drawing which shows the example of a data structure of a mount information table. It is a block diagram which shows the hardware structural example of the computer which implement | achieves this Embodiment.

Hereinafter, examples of various preferred embodiments for realizing the present invention will be described with reference to the drawings.
<First Embodiment>
FIG. 1 is a conceptual module configuration diagram of a configuration example according to the first embodiment.
The module generally refers to components such as software (computer program) and hardware that can be logically separated. Therefore, the module in the present embodiment indicates not only a module in a computer program but also a module in a hardware configuration. Therefore, the present embodiment is a computer program for causing these modules to function (a program for causing a computer to execute each procedure, a program for causing a computer to function as each means, and a function for each computer. This also serves as an explanation of the program and system and method for realizing the above. However, for the sake of explanation, the words “store”, “store”, and equivalents thereof are used. However, when the embodiment is a computer program, these words are stored in a storage device or stored in memory. This means that control is performed so as to be stored in the apparatus. Modules may correspond to functions one-to-one, but in mounting, one module may be configured by one program, or a plurality of modules may be configured by one program, and conversely, one module May be composed of a plurality of programs. The plurality of modules may be executed by one computer, or one module may be executed by a plurality of computers in a distributed or parallel environment. Note that one module may include other modules. Hereinafter, “connection” is used not only for physical connection but also for logical connection (data exchange, instruction, reference relationship between data, etc.). “Predetermined” means that the process is determined before the target process, and not only before the process according to this embodiment starts but also after the process according to this embodiment starts. In addition, if it is before the target processing, it is used in accordance with the situation / state at that time or with the intention to be decided according to the situation / state up to that point. When there are a plurality of “predetermined values”, they may be different values, or two or more values (of course, including all values) may be the same. In addition, the description having the meaning of “do B when it is A” is used in the meaning of “determine whether or not it is A and do B when it is judged as A”. However, the case where it is not necessary to determine whether or not A is excluded.
In addition, the system or device is configured by connecting a plurality of computers, hardware, devices, and the like by communication means such as a network (including one-to-one correspondence communication connection), etc., and one computer, hardware, device. The case where it implement | achieves by etc. is also included. “Apparatus” and “system” are used as synonymous terms. Of course, the “system” does not include a social “mechanism” (social system) that is an artificial arrangement.
In addition, when performing a plurality of processes in each module or in each module, the target information is read from the storage device for each process, and the processing result is written to the storage device after performing the processing. is there. Therefore, description of reading from the storage device before processing and writing to the storage device after processing may be omitted. Here, the storage device may include a hard disk, a RAM (Random Access Memory), an external storage medium, a storage device via a communication line, a register in a CPU (Central Processing Unit), and the like.

  The information processing apparatus 100 according to the first embodiment links the processing of a mount having a plurality of cells and the processing of a tag, and, as shown in the example of FIG. Reception module 110, spreadsheet display module 115, sticky note pasting position specification module 120, spreadsheet cell specification module 125, layer display control module 130, sticky note display module 135, extraction module 140, conversion processing reception module 160, processing module 165, A processing result output module 170 is included. The “mount having a plurality of cells” is a background for sticking a sticky note, and includes, for example, a table composed of rows and columns, a form or a document including the table as a configuration, and the like. As a more specific form, there is a spreadsheet (hereinafter, described by exemplifying a spreadsheet) as a table composed of rows and columns used in spreadsheet software.

  The information processing apparatus 100 is used in a meeting (workshop, meeting, idea extraction meeting, review meeting, etc.) held by a facilitator (generally one person) and a plurality of participants using a sticky note. Is done. A participant creates a sticky note on which an idea or the like is described using a terminal device (a sticky note information processing device 210 described later) as a participant terminal. Generally, as shown in the example of FIG. 3, as the sticky note information processing apparatus 210, there are a sticky note information processing apparatus 210 </ b> A, a sticky note information processing apparatus 210 </ b> B (hereinafter, representatively referred to as a sticky note information processing apparatus 210). There are a plurality of processing devices 210. The shared sticky note information processing apparatus 200 receives the sticky note from the sticky note information processing apparatus 210 and pastes the sticky note on the mount. The facilitator uses the shared screen, which is a display device of the shared sticky note information processing device 200, to determine or change the position of the sticky note on the mount, and to collect the sticky notes (associate the first sticky note with the second sticky note) It is also called group formation (collection formation), etc.), and it also creates sticky information itself and advances the meeting. In the present embodiment, the participant includes a facilitator.

The sticky note information processing apparatus 210 includes, for example, a touch panel display device and an input device, and accepts an operation using a participant's finger, pen, etc., and creates sticky note information. In addition to the touch panel, input using a keyboard or mouse, voice input using a microphone, image input using a camera, or the like may be used. The sticky note only needs to have a data structure capable of managing card-type information. The contents include, for example, text information, vector data indicating handwritten characters, graphics, etc., audio information, still image information such as photographs, video information, etc. Or a combination thereof.
The shared sticky note information processing apparatus 200 pastes a sticky note transmitted from the sticky note information processing apparatus 210 on a mount and displays it, and processes the sticky note. There are facilitators and operators of the shared tag information processing apparatus 200 as persons who instruct the processing for the tag.

  In a meeting using the shared sticky note information processing device 200 and the sticky note information processing device 210, a sticky note in which text or numbers are written is pasted on a prepared template or framework for discussion, etc. The number information is aggregated. The information processing apparatus 100 is configured to perform the counting process and the like using a spreadsheet, and can use a tag for input to the spreadsheet. In other words, it has a function as an FEP (Front End Processor) for spreadsheet software.

  The spreadsheet reception module 105 is connected to the spreadsheet display module 115 and the spreadsheet storage device 190. The spreadsheet reception module 105 receives a spreadsheet. The spreadsheet has a tabular format composed of rows and columns as will be described later. However, when the spreadsheet is displayed, the display format does not necessarily have to be a tabular format. For example, a spreadsheet, a document, etc. There may be. In this embodiment, the spreadsheet has a function as a mount for attaching a sticky note. Accordingly, the display form of the mount may be a table form or a form or the like. Here, accepting may be reading a spreadsheet stored in the spreadsheet storage module 192 of the spreadsheet storage device 190, or accepting a spreadsheet created by an operator using spreadsheet software. You may do it. The former is a case where a spreadsheet is created in advance, and does not necessarily have to be created assuming that a sticky note is pasted. Of course, it may be created assuming that a tag is pasted.

  The tag accepting module 110 is connected to the tag pasting position specifying module 120 and the tag information storage device 194. The sticky note receiving module 110 receives a sticky note. Here, accepting may be reading a sticky note stored in the sticky note information storage module 196 of the sticky note information storage device 194, or accepting a sticky note created by the operator using the sticky note information processing device 210. You may do it. The former is a case where a sticky note is created in advance, and does not necessarily have to be created assuming that it is pasted on a spreadsheet. Of course, it may be created assuming that it is pasted on a spreadsheet.

For example, there is a sticky note information table 1700 as a sticky note accepted by the sticky note acceptance module 110. FIG. 17 is an explanatory diagram showing an example of the data structure of the tag information table 1700. The tag information table 1700 includes a tag ID column 1710, a target spreadsheet ID column 1715, a pasting position column 1720, a size column 1725, a corresponding cell column 1730, a creation date / time column 1735, a creator column 1740, a color column 1745, and a frame shape column. 1750, a frame color column 1755, a frame line thickness column 1760, an affiliation group column 1765, a content type column 1770, and a content column 1775. The tag ID column 1710 stores information (tag ID: IDentification) for uniquely identifying a tag in the present embodiment. The target spreadsheet ID column 1715 stores information (target spreadsheet ID) for uniquely identifying the spreadsheet to which the tag is attached in the present embodiment. Specifically, it is the ID of the spreadsheet accepted by the spreadsheet acceptance module 105. The pasting position column 1720 stores the position where the tag is pasted. That is, the position on the mount is stored. For example, the coordinates in the XY coordinate system of the mount. Specifically, it is the position specified by the sticky note pasting position specifying module 120. The size column 1725 stores the size of the tag. For example, when the tag to be displayed is a rectangle, the width and height are stored. The corresponding cell column 1730 stores a cell in the spreadsheet corresponding to the position where the tag is pasted. Specifically, the cell position (for example, a combination of a row number and a column number) specified by the cell specification module 125 in the spreadsheet is stored. The creation date / time column 1735 stores the date / time (year, month, day, hour, minute, second, second or less, or a combination thereof) when the tag is created. The creator column 1740 stores the creator (creator ID) of the tag. Or you may memorize | store the information processing apparatus (equipment ID of the shared tag information processing apparatus 200 or the tag information processing apparatus 210) by which the tag was created. The color column 1745 stores the display color of the tag. The frame line shape column 1750 stores the shape of the frame line in the display of the tag. The frame line color field 1755 stores the color of the frame line in the display of the tag. The frame line thickness column 1760 stores the frame line thickness in the display of the tag. The affiliation group column 1765 stores information regarding the group to which the tag belongs. For example, information indicating whether or not the sticky note belongs to a group may be stored. If the sticky note belongs to a group, the group ID or other sticky note IDs belonging to the group are stored. May be. The content type column 1770 stores the content type of the tag (text data, vector data indicating handwritten characters or graphics, audio information, still image information such as a photo, moving image information, or the like, or a combination thereof). ing. The content column 1775 stores the content written on the tag.
In the state where the sticky note is not pasted on the spreadsheet as the mount, the target spreadsheet ID column 1715, the pasting position column 1720, the corresponding cell column 1730, etc. may be blank (NULL) or predetermined. Or a default value.

The spreadsheet display module 115 is connected to the spreadsheet reception module 105, the spreadsheet cell specifying module 125, and the layer display control module 130. The spreadsheet display module 115 displays the spreadsheet received by the spreadsheet reception module 105 on a display device such as a liquid crystal display of the shared tag information processing apparatus 200 or the tag information processing apparatus 210. As will be described later with reference to the example of FIG. 4, this display has a layer structure, and a spreadsheet is displayed on the designated layer under the control of the layer display control module 130.
The sticky note pasting position specifying module 120 is connected to the sticky note receiving module 110, the spreadsheet cell specifying module 125, and the sticky note display module 135. The sticky note pasting position specifying module 120 pastes the sticky note received by the sticky note receiving module 110 on a spreadsheet that is a mount. This pasting process may be a position designated in accordance with an operation by the operator, or may be pasted at a predetermined position. Then, the sticky note pasting position specifying module 120 specifies the position of the sticky note pasted on the spreadsheet. This specified position may be a position in the coordinate space of the spreadsheet or a position on the screen of the display device.

The tag display module 135 is connected to the tag pasting position specifying module 120 and the layer display control module 130. The sticky note display module 135 displays a sticky note at a position specified by the sticky note pasting position specifying module 120 on a display device such as a liquid crystal display of the shared sticky note information processing apparatus 200 or the sticky note information processing apparatus 210. As will be described later with reference to the example of FIG. 4, this display has a layer structure, and a tag is displayed on the designated layer under the control of the layer display control module 130.
The layer display control module 130 is connected to the spreadsheet display module 115 and the tag display module 135. The layer display control module 130 controls the display of the layer by controlling the spreadsheet display module 115 and the tag display module 135. By this control, a sticky note is pasted on the spreadsheet. Specifically, the position adjustment between the layer displaying the spreadsheet and the layer displaying the tag is performed. Then, the positional relationship between the layer displaying the spreadsheet and the layer displaying the tag (for example, the coordinates in the other coordinate space where the origin (0, 0) in one coordinate space is located) Pass to the specific module 125.
The layer display control module 130 assigns a spreadsheet display to one layer and assigns a sticky note display to the other layer. Thus, the spreadsheet display control by the spreadsheet display module 115 and the sticky note display control by the sticky note display module 135 can be performed independently. Then, the positional relationship between both layers is managed and displayed as if sticky notes are pasted on the spreadsheet.

  The in-spreadsheet cell specifying module 125 is connected to the spreadsheet display module 115, the sticky note pasting position specifying module 120, and the extraction module 140. The cell specification module 125 in the spreadsheet specifies a cell in the spreadsheet from the position of the tag specified by the tag pasting position specification module 120. In other words, it identifies which cell in the spreadsheet displayed by the spreadsheet display module 115 the sticking position of the tag displayed by the tag display module 135 corresponds to. Specifically, it is only necessary to determine to which cell the sticky tag pasting position overlaps using the area relationship of each cell in the spreadsheet and the positional relationship received from the layer display control module 130. In addition, when one sticky note overlaps with a plurality of cells, for example, the cell in which the upper left corner (or the center or the like) of the sticky note is located may be selected or overlapped. The cell having the largest area may be selected.

The extraction module 140 includes a tag information extraction module 145, an application processing extraction module 150 in the spreadsheet, and a conversion processing extraction module 155, and is connected to the cell specification module 125 in the spreadsheet and the processing module 165. The extraction module 140 extracts the information in the tag and the rules defining the application process for the information, and passes them to the processing module 165.
The sticky note information extraction module 145 extracts information from the target sticky note according to the rules extracted by the in-spreadsheet application processing extraction module 150 or the conversion processing extraction module 155. Specifically, target information defined in the rules is extracted from the spreadsheet creation screen 700.

The in-spreadsheet application process extraction module 150 extracts a rule (application process) related to the cell to which the tag is pasted. The in-spreadsheet application processing extraction module 150 extracts rules related to cells from the rules defined in the spreadsheet. The rule defines that “extract information from a tag and process the information”. That is, (1) what information on the tag is targeted, and (2) the processing content for the information are defined.
The conversion process reception module 160 is connected to the conversion process extraction module 155 of the extraction module 140. The conversion processing reception module 160 receives rules defined on the spreadsheet displayed by the spreadsheet display module 115. In the work of pasting a sticky note, a rule is input according to the operation of the operator. This rule corresponds to the position. For example, as shown in the example of FIG. 13 to be described later, this rule defines processing to be performed on a tag that is designated and pasted in the region. is there.
The conversion process extraction module 155 is connected to the conversion process reception module 160. The conversion process extraction module 155 extracts a rule (application process) related to the position where the tag is pasted. Specifically, the conversion process extraction module 155 extracts a rule related to the position from the rule received by the conversion process reception module 160. The rule defines that “extract information from a tag and process the information”. That is, (1) what information on the tag is targeted, and (2) the processing content for the information are defined.

The processing module 165 is connected to the extraction module 140 and the processing result output module 170. The processing module 165 extracts information for a sticky note according to the rules extracted by the in-spreadsheet application processing extraction module 150, and performs processing on the information. For example, there is statistical processing (for example, counting of the number of sticky notes, calculation of average value, maximum value, minimum value, median value, mode value, total value, etc.) for a plurality of sticky notes. As a plurality of sticky notes, for example, there is a sticky note group belonging to a certain group. In the processing of the processing module 165, the tag generated by the tag generation module 175 is not processed.
Further, the processing module 165 extracts a rule related to the cell by the application processing extraction module 150 in the spreadsheet, and further extracts a rule related to the position by the conversion processing extraction module 155 (that is, for one tag) When a plurality of rules are extracted), the rule related to the position may be preferentially applied. Here, “priority” means (1) a rule related to a position is applied and a rule related to a cell is not applied, and (2) a rule related to a cell is applied after a rule related to a position is applied. Is to apply one of these.
The processing result output module 170 includes a tag generation module 175 and a mount paste module 180, and is connected to the processing module 165. The processing result output module 170 receives the processing result from the processing module 165.
The sticky note generation module 175 generates a sticky note having the processing result by the processing module 165 as content. Note that the tag generated by the tag generation module 175 is not a target of processing by the processing module 165.
The mount pasting module 180 outputs (pastes) the sticky note generated by the sticky note generating module 175 on the mount.
Further, the sticky note generation module 175 may make the numerical value a graphic as the generation of the sticky note indicating the processing result by the processing module 165. For example, graphing of numerical values corresponds to the graphing.

The spreadsheet storage device 190 has a spreadsheet storage module 192 and is connected to the spreadsheet reception module 105 of the information processing apparatus 100. The spreadsheet storage device 190 manages the spreadsheet in the spreadsheet storage module 192. A spreadsheet prepared in advance is stored in the spreadsheet storage module 192.
The sticky note information storage device 194 includes a sticky note information storage module 196 and is connected to the sticky note reception module 110 of the information processing apparatus 100. The sticky note information storage device 194 manages the sticky notes in the sticky note information storage module 196. In the tag information storage module 196, a tag created in advance is stored.

FIG. 2 is an explanatory diagram showing a system configuration example using the present embodiment. The shared sticky note information processing apparatus 200 generally includes a large-screen display device, and is operated by a facilitator. This display device can be seen by all the participants. Each sticky note information processing device 210 is operated by a participant in the meeting, and generally each participant has one. For example, a tablet-type terminal or the like is used as the sticky note information processing apparatus 210.
These system configuration examples are information processing systems using sticky notes and mounts. The tabulation processing (so-called spreadsheet) of sticky notes pasted on the mount is performed. Further, the aggregation process is performed efficiently. Here, “efficient” includes reducing the number of operations by the operator, making it easy for the operator to understand visually, and the like. For example, as will be described later, a rule (for example, calculation of spreadsheet) is registered for each area on the mount, and attribute information of a tag attached to the area (for example, an identifier such as a tag ID or a tag) Information on sticky notes such as written values or characters, color of sticky notes, etc., and information on sets (groups) to which sticky notes belong (set identifiers such as group IDs, group labels, etc.) The registered calculation is performed using information such as a name and the like that can specify a set). When determining which group a tag belongs to, the positional relationship information between the tag and the group may be used. Also, the layout on the mount is associated with the layout of the spreadsheet software. When the rule is registered, a sticky note for displaying a result (processing result) of applying the rule is added to the mount.

  In the example of FIG. 2A1, the shared sticky note information processing apparatus 200 includes the information processing apparatus 100. The shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, the sticky note information processing device 210C, the sticky note information processing device 210D, and the sticky note information processing device 210E are connected via a communication line 299, respectively. Yes. The communication line 299 may be wireless, wired, or a combination thereof. For example, the Internet or an intranet as a communication infrastructure may be used. In this case, the information processing apparatus 100 performs processing on the spreadsheet and the tag displayed on the screen of the shared tag information processing apparatus 200. Then, the display of the screen of the shared sticky note information processing apparatus 200 is transmitted to each sticky note information processing apparatus 210 and is displayed on each sticky note information processing apparatus 210.

In the example of FIG. 2 (a2), the information processing device 100, the shared sticky note information processing device 200, the sticky note information processing device 210A, the sticky note information processing device 210B, the sticky note information processing device 210C, the sticky note information processing device 210D, and the sticky note information processing device 210E. Are connected to each other via a communication line 299. In this case, the shared sticky note information processing apparatus 200 and each sticky note information processing apparatus 210 use the information processing apparatus 100 via the communication line 299. Further, the function of the information processing apparatus 100 may be realized as a cloud service.
In the example of FIG. 2A 3, the shared sticky note information processing apparatus 200 and each sticky note information processing apparatus 210 have the information processing apparatus 100. The shared tag information processing apparatus 200, the tag information processing apparatus 210A, the tag information processing apparatus 210B, the tag information processing apparatus 210C, the tag information processing apparatus 210D, and the tag information processing apparatus 210E are connected via a communication line 299, respectively. In this case, each information processing apparatus 100 performs processing on the spreadsheet and the tag displayed on the screen of each tag information processing apparatus (shared tag information processing apparatus 200, each tag information processing apparatus 210).

In the example of FIG. 2B, a shared sticky note information processing device 200, a sticky note information processing device 210A, a sticky note information processing device 210B, and a sticky note information processing device 210C are installed in the conference room 280, and a meeting is performed. Shared tag information processing apparatus 200, tag information processing apparatus 210A, tag information processing apparatus 210B, and tag information processing apparatus 210C are connected to each other via communication line 299.
The information processing apparatus 100, the spreadsheet storage device 190, the sticky note information storage device 194, and the devices in the conference room 280 are connected via a communication line 298, respectively. The communication line 298 may be wireless, wired, or a combination thereof, and may be, for example, the Internet or an intranet as a communication infrastructure. The functions of the information processing apparatus 100, the spreadsheet storage device 190, and the tag information storage device 194 may be realized as a cloud service. In this case, the shared sticky note information processing apparatus 200 uses the information processing apparatus 100 to transmit the screen display of the shared sticky note information processing apparatus 200 to each sticky note information processing apparatus 210, and each sticky note information processing apparatus 210 uses it. You may make it display. Further, each of the shared sticky note information processing apparatus 200 and each sticky note information processing apparatus 210 may use the information processing apparatus 100.

FIG. 3 is an explanatory diagram showing an example of a conference room or the like in which the present embodiment is used, a usage example of the shared tag information processing apparatus 200, and the tag information processing apparatus 210.
As shown in the example of FIG. 3A, participants 311 and 312 and a facilitator 321 are gathered in a conference room or the like. Participant 311 uses sticky note information processing apparatus 210A, and participant 312 uses sticky note information processing apparatus 210B. In general, one terminal device (such as the tag information processing device 210A) is assigned to each participant, and is about the size of a notebook (such as the tag information processing device 210 shown in the example of FIG. 3C). For example, a tablet type terminal of A4, B5, 7 to 10 inches, etc., which is operated using a finger or a pen. The participant creates sticky note information in which text data, handwritten characters, graphics, and the like are described. The terminal device is not limited to a tablet-type terminal, and may be a PC (including a notebook PC) provided with a keyboard, a mouse, and the like.
The shared sticky note information processing apparatus 200x shown in the example of FIG. 3A is a projector and displays a mount. The shared sticky note information processing apparatus 200y is an electronic white board that detects the movement of a finger or a pen of the facilitator 321 and pastes the sticky note on a mount (spreadsheet), moves the sticky note, associates the sticky note ( Grouping) and operations such as rule creation are accepted. For example, the shared sticky note information processing apparatus 200y is provided with a pen, the pen has moved away from a predetermined pen holder (the facilitator 321 has lifted the pen to operate), and the position of the tip of the pen By detecting that the tip of the pen has touched the shared sticky note information processing apparatus 200y, an operation on the mount and the sticky note is accepted. For example, a sensor (such as a sensor that switches on and off due to the gravity of the pen) is provided in the pen holder, and which pen is used among a plurality of pens (black pen, red pen, blue pen, etc.) What is necessary is just to detect. Further, the entire display screen of the shared sticky note information processing apparatus 200y is a touch sensor, and it is only necessary to detect the position and pressure touched on the display screen.
Further, the shared sticky note information processing apparatus 200 may be an electronic board as shown in the example of FIG. The electronic board generally has a large-screen display device (at least larger than the display device of the sticky note information processing device 210), and the display device is a touch panel, and the position and pressure touched by the display screen. Is detected. For example, the screen may have a size of 80 inches or the like.

FIG. 4 is an explanatory diagram showing an example of display control processing by the layer display control module 130.
As shown in the example of FIG. 4A, the layer display control module 130 creates two layers. One is a background layer 410 for displaying a spreadsheet (mounting sheet), and the other is a sticky note layer 420 for displaying a sticky note. The display destination by the spreadsheet display module 115 is the background layer 410, and the display destination by the sticky note display module 135 is the sticky note layer 420. In general, the background layer 410 is a lower layer, the sticky note layer 420 is an upper layer, and an operation by the operator is accepted as an operation on an object (sticky note) displayed on the sticky note layer 420. Of course, a mode for accepting an operation on an object (spreadsheet) displayed on the background layer 410 may be prepared.
As shown in the example of FIG. 4B, on the screen 400, sticky notes 422 to 436 are displayed on a spreadsheet 415 in an overlapping manner. That is, the spreadsheet display module 115 displays the spreadsheet 415 on the background layer 410, the tag display module 135 displays the tags 422 to 436 on the tag layer 420, and the layer display control module 130 displays the tag layer 420 on the background layer 410. Overlaid on the screen 400.

FIG. 5 is an explanatory diagram showing a related example of the spreadsheet processing module 510, the intermediate layer processing module 520, and the tag processing module 530. The spreadsheet processing module 510 is a module that creates a spreadsheet and the like, and the tag processing module 530 is a module that creates and displays a tag, and any of them may use existing software. The intermediate layer processing module 520 corresponds to the information processing apparatus 100. The intermediate layer processing module 520 takes charge of data exchange between the spreadsheet processing module 510 and the tag processing module 530. In other words, the intermediate layer processing module 520 functions as an FEP of the spreadsheet processing module 510 and as a back end processor of the tag processing module 530. Specifically, the input to the cell in the spreadsheet of the spreadsheet processing module 510 corresponds to the sticking of the tag in the tag processing module 530.
In the example shown in FIG. 5A, the spreadsheet processing module 510, the intermediate layer processing module 520, and the tag processing module 530 are each configured independently.
In the example shown in FIG. 5B, the tag processing expansion module 540 includes an intermediate layer processing module 520 and a tag processing module 530, and the intermediate layer processing module 520 and the tag processing module 530 are integrated. . The entire sticky note processing expansion module 540 has a function as an FEP of the spreadsheet processing module 510.
In the example shown in FIG. 5C, the spreadsheet processing expansion module 550 includes a spreadsheet processing module 510 and an intermediate layer processing module 520, and the spreadsheet processing module 510 and the intermediate layer processing module 520 are configured as one unit. Is. The entire spreadsheet processing expansion module 550 has a function as a back-end processor of the tag processing module 530.
In the example illustrated in FIG. 5D, the spreadsheet sticky note processing module 560 includes a spreadsheet processing module 510, an intermediate layer processing module 520, and a sticky note processing module 530, and the spreadsheet processing module 510 and the intermediate layer processing module 520. The tag processing module 530 is integrated.

FIG. 6 is a flowchart illustrating a processing example according to the first exemplary embodiment.
In step S602, the spreadsheet reception module 105 receives a spreadsheet.
In step S604, the spreadsheet display module 115 displays a spreadsheet.
In step S606, the tag reception module 110 receives tag information.
In step S608, the sticky note pasting position specifying module 120 specifies the position of the sticky note.
In step S610, the tag display module 135 displays a tag.

In step S612, the cell-in-spread sheet specifying module 125 specifies a cell in the spreadsheet corresponding to the position occupied by the tag. For this identification process, for example, a mount / cell correspondence table 1800 may be used. FIG. 18 is an explanatory diagram showing an example of the data structure of the mount / cell correspondence table 1800.
The mount / cell correspondence table 1800 has a mount position column 1810 and a cell column 1820, and the mount position column 1810 has an X column 1812, a Y column 1814, a W column 1816, and an H column 1818. The cell column 1820 has a row number column 1822 and a column number column 1824. The mount position column 1810 stores the position of the area in the mount. The X column 1812 stores the X coordinate of the upper left corner (may be the lower right corner or the center of the region) of the region. The Y column 1814 stores the Y coordinate of the upper left corner of the area. The W column 1816 stores the width of the area. The H column 1818 stores the height of the area. The cell column 1820 stores a cell in the spreadsheet corresponding to the area. The row number column 1822 stores the row number in the spreadsheet indicating the position of the cell. The column number column 1824 stores the column number in the spreadsheet indicating the position of the cell. That is, it is extracted in which region of the mount position column 1810 the position where the sticky note in the mount is pasted. Then, by extracting the cell corresponding to the region, the cell in the spreadsheet corresponding to the position occupied by the tag can be specified.

In step S614, the in-spreadsheet application process extraction module 150 extracts the application process corresponding to the cell from the spreadsheet.
In step S616, the tag information extraction module 145 extracts information necessary for the application process from the tag information. In the process of step S616, the tag generated by the tag generation module 175 is not subject to extraction.
In step S618, the processing module 165 executes an application process. Specifically, the application process extracted in step S614 is executed on the information extracted in step S616.
In step S620, the processing result output module 170 outputs the execution result. The process of step S620 will be described later using the flowchart shown in the example of FIG.

FIG. 7 is an explanatory diagram illustrating a processing example according to the first exemplary embodiment.
In the spreadsheet creation screen 700 shown in the example of FIG. 7A, a spreadsheet 710 is created. The spreadsheet creation screen 700 is a screen for inputting a password for creating the spreadsheet 710, and the spreadsheet 710 is created by spreadsheet software (or a spreadsheet service provided by a cloud service). For example, as a spreadsheet 710, a template for performing calculation using values input to cells is created. The spreadsheet creation screen 700 is generally a screen of a personal computer other than the shared sticky note information processing apparatus 200 and the sticky note information processing apparatus 210, and the spreadsheet 710 is created by the personal computer or the like. However, the spreadsheet 710 may be created by the shared tag information processing apparatus 200 and the tag information processing apparatus 210.
The created spreadsheet 710 is stored in the spreadsheet storage module 192 and retrieved by the spreadsheet reception module 105.

In the sticky note display screen 720 shown in the example of FIG. 7B, the spreadsheet display module 115 displays the spreadsheet 710. The tag display screen 720 is a display screen of the shared tag information processing apparatus 200 or the tag information processing apparatus 210. For example, the URL (Uniform Resource Locator) of the spreadsheet 710 is designated, and a service that can paste a tag is started.
In the sticky note display screen 720 illustrated in the example of FIG. 7C, a sticky note 722 and the like are pasted on the spreadsheet 710 by an operation by the operator. That is, a sticky note is pasted on a cell or area.
On the sticky note display screen 720 shown in the example of FIG. 7D, a total display sticky note 752 and a total display sticky note 754 are created by the processing of the information processing apparatus 100, and are displayed at positions corresponding to cells in which rules are described. ing. The total display sticky note 752 indicates the result in accordance with the rule for counting the cells described in the second column of the spreadsheet 710, and the total display sticky note 754 is included in the cell in the third column of the spreadsheet 710. The result according to the rule of counting the number of

FIG. 8 is an explanatory diagram showing an example of rules defined in a spreadsheet.
The spreadsheet 710 includes a date / time column 812, a company name column 814, a number column 816, a unit price column 818, a product name column 820, and an address column 822, and has a total row 830 at the bottom row.
In the cell 832, “= count” application processing (target) is applied to the cells ((2, 2), (2, 3), (2, 4), (2, 5)) in the company name column 814. In the cell, a counting process of a cell having a description is defined.
In the cell 834, “= sum” is applied to the cells ((3, 2), (3, 3), (3,4), (3, 5)) in the number sequence 816 (target cell). Is defined).
The cell 836 includes “= average” application processing (target cell) for the cells ((4,2), (4,3), (4,4), (4,5)) in the unit price column 818. (Average processing of numerical values) is defined.
The cell 838 includes “= concatenate” application processing (target cell) for the cells ((5, 2), (5, 3), (5, 4), (5, 5)) in the product name column 820. Are defined).
The cell 840 includes “= send-email” application processing ((6, 2), (6, 3), (6, 4), (6, 5)) in the address column 822 ( A process is defined in which a character string in a target cell is treated as an email address and email is sent to that email address.
These definitions are defined in the spreadsheet 710 and are defined by existing spreadsheet software.

FIG. 9 is an explanatory diagram showing an example in which sticky notes (sticky notes 912 to 938) are pasted on the spreadsheet 710.
For example, since the tag 920 and the tag 922 are pasted to the cells (2, 2) and (2, 3), the definition of the cell 832 is executed. The execution result will be described with reference to the example of FIG.
When the sticky note is moved from the current position (cell) to another position (cell), information (post process) indicating that it disappears into the current position cell is input, and the information in the sticky note is entered in the new position cell. Entered.

FIG. 10 is an explanatory diagram showing an example of displaying the processing result.
In the cell 832, “2” is displayed according to the definition “= count”. Since the sticky note 920 and the sticky note 922 are attached to the cells (2, 2) and (2, 3), these numbers are counted (counted).
In the cell 834, “40” is displayed according to the definition “= sum”. Since the sticky notes 924 and 926 are pasted to the cells (3, 2) and (3,4), the numerical values “10” and “30” are totaled.
In the cell 836, “200” is displayed in accordance with the definition “= average”. Since the sticky notes 928 and 930 are attached to the cells (4, 3) and (4, 5), the average values of the numerical values “100” and “300” described are calculated.
In the cell 838, “mandarin orange, apple, banana” is displayed according to the definition “= concatenate”. Since the sticky note 932, the sticky note 934, and the sticky note 936 are attached to the cells (5, 2), (5, 3), and (5, 5), the numerical values “citrus”, “apple”, and “banana” that are described It is the result of concatenating the character strings.
Further, according to the definition “= send-email” of the cell 840, an e-mail is transmitted to “a@bc.def” which is a character string in the tag 938.

FIG. 11 is a flowchart illustrating a processing example according to the first exemplary embodiment. In addition to the rules related to cells (application processing, definition in the spreadsheet), a processing example in the case where rules related to position (conversion processing in the flowchart of FIG. 11) are defined is shown. Processing of steps S1106, S1116, S1118, and S1120 is added to the flowchart shown in the example of FIG.
In step S1102, the spreadsheet reception module 105 receives a spreadsheet.
In step S1104, the spreadsheet display module 115 displays a spreadsheet.
In step S1106, the conversion process reception module 160 receives the definition of the code information conversion process in association with the cell.
In step S1108, the sticky note receiving module 110 receives sticky note information.
In step S1110, the sticky note pasting position specifying module 120 specifies the position of the sticky note.
In step S1112, the tag display module 135 displays a tag.

In step S1114, the spreadsheet cell specifying module 125 specifies the cell in the spreadsheet corresponding to the position occupied by the tag. As described above, this specifying process may use, for example, the mount / cell correspondence table 1800.
In step S1116, the conversion process extraction module 155 extracts a conversion process corresponding to the cell.
In step S1118, the conversion process extraction module 155 extracts information necessary for the conversion process from the tag information. Note that in the process of step S1118, the tag generated by the tag generation module 175 is not subject to extraction.
In step S1120, conversion processing is executed.
In step S1122, the in-spreadsheet application process extraction module 150 extracts an application process corresponding to the cell from the spreadsheet.
In step S1124, the tag information extraction module 145 extracts information necessary for the application process from the tag information or the conversion process result. Note that in the process of step S1124, the tag generated by the tag generation module 175 is not subject to extraction.
In step S1126, the processing module 165 executes an application process.
In step S1128, the processing result output module 170 outputs the execution result. The processing in step S1128 will be described later using the flowchart shown in the example of FIG.
If conversion processing and application processing are extracted for the same cell, the processing in steps S1122 to S1126 may not be performed.

FIG. 12 is an explanatory diagram illustrating a processing example according to the first embodiment (processing example according to the flowchart illustrated in the example of FIG. 11).
The examples shown in FIGS. 12A to 12C are the same as the examples shown in FIGS.
In the sticky note display screen 720 shown in the example of FIG. 12D, the definition area 1210 is designated by the operation of the operator from the state of the sticky note display screen 720 shown in the example of FIG. Conversion processing for is defined. In the example of FIG. 12, a conversion process of “calculating the total value of sticky notes in the definition area 1210 and inputting them to the cells below the definition area 1210” is defined.
On the sticky note display screen 720 shown in FIG. 12 (e), a total display sticky note 752 and a total display sticky note 1254 are created by the processing of the information processing apparatus 100, and are displayed at positions corresponding to the cells in which the rules are described. . The total display sticky note 752 indicates the result according to the rule for counting the cells described in the second column of the spreadsheet 710, as in the example of FIG. 7, and the total display sticky note 1254 indicates the spreadsheet. The result according to the rule which totals the number in the cell of the 3rd column of 710 is shown.

FIG. 13 is an explanatory diagram showing an example of displaying the processing result.
The definition area 1310 is generated by the operation of the operator. However, the area may be specified according to the cell in the spreadsheet 710. Specifically, the area may be specified along the cell boundary. As a result, even if there is an area setting operation that crosses the middle of the cell, it is possible to set the area corresponding to the cell.
Further, by defining in the definition area 1310, for example, even when there is no application processing defined in the cell 834 shown in FIG. 8, the definition is not added in the spreadsheet (that is, the spreadsheet is displayed). And without modification operations) can be defined on the tag display screen.
The definition area 1310 defines a conversion process of “calculating the total value of sticky notes in the definition area 1310 and inputting them into cells below the definition area 1310”. As a result, “40” is displayed in the cell 834. The other cells 832 and the like are equivalent to the example of FIG.

FIG. 14 is an explanatory diagram showing an example when a plurality of sticky notes are pasted in one cell. Two sticky notes, a sticky note 924 and a sticky note 1412, are pasted on the cell (3, 2), and two sticky notes, a sticky note 928 and a sticky note 1414, are pasted on the cell (4, 3). A plurality of sticky notes may be pasted in duplicate.
In this way, when it is detected that a plurality of sticky notes are pasted in one cell, a predetermined process is performed on the information in these sticky notes and input to the cell. Here, as the “predetermined process”, for example, an addition process may be performed when the description content in the tag is a numerical value, and a connection process may be performed when the description content in the tag is a text. In accordance with the “predetermined process”, “30” is input to the cell (3, 2), and “300” is input to the cell (4, 3). Since the cell 834 is the result of the aggregation process, the process of “(10” + “20”) + “30” may be performed. Further, since the cell 836 is an average value calculation and the number of cells is 2, processing of ((“100” + “200”) + “300”) / 2 may be performed.

FIG. 15 is an explanatory diagram showing an example when a plurality of sticky notes are pasted in one cell. The example in case the description content in a tag is a text is shown.
When the description content in the sticky note is text, for example, a concatenation process is performed, but in what order it may be determined by the position of the sticky note in the cell, or the order in which the sticky note is pasted You may make it decide by. Specifically, as a process for determining the position of the tag in the cell, the tag may be connected in order from the left at the position where the tag is pasted. In the case of the example of FIG. 15A, the sticky note 1512a described as the text string “abc” is on the left, and the sticky note 1514a described as the text string “de” is on the right, so the character string “abcde” is displayed in the cell 1500a. ". In the example of FIG. 15B, the sticky note 1514b described as the text string “de” is on the left, and the sticky note 1512b described as the text string “abc” is on the right. Therefore, the character string “deabc” is displayed in the cell 1500b. ". Further, as processing for determining the order in which the sticky notes are pasted, the date and time when the sticky notes are pasted may be connected in order from the earliest.

FIG. 16 is an explanatory diagram showing an example when a plurality of sticky notes are pasted in one cell. The example in case the description content in a tag is a numerical value is shown.
In the example of FIG. 14, when there are a plurality of cells in one cell, an example is shown in which numerical values are added, but the processing may be varied depending on the positional relationship of the tag within the cell. Specifically, the addition processing may be performed when the sticky notes are arranged side by side, and the division processing may be performed when the sticky notes are arranged vertically. In the case of division processing, the tag on the top is the numerator and the tag on the bottom is the denominator (positional relationship similar to the fraction), and is the target of the division processing. For example, in the case of FIG. 16 (a), the sticky note 1612a described with the numerical value “10” and the sticky note 1614a described with the numerical value “5” are arranged side by side. Enter “15 (10 + 5)”. In the case of FIG. 16B, since the sticky note 1612b described as the numerical value “10” and the sticky note 1614b described as the numerical value “5” are arranged vertically, the division process is applied to the numerical value “2” in the cell 1600b. (10/5) "is input. In the case of FIG. 16C, since the sticky note 1614c described with the numerical value “5” and the sticky note 1612c described with the numerical value “10” are arranged vertically, the division process is applied to the numerical value “0” in the cell 1600c. .5 (5/10) ".
The concatenation process, the addition process, and the division process are shown as examples, but other processes (subtraction process, multiplication process, average value process, CSV (Comma-Separated Values) process, array process, sticky note group formation process, etc.) It may be. These (processing contents, positional relationship of sticky notes or pasting order) may be defined as defaults, or may be defined in the definition area 1310 shown in the example of FIG.

FIG. 19 is a flowchart illustrating a processing example according to the first exemplary embodiment.
In step S1902, the processing result output module 170 receives the processing result.
In step S1904, the tag generation module 175 generates a tag indicating the processing result received in step S1902. For example, the total display sticky note 752, the total display sticky note 754, and the total display sticky note 1254 are generated. Specifically, for example, there is a sticky note whose content is text (including numerical values). Moreover, the content which made the numerical value a figure may be sufficient. For example, a sticky note containing a graph may be generated.
In step S1906, the mount sticking module 180 specifies the position where the sticky note generated in step S1904 is attached on the mount. The pasting position here may be a predetermined position, or the position may be determined according to the operation of the operator.
In step S1908, the mount sticking module 180 pastes a sticky note (the sticky note generated in step S1904) on the mount. If the example of FIG. 4 is used, a tag will be displayed on the tag layer 420.

FIG. 20 is an explanatory diagram illustrating a processing example according to the first exemplary embodiment.
FIG. 20A shows an example of designing a spreadsheet (template) according to the operation of the facilitator. In this spreadsheet, an area, an application process, and a processing result display area (label) are set.
Specifically, an area 2010, an area 2020, an area 2030, and an area 2040 are set on the screen 2000. These correspond to spreadsheet cells. Then, an application process for counting the number of sticky notes pasted in the area is set. Moreover, it is shown that the tag groups in each area belong to the same group. For example, the tag group in the area 2010 is group A, the tag group in the area 2020 is group B, the tag group in the area 2030 is group C, and the tag group in the area 2040 is group D. Then, a processing result display area is set in the upper right of each area.
Then, the sticky note 2012 and the sticky note 2014 are pasted in the area 2010 by the participant's sticky note pasting operation, and the sticky note 2022 and the sticky note 2024 are pasted in the area 2020.
Specifically, the facilitator uses spreadsheet software to create a sheet (data sheet, display sheet, etc.) for tabulating sticky note data, and registers it in the information processing apparatus 100 together with the mount. The relationship between the cell in the sheet and the position in the mount is defined by the mount / cell correspondence table 1800 as described above.

FIG. 20B shows an example of displaying the processing result by the spreadsheet software. That is, the spreadsheet software is activated in the information processing apparatus 100 by the operation of the facilitator (for example, the calculation start operation), and the processing result by the spreadsheet software is displayed in the number of sticky notes display area in each area. . Specifically, the number of sticky notes in each area is counted, “3” for the sticky note 2019 in the area 2010, “4” for the sticky note 2029 in the area 2020, “0” for the sticky note 2039 in the area 2030, and the area 2040. “0” is displayed on the tag 2049. Of course, the number of sticky notes in the area 2010 does not include the sticky notes 2019.
From the state shown in the example of FIG. 20A, a sticky note 2016 is added to the area 2010, and a sticky note 2026 and a sticky note 2028 are added to the area 2020.

FIG. 20C shows an example of displaying the processing result by the spreadsheet software each time. That is, as the work progresses, when the sticky note is updated, processing by spreadsheet software is performed, and the display of the processing result is also updated.
By newly attaching a sticky note 2032 to the area 2030, the content of the sticky note 2039 is changed from “0” to “1”.

  FIG. 20D shows an example in which the combination of the mount and the spreadsheet software can be changed. In other words, this is an example in which the spreadsheet software is changed to one that counts the sticky notes in each area and displays the graph. The display differs depending on the modified spreadsheet software. Specifically, a sticky note 2070 is pasted on the mount in the screen 2000 and displayed. The content of the sticky note 2070 is a graph in which the horizontal axis indicates the group names of the area 2010, area 2020, area 2030, and area 2040 (in order, group A, group B, group C, and group D), and the vertical axis indicates the number of sticky notes.

21 and 22 are explanatory diagrams illustrating processing examples according to the first embodiment. The relationship between a mount and a table | surface (table | surface in spreadsheet software) is illustrated.
FIG. 21A shows an example in which a sticky note is pasted on a mount.
A mount 2110 is displayed on the screen 2100. The mount 2110 has a request title column 2115, a man-hour column 2120, a priority column 2125, and a status column 2130. In the request title column 2115, a tag of the request title is pasted. In the man-hour column 2120, a man-hour tag is pasted. In the priority column 2125, a priority tag is pasted. A status tag is pasted in the status column 2130. And it is divided into areas (group 2132, group 2134, group 2136, group 2138) in the row direction. The sticky notes included in the area of these groups belong to the same group.
In addition, a “Calculate” button 2140 is displayed on the mount 2110. When the “calculate” button 2140 is selected by the participant, the spreadsheet software is activated.

FIG. 21B is a screen example in the spreadsheet software when the “Calculate” button 2140 is selected in FIG. In the example of FIG. 21B, the data in the tag on the mount 2110 shown in the example of FIG. 21A is imported in a format that can be processed by spreadsheet software. Using the mount / cell correspondence table 1800, cell positions can be associated with sticky notes.
A table 2150 is displayed on the screen 2100. The table 2150 has a tag ID column 2155, a tag content column 2160, a group label column 2165, a group ID column 2170, and a tag color column 2175. The tag ID column 2155 stores a tag ID. The sticky note content field 2160 stores the content of the sticky note. The group label column 2165 stores group labels. The group ID column 2170 stores a group ID. The sticky note color field 2175 stores the color of the sticky note. One row in the table 2150 corresponds to one sticky note. For example, the tag ID “23” (the second line in the table 2150) corresponds to the tag “2” (the tag in the cell in the second row and the second column in the mount 2110) shown in the example of FIG. ing.

  FIG. 21C shows that the calculation formula “= sumif (xx)” is entered in the cell in the last row of the tag content field 2160 by the operation of the operator (for example, a facilitator). That is, a new sticky note is generated, and a rule (in this example, a calculation formula of “= sumif (xx)”) is described in the content of the sticky note. This calculation formula is for calculating the sum total of the contents of sticky notes relating to the man-hours in the group whose priority is 3 or less.

In the example of FIG. 22A, the display of the spreadsheet software is terminated and the mount 2110 is displayed from the state shown in the example of FIG.
Here, since a new tag is generated in the example of FIG. 21C, a calculation result display tag 2270 is newly generated and displayed.
The calculation result display tag 2270 displays the value “11”. That is, “11” obtained by adding the manhour “1” of the group 2134 having the priority 3 and the manhour “10” of the group 2136 is displayed on the calculation result display sticky note 2270.

  In the example of FIG. 22B, since the “priority” of the group 2132 has been changed from “4” to “2” (sticky note 2202) from the state of FIG. 22A, the man-hour “2” of the group 2132 Are further added to display “13” on the calculation result display sticky note 2270.

  FIG. 22C shows an example in which the rule set in the example of FIG. 21C is changed to a rule for creating a graph by the operation of an operator (for example, a facilitator). Specifically, a graph display tag 2280 is added to the mount 2110 and displayed. The content of the graph display sticky note 2280 is a graph in which the horizontal axis indicates the priority and the vertical axis indicates the man-hour of the group having the priority.

<Second Embodiment>
FIG. 23 is a conceptual module configuration diagram of a configuration example according to the second embodiment. In addition, the same code | symbol is attached | subjected to the site | part of the same kind as 1st Embodiment, and the overlapping description is abbreviate | omitted. The portion described as “spreadsheet” in the first embodiment may be read as “mounting paper”.
In the second embodiment, processing equivalent to that in the first embodiment is performed using the attribute of the tag and the group information. That is, this 2nd Embodiment has shown the example which does not use a spreadsheet and a cell position. Of course, you may combine 1st Embodiment and 2nd Embodiment. As an example of the combination, the first embodiment may be grasped as an example when the second embodiment is embodied (that is, as a superordinate concept of the first embodiment, 2 may be grasped). In this case, “mount” is a concept including a spreadsheet.
The information processing apparatus 2300 according to the second embodiment performs processing related to sticky notes, and as illustrated in the example of FIG. 23, a mount receiving module 2305, a sticky note receiving module 110, a mount display module 2315, and sticky sticking The position specifying module 120, the layer display control module 130, the tag display module 135, the extraction module 140, the conversion process reception module 160, the processing module 165, and the processing result output module 170 are included.

  The mount reception module 2305 is connected to the mount display module 2315 and the mount storage device 2390. The mount receiving module 2305 receives a mount. Here, accepting may be to read a mount stored in the mount storage module 2392 of the mount storage device 2390, or to accept a mount created by the operator using the mount generation software. Good. The former is a case where a mount is prepared in advance, and does not necessarily have to be created on the assumption that a sticky note is pasted. For example, it may be an image called wallpaper. Of course, it may be created assuming that a tag is pasted.

  The mount display module 2315 is connected to the mount receiving module 2305, the layer display control module 130, and the extraction module 140. The mount display module 2315 displays the mount received by the mount receiving module 2305 on a display device such as a liquid crystal display of the shared tag information processing apparatus 200 or the tag information processing apparatus 210. As described above with reference to the example of FIG. 4, this display has a layer structure, and a mount is displayed on the designated layer under the control of the layer display control module 130.

The sticky note pasting position specifying module 120 is connected to the sticky note receiving module 110, the sticky note display module 135, and the extraction module 140. The sticky note pasting position specifying module 120 pastes the sticky note received by the sticky note accepting module 110 on the mount. This pasting process may be a position designated in accordance with an operation by the operator, or may be pasted at a predetermined position. Then, the sticky note pasting position specifying module 120 specifies the position of the sticky note pasted on the mount. This specified position may be a position in the coordinate space of the mount or a position on the screen of the display device.
Then, the sticky note pasting position specifying module 120 specifies a group (set) to which the sticky notes pasted on the mount belong. Using the belonging group column 1765 of the sticky note information table 1700 for each sticky note, the group to which the sticky note belongs is specified.
When combined with the above-described first embodiment, the sticky note pasting position specifying module 120 specifies the cell in the mount on which the sticky note is pasted from the position of the sticky note on the mount having a plurality of cells. Thus, the set to which the sticky note belongs may be specified. For example, an area for group formation (for example, the inside of an enclosing line indicating the group area) is displayed in advance on the mount, and the sticky notes pasted in the area belong to the group corresponding to the area. It is determined that

  The extraction module 140 includes a tag information extraction module 145, an application processing extraction module 2350, and a conversion processing extraction module 155, and is connected to the mount display module 235, the tag sticking position specifying module 120, and the processing module 165. The extraction module 140 extracts the information in the tag and the rules defining the application process for the information, and passes them to the processing module 165.

The application process extraction module 2350 extracts rules (application processes) related to the group. The application processing extraction module 2350 extracts rules related to the group from the rules defined in the mount. The rule defines that “extract information from a tag and process the information”. That is, (1) what information on the tag is targeted, and (2) the processing content for the information are defined.
When combined with the above-described first embodiment, the application processing extraction module 2350 may associate the position of a sticky note or a spreadsheet cell as a mount as a group. Therefore, in this case, a rule related to the group is extracted from the position of the tag or the cell of the spreadsheet.

  The processing module 165 is connected to the extraction module 140 and the processing result output module 170. The processing module 165 extracts information for a sticky note according to the rules extracted by the application processing extraction module 2350, and performs processing on the information. For example, there is statistical processing (for example, counting of the number of sticky notes, calculation of average value, maximum value, minimum value, median value, mode value, total value, etc.) for a plurality of sticky notes. As a plurality of sticky notes, for example, there is a sticky note group belonging to a certain group. In the processing of the processing module 165, the tag generated by the tag generation module 175 is not processed.

  The mount storage device 2390 has a mount storage module 2392 and is connected to the mount reception module 2305 of the information processing device 2300. The mount storage device 2390 manages the mount in the mount storage module 2392. In the mount storage module 2392, a mount prepared in advance is stored.

  Instead of the tag information table 1700 used in the first embodiment, a tag information table 2500 may be used in the second embodiment. FIG. 25 is an explanatory diagram showing an example of the data structure of the tag information table 2500. The tag information table 2500 includes a tag ID column 2510, a target mount ID column 2515, a pasting position column 2520, a size column 2525, a creation date / time column 2535, a creator column 2540, a color column 2545, a frame shape column 2550, and a frame line color column. 2555, a frame line thickness column 2560, an affiliation group column 2565, a content type column 2570, and a content column 2575. That is, the corresponding spreadsheet ID column 1715 in the tag information table 1700 is used as the target mount ID column 2515, and the corresponding cell column 1730 is deleted. The target mount ID column 2515 stores information (mount ID) for uniquely identifying the mount on which the tag is attached in the present embodiment. The tag reception module 110 receives the tag information table 2500.

  Further, the mount information table 2600 may be used as information for managing the mount. FIG. 26 is an explanatory diagram showing an example of the data structure of the mount information table 2600. The mount information table 2600 includes a mount ID column 2610, a background information column 2620, a group number column 2630, a group ID column 2640, an area column 2650, and an application processing column 2660. The mount ID column 2610 stores a mount ID. The background information column 2620 stores information indicating the background of the mount with the mount ID. For example, it may be a file name of a background image (including URL (Uniform Resource Locator)) or information indicating a pattern. In the image, a group area may be described, and the pattern may be configured by a graphic command for drawing the group area. The group number column 2630 stores the number of groups defined in the mount. Accordingly, the combination of the group ID column 2640 to the application processing column 2660 continues thereafter by the number of groups. The group ID column 2640 stores information (group ID) for uniquely identifying a group in the present embodiment. The area column 2650 stores an area indicating the group. For example, when the area is a rectangle, it is defined by the coordinates, width, and height of the upper left corner. The application processing column 2660 stores rules related to the group (rules applied to sticky notes belonging to the group). In addition, when the belonging group column 2565 of the tag information table 2500 is used for the determination processing to which group the tag belongs, the group number column 2630 and the region column 2650 may be omitted. The mount receiving module 2305 receives the mount information table 2600.

FIG. 24 is a flowchart illustrating a processing example according to the second exemplary embodiment. This corresponds to the flowchart shown in the example of FIG. 6 in the first embodiment.
In step S2402, the mount receiving module 2305 receives the mount.
In step S2404, the mount display module 2315 displays the mount.
In step S2406, the sticky note receiving module 110 receives sticky note information.
In step S2408, the sticky note pasting position specifying module 120 specifies the position of the sticky note.
In step S2410, the tag display module 135 displays a tag.

In step S2412, the sticky note pasting position specifying module 120 specifies the group to which the sticky note pasted on the mount belongs.
In step S2414, the application process extraction module 2350 extracts the application process corresponding to the group from the mount.
In step S2416, the tag information extraction module 145 extracts information necessary for the application process from the tag information. Note that in the processing of step S2416, the tag generated by the tag generation module 175 is not subject to extraction.
In step S2418, the processing module 165 executes application processing. Specifically, the application process extracted in step S2414 is executed on the information extracted in step S2416.
In step S2420, the processing result output module 170 outputs the execution result. For the process in step S2420, the process according to the flowchart shown in the example of FIG. 19 may be used.

  Note that the hardware configuration of the computer on which the program according to the present embodiment is executed is a general computer as illustrated in FIG. 27, specifically, a personal computer, a computer that can be a server, or the like. That is, as a specific example, a CPU 2701 is used as a processing unit (calculation unit), and a RAM 2702, a ROM 2703, and an HD 2704 are used as storage devices. As the HD 2704, for example, a hard disk or an SSD (Solid State Drive) may be used. Spreadsheet reception module 105, sticky note reception module 110, spreadsheet display module 115, sticky note pasting position specification module 120, spreadsheet cell specification module 125, layer display control module 130, sticky note display module 135, extraction module 140, sticky note information extraction Module 145, spreadsheet application processing extraction module 150, conversion processing extraction module 155, conversion processing reception module 160, processing module 165, processing result output module 170, tag generation module 175, mount pasting module 180, mount reception module 2305, mount CPU 2701 for executing programs such as display module 2315 and application processing extraction module 2350, and RA for storing the programs and data 2702, a ROM 2703 storing a program for starting the computer, an auxiliary storage device (such as a flash memory) having functions as a spreadsheet storage module 192, a sticky note information storage module 196, a mount storage module 2392, etc. HD 2704, an accepting device 2706 that accepts data based on user operations on a keyboard, mouse, touch panel, microphone, and the like, an output device 2705 such as a CRT, a liquid crystal display, and a speaker, and a network interface card A communication line interface 2707 for connecting to a communication network such as the above, and a bus 2708 for connecting them to exchange data. A plurality of these computers may be connected to each other via a network.

Among the above-described embodiments, the computer program is a computer program that reads the computer program, which is software, in the hardware configuration system, and the software and hardware resources cooperate with each other. Is realized.
Note that the hardware configuration shown in FIG. 27 shows one configuration example, and the present embodiment is not limited to the configuration shown in FIG. 27 but can execute the modules described in the present embodiment. I just need it. For example, some modules may be configured with dedicated hardware (for example, Application Specific Integrated Circuit (ASIC), etc.), and some modules are in an external system and connected via a communication line Alternatively, a plurality of systems shown in FIG. 27 may be connected to each other via communication lines so as to cooperate with each other. In particular, in addition to personal computers, portable information communication devices (including mobile phones, smartphones, mobile devices, wearable computers, etc.), information appliances, robots, copiers, fax machines, scanners, printers, multifunction devices (scanners, printers, An image processing apparatus having two or more functions such as a copying machine and a fax machine) may be incorporated.

The program described above may be provided by being stored in a recording medium, or the program may be provided by communication means. In that case, for example, the above-described program may be regarded as an invention of a “computer-readable recording medium recording the program”.
The “computer-readable recording medium on which a program is recorded” refers to a computer-readable recording medium on which a program is recorded, which is used for program installation, execution, program distribution, and the like.
The recording medium is, for example, a digital versatile disc (DVD), which is a standard established by the DVD Forum, such as “DVD-R, DVD-RW, DVD-RAM,” and DVD + RW. Standard “DVD + R, DVD + RW, etc.”, compact disc (CD), read only memory (CD-ROM), CD recordable (CD-R), CD rewritable (CD-RW), Blu-ray disc ( Blu-ray (registered trademark) Disc), magneto-optical disk (MO), flexible disk (FD), magnetic tape, hard disk, read-only memory (ROM), electrically erasable and rewritable read-only memory (EEPROM (registered trademark)) )), Flash memory, random access memory (R) AM), SD (Secure Digital) memory card, and the like.
The program or a part of the program may be recorded on the recording medium for storage or distribution. Also, by communication, for example, a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), a wired network used for the Internet, an intranet, an extranet, or a wireless communication It may be transmitted using a transmission medium such as a network or a combination of these, or may be carried on a carrier wave.
Furthermore, the program may be a part or all of another program, or may be recorded on a recording medium together with a separate program. Moreover, it may be divided and recorded on a plurality of recording media. Further, it may be recorded in any manner as long as it can be restored, such as compression or encryption.

DESCRIPTION OF SYMBOLS 100 ... Information processing apparatus 105 ... Spreadsheet reception module 110 ... Sticky note reception module 115 ... Spreadsheet display module 120 ... Sticky note pasting position specification module 125 ... Spreadsheet cell specification module 130 ... Layer display control module 135 ... Sticky note display module 140 ... Extraction module 145 ... Sticky note information extraction module 150 ... Spreadsheet application processing extraction module 155 ... Conversion processing extraction module 160 ... Conversion processing acceptance module 165 ... Processing module 170 ... Processing result output module 175 ... Sticky note generation module 180 ... Mount paste module 190 ... Spreadsheet storage device 192 ... Spreadsheet storage module 194 ... Sticky note information storage device 196 ... Sticky note information storage module 200 Shared sticky note information processing device 210 ... Sticky note information processing device 280 ... Conference room 298, 299 ... Communication line 2300 ... Information processing device 2305 ... Mount receiving module 2315 ... Mount display module 2350 ... Application processing extraction module 2390 ... Mount storage device 2392 ... Mount Storage module

Claims (8)

A specifying means for specifying a set to which the sticky notes pasted on the mount belong,
Extraction means for extracting rules related to the identified set;
In accordance with the rules, processing means for extracting information on the attribute of the tag for the tag and processing the information;
Generating means for generating a sticky note containing the processing result of the processing means;
Output means for outputting the sticky note generated by the generating means on the mount;
The processing means does not process the sticky note generated by the generating means;
Information processing device. The specifying unit specifies a set to which a sticky note belongs by specifying a cell in the mount on which the sticky note is pasted from a position of the sticky note on a mount having a plurality of cells.
The information processing apparatus according to claim 1. The extraction means extracts a related rule from the position of the tag or the cell;
The information processing apparatus according to claim 2. The extraction means extracts rules associated with the set from rules defined in the mount;
The information processing apparatus according to claim 1. A receiving means for receiving a rule defined on the displayed mount;
The extracting means extracts a rule related to the position from the rule received by the receiving means;
The information processing apparatus according to any one of claims 1 to 4. The processing means, when the extracting means extracts both a rule related to the cell and a rule related to the position, preferentially applies the rule related to the position.
The information processing apparatus according to claim 5, which is dependent on claim 4. The generation means performs a figure of a numerical value as generation of a sticky note indicating a processing result.
The information processing apparatus according to any one of claims 1 to 6. Computer
A specifying means for specifying a set to which the sticky notes pasted on the mount belong,
Extraction means for extracting rules related to the identified set;
In accordance with the rules, processing means for extracting information on the attribute of the tag for the tag and processing the information;
Generating means for generating a sticky note containing the processing result of the processing means;
Function as output means for outputting the sticky note generated by the generating means on the mount,
The processing means does not process the sticky note generated by the generating means;
Information processing program.

Images