CN102270226A - Budget data summarization system - Google Patents
Budget data summarization system Download PDFInfo
- Publication number
- CN102270226A CN102270226A CN2011101774449A CN201110177444A CN102270226A CN 102270226 A CN102270226 A CN 102270226A CN 2011101774449 A CN2011101774449 A CN 2011101774449A CN 201110177444 A CN201110177444 A CN 201110177444A CN 102270226 A CN102270226 A CN 102270226A
- Authority
- CN
- China
- Prior art keywords
- budget
- variable region
- cell
- data
- dimension values
- 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
Images
Abstract
The invention provides a budget data summarization system of an Excel budget sheet. The system comprises the following devices: a budget sample sheet defining device, which is located at an Excel client, and is used for defining information of a variable area of the budget sample sheet and transmitting the budget sample sheet to a budget sample sheet issuing device; the budget sample sheet issuing device, which is located in a server, and is used for selecting a budget main body to which the budget sample sheet is issued, generating the corresponding budget sheet and transmitting the budget sheet to a corresponding budget sheet editing device; the budget sheet editing device, which is located at the Excel client, and is used for editing the variable area of the budget sheet and storing the budget data, and transmitting the edited budget sheet to a budget sheet summarization device; the budget sheet summarization device, which is used for summarizing the budget data of the budget sheet from bottom to top according to a rank order of the budget sheet. The technical scheme of the invention can flexibly define the variable area of the budget sheet, and also can flexibly edit the budget sheet in the variable area and automatically summarize the budget data, thereby improving work efficiency and further improving readability of the budget sheet.
Description
Technical field
The present invention relates to field of computer technology, in particular to the budget data aggregation system.
Background technology
Along with scope of the enterprise increases, subordinate's budget main body of higher level's budget main body is more and more, budget dimension at same type, the dimension values scope that each subordinate's budget main body is got may be all different, for example, budget dimension " expense " comprises " transportation expenses ", " administrative expenses ", " charges for water and electricity ", " property fees " 4 dimension values.And subordinate's budget main body A only comprises " transportation expenses ", " administrative expenses "; The budget main body B of subordinate only comprises " administrative expenses ", " charges for water and electricity "; The budget main body C of subordinate only comprises " charges for water and electricity ", " property fees ".If higher level's budget main body is that subordinate's budget main body A, B, C make budget sample table respectively at this situation, that just needs to make 3 sample tables, is handed down to subordinate's budget main body A, B, C then respectively, can make the workload of higher level's budget main body very big like this.If but higher level's budget main body is only made a budget sample table, all expenses all are listed on this budget sample table, be handed down to subordinate's budget main body A, B, C then respectively, the expense that the budget table that can cause subordinate's budget main body A, B, C to obtain so again exists some budget main bodys itself not comprise respectively, the redundancy that causes the budget table dimension values makes budget table unintelligible, readable poor.
Therefore, need a kind of budget data treatment technology, can avoid higher level's budget main body hard work amount, also can avoid budget table to have the problem of readable difference.
Summary of the invention
Technical matters to be solved by this invention is, a kind of budget data aggregation system of Excel budget table is provided, and can define the variable region of budget table flexibly, improves the work efficiency that budget data gathers.
A kind of budget data aggregation system of Excel budget table is provided, comprises: budget sample table definition device, can be positioned at the Excel client, be used to define budget sample table the variable region information and described budget sample table is sent to transmitting apparatus under the budget sample table; Transmitting apparatus under the described budget sample table can be positioned at server, is used to the budget main body of selecting described budget sample table to issue, and generates corresponding budget table, and described budget table is sent to corresponding budget table scheduling apparatus; Described budget table scheduling apparatus can be positioned at the Excel client, is used for budget data is worked out and preserved in the described variable region of described budget table, the described budget table after the establishment is sent to budget table gathers device; Described budget table gathers device, can be positioned at server, from bottom to top the budget data of described budget table is gathered according to the class of described budget table order.
In technique scheme, preferably, can also comprise: the variable region information-storing device, be used to store the information of the variable region of described budget table, the information of described variable region comprises variable region type, variable region structure and/or variable region budget data, described variable region type comprises capable variable region and row variable region, and described variable region structure comprises variable region classified information, variable region gauge outfit information and variable region budget data information.
In technique scheme, preferably, described variable region classified information is used to write down the scope and the type information of the described variable region of described budget table, described variable region gauge outfit information is used to write down the budget dimensional information of variable region gauge outfit, and described variable region budget data information is used for writing down the budget data information of each Excel cell correspondence of data field, variable region.
In technique scheme, preferably, the structure of described variable region classified information can comprise the dimension type of described variable region type, variable region title, variable region initial row number/row number, variable region line number/columns and variable region, the structure of described variable region gauge outfit information comprises affiliated variable region, cell name, dimension values, row number and row number, and the structure of described variable region budget data comprises affiliated variable region, cell name, variable region cell dimension values combinational code and budget data.
In technique scheme, preferably, described budget sample table definition device can comprise: definition unit, variable region, be used to select the presumptive area of Excel and it is defined as the variable region, the described variable region type of described variable region is set, generates the described variable region title that is used for the described variable region of unique identification automatically; Delete the unit, variable region, be used to delete the described variable region of definition; The variable region template(-let) is set, is used to be provided with the dimension type of the described variable region of selection.
In technique scheme, preferably, described budget table scheduling apparatus can comprise: expansion unit, variable region is used for the variable region of described budget table is increased or deleting variable row/row according to described variable region type; Dimension values binding unit is used for the variable region gauge outfit according to the described budget table of dimension type design of described variable region, filters out all dimension values under the dimension type of described variable region, and the described dimension values of selecting is tied to the cell of choosing; The estimating data cell is used to be received in the budget data of described variable region data field typing, works out described budget data.
In technique scheme, preferably, described budget table scheduling apparatus can also comprise: dimension values combinational code computing unit, with the described cell of described variable region is the center according to direction left and upward to the dimension values of all gauge outfits of the described cell correspondence that finds described variable region, the order of connection according to described dimension type connects described dimension values, generate the described dimension values combinational code of the described cell of described variable region, the described budget data that described dimension values combinational code is corresponding unique.
In technique scheme, preferably, described budget table gathers the budget table of device reception from described budget table scheduling apparatus, the cell of each described variable region of traversal described budget table of subordinate and the described budget table of higher level, dimension values combinational code and combinational code matched rule according to the cell of described variable region, find the cell with the described variable region of the described budget table of subordinate of the cell coupling of the described variable region of the described budget table of higher level, the described budget data of the cell correspondence of the described variable region of subordinate of coupling is added to the described budget data of cell of the described variable region of higher level of coupling.
In technique scheme, preferably, described budget table gathers device and can comprise: first scanning element, be used to scan the cell of the described variable region of the described budget table of higher level, obtain the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region, with described budget data zero clearing; Second scanning element is used to scan the cell of the described variable region of the described budget table of subordinate, obtains the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region; Gather the unit, the described dimension values combinational code that the cell of the described variable region of the described budget table of higher level that the described dimension values combinational code of the cell correspondence of the described variable region of the described budget table of subordinate that described second scanning element is obtained and described first scanning element are obtained is corresponding mates according to described combinational code matched rule, if the match is successful, then the described budget data of the cell correspondence of the described variable region of the described budget table of subordinate is added to the described budget data of cell correspondence of the described variable region of the described budget table of higher level.
In technique scheme, preferably, described combinational code matched rule is for after all removing the corresponding part of the corresponding described budget main body of described budget table in the described dimension values combinational code of the described budget table correspondence of the higher level described dimension values combinational code corresponding with subordinate described budget table, whether the described dimension values combinational code combinational code that the described dimension values combinational code combinational code of judging the described budget table correspondence of remaining higher level and remaining subordinate described budget table are corresponding is identical, if judgement is identical, then the described dimension values combinational code that the described budget table of the described dimension values combinational code of the described budget table correspondence of higher level and subordinate is corresponding mates.
Description of drawings
Fig. 1 shows the block diagram of budget data aggregation system according to an embodiment of the invention;
Fig. 2 shows the block diagram according to budget sample table definition device in the budget data aggregation system of the embodiment of the invention;
Fig. 3 shows the block diagram according to budget table scheduling apparatus in the budget data aggregation system of the embodiment of the invention;
Fig. 4 shows the block diagram that gathers device according to budget table in the budget data aggregation system of the embodiment of the invention; And
Fig. 5 shows the process synoptic diagram according to budget sample table definition and budget table establishment in the budget data aggregation system of the embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with the drawings and specific embodiments.
Set forth a lot of details in the following description so that fully understand the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following public specific embodiment.
Fig. 1 shows the block diagram of budget data aggregation system according to an embodiment of the invention.
As shown in Figure 1, the budget data aggregation system 100 of Excel budget table can comprise according to an embodiment of the invention: budget sample table definition device 102, can be positioned at the Excel client, be used to define budget sample table the variable region information and described budget sample table is sent to transmitting apparatus 104 under the budget sample table; Transmitting apparatus 104 under the described budget sample table can be positioned at server, is used to the budget main body of selecting described budget sample table to issue, and generates corresponding budget table, and described budget table is sent to corresponding budget table scheduling apparatus 106; Described budget table scheduling apparatus 106 can be positioned at the Excel client, is used for budget data is worked out and preserved in the described variable region of described budget table, the described budget table after the establishment is sent to budget table gathers device 108; Described budget table gathers device 108, is positioned at described server, from bottom to top the budget data of described budget table is gathered according to the class of described budget table order.Like this, the variable region by definition budget sample table makes subordinate's budget main body come budget table is worked out flexibly according to actual conditions, and the budget table after the budget main body at different levels establishment can be unified to gather.
In technique scheme, preferably, can also comprise: variable region information-storing device 110, be used to store the information of the variable region of described budget table, the information of described variable region comprises variable region type, variable region structure and/or variable region budget data, described variable region type comprises capable variable region and row variable region, and described variable region structure comprises variable region classified information, variable region gauge outfit information and variable region budget data information.
In technique scheme, preferably, described variable region classified information is used to write down the scope and the type information of the described variable region of described budget table, described variable region gauge outfit information is used to write down the budget dimensional information of variable region gauge outfit, and described variable region budget data information is used for writing down the budget data information of each Excel cell correspondence of data field, variable region.
In technique scheme, preferably, the structure of described variable region classified information can comprise the dimension type of described variable region type, variable region title, variable region initial row number/row number, variable region line number/columns and variable region, the structure of described variable region gauge outfit information comprises affiliated variable region, cell name, dimension values, row number and row number, and the structure of described variable region budget data comprises affiliated variable region, cell name, variable region cell dimension values combinational code and budget data.
In technique scheme, preferably, as shown in Figure 2, described budget sample table definition device 102 can comprise: definition unit, variable region 1022, be used to select the presumptive area of Excel and it is defined as the variable region, the described variable region type of described variable region is set, generates the described variable region title that is used for the described variable region of unique identification automatically; Delete unit, variable region 1024, be used to delete the described variable region of definition; Variable region template(-let) 1026 is set, is used to be provided with the dimension type of the described variable region of selection.
In technique scheme, preferably, as shown in Figure 3, described budget table scheduling apparatus 106 can comprise: expansion unit, variable region 1062 is used for the variable region of described budget table is increased or deleting variable row/row according to described variable region type; Dimension values binding unit 1064 is used for the variable region gauge outfit according to the described budget table of dimension type design of described variable region, filters out all dimension values under the dimension type of described variable region, and the described dimension values of selecting is tied to the cell of choosing; Estimating data cell 1066 is used to be received in the budget data of described variable region data field typing, works out described budget data.
In technique scheme, preferably, as shown in Figure 4, described budget table scheduling apparatus 106 can also comprise: dimension values combinational code computing unit 1068, with the described cell of described variable region is the center according to direction left and upward to the dimension values of all gauge outfits of the described cell correspondence that finds described variable region, the order of connection according to described dimension type connects described dimension values, generate the described dimension values combinational code of the described cell of described variable region, the described budget data that described dimension values combinational code is corresponding unique.
In technique scheme, preferably, described budget table gathers the budget table that device 108 receives from described budget table scheduling apparatus 106, the cell of each described variable region of traversal described budget table of subordinate and the described budget table of higher level, dimension values combinational code and combinational code matched rule according to the cell of described variable region, find the cell with the described variable region of the described budget table of subordinate of the cell coupling of the described variable region of the described budget table of higher level, the described budget data of the cell correspondence of the described variable region of subordinate of coupling is added to the described budget data of cell of the described variable region of higher level of coupling.
In technique scheme, preferably, as shown in Figure 5, described budget table gathers device 108 and can comprise: first scanning element 1082, be used to scan the cell of the described variable region of the described budget table of higher level, obtain the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region, with described budget data zero clearing; Second scanning element 1084 is used to scan the cell of the described variable region of the described budget table of subordinate, obtains the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region; Gather unit 1086, the described dimension values combinational code that the cell of the described variable region of the described budget table of higher level that the described dimension values combinational code of the cell correspondence of the described variable region of the described budget table of subordinate that described second scanning element is obtained and described first scanning element are obtained is corresponding mates according to described combinational code matched rule, if the match is successful, then the described budget data of the cell correspondence of the described variable region of the described budget table of subordinate is added to the described budget data of cell correspondence of the described variable region of the described budget table of higher level.
In technique scheme, preferably, described combinational code matched rule is for after all removing the corresponding part of the corresponding described budget main body of described budget table in the described dimension values combinational code of the described budget table correspondence of the higher level described dimension values combinational code corresponding with subordinate described budget table, whether the described dimension values combinational code combinational code that the described dimension values combinational code combinational code of judging the described budget table correspondence of remaining higher level and remaining subordinate described budget table are corresponding is identical, if judgement is identical, then the described dimension values combinational code that the described budget table of the described dimension values combinational code of the described budget table correspondence of higher level and subordinate is corresponding mates.
Realized that by technique scheme the user can define the variable region flexibly when budget sample table designs, use Excel to carry out the design and the establishment of budget table variable region easily, after working out, submit budget data to server by preserving budget table, and adopt method from bottom to top to gather subordinate's budget table variable region budget data, reaching customer data gathers automatically, satisfied user's demand, simplified user's operation, and improved the work efficiency of budget sample table design with budget compilation.
For ease of understanding the principle of budget table aggregation system of the present invention, at first some notions are made an explanation and illustrate with following example.
Variable region definition: in budget table template definition-budget table establishment pattern, in Excel during detailed estimate table template, if certain opens the overall format relative fixed of budget table, but content and line number, columns can be expanded (unfixing) in the table under budget table establishment pattern, then certain row or certain row are defined as the variable region.The variable region is divided into capable variable region and row variable region.
The row variable region: if budget table title, project, table tail form fix, but content in the table, line number are variable when each establishment main body establishment, then are called capable variable region.
(shown in the table 1) Gross Profit from Sales budget table template in the following example is the row variable region with the concrete Product Definition of table body, and when then the budget table template being handed down to each budget table establishment main body establishment, each works out main body will go the expansion establishment according to selling kind separately.
Row variable region example:
Table 1
Table 1 is the budget table (sample table) of higher level's budget body design, if column heading, columns are variable, then is called the row variable region.
(shown in the table 2) departmental expenses budget table template in the following example is defined as the row variable region with the concrete department of table body, and when then the budget table template being handed down to each budget table establishment main body establishment, each is worked out main body and will be listed as expansion according to department's quantity separately and work out.
Row variable region example:
Table 2
Department in the table 2 classifies the variable region as, and subordinate respectively works out main body and can design voluntarily and work out.
Utilize Excel the variable region to be defined out, and after budget sample table issues, when the budget table of budget main body correspondence is worked out, can design and work out the variable region of budget table in the sample table design phase.
Specify the each several part principle of budget data aggregation system of the present invention below:
1. the variable region information-storing device 110
This variable region information-storing device is stored the information of each variable region of Excel budget table, and the variable region information that adopts the XML structure to store the Excel budget table, and the XML structure is as shown in table 3 below:
| ＜variable region classified information 〉 | ＜variable region gauge outfit information 〉 | ＜variable region budget data information 〉 |
Table 3
In this XML structure＜the variable region classified information〉information such as scope of comprising of each variable region of partial record Excel budget table, type, variable region classified information structure is as shown in table 4 below:
Table 4
Wherein, " the variable region type " in the classified information structure of variable region is divided into capable variable region, row variable region, and the indication variable region is to expand or expand by the Excel row by Excel is capable; The code name of " variable region title " definition variable region is as the unique identification of variable region; The starting position of " variable region initial row number/row number " record variable region, if " variable region type " is the row variable region, then should " variable region initial row number/row number " expression variable region initial row number, otherwise initial row in expression variable region number; Line number/columns that " variable region line number/columns " record variable region takies, if " variable region type " is the row variable region, the line number that the expression variable region takies, otherwise the columns that the expression variable region takies; The type of the dimension values that " variable region dimension type " record variable region can be selected, when budget sample table definition after the dimension type of variable region, subordinate's budget main body is when designing the variable region of budget sample table, and the dimension values that can only select for use the dimension values type to equal " variable region dimension type " is filled the variable region.
And wherein＜variable region gauge outfit information〉write down the budget dimensional information of variable region gauge outfit, its structure is as shown in table 5 below:
| Affiliated variable region | Cell name | Dimension values | Capable number | Row number |
Table 5
Wherein, the title of variable region under " affiliated variable region " record Excel cell.The unique identification of " cell name " record cell lattice.Dimension values that " dimension values " record cell lattice are bound sign, and the type of dimension values can only equal variable region correspondence＜variable region classified information under the cell〉in " variable region dimension type "." row number ", " row number " are the row and column under the record cell lattice respectively, is used for the position of positioning unit lattice at the Excel table.
And wherein＜variable region budget data information〉write down the budget data information of each Excel cell correspondence of data field, variable region, its structure is as shown in table 6 below:
| Affiliated variable region | Cell name | Variable region cell dimension values combinational code | Budget data |
Table 6
Wherein, the title of variable region under " affiliated variable region " record cell lattice.The unique identification of " cell name " record cell lattice.The combinational code that " variable region cell dimension values combinational code " record will all dimension values relevant with data field, variable region cell be spliced into according to set dimension type arrangement order.Counting in advance of " budget data " recording user establishment.
Technical scheme of the present invention is by above-mentioned variable region information-storing device, information stores such as the type of each variable region of Excel budget table, structure, budget data are got off, design and the establishment information done at the variable region during with user's estimating table are noted, as the part of whole Excel budget table.
2. budget sample table definition device 102
Budget sample table definition device is the plug-in unit of expansion at the Excel end, can comprise following unit:
Definition unit, variable region: full line or permutation that this unit is selected according to the user are the variable region with the zone definitions of selecting.If selecteed zone is a full line, the variable region type is set is the row variable region; If selecteed zone is a permutation, the variable region type is set is the row variable region; The variable region title is generated automatically by budget sample table definition device, is used for the variable region of unique identification definition.When storing, this device the definition information of variable region can be written to above-mentioned variable region information-storing device＜the variable region classified information in.
Deletion unit, variable region: this unit is used to delete the variable region that the user selects.After deleted the variable region of the user being selected when deletion unit, variable region, the interface of deletion cell call variable region, variable region information-storing device was deleted the information of the variable region correspondence of deletion from the information-storing device of variable region.
The variable region template(-let) is set: this unit is provided with the dimension type of selected variable region according to user's setting.When storing, budget sample table definition device calls the interface of variable region information-storing device, with variable region dimension type be updated to the variable region memory storage＜the variable region classified information in, the dimension type-restriction scope of the dimension values that can select of variable region.
3. transmitting apparatus 104 under the budget sample table
This device is issued to budget main bodys at different levels with budget sample table, generates the budget table of budget main bodys at different levels.The budget main body that this device allows the user to select budget sample table and need be issued to, the budget sample table of user's selection is issued to the budget main body of appointment, generate the budget table of each main body, budget table is stored on the server, and when budget sample table issues, the variable region information of budget sample table is written in the variable region information-storing device of budget table.
4. the budget table scheduling apparatus 106
This device can be the plug-in unit of expansion at the Excel end, can comprise following unit:
Expansion unit, variable region 1062: this unit is used to expand the variable region, newly-increased or deletion variable row/row.The instruction of accepting according to variable region type and budget table scheduling apparatus is expanded accordingly the variable region and is revised.For example, if the variable region type is the row variable region, by increasing the variable row instruction, the row of choosing is set to the variable region, by the instruction of deletion variable row, the row of choosing is deleted from the variable region.In when storage, according to the variable region title information such as " initial row number/row number " of variable region, " variable region line number/columns " are written to budget table the variable region information-storing device＜the variable region classified information in.
Dimension values binding unit 1064: this unit is used to design the variable region gauge outfit, the dimension values of binding variable region gauge outfit.This unit is according to the variable region dimension type of the affiliated variable region of selected excel cell, all dimension values under the dimension type of variable region filtered out allow the user select, and the dimension values that the user is selected is tied on the excel cell of choosing.In when storage, with the dimension values binding information of cell be written to budget table variable region information-storing device＜variable region gauge outfit information in.
Estimating data cell 1066: the budget data of user in the typing of data field, variable region accepted in this unit, the estimating data.When storing, with the budget data of data field, variable region excel cell be written to budget table variable region memory storage＜variable region budget data information in.
5. budget table gathers device 108
This device is used for subordinate's budget table and reports to the higher level, gathers subordinate's variable region budget and counts on the counting in advance of higher level's budget table variable region correspondence.This device takes method from bottom to top that the variable region budget data of main body budget tables at different levels is upwards gathered.This device is receiving after reporting of subordinate's budget table gather instruction, all cells of the traversal excel of subordinate budget table variable region, " variable region cell dimension values combinational code " at each cell, according to set combinational code matched rule, remove to search in the budget table of higher level's budget main body correspondence the cell of combinational code coupling therewith, after finding corresponding higher level's budget object, the budget data of subordinate's variable region cell correspondence is added to the budget data of higher level's cell.
Variable region cell dimension values combinational code computing method are: be that the center is according to left, upward to all gauge outfit dimension values of searching the cell correspondence with the cell, these dimension values are connected according to the set dimension type order of connection, formed the dimension values combinational code of cell, the dimension values combinational code is unique in whole budgeting system, has uniquely determined one and count in advance (can finish computation process by the dimension values combinational code computing unit 1068 of budget table scheduling apparatus 106).
The specific algorithm that budget table gathers is:
1) scans data field, the variable region cell of higher level's budget main body Excel budget table one by one, obtain the dimension combinational code and the budget data of higher level variable region cell, owing to adopt the method that gathers budget data from bottom to top, higher level's budget table variable region cell budget data is directly zero clearing herein.
2) scan data field, the variable region cell of the budget main body Excel of each subordinate budget table one by one, obtain the dimension values combinational code and the budget data of subordinate's variable region cell.
3) travel through the budget main body Excel of each subordinate budget table variable region cell dimension values combinational code, itself and higher level's budget main body Excel budget table variable region cell dimension values combinational code are mated, if the match is successful, then subordinate's budget data is added to higher level's budget data.Concrete matched rule is: higher level's combinational code is all removed the corresponding part of budget main body with the subordinate combinational code, if remaining part is equal fully, the match is successful in explanation so.
4) finish the budget data that gathers the data field, variable region from bottom to top.
Continue below in conjunction with Fig. 5 technical scheme of the present invention to be described, Fig. 5 shows the process synoptic diagram according to budget sample table definition and budget table establishment in the budget data aggregation system of the embodiment of the invention.
1. hold the plug-in unit picture at the Excel that is providing, allow the user to define the variable region in the budget sample table design phase, the dimension binding rule of variable region is set, the variable region information of budget sample table is write budget sample table variable region memory storage (variable region information-storing device 110).
2. the budget sample table that will define the variable region is issued to budget main bodys at different levels, produces the Excel budget table of budget main bodys at different levels, and budget table comprises the variable region that budget sample table definition goes out, and gives the user with the message feedback that issues success.
3. allow the user that the budget table that comprises the variable region of the budget main body that is issued to user's correspondence is carried out the design and the establishment of variable region.The user can carry out the binding of dimension values to the variable region gauge outfit, and budget data is carried out in the data field, variable region work out, the variable region information of design and establishment is saved to budget table variable region device (variable region information-storing device 110), gives the user message and the successful message feedback of budget table variable region establishment that the variable region design finishes.So just finished the compilation process of budget data.
4. when the user preserves subordinate's budget table, according to above-mentioned budget data method of summary to the budget data of the subordinate budget table variable region aggregation process that makes progress.So just finished the aggregation process of budget data.
Realized that by technique scheme the user can define the variable region flexibly when budget sample table designs, use Excel to carry out the design and the establishment of budget table variable region easily, after working out, submit budget data to server by preserving budget table, and adopt method from bottom to top to gather subordinate's budget table variable region budget data, reaching customer data gathers automatically, satisfied user's demand, simplified user's operation, and improved the work efficiency of budget sample table design with budget compilation.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the budget data aggregation system of an Excel budget table is characterized in that, comprising:
Budget sample table definition device, be used to define budget sample table the variable region information and described budget sample table is sent to transmitting apparatus under the budget sample table;
Transmitting apparatus under the described budget sample table is used to the budget main body of selecting described budget sample table to issue, and generates corresponding budget table, and described budget table is sent to corresponding budget table scheduling apparatus;
Described budget table scheduling apparatus is used for budget data is worked out and preserved in the described variable region of described budget table, the described budget table after the establishment is sent to budget table gathers device;
Described budget table gathers device, from bottom to top the budget data of described budget table is gathered according to the class of described budget table order.
2. budget data aggregation system according to claim 1, it is characterized in that, also comprise: the variable region information-storing device, be used to store the information of the variable region of described budget table, the information of described variable region comprises variable region type, variable region structure and/or variable region budget data, described variable region type comprises capable variable region and row variable region, and described variable region structure comprises variable region classified information, variable region gauge outfit information and variable region budget data information.
3. budget data aggregation system according to claim 2, it is characterized in that, described variable region classified information is used to write down the scope and the type information of the described variable region of described budget table, described variable region gauge outfit information is used to write down the budget dimensional information of variable region gauge outfit, and described variable region budget data information is used for writing down the budget data information of each Excel cell correspondence of data field, variable region.
4. budget data aggregation system according to claim 3, it is characterized in that, the structure of described variable region classified information comprises the dimension type of described variable region type, variable region title, variable region initial row number/row number, variable region line number/columns and variable region, the structure of described variable region gauge outfit information comprises affiliated variable region, cell name, dimension values, row number and row number, and the structure of described variable region budget data comprises affiliated variable region, cell name, variable region cell dimension values combinational code and budget data.
5. budget data aggregation system according to claim 1, it is characterized in that, described budget sample table definition device comprises: definition unit, variable region, be used to select the presumptive area of Excel and it is defined as the variable region, the described variable region type of described variable region is set, generates the described variable region title that is used for the described variable region of unique identification automatically;
Delete the unit, variable region, be used to delete the described variable region of definition;
The variable region template(-let) is set, is used to be provided with the dimension type of the described variable region of selection.
6. budget data aggregation system according to claim 1 is characterized in that, described budget table scheduling apparatus comprises: expansion unit, variable region is used for the variable region of described budget table is increased or deleting variable row/row according to described variable region type;
Dimension values binding unit is used for the variable region gauge outfit according to the described budget table of dimension type design of described variable region, filters out all dimension values under the described dimension type of described variable region, and the described dimension values of selecting is tied to the cell of choosing;
The estimating data cell is used to be received in the budget data of described variable region data field typing, works out described budget data.
7. budget data aggregation system according to claim 6, it is characterized in that, described budget table scheduling apparatus also comprises: dimension values combinational code computing unit, with the described cell of described variable region is the center according to direction left and upward to the dimension values of all gauge outfits of the described cell correspondence that finds described variable region, the order of connection according to described dimension type connects described dimension values, generate the described dimension values combinational code of the described cell of described variable region, the described budget data that described dimension values combinational code is corresponding unique.
8. according to each described budget data aggregation system in the claim 1 to 7, it is characterized in that, described budget table gathers the budget table of device reception from described budget table scheduling apparatus, the cell of each described variable region of traversal described budget table of subordinate and the described budget table of higher level, dimension values combinational code and combinational code matched rule according to the cell of described variable region, find the cell with the described variable region of the described budget table of subordinate of the cell coupling of the described variable region of the described budget table of higher level, the described budget data of the cell correspondence of the described variable region of subordinate of coupling is added to the described budget data of cell of the described variable region of higher level of coupling.
9. budget data aggregation system according to claim 8, it is characterized in that, described budget table gathers device and comprises: first scanning element, be used to scan the cell of the described variable region of the described budget table of higher level, obtain the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region, with described budget data zero clearing;
Second scanning element is used to scan the cell of the described variable region of the described budget table of subordinate, obtains the described dimension values combinational code and the corresponding described budget data of the described cell of described variable region;
Gather the unit, the described dimension values combinational code that the cell of the described variable region of the described budget table of higher level that the described dimension values combinational code of the cell correspondence of the described variable region of the described budget table of subordinate that described second scanning element is obtained and described first scanning element are obtained is corresponding mates according to described combinational code matched rule, if the match is successful, then the described budget data of the cell correspondence of the described variable region of the described budget table of subordinate is added to the described budget data of cell correspondence of the described variable region of the described budget table of higher level.
10. budget data aggregation system according to claim 9, it is characterized in that, described combinational code matched rule is for after all removing the corresponding part of the corresponding described budget main body of described budget table in the described dimension values combinational code of the described budget table correspondence of the higher level described dimension values combinational code corresponding with subordinate described budget table, whether the described dimension values combinational code combinational code that the described dimension values combinational code combinational code of judging the described budget table correspondence of remaining higher level and remaining subordinate described budget table are corresponding is identical, if judgement is identical, then the described dimension values combinational code that the described budget table of the described dimension values combinational code of the described budget table correspondence of higher level and subordinate is corresponding mates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110177444 CN102270226B (en) | 2011-06-28 | 2011-06-28 | Budget data summarization system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110177444 CN102270226B (en) | 2011-06-28 | 2011-06-28 | Budget data summarization system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102270226A true CN102270226A (en) | 2011-12-07 |
| CN102270226B CN102270226B (en) | 2013-03-27 |
Family
ID=45052531
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110177444 Active CN102270226B (en) | 2011-06-28 | 2011-06-28 | Budget data summarization system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102270226B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103729404A (en) * | 2013-12-05 | 2014-04-16 | 金蝶软件（中国）有限公司 | Budget data processing method and system |
| CN104408057A (en) * | 2014-10-29 | 2015-03-11 | 中国建设银行股份有限公司 | Data summarization method and device |
| CN105938589A (en) * | 2015-12-18 | 2016-09-14 | 天津威腾软件技术有限公司 | System for managing internal information of company conveniently |
| CN106547841A (en) * | 2016-10-14 | 2017-03-29 | 西安工程大学 | A kind of data automatic switching method of Excel XML mappings |
| CN106681977A (en) * | 2017-02-20 | 2017-05-17 | 济南浪潮高新科技投资发展有限公司 | Report editing method and device |
| CN107491241A (en) * | 2017-08-24 | 2017-12-19 | 温州大学瓯江学院 | A kind of building fund budgeting system |
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN115586888A (en) * | 2022-10-08 | 2023-01-10 | 广州市玄武无线科技股份有限公司 | Data management method and system for configured budget |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026393A1 (en) * | 2000-02-29 | 2002-02-28 | Mattson Anna J. | Budget information, analysis, and projection system and method |
| CN1510620A (en) * | 2002-12-25 | 2004-07-07 | 鸿富锦精密工业（深圳）有限公司 | Budget and financial analyzing system and method |
| CN101576979A (en) * | 2009-06-22 | 2009-11-11 | 用友软件股份有限公司 | Method and device for ensuring data consistency in budgeting process |
-
2011
- 2011-06-28 CN CN 201110177444 patent/CN102270226B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026393A1 (en) * | 2000-02-29 | 2002-02-28 | Mattson Anna J. | Budget information, analysis, and projection system and method |
| CN1510620A (en) * | 2002-12-25 | 2004-07-07 | 鸿富锦精密工业（深圳）有限公司 | Budget and financial analyzing system and method |
| CN101576979A (en) * | 2009-06-22 | 2009-11-11 | 用友软件股份有限公司 | Method and device for ensuring data consistency in budgeting process |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103729404A (en) * | 2013-12-05 | 2014-04-16 | 金蝶软件（中国）有限公司 | Budget data processing method and system |
| CN103729404B (en) * | 2013-12-05 | 2018-01-12 | 金蝶软件（中国）有限公司 | Budget data processing method and system |
| CN104408057A (en) * | 2014-10-29 | 2015-03-11 | 中国建设银行股份有限公司 | Data summarization method and device |
| CN104408057B (en) * | 2014-10-29 | 2019-01-29 | 中国建设银行股份有限公司 | A kind of method and device of data summarization |
| CN105938589A (en) * | 2015-12-18 | 2016-09-14 | 天津威腾软件技术有限公司 | System for managing internal information of company conveniently |
| CN106547841A (en) * | 2016-10-14 | 2017-03-29 | 西安工程大学 | A kind of data automatic switching method of Excel XML mappings |
| CN106681977A (en) * | 2017-02-20 | 2017-05-17 | 济南浪潮高新科技投资发展有限公司 | Report editing method and device |
| CN106681977B (en) * | 2017-02-20 | 2020-04-28 | 浪潮通用软件有限公司 | Report editing method and device |
| CN107491241A (en) * | 2017-08-24 | 2017-12-19 | 温州大学瓯江学院 | A kind of building fund budgeting system |
| CN108549624A (en) * | 2018-04-18 | 2018-09-18 | 宁夏通信规划设计院（有限责任公司） | Engineeing design for communication budget and illustrate text automation generate system and method |
| CN115586888A (en) * | 2022-10-08 | 2023-01-10 | 广州市玄武无线科技股份有限公司 | Data management method and system for configured budget |
| CN115586888B (en) * | 2022-10-08 | 2024-04-16 | 广州市玄武无线科技股份有限公司 | Data management method and system for configuring budget |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102270226B (en) | 2013-03-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102270226B (en) | Budget data summarization system | |
| CN100458773C (en) | Information processing apparatus, method, storage medium and program | |
| CN1232913C (en) | Computerized system and method for optimally controlling storage and transfer of computer programs on a computer network | |
| CN104361018B (en) | Electronic archives information reorganization method and device | |
| CN103559323B (en) | Database implementation method | |
| CN102426582B (en) | Data manipulation management devices and data manipulation management method | |
| CN101971204A (en) | Arranging graphic objects on a page with relative position based control | |
| CN102810094A (en) | Report generation method and device | |
| CN101430761B (en) | Form data extracting apparatus, and form data extracting method | |
| CN102799690A (en) | Method for verifying page input by using database technology | |
| CN102693317A (en) | Method and device for data mining process generating | |
| CN104142930A (en) | Universal Delta data loading technology | |
| CN102844774B (en) | The control method of webpage and computer system | |
| CN105989013A (en) | Method and device for removing character watermarks | |
| KR20100110205A (en) | System for on line magazine service and method for publishing and distributing electronic documents using the same | |
| Cook | Streamlining office procedures: An analysis using the information control net model | |
| CN103678682A (en) | Mass grid data processing and management method based on abstract templates | |
| CN101241576A (en) | Method, system and program for providing printed matter | |
| CN106021488A (en) | Key value database management method and apparatus | |
| JP5086674B2 (en) | Report creation method, report creation device, and report creation program | |
| CN101815082A (en) | External information integrated device and service system | |
| JP4946095B2 (en) | Information processing method and apparatus related to special green space conservation area | |
| Eom | The development of decision support systems research: A bibliometrical approach | |
| JP2002169802A (en) | Electronic delivery data generation support system and recording medium in public works support integrated information system | |
| Jain et al. | Establishing State of the Art Unified Technical Data Center to Harness the Power of Legacy Data for Future Opportunities-An E&P Success Story in Sharjah, UAE |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| C56 | Change in the name or address of the patentee | ||
| CP03 | Change of name, title or address |
Address after: 100094 Haidian District North Road, Beijing, No. 68 Patentee after: Yonyou Network Technology Co., Ltd. Address before: 100094 Beijing city Haidian District North Road No. 68, UFIDA Software Park Patentee before: UFIDA Software Co., Ltd. |