CN101201924A - Method for estimating client level set-meal incomings and correlate system - Google Patents

Method for estimating client level set-meal incomings and correlate system Download PDF

Info

Publication number
CN101201924A
CN101201924A CNA2006101659685A CN200610165968A CN101201924A CN 101201924 A CN101201924 A CN 101201924A CN A2006101659685 A CNA2006101659685 A CN A2006101659685A CN 200610165968 A CN200610165968 A CN 200610165968A CN 101201924 A CN101201924 A CN 101201924A
Authority
CN
China
Prior art keywords
set meal
income
client
scheme
grade
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CNA2006101659685A
Other languages
Chinese (zh)
Inventor
徐秋慧
高璐
张舒博
季婷
解建辉
朱莹
陈峻锐
邓慧学
段学辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Telecom Corp Ltd
Original Assignee
China Telecom Corp Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Telecom Corp Ltd filed Critical China Telecom Corp Ltd
Priority to CNA2006101659685A priority Critical patent/CN101201924A/en
Publication of CN101201924A publication Critical patent/CN101201924A/en
Pending legal-status Critical Current

Links

Images

Abstract

The invention relates to a package income evaluation system and a corresponding method. The system carries out income evaluation based on a package selection model of a customer, which comprises an initial data import module that is used for providing interfaces with various data formats to import original data of relevant customers to the package income evaluation system, a design module for a package proposal that is used for designing, modifying package design documents, customizing a package language and a package template, wherein, the package proposal comprises arbitrary number of package grades and a package instruction, and a package reckoning module that is used based on the designed package proposal and reckons the expected value of income change for every customer through reckoning probability of choosing every package grade for every customer and adding income change of every package grade for every customer, adds probability of choosing every package grade for all customers and adds income change of every package grade for all customers as well to obtain the acceptance rate of very package proposal and income change status. The invention provides accurate package income estimation which is based on the level of customers and a package design platform which can facilitate management.

Description

Levels of clients set meal income appraisal procedure and related system
Technical field
The present invention relates to areas of information technology, particularly two kinds of general levels of clients set meal income appraisal procedure and related systems based on telecommunication service.
Background technology
The China's telecom industry market competition is growing more intense, various set meals emerge in an endless stream, but business decision persons at different levels generally lack set meal income are carried out the Method and kit for that levels of clients is accurately calculated assessment, existing measuring method all is based on customers' granularity, still can not satisfy the requirement of user to the measuring and calculating accuracy.The marketing plan of each branch office and business analyst press for a kind of more efficiently assessment tool, accurately calculate the influence of various set meals to income, avoid risk in advance; For this reason, the personalized measuring and calculating of the set meal masterplate of a series of EXCEL forms occurred, but still needed to improve convenience, dirigibility and the integrated level of its use, systematization, the universalization of set meal income assessment tool are imperative.
Summary of the invention
In order to solve the above-mentioned problems in the prior art, the present invention proposes two kinds of income measuring methods based on client's set meal selection behavior model, set up the universal architecture of set meal design and developed set meal income evaluating system.This system can preview for marketing program, the set meal income is estimated total solution is provided, and selects behavior model by built-in client's set meal, and the granularity with the set meal assessment refine to client's one-level first, has improved science and practicality that income is estimated.
For this reason, the present invention wishes to provide for business decision persons at different levels the method and the corresponding system of two kinds of set meal incomes measuring and calculating, and a kind of assessment tool more general, easy to use is provided.As a kind of decision supporting capability, put into practice the application of its income assessment in the marketing preview.
Another object of the present invention is to be the provide convenience set meal design platform of management of marketing plan personnel and set meal managerial personnel.
According to the present invention, the method for two kinds of measuring and calculating set meal incomes is provided, described method comprises:
The rational degree method of client: independently set the rational degree (number percent) of client according to the designer, determine the probability of the optimum set meal scheme of customer selecting, and then calculate the influence of set meal income.
The client guards Y-factor method Y: calculate the probability of each grade of customer selecting set meal automatically according to client's decision model of innovation, and by flexible configuration coefficient of sensitivity of price and the conservative coefficient of client, adapt to the telecommunication market situation of different regions.
According to the present invention, a kind of set meal income evaluating system that is used for general set meal is taken in assessment is provided, described set meal income evaluating system is taken in assessment based on client's set meal preference pattern, described system comprises: raw data imports module, is used for providing the interface of several data form to import to described set meal income evaluating system with the raw data file with relevant client; Set meal conceptual design module is used for design and revises the set meal design document, customization set meal language, set meal masterplate, and described set meal scheme comprises any a plurality of set meal shelves and a set meal supporting paper; And set meal measuring and calculating module, be used for based on designed set meal scheme, change by the probability of calculating every each grade of customer selecting set meal and the income that adds each grade set meal, and then calculate the expectation value that every client takes in variation; And, obtain the receptance of each grade set meal scheme and take in situation of change all client's set meals selection probability and selection set meal income variation totalling.
According to another aspect of the present invention, a kind of set meal income appraisal procedure of using set meal income evaluating system general set meal to be taken in assessment also is provided, described set meal income appraisal procedure is taken in assessment based on client's set meal preference pattern, described method comprises: raw data imports step, is used for providing the interface of several data form to import to described set meal income appraisal procedure with the raw data file with relevant client; Set meal conceptual design step is used for design and revises the set meal design document, customization set meal language, set meal masterplate, and described set meal scheme comprises any a plurality of set meal shelves and a set meal supporting paper; And set meal measuring and calculating step, be used for based on designed set meal scheme, change by the probability of calculating every each grade of customer selecting set meal and the income that adds each grade set meal, and then calculate the expectation value that every client takes in variation; And, obtain the receptance of each grade set meal scheme and take in situation of change all client's set meals selection probability and selection set meal income variation totalling.
For good client's experience is provided, improve system's result of use simultaneously, the present invention has also carried out following design to each key link of set meal income assessment:
● type of service is set
The user can freely design type of service and subclass, makes this software not be only applicable to general fixed network services, and various telecommunication services all can be calculated by the combination of single business element.
● the standard rate are set
Configure after the type of service, can add, revise and delete the standard rate of each business element, the reason that provides the standard rate to tabulate is the benchmark rate and the disunity of each branch office of telecom operators, and the actual average unit price of carrying out is difference to some extent.
● the set meal explanation
No matter the set meal scheme of the person of being to use oneself configuration design, still load the set meal design document that group company issues, page info about the set meal explanation all is provided, makes set meal mentality of designing, parameter designing, income risk be equilibrated at and realize unification on the same software platform.
● data importing
The data importing of multiple form is provided, and the data ETL (implication of abbreviation: Extract extracts, Transform changes and Load loads) of being convenient to each branch office realizes.
● data analysis
The analysis module of similar famous statistical analysis software is provided, can carries out data field calculating easily, solved the employee of branch office, make whole data analysis become simple the not enough difficult problem of the statistical study acquisition of knowledge.
● data cleansing
The user can freely carry out data processing, cleans mistake and singular data, handles missing values with multiple filter method and logical combination.
● client's stepping is analyzed
The tool model that provides client's stepping to analyze, this all occurs designing and developing with the form of stepping discount at most set meals in the present global telecommunications industry, and the user interface of multiple stepping design and What You See Is What You Get is provided here.
● the set meal conceptual design
The user can freely design and revise the set meal design document, makes telecom operators form the set meal language of oneself, set meal masterplate, improves set meal design and the communication efficient of distributing.
● the set meal measuring and calculating
Two kinds of measuring and calculating algorithms based on the customer selecting behavior model are provided, carry out the income of levels of clients and estimate, and provide the analysis result of income assessment.
Description of drawings
From the description of the following preferred embodiment of the present invention that mode with non-limitative example is provided and from appended drawings, can clear more these and other characteristics of the present invention, advantage and beneficial effect, wherein:
Fig. 1 has schematically shown the entire system Organization Chart according to general set meal income evaluating system of the present invention;
Fig. 2 a-2f has schematically shown the synoptic diagram according to the installation kit content of general set meal income evaluating system according to the present invention, shortcut, startup interface and relevant System menu, help menu and menu bar thereof;
Fig. 3 has schematically shown the synoptic diagram according to " type of service setting " interface of general set meal income evaluating system of the present invention;
Fig. 4 has schematically shown the synoptic diagram according to " setting of standard rate " interface of general set meal income evaluating system of the present invention;
Fig. 5 has schematically shown the synoptic diagram according to " set meal explanation " interface of general set meal income evaluating system of the present invention;
Fig. 6 has schematically shown the synoptic diagram that imports the interface according to " raw data " used in the set meal income assessment in the general set meal income evaluating system of the present invention;
Fig. 7 has schematically shown the synoptic diagram according to " data analysis " interface of general set meal income evaluating system of the present invention;
Fig. 8 has schematically shown the synoptic diagram according to " data profile " interface of " data analysis " result in the general set meal income evaluating system of the present invention;
Fig. 9 has schematically shown the synoptic diagram according to " data cleansing-missing values is handled " interface of general set meal income evaluating system of the present invention;
Figure 10 has schematically shown the synoptic diagram according to " data cleansing-custom condition screening " interface of general set meal income evaluating system of the present invention;
Figure 11 has schematically shown the synoptic diagram according to " data cleansing-screening by formula " interface of general set meal income evaluating system of the present invention;
Figure 12 has schematically shown the synoptic diagram according to " design of client's stepping analysis-stepping " interface of general set meal income evaluating system of the present invention;
Figure 13-a has schematically shown the synoptic diagram according to analysis result " accumulation graph " interface of " client's stepping analysis-stepping result " in the general set meal income evaluating system of the present invention;
Figure 13-b has schematically shown the calculating synoptic diagram according to the analysis result " Geordie value " of " client's stepping analysis-stepping result " in the set meal income assessment in the general set meal income evaluating system of the present invention;
Figure 13-c has schematically shown the synoptic diagram according to analysis result " stepping figure " interface of " client's stepping analysis-stepping result " in the set meal income assessment in the general set meal income evaluating system of the present invention;
Figure 13-d has schematically shown the synoptic diagram according to analysis result " distribution table " interface of " client's stepping analysis-stepping result " in the set meal income assessment in the general set meal income evaluating system of the present invention;
Figure 14-a has schematically shown the synoptic diagram according to " set meal conceptual design " interface of general set meal income evaluating system of the present invention;
Figure 14-b has schematically shown the synoptic diagram according to " the set meal function expense " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-c has schematically shown the synoptic diagram according to " minimum charge and the setting " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-d has schematically shown the synoptic diagram according to " value-added service filling " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-e has schematically shown the synoptic diagram according to " broadband binding " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-f has schematically shown the synoptic diagram according to " monthly rent the is preferential " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-g has schematically shown the synoptic diagram according to " account discount " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 14-h has schematically shown the synoptic diagram according to " set meal explanation " interface in " the set meal conceptual design-set meal scheme " of general set meal income evaluating system of the present invention;
Figure 15 has schematically shown the synoptic diagram according to " set meal measuring and calculating " interface of general set meal income evaluating system of the present invention;
Figure 16 has schematically shown the synoptic diagram according to the set meal results of measuring " analysis of client's acceptance rate " of " the set meal measuring and calculating " of general set meal income evaluating system of the present invention;
Figure 17 has schematically shown the synoptic diagram according to the set meal results of measuring of " the set meal measuring and calculating " of general set meal income evaluating system of the present invention " set meal related service income changes "; And
Figure 18 has schematically shown the process flow diagram according to general set meal income appraisal procedure of the present invention.
Embodiment
Below in conjunction with the drawings; preferred implementation of the present invention is described; should be appreciated that; here the preferred implementation of Miao Shuing not is restrictive explanation; those skilled in the art can be according to principle of the present invention, the present invention is made various modifications, improvement and can not break away from the protection domain that claim limits of enclosing.
Can realize the design of telecom operators' set meal and the support of measuring and calculating based on native system.Group company can be made into set meal file (* .offer) (comprising set meal scheme general description with the set meal scheme by native system, the scheme framework, parameter is provided with points for attention, calculation of measured data extracts explanation) be handed down to branch office of provinces and cities, with the unification that guarantees national set meal scheme and the precision of set meal measuring and calculating.Each province and city branch office also can design, calculate the personalized set meal of this province and this city voluntarily by native system.
Followingly describe the present invention with reference to accompanying drawing.Particularly, the management functions with China Telecom below is that example is elaborated.
1, system introduction
The China's telecom industry market competition is growing more intense, various set meals emerge in an endless stream, but business decision persons at different levels generally lack set meal income are accurately calculated the instrument of assessment, and existing method all is based on customers' granularity, still can not satisfy the requirement of user to the measuring and calculating accuracy.The marketing plan of each province and city branch office, business analyst press for a kind of more efficiently assessment tool, accurately calculate the influence of various set meals to income, avoid risk in advance; Centre of support, China Telecom market for group company provides the personalized measuring and calculating of the set meal masterplate of a series of EXCEL forms, but still needs to improve convenience, dirigibility and the integrated level of its use, and systematization, the universalization of set meal income assessment tool are imperative.
General set meal income evaluating system according to the present invention is an intelligence system of taking in assessment at set meal.This system can dispose the set meal scheme automatically according to user's demand, and takes in profit and loss measuring and calculating, can support the income measuring and calculating of all kinds of set meal forms (single product and product mix) in the set meal system that present telecom operators release comprehensively.The whole process analysis pattern that this system provides data importing, data cleansing, data analysis, the analysis of client's stepping, set meal conceptual design, income to assess.The core technology of this system is the configuration mechanism of set meal scheme and the set meal income assessment algorithm of levels of clients.Native system is a standalone version, and hardware is not had specific demand.
Fig. 1 has schematically shown the entire system Organization Chart according to general set meal income evaluating system of the present invention.This system adopts completely that object oriented language C# writes, and based on OO thought, adopts various Design Modes in a large number.The framework of system is classical three-tier architecture: the data operation layer of bottom, middle operation layer and present to the user representing layer.Each layer only carries out data transfer with adjacent layer, loose coupling between each layer, so system can be reconstructed and expand easily.
2, system installs and is provided with
2.1 system installs and deletion
At first referring to accompanying drawing 2-a.Wherein schematically shown installation kit according to general set meal income evaluating system of the present invention.After user click Setup.exe starts installation procedure, can install easily according to the guide that installation procedure provides, adopt the mode of acquiescence to get final product always.Whether installation procedure has installed the .net framework of Microsoft company in the detection system automatically, if do not install then installation automatically, otherwise omits .net framework installation steps.
After the installation, generate automatically on the table
Figure A20061016596800181
Icon is clicked and can be started general set meal income evaluating system.Accompanying drawing 2-b shows the shortcut according to general set meal income evaluating system of the present invention.
On the other hand, when the user wish deletion should be general set meal when taking in evaluating system, then can as the operation of the deletion software of routine, delete.Particularly, when general set meal income evaluating system is deleted in hope, need enter " beginning "-" control panel "-" adding or delete program " " the general set meal of GRE is taken in evaluating system ".
2.2 menu and toolbar use
Accompanying drawing 2-c shows the startup interface of general set meal income evaluating system.
Accompanying drawing 2-d shows the System menu synoptic diagram according to general set meal income evaluating system of the present invention.As shown in the figure, System menu provides the project of opening, has closed project and stored items function, and the approach that logs off.
In addition, shown in Fig. 2-e, also provide synoptic diagram, be used to provide mail contact method, system information explanation and system's skin to change function according to the help menu of general set meal income evaluating system of the present invention.
In accompanying drawing 2-f, also provide synoptic diagram according to the menu bar of general set meal income evaluating system of the present invention.Menu bar be respectively from left to right open project, preservation project, check current input variable, delete items, about system, user feedback and log off.
2.3 type of service is set
The general set meal income evaluating system of design is preferably used for the various management functions of China Telecom according to the present invention.Fig. 3 has schematically shown the synoptic diagram according to " type of service setting " interface of general set meal income evaluating system of the present invention.
The main business of China Telecom is managed according to it and the rate characteristics are divided into " speech business ", " broadband services ", " value-added service " and " integrated service ".Wherein, speech business comprises the voice subject of " fixed line " and " Personal Handyphone System ", in the district as this locality, interval professional; Long-distance domestic IP, domestic direct dial business; Monthly rent business etc.Broadband services comprises the monthly payment molded breadth band of various speed.Value-added service comprises showing, CRBT, PHS SMS etc.Integrated service is the integration of a plurality of benchmark services, as: fixed line local service (comprising in the fixed line district and the interval business of fixed line), fixed line national trunk traffic (it is long-distance long-distance with the domestic IP of fixed line to comprise the domestic tradition of fixed line) etc.Integrated service does not have the standard rate, can not carry out the set meal rate and set.But can set its minimum charge.
Type of service setting operation method
If the business that the set meal measuring and calculating needs does not appear in the service lists, can add, operation steps is:
1. big class under the business of selecting to need to add;
2. import the title of initiate business;
3. click [preservation] button, finish the interpolation process.
If do not need some business in the service lists, also can delete this business by right button.
2.4 the standard rate are set
Fig. 4 has schematically shown the synoptic diagram according to " setting of standard rate " interface of general set meal income evaluating system of the present invention.It is the basis of set meal measuring and calculating that the standard rate are set.First row of standard rate tabulation are Business Names; Secondary series is the rate value of standard rate; The 3rd row are rate units; The 4th row are relevant informations of remarks.Selected the user interface of " setting of standard rate " as the user after, the user can carry out accordingly operations such as " adding the standard rate ", " revising the standard rate ".
Interpolation standard rate method
Method of operating is:
1. click [interpolation] button on the lower right corner, interface
2. from " rate clauses and subclauses " combobox, select professional;
3. fill in rate unit price, unit and remarks;
4. click [preservation] button and finish interpolation.
Modification standard rate method
Revise certain professional standard rate if desired, method of operating is:
1. mouse-click is chosen the some business in the service lists;
2. in [rate unit price] text box, revise rate.
3. click [modification] button, and [determining] finished.
2.5 prompting
If the user uses the general income evaluating system of set meal for the first time, preferably, configure the class of business and the standard rate of place local network and confirm correct; After configuring, under situation about not changing, carry out the setting of repetition in the time of needn't assessing, therefore, above-mentioned two steps can be omitted at every turn.
3, set meal income evaluation process
3.1 set meal explanation
Set meal explanation is the introduction to set meal, and the explanation of system the is built-in public client's of China Telecom main flow set meal comprises pricing model, highest priority customers, design main points, main attraction, effect and example.Can edit and preserve the explanation of set meal in this module,, then must realize by grabgraf if want to preserve into formatted table.Unformatted textual description can hack and preservation.
Referring to accompanying drawing 5, schematically shown synoptic diagram according to " set meal explanation " interface of general set meal income evaluating system of the present invention.
3.2 step 1: raw data imports
Referring to accompanying drawing 6, schematically shown the synoptic diagram that imports the interface according to " raw data " used in the set meal income assessment in the general set meal income evaluating system of the present invention.The function of " raw data importing " interface module is that the raw data file with relevant client imports in the middle of the native system, and for further carrying out data analysis and processing, and the assessment of ensuing set meal is prepared.
Select File
1. [separator] that adopts in the selection raw data file is as TAB, space or comma.The current file call format is a text.
2. select the position at raw data place, click [opening] button, the raw data file that selection will be opened.
Attention: the raw data file that open here is client's accounting data, does not comprise detailed forms data.
3. click [checking the measuring and calculating variable] button and can check the required customer data of set meal measuring and calculating.
Corresponding field information
For the format conversion with raw data file becomes native system accepted standard form, the field attribute in the raw data file need be transformed into the form of system definition.Operation steps is:
1. from the list box in left side, select the field that to analyze;
2. click [
Figure A20061016596800211
] button, make the field of choosing enter into the list box on right side;
3. after all fields that need analyze being selected into the list box on right side, choose the field in the right-hand column bezel, cluster successively, [business], [classification], [unit] of these fields is provided with;
Annotate: click [coupling automatically], can realize the automatic correspondence of field
4. the field in all right-hand column bezel, clusters is chosen these fields after setting completed, clicks [interpolation] button, makes it to enter into the list box of [net result];
5. if think the field of deletion [net result] lining, can choose respective field, [deletion] button of clicking the right side gets final product.
After all operations is errorless, click [preservation] button, then the raw data through rough handling just can successful importing in the middle of the system.Can carry out next step data analysis work.
3.3 step 2: data analysis
Referring to accompanying drawing 7, schematically shown synoptic diagram according to " data analysis " interface in the general set meal income evaluating system of the present invention.Referring to accompanying drawing 8, schematically shown synoptic diagram according to " data analysis-data profile " interface in the general set meal income evaluating system of the present invention.The function of " data analysis-data profile " module is that raw data is carried out basic statistical study, and the histogram that draws is familiar with intuitively to raw data.
The data description analysis
1. need to select the field of analysis, click [
Figure A20061016596800221
] button, make it to enter in the list box on right side, also can click [
Figure A20061016596800222
] button, with the disposable list box of putting into the right side of whole fields;
2. click [statistics] button, then will list the statistic analysis result of field in [analysis result].
Analysis result
Statistical content comprises:
-data volume: this field record bar number;
-average: the mean value of this field;
-minimum value: the minimum value of this field;
-maximal value: the maximal value of this field;
-standard deviation: the standard deviation of this field;
-intermediate value: the value of maximum number of times appears in this field.
Data profile
1. in the drop-down list of the leftmost side, need to select the variable of analysis, and the lower limit and the upper limit (acquiescence is the minimum value and the maximal value of this variable) of the variable that input need be analyzed in two text boxes of [setting interval range], the quantity of input grouping in the text box of [umber between the setting district] then;
2. click [statistics] button, then can obtain the histogram of DATA DISTRIBUTION.
3.4 step 3: data cleansing
To the data that import, can carry out data cleansing at " missing values " that wherein may occur or " exceptional value " and handle.
Referring to accompanying drawing 9, schematically shown synoptic diagram according to " data cleansing-missing values is handled " interface in the general set meal income evaluating system of the present invention.This module is handled the missing values in the raw data.Operate as follows:
Missing values is handled
1. in the drop-down list on [selecting to set the missing values field] right side, select to need to set the field of missing values;
2. select [setting missing values] or [average replacement].If select [setting missing values] radio box, then in text box thereafter, import the numerical value of setting, if select [average replacement] radio box, then system can be set at missing values the average of available data automatically;
3. click [interpolation] or [deletion] button, can the missing values of setting be added or delete;
4. click [beginning to handle] button, finish the replacement of missing values,, click [recovering former table] if want data file is returned to virgin state before not replacing it.
Exceptional value is handled
Two kinds of exceptional value disposal routes are provided: [self-defined screening conditions] and [screening by formula], respectively referring to accompanying drawing 10,11.
Self-defined screening conditions
Referring to accompanying drawing 10, schematically shown synoptic diagram according to " data cleansing-exceptional value is handled " interface in the general set meal income evaluating system of the present invention.Choose the data that need analysis according to the condition of setting.
1. in first combobox, select the used field of screening;
2. alternative condition in second combobox;
3. input value in the 3rd combobox;
4. a plurality of if desired screening conditions, the then relation between the alternative condition in the 4th combobox;
5. click [adding conditional], condition is added,, choose the condition in the tabulation, click [condition deletion] if think the deletion condition
Click [beginning to handle], then can be according to the screening conditions of setting, the data of screening conditions are satisfied in deletion.
Click [recovering former table], then data set recovery is to there not being screening state before.
Screening by formula
Referring to accompanying drawing 11, schematically shown synoptic diagram according to " data cleansing-exceptional value is handled " interface in the general set meal income evaluating system of the present invention.It is generally acknowledged that customer data is similar to Normal Distribution, is abnormal data in [μ-x* σ, μ+x* σ] extraneous data then.
1. in first combobox, select the used field of screening;
2. input value x in text box is defaulted as 3, and x is big more, and the abnormal data of deletion is few more;
3. click [interpolation], condition is added,, choose the condition in the tabulation, click [deletion] if think the deletion condition.
Click [beginning to handle], then can select the data of analyzing according to condition of choosing or formula.
Click [recovering former table], then data set recovery is to there not being screening state before.
3.5 step 4: client's stepping is analyzed
● client's stepping
When design stepping set meal, often need carry out the stepping analysis to client's expense, duration etc.[client's stepping (stepping)] module can realize this function, and design does not have a direct impact this module to set meal, only plays reference role.
Client's stepping analytical procedure
Referring to accompanying drawing 12, schematically shown synoptic diagram according to " design of the client's stepping analysis-stepping " interface in the general set meal income evaluating system of the present invention.
1. select to carry out the variable that stepping is analyzed, can be single client's field, or the algebraic expression of several fields.Need to select the field of analysis, click [ ] button, make it to enter in the list box on right side and carry out the stepping analysis; Also can click the computed push-buttom of below, the algebraic expression of several fields is set, must link to each other with operational character between the field in the algebraic expression,, click [C] button as need cancel (CANCL) section expression formula.
2. set stepping quantity N (N is the integer more than or equal to 2, for example N can be 2,3,4 ..., 9,10)
3. set the stepping ratio
-to divide equally, each grade ratio is identical.As: if divide 4 grades, then each grade ratio is 25%.
-self-defined, set up each grade ratio on their own.
4. click [generation] button, then will list the result of calculation of variable in [stepping result].
The result shows
● accumulation graph
Show that each grade client counts accounting and variate-value accumulative total accounting, referring to accompanying drawing 13-a.
● the Geordie value
Shown in accompanying drawing 13-b, the absolute equality line reflects that all client's variable-values equate that variate-value accumulative total is than situation under the situation, and real variable value accumulative total line is meant client's variable-value is sorted back client's variate-value accumulative total from low to high than situation.
If the area that absolute equality line and real variable value accumulative total line surround is A, the area that real variable value accumulative total line and transverse axis, the longitudinal axis surround is B, then Geordie value=A/ (A+B).The equality degree of Geordie value reflection variable-value.Value distributes unequal more, and the Geordie value is big more.
● stepping figure
The critical value (maximum, minimum value) and the mean value that show each grade client variable are shown in Figure 13-c.
● distribution table
Form with form shows the detailed results that client's stepping is analyzed, shown in Figure 13-d.Comprise:
-client stepping lower limit
-client stepping the upper limit
-shared number number percent
-accumulative total accounting
-each grade average
3.6 step 5: set meal conceptual design
Referring to accompanying drawing 14-a, schematically shown synoptic diagram according to " set meal conceptual design " interface in the general set meal income evaluating system of the present invention.The principle of set meal design is as follows:
1. customer insight principle.The analysis of connecting inner data and outside enquiry data on the basis that the segmentation client is analysed in depth, is used product quantity and value contribution design, serial set meal is provided according to the client.
2. make up the marketing principle.Pay attention to be worth fill, with the combined set meal design be extended to emphasis, fix a price according to customer value.
3. simple effectively principle.Set meal is simple in structure, and the attraction is outstanding, with deduction and exemption monthly rent, long city with valency etc. as main attraction, initiatively discharge the rate risk.
4. the impression price is moulded with price and is merged principle.Merge design etc. by product mix and rate, blur the price of single product, mould the impression price of impulsive force.
5. set meal separates principle.By set meal design, realize automatically and guide the client area every.Design set meal respectively at middle and high end and low and middle-end family.
6. system equilibrating principle.Embody the established principle of set meal reasonable quantityization, system equilibrating.
7. standard is main, takes into account following principle.Substantially contain present each province main flow set meal pricing model, be convenient to the each province again and suitably extend, also help increasing 3G, broadband application product etc.
A set meal scheme can be made up of any a plurality of set meal shelves and a set meal supporting paper, and system adopts OO thought to define a class saveClass and describes.Class saveClass has a tabulation member object and is used for representing that a plurality of set meal shelves and a text member object are used for representing set meal supporting paper.
Set meal shelves are made up of 6 parts, are respectively that set meal function expense, minimum charge and rate setting, value-added service filling, broadband bundle, monthly rent is preferential, account is preferential.Combination in any by these six parts can be set and files existing set meal scheme and the set meal scheme that may newly release in the future.
Set meal shelves are described with class ATaoCan by system.Such ATaoCan is described by the attribute that 6 types are Units.Wherein Units is the array object of the derivation of a type safety from ArrayList.Therefore 6 ingredients of set meal shelves can be formed with the element of not limitting quantity respectively.
With class Moneys the rate scheme that 6 components constitute is described.For various rate schemes have defined an interface ImoneyItype.Every increase needs only the measuring and calculating of carrying out set meal in the system that is integrated into that realizes that this interface ImoneyItype can be seamless once cover rate scheme.
The push button function at " set meal conceptual design " interface shown in Figure 14-a is as follows:
Increase the set meal shelves
Newly-increased one grade of set meal scheme
Delete all set meal shelves
Delete already present all grades set meal
The set meal explanation
Be used to check the set meal explanation
Preserve
To have the set meal scheme now and save as * .offer file
Load
Import the set meal scheme file of having preserved (* .offer)
Revise
Click enters [scheme setting] interface, and the set meal scheme is made amendment.
Also can directly double-click the parameter value hurdle, parameter value is made amendment.
Deletion
Delete this grade set meal scheme.
Cancel
Cancel modification to this grade set meal scheme.
Annotate: if the set meal scheme is preserved, so completed modification can't be cancelled.
Preserve
The set meal scheme of having revised is preserved.
Attention: to any modification that this grade set meal scheme is carried out, have only to click and preserve, modification could come into force!
● the set meal function is taken
Referring to accompanying drawing 14-b, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-set meal function expense " interface in the general set meal income evaluating system of the present invention.Set meal function expense is meant that the user adds the expense that this grade set meal need additionally be paid, and this expense does not comprise any call rate or other any functional expenses of offset.If set meal comprises the function expense, can click [function expense] check box, set the concrete amount of money then.
● minimum charge and rate are set
Referring to accompanying drawing 14-c, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-minimum charge and the rate are set " interface in the general set meal income evaluating system of the present invention.Minimum charge is meant the amount of every month minimum charge of certain service-user, if customer consumption less than this amount, also will be paid the expense of this amount.
The minimum charge establishing method
Select needs to set the business of minimum charge at the list box in left side, but Dan Xuanyi business, but a plurality of business of also final election (pressing the ctrl key).Blank space is filled in this professional minimum charge amount of money in [minimum charge] below.Click [
Figure A20061016596800281
], the situation that is provided with of minimum charge can appear in the right-hand column bezel, cluster, illustrates that consumption is provided with success recently.Different business can be set nearest consumption jointly, also can set nearest consumption respectively.
The rate establishing method
If need change certain professional rate, then select to need to set the business of rate at the list box in left side, click [rate setting] button or double-click this business to enter the detailed rate setting page.
● value-added service is filled
Referring to accompanying drawing 14-d, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-value-added service is filled " interface in the general set meal income evaluating system of the present invention.Value-added service mainly is meant the value-added service of monthly chargeing here, comprises value-added fixed telephone service, Personal Handyphone System value-added service and broad band value-added service.
The value-added service fill method
List box in the left side is selected value-added service, but Dan Xuanyi business, but a plurality of business of also final election (pressing the ctrl key).Click [
Figure A20061016596800291
], the value-added service that the right-hand column bezel, cluster can occur selecting.Select needs to set the value-added service of exclusive monthly fee at the list box on right side, click [rate setting] button or double-click this value-added service to enter the exclusive monthly fee setting page.
● the broadband binding
Referring to accompanying drawing 14-e, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-broadband binding " interface in the general set meal income evaluating system of the present invention.
If set meal is a broadband binding set meal, then need to set [broadband binding] key element.Click [broadband exclusive monthly fee] check box, select broadband monthly payment type (as: 512K monthly payment broadband, 1M monthly payment broadband etc.), input broadband monthly payment value.
The new client response rate in broadband
If this grade broadband binding set meal can attract non-broadband client to add, then need the set meal designer rule of thumb artificially to set the new client response rate in broadband of this grade set meal.Do not enter this factor if do not consider the new client in broadband, then responsiveness is set at 0.
● monthly rent is preferential
Referring to accompanying drawing 14-f, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-monthly rent the is preferential " interface in the general set meal income evaluating system of the present invention.If it is preferential that set meal relates to monthly rent, then need [monthly rent is preferential] set.
The fixed line monthly rent
If it is preferential that set meal relates to the fixed line monthly rent, click [fixed line monthly rent] check box, import new monthly rent setting value.
The Personal Handyphone System monthly rent
If it is preferential that set meal relates to the Personal Handyphone System monthly rent, click [Personal Handyphone System monthly rent] check box, import new monthly rent setting value.
● account discount
Referring to accompanying drawing 14-g, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-account discount " interface in the general set meal income evaluating system of the present invention.If it is preferential that set meal relates to monthly rent, then need [account is preferential] set.The preferential value of account is the ratio of amount paid in expense and fee payable.
Preferential setting
In list box, select related service, but Dan Xuanyi business, but a plurality of business of also final election (pressing the ctrl key).Click [preferential setting] button or double-click this business that can to carry out account preferential.
Deletion is set
In list box, select related service, but Dan Xuanyi business, but a plurality of business of also final election (pressing the ctrl key).Clicking [deletion set] button, can to delete the account of having set preferential.
● the set meal explanation
Referring to accompanying drawing 14-h, schematically shown synoptic diagram according to " set meal conceptual design-set meal scheme-set meal explanation " interface in the general set meal income evaluating system of the present invention.Set meal explanation is the introduction to set meal, comprising the mentality of designing of set meal, determination of main parameters method, reference information or the like.
Set meal description operation method
Load a set meal file as need, the set meal explanation of this set meal will be carried in this page automatically, can see the relevant information of this set meal.Method of operating is: click and [open] icon in the toolbar, choose the supporting paper that will load, click [determining] button and open supporting paper.
Set the explanation of new set meal if desired or revise the explanation document that has set meal, can in this interface, edit.Method of operating is:
1. in the interface, revise content with keyboard and mouse;
2. [preservation] icon of clicking in the toolbar is preserved the content of revising.
3.7 step 6: set meal measuring and calculating
The income influence measuring and calculating of general set meal income evaluating system is the measuring and calculating of client's one-level.Change by the probability of calculating every each grade of customer selecting set meal and the income that adds each grade set meal, and then calculate the expectation value that every client takes in variation.All client's set meals are selected probability and select the set meal income to change to add up receptance and the income situation of change that promptly obtains each grade set meal scheme.
System provides two kinds of measuring methods, selects wherein a kind of measuring method, and native system can calculate the probability of every each grade of customer selecting set meal automatically based on client's communicating data of importing before.
According to the rational degree measuring and calculating of client
Referring to accompanying drawing 15, schematically shown synoptic diagram according to " set meal measuring and calculating " interface in the general set meal income evaluating system of the present invention.
Understand the set meal scheme (contain do not select set meal) of sorting charge under the resonable implementations of computing method hypothesis client according to the rational degree of client with minimum, and under irrational situation, the probability of a certain shelves of customer selecting set meal scheme is determined according to the expense of selecting this grade set meal scheme to be paid and the size of the gap between the least cost.The concrete operation logic is as follows:
If the client does not select set meal, expense is f 0Unit.Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit.Suppose that customer selecting i shelves scheme expense is minimum, i.e. f m=min (f 0f 1..., f n), then should select m shelves scheme under the resonable implementations of client.And may select other set meal schemes under the irrational situation of client.Suppose that the rational degree of client is P (0≤P≤1), then the probability of each grade of customer selecting set meal is respectively:
P m=P
P i = ( 1 - P ) * 1 f i - f m Σ j = 0 , j ≠ m n 1 f j - f m , I=0 ..., n and i ≠ m
Annotate: P 0Do not select the probability of set meal scheme for the client.
Example: with local stepping monthly package is example, and establishing the former local expense of certain client is 40 yuan, totally 3 grades of local set meals, and under the constant situation of client's duration of call, local expenditure is respectively 36,32 after the customer selecting, 50 yuan.Suppose that the rational degree of client is 80%, then according to the rational degree method of determining and calculating of client, the probability of this customer selecting set meal is respectively:
P 0 = ( 1 - 80 % ) * 1 ( 40 - 32 ) 1 ( 40 - 32 ) + 1 ( 36 - 32 ) + 1 ( 50 - 32 ) = 0.058064516
P 1 = ( 1 - 80 % ) * 1 ( 36 - 32 ) 1 ( 40 - 32 ) + 1 ( 36 - 32 ) + 1 ( 50 - 32 ) = 0 . 116129032
P 2=80%
P 3 = ( 1 - 80 % ) * 1 ( 50 - 32 ) 1 ( 40 - 32 ) + 1 ( 36 - 32 ) + 1 ( 50 - 32 ) = 0.025806452
The conservative Y-factor method Y measuring and calculating of client
The conservative Y-factor method Y of client influence two factors that have of customer selecting by formula simulation client's selection: the one, the client guards coefficient, reflection be the adhere to degree of client to original selection, it is big more that the client guards coefficient, the client tends to adhere to original selection more; The 2nd, coefficient of sensitivity of price, reflection be the influence degree of price for customer selecting, coefficient of sensitivity of price is big more, the client tends to sorting charge more with minimum set meal scheme.
If the client does not select set meal, expense is f 0Unit.Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit.Suppose that the conservative coefficient of set meal is α (α 〉=1), coefficient of sensitivity of price is k (k 〉=1), and then according to automatic method, the probability of each grade of customer selecting set meal scheme is:
P 0 = α * ( 1 f 0 ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k
P i = ( 1 f i ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k , i=1,...n
According to research to the executed set meal scheme of some local network, we think that α gets 8, it is 4 comparatively reasonable that k gets, these two parameters are variable, local network can be according to acceptance level and the sensitivity adjustment α of price and the value of k of domestic customer to the set meal scheme, and it is actual to make it more meet the local network marketing.
Example: with local stepping monthly package is example, and establishing the former local expense of certain client is 40 yuan, totally 3 grades of local set meals, and under the constant situation of client's duration of call, local expenditure is respectively 36,32 after the customer selecting, 50 yuan.Then according to automatic method, the probability of this customer selecting set meal is respectively:
P 0 = 10 * ( 1 40 ) 4 10 * ( 1 40 ) 4 + ( 1 36 ) 4 + ( 1 32 ) 4 + ( 1 50 ) 4 = 0.69564423
P 1 = ( 1 36 ) 4 10 * ( 1 40 ) 4 + ( 1 36 ) 4 + ( 1 32 ) 4 + ( 1 50 ) 4 = 0.106027165
P 2 = ( 1 32 ) 4 10 * ( 1 40 ) 4 + ( 1 36 ) 4 + ( 1 32 ) 4 + ( 1 50 ) 4 = 0.169835017
P 3 = ( 1 50 ) 4 10 * ( 1 40 ) 4 + ( 1 36 ) 4 + ( 1 32 ) 4 + ( 1 50 ) 4 = 0 . 028493588
Illustrate: voice and broadband binding scheme need add the probability that cover voice toll charge is after the meal estimated each grade of customer selecting set meal scheme according to the client.Former broadband client only may select to comprise the binding set meal scheme in corresponding broadband.The broadband client who newly enters may select all binding set meal schemes, but selects the probability of set meal scheme to need to enter probability adjustment according to the new client who sets in advance.
Select the measuring method step
Select the rational degree method of determining and calculating of client, drag scroll bar and change the rational degree probability of client or directly in the square frame of right side, insert the rational degree probability of client.This value is the P value in the rational level calculating method of client, and the rational degree probability of client is big more, and the probability of the set meal scheme that the customer selecting expense is minimum is just big more.
Select automatic method, if use default setting, the α in the then automatic method measure formula gets 8, and k gets 4; Click [Advanced Options], select [self-defined] to reset the value of α and k.
Receptance and the income of clicking [beginning measuring and calculating] calculating set meal scheme change.
Results of measuring
According to two kinds of method of determining and calculating of back, obtain the expense of each grade of customer selecting set meal scheme and select the probability of this grade set meal scheme, and then obtain the receptance and the income rate of change of every grade of set meal scheme, market reaction after estimating set meal and releasing and the influence that may bring income.
If total N client has m shelves set meal scheme, i customer selecting j shelves set meal scheme expense is f Ij(1≤i≤N, 0≤j≤m), i customer selecting j shelves set meal scheme probability is P Ij(1≤i≤N, 0≤j≤m)
Figure A20061016596800341
(j=1,...m)
= Σ i = 1 N P ij * ( f ij - f i 0 ) (j=1,...m)
Figure A20061016596800344
= Σ i = 1 N P ij * ( f ij - f i 0 ) / Σ i = 1 N f i 0 (j=1,...m)
Overall income rate of change=all shelves income rate of change sums
The result shows
Click [set meal receptance], can check the receptance of each grade set meal scheme.As shown in Figure 16.Accompanying drawing 16 has schematically shown the synoptic diagram according to the set meal results of measuring " analysis of client's acceptance rate " of " set meal measuring and calculating " in the general set meal income evaluating system of the present invention.
Click [set meal related service income changes], check overall income changing value, each grade set meal scheme income rate of change and overall income rate of change.As shown in Figure 17.Accompanying drawing 17 has schematically shown the synoptic diagram according to the set meal results of measuring " set meal related service income changes " of " set meal measuring and calculating " in the general set meal income evaluating system of the present invention.
Click [reference], can check each client's detailed data, comprise the set meal selection probability that communicating data and measuring and calculating obtain.
3.8 prompting
The offer document template that the user not only can use group company to provide, further the one's own set meal offer file of design is shared to other branch officies.
Unified offer file is exactly a kind of set meal language, and it can help standard set meal design element and method, raises the management level and work efficiency.
4, the process flow diagram of general set meal income appraisal procedure
Referring to Figure 18, schematically shown process flow diagram according to general set meal income appraisal procedure of the present invention, may further comprise the steps:
1. client's consumption data step S1: the data manipulation person of branch office derives detailed forms data or billing data in the charging billing and accounting system from production system, be stored on the hard disk with certain form.
If the required class of business of this measuring and calculating in the class of business tabulation, then omit by the 2nd step;
If the standard rate are constant, then the 3rd step omitted.
2. set class of business step S3: set the class of business that this measuring and calculating relates to.
3. established standards rate step S5: set this measuring and calculating and relate to professional standard rate, weigh so that the income before and after set meal carried out changes.
The content that this step is provided with can export as the report of rate basic configuration.
4. Data Mining step S7: utilize the statistical method heuristic data.
5. data cleansing step S9: the logic of utilizing the user to set is handled so that calculate better data.
The wash result in this step can export as the calculation of measured data analysis report.
6. stepping analytical procedure (not shown): the existing customer is carried out the stepping analysis, for the set meal stepping provides scientific basis.
7. set meal configuration step S11: the user can make up according to the class of business of setting previously, and data analysis and stepping analysis result in conjunction with do the front design new set meal.
The design result in this step can export as the set meal configuration file, also can load the set meal configuration file.
8. set meal is calculated step S13: the parameter of two kinds of measuring methods is set, carries out the set meal measuring and calculating.
9. set meal appraisal procedure S15: according to the graph results of set meal measuring and calculating output, the person's of being used in combination industry background knowledge is carried out the overall income assessment of set meal.
10. sensibility analysis step S17: adjust the set meal parameter, sensibility analysis is taken in measuring and calculating again.
11. conclusion steps in decision-making S19: according to the satisfied set meal that tuning obtains, the decision-making of carrying on the work.
Can know by above description about general set meal income evaluating system of the present invention and method, all modules that system of the present invention is not limited to complete as described above realize that method of the present invention also is not limited to be realized in steps by institute described above.And should be appreciated that some module/step be for more effective, obtain more useful effect of the present invention and the preferred implementation that adopts accurately.
Below in conjunction with the drawings general set meal evaluating system according to the present invention is set forth, but the present invention is not limited to this.One skilled in the art will appreciate that according to the principle of the invention, can make various modifications, improvement, and do not break away from the enclose scope of claim of the present invention the present invention.

Claims (34)

1. set meal income evaluating system that is used for general set meal is taken in assessment, described set meal income evaluating system is taken in assessment based on client's set meal preference pattern, and described system comprises:
Raw data imports module, is used for providing the interface of several data form to import to described set meal income evaluating system with the raw data file with relevant client;
Set meal conceptual design module is used for design and revises set meal design document, customization set meal language, set meal masterplate, and described set meal scheme comprises any a plurality of set meal shelves and a set meal supporting paper; And
Set meal measuring and calculating module is used for based on designed set meal scheme, changes by the probability of calculating every each grade of customer selecting set meal and the income that adds each grade set meal, and then calculates the expectation value that every client takes in variation; And, obtain the receptance of each grade set meal scheme and take in situation of change all client's set meals selection probability and selection set meal income variation totalling.
2. set meal income evaluating system according to claim 1, wherein, described set meal measuring and calculating module adopts the algorithm based on the rational degree of client, wherein the algorithm based on the rational degree of client is meant that autonomous setting is the rational degree of client of unit with number percent, determine the probability of the optimum set meal scheme of customer selecting, and then calculate the algorithm of set meal income influence.
3. set meal according to claim 2 income evaluating system, wherein, the arithmetic logic of described algorithm based on the rational degree of client is as follows:
If the client does not select set meal, expense is f 0Unit; Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit; Suppose that customer selecting i shelves scheme expense is minimum, i.e. f m=min (f 0f 1..., f n), then should select m shelves scheme under the resonable implementations of client; And may select other set meal schemes under the irrational situation of client; Suppose that the rational degree of client is P (0≤P≤1), then the probability of each grade of customer selecting set meal is respectively:
P m=P
P i = ( 1 - P ) * 1 f i - f m Σ j = 0 , j ≠ m n 1 f j - f m , I=0 ..., n and i ≠ m, wherein P 0Do not select the probability of set meal scheme for the client.
4. according to claim 2 or 3 described set meal income evaluating systems, wherein, described set meal measuring and calculating module also is used for according to the expense of each grade of the customer selecting set meal scheme that calculates and selects the probability of this grade set meal scheme, and calculate the receptance of every grade of set meal scheme and take in rate of change, its arithmetic logic is as follows:
If total N client has m shelves set meal scheme, i customer selecting j shelves set meal scheme expense is f Ij(1≤i≤N, 0≤j≤m), i customer selecting j shelves set meal scheme probability is P Ij(1≤i≤N, 0≤j≤m),
Figure A2006101659680003C2
(j=1,...m);
Figure A2006101659680003C3
= Σ i = 1 N P ij * ( f ij - f i 0 ) (j=1,...m);
Figure A2006101659680003C5
= Σ i = 1 N P ij * ( f ij - f i 0 ) / Σ i = 1 N f i 0 (j=1,...m);
Overall income rate of change=all shelves income rate of change sums.
5. set meal income evaluating system according to claim 1, wherein, described set meal measuring and calculating module adopts the algorithm based on the conservative coefficient of client to come the set meal income is calculated, wherein said algorithm based on the conservative coefficient of client is meant the probability of calculating each grade of customer selecting set meal according to client's decision model automatically, and guards the algorithm that coefficient is calculated by flexible configuration coefficient of sensitivity of price and client.
6. set meal according to claim 5 income evaluating system, wherein, the arithmetic logic of described algorithm based on the conservative coefficient of client is as follows:
If the client does not select set meal, expense is f 0Unit; Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit; Suppose that the conservative coefficient of set meal is α (α 〉=1), coefficient of sensitivity of price is k (k 〉=1), and then according to the conservative Y-factor method Y of client, the probability of each grade of customer selecting set meal scheme is:
P 0 = α * ( 1 f 0 ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k
P i = ( 1 f i ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k , i=1,...n
7. according to claim 5 or 6 described set meal income evaluating systems, wherein, described set meal measuring and calculating module also is used for according to the expense of each grade of the customer selecting set meal scheme that calculates and selects the probability of this grade set meal scheme, calculate the receptance and the income rate of change of every grade of set meal scheme, its arithmetic logic is as follows:
If total N client has m shelves set meal scheme, i customer selecting j shelves set meal scheme expense is f Ij(1≤i≤N, 0≤j≤m), i customer selecting j shelves set meal scheme probability is P Ij(1≤i≤N, 0≤j≤m),
Figure A2006101659680004C3
(j=1,...m);
Figure A2006101659680004C4
= Σ i = 1 N P ij * ( f ij - f i 0 ) (j=1,...m);
Figure A2006101659680004C6
= Σ i = 1 N P ij * ( f ij - f i 0 ) / Σ i = 1 N f i 0 (j=1,...m);
Overall income rate of change=all shelves income rate of change sums.
8. set meal income evaluating system according to claim 1, described system also comprises: data analysis module is used for raw data is carried out visual statistical study; Wherein, described data analysis module carries out the employed content of basic statistical study to raw data and comprises: the intermediate value of the value of maximum number of times appears in the standard deviation of the maximal value of the minimum value of the average of the mean value of the data volume of the record strip number of the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze and the field of indicating to analyze.
9. set meal income evaluating system according to claim 8, wherein, described data analysis module further comprises: the DATA DISTRIBUTION module is used for the result of data analysis module to Basic Statistics and Tables that raw data is carried out drawn the histogram of raw data analysis is represented.
10. set meal income evaluating system according to claim 1, described system also comprises: the data cleansing module, the logic interfacing that is used to data field calculating is provided, filter is cleaned mistake and singular data, is handled missing values with multiple filter method and logical combination so that raw data is carried out data processing.
11. set meal income evaluating system according to claim 10, wherein, described data cleansing module further comprises:
Be used for missing values processing module that the missing values of raw data is handled; And
Be used for exceptional value processing module that the exceptional value of the data of needs analysis is handled, wherein, described processing to exceptional value comprises: choose according to the condition of setting needs analysis data self-defined screening conditions and select the formula screening conditions of the data of analyzing according to condition of choosing or formula.
12. set meal income evaluating system according to claim 1, described system also comprises: client's stepping analysis module, and the variable, the described variable that are used to select to carry out the stepping analysis can be single client's field, or the algebraic expression of several fields; Set stepping quantity N, set the stepping ratio and generate the stepping result; Wherein said stepping result can be shown as: each grade client counts the distribution plan of client's stepping analysis result of the stepping figure that concerns between the critical value of accumulation graph, Geordie value, each grade client variable of accounting and variate-value accumulative total accounting and the mean value and form.
13. set meal income evaluating system according to claim 1, described data importing module is further used for:
From source document, select to carry out the file of data analysis and processing and the measuring and calculating of set meal subsequently, and the field attribute in the raw data file is changed into the defined form of set meal income evaluating system.
14. set meal according to claim 1 income evaluating system, described set meal conceptual design module also are used for according to set meal function expense, minimum charge and rate settings, value-added service filling, broadband binding, monthly rent is preferential and the combination of account discount and dispose and carry out the setting and the measuring and calculating of set meal shelves.
15. set meal income evaluating system according to claim 1, described set meal is taken in evaluating system and is also comprised the type of service setting module, is used for being undertaken by selection, interpolation, input, preservation or deletion action the related service setting of " speech business ", " broadband services ", " value-added service " and " integrated service ".
16. set meal income evaluating system according to claim 1, described set meal income evaluating system also comprises standard rate setting module, is used for by the setting of adding, retouching operation is finished the standard rate of corresponding service.
17. set meal income evaluating system according to claim 1, described system adopts object oriented language C# to write.
18. a set meal that uses set meal income evaluating system that general set meal is taken in assessment is taken in appraisal procedure, described set meal income appraisal procedure is taken in assessment based on client's set meal preference pattern, and described method comprises:
Raw data imports step, is used for providing the interface of several data form to import to described set meal income appraisal procedure with the raw data file with relevant client;
Set meal conceptual design step is used for design and revises the set meal design document, customization set meal language, set meal masterplate, and described set meal scheme comprises any a plurality of set meal shelves and a set meal supporting paper; And
Set meal measuring and calculating step is used for based on designed set meal scheme, changes by the probability of calculating every each grade of customer selecting set meal and the income that adds each grade set meal, and then calculates the expectation value that every client takes in variation; And, obtain the receptance of each grade set meal scheme and take in situation of change all client's set meals selection probability and selection set meal income variation totalling.
19. set meal income appraisal procedure according to claim 18, wherein, described set meal measuring and calculating step adopts the algorithm based on the rational degree of client, wherein the algorithm based on the rational degree of client is meant that autonomous setting is the rational degree of client of unit with number percent, determine the probability of the optimum set meal scheme of customer selecting, and then calculate the algorithm of set meal income influence.
20. set meal according to claim 19 income appraisal procedure, wherein, the arithmetic logic of described algorithm based on the rational degree of client is as follows:
If the client does not select set meal, expense is f 0Unit; Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit; Suppose that customer selecting i shelves scheme expense is minimum, i.e. f m=min (f 0f 1..., f n), then should select m shelves scheme under the resonable implementations of client; And may select other set meal schemes under the irrational situation of client; Suppose that the rational degree of client is P (0≤P≤1), then the probability of each grade of customer selecting set meal is respectively:
P m=P
P i = ( 1 - P ) * 1 f i - f m Σ j = 0 , j ≠ m n 1 f j - f m , I=0 ..., n and i ≠ m, wherein P 0Do not select the probability of set meal scheme for the client.
21. according to claim 19 or 20 described set meal income appraisal procedures, wherein, described set meal measuring and calculating step also is used for according to the expense of each grade of the customer selecting set meal scheme that calculates and selects the probability of this grade set meal scheme, and calculate the receptance of every grade of set meal scheme and take in rate of change, its arithmetic logic is as follows:
If total N client has m shelves set meal scheme, i customer selecting j shelves set meal scheme expense is f Ij(1≤i≤N, 0≤j≤m), i customer selecting j shelves set meal scheme probability is P Ij(1≤i≤N, 0≤j≤m),
Figure A2006101659680008C1
(j=1,...m);
Figure A2006101659680008C2
= Σ i = 1 N P ij * ( f ij - f i 0 ) (j=1,...m);
Figure A2006101659680008C4
= Σ i = 1 N P ij * ( f ij - f i 0 ) / Σ i = 1 N f i 0 (j=1,...m);
Overall income rate of change=all shelves income rate of change sums.
22. set meal income appraisal procedure according to claim 18, wherein, described set meal measuring and calculating step adopts the algorithm based on the conservative coefficient of client to come the set meal income is calculated, wherein said algorithm based on the conservative coefficient of client is meant the probability of calculating each grade of customer selecting set meal according to client's decision model of innovation automatically, and guards the algorithm that coefficient is calculated by flexible configuration coefficient of sensitivity of price and client.
23. set meal according to claim 22 income appraisal procedure, wherein, the arithmetic logic of described algorithm based on the conservative coefficient of client is as follows:
If the client does not select set meal, expense is f 0Unit; Be provided with n shelves set meal scheme, under the constant situation of conversation behavior, corresponding cost is followed successively by f after the customer selecting set meal scheme 1f 2..., f nUnit; Suppose that the conservative coefficient of set meal is α (α 〉=1), coefficient of sensitivity of price is k (k 〉=1), and then according to automatic method, the probability of each grade of customer selecting set meal scheme is:
P 0 = α * ( 1 f 0 ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k
P i = ( 1 f i ) k α * ( 1 f 0 ) k + Σ i = 1 n ( 1 f i ) k , i=1,...n
24. according to claim 23 or 24 described set meal income appraisal procedures, wherein, described set meal measuring and calculating step also is used for according to the expense of each grade of the customer selecting set meal scheme that calculates and selects the probability of this grade set meal scheme, calculate the receptance and the income rate of change of every grade of set meal scheme, its arithmetic logic is as follows:
If total N client has m shelves set meal scheme, i customer selecting j shelves set meal scheme expense is f Ij(1≤i≤N, 0≤j≤m), i customer selecting j shelves set meal scheme probability is P Ij(1≤i≤N, 0≤j≤m),
Figure A2006101659680009C1
(j=1,...m);
Figure A2006101659680009C2
= Σ i = 1 N P ij * ( f ij - f i 0 ) (j=1,...m);
Figure A2006101659680009C4
= Σ i = 1 N P ij * ( f ij - f i 0 ) / Σ i = 1 N f i 0 (j=1,...m);
Overall income rate of change=all shelves income rate of change.
25. set meal income appraisal procedure according to claim 18, described method also comprises: data analysis step is used for raw data is carried out visual statistical study; Wherein, described data analysis step is carried out the employed content of basic statistical study to raw data and comprised: the intermediate value of the value of maximum number of times appears in the standard deviation of the maximal value of the minimum value of the average of the mean value of the data volume of the record strip number of the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze, the field of indicating to analyze and the field of indicating to analyze.
26. set meal income appraisal procedure according to claim 25, wherein, described data analysis step further comprises: with the result of data analysis step to Basic Statistics and Tables that raw data is carried out, the step of drawing the histogram of raw data analysis being represented.
27. set meal income appraisal procedure according to claim 18, described method also comprises: the data cleansing step, the logic interfacing that is used to data field calculating is provided, filter is cleaned mistake and singular data, is handled missing values with multiple filter method and logical combination so that raw data is carried out data processing.
28. set meal income appraisal procedure according to claim 27, wherein, described data cleansing step further comprises:
Be used for missing values treatment step that the missing values of raw data is handled; And
Be used for exceptional value treatment step that the exceptional value of the data of needs analysis is handled, wherein, described processing to exceptional value comprises: choose according to the condition of setting needs analysis data self-defined screening conditions and select the formula screening conditions of the data of analyzing according to condition of choosing or formula.
29. set meal income appraisal procedure according to claim 18, described method also comprises: client's stepping analytical procedure, and the variable, the described variable that are used to select to carry out the stepping analysis can be single client's field, or the algebraic expression of several fields; Set stepping quantity N, set the stepping ratio and generate the stepping result; Wherein said stepping result can be shown as: each grade client counts the distribution plan of client's stepping analysis result of the stepping figure that concerns between the critical value of accumulation graph, Geordie value, each grade client variable of accounting and variate-value accumulative total accounting and the mean value and form.
30. set meal income appraisal procedure according to claim 18, described data importing step further comprises:
From source document, select to carry out the file of data analysis and processing and the measuring and calculating of set meal subsequently, and the step that the field attribute in the raw data file is changed into the defined form of set meal income appraisal procedure.
31. set meal according to claim 18 income appraisal procedure, described set meal conceptual design step comprise according to set meal function expense, minimum charge and rate settings, value-added service filling, broadband binding, monthly rent is preferential and account is preferential combination and dispose the step of setting and the measuring and calculating of carrying out the set meal shelves.
32. set meal income appraisal procedure according to claim 18, described set meal is taken in appraisal procedure and is also comprised type of service setting step, is used for being undertaken by selection, interpolation, input, preservation or deletion action the related service setting of " speech business ", " broadband services ", " value-added service " and " integrated service ".
33. set meal income appraisal procedure according to claim 18, described set meal income appraisal procedure also comprises standard rate setting step, is used for by the setting of adding, retouching operation is finished the standard rate of corresponding service.
34. set meal income appraisal procedure according to claim 18, described set meal income appraisal procedure adopts object oriented language C# to write.
CNA2006101659685A 2006-12-12 2006-12-12 Method for estimating client level set-meal incomings and correlate system Pending CN101201924A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CNA2006101659685A CN101201924A (en) 2006-12-12 2006-12-12 Method for estimating client level set-meal incomings and correlate system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CNA2006101659685A CN101201924A (en) 2006-12-12 2006-12-12 Method for estimating client level set-meal incomings and correlate system

Publications (1)

Publication Number Publication Date
CN101201924A true CN101201924A (en) 2008-06-18

Family

ID=39517078

Family Applications (1)

Application Number Title Priority Date Filing Date
CNA2006101659685A Pending CN101201924A (en) 2006-12-12 2006-12-12 Method for estimating client level set-meal incomings and correlate system

Country Status (1)

Country Link
CN (1) CN101201924A (en)

Cited By (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101827178A (en) * 2009-11-30 2010-09-08 中兴通讯股份有限公司 Method and device for realizing polyphonic ringtone plan
CN102075896B (en) * 2009-11-20 2014-06-04 中国移动通信集团贵州有限公司 Price previewing method and system
CN104823156A (en) * 2012-12-28 2015-08-05 英特尔公司 Instruction for determining histograms
CN105373946A (en) * 2015-10-09 2016-03-02 上海瀚之友信息技术服务有限公司 Supplier switching method and system
CN105825311A (en) * 2015-01-05 2016-08-03 中国移动通信集团湖南有限公司 Package determining method and package determining system
CN106227715A (en) * 2016-07-13 2016-12-14 广东电网有限责任公司 A kind of electricity electricity charge acquisition methods
CN112200651A (en) * 2020-10-22 2021-01-08 浪潮天元通信信息系统有限公司 Method and tool for accounting IFRS15 income according to income configuration elements

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102075896B (en) * 2009-11-20 2014-06-04 中国移动通信集团贵州有限公司 Price previewing method and system
CN101827178A (en) * 2009-11-30 2010-09-08 中兴通讯股份有限公司 Method and device for realizing polyphonic ringtone plan
CN104823156A (en) * 2012-12-28 2015-08-05 英特尔公司 Instruction for determining histograms
US9804839B2 (en) 2012-12-28 2017-10-31 Intel Corporation Instruction for determining histograms
CN104823156B (en) * 2012-12-28 2018-07-17 英特尔公司 Instruction for determining histogram
US10416998B2 (en) 2012-12-28 2019-09-17 Intel Corporation Instruction for determining histograms
US10908907B2 (en) 2012-12-28 2021-02-02 Intel Corporation Instruction for determining histograms
US10908908B2 (en) 2012-12-28 2021-02-02 Intel Corporation Instruction for determining histograms
CN105825311A (en) * 2015-01-05 2016-08-03 中国移动通信集团湖南有限公司 Package determining method and package determining system
CN105373946A (en) * 2015-10-09 2016-03-02 上海瀚之友信息技术服务有限公司 Supplier switching method and system
CN106227715A (en) * 2016-07-13 2016-12-14 广东电网有限责任公司 A kind of electricity electricity charge acquisition methods
CN112200651A (en) * 2020-10-22 2021-01-08 浪潮天元通信信息系统有限公司 Method and tool for accounting IFRS15 income according to income configuration elements

Similar Documents

Publication Publication Date Title
Coon et al. The North Dakota input-output model: A tool for analyzing economic linkages
Rosset et al. Customer lifetime value modeling and its use for customer retention planning
CN101201924A (en) Method for estimating client level set-meal incomings and correlate system
Radhi et al. Optimal configuration of remanufacturing supply network with return quality decision
Draper Implicit stochastic optimization with limited foresight for reservoir systems
Pinto et al. Tariff structures for water and sanitation urban households: a primer
CN107818503A (en) A kind of dynamically personalized menu of bank card IVR system recommends method
CN107392645A (en) Usage mining method, apparatus and its equipment
Dullaghan et al. Integration of machine learning techniques to evaluate dynamic customer segmentation analysis for mobile customers
CN109189931A (en) A kind of screening technique and device of object statement
CN107832132A (en) Application control method, apparatus, storage medium and electronic equipment
CN106127663A (en) A kind of communication user consumption feature attribute reduction matching extracting method and data system
CN107977855A (en) A kind of method and device of managing user information
Liao et al. Measuring the technology gap of APEC integrated telecommunications operators
CN109858947A (en) Retail user value analysis system and method
CN105139184A (en) Diversified data calculation method and diversified data calculation system
CN107909401A (en) A kind of satisfaction measuring method based on big data technology
CN202433952U (en) General network reporting system
Qu et al. Analysis of agriculture water pricing reform in a water-deficit area of Northwest China
CN109978304A (en) The appraisal procedure and device of object-oriented
CN108376300A (en) A kind of user power utilization behavior prediction method based on probability graph model
Yang et al. The effect of shortening lock-in periods in telecommunication services
US20070088642A1 (en) System and method for calculating savings
Mints et al. Hierarchical Fuzzy Method of Comparing Bank Products with Complex Tariff Packages
Tarassow et al. FEP-the forecast evaluation package for gretl: Based on FEP version 2.1

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C12 Rejection of a patent application after its publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20080618