Equipment purchase fee automatic statistical method based on real object ID and Internet of things label
Technical Field
The invention relates to the field of power grid investment information statistics, in particular to an automatic equipment purchase fee statistical method based on a material object ID and an Internet of things label.
Background
In 2016, the suggestion about improvement of the reality of statistical data by the innovation of the advanced statistical management system indicates that the statistical data is true, accurate, complete and timely. In the next 4 months, clear requirements are provided for reality, accuracy, completeness and timeliness of statistical data through the implementation regulation of the statistical law of the people's republic of China, and the application of modern information technologies such as big data and the like in statistical work is pointed out to enable the statistical work to meet the development requirements of the economic society. The change of the external environment puts new requirements on power grid services, power grid companies need to improve the attention on statistical work, ensure the authenticity and reliability of statistical data, strengthen the management and control on actual investment scale and progress, and improve the accuracy of power generation planning.
At present, Shanxi electric power company mainly counts the investment cost of a power grid capital construction project by two methods of automatic calculation based on project image progress and acquisition from ERP (enterprise resource planning), but due to the reasons of the manually estimated progress percentage of the finished project amount, the error between the calculated finished investment amount and the actual price (the contract price) by taking the approximate calculation price as a base number, the manual investment estimation statistics after the project is finished and the like, the authenticity, the accuracy and the timeliness of data are difficult to guarantee.
Disclosure of Invention
The invention aims to provide an automatic equipment purchase cost statistics method based on a real object ID and an Internet of things label, which aims to solve the problems in the prior art, can solve the problems of high investment statistics difficulty, low business coordination degree, low statistical data accuracy and the like of an electric company and can realize automatic statistics of equipment purchase cost investment completion information.
In order to achieve the purpose, the invention adopts the following technical scheme:
an automatic equipment purchase fee statistical method based on a real object ID and an Internet of things label comprises data communication, data acquisition, data modeling and data storage which are sequentially carried out;
the data communication takes the entity ID as a core, runs through all links of the whole process of the investment of a power grid project, and realizes communication and sharing of related information of the purchase cost of the substation equipment at each stage of design, purchase and construction in the project execution process through associated project coding, WBS coding and material coding;
the data acquisition comprises the acquisition of equipment purchase arrival information and equipment installation state information by utilizing an engineering construction mobile application;
the data modeling is to establish a statistical model of the purchasing cost of the transformer substation equipment based on the actual purchasing amount of the installed or arrived equipment according to a statistical method specified by the State administration;
the data storage means extracting field data of related forms according to a statistical model of the purchase cost of the substation equipment established by the background, developing calculation and storing results in a data center.
Further, the data link-through method specifically comprises the following steps:
A. the development of projects by a development department can be researched, compiled, reviewed and repeated, the feasibility and the necessity of the projects are demonstrated, investment estimation is carried out, the projects are brought into a comprehensive plan project storage library and are solidified and issued as the basis of comprehensive plan compilation, and the requirement of application entity ID is provided at this stage;
B. the capital construction part develops project schedule planning, submits design requirements, develops preliminary project design and completes project code, WBS and material code correspondence; and organizing and developing project budget planning work, and formally issuing project budget after overall optimization and comprehensive balance with a plan;
C. the material department develops bid purchase, signs a contract, generates a physical ID and pastes a label to the equipment, finishes the work of warehousing and ex-warehouse of the material and transports the equipment to a project site;
D. the construction party, the supervision party, the project party, the supplier and the inspection and acceptance personnel carry out unpacking inspection, and the qualified equipment is installed and debugged; and in the equipment installation and debugging link, carrying out the investment statistics work of the purchase cost of the substation equipment.
Further, the acquisition of the equipment purchase arrival information comprises acquisition of equipment basic information, equipment purchase information and equipment arrival information;
the equipment basic information is the equipment information of the equipment model, quantity, unit, item and supplier which are related by sticking the RFID label to the equipment; the equipment purchase information is obtained by scanning an RFID (radio frequency identification) label or a purchase order number through engineering construction mobile application, and acquiring a material code, a material purchase quantity, a material purchase price and equipment information of a supplier; the equipment arrival information is used for scanning the RFID label or the material delivery order number through the mobile application of the engineering construction to acquire equipment information of project units, project names, suppliers, material codes, material descriptions, units, delivery quantity and actual delivery date.
Further, the equipment installation state information comprises equipment needing to be built and installed and equipment not needing to be built and installed;
the equipment to be constructed and installed meets the following conditions: the foundation or the support of the equipment is finished, the drawing data necessary for installing the equipment is provided, and the equipment is transported to the site, lifted in place and installed after the box opening inspection is finished according to the normal construction procedure; the equipment which does not need to be built and installed meets the following conditions: the product reaches a warehouse of a construction unit or a designated place and is qualified in acceptance;
and under the condition that the equipment meets the conditions, acquiring the purchase amount and quantity information of the equipment through the entity ID associated item code, the WBS code and the material code.
Further, the concrete steps of utilizing the engineering construction mobile application to realize the acquisition of the procurement to-shipment information are as follows:
E. judging whether the substation equipment is attached with the physical ID, if the equipment is attached with the physical ID, performing the step F, and if the equipment is not attached with the physical ID, performing the step G;
F. scanning the RFID label, and then entering the step H;
G. scanning the material handover order number, and then entering the step H;
H. judging whether the equipment needs to be constructed and installed, if so, marking the equipment as the equipment needing to be constructed and installed, otherwise, marking the equipment as the equipment not needing to be constructed and installed;
I. for the equipment subjected to the step F, calculating the statistical state of the equipment to obtain basic information of the equipment; for the device that performs step G, the specific quantities calculated, unconfirmed and not calculated are directly looked at.
Further, the engineering construction mobile application uploads data to a data center after scanning the RFID or the material transfer order number, and a background establishes the following model to realize automatic calculation of the purchase cost of the substation equipment:
P= ∑A .....................(1)
A=a*(1+r) ...................(2)
a=c/u*n ......................(3)
wherein P represents the purchase fee of the substation equipment, A represents the tax amount of the order, a represents the tax-free amount of the order, r represents the tax rate, c represents the net price in the purchase voucher, u represents the price per unit, and n represents the actual quantity of the arrived goods.
Further, the data storage is to extract the field data of the relevant forms according to the statistical model of the purchase cost of the substation equipment established by the background, develop calculation and store the result in the data center, and the specific steps are as follows:
a. after the engineering construction mobile application scans the RFID or the material transfer order number, the data is uploaded to a data center;
b. establishing a statistical model of purchase cost of the substation equipment at a background, and extracting field data of relevant forms;
c. the calculation is carried out and the result is saved in the data center.
Compared with the prior art, the invention has the following beneficial technical effects:
1. after the equipment is installed, the data acquisition work is started on site, and the timeliness of data acquisition is guaranteed.
2. The RFID label or the material handover single number is scanned through the engineering construction mobile application, people interaction is achieved, flexible and convenient operation is achieved at any time and anywhere, secondary input is reduced through scanning, data input workload is reduced, and working efficiency is improved.
3. The equipment investment data are automatically acquired to the data center by scanning the RFID label, so that errors possibly caused by manual operation are avoided, and the authenticity, the accuracy and the reliability of the data are ensured.
The invention discloses an automatic equipment purchase cost statistics method based on a real object ID and an Internet of things label, which combines a mobile technology and an Internet of things label technology and can complete automatic statistics of equipment purchase cost investment completion. Compared with the existing two methods of automatic calculation based on the project image progress and obtaining from ERP, the method not only ensures the authenticity, accuracy and timeliness of the data, reduces the workload of statistical personnel, and improves the working efficiency.
Drawings
FIG. 1 is a schematic general flow chart of an implementation of an automatic device purchase fee statistics method based on a physical ID and an Internet of things label according to the present invention;
FIG. 2 is a schematic flow chart of the data pass-through provided by the present invention;
FIG. 3 is a schematic flow chart of data acquisition provided by the present invention;
FIG. 4 is a schematic flow chart of data storage provided by the present invention.
Detailed Description
The invention is described in further detail below with reference to the accompanying drawings:
referring to fig. 1 to 4, the present invention is an automatic device purchase fee statistics method based on a physical ID and an internet of things tag, including four steps: data link, data acquisition, data modeling and data storage. Sequentially carrying out data communication, data acquisition, data modeling and data storage of the equipment, wherein the next step cannot be carried out before the current step is not finished;
the data communication flow provided by the invention is shown in fig. 2, the investment statistics mainly covers the whole process from project planning to equipment installation, and relates to 3 departments such as a development department, a capital construction department, a material department and the like to generate 4 codes such as an entity ID, a project code, a WBS, a material code and the like, and the data communication specific steps are as follows:
(1) planning phase
The development department develops project research, compilation, review and approval, demonstrates project feasibility and necessity, carries out investment estimation, brings the project into a comprehensive plan project storage library, carries out solidification and issue, and serves as a comprehensive plan compilation basis. At this stage, the need to apply the physical ID is addressed.
(2) Purchase construction stage
Firstly, a capital construction department develops project schedule planning, submits design requirements, develops project primary design and completes project code, WBS and material code correspondence. And organizing and developing project budget planning work, and formally issuing project budget after overall planning optimization and comprehensive balance.
And secondly, the material department develops bid inviting purchase, signs a contract, generates a real object ID, pastes a label to the equipment, finishes the work of warehousing and ex-warehouse of the material and transports the equipment to a project site.
And finally, performing unpacking inspection on five parties including a constructor, a supervisor, a project party, a supplier, an inspection and acceptance person and the like, and installing and debugging the qualified equipment. And in the equipment installation and debugging link, carrying out the investment statistics work of the purchase cost of the substation equipment.
The data acquisition process provided by the invention is shown in fig. 3, and the data acquisition process comprises the following steps: and acquiring the equipment purchase arrival information and the equipment installation state information by utilizing the engineering construction mobile application.
The acquisition of the purchase arrival information comprises the acquisition of equipment basic information, equipment purchase information and equipment arrival information. The device basic information is the device information of the associated device model, quantity, unit, affiliated item and supplier by sticking the RFID label to the device; the equipment purchase information is obtained by scanning an RFID (radio frequency identification) label or a purchase order number through engineering construction mobile application to obtain a material code, a material purchase quantity, a material purchase price and equipment information of a supplier; the equipment arrival information is obtained by scanning the RFID label or the material delivery order number through the mobile application of the engineering construction, and the equipment information of project units, project names, suppliers, material codes, material descriptions, units, delivery quantity and actual delivery date is obtained.
The equipment installation state information includes equipment that needs to be installed constructively and equipment that does not need to be installed constructively. The equipment to be installed needs to meet the requirement that the foundation or the support of the equipment is completed, the drawing data required by the equipment to be installed is provided, and the equipment is transported to the site, subjected to box opening inspection, hoisted in place and installed according to the normal construction procedure; the equipment which does not need to be built and installed needs to meet the requirement that the equipment reaches a warehouse of a building unit or a designated place and is qualified in acceptance; under the condition that the equipment meets the conditions, the information of the purchase amount and the quantity of the equipment can be obtained through the entity ID associated item code, the WBS and the material code.
The specific steps of utilizing the engineering construction mobile application to realize the acquisition of the purchase arrival information are as follows:
A. b, judging whether the substation equipment is attached with the physical ID, if the equipment is attached with the physical ID, performing a step B, and if the equipment is not attached with the physical ID, performing a step C;
B. scanning the RFID tag;
C. scanning the material transfer order number;
D. judging whether the building is required to be constructed and installed, if so, performing the step E, otherwise, performing the step F;
E. marking the equipment as equipment needing building and installation;
F. marking the equipment as equipment which does not need to be built and installed;
G. for the equipment performing the step B, calculating the statistical state of the equipment to obtain basic information of the equipment;
H. for the device that performs step C, the specific number of "calculated", "unconfirmed", "not calculated" can be directly viewed.
The engineering construction mobile application uploads data to a data center after scanning RFID or material transfer order numbers, and a background establishes the following model to realize automatic calculation of the purchase cost of the substation equipment:
P=∑A ......................(1)
A=a*(1+r)...................(2)
a=c/u*n.....................(3)
wherein, P represents the purchase cost of the substation equipment, A represents the tax amount of the order, a represents the tax amount of the order, r represents the tax rate, c represents the net price in the purchase voucher, u represents the price per unit, and n represents the actual quantity of the arrived goods (non-purchase quantity).
The data storage process provided by the invention is as shown in fig. 4, and according to a statistical model of the purchase cost of the substation equipment established by a background, relevant form field data is extracted, calculation is carried out, and the result is stored in a data center, and the specific steps are as follows:
a. the data are uploaded to a data center after the RFID or the material transfer order number is scanned by the engineering construction mobile application;
b. establishing a statistical model of purchase cost of the substation equipment at a background, and extracting field data of relevant forms;
c. the calculation is carried out and the result is saved in the data center.