JP4385101B2 - Work completion system by listening survey - Google Patents

Description

【Technical field】
[0001]
  The present inventionListeningWork completion processing by investigationsystemIn more detail, for work such as telephone work and repair of OA equipment such as personal computers, copy machines, and facsimile machines, a work process list that specifies the work items that each work group should be in charge of and the order of the work is created in advance. In addition, when each work group works on a work item in the predetermined work order based on this work process list, a hearing survey is conducted from the work group immediately after the completion of each work, and the work contents, in particular, the work. The corresponding fee is efficiently and accurately calculated by computer processing and registered in the databasesystemAbout.
[Prior art]
[0002]
  As an example of telephone construction, a construction request received by a main contractor through a telephone, a sales window or a corporate sales is distributed to a telephone construction contractor, and data is transmitted as order information to a custom terminal of each contractor. 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 contractor.
[0003]
  Each contractor that has received the order information outputs a plurality of order information with the specified construction date from the custom terminal on the day before the construction date using a printer, and it is necessary for each order for each order. Check the tools, materials, etc., and create a work sorting table (also called group-specific take-out table) in consideration of construction reservation time, construction location (user address), construction content, etc. The work sorting table is created for each work group, and the construction location, construction content, scheduled construction start time, scheduled construction completion time, etc. are described in the order of construction.
[0004]
  On the day of construction, each work group performs the work in the specified order while confirming the orders assigned to the work group according to the work sorting table. When each construction is completed, each work group fills in the construction completion report with details of the construction details, and calculates the construction fee to be charged to the user using a predetermined calculation program and creates a construction fee breakdown. To the user. The work team that has completed all the work assigned on that day will submit a report on the completion of the work to the office.
[0005]
  The office that received the construction completion report collates this with the order information, confirms whether there are any changes in the construction content, materials used, etc., and then submits the records and reports to be submitted to the prime contractor. create.
[Problems to be solved by the invention]
[0006]
  As mentioned above, in the past, after completion of each work, the work team prepared a work completion report at the site and submitted it to the office after the work was completed on the day. This means that the completion process cannot be started until the work team that has completed all work on the day returns to the office. Normally, the work sorting table is created so that the last work ends at 5 pm to 6 pm, so even if there is some early arrival or delay, the work group that has completed all work will be in the office Arriving at is likely to concentrate in a specific time of the evening. In addition, since the work completion report to the main contractor company must be submitted the next day of the work, it is difficult to carry out work completion processing for all work teams under these time constraints, and it is difficult to carry out work conditions that extend to midnight. It has been pointed out that problems and the accuracy of processing are difficult to ensure.
[0007]
  The work group calculates the fee to be charged to the user every time the work is completed and gives it to the user as a construction fee breakdown. However, in the case of complicated work content, a calculation error may occur. there were. If a calculation mistake is found, it is necessary to contact the user the next day from the office to obtain consent, but it may cause troubles with the user or the occurrence of such a calculation mistake frequently causes the contractor to There was concern that reliability could be compromised.
[Means for Solving the Problems]
[0008]
  Therefore, the present invention aims to solve the above-mentioned problems in the prior art and to efficiently and accurately perform work completion processing on the day using a computer system when telephone work or the like is performed by a plurality of work teams. And
[0009]
  In addition, from the work team immediately after each workListeningThe purpose of the survey is to grasp the contents of the work in real time and to accurately calculate the fee according to the work.
[0010]
  In order to achieve these objectives, the present invention provides:A center computer provided with an arithmetic processing unit, a display, input means, a memory, a work group portable computer equipped with a printer, and data transmission / reception means for enabling data transmission / reception between the center computer and the work group portable computer. The memory of the center computer is a series of programs that can specify a predetermined program for calculating a charge according to the work content and conditions necessary for calculating the charge by the program by alternative answer or quantity entry. There is a question database stored as a question, and a completed work database that stores work contents including the work fee of completed work. The arithmetic processing unit of the center computer (a) stores the series of questions in the question database. (B) a process of reading from and sequentially displaying on the display A process of reading the program and calculating a work fee for the work based on an alternative answer or a quantity entry for the question items inputted via the force means, and displaying the display on the display; (c) the process A process for storing the work fee calculated in (b) in the completed work database; (d) a work fee breakdown is created based on the work fee calculated in (b), and this is transmitted via the data transmitting / receiving means. A work completion processing system based on a listening survey, characterized by executing a process to be transmitted to a work group portable computer.
DETAILED DESCRIPTION OF THE INVENTION
[0011]
  FIG. 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 team includes a GPS sensor 12, a central processing unit (CPU) 13, a display 14, a printer 15, and the like. The provided navigation system 11 is mounted.
[0012]
  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 GPS) that receives a correction signal for a positioning error transmitted from a predetermined base station and corrects the position is used, or a direction sensor (geomagnetic sensor, gyro sensor) , Wheel sensors, etc.), distance sensors, beacon receivers, etc. may be used in combination.
[0013]
  The CPU 13 receives a detection signal from the GPS sensor 12 and other positioning sensors, specifies the current location of the vehicle 10, displays the current location on the map of the display 14, and at the antenna 17 at a predetermined interval (for example, one minute interval). To the center computer 20.
[0014]
  The center computer 20 of the construction contractor is provided with a central processing unit (CPU) 21, a memory 22, a display 23, a printer 24, an input means 26 such as a keyboard, and the like. In the center 20, when the current location data of the vehicle 10 is received via the antenna 25, this is analyzed by the CPU 21 and displayed on the display 23.
[0015]
  In addition, the memory 22 connected to the CPU 21 so as to be able to transmit and receive data includes a standard work time database 221 empirically and statistically defined standard work time for each construction type, and an empirical work speed level for each work group. A statistically defined work speed level database 222 and a road map database 223 for displaying a road map of the district under the jurisdiction of the construction contractor and the surrounding district on the display 23 are stored.
[0016]
  FIG. 2 is a data table showing an example of the standard work time database 221, which corresponds to the code number for specifying the work type on the general telephone line and the work type standard corresponding to the work type specified by each code number. The process time is shown numerically. According to this data table, the standard process time of the “in-place” operation is set to “1”. For example, the standard process time of the “in-place” operation is set to “3”. Time is required, and the standard process time for the “public change” work is “5”, so it takes five times as long as the “in-place” work. When an unnecessary work type is deleted, a new work type is added, a standard process time of an existing work type is changed, the database 221 is updated accordingly, and the data table shown in FIG. Are displayed in the “update date and time” field (not shown in FIG. 2). The unit of the standard process time can be set arbitrarily, but in the data table of FIG. 2, it takes 80 minutes when the work group with the work level “1” described later works on the work with the standard process time “1”. Is defined as
[0017]
  An outline of specific construction contents of each work type displayed in the data table of FIG. 2 is as follows.
[0018]
  “Inside” = Construction of the new installation site for relocation without changing the telephone number of the subscriber telephone line
  "In-house" = Construction of the old installation site for relocation without changing the telephone number of the subscriber telephone line
  “Out-of-door” = Construction of a new installation site for relocation with change of telephone number of subscriber telephone line
  "Outing" = construction of the old installation site for relocation with change of telephone number of subscriber telephone line
  "Restoration" = work to revive what had been suspended subscriber telephone line rights
  "Suspension" = Construction to stop the subscriber telephone line and reserve the right
  “Appendix” = Construction to make subscriber telephone line available again
  "Left" = work to remove the wiring of subscriber telephone lines
  "Transfer" = work to divert subscriber telephone lines (change from analog to digital lines, etc.)
  "Addition / removal" = work to remove subscriber telephone lines
  "Landscape" = construction to install terminal equipment
  "Decommissioning" = work to remove terminal equipment
  "Change" = Construction to replace terminal equipment
  “Visit setting” = construction to install business phones
  "Busy abolition" = construction to abolish business phones
  “Business change” = work to replace business phones
  "N installation" = construction to newly establish services such as call waiting
  "A installation" = construction to newly establish a telephone number transfer notification service
  "Temporary access" = construction to install a temporary telephone line
  "Abolition" = construction to abolish temporary telephone lines
  "Damage" = work to remove the wiring of subscriber telephone lines that were lost due to an accident
  "Restoration" = construction to make it possible to use a subscriber telephone line that was lost due to an accident
  “Relocation” = Relocation of outdoor telephone service lines
  "New inclusion" = construction to establish a new subscriber telephone line
  "Preferential installation" = construction to enable use of the priority line (public telephone line)
  "Public change" = Public telephone transfer or telephone type change installation work
  “Dedicated” = Construction of a new dedicated line.
[0019]
  FIG. 3 is a data table showing an example of the work speed level database 222. A code number for identifying a work team and a work team identified by each code number (in this embodiment, one person constitutes one work team). Corresponding to the name of the work group (equal worker), the work level of the work group is shown numerically. According to this data table, for example, the work speed level of the work group of code 01 is “1.1”. Therefore, the “internal” is obtained by multiplying the standard process time of each work shown in the standard work time database of FIG. “1.1” work time (= 88 minutes) is required for the work, “3.3” work time (= 264 minutes) is required for the “going out” work, and “public change” work is required. It can be seen that “5.5” work time (= 440 minutes) is required. Similarly, since the work speed level of the work group of code 02 is “0.6”, the “in-place” work is “0” by multiplying the standard process time of each work shown in the standard work time database of FIG. .6 "work time (= 48 minutes)," In-house "work is" 1.8 "work time (= 144 minutes), and" Public change "work is" 3 "work time (= 240 minutes). That is, the smaller the “work level” value in the work speed level data table shown in FIG. 3, the more skilled the worker is and the faster the work speed is.
[0020]
  In addition, the work speed level data table of FIG. 3 indicates for each work team whether the construction of a special line other than a general telephone line is possible ("1") or impossible ("0"). Has been. According to this data table, in addition to general telephone line construction, the work group with code 01 sets up the Internet and mail settings for personal computers and other devices for users who have purchased a specified terminal device through ISDN64 telephone line construction. Work), "public" (public phone installation work) and "dedicated" (dedicated line installation / decommissioning work) can be performed, but "business phone" (multifunctional telephone installation work for business users) ) And “Home Telephone” (installation of multi-function telephones for general users) cannot be assigned. The work team with code 02 has the ability to do all the work.
[0021]
  When the data stored in the work speed level data table of FIG. 3 is changed or when a work team is added or deleted, the database 222 is updated accordingly, and the data table of FIG. It is displayed in the “update date and time” column in the middle (not shown in FIG. 3).
[0022]
  Further, the CPU 21 sets the work type, the work place, the work date, and the user-designated work time zone (in this embodiment, 9 am to 12:00, 1 pm to 3 pm) for the work received from the work ordering company to the construction contractor. Order information including, for example, that the construction should be started in three time zones from 1 pm to 5:00 pm), etc., directly from the construction ordering source, or from the terminal that received this The order file is created by making a list for each construction date and a certain construction area, and is stored in the order file storage unit 224 of the memory 22.
[0023]
  The CPU 21 also orders the work in charge of each work team according to the work sorting plan created as described later (see FIG. 21), construction location, telephone number, user (contractor) name, construction time specified by the user. Data relating to the band, the construction type, the scheduled construction start time, the scheduled construction completion time, the construction order, and the like are stored in the work sorting database 226. Further, detailed data of the construction content obtained through a hearing survey as described later when each construction of each work group is completed is stored in the completed construction database 227.
[0024]
  Further, the memory 22 stores a predetermined calculation program 228 for calculating a fee according to the construction content, and a question item for specifying a condition necessary for calculating the fee by the predetermined calculation program. It is stored as the question item database 229. The questions are prepared in advance as a series of questions that can be specified by alternative answers (Yes / No) or quantity entry via the input means while referring to the display.
[0025]
  FIG. 4 shows the order file for the work to be performed in a specific work area (here, Yokosuka area, Kanagawa) read from the order file storage unit 224 and displayed on the display. , Construction site telephone number (abbreviated below the area code), construction type, standard construction time expected to be constructed (corresponds 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, the presence / absence of group designation by the user, the skill element indicating whether the telephone line to be constructed is a general line or a special line, and the contractor name of the telephone line to be constructed (Display omitted) and its installation location (display omitted below towns) are displayed in a list display format. In this example, there is no team designation for any construction, and all construction is shown as being for general lines (no skill element), but this display can be used to change these as needed. Enter on the screen.
[0026]
  The CPU 21 creates a work sorting table when the work undertaken is shared among a plurality of work groups. The work sorting table is created by referring to the standard work time database 221 and the work speed level database 222 for work to be performed in a specific work area on a specific work day listed in the order file. Allocate to multiple operational teams to complete all work undertaken on the construction day within that day (preferably by 5:30 pm at the latest) and specify each work by the user As a general rule, the conditions for starting work within the construction time period of
[0027]
  Hereinafter, when all the 23 construction projects shown in the order file list of FIG. 4 are to be performed in the Yokosuka area on a specific day, the standard work time database 221 and the work speed level database 222 to be referred to are shown in FIGS. The details of the work sorting table creation processing will be described with reference to the flowchart of FIG. 5 assuming that the data table is created as shown in FIG. Normally, this work is performed the day before the construction date.
[0028]
  First, the order data of the day is acquired by displaying the order file list of the construction day on the display 23 of the computer 20 (S1). As mentioned above, work conditions such as team designation and skill elements can be changed on the display screen (Fig. 4) on which the order file list is displayed on the day. Can add the construction project.
[0029]
  Next, when a required key operation is performed on the display screen of the order file list (for example, clicking on the “Next” key (not shown) that appears on the screen), the display is displayed for all the working groups belonging to the construction contracting company. The display is switched to the list display (FIG. 6), and a work team to which the work of the day is to be assigned is designated on this display screen (S2). In order to simplify the explanation, it is assumed here that three work teams with code numbers 34, 37 and 45 can be operated in the Yokosuka area on the day, and check “Re” in the “Vehicle allocation” column of these three work teams. After that, click the “Next” key (not shown).
[0030]
  Since the work items to be subjected to the work sorting process and the work teams in charge of the work items are determined by S1 and S2, the CPU 21 that has received this activates the sort table creation program 225 to execute a plurality of work sort tables. Is created (S3). The sorting table creation program 225 refers to the standard work time data table in FIG. 2 and the work speed level data table in FIG. 3 and assigns all 23 construction projects acquired in S1 to the three work groups designated in S2. The distribution process is executed, and specific processing steps at that time will be described below with reference to the flowcharts of FIGS.
[0031]
  First, the process of selecting the construction project (first project in the morning) that should be handled first for each work group is shown in the flowchart of FIG. 14, and among the 23 construction projects in the order file of FIG. The ones designated for the morning construction time zone are extracted (S11), and among those construction projects, the work teams having the first predetermined priority among the work teams designated in S2 are processed. The target is set (S12), and the construction project located in the nearest place from the departure place (garage or sales office) is extracted (S13). The criteria for determining the priority order are arbitrary, but in this case, the order is the code number. In S12, 34 teams with the smallest code number are selected from the designated construction projects in the morning, and the construction closest to the departure place is selected. Items are extracted in S13.
[0032]
  It should be noted that a predetermined judgment criterion is adopted when extracting the “closest” construction place in S13, for example, referring to the contractor address (that is, the construction place) in the order file, and the shortest straight line distance from the departure place. Selected several construction sites, and calculated the actual distance traveled from the 34th garage by referring to the road map of the Yokosuka area read from the road map database 223 in the memory 22 for these several construction sites. Thus, the construction project with the shortest travel distance can be regarded as the “closest” construction project. With reference to traffic jam information from a VICS (road traffic information communication system), a construction project with the shortest travel time may be regarded as the “closest” construction project. Or, depending on the work group, there are cases where it is good at work in a specific station area (area with the same telephone number) in a construction area or a specific large-scale building. The construction projects to be performed may be limited to a specific station area, a specific large-scale building, etc., and the “closest” construction site may be extracted from among them, or the first station in the morning for the specific station area or building It is also possible to extract the items from the construction site with the shortest travel distance and the shortest travel time without regard to the station area or the like.
[0033]
  Further, 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 / hour). If the road is congested, it will take more travel time than usual, but in certain areas it is generally possible to predict the presence and extent of traffic jams in relation to the day of the week and the time zone. By referring to the database of the average vehicle speed and average travel time for each date and time created statistically from these relationships, it is possible to predict the required travel time with high accuracy.
[0034]
  Next, with reference to the construction project order file extracted in S13, it is confirmed whether or not the conditions of group designation and skill elements are satisfied (S14). If it is not satisfied (S14: No), the construction project is re-extracted in S18. However, in the order file in FIG. 4, there is no group designation for all construction projects and no skill element designation (S14: Yes). This construction project is selected as the first project in the morning of 34 groups, and the work end time is predicted (S15). For example, No. 34 is the closest to the starting point of 34th team. Assuming that 17 construction projects are selected as the first project in the morning of 34 teams, the construction type of this construction project is “Internal” (see FIG. 4), and its standard work time is “1” (see FIG. 4). 2), the work speed level of 34 teams is “0.5” (see FIG. 3), so this work requires “1” × “0.5” = “0.5” = 40 minutes. Can be predicted. Therefore, if the 34th group starts work on this construction project from 9:00, the scheduled work end time is 9:40 (see FIG. 7).
[0035]
  Next, in S16, it is determined whether or not the first case has been selected for all work groups. Here, since only the first case is selected for the 34th group (S16: No), the process target is moved to the next process target, that is, the 37th group with the next smallest code number (S17), and similarly S14 and S15. The first process of 37 groups is selected and the work end time is predicted. Next, the same process is performed for 45 teams, the first project in the morning of 45 teams is selected, and the work end time is predicted. It goes without saying that the first project in the morning for teams 37 and 45 is selected from among the construction projects excluding the construction projects that have already been selected. If there are conditions such as a large-scale building), the first project in the morning is selected from the construction projects that can be selected at that time. In this case, no. 21 construction projects (the scheduled end time of the work is 9:24) are selected, and No. 15 is the first project in the morning of 45 teams. Nineteen construction projects (the 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 required travel time so that each work group arrives at the construction site of the first project at 9:00 am.
[0036]
  In this manner, the first case is selected for all work groups (S16: Yes).
[0037]
  FIG. 15 is a flowchart showing a process for selecting a construction project (after the second morning project) that each work group should be in charge of. The process for selecting the second project in the morning will be described. The work group having the earliest scheduled work end time of the first project in each morning is extracted (S19), and the construction project closest to the current location, that is, the construction site of the first project in the morning is extracted (S19). S20). In this case, the 37th group finishes the work of the first project in the morning first (9:24 AM, see FIG. 8), so the 37th group is set as a processing target in S19. The extraction of the “closest” construction item in S20 can be determined in the same manner as described above for S13.
[0038]
  Next, in S21, it is determined whether or not the construction project extracted in S20 can be selected as the second morning project to be performed by the work group. Repeat the determination process. S21 is the same as already described with respect to S14, and S26 is the same as already described with respect to S18.
[0039]
  When it is confirmed that the construction project extracted in S21 satisfies the conditions of the team designation and skill elements (S21: Yes), whether or not the work team is in time for the construction time zone designated for the construction project. Judgment is made on the basis of the scheduled work end time of the immediately preceding construction project and the travel time from there to the construction site of the next construction project (construction project extracted in S20 or S26) (S22). The group (37 group) is selected as the second project in the morning and its work end time is predicted (S23).
[0040]
  Although the determination result in S22 does not affect the construction item selection process (work sorting table creation process) itself, as will be described later, when the work process for each team is displayed on the display, the construction is in time for the designated construction time zone. Necessary for distinguishing and displaying projects (● marks) and construction projects (○ marks) that are not in time. The reason for not eliminating construction cases that are not in time for the designated construction time period in the work sorting table creation process is that if they are eliminated, all construction projects acquired in S1 of FIG. 5 cannot be completed within the same day. Because there is a fear. For this reason, all the construction projects that must be carried out on the same day, regardless of whether or not they are in time for the designated construction time zone, are assigned to each work team for the time being, and then it is determined that the designated construction time zone is not in time. For construction projects, adjustments are made in time for the designated construction time zone by means of supplementary processing such as work transfer and work group addition as described below.
[0041]
  As described above, the construction work to be handled next for the work team was selected in the order of the work end time, and all the construction works for which the morning construction time zone was designated were selected (assigned to any work team). If so (S24: Yes), the process is terminated.
[0042]
  In this case, No. 1 is the second project in the morning of 37 teams. 10 construction projects are selected, and the work end time is predicted to be 10:01. 13 construction projects were selected, and the work end time was predicted to be 10:36. 07 is selected and the work end time is predicted to be 12:14 (see FIGS. 7 to 9).
[0043]
  The selection process after the third case in the morning is performed in the same manner as S20 to S28. In this case, the work end schedule of the second case in the morning is in order of 37 groups, 34 groups, and 45 groups, so S22 and S23 in this order. No. as the third project in the morning of 37 groups. 09 construction was selected and its work end time was predicted to be 11:35. 04 construction project is selected, and the work end time is predicted to be 12:01. A construction project of 05 is selected and its work end time is predicted to be 13:22. Note that the scheduled work end time (11:35) of the third project of 37 teams is earlier than the scheduled work end time (12:14) of the second project of 45 teams. In S25 after selecting the construction project of 04, 37 teams are extracted. In addition, since the scheduled end time of the work of the 2nd morning of 45 teams is already past 12:00, it is clear that it will not be in time for the construction work designated in the morning, so the third project will not be selected (above) FIG. 7 to FIG. 9). As a result, all the construction projects for which the morning construction time zone is designated have been selected (S24: Yes), and the processing according to the flowchart of FIG. 15 is terminated.
[0044]
  The selection process of construction projects that each working group should be in charge of in the afternoon is performed in substantially the same manner as in the morning described above. That is, the construction time zone in the afternoon is specified (in this example, there are two construction time zones, 1 to 3 pm and 1 pm to 5 pm, but the former takes precedence) If there are conditions such as construction type, skill element, construction location, etc. for each work group, excluding construction projects that do not meet those conditions, and scheduled work end time for the last construction project in the morning The first project is selected in the order of the work group with the earliest. In this case, it is the 34th, 45th, and 37th teams that end the construction work in the morning, so the first project in the afternoon is first selected in this order, and the second afternoon is performed in the same manner as in the morning. Select after the item. In this way, no. 08, no. 06, no. 16, no. 14, no. 23, no. 18 was selected as the 1st to 6th project in the afternoon of 34th group, 12, no. 11, no. 15, no. 20, no. No. 22 was selected as the 1st to 6th project in the afternoon of 37th group. 03, no. 01, No. 02 is selected as the 1st to 3rd projects in the afternoon of 45 groups (see FIGS. 7 to 9).
[0045]
  As for the estimated work start time of each construction project except the first construction project (first project in the morning), the travel time is predicted based on the travel distance from the previous construction site as described above. The time required for the movement has elapsed from the scheduled work end time of the immediately preceding construction project. For example, 34 teams are expected to finish working on the first project in the morning at 9:40, and the travel time from here to the second project location is 16 minutes, so the second project in the morning The scheduled work start time is 9:56. The construction type of this construction project is “new” (see FIG. 4), the standard work time is “1” (see FIG. 2), and the work speed level of the work group with code number 34 is “0”. .5 ”(see FIG. 3), it can be predicted that this work will require“ 1 ”ד 0.5 ”=“ 0.5 ”= 40 minutes, so the scheduled work end time is 10:00. 36 minutes (see FIG. 7).
[0046]
  Regarding the work start time of the first project in the afternoon (described in the “Plan” column in FIGS. 7 to 9), the 34th and 45th teams have a relatively early scheduled work end time for the last construction project in the morning, Even if the time required for moving the first project to the construction site is taken into consideration, the first project in the afternoon can be started at 13:00 (see Figs. 7 and 9). The scheduled end time of work has already exceeded 13 o'clock, and the time required to move to the construction site for the first project in the afternoon is added to this, so the scheduled work start time for the first project in the afternoon is 13:33 (See FIG. 8).
[0047]
  As described above, the first work sorting plan is created by setting the work process list for each team shown in FIGS. The list of work processes for each team can be displayed on the road map on the display 14 and confirmed.
[0048]
  According to the work classification according to the first plan, the 37th group's last construction project in the morning, No. 4 (No. 05), and the last construction project in the afternoon, No. 6 (No. 22), are the users. The work cannot be started at the designated construction time. In other words, the scheduled work start time of the fourth project in the morning is 12:02, indicating that the work cannot be started in the construction time zone (9:00 to 12:00) designated by the user in this construction. (See FIG. 8). By the way, the scheduled work completion time of the third project (No. 09) of 37 teams is 11:35, and the designated construction time zone from 9:00 am to 12:00 has not passed at this time (S23: No), so No. 4 as the fourth project in the morning. 05 is selected (S24), but this construction time zone has elapsed during the transfer from the third morning project to the fourth morning project. Similarly, the scheduled work start time for the 6th project of this 37th group is 17:02, and the work starts in the construction time zone (13: 00-17: 00) designated by the user in this construction. Indicates that you cannot. When the work process list for each team shown in FIG. 8 is displayed on the screen, these construction item columns are displayed in reverse or in a different color display from other construction items (things that can be started at a user-specified construction time zone). Are displayed separately.
[0049]
  The work sorting according to the first plan is displayed on the display as shown in FIG. As described above, according to this first work sorting plan, since the last construction project in the morning of 37 groups and the last construction project in the afternoon cannot be started at the construction time specified by the user, the display screen of FIG. These are also displayed in distinction from other construction projects. In FIG. 10, construction projects that can be started in the construction time zone designated by the user are indicated by ●, and those that cannot be started in the construction time zone are indicated by ○. In addition, in the work process list for each team (FIGS. 7 to 9), the scheduled work end times in the morning and afternoon of each work group are also displayed.
[0050]
  Next, another work sorting plan is created by changing the priority in S12 (S3). 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 set in the order of application of the 37th group, the 45th group, and the 34th group. The process of S15 and subsequent steps is performed, and next, the processes in S13 to S15 and subsequent steps are performed in the order of application of the 45th group, the 34th group, and the 37th group, so that a total of three work sorting plans are created. FIG. 11 and FIG. 12 show the work sorting tables created in the above-described manners according to the second and third plans in the same manner as in FIG. According to these second and third work sorting plans, any work group can start work during the construction time specified by the user, and all 23 construction works scheduled for the day have been delayed. It has become something that can be digested without.
[0051]
  After creating these three types of work sorting plans in S3, the CPU 21 outputs a list of scheduled work end times of the work teams whose work is completed most recently in each work sorting plan to the display 23 (S4, FIG. 13). . Double-clicking any scheduled work end time on this display screen shifts to a display screen showing a work sorting table (see FIGS. 10 to 12) for each plan. When a specific work team is designated here, the work team It is possible to shift to a display screen showing a list of work processes for each group (see FIGS. 7 to 9), and from here to a map screen (not shown) by a predetermined operation.
[0052]
  In actual operation of the computer 20, if all 23 works are identified in S 1 and work groups to be assigned to these works are identified in S 2, then the required key operation for prompting creation of work sorting plans is performed. A display screen showing a list of scheduled work end times as shown in FIG. 13 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, and the work of all the work teams is the earliest among them. Since the second plan is completed, confirming the details of the second plan as the first candidate results in a display screen showing the work sorting table (FIG. 12), and no work delay occurs in any work team. Therefore, the second plan is finally selected as work sorting (S5), and the work sorting process is terminated. In this embodiment, after confirming the presence or absence of work delay with reference to the work sorting table as shown in FIG. 12, the final plan is confirmed in S5 after waiting for input by the computer operator. If the two conditions of the earliest scheduled time and no work delay in any work team are satisfied, the CPU 21 may automatically select the plan.
[0053]
  A list of work processes for each team in the finally determined work sorting (corresponding to those shown in FIGS. 7 to 9 for the first proposal) is printed out by the printer 24 and each work is taken out as a group-specific take-out table. It can be handed to the team or transmitted to the vehicle 10 of each work team to display on the display 14 and / or output to the printer 15.
[0054]
  Although the procedure for creating each work sorting plan has been specifically described above, in actual processing, work delays may occur in at least one work team in any of the plurality of work sorting plans created. . Hereinafter, complementary processing in such a case will be described.
[0055]
  For example, the list of scheduled work end times in FIG. 13 in the above description is as shown in FIG. 16, and when the eleventh plan having the earliest scheduled work end time is confirmed as the first candidate and the details are confirmed, It is assumed that a list of work processes for each team according to the plan is displayed as shown in FIG. A circle is marked in the column of the 3rd morning project of 34th group, the 3rd and 4th morning project of 42th group, and the 4th morning project of 43th group. It is shown that work cannot be started in the time zone. In such a case, the screen returns to the display screen of the scheduled work end time list in FIG. 16, and the work sorting plan that the work is to be completed next is selected in sequence and the work sorting table is displayed on the screen. If there is something that does not cause any work delay at all, it is possible to finally select the work sorting plan, but in fact, there is work delay in any work group in all work sorting plans According to the proposal that no work delay occurs in each work group, the work end time may become extremely late. In such a case, for the 11th plan with the earliest work end time, it is examined whether it is possible to transfer each construction project in which work delay occurs to another work team.
[0056]
  As an example, a procedure for transferring work for the third morning project of 42 groups will be described. When double-clicking the column of the construction project marked with a circle in the work classification table of FIG. 17, construction details such as the scheduled work start time and the scheduled work end time are displayed in the margin of the display 23 together with details of the construction project. A screen appears (FIG. 18). From this display screen, it is possible to confirm that the scheduled work start time of the construction project is 12:15, and it is not in time for the construction time zone specified by the user from 9:00 to 12:00.
[0057]
  Here, a necessary operation for urging to transfer this construction project to another work team (for example, clicking the “work transfer” key displayed on the display screen and clicking the “OK” key after confirmation) is performed. And the work start scheduled time when other work groups are in charge of this construction project is calculated based on the location of each work project incorporated in the morning of each work team and their scheduled work end time, Further, the scheduled work end time in that case is calculated based on the work speed level of each work team (see FIG. 3) and the standard work time of the work type of the construction project (see FIG. 2), as shown in FIG. And display it on the appropriate work transfer selection screen. In this screen, a star indicates that there is no work delay in the work team after the transfer of work, and a ☆ mark indicates that a work delay occurs in the work team after the work transfer. In addition, there may be a delay in the construction work in the afternoon due to the addition of the construction work in the morning that was initially scheduled, and this is the case where the construction work in the afternoon was ● in FIG. It is shown by changing to a circle.
[0058]
  From the work transfer selection screen of FIG. 19, for example, in the initial work sorting plan (FIG. 17) in Group 31, two construction projects were incorporated in the morning. Even if the third project is transferred in the morning, it will be in time for the construction time specified by the user of the construction project, and even if this work transfer is performed, all the predetermined construction projects in the afternoon can be digested as scheduled. It can also be seen that the scheduled work end time in the afternoon is almost no problem. Here, when the execution of work transfer is urged by, for example, double-clicking the ★ mark of the third project in the morning of 31 groups, a work sorting table after the work transfer as shown in FIG. 20 is displayed. From the comparison with FIG. 17, for the 42 teams of the transfer source, the third project was deleted in the morning construction project column and the fourth project was moved to the third project in the morning. The scheduled work end time is earlier, and for the 31 transfer teams, a third project is added in the morning construction project column, and the scheduled work end times in the morning and afternoon are delayed accordingly. I understand that.
[0059]
  The work transfer process as described above is sequentially performed for each construction project marked with a circle indicating work delay in the work sorting table of FIG. In other words, even if the work in the morning of 42 teams is transferred to the work in the 3rd morning of 31 teams, the three construction projects are not in time for the user-specified construction time zone (FIG. 20). The work transfer process is performed sequentially.
[0060]
  Even with such work transfer processing, it is not always possible to transfer all construction projects successfully. Assume that a work sorting table as shown in FIG. 21 is created after several work transfer processes. In FIG. 17, four construction projects were marked with ○, but three of them were transferred to other work groups, but only the third work in the morning of 35 teams was the other work group. It cannot be transferred successfully to, and remains as a circle. When the corresponding construction details are displayed by double-clicking this circled column in the work sorting table of FIG. 21 (FIG. 22), the scheduled work start time of this third project is 12:01, and the user It can be seen that there is a delay of only 1 minute in the designated construction time zone. Since such a delay can be regarded as an allowable delay, the work sorting plan shown in FIG. 21 is finally adopted.
[0061]
  In any of the work sorting proposals created in multiple ways, if work delays of multiple construction projects are still not resolved after work transfer processing, or if the work start delay exceeds the allowable range, it is initially planned This means that not all work items can be processed in the work group, so add the work group and redo the work sorting process described above. If there are a small number of unsettled work projects marked with a circle, the work group to which these construction projects have been added may simply be assigned.
[0062]
  In addition, work transfer is not necessarily incorporated as the final project in the morning or afternoon of the transfer destination, the designated work time zone of the transfer target construction project and the scheduled work end time of each construction project of the transfer destination work group and Depending on the relationship with the construction site, it may be incorporated into construction projects in 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, it is incorporated into the third project in the morning, and the third project in the morning is initially moved down to the fourth project in the morning.
[0063]
  The work transfer process has been described. In the flowchart of FIG. 5, after acquiring the order data on the day of construction in S1, it is necessary to add an order until one of the work sorting plans is finally confirmed in S5. Even in such a case, it is possible to confirm whether or not each work team can be in charge of the additional order in the same manner as in the case of work transfer. For example, when a “work addition” key (not shown) is clicked on a display screen displaying work sorting tables as shown in FIGS. 17, 20, and 21, a construction details display screen as shown in FIG. 18 appears. On the screen, enter the required data such as the designated construction time zone, construction site telephone number, construction type, line contractor name, installation location, etc. Alternatively, the additional order may be directly received from the construction ordering source, or may be captured by data transmission or manual input from the terminal that has received the additional order and displayed as a construction details display screen as shown in FIG. As a result when each work group is in charge of the additional order, the additional order sorting selection screen shown in the same manner as the work transfer selection screen of FIG. 19 is displayed on the display, and the work item column of the work group recognized as the optimum among them is displayed. Additional order sorting processing is executed by double-clicking the ★ mark. Alternatively, after finding the registered construction project closest to the construction site of the additional order (based on the above criteria), the work group in charge of that construction project will be interrupted as the next construction project to be handled. The work sorting plan may be created in S3 of the flowchart of FIG.
[0064]
  In addition, as described above, the work transfer process in the case where it is not in time for the construction time zone specified by the user (the work cannot be started because it does not arrive at the construction place during the construction time zone), the order file list of the day ( If the number of construction projects included in Figure 4) is relatively small, the construction projects are distributed to each work group as described above. It is possible to arrive at the place. In this case, the work sorting process is terminated as it is, and in the created work sorting table of each plan (see FIG. 17), the early-arrived construction project is replaced with another construction project (that satisfies the conditions of the designated construction time zone). (●) and items that do not meet the designated construction time (○) are displayed in an identifiable manner. If there are many such early-arrival construction projects, it means that there are too many working teams for the number of construction projects and constructions to be performed on the day, so reduce the number of working teams. The sorting process can be executed again after resetting the number of work groups after reduction in S2 of the flowchart of FIG.
[0065]
  In the above description, the standard work time database 221 in which the standard work time for each work type is digitized, and the work speed level database 222 in which the work speed level for each work team is digitized are created in advance, and the center computer 20 Stored in the memory 22, in the work sorting table creation process, the standard work time for the work type of the work item that each work group is in charge of is read from the standard work time database, and the work speed level of the work group is set to the work speed. Although reading from the level database and multiplying them to calculate the work time required for the work item that each work group is in charge of, it is not limited to this specific method. For example, a work skill database in which the work time required by each work group is recorded for each work type is stored in the memory 22 of the center computer 20 and is referred to for the work items handled by each work group. The working time may be predicted. Each time a work group takes charge of a work item, the work time results are taken in, so that the work skill database is gradually updated and a more accurate work time prediction becomes possible.
[0066]
  In the above explanation, each work item is classified as one by one. For example, in telephone construction, when multiple work items are related to each other, the same work group should process them together ( In this case, multiple related orders are grouped together in the sorting process (S3 in the flowchart of FIG. 5). It is preferable to handle.
[0067]
  As described above, when it is determined that the work sorting plan in FIG. 21 is finally adopted, the center computer 20 stores the work sorting data in the work sorting database 226 in the memory 22. The work sorting data stored in the work sorting database 226 can be displayed on the display 23 as a work process list (see FIGS. 7 to 9) to be handled by each work group, if necessary.
[0068]
  In the present invention, when each work team works on a work item in a predetermined work order based on the work process list as shown in FIG. 7 to FIG. 9, a hearing survey from the work team is performed immediately after each work is completed. The present invention relates to a method for efficiently and accurately calculating the contents of the work, in particular, a charge corresponding to the work, and registering it in the database. The embodiment will be described with reference to the work process list in FIG. To do.
[0069]
  Corresponding to the work process list of FIG. 7, the order number, construction location, telephone number, user (contractor) name, construction time zone designated by the user, construction type, scheduled construction start time, Since the data related to the scheduled construction end time and the construction order are created by the center computer 20 up to the day before the order and stored in the work sorting database 226 in the memory 22, the working team (34 teams) in charge of these construction works. Portable computer equipment (HHC) 18 (car navigation system) capable of transmitting and receiving data to and from the center computer 20 before leaving for the first construction site (No. 17) from the departure place such as a garage on the day of ordering 11 may be provided with the function). Also, based on the created work process list, a list of telephones, telephone lines, tools, etc. necessary for the work of the day is created by the day before the order, and this necessary part data is also sent to the HHC 18 of the work team, The work group starts by loading necessary parts and the like with reference to the necessary part data displayed on the display, and sequentially performs the planned work with reference to the construction data displayed on the display.
[0070]
  When this work group arrives at the first construction site, the actual construction start time is transmitted to the center computer 20 by a predetermined button operation in the HHC 18. For example, current data detected by the work team vehicle 10 from the GPS sensor 12 is transmitted to the center computer 20 at intervals of 1 minute, for example, and data indicating vehicle status such as engine ON / OFF can also be transmitted. Therefore, when the current location data of the vehicle 10 of the work group is within a predetermined range that can be regarded as having reached the first construction site, and the engine of the vehicle 10 is turned off, the work group waited for a communication. Instead, the center computer 20 may determine that the construction has started and regard that time as the construction start time. In the “plan” column of the work process list in FIG. 7, the scheduled construction start time determined by the above-described processing is displayed, and the same time is initially displayed in the “start” column. When the actual construction start time is received, the time is written in the “start” column. If the actual construction start time written in the “Start” column is different from the planned construction start time in the “Plan” column, it is automatically corrected by the plus or minus amount and the planned construction end time in the “End” column is rewritten. It is done.
[0071]
  When each work is completed, the work team reports the work contents to the center using the mobile phone 19 at the construction site, and receives a hearing survey by the operator of the terminal connected to the center computer 20. In this listening work, the operator who has received the construction completion notification from the work team displays the initial screen 231 shown in FIG. 23 and then asks for the telephone number or order number for the completed construction while viewing this. Started by. When either the telephone number or the order number is entered in the number input fields 233 and 234, the order to be processed for the listening survey is specified, and the summary is displayed in the “listening order” field 232.
[0072]
  Thereafter, each time the “next” 235 sequentially displayed on the display is clicked, the CPU 21 reads out the question items from the question item database 229 and displays them on the display 23. The operator reads the question item displayed on the screen as it is, conveys it to the work team, and inputs the answer from the work team. Each question item can be easily answered by alternative answering from yes / no or multiple choices or by numerical input. In the case of alternative answers, the choices that can be answered are displayed on the display screen in a pull-down or menu format, and the operator can select and identify them according to the answers from the work team. .
[0073]
  All the conditions necessary to calculate the fee for the completed construction are obtained by the listening survey conducted in this way. Questions for this include identification of the type of construction, identification of the number of construction points when there is construction with multiple addresses and pillars in the single order (transfer of telephone lines), and the telephone number for the order Confirmation of whether other telephone numbers have been constructed, confirmation of phone book distribution, confirmation of the presence of new service lines, earth lines, protectors, indoor lines, etc. And confirmation of materials and parts used. When the operator clicks “Next” after obtaining all the conditions for calculating the charge for the completed construction by obtaining answers to these series of question items from the work team, the CPU 21 satisfies these conditions. Based on this, the construction fee is calculated by the calculation program 228 and displayed on the display.
[0074]
  The display screen at this time is shown in FIG. On this fee display screen 236, the calculated construction fee is displayed in the construction fee confirmation column 237 including the breakdown, and the work group is requested to confirm whether or not the construction fee is notified, and the work group calculates it by itself. To check against the price charged. If it is different from the charge calculated by the work group, click “Recalculate” 238 to recalculate. When the operator clicks “Register” 239 after confirming the construction fee by the charge verification, the CPU 21 stores the details of the construction content including the construction fee obtained by the listening survey in the completed construction database 227 of the memory 22, A breakdown of a predetermined construction fee created based on this is transmitted to the HHC 18 of the working group. The HHC 18 that has received the breakdown of the construction fee is launched by a printer that incorporates the breakdown and delivered to the user.
[0075]
  The interview is completed as described above, so the working group disconnects from the center and heads to the next construction site. When the “registration” 239 is clicked on the charge display screen 236 (FIG. 24), the center computer 20 receiving the signal considers that the work of the construction project has actually ended, and automatically displays this. 7 can be written in the “End” column of the work process list. The same processing may be performed when a work completion notification is received from the operator. Alternatively, when the current position data of the vehicle 10 of the work team is within a predetermined range from the initial construction site and vehicle information indicating that the engine of the vehicle 10 has been restarted is acquired, the center computer 20 determines that the construction has been completed. The time may be regarded as the construction end time and written in the “End” column of the work process list in FIG. As a result, when a time different from the scheduled construction start time is written in the “End” column of the work process list in FIG. 7, the “Start” column of the construction project scheduled thereafter is added according to the plus or minus. Rewrite the scheduled construction start time and the scheduled construction completion time in the “End” column.
【The invention's effect】
[0076]
  As explained above, according to the present invention,It is possible to efficiently and accurately perform the work completion process on the day when telephone work or the like is performed by a plurality of work groups. In addition, immediately after the completion of each work, it is possible to conduct a survey from the work team to grasp the contents of the work in real time, and to accurately calculate the fee according to the work.
[Brief description of the drawings]
[0077]
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 of work to be performed in a specific work area (Yokosuka area, Kanagawa Prefecture) is read from the order file storage unit and displayed on a specific work day.
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 team created 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 list of work processes of other work teams created through the same process in the same case.
FIG. 9 is a diagram showing a display of a list of work processes of other work teams created through the same process in the same case.
FIG. 10 is a diagram showing a display of a first proposal for work sorting created as a set of work process lists for each team in FIGS. 7 to 9;
FIG. 11 is a diagram showing a second work sorting proposal on a display.
FIG. 12 is a diagram showing a third work sorting proposal on a display.
FIG. 13 is a diagram showing, on a display, a scheduled work end time of a work team that finishes the latest work in each work sorting plan shown in FIGS.
FIG. 14 is a flowchart showing a processing step of selecting a construction project (first project in the morning) to be assigned to each work team first on the day as a specific process for executing step S3 in the flowchart of FIG. 5; .
FIG. 15 is a flowchart showing a processing step for selecting a construction project (second project after the morning) to be assigned next for each work group after the processing steps shown in the flowchart of FIG. 14;
FIG. 16 is a diagram showing, on a display, a scheduled work end time of a work team that finishes the latest work in each work sorting plan created in a more practical application example.
FIG. 17 is a diagram showing a display of a work sorting plan with the earliest scheduled work end time in FIG.
FIG. 18 is a diagram showing a display of the construction details of the construction project in which work delay occurs in FIG.
FIG. 19 is a diagram showing a work transfer selection screen displaying a processing result when the work item shown in FIG. 18 is transferred to another work group;
20 is a diagram showing a display of a work sorting plan after work transfer when one case that does not cause work delay 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 a similar work transfer process is repeatedly performed.
FIG. 22 is a diagram showing a display of the construction details of a construction project in which work delay occurs in the table of FIG.
FIG. 23 is a diagram showing an initial screen displayed on the display of the center computer when conducting a listening survey.
FIG. 24 is a diagram showing a construction fee display screen displayed on the display of the center computer at the end of the listening survey.
[Explanation of symbols]
[0078]
10 Work team vehicles
11 Car navigation system
12 GPS sensor
13 CPU
14 display
15 Printer
16 GPS antenna
17 Antenna
18 Portable computer equipment (HHC)
19 Mobile phone
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
  226 Work sorting database
  227 Completed construction database
  228 calculation program
  229 Questionnaire database
23 display
24 Printer
25 Antenna
26 Input means

Claims (1)

A center computer having an arithmetic processing unit, a display, input means, a memory, a work group portable computer having a printer, and data transmitting / receiving means for enabling data transmission / reception between the center computer and the work group portable computer. Configured with
The memory of the center computer stores a predetermined program for calculating a charge according to the work content and a series of questions that can specify conditions necessary for calculating the charge by the program by alternative answer or quantity entry. Item database and completed work database that stores work contents including work charges for completed work,
The arithmetic processing part of the center computer
(A) processing for reading the series of questions from the question database and sequentially displaying them on the display;
(B) Based on an alternative answer or quantity entry for the question items input via the input means, a process of reading the program, calculating a work fee for the work, and displaying it on a display;
(C) a process of storing the work fee calculated in (b) in the completed work database;
(D) A process of creating a work fee breakdown based on the work fee calculated in (b) and transmitting this to the work team portable computer via the data transmitting / receiving means;
An operation completion processing system based on a listening survey, characterized in that

Images