JP2003223536A - Method and program for sorting group operation - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To automatically and efficiently create, using a computer program, an operation journal in making a plurality of operation groups share telephone installation work or the like. <P>SOLUTION: This method includes acquiring operation issue data including at least the operation site and operation starting time zone of each of a plurality of operations to be completed within a specified period (S1); accepting the designation of the plurality of operation groups which should share the plurality of operations (S2); creating a plurality of operation sorting plans for the operation issues to be shared by the operation groups and their order, based on the operating time which each operation group requires to complete the operation issue for which each group is responsible (S3); and displaying the plurality of operation sorting plans created on a display in such a manner that either of the plans can be selected. These processes are implemented by computers. <P>COPYRIGHT: (C)2003,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a work sorting method for each group and a work sorting program for each group, and more specifically, it performs a plurality of works such as various telephone works and repair of office automation equipment such as personal computers, copiers, and facsimile machines. The present invention relates to a method and a program for automatically and efficiently creating a work sorting table when a work group shares the work with a computer.

[0002]

[Prior Art] Taking telephone construction as an example, a construction request received by telephone, sales counter or corporate sales
It is distributed to the contracting companies for telephone construction, and data is transmitted as order information to the custom terminal of each contracting company. Each contractor usually receives order information at least two days before the construction date. In this way, a plurality of order information in which the same construction date is designated is stored in the custom terminal of each contracting company.

Each contracting company that received the order information outputs a plurality of order information on the day before the construction day from a custom terminal to a printer, and outputs the construction information for each order for each order. Check the tools and materials needed for the construction, construction reservation time and construction place (user's address)
-Create a work sorting table (also called a group-specific carry-out table) in consideration of the work content. The work sorting table is created for each work group, and the work place, the work content, the scheduled start time of the work, the scheduled finish time of the work, etc. are described in the order of the work. On the day of construction,
Each work group performs construction in the designated order while confirming the orders assigned to it by the work sorting table.

[0004]

Conventionally, the above-mentioned work sorting table is manually created, but it takes a long time even for a skilled person. One of the reasons is that the skill level differs depending on the work group, and even for the same work, the time required for the work varies depending on the skill level of the work group or the work speed level accompanying it.

[0005]

SUMMARY OF THE INVENTION Therefore, the present invention solves the above problems in the prior art and automatically uses a computer system for a work sorting table when telephone work and the like are shared among a plurality of work groups. The objective is to create it efficiently and efficiently.

To achieve this object, the method for sorting work by group according to the present invention is: (a) a work project including at least a work place and a work start time zone for each of a plurality of works to be completed within a specific period. Get the data,
(B) The designation of a plurality of work groups to share these plurality of works, (c) the current location of each work group, the work location and work start time zone of each work case in the work case data, and each work From the work time required for each work group to be in charge of each group, a plurality of work classification plans for each work group to be in charge of each work group and its work order are created, and (d) of the created plural work classification plans. It is characterized in that a computer is caused to execute each processing for displaying any one of them on a display (claim 1).

According to one preferred embodiment of the invention,
In the processing of (c), among the work cases that satisfy the condition of (c-1) work start time zone, the work in the work place that is determined to be the closest from the departure place of the work team with the highest priority according to a predetermined priority order. Select a project to be the first work project of the highest priority work group, and in the same manner, according to the priority of the work group, it is judged that it is the closest to the departure point of each work group among the work projects excluding the already selected work project. The work case of the work place to be set is defined as the first work case of each work group, and (c-2) from the work group determined to finish the work earliest among the first work cases determined in this way, Of the work cases other than the selected work case, the work case of the work place that is judged to be closest to the work place of the first work case of the work group is selected and set as the second work case of the work group, and in the same manner. In order of work completion of the first work case Select the second work projects of the working group,
(C-3) In the same manner, the first work classification plan is created by allocating all work cases to each work group in the same manner.
-4) The priority of the work group is changed and the above-mentioned (c-1) and the subsequent processes (c-2) to (c-3) are executed to create a plurality of work sorting plans (claims). 2).

The work time used in the process (c) can be predicted based on a work skill database in which the actual work time required by each work group is recorded for each work type (claim 3). Alternatively, a standard work time database that quantifies the standard work time for each work type and a work speed level database that quantifies the work speed level for each work group are created, and in the processing of (c), each work group is created. The standard work time for the work type of the work item in charge of is read from the standard work time database, the work speed level of the work group is read from the work speed level database, and these are multiplied to obtain the work item that each work group is in charge of. The required work time may be calculated (claim 4).

According to another preferred embodiment of the present invention, in the processing of (d), for each of the work sorting plans created in a plurality of ways, the work group that finishes the work of all work projects latest The work end time is predicted and displayed on the display (Claim 5).

According to still another preferred embodiment of the present invention, even if the present time is within the work start time zone and the work place is the closest to the present position of the work group, Considering the time required to move to the work place, if the work start time exceeds the work start time zone,
In the process of (d), when the work group is in charge of the work case, it is displayed on the display that the condition of the work start time zone is not satisfied (claim 6). (D)
For the work items displayed as not satisfying the conditions of the work start time zone in the process of 1., the work start scheduled time when the work item is transferred to another work group is incorporated in each work group. It is possible to transfer to each work group by calculating it based on the location of each work case and the scheduled work end time, and further calculating the scheduled work end time in that case based on the work time required by each work group. Whether or not it can be displayed on the display (Claim 7). Further, upon receiving an instruction to transfer the work item to another work group, this work transfer is executed, and the work sorting plan after the work transfer can be displayed on the display (claim 8).

It is preferable that the work sorting plan selected after the process of (d) is made into a work process table for each group and can be output to a printer (claim 9).

The specific period in (a) is, for example, a specific time zone of the day (claim 1).
0).

The present invention also provides a group-based work sorting program for causing a computer to execute each process in the group-based work sorting method according to any one of claims 1 to 10.

[0014]

1 is a block diagram showing an outline of a telephone construction management system to which the present invention is applied. A vehicle 10 of each work group has a GPS sensor 12, a central processing unit (CPU) 13, A navigation system 11 including a display 14, a printer 15 and the like is mounted.

The GPS sensor 12 receives the positioning signal sent from the artificial satellite by the antenna 16 and detects the absolute position of the vehicle 10. For more accurate vehicle position detection, a D-GPS (Differential GP) that receives a correction signal for a positioning error transmitted from a predetermined base station and corrects the position.
S) may be used, or an orientation sensor (geomagnetic sensor, gyro sensor, wheel sensor, etc.), distance sensor, beacon receiving device, etc. may be used together.

The CPU 13 receives the detection signals from the GPS sensor 12 and other positioning sensors, specifies the current position of the vehicle 10, displays this current position on the map of the display 14, and also at a predetermined interval (for example, every 5 minutes). Is transmitted from the antenna 17 to the center computer 20.

Center computer 20 of the construction contractor
A central processing unit (CPU) 21, a memory 22, a display 23, a printer 24 and the like are provided in the computer. When the management center 20 receives the current position data of the vehicle 10 via the antenna 25, the CPU 21 analyzes the current position data and displays it on the display 23.

In the memory 22 connected to the CPU 21 so that data can be transmitted and received, the standard work time database 2 in which the standard work time for each construction type is empirically and statistically defined
21 and a work speed level database 222 that empirically and statistically defines the work speed level of each work group.
And a road map database 223 for displaying a road map of the area under its control and the surrounding area on the display 23.

FIG. 2 is a data table showing an example of the standard work time database 221. The work corresponding to the code number for specifying the work type in the general telephone line and the work type specified by each code number are shown. The standard process time of each type is shown numerically. According to this data table, the standard process time for "inside entry" work is "1".
As an example, the standard process time for "in-house" work is "3"
Because it is said that it takes three times as long as the time of “incoming” work,
Since the standard process time of the "public change" work is "5", it takes five times as long as the "internal entry" work. When the unnecessary work type is deleted, a new work type is added, or the standard process time of an existing work type is changed, the database 221 is updated accordingly, and the data table shown in FIG. It is displayed in the column of "update date and time" (display is omitted in FIG. 2). The unit of the standard process time can be set arbitrarily, but in the data table of FIG. 2, the standard process time is “1”.
It is defined that 80 minutes are required when the work group of the work level “1” described later constructs the work of (1).

The concrete construction contents of each work type displayed in the data table of FIG. 2 are outlined below.

"Domestic entry" = construction of new installation site for relocation without changing telephone number of subscriber telephone line "In-house" = construction of old installation site for relocation without changing telephone number of subscriber telephone line Construction "Outside" = Construction of a new installation site for relocation with a change in the telephone number of the subscriber's telephone line "Outside" = Construction of old installation site for relocation with a change in the telephone number of the subscriber's telephone line "Resurrection" = Construction to restore the subscriber's telephone line rights that have been suspended "Pause" = Construction to suspend the subscriber telephone line and retain the rights "Attach" = Construction to make the subscriber telephone line available again ”= Construction to remove the wiring of the subscriber's telephone line“ Transfer ”= Construction to convert the subscriber's telephone line (change from analog to digital, etc.)“ Addition ”= Construction to remove the subscriber's telephone line Setting "= Setting terminal equipment Work to be done "End of life" = Work to remove the terminal device "End of life" = Work to replace the terminal device "Visible" = Work to install a business phone "Business abandoned" = Work to abolish the business phone "Business strange" = Business phone Construction to be replaced "N" = Construction to newly establish a service such as call waiting "A" = Construction to newly establish a telephone number transfer notification service "Extra" = Construction to install a temporary telephone line "Extinction" = Temporary telephone line "Disintegration" = work to remove the wiring of the subscriber's telephone line that was interrupted due to the accident "Recovery" = construction to allow the use of the subscriber's telephone line that was interrupted due to the accident "Relocation" = Construction for relocating the telephone service line outside the building "New integration" = Construction for newly establishing a new subscriber telephone line "Excellent" = Construction for enabling the use of priority lines (public telephone lines) "Public change" = Public telephone Move to Construction of new phone models change installation work "only" = leased line

FIG. 3 shows a work speed level database 2
22 is a data table showing an example of a work group 22 and a code number for identifying a work group, and a work group specified by each code number (in this embodiment, one work group constitutes one work group, and thus is a work group equal worker). ), The work level of the work group is quantified and shown. According to this data table, for example, code 01
Since the work speed level of the work group of “1.1” is “1.1”, the standard process time of each work shown in the standard work time database of FIG. It takes time (= 88 minutes) and "3.
It can be seen that the work time of "3" (= 264 minutes) is required, and the work of "public change" requires the work time of "5.5" (= 440 minutes). Similarly, since the work speed level of the work group of code 02 is "0.6", the standard process time of each work shown in the standard work time database of FIG. Working time of 6 "(= 48 minutes)
The work time of “1.8” is for “in-house” work (= 14
It can be seen that it takes only 4 minutes) and the work of "public change" can be done in the work time of "3" (= 240 minutes). That is, the smaller the value of the "work level" in the work speed level data table shown in FIG. 3, the faster the worker is and the faster the work speed is.

In the work speed level data table shown in FIG. 3, it is also possible for each work group whether construction of special lines other than general telephone lines is possible ("1") or impossible ("0"). It is shown for each. According to this data table
In addition to general telephone line construction, the code 01 work group
"C" (work to set up Internet and mail for personal computers etc. for users who have purchased the specified terminal equipment in ISDN64 telephone line construction), "public" (public telephone installation work) and "dedicated" (dedicated line) Can be carried out (installation / abolition work)
It is not possible to take charge of each work (installation work of multi-function phone for business users) and "home telephone" (installation work of multi-function phone for general users). Code 0
The second work group is capable of doing all the work.

When the data stored in the work speed level data table of FIG. 3 is changed, or when a work group is added or deleted, the database 222 is updated accordingly, and FIG. It is displayed in the column of “update date and time” in the data table of (not shown in FIG. 3).

Further, the CPU 21 has the construction type of the construction ordered from the construction contractor to the construction contractor, the construction place, the construction date, and the construction time zone designated by the user (in this embodiment, 9:00 am to 12:00 am, 1 pm). 3am from 1pm to 3pm, 1pm to 5pm
The user can specify that the construction should be started in the specified time zone), etc., and directly receive the order information from the construction ordering source, or the data received from the terminal that received this or the manual input, and the construction An order file is created as a list for each day and a certain construction area, and stored in the order file storage unit 224 of the memory 22.

FIG. 4 shows an order file for a construction to be performed in a specific construction area (here, Yokosuka district, Kanagawa prefecture) on a specific construction day, which is read from the order file storage section 224 and displayed on the display. Order number, telephone number of the construction site (displayed as abbreviated below the station number), type of construction, standard construction time considered to be required for construction (corresponding to the standard process time of each work shown in the standard work time database in Fig. 2) , The construction time zone specified by the user, whether or not the group is specified by the user, the skill element indicating whether the telephone line targeted for construction is a general line or a special line, the telephone line targeted for construction The name of the contractor (not shown) and its location (not shown below the town) are displayed in list format. In this example,
There is no group designation for any construction, and all construction is shown as for general lines (no skill element), but if you change these as necessary, enter on this display screen. .

The CPU 21 creates a work sorting table when the contracted work is shared among a plurality of work groups.
For the work of creating the work sorting table, the work to be performed in the particular work area on the particular work day listed in the order file is referred to by referring to the standard work time database 221 and the work speed level database 222. Allocate to multiple work groups that can operate, and complete all the construction contracted on the construction day within that day (preferably by 5:30 pm at the latest), and user-designated for each construction As a general rule, the conditions for starting work within the construction time zone of

In the following, the standard work time database 2 to be referred to when all 23 construction projects shown in the order file list of FIG. 4 should be carried out in the Yokosuka area on a specific day.
21 and the work speed level database 222 are created as data tables as shown in FIGS. 2 and 3, respectively, the details of the work sorting table creation process will be described with reference to the flowchart of FIG. Normally, this work is done the day before the construction day.

First, the order file list for the construction day is displayed on the display 23 of the computer 20 to obtain the order data for the day (S).
1). As mentioned above, work conditions such as group designation and skill elements can be changed on the display screen (Fig. 4) displaying the order file list on the day, and when there is an addition to the construction project to be done on the day. Can add the construction project.

Next, when a required key operation is performed on the display screen of the order file list (for example, clicking a "next" key (not shown) appearing on the screen),
The display is switched to the list display of all work groups belonging to the construction contractor (FIG. 6), and the work groups to which the work of the day is to be assigned are designated on this display screen (S2). In order to simplify the explanation, it is assumed here that three work groups with code numbers 34, 37, and 45 can operate in the Yokosuka area on the day, and a check mark "Re" is entered in the "Vehicle allocation" column of these three work groups. After that, click the “Next” key (not shown).

By S1 and S2, the construction items to be subjected to the work sorting process and the work teams in charge of those construction items are determined. Therefore, the CPU 21 having received this, activates the sorting table creation program 225 to execute a plurality of types. A work sorting table is created (S3). The sorting table creation program 225 refers to the standard work time data table of FIG. 2 and the work speed level data table of FIG.
The process of allocating all the 23 construction projects acquired in S1 to the three work groups specified in S2 is executed, and the specific processing steps at that time will be described with reference to the flowcharts of FIGS. 14 and 15. This will be described below.

First, the processing steps for selecting the construction project (first project in the morning) to be in charge of the day for each work group are shown in the flowchart of FIG. 14, and all 23 constructions of the order file of FIG. 4 are constructed. The work for which the construction time zone in the morning is designated is extracted (S11), and the work with the predetermined priority is the first among the work groups designated in S2 among the construction works. Set the group as the processing target (S
12), the construction project located closest to the departure place (garage or sales office) is extracted (S13). Although the criteria for determining the priority is arbitrary, the order is the code number here, so in S12, the 34 teams with the smallest code number are selected from the designated construction projects in the morning, and the construction closest to the departure site is selected. The case is extracted in S13.

It should be noted that when extracting the "closest" construction site in S13, a predetermined judgment criterion is adopted, and for example, referring to the contractor address (that is, the construction site) in the order file, a straight line from the departure place is used. Select the shortest several construction sites in terms of distance, and refer to the Yokosuka district road map read from the road map database 223 of the memory 22 for these several construction sites, and the actual movement distance from the garage of 34 teams. And the construction project with the shortest moving distance can be regarded as the “closest” construction project. By referring to the traffic congestion information from VICS (Road Traffic Information and Communication System), the construction case with the shortest required travel time may be regarded as the “closest” construction case. Alternatively, some working groups may be good at working in a specific office area (area with the same telephone number) or a large building in the construction area. The construction projects to be carried out may be limited to a specific station area or a specific large-scale building, and the “closest” construction site may be extracted from them. For the first project in the morning, the specific station area or building concerned may be extracted. It is also possible to extract from the above, and for the subsequent projects, regardless of the station area or the like, those of the construction site having the shortest movement distance or the shortest movement time may be extracted.

The time required to move from the garage (or construction site) to the (next) construction site can be calculated from the relationship between the travel distance and an arbitrarily determined vehicle speed (for example, 10 km / h). If the road is congested, it will take more travel time than usual, but it is generally possible to predict the presence or extent of congestion in a specific area in relation to the day of the week and the time of day. By referring to the database of average vehicle speed and average travel time by date and time statistically created from these relationships, it becomes possible to predict the required travel time with high accuracy.

Next, referring to the order file of the construction project extracted in S13, it is confirmed whether or not the conditions of group designation and skill element are satisfied (S14). If not satisfied (S14: No), the construction project is re-extracted in S18, but in the order file of FIG. 4, no group is designated for all construction projects and no skill element is designated (S1).
4: Yes), the construction project is selected as the first project in the morning of the 34th group, and the work end time is predicted (S15). For example, No. 34 is the closest to the departure point of the 34th team. Assuming that the 17 construction projects were selected as the 1st project in the morning of the 34th group, the construction type of this construction project is "inside" (see Fig. 4), and the standard work time is "1" (Fig. 2), the working speed level of 34 teams is "0.5" (see Fig. 3), so this construction requires "1" x "0.5" = "0.5" = 40 minutes. Can be predicted. Therefore, when the 34th group starts work on this construction project from 9:00, the scheduled work end time is 9:40 (see FIG. 7).

Next, in S16, the first morning of all work groups
Determine whether the item is selected. Here, only the first case in the morning is selected for 34 teams (S16: N).
o), the processing target is moved to the next processing target, that is, the 37th group having the next smallest code number (S17), and similarly S14.
Then, the processing of S15 is performed, and the first case in the morning of group 37 is selected and the work end time is predicted. Next, the same processing is performed for the 45th team, the morning first case of the 45th team is selected, and the work end time is predicted. 37 teams and 4
Needless to say, the first project in the morning for Group 5 is selected from the construction projects excluding the already selected construction projects. Furthermore, regarding these work groups, the construction type / skill elements and construction location (bureau area and large scale If conditions such as buildings are specified, the first project in the morning is selected from the construction projects that can be selected at that time after considering them. In this example, No. 1 was selected as the first morning project of 37th group. No. 21 construction project (scheduled work end time is 9:24) was selected and No. 1 was selected as the first project in the morning of 45 teams. Nineteen construction projects (scheduled work end time is 10:28) are selected (see FIGS. 8 and 9). In addition, the garage departure time of each work group is determined based on the above-mentioned required travel time so that each work group arrives at the construction site of the first project at 9:00.

In this way, the first case in the morning is selected for all the work groups (S16: Yes).

The process steps for each work group to select the construction project (the second project after the morning) to be in charge thereafter are shown in the flowchart of FIG. 15, and the selection process for the second project in the morning will be described. The work group having the earliest scheduled work end time of the selected first work group in the first work group is extracted (S19), and the construction project located closest to the current location, that is, the construction site of the first work in the morning is extracted. Extract (S20). In this example, the 37th group finishes the work of the first item in the morning (9:24 am, see Fig. 8),
In S19, 37 teams are set as the processing target. The extraction of the “closest” construction project in S20 can be determined in the same manner as described above with respect to S13.

Then, it is determined in S21 whether or not the construction project extracted in S20 may be selected as the second morning project to be carried out by the work group. If not, the next closest construction project is extracted in S26. Then, the determination process of S21 is repeated. S21
Is similar to that already described for S14, and S2
Since item 6 is the same as that already described for step S18, the description thereof is omitted.

When it is confirmed that the construction project extracted in S21 satisfies the conditions of group designation and skill element (S21: Yes), whether the work group is in time for the construction time zone designated for the construction project. Whether or not it is determined based on the scheduled work completion time of the immediately preceding construction project and the moving time from there to the construction site of the next construction project (construction project extracted in S20 or S26) (S22). Is selected as the second morning project of the work group (37 group) and the work end time is predicted (S23).

Although the determination result in S22 does not affect the construction process selection process (work sorting table creation process) itself, as will be described later, when the work process of each group is displayed on the display, the designated construction time period is displayed. Construction projects in time for (●
It is necessary to distinguish and display the construction project (marked with ○) and the construction project that is not in time. The reason for not excluding construction cases that are not in time for the designated construction time zone in the work sorting table creation process is that if this is excluded, all construction projects acquired in S1 of FIG. 5 cannot be completed within that day. This is because there is a fear. Therefore, regardless of whether it is in time for the designated construction time, all the construction projects that must be done on that day are assigned to each work group for the time being, and then it was determined that it was not in time for the designated construction time With respect to construction projects, adjustments are made in time for the designated construction time by supplementary processing such as transfer of work and addition of work groups as described below.

As described above, the construction project to be in charge of the work group is selected next in order of the work end time, and all the construction projects for which the construction time zone in the morning is designated are selected (to any of the work groups). Allocation) (S24: Ye
The process ends in s).

In this example, No. 1 was selected as the second morning project of 37 teams. Construction work No. 10 was selected, and the work end time was predicted to be 10:01. The construction project of No. 13 is selected, and the work end time is predicted to be 10:36, and finally No. 13 as the second project in the morning of 45 teams. The construction project No. 07 is selected and the work end time is predicted to be 12:14 (see FIGS. 7 to 9).

The selection process after the third item in the morning is also S20 to S.
This is done in the same way as 28, and in this case the work completion schedule for the 2nd case in the morning is 37 teams, 34 teams, 45 teams in that order, so the conditions of S22 and S23 are determined in this order, and 3
No. 3 as the 3rd morning project of Group 7 The construction project No. 09 was selected, and the work end time is predicted to be 11:35, and 3
No. 3 as the 3rd morning project of Group 4 The construction project No. 04 is selected and the work end time is predicted to be 12: 01,
Finally, No. 4 as the 4th morning project of group 37. The construction item of 05 is selected, and the work end time is predicted to be 13:22. Since the scheduled work end time (11:35) of the third project in the 37th morning of group 37 is earlier than the scheduled work finish time (12:14) of the second project in the 45th group, No.
In S25 after the selection of the construction project in 04, 37 teams are extracted. Also, the scheduled end time of the 2nd morning project of group 45 is already past 12:00, and it is clear that it will not be in time for the designated construction project in the morning, so the 3rd morning project is not selected (above) 7 to 9). This selects all the construction projects with the designated construction time zone in the morning (S2
4: Yes), and thus the process according to the flowchart of FIG. 15 ends.

The selection process of the construction project that each work group should be in charge of in the afternoon is performed in substantially the same manner as in the morning. That is, a construction time zone in the afternoon is designated (in this example, the construction time zone from 1:00 pm to 3:00 pm and 1:00 pm to 5 pm)
There are two types of construction hours at the time, but the former is given priority), and for each work group, construction type, skill element,
When conditions such as the construction site are specified, the construction projects that do not meet those conditions are excluded, and the first project in the afternoon is selected in the order of the work group with the earliest scheduled work end time of the last construction project in the morning. In this example, the construction projects in the morning will be completed in the order of 34th group, 45th group, and 37th group. Therefore, in this order, the first project in the afternoon is selected first, and the second session in the afternoon is performed in the same manner as in the morning. Select after Item. In this way, the No.
08, No. 06, No. 16, No. 14, No. Two
3, No. No. 18 was selected as the 1st to 6th case in the afternoon of the 34th group, and No. 18 was selected. 12, No. 11, No. 15, N
o. 20, No. No. 22 was selected as the 1st to 6th case of the 37th group in the afternoon, and No. 22 was selected. 03, No. 01, No. 0
2 is selected as the 1st to 3rd case in the afternoon of 45 teams (see FIGS. 7 to 9).

As for the estimated work start time of each construction project except the first construction project (first project in the morning), the required travel time is based on the travel distance from the construction site immediately before that as described above. Is predicted, and the time required for movement has elapsed from the scheduled work completion time of the immediately preceding construction project. For example, it is predicted that the 34th group will finish the work on the 1st case in the morning at 9:40, and the time required to move from here to the location of the 2nd case in the morning is 16 minutes. The scheduled work start time is 9:56. The construction type of this construction project is “new” (see FIG. 4), and the standard work time is “1” (FIG. 2).
Since the work speed level of the work group of code number 34 is "0.5" (see Fig. 3), "1" x "0.5" = "0.5" = 40 minutes for this work. Since it can be predicted that this will require,
Minutes (see FIG. 7).

Work start time for the first case in the afternoon (FIGS. 7 to 9)
34) and 4)
Team 5 has a relatively early scheduled work end time for the last construction project in the morning, and should start work on the first project at 13:00 pm considering the time required to move from the construction site to the construction site for the first project in the afternoon. It is possible (see Figures 7 and 9), but for Team 37, the scheduled work end time for the last construction project in the morning has already exceeded 13:00, and this requires moving to the construction site for the first project in the afternoon. Due to the additional time, the scheduled work start time for the 1st case in the afternoon is 13:33 (Fig. 8
reference).

As described above, the first proposal for work sorting is created with the work process list for each group shown in FIGS. 7 to 9 as a set. A list of work processes for each group is displayed on the display 14.
You can check it by displaying it on the road map.

According to the work sorting according to the first plan, 3
The 4th morning project (N), which is the last construction project in the morning of Group 7
o. 05) and the 6th afternoon project (No. 22), which is the last construction project in the afternoon, cannot start work in the construction time zone designated by the user. That is, the scheduled work start time for the 4th case in the morning is 12:02, and the construction time zone (9:00 to 12) specified by the user in this construction.
It indicates that the work cannot be started at the time (see FIG. 8). By the way, the third project in the morning of group 37 (N
o. The scheduled work end time of 09) is 11:35,
At this point, the designated construction time zone from 9:00 am to 12:00 has not elapsed (S23: No), so No. 4 is selected as the fourth case in the morning. 05 is selected (S24), but this construction time period has passed during the movement from the third item in the morning to the fourth item in the morning. Similarly, the 6th afternoon of this 37th team
The scheduled work start time for the project is 17:02, and the construction time zone (1
It indicates that the work cannot be started from 3:00 to 17:00). When the work process list for each group in FIG. 8 is displayed on the display, the fields of these construction projects are highlighted or displayed in a different color from other construction projects (work can be started in the construction time zone specified by the user). Are displayed separately.

The work sorting according to the first plan is displayed on the display as shown in FIG. As mentioned above, this first
According to the work classification plan of No. 37, since the last construction project in the morning of the 37th group and the last construction project in the afternoon cannot be started in the construction time zone designated by the user, these construction project columns are also displayed in the display screen of FIG. It is displayed separately from the others. In FIG. 10, the work items that can start work in the work time zone designated by the user are indicated by ●, and those that cannot be started in the work time zone are indicated by ○. Further, in the work process list for each group (FIGS. 7 to 9), scheduled work end times in the morning and afternoon of each work group are also displayed.

Next, another work sorting plan is created by changing the priority order in S12 (S12).
3). Although a large number of work sorting plans may be created by randomly setting the priority order in S12, in this example, the priority order in S12 is 37.
By performing S13 to S15 and subsequent processing in the application order of the group, 45 group, and 34 group, and then performing S13 to S15 and subsequent processing in the application order of 45 group, 34 group, and 37 group, There are three types of work sorting plans.
FIGS. 11 and 12 show the display of the work sorting tables according to the second and third plans created in this way, similar to FIG. These second and third
According to the work sorting plan of No. 2, it is possible to start the work for any work group in the construction time zone specified by the user, and it is possible to smoothly complete all the 23 construction projects scheduled on the day. It has become a thing.

After creating these three types of work classification plans in S3, the CPU 21 outputs a list of the scheduled work completion times of the work groups whose work is the latest in each work classification plan to the display 23 (S4). (Fig. 13). If you double-click any scheduled work end time on this display screen, the screen will move to the display screen showing the work sorting table (see FIGS. 10 to 12) for each plan, and if you specify a specific work group here, the work group concerned will be displayed. The display screen showing the list of work steps for each group (see FIGS. 7 to 9) can be displayed, and the map screen (not shown) can be displayed from here by a predetermined operation.

In the actual operation of the computer 20, S1
When all the 23 works are specified in step S2 and the work group to which these works are to be assigned are specified in step S2, and the required key operation that prompts the creation of the work sorting plan is performed, the scheduled work end time shown in FIG. A display screen showing a list appears. In the example shown in FIG. 13, the scheduled work end times according to the first to third work sorting plans are 17:27, 17:15, and 17:35, among which the work of all work groups is the earliest. The second plan is to be completed, so if you check the details of the second plan as the first candidate, the work sorting table (Fig. 1) will be displayed.
The display screen shown in 2) is displayed, and it is confirmed that no work delay will occur in any work group.
The plan is finally selected as the work sorting (S5), and the work sorting processing is ended. In this embodiment, after confirming the presence or absence of work delay by referring to the work sorting table as shown in FIG. 12, the final plan is confirmed in S5 after waiting for the input by the computer operator. If two conditions are satisfied: the earliest scheduled time and no work delay in any work group, the CPU is
The program may be such that 21 automatically selects the plan.

The work process list for each group in the finally decided work sorting (corresponding to the one shown in FIGS. 7 to 9 for the first plan) is printed out by the printer 24 and brought out by group. Can be handed to each work group or transmitted to the vehicle 10 of each work group and displayed on the display 14 and / or output to the printer 15.

Although the procedure for creating each work classification plan has been specifically described above, in the actual processing, at least one work group causes a work delay in any of the plurality of work classification plans created. Sometimes. Hereinafter, complementary processing in such a case will be described.

For example, the scheduled work end time list of FIG. 13 in the above description is as shown in FIG. 16, and when the eleventh plan with the earliest scheduled work end time is the first candidate and its details are confirmed, It is assumed that the work process list for each group according to the 11th plan is displayed as shown in FIG. 34th group 3rd morning, 42nd group 3rd morning and 4th morning
A circle is attached to the case and the field of the fourth morning case of the 43rd group, and this proposal indicates that these construction cases cannot be started in the designated construction time zone.
In such a case, returning to the display screen of the scheduled work end time list of FIG. 16, the work sorting plan for which the work is finished sooner is sequentially selected, and the work sorting table is displayed on the screen. If there is no work delay in
It is possible to finally select the work classification plan, but in reality, all work classification plans have a work delay in one work group or no work delay in each work group. According to the report, the work end time may be extremely delayed. In such a case, with regard to the 11th plan, which has the earliest work end time, the possibility of transferring each construction project that causes a work delay to another work group is examined.

As an example, the procedure of work transfer for the morning third case of group 42 will be described. By double-clicking the column of the relevant construction item marked with a circle in the work sorting table of FIG. 17, the details of the construction item are displayed in the margin of the display 23 along with the construction details such as the scheduled work start time and scheduled work end time. The screen appears (Fig. 1
8). From this display screen, it is possible to confirm that the scheduled work start time of the construction project is 12:15, and that it will not be in time for the construction time zone designated by the user from 9:00 to 12:00.

Here, a required operation for promoting the transfer of this construction project to another work group (for example, clicking the "work transfer" key displayed on the display screen and clicking the "OK" key after confirmation thereof). ), The scheduled work start time when another work group is in charge of this construction project is based on the location of each work project incorporated in the morning of each work group and the scheduled work end time. 20 is calculated based on the work speed level of each work group (see FIG. 3) and the standard work time of the work type of the construction project (see FIG. 2). A work transfer selection screen such as that shown in is displayed on the display. In this screen, a star indicates that the work group will not be delayed even if the work is transferred, and a star indicates that the work group will be delayed after the work is transferred. In addition, the work project in the morning may be delayed due to the addition of the initially planned work project in the morning. This is shown in FIG. Then, it is shown by changing to a circle.

From the work transfer selection screen of FIG. 19, for example, in the 31st group, two construction projects were incorporated in the morning in the original work sorting plan (FIG. 17). , Even if the 42nd group's 3rd morning project is transferred, it will be in time for the user-specified construction time zone of the relevant construction project,
Moreover, it can be seen that even if this work transfer is performed, all the predetermined construction projects in the afternoon can be completed as scheduled, and the scheduled work end times in the morning and the afternoon are almost no problem. Here, if the transfer of work is urged by double-clicking on the ★ mark of the 3rd AM project in the 31st group,
The work sorting table after the work transfer as shown in 0 is displayed on the display. From the comparison with Fig. 17, for team 42 of the transfer source, the third project in the morning was deleted in the construction project column in the morning, and the fourth project in the afternoon moved to the third project in the morning. The scheduled work end time is earlier, and the third project in the morning is added to the transfer destination 31st group, and the scheduled work end time in the morning and afternoon is delayed accordingly. I know that

The work transfer processing as described above is sequentially carried out for each construction item marked with a circle indicating the work delay in the work sorting table of FIG. Ie 4
Even if the 3rd morning project of the 2nd group is transferred to the 3rd morning project of the 31st group, the 3 construction projects are still not in time for the construction time specified by the user (Fig. 20). Work transfer processing is performed sequentially.

Even with such work transfer processing, it is not always possible to transfer all the construction projects successfully. It is assumed that a work sorting table as shown in FIG. 21 is created after some work transfer processing. In Fig. 17, four construction projects were marked with a circle, but three construction projects could be transferred to another work group, but 3
Only the third project in the morning of group 5 could not be successfully transferred to other work groups, and it remains as a circle. When the corresponding work details are displayed by double-clicking the box marked with ○ in the work sorting table of FIG. 21 (FIG. 22), the scheduled work start time for this third AM project is 12: 1 and the user It can be seen that it is only 1 minute behind the designated construction time. Since a delay of this extent can be regarded as an allowable delay, the work sorting plan of FIG. 21 is finally adopted.

In any of the work sorting plans created in a plurality of cases, when the work delay of a plurality of construction projects cannot be eliminated even after the work transfer processing, or the work start delay exceeds the allowable range, Since it means that the initially planned work group cannot process all construction projects,
Add a work group and redo the work sorting process described above.
When the number of undecided construction projects marked with a circle is small, the work teams who have added these construction projects may simply be in charge.

The work transfer is not always incorporated as the final project in the morning or afternoon of the transfer destination, and the designated construction time period of the transfer target construction project and the completion of the work of each construction project of the transfer destination work group. Depending on the scheduled time and the relationship with the construction site, it may be included in a construction project during the morning or afternoon. For example, in the work transfer selection screen of FIG. 19, when the work is transferred to the 36th group or the 38th group, the work is incorporated into the 3rd morning project, and the 3rd morning project is put back to the 4th morning project.

Although the work transfer processing has been described, FIG.
In the flow chart of Fig. 2, even if it is necessary to add an order after obtaining the order data for the construction day on S1 and finally confirming one of the work sorting plans in S5, In the same manner, it is possible to confirm whether each work group can take charge of the additional order. For example, by clicking a "work addition" key (not shown) on the display screen displaying the work sorting table as shown in FIGS. 17, 20, and 21, a construction detail display screen as shown in FIG. 18 appears. On the screen, enter the required data such as designated construction time zone, construction site telephone number, construction type, line contractor name, and installation location. Alternatively, the additional order may be received directly from the construction ordering source, or may be received by data transmission or manual input from the terminal that has received the additional order and displayed as a construction detail display screen as shown in FIG. The result of assigning the additional order to each work group is the same as the work transfer selection screen of FIG. 19, and the additional order sorting selection screen is displayed. By double-clicking the mark of *, etc., the sorting process of the additional order is executed. Alternatively, the registered construction project closest to the construction site of the additional order (according to the above-mentioned criteria) is searched for, and the work team in charge of the construction project interrupts it as the next construction project to be in charge, and then A work sorting plan may be created in S3 of the flowchart of FIG.

It should be noted that the work transfer processing in the case where the construction time zone designated by the user is not in time (the work cannot be started during the construction time zone because the construction site has not arrived) has already been described. When the number of construction projects included in the file list (see Fig. 4) is relatively small, the work projects are distributed to each work group as described above. May arrive at the construction site. In this case, the work sorting process is terminated as it is, and in the work sorting table (see FIG. 17) of each draft created, the early-arriving construction project is replaced with another construction project (that satisfies the conditions of the designated construction time zone). (● mark) and those that do not meet the designated construction time (○ mark) will be displayed in a distinguishable manner. If many such early-arriving construction projects occur, it means that the number of operating work groups is too large for the number of construction projects and work contents to be done on the day, so the number of operating work groups should be reduced. (The number of work groups after reduction is reset in S2 of the flowchart of FIG. 5) and then the sorting process can be executed again.

Although some embodiments of the present invention have been described in detail with reference to the drawings, the present invention is not limited thereto, but is within the scope of the invention described in each claim of the claims. Can be widely modified. For example, in the above description, the standard work time database 221 that quantifies the standard work time for each work type and the work speed level database 222 that quantifies the work speed level for each work group are created in advance and stored in the center computer 20. It is stored in the memory 22, and in the work sorting table creation process, the standard work time for the work type of the work case in charge of each work group is read from the standard work time database, and the work speed level of the work group is set to the work speed. Although the work time is read from the level database and is multiplied by these to calculate the work time required for the work case in charge of each work group, the present invention is not limited to this specific method. For example, a work skill database in which the results of the work time required by each work group are recorded for each work type is stored in the memory 22 of the center computer 20, and the work cases required by each work group are referred to with reference to this. The working time may be predicted. Each time the work team takes charge of a work item, by incorporating the work time results, the work skill database is gradually updated to be highly reliable, and more accurate work time prediction becomes possible.

Further, in the above description, each work case is classified as work one by one, but, for example, in telephone construction, since a plurality of construction cases are related to each other, they are collectively processed by the same work group. There are cases where it should be done (new construction of telephone lines at the same address, telephone relocation work from the old address to the new address, etc.). In such cases, multiple related orders should be placed on the sorting process (S3 in the flowchart of FIG. 5). It is preferable to handle them collectively.

[0068]

As described above, according to the present invention, a work sorting table when telephone work or the like is divided among a plurality of work groups is performed automatically and efficiently by using a computer system. It has the effect that it can be created.

Further, in the present invention, since a plurality of types of work sorting plans are created, the work end scheduled time of the work group that finishes the work latest in each plan or the presence or absence of work delay of each work group in each plan is referred to. You can choose one of these options.

Further, when a work delay occurs in the work item in charge of any work group in the created work sorting plan, the work item can be transferred to another work group, and this work transfer processing is performed. This makes it possible to further optimize the work sorting plan.

[Brief description of drawings]

FIG. 1 is a block diagram showing an outline of a telephone construction management system to which the present invention is applied.

FIG. 2 is a data table showing an example of a standard work time database.

FIG. 3 is a data table showing an example of a work speed level database.

FIG. 4 is a diagram in which an order file for construction to be performed in a specific construction area (Yokosuka district, Kanagawa prefecture) on a specific construction day is read from the order file storage unit and displayed on the display.

FIG. 5 is a flowchart showing a work sorting table creation process according to the present invention.

FIG. 6 is a table showing a list of all work groups belonging to a construction contractor in a simplified application example.

FIG. 7 is a diagram showing a display of a work process list of one work group designed through the process steps shown in the flowcharts of FIGS. 14 and 15 and the subsequent process steps in the same case.

FIG. 8 is a diagram showing a display of a work process list of another work group, which has been devised through the same treatment process in the same case.

FIG. 9 is a diagram showing a display of a work process list of another work group, which has been designed through the same process in the same case.

FIG. 10 is a diagram in which a first plan of work sorting, which is designed as a set of work process lists for each group in FIGS. 7 to 9, is displayed on a display.

FIG. 11 is a diagram in which a second proposal of work sorting is displayed on a display.

FIG. 12 is a diagram in which a third plan of work sorting is displayed on a display.

FIG. 13 is a diagram in which a scheduled work end time of a work group, which finishes work latest in each work sorting plan shown in FIGS. 10 to 12, is displayed on a display.

FIG. 14 is a flowchart showing a processing step of selecting a construction project (first morning project) to be first in charge for each work group as a specific process for executing step S3 in the flowchart of FIG. .

FIG. 15 is a flowchart showing a processing step of selecting a construction project (the second project after the second morning) to be in charge for each work group after the processing steps shown in the flowchart of FIG.

FIG. 16 is a diagram in which the scheduled work end time of the work group, which finishes the work latest in each work sorting plan created in a more practical application example, is displayed on the display.

FIG. 17 is a diagram in which a work sorting plan with the earliest scheduled work end time in FIG. 16 is displayed on the display.

FIG. 18 is a diagram in which the construction details of the construction project in which the work delay has occurred in FIG. 17 are displayed on the display.

FIG. 19 is a diagram of a work transfer selection screen displaying a processing result when the construction project shown in FIG. 18 is transferred to another work group.

FIG. 20 is a diagram in which the work sorting plan after the work transfer is displayed on the display when the one case in which the work is not delayed is selected from the work transfer selection screen of FIG. 19;

FIG. 21 is a diagram showing a display of a work sorting plan after repeating the same work transfer process.

FIG. 22 is a diagram in which the construction details of a construction project in which a work delay occurs in the table of FIG. 21 are displayed on a display.

[Explanation of symbols]

Vehicle of 10 working groups 11 Car navigation system 12 GPS sensor 13 CPU 14 display 15 Printer 16 GPS antenna 17 antenna 20 Center computer 21 CPU 22 memory 221 Standard Working Time Database 222 Work speed level database 223 Road Map Database 224 Order file storage 225 Sorting table creation program 23 Display 24 printers 25 antenna

Claims (11)

[Claims] 1. A work item data including at least a work place and a work start time zone is acquired for each of a plurality of works to be completed within a specific period, and (b) the work is shared. (C) the current location of each work group, the work place and work start time zone of each work case in the work case data, and the work time required by each work group for each work case in charge From the above, a plurality of work assortment plans for work cases and work orders to be handled by each work group are created, and (d) any one of the plurality of created work assortment plans is selectably displayed. A method for sorting work by group, which is characterized by causing a computer to execute each process. 2. In the processing of (c), it is determined that the work item satisfying the condition of (c-1) work start time zone is closest to the departure place of the highest priority work group according to a predetermined priority order. The work item of the work place to be selected is set as the first work item of the highest priority work group, and in the same manner, according to the priority of the work group, the departure place of each work group among the work items excluding the already selected work item The work case of the work place that is determined to be closest to the work group is set as the first work case of each work group, and (c-2) it is determined that the work is completed earliest among the first work cases determined in this way. From the work group, among the work cases excluding the already selected work case, select the work case in the work place that is determined to be closest to the work place of the first work case in the work group, and select the second work case in the work group. And, in the same way, for the first work case The second work item of each work group is selected in the order of completion of the work, and (c-3) in the same manner, the first work sorting plan is created by allocating all work items to each work group, (c-4). By changing the priority of the work group, the above (c-
2. The method for sorting work by group according to claim 1, wherein a plurality of types of work sorting plans are created by executing the processing 1) and the subsequent processings (c-2) to (c-3). 3. The work time used in the process (c) is estimated based on a work skill database in which the actual work time required by each work group is recorded for each work type. The work sorting method according to section 1 or 2. 4. A standard work time database in which the standard work time for each work type is quantified, and a work speed level database in which the work speed level for each work group is quantified are created, and in the process of (c), The standard work time for the work type of the work item that each work group is in charge is read from the standard work time database, the work speed level of the work group is read from the work speed level database, and each work group is in charge by multiplying these. Characterized by calculating the work time required for the work item,
The method for sorting work by group according to claim 1. 5. In the processing of (d) above, for each of the work sorting plans created in a plurality of ways, the work end time of the work group that finishes the work of all work projects latest is predicted and displayed. Claim 1 characterized by the above.
The work sorting method according to any one of 1 to 4 above. 6. Even if the present time is within the work start time zone and the work place is the closest work item to the present position of the work group, the work is started considering the time required to move from the present position to the work place. When the time exceeds the work start time zone, in the process of (d), when the work group is in charge of the work case, it is displayed on the display that the condition of the work start time zone is not satisfied. A method for sorting work by group according to any one of claims 1 to 5. 7. The work start scheduled time when the work case is transferred to another work group for the work case displayed as not satisfying the condition of the work start time zone in the processing of (d), Calculated based on the location of each work case incorporated in each work group and their scheduled work end time, and in addition, calculate the scheduled work end time in that case based on the work time required by each work group, 7. The work sorting method for each group according to claim 6, further comprising displaying on a display whether or not the work can be transferred to each work group. 8. A method for receiving the instruction to transfer the work item to another work group, executing the work transfer, and displaying the work sorting plan after the work transfer on the display. Item-classified work sorting method according to item 7. 9. The group classification according to claim 1, wherein the work classification plan selected after the process of (d) is made into a group-specific work process table and can be output to a printer. Work sorting method. 10. The specific period in (a) above is a specific time zone of the day, and
A method for sorting work by group according to any one of 1 to 9. 11. A group-based work sorting program for causing a computer to execute each process in the group-based work sorting method according to any one of claims 1 to 10.