Method and system for replacing fixed quantities in railway engineering single-item budget files

Abstract

The present application relates to a railway engineering single item budget file quota batch replacement method and system. The budget quota adjustment replacement relies on manual processing, which cannot be processed quickly in batches. The method establishes a project database; reads the project chapter item information, constructs a chapter directory tree; reads the budget paragraph information, constructs a budget paragraph information table; associates the chapter directory tree to each entry in the budget paragraph information table; according to the entries in the budget paragraph information table, assigns single item budget quota information to each chapter; determines the quota number before and after replacement, and uses the chapter directory tree and the budget paragraph information table to replace the single item budget quota information contained in batches. The present application is suitable for batch replacement of different projects, different budget paragraphs, different chapter items, and different budget quotas, avoiding the original replacement of each paragraph and chapter item, and greatly improving the efficiency and accuracy of the budget file.

Description

Technical Field

[0001] This invention relates to the field of railway engineering budgeting technology, specifically to a method and system for batch replacement of quotas in individual railway engineering budget documents. Background Technology

[0002] According to the methods for compiling railway engineering budget estimates, when preparing individual budget estimates for railway engineering projects, professional technicians need to establish different budget units and detailed chapters based on the characteristics of the project, and determine different budget quotas according to the project content. These quotas are then compiled under the respective budget units and detailed chapters to calculate the cost of the corresponding project and complete the budget estimate document. Generally, large-scale projects can have dozens or even hundreds of budget units, tens of thousands of detailed chapters, and hundreds of thousands or even millions of quota data entries.

[0003] However, railway engineering projects are complex and ever-changing. As the project progresses through different stages, the budget quotas often need to be adjusted and replaced according to the selection of different construction methods. The current method relies on manual adjustment and replacement item by item, which cannot be processed quickly in batches. When there are many sections and chapters in the project budget, manual operation is time-consuming and laborious, and prone to omissions, and cannot guarantee 100% accuracy.

[0004] Therefore, it is necessary to propose new methods to overcome the above problems. Summary of the Invention

[0005] The purpose of this invention is to provide a method and system for batch replacement of quotas in single-item budget documents for railway engineering, so as to solve the problem of rapid batch replacement of quotas in budget documents and ensure the quality of budget documents.

[0006] To achieve the above objectives, the technical solution adopted by the present invention is as follows:

[0007] A method for batch replacement of quotas in single-item budget documents for railway engineering projects, the method comprising:

[0008] Establish a project database, which includes detailed information on project chapters, budget section information, and individual budget quota information.

[0009] Read the detailed chapter information of the project and build a chapter directory tree;

[0010] Read the information from the preliminary budget section and construct the preliminary budget section information table;

[0011] Link the chapter directory tree to each entry in the budget section information table;

[0012] Based on the entries in the budget section information table, assign individual budget quota information to each chapter;

[0013] Determine the quota numbers before and after the replacement, and use the chapter directory tree and the budget section information table to batch replace the individual budget quota information contained therein.

[0014] Furthermore, the project chapter details include the chapter entry number and the chapter name.

[0015] Furthermore, the information in the budget section includes the total budget number, total budget number, scope of preparation, unit, quantity of work, budget value, and budget indicator information.

[0016] Furthermore, the individual budget quota information includes quota number, quota name, and unit.

[0017] Furthermore, the project's chapter details are read to construct a chapter directory tree, including:

[0018] Iterate through all project chapter details, which have a hierarchical relationship;

[0019] Construct a chapter directory tree based on the hierarchical relationship of the project's chapter details.

[0020] Furthermore, read the budget section information and construct a budget section information table, including:

[0021] Select the preliminary budget section to read the preliminary budget section information;

[0022] Filter the relevant quota information belonging to this budget section;

[0023] Filter out quota information that does not belong to this budget section;

[0024] Obtain the budget section information table, which contains entries.

[0025] Furthermore, the chapter directory tree is linked to each entry in the budget section information table, including:

[0026] Select a project section to read the project section details;

[0027] Determine the hierarchy of the project's chapters and sub-items, and filter out quota information that does not belong to the hierarchy of the project's chapters and sub-items or their subsets.

[0028] Furthermore, based on the entries in the budget section information table, individual budget quota information is assigned to each chapter, including:

[0029] Select the level of the budget section and the level of the project chapter details to limit the quotas to be replaced to the selected range.

[0030] Furthermore, determine the quota numbers before and after the replacement, and use the chapter directory tree and budget section information table to perform batch replacement of the included individual budget quota information, including:

[0031] Search for the quota number before replacement, and obtain all entries in the budget section information table containing the budget section information corresponding to the quota number.

[0032] Select the entry you want to replace, and then select the chapter you want to replace in the chapter directory tree;

[0033] Determine the replacement quota number, and then batch replace all individual budget quota information at the level below the chapter.

[0034] On the other hand, a system for batch replacement of quotas in single-item budget documents for railway engineering is provided, the system being used to implement the method, including:

[0035] The project database creation module is used to create a project database, which contains detailed information on project chapters, budget paragraphs, and individual budget quotas.

[0036] The chapter directory tree construction module is used to read the detailed chapter information of the project and build the chapter directory tree.

[0037] The module for constructing the budget section information table is used to read budget section information and construct the budget section information table.

[0038] The association module is used to associate the chapter directory tree with each entry in the budget section information table;

[0039] The allocation module is used to allocate individual budget quota information to each chapter based on the entries in the budget paragraph information table.

[0040] The batch replacement module is used to determine the quota number before and after replacement, and to perform batch replacement of the included individual budget quota information using the chapter directory tree and the budget paragraph information table.

[0041] Compared with the prior art, the beneficial effects of the present invention are as follows:

[0042] This invention provides a method and system for batch replacement of quotas in single-item budget documents for railway engineering. It is applicable to the batch replacement of different projects, different budget paragraphs, different chapter details, and different budget quotas. It can realize the rapid batch modification of specified quotas, avoid the original replacement of paragraphs and chapter details one by one, greatly improve the efficiency and accuracy of budget document preparation, and ensure the quality of budget document preparation. Attached Figure Description

[0043] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other embodiments can be obtained from these drawings without creative effort.

[0044] Figure 1 This is a flowchart of the method of the present invention.

[0045] Figure 2 This is a schematic diagram of quota replacement according to an embodiment of the present invention.

[0046] Figure 3 This is an example diagram of the quota replacement before replacement in an embodiment of the present invention.

[0047] Figure 4 This is an example diagram of the quota replacement after the replacement in an embodiment of the present invention. Detailed Implementation

[0048] To facilitate understanding of the present invention, a more complete description will be given below with reference to the accompanying drawings. Preferred embodiments of the invention are shown in the drawings. However, the invention can be implemented in many different forms and is not limited to the embodiments described herein. Rather, these embodiments are provided to provide a thorough and complete understanding of the disclosure of the invention.

[0049] It should be noted that the terms “comprising” and any variations thereof are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are explicitly listed, but may include other steps or units that are not explicitly listed or that are inherent to such process, method, product or device.

[0050] It should also be noted that although the order of steps is mentioned in the method description, in some cases, steps may be performed in a different order than that described here, and this should not be interpreted as a restriction on the order of steps.

[0051] Currently, the preparation of individual budget estimates for railway engineering projects is mainly carried out in the railway engineering cost software "Railway Engineering Investment Control System". Users establish budget estimate sections based on the characteristics of the project and in accordance with specifications, determine the detailed itemization of the project chapters, and input quota information and quantity information under the corresponding project chapters. Through calculation, the preparation of individual budget estimates for railway engineering projects is completed. This software establishes a database file for each project to store the corresponding project budget estimate preparation information. This invention provides a method for batch replacement of quotas in individual budget estimate documents for railway engineering projects. By reading data from the corresponding database file and using a batch replacement method for quota data, it achieves rapid and accurate batch replacement of quota data in individual budget estimate documents for railway engineering projects, ensuring the quality of the budget estimate documents. The method includes:

[0052] S1: Establish a project database, which contains detailed information on project chapters, budget paragraphs, and individual budget quotas.

[0053] The project database contains project information, which refers to the information used to determine the uniqueness of a project, including project number, project name, design stage, and line length information, to distinguish different engineering projects.

[0054] In addition, the project database also contains detailed information on project chapters, budget section information, and individual budget quota information.

[0055] Project chapter details refer to the engineering categories or cost names divided according to the characteristics of different engineering projects, including chapter detail item number and chapter detail name (engineering or cost item name), used to distinguish different engineering contents or cost categories.

[0056] The information in the budget section refers to the different budget preparation scopes divided according to the requirements of the budget preparation specifications. It includes the total budget serial number, total budget number, preparation scope, unit, project quantity, budget value, and budget indicator information, which are used to distinguish different budget preparation scopes.

[0057] The single-item budget quota information refers to the consumption quotas used in compiling railway engineering budgets, including quota number, quota name, and unit. It is used to distinguish different quota categories, determine the consumption of engineering content, and is the basis for budget preparation.

[0058] S2: Read the detailed chapter information of the project and build a chapter directory tree. This includes:

[0059] S201: Traverse all project chapter details. The project chapter details have a hierarchical relationship, i.e., a containment relationship.

[0060] S202: Construct a chapter directory tree based on the hierarchical relationship of the project chapter details.

[0061] like Figure 2 On the left, the chapter details have an inclusion relationship, such as “Part 1: Static Investment” which includes the contents of Chapters 1 to 12, and is its parent level; the hierarchical relationship of “A. Cast-in-place concrete” in the figure is as follows: “Part 1: Static Investment—IV. Tunnels and Open-cut Caves—10. Tunnels—A. New Construction—II. Tunnels with a length of 3 km < Tunnel Length ≤ 4 km—I. Construction Engineering Costs—1. Main Tunnel (Drill and Blasting Method Construction)—(4) Class IV Surrounding Rock—② Lining—A. Cast-in-place Concrete”.

[0062] S3: Read the preliminary budget section information and construct the preliminary budget section information table. This includes:

[0063] S301: Select the preliminary budget section and read the preliminary budget section information;

[0064] S302: Filter the corresponding quota information belonging to this budget section;

[0065] S303: Filter out quota information that does not belong to this budget section;

[0066] S304: Obtain the budget section information table, which contains entries.

[0067] S4: Link the chapter directory tree to each entry in the budget section information table. This includes:

[0068] S401: Select a project section detail and read the project section detail information;

[0069] S402: Determine the level of the detailed items in this project chapter, and filter out the quota information that does not belong to the level of the detailed items in this project chapter or its subset.

[0070] S5: Based on the entries in the budget section information table, assign individual budget quota information to each chapter. This includes:

[0071] Select the level of the budget section and the level of the project chapter details to limit the quotas to be replaced to the selected range.

[0072] Different paragraphs and chapters may use the same quota. This method allows for the selection of multiple paragraphs, and can replace the detailed quotas of different paragraphs and the same chapter at the same time.

[0073] S6: Determine the quota numbers before and after the replacement, and use the chapter directory tree and budget section information table to batch replace the included individual budget quota information. This includes:

[0074] S601: Search for the replaced quota number, and obtain all entries in the budget section information table containing the budget section information based on the single budget quota information corresponding to the quota number.

[0075] S602: Select the entry to be replaced and select the chapter to be replaced in the chapter directory tree;

[0076] S603: Batch replace all individual budget quota information at the level below the chapter.

[0077] The location of the quota to be replaced can be selected by the hierarchical relationship of different chapters and sub-categories. Selecting the lowest chapter or sub-category will replace the specified quota under this sub-category. Selecting a parent level will replace all its corresponding child levels.

[0078] like Figure 2 In the lower right half, after determining the quota number to be replaced and the replacement quota number, use this method to replace the quota number under the specified budget section and chapter details, and complete the replacement and update of the corresponding quota name.

[0079] Example:

[0080] In a certain project, the tunnel budget quota number is SY-119, and the quota name is "cast concrete arch wall". Now, according to requirements, "SY-119 cast concrete arch wall" needs to be replaced with "SY-122 cast concrete invert arch". This replacement includes changing both the quota number and the quota name. Figure 3 The figure shows the quota content before the replacement.

[0081] from Figure 3 In the preview box in the lower right corner, you can see that the quota SY-119 appears under different chapter details in paragraphs 01 and 02. This replacement involves different paragraphs and different chapter details.

[0082] By inputting the quota numbers before and after replacement, and selecting the budget section and chapter detail level, batch replacement of specified quotas for different budget sections and chapter details is achieved, such as... Figure 4 As shown, both the quota number and quota name have been replaced, significantly improving the efficiency of quota replacement and greatly liberating productivity. Currently, this method has been successfully applied in multiple railway projects, significantly improving production efficiency and ensuring the quality of budget and estimate documents.

[0083] On the other hand, the present invention provides a system for batch replacement of quotas in single-item budget documents for railway engineering, used to implement the above method, including:

[0084] The project database creation module is used to create a project database, which contains detailed information on project chapters, budget paragraph information, and individual budget quota information, corresponding to S1 of the above method;

[0085] The chapter directory tree construction module is used to read the detailed chapter information of the project and construct the chapter directory tree, which corresponds to S2 of the above method;

[0086] The module for constructing the budget section information table is used to read the budget section information and construct the budget section information table, which corresponds to S3 of the above method.

[0087] The association module is used to associate the chapter directory tree with each entry in the budget paragraph information table, corresponding to S4 of the above method;

[0088] The allocation module is used to allocate individual budget quota information to each chapter according to the entries in the budget paragraph information table, corresponding to S5 of the above method;

[0089] The batch replacement module is used to determine the quota number before and after replacement, and to perform batch replacement of the included individual budget quota information using the chapter directory tree and the budget paragraph information table, corresponding to S6 of the above method.

[0090] Those skilled in the art will understand that all or part of the functions of the embodiments of the present invention can be implemented by hardware or by computer program. When all or part of the functions in the above embodiments are implemented by computer program, the program can be stored in a computer-readable storage medium, which may include: read-only memory, random access memory, disk, optical disk, hard disk, etc., and the program is executed by a computer to achieve the above functions. For example, the program can be stored in the memory of a device, and when the program in the memory is executed by the processor, all or part of the above functions can be achieved. In addition, when all or part of the functions in the above embodiments are implemented by computer program, the program can also be stored in a storage medium such as a server, another computer, disk, optical disk, flash drive, or portable hard drive, and can be downloaded or copied to the memory of a local device, or the system of the local device can be updated. When the program in the memory is executed by the processor, all or part of the functions in the above embodiments can be achieved.

[0091] The above examples illustrate the present invention only to aid in understanding it and are not intended to limit the scope of the invention. Those skilled in the art can make various simple deductions, modifications, or substitutions based on the principles of this invention.

Claims

1. A method for batch replacement of quotas in single-item budget documents for railway engineering projects, characterized by: The method includes: Establish a project database, which includes detailed information on project chapters, budget section information, and individual budget quota information. Read the detailed chapter information of the project and build a chapter directory tree; Read the information from the preliminary budget section and construct the preliminary budget section information table; Link the chapter directory tree to each entry in the budget section information table; Based on the entries in the budget section information table, assign individual budget quota information to each chapter; Determine the quota number before and after replacement, and use the chapter directory tree and budget section information table to batch replace the included individual budget quota information; in: Read the preliminary budget section information and construct a preliminary budget section information table, including: Select the preliminary budget section to read the preliminary budget section information; Filter the relevant quota information belonging to this budget section; Filter out quota information that does not belong to this budget section; Obtain the budget section information table, which contains entries; Link the chapter directory tree to each entry in the budget section information table, including: Select a project section to read the project section details; Determine the hierarchy of the project's chapters and sub-items, and filter out quota information that does not belong to the hierarchy of the project's chapters and sub-items or its subsets; Determine the quota numbers before and after the replacement, and use the chapter directory tree and budget section information table to batch replace the included individual budget quota information, including: Search for the quota number before replacement, and obtain all entries in the budget section information table containing the budget section information corresponding to the quota number. Select the entry you want to replace, and then select the chapter you want to replace in the chapter directory tree; Determine the replacement quota number, and then batch replace all individual budget quota information at the level below the chapter.

2. The method for batch replacement of quotas in single-item budget documents for railway engineering according to claim 1, characterized in that: The project section details include the section entry number and the section name.

3. The method for batch replacement of quotas in single-item budget documents for railway engineering according to claim 2, characterized in that: The information in the budget section includes the total budget number, total budget number, scope of preparation, unit, quantity of work, budget value, and budget index information.

4. The method for batch replacement of quotas in single-item budget documents for railway engineering according to claim 3, characterized in that: The information for individual budget quotas includes quota number, quota name, and unit.

5. The method for batch replacement of quotas in single-item budget documents for railway engineering according to claim 4, characterized in that: Read the detailed chapter information of the project and build a chapter directory tree, including: Iterate through all project chapter details, which have a hierarchical relationship; Construct a chapter directory tree based on the hierarchical relationship of the project's chapter details.

6. The method for batch replacement of quotas in single-item budget documents for railway engineering according to claim 5, characterized in that: Based on the entries in the budget section information table, assign individual budget quota information to each chapter, including: Select the level of the budget section and the level of the project chapter details to limit the quotas to be replaced to the selected range.

7. A system for batch replacement of quotas in single-item budget documents for railway engineering, characterized in that: The system is used to implement the method according to any one of claims 1-6, comprising: The project database creation module is used to create a project database, which contains detailed information on project chapters, budget paragraphs, and individual budget quotas. The chapter directory tree construction module is used to read the detailed chapter information of the project and build the chapter directory tree. The module for constructing the budget section information table is used to read budget section information and construct the budget section information table. The association module is used to associate the chapter directory tree with each entry in the budget section information table; The allocation module is used to allocate individual budget quota information to each chapter based on the entries in the budget paragraph information table. The batch replacement module is used to determine the quota number before and after replacement, and to perform batch replacement of the included individual budget quota information using the chapter directory tree and the budget paragraph information table.

Images