JP2013084297A - Work schedule creation device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To freely set a work pace at which each worker works for a certain period of time and easily and efficiently allocate works according to the set paces, in the case of creating a work schedule for multiple workers.SOLUTION: A setting unit 103 included in a work schedule creation device 100 deems each day of a month as a target day, and sets a target value of total work hours that are calculated by summing up flight hours for a time period from the first day of the month until a target day, for each crew. A selection unit 104 deems a day of a month as a target day from the first day to the last day of the month in order, calculates the total work hours of each of the crews for the time period from the first day of the month until the target day in the case of allocating a work to the crews on the target day, according to allocated work information 111 indicating works that have been already allocated to the respective crews, and selects a crew to which the work is allocated on the target day according to the result of the comparison of the actual total work hours and target total work hours of the crews for the time period from the first day of the month until the target day. It also adds the work allocated to the selected crew on the target day to the allocated work information 111.

Description

  The present invention relates to a work plan creation device and a program.

  2. Description of the Related Art Conventionally, there is an apparatus for creating a new crew member operation arrangement plan so as to eliminate a contradiction of a crew member operation plan caused by disturbance of train operation (see, for example, Patent Document 1). In addition, there is a device that changes the operation of a vehicle, a driver, and a crew member of a vehicle conductor to be used for a train when the train diagram is disturbed (see, for example, Patent Document 2). In addition, there is a device for improving the efficiency of creation work when creating a crew operation plan for assigning each crew member to each operating train or the like (see, for example, Patent Document 3).

JP 2006-79440 A JP 2007-45216 A Japanese Unexamined Patent Publication No. 7-77936

  With conventional devices, when creating a work plan for multiple workers, decide at what pace each worker should work within a certain period (for example, a month), and adjust accordingly. There has been a problem that it is difficult to assign work (for example, work leveling).

  In the present invention, for example, when creating a work plan for a plurality of workers, it is possible to arbitrarily determine at what pace each worker should work within a certain period of time and work according to that. The purpose of this is to perform the assignment of the data easily and efficiently.

The work plan creation device according to one aspect of the present invention is:
A work plan creation device that assigns a plurality of workers with predetermined work hours for a plurality of days,
For each of the plurality of workers, a database that stores work information indicating assigned work by a storage device;
Each of the plurality of days is a target day, and for each of the plurality of workers, the processing device uses the target value of the accumulated working hours obtained by accumulating the working hours from the first day to the target day of the plurality of days as a target working time. A setting section to be set;
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The total working time up to the target date when the system is assigned is calculated by the processing device, and the calculated total working time up to the target date is compared with the target working time up to the target date set by the setting unit by the processing device. Based on the comparison result, a worker who assigns work to the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned to the target day is stored in the database. A selection unit to be added to the information.

In one embodiment of the present invention,
The setting unit sets, for each of the plurality of workers, a target working time until the target day using a function having the number of days from the first day to the target day as a variable.

In one embodiment of the present invention,
The setting unit uses a linear function as the function.

In one embodiment of the present invention,
The database stores attribute information indicating a predetermined attribute for each of the plurality of workers by a storage device,
The setting unit uses a common function as the function for each worker who has a common attribute indicated by the attribute information stored in the database.

In one embodiment of the present invention,
A combination of work for two or more consecutive days among the plurality of days is predetermined as a work pattern,
If the work pattern of the period starting from the target date is unassigned, the selection unit sets the period as the target period, and for each of the plurality of workers, from the work information stored in the database to the target date Instead of the cumulative working hours, the cumulative working hours until the end of the target period when the work pattern is assigned to the target period is calculated, and the total working hours until the end of the calculated target period are set by the setting unit. Compared to the target working hours until the end of the target period, based on the comparison result, select the worker who assigns the work pattern to the target period from the plurality of workers, and for the selected worker, The work pattern assigned to the period is added to the work information stored in the database.

In one embodiment of the present invention,
The selection unit, as a worker who assigns work from the plurality of workers to the target day, works that does not exceed the target working time until the target date set by the setting unit as calculated by the setting unit. Select a person.

A program according to one aspect of the present invention is:
A program for assigning work to a plurality of workers with a predetermined working time for multiple days,
For each of the plurality of workers, a computer comprising a database for storing work information indicating assigned work by a storage device,
Each of the plurality of days is a target day, and for each of the plurality of workers, the processing device uses the target value of the accumulated working hours obtained by accumulating the working hours from the first day to the target day of the plurality of days as a target working time. A setting section to be set;
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The total working time up to the target date when the system is assigned is calculated by the processing device, and the calculated total working time up to the target date is compared with the target working time up to the target date set by the setting unit by the processing device. Based on the comparison result, a worker who assigns work to the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned to the target day is stored in the database. It functions as a selection unit to be added to information.

The work plan creation device according to another aspect of the present invention is:
A work plan creation device that assigns work to multiple workers for multiple days,
For each of the plurality of workers, a database that stores work information indicating assigned work by a storage device;
Setting each of the plurality of days as a target day, and setting a target value of a cumulative value obtained by accumulating a predetermined evaluation index from the first day to the target day for each of the plurality of workers by a processing device And
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The cumulative value up to the target date is assigned by the processing device, and the calculated cumulative value up to the target date is compared with the target value set by the setting unit up to the target date by the processing device. Based on the result, the worker who assigns work on the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned on the target day is added to the work information stored in the database. A selection unit.

  According to one aspect of the present invention, when creating a work plan for a plurality of workers, the worker is allowed to work at any pace within a certain period (that is, a plurality of days). (That is, the target working time) can be arbitrarily determined, and work can be allocated easily and efficiently in accordance with it.

FIG. 2 is a block diagram showing a configuration of a work plan creation device according to Embodiment 1. FIG. 3 is a diagram illustrating an example of a hardware configuration of a work plan creation device according to the first embodiment. 5 is a flowchart showing the operation of the work plan creation device according to Embodiment 1; 3 is a graph showing an example of assignment of work to workers in the first embodiment. 3 is a graph showing an example of assignment of work to workers in the first embodiment. 3 is a graph showing an example of assignment of work to workers in the first embodiment. FIG. 6 shows an example of work information in the first embodiment. FIG. 6 shows an example of work information in the first embodiment. FIG. 4 is a diagram illustrating an example of a work plan for a worker according to the first embodiment. FIG. 4 is a diagram illustrating an example of a work plan for a worker according to the first embodiment. FIG. 4 is a diagram illustrating an example of a work plan for a worker according to the first embodiment. The graph which shows an example of assignment of the work to the worker in the modification of Embodiment 1. The graph which shows an example of assignment of the work to the worker in the modification of Embodiment 1. FIG. 4 is a block diagram showing a configuration of a work plan creation device according to Embodiment 2. 10 is a graph showing an example of assignment of work to workers in the third embodiment. 10 is a graph showing an example of assignment of work to workers in the third embodiment. 10 is a graph showing an example of assignment of work to workers in the third embodiment. FIG. 14 shows an example of work information in the third embodiment. FIG. 10 is a diagram illustrating an example of a worker's work plan in the third embodiment. FIG. 10 is a diagram illustrating an example of a worker's work plan in the third embodiment. FIG. 10 is a diagram illustrating an example of a worker's work plan in the third embodiment.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings.

Embodiment 1 FIG.
FIG. 1 is a block diagram showing a configuration of a work plan creation apparatus 100 according to the present embodiment.

  In FIG. 1, a work plan creation device 100 is a device that assigns work that is determined in advance to a plurality of workers for a plurality of days, and includes a database 101, an input unit 102, a setting unit 103, and a selection unit 104. The output unit 105 is provided. In the present embodiment, the work plan creation device 100 works on an aircraft with a predetermined flight time (an example of working hours) for a month (an example of multiple days). It is assigned to (a cockpit crew or flight crew, an example of multiple workers). Here, a crew is a combination of one or more flights in a day, preferably a flight that starts from and arrives at the main base of the crew (the airport where the crew commutes). Suppose it ends. For example, a combination of a flight departing from airport A and arriving at airport B and a flight departing from airport B and arriving at airport A can be defined as one flight (work). In addition, for example, a combination of a flight that leaves airport A and arrives at airport B, a flight that leaves airport B and arrives at airport C, and a flight that leaves airport C and arrives at airport A is 1 It can be defined as one crew (work).

  The period for which work plan creation apparatus 100 is assigned to work is not limited to months, but (one) week, multiple weeks, multiple months, (single) year, multiple years, or any other period May be multiple days. Further, the work assigned by the work plan creation apparatus 100 is not limited to the crew on the aircraft, but may be the entire crew work including ground work, or the crew on a moving body other than an aircraft such as a train or a bus. It may also be a duty other than the crew on the moving body. The workers to be assigned to work by the work plan creation device 100 differ depending on what work is assigned by the work plan creation device 100. For example, if the work plan creation device 100 assigns a crew to a moving body, a crew member (for example, a driver) of the moving body becomes an assignment target. Moreover, even if the work plan creation device 100 assigns the crew to the aircraft as in the present embodiment, not only the crew but also CA (which is a cabin attendant or a flight attendant) is an assignment target. Also good.

  The work plan creation apparatus 100 includes hardware such as a processing device 191, a storage device 192, an input device 193, and an output device 194. The hardware is used by each part of the work plan creation apparatus 100. For example, the processing device 191 is used to perform calculation, processing, reading, writing, and the like of data and information in each unit of the work plan creation device 100. The storage device 192 is used to store the data and information. The input device 193 is used to input the data and information, and the output device 194 is used to output the data and information.

  The database 101 stores work information 111 and the like by the storage device 192. The contents of these information will be described later. The operations of the input unit 102, setting unit 103, selection unit 104, and output unit 105 will be described later.

  FIG. 2 is a diagram illustrating an example of a hardware configuration of the work plan creation apparatus 100.

  In FIG. 2, the work plan creation apparatus 100 is a computer, and includes an LCD 901 (Liquid / Crystal / Display), a keyboard 902 (K / B), a mouse 903, an FDD 904 (Flexible / Disk / Drive), and a CDD 905 (Compact / Disc / Disc). Drive) and a hardware device such as a printer 906 are provided. These hardware devices are connected by cables and signal lines. Instead of the LCD 901, a CRT (Cathode / Ray / Tube) or other display device may be used. Instead of the mouse 903, a touch panel, a touch pad, a trackball, a pen tablet, or other pointing devices may be used.

  The work plan creation device 100 includes a CPU 911 (Central Processing Unit) that executes a program. The CPU 911 is an example of a processing device 191. The CPU 911 includes a ROM 913 (Read / Only / Memory), a RAM 914 (Random / Access / Memory), a communication board 915, an LCD 901, a keyboard 902, a mouse 903, an FDD 904, a CDD 905, a printer 906, and an HDD 920 (Hard / Disk) via a bus 912. Connected with Drive) to control these hardware devices. Instead of the HDD 920, a flash memory, an optical disk device, a memory card reader / writer, or other recording medium may be used.

  The RAM 914 is an example of a volatile memory. The ROM 913, the FDD 904, the CDD 905, and the HDD 920 are examples of nonvolatile memories. These are examples of the storage device 192. The communication board 915, the keyboard 902, the mouse 903, the FDD 904, and the CDD 905 are examples of the input device 193. The communication board 915, the LCD 901, and the printer 906 are examples of the output device 194.

  The communication board 915 is connected to a LAN (Local / Area / Network) or the like. The communication board 915 is not limited to a LAN, but is an IP-VPN (Internet, Protocol, Private, Network), a wide area LAN, an ATM (Asynchronous / Transfer / Mode) network, a WAN (Wide / Area / Network), or the Internet. It does not matter if it is connected to. LAN, WAN, and the Internet are examples of networks.

  The HDD 920 stores an operating system 921 (OS), a window system 922, a program group 923, and a file group 924. The programs in the program group 923 are executed by the CPU 911, the operating system 921, and the window system 922. The program group 923 includes programs that execute the functions described as “˜units” in the description of the present embodiment. The program is read and executed by the CPU 911. The file group 924 includes data, information, and signal values described as “˜data”, “˜information”, “˜ID (identifier)”, “˜flag”, and “˜result” in the description of this embodiment. And variable values and parameters are included as items of “˜file”, “˜database”, and “˜table”. The “˜file”, “˜database”, and “˜table” are stored in a recording medium such as the RAM 914 or the HDD 920. Data, information, signal values, variable values, and parameters stored in a recording medium such as the RAM 914 and the HDD 920 are read out to the main memory and the cache memory by the CPU 911 via a read / write circuit, and extracted, searched, referenced, compared, and calculated. It is used for processing (operation) of the CPU 911 such as calculation, control, output, printing and display. During the processing of the CPU 911 such as extraction, search, reference, comparison, calculation, calculation, control, output, printing, and display, data, information, signal values, variable values, and parameters are temporarily stored in the main memory, cache memory, and buffer memory. Remembered.

  The arrows in the block diagrams and flowcharts used in the description of this embodiment mainly indicate input / output of data and signals. Data and signals are recorded in memory such as RAM 914, FDD904 flexible disk (FD), CDD905 compact disk (CD), HDD920 magnetic disk, optical disk, DVD (Digital Versatile Disc), or other recording media Is done. Data and signals are transmitted by a bus 912, a signal line, a cable, or other transmission media.

  In the description of the present embodiment, what is described as “to part” may be “to circuit”, “to device”, “to device”, and “to step”, “to process”, “to”. ~ Procedure "," ~ process ". That is, what is described as “˜unit” may be realized by firmware stored in the ROM 913. Alternatively, what is described as “˜unit” may be realized only by software, or only by hardware such as an element, a device, a board, and wiring. Alternatively, what is described as “to part” may be realized by a combination of software and hardware, or a combination of software, hardware and firmware. Firmware and software are stored as programs in a recording medium such as a flexible disk, a compact disk, a magnetic disk, an optical disk, and a DVD. The program is read by the CPU 911 and executed by the CPU 911. That is, the program causes the computer to function as “to part” described in the description of the present embodiment. Or a program makes a computer perform the procedure and method of "-part" described by description of this Embodiment.

  FIG. 3 is a flowchart showing the operation of the work plan creation device 100 (work plan creation method according to the present embodiment, program processing procedure according to the present embodiment).

  In step S101 of FIG. 3, the setting unit 103 sets each day of a certain month as a target day, and for each of n (n is an integer of 2 or more) crew C1 to Cn, from the first day of the month to the target day. The processing device 191 sets a target working time T up to the target day using a linear function y = ax + b (a is a real number greater than 0, b is a real number greater than or equal to 0) with the number of days as a variable x. Here, the target working time T is a target value of the cumulative working time U obtained by accumulating the flight time from the first day of the month to the target day. For example, since the setting unit 103 sets y = a + b when the first day of the month is the target day, all the target working hours T up to the target day are (a + b) hours for each of the n crews C1 to Cn. Set. Further, for example, when the 15th day of the month is set as the target day, the setting unit 103 has y = 15a + b, and therefore, for each of the n crews C1 to Cn, all the target working hours T up to the target day (15a + b ) Set the time.

  In step S101, the setting unit 103 may use a different function for each crew. In step S101, the setting unit 103 may use a function other than a linear function (for example, a step function) as a function having the number of days from the first day of the month to the target day as a variable. In addition, the setting unit 103 stores the target working time in advance in the storage device 192 in association with each day of the month, and reads the target working time corresponding to the target day from the storage device 192 instead of using the function. , It may be set as the target working time T until the target date. Moreover, the setting part 103 may set the target working time T to a target day for every crew as a target day instead of setting all the days of a month as a target day. In this case, only the working day of the month is set as the target day for each crew even after step S102 described later. A specific example will be described later.

  In step S102 of FIG. 3, the input unit 102 uses the input device 193 to perform an operation of designating a crew to be assigned work on the target day from n crews C1 to Cn, with any day in the month as the target day. Accept from. Then, the input unit 102 adds the work assigned to the target day to the work information 111 stored in the database 101 for the crew specified by the operation. Here, the work information 111 is information indicating assigned work for each of the n crews C1 to Cn.

  In step S102, work assignments that exceed the target work time T up to the target date set by the setting unit 103 in step S101 are also permitted.

  In step S102, when two or more work days are planned on the target day, the input unit 102 targets any work among the work, and from n crews C1 to Cn, An operation for specifying a crew to be assigned to the target work is received from a user or the like.

  Step S102 may be omitted.

  In step S103 of FIG. 3, the selection unit 104 sequentially sets the target day from the first day to the last day of the month. If the work on the target day (at least one work if two or more work is planned on the target day) is not assigned, the process proceeds to step S104. If work on the target day is assigned and the target day is not the last day of the month, the next day of the target day is set as the target day. If the work on the target day is already assigned and the target day is the last day of the month, the process proceeds to step S107.

  In step S104 of FIG. 3, the selection unit 104 assigns a work day (unassigned) to the target day from the work information 111 stored in the database 101 for each of the n crews C1 to Cn. The accumulated working time U is calculated by the processing device 191. Specifically, for each of the n crew members C1 to Cn, the selection unit 104 displays the assigned work hours of flight indicated by the work information 111 stored in the database 101 for work before the work on the target day. The total is further added to the result, and the flight time of work on the target day is added to obtain the cumulative work time U up to the target day.

In step S104, the selection unit 104 may omit the calculation of the accumulated working time U for a crew that satisfies a predetermined condition. In other words, arbitrary restrictions may be added with respect to work assignment targets. In this case, the crew for which the calculation of the accumulated working time U is omitted (corresponding to the restriction) is excluded from the assignment of work on the target day. Here, examples of the predetermined condition include the following.
-The target date is set in advance as a vacation acquisition date.
-The number of consecutive working days is greater than or equal to a predetermined threshold.
-Another work has been assigned on the target day.
-The work to be assigned is not available for a certain time (for example, 14 hours) from the last work.
The last work is a specific work A, and the work to be assigned is not available for a certain time (for example, 20 hours) from the last work A.
The last work is a specific work A, the work to be assigned is a specific work B, and the work B to be assigned is not available for a certain time (for example, 10 hours) from the last work A.
・ The location of work immediately before and the location of work being assigned are not the same.

  In step S105 in FIG. 3, the selection unit 104 determines, for each of the n crews C1 to Cn, the accumulated work time U up to the target date calculated in step S104 and the target date set by the setting unit 103 in step S102. The target working time T is compared by the processing device 191. Then, the selection unit 104 determines, for each of the n crews C1 to Cn, whether or not the accumulated working time U until the target date exceeds the target working time T until the target date.

  In step S106 in FIG. 3, the selection unit 104 selects the crew members C1 to Cn from n crews as working crews on the target day. In step S105, the cumulative working time U up to the target day is the target working time T up to the target day. The processing device 191 selects a crew that has been determined not to exceed. Then, the selection unit 104 adds the work assigned to the target day for the selected crew to the work information 111 stored in the database 101, and returns to step S103.

  In step S106, when two or more working hours are planned on the target day, if unassigned work remains after the selection unit 104 adds one of them to the work information 111, the target Regardless of whether the day is the last day of the month, the process returns to step S103. Then, steps S103 to S106 are executed for another work on the same target day.

  In Step S106, when there are two or more crews that have determined that the cumulative working time U up to the target date does not exceed the target working time T up to the target date in Step S105, the selection unit 104 uses an arbitrary method. Select one of them. For example, the selection unit 104 selects a crew having a minimum value (here, 0 or a negative value) obtained by subtracting the target working time T until the target date from the cumulative working time U until the target date. This makes it possible to level work within the month. When there are a plurality of corresponding crews (the above value is minimum), the selection unit 104 further selects one crew according to other criteria. Alternatively, the selection unit 104 randomly selects one crew member. Alternatively, the selection unit 104 causes a user or the like to designate one crew member. In this case, the output unit 105 first displays a list of two or more candidate crews using the output device 194. The input unit 102 receives an operation for designating one of them from the user or the like using the input device 193. Then, the selection unit 104 selects a crew designated by the operation.

  In step S <b> 106, the selection unit 104 uses an arbitrary method even when no crew has determined that the cumulative working time U up to the target date does not exceed the target working time T up to the target date in step S <b> 105. Select one crew member. As described above, for example, the selection unit 104 selects a crew that has a minimum value (here, a positive value) obtained by subtracting the target working time T until the target date from the cumulative working time U until the target date. select. This makes it possible to level work within the month. When there are a plurality of corresponding crews (the above value is minimum), the selection unit 104 further selects one crew according to other criteria. Alternatively, the selection unit 104 randomly selects one crew member. Alternatively, the selection unit 104 causes a user or the like to designate one crew member.

  In steps S105 and S106, instead of selecting a crew whose accumulated working time U up to the target date does not exceed the target working time T up to the target date, the selection unit 104 calculates the target date from the cumulative working time U up to the target date. You may select the crew from which the value which subtracted the target working time T until becomes the minimum or becomes below a predetermined threshold value. Alternatively, the selection unit 104 may select a crew according to another criterion.

  In step S107 of FIG. 3, the output unit 105 refers to the work information 111 stored in the database 101, and displays a crew schedule (an example of a work plan) for n crew members C1 to Cn in the month in a calendar format or the like. The data is output by the output device 194.

  Note that the order in which steps S101 to S107 are executed may be changed as appropriate. For example, step S101 may be executed after step S102. Alternatively, step S101 may be executed between steps S103 and S105. In this case, step S101 is executed for each target day as in step S104. That is, in step S104, the selection unit 104 calculates the cumulative working time U until the target date in step S103. In step S101, the setting unit 103 sets the target working time T until the target date in step S103. Set.

  Below, the specific example of operation | movement of step S101-107 is demonstrated.

  In this example, the work plan creation apparatus 100 creates a crew schedule for three crews C1 to C3 in September 2011. In September 2011, it is assumed that daily work W1 with a flight time of 6 hours and work W2 with a flight time of 4 hours are planned every day.

  In this example, it is assumed that the function y = 4x in step S101 is commonly set for the three crew members C1 to C3.

  FIG. 4 is a graph showing assignment of work to the crew C1 in this example. FIG. 5 is a graph showing assignment of work to the crew C2 in this example. FIG. 6 is a graph showing assignment of work to the crew C3 in this example.

  4 to 6, the vertical axis indicates the cumulative value of the flight time, and the horizontal axis indicates the number of days (x) from September 1, 2011. The straight line graph (y = 4x) represents the target working time T (the target value of the cumulative value of the flight time up to each day) for each crew on September 1 to 30, 2011. The bar graph represents work assigned to each crew on September 1 to 30, 2011. The height from the top to the bottom of the bar graph represents the working hours assigned to the corresponding day, and the height (position) of the top side of the bar graph is the cumulative working hours assigned to the corresponding day. Represents a value.

  In step S101, the setting unit 103 sets the target working times T of the crews C1 to C3 on September 1 to 30, 2011 using the function y = 4x, as shown in FIGS. The target working time T of the crews C1 to C3 until September 1, 2011 is 4 × 1 = 4 hours, and the target working time T of the crews C1 to C3 until September 2, 2011 is 4 × 2 = 8 hours, ..., the target working time T of the crews C1 to C3 until September 30, 2011 is 4 × 30 = 120 hours.

  7 and 8 are diagrams showing work information 111 in this example.

  7 and 8, work information 111 includes crew (crew identifier), date, duty (work identifier), flight (information on one or more flights on which the crew is on board), and flight time (on which the crew is on board). The data is stored in the database 101 as a table for storing data such as the total flight time of flights.

  In step S102, the input unit 102 receives, for example, an operation for designating the crew C1 from the user as a crew to which work W1 is assigned on September 1, 2011. Then, as shown in (1) of FIG. 7, the input unit 102 stores the work information 111 stored in the database 101 with the work W1 assigned on September 1, 2011 for the crew C1 designated by the operation. Add to

  In step S103, the selection unit 104 sets September 1, 2011 as the target day, and proceeds to step S104.

  In step S <b> 104, the selection unit 104 selects crew C <b> 1 to C <b> 3 until September 1, 2011 when unassigned work W <b> 2 is assigned on September 1, 2011 from the work information 111 stored in the database 101. Cumulative working time U is calculated. At this time, since the work W1 on September 1, 2011 is assigned to the crew C1, the selection unit 104 can assign both the work W1 and the work W2 on September 1, 2011 to the same crew ( For example, the cumulative working hours of Crew C1 until September 1, 2011 when working W2 is assigned on September 1, 2011 only when it is determined that the times do not overlap. U is calculated. When working W2 is assigned on September 1, 2011, the cumulative working time U of crew C1 until September 1, 2011 is the flight time of work W1 on September 1, 2011 and the flight time of work W2. That is, 6 + 4 = 10 hours. On the other hand, when working W2 is assigned on September 1, 2011, the cumulative working time U of crew C2, C3 until September 1, 2011 is the flight time of working W2 on September 1, 2011, that is, 4 hours. Note that the selection unit 104 may not unconditionally assign a work for a crew that has already been assigned another work on the target day, that is, may not calculate the cumulative work time U up to the target day.

  In step S105, the selection unit 104 determines, for each of the crews C1 to C3, the cumulative working time U calculated in step S104 until September 1, 2011 and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When working W2 is assigned on September 1, 2011, the cumulative working time U of crew C1 until September 1, 2011 is 10 hours, and the target working time T of crew C1 by September 1, 2011 Longer than 4 hours. On the other hand, when working W2 is assigned on September 1, 2011, the cumulative working time U of crew C2 and C3 until September 1, 2011 is 4 hours, and crew C2 until September 1, 2011 It is shorter than the target working time T of C3, which is 4 hours.

  In step S <b> 106, the output unit 105 displays a list of crews C <b> 2 and C <b> 3 whose cumulative working time U until September 1, 2011 does not exceed the target working time T until September 1, 2011 on the screen. For example, the input unit 102 receives an operation of designating the crew C2 from the user. The selection unit 104 selects the crew C2 designated by the operation as a crew to which work W2 is assigned on September 1, 2011. As illustrated in (2) of FIG. 7, the selection unit 104 adds the work W2 assigned on September 1, 2011 for the selected crew C2 to the work information 111 stored in the database 101. Then, the process returns to step S103. In step S106, for example, the selection unit 104 may randomly select one of the crews C2 and C3.

  In step S103, since all the work W1 and W2 on September 1, 2011 have been assigned, the selection unit 104 sets the target date as September 2, 2011, and proceeds to step S104.

  In step S104, the selection unit 104 determines the cumulative working hours of the crews C1 to C3 from the work information 111 stored in the database 101 to September 2, 2011 when work W1 is assigned on September 2, 2011. U is calculated. Since the work W1 on September 1, 2011 is assigned to the crew C1, the cumulative work time U of the crew C1 up to September 2, 2011 when the work W1 is assigned on September 2, 2011 is 6 + 6 = 12 hours. Since the work W2 on September 1, 2011 is assigned to the crew C2, the cumulative working time U of the crew C2 up to September 2, 2011 when the work W1 is assigned on September 2, 2011 is 4 + 6 = 10 hours. When work W1 is assigned on September 2, 2011, the cumulative work time U of crew C3 until September 2, 2011 is 6 hours.

  In step S105, the selection unit 104 determines, for each of the crews C1 to C3, the accumulated work time U until September 2, 2011 calculated in step S104 and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When work W1 is assigned on September 2, 2011, the cumulative working time U of crew C1 until September 2, 2011 is 12 hours, and the target working time T of crew C1 until September 2, 2011 Longer than 8 hours. When work W1 is assigned on September 2, 2011, the cumulative working time U of crew C2 until September 2, 2011 is 10 hours, and the target working time T of crew C2 by September 2, 2011 Longer than 8 hours. When work W1 is assigned on September 2, 2011, the cumulative working time U of crew C3 until September 2, 2011 is 6 hours, and the target working time T of crew C3 by September 2, 2011 It is shorter than 8 hours.

  In step S <b> 106, the selection unit 104 selects the crew C <b> 3 whose cumulative working time U up to September 2, 2011 does not exceed the target working time T up to September 2, 2011. As illustrated in (3) of FIG. 7, the selection unit 104 adds the work W1 assigned on September 2, 2011 for the selected crew C3 to the work information 111 stored in the database 101. Then, the process returns to step S103.

  In step S103, since the work W2 on September 2, 2011 has not been assigned, the selection unit 104 continues to step S104 on September 2, 2011 as the target day.

  In step S104, the selection unit 104 determines the cumulative working hours of the crews C1 to C3 from the work information 111 stored in the database 101 to September 2, 2011 when work W2 is assigned on September 2, 2011. U is calculated. Since the work W1 on September 1, 2011 is assigned to the crew C1, the cumulative working time U of the crew C1 up to September 2, 2011 when the work W2 is assigned on September 2, 2011 is 6 + 4 = 10 hours. Since the work W2 on September 1, 2011 is assigned to the crew C2, the cumulative work time U of the crew C2 up to September 2, 2011 when the work W2 is assigned on September 2, 2011 is 4 + 4 = 8 hours. Since the work W1 on September 2, 2011 is assigned to the crew C3, the cumulative work time U of the crew C3 up to September 2, 2011 when the work W2 is assigned on September 2, 2011 is 6 + 4 = 10 hours.

  In step S105, the selection unit 104 determines, for each of the crews C1 to C3, the accumulated work time U until September 2, 2011 calculated in step S104 and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When work W2 is assigned on September 2, 2011, the total working time U of crew C1, C3 up to September 2, 2011 is 10 hours, and crew C1, C3 up to September 2, 2011 The target working time T is longer than 8 hours. When working W2 is assigned on September 2, 2011, the cumulative working time U of Crew C2 until September 2, 2011 is 8 hours, and the target working time T of Crew C2 by September 2, 2011 It is the same as 8 hours.

  In step S <b> 106, the selection unit 104 selects a crew C <b> 2 whose cumulative working time U up to September 2, 2011 does not exceed the target working time T up to September 2, 2011. The selection unit 104 adds the work W2 assigned on September 2, 2011 to the work information 111 stored in the database 101 for the selected crew C2, as shown in (4) of FIG. Then, the process returns to step S103.

  In step S103, since all of the work W1 and W2 on September 2, 2011 have already been assigned, the selection unit 104 proceeds to step S104 with September 3, 2011 as the target day.

  In step S104, the selection unit 104 determines the cumulative working hours of the crews C1 to C3 from the work information 111 stored in the database 101 to September 3, 2011 when work W1 is assigned on September 3, 2011. U is calculated. When work W1 is assigned on September 3, 2011, the cumulative work time U of the crew C1 until September 3, 2011 is 6 + 6 = 12 hours. When work W1 is assigned on September 3, 2011, the cumulative work time U of crew C2 until September 3, 2011 is 4 + 4 + 6 = 14 hours. When work W1 is assigned on September 3, 2011, the cumulative work time U of the crew C3 until September 3, 2011 is 6 + 6 = 12 hours.

  In step S105, the selection unit 104 determines, for each of the crews C1 to C3, the cumulative working time U calculated in step S104 until September 3, 2011, and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When work W1 is assigned on September 3, 2011, the total working time U of crew C1, C3 up to September 3, 2011 is 12 hours, and crew C1, C3 up to September 3, 2011 This is the same as the target working time T of 12 hours. When working W1 is assigned on September 3, 2011, the cumulative working time U of crew C2 until September 3, 2011 is 14 hours, and the target working time T of crew C2 by September 3, 2011 It is longer than 12 hours.

  In step S <b> 106, the output unit 105 displays a list of crews C <b> 1 and C <b> 3 whose cumulative working time U until September 3, 2011 does not exceed the target working time T until September 3, 2011 on the screen. For example, the input unit 102 receives an operation for designating the crew C1 from the user. The selection unit 104 selects the crew C1 designated by the operation as a crew to which work W1 is assigned on September 3, 2011. As illustrated in (5) of FIG. 8, the selection unit 104 adds the work W1 assigned on September 3, 2011 to the work information 111 stored in the database 101 for the selected crew C1. Then, the process returns to step S103. In step S106, for example, the selection unit 104 may randomly select one of the crews C1 and C3.

  In step S103, since the work W2 on September 3, 2011 is not assigned, the selection unit 104 continues to step S104 on September 3, 2011 as the target day.

  In step S <b> 104, the selection unit 104 determines the cumulative working hours of the crews C <b> 1 to C <b> 3 until September 3, 2011 when work W <b> 2 is assigned on September 3, 2011 from the work information 111 stored in the database 101. U is calculated. When work W2 is assigned on September 3, 2011, the cumulative work time U of the crew C1 until September 3, 2011 is 6 + 6 + 4 = 14 hours. When work W2 is assigned on September 3, 2011, the cumulative work time U of the crew C2 until September 3, 2011 is 4 + 4 + 4 = 12 hours. When working W2 is assigned on September 3, 2011, the cumulative working time U of the crew C3 up to September 3, 2011 is 6 + 4 = 10 hours.

  In step S105, the selection unit 104 determines, for each of the crews C1 to C3, the cumulative working time U calculated in step S104 until September 3, 2011, and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When work W2 is assigned on September 3, 2011, the total working time U of crew C1 until September 3, 2011 is 14 hours, and the target working time T of crew C1 until September 3, 2011 It is longer than 12 hours. When working W2 is assigned on September 3, 2011, the cumulative working time U of Crew C2 until September 3, 2011 is 12 hours, and the target working time T of Crew C2 by September 3, 2011 It is the same as 12 hours. When working W2 is assigned on September 3, 2011, the cumulative working time U of Crew C3 until September 3, 2011 is 10 hours, and the target working time T of Crew C3 by September 3, 2011 Shorter than 12 hours.

  In step S106, the selection unit 104 determines that the value obtained by subtracting the target working time T until September 3, 2011 from the cumulative working time U until September 3, 2011 (here, -2 hours) is the minimum. Select Crew C3. As illustrated in (6) of FIG. 8, the selection unit 104 adds the work W2 assigned on September 3, 2011 for the selected crew C3 to the work information 111 stored in the database 101. Then, the process returns to step S103. In step S106, for example, the selection unit 104 may randomly select one of the crews C2 and C3, or may cause the user or the like to specify it.

  Thereafter, similarly, Steps S103 to S106 are repeatedly executed, and as shown in FIGS. 4 to 6, the respective work W1 and W2 of September 4 to 30, 2011 are assigned to the crews C1 to C3. The result is reflected in the work information 111 stored in the database 101.

  FIG. 9 is a diagram illustrating the crew schedule of the crew C1 in this example. FIG. 10 is a diagram showing the crew schedule of crew C2 in this example. FIG. 11 is a diagram showing a crew schedule of crew C3 in this example.

  In step S107, as shown in FIGS. 9 to 11, the output unit 105 refers to the work information 111 stored in the database 101, and outputs the crew schedule of crew C1 to C3 in September 2011 in a calendar format. To do.

  Note that, under the same conditions as in this example, it is possible to assign work differently from the crew schedule shown in FIGS. That is, a crew schedule different from those shown in FIGS. 9 to 11 can be created. In this example, it is assumed that every day, a work W1 with a flight time of 6 hours and a work W2 with a flight time of 4 hours are planned, but the number of planned work and the flight time are planned. Even if it differs from day to day, the present embodiment can be applied.

  As described above, in step S101, the setting unit 103 sets each of a plurality of days as the target day, and for each of the plurality of workers, the accumulated working hours obtained by accumulating the working hours from the first day of the plurality of days to the target day. The target value is set as the target working time. Thereby, it is possible to arbitrarily determine at what pace each worker works within a certain period. In the present embodiment, the setting unit 103 sets a target working time until the target day using a function with the number of days from the first day to the target day as a variable for each of the plurality of workers. Within a certain period, work can be leveled reliably and easily.

  In steps S103 to S106, the selection unit 104 sequentially sets the target days from the first day to the last day of a plurality of days. If the work on the target day is unassigned, the selection unit 104 calculates, for each of a plurality of workers, cumulative work from the work information 111 stored in the database 101 to the target day when work is assigned on the target day. Calculate time. The selection unit 104 compares the calculated cumulative working time up to the target date with the target working time up to the target date set by the setting unit 103. Based on the comparison result, the selection unit 104 selects a worker who assigns work on the target day from a plurality of workers. Then, the selection unit 104 adds the work assigned to the target day for the selected worker to the work information 111 stored in the database 101. This makes it possible to easily and efficiently assign work according to the pace at which each worker works (determined arbitrarily by the setting unit 103).

  Here, in the specific example of the operation in steps S101 to S107 described above, a modified example in which only the working day of the month is the target date will be described for each crew instead of setting all days of the month as target days. Note that description of points that overlap with the above-described example may be omitted.

  In this example, it is assumed that the function y = 5x + 2 in step S101 is set for the crew C1. A description of crew C2, C3 is omitted.

  12 and 13 are graphs showing assignment of work to the crew C1 in this example.

  In FIG. 12, the vertical axis represents the cumulative value of flight time, and the horizontal axis represents the number of working days (x) from the first working day of the crew C1 in September 2011. The straight line graph (y = 5x + 2) represents the target working time T of the crew C1 on the working day of the crew C1 in September 2011 (the target value of the cumulative value of the flight time up to each day). The bar graph represents work assigned to the crew C1 on each working day of the crew C1 in September 2011. FIG. 13 is a diagram in which the working days in FIG. 12 are expanded to calendar days. That is, in FIG. 13, the vertical axis represents the cumulative value of the flight time, and the horizontal axis represents the number of calendar days from September 1, 2011. The line graph represents the target working time T (the target value of the cumulative value of the flight time up to each day) of the crew C1 from September 1 to 30, 2011. The bar graph represents work assigned to the crew C1 on September 1 to 30, 2011.

  In step S101, the setting unit 103 sets the target working time T of the crew C1 on the working day in September 2011 using the function y = 5x + 2, as shown in FIG. In other words, as shown in FIG. 13, the setting unit 103 deletes the non-working days from the calendar for September 2011, arranges the remaining working days in ascending order of the calendar days, sets the first day as the first day, and the last day as the first day. When the m-th day is set, a and b are determined so that a × m + b is a predetermined target value of the total working time of the crew C1 in a month, and the target working time T on the first day is a × 1 + b, Use a function that makes the target working time T until the non-working day equal to the target working time T up to the previous working day, and if the non-working day has no preceding working day, the target working time T is set to 0 hour. The target working time T of the crew C1 for September 1 to 30, 2011 is set. The target working time T of Crew C1 by September 1, 2011 (working day) is 5 × 1 + 2 = 7 hours, and the target working time T of Crew C1 by September 2, 2011 (non-working day) is 7 hours. ,..., The target working time T of the crew C1 until September 30, 2011 (working day) is 5 × 30 + 2 = 102 hours. In addition, although description is abbreviate | omitted, the setting part 103 sets the target working time T of crew C2, C3 in the working day of September 2011 similarly.

  In step S102, the input unit 102 receives, for example, an operation for designating the crew C1 from the user as a crew to which work W1 is assigned on September 1, 2011. Then, the input unit 102 adds the work W1 assigned on September 1, 2011 to the work information 111 stored in the database 101 for the crew C1 designated by the operation.

  In steps S <b> 103 to S <b> 106, the selection unit 104 sequentially sets September 1 to 30, 2011 as the target day. If the work on the target day is unassigned, the selection unit 104 works for the crew whose work day is the working day among the crews C1 to C3 from the work information 111 stored in the database 101. The cumulative working time U up to the target date when the is assigned is calculated. The selection unit 104 compares the calculated cumulative working time U until the target date with the target working time T until the target date set by the setting unit 103. Based on the comparison result, the selection unit 104 selects a crew to which work is assigned on the target day from crews whose target day is an operating day. Then, the selection unit 104 adds the work assigned to the target day to the work information 111 stored in the database 101 for the selected crew. Thereby, as shown in FIG.12 and FIG.13, work W1 or W2 is allocated to the crew C1 on each working day of the crew C1 in September 2011. The same applies to the crews C2 and C3.

  In step S107, the output unit 105 refers to the work information 111 stored in the database 101 and outputs the crew schedules of crews C1 to C3 in September 2011 in a calendar format.

  According to this example, it is possible to achieve leveling of the workload within the month of the crew focused on the working day and leveling of the workload between the crews. Here, for crews with long working hours in the previous month, the monthly workload can be leveled by reducing the target value of the working hours in the current month. In addition, the target value of the total working hours in the month is, for example, “predetermined standard value” (may differ for each crew or crew type, or may differ for each month) × 2− “previous month It can be determined in the form of “total working hours in month” = “target value of total working hours in the month”.

Embodiment 2. FIG.
In the present embodiment, differences from the first embodiment will be mainly described.

  FIG. 14 is a block diagram showing the configuration of the work plan creation apparatus 100 according to the present embodiment.

  14, the configuration of the work plan creation device 100 is the same as that of the first embodiment shown in FIG. 1, but in this embodiment, the database 101 includes attribute information 112 in addition to the work information 111. The data is stored by the storage device 192. The attribute information 112 is information indicating the type of crew (an example of a predetermined attribute) for each of the n crews C1 to Cn. Crew types include general, senior, and flight time limiters. The time that a senior can ride in the month (that is, the target value of the monthly flight time) is uniformly limited. The flight time limiter is individually limited in the time that can be ridden in the month.

  Hereinafter, the operation of the work plan creation apparatus 100 will be described with reference to FIG.

In step S101 in FIG. 3, the setting unit 103 sets a target working time T using a common function for each crew with a common crew type indicated by the attribute information 112 stored in the database 101. Specifically, the setting unit 103 refers to the attribute information 112 stored in the database 101 and determines whether each of the n crews C1 to Cn corresponds to a general, senior, or flight time limiter. . Then, the setting unit 103 sets each day in the month as a target day, and for a general crew, a linear function y = a ₁ x + b ₁ (a ₁ is 0) with the number of days from the first day of the month to the target day as a variable x. real number larger than, b ₁ is set by the processor 191 of the target service time T to the target date using a 0 or a real number). In addition, the setting unit 103 sets each day of the month as a target day, and for senior crew, the senior function for senior crew y = a ₂ x + b ₂ with the number of days from the first day of the month to the target day as a variable x. The target working time T up to the target date is set by the processing device 191 using (a ₂ is a real number greater than 0 and b ₂ is a real number greater than or equal to 0). At this time, for example, a ₁ > a ₂ is satisfied. Further, the setting unit 103 sets each day in the month as the target day, and for the flight time limiter, the linear function y = a ₃ for each flight time limiter having the variable x as the number of days from the first day of the month to the target day. The target working time T up to the target date is set by the processing device 191 using x + b ₃ (a ₃ is a real number greater than 0 and b ₃ is a real number greater than or equal to 0). At this time, a ₃ and b ₃ are individually set for each flight time limiter.

  The operations after step S102 in FIG. 3 are the same as those in the first embodiment.

  In the present embodiment, the attribute information 112 may be information indicating attributes other than the crew type. Also in this case, the setting unit 103 sets the target working time T using a common function for each crew that has the same attribute indicated by the attribute information stored in the database 101.

  According to the present embodiment, it is possible to easily and efficiently create a work plan that causes each worker to work at a pace corresponding to the attributes of the worker within a certain period.

Embodiment 3 FIG.
In the present embodiment, differences from the first embodiment will be mainly described.

  In this embodiment, a combination of work for a period of two or more consecutive days in a month is determined in advance as a work pattern. For example, a flight that departs from airport A and arrives at airport B is assigned to work on the first day, a flight that departs from airport B and arrives at airport A on the second day, and the combination of these two days of work. It can be defined as one work pattern. Also, for example, a flight departing from airport A and arriving at airport B is served on the first day, and there is no flight, but staying in the vicinity of airport B is served on the second day, leaving airport B. The flight arriving at the airport A can be defined as a third day work, and a combination of these three day work can be defined as one work pattern. The work assigned in units of one day may be defined as one work pattern (a work pattern for only one day).

  The configuration of the work plan creation device 100 according to the present embodiment is the same as that of the first embodiment shown in FIG.

  Hereinafter, the operation of the work plan creation apparatus 100 will be described with reference to FIG.

  The operations in steps S101 and S102 in FIG. 3 are the same as those in the first embodiment.

  In step S104 of FIG. 3, if the work pattern of the period starting from the target date is not assigned, the selection unit 104 sets that period as the target period. For each of the n crew members C1 to Cn, the selection unit 104 accumulates from the work information 111 stored in the database 101 to the date when the target period ends when a (unassigned) work pattern is assigned to the target period. The working time U is calculated by the processing device 191. Specifically, for each of the n crews C1 to Cn, the selection unit 104 is stored in the database 101 in a work before the work pattern of the target period (including a part of the work pattern). The flight hours of the assigned work indicated by the work information 111 are totaled, and the flight time of the work pattern of the target period is added to the result, and the cumulative work time U until the end of the target period is obtained.

  In step S105 in FIG. 3, the selection unit 104 sets the total working hours U until the end of the target period calculated in step S104 and the setting unit 103 in step S102 for each of the n crews C1 to Cn. The processing device 191 compares the target working time T until the end of the target period. Then, for each of the n crews C1 to Cn, the selection unit 104 determines whether or not the accumulated working time U until the end of the target period exceeds the target working time T until the end of the target period. Judgment by

  In step S105, the target period may extend over two months. That is, the day when the target period ends may be the day of the next month. Therefore, in step S102, the setting unit 103 sets target working times T for n crews C1 to Cn for the first several days from the first day of the next month as necessary.

  In step S106 in FIG. 3, the selection unit 104 determines the cumulative working hours U from the n crews C1 to Cn to assign work patterns to the target period until the end of the target period in step S105. The crew that has determined that the target working time T until the end date is not exceeded is selected by the processing device 191. At this time, if there are two or more corresponding crews (the cumulative working time U does not exceed the target working time T) or there is no one, the selecting unit 104 selects an arbitrary method as in the first embodiment. Use to select one crew. And the selection part 104 adds the work pattern allocated to the object period about the selected crew to the work information 111 memorize | stored in the database 101, and returns to step S103.

  The operation in step S107 in FIG. 3 is the same as that in the first embodiment.

  Below, the specific example of operation | movement of step S101-107 is demonstrated.

  In this example, the work plan creation apparatus 100 creates a crew schedule for three crews C1 to C3 in September 2011. In September 2011, work patterns P1 for 4 days are set every Tuesday to Friday (1st, 2nd, 6th-9th, 13th-16th, 20th-23rd, 27th-30th) Assume that it is planned. Also, every Thursday (1st, 8th, 15th, 22nd, 29th), work W1 with flight time of 4 hours, every Saturday and Sunday (3rd, 4th, 10th, 11th, 17th) , 18th, 24th, 25th) is scheduled to work 6 hours flight W2 and every Wednesday (7th, 14th, 21st, 28th days) work 8 hours flight W3 It shall be. Furthermore, every 4 days (2-4 days, 6-8 days, 10-12 days, 14-16 days, 18-20 days, 22-24 days, 26-28 days, 30 days ) It is assumed that a 3-day work pattern P2 is planned. The work pattern P1 is a work pattern in which there is a 12-hour flight on the first and fourth days, and no flight on the second and third days. The work pattern P2 is a work pattern in which there is a 6-hour flight on the first day, a 2-hour flight on the second day, and an 8-hour flight on the third day.

  In this example, it is assumed that the function y = 4x in step S101 is commonly set for the three crew members C1 to C3.

  FIG. 15 is a graph showing assignment of work to the crew C1 in this example. FIG. 16 is a graph showing assignment of work to the crew C2 in this example. FIG. 17 is a graph showing assignment of work to the crew C3 in this example.

  Similar to FIGS. 4 to 6, in FIGS. 15 to 17, the vertical axis indicates the cumulative value of the flight time, and the horizontal axis indicates the number of days (x) from September 1, 2011. The straight line graph (y = 4x) represents the target working time T (the target value of the cumulative value of the flight time up to each day) for each crew on September 1 to 30, 2011. The bar graph represents the work or work pattern assigned to each crew on September 1 to 30, 2011. The height from the top side to the bottom side of the bar graph represents the flight time of the work or work pattern assigned to the corresponding day or period, and the height (position) of the top side of the bar graph represents the work assigned to the corresponding day Or it represents the cumulative value of the flight time of the work pattern.

  In step S101, the setting unit 103 sets the target working times T of the crews C1 to C3 on September 1 to 30, 2011 using the function y = 4x as shown in FIGS. The target working time T of the crews C1 to C3 until September 1, 2011 is 4 × 1 = 4 hours, and the target working time T of the crews C1 to C3 until September 2, 2011 is 4 × 2 = 8 hours, ..., the target working time T of the crews C1 to C3 until September 30, 2011 is 4 × 30 = 120 hours.

  FIG. 18 is a diagram showing work information 111 in this example.

  In FIG. 18, the work information 111 includes crew (crew identifier), date, work pattern (work pattern identifier), work (one or more work identifiers), flight (not shown), flight time (crew Is stored in the database 101 as a table for storing data such as the total flight time of flights on which the passengers ride. Here, the work pattern of the work information 111 is assumed to be empty data (indicated as “−” in the figure) for work assigned in units of one day. As described above, when the work assigned in units of one day is defined as one work pattern (a work pattern of only one day), the work pattern of the work information 111 is also applied to the work assigned in units of one day. Will be recorded.

  In step S102, the input unit 102 performs, for example, an operation for designating the crew C1 from the user as a crew that assigns the work pattern P1 (actually starts from August 30, 2011) on September 1st and 2nd, 2011. Accept. Then, as shown in FIG. 18 (1), the input unit 102 stores in the database 101 the work pattern P1 assigned to September 1st and 2nd 2011 for the crew C1 designated by the operation. Added to the work information 111.

  Note that, similarly to the work pattern assignment for September 2011 described here, if the work pattern assignment for August 2011 has already been performed, in step S102, the crew C1 is assigned 2011. The process of assigning the work pattern P1 on September 1st and 2nd of the year (update of work information 111) is unnecessary. That is, in the work information 111 stored in the database 101, if a work pattern that crosses the month from the previous month has already been assigned, that information can be used.

  In step S103, the selection unit 104 sets September 1, 2011 as the target day, and proceeds to step S104.

  In step S <b> 104, the selection unit 104 selects the crews C <b> 2 and C <b> 3 until September 1, 2011 when the unassigned work W <b> 1 is assigned on September 1, 2011 from the work information 111 stored in the database 101. Cumulative working time U is calculated. At this time, since the work pattern P1 from August 30, 2011 to September 2, 2011 is assigned to the crew C1, the selection unit 104 selects 2011 when the work W1 is assigned on September 1, 2011. It is not necessary to calculate the cumulative working time U of the crew C1 up to September 1 of the year. When work W1 is assigned on September 1, 2011, the cumulative work time U of crews C2 and C3 until September 1, 2011 is the flight time of work W1 on September 1, 2011, that is, 4 hours It becomes.

  In step S105, the selection unit 104 determines, for each of the crews C2 and C3, the cumulative working time U calculated in step S104 until September 1, 2011 and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When work W1 is assigned on September 1, 2011, the total working time U of crew C2 and C3 until September 1, 2011 is 4 hours, and crew C2 and C3 until September 1, 2011 This is the same as the target working time T of 4 hours.

  In step S <b> 106, the output unit 105 displays a list of crews C <b> 2 and C <b> 3 whose cumulative working time U until September 1, 2011 does not exceed the target working time T until September 1, 2011 on the screen. For example, the input unit 102 receives an operation of designating the crew C2 from the user. The selection unit 104 selects the crew C2 designated by the operation as a crew to which work W1 is assigned on September 1, 2011. The selection unit 104 adds the work W1 assigned on September 1, 2011 for the selected crew C2 to the work information 111 stored in the database 101, as shown in (2) of FIG. Then, the process returns to step S103. In step S106, for example, the selection unit 104 may randomly select one of the crews C2 and C3.

  In step S103, since the work W1 on September 1, 2011 has been allocated, the selection unit 104 sets the target date as September 2, 2011, and proceeds to step S104.

  In step S <b> 104, the selection unit 104 determines the crews C <b> 2 and C <b> 3 until September 4, 2011 when the work pattern P <b> 2 is assigned from September 2 to 4, 2011 from the work information 111 stored in the database 101. The accumulated working hours U are calculated. At this time, since the work pattern P1 from August 30, 2011 to September 2, 2011 is assigned to the crew C1, the selection unit 104 assigns the work pattern P2 from September 2 to 4, 2011. In this case, it is not necessary to calculate the cumulative working time U of the crew C1 until September 4, 2011. When work pattern P2 is assigned to September 2-4, 2011, the cumulative work time U of crew C2 until September 4, 2011 is 4 + 16 = 20 hours. When the work pattern P2 is assigned on September 2-4, 2011, the cumulative work time U of the crew C3 until September 4, 2011 is 16 hours.

  In step S105, the selection unit 104 determines, for each of the crews C2 and C3, the cumulative working time U calculated in step S104 until September 4, 2011, and the September 2011 set by the setting unit 103 in step S102. The target working time T until the day is compared. When working pattern P2 is assigned on September 2-4, 2011, the total working time U of crew C2 up to September 4, 2011 is 20 hours, and crew C2 up to September 4, 2011 The target working time T is longer than 16 hours. When working pattern P2 is assigned on September 2-4, 2011, the total working time U of crew C3 up to September 4, 2011 is 16 hours, and crew C3 up to September 4, 2011 This is the same as the target working time T of 16 hours.

  In step S <b> 106, the selection unit 104 selects the crew C <b> 3 whose cumulative working time U up to September 4, 2011 does not exceed the target working time T up to September 4, 2011. As illustrated in (3) of FIG. 18, the selection unit 104 adds the work pattern P2 assigned to the selected crew C3 from September 2 to 4, 2011 to the work information 111 stored in the database 101. . Then, the process returns to step S103.

  Thereafter, similarly, steps S103 to S106 are repeatedly executed, and as shown in FIGS. 15 to 17, work W1 to W3 and work patterns P1 and P2 of September 3 to 30, 2011 are crew C1 to C3. Assigned to. The result is reflected in the work information 111 stored in the database 101.

  FIG. 19 is a diagram showing a crew schedule of crew C1 in this example. FIG. 20 is a diagram showing the crew schedule of crew C2 in this example. FIG. 21 is a diagram showing a crew schedule of crew C3 in this example.

  In step S107, as shown in FIGS. 19 to 21, the output unit 105 refers to the work information 111 stored in the database 101 and outputs the crew schedules of the crews C1 to C3 in September 2011 in a calendar format. To do.

  Note that, under the same conditions as in this example, it is possible to assign work different from the crew schedule shown in FIGS. That is, a crew schedule different from that shown in FIGS. 19 to 21 can be created.

  According to the present embodiment, work patterns can be assigned, and convenience is improved.

Embodiment 4 FIG.
In the first to third embodiments, a crew that assigns work on a target day is selected using working hours as an evaluation index, but an evaluation index other than working hours may be used.

  For example, the flight distance can be used as an evaluation index.

  In this case, the setting unit 103 sets each of the plurality of days as the target day, and sets a target value of a cumulative value obtained by accumulating the flight distances from the first day of the plurality of days to the target day for each of the plurality of crews. The selection unit 104 sequentially sets the target days from the first day to the last day of a plurality of days. If the work on the target day is unassigned, the selection unit 104 determines the flight distance from the work information 111 stored in the database 101 to the target day when the work is assigned on the target day for each of the plurality of crews. Calculate the cumulative value. The selection unit 104 compares the calculated cumulative value of the flight distance up to the target date with the target value up to the target date set by the setting unit 103. Based on the comparison result, the selection unit 104 selects a crew to be assigned work on the target day from a plurality of crews. Specifically, the selection unit 104 selects a crew whose calculated flight distance up to the target date does not exceed the target value set by the setting unit 103 until the target date. Then, the selection unit 104 adds the work assigned to the target day to the work information 111 stored in the database 101 for the selected crew. Thus, as in the first embodiment, it is possible to easily and efficiently assign work according to the pace at which each crew works (determined arbitrarily by the setting unit 103).

  For example, the number of holidays can be used as an evaluation index.

  In this case, the setting unit 103 sets each of a plurality of days as a target day, and sets a target value of a cumulative value obtained by accumulating the number of holidays from the first day to the target day of each of the plurality of crews. The selection unit 104 sequentially sets the target days from the first day to the last day of a plurality of days. If the work on the target day is unassigned, the selection unit 104 calculates the number of holidays from the work information 111 stored in the database 101 to the target day when work is assigned on the target day for each of the plurality of crews. Calculate the cumulative value. The selection unit 104 compares the calculated cumulative number of holidays up to the target date with the target value up to the target date set by the setting unit 103. Based on the comparison result, the selection unit 104 selects a crew to be assigned work on the target day from a plurality of crews. Specifically, the selection unit 104 selects a crew whose calculated cumulative number of holidays until the target date does not fall below the target value until the target date set by the setting unit 103. Then, the selection unit 104 adds the work assigned to the target day to the work information 111 stored in the database 101 for the selected crew. Thus, as in the first embodiment, it is possible to easily and efficiently assign work according to the pace at which each crew works (determined arbitrarily by the setting unit 103).

  As mentioned above, although embodiment of this invention was described, you may implement in combination of 2 or more among these embodiment. Alternatively, one of these embodiments may be partially implemented. Alternatively, two or more of these embodiments may be partially combined. In addition, this invention is not limited to these embodiment, A various change is possible as needed.

  100 work plan creation device, 101 database, 102 input unit, 103 setting unit, 104 selection unit, 105 output unit, 111 work information, 112 attribute information, 191 processing device, 192 storage device, 193 input device, 194 output device, 901 LCD, 902 keyboard, 903 mouse, 904 FDD, 905 CDD, 906 printer, 911 CPU, 912 bus, 913 ROM, 914 RAM, 915 communication board, 920 HDD, 921 operating system, 922 window system, 923 program group, 924 file group.

Claims (8)

A work plan creation device that assigns a plurality of workers with predetermined work hours for a plurality of days,
For each of the plurality of workers, a database that stores work information indicating assigned work by a storage device;
Each of the plurality of days is a target day, and for each of the plurality of workers, the processing device uses the target value of the accumulated working hours obtained by accumulating the working hours from the first day to the target day of the plurality of days as a target working time. A setting section to be set;
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The total working time up to the target date when the system is assigned is calculated by the processing device, and the calculated total working time up to the target date is compared with the target working time up to the target date set by the setting unit by the processing device. Based on the comparison result, a worker who assigns work to the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned to the target day is stored in the database. A work plan creation device comprising a selection unit added to information.   The setting unit, for each of the plurality of workers, sets a target working time until the target date using a function having the number of days from the first day of the plurality of days to the target day as a variable. Item 1. Work plan creation device.   The work setting creation apparatus according to claim 2, wherein the setting unit uses a linear function as the function. The database stores attribute information indicating a predetermined attribute for each of the plurality of workers by a storage device,
The work setting creation apparatus according to claim 2 or 3, wherein the setting unit uses a common function as the function for each worker who has a common attribute indicated by the attribute information stored in the database. A combination of work for two or more consecutive days among the plurality of days is predetermined as a work pattern,
If the work pattern of the period starting from the target date is unassigned, the selection unit sets the period as the target period, and for each of the plurality of workers, from the work information stored in the database to the target date Instead of the cumulative working hours, the cumulative working hours until the end of the target period when the work pattern is assigned to the target period is calculated, and the total working hours until the end of the calculated target period are set by the setting unit. Compared to the target working hours until the end of the target period, based on the comparison result, select the worker who assigns the work pattern to the target period from the plurality of workers, and for the selected worker, 5. A work plan according to claim 1, wherein a work pattern assigned to a period is added to work information stored in the database. Apparatus.   The selection unit, as a worker who assigns work from the plurality of workers to the target day, works that does not exceed the target working time until the target date set by the setting unit as calculated by the setting unit. The work plan creation device according to claim 1, wherein a person is selected. A program for assigning work to a plurality of workers with a predetermined working time for multiple days,
For each of the plurality of workers, a computer comprising a database for storing work information indicating assigned work by a storage device,
Each of the plurality of days is a target day, and for each of the plurality of workers, the processing device uses the target value of the accumulated working hours obtained by accumulating the working hours from the first day to the target day of the plurality of days as a target working time. A setting section to be set;
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The total working time up to the target date when the system is assigned is calculated by the processing device, and the calculated total working time up to the target date is compared with the target working time up to the target date set by the setting unit by the processing device. Based on the comparison result, a worker who assigns work to the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned to the target day is stored in the database. A program for functioning as a selection unit to be added to information. A work plan creation device that assigns work to multiple workers for multiple days,
For each of the plurality of workers, a database that stores work information indicating assigned work by a storage device;
Setting each of the plurality of days as a target day, and setting a target value of a cumulative value obtained by accumulating a predetermined evaluation index from the first day to the target day for each of the plurality of workers by a processing device And
From the first day to the last day of the plurality of days as the target day, and if the work on the target day is unassigned, work for the target day from the work information stored in the database for each of the plurality of workers The cumulative value up to the target date is assigned by the processing device, and the calculated cumulative value up to the target date is compared with the target value set by the setting unit up to the target date by the processing device. Based on the result, the worker who assigns work on the target day is selected from the plurality of workers by the processing device, and for the selected worker, the work assigned on the target day is added to the work information stored in the database. A work plan creation device comprising: a selection unit for performing the operation.

Images