Disclosure of Invention
In order to solve the defects in the prior art, the invention aims to provide a power customer service work order processing method and system based on grid system monitoring.
The invention adopts the following technical scheme.
The electric power customer service work order processing method based on grid system monitoring comprises the following steps:
step 1, carrying out grid division on a power supply service area and acquiring information of each grid;
step 2, distributing business work order processing personnel to each grid according to the number of users in each grid;
step 3, obtaining information of business work order processing personnel and service request information in each grid;
step 4, collecting service request information in each grid in a set monitoring time interval so as to monitor the state of each grid; acquiring the grid information in an abnormal state, and entering step 5; acquiring grid information in a normal state, and entering step 6;
step 5, taking the service request with the highest frequency in the abnormal grid as the abnormal point, and scheduling the peripheral grid of the abnormal point to provide service; adding the abnormal grid number to the information of the business work order processing personnel providing service for the abnormal grid;
step 6, screening business work order processing personnel from the power supply service area, and distributing work orders to the screened business work order processing personnel according to the service request information;
and 7, finishing the work order by the service work order processing personnel and generating work order processing details.
Preferably, step 1 comprises:
step 1.1, numbering each power supply station in a power supply service area, and collecting position coordinates of each power supply station;
step 1.2, collecting user information in a power supply service area, and determining a power supply station to which a user belongs according to the user information;
step 1.3, taking each power supply station as a grid center, taking all users belonging to the power supply station as a grid range, and carrying out grid division;
step 1.4, constructing grid information including grid numbers and grid center coordinates; the grid number is the number of each power supply station, and the grid center coordinate is the position coordinate of each power supply station;
step 1.5, adding the information of the grid to which the user belongs to the user information;
step 1.6, when the power supply in the power supply service area is changed, repeating the steps 1.1 to 1.3, and changing the grid division;
and 1.7, repeating the steps 1.2 to 1.5 when the users in the power supply service area are changed, and changing the grid division.
Further, in step 1.2, the user information includes: the number of a house, the name of a house, the power supply station, the address, the power consumption type, the contract capacity and the operation capacity.
Preferably, in step 2, the business work order processing personnel comprise customer service personnel and operating personnel; wherein, the operation personnel divide according to the business category, include: business expansion work order operating personnel, electric charge work order operating personnel, metering work order operating personnel, inspection work order operating personnel and customer service work order operating personnel.
The step 2 comprises the following steps:
step 2.1, according to
Number of users within a grid
Total number of users in power supply service area
To the ratio of
Distribution of customer service personnel within a grid
Satisfies the following relation:
in the formula, the total number of the customer service staff in the P electric service area,
,
the total number of grids in the power supply service area;
step 2.2, according to
Number of users within a grid
In proportion to the total number M of users in the power supply service area
Within a grid
Number of kinds of business workers
Satisfies the following relation:
in the formula (I), the compound is shown in the specification,
to the first in the power supply service area
The total number of the business workers;
,
the total number of service types in the power supply service area;
,
the total number of grids in the power supply service area;
step 2.3, based on the improved K-means clustering method to the second
Within a grid
Number of kinds of business workers
Making an adjustment to obtain
Within a grid
Number of kinds of business workers
。
Further, step 2.3 comprises:
step 2.3.1, the total number N of grids in the power supply service area is the number of categories;
step 2.3.2, obtaining the power supply service area
First name
Address coordinates of a kind of business operator
(ii) a Wherein the subscript k represents the number
The kth operator of the kind of service,
;
step 2.3.3, with
Taking the center of each grid as an initial centroid;
step 2.3.4, calculate each address coordinate to
Distance of initial centroid
(ii) a According to the distance
Ordering the initial centroids in a small-to-large order;
step 2.3.5, from either centroid
Initially, the centroid to which each address coordinate belongs is determined, i.e., the centroid is
Corresponding to the first in the grid
Clustering number of operators of different service types
With the center of mass
Corresponding to the first in the grid
Number of operators assigned to different types of services
And (3) comparison: when the number of clusters is
Less than or equal to the number of allocations
If so, all the operators corresponding to the address coordinates are distributed to the grids corresponding to the centroid; when the number of clusters is
Greater than the number of dispenses
Then jump to the next centroid
And repeating step 2.3.5; wherein the next centroid
Ordered in the centroid
Then;
2.3.6, when power supply service area
First name
The kind of service operator has been assigned to
After each trellis, recalculating to obtain
A new centroid;
step 2.3.7, when
The distance between the new centroid and the original centroid is smaller than a preset threshold value, or the new centroid and the original centroid are redistributed to be in the first grid
Judging that the clustering reaches an ending condition if the number of the service operators does not change any more; otherwise, steps 2.3.4 to 2.3.7 are repeated.
Preferably, in step 3, the customer service staff information includes: the number, service field and state of the belonging grid; the worker information includes: the number, service field, position, estimated time consumption and state of the grid;
wherein the state comprises idle and non-idle;
the service request information includes: user address, number of the grid, application time and service type.
Preferably, step 4 comprises:
step 4.1, calculate
Average of historical data of service requests within a grid
And standard deviation of
;
Step 4.2, collecting the first time in a set monitoring time interval
Number of service requests in individual grid
And calculate
(ii) a When in use
When it is, it is determined to be
If the grid has abnormal state, repeating step 4.2 after shortening the monitoring time interval, and if the grid still judges that the grid has abnormal state
If the grid has an abnormal state, entering step 5;
when in use
When it is, it is determined to be
The individual grids are in the normal state and proceed to step 6.
Further, in step 4.2, the set monitoring time interval is taken to be 30 minutes, th
When each grid has an abnormal state, shortening the monitoring time interval to 10 minutes; the service request comprises a work order request.
Preferably, step 5 comprises:
step 5.1, acquiring grid numbers in an abnormal state and address information in a work order using request in an abnormal grid;
step 5.2, performing word segmentation and word frequency statistics on the address information, and extracting the address information with the highest occurrence frequency as an abnormal point coordinate;
and 5.3, taking the coordinate of the abnormal point as the center of a circle, taking the coordinate from the abnormal point to the center coordinate of the abnormal grid as an initial radius value, taking one half of the radius value as a step length, and continuously expanding the service area of the abnormal point until the number of grids in the service area of the abnormal point reaches
(ii) a Wherein the number of grids in the abnormal point service area
Satisfies the following relation:
in the formula (I), the compound is shown in the specification,
is the average of the historical data requested by the inspection order within the anomaly grid,
requesting times for the work order for use in the abnormal grid;
and 5.4, changing the grid information in the abnormal point service area, namely adding the abnormal grid number into the grid numbers of the customer service personnel information and the operator information which provide services for the abnormal grid respectively.
Preferably, step 6 comprises:
step 6.1, arranging each work order according to the application time sequence of the service request;
step 6.2, determining the distribution mode of each work order according to the service type of the service request, comprising the following steps: distributing the customer service work order to customer service personnel; the business expansion work order is distributed to the operating personnel; distributing the electric charge work order to the operator; the measurement work order is distributed to the operating personnel;
step 6.3, screening service work order processing personnel with abnormal grid numbers in the information from the power supply service area as processing personnel of each work order;
step 6.4, the work order assignment is carried out on the personnel screened in the step 6.3 according to the distribution mode determined in the step 6.2, and the work order assignment method comprises the following steps:
when the state in the screened customer service staff information is idle, the customer service work order is distributed to the customer service staff in the idle state; otherwise, sending the customer service work order into a waiting area, and performing work order assignment after waiting for the customer service staff in an idle state;
when the state in the screened first operator information is idle, according to the first operator informationThe distance between the operator address and the service request address, and the time of the first operator arriving at the service request address
(ii) a At the same time, a second operator closest to the service request address is searched from all the operators, and the time of the second operator reaching the service request address is calculated
And obtaining the predicted time consumption of the second operator
If, if
If not, assigning the work order to a second operator; the estimated time consumption is an estimated value of time for completing the task, which is fed back in the system according to the task condition after the order of the operating personnel is received;
and when the state in the screened first operator information is not idle, sending the customer service work order into a waiting area, and performing the work order assignment flow after waiting for the operator in the idle state.
Preferably, step 7 comprises:
step 7.1, the customer service staff modifies the state in the staff information according to the condition of the assigned work order; the operator modifies the state, address and predicted time consumption in the personnel information according to the condition of the assigned work order;
and 7.2, supplementing cost information in the work order after the work order is processed, and generating work order processing details.
Electric power customer service work order processing system based on meshing system monitoring includes: the system comprises a gridding monitoring module, a service personnel information module and a service work order processing module;
the grid monitoring module is used for carrying out grid division on a power supply service area and acquiring information of each grid and service request information in each grid; monitoring the state of each grid according to service request information in each grid within a set monitoring time interval;
the service staff information module is used for distributing service work order processing staff to each grid according to the number of users in each grid and storing the information of the service work order processing staff in each grid;
the service work order processing module is used for determining a service request with the highest frequency in an abnormal grid as an abnormal point according to the abnormal grid information sent by the gridding monitoring module, scheduling peripheral grids of the abnormal point to provide service, and sending the scheduled grid information to the service staff information module; and the system is also used for screening business work order processing personnel from the power supply service area, distributing work orders to the screened business work order processing personnel according to the service request information, finishing the work orders by the business work order processing personnel and generating work order processing details.
Compared with the prior art, the invention has the beneficial effects that:
1. the information of the client, the customer service staff and the operating staff is managed in a gridding manner, so that the integration from the customer service staff to the operating staff is provided for the client, the service is omnibearing, the service staff which is most suitable for the customer service requirement is matched, and the high-quality service is effectively provided in time;
2. whether an emergency happens can be found out in time by monitoring the work order state of the customer service center, and business personnel around the place where the emergency happens can be dispatched quickly to provide assistance by virtue of grid management;
3. by adding cost statistics in the work order state, the time cost and the consumable cost of each service can be conveniently recorded, and the final accounting of the property cost flow is facilitated.
Detailed Description
The present application is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present application is not limited thereby.
As shown in fig. 1, the method for processing the power customer service work order based on grid system monitoring includes:
step 1, carrying out grid division on a power supply service area, and acquiring information of each grid.
In consideration of the accuracy of power supply users managed by the power supply station, the power supply station to which each user belongs can be clearly known, distribution management is facilitated, and distribution of service personnel and operation personnel is performed by taking users served by the power supply station as a reference, so that the average service quality is guaranteed.
Specifically, step 1 comprises:
step 1.1, numbering each power supply station in a power supply service area, and collecting position coordinates of each power supply station;
in the preferred embodiment of the invention, the position coordinates of each power supply station in the power supply service area are obtained on the GIS map, the power supply stations are classified into cities, districts and counties, and in order to ensure the consistency of the grid classification levels, the county-level power supply station is selected as a classification center.
Step 1.2, collecting user information in a power supply service area, and determining a power supply station to which a user belongs according to the user information;
in the preferred embodiment of the invention, the information of all users served by a certain power supply station is acquired on a GIS map; user information includes, but is not limited to: the number of a house, the name of a house, the power supply station, the address, the power consumption type, the contract capacity and the operation capacity.
Step 1.3, taking each power supply station as a grid center, taking all users belonging to the power supply station as a grid range, and carrying out grid division;
in the preferred embodiment of the present invention, all county power supply stations are trellis coded, starting from 1 to
Wherein
Is the number of county-level power supply stations; through the grid division, the addresses in all the user information belonging to the same power supply station are connected into subareas, namely the service radiation range of the grid where the power supply station is located.
Step 1.4, constructing grid information including grid numbers and grid center coordinates; the grid number is the number of each power supply station, and the grid center coordinate is the position coordinate of each power supply station;
step 1.5, adding the information of the grid to which the user belongs to the user information;
step 1.6, when the power supply in the power supply service area is changed, repeating the steps 1.1 to 1.3, and changing the grid division;
the grid division result is also linked to the marketing business system, and when the power supply changes, including addition and deletion, the corresponding grid is purposefully added and deleted in the marketing business system.
And 1.7, repeating the steps 1.2 to 1.5 when the users in the power supply service area are changed, and changing the grid division.
And 2, distributing business work order processing personnel to each grid according to the number of users in each grid.
Specifically, in step 2, the business work order processing personnel comprise customer service personnel and operating personnel; wherein, the operation personnel divide according to the business category, include: business expansion work order operating personnel, electric charge work order operating personnel, metering work order operating personnel, inspection work order operating personnel and customer service work order operating personnel.
By counting the number of clients in each grid, client service personnel and operating personnel of each service are reasonably distributed to each grid according to the set proportion, uniform distribution of each grid is achieved, and the ratio of service work order processing personnel to clients is kept consistent.
The step 2 comprises the following steps:
step 2.1, according to
Number of users within a grid
The proportion of the total number M of users in the power supply service area to the second
Distribution of customer service personnel within a grid
Satisfies the following relation:
in the formula (I), the compound is shown in the specification,
the total number of customer service personnel in the power supply service area,
,
the total number of grids in the power supply service area;
since the customer service personnel are on-line service and are not limited by addresses, the equal proportion distribution can be carried out according to the principle.
Step 2.2, according to
Number of users within a grid
Total number of users in power supply service area
To the ratio of
Within a grid
Number of kinds of business workers
Satisfies the following relation:
in the formula (I), the compound is shown in the specification,
to the first in the power supply service area
The total number of the business workers;
,
the total number of service types in the power supply service area;
,
the total number of grids in the power supply service area;
step 2.3, based on the improved K-means clustering method to the second
Within a grid
Number of kinds of business workers
Making an adjustment to obtain
Within a grid
Number of kinds of business workers
. Because the operator involves offline operations, the distribution method differs from that of the customer service staff.
Further, the number of operators of various services in the power supply service area is counted, taking repair operators as an example, the allocation method of operators of other types of services is consistent with the allocation method of repair operators, except for guaranteeing resource balance, the grid to which the operators belong needs to be allocated in consideration of the principle of near work, so that a K-means clustering method is adopted to divide the operation into
And (4) class. However, the direct use of the K-means model can only ensure the nearby distribution and cannot ensure the resource balance, i.e. the number of people distributed by each grid is planned in advance, so that an improved K-means clustering method is adopted.
Further, step 2.3 comprises:
step 2.3.1, Total amount of grids in Power supply service area
As the number of categories;
step 2.3.2, obtaining the power supply service area
Address coordinate of business repair worker
(ii) a Wherein the subscript
The first operator who represents the repair work,
;
step 2.3.3, with
Taking the center of each grid as an initial centroid;
the step is distinguished from the traditional K-means clustering method, wherein the traditional K-means algorithm is random selection
The point is taken as the initial centroid, but in doing so, the set of centroids cannot be made to correspond to the grid that was previously assigned, and therefore, in the preferred embodiment of the present invention, the point is taken as the initial centroid
The center of each mesh serves as the initial centroid.
Step 2.3.4, calculate each address coordinate to
Distance of initial centroid
(ii) a According to the distance
Ordering the initial centroids in a small-to-large order;
in the preferred embodiment of the invention, the Euclidean distance is selected to calculate the coordinate of each address to
Distance of initial centroid
The following relational expression is satisfied:
in the formula (I), the compound is shown in the specification,
is as follows
Coordinates of the initial centroid;
step 2.3.5, from either centroid
Initially, the centroid to which each address coordinate belongs is determined, i.e., the centroid is
Corresponding to the first in the grid
Clustering number of operators of different service types
With the center of mass
Corresponding to the first in the grid
Number of operators assigned to different types of services
And (3) comparison: when the number of clusters is
Less than or equal to the number of allocations
If so, all the operators corresponding to the address coordinates are distributed to the grids corresponding to the centroid; when the number of clusters is
Greater than the number of dispenses
Then jump to the next centroid
And repeating step 2.3.5; wherein the next centroid
Ordered in the centroid
Then;
step 2.3.5 is different from the traditional K-means algorithm, in the traditional K-means algorithm, the set to which the centroid belongs is divided by directly judging the centroid to which each data point is closest, and the final set, namely the grid, is probably caused by the fact that the number of people distributed exceeds or is not enough to balance the number of people, so that the step is improved.
2.3.6, when power supply service area
The business repair workers are all assigned to
After each trellis, recalculating to obtain
A new centroid;
step 2.3.7, when
If the distance between the new centroid and the original centroid is smaller than a preset threshold value or the number of repair workers in each grid is not changed after redistribution, judging that the clustering reaches an end condition; otherwise, steps 2.3.4 to 2.3.7 are repeated.
And 3, acquiring the information of the business work order processing personnel and the service request information in each grid.
Specifically, in step 3, the customer service staff information includes: the number, service field and state of the belonging grid; the worker information includes: the number, service field, position, estimated time consumption and state of the grid;
wherein the state comprises idle and non-idle;
the service request information includes: user address, number of the grid, application time and service type.
Step 4, collecting service request information in each grid in a set monitoring time interval so as to monitor the state of each grid; acquiring the grid information in an abnormal state, and entering step 5; and acquiring the grid information in a normal state and entering the step 6.
Specifically, step 4 includes:
step 4.1, calculate
Average of historical data of service requests within a grid
And standard deviation of
;
Step 4.2, collecting the first time in a set monitoring time interval
Number of service requests in individual grid
And calculate
(ii) a When in use
When it is, it is determined to be
If the grid has abnormal state, repeating step 4.2 after shortening the monitoring time interval, and if the grid still judges that the grid has abnormal state
If the grid has an abnormal state, entering step 5;
when in use
When it is, it is determined to be
The individual grids are in the normal state and proceed to step 6.
Further, in step 4.2, the set monitoring time interval is taken to be 30 minutes, th
When each grid has an abnormal state, shortening the monitoring time interval to 10 minutes;
service requests include, but are not limited to, requests for a checklist; when an emergency accident occurs, the number of requests for repair services increases, so that the condition of the work order for monitoring is emphasized.
User service requirements are generally associated with equipment failure, and the failure condition of the equipment can be treated approximately as a random number. It is in accordance with
Criterion, assuming a group of detected data meets random rule, when one data exceeds
The value is generally considered to be an abnormal value.
The principle is as follows:
the value is distributed in
The probability of (1) is 0.6872;
the value is distributed in
The probability of (1) is 0.9545;
the value is distributed in
The probability of (1) is 0.9973.
Step 5, taking the service request with the highest frequency in the abnormal grid as an abnormal point, and scheduling the peripheral grid of the abnormal point to provide service; and adding the abnormal grid number into the information of the business work order processing personnel providing services for the abnormal grid.
Specifically, step 5 comprises:
step 5.1, acquiring grid numbers in an abnormal state and address information in a work order using request in the abnormal grid;
step 5.2, performing word segmentation and word frequency statistics on the address information, and extracting the address information with the highest occurrence frequency as an abnormal point coordinate;
step 5.3, taking the coordinate of the abnormal point as the center of a circle, taking the coordinate from the abnormal point to the center of the abnormal grid as an initial radius value, and taking one half of the initial radius valueThe radius value is a step length, and the abnormal point service area is continuously expanded until the number of grids in the abnormal point service area reaches
(ii) a Wherein the number of grids in the abnormal point service area
Satisfies the following relation:
in the formula (I), the compound is shown in the specification,
is the average of the historical data requested by the inspection order within the anomaly grid,
requesting times for the work order for use in the abnormal grid;
and 5.4, changing the grid information in the abnormal point service area, namely adding the abnormal grid number into the grid numbers of the customer service personnel information and the operator information which provide services for the abnormal grid respectively.
And 6, screening the service work order processing personnel from the power supply service area, and distributing the work order to the screened service work order processing personnel according to the service request information.
Specifically, step 6 includes:
step 6.1, arranging each work order according to the application time sequence of the service request;
step 6.2, determining the distribution mode of each work order according to the service type of the service request, comprising the following steps: distributing the customer service work order to customer service personnel; the business expansion work order is distributed to the operating personnel; distributing the electric charge work order to the operator; the measurement work order is distributed to the operating personnel;
step 6.3, screening service work order processing personnel with abnormal grid numbers in the information from the power supply service area as processing personnel of each work order;
step 6.4, the work order assignment is carried out on the personnel screened in the step 6.3 according to the distribution mode determined in the step 6.2, and the work order assignment method comprises the following steps:
when the state in the screened customer service staff information is idle, the customer service work order is distributed to the customer service staff in the idle state; otherwise, sending the customer service work order into a waiting area, and performing work order assignment after waiting for the customer service staff in an idle state;
when the state in the screened first operator information is idle, calculating the time of the first operator reaching the service request address according to the distance between the first operator address and the service request address
(ii) a At the same time, a second operator closest to the service request address is searched from all the operators, and the time of the second operator reaching the service request address is calculated
And obtaining the predicted time consumption of the second operator
If, if
If not, assigning the work order to a second operator; the estimated time consumption is an estimated value of time for completing the task, which is fed back in the system according to the task condition after the order of the operating personnel is received;
and when the state in the screened first operator information is not idle, sending the customer service work order into a waiting area, and performing the work order assignment flow after waiting for the operator in the idle state.
And 7, finishing the work order by the service work order processing personnel and generating work order processing details.
Specifically, step 7 includes:
step 7.1, the customer service staff modifies the state in the staff information according to the condition of the assigned work order; the operator modifies the state, address and predicted time consumption in the personnel information according to the condition of the assigned work order;
and 7.2, supplementing cost information in the work order after the work order is processed, and generating work order processing details.
Electric power customer service work order processing system based on meshing system monitoring includes: the system comprises a gridding monitoring module, a service personnel information module and a service work order processing module;
the grid monitoring module is used for carrying out grid division on a power supply service area and acquiring information of each grid and service request information in each grid; monitoring the state of each grid according to service request information in each grid within a set monitoring time interval;
the service staff information module is used for distributing service work order processing staff to each grid according to the number of users in each grid and storing the information of the service work order processing staff in each grid;
the service work order processing module is used for determining a service request with the highest frequency in an abnormal grid as an abnormal point according to the abnormal grid information sent by the gridding monitoring module, scheduling peripheral grids of the abnormal point to provide service, and sending the scheduled grid information to the service staff information module; and the system is also used for screening business work order processing personnel from the power supply service area, distributing work orders to the screened business work order processing personnel according to the service request information, finishing the work orders by the business work order processing personnel and generating work order processing details.
The work flow of the power customer business work order processing system based on grid system monitoring is shown in fig. 2.
Compared with the prior art, the invention has the beneficial effects that:
1. the information of the client, the customer service staff and the operating staff is managed in a gridding manner, so that the integration from the customer service staff to the operating staff is provided for the client, the service is omnibearing, the service staff which is most suitable for the customer service requirement is matched, and the high-quality service is effectively provided in time;
2. whether an emergency happens can be found out in time by monitoring the work order state of the customer service center, and business personnel around the place where the emergency happens can be dispatched quickly to provide assistance by virtue of grid management;
3. by adding cost statistics in the work order state, the time cost and the consumable cost of each service can be conveniently recorded, and the final accounting of the property cost flow is facilitated.
The present applicant has described and illustrated embodiments of the present invention in detail with reference to the accompanying drawings, but it should be understood by those skilled in the art that the above embodiments are merely preferred embodiments of the present invention, and the detailed description is only for the purpose of helping the reader to better understand the spirit of the present invention, and not for limiting the scope of the present invention, and on the contrary, any improvement or modification made based on the spirit of the present invention should fall within the scope of the present invention.