CN106528512A - EXCEL preliminary budget table automatic compiling method - Google Patents
EXCEL preliminary budget table automatic compiling method Download PDFInfo
- Publication number
- CN106528512A CN106528512A CN201610889385.0A CN201610889385A CN106528512A CN 106528512 A CN106528512 A CN 106528512A CN 201610889385 A CN201610889385 A CN 201610889385A CN 106528512 A CN106528512 A CN 106528512A
- Authority
- CN
- China
- Prior art keywords
- data
- data source
- output
- index
- source table
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to an EXCEL preliminary budget table automatic compiling generation method. The method comprises the steps of generating an EXCEL preliminary budget output table according to a budget compiling rule; compiling a data source table according to scales of items and related item line condition; automatically coding the items of the data source table through a data processing module; and realizing an automatic operation of automatically indexing the data of the data source table to the output table through an automatic index mechanism according to a generated classification index serial number string. Through adoption of the technical scheme of the method, automatic classification index output can be realized; the method is characterized in visualized interface, accurate data positioning and high adjustment operation automation; and through combination of a pointer positioning method, the preliminary budget automatic compiling of mass stations can be realized.
Description
Technical field
A kind of the present invention relates to construction budget establishment field, more particularly to EXCEL preliminary budgets form automatic editing method.
Background technology
Field is worked out in Project Budget, due to traditional Software of Budgetary Estimation establishment efficiency it is low, it is impossible to meet communication engineering
The engineering design demand of middle high-volume website, typically now by Microsoft Excel batch establishment preliminary budget.By Microsoft Excel
Although establishment preliminary budget can realize certain improved efficiency, preliminary budget form has many, need multiple forms it
Between also likely to be present between different classes of the demand of input data respectively in input data, and a form, therefore exist
Substantial amounts of manually duplication is pasted, shears the workload pasted, manually enter, and operating efficiency is still very low, and operates
The possibility of error is very big.
The content of the invention
It is an object of the invention to provide a kind of EXCEL preliminary budgets form automatic editing method, by data processing module
Automation layout is carried out to EXCEL preliminary budgets form, form establishment efficiency is greatly improved, while also greatly improving input
Accuracy, while also provide the window that good data are integrally verified or checked to user in " data source " table.
For achieving the above object, the present invention employs the following technical solutions realization：A kind of EXCEL preliminary budgets form automatic editing
Method, it is characterised in that comprise the following steps：
（1）According to work or the output requirement rules of engineering, the output table sample formula for generating is formulated, table is exported according to the demand
Lattice, output lattice are one or more, and each described item line of output and form are determined according to computation rule；
（2）According to work or the output requirement rules of engineering, the Data source table for generating is formulated, the Data source table is data
The intersection in source, is all data directories and the original data source for redirecting automatically index；
（3）Service data processing module, carries out autocoding to project in Data source table, builds jump automatically to described output table
Turn index, realize redirecting automatically index function between different index table.
Further, the classification according to item line, realizes the automatic of different classifications item line by the module of autocoding
Coding.
Further, export table to be gone here and there according to classified index numbering, be automatically obtained the automatic of grouped data from Data source table
Redirect index.
In an embodiment of the present invention, step（3）Including step in detail below：In the Data source table inserting sorting and
Classified index numbering row；The inserting sorting index number row in each sublist of input table；Category column in Data source table sets
Combobox is put, the option of combobox is the classification item for sublist classified index；By database coding module, in category column
Classification item carry out data number, be generated to classified index numbering row, described coding module is to be existed according to same classification item
The sequencing that form occurs, generates the data of a classification item+numbering；In the classified index numbering of each sublist of output table
Classification in row according to classified index, generates a classified index numbering string；Data directory is built in output table and Data source table
Link, the data directory are linked as in the data field of output table by the number in classified index numbering string indexing Data source table
According to content.
The present invention adopts above technical scheme, by the input to item line in " Data source table ", or off-the-shelf item row
The adjustment of classification, then by data coding module automatic numbering, it is achieved that the data automatic indexing of " Data source table " to " output
Table " is automatically brought into operation.The application of the technical scheme, realizes the automatic classified index output that " Data source table " arrives " output table ",
Have interface visual intuitively to change, data accurate positioning, adjustment operation automation it is high the features such as, in conjunction with needle locating method, can
To realize that the preliminary budget of high-volume website is worked out automatically.
Description of the drawings
Fig. 1 is the broad flow diagram of the present invention.
Specific embodiment
Explanation is further explained to the present invention with specific embodiment below in conjunction with the accompanying drawings.
Referring to Fig. 1, the present invention provides a kind of EXCEL preliminary budgets form automatic editing method, comprises the following steps：
（1）According to work or the output requirement rules of engineering, the output table sample formula for generating is formulated, table is exported according to the demand
Lattice, output lattice are one or more, and each described item line of output and form are determined according to computation rule；
（2）According to work or the output requirement rules of engineering, the Data source table for generating is formulated, the Data source table is data
The intersection in source, is all data directories and the original data source for redirecting automatically index；
（3）Service data processing module, carries out autocoding to project in Data source table, builds jump automatically to described output table
Turn index, realize redirecting automatically index function between different index table.
Further, the classification according to item line, realizes the automatic of different classifications item line by the module of autocoding
Coding.
Further, export table to be gone here and there according to classified index numbering, be automatically obtained the automatic of grouped data from Data source table
Redirect index.
In the specific embodiment of the present invention, mainly include the following steps that：
（1）Establishment EXCEL preliminary budgets " output table "：According to preliminary budget computation rule, EXCEL preliminary budget blank template tables are worked out
Lattice；
（2）Establishment EXCEL preliminary budgets " Data source table "：According to the scale and the item line situation being related to of project, organized data
Source table.
（3）The preliminary budget form automatic editing：Service data processing module, to the preliminary budget " output table " basis
Classification is filled up to " output table " corresponding column locations automatically for the item line of " Data source table " and allocation rule.
In order to realize step（3）In automatic editing, needs build between " input table " and " Data source table " data pass
Connection, builds data correlation and performs following steps：
1) insertion " classification " and " classified index numbering " row in " Data source table "；Insert in each sublist of " input table "
Enter " classified index numbering " row.
2) category column in " Data source table " arranges combobox, and the option of combobox is the class for sublist classified index
Mesh item, such as " table three ", " four cable main material of table ", " four optical cable main material of table ", " table tetramethyl supplies main material ", " table tetrem supplies main material " ...；
3) by database coding module, data number is carried out to the classification item in " classification " row, is generated to " classified index volume
Number " row, described coding module is the sequencing occurred in form according to same classification item（Can be discontinuous, wear
Slotting）, the data of a classification item+numbering are generated, such as table 31, table 32, table 33, four optical cable main material 1 of table, table tetramethyl are for master
Material 1, table tetramethyl supply main material 2, table 34 ...；
4) classification in " classified index numbering " row of each sublist of " output table " according to " classified index ", generates one point
Class index number string, such as table 31, table 32 ... table 3 100；Four optical cable main material 1 of table, four optical cable main material 2. ... table of table, four optical cable
Main material 100.
5) build data directory at " output table " with " Data source table " to link, the data directory is linked as at " output table "
Data field in by the data content in classified index numbering string indexing " Data source table ".
Above the object, technical solutions and advantages of the present invention have been described in detail, it is be should be understood that the above
Only presently preferred embodiments of the present invention, not to limit the present invention, it is all within the spirit and principles in the present invention, made
Any modification, equivalent substitution and improvements etc., should be included within the scope of the present invention.
Claims (4)
1. a kind of EXCEL preliminary budgets form automatic editing method, it is characterised in that comprise the following steps：
（1）According to work or the output requirement rules of engineering, the output table sample formula for generating is formulated, table is exported according to the demand
Lattice, output lattice are one or more, and each described item line of output and form are determined according to computation rule；
（2）According to work or the output requirement rules of engineering, the Data source table for generating is formulated, the Data source table is data
The intersection in source, is all data directories and the original data source for redirecting automatically index；
（3）Service data processing module, carries out autocoding to project in Data source table, builds jump automatically to described output table
Turn index, realize redirecting automatically index function between different index table.
2. EXCEL preliminary budgets form automatic editing method according to claim 1, it is characterised in that：According to item line
Classification, realizes the autocoding of different classifications item line by the module of autocoding.
3. EXCEL preliminary budgets form automatic editing method according to claim 2, it is characterised in that：Output table according to divide
Class index number string, be automatically obtained the grouped data from Data source table redirect index automatically.
4. EXCEL preliminary budgets form automatic editing method according to claim 1, it is characterised in that：Step（3）Including with
Lower concrete steps：
1) inserting sorting and classified index numbering row in the Data source table；The inserting sorting rope in each sublist of input table
Draw numbering row；
2) category column in Data source table arranges combobox, and the option of combobox is the classification item for sublist classified index；
3) by database coding module, data number is carried out to the classification item in category column, is generated to classified index numbering row,
Described coding module is the sequencing occurred in form according to same classification item, generates the number of a classification item+numbering
According to；
4) classification in the classified index numbering row of each sublist of output table according to classified index, generates a classification rope
Draw numbering string；
5) build data directory in output table and Data source table to link, the data directory is linked as in the data field of output table
By the data content in classified index numbering string indexing Data source table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610889385.0A CN106528512B (en) | 2016-10-12 | 2016-10-12 | A kind of EXCEL preliminary budget table automatic editing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610889385.0A CN106528512B (en) | 2016-10-12 | 2016-10-12 | A kind of EXCEL preliminary budget table automatic editing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106528512A true CN106528512A (en) | 2017-03-22 |
| CN106528512B CN106528512B (en) | 2019-05-21 |
Family
ID=58331472
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610889385.0A Active CN106528512B (en) | 2016-10-12 | 2016-10-12 | A kind of EXCEL preliminary budget table automatic editing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106528512B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN109634492A (en) * | 2018-10-23 | 2019-04-16 | 中国平安人寿保险股份有限公司 | Combobox designated value input method, device and computer readable storage medium |
| CN109685585A (en) * | 2019-02-13 | 2019-04-26 | 中国石油工程建设有限公司 | Petroleum gas cost compilation integral system and method |
| CN111025010A (en) * | 2019-11-25 | 2020-04-17 | 科华恒盛股份有限公司 | Method and device for measuring active response time of equipment and terminal equipment |
| CN111626029A (en) * | 2020-05-30 | 2020-09-04 | 阶梯项目咨询有限公司 | Budget method and device for project consultation, electronic equipment and computer-readable storage medium |
| CN113902479A (en) * | 2021-10-12 | 2022-01-07 | 广东省电信规划设计院有限公司 | Method and device for processing communication engineering budget estimate |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100293450A1 (en) * | 2009-05-14 | 2010-11-18 | Ratkowski Richard R | System and method for simulating discrete financial forecast calculations |
| CN105183709A (en) * | 2015-08-28 | 2015-12-23 | 国脉科技股份有限公司 | EXCEL budget estimate table layout method |
| CN105512392A (en) * | 2015-12-03 | 2016-04-20 | 国网安徽省电力公司阜阳供电公司 | State grid ERP material device coding and application system |
-
2016
- 2016-10-12 CN CN201610889385.0A patent/CN106528512B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100293450A1 (en) * | 2009-05-14 | 2010-11-18 | Ratkowski Richard R | System and method for simulating discrete financial forecast calculations |
| CN105183709A (en) * | 2015-08-28 | 2015-12-23 | 国脉科技股份有限公司 | EXCEL budget estimate table layout method |
| CN105512392A (en) * | 2015-12-03 | 2016-04-20 | 国网安徽省电力公司阜阳供电公司 | State grid ERP material device coding and application system |
Non-Patent Citations (1)
| Title |
|---|
| 马飞飞: ""全国矿产资源潜力评价数据模型管理系统实现"", 《中国优秀硕士学位论文全文数据库 基础科学辑》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN109634492A (en) * | 2018-10-23 | 2019-04-16 | 中国平安人寿保险股份有限公司 | Combobox designated value input method, device and computer readable storage medium |
| CN109685585A (en) * | 2019-02-13 | 2019-04-26 | 中国石油工程建设有限公司 | Petroleum gas cost compilation integral system and method |
| CN111025010A (en) * | 2019-11-25 | 2020-04-17 | 科华恒盛股份有限公司 | Method and device for measuring active response time of equipment and terminal equipment |
| CN111025010B (en) * | 2019-11-25 | 2022-03-11 | 科华恒盛股份有限公司 | Method and device for measuring active response time of equipment and terminal equipment |
| CN111626029A (en) * | 2020-05-30 | 2020-09-04 | 阶梯项目咨询有限公司 | Budget method and device for project consultation, electronic equipment and computer-readable storage medium |
| CN113902479A (en) * | 2021-10-12 | 2022-01-07 | 广东省电信规划设计院有限公司 | Method and device for processing communication engineering budget estimate |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106528512B (en) | 2019-05-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528512A (en) | EXCEL preliminary budget table automatic compiling method | |
| CN104915378B (en) | A kind of statistics task quick-speed generation system and method suitable for big data | |
| CN110543303B (en) | Visual service platform | |
| US20230419024A1 (en) | Method, system, and computing device for facilitating private drafting | |
| CN100474318C (en) | Automatic generation system for designing BOM | |
| CN103631969A (en) | Generation method and device of report data | |
| CN105843821A (en) | Data processing method and system capable of configuring reports | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN104615713A (en) | SQL executing method and device based on multiple database types | |
| CN110597842A (en) | Service data query method and system | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN102360336A (en) | Automatic testing system based on grammatical rules and method | |
| CN105320806A (en) | Method for summarizing nuclear power technology piping materials by combing PML with Excel-VBA to perform data processing | |
| CN101777073A (en) | Data conversion method based on XML form | |
| CN103197932A (en) | Component business model for developing application of modeless documental database | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| CN107193906B (en) | Method and device for generating process pipeline instrument diagram bill of materials | |
| CN101510124B (en) | Context relevant sensitization cue input method | |
| CN103885810A (en) | Gerber file compiler based on regular expressions | |
| CN106127863A (en) | A kind of refrigerator foaming die series design system and method thereof | |
| CN110989999A (en) | Code generation method and device, electronic equipment and medium | |
| CN102004666A (en) | Large-scale computer operation scheduling equipment and system | |
| CN103488743A (en) | Page element extraction method and page element extraction system | |
| CN101488164A (en) | Method for generating patent application files related to invention creation | |
| CN101488165A (en) | Patent application file generation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | 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 |