A method for automatically arranging an excel budget estimate table

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 [0001] The invention relates to the field of project budget preparation, in particular to a method for automatically arranging an EXCEL budget estimate table. Background technique [0002] In the field of engineering budget estimation, due to the low efficiency of traditional budget estimation software, it cannot meet the engineering design needs of a large number of sites in communication engineering. Now, it is generally used to prepare budget estimates in batches through EXCEL tables. Although the preparation of the budget estimate through the EXCEL form can achieve a certain efficiency improvement, but there are many budget estimate forms, and data needs to be entered between multiple forms, and there may also be a need to input data between different categories in one form. , so there is a large amount of manual copying and pasting, cutting and pasting, and manual input workload, the work efficiency is still very low, and the possibility of operation err...

AI Technical Summary

Problems solved by technology

[0002] In the field of engineering budget estimation, due to the low efficiency of traditional budget estimation software, it cannot meet the engineering design requirements of a large number of sites in communication engineering. Now, it is generally used to prepare budget estimates in batches through EXCEL tables

Although the preparation of the budget estimate through the EXCEL form can achieve a certain efficiency improvement, but there are many budget estimate forms, and data needs to be entered between multiple forms, and there may also be a need to input data between different categories in one form. , so there is a lot of manual copying and pasting, cutting and pasting, and manual input workload, the work efficiency is still very low, and the possibility of operation errors is very high

Images