CN114358729B - A method and system for implementing a formula recommendation algorithm - Google Patents
A method and system for implementing a formula recommendation algorithm Download PDFInfo
- Publication number
- CN114358729B CN114358729B CN202111654784.6A CN202111654784A CN114358729B CN 114358729 B CN114358729 B CN 114358729B CN 202111654784 A CN202111654784 A CN 202111654784A CN 114358729 B CN114358729 B CN 114358729B
- Authority
- CN
- China
- Prior art keywords
- formula
- calculation
- formulas
- recommendation
- conditions
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 34
- 238000004422 calculation algorithm Methods 0.000 title claims abstract description 29
- 238000004364 calculation method Methods 0.000 claims abstract description 132
- 230000006870 function Effects 0.000 claims description 41
- 230000007774 longterm Effects 0.000 abstract 1
- 235000012054 meals Nutrition 0.000 description 15
- 239000013589 supplement Substances 0.000 description 11
- 208000027418 Wounds and injury Diseases 0.000 description 9
- 230000006378 damage Effects 0.000 description 9
- 208000014674 injury Diseases 0.000 description 9
- 230000008901 benefit Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 7
- 230000000295 complement effect Effects 0.000 description 6
- 230000035558 fertility Effects 0.000 description 5
- 239000010931 gold Substances 0.000 description 5
- 229910052737 gold Inorganic materials 0.000 description 5
- 230000004044 response Effects 0.000 description 5
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 4
- 239000000284 extract Substances 0.000 description 2
- 206010000210 abortion Diseases 0.000 description 1
- 231100000176 abortion Toxicity 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 201000010099 disease Diseases 0.000 description 1
- 208000037265 diseases, disorders, signs and symptoms Diseases 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 150000002343 gold Chemical class 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000007620 mathematical function Methods 0.000 description 1
- 230000000474 nursing effect Effects 0.000 description 1
- 239000000047 product Substances 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000001502 supplementing effect Effects 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
本发明涉及一种公式推荐算法的实现方法及系统，属于公式推荐技术领域。方法包括：预存储资金运算的若干种计算公式，若干种计算公式包括常规公式和/或自定义公式；资金运算包括薪酬运算和/或工程运算；获取各资金运算对应的数据源并确定对应的推荐条件；薪酬运算对应的数据源为考勤数据，工程运算对应的数据源为工程管理数据；推荐条件为根据需求进行设定的条件；将数据源带入对应的资金运算的不同计算公式中，对比不同计算公式的计算结果；将满足推荐条件的计算结果所对应的计算公式进行推荐。本发明无需工作人员进行长期的学习，只需设定推荐条件即可得到最优的计算公式，操作简单，效率高。
The present invention relates to an implementation method and system of a formula recommendation algorithm, and belongs to the technical field of formula recommendation. The method includes: pre-storing several calculation formulas for fund operations, the several calculation formulas include conventional formulas and/or custom formulas; fund operations include salary operations and/or engineering operations; obtaining the data source corresponding to each fund operation and determining the corresponding recommendation conditions; the data source corresponding to the salary operation is attendance data, and the data source corresponding to the engineering operation is engineering management data; the recommendation conditions are conditions set according to demand; the data source is brought into different calculation formulas for the corresponding fund operations, and the calculation results of different calculation formulas are compared; and the calculation formula corresponding to the calculation result that meets the recommendation conditions is recommended. The present invention does not require long-term learning by the staff, and only requires setting the recommendation conditions to obtain the optimal calculation formula, which is simple to operate and highly efficient.
Description
Technical Field
The invention relates to a method and a system for realizing a formula recommendation algorithm, and belongs to the technical field of formula recommendation.
Background
The formula calculation is often used in the business system of each company, and each project corresponds to a plurality of different calculation formulas, for example, the calculation formulas of salary operation, and the related calculation items comprise a false hour, a overtime hour, a basic wages, an academic subsidy, a spacious working hour, a monthly working days and the like. The method has a plurality of different calculation formulas for different calculation items, so that the calculation formulas for salary operation are different, different calculation results are obtained by different calculation formulas, and the operation cost of a company is different.
Finding the optimal and most suitable computing formulas among the several different computing formulas is very important for enterprise operation management. The selection of the existing optimal formula generally requires a worker to learn different calculation formulas for a long time, or to design corresponding calculation formulas through learning, and the optimal formula is determined by comparing different calculation results, so that the existing mode not only increases the learning cost of enterprises, but also has low overall efficiency.
Disclosure of Invention
The application aims to provide a method and a system for realizing a formula recommendation algorithm, which are used for solving the problems of low efficiency and high cost in the existing formula determination process.
In order to achieve the above purpose, the present application provides a technical scheme of a method for implementing a formula recommendation algorithm, including the following steps:
1) The system comprises a plurality of calculation formulas for pre-storing fund operation, wherein the plurality of calculation formulas comprise conventional formulas and/or custom formulas, the conventional formulas are unified calculation formulas formulated according to expert experience, the custom formulas are calculation formulas built by self according to requirements, and the fund operation comprises salary operation and/or engineering operation;
2) Acquiring data sources corresponding to each fund operation and determining corresponding recommended conditions, wherein the data sources corresponding to the compensation operation are attendance data, and the data sources corresponding to the engineering operation are engineering management data;
3) Bringing the data source into different calculation formulas of corresponding fund operation, and comparing calculation results of the different calculation formulas;
4) And recommending the calculation formula corresponding to the calculation result meeting the recommendation condition.
The method for realizing the formula recommendation algorithm has the beneficial effects that by storing a plurality of calculation formulas corresponding to each fund operation, when recommendation is needed, a data source corresponding to each fund operation is obtained, the data source is brought into different calculation formulas to obtain different calculation results, the calculation results are compared, and the calculation formulas meeting the recommendation conditions are selected for recommendation. According to the invention, a worker does not need to learn for a long time, an optimal calculation formula can be automatically obtained by only setting recommended conditions, and the method is simple to operate and high in efficiency.
Further, the self-defined formula is built through a formula definition module, wherein the formula definition module comprises an operator and a function, the operator comprises an arithmetic operator, a comparison operator and a logic operator, and the function comprises a sine function, a cosine function, a tangent function, an absolute value function and a judging function.
In order to avoid a complex flow of formula definition by adopting a formula programming mode, a formula is built through a formula definition module, the formula input process is simplified, and the simple formula building method is suitable for less-experienced staff and meets the working requirements of staff at various levels.
Further, the recommendation condition is adjusted according to the time factor and the operation factor, and the recommendation result is updated after the recommendation condition is adjusted.
When the fund operation needs to be adjusted in different periods or under the influence of company operation, the corresponding optimal formula can be obtained by adjusting the recommended conditions, and the method is convenient and simple.
Further, the conventional formula is updated periodically.
In the case that a new conventional formula is found, the latest conventional formula can be stored to meet the latest requirements.
In addition, the application further provides a technical scheme of an implementation system of the formula recommendation algorithm, the implementation system of the formula recommendation algorithm comprises an intelligent formula learning library, a calculation comparison module and a recommendation module, the intelligent formula learning library is used for storing a plurality of calculation formulas of fund calculation, the plurality of calculation formulas comprise conventional formulas and/or custom formulas, the conventional formulas are unified calculation formulas formulated according to expert experience, the custom formulas are calculation formulas built by self according to requirements, the fund calculation comprises salary calculation and/or engineering calculation, the calculation comparison module is used for acquiring data sources corresponding to the fund calculation, the data sources are brought into different calculation formulas of the corresponding fund calculation and are compared with calculation results of the different calculation formulas, the data sources corresponding to the salary calculation are attendance data, the data sources corresponding to the engineering calculation are engineering management data, the recommendation module is used for determining recommendation conditions corresponding to the fund calculation, the calculation formulas corresponding to the calculation results meeting recommendation conditions are recommended according to requirements, and the recommendation conditions are conditions set according to requirements.
The technical scheme of the formula recommendation algorithm implementation system has the advantages that the intelligent formula learning library is used for storing a plurality of calculation formulas corresponding to each fund operation, when recommendation is needed, the calculation comparison module is used for obtaining data sources corresponding to each fund operation, the data sources are brought into different calculation formulas to obtain different calculation results, the calculation results are compared, and the recommendation module is used for selecting the calculation formulas meeting recommendation conditions to recommend. According to the invention, a worker does not need to learn for a long time, an optimal calculation formula can be automatically obtained by only setting recommended conditions, and the method is simple to operate and high in efficiency.
The self-defined formula is built through the formula definition module, the formula definition module comprises an operator and a function, the operator comprises an arithmetic operator, a comparison operator and a logic operator, and the function comprises a sine function, a cosine function, a tangent function, an absolute value function and a judging function.
In order to avoid a complex flow of formula definition by adopting a formula programming mode, a formula is built through a formula definition module, the formula input process is simplified, and the simple formula building method is suitable for less-experienced staff and meets the working requirements of staff at various levels.
Further, the recommendation condition is adjusted according to the time factor and the operation factor, and the recommendation result is updated after the recommendation condition is adjusted.
When the fund operation needs to be adjusted in different periods or under the influence of company operation, the corresponding optimal formula can be obtained by adjusting the recommended conditions, and the method is convenient and simple.
Further, the conventional formula is updated periodically.
In the case that a new conventional formula is found, the latest conventional formula can be stored to meet the latest requirements.
Drawings
FIG. 1 is a block diagram of a system for implementing the formula recommendation algorithm of the present invention.
Detailed Description
Implementation system embodiment of formula recommendation algorithm:
The invention stores various calculation formulas of fund operation in an intelligent formula learning library based on the existing optimal calculation formula selection mode with high cost and low efficiency, a calculation comparison module brings data sources into different calculation formulas after acquiring corresponding data sources to obtain different calculation results, and a recommendation module performs screening and recommendation of the calculation formulas according to set recommendation conditions and the calculation results, so that the recommendation of the optimal calculation formulas is simpler and more efficient.
Specifically, as shown in fig. 1, the system for implementing the formula recommendation algorithm includes a formula definition module, an intelligent formula learning library, a calculation comparison module, and a recommendation module.
The intelligent formula learning library is used for storing the constructed custom formulas or the acquired conventional formulas, comprising a salary business formula library and an engineering budget business formula library, the calculation comparison module (namely, a calculation result comparison center in fig. 1) comprises a calculation module and a budget module, the calculation module is used for calculating and comparing calculation results of different calculation formulas corresponding to salary operation, the budget module is used for calculating and comparing calculation results of different calculation formulas corresponding to engineering operation, and the recommendation module (namely, the intelligent formula recommendation module in fig. 1) is used for recommending the calculation formulas corresponding to calculation results meeting recommendation conditions according to the recommendation conditions and the calculation results obtained by the calculation comparison module.
The whole realization system of the formula recommendation algorithm is used for realizing the realization method of the formula recommendation algorithm, and the method comprises the following steps:
1) And constructing a plurality of custom formulas of the fund operation through a formula definition module, and acquiring a plurality of conventional formulas of the fund operation.
The conventional formula is a unified calculation formula established according to expert experience, the custom formula is a calculation formula built by a formula definition module according to requirements, the fund operation comprises salary operation and engineering operation, namely, the conventional formula comprises a plurality of calculation formulas of salary operation and a plurality of calculation formulas of engineering operation.
The formula definition module comprises an operation object definition, a function and an operator, and a plurality of small formulas are combined through the function and the operation object and the operator, so that a large formula is determined. For the operation object of compensation operation, the small formula comprises holiday overtime fee formula, meal compensation formula and the like, and the large formula, namely the calculation formula of compensation operation, is the payroll formula. The difference in the calculation ways of the small formulas will lead to the appearance of several calculation formulas for the large formulas.
For example, a holiday overtime formula is that holiday overtime=basic wages/21.75/8*3 is that holiday overtime time, a meal compensation formula is that meal compensation=iff (whether meal compensation is sent= "yes", attendance days are 12, 0), and when the iff function judges that meal compensation is sent, the meal compensation is sent according to the actual attendance days and the 12-yuan standard per day.
The payroll formula should be: payroll = basic payroll + post payroll + overtime + meal compensation.
The operators include arithmetic operators (addition, subtraction, multiplication, division), comparison operators, logical operators (> greater than, > = greater than or equal to, < less than, < = less than or equal to, = equal to, +=unequal to), and the like, and the operator priorities remain consistent with the normal order.
The functions are mathematical functions including sine function math.sin (d), cosine function math.cos (d), tangent function math.tan (d), absolute value function math.abs (d), judgment function iff (true, false), judgment of true or false by the first value, execution of subsequent formula blocks, and the like.
The formula definition module supports common types such as numbers, boolean values, strings, integers, bgiDecimal, and the like.
The list of operators is shown in Table one:
list of table-one operators
| Priority level | Operator | Binding property |
| 1 | ()[]. | From left to right |
| 2 | !~ | From right to left |
| 3 | */% | From left to right |
| 4 | +- | From left to right |
| 5 | <<>>>>> | From left to right |
| 6 | <<=>>= | From left to right |
| 7 | ==!= | From left to right |
| 8 | & | From left to right |
| 9 | ^ | From left to right |
| 10 | | | From left to right |
| 11 | && | From left to right |
| 12 | || | From left to right |
| 13 | ?: | From left to right |
| 14 | ==~ | From right to left |
The list for the functions is shown in Table two:
list of table two functions
2) Various custom formulas and conventional formulas of each established fund operation are stored in an intelligent formula learning library.
As can be seen from fig. 1, the intelligent formula learning library includes a compensation business formula library and an engineering budget business formula library, and other expansion business formula libraries are also possible.
The large formulas and the small formulas of the salary operation are stored in the salary business formula library, and different salary should be sent for different posts. The engineering budget business formula library stores corresponding formulas of engineering operation.
The conventional formula may appear new over time, thus requiring regular updates to the conventional formula.
3) The calculation comparison module synchronizes the attendance data of the attendance system with the engineering management data of the engineering management system through the data synchronization tool, extracts the attendance data into the accounting module for compensation operation, and extracts the engineering management data into the budget module for engineering operation.
The accounting module brings the attendance data into calculation formulas of various salary operations, the budget module brings the engineering management data into calculation formulas of various engineering operations to obtain different salary operation results and engineering operation results, and the different operation results are compared.
The synchronization tool is used for synchronizing the data of the attendance system, so that manual data input can be avoided, and the synchronization tool is of the prior art and is not described too much.
4) The recommendation module is provided with recommendation conditions corresponding to the determined fund operations, and a calculation formula corresponding to a calculation result meeting the recommendation conditions is recommended.
The recommended condition is a condition set according to the requirements of enterprises, the recommended condition can be the lowest cost of salary or the cost of salary within a certain set range for salary operation, and the recommended condition can be the lowest budget or the budget within a certain set range for engineering operation.
Regarding the recommendation condition, the recommendation condition can be adjusted according to the time factor and the operation factor, and the recommendation result is updated after the recommendation condition is adjusted. For example, when the company is difficult to operate, the recommended condition for the salary operation is set to be the lowest salary cost, and when the company is relieved, the recommended condition for the salary operation is set to be the moderate salary cost.
In the above embodiment, the formula definition module is used to build the self-defined formula to meet the working needs of the staff with different levels, and even if the staff with less working experience can complete the input of the formula, as other embodiments, the formula can be built in a programming manner, which is not limited in the invention.
The following describes the implementation method of the formula recommendation algorithm of the present invention in detail by taking the implementation of the calculation formula recommendation algorithm of the functional post in the compensation operation as an example.
First, the intelligent formula learning library stores a formula library 001 for a function post and a formula library 002 for a function post.
Formula library 001 for job position
1. Vehicle fare supplement is iff (whether departure supplement= "1", if (number of attendance days >0,60/(number of full attendance days-number of holidays on month) the departure supplement summary on month, 0), 0);
2. number of full service hours 8 times of number of full service days;
3. the company bears social insurance, namely, the current month old-age company bears, the current month medical company bears, the current month work injury company bears, the current month birth company bears, the current month lost company bears, the current month housing company bears, the previous month old-age company bears and the previous month housing company bears;
4. Non-attendance deduction, iff (legal holiday during attendance: 0or full day-check day-month holiday day >0, (basic wage + post wage)/full time hours (full time hours-check hours-legal holiday during attendance: 8), 0);
5. overtime, basic wages/21.75/8 holiday overtime time 3;
6. Meal supplement, namely 10 times of meal supplement of overtime and work day and 10 times of meal supplement of overtime and work day;
7. invitation withholding @ iff (number of hours on duty >0, (basic payroll + post payroll + certificate benefits)/(number of hours on duty) (number of hours on condition + number of hours on abortion + 0.5+ number of days on holidays on birth) 0);
8. the open work deduction is that if (number of response hours is greater than 0, (basic payroll + post payroll + certificate body)/(number of full service hours) the open work hours are 2, 0);
9. Generation notification gold if (whether generation notification gold is deducted = 1, (basic payroll + post payroll + meal fee subsidy + car fee subsidy)/30 generation notification days, 0);
10. the total of the payroll, basic payroll, post payroll, dining fee complement, vehicle fee complement, certificate benefit, overtime fee, overtime complement, overtime meal complement, project benefit, process complement, other complement, overage fee, workload benefit and performance benefit;
11. revenue total, namely, total to be sent- (quality prize deduction + full work attendance prize deduction + late deduction + false deduction + open work deduction + attendance deduction + other deductions + supplementary deduction + notification money);
12. tax payroll is total income- (old-age to month + medical to month + lost business to month + housing to month + old-age to month + industrial injury to month + medical to month + fertility to month + housing to month + business insurance to post month + business injury to post month + medical to post month + fertility to post month + housing to post month) +cash dispensing item;
13. payroll-revenue aggregate- (current month of care+current month of work injury+current month of care+current month of birth+current month of life+current month of loss+current month of life)
14. The deduction sum is that the quality prize deduction is + full work attendance prize deduction is + late deduction is + false deduction is + the open work deduction is + the attendance deduction is + other deductions are + the supplementary deduction is + the notification deposit is replaced;
15. The real issue total is the sum of the response issue, the deduction sum and the substitute deduction.
Job position formula library 002
1. Fare supplement, iff (departure supplement= "1",60,0);
2. number of full service hours 8 times of number of full service days;
3. The company bears social security: the method comprises the following steps of (1) carrying out current month old age companies, (b) carrying out current month medical treatment, carrying out current month lost business, carrying out current month work injury, carrying out current month child companies, (c) carrying out current month family members, carrying out current month old age companies, (c) carrying out current month old age companies, (d) carrying out previous month old age companies, (d) carrying out social security adjustment, and (d) carrying out current month outpatient medical treatment; company bearing, major medical company bearing, local nursing, disabled person employment guarantee, monthly work injury company bearing, monthly medical company bearing, monthly fertility company bearing, monthly loss company bearing, work injury insurance supplementing and monthly major medical company bearing; (the formula is suitable for deducting the current social security or deducting the calculation mode of the social security to the month, and one of the two calculation modes is selected);
4. the non-attendance deduction is that iff (full duty day-response day-false day-sick day-other false day-legal holiday during attendance >0, (basic wages + post wages + regional subsidies + house subsidies + telephone subsidies + car fee subsidies + certificate benefits + working subsidies)/full duty day (full duty day-response day-false day-sick day-other false day-legal holiday during attendance), 0) ";
5. overtime, basic wages/21.75/8*3 holiday overtime;
6. meal supplement-if (whether meal supplement is sent= "1", day of duty 12, 0);
7. Off-line deduction, iff (number of days on demand + number of days on illness >3, (basic payroll + post payroll + car fee subsidy + regional subsidy + house subsidy + telephone subsidy + certificate benefits + procedure subsidy)/number of days on duty + number of days on demand + basic payroll + post payroll + regional subsidy + house subsidy + telephone subsidy + car fee subsidy + procedure subsidy)/number of days on duty 0.5, 0);
8. Notification fund if (whether notification fund deducted = 1, (basic payroll + post payroll + regional subsidy + dining fee subsidy + fare subsidy + housing subsidy + phone subsidy + certificate subsidy)/30 notification days, 0);
9. the total of the payroll, basic payroll, post payroll, regional subsidy, dining fee subsidy, vehicle fee subsidy, certificate subsidy, housing subsidy, process subsidy, telephone subsidy, shift fee adding, project subsidy, overranging fee, subsidy, other subsidy, performance rewards and workload rewards;
10. Revenue total, total to be paid- (full work attendance prize deductions + quality prize deductions + false deductions + non-attendance deductions + other deductions + notification money + supplementary deductions);
11. Tax payroll-revenue aggregate- (old-month-old medical treatment + big-month-old-disease medical treatment + month-old lost business + month-old housing);
12. The deduction sum is full work attendance awards deduction, quality awards deduction, false deduction, not attendance deduction, other deductions, notification of gold, current month old maintenance, current month medical treatment, current month loss, current month housing, current month outpatient medical treatment tax deduction, current month industrial injury and current month fertility;
13. Payroll: revenue aggregate- (current month of care + current month of medical treatment + current month of loss + current month of housing + current month of injury + current month of business insurance + current month of fertility);
14. the real issue total is the sum of the response issue, the deduction sum and the substitute deduction.
And secondly, the calculation comparison module performs data synchronization or import, calculates a formula library and compares calculation results.
The system is used for extracting data sources above data from a business system through a data synchronization service, such as attendance records, leave records, overtime records, abstinence records, holiday records and the like.
The basic wages in the data source warehouse are 4000 yuan, the post wages are 6000 yuan, the number of days for full duty is 22 days, the number of days for actual attendance is 21 days, the overtime is 15 hours, the regional subsidy is 100 yuan, the housing subsidy is 1000 yuan, the telephone subsidy is 100 yuan, the certificate subsidy is 100 yuan, the working procedure subsidy is 100 yuan, the number of times of the day and night service dinner supplement is 10 times, the number of days for notification is 0 day, the legal holiday is 0 day, the month-keeping age is 360 yuan, the month medical treatment is 90 yuan, the month-keeping insurance is 90 yuan, and the month housing is 450 yuan;
The data are brought into a functional post formula library 001 and a functional post formula library 002, and the calculated results of the functional post 001 and 002 formula library are as follows:
calculation result of job position formula library 001
1. The vehicle charge is supplemented by 40 yuan;
2. Number of hours on duty 8 x 22 = 176 hours;
3. The company bears social security 360+90+13.5+450= 913.5 yuan;
4. no attendance deduction (4000+6000)/22×1= 454.55 yuan;
5. executive charge 4000/21.75/8 x 15 x 3= 1034.48 yuan;
6. Meal-supplement-assistance 10×10+10×10=200 yuan;
7. please pay for the deduction (4000+6000+100)/(176) 8=459 yuan;
8. The payment is withheld by the open worker for 0 yuan;
9. Substituted gold (4000+40+200)/30×0=0 element;
10. And (5) adding the following steps:
4000+6000+100+200+40+100+1034.48+0+0+0+100+0+0+0+0+0= 11474.48 elements;
11. Total revenue 11474.48- (0+0+0+0+0+454.55+0+0+0) = 11019.93 yuan;
12. Tax payroll 11019.93- (360+90+13.5+450) = 10106.43 yuan;
13. payroll 11019.93- (360+90+13.5+450) = 10106.43 yuan;
14. the deduction sum is 0+0+0+0+0+454.55+0+0+0= 454.55 yuan;
15. aggregate, 11474.48-454.55-0= 11019.93 yuan.
Calculation result of job position formula library 002
1. The vehicle charge is supplemented by 60 yuan;
2. Number of hours on duty 8 x 22 = 176 hours;
3. The company bears social security:
360+90+13.5+450+100+1000+0+0+0+0+0+0+0= 2013.5 yuan;
4. No attendance deduction (4000+6000+100+1000+100+100+100)/22×1= 518.18 yuan;
5. executive charge 4000/21.75/8 x 15 x 3= 1034.48 yuan;
6. meal supplement is 22×12=264 yuan;
7. Leave for deduction:
(4000+6000+60+100+1000+100+100+100)/22×1+ (4000+6000+100+1000+100+60+100+100)/22×0.5, 0) =520 elements;
8. Substituted notification gold (4000+100+264+60+100+100+100)/30×0=0 element;
9. And (5) adding the following steps:
4000+6000+100+264+60+100+1000+100+100+1034.48+0+0+0+0+0= 12758.48 bits;
10. Total revenue 12758.48- (0+0+0+518.18+0+0) = 12240.3 bits;
11. tax payroll 12240.3- (360+90+13.5+450) = 11326.8 yuan;
12. The deduction sum is 0+0+0+518.18+0+0= 518.18 yuan;
13. Payroll 12240.3- (360+90+13.5+450) = 11326.8 yuan;
14. Aggregate, 12758.48-518.18-0= 12240.3 yuan.
The calculation comparison module automatically compares the actual payroll calculation result of the functional post formula library 001 with 11019.93 yuan, the actual payroll calculation result of the functional post formula library 002 with 12240.3 yuan, and so on, the system automatically calculates the payroll calculation results of all formula libraries (including the functional post formula library 003 and the functional post formula library 004) in the intelligent formula learning library, and sorts the calculation results from large to small after the automatic comparison.
And finally, the recommendation module self-defines input conditions (namely recommendation conditions) to obtain an intelligent formula recommendation result.
And (3) customizing input conditions, such as recommending a formula with lowest compensation cost.
The system automatically compares all calculated results and intelligently recommends a result that the job position formula library 001 is the lowest job position compensation cost formula.
According to the embodiment, the salary calculation process is very complex, the efficiency is very low in a manual learning mode, and the optimal recommended formula is obtained by automatically comparing different calculation formulas, so that the selection efficiency of the optimal formula is greatly improved.
The formula recommendation main application scene of the invention is that pay settlement, engineering budget and the like are not limited to the two fund operations, the invention provides an optimal and most suitable algorithm, provides an optimal scheme for enterprises, reduces various trial-and-error costs and brings about cost increase, and takes a product client as an example, if a 3000-person manufacturing factory is provided, each working hour is calculated according to 25 yuan on average, and the time is saved by approximately 7.5 ten thousand yuan per month compared with the time before the use of the algorithm after the attendance recommendation algorithm is used.
Implementation method embodiment of formula recommendation algorithm:
the specific implementation process and effects of the implementation method of the formula recommendation algorithm are described in the implementation system embodiment of the formula recommendation algorithm, which is not described herein.
Claims (6)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111654784.6A CN114358729B (en) | 2021-12-30 | 2021-12-30 | A method and system for implementing a formula recommendation algorithm |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111654784.6A CN114358729B (en) | 2021-12-30 | 2021-12-30 | A method and system for implementing a formula recommendation algorithm |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114358729A CN114358729A (en) | 2022-04-15 |
| CN114358729B true CN114358729B (en) | 2024-12-24 |
Family
ID=81102513
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111654784.6A Active CN114358729B (en) | 2021-12-30 | 2021-12-30 | A method and system for implementing a formula recommendation algorithm |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114358729B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114971558A (en) * | 2022-05-31 | 2022-08-30 | 中智薪税技术服务有限公司 | Method and system based on salary tax calculation and computer readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110647666A (en) * | 2019-09-03 | 2020-01-03 | 平安科技（深圳）有限公司 | Intelligent matching method and device for template and formula and computer readable storage medium |
| CN112507675A (en) * | 2020-11-05 | 2021-03-16 | 社宝信息科技(上海)有限公司 | Intelligent salary calculation and real-time salary issuing system and method |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933181A (en) * | 2015-07-01 | 2015-09-23 | 周口师范学院 | Mathematical formula searching method and device |
| CN107657519A (en) * | 2017-09-06 | 2018-02-02 | 深圳市恒创智达信息技术有限公司 | Emolument calculating, delivery system and its method |
| CN108256986A (en) * | 2017-10-12 | 2018-07-06 | 平安科技（深圳）有限公司 | Wages computational methods, application server and computer readable storage medium based on cloud computing |
| CN109447775A (en) * | 2018-10-20 | 2019-03-08 | 江苏壹才网网络科技有限公司 | It pays out wages and wage and salary administration system on a kind of line based on bank settlement and cloud computing |
| CN112463819B (en) * | 2020-11-26 | 2024-10-25 | 北京宏景世纪软件股份有限公司 | Calculation method, device, equipment and storage medium based on Chinese expression |
| CN112508414A (en) * | 2020-12-08 | 2021-03-16 | 北京无线电测量研究所 | Working hour accounting method, system and computer equipment |
| CN113342976B (en) * | 2021-06-17 | 2023-07-04 | 北京海数宝科技有限公司 | Method, device, storage medium and equipment for automatically acquiring and processing data |
-
2021
- 2021-12-30 CN CN202111654784.6A patent/CN114358729B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110647666A (en) * | 2019-09-03 | 2020-01-03 | 平安科技（深圳）有限公司 | Intelligent matching method and device for template and formula and computer readable storage medium |
| CN112507675A (en) * | 2020-11-05 | 2021-03-16 | 社宝信息科技(上海)有限公司 | Intelligent salary calculation and real-time salary issuing system and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114358729A (en) | 2022-04-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6912508B1 (en) | Method and apparatus for promoting taxpayer compliance | |
| US20050038721A1 (en) | Integrated utility accounting, materials management, work management and regulatory reporting software | |
| US8290847B2 (en) | Methods, apparatus and computer program products for use in association with joint ventures and/or potential joint ventures | |
| AU2023202118A1 (en) | Improved system and method for timekeeping entry and work in progress reports | |
| CN105184448A (en) | Catering chain enterprise store salary management system | |
| US5852824A (en) | Apparatus and method for processing year-date data in computer systems | |
| CN107590619A (en) | A kind of electric automobile charging station operation management automatic scheduling strategy | |
| CN101510276A (en) | Payroll computation method adapting multi-valuta and multi-time-interval | |
| US20200342379A1 (en) | Forecasting methods | |
| CN114358729B (en) | A method and system for implementing a formula recommendation algorithm | |
| Serengil et al. | ATM cash flow prediction and replenishment optimization with ANN | |
| Morkovina et al. | Export potential and measures to support small and medium-sized enterprises | |
| CN115994679B (en) | Regional power grid active planning method and system based on load prediction correction | |
| Yung et al. | Labor planning and shift scheduling in retail stores using customer traffic data | |
| CN113159726B (en) | Science and technology project management and control system | |
| JP2025031987A (en) | Information processing device, information processing method, and program | |
| CN120125367A (en) | IT Project Cost Financial Independent Accounting System | |
| US20120011039A1 (en) | System and method for services management | |
| US20090234885A1 (en) | Account item management system | |
| JP7759610B2 (en) | Planning device, planning method, and program | |
| JP2004192495A (en) | Lifetime design support system | |
| CN101669137A (en) | Processing apparatus for normalizing a strip representing a weighted variable | |
| Gatzlaff et al. | Uncertainty, growth controls, and the efficiency of development patterns | |
| Hinomoto | An on-line customer information system at a gas-utility company | |
| KR100635433B1 (en) | How to group automation devices |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |