JP2845298B2 - Maintenance patrol work table creation device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a maintenance patrol work table creating apparatus, and more particularly to a maintenance patrol for allowing a customer building (hereinafter referred to as a "building") for which a maintenance contract has been concluded to patrol workers for maintenance and inspection work. The present invention relates to a maintenance patrol work table creation device that creates a work table.

[0002]

2. Description of the Related Art Buildings include elevators, man conveyors,
Various types of equipment such as fire alarms are installed, and if these equipments break down, resident of the building and people entering and exiting the building will receive a great deal of support. It may cause a serious accident related to In order to prevent such a situation from occurring, a maintenance company outsourced to building management regularly dispatches specialized workers to the building to be managed to perform maintenance inspections and repair / adjustment of equipment. I do. In order to perform such periodic patrols, the sales offices in each district of the maintenance company have previously created a maintenance patrol work table that specifies the names of buildings, workers, and patrol dates to be patroled on a monthly basis.

Conventionally, this maintenance patrol work table is a maintenance patrol work table that specifies a building name, a worker name, and a patrol date to be patrol by adhering a building name plate or a worker name plate to a date board with a magnet. Had been created. However, with this conventional method, even the most skilled patrol table creator can rearrange the building name plate and worker name plate several times to obtain the optimal maintenance patrol work table. Burdens the person.

[0004] In order to solve this problem, the applicant of the present invention has proposed a maintenance patrol work table creating apparatus capable of automatic assignment according to Japanese Patent Application No. 2-321145. FIG.
3 and FIG. 14 are diagrams showing the configuration of a maintenance patrol work table creating apparatus according to the proposal. As shown in FIG. 13, a center 1 that performs overall data processing of a building and a plurality of sales offices 2 of a maintenance company are provided. Are connected to each other by a communication line 3. Center 1
Comprises a storage unit 1a for comprehensively storing the maintenance data of the building under the jurisdiction of each sales office, and a transmission / reception device 1b connected to the storage unit 1a. The sales office 2 includes a transmission / reception device 2s and a work table creation unit. 10 is provided. This work table creation unit 10
Comprises a site information storage unit 11, a display unit 15, an input unit 16, a personal information storage unit 12, a control unit 14, and a schedule information storage unit 13.
A display unit 15 having one or two display areas, an input unit 16 such as a keyboard, a personal information storage unit 12 and a schedule information storage unit 13 are connected to each other.
Is connected. Further, the transmission / reception device 2s is connected to the control unit 14, and the transmission / reception device 2s and the transmission / reception device 1b of the center 1 are connected to each other via the communication line 3.

The site information storage unit 11 has a function of storing the name of the building to be worked in the patrol month, the contents of the work, the last work day, and the number of contract maintenance. The personal information storage unit 12 stores the work of the patrol month. It has a function to memorize work information and work qualifications of employees,
The schedule information storage unit 13 has a function of storing display contents displayed on the display unit 15.

In the center 1, customer data stored in the storage unit 1a is classified and stored for each area where a building is located and for each type of one-person work and two-person work based on data given in advance. In this case, the standard maintenance and inspection work is performed twice a month for one building, and one person and two people work alternately.
Classify the same building name as both one-person and two-person.

[0007] As shown in FIG.
, A display area 15A and a second display area 15B are provided, and the names of the buildings B1, B2,.
n is transmitted via the communication line 3 to the first display area 1
5A is displayed. Then, the control unit 14 operates to allocate a designated site where the customer has designated a work day first, referring to the data in the personal information storage unit 12 and the site information storage unit 11, and determine the remaining work time and qualification of the worker. Assign two-person work while checking, then assign one-person work.

[0008]

In the maintenance patrol work table creating apparatus according to the above-mentioned proposal, no consideration is given to the assignment when a business trip to a remote place is performed and maintenance and inspection work is performed over a plurality of days. When the problem occurred, it was processed during the assignment of the designated site, the assignment of two people, and the assignment of one person. Therefore, it was necessary to correct the assignment at the business trip site by manual work after the assignment was completed.

The present invention has been made in view of the above-described current situation of creating a maintenance patrol work table as described above. It is an object of the present invention to provide a maintenance patrol work table creating device which can be carried out at any time.

[0010]

In order to achieve the above object, the present invention provides a display unit having a column specified by a date within a predetermined period for creating a work table and a name of a worker who performs maintenance patrol work. In a maintenance patrol work table creating apparatus comprising: a worker data storage unit in which the worker's work information within the predetermined period and the work qualification of the worker are stored, and a work target within the predetermined period. A building data storage unit for storing a building name, work contents, a designated work date, and contract conditions, extracting means for extracting a business trip building name requiring a business trip from the building data storage unit, and Classifying means for classifying each business trip, arranging means for arranging the names of business trip buildings classified by the classifying means in the order of work days performed in the previous predetermined period, and Means of gathering , For the business trip building name that has been set in this set means, and has a configuration and a determination means for determining the working day and workers.

[0011]

With such a construction, the name of the building to be worked on within a predetermined period, the contents of the work, the specified work day, and the building data storage section for storing the contract conditions are used to extract the name of the business trip building requiring a business trip by the extracting means. It is extracted and the business trip building name is classified for each same area by the classification means. Then, the arrangement means are arranged in the order of the work days performed in the previous predetermined period, and the business trip building names having the same and adjacent work days are aggregated by the gathering means, and for the aggregated business trip building names,
The determining means determines the worker and the work date.

In this case, a candidate day (one or several days) for performing the work is determined based on the designation of the work day, the week and the day of the week, and the number of business days, and then the qualification of the worker and this candidate day are taken into consideration. Thus, the work execution date and the worker of the business trip building are determined.

[0013]

1 to 15 show an embodiment of the present invention.
This will be described with reference to FIG. Here, FIG. 1 is a block diagram showing the configuration of the embodiment, and FIGS. 2 to 15 are flowcharts showing the operation of the embodiment.

As shown in FIG. 1, a center 1 having a storage unit 1a and a transmission / reception device 1b is connected via a communication line 3 to a business office 2 comprising a transmission / reception device 2a and a work table creation unit 10. The transmitting / receiving device 1b of the center 1 and the transmitting / receiving device 2 of the business office 2 are connected to each other via the communication line 3.
The work table creation unit 10 includes a schedule information storage unit 13,
Site information storage unit 11a, control unit 14, qualification information storage unit 1
2a and a personal information storage unit 12 having a work absence information storage unit 12b, an input unit 16, a display unit 15, and a printing unit 17 are provided. The control unit 14 includes a schedule allocation processing unit 14c, a site information processing unit 14a, an input / output information processing unit 14d, and a personal information processing unit 14b, and the schedule information storage unit 13 is connected to the schedule allocation processing unit 14c. It is. The schedule allocation processing unit 14c is connected to the site information processing unit 14a, the input / output information processing unit 14d, and the personal information processing unit 14b.
Is connected to the personal information storage unit 12, and the input / output information processing unit 14d is connected to the input unit 16, the display unit 15, and the printing unit 17. The transmitting / receiving device 2a is connected to the site information storage unit 11a, and the site information storage unit 11a is connected to the site information processing unit 14a. The display unit 15 has the same column configuration as the conventional display unit already described with reference to FIG.

Here, the site information storage unit 11a corresponding to the building data storage unit of the present invention includes the storage unit 1a of the center 1.
The information (maintenance of the building, designated work date, work content, etc.) concerning the maintenance of the building managed by the sales office 2 among the information stored in the office 2 is stored through the transmitting / receiving device 2a. In addition, the personal information storage unit 12 corresponding to the worker data storage unit of the present invention stores the qualifications as workers and the working status of the month (annual leave, meeting, training, etc.) for all the workers belonging to the sales office 2. , Etc.) are stored. The qualifications for this work include "maintenance", "working aim" and "inspection". For two-person work, at least one of the workers must have the qualification of "maintenance", and "maintenance" or "work standard"
Can be assigned to one of the two tasks that can be performed or one task. A worker who is qualified for "inspection" can perform a check operation in one operation, and another unqualified worker performs auxiliary work for a qualified worker.

The on-site information processing section 14a has a function of extracting and processing information stored in the on-site information storage section 11a, and the personal information processing section 14b is stored in the personal information storage section 12. It has a function of taking out information and processing the information. The schedule allocation processing unit 14c has a function of executing allocation control of maintenance patrol work. The input / output information processing unit 14d has a function of inputting data and instructions, Are displayed on the display unit, and these processing units are constituted by microcomputers. Further, the control unit 14 is provided with the extracting means, the sorting means, the arranging means, the set procedure and the deciding means of the present invention.

Next, the operation performed under the control of the schedule allocation processing section 14c of the embodiment having such a configuration will be described.
This will be described with reference to FIGS.

First, the outline of the operation of the embodiment will be described with reference to the flowchart of FIG. 2. In step S1, the personal information processing unit 14b is stored in the personal information storage unit 12 according to a command from the schedule allocation processing unit 14c. Then, the data of the operable time is input to the schedule allocation processing unit 14c, and the data of the operable time are stored in the schedule information storage unit 13. Then, the process proceeds to step S2, in which the schedule allocation processing unit 14c allocates a building (site) that requires a business trip to perform work among the work target buildings for the month. Is assigned to the specified work day of the building for which is specified. Then, proceeding to step S4, the two-person work should be performed in the column of the two-person work among the buildings allocated in step S2 while considering the location of the building, the qualification of the work area, the work time, and the work day. Are allocated, and when the work time in the column reaches the limit, step S
Proceeding to 5, the building of the two-person work is allocated to the other fields of the two-person work allocated in step S3, and the buildings of the two-person work are sequentially allocated to the blanks.

When the allocation of the two-person building is completed, the process proceeds to step S6, where the building is already allocated and the one-person operation is allocated to the column having the remaining time. When the allocation is completed, the process proceeds to step S7. Then, the remaining one-person work is sequentially allocated to the blanks, and all the allocated work is completed.

Next, the details of the processing in step S2 performed by the schedule allocation processing section 14c will be described with reference to the flowchart in FIG.

In step S10 of FIG. 3, the site information processing unit 14a extracts all business trip sites from the site information storage unit 11a in response to a command from the schedule allocation processing unit 14c. Therefore, the schedule assignment processing unit 14c
In step S11, a business trip site is assigned from the extracted business trip sites to a designated site where a week, a day of the week, etc. are specified and the assignment date is specified. When the assignment of the business trip site is completed, the process proceeds to step S12. Assign a non-designated business trip site.

Here, the details of the processing in step S10 in FIG. 3 will be described with reference to the flowcharts in FIGS.

In step S13, the on-site information processing unit 1 receives a command from the schedule allocation processing unit 14c.
4a extracts all the business trip sites from the site information storage unit 11a, and sorts the business trip sites extracted in step S14 in ascending order of the traveling code.

Here, the cyclic code means that a territory of a business office is divided into a plurality of blocks of a large section (for example, a city), a middle section (for example, a ward) and a small section (for example, a town), and a site attached thereto. Each code is composed of three digits of 3000 to 999.

In step S15, the site information processing unit 14a rearranges the sites in the same region (sites having the same 100th place of the tour code) in ascending order of the previous month's allocation date with respect to the business trip sites sorted in the order of the tour code. . Then
In step S16, for the business trip site rearranged in step S15, a site where the previous month's allocation date is continuous (for example, the 100th place of the tour code is 1 and the previous month's allocation date is 2)
Day scene and 3 day scene) as one block. Therefore, business trip sites in the same area where the previous month's allocation dates are consecutive belong to the same block. Then, the number of days (business trip days) that are continuous with the first previous month allocation date (business trip start date of the previous month) of the business trip sites belonging to the block classified in step S15 and the business trip site belonging to the block are determined by the site information processing unit 14a. Is stored in the site information storage unit 11a. Then, in step S17, the on-site information processing unit 14a sorts the divided business trip sites in ascending order of the number of business days, and can output the business sites in ascending order of the number of business trips every time there is a command from the schedule allocation processing unit 14c. Put it like that.

Next, the assignment of the business trip site in step S11 of FIG. 3 will be described with reference to the flowcharts of FIGS.

In step S20 of FIG. 6, the schedule assignment processing unit 14c, after instructing the reordering of the business trip sites, first designates the designated business trip site in which the week or the day of the week is designated and the assignment candidate. The day and the number of business days are inquired to the site information processing section 14a. When the processing of the site information processing unit 14a in response to the inquiry in step S20 is proved with reference to the flowchart of FIG. 7, the site information processing unit 14a, which has received the instruction from the schedule allocation processing unit 14c in step S25, First, the leading block is extracted from the blocks at the business trip site sorted in the order of the longest business trip days for each block. Next, the process proceeds to step S26, where it is determined whether there is a designated business trip site in the extracted block. If at least one specified business trip site is included in this block, the block is replaced with the designated business trip site. Step S
Proceed to 28. In step S28, a common assignment candidate date is determined for all the business sites in the block (designated business sites or mixed business sites of the specified business sites and unspecified business sites).

On the other hand, if it is determined in step S26 that no specified business trip site is included in the block, the flow advances to step S27 to take out the next block and return to step S26 to return to the specified business trip. This process is repeated until a block is found at the site.

The details of step S28 will be described with reference to the flowchart of FIG.

In step S30, the site information processing unit 14a firstly determines, for a business trip site in a block including a designated business trip site and having a large number of business trip days in which the previous month's allocation day is continuous.
For all the business trip sites on the assignment day of the previous month on the first day, the allocation candidate date is calculated for each business site. In this case, for example, if the previous month's business trip day is two days, two days and three days, the first month's previous month allocation date is two days, and if the number of business trip sites allocated on the two days is three, Calculate the allocation candidate dates for all three sites. Next, in step S31, the site information processing unit 14a searches for a candidate day common to all the business trip sites for the allocation candidate day calculated for each business trip site on the first day, and identifies the common date as the first business trip day. The candidate day of the day's business trip site. For example, if there are three business trip sites on the first day and the candidate dates are 2 to 10, 4 to 12, 5 to 13 days, the common candidate date is 5 to 10 days. Become.

Next, the process proceeds to step S32, where it is determined whether or not the calculation of the common candidate date has been extracted for all of the business trip days of the block. If the determination is NO, the process proceeds to step S33 to perform the business trip of the next day. For each of the sites, the assignment candidate date is calculated, and the process returns to step S31. If the determination in step S32 is YES, the process proceeds to step S34, and a common candidate day for each business trip day is obtained. For example, in a three-day business trip, the common candidate day of the first business trip site is 5 to 10 days.
Day, the common candidate day of the second business trip site is 3-9 days,
If the common candidate day of the third day of the business trip site is 4 to 9 days,
The common candidate days for each business day in this block are 5 to 9 days. Next, the process proceeds to step S35, and the first day of the number of business trip days in the common candidate day is set as the allocation candidate date of the block. For example, the number of business trip days is three days, and the common candidate days are five to nine.
If it is a day, the business trip candidate date of the block is 5 to 7
Day, 6 to 8 days, 7 to 9 days. here,
The site information processing unit 14a sets the candidate date of the block as
The first five days, the sixth day, and the seventh day are taken out, and the number of business trip days is taken out, and the process proceeds to step S29 in the flowchart of FIG. In this step S29, the above-mentioned allocation candidate date of the block (arrangement of the head date) and the business trip date are input to the schedule allocation processing unit 14c as a response to the inquiry.

As described above, step S20 in FIG.
When the schedule assignment processing unit 14c receives the designated business trip site, the assignment candidate date, and the number of business days to be assigned from the site information processing unit 14a, the process proceeds to step S21, in which the scheduler, the accompanying person, and the work day to assign the designated business site are assigned. decide.
Here, the assignment of the business trip site is assigned to a set of a responsible person and a companion, whether or not the task is a single task. In step S22, it is determined whether the responsible person, the companion, and the work date are determined. If the determination in step S22 is YES, the process proceeds to step S23, where a designated business trip site is assigned to the responsible person and the accompanying person, and this is stored in the schedule information storage unit 13. Next, the process proceeds to step S24, where it is determined whether there is another designated business trip site. If the determination is YES, the process returns to step S20, and the process is repeated until there is no other designated business trip site. If the determination in step S24 is NO, the allocation process for the designated business trip site ends.

Here, the processing in step S21 in FIG. 6 will be described in detail with reference to the flowcharts in FIGS.

In step S40 of FIG. 9, the schedule information processing unit 14c extracts the first candidate date from the allocation candidate dates received from the site information processing unit 14a. For example, in the case of the designated site where the aforementioned candidate days are 5, 6, 7 and the number of business trip days is 3, the first candidate day is 5 days. Next, the process proceeds to step S41 to calculate a business trip day from the candidate day and the number of business trip days. For example, if the candidate date is 5
If the number of business trip days is three days, the business trip days are three days of five days, six days, and seven days. When the day of the business trip is determined in this way, the process proceeds to step S42, in which candidates of the person in charge of the business trip on the day of the business trip are determined. In step S43, it is determined whether or not the candidate of the person in charge is determined. In step S44, a companion candidate is determined, and in step S44
At 45, it is determined whether a companion candidate has been determined.

If the determination in step S45 is YES, the process proceeds to step S46, where the person who has the least number of business trips among the candidates for the responsible person is the responsible person, and The person with few persons is taken as a companion, and the responsible person and the companion are assigned to the business trip site. When it is determined in step S43 that the candidate for the responsible person has not been determined, or when it is determined in step S45 that the candidate for the accompanying person has not been determined, the process proceeds to step S47 and another candidate date is set. It is determined whether or not there is, and if the determination is YES, the process proceeds to step S48, another candidate date is extracted, and step S4 is performed.
1, the same operation as described above is repeated for the candidate date. On the other hand, if the determination in step S47 is NO, it means that there is no person in charge of assigning the business trip site or a companion, and the process returns to step S24 in FIG.

Here, the details of the operations in steps S42 and S44 of FIG. 9 will be described with reference to the flowcharts of FIGS.

FIGS. 10 and 11 are flowcharts for determining a candidate for the responsible person. In step S50, the first business trip day is taken out (for example, if the business trip day is three days of five to seven days, one day is taken out of five days). In the business day taken out in step S51, the first worker is taken out of the work table (the worker names in the work table are arranged in order from the one with the highest qualification). . Next, in step S52, a determination is made to confirm that the site has not yet been assigned to the removed worker, and if this determination is YES, the flow advances to step S53 to determine whether the worker is qualified as a responsible person. In response to this inquiry, it is determined in step S54 whether or not the worker is qualified as a responsible person. If the determination is YES, the process advances to step S55. Then, the personal information processing unit 14b is inquired as to whether the worker is assigned work leave information such as a meeting. In response to this inquiry, a determination is made in step S56 as to whether or not the employee is assigned work leave information. If this determination is NO, the process proceeds to step S57, and the worker has a next business day. Is determined. In this case, if the conditions are satisfied for all the business days from the 5th to the 7th and the determination in step S57 is NO, the process proceeds to step S59, and the worker is set as a candidate for the responsible person. If the decision in the step S57 is YES, the process proceeds to a step S58 to take out the next business day, returns to the step S51, and repeats the above operation until the next business day disappears. On the other hand, if the determination in step S52 is NO, step S54
Is NO, the determination in step S56 is YE
If the answer is S, the process proceeds to step S60, where it is determined whether or not another worker is present on the business trip day.
If it is ES, the worker is taken out in step S60a,
Returning to step S52, the operation described above is repeated.

Next, determination of a companion candidate will be described with reference to the flowcharts of FIGS.

First, in step S61, the first business trip day is taken out, and the process proceeds to step S62 to take out the last worker in the work table (worker names in the work table are arranged after workers with lower qualifications). ). Next, proceeding to step S63, a determination is made to confirm that the site has not yet been assigned to the worker taken out, and if this determination is YES, then in step S64, the worker is notified of the absence from work such as a meeting. The personal information processing unit 14b is inquired as to whether or not is assigned. In response to this inquiry, step S65
In step S66, it is determined whether or not the work leave information has been assigned to the worker.
To determine if there is a next business day. In this case, if the conditions are satisfied for all the business days from the 5th to the 7th and the determination in step S66 is NO, the process proceeds to step S68, and the worker is set as a candidate for the accompanying person. If the determination in step S66 is YES, the process proceeds to step S67, where the next business day is taken out, and step S62 is taken.
And the above-described operation is repeated until the next business trip disappears. On the other hand, if the determination in step S63 is NO, and if the determination in step S65 is YES, the process proceeds to step S69, where it is determined whether or not another worker is present on the business trip day. If so, the worker is taken out in step S70, and the process returns to step S63 to repeat the operation described above.

The details of the assignment of the business trip site other than the designation in step 12 of the flowchart of FIG. 3 will be described with reference to the flowchart of FIG.

First, in step S71, the schedule allocation processing unit 14c inquires the business site information processing unit 14a about a business trip site other than the designated one, an allocation candidate date, and the number of business days. The processing of the site information processing unit 14a in response to this inquiry will be described based on the flowchart of FIG.
In step S76, the site information processing unit 14a starts from the block of the business trip site arranged according to the above rule (the block including the designated business trip site has already been taken out and has not been arranged yet). Take out the block. Next, in step S77, a common assignment candidate date for all the business trip sites in the extracted block is obtained. In step S78, the schedule assignment processing unit 14c is inquired of the business trip site, the allocation candidate date, and the number of business days of the block. Enter as a reply.

Therefore, in step S72 of FIG. 14, the schedule assignment processing unit 14c determines the person in charge of assigning a business trip site other than the designated one, the accompanying person, and the work day based on the response from the site information processing unit 14a (processing Is the same as the already-specified business trip site, the description of which is omitted). If it is determined in step S73 that the responsible person, accompanying person, and work date have been determined, the process proceeds to step S74. In this step S74, a business trip site other than the designated one is assigned to the responsible person and the accompanying person, stored in the schedule information storage unit 13, and the process proceeds to step S75 to determine whether there is another business site. If the determination in step S75 is NO, the process ends. If the determination in step S75 is YES, the process returns to step S71 to repeat the process until there is no business trip site.

As described above, in the embodiment, the assignment of the business trip site is automatically executed. However, if the assignment of the business trip site becomes impossible by this method, after the processing for all the business trip sites is completed, While doing the work leave of the worker etc.,
The assignment of the non-assignable business trip site is performed manually.

As described above, according to the embodiment,
At the customer site where maintenance and patrol work is performed on the installed equipment and equipment, select the optimal group of responsible persons and accompanying persons in consideration of the number of business days and the region, and automatically assign the site. In addition, it is possible to provide a maintenance patrol work table creating apparatus that creates a maintenance patrol work table.

[0045]

According to the present invention, a candidate work day is determined for a building to be subjected to maintenance patrol work on the basis of the work day conditions, the number of business days, and the previous work day data. Therefore, it is possible to provide a maintenance patrol work creating apparatus that automatically creates a maintenance patrol work table for a customer building in consideration of business trip work conditions.

[Brief description of the drawings]

FIG. 1 is a block diagram showing the configuration of an embodiment of the present invention.

FIG. 2 is a flowchart showing the overall processing operation of one embodiment of the present invention.

FIG. 3 is a flowchart showing a processing operation of step S2 in FIG. 2;

FIG. 4 is a flowchart showing a processing operation in the first half of step S10 in FIG. 3;

FIG. 5 is a flowchart showing a processing operation in the second half of step S10 in FIG. 3;

FIG. 6 is a flowchart showing a processing operation of step S11 in FIG. 3;

FIG. 7 is a flowchart showing the processing operation of step S20 in FIG. 6;

FIG. 8 is a flowchart showing the processing operation of step S28 in FIG. 7;

FIG. 9 is a flowchart showing the processing operation of step S21 in FIG. 6;

FIG. 10 is a flowchart showing the processing operation in the first half of step S42 in FIG. 9;

FIG. 11 is a flowchart illustrating a processing operation in the second half of step S42 in FIG. 9;

FIG. 12 is a flowchart showing a processing operation in the first half of step S44 in FIG. 9;

FIG. 13 is a flowchart showing a processing operation in the second half of step S44 in FIG. 9;

FIG. 14 is a flowchart showing a processing operation in step S12 of FIG. 3;

FIG. 15 is a flowchart showing the processing operation of step S71 in FIG.

FIG. 16 is a block diagram showing a configuration of a conventional maintenance patrol work table creation device.

FIG. 17 is an explanatory diagram illustrating a configuration of a display unit in FIG. 16;

[Description of Signs] 10 Work table creation unit 11a Site information storage unit 12 Personal information storage unit 13 Schedule information storage unit 14 Control unit 14a Site information processing unit 14b Personal information processing unit 14c Schedule allocation processing unit 15 Display unit

Claims (3)

(57) [Claims] 1. A maintenance patrol work table creating apparatus, comprising: a display unit having a column specified by a date and time within a predetermined period for creating a work table and a name of an operator performing a maintenance patrol work. A worker data storage unit in which work information within a predetermined period and work qualifications of the worker are stored, and a building name, work contents, designated holidays, and contract conditions to be worked within the predetermined period are stored. A building data storage unit, an extracting unit for extracting a name of a business trip building that requires a business trip from the building data storage unit, a classifying unit for classifying the business trip building name for each region, and a business trip classified by the classifying unit. Arrangement means for arranging the building names in the order of the work days performed in the previous predetermined period, collection means for collecting the names of business trip buildings whose work days are the same day and adjacent days, and business trip building names collected by this collection means Working against A maintenance patrol work table creating apparatus, comprising: a determining means for determining a worker and a work day. 2. The maintenance patrol work according to claim 1, wherein the deciding means decides the work day based on the common work candidate day from the name of the business trip building on the same day where the gathering means has gathered. Table maker. 3. The method according to claim 1, wherein the deciding means decides adjacent days on the plurality of work days based on the common work candidate days from the names of the business trip buildings on the plurality of work days gathered by the gathering means. The maintenance patrol work table creating device according to claim 1, wherein