CN104408585A - Automatic calculation system for budget quota debugging of thermal power unit - Google Patents
Automatic calculation system for budget quota debugging of thermal power unit Download PDFInfo
- Publication number
- CN104408585A CN104408585A CN201410798647.3A CN201410798647A CN104408585A CN 104408585 A CN104408585 A CN 104408585A CN 201410798647 A CN201410798647 A CN 201410798647A CN 104408585 A CN104408585 A CN 104408585A
- Authority
- CN
- China
- Prior art keywords
- debugging
- quota
- budget
- expense
- cost
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0637—Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to the technical field of electric power, in particular to an automatic calculation system for budget quota debugging of a thermal power unit, and particularly provides an automatic calculation system for budget (budget estimate) quota debugging of a thermal power unit. The system can accurately finish calculation work of budget (budget estimate) quota debugging according to parameters such as the size of the unit, the type of a boiler, the model of a coal pulverizing system, difficult degree of a debugging area, the tax rate, the profit margin and the like, and provides a debug unit with accurate reference for tender offer. The automatic calculation system comprises a subsystem quota debugging calculation part, whole set start quota debugging calculation part, a comprehensive data part, a parameter definition part, a budget quota part and an instruction part. The automatic calculation system can calculate the quota budget debugging of a specific thermal power unit quickly, so that the working efficiency is increased, reference is provided for tender work of a debugging enterprise, and malicious low-price bid is prevented.
Description
Technical field
The present invention relates to technical field of electric power, particularly relate to a kind of fired power generating unit debugging quota budget Automatic computing system.Specifically a set of fired power generating unit debugging quota pre-(generally) calculates the Automatic computing system of quota, this system can complete exactly according to all multiparameters such as arduous degree, the tax rate, rate of profit in unit size, boiler type, pulverized coal preparation system model, debugging area and debug evaluation work that is pre-, budgetary estimate, for the offer by tender debugging unit provides accurate reference.
Background technology
Power construction engineering quota of budget debugging part is the Main Basis providing project quoted price in debugging enterprise tendering process, also be specification debugging market, prevent malice the important of competitive bidding from relying on, due in each debugging engineering, unit capacity is different, type is different, from different places, working range is different, debugging budget also has very big-difference, using the debugging of galley quota to carry out calculating will be a very loaded down with trivial details job, after 2013 editions debugging quotas are published, for convenience of debugging enterprise offer by tender, save computing time, reduce working strength, work out this cover debugging quota calculation system, " power construction engineering quota of budget " (version the 4th in 2013 that it is published with China Electric Power Publishing House, five debugging parts) based on content, quota is calculated in the debugging pre-(generally) calculating a particular rack exactly, greatly facilitate the offer by tender work of debugging enterprise.
Summary of the invention
The present invention is directed to problems of the prior art, provide a kind of fired power generating unit debugging quota budget Automatic computing system.Its objective is the debugging quota budget in order to calculate specific fired power generating unit fast, increasing work efficiency, for the Public Bidding Work debugging enterprise provides foundation, prevent malice low bidding prices.
For solving above-mentioned problems of the prior art, the present invention is achieved in the following ways:
Fired power generating unit debugging quota budget Automatic computing system, comprises following components:
(1) subsystem debugging quota calculation part: comprise boiler subsystem, steam turbine subsystem, electrically subsystem, thermal control subsystem, chemical subsystem, attached subsystem totally 6 parts;
(2) a whole set of Start-up and Adjustment quota calculation part: comprise boiler the whole series, a whole set of, the electric the whole series of steam turbine, thermal control is a whole set of, chemistry is a whole set of, desulfurization is a whole set of and a whole set of totally 7 parts of denitration;
(3) integrated data part: to subsystem part and a whole set of Data induction partly;
(4) parameter definitional part: the characterisitic parameter of particular rack is defined, comprise unit capacity, type, location, adjustment method, debugging material, the local tax rate, Expect Profits rate be equal to the relevant parameter of debugging quota, so that the carrying out of the evaluation work of system;
(5) quota of budget part: based on raw data, premised on defined parameters, accurately calculates and shows particular rack debugging quota budget value;
(6) declaratives: the use of this computing system and parameter are described.
Described subsystem debugging quota calculation part: comprise flat cost, overhead cost, profit, tax and other fees; Direct cost comprises direct construction cost and measure expense; Direct construction cost comprises: labour cost, fee of material and mechanical expense; Measure expense comprises: debug rainy season in winter and increase expense, arduous area debugging increase expense etc. and night shift premium, safety construction expense; Overhead cost comprises: social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, cooperation monomer test run expense; Other expenditure comprises: acceptance of the bid service guiding principle, deferred compensation expense and technical training expense.
Described parameter definitional part: be whole correlation parameters that definition calculates unit in " parameter definition " interface, comprise boiler type, pulverized coal preparation system type, debugging efforts location parameter; After parameter has defined, carry out the calculating of fired power generating unit debugging quota, each subsystem and each whole system are debugged quota and are added up to, and obtain adding up to labour cost, fee of material, mechanical expense; Finally debugging quota reference value is shown by the result obtained after calculating in " quota of budget " interface of quota of budget part.
Described subsystem debugging quota calculation part concrete operation step is as follows:
(1) raw data typing: comprise general data typing and non-generic data inputting;
General data typing: the quota of budget value of the different unit capacities in 2013 editions debugging quotas, different debug-item is input in Microsoft Excel; Subsystem debugging quota calculation part: comprise direct cost, indirect expense, profit and tax and other cost components, direct cost comprises again direct construction cost and measure expense two parts, direct construction cost directly provides according to unit capacity, debug-item by published quota, each project comprises labour cost, fee of material and machinery expense three subitems, needs these data to be entered in EXCEL electrical form one by one;
Non-generic data inputting: to the quota project separately having programming project, then need to use the look-up-table function typing in EXCEL;
(2) to the selection of sub-project;
Newly-built fired power generating unit configuring condition is had nothing in common with each other, so user should have the right to choose to project in computing system; A check box is configured with before each project, the budget comprising this sub-item in the debugging of this new-built unit is represented when check box is in selected state, the title of this project becomes runic, otherwise represent and do not comprise this sub-project, its title becomes normal font, the selection of this check box is carried out according to the actual conditions of new-built unit by user, is beneficial to calculating more flexibly of debugging quota; As for common pulverized coal firing boiler, " debugging of recirculating fluidized bed subsystem " the front check box in boiler subsystem debug-item should be deleted, and represents not comprise this subitem content in whole budget calculates;
For realizing this selection function, adopt the check box function in EXCEL control toolbox, first in design point, a check box is placed in A row corresponding unit lattice before each sub-item, then in VBA state, define respectively the state of choosing of this check box and non-state of choosing, choose during check box and complete two actions, one is be 1 by the K1 parameter assignment of colleague; Two is represent that the cell of this sub-project title becomes runic by colleague;
(3) to the correction of sub-project;
In 2013 editions debugging quotas, the difference according to newly-built fired power generating unit configures, and needs to revise the quota of some subitem;
(4) generation of quota of budget;
Unit total debugging pre-at last by flat cost, overhead cost, profit and other fees four part form; Flat cost comprises direct construction cost and measure expense, and direct construction cost is exactly artificial, material in quota and machinery expenses; Measure expense refer to arduous debugging enironment to debugging labour cost extra increase, as rainy season in winter debugging increase take, arduous area debugging increase take etc.; Computing formula is: labour cost x measure rate; Measure rate comprises 7 projects; Rate is increased for debugging in rainy season in winter, in quota, this rate is a two-dimensional function, both relevant with location, also relevant with machine set type, user selects unit location and machine set type in parameter definition list, and this selection will be presented at the top that debugging in rainy season in winter increases expense rate form, and the area that system inputs according to user and machine set type select suitable rate automatically; This process has also been come by look-up-table function, and the area that user inputs is placed on first row, as being looked into item, using the column selection item of machine set type as inquiry;
Overhead cost in quota comprises the projects such as social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, enterprise administration expense, and the formula of employing is: labour cost x overhead cost rate.Computing system gets expense scope for these expenses of getting define one, as social insurance premiums, get expense scope between 31.5% ~ 35%, user can be autonomous the rate of input selection, but rate must within the scope of this, otherwise system does not accept the data of user's input, and provides prompting of transfiniting, until user inputs rational numeral; To the other rate in computing system, as enterprise administration expense, rate of profit and the tax rate, although there is clear stipulaties in country, but user can select discount factor according to own situation in a rational scope, as rate of profit, national regulation is 7%, but discount rate can be chosen as the number between 0.8 ~ 1.2 by user, reasonably adjusts within the scope of this to rate of profit.After doing full selection, in " quota of budget " table, directly show the definitive estimate quota of certain capacity unit, the debugging quotation of this quota to debugging enterprise has important references meaning.
The present invention has following characteristics:
(1) based on power construction engineering quota of budget (version in 2013 the 5th debugging part), data complete calculating;
(2) definition of relevant parameters is completed with alternative means;
(3) to participating in computational item, there is the function selected according to actual conditions;
(4) report an error to selecting the parameter of mistake to have and reject function.
Advantage of the present invention and beneficial effect are: the debugging quota budget that can calculate specific fired power generating unit fast, increase work efficiency, and for the Public Bidding Work debugging enterprise provides foundation, prevent malice low bidding prices.
Below in conjunction with the drawings and specific embodiments, the present invention is further detailed explanation.
Accompanying drawing explanation
Fig. 1 is the pie graph of fired power generating unit debugging quota budget system;
Fig. 2 is fired power generating unit debugging quota budget system flowchart;
Fig. 3 is fired power generating unit debugging quota budget system reference value display page figure.
Embodiment
The present invention is a kind of fired power generating unit debugging quota budget Automatic computing system, is the Automatic computing system that a set of fired power generating unit debugging quota pre-(generally) developed on the basis of EXCEL electrical form calculates quota.The present invention is the debugging quota calculation system based on power construction engineering quota of budget (version in 2013 fourth, fifth debugging part), this system by the definition to correlation parameter, can calculate the debugging quota of budget of the domestic fired power generating unit arbitrarily of the People's Republic of China (PRC) exactly.
Fired power generating unit debugging quota budget System's composition figure of the present invention, as shown in Figure 1.Comprise flat cost, overhead cost, profit and other fees.
Direct cost comprises direct construction cost and measure expense, three subitems wherein forming direct construction cost are: labour cost, fee of material and mechanical expense, these three subitems are different along with the structure of unit and the difference of capacity, give and clearly define in power construction engineering quota of budget (version in 2013 the 5th debugging part); The adjustment that other such as measure expense, overhead cost, profit and other fees are all difference according to unit capacity, set structure, debugging area etc. and carry out on basic labour cost basis, regulation rule gives clear stipulaties in power construction engineering quota of budget (version in 2013 the 4th debugging part).Measure expense comprises: debug rainy season in winter and increase expense, arduous area debugging increase expense etc. and night shift premium, safety construction expense.
Overhead cost comprises: the enterprise administration expenses such as social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, cooperation monomer test run expense.
Other expenditure comprises: acceptance of the bid service guiding principle, deferred compensation expense and technical training expense.
Fired power generating unit debugging quota budget system flowchart of the present invention, as shown in Figure 2.In user Ying Xian " parameter definition " interface definition calculate whole correlation parameters of unit, comprise thirties parameters such as boiler type, pulverized coal preparation system type, debugging efforts location, after parameter has defined, the order shown according to Fig. 2 is carried out the calculating of fired power generating unit debugging quota by native system, and in " quota of budget " interface, debugging quota reference value is shown in A row, as shown in Figure 3.
One, present system comprises following components:
1, subsystem debugging quota calculation part: comprise boiler subsystem, steam turbine subsystem, electrically subsystem, thermal control subsystem, chemical subsystem, attached subsystem totally 6 parts.
2, a whole set of Start-up and Adjustment quota calculation part: comprise boiler the whole series, a whole set of, the electric the whole series of steam turbine, thermal control is a whole set of, chemistry is a whole set of, desulfurization is a whole set of and a whole set of totally 7 parts of denitration.
3, integrated data part: to subsystem part and a whole set of Data induction partly.
4, parameter definitional part: the characterisitic parameter of particular rack is defined, comprise unit capacity, type, location, adjustment method, debugging material, the local tax rate, Expect Profits rate be equal to the relevant parameter of debugging quota, so that the carrying out of the evaluation work of system.
5, quota of budget part: based on raw data, premised on defined parameters, accurately calculates and shows particular rack debugging quota budget value.
6, declaratives: the use of this computing system and parameter are described.
Two, concrete operation step of the present invention is as follows.
1, raw data typing.
(1) general data typing.
The work working out of this form most important, the most loaded down with trivial details is data inputting, the quota of budget value of the different unit capacities in 2013 editions debugging quotas, different debug-item is input in Microsoft Excel exactly.Fired power generating unit debugging quota comprises several parts such as direct cost, indirect expense, profit and tax, direct cost comprises again direct construction cost and measure expense two parts, direct construction cost directly provides according to unit capacity, debug-item by published quota, each project comprises labour cost, fee of material and machinery expense three subitems, needs these data to be entered into one by one in EXCEL electrical form.In 13 editions quotas, most debugging budget all divides according to unit capacity, and such data can directly be recorded in form.As the data of " the electric subsystem rating form " in table 1 one, be exactly complete from 13 editions quotas, take passages typing.
(2) non-generic data inputting.
To the quota project separately having programming project, then need to use the look-up-table function typing in EXCEL.As " auxiliary Power switching system debug " in table 1, divide quota according to electric pressure in 13 editions quotas, its original table is in table 2.As can be seen from Table 2, auxiliary Power switching system debug quota is not division unit with unit capacity, but take electric pressure as unit, and in this computing system, all data are all division unit with unit capacity, need according to the actual disposition situation of unit, data are put into unit capacity be division unit form in go.This will use the look-up-table function of electrical form, and for " auxiliary Power switching system debug ", user selects the electric pressure of this system in " parameter definition " table according to unit actual conditions, then use look-up-table function to determine concrete debugging quota.
As can be seen from Table 2, for auxiliary Power switching system, user can only select in " 400V " and " below 10KV " two options, for this situation having fixing candidate options, drop-down menu formula alternative forms is have employed, as the voltage in " auxiliary Power switching system-level and tricks are selected " in table 3 is selected in computing system." sequence " function in EXCEL electrical form under " data " menu in " validity " submenu, can complete this function well.Candidate item is filled in derived data district, connects with ", " of English state between item and item, then there will be the candidate's function in figure below.
In table 3, to auxiliary Power switching system, user makes a selection between " 400V " or " below 10KV ", and the cell arranged " parameter 1 " of colleague is carried out assignment by this selection, during selection " 400V ", assignment is " 1 ", and during selection " below 10KV ", assignment is " 2 ".System is provided with such table, in table 4 at " electric subsystem " table.
System will use look-up-table function, according to the electric pressure that user selects, search respectively, and be filled in table 1 quota options such as corresponding artificial, material, machinery, totals.For the labour cost of 50MW unit, its look-up-table function is:
(parameter defines=VLOOKUP! $ B $ 17, $ AG $ 23:$ AK $ 26,2,0)
Parameter defines wherein! The electric pressure that $ B $ 17 representative of consumer is selected, " 1 " representative " 400V "; " 2 " representative " below 10KV "
$ AG 23:$ AK 26 represents the address realm of " under different brackets station service switched system rating form ";
2 represent the data will searching secondary series;
0 represents and will accurately search.
Content after searching is as table 1: shown in the auxiliary Power switching system electrically in subsystem, and the row data are different by the selection difference according to user, but the unit of different capabilities is all identical.
2, to the selection of sub-project.
Newly-built fired power generating unit configuring condition is had nothing in common with each other, so user should have the right to choose to project in computing system.As shown in table 1, a check box is configured with before each project, the budget comprising this sub-item in the debugging of this new-built unit is represented when check box is in selected state, the title of this project becomes runic, otherwise represent and do not comprise this sub-project, its title becomes normal font, and the selection of this check box is carried out according to the actual conditions of new-built unit by user, is beneficial to calculating more flexibly of debugging quota.As for common pulverized coal firing boiler, " debugging of recirculating fluidized bed subsystem " the front check box in boiler subsystem debug-item should be deleted, and represents not comprise this subitem content in whole budget calculates.
For realizing this selection function, be check box function in EXCEL control toolbox, first in design point, a check box is placed in A row corresponding unit lattice before each sub-item, then in VBA state, define respectively the state of choosing of this check box and non-state of choosing, choose during check box and complete two actions, one is be 1 by the K1 parameter assignment of colleague; Two is represent that the cell of this sub-project title becomes runic by colleague, as shown in table 1.During removing check box, action is contrary, and respective cells assignment is 0 and removes the runic state of title.
In VBA, drive the program of this check box as follows:
Private Sub CheckBox1_Click()
If CheckBox1Then
Range("b3").Value＝1
Range("e3").Font.Bold＝True
Else
Range("b3").Value＝0
Range("e3").Font.Bold＝False
End If
End Sub
3, to the correction of sub-project.
In 2013 editions debugging quotas, the difference according to newly-built fired power generating unit configures, and needs to revise the quota of some subitem.As " generator synchronous system debug " in table 1 " electric subsystem rating form ", 13 editions debugging quotas electrically subsystems illustrate in work load evaluation and specify: " generator synchronous system debug by one the same period point consider; if two and when putting the above same period; often increase by the some same period, increases the quota of 0.2 times ".For meeting the correction needs of these subitems, adding a coefficient correction K2 in this quota calculation system and arranging.Correction factor is quoted in being shown by " parameter definition ".
4, the generation of quota of budget.
Unit total debugging pre-at last by flat cost, overhead cost, profit and other fees four part form.Flat cost comprises direct construction cost and measure expense, and direct construction cost is exactly artificial, material in quota and machinery expenses.Measure expense refer to arduous debugging enironment to debugging labour cost extra increase, as rainy season in winter debugging increase take, arduous area debugging increase take etc.Computing formula is: labour cost x measure rate.Measure rate comprises 7 projects.Rate is increased for debugging in rainy season in winter, in quota, this rate is a two-dimensional function, both relevant with location, also relevant with machine set type, user selects unit location and machine set type in parameter definition list, and this selection will be presented at the top that debugging in rainy season in winter increases expense rate form, and the area that system inputs according to user and machine set type select suitable rate automatically.This process has also been come by look-up-table function, and the area that user inputs is placed on first row, as being looked into item, using the column selection item of machine set type as inquiry.As shown in " rainy season in winter increases rate " in Fig. 3 one row.
Overhead cost in quota comprises the projects such as social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, enterprise administration expense, and the formula of employing is: labour cost x overhead cost rate.Computing system gets expense scope for these expenses of getting define one, as social insurance premiums, get expense scope between 31.5% ~ 35%, user can be autonomous the rate of input selection, but rate must within the scope of this, otherwise system does not accept the data of user's input, and provides prompting of transfiniting, until user inputs rational numeral.To the other rate in computing system, as enterprise administration expense, rate of profit and the tax rate, although there is clear stipulaties in country, but user can select discount factor according to own situation in a rational scope, as rate of profit, national regulation is 7%, but discount rate can be chosen as the number between 0.8 ~ 1.2 by user, reasonably adjusts within the scope of this to rate of profit.After doing full selection, in " quota of budget " table, directly show the definitive estimate quota of certain capacity unit, the debugging quotation of this quota to debugging enterprise has important references meaning.
Table 1: electrically subsystem rating form
Table 2. auxiliary Power switching system debug quota original table
Table 3 is subsystem parameter selection menu electrically
Station service switched system rating form under table 4 different brackets
Table 5. construction during rainy and winter season rate increases table
Claims (4)
1. fired power generating unit debugging quota budget Automatic computing system, is characterized in that: comprise following components:
(1) subsystem debugging quota calculation part: comprise boiler subsystem, steam turbine subsystem, electrically subsystem, thermal control subsystem, chemical subsystem, attached subsystem totally 6 parts;
(2) a whole set of Start-up and Adjustment quota calculation part: comprise boiler the whole series, a whole set of, the electric the whole series of steam turbine, thermal control is a whole set of, chemistry is a whole set of, desulfurization is a whole set of and a whole set of totally 7 parts of denitration;
(3) integrated data part: to subsystem part and a whole set of Data induction partly;
(4) parameter definitional part: the characterisitic parameter of particular rack is defined, comprise unit capacity, type, location, adjustment method, debugging material, the local tax rate, Expect Profits rate be equal to the relevant parameter of debugging quota, so that the carrying out of the evaluation work of system;
(5) quota of budget part: based on raw data, premised on defined parameters, accurately calculates and shows particular rack debugging quota budget value;
(6) declaratives: the use of this computing system and parameter are described.
2. fired power generating unit debugging quota budget Automatic computing system according to claim 1, is characterized in that: described subsystem debugging quota calculation part: comprise flat cost, overhead cost, profit, tax and other fees;
Direct cost comprises direct construction cost and measure expense; Direct construction cost comprises: labour cost, fee of material and mechanical expense; Measure expense comprises: debug rainy season in winter and increase expense, arduous area debugging increase expense etc. and night shift premium, safety construction expense;
Overhead cost comprises: social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, cooperation monomer test run expense;
Other expenditure comprises: acceptance of the bid service guiding principle, deferred compensation expense and technical training expense.
3. fired power generating unit debugging quota budget Automatic computing system according to claim 1, it is characterized in that: described parameter definitional part: be whole correlation parameters that definition calculates unit in " parameter definition " interface, comprise boiler type, pulverized coal preparation system type, debugging efforts location parameter; After parameter has defined, carry out the calculating of fired power generating unit debugging quota, each subsystem and each whole system are debugged quota and are added up to, and obtain adding up to labour cost, fee of material, mechanical expense;
Finally debugging quota reference value is shown by the result obtained after calculating in " quota of budget " interface of quota of budget part.
4. fired power generating unit debugging quota budget Automatic computing system according to claim 1, is characterized in that: described subsystem debugging quota calculation part concrete operation step is as follows:
(1) raw data typing: comprise general data typing and non-generic data inputting;
General data typing: the quota of budget value of the different unit capacities in 2013 editions debugging quotas, different debug-item is input in Microsoft Excel; Subsystem debugging quota calculation part: comprise direct cost, indirect expense, profit and tax and other cost components, direct cost comprises again direct construction cost and measure expense two parts, direct construction cost directly provides according to unit capacity, debug-item by published quota, each project comprises labour cost, fee of material and machinery expense three subitems, needs these data to be entered in EXCEL electrical form one by one;
Non-generic data inputting: to the quota project separately having programming project, then need to use the look-up-table function typing in EXCEL;
(2) to the selection of sub-project;
Newly-built fired power generating unit configuring condition is had nothing in common with each other, so user should have the right to choose to project in computing system; A check box is configured with before each project, the budget comprising this sub-item in the debugging of this new-built unit is represented when check box is in selected state, the title of this project becomes runic, otherwise represent and do not comprise this sub-project, its title becomes normal font, the selection of this check box is carried out according to the actual conditions of new-built unit by user, is beneficial to calculating more flexibly of debugging quota; As for common pulverized coal firing boiler, " debugging of recirculating fluidized bed subsystem " the front check box in boiler subsystem debug-item should be deleted, and represents not comprise this subitem content in whole budget calculates;
For realizing this selection function, adopt the check box function in EXCEL control toolbox, first in design point, a check box is placed in A row corresponding unit lattice before each sub-item, then in VBA state, define respectively the state of choosing of this check box and non-state of choosing, choose during check box and complete two actions, one is be 1 by the K1 parameter assignment of colleague; Two is represent that the cell of this sub-project title becomes runic by colleague;
(3) to the correction of sub-project;
In 2013 editions debugging quotas, the difference according to newly-built fired power generating unit configures, and needs to revise the quota of some subitem;
(4) generation of quota of budget;
Unit total debugging pre-at last by flat cost, overhead cost, profit and other fees four part form; Flat cost comprises direct construction cost and measure expense, and direct construction cost is exactly artificial, material in quota and machinery expenses; Measure expense refer to arduous debugging enironment to debugging labour cost extra increase, as rainy season in winter debugging increase take, arduous area debugging increase take etc.; Computing formula is: labour cost x measure rate; Measure rate comprises 7 projects; Rate is increased for debugging in rainy season in winter, in quota, this rate is a two-dimensional function, both relevant with location, also relevant with machine set type, user selects unit location and machine set type in parameter definition list, and this selection will be presented at the top that debugging in rainy season in winter increases expense rate form, and the area that system inputs according to user and machine set type select suitable rate automatically; This process has also been come by look-up-table function, and the area that user inputs is placed on first row, as being looked into item, using the column selection item of machine set type as inquiry;
Overhead cost in quota comprises the projects such as social insurance premiums, public accumalation fund for housing construction, accident/injury insurance, enterprise administration expense, and the formula of employing is: labour cost x overhead cost rate; Computing system gets expense scope for these expenses of getting define one, as social insurance premiums, get expense scope between 31.5% ~ 35%, user can be autonomous the rate of input selection, but rate must within the scope of this, otherwise system does not accept the data of user's input, and provides prompting of transfiniting, until user inputs rational numeral; To the other rate in computing system, as enterprise administration expense, rate of profit and the tax rate, although there is clear stipulaties in country, but user can select discount factor according to own situation in a rational scope, as rate of profit, national regulation is 7%, but discount rate can be chosen as the number between 0.8 ~ 1.2 by user, reasonably adjusts within the scope of this to rate of profit; After doing full selection, in " quota of budget " table, directly show the definitive estimate quota of certain capacity unit, the debugging quotation of this quota to debugging enterprise has important references meaning.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410798647.3A CN104408585A (en) | 2014-12-18 | 2014-12-18 | Automatic calculation system for budget quota debugging of thermal power unit |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410798647.3A CN104408585A (en) | 2014-12-18 | 2014-12-18 | Automatic calculation system for budget quota debugging of thermal power unit |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104408585A true CN104408585A (en) | 2015-03-11 |
Family
ID=52646214
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410798647.3A Pending CN104408585A (en) | 2014-12-18 | 2014-12-18 | Automatic calculation system for budget quota debugging of thermal power unit |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104408585A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110223002A (en) * | 2019-06-19 | 2019-09-10 | 北京瑞驰菲思工程咨询有限责任公司 | Solar energy optical-thermal engineering budget ration management system |
| CN113469744A (en) * | 2021-07-05 | 2021-10-01 | 四川明星电力股份有限公司 | Modular budget method and system based on typical design of distribution network |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080127053A1 (en) * | 2006-09-07 | 2008-05-29 | Microsoft Corporation | Controlling application features |
| CN101639875A (en) * | 2009-08-28 | 2010-02-03 | 上海工程技术大学 | Power construction budget estimate planning method and networking system thereof |
| US20110153524A1 (en) * | 2009-12-23 | 2011-06-23 | AEA Integration | System and method for automated building services design |
| CN103136595A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | On-line management method for project budget generation by material and labor cost analysis |
| CN103778105A (en) * | 2014-01-27 | 2014-05-07 | 湖南工程职业技术学院 | Computing method for held-to-maturity investment on basis of Excel finance modeling |
-
2014
- 2014-12-18 CN CN201410798647.3A patent/CN104408585A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080127053A1 (en) * | 2006-09-07 | 2008-05-29 | Microsoft Corporation | Controlling application features |
| CN101639875A (en) * | 2009-08-28 | 2010-02-03 | 上海工程技术大学 | Power construction budget estimate planning method and networking system thereof |
| US20110153524A1 (en) * | 2009-12-23 | 2011-06-23 | AEA Integration | System and method for automated building services design |
| CN103136595A (en) * | 2011-11-29 | 2013-06-05 | 北京建龙重工集团有限公司 | On-line management method for project budget generation by material and labor cost analysis |
| CN103778105A (en) * | 2014-01-27 | 2014-05-07 | 湖南工程职业技术学院 | Computing method for held-to-maturity investment on basis of Excel finance modeling |
Non-Patent Citations (1)
| Title |
|---|
| 国家能源局: "《电力建设工程概算定额 第四册 调试工程》", 30 November 2013 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110223002A (en) * | 2019-06-19 | 2019-09-10 | 北京瑞驰菲思工程咨询有限责任公司 | Solar energy optical-thermal engineering budget ration management system |
| CN113469744A (en) * | 2021-07-05 | 2021-10-01 | 四川明星电力股份有限公司 | Modular budget method and system based on typical design of distribution network |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Schill et al. | Long-run power storage requirements for high shares of renewables: Results and sensitivities | |
| Loulou et al. | Documentation for the times model part ii | |
| Kavvadias et al. | The IAEA DEEP desalination economic model: a critical review | |
| Kelman et al. | Long-term hydro scheduling based on stochastic models | |
| Hobbs et al. | Improved transmission representations in oligopolistic market models: quadratic losses, phase shifters, and DC lines | |
| Morris et al. | Representing the costs of low-carbon power generation in multi-region multi-sector energy-economic models | |
| Losekann et al. | Efficient power generating portfolio in Brazil: Conciliating cost, emissions and risk | |
| CN110232583B (en) | Electric power market marginal price planning method considering carbon emission right | |
| CN104408585A (en) | Automatic calculation system for budget quota debugging of thermal power unit | |
| Dhakal et al. | Risk sharing in hydropower development: case study of the Chukha Hydel Project in Bhutan | |
| Zhang et al. | Consideration of ancillary services in Screening Curve Method | |
| López | MHOGA | |
| CN116308873A (en) | Carbon asset accounting method, system, equipment and medium for distributed photovoltaic power generation | |
| Guerra et al. | Data for the modelling of the future power system with a high share of variable renewable energy | |
| JP2018025982A (en) | Energy plant plan support device and energy plant plan support system | |
| Lund et al. | Advanced Energy Systems Analysis Computer Model Documentation Version 11.4 | |
| Jia et al. | An effective DP solution for optimal generation expansion planning under new environment | |
| Hidalgo González et al. | Dispa-SET 2.0: unit commitment and power dispatch model | |
| Lee | Simulation model explores alternative wholesale power market structures | |
| Ripp et al. | Modeling Time-dependent CO $ _2 $ Intensities in Multi-modal Energy Systems with Storage | |
| Brunner et al. | The impact of different flexibility options on future electricity spot prices in Germany | |
| Ringler et al. | A model-based analysis of generation adequacy in interconnected electricity markets | |
| Prakash et al. | Quantifying reserve capabilities for designing flexible electricity markets: An Australian case study with increasing penetrations of renewables | |
| Kim et al. | Consideration of a Combined Cycle Gas Turbine’s Operating Modes in Pricing Mechanisms: A Korean Electricity Market Study | |
| Costa et al. | Maximum profit cogeneration plant-MPCP: system modeling, optimization problem formulation, and solution |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150311 |
|
| RJ01 | Rejection of invention patent application after publication |