VSTO-based water conservancy and hydropower project cost achievement compiling device and electronic equipment

Abstract

The invention relates to the technical field of project cost, and provides a VSTO-based water conservancy and hydropower project cost achievement compiling device and electronic equipment. Comprising an Excel plug-in module developed through a VSTO technology, and a template library and a quota database interacting with the Excel plug-in module; the Excel plug-in module comprises a template calling module, a unit price module, a calculation module and a report module; the template calling module is connected with the template library; the unit price module is connected with the quota database; the template calling module is configured to call a corresponding Excel template file in a template library according to a project type and a project stage selected by a user; the unit price module is configured to call quota data in the quota database to newly build a building installation project unit price in the auxiliary calculation table of the Excel template file; and the calculation module is configured to automatically summarize the cost data of each table in the Excel template file based on the Excel formula link. The cost compilation flexibility and format compatibility are improved, the compilation process is simplified, and rapid cost is realized.

Description

Technical Field

[0001] The present application relates to the field of engineering cost technology, and in particular to a VSTO-based water conservancy and hydropower engineering cost results compilation device and electronic equipment. Background Art

[0002] Compared to general municipal and housing construction projects, water conservancy and hydropower projects are characterized by large scale, long construction cycles, and complex construction. Their cost structure is less standardized than in other industries, with some large-scale water conservancy projects even exceeding compilation standards, making cost control even more challenging. Furthermore, the vast majority of project investment in water conservancy and hydropower projects is led by national government departments or large state-owned investment groups, resulting in complex approval processes and high precision requirements. Cost review processes often require individualized comparisons of multiple stages and similar projects.

[0003] Currently, the compilation of cost results in the water conservancy and hydropower engineering industry often adopts water conservancy and hydropower engineering cost software developed by large commercial companies or customized Excel template calculation methods. Among them, the cost software developed by commercial companies has the advantages of strong ease of use and fast result compilation, and is especially suitable for the compilation of costs of small and medium-sized water conservancy and hydropower projects. However, because it is strictly designed in accordance with cost compilation specifications, it cannot meet the customization needs that exist in the compilation of cost results of some large-scale water conservancy and hydropower projects. Correspondingly, although the Excel template calculation method solves the problem of personalized needs in the compilation of cost of some water conservancy and hydropower projects, and Excel format files are easier to analyze and process data due to their universal characteristics, they have the disadvantages of being cumbersome and time-consuming. Summary of the Invention

[0004] In view of this, the embodiment of the present application provides a VSTO-based water conservancy and hydropower project cost results compilation device and electronic equipment, which improves the flexibility and format compatibility of cost compilation and simplifies the compilation process to achieve rapid cost compilation.

[0005] A first aspect of an embodiment of the present application provides a VSTO-based device for compiling water conservancy and hydropower project cost results, comprising an Excel plug-in module developed using VSTO technology, and a template library and a quota database interacting with the Excel plug-in module; The Excel plug-in module includes a template calling module, a unit price module, a calculation module and a report module; The template calling module is connected with the template library; The unit price module is connected to the quota database; The template calling module is configured to call the corresponding Excel template file in the template library according to the project type and project stage selected by the user; The unit price module is configured to call the quota data in the quota database to create a new unit price for the construction and installation project in the auxiliary calculation table of the Excel template file; The calculation module is configured to automatically summarize the cost data of each table in the Excel template file based on the Excel formula link; The report module is configured to export the cost table in the Excel template file into a Word document and / or a numerical Excel file; The template library is configured to store Excel template files for different engineering types and different project stages, wherein the Excel template files include a budget table, a budget appendix, and an auxiliary calculation table; The quota database is configured to store construction and installation engineering quota data of water conservancy and hydropower projects.

[0006] In one embodiment, the budget table includes at least one of a general table, a construction auxiliary project table, a construction project table, an environmental protection and soil and water conservation special project table, a mechanical and electrical equipment and installation project table, a metal structure equipment and installation project table, an independent expense table, a construction land acquisition and resettlement compensation expense table, an annual investment summary table, and a cash flow summary table; The budget schedule includes at least one of a construction project unit price summary table, an installation project unit price summary table, a main material budget price summary table, a construction machinery hourly cost summary table, a main project main engineering quantity summary table, a main material usage summary table, and a main project man-hour quantity summary table; The auxiliary calculation forms include at least one of a construction project unit price calculation form, an installation project unit price calculation form, a sand and gravel unit price calculation form, a concrete material unit price calculation form, and a secondary material budget price summary form.

[0007] In one embodiment, the unit price module includes a construction unit price submodule, an intermediate unit price submodule, an installation unit price submodule, a specified unit price submodule, a query unit price submodule, and a personnel and equipment change submodule; The construction unit price submodule is configured to create a new user-specified construction unit price in the construction project unit price calculation table and add a corresponding unit price number to the construction project unit price summary table, wherein the construction unit price does not include an intermediate unit price; The intermediate unit price submodule is configured to create a new user-specified intermediate unit price in the construction project unit price calculation table and add a corresponding unit price number to the construction project unit price summary table; The installation unit price submodule is configured to create a new user-specified installation unit price in the installation project unit price calculation table and add a corresponding unit price number to the installation project unit price summary table; The specified unit price submodule is configured to form a formula link between the unit price of the sub-project specified by the user and the unit price in the construction unit price summary table and / or the installation unit price summary table in at least one table of the construction auxiliary project table, the construction project table, the electromechanical equipment and installation project table, and the metal structure equipment and installation project table.

[0008] In one embodiment, the unit price query submodule is configured to query the corresponding unit price table in the construction project unit price calculation table and / or the installation project unit price calculation table according to the unit price number; The changing manpower, material and machinery submodule is configured to change the labor, material and machinery equipment types in the construction project unit price calculation table and / or the installation project unit price calculation table.

[0009] In one embodiment, the calculation module includes a main material quantum module, a labor hour quantum module, a table hour fee submodule, and a secondary material fee submodule; The main material summary module is configured to automatically summarize the main material usage of the main project in the main material usage summary table; The unit-hour cost summary submodule is configured to automatically summarize the unit-hour costs of construction machinery in the unit-hour cost summary table; The summarizing work hour quantum module is configured to automatically summarize the main project work hour quantity in the main project work hour quantity summary table; The secondary material cost summary submodule is configured to automatically summarize secondary material prices in the secondary material budget price summary table.

[0010] In one embodiment, the report module includes a unit price cleaning submodule, a word report export submodule, a horizontal and vertical typesetting submodule, a page break setting submodule, and a numerical report export submodule; The unit price cleaning submodule is configured to delete unit prices that are not referenced by other tables in at least one of the construction project unit price summary table, the installation project unit price summary table, the construction project unit price calculation table, and the installation project unit price calculation table; The export word report submodule is configured to import the budget estimate form and / or the budget estimate appendix into a designated Word document; The horizontal and vertical layout submodule is configured to set the table page to be horizontally or vertically laid out; The page break setting submodule is configured to set page breaks between unit prices in the construction project unit price calculation table and / or the installation project unit price calculation table; The export numerical report submodule is configured to generate and export a numerical Excel file with formula links removed based on the current Excel file.

[0011] In one embodiment, the auxiliary calculation table provides material prices, hourly prices, and construction and installation unit prices for the budget table and budget appendix by means of Excel formula links; The budget appendix provides the construction installation unit price for the budget table through an Excel formula link.

[0012] In one embodiment, the Excel plug-in module further includes at least one of a registration and activation module, a tool module, and a help module, and the Excel plug-in module further interacts with a database; The registration and activation module is configured to implement software encryption protection and user management; The tool module is configured for use of common tools during table editing; The help module is configured to consult at least one of a system user manual, a water conservancy and hydropower engineering cost standard document, and a water conservancy and hydropower engineering technical standard document; The database is configured to store at least one of the system user manual file, the water conservancy and hydropower engineering cost standard file, and the water conservancy and hydropower engineering technical standard file.

[0013] In one embodiment, the quota database stores labor, materials, mechanical equipment types and corresponding consumption, and the labor, materials, and mechanical equipment types are all stored in the quota database in a coded form.

[0014] A second aspect of the embodiments of the present application provides an electronic device, comprising the device provided in the first aspect of the embodiments of the present application.

[0015] The first aspect of the embodiment of the present application provides a VSTO-based device for compiling water conservancy and hydropower engineering cost results, which includes an Excel plug-in module developed through VSTO technology, and a template library and quota database that interact with the Excel plug-in module; the Excel plug-in module includes a template calling module, a unit price module, a calculation module and a report module; the template calling module is connected to the template library; the unit price module is connected to the quota database; the template calling module is configured to call the corresponding Excel template file in the template library according to the project type and project stage selected by the user; the unit price module is configured to call the quota in the quota database The unit price of new construction and installation projects is created in the auxiliary calculation tables of the Excel template file. The calculation module is configured to automatically aggregate the cost data from each table in the Excel template file based on Excel formula links. The reporting module is configured to export the cost tables in the Excel template file as Word documents and / or digitized Excel files. The template library is configured to store Excel template files for different project types and phases, including budget tables, budget appendices, and auxiliary calculation tables. The quota database is configured to store quota data for construction and installation projects of water conservancy and hydropower projects. This improves the flexibility and format compatibility of cost compilation, simplifies the compilation process, and enables rapid cost compilation. The Excel file format for compiling cost results offers greater compatibility than other commercial water conservancy and hydropower project cost software. The linking of multiple Excel tables allows for clearer and more specific data sources. This makes it easier to verify errors in the results, compared to water conservancy and hydropower project cost software developed by large commercial companies, where the final results are separated from the compilation interface. Compiling cost results in Excel format offers greater flexibility and adaptability to the customized needs of large-scale water conservancy and hydropower projects. The development of a water conservancy and hydropower cost results compilation system using VSTO technology automates most compilation steps and improves compilation efficiency. Compared to VBA technology, traditionally used for developing Office automation programs, VSTO offers greater software compatibility.

[0016] It can be understood that the beneficial effects of the second aspect mentioned above can be found in the relevant description of the first aspect mentioned above, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the following briefly introduces the drawings required for use in the embodiments or descriptions of the prior art. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without any creative work.

[0018] Figure 1 This is a schematic diagram of a VSTO-based water conservancy and hydropower project cost compilation device provided in one embodiment of the present application; Figure 2 This is a schematic diagram of the composition of an Excel template file for water conservancy and hydropower project costs provided in another embodiment of the present application. DETAILED DESCRIPTION

[0019] In the following description, specific details such as specific system structures and techniques are provided for purposes of illustration rather than limitation to facilitate a thorough understanding of the embodiments of the present application. However, it will be apparent to those skilled in the art that the present application may be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid obscuring the description of the present application with unnecessary detail.

[0020] It should be understood that when used in the present specification and the appended claims, the term "comprising" indicates the presence of described features, integers, steps, operations, elements and / or components, but does not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components and / or collections thereof.

[0021] It will also be understood that the term "and / or" used in this specification and the appended claims refers to and includes any and all possible combinations of one or more of the associated listed items.

[0022] References to "one embodiment" or "some embodiments" in this specification mean that a particular feature, structure, or characteristic described in conjunction with that embodiment is included in one or more embodiments of the present application. Thus, phrases such as "in one embodiment," "in some embodiments," "in other embodiments," and "in other embodiments" appearing in various places in this specification do not necessarily refer to the same embodiment, but rather mean "one or more but not all embodiments," unless otherwise specifically emphasized. The terms "including," "comprising," "having," and variations thereof all mean "including but not limited to," unless otherwise specifically emphasized.

[0023] like Figure 1As shown, an embodiment of the present application provides a VSTO-based device for compiling water conservancy and hydropower engineering cost results. The VSTO-based device for compiling water conservancy and hydropower engineering cost results can be a virtual appliance in an electronic device, which is run by a processor of the electronic device, or it can be the electronic device itself. The VSTO-based device for compiling water conservancy and hydropower engineering cost results provided in an embodiment of the present application includes an Excel plug-in module developed using VSTO technology, and a template library and quota database that interact with the Excel plug-in module. The Excel plug-in module is implemented through the front-end interface 1, and the template library 21 and the quota database 22 are implemented through the back-end storage 2.

[0024] The Excel plug-in module includes a template calling module 12, a unit price module 13, a calculation module 14 and a report module 15; The template calling module 12 is connected to the template library 21; The unit price module 13 is connected to the quota database 22; The template calling module 12 is configured to call the corresponding Excel template file in the template library according to the project type and project stage selected by the user, and the subsequent cost results compilation is carried out based on the template file; The unit price module 13 is configured to call the quota data in the quota database to create a new unit price for the construction and installation project in the auxiliary calculation table of the Excel template file; The calculation module 14 is configured to automatically summarize the cost data of each table in the Excel template file based on the Excel formula link; The report module 15 is configured to export the cost table in the Excel template file into a Word document and / or a numerical Excel file; The template library 21 is configured to store Excel template files of water conservancy and hydropower project cost for different project types and different project stages, such as Figure 2 As shown, each Excel template file includes the budget form, budget appendix and auxiliary calculation forms related to these forms required by the water conservancy and hydropower project cost specifications; The quota database 22 is configured to store construction and installation engineering quota data of water conservancy and hydropower engineering projects.

[0025] In applications, VSTO (Visual Studio Tools for Office) technology can be used to develop various Office-based automation applications such as Excel, Word, and Access.

[0026] In the app, fill in the project name, such as Hubei Daye Pumped Storage Power Station, and select the project type, such as Pumped Storage Power Station and Project Phase Feasibility Study Design Estimate. Then, click New. The system will create the corresponding Excel template file in the folder specified by the user.

[0027] The embodiments of this application utilize an Excel plug-in module developed based on VSTO technology as its core, interacting with a template library storing predefined structures and a quota database storing quota data to create a cost compilation device that is deeply integrated into a user's familiar office environment. Its core advantage lies in leveraging VSTO technology to deeply expand Excel's functionality. This allows the system to inherit the significant advantages of Excel files in terms of flexible data processing and universal compatibility, while significantly improving the efficiency and accuracy of water conservancy and hydropower project cost compilation through automated modules (template calling, unit price generation, automatic calculation, and report output). This effectively addresses the lack of customizability of traditional commercial software and the cumbersome and time-consuming operation of pure Excel templates, providing a highly efficient tool for meeting the personalized needs of large-scale and complex water conservancy and hydropower projects.

[0028] In one embodiment, the budget table includes at least one of a general table, a construction auxiliary project table, a construction project table, an environmental protection and soil and water conservation special project table, a mechanical and electrical equipment and installation project table, a metal structure equipment and installation project table, an independent expense table, a construction land acquisition and resettlement compensation expense table, an annual investment summary table, and a cash flow summary table. The appendix to the budget estimate shall include at least one of the following: a summary table of unit prices for construction projects, a summary table of unit prices for installation projects, a summary table of budget prices for major materials, a summary table of hourly costs for construction machinery, a summary table of major quantities of major works for the main project, a summary table of quantities of major materials used for the main project, and a summary table of man-hour quantities for the main project; The auxiliary calculation forms include at least one of a construction project unit price calculation form, an installation project unit price calculation form, a sand and gravel unit price calculation form, a concrete material unit price calculation form and a secondary material budget price summary form.

[0029] The embodiment of this application strictly complies with the industry standards for the compilation of water conservancy and hydropower project costs by clearly defining the Excel template files in the template library to include three specific table types: budget tables, budget appendices, and auxiliary calculation tables (such as general tables, project unit price summary tables, unit price calculation tables, etc.), ensuring the standardization of the output results. At the same time, this structured table system forms a clear and traceable data flow through preset link relationships (especially the auxiliary calculation tables provide basic unit price data for the budget appendices, and the budget appendices provide comprehensive unit prices for the budget tables), greatly improving the transparency of cost results, facilitating review and error verification, and laying the foundation for meeting the complex multi-stage comparative review needs of state-owned investment projects.

[0030] In one embodiment, the unit price module includes a construction unit price submodule, an intermediate unit price submodule, an installation unit price submodule, a specified unit price submodule, a query unit price submodule, and a personnel and equipment change submodule; The construction unit price submodule is configured to create a new user-specified construction unit price in the construction project unit price calculation table and add the corresponding unit price number to the construction project unit price summary table, where the construction unit price does not include the intermediate unit price; The intermediate unit price submodule is configured to create a new user-specified intermediate unit price in the construction project unit price calculation table and add the corresponding unit price number in the construction project unit price summary table; The installation unit price submodule is configured to create a new user-specified installation unit price in the installation project unit price calculation table and add the corresponding unit price number in the installation project unit price summary table; The specified unit price submodule is configured to form a formula link between the unit price of the sub-project specified by the user and the unit price in the construction unit price summary table and / or the installation unit price summary table in at least one table of the construction auxiliary project table, the construction project table, the electromechanical equipment and installation project table, and the metal structure equipment and installation project table.

[0031] In the application, the unit price number is the name of the unit price, the price composition and the unique corresponding unit price number.

[0032] The embodiment of the present application refines the unit price module into specific functional units such as the construction unit price submodule, the intermediate unit price submodule, the installation unit price submodule, and the designated unit price submodule, thereby achieving refined and classified management of different types of unit prices in water conservancy and hydropower projects (such as direct construction unit prices, intermediate unit prices for composite processes, and equipment installation unit prices), in line with industry pricing characteristics. The designated unit price submodule can automatically establish formula links between sub-project tables (such as construction project tables) and unit price summary tables. This ensures that any modifications in the basic unit price calculation table (such as the construction project unit price calculation table) can be automatically and real-timely transmitted and updated to all places where the unit price is referenced through Excel's native link mechanism, completely avoiding the risk of data inconsistency errors caused by manual copying and pasting or missing updates in traditional methods, and significantly improving the reliability and maintenance efficiency of large-scale project data.

[0033] In one embodiment, the unit price query submodule is configured to query the corresponding unit price table in the construction project unit price calculation table and / or the installation project unit price calculation table according to the unit price number; The change manpower, material and machinery submodule is configured to change the labor, material and machinery equipment types in the construction project unit price calculation table and / or the installation project unit price calculation table.

[0034] The embodiment of the present application defines the functions of the query unit price submodule and the change personnel, materials and machinery submodule. The query unit price submodule uses the unique unit price number as an index, allowing users to quickly locate the calculation details of a specific unit price in the massive unit price data, greatly improving the efficiency of verification and reference in the cost compilation process. The advantage of the change personnel, materials and machinery submodule is that it provides the flexibility to directly modify the basic quota consumption (labor, materials, machinery), allowing the system to flexibly respond to quota adjustments in different regions, special construction process requirements or market price fluctuations, and these modifications can also automatically update all relevant unit prices and summary data through the established Excel formula link network, ensuring the convenience and data consistency of the system when adapting to changes.

[0035] In one embodiment, the calculation module includes a main material quantum module, a labor hour quantum module, a table hour fee submodule, and a secondary material fee submodule; The main material summary module is configured to automatically summarize the main material usage of the main project in the main material usage summary table; The unit-hour cost summary submodule is configured to automatically summarize and count the unit-hour costs of construction machinery in the unit-hour cost summary table of construction machinery; The summary work hour quantum module is configured to automatically summarize and count the main project work hour quantity in the main project work hour quantity summary table; The secondary material cost summary submodule is configured to automatically summarize and count the secondary material prices in the secondary material budget price summary table.

[0036] The embodiment of this application includes four automated summary submodules for summarizing main material quantities, labor hours, machine-hour fees, and secondary material fees. This module covers several of the most critical and computationally cumbersome summary tasks in compiling water conservancy and hydropower project costs (main material quantities, labor hours, machinery usage fees, and secondary material costs). Automatic and accurate aggregation of this data is achieved through pre-set Excel formula logic (such as SUMIF and SUMIFS). This eliminates the arduous and repetitive manual labor of searching, filtering, and summing numerous tables, significantly improving compilation efficiency while eliminating the potential for manual calculation errors. This ensures the accuracy of core results such as the "Summary Table of Main Material Consumption for the Main Project," providing a reliable basis for project cost control.

[0037] In one embodiment, the report module includes a unit price cleaning submodule, a word report export submodule, a horizontal and vertical typesetting submodule, a page break setting submodule, and a numerical report export submodule; The unit price cleaning submodule is configured to delete unit prices that are not referenced by other tables in at least one of the tables: the construction project unit price summary table, the installation project unit price summary table, the construction project unit price calculation table, and the installation project unit price calculation table; The export word report submodule is configured to import the budget estimate form and / or budget estimate appendix into a specified Word document; The horizontal and vertical layout submodule is configured to set the table page to be horizontal or vertical; The setting page break submodule is configured to set a unit price page break between each unit price in the construction project unit price calculation table and / or the installation project unit price calculation table; The export numerical report submodule is configured to generate and export a numerical Excel file with formula links removed based on the current Excel file.

[0038] The embodiment of this application defines the specific sub-functions of the report module and provides a complete set of cost results output and optimization solutions. Among them, the unit price cleaning sub-module automatically deletes unreferenced redundant unit price data, making the result file more refined and professional; the Word report export sub-module meets the standard format requirements for formal report submission; the horizontal and vertical layout and page break setting sub-module (especially paging by unit price in the unit price calculation table) ensures the standardization and readability of the print output, meeting the archiving requirements of cost files; the numerical report export sub-module generates an Excel file that removes formula links and only retains the calculation results, greatly facilitating the sharing, transmission and subsequent analysis of results (without worrying about broken links or formula errors), and solving the pain points of collaboration based on formula template files.

[0039] In one embodiment, the auxiliary calculation table provides material prices, hourly prices, and construction and installation unit prices for the budget table and budget appendix by means of Excel formula links; The budget appendix provides the unit price of construction and installation for the budget table through Excel formula link.

[0040] The embodiment of the present application defines the specific flow of data (material prices, hourly rates, and unit prices for construction and installation) between the auxiliary calculation table, the budget appendix, and the budget table through Excel formula links. A dynamic and traceable data network is constructed using Excel's built-in powerful formula linking function. Any modification in the basic calculation layer (auxiliary calculation table) will be automatically and real-time updated step by step to the budget appendix until the final budget summary table. This mechanism ensures the strong consistency, linkage, and accuracy of all data in the entire cost document from the bottom up. At the same time, the clarity of the data flow makes it easy to conduct reverse tracking when reviewing the results or diagnosing errors, which significantly improves the reliability and transparency of the cost results. It is especially suitable for water conservancy and hydropower engineering projects with strict audit requirements.

[0041] In one embodiment, the Excel plug-in module further includes at least one of a registration and activation module 11, a tool module 16, and a help module 17, and the Excel plug-in module further interacts with a database 23; The registration and activation module is configured to implement software encryption protection and user management; The tool module is configured for the use of common tools during table editing; The help module is configured to consult at least one of a system user manual file, a water conservancy and hydropower engineering cost standard file, and a water conservancy and hydropower engineering technical standard file; The database is configured to store at least one of system user manual files, water conservancy and hydropower engineering cost standard files, and water conservancy and hydropower engineering technical standard files.

[0042] The registration and activation module of the embodiment of the present application provides the necessary software authorization management and user authority control, ensuring the legal use and security of commercial software; the tool module integrates commonly used table editing functions (such as format brush, batch replacement, etc.), reducing the need for users to frequently switch back to the Excel native menu when using plug-ins, thereby improving operational fluency; the help module interacts with the database, allowing users to directly consult the built-in system operation guide, the latest cost standards or engineering technical standards during the compilation process, solving the common problem of users not knowing how to operate or being uncertain about the standard basis when using complex software, reducing learning costs, and improving work efficiency and the accuracy of the compilation basis.

[0043] In one embodiment, the quota database stores labor, materials, and mechanical equipment types and corresponding consumption. The labor, materials, and mechanical equipment types are all stored in the quota database in a coded form.

[0044] The coding system of the embodiment of the present application achieves standardized management of quota data. Coding eliminates potential ambiguities in natural language descriptions (such as different names for the same material in different regions), ensuring the uniqueness and accuracy of quota data. Coding acts as an efficient index key, greatly accelerating the retrieval and matching speed of the quota database, especially when processing the massive amount of quota data involved in large-scale projects. The standardized coding system lays a solid foundation for the reuse of historical quota data across projects and projects, facilitating the establishment of an enterprise quota database or the rapid application of experience data from similar projects, thereby improving data utilization value and compilation efficiency.

[0045] An embodiment of the present application also provides an electronic device, comprising the device provided in the first aspect of the embodiment of the present application.

[0046] It should be noted that the information interaction, execution process, etc. between the above-mentioned devices / units are based on the same concept as the method embodiment of this application. Their specific functions and technical effects can be found in the method embodiment section and will not be repeated here.

[0047] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In actual applications, the above-mentioned functions can be distributed and completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated into one processing unit, or each unit can exist physically alone, or two or more units can be integrated into one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.

[0048] Those skilled in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered beyond the scope of this application.

[0049] In the embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of modules or units is only a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0050] Units described as separate components may or may not be physically separate, and components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected to achieve the purpose of this embodiment according to actual needs.

[0051] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. These modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the various embodiments of the present application, and should all be included in the scope of protection of the present application.

Claims

1. A VSTO-based water conservancy and hydropower project cost results compilation device, characterized in that: It includes an Excel plug-in module developed by using VSTO technology, and a template library and a quota database that interact with the Excel plug-in module; The Excel plug-in module includes a template calling module, a unit price module, a calculation module and a report module; The template calling module is connected with the template library; The unit price module is connected to the quota database; The template calling module is configured to call the corresponding Excel template file in the template library according to the project type and project stage selected by the user; The unit price module is configured to call the quota data in the quota database to create a new unit price for the construction and installation project in the auxiliary calculation table of the Excel template file; The calculation module is configured to automatically summarize the cost data of each table in the Excel template file based on the Excel formula link; The report module is configured to export the cost table in the Excel template file into a Word document and / or a numerical Excel file; The template library is configured to store Excel template files for different engineering types and different project stages, wherein the Excel template files include a budget table, a budget appendix, and an auxiliary calculation table; The quota database is configured to store construction and installation engineering quota data of water conservancy and hydropower projects.

2. The VSTO-based water conservancy and hydropower project cost results compilation device according to claim 1, characterized in that: The budget forms include at least one of a general table, a construction auxiliary project table, a construction project table, an environmental protection and soil and water conservation special project table, a mechanical and electrical equipment and installation project table, a metal structure equipment and installation project table, an independent expense table, a construction land acquisition and resettlement compensation expense table, an annual investment summary table, and a cash flow summary table; The budget schedule includes at least one of a construction project unit price summary table, an installation project unit price summary table, a main material budget price summary table, a construction machinery hourly cost summary table, a main project main engineering quantity summary table, a main material usage summary table, and a main project man-hour quantity summary table; The auxiliary calculation forms include at least one of a construction project unit price calculation form, an installation project unit price calculation form, a sand and gravel unit price calculation form, a concrete material unit price calculation form, and a secondary material budget price summary form.

3. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 2, characterized in that: The unit price module includes a construction unit price submodule, an intermediate unit price submodule, an installation unit price submodule, a specified unit price submodule, a query unit price submodule, and a personnel and equipment change submodule; The construction unit price submodule is configured to create a new user-specified construction unit price in the construction project unit price calculation table and add a corresponding unit price number to the construction project unit price summary table, wherein the construction unit price does not include an intermediate unit price; The intermediate unit price submodule is configured to create a new user-specified intermediate unit price in the construction project unit price calculation table and add a corresponding unit price number to the construction project unit price summary table; The installation unit price submodule is configured to create a new user-specified installation unit price in the installation project unit price calculation table and add a corresponding unit price number to the installation project unit price summary table; The specified unit price submodule is configured to form a formula link between the unit price of the sub-project specified by the user and the unit price in the construction unit price summary table and / or the installation unit price summary table in at least one table of the construction auxiliary project table, the construction project table, the electromechanical equipment and installation project table, and the metal structure equipment and installation project table.

4. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 3, characterized in that: The unit price query submodule is configured to query the corresponding unit price table in the construction project unit price calculation table and / or the installation project unit price calculation table according to the unit price number; The changing manpower, material and machinery submodule is configured to change the labor, material and machinery equipment types in the construction project unit price calculation table and / or the installation project unit price calculation table.

5. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 2, characterized in that: The calculation module includes a main material quantum module, a work hour quantum module, a machine hour fee submodule, and a secondary material fee submodule; The main material summary module is configured to automatically summarize the main material usage of the main project in the main material usage summary table; The unit-hour cost summary submodule is configured to automatically summarize the unit-hour costs of construction machinery in the unit-hour cost summary table; The summarizing work hour quantum module is configured to automatically summarize the main project work hour quantity in the main project work hour quantity summary table; The secondary material cost summary submodule is configured to automatically summarize secondary material prices in the secondary material budget price summary table.

6. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 2, characterized in that: The report module includes a unit price cleaning submodule, a word report export submodule, a horizontal and vertical typesetting submodule, a page break setting submodule, and a numerical report export submodule; The unit price cleaning submodule is configured to delete unit prices that are not referenced by other tables in at least one of the construction project unit price summary table, the installation project unit price summary table, the construction project unit price calculation table, and the installation project unit price calculation table; The export word report submodule is configured to import the budget estimate form and / or the budget estimate appendix into a designated Word document; The horizontal and vertical layout submodule is configured to set the table page to be horizontally or vertically laid out; The page break setting submodule is configured to set page breaks between unit prices in the construction project unit price calculation table and / or the installation project unit price calculation table; The export numerical report submodule is configured to generate and export a numerical Excel file with formula links removed based on the current Excel file.

7. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 1, characterized in that: The auxiliary calculation form provides material prices, hourly prices and construction and installation unit prices for the budget form and budget appendix through Excel formula links; The budget appendix provides the construction installation unit price for the budget table through an Excel formula link.

8. The VSTO-based water conservancy and hydropower project cost compilation device according to claim 1, characterized in that: The Excel plug-in module further includes at least one of a registration and activation module, a tool module, and a help module, and the Excel plug-in module further interacts with a database; The registration and activation module is configured to implement software encryption protection and user management; The tool module is configured for use of common tools during table editing; The help module is configured to consult at least one of a system user manual, a water conservancy and hydropower engineering cost standard document, and a water conservancy and hydropower engineering technical standard document; The database is configured to store at least one of the system user manual file, the water conservancy and hydropower engineering cost standard file, and the water conservancy and hydropower engineering technical standard file.

9. The VSTO-based water conservancy and hydropower project cost results compilation device according to claim 1, characterized in that: The labor, materials, and mechanical equipment types and corresponding consumption amounts stored in the quota database are all stored in the quota database in a coded form.

10. An electronic device, characterized in that: Comprising the device according to any one of claims 1-9.

Images