Information providing apparatus, information providing method, and information providing program
The information providing device addresses scheduling challenges by dynamically displaying and adjusting work schedules to prevent equipment overlap, ensuring efficient production management.
Patent Information
- Application Number
- JP2023074570
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-04-28
- Publication Date
- 2024-11-08
Smart Images

Figure 2024158930000001_ABST
Abstract
Description
[Technical field]
[0001] The present application relates to an information providing device, an information providing method, and an information providing program. [Background technology]
[0002] 2. Description of the Related Art Conventionally, there is known a technique for displaying on a sheet information, such as equipment for a work process, a work schedule, and a progress status, using a spreadsheet software. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2006-338202 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, there are cases where a predetermined work schedule must be changed due to an unexpected equipment shutdown, etc. In such cases, it may become necessary to operate the equipment beyond the scheduled time, which may result in a situation where the next product that was scheduled to be processed cannot be processed. With conventional technology, there is a problem that it is difficult to grasp that the same equipment is assigned to different processes at the same time. [Means for solving the problem]
[0005] An information providing device according to one embodiment has a first display control unit that displays a process corresponding to a specified product in a first column of a table, and displays equipment specified for the process in a second column different from the first column in the same row as the process displayed in the first column; a schedule calculation unit that calculates a start date and time and an end date and time of the process displayed in the first column based on a specified date and time and the equipment displayed in the second column; a second display control unit that changes a display mode of a cell in the same row as the process displayed in the first column in the columns of the table corresponding to each of the dates and times based on the start date and end date and time calculated by the schedule calculation unit; and an overlapping equipment identification unit that identifies that a plurality of processes using common equipment are associated with a column of the table corresponding to one date and time.
[0006] In one aspect of the information provision method, a computer executes a process in a first column of a table, displays a process corresponding to a specified product in a second column different from the first column in the same row as the process displayed in the first column, calculates a start date and time and an end date and time of the process displayed in the first column based on the specified date and time and the equipment displayed in the second column, changes the display mode of a cell in the same row as the process displayed in the first column in the column of the table corresponding to each of the dates and times based on the calculated start date and time and end date and time, and identifies that a column of the table corresponding to one date and time is associated with multiple processes that share common equipment.
[0007] An information provision program in one embodiment causes a computer to execute a process that corresponds to a specified product in a first column of a table, displays equipment specified for the process in a second column different from the first column in the same row as the process displayed in the first column, calculates a start date and time and an end date and time for the process displayed in the first column based on the specified date and time and the equipment displayed in the second column, changes the display mode of a cell in the same row as the process displayed in the first column in the column of the table corresponding to each date and time based on the calculated start date and time and end date and time, and identifies that a column of the table corresponding to one date and time is associated with multiple processes that share common equipment. [Brief description of the drawings]
[0008] [Figure 1] FIG. 1 is a diagram illustrating an example of a configuration of an information providing device according to an embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the product master. [Diagram 3] FIG. 3 is a diagram illustrating an example of the product master. [Figure 4] FIG. 4 is a diagram illustrating an example of the facility master. [Diagram 5] FIG. 5 is a diagram showing an example of the schedule sheet 20. As shown in FIG. [Figure 6] FIG. 6 is a flowchart showing the flow of the product addition process. [Figure 7] FIG. 7 is a flowchart showing the flow of the month addition process. [Figure 8] FIG. 8 is a flowchart showing the flow of the schedule calculation process. [Figure 9] FIG. 9 is a flowchart showing the flow of the overlap identifying process. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0009] An embodiment for implementing an information providing device, an information providing method, an information providing program, and the like will be described in detail with reference to the drawings. Note that the present invention is not limited to the following description. Furthermore, the components in the following description include those that a person skilled in the art can easily imagine, those that are substantially the same, and those that are within the so-called equivalent range. In the following description, similar components may be given the same reference numerals. Furthermore, duplicated descriptions may be omitted.
[0010] The configuration of the information providing device will be described with reference to Fig. 1. Fig. 1 is a diagram showing an example of the configuration of the information providing device according to an embodiment.
[0011] The information providing device 10 provides information regarding the schedule for manufacturing a product. The product is manufactured through one or more processes. In each process, equipment performs a predetermined processing on the material. The time required for each process is determined by the processing method and the type of equipment.
[0012] For example, the information providing device 10 visualizes and displays a schedule using a table in which columns correspond to times and rows correspond to processes. The information providing device 10 is realized by an information processing device such as a server or a personal computer executing a spreadsheet software. In this case, an add-on for realizing the function of the information providing device 10 may be implemented in the spreadsheet software.
[0013] As shown in FIG. 1, the information providing device 10 includes a communication unit 11, an input unit 12, an output unit 13, a storage unit 14, and a control unit 15.
[0014] The communication unit 11 is an interface for communicating data with other devices via a wired network or a wireless network, and is, for example, a network interface controller (NIC).
[0015] The input unit 12 is an interface for receiving input of data. For example, the input unit 12 is connected to input devices such as a mouse and a keyboard.
[0016] The output unit 13 is an interface for outputting data. For example, the output unit 13 is connected to output devices such as a display and a speaker. In this embodiment, the output unit 13 outputs a screen to a display or the like.
[0017] The storage unit 14 can store programs and data. The storage unit 14 is also used as a working area for temporarily storing the processing results of the control unit 15. The storage unit 14 may include any non-transitory storage medium such as a semiconductor storage medium and a magnetic storage medium. The storage unit 14 may include multiple types of storage media.
[0018] The storage unit 14 may include a combination of a portable storage medium such as a memory card, an optical disk, or a magneto-optical disk, and a storage medium reader. The storage unit 14 may include a storage device used as a temporary storage area such as a RAM (Random Access Memory).
[0019] The storage unit 14 stores template information 141, a product DB 142, an equipment DB 143, and a performance DB 144. Note that the DB may include one or more tables.
[0020] The template information 141 is a template for the schedule sheet 20 described later. The products to be manufactured, the equipment to be used, the schedule, etc. are input to the schedule sheet 20 generated based on the template information 141. The schedule sheet 20 will be described in detail later.
[0021] The product DB 142 stores the process for each product and includes a product master corresponding to each product.
[0022] Fig. 2 is a diagram showing an example of a product master 1421. The product master 1421 shown in Fig. 2 shows the processes of a product named "KC1", the processing time for each process, and the equipment.
[0023] The "Process Name" column shows information for identifying the process. Figure 2 shows that the following processes are required to manufacture the product "KC1", namely "Process 1", "Process 2", "Process 3", "Process 4", "Process 5", "Process 6", "Process 7", "Thickness Finish", "Lapping and Measurement", "Process 8", "Process 9", and "Chamfering".
[0024] The "Time (Equipment A)" and "Time (Equipment B)" columns show the time required for each process for each type of equipment (Equipment A, Equipment B). The equipment is classified as either "Equipment A" or "Equipment B". The unit of time is days.
[0025] The columns "Priority=1" through "Priority=11" indicate the equipment for which each priority has been set.
[0026] For example, Figure 2 shows that the time required for "Process 1" is "3 days" regardless of whether the type of equipment is "Equipment A" or "Equipment B." Figure 2 also shows that "Process 1" is performed by equipment such as "A76," "A77," and "A140."
[0027] For example, Figure 2 shows that the time required for "Process 3" is "9 days" if the equipment type is "Equipment A," and "7 days" if the equipment type is "Equipment B." Figure 2 also shows that "Process 3" is performed by equipment such as "B1," "A76," and "A77."
[0028] Fig. 3 is a diagram showing an example of a product master 1422. The product master 1422 shown in Fig. 3 shows the processes of a product named "KC2", the processing time for each process, and the equipment.
[0029] The information indicated in each column of the product master 1422 is similar to the information indicated in each column of the product master 1421.
[0030] For example, Figure 3 shows that the time required for "Process 1" is "4 days" regardless of whether the type of equipment is "Equipment A" or "Equipment B." Figure 3 also shows that "Process 1" is performed by equipment such as "A76," "A77," and "A140."
[0031] For example, Figure 3 shows that the time required for "Process 3" is "9 days" if the equipment type is "Equipment A," and "7.5 days" if the equipment type is "Equipment B." Figure 3 also shows that "Process 3" is performed by equipment such as "B1," "A76," and "A77."
[0032] The equipment DB 143 stores the type of each piece of equipment. The equipment DB 143 includes an equipment master 1431.
[0033] Fig. 4 is a diagram showing an example of the facility master. As shown in Fig. 4, the facility master 1431 indicates the type of each facility. For example, Fig. 4 indicates that the type of facility "A77" is "A equipment."
[0034] The actual results DB 144 stores the start date / time and end date / time of each process displayed on the schedule sheet 20. The start date / time and end date / time of each process displayed on the schedule sheet 20 may be manually or automatically corrected according to the actual progress of the process. For example, if a process is delayed from its initial end date / time, the end date / time may be corrected, and the start date / time and end date / time of the process following the process may also be corrected. When the start date / time and end date / time are corrected, the actual results DB 144 stores both the start date / time and end date / time before and after the correction. The actual results DB 144 also stores the actual start date / time and end date / time.
[0035] Returning to Fig. 1, the control unit 15 is an arithmetic processing device. The arithmetic processing device includes, but is not limited to, a central processing unit (CPU), a system-on-a-chip (SoC), a micro control unit (MCU), a field-programmable gate array (FPGA), and a coprocessor. The control unit 15 can comprehensively control the operation of the information providing device 10 to realize various functions.
[0036] Specifically, the control unit 15 can execute instructions included in the program stored in the storage unit 14 while referring to the information stored in the storage unit 14 as necessary. The control unit 15 can then control the functional units in accordance with the data and instructions, thereby achieving various functions.
[0037] The control unit 15 includes a display control unit 151 , a schedule calculation unit 152 , and an overlapping equipment identification unit 153 .
[0038] The display control unit 151 displays a screen on a display or the like via the output unit 13. The display control unit 151 also controls the display of the schedule sheet 20. The display control unit 151 functions as a first display control unit and a second display control unit.
[0039] 5 is a diagram showing an example of the schedule sheet 20. First, the display control unit 151 displays the schedule sheet 20 based on the template information 141. Then, the display mode of the schedule sheet 20 is changed according to the input or processing result.
[0040] 5, the schedule sheet 20 may display an add product button 211, a product input area 212, a production quantity input area 213, an add month button 214, a number of days input area 215, a schedule table 22, a delete button 221, and a duplicate equipment button 231. The display control unit 151 functioning as a first display control unit and a second display control unit controls the display of the schedule table 22.
[0041] The schedule calculation unit 152 calculates the start date and time and the end date and time of the process based on the information entered in the schedule sheet 20 and the equipment DB 143.
[0042] The overlapping equipment identifying unit 153 identifies that the same equipment is assigned to the same date and time in the schedule table 22. Note that there is a restriction that each equipment cannot be used in multiple processes at the same time.
[0043] The processes of the display control unit 151, the schedule calculation unit 152, and the overlapping equipment identification unit 153 will be described in detail with reference to FIG. 6 to FIG.
[0044] Fig. 6 is a flowchart showing the flow of the product addition process. When the product addition button 211 is pressed in a state in which the product input area 212 and the production quantity input area 213 in Fig. 5 are filled in, the display control unit 151 starts the product addition process.
[0045] The product input area 212 is a drop-down list that displays, in a selectable manner, a list of products registered in the product master in the product DB 142. The production quantity input area 213 is a text box in which a numerical value can be input.
[0046] 6, the display control unit 151 accepts a product specification and an operation to add a product (pressing the product addition button 211) (step S101). The display control unit 151 accepts the product specification by reading input values in the product input area 212 and the production quantity input area 213.
[0047] Next, the display control unit 151 refers to the product DB 142 and acquires a process corresponding to the specified product (step S102). The display control unit 151 adds a row corresponding to the acquired process to the schedule sheet 20 (step S103).
[0048] For example, the display control unit 151 adds and displays rows of "Process 1", "Process 2-1", "Process 2-2", "Process 3", "Process 4", "Process 5", "Process 6", "Thickness Finish", "Lapping / Measurement", "Process 7", "Process 8", "Process 9", and "Chamfering", which are processes corresponding to the product "KC2", in the first to thirteenth rows of the schedule table 22 in Fig. 5. In this way, the display control unit 151 displays the processes corresponding to the specified product in the first column of the schedule table 22.
[0049] Moreover, when the delete button 221 is pressed, the display control unit 151 deletes the row of the process of the corresponding product.
[0050] Fig. 7 is a flow chart showing the flow of the month addition process. When the add month button 214 is pressed with the number of days input area 215 in Fig. 5 filled in, the display control unit 151 starts the month addition process.
[0051] The number of days input area 215 is a drop-down list that displays, in a selectable manner, candidates for the number of days of the date and time to be added on a monthly basis: "28th," "30th," and "31st."
[0052] 7, the display control unit 151 accepts an operation to specify the number of days and add a month (pressing the add month button 214) (step S201). The display control unit 151 accepts the specification of the number of days by reading an input value in the number of days input area 215.
[0053] Next, the display control unit 151 adds columns corresponding to the specified number of days to the schedule sheet (step S202). For example, the display control unit 151 adds columns corresponding to the 1st to 31st days of the month included in "May" in the schedule table 22 in FIG. 5, and displays them.
[0054] Fig. 8 is a flowchart showing the flow of the schedule calculation process. First, the display control unit 151 receives input of equipment corresponding to a process and a start date and time (step S301). For example, the display control unit 151 receives input of the "equipment" column and the "start date and time" column of the schedule table 22 in Fig. 5. Note that the display control unit 151 may receive the start date and time only for the first process of each product.
[0055] Next, the schedule calculation unit 152 acquires the number of processing days corresponding to the equipment from the equipment DB 143 (step S302), and calculates the start date and time and the end date and time of each process (step S303).
[0056] The display control unit 151 displays the equipment in the range from the start date and time to the end date and time in the row corresponding to the process (step S304), and also displays the calculated end date and time (step S305).
[0057] The schedule calculation process will be described using the row corresponding to "KC2 #255" in the schedule table 22 as an example. First, the display control unit 151 displays the specified equipment in the "Equipment" column. For example, the display control unit 151 displays the equipment "A177" in a different column in the same row as "Process 1". Then, the display control unit 151 displays the calculation result "22 / 4 / 15" in the "End date and time" column.
[0058] The schedule calculation unit 152 refers to the equipment DB 143, identifies whether the type of each piece of equipment is "equipment A" or "equipment B", and then acquires the processing time from the product DB 142. The schedule calculation unit 152 acquires the end date and time by adding the acquired processing time to the start date and time.
[0059] Furthermore, the schedule calculation unit 152 performs a similar calculation by setting the end date and time as the start date and time of the next process. Also, if the number of days to stop is set for each process, the schedule calculation unit 152 sets the date and time obtained by adding the number of days to the end date and time of the previous process as the start date and time of the next process.
[0060] In this way, the display control unit 151 displays the equipment designated for the process in the same row as the process displayed in the first column in the second column different from the first column in which the process is displayed. Also, the schedule calculation unit 152 calculates the start date and time and the end date and time of the process displayed in the first column based on the designated date and time and the equipment displayed in the second column.
[0061] Furthermore, based on the start date and time and end date and time calculated by the schedule calculation unit 152, the display control unit 151 changes the display mode of the cell in the same row as the process displayed in the first column in the column of the schedule table 22 corresponding to each of the dates and times.
[0062] For example, the display control unit 151 changes the display mode of the column of dates and times corresponding to the start date and time "22 / 4 / 12" to the end date and time "22 / 4 / 15" in the row showing "Process 1." For example, the display control unit 151 shows the equipment name "A177" in the corresponding cell, and fills the cell with the color and pattern corresponding to the equipment.
[0063] 9 is a flowchart showing the flow of the overlap identification process. When the overlapping equipment button 231 is pressed, the overlapping equipment identification unit 153 starts the overlapping equipment identification process (step S401). Pressing the overlapping equipment button 231 is an example of an operation for identifying overlapping equipment. Note that the overlapping identification process may be set to be automatically performed every time an input is made, without pressing the overlapping equipment button 231.
[0064] The overlapping equipment identifying unit 153 identifies cells in which the same equipment is associated with different processes at the same date and time (step S402). That is, the overlapping equipment identifying unit 153 identifies that multiple processes that share the same equipment are associated with a column corresponding to one date and time in the schedule table 22.
[0065] For example, in the column corresponding to "Friday, April 22" in Fig. 5, there are multiple (two) rows corresponding to facility "B8." The overlapping facility identifying unit 153 identifies that such a cell exists.
[0066] Furthermore, the display control unit 151 causes information (for example, a row number) for identifying the cell itself, the row, or the column identified by the overlapping equipment identifying unit 153 to be displayed in a predetermined area (step S403).
[0067] As described above, the information providing device 10 includes a display control unit 151, a schedule calculation unit 152, and an overlapping equipment identification unit 153. The display control unit 151 displays a process corresponding to a specified product in a first column of the schedule table 22, and displays equipment specified for the process in the same row as the process displayed in the first column in a second column different from the first column. The schedule calculation unit 152 calculates the start date and time and the end date and time of the process displayed in the first column based on the specified date and time and the equipment displayed in the second column. The display control unit 151 changes the display mode of the cell in the same row as the process displayed in the first column in the column of the schedule table 22 corresponding to each date and time based on the start date and end date and time calculated by the schedule calculation unit 152. The overlapping equipment identification unit 153 identifies that a plurality of processes with common equipment are associated with a column corresponding to one date and time in the schedule table 22.
[0068] This enables the information providing device 10 to automatically identify that the same equipment is assigned to different processes at the same time.
[0069] (Other embodiments) The display control unit 151 may display, in the same row as the process displayed in the first column, the equipment with the highest preset priority among the equipment associated with the process. In this case, in the product addition process, the display control unit 151 displays, in the "Equipment" column, the equipment with the highest priority among the equipment of the process displayed in the "Process" column.
[0070] Furthermore, the display control unit 151 may display the equipment so that the overlapping equipment identification unit 153 does not identify overlapping. In this case, the display control unit 151 displays the equipment with the highest priority among the non-overlapping equipment at the same date and time. At this time, the display control unit 151 may display, for example, on a schedule sheet, a message indicating that the schedule has been changed. Furthermore, the display control unit 151 may notify a mobile terminal or the like owned by the user of this (for example, display a screen on the mobile terminal notifying that the schedule has been changed).
[0071] In addition, when the start date and time or end date and time of a process displayed in the first column is corrected, the display control unit 151 adds a row corresponding to the process displayed in the first column to the schedule table 22, and changes the display manner of the cells of the added row in the columns of the schedule table 22 corresponding to each of the dates and times based on the corrected start date and time and end date and time.
[0072] Furthermore, when the actual start date and time and end date and time of the process displayed in the first column are input, the display control unit 151 adds a row corresponding to the process displayed in the first column to the schedule table 22, and changes the display manner of the cells of the added row in the columns of the schedule table 22 corresponding to each of the dates and times based on the actual start date and time and end date and time.
[0073] In this way, the display control unit 151 displays the corrected start date / time and end date / time, and the start date / time and end date / time stored in the results DB in dedicated rows, respectively. This makes it easier for the user to grasp the situation by displaying the initial settings of the start date / time and end date / time of each process, the corrected state, and the results in parallel.
[0074] Furthermore, the display control unit 151 displays an alert when the end date and time of a process based on the results exceeds a preset delivery date. The display control unit 151 determines whether the end date and time exceeds the delivery date or not when the end date and time is calculated by the schedule calculation unit 152, when the end date and time is corrected, or when the results of the end date and time are input, and if it exceeds the delivery date, displays an alert by a message or the like.
[0075] The schedule calculation unit 152 calculates the start date and time and the end date and time of the process displayed in the first column based on the preset time interval between processes and the date and time when the equipment cannot be operated. This makes it possible to set a schedule that takes into account the time required to replace equipment and the time required for manual operation.
[0076] Although specific embodiments have been described in order to fully and clearly disclose the technology of the appended claims, the appended claims should not be limited to the above-described embodiments, but should be construed to embody all modifications and alternative configurations that may be made by those skilled in the art within the scope of the basic subject matter presented in this specification. [Explanation of symbols]
[0077] 10 Information provision device 11 Communications Department 12 Input section 13 Output section 14 Storage section 15 Control section 20 Schedule Sheet 22 Schedule Table 141 Template Information 142 Product DB 143 Equipment DB 144 Results DB 151 Display control unit 152 Schedule Calculation Department 153 Duplicate equipment identification department 211 Add Product Button 212 Product Entry Area 213 Production quantity input area 214 Add Month Button 215 Days input field 221 Erase button 231 Duplicate equipment button 1421, 1422 Product Master 1431 Facility Master
Claims
1. A first display control unit; A schedule calculation unit; A second display control unit; A duplicate equipment identification unit, the first display control unit causes a process corresponding to a designated product to be displayed in a first column of the table, and causes a facility designated for the process to be displayed in a second column different from the first column and in the same row as the process displayed in the first column; The schedule calculation unit is Calculate the start date and time and the end date and time of the process displayed in the first column based on the specified date and time and the equipment displayed in the second column; The second display control unit is changing a display mode of a cell in the same row as the process displayed in the first column in the column of the table corresponding to each of the dates and times based on the start date and time and the end date and time calculated by the schedule calculation unit; The duplicate equipment identification unit Identifying that a plurality of processes using a common piece of equipment are associated with a column corresponding to one date and time in the table; Information provision device.
2. 2. The information providing device according to claim 1, wherein the first display control unit displays, in the same row as a process displayed in the first column, equipment that has the highest pre-set priority among the equipment associated with the process.
3. 2. The information providing device of claim 1, wherein when the start date and time or end date and time of a process displayed in the first column is revised, the second display control unit adds a row corresponding to the process displayed in the first column to the table, and changes the display mode of a cell in the added row in the column of the table corresponding to each of the dates and times based on the revised start date and time and end date and time.
4. 2. The information providing device of claim 1, wherein when actual data for the start date and time and end date and time of the process displayed in the first column are input, the second display control unit adds a row corresponding to the process displayed in the first column to the table, and changes the display mode of a cell in the added row in the column of the table corresponding to each of the dates and times based on the start date and time and end date and time of the actual data.
5. The information providing device according to claim 4 , wherein the second display control unit displays an alert when an end date and time of the process based on the performance exceeds a predetermined delivery date.
6. 2. The information providing device according to claim 1, wherein the schedule calculation unit calculates the start date and time and the end date and time of the process displayed in the first column based on a preset time interval between processes and a date and time when the equipment cannot be operated.
7. Displaying a process corresponding to a designated product in a first column of a table, and displaying equipment designated for the process in a second column different from the first column in the same row as the process displayed in the first column; Calculate the start date and time and the end date and time of the process displayed in the first column based on the specified date and time and the equipment displayed in the second column; based on the calculated start date and time and end date and time, changing the display manner of the cell in the same row as the process displayed in the first column in the column of the table corresponding to each date and time; Identifying that a plurality of processes that share a common facility are associated with a column corresponding to one date and time in the table A method of providing information in which processing is performed by a computer.
8. Displaying a process corresponding to a designated product in a first column of a table, and displaying equipment designated for the process in a second column different from the first column in the same row as the process displayed in the first column; Calculate the start date and time and the end date and time of the process displayed in the first column based on the specified date and time and the equipment displayed in the second column; based on the calculated start date and time and end date and time, changing the display manner of the cell in the same row as the process displayed in the first column in the column of the table corresponding to each date and time; Identifying that a plurality of processes that share a common facility are associated with a column corresponding to one date and time in the table An information providing program that causes a computer to execute processing.
Citation Information
Patent Citations
Process control support device
JP2006338202A
