CN117236988B - Power transmission and transformation project cost calculation system and cost calculation method - Google Patents
Power transmission and transformation project cost calculation system and cost calculation method Download PDFInfo
- Publication number
- CN117236988B CN117236988B CN202311315777.2A CN202311315777A CN117236988B CN 117236988 B CN117236988 B CN 117236988B CN 202311315777 A CN202311315777 A CN 202311315777A CN 117236988 B CN117236988 B CN 117236988B
- Authority
- CN
- China
- Prior art keywords
- project
- fjzs
- data set
- supply
- historical
- 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
- 238000004364 calculation method Methods 0.000 title claims abstract description 75
- 230000005540 biological transmission Effects 0.000 title claims abstract description 26
- 230000009466 transformation Effects 0.000 title claims abstract description 26
- 238000013209 evaluation strategy Methods 0.000 claims abstract description 33
- 238000012545 processing Methods 0.000 claims abstract description 26
- 238000009434 installation Methods 0.000 claims description 27
- 238000011156 evaluation Methods 0.000 claims description 24
- 230000010365 information processing Effects 0.000 claims description 14
- 238000000034 method Methods 0.000 claims description 13
- 238000012937 correction Methods 0.000 claims description 9
- 230000009193 crawling Effects 0.000 claims description 6
- 239000000284 extract Substances 0.000 claims description 6
- 230000010354 integration Effects 0.000 claims description 6
- 238000012216 screening Methods 0.000 claims description 6
- 238000000605 extraction Methods 0.000 claims description 5
- 238000007726 management method Methods 0.000 claims description 5
- 230000008569 process Effects 0.000 claims description 4
- 230000002159 abnormal effect Effects 0.000 claims description 3
- 238000004140 cleaning Methods 0.000 claims description 3
- 230000002596 correlated effect Effects 0.000 claims description 3
- 238000010606 normalization Methods 0.000 claims description 3
- 230000000875 corresponding effect Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000012733 comparative method Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a power transmission and transformation project cost calculation system and a cost calculation method, and relates to the technical field of project cost. The additional indexes Fjzs are used for matching the control protection equipment, installing time length grades in real time, correlating the control protection equipment with the additional indexes Fjzs, comparing the control protection equipment with a preset threshold S and a preset threshold T, acquiring a grade evaluation strategy scheme, and finally processing the content of the grade evaluation strategy scheme to form a predicted additional cost fluctuation scheme for reference of project staff, improving the efficiency of project cost calculation, and calculating the influence of the fluctuation of the additional cost on project budget and progress.
Description
Technical Field
The invention relates to the technical field of engineering cost, in particular to a power transmission and transformation engineering cost calculation system and a cost calculation method.
Background
The power transmission and transformation project is an important component of an electric power system and is used for transmitting electric energy generated by a power plant to terminals of various purposes, in the complex project, the accuracy of ensuring cost estimation is important so as to effectively plan and manage resources, therefore, the project cost calculation in the power transmission and transformation project becomes a key link, and the control and protection project cost calculation in the power transmission and transformation project covers a plurality of factors including equipment, materials and labor force.
At present, the control and protection project cost calculation in the power transmission and transformation project depends on a manual or electronic form-based mode, and the traditional calculation mode has certain limitation that errors are easy to occur in manual calculation, a large amount of time and resources are consumed, unnecessary working complexity is caused, and the electronic form improves the calculation efficiency, but still faces the challenge that market risks and technical complexity factors cannot be comprehensively considered, and the limitation makes the original project cost calculation method unable to accurately estimate the fluctuation of additional cost, so that potential budget shortage and project risks are caused, and project implementation is influenced.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a power transmission and transformation project cost calculation system and a cost calculation method, and solves the problems in the background art.
In order to achieve the above purpose, the invention is realized by the following technical scheme: the system comprises an information collection module, an information processing module, a calculation module, an evaluation module and a decision module;
the information collection module acquires the bill of supply information and the historical sales and supply information of the control protection equipment through the Internet and a plurality of provider channels;
the information processing module classifies, cleans and normalizes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set;
the calculation module calculates the first data set and the second data set, and obtains: the additional index Fjzs;
the additional index Fjzs is obtained by the following formula:
wherein Ghxs represents a supply coefficient, lsxs represents a historical sales supply coefficient, and A and B represent weight values of the supply coefficient Ghxs and the historical sales supply coefficient Lsxs, respectively;
the supply coefficient Ghxs is obtained through calculation of the first data set;
the historical sales supply coefficient Lsxs is obtained through calculation of the second data set;
the evaluation module carries out matching on the control protection equipment to implement the installation time grade, and then carries out correlation with the additional index Fjzs, and further compares the additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
and the decision module forms a predicted additional cost fluctuation file for reference of project staff through the content of the grade evaluation strategy scheme, so that the project risk is reduced.
Preferably, the information collection module comprises an internet crawling unit and a channel acquisition unit;
the internet crawling unit collects historical bill information related to control and protection equipment from the internet through a web crawler program, and performs preliminary screening and processing on the collected data to delete repeated and invalid information and form network bill information;
the channel acquisition unit is communicated with a plurality of suppliers through establishing contact and cooperation relations, acquires the bill information and the historical sales bill information of the control and protection equipment, and performs preliminary screening and processing on electronic documents or data files provided by the suppliers, including a product catalog, a specification list and a price list, so as to form the bill information of the supplier channel.
Preferably, the information processing module comprises a supply processing unit and a history processing unit;
the goods supply processing unit performs data cleaning on goods supply list information in electronic documents or data files provided by suppliers, checks abnormal format items, missing items and inconsistent items in the data, performs normalization processing, normalizes the data provided by different suppliers to ensure consistency of unit, format and specification parameters, classifies control protection devices of different specifications to form control protection devices of N1, N2, N3 to Nx specifications, and forms a first data set by taking N1 as an example, wherein the data set format parameters of the control protection devices of the N1, N2, N3 to Nx specifications are the same;
the first data set includes: the equipment quantity value Sbsl, the equipment total value Sbzj, the delivery time length value JFsc and the transportation cost value Ysfy;
the history processing unit performs feature extraction on the history supply list information and the history sales supply information of a plurality of provider channels, which are collected on the internet, so as to obtain a parameter format which is the same as the data set format of the control protection equipment obtained by the supply processing unit, and form the history information of the control protection equipment with L1, L2, L3 to Lx specifications, taking L1 as an example, and form a second data set;
the second data set includes: a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery duration value Lsjf, and a historical shipping cost value Lsys.
Preferably, the calculation module comprises a supply calculation unit, a historical supply calculation unit and an integration unit;
the goods supply calculation unit calculates a first data set to obtain a goods supply coefficient Ghxs;
the historical goods supply calculation unit calculates a second data set to obtain a historical sales goods supply coefficient Lsxs;
the integration unit calculates the obtained supply coefficient Ghxs and the historical sales supply coefficient Lsxs to obtain an additional index Fjzs.
Preferably, the obtained supply coefficient Ghxs is obtained by the following formula:
wherein e, f, g and h respectively represent weight values of an equipment quantity value Sbsl, an equipment total value Sbzj, a delivery time length value JFsc and a transportation cost value Ysfy;
wherein,，/>，/>，and (2) is (are) of>J represents a correction constant;
preferably, the historical sales supply coefficient Lsxs is obtained by the following formula:
wherein k, m, n and p respectively represent weight values of a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery time length value Lsjf and a historical transportation cost value Lsys;
wherein,，/>，/>，/>and, in addition, the method comprises,q represents a correction constant;
preferably, the evaluation module comprises an implementation matching unit and a comparison unit;
the implementation matching unit is used for matching the installation time length proposed by the obtained installation manuals of the control protection equipment with different specifications with the implementation installation time length grade to obtain a matching grading value Pfz;
the comparison unit is used for correlating the matching score value duration Pfz with the additional index Fjzs, and then comparing the correlated additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
wherein the post-association additional index Fjzs is obtained by the following formula:
the value of the additional index Fjzs is changed by performing addition assignment on the additional index Fjzs and the matching score value duration Pfz and then forming the value after addition assignment into the additional index Fjzs.
Preferably, the rating evaluation strategy scheme is obtained by the following comparative method:
the additional index Fjzs is smaller than a preset threshold S, a first-level evaluation is obtained, and the fluctuation of the additional cost does not influence the implementation of project budget and project progress;
the preset threshold S is less than or equal to the additional index Fjzs is less than or equal to the preset threshold T, the second-level evaluation is obtained, the fluctuation of the additional cost affects project budget, the implementation of project progress is not affected, the project budget needs to be adjusted to a certain extent to adapt to new conditions, in order to keep high quality, high efficiency and timely completion of the project, and meanwhile, the changing cost factors are fully dealt with, so that the whole project goal is ensured to be realized;
the additional index Fjzs is greater than a preset threshold T, three-level evaluation is obtained, fluctuation of additional cost affects implementation of project budget and project progress, allocation and utilization of resources are required to be reevaluated in the face of cost fluctuation, and adjustment is made on the specification and the type of control safety equipment so as to reduce influence on project budget and progress, and reevaluation is performed on the adjusted additional cost fluctuation until no influence on project progress is achieved.
Preferably, the decision module comprises a document generation unit;
the document generation unit fills a preset additional cost fluctuation document template through the content of the level evaluation strategy scheme to form an estimated additional cost fluctuation document, and details the fluctuation condition of the additional cost, risk factors and countermeasures taken by a project management team are described through the document so as to be used for reference and decision by related personnel.
A power transmission and transformation project cost calculation method comprises the following steps: acquiring the bill information and the historical sales and supply information of the control and protection equipment through an information collection module;
step two: the information processing module processes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set;
step three: calculating the first data set and the second data set through a calculation module to obtain an additional index Fjzs;
step four: matching the class of the implementation installation time length through an evaluation module, associating with the additional index Fjzs, and comparing with a preset threshold S and a preset threshold T to obtain a class evaluation strategy scheme;
step five: and filling a preset template by a decision module according to the content of the grade evaluation strategy scheme to form a predicted additional cost fluctuation document.
The invention provides a power transmission and transformation project cost calculation system and a cost calculation method, which have the following beneficial effects:
(1) When the system operates, the information collection module is used for acquiring the bill of supply information and the historical sales and supply information of the control protection equipment, the information processing module is used for processing the bill of supply information to form a first data set, the historical sales and supply information is used for carrying out feature extraction to form a second data set, and the calculation module is used for calculating the first data set and the second data set to acquire: the control protection equipment is matched with the real-time installation duration grade through the evaluation module, the control protection equipment is associated with the additional index Fjzs, the control protection equipment is further compared with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme, finally the content of the grade evaluation strategy scheme is processed through the decision module to form an estimated additional cost fluctuation scheme for reference of project staff, the efficiency of project cost calculation is improved, the influence of fluctuation of the additional cost on project budget and progress is calculated, the project staff can know the potential risk of the project as early as possible, and corresponding measures are taken in advance to ensure the controllability of the project in terms of cost and progress.
(2) Through the contents of the multiple level evaluation strategy schemes, the influences of market risks and technical complexity on project budget and progress are comprehensively calculated, a project management team is helped to more accurately understand potential risk factors, and corresponding measures are taken according to the contents of the level evaluation strategy schemes so as to reduce negative influences caused by uncertainty to the greatest extent.
(3) In the method, through the first to fifth steps, the inventory information and the historical sales supply information of the control protection equipment are collected, processed and feature extracted to form a first data set and a second data set, calculation is carried out to obtain an additional index Fjzs, the additional index Fjzs is associated with the matched implementation installation duration grade, the additional index Fjzs is further subjected to comparison with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme, and finally, the preset template is filled to obtain a predicted additional cost fluctuation scheme, so that the accuracy of engineering cost calculation is improved, whether project budget and project progress can be influenced is predicted, and adjustment is timely carried out.
Drawings
FIG. 1 is a block diagram and schematic diagram of a power transmission and transformation project cost calculation system;
FIG. 2 is a flow chart of steps of a method for calculating the cost of a power transmission and transformation project according to the present invention;
Detailed Description
The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, but not all embodiments, and all other embodiments obtained by those skilled in the art without making any inventive effort based on the embodiments of the present invention are within the scope of protection of the present invention.
The power transmission and transformation project is an important component of an electric power system and is used for transmitting electric energy generated by a power plant to terminals of various purposes, in the complex project, the accuracy of ensuring cost estimation is important so as to effectively plan and manage resources, therefore, the project cost calculation in the power transmission and transformation project becomes a key link, and the control and protection project cost calculation in the power transmission and transformation project covers a plurality of factors including equipment, materials and labor force.
At present, the control and protection project cost calculation in the power transmission and transformation project depends on a manual or electronic form-based mode, and the traditional calculation mode has certain limitation that errors are easy to occur in manual calculation, a large amount of time and resources are consumed, unnecessary working complexity is caused, and the electronic form improves the calculation efficiency, but still faces the challenge that market risks and technical complexity factors cannot be comprehensively considered, and the limitation makes the original project cost calculation method unable to accurately estimate the fluctuation of additional cost, so that potential budget shortage and project risks are caused, and project implementation is influenced.
Examples
The invention provides a power transmission and transformation project cost calculation system, referring to fig. 1, an information collection module, an information processing module, a calculation module, an evaluation module and a decision module;
the information collection module acquires the bill of supply information and the historical sales and supply information of the control protection equipment through the Internet and a plurality of provider channels;
the information processing module classifies, cleans and normalizes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set;
the calculation module calculates the first data set and the second data set, and obtains: the additional index Fjzs;
the additional index Fjzs is obtained by the following formula:
wherein Ghxs represents a supply coefficient, lsxs represents a historical sales supply coefficient, and A and B represent weight values of the supply coefficient Ghxs and the historical sales supply coefficient Lsxs, respectively;
wherein,，/>and (2) is (are) of>；
The supply coefficient Ghxs is obtained through calculation of the first data set;
the historical sales supply coefficient Lsxs is obtained through calculation of the second data set;
the evaluation module carries out matching on the control protection equipment to implement the installation time grade, and then carries out correlation with the additional index Fjzs, and further compares the additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
and the decision module forms a predicted additional cost fluctuation file for reference of project staff through the content of the grade evaluation strategy scheme, so that the project risk is reduced.
In this embodiment, the information collecting module obtains the supply list information and the historical sales supply information of the control protection device, the information processing module processes the supply list information to form a first data set, the historical sales supply information is subjected to feature extraction to form a second data set, and the computing module computes the first data set and the second data set to obtain: the control protection equipment is matched with the real-time installation duration grade through the evaluation module, the control protection equipment is associated with the additional index Fjzs, the control protection equipment is further compared with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme, finally the content of the grade evaluation strategy scheme is processed through the decision module to form an estimated additional cost fluctuation scheme for reference of project staff, the efficiency of project cost calculation is improved, the influence of fluctuation of the additional cost on project budget and progress is calculated, the project staff can know the potential risk of the project as early as possible, and corresponding measures are taken in advance to ensure the controllability of the project in terms of cost and progress.
Examples
This embodiment is explained in embodiment 1, please refer to fig. 1, specifically: the information collection module comprises an Internet crawling unit and a channel acquisition unit;
the internet crawling unit collects historical bill information related to control and protection equipment from the internet through a web crawler program, and performs preliminary screening and processing on the collected data to delete repeated and invalid information and form network bill information;
the web crawler program is a computer program or script and is specially used for automatically browsing web pages on the Internet, capturing information and analyzing web page contents, so that historical bill information related to control and protection equipment is collected from the Internet, and the web crawler program comprises a plurality of websites, databases or online resources which are accessed to acquire required data;
the channel acquisition unit is communicated with a plurality of suppliers through establishing contact and cooperation relations, acquires the bill information and the historical sales bill information of the control and protection equipment, and performs preliminary screening and processing on electronic documents or data files provided by the suppliers, including a product catalog, a specification list and a price list, so as to form the bill information of the supplier channel.
The information processing module comprises a supply processing unit and a history processing unit;
the goods supply processing unit performs data cleaning on goods supply list information in electronic documents or data files provided by suppliers, checks abnormal format items, missing items and inconsistent items in the data, performs normalization processing, normalizes the data provided by different suppliers to ensure consistency of unit, format and specification parameters, classifies control protection devices of different specifications to form control protection devices of N1, N2, N3 to Nx specifications, and forms a first data set by taking N1 as an example, wherein the data set format parameters of the control protection devices of the N1, N2, N3 to Nx specifications are the same;
the first data set includes: the equipment quantity value Sbsl, the equipment total value Sbzj, the delivery time length value JFsc and the transportation cost value Ysfy;
the history processing unit performs feature extraction on the history supply list information and the history sales supply information of a plurality of provider channels, which are collected on the internet, so as to obtain a parameter format which is the same as the data set format of the control protection equipment obtained by the supply processing unit, and form the history information of the control protection equipment with L1, L2, L3 to Lx specifications, taking L1 as an example, and form a second data set;
the second data set includes: a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery duration value Lsjf, and a historical shipping cost value Lsys.
The calculation module comprises a supply calculation unit, a historical supply calculation unit and an integration unit;
the goods supply calculation unit calculates a first data set to obtain a goods supply coefficient Ghxs;
the historical goods supply calculation unit calculates a second data set to obtain a historical sales goods supply coefficient Lsxs;
the integration unit calculates the obtained supply coefficient Ghxs and the historical sales supply coefficient Lsxs to obtain an additional index Fjzs.
Examples
This embodiment is explained in embodiment 1, please refer to fig. 1, specifically: the obtained supply coefficient Ghxs is obtained by the following formula:
wherein e, f, g and h respectively represent weight values of an equipment quantity value Sbsl, an equipment total value Sbzj, a delivery time length value JFsc and a transportation cost value Ysfy;
wherein,，/>，/>，and (2) is (are) of>J represents a correction constant;
the historical sales supply coefficient Lsxs is obtained by the following formula:
wherein k, m, n and p respectively represent weight values of a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery time length value Lsjf and a historical transportation cost value Lsys;
wherein,，/>，/>，/>and, in addition, the method comprises,q represents a correction constant;
the evaluation module comprises an implementation matching unit and a comparison unit;
the implementation matching unit is used for matching the installation time length proposed by the obtained installation manuals of the control protection equipment with different specifications with the implementation installation time length grade to obtain a matching grading value Pfz;
the comparison unit is used for correlating the matching score value duration Pfz with the additional index Fjzs, and then comparing the correlated additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
wherein the post-association additional index Fjzs is obtained by the following formula:
the value of the additional index Fjzs is changed by carrying out addition assignment on the additional index Fjzs and the matching score value duration Pfz and then forming the value after addition assignment into the additional index Fjzs;
the addition assignment is used to add two numbers and assign the result to a variable to change the value of the variable;
implementation of the installation duration grade: the first-level corresponding grade grading value is 3, the installation is completed within three days, the second-level corresponding grade grading value is 5, the installation is performed within five days, the third-level corresponding grade grading value is 8, the installation is completed within eight days, the fourth-level corresponding grade grading value is 12, and the installation is completed over eight days;
and matching the estimated installation time length of the control protection equipment with the class of the implementation installation time length in the installation manual of the control protection equipment to obtain the grading value of the corresponding class, and forming the matching grading value duration Pfz.
Examples
This embodiment is explained in embodiment 1, please refer to fig. 1, specifically: the grade evaluation strategy scheme is obtained by the following comparison mode:
the additional index Fjzs is smaller than a preset threshold S, a first-level evaluation is obtained, and the fluctuation of the additional cost does not influence the implementation of project budget and project progress;
the preset threshold S is less than or equal to the additional index Fjzs is less than or equal to the preset threshold T, the second-level evaluation is obtained, the fluctuation of the additional cost affects project budget, the implementation of project progress is not affected, the project budget needs to be adjusted to a certain extent to adapt to new conditions, in order to keep high quality, high efficiency and timely completion of the project, and meanwhile, the changing cost factors are fully dealt with, so that the whole project goal is ensured to be realized;
the additional index Fjzs is greater than a preset threshold T, three-level evaluation is obtained, fluctuation of additional cost affects implementation of project budget and project progress, allocation and utilization of resources are required to be reevaluated in the face of cost fluctuation, and adjustment is made on the specification and the type of control safety equipment so as to reduce influence on project budget and progress, and reevaluation is performed on the adjusted additional cost fluctuation until no influence on project progress is achieved.
The decision module comprises a document generation unit;
the document generation unit fills a preset additional cost fluctuation document template through the content of the level evaluation strategy scheme to form an estimated additional cost fluctuation document, and details the fluctuation condition of the additional cost, risk factors and countermeasures taken by a project management team are described through the document so as to be used for reference and decision by related personnel.
In this embodiment, the influence of market risk and technical complexity on project budget and progress is comprehensively calculated through the contents of the multiple level evaluation strategy schemes, so that project management teams can more accurately understand potential risk factors, and corresponding measures can be taken according to the contents of the level evaluation strategy schemes, so that negative influence caused by uncertainty is reduced to the greatest extent.
Examples
Referring to fig. 2, a method for calculating the cost of power transmission and transformation projects is specifically shown as follows: the method comprises the following steps:
step one: acquiring the bill information and the historical sales and supply information of the control and protection equipment through an information collection module;
step two: the information processing module processes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set;
step three: calculating the first data set and the second data set through a calculation module to obtain an additional index Fjzs;
step four: matching the class of the implementation installation time length through an evaluation module, associating with the additional index Fjzs, and comparing with a preset threshold S and a preset threshold T to obtain a class evaluation strategy scheme;
step five: and filling a preset template by a decision module according to the content of the grade evaluation strategy scheme to form a predicted additional cost fluctuation document.
In the method, through the first to fifth steps, the inventory information and the historical sales supply information of the control protection equipment are collected, processed and feature extracted to form a first data set and a second data set, calculation is carried out to obtain an additional index Fjzs, the additional index Fjzs is associated with the matched implementation installation duration grade, the additional index Fjzs is further subjected to comparison with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme, and finally, the preset template is filled to obtain a predicted additional cost fluctuation scheme, so that the accuracy of engineering cost calculation is improved, whether project budget and project progress can be influenced is predicted, and adjustment is timely carried out.
Specific examples: a power transmission and transformation project cost computing system for a building company will use specific parameters and values to demonstrate how to compute: the additional index Fjzs, the supply coefficient Ghxs and the historical sales supply coefficient Lsxs;
assume that the following parameter values are owned:
device number value Sbsl: 13. total value of device Sbzj: 140. delivery duration value Jfsc:36 and a transportation cost value Ysfy:18, weight value: e:0.21, f:0.24, g:0.19 and h:0.23, correction constant J:5, a step of;
obtaining according to a calculation formula of the supply coefficient Ghxs:
；
historical device number value Lssb: 15. 170, historical equipment total value Lszj, historical delivery duration value Lsjf:30 and a historical transportation cost value Lsys:24, weight value: k:0.21, m:0.25, n:0.18 and p:0.23, correction constant Q:5, a step of;
obtaining according to a calculation formula of the historical sales supply coefficient Lsxs:
；
weight value: a:0.48 and B:0.41, correction constant: 5, matching score duration Pfz:3, a step of;
obtaining according to a calculation formula of the additional index Fjzs:
；
the association is then made by the additional index Fjzs and the matching score duration Pfz:
obtaining: additional index fjzs=6.48+ (3 x 0.1) =6.78;
setting a preset threshold S to be 6, setting a preset threshold T to be 9, and comparing with an additional index Fjzs to obtain: the preset threshold S is less than or equal to the additional index Fjs and less than or equal to the preset threshold T, the second-level evaluation is obtained, fluctuation of additional cost affects project budget, implementation of project progress is not affected, project budget needs to be adjusted to a certain extent to adapt to new conditions, high quality, high efficiency and timely completion of the project are maintained, meanwhile, changing cost factors are fully dealt with, and the whole project goal is ensured to be achieved.
Although embodiments of the present invention have been shown and described, it will be understood by those skilled in the art that various changes, modifications, substitutions and alterations can be made therein without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.
Claims (5)
1. The utility model provides a power transmission and transformation engineering cost computing system which characterized in that: the system comprises an information collection module, an information processing module, a calculation module, an evaluation module and a decision module;
the information collection module acquires the bill of supply information and the historical sales and supply information of the control protection equipment through the Internet and a plurality of provider channels;
the information processing module classifies, cleans and normalizes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set; the information processing module comprises a supply processing unit and a history processing unit;
the supply processing unit performs data cleaning on the supply list information in the electronic document or the data file provided by the supplier, checks abnormal format items, missing items and inconsistent items in the data, performs normalization processing, normalizes the data provided by different suppliers to ensure that unit, format and specification parameters are consistent, and classifies the control protection devices with different specifications to form N1, N2 and N3 toControl and protection device of seed specification, and N1, N2, N3 to +.>The data set format parameters of the control protection equipment with the seed specification are the same, and taking N1 as an example, a first data set is formed;
the first data set includes: the equipment quantity value Sbsl, the equipment total value Sbzj, the delivery time length value JFsc and the transportation cost value Ysfy;
the history processing unit performs feature extraction on the history supply list information and the history sales supply information of a plurality of provider channels, which are collected on the internet, so as to obtain a parameter format which is the same as the data set format of the control protection equipment obtained by the supply processing unit, and form the history information of the control protection equipment with L1, L2, L3 to Lx specifications, taking L1 as an example, and form a second data set;
the second data set includes: a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery duration value Lsjf and a historical transportation cost value Lsys;
the calculation module calculates the first data set and the second data set, and obtains: the additional index Fjzs;
the additional index Fjzs is obtained by the following formula:
wherein Ghxs represents a supply coefficient, lsxs represents a historical sales supply coefficient, and A and B represent weight values of the supply coefficient Ghxs and the historical sales supply coefficient Lsxs, respectively;
the supply coefficient Ghxs is obtained through calculation of the first data set;
the historical sales supply coefficient Lsxs is obtained through calculation of the second data set;
the calculation module comprises a supply calculation unit, a historical supply calculation unit and an integration unit;
the goods supply calculation unit calculates a first data set to obtain a goods supply coefficient Ghxs;
the historical goods supply calculation unit calculates a second data set to obtain a historical sales goods supply coefficient Lsxs;
the integration unit calculates the obtained supply coefficient Ghxs and the historical sales supply coefficient Lsxs to obtain an additional index Fjzs;
the obtained supply coefficient Ghxs is obtained by the following formula:
wherein e, f, g and h respectively represent weight values of an equipment quantity value Sbsl, an equipment total value Sbzj, a delivery time length value JFsc and a transportation cost value Ysfy;
wherein,，/>，/>，/>and (2) is (are) of>J represents a correction constant;
the historical sales supply coefficient Lsxs is obtained by the following formula:
wherein k, m, n and p respectively represent weight values of a historical equipment quantity value Lssb, a historical equipment total value Lszj, a historical delivery time length value Lsjf and a historical transportation cost value Lsys;
wherein,，/>，/>，/>and, in addition, the method comprises,q represents a correction constant;
the evaluation module carries out matching on the control protection equipment to implement the installation time grade, and then carries out correlation with the additional index Fjzs, and further compares the additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
the evaluation module comprises an implementation matching unit and a comparison unit;
the implementation matching unit is used for matching the installation time length proposed by the obtained installation manuals of the control protection equipment with different specifications with the implementation installation time length grade to obtain a matching grading value Pfz;
the comparison unit is used for correlating the matching score value duration Pfz with the additional index Fjzs, and then comparing the correlated additional index Fjzs with a preset threshold S and a preset threshold T to obtain a grade evaluation strategy scheme;
wherein the post-association additional index Fjzs is obtained by the following formula:
the value of the additional index Fjzs is changed by carrying out addition assignment on the additional index Fjzs and the matching score value duration Pfz and then forming the value after addition assignment into the additional index Fjzs;
and the decision module forms a predicted additional cost fluctuation file for reference of project staff through the content of the grade evaluation strategy scheme, so that the project risk is reduced.
2. The power transmission and transformation project cost calculation system according to claim 1, wherein: the information collection module comprises an Internet crawling unit and a channel acquisition unit;
the internet crawling unit collects historical bill information related to control and protection equipment from the internet through a web crawler program, and performs preliminary screening and processing on the collected data to delete repeated and invalid information and form network bill information;
the channel acquisition unit is communicated with a plurality of suppliers through establishing contact and cooperation relations, acquires the bill information and the historical sales bill information of the control and protection equipment, and performs preliminary screening and processing on electronic documents or data files provided by the suppliers, including a product catalog, a specification list and a price list, so as to form the bill information of the supplier channel.
3. The power transmission and transformation project cost calculation system according to claim 1, wherein: the grade evaluation strategy scheme is obtained by the following comparison mode:
the additional index Fjzs is smaller than a preset threshold S, a first-level evaluation is obtained, and the fluctuation of the additional cost does not influence the implementation of project budget and project progress;
the preset threshold S is less than or equal to the additional index Fjzs is less than or equal to the preset threshold T, the second-level evaluation is obtained, the fluctuation of the additional cost affects project budget, the implementation of project progress is not affected, the project budget needs to be adjusted to a certain extent to adapt to new conditions, in order to keep high quality, high efficiency and timely completion of the project, and meanwhile, the changing cost factors are fully dealt with, so that the whole project goal is ensured to be realized;
the additional index Fjzs is greater than a preset threshold T, three-level evaluation is obtained, fluctuation of additional cost affects implementation of project budget and project progress, allocation and utilization of resources are required to be reevaluated in the face of cost fluctuation, and adjustment is made on the specification and the type of control safety equipment so as to reduce influence on project budget and progress, and reevaluation is performed on the adjusted additional cost fluctuation until no influence on project progress is achieved.
4. The power transmission and transformation project cost calculation system according to claim 1, wherein: the decision module comprises a document generation unit;
the document generation unit fills a preset additional cost fluctuation document template through the content of the level evaluation strategy scheme to form an estimated additional cost fluctuation document, and details the fluctuation condition of the additional cost, risk factors and countermeasures taken by a project management team are described through the document so as to be used for reference and decision by related personnel.
5. A power transmission and transformation project cost calculation method, comprising a power transmission and transformation project cost calculation system as claimed in any one of claims 1-4, characterized in that: the method comprises the following steps:
step one: acquiring the bill information and the historical sales and supply information of the control and protection equipment through an information collection module;
step two: the information processing module processes the collected bill information to form a first data set, and extracts the characteristics of the historical sales bill information to form a second data set;
step three: calculating the first data set and the second data set through a calculation module to obtain an additional index Fjzs;
step four: matching the class of the implementation installation time length through an evaluation module, associating with the additional index Fjzs, and comparing with a preset threshold S and a preset threshold T to obtain a class evaluation strategy scheme;
step five: and filling a preset template by a decision module according to the content of the grade evaluation strategy scheme to form a predicted additional cost fluctuation document.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311315777.2A CN117236988B (en) | 2023-10-11 | 2023-10-11 | Power transmission and transformation project cost calculation system and cost calculation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311315777.2A CN117236988B (en) | 2023-10-11 | 2023-10-11 | Power transmission and transformation project cost calculation system and cost calculation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117236988A CN117236988A (en) | 2023-12-15 |
| CN117236988B true CN117236988B (en) | 2024-02-27 |
Family
ID=89092864
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311315777.2A Active CN117236988B (en) | 2023-10-11 | 2023-10-11 | Power transmission and transformation project cost calculation system and cost calculation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117236988B (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105631552A (en) * | 2016-01-08 | 2016-06-01 | 国家电网公司 | Power distribution automation engineering economic benefit assessment method based on whole life cycle |
| CN106096779A (en) * | 2016-06-13 | 2016-11-09 | 国家电网公司 | A kind of power transmission and distribution cost analysis, risk evaluation model and risk structure optimization method |
| CN110490442A (en) * | 2019-08-07 | 2019-11-22 | 嘉兴市华信工程咨询有限公司 | A kind of Engineering Cost Consulting project risk management system and method |
| CN112232625A (en) * | 2020-09-07 | 2021-01-15 | 国网宁夏电力有限公司经济技术研究院 | Power transmission and transformation project cost evaluation method based on space-time big data |
| CN115587232A (en) * | 2022-11-02 | 2023-01-10 | 浙江明达工程造价咨询有限公司 | Intelligent management method and system for engineering cost data |
| CN116187743A (en) * | 2022-12-07 | 2023-05-30 | 国网辽宁省电力有限公司经济技术研究院 | Risk assessment method for field construction of power transmission and transformation project |
| CN116611785A (en) * | 2023-05-18 | 2023-08-18 | 国网陕西省电力有限公司经济技术研究院 | Power transmission and transformation project cost model construction method, system, equipment and medium based on big data |
| CN116739218A (en) * | 2023-06-21 | 2023-09-12 | 陈雪琦 | Engineering cost progress management control method and system |
| CN116822967A (en) * | 2023-08-28 | 2023-09-29 | 深圳市睿拓新科技有限公司 | Project cost risk management method and management system |
| CN116862289A (en) * | 2023-06-17 | 2023-10-10 | 上海上咨工程造价咨询有限公司 | Engineering cost index management method, system, terminal equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105825351A (en) * | 2016-04-22 | 2016-08-03 | 国网浙江省电力公司经济技术研究院 | Post evaluation method and risk management and control method of construction cost of power transmission project |
-
2023
- 2023-10-11 CN CN202311315777.2A patent/CN117236988B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105631552A (en) * | 2016-01-08 | 2016-06-01 | 国家电网公司 | Power distribution automation engineering economic benefit assessment method based on whole life cycle |
| CN106096779A (en) * | 2016-06-13 | 2016-11-09 | 国家电网公司 | A kind of power transmission and distribution cost analysis, risk evaluation model and risk structure optimization method |
| CN110490442A (en) * | 2019-08-07 | 2019-11-22 | 嘉兴市华信工程咨询有限公司 | A kind of Engineering Cost Consulting project risk management system and method |
| CN112232625A (en) * | 2020-09-07 | 2021-01-15 | 国网宁夏电力有限公司经济技术研究院 | Power transmission and transformation project cost evaluation method based on space-time big data |
| CN115587232A (en) * | 2022-11-02 | 2023-01-10 | 浙江明达工程造价咨询有限公司 | Intelligent management method and system for engineering cost data |
| CN116187743A (en) * | 2022-12-07 | 2023-05-30 | 国网辽宁省电力有限公司经济技术研究院 | Risk assessment method for field construction of power transmission and transformation project |
| CN116611785A (en) * | 2023-05-18 | 2023-08-18 | 国网陕西省电力有限公司经济技术研究院 | Power transmission and transformation project cost model construction method, system, equipment and medium based on big data |
| CN116862289A (en) * | 2023-06-17 | 2023-10-10 | 上海上咨工程造价咨询有限公司 | Engineering cost index management method, system, terminal equipment and storage medium |
| CN116739218A (en) * | 2023-06-21 | 2023-09-12 | 陈雪琦 | Engineering cost progress management control method and system |
| CN116822967A (en) * | 2023-08-28 | 2023-09-29 | 深圳市睿拓新科技有限公司 | Project cost risk management method and management system |
Non-Patent Citations (4)
| Title |
|---|
| BIM技术在高铁站房施工中的综合应用;张永庆 等;铁路技术创新;74-79 * |
| Research on Prediction of Transmission and Transfomation Project Cost Index Based on ARIMA and Exponential Smoothing Models;Dong-xiao Niu 等;Proceedings of the 22nd International Conference on Industrial Engineering and Engineering Management 2015;771-779 * |
| 电网线路工程造价影响因素识别及风险管控;刘尚科 等;项目管理技术;第19卷(第4期);134-137 * |
| 输变电工程项目成本管理与控制研究;蒙晗;中国优秀硕士学位论文全文数据库工程科技Ⅱ辑;C038-57 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117236988A (en) | 2023-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104318482A (en) | Comprehensive assessment system and method of smart distribution network | |
| CN106131158A (en) | Resource scheduling device based on cloud tenant's credit rating under a kind of cloud data center environment | |
| CN103426120A (en) | Medium and low voltage power distribution network comprehensive evaluation method based on reliability | |
| CN108846592A (en) | A kind of valuation of enterprise report-generating method and device based on big data | |
| CN115392735B (en) | Photovoltaic power station working performance monitoring method, system, equipment and medium | |
| CN107730158A (en) | Power network project intelligent evaluation method and system | |
| CN113361745A (en) | Power distribution network material demand prediction method and system | |
| CN112712240A (en) | Transformer area line loss cause analysis method and device | |
| CN115204583A (en) | Method, system and device for hierarchical management, control, evaluation and analysis of regional risks in chemical industry park | |
| CN109802634B (en) | Intelligent operation and maintenance method and system for photovoltaic power station based on big data | |
| CN115640950A (en) | Method for diagnosing abnormal line loss of distribution network line in active area based on factor analysis | |
| CN117236988B (en) | Power transmission and transformation project cost calculation system and cost calculation method | |
| CN112330089B (en) | Comprehensive energy efficiency monitoring method and monitoring system for equipment manufacturing enterprises | |
| CN116703335A (en) | Engineering supervision method and system based on Internet of things data sharing | |
| CN105354761A (en) | Safety and effectiveness evaluation method and system for accessing wind-power into power grid | |
| CN106886851A (en) | Electric energy meter standby redundancy Forecasting Methodology based on electric energy meter repair based on condition of component | |
| CN115173421A (en) | Probability optimal power flow calculation method based on progressive Latin hypercube sampling | |
| CN114693175A (en) | Unit state analysis method and system based on network source network-related test | |
| Zamar et al. | Robust optimization of competing biomass supply chains under feedstock uncertainty | |
| CN112785166A (en) | Block chain-based power distribution network distributed generation unit output evaluation method and device | |
| CN117311295B (en) | Production quality improving method and system based on wireless network equipment | |
| Ma et al. | Research on substation project prediction method in power transmission and transformation by improved neural network intelligent model | |
| CN117557300B (en) | Method and system for deducing business liveness based on energy consumption data of main equipment | |
| CN116845985B (en) | Source network load storage collaborative scheduling system based on data analysis | |
| CN112446570B (en) | Inventory health index construction method, system, equipment and storage medium |
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 |