CN111898354A - Railway engineering budget estimate file compiling method and device and electronic equipment - Google Patents

Railway engineering budget estimate file compiling method and device and electronic equipment Download PDF

Info

Publication number
CN111898354A
CN111898354A CN202010613039.6A CN202010613039A CN111898354A CN 111898354 A CN111898354 A CN 111898354A CN 202010613039 A CN202010613039 A CN 202010613039A CN 111898354 A CN111898354 A CN 111898354A
Authority
CN
China
Prior art keywords
engineering
project
dictionary
quota
data
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN202010613039.6A
Other languages
Chinese (zh)
Other versions
CN111898354B (en
Inventor
强博兴
杨国庆
胡国荣
王钢
米振宇
孙长江
张德龙
司天文
刘宝龙
邵等玲
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Railway First Survey and Design Institute Group Ltd
Original Assignee
China Railway First Survey and Design Institute Group Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Railway First Survey and Design Institute Group Ltd filed Critical China Railway First Survey and Design Institute Group Ltd
Priority to CN202010613039.6A priority Critical patent/CN111898354B/en
Publication of CN111898354A publication Critical patent/CN111898354A/en
Application granted granted Critical
Publication of CN111898354B publication Critical patent/CN111898354B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/186Templates
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Computational Linguistics (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The disclosure relates to a method, a device and an electronic device for compiling a railway project budget estimate file, wherein the method for compiling the railway project budget estimate file comprises the following steps: determining a first corresponding relation between the engineering quantity data to be processed and the engineering quota based on the quantity code of the engineering quantity data to be processed and the quantity quota dictionary; determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary; counting the engineering quantity by using the small quantity identification based on the second corresponding relation to form a counting result; and obtaining the project budget estimate file based on the first corresponding relation and the statistical result. The technical scheme of the embodiment of the disclosure can solve the problem that quota data used by the same engineering quantity is not uniform due to the fact that engineering cost personnel understand the engineering quantity non-uniformly, can realize integrated operation, and improves the efficiency and accuracy of railway engineering budget estimate planning.

Description

Railway engineering budget estimate file compiling method and device and electronic equipment
Technical Field
The present disclosure relates to the technical field of engineering budget estimate files, and in particular, to a method and an apparatus for railway engineering budget estimate files, and an electronic device.
Background
Currently, in the state iron project, the cost software used by each large design institute is a railway project investment control system. During the budget estimate file, the project cost personnel inputs the project quantity and the corresponding project quota item by item in the software interactive interface.
On the premise that the engineering design period is shorter and the workload is larger and smaller, it is obvious that the mode of inputting the engineering quantity and the corresponding engineering quota one by engineering cost personnel is low in efficiency, and due to the fact that the engineering quantity is not uniformly understood by the engineering cost personnel, the quota data used by the same engineering quantity is not uniform. Obviously, the budget estimate file-making method cannot meet the requirements of the current budget estimate file-making.
Disclosure of Invention
In order to solve the technical problems or at least partially solve the technical problems, the disclosure provides a method and a device for railway engineering budget estimate documentation and an electronic device.
In a first aspect, an embodiment of the present disclosure provides a method for filing a budget estimate of railway engineering, including:
acquiring an engineering quantity input table, wherein the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes;
acquiring a quantity quota dictionary and an engineering quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary;
determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary;
counting the engineering quantity by using the sub-counting quantity identification based on the second corresponding relation to form a counting result;
and obtaining an engineering budget estimate file based on the first corresponding relation and the statistical result.
In a second aspect, an embodiment of the present disclosure further provides a railway engineering budget estimate filing apparatus, including:
the system comprises an engineering quantity input table module, a processing module and a processing module, wherein the engineering quantity input table module is used for acquiring an engineering quantity input table, the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes;
the dictionary acquisition module is used for acquiring a quantity quota dictionary and a project quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
the first corresponding relation determining module is used for determining a first corresponding relation between the engineering quantity data to be processed and the engineering quota based on the quantity code of the engineering quantity data to be processed and the quantity quota dictionary;
the second corresponding relation determining module is used for determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary;
the counting module is used for counting the engineering quantity by using the sub-counting quantity identification based on the second corresponding relation to form a counting result;
and the project budget estimate file generating module is used for obtaining a project budget estimate file based on the first corresponding relation and the statistical result.
In a third aspect, an embodiment of the present disclosure further provides an electronic device, including: a processor and a memory;
the processor is configured to perform the steps of any of the methods described above by calling a program or instructions stored in the memory.
In a fourth aspect, the disclosed embodiments also provide a computer-readable storage medium storing a program or instructions for causing a computer to perform the steps of any of the above methods.
Compared with the prior art, the technical scheme provided by the embodiment of the disclosure has the following advantages:
the technical scheme of the embodiment of the disclosure can solve the problem that quota data used by the same engineering quantity is not uniform due to the fact that engineering cost personnel understand the engineering quantity non-uniformly, can realize integrated operation, and improves the efficiency and accuracy of railway engineering budget estimate planning.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.
In order to more clearly illustrate the embodiments or technical solutions in the prior art of the present disclosure, the drawings used in the description of the embodiments or prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without inventive exercise.
FIG. 1 is a flowchart of a method for filing a budget estimate of railway engineering provided by an embodiment of the present disclosure;
FIG. 2 is a partial schematic view of a user tree structure provided by the present disclosure;
FIG. 3 is a flowchart of another method for railroad engineering budget estimate documentation provided by an embodiment of the present disclosure;
FIG. 4 is a schematic diagram of a user input interface provided by an embodiment of the present disclosure;
FIG. 5 is a block diagram of an engineering budget estimate documentation device according to an embodiment of the present disclosure;
fig. 6 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present disclosure.
Detailed Description
In order that the above objects, features and advantages of the present disclosure may be more clearly understood, aspects of the present disclosure will be further described below. It should be noted that the embodiments and features of the embodiments of the present disclosure may be combined with each other without conflict.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present disclosure, but the present disclosure may be practiced in other ways than those described herein; it is to be understood that the embodiments disclosed in the specification are only a few embodiments of the present disclosure, and not all embodiments.
For the convenience of understanding, the overall development concept of the railway engineering budget estimate filing method provided by the present disclosure is explained first. Firstly, coding the engineering quantity of different engineering specialties, and establishing a standardized engineering quantity dictionary library; secondly, with the result as guidance, researching a project database of engineering cost software (such as a railway engineering investment control system) to find a data input interface of a single budget estimate and a comprehensive budget estimate table; thirdly, establishing a database system for mapping the engineering quantity and the engineering quota and summarizing the engineering quantity according to the data interface form; and finally, inputting the quantity of projects and corresponding design parameters through software programming, generating a result of the data of the railway project budget estimate table, and finishing the compilation of the project budget estimate file.
Fig. 1 is a flowchart of a method for filing a budget estimate of railway engineering according to an embodiment of the present disclosure. The method is executed by a computer. Referring to fig. 1, the method for filing the budget estimate of the railway project comprises the following steps:
s110, acquiring an engineering quantity input table, wherein the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes.
The project quantity data in the project quantity input table is determined and provided by the staff of each specialty of the design institute (such as the rail specialty, the roadbed specialty, the bridge specialty, the tunnel specialty, the station specialty, and the building specialty).
The implementation method of this step may be that after the engineering quantity data is imported by using the research and development software, the imported engineering quantity data is stored in the engineering quantity input table.
S120, acquiring a quantity quota dictionary and a project quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprises the corresponding relation between quantity codes and subtotal quantity identifications.
S130, determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary.
The essence of this step is that the first mapping data in the quantity quota dictionary comprises a correspondence of quantity codes to engineering quotas. And the engineering quantity data to be processed includes a quantity code. Therefore, the first corresponding relation between the engineering quantity data to be processed with consistent quantity codes and the engineering quota can be established.
S140, determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary.
The essence of this step is that the second mapping data in the engineering quantity dictionary includes the corresponding relationship between the quantity code and the sub-quantity identifier. And the engineering quantity data to be processed includes a quantity code. Therefore, a second corresponding relation can be established between the project quantity data to be processed with consistent quantity codes and the subtotal quantity identification.
S150, based on the second corresponding relation, counting the engineering quantity by using the small quantity identification to form a counting result.
Illustratively, the quantities of the projects with consistent sub-quantity identifications are summed to obtain a statistical result corresponding to the sub-quantity identifications.
And S160, obtaining an engineering budget estimate file based on the first corresponding relation and the statistical result.
The specific implementation method of the step can be that the first corresponding relation and the statistical result are input into the engineering cost software to obtain the engineering budget estimate file.
In the above technical solution, the quantity quota dictionary includes a plurality of pieces of first mapping data, the first mapping data includes a correspondence between quantity codes and engineering quotas, and the first correspondence between the engineering quantity data to be processed and the engineering quotas is determined by the quantity quota dictionary, which is substantially that the first mapping data is established in advance, the first mapping data is used as a template, and subsequently, when the first correspondence between the engineering quantity data to be processed and the engineering quotas is determined, the first mapping data is determined according to the first mapping data used as the template. The method can solve the problem that quota data used by the same engineering quantity is not uniform due to the fact that engineering cost personnel understand the engineering quantity non-uniformly.
In addition, in the technical scheme, the first corresponding relation between the engineering quantity data to be processed and the engineering quota and the second corresponding relation between the engineering quantity data to be processed and the subtotal quantity identification are determined according to the quantity codes, and compared with the determination according to the Chinese characters of the engineering quantity, the method can enable the engineering quantities determined by different professional designers to be unified, and avoid the problem that errors occur during computer identification due to the fact that the engineering quantities are not unique in name and the problem of design habits of different professional designers is solved.
In addition, the technical scheme has less data import times, and the probability of data errors can be avoided.
The technical scheme can be developed based on a database system, the identification and quota matching of the engineering quantity codes are carried out by utilizing computer programming, the result data are directly written into the construction cost software project database, the integrated operation is realized, and the efficiency and the accuracy of the railway engineering budget estimate planning are improved.
On the basis of the technical scheme, optionally, at least part of first mapping data in the quantity quota dictionary is associated with the distance coefficient; before S130, the method further includes: acquiring a distance configuration parameter; obtaining an updated distance coefficient based on the distance configuration parameter; updating the quantitative rating dictionary based on the updated distance coefficient; in S130, the quantity quota dictionary is the updated quantity quota dictionary. For example, in a specific design, it is assumed that a certain engineering quota (for example, the engineering quota numbered SY-164) is associated with a distance coefficient, and the distance coefficient is calculated based on the variable a. When constructing the quantity quota dictionary, a function relation between the distance coefficient of the engineering quota (namely the engineering quota with the number of SY-164) and the variable A is preset. Before executing S130, acquiring a distance configuration parameter, assigning the distance configuration parameter to the variable a, and based on a functional relation between the distance coefficient and the variable a, obtaining a distance coefficient currently associated with the project quota (i.e., the project quota numbered SY-164), that is, establishing a corresponding relation between the first mapping data suitable for the project budget estimate documentation at this time and the distance coefficient. By the method, the corresponding relation between all the first mapping data in the quantity rating dictionary and the distance coefficient is updated, and the updated quantity rating dictionary can be obtained. It should be noted that, because the distance configuration parameters that need to be input for different construction projects are often different, the updated quantity rating dictionary is only suitable for the budget estimate documentation of the railway project. The essence of the arrangement is that the quantity quota dictionary before updating has universality, and the quantity quota dictionary with the universality is changed into a special quantity quota dictionary meeting the individual requirements through the distance configuration parameters during the actual engineering budget estimate documentation. In the subsequent steps, the distance coefficient can be transmitted to the first corresponding relation and is led into the engineering cost software, so that the subsequent calculation is facilitated, and the automation level and the accuracy of the engineering budget estimate file compilation are improved.
On the basis of the technical scheme, optionally, at least part of first mapping data in the quantity quota dictionary is associated with the construction method identification; before S130, the method further includes: acquiring construction method identification parameters; screening first mapping data in the quantitative rating dictionary based on construction method identification parameters to form a screened quantitative rating dictionary; in S130, the quantity quota dictionary is the screened quantity quota dictionary. In practice, the same project can be realized by adopting a plurality of methods, for example, the track project can adopt a single sleeper method or a changing and laying method and the like for track laying, and different methods can cause different expenses for completing the project. The method mark is used as the reserve amount or the supplementary explanation amount of the first mapping data by setting at least part of the first mapping data in the quantitative rating dictionary to be related to the method mark, so that the condition applied to the first mapping data is clearer. Subsequently, the first mapping data in the quantitative rating dictionary is screened based on the construction method identification parameters to form a screened quantitative rating dictionary, and in the step S130, the quantitative rating dictionary is the screened quantitative rating dictionary, and the essence is that the first mapping data is subjected to 'cleaning' based on the construction method identification parameters, and the first mapping data inconsistent with the obtained construction method identification parameters is filtered out, so that the efficiency of executing the step S130 can be improved, and the accuracy of the determined first corresponding relation can be improved.
On the basis of the technical scheme, optionally, at least part of the first mapping data in the quantity quota dictionary is associated with the consumption coefficient; and/or; at least a portion of the first mapping data in the quantity quota dictionary is associated with a unit scale factor. The arrangement is favorable for transmitting the consumption coefficient and the unit conversion factor to the first corresponding relation and leading the consumption coefficient and the unit conversion factor into the engineering cost software, thereby facilitating subsequent calculation and improving the automation level and the accuracy of engineering budget estimate documentation.
On the basis of the above technical solutions, optionally, the quantity quota dictionary further includes chapter detail indexes corresponding to the first mapping data; after S130; further comprising: and determining the entry sequence number of each first corresponding relation based on the chapter item index. The entry number refers to an identification number that can be located to a specific entry in the user tree structure (also called chapter details). Illustratively, fig. 2 is a partial schematic diagram of a user tree structure provided by the present disclosure. In fig. 2, the user tree structure includes a plurality of lines of words (a line of words represents an entry), and optionally, the number of lines in which each line of words is located may be used as the entry number of the line of words (the entry). The essence of this is to associate the first correspondence with the user tree structure to make the subsequently generated project budget file easy to review.
On the basis of the foregoing technical solutions, optionally, before S150, the method further includes: acquiring a small counting quantity table, wherein the small counting quantity table comprises a plurality of pieces of third mapping data, and the third mapping data comprises the corresponding relation between small counting quantity identification and chapter detailed index; after S150, the method further includes: determining chapter detailed indexes corresponding to the statistical results based on the third mapping data and the statistical results; and determining the entry sequence number of each statistical result based on the chapter item index. The small counting quantity table is essentially a dictionary and stores the corresponding relation between the small counting quantity identification and the chapter detailed index. The essence of the setting is that the corresponding relation between the statistical result and the chapter detail index is determined based on the subtotal quantity identification; and then determining the entry sequence number of each statistical result based on the chapter item index. This allows statistical results to be associated with the user tree structure to facilitate review of subsequently generated project budget estimate files.
On the basis of the above technical solutions, optionally, after S110, the method further includes;
identifying newly added project quantity data in the project quantity data to be processed; the newly added project quantity data refers to the project quantity data to be processed, which do not have a corresponding relation with all the first mapping data in the quantity quota dictionary and do not have a corresponding relation with all the second mapping data in the project quantity dictionary; and updating the quantity quota dictionary and the project quantity dictionary based on the newly added project quantity data. The newly added project quantity data are not corresponding to all the first mapping data in the quantity quota dictionary, and the newly added project quantity data are not corresponding to all the second mapping data in the project quantity dictionary, so that the quantity quota dictionary and the project quantity dictionary are not perfect at present, and the quantity quota dictionary and the project quantity dictionary are updated subsequently based on the newly added project quantity data. The quantity quota dictionary and the engineering quantity dictionary can be gradually improved.
Fig. 3 is a flowchart of another method for railroad engineering budget estimate documentation, according to an embodiment of the present disclosure. Through the research on the data architecture of the railway engineering cost software project, the data input by the user through the software interface at present are mainly divided into two types: and collecting the total engineering quantity data by rating input data and chapter and detail. Therefore, the function can be assumed by generating necessary data in two tables with the result as a guide. Through research and analysis, in the process of generating two result tables, a dictionary table, a process table and a result table are required to be established in a database, professional design knowledge is stored through the dictionary table, corresponding data calculation processing is carried out in the process table, and the final result is stored in the result table and is used for being imported into a corresponding database table of a cost software background through a program to complete the calculation of the engineering investment.
Illustratively, in fig. 3, the dictionary table includes a project quantity dictionary (storing project quantity dictionary data), a quantity quota dictionary (storing quantity quota mapping data), a small count project quantity table (storing chapter details data). The process table (storing the process data generated in the program running process and needing to be calculated) comprises a coefficient updating table, a quantity quota combination table, a total approximate calculation sequence number entry sequence number adding table, a quantity summarizing identification table and a small project quantity updating table. The result table (storing program to generate result data of cost software) includes quota input table, summary table of small project quantity and new added table of project quantity. The container table (storing project quantity data imported by the user) includes a project quantity input table.
Illustratively, table 1 is a field type included in an engineering quantity dictionary provided by an embodiment of the present disclosure.
TABLE 1 engineering quantity dictionary
Column name Data type Allowable null value Whether or not to make a key
Serial number int yes Whether or not
Quantity coding nvarchar(50) no Whether or not
Description of engineering quantities nvarchar(255) yes Whether or not
Unit of quantity nvarchar(50) yes Whether or not
Small quantity mark 1 int yes Whether or not
…… int yes Whether or not
Small number mark n int yes Whether or not
Referring to table 1, according to the characteristics of different railway engineering specialties, a plurality of small counting quantity marks can be set, the marks are set according to the small counting quantity marks of the small counting engineering quantity table and are used for counting quantity summary items of corresponding chapter details, for example, two small counting quantity marks of a main line and a station line can be set according to the characteristics of the engineering quantity in the rail engineering, and 6 small counting quantity marks can be set according to surrounding rocks 1-6 in the tunnel engineering.
TABLE 2 quantity quota dictionary
Column name Data type Allowable null value Whether or not to make a key
Serial number int no Whether or not
Quantity coding nvarchar(50) no Whether or not
Engineering quota nvarchar(255) yes Whether or not
Name of fee nvarchar(255) yes Whether or not
Unit price of float yes Whether or not
Coefficient of distance traveled nvarchar(50) yes Whether or not
Quota adjustment nvarchar(255) yes Whether or not
Quota unit nvarchar(50) yes Whether or not
Unit conversion factor float yes Whether or not
Chapter detail index int yes Whether or not
Construction method mark int yes Whether or not
Table 2 is the field types included in a quantity quota dictionary provided by an embodiment of the present disclosure. The mapping relation between the engineering quantity in the standard format and the engineering quota is stored in the table 2, so that the problem that designers understand differently and adopt different quotas for the same quantity is solved.
In addition, the quantity quota dictionary is provided with a distance coefficient item to meet individual requirements, in the subsequent step, the distance coefficient can be transmitted to the first corresponding relation and is led into the engineering cost software, the subsequent calculation is facilitated, and the automation level and the accuracy of engineering budget estimate documentation are improved.
Table 2 also sets a unit conversion factor, and performs conversion between the engineering quantity unit and the quota unit, for example, the engineering quantity unit of the steel bar is kg, the quota unit is t, and the engineering quantity unit and the quota unit are unified by the unit conversion factor.
Table 2 also sets chapter detail index entries, which ensures that each project quota can be placed under the correct chapter detail (i.e., corresponding to the correct entry number).
In table 2, an operating method identifier is further provided to improve the efficiency of executing the method for filing the budget estimate of railway engineering provided by the present disclosure, and on the other hand, the accuracy of the determined first corresponding relationship can be improved.
TABLE 3 Small engineering quantity table
Column name Data type Allowable null value Whether or not to make a key
Serial number int no Whether or not
Name (R) nvarchar(50) yes Whether or not
Small quantity mark int yes Whether or not
Small engineering quantity float yes Whether or not
Unit of nvarchar(50) yes Whether or not
Chapter detail index int yes Whether or not
Total approximate serial number int yes Whether or not
Table 3 is a field type included in a small engineering quantity table provided in an embodiment of the present disclosure. The list stores the subtotal quantity identifications of different specialties in the construction software, and sets corresponding chapter and detail index values for the subtotal quantity identifications, and after a user selects the corresponding subtotal quantity identifications in the software using process, the project serial number can be updated according to the index values, so that the correspondence between the project quantity summary items and the chapter and detail (namely, the user tree structure) is ensured.
Table 4 new project quantity table
Figure BDA0002561198370000111
Figure BDA0002561198370000121
Table 4 is a field type included in the project quantity addition table provided in the embodiment of the present disclosure. The table is mainly used for storing newly added items input by the engineering quantity, and after the user imports the engineering quantity input table, items without engineering quantity codes and engineering quantity items which are not contained in the quantity rating dictionary and the engineering quantity dictionary can be automatically screened out, so that the subsequent maintenance of the quantity rating dictionary and the engineering quantity dictionary table in the database is facilitated.
TABLE 5 quota input Table
Figure BDA0002561198370000122
Table 5 is a field type included in a quota input table provided by an embodiment of the present disclosure. The table contains the main fields in the 'quota input' table in the project database in the cost software, and after the result table is generated, the data can be directly written into the project database of the cost software to finish the compilation of single budget estimate.
TABLE 6 summary of small project quantities
Column name Data type Allowable null value Whether or not to make a key
Total approximate serial number int yes Whether or not
Entry sequence number int yes Whether or not
Number of projects 1 float yes Whether or not
Table 6 is a field type included in a summary of the quantity of sub-projects provided by the embodiment of the present disclosure. The table contains the main fields in the 'total approximate calculation item' table in the project database in the cost software, and after the result table is generated, the data can be updated and written into the project database of the cost software, so that the comprehensive budget estimate can be compiled.
Referring to fig. 3 and tables 1 to 6, the method for filing the budget estimate of the railway project will be described in detail, and the method for filing the budget estimate of the railway project includes:
1. after the research and development software is acquired and imported into the engineering quantity data, the software stores the engineering quantity data in an engineering quantity input table.
2. And acquiring the distance configuration parameters and construction method identification parameters input by a user. Illustratively, fig. 4 is a schematic diagram of a user input interface provided by an embodiment of the present disclosure. The distance configuration parameters entered by the user via the user input interface in fig. 4.
3. The software automatically calculates the corresponding distance coefficient in the 'quantity rating dictionary' based on the distance configuration parameters, completes the updating of the quantity rating dictionary and generates a 'coefficient updating table' (namely the updated quantity rating dictionary).
4. The software calls the engineering quantity data in the engineering quantity input table, calls the engineering quota series data selected according to the user condition (namely, construction method identification parameters and the like) in the 'coefficient updating table', matches the engineering quantity with the quota for the same item according to the quantity codes in the two tables, and completes the unit conversion of the quantity by adopting the way of engineering quantity/unit conversion based on the unit conversion factor to generate the 'quantity quota combination table'.
5. The software inserts the data in the 'quantity quota combination table' into the 'total approximate sequence number entry sequence number adding table', and according to the approximate paragraph number (see fig. 4) input by the user in the user input interface approximate paragraph selection box, obtains the total approximate sequence number corresponding to the approximate paragraph number in the project library, and assigns (or is called as 'filling') the total approximate sequence number to the 'total approximate sequence number entry sequence number adding table'; and according to the corresponding relation between the item sequence numbers in the user tree structure and the chapter and detail index, obtaining the item sequence numbers of all the engineering quantities based on the chapter and detail index, and assigning (or filling) the item sequence numbers to the item sequence numbers in the general calculation sequence number item sequence number adding table.
6. The software inserts the processed engineering quantity data, quota data, total approximate calculation serial number and item serial number into a result table, namely a quota input table, assigns the columns of engineering or expense project names in the table to be quota names in a unified mode, assigns programmers to project operators and assigns modification dates to system time.
7. The software inserts the data in the quota input table into the 'quota input' table of the project database of the project cost software, and updates the 'project or expense project name' into an actual name by combining with the standard table in the project cost software, thereby finishing the compilation of single item budget estimate. The corresponding relation between the quota code and the quota name is preset in the standard table, and the quota data comprises the quota code, so that the step of updating the project or expense project name into the actual name can be completed based on the quota code.
8. The software acquires the engineering quantity and the quantity code in the engineering quantity input table, matches the engineering quantity dictionary to acquire the subtotal quantity identification of the engineering quantity input table, and generates a quantity summary identification table.
9. And the software acquires field data in the small project quantity table, inserts the field data into the small project quantity updating table and updates the small project quantity column in the small project quantity updating table by combining the project quantity in the quantity summary identification table. Specifically, the same items of the "small-count quantity identification" are summed, and the obtained "sum" is written into the small-count quantity data item in the "small-count project quantity update table", so that the "sum" corresponds to the corresponding small-count quantity identification, and the corresponding summarization of the project quantity is completed.
10. Updating the units which are not matched with the project quantity unit items of the construction software chapter details, if the unit of the summarized quantity item is kg, the unit of the construction software chapter details is t, and unifying the units.
11. In the small project quantity updating table, according to the approximate calculation paragraph number (see fig. 4) input by the user in the user input interface approximate calculation paragraph selection box, obtaining the total approximate calculation sequence number corresponding to the approximate calculation paragraph number in the project library, and assigning (or filling) the total approximate calculation sequence number to the total approximate calculation sequence number in the small project quantity updating table; and according to the corresponding relation between the item sequence numbers in the user tree structure and the chapter and detail index, obtaining the item sequence numbers of all the project quantities based on the chapter and detail index, and assigning (or filling) the item sequence numbers to the item sequence numbers in the small project quantity updating table.
12. And inserting the total approximate calculation sequence number, the item sequence number and the small amount data in the small project amount updating table into a result table, namely a small project amount summary table, and updating the small amount data into a total approximate calculation item of the construction cost software according to the total approximate calculation sequence number and the item sequence number so as to complete the compilation of the comprehensive approximate budget.
Fig. 5 is a block diagram of a schematic diagram of a railroad engineering budget estimate filing apparatus according to an embodiment of the present disclosure. Referring to fig. 5, the railroad project budget estimate documentation device includes:
an engineering quantity input table module 210, configured to obtain an engineering quantity input table, where the engineering quantity input table includes multiple pieces of to-be-processed engineering quantity data, and the to-be-processed engineering quantity data includes quantity codes;
a dictionary obtaining module 220 for obtaining a quantity quota dictionary and a project quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
a first corresponding relation determining module 230, configured to determine a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary;
a second corresponding relation determining module 240, configured to determine, based on the quantity code of the to-be-processed engineering quantity data and the engineering quantity dictionary, a second corresponding relation between the to-be-processed engineering quantity data and the subtotal quantity identifier;
a counting module 250, configured to count the engineering quantity by using the sub-counting quantity identifier based on the second corresponding relationship to form a counting result;
and the project budget estimate file generating module 260 is configured to obtain a project budget estimate file based on the first corresponding relationship and the statistical result.
The apparatus disclosed in the above embodiments can implement the processes of the methods disclosed in the above method embodiments, and has the same or corresponding beneficial effects, and for avoiding repetition, the details are not described herein again.
Fig. 6 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present disclosure, and as shown in fig. 6, the electronic device includes:
one or more processors 301, one processor 301 being exemplified in fig. 6;
a memory 302;
the electronic device may further include: an input device 303 and an output device 304.
The processor 301, the memory 302, the input device 303 and the output device 304 in the electronic apparatus may be connected by a bus or other means, and fig. 6 illustrates an example of connection by a bus.
The memory 302 is a non-transitory computer-readable storage medium, and can be used for storing software programs, computer-executable programs, and modules, such as program instructions/modules corresponding to the railroad engineering budget estimate filing method of the application program in the embodiment of the present disclosure. The processor 301 executes various functional applications of the server and data processing by running software programs, instructions and modules stored in the memory 302, namely, the railway engineering budget estimate filing method of the above-described method embodiment is realized.
The memory 302 may include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required for at least one function; the storage data area may store data created according to use of the electronic device, and the like. Further, the memory 302 may include high speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, memory 302 optionally includes memory located remotely from processor 301, which may be connected to a terminal device via a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The input device 303 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the electronic apparatus. The output means 304 may comprise a display device such as a display screen.
The disclosed embodiments also provide a computer-readable storage medium containing a program or instructions for causing a computer to execute a method for railroad engineering budget estimate documentation, the method comprising:
acquiring an engineering quantity input table, wherein the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes;
acquiring a quantity quota dictionary and an engineering quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary;
determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary;
counting the engineering quantity by using the sub-counting quantity identification based on the second corresponding relation to form a counting result;
and obtaining an engineering budget estimate file based on the first corresponding relation and the statistical result.
Optionally, the computer executable instructions, when executed by the computer processor, may be further used to implement the technical solution of the method for railroad engineering budget estimate documentation provided by any embodiment of the present disclosure.
From the above description of the embodiments, it is obvious for a person skilled in the art that the present disclosure can be implemented by software and necessary general hardware, and certainly can be implemented by hardware, but in many cases, the former is a better embodiment. Based on such understanding, the technical solutions of the present disclosure may be embodied in the form of a software product, which may be stored in a computer-readable storage medium, such as a floppy disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a FLASH Memory (FLASH), a hard disk or an optical disk of a computer, and includes several instructions for enabling a computer device (which may be a personal computer, a server, or a network device) to execute the methods according to the embodiments of the present disclosure.
It is noted that, in this document, relational terms such as "first" and "second," and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The foregoing are merely exemplary embodiments of the present disclosure, which enable those skilled in the art to understand or practice the present disclosure. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the disclosure. Thus, the present disclosure is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A method for filing a budget estimate of railway engineering, comprising:
acquiring an engineering quantity input table, wherein the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes;
acquiring a quantity quota dictionary and an engineering quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary;
determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary;
counting the engineering quantity by using the sub-counting quantity identification based on the second corresponding relation to form a counting result;
and obtaining an engineering budget estimate file based on the first corresponding relation and the statistical result.
2. The railroad engineering budget estimate filing method according to claim 1,
at least part of first mapping data in the quantity quota dictionary is associated with a distance coefficient;
before determining the first corresponding relationship between the engineering quantity data to be processed and the engineering quota based on the quantity code of the engineering quantity data to be processed and the quantity quota dictionary, the method further includes:
acquiring a distance configuration parameter;
obtaining an updated distance coefficient based on the distance configuration parameter;
updating the quantity quota dictionary based on the updated distance coefficient;
determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary, wherein the quantity quota dictionary is the updated quantity quota dictionary.
3. The railroad engineering budget estimate filing method according to claim 1,
at least part of first mapping data in the quantity quota dictionary is associated with construction method identification;
before determining the first corresponding relationship between the engineering quantity data to be processed and the engineering quota based on the quantity code of the engineering quantity data to be processed and the quantity quota dictionary, the method further includes:
acquiring construction method identification parameters;
screening the first mapping data in the quantity quota dictionary based on the construction method identification parameters to form a screened quantity quota dictionary;
determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary, wherein the quantity quota dictionary is the screened quantity quota dictionary.
4. The railroad engineering budget estimate filing method according to claim 1,
at least part of the first mapping data in the quantity quota dictionary is associated with a consumption coefficient; and/or;
at least a portion of the first mapping data in the quantity quota dictionary is associated with a unit scale factor.
5. The railroad engineering budget estimate documentation method of claim 1 wherein said quantity quota dictionary further includes a chapter detail index corresponding to each of said first mapping data;
after determining a first corresponding relation between the project quantity data to be processed and the project quota based on the quantity code of the project quantity data to be processed and the quantity quota dictionary; further comprising:
and determining the entry sequence number of each first corresponding relation based on the chapter item index.
6. The method according to claim 1, wherein before the counting the project quantity with the small quantity identifier based on the second corresponding relationship to form a statistical result, the method further comprises:
acquiring a small counting quantity table, wherein the small counting quantity table comprises a plurality of pieces of third mapping data, and the third mapping data comprises a corresponding relation between a small counting quantity identifier and a chapter detailed index;
after the counting the engineering quantity by using the sub-counting quantity identifier based on the second corresponding relationship to form a statistical result, the method further includes:
determining chapter detail indexes corresponding to the statistical results based on the third mapping data and the statistical results;
and determining the entry sequence number of each statistical result based on the chapter item index.
7. The railroad project budget estimate filing method according to claim 1, further comprising, after obtaining the project quantity input table, further comprising;
identifying newly added project quantity data in the project quantity data to be processed; the newly added project quantity data refers to the project quantity data to be processed, which do not have a corresponding relationship with all the first mapping data in the quantity quota dictionary and do not have a corresponding relationship with all the second mapping data in the project quantity dictionary;
and updating the quantity quota dictionary and the project quantity dictionary based on the newly added project quantity data.
8. A railroad project budget estimate filing apparatus, comprising:
the system comprises an engineering quantity input table module, a processing module and a processing module, wherein the engineering quantity input table module is used for acquiring an engineering quantity input table, the engineering quantity input table comprises a plurality of pieces of engineering quantity data to be processed, and the engineering quantity data to be processed comprises quantity codes;
the dictionary acquisition module is used for acquiring a quantity quota dictionary and a project quantity dictionary; the quantity quota dictionary comprises a plurality of pieces of first mapping data, and the first mapping data comprise the corresponding relation between quantity codes and engineering quotas; the engineering quantity dictionary comprises a plurality of pieces of second mapping data, and the second mapping data comprise the corresponding relation between quantity codes and subtotal quantity identifications;
the first corresponding relation determining module is used for determining a first corresponding relation between the engineering quantity data to be processed and the engineering quota based on the quantity code of the engineering quantity data to be processed and the quantity quota dictionary;
the second corresponding relation determining module is used for determining a second corresponding relation between the project quantity data to be processed and the subtotal quantity identification based on the quantity code of the project quantity data to be processed and the project quantity dictionary;
the counting module is used for counting the engineering quantity by using the sub-counting quantity identification based on the second corresponding relation to form a counting result;
and the project budget estimate file generating module is used for obtaining a project budget estimate file based on the first corresponding relation and the statistical result.
9. An electronic device, comprising: a processor and a memory;
the processor is adapted to perform the steps of the method of any one of claims 1 to 7 by calling a program or instructions stored in the memory.
10. A computer-readable storage medium, characterized in that it stores a program or instructions for causing a computer to carry out the steps of the method according to any one of claims 1 to 7.
CN202010613039.6A 2020-06-29 2020-06-29 Method and device for programming budget estimate file of railway engineering and electronic equipment Active CN111898354B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010613039.6A CN111898354B (en) 2020-06-29 2020-06-29 Method and device for programming budget estimate file of railway engineering and electronic equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010613039.6A CN111898354B (en) 2020-06-29 2020-06-29 Method and device for programming budget estimate file of railway engineering and electronic equipment

Publications (2)

Publication Number Publication Date
CN111898354A true CN111898354A (en) 2020-11-06
CN111898354B CN111898354B (en) 2023-10-31

Family

ID=73207946

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010613039.6A Active CN111898354B (en) 2020-06-29 2020-06-29 Method and device for programming budget estimate file of railway engineering and electronic equipment

Country Status (1)

Country Link
CN (1) CN111898354B (en)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB201114924D0 (en) * 2010-08-27 2011-10-12 Sandstrom Mark H Application load adaptive processing resource allocation
US20150301903A1 (en) * 2014-04-16 2015-10-22 Commvault Systems, Inc. Cross-system, user-level management of data objects stored in a plurality of information management systems
CN109408906A (en) * 2018-09-30 2019-03-01 中铁第勘察设计院集团有限公司 The method of engineering quantity expression and statistics based on BIM model
CN109472446A (en) * 2018-09-30 2019-03-15 中铁第勘察设计院集团有限公司 Project Budget preparation method based on BIM model
CN111260413A (en) * 2020-01-22 2020-06-09 国网浙江省电力有限公司经济技术研究院 Vector graph-based rapid calculation method for construction cost of power main network engineering

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB201114924D0 (en) * 2010-08-27 2011-10-12 Sandstrom Mark H Application load adaptive processing resource allocation
US20150301903A1 (en) * 2014-04-16 2015-10-22 Commvault Systems, Inc. Cross-system, user-level management of data objects stored in a plurality of information management systems
CN109408906A (en) * 2018-09-30 2019-03-01 中铁第勘察设计院集团有限公司 The method of engineering quantity expression and statistics based on BIM model
CN109472446A (en) * 2018-09-30 2019-03-15 中铁第勘察设计院集团有限公司 Project Budget preparation method based on BIM model
CN111260413A (en) * 2020-01-22 2020-06-09 国网浙江省电力有限公司经济技术研究院 Vector graph-based rapid calculation method for construction cost of power main network engineering

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
刘向阳;李军;隆云国;刘国图;: "基于公路标准化体系的工程量清单智能编制技术", 公路, no. 07, pages 213 - 218 *

Also Published As

Publication number Publication date
CN111898354B (en) 2023-10-31

Similar Documents

Publication Publication Date Title
CN104778540B (en) A kind of equipment for building materiaIs manufacturing BOM management method and management system
CN110292775B (en) Method and device for acquiring difference data
CN103914564A (en) Method and system for updating and warehousing urban pipelines on basis of ArcGIS (geographic information system)
CN111914135A (en) Data query method and device, electronic equipment and storage medium
CN111127068B (en) Automatic pricing method and device for engineering quantity list
CN109636036B (en) Method, system and equipment for enterprise invoice quantity prediction
CN105677625B (en) Processing method is made a report in the collaboration of multi-layer collect statistics report
CN112883042A (en) Data updating and displaying method and device, electronic equipment and storage medium
CN110728422A (en) Building information model, method, device and settlement system for construction project
CN110806977A (en) Test case set generation method and device based on product requirements and electronic equipment
CN106844320B (en) Financial statement integration method and equipment
CN105528293A (en) System and method for selecting test case for regression test
CN113342921A (en) Resource cataloging method and device
CN112613289B (en) Marketing campaign tariff configuration matching selection method
CN111913962B (en) Multi-dimensional annual detail fund planning system and method
CN111898354A (en) Railway engineering budget estimate file compiling method and device and electronic equipment
CN109241167B (en) Table data importing method based on BS framework
CN115809228A (en) Data comparison method and device, storage medium and electronic equipment
JP2012173849A (en) Accounting management system, accounting management method and accounting management program
CN105404608A (en) Formula analysis based complicated index set calculation method and system
CN112287005B (en) Data processing method, device, server and medium
CN115034906A (en) Financial product configuration scheme memorizing and recommending method and system
CN108920749B (en) Pipeline two-dimensional and three-dimensional data updating method and device and computer readable storage medium
JP2020004346A (en) System and method for examining maintenance request, and program
WO2024065407A1 (en) Production scheduling method, electronic device and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant